Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ## Find if a query is blocked by another
- ```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;
- ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement