Created
March 1, 2018 15:45
-
-
Save padak/aaabf4c5749bfce6955747515738e76f to your computer and use it in GitHub Desktop.
This file contains 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
select | |
DATE, | |
SUM(CNT) as daily_sum | |
FROM ( | |
/* spusť jen tohle pro výpis projektů v konkrétní den sestupně podle počtu čekajících jobů */ | |
SELECT | |
job_created::DATE as date, | |
project_id, | |
-- HOUR(job_created::timestamp) as hr, | |
COUNT(run_id) AS cnt | |
FROM "kbc_jobs" | |
where project_region = 'us-east-1' | |
AND job_waittime_sec > 1 /* tady ladím jak dlouho musí job před spuštěním čekat, aby se počítal */ | |
AND HOUR(job_created::timestamp) IN (23,0,1) /* tady ladím v jaký hodině se založil (UTC) */ | |
AND job_created::date BETWEEN '2017-12-01' AND '2018-02-28' | |
AND job_created::date = '2017-12-18' | |
group by 1,2 | |
order by CNT DESC | |
/* spusť jen tohle pro výpis projektů v konkrétní den sestupně podle počtu čekajících jobů */ | |
) | |
group by 1 | |
having daily_sum > 100 | |
order by 1; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment