Re: Question about DB stats resets

From: raghu ram <raghuchennuru(at)gmail(dot)com>
To: Luis <luisico(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Question about DB stats resets
Date: 2013-07-27 06:35:19
Message-ID: CALnrrJSJ3iiZQSfc0jX5ypvDLnhWmSAFp+yo4p_kysrvyE1=TA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Jul 26, 2013 at 9:01 PM, Luis <luisico(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bert 2013-07-29 07:08:27 vacuum full suddently took extremely long
Previous Message Alvaro Herrera 2013-07-26 20:27:14 Re: Disk latency goes up during certaing pediods