Redshift Research Project System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
new	pg_catalog	internal	immutable	name	mask_get_policy_for_role_on_column	varchar,varchar,varchar,varchar
new	pg_catalog	internal	immutable	name	mask_get_policy_for_user_on_column	varchar,varchar,varchar,varchar
new	pg_catalog	internal	stable	intervald2s	intervald2s	bpchar
new	pg_catalog	internal	stable	intervald2s	intervald2s	text
new	pg_catalog	internal	stable	intervaly2m	intervaly2m	bpchar
new	pg_catalog	internal	stable	intervaly2m	intervaly2m	text
dropped	pg_catalog	internal	immutable	bool	proc_is_rls_s3_safe	oid
dropped	pg_catalog	internal	immutable	bool	try_boolin	cstring
dropped	pg_catalog	internal	immutable	bool	try_partiql_bool	super
dropped	pg_catalog	internal	immutable	bpchar	try_bpcharin	cstring,oid,int4
dropped	pg_catalog	internal	immutable	bpchar	try_partiql_char	super
dropped	pg_catalog	internal	immutable	date	try_date	timestamp
dropped	pg_catalog	internal	immutable	date	try_partiql_date	super
dropped	pg_catalog	internal	immutable	float4	try_float4	bpchar
dropped	pg_catalog	internal	immutable	float4	try_float4	float8
dropped	pg_catalog	internal	immutable	float4	try_float4	text
dropped	pg_catalog	internal	immutable	float4	try_float4in	cstring
dropped	pg_catalog	internal	immutable	float4	try_partiql_float4	super
dropped	pg_catalog	internal	immutable	float8	try_float8	bpchar
dropped	pg_catalog	internal	immutable	float8	try_float8	text
dropped	pg_catalog	internal	immutable	float8	try_float8in	cstring
dropped	pg_catalog	internal	immutable	float8	try_partiql_float8	super
dropped	pg_catalog	internal	immutable	int2	try_int2	bpchar
dropped	pg_catalog	internal	immutable	int2	try_int2	float4
dropped	pg_catalog	internal	immutable	int2	try_int2	float8
dropped	pg_catalog	internal	immutable	int2	try_int2	int4
dropped	pg_catalog	internal	immutable	int2	try_int2	int8
dropped	pg_catalog	internal	immutable	int2	try_int2	numeric
dropped	pg_catalog	internal	immutable	int2	try_int2	text
dropped	pg_catalog	internal	immutable	int2	try_int2in	cstring
dropped	pg_catalog	internal	immutable	int2	try_partiql_int2	super
dropped	pg_catalog	internal	immutable	int4	try_int4	bpchar
dropped	pg_catalog	internal	immutable	int4	try_int4	float4
dropped	pg_catalog	internal	immutable	int4	try_int4	float8
dropped	pg_catalog	internal	immutable	int4	try_int4	int8
dropped	pg_catalog	internal	immutable	int4	try_int4	numeric
dropped	pg_catalog	internal	immutable	int4	try_int4	text
dropped	pg_catalog	internal	immutable	int4	try_int4in	cstring
dropped	pg_catalog	internal	immutable	int4	try_partiql_int4	super
dropped	pg_catalog	internal	immutable	int8	try_int8	bpchar
dropped	pg_catalog	internal	immutable	int8	try_int8	float4
dropped	pg_catalog	internal	immutable	int8	try_int8	float8
dropped	pg_catalog	internal	immutable	int8	try_int8	numeric
dropped	pg_catalog	internal	immutable	int8	try_int8	text
dropped	pg_catalog	internal	immutable	int8	try_int8in	cstring
dropped	pg_catalog	internal	immutable	int8	try_partiql_int8	super
dropped	pg_catalog	internal	immutable	intervald2s	intervald2s	time
dropped	pg_catalog	internal	immutable	super	h3_polyfill	geometry,int4
dropped	pg_catalog	internal	immutable	super	try_char_partiql	bpchar
dropped	pg_catalog	internal	immutable	super	try_float4_partiql	float4
dropped	pg_catalog	internal	immutable	super	try_float8_partiql	float8
dropped	pg_catalog	internal	immutable	super	try_partiql_in	cstring
dropped	pg_catalog	internal	immutable	super	try_text_partiql	text
dropped	pg_catalog	internal	immutable	super	try_varchar_partiql	varchar
dropped	pg_catalog	internal	immutable	text	try_partiql_text	super
dropped	pg_catalog	internal	immutable	text	try_textin	cstring
dropped	pg_catalog	internal	immutable	time	try_partiql_time	super
dropped	pg_catalog	internal	immutable	time	try_time	timestamp
dropped	pg_catalog	internal	immutable	timestamp	try_partiql_timestamp	super
dropped	pg_catalog	internal	immutable	timestamptz	try_partiql_timestamptz	super
dropped	pg_catalog	internal	immutable	timetz	try_partiql_timetz	super
dropped	pg_catalog	internal	immutable	varchar	mask_get_policy_for_role_on_column	varchar,varchar,varchar,varchar
dropped	pg_catalog	internal	immutable	varchar	mask_get_policy_for_user_on_column	varchar,varchar,varchar,varchar
dropped	pg_catalog	internal	immutable	varchar	try_partiql_varchar	super
dropped	pg_catalog	internal	immutable	varchar	try_varcharin	cstring,oid,int4
dropped	pg_catalog	internal	stable	bpchar	try_bpchar	timestamp
dropped	pg_catalog	internal	stable	bpchar	try_bpchar	timestamptz
dropped	pg_catalog	internal	stable	cstring	try_timestamp_out	timestamp
dropped	pg_catalog	internal	stable	cstring	try_timestamptz_out	timestamptz
dropped	pg_catalog	internal	stable	date	try_date	bpchar
dropped	pg_catalog	internal	stable	date	try_date	text
dropped	pg_catalog	internal	stable	date	try_date	timestamptz
dropped	pg_catalog	internal	stable	date	try_date_in	cstring
dropped	pg_catalog	internal	stable	int2	pg_get_cluster_isolation_level	None
dropped	pg_catalog	internal	stable	intervald2s	intervald2s	bpchar,int4
dropped	pg_catalog	internal	stable	intervald2s	intervald2s	text,int4
dropped	pg_catalog	internal	stable	intervaly2m	intervaly2m	bpchar,int4
dropped	pg_catalog	internal	stable	intervaly2m	intervaly2m	text,int4
dropped	pg_catalog	internal	stable	text	try_text	timestamp
dropped	pg_catalog	internal	stable	text	try_text	timestamptz
dropped	pg_catalog	internal	stable	time	try_time	bpchar
dropped	pg_catalog	internal	stable	time	try_time	text
dropped	pg_catalog	internal	stable	time	try_time	timestamptz
dropped	pg_catalog	internal	stable	time	try_time_in	cstring,oid,int4
dropped	pg_catalog	internal	stable	timestamp	try_timestamp	bpchar
dropped	pg_catalog	internal	stable	timestamp	try_timestamp	text
dropped	pg_catalog	internal	stable	timestamp	try_timestamp	timestamptz
dropped	pg_catalog	internal	stable	timestamp	try_timestamp_in	cstring,oid,int4
dropped	pg_catalog	internal	stable	timestamptz	try_timestamptz	bpchar
dropped	pg_catalog	internal	stable	timestamptz	try_timestamptz	text
dropped	pg_catalog	internal	stable	timestamptz	try_timestamptz	timestamp
dropped	pg_catalog	internal	stable	timestamptz	try_timestamptz_in	cstring,oid,int4
dropped	pg_catalog	internal	stable	timetz	try_timetz	bpchar
dropped	pg_catalog	internal	stable	timetz	try_timetz	text
dropped	pg_catalog	internal	stable	timetz	try_timetz	timestamptz
dropped	pg_catalog	internal	stable	timetz	try_timetz_in	cstring,oid,int4

Tables

pg_catalog.stcs_guid_cache_metrics

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
record_time	int8			NN
entries_tracked	int8			NN
staleness_percent	int8			NN
unknown_percent	int8			NN
lookups	int8			NN
staleness_count	int8			NN
unknown_count	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

pg_catalog.stll_guid_cache_metrics

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
record_time	timestamp			NN
entries_tracked	int8			NN
staleness_percent	int8			NN
unknown_percent	int8			NN
lookups	int8			NN
staleness_count	int8			NN
unknown_count	int8			NN

pg_internal.redshift_auto_health_check_43143369

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_burst_connection

old
column	data type	PK	U	NN
action	char(20)			NN
method	char(50)			NN
pid	int8			NN
xid	int8			NN
line_number	int8			NN
eventtime	int8			NN
cluster_arn	char(128)			NN
connection_guid	char(100)			NN
error	char(250)			NN
switch_status	char(20)			NN
switch_time	int4			NN
starttime	int8			NN
query	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

new
column	data type	PK	U	NN
action	char(20)			NN
method	char(50)			NN
pid	int8			NN
xid	int8			NN
line_number	int8			NN
eventtime	int8			NN
cluster_arn	char(100)			NN
connection_guid	char(100)			NN
error	char(250)			NN
switch_status	char(20)			NN
switch_time	int4			NN
starttime	int8			NN
query	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.stcs_burst_manager_personalization

old
column	data type	PK	U	NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
starttime	int8			NN
endtime	int8			NN
cluster_arn	char(128)			NN
backup_id	char(100)			NN
backup_prefix	char(100)			NN
backup_midfix	char(100)			NN
creds_access_key	char(100)			NN
creds_secret_key	char(100)			NN
creds_session_token	char(100)			NN
creds_expiration	int8			NN
cluster_id	char(38)			NN
cluster_name	char(70)			NN
error	char(250)			NN
account_id	char(38)			NN
query	int4			NN
auto_wlm_total_memory_mb	int4			NN
auto_wlm_per_query_max_memory_mb	int4			NN
instance_type	char(100)			NN
num_nodes	int4			NN
burst_cluster_id	char(38)			NN
burst_account_id	char(38)			NN
burst_cluster_version	char(50)			NN
main_instance_type	char(100)			NN
main_num_nodes	int4			NN
main_num_slices	int4			NN
refreshed_backup_id	char(100)			NN
refreshed_version	int4			NN
refreshing_backup_id	char(100)			NN
refreshing_version	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

new
column	data type	PK	U	NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
starttime	int8			NN
endtime	int8			NN
cluster_arn	char(120)			NN
backup_id	char(100)			NN
backup_prefix	char(100)			NN
backup_midfix	char(100)			NN
creds_access_key	char(100)			NN
creds_secret_key	char(100)			NN
creds_session_token	char(100)			NN
creds_expiration	int8			NN
cluster_id	char(38)			NN
cluster_name	char(70)			NN
error	char(250)			NN
account_id	char(38)			NN
query	int4			NN
auto_wlm_total_memory_mb	int4			NN
auto_wlm_per_query_max_memory_mb	int4			NN
instance_type	char(100)			NN
num_nodes	int4			NN
burst_cluster_id	char(38)			NN
burst_account_id	char(38)			NN
burst_cluster_version	char(50)			NN
main_instance_type	char(100)			NN
main_num_nodes	int4			NN
main_num_slices	int4			NN
refreshed_backup_id	char(100)			NN
refreshed_version	int4			NN
refreshing_backup_id	char(100)			NN
refreshing_version	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.stcs_burst_manager_refresh

old
column	data type	PK	U	NN
eventtime	int8			NN
action	char(50)			NN
type	char(20)			NN
refresh_method	char(20)			NN
pid	int8			NN
refresh_version	int8			NN
cluster_arn	char(128)			NN
error	char(350)			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
eventtime	int8			NN
action	char(50)			NN
type	char(20)			NN
refresh_method	char(20)			NN
pid	int8			NN
refresh_version	int8			NN
cluster_arn	char(100)			NN
error	char(350)			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.stcs_burst_query_execution

old
column	data type	PK	U	NN
action	char(20)			NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
query	int8			NN
backup_id	char(30)			NN
cluster_backup_version	int8			NN
starttime	int8			NN
endtime	int8			NN
cluster_arn	char(128)			NN
max_vis_xid	int8			NN
query_sb_version	int8			NN
num_tuples	int4			NN
fetch_complete	int4			NN
error	char(350)			NN
connection_guid	char(100)			NN
xen_error_code	int4			NN
burst_cluster_id	char(38)			NN
burst_query_id	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

new
column	data type	PK	U	NN
action	char(20)			NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
query	int8			NN
backup_id	char(30)			NN
cluster_backup_version	int8			NN
starttime	int8			NN
endtime	int8			NN
cluster_arn	char(100)			NN
max_vis_xid	int8			NN
query_sb_version	int8			NN
num_tuples	int4			NN
fetch_complete	int4			NN
error	char(350)			NN
connection_guid	char(100)			NN
xen_error_code	int4			NN
burst_cluster_id	char(38)			NN
burst_query_id	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.stcs_burst_service_client

old
column	data type	PK	U	NN
action	char(10)			NN
pid	int8			NN
xid	int8			NN
eventtime	int8			NN
cluster_arn	char(128)			NN
expiration	int8			NN
preshared_key	char(100)			NN
num_nodes	int4			NN
error	char(250)			NN
request_id	char(100)			NN
reason	char(40)			NN
query	int4			NN
starttime	int8			NN
extended_json	char(60)			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
action	char(10)			NN
pid	int8			NN
xid	int8			NN
eventtime	int8			NN
cluster_arn	char(100)			NN
expiration	int8			NN
preshared_key	char(100)			NN
num_nodes	int4			NN
error	char(250)			NN
request_id	char(100)			NN
reason	char(40)			NN
query	int4			NN
starttime	int8			NN
extended_json	char(60)			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_burst_connection

old
column	data type	PK	U	NN
action	char(20)			NN
method	char(50)			NN
pid	int8			NN
xid	int8			NN
line_number	int8			NN
eventtime	timestamp			NN
cluster_arn	char(128)			NN
connection_guid	char(100)			NN
error	char(250)			NN
switch_status	char(20)			NN
switch_time	int4			NN
starttime	timestamp			NN
query	int4			NN

new
column	data type	PK	U	NN
action	char(20)			NN
method	char(50)			NN
pid	int8			NN
xid	int8			NN
line_number	int8			NN
eventtime	timestamp			NN
cluster_arn	char(100)			NN
connection_guid	char(100)			NN
error	char(250)			NN
switch_status	char(20)			NN
switch_time	int4			NN
starttime	timestamp			NN
query	int4			NN

pg_catalog.stll_burst_manager_personalization

old
column	data type	PK	U	NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
cluster_arn	char(128)			NN
backup_id	char(100)			NN
backup_prefix	char(100)			NN
backup_midfix	char(100)			NN
creds_access_key	char(100)			NN
creds_secret_key	char(100)			NN
creds_session_token	char(100)			NN
creds_expiration	timestamp			NN
cluster_id	char(38)			NN
cluster_name	char(70)			NN
error	char(250)			NN
account_id	char(38)			NN
query	int4			NN
auto_wlm_total_memory_mb	int4			NN
auto_wlm_per_query_max_memory_mb	int4			NN
instance_type	char(100)			NN
num_nodes	int4			NN
burst_cluster_id	char(38)			NN
burst_account_id	char(38)			NN
burst_cluster_version	char(50)			NN
main_instance_type	char(100)			NN
main_num_nodes	int4			NN
main_num_slices	int4			NN
refreshed_backup_id	char(100)			NN
refreshed_version	int4			NN
refreshing_backup_id	char(100)			NN
refreshing_version	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
cluster_arn	char(120)			NN
backup_id	char(100)			NN
backup_prefix	char(100)			NN
backup_midfix	char(100)			NN
creds_access_key	char(100)			NN
creds_secret_key	char(100)			NN
creds_session_token	char(100)			NN
creds_expiration	timestamp			NN
cluster_id	char(38)			NN
cluster_name	char(70)			NN
error	char(250)			NN
account_id	char(38)			NN
query	int4			NN
auto_wlm_total_memory_mb	int4			NN
auto_wlm_per_query_max_memory_mb	int4			NN
instance_type	char(100)			NN
num_nodes	int4			NN
burst_cluster_id	char(38)			NN
burst_account_id	char(38)			NN
burst_cluster_version	char(50)			NN
main_instance_type	char(100)			NN
main_num_nodes	int4			NN
main_num_slices	int4			NN
refreshed_backup_id	char(100)			NN
refreshed_version	int4			NN
refreshing_backup_id	char(100)			NN
refreshing_version	int4			NN

pg_catalog.stll_burst_manager_refresh

old
column	data type	PK	U	NN
eventtime	timestamp			NN
action	char(50)			NN
type	char(20)			NN
refresh_method	char(20)			NN
pid	int8			NN
refresh_version	int8			NN
cluster_arn	char(128)			NN
error	char(350)			NN

new
column	data type	PK	U	NN
eventtime	timestamp			NN
action	char(50)			NN
type	char(20)			NN
refresh_method	char(20)			NN
pid	int8			NN
refresh_version	int8			NN
cluster_arn	char(100)			NN
error	char(350)			NN

pg_catalog.stll_burst_query_execution

old
column	data type	PK	U	NN
action	char(20)			NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
query	int8			NN
backup_id	char(30)			NN
cluster_backup_version	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
cluster_arn	char(128)			NN
max_vis_xid	int8			NN
query_sb_version	int8			NN
num_tuples	int4			NN
fetch_complete	int4			NN
error	char(350)			NN
connection_guid	char(100)			NN
xen_error_code	int4			NN
burst_cluster_id	char(38)			NN
burst_query_id	int4			NN

new
column	data type	PK	U	NN
action	char(20)			NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
query	int8			NN
backup_id	char(30)			NN
cluster_backup_version	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
cluster_arn	char(100)			NN
max_vis_xid	int8			NN
query_sb_version	int8			NN
num_tuples	int4			NN
fetch_complete	int4			NN
error	char(350)			NN
connection_guid	char(100)			NN
xen_error_code	int4			NN
burst_cluster_id	char(38)			NN
burst_query_id	int4			NN

pg_catalog.stll_burst_service_client

old
column	data type	PK	U	NN
action	char(10)			NN
pid	int8			NN
xid	int8			NN
eventtime	timestamp			NN
cluster_arn	char(128)			NN
expiration	timestamp			NN
preshared_key	char(100)			NN
num_nodes	int4			NN
error	char(250)			NN
request_id	char(100)			NN
reason	char(40)			NN
query	int4			NN
starttime	timestamp			NN
extended_json	char(60)			NN

new
column	data type	PK	U	NN
action	char(10)			NN
pid	int8			NN
xid	int8			NN
eventtime	timestamp			NN
cluster_arn	char(100)			NN
expiration	timestamp			NN
preshared_key	char(100)			NN
num_nodes	int4			NN
error	char(250)			NN
request_id	char(100)			NN
reason	char(40)			NN
query	int4			NN
starttime	timestamp			NN
extended_json	char(60)			NN

