Skip site navigation (1) Skip section navigation (2)

Re: How to monitor the progress of a stored procedure?

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 (view raw or flat)
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

In response to

pgsql-general by date

Next:From: Devrim GÜNDÜZDate: 2008-02-28 00:06:50
Subject: Re: RHEL3 configure ssl
Previous:From: Erik JonesDate: 2008-02-27 23:37:25
Subject: Re: How to monitor the progress of a stored procedure?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group