PostgreSQL 19 ← 18
← Catalog atlas / pg_stat_sys_indexes
STATISTICS VIEW · Statistics view
pg_stat_sys_indexes
Same as pg_stat_all_indexes, except that only indexes on system tables are shown.
Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗
Columns PostgreSQL 18
pg_stat_sys_indexesPostgreSQL 19 beta 3 is a preview snapshot; the structure can still change before release.
| COLUMN | TYPE | DESCRIPTION |
|---|---|---|
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 |
Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.
Common system columns 0
System attributes PostgreSQL provides, normally not expanded by SELECT *. Kept separately so they are not mixed in with ordinary columns.
| Columns | Type | attnum |
|---|
Column evolution matrix
Hover a cell for the column typePresentAdded / type or attribute changeRemoved
9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.
Evolution timeline
Changes between adjacent majorsPostgreSQL 16 ← 15
PostgreSQL 9.2 ← 9.1
Compare any two versions
Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.