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.
