analyze_wait_events
Identify PostgreSQL performance bottlenecks by analyzing wait events for locks, I/O, CPU usage, client communication, and extension delays to detect resource contention and saturation issues.
Instructions
Analyze PostgreSQL wait events to identify bottlenecks.
Wait events indicate what processes are waiting for:
Lock: Waiting for locks on tables/rows
IO: Waiting for disk I/O
CPU: Waiting for CPU time
Client: Waiting for client communication
Extension: Waiting in extension code
This helps identify:
I/O bottlenecks
Lock contention patterns
Resource saturation
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| active_only | No | Only include active (running) queries |
Input Schema (JSON Schema)
{
"properties": {
"active_only": {
"default": true,
"description": "Only include active (running) queries",
"type": "boolean"
}
},
"required": [],
"type": "object"
}