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 only to superusers. For more information, see Visibility of data in system tables and views.

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, Abort, Checkpoint, 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.

Some examples of values of the status column are as follows:

  • Skipped:Table not found.

  • Skipped:Recommendation is empty.

  • Skipped:Apply sortkey recommendation is disabled.

  • Skipped:Retry exceeds the maximum limit for a table.

  • Skipped:Table column has changed.

  • Abort:This table is not AUTO.

  • Abort:This table has been recently converted.

  • Abort:This table exceeds table size threshold.

  • Abort:This table is already the recommended style.

  • Checkpoint: progress 21.9963%.

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 | Skipped:Retry exceeds the maximum limit for a table. | 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 | Checkpoint: progress 14.755079% | 2020-08-22 19:42:52.692828 | 0 | 118072 | sortkey | Failed | 2020-08-22 19:44:14.796071 | 0 | 116723 | sortkey | Abort:This table is not AUTO. | 2020-10-28 05:12:58.479233 | 0 | 110203 | distkey | Abort:This table is not AUTO. | 2020-10-28 05:45:54.67259 | 0 |