get_top_queries
Retrieve the slowest or most resource-intensive queries using pg_stat_statements, sorted by total time, mean time, or combined CPU and I/O usage.
Instructions
Report the slowest or most resource-intensive queries using pg_stat_statements.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| sort_by | No | "resources" = combined CPU + I/O; "total_time" = cumulative; "mean_time" = per execution | resources |
| database | No | Database alias to query. Omit to use the primary database. |