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

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

From: Klint Gore <kgore4(at)une(dot)edu(dot)au>
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-28 00:12:18
Message-ID: 47C5FC62.5050008@une.edu.au (view raw or flat)
Thread:
Lists: pgsql-general
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?
>
> [...](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.)
elog?  (see example in 
http://www.postgresql.org/docs/8.3/interactive/plperl-database.html)

klint.

-- 
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350

Ph: 02 6773 3789  
Fax: 02 6773 3266
EMail: kgore4(at)une(dot)edu(dot)au


In response to

pgsql-general by date

Next:From: Gevik BabakhaniDate: 2008-02-28 00:29:43
Subject: Re: Can't start Postgres anymore
Previous:From: Simon RiggsDate: 2008-02-28 00:07:29
Subject: PostgreSQL UK 2008 Conference

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