Functions

Status Schema Language Volatility Return Function Arguments
new pg_catalog internal immutable int4 json_size super
new pg_catalog internal immutable int4 murmur3_32_hash bool
new pg_catalog internal immutable int4 murmur3_32_hash bool,int4
new pg_catalog internal immutable int4 murmur3_32_hash bpchar
new pg_catalog internal immutable int4 murmur3_32_hash bpchar,int4
new pg_catalog internal immutable int4 murmur3_32_hash date
new pg_catalog internal immutable int4 murmur3_32_hash date,int4
new pg_catalog internal immutable int4 murmur3_32_hash float4
new pg_catalog internal immutable int4 murmur3_32_hash float4,int4
new pg_catalog internal immutable int4 murmur3_32_hash float8
new pg_catalog internal immutable int4 murmur3_32_hash float8,int4
new pg_catalog internal immutable int4 murmur3_32_hash int2
new pg_catalog internal immutable int4 murmur3_32_hash int2,int4
new pg_catalog internal immutable int4 murmur3_32_hash int4
new pg_catalog internal immutable int4 murmur3_32_hash int4,int4
new pg_catalog internal immutable int4 murmur3_32_hash int8
new pg_catalog internal immutable int4 murmur3_32_hash int8,int4
new pg_catalog internal immutable int4 murmur3_32_hash numeric
new pg_catalog internal immutable int4 murmur3_32_hash numeric,int4
new pg_catalog internal immutable int4 murmur3_32_hash text
new pg_catalog internal immutable int4 murmur3_32_hash text,int4
new pg_catalog internal immutable int4 murmur3_32_hash time
new pg_catalog internal immutable int4 murmur3_32_hash time,int4
new pg_catalog internal immutable int4 murmur3_32_hash timestamp
new pg_catalog internal immutable int4 murmur3_32_hash timestamp,int4
new pg_catalog internal immutable int4 murmur3_32_hash timestamptz
new pg_catalog internal immutable int4 murmur3_32_hash timestamptz,int4
new pg_catalog internal immutable int4 murmur3_32_hash timetz
new pg_catalog internal immutable int4 murmur3_32_hash timetz,int4
new pg_catalog internal immutable int4 murmur3_32_hash varbyte
new pg_catalog internal immutable int4 murmur3_32_hash varbyte,int4
new pg_catalog internal immutable name mask_get_policy_for_role_on_column varchar,varchar,varchar,varchar
new pg_catalog internal immutable name mask_get_policy_for_user_on_column varchar,varchar,varchar,varchar
new pg_catalog internal immutable numeric try_numeric bpchar
new pg_catalog internal immutable numeric try_numeric float4
new pg_catalog internal immutable numeric try_numeric float8
new pg_catalog internal immutable numeric try_numeric int2
new pg_catalog internal immutable numeric try_numeric int4
new pg_catalog internal immutable numeric try_numeric int8
new pg_catalog internal immutable numeric try_numeric numeric,int4
new pg_catalog internal immutable numeric try_numeric super
new pg_catalog internal immutable numeric try_numeric text
new pg_catalog internal immutable numeric try_numeric_in cstring,oid,int4
new pg_catalog internal immutable varchar mask_policy_attached_atts_out oid,varchar
new pg_catalog internal immutable varchar mask_policy_atts_out varchar
new pg_catalog internal immutable varchar mask_policy_expr_out varchar
new pg_catalog internal volatile int4 reset_workgroup None

Tables

pg_catalog.pg_auto_copy_history
old
columndata typePKUNN
new
columndata typePKUNN
job_nametext
file_nametext
ingestedboolNN

pg_catalog.pg_auto_copy_job
old
columndata typePKUNN
new
columndata typePKUNN
deletexidint8NN
insertxidint8NN
oidoidNN
job_nametext
job_ownerint4NN
auto_copy_table_oidoidNN
s3_prefixtext
iam_roletext
copy_querytext
is_autoboolNN
on_error_suspendboolNN
last_file_ingesttimestampNN

pg_catalog.pg_external_object
old
columndata typePKUNN
new
columndata typePKUNN
objidoidNN
objsourcechar(1)NN
objkindchar(1)NN
objargstext

pg_catalog.pg_integration
old
columndata typePKUNN
new
columndata typePKUNN
deletexidint8NN
insertxidint8NN
oidoidNN
channel_arnnameNN
dbidoidNN
db_namenameNN
statenameNN
iam_rolenameNN
transport_pathtext
source_typenameNN

pg_catalog.stcs_alter_dist_catalog_change_events
old
columndata typePKUNN
new
columndata typePKUNN
xidint8NN
pidint4NN
tblint4NN
eventtimeint8NN
eventchar(128)NN
prev_distkeyint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_cdc_connection
old
columndata typePKUNN
new
columndata typePKUNN
record_timeint8NN
channel_idchar(128)NN
messagechar(256)NN
__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
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
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_integration_log
old
columndata typePKUNN
new
columndata typePKUNN
record_timeint8NN
integration_idchar(128)NN
integration_typechar(128)NN
statechar(128)NN
statuschar(128)NN
database_namechar(128)NN
checkpoint_namechar(128)NN
checkpoint_typechar(16)NN
synced_log_coordinatechar(128)NN
num_modified_tablesint4NN
lag_msint8NN
checkpoint_bytesint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_rowblock_manager_stats
old
columndata typePKUNN
new
columndata typePKUNN
logtimeint8NN
nodeint8NN
total_rowblocksint8NN
total_mega_rowblocksint8NN
max_rowblock_manager_sizeint8NN
min_rowblock_manager_sizeint8NN
max_rowblock_sizeint8NN
min_rowblock_sizeint8NN
added_rowblocksint8NN
added_mega_rowblocksint8NN
tossed_rowblocksint8NN
mega_rowblocks_writesint8NN
mega_rowblocks_readsint8NN
rowblocks_in_disk_cacheint8NN
num_megarowblocks_in_disk_cacheint8NN
mega_rowblocks_in_disk_cacheint8NN
pinned_rowblocksint8NN
percentage_shared_mem_usedfloat8NN
dirty_rowblocksint8NN
rowblocks_in_diskint8NN
rowblocks_in_s3int8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_sub_transaction_commit_info
old
columndata typePKUNN
new
columndata typePKUNN
masterxidint8NN
xidint8NN
nodeint4NN
commitlevelint4NN
refreshtypechar(10)NN
starttimeint8NN
endtimeint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_superblock_trickle_validation_summary
old
columndata typePKUNN
new
columndata typePKUNN
nodeint4NN
record_timeint8NN
snapshot_sb_versionint8NN
snapshot_sb_num_blocksint8NN
log_blocks_validatedint8NN
log_entries_validatedint8NN
tree_based_sb_modeint4NN
tree_entries_validatedint8NN
tree_trickle_validation_doneint4NN
trickle_validation_doneint4NN
num_steps_trickle_validationint4NN
log_rotation_doneint4NN
num_steps_log_rotationint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_user_query_map
old
columndata typePKUNN
new
columndata typePKUNN
user_idint4NN
user_query_idint8NN
rewritten_query_idint8NN
transaction_idint8NN
process_idint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_wlm_multi_az_routing
old
columndata typePKUNN
new
columndata typePKUNN
pidint4NN
xidint4NN
queryint4NN
service_classint4NN
recordtimeint8NN
main_total_memoryint4NN
main_used_memoryint4NN
multi_az_total_memoryint4NN
multi_az_used_memoryint4NN
routing_thresholdint4NN
routing_decisionint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stll_alter_dist_catalog_change_events
old
columndata typePKUNN
new
columndata typePKUNN
xidint8NN
pidint4NN
tblint4NN
eventtimetimestampNN
eventchar(128)NN
prev_distkeyint4NN

pg_catalog.stll_cdc_connection
old
columndata typePKUNN
new
columndata typePKUNN
record_timetimestampNN
channel_idchar(128)NN
messagechar(256)NN

pg_catalog.stll_datashare_query_info
old
columndata typePKUNN
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

pg_catalog.stll_integration_log
old
columndata typePKUNN
new
columndata typePKUNN
record_timetimestampNN
integration_idchar(128)NN
integration_typechar(128)NN
statechar(128)NN
statuschar(128)NN
database_namechar(128)NN
checkpoint_namechar(128)NN
checkpoint_typechar(16)NN
synced_log_coordinatechar(128)NN
num_modified_tablesint4NN
lag_msint8NN
checkpoint_bytesint8NN

pg_catalog.stll_rowblock_manager_stats
old
columndata typePKUNN
new
columndata typePKUNN
logtimetimestampNN
nodeint8NN
total_rowblocksint8NN
total_mega_rowblocksint8NN
max_rowblock_manager_sizeint8NN
min_rowblock_manager_sizeint8NN
max_rowblock_sizeint8NN
min_rowblock_sizeint8NN
added_rowblocksint8NN
added_mega_rowblocksint8NN
tossed_rowblocksint8NN
mega_rowblocks_writesint8NN
mega_rowblocks_readsint8NN
rowblocks_in_disk_cacheint8NN
num_megarowblocks_in_disk_cacheint8NN
mega_rowblocks_in_disk_cacheint8NN
pinned_rowblocksint8NN
percentage_shared_mem_usedfloat8NN
dirty_rowblocksint8NN
rowblocks_in_diskint8NN
rowblocks_in_s3int8NN

pg_catalog.stll_sub_transaction_commit_info
old
columndata typePKUNN
new
columndata typePKUNN
masterxidint8NN
xidint8NN
nodeint4NN
commitlevelint4NN
refreshtypechar(10)NN
starttimetimestampNN
endtimetimestampNN

pg_catalog.stll_superblock_trickle_validation_summary
old
columndata typePKUNN
new
columndata typePKUNN
nodeint4NN
record_timetimestampNN
snapshot_sb_versionint8NN
snapshot_sb_num_blocksint8NN
log_blocks_validatedint8NN
log_entries_validatedint8NN
tree_based_sb_modeint4NN
tree_entries_validatedint8NN
tree_trickle_validation_doneint4NN
trickle_validation_doneint4NN
num_steps_trickle_validationint4NN
log_rotation_doneint4NN
num_steps_log_rotationint4NN

pg_catalog.stll_user_query_map
old
columndata typePKUNN
new
columndata typePKUNN
user_idint4NN
user_query_idint8NN
rewritten_query_idint8NN
transaction_idint8NN
process_idint4NN

pg_catalog.stll_wlm_multi_az_routing
old
columndata typePKUNN
new
columndata typePKUNN
pidint4NN
xidint4NN
queryint4NN
service_classint4NN
recordtimetimestampNN
main_total_memoryint4NN
main_used_memoryint4NN
multi_az_total_memoryint4NN
multi_az_used_memoryint4NN
routing_thresholdint4NN
routing_decisionint4NN

pg_catalog.stv_cdc_connection
old
columndata typePKUNN
new
columndata typePKUNN
record_timetimestampNN
channel_idchar(128)NN
channel_statechar(128)NN
database_namechar(128)NN
sharding_policychar(128)NN
latest_scanned_checkpointchar(128)NN
synced_binlog_coordinatechar(128)NN
latest_applied_pe_checkpointchar(128)NN
lag_msint8NN

pg_catalog.stv_integration
old
columndata typePKUNN
new
columndata typePKUNN
record_timetimestampNN
integration_idchar(128)NN
integration_typechar(128)NN
statechar(128)NN
database_namechar(128)NN
synced_log_coordinatechar(128)NN
lag_msint8NN

pg_catalog.stv_rowblock_manager_state
old
columndata typePKUNN
new
columndata typePKUNN
nodeint8NN
total_rowblocksint8NN
total_mega_rowblocksint8NN
rowblocks_size_in_disk_cacheint8NN
mega_rowblocks_size_in_disk_cacheint8NN
rowblocks_size_in_diskint8NN
rowblocks_size_in_s3int8NN

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

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

pg_internal.redshift_auto_health_check_2151487
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
__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
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_arcadia_concurrency_scaling_usage
old
columndata typePKUNN
useridint4NN
recordtimeint8NN
rewritten_qidint4NN
user_query_idint8NN
child_query_seqint4NN
clusterchar(128)NN
report_arnchar(128)NN
instance_typechar(128)NN
num_nodesint4NN
starttimeint8NN
endtimeint8NN
request_idchar(36)NN
incurred_usage_msint4NN
incurred_usage_rpu_msint4NN
rpuint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
recordtimeint8NN
rewritten_qidint4NN
user_query_idint8NN
child_query_seqint4NN
clusterchar(128)NN
report_arnchar(128)NN
instance_typechar(128)NN
num_nodesint4NN
starttimeint8NN
endtimeint8NN
request_idchar(36)NN
incurred_usage_msint4NN
incurred_usage_rpu_msint4NN
rpuint4NN
is_cs_at_queryint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_auto_task_events
old
columndata typePKUNN
actor_pidint4NN
task_typechar(100)NN
task_statechar(50)NN
priorityfloat8NN
run_queriesint4NN
pidint4NN
retry_countint4NN
production_timeint8NN
max_execution_time_secint4NN
event_timeint8NN
messagechar(100)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
actor_pidint4NN
task_typechar(100)NN
task_statechar(50)NN
priorityfloat8NN
run_queriesint4NN
pidint4NN
retry_countint4NN
production_timeint8NN
max_execution_time_secint4NN
event_timeint8NN
messagechar(300)NN
task_idint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_burst_manager_refresh
old
columndata typePKUNN
eventtimeint8NN
actionchar(50)NN
typechar(20)NN
pidint8NN
refresh_versionint8NN
cluster_arnchar(100)NN
errorchar(350)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
eventtimeint8NN
actionchar(50)NN
typechar(20)NN
refresh_methodchar(20)NN
pidint8NN
refresh_versionint8NN
cluster_arnchar(100)NN
errorchar(350)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_cdc_checkpoints
old
columndata typePKUNN
recordtimeint8NN
connection_idchar(128)NN
db_namechar(128)NN
s3_pathchar(512)NN
checkpointchar(128)NN
typechar(16)NN
num_tables_modifiedint4NN
statuschar(16)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
recordtimeint8NN
connection_idchar(128)NN
db_namechar(128)NN
s3_pathchar(512)NN
checkpointchar(128)NN
typechar(16)NN
num_tables_modifiedint4NN
statuschar(16)NN
bytes_downloadedint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_command_result
old
columndata typePKUNN
commandtimeint8NN
commandchar(48)NN
argschar(512)NN
resultcodeint4NN
errormsgchar(512)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
commandtimeint8NN
commandchar(48)NN
argschar(512)NN
resultcodeint4NN
errormsgchar(512)NN
endtimeint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_comm_diag
old
columndata typePKUNN
nowint8NN
nodeint4NN
sliceint4NN
is_sourceint4NN
packet_countint4NN
duration_msint4NN
bandwidthfloat8NN
configchar(256)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
nowint8NN
nodeint4NN
sliceint4NN
queryint4NN
is_sourceint4NN
packet_countint4NN
duration_msint4NN
bandwidthfloat8NN
configchar(256)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_concurrency_scaling_usage
old
columndata typePKUNN
recordtimeint8NN
queryint4NN
clusterchar(128)NN
starttimeint8NN
endtimeint8NN
request_idchar(36)NN
incurred_usage_msint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
recordtimeint8NN
queryint4NN
clusterchar(128)NN
starttimeint8NN
endtimeint8NN
request_idchar(36)NN
incurred_usage_msint4NN
is_cs_at_queryint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_dag_cleanup
old
columndata typePKUNN
ending_xidint8NN
is_commitint4NN
timestampint8NN
eventchar(6)NN
dag_vertsint8NN
txn_set_sizeint4NN
lowest_added_xidint8NN
highest_added_xidint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
ending_xidint8NN
is_commitint4NN
timestampint8NN
eventchar(32)NN
dag_vertsint8NN
txn_set_sizeint4NN
lowest_added_xidint8NN
highest_added_xidint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_disk_cache_write
old
columndata typePKUNN
blocks_pushedint4NN
blocks_instant_pushedint4NN
avg_lru_size_before_pushint4NN
push_attemptsint4NN
pending_writes_pushint4NN
pending_reads_pushint4NN
blocks_written_backint4NN
writeback_preemptsint4NN
avg_lru_size_before_writebackint4NN
writeback_attemptsint4NN
pending_writes_writebackint4NN
pending_reads_writebackint4NN
avg_push_time_microsecint8NN
avg_writeback_time_microsecint8NN
sample_start_timeint8NN
sample_end_timeint8NN
nodeint4NN
rowsets_pushedint4NN
rowsets_instant_pushedint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
blocks_pushedint4NN
blocks_instant_pushedint4NN
avg_lru_size_before_pushint4NN
push_attemptsint4NN
pending_writes_pushint4NN
pending_reads_pushint4NN
blocks_written_backint4NN
writeback_preemptsint4NN
avg_lru_size_before_writebackint4NN
writeback_attemptsint4NN
pending_writes_writebackint4NN
pending_reads_writebackint4NN
avg_push_time_microsecint8NN
avg_writeback_time_microsecint8NN
sample_start_timeint8NN
sample_end_timeint8NN
nodeint4NN
rowsets_pushedint4NN
rowsets_instant_pushedint4NN
critical_writebackint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_internal_query_details
old
columndata typePKUNN
queryint4NN
xidint8NN
initial_query_timeint8NN
seldispatch_statusint4NN
query_cmd_typeint4NN
user_temp_tables_accessedint4NN
volt_temp_tables_accessedint4NN
spectrum_tables_accessedint4NN
user_perm_tables_accessedint4NN
system_tables_accessedint4NN
query_target_table_typeint4NN
memory_demanding_infoint8NN
nobackup_tables_accessedint4NN
zindex_tables_accessedint4NN
pg_tables_accessedint4NN
dirty_tables_readint4NN
wlm_slot_typechar(8)NN
is_short_queryint4NN
est_peak_mem_neededint8NN
wlm_query_memoryint8NN
datasharing_tables_accessedint4NN
uses_new_cost_modelchar(1)NN
new_model_reasonint4NN
num_rowsetsint4NN
xregion_datasharing_tables_accessedint4NN
result_cache_miss_reasonint4NN
cs_node_numsint4NN
is_multiint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
queryint4NN
xidint8NN
initial_query_timeint8NN
seldispatch_statusint4NN
query_cmd_typeint4NN
user_temp_tables_accessedint4NN
volt_temp_tables_accessedint4NN
spectrum_tables_accessedint4NN
user_perm_tables_accessedint4NN
system_tables_accessedint4NN
query_target_table_typeint4NN
memory_demanding_infoint8NN
nobackup_tables_accessedint4NN
zindex_tables_accessedint4NN
pg_tables_accessedint4NN
dirty_tables_readint4NN
wlm_slot_typechar(8)NN
is_short_queryint4NN
est_peak_mem_neededint8NN
wlm_query_memoryint8NN
datasharing_tables_accessedint4NN
uses_new_cost_modelchar(1)NN
new_model_reasonint4NN
num_rowsetsint4NN
xregion_datasharing_tables_accessedint4NN
result_cache_miss_reasonint4NN
cs_node_numsint4NN
is_multiint4NN
is_burst_for_at_taskint4NN
user_query_idint8NN
lf_datasharing_tables_accessedint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_lambda_client
old
columndata typePKUNN
queryint4NN
nodeint4NN
sliceint4NN
segmentint4NN
request_idchar(100)NN
function_namechar(100)NN
recordtimeint8NN
num_recordsint4NN
sizeint4NN
queue_idint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
queryint4NN
nodeint4NN
sliceint4NN
segmentint4NN
request_idchar(100)NN
function_namechar(100)NN
recordtimeint8NN
num_recordsint4NN
sizeint4NN
queue_idint4NN
batch_versionint4NN
__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
__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
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_query_memory
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
consumed_memint8NN
reported_memint8NN
wlm_working_memint8NN
cheating_working_memint8NN
__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
consumed_memint8NN
reported_memint8NN
wlm_working_memint8NN
cheating_working_memint8NN
avg_runtime_working_memint8NN
max_runtime_working_memint8NN
min_runtime_working_memint8NN
contributed_memint8NN
pool_out_of_memorychar(1)NN
reached_upper_boundchar(1)NN
__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
__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
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_services_control_metrics
old
columndata typePKUNN
nodeint4NN
pidint4NN
step_starttimeint8NN
step_endtimeint8NN
script_actionchar(128)NN
phasechar(128)NN
script_statuschar(32)NN
restart_trace_idchar(64)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
nodeint4NN
pidint4NN
step_starttimeint8NN
step_endtimeint8NN
script_actionchar(128)NN
phasechar(128)NN
script_statuschar(32)NN
restart_trace_idchar(64)NN
restart_reasonchar(64)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_superblock_trickle_validation_stats
old
columndata typePKUNN
nodeint4NN
record_timeint8NN
snapshot_sb_versionint8NN
snapshot_sb_num_blocksint8NN
log_entries_validatedint8NN
log_blocks_validatedint8NN
tree_based_sb_modeint4NN
tree_entries_validatedint8NN
trickle_validation_doneint4NN
log_rotationint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
nodeint4NN
record_timeint8NN
snapshot_sb_versionint8NN
snapshot_sb_num_blocksint8NN
log_entries_validatedint8NN
log_blocks_validatedint8NN
tree_based_sb_modeint4NN
tree_entries_validatedint8NN
trickle_validation_doneint4NN
log_rotationint4NN
was_tree_validatedint4NN
tree_trickle_validation_doneint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_unload_options
old
columndata typePKUNN
queryint8NN
row_countint8NN
formatint4NN
authenticationint4NN
compression_typeint4NN
encryption_typeint4NN
manifestint4NN
maxfilesizeint8NN
cross_regionchar(15)NN
opt_delimiterint4NN
opt_fixedwidthint4NN
opt_addquotesint4NN
opt_null_asint4NN
opt_escapeint4NN
opt_allowoverwriteint4NN
opt_parallelint4NN
is_headerint4NN
num_part_colint4NN
opt_incld_part_colint4NN
is_write_ext_tblint4NN
is_encrypted_autoint4NN
opt_cleanpathint4NN
rowgroupsizeint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
queryint8NN
row_countint8NN
formatint4NN
authenticationint4NN
compression_typeint4NN
encryption_typeint4NN
manifestint4NN
maxfilesizeint8NN
cross_regionchar(15)NN
opt_delimiterint4NN
opt_fixedwidthint4NN
opt_addquotesint4NN
opt_null_asint4NN
opt_escapeint4NN
opt_allowoverwriteint4NN
opt_parallelint4NN
is_headerint4NN
num_part_colint4NN
opt_incld_part_colint4NN
is_write_ext_tblint4NN
is_encrypted_autoint4NN
opt_cleanpathint4NN
rowgroupsizeint8NN
extensionchar(15)NN
__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
__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
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_xregion_metering
old
columndata typePKUNN
eventtimeint8NN
queryint8NN
regionchar(30)NN
internal_request_uuidchar(36)NN
metered_mbsint8NN
transferred_dataint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
eventtimeint8NN
queryint8NN
regionchar(30)NN
internal_request_uuidchar(36)NN
metered_mbsint8NN
transferred_dataint8NN
billing_cluster_immutable_idchar(64)NN
__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
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

