analyze_locks
Identify blocking chains, long-running queries, and idle-in-transaction sessions causing lock contention in PostgreSQL.
Instructions
Detect lock contention: blocking chains, long-running queries, idle-in-transaction sessions.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Database alias to query. Omit to use the primary database. |