Redshift Observatory System Table Tracker

Functions

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

Tables

pg_catalog.pg_global_object

old
column	data type	PK	U	NN

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

pg_catalog.pg_global_object_attributes

old
column	data type	PK	U	NN

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

pg_catalog.stcs_auto_undo_events

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
eventtime	int8			NN
node	int4			NN
slice	int4			NN
xid	int8			NN
pid	int4			NN
table_id	int4			NN
mode	int4			NN
event	char(256)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_burst_manager_lag_based_refresh

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
eventtime	int8			NN
cluster_arn	char(100)			NN
refresh_end_time	int8			NN
refreshed_version	int8			NN
main_sb_version	int8			NN
decision	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_create_table_ddl_summary

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
querytime	int8			NN
userid	int4			NN
db_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
num_cols_with_encode	int4			NN
num_cols_without_encode	int4			NN
sortkey_defined	char(1)			NN
distkey_defined	char(1)			NN
diststyle_defined	char(1)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_guid_based_rereplication_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
logtime	int8			NN
node_num	int4			NN
queued_reads	int8			NN
issued_reads	int8			NN
issued_writes	int8			NN
failed_reads	int8			NN
failed_writes	int8			NN
useful_writes	int8			NN
wasted_writes	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_guid_cache_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
record_time	int8			NN
mode	int4			NN
entries	int8			NN
lookups	int8			NN
hits	int8			NN
inserts	int8			NN
deletes	int8			NN
resets	int8			NN
stale_hits	int8			NN
ds_lookups	int8			NN
ds_hits	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_integration_cdc_detail

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
database_name	char(128)			NN
checkpoint	char(128)			NN
source_type	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
status	int4			NN
synced_log_coordinate	char(128)			NN
src_inserts	int8			NN
src_deletes	int8			NN
src_updates	int8			NN
inserts	int8			NN
inserts_dt	int8			NN
parsed_rows	int8			NN
skipped_rows	int8			NN
is_bursted	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_mddl_history

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
tbl	int4			NN
mask	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_query_level_cg_paths

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
recordtime	int8			NN
query	int4			NN
segment	int4			NN
was_cached	int4			NN
path	char(255)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_query_scaling_prediction

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
cluster_size	int4			NN
execution_time	float8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_sage_mode_budget

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int4			NN
userid	int4			NN
record_time	int8			NN
mb_scanned	int4			NN
rpu_sec	int4			NN
total_rpu_sec	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_sage_scaling_candidates

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
decision_id	int4			NN
candidate_id	int4			NN
ssid	int4			NN
state	int4			NN
nodes	int4			NN
running_queries	int4			NN
queued_queries	int4			NN
est_exec_time_ms	int4			NN
spill_penalty_ms	int4			NN
est_prepare_delay_ms	int4			NN
est_queue_time_ms	int4			NN
penalty	float8			NN
eligible	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_sage_scaling_clusters

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	int8			NN
ssid	int4			NN
prev_state	int4			NN
new_state	int4			NN
nodes	int4			NN
arn	char(128)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_sage_scaling_decisions

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
pid	int4			NN
userid	int4			NN
decision_id	int4			NN
decision_time	int8			NN
budget_rpu_sec	int4			NN
queue_time_ms	int4			NN
chosen_candidate_id	int4			NN
seconds_since_last_acquire	int4			NN
alpha	float8			NN
burstable	int4			NN
fallback	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stll_auto_undo_events

old
column	data type	PK	U	NN

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

pg_catalog.stll_burst_manager_lag_based_refresh

old
column	data type	PK	U	NN

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

pg_catalog.stll_create_table_ddl_summary

old
column	data type	PK	U	NN

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

pg_catalog.stll_guid_based_rereplication_stats

old
column	data type	PK	U	NN

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

pg_catalog.stll_guid_cache_stats

old
column	data type	PK	U	NN

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

pg_catalog.stll_integration_cdc_detail

old
column	data type	PK	U	NN

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

pg_catalog.stll_mddl_history

old
column	data type	PK	U	NN

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

pg_catalog.stll_query_level_cg_paths

old
column	data type	PK	U	NN

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

pg_catalog.stll_query_scaling_prediction

old
column	data type	PK	U	NN

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

pg_catalog.stll_sage_mode_budget

old
column	data type	PK	U	NN

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

pg_catalog.stll_sage_scaling_candidates

old
column	data type	PK	U	NN

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

pg_catalog.stll_sage_scaling_clusters

old
column	data type	PK	U	NN

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

pg_catalog.stll_sage_scaling_decisions

old
column	data type	PK	U	NN

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

pg_catalog.stv_inflight_undos

old
column	data type	PK	U	NN

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

pg_catalog.stv_sage_scaling_current_clusters

old
column	data type	PK	U	NN

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

pg_internal.redshift_auto_health_check_4998877

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_auto_copy_job

old
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
job_name	text
job_owner	int4			NN
auto_copy_table_oid	oid			NN
s3_prefix	text
iam_role	text
copy_query	text
is_auto	bool			NN
on_error_suspend	bool			NN
last_file_ingest	timestamp			NN

new
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
job_name	text
job_owner	int4			NN
auto_copy_table_oid	oid			NN
s3_prefix	text
iam_role	text
copy_query	text
is_auto	bool			NN
on_error_suspend	bool			NN
last_file_ingest	timestamp			NN
job_create_time	timestamp			NN
metadata	text

pg_catalog.stcs_aggr

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
bytes	int8			NN
slots	int4			NN
occupied	int4			NN
maxlength	int4			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
type	char(6)			NN
resizes	int4			NN
flushable	int4			NN
varchar_agg_opt	char(1)			NN
varagg_opt_bitmap	int8			NN
used_agg_prefetching	char(1)			NN
used_mega_block	char(1)			NN
num_flushes	int4			NN
memory_usage_ratio	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
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
slots	int4			NN
occupied	int4			NN
maxlength	int4			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
type	char(6)			NN
resizes	int4			NN
flushable	int4			NN
varchar_agg_opt	char(1)			NN
varagg_opt_bitmap	int8			NN
used_agg_prefetching	char(1)			NN
used_mega_block	char(1)			NN
num_flushes	int4			NN
memory_usage_ratio	int4			NN
dist_by_distinct	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_xact_log

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	int8			NN
xid	int8			NN
pid	int4			NN
xact_tag	int4			NN
xact_start_loc	int4			NN
xact_stop_loc	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
userid	int4			NN
recordtime	int8			NN
xid	int8			NN
pid	int4			NN
xact_tag	int4			NN
xact_start_loc	int4			NN
xact_stop_loc	int4			NN
tx_billable_state	int4			NN
force_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_connection

old
column	data type	PK	U	NN
action	char(20)			NN
method	char(50)			NN
pid	int8			NN
xid	int8			NN
line_number	int8			NN
eventtime	int8			NN
cluster_arn	char(100)			NN
connection_guid	char(100)			NN
error	char(250)			NN
switch_status	char(20)			NN
switch_time	int4			NN
starttime	int8			NN
query	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
action	char(20)			NN
method	char(50)			NN
pid	int8			NN
xid	int8			NN
line_number	int8			NN
eventtime	int8			NN
cluster_arn	char(128)			NN
connection_guid	char(100)			NN
error	char(250)			NN
switch_status	char(20)			NN
switch_time	int4			NN
starttime	int8			NN
query	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_burst_manager_personalization

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

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

pg_catalog.stcs_burst_manager_refresh

old
column	data type	PK	U	NN
eventtime	int8			NN
action	char(50)			NN
type	char(20)			NN
refresh_method	char(20)			NN
pid	int8			NN
refresh_version	int8			NN
cluster_arn	char(100)			NN
error	char(350)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
eventtime	int8			NN
action	char(50)			NN
type	char(20)			NN
refresh_method	char(20)			NN
pid	int8			NN
refresh_version	int8			NN
cluster_arn	char(128)			NN
error	char(350)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_burst_query_execution

old
column	data type	PK	U	NN
action	char(20)			NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
query	int8			NN
backup_id	char(30)			NN
cluster_backup_version	int8			NN
starttime	int8			NN
endtime	int8			NN
cluster_arn	char(100)			NN
max_vis_xid	int8			NN
query_sb_version	int8			NN
num_tuples	int4			NN
fetch_complete	int4			NN
error	char(350)			NN
connection_guid	char(100)			NN
xen_error_code	int4			NN
burst_cluster_id	char(38)			NN
burst_query_id	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
action	char(20)			NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
query	int8			NN
backup_id	char(30)			NN
cluster_backup_version	int8			NN
starttime	int8			NN
endtime	int8			NN
cluster_arn	char(128)			NN
max_vis_xid	int8			NN
query_sb_version	int8			NN
num_tuples	int4			NN
fetch_complete	int4			NN
error	char(350)			NN
connection_guid	char(100)			NN
xen_error_code	int4			NN
burst_cluster_id	char(38)			NN
burst_query_id	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_burst_service_client

old
column	data type	PK	U	NN
action	char(10)			NN
pid	int8			NN
xid	int8			NN
eventtime	int8			NN
cluster_arn	char(100)			NN
expiration	int8			NN
preshared_key	char(100)			NN
num_nodes	int4			NN
error	char(250)			NN
request_id	char(100)			NN
reason	char(40)			NN
query	int4			NN
starttime	int8			NN
extended_json	char(60)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
action	char(10)			NN
pid	int8			NN
xid	int8			NN
eventtime	int8			NN
cluster_arn	char(128)			NN
expiration	int8			NN
preshared_key	char(100)			NN
num_nodes	int4			NN
error	char(250)			NN
request_id	char(100)			NN
reason	char(40)			NN
query	int4			NN
starttime	int8			NN
extended_json	char(60)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_cdc_checkpoints

old
column	data type	PK	U	NN
recordtime	int8			NN
connection_id	char(128)			NN
db_name	char(128)			NN
s3_path	char(512)			NN
checkpoint	char(128)			NN
type	char(16)			NN
num_tables_modified	int4			NN
status	char(16)			NN
bytes_downloaded	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
recordtime	int8			NN
connection_id	char(128)			NN
db_name	char(128)			NN
s3_path	char(512)			NN
checkpoint	char(128)			NN
type	char(16)			NN
num_tables_modified	int4			NN
status	char(16)			NN
bytes_downloaded	int8			NN
channel_state	char(128)			NN
export_identifier	char(64)			NN
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

pg_catalog.stcs_compute_elasticity_insert

old
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
ds_calc_option	int4			NN
parallel_insert_degree	int4			NN
parallel_insert_reason	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	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
ds_calc_option	int4			NN
parallel_insert_degree	int4			NN
parallel_insert_reason	int4			NN
tbl	int4			NN
rows	int8			NN
cols	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_datashare_request_producer

old
column	data type	PK	U	NN
userid	int4			NN
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
xid	int8			NN
backend_start_time	int8			NN
handler_start_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

new
column	data type	PK	U	NN
userid	int4			NN
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
xid	int8			NN
backend_start_time	int8			NN
handler_start_time	int8			NN
consumer_region	char(64)			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_exec_state

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
currenttime	int8			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
label	char(256)			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	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
currenttime	int8			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
label	char(256)			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
step_attribute	char(64)			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_integration_activity_detail

old
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
database_name	char(128)			NN
node_id	int4			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
copy_id	int8			NN
table_name	char(128)			NN
checkpoint_data_size	int8			NN
state	char(128)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
database_name	char(128)			NN
node_id	int4			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
copy_id	int8			NN
table_name	char(128)			NN
checkpoint_data_size	int8			NN
state	char(128)			NN
channel_state	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_integration_log

old
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
status	char(128)			NN
database_name	char(128)			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
synced_log_coordinate	char(128)			NN
num_modified_tables	int4			NN
lag_ms	int8			NN
checkpoint_bytes	int8			NN
integration_start_time	int8			NN
last_commit_timestamp	int8			NN
num_failed_tables	int4			NN
delay_ms	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
record_time	int8			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
status	char(128)			NN
database_name	char(128)			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
synced_log_coordinate	char(128)			NN
num_modified_tables	int4			NN
lag_ms	int8			NN
checkpoint_bytes	int8			NN
integration_start_time	int8			NN
last_commit_timestamp	int8			NN
num_failed_tables	int4			NN
delay_ms	int8			NN
channel_state	char(128)			NN
export_identifier	char(64)			NN
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

pg_catalog.stcs_query_detail

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
stream_id	int4			NN
segment_id	int4			NN
step_id	int4			NN
slice	int4			NN
starttime	int8			NN
endtime	int8			NN
step_name	int4			NN
table_id	int4			NN
table_name	char(136)			NN
input_rows	int8			NN
input_bytes	int8			NN
output_rows	int8			NN
output_bytes	int8			NN
is_rrscan	char(1)			NN
blocks_read	int8			NN
blocks_write	int8			NN
local_read_io	int8			NN
remote_read_io	int8			NN
alert	char(1024)			NN
internal_query	char(1)			NN
source	char(64)			NN
cpu_time	int8			NN
spilled_block_local_disk	int8			NN
spilled_block_remote_disk	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
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
stream_id	int4			NN
segment_id	int4			NN
step_id	int4			NN
slice	int4			NN
starttime	int8			NN
endtime	int8			NN
step_name	int4			NN
table_id	int4			NN
table_name	char(136)			NN
input_rows	int8			NN
input_bytes	int8			NN
output_rows	int8			NN
output_bytes	int8			NN
is_rrscan	char(1)			NN
blocks_read	int8			NN
blocks_write	int8			NN
local_read_io	int8			NN
remote_read_io	int8			NN
alert	char(1024)			NN
internal_query	char(1)			NN
source	char(64)			NN
cpu_time	int8			NN
spilled_block_local_disk	int8			NN
spilled_block_remote_disk	int8			NN
step_attribute	char(64)			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_rls_applied_policy

old
column	data type	PK	U	NN
userid	int4			NN
plan_qid	int8			NN
xid	int8			NN
pid	int4			NN
recordtime	int8			NN
command	char(1)			NN
dbid	int4			NN
relid	int4			NN
polid	int4			NN
poldefault	char(1)			NN
policy_provider	char(20)			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
plan_qid	int8			NN
xid	int8			NN
pid	int4			NN
recordtime	int8			NN
command	char(1)			NN
dbid	int4			NN
relid	int4			NN
polid	int4			NN
poldefault	char(1)			NN
policy_provider	char(20)			NN
relkind	char(30)			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_tiered_storage_s3_blocks

old
column	data type	PK	U	NN
node_num	int4			NN
event_time	int8			NN
num_blocks_evicted	int8			NN
on_demand_eviction	int4			NN
superblock_version	int8			NN
transaction_id	int8			NN
local_capacity	int8			NN
ts_cache_elems	int8			NN
blks_evictable	int8			NN
blks_to_backup	int8			NN
evicted_without_reads	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
node_num	int4			NN
event_time	int8			NN
num_blocks_evicted	int8			NN
on_demand_eviction	int4			NN
superblock_version	int8			NN
transaction_id	int8			NN
local_capacity	int8			NN
ts_cache_elems	int8			NN
blks_evictable	int8			NN
blks_to_backup	int8			NN
evicted_without_reads	int8			NN
num_to_evict	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_vacuum_detail

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
part	int4			NN
start_row	int8			NN
end_row	int8			NN
num_new_rows	int8			NN
num_blocks_replaced	int8			NN
total_block_io_estimate	int8			NN
window_num	int4			NN
num_deleted_rows	int8			NN
compact	int4			NN
num_new_blocks	int8			NN
empty_space_size	int8			NN
table_partition_number	int4			NN
local_to_total_ratio	float8			NN
local_block_count	int8			NN
insufficient_local_blk_cnt	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
slice	int4			NN
part	int4			NN
start_row	int8			NN
end_row	int8			NN
num_new_rows	int8			NN
num_blocks_replaced	int8			NN
total_block_io_estimate	int8			NN
window_num	int4			NN
num_deleted_rows	int8			NN
compact	int4			NN
num_new_blocks	int8			NN
empty_space_size	int8			NN
table_partition_number	int4			NN
local_to_total_ratio	float8			NN
local_block_count	int8			NN
insufficient_local_blk_cnt	int4			NN
table_id	int4			NN
xid	int8			NN
pid	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_aggr

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
bytes	int8			NN
slots	int4			NN
occupied	int4			NN
maxlength	int4			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
type	char(6)			NN
resizes	int4			NN
flushable	int4			NN
varchar_agg_opt	char(1)			NN
varagg_opt_bitmap	int8			NN
used_agg_prefetching	char(1)			NN
used_mega_block	char(1)			NN
num_flushes	int4			NN
memory_usage_ratio	int4			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
bytes	int8			NN
slots	int4			NN
occupied	int4			NN
maxlength	int4			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
type	char(6)			NN
resizes	int4			NN
flushable	int4			NN
varchar_agg_opt	char(1)			NN
varagg_opt_bitmap	int8			NN
used_agg_prefetching	char(1)			NN
used_mega_block	char(1)			NN
num_flushes	int4			NN
memory_usage_ratio	int4			NN
dist_by_distinct	int4			NN

pg_catalog.stll_arcadia_billing_xact_log

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
xid	int8			NN
pid	int4			NN
xact_tag	int4			NN
xact_start_loc	int4			NN
xact_stop_loc	int4			NN
tx_billable_state	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
xid	int8			NN
pid	int4			NN
xact_tag	int4			NN
xact_start_loc	int4			NN
xact_stop_loc	int4			NN
tx_billable_state	int4			NN
force_billable_state	int4			NN

pg_catalog.stll_burst_connection

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

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

pg_catalog.stll_burst_manager_personalization

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

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

pg_catalog.stll_burst_manager_refresh

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

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

pg_catalog.stll_burst_query_execution

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

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

pg_catalog.stll_burst_service_client

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

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

pg_catalog.stll_cdc_checkpoints

old
column	data type	PK	U	NN
recordtime	timestamp			NN
connection_id	char(128)			NN
db_name	char(128)			NN
s3_path	char(512)			NN
checkpoint	char(128)			NN
type	char(16)			NN
num_tables_modified	int4			NN
status	char(16)			NN
bytes_downloaded	int8			NN

new
column	data type	PK	U	NN
recordtime	timestamp			NN
connection_id	char(128)			NN
db_name	char(128)			NN
s3_path	char(512)			NN
checkpoint	char(128)			NN
type	char(16)			NN
num_tables_modified	int4			NN
status	char(16)			NN
bytes_downloaded	int8			NN
channel_state	char(128)			NN
export_identifier	char(64)			NN
rows	int8			NN

pg_catalog.stll_compute_elasticity_insert

old
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
ds_calc_option	int4			NN
parallel_insert_degree	int4			NN
parallel_insert_reason	int4			NN

new
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
ds_calc_option	int4			NN
parallel_insert_degree	int4			NN
parallel_insert_reason	int4			NN
tbl	int4			NN
rows	int8			NN
cols	int4			NN

pg_catalog.stll_datashare_request_producer

old
column	data type	PK	U	NN
userid	int4			NN
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	timestamp			NN
endtime	timestamp			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
xid	int8			NN
backend_start_time	timestamp			NN
handler_start_time	timestamp			NN

new
column	data type	PK	U	NN
userid	int4			NN
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	timestamp			NN
endtime	timestamp			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
xid	int8			NN
backend_start_time	timestamp			NN
handler_start_time	timestamp			NN
consumer_region	char(64)			NN

pg_catalog.stll_exec_state

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
currenttime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
label	char(256)			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	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
currenttime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
label	char(256)			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
step_attribute	char(64)			NN

pg_catalog.stll_integration_activity_detail

old
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
database_name	char(128)			NN
node_id	int4			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
copy_id	int8			NN
table_name	char(128)			NN
checkpoint_data_size	int8			NN
state	char(128)			NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
database_name	char(128)			NN
node_id	int4			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
copy_id	int8			NN
table_name	char(128)			NN
checkpoint_data_size	int8			NN
state	char(128)			NN
channel_state	char(128)			NN

pg_catalog.stll_integration_log

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
status	char(128)			NN
database_name	char(128)			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
synced_log_coordinate	char(128)			NN
num_modified_tables	int4			NN
lag_ms	int8			NN
checkpoint_bytes	int8			NN
integration_start_time	timestamp			NN
last_commit_timestamp	timestamp			NN
num_failed_tables	int4			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
status	char(128)			NN
database_name	char(128)			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
synced_log_coordinate	char(128)			NN
num_modified_tables	int4			NN
lag_ms	int8			NN
checkpoint_bytes	int8			NN
integration_start_time	timestamp			NN
last_commit_timestamp	timestamp			NN
num_failed_tables	int4			NN
delay_ms	int8			NN
channel_state	char(128)			NN
export_identifier	char(64)			NN
rows	int8			NN

pg_catalog.stll_query_detail

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
stream_id	int4			NN
segment_id	int4			NN
step_id	int4			NN
slice	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
step_name	int4			NN
table_id	int4			NN
table_name	char(136)			NN
input_rows	int8			NN
input_bytes	int8			NN
output_rows	int8			NN
output_bytes	int8			NN
is_rrscan	char(1)			NN
blocks_read	int8			NN
blocks_write	int8			NN
local_read_io	int8			NN
remote_read_io	int8			NN
alert	char(1024)			NN
internal_query	char(1)			NN
source	char(64)			NN
cpu_time	int8			NN
spilled_block_local_disk	int8			NN
spilled_block_remote_disk	int8			NN

new
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
stream_id	int4			NN
segment_id	int4			NN
step_id	int4			NN
slice	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
step_name	int4			NN
table_id	int4			NN
table_name	char(136)			NN
input_rows	int8			NN
input_bytes	int8			NN
output_rows	int8			NN
output_bytes	int8			NN
is_rrscan	char(1)			NN
blocks_read	int8			NN
blocks_write	int8			NN
local_read_io	int8			NN
remote_read_io	int8			NN
alert	char(1024)			NN
internal_query	char(1)			NN
source	char(64)			NN
cpu_time	int8			NN
spilled_block_local_disk	int8			NN
spilled_block_remote_disk	int8			NN
step_attribute	char(64)			NN

pg_catalog.stll_rls_applied_policy

old
column	data type	PK	U	NN
userid	int4			NN
plan_qid	int8			NN
xid	int8			NN
pid	int4			NN
recordtime	timestamp			NN
command	char(1)			NN
dbid	int4			NN
relid	int4			NN
polid	int4			NN
poldefault	char(1)			NN
policy_provider	char(20)			NN

new
column	data type	PK	U	NN
userid	int4			NN
plan_qid	int8			NN
xid	int8			NN
pid	int4			NN
recordtime	timestamp			NN
command	char(1)			NN
dbid	int4			NN
relid	int4			NN
polid	int4			NN
poldefault	char(1)			NN
policy_provider	char(20)			NN
relkind	char(30)			NN

pg_catalog.stll_tiered_storage_s3_blocks

old
column	data type	PK	U	NN
node_num	int4			NN
event_time	timestamp			NN
num_blocks_evicted	int8			NN
on_demand_eviction	int4			NN
superblock_version	int8			NN
transaction_id	int8			NN
local_capacity	int8			NN
ts_cache_elems	int8			NN
blks_evictable	int8			NN
blks_to_backup	int8			NN
evicted_without_reads	int8			NN

new
column	data type	PK	U	NN
node_num	int4			NN
event_time	timestamp			NN
num_blocks_evicted	int8			NN
on_demand_eviction	int4			NN
superblock_version	int8			NN
transaction_id	int8			NN
local_capacity	int8			NN
ts_cache_elems	int8			NN
blks_evictable	int8			NN
blks_to_backup	int8			NN
evicted_without_reads	int8			NN
num_to_evict	int8			NN

pg_catalog.stll_vacuum_detail

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
part	int4			NN
start_row	int8			NN
end_row	int8			NN
num_new_rows	int8			NN
num_blocks_replaced	int8			NN
total_block_io_estimate	int8			NN
window_num	int4			NN
num_deleted_rows	int8			NN
compact	int4			NN
num_new_blocks	int8			NN
empty_space_size	int8			NN
table_partition_number	int4			NN
local_to_total_ratio	float8			NN
local_block_count	int8			NN
insufficient_local_blk_cnt	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
part	int4			NN
start_row	int8			NN
end_row	int8			NN
num_new_rows	int8			NN
num_blocks_replaced	int8			NN
total_block_io_estimate	int8			NN
window_num	int4			NN
num_deleted_rows	int8			NN
compact	int4			NN
num_new_blocks	int8			NN
empty_space_size	int8			NN
table_partition_number	int4			NN
local_to_total_ratio	float8			NN
local_block_count	int8			NN
insufficient_local_blk_cnt	int4			NN
table_id	int4			NN
xid	int8			NN
pid	int4			NN

pg_catalog.stv_burst_manager_cluster_info

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

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

pg_catalog.stv_exec_state

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
currenttime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
label	char(256)			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	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
currenttime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
label	char(256)			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
step_attribute	char(64)			NN

pg_catalog.stv_local_superblock_manager

old
column	data type	PK	U	NN
local_node_num	int4			NN
producer_cluster_id	int4			NN
producer_node_num	int4			NN
superblock_size	int8			NN
last_accessed_timestamp	int8			NN

new
column	data type	PK	U	NN
local_node_num	int4			NN
producer_cluster_id	int4			NN
producer_node_num	int4			NN
superblock_size	int8			NN
last_accessed_timestamp	int8			NN
data_size	int8			NN

pg_catalog.stcs_guid_cache_metrics

old
column	data type	PK	U	NN
node	int4			NN
record_time	int8			NN
entries_tracked	int8			NN
staleness_percent	int8			NN
unknown_percent	int8			NN
lookups	int8			NN
staleness_count	int8			NN
unknown_count	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_guid_cache_metrics

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

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_43143369

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_auto_undo_events

old
column	data type

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

pg_catalog.stl_burst_manager_lag_based_refresh

old
column	data type

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

pg_catalog.stl_create_table_ddl_summary

old
column	data type

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

pg_catalog.stl_guid_based_rereplication_stats

old
column	data type

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

pg_catalog.stl_guid_cache_stats

old
column	data type

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

pg_catalog.stl_integration_cdc_detail

old
column	data type

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

pg_catalog.stl_mddl_history

old
column	data type

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

pg_catalog.stl_query_level_cg_paths

old
column	data type

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

pg_catalog.stl_query_scaling_prediction

old
column	data type

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

pg_catalog.stl_sage_mode_budget

old
column	data type

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

pg_catalog.stl_sage_scaling_candidates

old
column	data type

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

pg_catalog.stl_sage_scaling_clusters

old
column	data type

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

pg_catalog.stl_sage_scaling_decisions

old
column	data type

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

pg_catalog.sys_auto_table_optimization

old
column	data type

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

pg_catalog.stl_aggr

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
slots	int4
occupied	int4
maxlength	int4
tbl	int4
is_diskbased	char(1)
workmem	int8
type	char(6)
resizes	int4
flushable	int4
varchar_agg_opt	char(1)
varagg_opt_bitmap	int8
used_agg_prefetching	char(1)
used_mega_block	char(1)
num_flushes	int4
memory_usage_ratio	int4

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
slots	int4
occupied	int4
maxlength	int4
tbl	int4
is_diskbased	char(1)
workmem	int8
type	char(6)
resizes	int4
flushable	int4
varchar_agg_opt	char(1)
varagg_opt_bitmap	int8
used_agg_prefetching	char(1)
used_mega_block	char(1)
num_flushes	int4
memory_usage_ratio	int4
dist_by_distinct	int4

pg_catalog.stl_arcadia_billing_xact_log

old
column	data type
userid	int4
recordtime	timestamp
xid	int8
pid	int4
xact_tag	int4
xact_start_loc	int4
xact_stop_loc	int4
tx_billable_state	int4

new
column	data type
userid	int4
recordtime	timestamp
xid	int8
pid	int4
xact_tag	int4
xact_start_loc	int4
xact_stop_loc	int4
tx_billable_state	int4
force_billable_state	int4

pg_catalog.stl_burst_connection

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

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

pg_catalog.stl_burst_manager_personalization

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

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

pg_catalog.stl_burst_manager_refresh

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

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

pg_catalog.stl_burst_query_execution

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

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

pg_catalog.stl_burst_service_client

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

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

pg_catalog.stl_cdc_checkpoints

old
column	data type
recordtime	timestamp
connection_id	char(128)
db_name	char(128)
s3_path	char(512)
checkpoint	char(128)
type	char(16)
num_tables_modified	int4
status	char(16)
bytes_downloaded	int8

new
column	data type
recordtime	timestamp
connection_id	char(128)
db_name	char(128)
s3_path	char(512)
checkpoint	char(128)
type	char(16)
num_tables_modified	int4
status	char(16)
bytes_downloaded	int8
channel_state	char(128)
export_identifier	char(64)
rows	int8

pg_catalog.stl_compute_elasticity_insert

old
column	data type
query	int4
slice	int4
segment	int4
step	int4
ds_calc_option	int4
parallel_insert_degree	int4
parallel_insert_reason	int4

new
column	data type
query	int4
slice	int4
segment	int4
step	int4
ds_calc_option	int4
parallel_insert_degree	int4
parallel_insert_reason	int4
tbl	int4
rows	int8
cols	int4

pg_catalog.stl_datashare_request_producer

old
column	data type
userid	int4
pid	int4
requestid	char(50)
sb_version	int8
dbtype	int4
dbid	int4
shareid	int4
sharename	char(128)
api_call	int4
obj_type	int4
obj_oid	int4
obj_name	char(128)
starttime	timestamp
endtime	timestamp
status	int4
message	char(512)
consumeraccountid	char(50)
consumernamespace	char(50)
consumer_transaction_uid	char(50)
is_versioned_request	int4
overridden_snapshot_xmin	int8
xid	int8
backend_start_time	timestamp
handler_start_time	timestamp

new
column	data type
userid	int4
pid	int4
requestid	char(50)
sb_version	int8
dbtype	int4
dbid	int4
shareid	int4
sharename	char(128)
api_call	int4
obj_type	int4
obj_oid	int4
obj_name	char(128)
starttime	timestamp
endtime	timestamp
status	int4
message	char(512)
consumeraccountid	char(50)
consumernamespace	char(50)
consumer_transaction_uid	char(50)
is_versioned_request	int4
overridden_snapshot_xmin	int8
xid	int8
backend_start_time	timestamp
handler_start_time	timestamp
consumer_region	char(64)

pg_catalog.stl_exec_state

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
currenttime	timestamp
tasknum	int4
rows	int8
bytes	int8
label	char(256)
is_diskbased	char(1)
workmem	int8
num_parts	int4
is_rrscan	char(1)
is_delayed_scan	char(1)

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
currenttime	timestamp
tasknum	int4
rows	int8
bytes	int8
label	char(256)
is_diskbased	char(1)
workmem	int8
num_parts	int4
is_rrscan	char(1)
is_delayed_scan	char(1)
step_attribute	char(64)

pg_catalog.stl_integration_activity_detail

old
column	data type
record_time	timestamp
integration_id	char(128)
database_name	char(128)
node_id	int4
checkpoint_name	char(128)
checkpoint_type	char(16)
copy_id	int8
table_name	char(128)
checkpoint_data_size	int8
state	char(128)

new
column	data type
record_time	timestamp
integration_id	char(128)
database_name	char(128)
node_id	int4
checkpoint_name	char(128)
checkpoint_type	char(16)
copy_id	int8
table_name	char(128)
checkpoint_data_size	int8
state	char(128)
channel_state	char(128)

pg_catalog.stl_integration_log

old
column	data type
record_time	timestamp
integration_id	char(128)
integration_type	char(128)
state	char(128)
status	char(128)
database_name	char(128)
checkpoint_name	char(128)
checkpoint_type	char(16)
synced_log_coordinate	char(128)
num_modified_tables	int4
lag_ms	int8
checkpoint_bytes	int8
integration_start_time	timestamp
last_commit_timestamp	timestamp
num_failed_tables	int4
delay_ms	int8

new
column	data type
record_time	timestamp
integration_id	char(128)
integration_type	char(128)
state	char(128)
status	char(128)
database_name	char(128)
checkpoint_name	char(128)
checkpoint_type	char(16)
synced_log_coordinate	char(128)
num_modified_tables	int4
lag_ms	int8
checkpoint_bytes	int8
integration_start_time	timestamp
last_commit_timestamp	timestamp
num_failed_tables	int4
delay_ms	int8
channel_state	char(128)
export_identifier	char(64)
rows	int8

pg_catalog.stl_query_detail

old
column	data type
user_id	int4
query_id	int8
child_query_id	int4
child_query_sequence	int4
stream_id	int4
segment_id	int4
step_id	int4
slice	int4
starttime	timestamp
endtime	timestamp
step_name	int4
table_id	int4
table_name	char(136)
input_rows	int8
input_bytes	int8
output_rows	int8
output_bytes	int8
is_rrscan	char(1)
blocks_read	int8
blocks_write	int8
local_read_io	int8
remote_read_io	int8
alert	char(1024)
internal_query	char(1)
source	char(64)
cpu_time	int8
spilled_block_local_disk	int8
spilled_block_remote_disk	int8

new
column	data type
user_id	int4
query_id	int8
child_query_id	int4
child_query_sequence	int4
stream_id	int4
segment_id	int4
step_id	int4
slice	int4
starttime	timestamp
endtime	timestamp
step_name	int4
table_id	int4
table_name	char(136)
input_rows	int8
input_bytes	int8
output_rows	int8
output_bytes	int8
is_rrscan	char(1)
blocks_read	int8
blocks_write	int8
local_read_io	int8
remote_read_io	int8
alert	char(1024)
internal_query	char(1)
source	char(64)
cpu_time	int8
spilled_block_local_disk	int8
spilled_block_remote_disk	int8
step_attribute	char(64)

pg_catalog.stl_rls_applied_policy

old
column	data type
userid	int4
plan_qid	int8
xid	int8
pid	int4
recordtime	timestamp
command	char(1)
dbid	int4
relid	int4
polid	int4
poldefault	char(1)
policy_provider	char(20)

new
column	data type
userid	int4
plan_qid	int8
xid	int8
pid	int4
recordtime	timestamp
command	char(1)
dbid	int4
relid	int4
polid	int4
poldefault	char(1)
policy_provider	char(20)
relkind	char(30)

pg_catalog.stl_tiered_storage_s3_blocks

old
column	data type
node_num	int4
event_time	timestamp
num_blocks_evicted	int8
on_demand_eviction	int4
superblock_version	int8
transaction_id	int8
local_capacity	int8
ts_cache_elems	int8
blks_evictable	int8
blks_to_backup	int8
evicted_without_reads	int8

new
column	data type
node_num	int4
event_time	timestamp
num_blocks_evicted	int8
on_demand_eviction	int4
superblock_version	int8
transaction_id	int8
local_capacity	int8
ts_cache_elems	int8
blks_evictable	int8
blks_to_backup	int8
evicted_without_reads	int8
num_to_evict	int8

pg_catalog.stl_vacuum_detail

old
column	data type
userid	int4
query	int4
slice	int4
part	int4
start_row	int8
end_row	int8
num_new_rows	int8
num_blocks_replaced	int8
total_block_io_estimate	int8
window_num	int4
num_deleted_rows	int8
compact	int4
num_new_blocks	int8
empty_space_size	int8
table_partition_number	int4
local_to_total_ratio	float8
local_block_count	int8
insufficient_local_blk_cnt	int4

new
column	data type
userid	int4
query	int4
slice	int4
part	int4
start_row	int8
end_row	int8
num_new_rows	int8
num_blocks_replaced	int8
total_block_io_estimate	int8
window_num	int4
num_deleted_rows	int8
compact	int4
num_new_blocks	int8
empty_space_size	int8
table_partition_number	int4
local_to_total_ratio	float8
local_block_count	int8
insufficient_local_blk_cnt	int4
table_id	int4
xid	int8
pid	int4

pg_catalog.svl_burst_service_client

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

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

pg_catalog.svl_datashare_usage_producer

old
column	data type
share_id	int4
share_name	varchar(128)
request_id	varchar(50)
request_type	varchar(25)
object_type	varchar(64)
object_oid	int4
object_name	varchar(128)
consumer_account	varchar(16)
consumer_namespace	varchar(64)
consumer_transaction_uid	varchar(50)
recordtime	timestamp
status	int4
error	varchar(512)

new
column	data type
share_id	int4
share_name	varchar(128)
request_id	varchar(50)
request_type	varchar(25)
object_type	varchar(64)
object_oid	int4
object_name	varchar(128)
consumer_account	varchar(16)
consumer_namespace	varchar(64)
consumer_transaction_uid	varchar(50)
recordtime	timestamp
status	int4
error	varchar(512)
consumer_region	varchar(64)

pg_catalog.svv_redshift_databases

old
column	data type
database_name	varchar(128)
database_owner	int4
database_type	varchar(32)
database_acl	varchar(128)
database_options	varchar(128)

new
column	data type
database_name	varchar(128)
database_owner	int4
database_type	varchar(32)
database_acl	varchar(128)
database_options	varchar(128)
database_isolation_level	varchar(128)

pg_catalog.svv_rls_applied_policy

old
column	data type
username	text
query	int4
xid	int8
pid	int4
recordtime	timestamp
command	char(1)
datname	text
relschema	text
relname	text
polname	text
poldefault	text

new
column	data type
username	text
query	int4
xid	int8
pid	int4
recordtime	timestamp
command	char(1)
datname	text
relschema	text
relname	text
polname	text
poldefault	text
relkind	text

pg_catalog.sys_datashare_usage_producer

old
column	data type
share_id	int4
share_name	varchar(128)
request_id	varchar(50)
request_type	varchar(25)
object_type	varchar(64)
object_oid	int4
object_name	varchar(128)
consumer_account	varchar(16)
consumer_namespace	varchar(64)
consumer_transaction_uid	varchar(50)
record_time	timestamp
status	int4
error	varchar(512)

new
column	data type
share_id	int4
share_name	varchar(128)
request_id	varchar(50)
request_type	varchar(25)
object_type	varchar(64)
object_oid	int4
object_name	varchar(128)
consumer_account	varchar(16)
consumer_namespace	varchar(64)
consumer_transaction_uid	varchar(50)
record_time	timestamp
status	int4
error	varchar(512)
consumer_region	varchar(64)

pg_catalog.sys_query_detail

old
column	data type
user_id	int4
query_id	int8
child_query_sequence	int4
stream_id	int4
segment_id	int4
step_id	int4
step_name	varchar(256)
table_id	int4
table_name	varchar(136)
is_rrscan	varchar(1)
start_time	timestamp
end_time	timestamp
duration	int8
alert	varchar(1024)
input_bytes	int8
input_rows	int8
output_bytes	int8
output_rows	int8
blocks_read	int8
blocks_write	int8
local_read_io	int8
remote_read_io	int8
source	varchar(64)
data_skewness	int4
time_skewness	int4
is_active	varchar(1)
spilled_block_local_disk	int8
spilled_block_remote_disk	int8

new
column	data type
user_id	int4
query_id	int8
child_query_sequence	int4
stream_id	int4
segment_id	int4
step_id	int4
step_name	varchar(256)
table_id	int4
table_name	varchar(136)
is_rrscan	varchar(1)
start_time	timestamp
end_time	timestamp
duration	int8
alert	varchar(1024)
input_bytes	int8
input_rows	int8
output_bytes	int8
output_rows	int8
blocks_read	int8
blocks_write	int8
local_read_io	int8
remote_read_io	int8
source	varchar(64)
data_skewness	int4
time_skewness	int4
is_active	varchar(1)
spilled_block_local_disk	int8
spilled_block_remote_disk	int8
step_attribute	varchar(64)

pg_catalog.stl_guid_cache_metrics

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

new
column	data type