Functions

Status Schema Language Volatility Return Function Arguments
new pg_catalog internal immutable bool is_seclog_downgrade_enabled None
new pg_catalog internal immutable super lower_attribute_names super
new pg_catalog internal immutable super upper_attribute_names super
new pg_catalog internal volatile int8 last_num_sorted_rows_user_columns int8

Tables

pg_catalog.stcs_applied_masking_policy
old
columndata typePKUNN
new
columndata typePKUNN
polidint4NN
user_idint4NN
record_timeint8NN
pidint4NN
xidint8NN
query_idint8NN
dbidint4NN
relidint4NN
relation_kindchar(30)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_async_rerep_worker_stats
old
columndata typePKUNN
new
columndata typePKUNN
logtimeint8NN
node_numint4NN
issued_rerep_readsint8NN
issued_rerep_writesint8NN
issued_dirty_writesint8NN
completed_rerep_readsint8NN
completed_rerep_writesint8NN
completed_dirty_writesint8NN
ignored_rerep_readsint8NN
ignored_rerep_writesint8NN
ignored_dirty_writesint8NN
rerep_pool_exhaustedint8NN
ignored_comp_table_not_in_active_setint8NN
ignored_comp_block_state_changedint8NN
ignored_comp_block_pinned_during_writeint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_auto_task_cost_benefit
old
columndata typePKUNN
new
columndata typePKUNN
task_typechar(100)NN
estimation_typechar(50)NN
estimation_in_secondsfloat8NN
real_val_in_secondsfloat8NN
event_timeint8NN
task_idint8NN
task_targetint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_burst_user_temp_table_stats
old
columndata typePKUNN
new
columndata typePKUNN
recordtimeint8NN
xidint8NN
queryint8NN
query_priorityint4NN
total_blocksint8NN
blocks_not_in_s3int8NN
num_temp_tablesint4NN
block_replication_start_timeint8NN
block_replication_end_timeint8NN
metadata_serialize_duration_main_msfloat8NN
metadata_deserialize_duration_burst_msfloat8NN
query_exec_statechar(30)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_burst_write_transactions
old
columndata typePKUNN
new
columndata typePKUNN
xidint8NN
statusint4NN
timestampint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_conjunct_hash
old
columndata typePKUNN
new
columndata typePKUNN
useridint4NN
queryint4NN
nodeidint4NN
parentidint4NN
conjunctint4NN
conjunct_hashchar(64)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_conjunct_hash_mapping
old
columndata typePKUNN
new
columndata typePKUNN
tblint4NN
conjunct_hashchar(64)NN
conjunct_textchar(4000)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_insertion_point_bindings
old
columndata typePKUNN
new
columndata typePKUNN
query_idint4NN
tblint4NN
stage_tblint4NN
ip_idint4NN
timeint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_insertion_point_reservations
old
columndata typePKUNN
new
columndata typePKUNN
query_idint4NN
tblint4NN
data_sliceint4NN
strategyint4NN
eventint4NN
ip_idint4NN
typeint4NN
writer_group_indexint4NN
writer_indexint4NN
timeint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_optima_resource_usage
old
columndata typePKUNN
new
columndata typePKUNN
recordtimeint8NN
optima_last_day_end_timestamp_secint8NN
optima_consumed_rpu_msecint8NN
optima_accrued_rpu_msecint8NN
num_atcs_query_running_queuingint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_pg_query_execution_info
old
columndata typePKUNN
new
columndata typePKUNN
recordtimeint8NN
query_idint8NN
pidint4NN
xidint8NN
user_idint4NN
checkpointint4NN
time_consumption_usint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_process_registry_history
old
columndata typePKUNN
new
columndata typePKUNN
padb_start_timeint8NN
timestampint8NN
node_numberint4NN
procnamechar(32)NN
pidint4NN
is_criticalint4NN
is_registerint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_resource_forecaster_event
old
columndata typePKUNN
new
columndata typePKUNN
event_timeint8NN
componentint4NN
event_typeint4NN
descriptionchar(400)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_resource_forecaster_inference
old
columndata typePKUNN
new
columndata typePKUNN
prediction_starttimeint8NN
prediction_endtimeint8NN
prediction_bucket_indexint4NN
modelint4NN
sequenceint4NN
json_datachar(400)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_resource_forecaster_training
old
columndata typePKUNN
new
columndata typePKUNN
starttimeint8NN
endtimeint8NN
sequenceint4NN
json_datachar(400)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_sage_mode_policy
old
columndata typePKUNN
new
columndata typePKUNN
policy_idint4NN
optimization_start_timeint8NN
creation_timeint8NN
expiration_timeint8NN
performance_levelint4NN
resize_configchar(200)NN
current_size_configchar(200)NN
simulated_cost_rpu_secfloat8NN
simulated_avg_response_time_secfloat8NN
selectedint4NN
used_forecastint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_sage_resize
old
columndata typePKUNN
new
columndata typePKUNN
record_timeint8NN
current_rpusint4NN
target_rpusint4NN
errorchar(256)NN
policy_idint4NN
triggerint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_storage_oid_events
old
columndata typePKUNN
new
columndata typePKUNN
xidint8NN
eventchar(256)NN
table_idint4NN
remote_oidint4NN
useridint4NN
pidint4NN
recordtimeint8NN
current_dml_versionint8NN
current_structure_versionint8NN
current_sb_versionint8NN
current_ddl_versionint8NN
hostchar(256)NN
databasechar(256)NN
schemachar(256)NN
table_namechar(256)NN
table_sizeint8NN
dirtiness_typechar(20)NN
total_grafted_superblock_sizeint8NN
storage_oid_table_countint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_tuple_crc_metrics
old
columndata typePKUNN
new
columndata typePKUNN
log_timeint8NN
num_hitsint8NN
num_missesint8NN
num_resetsint8NN
total_num_invalidationsint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_vacuum_lock_time
old
columndata typePKUNN
new
columndata typePKUNN
xidint8NN
queryint4NN
tbl_idint4NN
lock_typeint4NN
vac_typeint4NN
starttimeint8NN
endtimeint8NN
num_colsint4NN
optimizedint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stll_applied_masking_policy
old
columndata typePKUNN
new
columndata typePKUNN
polidint4NN
user_idint4NN
record_timetimestampNN
pidint4NN
xidint8NN
query_idint8NN
dbidint4NN
relidint4NN
relation_kindchar(30)NN

pg_catalog.stll_async_rerep_worker_stats
old
columndata typePKUNN
new
columndata typePKUNN
logtimetimestampNN
node_numint4NN
issued_rerep_readsint8NN
issued_rerep_writesint8NN
issued_dirty_writesint8NN
completed_rerep_readsint8NN
completed_rerep_writesint8NN
completed_dirty_writesint8NN
ignored_rerep_readsint8NN
ignored_rerep_writesint8NN
ignored_dirty_writesint8NN
rerep_pool_exhaustedint8NN
ignored_comp_table_not_in_active_setint8NN
ignored_comp_block_state_changedint8NN
ignored_comp_block_pinned_during_writeint8NN

pg_catalog.stll_auto_task_cost_benefit
old
columndata typePKUNN
new
columndata typePKUNN
task_typechar(100)NN
estimation_typechar(50)NN
estimation_in_secondsfloat8NN
real_val_in_secondsfloat8NN
event_timetimestampNN
task_idint8NN
task_targetint4NN

pg_catalog.stll_burst_user_temp_table_stats
old
columndata typePKUNN
new
columndata typePKUNN
recordtimetimestampNN
xidint8NN
queryint8NN
query_priorityint4NN
total_blocksint8NN
blocks_not_in_s3int8NN
num_temp_tablesint4NN
block_replication_start_timetimestampNN
block_replication_end_timetimestampNN
metadata_serialize_duration_main_msfloat8NN
metadata_deserialize_duration_burst_msfloat8NN
query_exec_statechar(30)NN

pg_catalog.stll_burst_write_transactions
old
columndata typePKUNN
new
columndata typePKUNN
xidint8NN
statusint4NN
timestamptimestampNN

pg_catalog.stll_conjunct_hash
old
columndata typePKUNN
new
columndata typePKUNN
useridint4NN
queryint4NN
nodeidint4NN
parentidint4NN
conjunctint4NN
conjunct_hashchar(64)NN

pg_catalog.stll_conjunct_hash_mapping
old
columndata typePKUNN
new
columndata typePKUNN
tblint4NN
conjunct_hashchar(64)NN
conjunct_textchar(4000)NN

pg_catalog.stll_insertion_point_bindings
old
columndata typePKUNN
new
columndata typePKUNN
query_idint4NN
tblint4NN
stage_tblint4NN
ip_idint4NN
timetimestampNN

pg_catalog.stll_insertion_point_reservations
old
columndata typePKUNN
new
columndata typePKUNN
query_idint4NN
tblint4NN
data_sliceint4NN
strategyint4NN
eventint4NN
ip_idint4NN
typeint4NN
writer_group_indexint4NN
writer_indexint4NN
timetimestampNN

pg_catalog.stll_optima_resource_usage
old
columndata typePKUNN
new
columndata typePKUNN
recordtimetimestampNN
optima_last_day_end_timestamp_secint8NN
optima_consumed_rpu_msecint8NN
optima_accrued_rpu_msecint8NN
num_atcs_query_running_queuingint4NN

pg_catalog.stll_pg_query_execution_info
old
columndata typePKUNN
new
columndata typePKUNN
recordtimetimestampNN
query_idint8NN
pidint4NN
xidint8NN
user_idint4NN
checkpointint4NN
time_consumption_usint8NN

pg_catalog.stll_process_registry_history
old
columndata typePKUNN
new
columndata typePKUNN
padb_start_timetimestampNN
timestamptimestampNN
node_numberint4NN
procnamechar(32)NN
pidint4NN
is_criticalint4NN
is_registerint4NN

pg_catalog.stll_resource_forecaster_event
old
columndata typePKUNN
new
columndata typePKUNN
event_timetimestampNN
componentint4NN
event_typeint4NN
descriptionchar(400)NN

pg_catalog.stll_resource_forecaster_inference
old
columndata typePKUNN
new
columndata typePKUNN
prediction_starttimetimestampNN
prediction_endtimetimestampNN
prediction_bucket_indexint4NN
modelint4NN
sequenceint4NN
json_datachar(400)NN

pg_catalog.stll_resource_forecaster_training
old
columndata typePKUNN
new
columndata typePKUNN
starttimetimestampNN
endtimetimestampNN
sequenceint4NN
json_datachar(400)NN

pg_catalog.stll_sage_mode_policy
old
columndata typePKUNN
new
columndata typePKUNN
policy_idint4NN
optimization_start_timetimestampNN
creation_timetimestampNN
expiration_timetimestampNN
performance_levelint4NN
resize_configchar(200)NN
current_size_configchar(200)NN
simulated_cost_rpu_secfloat8NN
simulated_avg_response_time_secfloat8NN
selectedint4NN
used_forecastint4NN

pg_catalog.stll_sage_resize
old
columndata typePKUNN
new
columndata typePKUNN
record_timetimestampNN
current_rpusint4NN
target_rpusint4NN
errorchar(256)NN
policy_idint4NN
triggerint4NN

pg_catalog.stll_storage_oid_events
old
columndata typePKUNN
new
columndata typePKUNN
xidint8NN
eventchar(256)NN
table_idint4NN
remote_oidint4NN
useridint4NN
pidint4NN
recordtimetimestampNN
current_dml_versionint8NN
current_structure_versionint8NN
current_sb_versionint8NN
current_ddl_versionint8NN
hostchar(256)NN
databasechar(256)NN
schemachar(256)NN
table_namechar(256)NN
table_sizeint8NN
dirtiness_typechar(20)NN
total_grafted_superblock_sizeint8NN
storage_oid_table_countint4NN

pg_catalog.stll_tuple_crc_metrics
old
columndata typePKUNN
new
columndata typePKUNN
log_timetimestampNN
num_hitsint8NN
num_missesint8NN
num_resetsint8NN
total_num_invalidationsint8NN

pg_catalog.stll_vacuum_lock_time
old
columndata typePKUNN
new
columndata typePKUNN
xidint8NN
queryint4NN
tbl_idint4NN
lock_typeint4NN
vac_typeint4NN
starttimetimestampNN
endtimetimestampNN
num_colsint4NN
optimizedint4NN

pg_catalog.stv_guid_based_ts_cache_leaks
old
columndata typePKUNN
new
columndata typePKUNN
nodeint4NN
guidchar(64)NN
sb_posint4NN
hdr_guidchar(64)NN
leak_typeint4NN

pg_catalog.stv_resource_forecaster_status
old
columndata typePKUNN
new
columndata typePKUNN
enabledchar(1)NN
leader_collector_startup_finishedchar(1)NN
bucketizer_startup_finishedchar(1)NN
last_baselineint4NN
modelint4NN
total_sample_countint4NN
sample_cutoff_time_millisecondsint4NN
open_bucket_builders_countint4NN
leader_metrics_history_sizeint4NN
chunk_countint4NN
persisted_bytesint4NN

pg_internal.redshift_auto_health_check_5579195
old
columndata typePKUNN
new
columndata typePKUNN
deletexidint8NN
insertxidint8NN
oidoidNN
aint4

pg_catalog.stcs_aggr
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
slotsint4NN
occupiedint4NN
maxlengthint4NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
typechar(6)NN
resizesint4NN
flushableint4NN
varchar_agg_optchar(1)NN
varagg_opt_bitmapint8NN
used_agg_prefetchingchar(1)NN
used_mega_blockchar(1)NN
num_flushesint4NN
memory_usage_ratioint4NN
dist_by_distinctint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
slotsint4NN
occupiedint4NN
maxlengthint4NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
typechar(6)NN
resizesint4NN
flushableint4NN
varchar_agg_optchar(1)NN
varagg_opt_bitmapint8NN
used_agg_prefetchingchar(1)NN
used_mega_blockchar(1)NN
num_flushesint4NN
memory_usage_ratioint4NN
dist_by_distinctint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_bcast
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
packetsint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
packetsint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_blocklist
old
columndata typePKUNN
logtimeint8NN
sliceint4NN
colint4NN
tblint4NN
blocknumint4NN
num_valuesint4NN
extended_limitsint4NN
minvalueint8NN
maxvalueint8NN
sb_posint4NN
pinnedint4NN
on_diskint4NN
backed_upint4NN
modifiedint4NN
hdr_modifiedint4NN
unsortedint4NN
tombstoneint4NN
preferred_disknoint4NN
temporaryint4NN
newblockint4NN
num_readersint4NN
idchar(64)NN
flagsint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
logtimeint8NN
sliceint4NN
colint4NN
tblint4NN
blocknumint4NN
num_valuesint4NN
extended_limitsint4NN
minvalueint8NN
maxvalueint8NN
sb_posint4NN
pinnedint4NN
on_diskint4NN
backed_upint4NN
modifiedint4NN
hdr_modifiedint4NN
unsortedint4NN
tombstoneint4NN
preferred_disknoint4NN
temporaryint4NN
newblockint4NN
num_readersint4NN
idchar(64)NN
flagsint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_burst_manager_personalization
old
columndata typePKUNN
useridint4NN
pidint8NN
xidint8NN
starttimeint8NN
endtimeint8NN
cluster_arnchar(128)NN
backup_idchar(100)NN
backup_prefixchar(100)NN
backup_midfixchar(100)NN
creds_access_keychar(100)NN
creds_secret_keychar(100)NN
creds_session_tokenchar(100)NN
creds_expirationint8NN
cluster_idchar(38)NN
cluster_namechar(70)NN
errorchar(250)NN
account_idchar(38)NN
queryint4NN
auto_wlm_total_memory_mbint4NN
auto_wlm_per_query_max_memory_mbint4NN
instance_typechar(100)NN
num_nodesint4NN
burst_cluster_idchar(38)NN
burst_account_idchar(38)NN
burst_cluster_versionchar(50)NN
main_instance_typechar(100)NN
main_num_nodesint4NN
main_num_slicesint4NN
refreshed_backup_idchar(100)NN
refreshed_versionint4NN
refreshing_backup_idchar(100)NN
refreshing_versionint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
pidint8NN
xidint8NN
starttimeint8NN
endtimeint8NN
cluster_arnchar(128)NN
backup_idchar(100)NN
backup_prefixchar(100)NN
backup_midfixchar(100)NN
creds_access_keychar(100)NN
creds_secret_keychar(100)NN
creds_session_tokenchar(100)NN
creds_expirationint8NN
cluster_idchar(38)NN
cluster_namechar(70)NN
errorchar(250)NN
account_idchar(38)NN
queryint4NN
auto_wlm_total_memory_mbint4NN
auto_wlm_per_query_max_memory_mbint4NN
instance_typechar(100)NN
num_nodesint4NN
burst_cluster_idchar(38)NN
burst_account_idchar(38)NN
burst_cluster_versionchar(50)NN
main_instance_typechar(100)NN
main_num_nodesint4NN
main_num_slicesint4NN
refreshed_backup_idchar(100)NN
refreshed_versionint4NN
refreshing_backup_idchar(100)NN
refreshing_versionint4NN
burst_requested_nodesint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_burst_write_block_header_trace
old
columndata typePKUNN
xidint8NN
queryint8NN
tblint4NN
nodeint4NN
block_header_rcvdint8NN
rcvd_timeint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
xidint8NN
queryint8NN
tblint4NN
nodeint4NN
block_header_rcvdint8NN
rcvd_timeint8NN
remote_write_typeint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_burst_write_exec
old
columndata typePKUNN
pidint8NN
xidint8NN
queryint8NN
query_start_timeint8NN
flush_start_timeint8NN
stream_start_timeint8NN
stream_end_timeint8NN
dispatch_start_timeint8NN
snap_in_start_timeint8NN
snap_in_end_timeint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
pidint8NN
xidint8NN
queryint8NN
query_start_timeint8NN
flush_start_timeint8NN
stream_start_timeint8NN
stream_end_timeint8NN
dispatch_start_timeint8NN
snap_in_start_timeint8NN
snap_in_end_timeint8NN
dispatch_end_timeint8NN
remote_write_typeint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_comm_pkt_oob_count
old
columndata typePKUNN
nowint8NN
sinceint8NN
nodeint4NN
is_raidpint4NN
bad_guidint4NN
no_channelint4NN
bad_srcint4NN
bad_dstint4NN
bad_cmdint4NN
bad_crcint4NN
excess_ackint4NN
low_seqnumint4NN
high_seqnumint4NN
early_xonint4NN
lost_packetint4NN
reorder_packetint4NN
likely_lost_ackint4NN
extreme_delayint4NN
in_robint4NN
excess_fast_rexmitint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
nowint8NN
sinceint8NN
nodeint4NN
channel_typeint4NN
bad_guidint4NN
no_channelint4NN
bad_srcint4NN
bad_dstint4NN
bad_cmdint4NN
bad_crcint4NN
excess_ackint4NN
low_seqnumint4NN
high_seqnumint4NN
early_xonint4NN
lost_packetint4NN
reorder_packetint4NN
likely_lost_ackint4NN
extreme_delayint4NN
in_robint4NN
excess_fast_rexmitint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_comm_pkt_sent_count
old
columndata typePKUNN
nowint8NN
sinceint8NN
src_nodeint4NN
dest_nodeint4NN
is_raidpint4NN
bytesint8NN
rexmitint4NN
xonint4NN
replyint4NN
ackint4NN
packetint4NN
fast_rexmitint4NN
original_ackint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
nowint8NN
sinceint8NN
src_nodeint4NN
dest_nodeint4NN
channel_typeint4NN
bytesint8NN
rexmitint4NN
xonint4NN
replyint4NN
ackint4NN
packetint4NN
fast_rexmitint4NN
original_ackint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_comm_pkt_size
old
columndata typePKUNN
sinceint8NN
nowint8NN
dest_nodeint4NN
is_socketint4NN
cmd_codechar(64)NN
meanfloat8NN
stdevfloat8NN
minint8NN
maxint8NN
totalint4NN
less_than_100int4NN
less_than_1000int4NN
less_than_10000int4NN
infint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
sinceint8NN
nowint8NN
src_nodeint4NN
dest_nodeint4NN
is_socketint4NN
cmd_codechar(64)NN
meanfloat8NN
stdevfloat8NN
minint8NN
maxint8NN
totalint4NN
less_than_100int4NN
less_than_1000int4NN
less_than_10000int4NN
infint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_datashare_query_info
old
columndata typePKUNN
useridint4NN
leaderpidint4NN
xidint8NN
queryint4NN
table_idint4NN
current_dml_versionint8NN
current_sructure_versionint8NN
current_sb_versionint8NN
current_ddl_versionint8NN
target_dml_versionint8NN
target_structure_versionint8NN
target_sb_versionint8NN
target_ddl_versionint8NN
leader_node_start_timeint8NN
leader_node_end_timeint8NN
nodeint4NN
compute_node_start_timeint8NN
compute_node_end_timeint8NN
refresh_queue_start_timeint8NN
refresh_queue_end_timeint8NN
sb_download_grafting_start_timeint8NN
sb_download_grafting_end_timeint8NN
total_sb_download_secondsfloat8NN
total_sb_batchesint4NN
changed_headersint8NN
table_grafting_modechar(16)NN
sb_download_modechar(16)NN
superblock_typechar(256)NN
schema_name_table_namechar(256)NN
table_sizeint8NN
total_log_entries_changedint8NN
total_sb_sizeint8NN
num_cols_graftedint4NN
total_num_colsint4NN
graft_batch_numint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
leaderpidint4NN
xidint8NN
queryint4NN
table_idint4NN
current_dml_versionint8NN
current_sructure_versionint8NN
current_sb_versionint8NN
current_ddl_versionint8NN
target_dml_versionint8NN
target_structure_versionint8NN
target_sb_versionint8NN
target_ddl_versionint8NN
leader_node_start_timeint8NN
leader_node_end_timeint8NN
nodeint4NN
compute_node_start_timeint8NN
compute_node_end_timeint8NN
refresh_queue_start_timeint8NN
refresh_queue_end_timeint8NN
sb_download_grafting_start_timeint8NN
sb_download_grafting_end_timeint8NN
total_sb_download_secondsfloat8NN
total_sb_batchesint4NN
changed_headersint8NN
table_grafting_modechar(16)NN
sb_download_modechar(16)NN
superblock_typechar(256)NN
schema_name_table_namechar(256)NN
table_sizeint8NN
total_log_entries_changedint8NN
total_sb_sizeint8NN
num_cols_graftedint4NN
total_num_colsint4NN
graft_batch_numint4NN
access_modechar(16)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_ddltext
old
columndata typePKUNN
useridint4NN
xidint8NN
pidint4NN
labelchar(320)NN
starttimeint8NN
endtimeint8NN
sequenceint4NN
textchar(200)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
xidint8NN
pidint4NN
labelchar(320)NN
starttimeint8NN
endtimeint8NN
sequenceint4NN
textchar(200)NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_delete
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
tblint4NN
write_xidint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
tblint4NN
write_xidint8NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_dist
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
packetsint4NN
topology_signatureint8NN
is_intra_nodechar(1)NN
distribute_by_ldschar(1)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
packetsint4NN
topology_signatureint8NN
is_intra_nodechar(1)NN
distribute_by_ldschar(1)NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_exec_state
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
currenttimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
labelchar(256)NN
is_diskbasedchar(1)NN
workmemint8NN
num_partsint4NN
is_rrscanchar(1)NN
is_delayed_scanchar(1)NN
step_attributechar(64)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
currenttimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
labelchar(256)NN
is_diskbasedchar(1)NN
workmemint8NN
num_partsint4NN
is_rrscanchar(1)NN
is_delayed_scanchar(1)NN
step_attributechar(64)NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_explain
old
columndata typePKUNN
useridint4NN
queryint4NN
nodeidint4NN
parentidint4NN
plannodechar(400)NN
infochar(400)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
nodeidint4NN
parentidint4NN
plannodechar(400)NN
infochar(400)NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_external_query_detail_base
old
columndata typePKUNN
user_idint4NN
query_idint8NN
child_query_sequenceint4NN
child_query_idint4NN
pidint4NN
xidint8NN
segment_idint4NN
nodeint4NN
sliceint4NN
table_namechar(256)NN
sourcetypechar(32)NN
eventtimeint8NN
starttimeint8NN
endtimeint8NN
durationint8NN
total_partitionsint4NN
qualified_partitionsint4NN
total_filesint4NN
files_scannedint4NN
num_rowsint8NN
num_bytesint8NN
file_formatchar(16)NN
locationchar(256)NN
pg_query_textchar(4000)NN
logging_tagchar(32)NN
warning_messagechar(4000)NN
is_recursivechar(1)NN
is_nestedchar(1)NN
s3list_timeint8NN
get_partition_timeint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
user_idint4NN
query_idint8NN
child_query_sequenceint4NN
child_query_idint4NN
pidint4NN
xidint8NN
segment_idint4NN
nodeint4NN
sliceint4NN
table_namechar(256)NN
sourcetypechar(32)NN
eventtimeint8NN
starttimeint8NN
endtimeint8NN
durationint8NN
total_partitionsint4NN
qualified_partitionsint4NN
total_filesint4NN
files_scannedint4NN
num_rowsint8NN
num_bytesint8NN
file_formatchar(16)NN
locationchar(256)NN
pg_query_textchar(4000)NN
logging_tagchar(32)NN
warning_messagechar(4000)NN
is_recursivechar(1)NN
is_nestedchar(1)NN
s3list_timeint8NN
get_partition_timeint8NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_hash
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
slotsint4NN
occupiedint4NN
maxlengthint4NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
num_partsint4NN
est_rowsint8NN
num_blocks_permittedint4NN
resizesint4NN
checksumint8NN
used_prefetchingchar(1)NN
runtime_filter_sizeint4NN
max_runtime_filter_sizeint4NN
runtime_filter_typeint4NN
is_hashed_subplanchar(1)NN
build_global_hash_tablechar(1)NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
slotsint4NN
occupiedint4NN
maxlengthint4NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
num_partsint4NN
est_rowsint8NN
num_blocks_permittedint4NN
resizesint4NN
checksumint8NN
used_prefetchingchar(1)NN
runtime_filter_sizeint4NN
max_runtime_filter_sizeint4NN
runtime_filter_typeint4NN
is_hashed_subplanchar(1)NN
build_global_hash_tablechar(1)NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
logtimeint8NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_hashjoin
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
tblint4NN
num_partsint4NN
join_typeint4NN
hash_loopedchar(1)NN
switched_partschar(1)NN
used_prefetchingchar(1)NN
hash_segmentint4NN
hash_stepint4NN
checksumint8NN
distributionint4NN
is_externalizedchar(1)NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
tblint4NN
num_partsint4NN
join_typeint4NN
hash_loopedchar(1)NN
switched_partschar(1)NN
used_prefetchingchar(1)NN
hash_segmentint4NN
hash_stepint4NN
checksumint8NN
distributionint4NN
is_externalizedchar(1)NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_insert
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
tblint4NN
inserted_mega_valuechar(1)NN
use_staging_tablechar(1)NN
write_xidint8NN
reserve_rowidint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
tblint4NN
inserted_mega_valuechar(1)NN
use_staging_tablechar(1)NN
write_xidint8NN
reserve_rowidint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_integration_cdc_detail
old
columndata typePKUNN
record_timeint8NN
integration_idchar(128)NN
database_namechar(128)NN
checkpointchar(128)NN
source_typechar(128)NN
schema_namechar(128)NN
table_namechar(128)NN
statusint4NN
synced_log_coordinatechar(128)NN
src_insertsint8NN
src_deletesint8NN
src_updatesint8NN
insertsint8NN
inserts_dtint8NN
parsed_rowsint8NN
skipped_rowsint8NN
is_burstedint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
record_timeint8NN
integration_idchar(128)NN
database_namechar(128)NN
checkpointchar(128)NN
source_typechar(128)NN
schema_namechar(128)NN
table_namechar(128)NN
statusint4NN
synced_log_coordinatechar(128)NN
src_insertsint8NN
src_deletesint8NN
src_updatesint8NN
insertsint8NN
inserts_dtint8NN
parsed_rowsint8NN
skipped_rowsint8NN
is_burstedint4NN
bytes_ingestedint8NN
updated_rowsint8NN
validation_statusint4NN
xidint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_limit
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
hit_limitchar(1)NN
checksumint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
hit_limitchar(1)NN
checksumint8NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_load_history_base
old
columndata typePKUNN
user_idint4NN
dbchar(64)NN
xidint8NN
pidint4NN
query_idint8NN
child_query_sequenceint4NN
child_query_idint4NN
statusint4NN
table_namechar(128)NN
event_timeint8NN
sliceint4NN
filenamechar(256)NN
file_countint4NN
file_bytesint8NN
file_count_scannedint4NN
file_bytes_scannedint8NN
bytes_copiedint8NN
rows_copiedint8NN
file_formatchar(16)NN
error_countint4NN
data_sourcechar(256)NN
copy_job_idint8NN
start_offsetint8NN
bytes_scannedint8NN
lines_scannedint8NN
start_timeint8NN
end_timeint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
user_idint4NN
dbchar(64)NN
xidint8NN
pidint4NN
query_idint8NN
child_query_sequenceint4NN
child_query_idint4NN
statusint4NN
table_namechar(128)NN
event_timeint8NN
sliceint4NN
filenamechar(256)NN
file_countint4NN
file_bytesint8NN
file_count_scannedint4NN
file_bytes_scannedint8NN
bytes_copiedint8NN
rows_copiedint8NN
file_formatchar(16)NN
error_countint4NN
data_sourcechar(256)NN
copy_job_idint8NN
start_offsetint8NN
bytes_scannedint8NN
lines_scannedint8NN
start_timeint8NN
end_timeint8NN
file_etagchar(256)NN
file_last_modifiedint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_merge
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_mergejoin
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
tblint4NN
checksumint8NN
distributionint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
tblint4NN
checksumint8NN
distributionint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_nestloop
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
tblint4NN
checksumint8NN
distributionint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
tblint4NN
checksumint8NN
distributionint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_parse
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_plan_info
old
columndata typePKUNN
useridint4NN
queryint4NN
nodeidint4NN
segmentint4NN
stepint4NN
locusint4NN
plannodeint4NN
startupcostfloat8NN
totalcostfloat8NN
rowsint8NN
bytesint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
nodeidint4NN
segmentint4NN
stepint4NN
locusint4NN
plannodeint4NN
startupcostfloat8NN
totalcostfloat8NN
rowsint8NN
bytesint8NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_project
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
checksumint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
checksumint8NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_query
old
columndata typePKUNN
useridint4NN
queryint4NN
labelchar(320)NN
xidint8NN
pidint4NN
databasechar(32)NN
querytxtchar(4000)NN
starttimeint8NN
endtimeint8NN
abortedint4NN
insert_pristineint4NN
concurrency_scaling_statusint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
labelchar(320)NN
xidint8NN
pidint4NN
databasechar(32)NN
querytxtchar(4000)NN
starttimeint8NN
endtimeint8NN
abortedint4NN
insert_pristineint4NN
concurrency_scaling_statusint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_query_detail
old
columndata typePKUNN
user_idint4NN
query_idint8NN
child_query_idint4NN
child_query_sequenceint4NN
stream_idint4NN
segment_idint4NN
step_idint4NN
sliceint4NN
starttimeint8NN
endtimeint8NN
step_nameint4NN
table_idint4NN
table_namechar(136)NN
input_rowsint8NN
input_bytesint8NN
output_rowsint8NN
output_bytesint8NN
is_rrscanchar(1)NN
blocks_readint8NN
blocks_writeint8NN
local_read_ioint8NN
remote_read_ioint8NN
alertchar(1024)NN
internal_querychar(1)NN
sourcechar(64)NN
cpu_timeint8NN
spilled_block_local_diskint8NN
spilled_block_remote_diskint8NN
step_attributechar(64)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
user_idint4NN
query_idint8NN
child_query_idint4NN
child_query_sequenceint4NN
stream_idint4NN
segment_idint4NN
step_idint4NN
sliceint4NN
starttimeint8NN
endtimeint8NN
step_nameint4NN
table_idint4NN
table_namechar(136)NN
input_rowsint8NN
input_bytesint8NN
output_rowsint8NN
output_bytesint8NN
is_rrscanchar(1)NN
blocks_readint8NN
blocks_writeint8NN
local_read_ioint8NN
remote_read_ioint8NN
alertchar(1024)NN
internal_querychar(1)NN
sourcechar(64)NN
cpu_timeint8NN
spilled_block_local_diskint8NN
spilled_block_remote_diskint8NN
step_attributechar(64)NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_query_metrics
old
columndata typePKUNN
useridint4NN
service_classint4NN
queryint4NN
segmentint4NN
step_typeint4NN
starttimeint8NN
slicesint4NN
max_rowsint8NN
rowsint8NN
max_cpu_timeint8NN
cpu_timeint8NN
max_blocks_readint4NN
blocks_readint8NN
max_run_timeint8NN
run_timeint8NN
max_blocks_to_diskint8NN
blocks_to_diskint8NN
stepint4NN
max_query_scan_sizeint8NN
query_scan_sizeint8NN
query_priorityint4NN
query_queue_timeint8NN
service_class_namechar(64)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
service_classint4NN
queryint4NN
segmentint4NN
step_typeint4NN
starttimeint8NN
slicesint4NN
max_rowsint8NN
rowsint8NN
max_cpu_timeint8NN
cpu_timeint8NN
max_blocks_readint4NN
blocks_readint8NN
max_run_timeint8NN
run_timeint8NN
max_blocks_to_diskint8NN
blocks_to_diskint8NN
stepint4NN
max_query_scan_sizeint8NN
query_scan_sizeint8NN
query_priorityint4NN
query_queue_timeint8NN
service_class_namechar(64)NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_querytext
old
columndata typePKUNN
useridint4NN
xidint8NN
pidint4NN
queryint4NN
sequenceint4NN
textchar(200)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
xidint8NN
pidint4NN
queryint4NN
sequenceint4NN
textchar(200)NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_restarted_sessions_internal
old
columndata typePKUNN
currenttimeint8NN
is_reforkablechar(10)NN
temp_tbl_createdchar(10)NN
named_prep_stmt_ctint4NN
unnamed_stmt_ctint4NN
in_xact_blkchar(10)NN
is_read_onlychar(10)NN
is_single_stmt_querychar(10)NN
conn_statechar(100)NN
pidint4NN
in_authenticationchar(10)NN
is_bootstrapchar(10)NN
is_restarted_sessionchar(10)NN
is_extended_protocolchar(10)NN
is_idle_connectionchar(10)NN
current_executing_commandchar(10)NN
is_ssl_compressedchar(10)NN
is_protocol_v3char(10)NN
are_commands_repeatedchar(10)NN
unsupported_command_sequencechar(10)NN
can_reissue_querychar(10)NN
parked_state_in_proxychar(10)NN
session_sizeint8NN
is_inc_resizechar(10)NN
written_state_to_diskchar(10)NN
auto_resumechar(10)NN
query_command_sequencechar(32)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
currenttimeint8NN
is_reforkablechar(10)NN
temp_tbl_createdchar(10)NN
named_prep_stmt_ctint4NN
unnamed_stmt_ctint4NN
in_xact_blkchar(10)NN
is_read_onlychar(10)NN
is_single_stmt_querychar(10)NN
conn_statechar(100)NN
pidint4NN
in_authenticationchar(10)NN
is_bootstrapchar(10)NN
is_restarted_sessionchar(10)NN
is_extended_protocolchar(10)NN
is_idle_connectionchar(10)NN
current_executing_commandchar(10)NN
is_ssl_compressedchar(10)NN
is_protocol_v3char(10)NN
are_commands_repeatedchar(10)NN
unsupported_command_sequencechar(10)NN
can_reissue_querychar(10)NN
parked_state_in_proxychar(10)NN
session_sizeint8NN
is_inc_resizechar(10)NN
written_state_to_diskchar(10)NN
auto_resumechar(10)NN
query_command_sequencechar(32)NN
is_fas_setchar(10)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_return
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
packetsint4NN
checksumint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
packetsint4NN
checksumint8NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_rtree
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
mem_allowance_for_indexint8NN
cheating_memint8NN
index_predicted_sizeint8NN
index_sizeint8NN
insert_durationint8NN
build_durationint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
mem_allowance_for_indexint8NN
cheating_memint8NN
index_predicted_sizeint8NN
index_sizeint8NN
insert_durationint8NN
build_durationint8NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_s3list
old
columndata typePKUNN
useridint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
nodeint4NN
sliceint4NN
eventtimeint8NN
bucketchar(256)NN
prefixchar(256)NN
recursivechar(1)NN
retrieved_filesint4NN
max_file_sizeint8NN
avg_file_sizefloat8NN
durationint8NN
generated_splitsint4NN
avg_split_lengthfloat8NN
scan_typeint4NN
list_typeint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
nodeint4NN
sliceint4NN
eventtimeint8NN
bucketchar(256)NN
prefixchar(256)NN
recursivechar(1)NN
retrieved_filesint4NN
max_file_sizeint8NN
avg_file_sizefloat8NN
durationint8NN
generated_splitsint4NN
avg_split_lengthfloat8NN
scan_typeint4NN
list_typeint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_s3log
old
columndata typePKUNN
useridint4NN
is_internalint4NN
pidint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
stepint4NN
nodeint4NN
sliceint4NN
eventtimeint8NN
messagechar(512)NN
scan_typeint4NN
request_idchar(16)NN
error_typeint4NN
spectrum_error_codeint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
is_internalint4NN
pidint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
stepint4NN
nodeint4NN
sliceint4NN
eventtimeint8NN
messagechar(512)NN
scan_typeint4NN
request_idchar(16)NN
error_typeint4NN
spectrum_error_codeint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_s3partition_elimination
old
columndata typePKUNN
useridint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
nodeint4NN
sliceint4NN
starttimeint8NN
endtimeint8NN
total_partitionsint4NN
qualified_partitionsint4NN
assignmentchar(1)NN
durationint8NN
assigned_partitionsint4NN
scan_typeint4NN
fetched_partitionsint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
nodeint4NN
sliceint4NN
starttimeint8NN
endtimeint8NN
total_partitionsint4NN
qualified_partitionsint4NN
assignmentchar(1)NN
durationint8NN
assigned_partitionsint4NN
scan_typeint4NN
fetched_partitionsint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_s3query
old
columndata typePKUNN
useridint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
stepint4NN
nodeint4NN
sliceint4NN
starttimeint8NN
endtimeint8NN
external_table_namechar(136)NN
is_partitionedchar(1)NN
is_rrscanchar(1)NN
s3_scanned_rowsint8NN
s3_scanned_bytesint8NN
s3query_returned_rowsint8NN
s3query_returned_bytesint8NN
filesint4NN
total_retriesint4NN
max_retriesint4NN
max_request_durationint8NN
avg_request_durationint8NN
max_request_parallelismint4NN
max_allowed_parallelismint4NN
avg_request_parallelismfloat8NN
splitsint4NN
total_split_sizeint8NN
max_split_sizeint8NN
request_fingerprintint8NN
file_formatchar(16)NN
cache_hitsint4NN
is_copyint4NN
is_nestedchar(1)NN
slowdown_countint4NN
max_concurrent_slowdown_countint4NN
s3_billable_scanned_bytesint8NN
scan_typeint4NN
s3query_returned_uncompressed_bytesint8NN
is_lakeformationint4NN
is_governedint4NN
transaction_idchar(32)NN
query_as_of_timeint8NN
throttled_requestsint4NN
peakmemint8NN
is_localint4NN
is_evrint4NN
has_cell_level_securityint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
stepint4NN
nodeint4NN
sliceint4NN
starttimeint8NN
endtimeint8NN
external_table_namechar(136)NN
is_partitionedchar(1)NN
is_rrscanchar(1)NN
s3_scanned_rowsint8NN
s3_scanned_bytesint8NN
s3query_returned_rowsint8NN
s3query_returned_bytesint8NN
filesint4NN
total_retriesint4NN
max_retriesint4NN
max_request_durationint8NN
avg_request_durationint8NN
max_request_parallelismint4NN
max_allowed_parallelismint4NN
avg_request_parallelismfloat8NN
splitsint4NN
total_split_sizeint8NN
max_split_sizeint8NN
request_fingerprintint8NN
file_formatchar(16)NN
cache_hitsint4NN
is_copyint4NN
is_nestedchar(1)NN
slowdown_countint4NN
max_concurrent_slowdown_countint4NN
s3_billable_scanned_bytesint8NN
scan_typeint4NN
s3query_returned_uncompressed_bytesint8NN
is_lakeformationint4NN
is_governedint4NN
transaction_idchar(32)NN
query_as_of_timeint8NN
throttled_requestsint4NN
peakmemint8NN
is_localint4NN
is_evrint4NN
has_cell_level_securityint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_s3retries
old
columndata typePKUNN
useridint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
nodeint4NN
sliceint4NN
eventtimeint8NN
retriesint4NN
successful_fetchesint4NN
file_sizeint8NN
start_offsetint8NN
lengthint8NN
locationchar(256)NN
messagechar(256)NN
retry_backoff_msint4NN
scan_typeint4NN
timeoutint8NN
connect_retriesint4NN
connect_timeint8NN
exectask_timeint8NN
fast_forward_fetch_timeint8NN
fetch_timeint8NN
request_idchar(16)NN
stateint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
nodeint4NN
sliceint4NN
eventtimeint8NN
retriesint4NN
successful_fetchesint4NN
file_sizeint8NN
start_offsetint8NN
lengthint8NN
locationchar(256)NN
messagechar(256)NN
retry_backoff_msint4NN
scan_typeint4NN
timeoutint8NN
connect_retriesint4NN
connect_timeint8NN
exectask_timeint8NN
fast_forward_fetch_timeint8NN
fetch_timeint8NN
request_idchar(16)NN
stateint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_save
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
is_save_rtfchar(1)NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
is_save_rtfchar(1)NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_scan
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
fetchesint8NN
typeint4NN
tblint4NN
is_rrscanchar(1)NN
is_delayed_scanchar(1)NN
rows_pre_filterint8NN
rows_pre_user_filterint8NN
perm_table_namechar(136)NN
is_rlf_scanchar(1)NN
is_rlf_scan_reasonint4NN
num_em_blocksint4NN
checksumint8NN
runtime_filteringchar(1)NN
scan_regionint4NN
num_sortkey_as_predicateint4NN
row_fetcher_stateint4NN
consumed_scan_rangesint8NN
work_stealing_reasonint8NN
is_vectorized_scanchar(1)NN
is_vectorized_scan_reasonint4NN
row_fetcher_reasonint8NN
topology_signatureint8NN
use_tpm_partitionchar(1)NN
is_rrscan_exprchar(1)NN
use_fwd_mtx_optchar(1)NN
scanned_mega_valuechar(1)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
fetchesint8NN
typeint4NN
tblint4NN
is_rrscanchar(1)NN
is_delayed_scanchar(1)NN
rows_pre_filterint8NN
rows_pre_user_filterint8NN
perm_table_namechar(136)NN
is_rlf_scanchar(1)NN
is_rlf_scan_reasonint4NN
num_em_blocksint4NN
checksumint8NN
runtime_filteringchar(1)NN
scan_regionint4NN
num_sortkey_as_predicateint4NN
row_fetcher_stateint4NN
consumed_scan_rangesint8NN
work_stealing_reasonint8NN
is_vectorized_scanchar(1)NN
is_vectorized_scan_reasonint4NN
row_fetcher_reasonint8NN
topology_signatureint8NN
use_tpm_partitionchar(1)NN
is_rrscan_exprchar(1)NN
use_fwd_mtx_optchar(1)NN
scanned_mega_valuechar(1)NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_sort
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
checksumint8NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
bytesint8NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
checksumint8NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_spatial_join
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
rtree_segmentint4NN
rtree_stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
predicateint4NN
rowsint8NN
pruned_tuplesint8NN
tblint4NN
checksumint8NN
distributionint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
rtree_segmentint4NN
rtree_stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
predicateint4NN
rowsint8NN
pruned_tuplesint8NN
tblint4NN
checksumint8NN
distributionint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_spectrum_scan_error
old
columndata typePKUNN
useridint4NN
queryint4NN
locationchar(256)NN
rowidchar(2100)NN
colnamechar(127)NN
original_valuechar(1024)NN
modified_valuechar(1024)NN
triggerint4NN
actionint4NN
action_valuechar(127)NN
error_codeint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
locationchar(256)NN
rowidchar(2100)NN
colnamechar(127)NN
original_valuechar(1024)NN
modified_valuechar(1024)NN
triggerint4NN
actionint4NN
action_valuechar(127)NN
error_codeint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_stored_proc_call
old
columndata typePKUNN
useridint4NN
session_useridint4NN
queryint4NN
labelchar(320)NN
xidint8NN
pidint4NN
databasechar(32)NN
querytxtchar(500)NN
starttimeint8NN
endtimeint8NN
abortedint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
session_useridint4NN
queryint4NN
labelchar(320)NN
xidint8NN
pidint4NN
databasechar(32)NN
querytxtchar(500)NN
starttimeint8NN
endtimeint8NN
abortedint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_stored_proc_messages
old
columndata typePKUNN
useridint4NN
queryint4NN
loglevelint4NN
messagechar(1024)NN
linenumint4NN
recordtimeint8NN
message_xidint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
loglevelint4NN
messagechar(1024)NN
linenumint4NN
recordtimeint8NN
message_xidint8NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_tr_conflict
old
columndata typePKUNN
xact_idint8NN
process_idint8NN
xact_start_tsint8NN
abort_timeint8NN
table_idint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
xact_idint8NN
process_idint8NN
xact_start_tsint8NN
abort_timeint8NN
table_idint8NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_udf_log
old
columndata typePKUNN
queryint8NN
messagechar(4096)NN
createdint8NN
filenamechar(256)NN
funcnamechar(256)NN
level_namechar(64)NN
level_numberint4NN
linenoint4NN
modulechar(256)NN
msecsfloat8NN
namechar(256)NN
path_namechar(256)NN
processint8NN
process_namechar(256)NN
relative_createdfloat8NN
threadint8NN
thread_namechar(256)NN
tracebackchar(4096)NN
nodeint4NN
sliceint4NN
seqint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
queryint8NN
messagechar(4096)NN
createdint8NN
filenamechar(256)NN
funcnamechar(256)NN
level_namechar(64)NN
level_numberint4NN
linenoint4NN
modulechar(256)NN
msecsfloat8NN
namechar(256)NN
path_namechar(256)NN
processint8NN
process_namechar(256)NN
relative_createdfloat8NN
threadint8NN
thread_namechar(256)NN
tracebackchar(4096)NN
nodeint4NN
sliceint4NN
seqint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_undone
old
columndata typePKUNN
useridint4NN
xact_idint8NN
xact_id_undoneint8NN
undo_start_tsint8NN
undo_end_tsint8NN
table_idint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
xact_idint8NN
xact_id_undoneint8NN
undo_start_tsint8NN
undo_end_tsint8NN
table_idint8NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_unique
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
typechar(6)NN
is_diskbasedchar(1)NN
slotsint4NN
workmemint8NN
max_buffers_usedint8NN
resizesint4NN
occupiedint4NN
flushableint4NN
used_unique_prefetchingchar(1)NN
bytesint8NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
typechar(6)NN
is_diskbasedchar(1)NN
slotsint4NN
workmemint8NN
max_buffers_usedint8NN
resizesint4NN
occupiedint4NN
flushableint4NN
used_unique_prefetchingchar(1)NN
bytesint8NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_unnest
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_user_query_history
old
columndata typePKUNN
user_idint4NN
query_idint8NN
labelchar(320)NN
xidint8NN
pidint4NN
database_namechar(128)NN
query_typechar(32)NN
statuschar(10)NN
result_cache_source_queryint8NN
start_timeint8NN
end_timeint8NN
queue_timeint8NN
execution_timeint8NN
error_messagechar(512)NN
returned_rowsint8NN
returned_bytesint8NN
redshift_versionchar(32)NN
usage_limitchar(150)NN
internal_querychar(1)NN
query_textchar(4000)NN
compute_typechar(32)NN
compile_timeint8NN
planning_timeint8NN
pure_planning_timeint8NN
lock_wait_timeint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
user_idint4NN
query_idint8NN
labelchar(320)NN
xidint8NN
pidint4NN
database_namechar(128)NN
query_typechar(32)NN
statuschar(10)NN
result_cache_source_queryint8NN
start_timeint8NN
end_timeint8NN
queue_timeint8NN
execution_timeint8NN
error_messagechar(512)NN
returned_rowsint8NN
returned_bytesint8NN
redshift_versionchar(32)NN
usage_limitchar(150)NN
internal_querychar(1)NN
query_textchar(4000)NN
compute_typechar(32)NN
compile_timeint8NN
planning_timeint8NN
pure_planning_timeint8NN
lock_wait_timeint8NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_utilitytext
old
columndata typePKUNN
useridint4NN
xidint8NN
pidint4NN
labelchar(320)NN
starttimeint8NN
endtimeint8NN
sequenceint4NN
textchar(200)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
xidint8NN
pidint4NN
labelchar(320)NN
starttimeint8NN
endtimeint8NN
sequenceint4NN
textchar(200)NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_window
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
is_diskbasedchar(1)NN
workmemint8NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimeint8NN
endtimeint8NN
tasknumint4NN
rowsint8NN
is_diskbasedchar(1)NN
workmemint8NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
access_controlint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stll_aggr
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
slotsint4NN
occupiedint4NN
maxlengthint4NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
typechar(6)NN
resizesint4NN
flushableint4NN
varchar_agg_optchar(1)NN
varagg_opt_bitmapint8NN
used_agg_prefetchingchar(1)NN
used_mega_blockchar(1)NN
num_flushesint4NN
memory_usage_ratioint4NN
dist_by_distinctint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
slotsint4NN
occupiedint4NN
maxlengthint4NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
typechar(6)NN
resizesint4NN
flushableint4NN
varchar_agg_optchar(1)NN
varagg_opt_bitmapint8NN
used_agg_prefetchingchar(1)NN
used_mega_blockchar(1)NN
num_flushesint4NN
memory_usage_ratioint4NN
dist_by_distinctint4NN
access_controlint4NN

pg_catalog.stll_bcast
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
packetsint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
packetsint4NN
access_controlint4NN

pg_catalog.stll_blocklist
old
columndata typePKUNN
logtimetimestampNN
sliceint4NN
colint4NN
tblint4NN
blocknumint4NN
num_valuesint4NN
extended_limitsint4NN
minvalueint8NN
maxvalueint8NN
sb_posint4NN
pinnedint4NN
on_diskint4NN
backed_upint4NN
modifiedint4NN
hdr_modifiedint4NN
unsortedint4NN
tombstoneint4NN
preferred_disknoint4NN
temporaryint4NN
newblockint4NN
num_readersint4NN
idchar(64)NN
flagsint4NN
new
columndata typePKUNN
logtimetimestampNN
sliceint4NN
colint4NN
tblint4NN
blocknumint4NN
num_valuesint4NN
extended_limitsint4NN
minvalueint8NN
maxvalueint8NN
sb_posint4NN
pinnedint4NN
on_diskint4NN
backed_upint4NN
modifiedint4NN
hdr_modifiedint4NN
unsortedint4NN
tombstoneint4NN
preferred_disknoint4NN
temporaryint4NN
newblockint4NN
num_readersint4NN
idchar(64)NN
flagsint4NN
access_controlint4NN

pg_catalog.stll_burst_manager_personalization
old
columndata typePKUNN
useridint4NN
pidint8NN
xidint8NN
starttimetimestampNN
endtimetimestampNN
cluster_arnchar(128)NN
backup_idchar(100)NN
backup_prefixchar(100)NN
backup_midfixchar(100)NN
creds_access_keychar(100)NN
creds_secret_keychar(100)NN
creds_session_tokenchar(100)NN
creds_expirationtimestampNN
cluster_idchar(38)NN
cluster_namechar(70)NN
errorchar(250)NN
account_idchar(38)NN
queryint4NN
auto_wlm_total_memory_mbint4NN
auto_wlm_per_query_max_memory_mbint4NN
instance_typechar(100)NN
num_nodesint4NN
burst_cluster_idchar(38)NN
burst_account_idchar(38)NN
burst_cluster_versionchar(50)NN
main_instance_typechar(100)NN
main_num_nodesint4NN
main_num_slicesint4NN
refreshed_backup_idchar(100)NN
refreshed_versionint4NN
refreshing_backup_idchar(100)NN
refreshing_versionint4NN
new
columndata typePKUNN
useridint4NN
pidint8NN
xidint8NN
starttimetimestampNN
endtimetimestampNN
cluster_arnchar(128)NN
backup_idchar(100)NN
backup_prefixchar(100)NN
backup_midfixchar(100)NN
creds_access_keychar(100)NN
creds_secret_keychar(100)NN
creds_session_tokenchar(100)NN
creds_expirationtimestampNN
cluster_idchar(38)NN
cluster_namechar(70)NN
errorchar(250)NN
account_idchar(38)NN
queryint4NN
auto_wlm_total_memory_mbint4NN
auto_wlm_per_query_max_memory_mbint4NN
instance_typechar(100)NN
num_nodesint4NN
burst_cluster_idchar(38)NN
burst_account_idchar(38)NN
burst_cluster_versionchar(50)NN
main_instance_typechar(100)NN
main_num_nodesint4NN
main_num_slicesint4NN
refreshed_backup_idchar(100)NN
refreshed_versionint4NN
refreshing_backup_idchar(100)NN
refreshing_versionint4NN
burst_requested_nodesint4NN

