# Why doc\_values\_memory\_in\_bytes is small?

**URL:** <https://discuss.elastic.co/t/why-doc-values-memory-in-bytes-is-small/147196>\
**Category:** Elasticsearch\
**Created:** [September 4, 2018, 11:34am UTC](https://discuss.elastic.co/t/why-doc-values-memory-in-bytes-is-small/147196 "2018-09-04T11:34:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bruce88](https://avatars.discourse-cdn.com/v4/letter/b/b3f665/32.png) [@bruce88](https://discuss.elastic.co/u/bruce88)\
**Post date:** [September 4, 2018, 11:34am UTC](https://discuss.elastic.co/t/why-doc-values-memory-in-bytes-is-small/147196/1 "2018-09-04T11:34:26Z")

</div>

We have a cluster with 12 m4.4xlarge nodes (m4.4xlarge: 16vcores, 64GB memory). All the fields are keyword or long type. The cluster has about 4TB data, 24 indices, and 370 shards, 34.8 billions data. ES version is 5.5.2.

We found some aggregation search are very slow, which need about 15 seconds to return. These search are very ordinary which has one or two term filter and one term aggregations and one sum aggregation. Is this performance normal?

We checked the cluster stats, and found that doc\_values\_memory\_in\_bytes is very small. As we have about 32GB memory for OS on one node, why this value is so small. Does it mean that all the doc\_values are in disk, not cache? Supposed it's big, will it be helpful to the performance? And how to tune it?

> "docs" : {  
> "count" : 34823973828,  
> "deleted" : 0  
> },  
> "store" : {  
> "size\_in\_bytes" : 4223269441404,  
> "throttle\_time\_in\_millis" : 0  
> },  
> "fielddata" : {  
> "memory\_size\_in\_bytes" : 1756552,  
> "evictions" : 0  
> },  
> "query\_cache" : {  
> "memory\_size\_in\_bytes" : 30830935905,  
> "total\_count" : 30419291,  
> "hit\_count" : 21286292,  
> "miss\_count" : 9132999,  
> "cache\_size" : 8407,  
> "cache\_count" : 8407,  
> "evictions" : 0  
> },  
> "completion" : {  
> "size\_in\_bytes" : 0  
> },  
> "segments" : {  
> "count" : 2290,  
> "memory\_in\_bytes" : 32573158916,  
> "terms\_memory\_in\_bytes" : 29482647034,  
> "stored\_fields\_memory\_in\_bytes" : 1789047616,  
> "term\_vectors\_memory\_in\_bytes" : 0,  
> "norms\_memory\_in\_bytes" : 128,  
> "points\_memory\_in\_bytes" : 1298264922,  
> "doc\_values\_memory\_in\_bytes" : 3199216,  
> "index\_writer\_memory\_in\_bytes" : 0,  
> "version\_map\_memory\_in\_bytes" : 0,  
> "fixed\_bit\_set\_memory\_in\_bytes" : 0,  
> "max\_unsafe\_auto\_id\_timestamp" : 1535587593485,  
> "file\_sizes" : { }

---

<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:** [October 2, 2018, 11:34am UTC](https://discuss.elastic.co/t/why-doc-values-memory-in-bytes-is-small/147196/2 "2018-10-02T11:34:27Z")

</div>

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