Help Center/ Data Warehouse Service / Standard Data Warehouse (9.1.0.x)/ GaussDB(DWS) System Catalogs and Views/ System Views/ PGXC_REDO_STAT
Updated on 2025-06-12 GMT+08:00
View PDF

PGXC_REDO_STAT

PGXC_REDO_STAT displays statistics on redoing Xlogs of each node in the cluster. All columns except node_name are the same as those in the PV_REDO_STAT view. Only the system administrator or the preset role gs_role_read_all_stats can access this view.

Table 1 PGXC_REDO_STAT columns

Column

Type

Description

node_name

Text

Node name

phywrts

Bigint

Number of physical writes

phyblkwrt

Bigint

Number of physical blocks written

writetim

Bigint

Time taken for physical writes

avgiotim

Bigint

Average time taken per write

lstiotim

Bigint

Time taken for the last write

miniotim

Bigint

Minimum time taken for a write

maxiowtm

Bigint

Maximum time taken for a write
Parent Topic: System Views