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>
In-Reply-To: <38725031-5e80-46ee-b403-a92107b24c39@aklaver.com>
From: Steeve Boulanger <sboulanger29@gmail.com>
Date: Thu, 21 Nov 2024 14:57:58 -0600
Message-ID: <CAAiSvx-pwz562KrTPdayK+qqRm9DxbrU1r9_Qkpm5BLh-1G+pA@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="0000000000002069c4062772866a"
Archived-At: <https://www.postgresql.org/message-id/CAAiSvx-pwz562KrTPdayK%2BqqRm9DxbrU1r9_Qkpm5BLh-1G%2BpA%40mail.gmail.com>
Precedence: bulk

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

> 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=E2=80=AFPM Adrian Klaver <adrian.klaver@aklave=
r.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.klaver@aklaver.com
>
>

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

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><br></div><div dir=3D"lt=
r">&gt; Please reply to list also.</div><div dir=3D"ltr"><br></div><div>My =
apologies - I thought I did a &quot;Reply all&quot;, but apparently not. I&=
#39;m a little bit of a noob with email distrib lists.=C2=A0</div><div><br>=
</div><div>&gt; 1) What is log_min_error_statement set to?</div><div><br></=
div><div>=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>-------------------------+-------=
--+-----------------<br>=C2=A0log_min_error_statement | error =C2=A0 | f<br=
></div><div><br></div><div>&gt; 2) Did you reload the server when changing?=
:</div><div><br></div><div>yes - pg_reload_conf()</div><div><br></div><div>=
-Steeve</div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail=
_attr">On Thu, Nov 21, 2024 at 2:49=E2=80=AFPM Adrian Klaver &lt;<a href=3D=
"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klaver@aklaver.=
com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"marg=
in:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1e=
x">On 11/21/24 12:34, Steeve Boulanger wrote:<br>
<br>
Please reply to list also.<br>
<br>
Ccing list.<br>
<br>
<br>
&gt; Thanks Adrian for taking the time to respond. I will review the <br>
&gt; documentation once more, just in case I missed anything.<br>
&gt; <br>
&gt; My apologies - I forgot to mention in my original post, that our last =
<br>
&gt; cluster shutdown was over 15 days ago, thus an &quot;unclean&quot; <br=
>
&gt; shutdown=C2=A0would=C2=A0not explain these daily stats reset that we a=
re seeing. <br>
&gt; It might also be relevant to mentioned<br>
<br>
Then something is resetting the statistics.<br>
<br>
1) What is log_min_error_statement set to?<br>
<br>
2) Did you reload the server when changing?:<br>
<br>
log_min_duration_statement | 0<br>
log_statement=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | all<br>
<br>
&gt; <br>
&gt; -Steeve<br>
&gt; <br>
&gt; <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></div>
</div>

--0000000000002069c4062772866a--