MIME-Version: 1.0
References: 
 <CAA5-nLDgGReN_C9TYsuSC4X04xzGdFbM=V3CsBo2J0xePceOaQ@mail.gmail.com>
 <1976972.1734364021@sss.pgh.pa.us>
In-Reply-To: <1976972.1734364021@sss.pgh.pa.us>
From: Guillaume Lelarge <guillaume@lelarge.info>
Date: Mon, 16 Dec 2024 16:55:54 +0100
Message-ID: 
 <CAECtzeVW34wcE0UVRg4jCvX=aCp1DpYed_av9rhjHDHAT-fjyQ@mail.gmail.com>
Subject: Re: pg_stat_statements_reset
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Fabrice Chapuis <fabrice636861@gmail.com>,
 pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000ccadc40629653706"
Archived-At: 
 <https://www.postgresql.org/message-id/CAECtzeVW34wcE0UVRg4jCvX%3DaCp1DpYed_av9rhjHDHAT-fjyQ%40mail.gmail.com>
Precedence: bulk

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

Hello,

Le lun. 16 d=C3=A9c. 2024 =C3=A0 16:47, Tom Lane <tgl@sss.pgh.pa.us> a =C3=
=A9crit :

> Fabrice Chapuis <fabrice636861@gmail.com> writes:
> > This query seems not resetting stats for databae mydb
>
> > SELECT pg_stat_statements_reset(
> >     NULL,  -- userid: NULL means "all users"
> >     (SELECT oid FROM pg_database WHERE datname =3D 'mydb'),
> >     NULL   -- queryid: NULL means "all queries"
> > );
>
> Where did you get the idea that NULL means "all"?  AFAICS
> that function is strict, meaning it won't run at all for
> null input.
>
>
You should try:

select pg_stat_statements_reset(dbid =3D> oid)
from pg_database
where datname=3D'mydb';

Works on my test case (and I find it easier to understand, but that may be
subjective).


--=20
Guillaume.

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

<div dir=3D"ltr"><div dir=3D"ltr">Hello,<br></div><br><div class=3D"gmail_q=
uote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">Le=C2=A0l=
un. 16 d=C3=A9c. 2024 =C3=A0=C2=A016:47, Tom Lane &lt;<a href=3D"mailto:tgl=
@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; a =C3=A9crit=C2=A0:<br></div><blo=
ckquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left=
:1px solid rgb(204,204,204);padding-left:1ex">Fabrice Chapuis &lt;<a href=
=3D"mailto:fabrice636861@gmail.com" target=3D"_blank">fabrice636861@gmail.c=
om</a>&gt; writes:<br>
&gt; This query seems not resetting stats for databae mydb<br>
<br>
&gt; SELECT pg_stat_statements_reset(<br>
&gt;=C2=A0 =C2=A0 =C2=A0NULL,=C2=A0 -- userid: NULL means &quot;all users&q=
uot;<br>
&gt;=C2=A0 =C2=A0 =C2=A0(SELECT oid FROM pg_database WHERE datname =3D &#39=
;mydb&#39;),<br>
&gt;=C2=A0 =C2=A0 =C2=A0NULL=C2=A0 =C2=A0-- queryid: NULL means &quot;all q=
ueries&quot;<br>
&gt; );<br>
<br>
Where did you get the idea that NULL means &quot;all&quot;?=C2=A0 AFAICS<br=
>
that function is strict, meaning it won&#39;t run at all for<br>
null input.<br>
<br></blockquote><div><br></div><div>You should try:</div><div><br></div><d=
iv>select pg_stat_statements_reset(dbid =3D&gt; oid)</div><div>from pg_data=
base</div><div>where datname=3D&#39;mydb&#39;;</div><div><br></div><div>Wor=
ks on my test case (and I find it easier to understand, but that may be sub=
jective).</div><br></div><br><span class=3D"gmail_signature_prefix">-- </sp=
an><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr"><div><di=
v dir=3D"ltr"><div>Guillaume.<br></div></div></div></div></div></div>

--000000000000ccadc40629653706--