Redshift Observatory System Table Tracker

Tables

pg_catalog.stcs_right_sizing

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
now	int8			NN
initial_query_time	int8			NN
query	int4			NN
xid	int8			NN
main_size	int4			NN
cs_size	int4			NN
est_exec_time_on_x	float8			NN
est_exec_time_on_2x	float8			NN
est_queue_time_on_x	float8			NN
est_queue_time_on_2x	float8			NN
decision_size	int4			NN
decision_acquire	int4			NN
initial_state	int8			NN
modified_state	int8			NN
overridden	int4			NN
num_running_on_x	int4			NN
num_running_on_2x	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_right_sizing

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
now	timestamp			NN
initial_query_time	timestamp			NN
query	int4			NN
xid	int8			NN
main_size	int4			NN
cs_size	int4			NN
est_exec_time_on_x	float8			NN
est_exec_time_on_2x	float8			NN
est_queue_time_on_x	float8			NN
est_queue_time_on_2x	float8			NN
decision_size	int4			NN
decision_acquire	int4			NN
initial_state	int8			NN
modified_state	int8			NN
overridden	int4			NN
num_running_on_x	int4			NN
num_running_on_2x	int4			NN

pg_internal.redshift_auto_health_check_1618986

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_commit_checkpoint

old
column	data type	PK	U	NN
xid	int8			NN
start_acquire_checkpoint_lock	int8			NN
start_acquire_checkpoint_start_lock	int8			NN
start_checkpoint_work	int8			NN
start_create_control_file	int8			NN
end_create_control_file	int8			NN
end_checkpoint	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
xid	int8			NN
start_acquire_checkpoint_lock	int8			NN
start_acquire_checkpoint_start_lock	int8			NN
start_checkpoint_work	int8			NN
start_create_control_file	int8			NN
end_create_control_file	int8			NN
end_checkpoint	int8			NN
xlog_file_num	int8			NN
xlog_file_off	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_datashare_request_producer

old
column	data type	PK	U	NN
userid	int4			NN
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			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
userid	int4			NN
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
xid	int8			NN
backend_start_time	int8			NN
handler_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

pg_catalog.stcs_pg_wal_stats

old
column	data type	PK	U	NN
period_start	int8			NN
log_time	int8			NN
num_wal_inserts	int8			NN
num_wal_writes	int8			NN
num_repwal_msgs	int8			NN
total_repwal_size_kb	int8			NN
total_repwal_time_ms	int8			NN
avg_repwal_time_us	int8			NN
max_repwal_time_us	int8			NN
logged_manually	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
period_start	int8			NN
log_time	int8			NN
num_wal_inserts	int8			NN
num_wal_writes	int8			NN
num_repwal_msgs	int8			NN
total_repwal_size_kb	int8			NN
total_repwal_time_ms	int8			NN
avg_repwal_time_us	int8			NN
max_repwal_time_us	int8			NN
logged_manually	int4			NN
last_repwal_log_id	int8			NN
last_repwal_log_seg	int8			NN
last_repwal_offset	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_user_load_error_detail

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
pid	int4			NN
db	char(64)			NN
xid	int8			NN
slice	int4			NN
table_id	int4			NN
starttime	int8			NN
filename	char(256)			NN
line_number	int8			NN
col_name	char(127)			NN
type	char(10)			NN
col_length	char(10)			NN
position	int4			NN
err_code	int4			NN
err_reason	char(100)			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
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
pid	int4			NN
db	char(64)			NN
xid	int8			NN
slice	int4			NN
table_id	int4			NN
starttime	int8			NN
filename	char(256)			NN
line_number	int8			NN
col_name	char(127)			NN
type	char(10)			NN
col_length	char(10)			NN
position	int4			NN
err_code	int4			NN
err_reason	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

pg_catalog.stll_commit_checkpoint

old
column	data type	PK	U	NN
xid	int8			NN
start_acquire_checkpoint_lock	timestamp			NN
start_acquire_checkpoint_start_lock	timestamp			NN
start_checkpoint_work	timestamp			NN
start_create_control_file	timestamp			NN
end_create_control_file	timestamp			NN
end_checkpoint	timestamp			NN

new
column	data type	PK	U	NN
xid	int8			NN
start_acquire_checkpoint_lock	timestamp			NN
start_acquire_checkpoint_start_lock	timestamp			NN
start_checkpoint_work	timestamp			NN
start_create_control_file	timestamp			NN
end_create_control_file	timestamp			NN
end_checkpoint	timestamp			NN
xlog_file_num	int8			NN
xlog_file_off	int8			NN

pg_catalog.stll_datashare_request_producer

old
column	data type	PK	U	NN
userid	int4			NN
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	timestamp			NN
endtime	timestamp			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
xid	int8			NN

new
column	data type	PK	U	NN
userid	int4			NN
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	timestamp			NN
endtime	timestamp			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
xid	int8			NN
backend_start_time	timestamp			NN
handler_start_time	timestamp			NN

pg_catalog.stll_pg_wal_stats

old
column	data type	PK	U	NN
period_start	timestamp			NN
log_time	timestamp			NN
num_wal_inserts	int8			NN
num_wal_writes	int8			NN
num_repwal_msgs	int8			NN
total_repwal_size_kb	int8			NN
total_repwal_time_ms	int8			NN
avg_repwal_time_us	int8			NN
max_repwal_time_us	int8			NN
logged_manually	int4			NN

new
column	data type	PK	U	NN
period_start	timestamp			NN
log_time	timestamp			NN
num_wal_inserts	int8			NN
num_wal_writes	int8			NN
num_repwal_msgs	int8			NN
total_repwal_size_kb	int8			NN
total_repwal_time_ms	int8			NN
avg_repwal_time_us	int8			NN
max_repwal_time_us	int8			NN
logged_manually	int4			NN
last_repwal_log_id	int8			NN
last_repwal_log_seg	int8			NN
last_repwal_offset	int8			NN

pg_catalog.stll_user_load_error_detail

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
pid	int4			NN
db	char(64)			NN
xid	int8			NN
slice	int4			NN
table_id	int4			NN
starttime	timestamp			NN
filename	char(256)			NN
line_number	int8			NN
col_name	char(127)			NN
type	char(10)			NN
col_length	char(10)			NN
position	int4			NN
err_code	int4			NN
err_reason	char(100)			NN

new
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
pid	int4			NN
db	char(64)			NN
xid	int8			NN
slice	int4			NN
table_id	int4			NN
starttime	timestamp			NN
filename	char(256)			NN
line_number	int8			NN
col_name	char(127)			NN
type	char(10)			NN
col_length	char(10)			NN
position	int4			NN
err_code	int4			NN
err_reason	char(512)			NN

Views

pg_catalog.stl_right_sizing

old
column	data type

new
column	data type
now	timestamp
initial_query_time	timestamp
query	int4
xid	int8
main_size	int4
cs_size	int4
est_exec_time_on_x	float8
est_exec_time_on_2x	float8
est_queue_time_on_x	float8
est_queue_time_on_2x	float8
decision_size	int4
decision_acquire	int4
initial_state	int8
modified_state	int8
overridden	int4
num_running_on_x	int4
num_running_on_2x	int4

pg_catalog.stl_commit_checkpoint

old
column	data type
xid	int8
start_acquire_checkpoint_lock	timestamp
start_acquire_checkpoint_start_lock	timestamp
start_checkpoint_work	timestamp
start_create_control_file	timestamp
end_create_control_file	timestamp
end_checkpoint	timestamp

new
column	data type
xid	int8
start_acquire_checkpoint_lock	timestamp
start_acquire_checkpoint_start_lock	timestamp
start_checkpoint_work	timestamp
start_create_control_file	timestamp
end_create_control_file	timestamp
end_checkpoint	timestamp
xlog_file_num	int8
xlog_file_off	int8

pg_catalog.stl_datashare_request_producer

old
column	data type
userid	int4
pid	int4
requestid	char(50)
sb_version	int8
dbtype	int4
dbid	int4
shareid	int4
sharename	char(128)
api_call	int4
obj_type	int4
obj_oid	int4
obj_name	char(128)
starttime	timestamp
endtime	timestamp
status	int4
message	char(512)
consumeraccountid	char(50)
consumernamespace	char(50)
consumer_transaction_uid	char(50)
is_versioned_request	int4
overridden_snapshot_xmin	int8
xid	int8

new
column	data type
userid	int4
pid	int4
requestid	char(50)
sb_version	int8
dbtype	int4
dbid	int4
shareid	int4
sharename	char(128)
api_call	int4
obj_type	int4
obj_oid	int4
obj_name	char(128)
starttime	timestamp
endtime	timestamp
status	int4
message	char(512)
consumeraccountid	char(50)
consumernamespace	char(50)
consumer_transaction_uid	char(50)
is_versioned_request	int4
overridden_snapshot_xmin	int8
xid	int8
backend_start_time	timestamp
handler_start_time	timestamp

pg_catalog.stl_pg_wal_stats

old
column	data type
period_start	timestamp
log_time	timestamp
num_wal_inserts	int8
num_wal_writes	int8
num_repwal_msgs	int8
total_repwal_size_kb	int8
total_repwal_time_ms	int8
avg_repwal_time_us	int8
max_repwal_time_us	int8
logged_manually	int4

new
column	data type
period_start	timestamp
log_time	timestamp
num_wal_inserts	int8
num_wal_writes	int8
num_repwal_msgs	int8
total_repwal_size_kb	int8
total_repwal_time_ms	int8
avg_repwal_time_us	int8
max_repwal_time_us	int8
logged_manually	int4
last_repwal_log_id	int8
last_repwal_log_seg	int8
last_repwal_offset	int8

pg_catalog.stl_user_load_error_detail

old
column	data type
user_id	int4
query_id	int8
child_query_id	int4
pid	int4
db	char(64)
xid	int8
slice	int4
table_id	int4
starttime	timestamp
filename	char(256)
line_number	int8
col_name	char(127)
type	char(10)
col_length	char(10)
position	int4
err_code	int4
err_reason	char(100)

new
column	data type
user_id	int4
query_id	int8
child_query_id	int4
pid	int4
db	char(64)
xid	int8
slice	int4
table_id	int4
starttime	timestamp
filename	char(256)
line_number	int8
col_name	char(127)
type	char(10)
col_length	char(10)
position	int4
err_code	int4
err_reason	char(512)

pg_catalog.sys_load_error_detail

old
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
database_name	text
table_id	int4
start_time	timestamp
file_name	char(256)
line_number	int8
column_name	char(127)
column_type	char(10)
column_length	char(10)
position	int4
error_code	int4
error_message	char(100)

new
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
database_name	text
table_id	int4
start_time	timestamp
file_name	char(256)
line_number	int8
column_name	char(127)
column_type	char(10)
column_length	char(10)
position	int4
error_code	int4
error_message	char(512)