Skip to content

Instantly share code, notes, and snippets.

@runk
Created November 20, 2012 11:52
Show Gist options
  • Save runk/4117490 to your computer and use it in GitHub Desktop.
Save runk/4117490 to your computer and use it in GitHub Desktop.
[2012-11-20T11:37:04.506Z] DEBUG: cockpit/1606 on corona: cachedQuery: CREATE GLOBAL TEMPORARY TABLE ftmp_1353411424501(step VARCHAR(10), s INT, o INT, created_at TIMESTAMP NOT NULL) ON COMMIT DELETE ROWS
[2012-11-20T11:37:10.793Z] DEBUG: cockpit/1606 on corona: cachedQuery: INSERT INTO ftmp_1353411424501 SELECT 'Start', s, 0, created_at FROM evt s WHERE key IN (49) AND s.st1 = 'tutorial2' AND s.st2 = 'create_house' AND s.st3 IS NULL AND s.n = 'step_0'
[2012-11-20T11:37:11.086Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM ftmp_1353411424501
[2012-11-20T11:37:11.124Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 2390 ] ]
[2012-11-20T11:37:11.402Z] DEBUG: cockpit/1610 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'create_house' AND e.st3 IS NULL AND e.n = 'step_1' AND e.created_at>f.created_at) k
[2012-11-20T11:37:11.580Z] DEBUG: cockpit/1610 on corona: FUNNEL RESULT [ [ 0 ] ]
[2012-11-20T11:37:11.855Z] DEBUG: cockpit/1610 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'create_house' AND e.st3 IS NULL AND e.n = 'step_2' AND e.created_at>f.created_at) k
[2012-11-20T11:37:12.079Z] DEBUG: cockpit/1610 on corona: FUNNEL RESULT [ [ 0 ] ]
[2012-11-20T11:37:12.332Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'create_house' AND e.st3 IS NULL AND e.n = 'step_3' AND e.created_at>f.created_at) k
[2012-11-20T11:37:12.580Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 2222 ] ]
[2012-11-20T11:37:12.857Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'create_house' AND e.st3 IS NULL AND e.n = 'step_4' AND e.created_at>f.created_at) k
[2012-11-20T11:37:13.083Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 2180 ] ]
[2012-11-20T11:37:13.374Z] DEBUG: cockpit/1616 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'create_house' AND e.st3 IS NULL AND e.n = 'step_5' AND e.created_at>f.created_at) k
[2012-11-20T11:37:15.222Z] DEBUG: cockpit/1616 on corona: FUNNEL RESULT [ [ 0 ] ]
[2012-11-20T11:37:15.515Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'create_house' AND e.st3 IS NULL AND e.n = 'step_6' AND e.created_at>f.created_at) k
[2012-11-20T11:37:15.806Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 2129 ] ]
[2012-11-20T11:37:16.119Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'pick_house' AND e.st3 IS NULL AND e.n = 'step_0' AND e.created_at>f.created_at) k
[2012-11-20T11:37:16.535Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 2121 ] ]
[2012-11-20T11:37:16.815Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'pick_house' AND e.st3 IS NULL AND e.n = 'step_1' AND e.created_at>f.created_at) k
[2012-11-20T11:37:17.113Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 2097 ] ]
[2012-11-20T11:37:17.413Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'pick_house' AND e.st3 IS NULL AND e.n = 'step_2' AND e.created_at>f.created_at) k
[2012-11-20T11:37:17.560Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 2086 ] ]
[2012-11-20T11:37:17.815Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'create_leisure' AND e.st3 IS NULL AND e.n = 'step_0' AND e.created_at>f.created_at) k
[2012-11-20T11:37:19.079Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 2084 ] ]
[2012-11-20T11:37:19.334Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'create_leisure' AND e.st3 IS NULL AND e.n = 'step_1' AND e.created_at>f.created_at) k
[2012-11-20T11:37:19.547Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 2076 ] ]
[2012-11-20T11:37:19.816Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'create_leisure' AND e.st3 IS NULL AND e.n = 'step_2' AND e.created_at>f.created_at) k
[2012-11-20T11:37:28.713Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 2065 ] ]
[2012-11-20T11:37:29.399Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'create_leisure' AND e.st3 IS NULL AND e.n = 'step_3' AND e.created_at>f.created_at) k
[2012-11-20T11:37:29.562Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 2044 ] ]
[2012-11-20T11:37:29.864Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'create_leisure' AND e.st3 IS NULL AND e.n = 'step_4' AND e.created_at>f.created_at) k
[2012-11-20T11:37:30.077Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 2042 ] ]
[2012-11-20T11:37:30.279Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'create_leisure' AND e.st3 IS NULL AND e.n = 'step_5' AND e.created_at>f.created_at) k
[2012-11-20T11:37:30.697Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 2036 ] ]
[2012-11-20T11:37:31.130Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'create_leisure' AND e.st3 IS NULL AND e.n = 'step_6' AND e.created_at>f.created_at) k
[2012-11-20T11:37:31.354Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 2030 ] ]
[2012-11-20T11:37:31.676Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'create_leisure' AND e.st3 IS NULL AND e.n = 'step_7' AND e.created_at>f.created_at) k
[2012-11-20T11:37:32.213Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 2035 ] ]
[2012-11-20T11:37:32.472Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'pick_leisure' AND e.st3 IS NULL AND e.n = 'step_0' AND e.created_at>f.created_at) k
[2012-11-20T11:37:38.692Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 1924 ] ]
[2012-11-20T11:37:39.122Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'pick_leisure' AND e.st3 IS NULL AND e.n = 'step_1' AND e.created_at>f.created_at) k
[2012-11-20T11:37:39.934Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 1916 ] ]
[2012-11-20T11:37:40.705Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'pick_leisure' AND e.st3 IS NULL AND e.n = 'step_2' AND e.created_at>f.created_at) k
[2012-11-20T11:37:44.185Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 1914 ] ]
[2012-11-20T11:37:44.740Z] DEBUG: cockpit/1606 on corona: cachedQuery: SELECT COUNT(DISTINCT s) FROM (SELECT e.s, e.created_at FROM evt e RIGHT JOIN ftmp_1353411424501 f ON f.s = e.s AND f.step = 'Start' WHERE key IN (49) AND e.st1 = 'tutorial2' AND e.st2 = 'pick_leisure' AND e.st3 IS NULL AND e.n = 'step_3' AND e.created_at>f.created_at) k
[2012-11-20T11:37:45.145Z] DEBUG: cockpit/1606 on corona: FUNNEL RESULT [ [ 1908 ] ]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment