Postgres Pro
Downloads
Home   >   mailing lists

Thread: [GENERAL] A question on pg_stat_subscription view

[GENERAL] A question on pg_stat_subscription view

From
Önder Kalacı
Date:
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!

Re: [GENERAL] A question on pg_stat_subscription view

From
Günce Kaya
Date:
Hello,

You can find more information about that view and its columns. 


Regards,
Gunce 

On 22 Oct 2017 Sun at 11:11 Önder Kalacı <onderkalaci@gmail.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

Re: [GENERAL] A question on pg_stat_subscription view

From
Önder Kalacı
Date:
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@gmail.com> wrote:
Hello,

You can find more information about that view and its columns. 


Regards,
Gunce 

On 22 Oct 2017 Sun at 11:11 Önder Kalacı <onderkalaci@gmail.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