Обсуждение: Question about DB stats resets
Hi, I have a doubt about stats reset.
I've been investigating some zero values in some tables tuples stats.
By querying pg_stat_database view I can see reset times (pg_stat_database) that have not been performed by me (doing a SELECT pg_stat_reset())
My question is, what other actions or events may reset the stats of a DB?I've been investigating some zero values in some tables tuples stats.
By querying pg_stat_database view I can see reset times (pg_stat_database) that have not been performed by me (doing a SELECT pg_stat_reset())
I don't know if, somehow, having a busy server or with a high number of DBs may produce this effect.
On Fri, Jul 26, 2013 at 9:01 PM, Luis <luisico@gmail.com> wrote:
Hi, I have a doubt about stats reset.My question is, what other actions or events may reset the stats of a DB?
I've been investigating some zero values in some tables tuples stats.
By querying pg_stat_database view I can see reset times (pg_stat_database) that have not been performed by me (doing a SELECT pg_stat_reset())I don't know if, somehow, having a busy server or with a high number of DBs may produce this effect.
Statistics will reset whenever we are stopping PostgreSQL Instance in IMMEDIATE mode.
Thanks & Regards
Raghu Ram