It depends on the type of egg collection you have: Awake (with pain killers and gas and air), sedation (mostly no realisation of what's going on) or asleep (general anaesthetic so you wont have a clue).
There is a detailed thread on here with ladies experience of egg collection awake or asleep which you can find in the Useful Threads sticky post.
Good luck