Redshift Observatory

System Table Tracker

System view pg_catalog.stl_vec_scan_stats version 1.0.50708 / 2023-05-19

schema	name	column	data type
pg_catalog	stl_vec_scan_stats	apply_predicate_time	int8
pg_catalog	stl_vec_scan_stats	apply_xid_time	int8
pg_catalog	stl_vec_scan_stats	compact_col_count	int4
pg_catalog	stl_vec_scan_stats	compact_payload_time	int8
pg_catalog	stl_vec_scan_stats	compact_predicate_time	int8
pg_catalog	stl_vec_scan_stats	consume_time	int8
pg_catalog	stl_vec_scan_stats	extract_payload_time	int8
pg_catalog	stl_vec_scan_stats	extract_predicate_time	int8
pg_catalog	stl_vec_scan_stats	is_operator_pushdown	char(1)
pg_catalog	stl_vec_scan_stats	payload_window_size	int4
pg_catalog	stl_vec_scan_stats	predicate_window_size	int4
pg_catalog	stl_vec_scan_stats	query	int4
pg_catalog	stl_vec_scan_stats	scalar_encoding_type	int4
pg_catalog	stl_vec_scan_stats	scalar_predicate_time	int8
pg_catalog	stl_vec_scan_stats	segment	int4
pg_catalog	stl_vec_scan_stats	slice	int4
pg_catalog	stl_vec_scan_stats	step	int4

View Text

SELECT stll_vec_scan_stats.query,
       stll_vec_scan_stats.slice,
       stll_vec_scan_stats.segment,
       stll_vec_scan_stats.scalar_encoding_type,
       stll_vec_scan_stats.predicate_window_size,
       stll_vec_scan_stats.payload_window_size,
       stll_vec_scan_stats.compact_col_count,
       stll_vec_scan_stats.is_operator_pushdown,
       stll_vec_scan_stats.apply_xid_time,
       stll_vec_scan_stats.apply_predicate_time,
       stll_vec_scan_stats.extract_predicate_time,
       stll_vec_scan_stats.extract_payload_time,
       stll_vec_scan_stats.compact_predicate_time,
       stll_vec_scan_stats.compact_payload_time,
       stll_vec_scan_stats.scalar_predicate_time,
       stll_vec_scan_stats.consume_time,
       stll_vec_scan_stats.step
FROM stll_vec_scan_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