Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why?

On 11/23/24 16:20, Steeve Boulanger wrote:
> Apologies for the late reply.
> 
>  > I'm guessing shutting down Netdata did not stop the resets?
> 
> There was a hiccup yesterday, so I had to redo the test and wait until 
> today to see if there were any stats resets ... and NONE today!!
> 
>      reset_status    | cnt
> --------------------+-----
>   reset before today | 100
>   no reset           |  57
>   reset today        |   0

Getting closer.

> 
> This is quite interesting, and a little unexpected... but in order to 
> confirm this theory, I have done the following just now:
> 
> 1) Restart Netdata service
> 2) rename the "pg_stat_reset()" function , as you suggested in another 
> post  - very clever btw! :-)

Not sure who 'you' refers to, but just to be clear that was Greg Sabino 
Mullane.

> 
> Now let's wait until tomorrow to see if we have any stats reset and/or 
> some relevant errors in the PG logs!
> 
> Quick note: I did do a quick check in any user functions for any 
> "pg_stat_reset" calls , but didn't find any. With that said, we have 
> 150+ databases in our cluster, so perhaps I missed something. I also did 
> a grep on the netdata directories, but nothing as well.
> 
> -Steeve
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com