Skip to content

Instantly share code, notes, and snippets.

@michaelcontento

michaelcontento/aussetzer_01_bis_02

Created July 3, 2012 09:41
Show Gist options
  • Save michaelcontento/3038768 to your computer and use it in GitHub Desktop.
Save michaelcontento/3038768 to your computer and use it in GitHub Desktop.
Download ZIP
CC worker problems
Raw
aussetzer_01_bis_02
Aussetzer zwischen 01:00 Uhr und 02:00 Uhr
+---------------+----------+---------------------+---------------------+
| date(created) | count(*) | min(created) | max(created) |
+---------------+----------+---------------------+---------------------+
| 2012-06-26 | 102 | 2012-06-26 01:48:02 | 2012-06-26 01:54:36 |
| 2012-06-27 | 46 | 2012-06-27 01:50:09 | 2012-06-27 01:54:35 |
| 2012-06-28 | 109 | 2012-06-28 01:49:03 | 2012-06-28 01:56:33 |
| 2012-06-29 | 143 | 2012-06-29 01:48:18 | 2012-06-29 01:56:51 |
| 2012-06-30 | 29 | 2012-06-30 01:48:54 | 2012-06-30 01:51:04 |
| 2012-07-01 | 16 | 2012-07-01 01:49:59 | 2012-07-01 01:52:11 |
| 2012-07-02 | 20 | 2012-07-02 01:50:10 | 2012-07-02 01:50:18 |
| 2012-07-03 | 52 | 2012-07-03 01:50:03 | 2012-07-03 01:53:45 |
+---------------+----------+---------------------+---------------------+
Raw
aussetzer_ganzer_tag
Aussetzer über den ganzen Tag
+---------------+---------------+----------+---------------------+---------------------+
| date(created) | hour(created) | count(*) | min(created) | max(created) |
+---------------+---------------+----------+---------------------+---------------------+
| 2012-06-26 | 0 | 1 | 2012-06-26 00:10:42 | 2012-06-26 00:10:42 |
| 2012-06-26 | 1 | 102 | 2012-06-26 01:48:02 | 2012-06-26 01:54:36 |
| 2012-06-26 | 3 | 1 | 2012-06-26 03:10:45 | 2012-06-26 03:10:45 |
| 2012-06-26 | 6 | 179 | 2012-06-26 06:10:42 | 2012-06-26 06:40:28 |
| 2012-06-26 | 9 | 61 | 2012-06-26 09:08:58 | 2012-06-26 09:13:41 |
| 2012-06-26 | 12 | 73 | 2012-06-26 12:09:40 | 2012-06-26 12:14:41 |
| 2012-06-26 | 15 | 137 | 2012-06-26 15:09:23 | 2012-06-26 15:17:37 |
| 2012-06-26 | 18 | 120 | 2012-06-26 18:09:27 | 2012-06-26 18:18:26 |
| 2012-06-26 | 21 | 126 | 2012-06-26 21:09:47 | 2012-06-26 21:18:42 |
| 2012-06-27 | 0 | 1 | 2012-06-27 00:10:40 | 2012-06-27 00:10:40 |
| 2012-06-27 | 1 | 46 | 2012-06-27 01:50:09 | 2012-06-27 01:54:35 |
| 2012-06-27 | 3 | 4 | 2012-06-27 03:10:16 | 2012-06-27 03:11:17 |
| 2012-06-27 | 6 | 146 | 2012-06-27 06:09:38 | 2012-06-27 06:39:54 |
| 2012-06-27 | 9 | 27 | 2012-06-27 09:09:16 | 2012-06-27 09:12:09 |
| 2012-06-27 | 12 | 59 | 2012-06-27 12:08:36 | 2012-06-27 12:14:08 |
| 2012-06-27 | 15 | 40 | 2012-06-27 15:09:20 | 2012-06-27 15:22:58 |
| 2012-06-27 | 18 | 113 | 2012-06-27 18:09:47 | 2012-06-27 18:27:35 |
| 2012-06-27 | 21 | 173 | 2012-06-27 21:08:56 | 2012-06-27 21:19:57 |
| 2012-06-28 | 0 | 1 | 2012-06-28 00:10:33 | 2012-06-28 00:10:33 |
| 2012-06-28 | 1 | 109 | 2012-06-28 01:49:03 | 2012-06-28 01:56:33 |
| 2012-06-28 | 3 | 8 | 2012-06-28 03:10:06 | 2012-06-28 03:11:09 |
| 2012-06-28 | 6 | 127 | 2012-06-28 06:12:03 | 2012-06-28 06:45:33 |
| 2012-06-28 | 9 | 55 | 2012-06-28 09:10:25 | 2012-06-28 09:13:44 |
| 2012-06-28 | 12 | 100 | 2012-06-28 12:08:50 | 2012-06-28 12:15:37 |
| 2012-06-28 | 15 | 118 | 2012-06-28 15:09:28 | 2012-06-28 15:18:13 |
| 2012-06-28 | 18 | 4 | 2012-06-28 18:08:54 | 2012-06-28 18:08:55 |
| 2012-06-28 | 19 | 1 | 2012-06-28 19:36:38 | 2012-06-28 19:36:38 |
| 2012-06-28 | 21 | 126 | 2012-06-28 21:08:33 | 2012-06-28 21:17:25 |
| 2012-06-29 | 0 | 1 | 2012-06-29 00:10:38 | 2012-06-29 00:10:38 |
| 2012-06-29 | 1 | 143 | 2012-06-29 01:48:18 | 2012-06-29 01:56:51 |
| 2012-06-29 | 3 | 4 | 2012-06-29 03:09:49 | 2012-06-29 03:10:52 |
| 2012-06-29 | 6 | 6 | 2012-06-29 06:09:33 | 2012-06-29 06:10:29 |
| 2012-06-29 | 9 | 14 | 2012-06-29 09:10:19 | 2012-06-29 09:11:26 |
| 2012-06-29 | 12 | 2 | 2012-06-29 12:09:03 | 2012-06-29 12:33:49 |
| 2012-06-29 | 15 | 71 | 2012-06-29 15:09:54 | 2012-06-29 15:14:24 |
| 2012-06-29 | 17 | 157 | 2012-06-29 17:06:52 | 2012-06-29 17:51:42 |
| 2012-06-29 | 18 | 143 | 2012-06-29 18:09:18 | 2012-06-29 18:19:15 |
| 2012-06-29 | 21 | 139 | 2012-06-29 21:08:46 | 2012-06-29 21:19:31 |
| 2012-06-30 | 0 | 1 | 2012-06-30 00:10:16 | 2012-06-30 00:10:16 |
| 2012-06-30 | 1 | 29 | 2012-06-30 01:48:54 | 2012-06-30 01:51:04 |
| 2012-06-30 | 3 | 4 | 2012-06-30 03:09:11 | 2012-06-30 03:10:32 |
| 2012-06-30 | 6 | 110 | 2012-06-30 06:10:16 | 2012-06-30 06:50:11 |
| 2012-06-30 | 9 | 31 | 2012-06-30 09:10:00 | 2012-06-30 09:12:13 |
| 2012-06-30 | 12 | 54 | 2012-06-30 12:09:09 | 2012-06-30 12:13:43 |
| 2012-06-30 | 15 | 17 | 2012-06-30 15:09:42 | 2012-06-30 15:11:54 |
| 2012-06-30 | 18 | 123 | 2012-06-30 18:08:45 | 2012-06-30 18:16:21 |
| 2012-06-30 | 21 | 48 | 2012-06-30 21:21:42 | 2012-06-30 21:24:46 |
| 2012-07-01 | 0 | 1 | 2012-07-01 00:11:05 | 2012-07-01 00:11:05 |
| 2012-07-01 | 1 | 16 | 2012-07-01 01:49:59 | 2012-07-01 01:52:11 |
| 2012-07-01 | 3 | 3 | 2012-07-01 03:09:31 | 2012-07-01 03:10:35 |
| 2012-07-01 | 6 | 32 | 2012-07-01 06:09:43 | 2012-07-01 06:34:33 |
| 2012-07-01 | 9 | 18 | 2012-07-01 09:09:36 | 2012-07-01 09:11:37 |
| 2012-07-01 | 12 | 23 | 2012-07-01 12:09:36 | 2012-07-01 12:11:36 |
| 2012-07-01 | 15 | 49 | 2012-07-01 15:09:19 | 2012-07-01 15:13:27 |
| 2012-07-01 | 18 | 59 | 2012-07-01 18:08:25 | 2012-07-01 18:13:57 |
| 2012-07-01 | 21 | 97 | 2012-07-01 21:08:45 | 2012-07-01 21:15:10 |
| 2012-07-02 | 0 | 1 | 2012-07-02 00:10:50 | 2012-07-02 00:10:50 |
| 2012-07-02 | 1 | 20 | 2012-07-02 01:50:10 | 2012-07-02 01:50:18 |
| 2012-07-02 | 3 | 1 | 2012-07-02 03:11:06 | 2012-07-02 03:11:06 |
| 2012-07-02 | 6 | 1 | 2012-07-02 06:10:42 | 2012-07-02 06:10:42 |
| 2012-07-02 | 9 | 1 | 2012-07-02 09:10:14 | 2012-07-02 09:10:14 |
| 2012-07-02 | 12 | 28 | 2012-07-02 12:09:43 | 2012-07-02 12:11:59 |
| 2012-07-02 | 15 | 1 | 2012-07-02 15:10:59 | 2012-07-02 15:10:59 |
| 2012-07-02 | 18 | 24 | 2012-07-02 18:09:22 | 2012-07-02 18:12:21 |
| 2012-07-02 | 21 | 19 | 2012-07-02 21:10:04 | 2012-07-02 21:12:16 |
| 2012-07-03 | 0 | 1 | 2012-07-03 00:10:58 | 2012-07-03 00:10:58 |
| 2012-07-03 | 1 | 52 | 2012-07-03 01:50:03 | 2012-07-03 01:53:45 |
| 2012-07-03 | 3 | 1 | 2012-07-03 03:10:39 | 2012-07-03 03:10:39 |
| 2012-07-03 | 6 | 28 | 2012-07-03 06:11:40 | 2012-07-03 06:37:19 |
| 2012-07-03 | 9 | 1 | 2012-07-03 09:10:37 | 2012-07-03 09:10:37 |
+---------------+---------------+----------+---------------------+---------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment