Anyone have an HSG done and find it INCREDIBLY painful?

I had one done today, took 4 advil prior as advised by doctor. I have quite a high tolerance for pain, but I was completely unprepared for this. I almost flew off the table. The end result was clear tubes, which is great, but geez.... I understand it is not like this for everyone. Hope it works for me!