Home > mailing lists

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

From	Magnus Hagander
Subject	Re: Gauging progress of COPY?
Date	January 22, 2022 13:09:23
Msg-id	CABUevExRoUYbQhb9zMu3ZzJoaa69uYMt_s=JBkCaL6rXsFSiCg@mail.gmail.com Whole thread Raw
In response to	Gauging progress of COPY? (Wells Oliver <wells.oliver@gmail.com>)
Responses	Re: Gauging progress of COPY? (Greg Spiegelberg <gspiegelberg@gmail.com>)
List	pgsql-admin

On Thu, Jan 20, 2022, 19:01 Wells Oliver <wells.oliver@gmail.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

From: Vijaykumar Jain
Date: 22 January 2022, 10:43:41
Subject: Re: Determine potential change in table size after a column dropped?

From: Ron
Date: 22 January 2022, 16:38:26
Subject: Re: Determine potential change in table size after a column dropped?