Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
new	pg_catalog	internal	stable	text	pg_get_privilege_scope_text	oid,oid
new	pg_catalog	internal	stable	text	pg_get_privilege_type_text	oid

Tables

pg_catalog.pg_integration_filter

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
channel_arn	name			NN
dbid	oid			NN
dependency_id	oid			NN
filter	text

pg_catalog.stcs_cluster_heart_beat

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
cluster_state	char(128)			NN
timestamp	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_comm_cleaner_queue_size

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
since	int8			NN
now	int8			NN
node	int4			NN
num_sinks	int8			NN
num_sources	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_grafting_cn

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
leaderpid	int4			NN
xid	int8			NN
query	int4			NN
table_id	int4			NN
graft_batch_id	int4			NN
producer_node_id	int4			NN
graft_step_start_time	int8			NN
graft_step_end_time	int8			NN
num_grafted_header_total	int8			NN
num_grafted_header_new	int8			NN
node	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_histogram_guardrails

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
qid	int4			NN
xid	int8			NN
total_accesses	int4			NN
planner_accesses	int4			NN
hit_count	int4			NN
copied_tables	int4			NN
refreshed_tables	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_iceberg_partition

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
pid	int4			NN
recordtime	int8			NN
table_name	char(512)			NN
table_uuid	char(36)			NN
snapshot_id	int8			NN
partition_spec	int8			NN
num_part_cols	int4			NN
num_partition_specs	int4			NN
num_identity	int4			NN
num_bucket	int4			NN
num_truncate	int4			NN
num_year	int4			NN
num_month	int4			NN
num_day	int4			NN
num_hour	int4			NN
num_void	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_lock

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
log_time	int8			NN
pid	int8			NN
process_type	char(20)			NN
xid	int8			NN
wait_time_us	int8			NN
hold_time_us	int8			NN
queue_length	int4			NN
lock_mode	int4			NN
lock_obj_type	int4			NN
lock_method_id	int4			NN
db_oid	int8			NN
rel_oid	int8			NN
block_num	int8			NN
lock_xid	int8			NN
class_oid	int8			NN
object_oid	int8			NN
object_subid	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_predictor_retrain

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
predictor	char(64)			NN
model	char(16)			NN
starttime	int8			NN
endtime	int8			NN
query_number	int4			NN
succeed	int4			NN
message	char(256)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_redcat_valet_request

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
requestid	char(50)			NN
api_call	int4			NN
starttime	int8			NN
worker_starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_sage_mode_simulation_clusters

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

pg_catalog.stcs_sage_mode_simulation_summary

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

pg_catalog.stcs_sage_query_trace_data

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
event_time	int8			NN
query_id	int4			NN
inflight	int4			NN
burstable	int4			NN
arrival_time	int8			NN
execution_time_ms	int4			NN
consumed_megabytes	int4			NN
cluster_size	int4			NN
predicted_execution_times	char(400)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_sage_query_trace_parameters

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
event_time	int8			NN
start_time	int8			NN
end_time	int8			NN
noise_enabled	int4			NN
noise_seed	int4			NN
arrival_time_noise_stddev_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

pg_catalog.stll_cluster_heart_beat

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
cluster_state	char(128)			NN
timestamp	int8			NN

pg_catalog.stll_comm_cleaner_queue_size

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
since	timestamp			NN
now	timestamp			NN
node	int4			NN
num_sinks	int8			NN
num_sources	int8			NN

pg_catalog.stll_datashare_grafting_cn

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
leaderpid	int4			NN
xid	int8			NN
query	int4			NN
table_id	int4			NN
graft_batch_id	int4			NN
producer_node_id	int4			NN
graft_step_start_time	timestamp			NN
graft_step_end_time	timestamp			NN
num_grafted_header_total	int8			NN
num_grafted_header_new	int8			NN
node	int4			NN

pg_catalog.stll_histogram_guardrails

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
qid	int4			NN
xid	int8			NN
total_accesses	int4			NN
planner_accesses	int4			NN
hit_count	int4			NN
copied_tables	int4			NN
refreshed_tables	int4			NN

pg_catalog.stll_iceberg_partition

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
pid	int4			NN
recordtime	timestamp			NN
table_name	char(512)			NN
table_uuid	char(36)			NN
snapshot_id	int8			NN
partition_spec	int8			NN
num_part_cols	int4			NN
num_partition_specs	int4			NN
num_identity	int4			NN
num_bucket	int4			NN
num_truncate	int4			NN
num_year	int4			NN
num_month	int4			NN
num_day	int4			NN
num_hour	int4			NN
num_void	int4			NN

pg_catalog.stll_lock

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
log_time	timestamp			NN
pid	int8			NN
process_type	char(20)			NN
xid	int8			NN
wait_time_us	int8			NN
hold_time_us	int8			NN
queue_length	int4			NN
lock_mode	int4			NN
lock_obj_type	int4			NN
lock_method_id	int4			NN
db_oid	int8			NN
rel_oid	int8			NN
block_num	int8			NN
lock_xid	int8			NN
class_oid	int8			NN
object_oid	int8			NN
object_subid	int4			NN

pg_catalog.stll_predictor_retrain

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
predictor	char(64)			NN
model	char(16)			NN
starttime	timestamp			NN
endtime	timestamp			NN
query_number	int4			NN
succeed	int4			NN
message	char(256)			NN

pg_catalog.stll_redcat_valet_request

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
requestid	char(50)			NN
api_call	int4			NN
starttime	timestamp			NN
worker_starttime	timestamp			NN
endtime	timestamp			NN
status	int4			NN
message	char(512)			NN

pg_catalog.stll_sage_mode_simulation_clusters

old
column	data type	PK	U	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	int4			NN
running_queries	int4			NN
occupied_query_mb	int4			NN
avg_response_time_ms	int4			NN
billed_rpu_ms	int4			NN

pg_catalog.stll_sage_mode_simulation_summary

old
column	data type	PK	U	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	int4			NN
total_queries	int8			NN
num_transitions	int4			NN
num_skipped_queries	int4			NN

pg_catalog.stll_sage_query_trace_data

old
column	data type	PK	U	NN

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

pg_catalog.stll_sage_query_trace_parameters

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
event_time	timestamp			NN
start_time	timestamp			NN
end_time	timestamp			NN
noise_enabled	int4			NN
noise_seed	int4			NN
arrival_time_noise_stddev_ms	int4			NN

pg_catalog.stv_comm_cleaner_queue_size

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
now	timestamp			NN
node	int4			NN
num_sinks	int8			NN
num_sources	int8			NN

pg_internal.redshift_auto_health_check_6098293

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

old
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
job_name	text
job_owner	int4			NN
auto_copy_table_oid	oid			NN
s3_prefix	text
iam_role	text
copy_query	text
is_auto	bool			NN
on_error_suspend	bool			NN
last_file_ingest	timestamp			NN
job_create_time	timestamp			NN
metadata	text

new
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
job_name	text
job_owner	int4			NN
auto_copy_table_oid	oid			NN
s3_prefix	text
iam_role	text
copy_query	text
is_auto	bool			NN
on_error_suspend	bool			NN
last_file_ingest	timestamp			NN
job_create_time	timestamp			NN
metadata	text
job_state	int4			NN

pg_catalog.pg_integration

old
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
channel_arn	name			NN
dbid	oid			NN
db_name	name			NN
state	name			NN
iam_role	name			NN
transport_path	text
source_type	name			NN

new
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
channel_arn	name			NN
dbid	oid			NN
db_name	name			NN
state	name			NN
iam_role	name			NN
transport_path	text
source_type	name			NN
full_channel_arn	name			NN
source_arn	name			NN
metadata	text

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
cluster_id	char(256)			NN
s3commit_aware_backup	int4			NN
manifest_compress_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

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
s3commit_aware_backup	int4			NN
manifest_compress_level	int4			NN
table_schema_size	int4			NN
db_metadata_size	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_burst_service_client

old
column	data type	PK	U	NN
action	char(10)			NN
pid	int8			NN
xid	int8			NN
eventtime	int8			NN
cluster_arn	char(128)			NN
expiration	int8			NN
preshared_key	char(100)			NN
num_nodes	int4			NN
error	char(250)			NN
request_id	char(100)			NN
reason	char(40)			NN
query	int4			NN
starttime	int8			NN
extended_json	char(80)			NN
burst_override_gucs	char(256)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
action	char(10)			NN
pid	int8			NN
xid	int8			NN
eventtime	int8			NN
cluster_arn	char(128)			NN
expiration	int8			NN
preshared_key	char(100)			NN
num_nodes	int4			NN
error	char(250)			NN
request_id	char(100)			NN
reason	char(40)			NN
query	int4			NN
starttime	int8			NN
extended_json	char(80)			NN
burst_override_gucs	char(256)			NN
burst_max_idle_time_seconds	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_burst_write_exec

old
column	data type	PK	U	NN
pid	int8			NN
xid	int8			NN
query	int8			NN
query_start_time	int8			NN
flush_start_time	int8			NN
stream_start_time	int8			NN
stream_end_time	int8			NN
dispatch_start_time	int8			NN
snap_in_start_time	int8			NN
snap_in_end_time	int8			NN
dispatch_end_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
pid	int8			NN
xid	int8			NN
query	int8			NN
query_start_time	int8			NN
flush_start_time	int8			NN
stream_start_time	int8			NN
stream_end_time	int8			NN
dispatch_start_time	int8			NN
snap_in_start_time	int8			NN
snap_in_end_time	int8			NN
dispatch_end_time	int8			NN
remote_write_type	int4			NN
receiver_wam_tracking_start	int8			NN
wam_delete_start_time	int8			NN
wam_delete_end_time	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_cdc_checkpoints

old
column	data type	PK	U	NN
recordtime	int8			NN
connection_id	char(128)			NN
db_name	char(128)			NN
s3_path	char(512)			NN
checkpoint	char(128)			NN
type	char(16)			NN
num_tables_modified	int4			NN
status	char(16)			NN
bytes_downloaded	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
recordtime	int8			NN
connection_id	char(128)			NN
db_name	char(128)			NN
s3_path	char(512)			NN
checkpoint	char(128)			NN
type	char(16)			NN
num_tables_modified	int4			NN
status	char(16)			NN
bytes_downloaded	int8			NN
channel_state	char(128)			NN
export_identifier	char(64)			NN
rows	int8			NN
content	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_exec_state

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
currenttime	int8			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
label	char(256)			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
step_attribute	char(64)			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

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
currenttime	int8			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
label	char(256)			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
step_attribute	char(64)			NN
access_control	int4			NN
parent_node_id	int4			NN
node_id	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_external_catalog_calls

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
uuid	char(36)			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
eventtime	int8			NN
call	int4			NN
objects	int4			NN
duration	int8			NN
catalog_type	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

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

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

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
initial_query_time	int8			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
reported_peak_usage_bytes	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
exec_time_wo_compilation	int8			NN
exec_cluster_size	int4			NN
auto_mounted_tables_accessed	int4			NN
spectrum_file_count	int4			NN
datasharing_spectrum_tables_accessed	int4			NN
lf_datasharing_spectrum_tables_accessed	int4			NN
__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_leader_snapshot

old
column	data type	PK	U	NN
currenttime	int8			NN
num_snapshot_blocks	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
num_snapshot_blocks	int4			NN
snapshot_creation_duration	int8			NN
persist_duration	int8			NN
last_wal_chain_block_num	int4			NN
pid	int4			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_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
internal_query	char(1)			NN
source	char(64)			NN
cpu_time	int8			NN
spilled_block_local_disk	int8			NN
spilled_block_remote_disk	int8			NN
step_attribute	char(64)			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

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
source	char(64)			NN
cpu_time	int8			NN
spilled_block_local_disk	int8			NN
spilled_block_remote_disk	int8			NN
step_attribute	char(64)			NN
access_control	int4			NN
plan_parent_id	int4			NN
plan_node_id	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_query_scaling_prediction

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
cluster_size	int4			NN
execution_time	float8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
cluster_size	int4			NN
execution_time	float8			NN
source	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_s3log

old
column	data type	PK	U	NN
userid	int4			NN
is_internal	int4			NN
pid	int4			NN
query	int4			NN
uuid	char(36)			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
eventtime	int8			NN
message	char(512)			NN
scan_type	int4			NN
request_id	char(16)			NN
error_type	int4			NN
spectrum_error_code	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

new
column	data type	PK	U	NN
userid	int4			NN
is_internal	int4			NN
pid	int4			NN
query	int4			NN
uuid	char(36)			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
eventtime	int8			NN
message	char(512)			NN
scan_type	int4			NN
request_id	char(16)			NN
error_type	int4			NN
spectrum_error_code	int4			NN
access_control	int4			NN
user_query_id	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_s3partition_elimination

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
starttime	int8			NN
endtime	int8			NN
total_partitions	int4			NN
qualified_partitions	int4			NN
assignment	char(1)			NN
duration	int8			NN
assigned_partitions	int4			NN
scan_type	int4			NN
fetched_partitions	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

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
starttime	int8			NN
endtime	int8			NN
total_partitions	int4			NN
qualified_partitions	int4			NN
assignment	char(1)			NN
duration	int8			NN
assigned_partitions	int4			NN
scan_type	int4			NN
fetched_partitions	int4			NN
access_control	int4			NN
user_query_id	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_s3table_stats

old
column	data type	PK	U	NN
user_id	int4			NN
pid	int4			NN
external_database_name	char(136)			NN
external_table_name	char(136)			NN
internal_table_name	char(272)			NN
record_time	int8			NN
table_statistics_source	int4			NN
column_statistics_source	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
user_id	int4			NN
pid	int4			NN
external_database_name	char(136)			NN
external_table_name	char(136)			NN
internal_table_name	char(272)			NN
record_time	int8			NN
table_statistics_source	int4			NN
column_statistics_source	int4			NN
has_null_count	int4			NN
has_ndv	int4			NN
has_histogram	int4			NN
has_column_width	int4			NN
user_query_id	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_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
__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	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

pg_catalog.stcs_segment_ce_stats

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
segment	int4			NN
num_data_slices	int4			NN
num_compute_slices	int4			NN
num_active_compute_slices	int4			NN
parallelization_mode	char(32)			NN
row_fetcher_state	char(32)			NN
row_fetcher_reason	int8			NN
work_stealing_state	int8			NN
lds_distribution_state	int8			NN
topology_type	char(32)			NN
topology_id	int8			NN
target_topology_id	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
segment	int4			NN
num_data_slices	int4			NN
num_compute_slices	int4			NN
num_active_compute_slices	int4			NN
parallelization_mode	char(32)			NN
row_fetcher_state	char(32)			NN
row_fetcher_reason	int8			NN
work_stealing_state	int8			NN
lds_distribution_state	int8			NN
topology_type	char(32)			NN
topology_id	int8			NN
target_topology_id	int8			NN
is_ce_insert_mem_opt	char(1)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_state_table_column_metadata

old
column	data type	PK	U	NN
timestamp	int8			NN
slice	int4			NN
table_id	int4			NN
column_id	int4			NN
num_blocks	int8			NN
row_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
timestamp	int8			NN
slice	int4			NN
table_id	int4			NN
column_id	int4			NN
num_blocks	int8			NN
row_count	int8			NN
temp	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

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

pg_catalog.stcs_version

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

new
column	data type	PK	U	NN
bootstrap_time	int8			NN
db_version	char(50)			NN
restart_reason	char(100)			NN
restart_trace_id	char(64)			NN
track_name	char(30)			NN
instance_type	char(30)			NN
num_nodes	int4			NN
major_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.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
cluster_id	char(256)			NN
s3commit_aware_backup	int4			NN
manifest_compress_level	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
s3commit_aware_backup	int4			NN
manifest_compress_level	int4			NN
table_schema_size	int4			NN
db_metadata_size	int4			NN

pg_catalog.stll_burst_service_client

old
column	data type	PK	U	NN
action	char(10)			NN
pid	int8			NN
xid	int8			NN
eventtime	timestamp			NN
cluster_arn	char(128)			NN
expiration	timestamp			NN
preshared_key	char(100)			NN
num_nodes	int4			NN
error	char(250)			NN
request_id	char(100)			NN
reason	char(40)			NN
query	int4			NN
starttime	timestamp			NN
extended_json	char(80)			NN
burst_override_gucs	char(256)			NN

new
column	data type	PK	U	NN
action	char(10)			NN
pid	int8			NN
xid	int8			NN
eventtime	timestamp			NN
cluster_arn	char(128)			NN
expiration	timestamp			NN
preshared_key	char(100)			NN
num_nodes	int4			NN
error	char(250)			NN
request_id	char(100)			NN
reason	char(40)			NN
query	int4			NN
starttime	timestamp			NN
extended_json	char(80)			NN
burst_override_gucs	char(256)			NN
burst_max_idle_time_seconds	int8			NN

pg_catalog.stll_burst_write_exec

old
column	data type	PK	U	NN
pid	int8			NN
xid	int8			NN
query	int8			NN
query_start_time	timestamp			NN
flush_start_time	timestamp			NN
stream_start_time	timestamp			NN
stream_end_time	timestamp			NN
dispatch_start_time	timestamp			NN
snap_in_start_time	timestamp			NN
snap_in_end_time	timestamp			NN
dispatch_end_time	timestamp			NN
remote_write_type	int4			NN

new
column	data type	PK	U	NN
pid	int8			NN
xid	int8			NN
query	int8			NN
query_start_time	timestamp			NN
flush_start_time	timestamp			NN
stream_start_time	timestamp			NN
stream_end_time	timestamp			NN
dispatch_start_time	timestamp			NN
snap_in_start_time	timestamp			NN
snap_in_end_time	timestamp			NN
dispatch_end_time	timestamp			NN
remote_write_type	int4			NN
receiver_wam_tracking_start	timestamp			NN
wam_delete_start_time	timestamp			NN
wam_delete_end_time	timestamp			NN

pg_catalog.stll_cdc_checkpoints

old
column	data type	PK	U	NN
recordtime	timestamp			NN
connection_id	char(128)			NN
db_name	char(128)			NN
s3_path	char(512)			NN
checkpoint	char(128)			NN
type	char(16)			NN
num_tables_modified	int4			NN
status	char(16)			NN
bytes_downloaded	int8			NN
channel_state	char(128)			NN
export_identifier	char(64)			NN
rows	int8			NN

new
column	data type	PK	U	NN
recordtime	timestamp			NN
connection_id	char(128)			NN
db_name	char(128)			NN
s3_path	char(512)			NN
checkpoint	char(128)			NN
type	char(16)			NN
num_tables_modified	int4			NN
status	char(16)			NN
bytes_downloaded	int8			NN
channel_state	char(128)			NN
export_identifier	char(64)			NN
rows	int8			NN
content	char(4096)			NN

pg_catalog.stll_exec_state

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
currenttime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
label	char(256)			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
step_attribute	char(64)			NN
access_control	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
currenttime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
label	char(256)			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
step_attribute	char(64)			NN
access_control	int4			NN
parent_node_id	int4			NN
node_id	int4			NN

pg_catalog.stll_external_catalog_calls

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

pg_catalog.stll_internal_query_details

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

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

pg_catalog.stll_leader_snapshot

old
column	data type	PK	U	NN
currenttime	timestamp			NN
num_snapshot_blocks	int4			NN

new
column	data type	PK	U	NN
currenttime	timestamp			NN
num_snapshot_blocks	int4			NN
snapshot_creation_duration	int8			NN
persist_duration	int8			NN
last_wal_chain_block_num	int4			NN
pid	int4			NN
xid	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
internal_query	char(1)			NN
source	char(64)			NN
cpu_time	int8			NN
spilled_block_local_disk	int8			NN
spilled_block_remote_disk	int8			NN
step_attribute	char(64)			NN
access_control	int4			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
source	char(64)			NN
cpu_time	int8			NN
spilled_block_local_disk	int8			NN
spilled_block_remote_disk	int8			NN
step_attribute	char(64)			NN
access_control	int4			NN
plan_parent_id	int4			NN
plan_node_id	int4			NN

pg_catalog.stll_query_scaling_prediction

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
cluster_size	int4			NN
execution_time	float8			NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
cluster_size	int4			NN
execution_time	float8			NN
source	int4			NN

pg_catalog.stll_s3log

old
column	data type	PK	U	NN
userid	int4			NN
is_internal	int4			NN
pid	int4			NN
query	int4			NN
uuid	char(36)			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
eventtime	timestamp			NN
message	char(512)			NN
scan_type	int4			NN
request_id	char(16)			NN
error_type	int4			NN
spectrum_error_code	int4			NN
access_control	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
is_internal	int4			NN
pid	int4			NN
query	int4			NN
uuid	char(36)			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
eventtime	timestamp			NN
message	char(512)			NN
scan_type	int4			NN
request_id	char(16)			NN
error_type	int4			NN
spectrum_error_code	int4			NN
access_control	int4			NN
user_query_id	int8			NN

pg_catalog.stll_s3partition_elimination

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
starttime	timestamp			NN
endtime	timestamp			NN
total_partitions	int4			NN
qualified_partitions	int4			NN
assignment	char(1)			NN
duration	int8			NN
assigned_partitions	int4			NN
scan_type	int4			NN
fetched_partitions	int4			NN
access_control	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
starttime	timestamp			NN
endtime	timestamp			NN
total_partitions	int4			NN
qualified_partitions	int4			NN
assignment	char(1)			NN
duration	int8			NN
assigned_partitions	int4			NN
scan_type	int4			NN
fetched_partitions	int4			NN
access_control	int4			NN
user_query_id	int8			NN

pg_catalog.stll_s3table_stats

old
column	data type	PK	U	NN
user_id	int4			NN
pid	int4			NN
external_database_name	char(136)			NN
external_table_name	char(136)			NN
internal_table_name	char(272)			NN
record_time	timestamp			NN
table_statistics_source	int4			NN
column_statistics_source	int4			NN

new
column	data type	PK	U	NN
user_id	int4			NN
pid	int4			NN
external_database_name	char(136)			NN
external_table_name	char(136)			NN
internal_table_name	char(272)			NN
record_time	timestamp			NN
table_statistics_source	int4			NN
column_statistics_source	int4			NN
has_null_count	int4			NN
has_ndv	int4			NN
has_histogram	int4			NN
has_column_width	int4			NN
user_query_id	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

new
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

pg_catalog.stll_segment_ce_stats

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
segment	int4			NN
num_data_slices	int4			NN
num_compute_slices	int4			NN
num_active_compute_slices	int4			NN
parallelization_mode	char(32)			NN
row_fetcher_state	char(32)			NN
row_fetcher_reason	int8			NN
work_stealing_state	int8			NN
lds_distribution_state	int8			NN
topology_type	char(32)			NN
topology_id	int8			NN
target_topology_id	int8			NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
segment	int4			NN
num_data_slices	int4			NN
num_compute_slices	int4			NN
num_active_compute_slices	int4			NN
parallelization_mode	char(32)			NN
row_fetcher_state	char(32)			NN
row_fetcher_reason	int8			NN
work_stealing_state	int8			NN
lds_distribution_state	int8			NN
topology_type	char(32)			NN
topology_id	int8			NN
target_topology_id	int8			NN
is_ce_insert_mem_opt	char(1)			NN

pg_catalog.stll_state_table_column_metadata

old
column	data type	PK	U	NN
timestamp	int8			NN
slice	int4			NN
table_id	int4			NN
column_id	int4			NN
num_blocks	int8			NN
row_count	int8			NN

new
column	data type	PK	U	NN
timestamp	int8			NN
slice	int4			NN
table_id	int4			NN
column_id	int4			NN
num_blocks	int8			NN
row_count	int8			NN
temp	int4			NN

pg_catalog.stll_user_query_history

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database_name	char(128)			NN
query_type	char(32)			NN
status	char(10)			NN
result_cache_source_query	int8			NN
start_time	timestamp			NN
end_time	timestamp			NN
queue_time	int8			NN
execution_time	int8			NN
error_message	char(512)			NN
returned_rows	int8			NN
returned_bytes	int8			NN
redshift_version	char(32)			NN
usage_limit	char(150)			NN
internal_query	char(1)			NN
query_text	char(4000)			NN
compute_type	char(32)			NN
compile_time	int8			NN
planning_time	int8			NN
pure_planning_time	int8			NN
lock_wait_time	int8			NN
access_control	int4			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

pg_catalog.stll_version

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

new
column	data type	PK	U	NN
bootstrap_time	timestamp			NN
db_version	char(50)			NN
restart_reason	char(100)			NN
restart_trace_id	char(64)			NN
track_name	char(30)			NN
instance_type	char(30)			NN
num_nodes	int4			NN
major_version	int4			NN

pg_catalog.stv_exec_state

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
currenttime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
label	char(256)			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
step_attribute	char(64)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
currenttime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
label	char(256)			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
step_attribute	char(64)			NN
plan_parent_id	int4			NN
plan_node_id	int4			NN

pg_catalog.stv_integration_table_state

old
column	data type	PK	U	NN
integration_id	char(128)			NN
database_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
state	char(128)			NN
synced_log_coordinate	char(128)			NN
reason	char(256)			NN
size	int4			NN
last_updated	timestamp			NN

new
column	data type	PK	U	NN
integration_id	char(128)			NN
database_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
state	char(128)			NN
synced_log_coordinate	char(128)			NN
reason	char(256)			NN
size	int4			NN
last_updated	timestamp			NN
table_id	int4			NN

pg_catalog.stv_user_query_state

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
label	char(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

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

pg_internal.redshift_auto_health_check_6071476

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_cluster_heart_beat

old
column	data type

new
column	data type
cluster_state	char(128)
timestamp	int8

pg_catalog.stl_comm_cleaner_queue_size

old
column	data type

new
column	data type
since	timestamp
now	timestamp
node	int4
num_sinks	int8
num_sources	int8

pg_catalog.stl_datashare_grafting_cn

old
column	data type

new
column	data type
leaderpid	int4
xid	int8
query	int4
table_id	int4
graft_batch_id	int4
producer_node_id	int4
graft_step_start_time	timestamp
graft_step_end_time	timestamp
num_grafted_header_total	int8
num_grafted_header_new	int8
node	int4

pg_catalog.stl_histogram_guardrails

old
column	data type

new
column	data type
qid	int4
xid	int8
total_accesses	int4
planner_accesses	int4
hit_count	int4
copied_tables	int4
refreshed_tables	int4

pg_catalog.stl_iceberg_partition

old
column	data type

new
column	data type
userid	int4
query	int4
pid	int4
recordtime	timestamp
table_name	char(512)
table_uuid	char(36)
snapshot_id	int8
partition_spec	int8
num_part_cols	int4
num_partition_specs	int4
num_identity	int4
num_bucket	int4
num_truncate	int4
num_year	int4
num_month	int4
num_day	int4
num_hour	int4
num_void	int4

pg_catalog.stl_lock

old
column	data type

new
column	data type
log_time	timestamp
pid	int8
process_type	char(20)
xid	int8
wait_time_us	int8
hold_time_us	int8
queue_length	int4
lock_mode	int4
lock_obj_type	int4
lock_method_id	int4
db_oid	int8
rel_oid	int8
block_num	int8
lock_xid	int8
class_oid	int8
object_oid	int8
object_subid	int4

pg_catalog.stl_predictor_retrain

old
column	data type

new
column	data type
predictor	char(64)
model	char(16)
starttime	timestamp
endtime	timestamp
query_number	int4
succeed	int4
message	char(256)

pg_catalog.stl_redcat_valet_request

old
column	data type

new
column	data type
requestid	char(50)
api_call	int4
starttime	timestamp
worker_starttime	timestamp
endtime	timestamp
status	int4
message	char(512)

pg_catalog.stl_sage_mode_simulation_clusters

old
column	data type

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	int4
running_queries	int4
occupied_query_mb	int4
avg_response_time_ms	int4
billed_rpu_ms	int4

pg_catalog.stl_sage_mode_simulation_summary

old
column	data type

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	int4
total_queries	int8
num_transitions	int4
num_skipped_queries	int4

pg_catalog.stl_sage_query_trace_data

old
column	data type

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

pg_catalog.stl_sage_query_trace_parameters

old
column	data type

new
column	data type
event_time	timestamp
start_time	timestamp
end_time	timestamp
noise_enabled	int4
noise_seed	int4
arrival_time_noise_stddev_ms	int4

pg_catalog.sys_query_explain

old
column	data type

new
column	data type
userid	int4
query_id	int8
child_query_sequence	int4
plan_node_id	int4
plan_parent_id	int4
plan_node	char(400)
plan_info	char(400)

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
cluster_id	char(256)
s3commit_aware_backup	int4
manifest_compress_level	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)
s3commit_aware_backup	int4
manifest_compress_level	int4
table_schema_size	int4
db_metadata_size	int4

pg_catalog.stl_burst_service_client

old
column	data type
action	char(10)
pid	int8
xid	int8
eventtime	timestamp
cluster_arn	char(128)
expiration	timestamp
preshared_key	char(100)
num_nodes	int4
error	char(250)
request_id	char(100)
reason	char(40)
query	int4
starttime	timestamp
extended_json	char(80)
burst_override_gucs	char(256)

new
column	data type
action	char(10)
pid	int8
xid	int8
eventtime	timestamp
cluster_arn	char(128)
expiration	timestamp
preshared_key	char(100)
num_nodes	int4
error	char(250)
request_id	char(100)
reason	char(40)
query	int4
starttime	timestamp
extended_json	char(80)
burst_override_gucs	char(256)
burst_max_idle_time_seconds	int8

pg_catalog.stl_burst_write_exec

old
column	data type
pid	int8
xid	int8
query	int8
query_start_time	timestamp
flush_start_time	timestamp
stream_start_time	timestamp
stream_end_time	timestamp
dispatch_start_time	timestamp
snap_in_start_time	timestamp
snap_in_end_time	timestamp
dispatch_end_time	timestamp
remote_write_type	int4

new
column	data type
pid	int8
xid	int8
query	int8
query_start_time	timestamp
flush_start_time	timestamp
stream_start_time	timestamp
stream_end_time	timestamp
dispatch_start_time	timestamp
snap_in_start_time	timestamp
snap_in_end_time	timestamp
dispatch_end_time	timestamp
remote_write_type	int4
receiver_wam_tracking_start	timestamp
wam_delete_start_time	timestamp
wam_delete_end_time	timestamp

pg_catalog.stl_cdc_checkpoints

old
column	data type
recordtime	timestamp
connection_id	char(128)
db_name	char(128)
s3_path	char(512)
checkpoint	char(128)
type	char(16)
num_tables_modified	int4
status	char(16)
bytes_downloaded	int8
channel_state	char(128)
export_identifier	char(64)
rows	int8

new
column	data type
recordtime	timestamp
connection_id	char(128)
db_name	char(128)
s3_path	char(512)
checkpoint	char(128)
type	char(16)
num_tables_modified	int4
status	char(16)
bytes_downloaded	int8
channel_state	char(128)
export_identifier	char(64)
rows	int8
content	char(4096)

pg_catalog.stl_exec_state

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
currenttime	timestamp
tasknum	int4
rows	int8
bytes	int8
label	char(256)
is_diskbased	char(1)
workmem	int8
num_parts	int4
is_rrscan	char(1)
is_delayed_scan	char(1)
step_attribute	char(64)

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
currenttime	timestamp
tasknum	int4
rows	int8
bytes	int8
label	char(256)
is_diskbased	char(1)
workmem	int8
num_parts	int4
is_rrscan	char(1)
is_delayed_scan	char(1)
step_attribute	char(64)
parent_node_id	int4
node_id	int4

pg_catalog.stl_external_catalog_calls

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

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

pg_catalog.stl_internal_query_details

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

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

pg_catalog.stl_leader_snapshot

old
column	data type
currenttime	timestamp
num_snapshot_blocks	int4

new
column	data type
currenttime	timestamp
num_snapshot_blocks	int4
snapshot_creation_duration	int8
persist_duration	int8
last_wal_chain_block_num	int4
pid	int4
xid	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)
internal_query	char(1)
source	char(64)
cpu_time	int8
spilled_block_local_disk	int8
spilled_block_remote_disk	int8
step_attribute	char(64)

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)
source	char(64)
cpu_time	int8
spilled_block_local_disk	int8
spilled_block_remote_disk	int8
step_attribute	char(64)
plan_parent_id	int4
plan_node_id	int4

pg_catalog.stl_query_scaling_prediction

old
column	data type
query	int4
xid	int8
cluster_size	int4
execution_time	float8

new
column	data type
query	int4
xid	int8
cluster_size	int4
execution_time	float8
source	int4

pg_catalog.stl_s3log

old
column	data type
userid	int4
is_internal	int4
pid	int4
query	int4
uuid	char(36)
segment	int4
step	int4
node	int4
slice	int4
eventtime	timestamp
message	char(512)
scan_type	int4
request_id	char(16)
error_type	int4
spectrum_error_code	int4

new
column	data type
userid	int4
is_internal	int4
pid	int4
query	int4
uuid	char(36)
segment	int4
step	int4
node	int4
slice	int4
eventtime	timestamp
message	char(512)
scan_type	int4
request_id	char(16)
error_type	int4
spectrum_error_code	int4
user_query_id	int8

pg_catalog.stl_s3partition_elimination

old
column	data type
userid	int4
query	int4
uuid	char(36)
segment	int4
node	int4
slice	int4
starttime	timestamp
endtime	timestamp
total_partitions	int4
qualified_partitions	int4
assignment	char(1)
duration	int8
assigned_partitions	int4
scan_type	int4
fetched_partitions	int4

new
column	data type
userid	int4
query	int4
uuid	char(36)
segment	int4
node	int4
slice	int4
starttime	timestamp
endtime	timestamp
total_partitions	int4
qualified_partitions	int4
assignment	char(1)
duration	int8
assigned_partitions	int4
scan_type	int4
fetched_partitions	int4
user_query_id	int8

pg_catalog.stl_s3table_stats

old
column	data type
user_id	int4
pid	int4
external_database_name	char(136)
external_table_name	char(136)
internal_table_name	char(272)
record_time	timestamp
table_statistics_source	int4
column_statistics_source	int4

new
column	data type
user_id	int4
pid	int4
external_database_name	char(136)
external_table_name	char(136)
internal_table_name	char(272)
record_time	timestamp
table_statistics_source	int4
column_statistics_source	int4
has_null_count	int4
has_ndv	int4
has_histogram	int4
has_column_width	int4
user_query_id	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

new
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

pg_catalog.stl_segment_ce_stats

old
column	data type
query	int4
node	int4
segment	int4
num_data_slices	int4
num_compute_slices	int4
num_active_compute_slices	int4
parallelization_mode	char(32)
row_fetcher_state	char(32)
row_fetcher_reason	int8
work_stealing_state	int8
lds_distribution_state	int8
topology_type	char(32)
topology_id	int8
target_topology_id	int8

new
column	data type
query	int4
node	int4
segment	int4
num_data_slices	int4
num_compute_slices	int4
num_active_compute_slices	int4
parallelization_mode	char(32)
row_fetcher_state	char(32)
row_fetcher_reason	int8
work_stealing_state	int8
lds_distribution_state	int8
topology_type	char(32)
topology_id	int8
target_topology_id	int8
is_ce_insert_mem_opt	char(1)

pg_catalog.stl_state_table_column_metadata

old
column	data type
timestamp	int8
slice	int4
table_id	int4
column_id	int4
num_blocks	int8
row_count	int8

new
column	data type
timestamp	int8
slice	int4
table_id	int4
column_id	int4
num_blocks	int8
row_count	int8
temp	int4

pg_catalog.stl_user_query_history

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

new
column	data type
user_id	int4
query_id	int8
label	char(320)
xid	int8
pid	int4
database_name	char(128)
query_type	char(32)
status	char(10)
result_cache_source_query	int8
start_time	timestamp
end_time	timestamp
queue_time	int8
execution_time	int8
error_message	char(512)
returned_rows	int8
returned_bytes	int8
redshift_version	char(32)
usage_limit	char(150)
internal_query	char(1)
query_text	char(4000)
compute_type	char(32)
compile_time	int8
planning_time	int8
pure_planning_time	int8
lock_wait_time	int8
service_class_id	int4
service_class_name	char(64)
query_priority	char(20)
short_query_accelerated	char(10)

pg_catalog.stl_version

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

new
column	data type
bootstrap_time	timestamp
db_version	char(50)
restart_reason	char(100)
restart_trace_id	char(64)
track_name	char(30)
instance_type	char(30)
num_nodes	int4
major_version	int4

pg_catalog.svv_database_privileges

old
column	data type
database_name	varchar(128)
privilege_type	varchar(128)
identity_id	int4
identity_name	varchar(128)
identity_type	varchar(128)
admin_option	bool

new
column	data type
database_name	varchar(128)
privilege_type	varchar(128)
identity_id	int4
identity_name	varchar(128)
identity_type	varchar(128)
admin_option	bool
privilege_scope	varchar(128)

pg_catalog.svv_integration_table_state

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

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

pg_catalog.svv_schema_privileges

old
column	data type
namespace_name	varchar(128)
privilege_type	varchar(128)
identity_id	int4
identity_name	varchar(128)
identity_type	varchar(128)
admin_option	bool

new
column	data type
namespace_name	varchar(128)
privilege_type	varchar(128)
identity_id	int4
identity_name	varchar(128)
identity_type	varchar(128)
admin_option	bool
privilege_scope	varchar(128)

pg_catalog.svv_vacuum_progress

old
column	data type
table_name	varchar(255)
status	varchar(4000)
time_remaining_estimate	varchar(32)

new
column	data type
table_name	varchar(255)
status	varchar(4000)
time_remaining_estimate	varchar(32)
total_duration_s	int8
xid	int8
table_id	int4
db_id	int4
database_name	varchar(128)
vacuum_start_time	timestamp
vacuum_end_time	timestamp

pg_catalog.sys_query_detail

old
column	data type
user_id	int4
query_id	int8
child_query_sequence	int4
stream_id	int4
segment_id	int4
step_id	int4
step_name	varchar(256)
table_id	int4
table_name	varchar(136)
is_rrscan	varchar(1)
start_time	timestamp
end_time	timestamp
duration	int8
alert	varchar(1024)
input_bytes	int8
input_rows	int8
output_bytes	int8
output_rows	int8
blocks_read	int8
blocks_write	int8
local_read_io	int8
remote_read_io	int8
source	varchar(64)
data_skewness	int4
time_skewness	int4
is_active	varchar(1)
spilled_block_local_disk	int8
spilled_block_remote_disk	int8
step_attribute	varchar(64)
metrics_level	varchar(11)

new
column	data type
user_id	int4
query_id	int8
child_query_sequence	int4
stream_id	int4
segment_id	int4
step_id	int4
step_name	varchar(256)
table_id	int4
table_name	varchar(136)
is_rrscan	varchar(1)
start_time	timestamp
end_time	timestamp
duration	int8
alert	varchar(1024)
input_bytes	int8
input_rows	int8
output_bytes	int8
output_rows	int8
blocks_read	int8
blocks_write	int8
local_read_io	int8
remote_read_io	int8
source	varchar(64)
data_skewness	int4
time_skewness	int4
is_active	varchar(1)
spilled_block_local_disk	int8
spilled_block_remote_disk	int8
step_attribute	varchar(64)
metrics_level	varchar(11)
plan_parent_id	int4
plan_node_id	int4

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

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)