From: Guillaume Lelarge <guillaume@lelarge.info>
To: Yuri Levinsky <yuril@celltick.com>
Cc: depesz@depesz.com <depesz@depesz.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Cc: Craig James <cjames@emolecules.com>
Subject: Re: Current query of the PL/pgsql procedure.
Date: Wed, 18 Dec 2013 09:30:27 +0100
Message-ID: <1387355427.2240.4.camel@localhost> (raw)
In-Reply-To: <C9278837BA426D4DBDF8996DB89023260B79A7@Cobra.celltick.com>
References: <C9278837BA426D4DBDF8996DB89023260B685B@Cobra.celltick.com>
<20131216102619.GA27781@depesz.com>
<C9278837BA426D4DBDF8996DB89023260B79A7@Cobra.celltick.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
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.infohttp://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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: guillaume@lelarge.info, yuril@celltick.com, depesz@depesz.com, cjames@emolecules.com
Subject: Re: Current query of the PL/pgsql procedure.
In-Reply-To: <1387355427.2240.4.camel@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox