Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
new	pg_catalog	internal	immutable	text	tzdb_version	None
new	pg_catalog	internal	volatile	_record	pg_get_all_redshift_foreign_keys	None
new	pg_catalog	internal	volatile	_record	pg_get_all_redshift_primary_keys	None

Tables

pg_catalog.stcs_burst_rest_agent_info

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
eventtime	int8			NN
pid	int4			NN
request_type	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_burst_using_ds_localization_info

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
eventtime	int8			NN
padb	char(64)			NN
burst_using_ds_localization	int4			NN
reason	char(40)			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_source_diag

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	int8			NN
query	int4			NN
slice	int4			NN
channel_id	int4			NN
conn_idx	int4			NN
msg	char(512)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_disk_cache_access_pattern

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
logtime	int8			NN
node	int4			NN
table_id	int4			NN
metric_type	char(32)			NN
range_0_5	int4			NN
range_6_20	int4			NN
range_21_100	int4			NN
range_101_200	int4			NN
range_201_300	int4			NN
range_301_400	int4			NN
range_401_500	int4			NN
range_501_600	int4			NN
range_601_700	int4			NN
range_701_800	int4			NN
range_801_900	int4			NN
range_901_1000	int4			NN
range_1001_1500	int4			NN
range_1501_2000	int4			NN
range_2001_2500	int4			NN
range_2500_plus	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_global_alloc_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
now	int8			NN
since	int8			NN
node	int4			NN
alloc_base_req	int8			NN
alloc_public_req	int8			NN
alloc_disk_block_req	int8			NN
alloc_private_req	int8			NN
free_base_req	int8			NN
free_public_req	int8			NN
free_disk_block_req	int8			NN
free_private_req	int8			NN
end_of_segment_updates	int8			NN
update_on_access_base_page	int8			NN
update_on_access_public_page	int8			NN
update_on_access_private_page	int8			NN
fix_access_public_page	int8			NN
fix_access_other_page	int8			NN
enable_privilege_system	int8			NN
disable_privilege_system	int8			NN
mark_public_page	int8			NN
release_evicted_page	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_iceberg_query_detail

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
query	int4			NN
xid	int8			NN
segment	int4			NN
step	int4			NN
slice	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
tbl	int4			NN
file_format	char(64)			NN
compression_type	char(64)			NN
iceberg_files_count	int8			NN
iceberg_files_total_bytes	int8			NN
elapsed_write_time_us	int8			NN
partitions_accessed	int8			NN
table_name	char(128)			NN
iceberg_snapshot_id	int8			NN
access_control	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_stream_info

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	int8			NN
pid	int4			NN
xid	int8			NN
user_id	int4			NN
mvoid	int8			NN
eskind	int4			NN
action	char(128)			NN
database_name	char(128)			NN
schema_name	char(128)			NN
external_schema_name	char(128)			NN
stream_name	char(128)			NN
mv_name	char(128)			NN
refresh_type	char(32)			NN
cust_traffic_mode	char(128)			NN
esoptions	char(4096)			NN
metadata	char(4096)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_vacuum_log

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
eventtime	int8			NN
is_auto	int4			NN
xid	int8			NN
table_id	int4			NN
mode	char(16)			NN
slice	int4			NN
eventtext	char(128)			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_burst_rest_agent_info

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
eventtime	timestamp			NN
pid	int4			NN
request_type	int4			NN

pg_catalog.stll_burst_using_ds_localization_info

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
eventtime	timestamp			NN
padb	char(64)			NN
burst_using_ds_localization	int4			NN
reason	char(40)			NN

pg_catalog.stll_comm_source_diag

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	timestamp			NN
query	int4			NN
slice	int4			NN
channel_id	int4			NN
conn_idx	int4			NN
msg	char(512)			NN

pg_catalog.stll_disk_cache_access_pattern

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
logtime	timestamp			NN
node	int4			NN
table_id	int4			NN
metric_type	char(32)			NN
range_0_5	int4			NN
range_6_20	int4			NN
range_21_100	int4			NN
range_101_200	int4			NN
range_201_300	int4			NN
range_301_400	int4			NN
range_401_500	int4			NN
range_501_600	int4			NN
range_601_700	int4			NN
range_701_800	int4			NN
range_801_900	int4			NN
range_901_1000	int4			NN
range_1001_1500	int4			NN
range_1501_2000	int4			NN
range_2001_2500	int4			NN
range_2500_plus	int4			NN

pg_catalog.stll_global_alloc_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
now	timestamp			NN
since	timestamp			NN
node	int4			NN
alloc_base_req	int8			NN
alloc_public_req	int8			NN
alloc_disk_block_req	int8			NN
alloc_private_req	int8			NN
free_base_req	int8			NN
free_public_req	int8			NN
free_disk_block_req	int8			NN
free_private_req	int8			NN
end_of_segment_updates	int8			NN
update_on_access_base_page	int8			NN
update_on_access_public_page	int8			NN
update_on_access_private_page	int8			NN
fix_access_public_page	int8			NN
fix_access_other_page	int8			NN
enable_privilege_system	int8			NN
disable_privilege_system	int8			NN
mark_public_page	int8			NN
release_evicted_page	int8			NN

pg_catalog.stll_iceberg_query_detail

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
query	int4			NN
xid	int8			NN
segment	int4			NN
step	int4			NN
slice	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
tbl	int4			NN
file_format	char(64)			NN
compression_type	char(64)			NN
iceberg_files_count	int8			NN
iceberg_files_total_bytes	int8			NN
elapsed_write_time_us	int8			NN
partitions_accessed	int8			NN
table_name	char(128)			NN
iceberg_snapshot_id	int8			NN
access_control	int4			NN

pg_catalog.stll_stream_info

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
pid	int4			NN
xid	int8			NN
user_id	int4			NN
mvoid	int8			NN
eskind	int4			NN
action	char(128)			NN
database_name	char(128)			NN
schema_name	char(128)			NN
external_schema_name	char(128)			NN
stream_name	char(128)			NN
mv_name	char(128)			NN
refresh_type	char(32)			NN
cust_traffic_mode	char(128)			NN
esoptions	char(4096)			NN
metadata	char(4096)			NN

pg_catalog.stll_vacuum_log

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
eventtime	timestamp			NN
is_auto	int4			NN
xid	int8			NN
table_id	int4			NN
mode	char(16)			NN
slice	int4			NN
eventtext	char(128)			NN

pg_catalog.stv_planstats_cache

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
partition_num	char(10)			NN
old_query_id	int4			NN
new_query_id	int4			NN
old_compile_time	int4			NN
old_exec_time	int4			NN
new_exec_time	int4			NN
num_cache_hits	int4			NN
flags	int4			NN
plan_signature	char(10)			NN
generic_query_signature	char(20)			NN
generic_plan_signature	char(10)			NN

pg_internal.redshift_auto_health_check_8456260

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_alter_dist_sort

old
column	data type	PK	U	NN
xid	int8			NN
cutoff_xid	int8			NN
tbl	int4			NN
event	char(128)			NN
src_rows	int8			NN
dest_rows	int8			NN
redo_delete_rows	int8			NN
undone_rows	int8			NN
undone_txns	int8			NN
eventtime	int8			NN
origin_dist_style	int4			NN
num_sort_keys	int4			NN
target_distkey	int4			NN
request_sort	int4			NN
num_sort_iterations	int4			NN
dst_sorted_rows	int8			NN
is_autoworker_altered	int4			NN
src_table_num_blocks	int8			NN
nth_checkpoint	int4			NN
pid	int4			NN
shadow_tbl_num_blocks	int8			NN
controller_uuid	char(64)			NN
scanned_rows	int8			NN
scanned_rows_delta	int8			NN
alter_cmd_owner	char(64)			NN
db_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
message_code	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
xid	int8			NN
cutoff_xid	int8			NN
tbl	int4			NN
event	char(128)			NN
src_rows	int8			NN
dest_rows	int8			NN
redo_delete_rows	int8			NN
undone_rows	int8			NN
undone_txns	int8			NN
eventtime	int8			NN
origin_dist_style	int4			NN
num_sort_keys	int4			NN
target_distkey	int4			NN
request_sort	int4			NN
num_sort_iterations	int4			NN
dst_sorted_rows	int8			NN
is_autoworker_altered	int4			NN
src_table_num_blocks	int8			NN
nth_checkpoint	int4			NN
pid	int4			NN
shadow_tbl_num_blocks	int8			NN
controller_uuid	char(64)			NN
scanned_rows	int8			NN
scanned_rows_delta	int8			NN
alter_cmd_owner	char(64)			NN
db_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
message_code	int4			NN
query_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_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
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
attachment_id	int4			NN
policy_name	char(128)			NN
database_name	char(128)			NN
relation_name	char(128)			NN
schema_name	char(128)			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_async_prepare

old
column	data type	PK	U	NN
pid	int8			NN
starttime	int8			NN
acquire_endtime	int8			NN
endtime	int8			NN
cluster_arn	char(128)			NN
reason	char(40)			NN
num_nodes	int4			NN
error	char(250)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
pid	int8			NN
starttime	int8			NN
acquire_endtime	int8			NN
endtime	int8			NN
cluster_arn	char(128)			NN
reason	char(40)			NN
num_nodes	int4			NN
error	char(250)			NN
is_auto_task_burst	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_burst_connection

old
column	data type	PK	U	NN
action	char(20)			NN
method	char(50)			NN
pid	int8			NN
xid	int8			NN
line_number	int8			NN
eventtime	int8			NN
cluster_arn	char(128)			NN
connection_guid	char(100)			NN
error	char(250)			NN
switch_status	char(20)			NN
switch_time	int4			NN
starttime	int8			NN
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

new
column	data type	PK	U	NN
action	char(20)			NN
method	char(50)			NN
pid	int8			NN
xid	int8			NN
line_number	int8			NN
eventtime	int8			NN
cluster_arn	char(128)			NN
connection_guid	char(100)			NN
error	char(250)			NN
switch_status	char(20)			NN
switch_time	int4			NN
starttime	int8			NN
query	int4			NN
remote_pid	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_prepare

old
column	data type	PK	U	NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
starttime	int8			NN
endtime	int8			NN
error	char(250)			NN
query	int4			NN
code	int4			NN
source	int4			NN
multi_az_only	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
starttime	int8			NN
endtime	int8			NN
error	char(250)			NN
query	int4			NN
code	int4			NN
source	int4			NN
multi_az_only	int4			NN
is_auto_task_burst	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_checkpoints

old
column	data type	PK	U	NN
recordtime	int8			NN
connection_id	char(128)			NN
db_name	char(128)			NN
s3_path	char(512)			NN
checkpoint	char(128)			NN
type	char(16)			NN
num_tables_modified	int4			NN
status	char(16)			NN
bytes_downloaded	int8			NN
channel_state	char(128)			NN
export_identifier	char(64)			NN
rows	int8			NN
content	char(4096)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
recordtime	int8			NN
connection_id	char(128)			NN
db_name	char(128)			NN
s3_path	char(512)			NN
checkpoint	char(128)			NN
type	char(16)			NN
num_tables_modified	int4			NN
status	char(16)			NN
bytes_downloaded	int8			NN
channel_state	char(128)			NN
export_identifier	char(64)			NN
rows	int8			NN
content	char(4096)			NN
prev_checkpoint	char(128)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_federated_calls

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
sourcetype	char(30)			NN
segment	int4			NN
slice	int4			NN
recordtime	int8			NN
calltype	char(30)			NN
duration	int8			NN
querytext	char(4000)			NN
on_leader	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
xid	int8			NN
pid	int4			NN
query	int4			NN
sourcetype	char(30)			NN
segment	int4			NN
slice	int4			NN
recordtime	int8			NN
calltype	char(30)			NN
duration	int8			NN
querytext	char(4000)			NN
on_leader	char(1)			NN
is_redacted	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_filter

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
nodeid	int4			NN
parentid	int4			NN
kind	int4			NN
sequence	int4			NN
text	char(200)			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
nodeid	int4			NN
parentid	int4			NN
kind	int4			NN
sequence	int4			NN
text	char(200)			NN
is_redacted	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_inflight

old
column	data type	PK	U	NN
userid	int4			NN
logtime	int8			NN
slice	int4			NN
query	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
starttime	int8			NN
text	char(100)			NN
suspended	int4			NN
insert_pristine	int4			NN
working_mem	int8			NN
concurrency_scaling_status	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
logtime	int8			NN
slice	int4			NN
query	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
starttime	int8			NN
text	char(100)			NN
suspended	int4			NN
insert_pristine	int4			NN
working_mem	int8			NN
concurrency_scaling_status	int4			NN
is_redacted	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_integration_log

old
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
status	char(128)			NN
database_name	char(128)			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
synced_log_coordinate	char(128)			NN
num_modified_tables	int4			NN
lag_ms	int8			NN
checkpoint_bytes	int8			NN
integration_start_time	int8			NN
last_commit_timestamp	int8			NN
num_failed_tables	int4			NN
delay_ms	int8			NN
channel_state	char(128)			NN
export_identifier	char(64)			NN
rows	int8			NN
inserted_rows	int8			NN
deleted_rows	int8			NN
updated_rows	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

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

old
column	data type	PK	U	NN
pid	int4			NN
xid	int8			NN
database	int4			NN
sessionid	char(36)			NN
replay_start	int8			NN
replay_end	int8			NN
command_type	char(32)			NN
command_text	char(255)			NN
new_nft_replay	int4			NN
lazy_replay	int4			NN
reissue_status	char(255)			NN
multi_statement_replay	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
pid	int4			NN
xid	int8			NN
database	int4			NN
sessionid	char(36)			NN
replay_start	int8			NN
replay_end	int8			NN
command_type	char(32)			NN
command_text	char(255)			NN
new_nft_replay	int4			NN
lazy_replay	int4			NN
reissue_status	char(255)			NN
multi_statement_replay	int4			NN
is_redacted	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_query_internal

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

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database	char(32)			NN
querytxt	char(4000)			NN
starttime	int8			NN
endtime	int8			NN
aborted	int4			NN
is_redacted	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_querytext_internal

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
sequence	int4			NN
text	char(200)			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
xid	int8			NN
pid	int4			NN
query	int4			NN
sequence	int4			NN
text	char(200)			NN
is_redacted	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_rls_applied_policy

old
column	data type	PK	U	NN
userid	int4			NN
plan_qid	int8			NN
xid	int8			NN
pid	int4			NN
recordtime	int8			NN
command	char(1)			NN
dbid	int4			NN
relid	int4			NN
polid	int4			NN
poldefault	char(1)			NN
policy_provider	char(20)			NN
relkind	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
userid	int4			NN
plan_qid	int8			NN
xid	int8			NN
pid	int4			NN
recordtime	int8			NN
command	char(1)			NN
dbid	int4			NN
relid	int4			NN
polid	int4			NN
poldefault	char(1)			NN
policy_provider	char(20)			NN
relkind	char(30)			NN
user_name	char(128)			NN
database_name	char(128)			NN
schema_name	char(128)			NN
policy_name	char(128)			NN
table_name	char(128)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_s3partition_predicate

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
eventtime	int8			NN
predicate	char(1024)			NN
effectiveness	char(32)			NN
error	char(1024)			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
segment	int4			NN
node	int4			NN
slice	int4			NN
eventtime	int8			NN
predicate	char(1024)			NN
effectiveness	char(32)			NN
error	char(1024)			NN
is_redacted	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_truncate_history

old
column	data type	PK	U	NN
logtime	int8			NN
xid	int8			NN
table_id	int4			NN
table_name	char(128)			NN
is_temp	int4			NN
is_safe	int4			NN
is_extended_protocol	int4			NN
is_user	int4			NN
query_text	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
logtime	int8			NN
xid	int8			NN
table_id	int4			NN
table_name	char(128)			NN
is_temp	int4			NN
is_safe	int4			NN
is_extended_protocol	int4			NN
is_user	int4			NN
query_text	char(256)			NN
is_redacted	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.stll_alter_dist_sort

old
column	data type	PK	U	NN
xid	int8			NN
cutoff_xid	int8			NN
tbl	int4			NN
event	char(128)			NN
src_rows	int8			NN
dest_rows	int8			NN
redo_delete_rows	int8			NN
undone_rows	int8			NN
undone_txns	int8			NN
eventtime	timestamp			NN
origin_dist_style	int4			NN
num_sort_keys	int4			NN
target_distkey	int4			NN
request_sort	int4			NN
num_sort_iterations	int4			NN
dst_sorted_rows	int8			NN
is_autoworker_altered	int4			NN
src_table_num_blocks	int8			NN
nth_checkpoint	int4			NN
pid	int4			NN
shadow_tbl_num_blocks	int8			NN
controller_uuid	char(64)			NN
scanned_rows	int8			NN
scanned_rows_delta	int8			NN
alter_cmd_owner	char(64)			NN
db_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
message_code	int4			NN

new
column	data type	PK	U	NN
xid	int8			NN
cutoff_xid	int8			NN
tbl	int4			NN
event	char(128)			NN
src_rows	int8			NN
dest_rows	int8			NN
redo_delete_rows	int8			NN
undone_rows	int8			NN
undone_txns	int8			NN
eventtime	timestamp			NN
origin_dist_style	int4			NN
num_sort_keys	int4			NN
target_distkey	int4			NN
request_sort	int4			NN
num_sort_iterations	int4			NN
dst_sorted_rows	int8			NN
is_autoworker_altered	int4			NN
src_table_num_blocks	int8			NN
nth_checkpoint	int4			NN
pid	int4			NN
shadow_tbl_num_blocks	int8			NN
controller_uuid	char(64)			NN
scanned_rows	int8			NN
scanned_rows_delta	int8			NN
alter_cmd_owner	char(64)			NN
db_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
message_code	int4			NN
query_id	int4			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
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
attachment_id	int4			NN
policy_name	char(128)			NN
database_name	char(128)			NN
relation_name	char(128)			NN
schema_name	char(128)			NN

