The command of Taraaweeh brings about a change in the habit of sleeping, and this changing of habit is difficult on the nafs. This is precisely Mujaahidah . In other words, they perform Salaat during the night. However the trend of the aayat comprehends all forms of Ibaadat, hence it applies to Du'a and Zikr as well. Furthermore, beside the Deeni benefits in sleeping less, the physical health also benefits.
Excessive sleep is detrimental to the physical health as well.
It reduces or stunts the capacity of contemplation in a person. This in turn brings . A person who is given to excessive sleeping is never able to be punctual in time. Nowadays this moderation means sleeping at least six or seven hours, If sleep becomes over-bearing then one should not ward it off. The wazeefah should be completed later.