Updated on 2022-08-16 GMT+08:00

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