HSG-Do they work?

Presley
Hello ladies, 
Has anyone had an HSG?  I've been toying around with the idea.  Is it painful?  Did it help in TTC?