GaussDB-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. For details about the columns, see Table 1.
| 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. |
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…
