Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
189
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.55 KB | None | 0 0
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement