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.
Hi @nathanielobrown
To reset “Query statistics” you can use the below command which will discards statistics gathered so far by “pg_stat_statements” corresponding to the specified userid, dbid and queryid.
If you are getting any error while running this, Kindly check if “pg_stat_statements” is available.
You can use the below command to create extension :
Regards, Rajkishore
Same question but for MySQL