Redshift Observatory System Table Tracker

Functions

Status	Schema	Language	Volatility	Return	Function	Arguments
new	pg_catalog	internal	immutable	geometry	st_geomfromgeojson	super

Tables

pg_catalog.pg_cdc_checkpoint_cache

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
ckp_seq_num	int8			NN
integration_id	name			NN
remote_db_name	name			NN
checkpoint	name			NN

pg_catalog.stcs_awsidc_active_session_group_sync_worker

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
vpid	int4			NN
starttime	int8			NN
endtime	int8			NN
num_awsidc_users_monitored	int4			NN
num_users_updated	int4			NN
total_roles_processed	int4			NN
exception	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_block_hdr_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
now	int8			NN
since	int8			NN
node	int4			NN
total_count_in_sh_mem	int4			NN
total_count_in_superblock	int4			NN
num_sh_mem_adds	int4			NN
num_sh_mem_tosses	int4			NN
num_sb_adds	int4			NN
num_sb_tosses	int4			NN
num_alloc_fails	int4			NN
sh_mem_fragmentation	float8			NN
sb_fragmentation	float8			NN
hdr_sh_mem_usage	float8			NN
sh_mem_percentage	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_codegen_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
query	int4			NN
segment	int4			NN
pid	int4			NN
codegen_starttime	int8			NN
codegen_endtime	int8			NN
ir_gen_starttime	int8			NN
ir_gen_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_global_credentials_cache_worker

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
vpid	int4			NN
starttime	int8			NN
endtime	int8			NN
total_num_creds_in_cache	int4			NN
total_num_creds_removed	int4			NN
exception	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_jit_analyze_log

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
pid	int8			NN
xid	int8			NN
user_query_id	int8			NN
child_query_id	int8			NN
eventtime	int8			NN
database_name	char(128)			NN
external_schema_name	char(128)			NN
table_name	char(136)			NN
table_id	int4			NN
message	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

pg_catalog.stcs_jit_exec_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
query	int4			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
pid	int4			NN
jitting_starttime	int8			NN
jitting_endtime	int8			NN
exec_starttime	int8			NN
exec_endtime	int8			NN
memory_used	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_reguid

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	int8			NN
node	int4			NN
slice	int4			NN
tbl_id	int4			NN
sb_pos	int4			NN
original_guid	char(64)			NN
new_guid	char(64)			NN
reguid_count	int4			NN
reguid_reason	char(64)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_remote_flush_time_breakdown

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
xid	int8			NN
query	int8			NN
tbl_id	int4			NN
step	char(64)			NN
step_start_time	int8			NN
step_end_time	int8			NN
step_total_time_us	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_remote_ship_time_breakdown

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
xid	int8			NN
query	int8			NN
tbl_id	int4			NN
step	char(64)			NN
step_start_time	int8			NN
step_end_time	int8			NN
step_total_time_us	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_remote_writeback_time_breakdown

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
tbl_id	int4			NN
id	char(64)			NN
data_block_guid	char(64)			NN
step	char(64)			NN
step_start_time	int8			NN
step_end_time	int8			NN
step_total_time_us	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_s3client_error_internal

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
sliceid	int4			NN
recordtime	int8			NN
pid	int4			NN
http_method	char(64)			NN
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
error	char(1024)			NN
retry_count	int4			NN
curl_code	int4			NN
start_time	int8			NN
resolve_time	int8			NN
connect_time	int8			NN
transfer_size	int8			NN
node	int4			NN
table_id	int4			NN
one_perm_rep	int4			NN
flags	int4			NN
s3_write_type	char(64)			NN
is_s3commit_write	int4			NN
is_partial	int4			NN
start_offset	int8			NN
col_num	int4			NN
is_wam_write	int4			NN
wam_precommit_id	int4			NN
region	char(64)			NN
is_xregion	int4			NN
segment	int8			NN
sb_pos	int4			NN
access_control	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_tbl_perm_at_create

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
table_id	int4			NN
node	int4			NN
dist_style	int4			NN
temp	int4			NN
eventtime	int8			NN
xid	int8			NN
name	char(128)			NN
topology	int8			NN
encrypted	int4			NN
rowid_encoding	int4			NN
is_storage_oid	int4			NN
db_id	int4			NN
namespace_id	int4			NN
num_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

pg_catalog.stcs_user_permission_log

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
pid	int4			NN
xid	int8			NN
query	int8			NN
recordtime	int8			NN
userid	int4			NN
dbid	int4			NN
objtype	int4			NN
objid	int4			NN
objsubid	int4			NN
accessrequested	int4			NN
accessgranted	int4			NN
accessmode	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stll_awsidc_active_session_group_sync_worker

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
vpid	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
num_awsidc_users_monitored	int4			NN
num_users_updated	int4			NN
total_roles_processed	int4			NN
exception	int4			NN

pg_catalog.stll_block_hdr_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
now	timestamp			NN
since	timestamp			NN
node	int4			NN
total_count_in_sh_mem	int4			NN
total_count_in_superblock	int4			NN
num_sh_mem_adds	int4			NN
num_sh_mem_tosses	int4			NN
num_sb_adds	int4			NN
num_sb_tosses	int4			NN
num_alloc_fails	int4			NN
sh_mem_fragmentation	float8			NN
sb_fragmentation	float8			NN
hdr_sh_mem_usage	float8			NN
sh_mem_percentage	float8			NN

pg_catalog.stll_codegen_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
query	int4			NN
segment	int4			NN
pid	int4			NN
codegen_starttime	timestamp			NN
codegen_endtime	timestamp			NN
ir_gen_starttime	timestamp			NN
ir_gen_endtime	timestamp			NN

pg_catalog.stll_global_credentials_cache_worker

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
vpid	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
total_num_creds_in_cache	int4			NN
total_num_creds_removed	int4			NN
exception	int4			NN

pg_catalog.stll_jit_analyze_log

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
user_id	int4			NN
pid	int8			NN
xid	int8			NN
user_query_id	int8			NN
child_query_id	int8			NN
eventtime	timestamp			NN
database_name	char(128)			NN
external_schema_name	char(128)			NN
table_name	char(136)			NN
table_id	int4			NN
message	char(1024)			NN

pg_catalog.stll_jit_exec_stats

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
xid	int8			NN
query	int4			NN
segment	int4			NN
node	int4			NN
slice	int4			NN
pid	int4			NN
jitting_starttime	timestamp			NN
jitting_endtime	timestamp			NN
exec_starttime	timestamp			NN
exec_endtime	timestamp			NN
memory_used	int8			NN

pg_catalog.stll_reguid

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
recordtime	timestamp			NN
node	int4			NN
slice	int4			NN
tbl_id	int4			NN
sb_pos	int4			NN
original_guid	char(64)			NN
new_guid	char(64)			NN
reguid_count	int4			NN
reguid_reason	char(64)			NN

pg_catalog.stll_remote_flush_time_breakdown

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
xid	int8			NN
query	int8			NN
tbl_id	int4			NN
step	char(64)			NN
step_start_time	timestamp			NN
step_end_time	timestamp			NN
step_total_time_us	float8			NN

pg_catalog.stll_remote_ship_time_breakdown

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
xid	int8			NN
query	int8			NN
tbl_id	int4			NN
step	char(64)			NN
step_start_time	timestamp			NN
step_end_time	timestamp			NN
step_total_time_us	float8			NN

pg_catalog.stll_remote_writeback_time_breakdown

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
node	int4			NN
tbl_id	int4			NN
id	char(64)			NN
data_block_guid	char(64)			NN
step	char(64)			NN
step_start_time	timestamp			NN
step_end_time	timestamp			NN
step_total_time_us	float8			NN

pg_catalog.stll_s3client_error_internal

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
sliceid	int4			NN
recordtime	timestamp			NN
pid	int4			NN
http_method	char(64)			NN
s3_action	char(64)			NN
bucket	char(64)			NN
key	char(256)			NN
error	char(1024)			NN
retry_count	int4			NN
curl_code	int4			NN
start_time	timestamp			NN
resolve_time	int8			NN
connect_time	int8			NN
transfer_size	int8			NN
node	int4			NN
table_id	int4			NN
one_perm_rep	int4			NN
flags	int4			NN
s3_write_type	char(64)			NN
is_s3commit_write	int4			NN
is_partial	int4			NN
start_offset	int8			NN
col_num	int4			NN
is_wam_write	int4			NN
wam_precommit_id	int4			NN
region	char(64)			NN
is_xregion	int4			NN
segment	int8			NN
sb_pos	int4			NN
access_control	int4			NN

pg_catalog.stll_tbl_perm_at_create

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
table_id	int4			NN
node	int4			NN
dist_style	int4			NN
temp	int4			NN
eventtime	timestamp			NN
xid	int8			NN
name	char(128)			NN
topology	int8			NN
encrypted	int4			NN
rowid_encoding	int4			NN
is_storage_oid	int4			NN
db_id	int4			NN
namespace_id	int4			NN
num_cols	int4			NN

pg_catalog.stll_user_permission_log

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
pid	int4			NN
xid	int8			NN
query	int8			NN
recordtime	timestamp			NN
userid	int4			NN
dbid	int4			NN
objtype	int4			NN
objid	int4			NN
objsubid	int4			NN
accessrequested	int4			NN
accessgranted	int4			NN
accessmode	int4			NN

pg_internal.redshift_auto_health_check_8783999

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
a	int4

pg_catalog.stcs_burst_billing_ris_reports

old
column	data type	PK	U	NN
request_id	char(100)			NN
billing_time	char(100)			NN
usage_sec	int4			NN
cluster_arn	char(128)			NN
log_time	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
request_id	char(100)			NN
billing_time	char(100)			NN
usage_sec	int4			NN
cluster_arn	char(128)			NN
log_time	int8			NN
is_auto_task	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_burst_soid_requests

old
column	data type	PK	U	NN
pid	int4			NN
write_xid	int8			NN
type	int4			NN
starttime	int8			NN
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
pid	int4			NN
write_xid	int8			NN
type	int4			NN
starttime	int8			NN
endtime	int8			NN
connection_guid	char(100)			NN
reuse_conn	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_burst_write_exec

old
column	data type	PK	U	NN
pid	int8			NN
xid	int8			NN
query	int8			NN
query_start_time	int8			NN
flush_start_time	int8			NN
stream_start_time	int8			NN
stream_end_time	int8			NN
dispatch_start_time	int8			NN
snap_in_start_time	int8			NN
snap_in_end_time	int8			NN
dispatch_end_time	int8			NN
remote_write_type	int4			NN
receiver_wam_tracking_start	int8			NN
wam_delete_start_time	int8			NN
wam_delete_end_time	int8			NN
is_distall_synchronization	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
pid	int8			NN
xid	int8			NN
query	int8			NN
query_start_time	int8			NN
flush_start_time	int8			NN
stream_start_time	int8			NN
stream_end_time	int8			NN
dispatch_start_time	int8			NN
snap_in_start_time	int8			NN
snap_in_end_time	int8			NN
dispatch_end_time	int8			NN
remote_write_type	int4			NN
receiver_wam_tracking_start	int8			NN
wam_delete_start_time	int8			NN
wam_delete_end_time	int8			NN
is_distall_synchronization	int4			NN
hollow_temp_create_start_time	int8			NN
hollow_temp_create_end_time	int8			NN
soid_grafting_start_time	int8			NN
soid_grafting_end_time	int8			NN
soid_refresh_start_time	int8			NN
soid_refresh_end_time	int8			NN
write_target_lock_acquire_start_time	int8			NN
write_target_lock_acquire_end_time	int8			NN
write_target_lock_release_start_time	int8			NN
write_target_lock_release_end_time	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_concurrency_scaling_usage

old
column	data type	PK	U	NN
recordtime	int8			NN
query	int4			NN
cluster	char(128)			NN
starttime	int8			NN
endtime	int8			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
is_cs_at_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

new
column	data type	PK	U	NN
recordtime	int8			NN
query	int4			NN
cluster	char(128)			NN
starttime	int8			NN
endtime	int8			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
is_cs_at_query	int4			NN
is_auto_task	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_guid_based_cache_policy_stats

old
column	data type	PK	U	NN
node_num	int4			NN
promote_untracked_to_cold_untouch	int8			NN
promote_cold_untouch_to_cold_touch	int8			NN
promote_cold_touch_to_hot_untouch	int8			NN
promote_hot_untouch_to_hot_touch	int8			NN
reaccess_hot_touch	int8			NN
demote_hot_touch_to_hot_untouch	int8			NN
demote_hot_untouch_to_cold_touch	int8			NN
demote_cold_touch_to_cold_untouch	int8			NN
demote_cold_untouch_to_untracked	int8			NN
cold_blocks	int8			NN
hot_blocks	int8			NN
blocks_in_cache	int8			NN
start_time	int8			NN
end_time	int8			NN
capacity	int8			NN
write_accesses	int8			NN
rerep_writes	int8			NN
hot_touched_blocks	int8			NN
hot_untouched_blocks	int8			NN
cold_touched_blocks	int8			NN
cold_untouched_blocks	int8			NN
ghost_buffer_hits	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
node_num	int4			NN
promote_untracked_to_cold_untouch	int8			NN
promote_cold_untouch_to_cold_touch	int8			NN
promote_cold_touch_to_hot_untouch	int8			NN
promote_hot_untouch_to_hot_touch	int8			NN
reaccess_hot_touch	int8			NN
demote_hot_touch_to_hot_untouch	int8			NN
demote_hot_untouch_to_cold_touch	int8			NN
demote_cold_touch_to_cold_untouch	int8			NN
demote_cold_untouch_to_untracked	int8			NN
cold_blocks	int8			NN
hot_blocks	int8			NN
blocks_in_cache	int8			NN
start_time	int8			NN
end_time	int8			NN
capacity	int8			NN
write_accesses	int8			NN
rerep_writes	int8			NN
hot_touched_blocks	int8			NN
hot_untouched_blocks	int8			NN
cold_touched_blocks	int8			NN
cold_untouched_blocks	int8			NN
ghost_buffer_hits	int8			NN
timedout_evictions	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_insert

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
tbl	int4			NN
inserted_mega_value	char(1)			NN
use_staging_table	char(1)			NN
write_xid	int8			NN
reserve_rowid	int4			NN
access_control	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
tbl	int4			NN
inserted_mega_value	char(1)			NN
use_staging_table	char(1)			NN
write_xid	int8			NN
reserve_rowid	int4			NN
access_control	int4			NN
num_partitions	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_leader_commit_trace

old
column	data type	PK	U	NN
xid	int8			NN
recordtime	int8			NN
batched_by	int8			NN
sb_version	int4			NN
xen_commit_level	int4			NN
queuelen	int8			NN
dsw_xact	int4			NN
burst_write	int4			NN
step	char(100)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
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
pid	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_leader_snapshot

old
column	data type	PK	U	NN
currenttime	int8			NN
num_snapshot_blocks	int4			NN
snapshot_creation_duration	int8			NN
persist_duration	int8			NN
last_wal_chain_block_num	int4			NN
pid	int4			NN
xid	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
currenttime	int8			NN
num_snapshot_blocks	int4			NN
snapshot_creation_duration	int8			NN
persist_duration	int8			NN
last_wal_chain_block_num	int4			NN
pid	int4			NN
xid	int8			NN
is_postinit_snapshot	char(1)			NN
is_worker_snapshot	char(1)			NN
wal_bloat_sz_truncated_in_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_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
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

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

pg_catalog.stcs_sort

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
checksum	int8			NN
used_mega_block	char(1)			NN
memory_usage_ratio	int4			NN
access_control	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	int8			NN
endtime	int8			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
checksum	int8			NN
used_mega_block	char(1)			NN
memory_usage_ratio	int4			NN
access_control	int4			NN
parallel_merge	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_storage_oid_events

old
column	data type	PK	U	NN
xid	int8			NN
event	char(256)			NN
table_id	int4			NN
remote_oid	int4			NN
userid	int4			NN
pid	int4			NN
recordtime	int8			NN
current_dml_version	int8			NN
current_structure_version	int8			NN
current_sb_version	int8			NN
current_ddl_version	int8			NN
host	char(256)			NN
database	char(256)			NN
schema	char(256)			NN
table_name	char(256)			NN
table_size	int8			NN
dirtiness_type	char(20)			NN
total_grafted_superblock_size	int8			NN
storage_oid_table_count	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
xid	int8			NN
event	char(256)			NN
table_id	int4			NN
remote_oid	int4			NN
userid	int4			NN
pid	int4			NN
recordtime	int8			NN
current_dml_version	int8			NN
current_structure_version	int8			NN
current_sb_version	int8			NN
current_ddl_version	int8			NN
host	char(256)			NN
database	char(256)			NN
schema	char(256)			NN
table_name	char(256)			NN
table_size	int8			NN
dirtiness_type	char(20)			NN
total_grafted_superblock_size	int8			NN
storage_oid_table_count	int4			NN
ref_count	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_udf_usage_in_query

old
column	data type	PK	U	NN
query	int4			NN
nodeid	int4			NN
plan_node_type	int4			NN
func_id	int4			NN
func_name	char(200)			NN
func_type	int4			NN
in_targetlist	int4			NN
recordtime	int8			NN
in_case_expr	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
nodeid	int4			NN
plan_node_type	int4			NN
func_id	int4			NN
func_name	char(200)			NN
func_type	int4			NN
in_targetlist	int4			NN
recordtime	int8			NN
in_case_expr	int4			NN
join_side	int4			NN
nested_udf	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stll_burst_billing_ris_reports

old
column	data type	PK	U	NN
request_id	char(100)			NN
billing_time	char(100)			NN
usage_sec	int4			NN
cluster_arn	char(128)			NN
log_time	timestamp			NN

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

pg_catalog.stll_burst_soid_requests

old
column	data type	PK	U	NN
pid	int4			NN
write_xid	int8			NN
type	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN

new
column	data type	PK	U	NN
pid	int4			NN
write_xid	int8			NN
type	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
connection_guid	char(100)			NN
reuse_conn	char(1)			NN

pg_catalog.stll_burst_write_exec

old
column	data type	PK	U	NN
pid	int8			NN
xid	int8			NN
query	int8			NN
query_start_time	timestamp			NN
flush_start_time	timestamp			NN
stream_start_time	timestamp			NN
stream_end_time	timestamp			NN
dispatch_start_time	timestamp			NN
snap_in_start_time	timestamp			NN
snap_in_end_time	timestamp			NN
dispatch_end_time	timestamp			NN
remote_write_type	int4			NN
receiver_wam_tracking_start	timestamp			NN
wam_delete_start_time	timestamp			NN
wam_delete_end_time	timestamp			NN
is_distall_synchronization	int4			NN

new
column	data type	PK	U	NN
pid	int8			NN
xid	int8			NN
query	int8			NN
query_start_time	timestamp			NN
flush_start_time	timestamp			NN
stream_start_time	timestamp			NN
stream_end_time	timestamp			NN
dispatch_start_time	timestamp			NN
snap_in_start_time	timestamp			NN
snap_in_end_time	timestamp			NN
dispatch_end_time	timestamp			NN
remote_write_type	int4			NN
receiver_wam_tracking_start	timestamp			NN
wam_delete_start_time	timestamp			NN
wam_delete_end_time	timestamp			NN
is_distall_synchronization	int4			NN
hollow_temp_create_start_time	timestamp			NN
hollow_temp_create_end_time	timestamp			NN
soid_grafting_start_time	timestamp			NN
soid_grafting_end_time	timestamp			NN
soid_refresh_start_time	timestamp			NN
soid_refresh_end_time	timestamp			NN
write_target_lock_acquire_start_time	timestamp			NN
write_target_lock_acquire_end_time	timestamp			NN
write_target_lock_release_start_time	timestamp			NN
write_target_lock_release_end_time	timestamp			NN

pg_catalog.stll_concurrency_scaling_usage

old
column	data type	PK	U	NN
recordtime	timestamp			NN
query	int4			NN
cluster	char(128)			NN
starttime	timestamp			NN
endtime	timestamp			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
is_cs_at_query	int4			NN

new
column	data type	PK	U	NN
recordtime	timestamp			NN
query	int4			NN
cluster	char(128)			NN
starttime	timestamp			NN
endtime	timestamp			NN
request_id	char(36)			NN
incurred_usage_ms	int4			NN
is_cs_at_query	int4			NN
is_auto_task	int4			NN

pg_catalog.stll_guid_based_cache_policy_stats

old
column	data type	PK	U	NN
node_num	int4			NN
promote_untracked_to_cold_untouch	int8			NN
promote_cold_untouch_to_cold_touch	int8			NN
promote_cold_touch_to_hot_untouch	int8			NN
promote_hot_untouch_to_hot_touch	int8			NN
reaccess_hot_touch	int8			NN
demote_hot_touch_to_hot_untouch	int8			NN
demote_hot_untouch_to_cold_touch	int8			NN
demote_cold_touch_to_cold_untouch	int8			NN
demote_cold_untouch_to_untracked	int8			NN
cold_blocks	int8			NN
hot_blocks	int8			NN
blocks_in_cache	int8			NN
start_time	timestamp			NN
end_time	timestamp			NN
capacity	int8			NN
write_accesses	int8			NN
rerep_writes	int8			NN
hot_touched_blocks	int8			NN
hot_untouched_blocks	int8			NN
cold_touched_blocks	int8			NN
cold_untouched_blocks	int8			NN
ghost_buffer_hits	int8			NN

new
column	data type	PK	U	NN
node_num	int4			NN
promote_untracked_to_cold_untouch	int8			NN
promote_cold_untouch_to_cold_touch	int8			NN
promote_cold_touch_to_hot_untouch	int8			NN
promote_hot_untouch_to_hot_touch	int8			NN
reaccess_hot_touch	int8			NN
demote_hot_touch_to_hot_untouch	int8			NN
demote_hot_untouch_to_cold_touch	int8			NN
demote_cold_touch_to_cold_untouch	int8			NN
demote_cold_untouch_to_untracked	int8			NN
cold_blocks	int8			NN
hot_blocks	int8			NN
blocks_in_cache	int8			NN
start_time	timestamp			NN
end_time	timestamp			NN
capacity	int8			NN
write_accesses	int8			NN
rerep_writes	int8			NN
hot_touched_blocks	int8			NN
hot_untouched_blocks	int8			NN
cold_touched_blocks	int8			NN
cold_untouched_blocks	int8			NN
ghost_buffer_hits	int8			NN
timedout_evictions	int8			NN

pg_catalog.stll_insert

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
tbl	int4			NN
inserted_mega_value	char(1)			NN
use_staging_table	char(1)			NN
write_xid	int8			NN
reserve_rowid	int4			NN
access_control	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
tbl	int4			NN
inserted_mega_value	char(1)			NN
use_staging_table	char(1)			NN
write_xid	int8			NN
reserve_rowid	int4			NN
access_control	int4			NN
num_partitions	int4			NN

pg_catalog.stll_leader_commit_trace

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

new
column	data type	PK	U	NN
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
pid	int8			NN

pg_catalog.stll_leader_snapshot

old
column	data type	PK	U	NN
currenttime	timestamp			NN
num_snapshot_blocks	int4			NN
snapshot_creation_duration	int8			NN
persist_duration	int8			NN
last_wal_chain_block_num	int4			NN
pid	int4			NN
xid	int8			NN

new
column	data type	PK	U	NN
currenttime	timestamp			NN
num_snapshot_blocks	int4			NN
snapshot_creation_duration	int8			NN
persist_duration	int8			NN
last_wal_chain_block_num	int4			NN
pid	int4			NN
xid	int8			NN
is_postinit_snapshot	char(1)			NN
is_worker_snapshot	char(1)			NN
wal_bloat_sz_truncated_in_kb	int8			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
pg_error_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(512)			NN

pg_catalog.stll_sort

