Re: [GENERAL] Is there a way to tell how far along a COPY is in the process?

[andy]

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?

Thanks,

Keaton

I use this little perl function:

sub runscript($)
{
        my $fname = pop;
        open(F, $fname) or die;
        print "executing $fname\n";
        my $sql = <F>;
        $db->do($sql) or die 'cant start copy';
        my $c = 0;
        while (<F>)
        {
                $db->pg_putline($_);
                if ($c % 10_000 == 0) {
                        print "$c\r";
                        if ($stop) { die; }
                }
                $c++;
        }
        print "$c total\n";
        $db->pg_endcopy;
        unlink($fname);
}


The first line in the file needs to be the sql copy command, like:

print F "copy junk(id, name, address) from stdin;\n";

The following lines are the data, like:

print F "$id\t$name\t$add\n";


-Andy

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly