STV_STARTUP_RECOVERY_STATE
Records the state of tables that are temporarily locked during cluster restart operations. Amazon Redshift places a temporary lock on tables while they are being processed to resolve stale transactions following a cluster restart.
STV_STARTUP_RECOVERY_STATE is visible only to superusers. For more information, see Visibility of Data in System Tables and Views.
Table Columns
Column Name | Data Type | Description |
---|---|---|
db_id | integer | Database ID. |
table_id | integer | Table ID. |
table_name | character(137) | Table name. |
Sample Queries
To monitor which tables are temporarily locked, execute the following query after a cluster restart.
select * from STV_STARTUP_RECOVERY_STATE; db_id | tbl_id | table_name --------+--------+------------ 100044 | 100058 | lineorder 100044 | 100068 | part 100044 | 100072 | customer 100044 | 100192 | supplier (4 rows)