Re: Logging functions executed by queries in 8.2? - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Logging functions executed by queries in 8.2?
Date
Msg-id 200702051626.10094.josh@agliodbs.com
Whole thread Raw
In response to Logging functions executed by queries in 8.2?  (Josh Berkus <josh@agliodbs.com>)
List 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


pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Proposed adjustments in MaxTupleSize and toastthresholds
Next
From: Tom Lane
Date:
Subject: Re: Logging functions executed by queries in 8.2?