gs_copy_summary

The gs_copy_summary table is used to record the COPY execution result summary, including the number of successful rows, number of error rows, number of ignored rows, and number of empty rows. For details about the permissions, see "Client Tools > gs_loader > Permission" in Tool Reference.

**Table 1** gs_copy_summary columns
Name	Type	Description
relname	character varying	Name of the target table to be imported.
begintime	timestamp with time zone	Start time of an import task.
endtime	timestamp with time zone	End time of an import task.
id	bigint	ID of the transaction to be imported.
pid	bigint	ID of the worker thread for the current import.
readrows	bigint	Total number of data rows read by the import task.
skiprows	bigint	Total number of data rows skipped in the import task.
loadrows	bigint	Number of data rows successfully imported in the current import task.
errorrows	bigint	Number of error data rows in the current import task.
whenrows	bigint	Number of data rows that violate the WHEN filter criterion in the current import task.
allnullrows	bigint	Number of data rows where all columns are empty.
detail	text	Summary of the import task, including the number of successfully imported rows, number of error data rows, number of rows that violate the WHEN condition, and number of blank rows.