Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about DB stats resets - Mailing list pgsql-admin

From raghu ram
Subject Re: Question about DB stats resets
Date
Msg-id CALnrrJSJ3iiZQSfc0jX5ypvDLnhWmSAFp+yo4p_kysrvyE1=TA@mail.gmail.com
Whole thread Raw
In response to Question about DB stats resets  (Luis <luisico@gmail.com>)
List pgsql-admin
Tree view

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 

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Disk latency goes up during certaing pediods
Next
From: Bert
Date:
Subject: vacuum full suddently took extremely long