The “Query statistics” section is great for finding slow queries so they can be speed up. However, once the query is improved I would like a way to reset these statistics so the old, slow queries are gone. Is there a way to do this?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
2 answers

Same question but for MySQL

Hi @nathanielobrown

To reset “Query statistics” you can use the below command which will discards statistics gathered so far by “pgstatstatements” corresponding to the specified userid, dbid and queryid.

SELECT pg_stat_statements_reset();

If you are getting any error while running this, Kindly check if “pgstatstatements” is available.

You can use the below command to create extension :

CREATE EXTENSION IF NOT EXISTS "pg_stat_statements";

Regards,
Rajkishore