Redshift Research Project System Table Tracker

Functions

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

Tables

pg_catalog.pg_integration_database

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_arcadia_billing_burstq_tracking

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_arcadia_billing_txn_tracking

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_burst_max_rpus

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_cluster_idleness

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_comm_pkt_size

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_conjunct_scan_metrics

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_filter

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_restore_slice_mapping

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_s3table_stats

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_shadow_table_recovery

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_transaction_history

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_unified_vec_scan

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_arcadia_billing_burstq_tracking

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_arcadia_billing_txn_tracking

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_burst_max_rpus

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_cluster_idleness

old
column	data type	PK	U	NN

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

pg_catalog.stll_comm_pkt_size

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_conjunct_scan_metrics

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_filter

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_restore_slice_mapping

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_s3table_stats

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_shadow_table_recovery

old
column	data type	PK	U	NN

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

pg_catalog.stll_transaction_history

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_unified_vec_scan

old
column	data type	PK	U	NN

new
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

pg_catalog.stv_dag_cleanup_queue

old
column	data type	PK	U	NN

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

pg_catalog.stv_guid_cache

old
column	data type	PK	U	NN

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

pg_catalog.stv_redshift_schema_quota

old
column	data type	PK	U	NN

new
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

pg_internal.redshift_auto_health_check_4188506

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_analyze

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
database	char(30)			NN
table_id	int4			NN
status	char(15)			NN
rows	float8			NN
modified_rows	float8			NN
threshold_percent	float8			NN
is_auto	char(1)			NN
starttime	int8			NN
endtime	int8			NN
prevtime	int8			NN
num_predicate_cols	int4			NN
num_new_predicate_cols	int4			NN
is_background	char(1)			NN
auto_analyze_phase	char(100)			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
xid	int8			NN
database	char(30)			NN
table_id	int4			NN
status	char(15)			NN
rows	float8			NN
modified_rows	float8			NN
threshold_percent	float8			NN
is_auto	char(1)			NN
starttime	int8			NN
endtime	int8			NN
prevtime	int8			NN
num_predicate_cols	int4			NN
num_new_predicate_cols	int4			NN
is_background	char(1)			NN
auto_analyze_phase	char(100)			NN
schema_name	char(128)			NN
table_name	char(136)			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_analyze_compression

old
column	data type	PK	U	NN
userid	int4			NN
start_time	int8			NN
xid	int8			NN
tbl	int4			NN
tablename	char(128)			NN
col	int4			NN
old_encoding	char(15)			NN
new_encoding	char(15)			NN
mode	char(14)			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
start_time	int8			NN
xid	int8			NN
tbl	int4			NN
tablename	char(128)			NN
col	int4			NN
old_encoding	char(15)			NN
new_encoding	char(15)			NN
mode	char(14)			NN
best_compression_encoding	char(15)			NN
recommended_bytes	int8			NN
best_compression_bytes	int8			NN
ndv	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.stcs_arcadia_billing_ris_reports

old
column	data type	PK	U	NN
request_id	char(100)			NN
billing_time	char(100)			NN
usage_rpu_sec	int4			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
is_burst	int4			NN
cluster_arn	char(128)			NN
usage_sec	int4			NN
usage_sec_before_minimum	int4			NN
cluster_rpus	int4			NN
report_time	int8			NN
interval_starttime	int8			NN
interval_endtime	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
request_id	char(100)			NN
billing_time	char(100)			NN
usage_rpu_sec	int4			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
is_burst	int4			NN
cluster_arn	char(128)			NN
usage_sec	int4			NN
usage_sec_before_minimum	int4			NN
interval_billed_starttime	int8			NN
interval_billed_endtime	int8			NN
cluster_rpus	int4			NN
report_time	int8			NN
interval_starttime	int8			NN
interval_endtime	int8			NN
resv_model	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_arcadia_concurrency_scaling_usage

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
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	int8			NN
endtime	int8			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN
is_cs_at_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
userid	int4			NN
recordtime	int8			NN
rewritten_qid	int4			NN
user_query_id	int8			NN
child_query_seq	int4			NN
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	int8			NN
endtime	int8			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN
is_cs_at_query	int4			NN
is_multi_az_secondary	int4			NN
resv_model	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_arcadia_main_usage

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	int8			NN
xid	int8			NN
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	int8			NN
endtime	int8			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	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
recordtime	int8			NN
xid	int8			NN
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	int8			NN
endtime	int8			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN
resv_model	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_bkg_compile_info

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
segment	int4			NN
locus	int4			NN
starttime	int8			NN
endtime	int8			NN
bytes	int8			NN
path	char(255)			NN
compile	int4			NN
complevel	int4			NN
cachehit	int4			NN
tokwaittime	int8			NN
compilestarttime	int8			NN
compileendtime	int8			NN
compilelocktime	int8			NN
compilememory	int8			NN
putsuccess	int4			NN
getsuccess	int4			NN
puttime	int8			NN
gettime	int8			NN
objsize	int8			NN
skip_opt_compile	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
xid	int8			NN
pid	int4			NN
query	int4			NN
segment	int4			NN
locus	int4			NN
starttime	int8			NN
endtime	int8			NN
bytes	int8			NN
path	char(255)			NN
compile	int4			NN
complevel	int4			NN
cachehit	int4			NN
tokwaittime	int8			NN
compilestarttime	int8			NN
compileendtime	int8			NN
compilelocktime	int8			NN
compilememory	int8			NN
putsuccess	int4			NN
getsuccess	int4			NN
puttime	int8			NN
gettime	int8			NN
objsize	int8			NN
skip_opt_compile	int4			NN
cachehit_name	char(40)			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_refresh

old
column	data type	PK	U	NN
record_time	int8			NN
node	int4			NN
process	char(32)			NN
pid	int4			NN
error_code	int4			NN
message	char(1024)			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
record_time	int8			NN
node	int4			NN
process	char(32)			NN
pid	int4			NN
error_code	int4			NN
message	char(1024)			NN
thread_id	char(32)			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_catalog_bufmgr_stats

old
column	data type	PK	U	NN
logtime	int8			NN
period_start	int8			NN
read_buffer	int8			NN
hits	int8			NN
free_buffers_found	int8			NN
evictions	int8			NN
dirty_evictions	int8			NN
contentions_on_eviction	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
logtime	int8			NN
period_start	int8			NN
read_buffer	int8			NN
hits	int8			NN
free_buffers_found	int8			NN
evictions	int8			NN
dirty_evictions	int8			NN
contentions_on_eviction	int8			NN
pid	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.stcs_compile_info

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
segment	int4			NN
locus	int4			NN
starttime	int8			NN
endtime	int8			NN
bytes	int8			NN
path	char(255)			NN
compile	int4			NN
complevel	int4			NN
cachehit	int4			NN
tokwaittime	int8			NN
compilestarttime	int8			NN
compileendtime	int8			NN
compilelocktime	int8			NN
compilememory	int8			NN
getsuccess	int4			NN
gettime	int8			NN
objsize	int8			NN
skip_opt_compile	int4			NN
replace_obj_status	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
xid	int8			NN
pid	int4			NN
query	int4			NN
segment	int4			NN
locus	int4			NN
starttime	int8			NN
endtime	int8			NN
bytes	int8			NN
path	char(255)			NN
compile	int4			NN
complevel	int4			NN
cachehit	int4			NN
tokwaittime	int8			NN
compilestarttime	int8			NN
compileendtime	int8			NN
compilelocktime	int8			NN
compilememory	int8			NN
getsuccess	int4			NN
gettime	int8			NN
objsize	int8			NN
skip_opt_compile	int4			NN
replace_obj_status	int4			NN
cachehit_name	char(40)			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_external_query_detail_base

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
pid	int4			NN
xid	int8			NN
segment_id	int4			NN
node	int4			NN
slice	int4			NN
table_name	char(256)			NN
sourcetype	char(32)			NN
eventtime	int8			NN
starttime	int8			NN
endtime	int8			NN
duration	int8			NN
total_partitions	int4			NN
qualified_partitions	int4			NN
total_files	int4			NN
files_scanned	int4			NN
num_rows	int8			NN
num_bytes	int8			NN
file_format	char(16)			NN
location	char(256)			NN
pg_query_text	char(4000)			NN
logging_tag	char(32)			NN
warning_message	char(4000)			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
user_id	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
pid	int4			NN
xid	int8			NN
segment_id	int4			NN
node	int4			NN
slice	int4			NN
table_name	char(256)			NN
sourcetype	char(32)			NN
eventtime	int8			NN
starttime	int8			NN
endtime	int8			NN
duration	int8			NN
total_partitions	int4			NN
qualified_partitions	int4			NN
total_files	int4			NN
files_scanned	int4			NN
num_rows	int8			NN
num_bytes	int8			NN
file_format	char(16)			NN
location	char(256)			NN
pg_query_text	char(4000)			NN
logging_tag	char(32)			NN
warning_message	char(4000)			NN
is_recursive	char(1)			NN
is_nested	char(1)			NN
s3list_time	int8			NN
get_partition_time	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.stcs_incremental_resize_state

old
column	data type	PK	U	NN
resizeid	char(128)			NN
starttime	int8			NN
resizephase	char(32)			NN
resizeplanstate	char(32)			NN
nodenum	int4			NN
globalslicenum	int4			NN
localslicenum	int4			NN
datablocks	int4			NN
metadatablocks	int4			NN
distallblocks	int4			NN
metachainblocks	int4			NN
blockchainmetachainblocks	int4			NN
leadersnapshotblocks	int4			NN
pgwalblocks	int4			NN
rows	int8			NN
distallrows	int8			NN
persist_temp_tables_state	char(100)			NN
temp_blocks	int4			NN
temp_distall_blocks	int4			NN
temp_rows	int8			NN
temp_distall_rows	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
resizeid	char(128)			NN
starttime	int8			NN
resizephase	char(32)			NN
resizeplanstate	char(32)			NN
nodenum	int4			NN
globalslicenum	int4			NN
localslicenum	int4			NN
datablocks	int4			NN
metadatablocks	int4			NN
distallblocks	int4			NN
metachainblocks	int4			NN
blockchainmetachainblocks	int4			NN
leadersnapshotblocks	int4			NN
pgwalblocks	int4			NN
rows	int8			NN
distallrows	int8			NN
persist_temp_tables_state	char(100)			NN
temp_blocks	int4			NN
temp_distall_blocks	int4			NN
temp_rows	int8			NN
temp_distall_rows	int8			NN
src_nodenum	int4			NN
src_localslicenum	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_insert

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
tbl	int4			NN
inserted_mega_value	char(1)			NN
use_staging_table	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
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
tbl	int4			NN
inserted_mega_value	char(1)			NN
use_staging_table	char(1)			NN
write_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

pg_catalog.stcs_load_history_base

old
column	data type	PK	U	NN
user_id	int4			NN
db	char(64)			NN
xid	int8			NN
pid	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
status	int4			NN
table_name	char(128)			NN
event_time	int8			NN
slice	int4			NN
filename	char(256)			NN
file_count	int4			NN
file_bytes	int8			NN
file_count_scanned	int4			NN
file_bytes_scanned	int8			NN
bytes_copied	int8			NN
rows_copied	int8			NN
file_format	char(16)			NN
error_count	int4			NN
data_source	char(256)			NN
copy_job_id	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
user_id	int4			NN
db	char(64)			NN
xid	int8			NN
pid	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
status	int4			NN
table_name	char(128)			NN
event_time	int8			NN
slice	int4			NN
filename	char(256)			NN
file_count	int4			NN
file_bytes	int8			NN
file_count_scanned	int4			NN
file_bytes_scanned	int8			NN
bytes_copied	int8			NN
rows_copied	int8			NN
file_format	char(16)			NN
error_count	int4			NN
data_source	char(256)			NN
copy_job_id	int8			NN
start_offset	int8			NN
bytes_scanned	int8			NN
lines_scanned	int8			NN
start_time	int8			NN
end_time	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.stcs_lwlock

old
column	data type	PK	U	NN
log_time	int8			NN
pid	int4			NN
lwlockid	int4			NN
lwlock_name	char(50)			NN
mode	char(25)			NN
acquire_wait_us	int8			NN
spinlock_max_wait_us	int8			NN
num_spinlock_waits	int8			NN
hold_time_us	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
log_time	int8			NN
pid	int4			NN
lwlockid	int4			NN
lwlock_name	char(50)			NN
mode	char(25)			NN
acquire_wait_us	int8			NN
spinlock_max_wait_us	int8			NN
num_spinlock_waits	int8			NN
hold_time_us	int8			NN
blocked_by	int8			NN
queue_depth	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.stcs_omnisql_rewrite_rules

old
column	data type	PK	U	NN
query	int8			NN
rule	char(50)			NN
count	int4			NN
time	int8			NN
type	int4			NN
module	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
query	int8			NN
rule	char(50)			NN
count	int4			NN
time	int8			NN
type	int4			NN
module	int4			NN
file	char(80)			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_plan_state

old
column	data type	PK	U	NN
query	int8			NN
component	char(32)			NN
state	char(15)			NN
detail	char(100)			NN
label	char(320)			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	int8			NN
component	char(32)			NN
state	char(15)			NN
detail	char(100)			NN
label	char(320)			NN
xid	int8			NN
vpid	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_predicate_information

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
segment	int4			NN
step	int4			NN
node_id	int4			NN
parent_node_id	int4			NN
expr_datatype	int4			NN
expr_name	char(64)			NN
expr_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
userid	int4			NN
query	int4			NN
segment	int4			NN
step	int4			NN
node_id	int4			NN
parent_node_id	int4			NN
expr_datatype	int4			NN
expr_name	char(64)			NN
expr_id	int4			NN
rrscan_status	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.stcs_s3commit_stats

