SUMMARY_STAT_ALL_INDEXES
Displays the access statistics of each index on each database node in a cluster. It is used on CNs. The access statistics of each node index are summed up. The timestamp column is not summed up, and only the latest value of the column on all nodes is used, as described in Table 1.
Name |
Type |
Description |
---|---|---|
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 |
numeric |
Number of index scans performed on the index. |
idx_tup_read |
numeric |
Number of index entries returned by scans on the index. |
idx_tup_fetch |
numeric |
Number of live rows fetched in the original table by a simple index scan that uses the index. |
last_updated |
timestamp with time zone |
Time when the monitoring data of the index in the view is updated for the last time. |
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