Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
new	pg_catalog	internal	stable	bool	has_copy_job_privilege	name,oid

Tables

pg_catalog.pg_auto_copy_watermark

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
job_id	oid			NN
type	char(1)			NN
generation	int4			NN
xid	int8			NN

pg_catalog.stcs_catalog_aggregate_bufmgr_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
period_start	int8			NN
log_time	int8			NN
read_buffer_cache_hits	int8			NN
read_buffer_cache_misses	int8			NN
get_buffer_in_free_list	int8			NN
get_buffer_evictions	int8			NN
clean_evictions	int8			NN
dirty_evictions	int8			NN
contention_on_eviction	int8			NN
microseconds_flushing_dirty_buffers_during_allocation	int8			NN
microseconds_flushing_dirty_buffers	int8			NN
pin_buffer_calls	int8			NN
unpin_buffer_calls	int8			NN
invalidate_buffer	int8			NN
freelist_size_end_of_interval	int8			NN
recency_cache_size_end_of_interval	int8			NN
frequency_cache_size_end_of_interval	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_compile_errors

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
recordtime	int8			NN
query	int4			NN
segment	int4			NN
sequence	int4			NN
message	char(255)			NN
loc	char(255)			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_ddltext_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
label	char(320)			NN
starttime	int8			NN
endtime	int8			NN
sequence	int4			NN
text_redacted	char(200)			NN
access_control	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_doryc_container_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
eventtime	int8			NN
node	int4			NN
container_name	char(32)			NN
container_id	char(32)			NN
cpu_usage_percentage	float8			NN
memory_usage_percentage	float8			NN
memory_usage	char(16)			NN
pid_count	int4			NN
net_io	char(16)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_explain_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
nodeid	int4			NN
parentid	int4			NN
plannode	char(400)			NN
info_redacted	char(400)			NN
access_control	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_external_query_detail_base_redacted

old
column	data type	PK	U	NN

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

pg_catalog.stcs_federated_query_redacted

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
sourcetype	char(30)			NN
database	char(30)			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
recordtime	int8			NN
querytext_redacted	char(4000)			NN
num_rows	int8			NN
num_bytes	int8			NN
duration	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_query_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database	char(32)			NN
querytxt_redacted	char(4000)			NN
starttime	int8			NN
endtime	int8			NN
aborted	int4			NN
insert_pristine	int4			NN
concurrency_scaling_status	int4			NN
access_control	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_querytext_redacted

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
sequence	int4			NN
text_redacted	char(200)			NN
access_control	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_sage_mode_simulation_queries

old
column	data type	PK	U	NN

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

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
session_userid	int4			NN
query	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database	char(32)			NN
querytxt_redacted	char(500)			NN
starttime	int8			NN
endtime	int8			NN
aborted	int4			NN
access_control	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_user_query_history_redacted

old
column	data type	PK	U	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_redacted	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
access_control	int4			NN
service_class_id	int4			NN
service_class_name	char(64)			NN
query_priority	char(20)			NN
short_query_accelerated	char(10)			NN
user_query_hash	char(40)			NN
generic_query_hash	char(40)			NN
query_hash_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_user_query_text_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
transaction_id	int8			NN
session_id	int4			NN
start_time	int8			NN
sequence	int4			NN
text_redacted	char(4000)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_utilitytext_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
label	char(320)			NN
starttime	int8			NN
endtime	int8			NN
sequence	int4			NN
text_redacted	char(200)			NN
access_control	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stll_catalog_aggregate_bufmgr_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
period_start	timestamp			NN
log_time	timestamp			NN
read_buffer_cache_hits	int8			NN
read_buffer_cache_misses	int8			NN
get_buffer_in_free_list	int8			NN
get_buffer_evictions	int8			NN
clean_evictions	int8			NN
dirty_evictions	int8			NN
contention_on_eviction	int8			NN
microseconds_flushing_dirty_buffers_during_allocation	int8			NN
microseconds_flushing_dirty_buffers	int8			NN
pin_buffer_calls	int8			NN
unpin_buffer_calls	int8			NN
invalidate_buffer	int8			NN
freelist_size_end_of_interval	int8			NN
recency_cache_size_end_of_interval	int8			NN
frequency_cache_size_end_of_interval	int8			NN

pg_catalog.stll_compile_errors

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
recordtime	timestamp			NN
query	int4			NN
segment	int4			NN
sequence	int4			NN
message	char(255)			NN
loc	char(255)			NN

pg_catalog.stll_ddltext_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
label	char(320)			NN
starttime	timestamp			NN
endtime	timestamp			NN
sequence	int4			NN
text_redacted	char(200)			NN
access_control	int4			NN

pg_catalog.stll_doryc_container_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
eventtime	timestamp			NN
node	int4			NN
container_name	char(32)			NN
container_id	char(32)			NN
cpu_usage_percentage	float8			NN
memory_usage_percentage	float8			NN
memory_usage	char(16)			NN
pid_count	int4			NN
net_io	char(16)			NN

pg_catalog.stll_explain_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
nodeid	int4			NN
parentid	int4			NN
plannode	char(400)			NN
info_redacted	char(400)			NN
access_control	int4			NN

pg_catalog.stll_external_query_detail_base_redacted

old
column	data type	PK	U	NN

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

pg_catalog.stll_federated_query_redacted

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
sourcetype	char(30)			NN
database	char(30)			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
recordtime	timestamp			NN
querytext_redacted	char(4000)			NN
num_rows	int8			NN
num_bytes	int8			NN
duration	int8			NN

pg_catalog.stll_query_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database	char(32)			NN
querytxt_redacted	char(4000)			NN
starttime	timestamp			NN
endtime	timestamp			NN
aborted	int4			NN
insert_pristine	int4			NN
concurrency_scaling_status	int4			NN
access_control	int4			NN

pg_catalog.stll_querytext_redacted

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
sequence	int4			NN
text_redacted	char(200)			NN
access_control	int4			NN

pg_catalog.stll_sage_mode_simulation_queries

old
column	data type	PK	U	NN

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

pg_catalog.stll_stored_proc_call_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
session_userid	int4			NN
query	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database	char(32)			NN
querytxt_redacted	char(500)			NN
starttime	timestamp			NN
endtime	timestamp			NN
aborted	int4			NN
access_control	int4			NN

pg_catalog.stll_user_query_history_redacted

old
column	data type	PK	U	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_redacted	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
access_control	int4			NN
service_class_id	int4			NN
service_class_name	char(64)			NN
query_priority	char(20)			NN
short_query_accelerated	char(10)			NN
user_query_hash	char(40)			NN
generic_query_hash	char(40)			NN
query_hash_version	int4			NN

pg_catalog.stll_user_query_text_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
transaction_id	int8			NN
session_id	int4			NN
start_time	timestamp			NN
sequence	int4			NN
text_redacted	char(4000)			NN

pg_catalog.stll_utilitytext_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
label	char(320)			NN
starttime	timestamp			NN
endtime	timestamp			NN
sequence	int4			NN
text_redacted	char(200)			NN
access_control	int4			NN

pg_catalog.stv_sage_query_trace_metrics

old
column	data type	PK	U	NN

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

pg_catalog.stv_sage_query_trace_status

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
metrics_queue_size	int4			NN
departure_updates_queue_size	int4			NN

pg_catalog.stv_table_insertion_point_state

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
tbl	int4			NN
slice	int4			NN
ip_id	int4			NN
last_partition_id	int4			NN

pg_internal.redshift_auto_health_check_6184316

old
column	data type	PK	U	NN

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

pg_catalog.stcs_backup_compute

old
column	data type	PK	U	NN
currenttime	int8			NN
node_num	int4			NN
state	char(256)			NN
backup_id	char(256)			NN
sb_version	int8			NN
starttime	int8			NN
num_blocks	int8			NN
superblock_size	int8			NN
permanent_blocks	int8			NN
blocks_to_upload	int8			NN
blocks_uploaded	int8			NN
num_failures	int8			NN
num_modified_superblock_segments	int8			NN
total_num_superblock_segments	int8			NN
time_spent_stage1	int8			NN
time_spent_read_sb_header	int8			NN
time_spent_copy_segments	int8			NN
time_spent_stage2	int8			NN
time_spent_set_in_s3_bits	int8			NN
inc_no_backup	int8			NN
nobackup_blocks	int8			NN
distall_blocks	int8			NN
non_distall_blocks	int8			NN
perm_blocks_in_s3	int8			NN
metadata_read_from_backup	int4			NN
blocks_validated	int8			NN
sb_segments_available	int4			NN
backup_manifest_available	int4			NN
time_spent_generating_manifest	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
currenttime	int8			NN
node_num	int4			NN
state	char(256)			NN
backup_id	char(256)			NN
sb_version	int8			NN
starttime	int8			NN
num_blocks	int8			NN
superblock_size	int8			NN
permanent_blocks	int8			NN
blocks_to_upload	int8			NN
blocks_uploaded	int8			NN
num_failures	int8			NN
num_modified_superblock_segments	int8			NN
total_num_superblock_segments	int8			NN
time_spent_stage1	int8			NN
time_spent_read_sb_header	int8			NN
time_spent_copy_segments	int8			NN
time_spent_stage2	int8			NN
time_spent_set_in_s3_bits	int8			NN
inc_no_backup	int8			NN
nobackup_blocks	int8			NN
distall_blocks	int8			NN
non_distall_blocks	int8			NN
perm_blocks_in_s3	int8			NN
metadata_read_from_backup	int4			NN
blocks_validated	int8			NN
sb_segments_available	int4			NN
backup_manifest_available	int4			NN
time_spent_generating_manifest	int8			NN
manifest_compression_level	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_burst_manager_personalization

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

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

old
column	data type	PK	U	NN
xid	int8			NN
query	int8			NN
tbl	int4			NN
node	int4			NN
block_header_rcvd	int8			NN
rcvd_time	int8			NN
remote_write_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
xid	int8			NN
query	int8			NN
tbl	int4			NN
node	int4			NN
block_header_rcvd	int8			NN
rcvd_time	int8			NN
remote_write_type	int4			NN
num_perm_mirror	int8			NN
num_blk_header_batches	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_catalog_rebuild_info

old
column	data type	PK	U	NN
xid	int8			NN
database	int4			NN
table_name	char(64)			NN
table_oid	int8			NN
num_live_tups	int8			NN
num_dead_tups	int8			NN
total_live_tup_sz	int8			NN
total_dead_tup_sz	int8			NN
starttime	int8			NN
tuple_storage_duration_in_msec	int8			NN
commit_lock_acq_duration_in_msec	int8			NN
rebuild_duration_in_msec	int8			NN
total_duration_in_msec	int8			NN
message	char(128)			NN
rebuild_mode	char(8)			NN
startup	int4			NN
versioned_rebuild	int4			NN
versioned_rebuild_pivot_xid	int8			NN
heap_xlog_duration_in_msec	int8			NN
index_xlog_duration_in_msec	int8			NN
xlog_write_duration_in_msec	int8			NN
xlog_fsync_duration_in_msec	int8			NN
repwal_duration_in_msec	int8			NN
xlog_write_lock_acq_time_in_msec	int8			NN
xlog_insert_lock_acq_time_in_msec	int8			NN
num_xlog_writes	int8			NN
num_xlog_fsyncs	int8			NN
commit_message_mutex_acq_time_in_msec	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
database	int4			NN
table_name	char(64)			NN
table_oid	int8			NN
num_live_tups	int8			NN
num_dead_tups	int8			NN
total_live_tup_sz	int8			NN
total_dead_tup_sz	int8			NN
starttime	int8			NN
tuple_storage_duration_in_msec	int8			NN
commit_lock_acq_duration_in_msec	int8			NN
rebuild_duration_in_msec	int8			NN
total_duration_in_msec	int8			NN
message	char(128)			NN
rebuild_mode	char(8)			NN
startup	int4			NN
versioned_rebuild	int4			NN
versioned_rebuild_pivot_xid	int8			NN
heap_xlog_duration_in_msec	int8			NN
index_xlog_duration_in_msec	int8			NN
xlog_write_duration_in_msec	int8			NN
xlog_fsync_duration_in_msec	int8			NN
repwal_duration_in_msec	int8			NN
xlog_write_lock_acq_time_in_msec	int8			NN
xlog_insert_lock_acq_time_in_msec	int8			NN
num_xlog_writes	int8			NN
num_xlog_fsyncs	int8			NN
commit_message_mutex_acq_time_in_msec	int8			NN
toast_num_live_tups	int8			NN
toast_num_dead_tups	int8			NN
total_toast_live_tup_sz	int8			NN
total_toast_dead_tup_sz	int8			NN
num_ver_dead_tups	int8			NN
ver_dead_tup_sz_in_bytes	int8			NN
toast_num_ver_dead_tups	int8			NN
toast_ver_dead_tup_sz_in_bytes	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_catalog_scan_metrics

old
column	data type	PK	U	NN
xid	int8			NN
database	int4			NN
table_name	char(128)			NN
starttime	int8			NN
duration_msec	int8			NN
num_live_tups	int8			NN
num_dead_tups	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
database	int4			NN
table_name	char(128)			NN
starttime	int8			NN
duration_msec	int8			NN
num_live_tups	int8			NN
num_dead_tups	int8			NN
total_live_tup_sz	int8			NN
total_dead_tup_sz	int8			NN
toast_num_live_tups	int8			NN
toast_num_dead_tups	int8			NN
total_toast_live_tup_sz	int8			NN
total_toast_dead_tup_sz	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_cqi_metrics

old
column	data type	PK	U	NN
pid	int4			NN
starttime	int8			NN
endtime	int8			NN
component_name	char(48)			NN
phase	char(48)			NN
restart_id	char(64)			NN
message	char(512)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
pid	int4			NN
starttime	int8			NN
endtime	int8			NN
component_name	char(48)			NN
phase	char(48)			NN
restart_id	char(64)			NN
message	char(4096)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_insertion_point_reservations

old
column	data type	PK	U	NN
query_id	int4			NN
tbl	int4			NN
data_slice	int4			NN
strategy	int4			NN
event	int4			NN
ip_id	int4			NN
type	int4			NN
writer_group_index	int4			NN
writer_index	int4			NN
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
tbl	int4			NN
data_slice	int4			NN
strategy	int4			NN
event	int4			NN
ip_id	int4			NN
type	int4			NN
writer_group_index	int4			NN
writer_index	int4			NN
time	int8			NN
is_remote	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_integration_log

old
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
status	char(128)			NN
database_name	char(128)			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
synced_log_coordinate	char(128)			NN
num_modified_tables	int4			NN
lag_ms	int8			NN
checkpoint_bytes	int8			NN
integration_start_time	int8			NN
last_commit_timestamp	int8			NN
num_failed_tables	int4			NN
delay_ms	int8			NN
channel_state	char(128)			NN
export_identifier	char(64)			NN
rows	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
record_time	int8			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
status	char(128)			NN
database_name	char(128)			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
synced_log_coordinate	char(128)			NN
num_modified_tables	int4			NN
lag_ms	int8			NN
checkpoint_bytes	int8			NN
integration_start_time	int8			NN
last_commit_timestamp	int8			NN
num_failed_tables	int4			NN
delay_ms	int8			NN
channel_state	char(128)			NN
export_identifier	char(64)			NN
rows	int8			NN
inserted_rows	int8			NN
deleted_rows	int8			NN
updated_rows	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_lambda_invocation_error

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

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

pg_catalog.stcs_sage_mode_policy

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

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

pg_catalog.stcs_sage_mode_simulation_clusters

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

pg_catalog.stcs_sage_mode_simulation_summary

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

pg_catalog.stcs_sage_scaling_candidates

old
column	data type	PK	U	NN
query	int4			NN
decision_id	int4			NN
candidate_id	int4			NN
ssid	int4			NN
state	int4			NN
nodes	int4			NN
running_queries	int4			NN
queued_queries	int4			NN
est_exec_time_ms	int4			NN
spill_penalty_ms	int4			NN
est_prepare_delay_ms	int4			NN
est_queue_time_ms	int4			NN
penalty	float8			NN
eligible	int4			NN
other_active_query_runtime_ms	int4			NN
cost	float8			NN
other_active_cluster_cost	float8			NN
occupied_mb	int4			NN
queue_head_wait_ms	int4			NN
ineligibility_reason	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
query	int4			NN
decision_id	int8			NN
candidate_id	int4			NN
ssid	int4			NN
state	int4			NN
nodes	int4			NN
running_queries	int4			NN
queued_queries	int4			NN
est_exec_time_ms	int4			NN
spill_penalty_ms	int4			NN
est_prepare_delay_ms	int4			NN
est_queue_time_ms	int4			NN
penalty	float8			NN
eligible	int4			NN
other_active_query_runtime_ms	int4			NN
cost	float8			NN
other_active_cluster_cost	float8			NN
occupied_mb	int4			NN
queue_head_wait_ms	int4			NN
ineligibility_reason	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_scan_range_stats

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
node	int4			NN
local_data_slice	int4			NN
local_compute_slice	int4			NN
starttime	int8			NN
endtime	int8			NN
num_blocks_to_scan	int8			NN
total_blocks	int8			NN
num_scan_ranges	int8			NN
min_scan_range_size	int8			NN
max_scan_range_size	int8			NN
avg_scan_range_size	int8			NN
num_blf_ranges	int8			NN
min_blf_range_size	int8			NN
max_blf_range_size	int8			NN
avg_blf_range_size	int8			NN
block_reopen_times	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
segment	int4			NN
step	int4			NN
node	int4			NN
local_data_slice	int4			NN
local_compute_slice	int4			NN
starttime	int8			NN
endtime	int8			NN
num_blocks_to_scan	int8			NN
total_blocks	int8			NN
num_scan_ranges	int8			NN
min_scan_range_size	int8			NN
max_scan_range_size	int8			NN
avg_scan_range_size	int8			NN
num_blf_ranges	int8			NN
min_blf_range_size	int8			NN
max_blf_range_size	int8			NN
avg_blf_range_size	int8			NN
block_reopen_times	int8			NN
optimized_scan_range_gen	char(1)			NN
max_rows_per_scan_range	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_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
lock_wait_time	int8			NN
access_control	int4			NN
service_class_id	int4			NN
service_class_name	char(64)			NN
query_priority	char(20)			NN
short_query_accelerated	char(10)			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
access_control	int4			NN
service_class_id	int4			NN
service_class_name	char(64)			NN
query_priority	char(20)			NN
short_query_accelerated	char(10)			NN
user_query_hash	char(40)			NN
generic_query_hash	char(40)			NN
query_hash_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_vec_scan_stats

old
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
scalar_encoding_type	int4			NN
predicate_window_size	int4			NN
payload_window_size	int4			NN
compact_col_count	int4			NN
is_operator_pushdown	char(1)			NN
apply_xid_time	int8			NN
apply_predicate_time	int8			NN
extract_predicate_time	int8			NN
extract_payload_time	int8			NN
compact_predicate_time	int8			NN
compact_payload_time	int8			NN
scalar_predicate_time	int8			NN
consume_time	int8			NN
step	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
slice	int4			NN
segment	int4			NN
scalar_encoding_type	int4			NN
predicate_window_size	int4			NN
payload_window_size	int4			NN
compact_col_count	int4			NN
is_operator_pushdown	char(1)			NN
apply_xid_time	int8			NN
apply_predicate_time	int8			NN
extract_predicate_time	int8			NN
extract_payload_time	int8			NN
compact_predicate_time	int8			NN
compact_payload_time	int8			NN
scalar_predicate_time	int8			NN
consume_time	int8			NN
step	int4			NN
dynamic_predicate_reordering_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.stll_backup_compute

old
column	data type	PK	U	NN
currenttime	timestamp			NN
node_num	int4			NN
state	char(256)			NN
backup_id	char(256)			NN
sb_version	int8			NN
starttime	timestamp			NN
num_blocks	int8			NN
superblock_size	int8			NN
permanent_blocks	int8			NN
blocks_to_upload	int8			NN
blocks_uploaded	int8			NN
num_failures	int8			NN
num_modified_superblock_segments	int8			NN
total_num_superblock_segments	int8			NN
time_spent_stage1	int8			NN
time_spent_read_sb_header	int8			NN
time_spent_copy_segments	int8			NN
time_spent_stage2	int8			NN
time_spent_set_in_s3_bits	int8			NN
inc_no_backup	int8			NN
nobackup_blocks	int8			NN
distall_blocks	int8			NN
non_distall_blocks	int8			NN
perm_blocks_in_s3	int8			NN
metadata_read_from_backup	int4			NN
blocks_validated	int8			NN
sb_segments_available	int4			NN
backup_manifest_available	int4			NN
time_spent_generating_manifest	int8			NN

new
column	data type	PK	U	NN
currenttime	timestamp			NN
node_num	int4			NN
state	char(256)			NN
backup_id	char(256)			NN
sb_version	int8			NN
starttime	timestamp			NN
num_blocks	int8			NN
superblock_size	int8			NN
permanent_blocks	int8			NN
blocks_to_upload	int8			NN
blocks_uploaded	int8			NN
num_failures	int8			NN
num_modified_superblock_segments	int8			NN
total_num_superblock_segments	int8			NN
time_spent_stage1	int8			NN
time_spent_read_sb_header	int8			NN
time_spent_copy_segments	int8			NN
time_spent_stage2	int8			NN
time_spent_set_in_s3_bits	int8			NN
inc_no_backup	int8			NN
nobackup_blocks	int8			NN
distall_blocks	int8			NN
non_distall_blocks	int8			NN
perm_blocks_in_s3	int8			NN
metadata_read_from_backup	int4			NN
blocks_validated	int8			NN
sb_segments_available	int4			NN
backup_manifest_available	int4			NN
time_spent_generating_manifest	int8			NN
manifest_compression_level	int4			NN

pg_catalog.stll_burst_manager_personalization

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

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

pg_catalog.stll_burst_write_block_header_trace

old
column	data type	PK	U	NN
xid	int8			NN
query	int8			NN
tbl	int4			NN
node	int4			NN
block_header_rcvd	int8			NN
rcvd_time	timestamp			NN
remote_write_type	int4			NN

new
column	data type	PK	U	NN
xid	int8			NN
query	int8			NN
tbl	int4			NN
node	int4			NN
block_header_rcvd	int8			NN
rcvd_time	timestamp			NN
remote_write_type	int4			NN
num_perm_mirror	int8			NN
num_blk_header_batches	int4			NN

pg_catalog.stll_catalog_rebuild_info

old
column	data type	PK	U	NN
xid	int8			NN
database	int4			NN
table_name	char(64)			NN
table_oid	int8			NN
num_live_tups	int8			NN
num_dead_tups	int8			NN
total_live_tup_sz	int8			NN
total_dead_tup_sz	int8			NN
starttime	timestamp			NN
tuple_storage_duration_in_msec	int8			NN
commit_lock_acq_duration_in_msec	int8			NN
rebuild_duration_in_msec	int8			NN
total_duration_in_msec	int8			NN
message	char(128)			NN
rebuild_mode	char(8)			NN
startup	int4			NN
versioned_rebuild	int4			NN
versioned_rebuild_pivot_xid	int8			NN
heap_xlog_duration_in_msec	int8			NN
index_xlog_duration_in_msec	int8			NN
xlog_write_duration_in_msec	int8			NN
xlog_fsync_duration_in_msec	int8			NN
repwal_duration_in_msec	int8			NN
xlog_write_lock_acq_time_in_msec	int8			NN
xlog_insert_lock_acq_time_in_msec	int8			NN
num_xlog_writes	int8			NN
num_xlog_fsyncs	int8			NN
commit_message_mutex_acq_time_in_msec	int8			NN

new
column	data type	PK	U	NN
xid	int8			NN
database	int4			NN
table_name	char(64)			NN
table_oid	int8			NN
num_live_tups	int8			NN
num_dead_tups	int8			NN
total_live_tup_sz	int8			NN
total_dead_tup_sz	int8			NN
starttime	timestamp			NN
tuple_storage_duration_in_msec	int8			NN
commit_lock_acq_duration_in_msec	int8			NN
rebuild_duration_in_msec	int8			NN
total_duration_in_msec	int8			NN
message	char(128)			NN
rebuild_mode	char(8)			NN
startup	int4			NN
versioned_rebuild	int4			NN
versioned_rebuild_pivot_xid	int8			NN
heap_xlog_duration_in_msec	int8			NN
index_xlog_duration_in_msec	int8			NN
xlog_write_duration_in_msec	int8			NN
xlog_fsync_duration_in_msec	int8			NN
repwal_duration_in_msec	int8			NN
xlog_write_lock_acq_time_in_msec	int8			NN
xlog_insert_lock_acq_time_in_msec	int8			NN
num_xlog_writes	int8			NN
num_xlog_fsyncs	int8			NN
commit_message_mutex_acq_time_in_msec	int8			NN
toast_num_live_tups	int8			NN
toast_num_dead_tups	int8			NN
total_toast_live_tup_sz	int8			NN
total_toast_dead_tup_sz	int8			NN
num_ver_dead_tups	int8			NN
ver_dead_tup_sz_in_bytes	int8			NN
toast_num_ver_dead_tups	int8			NN
toast_ver_dead_tup_sz_in_bytes	int8			NN

pg_catalog.stll_catalog_scan_metrics

old
column	data type	PK	U	NN
xid	int8			NN
database	int4			NN
table_name	char(128)			NN
starttime	timestamp			NN
duration_msec	int8			NN
num_live_tups	int8			NN
num_dead_tups	int8			NN

new
column	data type	PK	U	NN
xid	int8			NN
database	int4			NN
table_name	char(128)			NN
starttime	timestamp			NN
duration_msec	int8			NN
num_live_tups	int8			NN
num_dead_tups	int8			NN
total_live_tup_sz	int8			NN
total_dead_tup_sz	int8			NN
toast_num_live_tups	int8			NN
toast_num_dead_tups	int8			NN
total_toast_live_tup_sz	int8			NN
total_toast_dead_tup_sz	int8			NN

pg_catalog.stll_cqi_metrics

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

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

pg_catalog.stll_insertion_point_reservations

old
column	data type	PK	U	NN
query_id	int4			NN
tbl	int4			NN
data_slice	int4			NN
strategy	int4			NN
event	int4			NN
ip_id	int4			NN
type	int4			NN
writer_group_index	int4			NN
writer_index	int4			NN
time	timestamp			NN

new
column	data type	PK	U	NN
query_id	int4			NN
tbl	int4			NN
data_slice	int4			NN
strategy	int4			NN
event	int4			NN
ip_id	int4			NN
type	int4			NN
writer_group_index	int4			NN
writer_index	int4			NN
time	timestamp			NN
is_remote	int4			NN

pg_catalog.stll_integration_log

old
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
status	char(128)			NN
database_name	char(128)			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
synced_log_coordinate	char(128)			NN
num_modified_tables	int4			NN
lag_ms	int8			NN
checkpoint_bytes	int8			NN
integration_start_time	timestamp			NN
last_commit_timestamp	timestamp			NN
num_failed_tables	int4			NN
delay_ms	int8			NN
channel_state	char(128)			NN
export_identifier	char(64)			NN
rows	int8			NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
status	char(128)			NN
database_name	char(128)			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
synced_log_coordinate	char(128)			NN
num_modified_tables	int4			NN
lag_ms	int8			NN
checkpoint_bytes	int8			NN
integration_start_time	timestamp			NN
last_commit_timestamp	timestamp			NN
num_failed_tables	int4			NN
delay_ms	int8			NN
channel_state	char(128)			NN
export_identifier	char(64)			NN
rows	int8			NN
inserted_rows	int8			NN
deleted_rows	int8			NN
updated_rows	int8			NN

pg_catalog.stll_lambda_invocation_error

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

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

pg_catalog.stll_sage_mode_policy

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

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

pg_catalog.stll_sage_mode_simulation_clusters

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

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

pg_catalog.stll_sage_mode_simulation_summary

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

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

pg_catalog.stll_sage_scaling_candidates

old
column	data type	PK	U	NN
query	int4			NN
decision_id	int4			NN
candidate_id	int4			NN
ssid	int4			NN
state	int4			NN
nodes	int4			NN
running_queries	int4			NN
queued_queries	int4			NN
est_exec_time_ms	int4			NN
spill_penalty_ms	int4			NN
est_prepare_delay_ms	int4			NN
est_queue_time_ms	int4			NN
penalty	float8			NN
eligible	int4			NN
other_active_query_runtime_ms	int4			NN
cost	float8			NN
other_active_cluster_cost	float8			NN
occupied_mb	int4			NN
queue_head_wait_ms	int4			NN
ineligibility_reason	int4			NN

new
column	data type	PK	U	NN
query	int4			NN
decision_id	int8			NN
candidate_id	int4			NN
ssid	int4			NN
state	int4			NN
nodes	int4			NN
running_queries	int4			NN
queued_queries	int4			NN
est_exec_time_ms	int4			NN
spill_penalty_ms	int4			NN
est_prepare_delay_ms	int4			NN
est_queue_time_ms	int4			NN
penalty	float8			NN
eligible	int4			NN
other_active_query_runtime_ms	int4			NN
cost	float8			NN
other_active_cluster_cost	float8			NN
occupied_mb	int4			NN
queue_head_wait_ms	int4			NN
ineligibility_reason	int4			NN

pg_catalog.stll_scan_range_stats

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
node	int4			NN
local_data_slice	int4			NN
local_compute_slice	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
num_blocks_to_scan	int8			NN
total_blocks	int8			NN
num_scan_ranges	int8			NN
min_scan_range_size	int8			NN
max_scan_range_size	int8			NN
avg_scan_range_size	int8			NN
num_blf_ranges	int8			NN
min_blf_range_size	int8			NN
max_blf_range_size	int8			NN
avg_blf_range_size	int8			NN
block_reopen_times	int8			NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
node	int4			NN
local_data_slice	int4			NN
local_compute_slice	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
num_blocks_to_scan	int8			NN
total_blocks	int8			NN
num_scan_ranges	int8			NN
min_scan_range_size	int8			NN
max_scan_range_size	int8			NN
avg_scan_range_size	int8			NN
num_blf_ranges	int8			NN
min_blf_range_size	int8			NN
max_blf_range_size	int8			NN
avg_blf_range_size	int8			NN
block_reopen_times	int8			NN
optimized_scan_range_gen	char(1)			NN
max_rows_per_scan_range	int8			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
lock_wait_time	int8			NN
access_control	int4			NN
service_class_id	int4			NN
service_class_name	char(64)			NN
query_priority	char(20)			NN
short_query_accelerated	char(10)			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
access_control	int4			NN
service_class_id	int4			NN
service_class_name	char(64)			NN
query_priority	char(20)			NN
short_query_accelerated	char(10)			NN
user_query_hash	char(40)			NN
generic_query_hash	char(40)			NN
query_hash_version	int4			NN

pg_catalog.stll_vec_scan_stats

old
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
scalar_encoding_type	int4			NN
predicate_window_size	int4			NN
payload_window_size	int4			NN
compact_col_count	int4			NN
is_operator_pushdown	char(1)			NN
apply_xid_time	int8			NN
apply_predicate_time	int8			NN
extract_predicate_time	int8			NN
extract_payload_time	int8			NN
compact_predicate_time	int8			NN
compact_payload_time	int8			NN
scalar_predicate_time	int8			NN
consume_time	int8			NN
step	int4			NN

new
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
scalar_encoding_type	int4			NN
predicate_window_size	int4			NN
payload_window_size	int4			NN
compact_col_count	int4			NN
is_operator_pushdown	char(1)			NN
apply_xid_time	int8			NN
apply_predicate_time	int8			NN
extract_predicate_time	int8			NN
extract_payload_time	int8			NN
compact_predicate_time	int8			NN
compact_payload_time	int8			NN
scalar_predicate_time	int8			NN
consume_time	int8			NN
step	int4			NN
dynamic_predicate_reordering_status	int4			NN

pg_catalog.stv_catalog_metrics

old
column	data type	PK	U	NN
database	int4			NN
table_name	char(48)			NN
table_oid	int4			NN
num_live_tups	int8			NN
num_dead_tups	int8			NN
total_live_tup_sz	int8			NN
total_dead_tup_sz	int8			NN

new
column	data type	PK	U	NN
database	int4			NN
table_name	char(48)			NN
table_oid	int4			NN
num_live_tups	int8			NN
num_dead_tups	int8			NN
total_live_tup_sz	int8			NN
total_dead_tup_sz	int8			NN
toast_num_live_tups	int8			NN
toast_num_dead_tups	int8			NN
total_toast_live_tup_sz	int8			NN
total_toast_dead_tup_sz	int8			NN
total_ver_num_dead_tups	int8			NN
total_ver_dead_tup_sz	int8			NN

pg_catalog.stv_integration

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

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

pg_catalog.stv_mv_deps_internal

old
column	data type	PK	U	NN
database_name	char(128)			NN
schema_name	char(128)			NN
name	char(128)			NN
ref_database_name	char(128)			NN
ref_schema_name	char(128)			NN
ref_name	char(128)			NN
ref_type	char(128)			NN
ref_source	char(128)			NN

new
column	data type	PK	U	NN
database_name	char(128)			NN
schema_name	char(128)			NN
name	char(128)			NN
ref_database_name	char(128)			NN
ref_schema_name	char(128)			NN
ref_name	char(128)			NN
ref_type	char(128)			NN
ref_source	char(128)			NN
ref_format	char(128)			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
lock_wait_time	int8			NN
service_class_id	int4			NN
service_class_name	char(64)			NN
query_priority	char(20)			NN
short_query_accelerated	char(10)			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
service_class_id	int4			NN
service_class_name	char(64)			NN
query_priority	char(20)			NN
short_query_accelerated	char(10)			NN
user_query_hash	char(40)			NN
generic_query_hash	char(40)			NN
query_hash_version	int4			NN

pg_catalog.stv_resource_forecaster_status

old
column	data type	PK	U	NN
enabled	char(1)			NN
leader_collector_startup_finished	char(1)			NN
bucketizer_startup_finished	char(1)			NN
last_baseline	int4			NN
model	int4			NN
total_sample_count	int4			NN
sample_cutoff_time_milliseconds	int4			NN
open_bucket_builders_count	int4			NN
leader_metrics_history_size	int4			NN
chunk_count	int4			NN
persisted_bytes	int4			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_15381629

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_catalog_aggregate_bufmgr_stats

old
column	data type

new
column	data type
period_start	timestamp
log_time	timestamp
read_buffer_cache_hits	int8
read_buffer_cache_misses	int8
get_buffer_in_free_list	int8
get_buffer_evictions	int8
clean_evictions	int8
dirty_evictions	int8
contention_on_eviction	int8
microseconds_flushing_dirty_buffers_during_allocation	int8
microseconds_flushing_dirty_buffers	int8
pin_buffer_calls	int8
unpin_buffer_calls	int8
invalidate_buffer	int8
freelist_size_end_of_interval	int8
recency_cache_size_end_of_interval	int8
frequency_cache_size_end_of_interval	int8

pg_catalog.stl_compile_errors

old
column	data type

new
column	data type
userid	int4
xid	int8
pid	int4
recordtime	timestamp
query	int4
segment	int4
sequence	int4
message	char(255)
loc	char(255)

pg_catalog.stl_ddltext_redacted

old
column	data type

new
column	data type
userid	int4
xid	int8
pid	int4
label	char(320)
starttime	timestamp
endtime	timestamp
sequence	int4
text_redacted	char(200)

pg_catalog.stl_doryc_container_stats

old
column	data type

new
column	data type
eventtime	timestamp
node	int4
container_name	char(32)
container_id	char(32)
cpu_usage_percentage	float8
memory_usage_percentage	float8
memory_usage	char(16)
pid_count	int4
net_io	char(16)

pg_catalog.stl_explain_redacted

old
column	data type

new
column	data type
userid	int4
query	int4
nodeid	int4
parentid	int4
plannode	char(400)
info_redacted	char(400)

pg_catalog.stl_external_query_detail_base_redacted

old
column	data type

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

pg_catalog.stl_federated_query_redacted

old
column	data type

new
column	data type
userid	int4
xid	int8
pid	int4
query	int4
sourcetype	char(30)
database	char(30)
segment	int4
node	int4
slice	int4
recordtime	timestamp
querytext_redacted	char(4000)
num_rows	int8
num_bytes	int8
duration	int8

pg_catalog.stl_query_redacted

old
column	data type

new
column	data type
userid	int4
query	int4
label	char(320)
xid	int8
pid	int4
database	char(32)
querytxt_redacted	char(4000)
starttime	timestamp
endtime	timestamp
aborted	int4
insert_pristine	int4
concurrency_scaling_status	int4

pg_catalog.stl_querytext_redacted

old
column	data type

new
column	data type
userid	int4
xid	int8
pid	int4
query	int4
sequence	int4
text_redacted	char(200)

pg_catalog.stl_sage_mode_simulation_queries

old
column	data type

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

pg_catalog.stl_stored_proc_call_redacted

old
column	data type

new
column	data type
userid	int4
session_userid	int4
query	int4
label	char(320)
xid	int8
pid	int4
database	char(32)
querytxt_redacted	char(500)
starttime	timestamp
endtime	timestamp
aborted	int4

pg_catalog.stl_user_query_history_redacted

old
column	data type

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_redacted	char(4000)
compute_type	char(32)
compile_time	int8
planning_time	int8
pure_planning_time	int8
lock_wait_time	int8
service_class_id	int4
service_class_name	char(64)
query_priority	char(20)
short_query_accelerated	char(10)
user_query_hash	char(40)
generic_query_hash	char(40)
query_hash_version	int4

pg_catalog.stl_user_query_text_redacted

old
column	data type

new
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
start_time	timestamp
sequence	int4
text_redacted	char(4000)

pg_catalog.stl_utilitytext_redacted

old
column	data type

new
column	data type
userid	int4
xid	int8
pid	int4
label	char(320)
starttime	timestamp
endtime	timestamp
sequence	int4
text_redacted	char(200)

pg_catalog.svv_copy_job_integrations

old
column	data type

new
column	data type
job_owner	int4
channel_arn	name
bucket	text
channel_state	name
db_name	name
job_name	text
job_state	int4

pg_catalog.stl_backup_compute

old
column	data type
currenttime	timestamp
node_num	int4
state	char(256)
backup_id	char(256)
sb_version	int8
starttime	timestamp
num_blocks	int8
superblock_size	int8
permanent_blocks	int8
blocks_to_upload	int8
blocks_uploaded	int8
num_failures	int8
num_modified_superblock_segments	int8
total_num_superblock_segments	int8
time_spent_stage1	int8
time_spent_read_sb_header	int8
time_spent_copy_segments	int8
time_spent_stage2	int8
time_spent_set_in_s3_bits	int8
inc_no_backup	int8
nobackup_blocks	int8
distall_blocks	int8
non_distall_blocks	int8
perm_blocks_in_s3	int8
metadata_read_from_backup	int4
blocks_validated	int8
sb_segments_available	int4
backup_manifest_available	int4
time_spent_generating_manifest	int8

new
column	data type
currenttime	timestamp
node_num	int4
state	char(256)
backup_id	char(256)
sb_version	int8
starttime	timestamp
num_blocks	int8
superblock_size	int8
permanent_blocks	int8
blocks_to_upload	int8
blocks_uploaded	int8
num_failures	int8
num_modified_superblock_segments	int8
total_num_superblock_segments	int8
time_spent_stage1	int8
time_spent_read_sb_header	int8
time_spent_copy_segments	int8
time_spent_stage2	int8
time_spent_set_in_s3_bits	int8
inc_no_backup	int8
nobackup_blocks	int8
distall_blocks	int8
non_distall_blocks	int8
perm_blocks_in_s3	int8
metadata_read_from_backup	int4
blocks_validated	int8
sb_segments_available	int4
backup_manifest_available	int4
time_spent_generating_manifest	int8
manifest_compression_level	int4

pg_catalog.stl_burst_manager_personalization

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

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

pg_catalog.stl_burst_write_block_header_trace

old
column	data type
xid	int8
query	int8
tbl	int4
node	int4
block_header_rcvd	int8
rcvd_time	timestamp
remote_write_type	int4

new
column	data type
xid	int8
query	int8
tbl	int4
node	int4
block_header_rcvd	int8
rcvd_time	timestamp
remote_write_type	int4
num_perm_mirror	int8
num_blk_header_batches	int4

pg_catalog.stl_catalog_rebuild_info

old
column	data type
xid	int8
database	int4
table_name	char(64)
table_oid	int8
num_live_tups	int8
num_dead_tups	int8
total_live_tup_sz	int8
total_dead_tup_sz	int8
starttime	timestamp
tuple_storage_duration_in_msec	int8
commit_lock_acq_duration_in_msec	int8
rebuild_duration_in_msec	int8
total_duration_in_msec	int8
message	char(128)
rebuild_mode	char(8)
startup	int4
versioned_rebuild	int4
versioned_rebuild_pivot_xid	int8
heap_xlog_duration_in_msec	int8
index_xlog_duration_in_msec	int8
xlog_write_duration_in_msec	int8
xlog_fsync_duration_in_msec	int8
repwal_duration_in_msec	int8
xlog_write_lock_acq_time_in_msec	int8
xlog_insert_lock_acq_time_in_msec	int8
num_xlog_writes	int8
num_xlog_fsyncs	int8
commit_message_mutex_acq_time_in_msec	int8

new
column	data type
xid	int8
database	int4
table_name	char(64)
table_oid	int8
num_live_tups	int8
num_dead_tups	int8
total_live_tup_sz	int8
total_dead_tup_sz	int8
starttime	timestamp
tuple_storage_duration_in_msec	int8
commit_lock_acq_duration_in_msec	int8
rebuild_duration_in_msec	int8
total_duration_in_msec	int8
message	char(128)
rebuild_mode	char(8)
startup	int4
versioned_rebuild	int4
versioned_rebuild_pivot_xid	int8
heap_xlog_duration_in_msec	int8
index_xlog_duration_in_msec	int8
xlog_write_duration_in_msec	int8
xlog_fsync_duration_in_msec	int8
repwal_duration_in_msec	int8
xlog_write_lock_acq_time_in_msec	int8
xlog_insert_lock_acq_time_in_msec	int8
num_xlog_writes	int8
num_xlog_fsyncs	int8
commit_message_mutex_acq_time_in_msec	int8
toast_num_live_tups	int8
toast_num_dead_tups	int8
total_toast_live_tup_sz	int8
total_toast_dead_tup_sz	int8
num_ver_dead_tups	int8
ver_dead_tup_sz_in_bytes	int8
toast_num_ver_dead_tups	int8
toast_ver_dead_tup_sz_in_bytes	int8

pg_catalog.stl_catalog_scan_metrics

old
column	data type
xid	int8
database	int4
table_name	char(128)
starttime	timestamp
duration_msec	int8
num_live_tups	int8
num_dead_tups	int8

new
column	data type
xid	int8
database	int4
table_name	char(128)
starttime	timestamp
duration_msec	int8
num_live_tups	int8
num_dead_tups	int8
total_live_tup_sz	int8
total_dead_tup_sz	int8
toast_num_live_tups	int8
toast_num_dead_tups	int8
total_toast_live_tup_sz	int8
total_toast_dead_tup_sz	int8

