Re: pg_stat_statements_reset

Hello,

Le lun. 16 déc. 2024 à 16:47, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> a écrit :

> Fabrice Chapuis <fabrice636861(at)gmail(dot)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 = '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.