Re: Stats Collector

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...

Hmmm,

there is a special control message for the collector to do so, and a
function that sends it exists too. But there is absolutely no way to
call it =:-O

Looks to me, someone forgot something. That would be me and now I
remember that I originally wanted to add some utility command for that.

What you need in the meantime is a little C function that calls

void pgstat_reset_counters(void);

I might find the time tomorrow to write one for you if you don't know
how.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #