Message-ID: <1387355427.2240.4.camel@localhost>
Subject: Re: Current query of the PL/pgsql procedure.
From: Guillaume Lelarge <guillaume@lelarge.info>
To: Yuri Levinsky <yuril@celltick.com>
Cc: "depesz@depesz.com" <depesz@depesz.com>,
 "pgsql-performance@postgresql.org"
 <pgsql-performance@postgresql.org>, Craig James <cjames@emolecules.com>
Date: Wed, 18 Dec 2013 09:30:27 +0100
In-Reply-To: <C9278837BA426D4DBDF8996DB89023260B79A7@Cobra.celltick.com>
References: <C9278837BA426D4DBDF8996DB89023260B685B@Cobra.celltick.com>
 <20131216102619.GA27781@depesz.com>
 <C9278837BA426D4DBDF8996DB89023260B79A7@Cobra.celltick.com>
Content-Type: text/plain; charset="UTF-8"
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

On Mon, 2013-12-16 at 11:42 +0000, Yuri Levinsky wrote:
>  Dear Depesz,
> This is very problematic solution: I have to change whole!!! my code to put appropriate comment with query text before any query execution. In addition I would like to know current execution plan, that seems to be impossible. This is very hard limitation let's say. In case of production issue I'll just unable to do it: the issue already happening, I can't stop procedure and start code change.
> James,
> I saw your reply: I see the function is running, it's just not clear that exactly and how this function doing. 
> 

This blog post
(http://blog.guillaume.lelarge.info/index.php/post/2012/03/31/Profiling-PL/pgsql-functions) can probably help you profiling your PL/pgsql functions without modifying them.

I'm interested in any comments you can have on the log_functions hook
function.

Regards.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance