Elasticsearch is a powerful search and analytics engine that powers large-scale applications such as logging, search engines, and etc.

When working in development mode, where you might have a small database for testing purposes, you may encounter an instance where you must fetch all the records from the database.

In this post, you will learn how to use the Elasticsearch search query to fetch all the records from a given index.

Using Search and Wildcard Character

We can use the Elasticsearch search query and the wildcard parameter to fetch all the records from a given index. The syntax is as shown:

 
For example, suppose we have an index called Disney holding all the Disney Movies and TV shows records. If we wish to retrieve the first ten records from the index using the search query, we can run the request as shown below:

 
Running the request above should return the queried documents. An example output is as shown:

Using Elasticsearch Scan Search Type

Another method of fetching all the records from an index is using the scan search type. The syntax is as shown:

 
It is good to remember that the scan search is deprecated in recent versions of Elasticsearch. It is recommended to use the scroll feature. You can learn more about that in the scroll elastic search tutorial.

An example is as shown:

 
Similarly, the request above should fetch all the documents in the index as shown in the sample output below:

Conclusion

In this post, you discovered two main methods of fetching all the documents from a given Elasticsearch index.