Help Center> GaussDB> Centralized_3.x> Schemas> DBE_PERF Schema> File> SUMMARY_FILE_REDO_IOSTAT

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

View PDF

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.

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