pg_replication_slots view provides a listing of all replication slots that currently exist on the database cluster, along with their current state.
|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 slot is currently actively being used
|The process ID of the session using this slot if the slot is currently actively being used.
NULL if inactive.
|The oldest transaction that this slot needs the database to retain.
VACUUM cannot remove tuples deleted by any later transaction.
|The oldest transaction affecting the system catalogs that this slot needs the database to retain.
VACUUM cannot remove catalog tuples deleted by any later transaction.
|The address (
LSN) of oldest WAL which still might be required by the consumer of this slot and thus won't be automatically removed during checkpoints.