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

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)