explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h9ud

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 7,663.599 ↓ 0.0 0 1

Hash Join (cost=10,157.91..19,007.90 rows=527 width=133) (actual time=7,663.599..7,663.599 rows=0 loops=1)

  • Hash Cond: (dn.notification_uuid = ln.notification_uuid)
2.          

CTE get_event

3. 571.810 680.417 ↑ 586.0 1 1

Bitmap Heap Scan on events_org_part_140 e (cost=33.12..1,284.90 rows=586 width=106) (actual time=680.416..680.417 rows=1 loops=1)

  • Recheck Cond: (event_uuid = '170321c8-cfaf-462c-8e0b-91d5046f69be'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid))
  • Rows Removed by Filter: 1758
  • Heap Blocks: exact=804
4. 108.607 108.607 ↑ 1.0 1,759 1

Bitmap Index Scan on events_org_part_140_event_uuid_idx1 (cost=0.00..32.98 rows=1,759 width=0) (actual time=108.607..108.607 rows=1,759 loops=1)

  • Index Cond: (event_uuid = '170321c8-cfaf-462c-8e0b-91d5046f69be'::uuid)
5.          

CTE get_event_created_min

6. 0.004 0.005 ↑ 1.0 1 1

Aggregate (cost=13.19..13.20 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=1)

7. 0.001 0.001 ↑ 586.0 1 1

CTE Scan on get_event e_1 (cost=0.00..11.72 rows=586 width=8) (actual time=0.001..0.001 rows=1 loops=1)

8.          

CTE get_event_closing_max

9. 0.029 680.453 ↑ 1.0 1 1

Aggregate (cost=17.58..17.59 rows=1 width=8) (actual time=680.453..680.453 rows=1 loops=1)

10. 680.424 680.424 ↑ 586.0 1 1

CTE Scan on get_event e_2 (cost=0.00..11.72 rows=586 width=16) (actual time=680.422..680.424 rows=1 loops=1)

11.          

Initplan (for Hash Join)

12. 680.457 680.457 ↑ 1.0 1 1

CTE Scan on get_event_closing_max e_3 (cost=0.00..0.02 rows=1 width=8) (actual time=680.456..680.457 rows=1 loops=1)

13. 0.006 0.006 ↑ 1.0 1 1

CTE Scan on get_event_created_min (cost=0.00..0.02 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=1)

14. 0.004 0.004 ↑ 1.0 1 1

CTE Scan on get_event_closing_max e_4 (cost=0.00..0.02 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=1)

15. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event_created_min get_event_created_min_1 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

16. 681.205 762.488 ↓ 18.5 8,862 1

Append (cost=0.56..8,817.74 rows=479 width=124) (actual time=741.745..762.488 rows=8,862 loops=1)

17. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient_u_idx on notifications_summary_weekly_partitioned_2019_w5 dn (cost=0.56..452.91 rows=26 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
18. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx1 on notifications_summary_weekly_partitioned_2019_w6 dn_1 (cost=0.56..115.83 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx2 on notifications_summary_weekly_partitioned_2019_w7 dn_2 (cost=0.56..96.32 rows=6 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx3 on notifications_summary_weekly_partitioned_2019_w8 dn_3 (cost=0.56..107.95 rows=6 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx4 on notifications_summary_weekly_partitioned_2019_w9 dn_4 (cost=0.56..120.85 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx5 on notifications_summary_weekly_partitioned_2019_w10 dn_5 (cost=0.56..111.64 rows=6 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
23. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx6 on notifications_summary_weekly_partitioned_2019_w11 dn_6 (cost=0.56..127.09 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
24. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx7 on notifications_summary_weekly_partitioned_2019_w12 dn_7 (cost=0.56..104.04 rows=6 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
25. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx8 on notifications_summary_weekly_partitioned_2019_w13 dn_8 (cost=0.56..473.27 rows=26 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
26. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx9 on notifications_summary_weekly_partitioned_2019_w14 dn_9 (cost=0.56..108.05 rows=6 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
27. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx10 on notifications_summary_weekly_partitioned_2019_w15 dn_10 (cost=0.56..121.55 rows=6 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
28. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w16_pkey on notifications_summary_weekly_partitioned_2019_w16 dn_11 (cost=0.56..129.64 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
29. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx12 on notifications_summary_weekly_partitioned_2019_w17 dn_12 (cost=0.56..126.83 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
30. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w18_pkey on notifications_summary_weekly_partitioned_2019_w18 dn_13 (cost=0.56..136.08 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
31. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx14 on notifications_summary_weekly_partitioned_2019_w19 dn_14 (cost=0.56..126.50 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
32. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w20_pkey on notifications_summary_weekly_partitioned_2019_w20 dn_15 (cost=0.56..148.05 rows=8 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
33. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx16 on notifications_summary_weekly_partitioned_2019_w21 dn_16 (cost=0.56..149.99 rows=8 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
34. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w22_pkey on notifications_summary_weekly_partitioned_2019_w22 dn_17 (cost=0.56..151.36 rows=8 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
35. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w23_pkey on notifications_summary_weekly_partitioned_2019_w23 dn_18 (cost=0.56..143.13 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
36. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx19 on notifications_summary_weekly_partitioned_2019_w24 dn_19 (cost=0.56..141.06 rows=8 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
37. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w25_pkey on notifications_summary_weekly_partitioned_2019_w25 dn_20 (cost=0.56..147.12 rows=8 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
38. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx21 on notifications_summary_weekly_partitioned_2019_w26 dn_21 (cost=0.56..148.12 rows=8 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
39. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w27_pkey on notifications_summary_weekly_partitioned_2019_w27 dn_22 (cost=0.56..121.27 rows=6 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
40. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w28_pkey on notifications_summary_weekly_partitioned_2019_w28 dn_23 (cost=0.56..118.54 rows=6 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
41. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w29_pkey on notifications_summary_weekly_partitioned_2019_w29 dn_24 (cost=0.56..151.23 rows=8 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
42. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx25 on notifications_summary_weekly_partitioned_2019_w30 dn_25 (cost=0.56..147.76 rows=8 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
43. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w31_pkey on notifications_summary_weekly_partitioned_2019_w31 dn_26 (cost=0.56..103.24 rows=5 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
44. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx27 on notifications_summary_weekly_partitioned_2019_w32 dn_27 (cost=0.56..130.05 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
45. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w33_pkey on notifications_summary_weekly_partitioned_2019_w33 dn_28 (cost=0.56..81.44 rows=4 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
46. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx29 on notifications_summary_weekly_partitioned_2019_w34 dn_29 (cost=0.56..60.00 rows=3 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
47. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx30 on notifications_summary_weekly_partitioned_2019_w35 dn_30 (cost=0.56..135.38 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
48. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx31 on notifications_summary_weekly_partitioned_2019_w36 dn_31 (cost=0.56..134.07 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
49. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx32 on notifications_summary_weekly_partitioned_2019_w37 dn_32 (cost=0.56..144.44 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
50. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx33 on notifications_summary_weekly_partitioned_2019_w38 dn_33 (cost=0.56..148.71 rows=8 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
51. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx34 on notifications_summary_weekly_partitioned_2019_w39 dn_34 (cost=0.56..149.42 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
52. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx35 on notifications_summary_weekly_partitioned_2019_w40 dn_35 (cost=0.56..145.99 rows=6 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
53. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx36 on notifications_summary_weekly_partitioned_2019_w41 dn_36 (cost=0.56..158.82 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
54. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w42_pkey on notifications_summary_weekly_partitioned_2019_w42 dn_37 (cost=0.56..163.24 rows=7 width=112) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
55. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx38 on notifications_summary_weekly_partitioned_2019_w43 dn_38 (cost=0.56..154.40 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
56. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx39 on notifications_summary_weekly_partitioned_2019_w44 dn_39 (cost=0.56..171.84 rows=8 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
57. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx40 on notifications_summary_weekly_partitioned_2019_w45 dn_40 (cost=0.56..136.23 rows=6 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
58. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx41 on notifications_summary_weekly_partitioned_2019_w46 dn_41 (cost=0.56..158.88 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
59. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx42 on notifications_summary_weekly_partitioned_2019_w47 dn_42 (cost=0.56..176.94 rows=8 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
60. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx43 on notifications_summary_weekly_partitioned_2019_w48 dn_43 (cost=0.56..138.28 rows=6 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
61. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx44 on notifications_summary_weekly_partitioned_2019_w49 dn_44 (cost=0.56..142.36 rows=6 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
62. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx45 on notifications_summary_weekly_partitioned_2019_w50 dn_45 (cost=0.56..145.54 rows=6 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
63. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx46 on notifications_summary_weekly_partitioned_2019_w51 dn_46 (cost=0.56..150.91 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
64. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx47 on notifications_summary_weekly_partitioned_2019_w52 dn_47 (cost=0.56..104.92 rows=5 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
65. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx49 on notifications_summary_weekly_partitioned_2020_w1 dn_48 (cost=0.56..109.79 rows=5 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
66. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx50 on notifications_summary_weekly_partitioned_2020_w2 dn_49 (cost=0.56..135.06 rows=6 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
67. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx51 on notifications_summary_weekly_partitioned_2020_w3 dn_50 (cost=0.56..140.94 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
68. 81.283 81.283 ↓ 206.1 8,862 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx52 on notifications_summary_weekly_partitioned_2020_w4 dn_51 (cost=0.56..949.12 rows=43 width=111) (actual time=61.260..81.283 rows=8,862 loops=1)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
  • Rows Removed by Filter: 11535
69. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w5_pkey on notifications_summary_weekly_partitioned_2020_w5 dn_52 (cost=0.56..160.34 rows=6 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
70. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w6_pkey on notifications_summary_weekly_partitioned_2020_w6 dn_53 (cost=0.56..109.82 rows=4 width=111) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
71. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w7_pkey on notifications_summary_weekly_partitioned_2020_w7 dn_54 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
72. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w8_pkey on notifications_summary_weekly_partitioned_2020_w8 dn_55 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
73. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w9_pkey on notifications_summary_weekly_partitioned_2020_w9 dn_56 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
74. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w10_pkey on notifications_summary_weekly_partitioned_2020_w10 dn_57 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
75. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w11_pkey on notifications_summary_weekly_partitioned_2020_w11 dn_58 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
76. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w12_pkey on notifications_summary_weekly_partitioned_2020_w12 dn_59 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
77. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w13_pkey on notifications_summary_weekly_partitioned_2020_w13 dn_60 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
78. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w14_pkey on notifications_summary_weekly_partitioned_2020_w14 dn_61 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
79. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w15_pkey on notifications_summary_weekly_partitioned_2020_w15 dn_62 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
80. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w16_pkey on notifications_summary_weekly_partitioned_2020_w16 dn_63 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
81. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w17_pkey on notifications_summary_weekly_partitioned_2020_w17 dn_64 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
82. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w18_pkey on notifications_summary_weekly_partitioned_2020_w18 dn_65 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
83. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w19_pkey on notifications_summary_weekly_partitioned_2020_w19 dn_66 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
84. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w20_pkey on notifications_summary_weekly_partitioned_2020_w20 dn_67 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
85. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w21_pkey on notifications_summary_weekly_partitioned_2020_w21 dn_68 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
86. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w22_pkey on notifications_summary_weekly_partitioned_2020_w22 dn_69 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
87. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w23_pkey on notifications_summary_weekly_partitioned_2020_w23 dn_70 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
88. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w24_pkey on notifications_summary_weekly_partitioned_2020_w24 dn_71 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
89. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w25_pkey on notifications_summary_weekly_partitioned_2020_w25 dn_72 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
90. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w26_pkey on notifications_summary_weekly_partitioned_2020_w26 dn_73 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
91. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w27_pkey on notifications_summary_weekly_partitioned_2020_w27 dn_74 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
92. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w28_pkey on notifications_summary_weekly_partitioned_2020_w28 dn_75 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
93. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w29_pkey on notifications_summary_weekly_partitioned_2020_w29 dn_76 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
94. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w30_pkey on notifications_summary_weekly_partitioned_2020_w30 dn_77 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
95. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w31_pkey on notifications_summary_weekly_partitioned_2020_w31 dn_78 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
96. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w32_pkey on notifications_summary_weekly_partitioned_2020_w32 dn_79 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
97. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w33_pkey on notifications_summary_weekly_partitioned_2020_w33 dn_80 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
98. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w34_pkey on notifications_summary_weekly_partitioned_2020_w34 dn_81 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
99. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w35_pkey on notifications_summary_weekly_partitioned_2020_w35 dn_82 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
100. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w36_pkey on notifications_summary_weekly_partitioned_2020_w36 dn_83 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
101. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w37_pkey on notifications_summary_weekly_partitioned_2020_w37 dn_84 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
102. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w38_pkey on notifications_summary_weekly_partitioned_2020_w38 dn_85 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
103. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w39_pkey on notifications_summary_weekly_partitioned_2020_w39 dn_86 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
104. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w40_pkey on notifications_summary_weekly_partitioned_2020_w40 dn_87 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
105. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w41_pkey on notifications_summary_weekly_partitioned_2020_w41 dn_88 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
106. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w42_pkey on notifications_summary_weekly_partitioned_2020_w42 dn_89 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
107. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w43_pkey on notifications_summary_weekly_partitioned_2020_w43 dn_90 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
108. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w44_pkey on notifications_summary_weekly_partitioned_2020_w44 dn_91 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
109. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w45_pkey on notifications_summary_weekly_partitioned_2020_w45 dn_92 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
110. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w46_pkey on notifications_summary_weekly_partitioned_2020_w46 dn_93 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
111. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w47_pkey on notifications_summary_weekly_partitioned_2020_w47 dn_94 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
112. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w48_pkey on notifications_summary_weekly_partitioned_2020_w48 dn_95 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
113. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w49_pkey on notifications_summary_weekly_partitioned_2020_w49 dn_96 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
114. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w50_pkey on notifications_summary_weekly_partitioned_2020_w50 dn_97 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
115. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w51_pkey on notifications_summary_weekly_partitioned_2020_w51 dn_98 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
116. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w52_pkey on notifications_summary_weekly_partitioned_2020_w52 dn_99 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
117. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_part_default_pkey on notifications_summary_weekly_part_default dn_100 (cost=0.14..3.17 rows=1 width=246) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'DEVICE'::text)
118. 2.721 6,899.212 ↓ 39.0 8,573 1

Hash (cost=8,838.83..8,838.83 rows=220 width=24) (actual time=6,899.212..6,899.212 rows=8,573 loops=1)

  • Buckets: 16384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 597kB
119. 2.449 6,896.491 ↓ 39.0 8,573 1

Hash Join (cost=18.25..8,838.83 rows=220 width=24) (actual time=5,650.125..6,896.491 rows=8,573 loops=1)

  • Hash Cond: (ln.event_uuid = get_event.event_uuid)
120. 0.934 6,894.021 ↓ 20.0 8,820 1

Append (cost=0.56..8,817.54 rows=440 width=40) (actual time=5,650.052..6,894.021 rows=8,820 loops=1)

121. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient_u_idx on notifications_summary_weekly_partitioned_2019_w5 ln (cost=0.56..452.91 rows=24 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
122. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx1 on notifications_summary_weekly_partitioned_2019_w6 ln_1 (cost=0.56..115.83 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
123. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx2 on notifications_summary_weekly_partitioned_2019_w7 ln_2 (cost=0.56..96.32 rows=5 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
124. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx3 on notifications_summary_weekly_partitioned_2019_w8 ln_3 (cost=0.56..107.95 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
125. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx4 on notifications_summary_weekly_partitioned_2019_w9 ln_4 (cost=0.56..120.85 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
126. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx5 on notifications_summary_weekly_partitioned_2019_w10 ln_5 (cost=0.56..111.64 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
127. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx6 on notifications_summary_weekly_partitioned_2019_w11 ln_6 (cost=0.56..127.09 rows=7 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
128. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx7 on notifications_summary_weekly_partitioned_2019_w12 ln_7 (cost=0.56..104.04 rows=5 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
129. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx8 on notifications_summary_weekly_partitioned_2019_w13 ln_8 (cost=0.56..473.27 rows=24 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
130. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx9 on notifications_summary_weekly_partitioned_2019_w14 ln_9 (cost=0.56..108.05 rows=5 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
131. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx10 on notifications_summary_weekly_partitioned_2019_w15 ln_10 (cost=0.56..121.55 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
132. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w16_pkey on notifications_summary_weekly_partitioned_2019_w16 ln_11 (cost=0.56..129.64 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
133. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx12 on notifications_summary_weekly_partitioned_2019_w17 ln_12 (cost=0.56..126.83 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
134. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w18_pkey on notifications_summary_weekly_partitioned_2019_w18 ln_13 (cost=0.56..136.08 rows=7 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
135. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx14 on notifications_summary_weekly_partitioned_2019_w19 ln_14 (cost=0.56..126.50 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
136. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w20_pkey on notifications_summary_weekly_partitioned_2019_w20 ln_15 (cost=0.56..148.05 rows=7 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
137. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx16 on notifications_summary_weekly_partitioned_2019_w21 ln_16 (cost=0.56..149.99 rows=7 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
138. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w22_pkey on notifications_summary_weekly_partitioned_2019_w22 ln_17 (cost=0.56..151.36 rows=7 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
139. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w23_pkey on notifications_summary_weekly_partitioned_2019_w23 ln_18 (cost=0.56..143.13 rows=7 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
140. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx19 on notifications_summary_weekly_partitioned_2019_w24 ln_19 (cost=0.56..141.06 rows=7 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
141. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w25_pkey on notifications_summary_weekly_partitioned_2019_w25 ln_20 (cost=0.56..147.12 rows=7 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
142. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx21 on notifications_summary_weekly_partitioned_2019_w26 ln_21 (cost=0.56..148.12 rows=7 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
143. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w27_pkey on notifications_summary_weekly_partitioned_2019_w27 ln_22 (cost=0.56..121.27 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
144. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w28_pkey on notifications_summary_weekly_partitioned_2019_w28 ln_23 (cost=0.56..118.54 rows=5 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
145. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w29_pkey on notifications_summary_weekly_partitioned_2019_w29 ln_24 (cost=0.56..151.23 rows=7 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
146. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx25 on notifications_summary_weekly_partitioned_2019_w30 ln_25 (cost=0.56..147.76 rows=7 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
147. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w31_pkey on notifications_summary_weekly_partitioned_2019_w31 ln_26 (cost=0.56..103.24 rows=5 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
148. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx27 on notifications_summary_weekly_partitioned_2019_w32 ln_27 (cost=0.56..130.05 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
149. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w33_pkey on notifications_summary_weekly_partitioned_2019_w33 ln_28 (cost=0.56..81.44 rows=4 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
150. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx29 on notifications_summary_weekly_partitioned_2019_w34 ln_29 (cost=0.56..60.00 rows=3 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
151. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx30 on notifications_summary_weekly_partitioned_2019_w35 ln_30 (cost=0.56..135.38 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
152. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx31 on notifications_summary_weekly_partitioned_2019_w36 ln_31 (cost=0.56..134.07 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
153. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx32 on notifications_summary_weekly_partitioned_2019_w37 ln_32 (cost=0.56..144.44 rows=7 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
154. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx33 on notifications_summary_weekly_partitioned_2019_w38 ln_33 (cost=0.56..148.71 rows=7 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
155. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx34 on notifications_summary_weekly_partitioned_2019_w39 ln_34 (cost=0.56..149.42 rows=7 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
156. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx35 on notifications_summary_weekly_partitioned_2019_w40 ln_35 (cost=0.56..145.99 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
157. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx36 on notifications_summary_weekly_partitioned_2019_w41 ln_36 (cost=0.56..158.82 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
158. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w42_pkey on notifications_summary_weekly_partitioned_2019_w42 ln_37 (cost=0.56..163.24 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
159. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx38 on notifications_summary_weekly_partitioned_2019_w43 ln_38 (cost=0.56..154.40 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
160. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx39 on notifications_summary_weekly_partitioned_2019_w44 ln_39 (cost=0.56..171.84 rows=7 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
161. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx40 on notifications_summary_weekly_partitioned_2019_w45 ln_40 (cost=0.56..136.23 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
162. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx41 on notifications_summary_weekly_partitioned_2019_w46 ln_41 (cost=0.56..158.88 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
163. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx42 on notifications_summary_weekly_partitioned_2019_w47 ln_42 (cost=0.56..176.94 rows=7 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
164. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx43 on notifications_summary_weekly_partitioned_2019_w48 ln_43 (cost=0.56..138.28 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
165. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx44 on notifications_summary_weekly_partitioned_2019_w49 ln_44 (cost=0.56..142.36 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
166. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx45 on notifications_summary_weekly_partitioned_2019_w50 ln_45 (cost=0.56..145.54 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
167. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx46 on notifications_summary_weekly_partitioned_2019_w51 ln_46 (cost=0.56..150.91 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
168. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx47 on notifications_summary_weekly_partitioned_2019_w52 ln_47 (cost=0.56..104.92 rows=4 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
169. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx49 on notifications_summary_weekly_partitioned_2020_w1 ln_48 (cost=0.56..109.79 rows=4 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
170. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx50 on notifications_summary_weekly_partitioned_2020_w2 ln_49 (cost=0.56..135.06 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
171. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx51 on notifications_summary_weekly_partitioned_2020_w3 ln_50 (cost=0.56..140.94 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
172. 6,893.087 6,893.087 ↓ 226.2 8,820 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx52 on notifications_summary_weekly_partitioned_2020_w4 ln_51 (cost=0.56..949.12 rows=39 width=40) (actual time=5,650.031..6,893.087 rows=8,820 loops=1)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
  • Rows Removed by Filter: 11577
173. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w5_pkey on notifications_summary_weekly_partitioned_2020_w5 ln_52 (cost=0.56..160.34 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
174. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w6_pkey on notifications_summary_weekly_partitioned_2020_w6 ln_53 (cost=0.56..109.82 rows=4 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'LIVE'::text)
175. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx55 on notifications_summary_weekly_partitioned_2020_w7 ln_54 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
176. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx56 on notifications_summary_weekly_partitioned_2020_w8 ln_55 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
177. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx57 on notifications_summary_weekly_partitioned_2020_w9 ln_56 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
178. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx58 on notifications_summary_weekly_partitioned_2020_w10 ln_57 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
179. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx59 on notifications_summary_weekly_partitioned_2020_w11 ln_58 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
180. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx60 on notifications_summary_weekly_partitioned_2020_w12 ln_59 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
181. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx61 on notifications_summary_weekly_partitioned_2020_w13 ln_60 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
182. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx62 on notifications_summary_weekly_partitioned_2020_w14 ln_61 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
183. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx63 on notifications_summary_weekly_partitioned_2020_w15 ln_62 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
184. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx64 on notifications_summary_weekly_partitioned_2020_w16 ln_63 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
185. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx65 on notifications_summary_weekly_partitioned_2020_w17 ln_64 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
186. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx66 on notifications_summary_weekly_partitioned_2020_w18 ln_65 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
187. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx67 on notifications_summary_weekly_partitioned_2020_w19 ln_66 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
188. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx68 on notifications_summary_weekly_partitioned_2020_w20 ln_67 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
189. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx69 on notifications_summary_weekly_partitioned_2020_w21 ln_68 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
190. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx70 on notifications_summary_weekly_partitioned_2020_w22 ln_69 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
191. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx71 on notifications_summary_weekly_partitioned_2020_w23 ln_70 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
192. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx72 on notifications_summary_weekly_partitioned_2020_w24 ln_71 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
193. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx73 on notifications_summary_weekly_partitioned_2020_w25 ln_72 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
194. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx74 on notifications_summary_weekly_partitioned_2020_w26 ln_73 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
195. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx75 on notifications_summary_weekly_partitioned_2020_w27 ln_74 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
196. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx76 on notifications_summary_weekly_partitioned_2020_w28 ln_75 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
197. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx77 on notifications_summary_weekly_partitioned_2020_w29 ln_76 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
198. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx78 on notifications_summary_weekly_partitioned_2020_w30 ln_77 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
199. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx79 on notifications_summary_weekly_partitioned_2020_w31 ln_78 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
200. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx80 on notifications_summary_weekly_partitioned_2020_w32 ln_79 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
201. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx81 on notifications_summary_weekly_partitioned_2020_w33 ln_80 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
202. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx82 on notifications_summary_weekly_partitioned_2020_w34 ln_81 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
203. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx83 on notifications_summary_weekly_partitioned_2020_w35 ln_82 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
204. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx84 on notifications_summary_weekly_partitioned_2020_w36 ln_83 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
205. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx85 on notifications_summary_weekly_partitioned_2020_w37 ln_84 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
206. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx86 on notifications_summary_weekly_partitioned_2020_w38 ln_85 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
207. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx87 on notifications_summary_weekly_partitioned_2020_w39 ln_86 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
208. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx88 on notifications_summary_weekly_partitioned_2020_w40 ln_87 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
209. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx89 on notifications_summary_weekly_partitioned_2020_w41 ln_88 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
210. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx90 on notifications_summary_weekly_partitioned_2020_w42 ln_89 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
211. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx91 on notifications_summary_weekly_partitioned_2020_w43 ln_90 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
212. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx92 on notifications_summary_weekly_partitioned_2020_w44 ln_91 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
213. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx93 on notifications_summary_weekly_partitioned_2020_w45 ln_92 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
214. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx94 on notifications_summary_weekly_partitioned_2020_w46 ln_93 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
215. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx95 on notifications_summary_weekly_partitioned_2020_w47 ln_94 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
216. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx96 on notifications_summary_weekly_partitioned_2020_w48 ln_95 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
217. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx97 on notifications_summary_weekly_partitioned_2020_w49 ln_96 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
218. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx98 on notifications_summary_weekly_partitioned_2020_w50 ln_97 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
219. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx99 on notifications_summary_weekly_partitioned_2020_w51 ln_98 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
220. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uui_idx100 on notifications_summary_weekly_partitioned_2020_w52 ln_99 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
221. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx53 on notifications_summary_weekly_part_default ln_100 (cost=0.14..3.17 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $5) AND (created_date >= $6) AND (category = 'LIVE'::text))
222. 0.005 0.021 ↑ 200.0 1 1

Hash (cost=15.19..15.19 rows=200 width=16) (actual time=0.021..0.021 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
223. 0.010 0.016 ↑ 200.0 1 1

HashAggregate (cost=13.19..15.19 rows=200 width=16) (actual time=0.014..0.016 rows=1 loops=1)

  • Group Key: get_event.event_uuid
224. 0.006 0.006 ↑ 586.0 1 1

CTE Scan on get_event (cost=0.00..11.72 rows=586 width=16) (actual time=0.005..0.006 rows=1 loops=1)

Planning time : 1,602.789 ms
Execution time : 7,669.927 ms