Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group