Lines Matching refs:blocking
26 blocking.pid,
29 blocking.mode,
36 blocking.locktype,
39 blocking.relation::regclass AS relation,
42 pg_locks AS blocking
49 NOT granted) AS blocked ON (blocking.transactionid = blocked.transactionid)
50 JOIN pg_stat_activity ON (blocking.pid = pg_stat_activity.procpid)
52 blocking.granted
59 blocking.pid,
62 blocking.mode,
69 blocking.locktype,
72 blocking.relation::regclass AS relation,
75 pg_locks AS blocking
82 NOT granted) AS blocked ON (blocking.virtualxid = blocked.virtualxid)
83 JOIN pg_stat_activity ON (blocking.pid = pg_stat_activity.procpid)
85 blocking.granted
92 blocking.pid,
95 blocking.mode,
102 blocking.locktype,
105 blocking.relation::regclass AS relation,
108 pg_locks AS blocking
119 … ) AS blocked ON (blocking.database = blocked.database AND blocking.relation = blocked.relation)
120 JOIN pg_stat_activity ON (blocking.pid = pg_stat_activity.procpid)
122 blocking.granted