Re: statistics collector: number of function calls

From: Mike G <mike(at)thegodshalls(dot)com>
To: Markus Bertheau <twanger(at)bluetwanger(dot)de>
Cc: mike(at)thegodshalls(dot)com, pgsql-admin(at)postgresql(dot)org
Subject: Re: statistics collector: number of function calls
Date: 2004-07-14 01:35:39
Message-ID: 20040714013539.GA3003@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I believe you are correct. I will check my logs later. If you have access to the code you could add individual sequences within each procedures and use those as counters.

On Tue, Jul 13, 2004 at 10:07:33AM +0200, Markus Bertheau wrote:
> В Втр, 13.07.2004, в 04:43, mike g пишет:
> > 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.
>
> Does that help when functions call other functions? The second function
> will be nowhere in the logs, right?
>
> --
> Markus Bertheau <twanger(at)bluetwanger(dot)de>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Markus Bertheau 2004-07-14 02:08:22 Re: statistics collector: number of function calls
Previous Message Jim Seymour 2004-07-14 00:28:52 Re: Slony NG