Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 881C11337BDB for ; Wed, 20 Apr 2011 16:47:41 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 11984-04-7 for ; Wed, 20 Apr 2011 19:47:31 +0000 (UTC) X-Greylist: delayed 00:15:57.717248 by SQLgrey-1.7.6 Received: from out2.mail.amis.hr (out2.mail.amis.hr [188.129.0.5]) by mail.postgresql.org (Postfix) with ESMTP id 974A11337BD5 for ; Wed, 20 Apr 2011 16:47:30 -0300 (ADT) Received: from out.fsec.sm.srv.amis.hr (out.fsec.sm.srv.amis.hr [192.168.106.22]) by out2.mail.amis.hr (Postfix) with ESMTP id EBFAA1FE88 for ; Wed, 20 Apr 2011 21:31:30 +0200 (CEST) Received: from pps.filterd (out [127.0.0.1]) by out.fsec.sm.srv.amis.hr (8.14.3/8.14.3) with SMTP id p3KJUZAL027731 for ; Wed, 20 Apr 2011 21:31:30 +0200 Received: from smtp.amis.hr (smtp.sm.srv.amis.hr [192.168.106.39]) by out.fsec.sm.srv.amis.hr with ESMTP id vsc3v0evy-1 for ; Wed, 20 Apr 2011 21:31:30 +0200 A-Original-Client-UID: 188.129.69.47 splivalo Received: from [192.168.10.1] (cpe-188-129-69-47.dynamic.amis.hr [188.129.69.47]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: splivalo) by smtp.amis.hr (Postfix) with ESMTPSA id ACDF836B for ; Wed, 20 Apr 2011 21:31:30 +0200 (CEST) Message-ID: <4DAF3492.1000205@megafon.hr> Date: Wed, 20 Apr 2011 21:31:30 +0200 From: Mario Splivalo User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.14) Gecko/20110223 Thunderbird/3.1.8 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Reseting statistics, cluster wide Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.2.15, 1.0.148, 0.0.0000 definitions=2011-04-20_06:2011-04-20, 2011-04-20, 1970-01-01 signatures=0 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 ipscore=0 suspectscore=1 phishscore=0 bulkscore=0 adultscore=0 classifier=spam adjust=0 reason=mlx engine=6.0.2-1012030000 definitions=main-1104200093 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201104/194 X-Sequence-Number: 37375 I have set up munin monitoring that plots nice graphs using pg_stat_bgwriter and pg_stat_database views. It has been on for quite some time now, and the numbers those views return are too big for munin to handle. I would like to reset those statistics. As explained by manual, pg_stat_reset() resets only db-related statistics, not the ones used cluster-wide. Is there a way to reset those? I don't mind stopping the server if I need to, but I'd realy like to have those started all over again. Mario