Troubleshoot replication lags in RDS for PostgreSQL

The logical replication slot “mylogslot” is also active and permanent It's client has received up to 0

Troubleshoot replication lags in RDS for PostgreSQL Therefore, be sure to monitor the runtime of active transactions with the PostgreSQL pg_stat_activity view Run a query on the primary instance similar to the

The logical replication slot “mylogslot” is also active and permanent It's client has received up to 0

replication slot Query on the primary instance is always running After creating a replica, the query SELECT * from pg_stat_activity where state = 'active' and pid = XXXX and

When this slot should be active, because you have a secondary site configured using that slot, look for the PostgreSQL logs for the secondary site, to view why

replication slot postgres The Slot Name field is a unique, cluster-wide identifier for the replication slot · The Slot Type field is the slot type

pid 23095 usesysid 169593 usename repmgr application_name active t active_pid 6689 xmin catalog_xmin restart_lsn