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

Updated on 2024-11-05 GMT+08:00

View PDF

GLOBAL_REDO_STAT

GLOBAL_REDO_STAT displays the total statistics of XLOG redo operations on all nodes in a cluster. Except the avgiotim column (indicating the average redo write time of all nodes), the names of the other columns in this view are the same as those in the PV_REDO_STAT view. The respective meanings of the other columns are the sum of the values of the same columns in the PV_REDO_STAT view on each node.

**Table 1** GLOBAL_REDO_STAT columns
Column	Type	Description
phywrts	bigint	Total number of physical writes on all nodes
phyblkwrt	bigint	Total number of physical write blocks on all nodes
writetim	bigint	Total physical write time of all nodes
avgiotim	bigint	Average redo write time of all nodes
lstiotim	bigint	Sum of the last write time of all nodes
miniotim	bigint	Sum of the minimum write time of all nodes
maxiowtm	bigint	Sum of the maximum write time of all nodes

Only users with system administrator permissions can access this view.

Parent topic: System Views

Previous topic: GLOBAL_COLUMN_TABLE_IO_STAT

Next topic: GLOBAL_REL_IOSTAT

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.