On Mon, Feb 21, 2022 at 6:19 PM Amit Kapila <amit.kapil...@gmail.com> wrote: > > On Mon, Feb 21, 2022 at 1:18 PM Andres Freund <and...@anarazel.de> wrote: > > > > On 2022-02-21 12:39:31 +0530, Amit Kapila wrote: > > > Fair enough. Then, how about the following keeping the following > > > information: > > > > Mostly sounds good. > > > > > > > * subid (subscription id) > > > * subname (subscription name) > > > > Coming from catalog, via join, I assume? > > > > The subname would be from pg_subscription catalog similar to what we > are doing now for pg_stat_subscription_workers.
I've attached a patch that changes pg_stat_subscription_workers view. It removes non-cumulative values such as error details such as error-XID and the error message from the view, and consequently the view now has only cumulative statistics counters: apply_error_count and sync_error_count. Since the new view name is under discussion I temporarily chose pg_stat_subscription_activity. Regards, -- Masahiko Sawada EDB: https://www.enterprisedb.com/
v1-0001-Reconsider-pg_stat_subscription_workers-view.patch
Description: Binary data
