Athena
ClientsClient_nameStatisticsDrilldown

List gateway operation log rows for a client table operation

Returns rows from `gateway_operation_log` filtered by `client`, `table_name`, and `operation`, with optional `status` (`all`, `errors`, or `normal`) and pagination. Requires the static admin key (`ATHENA_KEY_12`) and a connected `athena_logging` pool.

GET
/admin/clients/{client_name}/statistics/drilldown

Path Parameters

client_name*string

Query Parameters

table_name*string

Table name (matches gateway_operation_log.table_name).

operation*string

Operation name (matches gateway_operation_log.operation).

status?string

errors includes rows where error is true or status_code is at least 400; normal excludes those.

Default"all"
Value in"all" | "errors" | "normal"
limit?integer
Default100
Range1 <= value <= 500
offset?integer
Default0
Range0 <= value

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/clients/string/statistics/drilldown?table_name=string&operation=string" \  -H "apikey: string"
{
  "client_name": "string",
  "table_name": "string",
  "operation": "string",
  "status": "string",
  "limit": 0,
  "offset": 0,
  "rows": [
    {
      "created_at": "2019-08-24T14:15:22Z",
      "request_id": "string",
      "operation": "string",
      "table_name": "string",
      "client_name": "string",
      "method": "string",
      "path": "string",
      "status_code": 0,
      "duration_ms": 0,
      "operation_time_ms": 0,
      "details": {},
      "error": true,
      "message": "string",
      "cache_key": "string"
    }
  ]
}
Empty
{
  "status": "error",
  "message": "string",
  "error": "string"
}

Inspect Athena client statistics GET

Previous Page

Approximate per-table row counts plus storage-pressure advisories GET

Runs a read-only catalog query against the target Postgres client and returns approximate row counts sourced from `pg_class.reltuples`. Responses are cached through Athena's shared response cache (in-process + Redis when configured). Send `Cache-Control: no-cache` to bypass the cache and force a fresh snapshot. By default Athena excludes system schemas (`pg_catalog`, `information_schema`, `pg_toast`, and temporary variants). Snapshot advisories also flag very large tables and Athena-managed gateway log tables that commonly show up in disk-pressure incidents.