GLOBAL_REPLICATION_SLOTS
GLOBAL_REPLICATION_SLOTS displays information about replicated slots on each node in the cluster.
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.
|
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.
|
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.