Le lun. 16 déc. 2024 à 16:47, Tom Lane <tgl@sss.pgh.pa.us> a écrit :
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 = '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).
