Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group