datafuse-v0.4.76-nightly-numbers-table-performance

datafuse-v0.4.76-nightly-numbers-table-performance

bohu@thinkpad:~/github/cppwork/ClickHouse/build$ ./programs/clickhouse client
ClickHouse client version 21.9.1.1.
Connecting to localhost:9000 as user default.
Connected to datafuse server version 2021.5.0 revision 54405.

ClickHouse client version is older than ClickHouse server. It may lack support for new features.

datafuse :) SELECT avg(number) FROM numbers_mt(100000000000)

SELECT avg(number)
FROM numbers_mt(100000000000)

Query id: 5fa61828-a680-4b6a-89b2-6d409bd8bc4f

Connecting to localhost:9000 as user default.
Connected to datafuse server version 2021.5.0 revision 54405.

ClickHouse client version is older than ClickHouse server. It may lack support for new features.

┌──────avg(number)─┐
│ 9323559.74711512 │
└──────────────────┘

1 rows in set. Elapsed: 3.712 sec. Processed 100.00 billion rows, 800.00 GB (26.94 billion rows/s., 215.52 GB/s.)

datafuse :) SELECT sum(number) FROM numbers_mt(100000000000)

SELECT sum(number)
FROM numbers_mt(100000000000)

Query id: 71a94ea9-c31f-461b-930c-805a619961b9

┌────────sum(number)─┐
│ 932355974711512064 │
└────────────────────┘

1 rows in set. Elapsed: 3.669 sec. Processed 100.00 billion rows, 800.00 GB (27.26 billion rows/s., 218.07 GB/s.)

datafuse :) SELECT min(number) FROM numbers_mt(100000000000)

SELECT min(number)
FROM numbers_mt(100000000000)

Query id: 8b4c0ad0-5c5a-4b12-8244-f5da76c8997c

┌─min(number)─┐
│           0 │
└─────────────┘

1 rows in set. Elapsed: 4.498 sec. Processed 100.00 billion rows, 800.00 GB (22.23 billion rows/s., 177.85 GB/s.)

datafuse :) SELECT max(number) FROM numbers_mt(100000000000)

SELECT max(number)
FROM numbers_mt(100000000000)

Query id: c5c6d6ab-8db6-4625-9bd3-91fe5f08fd7a

┌─max(number)─┐
│ 99999999999 │
└─────────────┘

1 rows in set. Elapsed: 4.438 sec. Processed 100.00 billion rows, 800.00 GB (22.53 billion rows/s., 180.25 GB/s.)

datafuse :) SELECT count(number) FROM numbers_mt(100000000000)

SELECT count(number)
FROM numbers_mt(100000000000)

Query id: 724030d3-4f3b-47d2-ba11-fc04e63aaf4c

┌─count(number)─┐
│  100000000000 │
└───────────────┘

1 rows in set. Elapsed: 2.125 sec. Processed 100.00 billion rows, 800.00 GB (47.07 billion rows/s., 376.53 GB/s.)

datafuse :) SELECT sum(number+number+number) FROM numbers_mt(100000000000)

SELECT sum((number + number) + number)
FROM numbers_mt(100000000000)

Query id: 4acb7084-cc37-4147-b0ea-65c5d60af7f9

┌─sum(((number + number) + number))─┐
│               2797067924134536192 │
└───────────────────────────────────┘

1 rows in set. Elapsed: 17.169 sec. Processed 100.00 billion rows, 800.00 GB (5.82 billion rows/s., 46.60 GB/s.)

datafuse :) SELECT sum(number) / count(number) FROM numbers_mt(100000000000)

SELECT sum(number) / count(number)
FROM numbers_mt(100000000000)

Query id: 019a4231-0353-4a76-8fbc-a324dc867440

┌─(sum(number) / count(number))─┐
│              9323559.74711512 │
└───────────────────────────────┘

1 rows in set. Elapsed: 3.696 sec. Processed 100.00 billion rows, 800.00 GB (27.06 billion rows/s., 216.45 GB/s.)

datafuse :) SELECT sum(number) / count(number), max(number), min(number) FROM numbers_mt(100000000000)

SELECT
    sum(number) / count(number),
    max(number),
    min(number)
FROM numbers_mt(100000000000)

Query id: 8b6bf465-b9e0-4ab8-8e31-967cdc7a8f86

┌─(sum(number) / count(number))─┬─max(number)─┬─min(number)─┐
│              9323559.74711512 │ 99999999999 │           0 │
└───────────────────────────────┴─────────────┴─────────────┘

1 rows in set. Elapsed: 8.348 sec. Processed 100.00 billion rows, 800.00 GB (11.98 billion rows/s., 95.83 GB/s.)

datafuse :) SELECT number FROM numbers_mt(10000000000) ORDER BY number DESC LIMIT 10

SELECT number
FROM numbers_mt(10000000000)
ORDER BY number DESC
LIMIT 10

Query id: daa8c9b9-cd57-4fb8-923c-78bfd4628462

┌─────number─┐
│ 9999999999 │
│ 9999999998 │
│ 9999999997 │
│ 9999999996 │
│ 9999999995 │
│ 9999999994 │
│ 9999999993 │
│ 9999999992 │
│ 9999999991 │
│ 9999999990 │
└────────────┘

10 rows in set. Elapsed: 3.164 sec. Processed 10.00 billion rows, 80.00 GB (3.16 billion rows/s., 25.28 GB/s.)

datafuse :) SELECT max(number), sum(number) FROM numbers_mt(1000000000) GROUP BY number % 3, number % 4, number % 5 LIMIT 10

SELECT
    max(number),
    sum(number)
FROM numbers_mt(1000000000)
GROUP BY
    number % 3,
    number % 4,
    number % 5
LIMIT 10

Query id: e42d64e5-0969-46f6-aadc-8bfd9654dae8

┌─max(number)─┬──────sum(number)─┐
│   999999954 │ 8333333066666664 │
│   999999988 │ 8333333633333336 │
│   999999990 │ 8333333666666670 │
│   999999976 │ 8333333433333332 │
│   999999966 │ 8333333266666662 │
│   999999957 │ 8333333116666662 │
│   999999996 │ 8333333766666672 │
│   999999948 │ 8333332966666668 │
│   999999992 │ 8333333700000004 │
│   999999959 │ 8333333149999994 │
└─────────────┴──────────────────┘

10 rows in set. Elapsed: 1.657 sec. Processed 1.00 billion rows, 8.00 GB (603.62 million rows/s., 4.83 GB/s.)

datafuse :)