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.
