/* 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;