Redshift Observatory

System Table Tracker

System view pg_catalog.stl_wam_lifecycle version 1.0.77272 / 2024-11-01

schema name column data type
pg_catalog stl_wam_lifecycle burst_wam_state char(50)
pg_catalog stl_wam_lifecycle caller_description char(100)
pg_catalog stl_wam_lifecycle node int4
pg_catalog stl_wam_lifecycle number_of_records int4
pg_catalog stl_wam_lifecycle precommit_id int4
pg_catalog stl_wam_lifecycle query_id int8
pg_catalog stl_wam_lifecycle record_time timestamp
pg_catalog stl_wam_lifecycle record_type_id char(50)
pg_catalog stl_wam_lifecycle restart_incarnation char(50)
pg_catalog stl_wam_lifecycle s3_block_midfix char(50)
pg_catalog stl_wam_lifecycle s3_region char(50)
pg_catalog stl_wam_lifecycle wam_action char(50)
pg_catalog stl_wam_lifecycle wam_file_name char(300)
pg_catalog stl_wam_lifecycle wam_type_id char(50)

View Text

SELECT stll_wam_lifecycle.record_time,
       stll_wam_lifecycle.wam_file_name,
       stll_wam_lifecycle.wam_action,
       stll_wam_lifecycle.wam_type_id,
       stll_wam_lifecycle.record_type_id,
       stll_wam_lifecycle.node,
       stll_wam_lifecycle.caller_description,
       stll_wam_lifecycle.number_of_records,
       stll_wam_lifecycle.precommit_id,
       stll_wam_lifecycle.restart_incarnation,
       stll_wam_lifecycle.query_id,
       stll_wam_lifecycle.burst_wam_state,
       stll_wam_lifecycle.s3_region,
       stll_wam_lifecycle.s3_block_midfix
FROM stll_wam_lifecycle


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