Skip to content

Instantly share code, notes, and snippets.

@scottmcclung

scottmcclung/processlist.sql

Forked from romuald/processlist.sql
Created July 12, 2024 15:46
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save scottmcclung/8eaa8e2cff865b3ae0f4ac97065b1e35 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save scottmcclung/8eaa8e2cff865b3ae0f4ac97065b1e35 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