Check database health
check_database_healthRun database health checks to assess connection utilisation, buffer cache hit ratio, tables needing vacuum, and invalid indexes. Get status per check to identify issues quickly.
Instructions
Run database health checks: connection utilisation, buffer cache hit ratio, tables needing vacuum, and invalid indexes. Returns an object with status ('ok' / 'warning' / 'critical') and checks (a list of {name, status, detail} per check).
Example: check_database_health()
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Optional: target a configured secondary (read-only) database by name; omit for the primary. Call list_databases to see the configured ids. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| checks | Yes | ||
| status | Yes |