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> <CANzqJaDSU6dsbL6jc7DP7=iNu9HZaMPX9yN2WBtTxOb0JPpXOA@mail.gmail.com>
In-Reply-To: <CANzqJaDSU6dsbL6jc7DP7=iNu9HZaMPX9yN2WBtTxOb0JPpXOA@mail.gmail.com>
From: Steeve Boulanger <sboulanger29@gmail.com>
Date: Thu, 21 Nov 2024 15:33:36 -0600
Message-ID: <CAAiSvx9aZHPzMYcQtK5yNyPxcd4Le1erpUONP1W8DMvSi4vP=A@mail.gmail.com>
Subject: Re: Database stats ( pg_stat_database.stats_reset ) get reset on
 daily basis - why?
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000095dee3062773056c"
Archived-At: <https://www.postgresql.org/message-id/CAAiSvx9aZHPzMYcQtK5yNyPxcd4Le1erpUONP1W8DMvSi4vP%3DA%40mail.gmail.com>
Precedence: bulk

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

Hello Ron,

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

Yes you're right - I should have been more explicit.

[local]:5432 postgres@postgres=3D# select current_timestamp -
pg_postmaster_start_time() as uptime;
         uptime
-------------------------
 15 days 10:03:44.048383

-Steeve

On Thu, Nov 21, 2024 at 3:30=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.co=
m> wrote:

> On Thu, Nov 21, 2024 at 4:12=E2=80=AFPM Adrian Klaver <adrian.klaver@akla=
ver.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.
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
>

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

<div dir=3D"ltr">Hello Ron,<div><br></div><div>&gt; Also, &quot;SELECT pg_p=
ostmaster_start_time();&quot; to show the=C2=A0<i>real</i>=C2=A0Postgresql =
start time, instead of what you think it is.</div><div><br></div><div>Yes y=
ou&#39;re right - I should have been more explicit.=C2=A0</div><div><br></d=
iv><div>[local]:5432 postgres@postgres=3D# select current_timestamp - pg_po=
stmaster_start_time() as uptime;<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0uptim=
e<br>-------------------------<br>=C2=A015 days 10:03:44.048383<br></div><d=
iv><br></div><div>-Steeve</div></div><br><div class=3D"gmail_quote"><div di=
r=3D"ltr" class=3D"gmail_attr">On Thu, Nov 21, 2024 at 3:30=E2=80=AFPM Ron =
Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.=
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"><div dir=3D"ltr"><div dir=3D"ltr">On Thu, Nov 21, 2024 at 4:12=E2=80=AFP=
M Adrian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"=
_blank">adrian.klaver@aklaver.com</a>&gt; wrote:</div><div class=3D"gmail_q=
uote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;b=
order-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></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>
</blockquote></div>

--00000000000095dee3062773056c--