diff options
| author | Masahiko Sawada <msawada@postgresql.org> | 2024-01-25 10:57:41 +0900 |
|---|---|---|
| committer | Masahiko Sawada <msawada@postgresql.org> | 2024-01-25 10:57:41 +0900 |
| commit | 729439607ad210dbb446e31754e8627d7e3f7dda (patch) | |
| tree | 627604256869a22130478dc417949d07d8b7f32f /doc/src | |
| parent | d282e88e50521a457fa1b36e55f43bac02a3167f (diff) | |
| download | postgresql-729439607ad210dbb446e31754e8627d7e3f7dda.tar.gz postgresql-729439607ad210dbb446e31754e8627d7e3f7dda.zip | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 6e74138a69a..d9b8b37585c 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -5780,6 +5780,18 @@ FROM pg_stat_get_backend_idset() AS backendid; <command>WHERE</command> clause of the <command>COPY</command> command. </para></entry> </row> + + <row> + <entry role="catalog_table_entry"><para role="column_definition"> + <structfield>tuples_skipped</structfield> <type>bigint</type> + </para> + <para> + Number of tuples skipped because they contain malformed data. + This counter only advances when a value other than + <literal>stop</literal> is specified to the <literal>ON_ERROR</literal> + option. + </para></entry> + </row> </tbody> </tgroup> </table> |