Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
new	pg_catalog	internal	immutable	int4	json_size	super
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	bool
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	bool,int4
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	bpchar
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	bpchar,int4
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	date
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	date,int4
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	float4
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	float4,int4
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	float8
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	float8,int4
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	int2
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	int2,int4
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	int4
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	int4,int4
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	int8
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	int8,int4
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	numeric
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	numeric,int4
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	text
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	text,int4
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	time
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	time,int4
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	timestamp
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	timestamp,int4
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	timestamptz
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	timestamptz,int4
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	timetz
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	timetz,int4
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	varbyte
new	pg_catalog	internal	immutable	int4	murmur3_32_hash	varbyte,int4
new	pg_catalog	internal	immutable	name	mask_get_policy_for_role_on_column	varchar,varchar,varchar,varchar
new	pg_catalog	internal	immutable	name	mask_get_policy_for_user_on_column	varchar,varchar,varchar,varchar
new	pg_catalog	internal	immutable	numeric	try_numeric	bpchar
new	pg_catalog	internal	immutable	numeric	try_numeric	float4
new	pg_catalog	internal	immutable	numeric	try_numeric	float8
new	pg_catalog	internal	immutable	numeric	try_numeric	int2
new	pg_catalog	internal	immutable	numeric	try_numeric	int4
new	pg_catalog	internal	immutable	numeric	try_numeric	int8
new	pg_catalog	internal	immutable	numeric	try_numeric	numeric,int4
new	pg_catalog	internal	immutable	numeric	try_numeric	super
new	pg_catalog	internal	immutable	numeric	try_numeric	text
new	pg_catalog	internal	immutable	numeric	try_numeric_in	cstring,oid,int4
new	pg_catalog	internal	immutable	varchar	mask_policy_attached_atts_out	oid,varchar
new	pg_catalog	internal	immutable	varchar	mask_policy_atts_out	varchar
new	pg_catalog	internal	immutable	varchar	mask_policy_expr_out	varchar
new	pg_catalog	internal	volatile	int4	reset_workgroup	None

Tables

pg_catalog.pg_auto_copy_history

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
job_name	text
file_name	text
ingested	bool			NN

pg_catalog.pg_auto_copy_job

old
column	data type	PK	U	NN

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

pg_catalog.pg_external_object

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
objid	oid			NN
objsource	char(1)			NN
objkind	char(1)			NN
objargs	text

pg_catalog.pg_integration

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
db_name	name			NN
state	name			NN
iam_role	name			NN
transport_path	text
source_type	name			NN

pg_catalog.stcs_alter_dist_catalog_change_events

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
xid	int8			NN
pid	int4			NN
tbl	int4			NN
eventtime	int8			NN
event	char(128)			NN
prev_distkey	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_cdc_connection

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	int8			NN
channel_id	char(128)			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_datashare_query_info

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
leaderpid	int4			NN
xid	int8			NN
query	int4			NN
table_id	int4			NN
current_dml_version	int8			NN
current_sructure_version	int8			NN
current_sb_version	int8			NN
current_ddl_version	int8			NN
target_dml_version	int8			NN
target_structure_version	int8			NN
target_sb_version	int8			NN
target_ddl_version	int8			NN
leader_node_start_time	int8			NN
leader_node_end_time	int8			NN
node	int4			NN
compute_node_start_time	int8			NN
compute_node_end_time	int8			NN
refresh_queue_start_time	int8			NN
refresh_queue_end_time	int8			NN
sb_download_grafting_start_time	int8			NN
sb_download_grafting_end_time	int8			NN
total_sb_download_seconds	float8			NN
total_sb_batches	int4			NN
changed_headers	int8			NN
table_grafting_mode	char(16)			NN
sb_download_mode	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_integration_log

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

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
logtime	int8			NN
node	int8			NN
total_rowblocks	int8			NN
total_mega_rowblocks	int8			NN
max_rowblock_manager_size	int8			NN
min_rowblock_manager_size	int8			NN
max_rowblock_size	int8			NN
min_rowblock_size	int8			NN
added_rowblocks	int8			NN
added_mega_rowblocks	int8			NN
tossed_rowblocks	int8			NN
mega_rowblocks_writes	int8			NN
mega_rowblocks_reads	int8			NN
rowblocks_in_disk_cache	int8			NN
num_megarowblocks_in_disk_cache	int8			NN
mega_rowblocks_in_disk_cache	int8			NN
pinned_rowblocks	int8			NN
percentage_shared_mem_used	float8			NN
dirty_rowblocks	int8			NN
rowblocks_in_disk	int8			NN
rowblocks_in_s3	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_sub_transaction_commit_info

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
masterxid	int8			NN
xid	int8			NN
node	int4			NN
commitlevel	int4			NN
refreshtype	char(10)			NN
starttime	int8			NN
endtime	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_superblock_trickle_validation_summary

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
record_time	int8			NN
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_blocks_validated	int8			NN
log_entries_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
tree_trickle_validation_done	int4			NN
trickle_validation_done	int4			NN
num_steps_trickle_validation	int4			NN
log_rotation_done	int4			NN
num_steps_log_rotation	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_map

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
user_query_id	int8			NN
rewritten_query_id	int8			NN
transaction_id	int8			NN
process_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_wlm_multi_az_routing

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
pid	int4			NN
xid	int4			NN
query	int4			NN
service_class	int4			NN
recordtime	int8			NN
main_total_memory	int4			NN
main_used_memory	int4			NN
multi_az_total_memory	int4			NN
multi_az_used_memory	int4			NN
routing_threshold	int4			NN
routing_decision	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_alter_dist_catalog_change_events

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
xid	int8			NN
pid	int4			NN
tbl	int4			NN
eventtime	timestamp			NN
event	char(128)			NN
prev_distkey	int4			NN

pg_catalog.stll_cdc_connection

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
channel_id	char(128)			NN
message	char(256)			NN

pg_catalog.stll_datashare_query_info

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
leaderpid	int4			NN
xid	int8			NN
query	int4			NN
table_id	int4			NN
current_dml_version	int8			NN
current_sructure_version	int8			NN
current_sb_version	int8			NN
current_ddl_version	int8			NN
target_dml_version	int8			NN
target_structure_version	int8			NN
target_sb_version	int8			NN
target_ddl_version	int8			NN
leader_node_start_time	timestamp			NN
leader_node_end_time	timestamp			NN
node	int4			NN
compute_node_start_time	timestamp			NN
compute_node_end_time	timestamp			NN
refresh_queue_start_time	timestamp			NN
refresh_queue_end_time	timestamp			NN
sb_download_grafting_start_time	timestamp			NN
sb_download_grafting_end_time	timestamp			NN
total_sb_download_seconds	float8			NN
total_sb_batches	int4			NN
changed_headers	int8			NN
table_grafting_mode	char(16)			NN
sb_download_mode	char(16)			NN

pg_catalog.stll_integration_log

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

pg_catalog.stll_rowblock_manager_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
logtime	timestamp			NN
node	int8			NN
total_rowblocks	int8			NN
total_mega_rowblocks	int8			NN
max_rowblock_manager_size	int8			NN
min_rowblock_manager_size	int8			NN
max_rowblock_size	int8			NN
min_rowblock_size	int8			NN
added_rowblocks	int8			NN
added_mega_rowblocks	int8			NN
tossed_rowblocks	int8			NN
mega_rowblocks_writes	int8			NN
mega_rowblocks_reads	int8			NN
rowblocks_in_disk_cache	int8			NN
num_megarowblocks_in_disk_cache	int8			NN
mega_rowblocks_in_disk_cache	int8			NN
pinned_rowblocks	int8			NN
percentage_shared_mem_used	float8			NN
dirty_rowblocks	int8			NN
rowblocks_in_disk	int8			NN
rowblocks_in_s3	int8			NN

pg_catalog.stll_sub_transaction_commit_info

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
masterxid	int8			NN
xid	int8			NN
node	int4			NN
commitlevel	int4			NN
refreshtype	char(10)			NN
starttime	timestamp			NN
endtime	timestamp			NN

pg_catalog.stll_superblock_trickle_validation_summary

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
record_time	timestamp			NN
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_blocks_validated	int8			NN
log_entries_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
tree_trickle_validation_done	int4			NN
trickle_validation_done	int4			NN
num_steps_trickle_validation	int4			NN
log_rotation_done	int4			NN
num_steps_log_rotation	int4			NN

pg_catalog.stll_user_query_map

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
user_query_id	int8			NN
rewritten_query_id	int8			NN
transaction_id	int8			NN
process_id	int4			NN

pg_catalog.stll_wlm_multi_az_routing

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
pid	int4			NN
xid	int4			NN
query	int4			NN
service_class	int4			NN
recordtime	timestamp			NN
main_total_memory	int4			NN
main_used_memory	int4			NN
multi_az_total_memory	int4			NN
multi_az_used_memory	int4			NN
routing_threshold	int4			NN
routing_decision	int4			NN

pg_catalog.stv_cdc_connection

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
channel_id	char(128)			NN
channel_state	char(128)			NN
database_name	char(128)			NN
sharding_policy	char(128)			NN
latest_scanned_checkpoint	char(128)			NN
synced_binlog_coordinate	char(128)			NN
latest_applied_pe_checkpoint	char(128)			NN
lag_ms	int8			NN

pg_catalog.stv_integration

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

pg_catalog.stv_rowblock_manager_state

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int8			NN
total_rowblocks	int8			NN
total_mega_rowblocks	int8			NN
rowblocks_size_in_disk_cache	int8			NN
mega_rowblocks_size_in_disk_cache	int8			NN
rowblocks_size_in_disk	int8			NN
rowblocks_size_in_s3	int8			NN

pg_catalog.stv_tbl_column_slice_state

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
table_id	int4			NN
col	int4			NN
slice	int4			NN
num_blocks	int4			NN

pg_catalog.stv_tbl_perm_with_megavalues

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
slice	int4			NN
id	int4			NN
name	char(128)			NN
rows	int8			NN
sorted_rows	int8			NN
temp	int4			NN
db_id	int4			NN
insert_pristine	int4			NN
delete_pristine	int4			NN
backup	int4			NN
dist_style	int4			NN
block_count	int4			NN
partial_block_count	int4			NN

pg_internal.redshift_auto_health_check_2151487

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_aggr

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
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
slots	int4			NN
occupied	int4			NN
maxlength	int4			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
type	char(6)			NN
resizes	int4			NN
flushable	int4			NN
varchar_agg_opt	char(1)			NN
varagg_opt_bitmap	int8			NN
used_agg_prefetching	char(1)			NN
used_mega_block	char(1)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
slots	int4			NN
occupied	int4			NN
maxlength	int4			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
type	char(6)			NN
resizes	int4			NN
flushable	int4			NN
varchar_agg_opt	char(1)			NN
varagg_opt_bitmap	int8			NN
used_agg_prefetching	char(1)			NN
used_mega_block	char(1)			NN
num_flushes	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_arcadia_concurrency_scaling_usage

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	int8			NN
rewritten_qid	int4			NN
user_query_id	int8			NN
child_query_seq	int4			NN
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	int8			NN
endtime	int8			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
recordtime	int8			NN
rewritten_qid	int4			NN
user_query_id	int8			NN
child_query_seq	int4			NN
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	int8			NN
endtime	int8			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN
is_cs_at_query	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_auto_task_events

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

new
column	data type	PK	U	NN
actor_pid	int4			NN
task_type	char(100)			NN
task_state	char(50)			NN
priority	float8			NN
run_queries	int4			NN
pid	int4			NN
retry_count	int4			NN
production_time	int8			NN
max_execution_time_sec	int4			NN
event_time	int8			NN
message	char(300)			NN
task_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_burst_manager_refresh

old
column	data type	PK	U	NN
eventtime	int8			NN
action	char(50)			NN
type	char(20)			NN
pid	int8			NN
refresh_version	int8			NN
cluster_arn	char(100)			NN
error	char(350)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
eventtime	int8			NN
action	char(50)			NN
type	char(20)			NN
refresh_method	char(20)			NN
pid	int8			NN
refresh_version	int8			NN
cluster_arn	char(100)			NN
error	char(350)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

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

old
column	data type	PK	U	NN
commandtime	int8			NN
command	char(48)			NN
args	char(512)			NN
resultcode	int4			NN
errormsg	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
commandtime	int8			NN
command	char(48)			NN
args	char(512)			NN
resultcode	int4			NN
errormsg	char(512)			NN
endtime	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_diag

old
column	data type	PK	U	NN
now	int8			NN
node	int4			NN
slice	int4			NN
is_source	int4			NN
packet_count	int4			NN
duration_ms	int4			NN
bandwidth	float8			NN
config	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
now	int8			NN
node	int4			NN
slice	int4			NN
query	int4			NN
is_source	int4			NN
packet_count	int4			NN
duration_ms	int4			NN
bandwidth	float8			NN
config	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_concurrency_scaling_usage

old
column	data type	PK	U	NN
recordtime	int8			NN
query	int4			NN
cluster	char(128)			NN
starttime	int8			NN
endtime	int8			NN
request_id	char(36)			NN
incurred_usage_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
recordtime	int8			NN
query	int4			NN
cluster	char(128)			NN
starttime	int8			NN
endtime	int8			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
is_cs_at_query	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_dag_cleanup

old
column	data type	PK	U	NN
ending_xid	int8			NN
is_commit	int4			NN
timestamp	int8			NN
event	char(6)			NN
dag_verts	int8			NN
txn_set_size	int4			NN
lowest_added_xid	int8			NN
highest_added_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

new
column	data type	PK	U	NN
ending_xid	int8			NN
is_commit	int4			NN
timestamp	int8			NN
event	char(32)			NN
dag_verts	int8			NN
txn_set_size	int4			NN
lowest_added_xid	int8			NN
highest_added_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_disk_cache_write

old
column	data type	PK	U	NN
blocks_pushed	int4			NN
blocks_instant_pushed	int4			NN
avg_lru_size_before_push	int4			NN
push_attempts	int4			NN
pending_writes_push	int4			NN
pending_reads_push	int4			NN
blocks_written_back	int4			NN
writeback_preempts	int4			NN
avg_lru_size_before_writeback	int4			NN
writeback_attempts	int4			NN
pending_writes_writeback	int4			NN
pending_reads_writeback	int4			NN
avg_push_time_microsec	int8			NN
avg_writeback_time_microsec	int8			NN
sample_start_time	int8			NN
sample_end_time	int8			NN
node	int4			NN
rowsets_pushed	int4			NN
rowsets_instant_pushed	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
blocks_pushed	int4			NN
blocks_instant_pushed	int4			NN
avg_lru_size_before_push	int4			NN
push_attempts	int4			NN
pending_writes_push	int4			NN
pending_reads_push	int4			NN
blocks_written_back	int4			NN
writeback_preempts	int4			NN
avg_lru_size_before_writeback	int4			NN
writeback_attempts	int4			NN
pending_writes_writeback	int4			NN
pending_reads_writeback	int4			NN
avg_push_time_microsec	int8			NN
avg_writeback_time_microsec	int8			NN
sample_start_time	int8			NN
sample_end_time	int8			NN
node	int4			NN
rowsets_pushed	int4			NN
rowsets_instant_pushed	int4			NN
critical_writeback	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
est_peak_mem_needed	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
initial_query_time	int8			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
est_peak_mem_needed	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_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_lambda_client

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
request_id	char(100)			NN
function_name	char(100)			NN
recordtime	int8			NN
num_records	int4			NN
size	int4			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
node	int4			NN
slice	int4			NN
segment	int4			NN
request_id	char(100)			NN
function_name	char(100)			NN
recordtime	int8			NN
num_records	int4			NN
size	int4			NN
queue_id	int4			NN
batch_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_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
__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
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_query_memory

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
consumed_mem	int8			NN
reported_mem	int8			NN
wlm_working_mem	int8			NN
cheating_working_mem	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

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

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
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
mem_allowance_for_index	int8			NN
cheating_mem	int8			NN
index_predicted_size	int8			NN
index_size	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

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
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
mem_allowance_for_index	int8			NN
cheating_mem	int8			NN
index_predicted_size	int8			NN
index_size	int8			NN
insert_duration	int8			NN
build_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_services_control_metrics

old
column	data type	PK	U	NN
node	int4			NN
pid	int4			NN
step_starttime	int8			NN
step_endtime	int8			NN
script_action	char(128)			NN
phase	char(128)			NN
script_status	char(32)			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
node	int4			NN
pid	int4			NN
step_starttime	int8			NN
step_endtime	int8			NN
script_action	char(128)			NN
phase	char(128)			NN
script_status	char(32)			NN
restart_trace_id	char(64)			NN
restart_reason	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

pg_catalog.stcs_superblock_trickle_validation_stats

old
column	data type	PK	U	NN
node	int4			NN
record_time	int8			NN
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_entries_validated	int8			NN
log_blocks_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
trickle_validation_done	int4			NN
log_rotation	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
node	int4			NN
record_time	int8			NN
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_entries_validated	int8			NN
log_blocks_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
trickle_validation_done	int4			NN
log_rotation	int4			NN
was_tree_validated	int4			NN
tree_trickle_validation_done	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_unload_options

