Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
dropped	pg_catalog	internal	stable	bool	has_copy_job_privilege	name,oid

Tables

pg_catalog.stv_resource_forecaster_status

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
enabled	char(1)			NN
leader_collector_startup_finished	char(1)			NN
bucketizer_startup_finished	char(1)			NN
last_baseline	int4			NN
model	int4			NN
total_sample_count	int4			NN
sample_cutoff_time_milliseconds	int4			NN
open_bucket_builders_count	int4			NN
leader_metrics_history_size	int4			NN
chunk_count	int4			NN
persisted_bytes	int4			NN

pg_internal.redshift_auto_health_check_61704509

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_cqi_metrics

old
column	data type	PK	U	NN
pid	int4			NN
starttime	int8			NN
endtime	int8			NN
component_name	char(48)			NN
phase	char(48)			NN
restart_id	char(64)			NN
message	char(4096)			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
starttime	int8			NN
endtime	int8			NN
component_name	char(48)			NN
phase	char(48)			NN
restart_id	char(64)			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.stll_cqi_metrics

old
column	data type	PK	U	NN
pid	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
component_name	char(48)			NN
phase	char(48)			NN
restart_id	char(64)			NN
message	char(4096)			NN

new
column	data type	PK	U	NN
pid	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
component_name	char(48)			NN
phase	char(48)			NN
restart_id	char(64)			NN
message	char(512)			NN

pg_catalog.pg_auto_copy_watermark

old
column	data type	PK	U	NN
job_id	oid			NN
type	char(1)			NN
generation	int4			NN
xid	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stcs_catalog_aggregate_bufmgr_stats

old
column	data type	PK	U	NN
period_start	int8			NN
log_time	int8			NN
read_buffer_cache_hits	int8			NN
read_buffer_cache_misses	int8			NN
get_buffer_in_free_list	int8			NN
get_buffer_evictions	int8			NN
clean_evictions	int8			NN
dirty_evictions	int8			NN
contention_on_eviction	int8			NN
microseconds_flushing_dirty_buffers_during_allocation	int8			NN
microseconds_flushing_dirty_buffers	int8			NN
pin_buffer_calls	int8			NN
unpin_buffer_calls	int8			NN
invalidate_buffer	int8			NN
freelist_size_end_of_interval	int8			NN
recency_cache_size_end_of_interval	int8			NN
frequency_cache_size_end_of_interval	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_compile_errors

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
recordtime	int8			NN
query	int4			NN
segment	int4			NN
sequence	int4			NN
message	char(255)			NN
loc	char(255)			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_ddltext_redacted

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
label	char(320)			NN
starttime	int8			NN
endtime	int8			NN
sequence	int4			NN
text_redacted	char(200)			NN
access_control	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_doryc_container_stats

old
column	data type	PK	U	NN
eventtime	int8			NN
node	int4			NN
container_name	char(32)			NN
container_id	char(32)			NN
cpu_usage_percentage	float8			NN
memory_usage_percentage	float8			NN
memory_usage	char(16)			NN
pid_count	int4			NN
net_io	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.stcs_explain_redacted

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
nodeid	int4			NN
parentid	int4			NN
plannode	char(400)			NN
info_redacted	char(400)			NN
access_control	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_external_query_detail_base_redacted

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
pid	int4			NN
xid	int8			NN
segment_id	int4			NN
node	int4			NN
slice	int4			NN
table_name	char(256)			NN
sourcetype	char(32)			NN
eventtime	int8			NN
starttime	int8			NN
endtime	int8			NN
duration	int8			NN
total_partitions	int4			NN
qualified_partitions	int4			NN
total_files	int4			NN
files_scanned	int4			NN
num_rows	int8			NN
num_bytes	int8			NN
file_format	char(16)			NN
location	char(256)			NN
pg_query_text_redacted	char(4000)			NN
logging_tag	char(32)			NN
warning_message	char(4000)			NN
is_recursive	char(1)			NN
is_nested	char(1)			NN
s3list_time	int8			NN
get_partition_time	int8			NN
access_control	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_federated_query_redacted

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
sourcetype	char(30)			NN
database	char(30)			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
recordtime	int8			NN
querytext_redacted	char(4000)			NN
num_rows	int8			NN
num_bytes	int8			NN
duration	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_query_redacted

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database	char(32)			NN
querytxt_redacted	char(4000)			NN
starttime	int8			NN
endtime	int8			NN
aborted	int4			NN
insert_pristine	int4			NN
concurrency_scaling_status	int4			NN
access_control	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_querytext_redacted

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
sequence	int4			NN
text_redacted	char(200)			NN
access_control	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_sage_mode_simulation_queries

old
column	data type	PK	U	NN
simulation_id	char(36)			NN
trace_id	int4			NN
query_id	int4			NN
arrival_time	int8			NN
burstable	int4			NN
exec_start_time	int8			NN
ssid	int4			NN
cluster_size	int4			NN
est_execution_time_ms	float8			NN
est_queue_time_ms	float8			NN
est_cost_rpu_ms	float8			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_stored_proc_call_redacted

old
column	data type	PK	U	NN
userid	int4			NN
session_userid	int4			NN
query	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database	char(32)			NN
querytxt_redacted	char(500)			NN
starttime	int8			NN
endtime	int8			NN
aborted	int4			NN
access_control	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_user_query_history_redacted

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database_name	char(128)			NN
query_type	char(32)			NN
status	char(10)			NN
result_cache_source_query	int8			NN
start_time	int8			NN
end_time	int8			NN
queue_time	int8			NN
execution_time	int8			NN
error_message	char(512)			NN
returned_rows	int8			NN
returned_bytes	int8			NN
redshift_version	char(32)			NN
usage_limit	char(150)			NN
internal_query	char(1)			NN
query_text_redacted	char(4000)			NN
compute_type	char(32)			NN
compile_time	int8			NN
planning_time	int8			NN
pure_planning_time	int8			NN
lock_wait_time	int8			NN
access_control	int4			NN
service_class_id	int4			NN
service_class_name	char(64)			NN
query_priority	char(20)			NN
short_query_accelerated	char(10)			NN
user_query_hash	char(40)			NN
generic_query_hash	char(40)			NN
query_hash_version	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_user_query_text_redacted

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
transaction_id	int8			NN
session_id	int4			NN
start_time	int8			NN
sequence	int4			NN
text_redacted	char(4000)			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_utilitytext_redacted

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
label	char(320)			NN
starttime	int8			NN
endtime	int8			NN
sequence	int4			NN
text_redacted	char(200)			NN
access_control	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.stll_catalog_aggregate_bufmgr_stats

old
column	data type	PK	U	NN
period_start	timestamp			NN
log_time	timestamp			NN
read_buffer_cache_hits	int8			NN
read_buffer_cache_misses	int8			NN
get_buffer_in_free_list	int8			NN
get_buffer_evictions	int8			NN
clean_evictions	int8			NN
dirty_evictions	int8			NN
contention_on_eviction	int8			NN
microseconds_flushing_dirty_buffers_during_allocation	int8			NN
microseconds_flushing_dirty_buffers	int8			NN
pin_buffer_calls	int8			NN
unpin_buffer_calls	int8			NN
invalidate_buffer	int8			NN
freelist_size_end_of_interval	int8			NN
recency_cache_size_end_of_interval	int8			NN
frequency_cache_size_end_of_interval	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_compile_errors

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
recordtime	timestamp			NN
query	int4			NN
segment	int4			NN
sequence	int4			NN
message	char(255)			NN
loc	char(255)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_ddltext_redacted

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
label	char(320)			NN
starttime	timestamp			NN
endtime	timestamp			NN
sequence	int4			NN
text_redacted	char(200)			NN
access_control	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_doryc_container_stats

old
column	data type	PK	U	NN
eventtime	timestamp			NN
node	int4			NN
container_name	char(32)			NN
container_id	char(32)			NN
cpu_usage_percentage	float8			NN
memory_usage_percentage	float8			NN
memory_usage	char(16)			NN
pid_count	int4			NN
net_io	char(16)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_explain_redacted

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
nodeid	int4			NN
parentid	int4			NN
plannode	char(400)			NN
info_redacted	char(400)			NN
access_control	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_external_query_detail_base_redacted

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
pid	int4			NN
xid	int8			NN
segment_id	int4			NN
node	int4			NN
slice	int4			NN
table_name	char(256)			NN
sourcetype	char(32)			NN
eventtime	timestamp			NN
starttime	timestamp			NN
endtime	timestamp			NN
duration	int8			NN
total_partitions	int4			NN
qualified_partitions	int4			NN
total_files	int4			NN
files_scanned	int4			NN
num_rows	int8			NN
num_bytes	int8			NN
file_format	char(16)			NN
location	char(256)			NN
pg_query_text_redacted	char(4000)			NN
logging_tag	char(32)			NN
warning_message	char(4000)			NN
is_recursive	char(1)			NN
is_nested	char(1)			NN
s3list_time	int8			NN
get_partition_time	int8			NN
access_control	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_federated_query_redacted

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
sourcetype	char(30)			NN
database	char(30)			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
recordtime	timestamp			NN
querytext_redacted	char(4000)			NN
num_rows	int8			NN
num_bytes	int8			NN
duration	int8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_query_redacted

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database	char(32)			NN
querytxt_redacted	char(4000)			NN
starttime	timestamp			NN
endtime	timestamp			NN
aborted	int4			NN
insert_pristine	int4			NN
concurrency_scaling_status	int4			NN
access_control	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_querytext_redacted

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
sequence	int4			NN
text_redacted	char(200)			NN
access_control	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_sage_mode_simulation_queries

