EXPLAIN ANALYZE query
Can someone execute, on prod:
EXPLAIN ANALYZE SELECT COUNT("ci_builds"."created_at") AS count_created_at, to_char(ci_builds.created_at, '01 Month YYYY') AS to_char_ci_builds_created_at_01_month_yyyy
FROM "ci_builds"
WHERE "ci_builds"."type" IN ('Ci::Build')
AND "ci_builds"."project_id" = 13083
AND ('2017-05-31' > ci_builds.created_at AND ci_builds.created_at > '2016-05-01')
GROUP BY to_char(ci_builds.created_at, '01 Month YYYY')
Edited by Zeger-Jan van de Weg