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

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