Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
new	information_schema	sql	immutable	int4	_pg_interval_precision	oid,int4
new	information_schema	sql	immutable	varchar	_pg_interval_type	oid,int4

Tables

pg_catalog.stcs_backend_slot

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	int8			NN
pid	int4			NN
event	char(30)			NN
slots	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_compute_elasticity_insert

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
ds_calc_option	int4			NN
parallel_insert_degree	int4			NN
parallel_insert_reason	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_copy_job_info

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
job_id	int8			NN
job_name	char(128)			NN
transaction_id	int8			NN
database_name	char(128)			NN
record_time	int8			NN
message	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_backend_slot

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	timestamp			NN
pid	int4			NN
event	char(30)			NN
slots	int4			NN

pg_catalog.stll_compute_elasticity_insert

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
ds_calc_option	int4			NN
parallel_insert_degree	int4			NN
parallel_insert_reason	int4			NN

pg_catalog.stll_copy_job_info

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
job_id	int8			NN
job_name	char(128)			NN
transaction_id	int8			NN
database_name	char(128)			NN
record_time	timestamp			NN
message	char(512)			NN

pg_internal.redshift_auto_health_check_4400005

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

old
column	data type	PK	U	NN
shareid	oid			NN
consumeraccount	name			NN
consumernamespace	name			NN
sharedate	timestamp			NN

new
column	data type	PK	U	NN
shareid	oid			NN
consumeraccount	name			NN
consumernamespace	name			NN
sharedate	timestamp			NN
pseudouser	int4			NN

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

old
column	data type	PK	U	NN
request_id	char(100)			NN
billing_time	char(100)			NN
usage_rpu_sec	int4			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
is_burst	int4			NN
cluster_arn	char(128)			NN
usage_sec	int4			NN
usage_sec_before_minimum	int4			NN
interval_billed_starttime	int8			NN
interval_billed_endtime	int8			NN
cluster_rpus	int4			NN
report_time	int8			NN
interval_starttime	int8			NN
interval_endtime	int8			NN
resv_model	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
request_id	char(100)			NN
billing_time	char(100)			NN
usage_rpu_sec	int4			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
is_burst	int4			NN
cluster_arn	char(128)			NN
usage_sec	int4			NN
usage_sec_before_minimum	int4			NN
interval_billed_starttime	int8			NN
interval_billed_endtime	int8			NN
cluster_rpus	int4			NN
report_time	int8			NN
interval_starttime	int8			NN
interval_endtime	int8			NN
resv_model	int4			NN
auto_task_usage_sec	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_connection_log

old
column	data type	PK	U	NN
event	char(50)			NN
recordtime	int8			NN
remotehost	char(32)			NN
remoteport	char(32)			NN
pid	int4			NN
dbname	char(50)			NN
username	char(50)			NN
authmethod	char(32)			NN
duration	int8			NN
sslversion	char(50)			NN
sslcipher	char(128)			NN
mtu	int4			NN
sslcompression	char(64)			NN
sslexpansion	char(64)			NN
iamauthguid	char(36)			NN
application_name	char(250)			NN
os_version	char(64)			NN
driver_version	char(64)			NN
plugin_name	char(32)			NN
protocol_version	int4			NN
sessionid	char(36)			NN
compression	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
event	char(50)			NN
recordtime	int8			NN
remotehost	char(45)			NN
remoteport	char(32)			NN
pid	int4			NN
dbname	char(50)			NN
username	char(50)			NN
authmethod	char(32)			NN
duration	int8			NN
sslversion	char(50)			NN
sslcipher	char(128)			NN
mtu	int4			NN
sslcompression	char(64)			NN
sslexpansion	char(64)			NN
iamauthguid	char(36)			NN
application_name	char(250)			NN
os_version	char(64)			NN
driver_version	char(64)			NN
plugin_name	char(32)			NN
protocol_version	int4			NN
sessionid	char(36)			NN
compression	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

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
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
num_cols_grafted	int4			NN
total_num_cols	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
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
num_cols_grafted	int4			NN
total_num_cols	int4			NN
graft_batch_num	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_delete

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

old
column	data type	PK	U	NN
resizeid	char(128)			NN
starttime	int8			NN
resizephase	char(32)			NN
resizeplanstate	char(32)			NN
nodenum	int4			NN
globalslicenum	int4			NN
localslicenum	int4			NN
datablocks	int4			NN
metadatablocks	int4			NN
distallblocks	int4			NN
metachainblocks	int4			NN
blockchainmetachainblocks	int4			NN
leadersnapshotblocks	int4			NN
pgwalblocks	int4			NN
rows	int8			NN
distallrows	int8			NN
persist_temp_tables_state	char(100)			NN
temp_blocks	int4			NN
temp_distall_blocks	int4			NN
temp_rows	int8			NN
temp_distall_rows	int8			NN
src_nodenum	int4			NN
src_localslicenum	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
resizeid	char(128)			NN
starttime	int8			NN
resizephase	char(32)			NN
resizeplanstate	char(32)			NN
nodenum	int4			NN
globalslicenum	int4			NN
localslicenum	int4			NN
datablocks	int4			NN
metadatablocks	int4			NN
distallblocks	int4			NN
metachainblocks	int4			NN
blockchainmetachainblocks	int4			NN
leadersnapshotblocks	int4			NN
pgwalblocks	int4			NN
rows	int8			NN
distallrows	int8			NN
persist_temp_tables_state	char(100)			NN
temp_blocks	int4			NN
temp_distall_blocks	int4			NN
temp_rows	int8			NN
temp_distall_rows	int8			NN
src_nodenum	int4			NN
src_localslicenum	int4			NN
incresize_mapping_method	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_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
inserted_mega_value	char(1)			NN
use_staging_table	char(1)			NN
write_xid	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
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
use_staging_table	char(1)			NN
write_xid	int8			NN
reserve_rowid	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_internal_query_details

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
initial_query_time	int8			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
reported_peak_usage_bytes	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
exec_time_wo_compilation	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	int4			NN
xid	int8			NN
initial_query_time	int8			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
reported_peak_usage_bytes	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
exec_time_wo_compilation	int8			NN
exec_cluster_size	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_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_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
queue_delay_sample_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_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
queue_delay_sample_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_query_heap_memory_usage

old
column	data type	PK	U	NN
recordtime	int8			NN
pid	int4			NN
xid	int8			NN
userid	int4			NN
checkpoint	int4			NN
heap_mem_usage	int8			NN
heap_max_mem_usage	int8			NN
query	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
recordtime	int8			NN
pid	int4			NN
xid	int8			NN
userid	int4			NN
checkpoint	int4			NN
heap_mem_usage	int8			NN
heap_max_mem_usage	int8			NN
query	int8			NN
identifier	int8			NN
lw_lock_wait_time_us	int8			NN
pg_lock_wait_time_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_restarted_sessions

old
column	data type	PK	U	NN
currenttime	int8			NN
dbname	char(50)			NN
newpid	int4			NN
oldpid	int4			NN
username	char(50)			NN
remotehost	char(32)			NN
remoteport	char(32)			NN
parkedtime	int8			NN
session_vars	char(2000)			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
currenttime	int8			NN
dbname	char(50)			NN
newpid	int4			NN
oldpid	int4			NN
username	char(50)			NN
remotehost	char(45)			NN
remoteport	char(32)			NN
parkedtime	int8			NN
session_vars	char(2000)			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_summary

old
column	data type	PK	U	NN
node	int4			NN
record_time	int8			NN
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_blocks_validated	int8			NN
log_entries_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
tree_trickle_validation_done	int4			NN
trickle_validation_done	int4			NN
num_steps_trickle_validation	int4			NN
log_rotation_done	int4			NN
num_steps_log_rotation	int4			NN
snapshot_sb_ckpt_hdrs_remaining	int8			NN
snapshot_sb_num_log_blocks	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
node	int4			NN
record_time	int8			NN
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_blocks_validated	int8			NN
log_entries_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
tree_trickle_validation_done	int4			NN
trickle_validation_done	int4			NN
num_steps_trickle_validation	int4			NN
log_rotation_done	int4			NN
num_steps_log_rotation	int4			NN
snapshot_sb_ckpt_hdrs_remaining	int8			NN
snapshot_sb_num_log_blocks	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_xrestore

old
column	data type	PK	U	NN
backup_id	char(256)			NN
node	int4			NN
catalog_download_start_time	int8			NN
catalog_download_end_time	int8			NN
slice_transfer_start_time	int8			NN
slice_transfer_end_time	int8			NN
guid_pool_hit_rate	float8			NN
num_guids_created_on_demand	int4			NN
node_occ_mean	float8			NN
node_occ_variance	float8			NN
data_skew_cluster	float8			NN
xrestore_type	int4			NN
xrestore_source	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
backup_id	char(256)			NN
node	int4			NN
catalog_download_start_time	int8			NN
catalog_download_end_time	int8			NN
slice_transfer_start_time	int8			NN
slice_transfer_end_time	int8			NN
guid_pool_hit_rate	float8			NN
num_guids_created_on_demand	int4			NN
node_occ_mean	float8			NN
node_occ_variance	float8			NN
data_skew_cluster	float8			NN
xrestore_type	int4			NN
xrestore_source	int4			NN
slice_remapping_policy	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_xrestore_alter_distkey

old
column	data type	PK	U	NN
pid	int4			NN
xid	int8			NN
tbl	int4			NN
column_name	char(200)			NN
event_time	int8			NN
message	char(350)			NN
elapsed_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
pid	int4			NN
xid	int8			NN
tbl	int4			NN
column_name	char(200)			NN
event_time	int8			NN
message	char(350)			NN
elapsed_us	int8			NN
message_code	int4			NN
task_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_xrestore_cluster_level_distkey_tables

old
column	data type	PK	U	NN
tbl	int4			NN
action	char(64)			NN
event_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
tbl	int4			NN
action	char(64)			NN
event_time	int8			NN
task_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.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

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

pg_catalog.stll_arcadia_billing_ris_reports

old
column	data type	PK	U	NN
request_id	char(100)			NN
billing_time	char(100)			NN
usage_rpu_sec	int4			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
is_burst	int4			NN
cluster_arn	char(128)			NN
usage_sec	int4			NN
usage_sec_before_minimum	int4			NN
interval_billed_starttime	timestamp			NN
interval_billed_endtime	timestamp			NN
cluster_rpus	int4			NN
report_time	timestamp			NN
interval_starttime	timestamp			NN
interval_endtime	timestamp			NN
resv_model	int4			NN

new
column	data type	PK	U	NN
request_id	char(100)			NN
billing_time	char(100)			NN
usage_rpu_sec	int4			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
is_burst	int4			NN
cluster_arn	char(128)			NN
usage_sec	int4			NN
usage_sec_before_minimum	int4			NN
interval_billed_starttime	timestamp			NN
interval_billed_endtime	timestamp			NN
cluster_rpus	int4			NN
report_time	timestamp			NN
interval_starttime	timestamp			NN
interval_endtime	timestamp			NN
resv_model	int4			NN
auto_task_usage_sec	int4			NN

pg_catalog.stll_connection_log

old
column	data type	PK	U	NN
event	char(50)			NN
recordtime	timestamp			NN
remotehost	char(32)			NN
remoteport	char(32)			NN
pid	int4			NN
dbname	char(50)			NN
username	char(50)			NN
authmethod	char(32)			NN
duration	int8			NN
sslversion	char(50)			NN
sslcipher	char(128)			NN
mtu	int4			NN
sslcompression	char(64)			NN
sslexpansion	char(64)			NN
iamauthguid	char(36)			NN
application_name	char(250)			NN
os_version	char(64)			NN
driver_version	char(64)			NN
plugin_name	char(32)			NN
protocol_version	int4			NN
sessionid	char(36)			NN
compression	char(16)			NN

new
column	data type	PK	U	NN
event	char(50)			NN
recordtime	timestamp			NN
remotehost	char(45)			NN
remoteport	char(32)			NN
pid	int4			NN
dbname	char(50)			NN
username	char(50)			NN
authmethod	char(32)			NN
duration	int8			NN
sslversion	char(50)			NN
sslcipher	char(128)			NN
mtu	int4			NN
sslcompression	char(64)			NN
sslexpansion	char(64)			NN
iamauthguid	char(36)			NN
application_name	char(250)			NN
os_version	char(64)			NN
driver_version	char(64)			NN
plugin_name	char(32)			NN
protocol_version	int4			NN
sessionid	char(36)			NN
compression	char(16)			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
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
num_cols_grafted	int4			NN
total_num_cols	int4			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
num_cols_grafted	int4			NN
total_num_cols	int4			NN
graft_batch_num	int4			NN

pg_catalog.stll_delete

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
write_xid	int8			NN

pg_catalog.stll_incremental_resize_state

old
column	data type	PK	U	NN
resizeid	char(128)			NN
starttime	timestamp			NN
resizephase	char(32)			NN
resizeplanstate	char(32)			NN
nodenum	int4			NN
globalslicenum	int4			NN
localslicenum	int4			NN
datablocks	int4			NN
metadatablocks	int4			NN
distallblocks	int4			NN
metachainblocks	int4			NN
blockchainmetachainblocks	int4			NN
leadersnapshotblocks	int4			NN
pgwalblocks	int4			NN
rows	int8			NN
distallrows	int8			NN
persist_temp_tables_state	char(100)			NN
temp_blocks	int4			NN
temp_distall_blocks	int4			NN
temp_rows	int8			NN
temp_distall_rows	int8			NN
src_nodenum	int4			NN
src_localslicenum	int4			NN

new
column	data type	PK	U	NN
resizeid	char(128)			NN
starttime	timestamp			NN
resizephase	char(32)			NN
resizeplanstate	char(32)			NN
nodenum	int4			NN
globalslicenum	int4			NN
localslicenum	int4			NN
datablocks	int4			NN
metadatablocks	int4			NN
distallblocks	int4			NN
metachainblocks	int4			NN
blockchainmetachainblocks	int4			NN
leadersnapshotblocks	int4			NN
pgwalblocks	int4			NN
rows	int8			NN
distallrows	int8			NN
persist_temp_tables_state	char(100)			NN
temp_blocks	int4			NN
temp_distall_blocks	int4			NN
temp_rows	int8			NN
temp_distall_rows	int8			NN
src_nodenum	int4			NN
src_localslicenum	int4			NN
incresize_mapping_method	int4			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
inserted_mega_value	char(1)			NN
use_staging_table	char(1)			NN
write_xid	int8			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
use_staging_table	char(1)			NN
write_xid	int8			NN
reserve_rowid	int4			NN

pg_catalog.stll_internal_query_details

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
initial_query_time	timestamp			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
reported_peak_usage_bytes	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
exec_time_wo_compilation	int8			NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
initial_query_time	timestamp			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
reported_peak_usage_bytes	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
exec_time_wo_compilation	int8			NN
exec_cluster_size	int4			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_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
queue_delay_sample_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_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
queue_delay_sample_count	int8			NN

pg_catalog.stll_query_heap_memory_usage

old
column	data type	PK	U	NN
recordtime	timestamp			NN
pid	int4			NN
xid	int8			NN
userid	int4			NN
checkpoint	int4			NN
heap_mem_usage	int8			NN
heap_max_mem_usage	int8			NN
query	int8			NN

new
column	data type	PK	U	NN
recordtime	timestamp			NN
pid	int4			NN
xid	int8			NN
userid	int4			NN
checkpoint	int4			NN
heap_mem_usage	int8			NN
heap_max_mem_usage	int8			NN
query	int8			NN
identifier	int8			NN
lw_lock_wait_time_us	int8			NN
pg_lock_wait_time_us	int8			NN

pg_catalog.stll_restarted_sessions

old
column	data type	PK	U	NN
currenttime	timestamp			NN
dbname	char(50)			NN
newpid	int4			NN
oldpid	int4			NN
username	char(50)			NN
remotehost	char(32)			NN
remoteport	char(32)			NN
parkedtime	timestamp			NN
session_vars	char(2000)			NN

new
column	data type	PK	U	NN
currenttime	timestamp			NN
dbname	char(50)			NN
newpid	int4			NN
oldpid	int4			NN
username	char(50)			NN
remotehost	char(45)			NN
remoteport	char(32)			NN
parkedtime	timestamp			NN
session_vars	char(2000)			NN

pg_catalog.stll_superblock_trickle_validation_summary

old
column	data type	PK	U	NN
node	int4			NN
record_time	timestamp			NN
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_blocks_validated	int8			NN
log_entries_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
tree_trickle_validation_done	int4			NN
trickle_validation_done	int4			NN
num_steps_trickle_validation	int4			NN
log_rotation_done	int4			NN
num_steps_log_rotation	int4			NN
snapshot_sb_ckpt_hdrs_remaining	int8			NN
snapshot_sb_num_log_blocks	int8			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_blocks_validated	int8			NN
log_entries_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
tree_trickle_validation_done	int4			NN
trickle_validation_done	int4			NN
num_steps_trickle_validation	int4			NN
log_rotation_done	int4			NN
num_steps_log_rotation	int4			NN
snapshot_sb_ckpt_hdrs_remaining	int8			NN
snapshot_sb_num_log_blocks	int8			NN
start_time	timestamp			NN

pg_catalog.stll_xrestore

old
column	data type	PK	U	NN
backup_id	char(256)			NN
node	int4			NN
catalog_download_start_time	timestamp			NN
catalog_download_end_time	timestamp			NN
slice_transfer_start_time	timestamp			NN
slice_transfer_end_time	timestamp			NN
guid_pool_hit_rate	float8			NN
num_guids_created_on_demand	int4			NN
node_occ_mean	float8			NN
node_occ_variance	float8			NN
data_skew_cluster	float8			NN
xrestore_type	int4			NN
xrestore_source	int4			NN

new
column	data type	PK	U	NN
backup_id	char(256)			NN
node	int4			NN
catalog_download_start_time	timestamp			NN
catalog_download_end_time	timestamp			NN
slice_transfer_start_time	timestamp			NN
slice_transfer_end_time	timestamp			NN
guid_pool_hit_rate	float8			NN
num_guids_created_on_demand	int4			NN
node_occ_mean	float8			NN
node_occ_variance	float8			NN
data_skew_cluster	float8			NN
xrestore_type	int4			NN
xrestore_source	int4			NN
slice_remapping_policy	int4			NN

pg_catalog.stll_xrestore_alter_distkey

old
column	data type	PK	U	NN
pid	int4			NN
xid	int8			NN
tbl	int4			NN
column_name	char(200)			NN
event_time	timestamp			NN
message	char(350)			NN
elapsed_us	int8			NN

new
column	data type	PK	U	NN
pid	int4			NN
xid	int8			NN
tbl	int4			NN
column_name	char(200)			NN
event_time	timestamp			NN
message	char(350)			NN
elapsed_us	int8			NN
message_code	int4			NN
task_type	int4			NN

pg_catalog.stll_xrestore_cluster_level_distkey_tables

old
column	data type	PK	U	NN
tbl	int4			NN
action	char(64)			NN
event_time	timestamp			NN

new
column	data type	PK	U	NN
tbl	int4			NN
action	char(64)			NN
event_time	timestamp			NN
task_type	int4			NN

pg_catalog.stv_storage_oid_map

old
column	data type	PK	U	NN
key	char(128)			NN
storage_oid	int8			NN
external_oid	int8			NN
host	char(64)			NN
db_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
ddl_end_version	int8			NN
grafted_sb_version	int8			NN
current_dml_end_version	int8			NN
current_structure_chg_version	int8			NN
target_dml_end_version	int8			NN
target_structure_chg_version	int8			NN
in_grafting	int4			NN
ref_count	int4			NN
marked_for_deletion	int4			NN
last_accessed_time	timestamp			NN
size	int8			NN

new
column	data type	PK	U	NN
key	char(128)			NN
storage_oid	int8			NN
external_oid	int8			NN
host	char(64)			NN
db_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
ddl_end_version	int8			NN
grafted_sb_version	int8			NN
current_dml_end_version	int8			NN
current_structure_chg_version	int8			NN
target_dml_end_version	int8			NN
target_structure_chg_version	int8			NN
in_grafting	int4			NN
ref_count	int4			NN
marked_for_deletion	int4			NN
last_accessed_time	timestamp			NN
size	int8			NN
dirtiness_type	char(20)			NN

pg_catalog.stv_xrestore_alter_queue_state

old
column	data type	PK	U	NN
userid	int4			NN
db_id	int4			NN
schema	char(128)			NN
table_name	char(128)			NN
tbl	int4			NN
status	char(64)			NN

new
column	data type	PK	U	NN
userid	int4			NN
db_id	int4			NN
schema	char(128)			NN
table_name	char(128)			NN
tbl	int4			NN
status	char(64)			NN
task_type	int4			NN

pg_catalog.stv_xrestore_state

old
column	data type	PK	U	NN
userid	int4			NN
database_id	int4			NN
schema_id	int4			NN
table_id	int4			NN
table_name	char(128)			NN
status	char(64)			NN

new
column	data type	PK	U	NN
userid	int4			NN
database_id	int4			NN
schema_id	int4			NN
table_id	int4			NN
table_name	char(128)			NN
status	char(64)			NN
task_type	int4			NN

pg_internal.redshift_auto_health_check_4318764

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_backend_slot

old
column	data type

new
column	data type
recordtime	timestamp
pid	int4
event	char(30)
slots	int4

pg_catalog.stl_compute_elasticity_insert

old
column	data type

new
column	data type
query	int4
slice	int4
segment	int4
step	int4
ds_calc_option	int4
parallel_insert_degree	int4
parallel_insert_reason	int4

pg_catalog.stl_copy_job_info

old
column	data type

new
column	data type
user_id	int4
job_id	int8
job_name	char(128)
transaction_id	int8
database_name	char(128)
record_time	timestamp
message	char(512)

pg_catalog.sys_copy_job_info

old
column	data type

new
column	data type
job_id	int8
job_name	char(128)
database_name	char(128)
record_time	timestamp
message	char(512)

pg_catalog.sys_restore_log

old
column	data type

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

information_schema.columns

old
column	data type
table_catalog	sql_identifier
table_schema	sql_identifier
table_name	sql_identifier
column_name	sql_identifier
ordinal_position	cardinal_number
column_default	character_data
is_nullable	character_data
data_type	character_data
character_maximum_length	cardinal_number
character_octet_length	cardinal_number
numeric_precision	cardinal_number
numeric_precision_radix	cardinal_number
numeric_scale	cardinal_number
datetime_precision	cardinal_number
interval_type	character_data
interval_precision	character_data
character_set_catalog	sql_identifier
character_set_schema	sql_identifier
character_set_name	sql_identifier
collation_catalog	sql_identifier
collation_schema	sql_identifier
collation_name	sql_identifier
domain_catalog	sql_identifier
domain_schema	sql_identifier
domain_name	sql_identifier
udt_catalog	sql_identifier
udt_schema	sql_identifier
udt_name	sql_identifier
scope_catalog	sql_identifier
scope_schema	sql_identifier
scope_name	sql_identifier
maximum_cardinality	cardinal_number
dtd_identifier	sql_identifier
is_self_referencing	character_data

new
column	data type
table_catalog	sql_identifier
table_schema	sql_identifier
table_name	sql_identifier
column_name	sql_identifier
ordinal_position	cardinal_number
column_default	character_data
is_nullable	character_data
data_type	character_data
character_maximum_length	cardinal_number
character_octet_length	cardinal_number
numeric_precision	cardinal_number
numeric_precision_radix	cardinal_number
numeric_scale	cardinal_number
datetime_precision	cardinal_number
interval_type	character_data
interval_precision	cardinal_number
character_set_catalog	sql_identifier
character_set_schema	sql_identifier
character_set_name	sql_identifier
collation_catalog	sql_identifier
collation_schema	sql_identifier
collation_name	sql_identifier
domain_catalog	sql_identifier
domain_schema	sql_identifier
domain_name	sql_identifier
udt_catalog	sql_identifier
udt_schema	sql_identifier
udt_name	sql_identifier
scope_catalog	sql_identifier
scope_schema	sql_identifier
scope_name	sql_identifier
maximum_cardinality	cardinal_number
dtd_identifier	sql_identifier
is_self_referencing	character_data

information_schema.domains

old
column	data type
domain_catalog	sql_identifier
domain_schema	sql_identifier
domain_name	sql_identifier
data_type	character_data
character_maximum_length	cardinal_number
character_octet_length	cardinal_number
character_set_catalog	sql_identifier
character_set_schema	sql_identifier
character_set_name	sql_identifier
collation_catalog	sql_identifier
collation_schema	sql_identifier
collation_name	sql_identifier
numeric_precision	cardinal_number
numeric_precision_radix	cardinal_number
numeric_scale	cardinal_number
datetime_precision	cardinal_number
interval_type	character_data
interval_precision	character_data
domain_default	character_data
udt_catalog	sql_identifier
udt_schema	sql_identifier
udt_name	sql_identifier
scope_catalog	sql_identifier
scope_schema	sql_identifier
scope_name	sql_identifier
maximum_cardinality	cardinal_number
dtd_identifier	sql_identifier

new
column	data type
domain_catalog	sql_identifier
domain_schema	sql_identifier
domain_name	sql_identifier
data_type	character_data
character_maximum_length	cardinal_number
character_octet_length	cardinal_number
character_set_catalog	sql_identifier
character_set_schema	sql_identifier
character_set_name	sql_identifier
collation_catalog	sql_identifier
collation_schema	sql_identifier
collation_name	sql_identifier
numeric_precision	cardinal_number
numeric_precision_radix	cardinal_number
numeric_scale	cardinal_number
datetime_precision	cardinal_number
interval_type	character_data
interval_precision	cardinal_number
domain_default	character_data
udt_catalog	sql_identifier
udt_schema	sql_identifier
udt_name	sql_identifier
scope_catalog	sql_identifier
scope_schema	sql_identifier
scope_name	sql_identifier
maximum_cardinality	cardinal_number
dtd_identifier	sql_identifier

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

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

pg_catalog.stl_arcadia_billing_ris_reports

old
column	data type
request_id	char(100)
billing_time	char(100)
usage_rpu_sec	int4
report_arn	char(128)
instance_type	char(128)
num_nodes	int4
is_burst	int4
cluster_arn	char(128)
usage_sec	int4
usage_sec_before_minimum	int4
interval_billed_starttime	timestamp
interval_billed_endtime	timestamp
cluster_rpus	int4
report_time	timestamp
interval_starttime	timestamp
interval_endtime	timestamp
resv_model	int4

new
column	data type
request_id	char(100)
billing_time	char(100)
usage_rpu_sec	int4
report_arn	char(128)
instance_type	char(128)
num_nodes	int4
is_burst	int4
cluster_arn	char(128)
usage_sec	int4
usage_sec_before_minimum	int4
interval_billed_starttime	timestamp
interval_billed_endtime	timestamp
cluster_rpus	int4
report_time	timestamp
interval_starttime	timestamp
interval_endtime	timestamp
resv_model	int4
auto_task_usage_sec	int4

pg_catalog.stl_connection_log

old
column	data type
event	char(50)
recordtime	timestamp
remotehost	char(32)
remoteport	char(32)
pid	int4
dbname	char(50)
username	char(50)
authmethod	char(32)
duration	int8
sslversion	char(50)
sslcipher	char(128)
mtu	int4
sslcompression	char(64)
sslexpansion	char(64)
iamauthguid	char(36)
application_name	char(250)
os_version	char(64)
driver_version	char(64)
plugin_name	char(32)
protocol_version	int4
sessionid	char(36)
compression	char(16)

new
column	data type
event	char(50)
recordtime	timestamp
remotehost	char(45)
remoteport	char(32)
pid	int4
dbname	char(50)
username	char(50)
authmethod	char(32)
duration	int8
sslversion	char(50)
sslcipher	char(128)
mtu	int4
sslcompression	char(64)
sslexpansion	char(64)
iamauthguid	char(36)
application_name	char(250)
os_version	char(64)
driver_version	char(64)
plugin_name	char(32)
protocol_version	int4
sessionid	char(36)
compression	char(16)

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

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
num_cols_grafted	int4
total_num_cols	int4
graft_batch_num	int4

pg_catalog.stl_delete

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

pg_catalog.stl_incremental_resize_state

old
column	data type
resizeid	char(128)
starttime	timestamp
resizephase	char(32)
resizeplanstate	char(32)
nodenum	int4
globalslicenum	int4
localslicenum	int4
datablocks	int4
metadatablocks	int4
distallblocks	int4
metachainblocks	int4
blockchainmetachainblocks	int4
leadersnapshotblocks	int4
pgwalblocks	int4
rows	int8
distallrows	int8
persist_temp_tables_state	char(100)
temp_blocks	int4
temp_distall_blocks	int4
temp_rows	int8
temp_distall_rows	int8
src_nodenum	int4
src_localslicenum	int4

new
column	data type
resizeid	char(128)
starttime	timestamp
resizephase	char(32)
resizeplanstate	char(32)
nodenum	int4
globalslicenum	int4
localslicenum	int4
datablocks	int4
metadatablocks	int4
distallblocks	int4
metachainblocks	int4
blockchainmetachainblocks	int4
leadersnapshotblocks	int4
pgwalblocks	int4
rows	int8
distallrows	int8
persist_temp_tables_state	char(100)
temp_blocks	int4
temp_distall_blocks	int4
temp_rows	int8
temp_distall_rows	int8
src_nodenum	int4
src_localslicenum	int4
incresize_mapping_method	int4

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
inserted_mega_value	char(1)
use_staging_table	char(1)
write_xid	int8

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)
use_staging_table	char(1)
write_xid	int8
reserve_rowid	int4

pg_catalog.stl_internal_query_details

old
column	data type
query	int4
xid	int8
initial_query_time	timestamp
seldispatch_status	int4
query_cmd_type	int4
user_temp_tables_accessed	int4
volt_temp_tables_accessed	int4
spectrum_tables_accessed	int4
user_perm_tables_accessed	int4
system_tables_accessed	int4
query_target_table_type	int4
memory_demanding_info	int8
nobackup_tables_accessed	int4
zindex_tables_accessed	int4
pg_tables_accessed	int4
dirty_tables_read	int4
wlm_slot_type	char(8)
is_short_query	int4
reported_peak_usage_bytes	int8
wlm_query_memory	int8
datasharing_tables_accessed	int4
uses_new_cost_model	char(1)
new_model_reason	int4
num_rowsets	int4
xregion_datasharing_tables_accessed	int4
result_cache_miss_reason	int4
cs_node_nums	int4
is_multi	int4
is_burst_for_at_task	int4
user_query_id	int8
lf_datasharing_tables_accessed	int4
qpc_source_qid	int8
exec_time_wo_compilation	int8

new
column	data type
query	int4
xid	int8
initial_query_time	timestamp
seldispatch_status	int4
query_cmd_type	int4
user_temp_tables_accessed	int4
volt_temp_tables_accessed	int4
spectrum_tables_accessed	int4
user_perm_tables_accessed	int4
system_tables_accessed	int4
query_target_table_type	int4
memory_demanding_info	int8
nobackup_tables_accessed	int4
zindex_tables_accessed	int4
pg_tables_accessed	int4
dirty_tables_read	int4
wlm_slot_type	char(8)
is_short_query	int4
reported_peak_usage_bytes	int8
wlm_query_memory	int8
datasharing_tables_accessed	int4
uses_new_cost_model	char(1)
new_model_reason	int4
num_rowsets	int4
xregion_datasharing_tables_accessed	int4
result_cache_miss_reason	int4
cs_node_nums	int4
is_multi	int4
is_burst_for_at_task	int4
user_query_id	int8
lf_datasharing_tables_accessed	int4
qpc_source_qid	int8
exec_time_wo_compilation	int8
exec_cluster_size	int4

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_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
queue_delay_sample_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_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
queue_delay_sample_count	int8

pg_catalog.stl_query_heap_memory_usage

old
column	data type
recordtime	timestamp
pid	int4
xid	int8
userid	int4
checkpoint	int4
heap_mem_usage	int8
heap_max_mem_usage	int8
query	int8

new
column	data type
recordtime	timestamp
pid	int4
xid	int8
userid	int4
checkpoint	int4
heap_mem_usage	int8
heap_max_mem_usage	int8
query	int8
identifier	int8
lw_lock_wait_time_us	int8
pg_lock_wait_time_us	int8

pg_catalog.stl_restarted_sessions

old
column	data type
currenttime	timestamp
dbname	char(50)
newpid	int4
oldpid	int4
username	char(50)
remotehost	char(32)
remoteport	char(32)
parkedtime	timestamp
session_vars	char(2000)

new
column	data type
currenttime	timestamp
dbname	char(50)
newpid	int4
oldpid	int4
username	char(50)
remotehost	char(45)
remoteport	char(32)
parkedtime	timestamp
session_vars	char(2000)

pg_catalog.stl_superblock_trickle_validation_summary

old
column	data type
node	int4
record_time	timestamp
snapshot_sb_version	int8
snapshot_sb_num_blocks	int8
log_blocks_validated	int8
log_entries_validated	int8
tree_based_sb_mode	int4
tree_entries_validated	int8
tree_trickle_validation_done	int4
trickle_validation_done	int4
num_steps_trickle_validation	int4
log_rotation_done	int4
num_steps_log_rotation	int4
snapshot_sb_ckpt_hdrs_remaining	int8
snapshot_sb_num_log_blocks	int8

new
column	data type
node	int4
record_time	timestamp
snapshot_sb_version	int8
snapshot_sb_num_blocks	int8
log_blocks_validated	int8
log_entries_validated	int8
tree_based_sb_mode	int4
tree_entries_validated	int8
tree_trickle_validation_done	int4
trickle_validation_done	int4
num_steps_trickle_validation	int4
log_rotation_done	int4
num_steps_log_rotation	int4
snapshot_sb_ckpt_hdrs_remaining	int8
snapshot_sb_num_log_blocks	int8
start_time	timestamp

pg_catalog.stl_xrestore

old
column	data type
backup_id	char(256)
node	int4
catalog_download_start_time	timestamp
catalog_download_end_time	timestamp
slice_transfer_start_time	timestamp
slice_transfer_end_time	timestamp
guid_pool_hit_rate	float8
num_guids_created_on_demand	int4
node_occ_mean	float8
node_occ_variance	float8
data_skew_cluster	float8
xrestore_type	int4
xrestore_source	int4

new
column	data type
backup_id	char(256)
node	int4
catalog_download_start_time	timestamp
catalog_download_end_time	timestamp
slice_transfer_start_time	timestamp
slice_transfer_end_time	timestamp
guid_pool_hit_rate	float8
num_guids_created_on_demand	int4
node_occ_mean	float8
node_occ_variance	float8
data_skew_cluster	float8
xrestore_type	int4
xrestore_source	int4
slice_remapping_policy	int4

pg_catalog.stl_xrestore_alter_distkey

old
column	data type
pid	int4
xid	int8
tbl	int4
column_name	char(200)
event_time	timestamp
message	char(350)
elapsed_us	int8

new
column	data type
pid	int4
xid	int8
tbl	int4
column_name	char(200)
event_time	timestamp
message	char(350)
elapsed_us	int8
message_code	int4
task_type	int4

pg_catalog.stl_xrestore_cluster_level_distkey_tables

old
column	data type
tbl	int4
action	char(64)
event_time	timestamp

new
column	data type
tbl	int4
action	char(64)
event_time	timestamp
task_type	int4

pg_catalog.svcs_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
use_staging_table	char(1)

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
tbl	int4
use_staging_table	char(1)
reserve_rowid	int4

pg_catalog.svl_restore_alter_table_progress

old
column	data type
tbl	int4
progress	varchar(41)
message	char(350)

new
column	data type
tbl	int4
progress	varchar(41)
message	varchar(350)

pg_catalog.sys_connection_log

old
column	data type
event	char(50)
record_time	timestamp
remote_host	char(32)
remote_port	char(32)
session_id	int4
database_name	char(50)
user_name	char(50)
auth_method	char(32)
duration	int8
ssl_version	char(50)
ssl_cipher	char(128)
mtu	int4
ssl_compression	char(64)
ssl_expansion	char(64)
iam_auth_guid	char(36)
application_name	char(250)
driver_version	char(64)
os_version	char(64)
plugin_name	char(32)
protocol_version	int4
global_session_id	char(36)

new
column	data type
event	char(50)
record_time	timestamp
remote_host	char(45)
remote_port	char(32)
session_id	int4
database_name	char(50)
user_name	char(50)
auth_method	char(32)
duration	int8
ssl_version	char(50)
ssl_cipher	char(128)
mtu	int4
ssl_compression	char(64)
ssl_expansion	char(64)
iam_auth_guid	char(36)
application_name	char(250)
driver_version	char(64)
os_version	char(64)
plugin_name	char(32)
protocol_version	int4
global_session_id	char(36)

pg_catalog.sys_restore_state

old
column	data type
user_id	int4
database_name	text
schema_id	int4
table_id	int4
table_name	text
redistribution_status	text
precentage_redistributed	float8

new
column	data type
user_id	int4
database_name	text
schema_id	int4
table_id	int4
table_name	text
redistribution_status	text
precentage_redistributed	float8
redistribution_type	text