System Catalogs / Statistics views
pg_stat_user_indexes
Read the PG 18 manualSame as pg_stat_all_indexes, except that only indexes on user 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:da2785f88dcc17649ce824fd8ed… · English manual source