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

> Please reply to list also.

My apologies - I thought I did a "Reply all", but apparently not. I'm a
little bit of a noob with email distrib lists.

> 1) What is log_min_error_statement set to?

name | setting | pending_restart
-------------------------+---------+-----------------
log_min_error_statement | error | f

> 2) Did you reload the server when changing?:

yes - pg_reload_conf()

-Steeve

On Thu, Nov 21, 2024 at 2:49 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> 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(dot)klaver(at)aklaver(dot)com
>
>