Advertisement
Guest User

Untitled

a guest
Oct 14th, 2019
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. ## Find if a query is blocked by another
  2. ```sql
  3. select pid,
  4. usename,
  5. pg_blocking_pids(pid) as blocked_by,
  6. query as blocked_query
  7. from pg_stat_activity
  8. where cardinality(pg_blocking_pids(pid)) > 0;
  9. ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement