Postgres Pro
Downloads
Home   >   mailing lists

clear statistics in pg_stat - Mailing list pgsql-admin

From Campbell, Lance
Subject clear statistics in pg_stat
Date
Msg-id B10E6810AC2A2F4EA7550D072CDE8760197E2A@SAB-FENWICK.sab.uiuc.edu
Whole thread Raw
Responses Re: clear statistics in pg_stat  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: clear statistics in pg_stat  ("Milen A. Radev" <milen@radev.net>)
List pgsql-admin
Tree view

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

 

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Enable Syslog on Postgres
Next
From: "Peter Koczan"
Date:
Subject: Converting from SQL_ASCII to UTF8