Skip to content

Instantly share code, notes, and snippets.

@Whitespace

Whitespace/long_running_transactions.sql

Created April 15, 2015 19:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Whitespace/9d60a81c5739fa0caa18 to your computer and use it in GitHub Desktop.
Save Whitespace/9d60a81c5739fa0caa18 to your computer and use it in GitHub Desktop.
Download ZIP
Debugging Postgres
Raw
long_running_transactions.sql
SELECT userid, dbid, left(query, 100), total_time, rows FROM pg_stat_statements WHERE total_time >= 1000 ORDER BY total_time DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment