Redshift Observatory

System Table Tracker

System view pg_catalog.stl_segment_ce_stats version 1.0.76913 / 2024-10-24

schema	name	column	data type
pg_catalog	stl_segment_ce_stats	is_ce_insert_mem_opt	char(1)
pg_catalog	stl_segment_ce_stats	lds_distribution_state	int8
pg_catalog	stl_segment_ce_stats	node	int4
pg_catalog	stl_segment_ce_stats	num_active_compute_slices	int4
pg_catalog	stl_segment_ce_stats	num_compute_slices	int4
pg_catalog	stl_segment_ce_stats	num_data_slices	int4
pg_catalog	stl_segment_ce_stats	parallelization_mode	char(32)
pg_catalog	stl_segment_ce_stats	query	int4
pg_catalog	stl_segment_ce_stats	row_fetcher_reason	int8
pg_catalog	stl_segment_ce_stats	row_fetcher_state	char(32)
pg_catalog	stl_segment_ce_stats	segment	int4
pg_catalog	stl_segment_ce_stats	target_topology_id	int8
pg_catalog	stl_segment_ce_stats	topology_id	int8
pg_catalog	stl_segment_ce_stats	topology_type	char(32)
pg_catalog	stl_segment_ce_stats	work_stealing_state	int8

View Text

SELECT stll_segment_ce_stats.query,
       stll_segment_ce_stats.node,
       stll_segment_ce_stats.segment,
       stll_segment_ce_stats.num_data_slices,
       stll_segment_ce_stats.num_compute_slices,
       stll_segment_ce_stats.num_active_compute_slices,
       stll_segment_ce_stats.parallelization_mode,
       stll_segment_ce_stats.row_fetcher_state,
       stll_segment_ce_stats.row_fetcher_reason,
       stll_segment_ce_stats.work_stealing_state,
       stll_segment_ce_stats.lds_distribution_state,
       stll_segment_ce_stats.topology_type,
       stll_segment_ce_stats.topology_id,
       stll_segment_ce_stats.target_topology_id,
       stll_segment_ce_stats.is_ce_insert_mem_opt
FROM stll_segment_ce_stats

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