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

GS_REDO_STAT

GS_REDO_STAT displays the log replay of session threads.

Table 1 GS_REDO_STAT columns

Name

Type

Description

phywrts

bigint

Number of times that data is written during log replay.

phyblkwrt

bigint

Number of data blocks written during log replay.

writetim

bigint

Total time required for writing data during log replay.

avgiotim

bigint

Average time required for writing data during log replay.

lstiotim

bigint

Time consumed by the last data write operation during log replay.

miniotim

bigint

Minimum time consumed by a single data write operation during log replay.

maxiowtm

bigint

Maximum time consumed by a single data write operation during log replay.