Technologies/PostgreSQL/postgresql.index_blocks_read
PostgreSQLPostgreSQLMetric

postgresql.index_blocks_read

Index blocks read from disk
Dimensions:None
Available on:DatadogDatadog (2)Native (1)PrometheusPrometheus (1)
Interface Metrics (4)
DatadogDatadog
Total number of blocks to be processed in the current phase. Only available with PostgreSQL 12 and newer. This metric is tagged with db, table, index, command, phase.
Dimensions:None
DatadogDatadog
Enabled with `relations`. The number of disk blocks read from this table's TOAST table index. This metric is tagged with db, schema, table.
Dimensions:None
Native
Number of disk blocks read from indexes
Dimensions:None
PrometheusPrometheus
Number of disk blocks read from all indexes on this table
Dimensions:None
Sources
postgresql.create_index.blocks_totalgithub.com
postgresql.toast_index_blocks_readgithub.com
idx_blks_readgithub.com
statio_user_tables_idx_blocks_readgithub.com

Technical Annotations (5)

CLI Commands (1)
CREATE INDEX CONCURRENTLY ON cities (country_code) INCLUDE (id, latitude, longitude);remediation
Technical References (4)
covering indexconceptIndex Only ScanconceptINCLUDEconceptHeap Fetchesconcept
Related Insights (1)
Covering indexes reduce heap access but require clean visibility mapinfo
▸