Redshift Observatory

System Table Tracker

System view pg_catalog.stl_sage_scaling_candidates version 1.0.73348 / 2024-08-22

schema	name	column	data type
pg_catalog	stl_sage_scaling_candidates	candidate_id	int4
pg_catalog	stl_sage_scaling_candidates	cost	float8
pg_catalog	stl_sage_scaling_candidates	decision_id	int4
pg_catalog	stl_sage_scaling_candidates	eligible	int4
pg_catalog	stl_sage_scaling_candidates	est_exec_time_ms	int4
pg_catalog	stl_sage_scaling_candidates	est_prepare_delay_ms	int4
pg_catalog	stl_sage_scaling_candidates	est_queue_time_ms	int4
pg_catalog	stl_sage_scaling_candidates	nodes	int4
pg_catalog	stl_sage_scaling_candidates	other_active_cluster_cost	float8
pg_catalog	stl_sage_scaling_candidates	other_active_query_runtime_ms	int4
pg_catalog	stl_sage_scaling_candidates	penalty	float8
pg_catalog	stl_sage_scaling_candidates	query	int4
pg_catalog	stl_sage_scaling_candidates	queued_queries	int4
pg_catalog	stl_sage_scaling_candidates	running_queries	int4
pg_catalog	stl_sage_scaling_candidates	spill_penalty_ms	int4
pg_catalog	stl_sage_scaling_candidates	ssid	int4
pg_catalog	stl_sage_scaling_candidates	state	int4

View Text

SELECT stll_sage_scaling_candidates.query,
       stll_sage_scaling_candidates.decision_id,
       stll_sage_scaling_candidates.candidate_id,
       stll_sage_scaling_candidates.ssid,
       stll_sage_scaling_candidates.state,
       stll_sage_scaling_candidates.nodes,
       stll_sage_scaling_candidates.running_queries,
       stll_sage_scaling_candidates.queued_queries,
       stll_sage_scaling_candidates.est_exec_time_ms,
       stll_sage_scaling_candidates.spill_penalty_ms,
       stll_sage_scaling_candidates.est_prepare_delay_ms,
       stll_sage_scaling_candidates.est_queue_time_ms,
       stll_sage_scaling_candidates.penalty,
       stll_sage_scaling_candidates.eligible,
       stll_sage_scaling_candidates.other_active_query_runtime_ms,
       stll_sage_scaling_candidates.cost,
       stll_sage_scaling_candidates.other_active_cluster_cost
FROM stll_sage_scaling_candidates

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