More consumption/loss of power for exhaust tuning

Good evening, to what extent the replacement of the original exhaust system affects the fuel consumption and the performance. If the original system is replaced by e.g. a continuous pipe/empty pots/bulbs etc., does this necessarily increase the consumption? Does the car lose power? Does a car engine need counter pressure as with a 2Tacter ? mfg Jockel