Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
new	pg_catalog	internal	immutable	bool	is_object_sensitive_internal	super,int4
new	pg_catalog	internal	immutable	hllsketch	hll_import_sketch	text
new	pg_catalog	internal	immutable	super	get_sensitive_localizations_internal	None
new	pg_catalog	internal	immutable	super	get_sensitive_queries_internal	None
new	pg_catalog	internal	immutable	text	hll_export_sketch	hllsketch
new	pg_catalog	internal	stable	varchar	current_session_arn	None
new	pg_catalog	internal	stable	varchar	get_mounted_role	None
new	pg_catalog	internal	volatile	_record	pg_get_external_database_tables_extended	None
new	pg_catalog	internal	volatile	_record	pg_get_external_tables_extended	None

Tables

pg_catalog.stcs_commit_internal_time_breakdown

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
sb_version	int8			NN
step	char(64)			NN
step_start_time	int8			NN
step_total_time_us	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_explain_internal

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
plannode	char(400)			NN
startupcost	float8			NN
totalcost	float8			NN
rows	int8			NN
width	int8			NN
missingstats	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_megablock_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
scanned_mega_super	char(1)			NN
scanned_mega_varbyte	char(1)			NN
inserted_mega_super	char(1)			NN
inserted_mega_varbyte	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_state_gui_status

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
timestamp	int8			NN
start_time	int8			NN
num_nodes	int4			NN
num_sessions	int4			NN
total_queries	int4			NN
recent_queries	int4			NN
load_time	int8			NN
system_status	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_state_node_storage_capacity

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
timestamp	int8			NN
node	int4			NN
used	int8			NN
capacity	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_state_partitions

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
timestamp	int8			NN
owner	int4			NN
host	int4			NN
diskno	int4			NN
part_begin	int8			NN
part_end	int8			NN
used	int4			NN
tossed	int4			NN
capacity	int4			NN
reads	int8			NN
writes	int8			NN
seek_forward	int4			NN
seek_back	int4			NN
is_san	int4			NN
failed	int4			NN
mbps	int4			NN
mount	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_state_slices

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
timestamp	int8			NN
restart_trace_id	char(64)			NN
node	int4			NN
slice	int4			NN
localslice	int4			NN
type	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_state_table_column_metadata

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
timestamp	int8			NN
slice	int4			NN
table_id	int4			NN
column_id	int4			NN
num_blocks	int8			NN
row_count	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stll_commit_internal_time_breakdown

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
sb_version	int8			NN
step	char(64)			NN
step_start_time	timestamp			NN
step_total_time_us	float8			NN

pg_catalog.stll_explain_internal

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
plannode	char(400)			NN
startupcost	float8			NN
totalcost	float8			NN
rows	int8			NN
width	int8			NN
missingstats	int4			NN

pg_catalog.stll_megablock_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
scanned_mega_super	char(1)			NN
scanned_mega_varbyte	char(1)			NN
inserted_mega_super	char(1)			NN
inserted_mega_varbyte	char(1)			NN

pg_catalog.stll_state_gui_status

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
timestamp	int8			NN
start_time	timestamp			NN
num_nodes	int4			NN
num_sessions	int4			NN
total_queries	int4			NN
recent_queries	int4			NN
load_time	timestamp			NN
system_status	char(30)			NN

pg_catalog.stll_state_node_storage_capacity

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
timestamp	int8			NN
node	int4			NN
used	int8			NN
capacity	int8			NN

pg_catalog.stll_state_partitions

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
timestamp	int8			NN
owner	int4			NN
host	int4			NN
diskno	int4			NN
part_begin	int8			NN
part_end	int8			NN
used	int4			NN
tossed	int4			NN
capacity	int4			NN
reads	int8			NN
writes	int8			NN
seek_forward	int4			NN
seek_back	int4			NN
is_san	int4			NN
failed	int4			NN
mbps	int4			NN
mount	char(256)			NN

pg_catalog.stll_state_slices

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
timestamp	int8			NN
restart_trace_id	char(64)			NN
node	int4			NN
slice	int4			NN
localslice	int4			NN
type	char(1)			NN

pg_catalog.stll_state_table_column_metadata

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
timestamp	int8			NN
slice	int4			NN
table_id	int4			NN
column_id	int4			NN
num_blocks	int8			NN
row_count	int8			NN

pg_internal.redshift_auto_health_check_5806772

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_awsidc_refresh_token_worker

old
column	data type	PK	U	NN
vpid	int4			NN
starttime	int8			NN
endtime	int8			NN
num_session_monitored	int4			NN
num_session_revoked	int4			NN
revoked_sessions	char(250)			NN
exception	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
vpid	int4			NN
starttime	int8			NN
endtime	int8			NN
num_session_monitored	int4			NN
num_session_revoked	int4			NN
revoked_sessions	char(250)			NN
exception	int4			NN
num_sessions_with_exception	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_burst_manager_personalization

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

pg_catalog.stcs_burst_service_client

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

new
column	data type	PK	U	NN
action	char(10)			NN
pid	int8			NN
xid	int8			NN
eventtime	int8			NN
cluster_arn	char(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(80)			NN
burst_override_gucs	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_commit_stats

old
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
startqueue	int8			NN
startwork	int8			NN
endflush	int8			NN
endstage	int8			NN
endlocal	int8			NN
startglobal	int8			NN
endtime	int8			NN
queuelen	int8			NN
permblocks	int8			NN
newblocks	int8			NN
dirtyblocks	int8			NN
tombstonedblocks	int8			NN
tossedblocks	int8			NN
headers	int8			NN
numxids	int4			NN
oldestxid	int8			NN
extwritelatency	int8			NN
metadatawritten	int4			NN
batched_by	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
startqueue	int8			NN
startwork	int8			NN
endflush	int8			NN
endstage	int8			NN
endlocal	int8			NN
startglobal	int8			NN
endtime	int8			NN
queuelen	int8			NN
permblocks	int8			NN
newblocks	int8			NN
dirtyblocks	int8			NN
tombstonedblocks	int8			NN
tossedblocks	int8			NN
headers	int8			NN
numxids	int4			NN
oldestxid	int8			NN
extwritelatency	int8			NN
metadatawritten	int4			NN
batched_by	int8			NN
sb_version	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_datashare_request_consumer

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
initial_query_time	int8			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
api_call	int4			NN
starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
transaction_uid	char(50)			NN
retry_times	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
initial_query_time	int8			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
api_call	int4			NN
starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
transaction_uid	char(50)			NN
retry_times	int4			NN
producer_cluster_id	char(50)			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
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

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
producer_cluster_id	char(50)			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_internal_query_details

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
initial_query_time	int8			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
reported_peak_usage_bytes	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
exec_time_wo_compilation	int8			NN
exec_cluster_size	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
xid	int8			NN
initial_query_time	int8			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
reported_peak_usage_bytes	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
exec_time_wo_compilation	int8			NN
exec_cluster_size	int4			NN
auto_mounted_tables_accessed	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
query	int4			NN
decision_id	int4			NN
candidate_id	int4			NN
ssid	int4			NN
state	int4			NN
nodes	int4			NN
running_queries	int4			NN
queued_queries	int4			NN
est_exec_time_ms	int4			NN
spill_penalty_ms	int4			NN
est_prepare_delay_ms	int4			NN
est_queue_time_ms	int4			NN
penalty	float8			NN
eligible	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
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
other_active_query_runtime_ms	int4			NN
cost	float8			NN
other_active_cluster_cost	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_scaling_decisions

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

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
pid	int4			NN
userid	int4			NN
decision_id	int4			NN
decision_time	int8			NN
budget_rpu_sec	int8			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.stcs_wam_lifecycle

old
column	data type	PK	U	NN
record_time	int8			NN
wam_file_name	char(300)			NN
wam_action	char(50)			NN
wam_type_id	char(50)			NN
record_type_id	char(50)			NN
node	int4			NN
caller_description	char(100)			NN
number_of_records	int4			NN
precommit_id	int4			NN
restart_incarnation	char(50)			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
wam_file_name	char(300)			NN
wam_action	char(50)			NN
wam_type_id	char(50)			NN
record_type_id	char(50)			NN
node	int4			NN
caller_description	char(100)			NN
number_of_records	int4			NN
precommit_id	int4			NN
restart_incarnation	char(50)			NN
query_id	int8			NN
burst_wam_state	char(50)			NN
s3_region	char(50)			NN
s3_block_midfix	char(50)			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_awsidc_refresh_token_worker

old
column	data type	PK	U	NN
vpid	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
num_session_monitored	int4			NN
num_session_revoked	int4			NN
revoked_sessions	char(250)			NN
exception	int4			NN

new
column	data type	PK	U	NN
vpid	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
num_session_monitored	int4			NN
num_session_revoked	int4			NN
revoked_sessions	char(250)			NN
exception	int4			NN
num_sessions_with_exception	int4			NN

pg_catalog.stll_burst_manager_personalization

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

pg_catalog.stll_burst_service_client

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

new
column	data type	PK	U	NN
action	char(10)			NN
pid	int8			NN
xid	int8			NN
eventtime	timestamp			NN
cluster_arn	char(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(80)			NN
burst_override_gucs	char(256)			NN

pg_catalog.stll_commit_stats

old
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
startqueue	timestamp			NN
startwork	timestamp			NN
endflush	timestamp			NN
endstage	timestamp			NN
endlocal	timestamp			NN
startglobal	timestamp			NN
endtime	timestamp			NN
queuelen	int8			NN
permblocks	int8			NN
newblocks	int8			NN
dirtyblocks	int8			NN
tombstonedblocks	int8			NN
tossedblocks	int8			NN
headers	int8			NN
numxids	int4			NN
oldestxid	int8			NN
extwritelatency	int8			NN
metadatawritten	int4			NN
batched_by	int8			NN

new
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
startqueue	timestamp			NN
startwork	timestamp			NN
endflush	timestamp			NN
endstage	timestamp			NN
endlocal	timestamp			NN
startglobal	timestamp			NN
endtime	timestamp			NN
queuelen	int8			NN
permblocks	int8			NN
newblocks	int8			NN
dirtyblocks	int8			NN
tombstonedblocks	int8			NN
tossedblocks	int8			NN
headers	int8			NN
numxids	int4			NN
oldestxid	int8			NN
extwritelatency	int8			NN
metadatawritten	int4			NN
batched_by	int8			NN
sb_version	int8			NN

pg_catalog.stll_datashare_request_consumer

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
initial_query_time	timestamp			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
api_call	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
status	int4			NN
message	char(512)			NN
transaction_uid	char(50)			NN
retry_times	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
initial_query_time	timestamp			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
api_call	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
status	int4			NN
message	char(512)			NN
transaction_uid	char(50)			NN
retry_times	int4			NN
producer_cluster_id	char(50)			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
consumer_region	char(64)			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
producer_cluster_id	char(50)			NN

pg_catalog.stll_internal_query_details

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
initial_query_time	timestamp			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
reported_peak_usage_bytes	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
exec_time_wo_compilation	int8			NN
exec_cluster_size	int4			NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
initial_query_time	timestamp			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
reported_peak_usage_bytes	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
exec_time_wo_compilation	int8			NN
exec_cluster_size	int4			NN
auto_mounted_tables_accessed	int4			NN

pg_catalog.stll_sage_scaling_candidates

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

new
column	data type	PK	U	NN
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
other_active_query_runtime_ms	int4			NN
cost	float8			NN
other_active_cluster_cost	float8			NN

pg_catalog.stll_sage_scaling_decisions

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

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
pid	int4			NN
userid	int4			NN
decision_id	int4			NN
decision_time	timestamp			NN
budget_rpu_sec	int8			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.stll_wam_lifecycle

old
column	data type	PK	U	NN
record_time	timestamp			NN
wam_file_name	char(300)			NN
wam_action	char(50)			NN
wam_type_id	char(50)			NN
record_type_id	char(50)			NN
node	int4			NN
caller_description	char(100)			NN
number_of_records	int4			NN
precommit_id	int4			NN
restart_incarnation	char(50)			NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
wam_file_name	char(300)			NN
wam_action	char(50)			NN
wam_type_id	char(50)			NN
record_type_id	char(50)			NN
node	int4			NN
caller_description	char(100)			NN
number_of_records	int4			NN
precommit_id	int4			NN
restart_incarnation	char(50)			NN
query_id	int8			NN
burst_wam_state	char(50)			NN
s3_region	char(50)			NN
s3_block_midfix	char(50)			NN

pg_catalog.stv_guid_cache

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

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

pg_internal.redshift_auto_health_check_3156179

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_commit_internal_time_breakdown

old
column	data type

new
column	data type
xid	int8
node	int4
sb_version	int8
step	char(64)
step_start_time	timestamp
step_total_time_us	float8

pg_catalog.stl_explain_internal

old
column	data type

new
column	data type
userid	int4
query	int4
nodeid	int4
parentid	int4
plannode	char(400)
startupcost	float8
totalcost	float8
rows	int8
width	int8
missingstats	int4

pg_catalog.stl_megablock_stats

old
column	data type

new
column	data type
query	int4
slice	int4
segment	int4
step	int4
scanned_mega_super	char(1)
scanned_mega_varbyte	char(1)
inserted_mega_super	char(1)
inserted_mega_varbyte	char(1)

pg_catalog.stl_state_gui_status

old
column	data type

new
column	data type
timestamp	int8
start_time	timestamp
num_nodes	int4
num_sessions	int4
total_queries	int4
recent_queries	int4
load_time	timestamp
system_status	char(30)

pg_catalog.stl_state_node_storage_capacity

old
column	data type

new
column	data type
timestamp	int8
node	int4
used	int8
capacity	int8

pg_catalog.stl_state_partitions

old
column	data type

new
column	data type
timestamp	int8
owner	int4
host	int4
diskno	int4
part_begin	int8
part_end	int8
used	int4
tossed	int4
capacity	int4
reads	int8
writes	int8
seek_forward	int4
seek_back	int4
is_san	int4
failed	int4
mbps	int4
mount	char(256)

pg_catalog.stl_state_slices

old
column	data type

new
column	data type
timestamp	int8
restart_trace_id	char(64)
node	int4
slice	int4
localslice	int4
type	char(1)

pg_catalog.stl_state_table_column_metadata

old
column	data type

new
column	data type
timestamp	int8
slice	int4
table_id	int4
column_id	int4
num_blocks	int8
row_count	int8

pg_catalog.sys_child_query_text

old
column	data type

new
column	data type
user_id	int4
query_id	int8
child_query_sequence	int4
sequence	int4
text	char(200)

pg_catalog.stl_awsidc_refresh_token_worker

old
column	data type
vpid	int4
starttime	timestamp
endtime	timestamp
num_session_monitored	int4
num_session_revoked	int4
revoked_sessions	char(250)
exception	int4

new
column	data type
vpid	int4
starttime	timestamp
endtime	timestamp
num_session_monitored	int4
num_session_revoked	int4
revoked_sessions	char(250)
exception	int4
num_sessions_with_exception	int4

pg_catalog.stl_burst_manager_personalization

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

pg_catalog.stl_burst_service_client

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

new
column	data type
action	char(10)
pid	int8
xid	int8
eventtime	timestamp
cluster_arn	char(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(80)
burst_override_gucs	char(256)

pg_catalog.stl_commit_stats

old
column	data type
xid	int8
node	int4
startqueue	timestamp
startwork	timestamp
endflush	timestamp
endstage	timestamp
endlocal	timestamp
startglobal	timestamp
endtime	timestamp
queuelen	int8
permblocks	int8
newblocks	int8
dirtyblocks	int8
tombstonedblocks	int8
tossedblocks	int8
headers	int8
numxids	int4
oldestxid	int8
extwritelatency	int8
metadatawritten	int4
batched_by	int8

new
column	data type
xid	int8
node	int4
startqueue	timestamp
startwork	timestamp
endflush	timestamp
endstage	timestamp
endlocal	timestamp
startglobal	timestamp
endtime	timestamp
queuelen	int8
permblocks	int8
newblocks	int8
dirtyblocks	int8
tombstonedblocks	int8
tossedblocks	int8
headers	int8
numxids	int4
oldestxid	int8
extwritelatency	int8
metadatawritten	int4
batched_by	int8
sb_version	int8

pg_catalog.stl_datashare_request_consumer

old
column	data type
userid	int4
xid	int8
pid	int4
initial_query_time	timestamp
requestid	char(50)
sb_version	int8
dbtype	int4
dbid	int4
api_call	int4
starttime	timestamp
endtime	timestamp
status	int4
message	char(512)
transaction_uid	char(50)
retry_times	int4

new
column	data type
userid	int4
xid	int8
pid	int4
initial_query_time	timestamp
requestid	char(50)
sb_version	int8
dbtype	int4
dbid	int4
api_call	int4
starttime	timestamp
endtime	timestamp
status	int4
message	char(512)
transaction_uid	char(50)
retry_times	int4
producer_cluster_id	char(50)

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
consumer_region	char(64)

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)
producer_cluster_id	char(50)

pg_catalog.stl_internal_query_details

old
column	data type
query	int4
xid	int8
initial_query_time	timestamp
seldispatch_status	int4
query_cmd_type	int4
user_temp_tables_accessed	int4
volt_temp_tables_accessed	int4
spectrum_tables_accessed	int4
user_perm_tables_accessed	int4
system_tables_accessed	int4
query_target_table_type	int4
memory_demanding_info	int8
nobackup_tables_accessed	int4
zindex_tables_accessed	int4
pg_tables_accessed	int4
dirty_tables_read	int4
wlm_slot_type	char(8)
is_short_query	int4
reported_peak_usage_bytes	int8
wlm_query_memory	int8
datasharing_tables_accessed	int4
uses_new_cost_model	char(1)
new_model_reason	int4
num_rowsets	int4
xregion_datasharing_tables_accessed	int4
result_cache_miss_reason	int4
cs_node_nums	int4
is_multi	int4
is_burst_for_at_task	int4
user_query_id	int8
lf_datasharing_tables_accessed	int4
qpc_source_qid	int8
exec_time_wo_compilation	int8
exec_cluster_size	int4

new
column	data type
query	int4
xid	int8
initial_query_time	timestamp
seldispatch_status	int4
query_cmd_type	int4
user_temp_tables_accessed	int4
volt_temp_tables_accessed	int4
spectrum_tables_accessed	int4
user_perm_tables_accessed	int4
system_tables_accessed	int4
query_target_table_type	int4
memory_demanding_info	int8
nobackup_tables_accessed	int4
zindex_tables_accessed	int4
pg_tables_accessed	int4
dirty_tables_read	int4
wlm_slot_type	char(8)
is_short_query	int4
reported_peak_usage_bytes	int8
wlm_query_memory	int8
datasharing_tables_accessed	int4
uses_new_cost_model	char(1)
new_model_reason	int4
num_rowsets	int4
xregion_datasharing_tables_accessed	int4
result_cache_miss_reason	int4
cs_node_nums	int4
is_multi	int4
is_burst_for_at_task	int4
user_query_id	int8
lf_datasharing_tables_accessed	int4
qpc_source_qid	int8
exec_time_wo_compilation	int8
exec_cluster_size	int4
auto_mounted_tables_accessed	int4

pg_catalog.stl_sage_scaling_candidates

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

new
column	data type
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
other_active_query_runtime_ms	int4
cost	float8
other_active_cluster_cost	float8

pg_catalog.stl_sage_scaling_decisions

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

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

pg_catalog.stl_wam_lifecycle

old
column	data type
record_time	timestamp
wam_file_name	char(300)
wam_action	char(50)
wam_type_id	char(50)
record_type_id	char(50)
node	int4
caller_description	char(100)
number_of_records	int4
precommit_id	int4
restart_incarnation	char(50)

new
column	data type
record_time	timestamp
wam_file_name	char(300)
wam_action	char(50)
wam_type_id	char(50)
record_type_id	char(50)
node	int4
caller_description	char(100)
number_of_records	int4
precommit_id	int4
restart_incarnation	char(50)
query_id	int8
burst_wam_state	char(50)
s3_region	char(50)
s3_block_midfix	char(50)