old
column	data type	PK	U	NN
query	int8			NN
row_count	int8			NN
format	int4			NN
authentication	int4			NN
compression_type	int4			NN
encryption_type	int4			NN
manifest	int4			NN
maxfilesize	int8			NN
cross_region	char(15)			NN
opt_delimiter	int4			NN
opt_fixedwidth	int4			NN
opt_addquotes	int4			NN
opt_null_as	int4			NN
opt_escape	int4			NN
opt_allowoverwrite	int4			NN
opt_parallel	int4			NN
is_header	int4			NN
num_part_col	int4			NN
opt_incld_part_col	int4			NN
is_write_ext_tbl	int4			NN
is_encrypted_auto	int4			NN
opt_cleanpath	int4			NN
rowgroupsize	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	int8			NN
row_count	int8			NN
format	int4			NN
authentication	int4			NN
compression_type	int4			NN
encryption_type	int4			NN
manifest	int4			NN
maxfilesize	int8			NN
cross_region	char(15)			NN
opt_delimiter	int4			NN
opt_fixedwidth	int4			NN
opt_addquotes	int4			NN
opt_null_as	int4			NN
opt_escape	int4			NN
opt_allowoverwrite	int4			NN
opt_parallel	int4			NN
is_header	int4			NN
num_part_col	int4			NN
opt_incld_part_col	int4			NN
is_write_ext_tbl	int4			NN
is_encrypted_auto	int4			NN
opt_cleanpath	int4			NN
rowgroupsize	int8			NN
extension	char(15)			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
__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
__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_xregion_metering

old
column	data type	PK	U	NN
eventtime	int8			NN
query	int8			NN
region	char(30)			NN
internal_request_uuid	char(36)			NN
metered_mbs	int8			NN
transferred_data	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
eventtime	int8			NN
query	int8			NN
region	char(30)			NN
internal_request_uuid	char(36)			NN
metered_mbs	int8			NN
transferred_data	int8			NN
billing_cluster_immutable_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

pg_catalog.stll_aggr

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
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
slots	int4			NN
occupied	int4			NN
maxlength	int4			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
type	char(6)			NN
resizes	int4			NN
flushable	int4			NN
varchar_agg_opt	char(1)			NN
varagg_opt_bitmap	int8			NN
used_agg_prefetching	char(1)			NN
used_mega_block	char(1)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
slots	int4			NN
occupied	int4			NN
maxlength	int4			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
type	char(6)			NN
resizes	int4			NN
flushable	int4			NN
varchar_agg_opt	char(1)			NN
varagg_opt_bitmap	int8			NN
used_agg_prefetching	char(1)			NN
used_mega_block	char(1)			NN
num_flushes	int4			NN

pg_catalog.stll_arcadia_concurrency_scaling_usage

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
rewritten_qid	int4			NN
user_query_id	int8			NN
child_query_seq	int4			NN
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
rewritten_qid	int4			NN
user_query_id	int8			NN
child_query_seq	int4			NN
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN
is_cs_at_query	int4			NN

pg_catalog.stll_auto_task_events

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

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

pg_catalog.stll_burst_manager_refresh

old
column	data type	PK	U	NN
eventtime	timestamp			NN
action	char(50)			NN
type	char(20)			NN
pid	int8			NN
refresh_version	int8			NN
cluster_arn	char(100)			NN
error	char(350)			NN

new
column	data type	PK	U	NN
eventtime	timestamp			NN
action	char(50)			NN
type	char(20)			NN
refresh_method	char(20)			NN
pid	int8			NN
refresh_version	int8			NN
cluster_arn	char(100)			NN
error	char(350)			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

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

pg_catalog.stll_command_result

old
column	data type	PK	U	NN
commandtime	timestamp			NN
command	char(48)			NN
args	char(512)			NN
resultcode	int4			NN
errormsg	char(512)			NN

new
column	data type	PK	U	NN
commandtime	timestamp			NN
command	char(48)			NN
args	char(512)			NN
resultcode	int4			NN
errormsg	char(512)			NN
endtime	timestamp			NN

pg_catalog.stll_comm_diag

old
column	data type	PK	U	NN
now	timestamp			NN
node	int4			NN
slice	int4			NN
is_source	int4			NN
packet_count	int4			NN
duration_ms	int4			NN
bandwidth	float8			NN
config	char(256)			NN

new
column	data type	PK	U	NN
now	timestamp			NN
node	int4			NN
slice	int4			NN
query	int4			NN
is_source	int4			NN
packet_count	int4			NN
duration_ms	int4			NN
bandwidth	float8			NN
config	char(256)			NN

pg_catalog.stll_concurrency_scaling_usage

old
column	data type	PK	U	NN
recordtime	timestamp			NN
query	int4			NN
cluster	char(128)			NN
starttime	timestamp			NN
endtime	timestamp			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN

new
column	data type	PK	U	NN
recordtime	timestamp			NN
query	int4			NN
cluster	char(128)			NN
starttime	timestamp			NN
endtime	timestamp			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
is_cs_at_query	int4			NN

pg_catalog.stll_dag_cleanup

old
column	data type	PK	U	NN
ending_xid	int8			NN
is_commit	int4			NN
timestamp	timestamp			NN
event	char(6)			NN
dag_verts	int8			NN
txn_set_size	int4			NN
lowest_added_xid	int8			NN
highest_added_xid	int8			NN

new
column	data type	PK	U	NN
ending_xid	int8			NN
is_commit	int4			NN
timestamp	timestamp			NN
event	char(32)			NN
dag_verts	int8			NN
txn_set_size	int4			NN
lowest_added_xid	int8			NN
highest_added_xid	int8			NN

pg_catalog.stll_disk_cache_write

old
column	data type	PK	U	NN
blocks_pushed	int4			NN
blocks_instant_pushed	int4			NN
avg_lru_size_before_push	int4			NN
push_attempts	int4			NN
pending_writes_push	int4			NN
pending_reads_push	int4			NN
blocks_written_back	int4			NN
writeback_preempts	int4			NN
avg_lru_size_before_writeback	int4			NN
writeback_attempts	int4			NN
pending_writes_writeback	int4			NN
pending_reads_writeback	int4			NN
avg_push_time_microsec	int8			NN
avg_writeback_time_microsec	int8			NN
sample_start_time	timestamp			NN
sample_end_time	timestamp			NN
node	int4			NN
rowsets_pushed	int4			NN
rowsets_instant_pushed	int4			NN

new
column	data type	PK	U	NN
blocks_pushed	int4			NN
blocks_instant_pushed	int4			NN
avg_lru_size_before_push	int4			NN
push_attempts	int4			NN
pending_writes_push	int4			NN
pending_reads_push	int4			NN
blocks_written_back	int4			NN
writeback_preempts	int4			NN
avg_lru_size_before_writeback	int4			NN
writeback_attempts	int4			NN
pending_writes_writeback	int4			NN
pending_reads_writeback	int4			NN
avg_push_time_microsec	int8			NN
avg_writeback_time_microsec	int8			NN
sample_start_time	timestamp			NN
sample_end_time	timestamp			NN
node	int4			NN
rowsets_pushed	int4			NN
rowsets_instant_pushed	int4			NN
critical_writeback	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
est_peak_mem_needed	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN

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

pg_catalog.stll_lambda_client

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
request_id	char(100)			NN
function_name	char(100)			NN
recordtime	timestamp			NN
num_records	int4			NN
size	int4			NN
queue_id	int4			NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
request_id	char(100)			NN
function_name	char(100)			NN
recordtime	timestamp			NN
num_records	int4			NN
size	int4			NN
queue_id	int4			NN
batch_version	int4			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

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

pg_catalog.stll_query_memory

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
consumed_mem	int8			NN
reported_mem	int8			NN
wlm_working_mem	int8			NN
cheating_working_mem	int8			NN

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

pg_catalog.stll_rtree

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
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
mem_allowance_for_index	int8			NN
cheating_mem	int8			NN
index_predicted_size	int8			NN
index_size	int8			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
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
mem_allowance_for_index	int8			NN
cheating_mem	int8			NN
index_predicted_size	int8			NN
index_size	int8			NN
insert_duration	int8			NN
build_duration	int8			NN

pg_catalog.stll_services_control_metrics

old
column	data type	PK	U	NN
node	int4			NN
pid	int4			NN
step_starttime	timestamp			NN
step_endtime	timestamp			NN
script_action	char(128)			NN
phase	char(128)			NN
script_status	char(32)			NN
restart_trace_id	char(64)			NN

new
column	data type	PK	U	NN
node	int4			NN
pid	int4			NN
step_starttime	timestamp			NN
step_endtime	timestamp			NN
script_action	char(128)			NN
phase	char(128)			NN
script_status	char(32)			NN
restart_trace_id	char(64)			NN
restart_reason	char(64)			NN

pg_catalog.stll_superblock_trickle_validation_stats

old
column	data type	PK	U	NN
node	int4			NN
record_time	timestamp			NN
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_entries_validated	int8			NN
log_blocks_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
trickle_validation_done	int4			NN
log_rotation	int4			NN

new
column	data type	PK	U	NN
node	int4			NN
record_time	timestamp			NN
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_entries_validated	int8			NN
log_blocks_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
trickle_validation_done	int4			NN
log_rotation	int4			NN
was_tree_validated	int4			NN
tree_trickle_validation_done	int4			NN

pg_catalog.stll_unload_options

old
column	data type	PK	U	NN
query	int8			NN
row_count	int8			NN
format	int4			NN
authentication	int4			NN
compression_type	int4			NN
encryption_type	int4			NN
manifest	int4			NN
maxfilesize	int8			NN
cross_region	char(15)			NN
opt_delimiter	int4			NN
opt_fixedwidth	int4			NN
opt_addquotes	int4			NN
opt_null_as	int4			NN
opt_escape	int4			NN
opt_allowoverwrite	int4			NN
opt_parallel	int4			NN
is_header	int4			NN
num_part_col	int4			NN
opt_incld_part_col	int4			NN
is_write_ext_tbl	int4			NN
is_encrypted_auto	int4			NN
opt_cleanpath	int4			NN
rowgroupsize	int8			NN

new
column	data type	PK	U	NN
query	int8			NN
row_count	int8			NN
format	int4			NN
authentication	int4			NN
compression_type	int4			NN
encryption_type	int4			NN
manifest	int4			NN
maxfilesize	int8			NN
cross_region	char(15)			NN
opt_delimiter	int4			NN
opt_fixedwidth	int4			NN
opt_addquotes	int4			NN
opt_null_as	int4			NN
opt_escape	int4			NN
opt_allowoverwrite	int4			NN
opt_parallel	int4			NN
is_header	int4			NN
num_part_col	int4			NN
opt_incld_part_col	int4			NN
is_write_ext_tbl	int4			NN
is_encrypted_auto	int4			NN
opt_cleanpath	int4			NN
rowgroupsize	int8			NN
extension	char(15)			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

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

pg_catalog.stll_xregion_metering

old
column	data type	PK	U	NN
eventtime	timestamp			NN
query	int8			NN
region	char(30)			NN
internal_request_uuid	char(36)			NN
metered_mbs	int8			NN
transferred_data	int8			NN

new
column	data type	PK	U	NN
eventtime	timestamp			NN
query	int8			NN
region	char(30)			NN
internal_request_uuid	char(36)			NN
metered_mbs	int8			NN
transferred_data	int8			NN
billing_cluster_immutable_id	char(64)			NN

pg_catalog.stv_burst_manager_cluster_info

old
column	data type	PK	U	NN
cluster_arn	char(120)			NN
num_sessions	int4			NN
max_sessions	int4			NN
backup_version	int8			NN
backup_id	char(100)			NN
last_heartbeat_check	timestamp			NN
last_used	timestamp			NN
idle_counter	int4			NN
active_pids	char(40)			NN
personalized	int4			NN
gateway_errors	int4			NN
credentials_errors	int4			NN
refresh_backup_version	int8			NN
refresh_backup_id	char(100)			NN
refresh_start_time	timestamp			NN

new
column	data type	PK	U	NN
cluster_arn	char(120)			NN
num_sessions	int4			NN
max_sessions	int4			NN
backup_version	int8			NN
backup_id	char(100)			NN
last_heartbeat_check	timestamp			NN
last_used	timestamp			NN
idle_counter	int4			NN
active_pids	char(256)			NN
personalized	int4			NN
gateway_errors	int4			NN
credentials_errors	int4			NN
refresh_backup_version	int8			NN
refresh_backup_id	char(100)			NN
refresh_start_time	timestamp			NN
has_limited_sessions	int4			NN
total_memory	int8			NN
used_memory	int8			NN
multi_az	int4			NN

pg_catalog.stv_ml_model_info

old
column	data type	PK	U	NN
schema_name	char(128)			NN
user_name	char(128)			NN
model_name	char(128)			NN
life_cycle	char(20)			NN
is_refreshable	int4			NN
model_state	char(128)			NN

new
column	data type	PK	U	NN
schema_name	char(128)			NN
user_name	char(128)			NN
model_name	char(128)			NN
life_cycle	char(20)			NN
is_refreshable	int4			NN
model_state	char(128)			NN
database_name	char(128)			NN

pg_catalog.stv_mv_deps

old
column	data type	PK	U	NN
db_name	char(128)			NN
schema	char(128)			NN
name	char(128)			NN
ref_schema	char(128)			NN
ref_name	char(128)			NN

new
column	data type	PK	U	NN
db_name	char(128)			NN
schema	char(128)			NN
name	char(128)			NN
ref_schema	char(128)			NN
ref_name	char(128)			NN
ref_database_name	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

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

pg_internal.redshift_auto_health_check_2009981

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_alter_dist_catalog_change_events

old
column	data type

new
column	data type
xid	int8
pid	int4
tbl	int4
eventtime	timestamp
event	char(128)
prev_distkey	int4

pg_catalog.stl_cdc_connection

old
column	data type

new
column	data type
record_time	timestamp
channel_id	char(128)
message	char(256)

pg_catalog.stl_datashare_query_info

old
column	data type

new
column	data type
userid	int4
leaderpid	int4
xid	int8
query	int4
table_id	int4
current_dml_version	int8
current_sructure_version	int8
current_sb_version	int8
current_ddl_version	int8
target_dml_version	int8
target_structure_version	int8
target_sb_version	int8
target_ddl_version	int8
leader_node_start_time	timestamp
leader_node_end_time	timestamp
node	int4
compute_node_start_time	timestamp
compute_node_end_time	timestamp
refresh_queue_start_time	timestamp
refresh_queue_end_time	timestamp
sb_download_grafting_start_time	timestamp
sb_download_grafting_end_time	timestamp
total_sb_download_seconds	float8
total_sb_batches	int4
changed_headers	int8
table_grafting_mode	char(16)
sb_download_mode	char(16)

pg_catalog.stl_integration_log

old
column	data type

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

pg_catalog.stl_rowblock_manager_stats

old
column	data type

new
column	data type
logtime	timestamp
node	int8
total_rowblocks	int8
total_mega_rowblocks	int8
max_rowblock_manager_size	int8
min_rowblock_manager_size	int8
max_rowblock_size	int8
min_rowblock_size	int8
added_rowblocks	int8
added_mega_rowblocks	int8
tossed_rowblocks	int8
mega_rowblocks_writes	int8
mega_rowblocks_reads	int8
rowblocks_in_disk_cache	int8
num_megarowblocks_in_disk_cache	int8
mega_rowblocks_in_disk_cache	int8
pinned_rowblocks	int8
percentage_shared_mem_used	float8
dirty_rowblocks	int8
rowblocks_in_disk	int8
rowblocks_in_s3	int8

pg_catalog.stl_sub_transaction_commit_info

old
column	data type

new
column	data type
masterxid	int8
xid	int8
node	int4
commitlevel	int4
refreshtype	char(10)
starttime	timestamp
endtime	timestamp

pg_catalog.stl_superblock_trickle_validation_summary

old
column	data type

new
column	data type
node	int4
record_time	timestamp
snapshot_sb_version	int8
snapshot_sb_num_blocks	int8
log_blocks_validated	int8
log_entries_validated	int8
tree_based_sb_mode	int4
tree_entries_validated	int8
tree_trickle_validation_done	int4
trickle_validation_done	int4
num_steps_trickle_validation	int4
log_rotation_done	int4
num_steps_log_rotation	int4

pg_catalog.stl_user_query_map

old
column	data type

new
column	data type
user_id	int4
user_query_id	int8
rewritten_query_id	int8
transaction_id	int8
process_id	int4

pg_catalog.stl_wlm_multi_az_routing

old
column	data type

new
column	data type
pid	int4
xid	int4
query	int4
service_class	int4
recordtime	timestamp
main_total_memory	int4
main_used_memory	int4
multi_az_total_memory	int4
multi_az_used_memory	int4
routing_threshold	int4
routing_decision	int4

pg_catalog.svv_attached_masking_policy

old
column	data type

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

pg_catalog.svv_integration

old
column	data type

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)

pg_catalog.svv_masking_policy

old
column	data type

new
column	data type
policy_database	varchar(128)
policy_name	varchar(128)
input_columns	varchar(256)
policy_expression	varchar(256)
policy_modified_by	varchar(128)
policy_modified_time	timestamp

pg_catalog.svv_ml_model_info

old
column	data type

new
column	data type
database_name	char(128)
schema_name	char(128)
user_name	char(128)
model_name	char(128)
life_cycle	char(20)
is_refreshable	int4
model_state	char(128)

pg_catalog.svv_mv_dependency

old
column	data type

new
column	data type
database_name	char(128)
schema_name	char(128)
name	char(128)
dependent_database_name	char(128)
dependent_schema_name	char(128)
dependent_name	char(128)

pg_catalog.sys_integration_activity

old
column	data type

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	int4
modified_tables	int4
integration_start_time	int4
integration_end_time	timestamp

pg_catalog.sys_load_detail

old
column	data type

new
column	data type
user_id	int4
query_id	int8
file_name	char(256)
bytes_scanned	int4
lines_scanned	int4
record_time	timestamp

pg_catalog.sys_spectrum_scan_error

old
column	data type

new
column	data type
userid	int4
query	int8
location	char(256)
rowid	char(2100)
colname	char(127)
original_value	char(1024)
modified_value	char(1024)
trigger	text
action	text
action_value	char(127)
error_code	int4

pg_catalog.stl_aggr

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
slots	int4
occupied	int4
maxlength	int4
tbl	int4
is_diskbased	char(1)
workmem	int8
type	char(6)
resizes	int4
flushable	int4
varchar_agg_opt	char(1)
varagg_opt_bitmap	int8
used_agg_prefetching	char(1)
used_mega_block	char(1)

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
slots	int4
occupied	int4
maxlength	int4
tbl	int4
is_diskbased	char(1)
workmem	int8
type	char(6)
resizes	int4
flushable	int4
varchar_agg_opt	char(1)
varagg_opt_bitmap	int8
used_agg_prefetching	char(1)
used_mega_block	char(1)
num_flushes	int4

pg_catalog.stl_arcadia_concurrency_scaling_usage

old
column	data type
userid	int4
recordtime	timestamp
rewritten_qid	int4
user_query_id	int8
child_query_seq	int4
cluster	char(128)
report_arn	char(128)
instance_type	char(128)
num_nodes	int4
starttime	timestamp
endtime	timestamp
request_id	char(36)
incurred_usage_ms	int4
incurred_usage_rpu_ms	int4
rpu	int4

new
column	data type
userid	int4
recordtime	timestamp
rewritten_qid	int4
user_query_id	int8
child_query_seq	int4
cluster	char(128)
report_arn	char(128)
instance_type	char(128)
num_nodes	int4
starttime	timestamp
endtime	timestamp
request_id	char(36)
incurred_usage_ms	int4
incurred_usage_rpu_ms	int4
rpu	int4
is_cs_at_query	int4

pg_catalog.stl_auto_task_events

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

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

pg_catalog.stl_burst_manager_refresh

old
column	data type
eventtime	timestamp
action	char(50)
type	char(20)
pid	int8
refresh_version	int8
cluster_arn	char(100)
error	char(350)

new
column	data type
eventtime	timestamp
action	char(50)
type	char(20)
refresh_method	char(20)
pid	int8
refresh_version	int8
cluster_arn	char(100)
error	char(350)

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)

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

pg_catalog.stl_command_result

old
column	data type
commandtime	timestamp
command	char(48)
args	char(512)
resultcode	int4
errormsg	char(512)

new
column	data type
commandtime	timestamp
command	char(48)
args	char(512)
resultcode	int4
errormsg	char(512)
endtime	timestamp

pg_catalog.stl_comm_diag

old
column	data type
now	timestamp
node	int4
slice	int4
is_source	int4
packet_count	int4
duration_ms	int4
bandwidth	float8
config	char(256)

new
column	data type
now	timestamp
node	int4
slice	int4
query	int4
is_source	int4
packet_count	int4
duration_ms	int4
bandwidth	float8
config	char(256)

pg_catalog.stl_concurrency_scaling_usage

old
column	data type
recordtime	timestamp
query	int4
cluster	char(128)
starttime	timestamp
endtime	timestamp
request_id	char(36)
incurred_usage_ms	int4

new
column	data type
recordtime	timestamp
query	int4
cluster	char(128)
starttime	timestamp
endtime	timestamp
request_id	char(36)
incurred_usage_ms	int4
is_cs_at_query	int4

pg_catalog.stl_dag_cleanup

old
column	data type
ending_xid	int8
is_commit	int4
timestamp	timestamp
event	char(6)
dag_verts	int8
txn_set_size	int4
lowest_added_xid	int8
highest_added_xid	int8

new
column	data type
ending_xid	int8
is_commit	int4
timestamp	timestamp
event	char(32)
dag_verts	int8
txn_set_size	int4
lowest_added_xid	int8
highest_added_xid	int8

pg_catalog.stl_disk_cache_write

old
column	data type
blocks_pushed	int4
blocks_instant_pushed	int4
avg_lru_size_before_push	int4
push_attempts	int4
pending_writes_push	int4
pending_reads_push	int4
blocks_written_back	int4
writeback_preempts	int4
avg_lru_size_before_writeback	int4
writeback_attempts	int4
pending_writes_writeback	int4
pending_reads_writeback	int4
avg_push_time_microsec	int8
avg_writeback_time_microsec	int8
sample_start_time	timestamp
sample_end_time	timestamp
node	int4
rowsets_pushed	int4
rowsets_instant_pushed	int4

new
column	data type
blocks_pushed	int4
blocks_instant_pushed	int4
avg_lru_size_before_push	int4
push_attempts	int4
pending_writes_push	int4
pending_reads_push	int4
blocks_written_back	int4
writeback_preempts	int4
avg_lru_size_before_writeback	int4
writeback_attempts	int4
pending_writes_writeback	int4
pending_reads_writeback	int4
avg_push_time_microsec	int8
avg_writeback_time_microsec	int8
sample_start_time	timestamp
sample_end_time	timestamp
node	int4
rowsets_pushed	int4
rowsets_instant_pushed	int4
critical_writeback	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
est_peak_mem_needed	int8
wlm_query_memory	int8
datasharing_tables_accessed	int4
uses_new_cost_model	char(1)
new_model_reason	int4
num_rowsets	int4
xregion_datasharing_tables_accessed	int4
result_cache_miss_reason	int4
cs_node_nums	int4
is_multi	int4

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

pg_catalog.stl_lambda_client

old
column	data type
query	int4
node	int4
slice	int4
segment	int4
request_id	char(100)
function_name	char(100)
recordtime	timestamp
num_records	int4
size	int4
queue_id	int4

new
column	data type
query	int4
node	int4
slice	int4
segment	int4
request_id	char(100)
function_name	char(100)
recordtime	timestamp
num_records	int4
size	int4
queue_id	int4
batch_version	int4

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)

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

pg_catalog.stl_query_memory

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
consumed_mem	int8
reported_mem	int8
wlm_working_mem	int8
cheating_working_mem	int8

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

pg_catalog.stl_rtree

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
tbl	int4
is_diskbased	char(1)
workmem	int8
mem_allowance_for_index	int8
cheating_mem	int8
index_predicted_size	int8
index_size	int8

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
tbl	int4
is_diskbased	char(1)
workmem	int8
mem_allowance_for_index	int8
cheating_mem	int8
index_predicted_size	int8
index_size	int8
insert_duration	int8
build_duration	int8

pg_catalog.stl_services_control_metrics

old
column	data type
node	int4
pid	int4
step_starttime	timestamp
step_endtime	timestamp
script_action	char(128)
phase	char(128)
script_status	char(32)
restart_trace_id	char(64)

new
column	data type
node	int4
pid	int4
step_starttime	timestamp
step_endtime	timestamp
script_action	char(128)
phase	char(128)
script_status	char(32)
restart_trace_id	char(64)
restart_reason	char(64)

pg_catalog.stl_superblock_trickle_validation_stats

old
column	data type
node	int4
record_time	timestamp
snapshot_sb_version	int8
snapshot_sb_num_blocks	int8
log_entries_validated	int8
log_blocks_validated	int8
tree_based_sb_mode	int4
tree_entries_validated	int8
trickle_validation_done	int4
log_rotation	int4

new
column	data type
node	int4
record_time	timestamp
snapshot_sb_version	int8
snapshot_sb_num_blocks	int8
log_entries_validated	int8
log_blocks_validated	int8
tree_based_sb_mode	int4
tree_entries_validated	int8
trickle_validation_done	int4
log_rotation	int4
was_tree_validated	int4
tree_trickle_validation_done	int4

pg_catalog.stl_unload_options

old
column	data type
query	int8
row_count	int8
format	int4
authentication	int4
compression_type	int4
encryption_type	int4
manifest	int4
maxfilesize	int8
cross_region	char(15)
opt_delimiter	int4
opt_fixedwidth	int4
opt_addquotes	int4
opt_null_as	int4
opt_escape	int4
opt_allowoverwrite	int4
opt_parallel	int4
is_header	int4
num_part_col	int4
opt_incld_part_col	int4
is_write_ext_tbl	int4
is_encrypted_auto	int4
opt_cleanpath	int4
rowgroupsize	int8

new
column	data type
query	int8
row_count	int8
format	int4
authentication	int4
compression_type	int4
encryption_type	int4
manifest	int4
maxfilesize	int8
cross_region	char(15)
opt_delimiter	int4
opt_fixedwidth	int4
opt_addquotes	int4
opt_null_as	int4
opt_escape	int4
opt_allowoverwrite	int4
opt_parallel	int4
is_header	int4
num_part_col	int4
opt_incld_part_col	int4
is_write_ext_tbl	int4
is_encrypted_auto	int4
opt_cleanpath	int4
rowgroupsize	int8
extension	char(15)

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)

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

pg_catalog.stl_xregion_metering

old
column	data type
eventtime	timestamp
query	int8
region	char(30)
internal_request_uuid	char(36)
metered_mbs	int8
transferred_data	int8

new
column	data type
eventtime	timestamp
query	int8
region	char(30)
internal_request_uuid	char(36)
metered_mbs	int8
transferred_data	int8
billing_cluster_immutable_id	char(64)

pg_catalog.svcs_rtree

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
tbl	int4
workmem	int8
is_diskbased	char(1)
mem_allowance_for_index	int8
cheating_mem	int8
index_predicted_size	int8
index_size	int8

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
tbl	int4
workmem	int8
is_diskbased	char(1)
mem_allowance_for_index	int8
cheating_mem	int8
index_predicted_size	int8
index_size	int8
insert_duration	int8
build_duration	int8

pg_catalog.svv_external_databases

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

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

pg_catalog.svv_rls_relation

old
column	data type
datname	varchar(128)
relschema	varchar(128)
relname	varchar(128)
relkind	varchar(17)
is_rls_on	char(1)

new
column	data type
datname	varchar(128)
relschema	varchar(128)
relname	varchar(128)
relkind	varchar(17)
is_rls_on	char(1)
is_rls_datashare_on	char(1)

pg_catalog.sys_external_query_detail

old
column	data type
user_id	int4
query_id	int8
transaction_id	int8
child_query_sequence	int4
segment_id	int4
source_type	char(32)
start_time	timestamp
end_time	timestamp
duration	int8
total_partitions	int4
qualified_partitions	int4
scanned_files	int8
returned_rows	int8
returned_bytes	int8
file_format	text
file_location	text
external_query_text	text
warning_message	char(4000)

new
column	data type
user_id	int4
query_id	int8
transaction_id	int8
child_query_sequence	int4
segment_id	int4
source_type	char(32)
start_time	timestamp
end_time	timestamp
duration	int8
total_partitions	int4
qualified_partitions	int4
scanned_files	int8
returned_rows	int8
returned_bytes	int8
file_format	text
file_location	text
external_query_text	text
warning_message	char(4000)
table_name	text

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	text
table_id	int4
table_name	char(136)
is_rrscan	char(1)
start_time	timestamp
end_time	timestamp
duration	int8
alert	text
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

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	text
table_id	int4
table_name	text
is_rrscan	text
start_time	timestamp
end_time	timestamp
duration	int8
alert	text
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	text
data_skewness	int4
time_skewness	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)

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