vortex icon indicating copy to clipboard operation
vortex copied to clipboard

feature: Bloom Filters

Open a10y opened this issue 3 months ago • 18 comments

This PR (WIP) augments our existing DictLayout to write bloom filters that can then be used for pruning.

This is backwards-compatible, the metadata includes an additional optional protobuf field and if that field is present, it will point at a segment ID that contains the bloom filters.

We implement the Split block Bloom Filter from https://arxiv.org/pdf/2101.01719, with xxHasher. This is effectively what Parquet does (and StarRocks, and a few others).

The bloom filter implementation borrows heavily from the parquet-rs one, as well as the pseudocode in the Parquet documentation https://parquet.apache.org/docs/file-format/bloomfilter/

Settings

Writing of bloom filters are currently disabled by default, but are enabled for SQL benchmarks TPC-H and FineWeb.

Tokenization and Pruning

We tokenize the dictionary values upon insertion so we can support pruning of partial-string matches.

Now pruning occurs for the following expression types

  • $ = Literal
  • $ LIKE 'EXACT'
  • $ LIKE 'prefix%'
  • $ LIKE '%suffix'
  • $ LIKE '%substr%'

Not-equals cannot be pruned using an approximate membership data structure like a bloom filter.

Extension

Extending to other data types like datetime, ints, decimals, extension types like geocolumns etc.

a10y avatar Sep 05 '25 17:09 a10y

Codecov Report

:x: Patch coverage is 80.74074% with 130 lines in your changes missing coverage. Please review. :white_check_mark: Project coverage is 87.59%. Comparing base (4181e12) to head (f363906). :warning: Report is 167 commits behind head on develop.

Files with missing lines Patch % Lines
vortex-layout/src/layouts/dict/writer.rs 66.37% 39 Missing :warning:
vortex-layout/src/layouts/dict/bloom/mod.rs 80.95% 24 Missing :warning:
vortex-layout/src/layouts/dict/bloom/sbbf/prune.rs 62.50% 18 Missing :warning:
vortex-expr/src/exprs/like.rs 40.00% 12 Missing :warning:
vortex-layout/src/layouts/dict/bloom/sbbf/mod.rs 88.09% 10 Missing :warning:
vortex-layout/src/layouts/compressed/writer.rs 55.00% 9 Missing :warning:
vortex-layout/src/layouts/compressed/mod.rs 53.33% 7 Missing :warning:
vortex-file/src/file.rs 0.00% 6 Missing :warning:
vortex-layout/src/layouts/compressed/compact.rs 57.14% 3 Missing :warning:
vortex-layout/src/layouts/dict/bloom/serde.rs 98.03% 1 Missing :warning:
... and 1 more

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

:rocket: New features to boost your workflow:
  • :snowflake: Test Analytics: Detect flaky tests, report on failures, and find test suite problems.
  • :package: JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.

codecov[bot] avatar Sep 05 '25 18:09 codecov[bot]

Any reason the bloom filters aren't just a binary column in the zone map? In theory, we could write the zone map using a StructLayout such that only the required columns are read.

Although I guess we'd probably want a layout that allows us to group some set of columns together to avoid too many flat layouts.

gatesn avatar Sep 05 '25 20:09 gatesn

Benchmarks: TPC-H SF=1 on NVME

Summary

  • Overall: 1.001x ➖
  • Vortex: 0.999x ➖
  • duckdb:vortex: 1.004x ➖
  • datafusion:vortex: 0.994x ➖
  • Best: tpch_q20/DuckDB:vortex-compact (0.943x)
  • Worst: tpch_q16/DuckDB:vortex-compact (1.093x)
  • Significant (>10%): 0↑ 0↓
Detailed Results Table
name PR 44465167 base 4181e121 ratio (PR/base) unit remark
tpch_q01/DataFusion:arrow 51894928 6.12112e+07 0.847801 ns
tpch_q02/DataFusion:arrow 17011987 1.78874e+07 0.951057 ns
tpch_q03/DataFusion:arrow 21962957 2.27685e+07 0.964622 ns
tpch_q04/DataFusion:arrow 12064212 1.1944e+07 1.01007 ns
tpch_q05/DataFusion:arrow 32736160 3.27126e+07 1.00072 ns
tpch_q06/DataFusion:arrow 8956290 7.00852e+06 1.27791 ns
tpch_q07/DataFusion:arrow 53824007 5.21737e+07 1.03163 ns
tpch_q08/DataFusion:arrow 18652861 1.87822e+07 0.993113 ns
tpch_q09/DataFusion:arrow 32578496 3.19919e+07 1.01834 ns
tpch_q10/DataFusion:arrow 29439604 2.78324e+07 1.05775 ns
tpch_q11/DataFusion:arrow 39640160 3.95758e+07 1.00163 ns
tpch_q12/DataFusion:arrow 18439118 1.9109e+07 0.964943 ns
tpch_q13/DataFusion:arrow 17636622 1.79212e+07 0.984123 ns
tpch_q14/DataFusion:arrow 7045587 7.25817e+06 0.970712 ns
tpch_q15/DataFusion:arrow 12971172 1.31862e+07 0.98369 ns
tpch_q16/DataFusion:arrow 15288400 1.49861e+07 1.02017 ns
tpch_q17/DataFusion:arrow 48461562 5.03751e+07 0.962014 ns
tpch_q18/DataFusion:arrow 99799558 1.01687e+08 0.981436 ns
tpch_q19/DataFusion:arrow 15475993 1.72222e+07 0.89861 ns
tpch_q20/DataFusion:arrow 20233513 2.02275e+07 1.0003 ns
tpch_q21/DataFusion:arrow 75638816 7.53497e+07 1.00384 ns
tpch_q22/DataFusion:arrow 9676568 1.0356e+07 0.934397 ns
tpch_q01/DataFusion:parquet 151587218 1.52957e+08 0.991044 ns
tpch_q02/DataFusion:parquet 90519624 8.73706e+07 1.03604 ns
tpch_q03/DataFusion:parquet 78210318 8.11228e+07 0.964097 ns
tpch_q04/DataFusion:parquet 56428497 5.28442e+07 1.06783 ns
tpch_q05/DataFusion:parquet 101918072 9.71408e+07 1.04918 ns
tpch_q06/DataFusion:parquet 35541879 3.44219e+07 1.03254 ns
tpch_q07/DataFusion:parquet 124659670 1.22619e+08 1.01664 ns
tpch_q08/DataFusion:parquet 116704668 1.23216e+08 0.947153 ns
tpch_q09/DataFusion:parquet 143245999 1.51291e+08 0.946824 ns
tpch_q10/DataFusion:parquet 119190506 1.23596e+08 0.964352 ns
tpch_q11/DataFusion:parquet 70784636 6.75884e+07 1.04729 ns
tpch_q12/DataFusion:parquet 82006747 8.08652e+07 1.01412 ns
tpch_q13/DataFusion:parquet 197472523 2.04206e+08 0.967028 ns
tpch_q14/DataFusion:parquet 43314154 4.26224e+07 1.01623 ns
tpch_q15/DataFusion:parquet 62454814 5.46962e+07 1.14185 ns
tpch_q16/DataFusion:parquet 45687839 4.62288e+07 0.988299 ns
tpch_q17/DataFusion:parquet 127398083 1.27967e+08 0.995551 ns
tpch_q18/DataFusion:parquet 172019480 1.82699e+08 0.941548 ns
tpch_q19/DataFusion:parquet 95482544 8.39894e+07 1.13684 ns
tpch_q20/DataFusion:parquet 65382861 6.78196e+07 0.96407 ns
tpch_q21/DataFusion:parquet 139810513 1.36505e+08 1.02422 ns
tpch_q22/DataFusion:parquet 65647429 6.69489e+07 0.98056 ns
tpch_q01/DataFusion:vortex-file-compressed 57621350 5.58581e+07 1.03157 ns
tpch_q02/DataFusion:vortex-file-compressed 33908079 3.31607e+07 1.02254 ns
tpch_q03/DataFusion:vortex-file-compressed 22168168 2.15225e+07 1.03 ns
tpch_q04/DataFusion:vortex-file-compressed 16062097 1.59864e+07 1.00474 ns
tpch_q05/DataFusion:vortex-file-compressed 58877987 5.9023e+07 0.997543 ns
tpch_q06/DataFusion:vortex-file-compressed 7535564 7.23464e+06 1.04159 ns
tpch_q07/DataFusion:vortex-file-compressed 68600486 6.9632e+07 0.985187 ns
tpch_q08/DataFusion:vortex-file-compressed 41239245 4.12826e+07 0.99895 ns
tpch_q09/DataFusion:vortex-file-compressed 56538136 5.61188e+07 1.00747 ns
tpch_q10/DataFusion:vortex-file-compressed 38014925 3.92952e+07 0.967419 ns
tpch_q11/DataFusion:vortex-file-compressed 21359476 2.15116e+07 0.992928 ns
tpch_q12/DataFusion:vortex-file-compressed 17285160 1.79396e+07 0.963517 ns
tpch_q13/DataFusion:vortex-file-compressed 24217910 2.5518e+07 0.949054 ns
tpch_q14/DataFusion:vortex-file-compressed 11014796 1.10554e+07 0.996328 ns
tpch_q15/DataFusion:vortex-file-compressed 18058712 1.80073e+07 1.00285 ns
tpch_q16/DataFusion:vortex-file-compressed 20804013 2.19216e+07 0.949019 ns
tpch_q17/DataFusion:vortex-file-compressed 57931629 5.88939e+07 0.983661 ns
tpch_q18/DataFusion:vortex-file-compressed 91299447 9.07068e+07 1.00653 ns
tpch_q19/DataFusion:vortex-file-compressed 17069976 1.79575e+07 0.950575 ns
tpch_q20/DataFusion:vortex-file-compressed 24257834 2.38676e+07 1.01635 ns
tpch_q21/DataFusion:vortex-file-compressed 72059137 7.19819e+07 1.00107 ns
tpch_q22/DataFusion:vortex-file-compressed 13316139 1.36024e+07 0.978953 ns
tpch_q01/DataFusion:vortex-compact 57131000 6.03387e+07 0.946839 ns
tpch_q02/DataFusion:vortex-compact 40165914 3.83023e+07 1.04866 ns
tpch_q03/DataFusion:vortex-compact 25282296 2.53811e+07 0.996105 ns
tpch_q04/DataFusion:vortex-compact 18798684 1.9139e+07 0.982217 ns
tpch_q05/DataFusion:vortex-compact 63108099 6.45139e+07 0.978209 ns
tpch_q06/DataFusion:vortex-compact 11794810 1.19721e+07 0.985195 ns
tpch_q07/DataFusion:vortex-compact 76260695 7.70775e+07 0.989403 ns
tpch_q08/DataFusion:vortex-compact 44141630 4.41242e+07 1.00039 ns
tpch_q09/DataFusion:vortex-compact 60716543 6.15267e+07 0.986832 ns
tpch_q10/DataFusion:vortex-compact 41581361 4.15808e+07 1.00001 ns
tpch_q11/DataFusion:vortex-compact 23166062 2.28552e+07 1.0136 ns
tpch_q12/DataFusion:vortex-compact 25845552 2.60363e+07 0.992673 ns
tpch_q13/DataFusion:vortex-compact 30518637 3.05777e+07 0.998067 ns
tpch_q14/DataFusion:vortex-compact 15804680 1.60387e+07 0.985411 ns
tpch_q15/DataFusion:vortex-compact 28210885 2.80221e+07 1.00674 ns
tpch_q16/DataFusion:vortex-compact 27355784 2.60637e+07 1.04957 ns
tpch_q17/DataFusion:vortex-compact 62284362 6.30543e+07 0.98779 ns
tpch_q18/DataFusion:vortex-compact 91739114 9.14243e+07 1.00344 ns
tpch_q19/DataFusion:vortex-compact 33590465 3.47669e+07 0.966162 ns
tpch_q20/DataFusion:vortex-compact 28742191 3.01084e+07 0.954623 ns
tpch_q21/DataFusion:vortex-compact 76975323 7.71998e+07 0.997092 ns
tpch_q22/DataFusion:vortex-compact 15387911 1.52432e+07 1.0095 ns
tpch_q01/DuckDB:parquet 80125993 7.97108e+07 1.00521 ns
tpch_q02/DuckDB:parquet 47501918 4.59227e+07 1.03439 ns
tpch_q03/DuckDB:parquet 77647976 7.74522e+07 1.00253 ns
tpch_q04/DuckDB:parquet 59293241 5.95972e+07 0.9949 ns
tpch_q05/DuckDB:parquet 73734590 7.4728e+07 0.986706 ns
tpch_q06/DuckDB:parquet 22804660 2.29316e+07 0.994465 ns
tpch_q07/DuckDB:parquet 80309973 8.03216e+07 0.999856 ns
tpch_q08/DuckDB:parquet 97255104 9.54457e+07 1.01896 ns
tpch_q09/DuckDB:parquet 146402533 1.45011e+08 1.00959 ns
tpch_q10/DuckDB:parquet 138547919 1.38337e+08 1.00153 ns
tpch_q11/DuckDB:parquet 26073792 2.58187e+07 1.00988 ns
tpch_q12/DuckDB:parquet 60559079 5.93389e+07 1.02056 ns
tpch_q13/DuckDB:parquet 272430238 2.77779e+08 0.980743 ns
tpch_q14/DuckDB:parquet 52475607 5.26025e+07 0.997588 ns
tpch_q15/DuckDB:parquet 29223901 2.90693e+07 1.00532 ns
tpch_q16/DuckDB:parquet 59384337 5.98131e+07 0.992832 ns
tpch_q17/DuckDB:parquet 59581259 5.79581e+07 1.02801 ns
tpch_q18/DuckDB:parquet 123003875 1.23394e+08 0.996841 ns
tpch_q19/DuckDB:parquet 72632927 7.08529e+07 1.02512 ns
tpch_q20/DuckDB:parquet 64174542 6.26688e+07 1.02403 ns
tpch_q21/DuckDB:parquet 183146877 1.68605e+08 1.08625 ns
tpch_q22/DuckDB:parquet 55908744 5.59585e+07 0.999112 ns
tpch_q01/DuckDB:vortex-file-compressed 27886404 2.86901e+07 0.971988 ns
tpch_q02/DuckDB:vortex-file-compressed 27624412 2.82991e+07 0.97616 ns
tpch_q03/DuckDB:vortex-file-compressed 30203986 3.01619e+07 1.00139 ns
tpch_q04/DuckDB:vortex-file-compressed 29903819 2.98437e+07 1.00201 ns
tpch_q05/DuckDB:vortex-file-compressed 32392551 3.28038e+07 0.987463 ns
tpch_q06/DuckDB:vortex-file-compressed 8911109 9.20256e+06 0.968329 ns
tpch_q07/DuckDB:vortex-file-compressed 36283795 3.66645e+07 0.989615 ns
tpch_q08/DuckDB:vortex-file-compressed 42619261 4.31481e+07 0.987744 ns
tpch_q09/DuckDB:vortex-file-compressed 68334684 7.12423e+07 0.959186 ns
tpch_q10/DuckDB:vortex-file-compressed 33428573 3.14303e+07 1.06358 ns
tpch_q11/DuckDB:vortex-file-compressed 16550938 1.555e+07 1.06437 ns
tpch_q12/DuckDB:vortex-file-compressed 22512801 2.29961e+07 0.978986 ns
tpch_q13/DuckDB:vortex-file-compressed 37591480 3.80244e+07 0.988615 ns
tpch_q14/DuckDB:vortex-file-compressed 22306846 2.25597e+07 0.988791 ns
tpch_q15/DuckDB:vortex-file-compressed 12179329 1.23564e+07 0.985668 ns
tpch_q16/DuckDB:vortex-file-compressed 32130775 3.21269e+07 1.00012 ns
tpch_q17/DuckDB:vortex-file-compressed 23852245 2.42013e+07 0.985579 ns
tpch_q18/DuckDB:vortex-file-compressed 47830932 4.87514e+07 0.981119 ns
tpch_q19/DuckDB:vortex-file-compressed 31093429 3.08438e+07 1.00809 ns
tpch_q20/DuckDB:vortex-file-compressed 26357649 2.61955e+07 1.00619 ns
tpch_q21/DuckDB:vortex-file-compressed 100483272 1.01724e+08 0.987807 ns
tpch_q22/DuckDB:vortex-file-compressed 20163815 1.91152e+07 1.05486 ns
tpch_q01/DuckDB:vortex-compact 32859170 3.24707e+07 1.01196 ns
tpch_q02/DuckDB:vortex-compact 38118179 3.73054e+07 1.02179 ns
tpch_q03/DuckDB:vortex-compact 38200585 3.70188e+07 1.03192 ns
tpch_q04/DuckDB:vortex-compact 38178172 3.93533e+07 0.970139 ns
tpch_q05/DuckDB:vortex-compact 40148202 3.99191e+07 1.00574 ns
tpch_q06/DuckDB:vortex-compact 14937776 1.50977e+07 0.989406 ns
tpch_q07/DuckDB:vortex-compact 46494333 4.58663e+07 1.01369 ns
tpch_q08/DuckDB:vortex-compact 52761521 5.38154e+07 0.980417 ns
tpch_q09/DuckDB:vortex-compact 79467646 7.7421e+07 1.02644 ns
tpch_q10/DuckDB:vortex-compact 41948679 4.25455e+07 0.985972 ns
tpch_q11/DuckDB:vortex-compact 21439838 2.03378e+07 1.05418 ns
tpch_q12/DuckDB:vortex-compact 49615589 4.82051e+07 1.02926 ns
tpch_q13/DuckDB:vortex-compact 43452260 4.35881e+07 0.996884 ns
tpch_q14/DuckDB:vortex-compact 29377726 2.8295e+07 1.03827 ns
tpch_q15/DuckDB:vortex-compact 18010356 1.75742e+07 1.02482 ns
tpch_q16/DuckDB:vortex-compact 39530658 3.61702e+07 1.09291 ns
tpch_q17/DuckDB:vortex-compact 29318194 2.87569e+07 1.01952 ns
tpch_q18/DuckDB:vortex-compact 53702631 5.38258e+07 0.997712 ns
tpch_q19/DuckDB:vortex-compact 41180230 4.02901e+07 1.02209 ns
tpch_q20/DuckDB:vortex-compact 35582381 3.77424e+07 0.94277 ns
tpch_q21/DuckDB:vortex-compact 112991344 1.16039e+08 0.97374 ns
tpch_q22/DuckDB:vortex-compact 21620178 2.11784e+07 1.02086 ns
tpch_q01/DuckDB:duckdb 17369786 1.73466e+07 1.00134 ns
tpch_q02/DuckDB:duckdb 14081312 1.39375e+07 1.01032 ns
tpch_q03/DuckDB:duckdb 20893361 2.11348e+07 0.988575 ns
tpch_q04/DuckDB:duckdb 19120688 1.91305e+07 0.999486 ns
tpch_q05/DuckDB:duckdb 22216066 2.23641e+07 0.993383 ns
tpch_q06/DuckDB:duckdb 7314496 7.24512e+06 1.00958 ns
tpch_q07/DuckDB:duckdb 26249026 2.67307e+07 0.98198 ns
tpch_q08/DuckDB:duckdb 26399238 2.62856e+07 1.00432 ns
tpch_q09/DuckDB:duckdb 57319832 5.85058e+07 0.979728 ns
tpch_q10/DuckDB:duckdb 57494597 5.74885e+07 1.00011 ns
tpch_q11/DuckDB:duckdb 7119789 6.97674e+06 1.0205 ns
tpch_q12/DuckDB:duckdb 17037309 1.72063e+07 0.990178 ns
tpch_q13/DuckDB:duckdb 40015388 3.96999e+07 1.00795 ns
tpch_q14/DuckDB:duckdb 22419701 2.28428e+07 0.981479 ns
tpch_q15/DuckDB:duckdb 12316126 1.213e+07 1.01535 ns
tpch_q16/DuckDB:duckdb 24997308 2.43647e+07 1.02597 ns
tpch_q17/DuckDB:duckdb 17839239 1.78879e+07 0.99728 ns
tpch_q18/DuckDB:duckdb 39621104 3.89214e+07 1.01798 ns
tpch_q19/DuckDB:duckdb 32132835 3.17959e+07 1.0106 ns
tpch_q20/DuckDB:duckdb 22788781 2.27178e+07 1.00312 ns
tpch_q21/DuckDB:duckdb 61006005 6.08258e+07 1.00296 ns
tpch_q22/DuckDB:duckdb 27014903 2.65272e+07 1.01838 ns

github-actions[bot] avatar Sep 08 '25 20:09 github-actions[bot]

Benchmarks: TPC-H SF=1 on S3

Summary

  • Overall: 1.042x ➖
  • Vortex: 1.062x ➖
  • duckdb:vortex: 1.038x ➖
  • datafusion:vortex: 1.086x ➖
  • Best: tpch_q01/DataFusion:vortex-file-compressed (0.580x)
  • Worst: tpch_q08/DataFusion:vortex-compact (1.655x)
  • Significant (>30%): 1↑ 4↓
Detailed Results Table
name PR 44465167 base 4181e121 ratio (PR/base) unit remark
tpch_q01/DataFusion:parquet 242314587 2.44242e+08 0.99211 ns
tpch_q02/DataFusion:parquet 362278362 3.47043e+08 1.0439 ns
tpch_q03/DataFusion:parquet 300705979 2.88608e+08 1.04192 ns
tpch_q04/DataFusion:parquet 134692728 1.37907e+08 0.976696 ns
tpch_q05/DataFusion:parquet 364093945 3.68275e+08 0.988647 ns
tpch_q06/DataFusion:parquet 127314777 1.27652e+08 0.997356 ns
tpch_q07/DataFusion:parquet 385667760 3.89086e+08 0.991214 ns
tpch_q08/DataFusion:parquet 453912177 4.60617e+08 0.985444 ns
tpch_q09/DataFusion:parquet 417181408 4.23133e+08 0.985934 ns
tpch_q10/DataFusion:parquet 438293759 4.38764e+08 0.998929 ns
tpch_q11/DataFusion:parquet 298646748 2.77747e+08 1.07525 ns
tpch_q12/DataFusion:parquet 211720543 2.07969e+08 1.01804 ns
tpch_q13/DataFusion:parquet 424672830 4.26295e+08 0.996195 ns
tpch_q14/DataFusion:parquet 155073985 1.48392e+08 1.04503 ns
tpch_q15/DataFusion:parquet 275401936 2.72127e+08 1.01203 ns
tpch_q16/DataFusion:parquet 183572821 1.87643e+08 0.978309 ns
tpch_q17/DataFusion:parquet 338200541 3.32945e+08 1.01579 ns
tpch_q18/DataFusion:parquet 416351661 4.13016e+08 1.00808 ns
tpch_q19/DataFusion:parquet 301153584 2.86229e+08 1.05214 ns
tpch_q20/DataFusion:parquet 267585136 2.53237e+08 1.05666 ns
tpch_q21/DataFusion:parquet 409288492 4.0152e+08 1.01935 ns
tpch_q22/DataFusion:parquet 164599215 1.73133e+08 0.950712 ns
tpch_q01/DataFusion:vortex-file-compressed 177972425 3.06596e+08 0.580478 ns 🚀
tpch_q02/DataFusion:vortex-file-compressed 209064687 2.02305e+08 1.03342 ns
tpch_q03/DataFusion:vortex-file-compressed 332611690 2.84248e+08 1.17014 ns
tpch_q04/DataFusion:vortex-file-compressed 143744730 1.42533e+08 1.0085 ns
tpch_q05/DataFusion:vortex-file-compressed 198084464 1.99022e+08 0.99529 ns
tpch_q06/DataFusion:vortex-file-compressed 175069801 1.55084e+08 1.12887 ns
tpch_q07/DataFusion:vortex-file-compressed 189665607 1.95067e+08 0.972309 ns
tpch_q08/DataFusion:vortex-file-compressed 461452717 4.3152e+08 1.06937 ns
tpch_q09/DataFusion:vortex-file-compressed 406581456 4.08213e+08 0.996004 ns
tpch_q10/DataFusion:vortex-file-compressed 256538192 2.33706e+08 1.0977 ns
tpch_q11/DataFusion:vortex-file-compressed 105818824 1.05512e+08 1.0029 ns
tpch_q12/DataFusion:vortex-file-compressed 267832292 2.22489e+08 1.2038 ns
tpch_q13/DataFusion:vortex-file-compressed 235564020 2.10243e+08 1.12044 ns
tpch_q14/DataFusion:vortex-file-compressed 115570453 1.19194e+08 0.969597 ns
tpch_q15/DataFusion:vortex-file-compressed 184136275 1.8732e+08 0.983003 ns
tpch_q16/DataFusion:vortex-file-compressed 229724645 1.90827e+08 1.20384 ns
tpch_q17/DataFusion:vortex-file-compressed 333016318 2.8884e+08 1.15294 ns
tpch_q18/DataFusion:vortex-file-compressed 218162215 2.1503e+08 1.01457 ns
tpch_q19/DataFusion:vortex-file-compressed 336136078 2.74138e+08 1.22616 ns
tpch_q20/DataFusion:vortex-file-compressed 188615327 1.86064e+08 1.01371 ns
tpch_q21/DataFusion:vortex-file-compressed 347421405 3.1098e+08 1.11718 ns
tpch_q22/DataFusion:vortex-file-compressed 149114693 1.49654e+08 0.996393 ns
tpch_q01/DataFusion:vortex-compact 189964392 1.58432e+08 1.19903 ns
tpch_q02/DataFusion:vortex-compact 213904395 1.82657e+08 1.17107 ns
tpch_q03/DataFusion:vortex-compact 318138912 2.9039e+08 1.09556 ns
tpch_q04/DataFusion:vortex-compact 160149489 1.48944e+08 1.07523 ns
tpch_q05/DataFusion:vortex-compact 187747152 1.98894e+08 0.943955 ns
tpch_q06/DataFusion:vortex-compact 182723019 1.78911e+08 1.02131 ns
tpch_q07/DataFusion:vortex-compact 209091537 1.77861e+08 1.17559 ns
tpch_q08/DataFusion:vortex-compact 457206143 2.76225e+08 1.6552 ns 🚨
tpch_q09/DataFusion:vortex-compact 385563274 2.46409e+08 1.56473 ns 🚨
tpch_q10/DataFusion:vortex-compact 308326913 2.71164e+08 1.13705 ns
tpch_q11/DataFusion:vortex-compact 90175379 9.19238e+07 0.98098 ns
tpch_q12/DataFusion:vortex-compact 307176308 2.84423e+08 1.08 ns
tpch_q13/DataFusion:vortex-compact 175264245 1.19625e+08 1.46511 ns 🚨
tpch_q14/DataFusion:vortex-compact 129742596 1.23288e+08 1.05236 ns
tpch_q15/DataFusion:vortex-compact 182169460 2.02605e+08 0.899134 ns
tpch_q16/DataFusion:vortex-compact 247860617 1.94989e+08 1.27115 ns
tpch_q17/DataFusion:vortex-compact 302762085 2.83927e+08 1.06634 ns
tpch_q18/DataFusion:vortex-compact 200705310 2.04043e+08 0.983641 ns
tpch_q19/DataFusion:vortex-compact 399204347 3.05305e+08 1.30756 ns 🚨
tpch_q20/DataFusion:vortex-compact 189483325 1.75739e+08 1.07821 ns
tpch_q21/DataFusion:vortex-compact 384729915 3.4319e+08 1.12104 ns
tpch_q22/DataFusion:vortex-compact 148317303 1.50587e+08 0.984925 ns
tpch_q01/DuckDB:parquet 450956242 4.48641e+08 1.00516 ns
tpch_q02/DuckDB:parquet 1011201447 9.66799e+08 1.04593 ns
tpch_q03/DuckDB:parquet 828546240 7.61909e+08 1.08746 ns
tpch_q04/DuckDB:parquet 509105993 5.1612e+08 0.986409 ns
tpch_q05/DuckDB:parquet 1097782963 1.14479e+09 0.958942 ns
tpch_q06/DuckDB:parquet 313324420 3.16604e+08 0.989641 ns
tpch_q07/DuckDB:parquet 906763430 9.73798e+08 0.931162 ns
tpch_q08/DuckDB:parquet 1165695328 1.17107e+09 0.995414 ns
tpch_q09/DuckDB:parquet 1117777698 1.07188e+09 1.04282 ns
tpch_q10/DuckDB:parquet 1084209627 1.06071e+09 1.02215 ns
tpch_q11/DuckDB:parquet 661610048 6.41694e+08 1.03104 ns
tpch_q12/DuckDB:parquet 436845758 4.55263e+08 0.959547 ns
tpch_q13/DuckDB:parquet 795161379 7.49609e+08 1.06077 ns
tpch_q14/DuckDB:parquet 493775093 4.82073e+08 1.02427 ns
tpch_q15/DuckDB:parquet 493402232 5.48039e+08 0.900306 ns
tpch_q16/DuckDB:parquet 422282010 3.78328e+08 1.11618 ns
tpch_q17/DuckDB:parquet 554878572 6.15735e+08 0.901164 ns
tpch_q18/DuckDB:parquet 660221600 6.51477e+08 1.01342 ns
tpch_q19/DuckDB:parquet 603803020 6.29258e+08 0.959548 ns
tpch_q20/DuckDB:parquet 800660843 7.80428e+08 1.02593 ns
tpch_q21/DuckDB:parquet 885127704 8.79709e+08 1.00616 ns
tpch_q22/DuckDB:parquet 359843504 4.14749e+08 0.867618 ns
tpch_q01/DuckDB:vortex-file-compressed 237883368 2.05427e+08 1.158 ns
tpch_q02/DuckDB:vortex-file-compressed 789830203 7.79661e+08 1.01304 ns
tpch_q03/DuckDB:vortex-file-compressed 567040954 5.64044e+08 1.00531 ns
tpch_q04/DuckDB:vortex-file-compressed 331521230 3.06466e+08 1.08176 ns
tpch_q05/DuckDB:vortex-file-compressed 587176620 6.06782e+08 0.96769 ns
tpch_q06/DuckDB:vortex-file-compressed 301810697 2.90739e+08 1.03808 ns
tpch_q07/DuckDB:vortex-file-compressed 608857946 5.66316e+08 1.07512 ns
tpch_q08/DuckDB:vortex-file-compressed 835896168 7.92085e+08 1.05531 ns
tpch_q09/DuckDB:vortex-file-compressed 676539192 6.27596e+08 1.07798 ns
tpch_q10/DuckDB:vortex-file-compressed 597852252 6.3438e+08 0.94242 ns
tpch_q11/DuckDB:vortex-file-compressed 451762350 4.63977e+08 0.973673 ns
tpch_q12/DuckDB:vortex-file-compressed 425504314 3.86044e+08 1.10222 ns
tpch_q13/DuckDB:vortex-file-compressed 266917472 2.51189e+08 1.06262 ns
tpch_q14/DuckDB:vortex-file-compressed 305655668 2.78305e+08 1.09828 ns
tpch_q15/DuckDB:vortex-file-compressed 242260725 2.45805e+08 0.985581 ns
tpch_q16/DuckDB:vortex-file-compressed 368737800 3.48349e+08 1.05853 ns
tpch_q17/DuckDB:vortex-file-compressed 542651974 5.03983e+08 1.07673 ns
tpch_q18/DuckDB:vortex-file-compressed 503452068 4.7001e+08 1.07115 ns
tpch_q19/DuckDB:vortex-file-compressed 432194199 3.94607e+08 1.09525 ns
tpch_q20/DuckDB:vortex-file-compressed 563297930 5.10479e+08 1.10347 ns
tpch_q21/DuckDB:vortex-file-compressed 750018859 7.14546e+08 1.04964 ns
tpch_q22/DuckDB:vortex-file-compressed 273992450 2.78218e+08 0.984813 ns
tpch_q01/DuckDB:vortex-compact 225342939 2.16136e+08 1.0426 ns
tpch_q02/DuckDB:vortex-compact 779883531 7.67774e+08 1.01577 ns
tpch_q03/DuckDB:vortex-compact 583621946 5.37031e+08 1.08676 ns
tpch_q04/DuckDB:vortex-compact 294709101 3.19243e+08 0.923149 ns
tpch_q05/DuckDB:vortex-compact 581815426 5.68514e+08 1.0234 ns
tpch_q06/DuckDB:vortex-compact 267155395 2.84381e+08 0.939429 ns
tpch_q07/DuckDB:vortex-compact 570225398 5.62984e+08 1.01286 ns
tpch_q08/DuckDB:vortex-compact 841821665 8.02194e+08 1.0494 ns
tpch_q09/DuckDB:vortex-compact 602357747 6.21957e+08 0.968487 ns
tpch_q10/DuckDB:vortex-compact 596586605 5.59391e+08 1.06649 ns
tpch_q11/DuckDB:vortex-compact 438333989 4.40836e+08 0.994325 ns
tpch_q12/DuckDB:vortex-compact 412180312 3.9067e+08 1.05506 ns
tpch_q13/DuckDB:vortex-compact 256328084 2.48342e+08 1.03216 ns
tpch_q14/DuckDB:vortex-compact 292780804 2.81964e+08 1.03836 ns
tpch_q15/DuckDB:vortex-compact 234541202 2.36873e+08 0.990158 ns
tpch_q16/DuckDB:vortex-compact 376779368 3.30083e+08 1.14147 ns
tpch_q17/DuckDB:vortex-compact 532740625 4.66296e+08 1.14249 ns
tpch_q18/DuckDB:vortex-compact 446797406 4.50177e+08 0.992492 ns
tpch_q19/DuckDB:vortex-compact 435922217 3.91178e+08 1.11438 ns
tpch_q20/DuckDB:vortex-compact 539258785 5.46452e+08 0.986837 ns
tpch_q21/DuckDB:vortex-compact 738199037 7.02268e+08 1.05116 ns
tpch_q22/DuckDB:vortex-compact 269509613 2.73628e+08 0.98495 ns

github-actions[bot] avatar Sep 08 '25 20:09 github-actions[bot]

Benchmarks: TPC-H SF=10 on NVME

Summary

  • Overall: 0.995x ➖
  • Vortex: 0.995x ➖
  • duckdb:vortex: 0.997x ➖
  • datafusion:vortex: 0.992x ➖
  • Best: tpch_q09/DataFusion:vortex-file-compressed (0.918x)
  • Worst: tpch_q01/DataFusion:vortex-file-compressed (1.071x)
  • Significant (>10%): 0↑ 0↓
Detailed Results Table
name PR 44465167 base 4181e121 ratio (PR/base) unit remark
tpch_q01/DataFusion:arrow 477440325 4.82694e+08 0.989116 ns
tpch_q02/DataFusion:arrow 93012954 9.11279e+07 1.02069 ns
tpch_q03/DataFusion:arrow 177103429 1.82303e+08 0.971478 ns
tpch_q04/DataFusion:arrow 87746959 8.89286e+07 0.986712 ns
tpch_q05/DataFusion:arrow 338303494 3.45751e+08 0.978459 ns
tpch_q06/DataFusion:arrow 58668470 6.0104e+07 0.976116 ns
tpch_q07/DataFusion:arrow 636863211 6.46122e+08 0.98567 ns
tpch_q08/DataFusion:arrow 274226494 2.83035e+08 0.96888 ns
tpch_q09/DataFusion:arrow 559937182 5.69925e+08 0.982476 ns
tpch_q10/DataFusion:arrow 230686268 2.33143e+08 0.989464 ns
tpch_q11/DataFusion:arrow 388513435 3.88853e+08 0.999126 ns
tpch_q12/DataFusion:arrow 176766417 1.75921e+08 1.0048 ns
tpch_q13/DataFusion:arrow 188025112 1.88441e+08 0.997794 ns
tpch_q14/DataFusion:arrow 52330771 5.1197e+07 1.02214 ns
tpch_q15/DataFusion:arrow 98394371 9.85802e+07 0.998114 ns
tpch_q16/DataFusion:arrow 72844910 7.39859e+07 0.984579 ns
tpch_q17/DataFusion:arrow 578121845 5.81788e+08 0.993698 ns
tpch_q18/DataFusion:arrow 1324153019 1.34808e+09 0.982251 ns
tpch_q19/DataFusion:arrow 106645657 1.07925e+08 0.988147 ns
tpch_q20/DataFusion:arrow 165465733 1.64334e+08 1.00689 ns
tpch_q21/DataFusion:arrow 896557426 8.68353e+08 1.03248 ns
tpch_q22/DataFusion:arrow 52293736 4.94022e+07 1.05853 ns
tpch_q01/DataFusion:parquet 661401300 6.78074e+08 0.975412 ns
tpch_q01/DataFusion:parquet 661401300 6.66163e+08 0.992852 ns
tpch_q02/DataFusion:parquet 201337863 1.99349e+08 1.00998 ns
tpch_q02/DataFusion:parquet 201337863 2.05857e+08 0.978049 ns
tpch_q03/DataFusion:parquet 283472870 2.81548e+08 1.00684 ns
tpch_q03/DataFusion:parquet 283472870 2.96328e+08 0.956617 ns
tpch_q04/DataFusion:parquet 199215431 1.93455e+08 1.02978 ns
tpch_q04/DataFusion:parquet 199215431 2.02653e+08 0.983036 ns
tpch_q05/DataFusion:parquet 456039545 4.5058e+08 1.01212 ns
tpch_q05/DataFusion:parquet 456039545 4.62861e+08 0.985262 ns
tpch_q06/DataFusion:parquet 114279748 1.12291e+08 1.01771 ns
tpch_q06/DataFusion:parquet 114279748 1.13559e+08 1.00635 ns
tpch_q07/DataFusion:parquet 665463503 6.61732e+08 1.00564 ns
tpch_q07/DataFusion:parquet 665463503 6.66554e+08 0.998365 ns
tpch_q08/DataFusion:parquet 506961346 5.13604e+08 0.987066 ns
tpch_q08/DataFusion:parquet 506961346 5.12619e+08 0.988964 ns
tpch_q09/DataFusion:parquet 801454057 8.07213e+08 0.992866 ns
tpch_q09/DataFusion:parquet 801454057 8.07511e+08 0.992499 ns
tpch_q10/DataFusion:parquet 501182743 4.93569e+08 1.01543 ns
tpch_q10/DataFusion:parquet 501182743 5.08727e+08 0.98517 ns
tpch_q11/DataFusion:parquet 128414302 1.27299e+08 1.00876 ns
tpch_q11/DataFusion:parquet 128414302 1.29998e+08 0.987815 ns
tpch_q12/DataFusion:parquet 199011202 1.97211e+08 1.00913 ns
tpch_q12/DataFusion:parquet 199011202 1.92774e+08 1.03236 ns
tpch_q13/DataFusion:parquet 409484663 3.93846e+08 1.03971 ns
tpch_q13/DataFusion:parquet 409484663 4.06585e+08 1.00713 ns
tpch_q14/DataFusion:parquet 143869209 1.46222e+08 0.983907 ns
tpch_q14/DataFusion:parquet 143869209 1.49907e+08 0.959725 ns
tpch_q15/DataFusion:parquet 236044975 2.49206e+08 0.947189 ns
tpch_q15/DataFusion:parquet 236044975 2.49649e+08 0.945508 ns
tpch_q16/DataFusion:parquet 143471671 1.43612e+08 0.999023 ns
tpch_q16/DataFusion:parquet 143471671 1.49968e+08 0.956684 ns
tpch_q17/DataFusion:parquet 697970560 6.96501e+08 1.00211 ns
tpch_q17/DataFusion:parquet 697970560 7.09641e+08 0.983554 ns
tpch_q18/DataFusion:parquet 1097771590 1.0868e+09 1.01009 ns
tpch_q18/DataFusion:parquet 1097771590 1.13136e+09 0.970314 ns
tpch_q19/DataFusion:parquet 266808984 2.72367e+08 0.979594 ns
tpch_q19/DataFusion:parquet 266808984 2.79201e+08 0.955618 ns
tpch_q20/DataFusion:parquet 300389061 2.99462e+08 1.0031 ns
tpch_q20/DataFusion:parquet 300389061 3.06647e+08 0.979591 ns
tpch_q21/DataFusion:parquet 849527154 8.55698e+08 0.992789 ns
tpch_q21/DataFusion:parquet 849527154 8.73221e+08 0.972866 ns
tpch_q22/DataFusion:parquet 327042407 3.24842e+08 1.00677 ns
tpch_q22/DataFusion:parquet 327042407 3.23912e+08 1.00967 ns
tpch_q01/DataFusion:vortex-file-compressed 488416040 4.55938e+08 1.07123 ns
tpch_q01/DataFusion:vortex-file-compressed 488416040 4.82777e+08 1.01168 ns
tpch_q02/DataFusion:vortex-file-compressed 153128222 1.53401e+08 0.998225 ns
tpch_q02/DataFusion:vortex-file-compressed 153128222 1.55144e+08 0.987006 ns
tpch_q03/DataFusion:vortex-file-compressed 214589441 2.15237e+08 0.996993 ns
tpch_q03/DataFusion:vortex-file-compressed 214589441 2.18634e+08 0.9815 ns
tpch_q04/DataFusion:vortex-file-compressed 98117000 9.58757e+07 1.02338 ns
tpch_q04/DataFusion:vortex-file-compressed 98117000 1.00646e+08 0.974875 ns
tpch_q05/DataFusion:vortex-file-compressed 552623535 5.42608e+08 1.01846 ns
tpch_q05/DataFusion:vortex-file-compressed 552623535 5.80464e+08 0.952037 ns
tpch_q06/DataFusion:vortex-file-compressed 35281251 3.63963e+07 0.969363 ns
tpch_q06/DataFusion:vortex-file-compressed 35281251 3.6839e+07 0.957716 ns
tpch_q07/DataFusion:vortex-file-compressed 570890674 5.72469e+08 0.997243 ns
tpch_q07/DataFusion:vortex-file-compressed 570890674 5.79204e+08 0.985648 ns
tpch_q08/DataFusion:vortex-file-compressed 626668430 6.30344e+08 0.994169 ns
tpch_q08/DataFusion:vortex-file-compressed 626668430 6.19835e+08 1.01102 ns
tpch_q09/DataFusion:vortex-file-compressed 966429786 9.53594e+08 1.01346 ns
tpch_q09/DataFusion:vortex-file-compressed 966429786 1.05223e+09 0.918454 ns
tpch_q10/DataFusion:vortex-file-compressed 247609642 2.5435e+08 0.9735 ns
tpch_q10/DataFusion:vortex-file-compressed 247609642 2.58021e+08 0.959648 ns
tpch_q11/DataFusion:vortex-file-compressed 127276368 1.30769e+08 0.97329 ns
tpch_q11/DataFusion:vortex-file-compressed 127276368 1.28126e+08 0.993371 ns
tpch_q12/DataFusion:vortex-file-compressed 96122064 9.66569e+07 0.994467 ns
tpch_q12/DataFusion:vortex-file-compressed 96122064 9.56263e+07 1.00518 ns
tpch_q13/DataFusion:vortex-file-compressed 215487503 2.15618e+08 0.999396 ns
tpch_q13/DataFusion:vortex-file-compressed 215487503 2.18589e+08 0.985812 ns
tpch_q14/DataFusion:vortex-file-compressed 53802657 5.3347e+07 1.00854 ns
tpch_q14/DataFusion:vortex-file-compressed 53802657 5.47482e+07 0.982729 ns
tpch_q15/DataFusion:vortex-file-compressed 93551590 9.41993e+07 0.993124 ns
tpch_q15/DataFusion:vortex-file-compressed 93551590 9.39876e+07 0.995361 ns
tpch_q16/DataFusion:vortex-file-compressed 82949081 8.18004e+07 1.01404 ns
tpch_q16/DataFusion:vortex-file-compressed 82949081 8.39184e+07 0.988449 ns
tpch_q17/DataFusion:vortex-file-compressed 879146403 9.03331e+08 0.973227 ns
tpch_q17/DataFusion:vortex-file-compressed 879146403 8.95008e+08 0.982278 ns
tpch_q18/DataFusion:vortex-file-compressed 1078680745 1.09085e+09 0.988848 ns
tpch_q18/DataFusion:vortex-file-compressed 1078680745 1.09673e+09 0.983541 ns
tpch_q19/DataFusion:vortex-file-compressed 67690826 6.7382e+07 1.00458 ns
tpch_q19/DataFusion:vortex-file-compressed 67690826 6.79086e+07 0.996793 ns
tpch_q20/DataFusion:vortex-file-compressed 172947111 1.75124e+08 0.987568 ns
tpch_q20/DataFusion:vortex-file-compressed 172947111 1.77735e+08 0.97306 ns
tpch_q21/DataFusion:vortex-file-compressed 747570900 7.49419e+08 0.997534 ns
tpch_q21/DataFusion:vortex-file-compressed 747570900 7.59366e+08 0.984467 ns
tpch_q22/DataFusion:vortex-file-compressed 64487201 6.4863e+07 0.994207 ns
tpch_q22/DataFusion:vortex-file-compressed 64487201 6.52101e+07 0.988914 ns
tpch_q01/DataFusion:vortex-compact 508775415 5.25528e+08 0.968123 ns
tpch_q02/DataFusion:vortex-compact 158864272 1.62957e+08 0.974882 ns
tpch_q03/DataFusion:vortex-compact 234855262 2.32076e+08 1.01197 ns
tpch_q04/DataFusion:vortex-compact 115226055 1.1442e+08 1.00704 ns
tpch_q05/DataFusion:vortex-compact 553492262 5.58034e+08 0.991861 ns
tpch_q06/DataFusion:vortex-compact 74991897 7.50966e+07 0.998606 ns
tpch_q07/DataFusion:vortex-compact 599987231 6.06786e+08 0.988796 ns
tpch_q08/DataFusion:vortex-compact 628770638 6.24356e+08 1.00707 ns
tpch_q09/DataFusion:vortex-compact 971080632 9.5756e+08 1.01412 ns
tpch_q10/DataFusion:vortex-compact 285627889 2.86731e+08 0.996152 ns
tpch_q11/DataFusion:vortex-compact 129543883 1.29271e+08 1.00211 ns
tpch_q12/DataFusion:vortex-compact 156878544 1.56484e+08 1.00252 ns
tpch_q13/DataFusion:vortex-compact 260509044 2.58875e+08 1.00631 ns
tpch_q14/DataFusion:vortex-compact 87908414 8.70969e+07 1.00932 ns
tpch_q15/DataFusion:vortex-compact 169039429 1.68673e+08 1.00217 ns
tpch_q16/DataFusion:vortex-compact 88429714 8.9268e+07 0.990609 ns
tpch_q17/DataFusion:vortex-compact 892451177 8.9965e+08 0.991999 ns
tpch_q18/DataFusion:vortex-compact 1087860057 1.09463e+09 0.993818 ns
tpch_q19/DataFusion:vortex-compact 141247119 1.42756e+08 0.989433 ns
tpch_q20/DataFusion:vortex-compact 206143974 2.04801e+08 1.00656 ns
tpch_q21/DataFusion:vortex-compact 751436071 7.52904e+08 0.99805 ns
tpch_q22/DataFusion:vortex-compact 71297040 7.33239e+07 0.972357 ns
tpch_q01/DuckDB:parquet 259775588 2.58921e+08 1.0033 ns
tpch_q01/DuckDB:parquet 259775588 2.58435e+08 1.00519 ns
tpch_q02/DuckDB:parquet 122046711 1.1298e+08 1.08025 ns
tpch_q02/DuckDB:parquet 122046711 1.24521e+08 0.980133 ns
tpch_q03/DuckDB:parquet 220658429 2.20487e+08 1.00078 ns
tpch_q03/DuckDB:parquet 220658429 2.23298e+08 0.988177 ns
tpch_q04/DuckDB:parquet 149920296 1.48804e+08 1.0075 ns
tpch_q04/DuckDB:parquet 149920296 1.50487e+08 0.996235 ns
tpch_q05/DuckDB:parquet 231029218 2.27827e+08 1.01406 ns
tpch_q05/DuckDB:parquet 231029218 2.29366e+08 1.00725 ns
tpch_q06/DuckDB:parquet 70339780 7.00875e+07 1.0036 ns
tpch_q06/DuckDB:parquet 70339780 6.99217e+07 1.00598 ns
tpch_q07/DuckDB:parquet 215339236 2.14024e+08 1.00615 ns
tpch_q07/DuckDB:parquet 215339236 2.16614e+08 0.994116 ns
tpch_q08/DuckDB:parquet 327297706 3.22963e+08 1.01342 ns
tpch_q08/DuckDB:parquet 327297706 3.27821e+08 0.998405 ns
tpch_q09/DuckDB:parquet 484748308 4.83782e+08 1.002 ns
tpch_q09/DuckDB:parquet 484748308 4.81556e+08 1.00663 ns
tpch_q10/DuckDB:parquet 631737212 6.34462e+08 0.995706 ns
tpch_q10/DuckDB:parquet 631737212 6.36042e+08 0.993231 ns
tpch_q11/DuckDB:parquet 49762866 5.00903e+07 0.993462 ns
tpch_q11/DuckDB:parquet 49762866 4.96423e+07 1.00243 ns
tpch_q12/DuckDB:parquet 139875680 1.40205e+08 0.997651 ns
tpch_q12/DuckDB:parquet 139875680 1.38942e+08 1.00672 ns
tpch_q13/DuckDB:parquet 402795420 4.11358e+08 0.979184 ns
tpch_q13/DuckDB:parquet 402795420 4.09364e+08 0.983955 ns
tpch_q14/DuckDB:parquet 179939217 1.79223e+08 1.004 ns
tpch_q14/DuckDB:parquet 179939217 1.79784e+08 1.00086 ns
tpch_q15/DuckDB:parquet 105573633 1.06197e+08 0.994134 ns
tpch_q15/DuckDB:parquet 105573633 1.06698e+08 0.989466 ns
tpch_q16/DuckDB:parquet 136589304 1.62278e+08 0.841699 ns
tpch_q16/DuckDB:parquet 136589304 1.36826e+08 0.998272 ns
tpch_q17/DuckDB:parquet 202830013 2.03191e+08 0.998225 ns
tpch_q17/DuckDB:parquet 202830013 2.02767e+08 1.00031 ns
tpch_q18/DuckDB:parquet 353285799 3.6255e+08 0.974447 ns
tpch_q18/DuckDB:parquet 353285799 3.58406e+08 0.985714 ns
tpch_q19/DuckDB:parquet 277853325 2.75218e+08 1.00957 ns
tpch_q19/DuckDB:parquet 277853325 2.7889e+08 0.996281 ns
tpch_q20/DuckDB:parquet 217368654 2.16081e+08 1.00596 ns
tpch_q20/DuckDB:parquet 217368654 2.18259e+08 0.99592 ns
tpch_q21/DuckDB:parquet 563304597 5.66781e+08 0.993866 ns
tpch_q21/DuckDB:parquet 563304597 5.6626e+08 0.994781 ns
tpch_q22/DuckDB:parquet 292601018 2.97023e+08 0.985114 ns
tpch_q22/DuckDB:parquet 292601018 2.87798e+08 1.01669 ns
tpch_q01/DuckDB:vortex-file-compressed 197970201 1.95462e+08 1.01283 ns
tpch_q01/DuckDB:vortex-file-compressed 197970201 1.96982e+08 1.00502 ns
tpch_q02/DuckDB:vortex-file-compressed 54576713 5.35973e+07 1.01827 ns
tpch_q02/DuckDB:vortex-file-compressed 54576713 5.52101e+07 0.988527 ns
tpch_q03/DuckDB:vortex-file-compressed 127670904 1.30402e+08 0.979059 ns
tpch_q03/DuckDB:vortex-file-compressed 127670904 1.30921e+08 0.975178 ns
tpch_q04/DuckDB:vortex-file-compressed 143407710 1.46649e+08 0.9779 ns
tpch_q04/DuckDB:vortex-file-compressed 143407710 1.48142e+08 0.968045 ns
tpch_q05/DuckDB:vortex-file-compressed 127879349 1.30239e+08 0.981881 ns
tpch_q05/DuckDB:vortex-file-compressed 127879349 1.29854e+08 0.984793 ns
tpch_q06/DuckDB:vortex-file-compressed 49616051 5.0808e+07 0.976539 ns
tpch_q06/DuckDB:vortex-file-compressed 49616051 5.03124e+07 0.98616 ns
tpch_q07/DuckDB:vortex-file-compressed 139323112 1.39304e+08 1.00014 ns
tpch_q07/DuckDB:vortex-file-compressed 139323112 1.40215e+08 0.993642 ns
tpch_q08/DuckDB:vortex-file-compressed 233340254 2.31909e+08 1.00617 ns
tpch_q08/DuckDB:vortex-file-compressed 233340254 2.29818e+08 1.01533 ns
tpch_q09/DuckDB:vortex-file-compressed 350788505 3.52152e+08 0.996128 ns
tpch_q09/DuckDB:vortex-file-compressed 350788505 3.56084e+08 0.985129 ns
tpch_q10/DuckDB:vortex-file-compressed 140986689 1.39619e+08 1.00979 ns
tpch_q10/DuckDB:vortex-file-compressed 140986689 1.40995e+08 0.999939 ns
tpch_q11/DuckDB:vortex-file-compressed 36189450 3.60024e+07 1.00519 ns
tpch_q11/DuckDB:vortex-file-compressed 36189450 3.52163e+07 1.02763 ns
tpch_q12/DuckDB:vortex-file-compressed 103118013 1.02307e+08 1.00792 ns
tpch_q12/DuckDB:vortex-file-compressed 103118013 1.03134e+08 0.999849 ns
tpch_q13/DuckDB:vortex-file-compressed 233322045 2.34137e+08 0.996521 ns
tpch_q13/DuckDB:vortex-file-compressed 233322045 2.36169e+08 0.987946 ns
tpch_q14/DuckDB:vortex-file-compressed 62288974 6.28881e+07 0.990473 ns
tpch_q14/DuckDB:vortex-file-compressed 62288974 6.3905e+07 0.974711 ns
tpch_q15/DuckDB:vortex-file-compressed 53250570 5.41184e+07 0.983964 ns
tpch_q15/DuckDB:vortex-file-compressed 53250570 5.39541e+07 0.98696 ns
tpch_q16/DuckDB:vortex-file-compressed 80821505 7.60235e+07 1.06311 ns
tpch_q16/DuckDB:vortex-file-compressed 80821505 7.68412e+07 1.0518 ns
tpch_q17/DuckDB:vortex-file-compressed 123244465 1.22653e+08 1.00482 ns
tpch_q17/DuckDB:vortex-file-compressed 123244465 1.24347e+08 0.991131 ns
tpch_q18/DuckDB:vortex-file-compressed 277570466 2.76731e+08 1.00303 ns
tpch_q18/DuckDB:vortex-file-compressed 277570466 2.78245e+08 0.997577 ns
tpch_q19/DuckDB:vortex-file-compressed 93708488 9.49276e+07 0.987157 ns
tpch_q19/DuckDB:vortex-file-compressed 93708488 9.51305e+07 0.985052 ns
tpch_q20/DuckDB:vortex-file-compressed 106787589 1.05699e+08 1.0103 ns
tpch_q20/DuckDB:vortex-file-compressed 106787589 1.04583e+08 1.02108 ns
tpch_q21/DuckDB:vortex-file-compressed 569959062 5.72952e+08 0.994777 ns
tpch_q21/DuckDB:vortex-file-compressed 569959062 5.72464e+08 0.995624 ns
tpch_q22/DuckDB:vortex-file-compressed 71108734 7.01869e+07 1.01313 ns
tpch_q22/DuckDB:vortex-file-compressed 71108734 7.29583e+07 0.974649 ns
tpch_q01/DuckDB:vortex-compact 247548123 2.49133e+08 0.993639 ns
tpch_q02/DuckDB:vortex-compact 71093774 7.13013e+07 0.997089 ns
tpch_q03/DuckDB:vortex-compact 177261402 1.7827e+08 0.99434 ns
tpch_q04/DuckDB:vortex-compact 198905029 1.99129e+08 0.998875 ns
tpch_q05/DuckDB:vortex-compact 168483086 1.6786e+08 1.00371 ns
tpch_q06/DuckDB:vortex-compact 108594499 1.0815e+08 1.00411 ns
tpch_q07/DuckDB:vortex-compact 218943943 2.1879e+08 1.0007 ns
tpch_q08/DuckDB:vortex-compact 257117348 2.55649e+08 1.00574 ns
tpch_q09/DuckDB:vortex-compact 401269272 4.01507e+08 0.999407 ns
tpch_q10/DuckDB:vortex-compact 203572862 2.04902e+08 0.993514 ns
tpch_q11/DuckDB:vortex-compact 42335008 4.34482e+07 0.97438 ns
tpch_q12/DuckDB:vortex-compact 303042964 3.04195e+08 0.996213 ns
tpch_q13/DuckDB:vortex-compact 294287347 2.92312e+08 1.00676 ns
tpch_q14/DuckDB:vortex-compact 107172525 1.07272e+08 0.999076 ns
tpch_q15/DuckDB:vortex-compact 102259812 1.02965e+08 0.993153 ns
tpch_q16/DuckDB:vortex-compact 88719329 8.97955e+07 0.988015 ns
tpch_q17/DuckDB:vortex-compact 140067255 1.41286e+08 0.991374 ns
tpch_q18/DuckDB:vortex-compact 327241023 3.31971e+08 0.985752 ns
tpch_q19/DuckDB:vortex-compact 154108860 1.54177e+08 0.999559 ns
tpch_q20/DuckDB:vortex-compact 161175498 1.6091e+08 1.00165 ns
tpch_q21/DuckDB:vortex-compact 671785224 6.76177e+08 0.993504 ns
tpch_q22/DuckDB:vortex-compact 79262194 8.09536e+07 0.979107 ns
tpch_q01/DuckDB:duckdb 116613099 1.16239e+08 1.00322 ns
tpch_q01/DuckDB:duckdb 116613099 1.17014e+08 0.996576 ns
tpch_q02/DuckDB:duckdb 50853912 4.74869e+07 1.0709 ns
tpch_q02/DuckDB:duckdb 50853912 5.16968e+07 0.983695 ns
tpch_q03/DuckDB:duckdb 100909223 1.01183e+08 0.997292 ns
tpch_q03/DuckDB:duckdb 100909223 1.00036e+08 1.00873 ns
tpch_q04/DuckDB:duckdb 121489477 1.20299e+08 1.00989 ns
tpch_q04/DuckDB:duckdb 121489477 1.20988e+08 1.00414 ns
tpch_q05/DuckDB:duckdb 110197854 1.15256e+08 0.956114 ns
tpch_q05/DuckDB:duckdb 110197854 1.12012e+08 0.983803 ns
tpch_q06/DuckDB:duckdb 44621522 4.45656e+07 1.00125 ns
tpch_q06/DuckDB:duckdb 44621522 4.47363e+07 0.997434 ns
tpch_q07/DuckDB:duckdb 108488882 1.09414e+08 0.991543 ns
tpch_q07/DuckDB:duckdb 108488882 1.08864e+08 0.99655 ns
tpch_q08/DuckDB:duckdb 139513415 1.38478e+08 1.00748 ns
tpch_q08/DuckDB:duckdb 139513415 1.39093e+08 1.00302 ns
tpch_q09/DuckDB:duckdb 303160724 3.03537e+08 0.998759 ns
tpch_q09/DuckDB:duckdb 303160724 3.01112e+08 1.0068 ns
tpch_q10/DuckDB:duckdb 206009862 2.1227e+08 0.970507 ns
tpch_q10/DuckDB:duckdb 206009862 2.12773e+08 0.968216 ns
tpch_q11/DuckDB:duckdb 22516533 2.21745e+07 1.01542 ns
tpch_q11/DuckDB:duckdb 22516533 2.24967e+07 1.00088 ns
tpch_q12/DuckDB:duckdb 85430427 8.58175e+07 0.995489 ns
tpch_q12/DuckDB:duckdb 85430427 8.55648e+07 0.99843 ns
tpch_q13/DuckDB:duckdb 233601673 2.35499e+08 0.991945 ns
tpch_q13/DuckDB:duckdb 233601673 2.36326e+08 0.988473 ns
tpch_q14/DuckDB:duckdb 76832459 7.73735e+07 0.993007 ns
tpch_q14/DuckDB:duckdb 76832459 7.8078e+07 0.984047 ns
tpch_q15/DuckDB:duckdb 66873031 6.69682e+07 0.998578 ns
tpch_q15/DuckDB:duckdb 66873031 6.7527e+07 0.990316 ns
tpch_q16/DuckDB:duckdb 72657126 7.31992e+07 0.992594 ns
tpch_q16/DuckDB:duckdb 72657126 7.34165e+07 0.989657 ns
tpch_q17/DuckDB:duckdb 98770335 9.85452e+07 1.00228 ns
tpch_q17/DuckDB:duckdb 98770335 9.83035e+07 1.00475 ns
tpch_q18/DuckDB:duckdb 216414204 2.17004e+08 0.997281 ns
tpch_q18/DuckDB:duckdb 216414204 2.1708e+08 0.996933 ns
tpch_q19/DuckDB:duckdb 128017596 1.2782e+08 1.00154 ns
tpch_q19/DuckDB:duckdb 128017596 1.27652e+08 1.00286 ns
tpch_q20/DuckDB:duckdb 97359720 9.68273e+07 1.0055 ns
tpch_q20/DuckDB:duckdb 97359720 9.75457e+07 0.998094 ns
tpch_q21/DuckDB:duckdb 311547223 3.13135e+08 0.994928 ns
tpch_q21/DuckDB:duckdb 311547223 3.11572e+08 0.999921 ns
tpch_q22/DuckDB:duckdb 66880276 6.70163e+07 0.99797 ns
tpch_q22/DuckDB:duckdb 66880276 6.96958e+07 0.959603 ns

github-actions[bot] avatar Sep 08 '25 20:09 github-actions[bot]

Benchmarks: Statistical and Population Genetics

Summary

  • Overall: 0.993x ➖
  • Vortex: 0.987x ➖
  • duckdb:vortex: 0.987x ➖
  • Best: statpopgen_q01/DuckDB:vortex-compact (0.795x)
  • Worst: statpopgen_q01/DuckDB:vortex-file-compressed (1.463x)
  • Significant (>10%): 1↑ 1↓
Detailed Results Table
name PR 44465167 base 4181e121 ratio (PR/base) unit remark
statpopgen_q00/DuckDB:parquet 196291434 1.92797e+08 1.01813 ns
statpopgen_q01/DuckDB:parquet 332755074 3.31425e+08 1.00401 ns
statpopgen_q02/DuckDB:parquet 647276553 6.39834e+08 1.01163 ns
statpopgen_q03/DuckDB:parquet 1071307601 1.0682e+09 1.00291 ns
statpopgen_q04/DuckDB:parquet 1067270265 1.07201e+09 0.995575 ns
statpopgen_q05/DuckDB:parquet 696105203 6.88146e+08 1.01157 ns
statpopgen_q06/DuckDB:parquet 1273496038 1.28123e+09 0.993964 ns
statpopgen_q07/DuckDB:parquet 815893557 8.25545e+08 0.988309 ns
statpopgen_q08/DuckDB:parquet 823365265 8.27611e+08 0.994869 ns
statpopgen_q09/DuckDB:parquet 900936940 8.73498e+08 1.03141 ns
statpopgen_q10/DuckDB:parquet 2027240875 2.05606e+09 0.985985 ns
statpopgen_q00/DuckDB:vortex-file-compressed 11776463 1.22397e+07 0.962151 ns
statpopgen_q01/DuckDB:vortex-file-compressed 87095396 5.95277e+07 1.46311 ns 🚨
statpopgen_q02/DuckDB:vortex-file-compressed 423134572 4.26977e+08 0.991001 ns
statpopgen_q03/DuckDB:vortex-file-compressed 1045822608 1.04889e+09 0.997078 ns
statpopgen_q04/DuckDB:vortex-file-compressed 1051821871 1.04231e+09 1.00912 ns
statpopgen_q05/DuckDB:vortex-file-compressed 514572936 5.13096e+08 1.00288 ns
statpopgen_q06/DuckDB:vortex-file-compressed 1405949494 1.40007e+09 1.0042 ns
statpopgen_q07/DuckDB:vortex-file-compressed 322790863 3.37574e+08 0.956207 ns
statpopgen_q08/DuckDB:vortex-file-compressed 333629143 3.4498e+08 0.967097 ns
statpopgen_q09/DuckDB:vortex-file-compressed 777307066 7.98829e+08 0.973058 ns
statpopgen_q10/DuckDB:vortex-file-compressed 2445172150 2.49065e+09 0.981742 ns
statpopgen_q00/DuckDB:vortex-compact 12180217 1.21453e+07 1.00288 ns
statpopgen_q01/DuckDB:vortex-compact 169527677 2.13293e+08 0.794812 ns
statpopgen_q02/DuckDB:vortex-compact 509752233 5.64843e+08 0.902468 ns
statpopgen_q03/DuckDB:vortex-compact 1124965022 1.15608e+09 0.973084 ns
statpopgen_q04/DuckDB:vortex-compact 1119552054 1.15883e+09 0.966103 ns
statpopgen_q05/DuckDB:vortex-compact 558711286 5.80062e+08 0.963193 ns
statpopgen_q06/DuckDB:vortex-compact 1477636468 1.52916e+09 0.966304 ns
statpopgen_q07/DuckDB:vortex-compact 1187576305 1.22778e+09 0.967255 ns
statpopgen_q08/DuckDB:vortex-compact 1414904164 1.39997e+09 1.01067 ns
statpopgen_q09/DuckDB:vortex-compact 892596848 9.18732e+08 0.971553 ns
statpopgen_q10/DuckDB:vortex-compact 2585502035 2.55973e+09 1.01007 ns

github-actions[bot] avatar Sep 08 '25 20:09 github-actions[bot]

Benchmarks: TPC-H SF=10 on S3

Summary

  • Overall: 1.008x ➖
  • Vortex: 1.011x ➖
  • duckdb:vortex: 1.010x ➖
  • datafusion:vortex: 1.012x ➖
  • Best: tpch_q14/DataFusion:vortex-file-compressed (0.806x)
  • Worst: tpch_q02/DataFusion:vortex-file-compressed (1.392x)
  • Significant (>30%): 0↑ 2↓
Detailed Results Table
name PR 44465167 base 4181e121 ratio (PR/base) unit remark
tpch_q01/DataFusion:parquet 1088845781 1.06026e+09 1.02697 ns
tpch_q01/DataFusion:parquet 1088845781 1.09914e+09 0.990636 ns
tpch_q02/DataFusion:parquet 633933702 6.08095e+08 1.04249 ns
tpch_q02/DataFusion:parquet 633933702 5.93856e+08 1.06749 ns
tpch_q03/DataFusion:parquet 871685475 8.28028e+08 1.05272 ns
tpch_q03/DataFusion:parquet 871685475 8.54968e+08 1.01955 ns
tpch_q04/DataFusion:parquet 454672685 5.34785e+08 0.850197 ns
tpch_q04/DataFusion:parquet 454672685 5.0763e+08 0.895678 ns
tpch_q05/DataFusion:parquet 1000984801 9.45412e+08 1.05878 ns
tpch_q05/DataFusion:parquet 1000984801 9.63472e+08 1.03893 ns
tpch_q06/DataFusion:parquet 489380949 4.49945e+08 1.08765 ns
tpch_q06/DataFusion:parquet 489380949 5.0232e+08 0.974242 ns
tpch_q07/DataFusion:parquet 1253097988 1.2419e+09 1.00902 ns
tpch_q07/DataFusion:parquet 1253097988 1.22862e+09 1.01992 ns
tpch_q08/DataFusion:parquet 1287575265 1.31058e+09 0.982446 ns
tpch_q08/DataFusion:parquet 1287575265 1.30428e+09 0.987192 ns
tpch_q09/DataFusion:parquet 1618675415 1.57153e+09 1.03 ns
tpch_q09/DataFusion:parquet 1618675415 1.55745e+09 1.03931 ns
tpch_q10/DataFusion:parquet 1809598897 1.79115e+09 1.0103 ns
tpch_q10/DataFusion:parquet 1809598897 1.81734e+09 0.995743 ns
tpch_q11/DataFusion:parquet 390275374 4.06057e+08 0.961134 ns
tpch_q11/DataFusion:parquet 390275374 3.93481e+08 0.991853 ns
tpch_q12/DataFusion:parquet 558823871 6.05308e+08 0.923206 ns
tpch_q12/DataFusion:parquet 558823871 6.12895e+08 0.911777 ns
tpch_q13/DataFusion:parquet 700778118 6.98081e+08 1.00386 ns
tpch_q13/DataFusion:parquet 700778118 7.02816e+08 0.997101 ns
tpch_q14/DataFusion:parquet 735082062 7.00251e+08 1.04974 ns
tpch_q14/DataFusion:parquet 735082062 7.24263e+08 1.01494 ns
tpch_q15/DataFusion:parquet 1146094028 1.16056e+09 0.987532 ns
tpch_q15/DataFusion:parquet 1146094028 1.1758e+09 0.974732 ns
tpch_q16/DataFusion:parquet 331377850 3.30985e+08 1.00119 ns
tpch_q16/DataFusion:parquet 331377850 3.25413e+08 1.01833 ns
tpch_q17/DataFusion:parquet 1295897349 1.27084e+09 1.01972 ns
tpch_q17/DataFusion:parquet 1295897349 1.27649e+09 1.0152 ns
tpch_q18/DataFusion:parquet 1591519595 1.58916e+09 1.00149 ns
tpch_q18/DataFusion:parquet 1591519595 1.59168e+09 0.999896 ns
tpch_q19/DataFusion:parquet 854042227 8.31187e+08 1.0275 ns
tpch_q19/DataFusion:parquet 854042227 8.58147e+08 0.995216 ns
tpch_q20/DataFusion:parquet 991418964 9.76252e+08 1.01554 ns
tpch_q20/DataFusion:parquet 991418964 1.00097e+09 0.990459 ns
tpch_q21/DataFusion:parquet 1644128658 1.59859e+09 1.02849 ns
tpch_q21/DataFusion:parquet 1644128658 1.62394e+09 1.01243 ns
tpch_q22/DataFusion:parquet 745951640 7.4733e+08 0.998156 ns
tpch_q22/DataFusion:parquet 745951640 7.43678e+08 1.00306 ns
tpch_q01/DataFusion:vortex-file-compressed 723805400 7.39875e+08 0.97828 ns
tpch_q01/DataFusion:vortex-file-compressed 723805400 7.1638e+08 1.01037 ns
tpch_q02/DataFusion:vortex-file-compressed 654784664 4.70669e+08 1.39118 ns 🚨
tpch_q02/DataFusion:vortex-file-compressed 654784664 4.70413e+08 1.39194 ns 🚨
tpch_q03/DataFusion:vortex-file-compressed 818811391 7.61706e+08 1.07497 ns
tpch_q03/DataFusion:vortex-file-compressed 818811391 7.69548e+08 1.06402 ns
tpch_q04/DataFusion:vortex-file-compressed 496957700 4.77278e+08 1.04123 ns
tpch_q04/DataFusion:vortex-file-compressed 496957700 4.92843e+08 1.00835 ns
tpch_q05/DataFusion:vortex-file-compressed 1051243805 1.00937e+09 1.04149 ns
tpch_q05/DataFusion:vortex-file-compressed 1051243805 1.10875e+09 0.948137 ns
tpch_q06/DataFusion:vortex-file-compressed 532392969 5.37549e+08 0.990408 ns
tpch_q06/DataFusion:vortex-file-compressed 532392969 5.23789e+08 1.01643 ns
tpch_q07/DataFusion:vortex-file-compressed 871866471 8.63167e+08 1.01008 ns
tpch_q07/DataFusion:vortex-file-compressed 871866471 8.68575e+08 1.00379 ns
tpch_q08/DataFusion:vortex-file-compressed 1212402220 1.3162e+09 0.921141 ns
tpch_q08/DataFusion:vortex-file-compressed 1212402220 1.25943e+09 0.962661 ns
tpch_q09/DataFusion:vortex-file-compressed 1578121086 1.55304e+09 1.01615 ns
tpch_q09/DataFusion:vortex-file-compressed 1578121086 1.68679e+09 0.935575 ns
tpch_q10/DataFusion:vortex-file-compressed 1127865353 1.3005e+09 0.867257 ns
tpch_q10/DataFusion:vortex-file-compressed 1127865353 1.26767e+09 0.889716 ns
tpch_q11/DataFusion:vortex-file-compressed 341834423 3.65788e+08 0.934515 ns
tpch_q11/DataFusion:vortex-file-compressed 341834423 3.47621e+08 0.983354 ns
tpch_q12/DataFusion:vortex-file-compressed 711826977 7.06926e+08 1.00693 ns
tpch_q12/DataFusion:vortex-file-compressed 711826977 7.00717e+08 1.01586 ns
tpch_q13/DataFusion:vortex-file-compressed 386254112 3.81656e+08 1.01205 ns
tpch_q13/DataFusion:vortex-file-compressed 386254112 3.975e+08 0.97171 ns
tpch_q14/DataFusion:vortex-file-compressed 515945020 4.97165e+08 1.03777 ns
tpch_q14/DataFusion:vortex-file-compressed 515945020 6.39955e+08 0.806221 ns
tpch_q15/DataFusion:vortex-file-compressed 1001720671 1.0345e+09 0.968316 ns
tpch_q15/DataFusion:vortex-file-compressed 1001720671 1.03548e+09 0.967393 ns
tpch_q16/DataFusion:vortex-file-compressed 362592763 3.12648e+08 1.15975 ns
tpch_q16/DataFusion:vortex-file-compressed 362592763 3.12037e+08 1.16202 ns
tpch_q17/DataFusion:vortex-file-compressed 1370819438 1.3282e+09 1.03209 ns
tpch_q17/DataFusion:vortex-file-compressed 1370819438 1.31883e+09 1.03942 ns
tpch_q18/DataFusion:vortex-file-compressed 1422771663 1.44074e+09 0.987527 ns
tpch_q18/DataFusion:vortex-file-compressed 1422771663 1.42701e+09 0.997032 ns
tpch_q19/DataFusion:vortex-file-compressed 758374865 7.37945e+08 1.02768 ns
tpch_q19/DataFusion:vortex-file-compressed 758374865 7.89994e+08 0.959975 ns
tpch_q20/DataFusion:vortex-file-compressed 818858386 7.4522e+08 1.09881 ns
tpch_q20/DataFusion:vortex-file-compressed 818858386 8.75996e+08 0.934774 ns
tpch_q21/DataFusion:vortex-file-compressed 1592337424 1.49156e+09 1.06756 ns
tpch_q21/DataFusion:vortex-file-compressed 1592337424 1.54708e+09 1.02926 ns
tpch_q22/DataFusion:vortex-file-compressed 278022418 2.72532e+08 1.02015 ns
tpch_q22/DataFusion:vortex-file-compressed 278022418 2.83525e+08 0.980594 ns
tpch_q01/DataFusion:vortex-compact 740275223 7.26476e+08 1.019 ns
tpch_q02/DataFusion:vortex-compact 506104243 4.59321e+08 1.10185 ns
tpch_q03/DataFusion:vortex-compact 743043827 6.4642e+08 1.14948 ns
tpch_q04/DataFusion:vortex-compact 413589049 4.33789e+08 0.953434 ns
tpch_q05/DataFusion:vortex-compact 855501947 8.69591e+08 0.983798 ns
tpch_q06/DataFusion:vortex-compact 536925152 5.03375e+08 1.06665 ns
tpch_q07/DataFusion:vortex-compact 832925567 8.27011e+08 1.00715 ns
tpch_q08/DataFusion:vortex-compact 1127750781 1.14132e+09 0.988113 ns
tpch_q09/DataFusion:vortex-compact 1313753852 1.40001e+09 0.938389 ns
tpch_q10/DataFusion:vortex-compact 809202028 7.73475e+08 1.04619 ns
tpch_q11/DataFusion:vortex-compact 309722912 3.16913e+08 0.977311 ns
tpch_q12/DataFusion:vortex-compact 643280009 6.39728e+08 1.00555 ns
tpch_q13/DataFusion:vortex-compact 355827149 3.65253e+08 0.974194 ns
tpch_q14/DataFusion:vortex-compact 521678324 6.07269e+08 0.859057 ns
tpch_q15/DataFusion:vortex-compact 995699909 1.06203e+09 0.937542 ns
tpch_q16/DataFusion:vortex-compact 347766691 2.96512e+08 1.17286 ns
tpch_q17/DataFusion:vortex-compact 1376789345 1.31357e+09 1.04813 ns
tpch_q18/DataFusion:vortex-compact 1256084501 1.26651e+09 0.991772 ns
tpch_q19/DataFusion:vortex-compact 780127506 7.27884e+08 1.07177 ns
tpch_q20/DataFusion:vortex-compact 629274474 6.51825e+08 0.965404 ns
tpch_q21/DataFusion:vortex-compact 1414535186 1.41805e+09 0.997521 ns
tpch_q22/DataFusion:vortex-compact 277253240 2.71012e+08 1.02303 ns
tpch_q01/DuckDB:parquet 837949866 8.60416e+08 0.973889 ns
tpch_q01/DuckDB:parquet 837949866 8.67987e+08 0.965394 ns
tpch_q02/DuckDB:parquet 1088768947 1.07382e+09 1.01392 ns
tpch_q02/DuckDB:parquet 1088768947 1.20179e+09 0.905956 ns
tpch_q03/DuckDB:parquet 1258474721 1.20471e+09 1.04463 ns
tpch_q03/DuckDB:parquet 1258474721 1.23676e+09 1.01756 ns
tpch_q04/DuckDB:parquet 700471434 7.0528e+08 0.993183 ns
tpch_q04/DuckDB:parquet 700471434 6.82162e+08 1.02684 ns
tpch_q05/DuckDB:parquet 1595992139 1.49151e+09 1.07005 ns
tpch_q05/DuckDB:parquet 1595992139 1.55116e+09 1.0289 ns
tpch_q06/DuckDB:parquet 575944846 5.63946e+08 1.02128 ns
tpch_q06/DuckDB:parquet 575944846 5.51395e+08 1.04452 ns
tpch_q07/DuckDB:parquet 1327760127 1.34824e+09 0.984807 ns
tpch_q07/DuckDB:parquet 1327760127 1.34863e+09 0.984528 ns
tpch_q08/DuckDB:parquet 1798363961 1.78451e+09 1.00777 ns
tpch_q08/DuckDB:parquet 1798363961 1.82791e+09 0.983835 ns
tpch_q09/DuckDB:parquet 1825654940 1.85476e+09 0.984306 ns
tpch_q09/DuckDB:parquet 1825654940 1.86079e+09 0.981121 ns
tpch_q10/DuckDB:parquet 2500484439 2.57059e+09 0.972728 ns
tpch_q10/DuckDB:parquet 2500484439 2.48726e+09 1.00531 ns
tpch_q11/DuckDB:parquet 669082826 6.57367e+08 1.01782 ns
tpch_q11/DuckDB:parquet 669082826 6.0987e+08 1.09709 ns
tpch_q12/DuckDB:parquet 710434927 7.84107e+08 0.906043 ns
tpch_q12/DuckDB:parquet 710434927 7.25646e+08 0.979037 ns
tpch_q13/DuckDB:parquet 942607771 9.39548e+08 1.00326 ns
tpch_q13/DuckDB:parquet 942607771 9.29927e+08 1.01364 ns
tpch_q14/DuckDB:parquet 948335637 9.43785e+08 1.00482 ns
tpch_q14/DuckDB:parquet 948335637 9.28834e+08 1.021 ns
tpch_q15/DuckDB:parquet 865946461 8.47693e+08 1.02153 ns
tpch_q15/DuckDB:parquet 865946461 8.30864e+08 1.04222 ns
tpch_q16/DuckDB:parquet 616626522 5.68224e+08 1.08518 ns
tpch_q16/DuckDB:parquet 616626522 5.08331e+08 1.21304 ns
tpch_q17/DuckDB:parquet 1047577031 9.98731e+08 1.04891 ns
tpch_q17/DuckDB:parquet 1047577031 1.06954e+09 0.979464 ns
tpch_q18/DuckDB:parquet 974097871 9.96437e+08 0.977581 ns
tpch_q18/DuckDB:parquet 974097871 1.01461e+09 0.960076 ns
tpch_q19/DuckDB:parquet 1185965761 1.19277e+09 0.994297 ns
tpch_q19/DuckDB:parquet 1185965761 1.23169e+09 0.962874 ns
tpch_q20/DuckDB:parquet 1316202580 1.3329e+09 0.98747 ns
tpch_q20/DuckDB:parquet 1316202580 1.28835e+09 1.02161 ns
tpch_q21/DuckDB:parquet 1451036440 1.40997e+09 1.02913 ns
tpch_q21/DuckDB:parquet 1451036440 1.39097e+09 1.04318 ns
tpch_q22/DuckDB:parquet 788251650 8.09783e+08 0.973412 ns
tpch_q22/DuckDB:parquet 788251650 7.9294e+08 0.994088 ns
tpch_q01/DuckDB:vortex-file-compressed 897540941 9.24444e+08 0.970898 ns
tpch_q01/DuckDB:vortex-file-compressed 897540941 9.00542e+08 0.996667 ns
tpch_q02/DuckDB:vortex-file-compressed 1026647444 1.01651e+09 1.00997 ns
tpch_q02/DuckDB:vortex-file-compressed 1026647444 9.86541e+08 1.04065 ns
tpch_q03/DuckDB:vortex-file-compressed 1148066999 1.17381e+09 0.978071 ns
tpch_q03/DuckDB:vortex-file-compressed 1148066999 1.15083e+09 0.997601 ns
tpch_q04/DuckDB:vortex-file-compressed 699675912 6.94721e+08 1.00713 ns
tpch_q04/DuckDB:vortex-file-compressed 699675912 7.09475e+08 0.986188 ns
tpch_q05/DuckDB:vortex-file-compressed 1225952929 1.27398e+09 0.962298 ns
tpch_q05/DuckDB:vortex-file-compressed 1225952929 1.22794e+09 0.998379 ns
tpch_q06/DuckDB:vortex-file-compressed 859687163 8.4385e+08 1.01877 ns
tpch_q06/DuckDB:vortex-file-compressed 859687163 8.2148e+08 1.04651 ns
tpch_q07/DuckDB:vortex-file-compressed 1273441520 1.29108e+09 0.98634 ns
tpch_q07/DuckDB:vortex-file-compressed 1273441520 1.26593e+09 1.00594 ns
tpch_q08/DuckDB:vortex-file-compressed 1723368914 1.63027e+09 1.05711 ns
tpch_q08/DuckDB:vortex-file-compressed 1723368914 1.63907e+09 1.05143 ns
tpch_q09/DuckDB:vortex-file-compressed 1729954238 1.75891e+09 0.983538 ns
tpch_q09/DuckDB:vortex-file-compressed 1729954238 1.80284e+09 0.959569 ns
tpch_q10/DuckDB:vortex-file-compressed 1256917550 1.29256e+09 0.972427 ns
tpch_q10/DuckDB:vortex-file-compressed 1256917550 1.17525e+09 1.06949 ns
tpch_q11/DuckDB:vortex-file-compressed 610280453 6.11784e+08 0.997543 ns
tpch_q11/DuckDB:vortex-file-compressed 610280453 6.3292e+08 0.96423 ns
tpch_q12/DuckDB:vortex-file-compressed 814874424 8.28445e+08 0.983619 ns
tpch_q12/DuckDB:vortex-file-compressed 814874424 7.79671e+08 1.04515 ns
tpch_q13/DuckDB:vortex-file-compressed 786718479 8.17144e+08 0.962766 ns
tpch_q13/DuckDB:vortex-file-compressed 786718479 7.98324e+08 0.985462 ns
tpch_q14/DuckDB:vortex-file-compressed 830526332 8.33478e+08 0.996458 ns
tpch_q14/DuckDB:vortex-file-compressed 830526332 8.17326e+08 1.01615 ns
tpch_q15/DuckDB:vortex-file-compressed 797881958 7.92048e+08 1.00737 ns
tpch_q15/DuckDB:vortex-file-compressed 797881958 8.03052e+08 0.993562 ns
tpch_q16/DuckDB:vortex-file-compressed 534092377 4.97681e+08 1.07316 ns
tpch_q16/DuckDB:vortex-file-compressed 534092377 4.86697e+08 1.09738 ns
tpch_q17/DuckDB:vortex-file-compressed 1293585638 1.31941e+09 0.980426 ns
tpch_q17/DuckDB:vortex-file-compressed 1293585638 1.3576e+09 0.952846 ns
tpch_q18/DuckDB:vortex-file-compressed 1201012169 1.2175e+09 0.986458 ns
tpch_q18/DuckDB:vortex-file-compressed 1201012169 1.19756e+09 1.00288 ns
tpch_q19/DuckDB:vortex-file-compressed 1144409811 1.07938e+09 1.06025 ns
tpch_q19/DuckDB:vortex-file-compressed 1144409811 1.10259e+09 1.03793 ns
tpch_q20/DuckDB:vortex-file-compressed 1285458849 1.25187e+09 1.02683 ns
tpch_q20/DuckDB:vortex-file-compressed 1285458849 1.24418e+09 1.03318 ns
tpch_q21/DuckDB:vortex-file-compressed 2114818238 2.09733e+09 1.00834 ns
tpch_q21/DuckDB:vortex-file-compressed 2114818238 2.14313e+09 0.986792 ns
tpch_q22/DuckDB:vortex-file-compressed 451687934 4.38966e+08 1.02898 ns
tpch_q22/DuckDB:vortex-file-compressed 451687934 4.21231e+08 1.0723 ns
tpch_q01/DuckDB:vortex-compact 814646415 8.56928e+08 0.950659 ns
tpch_q02/DuckDB:vortex-compact 979974096 9.79061e+08 1.00093 ns
tpch_q03/DuckDB:vortex-compact 1029667628 1.04512e+09 0.985217 ns
tpch_q04/DuckDB:vortex-compact 645578112 6.27603e+08 1.02864 ns
tpch_q05/DuckDB:vortex-compact 1241237888 1.1828e+09 1.04941 ns
tpch_q06/DuckDB:vortex-compact 731660475 7.46162e+08 0.980565 ns
tpch_q07/DuckDB:vortex-compact 1180234148 1.14384e+09 1.03182 ns
tpch_q08/DuckDB:vortex-compact 1662195359 1.59578e+09 1.04162 ns
tpch_q09/DuckDB:vortex-compact 1652823536 1.59639e+09 1.03535 ns
tpch_q10/DuckDB:vortex-compact 1168708010 1.15506e+09 1.01182 ns
tpch_q11/DuckDB:vortex-compact 645475145 6.04679e+08 1.06747 ns
tpch_q12/DuckDB:vortex-compact 818219502 7.48705e+08 1.09285 ns
tpch_q13/DuckDB:vortex-compact 705758410 7.06651e+08 0.998737 ns
tpch_q14/DuckDB:vortex-compact 782557930 8.75257e+08 0.894089 ns
tpch_q15/DuckDB:vortex-compact 795024462 7.91342e+08 1.00465 ns
tpch_q16/DuckDB:vortex-compact 543207676 4.93127e+08 1.10156 ns
tpch_q17/DuckDB:vortex-compact 1204929220 1.17708e+09 1.02366 ns
tpch_q18/DuckDB:vortex-compact 928063506 9.45822e+08 0.981224 ns
tpch_q19/DuckDB:vortex-compact 1052153672 1.02491e+09 1.02658 ns
tpch_q20/DuckDB:vortex-compact 1145461343 1.18439e+09 0.967128 ns
tpch_q21/DuckDB:vortex-compact 1795955080 1.83967e+09 0.976238 ns
tpch_q22/DuckDB:vortex-compact 465174377 4.4379e+08 1.04819 ns

github-actions[bot] avatar Sep 08 '25 20:09 github-actions[bot]

Benchmarks: Clickbench on NVME

Summary

  • Overall: 0.992x ➖
  • Vortex: 0.994x ➖
  • duckdb:vortex: 1.005x ➖
  • datafusion:vortex: 0.982x ➖
  • Best: clickbench_q23/DuckDB:vortex-compact (0.818x)
  • Worst: clickbench_q23/DuckDB:vortex-file-compressed (2.157x)
  • Significant (>10%): 3↑ 4↓
Detailed Results Table
name PR 44465167 base 4181e121 ratio (PR/base) unit remark
clickbench_q00/DataFusion:parquet 1641141 1.62914e+06 1.00737 ns
clickbench_q00/DataFusion:parquet 1641141 1.62917e+06 1.00735 ns
clickbench_q01/DataFusion:parquet 25510322 2.63386e+07 0.968554 ns
clickbench_q01/DataFusion:parquet 25510322 2.59572e+07 0.982785 ns
clickbench_q02/DataFusion:parquet 59058796 5.97942e+07 0.987701 ns
clickbench_q02/DataFusion:parquet 59058796 6.04436e+07 0.97709 ns
clickbench_q03/DataFusion:parquet 51842963 5.23158e+07 0.990962 ns
clickbench_q03/DataFusion:parquet 51842963 5.06373e+07 1.02381 ns
clickbench_q04/DataFusion:parquet 359779060 3.67552e+08 0.978852 ns
clickbench_q04/DataFusion:parquet 359779060 3.61744e+08 0.994568 ns
clickbench_q05/DataFusion:parquet 370103353 3.74819e+08 0.987418 ns
clickbench_q05/DataFusion:parquet 370103353 3.75122e+08 0.98662 ns
clickbench_q06/DataFusion:parquet 1703789 1.79649e+06 0.948399 ns
clickbench_q06/DataFusion:parquet 1703789 1.70974e+06 0.996522 ns
clickbench_q07/DataFusion:parquet 31108800 3.12056e+07 0.996899 ns
clickbench_q07/DataFusion:parquet 31108800 3.11839e+07 0.997592 ns
clickbench_q08/DataFusion:parquet 449598675 4.59529e+08 0.978391 ns
clickbench_q08/DataFusion:parquet 449598675 4.49393e+08 1.00046 ns
clickbench_q09/DataFusion:parquet 667775704 6.95744e+08 0.959801 ns
clickbench_q09/DataFusion:parquet 667775704 6.93953e+08 0.962278 ns
clickbench_q10/DataFusion:parquet 127175272 1.325e+08 0.959811 ns
clickbench_q10/DataFusion:parquet 127175272 1.27968e+08 0.993803 ns
clickbench_q11/DataFusion:parquet 153596871 1.58432e+08 0.969482 ns
clickbench_q11/DataFusion:parquet 153596871 1.57539e+08 0.974978 ns
clickbench_q12/DataFusion:parquet 377150720 3.93077e+08 0.959483 ns
clickbench_q12/DataFusion:parquet 377150720 3.80229e+08 0.991903 ns
clickbench_q13/DataFusion:parquet 536385679 5.51509e+08 0.972579 ns
clickbench_q13/DataFusion:parquet 536385679 5.39046e+08 0.995064 ns
clickbench_q14/DataFusion:parquet 368601173 3.77507e+08 0.976408 ns
clickbench_q14/DataFusion:parquet 368601173 3.73073e+08 0.988015 ns
clickbench_q15/DataFusion:parquet 414091792 4.18045e+08 0.990545 ns
clickbench_q15/DataFusion:parquet 414091792 4.17679e+08 0.991412 ns
clickbench_q16/DataFusion:parquet 772281759 7.80546e+08 0.989412 ns
clickbench_q16/DataFusion:parquet 772281759 7.87296e+08 0.980929 ns
clickbench_q17/DataFusion:parquet 757898195 7.76335e+08 0.976252 ns
clickbench_q17/DataFusion:parquet 757898195 7.72825e+08 0.980685 ns
clickbench_q18/DataFusion:parquet 1406367455 1.41975e+09 0.990573 ns
clickbench_q18/DataFusion:parquet 1406367455 1.42425e+09 0.987441 ns
clickbench_q19/DataFusion:parquet 38897024 3.95702e+07 0.982987 ns
clickbench_q19/DataFusion:parquet 38897024 3.88528e+07 1.00114 ns
clickbench_q20/DataFusion:parquet 645121439 6.3236e+08 1.02018 ns
clickbench_q20/DataFusion:parquet 645121439 6.35564e+08 1.01504 ns
clickbench_q21/DataFusion:parquet 728130683 7.2662e+08 1.00208 ns
clickbench_q21/DataFusion:parquet 728130683 7.20275e+08 1.01091 ns
clickbench_q22/DataFusion:parquet 1047030718 1.06442e+09 0.983667 ns
clickbench_q22/DataFusion:parquet 1047030718 1.05797e+09 0.989665 ns
clickbench_q23/DataFusion:parquet 4221632090 4.32019e+09 0.977188 ns
clickbench_q23/DataFusion:parquet 4221632090 4.29163e+09 0.98369 ns
clickbench_q24/DataFusion:parquet 104859058 1.05355e+08 0.995294 ns
clickbench_q24/DataFusion:parquet 104859058 1.02355e+08 1.02446 ns
clickbench_q25/DataFusion:parquet 154015740 1.50634e+08 1.02245 ns
clickbench_q25/DataFusion:parquet 154015740 1.52127e+08 1.01242 ns
clickbench_q26/DataFusion:parquet 106132082 1.08191e+08 0.98097 ns
clickbench_q26/DataFusion:parquet 106132082 1.09506e+08 0.969194 ns
clickbench_q27/DataFusion:parquet 1060259218 1.01601e+09 1.04355 ns
clickbench_q27/DataFusion:parquet 1060259218 1.04514e+09 1.01446 ns
clickbench_q28/DataFusion:parquet 5842836724 5.82707e+09 1.00271 ns
clickbench_q28/DataFusion:parquet 5842836724 5.84978e+09 0.998813 ns
clickbench_q29/DataFusion:parquet 225643700 2.42832e+08 0.929218 ns
clickbench_q29/DataFusion:parquet 225643700 2.40599e+08 0.937842 ns
clickbench_q30/DataFusion:parquet 368524196 3.79644e+08 0.970709 ns
clickbench_q30/DataFusion:parquet 368524196 3.73482e+08 0.986726 ns
clickbench_q31/DataFusion:parquet 408156240 4.12264e+08 0.990036 ns
clickbench_q31/DataFusion:parquet 408156240 4.23996e+08 0.962642 ns
clickbench_q32/DataFusion:parquet 1384349258 1.30556e+09 1.06035 ns
clickbench_q32/DataFusion:parquet 1384349258 1.39145e+09 0.994894 ns
clickbench_q33/DataFusion:parquet 1601628865 1.62413e+09 0.986146 ns
clickbench_q33/DataFusion:parquet 1601628865 1.60417e+09 0.998417 ns
clickbench_q34/DataFusion:parquet 1595176462 1.62973e+09 0.978796 ns
clickbench_q34/DataFusion:parquet 1595176462 1.62011e+09 0.984608 ns
clickbench_q35/DataFusion:parquet 584707560 6.05214e+08 0.966116 ns
clickbench_q35/DataFusion:parquet 584707560 6.09939e+08 0.958633 ns
clickbench_q36/DataFusion:parquet 162650898 1.61007e+08 1.01021 ns
clickbench_q36/DataFusion:parquet 162650898 1.69552e+08 0.959297 ns
clickbench_q37/DataFusion:parquet 61264301 6.27869e+07 0.97575 ns
clickbench_q37/DataFusion:parquet 61264301 6.33796e+07 0.966625 ns
clickbench_q38/DataFusion:parquet 92940945 9.57666e+07 0.970494 ns
clickbench_q38/DataFusion:parquet 92940945 9.24725e+07 1.00507 ns
clickbench_q39/DataFusion:parquet 304961298 3.15316e+08 0.967161 ns
clickbench_q39/DataFusion:parquet 304961298 3.12717e+08 0.975198 ns
clickbench_q40/DataFusion:parquet 34693384 3.69172e+07 0.939762 ns
clickbench_q40/DataFusion:parquet 34693384 3.40353e+07 1.01933 ns
clickbench_q41/DataFusion:parquet 33810957 3.28676e+07 1.0287 ns
clickbench_q41/DataFusion:parquet 33810957 3.23266e+07 1.04592 ns
clickbench_q42/DataFusion:parquet 33454194 3.48918e+07 0.958798 ns
clickbench_q42/DataFusion:parquet 33454194 3.44586e+07 0.970852 ns
clickbench_q00/DataFusion:vortex-file-compressed 1752107 1.74485e+06 1.00416 ns
clickbench_q00/DataFusion:vortex-file-compressed 1752107 1.76511e+06 0.992636 ns
clickbench_q01/DataFusion:vortex-file-compressed 10835504 1.07761e+07 1.00551 ns
clickbench_q01/DataFusion:vortex-file-compressed 10835504 1.10518e+07 0.980433 ns
clickbench_q02/DataFusion:vortex-file-compressed 28328149 2.91682e+07 0.971201 ns
clickbench_q02/DataFusion:vortex-file-compressed 28328149 2.9245e+07 0.968649 ns
clickbench_q03/DataFusion:vortex-file-compressed 31600452 3.09585e+07 1.02073 ns
clickbench_q03/DataFusion:vortex-file-compressed 31600452 3.12167e+07 1.01229 ns
clickbench_q04/DataFusion:vortex-file-compressed 312200042 3.13509e+08 0.995826 ns
clickbench_q04/DataFusion:vortex-file-compressed 312200042 3.18532e+08 0.980123 ns
clickbench_q05/DataFusion:vortex-file-compressed 322731531 3.30755e+08 0.975741 ns
clickbench_q05/DataFusion:vortex-file-compressed 322731531 3.411e+08 0.946148 ns
clickbench_q06/DataFusion:vortex-file-compressed 1715543 1.73648e+06 0.987943 ns
clickbench_q06/DataFusion:vortex-file-compressed 1715543 1.77085e+06 0.96877 ns
clickbench_q07/DataFusion:vortex-file-compressed 14848650 1.64752e+07 0.901274 ns
clickbench_q07/DataFusion:vortex-file-compressed 14848650 1.58889e+07 0.93453 ns
clickbench_q08/DataFusion:vortex-file-compressed 375595271 3.91539e+08 0.959279 ns
clickbench_q08/DataFusion:vortex-file-compressed 375595271 3.9358e+08 0.954305 ns
clickbench_q09/DataFusion:vortex-file-compressed 556735227 5.73216e+08 0.971248 ns
clickbench_q09/DataFusion:vortex-file-compressed 556735227 5.7611e+08 0.96637 ns
clickbench_q10/DataFusion:vortex-file-compressed 69731717 6.80665e+07 1.02446 ns
clickbench_q10/DataFusion:vortex-file-compressed 69731717 7.10204e+07 0.981855 ns
clickbench_q11/DataFusion:vortex-file-compressed 78318829 8.03203e+07 0.975081 ns
clickbench_q11/DataFusion:vortex-file-compressed 78318829 8.1466e+07 0.961368 ns
clickbench_q12/DataFusion:vortex-file-compressed 273346836 2.72602e+08 1.00273 ns
clickbench_q12/DataFusion:vortex-file-compressed 273346836 2.75905e+08 0.990729 ns
clickbench_q13/DataFusion:vortex-file-compressed 443784782 4.49131e+08 0.988096 ns
clickbench_q13/DataFusion:vortex-file-compressed 443784782 4.51818e+08 0.98222 ns
clickbench_q14/DataFusion:vortex-file-compressed 252054618 2.558e+08 0.985357 ns
clickbench_q14/DataFusion:vortex-file-compressed 252054618 2.59205e+08 0.972416 ns
clickbench_q15/DataFusion:vortex-file-compressed 367946031 3.74457e+08 0.982613 ns
clickbench_q15/DataFusion:vortex-file-compressed 367946031 3.78569e+08 0.971939 ns
clickbench_q16/DataFusion:vortex-file-compressed 762133776 7.8609e+08 0.969525 ns
clickbench_q16/DataFusion:vortex-file-compressed 762133776 7.83361e+08 0.972903 ns
clickbench_q17/DataFusion:vortex-file-compressed 744516746 7.67101e+08 0.970558 ns
clickbench_q17/DataFusion:vortex-file-compressed 744516746 7.76844e+08 0.958387 ns
clickbench_q18/DataFusion:vortex-file-compressed 1427009377 1.41734e+09 1.00682 ns
clickbench_q18/DataFusion:vortex-file-compressed 1427009377 1.42638e+09 1.00044 ns
clickbench_q19/DataFusion:vortex-file-compressed 18205729 1.91327e+07 0.951549 ns
clickbench_q19/DataFusion:vortex-file-compressed 18205729 1.81377e+07 1.00375 ns
clickbench_q20/DataFusion:vortex-file-compressed 282557076 2.77457e+08 1.01838 ns
clickbench_q20/DataFusion:vortex-file-compressed 282557076 2.76189e+08 1.02306 ns
clickbench_q21/DataFusion:vortex-file-compressed 349446302 3.43632e+08 1.01692 ns
clickbench_q21/DataFusion:vortex-file-compressed 349446302 3.41491e+08 1.0233 ns
clickbench_q22/DataFusion:vortex-file-compressed 687402590 6.76916e+08 1.01549 ns
clickbench_q22/DataFusion:vortex-file-compressed 687402590 6.79628e+08 1.01144 ns
clickbench_q23/DataFusion:vortex-file-compressed 1875294804 1.80465e+09 1.03915 ns
clickbench_q23/DataFusion:vortex-file-compressed 1875294804 1.925e+09 0.974178 ns
clickbench_q24/DataFusion:vortex-file-compressed 74820683 7.38255e+07 1.01348 ns
clickbench_q24/DataFusion:vortex-file-compressed 74820683 7.55648e+07 0.990152 ns
clickbench_q25/DataFusion:vortex-file-compressed 59224949 6.0501e+07 0.978908 ns
clickbench_q25/DataFusion:vortex-file-compressed 59224949 6.29139e+07 0.941365 ns
clickbench_q26/DataFusion:vortex-file-compressed 75985352 7.54063e+07 1.00768 ns
clickbench_q26/DataFusion:vortex-file-compressed 75985352 7.43559e+07 1.02191 ns
clickbench_q27/DataFusion:vortex-file-compressed 794015483 8.08508e+08 0.982075 ns
clickbench_q27/DataFusion:vortex-file-compressed 794015483 7.93337e+08 1.00086 ns
clickbench_q28/DataFusion:vortex-file-compressed 6848872423 6.74879e+09 1.01483 ns
clickbench_q28/DataFusion:vortex-file-compressed 6848872423 6.63796e+09 1.03177 ns
clickbench_q29/DataFusion:vortex-file-compressed 237068031 2.27323e+08 1.04287 ns
clickbench_q29/DataFusion:vortex-file-compressed 237068031 2.38745e+08 0.992977 ns
clickbench_q30/DataFusion:vortex-file-compressed 257158096 2.54415e+08 1.01078 ns
clickbench_q30/DataFusion:vortex-file-compressed 257158096 2.58015e+08 0.99668 ns
clickbench_q31/DataFusion:vortex-file-compressed 290092245 2.93865e+08 0.987163 ns
clickbench_q31/DataFusion:vortex-file-compressed 290092245 2.96847e+08 0.977243 ns
clickbench_q32/DataFusion:vortex-file-compressed 1269975693 1.26114e+09 1.00701 ns
clickbench_q32/DataFusion:vortex-file-compressed 1269975693 1.3973e+09 0.908875 ns
clickbench_q33/DataFusion:vortex-file-compressed 1408717922 1.4572e+09 0.966726 ns
clickbench_q33/DataFusion:vortex-file-compressed 1408717922 1.43768e+09 0.979854 ns
clickbench_q34/DataFusion:vortex-file-compressed 1418530998 1.43918e+09 0.985651 ns
clickbench_q34/DataFusion:vortex-file-compressed 1418530998 1.43943e+09 0.98548 ns
clickbench_q35/DataFusion:vortex-file-compressed 551407371 5.55607e+08 0.992442 ns
clickbench_q35/DataFusion:vortex-file-compressed 551407371 5.60227e+08 0.984256 ns
clickbench_q36/DataFusion:vortex-file-compressed 78754371 7.76032e+07 1.01483 ns
clickbench_q36/DataFusion:vortex-file-compressed 78754371 8.70115e+07 0.905103 ns
clickbench_q37/DataFusion:vortex-file-compressed 36585330 3.74325e+07 0.977369 ns
clickbench_q37/DataFusion:vortex-file-compressed 36585330 3.9309e+07 0.930711 ns
clickbench_q38/DataFusion:vortex-file-compressed 20142046 1.94801e+07 1.03398 ns
clickbench_q38/DataFusion:vortex-file-compressed 20142046 2.04159e+07 0.986584 ns
clickbench_q39/DataFusion:vortex-file-compressed 156601870 1.66139e+08 0.942594 ns
clickbench_q39/DataFusion:vortex-file-compressed 156601870 1.67141e+08 0.936945 ns
clickbench_q40/DataFusion:vortex-file-compressed 17609818 1.82519e+07 0.964819 ns
clickbench_q40/DataFusion:vortex-file-compressed 17609818 1.88513e+07 0.934142 ns
clickbench_q41/DataFusion:vortex-file-compressed 15754372 1.69528e+07 0.929311 ns
clickbench_q41/DataFusion:vortex-file-compressed 15754372 1.65192e+07 0.953701 ns
clickbench_q42/DataFusion:vortex-file-compressed 18870148 1.97421e+07 0.955835 ns
clickbench_q42/DataFusion:vortex-file-compressed 18870148 1.9818e+07 0.952171 ns
clickbench_q00/DataFusion:vortex-compact 1771302 1.80217e+06 0.982872 ns
clickbench_q01/DataFusion:vortex-compact 10567544 1.15831e+07 0.912322 ns
clickbench_q02/DataFusion:vortex-compact 29117352 2.86634e+07 1.01584 ns
clickbench_q03/DataFusion:vortex-compact 29525421 3.16305e+07 0.933447 ns
clickbench_q04/DataFusion:vortex-compact 311640051 3.13488e+08 0.994105 ns
clickbench_q05/DataFusion:vortex-compact 323632380 3.34857e+08 0.966479 ns
clickbench_q06/DataFusion:vortex-compact 1742230 1.77555e+06 0.981232 ns
clickbench_q07/DataFusion:vortex-compact 15786638 1.55553e+07 1.01487 ns
clickbench_q08/DataFusion:vortex-compact 377301701 3.90526e+08 0.966137 ns
clickbench_q09/DataFusion:vortex-compact 553615447 5.60854e+08 0.987094 ns
clickbench_q10/DataFusion:vortex-compact 67855334 7.26553e+07 0.933934 ns
clickbench_q11/DataFusion:vortex-compact 79870600 8.29004e+07 0.963452 ns
clickbench_q12/DataFusion:vortex-compact 269584333 2.73608e+08 0.985296 ns
clickbench_q13/DataFusion:vortex-compact 443041870 4.47312e+08 0.990454 ns
clickbench_q14/DataFusion:vortex-compact 248890325 2.58482e+08 0.962894 ns
clickbench_q15/DataFusion:vortex-compact 367031919 3.71064e+08 0.989133 ns
clickbench_q16/DataFusion:vortex-compact 758458238 7.71285e+08 0.98337 ns
clickbench_q17/DataFusion:vortex-compact 752004105 7.64083e+08 0.984191 ns
clickbench_q18/DataFusion:vortex-compact 1404887369 1.43306e+09 0.980338 ns
clickbench_q19/DataFusion:vortex-compact 17836404 1.8467e+07 0.965852 ns
clickbench_q20/DataFusion:vortex-compact 280222901 2.7399e+08 1.02275 ns
clickbench_q21/DataFusion:vortex-compact 346216512 3.44907e+08 1.0038 ns
clickbench_q22/DataFusion:vortex-compact 672722947 6.78967e+08 0.990804 ns
clickbench_q23/DataFusion:vortex-compact 1858853158 1.92119e+09 0.967555 ns
clickbench_q24/DataFusion:vortex-compact 74654699 7.58751e+07 0.983916 ns
clickbench_q25/DataFusion:vortex-compact 61174341 6.02295e+07 1.01569 ns
clickbench_q26/DataFusion:vortex-compact 76890950 7.49894e+07 1.02536 ns
clickbench_q27/DataFusion:vortex-compact 762149736 7.64608e+08 0.996785 ns
clickbench_q28/DataFusion:vortex-compact 6725632460 6.8431e+09 0.982835 ns
clickbench_q29/DataFusion:vortex-compact 245600158 2.39804e+08 1.02417 ns
clickbench_q30/DataFusion:vortex-compact 249955314 2.56767e+08 0.973471 ns
clickbench_q31/DataFusion:vortex-compact 292969328 2.97106e+08 0.986075 ns
clickbench_q32/DataFusion:vortex-compact 1243196530 1.26555e+09 0.982335 ns
clickbench_q33/DataFusion:vortex-compact 1405843483 1.44479e+09 0.973042 ns
clickbench_q34/DataFusion:vortex-compact 1418465691 1.43839e+09 0.986145 ns
clickbench_q35/DataFusion:vortex-compact 541211719 5.56926e+08 0.971785 ns
clickbench_q36/DataFusion:vortex-compact 79134554 8.26052e+07 0.957986 ns
clickbench_q37/DataFusion:vortex-compact 37105188 3.75855e+07 0.987221 ns
clickbench_q38/DataFusion:vortex-compact 19851637 1.94522e+07 1.02054 ns
clickbench_q39/DataFusion:vortex-compact 162307950 1.59978e+08 1.01456 ns
clickbench_q40/DataFusion:vortex-compact 17239521 1.77356e+07 0.972027 ns
clickbench_q41/DataFusion:vortex-compact 16514481 1.74816e+07 0.944677 ns
clickbench_q42/DataFusion:vortex-compact 19721357 1.95074e+07 1.01097 ns
clickbench_q00/DuckDB:parquet 123456920 1.23453e+08 1.00003 ns
clickbench_q00/DuckDB:parquet 123456920 1.21754e+08 1.01399 ns
clickbench_q01/DuckDB:parquet 49335705 5.02371e+07 0.982057 ns
clickbench_q01/DuckDB:parquet 49335705 4.99164e+07 0.988367 ns
clickbench_q02/DuckDB:parquet 62983341 6.36485e+07 0.989549 ns
clickbench_q02/DuckDB:parquet 62983341 6.2848e+07 1.00215 ns
clickbench_q03/DuckDB:parquet 60934030 6.20006e+07 0.982797 ns
clickbench_q03/DuckDB:parquet 60934030 6.16728e+07 0.988021 ns
clickbench_q04/DuckDB:parquet 199603147 2.00622e+08 0.99492 ns
clickbench_q04/DuckDB:parquet 199603147 2.00501e+08 0.995524 ns
clickbench_q05/DuckDB:parquet 266160726 2.67327e+08 0.995639 ns
clickbench_q05/DuckDB:parquet 266160726 2.69139e+08 0.988934 ns
clickbench_q06/DuckDB:parquet 59179126 5.98433e+07 0.988901 ns
clickbench_q06/DuckDB:parquet 59179126 5.96387e+07 0.992294 ns
clickbench_q07/DuckDB:parquet 53664262 5.37755e+07 0.997931 ns
clickbench_q07/DuckDB:parquet 53664262 5.48154e+07 0.979 ns
clickbench_q08/DuckDB:parquet 263078678 2.63792e+08 0.997297 ns
clickbench_q08/DuckDB:parquet 263078678 2.65066e+08 0.992503 ns
clickbench_q09/DuckDB:parquet 387847315 3.89981e+08 0.994529 ns
clickbench_q09/DuckDB:parquet 387847315 3.89772e+08 0.995061 ns
clickbench_q10/DuckDB:parquet 92325748 9.28919e+07 0.993905 ns
clickbench_q10/DuckDB:parquet 92325748 9.44056e+07 0.977969 ns
clickbench_q11/DuckDB:parquet 101799661 1.03955e+08 0.979265 ns
clickbench_q11/DuckDB:parquet 101799661 1.07478e+08 0.947172 ns
clickbench_q12/DuckDB:parquet 286374296 2.86584e+08 0.999268 ns
clickbench_q12/DuckDB:parquet 286374296 2.84861e+08 1.00531 ns
clickbench_q13/DuckDB:parquet 469538436 4.71762e+08 0.995286 ns
clickbench_q13/DuckDB:parquet 469538436 4.72288e+08 0.994178 ns
clickbench_q14/DuckDB:parquet 319273503 3.21138e+08 0.994195 ns
clickbench_q14/DuckDB:parquet 319273503 3.19646e+08 0.998834 ns
clickbench_q15/DuckDB:parquet 234852203 2.38709e+08 0.983844 ns
clickbench_q15/DuckDB:parquet 234852203 2.37042e+08 0.99076 ns
clickbench_q16/DuckDB:parquet 566324210 5.66441e+08 0.999794 ns
clickbench_q16/DuckDB:parquet 566324210 5.66225e+08 1.00018 ns
clickbench_q17/DuckDB:parquet 474146302 4.75936e+08 0.99624 ns
clickbench_q17/DuckDB:parquet 474146302 4.77295e+08 0.993403 ns
clickbench_q18/DuckDB:parquet 973133566 9.79807e+08 0.993189 ns
clickbench_q18/DuckDB:parquet 973133566 9.8431e+08 0.988645 ns
clickbench_q19/DuckDB:parquet 47626836 4.72347e+07 1.0083 ns
clickbench_q19/DuckDB:parquet 47626836 4.73317e+07 1.00623 ns
clickbench_q20/DuckDB:parquet 401391836 4.06235e+08 0.988078 ns
clickbench_q20/DuckDB:parquet 401391836 4.0227e+08 0.997816 ns
clickbench_q21/DuckDB:parquet 521681396 5.17985e+08 1.00714 ns
clickbench_q21/DuckDB:parquet 521681396 5.17873e+08 1.00735 ns
clickbench_q22/DuckDB:parquet 894237414 8.98193e+08 0.995596 ns
clickbench_q22/DuckDB:parquet 894237414 9.03158e+08 0.990123 ns
clickbench_q23/DuckDB:parquet 271868834 2.79824e+08 0.97157 ns
clickbench_q23/DuckDB:parquet 271868834 2.78556e+08 0.975992 ns
clickbench_q24/DuckDB:parquet 79805623 7.77273e+07 1.02674 ns
clickbench_q24/DuckDB:parquet 79805623 7.81166e+07 1.02162 ns
clickbench_q25/DuckDB:parquet 138076857 1.37873e+08 1.00148 ns
clickbench_q25/DuckDB:parquet 138076857 1.36961e+08 1.00815 ns
clickbench_q26/DuckDB:parquet 52836151 5.2334e+07 1.0096 ns
clickbench_q26/DuckDB:parquet 52836151 5.20485e+07 1.01513 ns
clickbench_q27/DuckDB:parquet 613666007 6.12863e+08 1.00131 ns
clickbench_q27/DuckDB:parquet 613666007 6.11186e+08 1.00406 ns
clickbench_q28/DuckDB:parquet 4802051600 4.90138e+09 0.979735 ns
clickbench_q28/DuckDB:parquet 4802051600 4.79913e+09 1.00061 ns
clickbench_q29/DuckDB:parquet 60332971 6.08773e+07 0.991059 ns
clickbench_q29/DuckDB:parquet 60332971 6.01712e+07 1.00269 ns
clickbench_q30/DuckDB:parquet 304150016 3.06903e+08 0.99103 ns
clickbench_q30/DuckDB:parquet 304150016 3.03555e+08 1.00196 ns
clickbench_q31/DuckDB:parquet 344924391 3.45724e+08 0.997686 ns
clickbench_q31/DuckDB:parquet 344924391 3.43857e+08 1.0031 ns
clickbench_q32/DuckDB:parquet 1027230003 1.02839e+09 0.99887 ns
clickbench_q32/DuckDB:parquet 1027230003 1.03065e+09 0.996682 ns
clickbench_q33/DuckDB:parquet 1046025873 1.06314e+09 0.983902 ns
clickbench_q33/DuckDB:parquet 1046025873 1.05171e+09 0.994593 ns
clickbench_q34/DuckDB:parquet 1098011081 1.10522e+09 0.993475 ns
clickbench_q34/DuckDB:parquet 1098011081 1.0964e+09 1.00147 ns
clickbench_q35/DuckDB:parquet 346120347 3.46268e+08 0.999573 ns
clickbench_q35/DuckDB:parquet 346120347 3.46571e+08 0.998699 ns
clickbench_q36/DuckDB:parquet 60569853 6.01304e+07 1.00731 ns
clickbench_q36/DuckDB:parquet 60569853 6.1226e+07 0.989283 ns
clickbench_q37/DuckDB:parquet 47829498 5.05656e+07 0.945889 ns
clickbench_q37/DuckDB:parquet 47829498 4.9299e+07 0.970191 ns
clickbench_q38/DuckDB:parquet 50854284 5.19972e+07 0.978019 ns
clickbench_q38/DuckDB:parquet 50854284 5.06096e+07 1.00484 ns
clickbench_q39/DuckDB:parquet 91773631 9.35239e+07 0.981286 ns
clickbench_q39/DuckDB:parquet 91773631 9.26519e+07 0.990521 ns
clickbench_q40/DuckDB:parquet 52450897 5.29079e+07 0.991362 ns
clickbench_q40/DuckDB:parquet 52450897 5.33755e+07 0.982678 ns
clickbench_q41/DuckDB:parquet 54861318 5.63336e+07 0.973866 ns
clickbench_q41/DuckDB:parquet 54861318 5.5681e+07 0.985279 ns
clickbench_q42/DuckDB:parquet 41139071 4.37752e+07 0.939781 ns
clickbench_q42/DuckDB:parquet 41139071 4.23048e+07 0.972445 ns
clickbench_q00/DuckDB:vortex-file-compressed 11580807 1.11563e+07 1.03805 ns
clickbench_q00/DuckDB:vortex-file-compressed 11580807 1.1157e+07 1.03798 ns
clickbench_q01/DuckDB:vortex-file-compressed 18443559 1.87065e+07 0.985944 ns
clickbench_q01/DuckDB:vortex-file-compressed 18443559 1.79339e+07 1.02842 ns
clickbench_q02/DuckDB:vortex-file-compressed 29788505 3.00849e+07 0.990149 ns
clickbench_q02/DuckDB:vortex-file-compressed 29788505 2.99049e+07 0.996109 ns
clickbench_q03/DuckDB:vortex-file-compressed 33357946 3.75458e+07 0.88846 ns
clickbench_q03/DuckDB:vortex-file-compressed 33357946 3.39386e+07 0.98289 ns
clickbench_q04/DuckDB:vortex-file-compressed 173433411 1.705e+08 1.0172 ns
clickbench_q04/DuckDB:vortex-file-compressed 173433411 1.70122e+08 1.01947 ns
clickbench_q05/DuckDB:vortex-file-compressed 193265978 1.93072e+08 1.001 ns
clickbench_q05/DuckDB:vortex-file-compressed 193265978 1.91191e+08 1.01085 ns
clickbench_q06/DuckDB:vortex-file-compressed 32831461 3.3483e+07 0.980542 ns
clickbench_q06/DuckDB:vortex-file-compressed 32831461 3.4787e+07 0.943786 ns
clickbench_q07/DuckDB:vortex-file-compressed 21040865 2.16489e+07 0.971913 ns
clickbench_q07/DuckDB:vortex-file-compressed 21040865 2.1891e+07 0.961163 ns
clickbench_q08/DuckDB:vortex-file-compressed 261796891 2.65675e+08 0.985402 ns
clickbench_q08/DuckDB:vortex-file-compressed 261796891 2.6234e+08 0.99793 ns
clickbench_q09/DuckDB:vortex-file-compressed 347256691 3.5021e+08 0.991567 ns
clickbench_q09/DuckDB:vortex-file-compressed 347256691 3.45695e+08 1.00452 ns
clickbench_q10/DuckDB:vortex-file-compressed 72993030 7.25595e+07 1.00597 ns
clickbench_q10/DuckDB:vortex-file-compressed 72993030 7.25468e+07 1.00615 ns
clickbench_q11/DuckDB:vortex-file-compressed 82939574 8.29422e+07 0.999968 ns
clickbench_q11/DuckDB:vortex-file-compressed 82939574 8.24546e+07 1.00588 ns
clickbench_q12/DuckDB:vortex-file-compressed 208234946 2.03699e+08 1.02227 ns
clickbench_q12/DuckDB:vortex-file-compressed 208234946 2.04744e+08 1.01705 ns
clickbench_q13/DuckDB:vortex-file-compressed 463293232 4.63905e+08 0.99868 ns
clickbench_q13/DuckDB:vortex-file-compressed 463293232 4.66342e+08 0.993463 ns
clickbench_q14/DuckDB:vortex-file-compressed 291131732 2.94165e+08 0.989689 ns
clickbench_q14/DuckDB:vortex-file-compressed 291131732 2.92733e+08 0.994529 ns
clickbench_q15/DuckDB:vortex-file-compressed 212727340 2.1082e+08 1.00905 ns
clickbench_q15/DuckDB:vortex-file-compressed 212727340 2.10223e+08 1.01191 ns
clickbench_q16/DuckDB:vortex-file-compressed 933951152 9.31493e+08 1.00264 ns
clickbench_q16/DuckDB:vortex-file-compressed 933951152 9.45686e+08 0.987591 ns
clickbench_q17/DuckDB:vortex-file-compressed 849889799 8.50597e+08 0.999168 ns
clickbench_q17/DuckDB:vortex-file-compressed 849889799 8.5338e+08 0.99591 ns
clickbench_q18/DuckDB:vortex-file-compressed 1468153652 1.42877e+09 1.02756 ns
clickbench_q18/DuckDB:vortex-file-compressed 1468153652 1.4863e+09 0.987788 ns
clickbench_q19/DuckDB:vortex-file-compressed 25626874 2.59316e+07 0.988248 ns
clickbench_q19/DuckDB:vortex-file-compressed 25626874 2.57591e+07 0.994867 ns
clickbench_q20/DuckDB:vortex-file-compressed 394801725 3.87866e+08 1.01788 ns
clickbench_q20/DuckDB:vortex-file-compressed 394801725 3.84725e+08 1.02619 ns
clickbench_q21/DuckDB:vortex-file-compressed 337132939 3.19917e+08 1.05381 ns
clickbench_q21/DuckDB:vortex-file-compressed 337132939 3.19747e+08 1.05438 ns
clickbench_q22/DuckDB:vortex-file-compressed 642823399 6.18405e+08 1.03949 ns
clickbench_q22/DuckDB:vortex-file-compressed 642823399 6.22896e+08 1.03199 ns
clickbench_q23/DuckDB:vortex-file-compressed 1074502894 4.98176e+08 2.15688 ns 🚨
clickbench_q23/DuckDB:vortex-file-compressed 1074502894 1.09568e+09 0.980675 ns
clickbench_q24/DuckDB:vortex-file-compressed 44273195 3.58927e+07 1.23349 ns
clickbench_q24/DuckDB:vortex-file-compressed 44273195 3.8789e+07 1.14139 ns
clickbench_q25/DuckDB:vortex-file-compressed 67436346 6.54839e+07 1.02982 ns
clickbench_q25/DuckDB:vortex-file-compressed 67436346 6.55495e+07 1.02879 ns
clickbench_q26/DuckDB:vortex-file-compressed 42010920 3.72505e+07 1.12779 ns
clickbench_q26/DuckDB:vortex-file-compressed 42010920 4.10612e+07 1.02313 ns
clickbench_q27/DuckDB:vortex-file-compressed 445660502 4.67191e+08 0.953914 ns
clickbench_q27/DuckDB:vortex-file-compressed 445660502 4.23654e+08 1.05194 ns
clickbench_q28/DuckDB:vortex-file-compressed 3057868567 3.09633e+09 0.987579 ns
clickbench_q28/DuckDB:vortex-file-compressed 3057868567 3.09011e+09 0.989566 ns
clickbench_q29/DuckDB:vortex-file-compressed 32758901 3.31922e+07 0.986946 ns
clickbench_q29/DuckDB:vortex-file-compressed 32758901 3.35746e+07 0.975704 ns
clickbench_q30/DuckDB:vortex-file-compressed 187004787 1.82467e+08 1.02487 ns
clickbench_q30/DuckDB:vortex-file-compressed 187004787 1.83893e+08 1.01692 ns
clickbench_q31/DuckDB:vortex-file-compressed 247338992 2.44971e+08 1.00967 ns
clickbench_q31/DuckDB:vortex-file-compressed 247338992 2.48676e+08 0.994624 ns
clickbench_q32/DuckDB:vortex-file-compressed 1040622301 1.04477e+09 0.996027 ns
clickbench_q32/DuckDB:vortex-file-compressed 1040622301 1.05873e+09 0.982894 ns
clickbench_q33/DuckDB:vortex-file-compressed 1001388886 1.01939e+09 0.982339 ns
clickbench_q33/DuckDB:vortex-file-compressed 1001388886 1.01156e+09 0.989941 ns
clickbench_q34/DuckDB:vortex-file-compressed 1471549936 1.5175e+09 0.969717 ns
clickbench_q34/DuckDB:vortex-file-compressed 1471549936 1.53148e+09 0.960868 ns
clickbench_q35/DuckDB:vortex-file-compressed 357320185 3.62672e+08 0.985242 ns
clickbench_q35/DuckDB:vortex-file-compressed 357320185 3.62681e+08 0.985218 ns
clickbench_q36/DuckDB:vortex-file-compressed 25484274 2.47204e+07 1.0309 ns
clickbench_q36/DuckDB:vortex-file-compressed 25484274 2.50878e+07 1.0158 ns
clickbench_q37/DuckDB:vortex-file-compressed 16553185 1.57694e+07 1.0497 ns
clickbench_q37/DuckDB:vortex-file-compressed 16553185 1.64589e+07 1.00573 ns
clickbench_q38/DuckDB:vortex-file-compressed 17939146 1.75616e+07 1.0215 ns
clickbench_q38/DuckDB:vortex-file-compressed 17939146 1.7806e+07 1.00748 ns
clickbench_q39/DuckDB:vortex-file-compressed 42852236 4.39773e+07 0.974418 ns
clickbench_q39/DuckDB:vortex-file-compressed 42852236 4.53223e+07 0.945501 ns
clickbench_q40/DuckDB:vortex-file-compressed 15489642 1.6008e+07 0.967619 ns
clickbench_q40/DuckDB:vortex-file-compressed 15489642 1.70983e+07 0.905916 ns
clickbench_q41/DuckDB:vortex-file-compressed 16679540 1.63318e+07 1.02129 ns
clickbench_q41/DuckDB:vortex-file-compressed 16679540 1.75211e+07 0.951969 ns
clickbench_q42/DuckDB:vortex-file-compressed 18524454 1.89165e+07 0.979277 ns
clickbench_q42/DuckDB:vortex-file-compressed 18524454 1.90339e+07 0.973234 ns
clickbench_q00/DuckDB:vortex-compact 10531097 1.03038e+07 1.02206 ns
clickbench_q01/DuckDB:vortex-compact 40645259 4.01392e+07 1.01261 ns
clickbench_q02/DuckDB:vortex-compact 49052066 4.93595e+07 0.993771 ns
clickbench_q03/DuckDB:vortex-compact 45864970 4.63163e+07 0.990255 ns
clickbench_q04/DuckDB:vortex-compact 212799646 2.11844e+08 1.00451 ns
clickbench_q05/DuckDB:vortex-compact 230214810 2.32173e+08 0.991566 ns
clickbench_q06/DuckDB:vortex-compact 35576119 3.61488e+07 0.984159 ns
clickbench_q07/DuckDB:vortex-compact 55773553 5.56929e+07 1.00145 ns
clickbench_q08/DuckDB:vortex-compact 286443339 2.87939e+08 0.994805 ns
clickbench_q09/DuckDB:vortex-compact 413999082 4.14373e+08 0.999098 ns
clickbench_q10/DuckDB:vortex-compact 128808368 1.27071e+08 1.01368 ns
clickbench_q11/DuckDB:vortex-compact 151225379 1.52041e+08 0.994635 ns
clickbench_q12/DuckDB:vortex-compact 317526047 3.17581e+08 0.999827 ns
clickbench_q13/DuckDB:vortex-compact 585832702 5.87682e+08 0.996853 ns
clickbench_q14/DuckDB:vortex-compact 412397849 4.18228e+08 0.986059 ns
clickbench_q15/DuckDB:vortex-compact 251369499 2.52682e+08 0.994804 ns
clickbench_q16/DuckDB:vortex-compact 1029674514 1.0258e+09 1.00378 ns
clickbench_q17/DuckDB:vortex-compact 917715321 9.34784e+08 0.981741 ns
clickbench_q18/DuckDB:vortex-compact 1519627660 1.55238e+09 0.978904 ns
clickbench_q19/DuckDB:vortex-compact 28963640 2.97415e+07 0.973847 ns
clickbench_q20/DuckDB:vortex-compact 543292164 5.23732e+08 1.03735 ns
clickbench_q21/DuckDB:vortex-compact 503221220 4.77131e+08 1.05468 ns
clickbench_q22/DuckDB:vortex-compact 997671541 9.75186e+08 1.02306 ns
clickbench_q23/DuckDB:vortex-compact 709938681 8.68013e+08 0.817889 ns
clickbench_q24/DuckDB:vortex-compact 77124443 9.12545e+07 0.845158 ns
clickbench_q25/DuckDB:vortex-compact 179530409 1.77605e+08 1.01084 ns
clickbench_q26/DuckDB:vortex-compact 100926912 9.62222e+07 1.04889 ns
clickbench_q27/DuckDB:vortex-compact 818659483 8.01981e+08 1.0208 ns
clickbench_q28/DuckDB:vortex-compact 3385326628 3.38048e+09 1.00143 ns
clickbench_q29/DuckDB:vortex-compact 41997053 4.18412e+07 1.00373 ns
clickbench_q30/DuckDB:vortex-compact 291364945 2.93603e+08 0.992378 ns
clickbench_q31/DuckDB:vortex-compact 341018476 3.45302e+08 0.987595 ns
clickbench_q32/DuckDB:vortex-compact 1068174650 1.089e+09 0.980876 ns
clickbench_q33/DuckDB:vortex-compact 1071575758 1.0834e+09 0.989083 ns
clickbench_q34/DuckDB:vortex-compact 1586242519 1.59276e+09 0.99591 ns
clickbench_q35/DuckDB:vortex-compact 360749704 3.61118e+08 0.998981 ns
clickbench_q36/DuckDB:vortex-compact 31285427 3.14047e+07 0.996204 ns
clickbench_q37/DuckDB:vortex-compact 22754853 2.26694e+07 1.00377 ns
clickbench_q38/DuckDB:vortex-compact 22417224 2.25159e+07 0.995619 ns
clickbench_q39/DuckDB:vortex-compact 49874490 5.13273e+07 0.971695 ns
clickbench_q40/DuckDB:vortex-compact 25168090 2.74133e+07 0.918099 ns
clickbench_q41/DuckDB:vortex-compact 23117730 2.34392e+07 0.986286 ns
clickbench_q42/DuckDB:vortex-compact 21633035 2.1324e+07 1.01449 ns
clickbench_q00/DuckDB:duckdb 18105494 1.80888e+07 1.00092 ns
clickbench_q00/DuckDB:duckdb 18105494 1.82303e+07 0.993156 ns
clickbench_q01/DuckDB:duckdb 36245712 3.73464e+07 0.970529 ns
clickbench_q01/DuckDB:duckdb 36245712 3.66209e+07 0.989756 ns
clickbench_q02/DuckDB:duckdb 45942193 4.6533e+07 0.987304 ns
clickbench_q02/DuckDB:duckdb 45942193 4.57577e+07 1.00403 ns
clickbench_q03/DuckDB:duckdb 47285983 4.78871e+07 0.987448 ns
clickbench_q03/DuckDB:duckdb 47285983 4.76051e+07 0.993298 ns
clickbench_q04/DuckDB:duckdb 187236085 1.89137e+08 0.989949 ns
clickbench_q04/DuckDB:duckdb 187236085 1.89271e+08 0.989248 ns
clickbench_q05/DuckDB:duckdb 295842686 2.98368e+08 0.991536 ns
clickbench_q05/DuckDB:duckdb 295842686 2.99087e+08 0.989153 ns
clickbench_q06/DuckDB:duckdb 35161985 3.60374e+07 0.975708 ns
clickbench_q06/DuckDB:duckdb 35161985 3.53849e+07 0.993701 ns
clickbench_q07/DuckDB:duckdb 37785152 3.80258e+07 0.993673 ns
clickbench_q07/DuckDB:duckdb 37785152 3.79923e+07 0.994547 ns
clickbench_q08/DuckDB:duckdb 247132318 2.5081e+08 0.985336 ns
clickbench_q08/DuckDB:duckdb 247132318 2.49682e+08 0.989789 ns
clickbench_q09/DuckDB:duckdb 361969472 3.63648e+08 0.995385 ns
clickbench_q09/DuckDB:duckdb 361969472 3.64708e+08 0.992492 ns
clickbench_q10/DuckDB:duckdb 109315309 1.10295e+08 0.991121 ns
clickbench_q10/DuckDB:duckdb 109315309 1.11654e+08 0.979053 ns
clickbench_q11/DuckDB:duckdb 120769245 1.22156e+08 0.988648 ns
clickbench_q11/DuckDB:duckdb 120769245 1.19232e+08 1.01289 ns
clickbench_q12/DuckDB:duckdb 264743194 2.6849e+08 0.986046 ns
clickbench_q12/DuckDB:duckdb 264743194 2.67617e+08 0.989262 ns
clickbench_q13/DuckDB:duckdb 443707373 4.50244e+08 0.985482 ns
clickbench_q13/DuckDB:duckdb 443707373 4.47832e+08 0.99079 ns
clickbench_q14/DuckDB:duckdb 290292843 2.90175e+08 1.00041 ns
clickbench_q14/DuckDB:duckdb 290292843 2.91631e+08 0.995411 ns
clickbench_q15/DuckDB:duckdb 218098046 2.20603e+08 0.988644 ns
clickbench_q15/DuckDB:duckdb 218098046 2.20418e+08 0.989474 ns
clickbench_q16/DuckDB:duckdb 537819337 5.46354e+08 0.98438 ns
clickbench_q16/DuckDB:duckdb 537819337 5.45651e+08 0.985648 ns
clickbench_q17/DuckDB:duckdb 454805136 4.61943e+08 0.984547 ns
clickbench_q17/DuckDB:duckdb 454805136 4.58953e+08 0.990961 ns
clickbench_q18/DuckDB:duckdb 941883770 9.50903e+08 0.990515 ns
clickbench_q18/DuckDB:duckdb 941883770 9.49873e+08 0.991589 ns
clickbench_q19/DuckDB:duckdb 36762848 3.67523e+07 1.00029 ns
clickbench_q19/DuckDB:duckdb 36762848 3.67138e+07 1.00134 ns
clickbench_q20/DuckDB:duckdb 451445152 4.49137e+08 1.00514 ns
clickbench_q20/DuckDB:duckdb 451445152 4.51189e+08 1.00057 ns
clickbench_q21/DuckDB:duckdb 474410421 4.75586e+08 0.997528 ns
clickbench_q21/DuckDB:duckdb 474410421 4.74544e+08 0.999719 ns
clickbench_q22/DuckDB:duckdb 523657707 5.27021e+08 0.993618 ns
clickbench_q22/DuckDB:duckdb 523657707 5.40727e+08 0.968433 ns
clickbench_q23/DuckDB:duckdb 221028735 2.28036e+08 0.96927 ns
clickbench_q23/DuckDB:duckdb 221028735 2.25692e+08 0.979337 ns
clickbench_q24/DuckDB:duckdb 48141393 4.78412e+07 1.00627 ns
clickbench_q24/DuckDB:duckdb 48141393 4.82996e+07 0.996724 ns
clickbench_q25/DuckDB:duckdb 110626578 1.11089e+08 0.995835 ns
clickbench_q25/DuckDB:duckdb 110626578 1.10533e+08 1.00084 ns
clickbench_q26/DuckDB:duckdb 46782868 4.58264e+07 1.02087 ns
clickbench_q26/DuckDB:duckdb 46782868 4.69698e+07 0.99602 ns
clickbench_q27/DuckDB:duckdb 526790643 5.26985e+08 0.999632 ns
clickbench_q27/DuckDB:duckdb 526790643 5.2487e+08 1.00366 ns
clickbench_q28/DuckDB:duckdb 4412673361 4.49171e+09 0.982405 ns
clickbench_q28/DuckDB:duckdb 4412673361 4.41994e+09 0.998357 ns
clickbench_q29/DuckDB:duckdb 49562565 4.99979e+07 0.991293 ns
clickbench_q29/DuckDB:duckdb 49562565 4.97083e+07 0.997068 ns
clickbench_q30/DuckDB:duckdb 269337187 2.70498e+08 0.99571 ns
clickbench_q30/DuckDB:duckdb 269337187 2.69832e+08 0.998166 ns
clickbench_q31/DuckDB:duckdb 335633427 3.37175e+08 0.995427 ns
clickbench_q31/DuckDB:duckdb 335633427 3.38295e+08 0.992131 ns
clickbench_q32/DuckDB:duckdb 1004339508 1.02411e+09 0.980696 ns
clickbench_q32/DuckDB:duckdb 1004339508 1.02156e+09 0.983144 ns
clickbench_q33/DuckDB:duckdb 1073100700 1.07881e+09 0.994703 ns
clickbench_q33/DuckDB:duckdb 1073100700 1.07945e+09 0.994117 ns
clickbench_q34/DuckDB:duckdb 1137307817 1.14319e+09 0.994857 ns
clickbench_q34/DuckDB:duckdb 1137307817 1.14825e+09 0.990472 ns
clickbench_q35/DuckDB:duckdb 262786867 2.65628e+08 0.989305 ns
clickbench_q35/DuckDB:duckdb 262786867 2.64096e+08 0.995041 ns
clickbench_q36/DuckDB:duckdb 44422270 4.40973e+07 1.00737 ns
clickbench_q36/DuckDB:duckdb 44422270 4.49254e+07 0.988801 ns
clickbench_q37/DuckDB:duckdb 31966606 3.20996e+07 0.995856 ns
clickbench_q37/DuckDB:duckdb 31966606 3.18287e+07 1.00433 ns
clickbench_q38/DuckDB:duckdb 33436026 3.36563e+07 0.993454 ns
clickbench_q38/DuckDB:duckdb 33436026 3.37296e+07 0.991296 ns
clickbench_q39/DuckDB:duckdb 71879432 7.13994e+07 1.00672 ns
clickbench_q39/DuckDB:duckdb 71879432 7.16765e+07 1.00283 ns
clickbench_q40/DuckDB:duckdb 31805303 3.22765e+07 0.985401 ns
clickbench_q40/DuckDB:duckdb 31805303 3.23636e+07 0.982749 ns
clickbench_q41/DuckDB:duckdb 32552198 3.30805e+07 0.98403 ns
clickbench_q41/DuckDB:duckdb 32552198 3.28636e+07 0.990525 ns
clickbench_q42/DuckDB:duckdb 31819389 3.21003e+07 0.99125 ns
clickbench_q42/DuckDB:duckdb 31819389 3.21382e+07 0.99008 ns

github-actions[bot] avatar Sep 08 '25 20:09 github-actions[bot]

Benchmarks: TPC-DS SF=1 on NVME

Summary

  • Overall: 1.002x ➖
  • Vortex: 1.004x ➖
  • duckdb:vortex: 1.002x ➖
  • datafusion:vortex: 1.006x ➖
  • Best: tpcds_q44/DataFusion:vortex-compact (0.918x)
  • Worst: tpcds_q62/DuckDB:vortex-file-compressed (1.100x)
  • Significant (>10%): 0↑ 0↓
Detailed Results Table
name PR 44465167 base 4181e121 ratio (PR/base) unit remark
tpcds_q01/DataFusion:parquet 38296943 3.85837e+07 0.992568 ns
tpcds_q02/DataFusion:parquet 42588229 4.22857e+07 1.00716 ns
tpcds_q03/DataFusion:parquet 18980716 1.86539e+07 1.01752 ns
tpcds_q04/DataFusion:parquet 334772719 3.3872e+08 0.988346 ns
tpcds_q05/DataFusion:parquet 40443739 3.83428e+07 1.05479 ns
tpcds_q06/DataFusion:parquet 63610136 6.26323e+07 1.01561 ns
tpcds_q07/DataFusion:parquet 102506535 1.05635e+08 0.97038 ns
tpcds_q08/DataFusion:parquet 65905004 6.54708e+07 1.00663 ns
tpcds_q09/DataFusion:parquet 48075970 4.8393e+07 0.993448 ns
tpcds_q10/DataFusion:parquet 99823377 1.02629e+08 0.972661 ns
tpcds_q11/DataFusion:parquet 223722950 2.26763e+08 0.986593 ns
tpcds_q12/DataFusion:parquet 30187694 2.6631e+07 1.13355 ns
tpcds_q13/DataFusion:parquet 102714680 1.05085e+08 0.977444 ns
tpcds_q14/DataFusion:parquet 287481241 2.85669e+08 1.00634 ns
tpcds_q15/DataFusion:parquet 29772799 3.0018e+07 0.991831 ns
tpcds_q16/DataFusion:parquet 40026730 3.84799e+07 1.0402 ns
tpcds_q17/DataFusion:parquet 103032465 1.03211e+08 0.998275 ns
tpcds_q18/DataFusion:parquet 127549739 1.26964e+08 1.00461 ns
tpcds_q19/DataFusion:parquet 34255275 3.44476e+07 0.994417 ns
tpcds_q20/DataFusion:parquet 25496986 2.49343e+07 1.02257 ns
tpcds_q21/DataFusion:parquet 32112517 2.99142e+07 1.07349 ns
tpcds_q22/DataFusion:parquet 71129094 6.9159e+07 1.02849 ns
tpcds_q23/DataFusion:parquet 239328938 2.35934e+08 1.01439 ns
tpcds_q24/DataFusion:parquet 140044557 1.37707e+08 1.01698 ns
tpcds_q25/DataFusion:parquet 102729694 1.02243e+08 1.00476 ns
tpcds_q26/DataFusion:parquet 94157743 9.75933e+07 0.964797 ns
tpcds_q27/DataFusion:parquet 200512930 1.98479e+08 1.01025 ns
tpcds_q28/DataFusion:parquet 44381266 4.40699e+07 1.00707 ns
tpcds_q29/DataFusion:parquet 103083743 1.06457e+08 0.968317 ns
tpcds_q30/DataFusion:parquet 48371445 4.95802e+07 0.97562 ns
tpcds_q31/DataFusion:parquet 106980616 1.06013e+08 1.00913 ns
tpcds_q32/DataFusion:parquet 21929243 2.30012e+07 0.953397 ns
tpcds_q33/DataFusion:parquet 38100152 3.7267e+07 1.02236 ns
tpcds_q34/DataFusion:parquet 35983256 3.70179e+07 0.972051 ns
tpcds_q35/DataFusion:parquet 103402661 1.02544e+08 1.00838 ns
tpcds_q36/DataFusion:parquet 91937637 9.65051e+07 0.952671 ns
tpcds_q37/DataFusion:parquet 26410489 2.6839e+07 0.984032 ns
tpcds_q38/DataFusion:parquet 57707936 5.93768e+07 0.971894 ns
tpcds_q39/DataFusion:parquet 70020833 7.01027e+07 0.998833 ns
tpcds_q40/DataFusion:parquet 32504260 3.4404e+07 0.944782 ns
tpcds_q41/DataFusion:parquet 11909512 1.15593e+07 1.0303 ns
tpcds_q42/DataFusion:parquet 19061809 1.95378e+07 0.97564 ns
tpcds_q43/DataFusion:parquet 23409523 2.36021e+07 0.991842 ns
tpcds_q44/DataFusion:parquet 59113920 5.89236e+07 1.00323 ns
tpcds_q45/DataFusion:parquet 48485101 4.68768e+07 1.03431 ns
tpcds_q46/DataFusion:parquet 51300453 5.82932e+07 0.880042 ns
tpcds_q47/DataFusion:parquet 221223809 2.20215e+08 1.00458 ns
tpcds_q48/DataFusion:parquet 92394102 9.20659e+07 1.00357 ns
tpcds_q49/DataFusion:parquet 60750079 6.10402e+07 0.995247 ns
tpcds_q50/DataFusion:parquet 69317741 7.18786e+07 0.964372 ns
tpcds_q51/DataFusion:parquet 108052869 1.08631e+08 0.99468 ns
tpcds_q52/DataFusion:parquet 19898789 2.07618e+07 0.958433 ns
tpcds_q53/DataFusion:parquet 33577458 3.10928e+07 1.07991 ns
tpcds_q54/DataFusion:parquet 42223357 4.29735e+07 0.982544 ns
tpcds_q55/DataFusion:parquet 19129179 1.95916e+07 0.976397 ns
tpcds_q56/DataFusion:parquet 41740592 4.06204e+07 1.02758 ns
tpcds_q57/DataFusion:parquet 135213436 1.36355e+08 0.991628 ns
tpcds_q58/DataFusion:parquet 111124539 1.12886e+08 0.984396 ns
tpcds_q59/DataFusion:parquet 68849884 6.85955e+07 1.00371 ns
tpcds_q60/DataFusion:parquet 41428723 3.66403e+07 1.13069 ns
tpcds_q61/DataFusion:parquet 63260451 6.14269e+07 1.02985 ns
tpcds_q62/DataFusion:parquet 43065405 4.24621e+07 1.01421 ns
tpcds_q63/DataFusion:parquet 30270977 3.26812e+07 0.92625 ns
tpcds_q64/DataFusion:parquet 617024628 6.1782e+08 0.998712 ns
tpcds_q65/DataFusion:parquet 46390132 5.02037e+07 0.924038 ns
tpcds_q66/DataFusion:parquet 94291831 9.83178e+07 0.959051 ns
tpcds_q67/DataFusion:parquet 128521425 1.30833e+08 0.982331 ns
tpcds_q68/DataFusion:parquet 56707995 5.88538e+07 0.96354 ns
tpcds_q69/DataFusion:parquet 97478152 9.16561e+07 1.06352 ns
tpcds_q70/DataFusion:parquet 126142994 1.25099e+08 1.00835 ns
tpcds_q71/DataFusion:parquet 27192290 3.08586e+07 0.88119 ns
tpcds_q72/DataFusion:parquet 1637939180 1.62291e+09 1.00926 ns
tpcds_q73/DataFusion:parquet 33230454 3.56957e+07 0.930937 ns
tpcds_q74/DataFusion:parquet 139463127 1.42426e+08 0.979198 ns
tpcds_q75/DataFusion:parquet 111527444 1.20479e+08 0.925697 ns
tpcds_q76/DataFusion:parquet 53169040 5.25898e+07 1.01101 ns
tpcds_q77/DataFusion:parquet 46893910 4.76207e+07 0.984738 ns
tpcds_q78/DataFusion:parquet 175980291 1.73735e+08 1.01292 ns
tpcds_q79/DataFusion:parquet 35260942 3.73358e+07 0.944427 ns
tpcds_q80/DataFusion:parquet 99297241 9.95228e+07 0.997734 ns
tpcds_q81/DataFusion:parquet 48816181 5.04121e+07 0.968343 ns
tpcds_q82/DataFusion:parquet 28280643 2.66024e+07 1.06309 ns
tpcds_q83/DataFusion:parquet 69962495 6.97745e+07 1.00269 ns
tpcds_q84/DataFusion:parquet 49095067 5.23723e+07 0.937424 ns
tpcds_q85/DataFusion:parquet 163055248 1.68021e+08 0.970448 ns
tpcds_q86/DataFusion:parquet 21839443 2.05672e+07 1.06186 ns
tpcds_q87/DataFusion:parquet 59254685 5.96633e+07 0.993152 ns
tpcds_q88/DataFusion:parquet 101544900 1.03816e+08 0.978119 ns
tpcds_q89/DataFusion:parquet 34046226 3.36801e+07 1.01087 ns
tpcds_q90/DataFusion:parquet 27694182 2.57361e+07 1.07608 ns
tpcds_q91/DataFusion:parquet 85114532 8.45113e+07 1.00714 ns
tpcds_q92/DataFusion:parquet 26560668 2.71713e+07 0.977527 ns
tpcds_q93/DataFusion:parquet 34342457 3.5765e+07 0.960225 ns
tpcds_q94/DataFusion:parquet 31799303 3.12015e+07 1.01916 ns
tpcds_q95/DataFusion:parquet 84402297 8.21551e+07 1.02735 ns
tpcds_q96/DataFusion:parquet 23349816 2.25042e+07 1.03757 ns
tpcds_q97/DataFusion:parquet 38309316 3.89324e+07 0.983997 ns
tpcds_q98/DataFusion:parquet 32862772 3.26798e+07 1.0056 ns
tpcds_q99/DataFusion:parquet 53192566 5.10625e+07 1.04172 ns
tpcds_q01/DataFusion:vortex-file-compressed 18775221 1.81062e+07 1.03695 ns
tpcds_q02/DataFusion:vortex-file-compressed 42758712 4.20647e+07 1.0165 ns
tpcds_q03/DataFusion:vortex-file-compressed 15213754 1.50946e+07 1.00789 ns
tpcds_q04/DataFusion:vortex-file-compressed 480002034 4.79527e+08 1.00099 ns
tpcds_q05/DataFusion:vortex-file-compressed 41201504 4.08037e+07 1.00975 ns
tpcds_q06/DataFusion:vortex-file-compressed 55362153 5.34454e+07 1.03586 ns
tpcds_q07/DataFusion:vortex-file-compressed 56677098 5.38439e+07 1.05262 ns
tpcds_q08/DataFusion:vortex-file-compressed 62370492 6.29412e+07 0.990933 ns
tpcds_q09/DataFusion:vortex-file-compressed 32100757 3.21053e+07 0.999858 ns
tpcds_q10/DataFusion:vortex-file-compressed 35968326 3.49491e+07 1.02916 ns
tpcds_q11/DataFusion:vortex-file-compressed 293841528 2.90216e+08 1.01249 ns
tpcds_q12/DataFusion:vortex-file-compressed 18020877 1.92456e+07 0.936362 ns
tpcds_q13/DataFusion:vortex-file-compressed 39511658 3.88122e+07 1.01802 ns
tpcds_q14/DataFusion:vortex-file-compressed 260196193 2.59211e+08 1.0038 ns
tpcds_q15/DataFusion:vortex-file-compressed 40416813 3.98407e+07 1.01446 ns
tpcds_q16/DataFusion:vortex-file-compressed 26710561 2.6467e+07 1.0092 ns
tpcds_q17/DataFusion:vortex-file-compressed 79153322 7.47516e+07 1.05888 ns
tpcds_q18/DataFusion:vortex-file-compressed 59848374 5.82853e+07 1.02682 ns
tpcds_q19/DataFusion:vortex-file-compressed 28029284 2.77179e+07 1.01124 ns
tpcds_q20/DataFusion:vortex-file-compressed 23501533 2.24419e+07 1.04722 ns
tpcds_q21/DataFusion:vortex-file-compressed 229558124 2.28113e+08 1.00634 ns
tpcds_q22/DataFusion:vortex-file-compressed 67173311 7.00793e+07 0.958533 ns
tpcds_q23/DataFusion:vortex-file-compressed 232365713 2.28391e+08 1.0174 ns
tpcds_q24/DataFusion:vortex-file-compressed 116340302 1.14945e+08 1.01213 ns
tpcds_q25/DataFusion:vortex-file-compressed 77810344 7.73066e+07 1.00652 ns
tpcds_q26/DataFusion:vortex-file-compressed 38136244 3.71819e+07 1.02567 ns
tpcds_q27/DataFusion:vortex-file-compressed 137650617 1.35054e+08 1.01923 ns
tpcds_q28/DataFusion:vortex-file-compressed 28581401 2.92122e+07 0.978405 ns
tpcds_q29/DataFusion:vortex-file-compressed 78176524 7.66807e+07 1.01951 ns
tpcds_q30/DataFusion:vortex-file-compressed 29373424 2.76664e+07 1.0617 ns
tpcds_q31/DataFusion:vortex-file-compressed 113110526 1.12442e+08 1.00594 ns
tpcds_q32/DataFusion:vortex-file-compressed 13930905 1.40315e+07 0.992832 ns
tpcds_q33/DataFusion:vortex-file-compressed 33912523 3.28865e+07 1.0312 ns
tpcds_q34/DataFusion:vortex-file-compressed 27482852 2.69959e+07 1.01804 ns
tpcds_q35/DataFusion:vortex-file-compressed 50772612 4.74608e+07 1.06978 ns
tpcds_q36/DataFusion:vortex-file-compressed 70056643 7.20037e+07 0.972959 ns
tpcds_q37/DataFusion:vortex-file-compressed 29096132 2.91088e+07 0.999566 ns
tpcds_q38/DataFusion:vortex-file-compressed 44022754 4.39327e+07 1.00205 ns
tpcds_q39/DataFusion:vortex-file-compressed 314066840 3.0886e+08 1.01686 ns
tpcds_q40/DataFusion:vortex-file-compressed 58563870 5.70797e+07 1.026 ns
tpcds_q41/DataFusion:vortex-file-compressed 12459274 1.16807e+07 1.06666 ns
tpcds_q42/DataFusion:vortex-file-compressed 15817848 1.53654e+07 1.02944 ns
tpcds_q43/DataFusion:vortex-file-compressed 30456221 3.05336e+07 0.997465 ns
tpcds_q44/DataFusion:vortex-file-compressed 51107083 5.36273e+07 0.953005 ns
tpcds_q45/DataFusion:vortex-file-compressed 35163666 3.41903e+07 1.02847 ns
tpcds_q46/DataFusion:vortex-file-compressed 45681303 4.66911e+07 0.978372 ns
tpcds_q47/DataFusion:vortex-file-compressed 258501234 2.57873e+08 1.00244 ns
tpcds_q48/DataFusion:vortex-file-compressed 41535486 4.33099e+07 0.95903 ns
tpcds_q49/DataFusion:vortex-file-compressed 55205487 5.49859e+07 1.00399 ns
tpcds_q50/DataFusion:vortex-file-compressed 51212678 5.05142e+07 1.01383 ns
tpcds_q51/DataFusion:vortex-file-compressed 100766204 1.00834e+08 0.999332 ns
tpcds_q52/DataFusion:vortex-file-compressed 15646565 1.61543e+07 0.968572 ns
tpcds_q53/DataFusion:vortex-file-compressed 23136713 2.37706e+07 0.973332 ns
tpcds_q54/DataFusion:vortex-file-compressed 35231033 3.57688e+07 0.984966 ns
tpcds_q55/DataFusion:vortex-file-compressed 15683410 1.56539e+07 1.00188 ns
tpcds_q56/DataFusion:vortex-file-compressed 35885870 3.40612e+07 1.05357 ns
tpcds_q57/DataFusion:vortex-file-compressed 176519209 1.76278e+08 1.00137 ns
tpcds_q58/DataFusion:vortex-file-compressed 100999179 9.74314e+07 1.03662 ns
tpcds_q59/DataFusion:vortex-file-compressed 73772873 7.03203e+07 1.0491 ns
tpcds_q60/DataFusion:vortex-file-compressed 35466475 3.576e+07 0.991791 ns
tpcds_q61/DataFusion:vortex-file-compressed 46803400 4.77352e+07 0.980479 ns
tpcds_q62/DataFusion:vortex-file-compressed 40460475 4.02231e+07 1.0059 ns
tpcds_q63/DataFusion:vortex-file-compressed 23884638 2.31655e+07 1.03104 ns
tpcds_q64/DataFusion:vortex-file-compressed 410290542 4.08335e+08 1.00479 ns
tpcds_q65/DataFusion:vortex-file-compressed 41690682 4.16114e+07 1.00191 ns
tpcds_q66/DataFusion:vortex-file-compressed 173849445 1.74922e+08 0.993866 ns
tpcds_q67/DataFusion:vortex-file-compressed 125016400 1.28035e+08 0.976426 ns
tpcds_q68/DataFusion:vortex-file-compressed 43321203 4.58825e+07 0.944178 ns
tpcds_q69/DataFusion:vortex-file-compressed 35605559 3.28961e+07 1.08237 ns
tpcds_q70/DataFusion:vortex-file-compressed 131458324 1.34429e+08 0.977898 ns
tpcds_q71/DataFusion:vortex-file-compressed 26645161 2.62826e+07 1.01379 ns
tpcds_q72/DataFusion:vortex-file-compressed 2973386292 2.96055e+09 1.00434 ns
tpcds_q73/DataFusion:vortex-file-compressed 26610606 2.58565e+07 1.02916 ns
tpcds_q74/DataFusion:vortex-file-compressed 150799602 1.48649e+08 1.01447 ns
tpcds_q75/DataFusion:vortex-file-compressed 110125926 1.07945e+08 1.0202 ns
tpcds_q76/DataFusion:vortex-file-compressed 31856029 3.16443e+07 1.00669 ns
tpcds_q77/DataFusion:vortex-file-compressed 37278383 3.76939e+07 0.988976 ns
tpcds_q78/DataFusion:vortex-file-compressed 197577185 1.94397e+08 1.01636 ns
tpcds_q79/DataFusion:vortex-file-compressed 34634135 3.56951e+07 0.970278 ns
tpcds_q80/DataFusion:vortex-file-compressed 122812888 1.23654e+08 0.993201 ns
tpcds_q81/DataFusion:vortex-file-compressed 34019940 3.37569e+07 1.00779 ns
tpcds_q82/DataFusion:vortex-file-compressed 31239238 3.06855e+07 1.01805 ns
tpcds_q83/DataFusion:vortex-file-compressed 43259225 4.44889e+07 0.972359 ns
tpcds_q84/DataFusion:vortex-file-compressed 14560291 1.3595e+07 1.071 ns
tpcds_q85/DataFusion:vortex-file-compressed 47510626 4.84797e+07 0.98001 ns
tpcds_q86/DataFusion:vortex-file-compressed 17214774 1.65922e+07 1.03752 ns
tpcds_q87/DataFusion:vortex-file-compressed 45002515 4.42313e+07 1.01744 ns
tpcds_q88/DataFusion:vortex-file-compressed 79276519 8.03863e+07 0.986194 ns
tpcds_q89/DataFusion:vortex-file-compressed 38847641 3.69101e+07 1.05249 ns
tpcds_q90/DataFusion:vortex-file-compressed 16886985 1.63771e+07 1.03113 ns
tpcds_q91/DataFusion:vortex-file-compressed 19746760 2.09347e+07 0.943257 ns
tpcds_q92/DataFusion:vortex-file-compressed 12797492 1.3029e+07 0.98223 ns
tpcds_q93/DataFusion:vortex-file-compressed 40630404 4.11061e+07 0.988428 ns
tpcds_q94/DataFusion:vortex-file-compressed 22524512 2.23507e+07 1.00777 ns
tpcds_q95/DataFusion:vortex-file-compressed 58395397 5.67555e+07 1.02889 ns
tpcds_q96/DataFusion:vortex-file-compressed 14044039 1.43367e+07 0.979584 ns
tpcds_q97/DataFusion:vortex-file-compressed 28873783 2.84594e+07 1.01456 ns
tpcds_q98/DataFusion:vortex-file-compressed 31509414 3.13318e+07 1.00567 ns
tpcds_q99/DataFusion:vortex-file-compressed 70801963 6.66932e+07 1.06161 ns
tpcds_q01/DataFusion:vortex-compact 19744086 1.91373e+07 1.03171 ns
tpcds_q02/DataFusion:vortex-compact 42979989 4.42436e+07 0.971439 ns
tpcds_q03/DataFusion:vortex-compact 15143462 1.61114e+07 0.939924 ns
tpcds_q04/DataFusion:vortex-compact 480604110 4.79082e+08 1.00318 ns
tpcds_q05/DataFusion:vortex-compact 40737591 4.27386e+07 0.953181 ns
tpcds_q06/DataFusion:vortex-compact 55636176 5.54082e+07 1.00411 ns
tpcds_q07/DataFusion:vortex-compact 55092979 5.73254e+07 0.961058 ns
tpcds_q08/DataFusion:vortex-compact 62168561 6.19199e+07 1.00402 ns
tpcds_q09/DataFusion:vortex-compact 32148091 3.18713e+07 1.00868 ns
tpcds_q10/DataFusion:vortex-compact 37485646 3.6666e+07 1.02236 ns
tpcds_q11/DataFusion:vortex-compact 290750205 2.91595e+08 0.997102 ns
tpcds_q12/DataFusion:vortex-compact 17951428 1.78909e+07 1.00338 ns
tpcds_q13/DataFusion:vortex-compact 40836191 4.04999e+07 1.0083 ns
tpcds_q14/DataFusion:vortex-compact 258249253 2.55139e+08 1.01219 ns
tpcds_q15/DataFusion:vortex-compact 40937066 4.14811e+07 0.986884 ns
tpcds_q16/DataFusion:vortex-compact 26992881 2.63213e+07 1.02552 ns
tpcds_q17/DataFusion:vortex-compact 77073804 7.56796e+07 1.01842 ns
tpcds_q18/DataFusion:vortex-compact 59201087 5.67409e+07 1.04336 ns
tpcds_q19/DataFusion:vortex-compact 26975457 2.76195e+07 0.976682 ns
tpcds_q20/DataFusion:vortex-compact 22885461 2.28903e+07 0.999789 ns
tpcds_q21/DataFusion:vortex-compact 224015104 2.19971e+08 1.01838 ns
tpcds_q22/DataFusion:vortex-compact 72298637 6.91807e+07 1.04507 ns
tpcds_q23/DataFusion:vortex-compact 227966502 2.334e+08 0.976722 ns
tpcds_q24/DataFusion:vortex-compact 115861010 1.16336e+08 0.995914 ns
tpcds_q25/DataFusion:vortex-compact 78740428 7.7728e+07 1.01303 ns
tpcds_q26/DataFusion:vortex-compact 36862835 3.67825e+07 1.00218 ns
tpcds_q27/DataFusion:vortex-compact 137034751 1.3643e+08 1.00443 ns
tpcds_q28/DataFusion:vortex-compact 28685259 2.89045e+07 0.992415 ns
tpcds_q29/DataFusion:vortex-compact 78123631 7.82639e+07 0.998208 ns
tpcds_q30/DataFusion:vortex-compact 27627143 2.79148e+07 0.989695 ns
tpcds_q31/DataFusion:vortex-compact 114578818 1.14039e+08 1.00473 ns
tpcds_q32/DataFusion:vortex-compact 14212280 1.33372e+07 1.06561 ns
tpcds_q33/DataFusion:vortex-compact 33428310 3.33509e+07 1.00232 ns
tpcds_q34/DataFusion:vortex-compact 27521130 2.67828e+07 1.02757 ns
tpcds_q35/DataFusion:vortex-compact 48087706 4.90593e+07 0.980196 ns
tpcds_q36/DataFusion:vortex-compact 72549856 7.15025e+07 1.01465 ns
tpcds_q37/DataFusion:vortex-compact 29028512 2.90122e+07 1.00056 ns
tpcds_q38/DataFusion:vortex-compact 44616881 4.60734e+07 0.968386 ns
tpcds_q39/DataFusion:vortex-compact 316875166 3.08285e+08 1.02786 ns
tpcds_q40/DataFusion:vortex-compact 59774590 6.14536e+07 0.972679 ns
tpcds_q41/DataFusion:vortex-compact 12707121 1.30108e+07 0.976662 ns
tpcds_q42/DataFusion:vortex-compact 15361701 1.50735e+07 1.01912 ns
tpcds_q43/DataFusion:vortex-compact 30578757 2.93299e+07 1.04258 ns
tpcds_q44/DataFusion:vortex-compact 50427238 5.49461e+07 0.917758 ns
tpcds_q45/DataFusion:vortex-compact 34505060 3.48722e+07 0.989472 ns
tpcds_q46/DataFusion:vortex-compact 46960745 4.53571e+07 1.03536 ns
tpcds_q47/DataFusion:vortex-compact 253609658 2.54853e+08 0.995123 ns
tpcds_q48/DataFusion:vortex-compact 42850461 4.32916e+07 0.989809 ns
tpcds_q49/DataFusion:vortex-compact 54502730 5.5616e+07 0.979982 ns
tpcds_q50/DataFusion:vortex-compact 51130141 5.2845e+07 0.96755 ns
tpcds_q51/DataFusion:vortex-compact 99077939 9.9684e+07 0.99392 ns
tpcds_q52/DataFusion:vortex-compact 15948570 1.62936e+07 0.978824 ns
tpcds_q53/DataFusion:vortex-compact 23224946 2.38957e+07 0.971928 ns
tpcds_q54/DataFusion:vortex-compact 36529556 3.60395e+07 1.0136 ns
tpcds_q55/DataFusion:vortex-compact 15298693 1.54518e+07 0.990089 ns
tpcds_q56/DataFusion:vortex-compact 34314205 3.46591e+07 0.990049 ns
tpcds_q57/DataFusion:vortex-compact 176930249 1.75625e+08 1.00743 ns
tpcds_q58/DataFusion:vortex-compact 99857801 9.91472e+07 1.00717 ns
tpcds_q59/DataFusion:vortex-compact 73530807 7.09013e+07 1.03709 ns
tpcds_q60/DataFusion:vortex-compact 35739235 3.61939e+07 0.987439 ns
tpcds_q61/DataFusion:vortex-compact 47699690 4.82572e+07 0.988446 ns
tpcds_q62/DataFusion:vortex-compact 39758699 4.09493e+07 0.970925 ns
tpcds_q63/DataFusion:vortex-compact 23747468 2.37413e+07 1.00026 ns
tpcds_q64/DataFusion:vortex-compact 415473117 4.1273e+08 1.00665 ns
tpcds_q65/DataFusion:vortex-compact 42038816 4.26854e+07 0.984852 ns
tpcds_q66/DataFusion:vortex-compact 174381584 1.69543e+08 1.02854 ns
tpcds_q67/DataFusion:vortex-compact 128108517 1.27605e+08 1.00394 ns
tpcds_q68/DataFusion:vortex-compact 44496017 4.52692e+07 0.982921 ns
tpcds_q69/DataFusion:vortex-compact 34639367 3.40891e+07 1.01614 ns
tpcds_q70/DataFusion:vortex-compact 131320177 1.35093e+08 0.972069 ns
tpcds_q71/DataFusion:vortex-compact 25944739 2.59272e+07 1.00068 ns
tpcds_q72/DataFusion:vortex-compact 3013060603 2.979e+09 1.01144 ns
tpcds_q73/DataFusion:vortex-compact 28295482 2.71851e+07 1.04085 ns
tpcds_q74/DataFusion:vortex-compact 152100218 1.50566e+08 1.01019 ns
tpcds_q75/DataFusion:vortex-compact 110846072 1.10529e+08 1.00287 ns
tpcds_q76/DataFusion:vortex-compact 32267455 3.10689e+07 1.03858 ns
tpcds_q77/DataFusion:vortex-compact 38564732 3.67842e+07 1.0484 ns
tpcds_q78/DataFusion:vortex-compact 198716107 2.00864e+08 0.989308 ns
tpcds_q79/DataFusion:vortex-compact 35839462 3.4901e+07 1.02689 ns
tpcds_q80/DataFusion:vortex-compact 125311667 1.23348e+08 1.01592 ns
tpcds_q81/DataFusion:vortex-compact 35329136 3.49163e+07 1.01182 ns
tpcds_q82/DataFusion:vortex-compact 31297682 3.02784e+07 1.03366 ns
tpcds_q83/DataFusion:vortex-compact 44843449 4.43796e+07 1.01045 ns
tpcds_q84/DataFusion:vortex-compact 14263222 1.41356e+07 1.00903 ns
tpcds_q85/DataFusion:vortex-compact 49122512 4.92828e+07 0.996747 ns
tpcds_q86/DataFusion:vortex-compact 16935324 1.66751e+07 1.01561 ns
tpcds_q87/DataFusion:vortex-compact 43910066 4.44266e+07 0.988374 ns
tpcds_q88/DataFusion:vortex-compact 78678961 7.71256e+07 1.02014 ns
tpcds_q89/DataFusion:vortex-compact 38316338 3.71587e+07 1.03116 ns
tpcds_q90/DataFusion:vortex-compact 17041309 1.66695e+07 1.02231 ns
tpcds_q91/DataFusion:vortex-compact 21683783 2.08829e+07 1.03835 ns
tpcds_q92/DataFusion:vortex-compact 12915395 1.25821e+07 1.02649 ns
tpcds_q93/DataFusion:vortex-compact 40093277 3.9918e+07 1.00439 ns
tpcds_q94/DataFusion:vortex-compact 22761179 2.25251e+07 1.01048 ns
tpcds_q95/DataFusion:vortex-compact 57370903 5.91864e+07 0.969326 ns
tpcds_q96/DataFusion:vortex-compact 14365043 1.43264e+07 1.0027 ns
tpcds_q97/DataFusion:vortex-compact 28271891 2.86226e+07 0.987747 ns
tpcds_q98/DataFusion:vortex-compact 30945724 3.15314e+07 0.981426 ns
tpcds_q99/DataFusion:vortex-compact 73343350 6.98616e+07 1.04984 ns
tpcds_q01/DuckDB:parquet 46013535 4.61932e+07 0.996111 ns
tpcds_q02/DuckDB:parquet 28165260 2.85985e+07 0.98485 ns
tpcds_q03/DuckDB:parquet 13633234 1.38263e+07 0.986038 ns
tpcds_q04/DuckDB:parquet 124152006 1.25739e+08 0.987379 ns
tpcds_q05/DuckDB:parquet 29246136 2.95333e+07 0.990278 ns
tpcds_q06/DuckDB:parquet 32585304 3.25884e+07 0.999904 ns
tpcds_q07/DuckDB:parquet 27726290 2.79353e+07 0.992518 ns
tpcds_q08/DuckDB:parquet 28093253 2.81034e+07 0.999638 ns
tpcds_q09/DuckDB:parquet 40247049 4.07424e+07 0.987841 ns
tpcds_q10/DuckDB:parquet 39276330 3.75424e+07 1.04619 ns
tpcds_q11/DuckDB:parquet 83392212 8.29945e+07 1.00479 ns
tpcds_q12/DuckDB:parquet 17957192 1.87014e+07 0.960208 ns
tpcds_q13/DuckDB:parquet 37490589 3.73165e+07 1.00467 ns
tpcds_q14/DuckDB:parquet 98796241 9.8178e+07 1.0063 ns
tpcds_q15/DuckDB:parquet 25902144 2.58472e+07 1.00213 ns
tpcds_q16/DuckDB:parquet 22288278 2.26766e+07 0.982878 ns
tpcds_q17/DuckDB:parquet 39259014 3.93065e+07 0.998791 ns
tpcds_q18/DuckDB:parquet 98910981 1.00485e+08 0.984339 ns
tpcds_q19/DuckDB:parquet 32367765 3.21737e+07 1.00603 ns
tpcds_q20/DuckDB:parquet 18199530 1.89359e+07 0.961111 ns
tpcds_q21/DuckDB:parquet 13375756 1.33808e+07 0.999623 ns
tpcds_q22/DuckDB:parquet 95897440 9.71856e+07 0.986746 ns
tpcds_q23/DuckDB:parquet 97529091 9.92994e+07 0.982172 ns
tpcds_q24/DuckDB:parquet 49409881 4.96267e+07 0.995632 ns
tpcds_q25/DuckDB:parquet 35888200 3.58463e+07 1.00117 ns
tpcds_q26/DuckDB:parquet 37096777 3.70584e+07 1.00103 ns
tpcds_q27/DuckDB:parquet 75766499 7.88871e+07 0.960443 ns
tpcds_q28/DuckDB:parquet 42160507 4.29974e+07 0.980537 ns
tpcds_q29/DuckDB:parquet 37261128 3.74718e+07 0.994379 ns
tpcds_q30/DuckDB:parquet 44608570 4.45441e+07 1.00145 ns
tpcds_q31/DuckDB:parquet 27081742 2.64502e+07 1.02388 ns
tpcds_q32/DuckDB:parquet 12361921 1.24062e+07 0.99643 ns
tpcds_q33/DuckDB:parquet 20368801 2.00438e+07 1.01621 ns
tpcds_q34/DuckDB:parquet 23355797 2.32794e+07 1.00328 ns
tpcds_q35/DuckDB:parquet 67167676 6.72556e+07 0.998692 ns
tpcds_q36/DuckDB:parquet 24319309 2.45957e+07 0.988763 ns
tpcds_q37/DuckDB:parquet 15075136 1.50988e+07 0.998432 ns
tpcds_q38/DuckDB:parquet 35453062 3.5561e+07 0.996966 ns
tpcds_q39/DuckDB:parquet 36237407 3.57805e+07 1.01277 ns
tpcds_q40/DuckDB:parquet 19366577 1.89741e+07 1.02068 ns
tpcds_q41/DuckDB:parquet 9695588 9.87153e+06 0.982176 ns
tpcds_q42/DuckDB:parquet 12206571 1.27941e+07 0.954081 ns
tpcds_q43/DuckDB:parquet 17867890 1.79382e+07 0.99608 ns
tpcds_q44/DuckDB:parquet 28336604 2.86827e+07 0.987934 ns
tpcds_q45/DuckDB:parquet 28621085 2.93888e+07 0.973876 ns
tpcds_q46/DuckDB:parquet 49128172 4.83632e+07 1.01582 ns
tpcds_q47/DuckDB:parquet 64726845 6.48073e+07 0.998758 ns
tpcds_q48/DuckDB:parquet 33889192 3.41535e+07 0.99226 ns
tpcds_q49/DuckDB:parquet 26123706 2.61886e+07 0.997521 ns
tpcds_q50/DuckDB:parquet 28149451 2.86768e+07 0.981609 ns
tpcds_q51/DuckDB:parquet 196087673 1.95028e+08 1.00543 ns
tpcds_q52/DuckDB:parquet 12961797 1.2889e+07 1.00564 ns
tpcds_q53/DuckDB:parquet 20329137 2.05175e+07 0.990821 ns
tpcds_q54/DuckDB:parquet 25039908 2.53167e+07 0.989065 ns
tpcds_q55/DuckDB:parquet 12728382 1.29974e+07 0.9793 ns
tpcds_q56/DuckDB:parquet 22580672 2.3033e+07 0.980363 ns
tpcds_q57/DuckDB:parquet 50292374 5.03773e+07 0.998315 ns
tpcds_q58/DuckDB:parquet 24954674 2.50409e+07 0.996556 ns
tpcds_q59/DuckDB:parquet 38674482 3.91398e+07 0.988112 ns
tpcds_q60/DuckDB:parquet 22882534 2.34731e+07 0.97484 ns
tpcds_q61/DuckDB:parquet 31083818 3.06115e+07 1.01543 ns
tpcds_q62/DuckDB:parquet 13887302 1.36146e+07 1.02003 ns
tpcds_q63/DuckDB:parquet 17233089 1.72625e+07 0.998295 ns
tpcds_q64/DuckDB:parquet 76630647 7.67744e+07 0.998127 ns
tpcds_q65/DuckDB:parquet 27165653 2.64325e+07 1.02774 ns
tpcds_q66/DuckDB:parquet 30341049 3.03018e+07 1.0013 ns
tpcds_q67/DuckDB:parquet 188406177 1.85466e+08 1.01585 ns
tpcds_q68/DuckDB:parquet 39309907 3.91125e+07 1.00505 ns
tpcds_q69/DuckDB:parquet 41179628 4.12011e+07 0.999479 ns
tpcds_q70/DuckDB:parquet 56516763 5.69068e+07 0.993146 ns
tpcds_q71/DuckDB:parquet 21081735 2.10204e+07 1.00292 ns
tpcds_q72/DuckDB:parquet 169445981 1.65677e+08 1.02275 ns
tpcds_q73/DuckDB:parquet 20648575 2.09208e+07 0.986989 ns
tpcds_q74/DuckDB:parquet 53208824 5.26531e+07 1.01055 ns
tpcds_q75/DuckDB:parquet 54910919 5.38704e+07 1.01932 ns
tpcds_q76/DuckDB:parquet 21084667 2.15464e+07 0.978572 ns
tpcds_q77/DuckDB:parquet 23514294 2.33374e+07 1.00758 ns
tpcds_q78/DuckDB:parquet 77246867 7.77491e+07 0.993541 ns
tpcds_q79/DuckDB:parquet 30951774 3.15229e+07 0.981882 ns
tpcds_q80/DuckDB:parquet 42978768 4.36502e+07 0.984618 ns
tpcds_q81/DuckDB:parquet 49345468 4.99207e+07 0.988477 ns
tpcds_q82/DuckDB:parquet 18352851 1.84348e+07 0.995554 ns
tpcds_q83/DuckDB:parquet 18347312 1.79355e+07 1.02296 ns
tpcds_q84/DuckDB:parquet 20715378 2.11726e+07 0.978403 ns
tpcds_q85/DuckDB:parquet 42196650 4.31507e+07 0.97789 ns
tpcds_q86/DuckDB:parquet 38724787 3.91443e+07 0.989284 ns
tpcds_q87/DuckDB:parquet 37464335 3.61176e+07 1.03729 ns
tpcds_q88/DuckDB:parquet 52755830 5.34934e+07 0.986212 ns
tpcds_q89/DuckDB:parquet 22554184 2.29564e+07 0.982481 ns
tpcds_q90/DuckDB:parquet 8998114 9.14887e+06 0.983522 ns
tpcds_q91/DuckDB:parquet 26258625 2.56428e+07 1.02402 ns
tpcds_q92/DuckDB:parquet 13416608 1.34851e+07 0.994922 ns
tpcds_q93/DuckDB:parquet 33140273 3.32056e+07 0.998034 ns
tpcds_q94/DuckDB:parquet 18848513 1.86344e+07 1.01149 ns
tpcds_q95/DuckDB:parquet 125469414 1.38882e+08 0.903424 ns
tpcds_q96/DuckDB:parquet 11271541 1.12239e+07 1.00424 ns
tpcds_q97/DuckDB:parquet 35162788 3.78211e+07 0.929715 ns
tpcds_q98/DuckDB:parquet 24394214 2.42755e+07 1.00489 ns
tpcds_q99/DuckDB:parquet 24577429 2.42792e+07 1.01228 ns
tpcds_q01/DuckDB:vortex-file-compressed 32087552 3.25758e+07 0.985013 ns
tpcds_q02/DuckDB:vortex-file-compressed 52976275 5.12938e+07 1.0328 ns
tpcds_q03/DuckDB:vortex-file-compressed 22222897 2.29695e+07 0.967495 ns
tpcds_q04/DuckDB:vortex-file-compressed 111088796 1.15018e+08 0.965841 ns
tpcds_q05/DuckDB:vortex-file-compressed 43663787 4.22429e+07 1.03364 ns
tpcds_q06/DuckDB:vortex-file-compressed 35746570 3.63601e+07 0.983127 ns
tpcds_q07/DuckDB:vortex-file-compressed 26894921 2.7746e+07 0.969326 ns
tpcds_q08/DuckDB:vortex-file-compressed 32272531 3.1127e+07 1.0368 ns
tpcds_q09/DuckDB:vortex-file-compressed 49292466 4.89658e+07 1.00667 ns
tpcds_q10/DuckDB:vortex-file-compressed 45922545 4.61158e+07 0.995809 ns
tpcds_q11/DuckDB:vortex-file-compressed 70327503 7.3073e+07 0.962428 ns
tpcds_q12/DuckDB:vortex-file-compressed 18048254 1.82909e+07 0.986734 ns
tpcds_q13/DuckDB:vortex-file-compressed 33021858 3.37219e+07 0.97924 ns
tpcds_q14/DuckDB:vortex-file-compressed 129339420 1.27931e+08 1.01101 ns
tpcds_q15/DuckDB:vortex-file-compressed 28727918 2.86158e+07 1.00392 ns
tpcds_q16/DuckDB:vortex-file-compressed 31285632 2.9696e+07 1.05353 ns
tpcds_q17/DuckDB:vortex-file-compressed 39418265 3.87134e+07 1.01821 ns
tpcds_q18/DuckDB:vortex-file-compressed 85956126 8.78808e+07 0.9781 ns
tpcds_q19/DuckDB:vortex-file-compressed 35302856 3.53679e+07 0.998162 ns
tpcds_q20/DuckDB:vortex-file-compressed 19535826 1.96578e+07 0.993795 ns
tpcds_q21/DuckDB:vortex-file-compressed 16897945 1.67132e+07 1.01106 ns
tpcds_q22/DuckDB:vortex-file-compressed 108391355 1.08504e+08 0.998966 ns
tpcds_q23/DuckDB:vortex-file-compressed 124334748 1.21911e+08 1.01989 ns
tpcds_q24/DuckDB:vortex-file-compressed 54265375 5.39958e+07 1.00499 ns
tpcds_q25/DuckDB:vortex-file-compressed 37572293 3.81427e+07 0.985047 ns
tpcds_q26/DuckDB:vortex-file-compressed 42392028 4.19999e+07 1.00934 ns
tpcds_q27/DuckDB:vortex-file-compressed 86002197 8.47382e+07 1.01492 ns
tpcds_q28/DuckDB:vortex-file-compressed 41145569 4.06594e+07 1.01196 ns
tpcds_q29/DuckDB:vortex-file-compressed 38948788 3.80031e+07 1.02488 ns
tpcds_q30/DuckDB:vortex-file-compressed 34532561 3.44508e+07 1.00237 ns
tpcds_q31/DuckDB:vortex-file-compressed 34306609 3.28566e+07 1.04413 ns
tpcds_q32/DuckDB:vortex-file-compressed 15496766 1.48888e+07 1.04083 ns
tpcds_q33/DuckDB:vortex-file-compressed 40165493 3.87236e+07 1.03723 ns
tpcds_q34/DuckDB:vortex-file-compressed 26644085 2.49279e+07 1.06884 ns
tpcds_q35/DuckDB:vortex-file-compressed 77308996 7.64501e+07 1.01123 ns
tpcds_q36/DuckDB:vortex-file-compressed 25941159 2.75921e+07 0.940166 ns
tpcds_q37/DuckDB:vortex-file-compressed 16440780 1.71716e+07 0.957441 ns
tpcds_q38/DuckDB:vortex-file-compressed 42191270 4.13075e+07 1.0214 ns
tpcds_q39/DuckDB:vortex-file-compressed 41636550 4.13809e+07 1.00618 ns
tpcds_q40/DuckDB:vortex-file-compressed 22499909 2.321e+07 0.969405 ns
tpcds_q41/DuckDB:vortex-file-compressed 17056413 1.71839e+07 0.99258 ns
tpcds_q42/DuckDB:vortex-file-compressed 12109312 1.17041e+07 1.03462 ns
tpcds_q43/DuckDB:vortex-file-compressed 18459063 1.8385e+07 1.00403 ns
tpcds_q44/DuckDB:vortex-file-compressed 31150019 3.09102e+07 1.00776 ns
tpcds_q45/DuckDB:vortex-file-compressed 31079041 3.14911e+07 0.986915 ns
tpcds_q46/DuckDB:vortex-file-compressed 49920876 5.03696e+07 0.991092 ns
tpcds_q47/DuckDB:vortex-file-compressed 68340541 6.69347e+07 1.021 ns
tpcds_q48/DuckDB:vortex-file-compressed 30636006 3.07596e+07 0.995982 ns
tpcds_q49/DuckDB:vortex-file-compressed 41845832 4.23678e+07 0.98768 ns
tpcds_q50/DuckDB:vortex-file-compressed 32103091 3.05657e+07 1.0503 ns
tpcds_q51/DuckDB:vortex-file-compressed 125586491 1.2502e+08 1.00453 ns
tpcds_q52/DuckDB:vortex-file-compressed 11886408 1.24273e+07 0.956477 ns
tpcds_q53/DuckDB:vortex-file-compressed 26835356 2.63896e+07 1.01689 ns
tpcds_q54/DuckDB:vortex-file-compressed 36454992 3.66182e+07 0.995543 ns
tpcds_q55/DuckDB:vortex-file-compressed 12050443 1.27772e+07 0.943121 ns
tpcds_q56/DuckDB:vortex-file-compressed 43449201 4.13123e+07 1.05173 ns
tpcds_q57/DuckDB:vortex-file-compressed 62595610 6.23407e+07 1.00409 ns
tpcds_q58/DuckDB:vortex-file-compressed 34970454 3.6085e+07 0.969112 ns
tpcds_q59/DuckDB:vortex-file-compressed 55397945 5.49661e+07 1.00786 ns
tpcds_q60/DuckDB:vortex-file-compressed 42025344 4.16351e+07 1.00937 ns
tpcds_q61/DuckDB:vortex-file-compressed 38541482 3.84325e+07 1.00284 ns
tpcds_q62/DuckDB:vortex-file-compressed 22687694 2.06308e+07 1.0997 ns
tpcds_q63/DuckDB:vortex-file-compressed 26948420 2.72983e+07 0.987183 ns
tpcds_q64/DuckDB:vortex-file-compressed 83944602 8.3709e+07 1.00281 ns
tpcds_q65/DuckDB:vortex-file-compressed 30145854 3.03351e+07 0.993762 ns
tpcds_q66/DuckDB:vortex-file-compressed 38895515 4.17858e+07 0.93083 ns
tpcds_q67/DuckDB:vortex-file-compressed 179666398 1.72362e+08 1.04238 ns
tpcds_q68/DuckDB:vortex-file-compressed 41368657 4.24045e+07 0.975573 ns
tpcds_q69/DuckDB:vortex-file-compressed 47751038 4.86811e+07 0.980895 ns
tpcds_q70/DuckDB:vortex-file-compressed 49331045 5.06645e+07 0.973681 ns
tpcds_q71/DuckDB:vortex-file-compressed 30831301 3.07541e+07 1.00251 ns
tpcds_q72/DuckDB:vortex-file-compressed 170054378 1.6627e+08 1.02276 ns
tpcds_q73/DuckDB:vortex-file-compressed 23948759 2.33397e+07 1.0261 ns
tpcds_q74/DuckDB:vortex-file-compressed 59695433 6.14139e+07 0.972019 ns
tpcds_q75/DuckDB:vortex-file-compressed 72875523 7.54474e+07 0.965912 ns
tpcds_q76/DuckDB:vortex-file-compressed 24572774 2.41506e+07 1.01748 ns
tpcds_q77/DuckDB:vortex-file-compressed 36515471 3.64968e+07 1.00051 ns
tpcds_q78/DuckDB:vortex-file-compressed 83637439 8.62946e+07 0.969208 ns
tpcds_q79/DuckDB:vortex-file-compressed 31476753 3.14315e+07 1.00144 ns
tpcds_q80/DuckDB:vortex-file-compressed 51290286 5.01247e+07 1.02325 ns
tpcds_q81/DuckDB:vortex-file-compressed 38081513 3.9188e+07 0.971765 ns
tpcds_q82/DuckDB:vortex-file-compressed 17724276 1.83027e+07 0.968397 ns
tpcds_q83/DuckDB:vortex-file-compressed 40075474 3.96439e+07 1.01089 ns
tpcds_q84/DuckDB:vortex-file-compressed 21293808 2.04575e+07 1.04088 ns
tpcds_q85/DuckDB:vortex-file-compressed 48673585 4.88716e+07 0.995948 ns
tpcds_q86/DuckDB:vortex-file-compressed 38777585 3.82356e+07 1.01417 ns
tpcds_q87/DuckDB:vortex-file-compressed 43486467 4.51663e+07 0.962808 ns
tpcds_q88/DuckDB:vortex-file-compressed 80546518 7.90133e+07 1.0194 ns
tpcds_q89/DuckDB:vortex-file-compressed 26587518 2.7076e+07 0.98196 ns
tpcds_q90/DuckDB:vortex-file-compressed 18157947 1.80916e+07 1.00367 ns
tpcds_q91/DuckDB:vortex-file-compressed 30189226 2.94759e+07 1.0242 ns
tpcds_q92/DuckDB:vortex-file-compressed 18444795 1.89055e+07 0.975631 ns
tpcds_q93/DuckDB:vortex-file-compressed 31034191 3.09352e+07 1.0032 ns
tpcds_q94/DuckDB:vortex-file-compressed 24625270 2.47128e+07 0.996458 ns
tpcds_q95/DuckDB:vortex-file-compressed 141375065 1.4322e+08 0.987119 ns
tpcds_q96/DuckDB:vortex-file-compressed 10991371 1.09699e+07 1.00196 ns
tpcds_q97/DuckDB:vortex-file-compressed 41623771 4.22777e+07 0.984532 ns
tpcds_q98/DuckDB:vortex-file-compressed 20611537 2.0879e+07 0.987188 ns
tpcds_q99/DuckDB:vortex-file-compressed 35830195 3.57069e+07 1.00345 ns
tpcds_q01/DuckDB:vortex-compact 32690158 3.20141e+07 1.02112 ns
tpcds_q02/DuckDB:vortex-compact 51035595 4.98779e+07 1.02321 ns
tpcds_q03/DuckDB:vortex-compact 22380163 2.21201e+07 1.01176 ns
tpcds_q04/DuckDB:vortex-compact 119587503 1.12419e+08 1.06376 ns
tpcds_q05/DuckDB:vortex-compact 43284709 4.52126e+07 0.95736 ns
tpcds_q06/DuckDB:vortex-compact 36999472 3.56832e+07 1.03689 ns
tpcds_q07/DuckDB:vortex-compact 28670455 2.76993e+07 1.03506 ns
tpcds_q08/DuckDB:vortex-compact 31848194 3.20499e+07 0.993706 ns
tpcds_q09/DuckDB:vortex-compact 49043896 4.90911e+07 0.999039 ns
tpcds_q10/DuckDB:vortex-compact 45785726 4.60839e+07 0.99353 ns
tpcds_q11/DuckDB:vortex-compact 70996926 7.05535e+07 1.00628 ns
tpcds_q12/DuckDB:vortex-compact 18180357 1.82895e+07 0.994032 ns
tpcds_q13/DuckDB:vortex-compact 33779681 3.37033e+07 1.00227 ns
tpcds_q14/DuckDB:vortex-compact 130013676 1.29145e+08 1.00672 ns
tpcds_q15/DuckDB:vortex-compact 27705701 2.85184e+07 0.971504 ns
tpcds_q16/DuckDB:vortex-compact 29909256 2.89971e+07 1.03146 ns
tpcds_q17/DuckDB:vortex-compact 38927339 3.89252e+07 1.00006 ns
tpcds_q18/DuckDB:vortex-compact 87302866 8.60699e+07 1.01432 ns
tpcds_q19/DuckDB:vortex-compact 35326389 3.53217e+07 1.00013 ns
tpcds_q20/DuckDB:vortex-compact 19390904 1.99681e+07 0.971092 ns
tpcds_q21/DuckDB:vortex-compact 16003383 1.65447e+07 0.96728 ns
tpcds_q22/DuckDB:vortex-compact 110405402 1.10049e+08 1.00324 ns
tpcds_q23/DuckDB:vortex-compact 122007125 1.22305e+08 0.997564 ns
tpcds_q24/DuckDB:vortex-compact 53670217 5.55951e+07 0.965377 ns
tpcds_q25/DuckDB:vortex-compact 36738224 3.72411e+07 0.986497 ns
tpcds_q26/DuckDB:vortex-compact 43179248 4.21806e+07 1.02368 ns
tpcds_q27/DuckDB:vortex-compact 85510064 8.18653e+07 1.04452 ns
tpcds_q28/DuckDB:vortex-compact 40475706 4.08964e+07 0.989712 ns
tpcds_q29/DuckDB:vortex-compact 38537969 3.94967e+07 0.975725 ns
tpcds_q30/DuckDB:vortex-compact 34545740 3.39579e+07 1.01731 ns
tpcds_q31/DuckDB:vortex-compact 33258666 3.34448e+07 0.994434 ns
tpcds_q32/DuckDB:vortex-compact 14785002 1.50181e+07 0.98448 ns
tpcds_q33/DuckDB:vortex-compact 39437114 3.98885e+07 0.988685 ns
tpcds_q34/DuckDB:vortex-compact 25573381 2.5813e+07 0.990715 ns
tpcds_q35/DuckDB:vortex-compact 76169273 7.67928e+07 0.991881 ns
tpcds_q36/DuckDB:vortex-compact 26981117 2.69937e+07 0.999532 ns
tpcds_q37/DuckDB:vortex-compact 16543735 1.68186e+07 0.983656 ns
tpcds_q38/DuckDB:vortex-compact 43743104 4.32504e+07 1.01139 ns
tpcds_q39/DuckDB:vortex-compact 41143454 4.15502e+07 0.990211 ns
tpcds_q40/DuckDB:vortex-compact 22532828 2.23753e+07 1.00704 ns
tpcds_q41/DuckDB:vortex-compact 17123762 1.70394e+07 1.00495 ns
tpcds_q42/DuckDB:vortex-compact 12409679 1.21842e+07 1.01851 ns
tpcds_q43/DuckDB:vortex-compact 18618648 1.82945e+07 1.01772 ns
tpcds_q44/DuckDB:vortex-compact 31368508 3.19408e+07 0.982083 ns
tpcds_q45/DuckDB:vortex-compact 32085763 3.0962e+07 1.0363 ns
tpcds_q46/DuckDB:vortex-compact 50980297 5.06641e+07 1.00624 ns
tpcds_q47/DuckDB:vortex-compact 68499812 6.86716e+07 0.997498 ns
tpcds_q48/DuckDB:vortex-compact 31196241 3.16425e+07 0.985898 ns
tpcds_q49/DuckDB:vortex-compact 42319446 4.30431e+07 0.983187 ns
tpcds_q50/DuckDB:vortex-compact 31570337 3.19896e+07 0.986893 ns
tpcds_q51/DuckDB:vortex-compact 124669834 1.23939e+08 1.0059 ns
tpcds_q52/DuckDB:vortex-compact 12151245 1.22003e+07 0.995978 ns
tpcds_q53/DuckDB:vortex-compact 26668433 2.70922e+07 0.984359 ns
tpcds_q54/DuckDB:vortex-compact 36189272 3.59438e+07 1.00683 ns
tpcds_q55/DuckDB:vortex-compact 11758334 1.18615e+07 0.991299 ns
tpcds_q56/DuckDB:vortex-compact 42565812 4.18319e+07 1.01754 ns
tpcds_q57/DuckDB:vortex-compact 60919375 6.15779e+07 0.989306 ns
tpcds_q58/DuckDB:vortex-compact 35254246 3.58012e+07 0.984723 ns
tpcds_q59/DuckDB:vortex-compact 54264153 5.38772e+07 1.00718 ns
tpcds_q60/DuckDB:vortex-compact 42113931 4.20296e+07 1.00201 ns
tpcds_q61/DuckDB:vortex-compact 39401819 3.83973e+07 1.02616 ns
tpcds_q62/DuckDB:vortex-compact 20700407 2.09239e+07 0.989317 ns
tpcds_q63/DuckDB:vortex-compact 27679759 2.68796e+07 1.02977 ns
tpcds_q64/DuckDB:vortex-compact 82749989 8.35197e+07 0.990784 ns
tpcds_q65/DuckDB:vortex-compact 30639174 2.9844e+07 1.02664 ns
tpcds_q66/DuckDB:vortex-compact 39169491 3.88815e+07 1.00741 ns
tpcds_q67/DuckDB:vortex-compact 175018176 1.76268e+08 0.992909 ns
tpcds_q68/DuckDB:vortex-compact 40876650 4.16918e+07 0.980448 ns
tpcds_q69/DuckDB:vortex-compact 48274417 4.80369e+07 1.00494 ns
tpcds_q70/DuckDB:vortex-compact 50327914 5.06208e+07 0.994213 ns
tpcds_q71/DuckDB:vortex-compact 31462275 3.15295e+07 0.997867 ns
tpcds_q72/DuckDB:vortex-compact 170344680 1.66877e+08 1.02078 ns
tpcds_q73/DuckDB:vortex-compact 23624142 2.34784e+07 1.00621 ns
tpcds_q74/DuckDB:vortex-compact 59701689 6.15849e+07 0.969422 ns
tpcds_q75/DuckDB:vortex-compact 74375940 7.37721e+07 1.00819 ns
tpcds_q76/DuckDB:vortex-compact 24479878 2.45291e+07 0.997995 ns
tpcds_q77/DuckDB:vortex-compact 36527775 3.55394e+07 1.02781 ns
tpcds_q78/DuckDB:vortex-compact 85527396 8.4176e+07 1.01605 ns
tpcds_q79/DuckDB:vortex-compact 31541212 3.23661e+07 0.974514 ns
tpcds_q80/DuckDB:vortex-compact 50131780 5.20156e+07 0.963784 ns
tpcds_q81/DuckDB:vortex-compact 37829996 3.81055e+07 0.992769 ns
tpcds_q82/DuckDB:vortex-compact 17156461 1.69328e+07 1.01321 ns
tpcds_q83/DuckDB:vortex-compact 40093915 3.93802e+07 1.01812 ns
tpcds_q84/DuckDB:vortex-compact 21298070 2.12963e+07 1.00008 ns
tpcds_q85/DuckDB:vortex-compact 47352284 4.92164e+07 0.962125 ns
tpcds_q86/DuckDB:vortex-compact 42221116 3.85413e+07 1.09548 ns
tpcds_q87/DuckDB:vortex-compact 43887718 4.33977e+07 1.01129 ns
tpcds_q88/DuckDB:vortex-compact 78512645 7.87632e+07 0.996818 ns
tpcds_q89/DuckDB:vortex-compact 26718681 2.67551e+07 0.998637 ns
tpcds_q90/DuckDB:vortex-compact 18546183 1.83544e+07 1.01045 ns
tpcds_q91/DuckDB:vortex-compact 29585401 2.8525e+07 1.03718 ns
tpcds_q92/DuckDB:vortex-compact 18821402 1.78111e+07 1.05672 ns
tpcds_q93/DuckDB:vortex-compact 30719413 3.1015e+07 0.99047 ns
tpcds_q94/DuckDB:vortex-compact 24331319 2.33687e+07 1.04119 ns
tpcds_q95/DuckDB:vortex-compact 136763286 1.42944e+08 0.956761 ns
tpcds_q96/DuckDB:vortex-compact 11079938 1.04969e+07 1.05555 ns
tpcds_q97/DuckDB:vortex-compact 42151214 4.27856e+07 0.985173 ns
tpcds_q98/DuckDB:vortex-compact 20372700 2.06435e+07 0.986881 ns
tpcds_q99/DuckDB:vortex-compact 36041797 3.50614e+07 1.02796 ns
tpcds_q01/DuckDB:duckdb 23781457 2.31985e+07 1.02513 ns
tpcds_q02/DuckDB:duckdb 23242986 2.29098e+07 1.01454 ns
tpcds_q03/DuckDB:duckdb 10441655 1.01637e+07 1.02735 ns
tpcds_q04/DuckDB:duckdb 173547324 1.71825e+08 1.01003 ns
tpcds_q05/DuckDB:duckdb 20648722 1.99665e+07 1.03417 ns
tpcds_q06/DuckDB:duckdb 27228794 2.80696e+07 0.970044 ns
tpcds_q07/DuckDB:duckdb 40201454 3.98952e+07 1.00768 ns
tpcds_q08/DuckDB:duckdb 124804261 1.23132e+08 1.01358 ns
tpcds_q09/DuckDB:duckdb 19237086 1.9135e+07 1.00534 ns
tpcds_q10/DuckDB:duckdb 26530102 2.68129e+07 0.989453 ns
tpcds_q11/DuckDB:duckdb 150723245 1.48785e+08 1.01303 ns
tpcds_q12/DuckDB:duckdb 15003146 1.52401e+07 0.984452 ns
tpcds_q13/DuckDB:duckdb 26560078 2.63774e+07 1.00692 ns
tpcds_q14/DuckDB:duckdb 91829209 9.20355e+07 0.997759 ns
tpcds_q15/DuckDB:duckdb 22813907 2.18625e+07 1.04352 ns
tpcds_q16/DuckDB:duckdb 20122825 2.00683e+07 1.00272 ns
tpcds_q17/DuckDB:duckdb 24173711 2.44719e+07 0.987815 ns
tpcds_q18/DuckDB:duckdb 48574284 4.84476e+07 1.00261 ns
tpcds_q19/DuckDB:duckdb 19816602 1.92185e+07 1.03112 ns
tpcds_q20/DuckDB:duckdb 15444336 1.54074e+07 1.0024 ns
tpcds_q21/DuckDB:duckdb 7844898 7.69594e+06 1.01936 ns
tpcds_q22/DuckDB:duckdb 83396645 8.075e+07 1.03278 ns
tpcds_q23/DuckDB:duckdb 71051440 7.30246e+07 0.972979 ns
tpcds_q24/DuckDB:duckdb 26464833 2.59712e+07 1.01901 ns
tpcds_q25/DuckDB:duckdb 19144479 1.86631e+07 1.02579 ns
tpcds_q26/DuckDB:duckdb 29023621 2.87819e+07 1.0084 ns
tpcds_q27/DuckDB:duckdb 50183712 5.10639e+07 0.982763 ns
tpcds_q28/DuckDB:duckdb 24521694 2.47324e+07 0.991482 ns
tpcds_q29/DuckDB:duckdb 24639938 2.44514e+07 1.00771 ns
tpcds_q30/DuckDB:duckdb 32261057 3.21168e+07 1.00449 ns
tpcds_q31/DuckDB:duckdb 23670805 2.38424e+07 0.992802 ns
tpcds_q32/DuckDB:duckdb 8377557 8.32027e+06 1.00688 ns
tpcds_q33/DuckDB:duckdb 16109680 1.7092e+07 0.942529 ns
tpcds_q34/DuckDB:duckdb 17783112 1.83067e+07 0.9714 ns
tpcds_q35/DuckDB:duckdb 35901817 3.64769e+07 0.984235 ns
tpcds_q36/DuckDB:duckdb 77144615 7.48595e+07 1.03053 ns
tpcds_q37/DuckDB:duckdb 9184382 8.90718e+06 1.03112 ns
tpcds_q38/DuckDB:duckdb 32760935 3.28821e+07 0.996315 ns
tpcds_q39/DuckDB:duckdb 29570299 2.91526e+07 1.01433 ns
tpcds_q40/DuckDB:duckdb 15055807 1.47231e+07 1.02259 ns
tpcds_q41/DuckDB:duckdb 11320818 1.03148e+07 1.09754 ns
tpcds_q42/DuckDB:duckdb 8917558 8.67797e+06 1.02761 ns
tpcds_q43/DuckDB:duckdb 13478651 1.43971e+07 0.936208 ns
tpcds_q44/DuckDB:duckdb 16790089 1.69198e+07 0.992331 ns
tpcds_q45/DuckDB:duckdb 18728242 1.79056e+07 1.04594 ns
tpcds_q46/DuckDB:duckdb 39403883 3.88025e+07 1.0155 ns
tpcds_q47/DuckDB:duckdb 59718868 5.99738e+07 0.995749 ns
tpcds_q48/DuckDB:duckdb 25860536 2.56877e+07 1.00673 ns
tpcds_q49/DuckDB:duckdb 18067548 1.71179e+07 1.05548 ns
tpcds_q50/DuckDB:duckdb 16793222 1.63877e+07 1.02474 ns
tpcds_q51/DuckDB:duckdb 110011607 1.10708e+08 0.993709 ns
tpcds_q52/DuckDB:duckdb 9693818 8.77855e+06 1.10426 ns
tpcds_q53/DuckDB:duckdb 16861605 1.65468e+07 1.01902 ns
tpcds_q54/DuckDB:duckdb 18699397 1.91224e+07 0.97788 ns
tpcds_q55/DuckDB:duckdb 9469059 9.8896e+06 0.957477 ns
tpcds_q56/DuckDB:duckdb 17452774 1.72819e+07 1.00989 ns
tpcds_q57/DuckDB:duckdb 48792691 4.92715e+07 0.990283 ns
tpcds_q58/DuckDB:duckdb 16617842 1.61723e+07 1.02755 ns
tpcds_q59/DuckDB:duckdb 37332667 3.73007e+07 1.00086 ns
tpcds_q60/DuckDB:duckdb 19321124 1.89632e+07 1.01887 ns
tpcds_q61/DuckDB:duckdb 18376484 1.82423e+07 1.00735 ns
tpcds_q62/DuckDB:duckdb 10321062 1.04074e+07 0.991705 ns
tpcds_q63/DuckDB:duckdb 13670978 1.39482e+07 0.980128 ns
tpcds_q64/DuckDB:duckdb 59481050 5.83323e+07 1.01969 ns
tpcds_q65/DuckDB:duckdb 32790316 3.27945e+07 0.999871 ns
tpcds_q66/DuckDB:duckdb 26740264 2.66304e+07 1.00413 ns
tpcds_q67/DuckDB:duckdb 155186547 1.54317e+08 1.00563 ns
tpcds_q68/DuckDB:duckdb 27965067 2.7601e+07 1.01319 ns
tpcds_q69/DuckDB:duckdb 29203902 2.91512e+07 1.00181 ns
tpcds_q70/DuckDB:duckdb 19683570 1.96048e+07 1.00402 ns
tpcds_q71/DuckDB:duckdb 16193538 1.58518e+07 1.02156 ns
tpcds_q72/DuckDB:duckdb 45705224 4.49854e+07 1.016 ns
tpcds_q73/DuckDB:duckdb 13230525 1.42385e+07 0.929208 ns
tpcds_q74/DuckDB:duckdb 106072680 1.04936e+08 1.01083 ns
tpcds_q75/DuckDB:duckdb 42750560 4.37943e+07 0.976167 ns
tpcds_q76/DuckDB:duckdb 13610090 1.38722e+07 0.981108 ns
tpcds_q77/DuckDB:duckdb 14138906 1.43612e+07 0.984523 ns
tpcds_q78/DuckDB:duckdb 65742809 6.59327e+07 0.99712 ns
tpcds_q79/DuckDB:duckdb 21304919 2.11561e+07 1.00704 ns
tpcds_q80/DuckDB:duckdb 31072373 3.05354e+07 1.01758 ns
tpcds_q81/DuckDB:duckdb 40551549 3.9397e+07 1.02931 ns
tpcds_q82/DuckDB:duckdb 10523157 1.04918e+07 1.00299 ns
tpcds_q83/DuckDB:duckdb 10473097 1.0836e+07 0.966514 ns
tpcds_q84/DuckDB:duckdb 14726061 1.48952e+07 0.988643 ns
tpcds_q85/DuckDB:duckdb 24866889 2.49485e+07 0.996728 ns
tpcds_q86/DuckDB:duckdb 13760525 1.39185e+07 0.98865 ns
tpcds_q87/DuckDB:duckdb 32138318 3.31914e+07 0.968271 ns
tpcds_q88/DuckDB:duckdb 27250886 2.72687e+07 0.999346 ns
tpcds_q89/DuckDB:duckdb 18865609 1.91565e+07 0.984814 ns
tpcds_q90/DuckDB:duckdb 6618221 6.55141e+06 1.0102 ns
tpcds_q91/DuckDB:duckdb 15118182 1.4319e+07 1.05581 ns
tpcds_q92/DuckDB:duckdb 9662171 9.99343e+06 0.966852 ns
tpcds_q93/DuckDB:duckdb 23325340 2.34286e+07 0.995593 ns
tpcds_q94/DuckDB:duckdb 15288101 1.48608e+07 1.02876 ns
tpcds_q95/DuckDB:duckdb 108447135 1.08601e+08 0.998584 ns
tpcds_q96/DuckDB:duckdb 5989248 6.1443e+06 0.974765 ns
tpcds_q97/DuckDB:duckdb 32292531 3.23664e+07 0.997717 ns
tpcds_q98/DuckDB:duckdb 20441887 1.99633e+07 1.02397 ns
tpcds_q99/DuckDB:duckdb 21131073 2.09114e+07 1.01051 ns

github-actions[bot] avatar Sep 08 '25 21:09 github-actions[bot]

Why did you choose a bloom filter instead of an another approximate set membership data-structure (cuckoo or quotient filter)?

joseph-isaacs avatar Sep 09 '25 10:09 joseph-isaacs

FWIW the SOA is either what you did or https://arxiv.org/pdf/2405.10253, there's no comparison of these two in the literature yet

robert3005 avatar Sep 09 '25 15:09 robert3005

Why did you choose a bloom filter instead of an another approximate set membership data-structure (cuckoo or quotient filter)?

Yea, I mostly just ran with SBBF since there is a lot of prior art behind it, Cuckoo might be better but the infra is the same regardless. I also haven't done anything to explicitly perf test the hasher or the bloom filter itself, but it deserves its own microbenchmarks. StarRocks has some AVX2 kernels as well that might be useful to look into in the future

Any reason the bloom filters aren't just a binary column in the zone map? In theory, we could write the zone map using a StructLayout such that only the required columns are read.

That is true, but then it gets a bit weird: how do you implement pushdown? For ZoneMaps we create pruning expressions and then apply them against the stats array like it were any other array. Following the analogy, we'd write nullable bloom filter Binary columns in the zone map, then implement a new BloomFilterCheck expression which receives a Binary child and a Utf8 child, and would deserialize the binary child as well.

You also want all of the bloom filters to be packed into a single segment, roughly, since all of it gets touched in pruning. So then you need to make a special layout for it or whatever. All this vs just shoving it explicitly into a segment and wiring it in as another step in the pruning pipeline...not sure really.

Initial results here look like there are some promising speedups to be gained, particularly against S3. Need to figure out why there are some perf degredations, and probably play around with the filter size

a10y avatar Sep 09 '25 22:09 a10y

Having fewer special things should be the way. Stats are already at the end of the file. If we want to use bloom filters for anything else it shoudnt be the case that nothing works. The special layout we are suggesting is likely generally useful concept that would get used outside of stats

robert3005 avatar Sep 10 '25 00:09 robert3005

Not sure what you're suggesting @robert3005 ? I think I agree with @a10y that we can treat bloom filters specially? The problem we may have is that LayoutReaders are a tree, so it's not clear if the bloom filter should come before / after pruning or basically where in the tree? And what about if we add other indexing structures? But that feels like it can be solved later.

gatesn avatar Sep 10 '25 07:09 gatesn

Im suggesting they’re a sibling of other stats and essentially a extension dtype on binary dtype. But it’s also easy to add new layouts or stats so we can always implement another version of it.

robert3005 avatar Sep 10 '25 07:09 robert3005

CodSpeed Performance Report

Merging #4548 will degrade performances by 12.01%

Comparing aduffy/bloom (f363906) with develop (e604d22)

Summary

❌ 1 regression
✅ 1167 untouched

:warning: Please fix the performance issues or acknowledge them on CodSpeed.

Benchmarks breakdown

Benchmark BASE HEAD Change
encode_specialized 1.1 ms 1.2 ms -12.01%

codspeed-hq[bot] avatar Sep 11 '25 20:09 codspeed-hq[bot]

Benchmarks: FineWeb

Summary

  • Overall: 0.969x ➖
  • Vortex: 0.956x ➖
  • duckdb:vortex: 0.963x ➖
  • datafusion:vortex: 0.949x ➖
  • Best: fineweb_q08/DuckDB:vortex-compact (0.651x)
  • Worst: fineweb_q02/DataFusion:vortex-file-compressed (1.121x)
  • Significant (>10%): 7↑ 1↓
Detailed Results Table
name PR 44465167 base 4181e121 ratio (PR/base) unit remark
fineweb_q00/DuckDB:parquet 28292517 2.86226e+07 0.988469 ns
fineweb_q01/DuckDB:parquet 96078322 9.673e+07 0.993262 ns
fineweb_q02/DuckDB:parquet 100041816 1.00262e+08 0.9978 ns
fineweb_q03/DuckDB:parquet 304217318 3.04362e+08 0.999523 ns
fineweb_q04/DuckDB:parquet 429505742 4.27287e+08 1.00519 ns
fineweb_q05/DuckDB:parquet 402292474 4.07871e+08 0.986324 ns
fineweb_q06/DuckDB:parquet 199930946 2.05087e+08 0.974862 ns
fineweb_q07/DuckDB:parquet 213316049 2.14071e+08 0.996473 ns
fineweb_q08/DuckDB:parquet 57089638 6.04861e+07 0.943847 ns
fineweb_q00/DuckDB:vortex-file-compressed 4108198 3.95713e+06 1.03818 ns
fineweb_q01/DuckDB:vortex-file-compressed 24548059 2.55118e+07 0.962223 ns
fineweb_q02/DuckDB:vortex-file-compressed 29450630 2.86671e+07 1.02733 ns
fineweb_q03/DuckDB:vortex-file-compressed 107224450 1.05069e+08 1.02052 ns
fineweb_q04/DuckDB:vortex-file-compressed 188978221 1.93758e+08 0.975329 ns
fineweb_q05/DuckDB:vortex-file-compressed 173237813 1.7139e+08 1.01078 ns
fineweb_q06/DuckDB:vortex-file-compressed 53886527 5.36092e+07 1.00517 ns
fineweb_q07/DuckDB:vortex-file-compressed 57727012 5.62811e+07 1.02569 ns
fineweb_q08/DuckDB:vortex-file-compressed 5090769 7.35739e+06 0.691926 ns 🚀
fineweb_q00/DuckDB:vortex-compact 5117677 5.56388e+06 0.919803 ns
fineweb_q01/DuckDB:vortex-compact 87821241 8.9041e+07 0.986301 ns
fineweb_q02/DuckDB:vortex-compact 95187092 9.32396e+07 1.02089 ns
fineweb_q03/DuckDB:vortex-compact 829912134 8.23297e+08 1.00803 ns
fineweb_q04/DuckDB:vortex-compact 936635614 8.85169e+08 1.05814 ns
fineweb_q05/DuckDB:vortex-compact 807114292 7.90992e+08 1.02038 ns
fineweb_q06/DuckDB:vortex-compact 446691829 4.38522e+08 1.01863 ns
fineweb_q07/DuckDB:vortex-compact 460210360 4.47981e+08 1.0273 ns
fineweb_q08/DuckDB:vortex-compact 5057616 7.77214e+06 0.650737 ns 🚀
fineweb_q00/DataFusion:parquet 5751356 6.08924e+06 0.944511 ns
fineweb_q01/DataFusion:parquet 298417535 2.95859e+08 1.00865 ns
fineweb_q02/DataFusion:parquet 302659960 2.98694e+08 1.01328 ns
fineweb_q03/DataFusion:parquet 298141807 2.94955e+08 1.01081 ns
fineweb_q04/DataFusion:parquet 319773137 3.14456e+08 1.01691 ns
fineweb_q05/DataFusion:parquet 313979574 3.09758e+08 1.01363 ns
fineweb_q06/DataFusion:parquet 305780926 3.00914e+08 1.01617 ns
fineweb_q07/DataFusion:parquet 299468410 2.93914e+08 1.0189 ns
fineweb_q08/DataFusion:parquet 295930522 2.9414e+08 1.00609 ns
fineweb_q00/DataFusion:vortex-file-compressed 3222509 3.26702e+06 0.986376 ns
fineweb_q01/DataFusion:vortex-file-compressed 20028599 2.2455e+07 0.891942 ns
fineweb_q02/DataFusion:vortex-file-compressed 24917529 2.22191e+07 1.12145 ns
fineweb_q03/DataFusion:vortex-file-compressed 70704696 7.71174e+07 0.916845 ns
fineweb_q04/DataFusion:vortex-file-compressed 194647288 1.97472e+08 0.985695 ns
fineweb_q05/DataFusion:vortex-file-compressed 177988660 1.79231e+08 0.993068 ns
fineweb_q06/DataFusion:vortex-file-compressed 64584411 6.08037e+07 1.06218 ns
fineweb_q07/DataFusion:vortex-file-compressed 64982645 6.26342e+07 1.03749 ns
fineweb_q08/DataFusion:vortex-file-compressed 5404030 7.05529e+06 0.765954 ns
fineweb_q00/DataFusion:vortex-compact 3630021 4.15931e+06 0.872746 ns
fineweb_q01/DataFusion:vortex-compact 96239176 1.12174e+08 0.857946 ns
fineweb_q02/DataFusion:vortex-compact 93074132 9.9511e+07 0.935315 ns
fineweb_q03/DataFusion:vortex-compact 918614068 9.42509e+08 0.974647 ns
fineweb_q04/DataFusion:vortex-compact 1050314698 1.04937e+09 1.0009 ns
fineweb_q05/DataFusion:vortex-compact 891177223 9.0045e+08 0.989702 ns
fineweb_q06/DataFusion:vortex-compact 486769921 4.85795e+08 1.00201 ns
fineweb_q07/DataFusion:vortex-compact 502835558 5.0199e+08 1.00168 ns
fineweb_q08/DataFusion:vortex-compact 5490733 7.20522e+06 0.76205 ns

github-actions[bot] avatar Oct 02 '25 20:10 github-actions[bot]

I'm struggling to reproduce a lot of the slowdowns that I'm seeing in the NVME runs here

image

(top is branch, bottom is develop)

I'm convinced they're real but I need to find a better way to replicate and track them down.

There's probably something suboptimal in the way that we're laying out the segments. Right now, I have the bloom filter segments for all dict chunks be contiguous. We could change it to be contiguous with the dict values segment, but that ends up causing many small reads for each chunk. Something feels a bit off.

a10y avatar Oct 06 '25 14:10 a10y