explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3e1

Settings
# exclusive inclusive rows x rows loops node
1. 2.679 793.388 ↑ 84,712.6 604 1

Sort (cost=24,882,115.20..25,010,031.23 rows=51,166,411 width=406) (actual time=793.353..793.388 rows=604 loops=1)

  • Sort Key: pn.event_uuid, pn.person_uuid
  • Sort Method: quicksort Memory: 185kB
2.          

CTE get_event

3. 1.859 2.063 ↑ 156.0 1 1

Bitmap Heap Scan on events_org_part_252 e_1 (cost=10.11..667.58 rows=156 width=105) (actual time=2.062..2.063 rows=1 loops=1)

  • Recheck Cond: (event_uuid = '15dfc14e-9565-4c90-8664-b6d406d6c330'::uuid)
  • Filter: ((is_visible IS TRUE) AND (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (valid_range @> now()))
  • Rows Removed by Filter: 451
  • Heap Blocks: exact=221
4. 0.204 0.204 ↓ 1.9 903 1

Bitmap Index Scan on events_org_part_252_event_uuid_idx (cost=0.00..10.07 rows=487 width=0) (actual time=0.204..0.204 rows=903 loops=1)

  • Index Cond: (event_uuid = '15dfc14e-9565-4c90-8664-b6d406d6c330'::uuid)
5.          

CTE get_event_created_min

6. 0.003 0.004 ↑ 1.0 1 1

Aggregate (cost=3.51..3.52 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

7. 0.001 0.001 ↑ 156.0 1 1

CTE Scan on get_event e_2 (cost=0.00..3.12 rows=156 width=8) (actual time=0.000..0.001 rows=1 loops=1)

8.          

CTE get_event_closing_max

9. 0.019 2.092 ↑ 1.0 1 1

Aggregate (cost=4.68..4.69 rows=1 width=8) (actual time=2.092..2.092 rows=1 loops=1)

10. 2.073 2.073 ↑ 156.0 1 1

CTE Scan on get_event e_3 (cost=0.00..3.12 rows=156 width=16) (actual time=2.072..2.073 rows=1 loops=1)

11.          

CTE get_event_device_notifications

12. 0.551 13.947 ↑ 2.2 1,524 1

Result (cost=358.79..1,104.00 rows=3,350 width=447) (actual time=4.498..13.947 rows=1,524 loops=1)

  • One-Time Filter: ($3 = $6)
13.          

Initplan (for Result)

14. 0.003 0.003 ↑ 156.0 1 1

CTE Scan on get_event (cost=0.00..3.12 rows=156 width=16) (actual time=0.003..0.003 rows=1 loops=1)

15. 0.001 0.001 ↑ 1.0 1 1

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

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

17. 0.001 0.001 ↑ 156.0 1 1

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

18. 1.052 13.390 ↑ 2.2 1,524 1

Nested Loop Left Join (cost=352.51..1,022.35 rows=3,350 width=407) (actual time=4.478..13.390 rows=1,524 loops=1)

  • Join Filter: (dn_1.responded_date <= (now())::timestamp without time zone)
19. 0.686 7.766 ↓ 15.1 1,524 1

Hash Join (cost=352.09..696.38 rows=101 width=181) (actual time=4.446..7.766 rows=1,524 loops=1)

  • Hash Cond: (dn_1.notification_uuid = ln.parent_ntfn_uuid)
20. 0.181 2.758 ↓ 17.0 1,715 1

Append (cost=0.56..344.58 rows=101 width=173) (actual time=0.053..2.758 rows=1,715 loops=1)

21. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx5 on notifications_summary_weekly_partitioned_2019_w5 dn_1 (cost=0.56..3.59 rows=1 width=111) (never executed)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx14 on notifications_summary_weekly_partitioned_2019_w14 dn_10 (cost=0.56..3.59 rows=1 width=111) (never executed)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx28 on notifications_summary_weekly_partitioned_2019_w28 dn_24 (cost=0.56..3.59 rows=1 width=111) (never executed)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx38 on notifications_summary_weekly_partitioned_2019_w38 dn_34 (cost=0.56..4.29 rows=1 width=111) (never executed)

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx40 on notifications_summary_weekly_partitioned_2019_w40 dn_36 (cost=0.56..3.59 rows=1 width=111) (never executed)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $6))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'DEVICE'::text))
74. 2.577 2.577 ↓ 1,715.0 1,715 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx54 on notifications_summary_weekly_partitioned_2020_w6 dn_54 (cost=0.56..3.59 rows=1 width=111) (actual time=0.040..2.577 rows=1,715 loops=1)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $6))
  • Filter: ((created_date <= $4) AND (created_date >= $5) AND (category = 'DEVICE'::text))
  • Rows Removed by Filter: 2280
75. 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 dn_55 (cost=0.56..3.59 rows=1 width=111) (never executed)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (created_date <= $4) AND (created_date >= $5))
  • Filter: ((event_uuid = $6) AND (category = 'DEVICE'::text))
122. 0.410 4.322 ↓ 15.1 1,524 1

Hash (cost=350.26..350.26 rows=101 width=24) (actual time=4.322..4.322 rows=1,524 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 100kB
123. 0.199 3.912 ↓ 15.1 1,524 1

Subquery Scan on ln (cost=348.24..350.26 rows=101 width=24) (actual time=3.480..3.912 rows=1,524 loops=1)

124. 1.202 3.713 ↓ 15.1 1,524 1

HashAggregate (cost=348.24..349.25 rows=101 width=24) (actual time=3.477..3.713 rows=1,524 loops=1)

  • Group Key: ln_1.parent_ntfn_uuid
125.          

Initplan (for HashAggregate)

126. 0.001 0.001 ↑ 156.0 1 1

CTE Scan on get_event get_event_2 (cost=0.00..3.12 rows=156 width=16) (actual time=0.001..0.001 rows=1 loops=1)

127. 0.001 0.001 ↑ 1.0 1 1

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

128. 0.000 0.000 ↑ 1.0 1 1

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

129. 0.152 2.509 ↓ 16.2 1,632 1

Append (cost=0.56..344.58 rows=101 width=24) (actual time=0.026..2.509 rows=1,632 loops=1)

130. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $7))
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = 'LIVE'::text))
183. 2.357 2.357 ↓ 1,632.0 1,632 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx54 on notifications_summary_weekly_partitioned_2020_w6 ln_54 (cost=0.56..3.59 rows=1 width=24) (actual time=0.020..2.357 rows=1,632 loops=1)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $7))
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = 'LIVE'::text))
  • Rows Removed by Filter: 2363
184. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: ((event_uuid = $7) AND (category = 'LIVE'::text))
231. 4.572 4.572 ↓ 0.0 0 1,524

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=0.003..0.003 rows=0 loops=1,524)

  • Index Cond: (notification_uuid = dn_1.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())::timestamp without time zone))
232.          

CTE get_event_person_notifications

233. 0.000 9.921 ↑ 5.7 587 1

Nested Loop Left Join (cost=4.14..723.70 rows=3,350 width=399) (actual time=2.242..9.921 rows=587 loops=1)

  • Join Filter: (pn_2.responded_date <= (now())::timestamp without time zone)
234.          

Initplan (for Nested Loop Left Join)

235. 0.001 0.001 ↑ 156.0 1 1

CTE Scan on get_event get_event_3 (cost=0.00..3.12 rows=156 width=16) (actual time=0.001..0.001 rows=1 loops=1)

236. 2.094 2.094 ↑ 1.0 1 1

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

237. 0.005 0.005 ↑ 1.0 1 1

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

238. 2.176 6.180 ↓ 5.8 587 1

