analyze_wait_events
Identify PostgreSQL performance bottlenecks by analyzing wait events for client backend processes, helping detect I/O issues, lock contention, and resource saturation in application queries.
Instructions
Analyze PostgreSQL wait events to identify bottlenecks.
Note: This tool focuses on client backend processes and excludes system background processes to help identify bottlenecks in your application queries.
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 |