get_top_queries
Identify slowest or most resource-intensive queries from pg_stat_statements to pinpoint performance bottlenecks by total time, mean time, or resource usage.
Instructions
Reports the slowest or most resource-intensive queries using data from the 'pg_stat_statements' extension.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Number of queries to return when ranking based on mean_time or total_time | |
| sort_by | No | Ranking criteria: 'total_time' for total execution time or 'mean_time' for mean execution time per call, or 'resources' for resource-intensive queries | resources |
| database | No | Optional. Alias of the configured database to query. Omit it when the server has only one database configured. When several are configured this parameter is required - call list_databases first to learn the valid aliases. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |