Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
dropped	pg_catalog	internal	stable	text	current_setting	text,bool

Tables

pg_catalog.stcs_query_detail

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
stream_id	int4			NN
segment_id	int4			NN
step_id	int4			NN
slice	int4			NN
starttime	int8			NN
endtime	int8			NN
step_name	int4			NN
table_id	int4			NN
table_name	char(136)			NN
input_rows	int8			NN
input_bytes	int8			NN
output_rows	int8			NN
output_bytes	int8			NN
is_rrscan	char(1)			NN
blocks_read	int8			NN
blocks_write	int8			NN
local_read_io	int8			NN
remote_read_io	int8			NN
alert	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
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
stream_id	int4			NN
segment_id	int4			NN
step_id	int4			NN
slice	int4			NN
starttime	int8			NN
endtime	int8			NN
step_name	int4			NN
table_id	int4			NN
table_name	char(136)			NN
input_rows	int8			NN
input_bytes	int8			NN
output_rows	int8			NN
output_bytes	int8			NN
is_rrscan	char(1)			NN
blocks_read	int8			NN
blocks_write	int8			NN
local_read_blocks	int8			NN
remote_read_blocks	int8			NN
alert	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

pg_catalog.stcs_query_history_base

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
db	char(64)			NN
query_type	char(32)			NN
query_text	char(4000)			NN
eventtime	int8			NN
status	char(10)			NN
result_cache_source_query	int8			NN
concurrency_scaling_status	int4			NN
error_message	char(512)			NN
task	int4			NN
service_class	int4			NN
returned_rows	int8			NN
returned_bytes	int8			NN
total_queue_time	int8			NN
total_exec_time	int8			NN
redshift_version	char(256)			NN
location_tag	char(32)			NN
usage_limit	char(150)			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
child_query_sequence	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
db	char(64)			NN
query_type	char(32)			NN
query_text	char(4000)			NN
eventtime	int8			NN
status	char(64)			NN
result_cache_source_query	int8			NN
concurrency_scaling_status	int4			NN
error_message	char(512)			NN
task	int4			NN
service_class	int4			NN
returned_rows	int8			NN
returned_bytes	int8			NN
total_queue_time	int8			NN
total_exec_time	int8			NN
redshift_version	char(256)			NN
location_tag	char(32)			NN
usage_limit	char(150)			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_history

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
label	char(32)			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	int8			NN
end_time	int8			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
__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
label	char(32)			NN
xid	int8			NN
pid	int4			NN
database_name	char(128)			NN
query_type	char(32)			NN
status	char(32)			NN
result_cache_source_query	int8			NN
start_time	int8			NN
end_time	int8			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
__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_query_detail

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
stream_id	int4			NN
segment_id	int4			NN
step_id	int4			NN
slice	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
step_name	int4			NN
table_id	int4			NN
table_name	char(136)			NN
input_rows	int8			NN
input_bytes	int8			NN
output_rows	int8			NN
output_bytes	int8			NN
is_rrscan	char(1)			NN
blocks_read	int8			NN
blocks_write	int8			NN
local_read_io	int8			NN
remote_read_io	int8			NN
alert	char(1024)			NN

new
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
stream_id	int4			NN
segment_id	int4			NN
step_id	int4			NN
slice	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
step_name	int4			NN
table_id	int4			NN
table_name	char(136)			NN
input_rows	int8			NN
input_bytes	int8			NN
output_rows	int8			NN
output_bytes	int8			NN
is_rrscan	char(1)			NN
blocks_read	int8			NN
blocks_write	int8			NN
local_read_blocks	int8			NN
remote_read_blocks	int8			NN
alert	char(1024)			NN

pg_catalog.stll_query_history_base

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
db	char(64)			NN
query_type	char(32)			NN
query_text	char(4000)			NN
eventtime	timestamp			NN
status	char(10)			NN
result_cache_source_query	int8			NN
concurrency_scaling_status	int4			NN
error_message	char(512)			NN
task	int4			NN
service_class	int4			NN
returned_rows	int8			NN
returned_bytes	int8			NN
total_queue_time	int8			NN
total_exec_time	int8			NN
redshift_version	char(256)			NN
location_tag	char(32)			NN
usage_limit	char(150)			NN

new
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_id	int4			NN
child_query_sequence	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
db	char(64)			NN
query_type	char(32)			NN
query_text	char(4000)			NN
eventtime	timestamp			NN
status	char(64)			NN
result_cache_source_query	int8			NN
concurrency_scaling_status	int4			NN
error_message	char(512)			NN
task	int4			NN
service_class	int4			NN
returned_rows	int8			NN
returned_bytes	int8			NN
total_queue_time	int8			NN
total_exec_time	int8			NN
redshift_version	char(256)			NN
location_tag	char(32)			NN
usage_limit	char(150)			NN

pg_catalog.stll_user_query_history

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
label	char(32)			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
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

new
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
label	char(32)			NN
xid	int8			NN
pid	int4			NN
database_name	char(128)			NN
query_type	char(32)			NN
status	char(32)			NN
result_cache_source_query	int8			NN
start_time	timestamp			NN
end_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

pg_catalog.stv_user_query_state

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
label	char(32)			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

new
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
label	char(32)			NN
xid	int8			NN
pid	int4			NN
database_name	char(128)			NN
query_type	char(32)			NN
status	char(32)			NN
result_cache_source_query	int8			NN
start_time	timestamp			NN
end_time	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

pg_catalog.pg_default_permission

old
column	data type	PK	U	NN
defpermid	oid			NN
dbid	oid			NN
namespaceid	oid			NN
authtype	int2			NN
authid	int4			NN
objtype	char(1)			NN
privid	oid			NN
userlist	useritem[]
rolelist	roleitem[]

new
column	data type	PK	U	NN

pg_catalog.stcs_epsilon_metadata_events

old
column	data type	PK	U	NN
timestamp	int8			NN
xid	int8			NN
process	char(32)			NN
pid	int4			NN
node	int4			NN
is_error	int4			NN
context	char(32)			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_guid_cache_metrics

old
column	data type	PK	U	NN
node	int4			NN
record_time	int8			NN
entries_tracked	int8			NN
staleness_percent	int8			NN
unknown_percent	int8			NN
lookups	int8			NN
staleness_count	int8			NN
unknown_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_rls_applied_policy

old
column	data type	PK	U	NN
userid	int4			NN
plan_qid	int8			NN
xid	int8			NN
pid	int4			NN
recordtime	int8			NN
command	char(1)			NN
dbid	int4			NN
relid	int4			NN
polid	int4			NN
poldefault	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_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

pg_catalog.stll_epsilon_metadata_events

old
column	data type	PK	U	NN
timestamp	timestamp			NN
xid	int8			NN
process	char(32)			NN
pid	int4			NN
node	int4			NN
is_error	int4			NN
context	char(32)			NN
message	char(512)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_guid_cache_metrics

old
column	data type	PK	U	NN
node	int4			NN
record_time	timestamp			NN
entries_tracked	int8			NN
staleness_percent	int8			NN
unknown_percent	int8			NN
lookups	int8			NN
staleness_count	int8			NN
unknown_count	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_rls_applied_policy

old
column	data type	PK	U	NN
userid	int4			NN
plan_qid	int8			NN
xid	int8			NN
pid	int4			NN
recordtime	timestamp			NN
command	char(1)			NN
dbid	int4			NN
relid	int4			NN
polid	int4			NN
poldefault	char(1)			NN

new
column	data type	PK	U	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

pg_internal.redshift_auto_health_check_1355123

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_query_detail

old
column	data type
user_id	int4
query_id	int8
child_query_id	int4
child_query_sequence	int4
stream_id	int4
segment_id	int4
step_id	int4
slice	int4
starttime	timestamp
endtime	timestamp
step_name	int4
table_id	int4
table_name	char(136)
input_rows	int8
input_bytes	int8
output_rows	int8
output_bytes	int8
is_rrscan	char(1)
blocks_read	int8
blocks_write	int8
local_read_io	int8
remote_read_io	int8
alert	char(1024)

new
column	data type
user_id	int4
query_id	int8
child_query_id	int4
child_query_sequence	int4
stream_id	int4
segment_id	int4
step_id	int4
slice	int4
starttime	timestamp
endtime	timestamp
step_name	int4
table_id	int4
table_name	char(136)
input_rows	int8
input_bytes	int8
output_rows	int8
output_bytes	int8
is_rrscan	char(1)
blocks_read	int8
blocks_write	int8
local_read_blocks	int8
remote_read_blocks	int8
alert	char(1024)

pg_catalog.stl_query_history_base

old
column	data type
user_id	int4
query_id	int8
child_query_id	int4
child_query_sequence	int4
label	char(320)
xid	int8
pid	int4
db	char(64)
query_type	char(32)
query_text	char(4000)
eventtime	timestamp
status	char(10)
result_cache_source_query	int8
concurrency_scaling_status	int4
error_message	char(512)
task	int4
service_class	int4
returned_rows	int8
returned_bytes	int8
total_queue_time	int8
total_exec_time	int8
redshift_version	char(256)
location_tag	char(32)
usage_limit	char(150)

new
column	data type
user_id	int4
query_id	int8
child_query_id	int4
child_query_sequence	int4
label	char(320)
xid	int8
pid	int4
db	char(64)
query_type	char(32)
query_text	char(4000)
eventtime	timestamp
status	char(64)
result_cache_source_query	int8
concurrency_scaling_status	int4
error_message	char(512)
task	int4
service_class	int4
returned_rows	int8
returned_bytes	int8
total_queue_time	int8
total_exec_time	int8
redshift_version	char(256)
location_tag	char(32)
usage_limit	char(150)

pg_catalog.stl_user_query_history

old
column	data type
user_id	int4
query_id	int8
label	char(32)
xid	int8
pid	int4
database_name	char(128)
query_type	char(32)
status	char(10)
result_cache_source_query	int8
start_time	timestamp
end_time	timestamp
queue_time	int8
execution_time	int8
error_message	char(512)
returned_rows	int8
returned_bytes	int8
redshift_version	char(32)
usage_limit	char(150)
internal_query	char(1)
query_text	char(4000)

new
column	data type
user_id	int4
query_id	int8
label	char(32)
xid	int8
pid	int4
database_name	char(128)
query_type	char(32)
status	char(32)
result_cache_source_query	int8
start_time	timestamp
end_time	timestamp
queue_time	int8
execution_time	int8
error_message	char(512)
returned_rows	int8
returned_bytes	int8
redshift_version	char(32)
usage_limit	char(150)
internal_query	char(1)
query_text	char(4000)

pg_catalog.sys_load_error_detail

old
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
database_name	varchar(64)
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
database_name	text
transaction_id	int8
session_id	int4
query_id	int8
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
raw_line	char(1024)
raw_field_value	char(1024)
error_code	int4
error_message	char(100)

pg_catalog.sys_query_detail

old
column	data type
user_id	int4
query_id	int8
child_query_sequence	int4
stream_id	int4
segment_id	int4
step_id	int4
step_name	text
table_id	int4
table_name	char(136)
is_rrscan	char(1)
start_time	timestamp
end_time	timestamp
duration	int8
alert	text
input_bytes	int8
input_rows	int8
output_bytes	int8
output_rows	int8
blocks_read	int8
blocks_write	int8
local_read_io	int8
remote_read_io	int8

new
column	data type
user_id	int4
query_id	int8
child_query_sequence	int4
stream_id	int4
segment_id	int4
step_id	int4
step_name	text
table_id	int4
table_name	char(136)
is_rrscan	char(1)
alert	text
start_time	timestamp
end_time	timestamp
duration	int8
input_bytes	int8
input_rows	int8
output_bytes	int8
output_rows	int8
blocks_read	int8
blocks_write	int8
local_read_blocks	int8
remote_read_blocks	int8

pg_catalog.sys_query_history

old
column	data type
user_id	int4
query_id	int8
query_label	varchar(320)
transaction_id	int8
session_id	int4
database_name	varchar(128)
query_type	varchar(32)
status	char(10)
result_cache_hit	bool
start_time	timestamp
end_time	timestamp
elapsed_time	int8
queue_time	int8
execution_time	int8
error_message	varchar(512)
returned_rows	int8
returned_bytes	int8
query_text	varchar(4000)
redshift_version	char(256)
usage_limit	varchar(150)

new
column	data type
user_id	int4
query_id	int8
query_label	varchar(320)
transaction_id	int8
session_id	int4
database_name	varchar(128)
query_type	varchar(32)
status	varchar(32)
result_cache_hit	bool
start_time	timestamp
end_time	timestamp
elapsed_time	int8
queue_time	int8
execution_time	int8
error_message	varchar(512)
returned_rows	int8
returned_bytes	int8
query_text	varchar(4000)
redshift_version	char(256)
usage_limit	varchar(150)

pg_catalog.stl_epsilon_metadata_events

old
column	data type
timestamp	timestamp
xid	int8
process	char(32)
pid	int4
node	int4
is_error	int4
context	char(32)
message	char(512)

new
column	data type

pg_catalog.stl_guid_cache_metrics

old
column	data type
node	int4
record_time	timestamp
entries_tracked	int8
staleness_percent	int8
unknown_percent	int8
lookups	int8
staleness_count	int8
unknown_count	int8

new
column	data type

pg_catalog.stl_rls_applied_policy

old
column	data type
userid	int4
plan_qid	int8
xid	int8
pid	int4
recordtime	timestamp
command	char(1)
dbid	int4
relid	int4
polid	int4
poldefault	char(1)

new
column	data type

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

pg_catalog.svv_rls_applied_policy

old
column	data type
username	text
query	int4
xid	int8
pid	int4
recordtime	timestamp
command	char(1)
datname	text
relschema	text
relname	text
polname	text
poldefault	text

new
column	data type