What have your experiences been with a HSG?

am having an HSG done on friday and I am scared because some women say that it really hurts. Any suggestions? Tell me what it feels like and what I should expect, please. there r possibilities of being pregnant???