Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 0EFBD1337B8B
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 18 Mar 2011 02:16:55 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 70158-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 18 Mar 2011 05:16:45 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from sam.nabble.com (sam.nabble.com [216.139.236.26])
	by mail.postgresql.org (Postfix) with ESMTP id 8C9D81337B82
	for <pgsql-admin@postgresql.org>; Fri, 18 Mar 2011 02:16:44 -0300 (ADT)
Received: from [192.168.236.26] (helo=sam.nabble.com)
	by sam.nabble.com with esmtp (Exim 4.69)
	(envelope-from <leslie.bks@gmail.com>) id 1Q0S3G-0005Y3-VH
	for pgsql-admin@postgresql.org; Thu, 17 Mar 2011 22:16:42 -0700
Date: Thu, 17 Mar 2011 22:16:42 -0700 (PDT)
From: leslie samuel <leslie.bks@gmail.com>
To: pgsql-admin@postgresql.org
Message-ID: <1300425402963-3933652.post@n5.nabble.com>
In-Reply-To: <AANLkTins9v14V3zmjs_4Z=_z-9EJhK5zBq4BXqi2dFXG@mail.gmail.com>
References: <1300262337849-3767851.post@n5.nabble.com>
	<AANLkTins9v14V3zmjs_4Z=_z-9EJhK5zBq4BXqi2dFXG@mail.gmail.com>
Subject: Re: pg_stat_all_tables column value reseting problem.
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.767 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01,
	URI_HEX=1.122
X-Spam-Level: 
X-Archive-Number: 201103/194
X-Sequence-Number: 37066

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

--
View this message in context: http://postgresql.1045698.n5.nabble.com/pg-stat-all-tables-column-value-reseting-problem-tp3767851p3933652.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.