Postgres Pro
Downloads
Home   >   mailing lists

Thread: Question about DB stats resets

Question about DB stats resets

From
Luis
Date:
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 don't know if, somehow, having a busy server or with a high number of DBs may produce this effect.

Thanks

Re: Question about DB stats resets

From
raghu ram
Date:

On Fri, Jul 26, 2013 at 9:01 PM, Luis <luisico@gmail.com> wrote:
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 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