| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Stats Collector |
| Date: | 2002-07-23 14:03:25 |
| Message-ID: | 1027433005.4016.35.camel@camel |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
I don't think there is any way to do it without restarting the server
and using STATS_RESET_ON_SERVER_START from the postgresql.conf
you might be able to do it by killing the stats collector process on
your machine, but i cant recall if postmaster will automagically fire up
a new collector or if you have to do something more involved. It might
be worth trying on a development machine.
Robert Treat
On Mon, 2002-07-22 at 22:43, Christopher Kings-Lynne wrote:
> Is there any way of resetting the stats collector without restarting
> Postgres? I want all the pg_stat_* tables to have zero for everything
> again...
>
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wim | 2002-07-23 14:05:11 | Re: [NOVICE] URGENT! pg_dump doesn't work! (fwd) |
| Previous Message | Ian Zapczynski | 2002-07-23 14:01:58 | Exporting data from PostgreSQL 7.1 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2002-07-23 14:05:28 | Re: Stats Collector |
| Previous Message | Zeugswetter Andreas SB SD | 2002-07-23 07:39:21 | Re: CREATE CAST code review |