pg_catalog.stll_burst_write_block_header_trace
old
columndata typePKUNN
xidint8NN
queryint8NN
tblint4NN
nodeint4NN
block_header_rcvdint8NN
rcvd_timetimestampNN
new
columndata typePKUNN
xidint8NN
queryint8NN
tblint4NN
nodeint4NN
block_header_rcvdint8NN
rcvd_timetimestampNN
remote_write_typeint4NN

pg_catalog.stll_burst_write_exec
old
columndata typePKUNN
pidint8NN
xidint8NN
queryint8NN
query_start_timetimestampNN
flush_start_timetimestampNN
stream_start_timetimestampNN
stream_end_timetimestampNN
dispatch_start_timetimestampNN
snap_in_start_timetimestampNN
snap_in_end_timetimestampNN
new
columndata typePKUNN
pidint8NN
xidint8NN
queryint8NN
query_start_timetimestampNN
flush_start_timetimestampNN
stream_start_timetimestampNN
stream_end_timetimestampNN
dispatch_start_timetimestampNN
snap_in_start_timetimestampNN
snap_in_end_timetimestampNN
dispatch_end_timetimestampNN
remote_write_typeint4NN

pg_catalog.stll_comm_pkt_oob_count
old
columndata typePKUNN
nowtimestampNN
sincetimestampNN
nodeint4NN
is_raidpint4NN
bad_guidint4NN
no_channelint4NN
bad_srcint4NN
bad_dstint4NN
bad_cmdint4NN
bad_crcint4NN
excess_ackint4NN
low_seqnumint4NN
high_seqnumint4NN
early_xonint4NN
lost_packetint4NN
reorder_packetint4NN
likely_lost_ackint4NN
extreme_delayint4NN
in_robint4NN
excess_fast_rexmitint4NN
new
columndata typePKUNN
nowtimestampNN
sincetimestampNN
nodeint4NN
channel_typeint4NN
bad_guidint4NN
no_channelint4NN
bad_srcint4NN
bad_dstint4NN
bad_cmdint4NN
bad_crcint4NN
excess_ackint4NN
low_seqnumint4NN
high_seqnumint4NN
early_xonint4NN
lost_packetint4NN
reorder_packetint4NN
likely_lost_ackint4NN
extreme_delayint4NN
in_robint4NN
excess_fast_rexmitint4NN

pg_catalog.stll_comm_pkt_sent_count
old
columndata typePKUNN
nowtimestampNN
sincetimestampNN
src_nodeint4NN
dest_nodeint4NN
is_raidpint4NN
bytesint8NN
rexmitint4NN
xonint4NN
replyint4NN
ackint4NN
packetint4NN
fast_rexmitint4NN
original_ackint4NN
new
columndata typePKUNN
nowtimestampNN
sincetimestampNN
src_nodeint4NN
dest_nodeint4NN
channel_typeint4NN
bytesint8NN
rexmitint4NN
xonint4NN
replyint4NN
ackint4NN
packetint4NN
fast_rexmitint4NN
original_ackint4NN

pg_catalog.stll_comm_pkt_size
old
columndata typePKUNN
sincetimestampNN
nowtimestampNN
dest_nodeint4NN
is_socketint4NN
cmd_codechar(64)NN
meanfloat8NN
stdevfloat8NN
minint8NN
maxint8NN
totalint4NN
less_than_100int4NN
less_than_1000int4NN
less_than_10000int4NN
infint4NN
new
columndata typePKUNN
sincetimestampNN
nowtimestampNN
src_nodeint4NN
dest_nodeint4NN
is_socketint4NN
cmd_codechar(64)NN
meanfloat8NN
stdevfloat8NN
minint8NN
maxint8NN
totalint4NN
less_than_100int4NN
less_than_1000int4NN
less_than_10000int4NN
infint4NN

pg_catalog.stll_datashare_query_info
old
columndata typePKUNN
useridint4NN
leaderpidint4NN
xidint8NN
queryint4NN
table_idint4NN
current_dml_versionint8NN
current_sructure_versionint8NN
current_sb_versionint8NN
current_ddl_versionint8NN
target_dml_versionint8NN
target_structure_versionint8NN
target_sb_versionint8NN
target_ddl_versionint8NN
leader_node_start_timetimestampNN
leader_node_end_timetimestampNN
nodeint4NN
compute_node_start_timetimestampNN
compute_node_end_timetimestampNN
refresh_queue_start_timetimestampNN
refresh_queue_end_timetimestampNN
sb_download_grafting_start_timetimestampNN
sb_download_grafting_end_timetimestampNN
total_sb_download_secondsfloat8NN
total_sb_batchesint4NN
changed_headersint8NN
table_grafting_modechar(16)NN
sb_download_modechar(16)NN
superblock_typechar(256)NN
schema_name_table_namechar(256)NN
table_sizeint8NN
total_log_entries_changedint8NN
total_sb_sizeint8NN
num_cols_graftedint4NN
total_num_colsint4NN
graft_batch_numint4NN
new
columndata typePKUNN
useridint4NN
leaderpidint4NN
xidint8NN
queryint4NN
table_idint4NN
current_dml_versionint8NN
current_sructure_versionint8NN
current_sb_versionint8NN
current_ddl_versionint8NN
target_dml_versionint8NN
target_structure_versionint8NN
target_sb_versionint8NN
target_ddl_versionint8NN
leader_node_start_timetimestampNN
leader_node_end_timetimestampNN
nodeint4NN
compute_node_start_timetimestampNN
compute_node_end_timetimestampNN
refresh_queue_start_timetimestampNN
refresh_queue_end_timetimestampNN
sb_download_grafting_start_timetimestampNN
sb_download_grafting_end_timetimestampNN
total_sb_download_secondsfloat8NN
total_sb_batchesint4NN
changed_headersint8NN
table_grafting_modechar(16)NN
sb_download_modechar(16)NN
superblock_typechar(256)NN
schema_name_table_namechar(256)NN
table_sizeint8NN
total_log_entries_changedint8NN
total_sb_sizeint8NN
num_cols_graftedint4NN
total_num_colsint4NN
graft_batch_numint4NN
access_modechar(16)NN

pg_catalog.stll_ddltext
old
columndata typePKUNN
useridint4NN
xidint8NN
pidint4NN
labelchar(320)NN
starttimetimestampNN
endtimetimestampNN
sequenceint4NN
textchar(200)NN
new
columndata typePKUNN
useridint4NN
xidint8NN
pidint4NN
labelchar(320)NN
starttimetimestampNN
endtimetimestampNN
sequenceint4NN
textchar(200)NN
access_controlint4NN

pg_catalog.stll_delete
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
tblint4NN
write_xidint8NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
tblint4NN
write_xidint8NN
access_controlint4NN

pg_catalog.stll_dist
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
packetsint4NN
topology_signatureint8NN
is_intra_nodechar(1)NN
distribute_by_ldschar(1)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
packetsint4NN
topology_signatureint8NN
is_intra_nodechar(1)NN
distribute_by_ldschar(1)NN
access_controlint4NN

pg_catalog.stll_exec_state
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
currenttimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
labelchar(256)NN
is_diskbasedchar(1)NN
workmemint8NN
num_partsint4NN
is_rrscanchar(1)NN
is_delayed_scanchar(1)NN
step_attributechar(64)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
currenttimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
labelchar(256)NN
is_diskbasedchar(1)NN
workmemint8NN
num_partsint4NN
is_rrscanchar(1)NN
is_delayed_scanchar(1)NN
step_attributechar(64)NN
access_controlint4NN

pg_catalog.stll_explain
old
columndata typePKUNN
useridint4NN
queryint4NN
nodeidint4NN
parentidint4NN
plannodechar(400)NN
infochar(400)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
nodeidint4NN
parentidint4NN
plannodechar(400)NN
infochar(400)NN
access_controlint4NN

pg_catalog.stll_external_query_detail_base
old
columndata typePKUNN
user_idint4NN
query_idint8NN
child_query_sequenceint4NN
child_query_idint4NN
pidint4NN
xidint8NN
segment_idint4NN
nodeint4NN
sliceint4NN
table_namechar(256)NN
sourcetypechar(32)NN
eventtimetimestampNN
starttimetimestampNN
endtimetimestampNN
durationint8NN
total_partitionsint4NN
qualified_partitionsint4NN
total_filesint4NN
files_scannedint4NN
num_rowsint8NN
num_bytesint8NN
file_formatchar(16)NN
locationchar(256)NN
pg_query_textchar(4000)NN
logging_tagchar(32)NN
warning_messagechar(4000)NN
is_recursivechar(1)NN
is_nestedchar(1)NN
s3list_timeint8NN
get_partition_timeint8NN
new
columndata typePKUNN
user_idint4NN
query_idint8NN
child_query_sequenceint4NN
child_query_idint4NN
pidint4NN
xidint8NN
segment_idint4NN
nodeint4NN
sliceint4NN
table_namechar(256)NN
sourcetypechar(32)NN
eventtimetimestampNN
starttimetimestampNN
endtimetimestampNN
durationint8NN
total_partitionsint4NN
qualified_partitionsint4NN
total_filesint4NN
files_scannedint4NN
num_rowsint8NN
num_bytesint8NN
file_formatchar(16)NN
locationchar(256)NN
pg_query_textchar(4000)NN
logging_tagchar(32)NN
warning_messagechar(4000)NN
is_recursivechar(1)NN
is_nestedchar(1)NN
s3list_timeint8NN
get_partition_timeint8NN
access_controlint4NN

pg_catalog.stll_hash
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
slotsint4NN
occupiedint4NN
maxlengthint4NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
num_partsint4NN
est_rowsint8NN
num_blocks_permittedint4NN
resizesint4NN
checksumint8NN
used_prefetchingchar(1)NN
runtime_filter_sizeint4NN
max_runtime_filter_sizeint4NN
runtime_filter_typeint4NN
is_hashed_subplanchar(1)NN
build_global_hash_tablechar(1)NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
slotsint4NN
occupiedint4NN
maxlengthint4NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
num_partsint4NN
est_rowsint8NN
num_blocks_permittedint4NN
resizesint4NN
checksumint8NN
used_prefetchingchar(1)NN
runtime_filter_sizeint4NN
max_runtime_filter_sizeint4NN
runtime_filter_typeint4NN
is_hashed_subplanchar(1)NN
build_global_hash_tablechar(1)NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
logtimetimestampNN
access_controlint4NN

pg_catalog.stll_hashjoin
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
tblint4NN
num_partsint4NN
join_typeint4NN
hash_loopedchar(1)NN
switched_partschar(1)NN
used_prefetchingchar(1)NN
hash_segmentint4NN
hash_stepint4NN
checksumint8NN
distributionint4NN
is_externalizedchar(1)NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
tblint4NN
num_partsint4NN
join_typeint4NN
hash_loopedchar(1)NN
switched_partschar(1)NN
used_prefetchingchar(1)NN
hash_segmentint4NN
hash_stepint4NN
checksumint8NN
distributionint4NN
is_externalizedchar(1)NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
access_controlint4NN

pg_catalog.stll_insert
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
tblint4NN
inserted_mega_valuechar(1)NN
use_staging_tablechar(1)NN
write_xidint8NN
reserve_rowidint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
tblint4NN
inserted_mega_valuechar(1)NN
use_staging_tablechar(1)NN
write_xidint8NN
reserve_rowidint4NN
access_controlint4NN

pg_catalog.stll_integration_cdc_detail
old
columndata typePKUNN
record_timetimestampNN
integration_idchar(128)NN
database_namechar(128)NN
checkpointchar(128)NN
source_typechar(128)NN
schema_namechar(128)NN
table_namechar(128)NN
statusint4NN
synced_log_coordinatechar(128)NN
src_insertsint8NN
src_deletesint8NN
src_updatesint8NN
insertsint8NN
inserts_dtint8NN
parsed_rowsint8NN
skipped_rowsint8NN
is_burstedint4NN
new
columndata typePKUNN
record_timetimestampNN
integration_idchar(128)NN
database_namechar(128)NN
checkpointchar(128)NN
source_typechar(128)NN
schema_namechar(128)NN
table_namechar(128)NN
statusint4NN
synced_log_coordinatechar(128)NN
src_insertsint8NN
src_deletesint8NN
src_updatesint8NN
insertsint8NN
inserts_dtint8NN
parsed_rowsint8NN
skipped_rowsint8NN
is_burstedint4NN
bytes_ingestedint8NN
updated_rowsint8NN
validation_statusint4NN
xidint8NN

pg_catalog.stll_limit
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
hit_limitchar(1)NN
checksumint8NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
hit_limitchar(1)NN
checksumint8NN
access_controlint4NN

pg_catalog.stll_load_history_base
old
columndata typePKUNN
user_idint4NN
dbchar(64)NN
xidint8NN
pidint4NN
query_idint8NN
child_query_sequenceint4NN
child_query_idint4NN
statusint4NN
table_namechar(128)NN
event_timetimestampNN
sliceint4NN
filenamechar(256)NN
file_countint4NN
file_bytesint8NN
file_count_scannedint4NN
file_bytes_scannedint8NN
bytes_copiedint8NN
rows_copiedint8NN
file_formatchar(16)NN
error_countint4NN
data_sourcechar(256)NN
copy_job_idint8NN
start_offsetint8NN
bytes_scannedint8NN
lines_scannedint8NN
start_timetimestampNN
end_timetimestampNN
new
columndata typePKUNN
user_idint4NN
dbchar(64)NN
xidint8NN
pidint4NN
query_idint8NN
child_query_sequenceint4NN
child_query_idint4NN
statusint4NN
table_namechar(128)NN
event_timetimestampNN
sliceint4NN
filenamechar(256)NN
file_countint4NN
file_bytesint8NN
file_count_scannedint4NN
file_bytes_scannedint8NN
bytes_copiedint8NN
rows_copiedint8NN
file_formatchar(16)NN
error_countint4NN
data_sourcechar(256)NN
copy_job_idint8NN
start_offsetint8NN
bytes_scannedint8NN
lines_scannedint8NN
start_timetimestampNN
end_timetimestampNN
file_etagchar(256)NN
file_last_modifiedtimestampNN

pg_catalog.stll_merge
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
access_controlint4NN

pg_catalog.stll_mergejoin
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
tblint4NN
checksumint8NN
distributionint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
tblint4NN
checksumint8NN
distributionint4NN
access_controlint4NN

pg_catalog.stll_nestloop
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
tblint4NN
checksumint8NN
distributionint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
tblint4NN
checksumint8NN
distributionint4NN
access_controlint4NN

pg_catalog.stll_parse
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
access_controlint4NN

pg_catalog.stll_plan_info
old
columndata typePKUNN
useridint4NN
queryint4NN
nodeidint4NN
segmentint4NN
stepint4NN
locusint4NN
plannodeint4NN
startupcostfloat8NN
totalcostfloat8NN
rowsint8NN
bytesint8NN
new
columndata typePKUNN
useridint4NN
queryint4NN
nodeidint4NN
segmentint4NN
stepint4NN
locusint4NN
plannodeint4NN
startupcostfloat8NN
totalcostfloat8NN
rowsint8NN
bytesint8NN
access_controlint4NN

pg_catalog.stll_project
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
checksumint8NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
checksumint8NN
access_controlint4NN

pg_catalog.stll_query
old
columndata typePKUNN
useridint4NN
queryint4NN
labelchar(320)NN
xidint8NN
pidint4NN
databasechar(32)NN
querytxtchar(4000)NN
starttimetimestampNN
endtimetimestampNN
abortedint4NN
insert_pristineint4NN
concurrency_scaling_statusint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
labelchar(320)NN
xidint8NN
pidint4NN
databasechar(32)NN
querytxtchar(4000)NN
starttimetimestampNN
endtimetimestampNN
abortedint4NN
insert_pristineint4NN
concurrency_scaling_statusint4NN
access_controlint4NN

pg_catalog.stll_query_detail
old
columndata typePKUNN
user_idint4NN
query_idint8NN
child_query_idint4NN
child_query_sequenceint4NN
stream_idint4NN
segment_idint4NN
step_idint4NN
sliceint4NN
starttimetimestampNN
endtimetimestampNN
step_nameint4NN
table_idint4NN
table_namechar(136)NN
input_rowsint8NN
input_bytesint8NN
output_rowsint8NN
output_bytesint8NN
is_rrscanchar(1)NN
blocks_readint8NN
blocks_writeint8NN
local_read_ioint8NN
remote_read_ioint8NN
alertchar(1024)NN
internal_querychar(1)NN
sourcechar(64)NN
cpu_timeint8NN
spilled_block_local_diskint8NN
spilled_block_remote_diskint8NN
step_attributechar(64)NN
new
columndata typePKUNN
user_idint4NN
query_idint8NN
child_query_idint4NN
child_query_sequenceint4NN
stream_idint4NN
segment_idint4NN
step_idint4NN
sliceint4NN
starttimetimestampNN
endtimetimestampNN
step_nameint4NN
table_idint4NN
table_namechar(136)NN
input_rowsint8NN
input_bytesint8NN
output_rowsint8NN
output_bytesint8NN
is_rrscanchar(1)NN
blocks_readint8NN
blocks_writeint8NN
local_read_ioint8NN
remote_read_ioint8NN
alertchar(1024)NN
internal_querychar(1)NN
sourcechar(64)NN
cpu_timeint8NN
spilled_block_local_diskint8NN
spilled_block_remote_diskint8NN
step_attributechar(64)NN
access_controlint4NN

pg_catalog.stll_query_metrics
old
columndata typePKUNN
useridint4NN
service_classint4NN
queryint4NN
segmentint4NN
step_typeint4NN
starttimetimestampNN
slicesint4NN
max_rowsint8NN
rowsint8NN
max_cpu_timeint8NN
cpu_timeint8NN
max_blocks_readint4NN
blocks_readint8NN
max_run_timeint8NN
run_timeint8NN
max_blocks_to_diskint8NN
blocks_to_diskint8NN
stepint4NN
max_query_scan_sizeint8NN
query_scan_sizeint8NN
query_priorityint4NN
query_queue_timeint8NN
service_class_namechar(64)NN
new
columndata typePKUNN
useridint4NN
service_classint4NN
queryint4NN
segmentint4NN
step_typeint4NN
starttimetimestampNN
slicesint4NN
max_rowsint8NN
rowsint8NN
max_cpu_timeint8NN
cpu_timeint8NN
max_blocks_readint4NN
blocks_readint8NN
max_run_timeint8NN
run_timeint8NN
max_blocks_to_diskint8NN
blocks_to_diskint8NN
stepint4NN
max_query_scan_sizeint8NN
query_scan_sizeint8NN
query_priorityint4NN
query_queue_timeint8NN
service_class_namechar(64)NN
access_controlint4NN

pg_catalog.stll_querytext
old
columndata typePKUNN
useridint4NN
xidint8NN
pidint4NN
queryint4NN
sequenceint4NN
textchar(200)NN
new
columndata typePKUNN
useridint4NN
xidint8NN
pidint4NN
queryint4NN
sequenceint4NN
textchar(200)NN
access_controlint4NN

pg_catalog.stll_restarted_sessions_internal
old
columndata typePKUNN
currenttimetimestampNN
is_reforkablechar(10)NN
temp_tbl_createdchar(10)NN
named_prep_stmt_ctint4NN
unnamed_stmt_ctint4NN
in_xact_blkchar(10)NN
is_read_onlychar(10)NN
is_single_stmt_querychar(10)NN
conn_statechar(100)NN
pidint4NN
in_authenticationchar(10)NN
is_bootstrapchar(10)NN
is_restarted_sessionchar(10)NN
is_extended_protocolchar(10)NN
is_idle_connectionchar(10)NN
current_executing_commandchar(10)NN
is_ssl_compressedchar(10)NN
is_protocol_v3char(10)NN
are_commands_repeatedchar(10)NN
unsupported_command_sequencechar(10)NN
can_reissue_querychar(10)NN
parked_state_in_proxychar(10)NN
session_sizeint8NN
is_inc_resizechar(10)NN
written_state_to_diskchar(10)NN
auto_resumechar(10)NN
query_command_sequencechar(32)NN
new
columndata typePKUNN
currenttimetimestampNN
is_reforkablechar(10)NN
temp_tbl_createdchar(10)NN
named_prep_stmt_ctint4NN
unnamed_stmt_ctint4NN
in_xact_blkchar(10)NN
is_read_onlychar(10)NN
is_single_stmt_querychar(10)NN
conn_statechar(100)NN
pidint4NN
in_authenticationchar(10)NN
is_bootstrapchar(10)NN
is_restarted_sessionchar(10)NN
is_extended_protocolchar(10)NN
is_idle_connectionchar(10)NN
current_executing_commandchar(10)NN
is_ssl_compressedchar(10)NN
is_protocol_v3char(10)NN
are_commands_repeatedchar(10)NN
unsupported_command_sequencechar(10)NN
can_reissue_querychar(10)NN
parked_state_in_proxychar(10)NN
session_sizeint8NN
is_inc_resizechar(10)NN
written_state_to_diskchar(10)NN
auto_resumechar(10)NN
query_command_sequencechar(32)NN
is_fas_setchar(10)NN

pg_catalog.stll_return
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
packetsint4NN
checksumint8NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
packetsint4NN
checksumint8NN
access_controlint4NN

pg_catalog.stll_rtree
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
mem_allowance_for_indexint8NN
cheating_memint8NN
index_predicted_sizeint8NN
index_sizeint8NN
insert_durationint8NN
build_durationint8NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
mem_allowance_for_indexint8NN
cheating_memint8NN
index_predicted_sizeint8NN
index_sizeint8NN
insert_durationint8NN
build_durationint8NN
access_controlint4NN

pg_catalog.stll_s3list
old
columndata typePKUNN
useridint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
nodeint4NN
sliceint4NN
eventtimetimestampNN
bucketchar(256)NN
prefixchar(256)NN
recursivechar(1)NN
retrieved_filesint4NN
max_file_sizeint8NN
avg_file_sizefloat8NN
durationint8NN
generated_splitsint4NN
avg_split_lengthfloat8NN
scan_typeint4NN
list_typeint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
nodeint4NN
sliceint4NN
eventtimetimestampNN
bucketchar(256)NN
prefixchar(256)NN
recursivechar(1)NN
retrieved_filesint4NN
max_file_sizeint8NN
avg_file_sizefloat8NN
durationint8NN
generated_splitsint4NN
avg_split_lengthfloat8NN
scan_typeint4NN
list_typeint4NN
access_controlint4NN

pg_catalog.stll_s3log
old
columndata typePKUNN
useridint4NN
is_internalint4NN
pidint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
stepint4NN
nodeint4NN
sliceint4NN
eventtimetimestampNN
messagechar(512)NN
scan_typeint4NN
request_idchar(16)NN
error_typeint4NN
spectrum_error_codeint4NN
new
columndata typePKUNN
useridint4NN
is_internalint4NN
pidint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
stepint4NN
nodeint4NN
sliceint4NN
eventtimetimestampNN
messagechar(512)NN
scan_typeint4NN
request_idchar(16)NN
error_typeint4NN
spectrum_error_codeint4NN
access_controlint4NN

pg_catalog.stll_s3partition_elimination
old
columndata typePKUNN
useridint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
nodeint4NN
sliceint4NN
starttimetimestampNN
endtimetimestampNN
total_partitionsint4NN
qualified_partitionsint4NN
assignmentchar(1)NN
durationint8NN
assigned_partitionsint4NN
scan_typeint4NN
fetched_partitionsint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
nodeint4NN
sliceint4NN
starttimetimestampNN
endtimetimestampNN
total_partitionsint4NN
qualified_partitionsint4NN
assignmentchar(1)NN
durationint8NN
assigned_partitionsint4NN
scan_typeint4NN
fetched_partitionsint4NN
access_controlint4NN

pg_catalog.stll_s3query
old
columndata typePKUNN
useridint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
stepint4NN
nodeint4NN
sliceint4NN
starttimetimestampNN
endtimetimestampNN
external_table_namechar(136)NN
is_partitionedchar(1)NN
is_rrscanchar(1)NN
s3_scanned_rowsint8NN
s3_scanned_bytesint8NN
s3query_returned_rowsint8NN
s3query_returned_bytesint8NN
filesint4NN
total_retriesint4NN
max_retriesint4NN
max_request_durationint8NN
avg_request_durationint8NN
max_request_parallelismint4NN
max_allowed_parallelismint4NN
avg_request_parallelismfloat8NN
splitsint4NN
total_split_sizeint8NN
max_split_sizeint8NN
request_fingerprintint8NN
file_formatchar(16)NN
cache_hitsint4NN
is_copyint4NN
is_nestedchar(1)NN
slowdown_countint4NN
max_concurrent_slowdown_countint4NN
s3_billable_scanned_bytesint8NN
scan_typeint4NN
s3query_returned_uncompressed_bytesint8NN
is_lakeformationint4NN
is_governedint4NN
transaction_idchar(32)NN
query_as_of_timetimestampNN
throttled_requestsint4NN
peakmemint8NN
is_localint4NN
is_evrint4NN
has_cell_level_securityint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
stepint4NN
nodeint4NN
sliceint4NN
starttimetimestampNN
endtimetimestampNN
external_table_namechar(136)NN
is_partitionedchar(1)NN
is_rrscanchar(1)NN
s3_scanned_rowsint8NN
s3_scanned_bytesint8NN
s3query_returned_rowsint8NN
s3query_returned_bytesint8NN
filesint4NN
total_retriesint4NN
max_retriesint4NN
max_request_durationint8NN
avg_request_durationint8NN
max_request_parallelismint4NN
max_allowed_parallelismint4NN
avg_request_parallelismfloat8NN
splitsint4NN
total_split_sizeint8NN
max_split_sizeint8NN
request_fingerprintint8NN
file_formatchar(16)NN
cache_hitsint4NN
is_copyint4NN
is_nestedchar(1)NN
slowdown_countint4NN
max_concurrent_slowdown_countint4NN
s3_billable_scanned_bytesint8NN
scan_typeint4NN
s3query_returned_uncompressed_bytesint8NN
is_lakeformationint4NN
is_governedint4NN
transaction_idchar(32)NN
query_as_of_timetimestampNN
throttled_requestsint4NN
peakmemint8NN
is_localint4NN
is_evrint4NN
has_cell_level_securityint4NN
access_controlint4NN

pg_catalog.stll_s3retries
old
columndata typePKUNN
useridint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
nodeint4NN
sliceint4NN
eventtimetimestampNN
retriesint4NN
successful_fetchesint4NN
file_sizeint8NN
start_offsetint8NN
lengthint8NN
locationchar(256)NN
messagechar(256)NN
retry_backoff_msint4NN
scan_typeint4NN
timeoutint8NN
connect_retriesint4NN
connect_timetimestampNN
exectask_timetimestampNN
fast_forward_fetch_timetimestampNN
fetch_timetimestampNN
request_idchar(16)NN
stateint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
uuidchar(36)NN
segmentint4NN
nodeint4NN
sliceint4NN
eventtimetimestampNN
retriesint4NN
successful_fetchesint4NN
file_sizeint8NN
start_offsetint8NN
lengthint8NN
locationchar(256)NN
messagechar(256)NN
retry_backoff_msint4NN
scan_typeint4NN
timeoutint8NN
connect_retriesint4NN
connect_timetimestampNN
exectask_timetimestampNN
fast_forward_fetch_timetimestampNN
fetch_timetimestampNN
request_idchar(16)NN
stateint4NN
access_controlint4NN

pg_catalog.stll_save
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
is_save_rtfchar(1)NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
is_save_rtfchar(1)NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
access_controlint4NN

pg_catalog.stll_scan
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
fetchesint8NN
typeint4NN
tblint4NN
is_rrscanchar(1)NN
is_delayed_scanchar(1)NN
rows_pre_filterint8NN
rows_pre_user_filterint8NN
perm_table_namechar(136)NN
is_rlf_scanchar(1)NN
is_rlf_scan_reasonint4NN
num_em_blocksint4NN
checksumint8NN
runtime_filteringchar(1)NN
scan_regionint4NN
num_sortkey_as_predicateint4NN
row_fetcher_stateint4NN
consumed_scan_rangesint8NN
work_stealing_reasonint8NN
is_vectorized_scanchar(1)NN
is_vectorized_scan_reasonint4NN
row_fetcher_reasonint8NN
topology_signatureint8NN
use_tpm_partitionchar(1)NN
is_rrscan_exprchar(1)NN
use_fwd_mtx_optchar(1)NN
scanned_mega_valuechar(1)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
fetchesint8NN
typeint4NN
tblint4NN
is_rrscanchar(1)NN
is_delayed_scanchar(1)NN
rows_pre_filterint8NN
rows_pre_user_filterint8NN
perm_table_namechar(136)NN
is_rlf_scanchar(1)NN
is_rlf_scan_reasonint4NN
num_em_blocksint4NN
checksumint8NN
runtime_filteringchar(1)NN
scan_regionint4NN
num_sortkey_as_predicateint4NN
row_fetcher_stateint4NN
consumed_scan_rangesint8NN
work_stealing_reasonint8NN
is_vectorized_scanchar(1)NN
is_vectorized_scan_reasonint4NN
row_fetcher_reasonint8NN
topology_signatureint8NN
use_tpm_partitionchar(1)NN
is_rrscan_exprchar(1)NN
use_fwd_mtx_optchar(1)NN
scanned_mega_valuechar(1)NN
access_controlint4NN

pg_catalog.stll_sort
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
checksumint8NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
tblint4NN
is_diskbasedchar(1)NN
workmemint8NN
checksumint8NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
access_controlint4NN

pg_catalog.stll_spatial_join
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
rtree_segmentint4NN
rtree_stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
predicateint4NN
rowsint8NN
pruned_tuplesint8NN
tblint4NN
checksumint8NN
distributionint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
rtree_segmentint4NN
rtree_stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
predicateint4NN
rowsint8NN
pruned_tuplesint8NN
tblint4NN
checksumint8NN
distributionint4NN
access_controlint4NN

pg_catalog.stll_spectrum_scan_error
old
columndata typePKUNN
useridint4NN
queryint4NN
locationchar(256)NN
rowidchar(2100)NN
colnamechar(127)NN
original_valuechar(1024)NN
modified_valuechar(1024)NN
triggerint4NN
actionint4NN
action_valuechar(127)NN
error_codeint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
locationchar(256)NN
rowidchar(2100)NN
colnamechar(127)NN
original_valuechar(1024)NN
modified_valuechar(1024)NN
triggerint4NN
actionint4NN
action_valuechar(127)NN
error_codeint4NN
access_controlint4NN

pg_catalog.stll_stored_proc_call
old
columndata typePKUNN
useridint4NN
session_useridint4NN
queryint4NN
labelchar(320)NN
xidint8NN
pidint4NN
databasechar(32)NN
querytxtchar(500)NN
starttimetimestampNN
endtimetimestampNN
abortedint4NN
new
columndata typePKUNN
useridint4NN
session_useridint4NN
queryint4NN
labelchar(320)NN
xidint8NN
pidint4NN
databasechar(32)NN
querytxtchar(500)NN
starttimetimestampNN
endtimetimestampNN
abortedint4NN
access_controlint4NN

pg_catalog.stll_stored_proc_messages
old
columndata typePKUNN
useridint4NN
queryint4NN
loglevelint4NN
messagechar(1024)NN
linenumint4NN
recordtimetimestampNN
message_xidint8NN
new
columndata typePKUNN
useridint4NN
queryint4NN
loglevelint4NN
messagechar(1024)NN
linenumint4NN
recordtimetimestampNN
message_xidint8NN
access_controlint4NN

pg_catalog.stll_tr_conflict
old
columndata typePKUNN
xact_idint8NN
process_idint8NN
xact_start_tstimestampNN
abort_timetimestampNN
table_idint8NN
new
columndata typePKUNN
xact_idint8NN
process_idint8NN
xact_start_tstimestampNN
abort_timetimestampNN
table_idint8NN
access_controlint4NN

pg_catalog.stll_udf_log
old
columndata typePKUNN
queryint8NN
messagechar(4096)NN
createdtimestampNN
filenamechar(256)NN
funcnamechar(256)NN
level_namechar(64)NN
level_numberint4NN
linenoint4NN
modulechar(256)NN
msecsfloat8NN
namechar(256)NN
path_namechar(256)NN
processint8NN
process_namechar(256)NN
relative_createdfloat8NN
threadint8NN
thread_namechar(256)NN
tracebackchar(4096)NN
nodeint4NN
sliceint4NN
seqint4NN
new
columndata typePKUNN
queryint8NN
messagechar(4096)NN
createdtimestampNN
filenamechar(256)NN
funcnamechar(256)NN
level_namechar(64)NN
level_numberint4NN
linenoint4NN
modulechar(256)NN
msecsfloat8NN
namechar(256)NN
path_namechar(256)NN
processint8NN
process_namechar(256)NN
relative_createdfloat8NN
threadint8NN
thread_namechar(256)NN
tracebackchar(4096)NN
nodeint4NN
sliceint4NN
seqint4NN
access_controlint4NN

pg_catalog.stll_undone
old
columndata typePKUNN
useridint4NN
xact_idint8NN
xact_id_undoneint8NN
undo_start_tstimestampNN
undo_end_tstimestampNN
table_idint8NN
new
columndata typePKUNN
useridint4NN
xact_idint8NN
xact_id_undoneint8NN
undo_start_tstimestampNN
undo_end_tstimestampNN
table_idint8NN
access_controlint4NN

pg_catalog.stll_unique
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
typechar(6)NN
is_diskbasedchar(1)NN
slotsint4NN
workmemint8NN
max_buffers_usedint8NN
resizesint4NN
occupiedint4NN
flushableint4NN
used_unique_prefetchingchar(1)NN
bytesint8NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
typechar(6)NN
is_diskbasedchar(1)NN
slotsint4NN
workmemint8NN
max_buffers_usedint8NN
resizesint4NN
occupiedint4NN
flushableint4NN
used_unique_prefetchingchar(1)NN
bytesint8NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
access_controlint4NN

pg_catalog.stll_unnest
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
access_controlint4NN

pg_catalog.stll_user_query_history
old
columndata typePKUNN
user_idint4NN
query_idint8NN
labelchar(320)NN
xidint8NN
pidint4NN
database_namechar(128)NN
query_typechar(32)NN
statuschar(10)NN
result_cache_source_queryint8NN
start_timetimestampNN
end_timetimestampNN
queue_timeint8NN
execution_timeint8NN
error_messagechar(512)NN
returned_rowsint8NN
returned_bytesint8NN
redshift_versionchar(32)NN
usage_limitchar(150)NN
internal_querychar(1)NN
query_textchar(4000)NN
compute_typechar(32)NN
compile_timeint8NN
planning_timeint8NN
pure_planning_timeint8NN
lock_wait_timeint8NN
new
columndata typePKUNN
user_idint4NN
query_idint8NN
labelchar(320)NN
xidint8NN
pidint4NN
database_namechar(128)NN
query_typechar(32)NN
statuschar(10)NN
result_cache_source_queryint8NN
start_timetimestampNN
end_timetimestampNN
queue_timeint8NN
execution_timeint8NN
error_messagechar(512)NN
returned_rowsint8NN
returned_bytesint8NN
redshift_versionchar(32)NN
usage_limitchar(150)NN
internal_querychar(1)NN
query_textchar(4000)NN
compute_typechar(32)NN
compile_timeint8NN
planning_timeint8NN
pure_planning_timeint8NN
lock_wait_timeint8NN
access_controlint4NN

