Help Center/Data Warehouse Service/Standard Data Warehouse (9.1.0.x)/DWS System Catalogs and Views/System Views/PG_STAT_USER_INDEXES
Updated on 2025-10-09 GMT+08:00
PG_STAT_USER_INDEXES
PG_STAT_USER_INDEXES displays information about the index status of user-defined ordinary tables and TOAST tables.
Column | 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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
