Monitor repl slot size

From: Nicola Contu <nicola(dot)contu(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Cc: Alessandro Aste <Alessandro(dot)aste(at)gtt(dot)net>
Subject: Monitor repl slot size
Date: 2018-07-13 10:19:15
Message-ID: CAMTZZh1xOq2e47evTaTTeUhz9QsectB7ESo+yn788hS=WtPLEw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2018-07-13 10:43:59 Re: Monitor repl slot size
Previous Message Łukasz Jarych 2018-07-13 09:30:16 Re: Create event triger