Cheat Sheet logoCheat Sheet Today
PostgreSQL Administration Cheat Sheet/Inspect locks

Inspect lock acquisition and contention.

Back to sheetBrowse commands
Sign in to save
Section: Monitoring and Statistics

Inspect locks

sql
sql
SELECT pid, relation::regclass, mode, granted
FROM pg_locks
ORDER BY relation, mode;
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Monitoring and Statistics
Show active sessions
Inspect current sessions and queries.
OpenIn sheetsqlsame section
Find unused indexes
Review index scan counts when cleaning up indexes.
OpenIn sheetsqlsame section
Cancel a query
Cancel a running query without terminating the session.
OpenIn sheetsqlsame section
Terminate session
Force a backend to disconnect.
OpenIn sheetsqlsame section
Show database size
Measure one database's size.
OpenIn sheetsqlsame section
Show table and indexes size
Measure one relation including indexes and TOAST.
OpenIn sheetsqlsame section