Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
new	pg_catalog	internal	immutable	int4	iceberg_bucket	date,int4
new	pg_catalog	internal	immutable	int4	iceberg_bucket	int4,int4
new	pg_catalog	internal	immutable	int4	iceberg_bucket	int8,int4
new	pg_catalog	internal	immutable	int4	iceberg_bucket	numeric,int4
new	pg_catalog	internal	immutable	int4	iceberg_bucket	text,int4
new	pg_catalog	internal	immutable	int4	iceberg_bucket	time,int4
new	pg_catalog	internal	immutable	int4	iceberg_bucket	timestamp,int4
new	pg_catalog	internal	immutable	int4	iceberg_bucket	timestamptz,int4
new	pg_catalog	internal	immutable	int4	iceberg_bucket	timetz,int4
new	pg_catalog	internal	immutable	int4	iceberg_bucket	varbyte,int4
new	pg_catalog	internal	immutable	int4	iceberg_bucket	varchar,int4
new	pg_catalog	internal	immutable	int4	iceberg_truncate	int4,int4
new	pg_catalog	internal	immutable	int8	iceberg_day	timestamp
new	pg_catalog	internal	immutable	int8	iceberg_hour	timestamp
new	pg_catalog	internal	immutable	int8	iceberg_month	timestamp
new	pg_catalog	internal	immutable	int8	iceberg_truncate	int8,int4
new	pg_catalog	internal	immutable	int8	iceberg_year	timestamp
new	pg_catalog	internal	immutable	numeric	iceberg_truncate	numeric,int4
new	pg_catalog	internal	immutable	text	iceberg_truncate	text,int4
new	pg_catalog	internal	immutable	varbyte	iceberg_truncate	varbyte,int4
new	pg_catalog	internal	immutable	varchar	iceberg_truncate	varchar,int4

Tables

pg_catalog.pg_template

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
template_id	oid			NN
database_id	oid			NN
schema_id	oid			NN
template_name	name			NN
template_type	int2			NN
create_time	timestamp			NN
last_modified_time	timestamp			NN
template_owner	oid			NN
last_modified_by	oid			NN
template_definition	text

pg_catalog.stcs_mddl_events

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
tbl	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
eventtime	int8			NN
eventtype	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_result_offload_detail

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
pid	int4			NN
user_query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
slice_id	int4			NN
offload_start_time	int8			NN
offload_end_time	int8			NN
offloaded_rows	int8			NN
offloaded_bytes	int8			NN
offload_location	char(1024)			NN
file_format	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.stcs_sage_mode_policy_candidates

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
policy_id	int4			NN
creation_time	int8			NN
current_main	int4			NN
current_alpha	float8			NN
target_main	int4			NN
target_alpha	float8			NN
simulated_cost_rpu_sec	float8			NN
simulated_avg_response_time_sec	float8			NN
simulated_total_response_time_sec	float8			NN
simulated_num_queries	int8			NN
penalty	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

pg_catalog.stcs_watchdog_stuck_abort

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
aborttime	int8			NN
recordtime	int8			NN
pid	int4			NN
qid	int4			NN
abort_reason	char(32)			NN
stuck_type	char(20)			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_mddl_events

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
tbl	int4			NN
xid	int8			NN
pid	int4			NN
query	int4			NN
eventtime	timestamp			NN
eventtype	int4			NN

pg_catalog.stll_result_offload_detail

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
pid	int4			NN
user_query_id	int8			NN
child_query_sequence	int4			NN
child_query_id	int4			NN
slice_id	int4			NN
offload_start_time	timestamp			NN
offload_end_time	timestamp			NN
offloaded_rows	int8			NN
offloaded_bytes	int8			NN
offload_location	char(1024)			NN
file_format	char(16)			NN

pg_catalog.stll_sage_mode_policy_candidates

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
policy_id	int4			NN
creation_time	timestamp			NN
current_main	int4			NN
current_alpha	float8			NN
target_main	int4			NN
target_alpha	float8			NN
simulated_cost_rpu_sec	float8			NN
simulated_avg_response_time_sec	float8			NN
simulated_total_response_time_sec	float8			NN
simulated_num_queries	int8			NN
penalty	float8			NN

pg_catalog.stll_watchdog_stuck_abort

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
aborttime	timestamp			NN
recordtime	timestamp			NN
pid	int4			NN
qid	int4			NN
abort_reason	char(32)			NN
stuck_type	char(20)			NN

pg_internal.redshift_auto_health_check_8118012

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_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
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
dirty_cache_size_end_of_interval	int8			NN
max_dirty_buffers	int8			NN
clean_first_enabled	int4			NN
buffer_write_dirtied_buffers	int8			NN
rebuild_worker_dirtied_buffers	int8			NN
hint_bit_dirtied_buffers	int8			NN
flush_buffer_calls	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_datashare_request_consumer

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
initial_query_time	int8			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
api_call	int4			NN
starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
transaction_uid	char(50)			NN
retry_times	int4			NN
producer_cluster_id	char(50)			NN
pg_lock_modes	char(48)			NN
xen_lock_types	char(48)			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
xid	int8			NN
pid	int4			NN
initial_query_time	int8			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
api_call	int4			NN
starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
transaction_uid	char(50)			NN
retry_times	int4			NN
producer_cluster_id	char(50)			NN
pg_lock_modes	char(48)			NN
xen_lock_types	char(48)			NN
transaction_type	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_datashare_request_producer

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

new
column	data type	PK	U	NN
userid	int4			NN
pid	int4			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
shareid	int4			NN
sharename	char(128)			NN
api_call	int4			NN
obj_type	int4			NN
obj_oid	int4			NN
obj_name	char(128)			NN
starttime	int8			NN
endtime	int8			NN
status	int4			NN
message	char(512)			NN
consumeraccountid	char(50)			NN
consumernamespace	char(50)			NN
consumer_transaction_uid	char(50)			NN
is_versioned_request	int4			NN
overridden_snapshot_xmin	int8			NN
xid	int8			NN
backend_start_time	int8			NN
handler_start_time	int8			NN
consumer_region	char(64)			NN
producer_cluster_id	char(50)			NN
action	char(128)			NN
block_header	int4			NN
pg_lock_modes	char(48)			NN
xen_lock_types	char(48)			NN
pg_lock_acquire_starttime	int8			NN
pg_lock_acquire_endtime	int8			NN
xen_lock_acquire_starttime	int8			NN
xen_lock_acquire_endtime	int8			NN
real_pid	int4			NN
transaction_type	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_local_s3_scan_file_stats

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
slice	int4			NN
file	char(512)			NN
file_type	int4			NN
file_size_bytes	int8			NN
num_columns	int8			NN
footer_size_bytes	int8			NN
page_index_size_bytes	int8			NN
num_row_groups	int8			NN
min_row_group_size_bytes	int8			NN
max_row_group_size_bytes	int8			NN
avg_row_group_size_bytes	int8			NN
file_format_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
query	int4			NN
segment	int4			NN
slice	int4			NN
file	char(512)			NN
file_type	int4			NN
file_size_bytes	int8			NN
num_columns	int8			NN
footer_size_bytes	int8			NN
page_index_size_bytes	int8			NN
num_row_groups	int8			NN
min_row_group_size_bytes	int8			NN
max_row_group_size_bytes	int8			NN
avg_row_group_size_bytes	int8			NN
file_format_version	int4			NN
num_bloom_filters	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_local_s3_scan_sr_generation

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
init_num_rg_small_file	int4			NN
final_num_rg_small_file	int4			NN
init_num_rg_large_file	int4			NN
final_num_rg_large_file	int4			NN
init_num_sr_small_file	int4			NN
final_num_sr_small_file	int4			NN
init_num_sr_large_file	int4			NN
final_num_sr_large_file	int4			NN
distinct_files	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
query	int4			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
init_num_rg_small_file	int4			NN
final_num_rg_small_file	int4			NN
init_num_rg_large_file	int4			NN
final_num_rg_large_file	int4			NN
init_num_sr_small_file	int4			NN
final_num_sr_small_file	int4			NN
init_num_sr_large_file	int4			NN
final_num_sr_large_file	int4			NN
distinct_files	int4			NN
generation_start_timestamp	int8			NN
generation_finish_timestamp	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_local_s3_scan_sr_processing_stats

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
file	char(512)			NN
offset_bytes	int8			NN
length_bytes	int8			NN
deserialize_time	int8			NN
footer_first_prefetch_trigger_time	int8			NN
footer_first_fetch_sent_time	int8			NN
footer_first_fetch_ready_time	int8			NN
triggered_second_footer_prefetch	char(1)			NN
footer_second_prefetch_trigger_time	int8			NN
footer_second_fetch_sent_time	int8			NN
footer_second_fetch_ready_time	int8			NN
footer_parse_starttime	int8			NN
footer_parse_endtime	int8			NN
blf_starttime	int8			NN
blf_endtime	int8			NN
assigned_time	int8			NN
execution_starttime	int8			NN
execution_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

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
file	char(512)			NN
offset_bytes	int8			NN
length_bytes	int8			NN
deserialize_time	int8			NN
footer_first_prefetch_trigger_time	int8			NN
footer_first_fetch_sent_time	int8			NN
footer_first_fetch_ready_time	int8			NN
triggered_second_footer_prefetch	char(1)			NN
footer_second_prefetch_trigger_time	int8			NN
footer_second_fetch_sent_time	int8			NN
footer_second_fetch_ready_time	int8			NN
footer_parse_starttime	int8			NN
footer_parse_endtime	int8			NN
blf_starttime	int8			NN
blf_endtime	int8			NN
wait_for_assignment_start_time	int8			NN
assigned_time	int8			NN
execution_starttime	int8			NN
execution_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_mv_refresh

old
column	data type	PK	U	NN
userid	int8			NN
xid	int8			NN
starttime	int8			NN
endtime	int8			NN
schemaoid	int8			NN
mvoid	int8			NN
status	int4			NN
refresh_type	char(32)			NN
db_oid	int8			NN
no_new_rows	char(1)			NN
skipped_rows	char(1)			NN
may_have_more_rows	char(1)			NN
session_id	int4			NN
database_name	char(128)			NN
schema_name	char(128)			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
userid	int8			NN
xid	int8			NN
starttime	int8			NN
endtime	int8			NN
schemaoid	int8			NN
mvoid	int8			NN
status	int4			NN
refresh_type	char(32)			NN
db_oid	int8			NN
no_new_rows	char(1)			NN
skipped_rows	char(1)			NN
may_have_more_rows	char(1)			NN
session_id	int4			NN
database_name	char(128)			NN
schema_name	char(128)			NN
mv_name	char(128)			NN
is_cascade_mode	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_pg_wal_stats

old
column	data type	PK	U	NN
period_start	int8			NN
log_time	int8			NN
num_wal_inserts	int8			NN
num_wal_writes	int8			NN
num_repwal_msgs	int8			NN
total_repwal_size_kb	int8			NN
total_repwal_time_ms	int8			NN
avg_repwal_time_us	int8			NN
max_repwal_time_us	int8			NN
logged_manually	int4			NN
last_repwal_log_id	int8			NN
last_repwal_log_seg	int8			NN
last_repwal_offset	int8			NN
max_repwal_pid	int8			NN
max_repwal_xid	int8			NN
max_repwal_start_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
period_start	int8			NN
log_time	int8			NN
num_wal_inserts	int8			NN
num_wal_writes	int8			NN
num_repwal_msgs	int8			NN
total_repwal_size_kb	int8			NN
total_repwal_time_ms	int8			NN
avg_repwal_time_us	int8			NN
max_repwal_time_us	int8			NN
logged_manually	int4			NN
last_repwal_log_id	int8			NN
last_repwal_log_seg	int8			NN
last_repwal_offset	int8			NN
max_repwal_pid	int8			NN
max_repwal_xid	int8			NN
max_repwal_start_time	int8			NN
num_backup_blocks	int8			NN
total_wal_insert_size_kb	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_query_prediction

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
execution_time	float8			NN
execution_time_error	float8			NN
memory	float8			NN
memory_error	float8			NN
execution_time_without_compile	float8			NN
execution_time_without_compile_error	float8			NN
burst_exec_time	float8			NN
burst_exec_time_error	float8			NN
local_scaling_prediction	float8			NN
query_feature	char(256)			NN
local_scaling_feature	char(512)			NN
scaling_feature	char(512)			NN
copy_feature	char(128)			NN
copy_memory_feature	char(128)			NN
copy_scaling_feature	char(128)			NN
vacuum_feature	char(128)			NN
spectrum_file_count_feature	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
query	int4			NN
xid	int8			NN
execution_time	float8			NN
execution_time_error	float8			NN
memory	float8			NN
memory_error	float8			NN
execution_time_without_compile	float8			NN
execution_time_without_compile_error	float8			NN
burst_exec_time	float8			NN
burst_exec_time_error	float8			NN
local_scaling_prediction	float8			NN
query_feature	char(256)			NN
local_scaling_feature	char(512)			NN
scaling_feature	char(512)			NN
copy_feature	char(128)			NN
copy_memory_feature	char(128)			NN
copy_scaling_feature	char(128)			NN
vacuum_feature	char(128)			NN
spectrum_file_count_feature	char(16)			NN
pflearn_p_prerun	float8			NN
pflearn_b_prerun	float8			NN
pflearn_p_postrun	float8			NN
pflearn_b_postrun	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

