Skip to content

Instantly share code, notes, and snippets.

@fhgbaguidi

fhgbaguidi/pg_sql_find_blocking_queries.sql

Created January 24, 2023 10:27
Show Gist options
  • Save fhgbaguidi/57bf0c4f7c391e443e35742ee9d3ff4a to your computer and use it in GitHub Desktop.
Save fhgbaguidi/57bf0c4f7c391e443e35742ee9d3ff4a to your computer and use it in GitHub Desktop.
Download ZIP
Find blocking postgresql queries
Raw
pg_sql_find_blocking_queries.sql
SELECT pid, pg_blocking_pids(pid) AS blocked_by, query AS blocked_query, backend_start
FROM pg_stat_activity
WHERE pg_blocking_pids(pid)::TEXT != '{}';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment