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

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

From: Erik Jones <erik(at)myemma(dot)com>
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:37:25
Message-ID: 0AE94D9F-6160-464E-82D1-1C63DAD89188@myemma.com (view raw or flat)
Thread:
Lists: pgsql-general
On Feb 27, 2008, at 5:25 PM, Kynn Jones wrote:

> (Sorry for asking so many questions!)
>
> What techniques can one use to monitor the progress of a stored  
> procedure?
>
> Specifically, how can I get the procedure to print a progress  
> indicator message to the screen every once in a while?
>
> 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.)
>
> Thanks in advance,

Read up on this chapter: http://www.postgresql.org/docs/8.2/ 
interactive/plpgsql-errors-and-messages.html

Erik Jones

DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com




In response to

pgsql-general by date

Next:From: Colin WetherbeeDate: 2008-02-27 23:44:23
Subject: Re: How to monitor the progress of a stored procedure?
Previous:From: Kynn JonesDate: 2008-02-27 23:25:40
Subject: How to monitor the progress of a stored procedure?

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