Redshift Observatory

System Table Tracker

System view pg_catalog.stl_wam_lifecycle version 1.0.72899 / 2024-08-17

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