SUMMARY_FILE_REDO_IOSTAT
Records statistics about all redo logs and WALs on all nodes in the database. The values of the phywrts, phyblkwrt, and writetim columns are accumulated based on the data of each node. The value of avgiotim is the average value of each node (summed up writetim or phywrts). The values of lstiotim and maxiowtm are the maximum values of each node, and the value of miniotim is the minimum value of each node.
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). |
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