Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
new	pg_catalog	internal	immutable	geometry	st_geomfromgeosquare	int8
new	pg_catalog	internal	immutable	geometry	st_geomfromgeosquare	int8,int4
new	pg_catalog	internal	immutable	int8	st_geosquare	geometry
new	pg_catalog	internal	immutable	int8	st_geosquare	geometry,int4
new	pg_catalog	internal	volatile	_record	pg_get_session_roles	None

Tables

pg_catalog.pg_s3_sqs_notifications

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
sqs_url	text
dlq_url	text
region	text

pg_catalog.stcs_burst_async_prepare

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

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	int8			NN
pid	int4			NN
sb_version	int8			NN
refresh_type	int4			NN
list_type	int4			NN
num_tables	int4			NN
tables	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

pg_catalog.stcs_cluster_handle_usage

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
procname	char(32)			NN
cluster_version	int4			NN
acquired	int4			NN
time	int8			NN
pid	int4			NN
tid	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_global_packet_pool

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
since	int8			NN
now	int8			NN
pool_id	int4			NN
available_packets	int4			NN
command_type	char(50)			NN
borrowed_count	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_integration_activity_detail

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
database_name	char(128)			NN
node_id	int4			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
copy_id	int8			NN
table_name	char(128)			NN
checkpoint_data_size	int8			NN
state	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_perf_permanent_channel_sink

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
since	int8			NN
now	int8			NN
node	int4			NN
slice	int4			NN
channel_type	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
xoff_total_ns	int8			NN
xoff_max_ns	int8			NN
queue_delay_sample_total_ns	int8			NN
queue_delay_sample_max_ns	int8			NN
rexmit_total_count	int8			NN
rexmit_max_count	int8			NN
channel_sink_init_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

pg_catalog.stcs_perf_permanent_channel_source

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
since	int8			NN
now	int8			NN
node	int4			NN
slice	int4			NN
channel_type	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
borrow_total_ns	int8			NN
borrow_max_ns	int8			NN
queue_delay_sample_total_ns	int8			NN
queue_delay_sample_max_ns	int8			NN
channel_source_init_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

pg_catalog.stcs_redshift_proxy_connection_startup

old
column	data type	PK	U	NN

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

pg_catalog.stcs_s3_connection_holding_internal

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	int8			NN
pid	int4			NN
event	char(50)			NN
error	char(512)			NN
bucket_name	char(512)			NN
s3_key_prefix	char(512)			NN
file_name	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.stll_burst_async_prepare

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

pg_catalog.stll_burst_refresh_tables_list

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
pid	int4			NN
sb_version	int8			NN
refresh_type	int4			NN
list_type	int4			NN
num_tables	int4			NN
tables	char(1024)			NN

pg_catalog.stll_cluster_handle_usage

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
procname	char(32)			NN
cluster_version	int4			NN
acquired	int4			NN
time	timestamp			NN
pid	int4			NN
tid	int4			NN

pg_catalog.stll_comm_global_packet_pool

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
since	timestamp			NN
now	timestamp			NN
pool_id	int4			NN
available_packets	int4			NN
command_type	char(50)			NN
borrowed_count	int8			NN

pg_catalog.stll_integration_activity_detail

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
database_name	char(128)			NN
node_id	int4			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
copy_id	int8			NN
table_name	char(128)			NN
checkpoint_data_size	int8			NN
state	char(128)			NN

pg_catalog.stll_perf_permanent_channel_sink

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
since	timestamp			NN
now	timestamp			NN
node	int4			NN
slice	int4			NN
channel_type	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
xoff_total_ns	int8			NN
xoff_max_ns	int8			NN
queue_delay_sample_total_ns	int8			NN
queue_delay_sample_max_ns	int8			NN
rexmit_total_count	int8			NN
rexmit_max_count	int8			NN
channel_sink_init_us	int8			NN

pg_catalog.stll_perf_permanent_channel_source

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
since	timestamp			NN
now	timestamp			NN
node	int4			NN
slice	int4			NN
channel_type	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
borrow_total_ns	int8			NN
borrow_max_ns	int8			NN
queue_delay_sample_total_ns	int8			NN
queue_delay_sample_max_ns	int8			NN
channel_source_init_us	int8			NN

pg_catalog.stll_redshift_proxy_connection_startup

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
pid	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN

pg_catalog.stll_s3_connection_holding_internal

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	timestamp			NN
pid	int4			NN
event	char(50)			NN
error	char(512)			NN
bucket_name	char(512)			NN
s3_key_prefix	char(512)			NN
file_name	char(512)			NN

pg_catalog.stv_comm_global_packet_pool

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
now	timestamp			NN
pool_id	int4			NN
available_packets	int4			NN
command_type	char(50)			NN
borrowed_count	int8			NN

pg_catalog.stv_mv_deps_internal

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
database_name	char(128)			NN
schema_name	char(128)			NN
name	char(128)			NN
ref_database_name	char(128)			NN
ref_schema_name	char(128)			NN
ref_name	char(128)			NN
ref_type	char(128)			NN
ref_source	char(128)			NN

pg_internal.redshift_auto_health_check_3073466

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

old
column	data type	PK	U	NN
action	char(20)			NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
query	int8			NN
backup_id	char(30)			NN
cluster_backup_version	int8			NN
starttime	int8			NN
endtime	int8			NN
cluster_arn	char(100)			NN
max_vis_xid	int8			NN
query_sb_version	int8			NN
num_tuples	int4			NN
fetch_complete	int4			NN
error	char(350)			NN
connection_guid	char(100)			NN
xen_error_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
action	char(20)			NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
query	int8			NN
backup_id	char(30)			NN
cluster_backup_version	int8			NN
starttime	int8			NN
endtime	int8			NN
cluster_arn	char(100)			NN
max_vis_xid	int8			NN
query_sb_version	int8			NN
num_tuples	int4			NN
fetch_complete	int4			NN
error	char(350)			NN
connection_guid	char(100)			NN
xen_error_code	int4			NN
burst_cluster_id	char(38)			NN
burst_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_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
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
superblock_type	char(256)			NN
schema_name_table_name	char(256)			NN
table_size	int8			NN
total_log_entries_changed	int8			NN
total_sb_size	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_executor_steps

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	int8			NN
query	int4			NN
stream_num	int4			NN
segment	int4			NN
subplan_level	int4			NN
subplan_id	int4			NN
steps	char(2048)			NN
supports_executor	char(128)			NN
code_item_was_cached	int4			NN
compile	int4			NN
is_short_query	int4			NN
is_short_query_debug_compile	int4			NN
expression_oids	char(500)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
recordtime	int8			NN
query	int4			NN
stream_num	int4			NN
segment	int4			NN
subplan_level	int4			NN
subplan_id	int4			NN
steps	char(2048)			NN
supports_executor	int4			NN
code_item_was_cached	int4			NN
compile	int4			NN
is_short_query	int4			NN
is_short_query_debug_compile	int4			NN
expression_oids	char(500)			NN
step_supports_executor	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_file_scan

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
name	char(90)			NN
lines	int8			NN
bytes	int8			NN
loadtime	int8			NN
curtime	int8			NN
is_partial	int4			NN
start_offset	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
name	char(90)			NN
lines	int8			NN
bytes	int8			NN
loadtime	int8			NN
curtime	int8			NN
is_partial	int4			NN
start_offset	int8			NN
num_large_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

pg_catalog.stcs_insert

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
tbl	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
tbl	int4			NN
inserted_mega_value	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
__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
__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_mv_refresh

old
column	data type	PK	U	NN
userid	int8			NN
xid	int8			NN
starttime	int8			NN
endtime	int8			NN
schemaoid	int8			NN
mvoid	int8			NN
status	int4			NN
refresh_type	char(32)			NN
db_oid	int8			NN
no_new_rows	char(1)			NN
skipped_rows	char(1)			NN
may_have_more_rows	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	int8			NN
xid	int8			NN
starttime	int8			NN
endtime	int8			NN
schemaoid	int8			NN
mvoid	int8			NN
status	int4			NN
refresh_type	char(32)			NN
db_oid	int8			NN
no_new_rows	char(1)			NN
skipped_rows	char(1)			NN
may_have_more_rows	char(1)			NN
session_id	int4			NN
database_name	char(128)			NN
schema_name	char(128)			NN
mv_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_mv_state

old
column	data type	PK	U	NN
userid	int8			NN
starttime	int8			NN
xid	int8			NN
event_desc	char(500)			NN
db_name	char(128)			NN
base_table_schema	char(128)			NN
base_table_name	char(128)			NN
mv_schema	char(128)			NN
mv_name	char(128)			NN
state	char(32)			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	int8			NN
starttime	int8			NN
xid	int8			NN
event_desc	char(500)			NN
db_name	char(128)			NN
base_table_schema	char(128)			NN
base_table_name	char(128)			NN
mv_schema	char(128)			NN
mv_name	char(128)			NN
state	char(32)			NN
base_table_database_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_query_detail

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
stream_id	int4			NN
segment_id	int4			NN
step_id	int4			NN
slice	int4			NN
starttime	int8			NN
endtime	int8			NN
step_name	int4			NN
table_id	int4			NN
table_name	char(136)			NN
input_rows	int8			NN
input_bytes	int8			NN
output_rows	int8			NN
output_bytes	int8			NN
is_rrscan	char(1)			NN
blocks_read	int8			NN
blocks_write	int8			NN
local_read_io	int8			NN
remote_read_io	int8			NN
alert	char(1024)			NN
internal_query	char(1)			NN
source	char(64)			NN
cpu_time	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
stream_id	int4			NN
segment_id	int4			NN
step_id	int4			NN
slice	int4			NN
starttime	int8			NN
endtime	int8			NN
step_name	int4			NN
table_id	int4			NN
table_name	char(136)			NN
input_rows	int8			NN
input_bytes	int8			NN
output_rows	int8			NN
output_bytes	int8			NN
is_rrscan	char(1)			NN
blocks_read	int8			NN
blocks_write	int8			NN
local_read_io	int8			NN
remote_read_io	int8			NN
alert	char(1024)			NN
internal_query	char(1)			NN
source	char(64)			NN
cpu_time	int8			NN
spilled_block_local_disk	int8			NN
spilled_block_remote_disk	int8			NN
__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_stored_proc_messages

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
loglevel	int4			NN
message	char(1024)			NN
linenum	int4			NN
recordtime	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
loglevel	int4			NN
message	char(1024)			NN
linenum	int4			NN
recordtime	int8			NN
message_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_superblock_trickle_validation_stats

old
column	data type	PK	U	NN
node	int4			NN
record_time	int8			NN
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_entries_validated	int8			NN
log_blocks_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
trickle_validation_done	int4			NN
log_rotation	int4			NN
was_tree_validated	int4			NN
tree_trickle_validation_done	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
node	int4			NN
record_time	int8			NN
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_entries_validated	int8			NN
log_blocks_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
trickle_validation_done	int4			NN
log_rotation	int4			NN
was_tree_validated	int4			NN
tree_trickle_validation_done	int4			NN
xid	int8			NN
start_time	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_user_query_text

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
transaction_id	int8			NN
session_id	int4			NN
start_time	int8			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
user_id	int4			NN
query_id	int8			NN
transaction_id	int8			NN
session_id	int4			NN
start_time	int8			NN
sequence	int4			NN
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

pg_catalog.stcs_wlm_service_class_config

old
column	data type	PK	U	NN
service_class	int4			NN
queueing_strategy	char(32)			NN
num_query_tasks	int4			NN
target_num_query_tasks	int4			NN
evictable	char(8)			NN
eviction_threshold	int8			NN
query_working_mem	int4			NN
target_query_working_mem	int4			NN
min_step_mem	int4			NN
name	char(64)			NN
max_execution_time	int4			NN
user_group_wild_card	char(8)			NN
query_group_wild_card	char(8)			NN
concurrency_scaling	char(20)			NN
query_priority	char(20)			NN
eventtime	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
service_class	int4			NN
queueing_strategy	char(32)			NN
num_query_tasks	int4			NN
target_num_query_tasks	int4			NN
evictable	char(8)			NN
eviction_threshold	int8			NN
query_working_mem	int4			NN
target_query_working_mem	int4			NN
min_step_mem	int4			NN
name	char(64)			NN
max_execution_time	int4			NN
user_group_wild_card	char(8)			NN
query_group_wild_card	char(8)			NN
concurrency_scaling	char(20)			NN
query_priority	char(20)			NN
eventtime	int8			NN
user_role_wild_card	char(8)			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_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

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

pg_catalog.stll_burst_query_execution

old
column	data type	PK	U	NN
action	char(20)			NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
query	int8			NN
backup_id	char(30)			NN
cluster_backup_version	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
cluster_arn	char(100)			NN
max_vis_xid	int8			NN
query_sb_version	int8			NN
num_tuples	int4			NN
fetch_complete	int4			NN
error	char(350)			NN
connection_guid	char(100)			NN
xen_error_code	int4			NN

new
column	data type	PK	U	NN
action	char(20)			NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
query	int8			NN
backup_id	char(30)			NN
cluster_backup_version	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
cluster_arn	char(100)			NN
max_vis_xid	int8			NN
query_sb_version	int8			NN
num_tuples	int4			NN
fetch_complete	int4			NN
error	char(350)			NN
connection_guid	char(100)			NN
xen_error_code	int4			NN
burst_cluster_id	char(38)			NN
burst_query_id	int4			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
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
superblock_type	char(256)			NN
schema_name_table_name	char(256)			NN
table_size	int8			NN
total_log_entries_changed	int8			NN
total_sb_size	int8			NN

pg_catalog.stll_executor_steps

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
query	int4			NN
stream_num	int4			NN
segment	int4			NN
subplan_level	int4			NN
subplan_id	int4			NN
steps	char(2048)			NN
supports_executor	char(128)			NN
code_item_was_cached	int4			NN
compile	int4			NN
is_short_query	int4			NN
is_short_query_debug_compile	int4			NN
expression_oids	char(500)			NN

new
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
query	int4			NN
stream_num	int4			NN
segment	int4			NN
subplan_level	int4			NN
subplan_id	int4			NN
steps	char(2048)			NN
supports_executor	int4			NN
code_item_was_cached	int4			NN
compile	int4			NN
is_short_query	int4			NN
is_short_query_debug_compile	int4			NN
expression_oids	char(500)			NN
step_supports_executor	char(128)			NN

pg_catalog.stll_file_scan

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
name	char(90)			NN
lines	int8			NN
bytes	int8			NN
loadtime	int8			NN
curtime	timestamp			NN
is_partial	int4			NN
start_offset	int8			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
name	char(90)			NN
lines	int8			NN
bytes	int8			NN
loadtime	int8			NN
curtime	timestamp			NN
is_partial	int4			NN
start_offset	int8			NN
num_large_rows	int8			NN

pg_catalog.stll_insert

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
tbl	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
tbl	int4			NN
inserted_mega_value	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

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

pg_catalog.stll_mv_refresh

old
column	data type	PK	U	NN
userid	int8			NN
xid	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
schemaoid	int8			NN
mvoid	int8			NN
status	int4			NN
refresh_type	char(32)			NN
db_oid	int8			NN
no_new_rows	char(1)			NN
skipped_rows	char(1)			NN
may_have_more_rows	char(1)			NN

new
column	data type	PK	U	NN
userid	int8			NN
xid	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
schemaoid	int8			NN
mvoid	int8			NN
status	int4			NN
refresh_type	char(32)			NN
db_oid	int8			NN
no_new_rows	char(1)			NN
skipped_rows	char(1)			NN
may_have_more_rows	char(1)			NN
session_id	int4			NN
database_name	char(128)			NN
schema_name	char(128)			NN
mv_name	char(128)			NN

pg_catalog.stll_mv_state

old
column	data type	PK	U	NN
userid	int8			NN
starttime	timestamp			NN
xid	int8			NN
event_desc	char(500)			NN
db_name	char(128)			NN
base_table_schema	char(128)			NN
base_table_name	char(128)			NN
mv_schema	char(128)			NN
mv_name	char(128)			NN
state	char(32)			NN

new
column	data type	PK	U	NN
userid	int8			NN
starttime	timestamp			NN
xid	int8			NN
event_desc	char(500)			NN
db_name	char(128)			NN
base_table_schema	char(128)			NN
base_table_name	char(128)			NN
mv_schema	char(128)			NN
mv_name	char(128)			NN
state	char(32)			NN
base_table_database_name	char(128)			NN

pg_catalog.stll_query_detail

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
stream_id	int4			NN
segment_id	int4			NN
step_id	int4			NN
slice	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
step_name	int4			NN
table_id	int4			NN
table_name	char(136)			NN
input_rows	int8			NN
input_bytes	int8			NN
output_rows	int8			NN
output_bytes	int8			NN
is_rrscan	char(1)			NN
blocks_read	int8			NN
blocks_write	int8			NN
local_read_io	int8			NN
remote_read_io	int8			NN
alert	char(1024)			NN
internal_query	char(1)			NN
source	char(64)			NN
cpu_time	int8			NN

new
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
stream_id	int4			NN
segment_id	int4			NN
step_id	int4			NN
slice	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
step_name	int4			NN
table_id	int4			NN
table_name	char(136)			NN
input_rows	int8			NN
input_bytes	int8			NN
output_rows	int8			NN
output_bytes	int8			NN
is_rrscan	char(1)			NN
blocks_read	int8			NN
blocks_write	int8			NN
local_read_io	int8			NN
remote_read_io	int8			NN
alert	char(1024)			NN
internal_query	char(1)			NN
source	char(64)			NN
cpu_time	int8			NN
spilled_block_local_disk	int8			NN
spilled_block_remote_disk	int8			NN

pg_catalog.stll_stored_proc_messages

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
loglevel	int4			NN
message	char(1024)			NN
linenum	int4			NN
recordtime	timestamp			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
loglevel	int4			NN
message	char(1024)			NN
linenum	int4			NN
recordtime	timestamp			NN
message_xid	int8			NN

pg_catalog.stll_superblock_trickle_validation_stats

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

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

pg_catalog.stll_user_query_text

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
transaction_id	int8			NN
session_id	int4			NN
start_time	timestamp			NN
sequence	int4			NN
text	char(200)			NN

new
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
transaction_id	int8			NN
session_id	int4			NN
start_time	timestamp			NN
sequence	int4			NN
text	char(4000)			NN

pg_catalog.stll_wlm_service_class_config

old
column	data type	PK	U	NN
service_class	int4			NN
queueing_strategy	char(32)			NN
num_query_tasks	int4			NN
target_num_query_tasks	int4			NN
evictable	char(8)			NN
eviction_threshold	int8			NN
query_working_mem	int4			NN
target_query_working_mem	int4			NN
min_step_mem	int4			NN
name	char(64)			NN
max_execution_time	int4			NN
user_group_wild_card	char(8)			NN
query_group_wild_card	char(8)			NN
concurrency_scaling	char(20)			NN
query_priority	char(20)			NN
eventtime	timestamp			NN

new
column	data type	PK	U	NN
service_class	int4			NN
queueing_strategy	char(32)			NN
num_query_tasks	int4			NN
target_num_query_tasks	int4			NN
evictable	char(8)			NN
eviction_threshold	int8			NN
query_working_mem	int4			NN
target_query_working_mem	int4			NN
min_step_mem	int4			NN
name	char(64)			NN
max_execution_time	int4			NN
user_group_wild_card	char(8)			NN
query_group_wild_card	char(8)			NN
concurrency_scaling	char(20)			NN
query_priority	char(20)			NN
eventtime	timestamp			NN
user_role_wild_card	char(8)			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
total_tables_replicated	int4			NN
total_tables_failed	int4			NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
database_name	char(128)			NN
synced_log_coordinate	char(128)			NN
lag_ms	int8			NN
total_tables_replicated	int4			NN
total_tables_failed	int4			NN
source_state	char(128)			NN
source_error_reason	char(128)			NN

pg_catalog.stv_wlm_service_class_config

old
column	data type	PK	U	NN
service_class	int4			NN
queueing_strategy	char(32)			NN
num_query_tasks	int4			NN
target_num_query_tasks	int4			NN
evictable	char(8)			NN
eviction_threshold	int8			NN
query_working_mem	int4			NN
target_query_working_mem	int4			NN
min_step_mem	int4			NN
name	char(64)			NN
max_execution_time	int4			NN
user_group_wild_card	char(8)			NN
query_group_wild_card	char(8)			NN
concurrency_scaling	char(20)			NN
query_priority	char(20)			NN

new
column	data type	PK	U	NN
service_class	int4			NN
queueing_strategy	char(32)			NN
num_query_tasks	int4			NN
target_num_query_tasks	int4			NN
evictable	char(8)			NN
eviction_threshold	int8			NN
query_working_mem	int4			NN
target_query_working_mem	int4			NN
min_step_mem	int4			NN
name	char(64)			NN
max_execution_time	int4			NN
user_group_wild_card	char(8)			NN
query_group_wild_card	char(8)			NN
concurrency_scaling	char(20)			NN
query_priority	char(20)			NN
user_role_wild_card	char(8)			NN

pg_internal.redshift_auto_health_check_1272549

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_async_prepare

old
column	data type

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)

pg_catalog.stl_burst_refresh_tables_list

old
column	data type

new
column	data type
record_time	timestamp
pid	int4
sb_version	int8
refresh_type	int4
list_type	int4
num_tables	int4
tables	char(1024)

pg_catalog.stl_cluster_handle_usage

old
column	data type

new
column	data type
procname	char(32)
cluster_version	int4
acquired	int4
time	timestamp
pid	int4
tid	int4

pg_catalog.stl_comm_global_packet_pool

old
column	data type

new
column	data type
since	timestamp
now	timestamp
pool_id	int4
available_packets	int4
command_type	char(50)
borrowed_count	int8

pg_catalog.stl_integration_activity_detail

old
column	data type

new
column	data type
record_time	timestamp
integration_id	char(128)
database_name	char(128)
node_id	int4
checkpoint_name	char(128)
checkpoint_type	char(16)
copy_id	int8
table_name	char(128)
checkpoint_data_size	int8
state	char(128)

pg_catalog.stl_perf_permanent_channel_sink

old
column	data type

new
column	data type
since	timestamp
now	timestamp
node	int4
slice	int4
channel_type	int4
packet_count	int8
bytes_transferred	int8
xoff_total_ns	int8
xoff_max_ns	int8
queue_delay_sample_total_ns	int8
queue_delay_sample_max_ns	int8
rexmit_total_count	int8
rexmit_max_count	int8
channel_sink_init_us	int8

pg_catalog.stl_perf_permanent_channel_source

old
column	data type

new
column	data type
since	timestamp
now	timestamp
node	int4
slice	int4
channel_type	int4
packet_count	int8
bytes_transferred	int8
borrow_total_ns	int8
borrow_max_ns	int8
queue_delay_sample_total_ns	int8
queue_delay_sample_max_ns	int8
channel_source_init_us	int8

pg_catalog.stl_redshift_proxy_connection_startup

old
column	data type

new
column	data type
pid	int4
starttime	timestamp
endtime	timestamp

pg_catalog.stl_s3_connection_holding_internal

old
column	data type

new
column	data type
recordtime	timestamp
pid	int4
event	char(50)
error	char(512)
bucket_name	char(512)
s3_key_prefix	char(512)
file_name	char(512)

pg_catalog.sys_mv_refresh_history

old
column	data type

new
column	data type
user_id	int8
session_id	int4
transaction_id	int8
database_name	char(128)
schema_name	char(128)
mv_id	int8
mv_name	char(128)
refresh_type	char(32)
status	text
start_time	timestamp
end_time	timestamp
duration	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

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

pg_catalog.stl_burst_query_execution

old
column	data type
action	char(20)
userid	int4
pid	int8
xid	int8
query	int8
backup_id	char(30)
cluster_backup_version	int8
starttime	timestamp
endtime	timestamp
cluster_arn	char(100)
max_vis_xid	int8
query_sb_version	int8
num_tuples	int4
fetch_complete	int4
error	char(350)
connection_guid	char(100)
xen_error_code	int4

new
column	data type
action	char(20)
userid	int4
pid	int8
xid	int8
query	int8
backup_id	char(30)
cluster_backup_version	int8
starttime	timestamp
endtime	timestamp
cluster_arn	char(100)
max_vis_xid	int8
query_sb_version	int8
num_tuples	int4
fetch_complete	int4
error	char(350)
connection_guid	char(100)
xen_error_code	int4
burst_cluster_id	char(38)
burst_query_id	int4

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
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)
superblock_type	char(256)
schema_name_table_name	char(256)
table_size	int8
total_log_entries_changed	int8
total_sb_size	int8

pg_catalog.stl_executor_steps

old
column	data type
userid	int4
recordtime	timestamp
query	int4
stream_num	int4
segment	int4
subplan_level	int4
subplan_id	int4
steps	char(2048)
supports_executor	char(128)
code_item_was_cached	int4
compile	int4
is_short_query	int4
is_short_query_debug_compile	int4
expression_oids	char(500)

new
column	data type
userid	int4
recordtime	timestamp
query	int4
stream_num	int4
segment	int4
subplan_level	int4
subplan_id	int4
steps	char(2048)
supports_executor	int4
code_item_was_cached	int4
compile	int4
is_short_query	int4
is_short_query_debug_compile	int4
expression_oids	char(500)
step_supports_executor	char(128)

pg_catalog.stl_file_scan

old
column	data type
userid	int4
query	int4
slice	int4
name	char(90)
lines	int8
bytes	int8
loadtime	int8
curtime	timestamp
is_partial	int4
start_offset	int8

new
column	data type
userid	int4
query	int4
slice	int4
name	char(90)
lines	int8
bytes	int8
loadtime	int8
curtime	timestamp
is_partial	int4
start_offset	int8
num_large_rows	int8

pg_catalog.stl_insert

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
tbl	int4

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
tbl	int4
inserted_mega_value	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

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

pg_catalog.stl_mv_refresh

old
column	data type
userid	int8
xid	int8
starttime	timestamp
endtime	timestamp
schemaoid	int8
mvoid	int8
status	int4
refresh_type	char(32)
db_oid	int8
no_new_rows	char(1)
skipped_rows	char(1)
may_have_more_rows	char(1)

new
column	data type
userid	int8
xid	int8
starttime	timestamp
endtime	timestamp
schemaoid	int8
mvoid	int8
status	int4
refresh_type	char(32)
db_oid	int8
no_new_rows	char(1)
skipped_rows	char(1)
may_have_more_rows	char(1)
session_id	int4
database_name	char(128)
schema_name	char(128)
mv_name	char(128)

pg_catalog.stl_mv_state

old
column	data type
userid	int8
starttime	timestamp
xid	int8
event_desc	char(500)
db_name	char(128)
base_table_schema	char(128)
base_table_name	char(128)
mv_schema	char(128)
mv_name	char(128)
state	char(32)

new
column	data type
userid	int8
starttime	timestamp
xid	int8
event_desc	char(500)
db_name	char(128)
base_table_schema	char(128)
base_table_name	char(128)
mv_schema	char(128)
mv_name	char(128)
state	char(32)
base_table_database_name	char(128)

pg_catalog.stl_query_detail

old
column	data type
user_id	int4
query_id	int8
child_query_id	int4
child_query_sequence	int4
stream_id	int4
segment_id	int4
step_id	int4
slice	int4
starttime	timestamp
endtime	timestamp
step_name	int4
table_id	int4
table_name	char(136)
input_rows	int8
input_bytes	int8
output_rows	int8
output_bytes	int8
is_rrscan	char(1)
blocks_read	int8
blocks_write	int8
local_read_io	int8
remote_read_io	int8
alert	char(1024)
internal_query	char(1)
source	char(64)
cpu_time	int8

new
column	data type
user_id	int4
query_id	int8
child_query_id	int4
child_query_sequence	int4
stream_id	int4
segment_id	int4
step_id	int4
slice	int4
starttime	timestamp
endtime	timestamp
step_name	int4
table_id	int4
table_name	char(136)
input_rows	int8
input_bytes	int8
output_rows	int8
output_bytes	int8
is_rrscan	char(1)
blocks_read	int8
blocks_write	int8
local_read_io	int8
remote_read_io	int8
alert	char(1024)
internal_query	char(1)
source	char(64)
cpu_time	int8
spilled_block_local_disk	int8
spilled_block_remote_disk	int8

pg_catalog.stl_stored_proc_messages

old
column	data type
userid	int4
query	int4
loglevel	int4
message	char(1024)
linenum	int4
recordtime	timestamp

new
column	data type
userid	int4
query	int4
loglevel	int4
message	char(1024)
linenum	int4
recordtime	timestamp
message_xid	int8

pg_catalog.stl_superblock_trickle_validation_stats

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

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

pg_catalog.stl_user_query_text

old
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
start_time	timestamp
sequence	int4
text	char(200)

new
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
start_time	timestamp
sequence	int4
text	char(4000)

pg_catalog.stl_wlm_service_class_config

old
column	data type
service_class	int4
queueing_strategy	char(32)
num_query_tasks	int4
target_num_query_tasks	int4
evictable	char(8)
eviction_threshold	int8
query_working_mem	int4
target_query_working_mem	int4
min_step_mem	int4
name	char(64)
max_execution_time	int4
user_group_wild_card	char(8)
query_group_wild_card	char(8)
concurrency_scaling	char(20)
query_priority	char(20)
eventtime	timestamp

new
column	data type
service_class	int4
queueing_strategy	char(32)
num_query_tasks	int4
target_num_query_tasks	int4
evictable	char(8)
eviction_threshold	int8
query_working_mem	int4
target_query_working_mem	int4
min_step_mem	int4
name	char(64)
max_execution_time	int4
user_group_wild_card	char(8)
query_group_wild_card	char(8)
concurrency_scaling	char(20)
query_priority	char(20)
eventtime	timestamp
user_role_wild_card	char(8)

pg_catalog.svl_stored_proc_messages

old
column	data type
userid	int4
session_userid	int4
pid	int4
xid	int8
query	int4
recordtime	timestamp
loglevel	int4
loglevel_text	text
message	char(1024)
linenum	int4
querytxt	char(500)
label	char(320)
aborted	int4

new
column	data type
userid	int4
session_userid	int4
pid	int4
xid	int8
query	int4
recordtime	timestamp
loglevel	int4
loglevel_text	text
message	char(1024)
linenum	int4
querytxt	char(500)
label	char(320)
aborted	int4
message_xid	int8

pg_catalog.svv_redshift_tables

old
column	data type
database_name	varchar(128)
schema_name	varchar(128)
table_name	varchar(128)
table_type	varchar(128)
table_acl	varchar(128)
remarks	varchar(128)

new
column	data type
database_name	varchar(128)
schema_name	varchar(128)
table_name	varchar(128)
table_type	varchar(128)
table_acl	varchar(128)
remarks	varchar(128)
table_owner	varchar(128)

pg_catalog.sys_query_detail

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

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

pg_catalog.sys_query_text

old
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
start_time	timestamp
sequence	int4
text	char(200)

new
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
start_time	timestamp
sequence	int4
text	char(4000)