54.20. pg_replication_slots
#
The pg_replication_slots
view provides a listing of all replication slots that currently exist on the database cluster, along with their current state.
For more on replication slots, see Section 26.2.6 and Chapter 49.
Table 54.20. pg_replication_slots
Columns
Column Type Description |
---|
A unique, cluster-wide identifier for the replication slot |
The base name of the shared object containing the output plugin this logical slot is using, or null for physical slots. |
The slot type: |
The OID of the database this slot is associated with, or null. Only logical slots have an associated database. |
The name of the database this slot is associated with, or null. Only logical slots have an associated database. |
True if this is a temporary replication slot. Temporary slots are not saved to disk and are automatically dropped on error or when the session has finished. |
True if this slot is currently actively being used |
The process ID of the session using this slot if the slot is currently actively being used. |
The oldest transaction that this slot needs the database to retain. |
The oldest transaction affecting the system catalogs that this slot needs the database to retain. |
The address ( |
The address ( |
Availability of WAL files claimed by this slot. Possible values are:
The last two states are seen only when max_slot_wal_keep_size is non-negative. If |
The number of bytes that can be written to WAL such that this slot is not in danger of getting in state "lost". It is NULL for lost slots, as well as if |
True if the slot is enabled for decoding prepared transactions. Always false for physical slots. |
The time since the slot has become inactive. |
True if this logical slot conflicted with recovery (and so is now invalidated). When this column is true, check |
The reason for the slot's invalidation. It is set for both logical and physical slots.
|
True if this is a logical slot enabled to be synced to the standbys so that logical replication can be resumed from the new primary after failover. Always false for physical slots. |
True if this is a logical slot that was synced from a primary server. On a hot standby, the slots with the synced column marked as true can neither be used for logical decoding nor dropped manually. The value of this column has no meaning on the primary server; the column value on the primary is default false for all slots but may (if leftover from a promoted standby) also be true. |