Redshift Observatory System Table Tracker

Tables

pg_internal.redshift_auto_health_check_6524297

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

old
column	data type	PK	U	NN
table_id	oid			NN
value_type	int2			NN
value	text

new
column	data type	PK	U	NN

pg_catalog.stcs_burst_prepare_time

old
column	data type	PK	U	NN
logtime	int8			NN
xid	int8			NN
pid	int8			NN
qid	int4			NN
total_time_in_prepare	float8			NN
attempts	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_lambda_invocation_ids

old
column	data type	PK	U	NN
padb_request_id	char(100)			NN
lambda_request_id	char(100)			NN
recordtime	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_tidal_tbl_perm

old
column	data type	PK	U	NN
recordtime	int8			NN
user_id	int4			NN
table_name	char(128)			NN
table_id	int4			NN
delete_table_id	int4			NN
slice	int4			NN
temp	int4			NN
db_id	int4			NN
dist_style	int4			NN
block_count	int4			NN
partial_block_count	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_topology_mapping

old
column	data type	PK	U	NN
record_time	int8			NN
remote_topology	int8			NN
remote_node	int4			NN
native_node	int4			NN
remote_global_slice	int4			NN
native_global_slice	int4			NN
remote_node_slice	int4			NN
native_node_slice	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_udf_usage_in_query

old
column	data type	PK	U	NN
query	int4			NN
nodeid	int4			NN
plan_node_type	int4			NN
func_id	int4			NN
func_name	char(200)			NN
func_type	int4			NN
in_targetlist	int4			NN
recordtime	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_burst_prepare_time

old
column	data type	PK	U	NN
logtime	timestamp			NN
xid	int8			NN
pid	int8			NN
qid	int4			NN
total_time_in_prepare	float8			NN
attempts	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_lambda_invocation_ids

old
column	data type	PK	U	NN
padb_request_id	char(100)			NN
lambda_request_id	char(100)			NN
recordtime	timestamp			NN

new
column	data type	PK	U	NN

pg_catalog.stll_tidal_tbl_perm

old
column	data type	PK	U	NN
recordtime	int8			NN
user_id	int4			NN
table_name	char(128)			NN
table_id	int4			NN
delete_table_id	int4			NN
slice	int4			NN
temp	int4			NN
db_id	int4			NN
dist_style	int4			NN
block_count	int4			NN
partial_block_count	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_topology_mapping

old
column	data type	PK	U	NN
record_time	timestamp			NN
remote_topology	int8			NN
remote_node	int4			NN
native_node	int4			NN
remote_global_slice	int4			NN
native_global_slice	int4			NN
remote_node_slice	int4			NN
native_node_slice	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_udf_usage_in_query

old
column	data type	PK	U	NN
query	int4			NN
nodeid	int4			NN
plan_node_type	int4			NN
func_id	int4			NN
func_name	char(200)			NN
func_type	int4			NN
in_targetlist	int4			NN
recordtime	timestamp			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_16351582

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_auto_copy.copy_job_detail

old
column	data type
job_owner	int8
job_id	int8
job_name	varchar(256)
generation	int4
xid	int8
file_location	varchar(256)
file_name	varchar(2048)
file_size	int8
file_etag	varchar(512)
modification_time	timestamp
enqueue_time	timestamp
ingestion_status	int2

new
column	data type

pg_catalog.stl_burst_prepare_time

old
column	data type
logtime	timestamp
xid	int8
pid	int8
qid	int4
total_time_in_prepare	float8
attempts	int4

new
column	data type

pg_catalog.stl_lambda_invocation_ids

old
column	data type
padb_request_id	char(100)
lambda_request_id	char(100)
recordtime	timestamp

new
column	data type

pg_catalog.stl_tidal_tbl_perm

old
column	data type
recordtime	int8
user_id	int4
table_name	char(128)
table_id	int4
delete_table_id	int4
slice	int4
temp	int4
db_id	int4
dist_style	int4
block_count	int4
partial_block_count	int4

new
column	data type

pg_catalog.stl_topology_mapping

old
column	data type
record_time	timestamp
remote_topology	int8
remote_node	int4
native_node	int4
remote_global_slice	int4
native_global_slice	int4
remote_node_slice	int4
native_node_slice	int4

new
column	data type

pg_catalog.stl_udf_usage_in_query

old
column	data type
query	int4
nodeid	int4
plan_node_type	int4
func_id	int4
func_name	char(200)
func_type	int4
in_targetlist	int4
recordtime	timestamp

new
column	data type

pg_catalog.sys_copy_job_detail

old
column	data type
user_id	int8
database_name	name
job_name	varchar(256)
job_id	int8
file_location	varchar(256)
file_name	varchar(2048)
file_size	int8
file_etag	varchar(512)
modification_time	timestamp
enqueue_time	timestamp
status	text

new
column	data type

pg_catalog.sys_integration_table_activity

old
column	data type
integration_id	char(128)
checkpoint_name	char(128)
target_database	char(128)
schema_name	char(128)
table_name	char(128)
table_id	int4
record_time	timestamp
transaction_id	int8
inserted_rows	int8
deleted_rows	int8
updated_rows	int8
bytes_ingested	int8

new
column	data type