Re: pg_stat_statements_reset
| От | Guillaume Lelarge |
|---|---|
| Тема | Re: pg_stat_statements_reset |
| Дата | |
| Msg-id | CAECtzeVW34wcE0UVRg4jCvX=aCp1DpYed_av9rhjHDHAT-fjyQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: pg_stat_statements_reset (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: pg_stat_statements_reset
|
| Список | pgsql-admin |
Hello,
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).
--
Guillaume.
В списке pgsql-admin по дате отправления: