Just the idea of having this done makes me squirm! But when I did have it, they numbed me up with an epidural so I didn't feel anything. I was sore as all get out the next day, though. That took a couple of days to fade.
I didn't have the problem with not being able to urinate, thank goodness. As soon as the epidural wore off, I was fine as far as urination was concerned. It was just a little painful. After all, that area is an exit, not an entrance! I was glad when it was all over and I was back to normal.