Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

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.
Name
Type
Description
slot_name
name
A unique, cluster-wide identifier for the replication slot
plugin
name
The base name of the shared object containing the output plugin this logical slot is using, or null for physical slots.
slot_type
text
The slot type - physical or logical
datoid
oid
The OID of the database this slot is associated with, or null. Only logical slots have an associated database.
database
text
The name of the database this slot is associated with, or null. Only logical slots have an associated database.
active
boolean
True if this slot is currently actively being used
active_pid
integer
The process ID of the session using this slot if the slot is currently actively being used. NULL if inactive.
xmin
xid
The oldest transaction that this slot needs the database to retain. VACUUM cannot remove tuples deleted by any later transaction.
catalog_xmin
xid
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.
restart_lsn
pg_lsn
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.
confirmed_flush_lsn
pg_lsn
The address (LSN) up to which the logical slot's consumer has confirmed receiving data. Data older than this is not available anymore. NULL for physical slots.

Comments

Popular posts from this blog

PostgreSQL pgBadger

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

PostgreSQL Pgbadger Installation On Linux

PostgreSQL Database startup / shutdown /restart