Redshift Observatory

System Table Tracker

System view pg_catalog.stl_sage_mode_policy version 1.0.72503 / 2024-08-11

schema	name	column	data type
pg_catalog	stl_sage_mode_policy	creation_time	timestamp
pg_catalog	stl_sage_mode_policy	current_size_config	char(200)
pg_catalog	stl_sage_mode_policy	expiration_time	timestamp
pg_catalog	stl_sage_mode_policy	optimization_start_time	timestamp
pg_catalog	stl_sage_mode_policy	performance_level	int4
pg_catalog	stl_sage_mode_policy	policy_id	int4
pg_catalog	stl_sage_mode_policy	resize_config	char(200)
pg_catalog	stl_sage_mode_policy	selected	int4
pg_catalog	stl_sage_mode_policy	simulated_avg_response_time_sec	float8
pg_catalog	stl_sage_mode_policy	simulated_cost_rpu_sec	float8
pg_catalog	stl_sage_mode_policy	used_forecast	int4

View Text

SELECT stll_sage_mode_policy.policy_id,
       stll_sage_mode_policy.optimization_start_time,
       stll_sage_mode_policy.creation_time,
       stll_sage_mode_policy.expiration_time,
       stll_sage_mode_policy.performance_level,
       stll_sage_mode_policy.resize_config,
       stll_sage_mode_policy.current_size_config,
       stll_sage_mode_policy.simulated_cost_rpu_sec,
       stll_sage_mode_policy.simulated_avg_response_time_sec,
       stll_sage_mode_policy.selected,
       stll_sage_mode_policy.used_forecast
FROM stll_sage_mode_policy

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