explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X7uG : Notified Filter Only

Settings
# exclusive inclusive rows x rows loops node
1. 0.363 22,342.424 ↑ 1.0 100 1

Sort (cost=1,067,030.02..1,067,030.27 rows=100 width=620) (actual time=22,342.418..22,342.424 rows=100 loops=1)

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

CTE filtered_events

3. 4.507 22,132.924 ↑ 1.0 100 1

Limit (cost=1,066,823.91..1,066,824.16 rows=100 width=671) (actual time=22,128.408..22,132.924 rows=100 loops=1)

4. 11.797 22,128.417 ↑ 4.3 100 1

Sort (cost=1,066,823.91..1,066,824.98 rows=428 width=671) (actual time=22,128.406..22,128.417 rows=100 loops=1)

  • Sort Key: e_2.event_id DESC
  • Sort Method: top-N heapsort Memory: 162kB
5. 8.463 22,116.620 ↓ 21.3 9,130 1

Nested Loop Left Join (cost=992,282.22..1,066,807.55 rows=428 width=671) (actual time=20,505.925..22,116.620 rows=9,130 loops=1)

6. 11.938 22,089.897 ↓ 415.0 9,130 1

Nested Loop Left Join (cost=992,281.94..1,066,734.57 rows=22 width=649) (actual time=20,505.845..22,089.897 rows=9,130 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. 4.626 21,794.929 ↓ 415.0 9,130 1

Nested Loop Left Join (cost=992,281.39..1,066,655.64 rows=22 width=622) (actual time=20,502.519..21,794.929 rows=9,130 loops=1)

8. 834.464 21,406.843 ↓ 415.0 9,130 1

GroupAggregate (cost=992,280.97..1,066,579.47 rows=22 width=601) (actual time=20,434.709..21,406.843 rows=9,130 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_uuid) @> '{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])
  • Rows Removed by Filter: 441571
9. 711.608 20,572.379 ↑ 1.9 459,831 1

Sort (cost=992,280.97..994,466.22 rows=874,100 width=585) (actual time=20,434.564..20,572.379 rows=459,831 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: 119472kB
10. 128.908 19,860.771 ↑ 1.9 459,831 1

Subquery Scan on e_2 (cost=544,680.49..610,237.99 rows=874,100 width=585) (actual time=19,370.582..19,860.771 rows=459,831 loops=1)

11. 161.046 19,731.863 ↑ 1.9 459,831 1

Unique (cost=544,680.49..601,496.99 rows=874,100 width=585) (actual time=19,370.577..19,731.863 rows=459,831 loops=1)

12. 886.806 19,570.817 ↑ 1.9 460,090 1

Sort (cost=544,680.49..546,865.74 rows=874,100 width=585) (actual time=19,370.575..19,570.817 rows=460,090 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: 119608kB
13. 0.000 18,684.011 ↑ 1.9 460,090 1

Gather (cost=1,026.62..162,637.51 rows=874,100 width=585) (actual time=11.984..18,684.011 rows=460,090 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
14. 109.656 18,944.446 ↑ 2.4 92,018 5 / 5

Nested Loop (cost=26.62..74,227.51 rows=218,525 width=585) (actual time=10.459..18,944.446 rows=92,018 loops=5)

15. 11.059 16,073.665 ↓ 83.1 74,625 5 / 5

Parallel Append (cost=26.20..21,280.73 rows=898 width=40) (actual time=9.729..16,073.665 rows=74,625 loops=5)

16. 27.563 30.181 ↓ 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=15.106..150.904 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.618 2.618 ↓ 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.088..13.088 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. 27.294 28.737 ↓ 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.486..143.687 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: 13728
19. 1.443 1.443 ↓ 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=7.216..7.216 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. 30.045 32.027 ↓ 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=11.668..160.137 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.983 1.983 ↓ 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.913..9.913 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. 1,411.855 1,413.916 ↓ 56.6 5,209 2 / 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=15.379..3,534.790 rows=5,209 loops=2)

  • 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
23. 2.061 2.061 ↓ 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.306..10.306 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. 24.730 26.067 ↓ 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=8.149..130.336 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.337 1.337 ↓ 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=6.684..6.684 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. 7.337 8.168 ↓ 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=5.356..40.838 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. 0.831 0.831 ↓ 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=4.155..4.155 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. 13,938.742 13,939.660 ↓ 29.4 2,056 5 / 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=10.668..13,939.660 rows=2,056 loops=5)

  • 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: 1
  • Heap Blocks: exact=747
29. 0.918 0.918 ↓ 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=4.592..4.592 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. 9.453 10.165 ↓ 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=50.824..50.824 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: 12215
31. 0.712 0.712 ↓ 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=3.560..3.560 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. 10.664 11.754 ↓ 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=7.169..58.768 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.090 1.090 ↓ 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=5.448..5.448 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. 8.436 9.291 ↓ 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=5.715..46.453 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. 0.854 0.854 ↓ 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=4.271..4.271 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. 5.532 5.916 ↓ 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=4.002..29.581 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: 2268
37. 0.384 0.384 ↓ 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=1.921..1.921 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[])))
38. 5.605 5.605 ↓ 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=28.024..28.024 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: 8423
39. 8.161 8.161 ↓ 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.048..40.805 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
40. 7.771 7.771 ↓ 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.055..38.853 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
41. 8.033 8.033 ↓ 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.044..40.167 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
42. 7.798 7.798 ↓ 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.048..38.991 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
43. 25.079 25.079 ↓ 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.130..125.393 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
44. 19.858 19.858 ↓ 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.126..99.292 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)))
45. 28.117 28.117 ↓ 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.128..140.587 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
46. 20.667 20.667 ↓ 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.138..103.333 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
47. 33.011 33.011 ↓ 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.178..165.053 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
48. 30.609 30.609 ↓ 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.115..153.044 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
49. 24.987 24.987 ↓ 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.118..124.934 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
50. 21.620 21.620 ↓ 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.120..108.101 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
51. 24.720 24.720 ↓ 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.155..123.600 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
52. 26.314 26.314 ↓ 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.162..131.572 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)))
53. 23.227 23.227 ↓ 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.141..116.136 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
54. 14.598 14.598 ↓ 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.098..36.495 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
55. 18.223 18.223 ↓ 166.4 7,985 1 / 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.083..91.114 rows=7,985 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
56. 21.818 21.818 ↓ 194.9 9,940 1 / 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.134..109.088 rows=9,940 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)))
57. 27.412 27.412 ↓ 238.7 12,411 1 / 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.092..137.060 rows=12,411 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
58. 12.701 12.701 ↓ 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.108..63.505 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
59. 18.483 18.483 ↓ 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.097..92.417 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
60. 27.543 27.543 ↓ 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..137.715 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)))
61. 16.692 16.692 ↓ 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.078..83.459 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
62. 18.783 18.783 ↓ 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.072..93.916 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
63. 0.411 0.411 ↓ 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.073..2.056 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
64. 20.162 20.162 ↓ 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.070..100.808 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
65. 0.322 0.322 ↓ 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.074..1.610 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
66. 0.325 0.325 ↓ 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.069..1.625 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
67. 0.342 0.342 ↓ 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.068..1.708 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
68. 0.375 0.375 ↓ 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.066..1.874 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
69. 0.343 0.343 ↓ 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.073..1.714 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
70. 0.379 0.379 ↓ 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.071..1.893 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
71. 0.639 0.639 ↓ 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.067..3.193 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
72. 0.282 0.282 ↓ 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.062..1.412 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
73. 0.209 0.209 ↓ 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.078..1.044 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
74. 6.641 6.641 ↓ 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.100..33.206 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
75. 22.576 22.576 ↓ 1,931.8 7,727 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx50 on notifications_summary_weekly_partitioned_2020_w2 ns_49 (cost=0.56..57.06 rows=4 width=40) (actual time=0.097..112.881 rows=7,727 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
76. 1.862 1.862 ↓ 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.105..9.310 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)))
77. 0.000 0.000 ↓ 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.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)))
78. 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.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.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.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)))
80. 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)))
81. 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.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.000 0.000 ↓ 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.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)))
83. 0.001 0.001 ↓ 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.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_idx58 on notifications_summary_weekly_partitioned_2020_w10 ns_57 (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_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)))
86. 0.000 0.000 ↓ 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.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)))
87. 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.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)))
88. 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.002..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)))
89. 0.000 0.000 ↓ 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.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)))
90. 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.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.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.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)))
92. 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)))
93. 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.002..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.000 0.000 ↓ 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.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)))
95. 0.000 0.000 ↓ 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.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)))
96. 0.000 0.000 ↓ 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.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)))
97. 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)))
98. 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)))
99. 0.000 0.000 ↓ 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.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)))
100. 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)))
101. 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.002..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_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)))
103. 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.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.000 0.000 ↓ 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.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)))
105. 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.002..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_idx80 on notifications_summary_weekly_partitioned_2020_w32 ns_79 (cost=0.14..3.16 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: ((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.000 0.000 ↓ 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.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)))
108. 0.000 0.000 ↓ 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.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)))
109. 0.000 0.000 ↓ 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.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)))
110. 0.000 0.000 ↓ 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.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)))
111. 0.000 0.000 ↓ 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.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)))
112. 0.000 0.000 ↓ 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.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)))
113. 0.000 0.000 ↓ 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.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)))
114. 0.000 0.000 ↓ 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.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)))
115. 0.001 0.001 ↓ 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.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_idx90 on notifications_summary_weekly_partitioned_2020_w42 ns_89 (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_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)))
118. 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)))
119. 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)))
120. 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.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_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)))
122. 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)))
123. 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)))
124. 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.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_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)))
126. 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.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.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.010..0.010 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. 289.420 2,761.125 ↑ 25.0 1 373,125 / 5

Append (cost=0.42..57.49 rows=25 width=567) (actual time=0.035..0.037 rows=1 loops=373,125)

  • Subplans Removed: 11
129. 298.500 298.500 ↓ 0.0 0 373,125 / 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,125)

  • 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))))
130. 149.250 149.250 ↓ 0.0 0 373,125 / 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.77 rows=1 width=366) (actual time=0.002..0.002 rows=0 loops=373,125)

  • 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. 149.224 149.224 ↓ 0.0 0 373,061 / 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.75 rows=1 width=365) (actual time=0.002..0.002 rows=0 loops=373,061)

  • 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.487 223.487 ↓ 0.0 0 372,478 / 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,478)

  • 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. 223.170 223.170 ↓ 0.0 0 371,950 / 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.003..0.003 rows=0 loops=371,950)

  • 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. 266.610 266.610 ↓ 0.0 0 333,262 / 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,262)

  • 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. 225.744 225.744 ↓ 0.0 0 282,180 / 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,180)

  • 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. 277.872 277.872 ↑ 1.0 1 231,560 / 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,560)

  • 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. 174.312 174.312 ↓ 0.0 0 174,312 / 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.004..0.005 rows=0 loops=174,312)

  • 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. 143.507 143.507 ↓ 0.0 0 143,507 / 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,507)

  • 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. 85.493 85.493 ↓ 0.0 0 106,866 / 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,866)

  • 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. 118.546 118.546 ↓ 0.0 0 98,788 / 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,788)

  • 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. 106.229 106.229 ↑ 1.0 1 59,016 / 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.009..0.009 rows=1 loops=59,016)

  • 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. 29.762 29.762 ↑ 1.0 1 14,881 / 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,881)

  • 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. 383.460 383.460 ↑ 1.0 1 9,130

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

  • 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
144. 283.030 283.030 ↑ 1.0 1 9,130

Index Scan using plans_org_seq_vrange_uidx on plans pl (cost=0.55..3.57 rows=1 width=64) (actual time=0.030..0.031 rows=1 loops=9,130)

  • 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
145. 18.260 18.260 ↑ 1.0 1 9,130

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,130)

  • 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))
146. 0.098 22,342.061 ↑ 1.0 100 1

Hash Right Join (cost=129.10..202.53 rows=100 width=620) (actual time=22,341.915..22,342.061 rows=100 loops=1)

  • Hash Cond: (m.event_uuid = e.event_uuid)
147. 0.011 208.917 ↓ 11.1 100 1

Subquery Scan on m (cost=125.85..199.21 rows=9 width=71) (actual time=208.835..208.917 rows=100 loops=1)

  • Filter: (m.row_number = 1)
148. 0.104 208.906 ↑ 18.3 100 1

WindowAgg (cost=125.85..176.28 rows=1,834 width=102) (actual time=208.833..208.906 rows=100 loops=1)

149. 0.329 208.802 ↑ 18.3 100 1

Sort (cost=125.85..130.43 rows=1,834 width=78) (actual time=208.792..208.802 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
150. 0.346 208.473 ↑ 18.3 100 1

Hash Left Join (cost=3.75..26.44 rows=1,834 width=78) (actual time=2.953..208.473 rows=100 loops=1)

  • Hash Cond: ((msg.language)::text = (persons_org_part_67_l2_t.language)::text)
151. 0.234 208.102 ↑ 18.3 100 1

Nested Loop (cost=0.43..6.98 rows=1,834 width=74) (actual time=2.908..208.102 rows=100 loops=1)

152. 0.168 0.168 ↓ 100.0 100 1

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

  • Filter: (system_event_type IS NULL)
153. 207.700 207.700 ↑ 1.0 1 100

Index Scan using messages_org_part_12_event_uuid_idx on messages_org_part_12 msg (cost=0.43..4.97 rows=1 width=74) (actual time=2.075..2.077 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
154. 0.001 0.025 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
155. 0.024 0.024 ↓ 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.024..0.024 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))
156. 0.051 22,133.046 ↑ 1.0 100 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
157. 22,132.995 22,132.995 ↑ 1.0 100 1

CTE Scan on filtered_events e (cost=0.00..2.00 rows=100 width=588) (actual time=22,128.416..22,132.995 rows=100 loops=1)

Planning time : 140.337 ms
Execution time : 22,418.802 ms