explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LAuU : Filter and Permission, Reduced group clauses

Settings
# exclusive inclusive rows x rows loops node
1. 0.260 7,753.963 ↑ 1.0 100 1

Sort (cost=82,997.71..82,997.96 rows=100 width=620) (actual time=7,753.958..7,753.963 rows=100 loops=1)

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

CTE filtered_events

3. 0.021 7,751.722 ↑ 1.0 100 1

Limit (cost=82,791.50..82,791.75 rows=100 width=514) (actual time=7,751.704..7,751.722 rows=100 loops=1)

4.          

CTE da_events

5. 225.319 5,837.718 ↓ 48.6 453,492 1

Unique (cost=80,779.50..81,386.01 rows=9,331 width=585) (actual time=5,382.202..5,837.718 rows=453,492 loops=1)

6. 900.326 5,612.399 ↓ 48.6 453,731 1

Sort (cost=80,779.50..80,802.82 rows=9,331 width=585) (actual time=5,382.198..5,612.399 rows=453,731 loops=1)

  • Sort Key: e_2.event_uuid, e_2.event_id, e_2.submitter_uuid, e_2.priority, e_2.incident_id, e_2.override_device_restrictions, e_2.escalation_override, e_2.bypass_phone_intro, e_2.require_phone_password, e_2.conference_properties, e_2.created, e_2.status, e_2.terminated, e_2.request_uuid, e_2.sequence, e_2.revision_uuid, e_2.event_type, e_2.system_event_type, e_2.form_uuid, e_2.plan_uuid, e_2.choices, (lower(e_2.valid_range)), (upper(e_2.valid_range)), ns_41.recipient_uuid, e_2.recipients
  • Sort Method: external merge Disk: 117,992kB
7. 0.000 4,712.073 ↓ 48.6 453,731 1

