Re: Logging functions executed by queries in 8.2?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Logging functions executed by queries in 8.2?
Date: 2007-02-06 00:26:08
Message-ID: 200702051626.10094.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hackers,

> In recent versions, we've changed the logging of function executions so
> that only the function call is logged, and not any of the queries which
> it may execute internally. While most of the time this method is
> superior for performance analysis, in applications with extensive
> multi-line stored procedures sometimes you want to log each individual
> query.

Actually, it's even more twisted now; if I turn on debug_print_plan, I can
get the *plan* for queries executed by a function, but I can't get their
durations.

--
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-02-06 01:38:47 Re: Logging functions executed by queries in 8.2?
Previous Message Jan Wieck 2007-02-06 00:18:26 Re: Proposed adjustments in MaxTupleSize and toastthresholds