# Query time increases on a particular index out of many indexes in es

**URL:** <https://discuss.elastic.co/t/query-time-increases-on-a-particular-index-out-of-many-indexes-in-es/227421>\
**Category:** Elasticsearch\
**Created:** [April 9, 2020, 11:32pm UTC](https://discuss.elastic.co/t/query-time-increases-on-a-particular-index-out-of-many-indexes-in-es/227421 "2020-04-09T23:32:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mohit\_Ojha](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohit_ojha/32/48327_2.png) [@Mohit\_Ojha](https://discuss.elastic.co/u/Mohit_Ojha)\
**Post date:** [April 9, 2020, 11:32pm UTC](https://discuss.elastic.co/t/query-time-increases-on-a-particular-index-out-of-many-indexes-in-es/227421/1 "2020-04-09T23:32:50Z")

</div>

Query time increases on a particular index out of many indexes in es. This happens for 6-7 hours on some random days. The start time always is from 10:30 PM IST(occurs at same time on the day it happens), but there is no pattern on days it occurs. Out of 8-10 indices, only this one suffers. This index never gets updated but other indices in the same cluster are daily replaced by a new index.

---

<div class="post-metadata">

**Author:** ![Luca\_Belluccini](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/luca_belluccini/32/33239_2.png) [@Luca\_Belluccini](https://discuss.elastic.co/u/Luca_Belluccini)\
**Post date:** [April 10, 2020, 12:15am UTC](https://discuss.elastic.co/t/query-time-increases-on-a-particular-index-out-of-many-indexes-in-es/227421/2 "2020-04-10T00:15:43Z")

</div>

Hello @Mohit_Ojha

I would suggest to provide some additional information such as:

- Elasticsearch version
- Type or example of query
- Index size & shard numbers (`GET <index name>`, `GET _cat/indices?v`, `GET _cat/shards`)

It might be related to the amount of concurrent searches: if the shard(s) are hosted on a single machine, only this machine will be able to serve the search requests, creating a bottleneck.  
You might increase the number of replicas to scale the reads.

Other suggestions might be found in [our documentation](https://www.elastic.co/guide/en/elasticsearch/reference/master/tune-for-search-speed.html)

If you're on Elasticsearch 7.3.0 and you experience slowdown in Kibana when date histograms, you might be hitting a regression:

> <https://github.com/elastic/elasticsearch/issues/45702>
>
> Elasticsearch version (bin/elasticsearch --version):
> Version: 7.3.0, Build: default/rpm/de777fa/2019-07-24T18:30:11.767338Z, JVM: 12.0.1
> Plugins installed: \[\]
> repository-s3
> JVM version (java -version):
> JVM shipped with Elasticsearch (rpm)
> OS version (uname -a...

---

<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:** [May 8, 2020, 12:15am UTC](https://discuss.elastic.co/t/query-time-increases-on-a-particular-index-out-of-many-indexes-in-es/227421/3 "2020-05-08T00:15:49Z")

</div>

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