# Pulling more than 10000 records from elasticsearch query

**URL:** <https://discuss.elastic.co/t/pulling-more-than-10000-records-from-elasticsearch-query/181000>\
**Category:** Elasticsearch\
**Created:** [May 14, 2019, 12:23pm UTC](https://discuss.elastic.co/t/pulling-more-than-10000-records-from-elasticsearch-query/181000 "2019-05-14T12:23:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ninder.singh](https://avatars.discourse-cdn.com/v4/letter/n/3ab097/32.png) [@ninder.singh](https://discuss.elastic.co/u/ninder.singh)\
**Post date:** [May 14, 2019, 12:23pm UTC](https://discuss.elastic.co/t/pulling-more-than-10000-records-from-elasticsearch-query/181000/1 "2019-05-14T12:23:10Z")

</div>

We can get maximum 10000 records by using size parameter.  
What if we get more than 20000 records after applying filter query.  
Please update if there is any way to see records beyond 10000.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [May 14, 2019, 3:16pm UTC](https://discuss.elastic.co/t/pulling-more-than-10000-records-from-elasticsearch-query/181000/2 "2019-05-14T15:16:51Z")

</div>

You can use [`size` and `from` parameters](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-from-size.html) to display by default up to 10000 records to your users. If you want to change this limit, you can change `index.max_result_window` setting but be aware of the consequences (ie memory).  
You can use the [search after](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-search-after.html) feature to do deep pagination.  
You can use the [Scroll API](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-scroll.html) if you want to extract a resultset to be consumed by another tool later.

---

<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 11, 2019, 3:16pm UTC](https://discuss.elastic.co/t/pulling-more-than-10000-records-from-elasticsearch-query/181000/3 "2019-06-11T15:16:52Z")

</div>

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