pg_catalog.stll_burst_async_prepare

old
column	data type	PK	U	NN
pid	int8			NN
starttime	timestamp			NN
acquire_endtime	timestamp			NN
endtime	timestamp			NN
cluster_arn	char(128)			NN
reason	char(40)			NN
num_nodes	int4			NN
error	char(250)			NN

new
column	data type	PK	U	NN
pid	int8			NN
starttime	timestamp			NN
acquire_endtime	timestamp			NN
endtime	timestamp			NN
cluster_arn	char(128)			NN
reason	char(40)			NN
num_nodes	int4			NN
error	char(250)			NN
is_auto_task_burst	int4			NN

pg_catalog.stll_burst_connection

old
column	data type	PK	U	NN
action	char(20)			NN
method	char(50)			NN
pid	int8			NN
xid	int8			NN
line_number	int8			NN
eventtime	timestamp			NN
cluster_arn	char(128)			NN
connection_guid	char(100)			NN
error	char(250)			NN
switch_status	char(20)			NN
switch_time	int4			NN
starttime	timestamp			NN
query	int4			NN

new
column	data type	PK	U	NN
action	char(20)			NN
method	char(50)			NN
pid	int8			NN
xid	int8			NN
line_number	int8			NN
eventtime	timestamp			NN
cluster_arn	char(128)			NN
connection_guid	char(100)			NN
error	char(250)			NN
switch_status	char(20)			NN
switch_time	int4			NN
starttime	timestamp			NN
query	int4			NN
remote_pid	int8			NN

pg_catalog.stll_burst_prepare

old
column	data type	PK	U	NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
error	char(250)			NN
query	int4			NN
code	int4			NN
source	int4			NN
multi_az_only	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
error	char(250)			NN
query	int4			NN
code	int4			NN
source	int4			NN
multi_az_only	int4			NN
is_auto_task_burst	int4			NN

pg_catalog.stll_cdc_checkpoints

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

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

pg_catalog.stll_federated_calls

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
sourcetype	char(30)			NN
segment	int4			NN
slice	int4			NN
recordtime	timestamp			NN
calltype	char(30)			NN
duration	int8			NN
querytext	char(4000)			NN
on_leader	char(1)			NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
sourcetype	char(30)			NN
segment	int4			NN
slice	int4			NN
recordtime	timestamp			NN
calltype	char(30)			NN
duration	int8			NN
querytext	char(4000)			NN
on_leader	char(1)			NN
is_redacted	char(1)			NN

pg_catalog.stll_filter

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
nodeid	int4			NN
parentid	int4			NN
kind	int4			NN
sequence	int4			NN
text	char(200)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
nodeid	int4			NN
parentid	int4			NN
kind	int4			NN
sequence	int4			NN
text	char(200)			NN
is_redacted	char(1)			NN

pg_catalog.stll_inflight

old
column	data type	PK	U	NN
userid	int4			NN
logtime	timestamp			NN
slice	int4			NN
query	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
starttime	timestamp			NN
text	char(100)			NN
suspended	int4			NN
insert_pristine	int4			NN
working_mem	int8			NN
concurrency_scaling_status	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
logtime	timestamp			NN
slice	int4			NN
query	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
starttime	timestamp			NN
text	char(100)			NN
suspended	int4			NN
insert_pristine	int4			NN
working_mem	int8			NN
concurrency_scaling_status	int4			NN
is_redacted	char(1)			NN

pg_catalog.stll_integration_log

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

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

pg_catalog.stll_nft_statement_replay_status

old
column	data type	PK	U	NN
pid	int4			NN
xid	int8			NN
database	int4			NN
sessionid	char(36)			NN
replay_start	timestamp			NN
replay_end	timestamp			NN
command_type	char(32)			NN
command_text	char(255)			NN
new_nft_replay	int4			NN
lazy_replay	int4			NN
reissue_status	char(255)			NN
multi_statement_replay	int4			NN

new
column	data type	PK	U	NN
pid	int4			NN
xid	int8			NN
database	int4			NN
sessionid	char(36)			NN
replay_start	timestamp			NN
replay_end	timestamp			NN
command_type	char(32)			NN
command_text	char(255)			NN
new_nft_replay	int4			NN
lazy_replay	int4			NN
reissue_status	char(255)			NN
multi_statement_replay	int4			NN
is_redacted	char(1)			NN

pg_catalog.stll_query_internal

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database	char(32)			NN
querytxt	char(4000)			NN
starttime	timestamp			NN
endtime	timestamp			NN
aborted	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database	char(32)			NN
querytxt	char(4000)			NN
starttime	timestamp			NN
endtime	timestamp			NN
aborted	int4			NN
is_redacted	char(1)			NN

pg_catalog.stll_querytext_internal

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
sequence	int4			NN
text	char(200)			NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
sequence	int4			NN
text	char(200)			NN
is_redacted	char(1)			NN

pg_catalog.stll_rls_applied_policy

old
column	data type	PK	U	NN
userid	int4			NN
plan_qid	int8			NN
xid	int8			NN
pid	int4			NN
recordtime	timestamp			NN
command	char(1)			NN
dbid	int4			NN
relid	int4			NN
polid	int4			NN
poldefault	char(1)			NN
policy_provider	char(20)			NN
relkind	char(30)			NN

new
column	data type	PK	U	NN
userid	int4			NN
plan_qid	int8			NN
xid	int8			NN
pid	int4			NN
recordtime	timestamp			NN
command	char(1)			NN
dbid	int4			NN
relid	int4			NN
polid	int4			NN
poldefault	char(1)			NN
policy_provider	char(20)			NN
relkind	char(30)			NN
user_name	char(128)			NN
database_name	char(128)			NN
schema_name	char(128)			NN
policy_name	char(128)			NN
table_name	char(128)			NN

pg_catalog.stll_s3partition_predicate

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
eventtime	timestamp			NN
predicate	char(1024)			NN
effectiveness	char(32)			NN
error	char(1024)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
eventtime	timestamp			NN
predicate	char(1024)			NN
effectiveness	char(32)			NN
error	char(1024)			NN
is_redacted	char(1)			NN

pg_catalog.stll_truncate_history

old
column	data type	PK	U	NN
logtime	timestamp			NN
xid	int8			NN
table_id	int4			NN
table_name	char(128)			NN
is_temp	int4			NN
is_safe	int4			NN
is_extended_protocol	int4			NN
is_user	int4			NN
query_text	char(256)			NN

new
column	data type	PK	U	NN
logtime	timestamp			NN
xid	int8			NN
table_id	int4			NN
table_name	char(128)			NN
is_temp	int4			NN
is_safe	int4			NN
is_extended_protocol	int4			NN
is_user	int4			NN
query_text	char(256)			NN
is_redacted	char(1)			NN

pg_catalog.stv_burst_manager_cluster_info

old
column	data type	PK	U	NN
cluster_arn	char(128)			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(128)			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
autonomics_burst	int4			NN

pg_catalog.stcs_io_iscsi_monitor

old
column	data type	PK	U	NN
event_time	int8			NN
node	int4			NN
type	char(16)			NN
event	char(200)			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_io_iscsi_monitor

old
column	data type	PK	U	NN
event_time	timestamp			NN
node	int4			NN
type	char(16)			NN
event	char(200)			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_8336841

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_burst_rest_agent_info

old
column	data type

new
column	data type
eventtime	timestamp
pid	int4
request_type	int4

pg_catalog.stl_burst_using_ds_localization_info

old
column	data type

new
column	data type
eventtime	timestamp
padb	char(64)
burst_using_ds_localization	int4
reason	char(40)

pg_catalog.stl_comm_source_diag

old
column	data type

new
column	data type
recordtime	timestamp
query	int4
slice	int4
channel_id	int4
conn_idx	int4
msg	char(512)

pg_catalog.stl_disk_cache_access_pattern

old
column	data type

new
column	data type
logtime	timestamp
node	int4
table_id	int4
metric_type	char(32)
range_0_5	int4
range_6_20	int4
range_21_100	int4
range_101_200	int4
range_201_300	int4
range_301_400	int4
range_401_500	int4
range_501_600	int4
range_601_700	int4
range_701_800	int4
range_801_900	int4
range_901_1000	int4
range_1001_1500	int4
range_1501_2000	int4
range_2001_2500	int4
range_2500_plus	int4

pg_catalog.stl_global_alloc_stats

old
column	data type

new
column	data type
now	timestamp
since	timestamp
node	int4
alloc_base_req	int8
alloc_public_req	int8
alloc_disk_block_req	int8
alloc_private_req	int8
free_base_req	int8
free_public_req	int8
free_disk_block_req	int8
free_private_req	int8
end_of_segment_updates	int8
update_on_access_base_page	int8
update_on_access_public_page	int8
update_on_access_private_page	int8
fix_access_public_page	int8
fix_access_other_page	int8
enable_privilege_system	int8
disable_privilege_system	int8
mark_public_page	int8
release_evicted_page	int8

pg_catalog.stl_iceberg_query_detail

old
column	data type

new
column	data type
user_id	int4
query	int4
xid	int8
segment	int4
step	int4
slice	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
tbl	int4
file_format	char(64)
compression_type	char(64)
iceberg_files_count	int8
iceberg_files_total_bytes	int8
elapsed_write_time_us	int8
partitions_accessed	int8
table_name	char(128)
iceberg_snapshot_id	int8

pg_catalog.stl_stream_info

old
column	data type

new
column	data type
record_time	timestamp
pid	int4
xid	int8
user_id	int4
mvoid	int8
eskind	int4
action	char(128)
database_name	char(128)
schema_name	char(128)
external_schema_name	char(128)
stream_name	char(128)
mv_name	char(128)
refresh_type	char(32)
cust_traffic_mode	char(128)
esoptions	char(4096)
metadata	char(4096)

pg_catalog.stl_vacuum_log

old
column	data type

new
column	data type
eventtime	timestamp
is_auto	int4
xid	int8
table_id	int4
mode	char(16)
slice	int4
eventtext	char(128)

pg_catalog.stl_alter_dist_sort

old
column	data type
xid	int8
cutoff_xid	int8
tbl	int4
event	char(128)
src_rows	int8
dest_rows	int8
redo_delete_rows	int8
undone_rows	int8
undone_txns	int8
eventtime	timestamp
origin_dist_style	int4
num_sort_keys	int4
target_distkey	int4
request_sort	int4
num_sort_iterations	int4
dst_sorted_rows	int8
is_autoworker_altered	int4
src_table_num_blocks	int8
nth_checkpoint	int4
pid	int4
shadow_tbl_num_blocks	int8
controller_uuid	char(64)
scanned_rows	int8
scanned_rows_delta	int8
alter_cmd_owner	char(64)
db_name	char(128)
schema_name	char(128)
table_name	char(128)
message_code	int4

new
column	data type
xid	int8
cutoff_xid	int8
tbl	int4
event	char(128)
src_rows	int8
dest_rows	int8
redo_delete_rows	int8
undone_rows	int8
undone_txns	int8
eventtime	timestamp
origin_dist_style	int4
num_sort_keys	int4
target_distkey	int4
request_sort	int4
num_sort_iterations	int4
dst_sorted_rows	int8
is_autoworker_altered	int4
src_table_num_blocks	int8
nth_checkpoint	int4
pid	int4
shadow_tbl_num_blocks	int8
controller_uuid	char(64)
scanned_rows	int8
scanned_rows_delta	int8
alter_cmd_owner	char(64)
db_name	char(128)
schema_name	char(128)
table_name	char(128)
message_code	int4
query_id	int4

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
polid	int4
user_id	int4
record_time	timestamp
pid	int4
xid	int8
query_id	int8
dbid	int4
relid	int4
relation_kind	char(30)
attachment_id	int4
policy_name	char(128)
database_name	char(128)
relation_name	char(128)
schema_name	char(128)

pg_catalog.stl_burst_async_prepare

old
column	data type
pid	int8
starttime	timestamp
acquire_endtime	timestamp
endtime	timestamp
cluster_arn	char(128)
reason	char(40)
num_nodes	int4
error	char(250)

new
column	data type
pid	int8
starttime	timestamp
acquire_endtime	timestamp
endtime	timestamp
cluster_arn	char(128)
reason	char(40)
num_nodes	int4
error	char(250)
is_auto_task_burst	int4

pg_catalog.stl_burst_connection

old
column	data type
action	char(20)
method	char(50)
pid	int8
xid	int8
line_number	int8
eventtime	timestamp
cluster_arn	char(128)
connection_guid	char(100)
error	char(250)
switch_status	char(20)
switch_time	int4
starttime	timestamp
query	int4

new
column	data type
action	char(20)
method	char(50)
pid	int8
xid	int8
line_number	int8
eventtime	timestamp
cluster_arn	char(128)
connection_guid	char(100)
error	char(250)
switch_status	char(20)
switch_time	int4
starttime	timestamp
query	int4
remote_pid	int8

pg_catalog.stl_burst_prepare

old
column	data type
userid	int4
pid	int8
xid	int8
starttime	timestamp
endtime	timestamp
error	char(250)
query	int4
code	int4
source	int4
multi_az_only	int4

new
column	data type
userid	int4
pid	int8
xid	int8
starttime	timestamp
endtime	timestamp
error	char(250)
query	int4
code	int4
source	int4
multi_az_only	int4
is_auto_task_burst	int4

pg_catalog.stl_cdc_checkpoints

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

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

pg_catalog.stl_federated_calls

old
column	data type
userid	int4
xid	int8
pid	int4
query	int4
sourcetype	char(30)
segment	int4
slice	int4
recordtime	timestamp
calltype	char(30)
duration	int8
querytext	char(4000)
on_leader	char(1)

new
column	data type
userid	int4
xid	int8
pid	int4
query	int4
sourcetype	char(30)
segment	int4
slice	int4
recordtime	timestamp
calltype	char(30)
duration	int8
querytext	char(4000)
on_leader	char(1)
is_redacted	char(1)

pg_catalog.stl_filter

old
column	data type
userid	int4
query	int4
nodeid	int4
parentid	int4
kind	int4
sequence	int4
text	char(200)

new
column	data type
userid	int4
query	int4
nodeid	int4
parentid	int4
kind	int4
sequence	int4
text	char(200)
is_redacted	char(1)

pg_catalog.stl_inflight

old
column	data type
userid	int4
logtime	timestamp
slice	int4
query	int4
label	char(320)
xid	int8
pid	int4
starttime	timestamp
text	char(100)
suspended	int4
insert_pristine	int4
working_mem	int8
concurrency_scaling_status	int4

new
column	data type
userid	int4
logtime	timestamp
slice	int4
query	int4
label	char(320)
xid	int8
pid	int4
starttime	timestamp
text	char(100)
suspended	int4
insert_pristine	int4
working_mem	int8
concurrency_scaling_status	int4
is_redacted	char(1)

pg_catalog.stl_integration_log

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

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

pg_catalog.stl_nft_statement_replay_status

old
column	data type
pid	int4
xid	int8
database	int4
sessionid	char(36)
replay_start	timestamp
replay_end	timestamp
command_type	char(32)
command_text	char(255)
new_nft_replay	int4
lazy_replay	int4
reissue_status	char(255)
multi_statement_replay	int4

new
column	data type
pid	int4
xid	int8
database	int4
sessionid	char(36)
replay_start	timestamp
replay_end	timestamp
command_type	char(32)
command_text	char(255)
new_nft_replay	int4
lazy_replay	int4
reissue_status	char(255)
multi_statement_replay	int4
is_redacted	char(1)

pg_catalog.stl_query_internal

old
column	data type
userid	int4
query	int4
label	char(320)
xid	int8
pid	int4
database	char(32)
querytxt	char(4000)
starttime	timestamp
endtime	timestamp
aborted	int4

new
column	data type
userid	int4
query	int4
label	char(320)
xid	int8
pid	int4
database	char(32)
querytxt	char(4000)
starttime	timestamp
endtime	timestamp
aborted	int4
is_redacted	char(1)

pg_catalog.stl_querytext_internal

old
column	data type
userid	int4
xid	int8
pid	int4
query	int4
sequence	int4
text	char(200)

new
column	data type
userid	int4
xid	int8
pid	int4
query	int4
sequence	int4
text	char(200)
is_redacted	char(1)

pg_catalog.stl_rls_applied_policy

old
column	data type
userid	int4
plan_qid	int8
xid	int8
pid	int4
recordtime	timestamp
command	char(1)
dbid	int4
relid	int4
polid	int4
poldefault	char(1)
policy_provider	char(20)
relkind	char(30)

new
column	data type
userid	int4
plan_qid	int8
xid	int8
pid	int4
recordtime	timestamp
command	char(1)
dbid	int4
relid	int4
polid	int4
poldefault	char(1)
policy_provider	char(20)
relkind	char(30)
user_name	char(128)
database_name	char(128)
schema_name	char(128)
policy_name	char(128)
table_name	char(128)

pg_catalog.stl_s3partition_predicate

old
column	data type
userid	int4
query	int4
segment	int4
node	int4
slice	int4
eventtime	timestamp
predicate	char(1024)
effectiveness	char(32)
error	char(1024)

new
column	data type
userid	int4
query	int4
segment	int4
node	int4
slice	int4
eventtime	timestamp
predicate	char(1024)
effectiveness	char(32)
error	char(1024)
is_redacted	char(1)

pg_catalog.stl_truncate_history

old
column	data type
logtime	timestamp
xid	int8
table_id	int4
table_name	char(128)
is_temp	int4
is_safe	int4
is_extended_protocol	int4
is_user	int4
query_text	char(256)

new
column	data type
logtime	timestamp
xid	int8
table_id	int4
table_name	char(128)
is_temp	int4
is_safe	int4
is_extended_protocol	int4
is_user	int4
query_text	char(256)
is_redacted	char(1)

pg_catalog.stl_io_iscsi_monitor

old
column	data type
event_time	timestamp
node	int4
type	char(16)
event	char(200)

new
column	data type