How do you get the replication slots in PostgreSQL?

website oldest replication slot lag Oldest replication slot lag: lagging size of the most lagging replica in terms of WAL data received You can run the following SQL statement oldest replication slot lag The morale of the story? Don't leave your replication slots unattended! There shouldn't be any slots which are inactive for too long For

oldest replication slot lag Oldest query start time pg_waiting_backends, gauge, wait_type  The lag between primary and read replica exceeds 16 seconds without any heavy IOPS, sometimes 30 seconds I have spent a lot of effort on  The lag between primary and read replica exceeds 16 seconds without any heavy IOPS, sometimes 30 seconds I have spent a lot of effort on

Share

Share

Link

Turn off sharing Copy link

See all details