pg_catalog.stll_arcadia_concurrency_scaling_usage
old
columndata typePKUNN
useridint4NN
recordtimetimestampNN
rewritten_qidint4NN
user_query_idint8NN
child_query_seqint4NN
clusterchar(128)NN
report_arnchar(128)NN
instance_typechar(128)NN
num_nodesint4NN
starttimetimestampNN
endtimetimestampNN
request_idchar(36)NN
incurred_usage_msint4NN
incurred_usage_rpu_msint4NN
rpuint4NN
new
columndata typePKUNN
useridint4NN
recordtimetimestampNN
rewritten_qidint4NN
user_query_idint8NN
child_query_seqint4NN
clusterchar(128)NN
report_arnchar(128)NN
instance_typechar(128)NN
num_nodesint4NN
starttimetimestampNN
endtimetimestampNN
request_idchar(36)NN
incurred_usage_msint4NN
incurred_usage_rpu_msint4NN
rpuint4NN
is_cs_at_queryint4NN

pg_catalog.stll_auto_task_events
old
columndata typePKUNN
actor_pidint4NN
task_typechar(100)NN
task_statechar(50)NN
priorityfloat8NN
run_queriesint4NN
pidint4NN
retry_countint4NN
production_timeint8NN
max_execution_time_secint4NN
event_timetimestampNN
messagechar(100)NN
new
columndata typePKUNN
actor_pidint4NN
task_typechar(100)NN
task_statechar(50)NN
priorityfloat8NN
run_queriesint4NN
pidint4NN
retry_countint4NN
production_timeint8NN
max_execution_time_secint4NN
event_timetimestampNN
messagechar(300)NN
task_idint8NN

pg_catalog.stll_burst_manager_refresh
old
columndata typePKUNN
eventtimetimestampNN
actionchar(50)NN
typechar(20)NN
pidint8NN
refresh_versionint8NN
cluster_arnchar(100)NN
errorchar(350)NN
new
columndata typePKUNN
eventtimetimestampNN
actionchar(50)NN
typechar(20)NN
refresh_methodchar(20)NN
pidint8NN
refresh_versionint8NN
cluster_arnchar(100)NN
errorchar(350)NN

pg_catalog.stll_cdc_checkpoints
old
columndata typePKUNN
recordtimetimestampNN
connection_idchar(128)NN
db_namechar(128)NN
s3_pathchar(512)NN
checkpointchar(128)NN
typechar(16)NN
num_tables_modifiedint4NN
statuschar(16)NN
new
columndata typePKUNN
recordtimetimestampNN
connection_idchar(128)NN
db_namechar(128)NN
s3_pathchar(512)NN
checkpointchar(128)NN
typechar(16)NN
num_tables_modifiedint4NN
statuschar(16)NN
bytes_downloadedint8NN

pg_catalog.stll_command_result
old
columndata typePKUNN
commandtimetimestampNN
commandchar(48)NN
argschar(512)NN
resultcodeint4NN
errormsgchar(512)NN
new
columndata typePKUNN
commandtimetimestampNN
commandchar(48)NN
argschar(512)NN
resultcodeint4NN
errormsgchar(512)NN
endtimetimestampNN

pg_catalog.stll_comm_diag
old
columndata typePKUNN
nowtimestampNN
nodeint4NN
sliceint4NN
is_sourceint4NN
packet_countint4NN
duration_msint4NN
bandwidthfloat8NN
configchar(256)NN
new
columndata typePKUNN
nowtimestampNN
nodeint4NN
sliceint4NN
queryint4NN
is_sourceint4NN
packet_countint4NN
duration_msint4NN
bandwidthfloat8NN
configchar(256)NN

pg_catalog.stll_concurrency_scaling_usage
old
columndata typePKUNN
recordtimetimestampNN
queryint4NN
clusterchar(128)NN
starttimetimestampNN
endtimetimestampNN
request_idchar(36)NN
incurred_usage_msint4NN
new
columndata typePKUNN
recordtimetimestampNN
queryint4NN
clusterchar(128)NN
starttimetimestampNN
endtimetimestampNN
request_idchar(36)NN
incurred_usage_msint4NN
is_cs_at_queryint4NN

pg_catalog.stll_dag_cleanup
old
columndata typePKUNN
ending_xidint8NN
is_commitint4NN
timestamptimestampNN
eventchar(6)NN
dag_vertsint8NN
txn_set_sizeint4NN
lowest_added_xidint8NN
highest_added_xidint8NN
new
columndata typePKUNN
ending_xidint8NN
is_commitint4NN
timestamptimestampNN
eventchar(32)NN
dag_vertsint8NN
txn_set_sizeint4NN
lowest_added_xidint8NN
highest_added_xidint8NN

pg_catalog.stll_disk_cache_write
old
columndata typePKUNN
blocks_pushedint4NN
blocks_instant_pushedint4NN
avg_lru_size_before_pushint4NN
push_attemptsint4NN
pending_writes_pushint4NN
pending_reads_pushint4NN
blocks_written_backint4NN
writeback_preemptsint4NN
avg_lru_size_before_writebackint4NN
writeback_attemptsint4NN
pending_writes_writebackint4NN
pending_reads_writebackint4NN
avg_push_time_microsecint8NN
avg_writeback_time_microsecint8NN
sample_start_timetimestampNN
sample_end_timetimestampNN
nodeint4NN
rowsets_pushedint4NN
rowsets_instant_pushedint4NN
new
columndata typePKUNN
blocks_pushedint4NN
blocks_instant_pushedint4NN
avg_lru_size_before_pushint4NN
push_attemptsint4NN
pending_writes_pushint4NN
pending_reads_pushint4NN
blocks_written_backint4NN
writeback_preemptsint4NN
avg_lru_size_before_writebackint4NN
writeback_attemptsint4NN
pending_writes_writebackint4NN
pending_reads_writebackint4NN
avg_push_time_microsecint8NN
avg_writeback_time_microsecint8NN
sample_start_timetimestampNN
sample_end_timetimestampNN
nodeint4NN
rowsets_pushedint4NN
rowsets_instant_pushedint4NN
critical_writebackint4NN

pg_catalog.stll_internal_query_details
old
columndata typePKUNN
queryint4NN
xidint8NN
initial_query_timetimestampNN
seldispatch_statusint4NN
query_cmd_typeint4NN
user_temp_tables_accessedint4NN
volt_temp_tables_accessedint4NN
spectrum_tables_accessedint4NN
user_perm_tables_accessedint4NN
system_tables_accessedint4NN
query_target_table_typeint4NN
memory_demanding_infoint8NN
nobackup_tables_accessedint4NN
zindex_tables_accessedint4NN
pg_tables_accessedint4NN
dirty_tables_readint4NN
wlm_slot_typechar(8)NN
is_short_queryint4NN
est_peak_mem_neededint8NN
wlm_query_memoryint8NN
datasharing_tables_accessedint4NN
uses_new_cost_modelchar(1)NN
new_model_reasonint4NN
num_rowsetsint4NN
xregion_datasharing_tables_accessedint4NN
result_cache_miss_reasonint4NN
cs_node_numsint4NN
is_multiint4NN
new
columndata typePKUNN
queryint4NN
xidint8NN
initial_query_timetimestampNN
seldispatch_statusint4NN
query_cmd_typeint4NN
user_temp_tables_accessedint4NN
volt_temp_tables_accessedint4NN
spectrum_tables_accessedint4NN
user_perm_tables_accessedint4NN
system_tables_accessedint4NN
query_target_table_typeint4NN
memory_demanding_infoint8NN
nobackup_tables_accessedint4NN
zindex_tables_accessedint4NN
pg_tables_accessedint4NN
dirty_tables_readint4NN
wlm_slot_typechar(8)NN
is_short_queryint4NN
est_peak_mem_neededint8NN
wlm_query_memoryint8NN
datasharing_tables_accessedint4NN
uses_new_cost_modelchar(1)NN
new_model_reasonint4NN
num_rowsetsint4NN
xregion_datasharing_tables_accessedint4NN
result_cache_miss_reasonint4NN
cs_node_numsint4NN
is_multiint4NN
is_burst_for_at_taskint4NN
user_query_idint8NN
lf_datasharing_tables_accessedint4NN

pg_catalog.stll_lambda_client
old
columndata typePKUNN
queryint4NN
nodeint4NN
sliceint4NN
segmentint4NN
request_idchar(100)NN
function_namechar(100)NN
recordtimetimestampNN
num_recordsint4NN
sizeint4NN
queue_idint4NN
new
columndata typePKUNN
queryint4NN
nodeint4NN
sliceint4NN
segmentint4NN
request_idchar(100)NN
function_namechar(100)NN
recordtimetimestampNN
num_recordsint4NN
sizeint4NN
queue_idint4NN
batch_versionint4NN

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

pg_catalog.stll_query_memory
old
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
consumed_memint8NN
reported_memint8NN
wlm_working_memint8NN
cheating_working_memint8NN
new
columndata typePKUNN
useridint4NN
queryint4NN
sliceint4NN
segmentint4NN
stepint4NN
consumed_memint8NN
reported_memint8NN
wlm_working_memint8NN
cheating_working_memint8NN
avg_runtime_working_memint8NN
max_runtime_working_memint8NN
min_runtime_working_memint8NN
contributed_memint8NN
pool_out_of_memorychar(1)NN
reached_upper_boundchar(1)NN

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

pg_catalog.stll_services_control_metrics
old
columndata typePKUNN
nodeint4NN
pidint4NN
step_starttimetimestampNN
step_endtimetimestampNN
script_actionchar(128)NN
phasechar(128)NN
script_statuschar(32)NN
restart_trace_idchar(64)NN
new
columndata typePKUNN
nodeint4NN
pidint4NN
step_starttimetimestampNN
step_endtimetimestampNN
script_actionchar(128)NN
phasechar(128)NN
script_statuschar(32)NN
restart_trace_idchar(64)NN
restart_reasonchar(64)NN

pg_catalog.stll_superblock_trickle_validation_stats
old
columndata typePKUNN
nodeint4NN
record_timetimestampNN
snapshot_sb_versionint8NN
snapshot_sb_num_blocksint8NN
log_entries_validatedint8NN
log_blocks_validatedint8NN
tree_based_sb_modeint4NN
tree_entries_validatedint8NN
trickle_validation_doneint4NN
log_rotationint4NN
new
columndata typePKUNN
nodeint4NN
record_timetimestampNN
snapshot_sb_versionint8NN
snapshot_sb_num_blocksint8NN
log_entries_validatedint8NN
log_blocks_validatedint8NN
tree_based_sb_modeint4NN
tree_entries_validatedint8NN
trickle_validation_doneint4NN
log_rotationint4NN
was_tree_validatedint4NN
tree_trickle_validation_doneint4NN

pg_catalog.stll_unload_options
old
columndata typePKUNN
queryint8NN
row_countint8NN
formatint4NN
authenticationint4NN
compression_typeint4NN
encryption_typeint4NN
manifestint4NN
maxfilesizeint8NN
cross_regionchar(15)NN
opt_delimiterint4NN
opt_fixedwidthint4NN
opt_addquotesint4NN
opt_null_asint4NN
opt_escapeint4NN
opt_allowoverwriteint4NN
opt_parallelint4NN
is_headerint4NN
num_part_colint4NN
opt_incld_part_colint4NN
is_write_ext_tblint4NN
is_encrypted_autoint4NN
opt_cleanpathint4NN
rowgroupsizeint8NN
new
columndata typePKUNN
queryint8NN
row_countint8NN
formatint4NN
authenticationint4NN
compression_typeint4NN
encryption_typeint4NN
manifestint4NN
maxfilesizeint8NN
cross_regionchar(15)NN
opt_delimiterint4NN
opt_fixedwidthint4NN
opt_addquotesint4NN
opt_null_asint4NN
opt_escapeint4NN
opt_allowoverwriteint4NN
opt_parallelint4NN
is_headerint4NN
num_part_colint4NN
opt_incld_part_colint4NN
is_write_ext_tblint4NN
is_encrypted_autoint4NN
opt_cleanpathint4NN
rowgroupsizeint8NN
extensionchar(15)NN

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

pg_catalog.stll_xregion_metering
old
columndata typePKUNN
eventtimetimestampNN
queryint8NN
regionchar(30)NN
internal_request_uuidchar(36)NN
metered_mbsint8NN
transferred_dataint8NN
new
columndata typePKUNN
eventtimetimestampNN
queryint8NN
regionchar(30)NN
internal_request_uuidchar(36)NN
metered_mbsint8NN
transferred_dataint8NN
billing_cluster_immutable_idchar(64)NN

pg_catalog.stv_burst_manager_cluster_info
old
columndata typePKUNN
cluster_arnchar(120)NN
num_sessionsint4NN
max_sessionsint4NN
backup_versionint8NN
backup_idchar(100)NN
last_heartbeat_checktimestampNN
last_usedtimestampNN
idle_counterint4NN
active_pidschar(40)NN
personalizedint4NN
gateway_errorsint4NN
credentials_errorsint4NN
refresh_backup_versionint8NN
refresh_backup_idchar(100)NN
refresh_start_timetimestampNN
new
columndata typePKUNN
cluster_arnchar(120)NN
num_sessionsint4NN
max_sessionsint4NN
backup_versionint8NN
backup_idchar(100)NN
last_heartbeat_checktimestampNN
last_usedtimestampNN
idle_counterint4NN
active_pidschar(256)NN
personalizedint4NN
gateway_errorsint4NN
credentials_errorsint4NN
refresh_backup_versionint8NN
refresh_backup_idchar(100)NN
refresh_start_timetimestampNN
has_limited_sessionsint4NN
total_memoryint8NN
used_memoryint8NN
multi_azint4NN

pg_catalog.stv_ml_model_info
old
columndata typePKUNN
schema_namechar(128)NN
user_namechar(128)NN
model_namechar(128)NN
life_cyclechar(20)NN
is_refreshableint4NN
model_statechar(128)NN
new
columndata typePKUNN
schema_namechar(128)NN
user_namechar(128)NN
model_namechar(128)NN
life_cyclechar(20)NN
is_refreshableint4NN
model_statechar(128)NN
database_namechar(128)NN

pg_catalog.stv_mv_deps
old
columndata typePKUNN
db_namechar(128)NN
schemachar(128)NN
namechar(128)NN
ref_schemachar(128)NN
ref_namechar(128)NN
new
columndata typePKUNN
db_namechar(128)NN
schemachar(128)NN
namechar(128)NN
ref_schemachar(128)NN
ref_namechar(128)NN
ref_database_namechar(128)NN

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

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

Views

pg_catalog.stl_alter_dist_catalog_change_events
old
columndata type
new
columndata type
xidint8
pidint4
tblint4
eventtimetimestamp
eventchar(128)
prev_distkeyint4

pg_catalog.stl_cdc_connection
old
columndata type
new
columndata type
record_timetimestamp
channel_idchar(128)
messagechar(256)

pg_catalog.stl_datashare_query_info
old
columndata type
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)

