Updated on 2022-07-15 GMT+08:00

PG_BULKLOAD_STATISTICS

On any normal node in a cluster, PG_BULKLOAD_STATISTICS displays the execution status of the import and export services. Each import or export service corresponds to a record. This view is accessible only to users with system administrators rights.

Table 1 PG_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

Execution phase of the current service import and export. 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