Append (cost=0.56..344.58 rows=101 width=165) (actual time=2.174..6.180 rows=587 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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 pn_29 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 pn_31 (cost=0.56..3.58 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 pn_33 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 pn_35 (cost=0.56..4.29 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 pn_36 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 pn_37 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 pn_38 (cost=0.56..3.59 rows=1 width=104) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 pn_39 (cost=0.56..3.59 rows=1 width=104) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 pn_52 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
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 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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
291. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx4 on notifications_summary_weekly_partitioned_2020_w5 pn_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 = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
292. 4.004 4.004 ↓ 587.0 587 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx54 on notifications_summary_weekly_partitioned_2020_w6 pn_55 (cost=0.56..3.59 rows=1 width=103) (actual time=0.061..4.004 rows=587 loops=1)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
  • Rows Removed by Filter: 3408
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 pn_56 (cost=0.56..3.59 rows=1 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $12))
  • Filter: ((created_date <= $13) AND (created_date >= $14) AND (category = 'PERSON'::text))
294. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
295. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
296. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
297. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
298. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
299. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
300. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
301. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
302. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
303. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
304. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
305. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
306. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
307. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
308. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
309. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
310. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
311. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
312. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
313. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
314. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
315. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
316. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
317. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
318. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
319. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
320. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
321. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
322. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
323. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
324. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
325. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
326. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
327. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
328. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
329. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
330. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
331. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
332. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
333. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
334. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
335. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
336. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
337. 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_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 <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
338. 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_101 (cost=0.14..3.17 rows=1 width=238) (never executed)

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

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

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: ((event_uuid = $12) AND (category = 'PERSON'::text))
340. 3.522 3.522 ↓ 0.0 0 587

Index Scan using responses_org_part_72_notification_uuid_idx on responses_org_part_72 r_1 (cost=0.41..3.21 rows=1 width=250) (actual time=0.006..0.006 rows=0 loops=587)

  • Index Cond: (notification_uuid = pn_2.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()))
341.          

CTE get_team_groups

342. 0.025 12.500 ↑ 42.8 60 1

Recursive Union (cost=83.60..4,125.71 rows=2,570 width=86) (actual time=8.463..12.500 rows=60 loops=1)

343. 0.051 10.391 ↑ 1.7 30 1

Hash Join (cost=83.60..428.95 rows=50 width=86) (actual time=8.460..10.391 rows=30 loops=1)

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

Initplan (for Hash Join)

345. 0.002 0.002 ↑ 156.0 1 1

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

346. 0.002 0.002 ↑ 1.0 1 1

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

347. 0.002 0.002 ↑ 1.0 1 1

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

348. 0.021 2.017 ↑ 3.4 30 1

Append (cost=0.56..345.09 rows=101 width=66) (actual time=0.099..2.017 rows=30 loops=1)

349. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
350. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
351. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
352. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
353. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
354. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
355. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
356. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
357. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
358. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
359. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
360. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
361. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
362. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
363. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
364. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
365. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
366. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
367. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
368. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
369. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
370. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
371. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
372. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
373. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
374. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
375. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
376. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
377. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
378. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
379. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
380. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
381. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
382. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
383. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
384. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
385. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
386. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
387. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
388. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
389. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
390. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
391. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
392. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
393. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
394. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
395. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
396. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
397. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
398. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
399. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
400. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
401. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
402. 1.996 1.996 ↓ 30.0 30 1

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) (actual time=0.083..1.996 rows=30 loops=1)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
  • Rows Removed by Filter: 3965
403. 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 = $18))
  • Filter: ((created_date >= $20) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
404. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
405. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
406. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
407. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
408. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
409. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
410. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
411. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
412. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
413. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
414. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
415. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
416. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
417. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
418. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
419. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
420. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
421. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
422. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
423. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
424. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
425. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
426. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
427. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
428. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
429. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
430. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
431. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
432. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
433. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
434. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
435. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
436. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
437. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
438. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
439. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
440. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
441. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
442. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
443. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
444. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
445. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
446. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
447. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
448. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
449. 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 >= $20) AND (event_uuid = $18) AND (category = 'TEAM'::text) AND (created_date <= LEAST(now(), $19)))
450. 0.014 8.317 ↑ 6.5 31 1

