System Catalogs / Statistics views
pg_stat_sys_indexes
Read the PG 18 manualSame as pg_stat_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
- 9
- Definition source
- English manual
Columns 9
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_scan | bigint | Number of index scans initiated on this index |
last_idx_scan | timestamp with time zone | The time of the last scan on this index, based on the most recent transaction stop time |
idx_tup_read | bigint | Number of index entries returned by scans on this index |
idx_tup_fetch | bigint | Number of live table rows fetched by simple index scans using this index |
Column history across versions
Definition snapshot: english-manuals:77ca715c03fbe70b2d3ac329c6a… · English manual source