Updated on 2024-11-05 GMT+08:00

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.

Table 1 GS_COLUMN_TABLE_IO_STAT columns

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