Re: Clearing global statistics

Greg Smith wrote:
> 
>> Before 8.3, we had the stats_reset_on_server_start parameter and
>> the pg_postmaster_start_time() function. This was an easy way of
>> resetting *all* statistics delivered by pg_stat_* and knowing when
>> this was done. We were able to produce stats with information about
>> sec/hours/days average values in an easy way.
>> 
> 
> With this new feature I'm submitting, you can adjust your database 
> startup scripts to make this happen again.  Start the server, 
> immediately loop over every database and call pg_stat_reset on them
> all, and call pg_stat_reset_shared('bgwriter').  Now you've got
> completely cleared stats that are within a second or two of 
> pg_postmaster_start_time(), should be close enough to most purposes.
>  Theoretically we could automate that better, but I've found it hard
> to justify working on given that it's not that difficult to handle
> outside of the database once the individual pieces are exposed.
> 


Great, this is good enough and we get what we need. Thanks :-)

regards
-- Rafael Martinez, <r.m.guerrero@usit.uio.no>Center for Information Technology ServicesUniversity of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/