lockquery.sql

select blocking_sa.query, pg_class.relname
from pg_stat_activity as blocking_sa
join pg_locks as blocking_locks on blocking_sa.pid = blocking_locks.pid
join pg_class on blocking_locks.relation = pg_class.oid
join pg_locks as blocked_locks on blocked_locks.relation = blocking_locks.relation
join pg_stat_activity as blocked_sa on blocked_locks.pid = blocked_sa.pid
where blocking_locks.granted is true and blocked_sa.waiting is true and blocking_sa.waiting is false;