Redshift Observatory System Table Tracker

Tables

pg_internal.redshift_auto_health_check_7282218

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
a	int4

pg_catalog.stcs_sage_mode_policy_candidates

old
column	data type	PK	U	NN
policy_id	int4			NN
creation_time	int8			NN
current_main	int4			NN
current_alpha	float8			NN
target_main	int4			NN
target_alpha	float8			NN
simulated_cost_rpu_sec	float8			NN
simulated_avg_response_time_sec	float8			NN
simulated_total_response_time_sec	float8			NN
simulated_num_queries	int8			NN
penalty	float8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_sage_mode_policy_candidates

old
column	data type	PK	U	NN
policy_id	int4			NN
creation_time	timestamp			NN
current_main	int4			NN
current_alpha	float8			NN
target_main	int4			NN
target_alpha	float8			NN
simulated_cost_rpu_sec	float8			NN
simulated_avg_response_time_sec	float8			NN
simulated_total_response_time_sec	float8			NN
simulated_num_queries	int8			NN
penalty	float8			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_7189312

old
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
a	int4

new
column	data type	PK	U	NN

Views

pg_catalog.stl_sage_mode_policy_candidates

old
column	data type
policy_id	int4
creation_time	timestamp
current_main	int4
current_alpha	float8
target_main	int4
target_alpha	float8
simulated_cost_rpu_sec	float8
simulated_avg_response_time_sec	float8
simulated_total_response_time_sec	float8
simulated_num_queries	int8
penalty	float8

new
column	data type