| blocked_pid | blocked_user | blocking_statement | blocking_duration | blocking_pid | blocking_user | blocked_statement | blocked_duration |
|---|---|---|---|---|---|---|---|
| 119560 | postgres | <IDLE> in transaction | 00:00:48.089 | 118572 | postgres | update JOURNAL_LOCAL_REVISIONS set REVISION_ID = $1 where JOURNAL_ID = $2 | 00:00:48.069 |
1 rows with 8 columns retrieved.
select bl.pid as blocked_pid, a.usename as blocked_user,
ka.current_query as blocking_statement, now() - ka.query_start as blocking_duration,
kl.pid as blocking_pid, ka.usename as blocking_user, a.current_query as blocked_statement,
now() - a.query_start as blocked_duration
from pg_catalog.pg_locks bl
join pg_catalog.pg_stat_activity a
on bl.pid = a.procpid
join pg_catalog.pg_locks kl
join pg_catalog.pg_stat_activity ka
on kl.pid = ka.procpid
on bl.transactionid = kl.transactionid and bl.pid != kl.pid
where not bl.granted;