From: | Colin Wetherbee <cww(at)denterprises(dot)org> |
---|---|
To: | Kynn Jones <kynnjo(at)gmail(dot)com> |
Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to monitor the progress of a stored procedure? |
Date: | 2008-02-27 23:44:23 |
Message-ID: | 47C5F5D7.4000503@denterprises.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Kynn Jones wrote:
> I have a stored procedure that has been running for a very long time.
> Before doing the current "real" run, I tested the procedure on a toy
> case and confirmed that it produced the right result. So I know that
> when it finishes it will be OK, but I can't tell whether it will finish
> in an hour or in a century... I have no idea of how far along it is.
> (In case it matters, the procedure is written in PL/perl. I tried to
> use Perl's print statement, unbuffered, to print out a message
> periodically from within the procedure, but I see no output.)
When I print() from PL/Perl, the messages show up in the PostgreSQL log
file. It's not an obvious place, but it makes sense because PL/Perl
functions aren't always called from interactive terminals. Did you look
there?
Colin
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GÜNDÜZ | 2008-02-28 00:06:50 | Re: RHEL3 configure ssl |
Previous Message | Erik Jones | 2008-02-27 23:37:25 | Re: How to monitor the progress of a stored procedure? |