GLOBAL_COLUMN_TABLE_IO_STAT
GLOBAL_COLUMN_TABLE_IO_STAT provides I/O statistics of all column-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_COLUMN_TABLE_IO_STAT view. For details about the columns, see GLOBAL_COLUMN_TABLE_IO_STAT. 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 |
Table name |
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 |
cu_read |
bigint |
Number of logical reads in the Compression Unit |
cu_hit |
bigint |
Number of hits in the Compression Unit |
cidx_read |
bigint |
Number of indexes logically read in the Compression Unit |
cidx_hit |
bigint |
Number of index hits in the Compression Unit |
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