Skip to content

Instantly share code, notes, and snippets.

@jdanbrown
Created June 28, 2017 22:54
Show Gist options
  • Save jdanbrown/f734c8bb79d5373cdc34fcad37755c7b to your computer and use it in GitHub Desktop.
Save jdanbrown/f734c8bb79d5373cdc34fcad37755c7b to your computer and use it in GitHub Desktop.
v1 sync runtimes
-- web_nightly fails
-- addresses takes ~6-7h
-- dwellings takes ~4-5h
-- web takes ~45m-1h >80% of the time, and 2-3h <20% of the time, probably due to whether it's running concurrently with the ones above
datawarehouse=> select completed_at - started_at as duration, * from etl.etl_logs where operation='etl' and created_at > now() - interval '14 days' order by duration desc, schema limit 180;
duration | id | operation | kind | schema | started_at | completed_at | created_at | updated_at | table_name
-----------------+---------+-----------+--------+-------------+----------------------------+----------------------------+----------------------------+----------------------------+------------
NULL | 2924404 | etl | schema | dwellings | 2017-06-15 08:00:00.355421 | NULL | 2017-06-15 08:00:00.355421 | 2017-06-15 08:00:00.355421 | NULL
NULL | 2949815 | etl | schema | mortgages | 2017-06-20 09:45:00.126079 | NULL | 2017-06-20 09:45:00.126079 | 2017-06-20 09:45:00.126079 | NULL
NULL | 2939165 | etl | schema | mortgages | 2017-06-18 09:45:00.163968 | NULL | 2017-06-18 09:45:00.163968 | 2017-06-18 09:45:00.163968 | NULL
NULL | 2976012 | etl | schema | mortgages | 2017-06-24 11:45:00.095217 | NULL | 2017-06-24 11:45:00.095217 | 2017-06-24 11:45:00.095217 | NULL
NULL | 2955200 | etl | schema | mortgages | 2017-06-21 09:45:00.117596 | NULL | 2017-06-21 09:45:00.117596 | 2017-06-21 09:45:00.117596 | NULL
NULL | 2991427 | etl | schema | mortgages | 2017-06-27 10:45:00.113432 | NULL | 2017-06-27 10:45:00.113432 | 2017-06-27 10:45:00.113432 | NULL
NULL | 2924968 | etl | schema | mortgages | 2017-06-15 15:45:00.289421 | NULL | 2017-06-15 15:45:00.289421 | 2017-06-15 15:45:00.289421 | NULL
NULL | 2928314 | etl | schema | mortgages | 2017-06-16 06:45:00.122228 | NULL | 2017-06-16 06:45:00.122228 | 2017-06-16 06:45:00.122228 | NULL
NULL | 2928792 | etl | schema | signals | 2017-06-16 11:00:00.245124 | NULL | 2017-06-16 11:00:00.245124 | 2017-06-16 11:00:00.245124 | NULL
NULL | 2933887 | etl | schema | signals | 2017-06-17 11:00:00.184307 | NULL | 2017-06-17 11:00:00.184307 | 2017-06-17 11:00:00.184307 | NULL
NULL | 2944560 | etl | schema | signals | 2017-06-19 11:00:00.176772 | NULL | 2017-06-19 11:00:00.176772 | 2017-06-19 11:00:00.176772 | NULL
NULL | 2950096 | etl | schema | signals | 2017-06-20 11:00:00.178791 | NULL | 2017-06-20 11:00:00.178791 | 2017-06-20 11:00:00.178791 | NULL
NULL | 2939454 | etl | schema | signals | 2017-06-18 11:00:00.147908 | NULL | 2017-06-18 11:00:00.147908 | 2017-06-18 11:00:00.147908 | NULL
NULL | 2924723 | etl | schema | signals | 2017-06-15 11:00:00.154415 | NULL | 2017-06-15 11:00:00.154415 | 2017-06-15 11:00:00.154415 | NULL
NULL | 2963180 | etl | schema | web | 2017-06-22 11:42:50.209377 | NULL | 2017-06-22 11:42:50.209377 | 2017-06-22 11:42:50.209377 | NULL
NULL | 2964716 | etl | schema | web | 2017-06-22 14:15:56.868487 | NULL | 2017-06-22 14:15:56.868487 | 2017-06-22 14:15:56.868487 | NULL
NULL | 2960017 | etl | schema | web | 2017-06-22 03:00:28.92329 | NULL | 2017-06-22 03:00:28.92329 | 2017-06-22 03:00:28.92329 | NULL
NULL | 2972949 | etl | schema | web | 2017-06-23 22:15:50.976563 | NULL | 2017-06-23 22:15:50.976563 | 2017-06-23 22:15:50.976563 | NULL
NULL | 2958481 | etl | schema | web | 2017-06-22 00:03:14.386026 | NULL | 2017-06-22 00:03:14.386026 | 2017-06-22 00:03:14.386026 | NULL
NULL | 2965228 | etl | schema | web | 2017-06-22 15:02:09.157895 | NULL | 2017-06-22 15:02:09.157895 | 2017-06-22 15:02:09.157895 | NULL
NULL | 2963692 | etl | schema | web | 2017-06-22 12:40:42.947631 | NULL | 2017-06-22 12:40:42.947631 | 2017-06-22 12:40:42.947631 | NULL
NULL | 2958993 | etl | schema | web | 2017-06-22 01:00:32.401942 | NULL | 2017-06-22 01:00:32.401942 | 2017-06-22 01:00:32.401942 | NULL
NULL | 2984291 | etl | schema | web | 2017-06-26 03:07:34.198739 | NULL | 2017-06-26 03:07:34.198739 | 2017-06-26 03:07:34.198739 | NULL
NULL | 2935916 | etl | schema | web | 2017-06-17 21:37:33.861291 | NULL | 2017-06-17 21:37:33.861291 | 2017-06-17 21:37:33.861291 | NULL
NULL | 2966764 | etl | schema | web | 2017-06-22 18:00:31.110403 | NULL | 2017-06-22 18:00:31.110403 | 2017-06-22 18:00:31.110403 | NULL
NULL | 2965740 | etl | schema | web | 2017-06-22 16:22:28.603986 | NULL | 2017-06-22 16:22:28.603986 | 2017-06-22 16:22:28.603986 | NULL
NULL | 2966252 | etl | schema | web | 2017-06-22 17:11:46.929956 | NULL | 2017-06-22 17:11:46.929956 | 2017-06-22 17:11:46.929956 | NULL
NULL | 2995779 | etl | schema | web | 2017-06-28 07:04:14.051528 | NULL | 2017-06-28 07:04:14.051528 | 2017-06-28 07:04:14.051528 | NULL
NULL | 2959505 | etl | schema | web | 2017-06-22 02:00:37.198183 | NULL | 2017-06-22 02:00:37.198183 | 2017-06-22 02:00:37.198183 | NULL
NULL | 2972950 | etl | schema | web | 2017-06-23 22:16:00.969629 | NULL | 2017-06-23 22:16:00.969629 | 2017-06-23 22:16:00.969629 | NULL
NULL | 2997333 | etl | schema | web | 2017-06-28 14:47:13.223631 | NULL | 2017-06-28 14:47:13.223631 | 2017-06-28 14:47:13.223631 | NULL
NULL | 2961562 | etl | schema | web | 2017-06-22 06:00:34.166287 | NULL | 2017-06-22 06:00:34.166287 | 2017-06-22 06:00:34.166287 | NULL
NULL | 2972909 | etl | schema | web | 2017-06-23 21:36:52.933146 | NULL | 2017-06-23 21:36:52.933146 | 2017-06-23 21:36:52.933146 | NULL
NULL | 2961041 | etl | schema | web | 2017-06-22 05:00:24.974697 | NULL | 2017-06-22 05:00:24.974697 | 2017-06-22 05:00:24.974697 | NULL
NULL | 2991793 | etl | schema | web | 2017-06-27 14:27:38.114988 | NULL | 2017-06-27 14:27:38.114988 | 2017-06-27 14:27:38.114988 | NULL
NULL | 2999119 | etl | schema | web | 2017-06-28 22:14:21.66645 | NULL | 2017-06-28 22:14:21.66645 | 2017-06-28 22:14:21.66645 | NULL
NULL | 2964204 | etl | schema | web | 2017-06-22 13:29:15.25875 | NULL | 2017-06-22 13:29:15.25875 | 2017-06-22 13:29:15.25875 | NULL
NULL | 2951572 | etl | schema | web | 2017-06-20 19:15:10.794956 | NULL | 2017-06-20 19:15:10.794956 | 2017-06-20 19:15:10.794956 | NULL
NULL | 2972947 | etl | schema | web | 2017-06-23 22:00:41.91617 | NULL | 2017-06-23 22:00:41.91617 | 2017-06-23 22:00:41.91617 | NULL
NULL | 2951902 | etl | schema | web | 2017-06-20 20:00:35.542409 | NULL | 2017-06-20 20:00:35.542409 | 2017-06-20 20:00:35.542409 | NULL
NULL | 2960529 | etl | schema | web | 2017-06-22 04:00:32.96054 | NULL | 2017-06-22 04:00:32.96054 | 2017-06-22 04:00:32.96054 | NULL
NULL | 2945368 | etl | schema | web | 2017-06-19 16:13:29.993466 | NULL | 2017-06-19 16:13:29.993466 | 2017-06-19 16:13:29.993466 | NULL
NULL | 2972948 | etl | schema | web | 2017-06-23 22:10:35.252446 | NULL | 2017-06-23 22:10:35.252446 | 2017-06-23 22:10:35.252446 | NULL
NULL | 2962361 | etl | schema | web | 2017-06-22 08:05:51.033583 | NULL | 2017-06-22 08:05:51.033583 | 2017-06-22 08:05:51.033583 | NULL
NULL | 2944344 | etl | schema | web_nightly | 2017-06-19 10:00:00.470972 | NULL | 2017-06-19 10:00:00.470972 | 2017-06-19 10:00:00.470972 | NULL
NULL | 2970719 | etl | schema | web_nightly | 2017-06-23 10:00:00.481289 | NULL | 2017-06-23 10:00:00.481289 | 2017-06-23 10:00:00.481289 | NULL
NULL | 2928635 | etl | schema | web_nightly | 2017-06-16 10:00:00.496525 | NULL | 2017-06-16 10:00:00.496525 | 2017-06-16 10:00:00.496525 | NULL
NULL | 2975749 | etl | schema | web_nightly | 2017-06-24 10:00:00.442135 | NULL | 2017-06-24 10:00:00.442135 | 2017-06-24 10:00:00.442135 | NULL
NULL | 2962934 | etl | schema | web_nightly | 2017-06-22 10:00:00.397612 | NULL | 2017-06-22 10:00:00.397612 | 2017-06-22 10:00:00.397612 | NULL
NULL | 2949864 | etl | schema | web_nightly | 2017-06-20 10:00:00.387516 | NULL | 2017-06-20 10:00:00.387516 | 2017-06-20 10:00:00.387516 | NULL
NULL | 2924685 | etl | schema | web_nightly | 2017-06-15 10:00:00.384224 | NULL | 2017-06-15 10:00:00.384224 | 2017-06-15 10:00:00.384224 | NULL
NULL | 2986345 | etl | schema | web_nightly | 2017-06-26 10:00:00.407054 | NULL | 2017-06-26 10:00:00.407054 | 2017-06-26 10:00:00.407054 | NULL
NULL | 2933659 | etl | schema | web_nightly | 2017-06-17 10:00:00.444086 | NULL | 2017-06-17 10:00:00.444086 | 2017-06-17 10:00:00.444086 | NULL
NULL | 2980814 | etl | schema | web_nightly | 2017-06-25 10:00:00.414592 | NULL | 2017-06-25 10:00:00.414592 | 2017-06-25 10:00:00.414592 | NULL
NULL | 2991413 | etl | schema | web_nightly | 2017-06-27 10:00:00.478494 | NULL | 2017-06-27 10:00:00.478494 | 2017-06-27 10:00:00.478494 | NULL
NULL | 2939215 | etl | schema | web_nightly | 2017-06-18 10:00:00.539424 | NULL | 2017-06-18 10:00:00.539424 | 2017-06-18 10:00:00.539424 | NULL
NULL | 2955291 | etl | schema | web_nightly | 2017-06-21 10:00:00.293314 | NULL | 2017-06-21 10:00:00.293314 | 2017-06-21 10:00:00.293314 | NULL
NULL | 2996452 | etl | schema | web_nightly | 2017-06-28 10:00:00.421489 | NULL | 2017-06-28 10:00:00.421489 | 2017-06-28 10:00:00.421489 | NULL
07:25:42.281219 | 2995496 | etl | schema | addresses | 2017-06-28 06:00:00.182521 | 2017-06-28 13:25:42.46374 | 2017-06-28 06:00:00.182521 | 2017-06-28 13:25:42.46374 | NULL
07:08:10.379163 | 2961553 | etl | schema | addresses | 2017-06-22 06:00:00.174965 | 2017-06-22 13:08:10.554128 | 2017-06-22 06:00:00.174965 | 2017-06-22 13:08:10.554128 | NULL
06:57:49.41077 | 2990473 | etl | schema | addresses | 2017-06-27 06:00:00.155872 | 2017-06-27 12:57:49.566642 | 2017-06-27 06:00:00.155872 | 2017-06-27 12:57:49.566642 | NULL
06:39:11.979933 | 2985408 | etl | schema | addresses | 2017-06-26 06:00:00.166771 | 2017-06-26 12:39:12.146704 | 2017-06-26 06:00:00.166771 | 2017-06-26 12:39:12.146704 | NULL
06:36:22.47443 | 2938270 | etl | schema | addresses | 2017-06-18 06:00:00.1653 | 2017-06-18 12:36:22.63973 | 2017-06-18 06:00:00.1653 | 2017-06-18 12:36:22.63973 | NULL
06:31:41.846386 | 2979875 | etl | schema | addresses | 2017-06-25 06:00:00.178698 | 2017-06-25 12:31:42.025084 | 2017-06-25 06:00:00.178698 | 2017-06-25 12:31:42.025084 | NULL
06:29:21.715398 | 2932700 | etl | schema | addresses | 2017-06-17 06:00:00.178969 | 2017-06-17 12:29:21.894367 | 2017-06-17 06:00:00.178969 | 2017-06-17 12:29:21.894367 | NULL
06:28:32.937768 | 2948948 | etl | schema | addresses | 2017-06-20 06:00:00.209685 | 2017-06-20 12:28:33.147453 | 2017-06-20 06:00:00.209685 | 2017-06-20 12:28:33.147453 | NULL
06:27:53.131359 | 2943373 | etl | schema | addresses | 2017-06-19 06:00:00.174023 | 2017-06-19 12:27:53.305382 | 2017-06-19 06:00:00.174023 | 2017-06-19 12:27:53.305382 | NULL
06:27:34.699386 | 2974816 | etl | schema | addresses | 2017-06-24 06:00:00.17842 | 2017-06-24 12:27:34.877806 | 2017-06-24 06:00:00.17842 | 2017-06-24 12:27:34.877806 | NULL
06:19:56.514076 | 2969767 | etl | schema | addresses | 2017-06-23 06:00:00.196886 | 2017-06-23 12:19:56.710962 | 2017-06-23 06:00:00.196886 | 2017-06-23 12:19:56.710962 | NULL
06:13:40.556282 | 2954691 | etl | schema | addresses | 2017-06-21 06:00:00.2819 | 2017-06-21 12:13:40.838182 | 2017-06-21 06:00:00.2819 | 2017-06-21 12:13:40.838182 | NULL
06:11:22.552902 | 2928063 | etl | schema | addresses | 2017-06-16 06:00:00.217496 | 2017-06-16 12:11:22.770398 | 2017-06-16 06:00:00.217496 | 2017-06-16 12:11:22.770398 | NULL
04:56:52.619014 | 2996297 | etl | schema | dwellings | 2017-06-28 08:00:00.321202 | 2017-06-28 12:56:52.940216 | 2017-06-28 08:00:00.321202 | 2017-06-28 12:56:52.940216 | NULL
04:40:24.73845 | 2962351 | etl | schema | dwellings | 2017-06-22 08:00:00.261522 | 2017-06-22 12:40:24.999972 | 2017-06-22 08:00:00.261522 | 2017-06-22 12:40:24.999972 | NULL
04:22:18.373003 | 2991276 | etl | schema | dwellings | 2017-06-27 08:00:00.881044 | 2017-06-27 12:22:19.254047 | 2017-06-27 08:00:00.881044 | 2017-06-27 12:22:19.254047 | NULL
04:21:41.520782 | 2986211 | etl | schema | dwellings | 2017-06-26 08:00:00.571083 | 2017-06-26 12:21:42.091865 | 2017-06-26 08:00:00.571083 | 2017-06-26 12:21:42.091865 | NULL
04:16:42.162418 | 2939063 | etl | schema | dwellings | 2017-06-18 08:00:00.240661 | 2017-06-18 12:16:42.403079 | 2017-06-18 08:00:00.240661 | 2017-06-18 12:16:42.403079 | NULL
04:14:30.873386 | 2980684 | etl | schema | dwellings | 2017-06-25 08:00:00.222488 | 2017-06-25 12:14:31.095874 | 2017-06-25 08:00:00.222488 | 2017-06-25 12:14:31.095874 | NULL
04:13:16.769012 | 2949286 | etl | schema | dwellings | 2017-06-20 08:00:00.282157 | 2017-06-20 12:13:17.051169 | 2017-06-20 08:00:00.282157 | 2017-06-20 12:13:17.051169 | NULL
04:11:12.21232 | 2975616 | etl | schema | dwellings | 2017-06-24 08:00:00.198308 | 2017-06-24 12:11:12.410628 | 2017-06-24 08:00:00.198308 | 2017-06-24 12:11:12.410628 | NULL
04:10:42.40258 | 2944168 | etl | schema | dwellings | 2017-06-19 08:00:00.209562 | 2017-06-19 12:10:42.612142 | 2017-06-19 08:00:00.209562 | 2017-06-19 12:10:42.612142 | NULL
04:10:36.684796 | 2933495 | etl | schema | dwellings | 2017-06-17 08:00:00.252965 | 2017-06-17 12:10:36.937761 | 2017-06-17 08:00:00.252965 | 2017-06-17 12:10:36.937761 | NULL
03:55:35.751148 | 2955061 | etl | schema | dwellings | 2017-06-21 08:00:00.339155 | 2017-06-21 11:55:36.090303 | 2017-06-21 08:00:00.339155 | 2017-06-21 11:55:36.090303 | NULL
03:51:48.412028 | 2928431 | etl | schema | dwellings | 2017-06-16 08:00:00.358281 | 2017-06-16 11:51:48.770309 | 2017-06-16 08:00:00.358281 | 2017-06-16 11:51:48.770309 | NULL
03:51:06.847791 | 2970568 | etl | schema | dwellings | 2017-06-23 08:00:00.292036 | 2017-06-23 11:51:07.139827 | 2017-06-23 08:00:00.292036 | 2017-06-23 11:51:07.139827 | NULL
03:36:24.569832 | 2924080 | etl | schema | addresses | 2017-06-15 06:00:00.176876 | 2017-06-15 09:36:24.746708 | 2017-06-15 06:00:00.176876 | 2017-06-15 09:36:24.746708 | NULL
03:07:50.535173 | 2949271 | etl | schema | web | 2017-06-20 07:54:03.428332 | 2017-06-20 11:01:53.963505 | 2017-06-20 07:54:03.428332 | 2017-06-20 11:01:53.963505 | NULL
02:55:45.768783 | 2996362 | etl | schema | web | 2017-06-28 09:23:37.886347 | 2017-06-28 12:19:23.65513 | 2017-06-28 09:23:37.886347 | 2017-06-28 12:19:23.65513 | NULL
02:37:48.19486 | 2938553 | etl | schema | web | 2017-06-18 06:59:22.868751 | 2017-06-18 09:37:11.063611 | 2017-06-18 06:59:22.868751 | 2017-06-18 09:37:11.063611 | NULL
02:32:57.593093 | 2943383 | etl | schema | web | 2017-06-19 06:02:32.757796 | 2017-06-19 08:35:30.350889 | 2017-06-19 06:02:32.757796 | 2017-06-19 08:35:30.350889 | NULL
02:29:53.082055 | 2932940 | etl | schema | web | 2017-06-17 06:28:29.25676 | 2017-06-17 08:58:22.338815 | 2017-06-17 06:28:29.25676 | 2017-06-17 08:58:22.338815 | NULL
02:24:34.387249 | 2985653 | etl | schema | web | 2017-06-26 06:38:52.019116 | 2017-06-26 09:03:26.406365 | 2017-06-26 06:38:52.019116 | 2017-06-26 09:03:26.406365 | NULL
02:20:53.866786 | 2990718 | etl | schema | web | 2017-06-27 06:38:59.967706 | 2017-06-27 08:59:53.834492 | 2017-06-27 06:38:59.967706 | 2017-06-27 08:59:53.834492 | NULL
02:10:26.105297 | 2975061 | etl | schema | web | 2017-06-24 06:44:02.183161 | 2017-06-24 08:54:28.288458 | 2017-06-24 06:44:02.183161 | 2017-06-24 08:54:28.288458 | NULL
02:06:48.006284 | 2969776 | etl | schema | web | 2017-06-23 06:00:04.721785 | 2017-06-23 08:06:52.728069 | 2017-06-23 06:00:04.721785 | 2017-06-23 08:06:52.728069 | NULL
01:57:20.110098 | 2979863 | etl | schema | web | 2017-06-25 05:55:57.038691 | 2017-06-25 07:53:17.148789 | 2017-06-25 05:55:57.038691 | 2017-06-25 07:53:17.148789 | NULL
01:39:10.400119 | 2955179 | etl | schema | web | 2017-06-21 09:39:37.254285 | 2017-06-21 11:18:47.654404 | 2017-06-21 09:39:37.254285 | 2017-06-21 11:18:47.654404 | NULL
01:22:46.602255 | 2930813 | etl | schema | web | 2017-06-16 21:13:04.366318 | 2017-06-16 22:35:50.968573 | 2017-06-16 21:13:04.366318 | 2017-06-16 22:35:50.968573 | NULL
01:22:09.620866 | 2927560 | etl | schema | web | 2017-06-16 05:39:20.95021 | 2017-06-16 07:01:30.571076 | 2017-06-16 05:39:20.95021 | 2017-06-16 07:01:30.571076 | NULL
01:17:37.12305 | 2997851 | etl | schema | web | 2017-06-28 16:08:13.572649 | 2017-06-28 17:25:50.695699 | 2017-06-28 16:08:13.572649 | 2017-06-28 17:25:50.695699 | NULL
01:02:41.340952 | 2929555 | etl | schema | web | 2017-06-16 15:32:32.639829 | 2017-06-16 16:35:13.980781 | 2017-06-16 15:32:32.639829 | 2017-06-16 16:35:13.980781 | NULL
00:56:30.318103 | 2967871 | etl | schema | web | 2017-06-22 21:33:52.131027 | 2017-06-22 22:30:22.44913 | 2017-06-22 21:33:52.131027 | 2017-06-22 22:30:22.44913 | NULL
00:54:20.220379 | 2967238 | etl | schema | web | 2017-06-22 18:42:10.996706 | 2017-06-22 19:36:31.217085 | 2017-06-22 18:42:10.996706 | 2017-06-22 19:36:31.217085 | NULL
00:52:17.152737 | 2934695 | etl | schema | web | 2017-06-17 16:20:48.479004 | 2017-06-17 17:13:05.631741 | 2017-06-17 16:20:48.479004 | 2017-06-17 17:13:05.631741 | NULL
00:52:09.259953 | 2930184 | etl | schema | web | 2017-06-16 18:24:18.729568 | 2017-06-16 19:16:27.989521 | 2017-06-16 18:24:18.729568 | 2017-06-16 19:16:27.989521 | NULL
00:50:47.955936 | 2925104 | etl | schema | web | 2017-06-15 18:22:52.166602 | 2017-06-15 19:13:40.122538 | 2017-06-15 18:22:52.166602 | 2017-06-15 19:13:40.122538 | NULL
00:50:44.433554 | 2945877 | etl | schema | web | 2017-06-19 17:21:19.533111 | 2017-06-19 18:12:03.966665 | 2017-06-19 17:21:19.533111 | 2017-06-19 18:12:03.966665 | NULL
00:50:14.714335 | 2972951 | etl | schema | web | 2017-06-23 22:19:55.917614 | 2017-06-23 23:10:10.631949 | 2017-06-23 22:19:55.917614 | 2017-06-23 23:10:10.631949 | NULL
00:50:08.910861 | 2937678 | etl | schema | web | 2017-06-18 04:02:28.701604 | 2017-06-18 04:52:37.612465 | 2017-06-18 04:02:28.701604 | 2017-06-18 04:52:37.612465 | NULL
00:50:07.962476 | 2946506 | etl | schema | web | 2017-06-19 20:03:28.851532 | 2017-06-19 20:53:36.814008 | 2017-06-19 20:03:28.851532 | 2017-06-19 20:53:36.814008 | NULL
00:50:05.031415 | 2976727 | etl | schema | web | 2017-06-24 16:12:46.395845 | 2017-06-24 17:02:51.42726 | 2017-06-24 16:12:46.395845 | 2017-06-24 17:02:51.42726 | NULL
00:49:57.331898 | 2987962 | etl | schema | web | 2017-06-26 18:58:47.301974 | 2017-06-26 19:48:44.633872 | 2017-06-26 18:58:47.301974 | 2017-06-26 19:48:44.633872 | NULL
00:49:37.257495 | 2982417 | etl | schema | web | 2017-06-25 18:53:06.139443 | 2017-06-25 19:42:43.396938 | 2017-06-25 18:53:06.139443 | 2017-06-25 19:42:43.396938 | NULL
00:49:31.569936 | 2992948 | etl | schema | web | 2017-06-27 18:33:46.92708 | 2017-06-27 19:23:18.497016 | 2017-06-27 18:33:46.92708 | 2017-06-27 19:23:18.497016 | NULL
00:49:16.939682 | 2974219 | etl | schema | web | 2017-06-24 03:55:13.312822 | 2017-06-24 04:44:30.252504 | 2017-06-24 03:55:13.312822 | 2017-06-24 04:44:30.252504 | NULL
00:49:14.932669 | 2937049 | etl | schema | web | 2017-06-18 01:03:25.70421 | 2017-06-18 01:52:40.636879 | 2017-06-18 01:03:25.70421 | 2017-06-18 01:52:40.636879 | NULL
00:49:13.967312 | 2935324 | etl | schema | web | 2017-06-17 19:00:08.949584 | 2017-06-17 19:49:22.916896 | 2017-06-17 19:00:08.949584 | 2017-06-17 19:49:22.916896 | NULL
00:49:13.902508 | 2988599 | etl | schema | web | 2017-06-26 21:47:39.939886 | 2017-06-26 22:36:53.842394 | 2017-06-26 21:47:39.939886 | 2017-06-26 22:36:53.842394 | NULL
00:48:53.58148 | 2968502 | etl | schema | web | 2017-06-23 00:30:47.390257 | 2017-06-23 01:19:40.971737 | 2017-06-23 00:30:47.390257 | 2017-06-23 01:19:40.971737 | NULL
00:48:47.623988 | 2932108 | etl | schema | web | 2017-06-17 03:48:32.375599 | 2017-06-17 04:37:19.999587 | 2017-06-17 03:48:32.375599 | 2017-06-17 04:37:19.999587 | NULL
00:48:45.541558 | 2992311 | etl | schema | web | 2017-06-27 15:44:48.456363 | 2017-06-27 16:33:33.997921 | 2017-06-27 15:44:48.456363 | 2017-06-27 16:33:33.997921 | NULL
00:48:41.12379 | 2936420 | etl | schema | web | 2017-06-17 22:25:41.111735 | 2017-06-17 23:14:22.235525 | 2017-06-17 22:25:41.111735 | 2017-06-17 23:14:22.235525 | NULL
00:48:30.838463 | 2972312 | etl | schema | web | 2017-06-23 18:53:45.693691 | 2017-06-23 19:42:16.532154 | 2017-06-23 18:53:45.693691 | 2017-06-23 19:42:16.532154 | NULL
00:48:25.263975 | 2989199 | etl | schema | web | 2017-06-27 00:30:34.334163 | 2017-06-27 01:18:59.598138 | 2017-06-27 00:30:34.334163 | 2017-06-27 01:18:59.598138 | NULL
00:48:21.302334 | 2940265 | etl | schema | web | 2017-06-18 16:24:52.233591 | 2017-06-18 17:13:13.535925 | 2017-06-18 16:24:52.233591 | 2017-06-18 17:13:13.535925 | NULL
00:48:19.968819 | 2989873 | etl | schema | web | 2017-06-27 03:47:05.29148 | 2017-06-27 04:35:25.260299 | 2017-06-27 03:47:05.29148 | 2017-06-27 04:35:25.260299 | NULL
00:48:05.127466 | 2926968 | etl | schema | web | 2017-06-16 02:51:54.467485 | 2017-06-16 03:39:59.594951 | 2017-06-16 02:51:54.467485 | 2017-06-16 03:39:59.594951 | NULL
00:48:03.284179 | 2957262 | etl | schema | web | 2017-06-21 18:46:18.740606 | 2017-06-21 19:34:22.024785 | 2017-06-21 18:46:18.740606 | 2017-06-21 19:34:22.024785 | NULL
00:48:02.993497 | 2978592 | etl | schema | web | 2017-06-24 23:52:50.892258 | 2017-06-25 00:40:53.885755 | 2017-06-24 23:52:50.892258 | 2017-06-25 00:40:53.885755 | NULL
00:48:01.037647 | 2994896 | etl | schema | web | 2017-06-28 03:47:51.469375 | 2017-06-28 04:35:52.507022 | 2017-06-28 03:47:51.469375 | 2017-06-28 04:35:52.507022 | NULL
00:47:51.188235 | 2977958 | etl | schema | web | 2017-06-24 21:20:37.450369 | 2017-06-24 22:08:28.638604 | 2017-06-24 21:20:37.450369 | 2017-06-24 22:08:28.638604 | NULL
00:47:48.758428 | 2983654 | etl | schema | web | 2017-06-26 00:28:09.030172 | 2017-06-26 01:15:57.7886 | 2017-06-26 00:28:09.030172 | 2017-06-26 01:15:57.7886 | NULL
00:47:48.393257 | 2983017 | etl | schema | web | 2017-06-25 21:35:30.573677 | 2017-06-25 22:23:18.966934 | 2017-06-25 21:35:30.573677 | 2017-06-25 22:23:18.966934 | NULL
00:47:47.595038 | 2977324 | etl | schema | web | 2017-06-24 18:44:17.68779 | 2017-06-24 19:32:05.282828 | 2017-06-24 18:44:17.68779 | 2017-06-24 19:32:05.282828 | NULL
00:47:43.577901 | 2947098 | etl | schema | web | 2017-06-19 22:43:15.047862 | 2017-06-19 23:30:58.625763 | 2017-06-19 22:43:15.047862 | 2017-06-19 23:30:58.625763 | NULL
00:47:33.462606 | 2998488 | etl | schema | web | 2017-06-28 19:28:35.114254 | 2017-06-28 20:16:08.57686 | 2017-06-28 19:28:35.114254 | 2017-06-28 20:16:08.57686 | NULL
00:47:30.428386 | 2941486 | etl | schema | web | 2017-06-18 21:27:50.245182 | 2017-06-18 22:15:20.673568 | 2017-06-18 21:27:50.245182 | 2017-06-18 22:15:20.673568 | NULL
00:47:24.245026 | 2956006 | etl | schema | web | 2017-06-21 13:38:23.03686 | 2017-06-21 14:25:47.281886 | 2017-06-21 13:38:23.03686 | 2017-06-21 14:25:47.281886 | NULL
00:47:19.358644 | 2987325 | etl | schema | web | 2017-06-26 16:26:01.184222 | 2017-06-26 17:13:20.542866 | 2017-06-26 16:26:01.184222 | 2017-06-26 17:13:20.542866 | NULL
00:47:16.785004 | 2950943 | etl | schema | web | 2017-06-20 16:30:12.420232 | 2017-06-20 17:17:29.205236 | 2017-06-20 16:30:12.420232 | 2017-06-20 17:17:29.205236 | NULL
00:47:14.829185 | 2993585 | etl | schema | web | 2017-06-27 21:31:29.597644 | 2017-06-27 22:18:44.426829 | 2017-06-27 21:31:29.597644 | 2017-06-27 22:18:44.426829 | NULL
00:47:10.226812 | 2971044 | etl | schema | web | 2017-06-23 13:39:22.35495 | 2017-06-23 14:26:32.581762 | 2017-06-23 13:39:22.35495 | 2017-06-23 14:26:32.581762 | NULL
00:47:09.197466 | 2953556 | etl | schema | web | 2017-06-21 02:38:38.312536 | 2017-06-21 03:25:47.510002 | 2017-06-21 02:38:38.312536 | 2017-06-21 03:25:47.510002 | NULL
00:47:05.159932 | 2950351 | etl | schema | web | 2017-06-20 13:52:24.713128 | 2017-06-20 14:39:29.87306 | 2017-06-20 13:52:24.713128 | 2017-06-20 14:39:29.87306 | NULL
00:47:02.874456 | 2947727 | etl | schema | web | 2017-06-20 01:16:42.505893 | 2017-06-20 02:03:45.380349 | 2017-06-20 01:16:42.505893 | 2017-06-20 02:03:45.380349 | NULL
00:47:02.124898 | 2934066 | etl | schema | web | 2017-06-17 13:44:04.444383 | 2017-06-17 14:31:06.569281 | 2017-06-17 13:44:04.444383 | 2017-06-17 14:31:06.569281 | NULL
00:47:00.22849 | 2942744 | etl | schema | web | 2017-06-19 03:05:30.937466 | 2017-06-19 03:52:31.165956 | 2017-06-19 03:05:30.937466 | 2017-06-19 03:52:31.165956 | NULL
00:46:58.951492 | 2926305 | etl | schema | web | 2017-06-15 23:34:24.501057 | 2017-06-16 00:21:23.452549 | 2017-06-15 23:34:24.501057 | 2017-06-16 00:21:23.452549 | NULL
00:46:51.538073 | 2986725 | etl | schema | web | 2017-06-26 13:49:48.587643 | 2017-06-26 14:36:40.125716 | 2017-06-26 13:49:48.587643 | 2017-06-26 14:36:40.125716 | NULL
00:46:50.962475 | 2939673 | etl | schema | web | 2017-06-18 13:53:20.804564 | 2017-06-18 14:40:11.767039 | 2017-06-18 13:53:20.804564 | 2017-06-18 14:40:11.767039 | NULL
00:46:48.326007 | 2957853 | etl | schema | web | 2017-06-21 21:29:04.22917 | 2017-06-21 22:15:52.555177 | 2017-06-21 21:29:04.22917 | 2017-06-21 22:15:52.555177 | NULL
00:46:32.391316 | 2971678 | etl | schema | web | 2017-06-23 16:18:11.104854 | 2017-06-23 17:04:43.49617 | 2017-06-23 16:18:11.104854 | 2017-06-23 17:04:43.49617 | NULL
00:46:31.446223 | 2952928 | etl | schema | web | 2017-06-20 23:38:53.012441 | 2017-06-21 00:25:24.458664 | 2017-06-20 23:38:53.012441 | 2017-06-21 00:25:24.458664 | NULL
00:46:25.986083 | 2956634 | etl | schema | web | 2017-06-21 16:17:18.059104 | 2017-06-21 17:03:44.045187 | 2017-06-21 16:17:18.059104 | 2017-06-21 17:03:44.045187 | NULL
00:46:25.710556 | 2944739 | etl | schema | web | 2017-06-19 13:39:59.108596 | 2017-06-19 14:26:24.819152 | 2017-06-19 13:39:59.108596 | 2017-06-19 14:26:24.819152 | NULL
00:46:21.904766 | 2976093 | etl | schema | web | 2017-06-24 13:41:15.636452 | 2017-06-24 14:27:37.541218 | 2017-06-24 13:41:15.636452 | 2017-06-24 14:27:37.541218 | NULL
00:46:15.874163 | 2981180 | etl | schema | web | 2017-06-25 13:49:17.760682 | 2017-06-25 14:35:33.634845 | 2017-06-25 13:49:17.760682 | 2017-06-25 14:35:33.634845 | NULL
00:46:14.029644 | 2979226 | etl | schema | web | 2017-06-25 03:10:31.238851 | 2017-06-25 03:56:45.268495 | 2017-06-25 03:10:31.238851 | 2017-06-25 03:56:45.268495 | NULL
00:46:10.611774 | 2954184 | etl | schema | web | 2017-06-21 05:27:59.47384 | 2017-06-21 06:14:10.085614 | 2017-06-21 05:27:59.47384 | 2017-06-21 06:14:10.085614 | NULL
00:45:59.728201 | 2981780 | etl | schema | web | 2017-06-25 16:24:09.704118 | 2017-06-25 17:10:09.432319 | 2017-06-25 16:24:09.704118 | 2017-06-25 17:10:09.432319 | NULL
00:45:56.615088 | 2973585 | etl | schema | web | 2017-06-24 00:57:38.134329 | 2017-06-24 01:43:34.749417 | 2017-06-24 00:57:38.134329 | 2017-06-24 01:43:34.749417 | NULL
00:45:56.572831 | 2940894 | etl | schema | web | 2017-06-18 18:54:47.738237 | 2017-06-18 19:40:44.311068 | 2017-06-18 18:54:47.738237 | 2017-06-18 19:40:44.311068 | NULL
00:45:50.301104 | 2969133 | etl | schema | web | 2017-06-23 03:15:00.730163 | 2017-06-23 04:00:51.031267 | 2017-06-23 03:15:00.730163 | 2017-06-23 04:00:51.031267 | NULL
00:45:48.329364 | 2994222 | etl | schema | web | 2017-06-28 00:17:28.99113 | 2017-06-28 01:03:17.320494 | 2017-06-28 00:17:28.99113 | 2017-06-28 01:03:17.320494 | NULL
00:45:39.361905 | 2984808 | etl | schema | web | 2017-06-26 04:00:27.767286 | 2017-06-26 04:46:07.129191 | 2017-06-26 04:00:27.767286 | 2017-06-26 04:46:07.129191 | NULL
00:45:34.925851 | 2928963 | etl | schema | web | 2017-06-16 12:58:01.516558 | 2017-06-16 13:43:36.442409 | 2017-06-16 12:58:01.516558 | 2017-06-16 13:43:36.442409 | NULL
00:45:34.161977 | 2948393 | etl | schema | web | 2017-06-20 04:54:13.139954 | 2017-06-20 05:39:47.301931 | 2017-06-20 04:54:13.139954 | 2017-06-20 05:39:47.301931 | NULL
00:45:33.813576 | 2942115 | etl | schema | web | 2017-06-18 23:56:33.247026 | 2017-06-19 00:42:07.060602 | 2017-06-18 23:56:33.247026 | 2017-06-19 00:42:07.060602 | NULL
00:45:26.086445 | 2952373 | etl | schema | web | 2017-06-20 21:00:31.879528 | 2017-06-20 21:45:57.965973 | 2017-06-20 21:00:31.879528 | 2017-06-20 21:45:57.965973 | NULL
00:44:53.096848 | 2931442 | etl | schema | web | 2017-06-17 00:19:55.328595 | 2017-06-17 01:04:48.425443 | 2017-06-17 00:19:55.328595 | 2017-06-17 01:04:48.425443 | NULL
00:44:25.312097 | 2925727 | etl | schema | web | 2017-06-15 21:04:53.994652 | 2017-06-15 21:49:19.306749 | 2017-06-15 21:04:53.994652 | 2017-06-15 21:49:19.306749 | NULL
00:01:09.176124 | 2928392 | etl | schema | mortgages | 2017-06-16 07:45:00.147781 | 2017-06-16 07:46:09.323905 | 2017-06-16 07:45:00.147781 | 2017-06-16 07:46:09.323905 | NULL
00:00:56.25052 | 2943215 | etl | schema | mortgages | 2017-06-19 03:45:00.109704 | 2017-06-19 03:45:56.360224 | 2017-06-19 03:45:00.109704 | 2017-06-19 03:45:56.360224 | NULL
00:00:54.414937 | 2962483 | etl | schema | mortgages | 2017-06-22 08:45:00.917004 | 2017-06-22 08:45:55.331941 | 2017-06-22 08:45:00.917004 | 2017-06-22 08:45:55.331941 | NULL
00:00:52.354147 | 2962989 | etl | schema | mortgages | 2017-06-22 10:45:00.140239 | 2017-06-22 10:45:52.494386 | 2017-06-22 10:45:00.140239 | 2017-06-22 10:45:52.494386 | NULL
00:00:47.001871 | 2998330 | etl | schema | mortgages | 2017-06-28 16:45:00.150498 | 2017-06-28 16:45:47.152369 | 2017-06-28 16:45:00.150498 | 2017-06-28 16:45:47.152369 | NULL
00:00:46.422491 | 2984770 | etl | schema | mortgages | 2017-06-26 03:45:00.151722 | 2017-06-26 03:45:46.574213 | 2017-06-26 03:45:00.151722 | 2017-06-26 03:45:46.574213 | NULL
00:00:46.33868 | 2982255 | etl | schema | mortgages | 2017-06-25 16:45:00.098032 | 2017-06-25 16:45:46.436712 | 2017-06-25 16:45:00.098032 | 2017-06-25 16:45:46.436712 | NULL
00:00:46.220916 | 2949759 | etl | schema | mortgages | 2017-06-20 08:45:00.139312 | 2017-06-20 08:45:46.360228 | 2017-06-20 08:45:00.139312 | 2017-06-20 08:45:46.360228 | NULL
00:00:45.524748 | 2986231 | etl | schema | mortgages | 2017-06-26 08:45:00.121908 | 2017-06-26 08:45:45.646656 | 2017-06-26 08:45:00.121908 | 2017-06-26 08:45:45.646656 | NULL
00:00:44.133407 | 2996317 | etl | schema | mortgages | 2017-06-28 08:45:00.157937 | 2017-06-28 08:45:44.291344 | 2017-06-28 08:45:00.157937 | 2017-06-28 08:45:44.291344 | NULL
(180 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment