Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
dropped	information_schema	sql	immutable	int4	_pg_interval_precision	oid,int4
dropped	information_schema	sql	immutable	varchar	_pg_interval_type	oid,int4

Tables

pg_internal.redshift_auto_health_check_4433988

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_connection_log

old
column	data type	PK	U	NN
event	char(50)			NN
recordtime	int8			NN
remotehost	char(45)			NN
remoteport	char(32)			NN
pid	int4			NN
dbname	char(50)			NN
username	char(50)			NN
authmethod	char(32)			NN
duration	int8			NN
sslversion	char(50)			NN
sslcipher	char(128)			NN
mtu	int4			NN
sslcompression	char(64)			NN
sslexpansion	char(64)			NN
iamauthguid	char(36)			NN
application_name	char(250)			NN
os_version	char(64)			NN
driver_version	char(64)			NN
plugin_name	char(32)			NN
protocol_version	int4			NN
sessionid	char(36)			NN
compression	char(16)			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
event	char(50)			NN
recordtime	int8			NN
remotehost	char(32)			NN
remoteport	char(32)			NN
pid	int4			NN
dbname	char(50)			NN
username	char(50)			NN
authmethod	char(32)			NN
duration	int8			NN
sslversion	char(50)			NN
sslcipher	char(128)			NN
mtu	int4			NN
sslcompression	char(64)			NN
sslexpansion	char(64)			NN
iamauthguid	char(36)			NN
application_name	char(250)			NN
os_version	char(64)			NN
driver_version	char(64)			NN
plugin_name	char(32)			NN
protocol_version	int4			NN
sessionid	char(36)			NN
compression	char(16)			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_restarted_sessions

old
column	data type	PK	U	NN
currenttime	int8			NN
dbname	char(50)			NN
newpid	int4			NN
oldpid	int4			NN
username	char(50)			NN
remotehost	char(45)			NN
remoteport	char(32)			NN
parkedtime	int8			NN
session_vars	char(2000)			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
currenttime	int8			NN
dbname	char(50)			NN
newpid	int4			NN
oldpid	int4			NN
username	char(50)			NN
remotehost	char(32)			NN
remoteport	char(32)			NN
parkedtime	int8			NN
session_vars	char(2000)			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_connection_log

old
column	data type	PK	U	NN
event	char(50)			NN
recordtime	timestamp			NN
remotehost	char(45)			NN
remoteport	char(32)			NN
pid	int4			NN
dbname	char(50)			NN
username	char(50)			NN
authmethod	char(32)			NN
duration	int8			NN
sslversion	char(50)			NN
sslcipher	char(128)			NN
mtu	int4			NN
sslcompression	char(64)			NN
sslexpansion	char(64)			NN
iamauthguid	char(36)			NN
application_name	char(250)			NN
os_version	char(64)			NN
driver_version	char(64)			NN
plugin_name	char(32)			NN
protocol_version	int4			NN
sessionid	char(36)			NN
compression	char(16)			NN

new
column	data type	PK	U	NN
event	char(50)			NN
recordtime	timestamp			NN
remotehost	char(32)			NN
remoteport	char(32)			NN
pid	int4			NN
dbname	char(50)			NN
username	char(50)			NN
authmethod	char(32)			NN
duration	int8			NN
sslversion	char(50)			NN
sslcipher	char(128)			NN
mtu	int4			NN
sslcompression	char(64)			NN
sslexpansion	char(64)			NN
iamauthguid	char(36)			NN
application_name	char(250)			NN
os_version	char(64)			NN
driver_version	char(64)			NN
plugin_name	char(32)			NN
protocol_version	int4			NN
sessionid	char(36)			NN
compression	char(16)			NN

pg_catalog.stll_restarted_sessions

old
column	data type	PK	U	NN
currenttime	timestamp			NN
dbname	char(50)			NN
newpid	int4			NN
oldpid	int4			NN
username	char(50)			NN
remotehost	char(45)			NN
remoteport	char(32)			NN
parkedtime	timestamp			NN
session_vars	char(2000)			NN

new
column	data type	PK	U	NN
currenttime	timestamp			NN
dbname	char(50)			NN
newpid	int4			NN
oldpid	int4			NN
username	char(50)			NN
remotehost	char(32)			NN
remoteport	char(32)			NN
parkedtime	timestamp			NN
session_vars	char(2000)			NN

pg_catalog.stcs_backend_slot

old
column	data type	PK	U	NN
recordtime	int8			NN
pid	int4			NN
event	char(30)			NN
slots	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_compute_elasticity_insert

old
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
ds_calc_option	int4			NN
parallel_insert_degree	int4			NN
parallel_insert_reason	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_copy_job_info

old
column	data type	PK	U	NN
user_id	int4			NN
job_id	int8			NN
job_name	char(128)			NN
transaction_id	int8			NN
database_name	char(128)			NN
record_time	int8			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.stll_backend_slot

old
column	data type	PK	U	NN
recordtime	timestamp			NN
pid	int4			NN
event	char(30)			NN
slots	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_compute_elasticity_insert

old
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
ds_calc_option	int4			NN
parallel_insert_degree	int4			NN
parallel_insert_reason	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_copy_job_info

old
column	data type	PK	U	NN
user_id	int4			NN
job_id	int8			NN
job_name	char(128)			NN
transaction_id	int8			NN
database_name	char(128)			NN
record_time	timestamp			NN
message	char(512)			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_4400005

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

information_schema.columns

old
column	data type
table_catalog	sql_identifier
table_schema	sql_identifier
table_name	sql_identifier
column_name	sql_identifier
ordinal_position	cardinal_number
column_default	character_data
is_nullable	character_data
data_type	character_data
character_maximum_length	cardinal_number
character_octet_length	cardinal_number
numeric_precision	cardinal_number
numeric_precision_radix	cardinal_number
numeric_scale	cardinal_number
datetime_precision	cardinal_number
interval_type	character_data
interval_precision	cardinal_number
character_set_catalog	sql_identifier
character_set_schema	sql_identifier
character_set_name	sql_identifier
collation_catalog	sql_identifier
collation_schema	sql_identifier
collation_name	sql_identifier
domain_catalog	sql_identifier
domain_schema	sql_identifier
domain_name	sql_identifier
udt_catalog	sql_identifier
udt_schema	sql_identifier
udt_name	sql_identifier
scope_catalog	sql_identifier
scope_schema	sql_identifier
scope_name	sql_identifier
maximum_cardinality	cardinal_number
dtd_identifier	sql_identifier
is_self_referencing	character_data

new
column	data type
table_catalog	sql_identifier
table_schema	sql_identifier
table_name	sql_identifier
column_name	sql_identifier
ordinal_position	cardinal_number
column_default	character_data
is_nullable	character_data
data_type	character_data
character_maximum_length	cardinal_number
character_octet_length	cardinal_number
numeric_precision	cardinal_number
numeric_precision_radix	cardinal_number
numeric_scale	cardinal_number
datetime_precision	cardinal_number
interval_type	character_data
interval_precision	character_data
character_set_catalog	sql_identifier
character_set_schema	sql_identifier
character_set_name	sql_identifier
collation_catalog	sql_identifier
collation_schema	sql_identifier
collation_name	sql_identifier
domain_catalog	sql_identifier
domain_schema	sql_identifier
domain_name	sql_identifier
udt_catalog	sql_identifier
udt_schema	sql_identifier
udt_name	sql_identifier
scope_catalog	sql_identifier
scope_schema	sql_identifier
scope_name	sql_identifier
maximum_cardinality	cardinal_number
dtd_identifier	sql_identifier
is_self_referencing	character_data

information_schema.domains

old
column	data type
domain_catalog	sql_identifier
domain_schema	sql_identifier
domain_name	sql_identifier
data_type	character_data
character_maximum_length	cardinal_number
character_octet_length	cardinal_number
character_set_catalog	sql_identifier
character_set_schema	sql_identifier
character_set_name	sql_identifier
collation_catalog	sql_identifier
collation_schema	sql_identifier
collation_name	sql_identifier
numeric_precision	cardinal_number
numeric_precision_radix	cardinal_number
numeric_scale	cardinal_number
datetime_precision	cardinal_number
interval_type	character_data
interval_precision	cardinal_number
domain_default	character_data
udt_catalog	sql_identifier
udt_schema	sql_identifier
udt_name	sql_identifier
scope_catalog	sql_identifier
scope_schema	sql_identifier
scope_name	sql_identifier
maximum_cardinality	cardinal_number
dtd_identifier	sql_identifier

new
column	data type
domain_catalog	sql_identifier
domain_schema	sql_identifier
domain_name	sql_identifier
data_type	character_data
character_maximum_length	cardinal_number
character_octet_length	cardinal_number
character_set_catalog	sql_identifier
character_set_schema	sql_identifier
character_set_name	sql_identifier
collation_catalog	sql_identifier
collation_schema	sql_identifier
collation_name	sql_identifier
numeric_precision	cardinal_number
numeric_precision_radix	cardinal_number
numeric_scale	cardinal_number
datetime_precision	cardinal_number
interval_type	character_data
interval_precision	character_data
domain_default	character_data
udt_catalog	sql_identifier
udt_schema	sql_identifier
udt_name	sql_identifier
scope_catalog	sql_identifier
scope_schema	sql_identifier
scope_name	sql_identifier
maximum_cardinality	cardinal_number
dtd_identifier	sql_identifier

pg_catalog.stl_connection_log

old
column	data type
event	char(50)
recordtime	timestamp
remotehost	char(45)
remoteport	char(32)
pid	int4
dbname	char(50)
username	char(50)
authmethod	char(32)
duration	int8
sslversion	char(50)
sslcipher	char(128)
mtu	int4
sslcompression	char(64)
sslexpansion	char(64)
iamauthguid	char(36)
application_name	char(250)
os_version	char(64)
driver_version	char(64)
plugin_name	char(32)
protocol_version	int4
sessionid	char(36)
compression	char(16)

new
column	data type
event	char(50)
recordtime	timestamp
remotehost	char(32)
remoteport	char(32)
pid	int4
dbname	char(50)
username	char(50)
authmethod	char(32)
duration	int8
sslversion	char(50)
sslcipher	char(128)
mtu	int4
sslcompression	char(64)
sslexpansion	char(64)
iamauthguid	char(36)
application_name	char(250)
os_version	char(64)
driver_version	char(64)
plugin_name	char(32)
protocol_version	int4
sessionid	char(36)
compression	char(16)

pg_catalog.stl_restarted_sessions

old
column	data type
currenttime	timestamp
dbname	char(50)
newpid	int4
oldpid	int4
username	char(50)
remotehost	char(45)
remoteport	char(32)
parkedtime	timestamp
session_vars	char(2000)

new
column	data type
currenttime	timestamp
dbname	char(50)
newpid	int4
oldpid	int4
username	char(50)
remotehost	char(32)
remoteport	char(32)
parkedtime	timestamp
session_vars	char(2000)

pg_catalog.svl_restore_alter_table_progress

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

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

pg_catalog.sys_connection_log

old
column	data type
event	char(50)
record_time	timestamp
remote_host	char(45)
remote_port	char(32)
session_id	int4
database_name	char(50)
user_name	char(50)
auth_method	char(32)
duration	int8
ssl_version	char(50)
ssl_cipher	char(128)
mtu	int4
ssl_compression	char(64)
ssl_expansion	char(64)
iam_auth_guid	char(36)
application_name	char(250)
driver_version	char(64)
os_version	char(64)
plugin_name	char(32)
protocol_version	int4
global_session_id	char(36)

new
column	data type
event	char(50)
record_time	timestamp
remote_host	char(32)
remote_port	char(32)
session_id	int4
database_name	char(50)
user_name	char(50)
auth_method	char(32)
duration	int8
ssl_version	char(50)
ssl_cipher	char(128)
mtu	int4
ssl_compression	char(64)
ssl_expansion	char(64)
iam_auth_guid	char(36)
application_name	char(250)
driver_version	char(64)
os_version	char(64)
plugin_name	char(32)
protocol_version	int4
global_session_id	char(36)

pg_catalog.stl_backend_slot

old
column	data type
recordtime	timestamp
pid	int4
event	char(30)
slots	int4

new
column	data type

pg_catalog.stl_compute_elasticity_insert

old
column	data type
query	int4
slice	int4
segment	int4
step	int4
ds_calc_option	int4
parallel_insert_degree	int4
parallel_insert_reason	int4

new
column	data type

pg_catalog.stl_copy_job_info

old
column	data type
user_id	int4
job_id	int8
job_name	char(128)
transaction_id	int8
database_name	char(128)
record_time	timestamp
message	char(512)

new
column	data type

pg_catalog.sys_copy_job_info

old
column	data type
job_id	int8
job_name	char(128)
database_name	char(128)
record_time	timestamp
message	char(512)

new
column	data type

pg_catalog.sys_restore_log

old
column	data type
database_name	varchar(128)
schema_name	varchar(128)
table_name	varchar(128)
table_id	int4
action	varchar(27)
total_data_processed	int8
delta_data_processed	int8
event_time	timestamp
table_size	int8
message	varchar(56)
redistribution_type	varchar(24)

new
column	data type