explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pqRJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=918,745.17..918,745.20 rows=1 width=88) (actual rows= loops=)

2.          

CTE error_job_runs

3. 0.000 0.000 ↓ 0.0

Unique (cost=909,702.25..909,707.57 rows=532 width=452) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=909,702.25..909,703.58 rows=532 width=452) (actual rows= loops=)

  • Sort Key: de.object_id, de.event_datetime, de.event_detail
5. 0.000 0.000 ↓ 0.0

Append (cost=0.00..909,678.17 rows=532 width=452) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events de (cost=0.00..0.00 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on dwp_events_20190601 de_1 (cost=18,055.08..192,538.96 rows=59 width=556) (actual rows= loops=)

  • Recheck Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on pk_dwp_events_20190601 (cost=0.00..18,055.06 rows=585,417 width=0) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
9. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on dwp_events_20190602 de_2 (cost=20,276.69..213,402.39 rows=64 width=556) (actual rows= loops=)

  • Recheck Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on pk_dwp_events_20190602 (cost=0.00..20,276.67 rows=642,698 width=0) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
11. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on dwp_events_20190603 de_3 (cost=21,596.20..219,769.43 rows=68 width=556) (actual rows= loops=)

  • Recheck Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
12. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on pk_dwp_events_20190603 (cost=0.00..21,596.18 rows=684,766 width=0) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
13. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190604 on dwp_events_20190604 de_4 (cost=0.43..6.21 rows=1 width=441) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
14. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190605 on dwp_events_20190605 de_5 (cost=0.43..6.21 rows=1 width=441) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
15. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190606 on dwp_events_20190606 de_6 (cost=0.43..6.21 rows=1 width=450) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
16. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190607 on dwp_events_20190607 de_7 (cost=0.43..6.21 rows=1 width=455) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
17. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190608 on dwp_events_20190608 de_8 (cost=0.43..6.21 rows=1 width=460) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
18. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190609 on dwp_events_20190609 de_9 (cost=0.43..6.21 rows=1 width=467) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
19. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190610 on dwp_events_20190610 de_10 (cost=0.43..6.21 rows=1 width=431) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
20. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190611 on dwp_events_20190611 de_11 (cost=0.43..6.21 rows=1 width=436) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
21. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190612 on dwp_events_20190612 de_12 (cost=0.43..6.21 rows=1 width=439) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
22. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190613 on dwp_events_20190613 de_13 (cost=0.43..6.21 rows=1 width=424) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
23. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190614 on dwp_events_20190614 de_14 (cost=0.43..6.21 rows=1 width=447) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
24. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190615 on dwp_events_20190615 de_15 (cost=0.43..6.21 rows=1 width=461) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
25. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190616 on dwp_events_20190616 de_16 (cost=0.43..6.21 rows=1 width=454) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
26. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190617 on dwp_events_20190617 de_17 (cost=0.43..6.21 rows=1 width=427) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
27. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190618 on dwp_events_20190618 de_18 (cost=0.43..6.21 rows=1 width=424) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
28. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190619 on dwp_events_20190619 de_19 (cost=0.43..6.21 rows=1 width=432) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
29. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190620 on dwp_events_20190620 de_20 (cost=0.43..6.21 rows=1 width=430) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
30. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190621 on dwp_events_20190621 de_21 (cost=0.43..6.21 rows=1 width=432) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
31. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190622 on dwp_events_20190622 de_22 (cost=0.43..6.21 rows=1 width=458) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
32. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190623 on dwp_events_20190623 de_23 (cost=0.43..6.21 rows=1 width=464) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
33. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190624 on dwp_events_20190624 de_24 (cost=0.43..6.21 rows=1 width=421) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
34. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190625 on dwp_events_20190625 de_25 (cost=0.43..6.21 rows=1 width=432) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
35. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190626 on dwp_events_20190626 de_26 (cost=0.43..6.21 rows=1 width=431) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
36. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190627 on dwp_events_20190627 de_27 (cost=0.43..6.21 rows=1 width=422) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
37. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190628 on dwp_events_20190628 de_28 (cost=0.43..6.21 rows=1 width=445) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
38. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190629 on dwp_events_20190629 de_29 (cost=0.43..6.21 rows=1 width=460) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
39. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190630 on dwp_events_20190630 de_30 (cost=0.43..6.21 rows=1 width=476) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
40. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190701 on dwp_events_20190701 de_31 (cost=0.44..6.21 rows=1 width=450) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
41. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190702 on dwp_events_20190702 de_32 (cost=0.44..6.21 rows=1 width=433) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
42. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190703 on dwp_events_20190703 de_33 (cost=0.43..6.21 rows=1 width=457) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
43. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190704 on dwp_events_20190704 de_34 (cost=0.43..6.21 rows=1 width=463) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
44. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190705 on dwp_events_20190705 de_35 (cost=0.43..6.21 rows=1 width=456) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
45. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190706 on dwp_events_20190706 de_36 (cost=0.43..6.21 rows=1 width=474) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
46. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190707 on dwp_events_20190707 de_37 (cost=0.43..6.21 rows=1 width=475) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
47. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190708 on dwp_events_20190708 de_38 (cost=0.43..6.21 rows=1 width=434) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
48. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190709 on dwp_events_20190709 de_39 (cost=0.43..6.21 rows=1 width=429) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
49. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190710 on dwp_events_20190710 de_40 (cost=0.43..6.21 rows=1 width=432) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
50. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190711 on dwp_events_20190711 de_41 (cost=0.43..6.21 rows=1 width=433) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
51. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190712 on dwp_events_20190712 de_42 (cost=0.43..6.21 rows=1 width=434) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
52. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190713 on dwp_events_20190713 de_43 (cost=0.43..6.21 rows=1 width=455) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
53. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190714 on dwp_events_20190714 de_44 (cost=0.43..6.21 rows=1 width=458) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
54. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190715 on dwp_events_20190715 de_45 (cost=0.43..6.22 rows=1 width=421) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
55. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190716 on dwp_events_20190716 de_46 (cost=0.43..6.21 rows=1 width=438) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
56. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190717 on dwp_events_20190717 de_47 (cost=0.43..6.21 rows=1 width=456) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
57. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190718 on dwp_events_20190718 de_48 (cost=0.43..6.21 rows=1 width=428) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
58. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190719 on dwp_events_20190719 de_49 (cost=0.43..6.21 rows=1 width=438) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
59. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190720 on dwp_events_20190720 de_50 (cost=0.43..6.21 rows=1 width=464) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
60. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190721 on dwp_events_20190721 de_51 (cost=0.43..6.21 rows=1 width=460) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
61. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190722 on dwp_events_20190722 de_52 (cost=0.43..6.21 rows=1 width=428) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
62. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190723 on dwp_events_20190723 de_53 (cost=0.43..6.21 rows=1 width=439) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
63. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190724 on dwp_events_20190724 de_54 (cost=0.44..6.21 rows=1 width=425) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
64. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190725 on dwp_events_20190725 de_55 (cost=0.44..6.21 rows=1 width=426) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
65. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190726 on dwp_events_20190726 de_56 (cost=0.44..6.21 rows=1 width=341) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
66. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190727 on dwp_events_20190727 de_57 (cost=0.57..6.34 rows=1 width=242) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
67. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190728 on dwp_events_20190728 de_58 (cost=0.44..6.21 rows=1 width=400) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
68. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190729 on dwp_events_20190729 de_59 (cost=0.44..6.21 rows=1 width=393) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
69. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190730 on dwp_events_20190730 de_60 (cost=0.44..6.21 rows=1 width=473) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
70. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190731 on dwp_events_20190731 de_61 (cost=0.44..6.21 rows=1 width=468) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
71. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190801 on dwp_events_20190801 de_62 (cost=0.44..6.21 rows=1 width=479) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
72. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190802 on dwp_events_20190802 de_63 (cost=0.44..6.21 rows=1 width=475) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
73. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190803 on dwp_events_20190803 de_64 (cost=0.43..6.21 rows=1 width=489) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
74. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190804 on dwp_events_20190804 de_65 (cost=0.43..6.21 rows=1 width=443) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
75. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190805 on dwp_events_20190805 de_66 (cost=0.43..6.21 rows=1 width=362) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
76. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190806 on dwp_events_20190806 de_67 (cost=0.43..6.21 rows=1 width=331) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
77. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190807 on dwp_events_20190807 de_68 (cost=0.43..6.21 rows=1 width=316) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
78. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190808 on dwp_events_20190808 de_69 (cost=0.43..6.21 rows=1 width=307) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
79. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190809 on dwp_events_20190809 de_70 (cost=0.43..6.21 rows=1 width=301) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
80. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190810 on dwp_events_20190810 de_71 (cost=0.43..6.21 rows=1 width=325) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
81. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190811 on dwp_events_20190811 de_72 (cost=0.43..6.21 rows=1 width=316) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
82. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190812 on dwp_events_20190812 de_73 (cost=0.43..6.21 rows=1 width=304) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
83. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190813 on dwp_events_20190813 de_74 (cost=0.43..6.21 rows=1 width=345) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
84. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190814 on dwp_events_20190814 de_75 (cost=0.43..6.21 rows=1 width=343) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
85. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190815 on dwp_events_20190815 de_76 (cost=0.43..6.21 rows=1 width=346) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
86. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190816 on dwp_events_20190816 de_77 (cost=0.43..6.21 rows=1 width=333) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
87. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190817 on dwp_events_20190817 de_78 (cost=0.43..6.21 rows=1 width=369) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
88. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190818 on dwp_events_20190818 de_79 (cost=0.43..6.21 rows=1 width=349) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
89. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190819 on dwp_events_20190819 de_80 (cost=0.43..6.21 rows=1 width=340) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
90. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190820 on dwp_events_20190820 de_81 (cost=0.43..6.21 rows=1 width=327) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
91. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190821 on dwp_events_20190821 de_82 (cost=0.43..6.21 rows=1 width=333) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
92. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190822 on dwp_events_20190822 de_83 (cost=0.43..6.21 rows=1 width=277) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
93. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190823 on dwp_events_20190823 de_84 (cost=0.56..6.34 rows=1 width=196) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
94. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190824 on dwp_events_20190824 de_85 (cost=0.57..6.34 rows=1 width=245) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
95. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190825 on dwp_events_20190825 de_86 (cost=0.44..6.21 rows=1 width=268) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
96. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190826 on dwp_events_20190826 de_87 (cost=0.43..6.21 rows=1 width=266) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
97. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190827 on dwp_events_20190827 de_88 (cost=0.43..6.21 rows=1 width=290) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
98. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190828 on dwp_events_20190828 de_89 (cost=0.43..6.21 rows=1 width=285) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
99. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190829 on dwp_events_20190829 de_90 (cost=0.43..6.21 rows=1 width=275) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
100. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190830 on dwp_events_20190830 de_91 (cost=0.43..6.21 rows=1 width=281) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
101. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190831 on dwp_events_20190831 de_92 (cost=0.43..6.21 rows=1 width=308) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
102. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190901 on dwp_events_20190901 de_93 (cost=0.43..6.21 rows=1 width=285) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
103. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190902 on dwp_events_20190902 de_94 (cost=0.43..6.21 rows=1 width=305) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
104. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190903 on dwp_events_20190903 de_95 (cost=0.43..6.21 rows=1 width=287) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
105. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190904 on dwp_events_20190904 de_96 (cost=0.43..6.21 rows=1 width=287) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
106. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190905 on dwp_events_20190905 de_97 (cost=0.43..6.21 rows=1 width=311) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
107. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190906 on dwp_events_20190906 de_98 (cost=0.43..6.21 rows=1 width=293) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
108. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_events_20190907 on dwp_events_20190907 de_99 (cost=0.43..6.20 rows=1 width=315) (actual rows= loops=)

  • Index Cond: (event_datetime >= (('now'::cstring)::date - 2))
  • Filter: ((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text)
109. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190908 de_100 (cost=0.00..99,268.07 rows=53 width=309) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
110. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190909 de_101 (cost=0.00..103,883.17 rows=60 width=291) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
111. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190910 de_102 (cost=0.00..79,289.87 rows=42 width=299) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
112. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190911 de_103 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
113. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190912 de_104 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
114. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190913 de_105 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
115. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190914 de_106 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
116. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190915 de_107 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
117. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190916 de_108 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
118. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190917 de_109 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
119. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190918 de_110 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
120. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190919 de_111 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
121. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190920 de_112 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
122. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190921 de_113 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
123. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190922 de_114 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
124. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190923 de_115 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
125. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190924 de_116 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
126. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190925 de_117 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
127. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190926 de_118 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
128. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190927 de_119 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
129. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190928 de_120 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
130. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190929 de_121 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
131. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20190930 de_122 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
132. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191001 de_123 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
133. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191002 de_124 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
134. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191003 de_125 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
135. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191004 de_126 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
136. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191005 de_127 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
137. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191006 de_128 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
138. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191007 de_129 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
139. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191008 de_130 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
140. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191009 de_131 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
141. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191010 de_132 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
142. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191011 de_133 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
143. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191012 de_134 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
144. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191013 de_135 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
145. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191014 de_136 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
146. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191015 de_137 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
147. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191016 de_138 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
148. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191017 de_139 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
149. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191018 de_140 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
150. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191019 de_141 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
151. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191020 de_142 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
152. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191021 de_143 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
153. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191022 de_144 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
154. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191023 de_145 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
155. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191024 de_146 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
156. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191025 de_147 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
157. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191026 de_148 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
158. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191027 de_149 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
159. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191028 de_150 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
160. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191029 de_151 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
161. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191030 de_152 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
162. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191031 de_153 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
163. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191101 de_154 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
164. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191102 de_155 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
165. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191103 de_156 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
166. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191104 de_157 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
167. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191105 de_158 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
168. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191106 de_159 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
169. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191107 de_160 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
170. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191108 de_161 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
171. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191109 de_162 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
172. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191110 de_163 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
173. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191111 de_164 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
174. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191112 de_165 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
175. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191113 de_166 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
176. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191114 de_167 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
177. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191115 de_168 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
178. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191116 de_169 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
179. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191117 de_170 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
180. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191118 de_171 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
181. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191119 de_172 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
182. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191120 de_173 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
183. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191121 de_174 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
184. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191122 de_175 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
185. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191123 de_176 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
186. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191124 de_177 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
187. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191125 de_178 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
188. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191126 de_179 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
189. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191127 de_180 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
190. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191128 de_181 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
191. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191129 de_182 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
192. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191130 de_183 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
193. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191201 de_184 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
194. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191202 de_185 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
195. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191203 de_186 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
196. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191204 de_187 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
197. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191205 de_188 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
198. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191206 de_189 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
199. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191207 de_190 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
200. 0.000 0.000 ↓ 0.0

Seq Scan on dwp_events_20191208 de_191 (cost=0.00..10.45 rows=1 width=556) (actual rows= loops=)

  • Filter: (((event_detail)::text ~~ '%data source com.amazon.dw.exec.redshift.extract.utils.db.DriverManagerDataSource returned a null connection%'::text) AND (event_datetime >= (('now'::cstring)::date - 2)))
201. 0.000 0.000 ↓ 0.0

Sort (cost=9,037.60..9,037.60 rows=1 width=88) (actual rows= loops=)

  • Sort Key: djr.job_run_id, djr.dataset_date, djr.hella_restart_count, djr.job_id, djr.interface_set_name, djr.restart_count, djr.start_datetime_utc, djr.end_datetime_utc, ((date_part('epoch'::text, ((timezone('UTC'::text, now()) - djr.end_datetime_utc) / '60'::double precision)))::numeric)
202. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.43..9,037.59 rows=1 width=88) (actual rows= loops=)

203. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.87..9,021.39 rows=2 width=61) (actual rows= loops=)

204. 0.000 0.000 ↓ 0.0

CTE Scan on error_job_runs (cost=0.00..10.64 rows=532 width=32) (actual rows= loops=)

205. 0.000 0.000 ↓ 0.0

Index Scan using i_dwp_jr_jrsi_jri on dwp_job_runs djr (cost=8.87..16.93 rows=1 width=61) (actual rows= loops=)

  • Index Cond: ((job_run_status_id = '7'::numeric) AND (job_run_id = error_job_runs.object_id))
  • Filter: ((NOT (hashed SubPlan 2)) AND (hella_restart_count < '2'::numeric) AND ((date_part('epoch'::text, ((timezone('UTC'::text, now()) - end_datetime_utc) / '60'::double precision)))::numeric > '15'::numeric) AND (COALESCE(end_datetime_utc, ((('now'::cstring)::date - 1))::timestamp without time zone) >= (('now'::cstring)::date - 2)))
206.          

SubPlan (forIndex Scan)

207. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_dwp_ldbi_sets on dwp_logical_db_interface_sets (cost=0.29..8.30 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (logical_db_name = 'L-DW'::text)
208. 0.000 0.000 ↓ 0.0

Index Scan using pk_dwp_jobs on dwp_jobs dj (cost=0.56..8.08 rows=1 width=11) (actual rows= loops=)

  • Index Cond: ((job_id = djr.job_id) AND (revision = djr.job_revision))
  • Filter: ((job_type_id = '2'::numeric) AND (group_id = ANY ('{11481,9962,10930,10497,9605,4232,5499,4033,4213,37607,9935}'::numeric[])))