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/21/24 12:34, Steeve Boulanger wrote:

Please reply to list also.

Ccing list.


Thanks Adrian for taking the time to respond. I will review the documentation once more, just in case I missed anything.

My apologies - I forgot to mention in my original post, that our last cluster shutdown was over 15 days ago, thus an "unclean" shutdown would not explain these daily stats reset that we are seeing. It might also be relevant to mentioned

Then something is resetting the statistics.

1) What is log_min_error_statement set to?

2) Did you reload the server when changing?:

log_min_duration_statement | 0
log_statement              | all


-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