Redshift Observatory

System Table Tracker

System view pg_catalog.stl_restore_slice_mapping version 1.0.59596 / 2023-11-12

schema name column data type
pg_catalog stl_restore_slice_mapping global_slice_num int4
pg_catalog stl_restore_slice_mapping mapping_policy int4
pg_catalog stl_restore_slice_mapping num_distall_data_blocks int4
pg_catalog stl_restore_slice_mapping num_metadata_blocks int4
pg_catalog stl_restore_slice_mapping num_non_distall_data_blocks int4
pg_catalog stl_restore_slice_mapping num_temp_distall_blocks int4
pg_catalog stl_restore_slice_mapping num_temp_non_distall_data_blocks int4
pg_catalog stl_restore_slice_mapping plan_id char(256)
pg_catalog stl_restore_slice_mapping resize_type int4
pg_catalog stl_restore_slice_mapping slice_remapper_state int4
pg_catalog stl_restore_slice_mapping slice_transfer_plan_state int4
pg_catalog stl_restore_slice_mapping source_local_slice_num int4
pg_catalog stl_restore_slice_mapping source_node_num int4
pg_catalog stl_restore_slice_mapping target_local_slice_num int4
pg_catalog stl_restore_slice_mapping target_node_num int4

View Text

SELECT stll_restore_slice_mapping.plan_id,
       stll_restore_slice_mapping.mapping_policy,
       stll_restore_slice_mapping.resize_type,
       stll_restore_slice_mapping.slice_transfer_plan_state,
       stll_restore_slice_mapping.slice_remapper_state,
       stll_restore_slice_mapping.global_slice_num,
       stll_restore_slice_mapping.target_node_num,
       stll_restore_slice_mapping.target_local_slice_num,
       stll_restore_slice_mapping.source_node_num,
       stll_restore_slice_mapping.source_local_slice_num,
       stll_restore_slice_mapping.num_non_distall_data_blocks,
       stll_restore_slice_mapping.num_distall_data_blocks,
       stll_restore_slice_mapping.num_temp_non_distall_data_blocks,
       stll_restore_slice_mapping.num_temp_distall_blocks,
       stll_restore_slice_mapping.num_metadata_blocks
FROM stll_restore_slice_mapping


Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers