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>
In-Reply-To: <1e2db3f5-00f4-4ec2-800f-46136c2fad59@aklaver.com>
From: Steeve Boulanger <sboulanger29@gmail.com>
Date: Thu, 21 Nov 2024 15:31:16 -0600
Message-ID: <CAAiSvx_ZtM72ZO=uq56X=iJ=a17KcgB=07c5abyFnQ8vAses0Q@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: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003b96c9062772fd83"
Archived-At: <https://www.postgresql.org/message-id/CAAiSvx_ZtM72ZO%3Duq56X%3DiJ%3Da17KcgB%3D07c5abyFnQ8vAses0Q%40mail.gmail.com>
Precedence: bulk

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

>  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.

-Steeve

On Thu, Nov 21, 2024 at 3:12=E2=80=AFPM Adrian Klaver <adrian.klaver@aklave=
r.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
>
>

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

<div dir=3D"ltr">&gt;=C2=A0

All I can think to do is look at the logs=C2=A0 around the stats_reset time=
s<br>&gt; for the databases and see if there is anything relevant.<div><br>=
</div><div>That was already done, but nothing relevant was found unfortunat=
ely.=C2=A0</div><div><br></div><div>-Steeve</div></div><br><div class=3D"gm=
ail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Nov 21, 2024 at 3:=
12=E2=80=AFPM Adrian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com=
">adrian.klaver@aklaver.com</a>&gt; wrote:<br></div><blockquote class=3D"gm=
ail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,=
204,204);padding-left:1ex">On 11/21/24 12:57, Steeve Boulanger wrote:<br>
&gt; <br>
&gt;=C2=A0 &gt; Please reply to list also.<br>
&gt; <br>
&gt; My apologies - I thought I did a &quot;Reply all&quot;, but apparently=
 not. I&#39;m a <br>
&gt; little bit of a noob with email distrib lists.<br>
&gt; <br>
&gt;=C2=A0 &gt; 1) What is log_min_error_statement set to?<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 name =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 | setting | pending_restart<br>
&gt; -------------------------+---------+-----------------<br>
&gt;=C2=A0 =C2=A0log_min_error_statement | error =C2=A0 | f<br>
&gt; <br>
&gt;=C2=A0 &gt; 2) Did you reload the server when changing?:<br>
&gt; <br>
&gt; yes - pg_reload_conf()<br>
<br>
All I can think to do is look at the logs=C2=A0 around the stats_reset time=
s <br>
for the databases and see if there is anything relevant.<br>
<br>
&gt; <br>
&gt; -Steeve<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>

--0000000000003b96c9062772fd83--