Поиск медленных страниц по acces.log через clickhouse

slow_page.sql

SELECT 
    ip, 
    avg(resp_time) AS avg_time, 
    domain, 
    path
FROM access_log 
WHERE event_date = '2016-11-01'
GROUP BY 
    path, 
    ip, 
    domain
ORDER BY avg_time DESC
LIMIT 10