Skip to content

Instantly share code, notes, and snippets.

@ValentinTrinque

ValentinTrinque/processlist.sql

Forked from romuald/processlist.sql
Created April 15, 2026 11:57
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ValentinTrinque/0173453164c9bdd970c4547f28fa832b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ValentinTrinque/0173453164c9bdd970c4547f28fa832b to your computer and use it in GitHub Desktop.
Download ZIP
Show PostgreSQL current (running) process list;
Raw
processlist.sql
SELECT user, pid, client_addr, waiting, query, query_start, NOW() - query_start AS elapsed
FROM pg_stat_activity
WHERE query != '<IDLE>'
-- AND EXTRACT(EPOCH FROM (NOW() - query_start)) > 1
ORDER BY elapsed DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment