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

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