pg_catalog.stv_burst_manager_cluster_info

old
column	data type	PK	U	NN
cluster_arn	char(128)			NN
num_sessions	int4			NN
max_sessions	int4			NN
backup_version	int8			NN
backup_id	char(100)			NN
last_heartbeat_check	timestamp			NN
last_used	timestamp			NN
idle_counter	int4			NN
active_pids	char(256)			NN
personalized	int4			NN
gateway_errors	int4			NN
credentials_errors	int4			NN
refresh_backup_version	int8			NN
refresh_backup_id	char(100)			NN
refresh_start_time	timestamp			NN
has_limited_sessions	int4			NN
total_memory	int8			NN
used_memory	int8			NN
multi_az	int4			NN

new
column	data type	PK	U	NN
cluster_arn	char(120)			NN
num_sessions	int4			NN
max_sessions	int4			NN
backup_version	int8			NN
backup_id	char(100)			NN
last_heartbeat_check	timestamp			NN
last_used	timestamp			NN
idle_counter	int4			NN
active_pids	char(256)			NN
personalized	int4			NN
gateway_errors	int4			NN
credentials_errors	int4			NN
refresh_backup_version	int8			NN
refresh_backup_id	char(100)			NN
refresh_start_time	timestamp			NN
has_limited_sessions	int4			NN
total_memory	int8			NN
used_memory	int8			NN
multi_az	int4			NN

pg_catalog.pg_global_object

old
column	data type	PK	U	NN
objid	oid			NN
dbid	oid			NN
schemaid	oid			NN
schemaname	name			NN
objtype	char(1)			NN
objname	name			NN
objowner	int4			NN
objnargs	int2			NN
argtypes	oidvector
objoptions	text

new
column	data type	PK	U	NN

pg_catalog.pg_global_object_attributes

old
column	data type	PK	U	NN
objid	oid			NN
attname	name			NN
attnum	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_auto_undo_events

old
column	data type	PK	U	NN
eventtime	int8			NN
node	int4			NN
slice	int4			NN
xid	int8			NN
pid	int4			NN
table_id	int4			NN
mode	int4			NN
event	char(256)			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.stcs_burst_manager_lag_based_refresh

old
column	data type	PK	U	NN
eventtime	int8			NN
cluster_arn	char(100)			NN
refresh_end_time	int8			NN
refreshed_version	int8			NN
main_sb_version	int8			NN
decision	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

new
column	data type	PK	U	NN

pg_catalog.stcs_create_table_ddl_summary

old
column	data type	PK	U	NN
querytime	int8			NN
userid	int4			NN
db_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
num_cols_with_encode	int4			NN
num_cols_without_encode	int4			NN
sortkey_defined	char(1)			NN
distkey_defined	char(1)			NN
diststyle_defined	char(1)			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.stcs_guid_based_rereplication_stats

old
column	data type	PK	U	NN
logtime	int8			NN
node_num	int4			NN
queued_reads	int8			NN
issued_reads	int8			NN
issued_writes	int8			NN
failed_reads	int8			NN
failed_writes	int8			NN
useful_writes	int8			NN
wasted_writes	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

pg_catalog.stcs_guid_cache_stats

old
column	data type	PK	U	NN
node	int4			NN
record_time	int8			NN
mode	int4			NN
entries	int8			NN
lookups	int8			NN
hits	int8			NN
inserts	int8			NN
deletes	int8			NN
resets	int8			NN
stale_hits	int8			NN
ds_lookups	int8			NN
ds_hits	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

pg_catalog.stcs_integration_cdc_detail

old
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
database_name	char(128)			NN
checkpoint	char(128)			NN
source_type	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
status	int4			NN
synced_log_coordinate	char(128)			NN
src_inserts	int8			NN
src_deletes	int8			NN
src_updates	int8			NN
inserts	int8			NN
inserts_dt	int8			NN
parsed_rows	int8			NN
skipped_rows	int8			NN
is_bursted	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

new
column	data type	PK	U	NN

pg_catalog.stcs_mddl_history

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
tbl	int4			NN
mask	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

pg_catalog.stcs_query_level_cg_paths

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	int8			NN
query	int4			NN
segment	int4			NN
was_cached	int4			NN
path	char(255)			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.stcs_query_scaling_prediction

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
cluster_size	int4			NN
execution_time	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.stcs_sage_mode_budget

old
column	data type	PK	U	NN
query	int4			NN
xid	int4			NN
userid	int4			NN
record_time	int8			NN
mb_scanned	int4			NN
rpu_sec	int4			NN
total_rpu_sec	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

new
column	data type	PK	U	NN

pg_catalog.stcs_sage_scaling_candidates

old
column	data type	PK	U	NN
query	int4			NN
decision_id	int4			NN
candidate_id	int4			NN
ssid	int4			NN
state	int4			NN
nodes	int4			NN
running_queries	int4			NN
queued_queries	int4			NN
est_exec_time_ms	int4			NN
spill_penalty_ms	int4			NN
est_prepare_delay_ms	int4			NN
est_queue_time_ms	int4			NN
penalty	float8			NN
eligible	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

new
column	data type	PK	U	NN

pg_catalog.stcs_sage_scaling_clusters

old
column	data type	PK	U	NN
recordtime	int8			NN
ssid	int4			NN
prev_state	int4			NN
new_state	int4			NN
nodes	int4			NN
arn	char(128)			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.stcs_sage_scaling_decisions

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
pid	int4			NN
userid	int4			NN
decision_id	int4			NN
decision_time	int8			NN
budget_rpu_sec	int4			NN
queue_time_ms	int4			NN
chosen_candidate_id	int4			NN
seconds_since_last_acquire	int4			NN
alpha	float8			NN
burstable	int4			NN
fallback	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

new
column	data type	PK	U	NN

pg_catalog.stll_auto_undo_events

old
column	data type	PK	U	NN
eventtime	timestamp			NN
node	int4			NN
slice	int4			NN
xid	int8			NN
pid	int4			NN
table_id	int4			NN
mode	int4			NN
event	char(256)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_burst_manager_lag_based_refresh

old
column	data type	PK	U	NN
eventtime	timestamp			NN
cluster_arn	char(100)			NN
refresh_end_time	timestamp			NN
refreshed_version	int8			NN
main_sb_version	int8			NN
decision	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_create_table_ddl_summary

old
column	data type	PK	U	NN
querytime	timestamp			NN
userid	int4			NN
db_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
num_cols_with_encode	int4			NN
num_cols_without_encode	int4			NN
sortkey_defined	char(1)			NN
distkey_defined	char(1)			NN
diststyle_defined	char(1)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_guid_based_rereplication_stats

old
column	data type	PK	U	NN
logtime	timestamp			NN
node_num	int4			NN
queued_reads	int8			NN
issued_reads	int8			NN
issued_writes	int8			NN
failed_reads	int8			NN
failed_writes	int8			NN
useful_writes	int8			NN
wasted_writes	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_guid_cache_stats

old
column	data type	PK	U	NN
node	int4			NN
record_time	timestamp			NN
mode	int4			NN
entries	int8			NN
lookups	int8			NN
hits	int8			NN
inserts	int8			NN
deletes	int8			NN
resets	int8			NN
stale_hits	int8			NN
ds_lookups	int8			NN
ds_hits	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_integration_cdc_detail

old
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
database_name	char(128)			NN
checkpoint	char(128)			NN
source_type	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
status	int4			NN
synced_log_coordinate	char(128)			NN
src_inserts	int8			NN
src_deletes	int8			NN
src_updates	int8			NN
inserts	int8			NN
inserts_dt	int8			NN
parsed_rows	int8			NN
skipped_rows	int8			NN
is_bursted	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_mddl_history

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
tbl	int4			NN
mask	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_query_level_cg_paths

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
query	int4			NN
segment	int4			NN
was_cached	int4			NN
path	char(255)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_query_scaling_prediction

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
cluster_size	int4			NN
execution_time	float8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_sage_mode_budget

old
column	data type	PK	U	NN
query	int4			NN
xid	int4			NN
userid	int4			NN
record_time	timestamp			NN
mb_scanned	int4			NN
rpu_sec	int4			NN
total_rpu_sec	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_sage_scaling_candidates

old
column	data type	PK	U	NN
query	int4			NN
decision_id	int4			NN
candidate_id	int4			NN
ssid	int4			NN
state	int4			NN
nodes	int4			NN
running_queries	int4			NN
queued_queries	int4			NN
est_exec_time_ms	int4			NN
spill_penalty_ms	int4			NN
est_prepare_delay_ms	int4			NN
est_queue_time_ms	int4			NN
penalty	float8			NN
eligible	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_sage_scaling_clusters

old
column	data type	PK	U	NN
recordtime	timestamp			NN
ssid	int4			NN
prev_state	int4			NN
new_state	int4			NN
nodes	int4			NN
arn	char(128)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_sage_scaling_decisions

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
pid	int4			NN
userid	int4			NN
decision_id	int4			NN
decision_time	timestamp			NN
budget_rpu_sec	int4			NN
queue_time_ms	int4			NN
chosen_candidate_id	int4			NN
seconds_since_last_acquire	int4			NN
alpha	float8			NN
burstable	int4			NN
fallback	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stv_inflight_undos

old
column	data type	PK	U	NN
node	int4			NN
table_id	int4			NN
undo_xid	int4			NN
undo_mode	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stv_sage_scaling_current_clusters

old
column	data type	PK	U	NN
ssid	int4			NN
state	int4			NN
nodes	int4			NN
created_time	timestamp			NN
acquired_time	timestamp			NN
arn	char(128)			NN
max_per_query_mb	int4			NN
total_cluster_mb	int4			NN
running_queries	int4			NN
queued_queries	int4			NN
est_head_wait_ms	int4			NN
fraction_of_time_occupied	float8			NN
utilization	float8			NN
allocated_mb	int4			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_4893996

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_guid_cache_metrics

old
column	data type

new
column	data type
node	int4
record_time	timestamp
entries_tracked	int8
staleness_percent	int8
unknown_percent	int8
lookups	int8
staleness_count	int8
unknown_count	int8

pg_catalog.stl_burst_connection

old
column	data type
action	char(20)
method	char(50)
pid	int8
xid	int8
line_number	int8
eventtime	timestamp
cluster_arn	char(128)
connection_guid	char(100)
error	char(250)
switch_status	char(20)
switch_time	int4
starttime	timestamp
query	int4

new
column	data type
action	char(20)
method	char(50)
pid	int8
xid	int8
line_number	int8
eventtime	timestamp
cluster_arn	char(100)
connection_guid	char(100)
error	char(250)
switch_status	char(20)
switch_time	int4
starttime	timestamp
query	int4

pg_catalog.stl_burst_manager_personalization

old
column	data type
userid	int4
pid	int8
xid	int8
starttime	timestamp
endtime	timestamp
cluster_arn	char(128)
backup_id	char(100)
backup_prefix	char(100)
backup_midfix	char(100)
creds_access_key	char(100)
creds_secret_key	char(100)
creds_session_token	char(100)
creds_expiration	timestamp
cluster_id	char(38)
cluster_name	char(70)
error	char(250)
account_id	char(38)
query	int4
auto_wlm_total_memory_mb	int4
auto_wlm_per_query_max_memory_mb	int4
instance_type	char(100)
num_nodes	int4
burst_cluster_id	char(38)
burst_account_id	char(38)
burst_cluster_version	char(50)
main_instance_type	char(100)
main_num_nodes	int4
main_num_slices	int4
refreshed_backup_id	char(100)
refreshed_version	int4
refreshing_backup_id	char(100)
refreshing_version	int4

new
column	data type
userid	int4
pid	int8
xid	int8
starttime	timestamp
endtime	timestamp
cluster_arn	char(120)
backup_id	char(100)
backup_prefix	char(100)
backup_midfix	char(100)
creds_access_key	char(100)
creds_secret_key	char(100)
creds_session_token	char(100)
creds_expiration	timestamp
cluster_id	char(38)
cluster_name	char(70)
error	char(250)
account_id	char(38)
query	int4
auto_wlm_total_memory_mb	int4
auto_wlm_per_query_max_memory_mb	int4
instance_type	char(100)
num_nodes	int4
burst_cluster_id	char(38)
burst_account_id	char(38)
burst_cluster_version	char(50)
main_instance_type	char(100)
main_num_nodes	int4
main_num_slices	int4
refreshed_backup_id	char(100)
refreshed_version	int4
refreshing_backup_id	char(100)
refreshing_version	int4

pg_catalog.stl_burst_manager_refresh

old
column	data type
eventtime	timestamp
action	char(50)
type	char(20)
refresh_method	char(20)
pid	int8
refresh_version	int8
cluster_arn	char(128)
error	char(350)

new
column	data type
eventtime	timestamp
action	char(50)
type	char(20)
refresh_method	char(20)
pid	int8
refresh_version	int8
cluster_arn	char(100)
error	char(350)

pg_catalog.stl_burst_query_execution

old
column	data type
action	char(20)
userid	int4
pid	int8
xid	int8
query	int8
backup_id	char(30)
cluster_backup_version	int8
starttime	timestamp
endtime	timestamp
cluster_arn	char(128)
max_vis_xid	int8
query_sb_version	int8
num_tuples	int4
fetch_complete	int4
error	char(350)
connection_guid	char(100)
xen_error_code	int4
burst_cluster_id	char(38)
burst_query_id	int4

new
column	data type
action	char(20)
userid	int4
pid	int8
xid	int8
query	int8
backup_id	char(30)
cluster_backup_version	int8
starttime	timestamp
endtime	timestamp
cluster_arn	char(100)
max_vis_xid	int8
query_sb_version	int8
num_tuples	int4
fetch_complete	int4
error	char(350)
connection_guid	char(100)
xen_error_code	int4
burst_cluster_id	char(38)
burst_query_id	int4

pg_catalog.stl_burst_service_client

old
column	data type
action	char(10)
pid	int8
xid	int8
eventtime	timestamp
cluster_arn	char(128)
expiration	timestamp
preshared_key	char(100)
num_nodes	int4
error	char(250)
request_id	char(100)
reason	char(40)
query	int4
starttime	timestamp
extended_json	char(60)

new
column	data type
action	char(10)
pid	int8
xid	int8
eventtime	timestamp
cluster_arn	char(100)
expiration	timestamp
preshared_key	char(100)
num_nodes	int4
error	char(250)
request_id	char(100)
reason	char(40)
query	int4
starttime	timestamp
extended_json	char(60)

pg_catalog.svl_burst_service_client

old
column	data type
action	char(10)
pid	int8
xid	int8
eventtime	timestamp
cluster_arn	char(128)
expiration	timestamp
num_nodes	int4
error	char(250)

new
column	data type
action	char(10)
pid	int8
xid	int8
eventtime	timestamp
cluster_arn	char(100)
expiration	timestamp
num_nodes	int4
error	char(250)

pg_catalog.stl_auto_undo_events

old
column	data type
eventtime	timestamp
node	int4
slice	int4
xid	int8
pid	int4
table_id	int4
mode	int4
event	char(256)

new
column	data type

pg_catalog.stl_burst_manager_lag_based_refresh

old
column	data type
eventtime	timestamp
cluster_arn	char(100)
refresh_end_time	timestamp
refreshed_version	int8
main_sb_version	int8
decision	int4

new
column	data type

pg_catalog.stl_create_table_ddl_summary

old
column	data type
querytime	timestamp
userid	int4
db_name	char(128)
schema_name	char(128)
table_name	char(128)
num_cols_with_encode	int4
num_cols_without_encode	int4
sortkey_defined	char(1)
distkey_defined	char(1)
diststyle_defined	char(1)

new
column	data type

pg_catalog.stl_guid_based_rereplication_stats

old
column	data type
logtime	timestamp
node_num	int4
queued_reads	int8
issued_reads	int8
issued_writes	int8
failed_reads	int8
failed_writes	int8
useful_writes	int8
wasted_writes	int8

new
column	data type

pg_catalog.stl_guid_cache_stats

old
column	data type
node	int4
record_time	timestamp
mode	int4
entries	int8
lookups	int8
hits	int8
inserts	int8
deletes	int8
resets	int8
stale_hits	int8
ds_lookups	int8
ds_hits	int8

new
column	data type

pg_catalog.stl_integration_cdc_detail

old
column	data type
record_time	timestamp
integration_id	char(128)
database_name	char(128)
checkpoint	char(128)
source_type	char(128)
schema_name	char(128)
table_name	char(128)
status	int4
synced_log_coordinate	char(128)
src_inserts	int8
src_deletes	int8
src_updates	int8
inserts	int8
inserts_dt	int8
parsed_rows	int8
skipped_rows	int8
is_bursted	int4

new
column	data type

pg_catalog.stl_mddl_history

old
column	data type
query	int4
segment	int4
tbl	int4
mask	int8

new
column	data type

pg_catalog.stl_query_level_cg_paths

old
column	data type
userid	int4
recordtime	timestamp
query	int4
segment	int4
was_cached	int4
path	char(255)

new
column	data type

pg_catalog.stl_query_scaling_prediction

old
column	data type
query	int4
xid	int8
cluster_size	int4
execution_time	float8

new
column	data type

pg_catalog.stl_sage_mode_budget

old
column	data type
query	int4
xid	int4
userid	int4
record_time	timestamp
mb_scanned	int4
rpu_sec	int4
total_rpu_sec	int4

new
column	data type

pg_catalog.stl_sage_scaling_candidates

old
column	data type
query	int4
decision_id	int4
candidate_id	int4
ssid	int4
state	int4
nodes	int4
running_queries	int4
queued_queries	int4
est_exec_time_ms	int4
spill_penalty_ms	int4
est_prepare_delay_ms	int4
est_queue_time_ms	int4
penalty	float8
eligible	int4

new
column	data type

pg_catalog.stl_sage_scaling_clusters

old
column	data type
recordtime	timestamp
ssid	int4
prev_state	int4
new_state	int4
nodes	int4
arn	char(128)

new
column	data type

pg_catalog.stl_sage_scaling_decisions

old
column	data type
query	int4
xid	int8
pid	int4
userid	int4
decision_id	int4
decision_time	timestamp
budget_rpu_sec	int4
queue_time_ms	int4
chosen_candidate_id	int4
seconds_since_last_acquire	int4
alpha	float8
burstable	int4
fallback	int4

new
column	data type

pg_catalog.sys_auto_table_optimization

old
column	data type
transaction_id	int8
session_id	int4
table_id	int4
alter_table_type	text
status	char(128)
event_time	timestamp
alter_from	char(200)

new
column	data type