MIME-Version: 1.0
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>
In-Reply-To: <793d8f62-fdfe-44d5-b11f-0da978743ccf@aklaver.com>
From: Steeve Boulanger <sboulanger29@gmail.com>
Date: Sat, 23 Nov 2024 18:20:28 -0600
Message-ID: <CAAiSvx-=6He5yKjqGZbZ_4BusMdNH4JRhSzY2xjriSAA=sPRFA@mail.gmail.com>
Subject: Re: Database stats ( pg_stat_database.stats_reset ) get reset on
 daily basis - why?
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: "Ray O'Donnell" <ray@rodonnell.ie>, pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000fdfcee06279d95c9"
Archived-At: <https://www.postgresql.org/message-id/CAAiSvx-%3D6He5yKjqGZbZ_4BusMdNH4JRhSzY2xjriSAA%3DsPRFA%40mail.gmail.com>
Precedence: bulk

--000000000000fdfcee06279d95c9
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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

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! :-)

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


On Sat, Nov 23, 2024 at 10:19=E2=80=AFAM Adrian Klaver <adrian.klaver@aklav=
er.com>
wrote:

> On 11/23/24 05:16, Steeve Boulanger wrote:
> >> Here (Ireland) we sometimes say "common-or-garden variety".... It mean=
s
> a normal, everyday variety. :-)
> >
> > I'm afraid that my Irish dialect is limited to "sl=C3=A1inte" only ;-) =
 In
> > any case, thanks for taking the time to help with this issue. I'm
> > still investigating, but I think that calling the "ghostbusters" is
> > moving up the list now lol.
>
> I'm guessing shutting down Netdata did not stop the resets?
>
> You might try setting log_min_messages to info to see if that catches
> anything.
>
>
> >
> >
> > On Sat, Nov 23, 2024 at 7:09=E2=80=AFAM Ray O'Donnell <ray@rodonnell.ie=
> wrote:
> >>
> >> On 23/11/2024 13:06, Steeve Boulanger wrote:
> >>
> >>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>

--000000000000fdfcee06279d95c9
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Apologies for the late reply.<br><br>&gt; I&#39;m guessing=
 shutting down Netdata did not stop the resets?<br><br>There was a hiccup y=
esterday, so I had to redo the test and wait until today to see if there we=
re any stats resets ... and NONE today!! <br><br><font face=3D"monospace">=
=C2=A0 =C2=A0 reset_status =C2=A0 =C2=A0| cnt<br>--------------------+-----=
<br>=C2=A0reset before today | 100<br>=C2=A0no reset =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 | =C2=A057<br>=C2=A0reset today =C2=A0 =C2=A0 =C2=A0 =C2=A0| =
=C2=A0 0<br></font><div><br></div><div>This is quite interesting, and a lit=
tle unexpected... but in order to confirm this theory, I have done the foll=
owing just now:=C2=A0</div><div><br></div><div>1) Restart Netdata service<b=
r>2) rename the &quot;pg_stat_reset()&quot; function , as you suggested in =
another post=C2=A0 - very clever btw! :-)=C2=A0=C2=A0</div><div><br></div><=
div>Now let&#39;s wait=C2=A0until tomorrow to see if we have any stats rese=
t and/or some relevant errors in the=C2=A0PG logs!=C2=A0</div><div><br></di=
v><div>Quick note: I did do a quick check in any user functions for any &qu=
ot;pg_stat_reset&quot; calls , but didn&#39;t find any. With that said, we =
have 150+ databases in our cluster, so perhaps=C2=A0I missed something. I a=
lso did a grep on the netdata directories, but nothing=C2=A0as well.=C2=A0<=
/div><div><br></div><div>-Steeve</div></div><br><br><div class=3D"gmail_quo=
te"><div dir=3D"ltr" class=3D"gmail_attr">On Sat, Nov 23, 2024 at 10:19=E2=
=80=AFAM Adrian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adr=
ian.klaver@aklaver.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_q=
uote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,2=
04);padding-left:1ex">On 11/23/24 05:16, Steeve Boulanger wrote:<br>
&gt;&gt; Here (Ireland) we sometimes say &quot;common-or-garden variety&quo=
t;.... It means a normal, everyday variety. :-)<br>
&gt; <br>
&gt; I&#39;m afraid that my Irish dialect is limited to &quot;sl=C3=A1inte&=
quot; only ;-)=C2=A0 In<br>
&gt; any case, thanks for taking the time to help with this issue. I&#39;m<=
br>
&gt; still investigating, but I think that calling the &quot;ghostbusters&q=
uot; is<br>
&gt; moving up the list now lol.<br>
<br>
I&#39;m guessing shutting down Netdata did not stop the resets?<br>
<br>
You might try setting log_min_messages to info to see if that catches <br>
anything.<br>
<br>
<br>
&gt; <br>
&gt; <br>
&gt; On Sat, Nov 23, 2024 at 7:09=E2=80=AFAM Ray O&#39;Donnell &lt;<a href=
=3D"mailto:ray@rodonnell.ie" target=3D"_blank">ray@rodonnell.ie</a>&gt; wro=
te:<br>
&gt;&gt;<br>
&gt;&gt; On 23/11/2024 13:06, Steeve Boulanger wrote:<br>
&gt;&gt;<br>
&gt;&gt;<br>
<br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
<br>
</blockquote></div>

--000000000000fdfcee06279d95c9--