On Sat, 2026-03-21 at 07:49 +0000, Subramanian,Ramachandran wrote:
> > Look at "pg_stat_replication" on the primary server.
>
> If I just look at the write_lag columns, it would give me a good idea of the situation -- Is my understanding
correct?
Yes, but if no WAL gets generated and replicated for a while, the columns will
become NULL, because then delay measured in time makes no sense.
Therefore, I prefer to use "replay_lsn" and friends and measure the lag in bytes.
Yours,
Laurenz Albe