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: B10E6810AC2A2F4EA7550D072CDE8760197E2A@SAB-FENWICK.sab.uiuc.edu (view raw or flat)
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.

 

Thanks,

 

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu

 

Responses

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-2014 The PostgreSQL Global Development Group