Redshift Observatory System Table Tracker

Tables

pg_catalog.stcs_connection_error_log

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
time	int8			NN
pid	int8			NN
event	char(64)			NN
hostname	char(64)			NN
unixsocketname	char(64)			NN
familydesc	char(64)			NN
portnumber	int4			NN
error_code	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_connection_queue_error_log

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
time	int8			NN
pid	int8			NN
event	char(64)			NN
remote_host	char(50)			NN
remote_port	char(50)			NN
error_code	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_guid_based_cache_policy_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node_num	int4			NN
promote_untracked_to_cold_untouch	int8			NN
promote_cold_untouch_to_cold_touch	int8			NN
promote_cold_touch_to_hot_untouch	int8			NN
promote_hot_untouch_to_hot_touch	int8			NN
reaccess_hot_touch	int8			NN
demote_hot_touch_to_hot_untouch	int8			NN
demote_hot_untouch_to_cold_touch	int8			NN
demote_cold_touch_to_cold_untouch	int8			NN
demote_cold_untouch_to_untracked	int8			NN
cold_blocks	int8			NN
hot_blocks	int8			NN
blocks_in_cache	int8			NN
start_time	int8			NN
end_time	int8			NN
capacity	int8			NN
write_accesses	int8			NN
rerep_writes	int8			NN
hot_touched_blocks	int8			NN
hot_untouched_blocks	int8			NN
cold_touched_blocks	int8			NN
cold_untouched_blocks	int8			NN
ghost_buffer_hits	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_query_abort_reason

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	int8			NN
start_time	int8			NN
qid	int4			NN
pid	int4			NN
xid	int8			NN
userid	int4			NN
reason	char(32)			NN
exception_msg	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_session_signal

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
eventtime	int8			NN
userid	int4			NN
src_pid	int4			NN
target_pid	int4			NN
target_vpid	int4			NN
signal	int4			NN
reason	char(32)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_tbl_perm_at_drop

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
table_id	int4			NN
node	int4			NN
num_blocks	int4			NN
dist_style	int4			NN
temp	int4			NN
__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_connection_error_log

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
time	timestamp			NN
pid	int8			NN
event	char(64)			NN
hostname	char(64)			NN
unixsocketname	char(64)			NN
familydesc	char(64)			NN
portnumber	int4			NN
error_code	int4			NN

pg_catalog.stll_connection_queue_error_log

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
time	timestamp			NN
pid	int8			NN
event	char(64)			NN
remote_host	char(50)			NN
remote_port	char(50)			NN
error_code	int4			NN

pg_catalog.stll_guid_based_cache_policy_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node_num	int4			NN
promote_untracked_to_cold_untouch	int8			NN
promote_cold_untouch_to_cold_touch	int8			NN
promote_cold_touch_to_hot_untouch	int8			NN
promote_hot_untouch_to_hot_touch	int8			NN
reaccess_hot_touch	int8			NN
demote_hot_touch_to_hot_untouch	int8			NN
demote_hot_untouch_to_cold_touch	int8			NN
demote_cold_touch_to_cold_untouch	int8			NN
demote_cold_untouch_to_untracked	int8			NN
cold_blocks	int8			NN
hot_blocks	int8			NN
blocks_in_cache	int8			NN
start_time	timestamp			NN
end_time	timestamp			NN
capacity	int8			NN
write_accesses	int8			NN
rerep_writes	int8			NN
hot_touched_blocks	int8			NN
hot_untouched_blocks	int8			NN
cold_touched_blocks	int8			NN
cold_untouched_blocks	int8			NN
ghost_buffer_hits	int8			NN

pg_catalog.stll_query_abort_reason

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	timestamp			NN
start_time	timestamp			NN
qid	int4			NN
pid	int4			NN
xid	int8			NN
userid	int4			NN
reason	char(32)			NN
exception_msg	char(128)			NN

pg_catalog.stll_session_signal

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
eventtime	timestamp			NN
userid	int4			NN
src_pid	int4			NN
target_pid	int4			NN
target_vpid	int4			NN
signal	int4			NN
reason	char(32)			NN

pg_catalog.stll_tbl_perm_at_drop

old
column	data type	PK	U	NN

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

pg_catalog.stv_guid_based_cache_policy_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node_num	int4			NN
name	char(64)			NN
value	int8			NN

pg_catalog.stv_guid_based_local_block_cache_state

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
guid	char(64)			NN
sb_pos	int4			NN
state	int4			NN

pg_catalog.stcs_burst_manager_personalization

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

pg_catalog.stcs_datashare_changes_consumer

old
column	data type	PK	U	NN
userid	int4			NN
username	char(128)			NN
xid	int8			NN
pid	int4			NN
initial_query_time	int8			NN
actiontime	int8			NN
action	int4			NN
sharedbid	int4			NN
sharedbname	char(128)			NN
sharename	char(128)			NN
produceraccount	char(12)			NN
producernamespace	char(128)			NN
targettype	int4			NN
targetid	int4			NN
targetname	char(128)			NN
status	int4			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

new
column	data type	PK	U	NN
userid	int4			NN
username	char(128)			NN
xid	int8			NN
pid	int4			NN
initial_query_time	int8			NN
actiontime	int8			NN
action	int4			NN
sharedbid	int4			NN
sharedbname	char(128)			NN
sharename	char(128)			NN
produceraccount	char(12)			NN
producernamespace	char(128)			NN
targettype	int4			NN
targetid	int4			NN
targetname	char(128)			NN
status	int4			NN
message	char(512)			NN
arn	char(192)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_load_commits

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
name	char(256)			NN
filename	char(256)			NN
byte_offset	int4			NN
lines_scanned	int4			NN
errors	int4			NN
status	int4			NN
curtime	int8			NN
file_format	char(16)			NN
is_partial	int4			NN
start_offset	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
slice	int4			NN
name	char(256)			NN
filename	char(256)			NN
byte_offset	int4			NN
lines_scanned	int4			NN
errors	int4			NN
status	int4			NN
curtime	int8			NN
file_format	char(16)			NN
is_partial	int4			NN
start_offset	int8			NN
copy_job_id	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_load_errors

old
column	data type	PK	U	NN
userid	int4			NN
slice	int4			NN
tbl	int4			NN
starttime	int8			NN
session	int4			NN
query	int4			NN
filename	char(256)			NN
line_number	int8			NN
colname	char(127)			NN
type	char(10)			NN
col_length	char(10)			NN
position	int4			NN
raw_line	char(1024)			NN
raw_field_value	char(1024)			NN
err_code	int4			NN
err_reason	char(100)			NN
is_partial	int4			NN
start_offset	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
slice	int4			NN
tbl	int4			NN
starttime	int8			NN
session	int4			NN
query	int4			NN
filename	char(256)			NN
line_number	int8			NN
colname	char(127)			NN
type	char(10)			NN
col_length	char(10)			NN
position	int4			NN
raw_line	char(1024)			NN
raw_field_value	char(1024)			NN
err_code	int4			NN
err_reason	char(100)			NN
is_partial	int4			NN
start_offset	int8			NN
copy_job_id	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_load_history_base

old
column	data type	PK	U	NN
user_id	int4			NN
db	char(64)			NN
xid	int8			NN
pid	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
status	int4			NN
table_name	char(128)			NN
event_time	int8			NN
slice	int4			NN
filename	char(256)			NN
file_count	int4			NN
file_bytes	int8			NN
file_count_scanned	int4			NN
file_bytes_scanned	int8			NN
bytes_copied	int8			NN
rows_copied	int8			NN
file_format	char(16)			NN
error_count	int4			NN
data_source	char(256)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

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

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_kb_sec	int8			NN
xoff_total_ns	int8			NN
xoff_max_ns	int8			NN
queue_delay_sample_total_ns	int8			NN
queue_delay_sample_max_ns	int8			NN
rexmit_total_count	int8			NN
rexmit_max_count	int8			NN
channel_sink_init_us	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_perf_channel_source

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

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_kb_sec	int8			NN
borrow_total_ns	int8			NN
borrow_max_ns	int8			NN
queue_delay_sample_total_ns	int8			NN
queue_delay_sample_max_ns	int8			NN
channel_source_init_us	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_pg_wal_stats

old
column	data type	PK	U	NN
period_start	int8			NN
log_time	int8			NN
num_wal_inserts	int8			NN
num_wal_writes	int8			NN
num_repwal_msgs	int8			NN
total_repwal_size_kb	int8			NN
total_repwal_time_ms	int8			NN
avg_repwal_time_us	int8			NN
max_repwal_time_us	int8			NN
logged_manually	int4			NN
last_repwal_log_id	int8			NN
last_repwal_log_seg	int8			NN
last_repwal_offset	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
period_start	int8			NN
log_time	int8			NN
num_wal_inserts	int8			NN
num_wal_writes	int8			NN
num_repwal_msgs	int8			NN
total_repwal_size_kb	int8			NN
total_repwal_time_ms	int8			NN
avg_repwal_time_us	int8			NN
max_repwal_time_us	int8			NN
logged_manually	int4			NN
last_repwal_log_id	int8			NN
last_repwal_log_seg	int8			NN
last_repwal_offset	int8			NN
max_repwal_pid	int8			NN
max_repwal_xid	int8			NN
max_repwal_start_time	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_query_memory

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
consumed_mem	int8			NN
reported_mem	int8			NN
wlm_working_mem	int8			NN
cheating_working_mem	int8			NN
avg_runtime_working_mem	int8			NN
max_runtime_working_mem	int8			NN
min_runtime_working_mem	int8			NN
contributed_mem	int8			NN
pool_out_of_memory	char(1)			NN
reached_upper_bound	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
consumed_mem	int8			NN
reported_mem	int8			NN
wlm_working_mem	int8			NN
cheating_working_mem	int8			NN
avg_runtime_working_mem	int8			NN
max_runtime_working_mem	int8			NN
min_runtime_working_mem	int8			NN
contributed_mem	int8			NN
pool_out_of_memory	char(1)			NN
reached_upper_bound	char(1)			NN
memory_action	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_rls_applied_policy

old
column	data type	PK	U	NN
userid	int4			NN
plan_qid	int8			NN
xid	int8			NN
pid	int4			NN
recordtime	int8			NN
command	char(1)			NN
dbid	int4			NN
relid	int4			NN
polid	int4			NN
poldefault	char(1)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

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

old
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
__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
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
__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_undo_transactions

old
column	data type	PK	U	NN
recordtime	int8			NN
table_id	int4			NN
tables_done	int4			NN
tables_total	int4			NN
table_name	char(137)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
recordtime	int8			NN
table_id	int4			NN
tables_done	int4			NN
tables_total	int4			NN
table_name	char(137)			NN
undo_mode	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_user_query_history

old
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
compute_type	char(32)			NN
compile_time	int8			NN
planning_time	int8			NN
pure_planning_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
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
compute_type	char(32)			NN
compile_time	int8			NN
planning_time	int8			NN
pure_planning_time	int8			NN
lock_wait_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.stll_burst_manager_personalization

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

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
refreshed_backup_id	char(100)			NN
refreshed_version	int4			NN
refreshing_backup_id	char(100)			NN
refreshing_version	int4			NN

pg_catalog.stll_datashare_changes_consumer

old
column	data type	PK	U	NN
userid	int4			NN
username	char(128)			NN
xid	int8			NN
pid	int4			NN
initial_query_time	timestamp			NN
actiontime	timestamp			NN
action	int4			NN
sharedbid	int4			NN
sharedbname	char(128)			NN
sharename	char(128)			NN
produceraccount	char(12)			NN
producernamespace	char(128)			NN
targettype	int4			NN
targetid	int4			NN
targetname	char(128)			NN
status	int4			NN
message	char(512)			NN

new
column	data type	PK	U	NN
userid	int4			NN
username	char(128)			NN
xid	int8			NN
pid	int4			NN
initial_query_time	timestamp			NN
actiontime	timestamp			NN
action	int4			NN
sharedbid	int4			NN
sharedbname	char(128)			NN
sharename	char(128)			NN
produceraccount	char(12)			NN
producernamespace	char(128)			NN
targettype	int4			NN
targetid	int4			NN
targetname	char(128)			NN
status	int4			NN
message	char(512)			NN
arn	char(192)			NN

pg_catalog.stll_load_commits

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
name	char(256)			NN
filename	char(256)			NN
byte_offset	int4			NN
lines_scanned	int4			NN
errors	int4			NN
status	int4			NN
curtime	timestamp			NN
file_format	char(16)			NN
is_partial	int4			NN
start_offset	int8			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
name	char(256)			NN
filename	char(256)			NN
byte_offset	int4			NN
lines_scanned	int4			NN
errors	int4			NN
status	int4			NN
curtime	timestamp			NN
file_format	char(16)			NN
is_partial	int4			NN
start_offset	int8			NN
copy_job_id	int8			NN

pg_catalog.stll_load_errors

old
column	data type	PK	U	NN
userid	int4			NN
slice	int4			NN
tbl	int4			NN
starttime	timestamp			NN
session	int4			NN
query	int4			NN
filename	char(256)			NN
line_number	int8			NN
colname	char(127)			NN
type	char(10)			NN
col_length	char(10)			NN
position	int4			NN
raw_line	char(1024)			NN
raw_field_value	char(1024)			NN
err_code	int4			NN
err_reason	char(100)			NN
is_partial	int4			NN
start_offset	int8			NN

new
column	data type	PK	U	NN
userid	int4			NN
slice	int4			NN
tbl	int4			NN
starttime	timestamp			NN
session	int4			NN
query	int4			NN
filename	char(256)			NN
line_number	int8			NN
colname	char(127)			NN
type	char(10)			NN
col_length	char(10)			NN
position	int4			NN
raw_line	char(1024)			NN
raw_field_value	char(1024)			NN
err_code	int4			NN
err_reason	char(100)			NN
is_partial	int4			NN
start_offset	int8			NN
copy_job_id	int8			NN

pg_catalog.stll_load_history_base

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

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

pg_catalog.stll_perf_channel_sink

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

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_kb_sec	int8			NN
xoff_total_ns	int8			NN
xoff_max_ns	int8			NN
queue_delay_sample_total_ns	int8			NN
queue_delay_sample_max_ns	int8			NN
rexmit_total_count	int8			NN
rexmit_max_count	int8			NN
channel_sink_init_us	int8			NN

pg_catalog.stll_perf_channel_source

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

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_kb_sec	int8			NN
borrow_total_ns	int8			NN
borrow_max_ns	int8			NN
queue_delay_sample_total_ns	int8			NN
queue_delay_sample_max_ns	int8			NN
channel_source_init_us	int8			NN

pg_catalog.stll_pg_wal_stats

old
column	data type	PK	U	NN
period_start	timestamp			NN
log_time	timestamp			NN
num_wal_inserts	int8			NN
num_wal_writes	int8			NN
num_repwal_msgs	int8			NN
total_repwal_size_kb	int8			NN
total_repwal_time_ms	int8			NN
avg_repwal_time_us	int8			NN
max_repwal_time_us	int8			NN
logged_manually	int4			NN
last_repwal_log_id	int8			NN
last_repwal_log_seg	int8			NN
last_repwal_offset	int8			NN

new
column	data type	PK	U	NN
period_start	timestamp			NN
log_time	timestamp			NN
num_wal_inserts	int8			NN
num_wal_writes	int8			NN
num_repwal_msgs	int8			NN
total_repwal_size_kb	int8			NN
total_repwal_time_ms	int8			NN
avg_repwal_time_us	int8			NN
max_repwal_time_us	int8			NN
logged_manually	int4			NN
last_repwal_log_id	int8			NN
last_repwal_log_seg	int8			NN
last_repwal_offset	int8			NN
max_repwal_pid	int8			NN
max_repwal_xid	int8			NN
max_repwal_start_time	timestamp			NN

pg_catalog.stll_query_memory

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
consumed_mem	int8			NN
reported_mem	int8			NN
wlm_working_mem	int8			NN
cheating_working_mem	int8			NN
avg_runtime_working_mem	int8			NN
max_runtime_working_mem	int8			NN
min_runtime_working_mem	int8			NN
contributed_mem	int8			NN
pool_out_of_memory	char(1)			NN
reached_upper_bound	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
consumed_mem	int8			NN
reported_mem	int8			NN
wlm_working_mem	int8			NN
cheating_working_mem	int8			NN
avg_runtime_working_mem	int8			NN
max_runtime_working_mem	int8			NN
min_runtime_working_mem	int8			NN
contributed_mem	int8			NN
pool_out_of_memory	char(1)			NN
reached_upper_bound	char(1)			NN
memory_action	int4			NN

pg_catalog.stll_rls_applied_policy

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

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

pg_catalog.stll_s3client

old
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

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

pg_catalog.stll_undo_transactions

old
column	data type	PK	U	NN
recordtime	timestamp			NN
table_id	int4			NN
tables_done	int4			NN
tables_total	int4			NN
table_name	char(137)			NN

new
column	data type	PK	U	NN
recordtime	timestamp			NN
table_id	int4			NN
tables_done	int4			NN
tables_total	int4			NN
table_name	char(137)			NN
undo_mode	int4			NN

pg_catalog.stll_user_query_history

old
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
compute_type	char(32)			NN
compile_time	int8			NN
planning_time	int8			NN
pure_planning_time	int8			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
compute_type	char(32)			NN
compile_time	int8			NN
planning_time	int8			NN
pure_planning_time	int8			NN
lock_wait_time	int8			NN

pg_catalog.stv_last_grafted_ctxt_table_versions

old
column	data type	PK	U	NN
host	char(64)			NN
sb_version	int8			NN
table_id	int4			NN
dml_version	int8			NN
ddl_version	int8			NN
structure_version	int8			NN

new
column	data type	PK	U	NN
host	char(64)			NN
sb_version	int8			NN
table_id	int4			NN
dml_version	int8			NN
ddl_version	int8			NN
structure_version	int8			NN
structure_delete_version	int8			NN

pg_catalog.stv_preferred_ctxt_table_versions

old
column	data type	PK	U	NN
sb_version	int8			NN
table_id	int4			NN
dml_version	int8			NN
ddl_version	int8			NN
structure_version	int8			NN

new
column	data type	PK	U	NN
sb_version	int8			NN
table_id	int4			NN
dml_version	int8			NN
ddl_version	int8			NN
structure_version	int8			NN
structure_delete_version	int8			NN

pg_catalog.stv_user_query_state

old
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
compute_type	char(32)			NN
compile_time	int8			NN
planning_time	int8			NN
pure_planning_time	int8			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
compute_type	char(32)			NN
compile_time	int8			NN
planning_time	int8			NN
pure_planning_time	int8			NN
lock_wait_time	int8			NN

pg_internal.redshift_auto_health_check_20739905

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_connection_error_log

old
column	data type

new
column	data type
time	timestamp
pid	int8
event	char(64)
hostname	char(64)
unixsocketname	char(64)
familydesc	char(64)
portnumber	int4
error_code	int4

pg_catalog.stl_connection_queue_error_log

old
column	data type

new
column	data type
time	timestamp
pid	int8
event	char(64)
remote_host	char(50)
remote_port	char(50)
error_code	int4

pg_catalog.stl_guid_based_cache_policy_stats

old
column	data type

new
column	data type
node_num	int4
promote_untracked_to_cold_untouch	int8
promote_cold_untouch_to_cold_touch	int8
promote_cold_touch_to_hot_untouch	int8
promote_hot_untouch_to_hot_touch	int8
reaccess_hot_touch	int8
demote_hot_touch_to_hot_untouch	int8
demote_hot_untouch_to_cold_touch	int8
demote_cold_touch_to_cold_untouch	int8
demote_cold_untouch_to_untracked	int8
cold_blocks	int8
hot_blocks	int8
blocks_in_cache	int8
start_time	timestamp
end_time	timestamp
capacity	int8
write_accesses	int8
rerep_writes	int8
hot_touched_blocks	int8
hot_untouched_blocks	int8
cold_touched_blocks	int8
cold_untouched_blocks	int8
ghost_buffer_hits	int8

pg_catalog.stl_query_abort_reason

old
column	data type

new
column	data type
recordtime	timestamp
start_time	timestamp
qid	int4
pid	int4
xid	int8
userid	int4
reason	char(32)
exception_msg	char(128)

pg_catalog.stl_session_signal

old
column	data type

new
column	data type
eventtime	timestamp
userid	int4
src_pid	int4
target_pid	int4
target_vpid	int4
signal	int4
reason	char(32)

pg_catalog.stl_tbl_perm_at_drop

old
column	data type

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

pg_catalog.svl_datashare_cross_region_usage

old
column	data type

new
column	data type
query	int4
segment	int8
start_time	int8
end_time	int8
transferred_data	int8
source_region	char(64)

pg_catalog.sys_copy_job

old
column	data type

new
column	data type
job_id	oid
job_name	text
job_owner	int4
table_id	oid
data_source	text
iam_role	text
copy_query	text
is_auto	bool
on_error_suspend	bool

pg_catalog.sys_unload_detail

old
column	data type

new
column	data type
user_id	int4
query_id	int8
session_id	int4
transaction_id	int8
path	char(1280)
start_time	timestamp
end_time	timestamp
line_count	int8
transfer_size	int8
file_format	char(10)

pg_catalog.stl_burst_manager_personalization

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

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
refreshed_backup_id	char(100)
refreshed_version	int4
refreshing_backup_id	char(100)
refreshing_version	int4

pg_catalog.stl_datashare_changes_consumer

old
column	data type
userid	int4
username	char(128)
xid	int8
pid	int4
initial_query_time	timestamp
actiontime	timestamp
action	int4
sharedbid	int4
sharedbname	char(128)
sharename	char(128)
produceraccount	char(12)
producernamespace	char(128)
targettype	int4
targetid	int4
targetname	char(128)
status	int4
message	char(512)

new
column	data type
userid	int4
username	char(128)
xid	int8
pid	int4
initial_query_time	timestamp
actiontime	timestamp
action	int4
sharedbid	int4
sharedbname	char(128)
sharename	char(128)
produceraccount	char(12)
producernamespace	char(128)
targettype	int4
targetid	int4
targetname	char(128)
status	int4
message	char(512)
arn	char(192)

pg_catalog.stl_load_commits

old
column	data type
userid	int4
query	int4
slice	int4
name	char(256)
filename	char(256)
byte_offset	int4
lines_scanned	int4
errors	int4
status	int4
curtime	timestamp
file_format	char(16)
is_partial	int4
start_offset	int8

new
column	data type
userid	int4
query	int4
slice	int4
name	char(256)
filename	char(256)
byte_offset	int4
lines_scanned	int4
errors	int4
status	int4
curtime	timestamp
file_format	char(16)
is_partial	int4
start_offset	int8
copy_job_id	int8

pg_catalog.stl_load_errors

old
column	data type
userid	int4
slice	int4
tbl	int4
starttime	timestamp
session	int4
query	int4
filename	char(256)
line_number	int8
colname	char(127)
type	char(10)
col_length	char(10)
position	int4
raw_line	char(1024)
raw_field_value	char(1024)
err_code	int4
err_reason	char(100)
is_partial	int4
start_offset	int8

new
column	data type
userid	int4
slice	int4
tbl	int4
starttime	timestamp
session	int4
query	int4
filename	char(256)
line_number	int8
colname	char(127)
type	char(10)
col_length	char(10)
position	int4
raw_line	char(1024)
raw_field_value	char(1024)
err_code	int4
err_reason	char(100)
is_partial	int4
start_offset	int8
copy_job_id	int8

pg_catalog.stl_load_history_base

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

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

pg_catalog.stl_perf_channel_sink

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

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_kb_sec	int8
xoff_total_ns	int8
xoff_max_ns	int8
queue_delay_sample_total_ns	int8
queue_delay_sample_max_ns	int8
rexmit_total_count	int8
rexmit_max_count	int8
channel_sink_init_us	int8

pg_catalog.stl_perf_channel_source

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

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_kb_sec	int8
borrow_total_ns	int8
borrow_max_ns	int8
queue_delay_sample_total_ns	int8
queue_delay_sample_max_ns	int8
channel_source_init_us	int8

pg_catalog.stl_pg_wal_stats

old
column	data type
period_start	timestamp
log_time	timestamp
num_wal_inserts	int8
num_wal_writes	int8
num_repwal_msgs	int8
total_repwal_size_kb	int8
total_repwal_time_ms	int8
avg_repwal_time_us	int8
max_repwal_time_us	int8
logged_manually	int4
last_repwal_log_id	int8
last_repwal_log_seg	int8
last_repwal_offset	int8

new
column	data type
period_start	timestamp
log_time	timestamp
num_wal_inserts	int8
num_wal_writes	int8
num_repwal_msgs	int8
total_repwal_size_kb	int8
total_repwal_time_ms	int8
avg_repwal_time_us	int8
max_repwal_time_us	int8
logged_manually	int4
last_repwal_log_id	int8
last_repwal_log_seg	int8
last_repwal_offset	int8
max_repwal_pid	int8
max_repwal_xid	int8
max_repwal_start_time	timestamp

pg_catalog.stl_query_memory

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
consumed_mem	int8
reported_mem	int8
wlm_working_mem	int8
cheating_working_mem	int8
avg_runtime_working_mem	int8
max_runtime_working_mem	int8
min_runtime_working_mem	int8
contributed_mem	int8
pool_out_of_memory	char(1)
reached_upper_bound	char(1)

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
consumed_mem	int8
reported_mem	int8
wlm_working_mem	int8
cheating_working_mem	int8
avg_runtime_working_mem	int8
max_runtime_working_mem	int8
min_runtime_working_mem	int8
contributed_mem	int8
pool_out_of_memory	char(1)
reached_upper_bound	char(1)
memory_action	int4

pg_catalog.stl_rls_applied_policy

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

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

pg_catalog.stl_s3client

old
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

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

pg_catalog.stl_undo_transactions

old
column	data type
recordtime	timestamp
table_id	int4
tables_done	int4
tables_total	int4
table_name	char(137)

new
column	data type
recordtime	timestamp
table_id	int4
tables_done	int4
tables_total	int4
table_name	char(137)
undo_mode	int4

pg_catalog.stl_user_query_history

old
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)
compute_type	char(32)
compile_time	int8
planning_time	int8
pure_planning_time	int8

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)
compute_type	char(32)
compile_time	int8
planning_time	int8
pure_planning_time	int8
lock_wait_time	int8

pg_catalog.svl_datashare_change_log

old
column	data type
userid	int4
username	varchar(128)
pid	int4
xid	int8
share_id	int4
share_name	varchar(128)
source_database_id	int4
source_database_name	varchar(128)
consumer_database_id	int4
consumer_database_name	varchar(128)
recordtime	timestamp
action	varchar(128)
status	int4
share_object_type	varchar(64)
share_object_id	int4
share_object_name	varchar(128)
target_user_type	varchar(16)
target_userid	int4
target_username	varchar(128)
consumer_account	varchar(16)
consumer_namespace	varchar(64)
producer_account	varchar(16)
producer_namespace	varchar(64)
attribute_name	varchar(64)
attribute_value	varchar(128)
message	varchar(512)

new
column	data type
userid	int4
username	varchar(128)
pid	int4
xid	int8
share_id	int4
share_name	varchar(128)
source_database_id	int4
source_database_name	varchar(128)
consumer_database_id	int4
consumer_database_name	varchar(128)
arn	char(192)
recordtime	timestamp
action	varchar(128)
status	int4
share_object_type	varchar(64)
share_object_id	int4
share_object_name	varchar(128)
target_user_type	varchar(16)
target_userid	int4
target_username	varchar(128)
consumer_account	varchar(16)
consumer_namespace	varchar(64)
producer_account	varchar(16)
producer_namespace	varchar(64)
attribute_name	varchar(64)
attribute_value	varchar(128)
message	varchar(512)

pg_catalog.svv_external_databases

old
column	data type
eskind	int4
esoptions	varchar(128)
databasename	varchar(128)
location	varchar(128)
parameters	varchar(128)

new
column	data type
eskind	int4
esoptions	text
databasename	text
location	text
parameters	text

pg_catalog.svv_redshift_databases

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

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

pg_catalog.svv_table_info

old
column	data type
database	text
schema	text
table_id	oid
table	text
encoded	text
diststyle	text
sortkey1	text
max_varchar	int4
sortkey1_enc	char(32)
sortkey_num	int4
size	int8
pct_used	numeric(10,4)
empty	int8
unsorted	numeric(5,2)
stats_off	numeric(5,2)
tbl_rows	numeric(38,0)
skew_sortkey1	numeric(19,2)
skew_rows	numeric(19,2)
estimated_visible_rows	numeric(38,0)
risk_event	text
vacuum_sort_benefit	numeric(12,2)

new
column	data type
database	text
schema	text
table_id	oid
table	text
encoded	text
diststyle	text
sortkey1	text
max_varchar	int4
sortkey1_enc	char(32)
sortkey_num	int4
size	int8
pct_used	numeric(10,4)
empty	int8
unsorted	numeric(5,2)
stats_off	numeric(5,2)
tbl_rows	numeric(38,0)
skew_sortkey1	numeric(19,2)
skew_rows	numeric(19,2)
estimated_visible_rows	numeric(38,0)
risk_event	text
vacuum_sort_benefit	numeric(12,2)
create_time	timestamp

pg_catalog.sys_datashare_change_log

old
column	data type
user_id	int4
user_name	varchar(128)
session_id	int4
transaction_id	int8
share_id	int4
share_name	varchar(128)
source_database_id	int4
source_database_name	varchar(128)
consumer_database_id	int4
consumer_database_name	varchar(128)
record_time	timestamp
action	varchar(128)
status	int4
share_object_type	varchar(64)
share_object_id	int4
share_object_name	varchar(128)
target_user_type	varchar(16)
target_user_id	int4
target_user_name	varchar(128)
consumer_account	varchar(16)
consumer_namespace	varchar(64)
producer_account	varchar(16)
producer_namespace	varchar(64)
attribute_name	varchar(64)
attribute_value	varchar(128)
message	varchar(512)

new
column	data type
user_id	int4
user_name	varchar(128)
session_id	int4
transaction_id	int8
share_id	int4
share_name	varchar(128)
source_database_id	int4
source_database_name	varchar(128)
consumer_database_id	int4
consumer_database_name	varchar(128)
arn	char(192)
record_time	timestamp
action	varchar(128)
status	int4
share_object_type	varchar(64)
share_object_id	int4
share_object_name	varchar(128)
target_user_type	varchar(16)
target_user_id	int4
target_user_name	varchar(128)
consumer_account	varchar(16)
consumer_namespace	varchar(64)
producer_account	varchar(16)
producer_namespace	varchar(64)
attribute_name	varchar(64)
attribute_value	varchar(128)
message	varchar(512)

pg_catalog.sys_load_history

old
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
database_name	text
status	text
table_name	text
start_time	timestamp
end_time	timestamp
duration	int8
data_source	text
file_format	text
loaded_rows	int8
loaded_bytes	int8
source_file_count	int8
source_file_bytes	int8
file_count_scanned	int8
file_bytes_scanned	int8
error_count	int8

new
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
database_name	text
status	text
table_name	text
start_time	timestamp
end_time	timestamp
duration	int8
data_source	text
file_format	text
loaded_rows	int8
loaded_bytes	int8
source_file_count	int8
source_file_bytes	int8
file_count_scanned	int8
file_bytes_scanned	int8
error_count	int8
copy_job_id	int8

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

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