STAT_ALL_INDEXES
Displays the access information about each index on the current database node.
Name |
Type |
Description |
---|---|---|
relid |
oid |
OID of the table that the index is created for |
indexrelid |
oid |
OID of the index |
schemaname |
name |
Name of the schema where the index is located. |
relname |
name |
Name of the table for the index |
indexrelname |
name |
Index name |
idx_scan |
bigint |
Number of index scans performed on the index. |
idx_tup_read |
bigint |
Number of index entries returned by scans on the index. |
idx_tup_fetch |
bigint |
Number of live rows fetched in the original table by a simple index scan that uses the index. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot