Re: pg_stat_statements_reset - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_stat_statements_reset
Date
Msg-id 1976972.1734364021@sss.pgh.pa.us
Whole thread Raw
In response to pg_stat_statements_reset  (Fabrice Chapuis <fabrice636861@gmail.com>)
Responses Re: pg_stat_statements_reset
List 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 by date:

Previous
From: Fabrice Chapuis
Date:
Subject: pg_stat_statements_reset
Next
From: Guillaume Lelarge
Date:
Subject: Re: pg_stat_statements_reset