Created
November 7, 2019 16:32
-
-
Save akuzm/717d844a73eb7c2510760abef434a34e to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2019-11-07 15:00:01,089 ( 0.002s) INFO (root) Query 'SELECT count() FROM system.numbers WHERE NOT ignore(visitParamExtractRaw(materialize('{"myparam":"test_string"}'), 'myparam'))' - /usr/share/clickhouse-test/performance/visit_param_extract_raw.xml failed, got value 18310128, prev 21285669 | |
| 2019-11-07 15:00:01,089 ( 0.000s) INFO (root) Query 'SELECT count() FROM system.numbers WHERE NOT ignore(visitParamExtractRaw(materialize('{"myparam":{"nested_1":"test_string","nested_2":"test_2"}}'), 'myparam'))' - /usr/share/clickhouse-test/performance/visit_param_extract_raw.xml ok, got value 7830467, prev 7946978 | |
| 2019-11-07 15:00:01,090 ( 0.000s) INFO (root) Query 'SELECT count() FROM system.numbers WHERE NOT ignore(visitParamExtractRaw(materialize('{"myparam":{"nested_1":"test_string","nested_2":"test_2","nested_1":"test_string","nested_2":"test_2","nested_1":"test_string","nested_2":"test_2"}}'), 'myparam'))' - /usr/share/clickhouse-test/performance/visit_param_extract_raw.xml ok, got value 2601970, prev 2597717 | |
| 2019-11-07 15:00:01,090 ( 0.000s) INFO (root) Query 'SELECT count() FROM hits_10m_single' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.0, prev 0.0 | |
| 2019-11-07 15:00:01,090 ( 0.000s) INFO (root) Query 'SELECT count() FROM hits_100m_single' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.0, prev 0.0 | |
| 2019-11-07 15:00:01,090 ( 0.000s) INFO (root) Query 'SELECT count() FROM hits_10m_single WHERE AdvEngineID != 0' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.004, prev 0.004 | |
| 2019-11-07 15:00:01,090 ( 0.000s) INFO (root) Query 'SELECT count() FROM hits_100m_single WHERE AdvEngineID != 0' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.007, prev 0.006 | |
| 2019-11-07 15:00:01,090 ( 0.000s) INFO (root) Query 'SELECT sum(AdvEngineID), count(), avg(ResolutionWidth) FROM hits_10m_single' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.005, prev 0.004 | |
| 2019-11-07 15:00:01,090 ( 0.000s) INFO (root) Query 'SELECT sum(AdvEngineID), count(), avg(ResolutionWidth) FROM hits_100m_single' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.019, prev 0.014 | |
| 2019-11-07 15:00:01,091 ( 0.000s) INFO (root) Query 'SELECT sum(UserID) FROM hits_10m_single' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.005, prev 0.005 | |
| 2019-11-07 15:00:01,091 ( 0.000s) INFO (root) Query 'SELECT sum(UserID) FROM hits_100m_single' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.021, prev 0.017 | |
| 2019-11-07 15:00:01,091 ( 0.000s) INFO (root) Query 'SELECT uniq(UserID) FROM hits_10m_single' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.035, prev 0.039 | |
| 2019-11-07 15:00:01,091 ( 0.000s) INFO (root) Query 'SELECT uniq(UserID) FROM hits_100m_single' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.077, prev 0.066 | |
| 2019-11-07 15:00:01,091 ( 0.000s) INFO (root) Query 'SELECT uniq(SearchPhrase) FROM hits_10m_single' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.044, prev 0.038 | |
| 2019-11-07 15:00:01,091 ( 0.000s) INFO (root) Query 'SELECT uniq(SearchPhrase) FROM hits_100m_single' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.145, prev 0.116 | |
| 2019-11-07 15:00:01,091 ( 0.000s) INFO (root) Query 'SELECT min(EventDate), max(EventDate) FROM hits_10m_single' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.003, prev 0.003 | |
| 2019-11-07 15:00:01,091 ( 0.000s) INFO (root) Query 'SELECT min(EventDate), max(EventDate) FROM hits_100m_single' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.009, prev 0.006 | |
| 2019-11-07 15:00:01,091 ( 0.000s) INFO (root) Query 'SELECT AdvEngineID, count() FROM hits_10m_single WHERE AdvEngineID != 0 GROUP BY AdvEngineID ORDER BY count() DESC' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.005, prev 0.005 | |
| 2019-11-07 15:00:01,092 ( 0.000s) INFO (root) Query 'SELECT AdvEngineID, count() FROM hits_100m_single WHERE AdvEngineID != 0 GROUP BY AdvEngineID ORDER BY count() DESC' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.008, prev 0.006 | |
| 2019-11-07 15:00:01,092 ( 0.000s) INFO (root) Query 'SELECT RegionID, uniq(UserID) AS u FROM hits_10m_single GROUP BY RegionID ORDER BY u DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.06, prev 0.045 | |
| 2019-11-07 15:00:01,092 ( 0.000s) INFO (root) Query 'SELECT RegionID, uniq(UserID) AS u FROM hits_100m_single GROUP BY RegionID ORDER BY u DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.335, prev 0.231 | |
| 2019-11-07 15:00:01,092 ( 0.000s) INFO (root) Query 'SELECT RegionID, sum(AdvEngineID), count() AS c, avg(ResolutionWidth), uniq(UserID) FROM hits_10m_single GROUP BY RegionID ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.065, prev 0.051 | |
| 2019-11-07 15:00:01,092 ( 0.000s) INFO (root) Query 'SELECT RegionID, sum(AdvEngineID), count() AS c, avg(ResolutionWidth), uniq(UserID) FROM hits_100m_single GROUP BY RegionID ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.369, prev 0.257 | |
| 2019-11-07 15:00:01,092 ( 0.000s) INFO (root) Query 'SELECT MobilePhoneModel, uniq(UserID) AS u FROM hits_10m_single WHERE MobilePhoneModel != '' GROUP BY MobilePhoneModel ORDER BY u DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.03, prev 0.027 | |
| 2019-11-07 15:00:01,092 ( 0.000s) INFO (root) Query 'SELECT MobilePhoneModel, uniq(UserID) AS u FROM hits_100m_single WHERE MobilePhoneModel != '' GROUP BY MobilePhoneModel ORDER BY u DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.107, prev 0.084 | |
| 2019-11-07 15:00:01,092 ( 0.000s) INFO (root) Query 'SELECT MobilePhone, MobilePhoneModel, uniq(UserID) AS u FROM hits_10m_single WHERE MobilePhoneModel != '' GROUP BY MobilePhone, MobilePhoneModel ORDER BY u DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.028, prev 0.023 | |
| 2019-11-07 15:00:01,093 ( 0.000s) INFO (root) Query 'SELECT MobilePhone, MobilePhoneModel, uniq(UserID) AS u FROM hits_100m_single WHERE MobilePhoneModel != '' GROUP BY MobilePhone, MobilePhoneModel ORDER BY u DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.122, prev 0.089 | |
| 2019-11-07 15:00:01,093 ( 0.000s) INFO (root) Query 'SELECT SearchPhrase, count() AS c FROM hits_10m_single WHERE SearchPhrase != '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.058, prev 0.044 | |
| 2019-11-07 15:00:01,093 ( 0.000s) INFO (root) Query 'SELECT SearchPhrase, count() AS c FROM hits_100m_single WHERE SearchPhrase != '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.344, prev 0.258 | |
| 2019-11-07 15:00:01,093 ( 0.000s) INFO (root) Query 'SELECT SearchPhrase, uniq(UserID) AS u FROM hits_10m_single WHERE SearchPhrase != '' GROUP BY SearchPhrase ORDER BY u DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.069, prev 0.052 | |
| 2019-11-07 15:00:01,093 ( 0.000s) INFO (root) Query 'SELECT SearchPhrase, uniq(UserID) AS u FROM hits_100m_single WHERE SearchPhrase != '' GROUP BY SearchPhrase ORDER BY u DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.433, prev 0.325 | |
| 2019-11-07 15:00:01,093 ( 0.000s) INFO (root) Query 'SELECT SearchEngineID, SearchPhrase, count() AS c FROM hits_10m_single WHERE SearchPhrase != '' GROUP BY SearchEngineID, SearchPhrase ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.07, prev 0.052 | |
| 2019-11-07 15:00:01,093 ( 0.000s) INFO (root) Query 'SELECT SearchEngineID, SearchPhrase, count() AS c FROM hits_100m_single WHERE SearchPhrase != '' GROUP BY SearchEngineID, SearchPhrase ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.411, prev 0.337 | |
| 2019-11-07 15:00:01,093 ( 0.000s) INFO (root) Query 'SELECT UserID, count() FROM hits_10m_single GROUP BY UserID ORDER BY count() DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.049, prev 0.043 | |
| 2019-11-07 15:00:01,094 ( 0.000s) INFO (root) Query 'SELECT UserID, count() FROM hits_100m_single GROUP BY UserID ORDER BY count() DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.485, prev 0.412 | |
| 2019-11-07 15:00:01,094 ( 0.000s) INFO (root) Query 'SELECT UserID, SearchPhrase, count() FROM hits_10m_single GROUP BY UserID, SearchPhrase ORDER BY count() DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.12, prev 0.096 | |
| 2019-11-07 15:00:01,094 ( 0.000s) INFO (root) Query 'SELECT UserID, SearchPhrase, count() FROM hits_100m_single GROUP BY UserID, SearchPhrase ORDER BY count() DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 1.194, prev 1.01 | |
| 2019-11-07 15:00:01,094 ( 0.000s) INFO (root) Query 'SELECT UserID, SearchPhrase, count() FROM hits_10m_single GROUP BY UserID, SearchPhrase LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.074, prev 0.061 | |
| 2019-11-07 15:00:01,094 ( 0.000s) INFO (root) Query 'SELECT UserID, SearchPhrase, count() FROM hits_100m_single GROUP BY UserID, SearchPhrase LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.714, prev 0.583 | |
| 2019-11-07 15:00:01,094 ( 0.000s) INFO (root) Query 'SELECT UserID, toMinute(EventTime) AS m, SearchPhrase, count() FROM hits_10m_single GROUP BY UserID, m, SearchPhrase ORDER BY count() DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.214, prev 0.184 | |
| 2019-11-07 15:00:01,094 ( 0.000s) INFO (root) Query 'SELECT UserID, toMinute(EventTime) AS m, SearchPhrase, count() FROM hits_100m_single GROUP BY UserID, m, SearchPhrase ORDER BY count() DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 2.457, prev 1.742 | |
| 2019-11-07 15:00:01,094 ( 0.000s) INFO (root) Query 'SELECT UserID FROM hits_10m_single WHERE UserID = 12345678901234567890' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.005, prev 0.005 | |
| 2019-11-07 15:00:01,095 ( 0.000s) INFO (root) Query 'SELECT UserID FROM hits_100m_single WHERE UserID = 12345678901234567890' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.02, prev 0.015 | |
| 2019-11-07 15:00:01,095 ( 0.000s) INFO (root) Query 'SELECT count() FROM hits_10m_single WHERE URL LIKE '%metrika%'' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.045, prev 0.033 | |
| 2019-11-07 15:00:01,095 ( 0.000s) INFO (root) Query 'SELECT count() FROM hits_100m_single WHERE URL LIKE '%metrika%'' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.308, prev 0.254 | |
| 2019-11-07 15:00:01,095 ( 0.000s) INFO (root) Query 'SELECT SearchPhrase, any(URL), count() AS c FROM hits_10m_single WHERE URL LIKE '%metrika%' AND SearchPhrase != '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.067, prev 0.047 | |
| 2019-11-07 15:00:01,095 ( 0.000s) INFO (root) Query 'SELECT SearchPhrase, any(URL), count() AS c FROM hits_100m_single WHERE URL LIKE '%metrika%' AND SearchPhrase != '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.391, prev 0.296 | |
| 2019-11-07 15:00:01,095 ( 0.000s) INFO (root) Query 'SELECT SearchPhrase, any(URL), any(Title), count() AS c, uniq(UserID) FROM hits_10m_single WHERE Title LIKE '%Яндекс%' AND URL NOT LIKE '%.yandex.%' AND SearchPhrase != '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.151, prev 0.116 | |
| 2019-11-07 15:00:01,095 ( 0.000s) INFO (root) Query 'SELECT SearchPhrase, any(URL), any(Title), count() AS c, uniq(UserID) FROM hits_100m_single WHERE Title LIKE '%Яндекс%' AND URL NOT LIKE '%.yandex.%' AND SearchPhrase != '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.925, prev 0.768 | |
| 2019-11-07 15:00:01,095 ( 0.000s) INFO (root) Query 'SELECT * FROM hits_10m_single WHERE URL LIKE '%metrika%' ORDER BY EventTime LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.265, prev 0.178 | |
| 2019-11-07 15:00:01,096 ( 0.000s) INFO (root) Query 'SELECT * FROM hits_100m_single WHERE URL LIKE '%metrika%' ORDER BY EventTime LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.501, prev 0.432 | |
| 2019-11-07 15:00:01,096 ( 0.000s) INFO (root) Query 'SELECT SearchPhrase FROM hits_10m_single WHERE SearchPhrase != '' ORDER BY EventTime LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.032, prev 0.021 | |
| 2019-11-07 15:00:01,096 ( 0.000s) INFO (root) Query 'SELECT SearchPhrase FROM hits_100m_single WHERE SearchPhrase != '' ORDER BY EventTime LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.138, prev 0.106 | |
| 2019-11-07 15:00:01,096 ( 0.000s) INFO (root) Query 'SELECT SearchPhrase FROM hits_10m_single WHERE SearchPhrase != '' ORDER BY SearchPhrase LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.027, prev 0.019 | |
| 2019-11-07 15:00:01,096 ( 0.000s) INFO (root) Query 'SELECT SearchPhrase FROM hits_100m_single WHERE SearchPhrase != '' ORDER BY SearchPhrase LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.106, prev 0.08 | |
| 2019-11-07 15:00:01,096 ( 0.000s) INFO (root) Query 'SELECT SearchPhrase FROM hits_10m_single WHERE SearchPhrase != '' ORDER BY EventTime, SearchPhrase LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.032, prev 0.022 | |
| 2019-11-07 15:00:01,096 ( 0.000s) INFO (root) Query 'SELECT SearchPhrase FROM hits_100m_single WHERE SearchPhrase != '' ORDER BY EventTime, SearchPhrase LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.141, prev 0.108 | |
| 2019-11-07 15:00:01,096 ( 0.000s) INFO (root) Query 'SELECT CounterID, avg(length(URL)) AS l, count() AS c FROM hits_10m_single WHERE URL != '' GROUP BY CounterID HAVING c > 100000 ORDER BY l DESC LIMIT 25' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.052, prev 0.04 | |
| 2019-11-07 15:00:01,096 ( 0.000s) INFO (root) Query 'SELECT CounterID, avg(length(URL)) AS l, count() AS c FROM hits_100m_single WHERE URL != '' GROUP BY CounterID HAVING c > 100000 ORDER BY l DESC LIMIT 25' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.386, prev 0.325 | |
| 2019-11-07 15:00:01,097 ( 0.000s) INFO (root) Query 'SELECT domainWithoutWWW(Referer) AS key, avg(length(Referer)) AS l, count() AS c, any(Referer) FROM hits_10m_single WHERE Referer != '' GROUP BY key HAVING c > 100000 ORDER BY l DESC LIMIT 25' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.1, prev 0.078 | |
| 2019-11-07 15:00:01,097 ( 0.000s) INFO (root) Query 'SELECT domainWithoutWWW(Referer) AS key, avg(length(Referer)) AS l, count() AS c, any(Referer) FROM hits_100m_single WHERE Referer != '' GROUP BY key HAVING c > 100000 ORDER BY l DESC LIMIT 25' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.599, prev 0.451 | |
| 2019-11-07 15:00:01,097 ( 0.000s) INFO (root) Query 'SELECT sum(ResolutionWidth), sum(ResolutionWidth + 1), sum(ResolutionWidth + 2), sum(ResolutionWidth + 3), sum(ResolutionWidth + 4), sum(ResolutionWidth + 5), sum(ResolutionWidth + 6), sum(ResolutionWidth + 7), sum(ResolutionWidth + 8), sum(ResolutionWidth + 9), sum(ResolutionWidth + 10), sum(ResolutionWidth + 11), sum(ResolutionWidth + 12), sum(ResolutionWidth + 13), sum(ResolutionWidth + 14), sum(ResolutionWidth + 15), sum(ResolutionWidth + 16), sum(ResolutionWidth + 17), sum(ResolutionWidth + 18), sum(ResolutionWidth + 19), sum(ResolutionWidth + 20), sum(ResolutionWidth + 21), sum(ResolutionWidth + 22), sum(ResolutionWidth + 23), sum(ResolutionWidth + 24), sum(ResolutionWidth + 25), sum(ResolutionWidth + 26), sum(ResolutionWidth + 27), sum(ResolutionWidth + 28), sum(ResolutionWidth + 29), sum(ResolutionWidth + 30), sum(ResolutionWidth + 31), sum(ResolutionWidth + 32), sum(ResolutionWidth + 33), sum(ResolutionWidth + 34), sum(ResolutionWidth + 35), sum(ResolutionWidth + 36), sum(ResolutionWidth + 37), sum(ResolutionWidth + 38), sum(ResolutionWidth + 39), sum(ResolutionWidth + 40), sum(ResolutionWidth + 41), sum(ResolutionWidth + 42), sum(ResolutionWidth + 43), sum(ResolutionWidth + 44), sum(ResolutionWidth + 45), sum(ResolutionWidth + 46), sum(ResolutionWidth + 47), sum(ResolutionWidth + 48), sum(ResolutionWidth + 49), sum(ResolutionWidth + 50), sum(ResolutionWidth + 51), sum(ResolutionWidth + 52), sum(ResolutionWidth + 53), sum(ResolutionWidth + 54), sum(ResolutionWidth + 55), sum(ResolutionWidth + 56), sum(ResolutionWidth + 57), sum(ResolutionWidth + 58), sum(ResolutionWidth + 59), sum(ResolutionWidth + 60), sum(ResolutionWidth + 61), sum(ResolutionWidth + 62), sum(ResolutionWidth + 63), sum(ResolutionWidth + 64), sum(ResolutionWidth + 65), sum(ResolutionWidth + 66), sum(ResolutionWidth + 67), sum(ResolutionWidth + 68), sum(ResolutionWidth + 69), sum(ResolutionWidth + 70), sum(ResolutionWidth + 71), sum(ResolutionWidth + 72), sum(ResolutionWidth + 73), sum(ResolutionWidth + 74), sum(ResolutionWidth + 75), sum(ResolutionWidth + 76), sum(ResolutionWidth + 77), sum(ResolutionWidth + 78), sum(ResolutionWidth + 79), sum(ResolutionWidth + 80), sum(ResolutionWidth + 81), sum(ResolutionWidth + 82), sum(ResolutionWidth + 83), sum(ResolutionWidth + 84), sum(ResolutionWidth + 85), sum(ResolutionWidth + 86), sum(ResolutionWidth + 87), sum(ResolutionWidth + 88), sum(ResolutionWidth + 89) FROM hits_10m_single' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.158, prev 0.138 | |
| 2019-11-07 15:00:01,097 ( 0.000s) INFO (root) Query 'SELECT sum(ResolutionWidth), sum(ResolutionWidth + 1), sum(ResolutionWidth + 2), sum(ResolutionWidth + 3), sum(ResolutionWidth + 4), sum(ResolutionWidth + 5), sum(ResolutionWidth + 6), sum(ResolutionWidth + 7), sum(ResolutionWidth + 8), sum(ResolutionWidth + 9), sum(ResolutionWidth + 10), sum(ResolutionWidth + 11), sum(ResolutionWidth + 12), sum(ResolutionWidth + 13), sum(ResolutionWidth + 14), sum(ResolutionWidth + 15), sum(ResolutionWidth + 16), sum(ResolutionWidth + 17), sum(ResolutionWidth + 18), sum(ResolutionWidth + 19), sum(ResolutionWidth + 20), sum(ResolutionWidth + 21), sum(ResolutionWidth + 22), sum(ResolutionWidth + 23), sum(ResolutionWidth + 24), sum(ResolutionWidth + 25), sum(ResolutionWidth + 26), sum(ResolutionWidth + 27), sum(ResolutionWidth + 28), sum(ResolutionWidth + 29), sum(ResolutionWidth + 30), sum(ResolutionWidth + 31), sum(ResolutionWidth + 32), sum(ResolutionWidth + 33), sum(ResolutionWidth + 34), sum(ResolutionWidth + 35), sum(ResolutionWidth + 36), sum(ResolutionWidth + 37), sum(ResolutionWidth + 38), sum(ResolutionWidth + 39), sum(ResolutionWidth + 40), sum(ResolutionWidth + 41), sum(ResolutionWidth + 42), sum(ResolutionWidth + 43), sum(ResolutionWidth + 44), sum(ResolutionWidth + 45), sum(ResolutionWidth + 46), sum(ResolutionWidth + 47), sum(ResolutionWidth + 48), sum(ResolutionWidth + 49), sum(ResolutionWidth + 50), sum(ResolutionWidth + 51), sum(ResolutionWidth + 52), sum(ResolutionWidth + 53), sum(ResolutionWidth + 54), sum(ResolutionWidth + 55), sum(ResolutionWidth + 56), sum(ResolutionWidth + 57), sum(ResolutionWidth + 58), sum(ResolutionWidth + 59), sum(ResolutionWidth + 60), sum(ResolutionWidth + 61), sum(ResolutionWidth + 62), sum(ResolutionWidth + 63), sum(ResolutionWidth + 64), sum(ResolutionWidth + 65), sum(ResolutionWidth + 66), sum(ResolutionWidth + 67), sum(ResolutionWidth + 68), sum(ResolutionWidth + 69), sum(ResolutionWidth + 70), sum(ResolutionWidth + 71), sum(ResolutionWidth + 72), sum(ResolutionWidth + 73), sum(ResolutionWidth + 74), sum(ResolutionWidth + 75), sum(ResolutionWidth + 76), sum(ResolutionWidth + 77), sum(ResolutionWidth + 78), sum(ResolutionWidth + 79), sum(ResolutionWidth + 80), sum(ResolutionWidth + 81), sum(ResolutionWidth + 82), sum(ResolutionWidth + 83), sum(ResolutionWidth + 84), sum(ResolutionWidth + 85), sum(ResolutionWidth + 86), sum(ResolutionWidth + 87), sum(ResolutionWidth + 88), sum(ResolutionWidth + 89) FROM hits_100m_single' - /usr/share/clickhouse-test/performance/website.xml failed, got value 1.127, prev 0.919 | |
| 2019-11-07 15:00:01,097 ( 0.000s) INFO (root) Query 'SELECT SearchEngineID, ClientIP, count() AS c, sum(Refresh), avg(ResolutionWidth) FROM hits_10m_single WHERE SearchPhrase != '' GROUP BY SearchEngineID, ClientIP ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.062, prev 0.05 | |
| 2019-11-07 15:00:01,097 ( 0.000s) INFO (root) Query 'SELECT SearchEngineID, ClientIP, count() AS c, sum(Refresh), avg(ResolutionWidth) FROM hits_100m_single WHERE SearchPhrase != '' GROUP BY SearchEngineID, ClientIP ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.369, prev 0.284 | |
| 2019-11-07 15:00:01,097 ( 0.000s) INFO (root) Query 'SELECT WatchID, ClientIP, count() AS c, sum(Refresh), avg(ResolutionWidth) FROM hits_10m_single WHERE SearchPhrase != '' GROUP BY WatchID, ClientIP ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.077, prev 0.058 | |
| 2019-11-07 15:00:01,098 ( 0.000s) INFO (root) Query 'SELECT WatchID, ClientIP, count() AS c, sum(Refresh), avg(ResolutionWidth) FROM hits_100m_single WHERE SearchPhrase != '' GROUP BY WatchID, ClientIP ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.529, prev 0.392 | |
| 2019-11-07 15:00:01,098 ( 0.000s) INFO (root) Query 'SELECT WatchID, ClientIP, count() AS c, sum(Refresh), avg(ResolutionWidth) FROM hits_10m_single GROUP BY WatchID, ClientIP ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.306, prev 0.237 | |
| 2019-11-07 15:00:01,098 ( 0.000s) INFO (root) Query 'SELECT WatchID, ClientIP, count() AS c, sum(Refresh), avg(ResolutionWidth) FROM hits_100m_single GROUP BY WatchID, ClientIP ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml ok, got value 3.886, prev 1.84467440737e+16 | |
| 2019-11-07 15:00:01,098 ( 0.000s) INFO (root) Query 'SELECT URL, count() AS c FROM hits_10m_single GROUP BY URL ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.208, prev 0.163 | |
| 2019-11-07 15:00:01,098 ( 0.000s) INFO (root) Query 'SELECT URL, count() AS c FROM hits_100m_single GROUP BY URL ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 1.925, prev 1.389 | |
| 2019-11-07 15:00:01,098 ( 0.000s) INFO (root) Query 'SELECT 1, URL, count() AS c FROM hits_10m_single GROUP BY 1, URL ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.209, prev 0.161 | |
| 2019-11-07 15:00:01,098 ( 0.000s) INFO (root) Query 'SELECT 1, URL, count() AS c FROM hits_100m_single GROUP BY 1, URL ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 1.895, prev 1.385 | |
| 2019-11-07 15:00:01,098 ( 0.000s) INFO (root) Query 'SELECT ClientIP AS x, x - 1, x - 2, x - 3, count() AS c FROM hits_10m_single GROUP BY x, x - 1, x - 2, x - 3 ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.071, prev 0.063 | |
| 2019-11-07 15:00:01,099 ( 0.000s) INFO (root) Query 'SELECT ClientIP AS x, x - 1, x - 2, x - 3, count() AS c FROM hits_100m_single GROUP BY x, x - 1, x - 2, x - 3 ORDER BY c DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.776, prev 0.439 | |
| 2019-11-07 15:00:01,099 ( 0.000s) INFO (root) Query 'SELECT URL, count() AS PageViews FROM hits_10m_single WHERE CounterID = 34 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT DontCountHits AND NOT Refresh AND notEmpty(URL) GROUP BY URL ORDER BY PageViews DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.103, prev 0.088 | |
| 2019-11-07 15:00:01,099 ( 0.000s) INFO (root) Query 'SELECT URL, count() AS PageViews FROM hits_100m_single WHERE CounterID = 34 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT DontCountHits AND NOT Refresh AND notEmpty(URL) GROUP BY URL ORDER BY PageViews DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.085, prev 0.073 | |
| 2019-11-07 15:00:01,099 ( 0.000s) INFO (root) Query 'SELECT Title, count() AS PageViews FROM hits_10m_single WHERE CounterID = 34 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT DontCountHits AND NOT Refresh AND notEmpty(Title) GROUP BY Title ORDER BY PageViews DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.052, prev 0.04 | |
| 2019-11-07 15:00:01,099 ( 0.000s) INFO (root) Query 'SELECT Title, count() AS PageViews FROM hits_100m_single WHERE CounterID = 34 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT DontCountHits AND NOT Refresh AND notEmpty(Title) GROUP BY Title ORDER BY PageViews DESC LIMIT 10' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.037, prev 0.028 | |
| 2019-11-07 15:00:01,099 ( 0.000s) INFO (root) Query 'SELECT URL, count() AS PageViews FROM hits_10m_single WHERE CounterID = 34 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT Refresh AND IsLink AND NOT IsDownload GROUP BY URL ORDER BY PageViews DESC LIMIT 1000' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.033, prev 0.027 | |
| 2019-11-07 15:00:01,099 ( 0.000s) INFO (root) Query 'SELECT URL, count() AS PageViews FROM hits_100m_single WHERE CounterID = 34 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT Refresh AND IsLink AND NOT IsDownload GROUP BY URL ORDER BY PageViews DESC LIMIT 1000' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.026, prev 0.021 | |
| 2019-11-07 15:00:01,099 ( 0.000s) INFO (root) Query 'SELECT TraficSourceID, SearchEngineID, AdvEngineID, ((SearchEngineID = 0 AND AdvEngineID = 0) ? Referer : '') AS Src, URL AS Dst, count() AS PageViews FROM hits_10m_single WHERE CounterID = 34 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT Refresh GROUP BY TraficSourceID, SearchEngineID, AdvEngineID, Src, Dst ORDER BY PageViews DESC LIMIT 1000' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.203, prev 0.17 | |
| 2019-11-07 15:00:01,100 ( 0.000s) INFO (root) Query 'SELECT TraficSourceID, SearchEngineID, AdvEngineID, ((SearchEngineID = 0 AND AdvEngineID = 0) ? Referer : '') AS Src, URL AS Dst, count() AS PageViews FROM hits_100m_single WHERE CounterID = 34 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT Refresh GROUP BY TraficSourceID, SearchEngineID, AdvEngineID, Src, Dst ORDER BY PageViews DESC LIMIT 1000' - /usr/share/clickhouse-test/performance/website.xml failed, got value 0.171, prev 0.125 | |
| 2019-11-07 15:00:01,100 ( 0.000s) INFO (root) Query 'SELECT URLHash, EventDate, count() AS PageViews FROM hits_10m_single WHERE CounterID = 34 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT Refresh AND TraficSourceID IN (-1, 6) AND RefererHash = halfMD5('http://example.ru/') GROUP BY URLHash, EventDate ORDER BY PageViews DESC LIMIT 100' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.014, prev 0.012 | |
| 2019-11-07 15:00:01,100 ( 0.000s) INFO (root) Query 'SELECT URLHash, EventDate, count() AS PageViews FROM hits_100m_single WHERE CounterID = 34 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT Refresh AND TraficSourceID IN (-1, 6) AND RefererHash = halfMD5('http://example.ru/') GROUP BY URLHash, EventDate ORDER BY PageViews DESC LIMIT 100' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.011, prev 0.01 | |
| 2019-11-07 15:00:01,100 ( 0.000s) INFO (root) Query 'SELECT WindowClientWidth, WindowClientHeight, count() AS PageViews FROM hits_10m_single WHERE CounterID = 34 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT Refresh AND NOT DontCountHits AND URLHash = halfMD5('http://example.ru/') GROUP BY WindowClientWidth, WindowClientHeight ORDER BY PageViews DESC LIMIT 10000' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.011, prev 0.009 | |
| 2019-11-07 15:00:01,100 ( 0.000s) INFO (root) Query 'SELECT WindowClientWidth, WindowClientHeight, count() AS PageViews FROM hits_100m_single WHERE CounterID = 34 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT Refresh AND NOT DontCountHits AND URLHash = halfMD5('http://example.ru/') GROUP BY WindowClientWidth, WindowClientHeight ORDER BY PageViews DESC LIMIT 10000' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.009, prev 0.008 | |
| 2019-11-07 15:00:01,100 ( 0.000s) INFO (root) Query 'SELECT toStartOfMinute(EventTime) AS Minute, count() AS PageViews FROM hits_10m_single WHERE CounterID = 34 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-02' AND NOT Refresh AND NOT DontCountHits GROUP BY Minute ORDER BY Minute' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.01, prev 0.008 | |
| 2019-11-07 15:00:01,100 ( 0.000s) INFO (root) Query 'SELECT toStartOfMinute(EventTime) AS Minute, count() AS PageViews FROM hits_100m_single WHERE CounterID = 34 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-02' AND NOT Refresh AND NOT DontCountHits GROUP BY Minute ORDER BY Minute' - /usr/share/clickhouse-test/performance/website.xml ok, got value 0.002, prev 0.001 | |
| 2019-11-07 15:00:01,101 ( 0.000s) INFO (root) Found failed tests 68 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment