petered out

The point at which after performing a penis will no longer support an erection

Honey, that was some good lovin, but I'm petered out.