On 12/16/2013 05:26 AM, hubert depesz lubaczewski wrote:
On Sun, Dec 15, 2013 at 04:18:18PM +0000, Yuri Levinsky wrote:
Dear ALL,
I am running PL/pgsql procedure with sql statements that taking a long
time. I able to see them in the log just after their completion. How
can I see currently running SQL statement? I am able to see in
pg_stat_activity only my call to function. Many thanks in advance.
pg_stat_activity and pg logs, can't see what your function does
internally.
What you can do, though, is to add some "RAISE LOG" to the function, so
that it will log its progress.
Check this for example:
http://www.depesz.com/2010/03/18/profiling-stored-proceduresfunctions/
Also, the auto-explain module can peer inside functions. See
<http://www.postgresql.org/docs/current/static/auto-explain.html>
cheers
andrew
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
