db_top_queries
Find slowest database queries to identify performance issues. Supports MySQL and PostgreSQL instances using performance schema or pg_stat_statements.
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 |
|---|---|---|---|
| app | No | Website/app to target when the instance hosts several DBs; matched loosely against stored site labels. Omit for a single DB. | |
| limit | No | How many queries to return (1–100, default 15). | |
| instance_id | Yes | Instance ID, name, or custom-server name. |