I ran into a performance issue today with nested Terms aggregations.
Performance took a 1000x dive (aggregation time went from ~10ms to
~10,000ms) when I added a terms aggregation as a sub-aggregation of an
existing term aggregation.
The nature of the data is that the sub-aggregation will only yield 1 bucket
- so its not like there were a bazillion buckets - but we do kind of have a
deep nesting of aggregations - and this particular aggregation lies at the
leaf of all aggregations.
That said, would such a jump in performance be expected? Might it be a bug?
Should I create a simple test case to reproduce it?
(If youre wondering why I would do a term aggregation where I only expect 1
result - see
https://groups.google.com/forum/?fromgroups=#!topic/elasticsearch/y5WTIIAxEPo)
Here is part of my request:
{
"aggregations" : {
"operatorId" : {
"terms" : {
"field" : "operatorId",
"size" : 100
},
"aggregations" : { <<------ adding this subaggregation has a
massive impact on perf.
"operatorFullName" : {
"terms" : {
"field" : "operatorFullName"
}
}
}
}
}
Cheers,
-M
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/b506a4cf-d600-483c-8813-3f2f1e6eff4d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.