For the stun setting, it's probably instantaneous - the target has no time to feel pain.
For kill? Probably depends on who made the weapon. I'm sure Klingon disruptors hurt. And so does the VaronT disruptor - it's specifically made to cause as much pain as possible before killing the victim.