explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K8rG : Notified Filter Only

Settings
# exclusive inclusive rows x rows loops node
1. 0.317 8,610.006 ↑ 1.0 100 1

Sort (cost=1,090,114.46..1,090,114.71 rows=100 width=620) (actual time=8,610.001..8,610.006 rows=100 loops=1)

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

CTE filtered_events

3. 2.959 8,606.331 ↑ 1.0 100 1

Limit (cost=1,089,908.24..1,089,908.49 rows=100 width=671) (actual time=8,603.361..8,606.331 rows=100 loops=1)

4. 11.482 8,603.372 ↑ 4.3 100 1

Sort (cost=1,089,908.24..1,089,909.31 rows=428 width=671) (actual time=8,603.359..8,603.372 rows=100 loops=1)

  • Sort Key: e_2.event_id DESC
  • Sort Method: top-N heapsort Memory: 162kB
5. 6.744 8,591.890 ↓ 21.3 9,135 1

Nested Loop Left Join (cost=1,013,776.20..1,089,891.88 rows=428 width=671) (actual time=7,138.775..8,591.890 rows=9,135 loops=1)

6. 5.392 8,566.876 ↓ 415.2 9,135 1

Nested Loop Left Join (cost=1,013,775.92..1,089,818.90 rows=22 width=649) (actual time=7,138.750..8,566.876 rows=9,135 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. 10.015 8,296.569 ↓ 415.2 9,135 1

Nested Loop Left Join (cost=1,013,775.37..1,089,739.97 rows=22 width=622) (actual time=7,138.538..8,296.569 rows=9,135 loops=1)

8. 897.812 8,186.069 ↓ 415.2 9,135 1

GroupAggregate (cost=1,013,774.95..1,089,663.80 rows=22 width=601) (actual time=7,138.471..8,186.069 rows=9,135 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: 441,674
9. 718.589 7,288.257 ↑ 1.9 459,944 1

Sort (cost=1,013,774.95..1,016,006.97 rows=892,810 width=585) (actual time=7,138.382..7,288.257 rows=459,944 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: 119,520kB
10. 136.261 6,569.668 ↑ 1.9 459,944 1

Subquery Scan on e_2 (cost=556,456.89..623,417.64 rows=892,810 width=585) (actual time=6,082.944..6,569.668 rows=459,944 loops=1)

11. 162.084 6,433.407 ↑ 1.9 459,944 1

Unique (cost=556,456.89..614,489.54 rows=892,810 width=585) (actual time=6,082.937..6,433.407 rows=459,944 loops=1)

12. 1,046.127 6,271.323 ↑ 1.9 460,203 1

Sort (cost=556,456.89..558,688.91 rows=892,810 width=585) (actual time=6,082.934..6,271.323 rows=460,203 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: 119,616kB
13. 0.000 5,225.196 ↑ 1.9 460,203 1

Gather (cost=1,026.62..166,099.57 rows=892,810 width=585) (actual time=14.094..5,225.196 rows=460,203 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
14. 107.435 5,329.496 ↑ 2.4 92,041 5 / 5

Nested Loop (cost=26.62..75,818.57 rows=223,202 width=585) (actual time=10.728..5,329.496 rows=92,041 loops=5)

15. 10.603 1,638.976 ↓ 81.5 74,648 5 / 5

Parallel Append (cost=26.20..21,844.71 rows=916 width=40) (actual time=9.958..1,638.976 rows=74,648 loops=5)

16. 28.885 31.617 ↓ 95.6 11,380 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w46 ns_41 (cost=38.24..1,541.37 rows=119 width=40) (actual time=16.306..158.083 rows=11,380 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 2.731 2.731 ↓ 11.5 11,535 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx41 (cost=0.00..38.19 rows=1,007 width=0) (actual time=13.657..13.657 rows=11,535 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
18. 39.371 40.655 ↓ 84.7 593 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w40 ns_35 (cost=28.29..1,836.85 rows=7 width=40) (actual time=9.137..203.276 rows=593 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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
19. 1.284 1.284 ↓ 11.8 14,321 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx35 (cost=0.00..28.29 rows=1,216 width=0) (actual time=6.419..6.419 rows=14,321 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
20. 26.653 28.465 ↓ 121.1 10,290 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2020_w1 ns_48 (cost=26.44..1,112.62 rows=85 width=40) (actual time=10.901..142.323 rows=10,290 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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
21. 1.811 1.811 ↓ 14.2 10,292 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx49 (cost=0.00..26.41 rows=727 width=0) (actual time=9.056..9.056 rows=10,292 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
22. 30.282 32.477 ↓ 113.2 10,418 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w50 ns_45 (cost=26.20..1,077.48 rows=92 width=40) (actual time=13.156..162.386 rows=10,418 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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
23. 2.195 2.195 ↓ 14.8 10,425 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx45 (cost=0.00..26.16 rows=703 width=0) (actual time=10.976..10.976 rows=10,425 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
24. 26.303 27.826 ↓ 133.0 8,909 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w48 ns_43 (cost=24.77..867.91 rows=67 width=40) (actual time=9.570..139.132 rows=8,909 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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
25. 1.523 1.523 ↓ 15.9 8,913 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx43 (cost=0.00..24.75 rows=562 width=0) (actual time=7.617..7.617 rows=8,913 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
26. 17.819 18.915 ↓ 112.9 7,339 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w45 ns_40 (cost=24.69..855.71 rows=65 width=40) (actual time=6.758..94.574 rows=7,339 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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
27. 1.096 1.096 ↓ 13.3 7,344 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx40 (cost=0.00..24.66 rows=554 width=0) (actual time=5.479..5.479 rows=7,344 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
28. 24.358 25.465 ↓ 146.9 10,282 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w51 ns_46 (cost=22.15..920.47 rows=70 width=40) (actual time=7.272..127.324 rows=10,282 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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
29. 1.107 1.107 ↓ 17.1 10,289 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx46 (cost=0.00..22.12 rows=600 width=0) (actual time=5.535..5.535 rows=10,289 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
30. 25.860 27.038 ↓ 0.0 0 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w41 ns_36 (cost=21.61..1,288.20 rows=1 width=40) (actual time=135.188..135.188 rows=0 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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
31. 1.178 1.178 ↓ 14.4 12,215 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx36 (cost=0.00..21.61 rows=848 width=0) (actual time=5.890..5.890 rows=12,215 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
32. 29.853 31.102 ↓ 167.9 10,748 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w47 ns_42 (cost=21.53..826.57 rows=64 width=40) (actual time=8.253..155.512 rows=10,748 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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
33. 1.249 1.249 ↓ 20.0 10,752 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx42 (cost=0.00..21.50 rows=537 width=0) (actual time=6.246..6.247 rows=10,752 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
34. 24.845 26.498 ↓ 152.6 8,850 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w52 ns_47 (cost=18.10..758.75 rows=58 width=40) (actual time=10.355..132.490 rows=8,850 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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.653 1.653 ↓ 17.9 8,853 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx47 (cost=0.00..18.08 rows=495 width=0) (actual time=8.265..8.265 rows=8,853 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
36. 61.101 62.086 ↓ 160.0 7,840 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2020_w2 ns_49 (cost=17.18..620.95 rows=49 width=40) (actual time=6.570..310.429 rows=7,840 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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.984 0.984 ↓ 22.2 8,963 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx50 (cost=0.00..17.16 rows=403 width=0) (actual time=4.921..4.922 rows=8,963 loops=1)

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

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w43 ns_38 (cost=13.07..454.65 rows=22 width=40) (actual time=6.467..70.682 rows=3,908 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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.501 0.501 ↓ 21.0 6,176 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx38 (cost=0.00..13.06 rows=294 width=0) (actual time=2.505..2.505 rows=6,176 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])))
40. 13.981 13.981 ↓ 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..767.39 rows=1 width=40) (actual time=69.907..69.907 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 36.904 36.904 ↓ 134.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..559.84 rows=99 width=40) (actual time=0.142..184.519 rows=13,341 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 39.944 39.944 ↓ 139.5 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..484.61 rows=74 width=40) (actual time=0.120..199.722 rows=10,325 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 53.296 53.296 ↓ 149.4 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..484.24 rows=85 width=40) (actual time=0.144..266.482 rows=12,697 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 50.355 50.355 ↓ 154.8 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..467.72 rows=76 width=40) (actual time=0.155..251.773 rows=11,763 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 51.625 51.625 ↓ 173.8 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..458.29 rows=77 width=40) (actual time=0.139..258.126 rows=13,386 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 38.654 38.654 ↓ 151.5 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..449.99 rows=76 width=40) (actual time=0.174..193.272 rows=11,511 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 69.944 69.944 ↓ 171.8 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..435.17 rows=74 width=40) (actual time=0.150..349.722 rows=12,711 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 68.440 68.440 ↓ 141.1 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..422.46 rows=74 width=40) (actual time=0.372..342.199 rows=10,445 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 114.114 114.114 ↓ 197.7 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..398.47 rows=67 width=40) (actual time=0.162..570.572 rows=13,244 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 126.108 126.108 ↓ 197.6 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..391.23 rows=68 width=40) (actual time=0.302..630.540 rows=13,440 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 86.828 86.828 ↓ 188.4 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..382.17 rows=63 width=40) (actual time=0.180..434.138 rows=11,870 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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
52. 70.030 70.030 ↓ 167.5 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..378.42 rows=66 width=40) (actual time=0.222..350.152 rows=11,054 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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
53. 41.622 41.622 ↓ 167.4 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..355.03 rows=60 width=40) (actual time=0.173..208.112 rows=10,047 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 42.960 42.960 ↓ 224.5 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..342.39 rows=61 width=40) (actual time=0.189..214.802 rows=13,694 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 33.387 33.387 ↓ 248.5 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..321.68 rows=55 width=40) (actual time=0.143..166.933 rows=13,666 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 21.571 21.571 ↓ 94.3 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..313.40 rows=54 width=40) (actual time=0.163..53.927 rows=5,091 loops=2)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 16.282 16.282 ↓ 41.6 1,996 4 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx31 on notifications_summary_weekly_partitioned_2019_w36 ns_31 (cost=0.56..312.52 rows=48 width=40) (actual time=0.116..20.353 rows=1,996 loops=4)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 24.898 24.898 ↓ 65.0 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..307.65 rows=51 width=40) (actual time=0.126..41.496 rows=3,313 loops=3)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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.950 28.950 ↓ 119.3 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..297.44 rows=52 width=40) (actual time=0.157..72.376 rows=6,206 loops=2)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 25.867 25.867 ↓ 115.3 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..295.47 rows=52 width=40) (actual time=0.176..129.336 rows=5,996 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 74.451 74.451 ↓ 138.7 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..287.73 rows=48 width=40) (actual time=0.141..372.255 rows=6,656 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 63.443 63.443 ↓ 1,441.9 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..83.72 rows=7 width=40) (actual time=0.086..317.217 rows=10,093 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 16.045 16.045 ↓ 1,384.4 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..75.41 rows=5 width=40) (actual time=0.058..80.223 rows=6,922 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 17.223 17.223 ↓ 1,685.0 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..43.46 rows=7 width=40) (actual time=0.064..86.113 rows=11,795 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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.352 0.352 ↓ 31.6 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..33.53 rows=5 width=40) (actual time=0.055..1.758 rows=158 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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. 22.071 22.071 ↓ 2,357.8 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..31.35 rows=5 width=40) (actual time=0.084..110.356 rows=11,789 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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.404 0.404 ↓ 32.2 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..28.69 rows=4 width=40) (actual time=0.069..2.018 rows=129 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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.324 0.324 ↓ 30.8 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..26.62 rows=4 width=40) (actual time=0.074..1.622 rows=123 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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.352 0.352 ↓ 31.2 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..25.33 rows=4 width=40) (actual time=0.131..1.761 rows=125 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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.354 0.354 ↓ 33.5 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..23.26 rows=4 width=40) (actual time=0.061..1.768 rows=134 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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.354 0.354 ↓ 25.8 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..22.66 rows=4 width=40) (actual time=0.072..1.771 rows=103 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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.386 0.386 ↓ 33.5 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..21.90 rows=4 width=40) (actual time=0.074..1.929 rows=134 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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.649 0.649 ↓ 85.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..21.88 rows=3 width=40) (actual time=0.060..3.243 rows=255 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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.322 0.322 ↓ 52.5 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..17.96 rows=2 width=40) (actual time=0.064..1.612 rows=105 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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.222 0.222 ↓ 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..14.45 rows=2 width=40) (actual time=0.101..1.110 rows=67 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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.747 7.747 ↓ 179.7 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..126.72 rows=20 width=40) (actual time=0.069..38.737 rows=3,594 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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.597 1.597 ↓ 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..6.99 rows=1 width=40) (actual time=0.103..7.985 rows=791 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = ANY ('{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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
80. 0.001 0.001 ↓ 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
82. 0.001 0.001 ↓ 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
88. 0.001 0.001 ↓ 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.16 rows=1 width=40) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
89. 0.001 0.001 ↓ 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
92. 0.001 0.001 ↓ 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 rows=1 width=40) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
106. 0.001 0.001 ↓ 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
119. 0.001 0.001 ↓ 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 rows=1 width=40) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
124. 0.001 0.001 ↓ 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 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: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) 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.16 rows=1 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((recipient_uuid = ANY ('{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])) AND (category = 'PERSON'::text) AND (((delivery_status)::text = 'DELIVERED'::text) OR ((delivery_status)::text = 'RESPONDED'::text)))
129. 369.763 3,583.085 ↑ 25.0 1 373,238 / 5

Append (cost=0.42..57.46 rows=25 width=567) (actual time=0.046..0.048 rows=1 loops=373,238)

  • Subplans Removed: 11
130. 298.590 298.590 ↓ 0.0 0 373,238 / 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,238)

  • 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.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
131. 223.943 223.943 ↓ 0.0 0 373,238 / 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,238)

  • 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.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
132. 223.904 223.904 ↓ 0.0 0 373,174 / 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,174)

  • 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.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
133. 298.073 298.073 ↓ 0.0 0 372,591 / 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.004..0.004 rows=0 loops=372,591)

  • 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.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
134. 372.063 372.063 ↓ 0.0 0 372,063 / 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.005..0.005 rows=0 loops=372,063)

  • 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.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
135. 333.375 333.375 ↓ 0.0 0 333,375 / 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.005..0.005 rows=0 loops=333,375)

  • 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.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
136. 338.752 338.752 ↓ 0.0 0 282,293 / 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.006..0.006 rows=0 loops=282,293)

  • 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.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
137. 370.677 370.677 ↑ 1.0 1 231,673 / 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.007..0.008 rows=1 loops=231,673)

  • 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.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
138. 209.310 209.310 ↓ 0.0 0 174,425 / 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.26 rows=1 width=364) (actual time=0.005..0.006 rows=0 loops=174,425)

  • 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.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
139. 172.344 172.344 ↓ 0.0 0 143,620 / 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.006..0.006 rows=0 loops=143,620)

  • 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.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
140. 85.583 85.583 ↓ 0.0 0 106,979 / 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=106,979)

  • 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.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
141. 138.461 138.461 ↓ 0.0 0 98,901 / 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.007..0.007 rows=0 loops=98,901)

  • 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.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
142. 118.258 118.258 ↑ 1.0 1 59,129 / 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.010..0.010 rows=1 loops=59,129)

  • 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.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
143. 29.988 29.988 ↑ 1.0 1 14,994 / 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=14,994)

  • 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.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
144. 100.485 100.485 ↑ 1.0 1 9,135

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

  • 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. 264.915 264.915 ↑ 1.0 1 9,135

Index Scan using plans_org_seq_vrange_uidx on plans pl (cost=0.55..3.57 rows=1 width=64) (actual time=0.027..0.029 rows=1 loops=9,135)

  • 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.270 18.270 ↑ 1.0 1 9,135

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.002..0.002 rows=1 loops=9,135)

  • 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.154 8,609.689 ↑ 1.0 100 1

Hash Right Join (cost=129.17..202.64 rows=100 width=620) (actual time=8,609.505..8,609.689 rows=100 loops=1)

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

Subquery Scan on m (cost=125.92..199.32 rows=9 width=71) (actual time=2.954..3.056 rows=100 loops=1)

  • Filter: (m.row_number = 1)
149. 0.111 3.042 ↑ 18.4 100 1

WindowAgg (cost=125.92..176.38 rows=1,835 width=102) (actual time=2.951..3.042 rows=100 loops=1)

150. 0.127 2.931 ↑ 18.4 100 1

Sort (cost=125.92..130.51 rows=1,835 width=78) (actual time=2.920..2.931 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.079 2.804 ↑ 18.4 100 1

Hash Left Join (cost=3.75..26.45 rows=1,835 width=78) (actual time=0.163..2.804 rows=100 loops=1)

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

Nested Loop (cost=0.43..6.98 rows=1,835 width=74) (actual time=0.098..2.699 rows=100 loops=1)

153. 0.057 0.057 ↓ 100.0 100 1

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

  • Filter: (system_event_type IS NULL)
154. 2.600 2.600 ↑ 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.026..0.026 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.000 0.026 ↓ 0.0 0 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
156. 0.026 0.026 ↓ 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.025..0.026 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.065 8,606.479 ↑ 1.0 100 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
158. 8,606.414 8,606.414 ↑ 1.0 100 1

CTE Scan on filtered_events e (cost=0.00..2.00 rows=100 width=588) (actual time=8,603.370..8,606.414 rows=100 loops=1)

Planning time : 148.074 ms
Execution time : 8,674.869 ms