pg_catalog.stll_utilitytext
old
columndata typePKUNN
useridint4NN
xidint8NN
pidint4NN
labelchar(320)NN
starttimetimestampNN
endtimetimestampNN
sequenceint4NN
textchar(200)NN
new
columndata typePKUNN
useridint4NN
xidint8NN
pidint4NN
labelchar(320)NN
starttimetimestampNN
endtimetimestampNN
sequenceint4NN
textchar(200)NN
access_controlint4NN

pg_catalog.stll_window
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
is_diskbasedchar(1)NN
workmemint8NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
endtimetimestampNN
tasknumint4NN
rowsint8NN
is_diskbasedchar(1)NN
workmemint8NN
used_mega_blockchar(1)NN
memory_usage_ratioint4NN
access_controlint4NN

pg_catalog.stv_blocklist
old
columndata typePKUNN
sliceint4NN
colint4NN
tblint4NN
blocknumint4NN
num_valuesint4NN
extended_limitsint4NN
minvalueint8NN
maxvalueint8NN
sb_posint4NN
pinnedint4NN
on_diskint4NN
backed_upint4NN
modifiedint4NN
hdr_modifiedint4NN
unsortedint4NN
tombstoneint4NN
preferred_disknoint4NN
temporaryint4NN
newblockint4NN
num_readersint4NN
idchar(64)NN
flagsint4NN
new
columndata typePKUNN
sliceint4NN
colint4NN
tblint4NN
blocknumint4NN
num_valuesint4NN
extended_limitsint4NN
minvalueint8NN
maxvalueint8NN
sb_posint4NN
pinnedint4NN
on_diskint4NN
backed_upint4NN
modifiedint4NN
hdr_modifiedint4NN
unsortedint4NN
tombstoneint4NN
preferred_disknoint4NN
temporaryint4NN
newblockint4NN
num_readersint4NN
idchar(64)NN
flagsint4NN
access_controlint4NN

pg_catalog.stv_exec_state
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
currenttimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
labelchar(256)NN
is_diskbasedchar(1)NN
workmemint8NN
num_partsint4NN
is_rrscanchar(1)NN
is_delayed_scanchar(1)NN
step_attributechar(64)NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
starttimetimestampNN
currenttimetimestampNN
tasknumint4NN
rowsint8NN
bytesint8NN
labelchar(256)NN
is_diskbasedchar(1)NN
workmemint8NN
num_partsint4NN
is_rrscanchar(1)NN
is_delayed_scanchar(1)NN
step_attributechar(64)NN
access_controlint4NN

pg_catalog.stv_locks
old
columndata typePKUNN
table_idint8NN
last_committimestampNN
last_updatetimestampNN
lock_ownerint8NN
lock_owner_pidint8NN
lock_owner_start_tstimestampNN
lock_owner_end_tstimestampNN
lock_statuschar(22)NN
new
columndata typePKUNN
table_idint8NN
last_committimestampNN
last_updatetimestampNN
lock_ownerint8NN
lock_owner_pidint8NN
lock_owner_start_tstimestampNN
lock_owner_end_tstimestampNN
lock_statuschar(22)NN
access_controlint4NN

pg_catalog.stv_query_metrics
old
columndata typePKUNN
useridint4NN
service_classint4NN
queryint4NN
segmentint4NN
step_typeint4NN
starttimetimestampNN
slicesint4NN
max_rowsint8NN
rowsint8NN
max_cpu_timeint8NN
cpu_timeint8NN
max_blocks_readint4NN
blocks_readint8NN
max_run_timeint8NN
run_timeint8NN
max_blocks_to_diskint8NN
blocks_to_diskint8NN
stepint4NN
max_query_scan_sizeint8NN
query_scan_sizeint8NN
query_priorityint4NN
query_queue_timeint8NN
new
columndata typePKUNN
useridint4NN
service_classint4NN
queryint4NN
segmentint4NN
step_typeint4NN
starttimetimestampNN
slicesint4NN
max_rowsint8NN
rowsint8NN
max_cpu_timeint8NN
cpu_timeint8NN
max_blocks_readint4NN
blocks_readint8NN
max_run_timeint8NN
run_timeint8NN
max_blocks_to_diskint8NN
blocks_to_diskint8NN
stepint4NN
max_query_scan_sizeint8NN
query_scan_sizeint8NN
query_priorityint4NN
query_queue_timeint8NN
access_controlint4NN

pg_catalog.stv_startup_recovery_state
old
columndata typePKUNN
db_idint4NN
table_idint4NN
table_namechar(137)NN
new
columndata typePKUNN
db_idint4NN
table_idint4NN
table_namechar(137)NN
access_controlint4NN

pg_catalog.stv_table_partitions
old
columndata typePKUNN
idint4NN
sliceint4NN
partition_idint8NN
rowsint8NN
flagsint4NN
num_blocksint8NN
num_overlapping_partitionsint4NN
degree_of_overlapint4NN
is_hotchar(1)NN
is_sortedchar(1)NN
is_range_partitionedchar(1)NN
qpdint4NN
total_wasted_blocksint8NN
total_blocks_readint8NN
total_blocks_usedint8NN
no_loss_scans_countint8NN
zero_bias_scans_countint8NN
scan_countint8NN
first_qpd_rise_tstimestampNN
first_marked_hot_tstimestampNN
num_scans_to_mark_hotint8NN
new
columndata typePKUNN
idint4NN
sliceint4NN
partition_idint8NN
rowsint8NN
flagsint4NN
num_blocksint8NN
num_overlapping_partitionsint4NN
degree_of_overlapint4NN
is_hotchar(1)NN
is_sortedchar(1)NN
is_range_partitionedchar(1)NN
qpdint4NN
total_wasted_blocksint8NN
total_blocks_readint8NN
total_blocks_usedint8NN
no_loss_scans_countint8NN
zero_bias_scans_countint8NN
scan_countint8NN
first_qpd_rise_tstimestampNN
first_marked_hot_tstimestampNN
num_scans_to_mark_hotint8NN
is_graftedchar(1)NN

pg_catalog.stv_tbl_column_slice_state
old
columndata typePKUNN
nodeint4NN
table_idint4NN
colint4NN
sliceint4NN
num_blocksint4NN
new
columndata typePKUNN
nodeint4NN
table_idint4NN
colint4NN
sliceint4NN
num_blocksint4NN
access_controlint4NN

pg_catalog.stv_tbl_perm
old
columndata typePKUNN
sliceint4NN
idint4NN
namechar(128)NN
rowsint8NN
sorted_rowsint8NN
tempint4NN
db_idint4NN
insert_pristineint4NN
delete_pristineint4NN
backupint4NN
dist_styleint4NN
block_countint4NN
new
columndata typePKUNN
sliceint4NN
idint4NN
namechar(128)NN
rowsint8NN
sorted_rowsint8NN
tempint4NN
db_idint4NN
insert_pristineint4NN
delete_pristineint4NN
backupint4NN
dist_styleint4NN
block_countint4NN
access_controlint4NN

pg_catalog.stv_tbl_trans
old
columndata typePKUNN
sliceint4NN
idint4NN
rowsint8NN
sizeint8NN
query_idint8NN
ref_cntint4NN
from_suspendedint4NN
prep_swapint4NN
new
columndata typePKUNN
sliceint4NN
idint4NN
rowsint8NN
sizeint8NN
query_idint8NN
ref_cntint4NN
from_suspendedint4NN
prep_swapint4NN
access_controlint4NN

pg_catalog.stv_user_query_state
old
columndata typePKUNN
user_idint4NN
query_idint8NN
labelchar(320)NN
xidint8NN
pidint4NN
database_namechar(128)NN
query_typechar(32)NN
statuschar(10)NN
result_cache_source_queryint8NN
start_timetimestampNN
end_timetimestampNN
nowtimestampNN
status_update_timetimestampNN
queue_timeint8NN
execution_timeint8NN
error_messagechar(512)NN
returned_rowsint8NN
returned_bytesint8NN
redshift_versionchar(32)NN
usage_limitchar(150)NN
internal_querychar(1)NN
query_textchar(4000)NN
compute_typechar(32)NN
compile_timeint8NN
planning_timeint8NN
pure_planning_timeint8NN
lock_wait_timeint8NN
new
columndata typePKUNN
user_idint4NN
query_idint8NN
labelchar(320)NN
xidint8NN
pidint4NN
database_namechar(128)NN
query_typechar(32)NN
statuschar(10)NN
result_cache_source_queryint8NN
start_timetimestampNN
end_timetimestampNN
nowtimestampNN
status_update_timetimestampNN
queue_timeint8NN
execution_timeint8NN
error_messagechar(512)NN
returned_rowsint8NN
returned_bytesint8NN
redshift_versionchar(32)NN
usage_limitchar(150)NN
internal_querychar(1)NN
query_textchar(4000)NN
compute_typechar(32)NN
compile_timeint8NN
planning_timeint8NN
pure_planning_timeint8NN
lock_wait_timeint8NN
access_controlint4NN

pg_internal.redshift_auto_health_check_5579497
old
columndata typePKUNN
deletexidint8NN
insertxidint8NN
oidoidNN
aint4
new
columndata typePKUNN

Views

pg_catalog.stl_applied_masking_policy
old
columndata type
new
columndata type
polidint4
user_idint4
record_timetimestamp
pidint4
xidint8
query_idint8
dbidint4
relidint4
relation_kindchar(30)

pg_catalog.stl_async_rerep_worker_stats
old
columndata type
new
columndata type
logtimetimestamp
node_numint4
issued_rerep_readsint8
issued_rerep_writesint8
issued_dirty_writesint8
completed_rerep_readsint8
completed_rerep_writesint8
completed_dirty_writesint8
ignored_rerep_readsint8
ignored_rerep_writesint8
ignored_dirty_writesint8
rerep_pool_exhaustedint8
ignored_comp_table_not_in_active_setint8
ignored_comp_block_state_changedint8
ignored_comp_block_pinned_during_writeint8

pg_catalog.stl_auto_task_cost_benefit
old
columndata type
new
columndata type
task_typechar(100)
estimation_typechar(50)
estimation_in_secondsfloat8
real_val_in_secondsfloat8
event_timetimestamp
task_idint8
task_targetint4

pg_catalog.stl_burst_user_temp_table_stats
old
columndata type
new
columndata type
recordtimetimestamp
xidint8
queryint8
query_priorityint4
total_blocksint8
blocks_not_in_s3int8
num_temp_tablesint4
block_replication_start_timetimestamp
block_replication_end_timetimestamp
metadata_serialize_duration_main_msfloat8
metadata_deserialize_duration_burst_msfloat8
query_exec_statechar(30)

pg_catalog.stl_burst_write_transactions
old
columndata type
new
columndata type
xidint8
statusint4
timestamptimestamp

pg_catalog.stl_conjunct_hash
old
columndata type
new
columndata type
useridint4
queryint4
nodeidint4
parentidint4
conjunctint4
conjunct_hashchar(64)

pg_catalog.stl_conjunct_hash_mapping
old
columndata type
new
columndata type
tblint4
conjunct_hashchar(64)
conjunct_textchar(4000)

pg_catalog.stl_insertion_point_bindings
old
columndata type
new
columndata type
query_idint4
tblint4
stage_tblint4
ip_idint4
timetimestamp

pg_catalog.stl_insertion_point_reservations
old
columndata type
new
columndata type
query_idint4
tblint4
data_sliceint4
strategyint4
eventint4
ip_idint4
typeint4
writer_group_indexint4
writer_indexint4
timetimestamp

pg_catalog.stl_optima_resource_usage
old
columndata type
new
columndata type
recordtimetimestamp
optima_last_day_end_timestamp_secint8
optima_consumed_rpu_msecint8
optima_accrued_rpu_msecint8
num_atcs_query_running_queuingint4

pg_catalog.stl_pg_query_execution_info
old
columndata type
new
columndata type
recordtimetimestamp
query_idint8
pidint4
xidint8
user_idint4
checkpointint4
time_consumption_usint8

pg_catalog.stl_process_registry_history
old
columndata type
new
columndata type
padb_start_timetimestamp
timestamptimestamp
node_numberint4
procnamechar(32)
pidint4
is_criticalint4
is_registerint4

pg_catalog.stl_resource_forecaster_event
old
columndata type
new
columndata type
event_timetimestamp
componentint4
event_typeint4
descriptionchar(400)

pg_catalog.stl_resource_forecaster_inference
old
columndata type
new
columndata type
prediction_starttimetimestamp
prediction_endtimetimestamp
prediction_bucket_indexint4
modelint4
sequenceint4
json_datachar(400)

pg_catalog.stl_resource_forecaster_training
old
columndata type
new
columndata type
starttimetimestamp
endtimetimestamp
sequenceint4
json_datachar(400)

pg_catalog.stl_sage_mode_policy
old
columndata type
new
columndata type
policy_idint4
optimization_start_timetimestamp
creation_timetimestamp
expiration_timetimestamp
performance_levelint4
resize_configchar(200)
current_size_configchar(200)
simulated_cost_rpu_secfloat8
simulated_avg_response_time_secfloat8
selectedint4
used_forecastint4

pg_catalog.stl_sage_resize
old
columndata type
new
columndata type
record_timetimestamp
current_rpusint4
target_rpusint4
errorchar(256)
policy_idint4
triggerint4

pg_catalog.stl_storage_oid_events
old
columndata type
new
columndata type
xidint8
eventchar(256)
table_idint4
remote_oidint4
useridint4
pidint4
recordtimetimestamp
current_dml_versionint8
current_structure_versionint8
current_sb_versionint8
current_ddl_versionint8
hostchar(256)
databasechar(256)
schemachar(256)
table_namechar(256)
table_sizeint8
dirtiness_typechar(20)
total_grafted_superblock_sizeint8
storage_oid_table_countint4

pg_catalog.stl_tuple_crc_metrics
old
columndata type
new
columndata type
log_timetimestamp
num_hitsint8
num_missesint8
num_resetsint8
total_num_invalidationsint8

pg_catalog.stl_vacuum_lock_time
old
columndata type
new
columndata type
xidint8
queryint4
tbl_idint4
lock_typeint4
vac_typeint4
starttimetimestamp
endtimetimestamp
num_colsint4
optimizedint4

pg_catalog.sys_applied_masking_policy_log
old
columndata type
new
columndata type
policy_nametext
user_idint4
record_timetimestamp
session_idint4
transaction_idint8
query_idint8
database_nametext
relation_nametext
schema_nametext
attachment_idoid
relation_kindchar(30)

pg_catalog.stl_burst_manager_personalization
old
columndata type
useridint4
pidint8
xidint8
starttimetimestamp
endtimetimestamp
cluster_arnchar(128)
backup_idchar(100)
backup_prefixchar(100)
backup_midfixchar(100)
creds_access_keychar(100)
creds_secret_keychar(100)
creds_session_tokenchar(100)
creds_expirationtimestamp
cluster_idchar(38)
cluster_namechar(70)
errorchar(250)
account_idchar(38)
queryint4
auto_wlm_total_memory_mbint4
auto_wlm_per_query_max_memory_mbint4
instance_typechar(100)
num_nodesint4
burst_cluster_idchar(38)
burst_account_idchar(38)
burst_cluster_versionchar(50)
main_instance_typechar(100)
main_num_nodesint4
main_num_slicesint4
refreshed_backup_idchar(100)
refreshed_versionint4
refreshing_backup_idchar(100)
refreshing_versionint4
new
columndata type
useridint4
pidint8
xidint8
starttimetimestamp
endtimetimestamp
cluster_arnchar(128)
backup_idchar(100)
backup_prefixchar(100)
backup_midfixchar(100)
creds_access_keychar(100)
creds_secret_keychar(100)
creds_session_tokenchar(100)
creds_expirationtimestamp
cluster_idchar(38)
cluster_namechar(70)
errorchar(250)
account_idchar(38)
queryint4
auto_wlm_total_memory_mbint4
auto_wlm_per_query_max_memory_mbint4
instance_typechar(100)
num_nodesint4
burst_cluster_idchar(38)
burst_account_idchar(38)
burst_cluster_versionchar(50)
main_instance_typechar(100)
main_num_nodesint4
main_num_slicesint4
refreshed_backup_idchar(100)
refreshed_versionint4
refreshing_backup_idchar(100)
refreshing_versionint4
burst_requested_nodesint4

pg_catalog.stl_burst_write_block_header_trace
old
columndata type
xidint8
queryint8
tblint4
nodeint4
block_header_rcvdint8
rcvd_timetimestamp
new
columndata type
xidint8
queryint8
tblint4
nodeint4
block_header_rcvdint8
rcvd_timetimestamp
remote_write_typeint4

pg_catalog.stl_burst_write_exec
old
columndata type
pidint8
xidint8
queryint8
query_start_timetimestamp
flush_start_timetimestamp
stream_start_timetimestamp
stream_end_timetimestamp
dispatch_start_timetimestamp
snap_in_start_timetimestamp
snap_in_end_timetimestamp
new
columndata type
pidint8
xidint8
queryint8
query_start_timetimestamp
flush_start_timetimestamp
stream_start_timetimestamp
stream_end_timetimestamp
dispatch_start_timetimestamp
snap_in_start_timetimestamp
snap_in_end_timetimestamp
dispatch_end_timetimestamp
remote_write_typeint4

pg_catalog.stl_comm_pkt_oob_count
old
columndata type
nowtimestamp
sincetimestamp
nodeint4
is_raidpint4
bad_guidint4
no_channelint4
bad_srcint4
bad_dstint4
bad_cmdint4
bad_crcint4
excess_ackint4
low_seqnumint4
high_seqnumint4
early_xonint4
lost_packetint4
reorder_packetint4
likely_lost_ackint4
extreme_delayint4
in_robint4
excess_fast_rexmitint4
new
columndata type
nowtimestamp
sincetimestamp
nodeint4
channel_typeint4
bad_guidint4
no_channelint4
bad_srcint4
bad_dstint4
bad_cmdint4
bad_crcint4
excess_ackint4
low_seqnumint4
high_seqnumint4
early_xonint4
lost_packetint4
reorder_packetint4
likely_lost_ackint4
extreme_delayint4
in_robint4
excess_fast_rexmitint4

pg_catalog.stl_comm_pkt_sent_count
old
columndata type
nowtimestamp
sincetimestamp
src_nodeint4
dest_nodeint4
is_raidpint4
bytesint8
rexmitint4
xonint4
replyint4
ackint4
packetint4
fast_rexmitint4
original_ackint4
new
columndata type
nowtimestamp
sincetimestamp
src_nodeint4
dest_nodeint4
channel_typeint4
bytesint8
rexmitint4
xonint4
replyint4
ackint4
packetint4
fast_rexmitint4
original_ackint4

pg_catalog.stl_comm_pkt_size
old
columndata type
sincetimestamp
nowtimestamp
dest_nodeint4
is_socketint4
cmd_codechar(64)
meanfloat8
stdevfloat8
minint8
maxint8
totalint4
less_than_100int4
less_than_1000int4
less_than_10000int4
infint4
new
columndata type
sincetimestamp
nowtimestamp
src_nodeint4
dest_nodeint4
is_socketint4
cmd_codechar(64)
meanfloat8
stdevfloat8
minint8
maxint8
totalint4
less_than_100int4
less_than_1000int4
less_than_10000int4
infint4

pg_catalog.stl_datashare_query_info
old
columndata type
useridint4
leaderpidint4
xidint8
queryint4
table_idint4
current_dml_versionint8
current_sructure_versionint8
current_sb_versionint8
current_ddl_versionint8
target_dml_versionint8
target_structure_versionint8
target_sb_versionint8
target_ddl_versionint8
leader_node_start_timetimestamp
leader_node_end_timetimestamp
nodeint4
compute_node_start_timetimestamp
compute_node_end_timetimestamp
refresh_queue_start_timetimestamp
refresh_queue_end_timetimestamp
sb_download_grafting_start_timetimestamp
sb_download_grafting_end_timetimestamp
total_sb_download_secondsfloat8
total_sb_batchesint4
changed_headersint8
table_grafting_modechar(16)
sb_download_modechar(16)
superblock_typechar(256)
schema_name_table_namechar(256)
table_sizeint8
total_log_entries_changedint8
total_sb_sizeint8
num_cols_graftedint4
total_num_colsint4
graft_batch_numint4
new
columndata type
useridint4
leaderpidint4
xidint8
queryint4
table_idint4
current_dml_versionint8
current_sructure_versionint8
current_sb_versionint8
current_ddl_versionint8
target_dml_versionint8
target_structure_versionint8
target_sb_versionint8
target_ddl_versionint8
leader_node_start_timetimestamp
leader_node_end_timetimestamp
nodeint4
compute_node_start_timetimestamp
compute_node_end_timetimestamp
refresh_queue_start_timetimestamp
refresh_queue_end_timetimestamp
sb_download_grafting_start_timetimestamp
sb_download_grafting_end_timetimestamp
total_sb_download_secondsfloat8
total_sb_batchesint4
changed_headersint8
table_grafting_modechar(16)
sb_download_modechar(16)
superblock_typechar(256)
schema_name_table_namechar(256)
table_sizeint8
total_log_entries_changedint8
total_sb_sizeint8
num_cols_graftedint4
total_num_colsint4
graft_batch_numint4
access_modechar(16)

pg_catalog.stl_hash
old
columndata type
useridint4
queryint4
sliceint4
segmentint4
stepint4
starttimetimestamp
endtimetimestamp
tasknumint4
rowsint8
bytesint8
slotsint4
occupiedint4
maxlengthint4
tblint4
is_diskbasedchar(1)
workmemint8
num_partsint4
est_rowsint8
num_blocks_permittedint4
resizesint4
checksumint8
used_prefetchingchar(1)
runtime_filter_sizeint4
max_runtime_filter_sizeint4
runtime_filter_typeint4
is_hashed_subplanchar(1)
build_global_hash_tablechar(1)
used_mega_blockchar(1)
memory_usage_ratioint4
new
columndata type
useridint4
queryint4
sliceint4
segmentint4
stepint4
starttimetimestamp
endtimetimestamp
tasknumint4
rowsint8
bytesint8
slotsint4
occupiedint4
maxlengthint4
tblint4
is_diskbasedchar(1)
workmemint8
num_partsint4
est_rowsint8
num_blocks_permittedint4
resizesint4
checksumint8
used_prefetchingchar(1)
runtime_filter_sizeint4
max_runtime_filter_sizeint4
runtime_filter_typeint4
is_hashed_subplanchar(1)
build_global_hash_tablechar(1)
used_mega_blockchar(1)
memory_usage_ratioint4
logtimetimestamp

pg_catalog.stl_integration_cdc_detail
old
columndata type
record_timetimestamp
integration_idchar(128)
database_namechar(128)
checkpointchar(128)
source_typechar(128)
schema_namechar(128)
table_namechar(128)
statusint4
synced_log_coordinatechar(128)
src_insertsint8
src_deletesint8
src_updatesint8
insertsint8
inserts_dtint8
parsed_rowsint8
skipped_rowsint8
is_burstedint4
new
columndata type
record_timetimestamp
integration_idchar(128)
database_namechar(128)
checkpointchar(128)
source_typechar(128)
schema_namechar(128)
table_namechar(128)
statusint4
synced_log_coordinatechar(128)
src_insertsint8
src_deletesint8
src_updatesint8
insertsint8
inserts_dtint8
parsed_rowsint8
skipped_rowsint8
is_burstedint4
bytes_ingestedint8
updated_rowsint8
validation_statusint4
xidint8

pg_catalog.stl_load_history_base
old
columndata type
user_idint4
dbchar(64)
xidint8
pidint4
query_idint8
child_query_sequenceint4
child_query_idint4
statusint4
table_namechar(128)
event_timetimestamp
sliceint4
filenamechar(256)
file_countint4
file_bytesint8
file_count_scannedint4
file_bytes_scannedint8
bytes_copiedint8
rows_copiedint8
file_formatchar(16)
error_countint4
data_sourcechar(256)
copy_job_idint8
start_offsetint8
bytes_scannedint8
lines_scannedint8
start_timetimestamp
end_timetimestamp
new
columndata type
user_idint4
dbchar(64)
xidint8
pidint4
query_idint8
child_query_sequenceint4
child_query_idint4
statusint4
table_namechar(128)
event_timetimestamp
sliceint4
filenamechar(256)
file_countint4
file_bytesint8
file_count_scannedint4
file_bytes_scannedint8
bytes_copiedint8
rows_copiedint8
file_formatchar(16)
error_countint4
data_sourcechar(256)
copy_job_idint8
start_offsetint8
bytes_scannedint8
lines_scannedint8
start_timetimestamp
end_timetimestamp
file_etagchar(256)
file_last_modifiedtimestamp

pg_catalog.stl_restarted_sessions_internal
old
columndata type
currenttimetimestamp
is_reforkablechar(10)
temp_tbl_createdchar(10)
named_prep_stmt_ctint4
unnamed_stmt_ctint4
in_xact_blkchar(10)
is_read_onlychar(10)
is_single_stmt_querychar(10)
conn_statechar(100)
pidint4
in_authenticationchar(10)
is_bootstrapchar(10)
is_restarted_sessionchar(10)
is_extended_protocolchar(10)
is_idle_connectionchar(10)
current_executing_commandchar(10)
is_ssl_compressedchar(10)
is_protocol_v3char(10)
are_commands_repeatedchar(10)
unsupported_command_sequencechar(10)
can_reissue_querychar(10)
parked_state_in_proxychar(10)
session_sizeint8
is_inc_resizechar(10)
written_state_to_diskchar(10)
auto_resumechar(10)
query_command_sequencechar(32)
new
columndata type
currenttimetimestamp
is_reforkablechar(10)
temp_tbl_createdchar(10)
named_prep_stmt_ctint4
unnamed_stmt_ctint4
in_xact_blkchar(10)
is_read_onlychar(10)
is_single_stmt_querychar(10)
conn_statechar(100)
pidint4
in_authenticationchar(10)
is_bootstrapchar(10)
is_restarted_sessionchar(10)
is_extended_protocolchar(10)
is_idle_connectionchar(10)
current_executing_commandchar(10)
is_ssl_compressedchar(10)
is_protocol_v3char(10)
are_commands_repeatedchar(10)
unsupported_command_sequencechar(10)
can_reissue_querychar(10)
parked_state_in_proxychar(10)
session_sizeint8
is_inc_resizechar(10)
written_state_to_diskchar(10)
auto_resumechar(10)
query_command_sequencechar(32)
is_fas_setchar(10)

pg_catalog.svv_diskusage
old
columndata type
db_idint4
namechar(128)
sliceint4
colint4
tblint4
blocknumint4
num_valuesint4
extended_limitsint4
minvalueint8
maxvalueint8
sb_posint4
pinnedint4
on_diskint4
backed_upint4
modifiedint4
hdr_modifiedint4
unsortedint4
tombstoneint4
preferred_disknoint4
temporaryint4
newblockint4
num_readersint4
idchar(64)
flagsint4
new
columndata type
db_idint4
namechar(128)
sliceint4
colint4
tblint4
blocknumint4
num_valuesint4
extended_limitsint4
minvalueint8
maxvalueint8
sb_posint4
pinnedint4
on_diskint4
backed_upint4
modifiedint4
hdr_modifiedint4
unsortedint4
tombstoneint4
preferred_disknoint4
temporaryint4
newblockint4
num_readersint4
idchar(64)
flagsint4
access_controlint4

pg_catalog.sys_load_detail
old
columndata type
user_idint4
query_idint8
file_namechar(256)
bytes_scannedint8
lines_scannedint8
record_timetimestamp
splits_scannedint8
start_timetimestamp
end_timetimestamp
new
columndata type
user_idint4
query_idint8
file_namechar(256)
bytes_scannedint8
lines_scannedint8
record_timetimestamp
splits_scannedint8
start_timetimestamp
end_timetimestamp
file_etagchar(256)
file_last_modifiedtimestamp

pg_catalog.sys_query_detail
old
columndata type
user_idint4
query_idint8
child_query_sequenceint4
stream_idint4
segment_idint4
step_idint4
step_namevarchar(256)
table_idint4
table_namevarchar(136)
is_rrscanvarchar(1)
start_timetimestamp
end_timetimestamp
durationint8
alertvarchar(1024)
input_bytesint8
input_rowsint8
output_bytesint8
output_rowsint8
blocks_readint8
blocks_writeint8
local_read_ioint8
remote_read_ioint8
sourcevarchar(64)
data_skewnessint4
time_skewnessint4
is_activevarchar(1)
spilled_block_local_diskint8
spilled_block_remote_diskint8
step_attributevarchar(64)
new
columndata type
user_idint4
query_idint8
child_query_sequenceint4
stream_idint4
segment_idint4
step_idint4
step_namevarchar(256)
table_idint4
table_namevarchar(136)
is_rrscanvarchar(1)
start_timetimestamp
end_timetimestamp
durationint8
alertvarchar(1024)
input_bytesint8
input_rowsint8
output_bytesint8
output_rowsint8
blocks_readint8
blocks_writeint8
local_read_ioint8
remote_read_ioint8
sourcevarchar(64)
data_skewnessint4
time_skewnessint4
is_activevarchar(1)
spilled_block_local_diskint8
spilled_block_remote_diskint8
step_attributevarchar(64)
metrics_levelvarchar(11)

pg_catalog.sys_restore_log
old
columndata type
database_namevarchar(128)
schema_namevarchar(128)
table_namevarchar(128)
table_idint4
actionvarchar(27)
total_data_processedint8
delta_data_processedint8
event_timetimestamp
table_sizeint8
messagevarchar(56)
redistribution_typevarchar(24)
new
columndata type
database_namevarchar(128)
schema_namevarchar(128)
table_namevarchar(128)
table_idint4
actionvarchar(27)
total_data_processedfloat8
delta_data_processedfloat8
event_timetimestamp
table_sizeint8
messagevarchar(56)
redistribution_typevarchar(24)