# On average, what should we expect in query performance for nodes and core variations?

**URL:** <https://discuss.elastic.co/t/on-average-what-should-we-expect-in-query-performance-for-nodes-and-core-variations/237512>\
**Category:** Elasticsearch\
**Created:** [June 17, 2020, 4:37pm UTC](https://discuss.elastic.co/t/on-average-what-should-we-expect-in-query-performance-for-nodes-and-core-variations/237512 "2020-06-17T16:37:36Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![spdoes](https://avatars.discourse-cdn.com/v4/letter/s/a698b9/32.png) [@spdoes](https://discuss.elastic.co/u/spdoes)\
**Post date:** [June 17, 2020, 4:37pm UTC](https://discuss.elastic.co/t/on-average-what-should-we-expect-in-query-performance-for-nodes-and-core-variations/237512/1 "2020-06-17T16:37:37Z")

</div>

1. Doubling the number of cores in rough average means reducing in half the query time ? (from 6 to 12 in my case)

2. Doubling the number of nodes in rough average means reducing in half the query time ? (from 1 to 2 and from 2 to 3 in my case)

3. If the double the number of nodes and increase the number of replicas in general would I get a penalty in query performance because of the replica ?

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [June 17, 2020, 4:52pm UTC](https://discuss.elastic.co/t/on-average-what-should-we-expect-in-query-performance-for-nodes-and-core-variations/237512/2 "2020-06-17T16:52:17Z")

</div>

It is hard to say as it depends on what is currently limiting performance. The number of concurrent queries and shards queried also matters.

If all data is cached in the OS page cache you might be CPU limited. If so, you need to make sure you have enough shards to make use of the parallel processing capacity.

If you instead are limited by disk performance adding CPU resources may not help at all.

---

<div class="post-metadata">

**Author:** ![spdoes](https://avatars.discourse-cdn.com/v4/letter/s/a698b9/32.png) [@spdoes](https://discuss.elastic.co/u/spdoes)\
**Post date:** [June 23, 2020, 8:34pm UTC](https://discuss.elastic.co/t/on-average-what-should-we-expect-in-query-performance-for-nodes-and-core-variations/237512/3 "2020-06-23T20:34:52Z")

</div>

I get it.

Concurrent queries are not my case I have large data dataset with low number of queries

Is there an easy way to know if the bottleneck is dick IO or CPU or memory ?

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [June 23, 2020, 8:38pm UTC](https://discuss.elastic.co/t/on-average-what-should-we-expect-in-query-performance-for-nodes-and-core-variations/237512/4 "2020-06-23T20:38:49Z")

</div>

Run queries and monitor GC, CPU usage and disk utilization/iowait. That should give you a good indication. If you have large amounts of data, much more than will fit in the OS page cache, disk I/O is often the bottleneck so that is what I would check first.

---

<div class="post-metadata">

**Author:** ![spdoes](https://avatars.discourse-cdn.com/v4/letter/s/a698b9/32.png) [@spdoes](https://discuss.elastic.co/u/spdoes)\
**Post date:** [June 24, 2020, 3:21pm UTC](https://discuss.elastic.co/t/on-average-what-should-we-expect-in-query-performance-for-nodes-and-core-variations/237512/5 "2020-06-24T15:21:13Z")

</div>

> [@Christian\_Dahlqvist](#):
>
> monitor GC, CPU usage and disk utilization/iowait

I will measure it and get back

---

<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 22, 2020, 3:21pm UTC](https://discuss.elastic.co/t/on-average-what-should-we-expect-in-query-performance-for-nodes-and-core-variations/237512/6 "2020-07-22T15:21:15Z")

</div>

Closed on July 22, 2020, 3:21pm UTC

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