explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mc3K0 : Notified Permission Query - Move clause to second select

Settings
# exclusive inclusive rows x rows loops node
1. 0.344 10,597.529 ↑ 1.0 100 1

Sort (cost=1,860,017.07..1,860,017.32 rows=100 width=620) (actual time=10,597.524..10,597.529 rows=100 loops=1)

  • Sort Key: e.event_id DESC
  • Sort Method: quicksort Memory: 76kB
2.          

CTE filtered_events

3. 0.086 10,594.773 ↑ 1.0 100 1

Limit (cost=1,859,811.40..1,859,811.65 rows=100 width=640) (actual time=10,594.679..10,594.773 rows=100 loops=1)

4. 4.018 10,594.687 ↑ 136,205.9 100 1

Sort (cost=1,859,811.40..1,893,862.88 rows=13,620,590 width=640) (actual time=10,594.677..10,594.687 rows=100 loops=1)

  • Sort Key: e_2.event_id DESC
  • Sort Method: top-N heapsort Memory: 105kB
5. 2.404 10,590.669 ↑ 6,347.0 2,146 1

Hash Left Join (cost=475,877.44..1,339,242.25 rows=13,620,590 width=640) (actual time=9,254.619..10,590.669 rows=2,146 loops=1)

  • Hash Cond: (e_2.submitter_uuid = p.person_uuid)
6. 5.074 10,520.588 ↑ 321.2 2,146 1

Hash Left Join (cost=472,529.19..857,623.19 rows=689,300 width=618) (actual time=9,186.924..10,520.588 rows=2,146 loops=1)

  • Hash Cond: (e_2.form_uuid = f.form_uuid)
  • Join Filter: (f.valid_range @> e_2.created)
  • Rows Removed by Join Filter: 18,831
7. 23.028 10,513.719 ↑ 321.2 2,146 1

Hash Left Join (cost=472,408.35..788,558.93 rows=689,300 width=597) (actual time=9,185.111..10,513.719 rows=2,146 loops=1)

  • Hash Cond: (e_2.plan_uuid = pl.plan_uuid)
  • Join Filter: (pl.valid_range @> e_2.created)
  • Rows Removed by Join Filter: 120,286
  • Filter: ((pl.plan_uuid IS NULL) OR ((pl.name)::text <> ALL ('{"Voice Recording Notifications","Error Response Notifications","User Upload Onboarding Notifications","Data Upload Notifications"}'::text[])))
8. 172.490 10,488.238 ↑ 326.3 2,146 1

Merge Left Join (cost=472,217.59..678,749.57 rows=700,343 width=570) (actual time=9,182.607..10,488.238 rows=2,146 loops=1)

  • Merge Cond: (e_2.event_uuid = ns.event_uuid)
  • Join Filter: ((ns.created_date >= e_2.created) AND (ns.created_date <= LEAST(e_2.terminated, (e_2.created + '1 mon'::interval))))
  • Filter: ((e_2.submitter_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) OR (ns.recipient_uuid IS NOT NULL))
  • Rows Removed by Filter: 1,291,778
9. 631.099 5,595.521 ↓ 3.0 1,293,924 1

Unique (cost=446,230.39..473,172.39 rows=431,072 width=570) (actual time=4,461.970..5,595.521 rows=1,293,924 loops=1)

10. 2,625.605 4,964.422 ↓ 3.0 1,293,924 1

Sort (cost=446,230.39..447,308.07 rows=431,072 width=570) (actual time=4,461.968..4,964.422 rows=1,293,924 loops=1)

  • Sort Key: e_2.event_uuid, e_2.event_id, e_2.submitter_uuid, e_2.priority, e_2.incident_id, e_2.override_device_restrictions, e_2.escalation_override, e_2.bypass_phone_intro, e_2.require_phone_password, e_2.conference_properties, e_2.created, e_2.status, e_2.terminated, e_2.request_uuid, e_2.sequence, e_2.revision_uuid, e_2.event_type, e_2.system_event_type, e_2.form_uuid, e_2.plan_uuid, e_2.choices, (lower(e_2.valid_range)), (upper(e_2.valid_range)), e_2.recipients
  • Sort Method: external merge Disk: 282,752kB