Hash (cost=77.38..77.38 rows=200 width=16) (actual time=8.317..8.317 rows=31 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
451. 0.143 8.303 ↑ 6.5 31 1

HashAggregate (cost=75.38..77.38 rows=200 width=16) (actual time=8.298..8.303 rows=31 loops=1)

  • Group Key: get_event_person_notifications.team_ntfn_uuid
452. 8.160 8.160 ↑ 5.7 587 1

CTE Scan on get_event_person_notifications (cost=0.00..67.00 rows=3,350 width=16) (actual time=0.001..8.160 rows=587 loops=1)

453. 0.094 2.084 ↑ 16.8 15 2

Hash Join (cost=349.51..364.54 rows=252 width=86) (actual time=1.033..1.042 rows=15 loops=2)

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

Initplan (for Hash Join)

455. 0.002 0.002 ↑ 156.0 1 1

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

456. 0.001 0.001 ↑ 1.0 1 1

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

457. 0.001 0.001 ↑ 1.0 1 1

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

458. 0.008 0.008 ↑ 16.7 30 2

WorkTable Scan on get_team_groups tg_1 (cost=0.00..10.00 rows=500 width=36) (actual time=0.001..0.004 rows=30 loops=2)

459. 0.028 1.978 ↑ 1.7 60 1

Hash (cost=345.09..345.09 rows=101 width=66) (actual time=1.978..1.978 rows=60 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
460. 0.021 1.950 ↑ 1.7 60 1

Append (cost=0.56..345.09 rows=101 width=66) (actual time=0.096..1.950 rows=60 loops=1)

461. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
462. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
463. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
464. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
465. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
466. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
467. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
468. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
469. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
470. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
471. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
472. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
473. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
474. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
475. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
476. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
477. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
478. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
479. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
480. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
481. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
482. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
483. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
484. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
485. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
486. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
487. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
488. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
489. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
490. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
491. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
492. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
493. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
494. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
495. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
496. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
497. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
498. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
499. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
500. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
501. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
502. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
503. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
504. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
505. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
506. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
507. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
508. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
509. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
510. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
511. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
512. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
513. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
514. 1.929 1.929 ↓ 60.0 60 1

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) (actual time=0.082..1.929 rows=60 loops=1)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
  • Rows Removed by Filter: 3935
515. 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 = $21))
  • Filter: ((created_date >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST(now(), $22)))
516. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
517. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
518. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
519. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
520. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
521. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
522. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
523. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
524. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
525. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
526. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
527. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
528. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
529. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
530. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
531. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
532. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
533. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
534. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
535. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
536. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
537. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
538. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
539. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
540. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
541. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
542. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
543. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
544. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
545. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
546. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
547. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
548. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
549. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
550. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
551. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
552. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
553. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
554. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
555. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
556. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
557. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
558. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
559. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
560. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
561. 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 >= $23) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (event_uuid = $21) AND (created_date <= LEAST(now(), $22)))
562. 1.051 790.709 ↑ 84,712.6 604 1

Hash Left Join (cost=68.78..110,915.50 rows=51,166,411 width=406) (actual time=103.939..790.709 rows=604 loops=1)

  • Hash Cond: (pn.team_ntfn_uuid = grps.team_ntfn_uuid)
563. 1.486 697.950 ↑ 7,483.4 604 1

Nested Loop Left Join (cost=5.49..34,916.19 rows=4,520,001 width=374) (actual time=12.196..697.950 rows=604 loops=1)

564. 0.599 21.796 ↑ 76.4 604 1

Hash Join (cost=5.07..3,022.05 rows=46,146 width=352) (actual time=2.505..21.796 rows=604 loops=1)

  • Hash Cond: (pn.event_uuid = e.event_uuid)
565. 0.166 21.167 ↑ 97.9 604 1

Append (cost=0.00..2,333.67 rows=59,161 width=352) (actual time=2.351..21.167 rows=604 loops=1)

