Help Center/ GaussDB(DWS)/ Developer Guide/ Standard data warehouse (8.3.0.x)/ GaussDB(DWS) System Catalogs and Views/ System Views/ GS_ROW_TABLE_IO_STAT

Updated on 2024-04-30 GMT+08:00

View PDF

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.

**Table 1** GS_ROW_TABLE_IO_STAT columns
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

Parent topic: System Views

Previous topic: GS_RESPOOL_MONITOR

Next topic: GS_SESSION_CPU_STATISTICS

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.