# Kibana Visualize page size is 50,000 all of sudden. How to make it 1000 again?

**URL:** <https://discuss.elastic.co/t/kibana-visualize-page-size-is-50-000-all-of-sudden-how-to-make-it-1000-again/180526>\
**Category:** Kibana\
**Created:** [May 10, 2019, 9:50am UTC](https://discuss.elastic.co/t/kibana-visualize-page-size-is-50-000-all-of-sudden-how-to-make-it-1000-again/180526 "2019-05-10T09:50:09Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![RRSR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rrsr/32/27766_2.png) [@RRSR](https://discuss.elastic.co/u/RRSR)\
**Post date:** [May 10, 2019, 9:50am UTC](https://discuss.elastic.co/t/kibana-visualize-page-size-is-50-000-all-of-sudden-how-to-make-it-1000-again/180526/1 "2019-05-10T09:50:09Z")

</div>

Hi all,

When I go to the Visualize tab on the Kibana then the API call to get the `saved_objects` based on the `type=visualization`is having the page size as 50,000 as seen below:

`http://<IP>:5601/api/saved_objects/_find?type=visualization&per_page=50000&page=1&search_fields=title%5E3&search_fields=description`

Response:  
`{ "message": "An internal server error occurred", "statusCode": 500, "error": "Internal Server Error" }`

Error:  
`Caused by: org.elasticsearch.search.query.QueryPhaseExecutionException: Result window is too large, from + size must be less than or equal to: [10000] but was [50000]. See the scroll api for a more efficient way to request large data sets. This limit can be set by changing the [index.max_result_window] index level setting.`

How to set the `per_page` to default value of 1000?

---

<div class="post-metadata">

**Author:** ![joelgriffith](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joelgriffith/32/53738_2.png) [@joelgriffith](https://discuss.elastic.co/u/joelgriffith)\
**Post date:** [May 10, 2019, 4:35pm UTC](https://discuss.elastic.co/t/kibana-visualize-page-size-is-50-000-all-of-sudden-how-to-make-it-1000-again/180526/2 "2019-05-10T16:35:18Z")

</div>

@RRSR did anything change related to your Kibana configuration? You can also force this to be a different value since the `per_page` parameter in your URL has the 50,000 coded in. Please try:

```auto
http://<IP>:5601/api/saved_objects/_find?type=visualization&per_page=1000&page=1&search_fields=title%5E3&search_fields=description

```

---

<div class="post-metadata">

**Author:** ![RRSR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rrsr/32/27766_2.png) [@RRSR](https://discuss.elastic.co/u/RRSR)\
**Post date:** [May 11, 2019, 7:06am UTC](https://discuss.elastic.co/t/kibana-visualize-page-size-is-50-000-all-of-sudden-how-to-make-it-1000-again/180526/3 "2019-05-11T07:06:23Z")

</div>

No @joelgriffith, nothing realated to Kibana UI was changed as per my knowledge. But as it is shared environment so someone might have changed something.

> [@joelgriffith](#):
>
> You can also force this to be a different value since the `per_page` parameter in your URL has the 50,000 coded in

Where to update it from 50000 to the default 1000? Can you please help with that.

And also which change might have been the cause if you could tell would be great as we will inform the team not to repeat the same.

---

<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:** [May 11, 2019, 8:03am UTC](https://discuss.elastic.co/t/kibana-visualize-page-size-is-50-000-all-of-sudden-how-to-make-it-1000-again/180526/4 "2019-05-11T08:03:15Z")

</div>

I believe this is one of the [advanced settings options](https://www.elastic.co/guide/en/kibana/7.0/advanced-options.html).

---

<div class="post-metadata">

**Author:** ![RRSR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rrsr/32/27766_2.png) [@RRSR](https://discuss.elastic.co/u/RRSR)\
**Post date:** [May 11, 2019, 10:34am UTC](https://discuss.elastic.co/t/kibana-visualize-page-size-is-50-000-all-of-sudden-how-to-make-it-1000-again/180526/5 "2019-05-11T10:34:24Z")

</div>

Yes, that was the case. Under the Kibana advanced settings, the field `Objects listing limit`(_Number of objects to fetch for the listing pages_) was set to 50,000 instead of the default 1000.  
After resetting it to default by clicking `Reset to default` button, the API calls are all now taking the `per_page` as 1000.

Thank you so much @Christian_Dahlqvist & @joelgriffith for the support.

PS: Somebody did change the Kibana Advanced Settings.

---

<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:** [June 8, 2019, 10:34am UTC](https://discuss.elastic.co/t/kibana-visualize-page-size-is-50-000-all-of-sudden-how-to-make-it-1000-again/180526/6 "2019-06-08T10:34:29Z")

</div>

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