/*
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;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter