get_active_queries
Monitor active PostgreSQL queries to identify long-running operations, detect lock contention, and analyze query patterns for performance optimization.
Instructions
Get information about currently active queries and connections.
Note: By default, this tool excludes system/background processes and focuses on client backend queries to help you analyze your application's query patterns. System catalog queries are filtered out unless explicitly requested.
Shows:
All active queries and their duration
Idle transactions that may be holding locks
Blocked queries waiting for locks
Connection state breakdown
Useful for:
Identifying long-running queries
Finding queries that might need optimization
Detecting stuck transactions
Troubleshooting lock contention
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| min_duration_seconds | No | Minimum query duration in seconds to include | |
| include_idle | No | Include idle connections | |
| include_system | No | Include system/background processes | |
| database | No | Filter by specific database |