Athena
ClientsClient_nameQuery optimizations

List query optimization recommendations for a client

Returns stored recommendations from the logging database with optional status filter and pagination. Requires the static admin key (`ATHENA_KEY_12`) and a connected `athena_logging` pool.

GET
/admin/clients/{client_name}/query-optimizations

Path Parameters

client_name*string

Query Parameters

status?string

Filter by recommendation status; omit or all for every status.

Value in"all" | "open" | "applied" | "dismissed"
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/query-optimizations" \  -H "apikey: string"
{
  "client_name": "string",
  "status": "string",
  "limit": 0,
  "offset": 0,
  "recommendations": [
    {}
  ]
}
Empty
{
  "status": "error",
  "message": "string",
  "error": "string"
}

Inspect Athena client pressure detail GET

Previous Page

Apply a query optimization recommendation POST

Applies the recommendation identified by `recommendation_id` for `client_name`. Optional JSON body may set `actor` for audit metadata. Requires the static admin key (`ATHENA_KEY_12`) and a connected `athena_logging` pool.