Updated on 2025-07-22 GMT+08:00

PG_STATIO_ALL_INDEXES

PG_STATIO_ALL_INDEXES displays I/O statistics of all indexes in the current database.

**Table 1** PG_STATIO_ALL_INDEXES columns
Column	Type	Description
relid	OID	OID of the index table
indexrelid	OID	OID of this index
schemaname	Name	Name of the schema this index is in
relname	Name	Name of the table for this index
indexrelname	Name	Name of this index
idx_blks_read	Bigint	Number of disk blocks read from the index
idx_blks_hit	Bigint	Number of buffer hits in this index

Parent Topic: System Views