From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Monitor repl slot size |
Date: | 2018-07-13 10:43:59 |
Message-ID: | 8eef4935-9a04-a70b-21f4-9ef76f1df12c@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 13/07/2018 13:19, Nicola Contu wrote:
> Hello,
> we used to monitor the replication slot size on postgres 9.6.6 with the following query:
>
> SELECT pg_xlog_location_diff(pg_current_xlog_location(), restart_lsn) FROM pg_replication_slots WHERE slot_name = 'SLOT NAME';
>
> We are moving to postgres 10.4 and we saw the pg_xlog_location_diff is not there anymore.
>
location -> lsn
xlog -> wal
SELECT pg_wal_lsn_diff(pg_current_wal_insert_lsn(), restart_lsn) FROM pg_replication_slots;
> I know we can re-create it following this link : https://github.com/DataDog/integrations-core/issues/907
>
> but, is there any better way to do it? Any replacement for that function on postgres 10?
>
> Thanks a lot,
> Nicola
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
From | Date | Subject | |
---|---|---|---|
Next Message | Łukasz Jarych | 2018-07-13 10:58:56 | Re: Read only to schema |
Previous Message | Nicola Contu | 2018-07-13 10:19:15 | Monitor repl slot size |