Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ Schema/ DBE_PERF Schema/ Utility/ GLOBAL_REPLICATION_SLOTS
Updated on 2025-02-27 GMT+08:00
View PDF
Share

GLOBAL_REPLICATION_SLOTS

GLOBAL_REPLICATION_SLOTS displays information about replicated slots on each node in the cluster.

Table 1 GLOBAL_REPLICATION_SLOTS columns

Name

Type

Description

node_name

name

Node name.

slot_name

text

Replication slot name.

plugin

text

Name of the output plug-in corresponding to the logical replication slot.

slot_type

text
Replication slot type.
  • physical: physical replication slot.
  • logical: logical replication slot.

datoid

oid

OID of the database where the replication slot resides.

database

name

Name of the database where the replication slot resides.

active

boolean
Determines whether the replication slot is activated.
  • t (true): yes.
  • f (false): no.

x_min

xid

The earliest transaction that the database must reserve for the replication slot. VACUUM cannot remove a tuple that is deleted by its subsequent transactions.

catalog_xmin

xid

The earliest transaction that affects the system catalog and must be reserved by the database for the replication slot. VACUUM cannot remove a system catalog tuple that is deleted by its subsequent transactions.

restart_lsn

text

Physical location of the earliest Xlog required by the replication slot.

dummy_standby

boolean

Lab features.
Parent topic: Utility