It suggests that the person was worried and held their breath out of fear. When the feared event did not occur, the person lets out a "sigh of relief." In other words, an expulsion of the breath they had been holding.