Question : postgres active connections
Answered by : hiren-reshamwala
SELECT * FROM pg_stat_activity;
OR
SELECT datid, datname, pid, usename, state, query FROM pg_stat_activity;
Source : | Last Update : Fri, 21 May 21
Question : psql connections
Answered by : magnificent-markhor-7umecig90oye
SELECT * FROM pg_stat_activity;
Source : https://stackoverflow.com/questions/27435839/how-to-list-active-connections-on-postgresql | Last Update : Mon, 24 Aug 20