Visualizing Lock Chains: Find the Root Blocker in Seconds

Visualizing Lock Chains: Find the Root Blocker in Seconds You have probably seen the advice a hundred times: "just check pg_locks." But pg_locks gives you a flat table of granted and waiting locks with no indication of which sessions are blocking whi...