Re: Gauging progress of COPY?

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Gauging progress of COPY?
Date: 2022-01-22 10:09:23
Message-ID: CABUevExRoUYbQhb9zMu3ZzJoaa69uYMt_s=JBkCaL6rXsFSiCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Jan 20, 2022, 19:01 Wells Oliver <wells(dot)oliver(at)gmail(dot)com> wrote:

> 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 you can open a second connection, you can just query
pg_stat_progress_copy.

/Magnus

>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2022-01-22 13:38:26 Re: Determine potential change in table size after a column dropped?
Previous Message Vijaykumar Jain 2022-01-22 07:43:41 Re: Determine potential change in table size after a column dropped?