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