Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [
- {
- "hostname": "max42-dev.sas.yp-c.yandex.net",
- "num_cores": 100,
- "num_threads": 100,
- "path": "/home/max42/clickhouse/source/dbms/tests/performance/merge_tree_huge_pk.xml",
- "ram": 115098206208,
- "runs": [
- {
- "bytes_per_second": 0.000000,
- "memory_usage": 0,
- "min_time": 0.008000,
- "quantiles": {
- "0.1": 0.008826,
- "0.2": 0.008931,
- "0.3": 0.009175,
- "0.4": 0.009472,
- "0.5": 0.009713,
- "0.6": 0.010364,
- "0.7": 0.011807,
- "0.8": 0.012509,
- "0.9": 0.014274,
- "0.95": 0.019948,
- "0.99": 0.034220,
- "0.999": 0.039120,
- "0.9999": 0.039610
- },
- "queries_per_second": 85.501118,
- "query": "SELECT count() FROM huge_pk WHERE c001 > 10",
- "query_index": 0,
- "rows_per_second": 0.000000,
- "total_time": 0.584788
- },
- {
- "bytes_per_second": 13246836.159883,
- "memory_usage": 0,
- "min_time": 0.097000,
- "quantiles": {
- "0.1": 0.098328,
- "0.2": 0.098767,
- "0.3": 0.099068,
- "0.4": 0.099327,
- "0.5": 0.099609,
- "0.6": 0.100069,
- "0.7": 0.100694,
- "0.8": 0.101225,
- "0.9": 0.102424,
- "0.95": 0.102997,
- "0.99": 0.106975,
- "0.999": 0.108321,
- "0.9999": 0.108456
- },
- "queries_per_second": 9.981762,
- "query": "SELECT count() FROM huge_pk WHERE c001 in (2,3) and c400 in (10,0) and c100 < 2",
- "query_index": 1,
- "rows_per_second": 4415612.053294,
- "total_time": 5.009136
- },
- {
- "bytes_per_second": 39644642.246356,
- "memory_usage": 0,
- "min_time": 0.022000,
- "quantiles": {
- "0.1": 0.023330,
- "0.2": 0.023755,
- "0.3": 0.023789,
- "0.4": 0.024070,
- "0.5": 0.024304,
- "0.6": 0.024423,
- "0.7": 0.024760,
- "0.8": 0.025900,
- "0.9": 0.029980,
- "0.95": 0.037416,
- "0.99": 0.057917,
- "0.999": 0.072033,
- "0.9999": 0.073445
- },
- "queries_per_second": 37.808077,
- "query": "SELECT count() FROM huge_pk WHERE c700 > 10",
- "query_index": 2,
- "rows_per_second": 39644642.246356,
- "total_time": 1.322469
- },
- {
- "bytes_per_second": 76854568.019200,
- "memory_usage": 0,
- "min_time": 0.010000,
- "quantiles": {
- "0.1": 0.011654,
- "0.2": 0.011737,
- "0.3": 0.011899,
- "0.4": 0.012116,
- "0.5": 0.012408,
- "0.6": 0.012807,
- "0.7": 0.013545,
- "0.8": 0.014549,
- "0.9": 0.015611,
- "0.95": 0.018859,
- "0.99": 0.028449,
- "0.999": 0.028478,
- "0.9999": 0.028481
- },
- "queries_per_second": 73.294228,
- "query": "SELECT count() FROM huge_pk WHERE c701 > 10",
- "query_index": 3,
- "rows_per_second": 76854568.019200,
- "total_time": 0.682182
- }
- ],
- "server_version": "20.2.1",
- "test_name": "merge_tree_huge_pk",
- "time": "2020-01-30 00:33:05"
- }
- ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement