Help Center/ GaussDB/ Developer Guide(Centralized_8.x)/ Schemas/ DBE_PERF Schema/ File/ GLOBAL_FILE_REDO_IOSTAT

Updated on 2024-06-03 GMT+08:00

View PDF

GLOBAL_FILE_REDO_IOSTAT

Displays statistics about redo logs (WALs) on nodes in the database, as shown in Table 1.

**Table 1** GLOBAL_FILE_REDO_IOSTAT columns
Name	Type	Description
node_name	name	Node name
phywrts	bigint	Number of times writing into the WAL buffer
phyblkwrt	bigint	Number of blocks written into the WAL buffer
writetim	bigint	Duration of writing into Xlog files (unit: μs)
avgiotim	bigint	Average duration of writing into Xlog files (unit: μs). avgiotim = writetim/phywrts
lstiotim	bigint	Duration of the last writing into Xlog files (unit: μs)
miniotim	bigint	Minimum duration of writing into Xlog files (unit: μs)
maxiowtm	bigint	Maximum duration of writing into Xlog files (unit: μs)

Parent topic: File

Previous topic: SUMMARY_FILE_REDO_IOSTAT

Next topic: LOCAL_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.