In my experience the type of exercise matters a lot: after my average cycling training (50-100km) my legs are hurting but I feel more energetic and awake.
Mostly it results in staying up later than normal.
Without exercise, I go to bed tired at 11 and can't sleep until 3 :)