old
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
start_time	int8			NN
end_time	int8			NN
s3_write_untagged_latency	int8			NN
s3_write_add_tag_latency	int8			NN
s3_write_delete_tag_latency	int8			NN
num_untagged_s3_writes	int8			NN
num_add_tags_issued_to_s3	int8			NN
num_delete_tags_issued_to_s3	int8			NN
dynamo_write_avg_latency_usec	int8			NN
synced_commits_to_s3	int4			NN
s3commit_enable_latency	int8			NN
s3commit_disable_latency	int8			NN
dynamo_get_avg_latency_usec	int8			NN
num_tossed_guids	int8			NN
num_tombstoned_guids	int8			NN
num_untagged_untracked	int8			NN
num_tossed_tagless_s3_writes	int8			NN
num_tossed_in_writes1	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
xid	int8			NN
node	int4			NN
start_time	int8			NN
end_time	int8			NN
s3_write_untagged_latency	int8			NN
s3_write_add_tag_latency	int8			NN
s3_write_delete_tag_latency	int8			NN
num_untagged_s3_writes	int8			NN
num_add_tags_issued_to_s3	int8			NN
num_delete_tags_issued_to_s3	int8			NN
dynamo_write_avg_latency_usec	int8			NN
synced_commits_to_s3	int4			NN
s3commit_enable_latency	int8			NN
s3commit_disable_latency	int8			NN
dynamo_get_avg_latency_usec	int8			NN
num_tossed_guids	int8			NN
num_tombstoned_guids	int8			NN
num_untagged_untracked	int8			NN
num_tossed_tagless_s3_writes	int8			NN
num_tossed_in_writes1	int8			NN
num_non_persistent_tagless_blocks	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.stcs_tbl_perm_at_drop

old
column	data type	PK	U	NN
table_id	int4			NN
node	int4			NN
num_blocks	int4			NN
dist_style	int4			NN
temp	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
table_id	int4			NN
node	int4			NN
num_blocks	int4			NN
dist_style	int4			NN
temp	int4			NN
eventtime	int8			NN
xid	int8			NN
name	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

pg_catalog.stcs_user_query_map

old
column	data type	PK	U	NN
user_id	int4			NN
user_query_id	int8			NN
rewritten_query_id	int8			NN
transaction_id	int8			NN
process_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
user_id	int4			NN
user_query_id	int8			NN
rewritten_query_id	int8			NN
transaction_id	int8			NN
process_id	int4			NN
child_query_sequence	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_xrestore

old
column	data type	PK	U	NN
backup_id	char(256)			NN
node	int4			NN
catalog_download_start_time	int8			NN
catalog_download_end_time	int8			NN
slice_transfer_start_time	int8			NN
slice_transfer_end_time	int8			NN
guid_pool_hit_rate	float8			NN
num_guids_created_on_demand	int4			NN
node_occ_mean	float8			NN
node_occ_variance	float8			NN
data_skew_cluster	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
backup_id	char(256)			NN
node	int4			NN
catalog_download_start_time	int8			NN
catalog_download_end_time	int8			NN
slice_transfer_start_time	int8			NN
slice_transfer_end_time	int8			NN
guid_pool_hit_rate	float8			NN
num_guids_created_on_demand	int4			NN
node_occ_mean	float8			NN
node_occ_variance	float8			NN
data_skew_cluster	float8			NN
xrestore_type	int4			NN
xrestore_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

pg_catalog.stll_analyze

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
database	char(30)			NN
table_id	int4			NN
status	char(15)			NN
rows	float8			NN
modified_rows	float8			NN
threshold_percent	float8			NN
is_auto	char(1)			NN
starttime	timestamp			NN
endtime	timestamp			NN
prevtime	timestamp			NN
num_predicate_cols	int4			NN
num_new_predicate_cols	int4			NN
is_background	char(1)			NN
auto_analyze_phase	char(100)			NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
database	char(30)			NN
table_id	int4			NN
status	char(15)			NN
rows	float8			NN
modified_rows	float8			NN
threshold_percent	float8			NN
is_auto	char(1)			NN
starttime	timestamp			NN
endtime	timestamp			NN
prevtime	timestamp			NN
num_predicate_cols	int4			NN
num_new_predicate_cols	int4			NN
is_background	char(1)			NN
auto_analyze_phase	char(100)			NN
schema_name	char(128)			NN
table_name	char(136)			NN

pg_catalog.stll_analyze_compression

old
column	data type	PK	U	NN
userid	int4			NN
start_time	timestamp			NN
xid	int8			NN
tbl	int4			NN
tablename	char(128)			NN
col	int4			NN
old_encoding	char(15)			NN
new_encoding	char(15)			NN
mode	char(14)			NN

new
column	data type	PK	U	NN
userid	int4			NN
start_time	timestamp			NN
xid	int8			NN
tbl	int4			NN
tablename	char(128)			NN
col	int4			NN
old_encoding	char(15)			NN
new_encoding	char(15)			NN
mode	char(14)			NN
best_compression_encoding	char(15)			NN
recommended_bytes	int8			NN
best_compression_bytes	int8			NN
ndv	int8			NN

pg_catalog.stll_arcadia_billing_ris_reports

old
column	data type	PK	U	NN
request_id	char(100)			NN
billing_time	char(100)			NN
usage_rpu_sec	int4			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
is_burst	int4			NN
cluster_arn	char(128)			NN
usage_sec	int4			NN
usage_sec_before_minimum	int4			NN
cluster_rpus	int4			NN
report_time	timestamp			NN
interval_starttime	timestamp			NN
interval_endtime	timestamp			NN

new
column	data type	PK	U	NN
request_id	char(100)			NN
billing_time	char(100)			NN
usage_rpu_sec	int4			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
is_burst	int4			NN
cluster_arn	char(128)			NN
usage_sec	int4			NN
usage_sec_before_minimum	int4			NN
interval_billed_starttime	timestamp			NN
interval_billed_endtime	timestamp			NN
cluster_rpus	int4			NN
report_time	timestamp			NN
interval_starttime	timestamp			NN
interval_endtime	timestamp			NN
resv_model	int4			NN

pg_catalog.stll_arcadia_concurrency_scaling_usage

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
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN
is_cs_at_query	int4			NN

new
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
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN
is_cs_at_query	int4			NN
is_multi_az_secondary	int4			NN
resv_model	int4			NN

pg_catalog.stll_arcadia_main_usage

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
xid	int8			NN
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
xid	int8			NN
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN
resv_model	int4			NN

pg_catalog.stll_bkg_compile_info

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
segment	int4			NN
locus	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
bytes	int8			NN
path	char(255)			NN
compile	int4			NN
complevel	int4			NN
cachehit	int4			NN
tokwaittime	int8			NN
compilestarttime	timestamp			NN
compileendtime	timestamp			NN
compilelocktime	int8			NN
compilememory	int8			NN
putsuccess	int4			NN
getsuccess	int4			NN
puttime	int8			NN
gettime	int8			NN
objsize	int8			NN
skip_opt_compile	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
segment	int4			NN
locus	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
bytes	int8			NN
path	char(255)			NN
compile	int4			NN
complevel	int4			NN
cachehit	int4			NN
tokwaittime	int8			NN
compilestarttime	timestamp			NN
compileendtime	timestamp			NN
compilelocktime	int8			NN
compilememory	int8			NN
putsuccess	int4			NN
getsuccess	int4			NN
puttime	int8			NN
gettime	int8			NN
objsize	int8			NN
skip_opt_compile	int4			NN
cachehit_name	char(40)			NN

pg_catalog.stll_burst_refresh

old
column	data type	PK	U	NN
record_time	timestamp			NN
node	int4			NN
process	char(32)			NN
pid	int4			NN
error_code	int4			NN
message	char(1024)			NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
node	int4			NN
process	char(32)			NN
pid	int4			NN
error_code	int4			NN
message	char(1024)			NN
thread_id	char(32)			NN

pg_catalog.stll_catalog_bufmgr_stats

old
column	data type	PK	U	NN
logtime	timestamp			NN
period_start	timestamp			NN
read_buffer	int8			NN
hits	int8			NN
free_buffers_found	int8			NN
evictions	int8			NN
dirty_evictions	int8			NN
contentions_on_eviction	int8			NN

new
column	data type	PK	U	NN
logtime	timestamp			NN
period_start	timestamp			NN
read_buffer	int8			NN
hits	int8			NN
free_buffers_found	int8			NN
evictions	int8			NN
dirty_evictions	int8			NN
contentions_on_eviction	int8			NN
pid	int8			NN

pg_catalog.stll_compile_info

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
segment	int4			NN
locus	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
bytes	int8			NN
path	char(255)			NN
compile	int4			NN
complevel	int4			NN
cachehit	int4			NN
tokwaittime	int8			NN
compilestarttime	timestamp			NN
compileendtime	timestamp			NN
compilelocktime	int8			NN
compilememory	int8			NN
getsuccess	int4			NN
gettime	int8			NN
objsize	int8			NN
skip_opt_compile	int4			NN
replace_obj_status	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
segment	int4			NN
locus	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
bytes	int8			NN
path	char(255)			NN
compile	int4			NN
complevel	int4			NN
cachehit	int4			NN
tokwaittime	int8			NN
compilestarttime	timestamp			NN
compileendtime	timestamp			NN
compilelocktime	int8			NN
compilememory	int8			NN
getsuccess	int4			NN
gettime	int8			NN
objsize	int8			NN
skip_opt_compile	int4			NN
replace_obj_status	int4			NN
cachehit_name	char(40)			NN

pg_catalog.stll_external_query_detail_base

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
pid	int4			NN
xid	int8			NN
segment_id	int4			NN
node	int4			NN
slice	int4			NN
table_name	char(256)			NN
sourcetype	char(32)			NN
eventtime	timestamp			NN
starttime	timestamp			NN
endtime	timestamp			NN
duration	int8			NN
total_partitions	int4			NN
qualified_partitions	int4			NN
total_files	int4			NN
files_scanned	int4			NN
num_rows	int8			NN
num_bytes	int8			NN
file_format	char(16)			NN
location	char(256)			NN
pg_query_text	char(4000)			NN
logging_tag	char(32)			NN
warning_message	char(4000)			NN

new
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
pid	int4			NN
xid	int8			NN
segment_id	int4			NN
node	int4			NN
slice	int4			NN
table_name	char(256)			NN
sourcetype	char(32)			NN
eventtime	timestamp			NN
starttime	timestamp			NN
endtime	timestamp			NN
duration	int8			NN
total_partitions	int4			NN
qualified_partitions	int4			NN
total_files	int4			NN
files_scanned	int4			NN
num_rows	int8			NN
num_bytes	int8			NN
file_format	char(16)			NN
location	char(256)			NN
pg_query_text	char(4000)			NN
logging_tag	char(32)			NN
warning_message	char(4000)			NN
is_recursive	char(1)			NN
is_nested	char(1)			NN
s3list_time	int8			NN
get_partition_time	int8			NN

pg_catalog.stll_incremental_resize_state

old
column	data type	PK	U	NN
resizeid	char(128)			NN
starttime	timestamp			NN
resizephase	char(32)			NN
resizeplanstate	char(32)			NN
nodenum	int4			NN
globalslicenum	int4			NN
localslicenum	int4			NN
datablocks	int4			NN
metadatablocks	int4			NN
distallblocks	int4			NN
metachainblocks	int4			NN
blockchainmetachainblocks	int4			NN
leadersnapshotblocks	int4			NN
pgwalblocks	int4			NN
rows	int8			NN
distallrows	int8			NN
persist_temp_tables_state	char(100)			NN
temp_blocks	int4			NN
temp_distall_blocks	int4			NN
temp_rows	int8			NN
temp_distall_rows	int8			NN

new
column	data type	PK	U	NN
resizeid	char(128)			NN
starttime	timestamp			NN
resizephase	char(32)			NN
resizeplanstate	char(32)			NN
nodenum	int4			NN
globalslicenum	int4			NN
localslicenum	int4			NN
datablocks	int4			NN
metadatablocks	int4			NN
distallblocks	int4			NN
metachainblocks	int4			NN
blockchainmetachainblocks	int4			NN
leadersnapshotblocks	int4			NN
pgwalblocks	int4			NN
rows	int8			NN
distallrows	int8			NN
persist_temp_tables_state	char(100)			NN
temp_blocks	int4			NN
temp_distall_blocks	int4			NN
temp_rows	int8			NN
temp_distall_rows	int8			NN
src_nodenum	int4			NN
src_localslicenum	int4			NN

pg_catalog.stll_insert

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
tbl	int4			NN
inserted_mega_value	char(1)			NN
use_staging_table	char(1)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
tbl	int4			NN
inserted_mega_value	char(1)			NN
use_staging_table	char(1)			NN
write_xid	int8			NN

pg_catalog.stll_load_history_base

old
column	data type	PK	U	NN
user_id	int4			NN
db	char(64)			NN
xid	int8			NN
pid	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
status	int4			NN
table_name	char(128)			NN
event_time	timestamp			NN
slice	int4			NN
filename	char(256)			NN
file_count	int4			NN
file_bytes	int8			NN
file_count_scanned	int4			NN
file_bytes_scanned	int8			NN
bytes_copied	int8			NN
rows_copied	int8			NN
file_format	char(16)			NN
error_count	int4			NN
data_source	char(256)			NN
copy_job_id	int8			NN

new
column	data type	PK	U	NN
user_id	int4			NN
db	char(64)			NN
xid	int8			NN
pid	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
status	int4			NN
table_name	char(128)			NN
event_time	timestamp			NN
slice	int4			NN
filename	char(256)			NN
file_count	int4			NN
file_bytes	int8			NN
file_count_scanned	int4			NN
file_bytes_scanned	int8			NN
bytes_copied	int8			NN
rows_copied	int8			NN
file_format	char(16)			NN
error_count	int4			NN
data_source	char(256)			NN
copy_job_id	int8			NN
start_offset	int8			NN
bytes_scanned	int8			NN
lines_scanned	int8			NN
start_time	timestamp			NN
end_time	timestamp			NN

pg_catalog.stll_lwlock

old
column	data type	PK	U	NN
log_time	timestamp			NN
pid	int4			NN
lwlockid	int4			NN
lwlock_name	char(50)			NN
mode	char(25)			NN
acquire_wait_us	int8			NN
spinlock_max_wait_us	int8			NN
num_spinlock_waits	int8			NN
hold_time_us	int8			NN

new
column	data type	PK	U	NN
log_time	timestamp			NN
pid	int4			NN
lwlockid	int4			NN
lwlock_name	char(50)			NN
mode	char(25)			NN
acquire_wait_us	int8			NN
spinlock_max_wait_us	int8			NN
num_spinlock_waits	int8			NN
hold_time_us	int8			NN
blocked_by	int8			NN
queue_depth	int8			NN

pg_catalog.stll_omnisql_rewrite_rules

old
column	data type	PK	U	NN
query	int8			NN
rule	char(50)			NN
count	int4			NN
time	int8			NN
type	int4			NN
module	int4			NN

new
column	data type	PK	U	NN
query	int8			NN
rule	char(50)			NN
count	int4			NN
time	int8			NN
type	int4			NN
module	int4			NN
file	char(80)			NN

pg_catalog.stll_plan_state

old
column	data type	PK	U	NN
query	int8			NN
component	char(32)			NN
state	char(15)			NN
detail	char(100)			NN
label	char(320)			NN

new
column	data type	PK	U	NN
query	int8			NN
component	char(32)			NN
state	char(15)			NN
detail	char(100)			NN
label	char(320)			NN
xid	int8			NN
vpid	int4			NN

pg_catalog.stll_predicate_information

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
segment	int4			NN
step	int4			NN
node_id	int4			NN
parent_node_id	int4			NN
expr_datatype	int4			NN
expr_name	char(64)			NN
expr_id	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
segment	int4			NN
step	int4			NN
node_id	int4			NN
parent_node_id	int4			NN
expr_datatype	int4			NN
expr_name	char(64)			NN
expr_id	int4			NN
rrscan_status	int8			NN

pg_catalog.stll_s3commit_stats

old
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
start_time	timestamp			NN
end_time	timestamp			NN
s3_write_untagged_latency	int8			NN
s3_write_add_tag_latency	int8			NN
s3_write_delete_tag_latency	int8			NN
num_untagged_s3_writes	int8			NN
num_add_tags_issued_to_s3	int8			NN
num_delete_tags_issued_to_s3	int8			NN
dynamo_write_avg_latency_usec	int8			NN
synced_commits_to_s3	int4			NN
s3commit_enable_latency	int8			NN
s3commit_disable_latency	int8			NN
dynamo_get_avg_latency_usec	int8			NN
num_tossed_guids	int8			NN
num_tombstoned_guids	int8			NN
num_untagged_untracked	int8			NN
num_tossed_tagless_s3_writes	int8			NN
num_tossed_in_writes1	int8			NN

new
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
start_time	timestamp			NN
end_time	timestamp			NN
s3_write_untagged_latency	int8			NN
s3_write_add_tag_latency	int8			NN
s3_write_delete_tag_latency	int8			NN
num_untagged_s3_writes	int8			NN
num_add_tags_issued_to_s3	int8			NN
num_delete_tags_issued_to_s3	int8			NN
dynamo_write_avg_latency_usec	int8			NN
synced_commits_to_s3	int4			NN
s3commit_enable_latency	int8			NN
s3commit_disable_latency	int8			NN
dynamo_get_avg_latency_usec	int8			NN
num_tossed_guids	int8			NN
num_tombstoned_guids	int8			NN
num_untagged_untracked	int8			NN
num_tossed_tagless_s3_writes	int8			NN
num_tossed_in_writes1	int8			NN
num_non_persistent_tagless_blocks	int8			NN

pg_catalog.stll_tbl_perm_at_drop

old
column	data type	PK	U	NN
table_id	int4			NN
node	int4			NN
num_blocks	int4			NN
dist_style	int4			NN
temp	int4			NN

new
column	data type	PK	U	NN
table_id	int4			NN
node	int4			NN
num_blocks	int4			NN
dist_style	int4			NN
temp	int4			NN
eventtime	timestamp			NN
xid	int8			NN
name	char(128)			NN

pg_catalog.stll_user_query_map

old
column	data type	PK	U	NN
user_id	int4			NN
user_query_id	int8			NN
rewritten_query_id	int8			NN
transaction_id	int8			NN
process_id	int4			NN

new
column	data type	PK	U	NN
user_id	int4			NN
user_query_id	int8			NN
rewritten_query_id	int8			NN
transaction_id	int8			NN
process_id	int4			NN
child_query_sequence	int4			NN

pg_catalog.stll_xrestore

old
column	data type	PK	U	NN
backup_id	char(256)			NN
node	int4			NN
catalog_download_start_time	timestamp			NN
catalog_download_end_time	timestamp			NN
slice_transfer_start_time	timestamp			NN
slice_transfer_end_time	timestamp			NN
guid_pool_hit_rate	float8			NN
num_guids_created_on_demand	int4			NN
node_occ_mean	float8			NN
node_occ_variance	float8			NN
data_skew_cluster	float8			NN

new
column	data type	PK	U	NN
backup_id	char(256)			NN
node	int4			NN
catalog_download_start_time	timestamp			NN
catalog_download_end_time	timestamp			NN
slice_transfer_start_time	timestamp			NN
slice_transfer_end_time	timestamp			NN
guid_pool_hit_rate	float8			NN
num_guids_created_on_demand	int4			NN
node_occ_mean	float8			NN
node_occ_variance	float8			NN
data_skew_cluster	float8			NN
xrestore_type	int4			NN
xrestore_source	int4			NN

pg_catalog.stv_integration

old
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
database_name	char(128)			NN
synced_log_coordinate	char(128)			NN
lag_ms	int8			NN
total_tables_replicated	int4			NN
total_tables_failed	int4			NN
source_state	char(128)			NN
source_error_reason	char(128)			NN
resync_state	char(128)			NN
delay_ms	int8			NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
database_name	char(128)			NN
synced_log_coordinate	char(128)			NN
lag_ms	int8			NN
total_tables_replicated	int4			NN
total_tables_failed	int4			NN
source_state	char(128)			NN
source_error_reason	char(128)			NN
resync_state	char(128)			NN
delay_ms	int8			NN
creation_time	timestamp			NN

