Re: pg_stat_statements_reset

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fabrice Chapuis <fabrice636861(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: pg_stat_statements_reset
Date: 2024-12-16 15:47:01
Message-ID: 1976972.1734364021@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Fabrice Chapuis <fabrice636861(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2024-12-16 15:55:54 Re: pg_stat_statements_reset
Previous Message Fabrice Chapuis 2024-12-16 15:30:39 pg_stat_statements_reset