I'm investigating an issue with DB connections being left open indefinitely, causing problems on the DB server. How do I see currently open connections to a PostgreSQL server, particularly those using a specific database? Ideally I'd like to see what command is executing there as well. Basically, I'm looking for something equivalent to the "Current Activity" view in MSSQL.
Postgresql – How to see active connections and “current activity” in PostgreSQL 8.4
postgresql
Best Answer
OK, got it from someone else. This query should do the trick: