X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B5B7CD1B23C for ; Tue, 13 Jul 2004 22:37:37 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71268-05 for ; Wed, 14 Jul 2004 01:37:38 +0000 (GMT) Received: from rwcrmhc12.comcast.net (rwcrmhc12.comcast.net [216.148.227.85]) by svr1.postgresql.org (Postfix) with ESMTP id B7A2ED1B220 for ; Tue, 13 Jul 2004 22:37:33 -0300 (ADT) Received: from localhost.localdomain (c-67-162-89-61.client.comcast.net[67.162.89.61]) by comcast.net (rwcrmhc12) with ESMTP id <200407140137310140042o9le>; Wed, 14 Jul 2004 01:37:37 +0000 Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by localhost.localdomain (8.12.11/8.12.11) with ESMTP id i6E1Zeuq003023; Tue, 13 Jul 2004 20:35:41 -0500 Received: (from spike@localhost) by localhost.localdomain (8.12.11/8.12.11/Submit) id i6E1Ze5m003020; Tue, 13 Jul 2004 20:35:40 -0500 X-Authentication-Warning: localhost.localdomain: spike set sender to mike@thegodshalls.com using -f Date: Tue, 13 Jul 2004 20:35:39 -0500 From: Mike G To: Markus Bertheau Cc: mike@thegodshalls.com, pgsql-admin@postgresql.org Subject: Re: statistics collector: number of function calls Message-ID: <20040714013539.GA3003@localhost.localdomain> References: <1089644918.3246.14.camel@dicaprio.akademie1.de> <1089686603.28592.10.camel@localhost.localdomain> <1089706053.2717.0.camel@teetnang> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <1089706053.2717.0.camel@teetnang> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/156 X-Sequence-Number: 14224 I believe you are correct. I will check my logs later. If you have access to the code you could add individual sequences within each procedures and use those as counters. On Tue, Jul 13, 2004 at 10:07:33AM +0200, Markus Bertheau wrote: > В Втр, 13.07.2004, в 04:43, mike g пишет: > > Hello, > > > > It is possible to enable the statements issued against the db to be > > logged in postgresql.conf(log_statement = true). Depending on the OS > > then you can filter the logs or maybe create a Perl script to scan the > > logs. > > Does that help when functions call other functions? The second function > will be nowhere in the logs, right? > > -- > Markus Bertheau > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster