System Catalogs / Statistics views
pg_statio_all_indexes
Read the PG 18 manualThe 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.
Reading PG 18current·documented in 24 of 24 versions, 7.4 to 20
- Kind
- Statistics views
- Columns in this snapshot
- 7
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 7
As listed in the PostgreSQL 18 manual.
| 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
Version history 5
Definition snapshot: english-manuals:2f4309049310fd438230db6879c… · English manual source