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
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.
| 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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
