explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N1Tc

Settings
# exclusive inclusive rows x rows loops node
1. 0.261 6,828.866 ↓ 5.0 100 1

Sort (cost=83,094.03..83,094.08 rows=20 width=620) (actual time=6,828.861..6,828.866 rows=100 loops=1)

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

CTE filtered_events

3. 3.326 6,825.634 ↓ 5.0 100 1

Limit (cost=82,895.13..82,895.18 rows=20 width=671) (actual time=6,822.298..6,825.634 rows=100 loops=1)

4. 8.998 6,822.308 ↓ 5.0 100 1

Sort (cost=82,895.13..82,895.18 rows=20 width=671) (actual time=6,822.297..6,822.308 rows=100 loops=1)

  • Sort Key: e_2.event_id DESC
  • Sort Method: top-N heapsort Memory: 162kB
5. 1.382 6,813.310 ↓ 456.9 9,137 1

Nested Loop Left Join (cost=82,092.45..82,894.70 rows=20 width=671) (actual time=5,550.230..6,813.310 rows=9,137 loops=1)

6. 11.948 6,793.654 ↓ 9,137.0 9,137 1

Nested Loop Left Join (cost=82,092.17..82,891.38 rows=1 width=649) (actual time=5,550.204..6,793.654 rows=9,137 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[])))
7. 6.099 6,553.281 ↓ 9,137.0 9,137 1

Nested Loop Left Join (cost=82,091.62..82,887.79 rows=1 width=622) (actual time=5,549.964..6,553.281 rows=9,137 loops=1)

8. 825.999 6,510.634 ↓ 9,137.0 9,137 1

GroupAggregate (cost=82,091.20..82,884.33 rows=1 width=601) (actual time=5,549.887..6,510.634 rows=9,137 loops=1)

  • Group 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.override_choices, e_2.valid_from, e_2.valid_to, e_2.recipients
  • Filter: (array_agg(DISTINCT e_2.notified_uuids) @> '{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])
  • Rows Removed by Filter: 435,198
9. 764.276 5,684.635 ↓ 48.6 453,472 1

Sort (cost=82,091.20..82,114.52 rows=9,331 width=585) (actual time=5,549.770..5,684.635 rows=453,472 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.override_choices, e_2.valid_from, e_2.valid_to, e_2.recipients
  • Sort Method: external merge Disk: 117,864kB
10. 134.076 4,920.359 ↓ 48.6 453,472 1

Subquery Scan on e_2 (cost=80,776.09..81,475.92 rows=9,331 width=585) (actual time=4,431.277..4,920.359 rows=453,472 loops=1)

11. 161.889 4,786.283 ↓ 48.6 453,472 1

Unique (cost=80,776.09..81,382.61 rows=9,331 width=585) (actual time=4,431.271..4,786.283 rows=453,472 loops=1)

12. 907.540 4,624.394 ↓ 48.6 453,711 1

Sort (cost=80,776.09..80,799.42 rows=9,331 width=585) (actual time=4,431.269..4,624.394 rows=453,711 loops=1)

  • Sort Key: e_3.event_uuid, e_3.event_id, e_3.submitter_uuid, e_3.priority, e_3.incident_id, e_3.override_device_restrictions, e_3.escalation_override, e_3.bypass_phone_intro, e_3.require_phone_password, e_3.conference_properties, e_3.created, e_3.status, e_3.terminated, e_3.request_uuid, e_3.sequence, e_3.revision_uuid, e_3.event_type, e_3.system_event_type, e_3.form_uuid, e_3.plan_uuid, e_3.choices, (lower(e_3.valid_range)), (upper(e_3.valid_range)), ns_41.recipient_uuid, e_3.recipients
  • Sort Method: external merge Disk: 117,984kB
13. 0.000 3,716.854 ↓ 48.6 453,711 1

Gather (cost=1,028.06..80,160.82 rows=9,331 width=585) (actual time=11.044..3,716.854 rows=453,711 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
14. 142.624 3,853.298 ↓ 38.9 90,742 5 / 5

Nested Loop (cost=28.06..78,227.72 rows=2,333 width=585) (actual time=8.779..3,853.298 rows=90,742 loops=5)

15. 9.723 799.121 ↓ 77.9 74,655 5 / 5

Parallel Append (cost=27.64..22,892.29 rows=958 width=40) (actual time=8.031..799.121 rows=74,655 loops=5)

16. 27.238 28.970 ↓ 92.5 11,380 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w46 ns_41 (cost=43.59..1,587.50 rows=123 width=40) (actual time=10.708..144.852 rows=11,380 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 155
17. 1.732 1.732 ↓ 11.2 11,535 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx41 (cost=0.00..43.54 rows=1,034 width=0) (actual time=8.662..8.662 rows=11,535 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
18. 22.528 24.041 ↓ 109.7 10,418 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w50 ns_45 (cost=31.55..1,127.95 rows=95 width=40) (actual time=9.366..120.204 rows=10,418 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 7
19. 1.513 1.513 ↓ 14.2 10,425 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx45 (cost=0.00..31.51 rows=733 width=0) (actual time=7.566..7.566 rows=10,425 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
20. 22.414 24.216 ↓ 129.1 8,909 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w48 ns_43 (cost=30.04..903.47 rows=69 width=40) (actual time=10.978..121.080 rows=8,909 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 4
21. 1.802 1.802 ↓ 15.3 8,913 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx43 (cost=0.00..30.01 rows=582 width=0) (actual time=9.008..9.008 rows=8,913 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
22. 25.171 26.342 ↓ 84.7 593 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w40 ns_35 (cost=27.64..1,878.45 rows=7 width=40) (actual time=8.861..131.708 rows=593 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 13,728
23. 1.170 1.170 ↓ 11.5 14,321 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx35 (cost=0.00..27.64 rows=1,244 width=0) (actual time=5.851..5.851 rows=14,321 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
24. 26.192 27.071 ↓ 116.9 10,290 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2020_w1 ns_48 (cost=27.25..1,151.09 rows=88 width=40) (actual time=6.087..135.353 rows=10,290 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 2
25. 0.878 0.878 ↓ 13.7 10,292 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx49 (cost=0.00..27.22 rows=752 width=0) (actual time=4.391..4.391 rows=10,292 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
26. 24.972 26.306 ↓ 142.8 10,282 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w51 ns_46 (cost=25.93..954.48 rows=72 width=40) (actual time=8.861..131.531 rows=10,282 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 7
27. 1.334 1.334 ↓ 16.6 10,289 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx46 (cost=0.00..25.90 rows=620 width=0) (actual time=6.671..6.671 rows=10,289 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
28. 14.407 15.228 ↓ 109.5 7,339 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w45 ns_40 (cost=25.42..880.74 rows=67 width=40) (actual time=5.361..76.142 rows=7,339 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 5
29. 0.822 0.822 ↓ 12.9 7,344 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx40 (cost=0.00..25.39 rows=570 width=0) (actual time=4.109..4.109 rows=7,344 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
30. 22.027 23.420 ↓ 162.8 10,748 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w47 ns_42 (cost=25.30..863.56 rows=66 width=40) (actual time=8.910..117.102 rows=10,748 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 4
31. 1.394 1.394 ↓ 19.2 10,752 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx42 (cost=0.00..25.27 rows=559 width=0) (actual time=6.969..6.969 rows=10,752 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
32. 21.952 22.676 ↓ 0.0 0 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w41 ns_36 (cost=23.92..1,329.72 rows=1 width=40) (actual time=113.380..113.380 rows=0 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 12,215
33. 0.724 0.724 ↓ 14.0 12,215 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx36 (cost=0.00..23.92 rows=874 width=0) (actual time=3.620..3.620 rows=12,215 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
34. 24.359 25.699 ↓ 147.5 8,850 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w52 ns_47 (cost=20.37..791.14 rows=60 width=40) (actual time=8.669..128.493 rows=8,850 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 3
35. 1.339 1.339 ↓ 17.2 8,853 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx47 (cost=0.00..20.34 rows=515 width=0) (actual time=6.697..6.697 rows=8,853 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
36. 25.144 25.937 ↓ 151.5 7,878 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2020_w2 ns_49 (cost=19.46..659.37 rows=52 width=40) (actual time=5.500..129.683 rows=7,878 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 2
37. 0.792 0.792 ↓ 21.2 9,046 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx50 (cost=0.00..19.44 rows=427 width=0) (actual time=3.961..3.962 rows=9,046 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
38. 13.852 14.325 ↓ 177.6 3,908 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w43 ns_38 (cost=13.79..476.54 rows=22 width=40) (actual time=6.315..71.623 rows=3,908 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 2,268
39. 0.473 0.473 ↓ 20.1 6,176 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx38 (cost=0.00..13.78 rows=308 width=0) (actual time=2.363..2.363 rows=6,176 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
40. 13.382 13.382 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx37 on notifications_summary_weekly_partitioned_2019_w42 ns_37 (cost=0.56..798.05 rows=1 width=40) (actual time=66.908..66.908 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 8,423
41. 19.155 19.155 ↓ 130.8 13,341 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx13 on notifications_summary_weekly_partitioned_2019_w18 ns_13 (cost=0.56..577.88 rows=102 width=40) (actual time=0.149..95.775 rows=13,341 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 15
42. 16.031 16.031 ↓ 137.7 10,325 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx34 on notifications_summary_weekly_partitioned_2019_w39 ns_34 (cost=0.56..499.48 rows=75 width=40) (actual time=0.130..80.154 rows=10,325 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 5
43. 19.021 19.021 ↓ 145.9 12,697 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx20 on notifications_summary_weekly_partitioned_2019_w25 ns_20 (cost=0.56..498.89 rows=87 width=40) (actual time=0.116..95.105 rows=12,697 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 28
44. 11.445 11.445 ↓ 148.9 11,763 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx27 on notifications_summary_weekly_partitioned_2019_w32 ns_27 (cost=0.56..481.44 rows=79 width=40) (actual time=0.163..57.223 rows=11,763 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 1
45. 22.738 22.738 ↓ 169.4 13,386 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx24 on notifications_summary_weekly_partitioned_2019_w29 ns_24 (cost=0.56..473.10 rows=79 width=40) (actual time=0.171..113.688 rows=13,386 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 26
46. 15.741 15.741 ↓ 145.7 11,511 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx19 on notifications_summary_weekly_partitioned_2019_w24 ns_19 (cost=0.56..463.97 rows=79 width=40) (actual time=0.140..78.705 rows=11,511 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
47. 16.389 16.389 ↓ 167.2 12,711 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx25 on notifications_summary_weekly_partitioned_2019_w30 ns_25 (cost=0.56..448.60 rows=76 width=40) (actual time=0.125..81.943 rows=12,711 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 3
48. 14.011 14.011 ↓ 137.4 10,445 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx18 on notifications_summary_weekly_partitioned_2019_w23 ns_18 (cost=0.56..437.80 rows=76 width=40) (actual time=0.160..70.053 rows=10,445 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 1
49. 11.573 11.573 ↓ 191.9 13,244 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx23 on notifications_summary_weekly_partitioned_2019_w28 ns_23 (cost=0.56..415.10 rows=69 width=40) (actual time=0.153..57.866 rows=13,244 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 21
50. 10.684 10.684 ↓ 194.8 13,440 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx11 on notifications_summary_weekly_partitioned_2019_w16 ns_11 (cost=0.56..407.16 rows=69 width=40) (actual time=0.194..53.422 rows=13,440 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 10
51. 14.218 14.218 ↓ 160.2 11,054 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx16 on notifications_summary_weekly_partitioned_2019_w21 ns_16 (cost=0.56..399.35 rows=69 width=40) (actual time=0.130..71.091 rows=11,054 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 10
52. 8.679 8.679 ↓ 182.6 11,870 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx26 on notifications_summary_weekly_partitioned_2019_w31 ns_26 (cost=0.56..396.45 rows=65 width=40) (actual time=0.123..43.395 rows=11,870 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 6
53. 19.085 19.085 ↓ 162.0 10,047 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx33 on notifications_summary_weekly_partitioned_2019_w38 ns_33 (cost=0.56..373.74 rows=62 width=40) (actual time=0.155..95.425 rows=10,047 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 1
54. 8.701 8.701 ↓ 214.0 13,694 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx21 on notifications_summary_weekly_partitioned_2019_w26 ns_21 (cost=0.56..363.59 rows=64 width=40) (actual time=0.051..43.503 rows=13,694 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
55. 8.676 8.676 ↓ 235.6 13,666 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx12 on notifications_summary_weekly_partitioned_2019_w17 ns_12 (cost=0.56..339.94 rows=58 width=40) (actual time=0.071..43.378 rows=13,666 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 6
56. 76.018 76.018 ↓ 90.9 5,091 2 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx17 on notifications_summary_weekly_partitioned_2019_w22 ns_17 (cost=0.56..328.70 rows=56 width=40) (actual time=0.131..190.046 rows=5,091 loops=2)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 2
57. 28.470 28.470 ↓ 31.9 1,597 5 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx31 on notifications_summary_weekly_partitioned_2019_w36 ns_31 (cost=0.56..325.74 rows=50 width=40) (actual time=0.074..28.470 rows=1,597 loops=5)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 0
58. 43.565 43.565 ↓ 63.7 3,313 3 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx30 on notifications_summary_weekly_partitioned_2019_w35 ns_30 (cost=0.56..321.52 rows=52 width=40) (actual time=0.080..72.609 rows=3,313 loops=3)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
59. 28.103 28.103 ↓ 114.9 6,206 2 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx14 on notifications_summary_weekly_partitioned_2019_w19 ns_14 (cost=0.56..314.61 rows=54 width=40) (actual time=0.147..70.258 rows=6,206 loops=2)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 1
60. 9.322 9.322 ↓ 109.0 5,996 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx10 on notifications_summary_weekly_partitioned_2019_w15 ns_10 (cost=0.56..309.04 rows=55 width=40) (actual time=0.113..46.612 rows=5,996 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 10
61. 12.542 12.542 ↓ 130.5 6,656 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx32 on notifications_summary_weekly_partitioned_2019_w37 ns_32 (cost=0.56..297.79 rows=51 width=40) (actual time=0.063..62.712 rows=6,656 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 4
62. 19.669 19.669 ↓ 1,009.3 10,093 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx44 on notifications_summary_weekly_partitioned_2019_w49 ns_44 (cost=0.56..127.03 rows=10 width=40) (actual time=0.093..98.346 rows=10,093 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
63. 13.710 13.710 ↓ 865.2 6,922 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx39 on notifications_summary_weekly_partitioned_2019_w44 ns_39 (cost=0.56..112.36 rows=8 width=40) (actual time=0.075..68.550 rows=6,922 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 12
64. 15.770 15.770 ↓ 1,072.3 11,795 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx15 on notifications_summary_weekly_partitioned_2019_w20 ns_15 (cost=0.56..64.49 rows=11 width=40) (actual time=0.069..78.850 rows=11,795 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 15
65. 0.310 0.310 ↓ 19.8 158 1 / 5

Parallel Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx9 on notifications_summary_weekly_partitioned_2019_w14 ns_9 (cost=0.56..51.10 rows=8 width=40) (actual time=0.070..1.548 rows=158 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 14
66. 17.133 17.133 ↓ 1,684.1 11,789 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx22 on notifications_summary_weekly_partitioned_2019_w27 ns_22 (cost=0.56..46.83 rows=7 width=40) (actual time=0.075..85.664 rows=11,789 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 10
67. 0.235 0.235 ↓ 21.5 129 1 / 5

Parallel Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx6 on notifications_summary_weekly_partitioned_2019_w11 ns_6 (cost=0.56..43.50 rows=6 width=40) (actual time=0.062..1.175 rows=129 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 17
68. 0.215 0.215 ↓ 20.5 123 1 / 5

Parallel Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx7 on notifications_summary_weekly_partitioned_2019_w12 ns_7 (cost=0.56..40.74 rows=6 width=40) (actual time=0.068..1.077 rows=123 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 7
69. 0.268 0.268 ↓ 20.8 125 1 / 5

Parallel Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx4 on notifications_summary_weekly_partitioned_2019_w9 ns_4 (cost=0.56..38.13 rows=6 width=40) (actual time=0.087..1.340 rows=125 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 39
70. 0.280 0.280 ↓ 26.8 134 1 / 5

Parallel Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx8 on notifications_summary_weekly_partitioned_2019_w13 ns_8 (cost=0.56..34.81 rows=5 width=40) (actual time=0.064..1.401 rows=134 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 38
71. 0.252 0.252 ↓ 20.6 103 1 / 5

Parallel Index Scan using notifications_summary_weekly__organization_uuid_recipient_u_idx on notifications_summary_weekly_partitioned_2019_w5 ns (cost=0.56..33.56 rows=5 width=40) (actual time=0.055..1.262 rows=103 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 63
72. 0.275 0.275 ↓ 26.8 134 1 / 5

Parallel Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx2 on notifications_summary_weekly_partitioned_2019_w7 ns_2 (cost=0.56..32.76 rows=5 width=40) (actual time=0.063..1.377 rows=134 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 59
73. 0.568 0.568 ↓ 51.0 255 1 / 5

Parallel Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx1 on notifications_summary_weekly_partitioned_2019_w6 ns_1 (cost=0.56..32.07 rows=5 width=40) (actual time=0.087..2.842 rows=255 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 34
74. 0.326 0.326 ↓ 26.2 105 1 / 5

Parallel Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx5 on notifications_summary_weekly_partitioned_2019_w10 ns_5 (cost=0.56..26.86 rows=4 width=40) (actual time=0.085..1.630 rows=105 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 30
75. 0.199 0.199 ↓ 33.5 67 1 / 5

Parallel Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx3 on notifications_summary_weekly_partitioned_2019_w8 ns_3 (cost=0.56..21.25 rows=2 width=40) (actual time=0.073..0.993 rows=67 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 22
76. 7.208 7.208 ↓ 171.1 3,594 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx28 on notifications_summary_weekly_partitioned_2019_w33 ns_28 (cost=0.56..134.90 rows=21 width=40) (actual time=0.069..36.038 rows=3,594 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
  • Rows Removed by Filter: 2
77. 1.170 1.170 ↓ 791.0 791 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx29 on notifications_summary_weekly_partitioned_2019_w34 ns_29 (cost=0.56..9.73 rows=1 width=40) (actual time=0.077..5.849 rows=791 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
  • Filter: ((category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
78. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel 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.004..0.004 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
79. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
80. 0.000 0.000 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
81. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
82. 0.000 0.000 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
83. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
84. 0.000 0.000 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
85. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
86. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
87. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
88. 0.000 0.000 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
89. 0.000 0.000 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
90. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
91. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
92. 0.000 0.000 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
93. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
94. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
95. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
96. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
97. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
98. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
99. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
100. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
101. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
102. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
103. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
104. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
105. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
106. 0.000 0.000 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
107. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
108. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
109. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
110. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
111. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
112. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
113. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
114. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
115. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
116. 0.000 0.000 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
117. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
118. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
119. 0.000 0.000 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
120. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
121. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
122. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
123. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
124. 0.000 0.000 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
125. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
126. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
127. 0.001 0.001 ↓ 0.0 0 1 / 5

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
128. 0.002 0.002 ↓ 0.0 0 1 / 5

Parallel 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.011..0.011 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((category = 'PERSON'::text) AND (recipient_uuid = ANY ('{5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd,b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
129. 191.047 2,911.553 ↑ 25.0 1 373,276 / 5

Append (cost=0.42..57.50 rows=25 width=567) (actual time=0.038..0.039 rows=1 loops=373,276)

  • Subplans Removed: 11
130. 298.621 298.621 ↓ 0.0 0 373,276 / 5

Index Scan using events_org_part_12_l3_t_2018_event_uuid_idx on events_org_part_12_l3_t_2018 e_3 (cost=0.42..3.00 rows=1 width=363) (actual time=0.004..0.004 rows=0 loops=373,276)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • 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 (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
131. 223.966 223.966 ↓ 0.0 0 373,276 / 5

Index Scan using events_org_part_12_l3_t_201901_event_uuid_idx on events_org_part_12_l3_t_201901 e_4 (cost=0.29..2.76 rows=1 width=366) (actual time=0.003..0.003 rows=0 loops=373,276)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • 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 (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
132. 223.927 223.927 ↓ 0.0 0 373,212 / 5

Index Scan using events_org_part_12_l3_t_201902_event_uuid_idx on events_org_part_12_l3_t_201902 e_5 (cost=0.29..2.74 rows=1 width=365) (actual time=0.003..0.003 rows=0 loops=373,212)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • 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 (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
133. 223.577 223.577 ↓ 0.0 0 372,629 / 5

Index Scan using events_org_part_12_l3_t_201903_event_uuid_idx on events_org_part_12_l3_t_201903 e_6 (cost=0.42..2.98 rows=1 width=366) (actual time=0.003..0.003 rows=0 loops=372,629)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • 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 (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
134. 297.681 297.681 ↓ 0.0 0 372,101 / 5

Index Scan using events_org_part_12_l3_t_201904_event_uuid_idx on events_org_part_12_l3_t_201904 e_7 (cost=0.42..3.00 rows=1 width=365) (actual time=0.004..0.004 rows=0 loops=372,101)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • 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 (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
135. 266.730 266.730 ↓ 0.0 0 333,413 / 5

Index Scan using events_org_part_12_l3_t_201905_event_uuid_idx on events_org_part_12_l3_t_201905 e_8 (cost=0.42..2.98 rows=1 width=1,412) (actual time=0.004..0.004 rows=0 loops=333,413)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • 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 (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
136. 225.865 225.865 ↓ 0.0 0 282,331 / 5

Index Scan using events_org_part_12_l3_t_201906_event_uuid_idx on events_org_part_12_l3_t_201906 e_9 (cost=0.42..2.99 rows=1 width=366) (actual time=0.004..0.004 rows=0 loops=282,331)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • 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 (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
137. 278.053 278.053 ↑ 1.0 1 231,711 / 5

Index Scan using events_org_part_12_l3_t_201907_event_uuid_idx on events_org_part_12_l3_t_201907 e_10 (cost=0.42..4.44 rows=1 width=882) (actual time=0.005..0.006 rows=1 loops=231,711)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • 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 (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
138. 209.356 209.356 ↓ 0.0 0 174,463 / 5

Index Scan using events_org_part_12_l3_t_201908_event_uuid_idx on events_org_part_12_l3_t_201908 e_11 (cost=0.42..4.25 rows=1 width=364) (actual time=0.005..0.006 rows=0 loops=174,463)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • 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 (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
139. 143.658 143.658 ↓ 0.0 0 143,658 / 5

Index Scan using events_org_part_12_l3_t_201909_event_uuid_idx on events_org_part_12_l3_t_201909 e_12 (cost=0.42..2.99 rows=1 width=367) (actual time=0.005..0.005 rows=0 loops=143,658)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • 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 (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
140. 85.614 85.614 ↓ 0.0 0 107,017 / 5

Index Scan using events_org_part_12_l3_t_201910_event_uuid_idx on events_org_part_12_l3_t_201910 e_13 (cost=0.42..2.97 rows=1 width=516) (actual time=0.004..0.004 rows=0 loops=107,017)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • 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 (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
141. 118.727 118.727 ↓ 0.0 0 98,939 / 5

Index Scan using events_org_part_12_l3_t_201911_event_uuid_idx on events_org_part_12_l3_t_201911 e_14 (cost=0.42..3.01 rows=1 width=513) (actual time=0.006..0.006 rows=0 loops=98,939)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • 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 (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
142. 94.667 94.667 ↑ 1.0 1 59,167 / 5

Index Scan using events_org_part_12_l3_t_201912_event_uuid_idx on events_org_part_12_l3_t_201912 e_15 (cost=0.42..2.97 rows=1 width=517) (actual time=0.008..0.008 rows=1 loops=59,167)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • 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 (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
143. 30.064 30.064 ↑ 1.0 1 15,032 / 5

Index Scan using events_org_part_12_l3_t_202001_event_uuid_idx on events_org_part_12_l3_t_202001 e_16 (cost=0.29..2.69 rows=1 width=516) (actual time=0.009..0.010 rows=1 loops=15,032)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • 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 (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
144. 36.548 36.548 ↑ 1.0 1 9,137

Index Scan using forms_org_seq_vrange_uidx on forms f (cost=0.42..3.44 rows=1 width=56) (actual time=0.004..0.004 rows=1 loops=9,137)

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

Index Scan using plans_org_seq_vrange_uidx on plans pl (cost=0.55..3.57 rows=1 width=64) (actual time=0.024..0.025 rows=1 loops=9,137)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (plan_uuid = e_2.plan_uuid))
  • Filter: ((is_visible IS TRUE) AND (valid_range @> e_2.created))
  • Rows Removed by Filter: 58
146. 18.274 18.274 ↑ 1.0 1 9,137

Index Scan using persons_org_part_67_l2_t_org_seq_vrange_uidx on persons_org_part_67_l2_t p (cost=0.29..3.31 rows=1 width=38) (actual time=0.001..0.002 rows=1 loops=9,137)

  • Index Cond: (person_uuid = e_2.submitter_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
147. 0.083 6,828.605 ↓ 5.0 100 1

Hash Right Join (cost=124.97..198.41 rows=20 width=620) (actual time=6,828.468..6,828.605 rows=100 loops=1)

  • Hash Cond: (m.event_uuid = e.event_uuid)
148. 0.012 2.537 ↓ 11.1 100 1

Subquery Scan on m (cost=124.32..197.72 rows=9 width=71) (actual time=2.459..2.537 rows=100 loops=1)

  • Filter: (m.row_number = 1)
149. 0.082 2.525 ↑ 18.4 100 1

WindowAgg (cost=124.32..174.78 rows=1,835 width=102) (actual time=2.457..2.525 rows=100 loops=1)

150. 0.110 2.443 ↑ 18.4 100 1

Sort (cost=124.32..128.91 rows=1,835 width=78) (actual time=2.435..2.443 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
151. 0.048 2.333 ↑ 18.4 100 1

Hash Left Join (cost=3.75..24.85 rows=1,835 width=78) (actual time=0.104..2.333 rows=100 loops=1)

  • Hash Cond: ((msg.language)::text = (persons_org_part_67_l2_t.language)::text)
152. 0.018 2.267 ↑ 18.4 100 1

Nested Loop (cost=0.43..5.38 rows=1,835 width=74) (actual time=0.072..2.267 rows=100 loops=1)

153. 0.049 0.049 ↓ 100.0 100 1

CTE Scan on filtered_events e_1 (cost=0.00..0.40 rows=1 width=16) (actual time=0.004..0.049 rows=100 loops=1)

  • Filter: (system_event_type IS NULL)
154. 2.200 2.200 ↑ 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.021..0.022 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: 1
155. 0.001 0.018 ↓ 0.0 0 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
156. 0.017 0.017 ↓ 0.0 0 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.017..0.017 rows=0 loops=1)

  • Index Cond: (person_uuid = 'a15b1a9d-23bc-4e1c-99f5-f0c6cd576f01'::uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
157. 0.054 6,825.985 ↓ 5.0 100 1

Hash (cost=0.40..0.40 rows=20 width=588) (actual time=6,825.985..6,825.985 rows=100 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
158. 6,825.931 6,825.931 ↓ 5.0 100 1

CTE Scan on filtered_events e (cost=0.00..0.40 rows=20 width=588) (actual time=6,822.308..6,825.931 rows=100 loops=1)

Planning time : 108.819 ms
Execution time : 6,893.594 ms