Re: How to monitor the progress of a stored procedure? - Mailing list pgsql-general

From Klint Gore
Subject Re: How to monitor the progress of a stored procedure?
Date
Msg-id 47C5FC62.5050008@une.edu.au
Whole thread Raw
In response to How to monitor the progress of a stored procedure?  ("Kynn Jones" <kynnjo@gmail.com>)
List 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@une.edu.au


pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: RHEL3 configure ssl
Next
From: "Gevik Babakhani"
Date:
Subject: Re: Can't start Postgres anymore