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