Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
dropped	pg_catalog	internal	stable	text	pg_get_privilege_scope_text	oid,oid
dropped	pg_catalog	internal	stable	text	pg_get_privilege_type_text	oid

Tables

pg_internal.redshift_auto_health_check_6032259

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_integration_filter

old
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
channel_arn	name			NN
dbid	oid			NN
dependency_id	oid			NN
filter	text

new
column	data type	PK	U	NN

pg_catalog.stcs_cluster_heart_beat

old
column	data type	PK	U	NN
cluster_state	char(128)			NN
timestamp	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_comm_cleaner_queue_size

old
column	data type	PK	U	NN
since	int8			NN
now	int8			NN
node	int4			NN
num_sinks	int8			NN
num_sources	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_datashare_grafting_cn

old
column	data type	PK	U	NN
leaderpid	int4			NN
xid	int8			NN
query	int4			NN
table_id	int4			NN
graft_batch_id	int4			NN
producer_node_id	int4			NN
graft_step_start_time	int8			NN
graft_step_end_time	int8			NN
num_grafted_header_total	int8			NN
num_grafted_header_new	int8			NN
node	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_histogram_guardrails

old
column	data type	PK	U	NN
qid	int4			NN
xid	int8			NN
total_accesses	int4			NN
planner_accesses	int4			NN
hit_count	int4			NN
copied_tables	int4			NN
refreshed_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

pg_catalog.stcs_iceberg_partition

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
pid	int4			NN
recordtime	int8			NN
table_name	char(512)			NN
table_uuid	char(36)			NN
snapshot_id	int8			NN
partition_spec	int8			NN
num_part_cols	int4			NN
num_partition_specs	int4			NN
num_identity	int4			NN
num_bucket	int4			NN
num_truncate	int4			NN
num_year	int4			NN
num_month	int4			NN
num_day	int4			NN
num_hour	int4			NN
num_void	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_lock

old
column	data type	PK	U	NN
log_time	int8			NN
pid	int8			NN
process_type	char(20)			NN
xid	int8			NN
wait_time_us	int8			NN
hold_time_us	int8			NN
queue_length	int4			NN
lock_mode	int4			NN
lock_obj_type	int4			NN
lock_method_id	int4			NN
db_oid	int8			NN
rel_oid	int8			NN
block_num	int8			NN
lock_xid	int8			NN
class_oid	int8			NN
object_oid	int8			NN
object_subid	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_predictor_retrain

old
column	data type	PK	U	NN
predictor	char(64)			NN
model	char(16)			NN
starttime	int8			NN
endtime	int8			NN
query_number	int4			NN
succeed	int4			NN
message	char(256)			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_redcat_valet_request

old
column	data type	PK	U	NN
requestid	char(50)			NN
api_call	int4			NN
starttime	int8			NN
worker_starttime	int8			NN
endtime	int8			NN
status	int4			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_sage_mode_simulation_clusters

old
column	data type	PK	U	NN
simulation_id	char(36)			NN
trace_id	int4			NN
trace_chunk_start_time	int8			NN
trace_chunk_end_time	int8			NN
ssid	int4			NN
nodes	int4			NN
creation_time	int8			NN
currenttime	int8			NN
end_time	int8			NN
state	int4			NN
detached_time	int8			NN
finished_queries	int4			NN
running_queries	int4			NN
occupied_query_mb	int4			NN
avg_response_time_ms	int4			NN
billed_rpu_ms	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_sage_mode_simulation_summary

old
column	data type	PK	U	NN
simulation_id	char(36)			NN
update_time	int8			NN
update_elapsed_ms	float8			NN
params	char(400)			NN
trace_id	int4			NN
trace_chunk_start_time	int8			NN
trace_chunk_end_time	int8			NN
cost_rpu_ms	float8			NN
avg_runtime_ms	float8			NN
num_queries	int4			NN
total_queries	int8			NN
num_transitions	int4			NN
num_skipped_queries	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_sage_query_trace_data

old
column	data type	PK	U	NN
event_time	int8			NN
query_id	int4			NN
inflight	int4			NN
burstable	int4			NN
arrival_time	int8			NN
execution_time_ms	int4			NN
consumed_megabytes	int4			NN
cluster_size	int4			NN
predicted_execution_times	char(400)			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_sage_query_trace_parameters

old
column	data type	PK	U	NN
event_time	int8			NN
start_time	int8			NN
end_time	int8			NN
noise_enabled	int4			NN
noise_seed	int4			NN
arrival_time_noise_stddev_ms	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.stll_cluster_heart_beat

old
column	data type	PK	U	NN
cluster_state	char(128)			NN
timestamp	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_comm_cleaner_queue_size

old
column	data type	PK	U	NN
since	timestamp			NN
now	timestamp			NN
node	int4			NN
num_sinks	int8			NN
num_sources	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_datashare_grafting_cn

old
column	data type	PK	U	NN
leaderpid	int4			NN
xid	int8			NN
query	int4			NN
table_id	int4			NN
graft_batch_id	int4			NN
producer_node_id	int4			NN
graft_step_start_time	timestamp			NN
graft_step_end_time	timestamp			NN
num_grafted_header_total	int8			NN
num_grafted_header_new	int8			NN
node	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_histogram_guardrails

old
column	data type	PK	U	NN
qid	int4			NN
xid	int8			NN
total_accesses	int4			NN
planner_accesses	int4			NN
hit_count	int4			NN
copied_tables	int4			NN
refreshed_tables	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_iceberg_partition

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
pid	int4			NN
recordtime	timestamp			NN
table_name	char(512)			NN
table_uuid	char(36)			NN
snapshot_id	int8			NN
partition_spec	int8			NN
num_part_cols	int4			NN
num_partition_specs	int4			NN
num_identity	int4			NN
num_bucket	int4			NN
num_truncate	int4			NN
num_year	int4			NN
num_month	int4			NN
num_day	int4			NN
num_hour	int4			NN
num_void	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_lock

old
column	data type	PK	U	NN
log_time	timestamp			NN
pid	int8			NN
process_type	char(20)			NN
xid	int8			NN
wait_time_us	int8			NN
hold_time_us	int8			NN
queue_length	int4			NN
lock_mode	int4			NN
lock_obj_type	int4			NN
lock_method_id	int4			NN
db_oid	int8			NN
rel_oid	int8			NN
block_num	int8			NN
lock_xid	int8			NN
class_oid	int8			NN
object_oid	int8			NN
object_subid	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_predictor_retrain

old
column	data type	PK	U	NN
predictor	char(64)			NN
model	char(16)			NN
starttime	timestamp			NN
endtime	timestamp			NN
query_number	int4			NN
succeed	int4			NN
message	char(256)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_redcat_valet_request

old
column	data type	PK	U	NN
requestid	char(50)			NN
api_call	int4			NN
starttime	timestamp			NN
worker_starttime	timestamp			NN
endtime	timestamp			NN
status	int4			NN
message	char(512)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_sage_mode_simulation_clusters

old
column	data type	PK	U	NN
simulation_id	char(36)			NN
trace_id	int4			NN
trace_chunk_start_time	timestamp			NN
trace_chunk_end_time	timestamp			NN
ssid	int4			NN
nodes	int4			NN
creation_time	timestamp			NN
currenttime	timestamp			NN
end_time	timestamp			NN
state	int4			NN
detached_time	timestamp			NN
finished_queries	int4			NN
running_queries	int4			NN
occupied_query_mb	int4			NN
avg_response_time_ms	int4			NN
billed_rpu_ms	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_sage_mode_simulation_summary

old
column	data type	PK	U	NN
simulation_id	char(36)			NN
update_time	timestamp			NN
update_elapsed_ms	float8			NN
params	char(400)			NN
trace_id	int4			NN
trace_chunk_start_time	timestamp			NN
trace_chunk_end_time	timestamp			NN
cost_rpu_ms	float8			NN
avg_runtime_ms	float8			NN
num_queries	int4			NN
total_queries	int8			NN
num_transitions	int4			NN
num_skipped_queries	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_sage_query_trace_data

old
column	data type	PK	U	NN
event_time	timestamp			NN
query_id	int4			NN
inflight	int4			NN
burstable	int4			NN
arrival_time	timestamp			NN
execution_time_ms	int4			NN
consumed_megabytes	int4			NN
cluster_size	int4			NN
predicted_execution_times	char(400)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_sage_query_trace_parameters

old
column	data type	PK	U	NN
event_time	timestamp			NN
start_time	timestamp			NN
end_time	timestamp			NN
noise_enabled	int4			NN
noise_seed	int4			NN
arrival_time_noise_stddev_ms	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stv_comm_cleaner_queue_size

old
column	data type	PK	U	NN
now	timestamp			NN
node	int4			NN
num_sinks	int8			NN
num_sources	int8			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_6002776

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_cluster_heart_beat

old
column	data type
cluster_state	char(128)
timestamp	int8

new
column	data type

pg_catalog.stl_comm_cleaner_queue_size

old
column	data type
since	timestamp
now	timestamp
node	int4
num_sinks	int8
num_sources	int8

new
column	data type

pg_catalog.stl_datashare_grafting_cn

old
column	data type
leaderpid	int4
xid	int8
query	int4
table_id	int4
graft_batch_id	int4
producer_node_id	int4
graft_step_start_time	timestamp
graft_step_end_time	timestamp
num_grafted_header_total	int8
num_grafted_header_new	int8
node	int4

new
column	data type

pg_catalog.stl_histogram_guardrails

old
column	data type
qid	int4
xid	int8
total_accesses	int4
planner_accesses	int4
hit_count	int4
copied_tables	int4
refreshed_tables	int4

new
column	data type

pg_catalog.stl_iceberg_partition

old
column	data type
userid	int4
query	int4
pid	int4
recordtime	timestamp
table_name	char(512)
table_uuid	char(36)
snapshot_id	int8
partition_spec	int8
num_part_cols	int4
num_partition_specs	int4
num_identity	int4
num_bucket	int4
num_truncate	int4
num_year	int4
num_month	int4
num_day	int4
num_hour	int4
num_void	int4

new
column	data type

pg_catalog.stl_lock

old
column	data type
log_time	timestamp
pid	int8
process_type	char(20)
xid	int8
wait_time_us	int8
hold_time_us	int8
queue_length	int4
lock_mode	int4
lock_obj_type	int4
lock_method_id	int4
db_oid	int8
rel_oid	int8
block_num	int8
lock_xid	int8
class_oid	int8
object_oid	int8
object_subid	int4

new
column	data type

pg_catalog.stl_predictor_retrain

old
column	data type
predictor	char(64)
model	char(16)
starttime	timestamp
endtime	timestamp
query_number	int4
succeed	int4
message	char(256)

new
column	data type

pg_catalog.stl_redcat_valet_request

old
column	data type
requestid	char(50)
api_call	int4
starttime	timestamp
worker_starttime	timestamp
endtime	timestamp
status	int4
message	char(512)

new
column	data type

pg_catalog.stl_sage_mode_simulation_clusters

old
column	data type
simulation_id	char(36)
trace_id	int4
trace_chunk_start_time	timestamp
trace_chunk_end_time	timestamp
ssid	int4
nodes	int4
creation_time	timestamp
currenttime	timestamp
end_time	timestamp
state	int4
detached_time	timestamp
finished_queries	int4
running_queries	int4
occupied_query_mb	int4
avg_response_time_ms	int4
billed_rpu_ms	int4

new
column	data type

pg_catalog.stl_sage_mode_simulation_summary

old
column	data type
simulation_id	char(36)
update_time	timestamp
update_elapsed_ms	float8
params	char(400)
trace_id	int4
trace_chunk_start_time	timestamp
trace_chunk_end_time	timestamp
cost_rpu_ms	float8
avg_runtime_ms	float8
num_queries	int4
total_queries	int8
num_transitions	int4
num_skipped_queries	int4

new
column	data type

pg_catalog.stl_sage_query_trace_data

old
column	data type
event_time	timestamp
query_id	int4
inflight	int4
burstable	int4
arrival_time	timestamp
execution_time_ms	int4
consumed_megabytes	int4
cluster_size	int4
predicted_execution_times	char(400)

new
column	data type

pg_catalog.stl_sage_query_trace_parameters

old
column	data type
event_time	timestamp
start_time	timestamp
end_time	timestamp
noise_enabled	int4
noise_seed	int4
arrival_time_noise_stddev_ms	int4

new
column	data type

pg_catalog.sys_query_explain

old
column	data type
userid	int4
query_id	int8
child_query_sequence	int4
plan_node_id	int4
plan_parent_id	int4
plan_node	char(400)
plan_info	char(400)

new
column	data type