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>
In-Reply-To: <CAAiSvx9HPJAXtTxyjs7uyJN+0NSBXGtwJiF15GSAjHdYwh4V7A@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Sat, 23 Nov 2024 12:49:45 -0500
Message-ID: <CAKAnmmLnTkwgpbmjafjWcxci29Jn24nF8gqUp4kmbBv_YFASCQ@mail.gmail.com>
Subject: Re: Database stats ( pg_stat_database.stats_reset ) get reset on
 daily basis - why?
To: Steeve Boulanger <sboulanger29@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="0000000000002f571a06279822e8"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmLnTkwgpbmjafjWcxci29Jn24nF8gqUp4kmbBv_YFASCQ%40mail.gmail.com>
Precedence: bulk

--0000000000002f571a06279822e8
Content-Type: text/plain; charset="UTF-8"

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

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

<div dir=3D"ltr">As a superuser, rename pg_stat_reset inside one of the com=
monly affected databases:<div><br></div><div>alter function pg_stat_reset r=
ename to hey_stop_running_pg_stat_reset_already;</div><div><br></div><div>T=
hen see who starts complaining. Additionally, your server log will get help=
ful entries like this:</div><div><br></div><div>ERROR: =C2=A0function pg_st=
at_reset() does not exist</div><div><br></div><div>Cheers,</div><div>Greg</=
div><div><br></div></div>

--0000000000002f571a06279822e8--