Re: clear statistics in pg_stat

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: clear statistics in pg_stat
Date: 2007-11-29 21:47:53
Message-ID: 20071129214753.GA8157@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Nov 29, 2007 at 03:32:59PM -0600, Campbell, Lance wrote:
> How can I clear pg_stat views? I thought there was a command I could

According to the manual, there's this:

pg_stat_reset()

I suggest you read the section of the manual about stats collection.

A

--
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Milen A. Radev 2007-11-29 21:52:27 Re: clear statistics in pg_stat
Previous Message Peter Koczan 2007-11-29 21:37:06 Converting from SQL_ASCII to UTF8