pg_catalog.stcs_user_query_history

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	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
username	char(128)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
user_id	int4			NN
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	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
username	char(128)			NN
result_offloaded	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_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
username	char(128)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
user_id	int4			NN
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
username	char(128)			NN
result_offloaded	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.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
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
dirty_cache_size_end_of_interval	int8			NN
max_dirty_buffers	int8			NN
clean_first_enabled	int4			NN
buffer_write_dirtied_buffers	int8			NN
rebuild_worker_dirtied_buffers	int8			NN
hint_bit_dirtied_buffers	int8			NN
flush_buffer_calls	int8			NN

pg_catalog.stll_datashare_request_consumer

old
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
initial_query_time	timestamp			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
api_call	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
status	int4			NN
message	char(512)			NN
transaction_uid	char(50)			NN
retry_times	int4			NN
producer_cluster_id	char(50)			NN
pg_lock_modes	char(48)			NN
xen_lock_types	char(48)			NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
pid	int4			NN
initial_query_time	timestamp			NN
requestid	char(50)			NN
sb_version	int8			NN
dbtype	int4			NN
dbid	int4			NN
api_call	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
status	int4			NN
message	char(512)			NN
transaction_uid	char(50)			NN
retry_times	int4			NN
producer_cluster_id	char(50)			NN
pg_lock_modes	char(48)			NN
xen_lock_types	char(48)			NN
transaction_type	int4			NN

pg_catalog.stll_datashare_request_producer

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

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

pg_catalog.stll_local_s3_scan_file_stats

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
slice	int4			NN
file	char(512)			NN
file_type	int4			NN
file_size_bytes	int8			NN
num_columns	int8			NN
footer_size_bytes	int8			NN
page_index_size_bytes	int8			NN
num_row_groups	int8			NN
min_row_group_size_bytes	int8			NN
max_row_group_size_bytes	int8			NN
avg_row_group_size_bytes	int8			NN
file_format_version	int4			NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
slice	int4			NN
file	char(512)			NN
file_type	int4			NN
file_size_bytes	int8			NN
num_columns	int8			NN
footer_size_bytes	int8			NN
page_index_size_bytes	int8			NN
num_row_groups	int8			NN
min_row_group_size_bytes	int8			NN
max_row_group_size_bytes	int8			NN
avg_row_group_size_bytes	int8			NN
file_format_version	int4			NN
num_bloom_filters	int8			NN

pg_catalog.stll_local_s3_scan_sr_generation

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
init_num_rg_small_file	int4			NN
final_num_rg_small_file	int4			NN
init_num_rg_large_file	int4			NN
final_num_rg_large_file	int4			NN
init_num_sr_small_file	int4			NN
final_num_sr_small_file	int4			NN
init_num_sr_large_file	int4			NN
final_num_sr_large_file	int4			NN
distinct_files	int4			NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
init_num_rg_small_file	int4			NN
final_num_rg_small_file	int4			NN
init_num_rg_large_file	int4			NN
final_num_rg_large_file	int4			NN
init_num_sr_small_file	int4			NN
final_num_sr_small_file	int4			NN
init_num_sr_large_file	int4			NN
final_num_sr_large_file	int4			NN
distinct_files	int4			NN
generation_start_timestamp	timestamp			NN
generation_finish_timestamp	timestamp			NN

pg_catalog.stll_local_s3_scan_sr_processing_stats

old
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
file	char(512)			NN
offset_bytes	int8			NN
length_bytes	int8			NN
deserialize_time	timestamp			NN
footer_first_prefetch_trigger_time	timestamp			NN
footer_first_fetch_sent_time	timestamp			NN
footer_first_fetch_ready_time	timestamp			NN
triggered_second_footer_prefetch	char(1)			NN
footer_second_prefetch_trigger_time	timestamp			NN
footer_second_fetch_sent_time	timestamp			NN
footer_second_fetch_ready_time	timestamp			NN
footer_parse_starttime	timestamp			NN
footer_parse_endtime	timestamp			NN
blf_starttime	timestamp			NN
blf_endtime	timestamp			NN
assigned_time	timestamp			NN
execution_starttime	timestamp			NN
execution_endtime	timestamp			NN

new
column	data type	PK	U	NN
query	int4			NN
segment	int4			NN
step	int4			NN
node	int4			NN
slice	int4			NN
file	char(512)			NN
offset_bytes	int8			NN
length_bytes	int8			NN
deserialize_time	timestamp			NN
footer_first_prefetch_trigger_time	timestamp			NN
footer_first_fetch_sent_time	timestamp			NN
footer_first_fetch_ready_time	timestamp			NN
triggered_second_footer_prefetch	char(1)			NN
footer_second_prefetch_trigger_time	timestamp			NN
footer_second_fetch_sent_time	timestamp			NN
footer_second_fetch_ready_time	timestamp			NN
footer_parse_starttime	timestamp			NN
footer_parse_endtime	timestamp			NN
blf_starttime	timestamp			NN
blf_endtime	timestamp			NN
wait_for_assignment_start_time	timestamp			NN
assigned_time	timestamp			NN
execution_starttime	timestamp			NN
execution_endtime	timestamp			NN

pg_catalog.stll_mv_refresh

old
column	data type	PK	U	NN
userid	int8			NN
xid	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
schemaoid	int8			NN
mvoid	int8			NN
status	int4			NN
refresh_type	char(32)			NN
db_oid	int8			NN
no_new_rows	char(1)			NN
skipped_rows	char(1)			NN
may_have_more_rows	char(1)			NN
session_id	int4			NN
database_name	char(128)			NN
schema_name	char(128)			NN
mv_name	char(128)			NN

new
column	data type	PK	U	NN
userid	int8			NN
xid	int8			NN
starttime	timestamp			NN
endtime	timestamp			NN
schemaoid	int8			NN
mvoid	int8			NN
status	int4			NN
refresh_type	char(32)			NN
db_oid	int8			NN
no_new_rows	char(1)			NN
skipped_rows	char(1)			NN
may_have_more_rows	char(1)			NN
session_id	int4			NN
database_name	char(128)			NN
schema_name	char(128)			NN
mv_name	char(128)			NN
is_cascade_mode	char(1)			NN

pg_catalog.stll_pg_wal_stats

old
column	data type	PK	U	NN
period_start	timestamp			NN
log_time	timestamp			NN
num_wal_inserts	int8			NN
num_wal_writes	int8			NN
num_repwal_msgs	int8			NN
total_repwal_size_kb	int8			NN
total_repwal_time_ms	int8			NN
avg_repwal_time_us	int8			NN
max_repwal_time_us	int8			NN
logged_manually	int4			NN
last_repwal_log_id	int8			NN
last_repwal_log_seg	int8			NN
last_repwal_offset	int8			NN
max_repwal_pid	int8			NN
max_repwal_xid	int8			NN
max_repwal_start_time	timestamp			NN

new
column	data type	PK	U	NN
period_start	timestamp			NN
log_time	timestamp			NN
num_wal_inserts	int8			NN
num_wal_writes	int8			NN
num_repwal_msgs	int8			NN
total_repwal_size_kb	int8			NN
total_repwal_time_ms	int8			NN
avg_repwal_time_us	int8			NN
max_repwal_time_us	int8			NN
logged_manually	int4			NN
last_repwal_log_id	int8			NN
last_repwal_log_seg	int8			NN
last_repwal_offset	int8			NN
max_repwal_pid	int8			NN
max_repwal_xid	int8			NN
max_repwal_start_time	timestamp			NN
num_backup_blocks	int8			NN
total_wal_insert_size_kb	int8			NN

pg_catalog.stll_query_prediction

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
execution_time	float8			NN
execution_time_error	float8			NN
memory	float8			NN
memory_error	float8			NN
execution_time_without_compile	float8			NN
execution_time_without_compile_error	float8			NN
burst_exec_time	float8			NN
burst_exec_time_error	float8			NN
local_scaling_prediction	float8			NN
query_feature	char(256)			NN
local_scaling_feature	char(512)			NN
scaling_feature	char(512)			NN
copy_feature	char(128)			NN
copy_memory_feature	char(128)			NN
copy_scaling_feature	char(128)			NN
vacuum_feature	char(128)			NN
spectrum_file_count_feature	char(16)			NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
execution_time	float8			NN
execution_time_error	float8			NN
memory	float8			NN
memory_error	float8			NN
execution_time_without_compile	float8			NN
execution_time_without_compile_error	float8			NN
burst_exec_time	float8			NN
burst_exec_time_error	float8			NN
local_scaling_prediction	float8			NN
query_feature	char(256)			NN
local_scaling_feature	char(512)			NN
scaling_feature	char(512)			NN
copy_feature	char(128)			NN
copy_memory_feature	char(128)			NN
copy_scaling_feature	char(128)			NN
vacuum_feature	char(128)			NN
spectrum_file_count_feature	char(16)			NN
pflearn_p_prerun	float8			NN
pflearn_b_prerun	float8			NN
pflearn_p_postrun	float8			NN
pflearn_b_postrun	float8			NN

pg_catalog.stll_user_query_history

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	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
username	char(128)			NN

new
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	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
username	char(128)			NN
result_offloaded	char(1)			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
username	char(128)			NN

new
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
username	char(128)			NN
result_offloaded	char(1)			NN

pg_catalog.stv_user_query_state

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
now	timestamp			NN
status_update_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	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
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
username	char(128)			NN

new
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
now	timestamp			NN
status_update_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	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
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
username	char(128)			NN
result_offloaded	char(1)			NN

pg_internal.redshift_auto_health_check_8117934

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_mddl_events

old
column	data type

new
column	data type
tbl	int4
xid	int8
pid	int4
query	int4
eventtime	timestamp
eventtype	int4

pg_catalog.stl_result_offload_detail

old
column	data type

new
column	data type
user_id	int4
pid	int4
user_query_id	int8
child_query_sequence	int4
child_query_id	int4
slice_id	int4
offload_start_time	timestamp
offload_end_time	timestamp
offloaded_rows	int8
offloaded_bytes	int8
offload_location	char(1024)
file_format	char(16)

pg_catalog.stl_sage_mode_policy_candidates

old
column	data type

new
column	data type
policy_id	int4
creation_time	timestamp
current_main	int4
current_alpha	float8
target_main	int4
target_alpha	float8
simulated_cost_rpu_sec	float8
simulated_avg_response_time_sec	float8
simulated_total_response_time_sec	float8
simulated_num_queries	int8
penalty	float8

pg_catalog.stl_watchdog_stuck_abort

old
column	data type

new
column	data type
aborttime	timestamp
recordtime	timestamp
pid	int4
qid	int4
abort_reason	char(32)
stuck_type	char(20)

pg_catalog.sys_result_offload_history

old
column	data type

new
column	data type
user_id	int4
query_id	int8
offload_start_time	timestamp
offload_end_time	timestamp
offload_duration	int8
offloaded_rows	int8
offloaded_bytes	int8
offload_location	text
offloaded_files_count	int8
file_format	char(16)

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
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
dirty_cache_size_end_of_interval	int8
max_dirty_buffers	int8
clean_first_enabled	int4
buffer_write_dirtied_buffers	int8
rebuild_worker_dirtied_buffers	int8
hint_bit_dirtied_buffers	int8
flush_buffer_calls	int8

pg_catalog.stl_datashare_request_consumer

old
column	data type
userid	int4
xid	int8
pid	int4
initial_query_time	timestamp
requestid	char(50)
sb_version	int8
dbtype	int4
dbid	int4
api_call	int4
starttime	timestamp
endtime	timestamp
status	int4
message	char(512)
transaction_uid	char(50)
retry_times	int4
producer_cluster_id	char(50)
pg_lock_modes	char(48)
xen_lock_types	char(48)

new
column	data type
userid	int4
xid	int8
pid	int4
initial_query_time	timestamp
requestid	char(50)
sb_version	int8
dbtype	int4
dbid	int4
api_call	int4
starttime	timestamp
endtime	timestamp
status	int4
message	char(512)
transaction_uid	char(50)
retry_times	int4
producer_cluster_id	char(50)
pg_lock_modes	char(48)
xen_lock_types	char(48)
transaction_type	int4

pg_catalog.stl_datashare_request_producer

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

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

pg_catalog.stl_local_s3_scan_file_stats

old
column	data type
query	int4
segment	int4
slice	int4
file	char(512)
file_type	int4
file_size_bytes	int8
num_columns	int8
footer_size_bytes	int8
page_index_size_bytes	int8
num_row_groups	int8
min_row_group_size_bytes	int8
max_row_group_size_bytes	int8
avg_row_group_size_bytes	int8
file_format_version	int4

new
column	data type
query	int4
segment	int4
slice	int4
file	char(512)
file_type	int4
file_size_bytes	int8
num_columns	int8
footer_size_bytes	int8
page_index_size_bytes	int8
num_row_groups	int8
min_row_group_size_bytes	int8
max_row_group_size_bytes	int8
avg_row_group_size_bytes	int8
file_format_version	int4
num_bloom_filters	int8

pg_catalog.stl_local_s3_scan_sr_generation

old
column	data type
query	int4
segment	int4
step	int4
node	int4
slice	int4
init_num_rg_small_file	int4
final_num_rg_small_file	int4
init_num_rg_large_file	int4
final_num_rg_large_file	int4
init_num_sr_small_file	int4
final_num_sr_small_file	int4
init_num_sr_large_file	int4
final_num_sr_large_file	int4
distinct_files	int4

new
column	data type
query	int4
segment	int4
step	int4
node	int4
slice	int4
init_num_rg_small_file	int4
final_num_rg_small_file	int4
init_num_rg_large_file	int4
final_num_rg_large_file	int4
init_num_sr_small_file	int4
final_num_sr_small_file	int4
init_num_sr_large_file	int4
final_num_sr_large_file	int4
distinct_files	int4
generation_start_timestamp	timestamp
generation_finish_timestamp	timestamp

pg_catalog.stl_local_s3_scan_sr_processing_stats

old
column	data type
query	int4
segment	int4
step	int4
node	int4
slice	int4
file	char(512)
offset_bytes	int8
length_bytes	int8
deserialize_time	timestamp
footer_first_prefetch_trigger_time	timestamp
footer_first_fetch_sent_time	timestamp
footer_first_fetch_ready_time	timestamp
triggered_second_footer_prefetch	char(1)
footer_second_prefetch_trigger_time	timestamp
footer_second_fetch_sent_time	timestamp
footer_second_fetch_ready_time	timestamp
footer_parse_starttime	timestamp
footer_parse_endtime	timestamp
blf_starttime	timestamp
blf_endtime	timestamp
assigned_time	timestamp
execution_starttime	timestamp
execution_endtime	timestamp

new
column	data type
query	int4
segment	int4
step	int4
node	int4
slice	int4
file	char(512)
offset_bytes	int8
length_bytes	int8
deserialize_time	timestamp
footer_first_prefetch_trigger_time	timestamp
footer_first_fetch_sent_time	timestamp
footer_first_fetch_ready_time	timestamp
triggered_second_footer_prefetch	char(1)
footer_second_prefetch_trigger_time	timestamp
footer_second_fetch_sent_time	timestamp
footer_second_fetch_ready_time	timestamp
footer_parse_starttime	timestamp
footer_parse_endtime	timestamp
blf_starttime	timestamp
blf_endtime	timestamp
wait_for_assignment_start_time	timestamp
assigned_time	timestamp
execution_starttime	timestamp
execution_endtime	timestamp

pg_catalog.stl_mv_refresh

old
column	data type
userid	int8
xid	int8
starttime	timestamp
endtime	timestamp
schemaoid	int8
mvoid	int8
status	int4
refresh_type	char(32)
db_oid	int8
no_new_rows	char(1)
skipped_rows	char(1)
may_have_more_rows	char(1)
session_id	int4
database_name	char(128)
schema_name	char(128)
mv_name	char(128)

new
column	data type
userid	int8
xid	int8
starttime	timestamp
endtime	timestamp
schemaoid	int8
mvoid	int8
status	int4
refresh_type	char(32)
db_oid	int8
no_new_rows	char(1)
skipped_rows	char(1)
may_have_more_rows	char(1)
session_id	int4
database_name	char(128)
schema_name	char(128)
mv_name	char(128)
is_cascade_mode	char(1)

pg_catalog.stl_pg_wal_stats

old
column	data type
period_start	timestamp
log_time	timestamp
num_wal_inserts	int8
num_wal_writes	int8
num_repwal_msgs	int8
total_repwal_size_kb	int8
total_repwal_time_ms	int8
avg_repwal_time_us	int8
max_repwal_time_us	int8
logged_manually	int4
last_repwal_log_id	int8
last_repwal_log_seg	int8
last_repwal_offset	int8
max_repwal_pid	int8
max_repwal_xid	int8
max_repwal_start_time	timestamp

new
column	data type
period_start	timestamp
log_time	timestamp
num_wal_inserts	int8
num_wal_writes	int8
num_repwal_msgs	int8
total_repwal_size_kb	int8
total_repwal_time_ms	int8
avg_repwal_time_us	int8
max_repwal_time_us	int8
logged_manually	int4
last_repwal_log_id	int8
last_repwal_log_seg	int8
last_repwal_offset	int8
max_repwal_pid	int8
max_repwal_xid	int8
max_repwal_start_time	timestamp
num_backup_blocks	int8
total_wal_insert_size_kb	int8

pg_catalog.stl_query_prediction

old
column	data type
query	int4
xid	int8
execution_time	float8
execution_time_error	float8
memory	float8
memory_error	float8
execution_time_without_compile	float8
execution_time_without_compile_error	float8
burst_exec_time	float8
burst_exec_time_error	float8
local_scaling_prediction	float8
query_feature	char(256)
local_scaling_feature	char(512)
scaling_feature	char(512)
copy_feature	char(128)
copy_memory_feature	char(128)
copy_scaling_feature	char(128)
vacuum_feature	char(128)
spectrum_file_count_feature	char(16)

new
column	data type
query	int4
xid	int8
execution_time	float8
execution_time_error	float8
memory	float8
memory_error	float8
execution_time_without_compile	float8
execution_time_without_compile_error	float8
burst_exec_time	float8
burst_exec_time_error	float8
local_scaling_prediction	float8
query_feature	char(256)
local_scaling_feature	char(512)
scaling_feature	char(512)
copy_feature	char(128)
copy_memory_feature	char(128)
copy_scaling_feature	char(128)
vacuum_feature	char(128)
spectrum_file_count_feature	char(16)
pflearn_p_prerun	float8
pflearn_b_prerun	float8
pflearn_p_postrun	float8
pflearn_b_postrun	float8

pg_catalog.stl_user_query_history

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	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
username	char(128)

new
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	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
username	char(128)
result_offloaded	char(1)

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
username	char(128)

new
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
username	char(128)
result_offloaded	char(1)

pg_catalog.svv_integration

old
column	data type
integration_id	char(128)
target_database	char(128)
source	char(128)
state	char(128)
current_lag	int8
last_replicated_checkpoint	char(128)
total_tables_replicated	int4
total_tables_failed	int4
creation_time	timestamp
refresh_interval	int4
source_database	char(128)
is_history_mode	bool

new
column	data type
integration_id	char(128)
target_database	char(128)
source	char(128)
state	char(128)
current_lag	int8
last_replicated_checkpoint	char(128)
total_tables_replicated	int4
total_tables_failed	int4
creation_time	timestamp
refresh_interval	int4
source_database	char(128)
is_history_mode	bool
query_all_states	bool
truncatecolumns	bool
accept_invchars	bool

pg_catalog.sys_query_history

old
column	data type
user_id	int4
query_id	int8
query_label	varchar(320)
transaction_id	int8
session_id	int4
database_name	varchar(128)
query_type	varchar(32)
status	char(10)
result_cache_hit	bool
start_time	timestamp
end_time	timestamp
elapsed_time	int8
queue_time	int8
execution_time	int8
error_message	varchar(512)
returned_rows	int8
returned_bytes	int8
query_text	varchar(4000)
redshift_version	char(32)
usage_limit	varchar(150)
compute_type	varchar(32)
compile_time	int8
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
result_cache_query_id	int8
username	char(128)

new
column	data type
user_id	int4
query_id	int8
query_label	varchar(320)
transaction_id	int8
session_id	int4
database_name	varchar(128)
query_type	varchar(32)
status	char(10)
result_cache_hit	bool
start_time	timestamp
end_time	timestamp
elapsed_time	int8
queue_time	int8
execution_time	int8
error_message	varchar(512)
returned_rows	int8
returned_bytes	int8
query_text	varchar(4000)
redshift_version	char(32)
usage_limit	varchar(150)
compute_type	varchar(32)
compile_time	int8
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
result_cache_query_id	int8
username	char(128)
result_offloaded	char(1)