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