Query

query.sql

SELECT "time_bucket",
       COUNT(*) AS value ,
       "group_field_0"
FROM
  (SELECT DISTINCT ON ("time_bucket", "shardPushdown"."user_id", "group_field_0")
    date_trunc('day', to_timestamp(("shardPushdown"."time" / 1000)) AT TIME ZONE 'America/Los_Angeles') AS "time_bucket",
    "group_field_0"
   FROM
     (SELECT "eventQuery"."user_id",
             "eventQuery"."time",
             '0k5ab3rpadwsf' AS query_identifier,
             group_field_0
      FROM
        (SELECT "multi_group_wrapper_1".*,
                group_field_0,
         FROM
           (SELECT "events"."time",
                   "events"."user_id",
                   "events"."data"
            FROM "events"
            WHERE ("events"."time" >= 1511164800000
                   AND "events"."time" <= 1511769600000
                   AND "events"."user_id" >= '(236035469, 0)'::APP_USER_ID
                   AND "events"."user_id" <= '(236035469, 9007199254740991)'::APP_USER_ID
                   AND ("events"."data" ->> 'object') = 'pageview')
                   AND (("events"."data" ->> 'domain') = 'blog.heapanalytics.com'
                         OR ("events"."data" ->> '_domain') = 'heap.engineering')
                   AND ("events"."data" ->> 'library') = 'web') AS "multi_group_wrapper_1"
         LEFT JOIN
           (SELECT "users"."id" AS "user_id",
                   normalize_referrer("users"."initial_referrer") AS "group_field_0"
            FROM "users") "left_group_by_1" ON ((("left_group_by_1".user_id).app_id = ("multi_group_wrapper_1".user_id).app_id
                                                 AND ("left_group_by_1".user_id).user_id = ("multi_group_wrapper_1".user_id).user_id))) "eventQuery") "shardPushdown") "shardPushdown"
GROUP BY "time_bucket",
         "group_field_0"