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

PGXC_COLUMN_TABLE_IO_STAT

PGXC_COLUMN_TABLE_IO_STAT provides I/O statistics of all column-store tables of the database on all CNs and DNs in the cluster. Except the nodename column of the name type added in front of each row, the names, types, and sequences of other columns are the same as those in the GS_COLUMN_TABLE_IO_STAT view. For details about the columns, see Table 1.

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