Re: Gauging progress of COPY? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Gauging progress of COPY?
Date
Msg-id 892470.1642702398@sss.pgh.pa.us
Whole thread Raw
In response to Gauging progress of COPY?  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
Wells Oliver <wells.oliver@gmail.com> writes:
> Is there some clever way to gauge the progress of a COPY command? i.e. you
> know it has 10m rows, but you can't SELECT COUNT(*).

If it's a COPY IN (to a table) you could monitor growth of the
physical size of the table, cf pg_relation_size().  This isn't
terribly satisfactory if you're not clear on how much space each
row will take, but it's something.

            regards, tom lane



pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Gauging progress of COPY?
Next
From: Sbob
Date:
Subject: AWS 'Instance Features'?