pg_catalog.stl_integration_log
old
columndata type
new
columndata type
record_timetimestamp
integration_idchar(128)
integration_typechar(128)
statechar(128)
statuschar(128)
database_namechar(128)
checkpoint_namechar(128)
checkpoint_typechar(16)
synced_log_coordinatechar(128)
num_modified_tablesint4
lag_msint8
checkpoint_bytesint8

pg_catalog.stl_rowblock_manager_stats
old
columndata type
new
columndata type
logtimetimestamp
nodeint8
total_rowblocksint8
total_mega_rowblocksint8
max_rowblock_manager_sizeint8
min_rowblock_manager_sizeint8
max_rowblock_sizeint8
min_rowblock_sizeint8
added_rowblocksint8
added_mega_rowblocksint8
tossed_rowblocksint8
mega_rowblocks_writesint8
mega_rowblocks_readsint8
rowblocks_in_disk_cacheint8
num_megarowblocks_in_disk_cacheint8
mega_rowblocks_in_disk_cacheint8
pinned_rowblocksint8
percentage_shared_mem_usedfloat8
dirty_rowblocksint8
rowblocks_in_diskint8
rowblocks_in_s3int8

pg_catalog.stl_sub_transaction_commit_info
old
columndata type
new
columndata type
masterxidint8
xidint8
nodeint4
commitlevelint4
refreshtypechar(10)
starttimetimestamp
endtimetimestamp

pg_catalog.stl_superblock_trickle_validation_summary
old
columndata type
new
columndata type
nodeint4
record_timetimestamp
snapshot_sb_versionint8
snapshot_sb_num_blocksint8
log_blocks_validatedint8
log_entries_validatedint8
tree_based_sb_modeint4
tree_entries_validatedint8
tree_trickle_validation_doneint4
trickle_validation_doneint4
num_steps_trickle_validationint4
log_rotation_doneint4
num_steps_log_rotationint4

pg_catalog.stl_user_query_map
old
columndata type
new
columndata type
user_idint4
user_query_idint8
rewritten_query_idint8
transaction_idint8
process_idint4

pg_catalog.stl_wlm_multi_az_routing
old
columndata type
new
columndata type
pidint4
xidint4
queryint4
service_classint4
recordtimetimestamp
main_total_memoryint4
main_used_memoryint4
multi_az_total_memoryint4
multi_az_used_memoryint4
routing_thresholdint4
routing_decisionint4

pg_catalog.svv_attached_masking_policy
old
columndata type
new
columndata type
policy_namevarchar(128)
schema_namevarchar(128)
table_namevarchar(128)
table_typevarchar(7)
grantorvarchar(128)
granteevarchar(128)
grantee_typevarchar(6)
priorityint4
input_columnsvarchar(256)
output_columnsvarchar(256)

pg_catalog.svv_integration
old
columndata type
new
columndata type
integration_idchar(128)
target_databasechar(128)
sourcechar(128)
statechar(128)
current_lagint8
last_replicated_checkpointchar(128)

pg_catalog.svv_masking_policy
old
columndata type
new
columndata type
policy_databasevarchar(128)
policy_namevarchar(128)
input_columnsvarchar(256)
policy_expressionvarchar(256)
policy_modified_byvarchar(128)
policy_modified_timetimestamp

pg_catalog.svv_ml_model_info
old
columndata type
new
columndata type
database_namechar(128)
schema_namechar(128)
user_namechar(128)
model_namechar(128)
life_cyclechar(20)
is_refreshableint4
model_statechar(128)

pg_catalog.svv_mv_dependency
old
columndata type
new
columndata type
database_namechar(128)
schema_namechar(128)
namechar(128)
dependent_database_namechar(128)
dependent_schema_namechar(128)
dependent_namechar(128)

pg_catalog.sys_integration_activity
old
columndata type
new
columndata type
integration_idchar(128)
target_databasechar(128)
sourcechar(128)
checkpoint_namechar(128)
checkpoint_typechar(16)
checkpoint_bytesint8
last_commit_timestampint4
modified_tablesint4
integration_start_timeint4
integration_end_timetimestamp

pg_catalog.sys_load_detail
old
columndata type
new
columndata type
user_idint4
query_idint8
file_namechar(256)
bytes_scannedint4
lines_scannedint4
record_timetimestamp

pg_catalog.sys_spectrum_scan_error
old
columndata type
new
columndata type
useridint4
queryint8
locationchar(256)
rowidchar(2100)
colnamechar(127)
original_valuechar(1024)
modified_valuechar(1024)
triggertext
actiontext
action_valuechar(127)
error_codeint4

pg_catalog.stl_aggr
old
columndata type
useridint4
queryint4
sliceint4
segmentint4
stepint4
starttimetimestamp
endtimetimestamp
tasknumint4
rowsint8
bytesint8
slotsint4
occupiedint4
maxlengthint4
tblint4
is_diskbasedchar(1)
workmemint8
typechar(6)
resizesint4
flushableint4
varchar_agg_optchar(1)
varagg_opt_bitmapint8
used_agg_prefetchingchar(1)
used_mega_blockchar(1)
new
columndata type
useridint4
queryint4
sliceint4
segmentint4
stepint4
starttimetimestamp
endtimetimestamp
tasknumint4
rowsint8
bytesint8
slotsint4
occupiedint4
maxlengthint4
tblint4
is_diskbasedchar(1)
workmemint8
typechar(6)
resizesint4
flushableint4
varchar_agg_optchar(1)
varagg_opt_bitmapint8
used_agg_prefetchingchar(1)
used_mega_blockchar(1)
num_flushesint4

pg_catalog.stl_arcadia_concurrency_scaling_usage
old
columndata type
useridint4
recordtimetimestamp
rewritten_qidint4
user_query_idint8
child_query_seqint4
clusterchar(128)
report_arnchar(128)
instance_typechar(128)
num_nodesint4
starttimetimestamp
endtimetimestamp
request_idchar(36)
incurred_usage_msint4
incurred_usage_rpu_msint4
rpuint4
new
columndata type
useridint4
recordtimetimestamp
rewritten_qidint4
user_query_idint8
child_query_seqint4
clusterchar(128)
report_arnchar(128)
instance_typechar(128)
num_nodesint4
starttimetimestamp
endtimetimestamp
request_idchar(36)
incurred_usage_msint4
incurred_usage_rpu_msint4
rpuint4
is_cs_at_queryint4

pg_catalog.stl_auto_task_events
old
columndata type
actor_pidint4
task_typechar(100)
task_statechar(50)
priorityfloat8
run_queriesint4
pidint4
retry_countint4
production_timeint8
max_execution_time_secint4
event_timetimestamp
messagechar(100)
new
columndata type
actor_pidint4
task_typechar(100)
task_statechar(50)
priorityfloat8
run_queriesint4
pidint4
retry_countint4
production_timeint8
max_execution_time_secint4
event_timetimestamp
messagechar(300)
task_idint8

pg_catalog.stl_burst_manager_refresh
old
columndata type
eventtimetimestamp
actionchar(50)
typechar(20)
pidint8
refresh_versionint8
cluster_arnchar(100)
errorchar(350)
new
columndata type
eventtimetimestamp
actionchar(50)
typechar(20)
refresh_methodchar(20)
pidint8
refresh_versionint8
cluster_arnchar(100)
errorchar(350)

pg_catalog.stl_cdc_checkpoints
old
columndata type
recordtimetimestamp
connection_idchar(128)
db_namechar(128)
s3_pathchar(512)
checkpointchar(128)
typechar(16)
num_tables_modifiedint4
statuschar(16)
new
columndata type
recordtimetimestamp
connection_idchar(128)
db_namechar(128)
s3_pathchar(512)
checkpointchar(128)
typechar(16)
num_tables_modifiedint4
statuschar(16)
bytes_downloadedint8

pg_catalog.stl_command_result
old
columndata type
commandtimetimestamp
commandchar(48)
argschar(512)
resultcodeint4
errormsgchar(512)
new
columndata type
commandtimetimestamp
commandchar(48)
argschar(512)
resultcodeint4
errormsgchar(512)
endtimetimestamp

pg_catalog.stl_comm_diag
old
columndata type
nowtimestamp
nodeint4
sliceint4
is_sourceint4
packet_countint4
duration_msint4
bandwidthfloat8
configchar(256)
new
columndata type
nowtimestamp
nodeint4
sliceint4
queryint4
is_sourceint4
packet_countint4
duration_msint4
bandwidthfloat8
configchar(256)

pg_catalog.stl_concurrency_scaling_usage
old
columndata type
recordtimetimestamp
queryint4
clusterchar(128)
starttimetimestamp
endtimetimestamp
request_idchar(36)
incurred_usage_msint4
new
columndata type
recordtimetimestamp
queryint4
clusterchar(128)
starttimetimestamp
endtimetimestamp
request_idchar(36)
incurred_usage_msint4
is_cs_at_queryint4

pg_catalog.stl_dag_cleanup
old
columndata type
ending_xidint8
is_commitint4
timestamptimestamp
eventchar(6)
dag_vertsint8
txn_set_sizeint4
lowest_added_xidint8
highest_added_xidint8
new
columndata type
ending_xidint8
is_commitint4
timestamptimestamp
eventchar(32)
dag_vertsint8
txn_set_sizeint4
lowest_added_xidint8
highest_added_xidint8

pg_catalog.stl_disk_cache_write
old
columndata type
blocks_pushedint4
blocks_instant_pushedint4
avg_lru_size_before_pushint4
push_attemptsint4
pending_writes_pushint4
pending_reads_pushint4
blocks_written_backint4
writeback_preemptsint4
avg_lru_size_before_writebackint4
writeback_attemptsint4
pending_writes_writebackint4
pending_reads_writebackint4
avg_push_time_microsecint8
avg_writeback_time_microsecint8
sample_start_timetimestamp
sample_end_timetimestamp
nodeint4
rowsets_pushedint4
rowsets_instant_pushedint4
new
columndata type
blocks_pushedint4
blocks_instant_pushedint4
avg_lru_size_before_pushint4
push_attemptsint4
pending_writes_pushint4
pending_reads_pushint4
blocks_written_backint4
writeback_preemptsint4
avg_lru_size_before_writebackint4
writeback_attemptsint4
pending_writes_writebackint4
pending_reads_writebackint4
avg_push_time_microsecint8
avg_writeback_time_microsecint8
sample_start_timetimestamp
sample_end_timetimestamp
nodeint4
rowsets_pushedint4
rowsets_instant_pushedint4
critical_writebackint4

pg_catalog.stl_internal_query_details
old
columndata type
queryint4
xidint8
initial_query_timetimestamp
seldispatch_statusint4
query_cmd_typeint4
user_temp_tables_accessedint4
volt_temp_tables_accessedint4
spectrum_tables_accessedint4
user_perm_tables_accessedint4
system_tables_accessedint4
query_target_table_typeint4
memory_demanding_infoint8
nobackup_tables_accessedint4
zindex_tables_accessedint4
pg_tables_accessedint4
dirty_tables_readint4
wlm_slot_typechar(8)
is_short_queryint4
est_peak_mem_neededint8
wlm_query_memoryint8
datasharing_tables_accessedint4
uses_new_cost_modelchar(1)
new_model_reasonint4
num_rowsetsint4
xregion_datasharing_tables_accessedint4
result_cache_miss_reasonint4
cs_node_numsint4
is_multiint4
new
columndata type
queryint4
xidint8
initial_query_timetimestamp
seldispatch_statusint4
query_cmd_typeint4
user_temp_tables_accessedint4
volt_temp_tables_accessedint4
spectrum_tables_accessedint4
user_perm_tables_accessedint4
system_tables_accessedint4
query_target_table_typeint4
memory_demanding_infoint8
nobackup_tables_accessedint4
zindex_tables_accessedint4
pg_tables_accessedint4
dirty_tables_readint4
wlm_slot_typechar(8)
is_short_queryint4
est_peak_mem_neededint8
wlm_query_memoryint8
datasharing_tables_accessedint4
uses_new_cost_modelchar(1)
new_model_reasonint4
num_rowsetsint4
xregion_datasharing_tables_accessedint4
result_cache_miss_reasonint4
cs_node_numsint4
is_multiint4
is_burst_for_at_taskint4
user_query_idint8
lf_datasharing_tables_accessedint4

pg_catalog.stl_lambda_client
old
columndata type
queryint4
nodeint4
sliceint4
segmentint4
request_idchar(100)
function_namechar(100)
recordtimetimestamp
num_recordsint4
sizeint4
queue_idint4
new
columndata type
queryint4
nodeint4
sliceint4
segmentint4
request_idchar(100)
function_namechar(100)
recordtimetimestamp
num_recordsint4
sizeint4
queue_idint4
batch_versionint4

pg_catalog.stl_query_detail
old
columndata type
user_idint4
query_idint8
child_query_idint4
child_query_sequenceint4
stream_idint4
segment_idint4
step_idint4
sliceint4
starttimetimestamp
endtimetimestamp
step_nameint4
table_idint4
table_namechar(136)
input_rowsint8
input_bytesint8
output_rowsint8
output_bytesint8
is_rrscanchar(1)
blocks_readint8
blocks_writeint8
local_read_ioint8
remote_read_ioint8
alertchar(1024)
internal_querychar(1)
new
columndata type
user_idint4
query_idint8
child_query_idint4
child_query_sequenceint4
stream_idint4
segment_idint4
step_idint4
sliceint4
starttimetimestamp
endtimetimestamp
step_nameint4
table_idint4
table_namechar(136)
input_rowsint8
input_bytesint8
output_rowsint8
output_bytesint8
is_rrscanchar(1)
blocks_readint8
blocks_writeint8
local_read_ioint8
remote_read_ioint8
alertchar(1024)
internal_querychar(1)
sourcechar(64)
cpu_timeint8

pg_catalog.stl_query_memory
old
columndata type
useridint4
queryint4
sliceint4
segmentint4
stepint4
consumed_memint8
reported_memint8
wlm_working_memint8
cheating_working_memint8
new
columndata type
useridint4
queryint4
sliceint4
segmentint4
stepint4
consumed_memint8
reported_memint8
wlm_working_memint8
cheating_working_memint8
avg_runtime_working_memint8
max_runtime_working_memint8
min_runtime_working_memint8
contributed_memint8
pool_out_of_memorychar(1)
reached_upper_boundchar(1)

pg_catalog.stl_rtree
old
columndata type
useridint4
queryint4
sliceint4
segmentint4
stepint4
starttimetimestamp
endtimetimestamp
tasknumint4
rowsint8
bytesint8
tblint4
is_diskbasedchar(1)
workmemint8
mem_allowance_for_indexint8
cheating_memint8
index_predicted_sizeint8
index_sizeint8
new
columndata type
useridint4
queryint4
sliceint4
segmentint4
stepint4
starttimetimestamp
endtimetimestamp
tasknumint4
rowsint8
bytesint8
tblint4
is_diskbasedchar(1)
workmemint8
mem_allowance_for_indexint8
cheating_memint8
index_predicted_sizeint8
index_sizeint8
insert_durationint8
build_durationint8

pg_catalog.stl_services_control_metrics
old
columndata type
nodeint4
pidint4
step_starttimetimestamp
step_endtimetimestamp
script_actionchar(128)
phasechar(128)
script_statuschar(32)
restart_trace_idchar(64)
new
columndata type
nodeint4
pidint4
step_starttimetimestamp
step_endtimetimestamp
script_actionchar(128)
phasechar(128)
script_statuschar(32)
restart_trace_idchar(64)
restart_reasonchar(64)

