Re: [ADMIN] clear statistics in pg_stat

2007-11-29 Thread Milen A. Radev
Campbell, Lance написа: > 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. "pg_stat_reset()"? (http://www.postgresql.org/docs/current/static/monitoring-stats.ht

Re: [ADMIN] clear statistics in pg_stat

2007-11-29 Thread Andrew Sullivan
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 wi

[ADMIN] clear statistics in pg_stat

2007-11-29 Thread Campbell, Lance
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 Illi