FILE_REDO_IOSTAT

FILE_REDO_IOSTAT records statistics about redo logs (WALs) on the current node.

Table 1 FILE_REDO_IOSTAT columns

Name	Type	Description
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)

FILE_REDO_IOSTAT ​