feature: Bloom Filters
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.
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.
: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.
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.
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Why did you choose a bloom filter instead of an another approximate set membership data-structure (cuckoo or quotient filter)?
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
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
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
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.
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.
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% |
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 |
I'm struggling to reproduce a lot of the slowdowns that I'm seeing in the NVME runs here
(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.