PGXC_BULKLOAD_STATISTICS

PGXC_BULKLOAD_STATISTICS displays real-time statistics about service execution, such as GDS, COPY, and \COPY, on a CN. This view summarizes the real-time execution status of import and export services that are being executed on each node in the current cluster. In this way, you can monitor the real-time progress of import and export services and locate performance problems.

Columns in PGXC_BULKLOAD_STATISTICS are the same as those in PG_BULKLOAD_STATISTICS. This is because PGXC_BULKLOAD_STATISTICS is essentially the summary result of querying PG_BULKLOAD_STATISTICS on each node in the cluster.

This view is accessible only to users with system administrators rights.

**Table 1** PGXC_BULKLOAD_STATISTICS columns
Name	Type	Description
node_name	Text	Node name
db_name	Text	Database name
query_id	Bigint	Query ID. It is equivalent to debug_query_id.
tid	Bigint	ID of the current thread
lwtid	Integer	Lightweight thread ID
session_id	Bigint	GDS session ID
direction	Text	Service type. The options are gds to file, gds from file, gds to pipe, gds from pipe, copy from, and copy to.
query	Text	Query statement
address	Text	Location of the foreign table used for data import and export
query_start	Timestamp with time zone	Start time of data import or export
total_bytes	Bigint	Total size of data to be processed This parameter is specified only when a GDS common file is to be imported and the record in the row comes from a CN. Otherwise, left this parameter unspecified.
phase	Text	Current phase. The options are INITIALIZING, TRANSFER_DATA, and RELEASE_RESOURCE.
done_lines	Bigint	Number of lines that have been transferred
done_bytes	Bigint	Number of bytes that have been transferred