Re: Clearing global statistics - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Clearing global statistics
Date
Msg-id 24296.1263484860@sss.pgh.pa.us
Whole thread Raw
In response to Re: Clearing global statistics  (Rafael Martinez <r.m.guerrero@usit.uio.no>)
Responses Re: Clearing global statistics  (Greg Smith <greg@2ndquadrant.com>)
Re: Clearing global statistics  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
Rafael Martinez <r.m.guerrero@usit.uio.no> writes:
> Is there any chance of implementing a way of knowing when was the last
> time statistics delivered via pg_stat_* were reset?

Actually, that brings up a more general question: what's with the
enthusiasm for clearing statistics *at all*?  ISTM that's something
you should do only in dire emergencies, like the collector went
haywire and has now got a bunch of garbage numbers.  The notion of
resetting subsets of the stats seems even more dubious, because now
you have numbers that aren't mutually comparable.  So I fail to
understand why the desire to expend valuable development time on
any of this.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: archive_timeout behavior for no activity
Next
From: "Kevin Grittner"
Date:
Subject: Re: archive_timeout behavior for no activity