To what extent can the epidural reduce pain?

Does it take the pain from ‘all’ to ‘nothing’, with dead legs and no comprehension of when to push?

Or does it just take it a couple of points down from 10 on the pain scale?

Is there anywhere I can get evidence-based knowledge on this?