Re: statistics collector: number of function calls - Mailing list pgsql-admin

From mike g
Subject Re: statistics collector: number of function calls
Date
Msg-id 1089686603.28592.10.camel@localhost.localdomain
Whole thread Raw
In response to statistics collector: number of function calls  (Markus Bertheau <twanger@bluetwanger.de>)
Responses Re: statistics collector: number of function calls  (Markus Bertheau <twanger@bluetwanger.de>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Markus Bertheau
Date:
Subject: statistics collector: number of function calls
Next
From: Gaetano Mendola
Date:
Subject: Slony NG