old
column	data type	PK	U	NN
simulation_id	char(36)			NN
trace_id	int4			NN
query_id	int4			NN
arrival_time	timestamp			NN
burstable	int4			NN
exec_start_time	timestamp			NN
ssid	int4			NN
cluster_size	int4			NN
est_execution_time_ms	float8			NN
est_queue_time_ms	float8			NN
est_cost_rpu_ms	float8			NN

new
column	data type	PK	U	NN

pg_catalog.stll_stored_proc_call_redacted

old
column	data type	PK	U	NN
userid	int4			NN
session_userid	int4			NN
query	int4			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database	char(32)			NN
querytxt_redacted	char(500)			NN
starttime	timestamp			NN
endtime	timestamp			NN
aborted	int4			NN
access_control	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_user_query_history_redacted

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
label	char(320)			NN
xid	int8			NN
pid	int4			NN
database_name	char(128)			NN
query_type	char(32)			NN
status	char(10)			NN
result_cache_source_query	int8			NN
start_time	timestamp			NN
end_time	timestamp			NN
queue_time	int8			NN
execution_time	int8			NN
error_message	char(512)			NN
returned_rows	int8			NN
returned_bytes	int8			NN
redshift_version	char(32)			NN
usage_limit	char(150)			NN
internal_query	char(1)			NN
query_text_redacted	char(4000)			NN
compute_type	char(32)			NN
compile_time	int8			NN
planning_time	int8			NN
pure_planning_time	int8			NN
lock_wait_time	int8			NN
access_control	int4			NN
service_class_id	int4			NN
service_class_name	char(64)			NN
query_priority	char(20)			NN
short_query_accelerated	char(10)			NN
user_query_hash	char(40)			NN
generic_query_hash	char(40)			NN
query_hash_version	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stll_user_query_text_redacted

old
column	data type	PK	U	NN
user_id	int4			NN
query_id	int8			NN
transaction_id	int8			NN
session_id	int4			NN
start_time	timestamp			NN
sequence	int4			NN
text_redacted	char(4000)			NN

new
column	data type	PK	U	NN

pg_catalog.stll_utilitytext_redacted

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
label	char(320)			NN
starttime	timestamp			NN
endtime	timestamp			NN
sequence	int4			NN
text_redacted	char(200)			NN
access_control	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stv_sage_query_trace_metrics

old
column	data type	PK	U	NN
query_id	int4			NN
arrival_time	timestamp			NN
inflight	int4			NN
burstable	int4			NN
cluster_size	int4			NN
execution_time_ms	int4			NN
consumed_megabytes	int4			NN
predicted_execution_times	char(400)			NN

new
column	data type	PK	U	NN

pg_catalog.stv_sage_query_trace_status

old
column	data type	PK	U	NN
metrics_queue_size	int4			NN
departure_updates_queue_size	int4			NN

new
column	data type	PK	U	NN

pg_catalog.stv_table_insertion_point_state

old
column	data type	PK	U	NN
tbl	int4			NN
slice	int4			NN
ip_id	int4			NN
last_partition_id	int4			NN

new
column	data type	PK	U	NN

pg_internal.redshift_auto_health_check_6184316

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_cqi_metrics

old
column	data type
pid	int4
starttime	timestamp
endtime	timestamp
component_name	char(48)
phase	char(48)
restart_id	char(64)
message	char(4096)

new
column	data type
pid	int4
starttime	timestamp
endtime	timestamp
component_name	char(48)
phase	char(48)
restart_id	char(64)
message	char(512)

pg_catalog.stl_catalog_aggregate_bufmgr_stats

old
column	data type
period_start	timestamp
log_time	timestamp
read_buffer_cache_hits	int8
read_buffer_cache_misses	int8
get_buffer_in_free_list	int8
get_buffer_evictions	int8
clean_evictions	int8
dirty_evictions	int8
contention_on_eviction	int8
microseconds_flushing_dirty_buffers_during_allocation	int8
microseconds_flushing_dirty_buffers	int8
pin_buffer_calls	int8
unpin_buffer_calls	int8
invalidate_buffer	int8
freelist_size_end_of_interval	int8
recency_cache_size_end_of_interval	int8
frequency_cache_size_end_of_interval	int8

new
column	data type

pg_catalog.stl_compile_errors

