System Catalogs / Statistics views
pg_statio_sys_indexes
Read the PG 18 manualSame as pg_statio_all_indexes, except that only indexes on system tables are shown.
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
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
Definition snapshot: english-manuals:a2c30f27d8780f6d2fdf10f5401… · English manual source