How badly does it hurt to have a catheter inserted?

I have to see a urologist coming up for chronic uti's and I imagine they'll be exploring my urinary tract whether it be with a cath or lord knows what else. For those who have experienced something like that, how was it?