What exhaust is this?

The previous owner had removed this from the car as it was apparently loud. I'm debating putting it back on as it's a third car so too fussed as long as its not deafening..

Anyone know what it is and if it will indeed be too loud?

Cheers