explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GXGi

Settings
# exclusive inclusive rows x rows loops node
1. 0.050 1,093.922 ↓ 29.0 29 1

Nested Loop Left Join (cost=4,876.98..4,881.79 rows=1 width=64) (actual time=1,086.094..1,093.922 rows=29 loops=1)

2.          

CTE get_event

3. 3.922 3.922 ↑ 1.0 1 1

Index Scan using events_org_part_252_event_uuid_idx on events_org_part_252 e (cost=0.42..6.49 rows=1 width=105) (actual time=1.641..3.922 rows=1 loops=1)

  • Index Cond: (event_uuid = 'a6c69a41-98dc-432b-8cf2-cd4922e27436'::uuid)
  • Filter: ((is_visible IS TRUE) AND (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (valid_range @> now()))
  • Rows Removed by Filter: 4
4.          

CTE get_event_created_min

5. 0.005 0.006 ↑ 1.0 1 1

Aggregate (cost=0.02..0.03 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=1)

6. 0.001 0.001 ↑ 1.0 1 1

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

7.          

CTE get_event_closing_max

8. 0.017 3.943 ↑ 1.0 1 1

Aggregate (cost=0.03..0.04 rows=1 width=8) (actual time=3.942..3.943 rows=1 loops=1)

9. 3.926 3.926 ↑ 1.0 1 1

CTE Scan on get_event e_2 (cost=0.00..0.02 rows=1 width=16) (actual time=1.644..3.926 rows=1 loops=1)

10.          

CTE get_event_person_notifications

11. 0.477 722.810 ↑ 11.6 288 1

Nested Loop Left Join (cost=1.04..720.53 rows=3,345 width=399) (actual time=14.155..722.810 rows=288 loops=1)

  • Join Filter: (pn.responded_date <= (now())::timestamp without time zone)
12.          

Initplan (for Nested Loop Left Join)

13. 0.002 0.002 ↑ 1.0 1 1

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

14. 0.002 0.002 ↑ 1.0 1 1

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

15. 0.001 0.001 ↑ 1.0 1 1

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

16. 0.082 357.144 ↓ 2.9 288 1

Append (cost=0.56..344.58 rows=101 width=165) (actual time=0.050..357.144 rows=288 loops=1)

17. 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..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
18. 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=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx7 on notifications_summary_weekly_partitioned_2019_w7 pn_2 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx8 on notifications_summary_weekly_partitioned_2019_w8 pn_3 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx9 on notifications_summary_weekly_partitioned_2019_w9 pn_4 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx10 on notifications_summary_weekly_partitioned_2019_w10 pn_5 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx11 on notifications_summary_weekly_partitioned_2019_w11 pn_6 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx12 on notifications_summary_weekly_partitioned_2019_w12 pn_7 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx13 on notifications_summary_weekly_partitioned_2019_w13 pn_8 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx14 on notifications_summary_weekly_partitioned_2019_w14 pn_9 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx15 on notifications_summary_weekly_partitioned_2019_w15 pn_10 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx16 on notifications_summary_weekly_partitioned_2019_w16 pn_11 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx17 on notifications_summary_weekly_partitioned_2019_w17 pn_12 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx18 on notifications_summary_weekly_partitioned_2019_w18 pn_13 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx19 on notifications_summary_weekly_partitioned_2019_w19 pn_14 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx20 on notifications_summary_weekly_partitioned_2019_w20 pn_15 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx21 on notifications_summary_weekly_partitioned_2019_w21 pn_16 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx22 on notifications_summary_weekly_partitioned_2019_w22 pn_17 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx23 on notifications_summary_weekly_partitioned_2019_w23 pn_18 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx24 on notifications_summary_weekly_partitioned_2019_w24 pn_19 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx25 on notifications_summary_weekly_partitioned_2019_w25 pn_20 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx26 on notifications_summary_weekly_partitioned_2019_w26 pn_21 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx27 on notifications_summary_weekly_partitioned_2019_w27 pn_22 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx28 on notifications_summary_weekly_partitioned_2019_w28 pn_23 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx29 on notifications_summary_weekly_partitioned_2019_w29 pn_24 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx30 on notifications_summary_weekly_partitioned_2019_w30 pn_25 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx31 on notifications_summary_weekly_partitioned_2019_w31 pn_26 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx32 on notifications_summary_weekly_partitioned_2019_w32 pn_27 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx33 on notifications_summary_weekly_partitioned_2019_w33 pn_28 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx34 on notifications_summary_weekly_partitioned_2019_w34 pn_29 (cost=0.56..3.58 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx35 on notifications_summary_weekly_partitioned_2019_w35 pn_30 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx36 on notifications_summary_weekly_partitioned_2019_w36 pn_31 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx37 on notifications_summary_weekly_partitioned_2019_w37 pn_32 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx38 on notifications_summary_weekly_partitioned_2019_w38 pn_33 (cost=0.56..4.29 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx39 on notifications_summary_weekly_partitioned_2019_w39 pn_34 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx40 on notifications_summary_weekly_partitioned_2019_w40 pn_35 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx41 on notifications_summary_weekly_partitioned_2019_w41 pn_36 (cost=0.56..3.59 rows=1 width=104) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx42 on notifications_summary_weekly_partitioned_2019_w42 pn_37 (cost=0.56..3.59 rows=1 width=104) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx43 on notifications_summary_weekly_partitioned_2019_w43 pn_38 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx44 on notifications_summary_weekly_partitioned_2019_w44 pn_39 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx45 on notifications_summary_weekly_partitioned_2019_w45 pn_40 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx46 on notifications_summary_weekly_partitioned_2019_w46 pn_41 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx47 on notifications_summary_weekly_partitioned_2019_w47 pn_42 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx48 on notifications_summary_weekly_partitioned_2019_w48 pn_43 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx49 on notifications_summary_weekly_partitioned_2019_w49 pn_44 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx50 on notifications_summary_weekly_partitioned_2019_w50 pn_45 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx51 on notifications_summary_weekly_partitioned_2019_w51 pn_46 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx52 on notifications_summary_weekly_partitioned_2019_w52 pn_47 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_p_organization_uuid_event_uuid_idx on notifications_summary_weekly_partitioned_2020_w1 pn_48 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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__organization_uuid_event_uuid_idx1 on notifications_summary_weekly_partitioned_2020_w2 pn_49 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx2 on notifications_summary_weekly_partitioned_2020_w3 pn_50 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_idx3 on notifications_summary_weekly_partitioned_2020_w4 pn_51 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
69. 357.062 357.062 ↓ 288.0 288 1

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=103) (actual time=0.037..357.062 rows=288 loops=1)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
  • Rows Removed by Filter: 1284
70. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx54 on notifications_summary_weekly_partitioned_2020_w6 pn_53 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
71. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx55 on notifications_summary_weekly_partitioned_2020_w7 pn_54 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $3))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'PERSON'::text))
72. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w9_pkey on notifications_summary_weekly_partitioned_2020_w9 pn_56 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w10_pkey on notifications_summary_weekly_partitioned_2020_w10 pn_57 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w11_pkey on notifications_summary_weekly_partitioned_2020_w11 pn_58 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w12_pkey on notifications_summary_weekly_partitioned_2020_w12 pn_59 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w13_pkey on notifications_summary_weekly_partitioned_2020_w13 pn_60 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w14_pkey on notifications_summary_weekly_partitioned_2020_w14 pn_61 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w15_pkey on notifications_summary_weekly_partitioned_2020_w15 pn_62 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w16_pkey on notifications_summary_weekly_partitioned_2020_w16 pn_63 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w17_pkey on notifications_summary_weekly_partitioned_2020_w17 pn_64 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w18_pkey on notifications_summary_weekly_partitioned_2020_w18 pn_65 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w19_pkey on notifications_summary_weekly_partitioned_2020_w19 pn_66 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w20_pkey on notifications_summary_weekly_partitioned_2020_w20 pn_67 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w21_pkey on notifications_summary_weekly_partitioned_2020_w21 pn_68 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w22_pkey on notifications_summary_weekly_partitioned_2020_w22 pn_69 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w23_pkey on notifications_summary_weekly_partitioned_2020_w23 pn_70 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w24_pkey on notifications_summary_weekly_partitioned_2020_w24 pn_71 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w25_pkey on notifications_summary_weekly_partitioned_2020_w25 pn_72 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w26_pkey on notifications_summary_weekly_partitioned_2020_w26 pn_73 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w27_pkey on notifications_summary_weekly_partitioned_2020_w27 pn_74 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w28_pkey on notifications_summary_weekly_partitioned_2020_w28 pn_75 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w29_pkey on notifications_summary_weekly_partitioned_2020_w29 pn_76 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w30_pkey on notifications_summary_weekly_partitioned_2020_w30 pn_77 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w31_pkey on notifications_summary_weekly_partitioned_2020_w31 pn_78 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w32_pkey on notifications_summary_weekly_partitioned_2020_w32 pn_79 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w33_pkey on notifications_summary_weekly_partitioned_2020_w33 pn_80 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w34_pkey on notifications_summary_weekly_partitioned_2020_w34 pn_81 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w35_pkey on notifications_summary_weekly_partitioned_2020_w35 pn_82 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w36_pkey on notifications_summary_weekly_partitioned_2020_w36 pn_83 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w37_pkey on notifications_summary_weekly_partitioned_2020_w37 pn_84 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w38_pkey on notifications_summary_weekly_partitioned_2020_w38 pn_85 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w39_pkey on notifications_summary_weekly_partitioned_2020_w39 pn_86 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w40_pkey on notifications_summary_weekly_partitioned_2020_w40 pn_87 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w41_pkey on notifications_summary_weekly_partitioned_2020_w41 pn_88 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w42_pkey on notifications_summary_weekly_partitioned_2020_w42 pn_89 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w43_pkey on notifications_summary_weekly_partitioned_2020_w43 pn_90 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w44_pkey on notifications_summary_weekly_partitioned_2020_w44 pn_91 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w45_pkey on notifications_summary_weekly_partitioned_2020_w45 pn_92 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w46_pkey on notifications_summary_weekly_partitioned_2020_w46 pn_93 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w47_pkey on notifications_summary_weekly_partitioned_2020_w47 pn_94 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w48_pkey on notifications_summary_weekly_partitioned_2020_w48 pn_95 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w49_pkey on notifications_summary_weekly_partitioned_2020_w49 pn_96 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w50_pkey on notifications_summary_weekly_partitioned_2020_w50 pn_97 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w51_pkey on notifications_summary_weekly_partitioned_2020_w51 pn_98 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_partitioned_2020_w52_pkey on notifications_summary_weekly_partitioned_2020_w52 pn_99 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::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_part_default_pkey on notifications_summary_weekly_part_default pn_100 (cost=0.14..3.17 rows=1 width=238) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $3) AND (category = 'PERSON'::text))
118. 365.184 365.184 ↓ 0.0 0 288

