How to display the progress of query - Mailing list pgsql-general

From pasman pasmański
Subject How to display the progress of query
Date
Msg-id CAOWY8=Y+O4ghztMUECYX4iV5N9MCZt_zbfjzQrjsRCrCTtVbwA@mail.gmail.com
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: Yeb Havinga
Date:
Subject: Re: Recommendations for SSDs in production?
Next
From: "Andrus"
Date:
Subject: How to get normalized data from tekst column