Redshift Observatory System Table Tracker

Tables

pg_internal.redshift_auto_health_check_6975875

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_udf_usage_in_query

old
column	data type	PK	U	NN
query	int4			NN
nodeid	int4			NN
plan_node_type	int4			NN
func_id	int4			NN
func_name	char(200)			NN
func_type	int4			NN
in_targetlist	int4			NN
recordtime	int8			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
query	int4			NN
nodeid	int4			NN
plan_node_type	int4			NN
func_id	int4			NN
func_name	char(200)			NN
func_type	int4			NN
in_targetlist	int4			NN
recordtime	int8			NN
in_case_expr	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stll_udf_usage_in_query

old
column	data type	PK	U	NN
query	int4			NN
nodeid	int4			NN
plan_node_type	int4			NN
func_id	int4			NN
func_name	char(200)			NN
func_type	int4			NN
in_targetlist	int4			NN
recordtime	timestamp			NN

new
column	data type	PK	U	NN
query	int4			NN
nodeid	int4			NN
plan_node_type	int4			NN
func_id	int4			NN
func_name	char(200)			NN
func_type	int4			NN
in_targetlist	int4			NN
recordtime	timestamp			NN
in_case_expr	int4			NN

pg_internal.redshift_auto_health_check_6918109

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_udf_usage_in_query

old
column	data type
query	int4
nodeid	int4
plan_node_type	int4
func_id	int4
func_name	char(200)
func_type	int4
in_targetlist	int4
recordtime	timestamp

new
column	data type
query	int4
nodeid	int4
plan_node_type	int4
func_id	int4
func_name	char(200)
func_type	int4
in_targetlist	int4
recordtime	timestamp
in_case_expr	int4