# Find out which indices are used most frequently

**URL:** https://discuss.elastic.co/t/find-out-which-indices-are-used-most-frequently/40023
**Category:** Elasticsearch
**Created:** [January 25, 2016, 12:54pm UTC](https://discuss.elastic.co/t/find-out-which-indices-are-used-most-frequently/40023 "2016-01-25T12:54:46Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![lwintergerst](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lwintergerst/32/18164_2.png) [@lwintergerst](https://discuss.elastic.co/u/lwintergerst)
#### Post date: [January 25, 2016, 12:54pm UTC](https://discuss.elastic.co/t/find-out-which-indices-are-used-most-frequently/40023/1 "2016-01-25T12:54:46Z")

</div>

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

---

<div class="post-metadata">

### Author: ![bleskes](https://avatars.discourse-cdn.com/v4/letter/b/71c47a/32.png) [@bleskes](https://discuss.elastic.co/u/bleskes)
#### Post date: [January 25, 2016, 1:36pm UTC](https://discuss.elastic.co/t/find-out-which-indices-are-used-most-frequently/40023/2 "2016-01-25T13:36:26Z")

</div>

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).

---

<div class="post-metadata">

### Author: ![lwintergerst](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lwintergerst/32/18164_2.png) [@lwintergerst](https://discuss.elastic.co/u/lwintergerst)
#### Post date: [January 25, 2016, 1:37pm UTC](https://discuss.elastic.co/t/find-out-which-indices-are-used-most-frequently/40023/3 "2016-01-25T13:37:53Z")

</div>

Ok, thanks a lot!

Looking forward to elasticON! 🙂

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 5, 2017, 11:21pm UTC](https://discuss.elastic.co/t/find-out-which-indices-are-used-most-frequently/40023/4 "2017-07-05T23:21:56Z")

</div>


