Redshift Observatory System Table Tracker

Tables

pg_catalog.stcs_awsidc_refresh_token_worker

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
vpid	int4			NN
starttime	int8			NN
endtime	int8			NN
num_session_monitored	int4			NN
num_session_revoked	int4			NN
revoked_sessions	char(250)			NN
exception	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_integration_datatype_mapping

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
db_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
checkpoint	char(128)			NN
log_coordinate	char(128)			NN
source_type	char(128)			NN
source_data_type	char(128)			NN
expected_export_type	char(128)			NN
length_of_datatype	int4			NN
mapped_data_type	char(128)			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_integration_ddl

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
db_name	char(128)			NN
checkpoint	char(128)			NN
log_coordinate	char(128)			NN
source_type	char(128)			NN
event_type	char(128)			NN
sequence	int4			NN
sql_query	char(1024)			NN
error_reason	char(256)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
event_code	char(128)			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_integration_scan

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	int8			NN
user_id	int4			NN
query	int4			NN
table_name	char(128)			NN
table_id	int4			NN
dt_table_id	int4			NN
num_table_rows	int8			NN
num_dt_table_rows	int8			NN
is_remote_scan	int4			NN
table_state	char(128)			NN
synced_log_coordinate	char(128)			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_integration_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	int8			NN
integration_type	char(16)			NN
integration_id	char(128)			NN
database_name	char(128)			NN
integration_state	char(128)			NN
schema_count	int4			NN
total_table_count	int4			NN
failed_table_count	int4			NN
resync_table_count	int4			NN
num_resyncs_initiated	int4			NN
num_resyncs_source_initiated	int4			NN
num_cdc_checkpoints_processed	int4			NN
num_cdc_ddl_checkpoints_processed	int4			NN
num_pe_tables	int4			NN
max_seed_pe_time_secs	int4			NN
max_resync_pe_time_secs	int4			NN
max_resync_cdc_time_secs	int4			NN
pe_bytes_ingested	int8			NN
cdc_bytes_ingested	int8			NN
num_commits	int4			NN
num_soft_commits	int4			NN
num_del_merges	int4			NN
max_lag	int4			NN
max_delay	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.stll_awsidc_refresh_token_worker

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
vpid	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
num_session_monitored	int4			NN
num_session_revoked	int4			NN
revoked_sessions	char(250)			NN
exception	int4			NN

pg_catalog.stll_integration_datatype_mapping

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
db_name	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
checkpoint	char(128)			NN
log_coordinate	char(128)			NN
source_type	char(128)			NN
source_data_type	char(128)			NN
expected_export_type	char(128)			NN
length_of_datatype	int4			NN
mapped_data_type	char(128)			NN

pg_catalog.stll_integration_ddl

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
db_name	char(128)			NN
checkpoint	char(128)			NN
log_coordinate	char(128)			NN
source_type	char(128)			NN
event_type	char(128)			NN
sequence	int4			NN
sql_query	char(1024)			NN
error_reason	char(256)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
event_code	char(128)			NN

pg_catalog.stll_integration_scan

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
user_id	int4			NN
query	int4			NN
table_name	char(128)			NN
table_id	int4			NN
dt_table_id	int4			NN
num_table_rows	int8			NN
num_dt_table_rows	int8			NN
is_remote_scan	int4			NN
table_state	char(128)			NN
synced_log_coordinate	char(128)			NN

pg_catalog.stll_integration_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
integration_type	char(16)			NN
integration_id	char(128)			NN
database_name	char(128)			NN
integration_state	char(128)			NN
schema_count	int4			NN
total_table_count	int4			NN
failed_table_count	int4			NN
resync_table_count	int4			NN
num_resyncs_initiated	int4			NN
num_resyncs_source_initiated	int4			NN
num_cdc_checkpoints_processed	int4			NN
num_cdc_ddl_checkpoints_processed	int4			NN
num_pe_tables	int4			NN
max_seed_pe_time_secs	int4			NN
max_resync_pe_time_secs	int4			NN
max_resync_cdc_time_secs	int4			NN
pe_bytes_ingested	int8			NN
cdc_bytes_ingested	int8			NN
num_commits	int4			NN
num_soft_commits	int4			NN
num_del_merges	int4			NN
max_lag	int4			NN
max_delay	int4			NN

pg_internal.redshift_auto_health_check_3696373

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_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
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
sequence	int4			NN
error_info	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.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
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
sequence	int4			NN
error_info	char(1024)			NN

pg_internal.redshift_auto_health_check_3639131

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_awsidc_refresh_token_worker

old
column	data type

new
column	data type
vpid	int4
starttime	timestamp
endtime	timestamp
num_session_monitored	int4
num_session_revoked	int4
revoked_sessions	char(250)
exception	int4

pg_catalog.stl_integration_datatype_mapping

old
column	data type

new
column	data type
record_time	timestamp
integration_id	char(128)
db_name	char(128)
schema_name	char(128)
table_name	char(128)
checkpoint	char(128)
log_coordinate	char(128)
source_type	char(128)
source_data_type	char(128)
expected_export_type	char(128)
length_of_datatype	int4
mapped_data_type	char(128)

pg_catalog.stl_integration_ddl

old
column	data type

new
column	data type
record_time	timestamp
integration_id	char(128)
db_name	char(128)
checkpoint	char(128)
log_coordinate	char(128)
source_type	char(128)
event_type	char(128)
sequence	int4
sql_query	char(1024)
error_reason	char(256)
schema_name	char(128)
table_name	char(128)
event_code	char(128)

pg_catalog.stl_integration_scan

old
column	data type

new
column	data type
record_time	timestamp
user_id	int4
query	int4
table_name	char(128)
table_id	int4
dt_table_id	int4
num_table_rows	int8
num_dt_table_rows	int8
is_remote_scan	int4
table_state	char(128)
synced_log_coordinate	char(128)

pg_catalog.stl_integration_stats

old
column	data type

new
column	data type
record_time	timestamp
integration_type	char(16)
integration_id	char(128)
database_name	char(128)
integration_state	char(128)
schema_count	int4
total_table_count	int4
failed_table_count	int4
resync_table_count	int4
num_resyncs_initiated	int4
num_resyncs_source_initiated	int4
num_cdc_checkpoints_processed	int4
num_cdc_ddl_checkpoints_processed	int4
num_pe_tables	int4
max_seed_pe_time_secs	int4
max_resync_pe_time_secs	int4
max_resync_cdc_time_secs	int4
pe_bytes_ingested	int8
cdc_bytes_ingested	int8
num_commits	int4
num_soft_commits	int4
num_del_merges	int4
max_lag	int4
max_delay	int4

pg_catalog.svv_integration_table_state

old
column	data type

new
column	data type
integration_id	char(128)
target_database	char(128)
schema_name	char(128)
table_name	char(128)
table_state	char(128)
table_last_replicated_checkpoint	char(128)
reason	char(256)
last_updated_timestamp	timestamp

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
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)
sequence	int4
error_info	char(1024)