Postgres Pro
Downloads
Home   >   mailing lists

Re: Reinitialising stats once only without restarting - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: Reinitialising stats once only without restarting
Date
Msg-id 20071220133559.GF5309@alvh.no-ip.org
Whole thread Raw
In response to Reinitialising stats once only without restarting  ("Anton Melser" <melser.anton@gmail.com>)
Responses Re: Reinitialising stats once only without restarting  ("Anton Melser" <melser.anton@gmail.com>)
List pgsql-performance
Tree view 
Anton Melser escribió:
> Hi,
> Sorry but I couldn't find the answer to this...
>
> I would like to empty all stats (pg_stat_all_tables probably mostly)
> so I can get an idea of what's going on now. Is this possible? I
> didn't want to just go deleting without knowing what it would do...

Sure, use pg_stat_reset();

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-performance by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Minimizing dead tuples caused by update triggers
Next
From: "Jan de Visser"
Date:
Subject: Re: Dual core Opterons beating quad core Xeons?