Help Center/ GaussDB/ Developer Guide(Distributed_8.x)/ System Catalogs and System Views/ System Views/ Other System Views/ GS_GLOBAL_ARCHIVE_STATUS
Updated on 2024-06-03 GMT+08:00
View PDF
Share

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.

Table 1 GS_GLOBAL_ARCHIVE_STATUS columns

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: Other System Views