# Upgrade ES 5.6.3 to ES 7.8.0: Slower queries. Trying to explain/find out why

**URL:** https://discuss.elastic.co/t/upgrade-es-5-6-3-to-es-7-8-0-slower-queries-trying-to-explain-find-out-why/255293
**Category:** Elasticsearch
**Created:** [November 13, 2020, 6:36am UTC](https://discuss.elastic.co/t/upgrade-es-5-6-3-to-es-7-8-0-slower-queries-trying-to-explain-find-out-why/255293 "2020-11-13T06:36:51Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![pvdp](https://avatars.discourse-cdn.com/v4/letter/p/8baadc/32.png) [@pvdp](https://discuss.elastic.co/u/pvdp)
#### Post date: [November 13, 2020, 6:36am UTC](https://discuss.elastic.co/t/upgrade-es-5-6-3-to-es-7-8-0-slower-queries-trying-to-explain-find-out-why/255293/1 "2020-11-13T06:36:51Z")

</div>

We are upgrading from ES 5.6.3 to ES 7.8.0. As part of this, we are doing performance tests to see  
if there is an improvement or actual degradation in performance.

For this we've setup 2 identical clusters in AWS, each cluster containing the index (3 shards) containing 9M docs.

Queries performed (with scroll of '1m'):

1. Date/time range ( 5.5M+ or 3.4M hits depending on provided range)
2. Date/time range + terms (1.2M+ hits or 750K+ hits depending on provided range)

We collected timings using the profile api + timed the ES calls from our C# application.  
What we were seeing is that the same queries against ES 7 take about **16%** longer. This contradicts the timings we see in the profile data, which shows better times when compared against ES 5 profile data.

So question is: What further action can we take to investigate this performance degradation?

Am able to provide additional info as required/requested.

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [November 17, 2020, 11:19pm UTC](https://discuss.elastic.co/t/upgrade-es-5-6-3-to-es-7-8-0-slower-queries-trying-to-explain-find-out-why/255293/2 "2020-11-17T23:19:35Z")

</div>

Welcome to our community! 😃

> [@pvdp](#):
>
> 2 identical clusters in AWS

Is this on EC2, or a managed service such as Elastic Cloud?

---

<div class="post-metadata">

### Author: ![pvdp](https://avatars.discourse-cdn.com/v4/letter/p/8baadc/32.png) [@pvdp](https://discuss.elastic.co/u/pvdp)
#### Post date: [November 17, 2020, 11:52pm UTC](https://discuss.elastic.co/t/upgrade-es-5-6-3-to-es-7-8-0-slower-queries-trying-to-explain-find-out-why/255293/3 "2020-11-17T23:52:16Z")

</div>

The clusters are on EC2.

---

<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: [December 15, 2020, 11:52pm UTC](https://discuss.elastic.co/t/upgrade-es-5-6-3-to-es-7-8-0-slower-queries-trying-to-explain-find-out-why/255293/4 "2020-12-15T23:52:20Z")

</div>

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