-
-
Save kokosing/9e4a0cdd7b314e9f071b9bac4f782b8d to your computer and use it in GitHub Desktop.
reorder joins log
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| nation - region [repartition] is (cpu: 2900, mem: 25, net: 0) (1 from 2,3) | |
| nation - region [repartition flipped] is (cpu: 2900, mem: 500, net: 0) (4 from 3,2) | |
| nation - region [best] is (cpu: 2900, mem: 25, net: 0) (1 from 2,3) | |
| supplier - nation,region [repartition] is (cpu: 12425, mem: 175, net: 0) (5 from 6,1) | |
| supplier - nation,region [repartition flipped] is (cpu: 12425, mem: 2050, net: 0) (7 from 1,6) | |
| supplier - nation,region [best] is (cpu: 12425, mem: 175, net: 0) (5 from 6,1) | |
| supplier - nation [repartition] is (cpu: 9500, mem: 500, net: 0) (8 from 6,2) | |
| supplier - nation [repartition flipped] is (cpu: 9500, mem: 2000, net: 0) (9 from 2,6) | |
| supplier - nation [best] is (cpu: 9500, mem: 500, net: 0) (8 from 6,2) | |
| nation,supplier - region [repartition] is (cpu: 22775, mem: 1025, net: 0) (10 from 8,3) | |
| nation,supplier - region [repartition flipped] is (cpu: 22775, mem: 3000, net: 0) (11 from 3,8) | |
| nation,supplier - region [best] is (cpu: 22775, mem: 1025, net: 0) (10 from 8,3) | |
| partsupp - nation,region,supplier [repartition] is (cpu: 545350, mem: 850, net: 0) (12 from 13,5) | |
| partsupp - nation,region,supplier [repartition flipped] is (cpu: 545350, mem: 160350, net: 0) (14 from 5,13) | |
| partsupp - nation,region,supplier [best] is (cpu: 545350, mem: 850, net: 0) (12 from 13,5) | |
| partsupp - supplier [repartition] is (cpu: 646000, mem: 2000, net: 0) (15 from 13,6) | |
| partsupp - supplier [repartition flipped] is (cpu: 646000, mem: 160000, net: 0) (16 from 6,13) | |
| partsupp - supplier [best] is (cpu: 646000, mem: 2000, net: 0) (15 from 13,6) | |
| partsupp,supplier - nation,region [repartition] is (cpu: 1497925, mem: 4175, net: 0) (17 from 15,1) | |
| partsupp,supplier - nation,region [repartition flipped] is (cpu: 1497925, mem: 164050, net: 0) (18 from 1,15) | |
| partsupp,supplier - nation,region [best] is (cpu: 1497925, mem: 4175, net: 0) (17 from 15,1) | |
| partsupp - nation,supplier [repartition] is (cpu: 661000, mem: 3000, net: 0) (19 from 13,8) | |
| partsupp - nation,supplier [repartition flipped] is (cpu: 661000, mem: 161000, net: 0) (20 from 8,13) | |
| partsupp - nation,supplier [best] is (cpu: 661000, mem: 3000, net: 0) (19 from 13,8) | |
| partsupp,supplier - nation [repartition] is (cpu: 1613500, mem: 4500, net: 0) (21 from 15,2) | |
| partsupp,supplier - nation [repartition flipped] is (cpu: 1613500, mem: 164000, net: 0) (22 from 2,15) | |
| partsupp,supplier - nation [best] is (cpu: 1613500, mem: 4500, net: 0) (21 from 15,2) | |
| nation,partsupp,supplier - region [repartition] is (cpu: 1523275, mem: 6025, net: 0) (23 from 19,3) | |
| nation,partsupp,supplier - region [repartition flipped] is (cpu: 1523275, mem: 166000, net: 0) (24 from 3,19) | |
| nation,partsupp,supplier - region [best] is (cpu: 1523275, mem: 6025, net: 0) (23 from 19,3) | |
| part - nation,partsupp,region,supplier [repartition] is (cpu: 1851300, mem: 41700, net: 0) (25 from 26,12) | |
| part - nation,partsupp,region,supplier [repartition flipped] is (cpu: 1851300, mem: 1900, net: 0) (27 from 12,26) | |
| part - nation,partsupp,region,supplier [best] is (cpu: 1851300, mem: 41700, net: 0) (25 from 26,12) | |
| part - partsupp [repartition] is (cpu: 1201400, mem: 160000, net: 0) (28 from 26,13) | |
| part - partsupp [repartition flipped] is (cpu: 1201400, mem: 200, net: 0) (29 from 13,26) | |
| part - partsupp [best] is (cpu: 1201400, mem: 160000, net: 0) (28 from 26,13) | |
| part,partsupp - nation,region,supplier [repartition] is (cpu: 2428950, mem: 320850, net: 0) (30 from 28,5) | |
| part,partsupp - nation,region,supplier [repartition flipped] is (cpu: 2428950, mem: 321150, net: 0) (31 from 5,28) | |
| part,partsupp - nation,region,supplier [best] is (cpu: 2428950, mem: 320850, net: 0) (30 from 28,5) | |
| part - partsupp,supplier [repartition] is (cpu: 2173400, mem: 164000, net: 0) (32 from 26,15) | |
| part - partsupp,supplier [repartition flipped] is (cpu: 2173400, mem: 4200, net: 0) (33 from 15,26) | |
| part - partsupp,supplier [best] is (cpu: 2173400, mem: 164000, net: 0) (32 from 26,15) | |
| part,partsupp - supplier [repartition] is (cpu: 2410400, mem: 322000, net: 0) (34 from 28,6) | |
| part,partsupp - supplier [repartition flipped] is (cpu: 2410400, mem: 320800, net: 0) (35 from 6,28) | |
| part,partsupp - supplier [best] is (cpu: 2410400, mem: 322000, net: 0) (34 from 28,6) | |
| part,partsupp,supplier - nation,region [repartition] is (cpu: 4353525, mem: 328175, net: 0) (36 from 32,1) | |
| part,partsupp,supplier - nation,region [repartition flipped] is (cpu: 4353525, mem: 328850, net: 0) (37 from 1,32) | |
| part,partsupp,supplier - nation,region [best] is (cpu: 4353525, mem: 328175, net: 0) (36 from 32,1) | |
| part - nation,partsupp,supplier [repartition] is (cpu: 2203400, mem: 166000, net: 0) (38 from 26,19) | |
| part - nation,partsupp,supplier [repartition flipped] is (cpu: 2203400, mem: 6200, net: 0) (39 from 19,26) | |
| part - nation,partsupp,supplier [best] is (cpu: 2203400, mem: 166000, net: 0) (38 from 26,19) | |
| part,partsupp - nation,supplier [repartition] is (cpu: 2425400, mem: 323000, net: 0) (40 from 28,8) | |
| part,partsupp - nation,supplier [repartition flipped] is (cpu: 2425400, mem: 321800, net: 0) (41 from 8,28) | |
| part,partsupp - nation,supplier [best] is (cpu: 2425400, mem: 323000, net: 0) (40 from 28,8) | |
| part,partsupp,supplier - nation [repartition] is (cpu: 4349900, mem: 328500, net: 0) (42 from 32,2) | |
| part,partsupp,supplier - nation [repartition flipped] is (cpu: 4349900, mem: 328800, net: 0) (43 from 2,32) | |
| part,partsupp,supplier - nation [best] is (cpu: 4349900, mem: 328500, net: 0) (42 from 32,2) | |
| nation,part,partsupp,supplier - region [repartition] is (cpu: 4408875, mem: 332025, net: 0) (44 from 38,3) | |
| nation,part,partsupp,supplier - region [repartition flipped] is (cpu: 4408875, mem: 332800, net: 0) (45 from 3,38) | |
| nation,part,partsupp,supplier - region [best] is (cpu: 4408875, mem: 332025, net: 0) (44 from 38,3) | |
| [best of the best] is (cpu: 1851300, mem: 41700, net: 0) (25 from 26,12) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
That was for partial TPCH q2: