Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
dropped	pg_catalog	internal	immutable	geometry	st_geomfromgeosquare	int8
dropped	pg_catalog	internal	immutable	geometry	st_geomfromgeosquare	int8,int4
dropped	pg_catalog	internal	immutable	int8	st_geosquare	geometry
dropped	pg_catalog	internal	immutable	int8	st_geosquare	geometry,int4
dropped	pg_catalog	internal	volatile	_record	pg_get_session_roles	None

Tables

pg_internal.redshift_auto_health_check_3056442

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_executor_steps

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	int8			NN
query	int4			NN
stream_num	int4			NN
segment	int4			NN
subplan_level	int4			NN
subplan_id	int4			NN
steps	char(2048)			NN
supports_executor	int4			NN
code_item_was_cached	int4			NN
compile	int4			NN
is_short_query	int4			NN
is_short_query_debug_compile	int4			NN
expression_oids	char(500)			NN
step_supports_executor	char(128)			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
recordtime	int8			NN
query	int4			NN
stream_num	int4			NN
segment	int4			NN
subplan_level	int4			NN
subplan_id	int4			NN
steps	char(2048)			NN
supports_executor	char(128)			NN
code_item_was_cached	int4			NN
compile	int4			NN
is_short_query	int4			NN
is_short_query_debug_compile	int4			NN
expression_oids	char(500)			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_query_text

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
transaction_id	int8			NN
session_id	int4			NN
start_time	int8			NN
sequence	int4			NN
text	char(4000)			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
transaction_id	int8			NN
session_id	int4			NN
start_time	int8			NN
sequence	int4			NN
text	char(200)			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_executor_steps

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
query	int4			NN
stream_num	int4			NN
segment	int4			NN
subplan_level	int4			NN
subplan_id	int4			NN
steps	char(2048)			NN
supports_executor	int4			NN
code_item_was_cached	int4			NN
compile	int4			NN
is_short_query	int4			NN
is_short_query_debug_compile	int4			NN
expression_oids	char(500)			NN
step_supports_executor	char(128)			NN

new
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
query	int4			NN
stream_num	int4			NN
segment	int4			NN
subplan_level	int4			NN
subplan_id	int4			NN
steps	char(2048)			NN
supports_executor	char(128)			NN
code_item_was_cached	int4			NN
compile	int4			NN
is_short_query	int4			NN
is_short_query_debug_compile	int4			NN
expression_oids	char(500)			NN

pg_catalog.stll_user_query_text

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
transaction_id	int8			NN
session_id	int4			NN
start_time	timestamp			NN
sequence	int4			NN
text	char(4000)			NN

new
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
transaction_id	int8			NN
session_id	int4			NN
start_time	timestamp			NN
sequence	int4			NN
text	char(200)			NN

pg_catalog.stv_superblock_tree_entries

old
column	data type	PK	U	NN
tbl	int4			NN
col	int4			NN
slice	int4			NN
blocknum	int4			NN
sb_pos	int4			NN
next_sb_pos	int4			NN
id	char(36)			NN
block_len	int4			NN
num_reps	int4			NN
num_values	int4			NN
min	int8			NN
max	int8			NN
backed_up	int4			NN
flags	int4			NN

new
column	data type	PK	U	NN
tbl	int4			NN
col	int4			NN
slice	int4			NN
blocknum	int4			NN
sb_pos	int4			NN
next_sb_pos	int4			NN
id	char(36)			NN
block_len	int4			NN
num_reps	int4			NN
num_values	int4			NN
min	int8			NN
max	int8			NN
pinned	int4			NN
on_disk	int4			NN
backed_up	int4			NN
flags	int4			NN

pg_catalog.pg_s3_sqs_notifications

old
column	data type	PK	U	NN
sqs_url	text
dlq_url	text
region	text

new
column	data type	PK	U	NN

pg_catalog.stcs_burst_async_prepare

old
column	data type	PK	U	NN
pid	int8			NN
starttime	int8			NN
acquire_endtime	int8			NN
endtime	int8			NN
cluster_arn	char(128)			NN
reason	char(40)			NN
num_nodes	int4			NN
error	char(250)			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_refresh_tables_list

old
column	data type	PK	U	NN
record_time	int8			NN
pid	int4			NN
sb_version	int8			NN
refresh_type	int4			NN
list_type	int4			NN
num_tables	int4			NN
tables	char(1024)			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_cluster_handle_usage

old
column	data type	PK	U	NN
procname	char(32)			NN
cluster_version	int4			NN
acquired	int4			NN
time	int8			NN
pid	int4			NN
tid	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_comm_global_packet_pool

old
column	data type	PK	U	NN
since	int8			NN
now	int8			NN
pool_id	int4			NN
available_packets	int4			NN
command_type	char(50)			NN
borrowed_count	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_integration_activity_detail

old
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
database_name	char(128)			NN
node_id	int4			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
copy_id	int8			NN
table_name	char(128)			NN
checkpoint_data_size	int8			NN
state	char(128)			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_perf_permanent_channel_sink

old
column	data type	PK	U	NN
since	int8			NN
now	int8			NN
node	int4			NN
slice	int4			NN
channel_type	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
xoff_total_ns	int8			NN
xoff_max_ns	int8			NN
queue_delay_sample_total_ns	int8			NN
queue_delay_sample_max_ns	int8			NN
rexmit_total_count	int8			NN
rexmit_max_count	int8			NN
channel_sink_init_us	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_perf_permanent_channel_source

old
column	data type	PK	U	NN
since	int8			NN
now	int8			NN
node	int4			NN
slice	int4			NN
channel_type	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
borrow_total_ns	int8			NN
borrow_max_ns	int8			NN
queue_delay_sample_total_ns	int8			NN
queue_delay_sample_max_ns	int8			NN
channel_source_init_us	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_redshift_proxy_connection_startup

old
column	data type	PK	U	NN
pid	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_s3_connection_holding_internal

old
column	data type	PK	U	NN
recordtime	int8			NN
pid	int4			NN
event	char(50)			NN
error	char(512)			NN
bucket_name	char(512)			NN
s3_key_prefix	char(512)			NN
file_name	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.stll_burst_async_prepare

old
column	data type	PK	U	NN
pid	int8			NN
starttime	timestamp			NN
acquire_endtime	timestamp			NN
endtime	timestamp			NN
cluster_arn	char(128)			NN
reason	char(40)			NN
num_nodes	int4			NN
error	char(250)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_burst_refresh_tables_list

old
column	data type	PK	U	NN
record_time	timestamp			NN
pid	int4			NN
sb_version	int8			NN
refresh_type	int4			NN
list_type	int4			NN
num_tables	int4			NN
tables	char(1024)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_cluster_handle_usage

old
column	data type	PK	U	NN
procname	char(32)			NN
cluster_version	int4			NN
acquired	int4			NN
time	timestamp			NN
pid	int4			NN
tid	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_comm_global_packet_pool

old
column	data type	PK	U	NN
since	timestamp			NN
now	timestamp			NN
pool_id	int4			NN
available_packets	int4			NN
command_type	char(50)			NN
borrowed_count	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_integration_activity_detail

old
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
database_name	char(128)			NN
node_id	int4			NN
checkpoint_name	char(128)			NN
checkpoint_type	char(16)			NN
copy_id	int8			NN
table_name	char(128)			NN
checkpoint_data_size	int8			NN
state	char(128)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_perf_permanent_channel_sink

old
column	data type	PK	U	NN
since	timestamp			NN
now	timestamp			NN
node	int4			NN
slice	int4			NN
channel_type	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
xoff_total_ns	int8			NN
xoff_max_ns	int8			NN
queue_delay_sample_total_ns	int8			NN
queue_delay_sample_max_ns	int8			NN
rexmit_total_count	int8			NN
rexmit_max_count	int8			NN
channel_sink_init_us	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_perf_permanent_channel_source

old
column	data type	PK	U	NN
since	timestamp			NN
now	timestamp			NN
node	int4			NN
slice	int4			NN
channel_type	int4			NN
packet_count	int8			NN
bytes_transferred	int8			NN
borrow_total_ns	int8			NN
borrow_max_ns	int8			NN
queue_delay_sample_total_ns	int8			NN
queue_delay_sample_max_ns	int8			NN
channel_source_init_us	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_redshift_proxy_connection_startup

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

new
column	data type	PK	U	NN

pg_catalog.stll_s3_connection_holding_internal

old
column	data type	PK	U	NN
recordtime	timestamp			NN
pid	int4			NN
event	char(50)			NN
error	char(512)			NN
bucket_name	char(512)			NN
s3_key_prefix	char(512)			NN
file_name	char(512)			NN

new
column	data type	PK	U	NN

pg_catalog.stv_comm_global_packet_pool

old
column	data type	PK	U	NN
now	timestamp			NN
pool_id	int4			NN
available_packets	int4			NN
command_type	char(50)			NN
borrowed_count	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stv_mv_deps_internal

old
column	data type	PK	U	NN
database_name	char(128)			NN
schema_name	char(128)			NN
name	char(128)			NN
ref_database_name	char(128)			NN
ref_schema_name	char(128)			NN
ref_name	char(128)			NN
ref_type	char(128)			NN
ref_source	char(128)			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_3046816

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_executor_steps

old
column	data type
userid	int4
recordtime	timestamp
query	int4
stream_num	int4
segment	int4
subplan_level	int4
subplan_id	int4
steps	char(2048)
supports_executor	int4
code_item_was_cached	int4
compile	int4
is_short_query	int4
is_short_query_debug_compile	int4
expression_oids	char(500)
step_supports_executor	char(128)

new
column	data type
userid	int4
recordtime	timestamp
query	int4
stream_num	int4
segment	int4
subplan_level	int4
subplan_id	int4
steps	char(2048)
supports_executor	char(128)
code_item_was_cached	int4
compile	int4
is_short_query	int4
is_short_query_debug_compile	int4
expression_oids	char(500)

pg_catalog.stl_user_query_text

old
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
start_time	timestamp
sequence	int4
text	char(4000)

new
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
start_time	timestamp
sequence	int4
text	char(200)

pg_catalog.sys_query_text

old
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
start_time	timestamp
sequence	int4
text	char(4000)

new
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
start_time	timestamp
sequence	int4
text	char(200)

pg_catalog.stl_burst_async_prepare

old
column	data type
pid	int8
starttime	timestamp
acquire_endtime	timestamp
endtime	timestamp
cluster_arn	char(128)
reason	char(40)
num_nodes	int4
error	char(250)

new
column	data type

pg_catalog.stl_burst_refresh_tables_list

old
column	data type
record_time	timestamp
pid	int4
sb_version	int8
refresh_type	int4
list_type	int4
num_tables	int4
tables	char(1024)

new
column	data type

pg_catalog.stl_cluster_handle_usage

old
column	data type
procname	char(32)
cluster_version	int4
acquired	int4
time	timestamp
pid	int4
tid	int4

new
column	data type

pg_catalog.stl_comm_global_packet_pool

old
column	data type
since	timestamp
now	timestamp
pool_id	int4
available_packets	int4
command_type	char(50)
borrowed_count	int8

new
column	data type

pg_catalog.stl_integration_activity_detail

old
column	data type
record_time	timestamp
integration_id	char(128)
database_name	char(128)
node_id	int4
checkpoint_name	char(128)
checkpoint_type	char(16)
copy_id	int8
table_name	char(128)
checkpoint_data_size	int8
state	char(128)

new
column	data type

pg_catalog.stl_perf_permanent_channel_sink

old
column	data type
since	timestamp
now	timestamp
node	int4
slice	int4
channel_type	int4
packet_count	int8
bytes_transferred	int8
xoff_total_ns	int8
xoff_max_ns	int8
queue_delay_sample_total_ns	int8
queue_delay_sample_max_ns	int8
rexmit_total_count	int8
rexmit_max_count	int8
channel_sink_init_us	int8

new
column	data type

pg_catalog.stl_perf_permanent_channel_source

old
column	data type
since	timestamp
now	timestamp
node	int4
slice	int4
channel_type	int4
packet_count	int8
bytes_transferred	int8
borrow_total_ns	int8
borrow_max_ns	int8
queue_delay_sample_total_ns	int8
queue_delay_sample_max_ns	int8
channel_source_init_us	int8

new
column	data type

pg_catalog.stl_redshift_proxy_connection_startup

old
column	data type
pid	int4
starttime	timestamp
endtime	timestamp

new
column	data type

pg_catalog.stl_s3_connection_holding_internal

old
column	data type
recordtime	timestamp
pid	int4
event	char(50)
error	char(512)
bucket_name	char(512)
s3_key_prefix	char(512)
file_name	char(512)

new
column	data type

pg_catalog.sys_analyze_history

old
column	data type
user_id	int4
transaction_id	int8
database_name	char(30)
schema_name	char(128)
table_name	char(136)
table_id	int4
is_automatic	char(1)
status	char(15)
start_time	timestamp
end_time	timestamp
rows	float8
modified_rows	float8
analyze_threshold_percent	float8
last_analyze_time	timestamp

new
column	data type

pg_catalog.sys_mv_refresh_history

old
column	data type
user_id	int8
session_id	int4
transaction_id	int8
database_name	char(128)
schema_name	char(128)
mv_id	int8
mv_name	char(128)
refresh_type	char(32)
status	text
start_time	timestamp
end_time	timestamp
duration	int8

new
column	data type