Redshift Observatory System Table Tracker

Tables

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.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_internal.redshift_auto_health_check_9688348

old
column	data type	PK	U	NN

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

pg_catalog.pg_mv_properties

old
column	data type	PK	U	NN
mv_oid	oid			NN
mv_state	int2			NN
mv_version_major	int2			NN
mv_version_minor	int2			NN
is_autorefreshable	bool			NN
is_autorewritable	bool			NN
is_automv	bool			NN
has_mutable_functions	bool			NN
has_aggregates_or_grouping	bool			NN
supports_cascade	bool			NN

new
column	data type	PK	U	NN

pg_catalog.pg_mv_refresh_state

old
column	data type	PK	U	NN
mv_oid	oid			NN
db_name	name			NN
mv_xid	int8			NN
mv_inflight_txns	int8[]
mv_last_cascade_xids	int8[]

new
column	data type	PK	U	NN

pg_catalog.pg_s3_metadata

old
column	data type	PK	U	NN
metadata_table_oid	oid			NN
metadata_refresh_xid	int8			NN
metadata_iceberg_snapshot_id	int8			NN
metadata_high_vacuum_xid	int8			NN
metadata_has_manifest	bool			NN
metadata_num_files	int8			NN
metadata_num_rows	int8			NN

new
column	data type	PK	U	NN

pg_catalog.pg_structure_change

old
column	data type	PK	U	NN
rel_oid	oid			NN
vacuum_xid	int8			NN
truncate_xid	int8			NN
small_table_conversion_xid	int8			NN
alter_xid	int8			NN

new
column	data type	PK	U	NN

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

pg_catalog.stcs_burst_soid_requests

old
column	data type	PK	U	NN
pid	int4			NN
write_xid	int8			NN
type	int4			NN
starttime	int8			NN
endtime	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

pg_catalog.stcs_encryption_trace

old
column	data type	PK	U	NN
pid	int4			NN
slice	int4			NN
recordtime	int8			NN
start_time	int8			NN
end_time	int8			NN
status	int4			NN
active_key_id	char(36)			NN
operation_type	int4			NN
trace_id	int4			NN
key_creation_time	int8			NN
new_key_id	char(36)			NN
input_bytes	int8			NN
output_bytes	int8			NN
cur_stek_state	int4			NN
new_stek_state	int4			NN
sys_table	char(128)			NN
latency_p50	int8			NN
latency_p90	int8			NN
latency_p99	int8			NN
size_p50	int8			NN
size_p90	int8			NN
size_p99	int8			NN
message	char(512)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_integration_maintenance_activities

old
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
db_name	char(128)			NN
maintenance_type	char(128)			NN
start_time	int8			NN
end_time	int8			NN
num_tables_maintained	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

pg_catalog.stcs_local_s3_scan_sr_processing_stats

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
file	char(512)			NN
offset_bytes	int8			NN
length_bytes	int8			NN
deserialize_time	int8			NN
footer_first_prefetch_trigger_time	int8			NN
footer_first_fetch_sent_time	int8			NN
footer_first_fetch_ready_time	int8			NN
triggered_second_footer_prefetch	char(1)			NN
footer_second_prefetch_trigger_time	int8			NN
footer_second_fetch_sent_time	int8			NN
footer_second_fetch_ready_time	int8			NN
footer_parse_starttime	int8			NN
footer_parse_endtime	int8			NN
blf_starttime	int8			NN
blf_endtime	int8			NN
assigned_time	int8			NN
execution_starttime	int8			NN
execution_endtime	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

pg_catalog.stcs_vec_scan_local_s3_stats

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
slice	int4			NN
step	int4			NN
num_rows	int8			NN
num_nulls	int8			NN
num_non_nulls	int8			NN
num_overflows	int8			NN
num_cols	int4			NN
avg_page_header_size	int8			NN
max_page_header_size	int8			NN
avg_data_page_size	int8			NN
max_data_page_size	int8			NN
num_values_dictionary_page	int8			NN
num_pages_dictionary_page	int8			NN
num_values_plain	int8			NN
num_pages_plain	int8			NN
num_values_dictionary_index	int8			NN
num_pages_dictionary_index	int8			NN
num_values_rle	int8			NN
num_pages_rle	int8			NN
num_values_delta	int8			NN
num_pages_delta	int8			NN
num_values_others	int8			NN
num_pages_others	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

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

pg_catalog.stll_burst_soid_requests

old
column	data type	PK	U	NN
pid	int4			NN
write_xid	int8			NN
type	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN

new
column	data type	PK	U	NN

pg_catalog.stll_encryption_trace

old
column	data type	PK	U	NN
pid	int4			NN
slice	int4			NN
recordtime	timestamp			NN
start_time	timestamp			NN
end_time	timestamp			NN
status	int4			NN
active_key_id	char(36)			NN
operation_type	int4			NN
trace_id	int4			NN
key_creation_time	timestamp			NN
new_key_id	char(36)			NN
input_bytes	int8			NN
output_bytes	int8			NN
cur_stek_state	int4			NN
new_stek_state	int4			NN
sys_table	char(128)			NN
latency_p50	int8			NN
latency_p90	int8			NN
latency_p99	int8			NN
size_p50	int8			NN
size_p90	int8			NN
size_p99	int8			NN
message	char(512)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_integration_maintenance_activities

old
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
db_name	char(128)			NN
maintenance_type	char(128)			NN
start_time	timestamp			NN
end_time	timestamp			NN
num_tables_maintained	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_local_s3_scan_sr_processing_stats

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
file	char(512)			NN
offset_bytes	int8			NN
length_bytes	int8			NN
deserialize_time	timestamp			NN
footer_first_prefetch_trigger_time	timestamp			NN
footer_first_fetch_sent_time	timestamp			NN
footer_first_fetch_ready_time	timestamp			NN
triggered_second_footer_prefetch	char(1)			NN
footer_second_prefetch_trigger_time	timestamp			NN
footer_second_fetch_sent_time	timestamp			NN
footer_second_fetch_ready_time	timestamp			NN
footer_parse_starttime	timestamp			NN
footer_parse_endtime	timestamp			NN
blf_starttime	timestamp			NN
blf_endtime	timestamp			NN
assigned_time	timestamp			NN
execution_starttime	timestamp			NN
execution_endtime	timestamp			NN

new
column	data type	PK	U	NN

pg_catalog.stll_vec_scan_local_s3_stats

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
slice	int4			NN
step	int4			NN
num_rows	int8			NN
num_nulls	int8			NN
num_non_nulls	int8			NN
num_overflows	int8			NN
num_cols	int4			NN
avg_page_header_size	int8			NN
max_page_header_size	int8			NN
avg_data_page_size	int8			NN
max_data_page_size	int8			NN
num_values_dictionary_page	int8			NN
num_pages_dictionary_page	int8			NN
num_values_plain	int8			NN
num_pages_plain	int8			NN
num_values_dictionary_index	int8			NN
num_pages_dictionary_index	int8			NN
num_values_rle	int8			NN
num_pages_rle	int8			NN
num_values_delta	int8			NN
num_pages_delta	int8			NN
num_values_others	int8			NN
num_pages_others	int8			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_7408175

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

pg_catalog.stl_burst_soid_requests

old
column	data type
pid	int4
write_xid	int8
type	int4
starttime	timestamp
endtime	timestamp

new
column	data type

pg_catalog.stl_encryption_trace

old
column	data type
pid	int4
slice	int4
recordtime	timestamp
start_time	timestamp
end_time	timestamp
status	int4
active_key_id	char(36)
operation_type	int4
trace_id	int4
key_creation_time	timestamp
new_key_id	char(36)
input_bytes	int8
output_bytes	int8
cur_stek_state	int4
new_stek_state	int4
sys_table	char(128)
latency_p50	int8
latency_p90	int8
latency_p99	int8
size_p50	int8
size_p90	int8
size_p99	int8
message	char(512)

new
column	data type

pg_catalog.stl_integration_maintenance_activities

old
column	data type
record_time	timestamp
integration_id	char(128)
db_name	char(128)
maintenance_type	char(128)
start_time	timestamp
end_time	timestamp
num_tables_maintained	int4

new
column	data type

pg_catalog.stl_local_s3_scan_sr_processing_stats

old
column	data type
query	int4
segment	int4
step	int4
node	int4
slice	int4
file	char(512)
offset_bytes	int8
length_bytes	int8
deserialize_time	timestamp
footer_first_prefetch_trigger_time	timestamp
footer_first_fetch_sent_time	timestamp
footer_first_fetch_ready_time	timestamp
triggered_second_footer_prefetch	char(1)
footer_second_prefetch_trigger_time	timestamp
footer_second_fetch_sent_time	timestamp
footer_second_fetch_ready_time	timestamp
footer_parse_starttime	timestamp
footer_parse_endtime	timestamp
blf_starttime	timestamp
blf_endtime	timestamp
assigned_time	timestamp
execution_starttime	timestamp
execution_endtime	timestamp

new
column	data type

pg_catalog.stl_vec_scan_local_s3_stats

old
column	data type
query	int4
segment	int4
slice	int4
step	int4
num_rows	int8
num_nulls	int8
num_non_nulls	int8
num_overflows	int8
num_cols	int4
avg_page_header_size	int8
max_page_header_size	int8
avg_data_page_size	int8
max_data_page_size	int8
num_values_dictionary_page	int8
num_pages_dictionary_page	int8
num_values_plain	int8
num_pages_plain	int8
num_values_dictionary_index	int8
num_pages_dictionary_index	int8
num_values_rle	int8
num_pages_rle	int8
num_values_delta	int8
num_pages_delta	int8
num_values_others	int8
num_pages_others	int8

new
column	data type