PostgreSQL 12 High Availability Cookbook - Third Edition

There's more...

Growth rates are also important. We recommend creating a scheduled task that checks these results at the end of every day and either emails them to a responsible DBA or saves them into a table for further examination. After the statistics are checked and logged, call the following two functions to reset them to zero:

SELECT pg_stat_statements_reset();
SELECT pg_stat_reset(); 

Any tables that are growing quickly are even more critical to identify early.