Horton

Add progress reporting of skipped tuples during COPY FROM.

Masahiko Sawada <msawada@postgresql.org>

View on postgr.es
Commit: 729439607ad210dbb446e31754e8627d7e3f7dda
Author: Masahiko Sawada <msawada@postgresql.org>
Date: 2024-01-25T01:57:41Z
Releases: 17.0 
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

Files

PathChange+/−
doc/src/sgml/monitoring.sgml modified +12 −0
src/backend/catalog/system_views.sql modified +2 −1
src/backend/commands/copyfrom.c modified +5 −0
src/include/catalog/catversion.h modified +1 −1
src/include/commands/progress.h modified +1 −0
src/test/regress/expected/rules.out modified +2 −1

Documentation touched

Discussion