MIME-Version: 1.0
From: Fabrice Chapuis <fabrice636861@gmail.com>
Date: Mon, 16 Dec 2024 16:30:39 +0100
Message-ID: 
 <CAA5-nLDgGReN_C9TYsuSC4X04xzGdFbM=V3CsBo2J0xePceOaQ@mail.gmail.com>
Subject: pg_stat_statements_reset
To: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000837862062964dd16"
Archived-At: 
 <https://www.postgresql.org/message-id/CAA5-nLDgGReN_C9TYsuSC4X04xzGdFbM%3DV3CsBo2J0xePceOaQ%40mail.gmail.com>
Precedence: bulk

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

Hi,
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"
);
=E2=94=82 pg_stat_statements_reset =E2=94=82

(1 row)

Something wrong in the use of the function pg_stat_statements_reset?

Regards,

Fabrice

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

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">Hi,<div>This query seems=
 not resetting stats for databae mydb</div><div><br></div><div><div>SELECT =
pg_stat_statements_reset(</div><div>=C2=A0 =C2=A0 NULL,=C2=A0 -- userid: NU=
LL means &quot;all users&quot;</div><div>=C2=A0 =C2=A0 (SELECT oid FROM pg_=
database WHERE datname =3D &#39;mydb&#39;),</div><div>=C2=A0 =C2=A0 NULL=C2=
=A0 =C2=A0-- queryid: NULL means &quot;all queries&quot;</div><div>);</div>=
<div>=E2=94=82 pg_stat_statements_reset =E2=94=82</div><div><br></div><div>=
(1 row)</div></div><div><br></div><div>Something wrong in the use of the fu=
nction pg_stat_statements_reset?</div><div><br></div><div>Regards,</div><di=
v><br></div><div>Fabrice</div><div><br></div></div></div></div>

--000000000000837862062964dd16--