Redshift Research Project System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
new	pg_catalog	internal	stable	bool	user_is_member_of_role	name,name
new	pg_catalog	internal	stable	int4	last_user_query_id	None
new	pg_catalog	internal	stable	text	txid_status	int8

Tables

pg_catalog.pg_integration_tablestate

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
schema_name	name			NN
table_name	name			NN
state	text
attributes	text

pg_catalog.stcs_awsclient_requests

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
recordtime	int8			NN
pid	int4			NN
http_method	char(64)			NN
endpoint	char(128)			NN
amzn_request_id	char(36)			NN
response_code	int4			NN
operation_name	char(128)			NN
canonical_uri	char(1024)			NN
canonical_query_string	char(1024)			NN
network_namespace	int4			NN
access_key_id	char(36)			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_table_state

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
integration_id	char(128)			NN
database_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
current_state	char(128)			NN
previous_state	char(128)			NN
record_time	int8			NN
synced_log_coordinate	char(128)			NN
reason	char(256)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_predicate_information

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
segment	int4			NN
step	int4			NN
node_id	int4			NN
parent_node_id	int4			NN
expr_datatype	int4			NN
expr_name	char(64)			NN
expr_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_user_query_text

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

pg_catalog.stll_awsclient_requests

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
recordtime	timestamp			NN
pid	int4			NN
http_method	char(64)			NN
endpoint	char(128)			NN
amzn_request_id	char(36)			NN
response_code	int4			NN
operation_name	char(128)			NN
canonical_uri	char(1024)			NN
canonical_query_string	char(1024)			NN
network_namespace	int4			NN
access_key_id	char(36)			NN

pg_catalog.stll_integration_table_state

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
integration_id	char(128)			NN
database_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
current_state	char(128)			NN
previous_state	char(128)			NN
record_time	timestamp			NN
synced_log_coordinate	char(128)			NN
reason	char(256)			NN

pg_catalog.stll_predicate_information

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
segment	int4			NN
step	int4			NN
node_id	int4			NN
parent_node_id	int4			NN
expr_datatype	int4			NN
expr_name	char(64)			NN
expr_id	int4			NN

pg_catalog.stll_user_query_text

old
column	data type	PK	U	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(200)			NN

pg_catalog.stv_integration_table_state

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
integration_id	char(128)			NN
database_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
state	char(128)			NN
synced_log_coordinate	char(128)			NN
reason	char(256)			NN
size	int4			NN
last_updated	timestamp			NN

pg_catalog.stv_perf_permanent_channel_sink

old
column	data type	PK	U	NN

new
column	data type	PK	U	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.stv_perf_permanent_channel_source

old
column	data type	PK	U	NN

new
column	data type	PK	U	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.stv_query_plan_cache

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
cache_id	int4			NN
source_plan_qid	int8			NN
invalidated_by	int8			NN
query_signature_size_bytes	int8			NN
plan_size_bytes	int8			NN
query_size_bytes	int8			NN
planning_time_us	int8			NN
hit_count	int8			NN

pg_catalog.stv_user_query_map

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
user_query_id	int8			NN
rewritten_query_id	int8			NN
child_query_sequence	int4			NN

pg_internal.redshift_auto_health_check_2815641

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_aggr

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
bytes	int8			NN
slots	int4			NN
occupied	int4			NN
maxlength	int4			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
type	char(6)			NN
resizes	int4			NN
flushable	int4			NN
varchar_agg_opt	char(1)			NN
varagg_opt_bitmap	int8			NN
used_agg_prefetching	char(1)			NN
used_mega_block	char(1)			NN
num_flushes	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
bytes	int8			NN
slots	int4			NN
occupied	int4			NN
maxlength	int4			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
type	char(6)			NN
resizes	int4			NN
flushable	int4			NN
varchar_agg_opt	char(1)			NN
varagg_opt_bitmap	int8			NN
used_agg_prefetching	char(1)			NN
used_mega_block	char(1)			NN
num_flushes	int4			NN
memory_usage_ratio	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_alert_messages

old
column	data type	PK	U	NN
eventtime	int8			NN
pid	int4			NN
error	char(512)			NN
code	int4			NN
context	char(512)			NN
query	int4			NN
file	char(512)			NN
linenumber	int4			NN
process	char(64)			NN
padb	char(32)			NN
tracefile	char(512)			NN
critical	int4			NN
exceptionid	int4			NN
unique_exception_identifier	char(46)			NN
minicore_file	char(1057)			NN
node_id	int4			NN
restart_trace_id	char(64)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
eventtime	int8			NN
pid	int4			NN
error	char(512)			NN
code	int4			NN
context	char(512)			NN
query	int4			NN
file	char(512)			NN
linenumber	int4			NN
process	char(64)			NN
padb	char(32)			NN
tracefile	char(512)			NN
critical	int4			NN
exceptionid	int4			NN
unique_exception_identifier	char(46)			NN
minicore_file	char(1057)			NN
node_id	int4			NN
restart_trace_id	char(64)			NN
vpid	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_backup_compute

