Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
dropped	pg_catalog	internal	volatile	_record	pg_get_all_shared_tables	None

Tables

pg_internal.redshift_auto_health_check_4925410

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_burst_query_execution

old
column	data type	PK	U	NN
action	char(20)			NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
query	int8			NN
backup_id	char(30)			NN
cluster_backup_version	int8			NN
starttime	int8			NN
endtime	int8			NN
cluster_arn	char(128)			NN
max_vis_xid	int8			NN
query_sb_version	int8			NN
num_tuples	int4			NN
fetch_complete	int4			NN
error	char(350)			NN
connection_guid	char(100)			NN
xen_error_code	int4			NN
burst_cluster_id	char(38)			NN
burst_query_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
action	char(20)			NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
query	int8			NN
backup_id	char(30)			NN
cluster_backup_version	int8			NN
starttime	int8			NN
endtime	int8			NN
cluster_arn	char(128)			NN
max_vis_xid	int8			NN
query_sb_version	int8			NN
num_tuples	int4			NN
fetch_complete	int4			NN
error	char(350)			NN
connection_guid	char(100)			NN
xen_error_code	int4			NN
burst_cluster_id	char(38)			NN
burst_query_id	int4			NN
reported_peak_usage_bytes	int8			NN
exec_time_wo_compilation	int8			NN
spectrum_file_count	int4			NN
num_pce_segs	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_burst_query_execution

old
column	data type	PK	U	NN
action	char(20)			NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
query	int8			NN
backup_id	char(30)			NN
cluster_backup_version	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
cluster_arn	char(128)			NN
max_vis_xid	int8			NN
query_sb_version	int8			NN
num_tuples	int4			NN
fetch_complete	int4			NN
error	char(350)			NN
connection_guid	char(100)			NN
xen_error_code	int4			NN
burst_cluster_id	char(38)			NN
burst_query_id	int4			NN

new
column	data type	PK	U	NN
action	char(20)			NN
userid	int4			NN
pid	int8			NN
xid	int8			NN
query	int8			NN
backup_id	char(30)			NN
cluster_backup_version	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
cluster_arn	char(128)			NN
max_vis_xid	int8			NN
query_sb_version	int8			NN
num_tuples	int4			NN
fetch_complete	int4			NN
error	char(350)			NN
connection_guid	char(100)			NN
xen_error_code	int4			NN
burst_cluster_id	char(38)			NN
burst_query_id	int4			NN
reported_peak_usage_bytes	int8			NN
exec_time_wo_compilation	int8			NN
spectrum_file_count	int4			NN
num_pce_segs	int4			NN

pg_catalog.stcs_leader_commit_trace

old
column	data type	PK	U	NN
xid	int8			NN
recordtime	int8			NN
batched_by	int8			NN
sb_version	int4			NN
xen_commit_level	int4			NN
queuelen	int8			NN
dsw_xact	int4			NN
burst_write	int4			NN
step	char(100)			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_local_s3_scan_fallback

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
tbl	char(512)			NN
reason	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_mem_alloc_histograms

old
column	data type	PK	U	NN
now	int8			NN
since	int8			NN
node	int4			NN
mem_type	char(32)			NN
blocks_1m	int8			NN
blocks_2m	int8			NN
blocks_4m	int8			NN
blocks_8m	int8			NN
blocks_16m	int8			NN
blocks_32m	int8			NN
blocks_64m	int8			NN
blocks_128m	int8			NN
blocks_256m	int8			NN
blocks_512m	int8			NN
blocks_1g	int8			NN
blocks_2g	int8			NN
max_blocks_1m	int8			NN
max_blocks_2m	int8			NN
max_blocks_4m	int8			NN
max_blocks_8m	int8			NN
max_blocks_16m	int8			NN
max_blocks_32m	int8			NN
max_blocks_64m	int8			NN
max_blocks_128m	int8			NN
max_blocks_256m	int8			NN
max_blocks_512m	int8			NN
max_blocks_1g	int8			NN
max_blocks_2g	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_perf_sink_histogram

old
column	data type	PK	U	NN
now	int8			NN
name	char(64)			NN
query_id	int4			NN
slice_number	int4			NN
channel_id	int4			NN
mean	float8			NN
stdev	float8			NN
min	float8			NN
max	float8			NN
total	int4			NN
sum	float8			NN
ten_us	int4			NN
hundred_us	int4			NN
one_ms	int4			NN
ten_ms	int4			NN
hundred_ms	int4			NN
one_s	int4			NN
ten_s	int4			NN
inf	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_perf_source_histogram

old
column	data type	PK	U	NN
now	int8			NN
name	char(64)			NN
query_id	int4			NN
slice_number	int4			NN
channel_id	int4			NN
mean	float8			NN
stdev	float8			NN
min	float8			NN
max	float8			NN
total	int4			NN
sum	float8			NN
ten_us	int4			NN
hundred_us	int4			NN
one_ms	int4			NN
ten_ms	int4			NN
hundred_ms	int4			NN
one_s	int4			NN
ten_s	int4			NN
inf	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_pg_function

old
column	data type	PK	U	NN
userid	int4			NN
query	int8			NN
functionid	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_redcat_logging

old
column	data type	PK	U	NN
xid	int8			NN
pid	int4			NN
recordtime	int8			NN
context	char(128)			NN
message	char(2048)			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_startnode_log

old
column	data type	PK	U	NN
message	char(4096)			NN
logtime	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_watchdog

old
column	data type	PK	U	NN
recordtime	int8			NN
pid	int4			NN
vpid	int4			NN
qid	int4			NN
abort_reason	char(32)			NN
stuck_reason	char(32)			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_leader_commit_trace

old
column	data type	PK	U	NN
xid	int8			NN
recordtime	timestamp			NN
batched_by	int8			NN
sb_version	int4			NN
xen_commit_level	int4			NN
queuelen	int8			NN
dsw_xact	int4			NN
burst_write	int4			NN
step	char(100)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_local_s3_scan_fallback

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
tbl	char(512)			NN
reason	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_mem_alloc_histograms

old
column	data type	PK	U	NN
now	timestamp			NN
since	timestamp			NN
node	int4			NN
mem_type	char(32)			NN
blocks_1m	int8			NN
blocks_2m	int8			NN
blocks_4m	int8			NN
blocks_8m	int8			NN
blocks_16m	int8			NN
blocks_32m	int8			NN
blocks_64m	int8			NN
blocks_128m	int8			NN
blocks_256m	int8			NN
blocks_512m	int8			NN
blocks_1g	int8			NN
blocks_2g	int8			NN
max_blocks_1m	int8			NN
max_blocks_2m	int8			NN
max_blocks_4m	int8			NN
max_blocks_8m	int8			NN
max_blocks_16m	int8			NN
max_blocks_32m	int8			NN
max_blocks_64m	int8			NN
max_blocks_128m	int8			NN
max_blocks_256m	int8			NN
max_blocks_512m	int8			NN
max_blocks_1g	int8			NN
max_blocks_2g	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_perf_sink_histogram

old
column	data type	PK	U	NN
now	timestamp			NN
name	char(64)			NN
query_id	int4			NN
slice_number	int4			NN
channel_id	int4			NN
mean	float8			NN
stdev	float8			NN
min	float8			NN
max	float8			NN
total	int4			NN
sum	float8			NN
ten_us	int4			NN
hundred_us	int4			NN
one_ms	int4			NN
ten_ms	int4			NN
hundred_ms	int4			NN
one_s	int4			NN
ten_s	int4			NN
inf	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_perf_source_histogram

old
column	data type	PK	U	NN
now	timestamp			NN
name	char(64)			NN
query_id	int4			NN
slice_number	int4			NN
channel_id	int4			NN
mean	float8			NN
stdev	float8			NN
min	float8			NN
max	float8			NN
total	int4			NN
sum	float8			NN
ten_us	int4			NN
hundred_us	int4			NN
one_ms	int4			NN
ten_ms	int4			NN
hundred_ms	int4			NN
one_s	int4			NN
ten_s	int4			NN
inf	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_pg_function

old
column	data type	PK	U	NN
userid	int4			NN
query	int8			NN
functionid	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_redcat_logging

old
column	data type	PK	U	NN
xid	int8			NN
pid	int4			NN
recordtime	timestamp			NN
context	char(128)			NN
message	char(2048)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_startnode_log

old
column	data type	PK	U	NN
message	char(4096)			NN
logtime	timestamp			NN

new
column	data type	PK	U	NN

pg_catalog.stll_watchdog

