• Logical replication of tables in schema in PostgreSQL 15
• Inside logical replication in PostgreSQL: How it works
• Using PostgreSQL Replication Slots

---

Logical replication of tables in schema in PostgreSQL 15

postgres=# d pg_replication_slots View 'pg_catalog.pg_replication_slots' Column | Type | Collation | Nullable | Default .

Inside logical replication in PostgreSQL: How it works

postgres=# SELECT * FROM pg_replication_slots ; slot_name | plugin | slot_type | datoid | database | active | xmin | catalog_xmin | restart_lsn .

Using PostgreSQL Replication Slots

postgres=# SELECT redo_lsn, slot_name,restart_lsn, round((redo_lsn-restart_lsn) / 1024 / 1024 / 1024, 2) AS GB_behind FROM pg_control_checkpoint(), pg_replication_slots; redo_lsn | slot_name | restart_lsn | gb_behind .