Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nAzw0-0000Ek-U0 for pgsql-admin@arkaria.postgresql.org; Fri, 21 Jan 2022 19:50:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nAzvz-0004jK-OE for pgsql-admin@arkaria.postgresql.org; Fri, 21 Jan 2022 19:50:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nAzvz-0004j9-De for pgsql-admin@lists.postgresql.org; Fri, 21 Jan 2022 19:50:55 +0000 Received: from tamriel.snowman.net ([70.109.60.50]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nAzvx-0003Ur-DE for pgsql-admin@lists.postgresql.org; Fri, 21 Jan 2022 19:50:54 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 1F3DA5F79F; Fri, 21 Jan 2022 14:50:53 -0500 (EST) Date: Fri, 21 Jan 2022 14:50:53 -0500 From: Stephen Frost To: Ron Cc: pgsql-admin@lists.postgresql.org Subject: Re: Gauging progress of COPY? Message-ID: <20220121195052.GJ10577@tamriel.snowman.net> References: <40d1f57f-7732-108b-8475-20fec24d8748@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="tKy6e3LXpfmanBFM" Content-Disposition: inline In-Reply-To: <40d1f57f-7732-108b-8475-20fec24d8748@gmail.com> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --tKy6e3LXpfmanBFM Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Ron (ronljohnsonjr@gmail.com) wrote: > On 1/20/22 12:00 PM, Wells Oliver wrote: > >Is there some clever way to gauge the progress=A0of a COPY command? i.e.= you > >know it has 10m rows, but you can't SELECT COUNT(*). >=20 > Use a specific tool like pg_bulkload. Or maybe just use pv if you're doing it through psql or such. Thanks, Stephen --tKy6e3LXpfmanBFM Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJh6w6cAAoJEO1sijiDR2RV+y0QAJXKL4po0aOd6DAFCi8s/0jF ZeL+1BTMzLMuu6+TjziX8owWQSmCfrRCRElAP+DYvHL5U2YynPLnMxJdHZTTaPQr jTzG75RLv9ou5TuqYF5P+2mez4wFCnyDFPb4GfhEUBVE25osedS7poLJYLDlZzSx Q/ujhlXsImlGKpsCtCZ8Up5SkBt4K8KkmG0vgp9GArdrFeM7+pm6x+e/ZjEhpY0W QRUhjAdBN56h3xtIWGCiX21Lb8tVkiUxTnB2cFgveOxqF6mm+XAM7NQE88CkvsY1 tSL/fvA4mmeMziY7Y74aqzttUfOtCTXpkkKuSDch6s6l/Y2DV5vrrt+03ZaHj/iH 1U968T6qxHNp2HwPMJQHyWB80PqRyjq0G3O250wpV87/0Iigac04qyNDzjkzABKH SkvtHmlQprHGFf8ANug8RVJt6WdLU39J5fYLjZKUjZm54v6EtAU/44/0qNkDusek FByKrFbufS/vX1M9VSdjsKSzY3nGEUQpnYWaUiUnyzwauhn83+4JUoWeN1kSAH05 5HYVqAXNtpbx2TFFPY15pGs4prV0do+YYosfTrcMJj/UaVOqDHrpRFdBleqDjUWh HqUpS7Rwe4a/1sWGqFKoy8Qy7PCaz283Lnae5YkwnsaI2d0d0ENrf9tHV0ggW1ui 1Cfvg5Omk+I5LjY2qrS2 =yWcX -----END PGP SIGNATURE----- --tKy6e3LXpfmanBFM--