Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
new	pg_catalog	internal	immutable	int4	size	super
new	pg_catalog	internal	immutable	int8	connect_by_level	None

Tables

pg_catalog.stcs_burst_id_col_highwatermark

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
log_time	int8			NN
log_type	int4			NN
query	int8			NN
tbl_id	int4			NN
col_id	int4			NN
burst_slice	int4			NN
main_slice	int4			NN
highwatermark	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_cqi_metrics

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
pid	int4			NN
starttime	int8			NN
endtime	int8			NN
component_name	char(48)			NN
phase	char(48)			NN
restart_id	char(64)			NN
message	char(512)			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_executor_steps

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
recordtime	int8			NN
query	int4			NN
stream_num	int4			NN
segment	int4			NN
subplan_level	int4			NN
subplan_id	int4			NN
steps	char(2048)			NN
supports_executor	char(128)			NN
code_item_was_cached	int4			NN
compile	int4			NN
is_short_query	int4			NN
is_short_query_debug_compile	int4			NN
expression_oids	char(500)			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_grouping_sets

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
slice	int4			NN
dist_grouping_set	int4			NN
grouping_set_id	int4			NN
rows	int8			NN
bytes	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_kafka_scan_errors

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
timestamp_type	char(1)			NN
kafka_timestamp	int8			NN
record_time	int8			NN
schema_name	char(128)			NN
topic_name	char(255)			NN
partition_id	int8			NN
record_offset	int8			NN
err_code	int4			NN
err_reason	char(128)			NN
raw_data	char(1024)			NN
mv_name	char(128)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_kafka_scan_states

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	int8			NN
schema_name	char(128)			NN
topic_name	char(255)			NN
partition_id	int8			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_offset	int8			NN
min_arrival_time	int8			NN
max_arrival_time	int8			NN
mv_name	char(128)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_lbc_replay_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
replay_type	char(32)			NN
node	int4			NN
start_time	int8			NN
end_time	int8			NN
index_seen	int4			NN
index_applied	int4			NN
active_seen	int4			NN
active_applied	int4			NN
inactive_seen	int4			NN
inactive_applied	int4			NN
checkpoint_seen	int4			NN
checkpoint_applied	int4			NN
log_blocks_seen	int4			NN
encrypted_log_blocks_seen	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_perf_channel_sink

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query_id	int4			NN
segment_number	int4			NN
slice_number	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
channel_type	int4			NN
channel_id	int4			NN
first_packet_time	int8			NN
last_packet_time	int8			NN
close_time	int8			NN
throughput_kilobytes_per_sec	int8			NN
xoff_total_time	int8			NN
xoff_max_time	int8			NN
queue_delay_total_time	int8			NN
queue_delay_max_time	int8			NN
rexmit_total_count	int8			NN
rexmit_max_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.stcs_perf_channel_source

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query_id	int4			NN
segment_number	int4			NN
slice_number	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
channel_type	int4			NN
channel_id	int4			NN
first_packet_time	int8			NN
last_packet_time	int8			NN
close_time	int8			NN
throughput_kilobytes_per_sec	int8			NN
borrow_total_time	int8			NN
borrow_max_time	int8			NN
queue_delay_total_time	int8			NN
queue_delay_max_time	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_s3commit_dm_guids

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	int8			NN
node	int4			NN
dm_name	char(300)			NN
guid	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_superblock_tree_events

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
eventtime	int8			NN
xid	int8			NN
process	char(32)			NN
pid	int4			NN
node	int4			NN
is_error	int4			NN
filename	char(80)			NN
linenum	int4			NN
context	char(48)			NN
message	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_superblock_trickle_validation_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
record_time	int8			NN
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_entries_validated	int8			NN
log_blocks_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
trickle_validation_done	int4			NN
log_rotation	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_truncate_history

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
logtime	int8			NN
xid	int8			NN
table_id	int4			NN
table_name	char(128)			NN
is_temp	int4			NN
is_safe	int4			NN
is_extended_protocol	int4			NN
is_user	int4			NN
query_text	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.stll_burst_id_col_highwatermark

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
log_time	timestamp			NN
log_type	int4			NN
query	int8			NN
tbl_id	int4			NN
col_id	int4			NN
burst_slice	int4			NN
main_slice	int4			NN
highwatermark	int8			NN

pg_catalog.stll_cqi_metrics

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
pid	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
component_name	char(48)			NN
phase	char(48)			NN
restart_id	char(64)			NN
message	char(512)			NN

pg_catalog.stll_executor_steps

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
query	int4			NN
stream_num	int4			NN
segment	int4			NN
subplan_level	int4			NN
subplan_id	int4			NN
steps	char(2048)			NN
supports_executor	char(128)			NN
code_item_was_cached	int4			NN
compile	int4			NN
is_short_query	int4			NN
is_short_query_debug_compile	int4			NN
expression_oids	char(500)			NN

pg_catalog.stll_grouping_sets

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
slice	int4			NN
dist_grouping_set	int4			NN
grouping_set_id	int4			NN
rows	int8			NN
bytes	int8			NN

pg_catalog.stll_kafka_scan_errors

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
timestamp_type	char(1)			NN
kafka_timestamp	timestamp			NN
record_time	timestamp			NN
schema_name	char(128)			NN
topic_name	char(255)			NN
partition_id	int8			NN
record_offset	int8			NN
err_code	int4			NN
err_reason	char(128)			NN
raw_data	char(1024)			NN
mv_name	char(128)			NN

pg_catalog.stll_kafka_scan_states

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	timestamp			NN
schema_name	char(128)			NN
topic_name	char(255)			NN
partition_id	int8			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_offset	int8			NN
min_arrival_time	timestamp			NN
max_arrival_time	timestamp			NN
mv_name	char(128)			NN

pg_catalog.stll_lbc_replay_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
replay_type	char(32)			NN
node	int4			NN
start_time	timestamp			NN
end_time	timestamp			NN
index_seen	int4			NN
index_applied	int4			NN
active_seen	int4			NN
active_applied	int4			NN
inactive_seen	int4			NN
inactive_applied	int4			NN
checkpoint_seen	int4			NN
checkpoint_applied	int4			NN
log_blocks_seen	int4			NN
encrypted_log_blocks_seen	int4			NN

pg_catalog.stll_perf_channel_sink

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query_id	int4			NN
segment_number	int4			NN
slice_number	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
channel_type	int4			NN
channel_id	int4			NN
first_packet_time	timestamp			NN
last_packet_time	timestamp			NN
close_time	timestamp			NN
throughput_kilobytes_per_sec	int8			NN
xoff_total_time	int8			NN
xoff_max_time	int8			NN
queue_delay_total_time	int8			NN
queue_delay_max_time	int8			NN
rexmit_total_count	int8			NN
rexmit_max_count	int8			NN

pg_catalog.stll_perf_channel_source

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query_id	int4			NN
segment_number	int4			NN
slice_number	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
channel_type	int4			NN
channel_id	int4			NN
first_packet_time	timestamp			NN
last_packet_time	timestamp			NN
close_time	timestamp			NN
throughput_kilobytes_per_sec	int8			NN
borrow_total_time	int8			NN
borrow_max_time	int8			NN
queue_delay_total_time	int8			NN
queue_delay_max_time	int8			NN

pg_catalog.stll_s3commit_dm_guids

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	timestamp			NN
node	int4			NN
dm_name	char(300)			NN
guid	char(64)			NN

pg_catalog.stll_superblock_tree_events

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
eventtime	timestamp			NN
xid	int8			NN
process	char(32)			NN
pid	int4			NN
node	int4			NN
is_error	int4			NN
filename	char(80)			NN
linenum	int4			NN
context	char(48)			NN
message	char(256)			NN

pg_catalog.stll_superblock_trickle_validation_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
record_time	timestamp			NN
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_entries_validated	int8			NN
log_blocks_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
trickle_validation_done	int4			NN
log_rotation	int4			NN

pg_catalog.stll_truncate_history

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
logtime	timestamp			NN
xid	int8			NN
table_id	int4			NN
table_name	char(128)			NN
is_temp	int4			NN
is_safe	int4			NN
is_extended_protocol	int4			NN
is_user	int4			NN
query_text	char(256)			NN

pg_catalog.stv_superblock_tree_entries

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
tbl	int4			NN
col	int4			NN
slice	int4			NN
blocknum	int4			NN
sb_pos	int4			NN
next_sb_pos	int4			NN
id	char(36)			NN
block_len	int4			NN
num_reps	int4			NN
num_values	int4			NN
min	int8			NN
max	int8			NN
pinned	int4			NN
on_disk	int4			NN
backed_up	int4			NN
flags	int4			NN

pg_internal.redshift_auto_health_check_1811921

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_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
__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
__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
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

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

old
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
prefetchesskipped	int8			NN
numreadsprocessed	int8			NN
numacksprocessed	int8			NN
tablebasedtosseligible	int4			NN
lastackwaittime	float8			NN
processtime	float8			NN
log_based	int4			NN
log_based_flags	int4			NN
index_log_regenerated	int4			NN
tables_total	int4			NN
tables_swept	int4			NN
headers_swept	int8			NN
tables_changed	int4			NN
blocks_pending_write	int8			NN
num_metadata_blocks_retained	int4			NN
total_metadata_blocks	int4			NN
sb_size	int8			NN
num_modified_hdrs_tracked	int8			NN
sb_sweep_tracking	int4			NN
sb_version	int8			NN
sb_sweep_optimized_commit	int4			NN
metadata_delta_validated	int4			NN
pendingwritesissued	int8			NN
sb_tree_blocks	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
prefetchesskipped	int8			NN
numreadsprocessed	int8			NN
numacksprocessed	int8			NN
tablebasedtosseligible	int4			NN
lastackwaittime	float8			NN
processtime	float8			NN
log_based	int4			NN
log_based_flags	int4			NN
index_log_regenerated	int4			NN
tables_total	int4			NN
tables_swept	int4			NN
headers_swept	int8			NN
tables_changed	int4			NN
blocks_pending_write	int8			NN
num_metadata_blocks_retained	int4			NN
total_metadata_blocks	int4			NN
sb_size	int8			NN
num_modified_hdrs_tracked	int8			NN
sb_sweep_tracking	int4			NN
sb_version	int8			NN
sb_sweep_optimized_commit	int4			NN
metadata_delta_validated	int4			NN
pendingwritesissued	int8			NN
sb_tree_blocks	int8			NN
log_blocks_written	int4			NN
encrypted_log_blocks_written	int4			NN
new_sb_tree_blocks	int8			NN
tossed_sb_tree_blocks	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_disk_cache_stats

old
column	data type	PK	U	NN
logtime	int8			NN
adds	int8			NN
new_blocks	int8			NN
dbr_blocks	int8			NN
pins	int8			NN
faults	int8			NN
throttles	int8			NN
scan_starts	int8			NN
cache_size	int4			NN
lru_size	int4			NN
throttle	int8			NN
ra_points	float8			NN
scans_running	int4			NN
evictions	int8			NN
prefetches	int8			NN
node	int4			NN
max_size	int4			NN
max_pushout_latency_us	int8			NN
rowset_blocks_spilled	int8			NN
rerep_write_skipped_exhausted_write_pool	int8			NN
max_rowsets_pinned	int8			NN
rowsets_currently_in_cache	int8			NN
rowsets_currently_pinned	int8			NN
accesses_to_outstanding_req	int8			NN
percentage_shared_mem_used	int4			NN
max_percentage_shared_mem_used	int4			NN
disk_upgrade_requests	int8			NN
successful_disk_upgrades	int8			NN
disk_upgrades_dropped	int8			NN
disk_upgrades_not_useful	int8			NN
s3_upgrade_requests	int8			NN
successful_s3_upgrades	int8			NN
s3_upgrades_dropped	int8			NN
num_upsizings	int8			NN
num_downsizings	int8			NN
largest_size_limit	int8			NN
smallest_size_limit	int8			NN
avg_size_limit	int8			NN
oom_eviction_calls	int4			NN
num_pushout_downsizings	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
logtime	int8			NN
adds	int8			NN
new_blocks	int8			NN
dbr_blocks	int8			NN
pins	int8			NN
faults	int8			NN
throttles	int8			NN
scan_starts	int8			NN
cache_size	int4			NN
lru_size	int4			NN
throttle	int8			NN
ra_points	float8			NN
scans_running	int4			NN
evictions	int8			NN
prefetches	int8			NN
node	int4			NN
max_size	int4			NN
max_pushout_latency_us	int8			NN
rowset_blocks_spilled	int8			NN
rerep_write_skipped_exhausted_write_pool	int8			NN
max_rowsets_pinned	int8			NN
rowsets_currently_in_cache	int8			NN
rowsets_currently_pinned	int8			NN
accesses_to_outstanding_req	int8			NN
percentage_shared_mem_used	int4			NN
max_percentage_shared_mem_used	int4			NN
disk_upgrade_requests	int8			NN
successful_disk_upgrades	int8			NN
disk_upgrades_dropped	int8			NN
disk_upgrades_not_useful	int8			NN
s3_upgrade_requests	int8			NN
successful_s3_upgrades	int8			NN
s3_upgrades_dropped	int8			NN
num_upsizings	int8			NN
num_downsizings	int8			NN
largest_size_limit	int8			NN
smallest_size_limit	int8			NN
avg_size_limit	int8			NN
oom_eviction_calls	int4			NN
num_pushout_downsizings	int8			NN
dirty_block_size	int8			NN
dirty_rowset_block_size	int8			NN
max_dirty_block_size	int8			NN
max_dirty_rowset_block_size	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_disk_cache_write

old
column	data type	PK	U	NN
blocks_pushed	int4			NN
blocks_instant_pushed	int4			NN
avg_lru_size_before_push	int4			NN
push_attempts	int4			NN
pending_writes_push	int4			NN
pending_reads_push	int4			NN
blocks_written_back	int4			NN
writeback_preempts	int4			NN
avg_lru_size_before_writeback	int4			NN
writeback_attempts	int4			NN
pending_writes_writeback	int4			NN
pending_reads_writeback	int4			NN
avg_push_time_microsec	int8			NN
avg_writeback_time_microsec	int8			NN
sample_start_time	int8			NN
sample_end_time	int8			NN
node	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
blocks_pushed	int4			NN
blocks_instant_pushed	int4			NN
avg_lru_size_before_push	int4			NN
push_attempts	int4			NN
pending_writes_push	int4			NN
pending_reads_push	int4			NN
blocks_written_back	int4			NN
writeback_preempts	int4			NN
avg_lru_size_before_writeback	int4			NN
writeback_attempts	int4			NN
pending_writes_writeback	int4			NN
pending_reads_writeback	int4			NN
avg_push_time_microsec	int8			NN
avg_writeback_time_microsec	int8			NN
sample_start_time	int8			NN
sample_end_time	int8			NN
node	int4			NN
rowsets_pushed	int4			NN
rowsets_instant_pushed	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_external_catalog_calls

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
uuid	char(36)			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
eventtime	int8			NN
call	int4			NN
objects	int4			NN
duration	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
query	int4			NN
uuid	char(36)			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
eventtime	int8			NN
call	int4			NN
objects	int4			NN
duration	int8			NN
catalog_type	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_external_query_detail_base

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
pid	int4			NN
xid	int8			NN
segment_id	int4			NN
node	int4			NN
slice	int4			NN
table_name	char(256)			NN
sourcetype	char(32)			NN
eventtime	int8			NN
starttime	int8			NN
endtime	int8			NN
duration	int8			NN
total_partitions	int4			NN
qualified_partitions	int4			NN
total_files	int4			NN
files_scanned	int4			NN
num_rows	int8			NN
num_bytes	int8			NN
file_format	char(16)			NN
location	char(256)			NN
pg_query_text	char(4000)			NN
logging_tag	char(32)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

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

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	int8			NN
request_type	char(64)			NN
request_payload	char(4096)			NN
err_reason	char(128)			NN
shard_id	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
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	int8			NN
request_type	char(64)			NN
request_payload	char(4096)			NN
err_reason	char(128)			NN
shard_id	char(128)			NN
mv_name	char(128)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_kinesis_scan_errors

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
arrival_time	int8			NN
record_time	int8			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
seq_num	char(128)			NN
err_code	int4			NN
err_reason	char(128)			NN
raw_data	char(1024)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
arrival_time	int8			NN
record_time	int8			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
seq_num	char(128)			NN
err_code	int4			NN
err_reason	char(128)			NN
raw_data	char(1024)			NN
mv_name	char(128)			NN
timestamp_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_kinesis_scan_states

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	int8			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_seq_num	char(128)			NN
millis_behind_latest	int8			NN
worker_bytes	int8			NN
queue_bytes	int8			NN
scheduling_period	int8			NN
request_duration	int8			NN
tardiness	int8			NN
min_arrival_time	int8			NN
max_arrival_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
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	int8			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_seq_num	char(128)			NN
millis_behind_latest	int8			NN
worker_bytes	int8			NN
queue_bytes	int8			NN
scheduling_period	int8			NN
request_duration	int8			NN
tardiness	int8			NN
min_arrival_time	int8			NN
max_arrival_time	int8			NN
mv_name	char(128)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_lambda_client

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
request_id	char(100)			NN
function_name	char(100)			NN
recordtime	int8			NN
num_records	int4			NN
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
node	int4			NN
slice	int4			NN
segment	int4			NN
request_id	char(100)			NN
function_name	char(100)			NN
recordtime	int8			NN
num_records	int4			NN
size	int4			NN
queue_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_lambda_execution_logs

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
request_id	char(100)			NN
recordtime	int8			NN
execution_logs	char(4096)			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
node	int4			NN
slice	int4			NN
request_id	char(100)			NN
recordtime	int8			NN
execution_logs	char(4096)			NN
queue_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_lambda_invocation_error

old
column	data type	PK	U	NN
query	int4			NN
recordtime	int8			NN
message	char(1024)			NN
node	int4			NN
slice	int4			NN
request_id	char(100)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
query	int4			NN
recordtime	int8			NN
message	char(1024)			NN
node	int4			NN
slice	int4			NN
request_id	char(100)			NN
queue_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_mv_refresh

old
column	data type	PK	U	NN
userid	int8			NN
xid	int8			NN
starttime	int8			NN
endtime	int8			NN
schemaoid	int8			NN
mvoid	int8			NN
status	int4			NN
refresh_type	char(32)			NN
db_oid	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	int8			NN
xid	int8			NN
starttime	int8			NN
endtime	int8			NN
schemaoid	int8			NN
mvoid	int8			NN
status	int4			NN
refresh_type	char(32)			NN
db_oid	int8			NN
no_new_rows	char(1)			NN
skipped_rows	char(1)			NN
may_have_more_rows	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_s3commit_stats

old
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
start_time	int8			NN
end_time	int8			NN
s3_write_untagged_latency	int8			NN
s3_write_add_tag_latency	int8			NN
s3_write_delete_tag_latency	int8			NN
num_untagged_s3_writes	int8			NN
num_add_tags_issued_to_s3	int8			NN
num_delete_tags_issued_to_s3	int8			NN
dynamo_write_avg_latency_usec	int8			NN
synced_commits_to_s3	int4			NN
s3commit_enable_latency	int8			NN
s3commit_disable_latency	int8			NN
dynamo_get_avg_latency_usec	int8			NN
num_tossed_guids	int8			NN
num_tombstoned_guids	int8			NN
num_untagged_untracked	int8			NN
num_tossed_tagless_s3_writes	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

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

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
uuid	char(36)			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
starttime	int8			NN
endtime	int8			NN
external_table_name	char(136)			NN
is_partitioned	char(1)			NN
is_rrscan	char(1)			NN
s3_scanned_rows	int8			NN
s3_scanned_bytes	int8			NN
s3query_returned_rows	int8			NN
s3query_returned_bytes	int8			NN
files	int4			NN
total_retries	int4			NN
max_retries	int4			NN
max_request_duration	int8			NN
avg_request_duration	int8			NN
max_request_parallelism	int4			NN
max_allowed_parallelism	int4			NN
avg_request_parallelism	float8			NN
splits	int4			NN
total_split_size	int8			NN
max_split_size	int8			NN
request_fingerprint	int8			NN
file_format	char(16)			NN
cache_hits	int4			NN
is_copy	int4			NN
is_nested	char(1)			NN
slowdown_count	int4			NN
max_concurrent_slowdown_count	int4			NN
s3_billable_scanned_bytes	int8			NN
scan_type	int4			NN
s3query_returned_uncompressed_bytes	int8			NN
is_lakeformation	int4			NN
is_governed	int4			NN
transaction_id	char(32)			NN
query_as_of_time	int8			NN
throttled_requests	int4			NN
peakmem	int8			NN
is_local	int4			NN
is_evr	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
uuid	char(36)			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
starttime	int8			NN
endtime	int8			NN
external_table_name	char(136)			NN
is_partitioned	char(1)			NN
is_rrscan	char(1)			NN
s3_scanned_rows	int8			NN
s3_scanned_bytes	int8			NN
s3query_returned_rows	int8			NN
s3query_returned_bytes	int8			NN
files	int4			NN
total_retries	int4			NN
max_retries	int4			NN
max_request_duration	int8			NN
avg_request_duration	int8			NN
max_request_parallelism	int4			NN
max_allowed_parallelism	int4			NN
avg_request_parallelism	float8			NN
splits	int4			NN
total_split_size	int8			NN
max_split_size	int8			NN
request_fingerprint	int8			NN
file_format	char(16)			NN
cache_hits	int4			NN
is_copy	int4			NN
is_nested	char(1)			NN
slowdown_count	int4			NN
max_concurrent_slowdown_count	int4			NN
s3_billable_scanned_bytes	int8			NN
scan_type	int4			NN
s3query_returned_uncompressed_bytes	int8			NN
is_lakeformation	int4			NN
is_governed	int4			NN
transaction_id	char(32)			NN
query_as_of_time	int8			NN
throttled_requests	int4			NN
peakmem	int8			NN
is_local	int4			NN
is_evr	int4			NN
has_cell_level_security	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_scan

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
fetches	int8			NN
type	int4			NN
tbl	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
rows_pre_filter	int8			NN
rows_pre_user_filter	int8			NN
perm_table_name	char(136)			NN
is_rlf_scan	char(1)			NN
is_rlf_scan_reason	int4			NN
num_em_blocks	int4			NN
checksum	int8			NN
runtime_filtering	char(1)			NN
scan_region	int4			NN
num_sortkey_as_predicate	int4			NN
row_fetcher_state	int4			NN
consumed_scan_ranges	int8			NN
work_stealing_reason	int8			NN
is_vectorized_scan	char(1)			NN
is_vectorized_scan_reason	int4			NN
row_fetcher_reason	int8			NN
topology_signature	int8			NN
use_tpm_partition	char(1)			NN
is_rrscan_expr	char(1)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
fetches	int8			NN
type	int4			NN
tbl	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
rows_pre_filter	int8			NN
rows_pre_user_filter	int8			NN
perm_table_name	char(136)			NN
is_rlf_scan	char(1)			NN
is_rlf_scan_reason	int4			NN
num_em_blocks	int4			NN
checksum	int8			NN
runtime_filtering	char(1)			NN
scan_region	int4			NN
num_sortkey_as_predicate	int4			NN
row_fetcher_state	int4			NN
consumed_scan_ranges	int8			NN
work_stealing_reason	int8			NN
is_vectorized_scan	char(1)			NN
is_vectorized_scan_reason	int4			NN
row_fetcher_reason	int8			NN
topology_signature	int8			NN
use_tpm_partition	char(1)			NN
is_rrscan_expr	char(1)			NN
use_fwd_mtx_opt	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_superblock

old
column	data type	PK	U	NN
node	int4			NN
record_time	int8			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	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
node	int4			NN
record_time	int8			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	int4			NN
sb_tree_root_pos	int4			NN
sb_tree_height	int4			NN
sb_tree_mode	int4			NN
sb_tree_blocks	int4			NN
sb_tree_root_guid	char(36)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_user_query_history

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
label	char(32)			NN
xid	int8			NN
pid	int4			NN
database_name	char(128)			NN
query_type	char(32)			NN
status	char(10)			NN
result_cache_source_query	int8			NN
start_time	int8			NN
end_time	int8			NN
queue_time	int8			NN
execution_time	int8			NN
error_message	char(512)			NN
returned_rows	int8			NN
returned_bytes	int8			NN
redshift_version	char(32)			NN
usage_limit	char(150)			NN
internal_query	char(1)			NN
query_text	char(4000)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database_name	char(128)			NN
query_type	char(32)			NN
status	char(10)			NN
result_cache_source_query	int8			NN
start_time	int8			NN
end_time	int8			NN
queue_time	int8			NN
execution_time	int8			NN
error_message	char(512)			NN
returned_rows	int8			NN
returned_bytes	int8			NN
redshift_version	char(32)			NN
usage_limit	char(150)			NN
internal_query	char(1)			NN
query_text	char(4000)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_version

old
column	data type	PK	U	NN
bootstrap_time	int8			NN
db_version	char(50)			NN
restart_reason	char(100)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
bootstrap_time	int8			NN
db_version	char(50)			NN
restart_reason	char(100)			NN
restart_trace_id	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_xregion_metering

old
column	data type	PK	U	NN
eventtime	int8			NN
query	int8			NN
region	char(30)			NN
internal_request_uuid	char(36)			NN
metered_mbs	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
eventtime	int8			NN
query	int8			NN
region	char(30)			NN
internal_request_uuid	char(36)			NN
metered_mbs	int8			NN
transferred_data	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_xrestore

old
column	data type	PK	U	NN
backup_id	char(256)			NN
node	int4			NN
catalog_download_start_time	int8			NN
catalog_download_end_time	int8			NN
slice_transfer_start_time	int8			NN
slice_transfer_end_time	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
backup_id	char(256)			NN
node	int4			NN
catalog_download_start_time	int8			NN
catalog_download_end_time	int8			NN
slice_transfer_start_time	int8			NN
slice_transfer_end_time	int8			NN
guid_pool_hit_rate	float8			NN
num_guids_created_on_demand	int4			NN
__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

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

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

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

pg_catalog.stll_commit_internal_stats

old
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
prefetchesskipped	int8			NN
numreadsprocessed	int8			NN
numacksprocessed	int8			NN
tablebasedtosseligible	int4			NN
lastackwaittime	float8			NN
processtime	float8			NN
log_based	int4			NN
log_based_flags	int4			NN
index_log_regenerated	int4			NN
tables_total	int4			NN
tables_swept	int4			NN
headers_swept	int8			NN
tables_changed	int4			NN
blocks_pending_write	int8			NN
num_metadata_blocks_retained	int4			NN
total_metadata_blocks	int4			NN
sb_size	int8			NN
num_modified_hdrs_tracked	int8			NN
sb_sweep_tracking	int4			NN
sb_version	int8			NN
sb_sweep_optimized_commit	int4			NN
metadata_delta_validated	int4			NN
pendingwritesissued	int8			NN
sb_tree_blocks	int8			NN

new
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
prefetchesskipped	int8			NN
numreadsprocessed	int8			NN
numacksprocessed	int8			NN
tablebasedtosseligible	int4			NN
lastackwaittime	float8			NN
processtime	float8			NN
log_based	int4			NN
log_based_flags	int4			NN
index_log_regenerated	int4			NN
tables_total	int4			NN
tables_swept	int4			NN
headers_swept	int8			NN
tables_changed	int4			NN
blocks_pending_write	int8			NN
num_metadata_blocks_retained	int4			NN
total_metadata_blocks	int4			NN
sb_size	int8			NN
num_modified_hdrs_tracked	int8			NN
sb_sweep_tracking	int4			NN
sb_version	int8			NN
sb_sweep_optimized_commit	int4			NN
metadata_delta_validated	int4			NN
pendingwritesissued	int8			NN
sb_tree_blocks	int8			NN
log_blocks_written	int4			NN
encrypted_log_blocks_written	int4			NN
new_sb_tree_blocks	int8			NN
tossed_sb_tree_blocks	int8			NN

pg_catalog.stll_disk_cache_stats

old
column	data type	PK	U	NN
logtime	timestamp			NN
adds	int8			NN
new_blocks	int8			NN
dbr_blocks	int8			NN
pins	int8			NN
faults	int8			NN
throttles	int8			NN
scan_starts	int8			NN
cache_size	int4			NN
lru_size	int4			NN
throttle	int8			NN
ra_points	float8			NN
scans_running	int4			NN
evictions	int8			NN
prefetches	int8			NN
node	int4			NN
max_size	int4			NN
max_pushout_latency_us	int8			NN
rowset_blocks_spilled	int8			NN
rerep_write_skipped_exhausted_write_pool	int8			NN
max_rowsets_pinned	int8			NN
rowsets_currently_in_cache	int8			NN
rowsets_currently_pinned	int8			NN
accesses_to_outstanding_req	int8			NN
percentage_shared_mem_used	int4			NN
max_percentage_shared_mem_used	int4			NN
disk_upgrade_requests	int8			NN
successful_disk_upgrades	int8			NN
disk_upgrades_dropped	int8			NN
disk_upgrades_not_useful	int8			NN
s3_upgrade_requests	int8			NN
successful_s3_upgrades	int8			NN
s3_upgrades_dropped	int8			NN
num_upsizings	int8			NN
num_downsizings	int8			NN
largest_size_limit	int8			NN
smallest_size_limit	int8			NN
avg_size_limit	int8			NN
oom_eviction_calls	int4			NN
num_pushout_downsizings	int8			NN

new
column	data type	PK	U	NN
logtime	timestamp			NN
adds	int8			NN
new_blocks	int8			NN
dbr_blocks	int8			NN
pins	int8			NN
faults	int8			NN
throttles	int8			NN
scan_starts	int8			NN
cache_size	int4			NN
lru_size	int4			NN
throttle	int8			NN
ra_points	float8			NN
scans_running	int4			NN
evictions	int8			NN
prefetches	int8			NN
node	int4			NN
max_size	int4			NN
max_pushout_latency_us	int8			NN
rowset_blocks_spilled	int8			NN
rerep_write_skipped_exhausted_write_pool	int8			NN
max_rowsets_pinned	int8			NN
rowsets_currently_in_cache	int8			NN
rowsets_currently_pinned	int8			NN
accesses_to_outstanding_req	int8			NN
percentage_shared_mem_used	int4			NN
max_percentage_shared_mem_used	int4			NN
disk_upgrade_requests	int8			NN
successful_disk_upgrades	int8			NN
disk_upgrades_dropped	int8			NN
disk_upgrades_not_useful	int8			NN
s3_upgrade_requests	int8			NN
successful_s3_upgrades	int8			NN
s3_upgrades_dropped	int8			NN
num_upsizings	int8			NN
num_downsizings	int8			NN
largest_size_limit	int8			NN
smallest_size_limit	int8			NN
avg_size_limit	int8			NN
oom_eviction_calls	int4			NN
num_pushout_downsizings	int8			NN
dirty_block_size	int8			NN
dirty_rowset_block_size	int8			NN
max_dirty_block_size	int8			NN
max_dirty_rowset_block_size	int8			NN

pg_catalog.stll_disk_cache_write

old
column	data type	PK	U	NN
blocks_pushed	int4			NN
blocks_instant_pushed	int4			NN
avg_lru_size_before_push	int4			NN
push_attempts	int4			NN
pending_writes_push	int4			NN
pending_reads_push	int4			NN
blocks_written_back	int4			NN
writeback_preempts	int4			NN
avg_lru_size_before_writeback	int4			NN
writeback_attempts	int4			NN
pending_writes_writeback	int4			NN
pending_reads_writeback	int4			NN
avg_push_time_microsec	int8			NN
avg_writeback_time_microsec	int8			NN
sample_start_time	timestamp			NN
sample_end_time	timestamp			NN
node	int4			NN

new
column	data type	PK	U	NN
blocks_pushed	int4			NN
blocks_instant_pushed	int4			NN
avg_lru_size_before_push	int4			NN
push_attempts	int4			NN
pending_writes_push	int4			NN
pending_reads_push	int4			NN
blocks_written_back	int4			NN
writeback_preempts	int4			NN
avg_lru_size_before_writeback	int4			NN
writeback_attempts	int4			NN
pending_writes_writeback	int4			NN
pending_reads_writeback	int4			NN
avg_push_time_microsec	int8			NN
avg_writeback_time_microsec	int8			NN
sample_start_time	timestamp			NN
sample_end_time	timestamp			NN
node	int4			NN
rowsets_pushed	int4			NN
rowsets_instant_pushed	int4			NN

pg_catalog.stll_external_catalog_calls

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
uuid	char(36)			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
eventtime	timestamp			NN
call	int4			NN
objects	int4			NN
duration	int8			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
uuid	char(36)			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
eventtime	timestamp			NN
call	int4			NN
objects	int4			NN
duration	int8			NN
catalog_type	int4			NN

pg_catalog.stll_external_query_detail_base

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

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

pg_catalog.stll_kinesis_outbound_requests

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	timestamp			NN
request_type	char(64)			NN
request_payload	char(4096)			NN
err_reason	char(128)			NN
shard_id	char(128)			NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	timestamp			NN
request_type	char(64)			NN
request_payload	char(4096)			NN
err_reason	char(128)			NN
shard_id	char(128)			NN
mv_name	char(128)			NN

pg_catalog.stll_kinesis_scan_errors

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
arrival_time	timestamp			NN
record_time	timestamp			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
seq_num	char(128)			NN
err_code	int4			NN
err_reason	char(128)			NN
raw_data	char(1024)			NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
arrival_time	timestamp			NN
record_time	timestamp			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
seq_num	char(128)			NN
err_code	int4			NN
err_reason	char(128)			NN
raw_data	char(1024)			NN
mv_name	char(128)			NN
timestamp_type	char(1)			NN

pg_catalog.stll_kinesis_scan_states

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	timestamp			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_seq_num	char(128)			NN
millis_behind_latest	int8			NN
worker_bytes	int8			NN
queue_bytes	int8			NN
scheduling_period	int8			NN
request_duration	int8			NN
tardiness	int8			NN
min_arrival_time	timestamp			NN
max_arrival_time	timestamp			NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	timestamp			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_seq_num	char(128)			NN
millis_behind_latest	int8			NN
worker_bytes	int8			NN
queue_bytes	int8			NN
scheduling_period	int8			NN
request_duration	int8			NN
tardiness	int8			NN
min_arrival_time	timestamp			NN
max_arrival_time	timestamp			NN
mv_name	char(128)			NN

pg_catalog.stll_lambda_client

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
request_id	char(100)			NN
function_name	char(100)			NN
recordtime	timestamp			NN
num_records	int4			NN
size	int4			NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
request_id	char(100)			NN
function_name	char(100)			NN
recordtime	timestamp			NN
num_records	int4			NN
size	int4			NN
queue_id	int4			NN

pg_catalog.stll_lambda_execution_logs

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
request_id	char(100)			NN
recordtime	timestamp			NN
execution_logs	char(4096)			NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
request_id	char(100)			NN
recordtime	timestamp			NN
execution_logs	char(4096)			NN
queue_id	int4			NN

pg_catalog.stll_lambda_invocation_error

old
column	data type	PK	U	NN
query	int4			NN
recordtime	timestamp			NN
message	char(1024)			NN
node	int4			NN
slice	int4			NN
request_id	char(100)			NN

new
column	data type	PK	U	NN
query	int4			NN
recordtime	timestamp			NN
message	char(1024)			NN
node	int4			NN
slice	int4			NN
request_id	char(100)			NN
queue_id	int4			NN

pg_catalog.stll_mv_refresh

old
column	data type	PK	U	NN
userid	int8			NN
xid	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
schemaoid	int8			NN
mvoid	int8			NN
status	int4			NN
refresh_type	char(32)			NN
db_oid	int8			NN

new
column	data type	PK	U	NN
userid	int8			NN
xid	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
schemaoid	int8			NN
mvoid	int8			NN
status	int4			NN
refresh_type	char(32)			NN
db_oid	int8			NN
no_new_rows	char(1)			NN
skipped_rows	char(1)			NN
may_have_more_rows	char(1)			NN

pg_catalog.stll_s3commit_stats

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

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

pg_catalog.stll_s3query

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
uuid	char(36)			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
external_table_name	char(136)			NN
is_partitioned	char(1)			NN
is_rrscan	char(1)			NN
s3_scanned_rows	int8			NN
s3_scanned_bytes	int8			NN
s3query_returned_rows	int8			NN
s3query_returned_bytes	int8			NN
files	int4			NN
total_retries	int4			NN
max_retries	int4			NN
max_request_duration	int8			NN
avg_request_duration	int8			NN
max_request_parallelism	int4			NN
max_allowed_parallelism	int4			NN
avg_request_parallelism	float8			NN
splits	int4			NN
total_split_size	int8			NN
max_split_size	int8			NN
request_fingerprint	int8			NN
file_format	char(16)			NN
cache_hits	int4			NN
is_copy	int4			NN
is_nested	char(1)			NN
slowdown_count	int4			NN
max_concurrent_slowdown_count	int4			NN
s3_billable_scanned_bytes	int8			NN
scan_type	int4			NN
s3query_returned_uncompressed_bytes	int8			NN
is_lakeformation	int4			NN
is_governed	int4			NN
transaction_id	char(32)			NN
query_as_of_time	timestamp			NN
throttled_requests	int4			NN
peakmem	int8			NN
is_local	int4			NN
is_evr	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
uuid	char(36)			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
external_table_name	char(136)			NN
is_partitioned	char(1)			NN
is_rrscan	char(1)			NN
s3_scanned_rows	int8			NN
s3_scanned_bytes	int8			NN
s3query_returned_rows	int8			NN
s3query_returned_bytes	int8			NN
files	int4			NN
total_retries	int4			NN
max_retries	int4			NN
max_request_duration	int8			NN
avg_request_duration	int8			NN
max_request_parallelism	int4			NN
max_allowed_parallelism	int4			NN
avg_request_parallelism	float8			NN
splits	int4			NN
total_split_size	int8			NN
max_split_size	int8			NN
request_fingerprint	int8			NN
file_format	char(16)			NN
cache_hits	int4			NN
is_copy	int4			NN
is_nested	char(1)			NN
slowdown_count	int4			NN
max_concurrent_slowdown_count	int4			NN
s3_billable_scanned_bytes	int8			NN
scan_type	int4			NN
s3query_returned_uncompressed_bytes	int8			NN
is_lakeformation	int4			NN
is_governed	int4			NN
transaction_id	char(32)			NN
query_as_of_time	timestamp			NN
throttled_requests	int4			NN
peakmem	int8			NN
is_local	int4			NN
is_evr	int4			NN
has_cell_level_security	int4			NN

pg_catalog.stll_scan

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
fetches	int8			NN
type	int4			NN
tbl	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
rows_pre_filter	int8			NN
rows_pre_user_filter	int8			NN
perm_table_name	char(136)			NN
is_rlf_scan	char(1)			NN
is_rlf_scan_reason	int4			NN
num_em_blocks	int4			NN
checksum	int8			NN
runtime_filtering	char(1)			NN
scan_region	int4			NN
num_sortkey_as_predicate	int4			NN
row_fetcher_state	int4			NN
consumed_scan_ranges	int8			NN
work_stealing_reason	int8			NN
is_vectorized_scan	char(1)			NN
is_vectorized_scan_reason	int4			NN
row_fetcher_reason	int8			NN
topology_signature	int8			NN
use_tpm_partition	char(1)			NN
is_rrscan_expr	char(1)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
fetches	int8			NN
type	int4			NN
tbl	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
rows_pre_filter	int8			NN
rows_pre_user_filter	int8			NN
perm_table_name	char(136)			NN
is_rlf_scan	char(1)			NN
is_rlf_scan_reason	int4			NN
num_em_blocks	int4			NN
checksum	int8			NN
runtime_filtering	char(1)			NN
scan_region	int4			NN
num_sortkey_as_predicate	int4			NN
row_fetcher_state	int4			NN
consumed_scan_ranges	int8			NN
work_stealing_reason	int8			NN
is_vectorized_scan	char(1)			NN
is_vectorized_scan_reason	int4			NN
row_fetcher_reason	int8			NN
topology_signature	int8			NN
use_tpm_partition	char(1)			NN
is_rrscan_expr	char(1)			NN
use_fwd_mtx_opt	char(1)			NN

pg_catalog.stll_superblock

old
column	data type	PK	U	NN
node	int4			NN
record_time	timestamp			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	int4			NN

new
column	data type	PK	U	NN
node	int4			NN
record_time	timestamp			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	int4			NN
sb_tree_root_pos	int4			NN
sb_tree_height	int4			NN
sb_tree_mode	int4			NN
sb_tree_blocks	int4			NN
sb_tree_root_guid	char(36)			NN

pg_catalog.stll_user_query_history

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
label	char(32)			NN
xid	int8			NN
pid	int4			NN
database_name	char(128)			NN
query_type	char(32)			NN
status	char(10)			NN
result_cache_source_query	int8			NN
start_time	timestamp			NN
end_time	timestamp			NN
queue_time	int8			NN
execution_time	int8			NN
error_message	char(512)			NN
returned_rows	int8			NN
returned_bytes	int8			NN
redshift_version	char(32)			NN
usage_limit	char(150)			NN
internal_query	char(1)			NN
query_text	char(4000)			NN

new
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database_name	char(128)			NN
query_type	char(32)			NN
status	char(10)			NN
result_cache_source_query	int8			NN
start_time	timestamp			NN
end_time	timestamp			NN
queue_time	int8			NN
execution_time	int8			NN
error_message	char(512)			NN
returned_rows	int8			NN
returned_bytes	int8			NN
redshift_version	char(32)			NN
usage_limit	char(150)			NN
internal_query	char(1)			NN
query_text	char(4000)			NN

pg_catalog.stll_version

old
column	data type	PK	U	NN
bootstrap_time	timestamp			NN
db_version	char(50)			NN
restart_reason	char(100)			NN

new
column	data type	PK	U	NN
bootstrap_time	timestamp			NN
db_version	char(50)			NN
restart_reason	char(100)			NN
restart_trace_id	char(64)			NN

pg_catalog.stll_xregion_metering

old
column	data type	PK	U	NN
eventtime	timestamp			NN
query	int8			NN
region	char(30)			NN
internal_request_uuid	char(36)			NN
metered_mbs	int8			NN

new
column	data type	PK	U	NN
eventtime	timestamp			NN
query	int8			NN
region	char(30)			NN
internal_request_uuid	char(36)			NN
metered_mbs	int8			NN
transferred_data	int8			NN

pg_catalog.stll_xrestore

old
column	data type	PK	U	NN
backup_id	char(256)			NN
node	int4			NN
catalog_download_start_time	timestamp			NN
catalog_download_end_time	timestamp			NN
slice_transfer_start_time	timestamp			NN
slice_transfer_end_time	timestamp			NN

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

pg_catalog.stv_disk_cache_state

old
column	data type	PK	U	NN
node	int4			NN
cache_size_mb	float8			NN
size_limit_mb	float8			NN
lru_size	int8			NN
throttle_points	int8			NN
ra_points	float8			NN
scans_running	int4			NN
total_size_of_rowblock	int8			NN
total_size_of_rowblock_pinned	int8			NN
percentage_shared_mem_used	float8			NN
cache_shd_mem_perc	float8			NN
size_delta_mb	int4			NN
high_water_mark	int8			NN
low_water_mark	int8			NN
megarowblocks_currently_in_cache	int8			NN
total_size_of_megarowblocks	int8			NN

new
column	data type	PK	U	NN
node	int4			NN
cache_size_mb	float8			NN
size_limit_mb	float8			NN
lru_size	int8			NN
throttle_points	int8			NN
ra_points	float8			NN
scans_running	int4			NN
total_size_of_rowblock	int8			NN
total_size_of_rowblock_pinned	int8			NN
percentage_shared_mem_used	float8			NN
cache_shd_mem_perc	float8			NN
size_delta_mb	int4			NN
high_water_mark	int8			NN
low_water_mark	int8			NN
megarowblocks_currently_in_cache	int8			NN
total_size_of_megarowblocks	int8			NN
dirty_block_size	int8			NN
dirty_rowset_block_size	int8			NN

pg_catalog.stv_superblock

old
column	data type	PK	U	NN
node	int4			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	int4			NN

new
column	data type	PK	U	NN
node	int4			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	int4			NN
sb_tree_root_pos	int4			NN
sb_tree_height	int4			NN
sb_tree_mode	int4			NN
sb_tree_blocks	int4			NN
sb_tree_root_guid	char(36)			NN

pg_catalog.stv_tbl_perm

old
column	data type	PK	U	NN
slice	int4			NN
id	int4			NN
name	char(128)			NN
rows	int8			NN
sorted_rows	int8			NN
temp	int4			NN
db_id	int4			NN
insert_pristine	int4			NN
delete_pristine	int4			NN
backup	int4			NN

new
column	data type	PK	U	NN
slice	int4			NN
id	int4			NN
name	char(128)			NN
rows	int8			NN
sorted_rows	int8			NN
temp	int4			NN
db_id	int4			NN
insert_pristine	int4			NN
delete_pristine	int4			NN
backup	int4			NN
dist_style	int4			NN
block_count	int4			NN

pg_catalog.stv_user_query_state

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
label	char(32)			NN
xid	int8			NN
pid	int4			NN
database_name	char(128)			NN
query_type	char(32)			NN
status	char(10)			NN
result_cache_source_query	int8			NN
start_time	timestamp			NN
end_time	timestamp			NN
now	timestamp			NN
status_update_time	timestamp			NN
queue_time	int8			NN
execution_time	int8			NN
error_message	char(512)			NN
returned_rows	int8			NN
returned_bytes	int8			NN
redshift_version	char(32)			NN
usage_limit	char(150)			NN
internal_query	char(1)			NN
query_text	char(4000)			NN

new
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database_name	char(128)			NN
query_type	char(32)			NN
status	char(10)			NN
result_cache_source_query	int8			NN
start_time	timestamp			NN
end_time	timestamp			NN
now	timestamp			NN
status_update_time	timestamp			NN
queue_time	int8			NN
execution_time	int8			NN
error_message	char(512)			NN
returned_rows	int8			NN
returned_bytes	int8			NN
redshift_version	char(32)			NN
usage_limit	char(150)			NN
internal_query	char(1)			NN
query_text	char(4000)			NN

pg_catalog.stcs_perf_comm

old
column	data type	PK	U	NN
query_id	int4			NN
segment_number	int4			NN
slice_number	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
channel_type	int4			NN
channel_id	int4			NN
start_time	int8			NN
end_time	int8			NN
throughput_kilobytes_per_sec	int8			NN
is_source	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_smfaults

old
column	data type	PK	U	NN
seq	int4			NN
run	int4			NN
mon_type	char(128)			NN
mon_name	char(128)			NN
severity	int4			NN
resolution_dbup	char(128)			NN
resolution_dbdown	char(128)			NN
code	int4			NN
recordtime	int8			NN
observer	char(15)			NN
culprit	char(15)			NN
msg	char(256)			NN
xml_extra	char(2048)			NN
has_measure_val	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_smfaults_cleared

old
column	data type	PK	U	NN
seq	int4			NN
run	int4			NN
recordtime	int8			NN
msg	char(256)			NN
resolution	char(256)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_smfaults_mval

old
column	data type	PK	U	NN
seq	int4			NN
run	int4			NN
thresh	int8			NN
value	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_smfaults_overflow

old
column	data type	PK	U	NN
parent_seq	int4			NN
parent_run	int4			NN
seq	int4			NN
run	int4			NN
mon_type	char(128)			NN
mon_name	char(128)			NN
severity	int4			NN
resolution_dbup	char(128)			NN
resolution_dbdown	char(128)			NN
code	int4			NN
recordtime	int8			NN
observer	char(15)			NN
culprit	char(15)			NN
msg	char(256)			NN
xml_extra	char(2048)			NN
has_measure_val	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_smlog

old
column	data type	PK	U	NN
seq	int4			NN
ip	char(15)			NN
process	char(15)			NN
level	int4			NN
recordtime	int8			NN
file	char(64)			NN
linenum	int4			NN
sys_errno	int4			NN
errno_str	char(64)			NN
msg	char(256)			NN
stack	char(512)			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_perf_comm

old
column	data type	PK	U	NN
query_id	int4			NN
segment_number	int4			NN
slice_number	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
channel_type	int4			NN
channel_id	int4			NN
start_time	timestamp			NN
end_time	timestamp			NN
throughput_kilobytes_per_sec	int8			NN
is_source	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_smfaults

old
column	data type	PK	U	NN
seq	int4			NN
run	int4			NN
mon_type	char(128)			NN
mon_name	char(128)			NN
severity	int4			NN
resolution_dbup	char(128)			NN
resolution_dbdown	char(128)			NN
code	int4			NN
recordtime	timestamp			NN
observer	char(15)			NN
culprit	char(15)			NN
msg	char(256)			NN
xml_extra	char(2048)			NN
has_measure_val	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_smfaults_cleared

old
column	data type	PK	U	NN
seq	int4			NN
run	int4			NN
recordtime	timestamp			NN
msg	char(256)			NN
resolution	char(256)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_smfaults_mval

old
column	data type	PK	U	NN
seq	int4			NN
run	int4			NN
thresh	int8			NN
value	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_smfaults_overflow

old
column	data type	PK	U	NN
parent_seq	int4			NN
parent_run	int4			NN
seq	int4			NN
run	int4			NN
mon_type	char(128)			NN
mon_name	char(128)			NN
severity	int4			NN
resolution_dbup	char(128)			NN
resolution_dbdown	char(128)			NN
code	int4			NN
recordtime	timestamp			NN
observer	char(15)			NN
culprit	char(15)			NN
msg	char(256)			NN
xml_extra	char(2048)			NN
has_measure_val	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_smlog

old
column	data type	PK	U	NN
seq	int4			NN
ip	char(15)			NN
process	char(15)			NN
level	int4			NN
recordtime	timestamp			NN
file	char(64)			NN
linenum	int4			NN
sys_errno	int4			NN
errno_str	char(64)			NN
msg	char(256)			NN
stack	char(512)			NN

new
column	data type	PK	U	NN

pg_catalog.stv_block_limits_metadata

old
column	data type	PK	U	NN
node	int4			NN
index	int4			NN
allocated	int4			NN
minvalue	char(16)			NN
maxvalue	char(16)			NN

new
column	data type	PK	U	NN

pg_catalog.stv_disk_extents

old
column	data type	PK	U	NN
owner	int4			NN
host	int4			NN
diskno	int4			NN
start_addr	int8			NN
end_addr	int8			NN
tbl	int4			NN
col	int4			NN
slice	int4			NN
num_allocated	int4			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_1678775

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_burst_id_col_highwatermark

old
column	data type

new
column	data type
log_time	timestamp
log_type	int4
query	int8
tbl_id	int4
col_id	int4
burst_slice	int4
main_slice	int4
highwatermark	int8

pg_catalog.stl_cqi_metrics

old
column	data type

new
column	data type
pid	int4
starttime	timestamp
endtime	timestamp
component_name	char(48)
phase	char(48)
restart_id	char(64)
message	char(512)

pg_catalog.stl_executor_steps

old
column	data type

new
column	data type
userid	int4
recordtime	timestamp
query	int4
stream_num	int4
segment	int4
subplan_level	int4
subplan_id	int4
steps	char(2048)
supports_executor	char(128)
code_item_was_cached	int4
compile	int4
is_short_query	int4
is_short_query_debug_compile	int4
expression_oids	char(500)

pg_catalog.stl_grouping_sets

old
column	data type

new
column	data type
query	int4
segment	int4
step	int4
slice	int4
dist_grouping_set	int4
grouping_set_id	int4
rows	int8
bytes	int8

pg_catalog.stl_kafka_scan_errors

old
column	data type

new
column	data type
query	int4
node	int4
slice	int4
segment	int4
pid	int4
timestamp_type	char(1)
kafka_timestamp	timestamp
record_time	timestamp
schema_name	char(128)
topic_name	char(255)
partition_id	int8
record_offset	int8
err_code	int4
err_reason	char(128)
raw_data	char(1024)
mv_name	char(128)

pg_catalog.stl_kafka_scan_states

old
column	data type

new
column	data type
query	int4
node	int4
slice	int4
segment	int4
pid	int4
record_time	timestamp
schema_name	char(128)
topic_name	char(255)
partition_id	int8
num_records	int8
num_skipped_records	int8
num_bytes	int8
latest_offset	int8
min_arrival_time	timestamp
max_arrival_time	timestamp
mv_name	char(128)

pg_catalog.stl_lbc_replay_stats

old
column	data type

new
column	data type
replay_type	char(32)
node	int4
start_time	timestamp
end_time	timestamp
index_seen	int4
index_applied	int4
active_seen	int4
active_applied	int4
inactive_seen	int4
inactive_applied	int4
checkpoint_seen	int4
checkpoint_applied	int4
log_blocks_seen	int4
encrypted_log_blocks_seen	int4

pg_catalog.stl_perf_channel_sink

old
column	data type

new
column	data type
query_id	int4
segment_number	int4
slice_number	int4
packet_count	int8
bytes_transferred	int8
channel_type	int4
channel_id	int4
first_packet_time	timestamp
last_packet_time	timestamp
close_time	timestamp
throughput_kilobytes_per_sec	int8
xoff_total_time	int8
xoff_max_time	int8
queue_delay_total_time	int8
queue_delay_max_time	int8
rexmit_total_count	int8
rexmit_max_count	int8

pg_catalog.stl_perf_channel_source

old
column	data type

new
column	data type
query_id	int4
segment_number	int4
slice_number	int4
packet_count	int8
bytes_transferred	int8
channel_type	int4
channel_id	int4
first_packet_time	timestamp
last_packet_time	timestamp
close_time	timestamp
throughput_kilobytes_per_sec	int8
borrow_total_time	int8
borrow_max_time	int8
queue_delay_total_time	int8
queue_delay_max_time	int8

pg_catalog.stl_s3commit_dm_guids

old
column	data type

new
column	data type
recordtime	timestamp
node	int4
dm_name	char(300)
guid	char(64)

pg_catalog.stl_superblock_tree_events

old
column	data type

new
column	data type
eventtime	timestamp
xid	int8
process	char(32)
pid	int4
node	int4
is_error	int4
filename	char(80)
linenum	int4
context	char(48)
message	char(256)

pg_catalog.stl_superblock_trickle_validation_stats

old
column	data type

new
column	data type
node	int4
record_time	timestamp
snapshot_sb_version	int8
snapshot_sb_num_blocks	int8
log_entries_validated	int8
log_blocks_validated	int8
tree_based_sb_mode	int4
tree_entries_validated	int8
trickle_validation_done	int4
log_rotation	int4

pg_catalog.stl_truncate_history

old
column	data type

new
column	data type
logtime	timestamp
xid	int8
table_id	int4
table_name	char(128)
is_temp	int4
is_safe	int4
is_extended_protocol	int4
is_user	int4
query_text	char(256)

pg_catalog.svl_stream_scan_errors

old
column	data type

new
column	data type
query	int4
pid	int4
timestamp_type	char(1)
stream_timestamp	timestamp
record_time	timestamp
mv_name	char(128)
schema_name	char(128)
stream_name	char(255)
partition_id	char(128)
position	char(128)
err_code	int4
err_reason	char(128)
raw_data	char(1024)

pg_catalog.svl_stream_scan_states

old
column	data type

new
column	data type
query	int4
pid	int4
record_time	timestamp
mv_name	char(128)
schema_name	char(128)
stream_name	char(255)
partition_id	char(128)
latest_position	char(128)
num_records	int8
num_skipped_records	int8
num_bytes	int8
min_arrival_time	timestamp
max_arrival_time	timestamp

pg_catalog.svv_iam_privileges

old
column	data type

new
column	data type
iam_arn	varchar(128)
command_type	varchar(128)
identity_id	int4
identity_name	varchar(128)
identity_type	varchar(128)

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)

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)

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)

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

pg_catalog.stl_commit_internal_stats

old
column	data type
xid	int8
node	int4
prefetchesskipped	int8
numreadsprocessed	int8
numacksprocessed	int8
tablebasedtosseligible	int4
lastackwaittime	float8
processtime	float8
log_based	int4
log_based_flags	int4
index_log_regenerated	int4
tables_total	int4
tables_swept	int4
headers_swept	int8
tables_changed	int4
blocks_pending_write	int8
num_metadata_blocks_retained	int4
total_metadata_blocks	int4
sb_size	int8
num_modified_hdrs_tracked	int8
sb_sweep_tracking	int4
sb_version	int8
sb_sweep_optimized_commit	int4
metadata_delta_validated	int4
pendingwritesissued	int8
sb_tree_blocks	int8

new
column	data type
xid	int8
node	int4
prefetchesskipped	int8
numreadsprocessed	int8
numacksprocessed	int8
tablebasedtosseligible	int4
lastackwaittime	float8
processtime	float8
log_based	int4
log_based_flags	int4
index_log_regenerated	int4
tables_total	int4
tables_swept	int4
headers_swept	int8
tables_changed	int4
blocks_pending_write	int8
num_metadata_blocks_retained	int4
total_metadata_blocks	int4
sb_size	int8
num_modified_hdrs_tracked	int8
sb_sweep_tracking	int4
sb_version	int8
sb_sweep_optimized_commit	int4
metadata_delta_validated	int4
pendingwritesissued	int8
sb_tree_blocks	int8
log_blocks_written	int4
encrypted_log_blocks_written	int4
new_sb_tree_blocks	int8
tossed_sb_tree_blocks	int8

pg_catalog.stl_disk_cache_stats

old
column	data type
logtime	timestamp
adds	int8
new_blocks	int8
dbr_blocks	int8
pins	int8
faults	int8
throttles	int8
scan_starts	int8
cache_size	int4
lru_size	int4
throttle	int8
ra_points	float8
scans_running	int4
evictions	int8
prefetches	int8
node	int4
max_size	int4
max_pushout_latency_us	int8
rowset_blocks_spilled	int8
rerep_write_skipped_exhausted_write_pool	int8
max_rowsets_pinned	int8
rowsets_currently_in_cache	int8
rowsets_currently_pinned	int8
accesses_to_outstanding_req	int8
percentage_shared_mem_used	int4
max_percentage_shared_mem_used	int4
disk_upgrade_requests	int8
successful_disk_upgrades	int8
disk_upgrades_dropped	int8
disk_upgrades_not_useful	int8
s3_upgrade_requests	int8
successful_s3_upgrades	int8
s3_upgrades_dropped	int8
num_upsizings	int8
num_downsizings	int8
largest_size_limit	int8
smallest_size_limit	int8
avg_size_limit	int8
oom_eviction_calls	int4
num_pushout_downsizings	int8

new
column	data type
logtime	timestamp
adds	int8
new_blocks	int8
dbr_blocks	int8
pins	int8
faults	int8
throttles	int8
scan_starts	int8
cache_size	int4
lru_size	int4
throttle	int8
ra_points	float8
scans_running	int4
evictions	int8
prefetches	int8
node	int4
max_size	int4
max_pushout_latency_us	int8
rowset_blocks_spilled	int8
rerep_write_skipped_exhausted_write_pool	int8
max_rowsets_pinned	int8
rowsets_currently_in_cache	int8
rowsets_currently_pinned	int8
accesses_to_outstanding_req	int8
percentage_shared_mem_used	int4
max_percentage_shared_mem_used	int4
disk_upgrade_requests	int8
successful_disk_upgrades	int8
disk_upgrades_dropped	int8
disk_upgrades_not_useful	int8
s3_upgrade_requests	int8
successful_s3_upgrades	int8
s3_upgrades_dropped	int8
num_upsizings	int8
num_downsizings	int8
largest_size_limit	int8
smallest_size_limit	int8
avg_size_limit	int8
oom_eviction_calls	int4
num_pushout_downsizings	int8
dirty_block_size	int8
dirty_rowset_block_size	int8
max_dirty_block_size	int8
max_dirty_rowset_block_size	int8

pg_catalog.stl_disk_cache_write

old
column	data type
blocks_pushed	int4
blocks_instant_pushed	int4
avg_lru_size_before_push	int4
push_attempts	int4
pending_writes_push	int4
pending_reads_push	int4
blocks_written_back	int4
writeback_preempts	int4
avg_lru_size_before_writeback	int4
writeback_attempts	int4
pending_writes_writeback	int4
pending_reads_writeback	int4
avg_push_time_microsec	int8
avg_writeback_time_microsec	int8
sample_start_time	timestamp
sample_end_time	timestamp
node	int4

new
column	data type
blocks_pushed	int4
blocks_instant_pushed	int4
avg_lru_size_before_push	int4
push_attempts	int4
pending_writes_push	int4
pending_reads_push	int4
blocks_written_back	int4
writeback_preempts	int4
avg_lru_size_before_writeback	int4
writeback_attempts	int4
pending_writes_writeback	int4
pending_reads_writeback	int4
avg_push_time_microsec	int8
avg_writeback_time_microsec	int8
sample_start_time	timestamp
sample_end_time	timestamp
node	int4
rowsets_pushed	int4
rowsets_instant_pushed	int4

pg_catalog.stl_external_catalog_calls

old
column	data type
userid	int4
query	int4
uuid	char(36)
segment	int4
node	int4
slice	int4
eventtime	timestamp
call	int4
objects	int4
duration	int8

new
column	data type
userid	int4
query	int4
uuid	char(36)
segment	int4
node	int4
slice	int4
eventtime	timestamp
call	int4
objects	int4
duration	int8
catalog_type	int4

pg_catalog.stl_external_query_detail_base

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

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

pg_catalog.stl_kinesis_outbound_requests

old
column	data type
query	int4
node	int4
slice	int4
segment	int4
pid	int4
record_time	timestamp
request_type	char(64)
request_payload	char(4096)
err_reason	char(128)
shard_id	char(128)

new
column	data type
query	int4
node	int4
slice	int4
segment	int4
pid	int4
record_time	timestamp
request_type	char(64)
request_payload	char(4096)
err_reason	char(128)
shard_id	char(128)
mv_name	char(128)

pg_catalog.stl_kinesis_scan_errors

old
column	data type
query	int4
node	int4
slice	int4
segment	int4
pid	int4
arrival_time	timestamp
record_time	timestamp
schema_name	char(128)
stream_name	char(128)
shard_id	char(128)
seq_num	char(128)
err_code	int4
err_reason	char(128)
raw_data	char(1024)

new
column	data type
query	int4
node	int4
slice	int4
segment	int4
pid	int4
arrival_time	timestamp
record_time	timestamp
schema_name	char(128)
stream_name	char(128)
shard_id	char(128)
seq_num	char(128)
err_code	int4
err_reason	char(128)
raw_data	char(1024)
mv_name	char(128)
timestamp_type	char(1)

pg_catalog.stl_kinesis_scan_states

old
column	data type
query	int4
node	int4
slice	int4
segment	int4
pid	int4
record_time	timestamp
schema_name	char(128)
stream_name	char(128)
shard_id	char(128)
num_records	int8
num_skipped_records	int8
num_bytes	int8
latest_seq_num	char(128)
millis_behind_latest	int8
worker_bytes	int8
queue_bytes	int8
scheduling_period	int8
request_duration	int8
tardiness	int8
min_arrival_time	timestamp
max_arrival_time	timestamp

new
column	data type
query	int4
node	int4
slice	int4
segment	int4
pid	int4
record_time	timestamp
schema_name	char(128)
stream_name	char(128)
shard_id	char(128)
num_records	int8
num_skipped_records	int8
num_bytes	int8
latest_seq_num	char(128)
millis_behind_latest	int8
worker_bytes	int8
queue_bytes	int8
scheduling_period	int8
request_duration	int8
tardiness	int8
min_arrival_time	timestamp
max_arrival_time	timestamp
mv_name	char(128)

pg_catalog.stl_lambda_client

old
column	data type
query	int4
node	int4
slice	int4
segment	int4
request_id	char(100)
function_name	char(100)
recordtime	timestamp
num_records	int4
size	int4

new
column	data type
query	int4
node	int4
slice	int4
segment	int4
request_id	char(100)
function_name	char(100)
recordtime	timestamp
num_records	int4
size	int4
queue_id	int4

pg_catalog.stl_lambda_execution_logs

old
column	data type
query	int4
node	int4
slice	int4
request_id	char(100)
recordtime	timestamp
execution_logs	char(4096)

new
column	data type
query	int4
node	int4
slice	int4
request_id	char(100)
recordtime	timestamp
execution_logs	char(4096)
queue_id	int4

pg_catalog.stl_lambda_invocation_error

old
column	data type
query	int4
recordtime	timestamp
message	char(1024)
node	int4
slice	int4
request_id	char(100)

new
column	data type
query	int4
recordtime	timestamp
message	char(1024)
node	int4
slice	int4
request_id	char(100)
queue_id	int4

pg_catalog.stl_mv_refresh

old
column	data type
userid	int8
xid	int8
starttime	timestamp
endtime	timestamp
schemaoid	int8
mvoid	int8
status	int4
refresh_type	char(32)
db_oid	int8

new
column	data type
userid	int8
xid	int8
starttime	timestamp
endtime	timestamp
schemaoid	int8
mvoid	int8
status	int4
refresh_type	char(32)
db_oid	int8
no_new_rows	char(1)
skipped_rows	char(1)
may_have_more_rows	char(1)

pg_catalog.stl_s3commit_stats

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

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

pg_catalog.stl_s3query

old
column	data type
userid	int4
query	int4
uuid	char(36)
segment	int4
step	int4
node	int4
slice	int4
starttime	timestamp
endtime	timestamp
external_table_name	char(136)
is_partitioned	char(1)
is_rrscan	char(1)
s3_scanned_rows	int8
s3_scanned_bytes	int8
s3query_returned_rows	int8
s3query_returned_bytes	int8
files	int4
total_retries	int4
max_retries	int4
max_request_duration	int8
avg_request_duration	int8
max_request_parallelism	int4
max_allowed_parallelism	int4
avg_request_parallelism	float8
splits	int4
total_split_size	int8
max_split_size	int8
request_fingerprint	int8
file_format	char(16)
cache_hits	int4
is_copy	int4
is_nested	char(1)
slowdown_count	int4
max_concurrent_slowdown_count	int4
s3_billable_scanned_bytes	int8
scan_type	int4
s3query_returned_uncompressed_bytes	int8
is_lakeformation	int4
is_governed	int4
transaction_id	char(32)
query_as_of_time	timestamp
throttled_requests	int4
peakmem	int8
is_local	int4
is_evr	int4

new
column	data type
userid	int4
query	int4
uuid	char(36)
segment	int4
step	int4
node	int4
slice	int4
starttime	timestamp
endtime	timestamp
external_table_name	char(136)
is_partitioned	char(1)
is_rrscan	char(1)
s3_scanned_rows	int8
s3_scanned_bytes	int8
s3query_returned_rows	int8
s3query_returned_bytes	int8
files	int4
total_retries	int4
max_retries	int4
max_request_duration	int8
avg_request_duration	int8
max_request_parallelism	int4
max_allowed_parallelism	int4
avg_request_parallelism	float8
splits	int4
total_split_size	int8
max_split_size	int8
request_fingerprint	int8
file_format	char(16)
cache_hits	int4
is_copy	int4
is_nested	char(1)
slowdown_count	int4
max_concurrent_slowdown_count	int4
s3_billable_scanned_bytes	int8
scan_type	int4
s3query_returned_uncompressed_bytes	int8
is_lakeformation	int4
is_governed	int4
transaction_id	char(32)
query_as_of_time	timestamp
throttled_requests	int4
peakmem	int8
is_local	int4
is_evr	int4
has_cell_level_security	int4

pg_catalog.stl_scan

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
fetches	int8
type	int4
tbl	int4
is_rrscan	char(1)
is_delayed_scan	char(1)
rows_pre_filter	int8
rows_pre_user_filter	int8
perm_table_name	char(136)
is_rlf_scan	char(1)
is_rlf_scan_reason	int4
num_em_blocks	int4
checksum	int8
runtime_filtering	char(1)
scan_region	int4
num_sortkey_as_predicate	int4
row_fetcher_state	int4
consumed_scan_ranges	int8
work_stealing_reason	int8
is_vectorized_scan	char(1)
is_vectorized_scan_reason	int4
row_fetcher_reason	int8
topology_signature	int8
use_tpm_partition	char(1)
is_rrscan_expr	char(1)

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
fetches	int8
type	int4
tbl	int4
is_rrscan	char(1)
is_delayed_scan	char(1)
rows_pre_filter	int8
rows_pre_user_filter	int8
perm_table_name	char(136)
is_rlf_scan	char(1)
is_rlf_scan_reason	int4
num_em_blocks	int4
checksum	int8
runtime_filtering	char(1)
scan_region	int4
num_sortkey_as_predicate	int4
row_fetcher_state	int4
consumed_scan_ranges	int8
work_stealing_reason	int8
is_vectorized_scan	char(1)
is_vectorized_scan_reason	int4
row_fetcher_reason	int8
topology_signature	int8
use_tpm_partition	char(1)
is_rrscan_expr	char(1)
use_fwd_mtx_opt	char(1)

pg_catalog.stl_superblock

old
column	data type
node	int4
record_time	timestamp
fs_version	int8
sb_version	int8
defrag_version	int8
num_blocks	int4
high_qid	int8
crc	int4
flags	int4
num_uncommitted	int8
active_log	int4
is_extended_superblock	int4
superblock_capacity	int8
perm_blocks	int4
freelist_size	int4
bloat	int4

new
column	data type
node	int4
record_time	timestamp
fs_version	int8
sb_version	int8
defrag_version	int8
num_blocks	int4
high_qid	int8
crc	int4
flags	int4
num_uncommitted	int8
active_log	int4
is_extended_superblock	int4
superblock_capacity	int8
perm_blocks	int4
freelist_size	int4
bloat	int4
sb_tree_root_pos	int4
sb_tree_height	int4
sb_tree_mode	int4
sb_tree_blocks	int4
sb_tree_root_guid	char(36)

pg_catalog.stl_user_query_history

old
column	data type
user_id	int4
query_id	int8
label	char(32)
xid	int8
pid	int4
database_name	char(128)
query_type	char(32)
status	char(10)
result_cache_source_query	int8
start_time	timestamp
end_time	timestamp
queue_time	int8
execution_time	int8
error_message	char(512)
returned_rows	int8
returned_bytes	int8
redshift_version	char(32)
usage_limit	char(150)
internal_query	char(1)
query_text	char(4000)

new
column	data type
user_id	int4
query_id	int8
label	char(320)
xid	int8
pid	int4
database_name	char(128)
query_type	char(32)
status	char(10)
result_cache_source_query	int8
start_time	timestamp
end_time	timestamp
queue_time	int8
execution_time	int8
error_message	char(512)
returned_rows	int8
returned_bytes	int8
redshift_version	char(32)
usage_limit	char(150)
internal_query	char(1)
query_text	char(4000)

pg_catalog.stl_version

old
column	data type
bootstrap_time	timestamp
db_version	char(50)
restart_reason	char(100)

new
column	data type
bootstrap_time	timestamp
db_version	char(50)
restart_reason	char(100)
restart_trace_id	char(64)

pg_catalog.stl_xregion_metering

old
column	data type
eventtime	timestamp
query	int8
region	char(30)
internal_request_uuid	char(36)
metered_mbs	int8

new
column	data type
eventtime	timestamp
query	int8
region	char(30)
internal_request_uuid	char(36)
metered_mbs	int8
transferred_data	int8

pg_catalog.stl_xrestore

old
column	data type
backup_id	char(256)
node	int4
catalog_download_start_time	timestamp
catalog_download_end_time	timestamp
slice_transfer_start_time	timestamp
slice_transfer_end_time	timestamp

new
column	data type
backup_id	char(256)
node	int4
catalog_download_start_time	timestamp
catalog_download_end_time	timestamp
slice_transfer_start_time	timestamp
slice_transfer_end_time	timestamp
guid_pool_hit_rate	float8
num_guids_created_on_demand	int4

pg_catalog.svl_s3catalog

old
column	data type
query	int4
segment	int4
node	int4
slice	int4
eventtime	timestamp
call	int4
objects	int4
duration	int8

new
column	data type
query	int4
segment	int4
node	int4
slice	int4
eventtime	timestamp
call	int4
objects	int4
duration	int8
catalog_type	int4

pg_catalog.sys_external_query_detail

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

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

pg_catalog.sys_serverless_usage

old
column	data type
start_time	timestamp
end_time	timestamp
compute_seconds	float8
compute_capacity	float8
data_storage	int8

new
column	data type
start_time	timestamp
end_time	timestamp
compute_seconds	float8
compute_capacity	float8
data_storage	int8
cross_region_transferred_data	int8

pg_catalog.stl_perf_comm

old
column	data type
query_id	int4
segment_number	int4
slice_number	int4
packet_count	int8
bytes_transferred	int8
channel_type	int4
channel_id	int4
start_time	timestamp
end_time	timestamp
throughput_kilobytes_per_sec	int8
is_source	int4

new
column	data type

pg_catalog.stl_smfaults

old
column	data type
seq	int4
run	int4
mon_type	char(128)
mon_name	char(128)
severity	int4
resolution_dbup	char(128)
resolution_dbdown	char(128)
code	int4
recordtime	timestamp
observer	char(15)
culprit	char(15)
msg	char(256)
xml_extra	char(2048)
has_measure_val	int4

new
column	data type

pg_catalog.stl_smfaults_cleared

old
column	data type
seq	int4
run	int4
recordtime	timestamp
msg	char(256)
resolution	char(256)

new
column	data type

pg_catalog.stl_smfaults_mval

old
column	data type
seq	int4
run	int4
thresh	int8
value	int8

new
column	data type

pg_catalog.stl_smfaults_overflow

old
column	data type
parent_seq	int4
parent_run	int4
seq	int4
run	int4
mon_type	char(128)
mon_name	char(128)
severity	int4
resolution_dbup	char(128)
resolution_dbdown	char(128)
code	int4
recordtime	timestamp
observer	char(15)
culprit	char(15)
msg	char(256)
xml_extra	char(2048)
has_measure_val	int4

new
column	data type

pg_catalog.stl_smlog

old
column	data type
seq	int4
ip	char(15)
process	char(15)
level	int4
recordtime	timestamp
file	char(64)
linenum	int4
sys_errno	int4
errno_str	char(64)
msg	char(256)
stack	char(512)

new
column	data type