You do need a level of wakefulness and attention to tackle the more interesting challenges, and some of that wakefulness gets consumed. There's a reason there are many coffee references in programming.
I doubt that it is more tiring than typical other types of work.