From: leslie samuel <leslie.bks@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: pg_stat_all_tables column value reseting problem.
Date: Thu, 17 Mar 2011 22:16:42 -0700 (PDT)
Message-ID: <1300425402963-3933652.post@n5.nabble.com> (raw)
In-Reply-To: <AANLkTins9v14V3zmjs_4Z=_z-9EJhK5zBq4BXqi2dFXG@mail.gmail.com>
References: <1300262337849-3767851.post@n5.nabble.com>
<AANLkTins9v14V3zmjs_4Z=_z-9EJhK5zBq4BXqi2dFXG@mail.gmail.com>
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-tp3767851p3...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: leslie.bks@gmail.com
Subject: Re: pg_stat_all_tables column value reseting problem.
In-Reply-To: <1300425402963-3933652.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox