Advertisement
Guest User

Untitled

a guest
Jan 29th, 2020
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.74 KB | None | 0 0
  1. [
  2. {
  3. "hostname": "max42-dev.sas.yp-c.yandex.net",
  4. "num_cores": 100,
  5. "num_threads": 100,
  6. "path": "/home/max42/clickhouse/source/dbms/tests/performance/merge_tree_huge_pk.xml",
  7. "ram": 115098206208,
  8. "runs": [
  9. {
  10. "bytes_per_second": 0.000000,
  11. "memory_usage": 0,
  12. "min_time": 0.008000,
  13. "quantiles": {
  14. "0.1": 0.008826,
  15. "0.2": 0.008931,
  16. "0.3": 0.009175,
  17. "0.4": 0.009472,
  18. "0.5": 0.009713,
  19. "0.6": 0.010364,
  20. "0.7": 0.011807,
  21. "0.8": 0.012509,
  22. "0.9": 0.014274,
  23. "0.95": 0.019948,
  24. "0.99": 0.034220,
  25. "0.999": 0.039120,
  26. "0.9999": 0.039610
  27. },
  28. "queries_per_second": 85.501118,
  29. "query": "SELECT count() FROM huge_pk WHERE c001 > 10",
  30. "query_index": 0,
  31. "rows_per_second": 0.000000,
  32. "total_time": 0.584788
  33. },
  34. {
  35. "bytes_per_second": 13246836.159883,
  36. "memory_usage": 0,
  37. "min_time": 0.097000,
  38. "quantiles": {
  39. "0.1": 0.098328,
  40. "0.2": 0.098767,
  41. "0.3": 0.099068,
  42. "0.4": 0.099327,
  43. "0.5": 0.099609,
  44. "0.6": 0.100069,
  45. "0.7": 0.100694,
  46. "0.8": 0.101225,
  47. "0.9": 0.102424,
  48. "0.95": 0.102997,
  49. "0.99": 0.106975,
  50. "0.999": 0.108321,
  51. "0.9999": 0.108456
  52. },
  53. "queries_per_second": 9.981762,
  54. "query": "SELECT count() FROM huge_pk WHERE c001 in (2,3) and c400 in (10,0) and c100 < 2",
  55. "query_index": 1,
  56. "rows_per_second": 4415612.053294,
  57. "total_time": 5.009136
  58. },
  59. {
  60. "bytes_per_second": 39644642.246356,
  61. "memory_usage": 0,
  62. "min_time": 0.022000,
  63. "quantiles": {
  64. "0.1": 0.023330,
  65. "0.2": 0.023755,
  66. "0.3": 0.023789,
  67. "0.4": 0.024070,
  68. "0.5": 0.024304,
  69. "0.6": 0.024423,
  70. "0.7": 0.024760,
  71. "0.8": 0.025900,
  72. "0.9": 0.029980,
  73. "0.95": 0.037416,
  74. "0.99": 0.057917,
  75. "0.999": 0.072033,
  76. "0.9999": 0.073445
  77. },
  78. "queries_per_second": 37.808077,
  79. "query": "SELECT count() FROM huge_pk WHERE c700 > 10",
  80. "query_index": 2,
  81. "rows_per_second": 39644642.246356,
  82. "total_time": 1.322469
  83. },
  84. {
  85. "bytes_per_second": 76854568.019200,
  86. "memory_usage": 0,
  87. "min_time": 0.010000,
  88. "quantiles": {
  89. "0.1": 0.011654,
  90. "0.2": 0.011737,
  91. "0.3": 0.011899,
  92. "0.4": 0.012116,
  93. "0.5": 0.012408,
  94. "0.6": 0.012807,
  95. "0.7": 0.013545,
  96. "0.8": 0.014549,
  97. "0.9": 0.015611,
  98. "0.95": 0.018859,
  99. "0.99": 0.028449,
  100. "0.999": 0.028478,
  101. "0.9999": 0.028481
  102. },
  103. "queries_per_second": 73.294228,
  104. "query": "SELECT count() FROM huge_pk WHERE c701 > 10",
  105. "query_index": 3,
  106. "rows_per_second": 76854568.019200,
  107. "total_time": 0.682182
  108. }
  109. ],
  110. "server_version": "20.2.1",
  111. "test_name": "merge_tree_huge_pk",
  112. "time": "2020-01-30 00:33:05"
  113. }
  114. ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement