GLOBAL_ROW_TABLE_IO_STAT
GLOBAL_ROW_TABLE_IO_STAT provides I/O statistics of all row-store tables in the current database. The names, types, and sequences of the columns in the view are the same as those in the GS_ROW_TABLE_IO_STAT view. For details about the columns, see Table 1. The value of each statistical column is the sum of the values of the corresponding columns of all nodes.
Name |
Type |
Description |
---|---|---|
schemaname |
name |
Namespace of a table |
relname |
name |
Name of a table |
heap_read |
bigint |
Number of blocks logically read in the heap |
heap_hit |
bigint |
Number of block hits in the heap |
idx_read |
bigint |
Number of blocks logically read in the index |
idx_hit |
bigint |
Number of block hits in the index |
toast_read |
bigint |
Number of blocks logically read in the TOAST table |
toast_hit |
bigint |
Number of block hits in the TOAST table |
tidx_read |
bigint |
Number of indexes logically read in the TOAST table |
tidx_hit |
bigint |
Number of index hits in the TOAST table |
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