Re: clear statistics in pg_stat - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: clear statistics in pg_stat
Date
Msg-id 20071129214753.GA8157@crankycanuck.ca
Whole thread Raw
In response to clear statistics in pg_stat  ("Campbell, Lance" <lance@uiuc.edu>)
List 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

pgsql-admin by date:

Previous
From: "Peter Koczan"
Date:
Subject: Converting from SQL_ASCII to UTF8
Next
From: "Milen A. Radev"
Date:
Subject: Re: clear statistics in pg_stat