🌚🌞

ClickBench - internal - Release v1.2.715-nightly

Clickbench | Release Versions | Changeset Detail
System: All Databend(Release@v1.2.715-nightly)Databend(Release@v1.2.705-nightly)Databend(Release@v1.2.714-nightly)Databend(Release@v1.2.710-nightly)Databend(Release@v1.2.708-nightly)Databend(Release@v1.2.713-nightly)Databend(Release@v1.2.703-nightly)Databend(Release@v1.2.712-nightly)Databend(Release@v1.2.707-nightly)
Type: All gp3
Machine: All m6a.4xlargem5a.4xlargem5.4xlarge
Cluster size: All 1
Metric: Cold Run Hot Run Load Time Storage Size
System & Machine Relative time (lower is better)
Databend(Release@v1.2.705-nightly) (m6a.4xlarge)†commit: 6f5d9414442780fe94b7613296b8c24b24430d04:
×1.02
Databend(Release@v1.2.708-nightly) (m6a.4xlarge)†commit: be1f233cb633e937650302ecd8da7210ef8423fa:
×1.03
Databend(Release@v1.2.714-nightly) (m6a.4xlarge)†commit: 59a3e4bd209cce35a63f8b094ca92294094b0305:
×1.04
Databend(Release@v1.2.703-nightly) (m6a.4xlarge)†commit: 1ad2acb810ffeca33795754d5bdb09f4e54ef295:
×1.05
Databend(Release@v1.2.715-nightly) (m6a.4xlarge)†commit: 59a3e4bd209cce35a63f8b094ca92294094b0305:
×1.05
Databend(Release@v1.2.707-nightly) (m5.4xlarge)†commit: ff841d133b7daff17e897a521160b512aec6c68f:
×1.11
Databend(Release@v1.2.712-nightly) (m5a.4xlarge)†commit: cd95677341185d289dd1d0c304da4646e2a28269:
×1.71
Databend(Release@v1.2.710-nightly) (m5a.4xlarge)†commit: b83cb6e4c9ffa6558f57d8d59f5afd13b5cc9113:
×1.71
Databend(Release@v1.2.713-nightly) (m5a.4xlarge)†commit: 73862939fec735699f0a70f54624817f2d9f3703:
×1.72

Detailed Comparison

Databend(Release@v1.2.705-nightly) (m6a.4xlarge)Databend(Release@v1.2.708-nightly) (m6a.4xlarge)Databend(Release@v1.2.714-nightly) (m6a.4xlarge)Databend(Release@v1.2.703-nightly) (m6a.4xlarge)Databend(Release@v1.2.715-nightly) (m6a.4xlarge)Databend(Release@v1.2.707-nightly) (m5.4xlarge)Databend(Release@v1.2.712-nightly) (m5a.4xlarge)Databend(Release@v1.2.710-nightly) (m5a.4xlarge)Databend(Release@v1.2.713-nightly) (m5a.4xlarge)
Load time: 574s (×1.00)588s (×1.03)573s (×1.00)581s (×1.01)595s (×1.04)578s (×1.01)792s (×1.38)765s (×1.34)764s (×1.33)
Data size: ☠☠☠☠☠☠☠☠☠
Q0. Query 0: -- test system table query speed select name from system.tables union all select name from system.columns union all select name from system.databases union all select name from system.functions ignore_result; 0.22s (×1.07)0.21s (×1.05)0.20s (×1.00)0.21s (×1.03)0.22s (×1.07)0.25s (×1.21)0.41s (×1.97)0.42s (×2.02)0.42s (×2.01)
Q1. Query 1: select name from system.tables where name='t_1'; 0.01s (×1.00)0.01s (×1.00)0.01s (×1.06)0.01s (×1.06)0.01s (×1.06)0.01s (×1.06)0.02s (×1.44)0.02s (×1.44)0.02s (×1.44)
Q2. Query 2: select name from system.tables where name in ('t_1', 't_2'); 0.01s (×1.00)0.01s (×1.04)0.01s (×1.00)0.01s (×1.04)0.01s (×1.04)0.01s (×1.00)0.03s (×1.52)0.03s (×1.57)0.03s (×1.57)
Q3. Query 3: select name from system.tables_with_history where name in ('t_1', 't_2'); 0.01s (×1.04)0.01s (×1.04)0.01s (×1.04)0.01s (×1.09)0.01s (×1.04)0.01s (×1.00)0.03s (×1.57)0.03s (×1.57)0.03s (×1.57)
Q4. Query 4: select (number::string)::Int from numbers(100000000) ignore_result; 0.27s (×1.00)0.27s (×1.01)0.30s (×1.11)0.28s (×1.02)0.28s (×1.03)0.37s (×1.34)0.59s (×2.13)0.57s (×2.06)0.58s (×2.10)