Redshift Observatory

System Table Tracker

System view pg_catalog.stl_vec_scan_local_s3_stats version 1.0.109768 / 2025-03-30

schema	name	column	data type
pg_catalog	stl_vec_scan_local_s3_stats	avg_data_page_size	int8
pg_catalog	stl_vec_scan_local_s3_stats	avg_page_header_size	int8
pg_catalog	stl_vec_scan_local_s3_stats	max_data_page_size	int8
pg_catalog	stl_vec_scan_local_s3_stats	max_page_header_size	int8
pg_catalog	stl_vec_scan_local_s3_stats	num_cols	int4
pg_catalog	stl_vec_scan_local_s3_stats	num_non_nulls	int8
pg_catalog	stl_vec_scan_local_s3_stats	num_nulls	int8
pg_catalog	stl_vec_scan_local_s3_stats	num_overflows	int8
pg_catalog	stl_vec_scan_local_s3_stats	num_pages_delta	int8
pg_catalog	stl_vec_scan_local_s3_stats	num_pages_dictionary_index	int8
pg_catalog	stl_vec_scan_local_s3_stats	num_pages_dictionary_page	int8
pg_catalog	stl_vec_scan_local_s3_stats	num_pages_others	int8
pg_catalog	stl_vec_scan_local_s3_stats	num_pages_plain	int8
pg_catalog	stl_vec_scan_local_s3_stats	num_pages_rle	int8
pg_catalog	stl_vec_scan_local_s3_stats	num_rows	int8
pg_catalog	stl_vec_scan_local_s3_stats	num_values_delta	int8
pg_catalog	stl_vec_scan_local_s3_stats	num_values_dictionary_index	int8
pg_catalog	stl_vec_scan_local_s3_stats	num_values_dictionary_page	int8
pg_catalog	stl_vec_scan_local_s3_stats	num_values_others	int8
pg_catalog	stl_vec_scan_local_s3_stats	num_values_plain	int8
pg_catalog	stl_vec_scan_local_s3_stats	num_values_rle	int8
pg_catalog	stl_vec_scan_local_s3_stats	query	int4
pg_catalog	stl_vec_scan_local_s3_stats	segment	int4
pg_catalog	stl_vec_scan_local_s3_stats	slice	int4
pg_catalog	stl_vec_scan_local_s3_stats	step	int4

View Text

SELECT stll_vec_scan_local_s3_stats.query,
       stll_vec_scan_local_s3_stats.segment,
       stll_vec_scan_local_s3_stats.slice,
       stll_vec_scan_local_s3_stats.step,
       stll_vec_scan_local_s3_stats.num_rows,
       stll_vec_scan_local_s3_stats.num_nulls,
       stll_vec_scan_local_s3_stats.num_non_nulls,
       stll_vec_scan_local_s3_stats.num_overflows,
       stll_vec_scan_local_s3_stats.num_cols,
       stll_vec_scan_local_s3_stats.avg_page_header_size,
       stll_vec_scan_local_s3_stats.max_page_header_size,
       stll_vec_scan_local_s3_stats.avg_data_page_size,
       stll_vec_scan_local_s3_stats.max_data_page_size,
       stll_vec_scan_local_s3_stats.num_values_dictionary_page,
       stll_vec_scan_local_s3_stats.num_pages_dictionary_page,
       stll_vec_scan_local_s3_stats.num_values_plain,
       stll_vec_scan_local_s3_stats.num_pages_plain,
       stll_vec_scan_local_s3_stats.num_values_dictionary_index,
       stll_vec_scan_local_s3_stats.num_pages_dictionary_index,
       stll_vec_scan_local_s3_stats.num_values_rle,
       stll_vec_scan_local_s3_stats.num_pages_rle,
       stll_vec_scan_local_s3_stats.num_values_delta,
       stll_vec_scan_local_s3_stats.num_pages_delta,
       stll_vec_scan_local_s3_stats.num_values_others,
       stll_vec_scan_local_s3_stats.num_pages_others
FROM stll_vec_scan_local_s3_stats

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers