pg_statio_user_indexes

The pg_statio_all_indexes view will contain one row for each index in the current database, showing statistics about I/O on that specific index.

Columns 7

Column	Type	Description / reference
`relid`	`oid`	OID of the table for this index
`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 this index
`idx_blks_hit`	`bigint`	Number of buffer hits in this index

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`relid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`indexrelid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`schemaname`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`relname`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`indexrelname`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`idx_blks_read`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`idx_blks_hit`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`stats_reset`	·	·	·	·	·	·	·	·	·	·	·	·	·	·	·	·	●	●

Version history 2

Definition snapshot: english-manuals:41824397c04c4159f522977362a… · English manual source