Redshift Observatory System Table Tracker

Tables

pg_internal.redshift_auto_health_check_3318398

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_catalog_rebuild_worker

old
column	data type	PK	U	NN
xid	int8			NN
pid	int4			NN
database	int4			NN
total_live_tup_sz	int8			NN
total_dead_tup_sz	int8			NN
starttime	int8			NN
endtime	int8			NN
num_rebuilds_reqd	int4			NN
rebuild_triggered	int4			NN
last_rebuild_time	int8			NN
rebuild_needed_duration	int8			NN
force_lock	int4			NN
exception	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
xid	int8			NN
pid	int4			NN
database	int4			NN
total_live_tup_sz	int8			NN
total_dead_tup_sz	int8			NN
starttime	int8			NN
endtime	int8			NN
num_rebuilds_reqd	int4			NN
rebuild_triggered	int4			NN
last_rebuild_time	int8			NN
rebuild_needed_duration	int8			NN
force_lock	int4			NN
exception	int4			NN
within_blockout_window	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_internal_query_details

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
initial_query_time	int8			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
est_peak_mem_needed	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
initial_query_time	int8			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
reported_peak_usage_bytes	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
exec_time_wo_compilation	int8			NN
__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_trickle_validation_stats

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_entries_validated	int8			NN
log_blocks_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
trickle_validation_done	int4			NN
log_rotation	int4			NN
was_tree_validated	int4			NN
tree_trickle_validation_done	int4			NN
xid	int8			NN
start_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
node	int4			NN
record_time	int8			NN
snapshot_sb_version	int8			NN
snapshot_sb_num_blocks	int8			NN
log_entries_validated	int8			NN
log_blocks_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
trickle_validation_done	int4			NN
log_rotation	int4			NN
was_tree_validated	int4			NN
tree_trickle_validation_done	int4			NN
xid	int8			NN
start_time	int8			NN
log_blocks_prefetched	int8			NN
log_blocks_prefetched_pending_io	int8			NN
log_blocks_read_sync	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_catalog_rebuild_worker

old
column	data type	PK	U	NN
xid	int8			NN
pid	int4			NN
database	int4			NN
total_live_tup_sz	int8			NN
total_dead_tup_sz	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
num_rebuilds_reqd	int4			NN
rebuild_triggered	int4			NN
last_rebuild_time	timestamp			NN
rebuild_needed_duration	int8			NN
force_lock	int4			NN
exception	int4			NN

new
column	data type	PK	U	NN
xid	int8			NN
pid	int4			NN
database	int4			NN
total_live_tup_sz	int8			NN
total_dead_tup_sz	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
num_rebuilds_reqd	int4			NN
rebuild_triggered	int4			NN
last_rebuild_time	timestamp			NN
rebuild_needed_duration	int8			NN
force_lock	int4			NN
exception	int4			NN
within_blockout_window	int4			NN

pg_catalog.stll_internal_query_details

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
initial_query_time	timestamp			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
est_peak_mem_needed	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
initial_query_time	timestamp			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
reported_peak_usage_bytes	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
exec_time_wo_compilation	int8			NN

pg_catalog.stll_superblock_trickle_validation_stats

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_entries_validated	int8			NN
log_blocks_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
trickle_validation_done	int4			NN
log_rotation	int4			NN
was_tree_validated	int4			NN
tree_trickle_validation_done	int4			NN
xid	int8			NN
start_time	timestamp			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_entries_validated	int8			NN
log_blocks_validated	int8			NN
tree_based_sb_mode	int4			NN
tree_entries_validated	int8			NN
trickle_validation_done	int4			NN
log_rotation	int4			NN
was_tree_validated	int4			NN
tree_trickle_validation_done	int4			NN
xid	int8			NN
start_time	timestamp			NN
log_blocks_prefetched	int8			NN
log_blocks_prefetched_pending_io	int8			NN
log_blocks_read_sync	int8			NN

pg_internal.redshift_auto_health_check_3073466

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_catalog_rebuild_worker

old
column	data type
xid	int8
pid	int4
database	int4
total_live_tup_sz	int8
total_dead_tup_sz	int8
starttime	timestamp
endtime	timestamp
num_rebuilds_reqd	int4
rebuild_triggered	int4
last_rebuild_time	timestamp
rebuild_needed_duration	int8
force_lock	int4
exception	int4

new
column	data type
xid	int8
pid	int4
database	int4
total_live_tup_sz	int8
total_dead_tup_sz	int8
starttime	timestamp
endtime	timestamp
num_rebuilds_reqd	int4
rebuild_triggered	int4
last_rebuild_time	timestamp
rebuild_needed_duration	int8
force_lock	int4
exception	int4
within_blockout_window	int4

pg_catalog.stl_internal_query_details

old
column	data type
query	int4
xid	int8
initial_query_time	timestamp
seldispatch_status	int4
query_cmd_type	int4
user_temp_tables_accessed	int4
volt_temp_tables_accessed	int4
spectrum_tables_accessed	int4
user_perm_tables_accessed	int4
system_tables_accessed	int4
query_target_table_type	int4
memory_demanding_info	int8
nobackup_tables_accessed	int4
zindex_tables_accessed	int4
pg_tables_accessed	int4
dirty_tables_read	int4
wlm_slot_type	char(8)
is_short_query	int4
est_peak_mem_needed	int8
wlm_query_memory	int8
datasharing_tables_accessed	int4
uses_new_cost_model	char(1)
new_model_reason	int4
num_rowsets	int4
xregion_datasharing_tables_accessed	int4
result_cache_miss_reason	int4
cs_node_nums	int4
is_multi	int4
is_burst_for_at_task	int4
user_query_id	int8
lf_datasharing_tables_accessed	int4
qpc_source_qid	int8

new
column	data type
query	int4
xid	int8
initial_query_time	timestamp
seldispatch_status	int4
query_cmd_type	int4
user_temp_tables_accessed	int4
volt_temp_tables_accessed	int4
spectrum_tables_accessed	int4
user_perm_tables_accessed	int4
system_tables_accessed	int4
query_target_table_type	int4
memory_demanding_info	int8
nobackup_tables_accessed	int4
zindex_tables_accessed	int4
pg_tables_accessed	int4
dirty_tables_read	int4
wlm_slot_type	char(8)
is_short_query	int4
reported_peak_usage_bytes	int8
wlm_query_memory	int8
datasharing_tables_accessed	int4
uses_new_cost_model	char(1)
new_model_reason	int4
num_rowsets	int4
xregion_datasharing_tables_accessed	int4
result_cache_miss_reason	int4
cs_node_nums	int4
is_multi	int4
is_burst_for_at_task	int4
user_query_id	int8
lf_datasharing_tables_accessed	int4
qpc_source_qid	int8
exec_time_wo_compilation	int8

pg_catalog.stl_superblock_trickle_validation_stats

old
column	data type
node	int4
record_time	timestamp
snapshot_sb_version	int8
snapshot_sb_num_blocks	int8
log_entries_validated	int8
log_blocks_validated	int8
tree_based_sb_mode	int4
tree_entries_validated	int8
trickle_validation_done	int4
log_rotation	int4
was_tree_validated	int4
tree_trickle_validation_done	int4
xid	int8
start_time	timestamp

new
column	data type
node	int4
record_time	timestamp
snapshot_sb_version	int8
snapshot_sb_num_blocks	int8
log_entries_validated	int8
log_blocks_validated	int8
tree_based_sb_mode	int4
tree_entries_validated	int8
trickle_validation_done	int4
log_rotation	int4
was_tree_validated	int4
tree_trickle_validation_done	int4
xid	int8
start_time	timestamp
log_blocks_prefetched	int8
log_blocks_prefetched_pending_io	int8
log_blocks_read_sync	int8