Skip to content

Instantly share code, notes, and snippets.

@nileema

nileema/gist:afaa1c69c4ef61c25ecf

Last active August 29, 2015 14:06
Show Gist options
  • Save nileema/afaa1c69c4ef61c25ecf to your computer and use it in GitHub Desktop.
Save nileema/afaa1c69c4ef61c25ecf to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
== GroupByHashBenchmark (trunk) ==
Benchmark Mode Samples Score Score error Units
c.f.p.o.GroupByHashBenchmark.testExistingGroupIds avgt 10 0.005 0.000 ms/op // all groupIds already exist
c.f.p.o.GroupByHashBenchmark.testNewGroupIds avgt 10 0.996 0.165 ms/op // all groupIds new
c.f.p.o.GroupByHashBenchmark.testMixGroupIds avgt 10 0.007 0.000 ms/op // half already exist
== GroupByHashBenchmark (branch) ==
Benchmark Mode Samples Score Score error Units
c.f.p.o.GroupByHashBenchmark.testExistingGroupIds avgt 10 0.006 0.000 ms/op
c.f.p.o.GroupByHashBenchmark.testNewGroupIds avgt 10 0.024 0.000 ms/op
c.f.p.o.GroupByHashBenchmark.testMixGroupIds avgt 10 0.007 0.000 ms/op
== Operator benchmarks (trunk) ==
sql_hash_join :: 2221.793 cpu ms :: in 7.5M, 129MB, 3.38M/s, 58MB/s :: out 6M, 229MB, 2.7M/s, 103MB/s
sql_join_with_predicate :: 617.452 cpu ms :: in 7.5M, 116MB, 12.1M/s, 188MB/s :: out 1, 1.02KB, 1/s, 1.66KB/s
sql_varbinary_max :: 149.928 cpu ms :: in 6M, 97.3MB, 40M/s, 649MB/s :: out 1, 57B, 6/s, 380B/s
sql_distinct_multi :: 152.790 cpu ms :: in 1.5M, 39.2MB, 9.82M/s, 257MB/s :: out 5, 1.16KB, 32/s, 7.56KB/s
sql_distinct_single :: 80.312 cpu ms :: in 1.5M, 12.9MB, 18.7M/s, 160MB/s :: out 1, 1.02KB, 12/s, 12.7KB/s
sql_tpch_query_1 :: 1952.687 cpu ms :: in 6M, 458MB, 3.07M/s, 235MB/s :: out 4, 8.49KB, 2/s, 4.35KB/s
sql_tpch_query_6 :: 194.141 cpu ms :: in 6M, 271MB, 30.9M/s, 1.36GB/s :: out 1, 1.02KB, 5/s, 5.27KB/s
sql_like :: 2080.670 cpu ms :: in 6M, 270MB, 2.88M/s, 130MB/s :: out 1.15M, 10.9MB, 551K/s, 5.25MB/s
sql_in :: 50.943 cpu ms :: in 6M, 51.5MB, 118M/s, 1011MB/s :: out 25, 1.21KB, 490/s, 23.8KB/s
sql_semijoin_in :: 1285.401 cpu ms :: in 7.5M, 64.4MB, 5.84M/s, 50.1MB/s :: out 3M, 28.6MB, 2.33M/s, 22.3MB/s
sql_regexp_like :: 1662.600 cpu ms :: in 1.5M, 76.6MB, 902K/s, 46.1MB/s :: out 1, 1.02KB, 0/s, 630B/s
sql_approx_percentile_long :: 466.776 cpu ms :: in 1.5M, 12.9MB, 3.21M/s, 27.6MB/s :: out 1, 1.02KB, 2/s, 2.19KB/s
sql_between_long :: 33.969 cpu ms :: in 1.5M, 12.9MB, 44.2M/s, 379MB/s :: out 1, 1.02KB, 29/s, 30.1KB/s
INFO: === Actually running benchmarks for metrics ===
sql_hash_join :: 2265.319 cpu ms :: in 7.5M, 129MB, 3.31M/s, 56.9MB/s :: out 6M, 229MB, 2.65M/s, 101MB/s
sql_join_with_predicate :: 578.681 cpu ms :: in 7.5M, 116MB, 13M/s, 200MB/s :: out 1, 1.02KB, 1/s, 1.77KB/s
sql_varbinary_max :: 149.938 cpu ms :: in 6M, 97.3MB, 40M/s, 649MB/s :: out 1, 57B, 6/s, 380B/s
sql_distinct_multi :: 146.442 cpu ms :: in 1.5M, 39.2MB, 10.2M/s, 268MB/s :: out 5, 1.16KB, 34/s, 7.89KB/s
sql_distinct_single :: 76.024 cpu ms :: in 1.5M, 12.9MB, 19.7M/s, 169MB/s :: out 1, 1.02KB, 13/s, 13.5KB/s
sql_tpch_query_1 :: 1923.755 cpu ms :: in 6M, 458MB, 3.12M/s, 238MB/s :: out 4, 8.49KB, 2/s, 4.41KB/s
sql_tpch_query_6 :: 185.833 cpu ms :: in 6M, 271MB, 32.3M/s, 1.42GB/s :: out 1, 1.02KB, 5/s, 5.51KB/s
sql_like :: 2027.144 cpu ms :: in 6M, 270MB, 2.96M/s, 133MB/s :: out 1.15M, 10.9MB, 566K/s, 5.39MB/s
sql_in :: 46.048 cpu ms :: in 6M, 51.5MB, 130M/s, 1.09GB/s :: out 25, 1.21KB, 542/s, 26.3KB/s
sql_semijoin_in :: 1232.444 cpu ms :: in 7.5M, 64.4MB, 6.09M/s, 52.3MB/s :: out 3M, 28.6MB, 2.43M/s, 23.2MB/s
sql_regexp_like :: 1635.956 cpu ms :: in 1.5M, 76.6MB, 917K/s, 46.8MB/s :: out 1, 1.02KB, 0/s, 640B/s
sql_approx_percentile_long :: 468.724 cpu ms :: in 1.5M, 12.9MB, 3.2M/s, 27.5MB/s :: out 1, 1.02KB, 2/s, 2.18KB/s
sql_between_long :: 32.793 cpu ms :: in 1.5M, 12.9MB, 45.7M/s, 393MB/s :: out 1, 1.02KB, 30/s, 31.2KB/s
== Operator benchmarks (branch) ==
sql_hash_join :: 2220.349 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 6M, 229MB, 2.7M/s, 103MB/s
sql_join_with_predicate :: 620.674 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 1, 1.02KB, 1/s, 1.65KB/s
sql_varbinary_max :: 164.966 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 1, 57B, 6/s, 345B/s
sql_distinct_multi :: 278.422 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 5, 1.16KB, 17/s, 4.15KB/s
sql_distinct_single :: 115.175 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 1, 1.02KB, 8/s, 8.89KB/s
sql_tpch_query_1 :: 2389.707 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 4, 8.49KB, 1/s, 3.55KB/s
sql_tpch_query_6 :: 211.681 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 1, 1.02KB, 4/s, 4.83KB/s
sql_like :: 2186.711 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 1.15M, 10.9MB, 524K/s, 5MB/s
sql_in :: 54.429 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 25, 1.21KB, 459/s, 22.2KB/s
sql_semijoin_in :: 1554.390 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 3M, 28.6MB, 1.93M/s, 18.4MB/s
sql_regexp_like :: 1726.540 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 1, 1.02KB, 0/s, 606B/s
sql_approx_percentile_long :: 514.908 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 1, 1.02KB, 1/s, 1.99KB/s
sql_between_long :: 36.581 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 1, 1.02KB, 27/s, 28KB/s
INFO: === Actually running benchmarks for metrics ===
sql_hash_join :: 2289.612 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 6M, 229MB, 2.62M/s, 100MB/s
sql_join_with_predicate :: 591.450 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 1, 1.02KB, 1/s, 1.73KB/s
sql_varbinary_max :: 147.551 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 1, 57B, 6/s, 386B/s
sql_distinct_multi :: 256.317 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 5, 1.16KB, 19/s, 4.51KB/s
sql_distinct_single :: 109.679 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 1, 1.02KB, 9/s, 9.33KB/s
sql_tpch_query_1 :: 2275.252 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 4, 8.49KB, 1/s, 3.73KB/s
sql_tpch_query_6 :: 190.446 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 1, 1.02KB, 5/s, 5.37KB/s
sql_like :: 2096.282 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 1.15M, 10.9MB, 547K/s, 5.21MB/s
sql_in :: 50.066 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 25, 1.21KB, 499/s, 24.2KB/s
sql_semijoin_in :: 1576.843 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 3M, 28.6MB, 1.9M/s, 18.2MB/s
sql_regexp_like :: 1713.643 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 1, 1.02KB, 0/s, 611B/s
sql_approx_percentile_long :: 521.530 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 1, 1.02KB, 1/s, 1.96KB/s
sql_between_long :: 36.831 cpu ms :: in 0, 0B, 0/s, 0B/s :: out 1, 1.02KB, 27/s, 27.8KB/s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment