PG_STAT_SYS_INDEXES¶
PG_STAT_SYS_INDEXES displays the index status information about all the system catalogs in the pg_catalog and information_schema schemas.
Name | Type | Description |
---|---|---|
relid | oid | Table OID for the 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 |
idx_tup_read | bigint | Number of index entries returned by scans on this index |
idx_tup_fetch | bigint | Number of rows that have live data fetched by index scans |