Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
new	pg_catalog	internal	immutable	geometry	h3_boundary	cstring
new	pg_catalog	internal	immutable	geometry	h3_boundary	int8
new	pg_catalog	internal	immutable	geometry	h3_boundary	text
new	pg_catalog	internal	immutable	geometry	h3_center	cstring
new	pg_catalog	internal	immutable	geometry	h3_center	int8
new	pg_catalog	internal	immutable	geometry	h3_center	text

Tables

pg_catalog.stcs_burst_push_model_prepare

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
pid	int8			NN
time	int8			NN
cluster_arn	char(128)			NN
is_push_notification	char(1)			NN
has_timed_out	char(1)			NN
push_notification_timeout	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_integration_user_activity

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
db_name	char(128)			NN
origin	char(64)			NN
external_time	int8			NN
type	char(64)			NN
option	char(64)			NN
message	char(1024)			NN
status	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

pg_catalog.stcs_internal_analyze_query

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
table_id	int4			NN
analyze_kind	int4			NN
group_size	int4			NN
group_attnums	char(160)			NN
rows_scanned	int8			NN
delta_start_xid	int8			NN
delta_finished_xids_min	int8			NN
delta_finished_xids_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_local_s3_scan_fetches

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
slice	int4			NN
file	char(512)			NN
column_id	int4			NN
num_fetches	int8			NN
min_fetch_size_bytes	int8			NN
max_fetch_size_bytes	int8			NN
avg_fetch_size_bytes	int8			NN
min_fetch_time_ms	int8			NN
max_fetch_time_ms	int8			NN
avg_fetch_time_ms	int8			NN
num_used_fetches	int8			NN
num_unused_fetches	int8			NN
num_aborted_fetches	int8			NN
num_retried_fetches	int8			NN
num_fetch_errors	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_local_s3_scan_file_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
slice	int4			NN
file	char(512)			NN
file_type	int4			NN
file_size_bytes	int8			NN
num_columns	int8			NN
footer_size_bytes	int8			NN
page_index_size_bytes	int8			NN
num_row_groups	int8			NN
min_row_group_size_bytes	int8			NN
max_row_group_size_bytes	int8			NN
avg_row_group_size_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_local_s3_scan_io_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
slice	int4			NN
min_used_parallelism	int8			NN
max_used_parallelism	int8			NN
avg_used_parallelism	int8			NN
min_max_parallelism	int8			NN
max_max_parallelism	int8			NN
avg_max_parallelism	int8			NN
min_used_memory	int8			NN
max_used_memory	int8			NN
avg_used_memory	int8			NN
min_max_memory	int8			NN
max_max_memory	int8			NN
avg_max_memory	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_local_s3_scan_read_requests

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
slice	int4			NN
file	char(512)			NN
request_category	int4			NN
column_id	int4			NN
num_requests	int8			NN
min_request_size_bytes	int8			NN
max_request_size_bytes	int8			NN
avg_request_size_bytes	int8			NN
num_prefetched_hits	int8			NN
num_loading_prefetch_hits	int8			NN
num_prefetch_misses	int8			NN
num_cancelled_prefetch_calls	int8			NN
num_stitched_reads	int8			NN
on_demand_wait_time_ms	int8			NN
prefetch_wait_time_ms	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_local_s3_scan_sr_generation

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
init_num_rg_small_file	int4			NN
final_num_rg_small_file	int4			NN
init_num_rg_large_file	int4			NN
final_num_rg_large_file	int4			NN
init_num_sr_small_file	int4			NN
final_num_sr_small_file	int4			NN
init_num_sr_large_file	int4			NN
final_num_sr_large_file	int4			NN
distinct_files	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_pg_lock_shared_inserts

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
log_time	int8			NN
xid	int8			NN
tbl	int4			NN
insert_type	int4			NN
lock_count	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_planner_print

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
pid	int4			NN
xid	int8			NN
user_query_id	int8			NN
recordtime	int8			NN
message	char(1024)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_s3client_internal

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
recordtime	int8			NN
pid	int4			NN
http_method	char(64)			NN
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
transfer_size	int8			NN
data_size	int8			NN
start_time	int8			NN
end_time	int8			NN
transfer_time	int8			NN
compression_time	int8			NN
connect_time	int8			NN
app_connect_time	int8			NN
retries	int4			NN
request_id	char(32)			NN
extended_request_id	char(128)			NN
ip_address	char(64)			NN
thread_id	int4			NN
original_start_time_us	int8			NN
total_transfer_time_us_with_retries	int8			NN
node	int4			NN
tbl_id	int4			NN
one_perm_rep	int4			NN
flags	int4			NN
s3_write_type	char(64)			NN
is_s3commit_write	int4			NN
is_partial	int4			NN
start_offset	int8			NN
col_num	int4			NN
is_wam_write	int4			NN
wam_precommit_id	int4			NN
region	char(64)			NN
is_xregion	int4			NN
is_spectrum_request	int4			NN
segnum	int8			NN
sb_pos	int4			NN
access_control	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_table_partition_update

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
eventtime	int8			NN
xid	int4			NN
query	int4			NN
table_id	int4			NN
slice	int4			NN
partition_id	int4			NN
row_count	int8			NN
row_count_before_update	int8			NN
flags	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_burst_push_model_prepare

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
pid	int8			NN
time	timestamp			NN
cluster_arn	char(128)			NN
is_push_notification	char(1)			NN
has_timed_out	char(1)			NN
push_notification_timeout	timestamp			NN

pg_catalog.stll_integration_user_activity

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
db_name	char(128)			NN
origin	char(64)			NN
external_time	timestamp			NN
type	char(64)			NN
option	char(64)			NN
message	char(1024)			NN
status	char(1024)			NN

pg_catalog.stll_internal_analyze_query

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
table_id	int4			NN
analyze_kind	int4			NN
group_size	int4			NN
group_attnums	char(160)			NN
rows_scanned	int8			NN
delta_start_xid	int8			NN
delta_finished_xids_min	int8			NN
delta_finished_xids_size	int8			NN

pg_catalog.stll_local_s3_scan_fetches

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
slice	int4			NN
file	char(512)			NN
column_id	int4			NN
num_fetches	int8			NN
min_fetch_size_bytes	int8			NN
max_fetch_size_bytes	int8			NN
avg_fetch_size_bytes	int8			NN
min_fetch_time_ms	int8			NN
max_fetch_time_ms	int8			NN
avg_fetch_time_ms	int8			NN
num_used_fetches	int8			NN
num_unused_fetches	int8			NN
num_aborted_fetches	int8			NN
num_retried_fetches	int8			NN
num_fetch_errors	int8			NN

pg_catalog.stll_local_s3_scan_file_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
slice	int4			NN
file	char(512)			NN
file_type	int4			NN
file_size_bytes	int8			NN
num_columns	int8			NN
footer_size_bytes	int8			NN
page_index_size_bytes	int8			NN
num_row_groups	int8			NN
min_row_group_size_bytes	int8			NN
max_row_group_size_bytes	int8			NN
avg_row_group_size_bytes	int8			NN

pg_catalog.stll_local_s3_scan_io_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
slice	int4			NN
min_used_parallelism	int8			NN
max_used_parallelism	int8			NN
avg_used_parallelism	int8			NN
min_max_parallelism	int8			NN
max_max_parallelism	int8			NN
avg_max_parallelism	int8			NN
min_used_memory	int8			NN
max_used_memory	int8			NN
avg_used_memory	int8			NN
min_max_memory	int8			NN
max_max_memory	int8			NN
avg_max_memory	int8			NN

pg_catalog.stll_local_s3_scan_read_requests

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
slice	int4			NN
file	char(512)			NN
request_category	int4			NN
column_id	int4			NN
num_requests	int8			NN
min_request_size_bytes	int8			NN
max_request_size_bytes	int8			NN
avg_request_size_bytes	int8			NN
num_prefetched_hits	int8			NN
num_loading_prefetch_hits	int8			NN
num_prefetch_misses	int8			NN
num_cancelled_prefetch_calls	int8			NN
num_stitched_reads	int8			NN
on_demand_wait_time_ms	int8			NN
prefetch_wait_time_ms	int8			NN

pg_catalog.stll_local_s3_scan_sr_generation

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
init_num_rg_small_file	int4			NN
final_num_rg_small_file	int4			NN
init_num_rg_large_file	int4			NN
final_num_rg_large_file	int4			NN
init_num_sr_small_file	int4			NN
final_num_sr_small_file	int4			NN
init_num_sr_large_file	int4			NN
final_num_sr_large_file	int4			NN
distinct_files	int4			NN

pg_catalog.stll_pg_lock_shared_inserts

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
log_time	timestamp			NN
xid	int8			NN
tbl	int4			NN
insert_type	int4			NN
lock_count	int4			NN

pg_catalog.stll_planner_print

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
pid	int4			NN
xid	int8			NN
user_query_id	int8			NN
recordtime	timestamp			NN
message	char(1024)			NN

pg_catalog.stll_s3client_internal

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
recordtime	timestamp			NN
pid	int4			NN
http_method	char(64)			NN
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
transfer_size	int8			NN
data_size	int8			NN
start_time	int8			NN
end_time	int8			NN
transfer_time	int8			NN
compression_time	int8			NN
connect_time	int8			NN
app_connect_time	int8			NN
retries	int4			NN
request_id	char(32)			NN
extended_request_id	char(128)			NN
ip_address	char(64)			NN
thread_id	int4			NN
original_start_time_us	int8			NN
total_transfer_time_us_with_retries	int8			NN
node	int4			NN
tbl_id	int4			NN
one_perm_rep	int4			NN
flags	int4			NN
s3_write_type	char(64)			NN
is_s3commit_write	int4			NN
is_partial	int4			NN
start_offset	int8			NN
col_num	int4			NN
is_wam_write	int4			NN
wam_precommit_id	int4			NN
region	char(64)			NN
is_xregion	int4			NN
is_spectrum_request	int4			NN
segnum	int8			NN
sb_pos	int4			NN
access_control	int4			NN

pg_catalog.stll_table_partition_update

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
eventtime	timestamp			NN
xid	int4			NN
query	int4			NN
table_id	int4			NN
slice	int4			NN
partition_id	int4			NN
row_count	int8			NN
row_count_before_update	int8			NN
flags	int4			NN

pg_internal.redshift_auto_health_check_6918109

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_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
log_blocks_written	int4			NN
encrypted_log_blocks_written	int4			NN
new_sb_tree_blocks	int8			NN
tossed_sb_tree_blocks	int8			NN
num_rerep_writes_skipped	int8			NN
num_rerep_writes_issued	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
num_rerep_writes_skipped	int8			NN
num_rerep_writes_issued	int8			NN
num_bg_rereps_skipped	int8			NN
num_bg_rerep_writes_issued	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_internal_query_details

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
initial_query_time	int8			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
reported_peak_usage_bytes	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
exec_time_wo_compilation	int8			NN
exec_cluster_size	int4			NN
auto_mounted_tables_accessed	int4			NN
spectrum_file_count	int4			NN
datasharing_spectrum_tables_accessed	int4			NN
lf_datasharing_spectrum_tables_accessed	int4			NN
num_pce_segs	int4			NN
slice_unmerge_query	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
initial_query_time	int8			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
reported_peak_usage_bytes	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
exec_time_wo_compilation	int8			NN
exec_cluster_size	int4			NN
auto_mounted_tables_accessed	int4			NN
spectrum_file_count	int4			NN
datasharing_spectrum_tables_accessed	int4			NN
lf_datasharing_spectrum_tables_accessed	int4			NN
num_pce_segs	int4			NN
slice_unmerge_query	int4			NN
sample_based_col_count	int4			NN
sketch_based_col_count	int4			NN
userid	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_sage_mode_policy

old
column	data type	PK	U	NN
policy_id	int4			NN
optimization_start_time	int8			NN
creation_time	int8			NN
expiration_time	int8			NN
performance_level	int4			NN
resize_config	char(200)			NN
current_size_config	char(200)			NN
simulated_cost_rpu_sec	float8			NN
simulated_avg_response_time_sec	float8			NN
selected	int4			NN
used_forecast	int4			NN
replay_start	int8			NN
replay_end	int8			NN
simulated_total_response_time_sec	float8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
policy_id	int4			NN
optimization_start_time	int8			NN
creation_time	int8			NN
expiration_time	int8			NN
performance_level	int4			NN
resize_config	char(200)			NN
current_size_config	char(200)			NN
simulated_cost_rpu_sec	float8			NN
simulated_avg_response_time_sec	float8			NN
selected	int4			NN
used_forecast	int4			NN
replay_start	int8			NN
replay_end	int8			NN
simulated_total_response_time_sec	float8			NN
simulated_num_queries	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_sage_mode_simulation_clusters

old
column	data type	PK	U	NN
simulation_id	char(36)			NN
trace_id	int4			NN
trace_chunk_start_time	int8			NN
trace_chunk_end_time	int8			NN
ssid	int4			NN
nodes	int4			NN
creation_time	int8			NN
currenttime	int8			NN
end_time	int8			NN
state	int4			NN
detached_time	int8			NN
finished_queries	int8			NN
running_queries	int4			NN
occupied_query_mb	int8			NN
avg_response_time_ms	int8			NN
billed_rpu_ms	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
simulation_id	char(36)			NN
trace_id	int4			NN
trace_chunk_start_time	int8			NN
trace_chunk_end_time	int8			NN
ssid	int4			NN
nodes	int4			NN
creation_time	int8			NN
currenttime	int8			NN
end_time	int8			NN
state	int4			NN
detached_time	int8			NN
finished_queries	int8			NN
running_queries	int4			NN
occupied_query_mb	int8			NN
avg_response_time_ms	int8			NN
billed_rpu_ms	int8			NN
fallback	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_sage_mode_simulation_queries

old
column	data type	PK	U	NN
simulation_id	char(36)			NN
trace_id	int4			NN
query_id	int4			NN
arrival_time	int8			NN
burstable	int4			NN
exec_start_time	int8			NN
ssid	int4			NN
cluster_size	int4			NN
est_execution_time_ms	float8			NN
est_queue_time_ms	float8			NN
est_cost_rpu_ms	float8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
simulation_id	char(36)			NN
trace_id	int4			NN
query_id	int4			NN
arrival_time	int8			NN
burstable	int4			NN
exec_start_time	int8			NN
ssid	int4			NN
cluster_size	int4			NN
est_execution_time_ms	float8			NN
est_queue_time_ms	float8			NN
est_cost_rpu_ms	float8			NN
fallback	int4			NN
closed_loop_id	int4			NN
ordering_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_sage_mode_simulation_summary

old
column	data type	PK	U	NN
simulation_id	char(36)			NN
update_time	int8			NN
update_elapsed_ms	float8			NN
params	char(400)			NN
trace_id	int4			NN
trace_chunk_start_time	int8			NN
trace_chunk_end_time	int8			NN
cost_rpu_ms	float8			NN
avg_runtime_ms	float8			NN
num_queries	int8			NN
total_queries	int8			NN
num_transitions	int8			NN
num_skipped_queries	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
simulation_id	char(36)			NN
update_time	int8			NN
update_elapsed_ms	float8			NN
params	char(400)			NN
trace_id	int4			NN
trace_chunk_start_time	int8			NN
trace_chunk_end_time	int8			NN
cost_rpu_ms	float8			NN
avg_runtime_ms	float8			NN
num_queries	int8			NN
total_queries	int8			NN
num_transitions	int8			NN
num_skipped_queries	int8			NN
broken_closed_loops	int8			NN
num_fallback_queries	int8			NN
is_completion_run	int4			NN
num_pending_events	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_sage_query_trace_data

old
column	data type	PK	U	NN
event_time	int8			NN
query_id	int4			NN
inflight	int4			NN
burstable	int4			NN
arrival_time	int8			NN
execution_time_ms	int4			NN
consumed_megabytes	int4			NN
cluster_size	int4			NN
predicted_execution_times	char(400)			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
event_time	int8			NN
query_id	int4			NN
inflight	int4			NN
burstable	int4			NN
arrival_time	int8			NN
execution_time_ms	int4			NN
consumed_megabytes	int4			NN
cluster_size	int4			NN
predicted_execution_times	char(400)			NN
closed_loop_id	int4			NN
position_in_loop	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_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
log_blocks_written	int4			NN
encrypted_log_blocks_written	int4			NN
new_sb_tree_blocks	int8			NN
tossed_sb_tree_blocks	int8			NN
num_rerep_writes_skipped	int8			NN
num_rerep_writes_issued	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
num_rerep_writes_skipped	int8			NN
num_rerep_writes_issued	int8			NN
num_bg_rereps_skipped	int8			NN
num_bg_rerep_writes_issued	int8			NN

pg_catalog.stll_internal_query_details

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

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

pg_catalog.stll_sage_mode_policy

old
column	data type	PK	U	NN
policy_id	int4			NN
optimization_start_time	timestamp			NN
creation_time	timestamp			NN
expiration_time	timestamp			NN
performance_level	int4			NN
resize_config	char(200)			NN
current_size_config	char(200)			NN
simulated_cost_rpu_sec	float8			NN
simulated_avg_response_time_sec	float8			NN
selected	int4			NN
used_forecast	int4			NN
replay_start	timestamp			NN
replay_end	timestamp			NN
simulated_total_response_time_sec	float8			NN

new
column	data type	PK	U	NN
policy_id	int4			NN
optimization_start_time	timestamp			NN
creation_time	timestamp			NN
expiration_time	timestamp			NN
performance_level	int4			NN
resize_config	char(200)			NN
current_size_config	char(200)			NN
simulated_cost_rpu_sec	float8			NN
simulated_avg_response_time_sec	float8			NN
selected	int4			NN
used_forecast	int4			NN
replay_start	timestamp			NN
replay_end	timestamp			NN
simulated_total_response_time_sec	float8			NN
simulated_num_queries	int8			NN

pg_catalog.stll_sage_mode_simulation_clusters

old
column	data type	PK	U	NN
simulation_id	char(36)			NN
trace_id	int4			NN
trace_chunk_start_time	timestamp			NN
trace_chunk_end_time	timestamp			NN
ssid	int4			NN
nodes	int4			NN
creation_time	timestamp			NN
currenttime	timestamp			NN
end_time	timestamp			NN
state	int4			NN
detached_time	timestamp			NN
finished_queries	int8			NN
running_queries	int4			NN
occupied_query_mb	int8			NN
avg_response_time_ms	int8			NN
billed_rpu_ms	int8			NN

new
column	data type	PK	U	NN
simulation_id	char(36)			NN
trace_id	int4			NN
trace_chunk_start_time	timestamp			NN
trace_chunk_end_time	timestamp			NN
ssid	int4			NN
nodes	int4			NN
creation_time	timestamp			NN
currenttime	timestamp			NN
end_time	timestamp			NN
state	int4			NN
detached_time	timestamp			NN
finished_queries	int8			NN
running_queries	int4			NN
occupied_query_mb	int8			NN
avg_response_time_ms	int8			NN
billed_rpu_ms	int8			NN
fallback	int4			NN

pg_catalog.stll_sage_mode_simulation_queries

old
column	data type	PK	U	NN
simulation_id	char(36)			NN
trace_id	int4			NN
query_id	int4			NN
arrival_time	timestamp			NN
burstable	int4			NN
exec_start_time	timestamp			NN
ssid	int4			NN
cluster_size	int4			NN
est_execution_time_ms	float8			NN
est_queue_time_ms	float8			NN
est_cost_rpu_ms	float8			NN

new
column	data type	PK	U	NN
simulation_id	char(36)			NN
trace_id	int4			NN
query_id	int4			NN
arrival_time	timestamp			NN
burstable	int4			NN
exec_start_time	timestamp			NN
ssid	int4			NN
cluster_size	int4			NN
est_execution_time_ms	float8			NN
est_queue_time_ms	float8			NN
est_cost_rpu_ms	float8			NN
fallback	int4			NN
closed_loop_id	int4			NN
ordering_time	timestamp			NN

pg_catalog.stll_sage_mode_simulation_summary

old
column	data type	PK	U	NN
simulation_id	char(36)			NN
update_time	timestamp			NN
update_elapsed_ms	float8			NN
params	char(400)			NN
trace_id	int4			NN
trace_chunk_start_time	timestamp			NN
trace_chunk_end_time	timestamp			NN
cost_rpu_ms	float8			NN
avg_runtime_ms	float8			NN
num_queries	int8			NN
total_queries	int8			NN
num_transitions	int8			NN
num_skipped_queries	int8			NN

new
column	data type	PK	U	NN
simulation_id	char(36)			NN
update_time	timestamp			NN
update_elapsed_ms	float8			NN
params	char(400)			NN
trace_id	int4			NN
trace_chunk_start_time	timestamp			NN
trace_chunk_end_time	timestamp			NN
cost_rpu_ms	float8			NN
avg_runtime_ms	float8			NN
num_queries	int8			NN
total_queries	int8			NN
num_transitions	int8			NN
num_skipped_queries	int8			NN
broken_closed_loops	int8			NN
num_fallback_queries	int8			NN
is_completion_run	int4			NN
num_pending_events	int4			NN

pg_catalog.stll_sage_query_trace_data

old
column	data type	PK	U	NN
event_time	timestamp			NN
query_id	int4			NN
inflight	int4			NN
burstable	int4			NN
arrival_time	timestamp			NN
execution_time_ms	int4			NN
consumed_megabytes	int4			NN
cluster_size	int4			NN
predicted_execution_times	char(400)			NN

new
column	data type	PK	U	NN
event_time	timestamp			NN
query_id	int4			NN
inflight	int4			NN
burstable	int4			NN
arrival_time	timestamp			NN
execution_time_ms	int4			NN
consumed_megabytes	int4			NN
cluster_size	int4			NN
predicted_execution_times	char(400)			NN
closed_loop_id	int4			NN
position_in_loop	int4			NN

pg_catalog.stv_integration

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

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

pg_catalog.stv_sage_query_trace_metrics

old
column	data type	PK	U	NN
query_id	int4			NN
arrival_time	timestamp			NN
inflight	int4			NN
burstable	int4			NN
cluster_size	int4			NN
execution_time_ms	int4			NN
consumed_megabytes	int4			NN
predicted_execution_times	char(400)			NN
closed_loop_id	int4			NN
last_in_closed_loop	int4			NN

new
column	data type	PK	U	NN
query_id	int4			NN
arrival_time	timestamp			NN
inflight	int4			NN
burstable	int4			NN
cluster_size	int4			NN
execution_time_ms	int4			NN
consumed_megabytes	int4			NN
predicted_execution_times	char(400)			NN
closed_loop_id	int4			NN
last_in_closed_loop	int4			NN
first_in_closed_loop	int4			NN

pg_internal.redshift_auto_health_check_6917767

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_push_model_prepare

old
column	data type

new
column	data type
pid	int8
time	timestamp
cluster_arn	char(128)
is_push_notification	char(1)
has_timed_out	char(1)
push_notification_timeout	timestamp

pg_catalog.stl_integration_user_activity

old
column	data type

new
column	data type
record_time	timestamp
integration_id	char(128)
db_name	char(128)
origin	char(64)
external_time	timestamp
type	char(64)
option	char(64)
message	char(1024)
status	char(1024)

pg_catalog.stl_internal_analyze_query

old
column	data type

new
column	data type
query	int4
xid	int8
table_id	int4
analyze_kind	int4
group_size	int4
group_attnums	char(160)
rows_scanned	int8
delta_start_xid	int8
delta_finished_xids_min	int8
delta_finished_xids_size	int8

pg_catalog.stl_local_s3_scan_fetches

old
column	data type

new
column	data type
query	int4
segment	int4
slice	int4
file	char(512)
column_id	int4
num_fetches	int8
min_fetch_size_bytes	int8
max_fetch_size_bytes	int8
avg_fetch_size_bytes	int8
min_fetch_time_ms	int8
max_fetch_time_ms	int8
avg_fetch_time_ms	int8
num_used_fetches	int8
num_unused_fetches	int8
num_aborted_fetches	int8
num_retried_fetches	int8
num_fetch_errors	int8

pg_catalog.stl_local_s3_scan_file_stats

old
column	data type

new
column	data type
query	int4
segment	int4
slice	int4
file	char(512)
file_type	int4
file_size_bytes	int8
num_columns	int8
footer_size_bytes	int8
page_index_size_bytes	int8
num_row_groups	int8
min_row_group_size_bytes	int8
max_row_group_size_bytes	int8
avg_row_group_size_bytes	int8

pg_catalog.stl_local_s3_scan_io_stats

old
column	data type

new
column	data type
query	int4
segment	int4
slice	int4
min_used_parallelism	int8
max_used_parallelism	int8
avg_used_parallelism	int8
min_max_parallelism	int8
max_max_parallelism	int8
avg_max_parallelism	int8
min_used_memory	int8
max_used_memory	int8
avg_used_memory	int8
min_max_memory	int8
max_max_memory	int8
avg_max_memory	int8

pg_catalog.stl_local_s3_scan_read_requests

old
column	data type

new
column	data type
query	int4
segment	int4
slice	int4
file	char(512)
request_category	int4
column_id	int4
num_requests	int8
min_request_size_bytes	int8
max_request_size_bytes	int8
avg_request_size_bytes	int8
num_prefetched_hits	int8
num_loading_prefetch_hits	int8
num_prefetch_misses	int8
num_cancelled_prefetch_calls	int8
num_stitched_reads	int8
on_demand_wait_time_ms	int8
prefetch_wait_time_ms	int8

pg_catalog.stl_local_s3_scan_sr_generation

old
column	data type

new
column	data type
query	int4
segment	int4
step	int4
node	int4
slice	int4
init_num_rg_small_file	int4
final_num_rg_small_file	int4
init_num_rg_large_file	int4
final_num_rg_large_file	int4
init_num_sr_small_file	int4
final_num_sr_small_file	int4
init_num_sr_large_file	int4
final_num_sr_large_file	int4
distinct_files	int4

pg_catalog.stl_pg_lock_shared_inserts

old
column	data type

new
column	data type
log_time	timestamp
xid	int8
tbl	int4
insert_type	int4
lock_count	int4

pg_catalog.stl_planner_print

old
column	data type

new
column	data type
user_id	int4
pid	int4
xid	int8
user_query_id	int8
recordtime	timestamp
message	char(1024)

pg_catalog.stl_s3client_internal

old
column	data type

new
column	data type
userid	int4
query	int4
slice	int4
recordtime	timestamp
pid	int4
http_method	char(64)
s3_action	char(64)
bucket	char(64)
key	char(256)
transfer_size	int8
data_size	int8
start_time	int8
end_time	int8
transfer_time	int8
compression_time	int8
connect_time	int8
app_connect_time	int8
retries	int4
request_id	char(32)
extended_request_id	char(128)
ip_address	char(64)
thread_id	int4
original_start_time_us	int8
total_transfer_time_us_with_retries	int8
node	int4
tbl_id	int4
one_perm_rep	int4
flags	int4
s3_write_type	char(64)
is_s3commit_write	int4
is_partial	int4
start_offset	int8
col_num	int4
is_wam_write	int4
wam_precommit_id	int4
region	char(64)
is_xregion	int4
is_spectrum_request	int4
segnum	int8
sb_pos	int4

pg_catalog.stl_table_partition_update

old
column	data type

new
column	data type
eventtime	timestamp
xid	int4
query	int4
table_id	int4
slice	int4
partition_id	int4
row_count	int8
row_count_before_update	int8
flags	int4

pg_catalog.svv_integration_table_mapping

old
column	data type

new
column	data type
integration_id	char(128)
source_database	char(128)
target_database	char(128)
source_schema_name	char(128)
target_schema_name	char(128)
source_table_name	char(128)
target_table_name	char(128)
source_column_name	char(128)
target_column_name	char(128)
source_data_type	char(128)
target_data_type	char(128)

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
log_blocks_written	int4
encrypted_log_blocks_written	int4
new_sb_tree_blocks	int8
tossed_sb_tree_blocks	int8
num_rerep_writes_skipped	int8
num_rerep_writes_issued	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
num_rerep_writes_skipped	int8
num_rerep_writes_issued	int8
num_bg_rereps_skipped	int8
num_bg_rerep_writes_issued	int8

pg_catalog.stl_internal_query_details

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

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

pg_catalog.stl_sage_mode_policy

old
column	data type
policy_id	int4
optimization_start_time	timestamp
creation_time	timestamp
expiration_time	timestamp
performance_level	int4
resize_config	char(200)
current_size_config	char(200)
simulated_cost_rpu_sec	float8
simulated_avg_response_time_sec	float8
selected	int4
used_forecast	int4
replay_start	timestamp
replay_end	timestamp
simulated_total_response_time_sec	float8

new
column	data type
policy_id	int4
optimization_start_time	timestamp
creation_time	timestamp
expiration_time	timestamp
performance_level	int4
resize_config	char(200)
current_size_config	char(200)
simulated_cost_rpu_sec	float8
simulated_avg_response_time_sec	float8
selected	int4
used_forecast	int4
replay_start	timestamp
replay_end	timestamp
simulated_total_response_time_sec	float8
simulated_num_queries	int8

pg_catalog.stl_sage_mode_simulation_clusters

old
column	data type
simulation_id	char(36)
trace_id	int4
trace_chunk_start_time	timestamp
trace_chunk_end_time	timestamp
ssid	int4
nodes	int4
creation_time	timestamp
currenttime	timestamp
end_time	timestamp
state	int4
detached_time	timestamp
finished_queries	int8
running_queries	int4
occupied_query_mb	int8
avg_response_time_ms	int8
billed_rpu_ms	int8

new
column	data type
simulation_id	char(36)
trace_id	int4
trace_chunk_start_time	timestamp
trace_chunk_end_time	timestamp
ssid	int4
nodes	int4
creation_time	timestamp
currenttime	timestamp
end_time	timestamp
state	int4
detached_time	timestamp
finished_queries	int8
running_queries	int4
occupied_query_mb	int8
avg_response_time_ms	int8
billed_rpu_ms	int8
fallback	int4

pg_catalog.stl_sage_mode_simulation_queries

old
column	data type
simulation_id	char(36)
trace_id	int4
query_id	int4
arrival_time	timestamp
burstable	int4
exec_start_time	timestamp
ssid	int4
cluster_size	int4
est_execution_time_ms	float8
est_queue_time_ms	float8
est_cost_rpu_ms	float8

new
column	data type
simulation_id	char(36)
trace_id	int4
query_id	int4
arrival_time	timestamp
burstable	int4
exec_start_time	timestamp
ssid	int4
cluster_size	int4
est_execution_time_ms	float8
est_queue_time_ms	float8
est_cost_rpu_ms	float8
fallback	int4
closed_loop_id	int4
ordering_time	timestamp

pg_catalog.stl_sage_mode_simulation_summary

old
column	data type
simulation_id	char(36)
update_time	timestamp
update_elapsed_ms	float8
params	char(400)
trace_id	int4
trace_chunk_start_time	timestamp
trace_chunk_end_time	timestamp
cost_rpu_ms	float8
avg_runtime_ms	float8
num_queries	int8
total_queries	int8
num_transitions	int8
num_skipped_queries	int8

new
column	data type
simulation_id	char(36)
update_time	timestamp
update_elapsed_ms	float8
params	char(400)
trace_id	int4
trace_chunk_start_time	timestamp
trace_chunk_end_time	timestamp
cost_rpu_ms	float8
avg_runtime_ms	float8
num_queries	int8
total_queries	int8
num_transitions	int8
num_skipped_queries	int8
broken_closed_loops	int8
num_fallback_queries	int8
is_completion_run	int4
num_pending_events	int4

pg_catalog.stl_sage_query_trace_data

old
column	data type
event_time	timestamp
query_id	int4
inflight	int4
burstable	int4
arrival_time	timestamp
execution_time_ms	int4
consumed_megabytes	int4
cluster_size	int4
predicted_execution_times	char(400)

new
column	data type
event_time	timestamp
query_id	int4
inflight	int4
burstable	int4
arrival_time	timestamp
execution_time_ms	int4
consumed_megabytes	int4
cluster_size	int4
predicted_execution_times	char(400)
closed_loop_id	int4
position_in_loop	int4

pg_catalog.svv_attached_masking_policy

old
column	data type
policy_name	varchar(128)
schema_name	varchar(128)
table_name	varchar(128)
table_type	varchar(17)
grantor	varchar(128)
grantee	varchar(128)
grantee_type	varchar(6)
priority	int4
input_columns	varchar(256)
output_columns	varchar(256)

new
column	data type
policy_name	varchar(128)
schema_name	varchar(128)
table_name	varchar(128)
table_type	varchar(17)
grantor	varchar(128)
grantee	varchar(128)
grantee_type	varchar(6)
priority	int4
input_columns	varchar(256)
output_columns	varchar(256)
is_masking_datashare_on	char(1)

pg_catalog.svv_integration

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

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

pg_catalog.svv_integration_table_state

old
column	data type
integration_id	char(128)
target_database	char(128)
schema_name	char(128)
table_name	char(128)
table_state	char(128)
table_last_replicated_checkpoint	char(128)
reason	char(256)
last_updated_timestamp	timestamp
table_rows	int8
table_size	int8

new
column	data type
integration_id	char(128)
target_database	char(128)
schema_name	char(128)
table_name	char(128)
table_state	char(128)
table_last_replicated_checkpoint	char(128)
reason	char(256)
last_updated_timestamp	timestamp
table_rows	int8
table_size	int8
is_history_mode	bool

pg_catalog.sys_query_history

old
column	data type
user_id	int4
query_id	int8
query_label	varchar(320)
transaction_id	int8
session_id	int4
database_name	varchar(128)
query_type	varchar(32)
status	char(10)
result_cache_hit	bool
start_time	timestamp
end_time	timestamp
elapsed_time	int8
queue_time	int8
execution_time	int8
error_message	varchar(512)
returned_rows	int8
returned_bytes	int8
query_text	varchar(4000)
redshift_version	char(32)
usage_limit	varchar(150)
compute_type	varchar(32)
compile_time	int8
planning_time	int8
lock_wait_time	int8
service_class_id	int4
service_class_name	char(64)
query_priority	char(20)
short_query_accelerated	char(10)
user_query_hash	char(40)
generic_query_hash	char(40)
query_hash_version	int4

new
column	data type
user_id	int4
query_id	int8
query_label	varchar(320)
transaction_id	int8
session_id	int4
database_name	varchar(128)
query_type	varchar(32)
status	char(10)
result_cache_hit	bool
start_time	timestamp
end_time	timestamp
elapsed_time	int8
queue_time	int8
execution_time	int8
error_message	varchar(512)
returned_rows	int8
returned_bytes	int8
query_text	varchar(4000)
redshift_version	char(32)
usage_limit	varchar(150)
compute_type	varchar(32)
compile_time	int8
planning_time	int8
lock_wait_time	int8
service_class_id	int4
service_class_name	char(64)
query_priority	char(20)
short_query_accelerated	char(10)
user_query_hash	char(40)
generic_query_hash	char(40)
query_hash_version	int4
result_cache_query_id	int8