/*
Show all connections to the database
*/
SELECT
datname, pid, usename, client_addr, client_port,
query_start, state_change, state, query
FROM
pg_stat_activity
WHERE
datname = '<database name HERE>'
ORDER BY
state_change DESC;
/*
Show all connections to the database
*/
SELECT
datname, pid, usename, client_addr, client_port,
query_start, state_change, state, query
FROM
pg_stat_activity
WHERE
datname = '<database name HERE>'
ORDER BY
state_change DESC;