Athena

Optimization and Admission

Query optimization recommendations, vacuum health, and admission events.

Query Optimization Routes

Per-client optimization endpoints:

  • GET /admin/clients/{client_name}/query-optimizations
  • POST /admin/clients/{client_name}/query-optimizations/refresh
  • GET /admin/clients/{client_name}/query-optimizations/runs
  • POST /admin/clients/{client_name}/query-optimizations/{recommendation_id}/apply

Vacuum and Admission Routes

  • GET /admin/vacuum-health
  • GET /admin/vacuum-health/{client_name}
  • GET /admin/admission-events

These endpoints support query tuning workflows and operational pressure visibility.

Auth Requirements

  • X-Athena-Client
  • x-athena-admin-key
  1. List current recommendations.
  2. Trigger recommendation refresh.
  3. Review execution runs and failures.
  4. Apply selected recommendations in controlled windows.
  5. Review vacuum and admission events after changes.

Reference

See Reference -> Athena API Reference -> admin -> clients, vacuum-health, and admission-events.

Schema and Introspection

Discover clients, schemas, tables, columns, migrations, and registry metadata.

Management DDL and Functions

Safe table, index, extension, and function management workflows.

On this page

Query Optimization RoutesVacuum and Admission RoutesAuth RequirementsRecommended Operating LoopReferenceOperation Links