old
column	data type	PK	U	NN
currenttime	int8			NN
node_num	int4			NN
state	char(256)			NN
backup_id	char(256)			NN
sb_version	int8			NN
starttime	int8			NN
num_blocks	int8			NN
superblock_size	int8			NN
permanent_blocks	int8			NN
blocks_to_upload	int8			NN
blocks_uploaded	int8			NN
num_failures	int8			NN
num_modified_superblock_segments	int8			NN
total_num_superblock_segments	int8			NN
time_spent_stage1	int8			NN
time_spent_read_sb_header	int8			NN
time_spent_copy_segments	int8			NN
time_spent_stage2	int8			NN
time_spent_set_in_s3_bits	int8			NN
inc_no_backup	int8			NN
nobackup_blocks	int8			NN
distall_blocks	int8			NN
non_distall_blocks	int8			NN
perm_blocks_in_s3	int8			NN
metadata_read_from_backup	int4			NN
blocks_validated	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
currenttime	int8			NN
node_num	int4			NN
state	char(256)			NN
backup_id	char(256)			NN
sb_version	int8			NN
starttime	int8			NN
num_blocks	int8			NN
superblock_size	int8			NN
permanent_blocks	int8			NN
blocks_to_upload	int8			NN
blocks_uploaded	int8			NN
num_failures	int8			NN
num_modified_superblock_segments	int8			NN
total_num_superblock_segments	int8			NN
time_spent_stage1	int8			NN
time_spent_read_sb_header	int8			NN
time_spent_copy_segments	int8			NN
time_spent_stage2	int8			NN
time_spent_set_in_s3_bits	int8			NN
inc_no_backup	int8			NN
nobackup_blocks	int8			NN
distall_blocks	int8			NN
non_distall_blocks	int8			NN
perm_blocks_in_s3	int8			NN
metadata_read_from_backup	int4			NN
blocks_validated	int8			NN
sb_segments_available	int4			NN
backup_manifest_available	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_backup_leader

old
column	data type	PK	U	NN
currenttime	int8			NN
backup_id	char(256)			NN
sb_version	int8			NN
starttime	int8			NN
in_progress	int4			NN
error_code	int4			NN
error_msg	char(256)			NN
enc_key_hash_base64	char(44)			NN
tlr_metadata_successful	int4			NN
tlr_metadata_time	int8			NN
tlr_metadata_error_msg	char(256)			NN
partial	int4			NN
backup_superblock_format	int4			NN
time_wait_commit_lock	int8			NN
time_hold_commit_lock	int8			NN
time_spent_commit_transaction	int8			NN
inc_no_backup	int8			NN
sb_version_stage3	int8			NN
backup_superblock_method	int4			NN
num_tables	int4			NN
inc_resize_lock_optional	int4			NN
inc_resize_lock_mandatory	int4			NN
cluster_id	char(256)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
currenttime	int8			NN
backup_id	char(256)			NN
sb_version	int8			NN
starttime	int8			NN
in_progress	int4			NN
error_code	int4			NN
error_msg	char(256)			NN
enc_key_hash_base64	char(44)			NN
tlr_metadata_successful	int4			NN
tlr_metadata_time	int8			NN
tlr_metadata_error_msg	char(256)			NN
partial	int4			NN
backup_superblock_format	int4			NN
time_wait_commit_lock	int8			NN
time_hold_commit_lock	int8			NN
time_spent_commit_transaction	int8			NN
inc_no_backup	int8			NN
sb_version_stage3	int8			NN
backup_superblock_method	int4			NN
num_tables	int4			NN
inc_resize_lock_optional	int4			NN
inc_resize_lock_mandatory	int4			NN
cluster_id	char(256)			NN
s3commit_aware_backup	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
__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(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

pg_catalog.stcs_datashare_request_consumer

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
initial_query_time	int8			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
api_call	int4			NN
starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
transaction_uid	char(50)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
initial_query_time	int8			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
api_call	int4			NN
starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
transaction_uid	char(50)			NN
retry_times	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_hash

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
bytes	int8			NN
slots	int4			NN
occupied	int4			NN
maxlength	int4			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
est_rows	int8			NN
num_blocks_permitted	int4			NN
resizes	int4			NN
checksum	int8			NN
used_prefetching	char(1)			NN
runtime_filter_size	int4			NN
max_runtime_filter_size	int4			NN
runtime_filter_type	int4			NN
is_hashed_subplan	char(1)			NN
build_global_hash_table	char(1)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
slots	int4			NN
occupied	int4			NN
maxlength	int4			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
est_rows	int8			NN
num_blocks_permitted	int4			NN
resizes	int4			NN
checksum	int8			NN
used_prefetching	char(1)			NN
runtime_filter_size	int4			NN
max_runtime_filter_size	int4			NN
runtime_filter_type	int4			NN
is_hashed_subplan	char(1)			NN
build_global_hash_table	char(1)			NN
used_mega_block	char(1)			NN
memory_usage_ratio	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_hashjoin

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
num_parts	int4			NN
join_type	int4			NN
hash_looped	char(1)			NN
switched_parts	char(1)			NN
used_prefetching	char(1)			NN
hash_segment	int4			NN
hash_step	int4			NN
checksum	int8			NN
distribution	int4			NN
is_externalized	char(1)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
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
num_parts	int4			NN
join_type	int4			NN
hash_looped	char(1)			NN
switched_parts	char(1)			NN
used_prefetching	char(1)			NN
hash_segment	int4			NN
hash_step	int4			NN
checksum	int8			NN
distribution	int4			NN
is_externalized	char(1)			NN
used_mega_block	char(1)			NN
memory_usage_ratio	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_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
__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
__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
est_peak_mem_needed	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
__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
est_peak_mem_needed	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
__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_transmit_metrics

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
send_starttime	int8			NN
send_endtime	int8			NN
send_time_spent_usec	int8			NN
send_bytes	int8			NN
send_rows	int8			NN
recv_starttime	int8			NN
recv_endtime	int8			NN
recv_time_spent_usec	int8			NN
recv_bytes	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
xid	int8			NN
pid	int4			NN
query	int4			NN
send_starttime	int8			NN
send_endtime	int8			NN
send_time_spent_usec	int8			NN
send_bytes	int8			NN
send_rows	int8			NN
recv_starttime	int8			NN
recv_endtime	int8			NN
recv_time_spent_usec	int8			NN
recv_bytes	int8			NN
send_bytes_raw	int8			NN
recv_bytes_raw	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_s3client_error

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
sliceid	int4			NN
recordtime	int8			NN
pid	int4			NN
http_method	char(64)			NN
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
error	char(1024)			NN
retry_count	int4			NN
curl_code	int4			NN
start_time	int8			NN
resolve_time	int8			NN
connect_time	int8			NN
transfer_size	int8			NN
node	int4			NN
table_id	int4			NN
one_perm_rep	int4			NN
flags	int4			NN
s3_write_type	char(64)			NN
is_s3commit_write	int4			NN
is_partial	int4			NN
start_offset	int8			NN
col_num	int4			NN
is_wam_write	int4			NN
wam_precommit_id	int4			NN
region	char(64)			NN
is_xregion	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
sliceid	int4			NN
recordtime	int8			NN
pid	int4			NN
http_method	char(64)			NN
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
error	char(1024)			NN
retry_count	int4			NN
curl_code	int4			NN
start_time	int8			NN
resolve_time	int8			NN
connect_time	int8			NN
transfer_size	int8			NN
node	int4			NN
table_id	int4			NN
one_perm_rep	int4			NN
flags	int4			NN
s3_write_type	char(64)			NN
is_s3commit_write	int4			NN
is_partial	int4			NN
start_offset	int8			NN
col_num	int4			NN
is_wam_write	int4			NN
wam_precommit_id	int4			NN
region	char(64)			NN
is_xregion	int4			NN
segment	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_save

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
bytes	int8			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
is_save_rtf	char(1)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
is_save_rtf	char(1)			NN
used_mega_block	char(1)			NN
memory_usage_ratio	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_scan

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
bytes	int8			NN
fetches	int8			NN
type	int4			NN
tbl	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
rows_pre_filter	int8			NN
rows_pre_user_filter	int8			NN
perm_table_name	char(136)			NN
is_rlf_scan	char(1)			NN
is_rlf_scan_reason	int4			NN
num_em_blocks	int4			NN
checksum	int8			NN
runtime_filtering	char(1)			NN
scan_region	int4			NN
num_sortkey_as_predicate	int4			NN
row_fetcher_state	int4			NN
consumed_scan_ranges	int8			NN
work_stealing_reason	int8			NN
is_vectorized_scan	char(1)			NN
is_vectorized_scan_reason	int4			NN
row_fetcher_reason	int8			NN
topology_signature	int8			NN
use_tpm_partition	char(1)			NN
is_rrscan_expr	char(1)			NN
use_fwd_mtx_opt	char(1)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
fetches	int8			NN
type	int4			NN
tbl	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
rows_pre_filter	int8			NN
rows_pre_user_filter	int8			NN
perm_table_name	char(136)			NN
is_rlf_scan	char(1)			NN
is_rlf_scan_reason	int4			NN
num_em_blocks	int4			NN
checksum	int8			NN
runtime_filtering	char(1)			NN
scan_region	int4			NN
num_sortkey_as_predicate	int4			NN
row_fetcher_state	int4			NN
consumed_scan_ranges	int8			NN
work_stealing_reason	int8			NN
is_vectorized_scan	char(1)			NN
is_vectorized_scan_reason	int4			NN
row_fetcher_reason	int8			NN
topology_signature	int8			NN
use_tpm_partition	char(1)			NN
is_rrscan_expr	char(1)			NN
use_fwd_mtx_opt	char(1)			NN
scanned_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_sort

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
bytes	int8			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
checksum	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
bytes	int8			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
checksum	int8			NN
used_mega_block	char(1)			NN
memory_usage_ratio	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_undo_transactions

old
column	data type	PK	U	NN
recordtime	int8			NN
table_id	int4			NN
tables_done	int4			NN
tables_total	int4			NN
table_name	char(137)			NN
undo_mode	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
recordtime	int8			NN
table_id	int4			NN
tables_done	int4			NN
tables_total	int4			NN
table_name	char(137)			NN
undo_mode	int4			NN
event	char(137)			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_unique

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
type	char(6)			NN
is_diskbased	char(1)			NN
slots	int4			NN
workmem	int8			NN
max_buffers_used	int8			NN
resizes	int4			NN
occupied	int4			NN
flushable	int4			NN
used_unique_prefetching	char(1)			NN
bytes	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
type	char(6)			NN
is_diskbased	char(1)			NN
slots	int4			NN
workmem	int8			NN
max_buffers_used	int8			NN
resizes	int4			NN
occupied	int4			NN
flushable	int4			NN
used_unique_prefetching	char(1)			NN
bytes	int8			NN
used_mega_block	char(1)			NN
memory_usage_ratio	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_window

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
is_diskbased	char(1)			NN
workmem	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
is_diskbased	char(1)			NN
workmem	int8			NN
used_mega_block	char(1)			NN
memory_usage_ratio	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

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

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
bytes	int8			NN
slots	int4			NN
occupied	int4			NN
maxlength	int4			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
type	char(6)			NN
resizes	int4			NN
flushable	int4			NN
varchar_agg_opt	char(1)			NN
varagg_opt_bitmap	int8			NN
used_agg_prefetching	char(1)			NN
used_mega_block	char(1)			NN
num_flushes	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
bytes	int8			NN
slots	int4			NN
occupied	int4			NN
maxlength	int4			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
type	char(6)			NN
resizes	int4			NN
flushable	int4			NN
varchar_agg_opt	char(1)			NN
varagg_opt_bitmap	int8			NN
used_agg_prefetching	char(1)			NN
used_mega_block	char(1)			NN
num_flushes	int4			NN
memory_usage_ratio	int4			NN

pg_catalog.stll_alert_messages

old
column	data type	PK	U	NN
eventtime	timestamp			NN
pid	int4			NN
error	char(512)			NN
code	int4			NN
context	char(512)			NN
query	int4			NN
file	char(512)			NN
linenumber	int4			NN
process	char(64)			NN
padb	char(32)			NN
tracefile	char(512)			NN
critical	int4			NN
exceptionid	int4			NN
unique_exception_identifier	char(46)			NN
minicore_file	char(1057)			NN
node_id	int4			NN
restart_trace_id	char(64)			NN

new
column	data type	PK	U	NN
eventtime	timestamp			NN
pid	int4			NN
error	char(512)			NN
code	int4			NN
context	char(512)			NN
query	int4			NN
file	char(512)			NN
linenumber	int4			NN
process	char(64)			NN
padb	char(32)			NN
tracefile	char(512)			NN
critical	int4			NN
exceptionid	int4			NN
unique_exception_identifier	char(46)			NN
minicore_file	char(1057)			NN
node_id	int4			NN
restart_trace_id	char(64)			NN
vpid	int4			NN

pg_catalog.stll_backup_compute

old
column	data type	PK	U	NN
currenttime	timestamp			NN
node_num	int4			NN
state	char(256)			NN
backup_id	char(256)			NN
sb_version	int8			NN
starttime	timestamp			NN
num_blocks	int8			NN
superblock_size	int8			NN
permanent_blocks	int8			NN
blocks_to_upload	int8			NN
blocks_uploaded	int8			NN
num_failures	int8			NN
num_modified_superblock_segments	int8			NN
total_num_superblock_segments	int8			NN
time_spent_stage1	int8			NN
time_spent_read_sb_header	int8			NN
time_spent_copy_segments	int8			NN
time_spent_stage2	int8			NN
time_spent_set_in_s3_bits	int8			NN
inc_no_backup	int8			NN
nobackup_blocks	int8			NN
distall_blocks	int8			NN
non_distall_blocks	int8			NN
perm_blocks_in_s3	int8			NN
metadata_read_from_backup	int4			NN
blocks_validated	int8			NN

new
column	data type	PK	U	NN
currenttime	timestamp			NN
node_num	int4			NN
state	char(256)			NN
backup_id	char(256)			NN
sb_version	int8			NN
starttime	timestamp			NN
num_blocks	int8			NN
superblock_size	int8			NN
permanent_blocks	int8			NN
blocks_to_upload	int8			NN
blocks_uploaded	int8			NN
num_failures	int8			NN
num_modified_superblock_segments	int8			NN
total_num_superblock_segments	int8			NN
time_spent_stage1	int8			NN
time_spent_read_sb_header	int8			NN
time_spent_copy_segments	int8			NN
time_spent_stage2	int8			NN
time_spent_set_in_s3_bits	int8			NN
inc_no_backup	int8			NN
nobackup_blocks	int8			NN
distall_blocks	int8			NN
non_distall_blocks	int8			NN
perm_blocks_in_s3	int8			NN
metadata_read_from_backup	int4			NN
blocks_validated	int8			NN
sb_segments_available	int4			NN
backup_manifest_available	int4			NN

pg_catalog.stll_backup_leader

old
column	data type	PK	U	NN
currenttime	timestamp			NN
backup_id	char(256)			NN
sb_version	int8			NN
starttime	timestamp			NN
in_progress	int4			NN
error_code	int4			NN
error_msg	char(256)			NN
enc_key_hash_base64	char(44)			NN
tlr_metadata_successful	int4			NN
tlr_metadata_time	int8			NN
tlr_metadata_error_msg	char(256)			NN
partial	int4			NN
backup_superblock_format	int4			NN
time_wait_commit_lock	int8			NN
time_hold_commit_lock	int8			NN
time_spent_commit_transaction	int8			NN
inc_no_backup	int8			NN
sb_version_stage3	int8			NN
backup_superblock_method	int4			NN
num_tables	int4			NN
inc_resize_lock_optional	int4			NN
inc_resize_lock_mandatory	int4			NN
cluster_id	char(256)			NN

new
column	data type	PK	U	NN
currenttime	timestamp			NN
backup_id	char(256)			NN
sb_version	int8			NN
starttime	timestamp			NN
in_progress	int4			NN
error_code	int4			NN
error_msg	char(256)			NN
enc_key_hash_base64	char(44)			NN
tlr_metadata_successful	int4			NN
tlr_metadata_time	int8			NN
tlr_metadata_error_msg	char(256)			NN
partial	int4			NN
backup_superblock_format	int4			NN
time_wait_commit_lock	int8			NN
time_hold_commit_lock	int8			NN
time_spent_commit_transaction	int8			NN
inc_no_backup	int8			NN
sb_version_stage3	int8			NN
backup_superblock_method	int4			NN
num_tables	int4			NN
inc_resize_lock_optional	int4			NN
inc_resize_lock_mandatory	int4			NN
cluster_id	char(256)			NN
s3commit_aware_backup	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

new
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

pg_catalog.stll_datashare_request_consumer

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
initial_query_time	timestamp			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
api_call	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
status	int4			NN
message	char(512)			NN
transaction_uid	char(50)			NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
initial_query_time	timestamp			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
api_call	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
status	int4			NN
message	char(512)			NN
transaction_uid	char(50)			NN
retry_times	int4			NN

pg_catalog.stll_hash

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
bytes	int8			NN
slots	int4			NN
occupied	int4			NN
maxlength	int4			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
est_rows	int8			NN
num_blocks_permitted	int4			NN
resizes	int4			NN
checksum	int8			NN
used_prefetching	char(1)			NN
runtime_filter_size	int4			NN
max_runtime_filter_size	int4			NN
runtime_filter_type	int4			NN
is_hashed_subplan	char(1)			NN
build_global_hash_table	char(1)			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
bytes	int8			NN
slots	int4			NN
occupied	int4			NN
maxlength	int4			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
est_rows	int8			NN
num_blocks_permitted	int4			NN
resizes	int4			NN
checksum	int8			NN
used_prefetching	char(1)			NN
runtime_filter_size	int4			NN
max_runtime_filter_size	int4			NN
runtime_filter_type	int4			NN
is_hashed_subplan	char(1)			NN
build_global_hash_table	char(1)			NN
used_mega_block	char(1)			NN
memory_usage_ratio	int4			NN

pg_catalog.stll_hashjoin

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
num_parts	int4			NN
join_type	int4			NN
hash_looped	char(1)			NN
switched_parts	char(1)			NN
used_prefetching	char(1)			NN
hash_segment	int4			NN
hash_step	int4			NN
checksum	int8			NN
distribution	int4			NN
is_externalized	char(1)			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
num_parts	int4			NN
join_type	int4			NN
hash_looped	char(1)			NN
switched_parts	char(1)			NN
used_prefetching	char(1)			NN
hash_segment	int4			NN
hash_step	int4			NN
checksum	int8			NN
distribution	int4			NN
is_externalized	char(1)			NN
used_mega_block	char(1)			NN
memory_usage_ratio	int4			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

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

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
est_peak_mem_needed	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

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
est_peak_mem_needed	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

pg_catalog.stll_query_transmit_metrics

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
send_starttime	timestamp			NN
send_endtime	timestamp			NN
send_time_spent_usec	int8			NN
send_bytes	int8			NN
send_rows	int8			NN
recv_starttime	timestamp			NN
recv_endtime	timestamp			NN
recv_time_spent_usec	int8			NN
recv_bytes	int8			NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
send_starttime	timestamp			NN
send_endtime	timestamp			NN
send_time_spent_usec	int8			NN
send_bytes	int8			NN
send_rows	int8			NN
recv_starttime	timestamp			NN
recv_endtime	timestamp			NN
recv_time_spent_usec	int8			NN
recv_bytes	int8			NN
send_bytes_raw	int8			NN
recv_bytes_raw	int8			NN

pg_catalog.stll_s3client_error

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
sliceid	int4			NN
recordtime	timestamp			NN
pid	int4			NN
http_method	char(64)			NN
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
error	char(1024)			NN
retry_count	int4			NN
curl_code	int4			NN
start_time	timestamp			NN
resolve_time	int8			NN
connect_time	int8			NN
transfer_size	int8			NN
node	int4			NN
table_id	int4			NN
one_perm_rep	int4			NN
flags	int4			NN
s3_write_type	char(64)			NN
is_s3commit_write	int4			NN
is_partial	int4			NN
start_offset	int8			NN
col_num	int4			NN
is_wam_write	int4			NN
wam_precommit_id	int4			NN
region	char(64)			NN
is_xregion	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
sliceid	int4			NN
recordtime	timestamp			NN
pid	int4			NN
http_method	char(64)			NN
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
error	char(1024)			NN
retry_count	int4			NN
curl_code	int4			NN
start_time	timestamp			NN
resolve_time	int8			NN
connect_time	int8			NN
transfer_size	int8			NN
node	int4			NN
table_id	int4			NN
one_perm_rep	int4			NN
flags	int4			NN
s3_write_type	char(64)			NN
is_s3commit_write	int4			NN
is_partial	int4			NN
start_offset	int8			NN
col_num	int4			NN
is_wam_write	int4			NN
wam_precommit_id	int4			NN
region	char(64)			NN
is_xregion	int4			NN
segment	int8			NN

pg_catalog.stll_save

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
bytes	int8			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
is_save_rtf	char(1)			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
bytes	int8			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
is_save_rtf	char(1)			NN
used_mega_block	char(1)			NN
memory_usage_ratio	int4			NN

pg_catalog.stll_scan

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
bytes	int8			NN
fetches	int8			NN
type	int4			NN
tbl	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
rows_pre_filter	int8			NN
rows_pre_user_filter	int8			NN
perm_table_name	char(136)			NN
is_rlf_scan	char(1)			NN
is_rlf_scan_reason	int4			NN
num_em_blocks	int4			NN
checksum	int8			NN
runtime_filtering	char(1)			NN
scan_region	int4			NN
num_sortkey_as_predicate	int4			NN
row_fetcher_state	int4			NN
consumed_scan_ranges	int8			NN
work_stealing_reason	int8			NN
is_vectorized_scan	char(1)			NN
is_vectorized_scan_reason	int4			NN
row_fetcher_reason	int8			NN
topology_signature	int8			NN
use_tpm_partition	char(1)			NN
is_rrscan_expr	char(1)			NN
use_fwd_mtx_opt	char(1)			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
bytes	int8			NN
fetches	int8			NN
type	int4			NN
tbl	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
rows_pre_filter	int8			NN
rows_pre_user_filter	int8			NN
perm_table_name	char(136)			NN
is_rlf_scan	char(1)			NN
is_rlf_scan_reason	int4			NN
num_em_blocks	int4			NN
checksum	int8			NN
runtime_filtering	char(1)			NN
scan_region	int4			NN
num_sortkey_as_predicate	int4			NN
row_fetcher_state	int4			NN
consumed_scan_ranges	int8			NN
work_stealing_reason	int8			NN
is_vectorized_scan	char(1)			NN
is_vectorized_scan_reason	int4			NN
row_fetcher_reason	int8			NN
topology_signature	int8			NN
use_tpm_partition	char(1)			NN
is_rrscan_expr	char(1)			NN
use_fwd_mtx_opt	char(1)			NN
scanned_mega_value	char(1)			NN

pg_catalog.stll_sort

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
bytes	int8			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
checksum	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
bytes	int8			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
checksum	int8			NN
used_mega_block	char(1)			NN
memory_usage_ratio	int4			NN

pg_catalog.stll_undo_transactions

old
column	data type	PK	U	NN
recordtime	timestamp			NN
table_id	int4			NN
tables_done	int4			NN
tables_total	int4			NN
table_name	char(137)			NN
undo_mode	int4			NN

new
column	data type	PK	U	NN
recordtime	timestamp			NN
table_id	int4			NN
tables_done	int4			NN
tables_total	int4			NN
table_name	char(137)			NN
undo_mode	int4			NN
event	char(137)			NN

pg_catalog.stll_unique

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
type	char(6)			NN
is_diskbased	char(1)			NN
slots	int4			NN
workmem	int8			NN
max_buffers_used	int8			NN
resizes	int4			NN
occupied	int4			NN
flushable	int4			NN
used_unique_prefetching	char(1)			NN
bytes	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
type	char(6)			NN
is_diskbased	char(1)			NN
slots	int4			NN
workmem	int8			NN
max_buffers_used	int8			NN
resizes	int4			NN
occupied	int4			NN
flushable	int4			NN
used_unique_prefetching	char(1)			NN
bytes	int8			NN
used_mega_block	char(1)			NN
memory_usage_ratio	int4			NN

pg_catalog.stll_window

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
is_diskbased	char(1)			NN
workmem	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
is_diskbased	char(1)			NN
workmem	int8			NN
used_mega_block	char(1)			NN
memory_usage_ratio	int4			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

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

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
node	int4			NN
guid	char(64)			NN
sb_pos	int4			NN
state	int4			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

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

Views

pg_catalog.stl_awsclient_requests

old
column	data type

new
column	data type
userid	int4
query	int4
slice	int4
recordtime	timestamp
pid	int4
http_method	char(64)
endpoint	char(128)
amzn_request_id	char(36)
response_code	int4
operation_name	char(128)
canonical_uri	char(1024)
canonical_query_string	char(1024)
network_namespace	int4
access_key_id	char(36)

pg_catalog.stl_integration_table_state

old
column	data type

new
column	data type
integration_id	char(128)
database_name	char(128)
schema_name	char(128)
table_name	char(128)
current_state	char(128)
previous_state	char(128)
record_time	timestamp
synced_log_coordinate	char(128)
reason	char(256)

pg_catalog.stl_predicate_information

old
column	data type

new
column	data type
userid	int4
query	int4
segment	int4
step	int4
node_id	int4
parent_node_id	int4
expr_datatype	int4
expr_name	char(64)
expr_id	int4

pg_catalog.stl_user_query_text

old
column	data type

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

pg_catalog.sys_integration_table_state

old
column	data type

new
column	data type
integration_id	char(128)
database_name	char(128)
schema_name	char(128)
table_name	char(128)
state	char(128)
last_replicated_checkpoint	char(128)
reason	char(256)
last_updated	int4

pg_catalog.sys_query_text

old
column	data type

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

pg_catalog.stl_aggr

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
slots	int4
occupied	int4
maxlength	int4
tbl	int4
is_diskbased	char(1)
workmem	int8
type	char(6)
resizes	int4
flushable	int4
varchar_agg_opt	char(1)
varagg_opt_bitmap	int8
used_agg_prefetching	char(1)
used_mega_block	char(1)
num_flushes	int4

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
slots	int4
occupied	int4
maxlength	int4
tbl	int4
is_diskbased	char(1)
workmem	int8
type	char(6)
resizes	int4
flushable	int4
varchar_agg_opt	char(1)
varagg_opt_bitmap	int8
used_agg_prefetching	char(1)
used_mega_block	char(1)
num_flushes	int4
memory_usage_ratio	int4

pg_catalog.stl_alert_messages

old
column	data type
eventtime	timestamp
pid	int4
error	char(512)
code	int4
context	char(512)
query	int4
file	char(512)
linenumber	int4
process	char(64)
padb	char(32)
tracefile	char(512)
critical	int4
exceptionid	int4
unique_exception_identifier	char(46)
minicore_file	char(1057)
node_id	int4
restart_trace_id	char(64)

new
column	data type
eventtime	timestamp
pid	int4
error	char(512)
code	int4
context	char(512)
query	int4
file	char(512)
linenumber	int4
process	char(64)
padb	char(32)
tracefile	char(512)
critical	int4
exceptionid	int4
unique_exception_identifier	char(46)
minicore_file	char(1057)
node_id	int4
restart_trace_id	char(64)
vpid	int4

pg_catalog.stl_backup_compute

old
column	data type
currenttime	timestamp
node_num	int4
state	char(256)
backup_id	char(256)
sb_version	int8
starttime	timestamp
num_blocks	int8
superblock_size	int8
permanent_blocks	int8
blocks_to_upload	int8
blocks_uploaded	int8
num_failures	int8
num_modified_superblock_segments	int8
total_num_superblock_segments	int8
time_spent_stage1	int8
time_spent_read_sb_header	int8
time_spent_copy_segments	int8
time_spent_stage2	int8
time_spent_set_in_s3_bits	int8
inc_no_backup	int8
nobackup_blocks	int8
distall_blocks	int8
non_distall_blocks	int8
perm_blocks_in_s3	int8
metadata_read_from_backup	int4
blocks_validated	int8

new
column	data type
currenttime	timestamp
node_num	int4
state	char(256)
backup_id	char(256)
sb_version	int8
starttime	timestamp
num_blocks	int8
superblock_size	int8
permanent_blocks	int8
blocks_to_upload	int8
blocks_uploaded	int8
num_failures	int8
num_modified_superblock_segments	int8
total_num_superblock_segments	int8
time_spent_stage1	int8
time_spent_read_sb_header	int8
time_spent_copy_segments	int8
time_spent_stage2	int8
time_spent_set_in_s3_bits	int8
inc_no_backup	int8
nobackup_blocks	int8
distall_blocks	int8
non_distall_blocks	int8
perm_blocks_in_s3	int8
metadata_read_from_backup	int4
blocks_validated	int8
sb_segments_available	int4
backup_manifest_available	int4

pg_catalog.stl_backup_leader

old
column	data type
currenttime	timestamp
backup_id	char(256)
sb_version	int8
starttime	timestamp
in_progress	int4
error_code	int4
error_msg	char(256)
enc_key_hash_base64	char(44)
tlr_metadata_successful	int4
tlr_metadata_time	int8
tlr_metadata_error_msg	char(256)
partial	int4
backup_superblock_format	int4
time_wait_commit_lock	int8
time_hold_commit_lock	int8
time_spent_commit_transaction	int8
inc_no_backup	int8
sb_version_stage3	int8
backup_superblock_method	int4
num_tables	int4
inc_resize_lock_optional	int4
inc_resize_lock_mandatory	int4
cluster_id	char(256)

new
column	data type
currenttime	timestamp
backup_id	char(256)
sb_version	int8
starttime	timestamp
in_progress	int4
error_code	int4
error_msg	char(256)
enc_key_hash_base64	char(44)
tlr_metadata_successful	int4
tlr_metadata_time	int8
tlr_metadata_error_msg	char(256)
partial	int4
backup_superblock_format	int4
time_wait_commit_lock	int8
time_hold_commit_lock	int8
time_spent_commit_transaction	int8
inc_no_backup	int8
sb_version_stage3	int8
backup_superblock_method	int4
num_tables	int4
inc_resize_lock_optional	int4
inc_resize_lock_mandatory	int4
cluster_id	char(256)
s3commit_aware_backup	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)

new
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)

pg_catalog.stl_datashare_request_consumer

old
column	data type
userid	int4
xid	int8
pid	int4
initial_query_time	timestamp
requestid	char(50)
sb_version	int8
dbtype	int4
dbid	int4
api_call	int4
starttime	timestamp
endtime	timestamp
status	int4
message	char(512)
transaction_uid	char(50)

new
column	data type
userid	int4
xid	int8
pid	int4
initial_query_time	timestamp
requestid	char(50)
sb_version	int8
dbtype	int4
dbid	int4
api_call	int4
starttime	timestamp
endtime	timestamp
status	int4
message	char(512)
transaction_uid	char(50)
retry_times	int4

pg_catalog.stl_hash

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
slots	int4
occupied	int4
maxlength	int4
tbl	int4
is_diskbased	char(1)
workmem	int8
num_parts	int4
est_rows	int8
num_blocks_permitted	int4
resizes	int4
checksum	int8
used_prefetching	char(1)
runtime_filter_size	int4
max_runtime_filter_size	int4
runtime_filter_type	int4
is_hashed_subplan	char(1)
build_global_hash_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
bytes	int8
slots	int4
occupied	int4
maxlength	int4
tbl	int4
is_diskbased	char(1)
workmem	int8
num_parts	int4
est_rows	int8
num_blocks_permitted	int4
resizes	int4
checksum	int8
used_prefetching	char(1)
runtime_filter_size	int4
max_runtime_filter_size	int4
runtime_filter_type	int4
is_hashed_subplan	char(1)
build_global_hash_table	char(1)
used_mega_block	char(1)
memory_usage_ratio	int4

pg_catalog.stl_hashjoin

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
tbl	int4
num_parts	int4
join_type	int4
hash_looped	char(1)
switched_parts	char(1)
used_prefetching	char(1)
hash_segment	int4
hash_step	int4
checksum	int8
distribution	int4
is_externalized	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
num_parts	int4
join_type	int4
hash_looped	char(1)
switched_parts	char(1)
used_prefetching	char(1)
hash_segment	int4
hash_step	int4
checksum	int8
distribution	int4
is_externalized	char(1)
used_mega_block	char(1)
memory_usage_ratio	int4

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

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

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
est_peak_mem_needed	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

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
est_peak_mem_needed	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

pg_catalog.stl_query_transmit_metrics

old
column	data type
userid	int4
xid	int8
pid	int4
query	int4
send_starttime	timestamp
send_endtime	timestamp
send_time_spent_usec	int8
send_bytes	int8
send_rows	int8
recv_starttime	timestamp
recv_endtime	timestamp
recv_time_spent_usec	int8
recv_bytes	int8

new
column	data type
userid	int4
xid	int8
pid	int4
query	int4
send_starttime	timestamp
send_endtime	timestamp
send_time_spent_usec	int8
send_bytes	int8
send_rows	int8
recv_starttime	timestamp
recv_endtime	timestamp
recv_time_spent_usec	int8
recv_bytes	int8
send_bytes_raw	int8
recv_bytes_raw	int8

pg_catalog.stl_s3client_error

old
column	data type
userid	int4
query	int4
sliceid	int4
recordtime	timestamp
pid	int4
http_method	char(64)
s3_action	char(64)
bucket	char(64)
key	char(256)
error	char(1024)
retry_count	int4
curl_code	int4
start_time	timestamp
resolve_time	int8
connect_time	int8
transfer_size	int8
node	int4
table_id	int4
one_perm_rep	int4
flags	int4
s3_write_type	char(64)
is_s3commit_write	int4
is_partial	int4
start_offset	int8
col_num	int4
is_wam_write	int4
wam_precommit_id	int4
region	char(64)
is_xregion	int4

new
column	data type
userid	int4
query	int4
sliceid	int4
recordtime	timestamp
pid	int4
http_method	char(64)
s3_action	char(64)
bucket	char(64)
key	char(256)
error	char(1024)
retry_count	int4
curl_code	int4
start_time	timestamp
resolve_time	int8
connect_time	int8
transfer_size	int8
node	int4
table_id	int4
one_perm_rep	int4
flags	int4
s3_write_type	char(64)
is_s3commit_write	int4
is_partial	int4
start_offset	int8
col_num	int4
is_wam_write	int4
wam_precommit_id	int4
region	char(64)
is_xregion	int4
segment	int8

pg_catalog.stl_save

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
tbl	int4
is_diskbased	char(1)
workmem	int8
is_save_rtf	char(1)

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
tbl	int4
is_diskbased	char(1)
workmem	int8
is_save_rtf	char(1)
used_mega_block	char(1)
memory_usage_ratio	int4

pg_catalog.stl_scan

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
fetches	int8
type	int4
tbl	int4
is_rrscan	char(1)
is_delayed_scan	char(1)
rows_pre_filter	int8
rows_pre_user_filter	int8
perm_table_name	char(136)
is_rlf_scan	char(1)
is_rlf_scan_reason	int4
num_em_blocks	int4
checksum	int8
runtime_filtering	char(1)
scan_region	int4
num_sortkey_as_predicate	int4
row_fetcher_state	int4
consumed_scan_ranges	int8
work_stealing_reason	int8
is_vectorized_scan	char(1)
is_vectorized_scan_reason	int4
row_fetcher_reason	int8
topology_signature	int8
use_tpm_partition	char(1)
is_rrscan_expr	char(1)
use_fwd_mtx_opt	char(1)

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
fetches	int8
type	int4
tbl	int4
is_rrscan	char(1)
is_delayed_scan	char(1)
rows_pre_filter	int8
rows_pre_user_filter	int8
perm_table_name	char(136)
is_rlf_scan	char(1)
is_rlf_scan_reason	int4
num_em_blocks	int4
checksum	int8
runtime_filtering	char(1)
scan_region	int4
num_sortkey_as_predicate	int4
row_fetcher_state	int4
consumed_scan_ranges	int8
work_stealing_reason	int8
is_vectorized_scan	char(1)
is_vectorized_scan_reason	int4
row_fetcher_reason	int8
topology_signature	int8
use_tpm_partition	char(1)
is_rrscan_expr	char(1)
use_fwd_mtx_opt	char(1)
scanned_mega_value	char(1)

pg_catalog.stl_sort

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
tbl	int4
is_diskbased	char(1)
workmem	int8
checksum	int8

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
tbl	int4
is_diskbased	char(1)
workmem	int8
checksum	int8
used_mega_block	char(1)
memory_usage_ratio	int4

pg_catalog.stl_undo_transactions

old
column	data type
recordtime	timestamp
table_id	int4
tables_done	int4
tables_total	int4
table_name	char(137)
undo_mode	int4

new
column	data type
recordtime	timestamp
table_id	int4
tables_done	int4
tables_total	int4
table_name	char(137)
undo_mode	int4
event	char(137)

pg_catalog.stl_unique

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
type	char(6)
is_diskbased	char(1)
slots	int4
workmem	int8
max_buffers_used	int8
resizes	int4
occupied	int4
flushable	int4
used_unique_prefetching	char(1)
bytes	int8

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
type	char(6)
is_diskbased	char(1)
slots	int4
workmem	int8
max_buffers_used	int8
resizes	int4
occupied	int4
flushable	int4
used_unique_prefetching	char(1)
bytes	int8
used_mega_block	char(1)
memory_usage_ratio	int4

pg_catalog.stl_window

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
is_diskbased	char(1)
workmem	int8

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
is_diskbased	char(1)
workmem	int8
used_mega_block	char(1)
memory_usage_ratio	int4

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

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

pg_catalog.svl_datashare_usage_consumer

old
column	data type
userid	int4
pid	int4
xid	int8
request_id	varchar(50)
request_type	varchar(25)
transaction_uid	varchar(50)
recordtime	timestamp
status	int4
error	varchar(512)

new
column	data type
userid	int4
pid	int4
xid	int8
request_id	varchar(50)
request_type	varchar(25)
transaction_uid	varchar(50)
recordtime	timestamp
status	int4
error	varchar(512)
retry_times	int4

pg_catalog.svv_columns

old
column	data type
table_catalog	varchar(128)
table_schema	varchar(128)
table_name	varchar(128)
column_name	varchar(128)
ordinal_position	int4
column_default	varchar(4000)
is_nullable	varchar(3)
data_type	varchar(128)
character_maximum_length	int4
numeric_precision	int4
numeric_precision_radix	int4
numeric_scale	int4
datetime_precision	int4
interval_type	varchar(256)
interval_precision	varchar(256)
character_set_catalog	varchar(128)
character_set_schema	varchar(128)
character_set_name	varchar(128)
collation_catalog	varchar(128)
collation_schema	varchar(128)
collation_name	varchar(128)
domain_name	varchar(128)
remarks	varchar(256)

new
column	data type
table_catalog	varchar(128)
table_schema	varchar(128)
table_name	varchar(128)
column_name	varchar(128)
ordinal_position	int4
column_default	varchar(4000)
is_nullable	varchar(128)
data_type	varchar(128)
character_maximum_length	int4
numeric_precision	int4
numeric_precision_radix	int4
numeric_scale	int4
datetime_precision	int4
interval_type	varchar(256)
interval_precision	varchar(256)
character_set_catalog	varchar(128)
character_set_schema	varchar(128)
character_set_name	varchar(128)
collation_catalog	varchar(128)
collation_schema	varchar(128)
collation_name	varchar(128)
domain_name	varchar(128)
remarks	varchar(256)

pg_catalog.svv_integration

old
column	data type
integration_id	char(128)
target_database	char(128)
source	char(128)
state	char(128)
current_lag	int8
last_replicated_checkpoint	char(128)

new
column	data type
integration_id	char(128)
target_database	char(128)
source	char(128)
state	char(128)
current_lag	int8
last_replicated_checkpoint	char(128)
total_tables_replicated	int4
total_tables_failed	int4

pg_catalog.sys_integration_activity

old
column	data type
integration_id	char(128)
target_database	char(128)
source	char(128)
checkpoint_name	char(128)
checkpoint_type	char(16)
checkpoint_bytes	int8
last_commit_timestamp	int4
modified_tables	int4
integration_start_time	int4
integration_end_time	timestamp

new
column	data type
integration_id	char(128)
target_database	char(128)
source	char(128)
checkpoint_name	char(128)
checkpoint_type	char(16)
checkpoint_bytes	int8
last_commit_timestamp	timestamp
modified_tables	int4
integration_start_time	timestamp
integration_end_time	timestamp

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	text
table_id	int4
table_name	text
is_rrscan	text
start_time	timestamp
end_time	timestamp
duration	int8
alert	text
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	text
data_skewness	int4
time_skewness	int4

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)

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
user_id	int4
query_id	int8
session_id	int4
transaction_id	int8
file_name	char(1280)
start_time	timestamp
end_time	timestamp
line_count	int8
transfer_size	int8
file_format	char(10)