Lock Management

Inspect PostgreSQL Lock Management Settings Where pg_locks shows the locks held right now, pg_settings shows the rules that govern them: how long a session waits before PostgreSQL checks for a deadlock, how big the shared lock table is, and when a statement gives up waiting. The query below lists the lock settings with …