malisper

-- Sierpinski's Triangle.
WITH points AS (
  SELECT ROW, col FROM generate_series(0, 63) a(ROW)
  CROSS JOIN generate_series(0, 63) b(col)
  ORDER BY ROW DESC, col ASC
), marked_points AS (
   SELECT ROW, col, (CASE WHEN ROW & col != 0
                  THEN ' '
                  ELSE '*'
                  END) AS marker

malisper

0:00:00-0:01:00 Thinking
0:01:00-0:03:15 Wrote query to get 100 queries after a given point in time that took a long time.
0:03:15-0:03:30 I try running the query and get an error. There's an issue with how I'm using TIMESTAMP AT TIME ZONE in Postgres.
0:03:30-0:04:15 I look up the docs for TIMESTAMP. I discover the issue is I wrote TIMESTAMP AT TIME ZONE instead of TIMESTAMP WITH TIME ZONE. I then run the query and it works.
0:04:15-0:05:45 I scroll through the results and look at them.
0:05:45-0:06:45 I modify the query I have to display how much time is spent in different parts of our stack. I'm looking at how much time was spent in our master database compared to our worker databases.
0:06:45-0:07:00 I get a few errors from ambigious fields in the SQL query. This is because I'm joining two tables that both have columns named start_time and both have columns named data. I modify the SQL query to refer explicitly to one of the tables.
0:07:00-07:30:00 The query I wrote is taking a long time. I kill it and t

malisper

-- Sum list of numbers
[["lambda", ["f"],
    ["f", "f",
       ["cons", 1, ["cons", 2, ["cons", 3, ["empty"]]]]]],
 ["lambda", ["self", "xs"],
    ["if", ["=", "xs", ["empty"]],
           0,
           ["+", ["head", "xs"],
                 ["self", "self", ["tail", "xs"]]]]]]

malisper

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",

malisper

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",

malisper

(defun multiple (a b)
  "Is A a multiple of B?"
  (= (mod a b) 0))

(defun next-fraction (n fractions)
  "Returns the next value of F in the Fractran program."
  (find-if (lambda (f)
             (integerp (* n f)))
           fractions))

malisper

SELECT
  SUM(funnel_events(
       ARRAY_AGG(funnel_step ORDER BY time ASC, funnel_step DESC), 
       2)) AS funnel_results
FROM ((SELECT *
        FROM (SELECT user_id,
                     time,
                     0 AS funnel_step
              FROM "events"
              WHERE type = 'click'

malisper

def base_query():
    return [1]

def recursive_query(ints):
    return [n+1 for n in ints if n+1 <= 100]

def recursive_cte()
  results = []
  working_table = base_query()

malisper

Aggregate
 ->  GroupAggregate
       Group Key: events.user_id
         ->  Append
               ->  Index Scan using events_pi_40542511 on events
                     Index Cond: ((time >= 1476428400000) AND (time <= 1477033200000))
               ->  Index Scan using events_pi_40542828 on events
                     Index Cond: ((time >= 1476428400000) AND (time <= 1477033200000))

malisper

(5/2 11/5 3/2 3/17 13/57 13/11 29/247 323/29 23/13 37/23 43/37 31/23 31/53
 2773/31 61/3149 61/43 73/4087 3551/73 71/61 83/71 97/83 79/71 79/103 1919/79
 7169/101 109/6313 109/97 127/6431 6077/127 113/109 137/113 149/137 131/113
 131/157 163/131 173/163 151/131 151/181 179/28841 179/173 197/34189 34571/197
 193/179 211/193 227/211 199/193 199/233 54731/199 241/4351 241/227 257/4579
 4427/257 251/241 269/251 277/269 263/251 263/283 53671/263 5567/281 307/70027
 307/277 313/73373 67637/313 311/307 331/311 347/331 317/311 317/353
 349/5206666620054784675760045562843307267 349/347
 367/5732260726811103633565476029754934499
 5797959990155643503291154838118887903/367 359/349 379/68569 73153/379 373/359