On replica node:
SELECT EXTRACT(EPOCH FROM (now() - pg_last_xact_replay_timestamp())) as lag
;
lag
-------------
2036.505786
(1 row)
Regards,
Nagarjuna
On Wed, Dec 16, 2020 at 3:36 PM L.walid (PowerM) <l.wa...@powerm.ma> wrote:
> Can you share the output of the select :
>
> SELECT EXTRACT(EPOCH FROM (now() - pg_last_xact_replay_timestamp())) as lag
>
> Best regards,
> --------------------------------------------------------------
> Walid Largou
> Solution Architect / Service Delivery Manager
> Mobile : +212 621 31 98 71
> Email : l.wa...@powerm.ma <l.wa...@powerm.ma>
> 320 Bd Zertouni 6th Floor, Casablanca, Morocco
> --------------------------------------------------------------
> https://www.powerm.ma
> Power Maroc #1 IBM Business Partner – Power Maroc
> This message is confidential .Its contents do not constitute a commitment
> by Power Maroc S.A.R.L except where provided for in a written agreement
> between you and Power Maroc S.A.R.L. Any authorized disclosure, use or
> dissemination, either whole or partial, is prohibited. If you are not the
> intended recipient of the message, please notify the sender immediately.
>
> On 16 Dec 2020, at 10:13, NAGARJUNA D.N <nagarj...@bluepi.in> wrote:
>
> Yes, only with the *pg_replication_lag. *
> Or somehow I need to get the replica lags behind the master.
>
> Regards,
> Nagarjuna
>
>
> On Wed, Dec 16, 2020 at 2:32 PM L.walid (PowerM) <l.wa...@powerm.ma>
> wrote:
>
>> Hi,
>>
>> Are you having issues with only the *pg_replication_lag *metric* ?*
>>
>> Best regards,
>> --------------------------------------------------------------
>> Walid Largou
>> Solution Architect / Service Delivery Manager
>> Mobile : +212 621 31 98 71
>> Email : l.wa...@powerm.ma <l.wa...@powerm.ma>
>> 320 Bd Zertouni 6th Floor, Casablanca, Morocco
>> --------------------------------------------------------------
>> https://www.powerm.ma
>> Power Maroc #1 IBM Business Partner – Power Maroc
>> This message is confidential .Its contents do not constitute a commitment
>> by Power Maroc S.A.R.L except where provided for in a written agreement
>> between you and Power Maroc S.A.R.L. Any authorized disclosure, use or
>> dissemination, either whole or partial, is prohibited. If you are not the
>> intended recipient of the message, please notify the sender immediately.
>>
>> On 16 Dec 2020, at 06:43, 'NAGARJUNA D.N' via Prometheus Users <
>> prometheus-users@googlegroups.com> wrote:
>>
>> *pg_replication_lag*
>>
>>
>>
> This communication is for informational purposes only. Any comments or
> statements made herein do not necessarily reflect those of Blue Pi
> Consulting India Private Limited, its subsidiaries and affiliates. This
> transmission may contain information that is privileged, confidential,
> legally privileged, and/or exempt from disclosure under applicable law. If
> you are not the intended recipient, you are hereby notified that any
> disclosure, copying, distribution, or use of the information contained
> herein (including any reliance thereon) is STRICTLY PROHIBITED. Although
> this transmission and any attachments are believed to be free of any virus
> or other defect that might affect any computer system into which it is
> received and opened, it is the responsibility of the recipient to ensure
> that it is virus free and no responsibility is accepted by Blue Pi
> Consulting India Private Limited, its subsidiaries and affiliates, as
> applicable, for any loss or damage arising in any way from its use. If you
> received this transmission in error, please immediately contact the sender
> and destroy the material in its entirety, whether in electronic or hard
> copy format. Thank you.
>
>
>
--
This communication is for informational purposes only. Any comments or
statements made herein do not necessarily reflect those of Blue Pi
Consulting India Private Limited, its subsidiaries and affiliates. This
transmission may contain information that is privileged, confidential,
legally privileged, and/or exempt from disclosure under applicable law. If
you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED. Although
this transmission and any attachments are believed to be free of any virus
or other defect that might affect any computer system into which it is
received and opened, it is the responsibility of the recipient to ensure
that it is virus free and no responsibility is accepted by Blue Pi
Consulting India Private Limited, its subsidiaries and affiliates, as
applicable, for any loss or damage arising in any way from its use. If you
received this transmission in error, please immediately contact the sender
and destroy the material in its entirety, whether in electronic or hard
copy format. Thank you.
--
You received this message because you are subscribed to the Google Groups
"Prometheus Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to prometheus-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/prometheus-users/CABa7G9YNi-T9krCmV%2Bg4G5uixpvqRhL9FV%2BdtgugcAbYCfZdYQ%40mail.gmail.com.
