# Query performance decreased after cluster upgrade

**URL:** <https://discuss.elastic.co/t/query-performance-decreased-after-cluster-upgrade/89161>\
**Category:** Elasticsearch\
**Created:** [June 13, 2017, 9:18am UTC](https://discuss.elastic.co/t/query-performance-decreased-after-cluster-upgrade/89161 "2017-06-13T09:18:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![BastiPaeltz](https://avatars.discourse-cdn.com/v4/letter/b/eada6e/32.png) [@BastiPaeltz](https://discuss.elastic.co/u/BastiPaeltz)\
**Post date:** [June 13, 2017, 9:18am UTC](https://discuss.elastic.co/t/query-performance-decreased-after-cluster-upgrade/89161/1 "2017-06-13T09:18:08Z")

</div>

Hey,

we recently upgraded our ES logging cluster from 2.X to 5.4 and implemented a distributed (3 x client, 3 x master and 6 x data nodes on separate machines) architecture.  
Before we ran everything on 6 x all-purpose nodes. In terms of hardware they are the same though. We imported data to the new cluster using ES snapshots, so index settings, like `number of shards` are the same as well.

We now see **worse query duration times** , especially when querying large time periods via Kibana.

Example:

Query:  
default Kibana query, not searching for anything, and querying the last 60 days of an index pattern

Result:

```
NEW CLUSTER:
------------
Query Duration 9778ms
Request Duration 9992ms
Hits 760170271

OLD CLUSTER:
-------------
Query Duration 7730ms
Request Duration 10002ms
Hits 755127976

```

Comparing the node load while the query runs, we see the **Process CPU of the new cluster rising to 100% on all data nodes** , while the old cluster merely reaches ~85%. (remember, the hardware is the same)

I'm happy to provide other metrics for you guys.  
Thanks for your help in advance 😃

---

<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 11, 2017, 9:18am UTC](https://discuss.elastic.co/t/query-performance-decreased-after-cluster-upgrade/89161/2 "2017-07-11T09:18:21Z")

</div>

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