pg_catalog.stl_superblock_trickle_validation_stats
old
columndata type
nodeint4
record_timetimestamp
snapshot_sb_versionint8
snapshot_sb_num_blocksint8
log_entries_validatedint8
log_blocks_validatedint8
tree_based_sb_modeint4
tree_entries_validatedint8
trickle_validation_doneint4
log_rotationint4
new
columndata type
nodeint4
record_timetimestamp
snapshot_sb_versionint8
snapshot_sb_num_blocksint8
log_entries_validatedint8
log_blocks_validatedint8
tree_based_sb_modeint4
tree_entries_validatedint8
trickle_validation_doneint4
log_rotationint4
was_tree_validatedint4
tree_trickle_validation_doneint4

pg_catalog.stl_unload_options
old
columndata type
queryint8
row_countint8
formatint4
authenticationint4
compression_typeint4
encryption_typeint4
manifestint4
maxfilesizeint8
cross_regionchar(15)
opt_delimiterint4
opt_fixedwidthint4
opt_addquotesint4
opt_null_asint4
opt_escapeint4
opt_allowoverwriteint4
opt_parallelint4
is_headerint4
num_part_colint4
opt_incld_part_colint4
is_write_ext_tblint4
is_encrypted_autoint4
opt_cleanpathint4
rowgroupsizeint8
new
columndata type
queryint8
row_countint8
formatint4
authenticationint4
compression_typeint4
encryption_typeint4
manifestint4
maxfilesizeint8
cross_regionchar(15)
opt_delimiterint4
opt_fixedwidthint4
opt_addquotesint4
opt_null_asint4
opt_escapeint4
opt_allowoverwriteint4
opt_parallelint4
is_headerint4
num_part_colint4
opt_incld_part_colint4
is_write_ext_tblint4
is_encrypted_autoint4
opt_cleanpathint4
rowgroupsizeint8
extensionchar(15)

pg_catalog.stl_user_query_history
old
columndata type
user_idint4
query_idint8
labelchar(320)
xidint8
pidint4
database_namechar(128)
query_typechar(32)
statuschar(10)
result_cache_source_queryint8
start_timetimestamp
end_timetimestamp
queue_timeint8
execution_timeint8
error_messagechar(512)
returned_rowsint8
returned_bytesint8
redshift_versionchar(32)
usage_limitchar(150)
internal_querychar(1)
query_textchar(4000)
new
columndata type
user_idint4
query_idint8
labelchar(320)
xidint8
pidint4
database_namechar(128)
query_typechar(32)
statuschar(10)
result_cache_source_queryint8
start_timetimestamp
end_timetimestamp
queue_timeint8
execution_timeint8
error_messagechar(512)
returned_rowsint8
returned_bytesint8
redshift_versionchar(32)
usage_limitchar(150)
internal_querychar(1)
query_textchar(4000)
compute_typechar(32)
compile_timeint8
planning_timeint8
pure_planning_timeint8

pg_catalog.stl_xregion_metering
old
columndata type
eventtimetimestamp
queryint8
regionchar(30)
internal_request_uuidchar(36)
metered_mbsint8
transferred_dataint8
new
columndata type
eventtimetimestamp
queryint8
regionchar(30)
internal_request_uuidchar(36)
metered_mbsint8
transferred_dataint8
billing_cluster_immutable_idchar(64)

pg_catalog.svcs_rtree
old
columndata type
useridint4
queryint4
sliceint4
segmentint4
stepint4
starttimetimestamp
endtimetimestamp
tasknumint4
rowsint8
bytesint8
tblint4
workmemint8
is_diskbasedchar(1)
mem_allowance_for_indexint8
cheating_memint8
index_predicted_sizeint8
index_sizeint8
new
columndata type
useridint4
queryint4
sliceint4
segmentint4
stepint4
starttimetimestamp
endtimetimestamp
tasknumint4
rowsint8
bytesint8
tblint4
workmemint8
is_diskbasedchar(1)
mem_allowance_for_indexint8
cheating_memint8
index_predicted_sizeint8
index_sizeint8
insert_durationint8
build_durationint8

pg_catalog.svv_external_databases
old
columndata type
eskindint4
esoptionstext
databasenametext
locationtext
parameterstext
new
columndata type
eskindint4
esoptionsvarchar(128)
databasenamevarchar(128)
locationvarchar(128)
parametersvarchar(128)

pg_catalog.svv_rls_relation
old
columndata type
datnamevarchar(128)
relschemavarchar(128)
relnamevarchar(128)
relkindvarchar(17)
is_rls_onchar(1)
new
columndata type
datnamevarchar(128)
relschemavarchar(128)
relnamevarchar(128)
relkindvarchar(17)
is_rls_onchar(1)
is_rls_datashare_onchar(1)

pg_catalog.sys_external_query_detail
old
columndata type
user_idint4
query_idint8
transaction_idint8
child_query_sequenceint4
segment_idint4
source_typechar(32)
start_timetimestamp
end_timetimestamp
durationint8
total_partitionsint4
qualified_partitionsint4
scanned_filesint8
returned_rowsint8
returned_bytesint8
file_formattext
file_locationtext
external_query_texttext
warning_messagechar(4000)
new
columndata type
user_idint4
query_idint8
transaction_idint8
child_query_sequenceint4
segment_idint4
source_typechar(32)
start_timetimestamp
end_timetimestamp
durationint8
total_partitionsint4
qualified_partitionsint4
scanned_filesint8
returned_rowsint8
returned_bytesint8
file_formattext
file_locationtext
external_query_texttext
warning_messagechar(4000)
table_nametext

pg_catalog.sys_query_detail
old
columndata type
user_idint4
query_idint8
child_query_sequenceint4
stream_idint4
segment_idint4
step_idint4
step_nametext
table_idint4
table_namechar(136)
is_rrscanchar(1)
start_timetimestamp
end_timetimestamp
durationint8
alerttext
input_bytesint8
input_rowsint8
output_bytesint8
output_rowsint8
blocks_readint8
blocks_writeint8
local_read_ioint8
remote_read_ioint8
new
columndata type
user_idint4
query_idint8
child_query_sequenceint4
stream_idint4
segment_idint4
step_idint4
step_nametext
table_idint4
table_nametext
is_rrscantext
start_timetimestamp
end_timetimestamp
durationint8
alerttext
input_bytesint8
input_rowsint8
output_bytesint8
output_rowsint8
blocks_readint8
blocks_writeint8
local_read_ioint8
remote_read_ioint8
sourcetext
data_skewnessint4
time_skewnessint4

pg_catalog.sys_query_history
old
columndata type
user_idint4
query_idint8
query_labelvarchar(320)
transaction_idint8
session_idint4
database_namevarchar(128)
query_typevarchar(32)
statuschar(10)
result_cache_hitbool
start_timetimestamp
end_timetimestamp
elapsed_timeint8
queue_timeint8
execution_timeint8
error_messagevarchar(512)
returned_rowsint8
returned_bytesint8
query_textvarchar(4000)
redshift_versionchar(32)
usage_limitvarchar(150)
new
columndata type
user_idint4
query_idint8
query_labelvarchar(320)
transaction_idint8
session_idint4
database_namevarchar(128)
query_typevarchar(32)
statuschar(10)
result_cache_hitbool
start_timetimestamp
end_timetimestamp
elapsed_timeint8
queue_timeint8
execution_timeint8
error_messagevarchar(512)
returned_rowsint8
returned_bytesint8
query_textvarchar(4000)
redshift_versionchar(32)
usage_limitvarchar(150)
compute_typevarchar(32)
compile_timeint8
planning_timeint8