Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025.
If you would like to use Python UDFs, create the UDFs prior to that date.
Existing Python UDFs will continue to function as normal. For more information, see the
blog post
STV_LOAD_STATE
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.
Table columns
| 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. |
Sample query
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)