566. 2.833 2.833 ↑ 20.1 166 1

CTE Scan on get_event_person_notifications pn (cost=0.00..67.00 rows=3,333 width=352) (actual time=2.350..2.833 rows=166 loops=1)

  • Filter: (response IS NOT NULL)
  • Rows Removed by Filter: 421
567. 0.844 18.168 ↑ 127.5 438 1

Merge Join (cost=525.17..1,379.25 rows=55,828 width=352) (actual time=16.906..18.168 rows=438 loops=1)

  • Merge Cond: (dn.person_ntfn_uuid = pn_1.person_ntfn_uuid)
568. 0.671 16.725 ↑ 7.6 438 1

Sort (cost=262.02..270.36 rows=3,333 width=328) (actual time=16.524..16.725 rows=438 loops=1)

  • Sort Key: dn.person_ntfn_uuid
  • Sort Method: quicksort Memory: 86kB
569. 16.054 16.054 ↑ 7.6 438 1

CTE Scan on get_event_device_notifications dn (cost=0.00..67.00 rows=3,333 width=328) (actual time=4.537..16.054 rows=438 loops=1)

  • Filter: (response IS NOT NULL)
  • Rows Removed by Filter: 1086
570. 0.484 0.599 ↑ 5.7 587 1

Sort (cost=263.14..271.52 rows=3,350 width=48) (actual time=0.369..0.599 rows=587 loops=1)

  • Sort Key: pn_1.person_ntfn_uuid
  • Sort Method: quicksort Memory: 70kB
571. 0.115 0.115 ↑ 5.7 587 1

CTE Scan on get_event_person_notifications pn_1 (cost=0.00..67.00 rows=3,350 width=48) (actual time=0.003..0.115 rows=587 loops=1)

572. 0.028 0.030 ↑ 156.0 1 1

Hash (cost=3.12..3.12 rows=156 width=16) (actual time=0.029..0.030 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
573. 0.002 0.002 ↑ 156.0 1 1

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

574. 674.668 674.668 ↑ 1.0 1 604

Index Scan using persons_org_part_10_l2_t_org_seq_vrange_uidx on persons_org_part_10_l2_t p (cost=0.41..0.68 rows=1 width=38) (actual time=1.109..1.117 rows=1 loops=604)

  • Index Cond: (person_uuid = pn.person_uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid))
575. 0.122 91.708 ↓ 2.7 30 1

Hash (cost=63.16..63.16 rows=11 width=48) (actual time=91.708..91.708 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
576. 0.059 91.586 ↓ 2.7 30 1

Nested Loop Left Join (cost=58.35..63.16 rows=11 width=48) (actual time=23.938..91.586 rows=30 loops=1)

577. 0.024 12.927 ↓ 30.0 30 1

Subquery Scan on grps (cost=58.07..58.49 rows=1 width=32) (actual time=12.762..12.927 rows=30 loops=1)

  • Filter: (grps."row" = 1)
578. 0.163 12.903 ↓ 2.3 30 1

WindowAgg (cost=58.07..58.33 rows=13 width=60) (actual time=12.758..12.903 rows=30 loops=1)

579. 0.158 12.740 ↓ 2.3 30 1

Sort (cost=58.07..58.10 rows=13 width=36) (actual time=12.725..12.740 rows=30 loops=1)

  • Sort Key: tg.root_uuid, tg.group_level DESC
  • Sort Method: quicksort Memory: 27kB
580. 12.582 12.582 ↓ 2.3 30 1

CTE Scan on get_team_groups tg (cost=0.00..57.82 rows=13 width=36) (actual time=12.497..12.582 rows=30 loops=1)

  • Filter: (category = 'GROUP'::text)
  • Rows Removed by Filter: 30
581. 78.600 78.600 ↑ 1.0 1 30

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=2.003..2.620 rows=1 loops=30)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (group_uuid = grps.group_uuid))
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE))
  • Rows Removed by Filter: 2
Planning time : 308.398 ms
Execution time : 818.161 ms