Re: statistics collector: number of function calls

From: mike g <mike(at)thegodshalls(dot)com>
To: Markus Bertheau <twanger(at)bluetwanger(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: statistics collector: number of function calls
Date: 2004-07-13 02:43:23
Message-ID: 1089686603.28592.10.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2004-07-13 07:54:29 Slony NG
Previous Message Sarah Tanembaum 2004-07-12 22:09:59 Re: Secure DB Systems - How to