Sample Header Ad - 728x90

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: enter image description here
Asked by Applez00800 (145 rep)
Oct 4, 2024, 07:44 AM
Last activity: Dec 1, 2024, 09:41 PM