explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CjMp

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 9,570.295 ↑ 39,279.1 1,723 1

Merge Left Join (cost=126,684.01..2,158,608.53 rows=67,677,804 width=701) (actual time=9,553.032..9,570.295 rows=1,723 loops=1)

  • Merge Cond: (pn.notification_uuid = dn.parent_ntfn_uuid)
2.          

CTE get_event

3. 83.223 96.757 ↑ 120.0 1 1

Bitmap Heap Scan on events_org_part_252 e (cost=7.64..500.70 rows=120 width=105) (actual time=96.756..96.757 rows=1 loops=1)

  • Recheck Cond: (event_uuid = 'ea9f3ff8-f347-4fa9-bd4e-c56ec11dec8d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid))
  • Rows Removed by Filter: 364
  • Heap Blocks: exact=125
4. 13.534 13.534 ↓ 1.0 365 1

Bitmap Index Scan on events_org_part_252_event_uuid_idx (cost=0.00..7.61 rows=360 width=0) (actual time=13.534..13.534 rows=365 loops=1)

  • Index Cond: (event_uuid = 'ea9f3ff8-f347-4fa9-bd4e-c56ec11dec8d'::uuid)
5.          

CTE get_event_created_min

6. 0.009 0.010 ↑ 1.0 1 1

Aggregate (cost=2.70..2.71 rows=1 width=8) (actual time=0.009..0.010 rows=1 loops=1)

7. 0.001 0.001 ↑ 120.0 1 1

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

8.          

CTE get_event_closing_max

9. 0.025 96.788 ↑ 1.0 1 1

Aggregate (cost=3.60..3.61 rows=1 width=8) (actual time=96.788..96.788 rows=1 loops=1)

10. 96.763 96.763 ↑ 120.0 1 1

CTE Scan on get_event e_2 (cost=0.00..2.40 rows=120 width=16) (actual time=96.761..96.763 rows=1 loops=1)

11.          

Initplan (for Merge Left Join)

12. 96.792 96.792 ↑ 1.0 1 1

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

13. 0.011 0.011 ↑ 1.0 1 1

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

14. 0.002 0.002 ↑ 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.002..0.002 rows=1 loops=1)

15. 0.001 0.001 ↑ 1.0 1 1

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

16. 0.002 0.002 ↑ 1.0 1 1

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

17. 0.001 0.001 ↑ 1.0 1 1

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

18. 6.443 9,436.394 ↑ 93.9 578 1

Merge Left Join (cost=25,876.74..26,694.35 rows=54,268 width=342) (actual time=9,420.652..9,436.394 rows=578 loops=1)

  • Merge Cond: (pn.notification_uuid = r.notification_uuid)
19. 1.962 9,259.184 ↑ 1.0 578 1

Sort (cost=21,938.59..21,940.04 rows=580 width=108) (actual time=9,259.138..9,259.184 rows=578 loops=1)

  • Sort Key: pn.notification_uuid
  • Sort Method: quicksort Memory: 106kB
20. 2.030 9,257.222 ↑ 1.0 578 1

Hash Semi Join (cost=4.46..21,911.97 rows=580 width=108) (actual time=669.174..9,257.222 rows=578 loops=1)

  • Hash Cond: (pn.event_uuid = get_event.event_uuid)
21. 97.398 9,255.181 ↑ 1.3 887 1

Append (cost=0.56..21,898.58 rows=1,159 width=109) (actual time=669.055..9,255.181 rows=887 loops=1)

22. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient_u_idx on notifications_summary_weekly_partitioned_2019_w5 pn (cost=0.56..125.14 rows=7 width=103) (never executed)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx8 on notifications_summary_weekly_partitioned_2019_w13 pn_8 (cost=0.56..111.56 rows=6 width=103) (never executed)

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx10 on notifications_summary_weekly_partitioned_2019_w15 pn_10 (cost=0.56..121.55 rows=7 width=103) (never executed)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Index Scan using notifications_summary_weekly_partitioned_2019_w23_pkey on notifications_summary_weekly_partitioned_2019_w23 pn_18 (cost=0.56..143.13 rows=8 width=103) (never executed)

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

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

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx21 on notifications_summary_weekly_partitioned_2019_w26 pn_21 (cost=0.56..148.12 rows=9 width=103) (never executed)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx30 on notifications_summary_weekly_partitioned_2019_w35 pn_30 (cost=0.56..1,038.43 rows=57 width=103) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx31 on notifications_summary_weekly_partitioned_2019_w36 pn_31 (cost=0.56..1,385.99 rows=74 width=103) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx32 on notifications_summary_weekly_partitioned_2019_w37 pn_32 (cost=0.56..144.44 rows=8 width=103) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx33 on notifications_summary_weekly_partitioned_2019_w38 pn_33 (cost=0.56..2,306.13 rows=134 width=103) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx34 on notifications_summary_weekly_partitioned_2019_w39 pn_34 (cost=0.56..149.42 rows=8 width=103) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx35 on notifications_summary_weekly_partitioned_2019_w40 pn_35 (cost=0.56..145.99 rows=7 width=103) (never executed)

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

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

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

Index Scan using notifications_summary_weekly_partitioned_2019_w42_pkey on notifications_summary_weekly_partitioned_2019_w42 pn_37 (cost=0.56..1,132.41 rows=49 width=104) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx38 on notifications_summary_weekly_partitioned_2019_w43 pn_38 (cost=0.56..1,579.81 rows=78 width=103) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx39 on notifications_summary_weekly_partitioned_2019_w44 pn_39 (cost=0.56..1,317.27 rows=66 width=103) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx40 on notifications_summary_weekly_partitioned_2019_w45 pn_40 (cost=0.56..136.23 rows=7 width=103) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx41 on notifications_summary_weekly_partitioned_2019_w46 pn_41 (cost=0.56..1,357.55 rows=67 width=103) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx42 on notifications_summary_weekly_partitioned_2019_w47 pn_42 (cost=0.56..1,381.60 rows=68 width=103) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx43 on notifications_summary_weekly_partitioned_2019_w48 pn_43 (cost=0.56..818.16 rows=40 width=103) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx44 on notifications_summary_weekly_partitioned_2019_w49 pn_44 (cost=0.56..142.36 rows=8 width=103) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx45 on notifications_summary_weekly_partitioned_2019_w50 pn_45 (cost=0.56..145.54 rows=8 width=103) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx46 on notifications_summary_weekly_partitioned_2019_w51 pn_46 (cost=0.56..1,616.46 rows=83 width=103) (never executed)

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

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

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx50 on notifications_summary_weekly_partitioned_2020_w2 pn_49 (cost=0.56..534.39 rows=27 width=103) (never executed)

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx52 on notifications_summary_weekly_partitioned_2020_w4 pn_51 (cost=0.56..150.82 rows=8 width=103) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (created_date <= $3) AND (created_date >= $4))
  • Filter: (category = 'PERSON'::text)
74. 9,157.783 9,157.783 ↓ 13.0 887 1

Index Scan using notifications_summary_weekly_partitioned_2020_w5_pkey on notifications_summary_weekly_partitioned_2020_w5 pn_52 (cost=0.56..1,573.31 rows=68 width=103) (actual time=572.233..9,157.783 rows=887 loops=1)

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

Index Scan using notifications_summary_weekly_partitioned_2020_w6_pkey on notifications_summary_weekly_partitioned_2020_w6 pn_53 (cost=0.56..461.59 rows=20 width=103) (never executed)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $3) AND (created_date >= $4) AND (category = 'PERSON'::text))
123. 0.007 0.011 ↑ 120.0 1 1

Hash (cost=2.40..2.40 rows=120 width=16) (actual time=0.010..0.011 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
124. 0.004 0.004 ↑ 120.0 1 1

CTE Scan on get_event (cost=0.00..2.40 rows=120 width=16) (actual time=0.004..0.004 rows=1 loops=1)

125. 81.646 170.767 ↓ 3.0 56,116 1

Sort (cost=3,938.15..3,984.97 rows=18,729 width=250) (actual time=161.437..170.767 rows=56,116 loops=1)

  • Sort Key: r.notification_uuid
  • Sort Method: external sort Disk: 4440kB
126. 89.121 89.121 ↓ 3.0 56,140 1

Seq Scan on responses_org_part_72 r (cost=0.00..2,609.05 rows=18,729 width=250) (actual time=0.056..89.121 rows=56,140 loops=1)

  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND ((response)::text <> 'XMATTERS_REMOVE'::text) AND (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (received <= now()))
  • Rows Removed by Filter: 721
127. 0.366 132.964 ↑ 144.8 1,722 1

Materialize (cost=100,300.12..101,547.24 rows=249,424 width=359) (actual time=132.366..132.964 rows=1,722 loops=1)

128. 1.304 132.598 ↑ 144.8 1,722 1

Sort (cost=100,300.12..100,923.68 rows=249,424 width=359) (actual time=132.360..132.598 rows=1,722 loops=1)

  • Sort Key: dn.parent_ntfn_uuid
  • Sort Method: quicksort Memory: 473kB
129. 6.868 131.294 ↑ 144.8 1,722 1

Merge Left Join (cost=47,843.35..51,634.45 rows=249,424 width=359) (actual time=113.379..131.294 rows=1,722 loops=1)

  • Merge Cond: (dn.notification_uuid = r_1.notification_uuid)
130. 1.031 26.278 ↑ 1.5 1,722 1

Merge Join (cost=43,905.20..43,947.59 rows=2,664 width=125) (actual time=24.719..26.278 rows=1,722 loops=1)

  • Merge Cond: (ln.parent_ntfn_uuid = dn.notification_uuid)
131. 0.929 13.215 ↓ 3.5 1,722 1

Sort (cost=21,936.94..21,938.18 rows=496 width=24) (actual time=12.942..13.215 rows=1,722 loops=1)

  • Sort Key: ln.parent_ntfn_uuid
  • Sort Method: quicksort Memory: 183kB
132. 0.556 12.286 ↓ 3.5 1,722 1

Hash Semi Join (cost=4.46..21,914.74 rows=496 width=24) (actual time=0.080..12.286 rows=1,722 loops=1)

  • Hash Cond: (ln.event_uuid = get_event_1.event_uuid)
133. 0.266 11.725 ↓ 2.7 2,681 1

Append (cost=0.56..21,902.71 rows=993 width=40) (actual time=0.057..11.725 rows=2,681 loops=1)

134. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx30 on notifications_summary_weekly_partitioned_2019_w35 ln_30 (cost=0.56..1,038.68 rows=50 width=40) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx31 on notifications_summary_weekly_partitioned_2019_w36 ln_31 (cost=0.56..1,386.32 rows=67 width=40) (never executed)

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx33 on notifications_summary_weekly_partitioned_2019_w38 ln_33 (cost=0.56..2,306.69 rows=112 width=40) (never executed)

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

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

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

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

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

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

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

Index Scan using notifications_summary_weekly_partitioned_2019_w42_pkey on notifications_summary_weekly_partitioned_2019_w42 ln_37 (cost=0.56..1,132.62 rows=42 width=40) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx38 on notifications_summary_weekly_partitioned_2019_w43 ln_38 (cost=0.56..1,580.14 rows=66 width=40) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx39 on notifications_summary_weekly_partitioned_2019_w44 ln_39 (cost=0.56..1,317.54 rows=55 width=40) (never executed)

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx41 on notifications_summary_weekly_partitioned_2019_w46 ln_41 (cost=0.56..1,357.83 rows=56 width=40) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx42 on notifications_summary_weekly_partitioned_2019_w47 ln_42 (cost=0.56..1,381.90 rows=59 width=40) (never executed)

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

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

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

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

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx46 on notifications_summary_weekly_partitioned_2019_w51 ln_46 (cost=0.56..1,616.80 rows=67 width=40) (never executed)

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

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

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

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

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

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

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx52 on notifications_summary_weekly_partitioned_2020_w4 ln_51 (cost=0.56..150.85 rows=6 width=40) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (created_date <= $7) AND (created_date >= $8))
  • Filter: (category = 'LIVE'::text)
186. 11.459 11.459 ↓ 49.6 2,681 1

Index Scan using notifications_summary_weekly_partitioned_2020_w5_pkey on notifications_summary_weekly_partitioned_2020_w5 ln_52 (cost=0.56..1,573.58 rows=54 width=40) (actual time=0.044..11.459 rows=2,681 loops=1)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (created_date <= $7) AND (created_date >= $8))
  • Filter: (category = 'LIVE'::text)
235. 0.003 0.005 ↑ 120.0 1 1

Hash (cost=2.40..2.40 rows=120 width=16) (actual time=0.005..0.005 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
236. 0.002 0.002 ↑ 120.0 1 1

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

237. 1.554 12.032 ↓ 3.1 3,360 1

Sort (cost=21,968.25..21,970.94 rows=1,073 width=117) (actual time=11.764..12.032 rows=3,360 loops=1)

  • Sort Key: dn.notification_uuid
  • Sort Method: quicksort Memory: 598kB
238. 0.291 10.478 ↓ 3.0 3,205 1

Append (cost=0.56..21,914.24 rows=1,073 width=117) (actual time=0.055..10.478 rows=3,205 loops=1)

239. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx30 on notifications_summary_weekly_partitioned_2019_w35 dn_30 (cost=0.56..1,039.25 rows=55 width=111) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx31 on notifications_summary_weekly_partitioned_2019_w36 dn_31 (cost=0.56..1,387.10 rows=74 width=111) (never executed)

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx33 on notifications_summary_weekly_partitioned_2019_w38 dn_33 (cost=0.56..2,307.90 rows=118 width=111) (never executed)

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

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

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

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

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

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

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

Index Scan using notifications_summary_weekly_partitioned_2019_w42_pkey on notifications_summary_weekly_partitioned_2019_w42 dn_37 (cost=0.56..1,133.10 rows=46 width=112) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx38 on notifications_summary_weekly_partitioned_2019_w43 dn_38 (cost=0.56..1,580.87 rows=71 width=111) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx39 on notifications_summary_weekly_partitioned_2019_w44 dn_39 (cost=0.56..1,318.15 rows=59 width=111) (never executed)

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx41 on notifications_summary_weekly_partitioned_2019_w46 dn_41 (cost=0.56..1,358.45 rows=60 width=111) (never executed)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx42 on notifications_summary_weekly_partitioned_2019_w47 dn_42 (cost=0.56..1,382.53 rows=62 width=111) (never executed)

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

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

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

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

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx46 on notifications_summary_weekly_partitioned_2019_w51 dn_46 (cost=0.56..1,617.54 rows=72 width=111) (never executed)

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

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

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

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

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

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

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

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

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx52 on notifications_summary_weekly_partitioned_2020_w4 dn_51 (cost=0.56..150.93 rows=7 width=111) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'DEVICE'::text)
291. 10.187 10.187 ↓ 52.5 3,205 1

Index Scan using notifications_summary_weekly_partitioned_2020_w5_pkey on notifications_summary_weekly_partitioned_2020_w5 dn_52 (cost=0.56..1,574.22 rows=61 width=111) (actual time=0.030..10.187 rows=3,205 loops=1)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (created_date <= $5) AND (created_date >= $6))
  • Filter: (category = 'DEVICE'::text)
340. 73.671 98.148 ↓ 3.0 56,130 1

Sort (cost=3,938.15..3,984.97 rows=18,729 width=250) (actual time=88.642..98.148 rows=56,130 loops=1)

  • Sort Key: r_1.notification_uuid
  • Sort Method: external sort Disk: 4440kB
341. 24.477 24.477 ↓ 3.0 56,140 1

Seq Scan on responses_org_part_72 r_1 (cost=0.00..2,609.05 rows=18,729 width=250) (actual time=0.033..24.477 rows=56,140 loops=1)

  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND ((response)::text <> 'XMATTERS_REMOVE'::text) AND (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (received <= now()))
  • Rows Removed by Filter: 721
Planning time : 187.072 ms
Execution time : 9,582.809 ms