Redshift Observatory System Table Tracker

Functions

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

Tables

pg_catalog.stcs_hdr_integrity_error_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	int8			NN
node_num	int4			NN
sb_ver	int8			NN
xid	int8			NN
sb_pos	int4			NN
hdr_dump_redacted	char(209)			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_leader_commit_trace

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_local_s3_scan_fallback

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_mem_alloc_histograms

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_perf_sink_histogram

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_perf_source_histogram

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_pg_function

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_redcat_logging

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_startnode_log

old
column	data type	PK	U	NN

new
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

pg_catalog.stcs_watchdog

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_hdr_integrity_error_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	timestamp			NN
node_num	int4			NN
sb_ver	int8			NN
xid	int8			NN
sb_pos	int4			NN
hdr_dump_redacted	char(209)			NN

pg_catalog.stll_leader_commit_trace

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_local_s3_scan_fallback

old
column	data type	PK	U	NN

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

pg_catalog.stll_mem_alloc_histograms

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_perf_sink_histogram

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_perf_source_histogram

old
column	data type	PK	U	NN

new
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

pg_catalog.stll_pg_function

old
column	data type	PK	U	NN

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

pg_catalog.stll_redcat_logging

old
column	data type	PK	U	NN

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

pg_catalog.stll_startnode_log

old
column	data type	PK	U	NN

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

pg_catalog.stll_watchdog

old
column	data type	PK	U	NN

new
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

pg_catalog.stv_iceberg_metadata_cache

old
column	data type	PK	U	NN

new
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

pg_internal.redshift_auto_health_check_7092458

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_arcadia_concurrency_scaling_usage

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	int8			NN
rewritten_qid	int4			NN
user_query_id	int8			NN
child_query_seq	int4			NN
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	int8			NN
endtime	int8			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN
is_cs_at_query	int4			NN
is_multi_az_secondary	int4			NN
resv_model	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
userid	int4			NN
recordtime	int8			NN
rewritten_qid	int4			NN
user_query_id	int8			NN
child_query_seq	int4			NN
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	int8			NN
endtime	int8			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN
is_cs_at_query	int4			NN
is_multi_az_secondary	int4			NN
resv_model	int4			NN
phantom_burst_query	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_arcadia_main_usage

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	int8			NN
xid	int8			NN
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	int8			NN
endtime	int8			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN
resv_model	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
userid	int4			NN
recordtime	int8			NN
xid	int8			NN
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	int8			NN
endtime	int8			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN
resv_model	int4			NN
phantom_transaction	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_compute_elasticity_insert

old
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
ds_calc_option	int4			NN
parallel_insert_degree	int4			NN
parallel_insert_reason	int4			NN
tbl	int4			NN
rows	int8			NN
cols	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
slice	int4			NN
segment	int4			NN
step	int4			NN
ds_calc_option	int4			NN
parallel_insert_degree	int4			NN
parallel_insert_reason	int4			NN
tbl	int4			NN
rows	int8			NN
cols	int4			NN
mem_col_bucket_size	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_integration_user_activity

old
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
db_name	char(128)			NN
origin	char(64)			NN
external_time	int8			NN
type	char(64)			NN
option	char(64)			NN
message	char(1024)			NN
status	char(1024)			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
record_time	int8			NN
integration_id	char(128)			NN
db_name	char(128)			NN
origin	char(64)			NN
external_time	int8			NN
type	char(64)			NN
option	char(64)			NN
message	char(1024)			NN
status	char(1024)			NN
source_type	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

pg_catalog.stcs_internal_query_details

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
initial_query_time	int8			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
reported_peak_usage_bytes	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
exec_time_wo_compilation	int8			NN
exec_cluster_size	int4			NN
auto_mounted_tables_accessed	int4			NN
spectrum_file_count	int4			NN
datasharing_spectrum_tables_accessed	int4			NN
lf_datasharing_spectrum_tables_accessed	int4			NN
num_pce_segs	int4			NN
slice_unmerge_query	int4			NN
sample_based_col_count	int4			NN
sketch_based_col_count	int4			NN
userid	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
xid	int8			NN
initial_query_time	int8			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
reported_peak_usage_bytes	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
exec_time_wo_compilation	int8			NN
exec_cluster_size	int4			NN
auto_mounted_tables_accessed	int4			NN
spectrum_file_count	int4			NN
datasharing_spectrum_tables_accessed	int4			NN
lf_datasharing_spectrum_tables_accessed	int4			NN
num_pce_segs	int4			NN
slice_unmerge_query	int4			NN
sample_based_col_count	int4			NN
sketch_based_col_count	int4			NN
userid	int4			NN
sql_feature	char(173)			NN
is_ml_predictor_eligible	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_query_abort_reason

old
column	data type	PK	U	NN
recordtime	int8			NN
start_time	int8			NN
qid	int4			NN
pid	int4			NN
xid	int8			NN
userid	int4			NN
reason	char(32)			NN
exception_msg	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
recordtime	int8			NN
start_time	int8			NN
qid	int4			NN
pid	int4			NN
xid	int8			NN
userid	int4			NN
reason	char(32)			NN
exception_msg	char(128)			NN
pg_error_msg	char(128)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_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
__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
__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
__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
__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_arcadia_concurrency_scaling_usage

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
rewritten_qid	int4			NN
user_query_id	int8			NN
child_query_seq	int4			NN
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN
is_cs_at_query	int4			NN
is_multi_az_secondary	int4			NN
resv_model	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
rewritten_qid	int4			NN
user_query_id	int8			NN
child_query_seq	int4			NN
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN
is_cs_at_query	int4			NN
is_multi_az_secondary	int4			NN
resv_model	int4			NN
phantom_burst_query	int4			NN

pg_catalog.stll_arcadia_main_usage

old
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
xid	int8			NN
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN
resv_model	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
recordtime	timestamp			NN
xid	int8			NN
cluster	char(128)			NN
report_arn	char(128)			NN
instance_type	char(128)			NN
num_nodes	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
incurred_usage_rpu_ms	int4			NN
rpu	int4			NN
resv_model	int4			NN
phantom_transaction	int4			NN

pg_catalog.stll_compute_elasticity_insert

old
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
ds_calc_option	int4			NN
parallel_insert_degree	int4			NN
parallel_insert_reason	int4			NN
tbl	int4			NN
rows	int8			NN
cols	int4			NN

new
column	data type	PK	U	NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
ds_calc_option	int4			NN
parallel_insert_degree	int4			NN
parallel_insert_reason	int4			NN
tbl	int4			NN
rows	int8			NN
cols	int4			NN
mem_col_bucket_size	int4			NN

pg_catalog.stll_integration_user_activity

old
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
db_name	char(128)			NN
origin	char(64)			NN
external_time	timestamp			NN
type	char(64)			NN
option	char(64)			NN
message	char(1024)			NN
status	char(1024)			NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
db_name	char(128)			NN
origin	char(64)			NN
external_time	timestamp			NN
type	char(64)			NN
option	char(64)			NN
message	char(1024)			NN
status	char(1024)			NN
source_type	char(32)			NN

pg_catalog.stll_internal_query_details

old
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
initial_query_time	timestamp			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
reported_peak_usage_bytes	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
exec_time_wo_compilation	int8			NN
exec_cluster_size	int4			NN
auto_mounted_tables_accessed	int4			NN
spectrum_file_count	int4			NN
datasharing_spectrum_tables_accessed	int4			NN
lf_datasharing_spectrum_tables_accessed	int4			NN
num_pce_segs	int4			NN
slice_unmerge_query	int4			NN
sample_based_col_count	int4			NN
sketch_based_col_count	int4			NN
userid	int4			NN

new
column	data type	PK	U	NN
query	int4			NN
xid	int8			NN
initial_query_time	timestamp			NN
seldispatch_status	int4			NN
query_cmd_type	int4			NN
user_temp_tables_accessed	int4			NN
volt_temp_tables_accessed	int4			NN
spectrum_tables_accessed	int4			NN
user_perm_tables_accessed	int4			NN
system_tables_accessed	int4			NN
query_target_table_type	int4			NN
memory_demanding_info	int8			NN
nobackup_tables_accessed	int4			NN
zindex_tables_accessed	int4			NN
pg_tables_accessed	int4			NN
dirty_tables_read	int4			NN
wlm_slot_type	char(8)			NN
is_short_query	int4			NN
reported_peak_usage_bytes	int8			NN
wlm_query_memory	int8			NN
datasharing_tables_accessed	int4			NN
uses_new_cost_model	char(1)			NN
new_model_reason	int4			NN
num_rowsets	int4			NN
xregion_datasharing_tables_accessed	int4			NN
result_cache_miss_reason	int4			NN
cs_node_nums	int4			NN
is_multi	int4			NN
is_burst_for_at_task	int4			NN
user_query_id	int8			NN
lf_datasharing_tables_accessed	int4			NN
qpc_source_qid	int8			NN
exec_time_wo_compilation	int8			NN
exec_cluster_size	int4			NN
auto_mounted_tables_accessed	int4			NN
spectrum_file_count	int4			NN
datasharing_spectrum_tables_accessed	int4			NN
lf_datasharing_spectrum_tables_accessed	int4			NN
num_pce_segs	int4			NN
slice_unmerge_query	int4			NN
sample_based_col_count	int4			NN
sketch_based_col_count	int4			NN
userid	int4			NN
sql_feature	char(173)			NN
is_ml_predictor_eligible	int4			NN

pg_catalog.stll_query_abort_reason

old
column	data type	PK	U	NN
recordtime	timestamp			NN
start_time	timestamp			NN
qid	int4			NN
pid	int4			NN
xid	int8			NN
userid	int4			NN
reason	char(32)			NN
exception_msg	char(128)			NN

new
column	data type	PK	U	NN
recordtime	timestamp			NN
start_time	timestamp			NN
qid	int4			NN
pid	int4			NN
xid	int8			NN
userid	int4			NN
reason	char(32)			NN
exception_msg	char(128)			NN
pg_error_msg	char(128)			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

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

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

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

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

pg_internal.redshift_auto_health_check_7092392

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_hdr_integrity_error_redacted

old
column	data type

new
column	data type
recordtime	timestamp
node_num	int4
sb_ver	int8
xid	int8
sb_pos	int4
hdr_dump_redacted	char(209)

pg_catalog.stl_leader_commit_trace

old
column	data type

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

pg_catalog.stl_local_s3_scan_fallback

old
column	data type

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

pg_catalog.stl_mem_alloc_histograms

old
column	data type

new
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

pg_catalog.stl_perf_sink_histogram

old
column	data type

new
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

pg_catalog.stl_perf_source_histogram

old
column	data type

new
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

pg_catalog.stl_pg_function

old
column	data type

new
column	data type
userid	int4
query	int8
functionid	int4

pg_catalog.stl_redcat_logging

old
column	data type

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

pg_catalog.stl_startnode_log

old
column	data type

new
column	data type
message	char(4096)
logtime	timestamp

pg_catalog.stl_watchdog

old
column	data type

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

pg_catalog.stl_arcadia_concurrency_scaling_usage

old
column	data type
userid	int4
recordtime	timestamp
rewritten_qid	int4
user_query_id	int8
child_query_seq	int4
cluster	char(128)
report_arn	char(128)
instance_type	char(128)
num_nodes	int4
starttime	timestamp
endtime	timestamp
request_id	char(36)
incurred_usage_ms	int4
incurred_usage_rpu_ms	int4
rpu	int4
is_cs_at_query	int4
is_multi_az_secondary	int4
resv_model	int4

new
column	data type
userid	int4
recordtime	timestamp
rewritten_qid	int4
user_query_id	int8
child_query_seq	int4
cluster	char(128)
report_arn	char(128)
instance_type	char(128)
num_nodes	int4
starttime	timestamp
endtime	timestamp
request_id	char(36)
incurred_usage_ms	int4
incurred_usage_rpu_ms	int4
rpu	int4
is_cs_at_query	int4
is_multi_az_secondary	int4
resv_model	int4
phantom_burst_query	int4

pg_catalog.stl_arcadia_main_usage

old
column	data type
userid	int4
recordtime	timestamp
xid	int8
cluster	char(128)
report_arn	char(128)
instance_type	char(128)
num_nodes	int4
starttime	timestamp
endtime	timestamp
request_id	char(36)
incurred_usage_ms	int4
incurred_usage_rpu_ms	int4
rpu	int4
resv_model	int4

new
column	data type
userid	int4
recordtime	timestamp
xid	int8
cluster	char(128)
report_arn	char(128)
instance_type	char(128)
num_nodes	int4
starttime	timestamp
endtime	timestamp
request_id	char(36)
incurred_usage_ms	int4
incurred_usage_rpu_ms	int4
rpu	int4
resv_model	int4
phantom_transaction	int4

pg_catalog.stl_compute_elasticity_insert

old
column	data type
query	int4
slice	int4
segment	int4
step	int4
ds_calc_option	int4
parallel_insert_degree	int4
parallel_insert_reason	int4
tbl	int4
rows	int8
cols	int4

new
column	data type
query	int4
slice	int4
segment	int4
step	int4
ds_calc_option	int4
parallel_insert_degree	int4
parallel_insert_reason	int4
tbl	int4
rows	int8
cols	int4
mem_col_bucket_size	int4

pg_catalog.stl_integration_user_activity

old
column	data type
record_time	timestamp
integration_id	char(128)
db_name	char(128)
origin	char(64)
external_time	timestamp
type	char(64)
option	char(64)
message	char(1024)
status	char(1024)

new
column	data type
record_time	timestamp
integration_id	char(128)
db_name	char(128)
origin	char(64)
external_time	timestamp
type	char(64)
option	char(64)
message	char(1024)
status	char(1024)
source_type	char(32)

pg_catalog.stl_internal_query_details

old
column	data type
query	int4
xid	int8
initial_query_time	timestamp
seldispatch_status	int4
query_cmd_type	int4
user_temp_tables_accessed	int4
volt_temp_tables_accessed	int4
spectrum_tables_accessed	int4
user_perm_tables_accessed	int4
system_tables_accessed	int4
query_target_table_type	int4
memory_demanding_info	int8
nobackup_tables_accessed	int4
zindex_tables_accessed	int4
pg_tables_accessed	int4
dirty_tables_read	int4
wlm_slot_type	char(8)
is_short_query	int4
reported_peak_usage_bytes	int8
wlm_query_memory	int8
datasharing_tables_accessed	int4
uses_new_cost_model	char(1)
new_model_reason	int4
num_rowsets	int4
xregion_datasharing_tables_accessed	int4
result_cache_miss_reason	int4
cs_node_nums	int4
is_multi	int4
is_burst_for_at_task	int4
user_query_id	int8
lf_datasharing_tables_accessed	int4
qpc_source_qid	int8
exec_time_wo_compilation	int8
exec_cluster_size	int4
auto_mounted_tables_accessed	int4
spectrum_file_count	int4
datasharing_spectrum_tables_accessed	int4
lf_datasharing_spectrum_tables_accessed	int4
num_pce_segs	int4
slice_unmerge_query	int4
sample_based_col_count	int4
sketch_based_col_count	int4
userid	int4

new
column	data type
query	int4
xid	int8
initial_query_time	timestamp
seldispatch_status	int4
query_cmd_type	int4
user_temp_tables_accessed	int4
volt_temp_tables_accessed	int4
spectrum_tables_accessed	int4
user_perm_tables_accessed	int4
system_tables_accessed	int4
query_target_table_type	int4
memory_demanding_info	int8
nobackup_tables_accessed	int4
zindex_tables_accessed	int4
pg_tables_accessed	int4
dirty_tables_read	int4
wlm_slot_type	char(8)
is_short_query	int4
reported_peak_usage_bytes	int8
wlm_query_memory	int8
datasharing_tables_accessed	int4
uses_new_cost_model	char(1)
new_model_reason	int4
num_rowsets	int4
xregion_datasharing_tables_accessed	int4
result_cache_miss_reason	int4
cs_node_nums	int4
is_multi	int4
is_burst_for_at_task	int4
user_query_id	int8
lf_datasharing_tables_accessed	int4
qpc_source_qid	int8
exec_time_wo_compilation	int8
exec_cluster_size	int4
auto_mounted_tables_accessed	int4
spectrum_file_count	int4
datasharing_spectrum_tables_accessed	int4
lf_datasharing_spectrum_tables_accessed	int4
num_pce_segs	int4
slice_unmerge_query	int4
sample_based_col_count	int4
sketch_based_col_count	int4
userid	int4
sql_feature	char(173)
is_ml_predictor_eligible	int4

pg_catalog.stl_query_abort_reason

old
column	data type
recordtime	timestamp
start_time	timestamp
qid	int4
pid	int4
xid	int8
userid	int4
reason	char(32)
exception_msg	char(128)

new
column	data type
recordtime	timestamp
start_time	timestamp
qid	int4
pid	int4
xid	int8
userid	int4
reason	char(32)
exception_msg	char(128)
pg_error_msg	char(128)

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

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)

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

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

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)