# Terms list might be incomplete because the request is taking too long

**URL:** <https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-too-long/277491>\
**Category:** Kibana\
**Created:** [June 30, 2021, 6:46pm UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-too-long/277491 "2021-06-30T18:46:05Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gaurav2](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gaurav2/32/81899_2.png) [@Gaurav2](https://discuss.elastic.co/u/Gaurav2)\
**Post date:** [June 30, 2021, 6:46pm UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-too-long/277491/1 "2021-06-30T18:46:05Z")

</div>

Hi,

please we need help on this. we have elasticsearch running with over 2 billion documents (32 GB ram, 4.5 cpu and 16 gb heap) and over 700 shards

we tried making these changes but ended up rebuilding kibana as it was no longer responding we had some luck as we increased the number slowly slowly... but it didn't worked..

Is there any other way to do it or any other dropdown visualization we can use??

or how about fixing this control visualization. I think the way it should work is it should pull the data from the index patten of the time defined... instead of pulling all the data at once... from all indices which is causing this issue....

please let me know.

Thanks!!

---

<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:** [June 30, 2021, 11:56pm UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-too-long/277491/2 "2021-06-30T23:56:19Z")

</div>

What is the output from the `_cluster/stats?pretty&human` API?  
But it sounds like your cluster (which appears to be a single node?) is overloaded, you need to reduce the shard count to start.

---

<div class="post-metadata">

**Author:** ![Gaurav2](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gaurav2/32/81899_2.png) [@Gaurav2](https://discuss.elastic.co/u/Gaurav2)\
**Post date:** [July 1, 2021, 8:02am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-too-long/277491/3 "2021-07-01T08:02:28Z")

</div>

Hi @warkolm

It is a 4 node cluster (1 tie breaker, 2 nodes (1 master and 1 master eligable) , 1 warm nodes)

Kibana with 4gb ram 2 cpu

please let us know ASAP. It is very important for us

Thanks

---

<div class="post-metadata">

**Author:** ![Gaurav2](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gaurav2/32/81899_2.png) [@Gaurav2](https://discuss.elastic.co/u/Gaurav2)\
**Post date:** [July 2, 2021, 8:13pm UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-too-long/277491/4 "2021-07-02T20:13:44Z")

</div>

Hello guys,

Finally, I found one solutions.

hope this helps to others out there facing the same issue..

In control visualization in options section you will find a option "Use time filter" just enable that and it works like a charm 🙂

please see the screenshots on how to implement if you are new to this.

with that setting

 ![working-with-time-filter](https://us1.discourse-cdn.com/elastic/original/3X/5/f/5f29ea6d18cfd59952474cd56d9b7f66a0fe7d57.png)

without that setting

 ![not working](https://us1.discourse-cdn.com/elastic/original/3X/a/a/aaada896d342471471cf9892688efebe2c52512f.png)

Thanks,

---

<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 30, 2021, 8:14pm UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-too-long/277491/5 "2021-07-30T20:14:28Z")

</div>

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