Redshift Observatory

System Table Tracker

System view pg_catalog.svl_auto_worker_action version 1.0.39009 / 2022-06-08

schema name column data type
pg_catalog svl_auto_worker_action eventtime timestamp
pg_catalog svl_auto_worker_action previous_state char(200)
pg_catalog svl_auto_worker_action sequence int4
pg_catalog svl_auto_worker_action status char(128)
pg_catalog svl_auto_worker_action table_id int4
pg_catalog svl_auto_worker_action type text

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 Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers