# SubAggregation Performance

**URL:** <https://discuss.elastic.co/t/subaggregation-performance/64721>\
**Category:** Elasticsearch\
**Created:** [November 2, 2016, 2:21pm UTC](https://discuss.elastic.co/t/subaggregation-performance/64721 "2016-11-02T14:21:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![learnes](https://avatars.discourse-cdn.com/v4/letter/l/35a633/32.png) [@learnes](https://discuss.elastic.co/u/learnes)\
**Post date:** [November 2, 2016, 2:21pm UTC](https://discuss.elastic.co/t/subaggregation-performance/64721/1 "2016-11-02T14:21:41Z")

</div>

The following queries (two level) take around 1minute to finish,

query1 : DateHistogram.subAggregation(TermsBuilderOnField1.subAggregation(TermsBuilderOnField2))  
query2 : DateHistogram.subAggregation(TermsBuilderOnField2.subAggregation(TermsBuilderOnField1))

Field1 - int field (Possible values are 1 to 10)  
Field2 - Long (High cardinality field basically a user ID)  
Version - 2.3.2

Some insights on my data,

1. daily indices with 2 copies , average size of 50GB for per copy (100GB for 2 copy)
2. Around 400 million docs in per day index
3. 3 machines with 128 GB RAM (Running as 6 nodes. 30GB assigned to each JVM )

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 5, 2017, 10:07pm UTC](https://discuss.elastic.co/t/subaggregation-performance/64721/2 "2017-07-05T22:07:05Z")

</div>