We noticed a serious performance degradation of date_histogram aggregations on our cluster after upgrading to 7.8.0.
We have two indexes with 1.2billion documents and use only date_histogram, but this query need 10S.
We use Profiler api to generate the following result.
We have 14 machines , per node has 128G memory and 5T SSD disk。
Did someone experienced the same behaviour?Is this something we can tune?