old
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
checksum	int8			NN
used_mega_block	char(1)			NN
memory_usage_ratio	int4			NN
access_control	int4			NN

new
column	data type	PK	U	NN
userid	int4			NN
query	int4			NN
slice	int4			NN
segment	int4			NN
step	int4			NN
starttime	timestamp			NN
endtime	timestamp			NN
tasknum	int4			NN
rows	int8			NN
bytes	int8			NN
tbl	int4			NN
is_diskbased	char(1)			NN
workmem	int8			NN
checksum	int8			NN
used_mega_block	char(1)			NN
memory_usage_ratio	int4			NN
access_control	int4			NN
parallel_merge	char(1)			NN

pg_catalog.stll_storage_oid_events

old
column	data type	PK	U	NN
xid	int8			NN
event	char(256)			NN
table_id	int4			NN
remote_oid	int4			NN
userid	int4			NN
pid	int4			NN
recordtime	timestamp			NN
current_dml_version	int8			NN
current_structure_version	int8			NN
current_sb_version	int8			NN
current_ddl_version	int8			NN
host	char(256)			NN
database	char(256)			NN
schema	char(256)			NN
table_name	char(256)			NN
table_size	int8			NN
dirtiness_type	char(20)			NN
total_grafted_superblock_size	int8			NN
storage_oid_table_count	int4			NN

new
column	data type	PK	U	NN
xid	int8			NN
event	char(256)			NN
table_id	int4			NN
remote_oid	int4			NN
userid	int4			NN
pid	int4			NN
recordtime	timestamp			NN
current_dml_version	int8			NN
current_structure_version	int8			NN
current_sb_version	int8			NN
current_ddl_version	int8			NN
host	char(256)			NN
database	char(256)			NN
schema	char(256)			NN
table_name	char(256)			NN
table_size	int8			NN
dirtiness_type	char(20)			NN
total_grafted_superblock_size	int8			NN
storage_oid_table_count	int4			NN
ref_count	int4			NN

pg_catalog.stll_udf_usage_in_query

old
column	data type	PK	U	NN
query	int4			NN
nodeid	int4			NN
plan_node_type	int4			NN
func_id	int4			NN
func_name	char(200)			NN
func_type	int4			NN
in_targetlist	int4			NN
recordtime	timestamp			NN
in_case_expr	int4			NN

new
column	data type	PK	U	NN
query	int4			NN
nodeid	int4			NN
plan_node_type	int4			NN
func_id	int4			NN
func_name	char(200)			NN
func_type	int4			NN
in_targetlist	int4			NN
recordtime	timestamp			NN
in_case_expr	int4			NN
join_side	int4			NN
nested_udf	int4			NN

pg_catalog.stv_alter_dist_sort

old
column	data type	PK	U	NN
xid	int8			NN
reloid	int4			NN
alter_type	int4			NN
data_tbl	int4			NN
shadow_tbl	int4			NN
stage	int4			NN

new
column	data type	PK	U	NN
xid	int8			NN
reloid	int4			NN
alter_type	int4			NN
data_tbl	int4			NN
shadow_tbl	int4			NN
stage	int4			NN
controller_uuid	char(64)			NN

pg_internal.redshift_auto_health_check_8659974

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_awsidc_active_session_group_sync_worker

old
column	data type

new
column	data type
vpid	int4
starttime	timestamp
endtime	timestamp
num_awsidc_users_monitored	int4
num_users_updated	int4
total_roles_processed	int4
exception	int4

pg_catalog.stl_block_hdr_stats

old
column	data type

new
column	data type
now	timestamp
since	timestamp
node	int4
total_count_in_sh_mem	int4
total_count_in_superblock	int4
num_sh_mem_adds	int4
num_sh_mem_tosses	int4
num_sb_adds	int4
num_sb_tosses	int4
num_alloc_fails	int4
sh_mem_fragmentation	float8
sb_fragmentation	float8
hdr_sh_mem_usage	float8
sh_mem_percentage	float8

pg_catalog.stl_codegen_stats

old
column	data type

new
column	data type
userid	int4
xid	int8
query	int4
segment	int4
pid	int4
codegen_starttime	timestamp
codegen_endtime	timestamp
ir_gen_starttime	timestamp
ir_gen_endtime	timestamp

pg_catalog.stl_global_credentials_cache_worker

old
column	data type

new
column	data type
vpid	int4
starttime	timestamp
endtime	timestamp
total_num_creds_in_cache	int4
total_num_creds_removed	int4
exception	int4

pg_catalog.stl_jit_analyze_log

old
column	data type

new
column	data type
user_id	int4
pid	int8
xid	int8
user_query_id	int8
child_query_id	int8
eventtime	timestamp
database_name	char(128)
external_schema_name	char(128)
table_name	char(136)
table_id	int4
message	char(1024)

pg_catalog.stl_jit_exec_stats

old
column	data type

new
column	data type
userid	int4
xid	int8
query	int4
segment	int4
node	int4
slice	int4
pid	int4
jitting_starttime	timestamp
jitting_endtime	timestamp
exec_starttime	timestamp
exec_endtime	timestamp
memory_used	int8

pg_catalog.stl_reguid

old
column	data type

new
column	data type
recordtime	timestamp
node	int4
slice	int4
tbl_id	int4
sb_pos	int4
original_guid	char(64)
new_guid	char(64)
reguid_count	int4
reguid_reason	char(64)

pg_catalog.stl_remote_flush_time_breakdown

old
column	data type

new
column	data type
node	int4
xid	int8
query	int8
tbl_id	int4
step	char(64)
step_start_time	timestamp
step_end_time	timestamp
step_total_time_us	float8

pg_catalog.stl_remote_ship_time_breakdown

old
column	data type

new
column	data type
node	int4
xid	int8
query	int8
tbl_id	int4
step	char(64)
step_start_time	timestamp
step_end_time	timestamp
step_total_time_us	float8

pg_catalog.stl_remote_writeback_time_breakdown

old
column	data type

new
column	data type
node	int4
tbl_id	int4
id	char(64)
data_block_guid	char(64)
step	char(64)
step_start_time	timestamp
step_end_time	timestamp
step_total_time_us	float8

pg_catalog.stl_s3client_error_internal

old
column	data type

new
column	data type
userid	int4
query	int4
sliceid	int4
recordtime	timestamp
pid	int4
http_method	char(64)
s3_action	char(64)
bucket	char(64)
key	char(256)
error	char(1024)
retry_count	int4
curl_code	int4
start_time	timestamp
resolve_time	int8
connect_time	int8
transfer_size	int8
node	int4
table_id	int4
one_perm_rep	int4
flags	int4
s3_write_type	char(64)
is_s3commit_write	int4
is_partial	int4
start_offset	int8
col_num	int4
is_wam_write	int4
wam_precommit_id	int4
region	char(64)
is_xregion	int4
segment	int8
sb_pos	int4

pg_catalog.stl_tbl_perm_at_create

old
column	data type

new
column	data type
table_id	int4
node	int4
dist_style	int4
temp	int4
eventtime	timestamp
xid	int8
name	char(128)
topology	int8
encrypted	int4
rowid_encoding	int4
is_storage_oid	int4
db_id	int4
namespace_id	int4
num_cols	int4

pg_catalog.stl_user_permission_log

old
column	data type

new
column	data type
pid	int4
xid	int8
query	int8
recordtime	timestamp
userid	int4
dbid	int4
objtype	int4
objid	int4
objsubid	int4
accessrequested	int4
accessgranted	int4
accessmode	int4

pg_catalog.stl_burst_billing_ris_reports

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

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

pg_catalog.stl_burst_soid_requests

old
column	data type
pid	int4
write_xid	int8
type	int4
starttime	timestamp
endtime	timestamp

new
column	data type
pid	int4
write_xid	int8
type	int4
starttime	timestamp
endtime	timestamp
connection_guid	char(100)
reuse_conn	char(1)

pg_catalog.stl_burst_write_exec

old
column	data type
pid	int8
xid	int8
query	int8
query_start_time	timestamp
flush_start_time	timestamp
stream_start_time	timestamp
stream_end_time	timestamp
dispatch_start_time	timestamp
snap_in_start_time	timestamp
snap_in_end_time	timestamp
dispatch_end_time	timestamp
remote_write_type	int4
receiver_wam_tracking_start	timestamp
wam_delete_start_time	timestamp
wam_delete_end_time	timestamp
is_distall_synchronization	int4

new
column	data type
pid	int8
xid	int8
query	int8
query_start_time	timestamp
flush_start_time	timestamp
stream_start_time	timestamp
stream_end_time	timestamp
dispatch_start_time	timestamp
snap_in_start_time	timestamp
snap_in_end_time	timestamp
dispatch_end_time	timestamp
remote_write_type	int4
receiver_wam_tracking_start	timestamp
wam_delete_start_time	timestamp
wam_delete_end_time	timestamp
is_distall_synchronization	int4
hollow_temp_create_start_time	timestamp
hollow_temp_create_end_time	timestamp
soid_grafting_start_time	timestamp
soid_grafting_end_time	timestamp
soid_refresh_start_time	timestamp
soid_refresh_end_time	timestamp
write_target_lock_acquire_start_time	timestamp
write_target_lock_acquire_end_time	timestamp
write_target_lock_release_start_time	timestamp
write_target_lock_release_end_time	timestamp

pg_catalog.stl_concurrency_scaling_usage

old
column	data type
recordtime	timestamp
query	int4
cluster	char(128)
starttime	timestamp
endtime	timestamp
request_id	char(36)
incurred_usage_ms	int4
is_cs_at_query	int4

new
column	data type
recordtime	timestamp
query	int4
cluster	char(128)
starttime	timestamp
endtime	timestamp
request_id	char(36)
incurred_usage_ms	int4
is_cs_at_query	int4
is_auto_task	int4

pg_catalog.stl_guid_based_cache_policy_stats

old
column	data type
node_num	int4
promote_untracked_to_cold_untouch	int8
promote_cold_untouch_to_cold_touch	int8
promote_cold_touch_to_hot_untouch	int8
promote_hot_untouch_to_hot_touch	int8
reaccess_hot_touch	int8
demote_hot_touch_to_hot_untouch	int8
demote_hot_untouch_to_cold_touch	int8
demote_cold_touch_to_cold_untouch	int8
demote_cold_untouch_to_untracked	int8
cold_blocks	int8
hot_blocks	int8
blocks_in_cache	int8
start_time	timestamp
end_time	timestamp
capacity	int8
write_accesses	int8
rerep_writes	int8
hot_touched_blocks	int8
hot_untouched_blocks	int8
cold_touched_blocks	int8
cold_untouched_blocks	int8
ghost_buffer_hits	int8

new
column	data type
node_num	int4
promote_untracked_to_cold_untouch	int8
promote_cold_untouch_to_cold_touch	int8
promote_cold_touch_to_hot_untouch	int8
promote_hot_untouch_to_hot_touch	int8
reaccess_hot_touch	int8
demote_hot_touch_to_hot_untouch	int8
demote_hot_untouch_to_cold_touch	int8
demote_cold_touch_to_cold_untouch	int8
demote_cold_untouch_to_untracked	int8
cold_blocks	int8
hot_blocks	int8
blocks_in_cache	int8
start_time	timestamp
end_time	timestamp
capacity	int8
write_accesses	int8
rerep_writes	int8
hot_touched_blocks	int8
hot_untouched_blocks	int8
cold_touched_blocks	int8
cold_untouched_blocks	int8
ghost_buffer_hits	int8
timedout_evictions	int8

pg_catalog.stl_insert

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
tbl	int4
inserted_mega_value	char(1)
use_staging_table	char(1)
write_xid	int8
reserve_rowid	int4

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
tbl	int4
inserted_mega_value	char(1)
use_staging_table	char(1)
write_xid	int8
reserve_rowid	int4
num_partitions	int4

pg_catalog.stl_leader_commit_trace

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

new
column	data type
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)
pid	int8

pg_catalog.stl_leader_snapshot

old
column	data type
currenttime	timestamp
num_snapshot_blocks	int4
snapshot_creation_duration	int8
persist_duration	int8
last_wal_chain_block_num	int4
pid	int4
xid	int8

new
column	data type
currenttime	timestamp
num_snapshot_blocks	int4
snapshot_creation_duration	int8
persist_duration	int8
last_wal_chain_block_num	int4
pid	int4
xid	int8
is_postinit_snapshot	char(1)
is_worker_snapshot	char(1)
wal_bloat_sz_truncated_in_kb	int8

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

pg_catalog.stl_sort

old
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
tbl	int4
is_diskbased	char(1)
workmem	int8
checksum	int8
used_mega_block	char(1)
memory_usage_ratio	int4

new
column	data type
userid	int4
query	int4
slice	int4
segment	int4
step	int4
starttime	timestamp
endtime	timestamp
tasknum	int4
rows	int8
bytes	int8
tbl	int4
is_diskbased	char(1)
workmem	int8
checksum	int8
used_mega_block	char(1)
memory_usage_ratio	int4
parallel_merge	char(1)

pg_catalog.stl_storage_oid_events

old
column	data type
xid	int8
event	char(256)
table_id	int4
remote_oid	int4
userid	int4
pid	int4
recordtime	timestamp
current_dml_version	int8
current_structure_version	int8
current_sb_version	int8
current_ddl_version	int8
host	char(256)
database	char(256)
schema	char(256)
table_name	char(256)
table_size	int8
dirtiness_type	char(20)
total_grafted_superblock_size	int8
storage_oid_table_count	int4

new
column	data type
xid	int8
event	char(256)
table_id	int4
remote_oid	int4
userid	int4
pid	int4
recordtime	timestamp
current_dml_version	int8
current_structure_version	int8
current_sb_version	int8
current_ddl_version	int8
host	char(256)
database	char(256)
schema	char(256)
table_name	char(256)
table_size	int8
dirtiness_type	char(20)
total_grafted_superblock_size	int8
storage_oid_table_count	int4
ref_count	int4

pg_catalog.stl_udf_usage_in_query

old
column	data type
query	int4
nodeid	int4
plan_node_type	int4
func_id	int4
func_name	char(200)
func_type	int4
in_targetlist	int4
recordtime	timestamp
in_case_expr	int4

new
column	data type
query	int4
nodeid	int4
plan_node_type	int4
func_id	int4
func_name	char(200)
func_type	int4
in_targetlist	int4
recordtime	timestamp
in_case_expr	int4
join_side	int4
nested_udf	int4