Programmer1970

Jul 19, 2026 · Backend Development

Elasticsearch Query Optimization: How Three Settings Cut a 5‑Second Aggregation to 80 ms

A Kibana‑observed daily aggregation query on 70 million documents took 5.2 seconds, but by tweaking three Elasticsearch settings—eager_global_ordinals, doc_values_format v2, and index.sort—the same query consistently runs in about 80 milliseconds.