Debugging postgres: List all connections

Sometimes want a list of all connections to your postgres database. Postgres maintains this list in...