Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
dropped	pg_catalog	internal	immutable	bool	is_object_sensitive_internal	super,int4
dropped	pg_catalog	internal	immutable	hllsketch	hll_import_sketch	text
dropped	pg_catalog	internal	immutable	super	get_sensitive_localizations_internal	None
dropped	pg_catalog	internal	immutable	super	get_sensitive_queries_internal	None
dropped	pg_catalog	internal	immutable	text	hll_export_sketch	hllsketch
dropped	pg_catalog	internal	stable	varchar	current_session_arn	None
dropped	pg_catalog	internal	stable	varchar	get_mounted_role	None
dropped	pg_catalog	internal	volatile	_record	pg_get_external_database_tables_extended	None
dropped	pg_catalog	internal	volatile	_record	pg_get_external_tables_extended	None

Tables

pg_internal.redshift_auto_health_check_5921113

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_burst_service_client

old
column	data type	PK	U	NN
action	char(10)			NN
pid	int8			NN
xid	int8			NN
eventtime	int8			NN
cluster_arn	char(128)			NN
expiration	int8			NN
preshared_key	char(100)			NN
num_nodes	int4			NN
error	char(250)			NN
request_id	char(100)			NN
reason	char(40)			NN
query	int4			NN
starttime	int8			NN
extended_json	char(80)			NN
burst_override_gucs	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
action	char(10)			NN
pid	int8			NN
xid	int8			NN
eventtime	int8			NN
cluster_arn	char(128)			NN
expiration	int8			NN
preshared_key	char(100)			NN
num_nodes	int4			NN
error	char(250)			NN
request_id	char(100)			NN
reason	char(40)			NN
query	int4			NN
starttime	int8			NN
extended_json	char(60)			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_sage_scaling_decisions

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
pid	int4			NN
userid	int4			NN
decision_id	int4			NN
decision_time	int8			NN
budget_rpu_sec	int8			NN
queue_time_ms	int4			NN
chosen_candidate_id	int4			NN
seconds_since_last_acquire	int4			NN
alpha	float8			NN
burstable	int4			NN
fallback	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
query	int4			NN
xid	int8			NN
pid	int4			NN
userid	int4			NN
decision_id	int4			NN
decision_time	int8			NN
budget_rpu_sec	int4			NN
queue_time_ms	int4			NN
chosen_candidate_id	int4			NN
seconds_since_last_acquire	int4			NN
alpha	float8			NN
burstable	int4			NN
fallback	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_burst_service_client

old
column	data type	PK	U	NN
action	char(10)			NN
pid	int8			NN
xid	int8			NN
eventtime	timestamp			NN
cluster_arn	char(128)			NN
expiration	timestamp			NN
preshared_key	char(100)			NN
num_nodes	int4			NN
error	char(250)			NN
request_id	char(100)			NN
reason	char(40)			NN
query	int4			NN
starttime	timestamp			NN
extended_json	char(80)			NN
burst_override_gucs	char(256)			NN

new
column	data type	PK	U	NN
action	char(10)			NN
pid	int8			NN
xid	int8			NN
eventtime	timestamp			NN
cluster_arn	char(128)			NN
expiration	timestamp			NN
preshared_key	char(100)			NN
num_nodes	int4			NN
error	char(250)			NN
request_id	char(100)			NN
reason	char(40)			NN
query	int4			NN
starttime	timestamp			NN
extended_json	char(60)			NN

pg_catalog.stll_sage_scaling_decisions

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
pid	int4			NN
userid	int4			NN
decision_id	int4			NN
decision_time	timestamp			NN
budget_rpu_sec	int8			NN
queue_time_ms	int4			NN
chosen_candidate_id	int4			NN
seconds_since_last_acquire	int4			NN
alpha	float8			NN
burstable	int4			NN
fallback	int4			NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
pid	int4			NN
userid	int4			NN
decision_id	int4			NN
decision_time	timestamp			NN
budget_rpu_sec	int4			NN
queue_time_ms	int4			NN
chosen_candidate_id	int4			NN
seconds_since_last_acquire	int4			NN
alpha	float8			NN
burstable	int4			NN
fallback	int4			NN

pg_catalog.stv_blocklist

old
column	data type	PK	U	NN
slice	int4			NN
col	int4			NN
tbl	int4			NN
blocknum	int4			NN
num_values	int4			NN
extended_limits	int4			NN
minvalue	int8			NN
maxvalue	int8			NN
sb_pos	int4			NN
pinned	int4			NN
on_disk	int4			NN
backed_up	int4			NN
modified	int4			NN
hdr_modified	int4			NN
unsorted	int4			NN
tombstone	int4			NN
preferred_diskno	int4			NN
temporary	int4			NN
newblock	int4			NN
num_readers	int4			NN
id	char(64)			NN
flags	int4			NN

new
column	data type	PK	U	NN
slice	int4			NN
col	int4			NN
tbl	int4			NN
blocknum	int4			NN
num_values	int4			NN
extended_limits	int4			NN
minvalue	int8			NN
maxvalue	int8			NN
sb_pos	int4			NN
pinned	int4			NN
on_disk	int4			NN
backed_up	int4			NN
modified	int4			NN
hdr_modified	int4			NN
unsorted	int4			NN
tombstone	int4			NN
preferred_diskno	int4			NN
temporary	int4			NN
newblock	int4			NN
num_readers	int4			NN
id	char(64)			NN
flags	int4			NN
access_control	int4			NN

pg_catalog.stv_exec_state

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
currenttime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
label	char(256)			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
step_attribute	char(64)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
currenttime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
label	char(256)			NN
is_diskbased	char(1)			NN
workmem	int8			NN
num_parts	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
step_attribute	char(64)			NN
access_control	int4			NN

pg_catalog.stv_inflight

old
column	data type	PK	U	NN
userid	int4			NN
slice	int4			NN
query	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
starttime	timestamp			NN
text	char(100)			NN
suspended	int4			NN
insert_pristine	int4			NN
concurrency_scaling_status	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
slice	int4			NN
query	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
starttime	timestamp			NN
text	char(100)			NN
suspended	int4			NN
insert_pristine	int4			NN
concurrency_scaling_status	int4			NN
access_control	int4			NN

pg_catalog.stv_query_metrics

old
column	data type	PK	U	NN
userid	int4			NN
service_class	int4			NN
query	int4			NN
segment	int4			NN
step_type	int4			NN
starttime	timestamp			NN
slices	int4			NN
max_rows	int8			NN
rows	int8			NN
max_cpu_time	int8			NN
cpu_time	int8			NN
max_blocks_read	int4			NN
blocks_read	int8			NN
max_run_time	int8			NN
run_time	int8			NN
max_blocks_to_disk	int8			NN
blocks_to_disk	int8			NN
step	int4			NN
max_query_scan_size	int8			NN
query_scan_size	int8			NN
query_priority	int4			NN
query_queue_time	int8			NN

new
column	data type	PK	U	NN
userid	int4			NN
service_class	int4			NN
query	int4			NN
segment	int4			NN
step_type	int4			NN
starttime	timestamp			NN
slices	int4			NN
max_rows	int8			NN
rows	int8			NN
max_cpu_time	int8			NN
cpu_time	int8			NN
max_blocks_read	int4			NN
blocks_read	int8			NN
max_run_time	int8			NN
run_time	int8			NN
max_blocks_to_disk	int8			NN
blocks_to_disk	int8			NN
step	int4			NN
max_query_scan_size	int8			NN
query_scan_size	int8			NN
query_priority	int4			NN
query_queue_time	int8			NN
access_control	int4			NN

pg_catalog.stv_query_stats

old
column	data type	PK	U	NN
node_num	int8			NN
query_id	int8			NN
temp_blocks	int8			NN

new
column	data type	PK	U	NN
node_num	int8			NN
query_id	int8			NN
temp_blocks	int8			NN
access_control	int4			NN

pg_catalog.stv_tbl_column_slice_state

old
column	data type	PK	U	NN
node	int4			NN
table_id	int4			NN
col	int4			NN
slice	int4			NN
num_blocks	int4			NN

new
column	data type	PK	U	NN
node	int4			NN
table_id	int4			NN
col	int4			NN
slice	int4			NN
num_blocks	int4			NN
access_control	int4			NN

pg_catalog.stv_tbl_perm

old
column	data type	PK	U	NN
slice	int4			NN
id	int4			NN
name	char(128)			NN
rows	int8			NN
sorted_rows	int8			NN
temp	int4			NN
db_id	int4			NN
insert_pristine	int4			NN
delete_pristine	int4			NN
backup	int4			NN
dist_style	int4			NN
block_count	int4			NN

new
column	data type	PK	U	NN
slice	int4			NN
id	int4			NN
name	char(128)			NN
rows	int8			NN
sorted_rows	int8			NN
temp	int4			NN
db_id	int4			NN
insert_pristine	int4			NN
delete_pristine	int4			NN
backup	int4			NN
dist_style	int4			NN
block_count	int4			NN
access_control	int4			NN

pg_catalog.stv_tbl_trans

old
column	data type	PK	U	NN
slice	int4			NN
id	int4			NN
rows	int8			NN
size	int8			NN
query_id	int8			NN
ref_cnt	int4			NN
from_suspended	int4			NN
prep_swap	int4			NN

new
column	data type	PK	U	NN
slice	int4			NN
id	int4			NN
rows	int8			NN
size	int8			NN
query_id	int8			NN
ref_cnt	int4			NN
from_suspended	int4			NN
prep_swap	int4			NN
access_control	int4			NN

pg_catalog.stv_user_query_state

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database_name	char(128)			NN
query_type	char(32)			NN
status	char(10)			NN
result_cache_source_query	int8			NN
start_time	timestamp			NN
end_time	timestamp			NN
now	timestamp			NN
status_update_time	timestamp			NN
queue_time	int8			NN
execution_time	int8			NN
error_message	char(512)			NN
returned_rows	int8			NN
returned_bytes	int8			NN
redshift_version	char(32)			NN
usage_limit	char(150)			NN
internal_query	char(1)			NN
query_text	char(4000)			NN
compute_type	char(32)			NN
compile_time	int8			NN
planning_time	int8			NN
pure_planning_time	int8			NN
lock_wait_time	int8			NN

new
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database_name	char(128)			NN
query_type	char(32)			NN
status	char(10)			NN
result_cache_source_query	int8			NN
start_time	timestamp			NN
end_time	timestamp			NN
now	timestamp			NN
status_update_time	timestamp			NN
queue_time	int8			NN
execution_time	int8			NN
error_message	char(512)			NN
returned_rows	int8			NN
returned_bytes	int8			NN
redshift_version	char(32)			NN
usage_limit	char(150)			NN
internal_query	char(1)			NN
query_text	char(4000)			NN
compute_type	char(32)			NN
compile_time	int8			NN
planning_time	int8			NN
pure_planning_time	int8			NN
lock_wait_time	int8			NN
access_control	int4			NN

pg_catalog.stcs_commit_internal_time_breakdown

old
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
sb_version	int8			NN
step	char(64)			NN
step_start_time	int8			NN
step_total_time_us	float8			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_explain_internal

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
nodeid	int4			NN
parentid	int4			NN
plannode	char(400)			NN
startupcost	float8			NN
totalcost	float8			NN
rows	int8			NN
width	int8			NN
missingstats	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_megablock_stats

old
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
scanned_mega_super	char(1)			NN
scanned_mega_varbyte	char(1)			NN
inserted_mega_super	char(1)			NN
inserted_mega_varbyte	char(1)			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_state_gui_status

old
column	data type	PK	U	NN
timestamp	int8			NN
start_time	int8			NN
num_nodes	int4			NN
num_sessions	int4			NN
total_queries	int4			NN
recent_queries	int4			NN
load_time	int8			NN
system_status	char(30)			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_state_node_storage_capacity

old
column	data type	PK	U	NN
timestamp	int8			NN
node	int4			NN
used	int8			NN
capacity	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_state_partitions

old
column	data type	PK	U	NN
timestamp	int8			NN
owner	int4			NN
host	int4			NN
diskno	int4			NN
part_begin	int8			NN
part_end	int8			NN
used	int4			NN
tossed	int4			NN
capacity	int4			NN
reads	int8			NN
writes	int8			NN
seek_forward	int4			NN
seek_back	int4			NN
is_san	int4			NN
failed	int4			NN
mbps	int4			NN
mount	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_state_slices

old
column	data type	PK	U	NN
timestamp	int8			NN
restart_trace_id	char(64)			NN
node	int4			NN
slice	int4			NN
localslice	int4			NN
type	char(1)			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_state_table_column_metadata

old
column	data type	PK	U	NN
timestamp	int8			NN
slice	int4			NN
table_id	int4			NN
column_id	int4			NN
num_blocks	int8			NN
row_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.stll_commit_internal_time_breakdown

old
column	data type	PK	U	NN
xid	int8			NN
node	int4			NN
sb_version	int8			NN
step	char(64)			NN
step_start_time	timestamp			NN
step_total_time_us	float8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_explain_internal

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
nodeid	int4			NN
parentid	int4			NN
plannode	char(400)			NN
startupcost	float8			NN
totalcost	float8			NN
rows	int8			NN
width	int8			NN
missingstats	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_megablock_stats

old
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
scanned_mega_super	char(1)			NN
scanned_mega_varbyte	char(1)			NN
inserted_mega_super	char(1)			NN
inserted_mega_varbyte	char(1)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_state_gui_status

old
column	data type	PK	U	NN
timestamp	int8			NN
start_time	timestamp			NN
num_nodes	int4			NN
num_sessions	int4			NN
total_queries	int4			NN
recent_queries	int4			NN
load_time	timestamp			NN
system_status	char(30)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_state_node_storage_capacity

old
column	data type	PK	U	NN
timestamp	int8			NN
node	int4			NN
used	int8			NN
capacity	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_state_partitions

old
column	data type	PK	U	NN
timestamp	int8			NN
owner	int4			NN
host	int4			NN
diskno	int4			NN
part_begin	int8			NN
part_end	int8			NN
used	int4			NN
tossed	int4			NN
capacity	int4			NN
reads	int8			NN
writes	int8			NN
seek_forward	int4			NN
seek_back	int4			NN
is_san	int4			NN
failed	int4			NN
mbps	int4			NN
mount	char(256)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_state_slices

old
column	data type	PK	U	NN
timestamp	int8			NN
restart_trace_id	char(64)			NN
node	int4			NN
slice	int4			NN
localslice	int4			NN
type	char(1)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_state_table_column_metadata

old
column	data type	PK	U	NN
timestamp	int8			NN
slice	int4			NN
table_id	int4			NN
column_id	int4			NN
num_blocks	int8			NN
row_count	int8			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_5890241

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_burst_service_client

old
column	data type
action	char(10)
pid	int8
xid	int8
eventtime	timestamp
cluster_arn	char(128)
expiration	timestamp
preshared_key	char(100)
num_nodes	int4
error	char(250)
request_id	char(100)
reason	char(40)
query	int4
starttime	timestamp
extended_json	char(80)
burst_override_gucs	char(256)

new
column	data type
action	char(10)
pid	int8
xid	int8
eventtime	timestamp
cluster_arn	char(128)
expiration	timestamp
preshared_key	char(100)
num_nodes	int4
error	char(250)
request_id	char(100)
reason	char(40)
query	int4
starttime	timestamp
extended_json	char(60)

pg_catalog.stl_sage_scaling_decisions

old
column	data type
query	int4
xid	int8
pid	int4
userid	int4
decision_id	int4
decision_time	timestamp
budget_rpu_sec	int8
queue_time_ms	int4
chosen_candidate_id	int4
seconds_since_last_acquire	int4
alpha	float8
burstable	int4
fallback	int4

new
column	data type
query	int4
xid	int8
pid	int4
userid	int4
decision_id	int4
decision_time	timestamp
budget_rpu_sec	int4
queue_time_ms	int4
chosen_candidate_id	int4
seconds_since_last_acquire	int4
alpha	float8
burstable	int4
fallback	int4

pg_catalog.svv_diskusage

old
column	data type
db_id	int4
name	char(128)
slice	int4
col	int4
tbl	int4
blocknum	int4
num_values	int4
extended_limits	int4
minvalue	int8
maxvalue	int8
sb_pos	int4
pinned	int4
on_disk	int4
backed_up	int4
modified	int4
hdr_modified	int4
unsorted	int4
tombstone	int4
preferred_diskno	int4
temporary	int4
newblock	int4
num_readers	int4
id	char(64)
flags	int4

new
column	data type
db_id	int4
name	char(128)
slice	int4
col	int4
tbl	int4
blocknum	int4
num_values	int4
extended_limits	int4
minvalue	int8
maxvalue	int8
sb_pos	int4
pinned	int4
on_disk	int4
backed_up	int4
modified	int4
hdr_modified	int4
unsorted	int4
tombstone	int4
preferred_diskno	int4
temporary	int4
newblock	int4
num_readers	int4
id	char(64)
flags	int4
access_control	int4

pg_catalog.stl_commit_internal_time_breakdown

old
column	data type
xid	int8
node	int4
sb_version	int8
step	char(64)
step_start_time	timestamp
step_total_time_us	float8

new
column	data type

pg_catalog.stl_explain_internal

old
column	data type
userid	int4
query	int4
nodeid	int4
parentid	int4
plannode	char(400)
startupcost	float8
totalcost	float8
rows	int8
width	int8
missingstats	int4

new
column	data type

pg_catalog.stl_megablock_stats

old
column	data type
query	int4
slice	int4
segment	int4
step	int4
scanned_mega_super	char(1)
scanned_mega_varbyte	char(1)
inserted_mega_super	char(1)
inserted_mega_varbyte	char(1)

new
column	data type

pg_catalog.stl_state_gui_status

old
column	data type
timestamp	int8
start_time	timestamp
num_nodes	int4
num_sessions	int4
total_queries	int4
recent_queries	int4
load_time	timestamp
system_status	char(30)

new
column	data type

pg_catalog.stl_state_node_storage_capacity

old
column	data type
timestamp	int8
node	int4
used	int8
capacity	int8

new
column	data type

pg_catalog.stl_state_partitions

old
column	data type
timestamp	int8
owner	int4
host	int4
diskno	int4
part_begin	int8
part_end	int8
used	int4
tossed	int4
capacity	int4
reads	int8
writes	int8
seek_forward	int4
seek_back	int4
is_san	int4
failed	int4
mbps	int4
mount	char(256)

new
column	data type

pg_catalog.stl_state_slices

old
column	data type
timestamp	int8
restart_trace_id	char(64)
node	int4
slice	int4
localslice	int4
type	char(1)

new
column	data type

pg_catalog.stl_state_table_column_metadata

old
column	data type
timestamp	int8
slice	int4
table_id	int4
column_id	int4
num_blocks	int8
row_count	int8

new
column	data type

pg_catalog.sys_child_query_text

old
column	data type
user_id	int4
query_id	int8
child_query_sequence	int4
sequence	int4
text	char(200)

new
column	data type