Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
dropped	pg_catalog	internal	stable	bool	user_is_member_of_role	name,name
dropped	pg_catalog	internal	stable	int4	last_user_query_id	None
dropped	pg_catalog	internal	stable	text	txid_status	int8

Tables

pg_catalog.pg_integration_tablestate

old
column	data type	PK	U	NN
schema_name	name			NN
table_name	name			NN
state	text
attributes	text

new
column	data type	PK	U	NN

pg_catalog.stcs_awsclient_requests

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
recordtime	int8			NN
pid	int4			NN
http_method	char(64)			NN
endpoint	char(128)			NN
amzn_request_id	char(36)			NN
response_code	int4			NN
operation_name	char(128)			NN
canonical_uri	char(1024)			NN
canonical_query_string	char(1024)			NN
network_namespace	int4			NN
access_key_id	char(36)			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_table_state

old
column	data type	PK	U	NN
integration_id	char(128)			NN
database_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
current_state	char(128)			NN
previous_state	char(128)			NN
record_time	int8			NN
synced_log_coordinate	char(128)			NN
reason	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_predicate_information

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
segment	int4			NN
step	int4			NN
node_id	int4			NN
parent_node_id	int4			NN
expr_datatype	int4			NN
expr_name	char(64)			NN
expr_id	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_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(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

new
column	data type	PK	U	NN

pg_catalog.stll_awsclient_requests

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
recordtime	timestamp			NN
pid	int4			NN
http_method	char(64)			NN
endpoint	char(128)			NN
amzn_request_id	char(36)			NN
response_code	int4			NN
operation_name	char(128)			NN
canonical_uri	char(1024)			NN
canonical_query_string	char(1024)			NN
network_namespace	int4			NN
access_key_id	char(36)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_integration_table_state

old
column	data type	PK	U	NN
integration_id	char(128)			NN
database_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
current_state	char(128)			NN
previous_state	char(128)			NN
record_time	timestamp			NN
synced_log_coordinate	char(128)			NN
reason	char(256)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_predicate_information

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
segment	int4			NN
step	int4			NN
node_id	int4			NN
parent_node_id	int4			NN
expr_datatype	int4			NN
expr_name	char(64)			NN
expr_id	int4			NN

new
column	data type	PK	U	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(200)			NN

new
column	data type	PK	U	NN

pg_catalog.stv_integration_table_state

old
column	data type	PK	U	NN
integration_id	char(128)			NN
database_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
state	char(128)			NN
synced_log_coordinate	char(128)			NN
reason	char(256)			NN
size	int4			NN
last_updated	timestamp			NN

new
column	data type	PK	U	NN

pg_catalog.stv_perf_permanent_channel_sink

old
column	data type	PK	U	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.stv_perf_permanent_channel_source

old
column	data type	PK	U	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.stv_query_plan_cache

old
column	data type	PK	U	NN
cache_id	int4			NN
source_plan_qid	int8			NN
invalidated_by	int8			NN
query_signature_size_bytes	int8			NN
plan_size_bytes	int8			NN
query_size_bytes	int8			NN
planning_time_us	int8			NN
hit_count	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stv_user_query_map

old
column	data type	PK	U	NN
user_id	int4			NN
user_query_id	int8			NN
rewritten_query_id	int8			NN
child_query_sequence	int4			NN

new
column	data type	PK	U	NN

Views

pg_catalog.svv_columns

old
column	data type
table_catalog	varchar(128)
table_schema	varchar(128)
table_name	varchar(128)
column_name	varchar(128)
ordinal_position	int4
column_default	varchar(4000)
is_nullable	varchar(128)
data_type	varchar(128)
character_maximum_length	int4
numeric_precision	int4
numeric_precision_radix	int4
numeric_scale	int4
datetime_precision	int4
interval_type	varchar(256)
interval_precision	varchar(256)
character_set_catalog	varchar(128)
character_set_schema	varchar(128)
character_set_name	varchar(128)
collation_catalog	varchar(128)
collation_schema	varchar(128)
collation_name	varchar(128)
domain_name	varchar(128)
remarks	varchar(256)

new
column	data type
table_catalog	varchar(128)
table_schema	varchar(128)
table_name	varchar(128)
column_name	varchar(128)
ordinal_position	int4
column_default	varchar(4000)
is_nullable	varchar(3)
data_type	varchar(128)
character_maximum_length	int4
numeric_precision	int4
numeric_precision_radix	int4
numeric_scale	int4
datetime_precision	int4
interval_type	varchar(256)
interval_precision	varchar(256)
character_set_catalog	varchar(128)
character_set_schema	varchar(128)
character_set_name	varchar(128)
collation_catalog	varchar(128)
collation_schema	varchar(128)
collation_name	varchar(128)
domain_name	varchar(128)
remarks	varchar(256)

pg_catalog.sys_integration_activity

old
column	data type
integration_id	char(128)
target_database	char(128)
source	char(128)
checkpoint_name	char(128)
checkpoint_type	char(16)
checkpoint_bytes	int8
last_commit_timestamp	timestamp
modified_tables	int4
integration_start_time	timestamp
integration_end_time	timestamp

new
column	data type
integration_id	char(128)
target_database	char(128)
source	char(128)
checkpoint_name	char(128)
checkpoint_type	char(16)
checkpoint_bytes	int8
last_commit_timestamp	int4
modified_tables	int4
integration_start_time	int4
integration_end_time	timestamp

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	varchar(256)
table_id	int4
table_name	varchar(136)
is_rrscan	varchar(1)
start_time	timestamp
end_time	timestamp
duration	int8
alert	varchar(1024)
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
source	varchar(64)
data_skewness	int4
time_skewness	int4
is_active	varchar(1)

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	text
is_rrscan	text
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
source	text
data_skewness	int4
time_skewness	int4

pg_catalog.sys_unload_detail

old
column	data type
user_id	int4
query_id	int8
session_id	int4
transaction_id	int8
file_name	char(1280)
start_time	timestamp
end_time	timestamp
line_count	int8
transfer_size	int8
file_format	char(10)

new
column	data type
user_id	int4
query_id	int8
session_id	int4
transaction_id	int8
path	char(1280)
start_time	timestamp
end_time	timestamp
line_count	int8
transfer_size	int8
file_format	char(10)

pg_catalog.stl_awsclient_requests

old
column	data type
userid	int4
query	int4
slice	int4
recordtime	timestamp
pid	int4
http_method	char(64)
endpoint	char(128)
amzn_request_id	char(36)
response_code	int4
operation_name	char(128)
canonical_uri	char(1024)
canonical_query_string	char(1024)
network_namespace	int4
access_key_id	char(36)

new
column	data type

pg_catalog.stl_integration_table_state

old
column	data type
integration_id	char(128)
database_name	char(128)
schema_name	char(128)
table_name	char(128)
current_state	char(128)
previous_state	char(128)
record_time	timestamp
synced_log_coordinate	char(128)
reason	char(256)

new
column	data type

pg_catalog.stl_predicate_information

old
column	data type
userid	int4
query	int4
segment	int4
step	int4
node_id	int4
parent_node_id	int4
expr_datatype	int4
expr_name	char(64)
expr_id	int4

new
column	data type

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(200)

new
column	data type

pg_catalog.sys_integration_table_state

old
column	data type
integration_id	char(128)
database_name	char(128)
schema_name	char(128)
table_name	char(128)
state	char(128)
last_replicated_checkpoint	char(128)
reason	char(256)
last_updated	int4

new
column	data type

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(200)

new
column	data type