# Result window is too large

**URL:** <https://discuss.elastic.co/t/result-window-is-too-large/58925>\
**Category:** Elasticsearch\
**Created:** [August 25, 2016, 11:35am UTC](https://discuss.elastic.co/t/result-window-is-too-large/58925 "2016-08-25T11:35:24Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![sukhada369](https://avatars.discourse-cdn.com/v4/letter/s/ce7236/32.png) [@sukhada369](https://discuss.elastic.co/u/sukhada369)\
**Post date:** [August 25, 2016, 11:35am UTC](https://discuss.elastic.co/t/result-window-is-too-large/58925/1 "2016-08-25T11:35:24Z")

</div>

Error: [query\_phase\_execution\_exception] Result window is too large, from + size must be less than or equal to: [10000] but was [2147483647].

I have changed the size of max\_result\_window of .kibana index from 10000 to 2147483647. Still I see the same error.

---

<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:** [August 25, 2016, 11:51am UTC](https://discuss.elastic.co/t/result-window-is-too-large/58925/2 "2016-08-25T11:51:50Z")

</div>

> [@sukhada369](#):
>
> I have changed the size of max\_result\_window of .kibana index from 10000 to 2147483647

That would be inadvisable, why does it need to be so large?

What version of things are you using?

---

<div class="post-metadata">

**Author:** ![sukhada369](https://avatars.discourse-cdn.com/v4/letter/s/ce7236/32.png) [@sukhada369](https://discuss.elastic.co/u/sukhada369)\
**Post date:** [August 26, 2016, 3:36am UTC](https://discuss.elastic.co/t/result-window-is-too-large/58925/3 "2016-08-26T03:36:41Z")

</div>

ES 2.3 and Kibana 4.5.4  
I am not able to understand how to overcome this error.

---

<div class="post-metadata">

**Author:** ![colings86](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/colings86/32/44960_2.png) [@colings86](https://discuss.elastic.co/u/colings86)\
**Post date:** [August 26, 2016, 8:37am UTC](https://discuss.elastic.co/t/result-window-is-too-large/58925/4 "2016-08-26T08:37:56Z")

</div>

Deep pagination is a very bad idea and this safeguard exists to help protect your cluster from very heavy requests that can destabilise or bring it down completely. Please read this page of the documentation to help understand why doing this is a bad idea: [https://www.elastic.co/guide/en/elasticsearch/guide/2.x/pagination.html](https://www.elastic.co/guide/en/elasticsearch/guide/2.x/pagination.html)

Why are you wanting to retrieve `2147483647` results from Elasticsearch? Could you explain your use case for doing this request? Then we might be able to offer some alternative ideas on what features of Elasticsearch you should use instead or on a different approach to solve your use case.

---

<div class="post-metadata">

**Author:** ![colings86](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/colings86/32/44960_2.png) [@colings86](https://discuss.elastic.co/u/colings86)\
**Post date:** [August 26, 2016, 8:39am UTC](https://discuss.elastic.co/t/result-window-is-too-large/58925/5 "2016-08-26T08:39:17Z")

</div>

I see you are also using Kibana, have you changed any of the settings in Kibana from the default values? If so, what have you changed?

---

<div class="post-metadata">

**Author:** ![sukhada369](https://avatars.discourse-cdn.com/v4/letter/s/ce7236/32.png) [@sukhada369](https://discuss.elastic.co/u/sukhada369)\
**Post date:** [August 26, 2016, 9:53am UTC](https://discuss.elastic.co/t/result-window-is-too-large/58925/6 "2016-08-26T09:53:06Z")

</div>

I know it is not a feasible solution. I am getting this error even tough there is very less data in ES. I am seeking for a feasible solution.

---

<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:** [August 26, 2016, 9:57am UTC](https://discuss.elastic.co/t/result-window-is-too-large/58925/7 "2016-08-26T09:57:48Z")

</div>

> [@warkolm](#):
>
> why does it need to be so large?

Getting an answer to that would be helpful. What sort of queries are you running.

---

<div class="post-metadata">

**Author:** ![sukhada369](https://avatars.discourse-cdn.com/v4/letter/s/ce7236/32.png) [@sukhada369](https://discuss.elastic.co/u/sukhada369)\
**Post date:** [August 26, 2016, 10:02am UTC](https://discuss.elastic.co/t/result-window-is-too-large/58925/8 "2016-08-26T10:02:03Z")

</div>

Thing is, I did not execute any query on same. When I accessed Kibana the very first time I am facing this error.

---

<div class="post-metadata">

**Author:** ![colings86](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/colings86/32/44960_2.png) [@colings86](https://discuss.elastic.co/u/colings86)\
**Post date:** [August 26, 2016, 10:54am UTC](https://discuss.elastic.co/t/result-window-is-too-large/58925/9 "2016-08-26T10:54:08Z")

</div>

> [@colings86](#):
>
> have you changed any of the settings in Kibana from the default values? If so, what have you changed?

Have you changed anything in the `kibana.yml` file or any of the settings on the Advanced config page in Kibana?

---

<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 5, 2017, 10:24pm UTC](https://discuss.elastic.co/t/result-window-is-too-large/58925/10 "2017-07-05T22:24:56Z")

</div>


