Re: keeping track of function execution

On Sun, May 3, 2009 at 9:38 AM, Wojtek <foo@twine.pl> wrote:
> Hi,
>
> I have a question on transactions/isolation levels/etc...
> In my PL/pgSQL function main loop goes through inventory list of active
> devices, for each one executing processing applicable for given device,
> like:
> FOR i in --i is %rowtype
> select device_id as device_id,
> type as type
> from devices_list
> where active = 1
> LOOP
>   (...)
> -- here is CASE statement, checking value of 'type' parameter
>  (....)
> END LOOP; --simple enough, right?
>
> This processing is pretty heavy and takes lot of time... so, I'd like to be
> able to monitor as processing progresses and I need to be able to say:
> -which devices've been processed already
> -which ones've not been processed yet

You could raise notice and then tail the logs as it runs.  Or the
other option mentioned of using dblink() works well too.