It's not painful at all. Aside from carbon dioxide, your body has no ability to tell the difference between an inert gas and oxygen. You lose consciousness before you realize what's happening. That's why sewer workers carry gas detectors on them.