PostgreSQL High Availability Cookbook - Second Edition

Resetting the stats

Statistics stored in the pg_stat_statements view accumulate until they are forcefully reset. If we don't want to monitor value deltas between checks, we can simply reset the status of the module and cause it to erase the data it has collected. To do that, execute this SQL statement as a superuser:

SELECT pg_stat_statements_reset();