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 A1919D1B195 for ; Tue, 13 Jul 2004 05:07:43 -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 83888-07 for ; Tue, 13 Jul 2004 08:07:42 +0000 (GMT) Received: from web11.manitu.net (web11.manitu.net [217.11.48.111]) by svr1.postgresql.org (Postfix) with ESMTP id 854ABD1B1C7 for ; Tue, 13 Jul 2004 05:07:33 -0300 (ADT) Received: from [192.168.0.1] (dsl-082-082-191-128.arcor-ip.net [82.82.191.128]) (authenticated) by web11.manitu.net (8.10.2-SOL3/8.10.2) with ESMTP id i6D87Wa06695; Tue, 13 Jul 2004 10:07:33 +0200 Subject: Re: statistics collector: number of function calls From: Markus Bertheau To: mike@thegodshalls.com Cc: pgsql-admin@postgresql.org In-Reply-To: <1089686603.28592.10.camel@localhost.localdomain> References: <1089644918.3246.14.camel@dicaprio.akademie1.de> <1089686603.28592.10.camel@localhost.localdomain> Content-Type: text/plain; charset=UTF-8 Message-Id: <1089706053.2717.0.camel@teetnang> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 13 Jul 2004 10:07:33 +0200 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/137 X-Sequence-Number: 14205 =D0=92 =D0=92=D1=82=D1=80, 13.07.2004, =D0=B2 04:43, mike g =D0=BF=D0=B8=D1= =88=D0=B5=D1=82: > Hello, >=20 > It is possible to enable the statements issued against the db to be > logged in postgresql.conf(log_statement =3D 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? --=20 Markus Bertheau