Redshift Observatory

System Table Tracker

System view pg_catalog.stl_restore_slice_mapping version 1.0.61678 / 2024-01-09

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