How to display the progress of query

[pasman pasmański <pasman.p@xxxxxxxxx>]

Hi.

I try to monitor a progress of the insert statement:

insert into table1
  (id,other fields)
select
  id+0*nextval('public.progress'),other fields

>From second session i run:

select nextval('public.progress');

but sequence 'progress' looks unchanged.
How to display number of processed rows ?


------------
pasman

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general