Redshift Research Project System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
new	pg_catalog	internal	immutable	bool	pg_default_perm_has_owner_grantee	oid
new	pg_catalog	internal	immutable	bool	pg_default_perm_has_public_grantee	oid
new	pg_catalog	internal	immutable	bool	pg_user_has_default_admin_option	int4,oid
new	pg_catalog	internal	stable	text	current_setting	text,bool

Tables

pg_catalog.pg_default_permission

old
column	data type	PK	U	NN

new
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[]

pg_catalog.stcs_epsilon_metadata_events

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_guid_cache_metrics

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_rls_applied_policy

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_user_load_error_detail

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

pg_catalog.stll_epsilon_metadata_events

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_guid_cache_metrics

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_rls_applied_policy

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_user_load_error_detail

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

pg_internal.redshift_auto_health_check_12636504

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_kinesis_scan_states

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	int8			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_seq_num	char(128)			NN
millis_behind_latest	int8			NN
worker_bytes	int8			NN
queue_bytes	int8			NN
scheduling_period	int8			NN
request_duration	int8			NN
tardiness	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
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	int8			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_seq_num	char(128)			NN
millis_behind_latest	int8			NN
worker_bytes	int8			NN
queue_bytes	int8			NN
scheduling_period	int8			NN
request_duration	int8			NN
tardiness	int8			NN
min_arrival_time	int8			NN
max_arrival_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_load_history_base

old
column	data type	PK	U	NN
user_id	int4			NN
db	char(64)			NN
xid	int8			NN
pid	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
status	int4			NN
table_name	char(128)			NN
event_time	int8			NN
slice	int4			NN
filename	char(256)			NN
file_count	int4			NN
file_bytes	int8			NN
bytes_copied	int8			NN
rows_copied	int8			NN
file_format	char(16)			NN
error_count	int4			NN
data_source	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
user_id	int4			NN
db	char(64)			NN
xid	int8			NN
pid	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
status	int4			NN
table_name	char(128)			NN
event_time	int8			NN
slice	int4			NN
filename	char(256)			NN
file_count	int4			NN
file_bytes	int8			NN
file_count_scanned	int4			NN
file_bytes_scanned	int8			NN
bytes_copied	int8			NN
rows_copied	int8			NN
file_format	char(16)			NN
error_count	int4			NN
data_source	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

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_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

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_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

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

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

pg_catalog.stcs_s3client

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
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
transfer_size	int8			NN
data_size	int8			NN
start_time	int8			NN
end_time	int8			NN
transfer_time	int8			NN
compression_time	int8			NN
connect_time	int8			NN
app_connect_time	int8			NN
retries	int4			NN
request_id	char(32)			NN
extended_request_id	char(128)			NN
ip_address	char(64)			NN
thread_id	int4			NN
original_start_time_us	int8			NN
total_transfer_time_us_with_retries	int8			NN
node	int4			NN
tbl_id	int4			NN
one_perm_rep	int4			NN
flags	int4			NN
s3_write_type	char(64)			NN
is_s3commit_write	int4			NN
is_partial	int4			NN
start_offset	int8			NN
col_num	int4			NN
is_wam_write	int4			NN
wam_precommit_id	int4			NN
region	char(64)			NN
is_xregion	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
userid	int4			NN
query	int4			NN
slice	int4			NN
recordtime	int8			NN
pid	int4			NN
http_method	char(64)			NN
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
transfer_size	int8			NN
data_size	int8			NN
start_time	int8			NN
end_time	int8			NN
transfer_time	int8			NN
compression_time	int8			NN
connect_time	int8			NN
app_connect_time	int8			NN
retries	int4			NN
request_id	char(32)			NN
extended_request_id	char(128)			NN
ip_address	char(64)			NN
thread_id	int4			NN
original_start_time_us	int8			NN
total_transfer_time_us_with_retries	int8			NN
node	int4			NN
tbl_id	int4			NN
one_perm_rep	int4			NN
flags	int4			NN
s3_write_type	char(64)			NN
is_s3commit_write	int4			NN
is_partial	int4			NN
start_offset	int8			NN
col_num	int4			NN
is_wam_write	int4			NN
wam_precommit_id	int4			NN
region	char(64)			NN
is_xregion	int4			NN
is_spectrum_request	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.stcs_scan

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
fetches	int8			NN
type	int4			NN
tbl	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
rows_pre_filter	int8			NN
rows_pre_user_filter	int8			NN
perm_table_name	char(136)			NN
is_rlf_scan	char(1)			NN
is_rlf_scan_reason	int4			NN
num_em_blocks	int4			NN
checksum	int8			NN
runtime_filtering	char(1)			NN
scan_region	int4			NN
num_sortkey_as_predicate	int4			NN
row_fetcher_state	int4			NN
consumed_scan_ranges	int8			NN
work_stealing_reason	int8			NN
is_vectorized_scan	char(1)			NN
is_vectorized_scan_reason	int4			NN
row_fetcher_reason	int8			NN
topology_signature	int8			NN
use_tpm_partition	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
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
fetches	int8			NN
type	int4			NN
tbl	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
rows_pre_filter	int8			NN
rows_pre_user_filter	int8			NN
perm_table_name	char(136)			NN
is_rlf_scan	char(1)			NN
is_rlf_scan_reason	int4			NN
num_em_blocks	int4			NN
checksum	int8			NN
runtime_filtering	char(1)			NN
scan_region	int4			NN
num_sortkey_as_predicate	int4			NN
row_fetcher_state	int4			NN
consumed_scan_ranges	int8			NN
work_stealing_reason	int8			NN
is_vectorized_scan	char(1)			NN
is_vectorized_scan_reason	int4			NN
row_fetcher_reason	int8			NN
topology_signature	int8			NN
use_tpm_partition	char(1)			NN
is_rrscan_expr	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

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

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

pg_catalog.stll_kinesis_scan_states

old
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	timestamp			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_seq_num	char(128)			NN
millis_behind_latest	int8			NN
worker_bytes	int8			NN
queue_bytes	int8			NN
scheduling_period	int8			NN
request_duration	int8			NN
tardiness	int8			NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	timestamp			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_seq_num	char(128)			NN
millis_behind_latest	int8			NN
worker_bytes	int8			NN
queue_bytes	int8			NN
scheduling_period	int8			NN
request_duration	int8			NN
tardiness	int8			NN
min_arrival_time	timestamp			NN
max_arrival_time	timestamp			NN

pg_catalog.stll_load_history_base

old
column	data type	PK	U	NN
user_id	int4			NN
db	char(64)			NN
xid	int8			NN
pid	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
status	int4			NN
table_name	char(128)			NN
event_time	timestamp			NN
slice	int4			NN
filename	char(256)			NN
file_count	int4			NN
file_bytes	int8			NN
bytes_copied	int8			NN
rows_copied	int8			NN
file_format	char(16)			NN
error_count	int4			NN
data_source	char(256)			NN

new
column	data type	PK	U	NN
user_id	int4			NN
db	char(64)			NN
xid	int8			NN
pid	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
status	int4			NN
table_name	char(128)			NN
event_time	timestamp			NN
slice	int4			NN
filename	char(256)			NN
file_count	int4			NN
file_bytes	int8			NN
file_count_scanned	int4			NN
file_bytes_scanned	int8			NN
bytes_copied	int8			NN
rows_copied	int8			NN
file_format	char(16)			NN
error_count	int4			NN
data_source	char(256)			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_blocks	int8			NN
remote_read_blocks	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_io	int8			NN
remote_read_io	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(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

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

pg_catalog.stll_s3client

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
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
transfer_size	int8			NN
data_size	int8			NN
start_time	int8			NN
end_time	int8			NN
transfer_time	int8			NN
compression_time	int8			NN
connect_time	int8			NN
app_connect_time	int8			NN
retries	int4			NN
request_id	char(32)			NN
extended_request_id	char(128)			NN
ip_address	char(64)			NN
thread_id	int4			NN
original_start_time_us	int8			NN
total_transfer_time_us_with_retries	int8			NN
node	int4			NN
tbl_id	int4			NN
one_perm_rep	int4			NN
flags	int4			NN
s3_write_type	char(64)			NN
is_s3commit_write	int4			NN
is_partial	int4			NN
start_offset	int8			NN
col_num	int4			NN
is_wam_write	int4			NN
wam_precommit_id	int4			NN
region	char(64)			NN
is_xregion	int4			NN

new
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
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
transfer_size	int8			NN
data_size	int8			NN
start_time	int8			NN
end_time	int8			NN
transfer_time	int8			NN
compression_time	int8			NN
connect_time	int8			NN
app_connect_time	int8			NN
retries	int4			NN
request_id	char(32)			NN
extended_request_id	char(128)			NN
ip_address	char(64)			NN
thread_id	int4			NN
original_start_time_us	int8			NN
total_transfer_time_us_with_retries	int8			NN
node	int4			NN
tbl_id	int4			NN
one_perm_rep	int4			NN
flags	int4			NN
s3_write_type	char(64)			NN
is_s3commit_write	int4			NN
is_partial	int4			NN
start_offset	int8			NN
col_num	int4			NN
is_wam_write	int4			NN
wam_precommit_id	int4			NN
region	char(64)			NN
is_xregion	int4			NN
is_spectrum_request	int4			NN

pg_catalog.stll_scan

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
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
fetches	int8			NN
type	int4			NN
tbl	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
rows_pre_filter	int8			NN
rows_pre_user_filter	int8			NN
perm_table_name	char(136)			NN
is_rlf_scan	char(1)			NN
is_rlf_scan_reason	int4			NN
num_em_blocks	int4			NN
checksum	int8			NN
runtime_filtering	char(1)			NN
scan_region	int4			NN
num_sortkey_as_predicate	int4			NN
row_fetcher_state	int4			NN
consumed_scan_ranges	int8			NN
work_stealing_reason	int8			NN
is_vectorized_scan	char(1)			NN
is_vectorized_scan_reason	int4			NN
row_fetcher_reason	int8			NN
topology_signature	int8			NN
use_tpm_partition	char(1)			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
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
fetches	int8			NN
type	int4			NN
tbl	int4			NN
is_rrscan	char(1)			NN
is_delayed_scan	char(1)			NN
rows_pre_filter	int8			NN
rows_pre_user_filter	int8			NN
perm_table_name	char(136)			NN
is_rlf_scan	char(1)			NN
is_rlf_scan_reason	int4			NN
num_em_blocks	int4			NN
checksum	int8			NN
runtime_filtering	char(1)			NN
scan_region	int4			NN
num_sortkey_as_predicate	int4			NN
row_fetcher_state	int4			NN
consumed_scan_ranges	int8			NN
work_stealing_reason	int8			NN
is_vectorized_scan	char(1)			NN
is_vectorized_scan_reason	int4			NN
row_fetcher_reason	int8			NN
topology_signature	int8			NN
use_tpm_partition	char(1)			NN
is_rrscan_expr	char(1)			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(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

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

pg_catalog.stv_logical_data_slices

old
column	data type	PK	U	NN
slice	int4			NN
num_data_slices	int4			NN
num_logical_data_slices	int4			NN

new
column	data type	PK	U	NN
slice	int4			NN
num_data_slices	int4			NN
num_logical_data_slices	int4			NN
nws	char(1)			NN

pg_catalog.stv_tbl_perm_property

old
column	data type	PK	U	NN
slice	int4			NN
db_id	int4			NN
namespace_id	int4			NN
id	int4			NN
name	char(72)			NN
rows	int8			NN
sorted_rows	int8			NN
temp	int4			NN
insert_pristine	int4			NN
delete_pristine	int4			NN
backup	int4			NN
dist	int4			NN
ddl_end_version	int8			NN
total_col_num	int4			NN
shadow_col_num	int4			NN
dml_end_version	int8			NN

new
column	data type	PK	U	NN
slice	int4			NN
db_id	int4			NN
namespace_id	int4			NN
id	int4			NN
name	char(72)			NN
rows	int8			NN
sorted_rows	int8			NN
temp	int4			NN
insert_pristine	int4			NN
delete_pristine	int4			NN
backup	int4			NN
dist	int4			NN
ddl_end_version	int8			NN
total_col_num	int4			NN
shadow_col_num	int4			NN
dml_end_version	int8			NN
rowid_encoding_type	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(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

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

Views

pg_catalog.stl_epsilon_metadata_events

old
column	data type

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

pg_catalog.stl_guid_cache_metrics

old
column	data type

new
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

pg_catalog.stl_rls_applied_policy

old
column	data type

new
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)

pg_catalog.stl_user_load_error_detail

old
column	data type

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

pg_catalog.svv_default_privileges

old
column	data type

new
column	data type
schema_name	varchar(128)
object_type	varchar(16)
owner_id	int4
owner_name	varchar(128)
owner_type	varchar(128)
privilege_type	varchar(128)
grantee_id	int4
grantee_name	varchar(128)
grantee_type	varchar(128)
admin_option	bool

pg_catalog.svv_rls_applied_policy

old
column	data type

new
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

pg_catalog.stl_kinesis_scan_states

old
column	data type
query	int4
node	int4
slice	int4
segment	int4
pid	int4
record_time	timestamp
schema_name	char(128)
stream_name	char(128)
shard_id	char(128)
num_records	int8
num_skipped_records	int8
num_bytes	int8
latest_seq_num	char(128)
millis_behind_latest	int8
worker_bytes	int8
queue_bytes	int8
scheduling_period	int8
request_duration	int8
tardiness	int8

new
column	data type
query	int4
node	int4
slice	int4
segment	int4
pid	int4
record_time	timestamp
schema_name	char(128)
stream_name	char(128)
shard_id	char(128)
num_records	int8
num_skipped_records	int8
num_bytes	int8
latest_seq_num	char(128)
millis_behind_latest	int8
worker_bytes	int8
queue_bytes	int8
scheduling_period	int8
request_duration	int8
tardiness	int8
min_arrival_time	timestamp
max_arrival_time	timestamp

pg_catalog.stl_load_history_base

old
column	data type
user_id	int4
db	char(64)
xid	int8
pid	int4
query_id	int8
child_query_sequence	int4
child_query_id	int4
status	int4
table_name	char(128)
event_time	timestamp
slice	int4
filename	char(256)
file_count	int4
file_bytes	int8
bytes_copied	int8
rows_copied	int8
file_format	char(16)
error_count	int4
data_source	char(256)

new
column	data type
user_id	int4
db	char(64)
xid	int8
pid	int4
query_id	int8
child_query_sequence	int4
child_query_id	int4
status	int4
table_name	char(128)
event_time	timestamp
slice	int4
filename	char(256)
file_count	int4
file_bytes	int8
file_count_scanned	int4
file_bytes_scanned	int8
bytes_copied	int8
rows_copied	int8
file_format	char(16)
error_count	int4
data_source	char(256)

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_blocks	int8
remote_read_blocks	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_io	int8
remote_read_io	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(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)

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

pg_catalog.stl_s3client

old
column	data type
userid	int4
query	int4
slice	int4
recordtime	timestamp
pid	int4
http_method	char(64)
s3_action	char(64)
bucket	char(64)
key	char(256)
transfer_size	int8
data_size	int8
start_time	int8
end_time	int8
transfer_time	int8
compression_time	int8
connect_time	int8
app_connect_time	int8
retries	int4
request_id	char(32)
extended_request_id	char(128)
ip_address	char(64)
thread_id	int4
original_start_time_us	int8
total_transfer_time_us_with_retries	int8
node	int4
tbl_id	int4
one_perm_rep	int4
flags	int4
s3_write_type	char(64)
is_s3commit_write	int4
is_partial	int4
start_offset	int8
col_num	int4
is_wam_write	int4
wam_precommit_id	int4
region	char(64)
is_xregion	int4

new
column	data type
userid	int4
query	int4
slice	int4
recordtime	timestamp
pid	int4
http_method	char(64)
s3_action	char(64)
bucket	char(64)
key	char(256)
transfer_size	int8
data_size	int8
start_time	int8
end_time	int8
transfer_time	int8
compression_time	int8
connect_time	int8
app_connect_time	int8
retries	int4
request_id	char(32)
extended_request_id	char(128)
ip_address	char(64)
thread_id	int4
original_start_time_us	int8
total_transfer_time_us_with_retries	int8
node	int4
tbl_id	int4
one_perm_rep	int4
flags	int4
s3_write_type	char(64)
is_s3commit_write	int4
is_partial	int4
start_offset	int8
col_num	int4
is_wam_write	int4
wam_precommit_id	int4
region	char(64)
is_xregion	int4
is_spectrum_request	int4

pg_catalog.stl_scan

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
fetches	int8
type	int4
tbl	int4
is_rrscan	char(1)
is_delayed_scan	char(1)
rows_pre_filter	int8
rows_pre_user_filter	int8
perm_table_name	char(136)
is_rlf_scan	char(1)
is_rlf_scan_reason	int4
num_em_blocks	int4
checksum	int8
runtime_filtering	char(1)
scan_region	int4
num_sortkey_as_predicate	int4
row_fetcher_state	int4
consumed_scan_ranges	int8
work_stealing_reason	int8
is_vectorized_scan	char(1)
is_vectorized_scan_reason	int4
row_fetcher_reason	int8
topology_signature	int8
use_tpm_partition	char(1)

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
fetches	int8
type	int4
tbl	int4
is_rrscan	char(1)
is_delayed_scan	char(1)
rows_pre_filter	int8
rows_pre_user_filter	int8
perm_table_name	char(136)
is_rlf_scan	char(1)
is_rlf_scan_reason	int4
num_em_blocks	int4
checksum	int8
runtime_filtering	char(1)
scan_region	int4
num_sortkey_as_predicate	int4
row_fetcher_state	int4
consumed_scan_ranges	int8
work_stealing_reason	int8
is_vectorized_scan	char(1)
is_vectorized_scan_reason	int4
row_fetcher_reason	int8
topology_signature	int8
use_tpm_partition	char(1)
is_rrscan_expr	char(1)

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

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

pg_catalog.sys_load_error_detail

old
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)

new
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)

pg_catalog.sys_load_history

old
column	data type
user_id	int4
query_id	int8
status	text
session_id	int4
transaction_id	int8
database_name	text
table_name	text
start_time	timestamp
end_time	timestamp
duration	int8
data_source	text
loaded_rows	int8
loaded_bytes	int8
source_file_count	int8
source_file_bytes	int8
error_count	int8

new
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
database_name	text
status	text
table_name	text
start_time	timestamp
end_time	timestamp
duration	int8
data_source	text
file_format	text
loaded_rows	int8
loaded_bytes	int8
source_file_count	int8
source_file_bytes	int8
file_count_scanned	int8
file_bytes_scanned	int8
error_count	int8

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

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

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

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