Redshift Observatory System Table Tracker

Functions

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

Tables

pg_catalog.pg_permission_mask

old
column	data type	PK	U	NN

new
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

pg_catalog.pg_policy_mask

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_burst_billing_ris_reports

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_bytedict_stats

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_cdc_checkpoints

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_burst_billing_ris_reports

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_bytedict_stats

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_cdc_checkpoints

old
column	data type	PK	U	NN

new
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

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(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

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(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

pg_catalog.stcs_arcadia_billing_ris_reports

old
column	data type	PK	U	NN
request_id	char(100)			NN
billing_time	char(100)			NN
usage_rpu_sec	int4			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
is_burst	int4			NN
cluster_arn	char(128)			NN
usage_sec	int4			NN
usage_sec_before_minimum	int4			NN
cluster_rpus	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
request_id	char(100)			NN
billing_time	char(100)			NN
usage_rpu_sec	int4			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
is_burst	int4			NN
cluster_arn	char(128)			NN
usage_sec	int4			NN
usage_sec_before_minimum	int4			NN
cluster_rpus	int4			NN
report_time	int8			NN
interval_starttime	int8			NN
interval_endtime	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

pg_catalog.stcs_kafka_scan_errors

old
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

new
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

pg_catalog.stcs_kafka_scan_states

old
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

new
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

pg_catalog.stcs_kinesis_scan_errors

old
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

new
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

pg_catalog.stcs_kinesis_scan_states

old
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

new
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

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(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
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

pg_catalog.stcs_small_table_convert_event

old
column	data type	PK	U	NN
xid	int8			NN
query	int8			NN
tbl	int4			NN
rows	int8			NN
start_time	int8			NN
end_time	int8			NN
command	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
xid	int8			NN
query	int8			NN
tbl	int4			NN
rows	int8			NN
start_time	int8			NN
end_time	int8			NN
command	char(128)			NN
distkey_index	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_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(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

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(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

pg_catalog.stcs_superblock

old
column	data type	PK	U	NN
node	int4			NN
record_time	int8			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	int4			NN
sb_tree_root_pos	int4			NN
sb_tree_height	int4			NN
sb_tree_mode	int4			NN
sb_tree_blocks	int4			NN
sb_tree_root_guid	char(36)			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
node	int4			NN
record_time	int8			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	int4			NN
sb_tree_root_pos	int4			NN
sb_tree_height	int4			NN
sb_tree_mode	int4			NN
sb_tree_blocks	int4			NN
sb_tree_root_guid	char(36)			NN
tombstoned_sb_tree_blocks	int4			NN
leader_snapshot_blocks	int4			NN
pg_wal_blocks	int4			NN
logchain_blocks	int4			NN
metachain_blocks	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_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(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
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

pg_catalog.stcs_unique

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
type	char(6)			NN
is_diskbased	char(1)			NN
slots	int4			NN
workmem	int8			NN
max_buffers_used	int8			NN
resizes	int4			NN
occupied	int4			NN
flushable	int4			NN
used_unique_prefetching	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

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
type	char(6)			NN
is_diskbased	char(1)			NN
slots	int4			NN
workmem	int8			NN
max_buffers_used	int8			NN
resizes	int4			NN
occupied	int4			NN
flushable	int4			NN
used_unique_prefetching	char(1)			NN
bytes	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

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(35)			NN
minicore_file	char(1057)			NN
node_id	int4			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(46)			NN
minicore_file	char(1057)			NN
node_id	int4			NN
restart_trace_id	char(64)			NN

pg_catalog.stll_arcadia_billing_ris_reports

old
column	data type	PK	U	NN
request_id	char(100)			NN
billing_time	char(100)			NN
usage_rpu_sec	int4			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
is_burst	int4			NN
cluster_arn	char(128)			NN
usage_sec	int4			NN
usage_sec_before_minimum	int4			NN
cluster_rpus	int4			NN

new
column	data type	PK	U	NN
request_id	char(100)			NN
billing_time	char(100)			NN
usage_rpu_sec	int4			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
is_burst	int4			NN
cluster_arn	char(128)			NN
usage_sec	int4			NN
usage_sec_before_minimum	int4			NN
cluster_rpus	int4			NN
report_time	timestamp			NN
interval_starttime	timestamp			NN
interval_endtime	timestamp			NN

pg_catalog.stll_kafka_scan_errors

old
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

new
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

pg_catalog.stll_kafka_scan_states

old
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

new
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

pg_catalog.stll_kinesis_scan_errors

old
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

new
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

pg_catalog.stll_kinesis_scan_states

old
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

new
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

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(256)			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(512)			NN

pg_catalog.stll_small_table_convert_event

old
column	data type	PK	U	NN
xid	int8			NN
query	int8			NN
tbl	int4			NN
rows	int8			NN
start_time	timestamp			NN
end_time	timestamp			NN
command	char(128)			NN

new
column	data type	PK	U	NN
xid	int8			NN
query	int8			NN
tbl	int4			NN
rows	int8			NN
start_time	timestamp			NN
end_time	timestamp			NN
command	char(128)			NN
distkey_index	int4			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(35)			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(46)			NN
restart_trace_id	char(64)			NN

pg_catalog.stll_superblock

old
column	data type	PK	U	NN
node	int4			NN
record_time	timestamp			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	int4			NN
sb_tree_root_pos	int4			NN
sb_tree_height	int4			NN
sb_tree_mode	int4			NN
sb_tree_blocks	int4			NN
sb_tree_root_guid	char(36)			NN

new
column	data type	PK	U	NN
node	int4			NN
record_time	timestamp			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	int4			NN
sb_tree_root_pos	int4			NN
sb_tree_height	int4			NN
sb_tree_mode	int4			NN
sb_tree_blocks	int4			NN
sb_tree_root_guid	char(36)			NN
tombstoned_sb_tree_blocks	int4			NN
leader_snapshot_blocks	int4			NN
pg_wal_blocks	int4			NN
logchain_blocks	int4			NN
metachain_blocks	int4			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(256)			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(512)			NN

pg_catalog.stll_unique

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
type	char(6)			NN
is_diskbased	char(1)			NN
slots	int4			NN
workmem	int8			NN
max_buffers_used	int8			NN
resizes	int4			NN
occupied	int4			NN
flushable	int4			NN
used_unique_prefetching	char(1)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
type	char(6)			NN
is_diskbased	char(1)			NN
slots	int4			NN
workmem	int8			NN
max_buffers_used	int8			NN
resizes	int4			NN
occupied	int4			NN
flushable	int4			NN
used_unique_prefetching	char(1)			NN
bytes	int8			NN

pg_catalog.stv_superblock

old
column	data type	PK	U	NN
node	int4			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	int4			NN
sb_tree_root_pos	int4			NN
sb_tree_height	int4			NN
sb_tree_mode	int4			NN
sb_tree_blocks	int4			NN
sb_tree_root_guid	char(36)			NN

new
column	data type	PK	U	NN
node	int4			NN
fs_version	int8			NN
sb_version	int8			NN
defrag_version	int8			NN
num_blocks	int4			NN
high_qid	int8			NN
crc	int4			NN
flags	int4			NN
num_uncommitted	int8			NN
active_log	int4			NN
is_extended_superblock	int4			NN
superblock_capacity	int8			NN
perm_blocks	int4			NN
freelist_size	int4			NN
bloat	int4			NN
sb_tree_root_pos	int4			NN
sb_tree_height	int4			NN
sb_tree_mode	int4			NN
sb_tree_blocks	int4			NN
sb_tree_root_guid	char(36)			NN
tombstoned_sb_tree_blocks	int4			NN
leader_snapshot_blocks	int4			NN
pg_wal_blocks	int4			NN
logchain_blocks	int4			NN
metachain_blocks	int4			NN

Views

pg_catalog.stl_burst_billing_ris_reports

old
column	data type

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

pg_catalog.stl_bytedict_stats

old
column	data type

new
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

pg_catalog.stl_cdc_checkpoints

old
column	data type

new
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)

pg_catalog.svv_mv_info

old
column	data type

new
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)

pg_catalog.svv_user_info

old
column	data type

new
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)

pg_catalog.sys_connection_log

old
column	data type

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
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)

pg_catalog.sys_datashare_change_log

old
column	data type

new
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)

pg_catalog.sys_datashare_usage_consumer

old
column	data type

new
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)

pg_catalog.sys_datashare_usage_producer

old
column	data type

new
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)

pg_catalog.sys_stream_scan_errors

old
column	data type

new
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)

pg_catalog.sys_stream_scan_states

old
column	data type

new
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

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(35)
minicore_file	char(1057)
node_id	int4

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(46)
minicore_file	char(1057)
node_id	int4
restart_trace_id	char(64)

pg_catalog.stl_arcadia_billing_ris_reports

old
column	data type
request_id	char(100)
billing_time	char(100)
usage_rpu_sec	int4
report_arn	char(128)
instance_type	char(128)
num_nodes	int4
is_burst	int4
cluster_arn	char(128)
usage_sec	int4
usage_sec_before_minimum	int4
cluster_rpus	int4

new
column	data type
request_id	char(100)
billing_time	char(100)
usage_rpu_sec	int4
report_arn	char(128)
instance_type	char(128)
num_nodes	int4
is_burst	int4
cluster_arn	char(128)
usage_sec	int4
usage_sec_before_minimum	int4
cluster_rpus	int4
report_time	timestamp
interval_starttime	timestamp
interval_endtime	timestamp

pg_catalog.stl_kafka_scan_errors

old
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)

new
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

pg_catalog.stl_kafka_scan_states

old
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)

new
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

pg_catalog.stl_kinesis_scan_errors

old
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)

new
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

pg_catalog.stl_kinesis_scan_states

old
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)

new
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

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(256)

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

pg_catalog.stl_small_table_convert_event

old
column	data type
xid	int8
query	int8
tbl	int4
rows	int8
start_time	timestamp
end_time	timestamp
command	char(128)

new
column	data type
xid	int8
query	int8
tbl	int4
rows	int8
start_time	timestamp
end_time	timestamp
command	char(128)
distkey_index	int4

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(35)

new
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)

pg_catalog.stl_superblock

old
column	data type
node	int4
record_time	timestamp
fs_version	int8
sb_version	int8
defrag_version	int8
num_blocks	int4
high_qid	int8
crc	int4
flags	int4
num_uncommitted	int8
active_log	int4
is_extended_superblock	int4
superblock_capacity	int8
perm_blocks	int4
freelist_size	int4
bloat	int4
sb_tree_root_pos	int4
sb_tree_height	int4
sb_tree_mode	int4
sb_tree_blocks	int4
sb_tree_root_guid	char(36)

new
column	data type
node	int4
record_time	timestamp
fs_version	int8
sb_version	int8
defrag_version	int8
num_blocks	int4
high_qid	int8
crc	int4
flags	int4
num_uncommitted	int8
active_log	int4
is_extended_superblock	int4
superblock_capacity	int8
perm_blocks	int4
freelist_size	int4
bloat	int4
sb_tree_root_pos	int4
sb_tree_height	int4
sb_tree_mode	int4
sb_tree_blocks	int4
sb_tree_root_guid	char(36)
tombstoned_sb_tree_blocks	int4
leader_snapshot_blocks	int4
pg_wal_blocks	int4
logchain_blocks	int4
metachain_blocks	int4

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(256)

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(512)

pg_catalog.stl_unique

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
type	char(6)
is_diskbased	char(1)
slots	int4
workmem	int8
max_buffers_used	int8
resizes	int4
occupied	int4
flushable	int4
used_unique_prefetching	char(1)

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
type	char(6)
is_diskbased	char(1)
slots	int4
workmem	int8
max_buffers_used	int8
resizes	int4
occupied	int4
flushable	int4
used_unique_prefetching	char(1)
bytes	int8

pg_catalog.svv_external_columns

old
column	data type
schemaname	varchar(128)
tablename	varchar(128)
columnname	varchar(128)
external_type	varchar(128)
columnnum	int4
part_key	int4
is_nullable	varchar(128)

new
column	data type
redshift_database_name	varchar(128)
schemaname	varchar(128)
tablename	varchar(128)
columnname	varchar(128)
external_type	varchar(128)
columnnum	int4
part_key	int4
is_nullable	varchar(128)

pg_catalog.svv_external_tables

old
column	data type
schemaname	varchar(128)
tablename	varchar(128)
location	varchar(128)
input_format	varchar(128)
output_format	varchar(128)
serialization_lib	varchar(128)
serde_parameters	varchar(128)
compressed	int4
parameters	varchar(128)
tabletype	varchar(128)

new
column	data type
redshift_database_name	varchar(128)
schemaname	varchar(128)
tablename	varchar(128)
location	varchar(128)
input_format	varchar(128)
output_format	varchar(128)
serialization_lib	varchar(128)
serde_parameters	varchar(128)
compressed	int4
parameters	varchar(128)
tabletype	varchar(128)

pg_catalog.svv_rls_attached_policy

old
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

new
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

pg_catalog.svv_rls_relation

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

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

pg_catalog.sys_serverless_usage

old
column	data type
start_time	timestamp
end_time	timestamp
compute_seconds	float8
compute_capacity	float8
data_storage	int8
cross_region_transferred_data	int8

new
column	data type
start_time	timestamp
end_time	timestamp
compute_seconds	float8
compute_capacity	float8
data_storage	int8
cross_region_transferred_data	int8
charged_seconds	int8

pg_catalog.svl_stream_scan_errors

old
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)

new
column	data type

pg_catalog.svl_stream_scan_states

old
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

new
column	data type