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

PGXC_ROW_TABLE_IO_STAT

PGXC_ROW_TABLE_IO_STAT provides I/O statistics of all row-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_ROW_TABLE_IO_STAT view. For details about the columns, see Table 1.

Table 1 GS_ROW_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

toast_read

bigint

Number of blocks logically read in the TOAST table

toast_hit

bigint

Number of block hits in the TOAST table

tidx_read

bigint

Number of indexes logically read in the TOAST table

tidx_hit

bigint

Number of index hits in the TOAST table