Hello everyone, I created a simple query which looks for specific 5 car ID's and aggregates upon them. It's extremely fast, takes about 300-500ms. But if I add a nested aggregation which looks only for a specific colour in those 5 ID's, it suddenly takes 10 seconds or longer. This doesn't make sens…

Nested aggregation slows query from ~400ms to 10s

loren (Loren Siebert) September 8, 2018, 1:43pm 9

If you run the 10s agg query several times in a row, does it always take 10s?

Also, how confident are you that none of your nodes are swapping?

Topic		Replies	Views
Troubleshooting Slow Aggregation Query Elasticsearch	7	3545	July 5, 2017
Aggregation on nested document always takes 2-3 seconds? Elasticsearch	2	542	July 6, 2017
Extremely slow nested aggregations, need suggestions on modeling/shards Elasticsearch	1	501	July 5, 2017
Performance Issue with Sub-Aggregations and Nested Document Structure? Elasticsearch	3	2351	March 27, 2017
Nested aggregation got too slow result Elasticsearch	12	604	May 22, 2018