Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
dropped	pg_catalog	internal	immutable	bool	intervald2s_eq	intervald2s,intervald2s
dropped	pg_catalog	internal	immutable	bool	intervald2s_ge	intervald2s,intervald2s
dropped	pg_catalog	internal	immutable	bool	intervald2s_gt	intervald2s,intervald2s
dropped	pg_catalog	internal	immutable	bool	intervald2s_le	intervald2s,intervald2s
dropped	pg_catalog	internal	immutable	bool	intervald2s_lt	intervald2s,intervald2s
dropped	pg_catalog	internal	immutable	bool	intervald2s_ne	intervald2s,intervald2s
dropped	pg_catalog	internal	immutable	bool	intervaly2m_eq	intervaly2m,intervaly2m
dropped	pg_catalog	internal	immutable	bool	intervaly2m_ge	intervaly2m,intervaly2m
dropped	pg_catalog	internal	immutable	bool	intervaly2m_gt	intervaly2m,intervaly2m
dropped	pg_catalog	internal	immutable	bool	intervaly2m_le	intervaly2m,intervaly2m
dropped	pg_catalog	internal	immutable	bool	intervaly2m_lt	intervaly2m,intervaly2m
dropped	pg_catalog	internal	immutable	bool	intervaly2m_ne	intervaly2m,intervaly2m
dropped	pg_catalog	internal	immutable	bpchar	bpchar	intervald2s
dropped	pg_catalog	internal	immutable	bpchar	bpchar	intervaly2m
dropped	pg_catalog	internal	immutable	bytea	intervald2s_send	intervald2s
dropped	pg_catalog	internal	immutable	bytea	intervaly2m_send	intervaly2m
dropped	pg_catalog	internal	immutable	cstring	intervald2s_out	intervald2s
dropped	pg_catalog	internal	immutable	cstring	intervaly2m_out	intervaly2m
dropped	pg_catalog	internal	immutable	date	date_mi_intervaly2m	date,intervaly2m
dropped	pg_catalog	internal	immutable	date	date_pl_intervaly2m	date,intervaly2m
dropped	pg_catalog	internal	immutable	float8	date_part	text,intervald2s
dropped	pg_catalog	internal	immutable	float8	date_part	text,intervaly2m
dropped	pg_catalog	internal	immutable	hllsketch	hll_create_sketch	intervald2s
dropped	pg_catalog	internal	immutable	hllsketch	hll_create_sketch	intervaly2m
dropped	pg_catalog	internal	immutable	hllsketch	hll_insert_to_sketch_intervald2s	hllsketch,intervald2s
dropped	pg_catalog	internal	immutable	hllsketch	hll_insert_to_sketch_intervaly2m	hllsketch,intervaly2m
dropped	pg_catalog	internal	immutable	int4	intervald2s_cmp	intervald2s,intervald2s
dropped	pg_catalog	internal	immutable	int4	intervaly2m_cmp	intervaly2m,intervaly2m
dropped	pg_catalog	internal	immutable	int8	h3_fromlonglat	float8,float8,int4
dropped	pg_catalog	internal	immutable	int8	h3_frompoint	geometry,int4
dropped	pg_catalog	internal	immutable	int8	hll	intervald2s
dropped	pg_catalog	internal	immutable	int8	hll	intervaly2m
dropped	pg_catalog	internal	immutable	interval	any_value	interval
dropped	pg_catalog	internal	immutable	interval	any_value_interval	interval,interval
dropped	pg_catalog	internal	immutable	interval	to_interval	intervald2s
dropped	pg_catalog	internal	immutable	interval	to_interval	intervaly2m
dropped	pg_catalog	internal	immutable	_intervald2s	intervald2s_accum	_intervald2s,intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	any_value	intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	any_value_intervald2s	intervald2s,intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	avg	intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	date_trunc	text,intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	first_value	intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	intervald2s	intervald2s,int4
dropped	pg_catalog	internal	immutable	intervald2s	intervald2s	reltime
dropped	pg_catalog	internal	immutable	intervald2s	intervald2s_avg	_intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	intervald2s_div	intervald2s,float8
dropped	pg_catalog	internal	immutable	intervald2s	intervald2s_larger	intervald2s,intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	intervald2s_mi	intervald2s,intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	intervald2s_mul	intervald2s,float8
dropped	pg_catalog	internal	immutable	intervald2s	intervald2s_pl	intervald2s,intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	intervald2s_recv	internal
dropped	pg_catalog	internal	immutable	intervald2s	intervald2s_smaller	intervald2s,intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	intervald2s_um	intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	lag	intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	lag	intervald2s,int4
dropped	pg_catalog	internal	immutable	intervald2s	lag	intervald2s,int4,intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	last_value	intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	lead	intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	lead	intervald2s,int4
dropped	pg_catalog	internal	immutable	intervald2s	lead	intervald2s,int4,intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	max	intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	median	intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	min	intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	nth_value	intervald2s,int4
dropped	pg_catalog	internal	immutable	intervald2s	percentile_cont	intervald2s,numeric
dropped	pg_catalog	internal	immutable	intervald2s	percentile_disc	intervald2s,numeric
dropped	pg_catalog	internal	immutable	intervald2s	sum	intervald2s
dropped	pg_catalog	internal	immutable	intervald2s	to_intervald2s	interval
dropped	pg_catalog	internal	immutable	_intervaly2m	intervaly2m_accum	_intervaly2m,intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	any_value	intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	any_value_intervaly2m	intervaly2m,intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	avg	intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	date_trunc	text,intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	first_value	intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	intervaly2m	intervaly2m,int4
dropped	pg_catalog	internal	immutable	intervaly2m	intervaly2m_avg	_intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	intervaly2m_div	intervaly2m,float8
dropped	pg_catalog	internal	immutable	intervaly2m	intervaly2m_larger	intervaly2m,intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	intervaly2m_mi	intervaly2m,intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	intervaly2m_mul	intervaly2m,float8
dropped	pg_catalog	internal	immutable	intervaly2m	intervaly2m_pl	intervaly2m,intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	intervaly2m_recv	internal
dropped	pg_catalog	internal	immutable	intervaly2m	intervaly2m_smaller	intervaly2m,intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	intervaly2m_um	intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	lag	intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	lag	intervaly2m,int4
dropped	pg_catalog	internal	immutable	intervaly2m	lag	intervaly2m,int4,intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	last_value	intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	lead	intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	lead	intervaly2m,int4
dropped	pg_catalog	internal	immutable	intervaly2m	lead	intervaly2m,int4,intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	max	intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	median	intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	min	intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	nth_value	intervaly2m,int4
dropped	pg_catalog	internal	immutable	intervaly2m	percentile_cont	intervaly2m,numeric
dropped	pg_catalog	internal	immutable	intervaly2m	percentile_disc	intervaly2m,numeric
dropped	pg_catalog	internal	immutable	intervaly2m	sum	intervaly2m
dropped	pg_catalog	internal	immutable	intervaly2m	to_intervaly2m	interval
dropped	pg_catalog	internal	immutable	reltime	reltime	intervald2s
dropped	pg_catalog	internal	immutable	text	text	intervald2s
dropped	pg_catalog	internal	immutable	text	text	intervaly2m
dropped	pg_catalog	internal	immutable	time	time	intervald2s
dropped	pg_catalog	internal	immutable	time	time_mi_intervald2s	time,intervald2s
dropped	pg_catalog	internal	immutable	time	time_pl_intervald2s	time,intervald2s
dropped	pg_catalog	internal	immutable	timestamp	date_mi_intervald2s	date,intervald2s
dropped	pg_catalog	internal	immutable	timestamp	date_pl_intervald2s	date,intervald2s
dropped	pg_catalog	internal	immutable	timestamp	timestamp_mi_intervald2s	timestamp,intervald2s
dropped	pg_catalog	internal	immutable	timestamp	timestamp_mi_intervaly2m	timestamp,intervaly2m
dropped	pg_catalog	internal	immutable	timestamp	timestamp_pl_intervald2s	timestamp,intervald2s
dropped	pg_catalog	internal	immutable	timestamp	timestamp_pl_intervaly2m	timestamp,intervaly2m
dropped	pg_catalog	internal	immutable	timestamp	timezone	intervald2s,timestamptz
dropped	pg_catalog	internal	immutable	timestamptz	timezone	intervald2s,timestamp
dropped	pg_catalog	internal	immutable	timetz	timetz_mi_intervald2s	timetz,intervald2s
dropped	pg_catalog	internal	immutable	timetz	timetz_pl_intervald2s	timetz,intervald2s
dropped	pg_catalog	internal	immutable	varchar	qsummary	intervald2s
dropped	pg_catalog	internal	immutable	varchar	qsummary	intervaly2m
dropped	pg_catalog	internal	stable	intervald2s	intervald2s	bpchar
dropped	pg_catalog	internal	stable	intervald2s	intervald2s	text
dropped	pg_catalog	internal	stable	intervald2s	intervald2s_in	cstring,oid,int4
dropped	pg_catalog	internal	stable	intervaly2m	intervaly2m	bpchar
dropped	pg_catalog	internal	stable	intervaly2m	intervaly2m	text
dropped	pg_catalog	internal	stable	intervaly2m	intervaly2m_in	cstring,oid,int4
dropped	pg_catalog	internal	stable	timestamptz	timestamptz_mi_intervald2s	timestamptz,intervald2s
dropped	pg_catalog	internal	stable	timestamptz	timestamptz_mi_intervaly2m	timestamptz,intervaly2m
dropped	pg_catalog	internal	stable	timestamptz	timestamptz_pl_intervald2s	timestamptz,intervald2s
dropped	pg_catalog	internal	stable	timestamptz	timestamptz_pl_intervaly2m	timestamptz,intervaly2m
dropped	pg_catalog	sql	immutable	date	intervaly2m_pl_date	intervaly2m,date
dropped	pg_catalog	sql	immutable	intervald2s	mul_d_intervald2s	float8,intervald2s
dropped	pg_catalog	sql	immutable	intervaly2m	mul_d_intervaly2m	float8,intervaly2m
dropped	pg_catalog	sql	immutable	time	intervald2s_pl_time	intervald2s,time
dropped	pg_catalog	sql	immutable	timestamp	intervald2s_pl_date	intervald2s,date
dropped	pg_catalog	sql	immutable	timestamp	intervald2s_pl_timestamp	intervald2s,timestamp
dropped	pg_catalog	sql	immutable	timestamp	intervaly2m_pl_timestamp	intervaly2m,timestamp
dropped	pg_catalog	sql	immutable	timetz	intervald2s_pl_timetz	intervald2s,timetz
dropped	pg_catalog	sql	stable	timestamptz	intervald2s_pl_timestamptz	intervald2s,timestamptz
dropped	pg_catalog	sql	stable	timestamptz	intervaly2m_pl_timestamptz	intervaly2m,timestamptz

Tables

pg_catalog.stcs_volt_tt_sizes

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
table_id	int4			NN
node	int4			NN
num_blocks	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_volt_tt_sizes

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
table_id	int4			NN
node	int4			NN
num_blocks	int4			NN

pg_internal.redshift_auto_health_check_37390414

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.pg_integration_database

old
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
channel_arn	name			NN
remote_db_id	oid			NN
remote_db_name	name			NN
local_db_id	oid			NN
local_db_name	name			NN
state	int4			NN
filters	text
details	text

new
column	data type	PK	U	NN

pg_catalog.stcs_arcadia_billing_burstq_tracking

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	int8			NN
rewritten_qid	int4			NN
user_query_id	int8			NN
child_query_seq	int4			NN
pid	int4			NN
start_time	int8			NN
total_duration	int4			NN
reported_so_far	int4			NN
remaining	int4			NN
completed	int4			NN
tx_billable_state	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_arcadia_billing_txn_tracking

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	int8			NN
xid	int8			NN
pid	int4			NN
start_time	int8			NN
total_duration	int4			NN
reported_so_far	int4			NN
remaining	int4			NN
completed	int4			NN
tx_billable_state	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_burst_max_rpus

old
column	data type	PK	U	NN
recordtime	int8			NN
pid	int4			NN
main_cluster_rpus	int4			NN
total_rpus	int4			NN
available_rpus	int4			NN
cluster_rpus	int4			NN
spare_clusters_slots_based_on_rpu	int4			NN
spare_clusters_slots_based_on_cluster	int4			NN
spare_clusters_slots	int4			NN
max_rpus	int4			NN
max_concurrency_scaling_clusters	int4			NN
current_clusters_count	int4			NN
async_acquire_enabled	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_cluster_idleness

old
column	data type	PK	U	NN
type	char(10)			NN
start_time	int8			NN
end_time	int8			NN
record_before_pause	char(10)			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_comm_pkt_size

old
column	data type	PK	U	NN
since	int8			NN
now	int8			NN
dest_node	int4			NN
is_socket	int4			NN
cmd_code	char(64)			NN
mean	float8			NN
stdev	float8			NN
min	int8			NN
max	int8			NN
total	int4			NN
less_than_100	int4			NN
less_than_1000	int4			NN
less_than_10000	int4			NN
inf	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_conjunct_scan_metrics

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
tbl	int4			NN
slice	int4			NN
conjunct	int4			NN
observed_rrscan_rows_filtered	int8			NN
observed_post_rrscan_rows_filtered	int8			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

pg_catalog.stcs_filter

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
nodeid	int4			NN
parentid	int4			NN
kind	int4			NN
sequence	int4			NN
text	char(200)			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_restore_slice_mapping

old
column	data type	PK	U	NN
plan_id	char(256)			NN
mapping_policy	int4			NN
resize_type	int4			NN
slice_transfer_plan_state	int4			NN
slice_remapper_state	int4			NN
global_slice_num	int4			NN
target_node_num	int4			NN
target_local_slice_num	int4			NN
source_node_num	int4			NN
source_local_slice_num	int4			NN
num_non_distall_data_blocks	int4			NN
num_distall_data_blocks	int4			NN
num_temp_non_distall_data_blocks	int4			NN
num_temp_distall_blocks	int4			NN
num_metadata_blocks	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_s3table_stats

old
column	data type	PK	U	NN
user_id	int4			NN
pid	int4			NN
external_database_name	char(136)			NN
external_table_name	char(136)			NN
internal_table_name	char(272)			NN
record_time	int8			NN
table_statistics_source	int4			NN
column_statistics_source	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_shadow_table_recovery

old
column	data type	PK	U	NN
recordtime	int8			NN
db_id	int4			NN
tbl_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

pg_catalog.stcs_transaction_history

old
column	data type	PK	U	NN
user_id	int4			NN
transaction_id	int8			NN
isolation_level	int4			NN
node_id	int4			NN
status	int4			NN
transaction_start_time	int8			NN
commit_start_time	int8			NN
commit_end_time	int8			NN
dirty_blocks	int8			NN
headers	int8			NN
undo_xid	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_unified_vec_scan

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
scalar_fetcher_columns_count	int4			NN
predicate_scalar_fetchers_count	int4			NN
payload_scalar_fetchers_count	int4			NN
subtree_nodes_count	int4			NN
subtree_depth	int4			NN
scalar_fetcher_nodes_count	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_arcadia_billing_burstq_tracking

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
rewritten_qid	int4			NN
user_query_id	int8			NN
child_query_seq	int4			NN
pid	int4			NN
start_time	timestamp			NN
total_duration	int4			NN
reported_so_far	int4			NN
remaining	int4			NN
completed	int4			NN
tx_billable_state	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_arcadia_billing_txn_tracking

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
xid	int8			NN
pid	int4			NN
start_time	timestamp			NN
total_duration	int4			NN
reported_so_far	int4			NN
remaining	int4			NN
completed	int4			NN
tx_billable_state	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_burst_max_rpus

old
column	data type	PK	U	NN
recordtime	timestamp			NN
pid	int4			NN
main_cluster_rpus	int4			NN
total_rpus	int4			NN
available_rpus	int4			NN
cluster_rpus	int4			NN
spare_clusters_slots_based_on_rpu	int4			NN
spare_clusters_slots_based_on_cluster	int4			NN
spare_clusters_slots	int4			NN
max_rpus	int4			NN
max_concurrency_scaling_clusters	int4			NN
current_clusters_count	int4			NN
async_acquire_enabled	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_cluster_idleness

old
column	data type	PK	U	NN
type	char(10)			NN
start_time	timestamp			NN
end_time	timestamp			NN
record_before_pause	char(10)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_comm_pkt_size

old
column	data type	PK	U	NN
since	timestamp			NN
now	timestamp			NN
dest_node	int4			NN
is_socket	int4			NN
cmd_code	char(64)			NN
mean	float8			NN
stdev	float8			NN
min	int8			NN
max	int8			NN
total	int4			NN
less_than_100	int4			NN
less_than_1000	int4			NN
less_than_10000	int4			NN
inf	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_conjunct_scan_metrics

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
tbl	int4			NN
slice	int4			NN
conjunct	int4			NN
observed_rrscan_rows_filtered	int8			NN
observed_post_rrscan_rows_filtered	int8			NN
recordtime	timestamp			NN

new
column	data type	PK	U	NN

pg_catalog.stll_filter

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
nodeid	int4			NN
parentid	int4			NN
kind	int4			NN
sequence	int4			NN
text	char(200)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_restore_slice_mapping

old
column	data type	PK	U	NN
plan_id	char(256)			NN
mapping_policy	int4			NN
resize_type	int4			NN
slice_transfer_plan_state	int4			NN
slice_remapper_state	int4			NN
global_slice_num	int4			NN
target_node_num	int4			NN
target_local_slice_num	int4			NN
source_node_num	int4			NN
source_local_slice_num	int4			NN
num_non_distall_data_blocks	int4			NN
num_distall_data_blocks	int4			NN
num_temp_non_distall_data_blocks	int4			NN
num_temp_distall_blocks	int4			NN
num_metadata_blocks	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_s3table_stats

old
column	data type	PK	U	NN
user_id	int4			NN
pid	int4			NN
external_database_name	char(136)			NN
external_table_name	char(136)			NN
internal_table_name	char(272)			NN
record_time	timestamp			NN
table_statistics_source	int4			NN
column_statistics_source	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_shadow_table_recovery

old
column	data type	PK	U	NN
recordtime	timestamp			NN
db_id	int4			NN
tbl_id	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_transaction_history

old
column	data type	PK	U	NN
user_id	int4			NN
transaction_id	int8			NN
isolation_level	int4			NN
node_id	int4			NN
status	int4			NN
transaction_start_time	timestamp			NN
commit_start_time	timestamp			NN
commit_end_time	timestamp			NN
dirty_blocks	int8			NN
headers	int8			NN
undo_xid	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_unified_vec_scan

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
scalar_fetcher_columns_count	int4			NN
predicate_scalar_fetchers_count	int4			NN
payload_scalar_fetchers_count	int4			NN
subtree_nodes_count	int4			NN
subtree_depth	int4			NN
scalar_fetcher_nodes_count	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stv_dag_cleanup_queue

old
column	data type	PK	U	NN
ending_xid	int8			NN
txn_set_size	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stv_guid_cache

old
column	data type	PK	U	NN
node	int4			NN
guid	char(64)			NN
diskno	int4			NN
diskaddr	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stv_redshift_schema_quota

old
column	data type	PK	U	NN
database_name	char(128)			NN
schema_name	char(128)			NN
schema_id	int4			NN
schema_owner	int4			NN
quota	int4			NN
disk_usage	int4			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_4101577

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_volt_tt_sizes

old
column	data type

new
column	data type
table_id	int4
node	int4
num_blocks	int4

pg_catalog.sys_integration_table_state

old
column	data type

new
column	data type
integration_id	char(128)
database_name	char(128)
schema_name	char(128)
table_name	char(128)
state	char(128)
last_replicated_checkpoint	char(128)
reason	char(256)
last_updated	timestamp

pg_catalog.sys_connection_log

old
column	data type
event	char(50)
record_time	timestamp
remote_host	char(32)
remote_port	char(32)
session_id	int4
database_name	char(50)
user_name	char(50)
auth_method	char(32)
duration	int8
ssl_version	char(50)
ssl_cipher	char(128)
mtu	int4
ssl_compression	char(64)
ssl_expansion	char(64)
iam_auth_guid	char(36)
application_name	char(250)
driver_version	char(64)
os_version	char(64)
plugin_name	char(32)
protocol_version	int4
global_session_id	char(36)

new
column	data type
event	char(50)
record_time	timestamp
remote_host	char(32)
remote_port	char(32)
session_id	int4
database_name	char(50)
user_name	char(50)
auth_method	char(32)
duration	int8
sslversion	char(50)
ssl_cipher	char(128)
mtu	int4
sslcompression	char(64)
sslexpansion	char(64)
iam_auth_guid	char(36)
application_name	char(250)
driver_version	char(64)
os_version	char(64)
plugin_name	char(32)
protocol_version	int4
glodbal_session_id	char(36)

pg_catalog.sys_load_detail

old
column	data type
user_id	int4
query_id	int8
file_name	char(256)
bytes_scanned	int8
lines_scanned	int8
record_time	timestamp
splits_scanned	int8
start_time	timestamp
end_time	timestamp

new
column	data type
user_id	int4
query_id	int8
file_name	char(256)
bytes_scanned	int4
lines_scanned	int4
record_time	timestamp

pg_catalog.stl_arcadia_billing_burstq_tracking

old
column	data type
userid	int4
recordtime	timestamp
rewritten_qid	int4
user_query_id	int8
child_query_seq	int4
pid	int4
start_time	timestamp
total_duration	int4
reported_so_far	int4
remaining	int4
completed	int4
tx_billable_state	int4

new
column	data type

pg_catalog.stl_arcadia_billing_txn_tracking

old
column	data type
userid	int4
recordtime	timestamp
xid	int8
pid	int4
start_time	timestamp
total_duration	int4
reported_so_far	int4
remaining	int4
completed	int4
tx_billable_state	int4

new
column	data type

pg_catalog.stl_burst_max_rpus

old
column	data type
recordtime	timestamp
pid	int4
main_cluster_rpus	int4
total_rpus	int4
available_rpus	int4
cluster_rpus	int4
spare_clusters_slots_based_on_rpu	int4
spare_clusters_slots_based_on_cluster	int4
spare_clusters_slots	int4
max_rpus	int4
max_concurrency_scaling_clusters	int4
current_clusters_count	int4
async_acquire_enabled	int4

new
column	data type

pg_catalog.stl_cluster_idleness

old
column	data type
type	char(10)
start_time	timestamp
end_time	timestamp
record_before_pause	char(10)

new
column	data type

pg_catalog.stl_comm_pkt_size

old
column	data type
since	timestamp
now	timestamp
dest_node	int4
is_socket	int4
cmd_code	char(64)
mean	float8
stdev	float8
min	int8
max	int8
total	int4
less_than_100	int4
less_than_1000	int4
less_than_10000	int4
inf	int4

new
column	data type

pg_catalog.stl_conjunct_scan_metrics

old
column	data type
query	int4
segment	int4
tbl	int4
slice	int4
conjunct	int4
observed_rrscan_rows_filtered	int8
observed_post_rrscan_rows_filtered	int8
recordtime	timestamp

new
column	data type

pg_catalog.stl_filter

old
column	data type
userid	int4
query	int4
nodeid	int4
parentid	int4
kind	int4
sequence	int4
text	char(200)

new
column	data type

pg_catalog.stl_restore_slice_mapping

old
column	data type
plan_id	char(256)
mapping_policy	int4
resize_type	int4
slice_transfer_plan_state	int4
slice_remapper_state	int4
global_slice_num	int4
target_node_num	int4
target_local_slice_num	int4
source_node_num	int4
source_local_slice_num	int4
num_non_distall_data_blocks	int4
num_distall_data_blocks	int4
num_temp_non_distall_data_blocks	int4
num_temp_distall_blocks	int4
num_metadata_blocks	int4

new
column	data type

pg_catalog.stl_s3table_stats

old
column	data type
user_id	int4
pid	int4
external_database_name	char(136)
external_table_name	char(136)
internal_table_name	char(272)
record_time	timestamp
table_statistics_source	int4
column_statistics_source	int4

new
column	data type

pg_catalog.stl_shadow_table_recovery

old
column	data type
recordtime	timestamp
db_id	int4
tbl_id	int4

new
column	data type

pg_catalog.stl_transaction_history

old
column	data type
user_id	int4
transaction_id	int8
isolation_level	int4
node_id	int4
status	int4
transaction_start_time	timestamp
commit_start_time	timestamp
commit_end_time	timestamp
dirty_blocks	int8
headers	int8
undo_xid	int8

new
column	data type

pg_catalog.stl_unified_vec_scan

old
column	data type
query	int4
segment	int4
step	int4
scalar_fetcher_columns_count	int4
predicate_scalar_fetchers_count	int4
payload_scalar_fetchers_count	int4
subtree_nodes_count	int4
subtree_depth	int4
scalar_fetcher_nodes_count	int4

new
column	data type

pg_catalog.svv_redshift_schema_quota

old
column	data type
database_name	char(128)
schema_name	char(128)
schema_owner	int4
quota	int4
disk_usage	int4

new
column	data type

pg_catalog.svv_tables_space_usage

old
column	data type
node	int4
capacity	int8
local_perm_tables_space_used	int8
local_temp_tables_space_used	int8
datasharing_tables_space_used	int8

new
column	data type

pg_catalog.sys_analyze_compression_history

old
column	data type
user_id	int4
start_time	timestamp
transaction_id	int8
table_id	int4
table_name	char(128)
column_position	int4
old_encoding	char(15)
new_encoding	char(15)
mode	char(14)

new
column	data type

pg_catalog.sys_analyze_history

old
column	data type
user_id	int4
transaction_id	int8
database_name	char(30)
schema_name	char(128)
table_name	char(136)
table_id	int4
is_automatic	char(1)
status	char(15)
start_time	timestamp
end_time	timestamp
rows	float8
modified_rows	float8
analyze_threshold_percent	float8
last_analyze_time	timestamp

new
column	data type

pg_catalog.sys_datashare_cross_region_usage

old
column	data type
query_id	int8
child_query_sequence	int4
segment_id	int8
start_time	int8
end_time	int8
transferred_data	int8
source_region	char(64)

new
column	data type

pg_catalog.sys_integration_table_state_change

old
column	data type
integration_id	char(128)
database_name	char(128)
schema_name	char(128)
table_name	char(128)
new_state	char(128)
table_last_replicated_checkpoint	char(128)
state_change_reason	char(256)
record_time	timestamp

new
column	data type

pg_catalog.sys_procedure_call

old
column	data type
session_user_id	int4
security_user_id	int4
query_id	int8
query_text	char(500)
start_time	timestamp
end_time	timestamp
status	text
caller_procedure_query_id	int8

new
column	data type

pg_catalog.sys_procedure_messages

old
column	data type
transaction_id	int8
query_id	int8
record_time	timestamp
log_level	text
message	char(1024)
line_number	int4

new
column	data type

pg_catalog.sys_session_history

old
column	data type
user_id	int4
session_id	int4
database_name	char(50)
status	varchar(9)
session_timeout	int4
start_time	timestamp
end_time	timestamp

new
column	data type

pg_catalog.sys_transaction_history

old
column	data type
user_id	int4
transaction_id	int8
isolation_level	text
status	text
transaction_start_time	timestamp
commit_start_time	timestamp
commit_end_time	timestamp
blocks_committed	int8
undo_transaction_id	int8

new
column	data type

pg_catalog.sys_udf_log

old
column	data type
query_id	int8
function_name	char(256)
record_time	timestamp
sequence	int4
message	text

new
column	data type