I was looking for an efficient solution by using which i should be able to select any date range data. Example: if i want to show a performance report for 2 months or 3 days the performance of system should not be effected much. Currently, i am storing index on monthly basis but with this logic elasticsearch performance goes down as i have 5 nodes and 3 shards for each node. And ES searches for data in each 5*3 nodes which is a time consuming process. Please suggest some design for this.