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> <CAKAnmmLnTkwgpbmjafjWcxci29Jn24nF8gqUp4kmbBv_YFASCQ@mail.gmail.com>
In-Reply-To: <CAKAnmmLnTkwgpbmjafjWcxci29Jn24nF8gqUp4kmbBv_YFASCQ@mail.gmail.com>
From: Steeve Boulanger <sboulanger29@gmail.com>
Date: Mon, 25 Nov 2024 20:48:38 -0600
Message-ID: <CAAiSvx8-2MNZ=t1o_PU9R-Z84kL8c-nNGq4FMmdy9jc7z-M7FA@mail.gmail.com>
Subject: Re: Database stats ( pg_stat_database.stats_reset ) get reset on
 daily basis - why?
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: "Ray O'Donnell" <ray@rodonnell.ie>, Adrian Klaver <adrian.klaver@aklaver.com>, 
	pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000077b1ea0627c7e395"
Archived-At: <https://www.postgresql.org/message-id/CAAiSvx8-2MNZ%3Dt1o_PU9R-Z84kL8c-nNGq4FMmdy9jc7z-M7FA%40mail.gmail.com>
Precedence: bulk

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

>  As a superuser, rename pg_stat_reset inside one of the commonly affected
databases:
> alter function pg_stat_reset rename to
hey_stop_running_pg_stat_reset_already;
> Then see who starts complaining. Additionally, your server log will get
helpful entries like this:

Thanks for the tip Greg - that's very clever! I've done this just now,
and will check back tomorrow to see if there's any corresponding error
message.

NB:  I hadn't originally realized that the system functions (ie pg_*) were
created for each database, so I had renamed only the one in the postgres
database, thinking it was global (ie I'll blame this on my Oracle days
;-)).

Now I renamed the function under one database that had been verified as
getting its stats reset on a daily basis. Hopefully tomorrow we'll get more
interesting info!

-Steeve

On Sat, Nov 23, 2024 at 11:50=E2=80=AFAM Greg Sabino Mullane <htamfids@gmai=
l.com>
wrote:

> As a superuser, rename pg_stat_reset inside one of the commonly affected
> databases:
>
> alter function pg_stat_reset rename to
> hey_stop_running_pg_stat_reset_already;
>
> Then see who starts complaining. Additionally, your server log will get
> helpful entries like this:
>
> ERROR:  function pg_stat_reset() does not exist
>
> Cheers,
> Greg
>
>

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

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

As a superuser, rename pg_stat_reset inside one of the commonly affected da=
tabases:<div>&gt; alter function pg_stat_reset rename to hey_stop_running_p=
g_stat_reset_already;</div><div>&gt; Then see who starts complaining. Addit=
ionally, your server log will get helpful entries like this:</div><div><br>=
</div><div>Thanks=C2=A0for the tip Greg - that&#39;s very clever! I&#39;ve =
done this just now, and=C2=A0will check back tomorrow to see if there&#39;s=
 any corresponding error message.=C2=A0</div><div><br></div><div>NB:=C2=A0 =
I hadn&#39;t originally realized that the system functions (ie pg_*) were c=
reated for each database, so I had renamed only the one in the postgres dat=
abase, thinking it was global (ie I&#39;ll blame this on my Oracle days ;-)=
).=C2=A0</div><div><br></div><div>Now I renamed the function under one data=
base that had been verified as getting its stats reset on a daily basis. Ho=
pefully tomorrow we&#39;ll get more interesting info!=C2=A0</div><div><br><=
/div><div>-Steeve</div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr=
" class=3D"gmail_attr">On Sat, Nov 23, 2024 at 11:50=E2=80=AFAM Greg Sabino=
 Mullane &lt;<a href=3D"mailto:htamfids@gmail.com">htamfids@gmail.com</a>&g=
t; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0p=
x 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div d=
ir=3D"ltr">As a superuser, rename pg_stat_reset inside one of the commonly =
affected databases:<div><br></div><div>alter function pg_stat_reset rename =
to hey_stop_running_pg_stat_reset_already;</div><div><br></div><div>Then se=
e who starts complaining. Additionally, your server log will get helpful en=
tries like this:</div><div><br></div><div>ERROR: =C2=A0function pg_stat_res=
et() does not exist</div><div><br></div><div>Cheers,</div><div>Greg</div><d=
iv><br></div></div>
</blockquote></div>

--00000000000077b1ea0627c7e395--