# Aggregation response time is slow in ES Version 6.4

**URL:** <https://discuss.elastic.co/t/aggregation-response-time-is-slow-in-es-version-6-4/164676>\
**Category:** Elasticsearch\
**Created:** [January 17, 2019, 4:05pm UTC](https://discuss.elastic.co/t/aggregation-response-time-is-slow-in-es-version-6-4/164676 "2019-01-17T16:05:16Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thillai\_Natarajan\_Ra](https://avatars.discourse-cdn.com/v4/letter/t/49beb7/32.png) [@Thillai\_Natarajan\_Ra](https://discuss.elastic.co/u/Thillai_Natarajan_Ra)\
**Post date:** [January 17, 2019, 4:05pm UTC](https://discuss.elastic.co/t/aggregation-response-time-is-slow-in-es-version-6-4/164676/1 "2019-01-17T16:05:16Z")

</div>

Hi,

I'm using elasticsearch version 2.2 and also 6.4. Since indices in version 2.2 cannot be directly reindexed to 6.4 i'm running both version at same time and once if data inside version 6.4 is large enough, i will stop ES2.2. Thats my plan.

I just run a Aggregation to compare the execution time. I ran a query with single index (Apprx 40-45 million documents) **V6.4** returns response in **5.548** minute whereas **V2.2** takes only **0.325** minute.

My query involves a must criteria with a termsquery on one field and cardinality on other field.

Let me share you the mapping details (Note : same mapping for both fields)  
In V2.2

> "doc\_values": true,  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "type": "string"

In V6.4

> "index": true,  
> "doc\_values": true,  
> "norms": false,  
> "type": "keyword"

I guess both the mapping are equivalent.

What i'm misssng ? Any new meta-fields is introduced?  
Kindly Assisst me.

Regards,  
Muthu Thillai

---

<div class="post-metadata">

**Author:** ![Thillai\_Natarajan\_Ra](https://avatars.discourse-cdn.com/v4/letter/t/49beb7/32.png) [@Thillai\_Natarajan\_Ra](https://discuss.elastic.co/u/Thillai_Natarajan_Ra)\
**Post date:** [January 18, 2019, 7:09am UTC](https://discuss.elastic.co/t/aggregation-response-time-is-slow-in-es-version-6-4/164676/2 "2019-01-18T07:09:05Z")

</div>

Can any one help me on this?

---

<div class="post-metadata">

**Author:** ![Thillai\_Natarajan\_Ra](https://avatars.discourse-cdn.com/v4/letter/t/49beb7/32.png) [@Thillai\_Natarajan\_Ra](https://discuss.elastic.co/u/Thillai_Natarajan_Ra)\
**Post date:** [January 21, 2019, 5:19am UTC](https://discuss.elastic.co/t/aggregation-response-time-is-slow-in-es-version-6-4/164676/3 "2019-01-21T05:19:07Z")

</div>

Team, any findings ? 😣😣

---

<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:** [February 18, 2019, 5:19am UTC](https://discuss.elastic.co/t/aggregation-response-time-is-slow-in-es-version-6-4/164676/4 "2019-02-18T05:19:13Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.