Bit new to Elasticsearch. When limiting the date range of a query (for example if I have a daily index of events and I'd like to search within only a non-aligned monthly cycle), is it worth optimising the index pattern? My application exposes a query API which is internally translated into an Elast…

Elasticsearch is quite efficient when it comes to filtering out shards that do not have any data within a time range, so I would recommend testing to see what the difference is for your specific scenario as it may vary depending on data and number of indices and shards.

Discuss the Elastic Stack

Performance querying time-based indices in a date range

Elastic Stack Elasticsearch

system (system) Closed August 3, 2020, 10:16am 4

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

Topic		Replies	Views
Efficient time-based multi index searches in ES6 Elasticsearch	5	457	August 22, 2018
Elastic Search Date Range queries Elasticsearch	2	439	July 6, 2017
Efficient date range handling Elasticsearch	4	2726	July 6, 2017
Bad response time when using date ranges Elasticsearch	6	683	July 6, 2017
Improve Query Performance Elasticsearch	10	466	July 6, 2017

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Performance querying time-based indices in a date range

Related topics