Re: A question on pg_stat_subscription view

From: Önder Kalacı <onderkalaci(at)gmail(dot)com>
To: Günce Kaya <guncekaya14(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: A question on pg_stat_subscription view
Date: 2017-10-23 13:19:41
Message-ID: CACawEhXcxTHBhdN-2AoEJRcAVP==BWVm+9+hEJNPWJekvk4qUQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Thanks for the reply, however, the documentation does not mention about
that clearly.

It only mentions that 'latest_end_lsn' is the `Last write-ahead log
location reported to origin WAL sender`. However, what I'm particularly
interested is that whether the reported log is the flushed or applied LSN.

Thanks,
Onder

On Sun, Oct 22, 2017 at 12:03 PM Günce Kaya <guncekaya14(at)gmail(dot)com> wrote:

> Hello,
>
> You can find more information about that view and its columns.
>
> https://www.postgresql.org/docs/devel/static/monitoring-
> stats.html#pg-stat-subscription
>
> Regards,
> Gunce
>
> On 22 Oct 2017 Sun at 11:11 Önder Kalacı <onderkalaci(at)gmail(dot)com> wrote:
>
>> Hi,
>>
>> I'm trying to understand the view pg_stat_subscription. What is the
>> `latest_end_lsn` column? Is that the latest lsn flushed or lsn replied or
>> something else?
>>
>> Thanks!
>>
> --
> Gunce Kaya
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Önder Kalacı 2017-10-23 13:28:43 Is it safe to create foreign keys beforehand when logical replication is used?
Previous Message Popov Aleksey 2017-10-23 13:06:07 Matching statement and duration log lines