Vacuum healthClient_name
Latest vacuum health snapshot and per-table stats for one client
Returns the latest snapshot for `client_name` plus all `vacuum_health_table_stats` rows for that snapshot. Requires the static admin key (`ATHENA_KEY_12`).
Path Parameters
client_name*string
Header Parameters
apikey*string
The static admin key configured as ATHENA_KEY_12. Authorization headers (Bearer <key>), X-API-Key, X-Athena-Key, or ?api_key= are also accepted.
Response Body
application/json
application/json
curl -X GET "https://athena-cluster.com/admin/vacuum-health/string" \ -H "apikey: string"{
"snapshot": {
"id": 0,
"recorded_at": "2019-08-24T14:15:22Z",
"client_name": "string",
"host": "string",
"instance_id": "06587974-2dbe-4e10-8bf9-38cce0f5a366",
"total_dead_rows": 0,
"tables_with_bloat": 0,
"xid_freeze_risk": 0,
"tables_needing_vacuum": 0,
"freeze_max_age": 0,
"collection_error": "string"
},
"tables": [
{
"id": 0,
"snapshot_id": 0,
"schemaname": "string",
"relname": "string",
"n_dead_tup": 0,
"n_live_tup": 0,
"dead_pct": 0,
"last_vacuum": "2019-08-24T14:15:22Z",
"last_autovacuum": "2019-08-24T14:15:22Z",
"xid_age": 0,
"xid_age_pct_of_freeze_max": 0
}
]
}Empty
{
"status": "error",
"message": "string",
"error": "string"
}List latest vacuum health snapshot per Postgres client GET
Returns the most recent `vacuum_health_snapshots` row per `client_name` stored in the logging database (populated by the background vacuum health collector). Requires the static admin key (`ATHENA_KEY_12`).
List gateway webhooks GET
Definitions for outbound HTTP hooks fired after successful gateway operations (requires static admin key).