Обсуждение: pgsql: Add progress reporting of skipped tuples during COPY FROM.

Поиск
Список
Период
Сортировка

pgsql: Add progress reporting of skipped tuples during COPY FROM.

От
Masahiko Sawada
Дата:
Add progress reporting of skipped tuples during COPY FROM.

9e2d870119 enabled the COPY command to skip malformed data, however
there was no visibility into how many tuples were actually skipped
during the COPY FROM.

This commit adds a new "tuples_skipped" column to
pg_stat_progress_copy view to report the number of tuples that were
skipped because they contain malformed data.

Bump catalog version.

Author: Atsushi Torikoshi
Reviewed-by: Masahiko Sawada
Discussion: https://postgr.es/m/d12fd8c99adcae2744212cb23feff6ed%40oss.nttdata.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/729439607ad210dbb446e31754e8627d7e3f7dda

Modified Files
--------------
doc/src/sgml/monitoring.sgml         | 12 ++++++++++++
src/backend/catalog/system_views.sql |  3 ++-
src/backend/commands/copyfrom.c      |  5 +++++
src/include/catalog/catversion.h     |  2 +-
src/include/commands/progress.h      |  1 +
src/test/regress/expected/rules.out  |  3 ++-
6 files changed, 23 insertions(+), 3 deletions(-)