# Increasing Rows per Page Limit in Kibana 8.6.2

**URL:** <https://discuss.elastic.co/t/increasing-rows-per-page-limit-in-kibana-8-6-2/336780>\
**Category:** Kibana\
**Created:** [June 23, 2023, 2:25pm UTC](https://discuss.elastic.co/t/increasing-rows-per-page-limit-in-kibana-8-6-2/336780 "2023-06-23T14:25:47Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![7a6b6f](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/7a6b6f/32/118074_2.png) [@7a6b6f](https://discuss.elastic.co/u/7a6b6f)\
**Post date:** [June 23, 2023, 2:25pm UTC](https://discuss.elastic.co/t/increasing-rows-per-page-limit-in-kibana-8-6-2/336780/1 "2023-06-23T14:25:48Z")

</div>

Hello fellow forum members,

I have been using Kibana version 8.6.2 for my data analysis needs and have come across a query regarding the "Rows per Page" limit in the Discover category of the advanced settings.

![image](https://us1.discourse-cdn.com/elastic/original/3X/c/c/cca657f09caf65414775b6efe3c8fc98188d1968.png)

By default, the limit is set to 500 rows per page.

Currently, when I query for a specific dataset, lets say I retrieve 3000 hits, Kibana limits the display to the default "Rows per Page" limit, which is set to 500. This means that I have to navigate through multiple pages to view all the hits.

Is it possible to configure it to display all 3000 hits on a single page, , without having to click through multiple pages?

If so, I would greatly appreciate any guidance or instructions on how to achieve this.

---

<div class="post-metadata">

**Author:** ![jughosta](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jughosta/32/107160_2.png) [@jughosta](https://discuss.elastic.co/u/jughosta)\
**Post date:** [June 24, 2023, 9:01am UTC](https://discuss.elastic.co/t/increasing-rows-per-page-limit-in-kibana-8-6-2/336780/2 "2023-06-24T09:01:11Z")

</div>

Hi @7a6b6f and welcome to the community!

Currently, it's not possible to set more than 500 rows per page via UI but we have plans on improving this user experience in the future.

As a workaround, you can set a custom value via `rowsPerPage:3000` param in URL, refresh the page and save the search.

---

<div class="post-metadata">

**Author:** ![7a6b6f](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/7a6b6f/32/118074_2.png) [@7a6b6f](https://discuss.elastic.co/u/7a6b6f)\
**Post date:** [June 27, 2023, 7:32am UTC](https://discuss.elastic.co/t/increasing-rows-per-page-limit-in-kibana-8-6-2/336780/3 "2023-06-27T07:32:41Z")

</div>

Save the search you mean with a csv right, etc.? Is 3000 rows the maximum because we tried 4k also and I could see them in the csv file we saved.

Thank you again very much for your help and support.

---

<div class="post-metadata">

**Author:** ![jughosta](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jughosta/32/107160_2.png) [@jughosta](https://discuss.elastic.co/u/jughosta)\
**Post date:** [June 27, 2023, 8:36am UTC](https://discuss.elastic.co/t/increasing-rows-per-page-limit-in-kibana-8-6-2/336780/4 "2023-06-27T08:36:10Z")

</div>

Saving a search via "Save" button on Discover would help to persist current `rowsPerPage` value for future use [Save a search for reuse | Kibana Guide [8.8] | Elastic](https://www.elastic.co/guide/en/kibana/current/save-open-search.html#_save_a_search)

3000 is not a limit, it's what was mentioned in the initial question.

---

<div class="post-metadata">

**Author:** ![Sandeep\_Raju](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@Sandeep\_Raju](https://discuss.elastic.co/u/Sandeep_Raju)\
**Post date:** [June 27, 2023, 10:34am UTC](https://discuss.elastic.co/t/increasing-rows-per-page-limit-in-kibana-8-6-2/336780/5 "2023-06-27T10:34:03Z")

</div>

Hi,

Can we save a search for \> 10,000 hits in any way in saved search?

Regards

---

<div class="post-metadata">

**Author:** ![jughosta](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jughosta/32/107160_2.png) [@jughosta](https://discuss.elastic.co/u/jughosta)\
**Post date:** [June 28, 2023, 10:55am UTC](https://discuss.elastic.co/t/increasing-rows-per-page-limit-in-kibana-8-6-2/336780/6 "2023-06-28T10:55:33Z")

</div>

Hi @Sandeep_Raju,

Not yet but we are working on it [[OnWeek][Discover] Allow to change current sample size and save it with a saved search by jughosta · Pull Request #157269 · elastic/kibana · GitHub](https://github.com/elastic/kibana/pull/157269)

The only configuration which is available right now is `sampleSize` on Advanced Settings page. It will be applied to all searches.

---

<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 26, 2023, 10:55am UTC](https://discuss.elastic.co/t/increasing-rows-per-page-limit-in-kibana-8-6-2/336780/7 "2023-07-26T10:55:54Z")

</div>

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