GS_ROW_TABLE_IO_STAT

Updated on 2023-10-31 GMT+08:00

View PDF

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