Cache Hit Ratio Metric

Cache hit ratio is a metric that measures the efficiency of key retrieval in a database.

Cache hit ratio is the ratio of key hits against the total number of key hits and misses.

PostgreSQL

The cache hit ratio plot tracks read efficiency, measured by the proportion of reads from cache versus the total reads from both disk and cache. With the exception of data warehouse use cases, an ideal cache hit ratio is 99% or higher, meaning that at least 99% of reads are from cache and no more than 1% are from disk.

Database cache hit ratio graph

If your cache hit ratio is consistently lower than 99%, consider upgrading to a plan with additional memory to increase your cache size.

For more information on monitoring PostgreSQL clusters, see How to Monitor PostgreSQL Database Performance.

Caching

The cache hit ratio plot displays the efficiency of key retrieval from the Caching cache. The Caching cache defines the ratio of key hits to the total number of key hits and misses. Key misses occur when a key has been expired or evicted from the cache, or it never existed.

Caching cache hit ratio plot

For optimal responsiveness, keep your cache hit ratio at 0.8 or higher.

For more information on monitoring Caching clusters, see How to Monitor Caching Database Cluster Performance.

Cache Hit Ratio Metric Articles

Access and interpret Caching database performance metrics.
Choose and set eviction policies for your Caching database clusters
Access and understand performance metrics for nodes in a database cluster.