Use the STV_LOAD_STATE table to find information about current state of ongoing COPY statements.
The COPY command updates this table after every million records are loaded.
STV_LOAD_STATE is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of Data in System Tables and Views.
|Column Name||Data Type||Description|
|userid||integer||ID of user who generated entry.|
|session||integer||Session PID of process doing the load.|
|query||integer||Query ID. Can be used to join various other system tables and views.|
|slice||integer||Node slice number.|
|pid||integer||Process ID. All of the queries in a session are run in the same process, so this value remains constant if you run a series of queries in the same session.|
|recordtime||timestamp||Time the record is logged.|
|bytes_to_load||bigint||Total number of bytes to be loaded by this slice. This is 0 if the data being loaded is compressed|
|bytes_loaded||bigint||Number of bytes loaded by this slice. If the data being loaded is compressed, this is the number of bytes loaded after the data is uncompressed.|
|bytes_to_load_compressed||bigint||Total number of bytes of compressed data to be loaded by this slice. This is 0 if the data being loaded is not compressed.|
|bytes_loaded_compressed||bigint||Number of bytes of compressed data loaded by this slice. This is 0 if the data being loaded is not compressed.|
|lines||integer||Number of lines loaded by this slice.|
|num_files||integer||Number of files to be loaded by this slice.|
|num_files_complete||integer||Number of files loaded by this slice.|
|current_file||character(256)||Name of the file being loaded by this slice.|
|pct_complete||integer||Percentage of data load completed by this slice.|
To view the progress of each slice for a COPY command, type the following query. This example uses the PG_LAST_COPY_ID() function to retrieve information for the last COPY command.
select slice , bytes_loaded, bytes_to_load , pct_complete from stv_load_state where query = pg_last_copy_id(); slice | bytes_loaded | bytes_to_load | pct_complete -------+--------------+---------------+-------------- 2 | 0 | 0 | 0 3 | 12840898 | 39104640 | 32 (2 rows)