Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_scan_range_stats	avg_blf_range_size	int8
pg_catalog	stl_scan_range_stats	avg_scan_range_size	int8
pg_catalog	stl_scan_range_stats	block_reopen_times	int8
pg_catalog	stl_scan_range_stats	endtime	timestamp
pg_catalog	stl_scan_range_stats	local_compute_slice	int4
pg_catalog	stl_scan_range_stats	local_data_slice	int4
pg_catalog	stl_scan_range_stats	max_blf_range_size	int8
pg_catalog	stl_scan_range_stats	max_rows_per_scan_range	int8
pg_catalog	stl_scan_range_stats	max_scan_range_size	int8
pg_catalog	stl_scan_range_stats	min_blf_range_size	int8
pg_catalog	stl_scan_range_stats	min_scan_range_size	int8
pg_catalog	stl_scan_range_stats	node	int4
pg_catalog	stl_scan_range_stats	num_blf_ranges	int8
pg_catalog	stl_scan_range_stats	num_blocks_to_scan	int8
pg_catalog	stl_scan_range_stats	num_scan_ranges	int8
pg_catalog	stl_scan_range_stats	optimized_scan_range_gen	char(1)
pg_catalog	stl_scan_range_stats	query	int4
pg_catalog	stl_scan_range_stats	segment	int4
pg_catalog	stl_scan_range_stats	starttime	timestamp
pg_catalog	stl_scan_range_stats	step	int4
pg_catalog	stl_scan_range_stats	total_blocks	int8

View Text

SELECT stll_scan_range_stats.query,
       stll_scan_range_stats.segment,
       stll_scan_range_stats.step,
       stll_scan_range_stats.node,
       stll_scan_range_stats.local_data_slice,
       stll_scan_range_stats.local_compute_slice,
       stll_scan_range_stats.starttime,
       stll_scan_range_stats.endtime,
       stll_scan_range_stats.num_blocks_to_scan,
       stll_scan_range_stats.total_blocks,
       stll_scan_range_stats.num_scan_ranges,
       stll_scan_range_stats.min_scan_range_size,
       stll_scan_range_stats.max_scan_range_size,
       stll_scan_range_stats.avg_scan_range_size,
       stll_scan_range_stats.num_blf_ranges,
       stll_scan_range_stats.min_blf_range_size,
       stll_scan_range_stats.max_blf_range_size,
       stll_scan_range_stats.avg_blf_range_size,
       stll_scan_range_stats.block_reopen_times,
       stll_scan_range_stats.optimized_scan_range_gen,
       stll_scan_range_stats.max_rows_per_scan_range
FROM stll_scan_range_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