Stewie sleeps for as long as I do. Sometimes as long as 12-14 hours on the weekends. I'd say that he is cranky/groggy if he doesn't get at least 8 hours. Sometimes if the alarm goes off on work days and he's still tired, he'll put his paws over his eyes and huff and puff if I pick him up.
