Amazon Redshift
Database Developer Guide (API Version 2012-12-01)


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)