Health snapshot
database_healthGet PostgreSQL database health: cache hit ratio, connections, long-running queries, vacuum backlog, invalid indexes, sequence exhaustion, replication lag. Unreadable values are marked unavailable.
Instructions
One snapshot of the things an operator would otherwise assemble by hand: cache hit ratio, connections, long-running statements and abandoned transactions, vacuum backlog, invalid indexes, sequences near their ceiling, replication lag. Scoped to the current database; anything the connected role cannot read is reported as unavailable rather than left out.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | which configured database to use; omit when only one is configured |