Metric to calculate WAL size left to transfer to Standby

From: Viral Shah <vshah(at)nodalexchange(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Metric to calculate WAL size left to transfer to Standby
Date: 2021-04-14 21:50:58
Message-ID: CAKL_ojy+Fr1yF_S5vTtyMUjE5XKSMhz3mf5L-CNUgGEpPBJXVA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

We have a PostgreSQL 10.12 cluster of servers in two different data
centers. Off lately, in the case of a large WAL generation, we are seeing
replication delay between the master and the standby server. These delays
have off lately been there for an unusually long time. I was wondering if
we have any metric that can calculate the amount (size) of WAL transfer
left between master and standby?

PS: We have ensured we have upgraded our firewalls for better speed
transfer.

Any help on how to figure out the slowness in the WAL transfer would
be much appreciated.

Thanks,
Viral Shah

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Moris Rumenov Vrachovski 2021-04-14 23:10:46 Vulnerability PostgreSQL 11.2
Previous Message Brent Wood 2021-04-14 21:33:03 Re: Timestamp/hstore query?