Feedback-ID: i76984098:Fastmail
Message-ID: <1270021b-c5b5-4ca8-b48d-7dfb163bb6f7@aklaver.com>
Date: Thu, 21 Nov 2024 14:32:06 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Database stats ( pg_stat_database.stats_reset ) get reset on
 daily basis - why?
To: Steeve Boulanger <sboulanger29@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
References: <CAAiSvx8_Z6QGey92dC+6Yona18KDMLWinfR5LOJsMgj-42XJtg@mail.gmail.com>
 <6a157286-5948-48ac-bc50-7bb4e65ee5e5@aklaver.com>
 <CAAiSvx_vsiCmL3gBj+1hRpMxo=nOc3HUa+VaGO9_GfOXDWCsrQ@mail.gmail.com>
 <38725031-5e80-46ee-b403-a92107b24c39@aklaver.com>
 <CAAiSvx-pwz562KrTPdayK+qqRm9DxbrU1r9_Qkpm5BLh-1G+pA@mail.gmail.com>
 <1e2db3f5-00f4-4ec2-800f-46136c2fad59@aklaver.com>
 <CAAiSvx_ZtM72ZO=uq56X=iJ=a17KcgB=07c5abyFnQ8vAses0Q@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAAiSvx_ZtM72ZO=uq56X=iJ=a17KcgB=07c5abyFnQ8vAses0Q@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/1270021b-c5b5-4ca8-b48d-7dfb163bb6f7%40aklaver.com>
Precedence: bulk

On 11/21/24 13:31, Steeve Boulanger wrote:
>  > All I can think to do is look at the logs  around the stats_reset times
>  > for the databases and see if there is anything relevant.
> 
> That was already done, but nothing relevant was found unfortunately.

Unless it was not recognized as relevant. Since for the time being I am 
eliminating magic as the cause, something concrete is causing this and 
it should be leaving a trace. In your post you had this affecting 77 out 
of 157 databases in the cluster.

1) Do the 77 share some trait the other 80 don't.

2) Do the OS system logs reveal anything?

3) What was happening in the databases just prior to the time the stats 
reset?

4) Do you have external tools accessing these databases?

5) Is the cluster directly open to the world?

> 
> -Steeve
> 
> On Thu, Nov 21, 2024 at 3:12 PM Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> wrote:
> 
>     On 11/21/24 12:57, Steeve Boulanger wrote:
>      >
>      >  > 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()
> 
>     All I can think to do is look at the logs  around the stats_reset times
>     for the databases and see if there is anything relevant.
> 
>      >
>      > -Steeve
> 
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com