explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dhw2 : Example query with WHERE notified filter and permission

Settings
# exclusive inclusive rows x rows loops node
1. 0.291 75,303.849 ↑ 1.0 100 1

Sort (cost=1,189,940.69..1,189,940.94 rows=100 width=620) (actual time=75,303.844..75,303.849 rows=100 loops=1)

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

CTE filtered_events

3. 0.099 75,294.537 ↑ 1.0 100 1

Limit (cost=1,189,734.92..1,189,735.17 rows=100 width=498) (actual time=75,294.429..75,294.537 rows=100 loops=1)

4.          

CTE da_events

5. 769.565 21,280.574 ↓ 3.0 1,294,215 1

Unique (cost=446,230.39..473,172.39 rows=431,072 width=570) (actual time=19,715.644..21,280.574 rows=1,294,215 loops=1)

6. 3,094.584 20,511.009 ↓ 3.0 1,294,215 1

Sort (cost=446,230.39..447,308.07 rows=431,072 width=570) (actual time=19,715.638..20,511.009 rows=1,294,215 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: 282856kB
7. 119.623 17,416.425 ↓ 3.0 1,294,215 1

Append (cost=0.00..334,848.04 rows=431,072 width=570) (actual time=8.976..17,416.425 rows=1,294,215 loops=1)

  • Subplans Removed: 11
8. 1,498.899 1,498.899 ↓ 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=8.972..1,498.899 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: 1401
9. 684.590 684.590 ↓ 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=13.420..684.590 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
10. 557.780 557.780 ↓ 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=12.918..557.780 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
11. 1,219.908 1,219.908 ↓ 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=17.760..1,219.908 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
12. 1,332.781 1,332.781 ↓ 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=18.381..1,332.781 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
13. 987.230 987.230 ↓ 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=28.346..987.230 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
14. 1,256.512 1,256.512 ↓ 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=22.774..1,256.512 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
15. 2,392.565 2,392.565 ↓ 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=15.728..2,392.565 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: 1087
16. 1,322.150 1,322.150 ↓ 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=12.517..1,322.150 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
17. 1,181.842 1,181.842 ↓ 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=32.162..1,181.842 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
18. 955.514 955.514 ↓ 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=7.649..955.514 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
19. 1,621.635 1,621.635 ↓ 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=29.644..1,621.635 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
20. 1,531.561 1,531.561 ↓ 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=46.987..1,531.561 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
21. 753.835 753.835 ↓ 3.1 24,033 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=24.209..753.835 rows=24,033 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
22. 4.256 75,294.438 ↑ 836.3 100 1

Sort (cost=716,562.53..716,771.59 rows=83,627 width=498) (actual time=75,294.428..75,294.438 rows=100 loops=1)

  • Sort Key: e_16.event_id DESC
  • Sort Method: top-N heapsort Memory: 109kB
23. 2.359 75,290.182 ↑ 42.1 1,988 1

Nested Loop Left Join (cost=696,707.10..713,366.36 rows=83,627 width=498) (actual time=73,886.317..75,290.182 rows=1,988 loops=1)

24. 2.589 75,250.051 ↑ 2.1 1,988 1

Nested Loop Left Join (cost=696,706.82..711,973.24 rows=4,232 width=476) (actual time=73,885.457..75,250.051 rows=1,988 loops=1)

25. 3.082 74,939.322 ↑ 2.1 1,988 1

Nested Loop Left Join (cost=696,706.40..709,622.82 rows=4,232 width=455) (actual time=73,749.093..74,939.322 rows=1,988 loops=1)

  • 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[])))
26. 162.198 73,461.144 ↑ 2.2 1,988 1

Hash Join (cost=696,705.85..706,459.19 rows=4,300 width=428) (actual time=73,011.655..73,461.144 rows=1,988 loops=1)

  • Hash Cond: (e_16.event_uuid = e_17.event_uuid)
  • Join Filter: ((e_16.submitter_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) OR (((array_agg(DISTINCT lower((p_1.target_name)::text)) || (array_agg(DISTINCT ns.recipient_uuid))::text[])) @> '{8f331ad1-fe92-419e-af03-f510fd115160}'::text[]))
27. 20,003.561 20,003.561 ↓ 3.0 1,294,215 1

CTE Scan on da_events e_16 (cost=0.00..8,621.44 rows=431,072 width=428) (actual time=19,715.646..20,003.561 rows=1,294,215 loops=1)

28. 0.857 53,295.385 ↓ 8.7 1,738 1

Hash (cost=696,703.35..696,703.35 rows=200 width=48) (actual time=53,295.384..53,295.385 rows=1,738 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 222kB
29. 8.927 53,294.528 ↓ 8.7 1,738 1

GroupAggregate (cost=679,404.99..696,701.35 rows=200 width=48) (actual time=53,071.363..53,294.528 rows=1,738 loops=1)

  • Group Key: e_17.event_uuid
30. 80.398 53,285.601 ↑ 37.0 1,988 1

Merge Join (cost=679,404.99..695,952.11 rows=73,474 width=40) (actual time=53,070.845..53,285.601 rows=1,988 loops=1)

  • Merge Cond: (ns.event_uuid = e_17.event_uuid)
  • Join Filter: ((ns.created_date >= e_17.created) AND (ns.created_date <= LEAST(e_17.terminated, (e_17.created + '1 mon'::interval))))
31. 2.849 6,176.191 ↑ 1.8 1,744 1

Sort (cost=27,043.68..27,051.43 rows=3,099 width=40) (actual time=6,175.629..6,176.191 rows=1,744 loops=1)

  • Sort Key: ns.event_uuid
  • Sort Method: quicksort Memory: 186kB
32. 0.793 6,173.342 ↑ 1.8 1,756 1

Append (cost=0.56..26,863.97 rows=3,099 width=40) (actual time=0.214..6,173.342 rows=1,756 loops=1)

33. 1.641 1.641 ↓ 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.212..1.641 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
34. 1.850 1.850 ↓ 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.139..1.850 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
35. 1.404 1.404 ↓ 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.087..1.404 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
36. 1.723 1.723 ↓ 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.382..1.723 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
37. 1.734 1.734 ↓ 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.200..1.734 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
38. 1.317 1.317 ↓ 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.145..1.317 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
39. 1.825 1.825 ↓ 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.154..1.825 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
40. 1.649 1.649 ↓ 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.095..1.649 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
41. 1.289 1.289 ↓ 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.269..1.289 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
42. 1.861 1.861 ↓ 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.187..1.861 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
43. 2.381 2.381 ↓ 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.370..2.381 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
44. 1.123 1.123 ↓ 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.186..1.123 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
45. 1.133 1.133 ↓ 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.085..1.133 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
46. 1.700 1.700 ↓ 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.107..1.700 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
47. 1.186 1.186 ↓ 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.127..1.186 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
48. 1.892 1.892 ↓ 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.070..1.892 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
49. 2.110 2.110 ↓ 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.073..2.110 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
50. 2.240 2.240 ↓ 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.502..2.240 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
51. 1.582 1.582 ↓ 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.156..1.582 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
52. 1.941 1.941 ↓ 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.108..1.941 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
53. 2.516 2.516 ↓ 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.195..2.516 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
54. 2.500 2.500 ↓ 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.127..2.500 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
55. 1.737 1.737 ↓ 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.391..1.737 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
56. 1.219 1.219 ↓ 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.115..1.219 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
57. 2.055 2.055 ↓ 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.155..2.055 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
58. 2.338 2.338 ↓ 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.160..2.338 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
59. 1.662 1.662 ↓ 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.163..1.662 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
60. 1.912 1.912 ↓ 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.199..1.912 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
61. 0.975 0.975 ↓ 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.246..0.975 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
62. 0.193 0.193 ↓ 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.069..0.193 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
63. 1.582 1.582 ↓ 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.105..1.582 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
64. 344.257 344.257 ↓ 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.192..344.257 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: 3696
65. 452.204 452.204 ↑ 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=8.192..452.204 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: 13022
66. 364.573 364.573 ↑ 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=11.669..364.573 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: 19562
67. 214.457 214.457 ↑ 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=10.369..214.457 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: 18083
68. 469.574 476.583 ↑ 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=16.859..476.583 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: 20517
  • Heap Blocks: exact=18561
69. 7.009 7.009 ↓ 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=7.009..7.009 rows=20,518 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
70. 342.203 351.921 ↓ 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=351.921..351.921 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: 20179
  • Heap Blocks: exact=17861
71. 9.718 9.718 ↓ 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=9.718..9.718 rows=20,179 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
72. 321.194 321.194 ↓ 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=321.194..321.194 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: 16893
73. 447.087 447.087 ↑ 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=150.527..447.087 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: 13441
74. 185.020 185.020 ↑ 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=12.697..185.020 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: 15068
75. 651.091 651.091 ↑ 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=7.894..651.091 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: 14517
76. 351.745 363.096 ↑ 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=88.578..363.096 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: 20961
  • Heap Blocks: exact=19804
77. 11.351 11.351 ↓ 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=11.351..11.351 rows=21,011 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
78. 242.223 242.223 ↑ 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=17.084..242.223 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: 18401
79. 238.231 238.231 ↑ 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.959..238.231 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: 14781
80. 287.365 287.365 ↑ 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.170..287.365 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: 18816
81. 229.967 237.012 ↑ 5.3 74 1

Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w50 ns_45 (cost=63.28..2,693.29 rows=390 width=40) (actual time=16.175..237.012 rows=74 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: 16665
  • Heap Blocks: exact=15951
82. 7.045 7.045 ↓ 9.5 16,739 1

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx45 (cost=0.00..63.18 rows=1,762 width=0) (actual time=7.045..7.045 rows=16,739 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
83. 263.292 263.292 ↑ 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=11.177..263.292 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: 15465
84. 270.457 270.457 ↑ 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=10.055..270.457 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: 13468
85. 258.985 269.033 ↑ 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=18.375..269.033 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: 16301
  • Heap Blocks: exact=15553
86. 10.048 10.048 ↓ 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=10.048..10.048 rows=16,341 loops=1)

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

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx50 on notifications_summary_weekly_partitioned_2020_w2 ns_49 (cost=0.56..1,025.77 rows=139 width=40) (actual time=17.044..140.846 rows=15 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: 12217
88. 0.013 0.013 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx2 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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
89. 0.017 0.017 ↓ 0.0 0 1

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

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

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx4 on notifications_summary_weekly_partitioned_2020_w5 ns_52 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
91. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx54 on notifications_summary_weekly_partitioned_2020_w6 ns_53 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
92. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx55 on notifications_summary_weekly_partitioned_2020_w7 ns_54 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
93. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx56 on notifications_summary_weekly_partitioned_2020_w8 ns_55 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) 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_event_uuid_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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
95. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx58 on notifications_summary_weekly_partitioned_2020_w10 ns_57 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
96. 0.007 0.007 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx59 on notifications_summary_weekly_partitioned_2020_w11 ns_58 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
97. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx60 on notifications_summary_weekly_partitioned_2020_w12 ns_59 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
98. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
99. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
100. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx63 on notifications_summary_weekly_partitioned_2020_w15 ns_62 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) 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_event_uuid_idx64 on notifications_summary_weekly_partitioned_2020_w16 ns_63 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
102. 0.006 0.006 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx65 on notifications_summary_weekly_partitioned_2020_w17 ns_64 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
103. 0.008 0.008 ↓ 0.0 0 1

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

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

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx67 on notifications_summary_weekly_partitioned_2020_w19 ns_66 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
105. 0.006 0.006 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx68 on notifications_summary_weekly_partitioned_2020_w20 ns_67 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) 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_event_uuid_idx69 on notifications_summary_weekly_partitioned_2020_w21 ns_68 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
107. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx70 on notifications_summary_weekly_partitioned_2020_w22 ns_69 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
108. 0.006 0.006 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx71 on notifications_summary_weekly_partitioned_2020_w23 ns_70 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
109. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx72 on notifications_summary_weekly_partitioned_2020_w24 ns_71 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
110. 0.007 0.007 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx73 on notifications_summary_weekly_partitioned_2020_w25 ns_72 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
111. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx74 on notifications_summary_weekly_partitioned_2020_w26 ns_73 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) 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_event_uuid_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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
113. 0.006 0.006 ↓ 0.0 0 1

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

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

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) 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_event_uuid_idx79 on notifications_summary_weekly_partitioned_2020_w31 ns_78 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
117. 0.028 0.028 ↓ 0.0 0 1

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

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

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
119. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
120. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx83 on notifications_summary_weekly_partitioned_2020_w35 ns_82 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
121. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx84 on notifications_summary_weekly_partitioned_2020_w36 ns_83 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
122. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx85 on notifications_summary_weekly_partitioned_2020_w37 ns_84 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
123. 0.006 0.006 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx86 on notifications_summary_weekly_partitioned_2020_w38 ns_85 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
124. 0.018 0.018 ↓ 0.0 0 1

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

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

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx88 on notifications_summary_weekly_partitioned_2020_w40 ns_87 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
126. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx89 on notifications_summary_weekly_partitioned_2020_w41 ns_88 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
127. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx90 on notifications_summary_weekly_partitioned_2020_w42 ns_89 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
128. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx91 on notifications_summary_weekly_partitioned_2020_w43 ns_90 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) 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_event_uuid_idx92 on notifications_summary_weekly_partitioned_2020_w44 ns_91 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) 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_event_uuid_idx93 on notifications_summary_weekly_partitioned_2020_w45 ns_92 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
131. 0.008 0.008 ↓ 0.0 0 1

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) 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_event_uuid_idx95 on notifications_summary_weekly_partitioned_2020_w47 ns_94 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
133. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx96 on notifications_summary_weekly_partitioned_2020_w48 ns_95 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
134. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
135. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx98 on notifications_summary_weekly_partitioned_2020_w50 ns_97 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
136. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
137. 0.006 0.006 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uui_idx100 on notifications_summary_weekly_partitioned_2020_w52 ns_99 (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)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
138. 0.008 0.008 ↓ 0.0 0 1

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
139. 869.102 47,029.012 ↓ 28.5 1,216,085 1

Sort (cost=652,361.31..652,468.00 rows=42,676 width=56) (actual time=46,894.920..47,029.012 rows=1,216,085 loops=1)

  • Sort Key: e_17.event_uuid
  • Sort Method: external sort Disk: 81912kB
140. 30,507.440 46,159.910 ↓ 28.5 1,216,114 1

Nested Loop (cost=5.03..649,079.28 rows=42,676 width=56) (actual time=74.977..46,159.910 rows=1,216,114 loops=1)

  • Join Filter: (p_1.valid_range @> e_17.created)
  • Rows Removed by Join Filter: 249861596
141. 2,710.320 2,710.320 ↓ 3.0 1,294,215 1

CTE Scan on da_events e_17 (cost=0.00..8,621.44 rows=431,072 width=32) (actual time=0.002..2,710.320 rows=1,294,215 loops=1)

142. 12,795.111 12,942.150 ↓ 2.0 194 1,294,215

Materialize (cost=5.03..316.17 rows=99 width=46) (actual time=0.000..0.010 rows=194 loops=1,294,215)

143. 0.060 147.039 ↓ 2.0 194 1

Append (cost=5.03..315.68 rows=99 width=46) (actual time=11.699..147.039 rows=194 loops=1)

144. 140.522 145.084 ↓ 2.0 193 1

Bitmap Heap Scan on persons_org_part_67_l2_f p_1 (cost=5.03..311.88 rows=98 width=46) (actual time=11.698..145.084 rows=193 loops=1)

  • Recheck Cond: (person_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
  • Filter: (is_visible AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
  • Rows Removed by Filter: 21
  • Heap Blocks: exact=130
145. 4.562 4.562 ↓ 1.0 214 1

Bitmap Index Scan on persons_org_part_67_l2_f_org_seq_vrange_uidx (cost=0.00..5.00 rows=211 width=0) (actual time=4.562..4.562 rows=214 loops=1)

  • Index Cond: (person_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
146. 1.895 1.895 ↑ 1.0 1 1

Index Scan using persons_org_part_67_l2_t_org_seq_vrange_uidx on persons_org_part_67_l2_t p_2 (cost=0.29..3.31 rows=1 width=38) (actual time=1.893..1.895 rows=1 loops=1)

  • Index Cond: (person_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
  • Filter: (is_visible AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
147. 1,475.096 1,475.096 ↑ 1.0 1 1,988

Index Scan using plans_org_seq_vrange_uidx on plans pl (cost=0.55..0.72 rows=1 width=64) (actual time=0.607..0.742 rows=1 loops=1,988)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (plan_uuid = e_16.plan_uuid))
  • Filter: ((is_visible IS TRUE) AND (valid_range @> e_16.created))
  • Rows Removed by Filter: 59
148. 308.140 308.140 ↑ 1.0 1 1,988

Index Scan using forms_org_seq_vrange_uidx on forms f (cost=0.42..0.55 rows=1 width=56) (actual time=0.115..0.155 rows=1 loops=1,988)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (form_uuid = e_16.form_uuid))
  • Filter: ((is_visible IS TRUE) AND (valid_range @> e_16.created))
  • Rows Removed by Filter: 9
149. 37.772 37.772 ↑ 1.0 1 1,988

Index Scan using persons_org_part_67_l2_t_org_seq_vrange_uidx on persons_org_part_67_l2_t p (cost=0.29..0.32 rows=1 width=38) (actual time=0.019..0.019 rows=1 loops=1,988)

  • Index Cond: (person_uuid = e_16.submitter_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
150. 0.091 75,303.558 ↑ 1.0 100 1

Hash Right Join (cost=128.89..202.20 rows=100 width=620) (actual time=75,303.408..75,303.558 rows=100 loops=1)

  • Hash Cond: (m.event_uuid = e.event_uuid)
151. 0.013 8.772 ↓ 11.1 100 1

Subquery Scan on m (cost=125.64..198.88 rows=9 width=71) (actual time=8.685..8.772 rows=100 loops=1)

  • Filter: (m.row_number = 1)
152. 0.118 8.759 ↑ 18.3 100 1

WindowAgg (cost=125.64..175.99 rows=1,831 width=102) (actual time=8.681..8.759 rows=100 loops=1)

153. 0.138 8.641 ↑ 18.3 100 1

Sort (cost=125.64..130.22 rows=1,831 width=78) (actual time=8.633..8.641 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
154. 0.088 8.503 ↑ 18.3 100 1

Hash Left Join (cost=3.75..26.41 rows=1,831 width=78) (actual time=0.148..8.503 rows=100 loops=1)

  • Hash Cond: ((msg.language)::text = (persons_org_part_67_l2_t.language)::text)
155. 0.035 8.397 ↑ 18.3 100 1

Nested Loop (cost=0.43..6.98 rows=1,831 width=74) (actual time=0.112..8.397 rows=100 loops=1)

156. 0.062 0.062 ↓ 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.062 rows=100 loops=1)

  • Filter: (system_event_type IS NULL)
157. 8.300 8.300 ↑ 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.082..0.083 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
158. 0.003 0.018 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
159. 0.015 0.015 ↑ 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.015..0.015 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))
160. 0.057 75,294.695 ↑ 1.0 100 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
161. 75,294.638 75,294.638 ↑ 1.0 100 1

CTE Scan on filtered_events e (cost=0.00..2.00 rows=100 width=588) (actual time=75,294.439..75,294.638 rows=100 loops=1)

Planning time : 1,459.625 ms
Execution time : 75,487.848 ms