How to reset stats in "pg_stats_subscription_stats"?
0
votes
1
answer
122
views
I have some errors produced while making changes to some logically replicated tables. Now I want to reset the errors logged in the
pg_stat_subscription_stats
table in the apply_error_count
column, but I can't find *anything* anywhere telling me how to do it.
I've tried:
- SELECT pg_stat_statements_reset()
- SELECT pg_stat_reset()
But these didn't reset this field ...
How do I reset this field?
For reference, the below is combining pg_stats_subscriptions
and pg_stat_subscription_stats
and shows the apply_error_count
values:

Asked by Applez00800
(145 rep)
Oct 4, 2024, 07:44 AM
Last activity: Dec 1, 2024, 09:41 PM
Last activity: Dec 1, 2024, 09:41 PM