Find out which indices are used most frequently

Elastic Stack Elasticsearch
1

Hello,

is there any way to find out which indices are queried the most?

One way would be to use the webserver/kibana logs, but I'm wondering if there is another.

I'm running a hot/cold architecture in our production cluster right now and I'm evaluating for how long the data should stay on the hot nodes.

Luca

2

You can use the indices stats API, which will tell you per index, how often it's being searched and indexed, by exposing a total count of these operations. By comparing two samples you can calculate what you need, similarly to what Marvel does (or you can just install marvel, it's basic version is free).

1 Like
3

Ok, thanks a lot!

Looking forward to elasticON! :slight_smile: