# Kibana search limit rows (top 20)

**URL:** https://discuss.elastic.co/t/kibana-search-limit-rows-top-20/77839
**Category:** Kibana
**Created:** [March 8, 2017, 2:58pm UTC](https://discuss.elastic.co/t/kibana-search-limit-rows-top-20/77839 "2017-03-08T14:58:36Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Exocomp](https://avatars.discourse-cdn.com/v4/letter/e/ea5d25/32.png) [@Exocomp](https://discuss.elastic.co/u/Exocomp)
#### Post date: [March 8, 2017, 2:58pm UTC](https://discuss.elastic.co/t/kibana-search-limit-rows-top-20/77839/1 "2017-03-08T14:58:36Z")

</div>

How can I use the Kibana search interface to limit to 20 rows ?

I looked here [https://www.elastic.co/guide/en/elasticsearch/reference/5.2/query-dsl-query-string-query.html#query-string-syntax](https://www.elastic.co/guide/en/elasticsearch/reference/5.2/query-dsl-query-string-query.html#query-string-syntax) and here [https://lucene.apache.org/core/2\_9\_4/queryparsersyntax.html](https://lucene.apache.org/core/2_9_4/queryparsersyntax.html) but I'm not seeing it.

---

<div class="post-metadata">

### Author: ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)
#### Post date: [March 8, 2017, 5:04pm UTC](https://discuss.elastic.co/t/kibana-search-limit-rows-top-20/77839/2 "2017-03-08T17:04:30Z")

</div>

@Exocomp are you using the Discover app and looking to limit to 20 rows? You can currently configure this for all of Discover by going to "Management" -\> "Advanced Settings" and changing the "discover:sampleSize" setting.

---

<div class="post-metadata">

### Author: ![Exocomp](https://avatars.discourse-cdn.com/v4/letter/e/ea5d25/32.png) [@Exocomp](https://discuss.elastic.co/u/Exocomp)
#### Post date: [March 8, 2017, 5:28pm UTC](https://discuss.elastic.co/t/kibana-search-limit-rows-top-20/77839/3 "2017-03-08T17:28:08Z")

</div>

@Brandon_Kobel

What if i was to create a table using the visualize tab, how could I limit the rows ?

---

<div class="post-metadata">

### Author: ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)
#### Post date: [March 9, 2017, 12:30pm UTC](https://discuss.elastic.co/t/kibana-search-limit-rows-top-20/77839/4 "2017-03-09T12:30:02Z")

</div>

You can use the 'Size' input to control the number of results returned:

 ![](https://us1.discourse-cdn.com/elastic/original/3X/3/5/353dcbc418274f67779fd2d7b8233abdb9036afd.png)

If you're using the DataTable visualization, you can also control the number of results that are returned per page:

 ![](https://us1.discourse-cdn.com/elastic/original/3X/d/9/d951bc597808b56f92d0284f6dbd9a135b20d759.png)

---

<div class="post-metadata">

### Author: ![Exocomp](https://avatars.discourse-cdn.com/v4/letter/e/ea5d25/32.png) [@Exocomp](https://discuss.elastic.co/u/Exocomp)
#### Post date: [March 9, 2017, 2:35pm UTC](https://discuss.elastic.co/t/kibana-search-limit-rows-top-20/77839/5 "2017-03-09T14:35:24Z")

</div>

@Brandon_Kobel gotcha, thank you!

---

<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: [April 6, 2017, 2:35pm UTC](https://discuss.elastic.co/t/kibana-search-limit-rows-top-20/77839/6 "2017-04-06T14:35:41Z")

</div>

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