pg_stat_statements_reset

From: Fabrice Chapuis <fabrice636861(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: pg_stat_statements_reset
Date: 2024-12-16 15:30:39
Message-ID: CAA5-nLDgGReN_C9TYsuSC4X04xzGdFbM=V3CsBo2J0xePceOaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
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"
);
│ pg_stat_statements_reset │

(1 row)

Something wrong in the use of the function pg_stat_statements_reset?

Regards,

Fabrice

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2024-12-16 15:47:01 Re: pg_stat_statements_reset
Previous Message Ron Johnson 2024-12-16 14:20:17 Re: Performance