Help Center> GaussDB> Distributed_2.x> Schemas> DBE_PERF Schema> File> GLOBAL_FILE_REDO_IOSTAT

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

View PDF

GLOBAL_FILE_REDO_IOSTAT

GLOBAL_FILE_REDO_IOSTAT displays statistics about redo logs (WALs) on nodes in the cluster.

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