Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
dropped	pg_catalog	internal	immutable	geometry	st_geomfromgeohash	cstring
dropped	pg_catalog	internal	immutable	geometry	st_geomfromgeohash	cstring,int4
dropped	pg_catalog	internal	immutable	geometry	st_geomfromgeohash	text
dropped	pg_catalog	internal	immutable	geometry	st_geomfromgeohash	text,int4
dropped	pg_catalog	internal	volatile	_record	pg_get_external_database_columns	None
dropped	pg_catalog	internal	volatile	_record	pg_get_external_database_tables	None

Tables

pg_catalog.stcs_alert_messages

old
column	data type	PK	U	NN
eventtime	int8			NN
pid	int4			NN
error	char(512)			NN
code	int4			NN
context	char(512)			NN
query	int4			NN
file	char(512)			NN
linenumber	int4			NN
process	char(64)			NN
padb	char(32)			NN
tracefile	char(512)			NN
critical	int4			NN
exceptionid	int4			NN
unique_exception_identifier	char(46)			NN
minicore_file	char(1057)			NN
node_id	int4			NN
restart_trace_id	char(64)			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
eventtime	int8			NN
pid	int4			NN
error	char(512)			NN
code	int4			NN
context	char(512)			NN
query	int4			NN
file	char(512)			NN
linenumber	int4			NN
process	char(64)			NN
padb	char(32)			NN
tracefile	char(512)			NN
critical	int4			NN
exceptionid	int4			NN
unique_exception_identifier	char(35)			NN
minicore_file	char(1057)			NN
node_id	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_kafka_scan_errors

old
column	data type	PK	U	NN
query	int8			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
timestamp_type	char(1)			NN
kafka_timestamp	int8			NN
record_time	int8			NN
schema_name	char(128)			NN
topic_name	char(255)			NN
partition_id	int8			NN
record_offset	int8			NN
err_code	int4			NN
err_reason	char(128)			NN
raw_data	char(1024)			NN
mv_name	char(128)			NN
transaction_id	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
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
timestamp_type	char(1)			NN
kafka_timestamp	int8			NN
record_time	int8			NN
schema_name	char(128)			NN
topic_name	char(255)			NN
partition_id	int8			NN
record_offset	int8			NN
err_code	int4			NN
err_reason	char(128)			NN
raw_data	char(1024)			NN
mv_name	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_kafka_scan_states

old
column	data type	PK	U	NN
query	int8			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	int8			NN
schema_name	char(128)			NN
topic_name	char(255)			NN
partition_id	int8			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_offset	int8			NN
min_arrival_time	int8			NN
max_arrival_time	int8			NN
mv_name	char(128)			NN
transaction_id	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
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	int8			NN
schema_name	char(128)			NN
topic_name	char(255)			NN
partition_id	int8			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_offset	int8			NN
min_arrival_time	int8			NN
max_arrival_time	int8			NN
mv_name	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_kinesis_scan_errors

old
column	data type	PK	U	NN
query	int8			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
arrival_time	int8			NN
record_time	int8			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
seq_num	char(128)			NN
err_code	int4			NN
err_reason	char(128)			NN
raw_data	char(1024)			NN
mv_name	char(128)			NN
timestamp_type	char(1)			NN
transaction_id	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
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
arrival_time	int8			NN
record_time	int8			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
seq_num	char(128)			NN
err_code	int4			NN
err_reason	char(128)			NN
raw_data	char(1024)			NN
mv_name	char(128)			NN
timestamp_type	char(1)			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_kinesis_scan_states

old
column	data type	PK	U	NN
query	int8			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	int8			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_seq_num	char(128)			NN
millis_behind_latest	int8			NN
worker_bytes	int8			NN
queue_bytes	int8			NN
scheduling_period	int8			NN
request_duration	int8			NN
tardiness	int8			NN
min_arrival_time	int8			NN
max_arrival_time	int8			NN
mv_name	char(128)			NN
transaction_id	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
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	int8			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_seq_num	char(128)			NN
millis_behind_latest	int8			NN
worker_bytes	int8			NN
queue_bytes	int8			NN
scheduling_period	int8			NN
request_duration	int8			NN
tardiness	int8			NN
min_arrival_time	int8			NN
max_arrival_time	int8			NN
mv_name	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_lbc_events

