So anxious 😟 about getting HSG done

My dr wants to have me do a HSG because I’ve had multiple losses. I’m so scared especially because my coworker told me she legit passed out from the pain & it was worse than labor for her!

If it’s that painful why don’t they sedate for it!?