I had two epis (though if I ever had a third, I don't want one). It doesn't hurt to get it in, though the numbing medicine they give you isn't pleasant but is only for just a few seconds.
The first one I had seemed to be by an overzealous anesthesiologist who wasn't too happy about being called in at 3am. He did it big...I couldn't walk for hours after the birth. Literally, I fell out of bed because I somehow managed to put my legs to the side to stand up and BOOM.
The second one I could KIND of feel my toes, feet and I could sort of move myself a bit, but not much. You're stuck on your back and when half of you doesn't work....well, it is hard to adjust yourself if you're uncomfortable.
With neither I felt contractions nor did I feel pain. In fact, I couldn't even feel pushing or the baby come out.
The only way you might feel sleepy is if they're hitting you up with other meds before they give you the demerol. If you're induced at night, it is pretty common for them to give you sleeping pills. I was given two ambien, a demerol and an epi.
I pretty much slept through my entire first birth because I was so doped up.