Index Scan using responses_org_part_72_notification_uuid_idx on responses_org_part_72 r (cost=0.41..3.21 rows=1 width=250) (actual time=1.268..1.268 rows=0 loops=288)

  • 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 = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (received <= now()))
  • Rows Removed by Filter: 0
119.          

CTE get_team_groups

120. 0.038 1,065.577 ↑ 14.8 174 1

Recursive Union (cost=80.39..4,091.50 rows=2,570 width=86) (actual time=1,063.919..1,065.577 rows=174 loops=1)

121. 0.000 1,064.691 ↑ 1.7 29 1

Hash Join (cost=80.39..425.73 rows=50 width=86) (actual time=1,063.917..1,064.691 rows=29 loops=1)

  • Hash Cond: (team_ntfn.notification_uuid = get_event_person_notifications.team_ntfn_uuid)
122.          

Initplan (for Hash Join)

123. 0.001 0.001 ↑ 1.0 1 1

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

124. 3.945 3.945 ↑ 1.0 1 1

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

125. 0.007 0.007 ↑ 1.0 1 1

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

126. 3.975 340.976 ↑ 2.2 46 1

Append (cost=0.56..345.09 rows=101 width=66) (actual time=340.198..340.976 rows=46 loops=1)

127. 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 team_ntfn (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
128. 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 team_ntfn_1 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
129. 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 team_ntfn_2 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
130. 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 team_ntfn_3 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
131. 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 team_ntfn_4 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
132. 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 team_ntfn_5 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
133. 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 team_ntfn_6 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
134. 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 team_ntfn_7 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
135. 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 team_ntfn_8 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
136. 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 team_ntfn_9 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
137. 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 team_ntfn_10 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
138. 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 team_ntfn_11 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
139. 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 team_ntfn_12 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
140. 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 team_ntfn_13 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
141. 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 team_ntfn_14 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
142. 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 team_ntfn_15 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
143. 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 team_ntfn_16 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
144. 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 team_ntfn_17 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
145. 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 team_ntfn_18 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
146. 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 team_ntfn_19 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
147. 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 team_ntfn_20 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
148. 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 team_ntfn_21 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
149. 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 team_ntfn_22 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
150. 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 team_ntfn_23 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
151. 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 team_ntfn_24 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
152. 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 team_ntfn_25 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
153. 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 team_ntfn_26 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
154. 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 team_ntfn_27 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
155. 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 team_ntfn_28 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
156. 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 team_ntfn_29 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
157. 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 team_ntfn_30 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
158. 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 team_ntfn_31 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
159. 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 team_ntfn_32 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
160. 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 team_ntfn_33 (cost=0.56..4.30 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
161. 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 team_ntfn_34 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
162. 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 team_ntfn_35 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
163. 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 team_ntfn_36 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
164. 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 team_ntfn_37 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
165. 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 team_ntfn_38 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
166. 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 team_ntfn_39 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
167. 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 team_ntfn_40 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
168. 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 team_ntfn_41 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
169. 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 team_ntfn_42 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
170. 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 team_ntfn_43 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
171. 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 team_ntfn_44 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
172. 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 team_ntfn_45 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
173. 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 team_ntfn_46 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
174. 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 team_ntfn_47 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
175. 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 team_ntfn_48 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
176. 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 team_ntfn_49 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
177. 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 team_ntfn_50 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
178. 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 team_ntfn_51 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
179. 337.001 337.001 ↓ 46.0 46 1

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx4 on notifications_summary_weekly_partitioned_2020_w5 team_ntfn_52 (cost=0.56..3.59 rows=1 width=54) (actual time=336.227..337.001 rows=46 loops=1)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
  • Rows Removed by Filter: 1526
180. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx54 on notifications_summary_weekly_partitioned_2020_w6 team_ntfn_53 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
181. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx55 on notifications_summary_weekly_partitioned_2020_w7 team_ntfn_54 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $9))
  • Filter: ((created_date >= $11) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
182. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx56 on notifications_summary_weekly_partitioned_2020_w8 team_ntfn_55 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
183. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx57 on notifications_summary_weekly_partitioned_2020_w9 team_ntfn_56 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
184. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx58 on notifications_summary_weekly_partitioned_2020_w10 team_ntfn_57 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
185. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx59 on notifications_summary_weekly_partitioned_2020_w11 team_ntfn_58 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
186. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx60 on notifications_summary_weekly_partitioned_2020_w12 team_ntfn_59 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
187. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx61 on notifications_summary_weekly_partitioned_2020_w13 team_ntfn_60 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
188. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx62 on notifications_summary_weekly_partitioned_2020_w14 team_ntfn_61 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
189. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx63 on notifications_summary_weekly_partitioned_2020_w15 team_ntfn_62 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
190. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx64 on notifications_summary_weekly_partitioned_2020_w16 team_ntfn_63 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
191. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx65 on notifications_summary_weekly_partitioned_2020_w17 team_ntfn_64 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
192. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx66 on notifications_summary_weekly_partitioned_2020_w18 team_ntfn_65 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
193. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx67 on notifications_summary_weekly_partitioned_2020_w19 team_ntfn_66 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
194. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx68 on notifications_summary_weekly_partitioned_2020_w20 team_ntfn_67 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
195. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx69 on notifications_summary_weekly_partitioned_2020_w21 team_ntfn_68 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
196. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx70 on notifications_summary_weekly_partitioned_2020_w22 team_ntfn_69 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
197. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx71 on notifications_summary_weekly_partitioned_2020_w23 team_ntfn_70 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
198. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx72 on notifications_summary_weekly_partitioned_2020_w24 team_ntfn_71 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
199. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx73 on notifications_summary_weekly_partitioned_2020_w25 team_ntfn_72 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
200. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx74 on notifications_summary_weekly_partitioned_2020_w26 team_ntfn_73 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
201. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx75 on notifications_summary_weekly_partitioned_2020_w27 team_ntfn_74 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
202. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx76 on notifications_summary_weekly_partitioned_2020_w28 team_ntfn_75 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
203. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx77 on notifications_summary_weekly_partitioned_2020_w29 team_ntfn_76 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
204. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx78 on notifications_summary_weekly_partitioned_2020_w30 team_ntfn_77 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
205. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx79 on notifications_summary_weekly_partitioned_2020_w31 team_ntfn_78 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
206. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx80 on notifications_summary_weekly_partitioned_2020_w32 team_ntfn_79 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
207. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx81 on notifications_summary_weekly_partitioned_2020_w33 team_ntfn_80 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
208. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx82 on notifications_summary_weekly_partitioned_2020_w34 team_ntfn_81 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
209. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx83 on notifications_summary_weekly_partitioned_2020_w35 team_ntfn_82 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
210. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx84 on notifications_summary_weekly_partitioned_2020_w36 team_ntfn_83 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
211. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx85 on notifications_summary_weekly_partitioned_2020_w37 team_ntfn_84 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
212. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx86 on notifications_summary_weekly_partitioned_2020_w38 team_ntfn_85 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
213. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx87 on notifications_summary_weekly_partitioned_2020_w39 team_ntfn_86 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
214. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx88 on notifications_summary_weekly_partitioned_2020_w40 team_ntfn_87 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
215. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx89 on notifications_summary_weekly_partitioned_2020_w41 team_ntfn_88 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
216. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx90 on notifications_summary_weekly_partitioned_2020_w42 team_ntfn_89 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
217. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx91 on notifications_summary_weekly_partitioned_2020_w43 team_ntfn_90 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
218. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx92 on notifications_summary_weekly_partitioned_2020_w44 team_ntfn_91 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
219. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx93 on notifications_summary_weekly_partitioned_2020_w45 team_ntfn_92 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
220. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx94 on notifications_summary_weekly_partitioned_2020_w46 team_ntfn_93 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
221. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx95 on notifications_summary_weekly_partitioned_2020_w47 team_ntfn_94 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
222. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx96 on notifications_summary_weekly_partitioned_2020_w48 team_ntfn_95 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
223. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx97 on notifications_summary_weekly_partitioned_2020_w49 team_ntfn_96 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
224. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx98 on notifications_summary_weekly_partitioned_2020_w50 team_ntfn_97 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
225. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx99 on notifications_summary_weekly_partitioned_2020_w51 team_ntfn_98 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
226. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_p_organization_uuid_ntfn_id_idx100 on notifications_summary_weekly_partitioned_2020_w52 team_ntfn_99 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
227. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx53 on notifications_summary_weekly_part_default team_ntfn_100 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $11) AND (event_uuid = $9) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $10)))
228. 0.016 723.663 ↑ 6.9 29 1

