A question on pg_stat_subscription view

Started by Önder Kalacıover 8 years ago3 messagesgeneral
Jump to latest
#1Önder Kalacı
onderkalaci@gmail.com

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!

#2Günce Kaya
guncekaya14@gmail.com
In reply to: Önder Kalacı (#1)
Re: A question on pg_stat_subscription view

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@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

#3Önder Kalacı
onderkalaci@gmail.com
In reply to: Günce Kaya (#2)
Re: A question on pg_stat_subscription view

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:

Show quoted text

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@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