GLOBAL_COLUMN_TABLE_IO_STAT

Updated on 2024-12-19 GMT+08:00

View PDF

GLOBAL_COLUMN_TABLE_IO_STAT provides I/O statistics of all column-store tables in the current database. The names, types, and sequence of the columns are the same as those in the GS_COLUMN_TABLE_IO_STAT view. The value of each statistical column is the sum of the values of the corresponding columns of all nodes.

**Table 1** **GLOBAL_COLUMN_TABLE_IO_STAT** columns
Name	Type	Description
schemaname	name	Table namespace
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