pg blocking queries #psql #db #postgres #sql

sql_blocking_queries

SELECT blocks.pid,
   (select query from pg_stat_activity where pid = blocks.pid) as blocked_query,
   blocks.blocking_pid,
   (select query from pg_stat_activity where pid = blocks.blocking_pid) AS blocking_query
FROM (
    SELECT pid, unnest(pg_blocking_pids(pid)) AS blocking_pid
    FROM pg_locks
    WHERE granted = false
) AS blocks;