Re: Current query of the PL/pgsql procedure.

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