Monday, 18 August 2025

Filled under:

 SELECT

    current_timestamp(0) AS query_time,

    current_setting('TimeZone') AS db_timezone,

    TRIM(TRAILING '.00' FROM TO_CHAR(

        ROUND(GREATEST(0, (pg_current_wal_lsn() - restart_lsn)::NUMERIC / 1024 / 1024), 2),

        'FM999999999990.00'

    )) AS rep_behind_MB

FROM pg_replication_slots;

0 comments:

Post a Comment