explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BDw7

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

Gather Motion 36:1 (slice2; segments: 36) (cost=99,934,711.78..99,934,721.09 rows=532 width=4) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=99,934,711.78..99,934,721.09 rows=15 width=4) (actual rows= loops=)

  • Filter: count(partial_aggregation.unnamed_attr_2) = count(partial_aggregation.unnamed_attr_3)
  • Group By: public.email_sends.contact_id
3. 0.000 0.000 ↓ 0.0

Redistribute Motion 36:36 (slice1; segments: 36) (cost=99,934,691.83..99,934,702.47 rows=15 width=20) (actual rows= loops=)

  • Hash Key: public.email_sends.contact_id
4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=99,934,691.83..99,934,691.83 rows=15 width=20) (actual rows= loops=)

  • Group By: public.email_sends.contact_id
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=18,651,578.11..99,914,592.41 rows=74,443 width=12) (actual rows= loops=)

  • Hash Cond: public.email_sends.customer_id = public.email_bounces.customer_id AND public.email_sends.contact_id = public.email_bounces.contact_id AND public.email_sends.campaign_
6. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=17,135,866.36..98,351,981.14 rows=74,443 width=20) (actual rows= loops=)

  • Hash Cond: public.email_sends.customer_id = public.email_opens.customer_id AND public.email_sends.contact_id = public.email_opens.contact_id AND public.email_sends.campaig
7. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,843,053.34..83,010,802.97 rows=74,443 width=16) (actual rows= loops=)

  • Hash Cond: public.email_sends.customer_id = public.email_clicks.customer_id AND public.email_sends.contact_id = public.email_clicks.contact_id AND public.email_sends
8. 0.000 0.000 ↓ 0.0

Append (cost=0.00..81,119,958.56 rows=74,443 width=12) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201904_2_prt_new_customers email_sends (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
10. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201904_2_prt_cust_568212387 email_sends (cost=0.00..9,085,889.44 rows=277 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
11. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201905_2_prt_new_customers email_sends (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
12. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201905_2_prt_cust_642302316 email_sends (cost=0.00..8,466,273.32 rows=15,411 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
13. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201906_2_prt_new_customers email_sends (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
14. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201906_2_prt_cust_761675666 email_sends (cost=0.00..8,277,182.24 rows=14,006 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
15. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201907_2_prt_new_customers email_sends (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
16. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201907_2_prt_cust_564587584 email_sends (cost=0.00..11,662,220.28 rows=13,143 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
17. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201908_2_prt_new_customers email_sends (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
18. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201908_2_prt_cust_642302316 email_sends (cost=0.00..14,907,949.36 rows=13,593 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
19. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201909_2_prt_new_customers email_sends (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
20. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201909_2_prt_cust_634478958 email_sends (cost=0.00..15,669,362.28 rows=424 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
21. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201910_2_prt_new_customers email_sends (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
22. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201910_2_prt_cust_761519236 email_sends (cost=0.00..11,231,040.92 rows=15,076 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
23. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201911_2_prt_new_customers email_sends (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
24. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201911_2_prt_cust_642302316 email_sends (cost=0.00..1,820,032.72 rows=2,516 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
25. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201912_2_prt_new_customers email_sends (cost=0.00..0.00 rows=1 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
26. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_sends_1_prt_201912_2_prt_cust_568240518 email_sends (cost=0.00..0.00 rows=1 width=12) (actual rows= loops=)

  • Filter: customer_id = 765071141 AND campaign_id = 1579677 AND sent_at >= '2019-04-17 00:00:00'::timestamp without time zone
27. 0.000 0.000 ↓ 0.0

Hash (cost=1,827,661.83..1,827,661.83 rows=24,431 width=12) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1,827,661.83 rows=24,431 width=12) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201810_2_prt_new_customers email_clicks (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
30. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201810_2_prt_cust_765040446 email_clicks (cost=0.00..105,931.89 rows=5 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
31. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201811_2_prt_new_customers email_clicks (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
32. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201811_2_prt_cust_566084831 email_clicks (cost=0.00..164,038.92 rows=8 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
33. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201812_2_prt_new_customers email_clicks (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
34. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201812_2_prt_cust_645036652 email_clicks (cost=0.00..155,959.88 rows=8 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
35. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201901_2_prt_new_customers email_clicks (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
36. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201901_2_prt_cust_765040446 email_clicks (cost=0.00..136,323.76 rows=6 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
37. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201902_2_prt_new_customers email_clicks (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
38. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201902_2_prt_cust_761510329 email_clicks (cost=0.00..106,247.32 rows=5 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
39. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201903_2_prt_new_customers email_clicks (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
40. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201903_2_prt_cust_761102586 email_clicks (cost=0.00..135,996.98 rows=6 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
41. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201904_2_prt_new_customers email_clicks (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
42. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201904_2_prt_cust_765061515 email_clicks (cost=0.00..128,695.18 rows=1,123 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
43. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201905_2_prt_new_customers email_clicks (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
44. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201905_2_prt_cust_756014626 email_clicks (cost=0.00..138,177.93 rows=3,611 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
45. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201906_2_prt_new_customers email_clicks (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
46. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201906_2_prt_cust_761411830 email_clicks (cost=0.00..123,445.82 rows=3,107 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
47. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201907_2_prt_new_customers email_clicks (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
48. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201907_2_prt_cust_567142090 email_clicks (cost=0.00..148,964.98 rows=4,147 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
49. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201908_2_prt_new_customers email_clicks (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
50. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201908_2_prt_cust_634478958 email_clicks (cost=0.00..147,816.30 rows=4,132 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
51. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201909_2_prt_new_customers email_clicks (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
52. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201909_2_prt_cust_757394253 email_clicks (cost=0.00..142,334.39 rows=3,640 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
53. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201910_2_prt_new_customers email_clicks (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
54. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201910_2_prt_cust_757973993 email_clicks (cost=0.00..159,172.23 rows=4,106 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
55. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201911_2_prt_new_customers email_clicks (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
56. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201911_2_prt_cust_761278940 email_clicks (cost=0.00..34,542.26 rows=533 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
57. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201912_2_prt_new_customers email_clicks (cost=0.00..0.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
58. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_clicks_1_prt_201912_2_prt_cust_761008171 email_clicks (cost=0.00..0.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
59. 0.000 0.000 ↓ 0.0

Hash (cost=15,267,520.46..15,267,520.46 rows=40,147 width=13) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Append (cost=0.00..15,267,520.46 rows=40,147 width=13) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201810_2_prt_new_customers email_opens (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
62. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201810_2_prt_cust_765061258 email_opens (cost=0.00..899,691.71 rows=23 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
63. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201811_2_prt_new_customers email_opens (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
64. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201811_2_prt_cust_634478958 email_opens (cost=0.00..1,238,055.44 rows=39 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
65. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201812_2_prt_new_customers email_opens (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
66. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201812_2_prt_cust_758198156 email_opens (cost=0.00..992,116.70 rows=38 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
67. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201901_2_prt_new_customers email_opens (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
68. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201901_2_prt_cust_761359323 email_opens (cost=0.00..979,123.72 rows=29 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
69. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201902_2_prt_new_customers email_opens (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
70. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201902_2_prt_cust_761510329 email_opens (cost=0.00..960,630.58 rows=29 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
71. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201903_2_prt_new_customers email_opens (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
72. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201903_2_prt_cust_765015328 email_opens (cost=0.00..1,058,786.68 rows=33 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
73. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201904_2_prt_new_customers email_opens (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
74. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201904_2_prt_cust_634478958 email_opens (cost=0.00..1,169,165.72 rows=2,134 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
75. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201905_2_prt_new_customers email_opens (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
76. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201905_2_prt_cust_757973993 email_opens (cost=0.00..1,152,104.16 rows=6,635 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
77. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201906_2_prt_new_customers email_opens (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
78. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201906_2_prt_cust_761809283 email_opens (cost=0.00..988,040.70 rows=5,404 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
79. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201907_2_prt_new_customers email_opens (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
80. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201907_2_prt_cust_634478958 email_opens (cost=0.00..1,433,233.52 rows=5,567 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
81. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201908_2_prt_new_customers email_opens (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
82. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201908_2_prt_cust_634478958 email_opens (cost=0.00..1,704,612.96 rows=6,084 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
83. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201909_2_prt_new_customers email_opens (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
84. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201909_2_prt_cust_761359323 email_opens (cost=0.00..1,261,188.92 rows=6,386 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
85. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201910_2_prt_new_customers email_opens (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
86. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201910_2_prt_cust_757973993 email_opens (cost=0.00..1,111,058.88 rows=6,883 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
87. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201911_2_prt_new_customers email_opens (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
88. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201911_2_prt_cust_758085548 email_opens (cost=0.00..319,696.77 rows=872 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
89. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201912_2_prt_new_customers email_opens (cost=0.00..0.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
90. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_opens_1_prt_201912_2_prt_cust_765002699 email_opens (cost=0.00..0.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
91. 0.000 0.000 ↓ 0.0

Hash (cost=1,515,696.91..1,515,696.91 rows=24 width=13) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1,515,696.91 rows=24 width=13) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201810_2_prt_new_customers email_bounces (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
94. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201810_2_prt_cust_594907796 email_bounces (cost=0.00..94,407.43 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
95. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201811_2_prt_new_customers email_bounces (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
96. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201811_2_prt_cust_594907796 email_bounces (cost=0.00..139,486.90 rows=3 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
97. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201812_2_prt_new_customers email_bounces (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
98. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201812_2_prt_cust_761519236 email_bounces (cost=0.00..28,189.13 rows=3 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
99. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201901_2_prt_new_customers email_bounces (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
100. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201901_2_prt_cust_634478958 email_bounces (cost=0.00..60,374.35 rows=2 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
101. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201902_2_prt_new_customers email_bounces (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
102. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201902_2_prt_cust_634478958 email_bounces (cost=0.00..107,174.22 rows=2 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
103. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201903_2_prt_new_customers email_bounces (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
104. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201903_2_prt_cust_567946104 email_bounces (cost=0.00..76,796.54 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
105. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201904_2_prt_new_customers email_bounces (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
106. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201904_2_prt_cust_634478958 email_bounces (cost=0.00..80,621.72 rows=4 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
107. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201905_2_prt_new_customers email_bounces (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
108. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201905_2_prt_cust_634478958 email_bounces (cost=0.00..76,134.50 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
109. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201906_2_prt_new_customers email_bounces (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
110. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201906_2_prt_cust_634478958 email_bounces (cost=0.00..136,596.30 rows=5 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
111. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201907_2_prt_new_customers email_bounces (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
112. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201907_2_prt_cust_634478958 email_bounces (cost=0.00..149,264.33 rows=2 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
113. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201908_2_prt_new_customers email_bounces (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
114. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201908_2_prt_cust_761628014 email_bounces (cost=0.00..130,015.12 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
115. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201909_2_prt_new_customers email_bounces (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
116. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201909_2_prt_cust_761628014 email_bounces (cost=0.00..194,869.56 rows=2 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
117. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201910_2_prt_new_customers email_bounces (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
118. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201910_2_prt_cust_634478958 email_bounces (cost=0.00..205,838.95 rows=2 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
119. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201911_2_prt_new_customers email_bounces (cost=0.00..1.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
120. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201911_2_prt_cust_761510329 email_bounces (cost=0.00..35,913.83 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
121. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201912_2_prt_new_customers email_bounces (cost=0.00..0.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141
122. 0.000 0.000 ↓ 0.0

Append-only Columnar Scan on email_bounces_1_prt_201912_2_prt_cust_761628014 email_bounces (cost=0.00..0.00 rows=1 width=12) (actual rows= loops=)

  • Filter: campaign_id = 1579677 AND customer_id = 765071141