PostgreSQL Logical replication Practical use case

Streaming replication with PostgreSQL , 10 & 11 replication slot is active for pid The logical replication slot “mylogslot” is also active and permanent It's client has received up to 0 replication slot already exists Whether the replication slot is active xmin xid Transaction ID of the Description pid bigint Thread PID sender_pid integer Current sender PID

replication slot is active for pid 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