Redshift Observatory

System Table Tracker

System view pg_catalog.svl_auto_worker_action version 1.0.80560 / 2024-12-22

View Text

SELECT stl_auto_alter_worker_event.tbl AS table_id,
       CASE
         WHEN stl_auto_alter_worker_event.recommend = 23
           THEN CAST('distkey' AS text)
         WHEN stl_auto_alter_worker_event.recommend = 24
           THEN CAST('sortkey' AS text)
         WHEN stl_auto_alter_worker_event.recommend = 26
           THEN CAST('encode' AS text)
         ELSE CAST(NULL AS text)
       END AS type,
       CASE
         WHEN stl_auto_alter_worker_event.status ~~ CAST('%Under%' AS text)
           THEN CAST('Failed' AS bpchar)
         WHEN stl_auto_alter_worker_event.status ~~ CAST('%Exception%' AS text)
           THEN CAST('Failed' AS bpchar)
         ELSE stl_auto_alter_worker_event.status
       END AS status,
       stl_auto_alter_worker_event.eventtime,
       stl_auto_alter_worker_event.sequence,
       stl_auto_alter_worker_event.previous_state
FROM stl_auto_alter_worker_event

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace System Table Tracker The Known Universe White Papers