Re: pg_stat_statements_reset

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_stat_statements_reset
Дата
Msg-id 1976972.1734364021@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_stat_statements_reset  (Fabrice Chapuis <fabrice636861@gmail.com>)
Ответы Re: pg_stat_statements_reset
Список pgsql-admin
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.

            regards, tom lane



В списке pgsql-admin по дате отправления: