Skip to content

Instantly share code, notes, and snippets.

@Haelle

Haelle/postgres_blocking_queries.sql

Created August 3, 2020 08:25
Show Gist options
  • Save Haelle/b6a15ad23a37bdf51e82aa2f97bdd80b to your computer and use it in GitHub Desktop.
Save Haelle/b6a15ad23a37bdf51e82aa2f97bdd80b to your computer and use it in GitHub Desktop.
Download ZIP
See Postgres blocking queries
Raw
postgres_blocking_queries.sql
select pid, usename, pg_blocking_pids(pid) as blocked_by, query as blocked_query
from pg_stat_activity
where cardinality(pg_blocking_pids(pid)) > 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment