From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Kenny Bachman <kenny.bachman17@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: postgresql replication replay lag
Date: Wed, 29 Dec 2021 05:53:57 +0100
Message-ID: <9350d584fdedaee8161f40ee70798a7d443b3f2c.camel@cybertec.at> (raw)
In-Reply-To: <CAC0w7LJFsyvkJe26hSZQHZiY5c=kHyVdy8-1CFfRdGNbpO4VMQ@mail.gmail.com>
References: <CAC0w7LJFsyvkJe26hSZQHZiY5c=kHyVdy8-1CFfRdGNbpO4VMQ@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, kenny.bachman17@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: postgresql replication replay lag
In-Reply-To: <9350d584fdedaee8161f40ee70798a7d443b3f2c.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox