Sex, like exercise, tends to leave my mind alert, so that even though I'm tired I have more trouble getting to sleep. That effect wears off after a while, though; I believe most books say to exercise a couple of hours before bedtime, not immediately before.