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.
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 |