Updated on 2023-04-14 GMT+08:00

GS_ROW_TABLE_IO_STAT

GS_ROW_TABLE_IO_STAT displays the I/O of all row-store tables of the database on the current node. The value of each statistical column is the accumulated value since the instance was started.

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