pg_catalog.stl_cqi_metrics

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

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

pg_catalog.stl_insertion_point_reservations

old
column	data type
query_id	int4
tbl	int4
data_slice	int4
strategy	int4
event	int4
ip_id	int4
type	int4
writer_group_index	int4
writer_index	int4
time	timestamp

new
column	data type
query_id	int4
tbl	int4
data_slice	int4
strategy	int4
event	int4
ip_id	int4
type	int4
writer_group_index	int4
writer_index	int4
time	timestamp
is_remote	int4

pg_catalog.stl_integration_log

old
column	data type
record_time	timestamp
integration_id	char(128)
integration_type	char(128)
state	char(128)
status	char(128)
database_name	char(128)
checkpoint_name	char(128)
checkpoint_type	char(16)
synced_log_coordinate	char(128)
num_modified_tables	int4
lag_ms	int8
checkpoint_bytes	int8
integration_start_time	timestamp
last_commit_timestamp	timestamp
num_failed_tables	int4
delay_ms	int8
channel_state	char(128)
export_identifier	char(64)
rows	int8

new
column	data type
record_time	timestamp
integration_id	char(128)
integration_type	char(128)
state	char(128)
status	char(128)
database_name	char(128)
checkpoint_name	char(128)
checkpoint_type	char(16)
synced_log_coordinate	char(128)
num_modified_tables	int4
lag_ms	int8
checkpoint_bytes	int8
integration_start_time	timestamp
last_commit_timestamp	timestamp
num_failed_tables	int4
delay_ms	int8
channel_state	char(128)
export_identifier	char(64)
rows	int8
inserted_rows	int8
deleted_rows	int8
updated_rows	int8

pg_catalog.stl_lambda_invocation_error

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

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

pg_catalog.stl_sage_mode_policy

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

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

pg_catalog.stl_sage_mode_simulation_clusters

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

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

pg_catalog.stl_sage_mode_simulation_summary

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

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

pg_catalog.stl_sage_scaling_candidates

old
column	data type
query	int4
decision_id	int4
candidate_id	int4
ssid	int4
state	int4
nodes	int4
running_queries	int4
queued_queries	int4
est_exec_time_ms	int4
spill_penalty_ms	int4
est_prepare_delay_ms	int4
est_queue_time_ms	int4
penalty	float8
eligible	int4
other_active_query_runtime_ms	int4
cost	float8
other_active_cluster_cost	float8
occupied_mb	int4
queue_head_wait_ms	int4
ineligibility_reason	int4

new
column	data type
query	int4
decision_id	int8
candidate_id	int4
ssid	int4
state	int4
nodes	int4
running_queries	int4
queued_queries	int4
est_exec_time_ms	int4
spill_penalty_ms	int4
est_prepare_delay_ms	int4
est_queue_time_ms	int4
penalty	float8
eligible	int4
other_active_query_runtime_ms	int4
cost	float8
other_active_cluster_cost	float8
occupied_mb	int4
queue_head_wait_ms	int4
ineligibility_reason	int4

pg_catalog.stl_scan_range_stats

old
column	data type
query	int4
segment	int4
step	int4
node	int4
local_data_slice	int4
local_compute_slice	int4
starttime	timestamp
endtime	timestamp
num_blocks_to_scan	int8
total_blocks	int8
num_scan_ranges	int8
min_scan_range_size	int8
max_scan_range_size	int8
avg_scan_range_size	int8
num_blf_ranges	int8
min_blf_range_size	int8
max_blf_range_size	int8
avg_blf_range_size	int8
block_reopen_times	int8

new
column	data type
query	int4
segment	int4
step	int4
node	int4
local_data_slice	int4
local_compute_slice	int4
starttime	timestamp
endtime	timestamp
num_blocks_to_scan	int8
total_blocks	int8
num_scan_ranges	int8
min_scan_range_size	int8
max_scan_range_size	int8
avg_scan_range_size	int8
num_blf_ranges	int8
min_blf_range_size	int8
max_blf_range_size	int8
avg_blf_range_size	int8
block_reopen_times	int8
optimized_scan_range_gen	char(1)
max_rows_per_scan_range	int8

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
lock_wait_time	int8
service_class_id	int4
service_class_name	char(64)
query_priority	char(20)
short_query_accelerated	char(10)

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
service_class_id	int4
service_class_name	char(64)
query_priority	char(20)
short_query_accelerated	char(10)
user_query_hash	char(40)
generic_query_hash	char(40)
query_hash_version	int4

pg_catalog.stl_vec_scan_stats

old
column	data type
query	int4
slice	int4
segment	int4
scalar_encoding_type	int4
predicate_window_size	int4
payload_window_size	int4
compact_col_count	int4
is_operator_pushdown	char(1)
apply_xid_time	int8
apply_predicate_time	int8
extract_predicate_time	int8
extract_payload_time	int8
compact_predicate_time	int8
compact_payload_time	int8
scalar_predicate_time	int8
consume_time	int8
step	int4

new
column	data type
query	int4
slice	int4
segment	int4
scalar_encoding_type	int4
predicate_window_size	int4
payload_window_size	int4
compact_col_count	int4
is_operator_pushdown	char(1)
apply_xid_time	int8
apply_predicate_time	int8
extract_predicate_time	int8
extract_payload_time	int8
compact_predicate_time	int8
compact_payload_time	int8
scalar_predicate_time	int8
consume_time	int8
step	int4
dynamic_predicate_reordering_status	int4

pg_catalog.svv_integration

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

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

pg_catalog.sys_integration_activity

old
column	data type
integration_id	char(128)
target_database	char(128)
source	char(128)
checkpoint_name	char(128)
checkpoint_type	char(16)
checkpoint_bytes	int8
last_commit_timestamp	timestamp
modified_tables	int4
integration_start_time	timestamp
integration_end_time	timestamp

new
column	data type
integration_id	char(128)
target_database	char(128)
source	char(128)
checkpoint_name	char(128)
checkpoint_type	char(16)
checkpoint_bytes	int8
last_commit_timestamp	timestamp
modified_tables	int4
integration_start_time	timestamp
integration_end_time	timestamp
inserted_rows	int8
deleted_rows	int8
updated_rows	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
lock_wait_time	int8
service_class_id	int4
service_class_name	char(64)
query_priority	char(20)
short_query_accelerated	char(10)

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