pgsql: Add support for more progress reporting in COPY

Started by Michael Paquierover 5 years ago1 messagescomitters

michael@paquier.xyz

over 5 years ago

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: /messages/by-id/CAEze2WiOcgdH4aQA8NtZq-4dgvnJzp8PohdeKchPkhMY-jWZXA@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/9d2d45700928d49212fb7ed140feeaebe3a6014f

Modified Files
--------------
doc/src/sgml/monitoring.sgml | 45 ++++++++++++++++++++++++++++++++----
src/backend/catalog/system_views.sql | 11 ++++++++-
src/backend/commands/copyfrom.c | 34 +++++++++++++++++++++++----
src/backend/commands/copyto.c | 28 ++++++++++++++++++----
src/include/catalog/catversion.h | 2 +-
src/include/commands/progress.h | 17 ++++++++++++--
src/test/regress/expected/rules.out | 15 +++++++++++-
7 files changed, 134 insertions(+), 18 deletions(-)