It does hurt, fairly bad, but only for a couple of seconds a min at the most, only when they are pumping in the dye. It's a very fast prosses and I didn't have any pain afterwards. I don't think the Dr. would give you anything for it. They usally say to take some motrin, maybe 600-800mg about and hour before. Good Luck!
OH that is greeat, Congratulations!! I go to the RE on Thursday. I should be cd5 then, so thats the first thing i am going to beg for (HSG)!!!!! But, I hear it hurts quite a bit. Do drs give you any pain med? Did it hurt for you? Also, were you on any fertility meds the cycle you conceived?
I know it's different from what this said but DH and I had been trying to conceive for a little over a year, I had an HSG which kinda clensed things out and we got pregnant that month with our daugher, the same thing happened to my sister.
A similar theory is that with a clean shoot your body absorbs meds, (and vitamins) better.
I just don't know a whole lot about cleansers though. There's lots of stuff out there to flush your colon but I wander if there's anything that (gently and safely) flushes out other organs, like kidneys, liver, etc...