get_top_queries
Retrieve the slowest PostgreSQL queries using pg_stat_statements to identify performance bottlenecks and optimize database efficiency.
Instructions
Find slowest queries from pg_stat_statements. Requires pg_stat_statements extension enabled. Use this to identify performance bottlenecks.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Number of queries to return (1-100) | |
| orderBy | No | Sort by total time, average time, or call count | total_time |
| minCalls | No | Minimum call count to include |