Hysteroscopy

Hello. Was wondering if anyone on here has ever had a hysteroscopy. I have been TTC for 9 months after being on BC for 11 years. I'm having abnormal bleeding between periods, my doc did an US in feb and everything looked good. She also drew blood for infertility but everything came back normal so she decided I should get a scope done. I'm having it done in the office and I'm worried about how painful it will be. Wondering if anyone has any experience with this. Thanks!