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

Re: pg_stat_all_tables column value reseting problem.

From: leslie samuel <leslie(dot)bks(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_stat_all_tables column value reseting problem.
Date: 2011-03-18 05:16:42
Message-ID: 1300425402963-3933652.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-admin
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.

In response to

Responses

pgsql-admin by date

Next:From: Devrim GÜNDÜZDate: 2011-03-18 07:21:44
Subject: Re: Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?
Previous:From: agfkDate: 2011-03-17 17:03:18
Subject: Re: Postgres Crash

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