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: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 21 Nov 2024 16:29:47 -0500
Message-ID: <CANzqJaDSU6dsbL6jc7DP7=iNu9HZaMPX9yN2WBtTxOb0JPpXOA@mail.gmail.com>
Subject: Re: Database stats ( pg_stat_database.stats_reset ) get reset on
 daily basis - why?
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d64a7d062772f755"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDSU6dsbL6jc7DP7%3DiNu9HZaMPX9yN2WBtTxOb0JPpXOA%40mail.gmail.com>
Precedence: bulk

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

On Thu, Nov 21, 2024 at 4: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.
>

Also, "SELECT pg_postmaster_start_time();" to show the *real* Postgresql
start time, instead of what you think it is.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Nov 21, 2024 at 4:12=E2=80=AFPM A=
drian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver=
@aklaver.com</a>&gt; wrote:</div><div class=3D"gmail_quote"><blockquote cla=
ss=3D"gmail_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 wrot=
e:<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></blockquote><d=
iv>=C2=A0</div><div>Also, &quot;SELECT pg_postmaster_start_time();&quot; to=
 show the <i>real</i>=C2=A0Postgresql start time, instead of what you think=
 it is.</div></div><div><br></div><span class=3D"gmail_signature_prefix">--=
 </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Dea=
th to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m st=
ill alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></div></=
div></div>

--000000000000d64a7d062772f755--