From: Nicola Contu [mailto:nicola.co...@gmail.com]
Sent: Friday, July 13, 2018 6:19 AM
To: pgsql-general@lists.postgresql.org
Cc: Alessandro Aste
Subject: Monitor repl slot size
Hello,
we used to monitor the replication slot size on postgres 9.6.6 with the
following query:
SELECT
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.
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