Gather (cost=1,028.06..80,164.22 rows=9,331 width=585) (actual time=15.894..4,712.073 rows=453,731 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
8. 121.633 4,871.965 ↓ 38.9 90,746 5 / 5

Nested Loop (cost=28.06..78,231.12 rows=2,333 width=585) (actual time=12.695..4,871.965 rows=90,746 loops=5)

9. 11.443 1,017.352 ↓ 77.9 74,660 5 / 5

Parallel Append (cost=27.64..22,895.32 rows=958 width=40) (actual time=11.493..1,017.352 rows=74,660 loops=5)

10. 39.569 42.563 ↓ 92.5 11,380 1 / 5

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2020_w2 ns_49 (cost=19.50..662.41 rows=52 width=40) (actual time=6.421..127.191 rows=7,900 loops=1)

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

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx50 (cost=0.00..19.48 rows=429 width=0) (actual time=5.037..5.037 rows=8,087 loops=1)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx74 on notifications_summary_weekly_partitioned_2020_w26 ns_73 (cost=0.14..3.17 rows=1 width=40) (actual time=0.004..0.005 rows=0 loops=1)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx98 on notifications_summary_weekly_partitioned_2020_w50 ns_97 (cost=0.14..3.17 rows=1 width=40) (actual time=0.003..0.004 rows=0 loops=1)

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

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

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

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

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

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

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

Append (cost=0.42..57.50 rows=25 width=567) (actual time=0.048..0.050 rows=1 loops=373,298)

  • Subplans Removed: 11
124. 373.298 373.298 ↓ 0.0 0 373,298 / 5

Index Scan using events_org_part_12_l3_t_2018_event_uuid_idx on events_org_part_12_l3_t_2018 e_2 (cost=0.42..3.00 rows=1 width=363) (actual time=0.005..0.005 rows=0 loops=373,298)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
125. 223.979 223.979 ↓ 0.0 0 373,298 / 5

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

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
126. 223.940 223.940 ↓ 0.0 0 373,234 / 5

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

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
127. 298.121 298.121 ↓ 0.0 0 372,651 / 5

Index Scan using events_org_part_12_l3_t_201903_event_uuid_idx on events_org_part_12_l3_t_201903 e_5 (cost=0.42..2.98 rows=1 width=366) (actual time=0.004..0.004 rows=0 loops=372,651)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
128. 372.123 372.123 ↓ 0.0 0 372,123 / 5

Index Scan using events_org_part_12_l3_t_201904_event_uuid_idx on events_org_part_12_l3_t_201904 e_6 (cost=0.42..3.00 rows=1 width=365) (actual time=0.005..0.005 rows=0 loops=372,123)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
129. 333.435 333.435 ↓ 0.0 0 333,435 / 5

Index Scan using events_org_part_12_l3_t_201905_event_uuid_idx on events_org_part_12_l3_t_201905 e_7 (cost=0.42..2.98 rows=1 width=1,412) (actual time=0.005..0.005 rows=0 loops=333,435)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
130. 338.824 338.824 ↓ 0.0 0 282,353 / 5

Index Scan using events_org_part_12_l3_t_201906_event_uuid_idx on events_org_part_12_l3_t_201906 e_8 (cost=0.42..2.99 rows=1 width=366) (actual time=0.006..0.006 rows=0 loops=282,353)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
131. 370.773 370.773 ↑ 1.0 1 231,733 / 5

Index Scan using events_org_part_12_l3_t_201907_event_uuid_idx on events_org_part_12_l3_t_201907 e_9 (cost=0.42..4.44 rows=1 width=882) (actual time=0.007..0.008 rows=1 loops=231,733)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
132. 244.279 244.279 ↓ 0.0 0 174,485 / 5

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

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
133. 172.416 172.416 ↓ 0.0 0 143,680 / 5

Index Scan using events_org_part_12_l3_t_201909_event_uuid_idx on events_org_part_12_l3_t_201909 e_11 (cost=0.42..2.99 rows=1 width=367) (actual time=0.006..0.006 rows=0 loops=143,680)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
134. 107.039 107.039 ↓ 0.0 0 107,039 / 5

Index Scan using events_org_part_12_l3_t_201910_event_uuid_idx on events_org_part_12_l3_t_201910 e_12 (cost=0.42..2.97 rows=1 width=516) (actual time=0.005..0.005 rows=0 loops=107,039)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
135. 158.338 158.338 ↓ 0.0 0 98,961 / 5

Index Scan using events_org_part_12_l3_t_201911_event_uuid_idx on events_org_part_12_l3_t_201911 e_13 (cost=0.42..3.01 rows=1 width=513) (actual time=0.008..0.008 rows=0 loops=98,961)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
136. 142.054 142.054 ↑ 1.0 1 59,189 / 5

Index Scan using events_org_part_12_l3_t_201912_event_uuid_idx on events_org_part_12_l3_t_201912 e_14 (cost=0.42..2.97 rows=1 width=517) (actual time=0.011..0.012 rows=1 loops=59,189)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
137. 39.140 39.140 ↑ 1.0 1 15,054 / 5

Index Scan using events_org_part_12_l3_t_202001_event_uuid_idx on events_org_part_12_l3_t_202001 e_15 (cost=0.29..2.69 rows=1 width=516) (actual time=0.013..0.013 rows=1 loops=15,054)

  • Index Cond: (event_uuid = ns_41.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (ns_41.created_date >= created) AND (created <= now()) AND ((ns_41.recipient_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid) OR (submitter_uuid = '5262d57c-4cfa-4a82-a9d0-74ed1a5eaedd'::uuid)) AND (ns_41.created_date <= LEAST(terminated, (created + '1 mon'::interval))))
  • Rows Removed by Filter: 0
138. 18.583 7,751.701 ↑ 9.1 100 1

Sort (cost=1,405.49..1,407.77 rows=914 width=514) (actual time=7,751.696..7,751.701 rows=100 loops=1)

  • Sort Key: e_16.event_id DESC
  • Sort Method: top-N heapsort Memory: 110kB
139. 8.369 7,733.118 ↓ 20.0 18,276 1

Nested Loop Left Join (cost=876.16..1,370.55 rows=914 width=514) (actual time=6,835.648..7,733.118 rows=18,276 loops=1)

140. 9.934 7,688.197 ↓ 397.3 18,276 1

Nested Loop Left Join (cost=875.87..1,331.11 rows=46 width=492) (actual time=6,835.607..7,688.197 rows=18,276 loops=1)

141. 17.922 7,605.159 ↓ 397.3 18,276 1

Nested Loop Left Join (cost=875.45..1,228.43 rows=46 width=471) (actual time=6,835.512..7,605.159 rows=18,276 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[])))
142. 101.500 7,075.509 ↓ 388.9 18,276 1

