Answer the question
In order to leave comments, you need to log in
How often do you reset pg_stat_statements statistics?
pg_stat_statements collects statistics for the entire PostgreSQL instance.
This extension is commonly used by DBAs as a data source for reporting (this data is actually the sum of the counts since the counters were reset).
By default, statistics are not reset.
I understand it needs to be reset periodically. But I can't find specific recommendations.
How often do you reset pg_stat_statements statistics?
Answer the question
In order to leave comments, you need to log in
We make a daily cron report, after which we call pg_stat_statements_reset. That is once a day.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question