Hash (cost=77.26..77.26 rows=200 width=16) (actual time=723.662..723.663 rows=29 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
229. 0.275 723.647 ↑ 6.9 29 1

HashAggregate (cost=75.26..77.26 rows=200 width=16) (actual time=723.642..723.647 rows=29 loops=1)

  • Group Key: get_event_person_notifications.team_ntfn_uuid
230. 723.372 723.372 ↑ 11.6 288 1

CTE Scan on get_event_person_notifications (cost=0.00..66.90 rows=3,345 width=16) (actual time=14.162..723.372 rows=288 loops=1)

231. 0.082 0.848 ↑ 14.0 18 8

Hash Join (cost=346.41..361.44 rows=252 width=86) (actual time=0.100..0.106 rows=18 loops=8)

  • Hash Cond: (tg_1.parent_ntfn_uuid = n.notification_uuid)
232.          

Initplan (for Hash Join)

233. 0.002 0.002 ↑ 1.0 1 1

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

234. 0.001 0.001 ↑ 1.0 1 1

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

235. 0.001 0.001 ↑ 1.0 1 1

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

236. 0.016 0.016 ↑ 22.7 22 8

WorkTable Scan on get_team_groups tg_1 (cost=0.00..10.00 rows=500 width=36) (actual time=0.000..0.002 rows=22 loops=8)

237. 0.027 0.746 ↑ 1.4 72 1

Hash (cost=345.09..345.09 rows=101 width=66) (actual time=0.746..0.746 rows=72 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
238. 0.019 0.719 ↑ 1.4 72 1

Append (cost=0.56..345.09 rows=101 width=66) (actual time=0.223..0.719 rows=72 loops=1)

239. 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 n (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
240. 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 n_1 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
241. 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 n_2 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
242. 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 n_3 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
243. 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 n_4 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
244. 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 n_5 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
245. 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 n_6 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
246. 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 n_7 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
247. 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 n_8 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
248. 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 n_9 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
249. 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 n_10 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
250. 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 n_11 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
251. 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 n_12 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
252. 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 n_13 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
253. 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 n_14 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
254. 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 n_15 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
255. 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 n_16 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
256. 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 n_17 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
257. 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 n_18 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
258. 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 n_19 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
259. 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 n_20 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
260. 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 n_21 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
261. 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 n_22 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
262. 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 n_23 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
263. 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 n_24 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
264. 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 n_25 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
265. 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 n_26 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
266. 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 n_27 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
267. 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 n_28 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
268. 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 n_29 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
269. 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 n_30 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
270. 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 n_31 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
271. 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 n_32 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
272. 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 n_33 (cost=0.56..4.30 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
273. 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 n_34 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
274. 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 n_35 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
275. 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 n_36 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
276. 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 n_37 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
277. 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 n_38 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
278. 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 n_39 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
279. 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 n_40 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
280. 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 n_41 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
281. 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 n_42 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
282. 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 n_43 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
283. 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 n_44 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
284. 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 n_45 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
285. 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 n_46 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
286. 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 n_47 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
287. 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 n_48 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
288. 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 n_49 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
289. 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 n_50 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
290. 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 n_51 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
291. 0.700 0.700 ↓ 72.0 72 1

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx4 on notifications_summary_weekly_partitioned_2020_w5 n_52 (cost=0.56..3.59 rows=1 width=54) (actual time=0.210..0.700 rows=72 loops=1)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
  • Rows Removed by Filter: 1500
292. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx54 on notifications_summary_weekly_partitioned_2020_w6 n_53 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
293. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx55 on notifications_summary_weekly_partitioned_2020_w7 n_54 (cost=0.56..3.59 rows=1 width=54) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $13)))
294. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx56 on notifications_summary_weekly_partitioned_2020_w8 n_55 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
295. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx57 on notifications_summary_weekly_partitioned_2020_w9 n_56 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
296. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx58 on notifications_summary_weekly_partitioned_2020_w10 n_57 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
297. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx59 on notifications_summary_weekly_partitioned_2020_w11 n_58 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
298. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx60 on notifications_summary_weekly_partitioned_2020_w12 n_59 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
299. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx61 on notifications_summary_weekly_partitioned_2020_w13 n_60 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
300. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx62 on notifications_summary_weekly_partitioned_2020_w14 n_61 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
301. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx63 on notifications_summary_weekly_partitioned_2020_w15 n_62 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
302. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx64 on notifications_summary_weekly_partitioned_2020_w16 n_63 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
303. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx65 on notifications_summary_weekly_partitioned_2020_w17 n_64 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
304. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx66 on notifications_summary_weekly_partitioned_2020_w18 n_65 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
305. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx67 on notifications_summary_weekly_partitioned_2020_w19 n_66 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
306. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx68 on notifications_summary_weekly_partitioned_2020_w20 n_67 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
307. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx69 on notifications_summary_weekly_partitioned_2020_w21 n_68 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
308. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx70 on notifications_summary_weekly_partitioned_2020_w22 n_69 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
309. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx71 on notifications_summary_weekly_partitioned_2020_w23 n_70 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
310. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx72 on notifications_summary_weekly_partitioned_2020_w24 n_71 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
311. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx73 on notifications_summary_weekly_partitioned_2020_w25 n_72 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
312. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx74 on notifications_summary_weekly_partitioned_2020_w26 n_73 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
313. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx75 on notifications_summary_weekly_partitioned_2020_w27 n_74 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
314. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx76 on notifications_summary_weekly_partitioned_2020_w28 n_75 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
315. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx77 on notifications_summary_weekly_partitioned_2020_w29 n_76 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
316. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx78 on notifications_summary_weekly_partitioned_2020_w30 n_77 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
317. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx79 on notifications_summary_weekly_partitioned_2020_w31 n_78 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
318. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx80 on notifications_summary_weekly_partitioned_2020_w32 n_79 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
319. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx81 on notifications_summary_weekly_partitioned_2020_w33 n_80 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
320. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx82 on notifications_summary_weekly_partitioned_2020_w34 n_81 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
321. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx83 on notifications_summary_weekly_partitioned_2020_w35 n_82 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
322. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx84 on notifications_summary_weekly_partitioned_2020_w36 n_83 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
323. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx85 on notifications_summary_weekly_partitioned_2020_w37 n_84 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
324. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx86 on notifications_summary_weekly_partitioned_2020_w38 n_85 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
325. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx87 on notifications_summary_weekly_partitioned_2020_w39 n_86 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
326. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx88 on notifications_summary_weekly_partitioned_2020_w40 n_87 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
327. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx89 on notifications_summary_weekly_partitioned_2020_w41 n_88 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
328. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx90 on notifications_summary_weekly_partitioned_2020_w42 n_89 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
329. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx91 on notifications_summary_weekly_partitioned_2020_w43 n_90 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
330. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx92 on notifications_summary_weekly_partitioned_2020_w44 n_91 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
331. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx93 on notifications_summary_weekly_partitioned_2020_w45 n_92 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
332. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx94 on notifications_summary_weekly_partitioned_2020_w46 n_93 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
333. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx95 on notifications_summary_weekly_partitioned_2020_w47 n_94 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
334. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx96 on notifications_summary_weekly_partitioned_2020_w48 n_95 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
335. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx97 on notifications_summary_weekly_partitioned_2020_w49 n_96 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
336. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx98 on notifications_summary_weekly_partitioned_2020_w50 n_97 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
337. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx99 on notifications_summary_weekly_partitioned_2020_w51 n_98 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
338. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_p_organization_uuid_ntfn_id_idx100 on notifications_summary_weekly_partitioned_2020_w52 n_99 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
339. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx53 on notifications_summary_weekly_part_default n_100 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date >= $14) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $12) AND (created_date <= LEAST(now(), $13)))
340.          

