Redshift Observatory

System Table Tracker

System view pg_catalog.stl_sage_mode_policy_candidates version 1.0.107360 / 2025-02-15

schema	name	column	data type
pg_catalog	stl_sage_mode_policy_candidates	creation_time	timestamp
pg_catalog	stl_sage_mode_policy_candidates	current_alpha	float8
pg_catalog	stl_sage_mode_policy_candidates	current_main	int4
pg_catalog	stl_sage_mode_policy_candidates	penalty	float8
pg_catalog	stl_sage_mode_policy_candidates	policy_id	int4
pg_catalog	stl_sage_mode_policy_candidates	simulated_avg_response_time_sec	float8
pg_catalog	stl_sage_mode_policy_candidates	simulated_cost_rpu_sec	float8
pg_catalog	stl_sage_mode_policy_candidates	simulated_num_queries	int8
pg_catalog	stl_sage_mode_policy_candidates	simulated_total_response_time_sec	float8
pg_catalog	stl_sage_mode_policy_candidates	target_alpha	float8
pg_catalog	stl_sage_mode_policy_candidates	target_main	int4

View Text

SELECT stll_sage_mode_policy_candidates.policy_id,
       stll_sage_mode_policy_candidates.creation_time,
       stll_sage_mode_policy_candidates.current_main,
       stll_sage_mode_policy_candidates.current_alpha,
       stll_sage_mode_policy_candidates.target_main,
       stll_sage_mode_policy_candidates.target_alpha,
       stll_sage_mode_policy_candidates.simulated_cost_rpu_sec,
       stll_sage_mode_policy_candidates.simulated_avg_response_time_sec,
       stll_sage_mode_policy_candidates.simulated_total_response_time_sec,
       stll_sage_mode_policy_candidates.simulated_num_queries,
       stll_sage_mode_policy_candidates.penalty
FROM stll_sage_mode_policy_candidates

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers