SHARE
TWEET

Untitled

a guest Jun 26th, 2019 71 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. "query": "SELECT COUNT() FROM ints l ANY LEFT JOIN ints r USING i64 WHERE i32 = 200042",    "rows_per_second": mimalloc 26504457.970317, jemalloc 27662583.862927
  2. "query": "SELECT COUNT() FROM ints l ANY LEFT JOIN ints r USING i64,i32,i16,i8 WHERE i32 = 200042", "rows_per_second": mimalloc 19032586.204721, jemalloc 19492576.651780
  3. "query": "SELECT COUNT() FROM ints l ANY LEFT JOIN ints r ON l.i64 = r.i64 WHERE i32 = 200042", "rows_per_second": mimalloc 27614153.181341, jemalloc 35777207.600395
  4. "query": "SELECT COUNT() FROM ints l ANY LEFT JOIN ints r USING i64 WHERE i32 IN(42, 100042, 200042, 300042, 400042)",  "rows_per_second": mimalloc 26286100.706415, jemalloc 32589645.233359
  5. "query": "SELECT COUNT() FROM ints l INNER JOIN ints r USING i64 WHERE i32 = 200042",   "rows_per_second": mimalloc 75832.963162, jemalloc 72902.124045
  6. "query": "SELECT COUNT() FROM ints l INNER JOIN ints r USING i64,i32,i16,i8 WHERE i32 = 200042",    "rows_per_second": mimalloc 56620.741535, jemalloc 54755.655698
  7. "query": "SELECT COUNT() FROM ints l INNER JOIN ints r ON l.i64 = r.i64 WHERE i32 = 200042",    "rows_per_second": mimalloc 78474.874791, jemalloc 73913.133171
  8. "query": "SELECT COUNT() FROM ints l INNER JOIN ints r USING i64 WHERE i32 IN(42, 100042, 200042, 300042, 400042)", "rows_per_second": mimalloc 75858.010327, jemalloc 70721.901393
  9. "query": "SELECT COUNT() FROM ints l LEFT JOIN ints r USING i64 WHERE i32 = 200042",    "rows_per_second": mimalloc 76472.797462, jemalloc 73144.599067
  10. "query": "SELECT COUNT() FROM ints l LEFT JOIN ints r USING i64,i32,i16,i8 WHERE i32 = 200042", "rows_per_second": mimalloc 56736.533755, jemalloc 54268.364466
  11. "query": "SELECT COUNT() FROM ints l LEFT JOIN ints r ON l.i64 = r.i64 WHERE i32 = 200042", "rows_per_second": mimalloc 75478.104478, jemalloc 73319.036800
  12. "query": "SELECT COUNT() FROM ints l LEFT JOIN ints r USING i64 WHERE i32 IN(42, 100042, 200042, 300042, 400042)",  "rows_per_second": mimalloc 72736.311989, jemalloc 70475.855626
  13. "query": "SELECT COUNT() FROM ints l RIGHT JOIN ints r USING i64 WHERE i32 = 200042",   "rows_per_second": mimalloc 77032.300429, jemalloc 74260.718119
  14. "query": "SELECT COUNT() FROM ints l RIGHT JOIN ints r USING i64,i32,i16,i8 WHERE i32 = 200042",    "rows_per_second": mimalloc 56481.367806, jemalloc 54220.609220
  15. "query": "SELECT COUNT() FROM ints l RIGHT JOIN ints r ON l.i64 = r.i64 WHERE i32 = 200042",    "rows_per_second": mimalloc 75734.276779, jemalloc 76919.171553
  16. "query": "SELECT COUNT() FROM ints l RIGHT JOIN ints r USING i64 WHERE i32 IN(42, 100042, 200042, 300042, 400042)", "rows_per_second": mimalloc 74970.671127, jemalloc 70749.306964
  17. "query": "SELECT COUNT() FROM ints l FULL JOIN ints r USING i64 WHERE i32 = 200042",    "rows_per_second": mimalloc 76129.609405, jemalloc 74062.365675
  18. "query": "SELECT COUNT() FROM ints l FULL JOIN ints r USING i64,i32,i16,i8 WHERE i32 = 200042", "rows_per_second": mimalloc 56400.777478, jemalloc 53005.920697
  19. "query": "SELECT COUNT() FROM ints l FULL JOIN ints r ON l.i64 = r.i64 WHERE i32 = 200042", "rows_per_second": mimalloc 77789.431253, jemalloc 72378.802482
  20. "query": "SELECT COUNT() FROM ints l FULL JOIN ints r USING i64 WHERE i32 IN(42, 100042, 200042, 300042, 400042)",  "rows_per_second": mimalloc 74320.745073, jemalloc 68980.391602
  21. "query": "SELECT COUNT() FROM ints l CROSS JOIN (SELECT number as i64 FROM numbers(4)) WHERE i32 = 42", "rows_per_second": mimalloc 16549873.622035, jemalloc 17322938.738656
  22. "query": "SELECT COUNT() FROM ints l CROSS JOIN (SELECT number as i64 FROM numbers(4)) WHERE i32 = 42", "rows_per_second": mimalloc 17315351.140563, jemalloc 16248992.115027
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top