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