clickhouse 2100

Intel Core i3-12100 testing with a ASRock B660M-HDV (6.02 BIOS) and Intel ADL-S GT1 16GB on Ubuntu 22.04 via the Phoronix Test Suite.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2206254-NE-CLICKHOUS01
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
A
June 25 2022
  29 Minutes
B
June 25 2022
  36 Minutes
C
June 25 2022
  48 Minutes
D
June 25 2022
  38 Minutes
Invert Hiding All Results Option
  38 Minutes

Only show results where is faster than
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):

{ "title": "clickhouse 2100", "last_modified": "2022-06-25 15:28:25", "description": "Intel Core i3-12100 testing with a ASRock B660M-HDV (6.02 BIOS) and Intel ADL-S GT1 16GB on Ubuntu 22.04 via the Phoronix Test Suite.", "systems": { "A": { "identifier": "A", "hardware": { "Processor": "Intel Core i3-12100 @ 5.50GHz (4 Cores \/ 8 Threads)", "Motherboard": "ASRock B660M-HDV (6.02 BIOS)", "Chipset": "Intel Device 7aa7", "Memory": "16GB", "Disk": "512GB Sabrent", "Graphics": "Intel ADL-S GT1 16GB (1400MHz)", "Audio": "Realtek ALC897", "Monitor": "DELL S2409W", "Network": "Intel" }, "software": { "OS": "Ubuntu 22.04", "Kernel": "5.18.0-051800-generic (x86_64)", "Desktop": "GNOME Shell 42.1", "Display Server": "X Server 1.20.14 + Wayland", "OpenGL": "4.6 Mesa 22.0.1", "Vulkan": "1.2.204", "Compiler": "GCC 11.2.0", "File-System": "ext4", "Screen Resolution": "1920x1080" }, "user": "phoronix", "timestamp": "2022-06-25 14:25:23", "client_version": "10.8.3", "data": { "cpu-scaling-governor": "intel_pstate powersave (EPP: balance_performance)", "cpu-microcode": "0x1f", "cpu-thermald": "2.4.9", "kernel-extra-details": "Transparent Huge Pages: madvise", "security": "itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy\/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected" } }, "B": { "identifier": "B", "hardware": { "Processor": "Intel Core i3-12100 @ 5.50GHz (4 Cores \/ 8 Threads)", "Motherboard": "ASRock B660M-HDV (6.02 BIOS)", "Chipset": "Intel Device 7aa7", "Memory": "16GB", "Disk": "512GB Sabrent", "Graphics": "Intel ADL-S GT1 16GB (1400MHz)", "Audio": "Realtek ALC897", "Monitor": "DELL S2409W", "Network": "Intel" }, "software": { "OS": "Ubuntu 22.04", "Kernel": "5.18.0-051800-generic (x86_64)", "Desktop": "GNOME Shell 42.1", "Display Server": "X Server 1.20.14 + Wayland", "OpenGL": "4.6 Mesa 22.0.1", "Vulkan": "1.2.204", "Compiler": "GCC 11.2.0", "File-System": "ext4", "Screen Resolution": "1920x1080" }, "user": "phoronix", "timestamp": "2022-06-25 14:37:55", "client_version": "10.8.3", "data": { "cpu-scaling-governor": "intel_pstate powersave (EPP: balance_performance)", "cpu-microcode": "0x1f", "cpu-thermald": "2.4.9", "kernel-extra-details": "Transparent Huge Pages: madvise", "security": "itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy\/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected" } }, "C": { "identifier": "C", "hardware": { "Processor": "Intel Core i3-12100 @ 5.50GHz (4 Cores \/ 8 Threads)", "Motherboard": "ASRock B660M-HDV (6.02 BIOS)", "Chipset": "Intel Device 7aa7", "Memory": "16GB", "Disk": "512GB Sabrent", "Graphics": "Intel ADL-S GT1 16GB (1400MHz)", "Audio": "Realtek ALC897", "Monitor": "DELL S2409W", "Network": "Intel" }, "software": { "OS": "Ubuntu 22.04", "Kernel": "5.18.0-051800-generic (x86_64)", "Desktop": "GNOME Shell 42.1", "Display Server": "X Server 1.20.14 + Wayland", "OpenGL": "4.6 Mesa 22.0.1", "Vulkan": "1.2.204", "Compiler": "GCC 11.2.0", "File-System": "ext4", "Screen Resolution": "1920x1080" }, "user": "phoronix", "timestamp": "2022-06-25 14:52:19", "client_version": "10.8.3", "data": { "cpu-scaling-governor": "intel_pstate powersave (EPP: balance_performance)", "cpu-microcode": "0x1f", "cpu-thermald": "2.4.9", "kernel-extra-details": "Transparent Huge Pages: madvise", "security": "itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy\/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected" } }, "D": { "identifier": "D", "hardware": { "Processor": "Intel Core i3-12100 @ 5.50GHz (4 Cores \/ 8 Threads)", "Motherboard": "ASRock B660M-HDV (6.02 BIOS)", "Chipset": "Intel Device 7aa7", "Memory": "16GB", "Disk": "512GB Sabrent", "Graphics": "Intel ADL-S GT1 16GB (1400MHz)", "Audio": "Realtek ALC897", "Monitor": "DELL S2409W", "Network": "Intel" }, "software": { "OS": "Ubuntu 22.04", "Kernel": "5.18.0-051800-generic (x86_64)", "Desktop": "GNOME Shell 42.1", "Display Server": "X Server 1.20.14 + Wayland", "OpenGL": "4.6 Mesa 22.0.1", "Vulkan": "1.2.204", "Compiler": "GCC 11.2.0", "File-System": "ext4", "Screen Resolution": "1920x1080" }, "user": "phoronix", "timestamp": "2022-06-25 15:14:10", "client_version": "10.8.3", "data": { "cpu-scaling-governor": "intel_pstate powersave (EPP: balance_performance)", "cpu-microcode": "0x1f", "cpu-thermald": "2.4.9", "kernel-extra-details": "Transparent Huge Pages: madvise", "security": "itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy\/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected" } } }, "results": { "d31a295ba0a3d334db8db72b3e025160d9eae487": { "identifier": "pts\/clickhouse-1.0.0", "title": "ClickHouse", "description": "100M Rows Web Analytics Dataset, First Run \/ Cold Cache", "scale": "Queries Per Minute, Geo Mean", "proportion": "HIB", "display_format": "BAR_GRAPH", "results": { "A": { "value": 85.68999999999999772626324556767940521240234375, "raw_values": [ 85.1332659647270020286669023334980010986328125, 86.376604272657999672446749173104763031005859375, 85.5618176043559941490457276813685894012451171875 ], "min_result": [ "6.99" ], "max_result": [ "15000" ], "test_run_times": [ 191.080000000000012505552149377763271331787109375, 192.31000000000000227373675443232059478759765625, 195.5 ], "details": { "install-footnote": "ClickHouse server version 22.7.1.687 (official build)." } }, "B": { "value": 87.8299999999999982946974341757595539093017578125, "raw_values": [ 88.4870890152489977253935649059712886810302734375, 86.9513131828440037907057558186352252960205078125, 88.063728013309997777469106949865818023681640625 ], "min_result": [ "7.25" ], "max_result": [ "15000" ], "test_run_times": [ 143.990000000000009094947017729282379150390625, 189.520000000000010231815394945442676544189453125, 191.81999999999999317878973670303821563720703125, 190.05000000000001136868377216160297393798828125 ], "details": { "install-footnote": "ClickHouse server version 22.7.1.687 (official build)." } }, "C": { "value": 88.43999999999999772626324556767940521240234375, "raw_values": [ 89.7024679588970030863492866046726703643798828125, 91.0690948352760045736431493423879146575927734375, 85.4519624568360001148903393186628818511962890625, 88.791061860691996798777836374938488006591796875, 87.160624307451001868685125373303890228271484375 ], "min_result": [ "6.79" ], "max_result": [ "20000" ], "test_run_times": [ 184.590000000000003410605131648480892181396484375, 189.849999999999994315658113919198513031005859375, 191.969999999999998863131622783839702606201171875, 190.6100000000000136424205265939235687255859375, 190.8600000000000136424205265939235687255859375 ], "details": { "install-footnote": "ClickHouse server version 22.7.1.687 (official build)." } }, "D": { "value": 89.68000000000000682121026329696178436279296875, "raw_values": [ 92.288323941350000723105040378868579864501953125, 89.5553684986929994238380459137260913848876953125, 87.717623679495005717399180866777896881103515625, 89.16130459144500264301314018666744232177734375 ], "min_result": [ "6.88" ], "max_result": [ "15000" ], "test_run_times": [ 183.93999999999999772626324556767940521240234375, 190.6100000000000136424205265939235687255859375, 191.979999999999989768184605054557323455810546875, 187.789999999999992041921359486877918243408203125 ], "details": { "install-footnote": "ClickHouse server version 22.7.1.687 (official build)." } } } }, "5ce551f880e64bf1a4d06211f4f8669cac2f3e94": { "identifier": "pts\/clickhouse-1.0.0", "title": "ClickHouse", "description": "100M Rows Web Analytics Dataset, Second Run", "scale": "Queries Per Minute, Geo Mean", "proportion": "HIB", "display_format": "BAR_GRAPH", "results": { "A": { "value": 94.8599999999999994315658113919198513031005859375, "raw_values": [ 97.7249188278299953935857047326862812042236328125, 94.2355438898620008103534928523004055023193359375, 92.60849343700300551063264720141887664794921875 ], "min_result": [ "7.71" ], "max_result": [ "30000" ], "test_run_times": [ 191.080000000000012505552149377763271331787109375, 192.31000000000000227373675443232059478759765625, 195.5 ], "details": { "install-footnote": "ClickHouse server version 22.7.1.687 (official build)." } }, "B": { "value": 97.650000000000005684341886080801486968994140625, "raw_values": [ 99.7724623621370056980595109052956104278564453125, 96.139968912217000251985155045986175537109375, 97.048367798968001807224936783313751220703125 ], "min_result": [ "7.76" ], "max_result": [ "20000" ], "test_run_times": [ 143.990000000000009094947017729282379150390625, 189.520000000000010231815394945442676544189453125, 191.81999999999999317878973670303821563720703125, 190.05000000000001136868377216160297393798828125 ], "details": { "install-footnote": "ClickHouse server version 22.7.1.687 (official build)." } }, "C": { "value": 96.8599999999999994315658113919198513031005859375, "raw_values": [ 101.0539978948499992839060723781585693359375, 98.584806521318995464753243140876293182373046875, 95.7113198780590010983360116370022296905517578125, 93.201272343097997463701176457107067108154296875, 95.7550998936630008984138839878141880035400390625 ], "min_result": [ "7.73" ], "max_result": [ "30000" ], "test_run_times": [ 184.590000000000003410605131648480892181396484375, 189.849999999999994315658113919198513031005859375, 191.969999999999998863131622783839702606201171875, 190.6100000000000136424205265939235687255859375, 190.8600000000000136424205265939235687255859375 ], "details": { "install-footnote": "ClickHouse server version 22.7.1.687 (official build)." } }, "D": { "value": 99.030000000000001136868377216160297393798828125, "raw_values": [ 102.3930719689600010724461753852665424346923828125, 100.8466591289299998379647149704396724700927734375, 94.489533029987995860210503451526165008544921875, 98.3723466991619943655678071081638336181640625 ], "min_result": [ "7.87" ], "max_result": [ "30000" ], "test_run_times": [ 183.93999999999999772626324556767940521240234375, 190.6100000000000136424205265939235687255859375, 191.979999999999989768184605054557323455810546875, 187.789999999999992041921359486877918243408203125 ], "details": { "install-footnote": "ClickHouse server version 22.7.1.687 (official build)." } } } }, "e1513066ea858892473846deb56a9e3c19210177": { "identifier": "pts\/clickhouse-1.0.0", "title": "ClickHouse", "description": "100M Rows Web Analytics Dataset, Third Run", "scale": "Queries Per Minute, Geo Mean", "proportion": "HIB", "display_format": "BAR_GRAPH", "results": { "A": { "value": 96.969999999999998863131622783839702606201171875, "raw_values": [ 98.80222668454899803691660054028034210205078125, 96.2506188038939995976761565543711185455322265625, 95.8472130533049977429982391186058521270751953125 ], "min_result": [ "8.05" ], "max_result": [ "30000" ], "test_run_times": [ 191.080000000000012505552149377763271331787109375, 192.31000000000000227373675443232059478759765625, 195.5 ], "details": { "install-footnote": "ClickHouse server version 22.7.1.687 (official build)." } }, "B": { "value": 97.409999999999996589394868351519107818603515625, "raw_values": [ 98.8754517586369985338023980148136615753173828125, 96.02342897063999771489761769771575927734375, 97.34019382233799433379317633807659149169921875 ], "min_result": [ "8.11" ], "max_result": [ "20000" ], "test_run_times": [ 143.990000000000009094947017729282379150390625, 189.520000000000010231815394945442676544189453125, 191.81999999999999317878973670303821563720703125, 190.05000000000001136868377216160297393798828125 ], "details": { "install-footnote": "ClickHouse server version 22.7.1.687 (official build)." } }, "C": { "value": 95.599999999999994315658113919198513031005859375, "raw_values": [ 98.1248462697910071028672973625361919403076171875, 97.34765645776900555574684403836727142333984375, 95.7194234799359975340848905034363269805908203125, 93.302354085800999428101931698620319366455078125, 93.509067559518001644391915760934352874755859375 ], "min_result": [ "7.68" ], "max_result": [ "20000" ], "test_run_times": [ 184.590000000000003410605131648480892181396484375, 189.849999999999994315658113919198513031005859375, 191.969999999999998863131622783839702606201171875, 190.6100000000000136424205265939235687255859375, 190.8600000000000136424205265939235687255859375 ], "details": { "install-footnote": "ClickHouse server version 22.7.1.687 (official build)." } }, "D": { "value": 95.849999999999994315658113919198513031005859375, "raw_values": [ 96.23797756279600434936583042144775390625, 94.1384498768640014532138593494892120361328125, 94.405319105035005122772417962551116943359375, 98.624053348600000390433706343173980712890625 ], "min_result": [ "7.68" ], "max_result": [ "30000" ], "test_run_times": [ 183.93999999999999772626324556767940521240234375, 190.6100000000000136424205265939235687255859375, 191.979999999999989768184605054557323455810546875, 187.789999999999992041921359486877918243408203125 ], "details": { "install-footnote": "ClickHouse server version 22.7.1.687 (official build)." } } } } } }