I've 1000s of day-wise (time-based) indices in my cluster. Is there a way to monitor or find out at the ES Server side which indices
return data when a query makes use of an
alias . E.g. consider the below query that my customer fires:
index_alias is mapped to all the
day-wise indices in the ES 6.8.6 cluster and they total
1200. The reason being the query is used to fetch historical records for that
Product_Serial_Num. Thus it is not possible to know beforehand which day-wise index would have data. That's the reason the
index_alias is mapped to
all indices. When the customer fires the above query, I would like to monitor this at the ES Server side and find out which
indices actually return the data when the query hits them. Is there a way to determine this without modifying anything at the customer end?
The purpose of this is to figure out the "which indices" are being hit the most, like
last-n-days (30, 60, 90) and then apply hot-warm architecture accordingly like having last 60 days indices on hot nodes and rest on warm nodes.
Or if there are better ways to determine, please do share.