PG_STAT_USER_INDEXES
PG_STAT_USER_INDEXES displays information about the index status of user-defined ordinary tables and TOAST tables.
Table 1 PG_STAT_USER_INDEXES columns
Name
|
Type
|
Description
|
|---|
relid
|
oid
|
OID of the table for this index
|
indexrelid
|
oid
|
OID of the index
|
schemaname
|
name
|
Name of the schema that the index is in
|
relname
|
name
|
Name of the table for the index
|
indexrelname
|
name
|
Index name
|
idx_scan
|
bigint
|
Number of index scans initiated on the index
|
last_idx_scan
|
timestamptz
|
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 the index
|
idx_tup_fetch
|
bigint
|
Number of live table rows fetched by simple index scans using the index
|