Explain a PostgreSQL lock mode
explain_lockExplain PostgreSQL lock modes. Provide what each lock blocks and which operations acquire it, helping prevent dangerous SQL migrations.
Instructions
Given a lock mode name (e.g. 'ACCESS EXCLUSIVE') or a fragment of an operation, explain what it blocks and which operations acquire it.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | A lock mode name or operation fragment, e.g. 'ACCESS EXCLUSIVE' or 'create index'. |