Add progress reporting of skipped tuples during COPY FROM.
authorMasahiko Sawada <msawada@postgresql.org>
Thu, 25 Jan 2024 01:57:41 +0000 (10:57 +0900)
committerMasahiko Sawada <msawada@postgresql.org>
Thu, 25 Jan 2024 01:57:41 +0000 (10:57 +0900)
commit729439607ad210dbb446e31754e8627d7e3f7dda
tree627604256869a22130478dc417949d07d8b7f32f
parentd282e88e50521a457fa1b36e55f43bac02a3167f
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
doc/src/sgml/monitoring.sgml
src/backend/catalog/system_views.sql
src/backend/commands/copyfrom.c
src/include/catalog/catversion.h
src/include/commands/progress.h
src/test/regress/expected/rules.out