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

itizir (Diego Becciolini) July 6, 2020, 10:16am 3

Oh btw, if you investigate the performance of time range filters, I'd be interested to hear whether you also see this...

Topic		Replies	Views
Time range query performance [7.6] Elasticsearch	18	5163	May 5, 2020
Range filter performance consideration Elasticsearch	3	873	July 5, 2017
Time based indices query strategy Elasticsearch	7	492	January 27, 2019
Kibana search performance over time-based indices Kibana	10	1759	March 22, 2019
Efficient way of storing data in index to support date range filter Elasticsearch	4	451	August 16, 2018

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