Has anyone here had a hysteroscopy?

Has anyone here had a hysteroscopy done recently? My husband and I have been TTC #2 for almost a year and my doctor mentioned that it might be my tubes blocked from my c section. I have no pain and I have regular periods but we just haven’t been able to get pregnant yet.

From anyone who has had this done -

Was it painful?

How expensive was it?

Did you get pregnant shortly after?

I’m very nervous abt having it done for financial reasons and worrying abt how painful it might be but we want to give our little man a sibling so badly!