Hi, We're experiencing a strange behavior with an aggregation. The below query is taking 1 - 1.5 seconds to execute. GET index/type/_search { "size": 0, "query": { "bool": { "must": [ { "term": { "query": { "value": "some search query" } } } …

Slow aggregation no matter the size of the result set

Mark_Harwood (Mark Harwood) September 28, 2018, 11:54am 2

Try execution hint of map on the terms agg.

1 Like

Topic		Replies	Views
Troubleshooting Slow Aggregation Query Elasticsearch	7	3555	July 5, 2017
What kind of performance can you expect when using aggregations? Elasticsearch	3	763	July 6, 2017
Bad performance on aggregations Elasticsearch	5	498	July 6, 2017
Very different aggregation speed for similar fields with different cardinality Elasticsearch	2	360	April 2, 2017
Slow query with aggregations Elasticsearch	8	551	September 30, 2021

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Slow aggregation no matter the size of the result set

Related topics