Help Center/
GaussDB(DWS)/
Standard Data Warehouse (9.1.0.x)/
GaussDB(DWS) System Catalogs and Views/
System Views/
PG_STAT_USER_INDEXES
Updated on 2024-09-30 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.
|
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 |
Parent topic: System Views
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.
