On Nov 5, 2007, at 1:32 PM, Keaton Adams wrote:
I’m looking for a way to see how many rows have been processed
while a COPY is actually running. I can’t seem to find a pg_stat
table/view that will give me this level of visibility into the
process.
Is there any way to do this, to tell the number of rows processed
during a COPY into a table while the COPY is still running?
No, because changes made by any given transaction are not visible to
other transactions until that transaction commits, which would be
when the COPY completes if it is the only statement in the
transaction. What you could do is split the file whose data you're
COPYing in into smaller pieces and run separate, sequential COPYs if
you really need something along those lines.
Erik Jones
Software Developer | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
