PG死锁检测

PostgreSQL中锁机制及其原理

PostgreSQL版本>9.6, 可以使用更为精简的查询

select pid, query_start,
       usename, 
       pg_blocking_pids(pid) as blocked_by, 
       query as blocked_query
from pg_stat_activity
where cardinality(pg_blocking_pids(pid)) > 0;