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
