System Catalogs / Progress reporting
pg_stat_progress_copy
Read the PG 18 manualWhenever COPY is running, the pg_stat_progress_copy view will contain one row for each backend that is currently running a COPY command.
Reading PG 18current·documented in 7 of 24 versions, 14 to 20
- Kind
- Progress reporting
- Columns in this snapshot
- 11
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 11
As listed in the PostgreSQL 18 manual.
| 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
Definition snapshot: english-manuals:431e9c2c59263876eed6e83a661… · English manual source