Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
new	pg_catalog	internal	volatile	_record	stl_lwlock_status	None

Tables

pg_catalog.stcs_segment_ce_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
segment	int4			NN
num_data_slices	int4			NN
num_compute_slices	int4			NN
num_active_compute_slices	int4			NN
parallelization_mode	char(32)			NN
row_fetcher_state	char(32)			NN
row_fetcher_reason	int8			NN
work_stealing_state	int8			NN
lds_distribution_state	int8			NN
topology_type	char(32)			NN
topology_id	int8			NN
target_topology_id	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_user_vacuum_history

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
transaction_id	int8			NN
query_id	int8			NN
database_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(136)			NN
table_id	int4			NN
vacuum_type	char(30)			NN
status	char(30)			NN
start_time	int8			NN
end_time	int8			NN
record_time	int8			NN
duration	int8			NN
rows_before_vacuum	int8			NN
size_before_vacuum	int8			NN
reclaimable_rows	int8			NN
reclaimed_rows	int8			NN
reclaimed_blocks	int8			NN
sortedrows_before_vacuum	int8			NN
sortedrows_after_vacuum	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_segment_ce_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
segment	int4			NN
num_data_slices	int4			NN
num_compute_slices	int4			NN
num_active_compute_slices	int4			NN
parallelization_mode	char(32)			NN
row_fetcher_state	char(32)			NN
row_fetcher_reason	int8			NN
work_stealing_state	int8			NN
lds_distribution_state	int8			NN
topology_type	char(32)			NN
topology_id	int8			NN
target_topology_id	int8			NN

pg_catalog.stll_user_vacuum_history

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
transaction_id	int8			NN
query_id	int8			NN
database_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(136)			NN
table_id	int4			NN
vacuum_type	char(30)			NN
status	char(30)			NN
start_time	timestamp			NN
end_time	timestamp			NN
record_time	timestamp			NN
duration	int8			NN
rows_before_vacuum	int8			NN
size_before_vacuum	int8			NN
reclaimable_rows	int8			NN
reclaimed_rows	int8			NN
reclaimed_blocks	int8			NN
sortedrows_before_vacuum	int8			NN
sortedrows_after_vacuum	int8			NN

pg_catalog.stv_xrestore_state

old
column	data type	PK	U	NN

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

pg_internal.redshift_auto_health_check_3639131

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

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
time_spent_generating_manifest	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_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
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

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
manifest_compress_level	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_datashare_query_info

old
column	data type	PK	U	NN
userid	int4			NN
leaderpid	int4			NN
xid	int8			NN
query	int4			NN
table_id	int4			NN
current_dml_version	int8			NN
current_sructure_version	int8			NN
current_sb_version	int8			NN
current_ddl_version	int8			NN
target_dml_version	int8			NN
target_structure_version	int8			NN
target_sb_version	int8			NN
target_ddl_version	int8			NN
leader_node_start_time	int8			NN
leader_node_end_time	int8			NN
node	int4			NN
compute_node_start_time	int8			NN
compute_node_end_time	int8			NN
refresh_queue_start_time	int8			NN
refresh_queue_end_time	int8			NN
sb_download_grafting_start_time	int8			NN
sb_download_grafting_end_time	int8			NN
total_sb_download_seconds	float8			NN
total_sb_batches	int4			NN
changed_headers	int8			NN
table_grafting_mode	char(16)			NN
sb_download_mode	char(16)			NN
superblock_type	char(256)			NN
schema_name_table_name	char(256)			NN
table_size	int8			NN
total_log_entries_changed	int8			NN
total_sb_size	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
leaderpid	int4			NN
xid	int8			NN
query	int4			NN
table_id	int4			NN
current_dml_version	int8			NN
current_sructure_version	int8			NN
current_sb_version	int8			NN
current_ddl_version	int8			NN
target_dml_version	int8			NN
target_structure_version	int8			NN
target_sb_version	int8			NN
target_ddl_version	int8			NN
leader_node_start_time	int8			NN
leader_node_end_time	int8			NN
node	int4			NN
compute_node_start_time	int8			NN
compute_node_end_time	int8			NN
refresh_queue_start_time	int8			NN
refresh_queue_end_time	int8			NN
sb_download_grafting_start_time	int8			NN
sb_download_grafting_end_time	int8			NN
total_sb_download_seconds	float8			NN
total_sb_batches	int4			NN
changed_headers	int8			NN
table_grafting_mode	char(16)			NN
sb_download_mode	char(16)			NN
superblock_type	char(256)			NN
schema_name_table_name	char(256)			NN
table_size	int8			NN
total_log_entries_changed	int8			NN
total_sb_size	int8			NN
num_cols_grafted	int4			NN
total_num_cols	int4			NN
__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_stats

old
column	data type	PK	U	NN
logtime	int8			NN
adds	int8			NN
new_blocks	int8			NN
dbr_blocks	int8			NN
pins	int8			NN
faults	int8			NN
throttles	int8			NN
scan_starts	int8			NN
cache_size	int4			NN
lru_size	int4			NN
throttle	int8			NN
ra_points	float8			NN
scans_running	int4			NN
evictions	int8			NN
prefetches	int8			NN
node	int4			NN
max_size	int4			NN
max_pushout_latency_us	int8			NN
rowset_blocks_spilled	int8			NN
rerep_write_skipped_exhausted_write_pool	int8			NN
max_rowsets_pinned	int8			NN
rowsets_currently_in_cache	int8			NN
rowsets_currently_pinned	int8			NN
accesses_to_outstanding_req	int8			NN
percentage_shared_mem_used	int4			NN
max_percentage_shared_mem_used	int4			NN
disk_upgrade_requests	int8			NN
successful_disk_upgrades	int8			NN
disk_upgrades_dropped	int8			NN
disk_upgrades_not_useful	int8			NN
s3_upgrade_requests	int8			NN
successful_s3_upgrades	int8			NN
s3_upgrades_dropped	int8			NN
num_upsizings	int8			NN
num_downsizings	int8			NN
largest_size_limit	int8			NN
smallest_size_limit	int8			NN
avg_size_limit	int8			NN
oom_eviction_calls	int4			NN
num_pushout_downsizings	int8			NN
dirty_block_size	int8			NN
dirty_rowset_block_size	int8			NN
max_dirty_block_size	int8			NN
max_dirty_rowset_block_size	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
logtime	int8			NN
adds	int8			NN
new_blocks	int8			NN
dbr_blocks	int8			NN
pins	int8			NN
faults	int8			NN
throttles	int8			NN
scan_starts	int8			NN
cache_size	int4			NN
lru_size	int4			NN
throttle	int8			NN
ra_points	float8			NN
scans_running	int4			NN
evictions	int8			NN
prefetches	int8			NN
node	int4			NN
max_size	int4			NN
max_pushout_latency_us	int8			NN
rowset_blocks_spilled	int8			NN
rerep_write_skipped_exhausted_write_pool	int8			NN
max_rowsets_pinned	int8			NN
rowsets_currently_in_cache	int8			NN
rowsets_currently_pinned	int8			NN
accesses_to_outstanding_req	int8			NN
percentage_shared_mem_used	int4			NN
max_percentage_shared_mem_used	int4			NN
disk_upgrade_requests	int8			NN
successful_disk_upgrades	int8			NN
disk_upgrades_dropped	int8			NN
disk_upgrades_not_useful	int8			NN
s3_upgrade_requests	int8			NN
successful_s3_upgrades	int8			NN
s3_upgrades_dropped	int8			NN
num_upsizings	int8			NN
num_downsizings	int8			NN
largest_size_limit	int8			NN
smallest_size_limit	int8			NN
avg_size_limit	int8			NN
oom_eviction_calls	int4			NN
num_pushout_downsizings	int8			NN
dirty_block_size	int8			NN
dirty_rowset_block_size	int8			NN
max_dirty_block_size	int8			NN
max_dirty_rowset_block_size	int8			NN
num_tree_blocks	int8			NN
num_log_blocks	int8			NN
max_num_tree_blocks	int8			NN
max_num_log_blocks	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_insert

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

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

pg_catalog.stcs_integration_log

old
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
status	char(128)			NN
database_name	char(128)			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
synced_log_coordinate	char(128)			NN
num_modified_tables	int4			NN
lag_ms	int8			NN
checkpoint_bytes	int8			NN
integration_start_time	int8			NN
last_commit_timestamp	int8			NN
num_failed_tables	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
status	char(128)			NN
database_name	char(128)			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
synced_log_coordinate	char(128)			NN
num_modified_tables	int4			NN
lag_ms	int8			NN
checkpoint_bytes	int8			NN
integration_start_time	int8			NN
last_commit_timestamp	int8			NN
num_failed_tables	int4			NN
delay_ms	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_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
__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
__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_lwlock

old
column	data type	PK	U	NN
log_time	int8			NN
pid	int4			NN
lwlockid	int4			NN
lwlock_name	char(50)			NN
mode	char(25)			NN
acquire_wait_us	int8			NN
spinlock_max_wait_us	int8			NN
num_spinlock_waits	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
log_time	int8			NN
pid	int4			NN
lwlockid	int4			NN
lwlock_name	char(50)			NN
mode	char(25)			NN
acquire_wait_us	int8			NN
spinlock_max_wait_us	int8			NN
num_spinlock_waits	int8			NN
hold_time_us	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_nft_statement_replay_status

old
column	data type	PK	U	NN
pid	int4			NN
xid	int8			NN
database	int4			NN
sessionid	char(36)			NN
replay_start	int8			NN
replay_end	int8			NN
command_type	char(32)			NN
command_text	char(255)			NN
new_nft_replay	int4			NN
lazy_replay	int4			NN
reissue_status	char(255)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
pid	int4			NN
xid	int8			NN
database	int4			NN
sessionid	char(36)			NN
replay_start	int8			NN
replay_end	int8			NN
command_type	char(32)			NN
command_text	char(255)			NN
new_nft_replay	int4			NN
lazy_replay	int4			NN
reissue_status	char(255)			NN
multi_statement_replay	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_perf_permanent_channel_source

old
column	data type	PK	U	NN
since	int8			NN
now	int8			NN
node	int4			NN
slice	int4			NN
channel_type	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
borrow_total_ns	int8			NN
borrow_max_ns	int8			NN
queue_delay_sample_total_ns	int8			NN
queue_delay_sample_max_ns	int8			NN
channel_source_init_us	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

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

old
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
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
transfer_size	int8			NN
data_size	int8			NN
start_time	int8			NN
end_time	int8			NN
transfer_time	int8			NN
compression_time	int8			NN
connect_time	int8			NN
app_connect_time	int8			NN
retries	int4			NN
request_id	char(32)			NN
extended_request_id	char(128)			NN
ip_address	char(64)			NN
thread_id	int4			NN
original_start_time_us	int8			NN
total_transfer_time_us_with_retries	int8			NN
node	int4			NN
tbl_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
is_spectrum_request	int4			NN
segnum	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
recordtime	int8			NN
pid	int4			NN
http_method	char(64)			NN
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
transfer_size	int8			NN
data_size	int8			NN
start_time	int8			NN
end_time	int8			NN
transfer_time	int8			NN
compression_time	int8			NN
connect_time	int8			NN
app_connect_time	int8			NN
retries	int4			NN
request_id	char(32)			NN
extended_request_id	char(128)			NN
ip_address	char(64)			NN
thread_id	int4			NN
original_start_time_us	int8			NN
total_transfer_time_us_with_retries	int8			NN
node	int4			NN
tbl_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
is_spectrum_request	int4			NN
segnum	int8			NN
sb_pos	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_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
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

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
sb_pos	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_s3client_trace

old
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
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
message	char(256)			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
slice	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
message	char(256)			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
sb_pos	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stll_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
sb_segments_available	int4			NN
backup_manifest_available	int4			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
time_spent_generating_manifest	int8			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
s3commit_aware_backup	int4			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
manifest_compress_level	int4			NN

pg_catalog.stll_datashare_query_info

old
column	data type	PK	U	NN
userid	int4			NN
leaderpid	int4			NN
xid	int8			NN
query	int4			NN
table_id	int4			NN
current_dml_version	int8			NN
current_sructure_version	int8			NN
current_sb_version	int8			NN
current_ddl_version	int8			NN
target_dml_version	int8			NN
target_structure_version	int8			NN
target_sb_version	int8			NN
target_ddl_version	int8			NN
leader_node_start_time	timestamp			NN
leader_node_end_time	timestamp			NN
node	int4			NN
compute_node_start_time	timestamp			NN
compute_node_end_time	timestamp			NN
refresh_queue_start_time	timestamp			NN
refresh_queue_end_time	timestamp			NN
sb_download_grafting_start_time	timestamp			NN
sb_download_grafting_end_time	timestamp			NN
total_sb_download_seconds	float8			NN
total_sb_batches	int4			NN
changed_headers	int8			NN
table_grafting_mode	char(16)			NN
sb_download_mode	char(16)			NN
superblock_type	char(256)			NN
schema_name_table_name	char(256)			NN
table_size	int8			NN
total_log_entries_changed	int8			NN
total_sb_size	int8			NN

new
column	data type	PK	U	NN
userid	int4			NN
leaderpid	int4			NN
xid	int8			NN
query	int4			NN
table_id	int4			NN
current_dml_version	int8			NN
current_sructure_version	int8			NN
current_sb_version	int8			NN
current_ddl_version	int8			NN
target_dml_version	int8			NN
target_structure_version	int8			NN
target_sb_version	int8			NN
target_ddl_version	int8			NN
leader_node_start_time	timestamp			NN
leader_node_end_time	timestamp			NN
node	int4			NN
compute_node_start_time	timestamp			NN
compute_node_end_time	timestamp			NN
refresh_queue_start_time	timestamp			NN
refresh_queue_end_time	timestamp			NN
sb_download_grafting_start_time	timestamp			NN
sb_download_grafting_end_time	timestamp			NN
total_sb_download_seconds	float8			NN
total_sb_batches	int4			NN
changed_headers	int8			NN
table_grafting_mode	char(16)			NN
sb_download_mode	char(16)			NN
superblock_type	char(256)			NN
schema_name_table_name	char(256)			NN
table_size	int8			NN
total_log_entries_changed	int8			NN
total_sb_size	int8			NN
num_cols_grafted	int4			NN
total_num_cols	int4			NN

pg_catalog.stll_disk_cache_stats

old
column	data type	PK	U	NN
logtime	timestamp			NN
adds	int8			NN
new_blocks	int8			NN
dbr_blocks	int8			NN
pins	int8			NN
faults	int8			NN
throttles	int8			NN
scan_starts	int8			NN
cache_size	int4			NN
lru_size	int4			NN
throttle	int8			NN
ra_points	float8			NN
scans_running	int4			NN
evictions	int8			NN
prefetches	int8			NN
node	int4			NN
max_size	int4			NN
max_pushout_latency_us	int8			NN
rowset_blocks_spilled	int8			NN
rerep_write_skipped_exhausted_write_pool	int8			NN
max_rowsets_pinned	int8			NN
rowsets_currently_in_cache	int8			NN
rowsets_currently_pinned	int8			NN
accesses_to_outstanding_req	int8			NN
percentage_shared_mem_used	int4			NN
max_percentage_shared_mem_used	int4			NN
disk_upgrade_requests	int8			NN
successful_disk_upgrades	int8			NN
disk_upgrades_dropped	int8			NN
disk_upgrades_not_useful	int8			NN
s3_upgrade_requests	int8			NN
successful_s3_upgrades	int8			NN
s3_upgrades_dropped	int8			NN
num_upsizings	int8			NN
num_downsizings	int8			NN
largest_size_limit	int8			NN
smallest_size_limit	int8			NN
avg_size_limit	int8			NN
oom_eviction_calls	int4			NN
num_pushout_downsizings	int8			NN
dirty_block_size	int8			NN
dirty_rowset_block_size	int8			NN
max_dirty_block_size	int8			NN
max_dirty_rowset_block_size	int8			NN

new
column	data type	PK	U	NN
logtime	timestamp			NN
adds	int8			NN
new_blocks	int8			NN
dbr_blocks	int8			NN
pins	int8			NN
faults	int8			NN
throttles	int8			NN
scan_starts	int8			NN
cache_size	int4			NN
lru_size	int4			NN
throttle	int8			NN
ra_points	float8			NN
scans_running	int4			NN
evictions	int8			NN
prefetches	int8			NN
node	int4			NN
max_size	int4			NN
max_pushout_latency_us	int8			NN
rowset_blocks_spilled	int8			NN
rerep_write_skipped_exhausted_write_pool	int8			NN
max_rowsets_pinned	int8			NN
rowsets_currently_in_cache	int8			NN
rowsets_currently_pinned	int8			NN
accesses_to_outstanding_req	int8			NN
percentage_shared_mem_used	int4			NN
max_percentage_shared_mem_used	int4			NN
disk_upgrade_requests	int8			NN
successful_disk_upgrades	int8			NN
disk_upgrades_dropped	int8			NN
disk_upgrades_not_useful	int8			NN
s3_upgrade_requests	int8			NN
successful_s3_upgrades	int8			NN
s3_upgrades_dropped	int8			NN
num_upsizings	int8			NN
num_downsizings	int8			NN
largest_size_limit	int8			NN
smallest_size_limit	int8			NN
avg_size_limit	int8			NN
oom_eviction_calls	int4			NN
num_pushout_downsizings	int8			NN
dirty_block_size	int8			NN
dirty_rowset_block_size	int8			NN
max_dirty_block_size	int8			NN
max_dirty_rowset_block_size	int8			NN
num_tree_blocks	int8			NN
num_log_blocks	int8			NN
max_num_tree_blocks	int8			NN
max_num_log_blocks	int8			NN

pg_catalog.stll_insert

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

pg_catalog.stll_integration_log

old
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
status	char(128)			NN
database_name	char(128)			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
synced_log_coordinate	char(128)			NN
num_modified_tables	int4			NN
lag_ms	int8			NN
checkpoint_bytes	int8			NN
integration_start_time	timestamp			NN
last_commit_timestamp	timestamp			NN
num_failed_tables	int4			NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
integration_type	char(128)			NN
state	char(128)			NN
status	char(128)			NN
database_name	char(128)			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
synced_log_coordinate	char(128)			NN
num_modified_tables	int4			NN
lag_ms	int8			NN
checkpoint_bytes	int8			NN
integration_start_time	timestamp			NN
last_commit_timestamp	timestamp			NN
num_failed_tables	int4			NN
delay_ms	int8			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

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

pg_catalog.stll_lwlock

old
column	data type	PK	U	NN
log_time	timestamp			NN
pid	int4			NN
lwlockid	int4			NN
lwlock_name	char(50)			NN
mode	char(25)			NN
acquire_wait_us	int8			NN
spinlock_max_wait_us	int8			NN
num_spinlock_waits	int8			NN

new
column	data type	PK	U	NN
log_time	timestamp			NN
pid	int4			NN
lwlockid	int4			NN
lwlock_name	char(50)			NN
mode	char(25)			NN
acquire_wait_us	int8			NN
spinlock_max_wait_us	int8			NN
num_spinlock_waits	int8			NN
hold_time_us	int8			NN

pg_catalog.stll_nft_statement_replay_status

old
column	data type	PK	U	NN
pid	int4			NN
xid	int8			NN
database	int4			NN
sessionid	char(36)			NN
replay_start	timestamp			NN
replay_end	timestamp			NN
command_type	char(32)			NN
command_text	char(255)			NN
new_nft_replay	int4			NN
lazy_replay	int4			NN
reissue_status	char(255)			NN

new
column	data type	PK	U	NN
pid	int4			NN
xid	int8			NN
database	int4			NN
sessionid	char(36)			NN
replay_start	timestamp			NN
replay_end	timestamp			NN
command_type	char(32)			NN
command_text	char(255)			NN
new_nft_replay	int4			NN
lazy_replay	int4			NN
reissue_status	char(255)			NN
multi_statement_replay	int4			NN

pg_catalog.stll_perf_permanent_channel_source

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

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

pg_catalog.stll_s3client

old
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
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
transfer_size	int8			NN
data_size	int8			NN
start_time	int8			NN
end_time	int8			NN
transfer_time	int8			NN
compression_time	int8			NN
connect_time	int8			NN
app_connect_time	int8			NN
retries	int4			NN
request_id	char(32)			NN
extended_request_id	char(128)			NN
ip_address	char(64)			NN
thread_id	int4			NN
original_start_time_us	int8			NN
total_transfer_time_us_with_retries	int8			NN
node	int4			NN
tbl_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
is_spectrum_request	int4			NN
segnum	int8			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
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
transfer_size	int8			NN
data_size	int8			NN
start_time	int8			NN
end_time	int8			NN
transfer_time	int8			NN
compression_time	int8			NN
connect_time	int8			NN
app_connect_time	int8			NN
retries	int4			NN
request_id	char(32)			NN
extended_request_id	char(128)			NN
ip_address	char(64)			NN
thread_id	int4			NN
original_start_time_us	int8			NN
total_transfer_time_us_with_retries	int8			NN
node	int4			NN
tbl_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
is_spectrum_request	int4			NN
segnum	int8			NN
sb_pos	int4			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
segment	int8			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
sb_pos	int4			NN

pg_catalog.stll_s3client_trace

old
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
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
message	char(256)			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
slice	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
message	char(256)			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
sb_pos	int4			NN

pg_catalog.stv_alter_checkpoint_state

old
column	data type	PK	U	NN
xid	int8			NN
tbl	int4			NN
command_type	char(128)			NN
target_distkey	int4			NN
scanned_rows	int4			NN
tbl_rows	int4			NN
num_of_iterations	int4			NN

new
column	data type	PK	U	NN
xid	int8			NN
tbl	int4			NN
command_type	char(128)			NN
target_distkey	int4			NN
scanned_rows	int8			NN
tbl_rows	int8			NN
num_of_iterations	int4			NN

pg_catalog.stv_cdc_connection

old
column	data type	PK	U	NN
record_time	timestamp			NN
channel_id	char(128)			NN
channel_state	char(128)			NN
database_name	char(128)			NN
sharding_policy	char(128)			NN
latest_scanned_checkpoint	char(128)			NN
synced_binlog_coordinate	char(128)			NN
latest_applied_pe_checkpoint	char(128)			NN
lag_ms	int8			NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
channel_id	char(128)			NN
channel_state	char(128)			NN
database_name	char(128)			NN
sharding_policy	char(128)			NN
latest_scanned_checkpoint	char(128)			NN
synced_binlog_coordinate	char(128)			NN
latest_applied_pe_checkpoint	char(128)			NN
lag_ms	int8			NN
resync_channel_state	char(128)			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

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

pg_catalog.stv_comm_diag_ping_stats

old
column	data type	PK	U	NN
recordtime	timestamp			NN
ip_addr	char(16)			NN
status	char(5)			NN
elapsed_time_us	int4			NN
expected_seq	int8			NN
recd_seq	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stv_comm_state_orphans

old
column	data type	PK	U	NN
node	int4			NN
type	char(8)			NN
channel_id	int4			NN
channel_type	char(32)			NN
ref_count	int4			NN
shutdown_time	timestamp			NN
shutdown_pid	int4			NN
shutdown_bt	char(256)			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_3550221

old
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
a	int4

new
column	data type	PK	U	NN

Views

pg_catalog.stl_segment_ce_stats

old
column	data type

new
column	data type
query	int4
node	int4
segment	int4
num_data_slices	int4
num_compute_slices	int4
num_active_compute_slices	int4
parallelization_mode	char(32)
row_fetcher_state	char(32)
row_fetcher_reason	int8
work_stealing_state	int8
lds_distribution_state	int8
topology_type	char(32)
topology_id	int8
target_topology_id	int8

pg_catalog.stl_user_vacuum_history

old
column	data type

new
column	data type
user_id	int4
transaction_id	int8
query_id	int8
database_name	char(128)
schema_name	char(128)
table_name	char(136)
table_id	int4
vacuum_type	char(30)
status	char(30)
start_time	timestamp
end_time	timestamp
record_time	timestamp
duration	int8
rows_before_vacuum	int8
size_before_vacuum	int8
reclaimable_rows	int8
reclaimed_rows	int8
reclaimed_blocks	int8
sortedrows_before_vacuum	int8
sortedrows_after_vacuum	int8

pg_catalog.svv_active_cursors

old
column	data type

new
column	data type
user_id	int4
cursor_name	char(256)
transaction_id	int8
session_id	int4
declare_time	timestamp
total_bytes	int8
total_rows	int8
fetched_rows	int8
cursor_storage_limit_used_percent	float8

pg_catalog.svv_lwlocks

old
column	data type

new
column	data type
lock_id	int4
lock_name	name
release_ok	bool
num_shared_holders	int2
exclusive_holder_pid	int4
last_change	timestamp

pg_catalog.sys_copy_replacements

old
column	data type

new
column	data type
user_id	int4
query_id	int8
table_id	int4
file_name	char(256)
column_name	char(127)
line_number	int8
raw_line	char(1024)

pg_catalog.sys_external_query_error

old
column	data type

new
column	data type
user_id	int4
query_id	int8
file_location	char(256)
rowid	char(2100)
column_name	char(127)
original_value	char(1024)
modified_value	char(1024)
trigger	text
action	text
action_value	char(127)
error_code	int4

pg_catalog.sys_mv_state

old
column	data type

new
column	data type
user_id	int8
transaction_id	int8
database_name	char(128)
event_desc	char(500)
start_time	timestamp
base_table_database_name	char(128)
base_table_schema	char(128)
base_table_name	char(128)
mv_schema	char(128)
mv_name	char(128)
state	char(32)

pg_catalog.sys_restore_state

old
column	data type

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

pg_catalog.sys_schema_quota_violations

old
column	data type

new
column	data type
owner_id	int4
user_id	int4
transaction_id	int8
session_id	int4
schema_id	int4
schema_name	char(128)
quota	int4
disk_usage	int4
record_time	timestamp

pg_catalog.sys_spatial_simplify

old
column	data type

new
column	data type
query_id	int8
line_number	int8
maximum_tolerance	float8
initial_size	int8
simplified	char(1)
final_size	int8
final_tolerance	float8

pg_catalog.sys_userlog

old
column	data type

new
column	data type
user_id	int4
user_name	char(50)
original_user_name	char(50)
action	char(10)
has_create_db_privs	int4
is_superuser	int4
has_update_catalog_privs	int4
password_expiration	timestamp
session_id	int4
transaction_id	int8
record_time	timestamp

pg_catalog.sys_vacuum_history

old
column	data type

new
column	data type
user_id	int4
transaction_id	int8
query_id	int8
database_name	char(128)
schema_name	char(128)
table_name	char(136)
table_id	int4
vacuum_type	char(30)
is_automatic	text
status	char(30)
start_time	timestamp
end_time	timestamp
record_time	timestamp
duration	int8
rows_before_vacuum	int8
size_before_vacuum	int8
reclaimable_rows	int8
reclaimed_rows	int8
reclaimed_blocks	int8
sortedrows_before_vacuum	int8
sortedrows_after_vacuum	int8

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
sb_segments_available	int4
backup_manifest_available	int4

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

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)
s3commit_aware_backup	int4

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
manifest_compress_level	int4

pg_catalog.stl_datashare_query_info

old
column	data type
userid	int4
leaderpid	int4
xid	int8
query	int4
table_id	int4
current_dml_version	int8
current_sructure_version	int8
current_sb_version	int8
current_ddl_version	int8
target_dml_version	int8
target_structure_version	int8
target_sb_version	int8
target_ddl_version	int8
leader_node_start_time	timestamp
leader_node_end_time	timestamp
node	int4
compute_node_start_time	timestamp
compute_node_end_time	timestamp
refresh_queue_start_time	timestamp
refresh_queue_end_time	timestamp
sb_download_grafting_start_time	timestamp
sb_download_grafting_end_time	timestamp
total_sb_download_seconds	float8
total_sb_batches	int4
changed_headers	int8
table_grafting_mode	char(16)
sb_download_mode	char(16)
superblock_type	char(256)
schema_name_table_name	char(256)
table_size	int8
total_log_entries_changed	int8
total_sb_size	int8

new
column	data type
userid	int4
leaderpid	int4
xid	int8
query	int4
table_id	int4
current_dml_version	int8
current_sructure_version	int8
current_sb_version	int8
current_ddl_version	int8
target_dml_version	int8
target_structure_version	int8
target_sb_version	int8
target_ddl_version	int8
leader_node_start_time	timestamp
leader_node_end_time	timestamp
node	int4
compute_node_start_time	timestamp
compute_node_end_time	timestamp
refresh_queue_start_time	timestamp
refresh_queue_end_time	timestamp
sb_download_grafting_start_time	timestamp
sb_download_grafting_end_time	timestamp
total_sb_download_seconds	float8
total_sb_batches	int4
changed_headers	int8
table_grafting_mode	char(16)
sb_download_mode	char(16)
superblock_type	char(256)
schema_name_table_name	char(256)
table_size	int8
total_log_entries_changed	int8
total_sb_size	int8
num_cols_grafted	int4
total_num_cols	int4

pg_catalog.stl_disk_cache_stats

old
column	data type
logtime	timestamp
adds	int8
new_blocks	int8
dbr_blocks	int8
pins	int8
faults	int8
throttles	int8
scan_starts	int8
cache_size	int4
lru_size	int4
throttle	int8
ra_points	float8
scans_running	int4
evictions	int8
prefetches	int8
node	int4
max_size	int4
max_pushout_latency_us	int8
rowset_blocks_spilled	int8
rerep_write_skipped_exhausted_write_pool	int8
max_rowsets_pinned	int8
rowsets_currently_in_cache	int8
rowsets_currently_pinned	int8
accesses_to_outstanding_req	int8
percentage_shared_mem_used	int4
max_percentage_shared_mem_used	int4
disk_upgrade_requests	int8
successful_disk_upgrades	int8
disk_upgrades_dropped	int8
disk_upgrades_not_useful	int8
s3_upgrade_requests	int8
successful_s3_upgrades	int8
s3_upgrades_dropped	int8
num_upsizings	int8
num_downsizings	int8
largest_size_limit	int8
smallest_size_limit	int8
avg_size_limit	int8
oom_eviction_calls	int4
num_pushout_downsizings	int8
dirty_block_size	int8
dirty_rowset_block_size	int8
max_dirty_block_size	int8
max_dirty_rowset_block_size	int8

new
column	data type
logtime	timestamp
adds	int8
new_blocks	int8
dbr_blocks	int8
pins	int8
faults	int8
throttles	int8
scan_starts	int8
cache_size	int4
lru_size	int4
throttle	int8
ra_points	float8
scans_running	int4
evictions	int8
prefetches	int8
node	int4
max_size	int4
max_pushout_latency_us	int8
rowset_blocks_spilled	int8
rerep_write_skipped_exhausted_write_pool	int8
max_rowsets_pinned	int8
rowsets_currently_in_cache	int8
rowsets_currently_pinned	int8
accesses_to_outstanding_req	int8
percentage_shared_mem_used	int4
max_percentage_shared_mem_used	int4
disk_upgrade_requests	int8
successful_disk_upgrades	int8
disk_upgrades_dropped	int8
disk_upgrades_not_useful	int8
s3_upgrade_requests	int8
successful_s3_upgrades	int8
s3_upgrades_dropped	int8
num_upsizings	int8
num_downsizings	int8
largest_size_limit	int8
smallest_size_limit	int8
avg_size_limit	int8
oom_eviction_calls	int4
num_pushout_downsizings	int8
dirty_block_size	int8
dirty_rowset_block_size	int8
max_dirty_block_size	int8
max_dirty_rowset_block_size	int8
num_tree_blocks	int8
num_log_blocks	int8
max_num_tree_blocks	int8
max_num_log_blocks	int8

pg_catalog.stl_insert

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
tbl	int4
inserted_mega_value	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
inserted_mega_value	char(1)
use_staging_table	char(1)

pg_catalog.stl_integration_log

old
column	data type
record_time	timestamp
integration_id	char(128)
integration_type	char(128)
state	char(128)
status	char(128)
database_name	char(128)
checkpoint_name	char(128)
checkpoint_type	char(16)
synced_log_coordinate	char(128)
num_modified_tables	int4
lag_ms	int8
checkpoint_bytes	int8
integration_start_time	timestamp
last_commit_timestamp	timestamp
num_failed_tables	int4

new
column	data type
record_time	timestamp
integration_id	char(128)
integration_type	char(128)
state	char(128)
status	char(128)
database_name	char(128)
checkpoint_name	char(128)
checkpoint_type	char(16)
synced_log_coordinate	char(128)
num_modified_tables	int4
lag_ms	int8
checkpoint_bytes	int8
integration_start_time	timestamp
last_commit_timestamp	timestamp
num_failed_tables	int4
delay_ms	int8

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

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

pg_catalog.stl_lwlock

old
column	data type
log_time	timestamp
pid	int4
lwlockid	int4
lwlock_name	char(50)
mode	char(25)
acquire_wait_us	int8
spinlock_max_wait_us	int8
num_spinlock_waits	int8

new
column	data type
log_time	timestamp
pid	int4
lwlockid	int4
lwlock_name	char(50)
mode	char(25)
acquire_wait_us	int8
spinlock_max_wait_us	int8
num_spinlock_waits	int8
hold_time_us	int8

pg_catalog.stl_nft_statement_replay_status

old
column	data type
pid	int4
xid	int8
database	int4
sessionid	char(36)
replay_start	timestamp
replay_end	timestamp
command_type	char(32)
command_text	char(255)
new_nft_replay	int4
lazy_replay	int4
reissue_status	char(255)

new
column	data type
pid	int4
xid	int8
database	int4
sessionid	char(36)
replay_start	timestamp
replay_end	timestamp
command_type	char(32)
command_text	char(255)
new_nft_replay	int4
lazy_replay	int4
reissue_status	char(255)
multi_statement_replay	int4

pg_catalog.stl_perf_permanent_channel_source

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

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

pg_catalog.stl_s3client

old
column	data type
userid	int4
query	int4
slice	int4
recordtime	timestamp
pid	int4
http_method	char(64)
s3_action	char(64)
bucket	char(64)
key	char(256)
transfer_size	int8
data_size	int8
start_time	int8
end_time	int8
transfer_time	int8
compression_time	int8
connect_time	int8
app_connect_time	int8
retries	int4
request_id	char(32)
extended_request_id	char(128)
ip_address	char(64)
thread_id	int4
original_start_time_us	int8
total_transfer_time_us_with_retries	int8
node	int4
tbl_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
is_spectrum_request	int4
segnum	int8

new
column	data type
userid	int4
query	int4
slice	int4
recordtime	timestamp
pid	int4
http_method	char(64)
s3_action	char(64)
bucket	char(64)
key	char(256)
transfer_size	int8
data_size	int8
start_time	int8
end_time	int8
transfer_time	int8
compression_time	int8
connect_time	int8
app_connect_time	int8
retries	int4
request_id	char(32)
extended_request_id	char(128)
ip_address	char(64)
thread_id	int4
original_start_time_us	int8
total_transfer_time_us_with_retries	int8
node	int4
tbl_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
is_spectrum_request	int4
segnum	int8
sb_pos	int4

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

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
sb_pos	int4

pg_catalog.stl_s3client_trace

old
column	data type
userid	int4
query	int4
slice	int4
recordtime	timestamp
pid	int4
http_method	char(64)
s3_action	char(64)
bucket	char(64)
key	char(256)
message	char(256)
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
slice	int4
recordtime	timestamp
pid	int4
http_method	char(64)
s3_action	char(64)
bucket	char(64)
key	char(256)
message	char(256)
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
sb_pos	int4

pg_catalog.svcs_insert

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

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

pg_catalog.svv_attached_masking_policy

old
column	data type
policy_name	varchar(128)
schema_name	varchar(128)
table_name	varchar(128)
table_type	varchar(7)
grantor	varchar(128)
grantee	varchar(128)
grantee_type	varchar(6)
priority	int4
input_columns	varchar(256)
output_columns	varchar(256)

new
column	data type
policy_name	varchar(128)
schema_name	varchar(128)
table_name	varchar(128)
table_type	varchar(17)
grantor	varchar(128)
grantee	varchar(128)
grantee_type	varchar(6)
priority	int4
input_columns	varchar(256)
output_columns	varchar(256)

pg_catalog.sys_integration_table_state

old
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

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	timestamp

pg_catalog.sys_spectrum_scan_error

old
column	data type
userid	int4
query	int8
location	char(256)
rowid	char(2100)
colname	char(127)
original_value	char(1024)
modified_value	char(1024)
trigger	text
action	text
action_value	char(127)
error_code	int4

new
column	data type