Redshift Research Project System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
new	pg_catalog	internal	immutable	geometry	st_geomfromgeojson	cstring
new	pg_catalog	internal	immutable	geometry	st_geomfromgeojson	text

Tables

pg_catalog.stcs_auto_task_events

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
actor_pid	int4			NN
task_type	char(100)			NN
task_state	char(50)			NN
priority	float8			NN
run_queries	int4			NN
pid	int4			NN
retry_count	int4			NN
production_time	int8			NN
max_execution_time_sec	int4			NN
event_time	int8			NN
message	char(100)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_pg_wal_stats

old
column	data type	PK	U	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
__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_concurrency_scaling_fail_reasons

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
timestamp	int8			NN
concurrency_scaling_status	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_xrestore_cluster_level_distkey_tables

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
tbl	int4			NN
action	char(64)			NN
event_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_auto_task_events

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
actor_pid	int4			NN
task_type	char(100)			NN
task_state	char(50)			NN
priority	float8			NN
run_queries	int4			NN
pid	int4			NN
retry_count	int4			NN
production_time	int8			NN
max_execution_time_sec	int4			NN
event_time	timestamp			NN
message	char(100)			NN

pg_catalog.stll_pg_wal_stats

old
column	data type	PK	U	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

pg_catalog.stll_query_concurrency_scaling_fail_reasons

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
timestamp	timestamp			NN
concurrency_scaling_status	int4			NN

pg_catalog.stll_xrestore_cluster_level_distkey_tables

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
tbl	int4			NN
action	char(64)			NN
event_time	timestamp			NN

pg_catalog.stv_auto_task_queue_state

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
task_type	char(50)			NN
task_state	char(50)			NN
priority	float8			NN
run_queries	int4			NN
pid	int4			NN
retry_count	int4			NN
production_time	int8			NN
max_execution_time_sec	int4			NN
message	char(100)			NN

pg_catalog.pg_cast

old
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
castsource	oid			NN
casttarget	oid			NN
castfunc	oid			NN
castcontext	char(1)			NN

new
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
castsource	oid			NN
casttarget	oid			NN
castfunc	oid			NN
castcontext	char(1)			NN
trycastfunc	oid			NN

pg_catalog.stcs_alter_dist_sort

old
column	data type	PK	U	NN
xid	int8			NN
cutoff_xid	int8			NN
tbl	int4			NN
event	char(128)			NN
src_rows	int8			NN
dest_rows	int8			NN
redo_delete_rows	int8			NN
undone_rows	int8			NN
undone_txns	int8			NN
eventtime	int8			NN
origin_dist_style	int4			NN
num_sort_keys	int4			NN
target_distkey	int4			NN
request_sort	int4			NN
num_sort_iterations	int4			NN
dst_sorted_rows	int8			NN
is_autoworker_altered	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
xid	int8			NN
cutoff_xid	int8			NN
tbl	int4			NN
event	char(128)			NN
src_rows	int8			NN
dest_rows	int8			NN
redo_delete_rows	int8			NN
undone_rows	int8			NN
undone_txns	int8			NN
eventtime	int8			NN
origin_dist_style	int4			NN
num_sort_keys	int4			NN
target_distkey	int4			NN
request_sort	int4			NN
num_sort_iterations	int4			NN
dst_sorted_rows	int8			NN
is_autoworker_altered	int4			NN
src_table_num_blocks	int8			NN
nth_checkpoint	int4			NN
pid	int4			NN
shadow_tbl_num_blocks	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_arcadia_billing_xact_log

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	int8			NN
xid	int8			NN
pid	int4			NN
xact_tag	int4			NN
xact_start_loc	int4			NN
xact_stop_loc	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

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

old
column	data type	PK	U	NN
currenttime	int8			NN
backup_id	char(256)			NN
sb_version	int8			NN
starttime	int8			NN
in_progress	int4			NN
error_code	int4			NN
error_msg	char(256)			NN
enc_key_hash_base64	char(44)			NN
tlr_metadata_successful	int4			NN
tlr_metadata_time	int8			NN
tlr_metadata_error_msg	char(256)			NN
partial	int4			NN
backup_superblock_format	int4			NN
time_wait_commit_lock	int8			NN
time_hold_commit_lock	int8			NN
time_spent_commit_transaction	int8			NN
inc_no_backup	int8			NN
sb_version_stage3	int8			NN
backup_superblock_method	int4			NN
num_tables	int4			NN
inc_resize_lock_optional	int4			NN
inc_resize_lock_mandatory	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
currenttime	int8			NN
backup_id	char(256)			NN
sb_version	int8			NN
starttime	int8			NN
in_progress	int4			NN
error_code	int4			NN
error_msg	char(256)			NN
enc_key_hash_base64	char(44)			NN
tlr_metadata_successful	int4			NN
tlr_metadata_time	int8			NN
tlr_metadata_error_msg	char(256)			NN
partial	int4			NN
backup_superblock_format	int4			NN
time_wait_commit_lock	int8			NN
time_hold_commit_lock	int8			NN
time_spent_commit_transaction	int8			NN
inc_no_backup	int8			NN
sb_version_stage3	int8			NN
backup_superblock_method	int4			NN
num_tables	int4			NN
inc_resize_lock_optional	int4			NN
inc_resize_lock_mandatory	int4			NN
cluster_id	char(256)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

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

pg_catalog.stcs_commit_internal_stats

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

pg_catalog.stcs_datashare_request_producer

old
column	data type	PK	U	NN
userid	int4			NN
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
xid	int8			NN
__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
est_peak_mem_needed	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
__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
est_peak_mem_needed	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
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_kinesis_outbound_requests

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	int8			NN
request_type	char(64)			NN
request_payload	char(4096)			NN
err_reason	char(128)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	int8			NN
request_type	char(64)			NN
request_payload	char(4096)			NN
err_reason	char(128)			NN
shard_id	char(128)			NN
__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_block_stats

old
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
block_reads	int4			NN
block_faults	int4			NN
total_block_fetchtime	int8			NN
max_block_fetchtime	int8			NN
transblock_reads	int4			NN
transblock_faults	int4			NN
total_transblock_fetchtime	int8			NN
max_transblock_fetchtime	int8			NN
blocks_used	int8			NN
block_reads_already_in_s3	int4			NN
disk_fetches	int8			NN
disk_prefetches	int8			NN
s3_fetches	int8			NN
s3_prefetches	int8			NN
trans_block_fetches	int8			NN
trans_block_prefetches	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
block_reads	int4			NN
block_faults	int4			NN
total_block_fetchtime	int8			NN
max_block_fetchtime	int8			NN
transblock_reads	int4			NN
transblock_faults	int4			NN
total_transblock_fetchtime	int8			NN
max_transblock_fetchtime	int8			NN
blocks_used	int8			NN
block_reads_already_in_s3	int4			NN
disk_fetches	int8			NN
disk_prefetches	int8			NN
s3_fetches	int8			NN
s3_prefetches	int8			NN
trans_block_fetches	int8			NN
trans_block_prefetches	int8			NN
megatrans_block_reads	int8			NN
megatrans_block_fault	int8			NN
megatrans_block_fetches	int8			NN
megatrans_block_prefetches	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_query_detail

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
stream_id	int4			NN
segment_id	int4			NN
step_id	int4			NN
slice	int4			NN
starttime	int8			NN
endtime	int8			NN
step_name	int4			NN
table_id	int4			NN
table_name	char(136)			NN
input_rows	int8			NN
input_bytes	int8			NN
output_rows	int8			NN
output_bytes	int8			NN
is_rrscan	char(1)			NN
blocks_read	int8			NN
blocks_write	int8			NN
local_read_io	int8			NN
remote_read_io	int8			NN
alert	char(1024)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

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

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
uuid	char(36)			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
eventtime	int8			NN
bucket	char(256)			NN
prefix	char(256)			NN
recursive	char(1)			NN
retrieved_files	int4			NN
max_file_size	int8			NN
avg_file_size	float8			NN
duration	int8			NN
generated_splits	int4			NN
avg_split_length	float8			NN
scan_type	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
uuid	char(36)			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
eventtime	int8			NN
bucket	char(256)			NN
prefix	char(256)			NN
recursive	char(1)			NN
retrieved_files	int4			NN
max_file_size	int8			NN
avg_file_size	float8			NN
duration	int8			NN
generated_splits	int4			NN
avg_split_length	float8			NN
scan_type	int4			NN
list_type	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_s3requests

old
column	data type	PK	U	NN
query	int4			NN
uuid	char(36)			NN
pid	int4			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
eventtime	int8			NN
duration	int8			NN
retry_count	int4			NN
returned_rows	int8			NN
fetched	int4			NN
file_size	int8			NN
start_offset	int8			NN
length	int8			NN
file_name	char(512)			NN
last_timeout	int8			NN
failed	int4			NN
etag	char(512)			NN
num_splits	int4			NN
cache_status	int4			NN
returned_bytes	int8			NN
s3_scanned_rows	int8			NN
s3_scanned_bytes	int8			NN
location	char(128)			NN
latency_caching_batches	int8			NN
latency_caching_manifest	int8			NN
row_groups	int8			NN
skipped_row_groups	int8			NN
skipped_rows	int8			NN
expected_duration	int8			NN
read_count	int8			NN
slowdown_count	int4			NN
scan_type	int4			NN
s3_physical_scanned_bytes	int8			NN
returned_uncompressed_bytes	int8			NN
starttime	int8			NN
peak_memory_utilization	int4			NN
codegen_time	int8			NN
total_storage_wait_time	int8			NN
total_query_cpu_time	int8			NN
scan_cpu_time	int8			NN
hostname	char(100)			NN
spectrum_starttime	int8			NN
spectrum_endtime	int8			NN
client_fetch_wait_time	int8			NN
cache_uncompressed_size	int8			NN
cache_compressed_size	int8			NN
cache_compression_latency	int8			NN
abort_reason	int4			NN
cache_objects_count	int4			NN
backoff_time	int8			NN
connect_retries	int4			NN
connect_time	int8			NN
exectask_time	int8			NN
fetch_time	int8			NN
tokens	int4			NN
request_id	char(16)			NN
fetch_error_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	int4			NN
uuid	char(36)			NN
pid	int4			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
eventtime	int8			NN
duration	int8			NN
retry_count	int4			NN
returned_rows	int8			NN
fetched	int4			NN
file_size	int8			NN
start_offset	int8			NN
length	int8			NN
file_name	char(512)			NN
last_timeout	int8			NN
failed	int4			NN
etag	char(512)			NN
num_splits	int4			NN
cache_status	int4			NN
returned_bytes	int8			NN
s3_scanned_rows	int8			NN
s3_scanned_bytes	int8			NN
location	char(128)			NN
latency_caching_batches	int8			NN
latency_caching_manifest	int8			NN
row_groups	int8			NN
skipped_row_groups	int8			NN
skipped_rows	int8			NN
expected_duration	int8			NN
read_count	int8			NN
slowdown_count	int4			NN
scan_type	int4			NN
s3_physical_scanned_bytes	int8			NN
returned_uncompressed_bytes	int8			NN
starttime	int8			NN
peak_memory_utilization	int4			NN
codegen_time	int8			NN
total_storage_wait_time	int8			NN
total_query_cpu_time	int8			NN
scan_cpu_time	int8			NN
hostname	char(100)			NN
spectrum_starttime	int8			NN
spectrum_endtime	int8			NN
client_fetch_wait_time	int8			NN
cache_uncompressed_size	int8			NN
cache_compressed_size	int8			NN
cache_compression_latency	int8			NN
abort_reason	int4			NN
cache_objects_count	int4			NN
backoff_time	int8			NN
connect_retries	int4			NN
connect_time	int8			NN
exectask_time	int8			NN
fetch_time	int8			NN
tokens	int4			NN
request_id	char(16)			NN
fetch_error_count	int8			NN
serialize_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_superblock_vacuum

old
column	data type	PK	U	NN
leaderstarttime	int8			NN
node	int4			NN
nodestarttime	int8			NN
nodeendtime	int8			NN
commitstarttime	int8			NN
commitendtime	int8			NN
success	int4			NN
permbefore	int8			NN
tempbefore	int8			NN
leadersnapshotbefore	int8			NN
pgwalbefore	int8			NN
metadatabefore	int8			NN
freebefore	int8			NN
allocatedbefore	int8			NN
permafter	int8			NN
tempafter	int8			NN
leadersnapshotafter	int8			NN
pgwalafter	int8			NN
metadataafter	int8			NN
freeafter	int8			NN
allocatedafter	int8			NN
freelistbefore	int8			NN
freelistafter	int8			NN
logbefore	int8			NN
logafter	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
leaderstarttime	int8			NN
node	int4			NN
nodestarttime	int8			NN
nodeendtime	int8			NN
commitstarttime	int8			NN
commitendtime	int8			NN
success	int4			NN
permbefore	int8			NN
tempbefore	int8			NN
leadersnapshotbefore	int8			NN
pgwalbefore	int8			NN
metadatabefore	int8			NN
freebefore	int8			NN
allocatedbefore	int8			NN
permafter	int8			NN
tempafter	int8			NN
leadersnapshotafter	int8			NN
pgwalafter	int8			NN
metadataafter	int8			NN
freeafter	int8			NN
allocatedafter	int8			NN
freelistbefore	int8			NN
freelistafter	int8			NN
logbefore	int8			NN
logafter	int8			NN
sbtreebefore	int8			NN
sbtreeafter	int8			NN
tombstonedsbtreebefore	int8			NN
tombstonedsbtreeafter	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_xrestore_alter_distkey

old
column	data type	PK	U	NN
pid	int4			NN
xid	int8			NN
tbl	int4			NN
column_name	char(200)			NN
event_time	int8			NN
message	char(350)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
pid	int4			NN
xid	int8			NN
tbl	int4			NN
column_name	char(200)			NN
event_time	int8			NN
message	char(350)			NN
elapsed_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.stll_alter_dist_sort

old
column	data type	PK	U	NN
xid	int8			NN
cutoff_xid	int8			NN
tbl	int4			NN
event	char(128)			NN
src_rows	int8			NN
dest_rows	int8			NN
redo_delete_rows	int8			NN
undone_rows	int8			NN
undone_txns	int8			NN
eventtime	timestamp			NN
origin_dist_style	int4			NN
num_sort_keys	int4			NN
target_distkey	int4			NN
request_sort	int4			NN
num_sort_iterations	int4			NN
dst_sorted_rows	int8			NN
is_autoworker_altered	int4			NN

new
column	data type	PK	U	NN
xid	int8			NN
cutoff_xid	int8			NN
tbl	int4			NN
event	char(128)			NN
src_rows	int8			NN
dest_rows	int8			NN
redo_delete_rows	int8			NN
undone_rows	int8			NN
undone_txns	int8			NN
eventtime	timestamp			NN
origin_dist_style	int4			NN
num_sort_keys	int4			NN
target_distkey	int4			NN
request_sort	int4			NN
num_sort_iterations	int4			NN
dst_sorted_rows	int8			NN
is_autoworker_altered	int4			NN
src_table_num_blocks	int8			NN
nth_checkpoint	int4			NN
pid	int4			NN
shadow_tbl_num_blocks	int8			NN

pg_catalog.stll_arcadia_billing_xact_log

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

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

pg_catalog.stll_backup_leader

old
column	data type	PK	U	NN
currenttime	timestamp			NN
backup_id	char(256)			NN
sb_version	int8			NN
starttime	timestamp			NN
in_progress	int4			NN
error_code	int4			NN
error_msg	char(256)			NN
enc_key_hash_base64	char(44)			NN
tlr_metadata_successful	int4			NN
tlr_metadata_time	int8			NN
tlr_metadata_error_msg	char(256)			NN
partial	int4			NN
backup_superblock_format	int4			NN
time_wait_commit_lock	int8			NN
time_hold_commit_lock	int8			NN
time_spent_commit_transaction	int8			NN
inc_no_backup	int8			NN
sb_version_stage3	int8			NN
backup_superblock_method	int4			NN
num_tables	int4			NN
inc_resize_lock_optional	int4			NN
inc_resize_lock_mandatory	int4			NN

new
column	data type	PK	U	NN
currenttime	timestamp			NN
backup_id	char(256)			NN
sb_version	int8			NN
starttime	timestamp			NN
in_progress	int4			NN
error_code	int4			NN
error_msg	char(256)			NN
enc_key_hash_base64	char(44)			NN
tlr_metadata_successful	int4			NN
tlr_metadata_time	int8			NN
tlr_metadata_error_msg	char(256)			NN
partial	int4			NN
backup_superblock_format	int4			NN
time_wait_commit_lock	int8			NN
time_hold_commit_lock	int8			NN
time_spent_commit_transaction	int8			NN
inc_no_backup	int8			NN
sb_version_stage3	int8			NN
backup_superblock_method	int4			NN
num_tables	int4			NN
inc_resize_lock_optional	int4			NN
inc_resize_lock_mandatory	int4			NN
cluster_id	char(256)			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

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

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

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

pg_catalog.stll_datashare_request_producer

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

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

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

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

pg_catalog.stll_kinesis_outbound_requests

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

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

pg_catalog.stll_query_block_stats

old
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
block_reads	int4			NN
block_faults	int4			NN
total_block_fetchtime	int8			NN
max_block_fetchtime	int8			NN
transblock_reads	int4			NN
transblock_faults	int4			NN
total_transblock_fetchtime	int8			NN
max_transblock_fetchtime	int8			NN
blocks_used	int8			NN
block_reads_already_in_s3	int4			NN
disk_fetches	int8			NN
disk_prefetches	int8			NN
s3_fetches	int8			NN
s3_prefetches	int8			NN
trans_block_fetches	int8			NN
trans_block_prefetches	int8			NN

new
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
block_reads	int4			NN
block_faults	int4			NN
total_block_fetchtime	int8			NN
max_block_fetchtime	int8			NN
transblock_reads	int4			NN
transblock_faults	int4			NN
total_transblock_fetchtime	int8			NN
max_transblock_fetchtime	int8			NN
blocks_used	int8			NN
block_reads_already_in_s3	int4			NN
disk_fetches	int8			NN
disk_prefetches	int8			NN
s3_fetches	int8			NN
s3_prefetches	int8			NN
trans_block_fetches	int8			NN
trans_block_prefetches	int8			NN
megatrans_block_reads	int8			NN
megatrans_block_fault	int8			NN
megatrans_block_fetches	int8			NN
megatrans_block_prefetches	int8			NN

pg_catalog.stll_query_detail

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

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

pg_catalog.stll_s3list

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
uuid	char(36)			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
eventtime	timestamp			NN
bucket	char(256)			NN
prefix	char(256)			NN
recursive	char(1)			NN
retrieved_files	int4			NN
max_file_size	int8			NN
avg_file_size	float8			NN
duration	int8			NN
generated_splits	int4			NN
avg_split_length	float8			NN
scan_type	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
uuid	char(36)			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
eventtime	timestamp			NN
bucket	char(256)			NN
prefix	char(256)			NN
recursive	char(1)			NN
retrieved_files	int4			NN
max_file_size	int8			NN
avg_file_size	float8			NN
duration	int8			NN
generated_splits	int4			NN
avg_split_length	float8			NN
scan_type	int4			NN
list_type	int4			NN

pg_catalog.stll_s3requests

old
column	data type	PK	U	NN
query	int4			NN
uuid	char(36)			NN
pid	int4			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
eventtime	timestamp			NN
duration	int8			NN
retry_count	int4			NN
returned_rows	int8			NN
fetched	int4			NN
file_size	int8			NN
start_offset	int8			NN
length	int8			NN
file_name	char(512)			NN
last_timeout	int8			NN
failed	int4			NN
etag	char(512)			NN
num_splits	int4			NN
cache_status	int4			NN
returned_bytes	int8			NN
s3_scanned_rows	int8			NN
s3_scanned_bytes	int8			NN
location	char(128)			NN
latency_caching_batches	int8			NN
latency_caching_manifest	int8			NN
row_groups	int8			NN
skipped_row_groups	int8			NN
skipped_rows	int8			NN
expected_duration	int8			NN
read_count	int8			NN
slowdown_count	int4			NN
scan_type	int4			NN
s3_physical_scanned_bytes	int8			NN
returned_uncompressed_bytes	int8			NN
starttime	timestamp			NN
peak_memory_utilization	int4			NN
codegen_time	int8			NN
total_storage_wait_time	int8			NN
total_query_cpu_time	int8			NN
scan_cpu_time	int8			NN
hostname	char(100)			NN
spectrum_starttime	timestamp			NN
spectrum_endtime	timestamp			NN
client_fetch_wait_time	int8			NN
cache_uncompressed_size	int8			NN
cache_compressed_size	int8			NN
cache_compression_latency	int8			NN
abort_reason	int4			NN
cache_objects_count	int4			NN
backoff_time	int8			NN
connect_retries	int4			NN
connect_time	timestamp			NN
exectask_time	timestamp			NN
fetch_time	timestamp			NN
tokens	int4			NN
request_id	char(16)			NN
fetch_error_count	int8			NN

new
column	data type	PK	U	NN
query	int4			NN
uuid	char(36)			NN
pid	int4			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
eventtime	timestamp			NN
duration	int8			NN
retry_count	int4			NN
returned_rows	int8			NN
fetched	int4			NN
file_size	int8			NN
start_offset	int8			NN
length	int8			NN
file_name	char(512)			NN
last_timeout	int8			NN
failed	int4			NN
etag	char(512)			NN
num_splits	int4			NN
cache_status	int4			NN
returned_bytes	int8			NN
s3_scanned_rows	int8			NN
s3_scanned_bytes	int8			NN
location	char(128)			NN
latency_caching_batches	int8			NN
latency_caching_manifest	int8			NN
row_groups	int8			NN
skipped_row_groups	int8			NN
skipped_rows	int8			NN
expected_duration	int8			NN
read_count	int8			NN
slowdown_count	int4			NN
scan_type	int4			NN
s3_physical_scanned_bytes	int8			NN
returned_uncompressed_bytes	int8			NN
starttime	timestamp			NN
peak_memory_utilization	int4			NN
codegen_time	int8			NN
total_storage_wait_time	int8			NN
total_query_cpu_time	int8			NN
scan_cpu_time	int8			NN
hostname	char(100)			NN
spectrum_starttime	timestamp			NN
spectrum_endtime	timestamp			NN
client_fetch_wait_time	int8			NN
cache_uncompressed_size	int8			NN
cache_compressed_size	int8			NN
cache_compression_latency	int8			NN
abort_reason	int4			NN
cache_objects_count	int4			NN
backoff_time	int8			NN
connect_retries	int4			NN
connect_time	timestamp			NN
exectask_time	timestamp			NN
fetch_time	timestamp			NN
tokens	int4			NN
request_id	char(16)			NN
fetch_error_count	int8			NN
serialize_time	int8			NN

pg_catalog.stll_superblock_vacuum

old
column	data type	PK	U	NN
leaderstarttime	timestamp			NN
node	int4			NN
nodestarttime	timestamp			NN
nodeendtime	timestamp			NN
commitstarttime	timestamp			NN
commitendtime	timestamp			NN
success	int4			NN
permbefore	int8			NN
tempbefore	int8			NN
leadersnapshotbefore	int8			NN
pgwalbefore	int8			NN
metadatabefore	int8			NN
freebefore	int8			NN
allocatedbefore	int8			NN
permafter	int8			NN
tempafter	int8			NN
leadersnapshotafter	int8			NN
pgwalafter	int8			NN
metadataafter	int8			NN
freeafter	int8			NN
allocatedafter	int8			NN
freelistbefore	int8			NN
freelistafter	int8			NN
logbefore	int8			NN
logafter	int8			NN

new
column	data type	PK	U	NN
leaderstarttime	timestamp			NN
node	int4			NN
nodestarttime	timestamp			NN
nodeendtime	timestamp			NN
commitstarttime	timestamp			NN
commitendtime	timestamp			NN
success	int4			NN
permbefore	int8			NN
tempbefore	int8			NN
leadersnapshotbefore	int8			NN
pgwalbefore	int8			NN
metadatabefore	int8			NN
freebefore	int8			NN
allocatedbefore	int8			NN
permafter	int8			NN
tempafter	int8			NN
leadersnapshotafter	int8			NN
pgwalafter	int8			NN
metadataafter	int8			NN
freeafter	int8			NN
allocatedafter	int8			NN
freelistbefore	int8			NN
freelistafter	int8			NN
logbefore	int8			NN
logafter	int8			NN
sbtreebefore	int8			NN
sbtreeafter	int8			NN
tombstonedsbtreebefore	int8			NN
tombstonedsbtreeafter	int8			NN

pg_catalog.stll_xrestore_alter_distkey

old
column	data type	PK	U	NN
pid	int4			NN
xid	int8			NN
tbl	int4			NN
column_name	char(200)			NN
event_time	timestamp			NN
message	char(350)			NN

new
column	data type	PK	U	NN
pid	int4			NN
xid	int8			NN
tbl	int4			NN
column_name	char(200)			NN
event_time	timestamp			NN
message	char(350)			NN
elapsed_us	int8			NN

pg_catalog.stv_disk_cache_state

old
column	data type	PK	U	NN
node	int4			NN
cache_size_mb	float8			NN
size_limit_mb	float8			NN
lru_size	int8			NN
throttle_points	int8			NN
ra_points	float8			NN
scans_running	int4			NN
rowsets_currently_in_cache	int8			NN
rowsets_currently_pinned	int8			NN
percentage_shared_mem_used	float8			NN
cache_shd_mem_perc	float8			NN
size_delta_mb	int4			NN
high_water_mark	int8			NN
low_water_mark	int8			NN

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

pg_catalog.stcs_load_error_detail_base

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
pid	int4			NN
db	char(64)			NN
xid	int8			NN
slice	int4			NN
table_id	int4			NN
starttime	int8			NN
filename	char(256)			NN
line_number	int8			NN
col_name	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
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_query_history_base

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
db	char(64)			NN
query_type	char(32)			NN
query_text	char(4000)			NN
eventtime	int8			NN
status	char(10)			NN
result_cache_source_query	int8			NN
concurrency_scaling_status	int4			NN
error_message	char(512)			NN
task	int4			NN
service_class	int4			NN
returned_rows	int8			NN
returned_bytes	int8			NN
total_queue_time	int8			NN
total_exec_time	int8			NN
redshift_version	char(256)			NN
location_tag	char(32)			NN
usage_limit	char(150)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_load_error_detail_base

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
pid	int4			NN
db	char(64)			NN
xid	int8			NN
slice	int4			NN
table_id	int4			NN
starttime	timestamp			NN
filename	char(256)			NN
line_number	int8			NN
col_name	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

new
column	data type	PK	U	NN

pg_catalog.stll_query_history_base

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
db	char(64)			NN
query_type	char(32)			NN
query_text	char(4000)			NN
eventtime	timestamp			NN
status	char(10)			NN
result_cache_source_query	int8			NN
concurrency_scaling_status	int4			NN
error_message	char(512)			NN
task	int4			NN
service_class	int4			NN
returned_rows	int8			NN
returned_bytes	int8			NN
total_queue_time	int8			NN
total_exec_time	int8			NN
redshift_version	char(256)			NN
location_tag	char(32)			NN
usage_limit	char(150)			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_4799635

old
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
a	int4

new
column	data type	PK	U	NN

Views

pg_catalog.stl_auto_task_events

old
column	data type

new
column	data type
actor_pid	int4
task_type	char(100)
task_state	char(50)
priority	float8
run_queries	int4
pid	int4
retry_count	int4
production_time	int8
max_execution_time_sec	int4
event_time	timestamp
message	char(100)

pg_catalog.stl_pg_wal_stats

old
column	data type

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

pg_catalog.stl_query_concurrency_scaling_fail_reasons

old
column	data type

new
column	data type
userid	int4
xid	int8
pid	int4
query	int4
timestamp	timestamp
concurrency_scaling_status	int4

pg_catalog.stl_xrestore_cluster_level_distkey_tables

old
column	data type

new
column	data type
tbl	int4
action	char(64)
event_time	timestamp

pg_catalog.svl_restore_alter_table_progress

old
column	data type

new
column	data type
tbl	int4
progress	varchar(41)
message	char(350)

pg_catalog.svv_geography_columns

old
column	data type

new
column	data type
f_table_catalog	varchar(128)
f_table_schema	varchar(128)
f_table_name	varchar(128)
f_geography_column	varchar(128)
coord_dimension	int4
srid	int4
type	varchar(9)

pg_catalog.svv_geometry_columns

old
column	data type

new
column	data type
f_table_catalog	varchar(128)
f_table_schema	varchar(128)
f_table_name	varchar(128)
f_geometry_column	varchar(128)
coord_dimension	int4
srid	int4
type	varchar(8)

pg_catalog.stl_alter_dist_sort

old
column	data type
xid	int8
cutoff_xid	int8
tbl	int4
event	char(128)
src_rows	int8
dest_rows	int8
redo_delete_rows	int8
undone_rows	int8
undone_txns	int8
eventtime	timestamp
origin_dist_style	int4
num_sort_keys	int4
target_distkey	int4
request_sort	int4
num_sort_iterations	int4
dst_sorted_rows	int8
is_autoworker_altered	int4

new
column	data type
xid	int8
cutoff_xid	int8
tbl	int4
event	char(128)
src_rows	int8
dest_rows	int8
redo_delete_rows	int8
undone_rows	int8
undone_txns	int8
eventtime	timestamp
origin_dist_style	int4
num_sort_keys	int4
target_distkey	int4
request_sort	int4
num_sort_iterations	int4
dst_sorted_rows	int8
is_autoworker_altered	int4
src_table_num_blocks	int8
nth_checkpoint	int4
pid	int4
shadow_tbl_num_blocks	int8

pg_catalog.stl_arcadia_billing_xact_log

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

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

pg_catalog.stl_backup_leader

old
column	data type
currenttime	timestamp
backup_id	char(256)
sb_version	int8
starttime	timestamp
in_progress	int4
error_code	int4
error_msg	char(256)
enc_key_hash_base64	char(44)
tlr_metadata_successful	int4
tlr_metadata_time	int8
tlr_metadata_error_msg	char(256)
partial	int4
backup_superblock_format	int4
time_wait_commit_lock	int8
time_hold_commit_lock	int8
time_spent_commit_transaction	int8
inc_no_backup	int8
sb_version_stage3	int8
backup_superblock_method	int4
num_tables	int4
inc_resize_lock_optional	int4
inc_resize_lock_mandatory	int4

new
column	data type
currenttime	timestamp
backup_id	char(256)
sb_version	int8
starttime	timestamp
in_progress	int4
error_code	int4
error_msg	char(256)
enc_key_hash_base64	char(44)
tlr_metadata_successful	int4
tlr_metadata_time	int8
tlr_metadata_error_msg	char(256)
partial	int4
backup_superblock_format	int4
time_wait_commit_lock	int8
time_hold_commit_lock	int8
time_spent_commit_transaction	int8
inc_no_backup	int8
sb_version_stage3	int8
backup_superblock_method	int4
num_tables	int4
inc_resize_lock_optional	int4
inc_resize_lock_mandatory	int4
cluster_id	char(256)

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

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)

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

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

pg_catalog.stl_datashare_request_producer

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

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

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

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

pg_catalog.stl_kinesis_outbound_requests

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

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

pg_catalog.stl_query_block_stats

old
column	data type
query	int4
slice	int4
segment	int4
block_reads	int4
block_faults	int4
total_block_fetchtime	int8
max_block_fetchtime	int8
transblock_reads	int4
transblock_faults	int4
total_transblock_fetchtime	int8
max_transblock_fetchtime	int8
blocks_used	int8
block_reads_already_in_s3	int4
disk_fetches	int8
disk_prefetches	int8
s3_fetches	int8
s3_prefetches	int8
trans_block_fetches	int8
trans_block_prefetches	int8

new
column	data type
query	int4
slice	int4
segment	int4
block_reads	int4
block_faults	int4
total_block_fetchtime	int8
max_block_fetchtime	int8
transblock_reads	int4
transblock_faults	int4
total_transblock_fetchtime	int8
max_transblock_fetchtime	int8
blocks_used	int8
block_reads_already_in_s3	int4
disk_fetches	int8
disk_prefetches	int8
s3_fetches	int8
s3_prefetches	int8
trans_block_fetches	int8
trans_block_prefetches	int8
megatrans_block_reads	int8
megatrans_block_fault	int8
megatrans_block_fetches	int8
megatrans_block_prefetches	int8

pg_catalog.stl_query_detail

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

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

pg_catalog.stl_s3list

old
column	data type
userid	int4
query	int4
uuid	char(36)
segment	int4
node	int4
slice	int4
eventtime	timestamp
bucket	char(256)
prefix	char(256)
recursive	char(1)
retrieved_files	int4
max_file_size	int8
avg_file_size	float8
duration	int8
generated_splits	int4
avg_split_length	float8
scan_type	int4

new
column	data type
userid	int4
query	int4
uuid	char(36)
segment	int4
node	int4
slice	int4
eventtime	timestamp
bucket	char(256)
prefix	char(256)
recursive	char(1)
retrieved_files	int4
max_file_size	int8
avg_file_size	float8
duration	int8
generated_splits	int4
avg_split_length	float8
scan_type	int4
list_type	int4

pg_catalog.stl_s3requests

old
column	data type
query	int4
uuid	char(36)
pid	int4
segment	int4
node	int4
slice	int4
eventtime	timestamp
duration	int8
retry_count	int4
returned_rows	int8
fetched	int4
file_size	int8
start_offset	int8
length	int8
file_name	char(512)
last_timeout	int8
failed	int4
etag	char(512)
num_splits	int4
cache_status	int4
returned_bytes	int8
s3_scanned_rows	int8
s3_scanned_bytes	int8
location	char(128)
latency_caching_batches	int8
latency_caching_manifest	int8
row_groups	int8
skipped_row_groups	int8
skipped_rows	int8
expected_duration	int8
read_count	int8
slowdown_count	int4
scan_type	int4
s3_physical_scanned_bytes	int8
returned_uncompressed_bytes	int8
starttime	timestamp
peak_memory_utilization	int4
codegen_time	int8
total_storage_wait_time	int8
total_query_cpu_time	int8
scan_cpu_time	int8
hostname	char(100)
spectrum_starttime	timestamp
spectrum_endtime	timestamp
client_fetch_wait_time	int8
cache_uncompressed_size	int8
cache_compressed_size	int8
cache_compression_latency	int8
abort_reason	int4
cache_objects_count	int4
backoff_time	int8
connect_retries	int4
connect_time	timestamp
exectask_time	timestamp
fetch_time	timestamp
tokens	int4
request_id	char(16)
fetch_error_count	int8

new
column	data type
query	int4
uuid	char(36)
pid	int4
segment	int4
node	int4
slice	int4
eventtime	timestamp
duration	int8
retry_count	int4
returned_rows	int8
fetched	int4
file_size	int8
start_offset	int8
length	int8
file_name	char(512)
last_timeout	int8
failed	int4
etag	char(512)
num_splits	int4
cache_status	int4
returned_bytes	int8
s3_scanned_rows	int8
s3_scanned_bytes	int8
location	char(128)
latency_caching_batches	int8
latency_caching_manifest	int8
row_groups	int8
skipped_row_groups	int8
skipped_rows	int8
expected_duration	int8
read_count	int8
slowdown_count	int4
scan_type	int4
s3_physical_scanned_bytes	int8
returned_uncompressed_bytes	int8
starttime	timestamp
peak_memory_utilization	int4
codegen_time	int8
total_storage_wait_time	int8
total_query_cpu_time	int8
scan_cpu_time	int8
hostname	char(100)
spectrum_starttime	timestamp
spectrum_endtime	timestamp
client_fetch_wait_time	int8
cache_uncompressed_size	int8
cache_compressed_size	int8
cache_compression_latency	int8
abort_reason	int4
cache_objects_count	int4
backoff_time	int8
connect_retries	int4
connect_time	timestamp
exectask_time	timestamp
fetch_time	timestamp
tokens	int4
request_id	char(16)
fetch_error_count	int8
serialize_time	int8

pg_catalog.stl_superblock_vacuum

old
column	data type
leaderstarttime	timestamp
node	int4
nodestarttime	timestamp
nodeendtime	timestamp
commitstarttime	timestamp
commitendtime	timestamp
success	int4
permbefore	int8
tempbefore	int8
leadersnapshotbefore	int8
pgwalbefore	int8
metadatabefore	int8
freebefore	int8
allocatedbefore	int8
permafter	int8
tempafter	int8
leadersnapshotafter	int8
pgwalafter	int8
metadataafter	int8
freeafter	int8
allocatedafter	int8
freelistbefore	int8
freelistafter	int8
logbefore	int8
logafter	int8

new
column	data type
leaderstarttime	timestamp
node	int4
nodestarttime	timestamp
nodeendtime	timestamp
commitstarttime	timestamp
commitendtime	timestamp
success	int4
permbefore	int8
tempbefore	int8
leadersnapshotbefore	int8
pgwalbefore	int8
metadatabefore	int8
freebefore	int8
allocatedbefore	int8
permafter	int8
tempafter	int8
leadersnapshotafter	int8
pgwalafter	int8
metadataafter	int8
freeafter	int8
allocatedafter	int8
freelistbefore	int8
freelistafter	int8
logbefore	int8
logafter	int8
sbtreebefore	int8
sbtreeafter	int8
tombstonedsbtreebefore	int8
tombstonedsbtreeafter	int8

pg_catalog.stl_xrestore_alter_distkey

old
column	data type
pid	int4
xid	int8
tbl	int4
column_name	char(200)
event_time	timestamp
message	char(350)

new
column	data type
pid	int4
xid	int8
tbl	int4
column_name	char(200)
event_time	timestamp
message	char(350)
elapsed_us	int8

pg_catalog.svl_s3requests

old
column	data type
query	int4
uuid	char(36)
pid	int4
segment	int4
node	int4
slice	int4
eventtime	timestamp
duration_msec	float8
retry_count	int4
returned_rows	int8
returned_bytes	int8
s3_scanned_rows	int8
s3_scanned_bytes	int8
row_groups	int8
skipped_row_groups	int8
skipped_rows	int8
fetched	int4
file_size	int8
start_offset	int8
length	int8
location	text
file	text
num_splits	int4
last_timeout_msec	float8
failed	int4
etag	text
fingerprint	int8
cache_status	int4
s3_physical_scanned_bytes	int8
starttime	timestamp
client_fetch_wait_time	int8
cache_compression_ratio	float8
cache_compression_latency	int8

new
column	data type
query	int4
uuid	char(36)
pid	int4
segment	int4
node	int4
slice	int4
eventtime	timestamp
duration_msec	float8
retry_count	int4
returned_rows	int8
returned_bytes	int8
s3_scanned_rows	int8
s3_scanned_bytes	int8
row_groups	int8
skipped_row_groups	int8
skipped_rows	int8
fetched	int4
file_size	int8
start_offset	int8
length	int8
location	text
file	text
num_splits	int4
last_timeout_msec	float8
failed	int4
etag	text
fingerprint	int8
cache_status	int4
s3_physical_scanned_bytes	int8
starttime	timestamp
client_fetch_wait_time	int8
cache_compression_ratio	float8
cache_compression_latency	int8
serialize_time	int8

pg_catalog.sys_load_error_detail

old
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
database_name	varchar(64)
table_id	int4
start_time	timestamp
file_name	char(256)
line_number	int8
column_name	char(127)
column_type	char(10)
column_length	char(10)
position	int4
error_code	int4
error_message	char(100)

new
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
database_name	text
table_id	int4
start_time	timestamp
file_name	char(256)
line_number	int8
column_name	char(127)
column_type	char(10)
column_length	char(10)
position	int4
error_code	int4
error_message	char(100)

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(256)
usage_limit	varchar(150)

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)

pg_catalog.stl_load_error_detail_base

old
column	data type
user_id	int4
query_id	int8
child_query_id	int4
pid	int4
db	char(64)
xid	int8
slice	int4
table_id	int4
starttime	timestamp
filename	char(256)
line_number	int8
col_name	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)

new
column	data type

pg_catalog.stl_query_history_base

old
column	data type
user_id	int4
query_id	int8
child_query_id	int4
child_query_sequence	int4
label	char(320)
xid	int8
pid	int4
db	char(64)
query_type	char(32)
query_text	char(4000)
eventtime	timestamp
status	char(10)
result_cache_source_query	int8
concurrency_scaling_status	int4
error_message	char(512)
task	int4
service_class	int4
returned_rows	int8
returned_bytes	int8
total_queue_time	int8
total_exec_time	int8
redshift_version	char(256)
location_tag	char(32)
usage_limit	char(150)

new
column	data type