Redshift Observatory System Table Tracker

pg_internal.redshift_auto_health_check_3820130

old
column	data type	PK	U	NN

pg_catalog.stcs_superblock_trickle_validation_summary

old
column	data type	PK	U	NN
node	int4			NN
record_time	int8			NN
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_blocks_validated	int8			NN
log_entries_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
tree_trickle_validation_done	int4			NN
trickle_validation_done	int4			NN
num_steps_trickle_validation	int4			NN
log_rotation_done	int4			NN
num_steps_log_rotation	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
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_blocks_validated	int8			NN
log_entries_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
tree_trickle_validation_done	int4			NN
trickle_validation_done	int4			NN
num_steps_trickle_validation	int4			NN
log_rotation_done	int4			NN
num_steps_log_rotation	int4			NN
snapshot_sb_ckpt_hdrs_remaining	int8			NN
snapshot_sb_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.stll_superblock_trickle_validation_summary

old
column	data type	PK	U	NN
node	int4			NN
record_time	timestamp			NN
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_blocks_validated	int8			NN
log_entries_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
tree_trickle_validation_done	int4			NN
trickle_validation_done	int4			NN
num_steps_trickle_validation	int4			NN
log_rotation_done	int4			NN
num_steps_log_rotation	int4			NN

new
column	data type	PK	U	NN
node	int4			NN
record_time	timestamp			NN
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_blocks_validated	int8			NN
log_entries_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
tree_trickle_validation_done	int4			NN
trickle_validation_done	int4			NN
num_steps_trickle_validation	int4			NN
log_rotation_done	int4			NN
num_steps_log_rotation	int4			NN
snapshot_sb_ckpt_hdrs_remaining	int8			NN
snapshot_sb_num_log_blocks	int8			NN

pg_internal.redshift_auto_health_check_3696373

new
column	data type	PK	U	NN

pg_catalog.stl_superblock_trickle_validation_summary

old
column	data type
node	int4
record_time	timestamp
snapshot_sb_version	int8
snapshot_sb_num_blocks	int8
log_blocks_validated	int8
log_entries_validated	int8
tree_based_sb_mode	int4
tree_entries_validated	int8
tree_trickle_validation_done	int4
trickle_validation_done	int4
num_steps_trickle_validation	int4
log_rotation_done	int4
num_steps_log_rotation	int4

new
column	data type
node	int4
record_time	timestamp
snapshot_sb_version	int8
snapshot_sb_num_blocks	int8
log_blocks_validated	int8
log_entries_validated	int8
tree_based_sb_mode	int4
tree_entries_validated	int8
tree_trickle_validation_done	int4
trickle_validation_done	int4
num_steps_trickle_validation	int4
log_rotation_done	int4
num_steps_log_rotation	int4
snapshot_sb_ckpt_hdrs_remaining	int8
snapshot_sb_num_log_blocks	int8