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 Table 1. The value of each statistical column is the sum of the values of the corresponding columns of all nodes.
|
Column |
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.