SYSTEM CATALOGS / PROGRESS REPORTING
pg_stat_progress_copy
Read PG 18 manual ↗Whenever COPY is running, the pg_stat_progress_copy view will contain one row for each backend that is currently running a COPY command.
- Kind
- Progress reporting
- Columns in this snapshot
- 11
- Definition source
- English manual
Columns 11
| Column | Type | Description / reference |
|---|---|---|
pid | integer | Process ID of backend. |
datid | oid | OID of the database to which this backend is connected. |
datname | name | Name of the database to which this backend is connected. |
relid | oid | OID of the table on which the COPY command is executed. It is set to 0 if copying from a SELECT query. |
command | text | The command that is running: COPY FROM, or COPY TO. |
type | text | The I/O type that the data is read from or written to: FILE, PROGRAM, PIPE (for COPY FROM STDIN and COPY TO STDOUT), or CALLBACK (used for example during the initial table synchronization in logical replication). |
bytes_processed | bigint | Number of bytes already processed by COPY command. |
bytes_total | bigint | Size of source file for COPY FROM command in bytes. It is set to 0 if not available. |
tuples_processed | bigint | Number of tuples already processed by COPY command. |
tuples_excluded | bigint | Number of tuples not processed because they were excluded by the WHERE clause of the COPY command. |
tuples_skipped | bigint | Number of tuples skipped because they contain malformed data. This counter only advances when a value other than stop is specified to the ON_ERROR option. |
Column history across versions
| Column | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
pid | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
datid | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
datname | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
relid | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
command | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
type | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
bytes_processed | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
bytes_total | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
tuples_processed | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
tuples_excluded | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
tuples_skipped | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● |
Version history 3
- PG 18 → 19changed
- PG 16 → 17changed
- PG 13 → 14added
Definition snapshot: english-manuals:8dab96f27695095c5dda51ebe6f… · English manual source