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.