Hash Join (cost=874.90..1,086.54 rows=47 width=444) (actual time=6,834.872..7,075.509 rows=18,276 loops=1)

  • Hash Cond: (e_16.event_uuid = enr.event_uuid)
143. 5,521.424 5,521.424 ↓ 48.6 453,492 1

CTE Scan on da_events e_16 (cost=0.00..186.62 rows=9,331 width=444) (actual time=5,382.211..5,521.424 rows=453,492 loops=1)

144. 2.648 1,452.585 ↓ 8,895.0 8,895 1

Hash (cost=874.89..874.89 rows=1 width=16) (actual time=1,452.585..1,452.585 rows=8,895 loops=1)

  • Buckets: 16,384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 545kB
145. 1.211 1,449.937 ↓ 8,895.0 8,895 1

Subquery Scan on enr (cost=801.90..874.89 rows=1 width=16) (actual time=942.478..1,449.937 rows=8,895 loops=1)

146. 435.247 1,448.726 ↓ 8,895.0 8,895 1

GroupAggregate (cost=801.90..874.88 rows=1 width=48) (actual time=942.475..1,448.726 rows=8,895 loops=1)

  • Group Key: e_17.event_uuid
  • Filter: (array_agg(DISTINCT e_17.notified_uuids) @> '{b545ffb1-6338-4399-9042-71bf4ea12192,63a499dc-0993-45e6-9a56-9756e0a7b649}'::uuid[])
  • Rows Removed by Filter: 349,237
147. 201.963 1,013.479 ↓ 48.6 453,492 1

Sort (cost=801.90..825.23 rows=9,331 width=32) (actual time=942.396..1,013.479 rows=453,492 loops=1)

  • Sort Key: e_17.event_uuid
  • Sort Method: external merge Disk: 18,664kB
148. 811.516 811.516 ↓ 48.6 453,492 1

CTE Scan on da_events e_17 (cost=0.00..186.62 rows=9,331 width=32) (actual time=0.019..811.516 rows=453,492 loops=1)

149. 511.728 511.728 ↑ 1.0 1 18,276

Index Scan using plans_org_seq_vrange_uidx on plans pl (cost=0.55..3.00 rows=1 width=64) (actual time=0.027..0.028 rows=1 loops=18,276)

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

Index Scan using forms_org_seq_vrange_uidx on forms f (cost=0.42..2.22 rows=1 width=56) (actual time=0.004..0.004 rows=1 loops=18,276)

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

Index Scan using persons_org_part_67_l2_t_org_seq_vrange_uidx on persons_org_part_67_l2_t p (cost=0.29..0.85 rows=1 width=38) (actual time=0.002..0.002 rows=1 loops=18,276)

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

Hash Right Join (cost=129.17..202.64 rows=100 width=620) (actual time=7,753.579..7,753.703 rows=100 loops=1)

  • Hash Cond: (m.event_uuid = e.event_uuid)
153. 0.010 1.755 ↓ 5.6 50 1

Subquery Scan on m (cost=125.92..199.32 rows=9 width=71) (actual time=1.678..1.755 rows=50 loops=1)

  • Filter: (m.row_number = 1)
  • Rows Removed by Filter: 50
154. 0.086 1.745 ↑ 18.4 100 1

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

155. 0.128 1.659 ↑ 18.4 100 1

Sort (cost=125.92..130.51 rows=1,835 width=78) (actual time=1.647..1.659 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
156. 0.065 1.531 ↑ 18.4 100 1

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

  • Hash Cond: ((msg.language)::text = (persons_org_part_67_l2_t.language)::text)
157. 0.016 1.452 ↑ 18.4 100 1

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

158. 0.036 0.036 ↓ 100.0 100 1

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

  • Filter: (system_event_type IS NULL)
159. 1.400 1.400 ↑ 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.014..0.014 rows=1 loops=100)

  • Index Cond: (event_uuid = e_1.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
  • Rows Removed by Filter: 0
160. 0.001 0.014 ↓ 0.0 0 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
161. 0.013 0.013 ↓ 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.013..0.013 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))
162. 0.050 7,751.861 ↑ 1.0 100 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
163. 7,751.811 7,751.811 ↑ 1.0 100 1

CTE Scan on filtered_events e (cost=0.00..2.00 rows=100 width=588) (actual time=7,751.719..7,751.811 rows=100 loops=1)

Planning time : 215.909 ms
Execution time : 7,827.550 ms