Help Center/ GaussDB/ Distributed_3.x/ Schemas/ DBE_PERF Schema/ File/ FILE_REDO_IOSTAT

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

View PDF

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). 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).