Re: pg_stat_all_tables column value reseting problem.

From: "Nicholson, Brad (Toronto, ON, CA)" <bnicholson(at)hp(dot)com>
To: leslie samuel <leslie(dot)bks(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_stat_all_tables column value reseting problem.
Date: 2011-03-18 13:28:54
Message-ID: 2626AEE4839D064CB0472A3814DC403F46D20812BE@GVW1092EXB.americas.hpqcorp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-
> owner(at)postgresql(dot)org] On Behalf Of leslie samuel
> Sent: Friday, March 18, 2011 1:17 AM
> To: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] pg_stat_all_tables column value reseting problem.
>
> Thanks for ur reply Ragu..
>
> Yes, I have executed this select pg_stat_reset(); as a root user.
> It has reseted the values.
>
> But last time ( when I was posted this query) I didn't executed it.
> But values were rested automatically.
>
> I would like to know,
>
> => Whether postgres automatically running this select
> pg_stat_reset();
> statement ?
> => If it runs Which scenario its executing this statement and what
> is the
> interval time between each execution ?
>
> Please let me know..
> Thanks..
>

If you stop/restart the database in immediate mode, or if it crashes the stats will be reset. What mode did you use for shutdown?

Brad.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nicholson, Brad (Toronto, ON, CA) 2011-03-18 14:17:29 Re: Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?
Previous Message Tapio Pitkäranta 2011-03-18 08:10:18 Re: Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?