danwolch

[86af7258-fb4a-4c90-8470-07a0826f72a7] 2022-07-28T12:11:20-04:00 INFO metabase.query-processor.card Question's average execution duration is 10.4 s; using 'magic' TTL of 34.7 mins 💾
[86af7258-fb4a-4c90-8470-07a0826f72a7] 2022-07-28T12:11:20-04:00 INFO metabase.query-processor.card Question's average execution duration is 3.7 s; using 'magic' TTL of 12.2 mins 💾
[86af7258-fb4a-4c90-8470-07a0826f72a7] 2022-07-28T12:11:20-04:00 DEBUG metabase.server.middleware.log POST /api/dashboard/319/dashcard/5362/card/5701/query 202 [ASYNC: completed] 6.2 s (17 DB calls) App DB connections: 9/15 Jetty threads: 27/50 (21 idle, 0 queued) (234 total active threads) Queries in flight: 41 (0 queued)
[86af7258-fb4a-4c90-8470-07a0826f72a7] 2022-07-28T12:11:20-04:00 DEBUG metabase.server.middleware.log POST /api/dashboard/319/dashcard/5331/card/5639/query 202 [ASYNC: completed] 6.2 s (17 DB calls) App DB connections: 7/15 Jetty threads: 27/50 (21 idle, 0 queued) (234 total active threads) Queries in flight: 40 (0 queued)
[86af7258-f

danwolch

Original Message
Message ID	<1581014337732.d2b3f284ddf8b@Nodemailer>
Created at:	Thu, Feb 6, 2020 at 1:38 PM (Delivered after 37 seconds)
From:	Brian Balfour <hello@reforge.com> Using Nodemailer (0.3.42-7; +http://www.nodemailer.com/)
To:	Dan Wolchonok <dan+2@wolchonok.com>
Subject:	Good Experiment, Bad Experiment
SPF:	PASS with IP 209.85.220.41 Learn more
DKIM:	'FAIL' with domain reforge.com Learn more
DMARC:	'FAIL' Learn more

danwolch

WITH days AS (
    SELECT d
    FROM   generate_series( timestamp '2019-02-01'
                            , timestamp '2019-04-15'
                            , interval  '1 day') d
), amounts AS (
    SELECT d.d
        , SUM(coalesce(amount::int,0) / 100) as Revenue
    FROM days d
        LEFT JOIN stripe.charges c

danwolch

#! /usr/bin/env python
#
# Mixpanel, Inc. -- http://mixpanel.com/
#
# Python API client library to consume mixpanel.com analytics data.

import hashlib
import urllib
import pickle
import time