Postgres Lock Contention: Reading pg_locks to Find Blocked Queries
Diagnose Postgres lock contention with pg_locks, pg_stat_activity and pg_blocking_pids(), trace blocked queries to the root holder, and prevent repeats.
20 min read
Tag
Diagnose Postgres lock contention with pg_locks, pg_stat_activity and pg_blocking_pids(), trace blocked queries to the root holder, and prevent repeats.
20 min read