How to display the progress of query

From: pasman pasmański <pasman(dot)p(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: How to display the progress of query
Date: 2011-11-24 13:37:11
Message-ID: CAOWY8=Y+O4ghztMUECYX4iV5N9MCZt_zbfjzQrjsRCrCTtVbwA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2011-11-24 13:47:12 How to get normalized data from tekst column
Previous Message Yeb Havinga 2011-11-24 13:20:59 Re: Recommendations for SSDs in production?