46.8. Copying Processes #
You can view information about copying processes (COPY). The information is based on the pg_stat_progress_copy view.
46.8.1. Viewing Copying Processes #
Go to copying processes in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Activity.
Select Copy, and then in the top-right corner of the page, select the instance and database.
Using the configuration section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Activity.
Select Copy, and then in the top-right corner of the page, select the database.
The table of copying processes with the following columns will be displayed:
PID: The ID of the backend.
State: The state of the backend.
For more information about possible values, refer to the official Postgres Pro documentation on the
pg_stat_activitymodule (refer to thestatecolumn).Wait event: The name and type of the wait event for the backend.
For more information, refer to the official Postgres Pro documentation on the
pg_stat_activitymodule (refer towait_event_typeandwait_eventcolumns).Database: The name of the database where copying is being performed.
User: The name of the DBMS user on behalf of which copying is being performed.
Table: The name or ID of the table being copied.
Query: The text of the current or last backend query.
Query duration: The duration of the current or last backend query.
Table size: The size of the table being copied.
Table tuples total: Rows of the table being copied.
This column includes additional information:
Tuples processed: The number of processed table rows.
Tuples excluded: The number of excluded table rows.
Source file size: The size of the file being copied.
Done, %: The completion percentage of copying.
This column includes additional information:
Processed: The size of the processed data.
Command: The text of the copying command.
Command type: The type of the copying command.
Actions.
For more information about available actions, refer to the corresponding instructions.
46.8.2. Canceling a Copying Process #
Canceling a copying process does not terminate a user session.
To cancel a copying process:
Go to copying processes in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Activity.
Select Copy, and then in the top-right corner of the page, select the instance and database.
Using the configuration section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Activity.
Select Copy, and then in the top-right corner of the page, select the database.
Click
next to the copying process. Click Execute.
46.8.3. Terminating the User Session for a Copying Process #
When the user session is terminated, the copying process is canceled automatically.
To terminate the user session for a copying process:
Go to copying processes in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Activity.
Select Copy, and then in the top-right corner of the page, select the instance and database.
Using the configuration section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Activity.
Select Copy, and then in the top-right corner of the page, select the database.
Click
next to the copying process. Click Execute.