Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux