Postgres Pro
Downloads
Home   >   mailing lists

pg_stat_statements_reset - Mailing list pgsql-admin

From Fabrice Chapuis
Subject pg_stat_statements_reset
Date
Msg-id CAA5-nLDgGReN_C9TYsuSC4X04xzGdFbM=V3CsBo2J0xePceOaQ@mail.gmail.com
Whole thread Raw
Responses Re: pg_stat_statements_reset
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Performance
Next
From: Tom Lane
Date:
Subject: Re: pg_stat_statements_reset