11. 108.048 2,338.817 ↓ 3.0 1,293,924 1

Append (cost=0.00..334,848.04 rows=431,072 width=570) (actual time=0.038..2,338.817 rows=1,293,924 loops=1)

  • Subplans Removed: 11
12. 209.490 209.490 ↓ 3.0 118,523 1

Seq Scan on events_org_part_12_l3_t_2018 e_2 (cost=0.00..28,906.72 rows=39,485 width=570) (actual time=0.035..209.490 rows=118,523 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 1,401
13. 93.203 93.203 ↓ 3.0 57,310 1

Seq Scan on events_org_part_12_l3_t_201901 e_3 (cost=0.00..13,045.67 rows=19,075 width=570) (actual time=0.025..93.203 rows=57,310 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 570
14. 82.531 82.531 ↓ 3.0 49,476 1

Seq Scan on events_org_part_12_l3_t_201902 e_4 (cost=0.00..11,213.37 rows=16,486 width=570) (actual time=0.024..82.531 rows=49,476 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 388
15. 157.789 157.789 ↓ 3.0 89,303 1

Seq Scan on events_org_part_12_l3_t_201903 e_5 (cost=0.00..22,988.84 rows=29,759 width=570) (actual time=0.032..157.789 rows=89,303 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 477
16. 179.759 179.759 ↓ 3.0 109,620 1

Seq Scan on events_org_part_12_l3_t_201904 e_6 (cost=0.00..26,642.31 rows=36,533 width=570) (actual time=0.030..179.759 rows=109,620 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 542
17. 163.802 163.802 ↓ 3.0 100,873 1

Seq Scan on events_org_part_12_l3_t_201905 e_7 (cost=0.00..23,028.21 rows=33,612 width=570) (actual time=0.022..163.802 rows=100,873 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 556
18. 168.974 168.974 ↓ 3.0 106,391 1

Seq Scan on events_org_part_12_l3_t_201906 e_8 (cost=0.00..24,403.11 rows=35,448 width=570) (actual time=0.034..168.974 rows=106,391 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 670
19. 374.897 374.897 ↓ 3.0 228,014 1

Seq Scan on events_org_part_12_l3_t_201907 e_9 (cost=0.00..52,596.96 rows=75,973 width=570) (actual time=0.031..374.897 rows=228,014 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 1,087
20. 182.013 182.013 ↓ 3.0 104,403 1

Seq Scan on events_org_part_12_l3_t_201908 e_10 (cost=0.00..27,599.92 rows=34,768 width=570) (actual time=0.025..182.013 rows=104,403 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 623
21. 145.581 145.581 ↓ 3.0 80,457 1

Seq Scan on events_org_part_12_l3_t_201909 e_11 (cost=0.00..24,480.31 rows=26,828 width=570) (actual time=0.023..145.581 rows=80,457 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 484
22. 136.875 136.875 ↓ 3.0 78,697 1

Seq Scan on events_org_part_12_l3_t_201910 e_12 (cost=0.00..21,048.41 rows=26,234 width=570) (actual time=0.023..136.875 rows=78,697 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 425
23. 163.619 163.619 ↓ 3.0 75,696 1

Seq Scan on events_org_part_12_l3_t_201911 e_13 (cost=0.00..28,973.10 rows=25,228 width=570) (actual time=0.034..163.619 rows=75,696 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 302
24. 128.163 128.163 ↓ 3.0 71,419 1

Seq Scan on events_org_part_12_l3_t_201912 e_14 (cost=0.00..20,390.72 rows=23,796 width=570) (actual time=0.028..128.163 rows=71,419 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 347
25. 44.073 44.073 ↓ 3.0 23,742 1

Seq Scan on events_org_part_12_l3_t_202001 e_15 (cost=0.00..7,340.09 rows=7,836 width=570) (actual time=0.024..44.073 rows=23,742 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 176
26. 3.378 4,720.227 ↑ 1.5 1,993 1

Sort (cost=25,987.20..25,994.55 rows=2,939 width=40) (actual time=4,719.355..4,720.227 rows=1,993 loops=1)

  • Sort Key: ns.event_uuid
  • Sort Method: quicksort Memory: 186kB
27. 0.873 4,716.849 ↑ 1.7 1,755 1

Append (cost=0.56..25,817.90 rows=2,939 width=40) (actual time=0.191..4,716.849 rows=1,755 loops=1)

28. 1.389 1.389 ↓ 8.3 25 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient_u_idx on notifications_summary_weekly_partitioned_2019_w5 ns (cost=0.56..11.84 rows=3 width=40) (actual time=0.189..1.389 rows=25 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 86
29. 1.411 1.411 ↓ 14.7 44 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx1 on notifications_summary_weekly_partitioned_2019_w6 ns_1 (cost=0.56..11.12 rows=3 width=40) (actual time=0.168..1.411 rows=44 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 87
30. 1.328 1.328 ↓ 14.3 43 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx2 on notifications_summary_weekly_partitioned_2019_w7 ns_2 (cost=0.56..11.80 rows=3 width=40) (actual time=0.075..1.328 rows=43 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 66
31. 1.240 1.240 ↓ 18.0 18 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx3 on notifications_summary_weekly_partitioned_2019_w8 ns_3 (cost=0.56..7.70 rows=1 width=40) (actual time=0.225..1.240 rows=18 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 94
32. 1.715 1.715 ↓ 18.0 54 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx4 on notifications_summary_weekly_partitioned_2019_w9 ns_4 (cost=0.56..13.19 rows=3 width=40) (actual time=0.170..1.715 rows=54 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 92
33. 1.286 1.286 ↓ 17.0 34 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx5 on notifications_summary_weekly_partitioned_2019_w10 ns_5 (cost=0.56..9.81 rows=2 width=40) (actual time=0.124..1.286 rows=34 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 81
34. 1.937 1.937 ↓ 13.8 55 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx6 on notifications_summary_weekly_partitioned_2019_w11 ns_6 (cost=0.56..15.23 rows=4 width=40) (actual time=0.135..1.937 rows=55 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 95
35. 2.525 2.525 ↓ 13.3 40 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx7 on notifications_summary_weekly_partitioned_2019_w12 ns_7 (cost=0.56..13.85 rows=3 width=40) (actual time=0.196..2.525 rows=40 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 90
36. 1.998 1.998 ↓ 6.0 18 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx8 on notifications_summary_weekly_partitioned_2019_w13 ns_8 (cost=0.56..12.49 rows=3 width=40) (actual time=0.239..1.998 rows=18 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 87
37. 2.542 2.542 ↓ 9.8 39 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx9 on notifications_summary_weekly_partitioned_2019_w14 ns_9 (cost=0.56..17.33 rows=4 width=40) (actual time=0.260..2.542 rows=39 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 104
38. 2.805 2.805 ↓ 8.6 43 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx10 on notifications_summary_weekly_partitioned_2019_w15 ns_10 (cost=0.56..17.55 rows=5 width=40) (actual time=0.330..2.805 rows=43 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 134
39. 1.207 1.207 ↓ 3.0 12 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx11 on notifications_summary_weekly_partitioned_2019_w16 ns_11 (cost=0.56..15.51 rows=4 width=40) (actual time=0.250..1.207 rows=12 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 87
40. 1.209 1.209 ↓ 7.4 37 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx12 on notifications_summary_weekly_partitioned_2019_w17 ns_12 (cost=0.56..17.71 rows=5 width=40) (actual time=0.109..1.209 rows=37 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 58
41. 1.567 1.567 ↓ 9.0 45 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx13 on notifications_summary_weekly_partitioned_2019_w18 ns_13 (cost=0.56..19.34 rows=5 width=40) (actual time=0.101..1.567 rows=45 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 90
42. 1.253 1.253 ↓ 6.8 27 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx14 on notifications_summary_weekly_partitioned_2019_w19 ns_14 (cost=0.56..16.09 rows=4 width=40) (actual time=0.121..1.253 rows=27 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 66
43. 1.634 1.634 ↓ 10.3 62 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx15 on notifications_summary_weekly_partitioned_2019_w20 ns_15 (cost=0.56..22.07 rows=6 width=40) (actual time=0.109..1.634 rows=62 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 81
44. 2.155 2.155 ↓ 12.4 62 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx16 on notifications_summary_weekly_partitioned_2019_w21 ns_16 (cost=0.56..20.43 rows=5 width=40) (actual time=0.098..2.155 rows=62 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 137
45. 1.805 1.805 ↓ 11.5 46 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx17 on notifications_summary_weekly_partitioned_2019_w22 ns_17 (cost=0.56..15.43 rows=4 width=40) (actual time=0.344..1.805 rows=46 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 125
46. 1.647 1.647 ↓ 11.8 47 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx18 on notifications_summary_weekly_partitioned_2019_w23 ns_18 (cost=0.56..16.59 rows=4 width=40) (actual time=0.236..1.647 rows=47 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 80
47. 1.648 1.648 ↓ 12.2 49 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx19 on notifications_summary_weekly_partitioned_2019_w24 ns_19 (cost=0.56..15.22 rows=4 width=40) (actual time=0.132..1.648 rows=49 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 97
48. 1.899 1.899 ↓ 9.2 37 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx20 on notifications_summary_weekly_partitioned_2019_w25 ns_20 (cost=0.56..16.58 rows=4 width=40) (actual time=0.186..1.899 rows=37 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 135
49. 2.311 2.311 ↓ 12.8 64 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx21 on notifications_summary_weekly_partitioned_2019_w26 ns_21 (cost=0.56..20.04 rows=5 width=40) (actual time=0.090..2.311 rows=64 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 127
50. 1.482 1.482 ↓ 9.0 36 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx22 on notifications_summary_weekly_partitioned_2019_w27 ns_22 (cost=0.56..15.90 rows=4 width=40) (actual time=0.233..1.482 rows=36 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 94
51. 1.074 1.074 ↓ 6.2 25 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx23 on notifications_summary_weekly_partitioned_2019_w28 ns_23 (cost=0.56..14.83 rows=4 width=40) (actual time=0.129..1.074 rows=25 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 68
52. 1.756 1.756 ↓ 8.5 34 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx24 on notifications_summary_weekly_partitioned_2019_w29 ns_24 (cost=0.56..17.30 rows=4 width=40) (actual time=0.206..1.756 rows=34 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 120
53. 1.852 1.852 ↓ 14.5 58 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx25 on notifications_summary_weekly_partitioned_2019_w30 ns_25 (cost=0.56..15.91 rows=4 width=40) (actual time=0.139..1.852 rows=58 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 116
54. 1.484 1.484 ↓ 8.3 25 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx26 on notifications_summary_weekly_partitioned_2019_w31 ns_26 (cost=0.56..13.16 rows=3 width=40) (actual time=0.133..1.484 rows=25 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 110
55. 1.446 1.446 ↓ 9.0 36 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx27 on notifications_summary_weekly_partitioned_2019_w32 ns_27 (cost=0.56..15.50 rows=4 width=40) (actual time=0.156..1.446 rows=36 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 98
56. 0.785 0.785 ↓ 16.5 33 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx28 on notifications_summary_weekly_partitioned_2019_w33 ns_28 (cost=0.56..9.08 rows=2 width=40) (actual time=0.170..0.785 rows=33 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 38
57. 0.140 0.140 ↓ 3.0 3 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx29 on notifications_summary_weekly_partitioned_2019_w34 ns_29 (cost=0.56..3.58 rows=1 width=40) (actual time=0.081..0.140 rows=3 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 4
58. 1.275 1.275 ↓ 14.3 43 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx30 on notifications_summary_weekly_partitioned_2019_w35 ns_30 (cost=0.56..13.33 rows=3 width=40) (actual time=0.119..1.275 rows=43 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 81
59. 28.947 28.947 ↓ 7.7 23 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx31 on notifications_summary_weekly_partitioned_2019_w36 ns_31 (cost=0.56..11.96 rows=3 width=40) (actual time=0.153..28.947 rows=23 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 3,696
60. 96.516 96.516 ↑ 3.8 24 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx32 on notifications_summary_weekly_partitioned_2019_w37 ns_32 (cost=0.56..321.14 rows=91 width=40) (actual time=7.185..96.516 rows=24 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 13,022
61. 153.021 153.021 ↑ 7.8 24 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx33 on notifications_summary_weekly_partitioned_2019_w38 ns_33 (cost=0.56..652.93 rows=186 width=40) (actual time=9.737..153.021 rows=24 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 19,562
62. 134.593 134.593 ↑ 3.9 41 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx34 on notifications_summary_weekly_partitioned_2019_w39 ns_34 (cost=0.56..628.14 rows=161 width=40) (actual time=8.971..134.593 rows=41 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 18,083
63. 232.341 238.582 ↑ 11.0 1 1

Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w40 ns_35 (cost=23.89..1,718.89 rows=11 width=40) (actual time=15.428..238.582 rows=1 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 20,517
  • Heap Blocks: exact=18,561
64. 6.241 6.241 ↓ 18.1 20,518 1

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx35 (cost=0.00..23.88 rows=1,132 width=0) (actual time=6.226..6.241 rows=20,518 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
65. 382.670 389.776 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w41 ns_36 (cost=41.12..2,736.15 rows=1 width=40) (actual time=389.775..389.776 rows=0 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 20,179
  • Heap Blocks: exact=17,861
66. 7.106 7.106 ↓ 11.2 20,179 1

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx36 (cost=0.00..41.12 rows=1,806 width=0) (actual time=7.106..7.106 rows=20,179 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
67. 544.011 544.011 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx37 on notifications_summary_weekly_partitioned_2019_w42 ns_37 (cost=0.56..1,293.79 rows=1 width=40) (actual time=544.011..544.011 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 16,893
68. 244.621 244.621 ↑ 3.3 19 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx38 on notifications_summary_weekly_partitioned_2019_w43 ns_38 (cost=0.56..770.07 rows=62 width=40) (actual time=88.920..244.621 rows=19 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 13,441
69. 568.245 568.245 ↑ 2.8 70 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx39 on notifications_summary_weekly_partitioned_2019_w44 ns_39 (cost=0.56..1,504.39 rows=197 width=40) (actual time=85.640..568.245 rows=70 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 15,068
70. 313.928 313.928 ↑ 3.7 29 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx40 on notifications_summary_weekly_partitioned_2019_w45 ns_40 (cost=0.56..835.12 rows=108 width=40) (actual time=24.389..313.928 rows=29 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 14,517
71. 313.133 324.117 ↑ 5.7 50 1

Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w46 ns_41 (cost=52.28..2,170.68 rows=285 width=40) (actual time=33.793..324.117 rows=50 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 20,961
  • Heap Blocks: exact=19,804
72. 10.984 10.984 ↓ 14.8 21,011 1

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx41 (cost=0.00..52.21 rows=1,415 width=0) (actual time=10.983..10.984 rows=21,011 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
73. 352.208 352.208 ↑ 6.6 43 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx42 on notifications_summary_weekly_partitioned_2019_w47 ns_42 (cost=0.56..2,177.28 rows=283 width=40) (actual time=16.832..352.208 rows=43 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 18,401
74. 268.359 268.359 ↑ 4.1 42 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx43 on notifications_summary_weekly_partitioned_2019_w48 ns_43 (cost=0.56..1,324.01 rows=172 width=40) (actual time=5.754..268.359 rows=42 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 14,781
75. 197.302 197.302 ↑ 8.8 32 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx44 on notifications_summary_weekly_partitioned_2019_w49 ns_44 (cost=0.56..1,979.15 rows=280 width=40) (actual time=9.496..197.302 rows=32 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 18,816
76. 140.477 140.477 ↑ 3.0 74 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx45 on notifications_summary_weekly_partitioned_2019_w50 ns_45 (cost=0.56..1,610.97 rows=225 width=40) (actual time=10.186..140.477 rows=74 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 16,665
77. 168.496 168.496 ↑ 7.3 22 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx46 on notifications_summary_weekly_partitioned_2019_w51 ns_46 (cost=0.56..1,250.58 rows=161 width=40) (actual time=23.761..168.496 rows=22 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 15,465
78. 108.632 108.632 ↑ 11.5 13 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx47 on notifications_summary_weekly_partitioned_2019_w52 ns_47 (cost=0.56..1,176.65 rows=150 width=40) (actual time=7.425..108.632 rows=13 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 13,468
79. 283.612 291.787 ↑ 6.3 40 1

Bitmap Heap Scan on notifications_summary_weekly_partitioned_2020_w1 ns_48 (cost=43.45..1,961.18 rows=254 width=40) (actual time=15.755..291.787 rows=40 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 16,301
  • Heap Blocks: exact=15,553
80. 8.175 8.175 ↓ 12.7 16,341 1

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx49 (cost=0.00..43.38 rows=1,282 width=0) (actual time=8.175..8.175 rows=16,341 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
81. 102.207 102.207 ↑ 10.3 14 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx50 on notifications_summary_weekly_partitioned_2020_w2 ns_49 (cost=0.56..1,062.80 rows=144 width=40) (actual time=12.418..102.207 rows=14 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 11,929
82. 0.013 0.013 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx51 on notifications_summary_weekly_partitioned_2020_w3 ns_50 (cost=0.14..3.17 rows=1 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
83. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx52 on notifications_summary_weekly_partitioned_2020_w4 ns_51 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
84. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx53 on notifications_summary_weekly_partitioned_2020_w5 ns_52 (cost=0.14..3.17 rows=1 width=40) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
85. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx54 on notifications_summary_weekly_partitioned_2020_w6 ns_53 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
86. 0.073 0.073 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx55 on notifications_summary_weekly_partitioned_2020_w7 ns_54 (cost=0.14..3.17 rows=1 width=40) (actual time=0.073..0.073 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
87. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx56 on notifications_summary_weekly_partitioned_2020_w8 ns_55 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
88. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx57 on notifications_summary_weekly_partitioned_2020_w9 ns_56 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
89. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx58 on notifications_summary_weekly_partitioned_2020_w10 ns_57 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
90. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx59 on notifications_summary_weekly_partitioned_2020_w11 ns_58 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
91. 0.006 0.006 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx60 on notifications_summary_weekly_partitioned_2020_w12 ns_59 (cost=0.14..3.17 rows=1 width=40) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
92. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx61 on notifications_summary_weekly_partitioned_2020_w13 ns_60 (cost=0.14..3.17 rows=1 width=40) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
93. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx62 on notifications_summary_weekly_partitioned_2020_w14 ns_61 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
94. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx63 on notifications_summary_weekly_partitioned_2020_w15 ns_62 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
95. 0.003 0.003 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx64 on notifications_summary_weekly_partitioned_2020_w16 ns_63 (cost=0.14..3.17 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
96. 0.012 0.012 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx65 on notifications_summary_weekly_partitioned_2020_w17 ns_64 (cost=0.14..3.17 rows=1 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
97. 0.003 0.003 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx66 on notifications_summary_weekly_partitioned_2020_w18 ns_65 (cost=0.14..3.17 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
98. 0.003 0.003 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx67 on notifications_summary_weekly_partitioned_2020_w19 ns_66 (cost=0.14..3.17 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
99. 0.029 0.029 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx68 on notifications_summary_weekly_partitioned_2020_w20 ns_67 (cost=0.14..3.17 rows=1 width=40) (actual time=0.029..0.029 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
100. 0.007 0.007 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx69 on notifications_summary_weekly_partitioned_2020_w21 ns_68 (cost=0.14..3.17 rows=1 width=40) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
101. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx70 on notifications_summary_weekly_partitioned_2020_w22 ns_69 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
102. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx71 on notifications_summary_weekly_partitioned_2020_w23 ns_70 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
103. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx72 on notifications_summary_weekly_partitioned_2020_w24 ns_71 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
104. 0.003 0.003 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx73 on notifications_summary_weekly_partitioned_2020_w25 ns_72 (cost=0.14..3.17 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
105. 0.007 0.007 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx74 on notifications_summary_weekly_partitioned_2020_w26 ns_73 (cost=0.14..3.17 rows=1 width=40) (actual time=0.006..0.007 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
106. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx75 on notifications_summary_weekly_partitioned_2020_w27 ns_74 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
107. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx76 on notifications_summary_weekly_partitioned_2020_w28 ns_75 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
108. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx77 on notifications_summary_weekly_partitioned_2020_w29 ns_76 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
109. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx78 on notifications_summary_weekly_partitioned_2020_w30 ns_77 (cost=0.14..3.17 rows=1 width=40) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
110. 0.006 0.006 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx79 on notifications_summary_weekly_partitioned_2020_w31 ns_78 (cost=0.14..3.17 rows=1 width=40) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
111. 0.003 0.003 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx80 on notifications_summary_weekly_partitioned_2020_w32 ns_79 (cost=0.14..3.17 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
112. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx81 on notifications_summary_weekly_partitioned_2020_w33 ns_80 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
113. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx82 on notifications_summary_weekly_partitioned_2020_w34 ns_81 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
114. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx83 on notifications_summary_weekly_partitioned_2020_w35 ns_82 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
115. 0.009 0.009 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx84 on notifications_summary_weekly_partitioned_2020_w36 ns_83 (cost=0.14..3.17 rows=1 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
116. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx85 on notifications_summary_weekly_partitioned_2020_w37 ns_84 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
117. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx86 on notifications_summary_weekly_partitioned_2020_w38 ns_85 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
118. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx87 on notifications_summary_weekly_partitioned_2020_w39 ns_86 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
119. 0.015 0.015 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx88 on notifications_summary_weekly_partitioned_2020_w40 ns_87 (cost=0.14..3.17 rows=1 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
120. 0.006 0.006 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx89 on notifications_summary_weekly_partitioned_2020_w41 ns_88 (cost=0.14..3.17 rows=1 width=40) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
121. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx90 on notifications_summary_weekly_partitioned_2020_w42 ns_89 (cost=0.14..3.17 rows=1 width=40) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
122. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx91 on notifications_summary_weekly_partitioned_2020_w43 ns_90 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
123. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx92 on notifications_summary_weekly_partitioned_2020_w44 ns_91 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
124. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx93 on notifications_summary_weekly_partitioned_2020_w45 ns_92 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
125. 0.006 0.006 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx94 on notifications_summary_weekly_partitioned_2020_w46 ns_93 (cost=0.14..3.17 rows=1 width=40) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
126. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx95 on notifications_summary_weekly_partitioned_2020_w47 ns_94 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
127. 0.003 0.003 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx96 on notifications_summary_weekly_partitioned_2020_w48 ns_95 (cost=0.14..3.17 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
128. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx97 on notifications_summary_weekly_partitioned_2020_w49 ns_96 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
129. 0.006 0.006 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx98 on notifications_summary_weekly_partitioned_2020_w50 ns_97 (cost=0.14..3.17 rows=1 width=40) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
130. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx99 on notifications_summary_weekly_partitioned_2020_w51 ns_98 (cost=0.14..3.17 rows=1 width=40) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
131. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient_idx100 on notifications_summary_weekly_partitioned_2020_w52 ns_99 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
132. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx48 on notifications_summary_weekly_part_default ns_100 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
133. 0.178 2.453 ↓ 6.0 736 1

Hash (cost=189.23..189.23 rows=123 width=64) (actual time=2.453..2.453 rows=736 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 73kB
134. 2.140 2.275 ↓ 6.0 736 1

Bitmap Heap Scan on plans pl (cost=4.39..189.23 rows=123 width=64) (actual time=0.189..2.275 rows=736 loops=1)

  • Recheck Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (is_visible IS TRUE)
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=253
135. 0.135 0.135 ↓ 6.0 750 1

Bitmap Index Scan on plans_organization_uuid_idx (cost=0.00..4.36 rows=125 width=0) (actual time=0.135..0.135 rows=750 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
136. 0.103 1.795 ↓ 4.9 386 1

Hash (cost=119.86..119.86 rows=78 width=56) (actual time=1.795..1.795 rows=386 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 43kB
137. 1.605 1.692 ↓ 4.9 386 1

Bitmap Heap Scan on forms f (cost=2.53..119.86 rows=78 width=56) (actual time=0.124..1.692 rows=386 loops=1)

  • Recheck Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (is_visible IS TRUE)
  • Rows Removed by Filter: 10
  • Heap Blocks: exact=197
138. 0.087 0.087 ↓ 5.0 396 1

Bitmap Index Scan on forms_choices_uuid_idx (cost=0.00..2.51 rows=79 width=0) (actual time=0.087..0.087 rows=396 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
139. 3.550 67.677 ↓ 3.0 11,857 1

Hash (cost=3,298.86..3,298.86 rows=3,952 width=38) (actual time=67.677..67.677 rows=11,857 loops=1)

  • Buckets: 16,384 (originally 4096) Batches: 1 (originally 1) Memory Usage: 953kB
140. 64.127 64.127 ↓ 3.0 11,857 1

Seq Scan on persons_org_part_67_l2_t p (cost=0.00..3,298.86 rows=3,952 width=38) (actual time=1.262..64.127 rows=11,857 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
141. 0.087 10,597.185 ↑ 1.0 100 1

Hash Right Join (cost=128.82..202.09 rows=100 width=620) (actual time=10,597.032..10,597.185 rows=100 loops=1)

  • Hash Cond: (m.event_uuid = e.event_uuid)
142. 0.014 2.128 ↓ 11.1 100 1

Subquery Scan on m (cost=125.57..198.77 rows=9 width=71) (actual time=2.040..2.128 rows=100 loops=1)

  • Filter: (m.row_number = 1)
143. 0.100 2.114 ↑ 18.3 100 1

WindowAgg (cost=125.57..175.89 rows=1,830 width=102) (actual time=2.036..2.114 rows=100 loops=1)

144. 0.114 2.014 ↑ 18.3 100 1

Sort (cost=125.57..130.14 rows=1,830 width=78) (actual time=2.005..2.014 rows=100 loops=1)

  • Sort Key: msg.event_uuid, (CASE msg.language WHEN persons_org_part_67_l2_t.language THEN 1 WHEN 'en'::text THEN 2 ELSE 3 END), msg.language
  • Sort Method: quicksort Memory: 39kB
145. 0.062 1.900 ↑ 18.3 100 1

Hash Left Join (cost=3.75..26.40 rows=1,830 width=78) (actual time=0.144..1.900 rows=100 loops=1)

  • Hash Cond: ((msg.language)::text = (persons_org_part_67_l2_t.language)::text)
146. 0.076 1.816 ↑ 18.3 100 1

Nested Loop (cost=0.43..6.98 rows=1,830 width=74) (actual time=0.100..1.816 rows=100 loops=1)

147. 0.040 0.040 ↓ 100.0 100 1

CTE Scan on filtered_events e_1 (cost=0.00..2.00 rows=1 width=16) (actual time=0.002..0.040 rows=100 loops=1)

  • Filter: (system_event_type IS NULL)
148. 1.700 1.700 ↑ 1.0 1 100

Index Scan using messages_org_part_12_event_uuid_idx on messages_org_part_12 msg (cost=0.43..4.97 rows=1 width=74) (actual time=0.017..0.017 rows=1 loops=100)

  • Index Cond: (event_uuid = e_1.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
  • Rows Removed by Filter: 0
149. 0.002 0.022 ↑ 1.0 1 1

Hash (cost=3.31..3.31 rows=1 width=3) (actual time=0.022..0.022 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
150. 0.020 0.020 ↑ 1.0 1 1

Index Scan using persons_org_part_67_l2_t_org_seq_vrange_uidx on persons_org_part_67_l2_t (cost=0.29..3.31 rows=1 width=3) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: (person_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
151. 0.054 10,594.970 ↑ 1.0 100 1

Hash (cost=2.00..2.00 rows=100 width=588) (actual time=10,594.970..10,594.970 rows=100 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
152. 10,594.916 10,594.916 ↑ 1.0 100 1

CTE Scan on filtered_events e (cost=0.00..2.00 rows=100 width=588) (actual time=10,594.688..10,594.916 rows=100 loops=1)

Planning time : 210.071 ms
Execution time : 10,667.092 ms