# Performance Downgrade, after upgrading from 6.4 to 7.7

**URL:** https://discuss.elastic.co/t/performance-downgrade-after-upgrading-from-6-4-to-7-7/274861
**Category:** Elasticsearch
**Created:** [June 3, 2021, 11:10am UTC](https://discuss.elastic.co/t/performance-downgrade-after-upgrading-from-6-4-to-7-7/274861 "2021-06-03T11:10:08Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![chintushah46](https://avatars.discourse-cdn.com/v4/letter/c/977dab/32.png) [@chintushah46](https://discuss.elastic.co/u/chintushah46)
#### Post date: [June 3, 2021, 11:10am UTC](https://discuss.elastic.co/t/performance-downgrade-after-upgrading-from-6-4-to-7-7/274861/1 "2021-06-03T11:10:08Z")

</div>

I am seeing a huge performance downgrade after upgrading Elasticsearch from version 6.4 to 7.7.

Query Sample:

> {"size": 1000000,"from": 0,"track\_total\_hits": true,"query": {"bool": {"filter": {"bool": {"should": [{"bool": {"must": [{"term": {"Term1": "String1"}},{"term": {"Term2": 0}}]}},{"bool": {"must": [{"term": {"Term1": "String2"}},{"term": {"Term2": 0}}]}},{"bool": {"must": [{"term": {"Term1": "String3"}},{"term": {"Term2": 0}}]}},{"bool": {"must": [{"term": {"Term1": "String4"}},{"term": {"Term2": 0}}]}},{"bool": {"must": [{"term": {"Term1": "String5"}},{"term": {"Term2": 2}}]}}],"must": [{"range": {"Term3": {"gte": 1622592000,"lte": 1622678399}}},{"terms": {"Term4": ["xyz1","xyz2","xyz3","xyz4","xyz5","xyz6","xyz7","xyz8","xyz9","xyz10","xyz11","xyz12","xyz13","xyz14","xyz15","xyz16","xyz17","xyz18","xyz19","xyz20","xyz21","xyz22","xyz23","xyz24","xyz25","xyz26","xyz27","xyz28","xyz29","xyz30","xyz31","xyz32","xyz33","xyz34","xyz35","xyz36","xyz37","xyz38","xyz39","xyz40","xyz41","xyz42","xyz43","xyz44","xyz45","xyz46","xyz47","xyz48","xyz49","xyz50","xyz51","xyz52","xyz53","xyz54","xyz55","xyz56","xyz57","xyz58","xyz59","xyz60","xyz61","xyz62","xyz63","xyz64","xyz65","xyz66","xyz67","xyz68","xyz69","xyz70","xyz71","xyz72","xyz73","xyz74","xyz75","xyz76","xyz77","xyz78","xyz79","xyz80","xyz81","xyz82","xyz83","xyz84","xyz85","xyz86","xyz87","xyz88","xyz89","xyz90","xyz91","xyz92","xyz93","xyz94","xyz95","xyz96","xyz97","xyz98","xyz99","xyz100","xyz101","xyz102","xyz103","xyz104","xyz105","xyz106","xyz107","xyz108","xyz109","xyz110","xyz111","xyz112","xyz113","xyz114","xyz115","xyz116","xyz117","xyz118","xyz119","xyz120"]}}]}}}},"\_source": ["Term3","Term1","Term2","Term4","V"],"sort": [{"Term3": {"order": "asc"}},{"Term1": {"order": "asc"}},{"Term2": {"order": "asc"}},{"Term4": {"order": "asc"}}]}

When I ran the above query on ES v6.4, The average Documents per seconds it was returning **58,014**. While the same query for ES v7.7 is returning **45,560**. Which is an almost **27%** downgrade.

**Note:**

- For both versions, I am having 5 shards.
- I have compared the Index settings, cluster's health, node's settings. They are almost the same except for whatever has been added through the newer version.
- I tried adding/removing shards, but no luck.

Any thought/help would be appreciated.

---

<div class="post-metadata">

### Author: ![chintushah46](https://avatars.discourse-cdn.com/v4/letter/c/977dab/32.png) [@chintushah46](https://discuss.elastic.co/u/chintushah46)
#### Post date: [June 15, 2021, 12:30pm UTC](https://discuss.elastic.co/t/performance-downgrade-after-upgrading-from-6-4-to-7-7/274861/2 "2021-06-15T12:30:41Z")

</div>

Hello,

Please let me know If there is anything that is missing in the above request? I am still having the same issue and its kind of critical.

---

<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 13, 2021, 12:31pm UTC](https://discuss.elastic.co/t/performance-downgrade-after-upgrading-from-6-4-to-7-7/274861/3 "2021-07-13T12:31:31Z")

</div>

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