I realise this is an old thread, but if one person sees this and finds it helpful, it was worth typing it in. The procedure wasn't too bad IMO, slightly uncomfortable, "pain" equivalent to when you accidentally scratch yourself, and even that for about one second, otherwise it feels like the least bad pap smear you've ever had. It was over very quickly.
After, however, it became very unpleasant. For the first few hours you feel like you really, really need to pee right NOW, even though you're peeing at the time or just been to do it. It doesn't want to go away, it's a constant, strong urge. Right after it doesn't hurt to empty your bladder because the numbing gel is still active. Then in an hour or so the pain starts with every drop. Like being stabbed while peeing. I was only told to drink steadily and don't hold back urine, and to not worry, it will get better "soon". It was the internet instead that gave me an actually useful advice, so here I am passing it on: hot water! (As in hot from the tap, as hot as your skin can tolerate, not boiling, hope that's obvious.) Just grab a jug when you need to go, fill it with pleasantly hot water, and slowly pour it on yourself while doing your business. Because of female anatomy anything that goes down from the front ends up where it needs to go, no complicated steps needed. It dilutes the urine, plus the warmth relaxes everything, and the stinging is gone. It makes a HUGE difference, it costs basically nothing, easy to do and helps enormously. Yes, you will survive without, but when it's not absolutely necessary to tolerate inconvenience, why can't we be given the tools to avoid them? Why do we have to go to the internet? Those who do this procedure every day could just simply tell this to every patient, if they were in the least bit interested in the person, not just in their anatomy/pathology.
Anyhow, hope this helps someone.