Help Center/ GaussDB/ Developer Guide(Centralized_2.x)/ Schemas/ DBE_PERF Schema/ File/ SUMMARY_FILE_REDO_IOSTAT

Updated on 2023-10-23 GMT+08:00

View PDF

SUMMARY_FILE_REDO_IOSTAT

SUMMARY_FILE_REDO_IOSTAT records statistics about all redo logs and WALs in the database.

**Table 1** SUMMARY_FILE_REDO_IOSTAT columns
Name	Type	Description
phywrts	numeric	Number of times writing into the WAL buffer
phyblkwrt	numeric	Number of blocks written into the WAL buffer
writetim	numeric	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: FILE_REDO_IOSTAT

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