Horton

Re: Design of pg_stat_subscription_workers vs pgstats

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>, Andres Freund <andres@anarazel.de>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2022-02-03T04:48:28Z
Lists: pgsql-hackers 
On Wednesday, February 2, 2022, Masahiko Sawada <sawada.mshk@gmail.com>
wrote:

> and have other error
> information in pg_stat_subscription_workers view.
>

What benefit is there to keeping the existing collector-based
pg_stat_subscripiton_workers view?  If we re-write it using shmem IPC then
we might as well put everything there and forego using a catalog.  Then it
behaves in a similar manner to pg_stat_activity but for logical replication
workers.

David J.

Commits

  1. Reconsider pg_stat_subscription_workers view.

  2. Add a view to show the stats of subscription workers.