Oh you poor thing. Don't panic! It shouldn't hurt at all.
Mine was an EMCS (so less time to prepare etc than yours will be) and it still didn't hurt. They'd already given me an epidural as I was trying to labour naturally and when they realised they'd need to do a CS they calmly took me to surgery, calmly topped up my spinal, calmly sorted the room etc. I can clearly remember my DP saying "see, everything must be fine, all these docs are so calm"
The anesthetist spent a long time checking what I could feel by spraying cold water on various parts of my stomach. I could still feel it for what felt like ages so he kept going, spraying, adjusting, etc. I was panicking it was taking too long as I knew DS needed to get out, but he just kept reassuring me and making sure it was right. DP told me later that there was A LOT of eye contact between the anesthetist and surgeon - he got the impression that if the spinal wasn't working quickly enough or it became even more urgent then they'd have given me GA straight away (in fact, he thinks the anesthetist had it in his hand ready to give me if he needed to)
Once they'd sorted that, I honestly felt no pain at all. The anethetist stayed at my head and kept talking to me, checking I was okay, etc. I could feel tugging, but it wasn't uncomfortable, just weird iyswim.
Like an earlier poster said, I probably looked like I was in pain though. That was simply because I was knackered after a long labour, scared about the baby and feeling a bit overwhelmed.
Honestly, no pain and because I knew it was to get my baby out, all of the other stuff didn't matter. Again, for an ELCS rather than an EMCS, this should be even more controlled.
I hope that reassures you 