Skip to content

Instantly share code, notes, and snippets.

@tom-clickhouse
Created October 17, 2023 19:48
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save tom-clickhouse/5517b902d3990f7299d747bedbd5fd77 to your computer and use it in GitHub Desktop.
------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
-- 9 nodes
------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
-- clickhouse-client output --------------------------------------------------------------------------------------------
0 rows in set. Elapsed: 1664.259 sec. Processed 65.33 billion rows, 9.60 TB (39.26 million rows/s., 5.77 GB/s.)
Peak memory usage: 231.76 GiB.
-- active parts at ingest finish
┌─parts─┐
│ 4918 │
└───────┘
-- time to 3k active parts
┌─seconds─┬─parts─┐
│ 2232 │ 2994 │
└─────────┴───────┘
------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
-- 6 nodes
------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
-- clickhouse-client output --------------------------------------------------------------------------------------------
0 rows in set. Elapsed: 2466.766 sec. Processed 65.33 billion rows, 9.60 TB (26.49 million rows/s., 3.89 GB/s.)
Peak memory usage: 232.68 GiB.
-- active parts at ingest finish
┌─parts─┐
│ 4468 │
└───────┘
-- time to 3k active parts
┌─seconds─┬─parts─┐
│ 3081 │ 2996 │
└─────────┴───────┘
------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
-- 3 nodes
------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
-- clickhouse-client output --------------------------------------------------------------------------------------------
0 rows in set. Elapsed: 4759.683 sec. Processed 65.33 billion rows, 9.60 TB (13.73 million rows/s., 2.02 GB/s.)
Peak memory usage: 231.84 GiB.
-- active parts at ingest finish
┌─parts─┐
│ 4042 │
└───────┘
-- time to 3k active parts
┌─seconds─┬─parts─┐
│ 5527 │ 2996 │
└─────────┴───────┘
------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
-- 1 node
------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
-- clickhouse-client output --------------------------------------------------------------------------------------------
0 rows in set. Elapsed: 14700.814 sec. Processed 65.33 billion rows, 9.60 TB (4.44 million rows/s., 653.24 MB/s.)
Peak memory usage: 232.14 GiB.
-- time to 3k active parts
┌─seconds─┐
│ 14700 │
└─────────┘
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment