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 22B03D1B19B for ; Mon, 12 Jul 2004 23:45:12 -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 69930-03 for ; Tue, 13 Jul 2004 02:45:12 +0000 (GMT) Received: from sccrmhc13.comcast.net (sccrmhc13.comcast.net [204.127.202.64]) by svr1.postgresql.org (Postfix) with ESMTP id 3ED03D1B2A6 for ; Mon, 12 Jul 2004 23:45:06 -0300 (ADT) Received: from localhost.localdomain (c-67-162-89-61.client.comcast.net[67.162.89.61]) by comcast.net (sccrmhc13) with ESMTP id <2004071302450801600ab6m0e>; Tue, 13 Jul 2004 02:45:10 +0000 Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by localhost.localdomain (8.12.11/8.12.11) with ESMTP id i6D2hOYg028741; Mon, 12 Jul 2004 21:43:24 -0500 Received: (from spike@localhost) by localhost.localdomain (8.12.11/8.12.11/Submit) id i6D2hNrU028738; Mon, 12 Jul 2004 21:43:23 -0500 X-Authentication-Warning: localhost.localdomain: spike set sender to mike@thegodshalls.com using -f Subject: Re: statistics collector: number of function calls From: mike g Reply-To: mike@thegodshalls.com To: Markus Bertheau Cc: pgsql-admin@postgresql.org In-Reply-To: <1089644918.3246.14.camel@dicaprio.akademie1.de> References: <1089644918.3246.14.camel@dicaprio.akademie1.de> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1089686603.28592.10.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-7) Date: Mon, 12 Jul 2004 21:43:23 -0500 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/135 X-Sequence-Number: 14203 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. HTH. On Mon, 2004-07-12 at 10:08, Markus Bertheau wrote: > Hi, > > I'd find it useful if the statistics collector (or someone else) counted > the number of times a function was called (or whether it was called at > all). Given that PL/pgSQL-Functions are compiled only at the first call > this would provide for a possibility to check whether every function has > been used and therefore compiled successfully during a test run of an > application. > > Is something like this planned or already available, but hidden well? > > Thanks