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

SUMMARY_FILE_REDO_IOSTAT

Displays statistics about redo logs (WALs) on all nodes in the cluster. 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.

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). The value is writetim divided by 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).