Redshift Observatory System Table Tracker

Functions

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

Tables

pg_internal.redshift_auto_health_check_1027271

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

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

pg_catalog.stcs_dag_cleanup

old
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

new
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

pg_catalog.stcs_disk_cache_megablock_stats

old
column	data type	PK	U	NN
logtime	int8			NN
node	int4			NN
adds	int8			NN
faults	int8			NN
pins	int8			NN
thrashed_blocks	int8			NN
evictions	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
logtime	int8			NN
node	int4			NN
adds	int8			NN
new_blocks	int8			NN
dbr_blocks	int8			NN
faults	int8			NN
pins	int8			NN
thrashed_blocks	int8			NN
evictions	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stll_auto_task_events

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

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

pg_catalog.stll_dag_cleanup

old
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

new
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

pg_catalog.stll_disk_cache_megablock_stats

old
column	data type	PK	U	NN
logtime	timestamp			NN
node	int4			NN
adds	int8			NN
faults	int8			NN
pins	int8			NN
thrashed_blocks	int8			NN
evictions	int8			NN

new
column	data type	PK	U	NN
logtime	timestamp			NN
node	int4			NN
adds	int8			NN
new_blocks	int8			NN
dbr_blocks	int8			NN
faults	int8			NN
pins	int8			NN
thrashed_blocks	int8			NN
evictions	int8			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(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

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

pg_catalog.pg_auto_copy_history

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

new
column	data type	PK	U	NN

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

new
column	data type	PK	U	NN

pg_catalog.pg_external_object

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

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

pg_catalog.stcs_alter_dist_catalog_change_events

old
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

new
column	data type	PK	U	NN

pg_catalog.stcs_cdc_connection

old
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

new
column	data type	PK	U	NN

pg_catalog.stcs_datashare_query_info

old
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

new
column	data type	PK	U	NN

pg_catalog.stcs_integration_log

old
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
status	char(128)			NN
database_name	char(128)			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
synced_log_coordinate	char(128)			NN
num_modified_tables	int4			NN
lag_ms	int8			NN
checkpoint_bytes	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_rowblock_manager_stats

old
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

new
column	data type	PK	U	NN

pg_catalog.stcs_sub_transaction_commit_info

old
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

new
column	data type	PK	U	NN

pg_catalog.stcs_superblock_trickle_validation_summary

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

new
column	data type	PK	U	NN

pg_catalog.stcs_user_query_map

old
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

new
column	data type	PK	U	NN

pg_catalog.stcs_wlm_multi_az_routing

old
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

new
column	data type	PK	U	NN

pg_catalog.stll_alter_dist_catalog_change_events

old
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

new
column	data type	PK	U	NN

pg_catalog.stll_cdc_connection

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

new
column	data type	PK	U	NN

pg_catalog.stll_datashare_query_info

old
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

new
column	data type	PK	U	NN

pg_catalog.stll_integration_log

old
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
status	char(128)			NN
database_name	char(128)			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
synced_log_coordinate	char(128)			NN
num_modified_tables	int4			NN
lag_ms	int8			NN
checkpoint_bytes	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_rowblock_manager_stats

old
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

new
column	data type	PK	U	NN

pg_catalog.stll_sub_transaction_commit_info

old
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

new
column	data type	PK	U	NN

pg_catalog.stll_superblock_trickle_validation_summary

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

new
column	data type	PK	U	NN

pg_catalog.stll_user_query_map

old
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

new
column	data type	PK	U	NN

pg_catalog.stll_wlm_multi_az_routing

old
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

new
column	data type	PK	U	NN

pg_catalog.stv_cdc_connection

old
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

new
column	data type	PK	U	NN

pg_catalog.stv_integration

old
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
database_name	char(128)			NN
synced_log_coordinate	char(128)			NN
lag_ms	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stv_rowblock_manager_state

old
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

new
column	data type	PK	U	NN

pg_catalog.stv_tbl_column_slice_state

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

new
column	data type	PK	U	NN

pg_catalog.stv_tbl_perm_with_megavalues

old
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

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_2151487

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

new
column	data type	PK	U	NN

Views

pg_catalog.stl_auto_task_events

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

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

pg_catalog.stl_dag_cleanup

old
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

new
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

pg_catalog.stl_disk_cache_megablock_stats

old
column	data type
logtime	timestamp
node	int4
adds	int8
faults	int8
pins	int8
thrashed_blocks	int8
evictions	int8

new
column	data type
logtime	timestamp
node	int4
adds	int8
new_blocks	int8
dbr_blocks	int8
faults	int8
pins	int8
thrashed_blocks	int8
evictions	int8

pg_catalog.svv_external_databases

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

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

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

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

pg_catalog.stl_alter_dist_catalog_change_events

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

new
column	data type

pg_catalog.stl_cdc_connection

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

new
column	data type

pg_catalog.stl_datashare_query_info

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

new
column	data type

pg_catalog.stl_integration_log

old
column	data type
record_time	timestamp
integration_id	char(128)
integration_type	char(128)
state	char(128)
status	char(128)
database_name	char(128)
checkpoint_name	char(128)
checkpoint_type	char(16)
synced_log_coordinate	char(128)
num_modified_tables	int4
lag_ms	int8
checkpoint_bytes	int8

new
column	data type

pg_catalog.stl_rowblock_manager_stats

old
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

new
column	data type

pg_catalog.stl_sub_transaction_commit_info

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

new
column	data type

pg_catalog.stl_superblock_trickle_validation_summary

old
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

new
column	data type

pg_catalog.stl_user_query_map

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

new
column	data type

pg_catalog.stl_wlm_multi_az_routing

old
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

new
column	data type

pg_catalog.svv_attached_masking_policy

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

new
column	data type

pg_catalog.svv_integration

old
column	data type
integration_id	char(128)
target_database	char(128)
source	char(128)
state	char(128)
current_lag	int8
last_replicated_checkpoint	char(128)

new
column	data type

pg_catalog.svv_masking_policy

old
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

new
column	data type

pg_catalog.svv_ml_model_info

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

new
column	data type

pg_catalog.svv_mv_dependency

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

new
column	data type

pg_catalog.sys_integration_activity

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

new
column	data type

pg_catalog.sys_load_detail

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

new
column	data type

pg_catalog.sys_spectrum_scan_error

old
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

new
column	data type