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

clear statistics in pg_stat

From: "Campbell, Lance" <lance(at)uiuc(dot)edu>
To: "posgres support" <pgsql-admin(at)postgresql(dot)org>
Subject: clear statistics in pg_stat
Date: 2007-11-29 21:32:59
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
How can I clear pg_stat views?  I thought there was a command I could
do.  I added a series of indexes.  I would like to start out fresh with
the stats.  I ran vacuum full analyze.




Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois




pgsql-admin by date

Next:From: Peter KoczanDate: 2007-11-29 21:37:06
Subject: Converting from SQL_ASCII to UTF8
Previous:From: Joshua D. DrakeDate: 2007-11-29 17:18:08
Subject: Re: Enable Syslog on Postgres

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