Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
new	pg_catalog	internal	volatile	_record	pg_get_auto_mounted_catalog_columns	None
new	pg_catalog	internal	volatile	_record	pg_get_auto_mounted_catalog_databases	None
new	pg_catalog	internal	volatile	_record	pg_get_auto_mounted_catalog_tables	None

Tables

pg_catalog.pg_analyze_table_info

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
table_id	oid			NN
value_type	int2			NN
value	text

pg_catalog.pg_consumer_object_owner

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
shareid	oid			NN
dbid	oid			NN
objtype	char(1)			NN
objid	oid			NN
produceruserid	int4			NN
consumernamespace	name			NN
consumeruserid	int4			NN

pg_catalog.pg_integration_invisible_xid

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
txn_seq	int8			NN
txn_id	int8			NN
invisible_xid	int8[]

pg_catalog.stcs_burst_prepare_time

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
logtime	int8			NN
xid	int8			NN
pid	int8			NN
qid	int4			NN
total_time_in_prepare	float8			NN
attempts	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_datashare_write_history

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
user_name	char(128)			NN
vpid	int4			NN
transaction_id	int8			NN
consumer_transaction_uid	char(64)			NN
db_id	int4			NN
db_name	char(128)			NN
object_type	char(64)			NN
object_id	int4			NN
object_name	char(128)			NN
query_type	char(64)			NN
record_time	int8			NN
inserted_row_count	int4			NN
deleted_row_count	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_lambda_invocation_ids

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
padb_request_id	char(100)			NN
lambda_request_id	char(100)			NN
recordtime	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_table_version_events

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	int8			NN
xid	int8			NN
pid	int8			NN
table_id	int4			NN
old_dml_version	int8			NN
new_dml_version	int8			NN
old_ddl_end_version	int8			NN
new_ddl_end_version	int8			NN
old_ddl_start_version	int8			NN
new_ddl_start_version	int8			NN
old_structure_version	int8			NN
new_structure_version	int8			NN
old_structure_delete_version	int8			NN
new_structure_delete_version	int8			NN
event	char(32)			NN
event_location	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_tidal_tbl_perm

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	int8			NN
user_id	int4			NN
table_name	char(128)			NN
table_id	int4			NN
delete_table_id	int4			NN
slice	int4			NN
temp	int4			NN
db_id	int4			NN
dist_style	int4			NN
block_count	int4			NN
partial_block_count	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_topology_mapping

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	int8			NN
remote_topology	int8			NN
remote_node	int4			NN
native_node	int4			NN
remote_global_slice	int4			NN
native_global_slice	int4			NN
remote_node_slice	int4			NN
native_node_slice	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_udf_usage_in_query

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
nodeid	int4			NN
plan_node_type	int4			NN
func_id	int4			NN
func_name	char(200)			NN
func_type	int4			NN
in_targetlist	int4			NN
recordtime	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stll_burst_prepare_time

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
logtime	timestamp			NN
xid	int8			NN
pid	int8			NN
qid	int4			NN
total_time_in_prepare	float8			NN
attempts	int4			NN

pg_catalog.stll_datashare_write_history

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
user_name	char(128)			NN
vpid	int4			NN
transaction_id	int8			NN
consumer_transaction_uid	char(64)			NN
db_id	int4			NN
db_name	char(128)			NN
object_type	char(64)			NN
object_id	int4			NN
object_name	char(128)			NN
query_type	char(64)			NN
record_time	timestamp			NN
inserted_row_count	int4			NN
deleted_row_count	int4			NN

pg_catalog.stll_lambda_invocation_ids

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
padb_request_id	char(100)			NN
lambda_request_id	char(100)			NN
recordtime	timestamp			NN

pg_catalog.stll_table_version_events

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
xid	int8			NN
pid	int8			NN
table_id	int4			NN
old_dml_version	int8			NN
new_dml_version	int8			NN
old_ddl_end_version	int8			NN
new_ddl_end_version	int8			NN
old_ddl_start_version	int8			NN
new_ddl_start_version	int8			NN
old_structure_version	int8			NN
new_structure_version	int8			NN
old_structure_delete_version	int8			NN
new_structure_delete_version	int8			NN
event	char(32)			NN
event_location	char(16)			NN

pg_catalog.stll_tidal_tbl_perm

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	int8			NN
user_id	int4			NN
table_name	char(128)			NN
table_id	int4			NN
delete_table_id	int4			NN
slice	int4			NN
temp	int4			NN
db_id	int4			NN
dist_style	int4			NN
block_count	int4			NN
partial_block_count	int4			NN

pg_catalog.stll_topology_mapping

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
remote_topology	int8			NN
remote_node	int4			NN
native_node	int4			NN
remote_global_slice	int4			NN
native_global_slice	int4			NN
remote_node_slice	int4			NN
native_node_slice	int4			NN

pg_catalog.stll_udf_usage_in_query

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
nodeid	int4			NN
plan_node_type	int4			NN
func_id	int4			NN
func_name	char(200)			NN
func_type	int4			NN
in_targetlist	int4			NN
recordtime	timestamp			NN

pg_internal.redshift_auto_health_check_6556304

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_analyze

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
database	char(30)			NN
table_id	int4			NN
status	char(15)			NN
rows	float8			NN
modified_rows	float8			NN
threshold_percent	float8			NN
is_auto	char(1)			NN
starttime	int8			NN
endtime	int8			NN
prevtime	int8			NN
num_predicate_cols	int4			NN
num_new_predicate_cols	int4			NN
is_background	char(1)			NN
auto_analyze_phase	char(100)			NN
schema_name	char(128)			NN
table_name	char(136)			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
database	char(30)			NN
table_id	int4			NN
status	char(15)			NN
rows	float8			NN
modified_rows	float8			NN
threshold_percent	float8			NN
is_auto	char(1)			NN
starttime	int8			NN
endtime	int8			NN
prevtime	int8			NN
num_predicate_cols	int4			NN
num_new_predicate_cols	int4			NN
is_background	char(1)			NN
auto_analyze_phase	char(100)			NN
schema_name	char(128)			NN
table_name	char(136)			NN
run_info	char(288)			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_burstq_tracking

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	int8			NN
rewritten_qid	int4			NN
user_query_id	int8			NN
child_query_seq	int4			NN
pid	int4			NN
start_time	int8			NN
total_duration	int4			NN
reported_so_far	int4			NN
remaining	int4			NN
completed	int4			NN
tx_billable_state	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
recordtime	int8			NN
rewritten_qid	int4			NN
user_query_id	int8			NN
child_query_seq	int4			NN
pid	int4			NN
start_time	int8			NN
total_duration	int4			NN
reported_so_far	int4			NN
remaining	int4			NN
completed	int4			NN
tx_billable_state	int4			NN
remaining_no_minimum	int4			NN
next_request_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_arcadia_billing_txn_tracking

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	int8			NN
xid	int8			NN
pid	int4			NN
start_time	int8			NN
total_duration	int4			NN
reported_so_far	int4			NN
remaining	int4			NN
completed	int4			NN
tx_billable_state	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
recordtime	int8			NN
xid	int8			NN
pid	int4			NN
start_time	int8			NN
total_duration	int4			NN
reported_so_far	int4			NN
remaining	int4			NN
completed	int4			NN
tx_billable_state	int4			NN
remaining_no_minimum	int4			NN
next_request_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_burst_write_exec

old
column	data type	PK	U	NN
pid	int8			NN
xid	int8			NN
query	int8			NN
query_start_time	int8			NN
flush_start_time	int8			NN
stream_start_time	int8			NN
stream_end_time	int8			NN
dispatch_start_time	int8			NN
snap_in_start_time	int8			NN
snap_in_end_time	int8			NN
dispatch_end_time	int8			NN
remote_write_type	int4			NN
receiver_wam_tracking_start	int8			NN
wam_delete_start_time	int8			NN
wam_delete_end_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
pid	int8			NN
xid	int8			NN
query	int8			NN
query_start_time	int8			NN
flush_start_time	int8			NN
stream_start_time	int8			NN
stream_end_time	int8			NN
dispatch_start_time	int8			NN
snap_in_start_time	int8			NN
snap_in_end_time	int8			NN
dispatch_end_time	int8			NN
remote_write_type	int4			NN
receiver_wam_tracking_start	int8			NN
wam_delete_start_time	int8			NN
wam_delete_end_time	int8			NN
is_distall_synchronization	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_commit_internal_stats

old
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
prefetchesskipped	int8			NN
numreadsprocessed	int8			NN
numacksprocessed	int8			NN
tablebasedtosseligible	int4			NN
lastackwaittime	float8			NN
processtime	float8			NN
log_based	int4			NN
log_based_flags	int4			NN
index_log_regenerated	int4			NN
tables_total	int4			NN
tables_swept	int4			NN
headers_swept	int8			NN
tables_changed	int4			NN
blocks_pending_write	int8			NN
num_metadata_blocks_retained	int4			NN
total_metadata_blocks	int4			NN
sb_size	int8			NN
num_modified_hdrs_tracked	int8			NN
sb_sweep_tracking	int4			NN
sb_version	int8			NN
sb_sweep_optimized_commit	int4			NN
metadata_delta_validated	int4			NN
pendingwritesissued	int8			NN
sb_tree_blocks	int8			NN
log_blocks_written	int4			NN
encrypted_log_blocks_written	int4			NN
new_sb_tree_blocks	int8			NN
tossed_sb_tree_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
node	int4			NN
prefetchesskipped	int8			NN
numreadsprocessed	int8			NN
numacksprocessed	int8			NN
tablebasedtosseligible	int4			NN
lastackwaittime	float8			NN
processtime	float8			NN
log_based	int4			NN
log_based_flags	int4			NN
index_log_regenerated	int4			NN
tables_total	int4			NN
tables_swept	int4			NN
headers_swept	int8			NN
tables_changed	int4			NN
blocks_pending_write	int8			NN
num_metadata_blocks_retained	int4			NN
total_metadata_blocks	int4			NN
sb_size	int8			NN
num_modified_hdrs_tracked	int8			NN
sb_sweep_tracking	int4			NN
sb_version	int8			NN
sb_sweep_optimized_commit	int4			NN
metadata_delta_validated	int4			NN
pendingwritesissued	int8			NN
sb_tree_blocks	int8			NN
log_blocks_written	int4			NN
encrypted_log_blocks_written	int4			NN
new_sb_tree_blocks	int8			NN
tossed_sb_tree_blocks	int8			NN
num_rerep_writes_skipped	int8			NN
num_rerep_writes_issued	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_datashare_request_producer

old
column	data type	PK	U	NN
userid	int4			NN
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
xid	int8			NN
backend_start_time	int8			NN
handler_start_time	int8			NN
consumer_region	char(64)			NN
producer_cluster_id	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
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
xid	int8			NN
backend_start_time	int8			NN
handler_start_time	int8			NN
consumer_region	char(64)			NN
producer_cluster_id	char(50)			NN
action	char(128)			NN
block_header	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_disk_cache_write

old
column	data type	PK	U	NN
blocks_pushed	int4			NN
blocks_instant_pushed	int4			NN
avg_lru_size_before_push	int4			NN
push_attempts	int4			NN
pending_writes_push	int4			NN
pending_reads_push	int4			NN
blocks_written_back	int4			NN
writeback_preempts	int4			NN
avg_lru_size_before_writeback	int4			NN
writeback_attempts	int4			NN
pending_writes_writeback	int4			NN
pending_reads_writeback	int4			NN
avg_push_time_microsec	int8			NN
avg_writeback_time_microsec	int8			NN
sample_start_time	int8			NN
sample_end_time	int8			NN
node	int4			NN
rowsets_pushed	int4			NN
rowsets_instant_pushed	int4			NN
critical_writeback	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
blocks_pushed	int4			NN
blocks_instant_pushed	int4			NN
avg_lru_size_before_push	int4			NN
push_attempts	int4			NN
pending_writes_push	int4			NN
pending_reads_push	int4			NN
blocks_written_back	int4			NN
writeback_preempts	int4			NN
avg_lru_size_before_writeback	int4			NN
writeback_attempts	int4			NN
pending_writes_writeback	int4			NN
pending_reads_writeback	int4			NN
avg_push_time_microsec	int8			NN
avg_writeback_time_microsec	int8			NN
sample_start_time	int8			NN
sample_end_time	int8			NN
node	int4			NN
rowsets_pushed	int4			NN
rowsets_instant_pushed	int4			NN
critical_writeback	int4			NN
remote_write_blocks_pushed	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_insertion_point_bindings

old
column	data type	PK	U	NN
query_id	int4			NN
tbl	int4			NN
stage_tbl	int4			NN
ip_id	int4			NN
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
query_id	int4			NN
tbl	int4			NN
stage_tbl	int4			NN
ip_id	int4			NN
time	int8			NN
slice	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
exec_cluster_size	int4			NN
auto_mounted_tables_accessed	int4			NN
spectrum_file_count	int4			NN
datasharing_spectrum_tables_accessed	int4			NN
lf_datasharing_spectrum_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
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
auto_mounted_tables_accessed	int4			NN
spectrum_file_count	int4			NN
datasharing_spectrum_tables_accessed	int4			NN
lf_datasharing_spectrum_tables_accessed	int4			NN
num_pce_segs	int4			NN
slice_unmerge_query	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_lambda_client

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
request_id	char(100)			NN
function_name	char(100)			NN
recordtime	int8			NN
num_records	int4			NN
size	int4			NN
queue_id	int4			NN
batch_version	int4			NN
step	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
node	int4			NN
slice	int4			NN
segment	int4			NN
request_id	char(100)			NN
function_name	char(100)			NN
recordtime	int8			NN
num_records	int4			NN
size	int4			NN
queue_id	int4			NN
batch_version	int4			NN
step	int4			NN
func_oid	int4			NN
call_id	int4			NN
by_rpc_udf_step	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_restarted_sessions_internal

old
column	data type	PK	U	NN
currenttime	int8			NN
is_reforkable	char(10)			NN
temp_tbl_created	char(10)			NN
named_prep_stmt_ct	int4			NN
unnamed_stmt_ct	int4			NN
in_xact_blk	char(10)			NN
is_read_only	char(10)			NN
is_single_stmt_query	char(10)			NN
conn_state	char(100)			NN
pid	int4			NN
in_authentication	char(10)			NN
is_bootstrap	char(10)			NN
is_restarted_session	char(10)			NN
is_extended_protocol	char(10)			NN
is_idle_connection	char(10)			NN
current_executing_command	char(10)			NN
is_ssl_compressed	char(10)			NN
is_protocol_v3	char(10)			NN
are_commands_repeated	char(10)			NN
unsupported_command_sequence	char(10)			NN
can_reissue_query	char(10)			NN
parked_state_in_proxy	char(10)			NN
session_size	int8			NN
is_inc_resize	char(10)			NN
written_state_to_disk	char(10)			NN
auto_resume	char(10)			NN
query_command_sequence	char(32)			NN
is_fas_set	char(10)			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
is_reforkable	char(10)			NN
temp_tbl_created	char(10)			NN
named_prep_stmt_ct	int4			NN
unnamed_stmt_ct	int4			NN
in_xact_blk	char(10)			NN
is_read_only	char(10)			NN
is_single_stmt_query	char(10)			NN
conn_state	char(100)			NN
pid	int4			NN
in_authentication	char(10)			NN
is_bootstrap	char(10)			NN
is_restarted_session	char(10)			NN
is_extended_protocol	char(10)			NN
is_idle_connection	char(10)			NN
current_executing_command	char(10)			NN
is_ssl_compressed	char(10)			NN
is_protocol_v3	char(10)			NN
are_commands_repeated	char(10)			NN
unsupported_command_sequence	char(10)			NN
can_reissue_query	char(10)			NN
parked_state_in_proxy	char(10)			NN
session_size	int8			NN
is_inc_resize	char(10)			NN
written_state_to_disk	char(10)			NN
auto_resume	char(10)			NN
query_command_sequence	char(32)			NN
is_fas_set	char(10)			NN
is_idc_set	char(5)			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_tbl_perm_at_drop

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

new
column	data type	PK	U	NN
table_id	int4			NN
node	int4			NN
num_blocks	int4			NN
dist_style	int4			NN
temp	int4			NN
eventtime	int8			NN
xid	int8			NN
name	char(128)			NN
topology	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_unload_history_base

old
column	data type	PK	U	NN
user_id	int4			NN
db	char(64)			NN
xid	int8			NN
pid	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
status	int4			NN
event_time	int8			NN
slice	int4			NN
files_count_produced	int4			NN
files_size_produced	int8			NN
rows_produced	int8			NN
file_format	char(32)			NN
compression_type	char(64)			NN
unloaded_location	char(256)			NN
error_message	char(128)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
user_id	int4			NN
db	char(64)			NN
xid	int8			NN
pid	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
status	int4			NN
event_time	int8			NN
slice	int4			NN
files_count_produced	int4			NN
files_size_produced	int8			NN
rows_produced	int8			NN
file_format	char(32)			NN
compression_type	char(64)			NN
unloaded_location	char(1280)			NN
error_message	char(128)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stll_analyze

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
database	char(30)			NN
table_id	int4			NN
status	char(15)			NN
rows	float8			NN
modified_rows	float8			NN
threshold_percent	float8			NN
is_auto	char(1)			NN
starttime	timestamp			NN
endtime	timestamp			NN
prevtime	timestamp			NN
num_predicate_cols	int4			NN
num_new_predicate_cols	int4			NN
is_background	char(1)			NN
auto_analyze_phase	char(100)			NN
schema_name	char(128)			NN
table_name	char(136)			NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
database	char(30)			NN
table_id	int4			NN
status	char(15)			NN
rows	float8			NN
modified_rows	float8			NN
threshold_percent	float8			NN
is_auto	char(1)			NN
starttime	timestamp			NN
endtime	timestamp			NN
prevtime	timestamp			NN
num_predicate_cols	int4			NN
num_new_predicate_cols	int4			NN
is_background	char(1)			NN
auto_analyze_phase	char(100)			NN
schema_name	char(128)			NN
table_name	char(136)			NN
run_info	char(288)			NN

pg_catalog.stll_arcadia_billing_burstq_tracking

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
rewritten_qid	int4			NN
user_query_id	int8			NN
child_query_seq	int4			NN
pid	int4			NN
start_time	timestamp			NN
total_duration	int4			NN
reported_so_far	int4			NN
remaining	int4			NN
completed	int4			NN
tx_billable_state	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
rewritten_qid	int4			NN
user_query_id	int8			NN
child_query_seq	int4			NN
pid	int4			NN
start_time	timestamp			NN
total_duration	int4			NN
reported_so_far	int4			NN
remaining	int4			NN
completed	int4			NN
tx_billable_state	int4			NN
remaining_no_minimum	int4			NN
next_request_id	char(36)			NN

pg_catalog.stll_arcadia_billing_txn_tracking

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
xid	int8			NN
pid	int4			NN
start_time	timestamp			NN
total_duration	int4			NN
reported_so_far	int4			NN
remaining	int4			NN
completed	int4			NN
tx_billable_state	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
xid	int8			NN
pid	int4			NN
start_time	timestamp			NN
total_duration	int4			NN
reported_so_far	int4			NN
remaining	int4			NN
completed	int4			NN
tx_billable_state	int4			NN
remaining_no_minimum	int4			NN
next_request_id	char(36)			NN

pg_catalog.stll_burst_write_exec

old
column	data type	PK	U	NN
pid	int8			NN
xid	int8			NN
query	int8			NN
query_start_time	timestamp			NN
flush_start_time	timestamp			NN
stream_start_time	timestamp			NN
stream_end_time	timestamp			NN
dispatch_start_time	timestamp			NN
snap_in_start_time	timestamp			NN
snap_in_end_time	timestamp			NN
dispatch_end_time	timestamp			NN
remote_write_type	int4			NN
receiver_wam_tracking_start	timestamp			NN
wam_delete_start_time	timestamp			NN
wam_delete_end_time	timestamp			NN

new
column	data type	PK	U	NN
pid	int8			NN
xid	int8			NN
query	int8			NN
query_start_time	timestamp			NN
flush_start_time	timestamp			NN
stream_start_time	timestamp			NN
stream_end_time	timestamp			NN
dispatch_start_time	timestamp			NN
snap_in_start_time	timestamp			NN
snap_in_end_time	timestamp			NN
dispatch_end_time	timestamp			NN
remote_write_type	int4			NN
receiver_wam_tracking_start	timestamp			NN
wam_delete_start_time	timestamp			NN
wam_delete_end_time	timestamp			NN
is_distall_synchronization	int4			NN

pg_catalog.stll_commit_internal_stats

old
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
prefetchesskipped	int8			NN
numreadsprocessed	int8			NN
numacksprocessed	int8			NN
tablebasedtosseligible	int4			NN
lastackwaittime	float8			NN
processtime	float8			NN
log_based	int4			NN
log_based_flags	int4			NN
index_log_regenerated	int4			NN
tables_total	int4			NN
tables_swept	int4			NN
headers_swept	int8			NN
tables_changed	int4			NN
blocks_pending_write	int8			NN
num_metadata_blocks_retained	int4			NN
total_metadata_blocks	int4			NN
sb_size	int8			NN
num_modified_hdrs_tracked	int8			NN
sb_sweep_tracking	int4			NN
sb_version	int8			NN
sb_sweep_optimized_commit	int4			NN
metadata_delta_validated	int4			NN
pendingwritesissued	int8			NN
sb_tree_blocks	int8			NN
log_blocks_written	int4			NN
encrypted_log_blocks_written	int4			NN
new_sb_tree_blocks	int8			NN
tossed_sb_tree_blocks	int8			NN

new
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
prefetchesskipped	int8			NN
numreadsprocessed	int8			NN
numacksprocessed	int8			NN
tablebasedtosseligible	int4			NN
lastackwaittime	float8			NN
processtime	float8			NN
log_based	int4			NN
log_based_flags	int4			NN
index_log_regenerated	int4			NN
tables_total	int4			NN
tables_swept	int4			NN
headers_swept	int8			NN
tables_changed	int4			NN
blocks_pending_write	int8			NN
num_metadata_blocks_retained	int4			NN
total_metadata_blocks	int4			NN
sb_size	int8			NN
num_modified_hdrs_tracked	int8			NN
sb_sweep_tracking	int4			NN
sb_version	int8			NN
sb_sweep_optimized_commit	int4			NN
metadata_delta_validated	int4			NN
pendingwritesissued	int8			NN
sb_tree_blocks	int8			NN
log_blocks_written	int4			NN
encrypted_log_blocks_written	int4			NN
new_sb_tree_blocks	int8			NN
tossed_sb_tree_blocks	int8			NN
num_rerep_writes_skipped	int8			NN
num_rerep_writes_issued	int8			NN

pg_catalog.stll_datashare_request_producer

old
column	data type	PK	U	NN
userid	int4			NN
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	timestamp			NN
endtime	timestamp			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
xid	int8			NN
backend_start_time	timestamp			NN
handler_start_time	timestamp			NN
consumer_region	char(64)			NN
producer_cluster_id	char(50)			NN

new
column	data type	PK	U	NN
userid	int4			NN
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	timestamp			NN
endtime	timestamp			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
xid	int8			NN
backend_start_time	timestamp			NN
handler_start_time	timestamp			NN
consumer_region	char(64)			NN
producer_cluster_id	char(50)			NN
action	char(128)			NN
block_header	int4			NN

pg_catalog.stll_disk_cache_write

old
column	data type	PK	U	NN
blocks_pushed	int4			NN
blocks_instant_pushed	int4			NN
avg_lru_size_before_push	int4			NN
push_attempts	int4			NN
pending_writes_push	int4			NN
pending_reads_push	int4			NN
blocks_written_back	int4			NN
writeback_preempts	int4			NN
avg_lru_size_before_writeback	int4			NN
writeback_attempts	int4			NN
pending_writes_writeback	int4			NN
pending_reads_writeback	int4			NN
avg_push_time_microsec	int8			NN
avg_writeback_time_microsec	int8			NN
sample_start_time	timestamp			NN
sample_end_time	timestamp			NN
node	int4			NN
rowsets_pushed	int4			NN
rowsets_instant_pushed	int4			NN
critical_writeback	int4			NN

new
column	data type	PK	U	NN
blocks_pushed	int4			NN
blocks_instant_pushed	int4			NN
avg_lru_size_before_push	int4			NN
push_attempts	int4			NN
pending_writes_push	int4			NN
pending_reads_push	int4			NN
blocks_written_back	int4			NN
writeback_preempts	int4			NN
avg_lru_size_before_writeback	int4			NN
writeback_attempts	int4			NN
pending_writes_writeback	int4			NN
pending_reads_writeback	int4			NN
avg_push_time_microsec	int8			NN
avg_writeback_time_microsec	int8			NN
sample_start_time	timestamp			NN
sample_end_time	timestamp			NN
node	int4			NN
rowsets_pushed	int4			NN
rowsets_instant_pushed	int4			NN
critical_writeback	int4			NN
remote_write_blocks_pushed	int4			NN

pg_catalog.stll_insertion_point_bindings

old
column	data type	PK	U	NN
query_id	int4			NN
tbl	int4			NN
stage_tbl	int4			NN
ip_id	int4			NN
time	timestamp			NN

new
column	data type	PK	U	NN
query_id	int4			NN
tbl	int4			NN
stage_tbl	int4			NN
ip_id	int4			NN
time	timestamp			NN
slice	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
exec_cluster_size	int4			NN
auto_mounted_tables_accessed	int4			NN
spectrum_file_count	int4			NN
datasharing_spectrum_tables_accessed	int4			NN
lf_datasharing_spectrum_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
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
auto_mounted_tables_accessed	int4			NN
spectrum_file_count	int4			NN
datasharing_spectrum_tables_accessed	int4			NN
lf_datasharing_spectrum_tables_accessed	int4			NN
num_pce_segs	int4			NN
slice_unmerge_query	int4			NN

pg_catalog.stll_lambda_client

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
request_id	char(100)			NN
function_name	char(100)			NN
recordtime	timestamp			NN
num_records	int4			NN
size	int4			NN
queue_id	int4			NN
batch_version	int4			NN
step	int4			NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
request_id	char(100)			NN
function_name	char(100)			NN
recordtime	timestamp			NN
num_records	int4			NN
size	int4			NN
queue_id	int4			NN
batch_version	int4			NN
step	int4			NN
func_oid	int4			NN
call_id	int4			NN
by_rpc_udf_step	int4			NN

pg_catalog.stll_restarted_sessions_internal

old
column	data type	PK	U	NN
currenttime	timestamp			NN
is_reforkable	char(10)			NN
temp_tbl_created	char(10)			NN
named_prep_stmt_ct	int4			NN
unnamed_stmt_ct	int4			NN
in_xact_blk	char(10)			NN
is_read_only	char(10)			NN
is_single_stmt_query	char(10)			NN
conn_state	char(100)			NN
pid	int4			NN
in_authentication	char(10)			NN
is_bootstrap	char(10)			NN
is_restarted_session	char(10)			NN
is_extended_protocol	char(10)			NN
is_idle_connection	char(10)			NN
current_executing_command	char(10)			NN
is_ssl_compressed	char(10)			NN
is_protocol_v3	char(10)			NN
are_commands_repeated	char(10)			NN
unsupported_command_sequence	char(10)			NN
can_reissue_query	char(10)			NN
parked_state_in_proxy	char(10)			NN
session_size	int8			NN
is_inc_resize	char(10)			NN
written_state_to_disk	char(10)			NN
auto_resume	char(10)			NN
query_command_sequence	char(32)			NN
is_fas_set	char(10)			NN

new
column	data type	PK	U	NN
currenttime	timestamp			NN
is_reforkable	char(10)			NN
temp_tbl_created	char(10)			NN
named_prep_stmt_ct	int4			NN
unnamed_stmt_ct	int4			NN
in_xact_blk	char(10)			NN
is_read_only	char(10)			NN
is_single_stmt_query	char(10)			NN
conn_state	char(100)			NN
pid	int4			NN
in_authentication	char(10)			NN
is_bootstrap	char(10)			NN
is_restarted_session	char(10)			NN
is_extended_protocol	char(10)			NN
is_idle_connection	char(10)			NN
current_executing_command	char(10)			NN
is_ssl_compressed	char(10)			NN
is_protocol_v3	char(10)			NN
are_commands_repeated	char(10)			NN
unsupported_command_sequence	char(10)			NN
can_reissue_query	char(10)			NN
parked_state_in_proxy	char(10)			NN
session_size	int8			NN
is_inc_resize	char(10)			NN
written_state_to_disk	char(10)			NN
auto_resume	char(10)			NN
query_command_sequence	char(32)			NN
is_fas_set	char(10)			NN
is_idc_set	char(5)			NN

pg_catalog.stll_tbl_perm_at_drop

old
column	data type	PK	U	NN
table_id	int4			NN
node	int4			NN
num_blocks	int4			NN
dist_style	int4			NN
temp	int4			NN
eventtime	timestamp			NN
xid	int8			NN
name	char(128)			NN

new
column	data type	PK	U	NN
table_id	int4			NN
node	int4			NN
num_blocks	int4			NN
dist_style	int4			NN
temp	int4			NN
eventtime	timestamp			NN
xid	int8			NN
name	char(128)			NN
topology	int8			NN

pg_catalog.stll_unload_history_base

old
column	data type	PK	U	NN
user_id	int4			NN
db	char(64)			NN
xid	int8			NN
pid	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
status	int4			NN
event_time	timestamp			NN
slice	int4			NN
files_count_produced	int4			NN
files_size_produced	int8			NN
rows_produced	int8			NN
file_format	char(32)			NN
compression_type	char(64)			NN
unloaded_location	char(256)			NN
error_message	char(128)			NN

new
column	data type	PK	U	NN
user_id	int4			NN
db	char(64)			NN
xid	int8			NN
pid	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
status	int4			NN
event_time	timestamp			NN
slice	int4			NN
files_count_produced	int4			NN
files_size_produced	int8			NN
rows_produced	int8			NN
file_format	char(32)			NN
compression_type	char(64)			NN
unloaded_location	char(1280)			NN
error_message	char(128)			NN

pg_catalog.stv_inflight_undos

old
column	data type	PK	U	NN
node	int4			NN
table_id	int4			NN
undo_xid	int4			NN
undo_mode	int4			NN

new
column	data type	PK	U	NN
node	int4			NN
table_id	int4			NN
undo_xid	int8			NN
undo_mode	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
total_tables_replicated	int4			NN
total_tables_failed	int4			NN
source_state	char(128)			NN
source_error_reason	char(128)			NN
resync_state	char(128)			NN
delay_ms	int8			NN
creation_time	timestamp			NN
refresh_interval	int4			NN
source_database	char(128)			NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
database_name	char(128)			NN
synced_log_coordinate	char(128)			NN
lag_ms	int8			NN
total_tables_replicated	int4			NN
total_tables_failed	int4			NN
source_state	char(128)			NN
source_error_reason	char(128)			NN
resync_state	char(128)			NN
delay_ms	int8			NN
creation_time	timestamp			NN
refresh_interval	int4			NN
source_database	char(128)			NN
is_history_mode	char(1)			NN

pg_catalog.stv_integration_table_state

old
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
table_id	int4			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
table_id	int4			NN
is_history_mode	char(1)			NN

pg_catalog.stv_sage_query_trace_metrics

old
column	data type	PK	U	NN
query_id	int4			NN
arrival_time	timestamp			NN
inflight	int4			NN
burstable	int4			NN
cluster_size	int4			NN
execution_time_ms	int4			NN
consumed_megabytes	int4			NN
predicted_execution_times	char(400)			NN

new
column	data type	PK	U	NN
query_id	int4			NN
arrival_time	timestamp			NN
inflight	int4			NN
burstable	int4			NN
cluster_size	int4			NN
execution_time_ms	int4			NN
consumed_megabytes	int4			NN
predicted_execution_times	char(400)			NN
closed_loop_id	int4			NN
last_in_closed_loop	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
dirtiness_type	char(20)			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
write_xid	int8			NN

pg_catalog.stv_table_partitions

old
column	data type	PK	U	NN
id	int4			NN
slice	int4			NN
partition_id	int8			NN
rows	int8			NN
flags	int4			NN
num_blocks	int8			NN
num_overlapping_partitions	int4			NN
degree_of_overlap	int4			NN
is_hot	char(1)			NN
is_sorted	char(1)			NN
is_range_partitioned	char(1)			NN
qpd	int4			NN
total_wasted_blocks	int8			NN
total_blocks_read	int8			NN
total_blocks_used	int8			NN
no_loss_scans_count	int8			NN
zero_bias_scans_count	int8			NN
scan_count	int8			NN
first_qpd_rise_ts	timestamp			NN
first_marked_hot_ts	timestamp			NN
num_scans_to_mark_hot	int8			NN
is_grafted	char(1)			NN

new
column	data type	PK	U	NN
id	int4			NN
slice	int4			NN
partition_id	int8			NN
rows	int8			NN
flags	int4			NN
num_blocks	int8			NN
num_overlapping_partitions	int4			NN
degree_of_overlap	int4			NN
is_hot	char(1)			NN
is_sorted	char(1)			NN
is_range_partitioned	char(1)			NN
qpd	int4			NN
total_wasted_blocks	int8			NN
total_blocks_read	int8			NN
total_blocks_used	int8			NN
no_loss_scans_count	int8			NN
zero_bias_scans_count	int8			NN
scan_count	int8			NN
first_qpd_rise_ts	timestamp			NN
first_marked_hot_ts	timestamp			NN
num_scans_to_mark_hot	int8			NN
is_grafted	char(1)			NN
insertion_area_id	int4			NN

pg_catalog.stv_tbl_perm_property

old
column	data type	PK	U	NN
slice	int4			NN
db_id	int4			NN
namespace_id	int4			NN
id	int4			NN
name	char(72)			NN
rows	int8			NN
sorted_rows	int8			NN
temp	int4			NN
insert_pristine	int4			NN
delete_pristine	int4			NN
backup	int4			NN
dist	int4			NN
ddl_end_version	int8			NN
total_col_num	int4			NN
shadow_col_num	int4			NN
dml_end_version	int8			NN
rowid_encoding_type	int4			NN

new
column	data type	PK	U	NN
slice	int4			NN
db_id	int4			NN
namespace_id	int4			NN
id	int4			NN
name	char(72)			NN
rows	int8			NN
sorted_rows	int8			NN
temp	int4			NN
insert_pristine	int4			NN
delete_pristine	int4			NN
backup	int4			NN
dist	int4			NN
ddl_end_version	int8			NN
total_col_num	int4			NN
shadow_col_num	int4			NN
dml_end_version	int8			NN
rowid_encoding_type	int4			NN
topology	int8			NN

pg_internal.redshift_auto_health_check_6524297

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_auto_copy.copy_job_detail

old
column	data type

new
column	data type
job_owner	int8
job_id	int8
job_name	varchar(256)
generation	int4
xid	int8
file_location	varchar(256)
file_name	varchar(2048)
file_size	int8
file_etag	varchar(512)
modification_time	timestamp
enqueue_time	timestamp
ingestion_status	int2

pg_catalog.stl_burst_prepare_time

old
column	data type

new
column	data type
logtime	timestamp
xid	int8
pid	int8
qid	int4
total_time_in_prepare	float8
attempts	int4

pg_catalog.stl_datashare_write_history

old
column	data type

new
column	data type
user_id	int4
user_name	char(128)
vpid	int4
transaction_id	int8
consumer_transaction_uid	char(64)
db_id	int4
db_name	char(128)
object_type	char(64)
object_id	int4
object_name	char(128)
query_type	char(64)
record_time	timestamp
inserted_row_count	int4
deleted_row_count	int4

pg_catalog.stl_lambda_invocation_ids

old
column	data type

new
column	data type
padb_request_id	char(100)
lambda_request_id	char(100)
recordtime	timestamp

pg_catalog.stl_table_version_events

old
column	data type

new
column	data type
record_time	timestamp
xid	int8
pid	int8
table_id	int4
old_dml_version	int8
new_dml_version	int8
old_ddl_end_version	int8
new_ddl_end_version	int8
old_ddl_start_version	int8
new_ddl_start_version	int8
old_structure_version	int8
new_structure_version	int8
old_structure_delete_version	int8
new_structure_delete_version	int8
event	char(32)
event_location	char(16)

pg_catalog.stl_tidal_tbl_perm

old
column	data type

new
column	data type
recordtime	int8
user_id	int4
table_name	char(128)
table_id	int4
delete_table_id	int4
slice	int4
temp	int4
db_id	int4
dist_style	int4
block_count	int4
partial_block_count	int4

pg_catalog.stl_topology_mapping

old
column	data type

new
column	data type
record_time	timestamp
remote_topology	int8
remote_node	int4
native_node	int4
remote_global_slice	int4
native_global_slice	int4
remote_node_slice	int4
native_node_slice	int4

pg_catalog.stl_udf_usage_in_query

old
column	data type

new
column	data type
query	int4
nodeid	int4
plan_node_type	int4
func_id	int4
func_name	char(200)
func_type	int4
in_targetlist	int4
recordtime	timestamp

pg_catalog.sys_copy_job_detail

old
column	data type

new
column	data type
user_id	int8
database_name	name
job_name	varchar(256)
job_id	int8
file_location	varchar(256)
file_name	varchar(2048)
file_size	int8
file_etag	varchar(512)
modification_time	timestamp
enqueue_time	timestamp
status	text

pg_catalog.sys_datashare_write_history

old
column	data type

new
column	data type
user_id	int4
user_name	varchar(128)
session_id	int4
transaction_id	int8
consumer_transaction_uid	varchar(64)
database_name	varchar(128)
object_type	varchar(64)
object_id	int4
object_name	varchar(128)
query_type	varchar(64)
record_time	timestamp
inserted_rows	int4
deleted_rows	int4

pg_catalog.sys_integration_table_activity

old
column	data type

new
column	data type
integration_id	char(128)
checkpoint_name	char(128)
target_database	char(128)
schema_name	char(128)
table_name	char(128)
table_id	int4
record_time	timestamp
transaction_id	int8
inserted_rows	int8
deleted_rows	int8
updated_rows	int8
bytes_ingested	int8

pg_catalog.stl_analyze

old
column	data type
userid	int4
xid	int8
database	char(30)
table_id	int4
status	char(15)
rows	float8
modified_rows	float8
threshold_percent	float8
is_auto	char(1)
starttime	timestamp
endtime	timestamp
prevtime	timestamp
num_predicate_cols	int4
num_new_predicate_cols	int4
is_background	char(1)
auto_analyze_phase	char(100)
schema_name	char(128)
table_name	char(136)

new
column	data type
userid	int4
xid	int8
database	char(30)
table_id	int4
status	char(15)
rows	float8
modified_rows	float8
threshold_percent	float8
is_auto	char(1)
starttime	timestamp
endtime	timestamp
prevtime	timestamp
num_predicate_cols	int4
num_new_predicate_cols	int4
is_background	char(1)
auto_analyze_phase	char(100)
schema_name	char(128)
table_name	char(136)
run_info	char(288)

pg_catalog.stl_arcadia_billing_burstq_tracking

old
column	data type
userid	int4
recordtime	timestamp
rewritten_qid	int4
user_query_id	int8
child_query_seq	int4
pid	int4
start_time	timestamp
total_duration	int4
reported_so_far	int4
remaining	int4
completed	int4
tx_billable_state	int4

new
column	data type
userid	int4
recordtime	timestamp
rewritten_qid	int4
user_query_id	int8
child_query_seq	int4
pid	int4
start_time	timestamp
total_duration	int4
reported_so_far	int4
remaining	int4
completed	int4
tx_billable_state	int4
remaining_no_minimum	int4
next_request_id	char(36)

pg_catalog.stl_arcadia_billing_txn_tracking

old
column	data type
userid	int4
recordtime	timestamp
xid	int8
pid	int4
start_time	timestamp
total_duration	int4
reported_so_far	int4
remaining	int4
completed	int4
tx_billable_state	int4

new
column	data type
userid	int4
recordtime	timestamp
xid	int8
pid	int4
start_time	timestamp
total_duration	int4
reported_so_far	int4
remaining	int4
completed	int4
tx_billable_state	int4
remaining_no_minimum	int4
next_request_id	char(36)

pg_catalog.stl_burst_write_exec

old
column	data type
pid	int8
xid	int8
query	int8
query_start_time	timestamp
flush_start_time	timestamp
stream_start_time	timestamp
stream_end_time	timestamp
dispatch_start_time	timestamp
snap_in_start_time	timestamp
snap_in_end_time	timestamp
dispatch_end_time	timestamp
remote_write_type	int4
receiver_wam_tracking_start	timestamp
wam_delete_start_time	timestamp
wam_delete_end_time	timestamp

new
column	data type
pid	int8
xid	int8
query	int8
query_start_time	timestamp
flush_start_time	timestamp
stream_start_time	timestamp
stream_end_time	timestamp
dispatch_start_time	timestamp
snap_in_start_time	timestamp
snap_in_end_time	timestamp
dispatch_end_time	timestamp
remote_write_type	int4
receiver_wam_tracking_start	timestamp
wam_delete_start_time	timestamp
wam_delete_end_time	timestamp
is_distall_synchronization	int4

pg_catalog.stl_commit_internal_stats

old
column	data type
xid	int8
node	int4
prefetchesskipped	int8
numreadsprocessed	int8
numacksprocessed	int8
tablebasedtosseligible	int4
lastackwaittime	float8
processtime	float8
log_based	int4
log_based_flags	int4
index_log_regenerated	int4
tables_total	int4
tables_swept	int4
headers_swept	int8
tables_changed	int4
blocks_pending_write	int8
num_metadata_blocks_retained	int4
total_metadata_blocks	int4
sb_size	int8
num_modified_hdrs_tracked	int8
sb_sweep_tracking	int4
sb_version	int8
sb_sweep_optimized_commit	int4
metadata_delta_validated	int4
pendingwritesissued	int8
sb_tree_blocks	int8
log_blocks_written	int4
encrypted_log_blocks_written	int4
new_sb_tree_blocks	int8
tossed_sb_tree_blocks	int8

new
column	data type
xid	int8
node	int4
prefetchesskipped	int8
numreadsprocessed	int8
numacksprocessed	int8
tablebasedtosseligible	int4
lastackwaittime	float8
processtime	float8
log_based	int4
log_based_flags	int4
index_log_regenerated	int4
tables_total	int4
tables_swept	int4
headers_swept	int8
tables_changed	int4
blocks_pending_write	int8
num_metadata_blocks_retained	int4
total_metadata_blocks	int4
sb_size	int8
num_modified_hdrs_tracked	int8
sb_sweep_tracking	int4
sb_version	int8
sb_sweep_optimized_commit	int4
metadata_delta_validated	int4
pendingwritesissued	int8
sb_tree_blocks	int8
log_blocks_written	int4
encrypted_log_blocks_written	int4
new_sb_tree_blocks	int8
tossed_sb_tree_blocks	int8
num_rerep_writes_skipped	int8
num_rerep_writes_issued	int8

pg_catalog.stl_datashare_request_producer

old
column	data type
userid	int4
pid	int4
requestid	char(50)
sb_version	int8
dbtype	int4
dbid	int4
shareid	int4
sharename	char(128)
api_call	int4
obj_type	int4
obj_oid	int4
obj_name	char(128)
starttime	timestamp
endtime	timestamp
status	int4
message	char(512)
consumeraccountid	char(50)
consumernamespace	char(50)
consumer_transaction_uid	char(50)
is_versioned_request	int4
overridden_snapshot_xmin	int8
xid	int8
backend_start_time	timestamp
handler_start_time	timestamp
consumer_region	char(64)
producer_cluster_id	char(50)

new
column	data type
userid	int4
pid	int4
requestid	char(50)
sb_version	int8
dbtype	int4
dbid	int4
shareid	int4
sharename	char(128)
api_call	int4
obj_type	int4
obj_oid	int4
obj_name	char(128)
starttime	timestamp
endtime	timestamp
status	int4
message	char(512)
consumeraccountid	char(50)
consumernamespace	char(50)
consumer_transaction_uid	char(50)
is_versioned_request	int4
overridden_snapshot_xmin	int8
xid	int8
backend_start_time	timestamp
handler_start_time	timestamp
consumer_region	char(64)
producer_cluster_id	char(50)
action	char(128)
block_header	int4

pg_catalog.stl_disk_cache_write

old
column	data type
blocks_pushed	int4
blocks_instant_pushed	int4
avg_lru_size_before_push	int4
push_attempts	int4
pending_writes_push	int4
pending_reads_push	int4
blocks_written_back	int4
writeback_preempts	int4
avg_lru_size_before_writeback	int4
writeback_attempts	int4
pending_writes_writeback	int4
pending_reads_writeback	int4
avg_push_time_microsec	int8
avg_writeback_time_microsec	int8
sample_start_time	timestamp
sample_end_time	timestamp
node	int4
rowsets_pushed	int4
rowsets_instant_pushed	int4
critical_writeback	int4

new
column	data type
blocks_pushed	int4
blocks_instant_pushed	int4
avg_lru_size_before_push	int4
push_attempts	int4
pending_writes_push	int4
pending_reads_push	int4
blocks_written_back	int4
writeback_preempts	int4
avg_lru_size_before_writeback	int4
writeback_attempts	int4
pending_writes_writeback	int4
pending_reads_writeback	int4
avg_push_time_microsec	int8
avg_writeback_time_microsec	int8
sample_start_time	timestamp
sample_end_time	timestamp
node	int4
rowsets_pushed	int4
rowsets_instant_pushed	int4
critical_writeback	int4
remote_write_blocks_pushed	int4

pg_catalog.stl_insertion_point_bindings

old
column	data type
query_id	int4
tbl	int4
stage_tbl	int4
ip_id	int4
time	timestamp

new
column	data type
query_id	int4
tbl	int4
stage_tbl	int4
ip_id	int4
time	timestamp
slice	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
exec_cluster_size	int4
auto_mounted_tables_accessed	int4
spectrum_file_count	int4
datasharing_spectrum_tables_accessed	int4
lf_datasharing_spectrum_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
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
auto_mounted_tables_accessed	int4
spectrum_file_count	int4
datasharing_spectrum_tables_accessed	int4
lf_datasharing_spectrum_tables_accessed	int4
num_pce_segs	int4
slice_unmerge_query	int4

pg_catalog.stl_lambda_client

old
column	data type
query	int4
node	int4
slice	int4
segment	int4
request_id	char(100)
function_name	char(100)
recordtime	timestamp
num_records	int4
size	int4
queue_id	int4
batch_version	int4
step	int4

new
column	data type
query	int4
node	int4
slice	int4
segment	int4
request_id	char(100)
function_name	char(100)
recordtime	timestamp
num_records	int4
size	int4
queue_id	int4
batch_version	int4
step	int4
func_oid	int4
call_id	int4
by_rpc_udf_step	int4

pg_catalog.stl_restarted_sessions_internal

old
column	data type
currenttime	timestamp
is_reforkable	char(10)
temp_tbl_created	char(10)
named_prep_stmt_ct	int4
unnamed_stmt_ct	int4
in_xact_blk	char(10)
is_read_only	char(10)
is_single_stmt_query	char(10)
conn_state	char(100)
pid	int4
in_authentication	char(10)
is_bootstrap	char(10)
is_restarted_session	char(10)
is_extended_protocol	char(10)
is_idle_connection	char(10)
current_executing_command	char(10)
is_ssl_compressed	char(10)
is_protocol_v3	char(10)
are_commands_repeated	char(10)
unsupported_command_sequence	char(10)
can_reissue_query	char(10)
parked_state_in_proxy	char(10)
session_size	int8
is_inc_resize	char(10)
written_state_to_disk	char(10)
auto_resume	char(10)
query_command_sequence	char(32)
is_fas_set	char(10)

new
column	data type
currenttime	timestamp
is_reforkable	char(10)
temp_tbl_created	char(10)
named_prep_stmt_ct	int4
unnamed_stmt_ct	int4
in_xact_blk	char(10)
is_read_only	char(10)
is_single_stmt_query	char(10)
conn_state	char(100)
pid	int4
in_authentication	char(10)
is_bootstrap	char(10)
is_restarted_session	char(10)
is_extended_protocol	char(10)
is_idle_connection	char(10)
current_executing_command	char(10)
is_ssl_compressed	char(10)
is_protocol_v3	char(10)
are_commands_repeated	char(10)
unsupported_command_sequence	char(10)
can_reissue_query	char(10)
parked_state_in_proxy	char(10)
session_size	int8
is_inc_resize	char(10)
written_state_to_disk	char(10)
auto_resume	char(10)
query_command_sequence	char(32)
is_fas_set	char(10)
is_idc_set	char(5)

pg_catalog.stl_tbl_perm_at_drop

old
column	data type
table_id	int4
node	int4
num_blocks	int4
dist_style	int4
temp	int4
eventtime	timestamp
xid	int8
name	char(128)

new
column	data type
table_id	int4
node	int4
num_blocks	int4
dist_style	int4
temp	int4
eventtime	timestamp
xid	int8
name	char(128)
topology	int8

pg_catalog.stl_unload_history_base

old
column	data type
user_id	int4
db	char(64)
xid	int8
pid	int4
query_id	int8
child_query_sequence	int4
child_query_id	int4
status	int4
event_time	timestamp
slice	int4
files_count_produced	int4
files_size_produced	int8
rows_produced	int8
file_format	char(32)
compression_type	char(64)
unloaded_location	char(256)
error_message	char(128)

new
column	data type
user_id	int4
db	char(64)
xid	int8
pid	int4
query_id	int8
child_query_sequence	int4
child_query_id	int4
status	int4
event_time	timestamp
slice	int4
files_count_produced	int4
files_size_produced	int8
rows_produced	int8
file_format	char(32)
compression_type	char(64)
unloaded_location	char(1280)
error_message	char(128)