Redshift Research Project System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
dropped	pg_catalog	internal	immutable	geometry	st_geomfromgeojson	cstring
dropped	pg_catalog	internal	immutable	geometry	st_geomfromgeojson	text

Tables

pg_catalog.stcs_load_error_detail_base

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
raw_line	char(1024)			NN
raw_field_value	char(1024)			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.stcs_query_history_base

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
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.stll_load_error_detail_base

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
raw_line	char(1024)			NN
raw_field_value	char(1024)			NN
err_code	int4			NN
err_reason	char(100)			NN

pg_catalog.stll_query_history_base

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
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_internal.redshift_auto_health_check_13223642

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.stv_disk_cache_state

old
column	data type	PK	U	NN
node	int4			NN
cache_size_mb	float8			NN
size_limit_mb	float8			NN
lru_size	int8			NN
throttle_points	int8			NN
ra_points	float8			NN
scans_running	int4			NN
total_size_of_rowblock	int8			NN
total_size_of_rowblock_pinned	int8			NN
percentage_shared_mem_used	float8			NN
cache_shd_mem_perc	float8			NN
size_delta_mb	int4			NN
high_water_mark	int8			NN
low_water_mark	int8			NN
megarowblocks_currently_in_cache	int8			NN
total_size_of_megarowblocks	int8			NN

new
column	data type	PK	U	NN
node	int4			NN
cache_size_mb	float8			NN
size_limit_mb	float8			NN
lru_size	int8			NN
throttle_points	int8			NN
ra_points	float8			NN
scans_running	int4			NN
rowsets_currently_in_cache	int8			NN
rowsets_currently_pinned	int8			NN
percentage_shared_mem_used	float8			NN
cache_shd_mem_perc	float8			NN
size_delta_mb	int4			NN
high_water_mark	int8			NN
low_water_mark	int8			NN

pg_catalog.stcs_auto_task_events

old
column	data type	PK	U	NN
actor_pid	int4			NN
task_type	char(100)			NN
task_state	char(50)			NN
priority	float8			NN
run_queries	int4			NN
pid	int4			NN
retry_count	int4			NN
production_time	int8			NN
max_execution_time_sec	int4			NN
event_time	int8			NN
message	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.stcs_pg_wal_stats

old
column	data type	PK	U	NN
period_start	int8			NN
log_time	int8			NN
num_wal_inserts	int8			NN
num_wal_writes	int8			NN
num_repwal_msgs	int8			NN
total_repwal_size_kb	int8			NN
total_repwal_time_ms	int8			NN
avg_repwal_time_us	int8			NN
max_repwal_time_us	int8			NN
logged_manually	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_query_concurrency_scaling_fail_reasons

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
timestamp	int8			NN
concurrency_scaling_status	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_xrestore_cluster_level_distkey_tables

old
column	data type	PK	U	NN
tbl	int4			NN
action	char(64)			NN
event_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

new
column	data type	PK	U	NN

pg_catalog.stll_auto_task_events

old
column	data type	PK	U	NN
actor_pid	int4			NN
task_type	char(100)			NN
task_state	char(50)			NN
priority	float8			NN
run_queries	int4			NN
pid	int4			NN
retry_count	int4			NN
production_time	int8			NN
max_execution_time_sec	int4			NN
event_time	timestamp			NN
message	char(100)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_pg_wal_stats

old
column	data type	PK	U	NN
period_start	timestamp			NN
log_time	timestamp			NN
num_wal_inserts	int8			NN
num_wal_writes	int8			NN
num_repwal_msgs	int8			NN
total_repwal_size_kb	int8			NN
total_repwal_time_ms	int8			NN
avg_repwal_time_us	int8			NN
max_repwal_time_us	int8			NN
logged_manually	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_query_concurrency_scaling_fail_reasons

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
timestamp	timestamp			NN
concurrency_scaling_status	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_xrestore_cluster_level_distkey_tables

old
column	data type	PK	U	NN
tbl	int4			NN
action	char(64)			NN
event_time	timestamp			NN

new
column	data type	PK	U	NN

pg_catalog.stv_auto_task_queue_state

old
column	data type	PK	U	NN
task_type	char(50)			NN
task_state	char(50)			NN
priority	float8			NN
run_queries	int4			NN
pid	int4			NN
retry_count	int4			NN
production_time	int8			NN
max_execution_time_sec	int4			NN
message	char(100)			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_1632608

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_load_error_detail_base

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
raw_line	char(1024)
raw_field_value	char(1024)
err_code	int4
err_reason	char(100)

pg_catalog.stl_query_history_base

old
column	data type

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.sys_load_error_detail

old
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
database_name	text
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
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_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(32)
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)

pg_catalog.stl_auto_task_events

old
column	data type
actor_pid	int4
task_type	char(100)
task_state	char(50)
priority	float8
run_queries	int4
pid	int4
retry_count	int4
production_time	int8
max_execution_time_sec	int4
event_time	timestamp
message	char(100)

new
column	data type

pg_catalog.stl_pg_wal_stats

old
column	data type
period_start	timestamp
log_time	timestamp
num_wal_inserts	int8
num_wal_writes	int8
num_repwal_msgs	int8
total_repwal_size_kb	int8
total_repwal_time_ms	int8
avg_repwal_time_us	int8
max_repwal_time_us	int8
logged_manually	int4

new
column	data type

pg_catalog.stl_query_concurrency_scaling_fail_reasons

old
column	data type
userid	int4
xid	int8
pid	int4
query	int4
timestamp	timestamp
concurrency_scaling_status	int4

new
column	data type

pg_catalog.stl_xrestore_cluster_level_distkey_tables

old
column	data type
tbl	int4
action	char(64)
event_time	timestamp

new
column	data type

pg_catalog.svl_restore_alter_table_progress

old
column	data type
tbl	int4
progress	varchar(41)
message	char(350)

new
column	data type

pg_catalog.svv_geography_columns

old
column	data type
f_table_catalog	varchar(128)
f_table_schema	varchar(128)
f_table_name	varchar(128)
f_geography_column	varchar(128)
coord_dimension	int4
srid	int4
type	varchar(9)

new
column	data type

pg_catalog.svv_geometry_columns

old
column	data type
f_table_catalog	varchar(128)
f_table_schema	varchar(128)
f_table_name	varchar(128)
f_geometry_column	varchar(128)
coord_dimension	int4
srid	int4
type	varchar(8)

new
column	data type