Thread: How to display the progress of query

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