Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- "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
- "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
- "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
- "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
- "query": "SELECT COUNT() FROM ints l INNER JOIN ints r USING i64 WHERE i32 = 200042", "rows_per_second": mimalloc 75832.963162, jemalloc 72902.124045
- "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
- "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
- "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
- "query": "SELECT COUNT() FROM ints l LEFT JOIN ints r USING i64 WHERE i32 = 200042", "rows_per_second": mimalloc 76472.797462, jemalloc 73144.599067
- "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
- "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
- "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
- "query": "SELECT COUNT() FROM ints l RIGHT JOIN ints r USING i64 WHERE i32 = 200042", "rows_per_second": mimalloc 77032.300429, jemalloc 74260.718119
- "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
- "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
- "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
- "query": "SELECT COUNT() FROM ints l FULL JOIN ints r USING i64 WHERE i32 = 200042", "rows_per_second": mimalloc 76129.609405, jemalloc 74062.365675
- "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
- "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
- "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
- "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
- "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