It really varies, and can depend on your body
I had to have one in January, and honestly it was the worst pain I have ever had
However, I have a backwards facing cervix, which refuses to dilate (even with strongest induction drugs - 1 EMCS, 1 ELCS) so believe this was the issue
It will also depend on the time taken - it can be quite quick, 10-15 minutes, but it depends on what they are checking for; mine was an hour. I wish I had been told about the water pipe they put inside your vagina to keep it flushed and clean so they can see better. I did know about the speculum and have never had an issue with smear tests, that part was fine, but it was the opening of the cervix that hurt. The doctor did say it was much more difficult than usual to open it. Part way through the procedure they did inject local anaesthetic, but then they had to do a biopsy and I could feel that as it was beyond where it reached to - doc told me to hold my breath for 20 seconds and that he was really sorry
I was told beforehand to take whatever I usually would for period pain so had paracetamol - it didn't even touch the pain. The medical staff were lovely, tried talking me through it and doing breathing exercises, but I spent the last 20 mins, including the biopsy part with tears just streaming down my face
I was very shaky when they finished. They told me not to look down (because blood, water & tissue will come out of you) and then I got dressed and put a pad on. I had to stay seated for 20 mins and have tea and a biscuit before they would discharge me. Afterwards I had codeine and ibuprofen then 2 hours later when it had made no difference I hit the Chardonnay (which finally took the edge off)
I was in bed with difficulty moving for 36 hours
I appreciate that my body was being particularly awkward, and others have been fine, but I personally would never have another one without a GA
Was more pissed off that the reason I had to have it in the first place was that I was prescribed the wrong HRT and my womb lining had thickened (found after an internal ultrasound - which I was absolutely fine during, no pain at all)
Happily, the biopsy came back negative so that's a good ending at least!