explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k9dq

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,828.669 ↑ 9.0 1,062 1

Sort (cost=3,762.34..3,786.16 rows=9,528 width=168) (actual time=2,828.568..2,828.669 rows=1,062 loops=1)

  • Sort Key: pn.recipient_uuid
  • Sort Method: quicksort Memory: 331kB
2.          

CTE get_event

3. 7.937 7.937 ↑ 2.0 1 1

Index Scan using events_org_part_57_event_uuid_idx1 on events_org_part_57 e (cost=0.42..11.05 rows=2 width=795) (actual time=0.184..7.937 rows=1 loops=1)

  • Index Cond: (event_uuid = '555c0aa7-4150-48ed-9441-b585b9133445'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid))
  • Rows Removed by Filter: 776
4.          

CTE get_event_created_min

5. 0.005 0.006 ↑ 1.0 1 1

Aggregate (cost=0.04..0.06 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=1)

6. 0.001 0.001 ↑ 2.0 1 1

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

7.          

CTE get_event_closing_max

8. 0.016 7.958 ↑ 1.0 1 1

Aggregate (cost=0.06..0.07 rows=1 width=8) (actual time=7.958..7.958 rows=1 loops=1)

9. 7.942 7.942 ↑ 2.0 1 1

CTE Scan on get_event e_2 (cost=0.00..0.04 rows=2 width=16) (actual time=0.188..7.942 rows=1 loops=1)

10.          

Initplan (for Sort)

11. 0.001 0.001 ↑ 2.0 1 1

CTE Scan on get_event (cost=0.00..0.04 rows=2 width=16) (actual time=0.001..0.001 rows=1 loops=1)

12. 7.964 7.964 ↑ 1.0 1 1

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

13. 0.014 0.014 ↑ 1.0 1 1

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

14. 1.176 2,826.912 ↑ 9.0 1,062 1

Nested Loop Left Join (cost=2,035.61..3,121.38 rows=9,528 width=168) (actual time=2,816.749..2,826.912 rows=1,062 loops=1)

  • Join Filter: (pn.responded_date <= (now())::timestamp without time zone)
  • Filter: ((dn.parent_ntfn_uuid IS NOT NULL) OR (CASE WHEN (pn.failed_date <= now()) THEN pn.failed_date ELSE NULL::timestamp with time zone END IS NOT NULL) OR (CASE WHEN (r.received <= now()) THEN pn.responded_date ELSE NULL::timestamp with time zone END IS NOT NULL))
15. 0.746 2,821.488 ↓ 10.5 1,062 1

Merge Left Join (cost=2,035.19..2,396.53 rows=101 width=160) (actual time=2,816.671..2,821.488 rows=1,062 loops=1)

  • Merge Cond: (pn.notification_uuid = dn.parent_ntfn_uuid)
16. 2.608 2,758.732 ↓ 10.5 1,062 1

Sort (cost=355.56..355.81 rows=101 width=72) (actual time=2,758.512..2,758.732 rows=1,062 loops=1)

  • Sort Key: pn.notification_uuid
  • Sort Method: quicksort Memory: 198kB
17. 8.372 2,756.124 ↓ 10.5 1,062 1

Append (cost=0.56..352.20 rows=101 width=72) (actual time=8.153..2,756.124 rows=1,062 loops=1)

18. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx5 on notifications_summary_weekly_partitioned_2019_w5 pn (cost=0.56..4.28 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
19. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx6 on notifications_summary_weekly_partitioned_2019_w6 pn_1 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
20. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx7 on notifications_summary_weekly_partitioned_2019_w7 pn_2 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
21. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx8 on notifications_summary_weekly_partitioned_2019_w8 pn_3 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
22. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx9 on notifications_summary_weekly_partitioned_2019_w9 pn_4 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
23. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx10 on notifications_summary_weekly_partitioned_2019_w10 pn_5 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
24. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx11 on notifications_summary_weekly_partitioned_2019_w11 pn_6 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
25. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx12 on notifications_summary_weekly_partitioned_2019_w12 pn_7 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
26. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx13 on notifications_summary_weekly_partitioned_2019_w13 pn_8 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
27. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx14 on notifications_summary_weekly_partitioned_2019_w14 pn_9 (cost=0.56..5.66 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
28. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx15 on notifications_summary_weekly_partitioned_2019_w15 pn_10 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
29. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx16 on notifications_summary_weekly_partitioned_2019_w16 pn_11 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
30. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx17 on notifications_summary_weekly_partitioned_2019_w17 pn_12 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
31. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx18 on notifications_summary_weekly_partitioned_2019_w18 pn_13 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
32. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx19 on notifications_summary_weekly_partitioned_2019_w19 pn_14 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
33. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx20 on notifications_summary_weekly_partitioned_2019_w20 pn_15 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
34. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx21 on notifications_summary_weekly_partitioned_2019_w21 pn_16 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
35. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx22 on notifications_summary_weekly_partitioned_2019_w22 pn_17 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
36. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx23 on notifications_summary_weekly_partitioned_2019_w23 pn_18 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
37. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx24 on notifications_summary_weekly_partitioned_2019_w24 pn_19 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
38. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx25 on notifications_summary_weekly_partitioned_2019_w25 pn_20 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
39. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx26 on notifications_summary_weekly_partitioned_2019_w26 pn_21 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
40. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx27 on notifications_summary_weekly_partitioned_2019_w27 pn_22 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
41. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx28 on notifications_summary_weekly_partitioned_2019_w28 pn_23 (cost=0.56..4.99 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
42. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx29 on notifications_summary_weekly_partitioned_2019_w29 pn_24 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
43. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx30 on notifications_summary_weekly_partitioned_2019_w30 pn_25 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
44. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx31 on notifications_summary_weekly_partitioned_2019_w31 pn_26 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
45. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx32 on notifications_summary_weekly_partitioned_2019_w32 pn_27 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
46. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx33 on notifications_summary_weekly_partitioned_2019_w33 pn_28 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
47. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx34 on notifications_summary_weekly_partitioned_2019_w34 pn_29 (cost=0.56..3.58 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
48. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx35 on notifications_summary_weekly_partitioned_2019_w35 pn_30 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
49. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx36 on notifications_summary_weekly_partitioned_2019_w36 pn_31 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
50. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx37 on notifications_summary_weekly_partitioned_2019_w37 pn_32 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
51. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx38 on notifications_summary_weekly_partitioned_2019_w38 pn_33 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
52. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx39 on notifications_summary_weekly_partitioned_2019_w39 pn_34 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
53. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx40 on notifications_summary_weekly_partitioned_2019_w40 pn_35 (cost=0.56..6.64 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
54. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx41 on notifications_summary_weekly_partitioned_2019_w41 pn_36 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
55. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx42 on notifications_summary_weekly_partitioned_2019_w42 pn_37 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
56. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx43 on notifications_summary_weekly_partitioned_2019_w43 pn_38 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
57. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx44 on notifications_summary_weekly_partitioned_2019_w44 pn_39 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
58. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx45 on notifications_summary_weekly_partitioned_2019_w45 pn_40 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
59. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx46 on notifications_summary_weekly_partitioned_2019_w46 pn_41 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
60. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx47 on notifications_summary_weekly_partitioned_2019_w47 pn_42 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
61. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx48 on notifications_summary_weekly_partitioned_2019_w48 pn_43 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
62. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx49 on notifications_summary_weekly_partitioned_2019_w49 pn_44 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
63. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx50 on notifications_summary_weekly_partitioned_2019_w50 pn_45 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
64. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx51 on notifications_summary_weekly_partitioned_2019_w51 pn_46 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
65. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx52 on notifications_summary_weekly_partitioned_2019_w52 pn_47 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
66. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_p_organization_uuid_event_uuid_idx on notifications_summary_weekly_partitioned_2020_w1 pn_48 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
67. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx1 on notifications_summary_weekly_partitioned_2020_w2 pn_49 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
68. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx2 on notifications_summary_weekly_partitioned_2020_w3 pn_50 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
69. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx3 on notifications_summary_weekly_partitioned_2020_w4 pn_51 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
70. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx4 on notifications_summary_weekly_partitioned_2020_w5 pn_52 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
71. 2,747.752 2,747.752 ↓ 1,062.0 1,062 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx54 on notifications_summary_weekly_partitioned_2020_w6 pn_53 (cost=0.56..5.12 rows=1 width=72) (actual time=0.157..2,747.752 rows=1,062 loops=1)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
  • Rows Removed by Filter: 6948
72. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx55 on notifications_summary_weekly_partitioned_2020_w7 pn_54 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
73. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx56 on notifications_summary_weekly_partitioned_2020_w8 pn_55 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
74. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx57 on notifications_summary_weekly_partitioned_2020_w9 pn_56 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
75. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx58 on notifications_summary_weekly_partitioned_2020_w10 pn_57 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
76. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx59 on notifications_summary_weekly_partitioned_2020_w11 pn_58 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
77. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx60 on notifications_summary_weekly_partitioned_2020_w12 pn_59 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
78. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx61 on notifications_summary_weekly_partitioned_2020_w13 pn_60 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
79. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx62 on notifications_summary_weekly_partitioned_2020_w14 pn_61 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
80. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx63 on notifications_summary_weekly_partitioned_2020_w15 pn_62 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
81. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx64 on notifications_summary_weekly_partitioned_2020_w16 pn_63 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
82. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx65 on notifications_summary_weekly_partitioned_2020_w17 pn_64 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
83. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx66 on notifications_summary_weekly_partitioned_2020_w18 pn_65 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
84. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx67 on notifications_summary_weekly_partitioned_2020_w19 pn_66 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
85. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx68 on notifications_summary_weekly_partitioned_2020_w20 pn_67 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
86. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx69 on notifications_summary_weekly_partitioned_2020_w21 pn_68 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
87. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx70 on notifications_summary_weekly_partitioned_2020_w22 pn_69 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
88. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx71 on notifications_summary_weekly_partitioned_2020_w23 pn_70 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
89. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx72 on notifications_summary_weekly_partitioned_2020_w24 pn_71 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
90. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx73 on notifications_summary_weekly_partitioned_2020_w25 pn_72 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
91. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx74 on notifications_summary_weekly_partitioned_2020_w26 pn_73 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
92. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx75 on notifications_summary_weekly_partitioned_2020_w27 pn_74 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
93. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx76 on notifications_summary_weekly_partitioned_2020_w28 pn_75 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
94. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx77 on notifications_summary_weekly_partitioned_2020_w29 pn_76 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
95. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx78 on notifications_summary_weekly_partitioned_2020_w30 pn_77 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
96. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx79 on notifications_summary_weekly_partitioned_2020_w31 pn_78 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
97. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx80 on notifications_summary_weekly_partitioned_2020_w32 pn_79 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
98. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx81 on notifications_summary_weekly_partitioned_2020_w33 pn_80 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
99. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx82 on notifications_summary_weekly_partitioned_2020_w34 pn_81 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
100. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx83 on notifications_summary_weekly_partitioned_2020_w35 pn_82 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
101. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx84 on notifications_summary_weekly_partitioned_2020_w36 pn_83 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
102. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx85 on notifications_summary_weekly_partitioned_2020_w37 pn_84 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
103. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx86 on notifications_summary_weekly_partitioned_2020_w38 pn_85 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
104. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx87 on notifications_summary_weekly_partitioned_2020_w39 pn_86 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
105. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx88 on notifications_summary_weekly_partitioned_2020_w40 pn_87 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
106. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx89 on notifications_summary_weekly_partitioned_2020_w41 pn_88 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
107. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx90 on notifications_summary_weekly_partitioned_2020_w42 pn_89 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
108. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx91 on notifications_summary_weekly_partitioned_2020_w43 pn_90 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
109. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx92 on notifications_summary_weekly_partitioned_2020_w44 pn_91 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
110. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx93 on notifications_summary_weekly_partitioned_2020_w45 pn_92 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
111. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx94 on notifications_summary_weekly_partitioned_2020_w46 pn_93 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
112. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx95 on notifications_summary_weekly_partitioned_2020_w47 pn_94 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
113. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx96 on notifications_summary_weekly_partitioned_2020_w48 pn_95 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
114. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx97 on notifications_summary_weekly_partitioned_2020_w49 pn_96 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
115. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx98 on notifications_summary_weekly_partitioned_2020_w50 pn_97 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
116. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx99 on notifications_summary_weekly_partitioned_2020_w51 pn_98 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
117. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient_idx100 on notifications_summary_weekly_partitioned_2020_w52 pn_99 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
118. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx48 on notifications_summary_weekly_part_default pn_100 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
119. 3.794 62.010 ↓ 10.5 1,062 1

GroupAggregate (cost=1,679.63..2,038.19 rows=101 width=160) (actual time=58.146..62.010 rows=1,062 loops=1)

  • Group Key: dn.parent_ntfn_uuid
120.          

Initplan (for GroupAggregate)

121. 0.001 0.001 ↑ 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.001..0.001 rows=1 loops=1)

122. 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)

123. 0.001 0.001 ↑ 2.0 1 1

CTE Scan on get_event get_event_1 (cost=0.00..0.04 rows=2 width=16) (actual time=0.001..0.001 rows=1 loops=1)

124. 0.002 0.002 ↑ 2.0 1 1

CTE Scan on get_event get_event_2 (cost=0.00..0.04 rows=2 width=16) (actual time=0.002..0.002 rows=1 loops=1)

125. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on get_event_closing_max e_5 (cost=0.00..0.02 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1)

126. 0.002 0.002 ↑ 1.0 1 1

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

127. 3.058 58.207 ↑ 3.2 2,946 1

Sort (cost=1,679.47..1,703.29 rows=9,528 width=56) (actual time=57.901..58.207 rows=2,946 loops=1)

  • Sort Key: dn.parent_ntfn_uuid
  • Sort Method: quicksort Memory: 327kB
128. 2.239 55.149 ↑ 3.2 2,946 1

Nested Loop Left Join (cost=354.44..1,049.77 rows=9,528 width=56) (actual time=8.525..55.149 rows=2,946 loops=1)

  • Join Filter: (dn.responded_date <= (now())::timestamp without time zone)
129. 2.018 17.558 ↓ 29.2 2,946 1

Hash Join (cost=354.02..707.05 rows=101 width=64) (actual time=8.448..17.558 rows=2,946 loops=1)

  • Hash Cond: (ln.parent_ntfn_uuid = dn.notification_uuid)
130. 0.340 7.268 ↓ 29.2 2,946 1

Append (cost=0.56..352.20 rows=101 width=24) (actual time=0.104..7.268 rows=2,946 loops=1)

131. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx5 on notifications_summary_weekly_partitioned_2019_w5 ln (cost=0.56..4.28 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
132. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx6 on notifications_summary_weekly_partitioned_2019_w6 ln_1 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
133. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx7 on notifications_summary_weekly_partitioned_2019_w7 ln_2 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
134. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx8 on notifications_summary_weekly_partitioned_2019_w8 ln_3 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
135. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx9 on notifications_summary_weekly_partitioned_2019_w9 ln_4 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
136. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx10 on notifications_summary_weekly_partitioned_2019_w10 ln_5 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
137. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx11 on notifications_summary_weekly_partitioned_2019_w11 ln_6 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
138. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx12 on notifications_summary_weekly_partitioned_2019_w12 ln_7 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
139. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx13 on notifications_summary_weekly_partitioned_2019_w13 ln_8 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
140. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx14 on notifications_summary_weekly_partitioned_2019_w14 ln_9 (cost=0.56..5.66 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
141. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx15 on notifications_summary_weekly_partitioned_2019_w15 ln_10 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
142. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx16 on notifications_summary_weekly_partitioned_2019_w16 ln_11 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
143. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx17 on notifications_summary_weekly_partitioned_2019_w17 ln_12 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
144. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx18 on notifications_summary_weekly_partitioned_2019_w18 ln_13 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
145. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx19 on notifications_summary_weekly_partitioned_2019_w19 ln_14 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
146. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx20 on notifications_summary_weekly_partitioned_2019_w20 ln_15 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
147. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx21 on notifications_summary_weekly_partitioned_2019_w21 ln_16 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
148. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx22 on notifications_summary_weekly_partitioned_2019_w22 ln_17 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
149. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx23 on notifications_summary_weekly_partitioned_2019_w23 ln_18 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
150. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx24 on notifications_summary_weekly_partitioned_2019_w24 ln_19 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
151. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx25 on notifications_summary_weekly_partitioned_2019_w25 ln_20 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
152. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx26 on notifications_summary_weekly_partitioned_2019_w26 ln_21 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
153. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx27 on notifications_summary_weekly_partitioned_2019_w27 ln_22 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
154. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx28 on notifications_summary_weekly_partitioned_2019_w28 ln_23 (cost=0.56..4.99 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
155. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx29 on notifications_summary_weekly_partitioned_2019_w29 ln_24 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
156. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx30 on notifications_summary_weekly_partitioned_2019_w30 ln_25 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
157. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx31 on notifications_summary_weekly_partitioned_2019_w31 ln_26 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
158. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx32 on notifications_summary_weekly_partitioned_2019_w32 ln_27 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
159. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx33 on notifications_summary_weekly_partitioned_2019_w33 ln_28 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
160. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx34 on notifications_summary_weekly_partitioned_2019_w34 ln_29 (cost=0.56..3.58 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
161. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx35 on notifications_summary_weekly_partitioned_2019_w35 ln_30 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
162. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx36 on notifications_summary_weekly_partitioned_2019_w36 ln_31 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
163. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx37 on notifications_summary_weekly_partitioned_2019_w37 ln_32 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
164. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx38 on notifications_summary_weekly_partitioned_2019_w38 ln_33 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
165. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx39 on notifications_summary_weekly_partitioned_2019_w39 ln_34 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
166. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx40 on notifications_summary_weekly_partitioned_2019_w40 ln_35 (cost=0.56..6.64 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
167. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx41 on notifications_summary_weekly_partitioned_2019_w41 ln_36 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
168. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx42 on notifications_summary_weekly_partitioned_2019_w42 ln_37 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
169. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx43 on notifications_summary_weekly_partitioned_2019_w43 ln_38 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
170. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx44 on notifications_summary_weekly_partitioned_2019_w44 ln_39 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
171. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx45 on notifications_summary_weekly_partitioned_2019_w45 ln_40 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
172. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx46 on notifications_summary_weekly_partitioned_2019_w46 ln_41 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
173. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx47 on notifications_summary_weekly_partitioned_2019_w47 ln_42 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
174. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx48 on notifications_summary_weekly_partitioned_2019_w48 ln_43 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
175. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx49 on notifications_summary_weekly_partitioned_2019_w49 ln_44 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
176. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx50 on notifications_summary_weekly_partitioned_2019_w50 ln_45 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
177. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx51 on notifications_summary_weekly_partitioned_2019_w51 ln_46 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
178. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx52 on notifications_summary_weekly_partitioned_2019_w52 ln_47 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
179. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_p_organization_uuid_event_uuid_idx on notifications_summary_weekly_partitioned_2020_w1 ln_48 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
180. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx1 on notifications_summary_weekly_partitioned_2020_w2 ln_49 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
181. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx2 on notifications_summary_weekly_partitioned_2020_w3 ln_50 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
182. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx3 on notifications_summary_weekly_partitioned_2020_w4 ln_51 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
183. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx4 on notifications_summary_weekly_partitioned_2020_w5 ln_52 (cost=0.56..3.59 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
184. 6.928 6.928 ↓ 2,946.0 2,946 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx54 on notifications_summary_weekly_partitioned_2020_w6 ln_53 (cost=0.56..5.12 rows=1 width=24) (actual time=0.083..6.928 rows=2,946 loops=1)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date <= $10) AND (created_date >= $11) AND (category = 'LIVE'::text))
  • Rows Removed by Filter: 5064
185. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
186. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
187. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
188. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
189. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
190. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
191. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
192. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
193. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
194. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
195. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
196. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
197. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
198. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
199. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
200. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
201. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
202. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
203. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
204. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
205. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
206. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
207. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
208. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
209. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
210. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
211. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
212. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
213. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
214. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
215. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
216. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
217. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
218. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
219. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
220. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
221. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
222. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
223. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
224. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
225. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
226. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
227. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
228. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
229. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
230. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
231. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $10) AND (created_date >= $11))
  • Filter: ((event_uuid = $9) AND (category = 'LIVE'::text))
232. 1.979 8.272 ↓ 39.6 4,000 1

Hash (cost=352.20..352.20 rows=101 width=56) (actual time=8.271..8.272 rows=4,000 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 311kB
233. 0.334 6.293 ↓ 39.6 4,000 1

Append (cost=0.56..352.20 rows=101 width=56) (actual time=0.106..6.293 rows=4,000 loops=1)

234. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx5 on notifications_summary_weekly_partitioned_2019_w5 dn (cost=0.56..4.28 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
235. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx6 on notifications_summary_weekly_partitioned_2019_w6 dn_1 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
236. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx7 on notifications_summary_weekly_partitioned_2019_w7 dn_2 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
237. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx8 on notifications_summary_weekly_partitioned_2019_w8 dn_3 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
238. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx9 on notifications_summary_weekly_partitioned_2019_w9 dn_4 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
239. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx10 on notifications_summary_weekly_partitioned_2019_w10 dn_5 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
240. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx11 on notifications_summary_weekly_partitioned_2019_w11 dn_6 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
241. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx12 on notifications_summary_weekly_partitioned_2019_w12 dn_7 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
242. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx13 on notifications_summary_weekly_partitioned_2019_w13 dn_8 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
243. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx14 on notifications_summary_weekly_partitioned_2019_w14 dn_9 (cost=0.56..5.66 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
244. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx15 on notifications_summary_weekly_partitioned_2019_w15 dn_10 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
245. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx16 on notifications_summary_weekly_partitioned_2019_w16 dn_11 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
246. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx17 on notifications_summary_weekly_partitioned_2019_w17 dn_12 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
247. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx18 on notifications_summary_weekly_partitioned_2019_w18 dn_13 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
248. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx19 on notifications_summary_weekly_partitioned_2019_w19 dn_14 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
249. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx20 on notifications_summary_weekly_partitioned_2019_w20 dn_15 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
250. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx21 on notifications_summary_weekly_partitioned_2019_w21 dn_16 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
251. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx22 on notifications_summary_weekly_partitioned_2019_w22 dn_17 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
252. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx23 on notifications_summary_weekly_partitioned_2019_w23 dn_18 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
253. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx24 on notifications_summary_weekly_partitioned_2019_w24 dn_19 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
254. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx25 on notifications_summary_weekly_partitioned_2019_w25 dn_20 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
255. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx26 on notifications_summary_weekly_partitioned_2019_w26 dn_21 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
256. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx27 on notifications_summary_weekly_partitioned_2019_w27 dn_22 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
257. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx28 on notifications_summary_weekly_partitioned_2019_w28 dn_23 (cost=0.56..4.99 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
258. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx29 on notifications_summary_weekly_partitioned_2019_w29 dn_24 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
259. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx30 on notifications_summary_weekly_partitioned_2019_w30 dn_25 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
260. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx31 on notifications_summary_weekly_partitioned_2019_w31 dn_26 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
261. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx32 on notifications_summary_weekly_partitioned_2019_w32 dn_27 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
262. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx33 on notifications_summary_weekly_partitioned_2019_w33 dn_28 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
263. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx34 on notifications_summary_weekly_partitioned_2019_w34 dn_29 (cost=0.56..3.58 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
264. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx35 on notifications_summary_weekly_partitioned_2019_w35 dn_30 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
265. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx36 on notifications_summary_weekly_partitioned_2019_w36 dn_31 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
266. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx37 on notifications_summary_weekly_partitioned_2019_w37 dn_32 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
267. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx38 on notifications_summary_weekly_partitioned_2019_w38 dn_33 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
268. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx39 on notifications_summary_weekly_partitioned_2019_w39 dn_34 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
269. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx40 on notifications_summary_weekly_partitioned_2019_w40 dn_35 (cost=0.56..6.64 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
270. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx41 on notifications_summary_weekly_partitioned_2019_w41 dn_36 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
271. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx42 on notifications_summary_weekly_partitioned_2019_w42 dn_37 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
272. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx43 on notifications_summary_weekly_partitioned_2019_w43 dn_38 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
273. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx44 on notifications_summary_weekly_partitioned_2019_w44 dn_39 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
274. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx45 on notifications_summary_weekly_partitioned_2019_w45 dn_40 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
275. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx46 on notifications_summary_weekly_partitioned_2019_w46 dn_41 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
276. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx47 on notifications_summary_weekly_partitioned_2019_w47 dn_42 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
277. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx48 on notifications_summary_weekly_partitioned_2019_w48 dn_43 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
278. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx49 on notifications_summary_weekly_partitioned_2019_w49 dn_44 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
279. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx50 on notifications_summary_weekly_partitioned_2019_w50 dn_45 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
280. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx51 on notifications_summary_weekly_partitioned_2019_w51 dn_46 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
281. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx52 on notifications_summary_weekly_partitioned_2019_w52 dn_47 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
282. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_p_organization_uuid_event_uuid_idx on notifications_summary_weekly_partitioned_2020_w1 dn_48 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
283. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx1 on notifications_summary_weekly_partitioned_2020_w2 dn_49 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
284. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx2 on notifications_summary_weekly_partitioned_2020_w3 dn_50 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
285. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx3 on notifications_summary_weekly_partitioned_2020_w4 dn_51 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
286. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx4 on notifications_summary_weekly_partitioned_2020_w5 dn_52 (cost=0.56..3.59 rows=1 width=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
287. 5.959 5.959 ↓ 4,000.0 4,000 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx54 on notifications_summary_weekly_partitioned_2020_w6 dn_53 (cost=0.56..5.12 rows=1 width=56) (actual time=0.086..5.959 rows=4,000 loops=1)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (event_uuid = $8))
  • Filter: ((created_date <= $6) AND (created_date >= $7) AND (category = 'DEVICE'::text))
  • Rows Removed by Filter: 4010
288. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
289. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
290. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
291. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
292. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
293. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
294. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
295. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
296. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
297. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
298. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
299. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
300. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
301. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
302. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
303. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
304. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
305. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
306. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
307. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
308. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
309. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
310. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
311. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
312. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
313. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
314. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
315. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
316. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
317. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
318. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
319. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
320. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
321. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
322. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
323. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
324. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
325. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
326. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
327. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
328. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
329. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
330. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
331. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
332. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
333. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
334. 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=56) (never executed)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (created_date <= $6) AND (created_date >= $7))
  • Filter: ((category = 'DEVICE'::text) AND (event_uuid = $8))
335. 35.352 35.352 ↓ 0.0 0 2,946

Index Scan using responses_org_part_16_notification_uuid_idx on responses_org_part_16 r_1 (cost=0.42..3.38 rows=1 width=24) (actual time=0.012..0.012 rows=0 loops=2,946)

  • Index Cond: (notification_uuid = dn.notification_uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND ((response)::text <> 'XMATTERS_REMOVE'::text) AND (organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (received <= now()))
336. 4.248 4.248 ↓ 0.0 0 1,062

Index Scan using responses_org_part_16_notification_uuid_idx on responses_org_part_16 r (cost=0.42..3.38 rows=1 width=24) (actual time=0.004..0.004 rows=0 loops=1,062)

  • Index Cond: (notification_uuid = pn.notification_uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND ((response)::text <> 'XMATTERS_REMOVE'::text) AND (organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (received <= now()))
Planning time : 141.692 ms
Execution time : 2,849.200 ms