old
column	data type	PK	U	NN
recordtime	timestamp			NN
pid	int4			NN
vpid	int4			NN
qid	int4			NN
abort_reason	char(32)			NN
stuck_reason	char(32)			NN

new
column	data type	PK	U	NN

pg_catalog.stv_iceberg_metadata_cache

old
column	data type	PK	U	NN
cache_key	char(320)			NN
cache_entry_size_bytes	int8			NN
s3_storage_size_bytes	int8			NN
hit_count	int8			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_7092458

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_burst_query_execution

old
column	data type
action	char(20)
userid	int4
pid	int8
xid	int8
query	int8
backup_id	char(30)
cluster_backup_version	int8
starttime	timestamp
endtime	timestamp
cluster_arn	char(128)
max_vis_xid	int8
query_sb_version	int8
num_tuples	int4
fetch_complete	int4
error	char(350)
connection_guid	char(100)
xen_error_code	int4
burst_cluster_id	char(38)
burst_query_id	int4

new
column	data type
action	char(20)
userid	int4
pid	int8
xid	int8
query	int8
backup_id	char(30)
cluster_backup_version	int8
starttime	timestamp
endtime	timestamp
cluster_arn	char(128)
max_vis_xid	int8
query_sb_version	int8
num_tuples	int4
fetch_complete	int4
error	char(350)
connection_guid	char(100)
xen_error_code	int4
burst_cluster_id	char(38)
burst_query_id	int4
reported_peak_usage_bytes	int8
exec_time_wo_compilation	int8
spectrum_file_count	int4
num_pce_segs	int4

pg_catalog.stl_leader_commit_trace

old
column	data type
xid	int8
recordtime	timestamp
batched_by	int8
sb_version	int4
xen_commit_level	int4
queuelen	int8
dsw_xact	int4
burst_write	int4
step	char(100)

new
column	data type

pg_catalog.stl_local_s3_scan_fallback

old
column	data type
userid	int4
query	int4
tbl	char(512)
reason	int8

new
column	data type

pg_catalog.stl_mem_alloc_histograms

old
column	data type
now	timestamp
since	timestamp
node	int4
mem_type	char(32)
blocks_1m	int8
blocks_2m	int8
blocks_4m	int8
blocks_8m	int8
blocks_16m	int8
blocks_32m	int8
blocks_64m	int8
blocks_128m	int8
blocks_256m	int8
blocks_512m	int8
blocks_1g	int8
blocks_2g	int8
max_blocks_1m	int8
max_blocks_2m	int8
max_blocks_4m	int8
max_blocks_8m	int8
max_blocks_16m	int8
max_blocks_32m	int8
max_blocks_64m	int8
max_blocks_128m	int8
max_blocks_256m	int8
max_blocks_512m	int8
max_blocks_1g	int8
max_blocks_2g	int8

new
column	data type

pg_catalog.stl_perf_sink_histogram

old
column	data type
now	timestamp
name	char(64)
query_id	int4
slice_number	int4
channel_id	int4
mean	float8
stdev	float8
min	float8
max	float8
total	int4
sum	float8
ten_us	int4
hundred_us	int4
one_ms	int4
ten_ms	int4
hundred_ms	int4
one_s	int4
ten_s	int4
inf	int4

new
column	data type

pg_catalog.stl_perf_source_histogram

old
column	data type
now	timestamp
name	char(64)
query_id	int4
slice_number	int4
channel_id	int4
mean	float8
stdev	float8
min	float8
max	float8
total	int4
sum	float8
ten_us	int4
hundred_us	int4
one_ms	int4
ten_ms	int4
hundred_ms	int4
one_s	int4
ten_s	int4
inf	int4

new
column	data type

pg_catalog.stl_pg_function

old
column	data type
userid	int4
query	int8
functionid	int4

new
column	data type

pg_catalog.stl_redcat_logging

old
column	data type
xid	int8
pid	int4
recordtime	timestamp
context	char(128)
message	char(2048)

new
column	data type

pg_catalog.stl_startnode_log

old
column	data type
message	char(4096)
logtime	timestamp

new
column	data type

pg_catalog.stl_watchdog

old
column	data type
recordtime	timestamp
pid	int4
vpid	int4
qid	int4
abort_reason	char(32)
stuck_reason	char(32)

new
column	data type