Redshift Observatory

System Table Tracker

System view pg_catalog.stl_vec_scan_stats version 1.0.61191 / 2023-12-18

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