Обсуждение: clear statistics in pg_stat

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

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.html#MONITORING-STATS-SETUP)


--
Milen A. Radev