On Mon, 2021-12-27 at 19:22 +0300, Kenny Bachman wrote: > I have a 3-nodes Patroni cluster with PG 12.9. There is a replay lag on the third node. > I don't understand why there is lag. The replication view output is below : > > Extra info: There is no long-running query on the third node. > > Where can I check to detect what's causing this? On the lagging node, examine SELECT * FROM pg_stat_activity; That should show you what causes the lag. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
