# Filter Cache Statistics

**URL:** <https://discuss.elastic.co/t/filter-cache-statistics/68330>\
**Category:** Elasticsearch\
**Created:** [December 7, 2016, 4:36pm UTC](https://discuss.elastic.co/t/filter-cache-statistics/68330 "2016-12-07T16:36:43Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![manast](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/manast/32/13705_2.png) [@manast](https://discuss.elastic.co/u/manast)\
**Post date:** [December 7, 2016, 4:36pm UTC](https://discuss.elastic.co/t/filter-cache-statistics/68330/1 "2016-12-07T16:36:43Z")

</div>

Hello,

the query cache statistics of my cluster contain following values:  
"query\_cache": {  
"memory\_size\_in\_bytes": 113744184,  
"total\_count": 394174905,  
"hit\_count": 17192100,  
"miss\_count": 376982805,  
"cache\_size": 6859,  
"cache\_count": 59078,  
"evictions": 52219  
}

I was wondering what these values really mean.  
In other words, is this cache overused or rather underused.  
And if it is underused what options do we have? Increasing indices.queries.cache.size?

Thanks,  
Michail

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [December 8, 2016, 2:48am UTC](https://discuss.elastic.co/t/filter-cache-statistics/68330/2 "2016-12-08T02:48:23Z")

</div>

You should really be looking at this in terms of changes over time, so are `miss_count` or `evictions` increasing dramatically, or slowly?

---

<div class="post-metadata">

**Author:** ![manast](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/manast/32/13705_2.png) [@manast](https://discuss.elastic.co/u/manast)\
**Post date:** [December 8, 2016, 8:17am UTC](https://discuss.elastic.co/t/filter-cache-statistics/68330/3 "2016-12-08T08:17:13Z")

</div>

Below are the current values. As you can see, after almost 18 hours the memory\_size\_in\_bytes dropped 50% while miss\_count increased significantly. Evictions increased but not much.

What would you propose based on that?

"query\_cache": {  
"memory\_size\_in\_bytes": 47289528,  
"total\_count": 532629646,  
"hit\_count": 21149807,  
"miss\_count": 511479839,  
"cache\_size": 3169,  
"cache\_count": 70321,  
"evictions": 67152  
}

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [December 8, 2016, 8:24am UTC](https://discuss.elastic.co/t/filter-cache-statistics/68330/4 "2016-12-08T08:24:29Z")

</div>

Depends, are you having problems?

---

<div class="post-metadata">

**Author:** ![manast](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/manast/32/13705_2.png) [@manast](https://discuss.elastic.co/u/manast)\
**Post date:** [December 8, 2016, 8:33am UTC](https://discuss.elastic.co/t/filter-cache-statistics/68330/5 "2016-12-08T08:33:21Z")

</div>

We have filter queries that take a long time to execute. As I understood such queries are using the cache, therefore I was wondering if the cache settings play a role here.

The queries are using range conditions on date fields, in some cases "lt" \< "now"

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [December 8, 2016, 8:43am UTC](https://discuss.elastic.co/t/filter-cache-statistics/68330/6 "2016-12-08T08:43:45Z")

</div>

Ok, what version are you on?

---

<div class="post-metadata">

**Author:** ![manast](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/manast/32/13705_2.png) [@manast](https://discuss.elastic.co/u/manast)\
**Post date:** [December 8, 2016, 8:45am UTC](https://discuss.elastic.co/t/filter-cache-statistics/68330/7 "2016-12-08T08:45:26Z")

</div>

We are using 2.2

---

<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:** [January 5, 2017, 8:45am UTC](https://discuss.elastic.co/t/filter-cache-statistics/68330/8 "2017-01-05T08:45:30Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.