Skip to content

Instantly share code, notes, and snippets.

@alexey-milovidov

alexey-milovidov/uniq_perf_test.json

Created November 23, 2018 20:15
Show Gist options
  • Save alexey-milovidov/9cbbc2916f8d946594049d424487e458 to your computer and use it in GitHub Desktop.
Save alexey-milovidov/9cbbc2916f8d946594049d424487e458 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
uniq_perf_test.json
[
{
"hostname": "mtlog-perftest03j.yandex.ru",
"main_metric": "min_time",
"num_cores": 16,
"num_threads": 32,
"parameters": {
"func": ["sum", "uniq", "uniqExact", "uniqHLL12", "uniqCombined(12)", "uniqCombined(13)", "uniqCombined(14)", "uniqCombined(15)", "uniqCombined(16)", "uniqCombined(17)", "uniqCombined(18)", "uniqCombined(19)", "uniqCombined(20)", "uniqUpTo(3)", "uniqUpTo(5)", "uniqUpTo(10)", "uniqUpTo(25)", "uniqUpTo(100)"],
"key": ["1", "SearchEngineID", "RegionID", "SearchPhrase", "ClientIP"]
},
"ram": 135166869504,
"runs": [
{
"min_time": 0.049000,
"query": "SELECT 1 AS k, sum(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.081000,
"query": "SELECT SearchEngineID AS k, sum(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.099000,
"query": "SELECT RegionID AS k, sum(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.013000,
"query": "SELECT SearchPhrase AS k, sum(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.671000,
"query": "SELECT ClientIP AS k, sum(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.098000,
"query": "SELECT 1 AS k, uniq(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.256000,
"query": "SELECT SearchEngineID AS k, uniq(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.437000,
"query": "SELECT RegionID AS k, uniq(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.139000,
"query": "SELECT SearchPhrase AS k, uniq(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 1.091000,
"query": "SELECT ClientIP AS k, uniq(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 1.568000,
"query": "SELECT 1 AS k, uniqExact(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 1.955000,
"query": "SELECT SearchEngineID AS k, uniqExact(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.839000,
"query": "SELECT RegionID AS k, uniqExact(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 3.314000,
"query": "SELECT SearchPhrase AS k, uniqExact(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 1.323000,
"query": "SELECT ClientIP AS k, uniqExact(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.121000,
"query": "SELECT 1 AS k, uniqHLL12(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.186000,
"query": "SELECT SearchEngineID AS k, uniqHLL12(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.284000,
"query": "SELECT RegionID AS k, uniqHLL12(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.342000,
"query": "SELECT SearchPhrase AS k, uniqHLL12(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 1.262000,
"query": "SELECT ClientIP AS k, uniqHLL12(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.120000,
"query": "SELECT 1 AS k, uniqCombined(12)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.178000,
"query": "SELECT SearchEngineID AS k, uniqCombined(12)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.246000,
"query": "SELECT RegionID AS k, uniqCombined(12)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.220000,
"query": "SELECT SearchPhrase AS k, uniqCombined(12)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 1.034000,
"query": "SELECT ClientIP AS k, uniqCombined(12)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.124000,
"query": "SELECT 1 AS k, uniqCombined(13)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.186000,
"query": "SELECT SearchEngineID AS k, uniqCombined(13)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.279000,
"query": "SELECT RegionID AS k, uniqCombined(13)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.239000,
"query": "SELECT SearchPhrase AS k, uniqCombined(13)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 1.034000,
"query": "SELECT ClientIP AS k, uniqCombined(13)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.125000,
"query": "SELECT 1 AS k, uniqCombined(14)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.202000,
"query": "SELECT SearchEngineID AS k, uniqCombined(14)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.318000,
"query": "SELECT RegionID AS k, uniqCombined(14)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.213000,
"query": "SELECT SearchPhrase AS k, uniqCombined(14)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 1.008000,
"query": "SELECT ClientIP AS k, uniqCombined(14)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.128000,
"query": "SELECT 1 AS k, uniqCombined(15)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.229000,
"query": "SELECT SearchEngineID AS k, uniqCombined(15)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.368000,
"query": "SELECT RegionID AS k, uniqCombined(15)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.173000,
"query": "SELECT SearchPhrase AS k, uniqCombined(15)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 1.005000,
"query": "SELECT ClientIP AS k, uniqCombined(15)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.133000,
"query": "SELECT 1 AS k, uniqCombined(16)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.257000,
"query": "SELECT SearchEngineID AS k, uniqCombined(16)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.422000,
"query": "SELECT RegionID AS k, uniqCombined(16)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.303000,
"query": "SELECT SearchPhrase AS k, uniqCombined(16)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 1.032000,
"query": "SELECT ClientIP AS k, uniqCombined(16)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.143000,
"query": "SELECT 1 AS k, uniqCombined(17)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.292000,
"query": "SELECT SearchEngineID AS k, uniqCombined(17)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.501000,
"query": "SELECT RegionID AS k, uniqCombined(17)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.204000,
"query": "SELECT SearchPhrase AS k, uniqCombined(17)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 1.017000,
"query": "SELECT ClientIP AS k, uniqCombined(17)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.167000,
"query": "SELECT 1 AS k, uniqCombined(18)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.379000,
"query": "SELECT SearchEngineID AS k, uniqCombined(18)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.597000,
"query": "SELECT RegionID AS k, uniqCombined(18)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.359000,
"query": "SELECT SearchPhrase AS k, uniqCombined(18)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 1.044000,
"query": "SELECT ClientIP AS k, uniqCombined(18)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.206000,
"query": "SELECT 1 AS k, uniqCombined(19)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.506000,
"query": "SELECT SearchEngineID AS k, uniqCombined(19)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.636000,
"query": "SELECT RegionID AS k, uniqCombined(19)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.392000,
"query": "SELECT SearchPhrase AS k, uniqCombined(19)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 1.016000,
"query": "SELECT ClientIP AS k, uniqCombined(19)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.290000,
"query": "SELECT 1 AS k, uniqCombined(20)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.713000,
"query": "SELECT SearchEngineID AS k, uniqCombined(20)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.694000,
"query": "SELECT RegionID AS k, uniqCombined(20)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.480000,
"query": "SELECT SearchPhrase AS k, uniqCombined(20)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 1.051000,
"query": "SELECT ClientIP AS k, uniqCombined(20)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.049000,
"query": "SELECT 1 AS k, uniqUpTo(3)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.085000,
"query": "SELECT SearchEngineID AS k, uniqUpTo(3)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.102000,
"query": "SELECT RegionID AS k, uniqUpTo(3)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.143000,
"query": "SELECT SearchPhrase AS k, uniqUpTo(3)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.725000,
"query": "SELECT ClientIP AS k, uniqUpTo(3)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.048000,
"query": "SELECT 1 AS k, uniqUpTo(5)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.085000,
"query": "SELECT SearchEngineID AS k, uniqUpTo(5)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.104000,
"query": "SELECT RegionID AS k, uniqUpTo(5)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.130000,
"query": "SELECT SearchPhrase AS k, uniqUpTo(5)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.773000,
"query": "SELECT ClientIP AS k, uniqUpTo(5)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.048000,
"query": "SELECT 1 AS k, uniqUpTo(10)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.085000,
"query": "SELECT SearchEngineID AS k, uniqUpTo(10)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.107000,
"query": "SELECT RegionID AS k, uniqUpTo(10)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.107000,
"query": "SELECT SearchPhrase AS k, uniqUpTo(10)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.841000,
"query": "SELECT ClientIP AS k, uniqUpTo(10)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.048000,
"query": "SELECT 1 AS k, uniqUpTo(25)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.085000,
"query": "SELECT SearchEngineID AS k, uniqUpTo(25)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.113000,
"query": "SELECT RegionID AS k, uniqUpTo(25)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.252000,
"query": "SELECT SearchPhrase AS k, uniqUpTo(25)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 1.130000,
"query": "SELECT ClientIP AS k, uniqUpTo(25)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.048000,
"query": "SELECT 1 AS k, uniqUpTo(100)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.086000,
"query": "SELECT SearchEngineID AS k, uniqUpTo(100)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 0.130000,
"query": "SELECT RegionID AS k, uniqUpTo(100)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.572000,
"query": "SELECT SearchPhrase AS k, uniqUpTo(100)(UserID) FROM hits_100m_single GROUP BY k"
},
{
"min_time": 2.013000,
"query": "SELECT ClientIP AS k, uniqUpTo(100)(UserID) FROM hits_100m_single GROUP BY k"
}
],
"server_version": "18.14.2",
"test_name": "uniq",
"time": "2018-11-23 23:06:49"
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment