Horton

Add support for more progress reporting in COPY

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: 9d2d45700928d49212fb7ed140feeaebe3a6014f
Author: Michael Paquier <michael@paquier.xyz>
Date: 2021-03-09T05:21:03Z
Releases: 14.0 
Add support for more progress reporting in COPY

The command (TO or FROM), its type (file, pipe, program or callback),
and the number of tuples excluded by a WHERE clause in COPY FROM are
added to the progress reporting already available.

The column "lines_processed" is renamed to "tuples_processed" to
disambiguate the meaning of this column in the cases of CSV and BINARY
COPY and to be more consistent with the other catalog progress views.

Bump catalog version, again.

Author: Matthias van de Meent
Reviewed-by: Michael Paquier, Justin Pryzby, Bharath Rupireddy, Josef
Šimánek, Tomas Vondra
Discussion: https://postgr.es/m/CAEze2WiOcgdH4aQA8NtZq-4dgvnJzp8PohdeKchPkhMY-jWZXA@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/monitoring.sgml modified +40 −5
src/backend/catalog/system_views.sql modified +10 −1
src/backend/commands/copyfrom.c modified +30 −4
src/backend/commands/copyto.c modified +24 −4
src/include/catalog/catversion.h modified +1 −1
src/include/commands/progress.h modified +15 −2
src/test/regress/expected/rules.out modified +14 −1

Documentation touched

Discussion