old
column	data type
userid	int4
xid	int8
pid	int4
recordtime	timestamp
query	int4
segment	int4
sequence	int4
message	char(255)
loc	char(255)

new
column	data type

pg_catalog.stl_ddltext_redacted

old
column	data type
userid	int4
xid	int8
pid	int4
label	char(320)
starttime	timestamp
endtime	timestamp
sequence	int4
text_redacted	char(200)

new
column	data type

pg_catalog.stl_doryc_container_stats

old
column	data type
eventtime	timestamp
node	int4
container_name	char(32)
container_id	char(32)
cpu_usage_percentage	float8
memory_usage_percentage	float8
memory_usage	char(16)
pid_count	int4
net_io	char(16)

new
column	data type

pg_catalog.stl_explain_redacted

old
column	data type
userid	int4
query	int4
nodeid	int4
parentid	int4
plannode	char(400)
info_redacted	char(400)

new
column	data type

pg_catalog.stl_external_query_detail_base_redacted

old
column	data type
user_id	int4
query_id	int8
child_query_sequence	int4
child_query_id	int4
pid	int4
xid	int8
segment_id	int4
node	int4
slice	int4
table_name	char(256)
sourcetype	char(32)
eventtime	timestamp
starttime	timestamp
endtime	timestamp
duration	int8
total_partitions	int4
qualified_partitions	int4
total_files	int4
files_scanned	int4
num_rows	int8
num_bytes	int8
file_format	char(16)
location	char(256)
pg_query_text_redacted	char(4000)
logging_tag	char(32)
warning_message	char(4000)
is_recursive	char(1)
is_nested	char(1)
s3list_time	int8
get_partition_time	int8

new
column	data type

pg_catalog.stl_federated_query_redacted

old
column	data type
userid	int4
xid	int8
pid	int4
query	int4
sourcetype	char(30)
database	char(30)
segment	int4
node	int4
slice	int4
recordtime	timestamp
querytext_redacted	char(4000)
num_rows	int8
num_bytes	int8
duration	int8

new
column	data type

pg_catalog.stl_query_redacted

old
column	data type
userid	int4
query	int4
label	char(320)
xid	int8
pid	int4
database	char(32)
querytxt_redacted	char(4000)
starttime	timestamp
endtime	timestamp
aborted	int4
insert_pristine	int4
concurrency_scaling_status	int4

new
column	data type

pg_catalog.stl_querytext_redacted

old
column	data type
userid	int4
xid	int8
pid	int4
query	int4
sequence	int4
text_redacted	char(200)

new
column	data type

pg_catalog.stl_sage_mode_simulation_queries

old
column	data type
simulation_id	char(36)
trace_id	int4
query_id	int4
arrival_time	timestamp
burstable	int4
exec_start_time	timestamp
ssid	int4
cluster_size	int4
est_execution_time_ms	float8
est_queue_time_ms	float8
est_cost_rpu_ms	float8

new
column	data type

pg_catalog.stl_stored_proc_call_redacted

old
column	data type
userid	int4
session_userid	int4
query	int4
label	char(320)
xid	int8
pid	int4
database	char(32)
querytxt_redacted	char(500)
starttime	timestamp
endtime	timestamp
aborted	int4

new
column	data type

pg_catalog.stl_user_query_history_redacted

old
column	data type
user_id	int4
query_id	int8
label	char(320)
xid	int8
pid	int4
database_name	char(128)
query_type	char(32)
status	char(10)
result_cache_source_query	int8
start_time	timestamp
end_time	timestamp
queue_time	int8
execution_time	int8
error_message	char(512)
returned_rows	int8
returned_bytes	int8
redshift_version	char(32)
usage_limit	char(150)
internal_query	char(1)
query_text_redacted	char(4000)
compute_type	char(32)
compile_time	int8
planning_time	int8
pure_planning_time	int8
lock_wait_time	int8
service_class_id	int4
service_class_name	char(64)
query_priority	char(20)
short_query_accelerated	char(10)
user_query_hash	char(40)
generic_query_hash	char(40)
query_hash_version	int4

new
column	data type

pg_catalog.stl_user_query_text_redacted

old
column	data type
user_id	int4
query_id	int8
transaction_id	int8
session_id	int4
start_time	timestamp
sequence	int4
text_redacted	char(4000)

new
column	data type

pg_catalog.stl_utilitytext_redacted

old
column	data type
userid	int4
xid	int8
pid	int4
label	char(320)
starttime	timestamp
endtime	timestamp
sequence	int4
text_redacted	char(200)

new
column	data type

pg_catalog.svv_copy_job_integrations

old
column	data type
job_owner	int4
channel_arn	name
bucket	text
channel_state	name
db_name	name
job_name	text
job_state	int4

new
column	data type