internal/storage/v2/clickhouse/BENCHMARKING.md
| Component | Details |
|---|---|
| VM | Oracle Cloud VM.Standard2.4 (4 OCPUs, Intel Xeon Platinum 8167M) |
| Memory | 60 GB |
| Disk | 47 GB block storage |
| OS | Oracle Linux 9 |
| ClickHouse | 26 (single-node) |
| Parameter | Value |
|---|---|
| Total traces | 1,000,000 |
| Spans per trace | 10 (1 parent + 9 children) |
| Total spans | 10,000,000 |
| Services | 10 |
| Partitions (days) | 10 |
| Attributes per span | 11 (across 97 distinct keys, 1000 distinct values) |
spans table)| Metric | Value |
|---|---|
| Uncompressed size | 5.99 GiB |
| Compressed size | 722.09 MiB |
| Compression ratio | 8.6x |
Script: table_compression_spans
| Metric | Value |
|---|---|
| Total spans | 10,000,000 |
| Total insert duration | 191.8 s |
| Throughput (spans/sec) | 52,129 |
Script: schema_insert
Each query was run 3 times. The table shows averages across all runs.
| Query | Avg Duration |
|---|---|
| Retrieve services | 3 ms |
| Retrieve operations | 4 ms |
| Get trace by ID | 101 ms |
| Query | Avg Duration |
|---|---|
| Search by service | 37 ms |
| Search by operation | 38 ms |
| Search by duration range | 43 ms |
| Search by timestamp range | 47 ms |
| Search by attribute | 1,769 ms |
| Search by all filters | 139 ms |
See the clickhouse-benchmarking repository for setup and reproduction instructions.