I just asked DH if he was any pain the night of, the next day, the next time he went to the loo. His response was 'i wouldn't have even know I'd had the procedure done'

Don't worry about waking up Hun, they will give you enough of the sedative to knock you out.

As Cheshire said, DH found out straight away that everything was fine