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