Re: pg_stat_statements_reset

[Fabrice Chapuis <fabrice636861@xxxxxxxxx>]

Thanks for your explanations Tom, Guillaume, your solution works fine for me too.

Regards

Fabrice

On Mon, Dec 16, 2024 at 4:56 PM Guillaume Lelarge <guillaume@xxxxxxxxxxxx> wrote:

Hello,

Le lun. 16 déc. 2024 à 16:47, Tom Lane <tgl@xxxxxxxxxxxxx> a écrit :

Fabrice Chapuis <fabrice636861@xxxxxxxxx> 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 = '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 => oid)

from pg_database

where datname='mydb';

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

--

Guillaume.