The pgx_stat_progress_loader view provides overall progress information for pgx_loader command.
The pgx_stat_progress_loader view displays the sum of the progress information of the back-end processes and the number of parallel worker processes when pgx_loader runs.
Table D.7 pgx_stat_progress_loader viewColumn | Type | Description |
|---|
pid | integer | Process ID of the backend. |
datid | Oid | Oid of the database to connect to. |
datname | name | Name of the database to connect to. |
relid | Oid | Oid of the table to load. |
command | text | Command executes the load process. (Always "COPY FROM"for pgx_loader) |
type | text | Type of data source for the load operation. |
bytes_processed | bigint | Size of the data at the end of the load. (Backend and worker totals) |
bytes_total | bigint | Size of the data to load. (Backend and worker totals) |
tuples_processed | bigint | Number of rows that have completed loading. (Backend and worker totals) |
tuples_excluded | bigint | Number of rows skipped during the load process. (Backend and worker totals) |
