Horton

Rename two columns in pg_stat_subscription_stats.

Amit Kapila <akapila@postgresql.org>

View on postgr.es
Commit: 3edaf29fa5e0d4fd6419c7eb73fd6df5b0406789
Author: Amit Kapila <akapila@postgresql.org>
Date: 2025-11-18T03:58:55Z
Releases: 19 (unreleased) 
Rename two columns in pg_stat_subscription_stats.

This patch renames the sync_error_count column to sync_table_error_count
in the pg_stat_subscription_stats view. The new name makes the purpose
explicit now that a separate column exists to track sequence
synchronization errors.

Additionally, the column seq_sync_error_count is renamed to
sync_seq_error_count to maintain a consistent naming pattern, making it
easier for users to group, and query synchronization related counters.

Author: Vignesh C <vignesh21@gmail.com>
Reviewed-by: Peter Smith <smithpb2250@gmail.com>
Reviewed-by: Chao Li <li.evan.chao@gmail.com>
Discussion: https://postgr.es/m/CALDaNm3WwJmz=-4ybTkhniB-Nf3qmFG9Zx1uKjyLLoPF5NYYXA@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/monitoring.sgml modified +2 −2
src/backend/catalog/system_views.sql modified +2 −2
src/backend/utils/activity/pgstat_subscription.c modified +4 −4
src/backend/utils/adt/pgstatfuncs.c modified +6 −6
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_proc.dat modified +1 −1
src/include/pgstat.h modified +4 −4
src/test/regress/expected/rules.out modified +3 −3
src/test/subscription/t/026_stats.pl modified +11 −11

Discussion