SVL_AUTO_WORKER_ACTION - Amazon Redshift

SVL_AUTO_WORKER_ACTION

Records automated actions taken by Amazon Redshift on tables defined for automatic optimization.

SVL_AUTO_WORKER_ACTION is visible to all users.

Table columns

Column name Data type Description
table_id integer The table identifier.
type character(32) The type of recommendation. Possible values are distkey and sortkey.
status character(128) The completion status of the recommendation. Possible values are Start, Complete, Skipped, and Failed.
eventtime timestamp The timestamp of the status column.
sequence integer The sequence number of a truncated previous_state value. When a single previous_state contains more than 200 characters, additional rows are logged for that value. Sequence is 0 is the first row, 1 is the second, and so on.
previous_state character(200) The previous distribution style and sort keys of the table before applying the recommendation. The value is truncated into 200-character increments.

Sample queries

In the following example, the rows in the result show actions taken by Amazon Redshift.

select table_id, type, status, eventtime, sequence, previous_state from SVL_AUTO_WORKER_ACTION;
table_id | type | status | eventtime | sequence | previous_state ----------+---------+----------+----------------------------+----------+--------------- 118082 | sortkey | Start | 2020-08-22 19:42:20.727049 | 0 | 118078 | sortkey | Start | 2020-08-22 19:43:54.728819 | 0 | 118082 | sortkey | Start | 2020-08-22 19:42:52.690264 | 0 | 118072 | sortkey | Start | 2020-08-22 19:44:14.793572 | 0 | 118082 | sortkey | Failed | 2020-08-22 19:42:20.728917 | 0 | 118078 | sortkey | Complete | 2020-08-22 19:43:54.792705 | 0 | SORTKEY: None; 118086 | sortkey | Complete | 2020-08-22 19:42:00.72635 | 0 | SORTKEY: None; 118082 | sortkey | Complete | 2020-08-22 19:43:34.728144 | 0 | SORTKEY: None; 118072 | sortkey | Failed | 2020-08-22 19:44:46.706155 | 0 | 118086 | sortkey | Start | 2020-08-22 19:42:00.685255 | 0 | 118082 | sortkey | Start | 2020-08-22 19:43:34.69531 | 0 | 118072 | sortkey | Start | 2020-08-22 19:44:46.703331 | 0 | 118082 | sortkey | Failed | 2020-08-22 19:42:52.692828 | 0 | 118072 | sortkey | Failed | 2020-08-22 19:44:14.796071 | 0 |