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.
|
Column |
Type |
Description |
|---|---|---|
|
schemaname |
Name |
Namespace of a table |
|
relname |
Name |
Name of a table |
|
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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.