Postgres Pro
Downloads
Home   >   mailing lists

Question about DB stats resets - Mailing list pgsql-admin

From Luis
Subject Question about DB stats resets
Date
Msg-id CAM-gcbQBX76OhegxARC8Sv1Agzc1HQ9ka7vD7LDHPmwp-pbRKQ@mail.gmail.com
Whole thread Raw
Responses Re: Question about DB stats resets  (raghu ram <raghuchennuru@gmail.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Postgres schema having > 20,000 schemas
Next
From: German Becker
Date:
Subject: Disk latency goes up during certaing pediods