Skip to content

Feature: Canonicalize ListView#4754

Closed
connortsui20 wants to merge 8 commits intodevelopfrom
ct/list-view-canonicalize
Closed

Feature: Canonicalize ListView#4754
connortsui20 wants to merge 8 commits intodevelopfrom
ct/list-view-canonicalize

Conversation

@connortsui20
Copy link
Contributor

@connortsui20 connortsui20 commented Sep 24, 2025

Tracking Issue: #4699

This PR migrates the Canonical::List encoding from ListArray to ListViewArray.

There were a lot of small things that had to be updated, as well as tests that assumed ListArray was the default encoding.

Unresolved

  • Bug in TPC-DS (Failed to downcast) due to list_contains kernel not expecting a ListViewArray
  • I am not entirely sure that my refactoring of encodings/sparse/src/canonical.rs and vortex-array/src/arrays/chunked/decode.rs is correct, so I would appreciate scrutiny on that. (I cleaned it up but also filed Clean up encodings/sparse/src/canonical.rs #4777)
  • Should the take compute function on ListArray return a ListViewArray? We might also want to defer this question to the operator changes later. (yes)
  • The preferred arrow encoding for lists is still the normal GenericListArray, not their GenericListViewArray. There are some tests that rely on this, not sure if should just remove parts of those tests. (ToArrow is now implemented for ListArray
  • The statpopgen benchmark slows down by 1.6-2.1x. That should be investigated, but is performance in the scope of this PR? There are a lot of compute functions that ListView needs to operate well (to make use of the fact that it is a view).

@connortsui20 connortsui20 added the changelog/feature A new feature label Sep 24, 2025
@connortsui20 connortsui20 marked this pull request as draft September 24, 2025 21:40
@codecov
Copy link

codecov bot commented Sep 24, 2025

Codecov Report

❌ Patch coverage is 94.66912% with 58 lines in your changes missing coverage. Please review.
✅ Project coverage is 87.65%. Comparing base (a6cb059) to head (33047a0).
⚠️ Report is 3 commits behind head on develop.

Files with missing lines Patch % Lines
vortex-duckdb/src/exporter/dict.rs 0.00% 13 Missing ⚠️
vortex-array/src/arrow/compute/to_arrow/list.rs 70.00% 12 Missing ⚠️
vortex-array/src/arrays/listview/rebuild.rs 94.30% 11 Missing ⚠️
vortex-duckdb/src/exporter/list.rs 87.50% 8 Missing ⚠️
vortex-array/src/builders/listview.rs 78.94% 4 Missing ⚠️
vortex-array/src/arrow/convert.rs 97.65% 3 Missing ⚠️
vortex-layout/src/layouts/compact.rs 0.00% 3 Missing ⚠️
vortex-array/src/arrays/listview/compute/filter.rs 75.00% 1 Missing ⚠️
vortex-array/src/canonical.rs 83.33% 1 Missing ⚠️
vortex-array/src/compute/list_contains.rs 99.25% 1 Missing ⚠️
... and 1 more

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

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

Base automatically changed from ct/list-view-builder to develop September 25, 2025 13:30
@connortsui20 connortsui20 force-pushed the ct/list-view-canonicalize branch 2 times, most recently from 7d112a5 to bbaf509 Compare September 25, 2025 14:10
@connortsui20 connortsui20 force-pushed the ct/list-view-canonicalize branch from bbaf509 to 727a639 Compare September 25, 2025 15:32
@codspeed-hq
Copy link

codspeed-hq bot commented Sep 25, 2025

CodSpeed Performance Report

Merging #4754 will degrade performances by 16.47%

Comparing ct/list-view-canonicalize (33047a0) with develop (a6cb059)

Summary

⚡ 4 improvements
❌ 1 regression
✅ 1151 untouched

⚠️ Please fix the performance issues or acknowledge them on CodSpeed.

Benchmarks breakdown

Benchmark BASE HEAD Change
new_bp_prim_test_between[i16, 16384] 76.7 µs 69.3 µs +10.73%
filter_runend[(1000, 256, 0.005)] 21.9 µs 19.9 µs +10.37%
filter_runend[(1000, 256, 0.03)] 22 µs 19.9 µs +10.35%
take_indices[(1000, 4, 0.01)] 19.3 µs 17 µs +13.64%
encode_specialized 1.1 ms 1.3 ms -16.47%

@connortsui20 connortsui20 force-pushed the ct/list-view-canonicalize branch from 727a639 to 2e149e8 Compare September 25, 2025 15:41
@connortsui20 connortsui20 added the action/benchmark-sql Trigger SQL benchmarks to run on this PR label Sep 25, 2025
@github-actions github-actions bot removed the action/benchmark-sql Trigger SQL benchmarks to run on this PR label Sep 25, 2025
@github-actions
Copy link
Contributor

github-actions bot commented Sep 25, 2025

Benchmarks: TPC-H SF=1 on NVME

Summary

  • Overall: 1.068x ➖
  • Vortex: 1.072x ➖
  • duckdb:vortex: 1.062x ➖
  • datafusion:vortex: 1.083x ➖
  • Best: tpch_q01/DuckDB:vortex-file-compressed (0.978x)
  • Worst: tpch_q03/DuckDB:vortex-compact (1.191x)
  • Significant (>10%): 0↑ 20↓
Detailed Results Table
name PR 33047a0 base a6cb059 ratio (PR/base) unit
tpch_q01/DataFusion:arrow 62795922 5.71747e+07 1.09832 ns
tpch_q02/DataFusion:arrow 18458037 1.75201e+07 1.05353 ns
tpch_q03/DataFusion:arrow 25288086 2.25139e+07 1.12322 ns
tpch_q04/DataFusion:arrow 12977007 1.17915e+07 1.10054 ns
tpch_q05/DataFusion:arrow 35494567 3.25405e+07 1.09078 ns
tpch_q06/DataFusion:arrow 8178868 8.79271e+06 0.930187 ns
tpch_q07/DataFusion:arrow 56754032 5.12221e+07 1.108 ns
tpch_q08/DataFusion:arrow 20891332 1.86604e+07 1.11956 ns
tpch_q09/DataFusion:arrow 34995319 3.16604e+07 1.10534 ns
tpch_q10/DataFusion:arrow 31526851 2.80827e+07 1.12264 ns
tpch_q11/DataFusion:arrow 39580713 3.88322e+07 1.01927 ns
tpch_q12/DataFusion:arrow 19886478 1.86828e+07 1.06443 ns
tpch_q13/DataFusion:arrow 18738109 1.7257e+07 1.08583 ns
tpch_q14/DataFusion:arrow 7649713 7.02991e+06 1.08817 ns
tpch_q15/DataFusion:arrow 14414413 1.26568e+07 1.13887 ns
tpch_q16/DataFusion:arrow 15687713 1.44708e+07 1.0841 ns
tpch_q17/DataFusion:arrow 54786728 4.83766e+07 1.13251 ns
tpch_q18/DataFusion:arrow 113666309 9.89602e+07 1.14861 ns
tpch_q19/DataFusion:arrow 18810107 1.62573e+07 1.15702 ns
tpch_q20/DataFusion:arrow 21998135 2.04622e+07 1.07506 ns
tpch_q21/DataFusion:arrow 85046201 7.46111e+07 1.13986 ns
tpch_q22/DataFusion:arrow 10813551 9.89682e+06 1.09263 ns
tpch_q01/DataFusion:parquet 158547146 1.53831e+08 1.03066 ns
tpch_q02/DataFusion:parquet 96764864 9.13953e+07 1.05875 ns
tpch_q03/DataFusion:parquet 80874448 8.57068e+07 0.943618 ns
tpch_q04/DataFusion:parquet 55657775 5.36156e+07 1.03809 ns
tpch_q05/DataFusion:parquet 101254534 1.01256e+08 0.999986 ns
tpch_q06/DataFusion:parquet 32879892 3.39715e+07 0.967867 ns
tpch_q07/DataFusion:parquet 131757934 1.19257e+08 1.10482 ns
tpch_q08/DataFusion:parquet 128572529 1.13956e+08 1.12827 ns
tpch_q09/DataFusion:parquet 155061655 1.49284e+08 1.03871 ns
tpch_q10/DataFusion:parquet 121579073 1.1242e+08 1.08147 ns
tpch_q11/DataFusion:parquet 74433605 6.74987e+07 1.10274 ns
tpch_q12/DataFusion:parquet 79276219 7.44038e+07 1.06549 ns
tpch_q13/DataFusion:parquet 203406264 1.92693e+08 1.0556 ns
tpch_q14/DataFusion:parquet 43811158 4.23722e+07 1.03396 ns
tpch_q15/DataFusion:parquet 60362310 5.42814e+07 1.11203 ns
tpch_q16/DataFusion:parquet 47883860 4.75989e+07 1.00599 ns
tpch_q17/DataFusion:parquet 147479103 1.3791e+08 1.06938 ns
tpch_q18/DataFusion:parquet 195637856 1.7307e+08 1.1304 ns
tpch_q19/DataFusion:parquet 82145710 8.6497e+07 0.949694 ns
tpch_q20/DataFusion:parquet 72801429 6.47035e+07 1.12515 ns
tpch_q21/DataFusion:parquet 150607227 1.3561e+08 1.11059 ns
tpch_q22/DataFusion:parquet 67453242 6.71236e+07 1.00491 ns
tpch_q01/DataFusion:vortex-file-compressed 55149727 5.36045e+07 1.02883 ns
tpch_q02/DataFusion:vortex-file-compressed 33377648 3.03364e+07 1.10025 ns
tpch_q03/DataFusion:vortex-file-compressed 23874713 2.22975e+07 1.07073 ns
tpch_q04/DataFusion:vortex-file-compressed 17130553 1.54648e+07 1.10771 ns
tpch_q05/DataFusion:vortex-file-compressed 62834746 5.78954e+07 1.08531 ns
tpch_q06/DataFusion:vortex-file-compressed 7712333 7.29154e+06 1.05771 ns
tpch_q07/DataFusion:vortex-file-compressed 70006828 6.71609e+07 1.04238 ns
tpch_q08/DataFusion:vortex-file-compressed 39743855 3.61136e+07 1.10052 ns
tpch_q09/DataFusion:vortex-file-compressed 50984314 5.05952e+07 1.00769 ns
tpch_q10/DataFusion:vortex-file-compressed 41078856 3.66651e+07 1.12038 ns
tpch_q11/DataFusion:vortex-file-compressed 21613082 1.99691e+07 1.08233 ns
tpch_q12/DataFusion:vortex-file-compressed 18303321 1.72429e+07 1.0615 ns
tpch_q13/DataFusion:vortex-file-compressed 25623589 2.39722e+07 1.06889 ns
tpch_q14/DataFusion:vortex-file-compressed 11774196 1.04726e+07 1.12428 ns
tpch_q15/DataFusion:vortex-file-compressed 19178509 1.7797e+07 1.07763 ns
tpch_q16/DataFusion:vortex-file-compressed 23387637 2.07595e+07 1.1266 ns
tpch_q17/DataFusion:vortex-file-compressed 62265069 5.76189e+07 1.08064 ns
tpch_q18/DataFusion:vortex-file-compressed 99411382 8.99421e+07 1.10528 ns
tpch_q19/DataFusion:vortex-file-compressed 18302985 1.65569e+07 1.10546 ns
tpch_q20/DataFusion:vortex-file-compressed 25946250 2.26281e+07 1.14664 ns
tpch_q21/DataFusion:vortex-file-compressed 74039659 6.8287e+07 1.08424 ns
tpch_q22/DataFusion:vortex-file-compressed 14146624 1.30192e+07 1.0866 ns
tpch_q01/DataFusion:vortex-compact 60957301 5.76788e+07 1.05684 ns
tpch_q02/DataFusion:vortex-compact 39699788 3.41816e+07 1.16144 ns
tpch_q03/DataFusion:vortex-compact 28680675 2.49342e+07 1.15025 ns
tpch_q04/DataFusion:vortex-compact 19544014 1.839e+07 1.06275 ns
tpch_q05/DataFusion:vortex-compact 66867367 5.98738e+07 1.11681 ns
tpch_q06/DataFusion:vortex-compact 12169743 1.1398e+07 1.06771 ns
tpch_q07/DataFusion:vortex-compact 78882653 7.12454e+07 1.1072 ns
tpch_q08/DataFusion:vortex-compact 44266809 3.85061e+07 1.14961 ns
tpch_q09/DataFusion:vortex-compact 59898368 5.44549e+07 1.09996 ns
tpch_q10/DataFusion:vortex-compact 45573587 4.15662e+07 1.09641 ns
tpch_q11/DataFusion:vortex-compact 22806281 2.14248e+07 1.06448 ns
tpch_q12/DataFusion:vortex-compact 27881210 2.6057e+07 1.07001 ns
tpch_q13/DataFusion:vortex-compact 31363592 3.02636e+07 1.03635 ns
tpch_q14/DataFusion:vortex-compact 16392001 1.57096e+07 1.04344 ns
tpch_q15/DataFusion:vortex-compact 30639943 2.8002e+07 1.09421 ns
tpch_q16/DataFusion:vortex-compact 26211538 2.39113e+07 1.0962 ns
tpch_q17/DataFusion:vortex-compact 69123394 6.36159e+07 1.08657 ns
tpch_q18/DataFusion:vortex-compact 98942605 9.09323e+07 1.08809 ns
tpch_q19/DataFusion:vortex-compact 30462966 3.01094e+07 1.01174 ns
tpch_q20/DataFusion:vortex-compact 29972197 2.83677e+07 1.05656 ns
tpch_q21/DataFusion:vortex-compact 79056686 7.5274e+07 1.05025 ns
tpch_q22/DataFusion:vortex-compact 15374881 1.48399e+07 1.03605 ns
tpch_q01/DuckDB:parquet 81206549 7.9915e+07 1.01616 ns
tpch_q02/DuckDB:parquet 50058635 4.59215e+07 1.09009 ns
tpch_q03/DuckDB:parquet 80297687 7.71403e+07 1.04093 ns
tpch_q04/DuckDB:parquet 62213771 6.00081e+07 1.03676 ns
tpch_q05/DuckDB:parquet 78359215 7.48669e+07 1.04665 ns
tpch_q06/DuckDB:parquet 22816533 2.23613e+07 1.02036 ns
tpch_q07/DuckDB:parquet 82527680 7.94217e+07 1.03911 ns
tpch_q08/DuckDB:parquet 99051052 9.61542e+07 1.03013 ns
tpch_q09/DuckDB:parquet 150589695 1.44942e+08 1.03896 ns
tpch_q10/DuckDB:parquet 144824809 1.37471e+08 1.05349 ns
tpch_q11/DuckDB:parquet 27433258 2.56508e+07 1.06949 ns
tpch_q12/DuckDB:parquet 60344690 5.84569e+07 1.03229 ns
tpch_q13/DuckDB:parquet 296509341 2.72579e+08 1.08779 ns
tpch_q14/DuckDB:parquet 54487936 5.39465e+07 1.01004 ns
tpch_q15/DuckDB:parquet 29826547 2.9008e+07 1.02822 ns
tpch_q16/DuckDB:parquet 60585540 5.86025e+07 1.03384 ns
tpch_q17/DuckDB:parquet 69797527 6.37862e+07 1.09424 ns
tpch_q18/DuckDB:parquet 127333168 1.2332e+08 1.03254 ns
tpch_q19/DuckDB:parquet 74230199 7.03795e+07 1.05471 ns
tpch_q20/DuckDB:parquet 76080258 6.24061e+07 1.21912 ns
tpch_q21/DuckDB:parquet 202879726 1.91286e+08 1.06061 ns
tpch_q22/DuckDB:parquet 58032064 5.49089e+07 1.05688 ns
tpch_q01/DuckDB:vortex-file-compressed 28298194 2.89447e+07 0.977666 ns
tpch_q02/DuckDB:vortex-file-compressed 28874660 2.63846e+07 1.09437 ns
tpch_q03/DuckDB:vortex-file-compressed 30365706 2.92924e+07 1.03664 ns
tpch_q04/DuckDB:vortex-file-compressed 28790549 2.77704e+07 1.03674 ns
tpch_q05/DuckDB:vortex-file-compressed 39698734 3.8083e+07 1.04243 ns
tpch_q06/DuckDB:vortex-file-compressed 7580162 7.01857e+06 1.08002 ns
tpch_q07/DuckDB:vortex-file-compressed 34341110 3.27347e+07 1.04907 ns
tpch_q08/DuckDB:vortex-file-compressed 45098887 4.21133e+07 1.07089 ns
tpch_q09/DuckDB:vortex-file-compressed 59299325 5.84725e+07 1.01414 ns
tpch_q10/DuckDB:vortex-file-compressed 39801638 3.78469e+07 1.05165 ns
tpch_q11/DuckDB:vortex-file-compressed 16103325 1.54721e+07 1.0408 ns
tpch_q12/DuckDB:vortex-file-compressed 30861459 2.95878e+07 1.04305 ns
tpch_q13/DuckDB:vortex-file-compressed 38714006 3.66773e+07 1.05553 ns
tpch_q14/DuckDB:vortex-file-compressed 22872024 2.15189e+07 1.06288 ns
tpch_q15/DuckDB:vortex-file-compressed 12038667 1.17084e+07 1.02821 ns
tpch_q16/DuckDB:vortex-file-compressed 30826609 2.94572e+07 1.04649 ns
tpch_q17/DuckDB:vortex-file-compressed 70686160 6.89956e+07 1.0245 ns
tpch_q18/DuckDB:vortex-file-compressed 51087005 4.71154e+07 1.0843 ns
tpch_q19/DuckDB:vortex-file-compressed 25866814 2.39864e+07 1.07839 ns
tpch_q20/DuckDB:vortex-file-compressed 26963098 2.64722e+07 1.01855 ns
tpch_q21/DuckDB:vortex-file-compressed 109756453 1.02223e+08 1.0737 ns
tpch_q22/DuckDB:vortex-file-compressed 21877272 1.90687e+07 1.14729 ns
tpch_q01/DuckDB:vortex-compact 33533481 3.10825e+07 1.07885 ns
tpch_q02/DuckDB:vortex-compact 38399295 3.70627e+07 1.03606 ns
tpch_q03/DuckDB:vortex-compact 39091835 3.28108e+07 1.19143 ns
tpch_q04/DuckDB:vortex-compact 33637271 3.11638e+07 1.07937 ns
tpch_q05/DuckDB:vortex-compact 44645452 4.15015e+07 1.07575 ns
tpch_q06/DuckDB:vortex-compact 12153964 1.10172e+07 1.10319 ns
tpch_q07/DuckDB:vortex-compact 43691358 4.18774e+07 1.04332 ns
tpch_q08/DuckDB:vortex-compact 54659271 5.21612e+07 1.04789 ns
tpch_q09/DuckDB:vortex-compact 68218363 6.454e+07 1.05699 ns
tpch_q10/DuckDB:vortex-compact 48492489 4.60559e+07 1.0529 ns
tpch_q11/DuckDB:vortex-compact 21536785 2.00946e+07 1.07177 ns
tpch_q12/DuckDB:vortex-compact 41843189 4.019e+07 1.04113 ns
tpch_q13/DuckDB:vortex-compact 44614033 4.27313e+07 1.04406 ns
tpch_q14/DuckDB:vortex-compact 27905217 2.71768e+07 1.0268 ns
tpch_q15/DuckDB:vortex-compact 16145575 1.53281e+07 1.05333 ns
tpch_q16/DuckDB:vortex-compact 36315236 3.37029e+07 1.07751 ns
tpch_q17/DuckDB:vortex-compact 75753800 7.04977e+07 1.07456 ns
tpch_q18/DuckDB:vortex-compact 56623637 5.39849e+07 1.04888 ns
tpch_q19/DuckDB:vortex-compact 32082805 2.82616e+07 1.13521 ns
tpch_q20/DuckDB:vortex-compact 37230892 3.32527e+07 1.11964 ns
tpch_q21/DuckDB:vortex-compact 113696213 1.09649e+08 1.03691 ns
tpch_q22/DuckDB:vortex-compact 22889420 2.06988e+07 1.10584 ns
tpch_q01/DuckDB:duckdb 17732902 1.73884e+07 1.01981 ns
tpch_q02/DuckDB:duckdb 15357905 1.38155e+07 1.11164 ns
tpch_q03/DuckDB:duckdb 22275566 2.1783e+07 1.02261 ns
tpch_q04/DuckDB:duckdb 20510536 1.91548e+07 1.07078 ns
tpch_q05/DuckDB:duckdb 24239438 2.23946e+07 1.08238 ns
tpch_q06/DuckDB:duckdb 7683586 7.12965e+06 1.07769 ns
tpch_q07/DuckDB:duckdb 27983922 2.63435e+07 1.06227 ns
tpch_q08/DuckDB:duckdb 26901197 2.64068e+07 1.01872 ns
tpch_q09/DuckDB:duckdb 63896767 5.86161e+07 1.09009 ns
tpch_q10/DuckDB:duckdb 65903794 6.16226e+07 1.06947 ns
tpch_q11/DuckDB:duckdb 7569749 6.97723e+06 1.08492 ns
tpch_q12/DuckDB:duckdb 18426528 1.74694e+07 1.05479 ns
tpch_q13/DuckDB:duckdb 41415320 3.95765e+07 1.04646 ns
tpch_q14/DuckDB:duckdb 23295300 2.20506e+07 1.05645 ns
tpch_q15/DuckDB:duckdb 12698686 1.21112e+07 1.04851 ns
tpch_q16/DuckDB:duckdb 26443816 2.45398e+07 1.07759 ns
tpch_q17/DuckDB:duckdb 18622101 1.79932e+07 1.03495 ns
tpch_q18/DuckDB:duckdb 40080787 3.94882e+07 1.01501 ns
tpch_q19/DuckDB:duckdb 32719179 3.16083e+07 1.03514 ns
tpch_q20/DuckDB:duckdb 23348327 2.25186e+07 1.03685 ns
tpch_q21/DuckDB:duckdb 65683055 6.19825e+07 1.0597 ns
tpch_q22/DuckDB:duckdb 28138530 2.61282e+07 1.07694 ns

@github-actions
Copy link
Contributor

github-actions bot commented Sep 25, 2025

Benchmarks: TPC-H SF=1 on S3

Summary

  • Overall: 0.993x ➖
  • Vortex: 0.988x ➖
  • duckdb:vortex: 0.978x ➖
  • datafusion:vortex: 0.998x ➖
  • Best: tpch_q13/DataFusion:vortex-compact (0.719x)
  • Worst: tpch_q01/DataFusion:vortex-file-compressed (1.144x)
  • Significant (>30%): 0↑ 0↓
Detailed Results Table
name PR 33047a0 base a6cb059 ratio (PR/base) unit
tpch_q01/DataFusion:parquet 242661504 2.43045e+08 0.998421 ns
tpch_q02/DataFusion:parquet 358786317 3.42866e+08 1.04643 ns
tpch_q03/DataFusion:parquet 282558967 2.8594e+08 0.988175 ns
tpch_q04/DataFusion:parquet 135940008 1.37195e+08 0.990851 ns
tpch_q05/DataFusion:parquet 354775024 3.75962e+08 0.943647 ns
tpch_q06/DataFusion:parquet 126905810 1.27541e+08 0.995024 ns
tpch_q07/DataFusion:parquet 398705449 3.87865e+08 1.02795 ns
tpch_q08/DataFusion:parquet 460510784 4.63008e+08 0.994606 ns
tpch_q09/DataFusion:parquet 416583612 4.33607e+08 0.96074 ns
tpch_q10/DataFusion:parquet 438730239 4.36676e+08 1.0047 ns
tpch_q11/DataFusion:parquet 290423687 2.75781e+08 1.0531 ns
tpch_q12/DataFusion:parquet 209189330 2.07799e+08 1.00669 ns
tpch_q13/DataFusion:parquet 426831709 4.2267e+08 1.00985 ns
tpch_q14/DataFusion:parquet 152927838 1.55106e+08 0.985958 ns
tpch_q15/DataFusion:parquet 271304611 2.75447e+08 0.984962 ns
tpch_q16/DataFusion:parquet 191090613 1.77565e+08 1.07617 ns
tpch_q17/DataFusion:parquet 314198693 3.24264e+08 0.968959 ns
tpch_q18/DataFusion:parquet 425954888 4.10159e+08 1.03851 ns
tpch_q19/DataFusion:parquet 286418701 2.85798e+08 1.00217 ns
tpch_q20/DataFusion:parquet 265976393 2.54821e+08 1.04378 ns
tpch_q21/DataFusion:parquet 398245190 4.14651e+08 0.960435 ns
tpch_q22/DataFusion:parquet 161747411 1.622e+08 0.997207 ns
tpch_q01/DataFusion:vortex-file-compressed 178455579 1.55959e+08 1.14424 ns
tpch_q02/DataFusion:vortex-file-compressed 195037117 2.06429e+08 0.944814 ns
tpch_q03/DataFusion:vortex-file-compressed 290514893 3.07308e+08 0.945354 ns
tpch_q04/DataFusion:vortex-file-compressed 160352046 1.49069e+08 1.07569 ns
tpch_q05/DataFusion:vortex-file-compressed 210933895 1.99789e+08 1.05578 ns
tpch_q06/DataFusion:vortex-file-compressed 153196088 1.53543e+08 0.997742 ns
tpch_q07/DataFusion:vortex-file-compressed 183615945 2.2065e+08 0.832159 ns
tpch_q08/DataFusion:vortex-file-compressed 293726300 3.04524e+08 0.964542 ns
tpch_q09/DataFusion:vortex-file-compressed 254021184 2.65626e+08 0.956313 ns
tpch_q10/DataFusion:vortex-file-compressed 244040275 2.78675e+08 0.875718 ns
tpch_q11/DataFusion:vortex-file-compressed 106658504 9.36086e+07 1.13941 ns
tpch_q12/DataFusion:vortex-file-compressed 215359561 2.16138e+08 0.996398 ns
tpch_q13/DataFusion:vortex-file-compressed 229966133 2.34162e+08 0.98208 ns
tpch_q14/DataFusion:vortex-file-compressed 112905156 1.13446e+08 0.995233 ns
tpch_q15/DataFusion:vortex-file-compressed 177826579 1.68673e+08 1.05427 ns
tpch_q16/DataFusion:vortex-file-compressed 154615786 1.46432e+08 1.05589 ns
tpch_q17/DataFusion:vortex-file-compressed 264627518 2.78049e+08 0.951729 ns
tpch_q18/DataFusion:vortex-file-compressed 222409253 2.22021e+08 1.00175 ns
tpch_q19/DataFusion:vortex-file-compressed 276006628 2.92212e+08 0.944543 ns
tpch_q20/DataFusion:vortex-file-compressed 196602967 1.86197e+08 1.05588 ns
tpch_q21/DataFusion:vortex-file-compressed 311576532 3.25888e+08 0.956084 ns
tpch_q22/DataFusion:vortex-file-compressed 144116052 1.45767e+08 0.988676 ns
tpch_q01/DataFusion:vortex-compact 171732516 1.73703e+08 0.988654 ns
tpch_q02/DataFusion:vortex-compact 185436550 1.86731e+08 0.993068 ns
tpch_q03/DataFusion:vortex-compact 301477330 3.09192e+08 0.97505 ns
tpch_q04/DataFusion:vortex-compact 142057994 1.45777e+08 0.974487 ns
tpch_q05/DataFusion:vortex-compact 183581426 1.89226e+08 0.970168 ns
tpch_q06/DataFusion:vortex-compact 199616094 1.82078e+08 1.09632 ns
tpch_q07/DataFusion:vortex-compact 175792134 1.78298e+08 0.985948 ns
tpch_q08/DataFusion:vortex-compact 256592027 2.53977e+08 1.0103 ns
tpch_q09/DataFusion:vortex-compact 283295757 2.78979e+08 1.01547 ns
tpch_q10/DataFusion:vortex-compact 285707300 2.5558e+08 1.11788 ns
tpch_q11/DataFusion:vortex-compact 85608715 7.75551e+07 1.10384 ns
tpch_q12/DataFusion:vortex-compact 274976180 3.04788e+08 0.902189 ns
tpch_q13/DataFusion:vortex-compact 100605799 1.39958e+08 0.718829 ns
tpch_q14/DataFusion:vortex-compact 121913045 1.16226e+08 1.04893 ns
tpch_q15/DataFusion:vortex-compact 181263209 1.70198e+08 1.06502 ns
tpch_q16/DataFusion:vortex-compact 147050537 1.48524e+08 0.990078 ns
tpch_q17/DataFusion:vortex-compact 277298166 2.55323e+08 1.08607 ns
tpch_q18/DataFusion:vortex-compact 201801887 2.08471e+08 0.96801 ns
tpch_q19/DataFusion:vortex-compact 330092675 3.16334e+08 1.0435 ns
tpch_q20/DataFusion:vortex-compact 185222868 1.79158e+08 1.03385 ns
tpch_q21/DataFusion:vortex-compact 347244727 3.43578e+08 1.01067 ns
tpch_q22/DataFusion:vortex-compact 151343151 1.44187e+08 1.04963 ns
tpch_q01/DuckDB:parquet 419947932 4.1627e+08 1.00884 ns
tpch_q02/DuckDB:parquet 977489490 9.41087e+08 1.03868 ns
tpch_q03/DuckDB:parquet 706964800 7.37686e+08 0.958355 ns
tpch_q04/DuckDB:parquet 493713547 4.42243e+08 1.11639 ns
tpch_q05/DuckDB:parquet 1148145029 1.013e+09 1.13341 ns
tpch_q06/DuckDB:parquet 300369919 2.86216e+08 1.04945 ns
tpch_q07/DuckDB:parquet 894177654 8.79824e+08 1.01631 ns
tpch_q08/DuckDB:parquet 1159884649 1.1302e+09 1.02626 ns
tpch_q09/DuckDB:parquet 967601413 1.0222e+09 0.946584 ns
tpch_q10/DuckDB:parquet 1067590166 1.03171e+09 1.03478 ns
tpch_q11/DuckDB:parquet 618891795 6.60717e+08 0.936698 ns
tpch_q12/DuckDB:parquet 398369934 4.13912e+08 0.96245 ns
tpch_q13/DuckDB:parquet 780537638 7.61685e+08 1.02475 ns
tpch_q14/DuckDB:parquet 470939139 4.60452e+08 1.02277 ns
tpch_q15/DuckDB:parquet 466962778 5.15605e+08 0.90566 ns
tpch_q16/DuckDB:parquet 387908271 3.59377e+08 1.07939 ns
tpch_q17/DuckDB:parquet 583790869 5.69051e+08 1.0259 ns
tpch_q18/DuckDB:parquet 593579022 6.47257e+08 0.917069 ns
tpch_q19/DuckDB:parquet 609707042 6.35637e+08 0.959206 ns
tpch_q20/DuckDB:parquet 793221228 7.25114e+08 1.09393 ns
tpch_q21/DuckDB:parquet 820027076 8.24482e+08 0.994597 ns
tpch_q22/DuckDB:parquet 322608604 3.50363e+08 0.920784 ns
tpch_q01/DuckDB:vortex-file-compressed 200467133 2.44723e+08 0.81916 ns
tpch_q02/DuckDB:vortex-file-compressed 733079202 7.2886e+08 1.00579 ns
tpch_q03/DuckDB:vortex-file-compressed 518593616 5.31894e+08 0.974994 ns
tpch_q04/DuckDB:vortex-file-compressed 274674104 2.9886e+08 0.919074 ns
tpch_q05/DuckDB:vortex-file-compressed 528940650 5.14544e+08 1.02798 ns
tpch_q06/DuckDB:vortex-file-compressed 247769685 2.29186e+08 1.08108 ns
tpch_q07/DuckDB:vortex-file-compressed 608548090 6.10716e+08 0.996451 ns
tpch_q08/DuckDB:vortex-file-compressed 775023684 8.04942e+08 0.962831 ns
tpch_q09/DuckDB:vortex-file-compressed 653807723 6.65547e+08 0.982361 ns
tpch_q10/DuckDB:vortex-file-compressed 571814159 5.40175e+08 1.05857 ns
tpch_q11/DuckDB:vortex-file-compressed 440263147 4.35706e+08 1.01046 ns
tpch_q12/DuckDB:vortex-file-compressed 469046569 4.61773e+08 1.01575 ns
tpch_q13/DuckDB:vortex-file-compressed 278966155 2.65493e+08 1.05075 ns
tpch_q14/DuckDB:vortex-file-compressed 272974624 3.00181e+08 0.909368 ns
tpch_q15/DuckDB:vortex-file-compressed 213746855 2.11237e+08 1.01188 ns
tpch_q16/DuckDB:vortex-file-compressed 330960105 3.49342e+08 0.94738 ns
tpch_q17/DuckDB:vortex-file-compressed 434856163 4.419e+08 0.98406 ns
tpch_q18/DuckDB:vortex-file-compressed 453965146 4.79809e+08 0.946137 ns
tpch_q19/DuckDB:vortex-file-compressed 355418564 3.58197e+08 0.992245 ns
tpch_q20/DuckDB:vortex-file-compressed 535330138 5.46485e+08 0.979589 ns
tpch_q21/DuckDB:vortex-file-compressed 647148660 6.74396e+08 0.959598 ns
tpch_q22/DuckDB:vortex-file-compressed 270600510 2.90877e+08 0.930292 ns
tpch_q01/DuckDB:vortex-compact 220708297 1.98803e+08 1.11019 ns
tpch_q02/DuckDB:vortex-compact 721518584 7.10547e+08 1.01544 ns
tpch_q03/DuckDB:vortex-compact 507635136 5.09181e+08 0.996964 ns
tpch_q04/DuckDB:vortex-compact 263869904 2.98523e+08 0.883917 ns
tpch_q05/DuckDB:vortex-compact 535122678 5.2547e+08 1.01837 ns
tpch_q06/DuckDB:vortex-compact 234505963 2.35729e+08 0.994811 ns
tpch_q07/DuckDB:vortex-compact 597747404 6.14542e+08 0.972671 ns
tpch_q08/DuckDB:vortex-compact 766978656 7.83145e+08 0.979358 ns
tpch_q09/DuckDB:vortex-compact 648077640 6.26958e+08 1.03369 ns
tpch_q10/DuckDB:vortex-compact 512110875 5.16614e+08 0.991283 ns
tpch_q11/DuckDB:vortex-compact 420654777 4.30662e+08 0.976763 ns
tpch_q12/DuckDB:vortex-compact 442020247 4.47636e+08 0.987455 ns
tpch_q13/DuckDB:vortex-compact 246587648 2.54372e+08 0.969399 ns
tpch_q14/DuckDB:vortex-compact 272870657 2.74219e+08 0.995084 ns
tpch_q15/DuckDB:vortex-compact 203260179 2.15286e+08 0.94414 ns
tpch_q16/DuckDB:vortex-compact 318618211 3.56864e+08 0.892829 ns
tpch_q17/DuckDB:vortex-compact 390961959 4.42939e+08 0.882655 ns
tpch_q18/DuckDB:vortex-compact 458943678 4.69434e+08 0.977654 ns
tpch_q19/DuckDB:vortex-compact 342558177 3.37225e+08 1.01582 ns
tpch_q20/DuckDB:vortex-compact 486112623 5.347e+08 0.909132 ns
tpch_q21/DuckDB:vortex-compact 642568588 6.6128e+08 0.971704 ns
tpch_q22/DuckDB:vortex-compact 260090617 2.60117e+08 0.9999 ns

@github-actions
Copy link
Contributor

github-actions bot commented Sep 25, 2025

Benchmarks: TPC-H SF=10 on NVME

Summary

  • Overall: 0.996x ➖
  • Vortex: 0.999x ➖
  • duckdb:vortex: 0.997x ➖
  • datafusion:vortex: 1.000x ➖
  • Best: tpch_q01/DataFusion:vortex-compact (0.961x)
  • Worst: tpch_q09/DataFusion:vortex-compact (1.064x)
  • Significant (>10%): 0↑ 0↓
Detailed Results Table
name PR 33047a0 base a6cb059 ratio (PR/base) unit
tpch_q01/DataFusion:arrow 484059938 4.81432e+08 1.00546 ns
tpch_q02/DataFusion:arrow 92911229 9.30602e+07 0.998399 ns
tpch_q03/DataFusion:arrow 179897707 1.82951e+08 0.983309 ns
tpch_q04/DataFusion:arrow 87686463 8.84638e+07 0.991213 ns
tpch_q05/DataFusion:arrow 340066875 3.46274e+08 0.982075 ns
tpch_q06/DataFusion:arrow 58793689 6.07377e+07 0.967993 ns
tpch_q07/DataFusion:arrow 636995347 6.40124e+08 0.995113 ns
tpch_q08/DataFusion:arrow 278061365 2.82007e+08 0.986009 ns
tpch_q09/DataFusion:arrow 561376919 5.70258e+08 0.984426 ns
tpch_q10/DataFusion:arrow 228765567 2.34672e+08 0.974832 ns
tpch_q11/DataFusion:arrow 384046804 3.82122e+08 1.00504 ns
tpch_q12/DataFusion:arrow 185880977 1.77185e+08 1.04908 ns
tpch_q13/DataFusion:arrow 188333117 1.87701e+08 1.00337 ns
tpch_q14/DataFusion:arrow 51334217 5.19804e+07 0.987569 ns
tpch_q15/DataFusion:arrow 97228065 1.00428e+08 0.968135 ns
tpch_q16/DataFusion:arrow 73142413 7.24912e+07 1.00898 ns
tpch_q17/DataFusion:arrow 579944576 5.77653e+08 1.00397 ns
tpch_q18/DataFusion:arrow 1336246674 1.34867e+09 0.990787 ns
tpch_q19/DataFusion:arrow 108618974 1.06184e+08 1.02293 ns
tpch_q20/DataFusion:arrow 164336140 1.64676e+08 0.997936 ns
tpch_q21/DataFusion:arrow 861313833 8.98799e+08 0.958294 ns
tpch_q22/DataFusion:arrow 51498742 5.09772e+07 1.01023 ns
tpch_q01/DataFusion:parquet 670251529 6.70156e+08 1.00014 ns
tpch_q02/DataFusion:parquet 206902418 1.98466e+08 1.04251 ns
tpch_q03/DataFusion:parquet 289827155 2.88018e+08 1.00628 ns
tpch_q04/DataFusion:parquet 197847860 2.01315e+08 0.982777 ns
tpch_q05/DataFusion:parquet 452073012 4.52976e+08 0.998007 ns
tpch_q06/DataFusion:parquet 104803064 1.13316e+08 0.924878 ns
tpch_q07/DataFusion:parquet 665101475 6.70393e+08 0.992107 ns
tpch_q08/DataFusion:parquet 508563297 5.14528e+08 0.988407 ns
tpch_q09/DataFusion:parquet 804142741 7.96857e+08 1.00914 ns
tpch_q10/DataFusion:parquet 494105744 5.01137e+08 0.98597 ns
tpch_q11/DataFusion:parquet 130457764 1.32121e+08 0.987408 ns
tpch_q12/DataFusion:parquet 191505460 1.97154e+08 0.971348 ns
tpch_q13/DataFusion:parquet 396426149 4.10297e+08 0.966192 ns
tpch_q14/DataFusion:parquet 144722253 1.45697e+08 0.99331 ns
tpch_q15/DataFusion:parquet 241008795 2.35406e+08 1.0238 ns
tpch_q16/DataFusion:parquet 145420433 1.43526e+08 1.0132 ns
tpch_q17/DataFusion:parquet 695543454 7.05826e+08 0.985432 ns
tpch_q18/DataFusion:parquet 1114806795 1.10202e+09 1.0116 ns
tpch_q19/DataFusion:parquet 260829636 2.78493e+08 0.936577 ns
tpch_q20/DataFusion:parquet 298550013 2.95833e+08 1.00919 ns
tpch_q21/DataFusion:parquet 847954193 8.49514e+08 0.998164 ns
tpch_q22/DataFusion:parquet 325833158 3.25753e+08 1.00025 ns
tpch_q01/DataFusion:vortex-file-compressed 467639819 4.63723e+08 1.00845 ns
tpch_q02/DataFusion:vortex-file-compressed 154395324 1.4623e+08 1.05584 ns
tpch_q03/DataFusion:vortex-file-compressed 221188537 2.16007e+08 1.02399 ns
tpch_q04/DataFusion:vortex-file-compressed 98527172 9.70848e+07 1.01486 ns
tpch_q05/DataFusion:vortex-file-compressed 541866874 5.5537e+08 0.975687 ns
tpch_q06/DataFusion:vortex-file-compressed 36635907 3.58495e+07 1.02194 ns
tpch_q07/DataFusion:vortex-file-compressed 567199750 5.70633e+08 0.993984 ns
tpch_q08/DataFusion:vortex-file-compressed 603186227 6.15036e+08 0.980733 ns
tpch_q09/DataFusion:vortex-file-compressed 1008416978 9.60829e+08 1.04953 ns
tpch_q10/DataFusion:vortex-file-compressed 248621735 2.51895e+08 0.987004 ns
tpch_q11/DataFusion:vortex-file-compressed 124937411 1.26192e+08 0.990058 ns
tpch_q12/DataFusion:vortex-file-compressed 94043657 9.54337e+07 0.985434 ns
tpch_q13/DataFusion:vortex-file-compressed 212738358 2.1501e+08 0.989433 ns
tpch_q14/DataFusion:vortex-file-compressed 54142982 5.21236e+07 1.03874 ns
tpch_q15/DataFusion:vortex-file-compressed 92633164 9.47919e+07 0.977227 ns
tpch_q16/DataFusion:vortex-file-compressed 84268893 8.46048e+07 0.99603 ns
tpch_q17/DataFusion:vortex-file-compressed 882331256 8.91176e+08 0.990075 ns
tpch_q18/DataFusion:vortex-file-compressed 1093946215 1.08161e+09 1.0114 ns
tpch_q19/DataFusion:vortex-file-compressed 66817781 6.6512e+07 1.0046 ns
tpch_q20/DataFusion:vortex-file-compressed 169632587 1.7288e+08 0.981217 ns
tpch_q21/DataFusion:vortex-file-compressed 743755514 7.49564e+08 0.992251 ns
tpch_q22/DataFusion:vortex-file-compressed 62891027 6.43282e+07 0.977659 ns
tpch_q01/DataFusion:vortex-compact 504472526 5.24855e+08 0.961166 ns
tpch_q02/DataFusion:vortex-compact 155072071 1.55542e+08 0.996978 ns
tpch_q03/DataFusion:vortex-compact 232189540 2.3419e+08 0.991456 ns
tpch_q04/DataFusion:vortex-compact 115371061 1.13088e+08 1.02019 ns
tpch_q05/DataFusion:vortex-compact 552524136 5.65543e+08 0.97698 ns
tpch_q06/DataFusion:vortex-compact 75088628 7.48175e+07 1.00362 ns
tpch_q07/DataFusion:vortex-compact 604410532 5.98366e+08 1.0101 ns
tpch_q08/DataFusion:vortex-compact 623739821 6.12497e+08 1.01836 ns
tpch_q09/DataFusion:vortex-compact 1024906635 9.63227e+08 1.06403 ns
tpch_q10/DataFusion:vortex-compact 287078594 2.86667e+08 1.00143 ns
tpch_q11/DataFusion:vortex-compact 129126789 1.28299e+08 1.00645 ns
tpch_q12/DataFusion:vortex-compact 156245529 1.58645e+08 0.984876 ns
tpch_q13/DataFusion:vortex-compact 261652969 2.62495e+08 0.99679 ns
tpch_q14/DataFusion:vortex-compact 85912734 8.76386e+07 0.980307 ns
tpch_q15/DataFusion:vortex-compact 167923601 1.70395e+08 0.985499 ns
tpch_q16/DataFusion:vortex-compact 86428801 8.92284e+07 0.968625 ns
tpch_q17/DataFusion:vortex-compact 884058754 8.92004e+08 0.991093 ns
tpch_q18/DataFusion:vortex-compact 1094155161 1.08978e+09 1.00401 ns
tpch_q19/DataFusion:vortex-compact 142721241 1.38105e+08 1.03343 ns
tpch_q20/DataFusion:vortex-compact 203836053 2.05349e+08 0.99263 ns
tpch_q21/DataFusion:vortex-compact 744824734 7.54335e+08 0.987393 ns
tpch_q22/DataFusion:vortex-compact 74769515 7.53925e+07 0.991736 ns
tpch_q01/DuckDB:parquet 259211244 2.56892e+08 1.00903 ns
tpch_q02/DuckDB:parquet 121030350 1.24065e+08 0.975542 ns
tpch_q03/DuckDB:parquet 224378173 2.17794e+08 1.03023 ns
tpch_q04/DuckDB:parquet 150991973 1.50848e+08 1.00096 ns
tpch_q05/DuckDB:parquet 227869122 2.30934e+08 0.986729 ns
tpch_q06/DuckDB:parquet 69640934 6.99191e+07 0.996022 ns
tpch_q07/DuckDB:parquet 212999917 2.15497e+08 0.988414 ns
tpch_q08/DuckDB:parquet 327800057 3.24655e+08 1.00969 ns
tpch_q09/DuckDB:parquet 472065501 4.85994e+08 0.97134 ns
tpch_q10/DuckDB:parquet 633998252 6.33423e+08 1.00091 ns
tpch_q11/DuckDB:parquet 43491394 5.54622e+07 0.784163 ns
tpch_q12/DuckDB:parquet 138848203 1.40267e+08 0.989888 ns
tpch_q13/DuckDB:parquet 406556787 4.06978e+08 0.998965 ns
tpch_q14/DuckDB:parquet 178513484 1.7762e+08 1.00503 ns
tpch_q15/DuckDB:parquet 106565946 1.0449e+08 1.01987 ns
tpch_q16/DuckDB:parquet 136176104 1.35458e+08 1.0053 ns
tpch_q17/DuckDB:parquet 204088908 2.0475e+08 0.99677 ns
tpch_q18/DuckDB:parquet 356908828 3.5364e+08 1.00924 ns
tpch_q19/DuckDB:parquet 279398203 2.78947e+08 1.00162 ns
tpch_q20/DuckDB:parquet 204805515 2.14806e+08 0.953446 ns
tpch_q21/DuckDB:parquet 580102730 5.78621e+08 1.00256 ns
tpch_q22/DuckDB:parquet 295676581 2.82358e+08 1.04717 ns
tpch_q01/DuckDB:vortex-file-compressed 190426278 1.91676e+08 0.99348 ns
tpch_q02/DuckDB:vortex-file-compressed 54888755 5.29823e+07 1.03598 ns
tpch_q03/DuckDB:vortex-file-compressed 119823092 1.20845e+08 0.991545 ns
tpch_q04/DuckDB:vortex-file-compressed 242556352 2.43989e+08 0.994129 ns
tpch_q05/DuckDB:vortex-file-compressed 156001496 1.57557e+08 0.990129 ns
tpch_q06/DuckDB:vortex-file-compressed 33713023 3.48128e+07 0.968409 ns
tpch_q07/DuckDB:vortex-file-compressed 139038879 1.42103e+08 0.978434 ns
tpch_q08/DuckDB:vortex-file-compressed 242382492 2.41923e+08 1.0019 ns
tpch_q09/DuckDB:vortex-file-compressed 395991253 3.98687e+08 0.99324 ns
tpch_q10/DuckDB:vortex-file-compressed 167217201 1.67801e+08 0.99652 ns
tpch_q11/DuckDB:vortex-file-compressed 34789248 3.42209e+07 1.01661 ns
tpch_q12/DuckDB:vortex-file-compressed 170710408 1.69253e+08 1.00861 ns
tpch_q13/DuckDB:vortex-file-compressed 234535971 2.35088e+08 0.997653 ns
tpch_q14/DuckDB:vortex-file-compressed 56926026 5.77072e+07 0.986464 ns
tpch_q15/DuckDB:vortex-file-compressed 47728945 4.86051e+07 0.981974 ns
tpch_q16/DuckDB:vortex-file-compressed 76293292 7.41852e+07 1.02842 ns
tpch_q17/DuckDB:vortex-file-compressed 443120545 4.44872e+08 0.996063 ns
tpch_q18/DuckDB:vortex-file-compressed 274033692 2.79301e+08 0.98114 ns
tpch_q19/DuckDB:vortex-file-compressed 75207322 7.6858e+07 0.978522 ns
tpch_q20/DuckDB:vortex-file-compressed 101214998 1.00226e+08 1.00987 ns
tpch_q21/DuckDB:vortex-file-compressed 951359756 9.53609e+08 0.997641 ns
tpch_q22/DuckDB:vortex-file-compressed 70403163 7.02574e+07 1.00207 ns
tpch_q01/DuckDB:vortex-compact 233818026 2.34267e+08 0.998082 ns
tpch_q02/DuckDB:vortex-compact 71035655 6.95104e+07 1.02194 ns
tpch_q03/DuckDB:vortex-compact 160225516 1.61038e+08 0.994957 ns
tpch_q04/DuckDB:vortex-compact 263564704 2.65459e+08 0.992865 ns
tpch_q05/DuckDB:vortex-compact 174971732 1.75436e+08 0.997352 ns
tpch_q06/DuckDB:vortex-compact 73629794 7.27494e+07 1.0121 ns
tpch_q07/DuckDB:vortex-compact 212227094 2.11261e+08 1.00457 ns
tpch_q08/DuckDB:vortex-compact 264354672 2.65893e+08 0.994213 ns
tpch_q09/DuckDB:vortex-compact 452738485 4.58398e+08 0.987653 ns
tpch_q10/DuckDB:vortex-compact 220408680 2.2123e+08 0.996288 ns
tpch_q11/DuckDB:vortex-compact 43571558 4.32e+07 1.0086 ns
tpch_q12/DuckDB:vortex-compact 256302052 2.5455e+08 1.00688 ns
tpch_q13/DuckDB:vortex-compact 296060064 2.96721e+08 0.997773 ns
tpch_q14/DuckDB:vortex-compact 90860684 9.36631e+07 0.970079 ns
tpch_q15/DuckDB:vortex-compact 87364109 8.88261e+07 0.983541 ns
tpch_q16/DuckDB:vortex-compact 84811114 8.50913e+07 0.996707 ns
tpch_q17/DuckDB:vortex-compact 461851970 4.66061e+08 0.990969 ns
tpch_q18/DuckDB:vortex-compact 330791841 3.26649e+08 1.01268 ns
tpch_q19/DuckDB:vortex-compact 109077536 1.09333e+08 0.997665 ns
tpch_q20/DuckDB:vortex-compact 148481671 1.49963e+08 0.990125 ns
tpch_q21/DuckDB:vortex-compact 1003052835 1.01124e+09 0.991905 ns
tpch_q22/DuckDB:vortex-compact 80976912 8.06411e+07 1.00416 ns
tpch_q01/DuckDB:duckdb 117774859 1.16449e+08 1.01139 ns
tpch_q02/DuckDB:duckdb 49351959 5.00274e+07 0.986498 ns
tpch_q03/DuckDB:duckdb 100530599 1.00874e+08 0.996591 ns
tpch_q04/DuckDB:duckdb 120521828 1.19973e+08 1.00458 ns
tpch_q05/DuckDB:duckdb 111010988 1.12178e+08 0.989601 ns
tpch_q06/DuckDB:duckdb 45155336 4.50721e+07 1.00185 ns
tpch_q07/DuckDB:duckdb 109287247 1.09301e+08 0.999872 ns
tpch_q08/DuckDB:duckdb 139927530 1.39791e+08 1.00098 ns
tpch_q09/DuckDB:duckdb 298681909 3.03249e+08 0.98494 ns
tpch_q10/DuckDB:duckdb 213785906 2.12279e+08 1.0071 ns
tpch_q11/DuckDB:duckdb 22412662 2.21795e+07 1.01051 ns
tpch_q12/DuckDB:duckdb 85154528 8.58006e+07 0.99247 ns
tpch_q13/DuckDB:duckdb 234853041 2.32543e+08 1.00993 ns
tpch_q14/DuckDB:duckdb 78706466 7.8453e+07 1.00323 ns
tpch_q15/DuckDB:duckdb 67597935 6.77257e+07 0.998114 ns
tpch_q16/DuckDB:duckdb 72748197 7.28573e+07 0.998502 ns
tpch_q17/DuckDB:duckdb 99067249 9.9502e+07 0.99563 ns
tpch_q18/DuckDB:duckdb 215967223 2.16651e+08 0.996842 ns
tpch_q19/DuckDB:duckdb 128138833 1.2835e+08 0.998355 ns
tpch_q20/DuckDB:duckdb 98103398 9.8245e+07 0.998559 ns
tpch_q21/DuckDB:duckdb 304013105 3.10373e+08 0.97951 ns
tpch_q22/DuckDB:duckdb 65174123 6.73837e+07 0.967209 ns

@github-actions
Copy link
Contributor

github-actions bot commented Sep 25, 2025

Benchmarks: Statistical and Population Genetics

Summary

  • Overall: 1.673x ❌
  • Vortex: 2.161x ❌
  • duckdb:vortex: 2.161x ❌
  • Best: statpopgen_q00/DuckDB:vortex-file-compressed (0.974x)
  • Worst: statpopgen_q08/DuckDB:vortex-compact (97.051x)
  • Significant (>10%): 0↑ 17↓
Detailed Results Table
name PR 33047a0 base a6cb059 ratio (PR/base) unit
statpopgen_q00/DuckDB:parquet 193107282 1.97303e+08 0.978736 ns
statpopgen_q01/DuckDB:parquet 330163867 3.33788e+08 0.989144 ns
statpopgen_q02/DuckDB:parquet 641498795 6.51927e+08 0.984004 ns
statpopgen_q03/DuckDB:parquet 1067815130 1.06949e+09 0.998437 ns
statpopgen_q04/DuckDB:parquet 1067131930 1.06976e+09 0.997546 ns
statpopgen_q05/DuckDB:parquet 691928858 6.87953e+08 1.00578 ns
statpopgen_q06/DuckDB:parquet 1274304826 1.25784e+09 1.01309 ns
statpopgen_q07/DuckDB:parquet 834108191 8.12036e+08 1.02718 ns
statpopgen_q08/DuckDB:parquet 817497457 8.06437e+08 1.01372 ns
statpopgen_q09/DuckDB:parquet 901457389 8.93135e+08 1.00932 ns
statpopgen_q10/DuckDB:parquet 2076299040 2.03321e+09 1.02119 ns
statpopgen_q00/DuckDB:vortex-file-compressed 11835253 1.21472e+07 0.974322 ns
statpopgen_q01/DuckDB:vortex-file-compressed 245857100 1.38679e+08 1.77285 ns
statpopgen_q02/DuckDB:vortex-file-compressed 1198570582 4.81684e+08 2.48829 ns
statpopgen_q03/DuckDB:vortex-file-compressed 2809180878 1.06911e+09 2.62758 ns
statpopgen_q04/DuckDB:vortex-file-compressed 2797657182 1.07795e+09 2.59534 ns
statpopgen_q05/DuckDB:vortex-file-compressed 1279166853 5.19388e+08 2.46283 ns
statpopgen_q06/DuckDB:vortex-file-compressed 1974980868 1.50321e+09 1.31384 ns
statpopgen_q07/DuckDB:vortex-file-compressed 866801936 3.3068e+08 2.62127 ns
statpopgen_q08/DuckDB:vortex-file-compressed 1168267169 3.44771e+08 3.38853 ns
statpopgen_q09/DuckDB:vortex-file-compressed 2589072476 8.09067e+08 3.20007 ns
statpopgen_q10/DuckDB:vortex-file-compressed 4169933017 2.52741e+09 1.64988 ns
statpopgen_q00/DuckDB:vortex-compact 12910925 1.21781e+07 1.06017 ns
statpopgen_q01/DuckDB:vortex-compact 363700557 2.88938e+08 1.25875 ns
statpopgen_q02/DuckDB:vortex-compact 694818144 6.46287e+08 1.07509 ns
statpopgen_q03/DuckDB:vortex-compact 2382723516 1.22277e+09 1.94863 ns
statpopgen_q04/DuckDB:vortex-compact 2366410267 1.21821e+09 1.94254 ns
statpopgen_q05/DuckDB:vortex-compact 718162677 6.65746e+08 1.07873 ns
statpopgen_q06/DuckDB:vortex-compact 1641171516 1.59262e+09 1.03049 ns
statpopgen_q07/DuckDB:vortex-compact 3248325259 1.18368e+09 2.74426 ns
statpopgen_q08/DuckDB:vortex-compact 134802440637 1.38899e+09 97.051 ns
statpopgen_q09/DuckDB:vortex-compact 2145053179 9.78184e+08 2.19289 ns
statpopgen_q10/DuckDB:vortex-compact 3890143807 2.66092e+09 1.46195 ns

@github-actions
Copy link
Contributor

github-actions bot commented Sep 25, 2025

Benchmarks: TPC-H SF=10 on S3

Summary

  • Overall: 0.998x ➖
  • Vortex: 1.009x ➖
  • duckdb:vortex: 1.010x ➖
  • datafusion:vortex: 1.008x ➖
  • Best: tpch_q15/DataFusion:vortex-file-compressed (0.871x)
  • Worst: tpch_q04/DataFusion:vortex-compact (1.215x)
  • Significant (>30%): 0↑ 0↓
Detailed Results Table
name PR 33047a0 base a6cb059 ratio (PR/base) unit
tpch_q01/DataFusion:parquet 1080909936 1.16836e+09 0.925149 ns
tpch_q02/DataFusion:parquet 598681312 6.10537e+08 0.980581 ns
tpch_q03/DataFusion:parquet 856502199 7.96559e+08 1.07525 ns
tpch_q04/DataFusion:parquet 493546562 5.2313e+08 0.943449 ns
tpch_q05/DataFusion:parquet 955306013 9.79333e+08 0.975466 ns
tpch_q06/DataFusion:parquet 487174728 5.18567e+08 0.939464 ns
tpch_q07/DataFusion:parquet 1244041838 1.2647e+09 0.983666 ns
tpch_q08/DataFusion:parquet 1278866342 1.32718e+09 0.963598 ns
tpch_q09/DataFusion:parquet 1614191421 1.64352e+09 0.982157 ns
tpch_q10/DataFusion:parquet 1817365343 1.84237e+09 0.986429 ns
tpch_q11/DataFusion:parquet 389313907 3.98669e+08 0.976534 ns
tpch_q12/DataFusion:parquet 527146607 6.10264e+08 0.863801 ns
tpch_q13/DataFusion:parquet 703127836 7.19221e+08 0.977625 ns
tpch_q14/DataFusion:parquet 682555803 7.09592e+08 0.961899 ns
tpch_q15/DataFusion:parquet 1195693012 1.19329e+09 1.00201 ns
tpch_q16/DataFusion:parquet 319908388 3.38135e+08 0.946097 ns
tpch_q17/DataFusion:parquet 1199435595 1.32996e+09 0.901856 ns
tpch_q18/DataFusion:parquet 1618130366 1.72274e+09 0.939277 ns
tpch_q19/DataFusion:parquet 882813573 8.72549e+08 1.01176 ns
tpch_q20/DataFusion:parquet 952313364 9.65925e+08 0.985908 ns
tpch_q21/DataFusion:parquet 1609755497 1.67906e+09 0.958726 ns
tpch_q22/DataFusion:parquet 745715770 7.49446e+08 0.995023 ns
tpch_q01/DataFusion:vortex-file-compressed 728592453 7.64495e+08 0.953038 ns
tpch_q02/DataFusion:vortex-file-compressed 470771692 4.76125e+08 0.988756 ns
tpch_q03/DataFusion:vortex-file-compressed 864598927 8.48992e+08 1.01838 ns
tpch_q04/DataFusion:vortex-file-compressed 493807417 4.84231e+08 1.01978 ns
tpch_q05/DataFusion:vortex-file-compressed 1031061685 1.10145e+09 0.936092 ns
tpch_q06/DataFusion:vortex-file-compressed 536963830 5.14296e+08 1.04407 ns
tpch_q07/DataFusion:vortex-file-compressed 902946294 9.64164e+08 0.936507 ns
tpch_q08/DataFusion:vortex-file-compressed 1239199225 1.23477e+09 1.00359 ns
tpch_q09/DataFusion:vortex-file-compressed 1525652421 1.58867e+09 0.960333 ns
tpch_q10/DataFusion:vortex-file-compressed 961697925 1.03501e+09 0.929169 ns
tpch_q11/DataFusion:vortex-file-compressed 332389539 3.34063e+08 0.994989 ns
tpch_q12/DataFusion:vortex-file-compressed 663743065 6.83183e+08 0.971545 ns
tpch_q13/DataFusion:vortex-file-compressed 404452759 3.73265e+08 1.08355 ns
tpch_q14/DataFusion:vortex-file-compressed 491685614 5.19145e+08 0.947107 ns
tpch_q15/DataFusion:vortex-file-compressed 964704581 1.10807e+09 0.870613 ns
tpch_q16/DataFusion:vortex-file-compressed 270427054 2.63446e+08 1.0265 ns
tpch_q17/DataFusion:vortex-file-compressed 1316314724 1.3324e+09 0.987927 ns
tpch_q18/DataFusion:vortex-file-compressed 1417085267 1.39035e+09 1.01923 ns
tpch_q19/DataFusion:vortex-file-compressed 709934204 7.08124e+08 1.00256 ns
tpch_q20/DataFusion:vortex-file-compressed 737429877 6.84299e+08 1.07764 ns
tpch_q21/DataFusion:vortex-file-compressed 1513062566 1.58766e+09 0.953013 ns
tpch_q22/DataFusion:vortex-file-compressed 285878832 2.8458e+08 1.00456 ns
tpch_q01/DataFusion:vortex-compact 739448165 7.49902e+08 0.98606 ns
tpch_q02/DataFusion:vortex-compact 446162537 4.33877e+08 1.02832 ns
tpch_q03/DataFusion:vortex-compact 722075092 6.96512e+08 1.0367 ns
tpch_q04/DataFusion:vortex-compact 433607229 3.5701e+08 1.21455 ns
tpch_q05/DataFusion:vortex-compact 904486042 8.49796e+08 1.06436 ns
tpch_q06/DataFusion:vortex-compact 549504012 5.18277e+08 1.06025 ns
tpch_q07/DataFusion:vortex-compact 857110169 8.15067e+08 1.05158 ns
tpch_q08/DataFusion:vortex-compact 1126150259 1.09139e+09 1.03185 ns
tpch_q09/DataFusion:vortex-compact 1355756598 1.35131e+09 1.00329 ns
tpch_q10/DataFusion:vortex-compact 800019327 7.5129e+08 1.06486 ns
tpch_q11/DataFusion:vortex-compact 312360311 3.02923e+08 1.03115 ns
tpch_q12/DataFusion:vortex-compact 650652795 6.47497e+08 1.00487 ns
tpch_q13/DataFusion:vortex-compact 363463883 3.72212e+08 0.976497 ns
tpch_q14/DataFusion:vortex-compact 511602356 5.32748e+08 0.960309 ns
tpch_q15/DataFusion:vortex-compact 1096825700 1.19878e+09 0.91495 ns
tpch_q16/DataFusion:vortex-compact 248387945 2.45819e+08 1.01045 ns
tpch_q17/DataFusion:vortex-compact 1266044580 1.31933e+09 0.959609 ns
tpch_q18/DataFusion:vortex-compact 1264693928 1.25733e+09 1.00586 ns
tpch_q19/DataFusion:vortex-compact 700833321 6.90162e+08 1.01546 ns
tpch_q20/DataFusion:vortex-compact 689560556 6.13177e+08 1.12457 ns
tpch_q21/DataFusion:vortex-compact 1416043836 1.28015e+09 1.10615 ns
tpch_q22/DataFusion:vortex-compact 295378881 2.77133e+08 1.06584 ns
tpch_q01/DuckDB:parquet 873807714 8.45624e+08 1.03333 ns
tpch_q02/DuckDB:parquet 1109523052 1.05303e+09 1.05365 ns
tpch_q03/DuckDB:parquet 1187871734 1.14342e+09 1.03887 ns
tpch_q04/DuckDB:parquet 661112586 7.46747e+08 0.885323 ns
tpch_q05/DuckDB:parquet 1528777682 1.61755e+09 0.945118 ns
tpch_q06/DuckDB:parquet 565356035 5.63674e+08 1.00298 ns
tpch_q07/DuckDB:parquet 1300173249 1.32672e+09 0.979991 ns
tpch_q08/DuckDB:parquet 1788909522 1.79938e+09 0.994181 ns
tpch_q09/DuckDB:parquet 1743776469 1.84401e+09 0.945644 ns
tpch_q10/DuckDB:parquet 2499861012 2.49133e+09 1.00343 ns
tpch_q11/DuckDB:parquet 634904128 5.93852e+08 1.06913 ns
tpch_q12/DuckDB:parquet 690764301 7.60334e+08 0.908501 ns
tpch_q13/DuckDB:parquet 938541915 9.31629e+08 1.00742 ns
tpch_q14/DuckDB:parquet 980657812 9.70778e+08 1.01018 ns
tpch_q15/DuckDB:parquet 869418760 8.58962e+08 1.01217 ns
tpch_q16/DuckDB:parquet 508341212 4.89387e+08 1.03873 ns
tpch_q17/DuckDB:parquet 1020054371 9.96959e+08 1.02317 ns
tpch_q18/DuckDB:parquet 998537466 9.97428e+08 1.00111 ns
tpch_q19/DuckDB:parquet 1176400062 1.20308e+09 0.977827 ns
tpch_q20/DuckDB:parquet 1256792601 1.33438e+09 0.941855 ns
tpch_q21/DuckDB:parquet 1338273286 1.45079e+09 0.922444 ns
tpch_q22/DuckDB:parquet 786489156 8.07935e+08 0.973456 ns
tpch_q01/DuckDB:vortex-file-compressed 883908182 8.92711e+08 0.990139 ns
tpch_q02/DuckDB:vortex-file-compressed 958000519 9.72769e+08 0.984818 ns
tpch_q03/DuckDB:vortex-file-compressed 997088693 1.01571e+09 0.981667 ns
tpch_q04/DuckDB:vortex-file-compressed 738892743 7.627e+08 0.968786 ns
tpch_q05/DuckDB:vortex-file-compressed 1170024205 1.19858e+09 0.976174 ns
tpch_q06/DuckDB:vortex-file-compressed 612596129 6.04888e+08 1.01274 ns
tpch_q07/DuckDB:vortex-file-compressed 1235436008 1.26275e+09 0.97837 ns
tpch_q08/DuckDB:vortex-file-compressed 1604839731 1.57547e+09 1.01864 ns
tpch_q09/DuckDB:vortex-file-compressed 1904845545 1.73624e+09 1.09711 ns
tpch_q10/DuckDB:vortex-file-compressed 1179223506 1.11722e+09 1.0555 ns
tpch_q11/DuckDB:vortex-file-compressed 623244867 6.01531e+08 1.0361 ns
tpch_q12/DuckDB:vortex-file-compressed 1239104168 1.20151e+09 1.03129 ns
tpch_q13/DuckDB:vortex-file-compressed 817692506 7.84075e+08 1.04288 ns
tpch_q14/DuckDB:vortex-file-compressed 702229190 7.08676e+08 0.990903 ns
tpch_q15/DuckDB:vortex-file-compressed 743668071 7.242e+08 1.02688 ns
tpch_q16/DuckDB:vortex-file-compressed 489954454 4.8296e+08 1.01448 ns
tpch_q17/DuckDB:vortex-file-compressed 1408947135 1.41966e+09 0.992453 ns
tpch_q18/DuckDB:vortex-file-compressed 1226293093 1.18811e+09 1.03214 ns
tpch_q19/DuckDB:vortex-file-compressed 924055422 9.57454e+08 0.965117 ns
tpch_q20/DuckDB:vortex-file-compressed 1132613472 1.12418e+09 1.0075 ns
tpch_q21/DuckDB:vortex-file-compressed 2420177204 2.4293e+09 0.996245 ns
tpch_q22/DuckDB:vortex-file-compressed 451612274 4.45732e+08 1.01319 ns
tpch_q01/DuckDB:vortex-compact 874762918 8.81705e+08 0.992127 ns
tpch_q02/DuckDB:vortex-compact 925281393 9.32243e+08 0.992532 ns
tpch_q03/DuckDB:vortex-compact 917800683 9.67506e+08 0.948625 ns
tpch_q04/DuckDB:vortex-compact 741296451 7.09392e+08 1.04497 ns
tpch_q05/DuckDB:vortex-compact 1068072377 1.04684e+09 1.02029 ns
tpch_q06/DuckDB:vortex-compact 591520982 5.52147e+08 1.07131 ns
tpch_q07/DuckDB:vortex-compact 1151479942 1.1529e+09 0.998767 ns
tpch_q08/DuckDB:vortex-compact 1558132472 1.59491e+09 0.976939 ns
tpch_q09/DuckDB:vortex-compact 1606825568 1.61995e+09 0.9919 ns
tpch_q10/DuckDB:vortex-compact 1128872325 1.13573e+09 0.993964 ns
tpch_q11/DuckDB:vortex-compact 585217215 5.61095e+08 1.04299 ns
tpch_q12/DuckDB:vortex-compact 983389227 9.86833e+08 0.99651 ns
tpch_q13/DuckDB:vortex-compact 709879792 7.20315e+08 0.985512 ns
tpch_q14/DuckDB:vortex-compact 729896342 7.29702e+08 1.00027 ns
tpch_q15/DuckDB:vortex-compact 799385666 7.29207e+08 1.09624 ns
tpch_q16/DuckDB:vortex-compact 494317618 4.81058e+08 1.02756 ns
tpch_q17/DuckDB:vortex-compact 1334165535 1.33316e+09 1.00076 ns
tpch_q18/DuckDB:vortex-compact 1015429307 9.32774e+08 1.08861 ns
tpch_q19/DuckDB:vortex-compact 876217396 9.04221e+08 0.96903 ns
tpch_q20/DuckDB:vortex-compact 989091277 1.01831e+09 0.971305 ns
tpch_q21/DuckDB:vortex-compact 2054011871 2.10255e+09 0.976916 ns
tpch_q22/DuckDB:vortex-compact 454268603 4.32096e+08 1.05131 ns

@github-actions
Copy link
Contributor

github-actions bot commented Sep 25, 2025

Benchmarks: Clickbench on NVME

Summary

  • Overall: 0.972x ➖
  • Vortex: 0.957x ➖
  • duckdb:vortex: 0.991x ➖
  • datafusion:vortex: 0.924x ➖
  • Best: clickbench_q00/DataFusion:vortex-compact (0.672x)
  • Worst: clickbench_q24/DuckDB:vortex-compact (1.229x)
  • Significant (>10%): 24↑ 4↓
Detailed Results Table
name PR 33047a0 base a6cb059 ratio (PR/base) unit
clickbench_q00/DataFusion:parquet 1654566 1.60314e+06 1.03208 ns
clickbench_q01/DataFusion:parquet 25776426 2.55199e+07 1.01005 ns
clickbench_q02/DataFusion:parquet 56391253 5.80116e+07 0.972069 ns
clickbench_q03/DataFusion:parquet 51114883 5.14647e+07 0.993203 ns
clickbench_q04/DataFusion:parquet 353156957 3.59109e+08 0.983424 ns
clickbench_q05/DataFusion:parquet 365265372 3.68137e+08 0.992201 ns
clickbench_q06/DataFusion:parquet 1700211 1.69967e+06 1.00032 ns
clickbench_q07/DataFusion:parquet 29204019 3.04865e+07 0.957931 ns
clickbench_q08/DataFusion:parquet 442031627 4.53499e+08 0.974713 ns
clickbench_q09/DataFusion:parquet 675120442 6.8298e+08 0.988492 ns
clickbench_q10/DataFusion:parquet 125980620 1.29795e+08 0.970613 ns
clickbench_q11/DataFusion:parquet 153039897 1.5412e+08 0.992993 ns
clickbench_q12/DataFusion:parquet 376659434 3.76585e+08 1.0002 ns
clickbench_q13/DataFusion:parquet 535796738 5.26011e+08 1.0186 ns
clickbench_q14/DataFusion:parquet 366912060 3.67933e+08 0.997224 ns
clickbench_q15/DataFusion:parquet 413738441 4.12033e+08 1.00414 ns
clickbench_q16/DataFusion:parquet 762529869 7.75837e+08 0.982849 ns
clickbench_q17/DataFusion:parquet 754105235 7.60757e+08 0.991256 ns
clickbench_q18/DataFusion:parquet 1385864191 1.44855e+09 0.956727 ns
clickbench_q19/DataFusion:parquet 37530785 3.92018e+07 0.957375 ns
clickbench_q20/DataFusion:parquet 609669366 6.22126e+08 0.979977 ns
clickbench_q21/DataFusion:parquet 712006142 7.09552e+08 1.00346 ns
clickbench_q22/DataFusion:parquet 1035150879 1.07307e+09 0.964664 ns
clickbench_q23/DataFusion:parquet 4208796640 4.25876e+09 0.988268 ns
clickbench_q24/DataFusion:parquet 103888372 1.05902e+08 0.980984 ns
clickbench_q25/DataFusion:parquet 147348441 1.49155e+08 0.987886 ns
clickbench_q26/DataFusion:parquet 112158084 1.06704e+08 1.05112 ns
clickbench_q27/DataFusion:parquet 1041786795 1.04213e+09 0.999671 ns
clickbench_q28/DataFusion:parquet 5746025990 5.76196e+09 0.997235 ns
clickbench_q29/DataFusion:parquet 231778422 2.32144e+08 0.998424 ns
clickbench_q30/DataFusion:parquet 366829213 3.65302e+08 1.00418 ns
clickbench_q31/DataFusion:parquet 404311308 4.08488e+08 0.989774 ns
clickbench_q32/DataFusion:parquet 1257229123 1.27069e+09 0.989405 ns
clickbench_q33/DataFusion:parquet 1591679620 1.58595e+09 1.00361 ns
clickbench_q34/DataFusion:parquet 1562142132 1.58128e+09 0.9879 ns
clickbench_q35/DataFusion:parquet 577887515 5.8389e+08 0.989719 ns
clickbench_q36/DataFusion:parquet 150025885 1.5629e+08 0.959917 ns
clickbench_q37/DataFusion:parquet 60390828 6.00758e+07 1.00524 ns
clickbench_q38/DataFusion:parquet 92817596 9.14065e+07 1.01544 ns
clickbench_q39/DataFusion:parquet 295135993 2.99429e+08 0.985661 ns
clickbench_q40/DataFusion:parquet 35095937 3.5837e+07 0.979322 ns
clickbench_q41/DataFusion:parquet 31692478 3.09347e+07 1.0245 ns
clickbench_q42/DataFusion:parquet 33864984 3.34532e+07 1.01231 ns
clickbench_q00/DataFusion:vortex-file-compressed 1835044 1.77634e+06 1.03305 ns
clickbench_q01/DataFusion:vortex-file-compressed 10204485 9.5432e+06 1.06929 ns
clickbench_q02/DataFusion:vortex-file-compressed 29914986 2.64227e+07 1.13217 ns
clickbench_q03/DataFusion:vortex-file-compressed 29485448 3.06963e+07 0.960553 ns
clickbench_q04/DataFusion:vortex-file-compressed 305050236 3.04742e+08 1.00101 ns
clickbench_q05/DataFusion:vortex-file-compressed 322742467 3.18791e+08 1.0124 ns
clickbench_q06/DataFusion:vortex-file-compressed 1732662 1.78844e+06 0.968814 ns
clickbench_q07/DataFusion:vortex-file-compressed 14202255 1.41543e+07 1.00339 ns
clickbench_q08/DataFusion:vortex-file-compressed 372014632 3.7121e+08 1.00217 ns
clickbench_q09/DataFusion:vortex-file-compressed 547166573 5.49246e+08 0.996214 ns
clickbench_q10/DataFusion:vortex-file-compressed 65911998 6.6577e+07 0.990011 ns
clickbench_q11/DataFusion:vortex-file-compressed 77519690 7.84048e+07 0.98871 ns
clickbench_q12/DataFusion:vortex-file-compressed 267641419 2.68292e+08 0.997577 ns
clickbench_q13/DataFusion:vortex-file-compressed 431520350 4.33335e+08 0.995812 ns
clickbench_q14/DataFusion:vortex-file-compressed 245158298 2.5047e+08 0.978792 ns
clickbench_q15/DataFusion:vortex-file-compressed 356222023 3.57489e+08 0.996455 ns
clickbench_q16/DataFusion:vortex-file-compressed 750779174 7.63427e+08 0.983433 ns
clickbench_q17/DataFusion:vortex-file-compressed 745830113 7.42305e+08 1.00475 ns
clickbench_q18/DataFusion:vortex-file-compressed 1378611539 1.39168e+09 0.99061 ns
clickbench_q19/DataFusion:vortex-file-compressed 17555713 1.7633e+07 0.995615 ns
clickbench_q20/DataFusion:vortex-file-compressed 268577602 2.71289e+08 0.990007 ns
clickbench_q21/DataFusion:vortex-file-compressed 337136993 3.37161e+08 0.999929 ns
clickbench_q22/DataFusion:vortex-file-compressed 663934435 6.6083e+08 1.0047 ns
clickbench_q23/DataFusion:vortex-file-compressed 2643782748 2.65636e+09 0.995266 ns
clickbench_q24/DataFusion:vortex-file-compressed 106169107 1.06426e+08 0.997585 ns
clickbench_q25/DataFusion:vortex-file-compressed 57314193 5.7977e+07 0.988567 ns
clickbench_q26/DataFusion:vortex-file-compressed 106206313 1.09123e+08 0.973269 ns
clickbench_q27/DataFusion:vortex-file-compressed 791031297 7.8859e+08 1.0031 ns
clickbench_q28/DataFusion:vortex-file-compressed 6716983545 6.78662e+09 0.989739 ns
clickbench_q29/DataFusion:vortex-file-compressed 239717258 2.29633e+08 1.04392 ns
clickbench_q30/DataFusion:vortex-file-compressed 253557055 2.59761e+08 0.976115 ns
clickbench_q31/DataFusion:vortex-file-compressed 293742626 2.98714e+08 0.983356 ns
clickbench_q32/DataFusion:vortex-file-compressed 1354109144 1.31925e+09 1.02642 ns
clickbench_q33/DataFusion:vortex-file-compressed 1404422034 1.43896e+09 0.975998 ns
clickbench_q34/DataFusion:vortex-file-compressed 1421490058 1.43305e+09 0.991937 ns
clickbench_q35/DataFusion:vortex-file-compressed 540984488 5.44152e+08 0.99418 ns
clickbench_q36/DataFusion:vortex-file-compressed 85096820 9.10885e+07 0.934222 ns
clickbench_q37/DataFusion:vortex-file-compressed 41435429 4.2893e+07 0.966019 ns
clickbench_q38/DataFusion:vortex-file-compressed 27547211 2.67212e+07 1.03091 ns
clickbench_q39/DataFusion:vortex-file-compressed 183182994 1.89229e+08 0.968051 ns
clickbench_q40/DataFusion:vortex-file-compressed 20261003 2.33461e+07 0.867854 ns
clickbench_q41/DataFusion:vortex-file-compressed 19492120 2.26275e+07 0.861436 ns
clickbench_q42/DataFusion:vortex-file-compressed 21215697 2.35268e+07 0.901768 ns
clickbench_q00/DataFusion:vortex-compact 1764929 2.62622e+06 0.67204 ns
clickbench_q01/DataFusion:vortex-compact 10175650 1.28752e+07 0.790328 ns
clickbench_q02/DataFusion:vortex-compact 27491754 3.58811e+07 0.76619 ns
clickbench_q03/DataFusion:vortex-compact 29853286 4.19654e+07 0.711379 ns
clickbench_q04/DataFusion:vortex-compact 304964450 4.38738e+08 0.695094 ns
clickbench_q05/DataFusion:vortex-compact 322425057 4.50471e+08 0.715751 ns
clickbench_q06/DataFusion:vortex-compact 1735282 2.55904e+06 0.6781 ns
clickbench_q07/DataFusion:vortex-compact 14752520 1.99185e+07 0.740643 ns
clickbench_q08/DataFusion:vortex-compact 373931783 5.36069e+08 0.697544 ns
clickbench_q09/DataFusion:vortex-compact 559444268 8.01379e+08 0.698102 ns
clickbench_q10/DataFusion:vortex-compact 65350098 8.73179e+07 0.748416 ns
clickbench_q11/DataFusion:vortex-compact 78086813 1.01227e+08 0.771405 ns
clickbench_q12/DataFusion:vortex-compact 266126508 3.8492e+08 0.691382 ns
clickbench_q13/DataFusion:vortex-compact 426398993 6.28291e+08 0.678664 ns
clickbench_q14/DataFusion:vortex-compact 244708266 3.60797e+08 0.678244 ns
clickbench_q15/DataFusion:vortex-compact 360029022 5.12712e+08 0.702205 ns
clickbench_q16/DataFusion:vortex-compact 747096381 1.06243e+09 0.703194 ns
clickbench_q17/DataFusion:vortex-compact 738884556 9.30144e+08 0.794377 ns
clickbench_q18/DataFusion:vortex-compact 1397165587 1.42899e+09 0.977726 ns
clickbench_q19/DataFusion:vortex-compact 18561924 1.80417e+07 1.02883 ns
clickbench_q20/DataFusion:vortex-compact 268056957 2.75614e+08 0.97258 ns
clickbench_q21/DataFusion:vortex-compact 335579946 3.49544e+08 0.96005 ns
clickbench_q22/DataFusion:vortex-compact 658551070 7.07342e+08 0.931022 ns
clickbench_q23/DataFusion:vortex-compact 2596262001 2.73909e+09 0.947854 ns
clickbench_q24/DataFusion:vortex-compact 108077272 1.11721e+08 0.967385 ns
clickbench_q25/DataFusion:vortex-compact 58279046 5.725e+07 1.01797 ns
clickbench_q26/DataFusion:vortex-compact 107050449 1.09548e+08 0.977201 ns
clickbench_q27/DataFusion:vortex-compact 779142845 7.67006e+08 1.01582 ns
clickbench_q28/DataFusion:vortex-compact 6673741095 6.56799e+09 1.0161 ns
clickbench_q29/DataFusion:vortex-compact 234084337 2.49639e+08 0.937692 ns
clickbench_q30/DataFusion:vortex-compact 251910198 2.53412e+08 0.994074 ns
clickbench_q31/DataFusion:vortex-compact 292359044 2.97797e+08 0.981738 ns
clickbench_q32/DataFusion:vortex-compact 1229404466 1.21888e+09 1.00863 ns
clickbench_q33/DataFusion:vortex-compact 1431725193 1.43369e+09 0.998626 ns
clickbench_q34/DataFusion:vortex-compact 1420864158 1.41105e+09 1.00695 ns
clickbench_q35/DataFusion:vortex-compact 540128632 5.41919e+08 0.996697 ns
clickbench_q36/DataFusion:vortex-compact 86074973 8.78922e+07 0.979325 ns
clickbench_q37/DataFusion:vortex-compact 40952840 4.19264e+07 0.976779 ns
clickbench_q38/DataFusion:vortex-compact 26596502 2.76364e+07 0.962373 ns
clickbench_q39/DataFusion:vortex-compact 180987286 1.87194e+08 0.966844 ns
clickbench_q40/DataFusion:vortex-compact 20984267 2.02317e+07 1.0372 ns
clickbench_q41/DataFusion:vortex-compact 19562370 1.94689e+07 1.0048 ns
clickbench_q42/DataFusion:vortex-compact 21162573 2.19494e+07 0.964154 ns
clickbench_q00/DuckDB:parquet 121837738 1.20956e+08 1.00729 ns
clickbench_q01/DuckDB:parquet 48681147 4.97692e+07 0.978138 ns
clickbench_q02/DuckDB:parquet 62492829 6.23132e+07 1.00288 ns
clickbench_q03/DuckDB:parquet 60803143 6.18612e+07 0.982896 ns
clickbench_q04/DuckDB:parquet 197987670 1.97932e+08 1.00028 ns
clickbench_q05/DuckDB:parquet 266692067 2.67251e+08 0.99791 ns
clickbench_q06/DuckDB:parquet 60554219 6.03819e+07 1.00285 ns
clickbench_q07/DuckDB:parquet 54512783 5.45958e+07 0.99848 ns
clickbench_q08/DuckDB:parquet 262174566 2.62824e+08 0.997527 ns
clickbench_q09/DuckDB:parquet 385125665 3.87998e+08 0.992597 ns
clickbench_q10/DuckDB:parquet 92060030 9.23726e+07 0.996616 ns
clickbench_q11/DuckDB:parquet 102672888 1.0403e+08 0.986951 ns
clickbench_q12/DuckDB:parquet 285184016 2.83267e+08 1.00677 ns
clickbench_q13/DuckDB:parquet 467319213 4.69656e+08 0.995025 ns
clickbench_q14/DuckDB:parquet 317160033 3.18892e+08 0.994569 ns
clickbench_q15/DuckDB:parquet 233982554 2.35525e+08 0.993451 ns
clickbench_q16/DuckDB:parquet 559687972 5.59525e+08 1.00029 ns
clickbench_q17/DuckDB:parquet 470030502 4.69329e+08 1.00149 ns
clickbench_q18/DuckDB:parquet 969457718 9.68804e+08 1.00068 ns
clickbench_q19/DuckDB:parquet 47274645 4.67721e+07 1.01074 ns
clickbench_q20/DuckDB:parquet 402286131 4.02465e+08 0.999554 ns
clickbench_q21/DuckDB:parquet 515308000 5.14226e+08 1.0021 ns
clickbench_q22/DuckDB:parquet 892675966 8.98354e+08 0.993679 ns
clickbench_q23/DuckDB:parquet 270302410 2.74771e+08 0.983736 ns
clickbench_q24/DuckDB:parquet 75972599 7.60916e+07 0.998436 ns
clickbench_q25/DuckDB:parquet 136668890 1.37441e+08 0.994381 ns
clickbench_q26/DuckDB:parquet 52220250 5.20426e+07 1.00341 ns
clickbench_q27/DuckDB:parquet 608435098 6.1319e+08 0.992246 ns
clickbench_q28/DuckDB:parquet 4808523377 4.84703e+09 0.992055 ns
clickbench_q29/DuckDB:parquet 60090065 6.03562e+07 0.99559 ns
clickbench_q30/DuckDB:parquet 302744509 3.046e+08 0.993907 ns
clickbench_q31/DuckDB:parquet 341672883 3.41053e+08 1.00182 ns
clickbench_q32/DuckDB:parquet 1026169429 1.03399e+09 0.992434 ns
clickbench_q33/DuckDB:parquet 1043084435 1.04388e+09 0.99924 ns
clickbench_q34/DuckDB:parquet 1081262842 1.09069e+09 0.991354 ns
clickbench_q35/DuckDB:parquet 345046181 3.4498e+08 1.00019 ns
clickbench_q36/DuckDB:parquet 60256203 6.01521e+07 1.00173 ns
clickbench_q37/DuckDB:parquet 48494837 4.7098e+07 1.02966 ns
clickbench_q38/DuckDB:parquet 50974531 5.45262e+07 0.934863 ns
clickbench_q39/DuckDB:parquet 92246230 9.60883e+07 0.960015 ns
clickbench_q40/DuckDB:parquet 50871820 5.76859e+07 0.881876 ns
clickbench_q41/DuckDB:parquet 54900317 5.53684e+07 0.991546 ns
clickbench_q42/DuckDB:parquet 42167893 4.14462e+07 1.01741 ns
clickbench_q00/DuckDB:vortex-file-compressed 11038678 1.09694e+07 1.00631 ns
clickbench_q01/DuckDB:vortex-file-compressed 15080384 1.5934e+07 0.94643 ns
clickbench_q02/DuckDB:vortex-file-compressed 30557839 3.23918e+07 0.943382 ns
clickbench_q03/DuckDB:vortex-file-compressed 38018739 4.3667e+07 0.870651 ns
clickbench_q04/DuckDB:vortex-file-compressed 168994322 1.9176e+08 0.881282 ns
clickbench_q05/DuckDB:vortex-file-compressed 188712192 1.94314e+08 0.97117 ns
clickbench_q06/DuckDB:vortex-file-compressed 30208744 3.12907e+07 0.965422 ns
clickbench_q07/DuckDB:vortex-file-compressed 19251563 2.10918e+07 0.912751 ns
clickbench_q08/DuckDB:vortex-file-compressed 259376202 2.72991e+08 0.950128 ns
clickbench_q09/DuckDB:vortex-file-compressed 346925823 3.51405e+08 0.987253 ns
clickbench_q10/DuckDB:vortex-file-compressed 66878432 6.97567e+07 0.958739 ns
clickbench_q11/DuckDB:vortex-file-compressed 77322862 7.93916e+07 0.973943 ns
clickbench_q12/DuckDB:vortex-file-compressed 194536593 1.96706e+08 0.988969 ns
clickbench_q13/DuckDB:vortex-file-compressed 446153213 4.52736e+08 0.98546 ns
clickbench_q14/DuckDB:vortex-file-compressed 281348335 2.84102e+08 0.990308 ns
clickbench_q15/DuckDB:vortex-file-compressed 209029745 2.09161e+08 0.999372 ns
clickbench_q16/DuckDB:vortex-file-compressed 927530156 9.45039e+08 0.981473 ns
clickbench_q17/DuckDB:vortex-file-compressed 845605010 8.48404e+08 0.996701 ns
clickbench_q18/DuckDB:vortex-file-compressed 1439845299 1.42052e+09 1.0136 ns
clickbench_q19/DuckDB:vortex-file-compressed 24874008 2.46282e+07 1.00998 ns
clickbench_q20/DuckDB:vortex-file-compressed 263289433 2.59463e+08 1.01475 ns
clickbench_q21/DuckDB:vortex-file-compressed 306730578 3.08961e+08 0.992779 ns
clickbench_q22/DuckDB:vortex-file-compressed 587328797 6.06043e+08 0.96912 ns
clickbench_q23/DuckDB:vortex-file-compressed 615010094 5.58213e+08 1.10175 ns
clickbench_q24/DuckDB:vortex-file-compressed 34724510 3.78628e+07 0.917115 ns
clickbench_q25/DuckDB:vortex-file-compressed 57727268 5.89219e+07 0.979725 ns
clickbench_q26/DuckDB:vortex-file-compressed 41439837 4.77849e+07 0.867217 ns
clickbench_q27/DuckDB:vortex-file-compressed 415225056 4.17373e+08 0.994854 ns
clickbench_q28/DuckDB:vortex-file-compressed 3063033963 3.09675e+09 0.989114 ns
clickbench_q29/DuckDB:vortex-file-compressed 32609822 3.32033e+07 0.982126 ns
clickbench_q30/DuckDB:vortex-file-compressed 171004723 1.7135e+08 0.997986 ns
clickbench_q31/DuckDB:vortex-file-compressed 227808514 2.32657e+08 0.97916 ns
clickbench_q32/DuckDB:vortex-file-compressed 1034105906 1.05414e+09 0.980999 ns
clickbench_q33/DuckDB:vortex-file-compressed 1005705615 1.01102e+09 0.994739 ns
clickbench_q34/DuckDB:vortex-file-compressed 1478703459 1.47122e+09 1.00508 ns
clickbench_q35/DuckDB:vortex-file-compressed 358266580 3.58028e+08 1.00067 ns
clickbench_q36/DuckDB:vortex-file-compressed 23620353 2.31383e+07 1.02083 ns
clickbench_q37/DuckDB:vortex-file-compressed 15691460 1.49222e+07 1.05155 ns
clickbench_q38/DuckDB:vortex-file-compressed 16612069 1.58559e+07 1.04769 ns
clickbench_q39/DuckDB:vortex-file-compressed 43374202 4.19201e+07 1.03469 ns
clickbench_q40/DuckDB:vortex-file-compressed 14045374 1.33861e+07 1.04925 ns
clickbench_q41/DuckDB:vortex-file-compressed 14290008 1.42115e+07 1.00552 ns
clickbench_q42/DuckDB:vortex-file-compressed 17393081 1.76191e+07 0.98717 ns
clickbench_q00/DuckDB:vortex-compact 10590580 1.11281e+07 0.951698 ns
clickbench_q01/DuckDB:vortex-compact 26148949 2.65907e+07 0.983385 ns
clickbench_q02/DuckDB:vortex-compact 50381127 4.9491e+07 1.01799 ns
clickbench_q03/DuckDB:vortex-compact 46526721 4.6478e+07 1.00105 ns
clickbench_q04/DuckDB:vortex-compact 211879822 2.11715e+08 1.00078 ns
clickbench_q05/DuckDB:vortex-compact 224327069 2.2648e+08 0.990494 ns
clickbench_q06/DuckDB:vortex-compact 34937257 3.47145e+07 1.00642 ns
clickbench_q07/DuckDB:vortex-compact 41494971 4.14174e+07 1.00187 ns
clickbench_q08/DuckDB:vortex-compact 285174447 2.86362e+08 0.995852 ns
clickbench_q09/DuckDB:vortex-compact 417243219 4.19245e+08 0.995225 ns
clickbench_q10/DuckDB:vortex-compact 106367161 1.07004e+08 0.99405 ns
clickbench_q11/DuckDB:vortex-compact 128988569 1.28677e+08 1.00242 ns
clickbench_q12/DuckDB:vortex-compact 285141519 2.89491e+08 0.984975 ns
clickbench_q13/DuckDB:vortex-compact 551070749 5.46673e+08 1.00804 ns
clickbench_q14/DuckDB:vortex-compact 386487658 3.8877e+08 0.994129 ns
clickbench_q15/DuckDB:vortex-compact 250683397 2.50187e+08 1.00198 ns
clickbench_q16/DuckDB:vortex-compact 1007981281 1.00876e+09 0.999226 ns
clickbench_q17/DuckDB:vortex-compact 919113940 9.18316e+08 1.00087 ns
clickbench_q18/DuckDB:vortex-compact 1502155954 1.50414e+09 0.998682 ns
clickbench_q19/DuckDB:vortex-compact 28477149 2.91609e+07 0.976553 ns
clickbench_q20/DuckDB:vortex-compact 332174000 3.32567e+08 0.998818 ns
clickbench_q21/DuckDB:vortex-compact 461526673 4.625e+08 0.997895 ns
clickbench_q22/DuckDB:vortex-compact 925049491 9.22939e+08 1.00229 ns
clickbench_q23/DuckDB:vortex-compact 551939759 4.86681e+08 1.13409 ns
clickbench_q24/DuckDB:vortex-compact 74540560 6.06269e+07 1.2295 ns
clickbench_q25/DuckDB:vortex-compact 157784758 1.61079e+08 0.979549 ns
clickbench_q26/DuckDB:vortex-compact 80020425 9.53395e+07 0.839321 ns
clickbench_q27/DuckDB:vortex-compact 767292975 7.73786e+08 0.991608 ns
clickbench_q28/DuckDB:vortex-compact 3318300725 3.34577e+09 0.99179 ns
clickbench_q29/DuckDB:vortex-compact 42171772 4.20451e+07 1.00301 ns
clickbench_q30/DuckDB:vortex-compact 267809919 2.67227e+08 1.00218 ns
clickbench_q31/DuckDB:vortex-compact 313601018 3.12973e+08 1.00201 ns
clickbench_q32/DuckDB:vortex-compact 1103215287 1.0948e+09 1.00769 ns
clickbench_q33/DuckDB:vortex-compact 1060450051 1.05832e+09 1.00201 ns
clickbench_q34/DuckDB:vortex-compact 1542211612 1.57935e+09 0.976487 ns
clickbench_q35/DuckDB:vortex-compact 362832524 3.69016e+08 0.983244 ns
clickbench_q36/DuckDB:vortex-compact 28704345 2.92764e+07 0.980461 ns
clickbench_q37/DuckDB:vortex-compact 20100088 1.9311e+07 1.04086 ns
clickbench_q38/DuckDB:vortex-compact 19428311 1.99929e+07 0.971763 ns
clickbench_q39/DuckDB:vortex-compact 48642811 4.97741e+07 0.977271 ns
clickbench_q40/DuckDB:vortex-compact 20254568 2.04955e+07 0.988243 ns
clickbench_q41/DuckDB:vortex-compact 20185366 1.87087e+07 1.07893 ns
clickbench_q42/DuckDB:vortex-compact 20443942 2.11538e+07 0.966445 ns
clickbench_q00/DuckDB:duckdb 18061005 1.80331e+07 1.00155 ns
clickbench_q01/DuckDB:duckdb 36150489 3.6585e+07 0.988123 ns
clickbench_q02/DuckDB:duckdb 45378592 4.56796e+07 0.993411 ns
clickbench_q03/DuckDB:duckdb 47674810 4.72575e+07 1.00883 ns
clickbench_q04/DuckDB:duckdb 187459421 1.87301e+08 1.00084 ns
clickbench_q05/DuckDB:duckdb 299122912 2.96334e+08 1.00941 ns
clickbench_q06/DuckDB:duckdb 35090968 3.51289e+07 0.998919 ns
clickbench_q07/DuckDB:duckdb 37703986 3.76441e+07 1.00159 ns
clickbench_q08/DuckDB:duckdb 247058178 2.47075e+08 0.999931 ns
clickbench_q09/DuckDB:duckdb 360781367 3.60625e+08 1.00043 ns
clickbench_q10/DuckDB:duckdb 110870323 1.10593e+08 1.0025 ns
clickbench_q11/DuckDB:duckdb 119627655 1.21013e+08 0.988549 ns
clickbench_q12/DuckDB:duckdb 266338333 2.6528e+08 1.00399 ns
clickbench_q13/DuckDB:duckdb 442738754 4.41639e+08 1.00249 ns
clickbench_q14/DuckDB:duckdb 287613785 2.89899e+08 0.992116 ns
clickbench_q15/DuckDB:duckdb 217173377 2.16901e+08 1.00126 ns
clickbench_q16/DuckDB:duckdb 538187161 5.36186e+08 1.00373 ns
clickbench_q17/DuckDB:duckdb 455176802 4.55183e+08 0.999985 ns
clickbench_q18/DuckDB:duckdb 943246989 9.38004e+08 1.00559 ns
clickbench_q19/DuckDB:duckdb 36768257 3.62256e+07 1.01498 ns
clickbench_q20/DuckDB:duckdb 450557071 4.52817e+08 0.99501 ns
clickbench_q21/DuckDB:duckdb 475506334 4.74591e+08 1.00193 ns
clickbench_q22/DuckDB:duckdb 516175390 5.27159e+08 0.979164 ns
clickbench_q23/DuckDB:duckdb 221782955 2.30019e+08 0.964195 ns
clickbench_q24/DuckDB:duckdb 47967169 4.71844e+07 1.01659 ns
clickbench_q25/DuckDB:duckdb 111523018 1.10766e+08 1.00683 ns
clickbench_q26/DuckDB:duckdb 45547148 4.61908e+07 0.986065 ns
clickbench_q27/DuckDB:duckdb 527999309 5.27213e+08 1.00149 ns
clickbench_q28/DuckDB:duckdb 4443307253 4.46225e+09 0.995755 ns
clickbench_q29/DuckDB:duckdb 49096791 4.91026e+07 0.999882 ns
clickbench_q30/DuckDB:duckdb 268195495 2.68604e+08 0.998478 ns
clickbench_q31/DuckDB:duckdb 335726678 3.3528e+08 1.00133 ns
clickbench_q32/DuckDB:duckdb 1015352263 1.01622e+09 0.999151 ns
clickbench_q33/DuckDB:duckdb 1060479126 1.06522e+09 0.995547 ns
clickbench_q34/DuckDB:duckdb 1136059630 1.1293e+09 1.00599 ns
clickbench_q35/DuckDB:duckdb 261685274 2.62047e+08 0.99862 ns
clickbench_q36/DuckDB:duckdb 39345965 4.40181e+07 0.893858 ns
clickbench_q37/DuckDB:duckdb 32068809 3.20715e+07 0.999916 ns
clickbench_q38/DuckDB:duckdb 33010200 3.28085e+07 1.00615 ns
clickbench_q39/DuckDB:duckdb 68076694 7.03949e+07 0.967069 ns
clickbench_q40/DuckDB:duckdb 31846864 3.18994e+07 0.998353 ns
clickbench_q41/DuckDB:duckdb 32246981 3.21181e+07 1.00401 ns
clickbench_q42/DuckDB:duckdb 31506911 3.13661e+07 1.00449 ns

- implement list view rebuilding
- add list view exporter conversion cast
- take rebuild optimization
- hack for empty export bug

Signed-off-by: Connor Tsui <[email protected]>
@connortsui20 connortsui20 force-pushed the ct/list-view-canonicalize branch from 41d9fc3 to 33047a0 Compare September 30, 2025 20:20
@connortsui20 connortsui20 added action/benchmark Trigger full benchmarks to run on this PR action/benchmark-sql Trigger SQL benchmarks to run on this PR labels Sep 30, 2025
@github-actions github-actions bot removed action/benchmark-sql Trigger SQL benchmarks to run on this PR action/benchmark Trigger full benchmarks to run on this PR labels Sep 30, 2025
@connortsui20
Copy link
Contributor Author

Since the conversation is getting long and I need to rebase a bunch of stuff I'm closing this and will reopen a fresh PR soon.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

changelog/feature A new feature

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants