Question about DB stats resets

From: Luis <luisico(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Question about DB stats resets
Date: 2013-07-26 15:31:06
Message-ID: CAM-gcbQBX76OhegxARC8Sv1Agzc1HQ9ka7vD7LDHPmwp-pbRKQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message German Becker 2013-07-26 19:21:25 Disk latency goes up during certaing pediods
Previous Message Bruce Momjian 2013-07-24 18:17:23 Re: Postgres schema having > 20,000 schemas