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.
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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.