Feedback-ID: i76984098:Fastmail
Message-ID: <017913c7-92d3-4967-bf78-2a4dbd193506@aklaver.com>
Date: Sat, 23 Nov 2024 16:28:28 -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: Ray O'Donnell <ray@rodonnell.ie>,
 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>
 <1270021b-c5b5-4ca8-b48d-7dfb163bb6f7@aklaver.com>
 <CAAiSvx-JPJCGc_VR+YrUNo75pb0yrmB8Ng3zBOCf+Mksdo5JYg@mail.gmail.com>
 <9a0d0e80-13e1-421a-9d84-da000fe4433a@aklaver.com>
 <CAAiSvx9CangeS_yZ6RLXsXHBZSKmuRvrcB39DNSB_Ler3=OhTw@mail.gmail.com>
 <01020193592431ad-0fedca70-38e9-4fd0-bf49-f5bbf628c76e-000000@eu-west-1.amazonses.com>
 <CAAiSvx9HPJAXtTxyjs7uyJN+0NSBXGtwJiF15GSAjHdYwh4V7A@mail.gmail.com>
 <793d8f62-fdfe-44d5-b11f-0da978743ccf@aklaver.com>
 <CAAiSvx-=6He5yKjqGZbZ_4BusMdNH4JRhSzY2xjriSAA=sPRFA@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAAiSvx-=6He5yKjqGZbZ_4BusMdNH4JRhSzY2xjriSAA=sPRFA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/017913c7-92d3-4967-bf78-2a4dbd193506%40aklaver.com>
Precedence: bulk

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