db_processlist
Check a database instance's connection saturation and session summary. Returns grouped sessions with counts, oldest age, and top 10 longest queries, or a raw processlist dump.
Instructions
Show an instance's DB connection saturation + a session summary. By default SUMMARISES server-side (saturation, sessions grouped by command/state with counts + oldest age, and the 10 longest-running queries) instead of dumping every row. Pass full=true for the raw SHOW FULL PROCESSLIST / pg_stat_activity dump. Requires a db_profile for the instance; 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 (e.g. 'shop.example.com'); matched loosely against stored site labels. Omit for a single-DB instance. | |
| full | No | Return the raw per-session dump instead of the summary. | |
| instance_id | Yes | Instance ID, name, or custom-server name. |