Help Center/ GaussDB/ Centralized_8.x/ Schemas/ DBE_PERF Schema/ File/ SUMMARY_FILE_REDO_IOSTAT

Updated on 2024-06-03 GMT+08:00

View PDF

SUMMARY_FILE_REDO_IOSTAT

Records redo log (WAL) statistics of all nodes in the database, as shown in Table 1. The values of phywrts, phyblkwrt, and writetim are summed up based on the data of each node. avgiotim is the average value (summed up writetim or phywrts) of each node. lstiotim and maxiowtm are the maximum values of each node. 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)