Redshift Observatory System Table Tracker

Tables

pg_catalog.stcs_burst_prepare_failures

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

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
nodeid	int4			NN
whens	int4			NN
when_with_udf	int4			NN
then_with_udf	int4			NN
else_with_udf	int4			NN
nested_case_with_udf	int4			NN
total_udfs	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_hdr_integrity_error_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	int8			NN
node_num	int4			NN
sb_ver	int8			NN
xid	int8			NN
sb_pos	int4			NN
hdr_dump_redacted	char(209)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_superblock_bg_trickle_validation_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
xid	int8			NN
start_time	int8			NN
end_time	int8			NN
snapshot_sb_version	int8			NN
tree_based_sb_mode	int4			NN
snapshot_sb_num_blocks	int8			NN
log_entries_validated	int8			NN
log_blocks_validated	int8			NN
tree_entries_validated	int8			NN
execution_time_of_log_validation	int8			NN
execution_time_of_tree_validation	int8			NN
trickle_validation_done	int4			NN
log_rotation_done	int4			NN
was_tree_validated	int4			NN
tree_trickle_validation_done	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_superblock_bg_trickle_validation_summary

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
start_time	int8			NN
end_time	int8			NN
snapshot_sb_version	int8			NN
tree_based_sb_mode	int4			NN
snapshot_sb_num_blocks	int8			NN
log_blocks_validated	int8			NN
log_entries_validated	int8			NN
tree_entries_validated	int8			NN
trickle_validation_done	int4			NN
tree_trickle_validation_done	int4			NN
num_steps_trickle_validation	int4			NN
num_steps_log_validation	int4			NN
execution_time_of_log_validation	int8			NN
num_steps_tree_validation	int4			NN
execution_time_of_tree_validation	int8			NN
log_rotation_done	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_wlm_qmr_config

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
service_class	int4			NN
rule_name	char(256)			NN
action	char(256)			NN
metric_name	char(256)			NN
metric_operator	char(2)			NN
metric_value	float8			NN
action_value	char(256)			NN
eventtime	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_failures

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

pg_catalog.stll_case_expr_with_udfs

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
query	int4			NN
nodeid	int4			NN
whens	int4			NN
when_with_udf	int4			NN
then_with_udf	int4			NN
else_with_udf	int4			NN
nested_case_with_udf	int4			NN
total_udfs	int4			NN

pg_catalog.stll_hdr_integrity_error_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	timestamp			NN
node_num	int4			NN
sb_ver	int8			NN
xid	int8			NN
sb_pos	int4			NN
hdr_dump_redacted	char(209)			NN

pg_catalog.stll_superblock_bg_trickle_validation_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
xid	int8			NN
start_time	timestamp			NN
end_time	timestamp			NN
snapshot_sb_version	int8			NN
tree_based_sb_mode	int4			NN
snapshot_sb_num_blocks	int8			NN
log_entries_validated	int8			NN
log_blocks_validated	int8			NN
tree_entries_validated	int8			NN
execution_time_of_log_validation	int8			NN
execution_time_of_tree_validation	int8			NN
trickle_validation_done	int4			NN
log_rotation_done	int4			NN
was_tree_validated	int4			NN
tree_trickle_validation_done	int4			NN

pg_catalog.stll_superblock_bg_trickle_validation_summary

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
start_time	timestamp			NN
end_time	timestamp			NN
snapshot_sb_version	int8			NN
tree_based_sb_mode	int4			NN
snapshot_sb_num_blocks	int8			NN
log_blocks_validated	int8			NN
log_entries_validated	int8			NN
tree_entries_validated	int8			NN
trickle_validation_done	int4			NN
tree_trickle_validation_done	int4			NN
num_steps_trickle_validation	int4			NN
num_steps_log_validation	int4			NN
execution_time_of_log_validation	int8			NN
num_steps_tree_validation	int4			NN
execution_time_of_tree_validation	int8			NN
log_rotation_done	int4			NN

pg_catalog.stll_wlm_qmr_config

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
service_class	int4			NN
rule_name	char(256)			NN
action	char(256)			NN
metric_name	char(256)			NN
metric_operator	char(2)			NN
metric_value	float8			NN
action_value	char(256)			NN
eventtime	timestamp			NN

pg_internal.redshift_auto_health_check_37429965

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_burst_billing_ris_response_error

old
column	data type	PK	U	NN
request_id	char(100)			NN
error_type	char(128)			NN
error_cause	char(128)			NN
log_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
request_id	char(100)			NN
error_type	char(128)			NN
error_cause	char(128)			NN
log_time	int8			NN
is_serverless	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
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

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
num_shared_contexts	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_integration_cdc_detail

old
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
database_name	char(128)			NN
checkpoint	char(128)			NN
source_type	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
status	int4			NN
synced_log_coordinate	char(128)			NN
src_inserts	int8			NN
src_deletes	int8			NN
src_updates	int8			NN
inserts	int8			NN
inserts_dt	int8			NN
parsed_rows	int8			NN
skipped_rows	int8			NN
is_bursted	int4			NN
bytes_ingested	int8			NN
updated_rows	int8			NN
validation_status	int4			NN
xid	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
database_name	char(128)			NN
checkpoint	char(128)			NN
source_type	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
status	int4			NN
synced_log_coordinate	char(128)			NN
src_inserts	int8			NN
src_deletes	int8			NN
src_updates	int8			NN
inserts	int8			NN
inserts_dt	int8			NN
parsed_rows	int8			NN
skipped_rows	int8			NN
is_bursted	int4			NN
bytes_ingested	int8			NN
updated_rows	int8			NN
validation_status	int4			NN
xid	int8			NN
replication_mode	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_local_s3_scan_file_stats

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
slice	int4			NN
file	char(512)			NN
file_type	int4			NN
file_size_bytes	int8			NN
num_columns	int8			NN
footer_size_bytes	int8			NN
page_index_size_bytes	int8			NN
num_row_groups	int8			NN
min_row_group_size_bytes	int8			NN
max_row_group_size_bytes	int8			NN
avg_row_group_size_bytes	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
slice	int4			NN
file	char(512)			NN
file_type	int4			NN
file_size_bytes	int8			NN
num_columns	int8			NN
footer_size_bytes	int8			NN
page_index_size_bytes	int8			NN
num_row_groups	int8			NN
min_row_group_size_bytes	int8			NN
max_row_group_size_bytes	int8			NN
avg_row_group_size_bytes	int8			NN
file_format_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

pg_catalog.stcs_query_prediction

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
execution_time	float8			NN
execution_time_error	float8			NN
memory	float8			NN
memory_error	float8			NN
execution_time_without_compile	float8			NN
execution_time_without_compile_error	float8			NN
burst_exec_time	float8			NN
burst_exec_time_error	float8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
execution_time	float8			NN
execution_time_error	float8			NN
memory	float8			NN
memory_error	float8			NN
execution_time_without_compile	float8			NN
execution_time_without_compile_error	float8			NN
burst_exec_time	float8			NN
burst_exec_time_error	float8			NN
local_scaling_prediction	float8			NN
query_feature	char(256)			NN
local_scaling_feature	char(512)			NN
scaling_feature	char(512)			NN
copy_feature	char(128)			NN
copy_memory_feature	char(128)			NN
copy_scaling_feature	char(128)			NN
vacuum_feature	char(128)			NN
spectrum_file_count_feature	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_query_scaling_prediction

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
cluster_size	int4			NN
execution_time	float8			NN
source	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
cluster_size	int4			NN
execution_time	float8			NN
source	int4			NN
underassigned_memory_mb_per_cn	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_superblock

old
column	data type	PK	U	NN
node	int4			NN
record_time	int8			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	int4			NN
sb_tree_root_pos	int4			NN
sb_tree_height	int4			NN
sb_tree_mode	int4			NN
sb_tree_blocks	int4			NN
sb_tree_root_guid	char(36)			NN
tombstoned_sb_tree_blocks	int4			NN
leader_snapshot_blocks	int4			NN
pg_wal_blocks	int4			NN
logchain_blocks	int4			NN
metachain_blocks	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
node	int4			NN
record_time	int8			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	int4			NN
sb_tree_root_pos	int4			NN
sb_tree_height	int4			NN
sb_tree_mode	int4			NN
sb_tree_blocks	int4			NN
sb_tree_root_guid	char(36)			NN
tombstoned_sb_tree_blocks	int4			NN
leader_snapshot_blocks	int4			NN
pg_wal_blocks	int4			NN
logchain_blocks	int4			NN
metachain_blocks	int4			NN
ds_blocks	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_burst_billing_ris_response_error

old
column	data type	PK	U	NN
request_id	char(100)			NN
error_type	char(128)			NN
error_cause	char(128)			NN
log_time	timestamp			NN

new
column	data type	PK	U	NN
request_id	char(100)			NN
error_type	char(128)			NN
error_cause	char(128)			NN
log_time	timestamp			NN
is_serverless	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
num_tree_blocks	int8			NN
num_log_blocks	int8			NN
max_num_tree_blocks	int8			NN
max_num_log_blocks	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
num_shared_contexts	int8			NN

pg_catalog.stll_integration_cdc_detail

old
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
database_name	char(128)			NN
checkpoint	char(128)			NN
source_type	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
status	int4			NN
synced_log_coordinate	char(128)			NN
src_inserts	int8			NN
src_deletes	int8			NN
src_updates	int8			NN
inserts	int8			NN
inserts_dt	int8			NN
parsed_rows	int8			NN
skipped_rows	int8			NN
is_bursted	int4			NN
bytes_ingested	int8			NN
updated_rows	int8			NN
validation_status	int4			NN
xid	int8			NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
database_name	char(128)			NN
checkpoint	char(128)			NN
source_type	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
status	int4			NN
synced_log_coordinate	char(128)			NN
src_inserts	int8			NN
src_deletes	int8			NN
src_updates	int8			NN
inserts	int8			NN
inserts_dt	int8			NN
parsed_rows	int8			NN
skipped_rows	int8			NN
is_bursted	int4			NN
bytes_ingested	int8			NN
updated_rows	int8			NN
validation_status	int4			NN
xid	int8			NN
replication_mode	int4			NN

pg_catalog.stll_local_s3_scan_file_stats

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
slice	int4			NN
file	char(512)			NN
file_type	int4			NN
file_size_bytes	int8			NN
num_columns	int8			NN
footer_size_bytes	int8			NN
page_index_size_bytes	int8			NN
num_row_groups	int8			NN
min_row_group_size_bytes	int8			NN
max_row_group_size_bytes	int8			NN
avg_row_group_size_bytes	int8			NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
slice	int4			NN
file	char(512)			NN
file_type	int4			NN
file_size_bytes	int8			NN
num_columns	int8			NN
footer_size_bytes	int8			NN
page_index_size_bytes	int8			NN
num_row_groups	int8			NN
min_row_group_size_bytes	int8			NN
max_row_group_size_bytes	int8			NN
avg_row_group_size_bytes	int8			NN
file_format_version	int4			NN

pg_catalog.stll_query_prediction

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
execution_time	float8			NN
execution_time_error	float8			NN
memory	float8			NN
memory_error	float8			NN
execution_time_without_compile	float8			NN
execution_time_without_compile_error	float8			NN
burst_exec_time	float8			NN
burst_exec_time_error	float8			NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
execution_time	float8			NN
execution_time_error	float8			NN
memory	float8			NN
memory_error	float8			NN
execution_time_without_compile	float8			NN
execution_time_without_compile_error	float8			NN
burst_exec_time	float8			NN
burst_exec_time_error	float8			NN
local_scaling_prediction	float8			NN
query_feature	char(256)			NN
local_scaling_feature	char(512)			NN
scaling_feature	char(512)			NN
copy_feature	char(128)			NN
copy_memory_feature	char(128)			NN
copy_scaling_feature	char(128)			NN
vacuum_feature	char(128)			NN
spectrum_file_count_feature	char(16)			NN

pg_catalog.stll_query_scaling_prediction

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
cluster_size	int4			NN
execution_time	float8			NN
source	int4			NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
cluster_size	int4			NN
execution_time	float8			NN
source	int4			NN
underassigned_memory_mb_per_cn	int4			NN

pg_catalog.stll_superblock

old
column	data type	PK	U	NN
node	int4			NN
record_time	timestamp			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	int4			NN
sb_tree_root_pos	int4			NN
sb_tree_height	int4			NN
sb_tree_mode	int4			NN
sb_tree_blocks	int4			NN
sb_tree_root_guid	char(36)			NN
tombstoned_sb_tree_blocks	int4			NN
leader_snapshot_blocks	int4			NN
pg_wal_blocks	int4			NN
logchain_blocks	int4			NN
metachain_blocks	int4			NN

new
column	data type	PK	U	NN
node	int4			NN
record_time	timestamp			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	int4			NN
sb_tree_root_pos	int4			NN
sb_tree_height	int4			NN
sb_tree_mode	int4			NN
sb_tree_blocks	int4			NN
sb_tree_root_guid	char(36)			NN
tombstoned_sb_tree_blocks	int4			NN
leader_snapshot_blocks	int4			NN
pg_wal_blocks	int4			NN
logchain_blocks	int4			NN
metachain_blocks	int4			NN
ds_blocks	int4			NN

pg_catalog.stll_tidal_tbl_perm

old
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

new
column	data type	PK	U	NN
recordtime	timestamp			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.stv_io_readahead

old
column	data type	PK	U	NN
node	int4			NN
pid	int4			NN
scanner	int4			NN
fraction	float8			NN
numblocks	int4			NN

new
column	data type	PK	U	NN
node	int4			NN
pid	int4			NN
scanner	int4			NN
fraction	float8			NN
numblocks	int8			NN

pg_catalog.stv_superblock

old
column	data type	PK	U	NN
node	int4			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	int4			NN
sb_tree_root_pos	int4			NN
sb_tree_height	int4			NN
sb_tree_mode	int4			NN
sb_tree_blocks	int4			NN
sb_tree_root_guid	char(36)			NN
tombstoned_sb_tree_blocks	int4			NN
leader_snapshot_blocks	int4			NN
pg_wal_blocks	int4			NN
logchain_blocks	int4			NN
metachain_blocks	int4			NN

new
column	data type	PK	U	NN
node	int4			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	int4			NN
sb_tree_root_pos	int4			NN
sb_tree_height	int4			NN
sb_tree_mode	int4			NN
sb_tree_blocks	int4			NN
sb_tree_root_guid	char(36)			NN
tombstoned_sb_tree_blocks	int4			NN
leader_snapshot_blocks	int4			NN
pg_wal_blocks	int4			NN
logchain_blocks	int4			NN
metachain_blocks	int4			NN
ds_blocks	int4			NN

pg_internal.redshift_auto_health_check_7771061

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_burst_prepare_failures

old
column	data type

new
column	data type
logtime	timestamp
xid	int8
pid	int8
qid	int4

pg_catalog.stl_case_expr_with_udfs

old
column	data type

new
column	data type
query	int4
nodeid	int4
whens	int4
when_with_udf	int4
then_with_udf	int4
else_with_udf	int4
nested_case_with_udf	int4
total_udfs	int4

pg_catalog.stl_hdr_integrity_error_redacted

old
column	data type

new
column	data type
recordtime	timestamp
node_num	int4
sb_ver	int8
xid	int8
sb_pos	int4
hdr_dump_redacted	char(209)

pg_catalog.stl_superblock_bg_trickle_validation_stats

old
column	data type

new
column	data type
node	int4
xid	int8
start_time	timestamp
end_time	timestamp
snapshot_sb_version	int8
tree_based_sb_mode	int4
snapshot_sb_num_blocks	int8
log_entries_validated	int8
log_blocks_validated	int8
tree_entries_validated	int8
execution_time_of_log_validation	int8
execution_time_of_tree_validation	int8
trickle_validation_done	int4
log_rotation_done	int4
was_tree_validated	int4
tree_trickle_validation_done	int4

pg_catalog.stl_superblock_bg_trickle_validation_summary

old
column	data type

new
column	data type
node	int4
start_time	timestamp
end_time	timestamp
snapshot_sb_version	int8
tree_based_sb_mode	int4
snapshot_sb_num_blocks	int8
log_blocks_validated	int8
log_entries_validated	int8
tree_entries_validated	int8
trickle_validation_done	int4
tree_trickle_validation_done	int4
num_steps_trickle_validation	int4
num_steps_log_validation	int4
execution_time_of_log_validation	int8
num_steps_tree_validation	int4
execution_time_of_tree_validation	int8
log_rotation_done	int4

pg_catalog.stl_wlm_qmr_config

old
column	data type

new
column	data type
service_class	int4
rule_name	char(256)
action	char(256)
metric_name	char(256)
metric_operator	char(2)
metric_value	float8
action_value	char(256)
eventtime	timestamp

pg_catalog.stl_burst_billing_ris_response_error

old
column	data type
request_id	char(100)
error_type	char(128)
error_cause	char(128)
log_time	timestamp

new
column	data type
request_id	char(100)
error_type	char(128)
error_cause	char(128)
log_time	timestamp
is_serverless	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
num_tree_blocks	int8
num_log_blocks	int8
max_num_tree_blocks	int8
max_num_log_blocks	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
num_shared_contexts	int8

pg_catalog.stl_integration_cdc_detail

old
column	data type
record_time	timestamp
integration_id	char(128)
database_name	char(128)
checkpoint	char(128)
source_type	char(128)
schema_name	char(128)
table_name	char(128)
status	int4
synced_log_coordinate	char(128)
src_inserts	int8
src_deletes	int8
src_updates	int8
inserts	int8
inserts_dt	int8
parsed_rows	int8
skipped_rows	int8
is_bursted	int4
bytes_ingested	int8
updated_rows	int8
validation_status	int4
xid	int8

new
column	data type
record_time	timestamp
integration_id	char(128)
database_name	char(128)
checkpoint	char(128)
source_type	char(128)
schema_name	char(128)
table_name	char(128)
status	int4
synced_log_coordinate	char(128)
src_inserts	int8
src_deletes	int8
src_updates	int8
inserts	int8
inserts_dt	int8
parsed_rows	int8
skipped_rows	int8
is_bursted	int4
bytes_ingested	int8
updated_rows	int8
validation_status	int4
xid	int8
replication_mode	int4

pg_catalog.stl_local_s3_scan_file_stats

old
column	data type
query	int4
segment	int4
slice	int4
file	char(512)
file_type	int4
file_size_bytes	int8
num_columns	int8
footer_size_bytes	int8
page_index_size_bytes	int8
num_row_groups	int8
min_row_group_size_bytes	int8
max_row_group_size_bytes	int8
avg_row_group_size_bytes	int8

new
column	data type
query	int4
segment	int4
slice	int4
file	char(512)
file_type	int4
file_size_bytes	int8
num_columns	int8
footer_size_bytes	int8
page_index_size_bytes	int8
num_row_groups	int8
min_row_group_size_bytes	int8
max_row_group_size_bytes	int8
avg_row_group_size_bytes	int8
file_format_version	int4

pg_catalog.stl_query_prediction

old
column	data type
query	int4
xid	int8
execution_time	float8
execution_time_error	float8
memory	float8
memory_error	float8
execution_time_without_compile	float8
execution_time_without_compile_error	float8
burst_exec_time	float8
burst_exec_time_error	float8

new
column	data type
query	int4
xid	int8
execution_time	float8
execution_time_error	float8
memory	float8
memory_error	float8
execution_time_without_compile	float8
execution_time_without_compile_error	float8
burst_exec_time	float8
burst_exec_time_error	float8
local_scaling_prediction	float8
query_feature	char(256)
local_scaling_feature	char(512)
scaling_feature	char(512)
copy_feature	char(128)
copy_memory_feature	char(128)
copy_scaling_feature	char(128)
vacuum_feature	char(128)
spectrum_file_count_feature	char(16)

pg_catalog.stl_query_scaling_prediction

old
column	data type
query	int4
xid	int8
cluster_size	int4
execution_time	float8
source	int4

new
column	data type
query	int4
xid	int8
cluster_size	int4
execution_time	float8
source	int4
underassigned_memory_mb_per_cn	int4

pg_catalog.stl_superblock

old
column	data type
node	int4
record_time	timestamp
fs_version	int8
sb_version	int8
defrag_version	int8
num_blocks	int4
high_qid	int8
crc	int4
flags	int4
num_uncommitted	int8
active_log	int4
is_extended_superblock	int4
superblock_capacity	int8
perm_blocks	int4
freelist_size	int4
bloat	int4
sb_tree_root_pos	int4
sb_tree_height	int4
sb_tree_mode	int4
sb_tree_blocks	int4
sb_tree_root_guid	char(36)
tombstoned_sb_tree_blocks	int4
leader_snapshot_blocks	int4
pg_wal_blocks	int4
logchain_blocks	int4
metachain_blocks	int4

new
column	data type
node	int4
record_time	timestamp
fs_version	int8
sb_version	int8
defrag_version	int8
num_blocks	int4
high_qid	int8
crc	int4
flags	int4
num_uncommitted	int8
active_log	int4
is_extended_superblock	int4
superblock_capacity	int8
perm_blocks	int4
freelist_size	int4
bloat	int4
sb_tree_root_pos	int4
sb_tree_height	int4
sb_tree_mode	int4
sb_tree_blocks	int4
sb_tree_root_guid	char(36)
tombstoned_sb_tree_blocks	int4
leader_snapshot_blocks	int4
pg_wal_blocks	int4
logchain_blocks	int4
metachain_blocks	int4
ds_blocks	int4

pg_catalog.stl_tidal_tbl_perm

old
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

new
column	data type
recordtime	timestamp
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