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
- PostgreSQL 14
- added (commit 8a4f618e)
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
References
- PostgreSQL documentation: pg_stat_progress_copy