Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
dropped	pg_catalog	internal	immutable	bool	is_seclog_downgrade_enabled	None
dropped	pg_catalog	internal	immutable	super	lower_attribute_names	super
dropped	pg_catalog	internal	immutable	super	upper_attribute_names	super
dropped	pg_catalog	internal	volatile	int8	last_num_sorted_rows_user_columns	int8

Tables

pg_internal.redshift_auto_health_check_5665089

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_comm_pkt_oob_count

old
column	data type	PK	U	NN
now	int8			NN
since	int8			NN
node	int4			NN
channel_type	int4			NN
bad_guid	int4			NN
no_channel	int4			NN
bad_src	int4			NN
bad_dst	int4			NN
bad_cmd	int4			NN
bad_crc	int4			NN
excess_ack	int4			NN
low_seqnum	int4			NN
high_seqnum	int4			NN
early_xon	int4			NN
lost_packet	int4			NN
reorder_packet	int4			NN
likely_lost_ack	int4			NN
extreme_delay	int4			NN
in_rob	int4			NN
excess_fast_rexmit	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
now	int8			NN
since	int8			NN
node	int4			NN
is_raidp	int4			NN
bad_guid	int4			NN
no_channel	int4			NN
bad_src	int4			NN
bad_dst	int4			NN
bad_cmd	int4			NN
bad_crc	int4			NN
excess_ack	int4			NN
low_seqnum	int4			NN
high_seqnum	int4			NN
early_xon	int4			NN
lost_packet	int4			NN
reorder_packet	int4			NN
likely_lost_ack	int4			NN
extreme_delay	int4			NN
in_rob	int4			NN
excess_fast_rexmit	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_comm_pkt_sent_count

old
column	data type	PK	U	NN
now	int8			NN
since	int8			NN
src_node	int4			NN
dest_node	int4			NN
channel_type	int4			NN
bytes	int8			NN
rexmit	int4			NN
xon	int4			NN
reply	int4			NN
ack	int4			NN
packet	int4			NN
fast_rexmit	int4			NN
original_ack	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
now	int8			NN
since	int8			NN
src_node	int4			NN
dest_node	int4			NN
is_raidp	int4			NN
bytes	int8			NN
rexmit	int4			NN
xon	int4			NN
reply	int4			NN
ack	int4			NN
packet	int4			NN
fast_rexmit	int4			NN
original_ack	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_comm_pkt_oob_count

old
column	data type	PK	U	NN
now	timestamp			NN
since	timestamp			NN
node	int4			NN
channel_type	int4			NN
bad_guid	int4			NN
no_channel	int4			NN
bad_src	int4			NN
bad_dst	int4			NN
bad_cmd	int4			NN
bad_crc	int4			NN
excess_ack	int4			NN
low_seqnum	int4			NN
high_seqnum	int4			NN
early_xon	int4			NN
lost_packet	int4			NN
reorder_packet	int4			NN
likely_lost_ack	int4			NN
extreme_delay	int4			NN
in_rob	int4			NN
excess_fast_rexmit	int4			NN

new
column	data type	PK	U	NN
now	timestamp			NN
since	timestamp			NN
node	int4			NN
is_raidp	int4			NN
bad_guid	int4			NN
no_channel	int4			NN
bad_src	int4			NN
bad_dst	int4			NN
bad_cmd	int4			NN
bad_crc	int4			NN
excess_ack	int4			NN
low_seqnum	int4			NN
high_seqnum	int4			NN
early_xon	int4			NN
lost_packet	int4			NN
reorder_packet	int4			NN
likely_lost_ack	int4			NN
extreme_delay	int4			NN
in_rob	int4			NN
excess_fast_rexmit	int4			NN

pg_catalog.stll_comm_pkt_sent_count

old
column	data type	PK	U	NN
now	timestamp			NN
since	timestamp			NN
src_node	int4			NN
dest_node	int4			NN
channel_type	int4			NN
bytes	int8			NN
rexmit	int4			NN
xon	int4			NN
reply	int4			NN
ack	int4			NN
packet	int4			NN
fast_rexmit	int4			NN
original_ack	int4			NN

new
column	data type	PK	U	NN
now	timestamp			NN
since	timestamp			NN
src_node	int4			NN
dest_node	int4			NN
is_raidp	int4			NN
bytes	int8			NN
rexmit	int4			NN
xon	int4			NN
reply	int4			NN
ack	int4			NN
packet	int4			NN
fast_rexmit	int4			NN
original_ack	int4			NN

pg_catalog.stcs_applied_masking_policy

old
column	data type	PK	U	NN
polid	int4			NN
user_id	int4			NN
record_time	int8			NN
pid	int4			NN
xid	int8			NN
query_id	int8			NN
dbid	int4			NN
relid	int4			NN
relation_kind	char(30)			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_async_rerep_worker_stats

old
column	data type	PK	U	NN
logtime	int8			NN
node_num	int4			NN
issued_rerep_reads	int8			NN
issued_rerep_writes	int8			NN
issued_dirty_writes	int8			NN
completed_rerep_reads	int8			NN
completed_rerep_writes	int8			NN
completed_dirty_writes	int8			NN
ignored_rerep_reads	int8			NN
ignored_rerep_writes	int8			NN
ignored_dirty_writes	int8			NN
rerep_pool_exhausted	int8			NN
ignored_comp_table_not_in_active_set	int8			NN
ignored_comp_block_state_changed	int8			NN
ignored_comp_block_pinned_during_write	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_auto_task_cost_benefit

old
column	data type	PK	U	NN
task_type	char(100)			NN
estimation_type	char(50)			NN
estimation_in_seconds	float8			NN
real_val_in_seconds	float8			NN
event_time	int8			NN
task_id	int8			NN
task_target	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_burst_user_temp_table_stats

old
column	data type	PK	U	NN
recordtime	int8			NN
xid	int8			NN
query	int8			NN
query_priority	int4			NN
total_blocks	int8			NN
blocks_not_in_s3	int8			NN
num_temp_tables	int4			NN
block_replication_start_time	int8			NN
block_replication_end_time	int8			NN
metadata_serialize_duration_main_ms	float8			NN
metadata_deserialize_duration_burst_ms	float8			NN
query_exec_state	char(30)			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_burst_write_transactions

old
column	data type	PK	U	NN
xid	int8			NN
status	int4			NN
timestamp	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_conjunct_hash

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
nodeid	int4			NN
parentid	int4			NN
conjunct	int4			NN
conjunct_hash	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

pg_catalog.stcs_conjunct_hash_mapping

old
column	data type	PK	U	NN
tbl	int4			NN
conjunct_hash	char(64)			NN
conjunct_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

pg_catalog.stcs_insertion_point_bindings

old
column	data type	PK	U	NN
query_id	int4			NN
tbl	int4			NN
stage_tbl	int4			NN
ip_id	int4			NN
time	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_insertion_point_reservations

old
column	data type	PK	U	NN
query_id	int4			NN
tbl	int4			NN
data_slice	int4			NN
strategy	int4			NN
event	int4			NN
ip_id	int4			NN
type	int4			NN
writer_group_index	int4			NN
writer_index	int4			NN
time	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_optima_resource_usage

old
column	data type	PK	U	NN
recordtime	int8			NN
optima_last_day_end_timestamp_sec	int8			NN
optima_consumed_rpu_msec	int8			NN
optima_accrued_rpu_msec	int8			NN
num_atcs_query_running_queuing	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_pg_query_execution_info

old
column	data type	PK	U	NN
recordtime	int8			NN
query_id	int8			NN
pid	int4			NN
xid	int8			NN
user_id	int4			NN
checkpoint	int4			NN
time_consumption_us	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_process_registry_history

old
column	data type	PK	U	NN
padb_start_time	int8			NN
timestamp	int8			NN
node_number	int4			NN
procname	char(32)			NN
pid	int4			NN
is_critical	int4			NN
is_register	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_resource_forecaster_event

old
column	data type	PK	U	NN
event_time	int8			NN
component	int4			NN
event_type	int4			NN
description	char(400)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_resource_forecaster_inference

old
column	data type	PK	U	NN
prediction_starttime	int8			NN
prediction_endtime	int8			NN
prediction_bucket_index	int4			NN
model	int4			NN
sequence	int4			NN
json_data	char(400)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_resource_forecaster_training

old
column	data type	PK	U	NN
starttime	int8			NN
endtime	int8			NN
sequence	int4			NN
json_data	char(400)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_sage_mode_policy

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

new
column	data type	PK	U	NN

pg_catalog.stcs_sage_resize

old
column	data type	PK	U	NN
record_time	int8			NN
current_rpus	int4			NN
target_rpus	int4			NN
error	char(256)			NN
policy_id	int4			NN
trigger	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_storage_oid_events

old
column	data type	PK	U	NN
xid	int8			NN
event	char(256)			NN
table_id	int4			NN
remote_oid	int4			NN
userid	int4			NN
pid	int4			NN
recordtime	int8			NN
current_dml_version	int8			NN
current_structure_version	int8			NN
current_sb_version	int8			NN
current_ddl_version	int8			NN
host	char(256)			NN
database	char(256)			NN
schema	char(256)			NN
table_name	char(256)			NN
table_size	int8			NN
dirtiness_type	char(20)			NN
total_grafted_superblock_size	int8			NN
storage_oid_table_count	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_tuple_crc_metrics

old
column	data type	PK	U	NN
log_time	int8			NN
num_hits	int8			NN
num_misses	int8			NN
num_resets	int8			NN
total_num_invalidations	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_vacuum_lock_time

old
column	data type	PK	U	NN
xid	int8			NN
query	int4			NN
tbl_id	int4			NN
lock_type	int4			NN
vac_type	int4			NN
starttime	int8			NN
endtime	int8			NN
num_cols	int4			NN
optimized	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_applied_masking_policy

old
column	data type	PK	U	NN
polid	int4			NN
user_id	int4			NN
record_time	timestamp			NN
pid	int4			NN
xid	int8			NN
query_id	int8			NN
dbid	int4			NN
relid	int4			NN
relation_kind	char(30)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_async_rerep_worker_stats

old
column	data type	PK	U	NN
logtime	timestamp			NN
node_num	int4			NN
issued_rerep_reads	int8			NN
issued_rerep_writes	int8			NN
issued_dirty_writes	int8			NN
completed_rerep_reads	int8			NN
completed_rerep_writes	int8			NN
completed_dirty_writes	int8			NN
ignored_rerep_reads	int8			NN
ignored_rerep_writes	int8			NN
ignored_dirty_writes	int8			NN
rerep_pool_exhausted	int8			NN
ignored_comp_table_not_in_active_set	int8			NN
ignored_comp_block_state_changed	int8			NN
ignored_comp_block_pinned_during_write	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_auto_task_cost_benefit

old
column	data type	PK	U	NN
task_type	char(100)			NN
estimation_type	char(50)			NN
estimation_in_seconds	float8			NN
real_val_in_seconds	float8			NN
event_time	timestamp			NN
task_id	int8			NN
task_target	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_burst_user_temp_table_stats

old
column	data type	PK	U	NN
recordtime	timestamp			NN
xid	int8			NN
query	int8			NN
query_priority	int4			NN
total_blocks	int8			NN
blocks_not_in_s3	int8			NN
num_temp_tables	int4			NN
block_replication_start_time	timestamp			NN
block_replication_end_time	timestamp			NN
metadata_serialize_duration_main_ms	float8			NN
metadata_deserialize_duration_burst_ms	float8			NN
query_exec_state	char(30)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_burst_write_transactions

old
column	data type	PK	U	NN
xid	int8			NN
status	int4			NN
timestamp	timestamp			NN

new
column	data type	PK	U	NN

pg_catalog.stll_conjunct_hash

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
nodeid	int4			NN
parentid	int4			NN
conjunct	int4			NN
conjunct_hash	char(64)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_conjunct_hash_mapping

old
column	data type	PK	U	NN
tbl	int4			NN
conjunct_hash	char(64)			NN
conjunct_text	char(4000)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_insertion_point_bindings

old
column	data type	PK	U	NN
query_id	int4			NN
tbl	int4			NN
stage_tbl	int4			NN
ip_id	int4			NN
time	timestamp			NN

new
column	data type	PK	U	NN

pg_catalog.stll_insertion_point_reservations

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

new
column	data type	PK	U	NN

pg_catalog.stll_optima_resource_usage

old
column	data type	PK	U	NN
recordtime	timestamp			NN
optima_last_day_end_timestamp_sec	int8			NN
optima_consumed_rpu_msec	int8			NN
optima_accrued_rpu_msec	int8			NN
num_atcs_query_running_queuing	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_pg_query_execution_info

old
column	data type	PK	U	NN
recordtime	timestamp			NN
query_id	int8			NN
pid	int4			NN
xid	int8			NN
user_id	int4			NN
checkpoint	int4			NN
time_consumption_us	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_process_registry_history

old
column	data type	PK	U	NN
padb_start_time	timestamp			NN
timestamp	timestamp			NN
node_number	int4			NN
procname	char(32)			NN
pid	int4			NN
is_critical	int4			NN
is_register	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_resource_forecaster_event

old
column	data type	PK	U	NN
event_time	timestamp			NN
component	int4			NN
event_type	int4			NN
description	char(400)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_resource_forecaster_inference

old
column	data type	PK	U	NN
prediction_starttime	timestamp			NN
prediction_endtime	timestamp			NN
prediction_bucket_index	int4			NN
model	int4			NN
sequence	int4			NN
json_data	char(400)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_resource_forecaster_training

old
column	data type	PK	U	NN
starttime	timestamp			NN
endtime	timestamp			NN
sequence	int4			NN
json_data	char(400)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_sage_mode_policy

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

new
column	data type	PK	U	NN

pg_catalog.stll_sage_resize

old
column	data type	PK	U	NN
record_time	timestamp			NN
current_rpus	int4			NN
target_rpus	int4			NN
error	char(256)			NN
policy_id	int4			NN
trigger	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_storage_oid_events

old
column	data type	PK	U	NN
xid	int8			NN
event	char(256)			NN
table_id	int4			NN
remote_oid	int4			NN
userid	int4			NN
pid	int4			NN
recordtime	timestamp			NN
current_dml_version	int8			NN
current_structure_version	int8			NN
current_sb_version	int8			NN
current_ddl_version	int8			NN
host	char(256)			NN
database	char(256)			NN
schema	char(256)			NN
table_name	char(256)			NN
table_size	int8			NN
dirtiness_type	char(20)			NN
total_grafted_superblock_size	int8			NN
storage_oid_table_count	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_tuple_crc_metrics

old
column	data type	PK	U	NN
log_time	timestamp			NN
num_hits	int8			NN
num_misses	int8			NN
num_resets	int8			NN
total_num_invalidations	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_vacuum_lock_time

old
column	data type	PK	U	NN
xid	int8			NN
query	int4			NN
tbl_id	int4			NN
lock_type	int4			NN
vac_type	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
num_cols	int4			NN
optimized	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stv_guid_based_ts_cache_leaks

old
column	data type	PK	U	NN
node	int4			NN
guid	char(64)			NN
sb_pos	int4			NN
hdr_guid	char(64)			NN
leak_type	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stv_resource_forecaster_status

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

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_5579195

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_comm_pkt_oob_count

old
column	data type
now	timestamp
since	timestamp
node	int4
channel_type	int4
bad_guid	int4
no_channel	int4
bad_src	int4
bad_dst	int4
bad_cmd	int4
bad_crc	int4
excess_ack	int4
low_seqnum	int4
high_seqnum	int4
early_xon	int4
lost_packet	int4
reorder_packet	int4
likely_lost_ack	int4
extreme_delay	int4
in_rob	int4
excess_fast_rexmit	int4

new
column	data type
now	timestamp
since	timestamp
node	int4
is_raidp	int4
bad_guid	int4
no_channel	int4
bad_src	int4
bad_dst	int4
bad_cmd	int4
bad_crc	int4
excess_ack	int4
low_seqnum	int4
high_seqnum	int4
early_xon	int4
lost_packet	int4
reorder_packet	int4
likely_lost_ack	int4
extreme_delay	int4
in_rob	int4
excess_fast_rexmit	int4

pg_catalog.stl_comm_pkt_sent_count

old
column	data type
now	timestamp
since	timestamp
src_node	int4
dest_node	int4
channel_type	int4
bytes	int8
rexmit	int4
xon	int4
reply	int4
ack	int4
packet	int4
fast_rexmit	int4
original_ack	int4

new
column	data type
now	timestamp
since	timestamp
src_node	int4
dest_node	int4
is_raidp	int4
bytes	int8
rexmit	int4
xon	int4
reply	int4
ack	int4
packet	int4
fast_rexmit	int4
original_ack	int4

pg_catalog.sys_restore_log

old
column	data type
database_name	varchar(128)
schema_name	varchar(128)
table_name	varchar(128)
table_id	int4
action	varchar(27)
total_data_processed	float8
delta_data_processed	float8
event_time	timestamp
table_size	int8
message	varchar(56)
redistribution_type	varchar(24)

new
column	data type
database_name	varchar(128)
schema_name	varchar(128)
table_name	varchar(128)
table_id	int4
action	varchar(27)
total_data_processed	int8
delta_data_processed	int8
event_time	timestamp
table_size	int8
message	varchar(56)
redistribution_type	varchar(24)

pg_catalog.stl_applied_masking_policy

old
column	data type
polid	int4
user_id	int4
record_time	timestamp
pid	int4
xid	int8
query_id	int8
dbid	int4
relid	int4
relation_kind	char(30)

new
column	data type

pg_catalog.stl_async_rerep_worker_stats

old
column	data type
logtime	timestamp
node_num	int4
issued_rerep_reads	int8
issued_rerep_writes	int8
issued_dirty_writes	int8
completed_rerep_reads	int8
completed_rerep_writes	int8
completed_dirty_writes	int8
ignored_rerep_reads	int8
ignored_rerep_writes	int8
ignored_dirty_writes	int8
rerep_pool_exhausted	int8
ignored_comp_table_not_in_active_set	int8
ignored_comp_block_state_changed	int8
ignored_comp_block_pinned_during_write	int8

new
column	data type

pg_catalog.stl_auto_task_cost_benefit

old
column	data type
task_type	char(100)
estimation_type	char(50)
estimation_in_seconds	float8
real_val_in_seconds	float8
event_time	timestamp
task_id	int8
task_target	int4

new
column	data type

pg_catalog.stl_burst_user_temp_table_stats

old
column	data type
recordtime	timestamp
xid	int8
query	int8
query_priority	int4
total_blocks	int8
blocks_not_in_s3	int8
num_temp_tables	int4
block_replication_start_time	timestamp
block_replication_end_time	timestamp
metadata_serialize_duration_main_ms	float8
metadata_deserialize_duration_burst_ms	float8
query_exec_state	char(30)

new
column	data type

pg_catalog.stl_burst_write_transactions

old
column	data type
xid	int8
status	int4
timestamp	timestamp

new
column	data type

pg_catalog.stl_conjunct_hash

old
column	data type
userid	int4
query	int4
nodeid	int4
parentid	int4
conjunct	int4
conjunct_hash	char(64)

new
column	data type

pg_catalog.stl_conjunct_hash_mapping

old
column	data type
tbl	int4
conjunct_hash	char(64)
conjunct_text	char(4000)

new
column	data type

pg_catalog.stl_insertion_point_bindings

old
column	data type
query_id	int4
tbl	int4
stage_tbl	int4
ip_id	int4
time	timestamp

new
column	data type

pg_catalog.stl_insertion_point_reservations

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

new
column	data type

pg_catalog.stl_optima_resource_usage

old
column	data type
recordtime	timestamp
optima_last_day_end_timestamp_sec	int8
optima_consumed_rpu_msec	int8
optima_accrued_rpu_msec	int8
num_atcs_query_running_queuing	int4

new
column	data type

pg_catalog.stl_pg_query_execution_info

old
column	data type
recordtime	timestamp
query_id	int8
pid	int4
xid	int8
user_id	int4
checkpoint	int4
time_consumption_us	int8

new
column	data type

pg_catalog.stl_process_registry_history

old
column	data type
padb_start_time	timestamp
timestamp	timestamp
node_number	int4
procname	char(32)
pid	int4
is_critical	int4
is_register	int4

new
column	data type

pg_catalog.stl_resource_forecaster_event

old
column	data type
event_time	timestamp
component	int4
event_type	int4
description	char(400)

new
column	data type

pg_catalog.stl_resource_forecaster_inference

old
column	data type
prediction_starttime	timestamp
prediction_endtime	timestamp
prediction_bucket_index	int4
model	int4
sequence	int4
json_data	char(400)

new
column	data type

pg_catalog.stl_resource_forecaster_training

old
column	data type
starttime	timestamp
endtime	timestamp
sequence	int4
json_data	char(400)

new
column	data type

pg_catalog.stl_sage_mode_policy

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

new
column	data type

pg_catalog.stl_sage_resize

old
column	data type
record_time	timestamp
current_rpus	int4
target_rpus	int4
error	char(256)
policy_id	int4
trigger	int4

new
column	data type

pg_catalog.stl_storage_oid_events

old
column	data type
xid	int8
event	char(256)
table_id	int4
remote_oid	int4
userid	int4
pid	int4
recordtime	timestamp
current_dml_version	int8
current_structure_version	int8
current_sb_version	int8
current_ddl_version	int8
host	char(256)
database	char(256)
schema	char(256)
table_name	char(256)
table_size	int8
dirtiness_type	char(20)
total_grafted_superblock_size	int8
storage_oid_table_count	int4

new
column	data type

pg_catalog.stl_tuple_crc_metrics

old
column	data type
log_time	timestamp
num_hits	int8
num_misses	int8
num_resets	int8
total_num_invalidations	int8

new
column	data type

pg_catalog.stl_vacuum_lock_time

old
column	data type
xid	int8
query	int4
tbl_id	int4
lock_type	int4
vac_type	int4
starttime	timestamp
endtime	timestamp
num_cols	int4
optimized	int4

new
column	data type

pg_catalog.sys_applied_masking_policy_log

old
column	data type
policy_name	text
user_id	int4
record_time	timestamp
session_id	int4
transaction_id	int8
query_id	int8
database_name	text
relation_name	text
schema_name	text
attachment_id	oid
relation_kind	char(30)

new
column	data type