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