old
column	data type	PK	U	NN
timestamp	int8			NN
xid	int8			NN
process	char(32)			NN
pid	int4			NN
node	int4			NN
is_error	int4			NN
context	char(32)			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
timestamp	int8			NN
xid	int8			NN
process	char(32)			NN
pid	int4			NN
node	int4			NN
is_error	int4			NN
context	char(32)			NN
message	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

pg_catalog.stcs_stack_traces

old
column	data type	PK	U	NN
pid	int4			NN
exceptionid	int4			NN
frame	int4			NN
address	char(20)			NN
instruction	char(100)			NN
filename	char(1024)			NN
unique_exception_identifier	char(46)			NN
restart_trace_id	char(64)			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
pid	int4			NN
exceptionid	int4			NN
frame	int4			NN
address	char(20)			NN
instruction	char(100)			NN
filename	char(1024)			NN
unique_exception_identifier	char(35)			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_superblock_tree_events

old
column	data type	PK	U	NN
eventtime	int8			NN
xid	int8			NN
process	char(32)			NN
pid	int4			NN
node	int4			NN
is_error	int4			NN
filename	char(80)			NN
linenum	int4			NN
context	char(48)			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
eventtime	int8			NN
xid	int8			NN
process	char(32)			NN
pid	int4			NN
node	int4			NN
is_error	int4			NN
filename	char(80)			NN
linenum	int4			NN
context	char(48)			NN
message	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

pg_catalog.stll_alert_messages

old
column	data type	PK	U	NN
eventtime	timestamp			NN
pid	int4			NN
error	char(512)			NN
code	int4			NN
context	char(512)			NN
query	int4			NN
file	char(512)			NN
linenumber	int4			NN
process	char(64)			NN
padb	char(32)			NN
tracefile	char(512)			NN
critical	int4			NN
exceptionid	int4			NN
unique_exception_identifier	char(46)			NN
minicore_file	char(1057)			NN
node_id	int4			NN
restart_trace_id	char(64)			NN

new
column	data type	PK	U	NN
eventtime	timestamp			NN
pid	int4			NN
error	char(512)			NN
code	int4			NN
context	char(512)			NN
query	int4			NN
file	char(512)			NN
linenumber	int4			NN
process	char(64)			NN
padb	char(32)			NN
tracefile	char(512)			NN
critical	int4			NN
exceptionid	int4			NN
unique_exception_identifier	char(35)			NN
minicore_file	char(1057)			NN
node_id	int4			NN

pg_catalog.stll_kafka_scan_errors

old
column	data type	PK	U	NN
query	int8			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
timestamp_type	char(1)			NN
kafka_timestamp	timestamp			NN
record_time	timestamp			NN
schema_name	char(128)			NN
topic_name	char(255)			NN
partition_id	int8			NN
record_offset	int8			NN
err_code	int4			NN
err_reason	char(128)			NN
raw_data	char(1024)			NN
mv_name	char(128)			NN
transaction_id	int8			NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
timestamp_type	char(1)			NN
kafka_timestamp	timestamp			NN
record_time	timestamp			NN
schema_name	char(128)			NN
topic_name	char(255)			NN
partition_id	int8			NN
record_offset	int8			NN
err_code	int4			NN
err_reason	char(128)			NN
raw_data	char(1024)			NN
mv_name	char(128)			NN

pg_catalog.stll_kafka_scan_states

old
column	data type	PK	U	NN
query	int8			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	timestamp			NN
schema_name	char(128)			NN
topic_name	char(255)			NN
partition_id	int8			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_offset	int8			NN
min_arrival_time	timestamp			NN
max_arrival_time	timestamp			NN
mv_name	char(128)			NN
transaction_id	int8			NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	timestamp			NN
schema_name	char(128)			NN
topic_name	char(255)			NN
partition_id	int8			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_offset	int8			NN
min_arrival_time	timestamp			NN
max_arrival_time	timestamp			NN
mv_name	char(128)			NN

pg_catalog.stll_kinesis_scan_errors

old
column	data type	PK	U	NN
query	int8			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
arrival_time	timestamp			NN
record_time	timestamp			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
seq_num	char(128)			NN
err_code	int4			NN
err_reason	char(128)			NN
raw_data	char(1024)			NN
mv_name	char(128)			NN
timestamp_type	char(1)			NN
transaction_id	int8			NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
arrival_time	timestamp			NN
record_time	timestamp			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
seq_num	char(128)			NN
err_code	int4			NN
err_reason	char(128)			NN
raw_data	char(1024)			NN
mv_name	char(128)			NN
timestamp_type	char(1)			NN

pg_catalog.stll_kinesis_scan_states

old
column	data type	PK	U	NN
query	int8			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	timestamp			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_seq_num	char(128)			NN
millis_behind_latest	int8			NN
worker_bytes	int8			NN
queue_bytes	int8			NN
scheduling_period	int8			NN
request_duration	int8			NN
tardiness	int8			NN
min_arrival_time	timestamp			NN
max_arrival_time	timestamp			NN
mv_name	char(128)			NN
transaction_id	int8			NN

new
column	data type	PK	U	NN
query	int4			NN
node	int4			NN
slice	int4			NN
segment	int4			NN
pid	int4			NN
record_time	timestamp			NN
schema_name	char(128)			NN
stream_name	char(128)			NN
shard_id	char(128)			NN
num_records	int8			NN
num_skipped_records	int8			NN
num_bytes	int8			NN
latest_seq_num	char(128)			NN
millis_behind_latest	int8			NN
worker_bytes	int8			NN
queue_bytes	int8			NN
scheduling_period	int8			NN
request_duration	int8			NN
tardiness	int8			NN
min_arrival_time	timestamp			NN
max_arrival_time	timestamp			NN
mv_name	char(128)			NN

pg_catalog.stll_lbc_events

old
column	data type	PK	U	NN
timestamp	timestamp			NN
xid	int8			NN
process	char(32)			NN
pid	int4			NN
node	int4			NN
is_error	int4			NN
context	char(32)			NN
message	char(512)			NN

new
column	data type	PK	U	NN
timestamp	timestamp			NN
xid	int8			NN
process	char(32)			NN
pid	int4			NN
node	int4			NN
is_error	int4			NN
context	char(32)			NN
message	char(256)			NN

pg_catalog.stll_stack_traces

old
column	data type	PK	U	NN
pid	int4			NN
exceptionid	int4			NN
frame	int4			NN
address	char(20)			NN
instruction	char(100)			NN
filename	char(1024)			NN
unique_exception_identifier	char(46)			NN
restart_trace_id	char(64)			NN

new
column	data type	PK	U	NN
pid	int4			NN
exceptionid	int4			NN
frame	int4			NN
address	char(20)			NN
instruction	char(100)			NN
filename	char(1024)			NN
unique_exception_identifier	char(35)			NN

pg_catalog.stll_superblock_tree_events

old
column	data type	PK	U	NN
eventtime	timestamp			NN
xid	int8			NN
process	char(32)			NN
pid	int4			NN
node	int4			NN
is_error	int4			NN
filename	char(80)			NN
linenum	int4			NN
context	char(48)			NN
message	char(512)			NN

new
column	data type	PK	U	NN
eventtime	timestamp			NN
xid	int8			NN
process	char(32)			NN
pid	int4			NN
node	int4			NN
is_error	int4			NN
filename	char(80)			NN
linenum	int4			NN
context	char(48)			NN
message	char(256)			NN

pg_catalog.pg_permission_mask

old
column	data type	PK	U	NN
permid	oid			NN
polid	oid			NN
relid	oid			NN
polpriority	int4			NN
polmodifiedby	int4			NN
polmodifiedtime	timestamp			NN
polattrsin	text
polattrsout	text

new
column	data type	PK	U	NN

pg_catalog.pg_policy_mask

old
column	data type	PK	U	NN
polid	oid			NN
poldbid	oid			NN
polname	name			NN
polmodifiedby	int4			NN
polmodifiedtime	timestamp			NN
polattrs	text
polexpr	text
polaux	text

new
column	data type	PK	U	NN

pg_catalog.stcs_burst_billing_ris_reports

old
column	data type	PK	U	NN
request_id	char(100)			NN
billing_time	char(100)			NN
usage_sec	int4			NN
cluster_arn	char(128)			NN
log_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.stcs_bytedict_stats

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
slice	int4			NN
table_id	int4			NN
column_id	int4			NN
is_apply	char(1)			NN
num_blocks	int8			NN
avg_dict_size	float8			NN
num_values	int8			NN
num_exceptions	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_cdc_checkpoints

old
column	data type	PK	U	NN
recordtime	int8			NN
connection_id	char(128)			NN
db_name	char(128)			NN
s3_path	char(512)			NN
checkpoint	char(128)			NN
type	char(16)			NN
num_tables_modified	int4			NN
status	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

pg_catalog.stll_burst_billing_ris_reports

old
column	data type	PK	U	NN
request_id	char(100)			NN
billing_time	char(100)			NN
usage_sec	int4			NN
cluster_arn	char(128)			NN
log_time	timestamp			NN

new
column	data type	PK	U	NN

pg_catalog.stll_bytedict_stats

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
slice	int4			NN
table_id	int4			NN
column_id	int4			NN
is_apply	char(1)			NN
num_blocks	int8			NN
avg_dict_size	float8			NN
num_values	int8			NN
num_exceptions	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_cdc_checkpoints

old
column	data type	PK	U	NN
recordtime	timestamp			NN
connection_id	char(128)			NN
db_name	char(128)			NN
s3_path	char(512)			NN
checkpoint	char(128)			NN
type	char(16)			NN
num_tables_modified	int4			NN
status	char(16)			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_1847762

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

old
column	data type

new
column	data type
query	int4
pid	int4
timestamp_type	char(1)
stream_timestamp	timestamp
record_time	timestamp
mv_name	char(128)
schema_name	char(128)
stream_name	char(255)
partition_id	char(128)
position	char(128)
err_code	int4
err_reason	char(128)
raw_data	char(1024)

pg_catalog.svl_stream_scan_states

old
column	data type

new
column	data type
query	int4
pid	int4
record_time	timestamp
mv_name	char(128)
schema_name	char(128)
stream_name	char(255)
partition_id	char(128)
latest_position	char(128)
num_records	int8
num_skipped_records	int8
num_bytes	int8
min_arrival_time	timestamp
max_arrival_time	timestamp

pg_catalog.stl_alert_messages

old
column	data type
eventtime	timestamp
pid	int4
error	char(512)
code	int4
context	char(512)
query	int4
file	char(512)
linenumber	int4
process	char(64)
padb	char(32)
tracefile	char(512)
critical	int4
exceptionid	int4
unique_exception_identifier	char(46)
minicore_file	char(1057)
node_id	int4
restart_trace_id	char(64)

new
column	data type
eventtime	timestamp
pid	int4
error	char(512)
code	int4
context	char(512)
query	int4
file	char(512)
linenumber	int4
process	char(64)
padb	char(32)
tracefile	char(512)
critical	int4
exceptionid	int4
unique_exception_identifier	char(35)
minicore_file	char(1057)
node_id	int4

pg_catalog.stl_kafka_scan_errors

old
column	data type
query	int8
node	int4
slice	int4
segment	int4
pid	int4
timestamp_type	char(1)
kafka_timestamp	timestamp
record_time	timestamp
schema_name	char(128)
topic_name	char(255)
partition_id	int8
record_offset	int8
err_code	int4
err_reason	char(128)
raw_data	char(1024)
mv_name	char(128)
transaction_id	int8

new
column	data type
query	int4
node	int4
slice	int4
segment	int4
pid	int4
timestamp_type	char(1)
kafka_timestamp	timestamp
record_time	timestamp
schema_name	char(128)
topic_name	char(255)
partition_id	int8
record_offset	int8
err_code	int4
err_reason	char(128)
raw_data	char(1024)
mv_name	char(128)

pg_catalog.stl_kafka_scan_states

old
column	data type
query	int8
node	int4
slice	int4
segment	int4
pid	int4
record_time	timestamp
schema_name	char(128)
topic_name	char(255)
partition_id	int8
num_records	int8
num_skipped_records	int8
num_bytes	int8
latest_offset	int8
min_arrival_time	timestamp
max_arrival_time	timestamp
mv_name	char(128)
transaction_id	int8

new
column	data type
query	int4
node	int4
slice	int4
segment	int4
pid	int4
record_time	timestamp
schema_name	char(128)
topic_name	char(255)
partition_id	int8
num_records	int8
num_skipped_records	int8
num_bytes	int8
latest_offset	int8
min_arrival_time	timestamp
max_arrival_time	timestamp
mv_name	char(128)

pg_catalog.stl_kinesis_scan_errors

old
column	data type
query	int8
node	int4
slice	int4
segment	int4
pid	int4
arrival_time	timestamp
record_time	timestamp
schema_name	char(128)
stream_name	char(128)
shard_id	char(128)
seq_num	char(128)
err_code	int4
err_reason	char(128)
raw_data	char(1024)
mv_name	char(128)
timestamp_type	char(1)
transaction_id	int8

new
column	data type
query	int4
node	int4
slice	int4
segment	int4
pid	int4
arrival_time	timestamp
record_time	timestamp
schema_name	char(128)
stream_name	char(128)
shard_id	char(128)
seq_num	char(128)
err_code	int4
err_reason	char(128)
raw_data	char(1024)
mv_name	char(128)
timestamp_type	char(1)

pg_catalog.stl_kinesis_scan_states

old
column	data type
query	int8
node	int4
slice	int4
segment	int4
pid	int4
record_time	timestamp
schema_name	char(128)
stream_name	char(128)
shard_id	char(128)
num_records	int8
num_skipped_records	int8
num_bytes	int8
latest_seq_num	char(128)
millis_behind_latest	int8
worker_bytes	int8
queue_bytes	int8
scheduling_period	int8
request_duration	int8
tardiness	int8
min_arrival_time	timestamp
max_arrival_time	timestamp
mv_name	char(128)
transaction_id	int8

new
column	data type
query	int4
node	int4
slice	int4
segment	int4
pid	int4
record_time	timestamp
schema_name	char(128)
stream_name	char(128)
shard_id	char(128)
num_records	int8
num_skipped_records	int8
num_bytes	int8
latest_seq_num	char(128)
millis_behind_latest	int8
worker_bytes	int8
queue_bytes	int8
scheduling_period	int8
request_duration	int8
tardiness	int8
min_arrival_time	timestamp
max_arrival_time	timestamp
mv_name	char(128)

pg_catalog.stl_lbc_events

old
column	data type
timestamp	timestamp
xid	int8
process	char(32)
pid	int4
node	int4
is_error	int4
context	char(32)
message	char(512)

new
column	data type
timestamp	timestamp
xid	int8
process	char(32)
pid	int4
node	int4
is_error	int4
context	char(32)
message	char(256)

pg_catalog.stl_stack_traces

old
column	data type
pid	int4
exceptionid	int4
frame	int4
address	char(20)
instruction	char(100)
filename	char(1024)
unique_exception_identifier	char(46)
restart_trace_id	char(64)

new
column	data type
pid	int4
exceptionid	int4
frame	int4
address	char(20)
instruction	char(100)
filename	char(1024)
unique_exception_identifier	char(35)

pg_catalog.stl_superblock_tree_events

old
column	data type
eventtime	timestamp
xid	int8
process	char(32)
pid	int4
node	int4
is_error	int4
filename	char(80)
linenum	int4
context	char(48)
message	char(512)

new
column	data type
eventtime	timestamp
xid	int8
process	char(32)
pid	int4
node	int4
is_error	int4
filename	char(80)
linenum	int4
context	char(48)
message	char(256)

pg_catalog.svv_rls_attached_policy

old
column	data type
relschema	varchar(128)
relname	varchar(128)
relkind	varchar(17)
polname	varchar(128)
grantor	varchar(128)
grantee	varchar(128)
granteekind	varchar(6)
is_pol_on	bool
is_rls_on	bool

new
column	data type
relschema	varchar(128)
relname	varchar(128)
relkind	varchar(7)
polname	varchar(128)
grantor	varchar(128)
grantee	varchar(128)
granteekind	varchar(6)
is_pol_on	bool
is_rls_on	bool

pg_catalog.svv_rls_relation

old
column	data type
datname	varchar(128)
relschema	varchar(128)
relname	varchar(128)
relkind	varchar(17)
is_rls_on	char(1)

new
column	data type
datname	varchar(128)
relschema	varchar(128)
relname	varchar(128)
relkind	varchar(7)
is_rls_on	char(1)

pg_catalog.stl_burst_billing_ris_reports

old
column	data type
request_id	char(100)
billing_time	char(100)
usage_sec	int4
cluster_arn	char(128)
log_time	timestamp

new
column	data type

pg_catalog.stl_bytedict_stats

old
column	data type
query	int4
segment	int4
step	int4
slice	int4
table_id	int4
column_id	int4
is_apply	char(1)
num_blocks	int8
avg_dict_size	float8
num_values	int8
num_exceptions	int8

new
column	data type

pg_catalog.stl_cdc_checkpoints

old
column	data type
recordtime	timestamp
connection_id	char(128)
db_name	char(128)
s3_path	char(512)
checkpoint	char(128)
type	char(16)
num_tables_modified	int4
status	char(16)

new
column	data type

pg_catalog.svv_mv_info

old
column	data type
database_name	char(128)
schema_name	char(128)
user_name	char(128)
name	char(128)
is_stale	char(1)
state	int4
autorewrite	char(1)
autorefresh	char(1)

new
column	data type

pg_catalog.svv_user_info

old
column	data type
user_name	varchar(128)
user_id	int4
createdb	bool
superuser	bool
catalog_update	bool
connection_limit	varchar(256)
syslog_access	varchar(256)
session_timeout	int4
last_ddl_timestamp	timestamp
external_user_id	varchar(128)

new
column	data type

pg_catalog.sys_connection_log

old
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
sslversion	char(50)
ssl_cipher	char(128)
mtu	int4
sslcompression	char(64)
sslexpansion	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
glodbal_session_id	char(36)

new
column	data type

pg_catalog.sys_datashare_change_log

old
column	data type
user_id	int4
user_name	varchar(128)
session_id	int4
transaction_id	int8
share_id	int4
share_name	varchar(128)
source_database_id	int4
source_database_name	varchar(128)
consumer_database_id	int4
consumer_database_name	varchar(128)
record_time	timestamp
action	varchar(128)
status	int4
share_object_type	varchar(64)
share_object_id	int4
share_object_name	varchar(128)
target_user_type	varchar(16)
target_user_id	int4
target_user_name	varchar(128)
consumer_account	varchar(16)
consumer_namespace	varchar(64)
producer_account	varchar(16)
producer_namespace	varchar(64)
attribute_name	varchar(64)
attribute_value	varchar(128)
message	varchar(512)

new
column	data type

pg_catalog.sys_datashare_usage_consumer

old
column	data type
user_id	int4
session_id	int4
transaction_id	int8
request_id	varchar(50)
request_type	varchar(25)
transaction_uid	varchar(50)
record_time	timestamp
status	int4
error	varchar(512)

new
column	data type

pg_catalog.sys_datashare_usage_producer

old
column	data type
share_id	int4
share_name	varchar(128)
request_id	varchar(50)
request_type	varchar(25)
object_type	varchar(64)
object_oid	int4
object_name	varchar(128)
consumer_account	varchar(16)
consumer_namespace	varchar(64)
consumer_transaction_uid	varchar(50)
record_time	timestamp
status	int4
error	varchar(512)

new
column	data type

pg_catalog.sys_stream_scan_errors

old
column	data type
external_schema_name	char(128)
stream_name	char(255)
mv_name	char(128)
transaction_id	int8
query_id	int8
stream_timestamp_type	char(1)
stream_timestamp	timestamp
record_time	timestamp
partition_id	char(128)
position	char(128)
error_code	int4
error_reason	char(128)

new
column	data type

pg_catalog.sys_stream_scan_states

old
column	data type
external_schema_name	char(128)
stream_name	char(255)
mv_name	char(128)
transaction_id	int8
query_id	int8
record_time	timestamp
partition_id	char(128)
latest_position	char(128)
scanned_rows	int8
skipped_rows	int8
scanned_bytes	int8
stream_record_time_min	timestamp
stream_record_time_max	timestamp

new
column	data type