get_active_queries
Monitor active PostgreSQL queries to identify long-running operations, detect lock contention, and troubleshoot stuck transactions for database performance optimization.
Instructions
Get information about currently active queries and connections.
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
| 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 |
Input Schema (JSON Schema)
{
"properties": {
"database": {
"description": "Filter by specific database",
"type": "string"
},
"include_idle": {
"default": false,
"description": "Include idle connections",
"type": "boolean"
},
"include_system": {
"default": false,
"description": "Include system/background processes",
"type": "boolean"
},
"min_duration_seconds": {
"default": 0,
"description": "Minimum query duration in seconds to include",
"type": "integer"
}
},
"required": [],
"type": "object"
}