PGXC_ROW_TABLE_IO_STAT
PGXC_ROW_TABLE_IO_STAT provides I/O statistics of all row-store tables of the database on all CNs and DNs in the cluster. Except the nodename column of the name type added in front of each row, the names, types, and sequences of other columns are the same as those in the GS_ROW_TABLE_IO_STAT view. For details about the columns, see Table 1.
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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot