Redshift Observatory System Table Tracker

Tables

pg_catalog.pg_consumer_object_owner

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
shareid	oid			NN
dbid	oid			NN
objtype	char(1)			NN
objid	oid			NN
produceruserid	int4			NN
consumernamespace	name			NN
consumeruserid	int4			NN

pg_catalog.pg_integration_invisible_xid

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
txn_seq	int8			NN
txn_id	int8			NN
invisible_xid	int8[]

pg_catalog.stcs_datashare_write_history

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
user_name	char(128)			NN
vpid	int4			NN
transaction_id	int8			NN
consumer_transaction_uid	char(64)			NN
db_id	int4			NN
db_name	char(128)			NN
object_type	char(64)			NN
object_id	int4			NN
object_name	char(128)			NN
query_type	char(64)			NN
record_time	int8			NN
inserted_row_count	int4			NN
deleted_row_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

pg_catalog.stcs_table_version_events

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	int8			NN
xid	int8			NN
pid	int8			NN
table_id	int4			NN
old_dml_version	int8			NN
new_dml_version	int8			NN
old_ddl_end_version	int8			NN
new_ddl_end_version	int8			NN
old_ddl_start_version	int8			NN
new_ddl_start_version	int8			NN
old_structure_version	int8			NN
new_structure_version	int8			NN
old_structure_delete_version	int8			NN
new_structure_delete_version	int8			NN
event	char(32)			NN
event_location	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.stll_datashare_write_history

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
user_name	char(128)			NN
vpid	int4			NN
transaction_id	int8			NN
consumer_transaction_uid	char(64)			NN
db_id	int4			NN
db_name	char(128)			NN
object_type	char(64)			NN
object_id	int4			NN
object_name	char(128)			NN
query_type	char(64)			NN
record_time	timestamp			NN
inserted_row_count	int4			NN
deleted_row_count	int4			NN

pg_catalog.stll_table_version_events

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
xid	int8			NN
pid	int8			NN
table_id	int4			NN
old_dml_version	int8			NN
new_dml_version	int8			NN
old_ddl_end_version	int8			NN
new_ddl_end_version	int8			NN
old_ddl_start_version	int8			NN
new_ddl_start_version	int8			NN
old_structure_version	int8			NN
new_structure_version	int8			NN
old_structure_delete_version	int8			NN
new_structure_delete_version	int8			NN
event	char(32)			NN
event_location	char(16)			NN

pg_internal.redshift_auto_health_check_6444622

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_datashare_request_producer

old
column	data type	PK	U	NN
userid	int4			NN
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
xid	int8			NN
backend_start_time	int8			NN
handler_start_time	int8			NN
consumer_region	char(64)			NN
producer_cluster_id	char(50)			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
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
xid	int8			NN
backend_start_time	int8			NN
handler_start_time	int8			NN
consumer_region	char(64)			NN
producer_cluster_id	char(50)			NN
action	char(128)			NN
block_header	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_restarted_sessions_internal

old
column	data type	PK	U	NN
currenttime	int8			NN
is_reforkable	char(10)			NN
temp_tbl_created	char(10)			NN
named_prep_stmt_ct	int4			NN
unnamed_stmt_ct	int4			NN
in_xact_blk	char(10)			NN
is_read_only	char(10)			NN
is_single_stmt_query	char(10)			NN
conn_state	char(100)			NN
pid	int4			NN
in_authentication	char(10)			NN
is_bootstrap	char(10)			NN
is_restarted_session	char(10)			NN
is_extended_protocol	char(10)			NN
is_idle_connection	char(10)			NN
current_executing_command	char(10)			NN
is_ssl_compressed	char(10)			NN
is_protocol_v3	char(10)			NN
are_commands_repeated	char(10)			NN
unsupported_command_sequence	char(10)			NN
can_reissue_query	char(10)			NN
parked_state_in_proxy	char(10)			NN
session_size	int8			NN
is_inc_resize	char(10)			NN
written_state_to_disk	char(10)			NN
auto_resume	char(10)			NN
query_command_sequence	char(32)			NN
is_fas_set	char(10)			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
is_reforkable	char(10)			NN
temp_tbl_created	char(10)			NN
named_prep_stmt_ct	int4			NN
unnamed_stmt_ct	int4			NN
in_xact_blk	char(10)			NN
is_read_only	char(10)			NN
is_single_stmt_query	char(10)			NN
conn_state	char(100)			NN
pid	int4			NN
in_authentication	char(10)			NN
is_bootstrap	char(10)			NN
is_restarted_session	char(10)			NN
is_extended_protocol	char(10)			NN
is_idle_connection	char(10)			NN
current_executing_command	char(10)			NN
is_ssl_compressed	char(10)			NN
is_protocol_v3	char(10)			NN
are_commands_repeated	char(10)			NN
unsupported_command_sequence	char(10)			NN
can_reissue_query	char(10)			NN
parked_state_in_proxy	char(10)			NN
session_size	int8			NN
is_inc_resize	char(10)			NN
written_state_to_disk	char(10)			NN
auto_resume	char(10)			NN
query_command_sequence	char(32)			NN
is_fas_set	char(10)			NN
is_idc_set	char(5)			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_unload_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
event_time	int8			NN
slice	int4			NN
files_count_produced	int4			NN
files_size_produced	int8			NN
rows_produced	int8			NN
file_format	char(32)			NN
compression_type	char(64)			NN
unloaded_location	char(256)			NN
error_message	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

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
event_time	int8			NN
slice	int4			NN
files_count_produced	int4			NN
files_size_produced	int8			NN
rows_produced	int8			NN
file_format	char(32)			NN
compression_type	char(64)			NN
unloaded_location	char(1280)			NN
error_message	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.stll_datashare_request_producer

old
column	data type	PK	U	NN
userid	int4			NN
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	timestamp			NN
endtime	timestamp			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
xid	int8			NN
backend_start_time	timestamp			NN
handler_start_time	timestamp			NN
consumer_region	char(64)			NN
producer_cluster_id	char(50)			NN

new
column	data type	PK	U	NN
userid	int4			NN
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	timestamp			NN
endtime	timestamp			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
xid	int8			NN
backend_start_time	timestamp			NN
handler_start_time	timestamp			NN
consumer_region	char(64)			NN
producer_cluster_id	char(50)			NN
action	char(128)			NN
block_header	int4			NN

pg_catalog.stll_restarted_sessions_internal

old
column	data type	PK	U	NN
currenttime	timestamp			NN
is_reforkable	char(10)			NN
temp_tbl_created	char(10)			NN
named_prep_stmt_ct	int4			NN
unnamed_stmt_ct	int4			NN
in_xact_blk	char(10)			NN
is_read_only	char(10)			NN
is_single_stmt_query	char(10)			NN
conn_state	char(100)			NN
pid	int4			NN
in_authentication	char(10)			NN
is_bootstrap	char(10)			NN
is_restarted_session	char(10)			NN
is_extended_protocol	char(10)			NN
is_idle_connection	char(10)			NN
current_executing_command	char(10)			NN
is_ssl_compressed	char(10)			NN
is_protocol_v3	char(10)			NN
are_commands_repeated	char(10)			NN
unsupported_command_sequence	char(10)			NN
can_reissue_query	char(10)			NN
parked_state_in_proxy	char(10)			NN
session_size	int8			NN
is_inc_resize	char(10)			NN
written_state_to_disk	char(10)			NN
auto_resume	char(10)			NN
query_command_sequence	char(32)			NN
is_fas_set	char(10)			NN

new
column	data type	PK	U	NN
currenttime	timestamp			NN
is_reforkable	char(10)			NN
temp_tbl_created	char(10)			NN
named_prep_stmt_ct	int4			NN
unnamed_stmt_ct	int4			NN
in_xact_blk	char(10)			NN
is_read_only	char(10)			NN
is_single_stmt_query	char(10)			NN
conn_state	char(100)			NN
pid	int4			NN
in_authentication	char(10)			NN
is_bootstrap	char(10)			NN
is_restarted_session	char(10)			NN
is_extended_protocol	char(10)			NN
is_idle_connection	char(10)			NN
current_executing_command	char(10)			NN
is_ssl_compressed	char(10)			NN
is_protocol_v3	char(10)			NN
are_commands_repeated	char(10)			NN
unsupported_command_sequence	char(10)			NN
can_reissue_query	char(10)			NN
parked_state_in_proxy	char(10)			NN
session_size	int8			NN
is_inc_resize	char(10)			NN
written_state_to_disk	char(10)			NN
auto_resume	char(10)			NN
query_command_sequence	char(32)			NN
is_fas_set	char(10)			NN
is_idc_set	char(5)			NN

pg_catalog.stll_unload_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
event_time	timestamp			NN
slice	int4			NN
files_count_produced	int4			NN
files_size_produced	int8			NN
rows_produced	int8			NN
file_format	char(32)			NN
compression_type	char(64)			NN
unloaded_location	char(256)			NN
error_message	char(128)			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
event_time	timestamp			NN
slice	int4			NN
files_count_produced	int4			NN
files_size_produced	int8			NN
rows_produced	int8			NN
file_format	char(32)			NN
compression_type	char(64)			NN
unloaded_location	char(1280)			NN
error_message	char(128)			NN

pg_catalog.stv_inflight_undos

old
column	data type	PK	U	NN
node	int4			NN
table_id	int4			NN
undo_xid	int4			NN
undo_mode	int4			NN

new
column	data type	PK	U	NN
node	int4			NN
table_id	int4			NN
undo_xid	int8			NN
undo_mode	int4			NN

pg_catalog.stv_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
state	char(128)			NN
synced_log_coordinate	char(128)			NN
reason	char(256)			NN
size	int4			NN
last_updated	timestamp			NN
table_id	int4			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
state	char(128)			NN
synced_log_coordinate	char(128)			NN
reason	char(256)			NN
size	int4			NN
last_updated	timestamp			NN
table_id	int4			NN
is_history_mode	char(1)			NN

pg_internal.redshift_auto_health_check_4174785

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_datashare_write_history

old
column	data type

new
column	data type
user_id	int4
user_name	char(128)
vpid	int4
transaction_id	int8
consumer_transaction_uid	char(64)
db_id	int4
db_name	char(128)
object_type	char(64)
object_id	int4
object_name	char(128)
query_type	char(64)
record_time	timestamp
inserted_row_count	int4
deleted_row_count	int4

pg_catalog.stl_table_version_events

old
column	data type

new
column	data type
record_time	timestamp
xid	int8
pid	int8
table_id	int4
old_dml_version	int8
new_dml_version	int8
old_ddl_end_version	int8
new_ddl_end_version	int8
old_ddl_start_version	int8
new_ddl_start_version	int8
old_structure_version	int8
new_structure_version	int8
old_structure_delete_version	int8
new_structure_delete_version	int8
event	char(32)
event_location	char(16)

pg_catalog.sys_datashare_write_history

old
column	data type

new
column	data type
user_id	int4
user_name	varchar(128)
session_id	int4
transaction_id	int8
consumer_transaction_uid	varchar(64)
database_name	varchar(128)
object_type	varchar(64)
object_id	int4
object_name	varchar(128)
query_type	varchar(64)
record_time	timestamp
inserted_rows	int4
deleted_rows	int4

pg_catalog.stl_datashare_request_producer

old
column	data type
userid	int4
pid	int4
requestid	char(50)
sb_version	int8
dbtype	int4
dbid	int4
shareid	int4
sharename	char(128)
api_call	int4
obj_type	int4
obj_oid	int4
obj_name	char(128)
starttime	timestamp
endtime	timestamp
status	int4
message	char(512)
consumeraccountid	char(50)
consumernamespace	char(50)
consumer_transaction_uid	char(50)
is_versioned_request	int4
overridden_snapshot_xmin	int8
xid	int8
backend_start_time	timestamp
handler_start_time	timestamp
consumer_region	char(64)
producer_cluster_id	char(50)

new
column	data type
userid	int4
pid	int4
requestid	char(50)
sb_version	int8
dbtype	int4
dbid	int4
shareid	int4
sharename	char(128)
api_call	int4
obj_type	int4
obj_oid	int4
obj_name	char(128)
starttime	timestamp
endtime	timestamp
status	int4
message	char(512)
consumeraccountid	char(50)
consumernamespace	char(50)
consumer_transaction_uid	char(50)
is_versioned_request	int4
overridden_snapshot_xmin	int8
xid	int8
backend_start_time	timestamp
handler_start_time	timestamp
consumer_region	char(64)
producer_cluster_id	char(50)
action	char(128)
block_header	int4

pg_catalog.stl_restarted_sessions_internal

old
column	data type
currenttime	timestamp
is_reforkable	char(10)
temp_tbl_created	char(10)
named_prep_stmt_ct	int4
unnamed_stmt_ct	int4
in_xact_blk	char(10)
is_read_only	char(10)
is_single_stmt_query	char(10)
conn_state	char(100)
pid	int4
in_authentication	char(10)
is_bootstrap	char(10)
is_restarted_session	char(10)
is_extended_protocol	char(10)
is_idle_connection	char(10)
current_executing_command	char(10)
is_ssl_compressed	char(10)
is_protocol_v3	char(10)
are_commands_repeated	char(10)
unsupported_command_sequence	char(10)
can_reissue_query	char(10)
parked_state_in_proxy	char(10)
session_size	int8
is_inc_resize	char(10)
written_state_to_disk	char(10)
auto_resume	char(10)
query_command_sequence	char(32)
is_fas_set	char(10)

new
column	data type
currenttime	timestamp
is_reforkable	char(10)
temp_tbl_created	char(10)
named_prep_stmt_ct	int4
unnamed_stmt_ct	int4
in_xact_blk	char(10)
is_read_only	char(10)
is_single_stmt_query	char(10)
conn_state	char(100)
pid	int4
in_authentication	char(10)
is_bootstrap	char(10)
is_restarted_session	char(10)
is_extended_protocol	char(10)
is_idle_connection	char(10)
current_executing_command	char(10)
is_ssl_compressed	char(10)
is_protocol_v3	char(10)
are_commands_repeated	char(10)
unsupported_command_sequence	char(10)
can_reissue_query	char(10)
parked_state_in_proxy	char(10)
session_size	int8
is_inc_resize	char(10)
written_state_to_disk	char(10)
auto_resume	char(10)
query_command_sequence	char(32)
is_fas_set	char(10)
is_idc_set	char(5)

pg_catalog.stl_unload_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
event_time	timestamp
slice	int4
files_count_produced	int4
files_size_produced	int8
rows_produced	int8
file_format	char(32)
compression_type	char(64)
unloaded_location	char(256)
error_message	char(128)

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
event_time	timestamp
slice	int4
files_count_produced	int4
files_size_produced	int8
rows_produced	int8
file_format	char(32)
compression_type	char(64)
unloaded_location	char(1280)
error_message	char(128)