Help Center/ GaussDB/ Distributed_8.x/ Schemas/ DBE_PERF Schema/ File/ GLOBAL_FILE_REDO_IOSTAT

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

View PDF

GLOBAL_FILE_REDO_IOSTAT

Displays statistics about redo logs (WALs) on nodes in the cluster, as described in Table 1.

**Table 1** GLOBAL_FILE_REDO_IOSTAT columns
Name	Type	Description
node_name	name	Node name.
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).