I had my ECV on Monday. I had a consultant and a registrar doing the procedure. They went through it all first, told me their statistics (performed 80 last year, 50% success but closer to 70% for 2nd of subsequent pregnancies).
I was on the monitor for about half an hour before hand to ensure the baby was okay, took my blood pressure, temperature etc. They then scanned me to check baby was still breech.
They kept the CTG (baby heartbeat monitor) on my tummy the whole time to keep an eye on the babies heartbeat. Firstly they try to push the baby's bum out of the pelvis. It was extremely uncomfortable, but more from the point of my skin stretching - felt like a chinese burn. I was surprised how much they actually pushed - really really gave it some welly!! They then gave me an injection to relax my uterus - this wasn't nice. It makes your heart beat very fast and feel very odd. Then tried again, he then managed to get the baby half way round by pushing the head as well as the bum but unfortunately the heartbeat dropped so they stopped - baby's bum went straight back into pelvis :( They then left it a while until the heartbeat picked back up and then the consultant took over to try again. Unfortunately although they managed to get the bum out a couple more times baby didn't want to turn.
They were constantly checking with the scanner, CTG and asked me every minute if I was okay.
So, it was painful but like a chinese burn not the actual pushing, the injection wasn't a nice feeling, but they constantly kept an eye on everything. They had a hand on my leg constantly which I think was to sense how I was as well as the baby. But I was surprised how much they actually pushed - more than you would think.
I wasn't scared at any point - I had a lot of trust in the consultant which I think is important, but he has a very high reputation.
A success story - my friend had an ECV 2 years ago with her first. She said it was uncomfortable but not painful and her little boy turned very quickly so I suppose if they turn then it might be less painful.
Hope that helps - ask if you have any questions.