Which are the reasons why pg_stats_all_table values might reset on a database?

471 Views Asked by At

I have read the PostgreSLQ documentation and it states that these conditions might reset the statistics' collection values:

  • Immediate Shutdown of the database
  • Server Crash (where the db is hosted)
  • Manual resetting with SELECT pg_stat_statements_reset();
  • Point-in-time recovery

I already made sure that the instace did not face a shutdown or crash and I did not manually reset the values with that query.

  • What could other reasons might trigger the values reset?

Further questions

  • Could a backup mess up these values as well?
  • How could I throubleshoot this?
0

There are 0 best solutions below