Horton

Report progress of COPY commands

Tomas Vondra <tomas.vondra@postgresql.org>

View on postgr.es
Commit: 8a4f618e7ae3cb11b0b37d0f06f05c8ff905833f
Author: Tomas Vondra <tomas.vondra@postgresql.org>
Date: 2021-01-06T20:51:06Z
Releases: 14.0 
Report progress of COPY commands

This commit introduces a view pg_stat_progress_copy, reporting progress
of COPY commands.  This allows rough estimates how far a running COPY
progressed, with the caveat that the total number of bytes may not be
available in some cases (e.g. when the input comes from the client).

Author: Josef Šimánek
Reviewed-by: Fujii Masao, Bharath Rupireddy, Vignesh C, Matthias van de Meent
Discussion: https://postgr.es/m/CAFp7QwqMGEi4OyyaLEK9DR0+E+oK3UtA4bEjDVCa4bNkwUY2PQ@mail.gmail.com
Discussion: https://postgr.es/m/CAFp7Qwr6_FmRM6pCO0x_a0mymOfX_Gg+FEKet4XaTGSW=LitKQ@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/monitoring.sgml modified +107 −0
src/backend/catalog/system_views.sql modified +11 −0
src/backend/commands/copyfrom.c modified +15 −2
src/backend/commands/copyfromparse.c modified +4 −0
src/backend/commands/copyto.c modified +20 −2
src/backend/utils/adt/pgstatfuncs.c modified +2 −0
src/include/commands/copyfrom_internal.h modified +1 −0
src/include/commands/progress.h modified +5 −0
src/include/pgstat.h modified +2 −1
src/test/regress/expected/rules.out modified +9 −0

Documentation touched

Discussion