# Elasticsearch query to return all records

**URL:** <https://discuss.elastic.co/t/elasticsearch-query-to-return-all-records/180099>\
**Category:** Elasticsearch\
**Created:** [May 8, 2019, 5:57am UTC](https://discuss.elastic.co/t/elasticsearch-query-to-return-all-records/180099 "2019-05-08T05:57:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lauren69](https://avatars.discourse-cdn.com/v4/letter/l/eb9ed0/32.png) [@Lauren69](https://discuss.elastic.co/u/Lauren69)\
**Post date:** [May 8, 2019, 5:57am UTC](https://discuss.elastic.co/t/elasticsearch-query-to-return-all-records/180099/1 "2019-05-08T05:57:52Z")

</div>

I have a small database in Elasticsearch and for testing purposes would like to pull all records back. I am attempting to use a URL of the form...

```
http://localhost:9200/foo/_search?pretty=true&q={'matchAll':{''}}

```

Can someone give me the URL you would use to accomplish this, please [feedback](https://www.mykfcexperience.vip/)?

---

<div class="post-metadata">

**Author:** ![johnrabi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/johnrabi/32/67223_2.png) [@johnrabi](https://discuss.elastic.co/u/johnrabi)\
**Post date:** [May 8, 2019, 6:00am UTC](https://discuss.elastic.co/t/elasticsearch-query-to-return-all-records/180099/2 "2019-05-08T06:00:38Z")

</div>

hi @Lauren69,

can you run this query for getting all the documents in elasticsearch

```
  URI search:
 ===========
   http://localhost:9200/foo/_search?size=5&q=*:*

```

OR  
curl -X GET "localhost:9200/foo/\_search" -H 'Content-Type: application/json' -d'  
{  
"query": {  
"match\_all": {}  
}  
}  
'  
Ref: [https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-match-all-query.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-match-all-query.html)

---

<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 8, 2019, 7:19am UTC](https://discuss.elastic.co/t/elasticsearch-query-to-return-all-records/180099/3 "2019-05-08T07:19:44Z")

</div>

```
http://localhost:9200/foo/_search?size=10000
```

---

<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 5, 2019, 7:19am UTC](https://discuss.elastic.co/t/elasticsearch-query-to-return-all-records/180099/4 "2019-06-05T07:19:45Z")

</div>

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