pg_catalog.stv_sessions

old
column	data type	PK	U	NN
starttime	timestamp			NN
process	int4			NN
user_name	char(50)			NN
db_name	char(50)			NN
timeout_sec	int4			NN

new
column	data type	PK	U	NN
starttime	timestamp			NN
process	int4			NN
user_name	char(50)			NN
db_name	char(50)			NN
timeout_sec	int4			NN
user_id	int4			NN

pg_catalog.stcs_volt_tt_sizes

old
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

new
column	data type	PK	U	NN

pg_catalog.stll_volt_tt_sizes

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

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_37390414

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_arcadia_billing_burstq_tracking

old
column	data type

new
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

pg_catalog.stl_arcadia_billing_txn_tracking

old
column	data type

new
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

pg_catalog.stl_burst_max_rpus

old
column	data type

new
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

pg_catalog.stl_cluster_idleness

old
column	data type

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

pg_catalog.stl_comm_pkt_size

old
column	data type

new
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

pg_catalog.stl_conjunct_scan_metrics

old
column	data type

new
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

pg_catalog.stl_filter

old
column	data type

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

pg_catalog.stl_restore_slice_mapping

old
column	data type

new
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

pg_catalog.stl_s3table_stats

old
column	data type

new
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

pg_catalog.stl_shadow_table_recovery

old
column	data type

new
column	data type
recordtime	timestamp
db_id	int4
tbl_id	int4

pg_catalog.stl_transaction_history

old
column	data type

new
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

pg_catalog.stl_unified_vec_scan

old
column	data type

new
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

pg_catalog.svv_redshift_schema_quota

old
column	data type

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

pg_catalog.svv_tables_space_usage

old
column	data type

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

pg_catalog.sys_analyze_compression_history

old
column	data type

new
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)

pg_catalog.sys_analyze_history

old
column	data type

new
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

pg_catalog.sys_datashare_cross_region_usage

old
column	data type

new
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)

pg_catalog.sys_integration_table_state_change

old
column	data type

new
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

pg_catalog.sys_procedure_call

old
column	data type

new
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

pg_catalog.sys_procedure_messages

old
column	data type

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

pg_catalog.sys_session_history

old
column	data type

new
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

pg_catalog.sys_transaction_history

old
column	data type

new
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

pg_catalog.sys_udf_log

old
column	data type

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

pg_catalog.stl_analyze

old
column	data type
userid	int4
xid	int8
database	char(30)
table_id	int4
status	char(15)
rows	float8
modified_rows	float8
threshold_percent	float8
is_auto	char(1)
starttime	timestamp
endtime	timestamp
prevtime	timestamp
num_predicate_cols	int4
num_new_predicate_cols	int4
is_background	char(1)
auto_analyze_phase	char(100)

new
column	data type
userid	int4
xid	int8
database	char(30)
table_id	int4
status	char(15)
rows	float8
modified_rows	float8
threshold_percent	float8
is_auto	char(1)
starttime	timestamp
endtime	timestamp
prevtime	timestamp
num_predicate_cols	int4
num_new_predicate_cols	int4
is_background	char(1)
auto_analyze_phase	char(100)
schema_name	char(128)
table_name	char(136)

pg_catalog.stl_analyze_compression

old
column	data type
userid	int4
start_time	timestamp
xid	int8
tbl	int4
tablename	char(128)
col	int4
old_encoding	char(15)
new_encoding	char(15)
mode	char(14)

new
column	data type
userid	int4
start_time	timestamp
xid	int8
tbl	int4
tablename	char(128)
col	int4
old_encoding	char(15)
new_encoding	char(15)
mode	char(14)
best_compression_encoding	char(15)
recommended_bytes	int8
best_compression_bytes	int8
ndv	int8

pg_catalog.stl_arcadia_billing_ris_reports

old
column	data type
request_id	char(100)
billing_time	char(100)
usage_rpu_sec	int4
report_arn	char(128)
instance_type	char(128)
num_nodes	int4
is_burst	int4
cluster_arn	char(128)
usage_sec	int4
usage_sec_before_minimum	int4
cluster_rpus	int4
report_time	timestamp
interval_starttime	timestamp
interval_endtime	timestamp

new
column	data type
request_id	char(100)
billing_time	char(100)
usage_rpu_sec	int4
report_arn	char(128)
instance_type	char(128)
num_nodes	int4
is_burst	int4
cluster_arn	char(128)
usage_sec	int4
usage_sec_before_minimum	int4
interval_billed_starttime	timestamp
interval_billed_endtime	timestamp
cluster_rpus	int4
report_time	timestamp
interval_starttime	timestamp
interval_endtime	timestamp
resv_model	int4

pg_catalog.stl_arcadia_concurrency_scaling_usage

old
column	data type
userid	int4
recordtime	timestamp
rewritten_qid	int4
user_query_id	int8
child_query_seq	int4
cluster	char(128)
report_arn	char(128)
instance_type	char(128)
num_nodes	int4
starttime	timestamp
endtime	timestamp
request_id	char(36)
incurred_usage_ms	int4
incurred_usage_rpu_ms	int4
rpu	int4
is_cs_at_query	int4

new
column	data type
userid	int4
recordtime	timestamp
rewritten_qid	int4
user_query_id	int8
child_query_seq	int4
cluster	char(128)
report_arn	char(128)
instance_type	char(128)
num_nodes	int4
starttime	timestamp
endtime	timestamp
request_id	char(36)
incurred_usage_ms	int4
incurred_usage_rpu_ms	int4
rpu	int4
is_cs_at_query	int4
is_multi_az_secondary	int4
resv_model	int4

pg_catalog.stl_arcadia_main_usage

old
column	data type
userid	int4
recordtime	timestamp
xid	int8
cluster	char(128)
report_arn	char(128)
instance_type	char(128)
num_nodes	int4
starttime	timestamp
endtime	timestamp
request_id	char(36)
incurred_usage_ms	int4
incurred_usage_rpu_ms	int4
rpu	int4

new
column	data type
userid	int4
recordtime	timestamp
xid	int8
cluster	char(128)
report_arn	char(128)
instance_type	char(128)
num_nodes	int4
starttime	timestamp
endtime	timestamp
request_id	char(36)
incurred_usage_ms	int4
incurred_usage_rpu_ms	int4
rpu	int4
resv_model	int4

pg_catalog.stl_bkg_compile_info

old
column	data type
userid	int4
xid	int8
pid	int4
query	int4
segment	int4
locus	int4
starttime	timestamp
endtime	timestamp
bytes	int8
path	char(255)
compile	int4
complevel	int4
cachehit	int4
tokwaittime	int8
compilestarttime	timestamp
compileendtime	timestamp
compilelocktime	int8
compilememory	int8
putsuccess	int4
getsuccess	int4
puttime	int8
gettime	int8
objsize	int8
skip_opt_compile	int4

new
column	data type
userid	int4
xid	int8
pid	int4
query	int4
segment	int4
locus	int4
starttime	timestamp
endtime	timestamp
bytes	int8
path	char(255)
compile	int4
complevel	int4
cachehit	int4
tokwaittime	int8
compilestarttime	timestamp
compileendtime	timestamp
compilelocktime	int8
compilememory	int8
putsuccess	int4
getsuccess	int4
puttime	int8
gettime	int8
objsize	int8
skip_opt_compile	int4
cachehit_name	char(40)

pg_catalog.stl_burst_refresh

old
column	data type
record_time	timestamp
node	int4
process	char(32)
pid	int4
error_code	int4
message	char(1024)

new
column	data type
record_time	timestamp
node	int4
process	char(32)
pid	int4
error_code	int4
message	char(1024)
thread_id	char(32)

pg_catalog.stl_catalog_bufmgr_stats

old
column	data type
logtime	timestamp
period_start	timestamp
read_buffer	int8
hits	int8
free_buffers_found	int8
evictions	int8
dirty_evictions	int8
contentions_on_eviction	int8

new
column	data type
logtime	timestamp
period_start	timestamp
read_buffer	int8
hits	int8
free_buffers_found	int8
evictions	int8
dirty_evictions	int8
contentions_on_eviction	int8
pid	int8

pg_catalog.stl_compile_info

old
column	data type
userid	int4
xid	int8
pid	int4
query	int4
segment	int4
locus	int4
starttime	timestamp
endtime	timestamp
bytes	int8
path	char(255)
compile	int4
complevel	int4
cachehit	int4
tokwaittime	int8
compilestarttime	timestamp
compileendtime	timestamp
compilelocktime	int8
compilememory	int8
getsuccess	int4
gettime	int8
objsize	int8
skip_opt_compile	int4
replace_obj_status	int4

new
column	data type
userid	int4
xid	int8
pid	int4
query	int4
segment	int4
locus	int4
starttime	timestamp
endtime	timestamp
bytes	int8
path	char(255)
compile	int4
complevel	int4
cachehit	int4
tokwaittime	int8
compilestarttime	timestamp
compileendtime	timestamp
compilelocktime	int8
compilememory	int8
getsuccess	int4
gettime	int8
objsize	int8
skip_opt_compile	int4
replace_obj_status	int4
cachehit_name	char(40)

pg_catalog.stl_external_query_detail_base

old
column	data type
user_id	int4
query_id	int8
child_query_sequence	int4
child_query_id	int4
pid	int4
xid	int8
segment_id	int4
node	int4
slice	int4
table_name	char(256)
sourcetype	char(32)
eventtime	timestamp
starttime	timestamp
endtime	timestamp
duration	int8
total_partitions	int4
qualified_partitions	int4
total_files	int4
files_scanned	int4
num_rows	int8
num_bytes	int8
file_format	char(16)
location	char(256)
pg_query_text	char(4000)
logging_tag	char(32)
warning_message	char(4000)

new
column	data type
user_id	int4
query_id	int8
child_query_sequence	int4
child_query_id	int4
pid	int4
xid	int8
segment_id	int4
node	int4
slice	int4
table_name	char(256)
sourcetype	char(32)
eventtime	timestamp
starttime	timestamp
endtime	timestamp
duration	int8
total_partitions	int4
qualified_partitions	int4
total_files	int4
files_scanned	int4
num_rows	int8
num_bytes	int8
file_format	char(16)
location	char(256)
pg_query_text	char(4000)
logging_tag	char(32)
warning_message	char(4000)
is_recursive	char(1)
is_nested	char(1)
s3list_time	int8
get_partition_time	int8

pg_catalog.stl_incremental_resize_state

old
column	data type
resizeid	char(128)
starttime	timestamp
resizephase	char(32)
resizeplanstate	char(32)
nodenum	int4
globalslicenum	int4
localslicenum	int4
datablocks	int4
metadatablocks	int4
distallblocks	int4
metachainblocks	int4
blockchainmetachainblocks	int4
leadersnapshotblocks	int4
pgwalblocks	int4
rows	int8
distallrows	int8
persist_temp_tables_state	char(100)
temp_blocks	int4
temp_distall_blocks	int4
temp_rows	int8
temp_distall_rows	int8

new
column	data type
resizeid	char(128)
starttime	timestamp
resizephase	char(32)
resizeplanstate	char(32)
nodenum	int4
globalslicenum	int4
localslicenum	int4
datablocks	int4
metadatablocks	int4
distallblocks	int4
metachainblocks	int4
blockchainmetachainblocks	int4
leadersnapshotblocks	int4
pgwalblocks	int4
rows	int8
distallrows	int8
persist_temp_tables_state	char(100)
temp_blocks	int4
temp_distall_blocks	int4
temp_rows	int8
temp_distall_rows	int8
src_nodenum	int4
src_localslicenum	int4

pg_catalog.stl_insert

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
tbl	int4
inserted_mega_value	char(1)
use_staging_table	char(1)

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
tbl	int4
inserted_mega_value	char(1)
use_staging_table	char(1)
write_xid	int8

pg_catalog.stl_load_history_base

old
column	data type
user_id	int4
db	char(64)
xid	int8
pid	int4
query_id	int8
child_query_sequence	int4
child_query_id	int4
status	int4
table_name	char(128)
event_time	timestamp
slice	int4
filename	char(256)
file_count	int4
file_bytes	int8
file_count_scanned	int4
file_bytes_scanned	int8
bytes_copied	int8
rows_copied	int8
file_format	char(16)
error_count	int4
data_source	char(256)
copy_job_id	int8

new
column	data type
user_id	int4
db	char(64)
xid	int8
pid	int4
query_id	int8
child_query_sequence	int4
child_query_id	int4
status	int4
table_name	char(128)
event_time	timestamp
slice	int4
filename	char(256)
file_count	int4
file_bytes	int8
file_count_scanned	int4
file_bytes_scanned	int8
bytes_copied	int8
rows_copied	int8
file_format	char(16)
error_count	int4
data_source	char(256)
copy_job_id	int8
start_offset	int8
bytes_scanned	int8
lines_scanned	int8
start_time	timestamp
end_time	timestamp

pg_catalog.stl_lwlock

old
column	data type
log_time	timestamp
pid	int4
lwlockid	int4
lwlock_name	char(50)
mode	char(25)
acquire_wait_us	int8
spinlock_max_wait_us	int8
num_spinlock_waits	int8
hold_time_us	int8

new
column	data type
log_time	timestamp
pid	int4
lwlockid	int4
lwlock_name	char(50)
mode	char(25)
acquire_wait_us	int8
spinlock_max_wait_us	int8
num_spinlock_waits	int8
hold_time_us	int8
blocked_by	int8
queue_depth	int8

pg_catalog.stl_omnisql_rewrite_rules

old
column	data type
query	int8
rule	char(50)
count	int4
time	int8
type	int4
module	int4

new
column	data type
query	int8
rule	char(50)
count	int4
time	int8
type	int4
module	int4
file	char(80)

pg_catalog.stl_plan_state

old
column	data type
query	int8
component	char(32)
state	char(15)
detail	char(100)
label	char(320)

new
column	data type
query	int8
component	char(32)
state	char(15)
detail	char(100)
label	char(320)
xid	int8
vpid	int4

pg_catalog.stl_predicate_information

old
column	data type
userid	int4
query	int4
segment	int4
step	int4
node_id	int4
parent_node_id	int4
expr_datatype	int4
expr_name	char(64)
expr_id	int4

new
column	data type
userid	int4
query	int4
segment	int4
step	int4
node_id	int4
parent_node_id	int4
expr_datatype	int4
expr_name	char(64)
expr_id	int4
rrscan_status	int8

pg_catalog.stl_s3commit_stats

old
column	data type
xid	int8
node	int4
start_time	timestamp
end_time	timestamp
s3_write_untagged_latency	int8
s3_write_add_tag_latency	int8
s3_write_delete_tag_latency	int8
num_untagged_s3_writes	int8
num_add_tags_issued_to_s3	int8
num_delete_tags_issued_to_s3	int8
dynamo_write_avg_latency_usec	int8
synced_commits_to_s3	int4
s3commit_enable_latency	int8
s3commit_disable_latency	int8
dynamo_get_avg_latency_usec	int8
num_tossed_guids	int8
num_tombstoned_guids	int8
num_untagged_untracked	int8
num_tossed_tagless_s3_writes	int8
num_tossed_in_writes1	int8

new
column	data type
xid	int8
node	int4
start_time	timestamp
end_time	timestamp
s3_write_untagged_latency	int8
s3_write_add_tag_latency	int8
s3_write_delete_tag_latency	int8
num_untagged_s3_writes	int8
num_add_tags_issued_to_s3	int8
num_delete_tags_issued_to_s3	int8
dynamo_write_avg_latency_usec	int8
synced_commits_to_s3	int4
s3commit_enable_latency	int8
s3commit_disable_latency	int8
dynamo_get_avg_latency_usec	int8
num_tossed_guids	int8
num_tombstoned_guids	int8
num_untagged_untracked	int8
num_tossed_tagless_s3_writes	int8
num_tossed_in_writes1	int8
num_non_persistent_tagless_blocks	int8

pg_catalog.stl_tbl_perm_at_drop

old
column	data type
table_id	int4
node	int4
num_blocks	int4
dist_style	int4
temp	int4

new
column	data type
table_id	int4
node	int4
num_blocks	int4
dist_style	int4
temp	int4
eventtime	timestamp
xid	int8
name	char(128)

pg_catalog.stl_user_query_map

old
column	data type
user_id	int4
user_query_id	int8
rewritten_query_id	int8
transaction_id	int8
process_id	int4

new
column	data type
user_id	int4
user_query_id	int8
rewritten_query_id	int8
transaction_id	int8
process_id	int4
child_query_sequence	int4

pg_catalog.stl_xrestore

old
column	data type
backup_id	char(256)
node	int4
catalog_download_start_time	timestamp
catalog_download_end_time	timestamp
slice_transfer_start_time	timestamp
slice_transfer_end_time	timestamp
guid_pool_hit_rate	float8
num_guids_created_on_demand	int4
node_occ_mean	float8
node_occ_variance	float8
data_skew_cluster	float8

new
column	data type
backup_id	char(256)
node	int4
catalog_download_start_time	timestamp
catalog_download_end_time	timestamp
slice_transfer_start_time	timestamp
slice_transfer_end_time	timestamp
guid_pool_hit_rate	float8
num_guids_created_on_demand	int4
node_occ_mean	float8
node_occ_variance	float8
data_skew_cluster	float8
xrestore_type	int4
xrestore_source	int4

pg_catalog.svv_integration

old
column	data type
integration_id	char(128)
target_database	char(128)
source	char(128)
state	char(128)
current_lag	int8
last_replicated_checkpoint	char(128)
total_tables_replicated	int4
total_tables_failed	int4

new
column	data type
integration_id	char(128)
target_database	char(128)
source	char(128)
state	char(128)
current_lag	int8
last_replicated_checkpoint	char(128)
total_tables_replicated	int4
total_tables_failed	int4
creation_time	timestamp

pg_catalog.svv_rls_attached_policy

old
column	data type
relschema	varchar(128)
relname	varchar(128)
relkind	varchar(17)
polname	varchar(128)
grantor	varchar(128)
grantee	varchar(128)
granteekind	varchar(6)
is_pol_on	bool
is_rls_on	bool

new
column	data type
relschema	varchar(128)
relname	varchar(128)
relkind	varchar(17)
polname	varchar(128)
grantor	varchar(128)
grantee	varchar(128)
granteekind	varchar(6)
is_pol_on	bool
is_rls_on	bool
rls_conjunction_type	varchar(3)

pg_catalog.svv_rls_relation

old
column	data type
datname	varchar(128)
relschema	varchar(128)
relname	varchar(128)
relkind	varchar(17)
is_rls_on	char(1)
is_rls_datashare_on	char(1)

new
column	data type
datname	varchar(128)
relschema	varchar(128)
relname	varchar(128)
relkind	varchar(17)
is_rls_on	char(1)
is_rls_datashare_on	char(1)
rls_conjunction_type	varchar(3)
rls_datashare_conjunction_type	varchar(3)

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
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)

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
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)

pg_catalog.sys_external_query_detail

old
column	data type
user_id	int4
query_id	int8
transaction_id	int8
child_query_sequence	int4
segment_id	int4
source_type	char(32)
start_time	timestamp
end_time	timestamp
duration	int8
total_partitions	int4
qualified_partitions	int4
scanned_files	int8
returned_rows	int8
returned_bytes	int8
file_format	text
file_location	text
external_query_text	text
warning_message	char(4000)
table_name	text

new
column	data type
user_id	int4
query_id	int8
transaction_id	int8
child_query_sequence	int4
segment_id	int4
source_type	char(32)
start_time	timestamp
end_time	timestamp
duration	int8
total_partitions	int4
qualified_partitions	int4
scanned_files	int8
returned_rows	int8
returned_bytes	int8
file_format	text
file_location	text
external_query_text	text
warning_message	char(4000)
table_name	text
is_recursive	text
is_nested	text
s3list_time	int8
get_partition_time	int8

pg_catalog.sys_load_detail

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

new
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

pg_catalog.stl_volt_tt_sizes

old
column	data type
table_id	int4
node	int4
num_blocks	int4

new
column	data type

pg_catalog.sys_integration_table_state

old
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

new
column	data type