You know things are bad when you wake up at 3am to do a little early morning coding and your Python Postgres query won't stop running after 10 minutes and you can't simply ^C your way out of it and you have to actually log into Postgres and run a cancel_backend command.
