Help Center> GaussDB> Distributed_2.x> Schemas> DBE_PERF Schema> Utility> REPLICATION_SLOTS
Updated on 2023-10-23 GMT+08:00
View PDF

REPLICATION_SLOTS

REPLICATION_SLOTS displays replication slot information.

Table 1 REPLICATION_SLOTS columns

Name

Type

Description

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

xmin

xid

XID of the earliest transaction that the database must reserve for the replication slot.

catalog_xmin

xid

XID of the earliest system catalog-involved transaction that the database must reserve for the logical replication slot.

restart_lsn

text

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

dummy_standby

boolean
Determines whether the peer end connected to the replication slot is a secondary node.
  • t (true): yes
  • f (false): no
Parent topic: Utility