Technologies/PostgreSQL/heap_blks_hit
PostgreSQLPostgreSQLMetric

heap_blks_hit

Heap buffer hits
Dimensions:None
Available on:DatadogDatadog (1)Native (1)PrometheusPrometheus (1)
Interface Metrics (3)
DatadogDatadog
Enabled with `relations`. The number of buffer hits in this table. This metric is tagged with db, schema, table.
Dimensions:None
Native
Number of buffer hits for table blocks
Dimensions:None
PrometheusPrometheus
Number of buffer hits in this table
Dimensions:None
Sources
postgresql.heap_blocks_hitgithub.com
heap_blks_hitgithub.com
statio_user_tables_heap_blocks_hitgithub.com

Technical Annotations (5)

Configuration Parameters (1)
shared_buffers
PostgreSQL memory cache size - increase if cache hit ratio is low
Technical References (4)
buffer cachecomponentshared_bufferscomponentDjango Debug Toolbarcomponentcache panelcomponent
Related Insights (2)
Buffer cache hit ratio below 95% causes excessive disk I/Owarning
▸
Low cache hit ratio indicates ineffective cache configurationinfo
▸