pg_manage_query
Analyze PostgreSQL query performance by generating EXPLAIN plans, identifying slow queries, retrieving statistics, and resetting monitoring data.
Instructions
Manage PostgreSQL query analysis and performance - operation="explain" for EXPLAIN plans, operation="get_slow_queries" for slow query analysis, operation="get_stats" for query statistics, operation="reset_stats" for clearing statistics
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| operation | Yes | Operation: explain (EXPLAIN/EXPLAIN ANALYZE query), get_slow_queries (find slow queries from pg_stat_statements), get_stats (query statistics with cache hit ratios), reset_stats (reset pg_stat_statements) | |
| connectionString | No | ||
| query | No | SQL query to explain (required for explain operation) | |
| analyze | No | Use EXPLAIN ANALYZE - actually executes the query (for explain operation) | |
| buffers | No | Include buffer usage information (for explain operation) | |
| verbose | No | Include verbose output (for explain operation) | |
| costs | No | Include cost estimates (for explain operation) | |
| format | No | Output format (for explain operation) | json |
| limit | No | Number of slow queries to return (for get_slow_queries operation) | |
| minDuration | No | Minimum average duration in milliseconds (for get_slow_queries operation) | |
| orderBy | No | Sort order (for get_slow_queries and get_stats operations) | mean_time |
| includeNormalized | No | Include normalized query text (for get_slow_queries operation) | |
| minCalls | No | Minimum number of calls (for get_stats operation) | |
| queryPattern | No | Filter queries containing this pattern (for get_stats operation) | |
| queryId | No | Specific query ID to reset (for reset_stats operation, resets all if not provided) |