[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Checking Postgres Streaming replication delay
From:       Patrick B <patrickbakerbr () gmail ! com>
Date:       2016-10-31 20:39:01
Message-ID: CAJNY3isOdVLMuUEUpwj3k=b6OUpjSEcyeqK3EzN4PdCAAbe4vQ () mail ! gmail ! com
[Download RAW message or body]

2016-10-31 15:54 GMT+13:00 Venkata B Nagothi <nag1010@gmail.com>:

>
> On Mon, Oct 31, 2016 at 11:57 AM, Patrick B <patrickbakerbr@gmail.com>
> wrote:
>
>> Hi guys,
>>
>> I'm using this query to measure the delay between a Master and a
>> Streaming Replication Slave server, using PostgreSQL 9.2.
>>
>> SELECT
>>> pg_last_xlog_receive_location() receive,
>>> pg_last_xlog_replay_location() replay,
>>> (
>>> extract(epoch FROM now()) -
>>> extract(epoch FROM pg_last_xact_replay_timestamp())
>>> )::int lag;
>>
>>
>> In your opinion, is that right?
>>
>> Yes, thats right.
>
> Regards,
>
> Venkata B N
> Database Consultant
>
>

Thanks!!!!

[Attachment #3 (text/html)]

<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">2016-10-31 \
15:54 GMT+13:00 Venkata B Nagothi <span dir="ltr">&lt;<a \
href="mailto:nag1010@gmail.com" \
target="_blank">nag1010@gmail.com</a>&gt;</span>:<br><blockquote class="gmail_quote" \
style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div \
dir="ltr"><br><div class="gmail_extra"><span class=""><div><div \
class="m_6019817328159482360gmail_signature"><div dir="ltr"><div dir="ltr"><div>On \
Mon, Oct 31, 2016 at 11:57 AM, Patrick B <span dir="ltr">&lt;<a \
href="mailto:patrickbakerbr@gmail.com" \
target="_blank">patrickbakerbr@gmail.com</a>&gt;</span> \
wrote:<br></div></div></div></div></div></span><div class="gmail_quote"><span \
class=""><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi \
guys,<div><br></div><div>I&#39;m using this query to measure the delay between a \
Master and a Streaming Replication Slave server, using PostgreSQL \
9.2.</div><div><br></div><div><blockquote class="gmail_quote" style="margin:0px 0px \
0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><code><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-kwd">SELECT<br></span></code><code><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pln">  \
pg_last_xlog_receive_location</span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pun">(<wbr>)</span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pln"> \
receive</span><span class="m_6019817328159482360gmail-m_8717449895212292242gmail-pun">,<br></span></code><code><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pln">  \
pg_last_xlog_replay_location</span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pun">()</span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pln"> replay</span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pun">,<br></span></code><code><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pln">  </span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pun">(<br></span></code><code><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pln">   \
extract</span><span class="m_6019817328159482360gmail-m_8717449895212292242gmail-pun">(</span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pln">epoch </span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-kwd">FROM</span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pln"> now</span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pun">())</span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pln"> </span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pun">-<br></span></code><code><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pln">   \
extract</span><span class="m_6019817328159482360gmail-m_8717449895212292242gmail-pun">(</span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pln">epoch </span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-kwd">FROM</span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pln"> \
pg_last_xact_replay_timestamp</span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pun">(<wbr>))<br></span></code><code><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pln">  </span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pun">)::</span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pln">int lag</span><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pun">;</span></code></blockquote><pre \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-lang-sql \
m_6019817328159482360gmail-m_8717449895212292242gmail-prettyprint \
m_6019817328159482360gmail-m_8717449895212292242gmail-prettyprinted"><code><span \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-pun"><br></span></code></pre><pre \
class="m_6019817328159482360gmail-m_8717449895212292242gmail-lang-sql \
m_6019817328159482360gmail-m_8717449895212292242gmail-prettyprint \
m_6019817328159482360gmail-m_8717449895212292242gmail-prettyprinted"><font \
face="arial, helvetica, sans-serif">In your opinion, is that \
right?</font></pre></div></div></blockquote></span><div>Yes, thats \
right.</div><div><br></div><div>Regards,<div><br></div><div>Venkata B \
N</div><div><span style="font-size:12.8px">Database \
Consultant</span></div></div><div><span \
style="font-size:12.8px"><br></span></div></div></div></div> \
</blockquote></div><br></div><div class="gmail_extra"><br></div><div \
class="gmail_extra">Thanks!!!!</div></div>



[prev in list] [next in list] [prev in thread] [next in thread]