Help Center/GaussDB/Developer Guide(Distributed_V2.0-2.x)/System Catalogs and System Views/System Views/PG_STATIO_USER_INDEXES
Updated on 2025-08-19 GMT+08:00
PG_STATIO_USER_INDEXES
PG_STATIO_USER_INDEXES displays I/O status information about all the user relationship table indexes in the namespaces.
Name | Type | Description |
|---|---|---|
relid | oid | OID of the table for this index. |
indexrelid | oid | OID of this index. |
schemaname | name | Name of the schema that this index is in. |
relname | name | Name of the table for this index. |
indexrelname | name | Index name. |
idx_blks_read | bigint | Number of disk blocks read from this index. |
idx_blks_hit | bigint | Number of cache hits in this index. |
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.
