pg_stat_progress_copy

A progress reporting view providing information on the progress of COPY command execution

pg_stat_progress_copy is a progress reporting view providing information on the progress of COPY command execution.

pg_stat_progress_copy was added in PostgreSQL 14.

Definition by PostgreSQL version

pg_stat_progress_copy (PostgreSQL 14)

          View "pg_catalog.pg_stat_progress_copy"
     Column      |  Type   | Collation | Nullable | Default 
-----------------+---------+-----------+----------+---------
 pid             | integer |           |          | 
 datid           | oid     |           |          | 
 datname         | name    |           |          | 
 relid           | oid     |           |          | 
 bytes_processed | bigint  |           |          | 
 bytes_total     | bigint  |           |          | 
 lines_processed | bigint  |           |          |
    

Documentation: pg_stat_progress_copy

Change history

Examples

Sample output during a COPY FROM operation:

postgres=# SELECT * FROM pg_stat_progress_copy\x\g\x
Expanded display is on.
-[ RECORD 1 ]---+-----------
pid             | 1792657
datid           | 13837
datname         | postgres
relid           | 16471
bytes_processed | 951779328
bytes_total     | 1118097736
lines_processed | 8482724

Categories

Progress reporting view

See also

COPY