Re: Clearing global statistics - Mailing list pgsql-hackers

From Itagaki Takahiro
Subject Re: Clearing global statistics
Date
Msg-id 20091207094457.950B.52131E4D@oss.ntt.co.jp
Whole thread Raw
In response to Clearing global statistics  (Greg Smith <greg@2ndquadrant.com>)
Responses Re: Clearing global statistics  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-hackers
Greg Smith <greg@2ndquadrant.com> wrote:

> This implements the TODO item "Allow the 
> clearing of cluster-level statistics", based on previous discussion 
> ending at http://archives.postgresql.org/pgsql-hackers/2009-03/msg00920.php

> -Not sure if this should be named pg_stat_rest_global (to match the way 
> these are called "global stats" in the source) or 
> pg_stat_reset_cluster.  Picked the former for V1, not attached to that 
> decision at all.  Might even make sense to use a name that makes it 
> obvious the pg_stat_bgwriter data is what's targeted.

A couple of comments:
* We will be able to reset global counters and current database's counters.  Do we need to have a method to reset other
databases'counters?  Or, will pg_stat_reset_global just reset counters of all databases?
 
* Is it useful to have a method to reset counters separately?  For example, pg_stat_reset( which text )      which :=
'buffers'| 'checkpoints' | 'tables' | 'functions' |  ...
 

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center




pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Hot standby, recent changes
Next
From: Greg Smith
Date:
Subject: Re: Clearing global statistics