Tables

pg_catalog.pg_mv_properties
old
columndata typePKUNN
new
columndata typePKUNN
mv_oidoidNN
mv_stateint2NN
mv_version_majorint2NN
mv_version_minorint2NN
is_autorefreshableboolNN
is_autorewritableboolNN
is_automvboolNN
has_mutable_functionsboolNN
has_aggregates_or_groupingboolNN
supports_cascadeboolNN

pg_catalog.pg_mv_refresh_state
old
columndata typePKUNN
new
columndata typePKUNN
mv_oidoidNN
db_namenameNN
mv_xidint8NN
mv_inflight_txnsint8[]
mv_last_cascade_xidsint8[]

pg_catalog.pg_s3_metadata
old
columndata typePKUNN
new
columndata typePKUNN
metadata_table_oidoidNN
metadata_refresh_xidint8NN
metadata_iceberg_snapshot_idint8NN
metadata_high_vacuum_xidint8NN
metadata_has_manifestboolNN
metadata_num_filesint8NN
metadata_num_rowsint8NN

pg_catalog.pg_structure_change
old
columndata typePKUNN
new
columndata typePKUNN
rel_oidoidNN
vacuum_xidint8NN
truncate_xidint8NN
small_table_conversion_xidint8NN
alter_xidint8NN

pg_catalog.stcs_burst_billing_ris_response_error
old
columndata typePKUNN
new
columndata typePKUNN
request_idchar(100)NN
error_typechar(128)NN
error_causechar(128)NN
log_timeint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_burst_soid_requests
old
columndata typePKUNN
new
columndata typePKUNN
pidint4NN
write_xidint8NN
typeint4NN
starttimeint8NN
endtimeint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_encryption_trace
old
columndata typePKUNN
new
columndata typePKUNN
pidint4NN
sliceint4NN
recordtimeint8NN
start_timeint8NN
end_timeint8NN
statusint4NN
active_key_idchar(36)NN
operation_typeint4NN
trace_idint4NN
key_creation_timeint8NN
new_key_idchar(36)NN
input_bytesint8NN
output_bytesint8NN
cur_stek_stateint4NN
new_stek_stateint4NN
sys_tablechar(128)NN
latency_p50int8NN
latency_p90int8NN
latency_p99int8NN
size_p50int8NN
size_p90int8NN
size_p99int8NN
messagechar(512)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_integration_maintenance_activities
old
columndata typePKUNN
new
columndata typePKUNN
record_timeint8NN
integration_idchar(128)NN
db_namechar(128)NN
maintenance_typechar(128)NN
start_timeint8NN
end_timeint8NN
num_tables_maintainedint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_local_s3_scan_sr_processing_stats
old
columndata typePKUNN
new
columndata typePKUNN
queryint4NN
segmentint4NN
stepint4NN
nodeint4NN
sliceint4NN
filechar(512)NN
offset_bytesint8NN
length_bytesint8NN
deserialize_timeint8NN
footer_first_prefetch_trigger_timeint8NN
footer_first_fetch_sent_timeint8NN
footer_first_fetch_ready_timeint8NN
triggered_second_footer_prefetchchar(1)NN
footer_second_prefetch_trigger_timeint8NN
footer_second_fetch_sent_timeint8NN
footer_second_fetch_ready_timeint8NN
footer_parse_starttimeint8NN
footer_parse_endtimeint8NN
blf_starttimeint8NN
blf_endtimeint8NN
assigned_timeint8NN
execution_starttimeint8NN
execution_endtimeint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_vec_scan_local_s3_stats
old
columndata typePKUNN
new
columndata typePKUNN
queryint4NN
segmentint4NN
sliceint4NN
stepint4NN
num_rowsint8NN
num_nullsint8NN
num_non_nullsint8NN
num_overflowsint8NN
num_colsint4NN
avg_page_header_sizeint8NN
max_page_header_sizeint8NN
avg_data_page_sizeint8NN
max_data_page_sizeint8NN
num_values_dictionary_pageint8NN
num_pages_dictionary_pageint8NN
num_values_plainint8NN
num_pages_plainint8NN
num_values_dictionary_indexint8NN
num_pages_dictionary_indexint8NN
num_values_rleint8NN
num_pages_rleint8NN
num_values_deltaint8NN
num_pages_deltaint8NN
num_values_othersint8NN
num_pages_othersint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stll_burst_billing_ris_response_error
old
columndata typePKUNN
new
columndata typePKUNN
request_idchar(100)NN
error_typechar(128)NN
error_causechar(128)NN
log_timetimestampNN

pg_catalog.stll_burst_soid_requests
old
columndata typePKUNN
new
columndata typePKUNN
pidint4NN
write_xidint8NN
typeint4NN
starttimetimestampNN
endtimetimestampNN

pg_catalog.stll_encryption_trace
old
columndata typePKUNN
new
columndata typePKUNN
pidint4NN
sliceint4NN
recordtimetimestampNN
start_timetimestampNN
end_timetimestampNN
statusint4NN
active_key_idchar(36)NN
operation_typeint4NN
trace_idint4NN
key_creation_timetimestampNN
new_key_idchar(36)NN
input_bytesint8NN
output_bytesint8NN
cur_stek_stateint4NN
new_stek_stateint4NN
sys_tablechar(128)NN
latency_p50int8NN
latency_p90int8NN
latency_p99int8NN
size_p50int8NN
size_p90int8NN
size_p99int8NN
messagechar(512)NN

pg_catalog.stll_integration_maintenance_activities
old
columndata typePKUNN
new
columndata typePKUNN
record_timetimestampNN
integration_idchar(128)NN
db_namechar(128)NN
maintenance_typechar(128)NN
start_timetimestampNN
end_timetimestampNN
num_tables_maintainedint4NN

pg_catalog.stll_local_s3_scan_sr_processing_stats
old
columndata typePKUNN
new
columndata typePKUNN
queryint4NN
segmentint4NN
stepint4NN
nodeint4NN
sliceint4NN
filechar(512)NN
offset_bytesint8NN
length_bytesint8NN
deserialize_timetimestampNN
footer_first_prefetch_trigger_timetimestampNN
footer_first_fetch_sent_timetimestampNN
footer_first_fetch_ready_timetimestampNN
triggered_second_footer_prefetchchar(1)NN
footer_second_prefetch_trigger_timetimestampNN
footer_second_fetch_sent_timetimestampNN
footer_second_fetch_ready_timetimestampNN
footer_parse_starttimetimestampNN
footer_parse_endtimetimestampNN
blf_starttimetimestampNN
blf_endtimetimestampNN
assigned_timetimestampNN
execution_starttimetimestampNN
execution_endtimetimestampNN

pg_catalog.stll_vec_scan_local_s3_stats
old
columndata typePKUNN
new
columndata typePKUNN
queryint4NN
segmentint4NN
sliceint4NN
stepint4NN
num_rowsint8NN
num_nullsint8NN
num_non_nullsint8NN
num_overflowsint8NN
num_colsint4NN
avg_page_header_sizeint8NN
max_page_header_sizeint8NN
avg_data_page_sizeint8NN
max_data_page_sizeint8NN
num_values_dictionary_pageint8NN
num_pages_dictionary_pageint8NN
num_values_plainint8NN
num_pages_plainint8NN
num_values_dictionary_indexint8NN
num_pages_dictionary_indexint8NN
num_values_rleint8NN
num_pages_rleint8NN
num_values_deltaint8NN
num_pages_deltaint8NN
num_values_othersint8NN
num_pages_othersint8NN

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

pg_catalog.stcs_datashare_request_consumer
old
columndata typePKUNN
useridint4NN
xidint8NN
pidint4NN
initial_query_timeint8NN
requestidchar(50)NN
sb_versionint8NN
dbtypeint4NN
dbidint4NN
api_callint4NN
starttimeint8NN
endtimeint8NN
statusint4NN
messagechar(512)NN
transaction_uidchar(50)NN
retry_timesint4NN
producer_cluster_idchar(50)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
xidint8NN
pidint4NN
initial_query_timeint8NN
requestidchar(50)NN
sb_versionint8NN
dbtypeint4NN
dbidint4NN
api_callint4NN
starttimeint8NN
endtimeint8NN
statusint4NN
messagechar(512)NN
transaction_uidchar(50)NN
retry_timesint4NN
producer_cluster_idchar(50)NN
pg_lock_modeschar(48)NN
xen_lock_typeschar(48)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_datashare_request_producer
old
columndata typePKUNN
useridint4NN
pidint4NN
requestidchar(50)NN
sb_versionint8NN
dbtypeint4NN
dbidint4NN
shareidint4NN
sharenamechar(128)NN
api_callint4NN
obj_typeint4NN
obj_oidint4NN
obj_namechar(128)NN
starttimeint8NN
endtimeint8NN
statusint4NN
messagechar(512)NN
consumeraccountidchar(50)NN
consumernamespacechar(50)NN
consumer_transaction_uidchar(50)NN
is_versioned_requestint4NN
overridden_snapshot_xminint8NN
xidint8NN
backend_start_timeint8NN
handler_start_timeint8NN
consumer_regionchar(64)NN
producer_cluster_idchar(50)NN
actionchar(128)NN
block_headerint4NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
useridint4NN
pidint4NN
requestidchar(50)NN
sb_versionint8NN
dbtypeint4NN
dbidint4NN
shareidint4NN
sharenamechar(128)NN
api_callint4NN
obj_typeint4NN
obj_oidint4NN
obj_namechar(128)NN
starttimeint8NN
endtimeint8NN
statusint4NN
messagechar(512)NN
consumeraccountidchar(50)NN
consumernamespacechar(50)NN
consumer_transaction_uidchar(50)NN
is_versioned_requestint4NN
overridden_snapshot_xminint8NN
xidint8NN
backend_start_timeint8NN
handler_start_timeint8NN
consumer_regionchar(64)NN
producer_cluster_idchar(50)NN
actionchar(128)NN
block_headerint4NN
pg_lock_modeschar(48)NN
xen_lock_typeschar(48)NN
pg_lock_acquire_starttimeint8NN
pg_lock_acquire_endtimeint8NN
xen_lock_acquire_starttimeint8NN
xen_lock_acquire_endtimeint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stcs_local_s3_scan_io_stats
old
columndata typePKUNN
queryint4NN
segmentint4NN
sliceint4NN
min_used_parallelismint8NN
max_used_parallelismint8NN
avg_used_parallelismint8NN
min_max_parallelismint8NN
max_max_parallelismint8NN
avg_max_parallelismint8NN
min_used_memoryint8NN
max_used_memoryint8NN
avg_used_memoryint8NN
min_max_memoryint8NN
max_max_memoryint8NN
avg_max_memoryint8NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN
queryint4NN
segmentint4NN
sliceint4NN
min_used_parallelismint8NN
max_used_parallelismint8NN
avg_used_parallelismint8NN
min_max_parallelismint8NN
max_max_parallelismint8NN
avg_max_parallelismint8NN
min_used_memoryint8NN
max_used_memoryint8NN
avg_used_memoryint8NN
min_max_memoryint8NN
max_max_memoryint8NN
avg_max_memoryint8NN
is_metadatachar(1)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN

pg_catalog.stll_datashare_request_consumer
old
columndata typePKUNN
useridint4NN
xidint8NN
pidint4NN
initial_query_timetimestampNN
requestidchar(50)NN
sb_versionint8NN
dbtypeint4NN
dbidint4NN
api_callint4NN
starttimetimestampNN
endtimetimestampNN
statusint4NN
messagechar(512)NN
transaction_uidchar(50)NN
retry_timesint4NN
producer_cluster_idchar(50)NN
new
columndata typePKUNN
useridint4NN
xidint8NN
pidint4NN
initial_query_timetimestampNN
requestidchar(50)NN
sb_versionint8NN
dbtypeint4NN
dbidint4NN
api_callint4NN
starttimetimestampNN
endtimetimestampNN
statusint4NN
messagechar(512)NN
transaction_uidchar(50)NN
retry_timesint4NN
producer_cluster_idchar(50)NN
pg_lock_modeschar(48)NN
xen_lock_typeschar(48)NN

pg_catalog.stll_datashare_request_producer
old
columndata typePKUNN
useridint4NN
pidint4NN
requestidchar(50)NN
sb_versionint8NN
dbtypeint4NN
dbidint4NN
shareidint4NN
sharenamechar(128)NN
api_callint4NN
obj_typeint4NN
obj_oidint4NN
obj_namechar(128)NN
starttimetimestampNN
endtimetimestampNN
statusint4NN
messagechar(512)NN
consumeraccountidchar(50)NN
consumernamespacechar(50)NN
consumer_transaction_uidchar(50)NN
is_versioned_requestint4NN
overridden_snapshot_xminint8NN
xidint8NN
backend_start_timetimestampNN
handler_start_timetimestampNN
consumer_regionchar(64)NN
producer_cluster_idchar(50)NN
actionchar(128)NN
block_headerint4NN
new
columndata typePKUNN
useridint4NN
pidint4NN
requestidchar(50)NN
sb_versionint8NN
dbtypeint4NN
dbidint4NN
shareidint4NN
sharenamechar(128)NN
api_callint4NN
obj_typeint4NN
obj_oidint4NN
obj_namechar(128)NN
starttimetimestampNN
endtimetimestampNN
statusint4NN
messagechar(512)NN
consumeraccountidchar(50)NN
consumernamespacechar(50)NN
consumer_transaction_uidchar(50)NN
is_versioned_requestint4NN
overridden_snapshot_xminint8NN
xidint8NN
backend_start_timetimestampNN
handler_start_timetimestampNN
consumer_regionchar(64)NN
producer_cluster_idchar(50)NN
actionchar(128)NN
block_headerint4NN
pg_lock_modeschar(48)NN
xen_lock_typeschar(48)NN
pg_lock_acquire_starttimetimestampNN
pg_lock_acquire_endtimetimestampNN
xen_lock_acquire_starttimetimestampNN
xen_lock_acquire_endtimetimestampNN

pg_catalog.stll_local_s3_scan_io_stats
old
columndata typePKUNN
queryint4NN
segmentint4NN
sliceint4NN
min_used_parallelismint8NN
max_used_parallelismint8NN
avg_used_parallelismint8NN
min_max_parallelismint8NN
max_max_parallelismint8NN
avg_max_parallelismint8NN
min_used_memoryint8NN
max_used_memoryint8NN
avg_used_memoryint8NN
min_max_memoryint8NN
max_max_memoryint8NN
avg_max_memoryint8NN
new
columndata typePKUNN
queryint4NN
segmentint4NN
sliceint4NN
min_used_parallelismint8NN
max_used_parallelismint8NN
avg_used_parallelismint8NN
min_max_parallelismint8NN
max_max_parallelismint8NN
avg_max_parallelismint8NN
min_used_memoryint8NN
max_used_memoryint8NN
avg_used_memoryint8NN
min_max_memoryint8NN
max_max_memoryint8NN
avg_max_memoryint8NN
is_metadatachar(1)NN

pg_catalog.stcs_hdr_integrity_error_redacted
old
columndata typePKUNN
recordtimeint8NN
node_numint4NN
sb_verint8NN
xidint8NN
sb_posint4NN
hdr_dump_redactedchar(209)NN
__pathvarchar(2050)NN
__sizeint8NN
__spectrum_oidvarchar(128)NN
__log_generated_datechar(8)NN
__cluster_typechar(4)NN
new
columndata typePKUNN

pg_catalog.stll_hdr_integrity_error_redacted
old
columndata typePKUNN
recordtimetimestampNN
node_numint4NN
sb_verint8NN
xidint8NN
sb_posint4NN
hdr_dump_redactedchar(209)NN
new
columndata typePKUNN

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

Views

pg_catalog.stl_burst_billing_ris_response_error
old
columndata type
new
columndata type
request_idchar(100)
error_typechar(128)
error_causechar(128)
log_timetimestamp

pg_catalog.stl_burst_soid_requests
old
columndata type
new
columndata type
pidint4
write_xidint8
typeint4
starttimetimestamp
endtimetimestamp

pg_catalog.stl_encryption_trace
old
columndata type
new
columndata type
pidint4
sliceint4
recordtimetimestamp
start_timetimestamp
end_timetimestamp
statusint4
active_key_idchar(36)
operation_typeint4
trace_idint4
key_creation_timetimestamp
new_key_idchar(36)
input_bytesint8
output_bytesint8
cur_stek_stateint4
new_stek_stateint4
sys_tablechar(128)
latency_p50int8
latency_p90int8
latency_p99int8
size_p50int8
size_p90int8
size_p99int8
messagechar(512)

pg_catalog.stl_integration_maintenance_activities
old
columndata type
new
columndata type
record_timetimestamp
integration_idchar(128)
db_namechar(128)
maintenance_typechar(128)
start_timetimestamp
end_timetimestamp
num_tables_maintainedint4

pg_catalog.stl_local_s3_scan_sr_processing_stats
old
columndata type
new
columndata type
queryint4
segmentint4
stepint4
nodeint4
sliceint4
filechar(512)
offset_bytesint8
length_bytesint8
deserialize_timetimestamp
footer_first_prefetch_trigger_timetimestamp
footer_first_fetch_sent_timetimestamp
footer_first_fetch_ready_timetimestamp
triggered_second_footer_prefetchchar(1)
footer_second_prefetch_trigger_timetimestamp
footer_second_fetch_sent_timetimestamp
footer_second_fetch_ready_timetimestamp
footer_parse_starttimetimestamp
footer_parse_endtimetimestamp
blf_starttimetimestamp
blf_endtimetimestamp
assigned_timetimestamp
execution_starttimetimestamp
execution_endtimetimestamp

pg_catalog.stl_vec_scan_local_s3_stats
old
columndata type
new
columndata type
queryint4
segmentint4
sliceint4
stepint4
num_rowsint8
num_nullsint8
num_non_nullsint8
num_overflowsint8
num_colsint4
avg_page_header_sizeint8
max_page_header_sizeint8
avg_data_page_sizeint8
max_data_page_sizeint8
num_values_dictionary_pageint8
num_pages_dictionary_pageint8
num_values_plainint8
num_pages_plainint8
num_values_dictionary_indexint8
num_pages_dictionary_indexint8
num_values_rleint8
num_pages_rleint8
num_values_deltaint8
num_pages_deltaint8
num_values_othersint8
num_pages_othersint8

pg_catalog.stl_datashare_request_consumer
old
columndata type
useridint4
xidint8
pidint4
initial_query_timetimestamp
requestidchar(50)
sb_versionint8
dbtypeint4
dbidint4
api_callint4
starttimetimestamp
endtimetimestamp
statusint4
messagechar(512)
transaction_uidchar(50)
retry_timesint4
producer_cluster_idchar(50)
new
columndata type
useridint4
xidint8
pidint4
initial_query_timetimestamp
requestidchar(50)
sb_versionint8
dbtypeint4
dbidint4
api_callint4
starttimetimestamp
endtimetimestamp
statusint4
messagechar(512)
transaction_uidchar(50)
retry_timesint4
producer_cluster_idchar(50)
pg_lock_modeschar(48)
xen_lock_typeschar(48)

pg_catalog.stl_datashare_request_producer
old
columndata type
useridint4
pidint4
requestidchar(50)
sb_versionint8
dbtypeint4
dbidint4
shareidint4
sharenamechar(128)
api_callint4
obj_typeint4
obj_oidint4
obj_namechar(128)
starttimetimestamp
endtimetimestamp
statusint4
messagechar(512)
consumeraccountidchar(50)
consumernamespacechar(50)
consumer_transaction_uidchar(50)
is_versioned_requestint4
overridden_snapshot_xminint8
xidint8
backend_start_timetimestamp
handler_start_timetimestamp
consumer_regionchar(64)
producer_cluster_idchar(50)
actionchar(128)
block_headerint4
new
columndata type
useridint4
pidint4
requestidchar(50)
sb_versionint8
dbtypeint4
dbidint4
shareidint4
sharenamechar(128)
api_callint4
obj_typeint4
obj_oidint4
obj_namechar(128)
starttimetimestamp
endtimetimestamp
statusint4
messagechar(512)
consumeraccountidchar(50)
consumernamespacechar(50)
consumer_transaction_uidchar(50)
is_versioned_requestint4
overridden_snapshot_xminint8
xidint8
backend_start_timetimestamp
handler_start_timetimestamp
consumer_regionchar(64)
producer_cluster_idchar(50)
actionchar(128)
block_headerint4
pg_lock_modeschar(48)
xen_lock_typeschar(48)
pg_lock_acquire_starttimetimestamp
pg_lock_acquire_endtimetimestamp
xen_lock_acquire_starttimetimestamp
xen_lock_acquire_endtimetimestamp

pg_catalog.stl_local_s3_scan_io_stats
old
columndata type
queryint4
segmentint4
sliceint4
min_used_parallelismint8
max_used_parallelismint8
avg_used_parallelismint8
min_max_parallelismint8
max_max_parallelismint8
avg_max_parallelismint8
min_used_memoryint8
max_used_memoryint8
avg_used_memoryint8
min_max_memoryint8
max_max_memoryint8
avg_max_memoryint8
new
columndata type
queryint4
segmentint4
sliceint4
min_used_parallelismint8
max_used_parallelismint8
avg_used_parallelismint8
min_max_parallelismint8
max_max_parallelismint8
avg_max_parallelismint8
min_used_memoryint8
max_used_memoryint8
avg_used_memoryint8
min_max_memoryint8
max_max_memoryint8
avg_max_memoryint8
is_metadatachar(1)

pg_catalog.stl_hdr_integrity_error_redacted
old
columndata type
recordtimetimestamp
node_numint4
sb_verint8
xidint8
sb_posint4
hdr_dump_redactedchar(209)
new
columndata type