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
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 |