GLOBAL_ROW_TABLE_IO_STAT

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

View PDF

GLOBAL_ROW_TABLE_IO_STAT provides I/O statistics of all row-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_ROW_TABLE_IO_STAT view. For details about the columns, see Table 1. The value of each statistical column is the sum of the values of the corresponding columns of all nodes.

**Table 1** **GS_ROW_TABLE_IO_STAT** columns
Name	Type	Description
schemaname	name	Table namespace
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