Initplan (for Nested Loop Left Join)

341. 0.008 0.011 ↑ 1.0 1 1

Aggregate (cost=0.02..0.03 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=1)

342. 0.003 0.003 ↑ 1.0 1 1

CTE Scan on get_event e_8 (cost=0.00..0.02 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1)

343. 0.029 1,065.934 ↓ 29.0 29 1

Subquery Scan on grps (cost=58.07..58.49 rows=1 width=48) (actual time=1,065.826..1,065.934 rows=29 loops=1)

  • Filter: (grps."row" = 1)
  • Rows Removed by Filter: 58
344. 0.112 1,065.905 ↓ 6.7 87 1

WindowAgg (cost=58.07..58.33 rows=13 width=60) (actual time=1,065.821..1,065.905 rows=87 loops=1)

345. 0.121 1,065.793 ↓ 6.7 87 1

Sort (cost=58.07..58.10 rows=13 width=52) (actual time=1,065.778..1,065.793 rows=87 loops=1)

  • Sort Key: tg.root_uuid, tg.group_level DESC
  • Sort Method: quicksort Memory: 37kB
346. 1,065.672 1,065.672 ↓ 6.7 87 1

CTE Scan on get_team_groups tg (cost=0.00..57.82 rows=13 width=52) (actual time=1,065.518..1,065.672 rows=87 loops=1)

  • Filter: (category = 'GROUP'::text)
  • Rows Removed by Filter: 87
347. 27.927 27.927 ↑ 1.0 1 29

Index Scan using groups_org_part_72_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_72 g (cost=0.28..4.66 rows=1 width=32) (actual time=0.895..0.963 rows=1 loops=29)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (group_uuid = grps.group_uuid))
  • Filter: ((is_visible IS TRUE) AND (valid_range @> $16))
  • Rows Removed by Filter: 3
Planning time : 337.855 ms
Execution time : 1,101.795 ms