db_top_queries
Show the slowest or heaviest queries for a database instance using performance_schema or pg_stat_statements. Read-only tool for troubleshooting query performance.
Instructions
Show the slowest / heaviest queries for an instance's DB. MySQL: performance_schema digest summary. Postgres: pg_stat_statements (extension must be enabled). For the shared-RDS noisy-neighbour case. Requires a db_profile; password from your secret store. Read-only query.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| instance_id | Yes | Instance ID, name, or custom-server name. | |
| limit | No | How many queries to return (1–100, default 15). |