Redshift Research Project System Table Tracker

Tables

pg_internal.redshift_auto_health_check_20739905

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_perf_channel_sink

old
column	data type	PK	U	NN
query_id	int4			NN
segment_number	int4			NN
slice_number	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
channel_type	int4			NN
channel_id	int4			NN
first_packet_time	int8			NN
last_packet_time	int8			NN
close_time	int8			NN
throughput_kb_sec	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

new
column	data type	PK	U	NN
query_id	int4			NN
segment_number	int4			NN
slice_number	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
channel_type	int4			NN
channel_id	int4			NN
first_packet_time	int8			NN
last_packet_time	int8			NN
close_time	int8			NN
throughput_kilobytes_per_sec	int8			NN
xoff_total_time	int8			NN
xoff_max_time	int8			NN
queue_delay_total_time	int8			NN
queue_delay_max_time	int8			NN
rexmit_total_count	int8			NN
rexmit_max_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_perf_channel_source

old
column	data type	PK	U	NN
query_id	int4			NN
segment_number	int4			NN
slice_number	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
channel_type	int4			NN
channel_id	int4			NN
first_packet_time	int8			NN
last_packet_time	int8			NN
close_time	int8			NN
throughput_kb_sec	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

new
column	data type	PK	U	NN
query_id	int4			NN
segment_number	int4			NN
slice_number	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
channel_type	int4			NN
channel_id	int4			NN
first_packet_time	int8			NN
last_packet_time	int8			NN
close_time	int8			NN
throughput_kilobytes_per_sec	int8			NN
borrow_total_time	int8			NN
borrow_max_time	int8			NN
queue_delay_total_time	int8			NN
queue_delay_max_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.stll_perf_channel_sink

old
column	data type	PK	U	NN
query_id	int4			NN
segment_number	int4			NN
slice_number	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
channel_type	int4			NN
channel_id	int4			NN
first_packet_time	timestamp			NN
last_packet_time	timestamp			NN
close_time	timestamp			NN
throughput_kb_sec	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

new
column	data type	PK	U	NN
query_id	int4			NN
segment_number	int4			NN
slice_number	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
channel_type	int4			NN
channel_id	int4			NN
first_packet_time	timestamp			NN
last_packet_time	timestamp			NN
close_time	timestamp			NN
throughput_kilobytes_per_sec	int8			NN
xoff_total_time	int8			NN
xoff_max_time	int8			NN
queue_delay_total_time	int8			NN
queue_delay_max_time	int8			NN
rexmit_total_count	int8			NN
rexmit_max_count	int8			NN

pg_catalog.stll_perf_channel_source

old
column	data type	PK	U	NN
query_id	int4			NN
segment_number	int4			NN
slice_number	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
channel_type	int4			NN
channel_id	int4			NN
first_packet_time	timestamp			NN
last_packet_time	timestamp			NN
close_time	timestamp			NN
throughput_kb_sec	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

new
column	data type	PK	U	NN
query_id	int4			NN
segment_number	int4			NN
slice_number	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
channel_type	int4			NN
channel_id	int4			NN
first_packet_time	timestamp			NN
last_packet_time	timestamp			NN
close_time	timestamp			NN
throughput_kilobytes_per_sec	int8			NN
borrow_total_time	int8			NN
borrow_max_time	int8			NN
queue_delay_total_time	int8			NN
queue_delay_max_time	int8			NN

pg_catalog.stcs_connection_error_log

old
column	data type	PK	U	NN
time	int8			NN
pid	int8			NN
event	char(64)			NN
hostname	char(64)			NN
unixsocketname	char(64)			NN
familydesc	char(64)			NN
portnumber	int4			NN
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

pg_catalog.stcs_connection_queue_error_log

old
column	data type	PK	U	NN
time	int8			NN
pid	int8			NN
event	char(64)			NN
remote_host	char(50)			NN
remote_port	char(50)			NN
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

pg_catalog.stcs_guid_based_cache_policy_stats

old
column	data type	PK	U	NN
node_num	int4			NN
promote_untracked_to_cold_untouch	int8			NN
promote_cold_untouch_to_cold_touch	int8			NN
promote_cold_touch_to_hot_untouch	int8			NN
promote_hot_untouch_to_hot_touch	int8			NN
reaccess_hot_touch	int8			NN
demote_hot_touch_to_hot_untouch	int8			NN
demote_hot_untouch_to_cold_touch	int8			NN
demote_cold_touch_to_cold_untouch	int8			NN
demote_cold_untouch_to_untracked	int8			NN
cold_blocks	int8			NN
hot_blocks	int8			NN
blocks_in_cache	int8			NN
start_time	int8			NN
end_time	int8			NN
capacity	int8			NN
write_accesses	int8			NN
rerep_writes	int8			NN
hot_touched_blocks	int8			NN
hot_untouched_blocks	int8			NN
cold_touched_blocks	int8			NN
cold_untouched_blocks	int8			NN
ghost_buffer_hits	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_query_abort_reason

old
column	data type	PK	U	NN
recordtime	int8			NN
start_time	int8			NN
qid	int4			NN
pid	int4			NN
xid	int8			NN
userid	int4			NN
reason	char(32)			NN
exception_msg	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

new
column	data type	PK	U	NN

pg_catalog.stcs_session_signal

old
column	data type	PK	U	NN
eventtime	int8			NN
userid	int4			NN
src_pid	int4			NN
target_pid	int4			NN
target_vpid	int4			NN
signal	int4			NN
reason	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

pg_catalog.stcs_tbl_perm_at_drop

old
column	data type	PK	U	NN
table_id	int4			NN
node	int4			NN
num_blocks	int4			NN
dist_style	int4			NN
temp	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_connection_error_log

old
column	data type	PK	U	NN
time	timestamp			NN
pid	int8			NN
event	char(64)			NN
hostname	char(64)			NN
unixsocketname	char(64)			NN
familydesc	char(64)			NN
portnumber	int4			NN
error_code	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_connection_queue_error_log

old
column	data type	PK	U	NN
time	timestamp			NN
pid	int8			NN
event	char(64)			NN
remote_host	char(50)			NN
remote_port	char(50)			NN
error_code	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_guid_based_cache_policy_stats

old
column	data type	PK	U	NN
node_num	int4			NN
promote_untracked_to_cold_untouch	int8			NN
promote_cold_untouch_to_cold_touch	int8			NN
promote_cold_touch_to_hot_untouch	int8			NN
promote_hot_untouch_to_hot_touch	int8			NN
reaccess_hot_touch	int8			NN
demote_hot_touch_to_hot_untouch	int8			NN
demote_hot_untouch_to_cold_touch	int8			NN
demote_cold_touch_to_cold_untouch	int8			NN
demote_cold_untouch_to_untracked	int8			NN
cold_blocks	int8			NN
hot_blocks	int8			NN
blocks_in_cache	int8			NN
start_time	timestamp			NN
end_time	timestamp			NN
capacity	int8			NN
write_accesses	int8			NN
rerep_writes	int8			NN
hot_touched_blocks	int8			NN
hot_untouched_blocks	int8			NN
cold_touched_blocks	int8			NN
cold_untouched_blocks	int8			NN
ghost_buffer_hits	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_query_abort_reason

old
column	data type	PK	U	NN
recordtime	timestamp			NN
start_time	timestamp			NN
qid	int4			NN
pid	int4			NN
xid	int8			NN
userid	int4			NN
reason	char(32)			NN
exception_msg	char(128)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_session_signal

old
column	data type	PK	U	NN
eventtime	timestamp			NN
userid	int4			NN
src_pid	int4			NN
target_pid	int4			NN
target_vpid	int4			NN
signal	int4			NN
reason	char(32)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_tbl_perm_at_drop

old
column	data type	PK	U	NN
table_id	int4			NN
node	int4			NN
num_blocks	int4			NN
dist_style	int4			NN
temp	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stv_guid_based_cache_policy_stats

old
column	data type	PK	U	NN
node_num	int4			NN
name	char(64)			NN
value	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stv_guid_based_local_block_cache_state

old
column	data type	PK	U	NN
guid	char(64)			NN
sb_pos	int4			NN
state	int4			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_2429952

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_perf_channel_sink

old
column	data type
query_id	int4
segment_number	int4
slice_number	int4
packet_count	int8
bytes_transferred	int8
channel_type	int4
channel_id	int4
first_packet_time	timestamp
last_packet_time	timestamp
close_time	timestamp
throughput_kb_sec	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

new
column	data type
query_id	int4
segment_number	int4
slice_number	int4
packet_count	int8
bytes_transferred	int8
channel_type	int4
channel_id	int4
first_packet_time	timestamp
last_packet_time	timestamp
close_time	timestamp
throughput_kilobytes_per_sec	int8
xoff_total_time	int8
xoff_max_time	int8
queue_delay_total_time	int8
queue_delay_max_time	int8
rexmit_total_count	int8
rexmit_max_count	int8

pg_catalog.stl_perf_channel_source

old
column	data type
query_id	int4
segment_number	int4
slice_number	int4
packet_count	int8
bytes_transferred	int8
channel_type	int4
channel_id	int4
first_packet_time	timestamp
last_packet_time	timestamp
close_time	timestamp
throughput_kb_sec	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

new
column	data type
query_id	int4
segment_number	int4
slice_number	int4
packet_count	int8
bytes_transferred	int8
channel_type	int4
channel_id	int4
first_packet_time	timestamp
last_packet_time	timestamp
close_time	timestamp
throughput_kilobytes_per_sec	int8
borrow_total_time	int8
borrow_max_time	int8
queue_delay_total_time	int8
queue_delay_max_time	int8

pg_catalog.svv_external_databases

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

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

pg_catalog.svv_redshift_databases

old
column	data type
database_name	varchar(128)
database_owner	int4
database_type	varchar(32)
database_acl	varchar(128)
database_options	varchar(128)

new
column	data type
database_name	varchar(128)
database_owner	int4
database_type	varchar(16)
database_acl	varchar(128)
database_options	varchar(128)

pg_catalog.stl_connection_error_log

old
column	data type
time	timestamp
pid	int8
event	char(64)
hostname	char(64)
unixsocketname	char(64)
familydesc	char(64)
portnumber	int4
error_code	int4

new
column	data type

pg_catalog.stl_connection_queue_error_log

old
column	data type
time	timestamp
pid	int8
event	char(64)
remote_host	char(50)
remote_port	char(50)
error_code	int4

new
column	data type

pg_catalog.stl_guid_based_cache_policy_stats

old
column	data type
node_num	int4
promote_untracked_to_cold_untouch	int8
promote_cold_untouch_to_cold_touch	int8
promote_cold_touch_to_hot_untouch	int8
promote_hot_untouch_to_hot_touch	int8
reaccess_hot_touch	int8
demote_hot_touch_to_hot_untouch	int8
demote_hot_untouch_to_cold_touch	int8
demote_cold_touch_to_cold_untouch	int8
demote_cold_untouch_to_untracked	int8
cold_blocks	int8
hot_blocks	int8
blocks_in_cache	int8
start_time	timestamp
end_time	timestamp
capacity	int8
write_accesses	int8
rerep_writes	int8
hot_touched_blocks	int8
hot_untouched_blocks	int8
cold_touched_blocks	int8
cold_untouched_blocks	int8
ghost_buffer_hits	int8

new
column	data type

pg_catalog.stl_query_abort_reason

old
column	data type
recordtime	timestamp
start_time	timestamp
qid	int4
pid	int4
xid	int8
userid	int4
reason	char(32)
exception_msg	char(128)

new
column	data type

pg_catalog.stl_session_signal

old
column	data type
eventtime	timestamp
userid	int4
src_pid	int4
target_pid	int4
target_vpid	int4
signal	int4
reason	char(32)

new
column	data type

pg_catalog.stl_tbl_perm_at_drop

old
column	data type
table_id	int4
node	int4
num_blocks	int4
dist_style	int4
temp	int4

new
column	data type

pg_catalog.svl_datashare_cross_region_usage

old
column	data type
query	int4
segment	int8
start_time	int8
end_time	int8
transferred_data	int8
source_region	char(64)

new
column	data type

pg_catalog.sys_copy_job

old
column	data type
job_id	oid
job_name	text
job_owner	int4
table_id	oid
data_source	text
iam_role	text
copy_query	text
is_auto	bool
on_error_suspend	bool

new
column	data type

pg_catalog.sys_unload_detail

old
column	data type
user_id	int4
query_id	int8
session_id	int4
transaction_id	int8
path	char(1280)
start_time	timestamp
end_time	timestamp
line_count	int8
transfer_size	int8
file_format	char(10)

new
column	data type