Redshift Observatory

System Table Tracker

System view pg_catalog.stl_sage_mode_policy version 1.0.76913 / 2024-10-24

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	replay_end	timestamp
pg_catalog	stl_sage_mode_policy	replay_start	timestamp
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	simulated_total_response_time_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,
       stll_sage_mode_policy.replay_start,
       stll_sage_mode_policy.replay_end,
       stll_sage_mode_policy.simulated_total_response_time_sec
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