Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-3.x)/ System Catalogs and System Views/ System Views/ GS_GLOBAL_ARCHIVE_STATUS
Updated on 2025-08-19 GMT+08:00
GS_GLOBAL_ARCHIVE_STATUS
GS_GLOBAL_ARCHIVE_STATUS describes the archiving progress of CNs and all shards, including the shard name (node_name), archiving location (restart_lsn), name of the primary or standby node (archive_node), and current log location (current_xlog_location). To query this view, you need to enable the archiving function of the database and query the view from the CN node. The monitor admin and sysadmin permissions are required.
| Name | Type | Description |
|---|---|---|
| node_name | text | Shard name. |
| restart_lsn | text | Archiving location. |
| archive_node | text | Name of the primary or standby node where archiving is performed. |
| current_xlog_location | text | Current log position. |
Parent topic: System Views
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.
