PostgreSQL Blocking Queries: Find the Root Blocker with pg_locks
Learn to trace PostgreSQL blocking queries to the root blocker with pg_stat_activity, pg_blocking_pids() and pg_locks, then prevent them with lock_timeout.
13 min read
Tag
Tag
Learn to trace PostgreSQL blocking queries to the root blocker with pg_stat_activity, pg_blocking_pids() and pg_locks, then prevent them with lock_timeout.
13 min read