explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NAaD1

Settings
# exclusive inclusive rows x rows loops node
1. 0.352 45,611.568 ↑ 1.0 100 1

Sort (cost=1,788,029.60..1,788,029.85 rows=100 width=620) (actual time=45,611.562..45,611.568 rows=100 loops=1)

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

CTE filtered_events

3. 5.317 45,406.623 ↑ 1.0 100 1

Limit (cost=1,787,824.16..1,787,824.41 rows=100 width=642) (actual time=45,401.299..45,406.623 rows=100 loops=1)

4. 1.973 45,401.306 ↑ 130,198.4 100 1

Sort (cost=1,787,824.16..1,820,373.77 rows=13,019,845 width=642) (actual time=45,401.297..45,401.306 rows=100 loops=1)

  • Sort Key: e_9.event_id DESC
  • Sort Method: top-N heapsort Memory: 87kB
5. 1.780 45,399.333 ↑ 6,075.5 2,143 1

Nested Loop Left Join (cost=955,737.38..1,290,215.04 rows=13,019,845 width=642) (actual time=45,362.420..45,399.333 rows=2,143 loops=1)

6. 34.628 45,393.267 ↑ 307.8 2,143 1

Hash Right Join (cost=955,737.10..1,075,837.08 rows=659,567 width=620) (actual time=45,362.316..45,393.267 rows=2,143 loops=1)

  • Hash Cond: (pl.plan_uuid = e_9.plan_uuid)
  • Join Filter: (pl.valid_range @> e_9.created)
  • Rows Removed by Join Filter: 120,115
  • 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. 1,959.306 1,967.113 ↑ 1.1 736 1

Bitmap Heap Scan on plans pl (cost=17.20..1,157.41 rows=798 width=64) (actual time=43.567..1,967.113 rows=736 loops=1)

  • Recheck Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (is_visible IS TRUE)
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=253
8. 7.807 7.807 ↑ 1.1 750 1

Bitmap Index Scan on plans_organization_uuid_idx (cost=0.00..17.00 rows=810 width=0) (actual time=7.807..7.807 rows=750 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
9. 1.710 43,391.526 ↑ 312.3 2,143 1

Hash (cost=896,374.01..896,374.01 rows=669,271 width=593) (actual time=43,391.525..43,391.526 rows=2,143 loops=1)

  • Buckets: 16,384 Batches: 64 Memory Usage: 546kB
10. 11.465 43,389.816 ↑ 312.3 2,143 1

Hash Right Join (cost=810,581.79..896,374.01 rows=669,271 width=593) (actual time=43,382.103..43,389.816 rows=2,143 loops=1)

  • Hash Cond: (f.form_uuid = e_9.form_uuid)
  • Join Filter: (f.valid_range @> e_9.created)
  • Rows Removed by Join Filter: 18,804
11. 79.943 166.735 ↑ 1.1 386 1

Bitmap Heap Scan on forms f (cost=8.32..639.81 rows=431 width=56) (actual time=86.852..166.735 rows=386 loops=1)

  • Recheck Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (is_visible IS TRUE)
  • Rows Removed by Filter: 10
  • Heap Blocks: exact=197
12. 86.792 86.792 ↑ 1.1 396 1

Bitmap Index Scan on forms_organization_uuid_idx (cost=0.00..8.21 rows=439 width=0) (actual time=86.792..86.792 rows=396 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
13. 1.718 43,211.616 ↑ 312.3 2,143 1

Hash (cost=753,188.59..753,188.59 rows=669,271 width=572) (actual time=43,211.615..43,211.616 rows=2,143 loops=1)

  • Buckets: 16,384 Batches: 64 Memory Usage: 519kB
14. 1.459 43,209.898 ↑ 312.3 2,143 1

Unique (cost=704,666.44..746,495.88 rows=669,271 width=572) (actual time=43,208.047..43,209.898 rows=2,143 loops=1)

15. 0.781 43,208.439 ↑ 312.3 2,143 1

Sort (cost=704,666.44..706,339.62 rows=669,271 width=572) (actual time=43,208.045..43,208.439 rows=2,143 loops=1)

  • Sort Key: e_9.event_uuid, e_9.event_id, e_9.submitter_uuid, e_9.priority, e_9.incident_id, e_9.override_device_restrictions, e_9.escalation_override, e_9.bypass_phone_intro, e_9.require_phone_password, e_9.conference_properties, e_9.created, e_9.status, e_9.terminated, e_9.request_uuid, e_9.sequence, e_9.revision_uuid, e_9.event_type, e_9.system_event_type, e_9.form_uuid, e_9.plan_uuid, e_9.choices, (lower(e_9.valid_range)), (upper(e_9.valid_range)), e_9.recipients
  • Sort Method: quicksort Memory: 785kB
16. 72.290 43,207.658 ↑ 312.3 2,143 1

Gather (cost=25,004.38..419,321.50 rows=669,271 width=572) (actual time=40,762.858..43,207.658 rows=2,143 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
17. 82.673 43,135.368 ↑ 390.0 429 5 / 5

Parallel Hash Left Join (cost=24,004.38..351,394.40 rows=167,318 width=572) (actual time=40,703.867..43,135.368 rows=429 loops=5)

  • Hash Cond: (e_9.event_uuid = ns_41.event_uuid)
  • Join Filter: ((ns_41.created_date >= e_9.created) AND (ns_41.created_date <= (e_9.created + '1 mon'::interval)))
  • Filter: ((e_9.submitter_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) OR (ns_41.recipient_uuid IS NOT NULL))
  • Rows Removed by Filter: 257,714
18. 31.246 2,359.113 ↓ 2.4 258,143 5 / 5

Parallel Append (cost=0.14..309,570.95 rows=107,519 width=569) (actual time=0.110..2,359.113 rows=258,143 loops=5)

  • Subplans Removed: 11
19. 370.353 370.353 ↓ 12.0 228,014 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201907 e_9 (cost=0.00..48,352.14 rows=19,010 width=882) (actual time=0.121..1,851.767 rows=228,014 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 1,087
20. 208.211 208.211 ↓ 9.3 75,696 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201911 e_13 (cost=0.00..27,688.60 rows=8,139 width=514) (actual time=0.115..1,041.056 rows=75,696 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 302
21. 198.892 198.892 ↓ 9.3 118,523 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_2018 e_2 (cost=0.00..26,881.42 rows=12,738 width=363) (actual time=0.115..994.458 rows=118,523 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 1,401
22. 189.035 189.035 ↓ 9.3 104,403 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201908 e_10 (cost=0.00..25,825.29 rows=11,217 width=365) (actual time=0.106..945.176 rows=104,403 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 623
23. 207.356 207.356 ↓ 9.3 109,620 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201904 e_6 (cost=0.00..24,780.56 rows=11,776 width=365) (actual time=0.015..1,036.782 rows=109,620 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 542
24. 162.144 162.144 ↓ 9.3 80,457 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201909 e_11 (cost=0.00..23,112.47 rows=8,646 width=367) (actual time=0.054..810.719 rows=80,457 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 484
25. 180.750 180.750 ↓ 9.3 106,391 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201906 e_8 (cost=0.00..22,594.06 rows=11,439 width=366) (actual time=0.018..903.751 rows=106,391 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 670
26. 137.272 137.272 ↓ 3.1 29,768 3 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201903 e_5 (cost=0.00..21,471.63 rows=9,598 width=366) (actual time=0.035..228.787 rows=29,768 loops=3)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 159
27. 109.129 109.129 ↓ 3.1 33,624 3 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201905 e_7 (cost=0.00..21,314.18 rows=10,840 width=1,438) (actual time=0.016..181.881 rows=33,624 loops=3)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 185
28. 91.464 91.464 ↓ 4.6 39,348 2 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201910 e_12 (cost=0.00..19,711.27 rows=8,465 width=516) (actual time=0.035..228.660 rows=39,348 loops=2)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 212
29. 223.811 223.811 ↓ 4.7 35,710 2 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201912 e_14 (cost=0.00..19,177.88 rows=7,676 width=517) (actual time=0.036..559.528 rows=35,710 loops=2)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 174
30. 109.387 109.387 ↓ 9.3 57,310 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201901 e_3 (cost=0.00..12,068.10 rows=6,159 width=365) (actual time=0.062..546.934 rows=57,310 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 570
31. 72.588 72.588 ↓ 9.3 49,476 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201902 e_4 (cost=0.00..10,370.92 rows=5,316 width=365) (actual time=0.064..362.942 rows=49,476 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 388
32. 67.474 67.474 ↓ 7.2 20,532 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_202001 e_15 (cost=0.00..5,650.07 rows=2,837 width=516) (actual time=0.077..337.370 rows=20,532 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 166
33. 25.084 40,693.582 ↑ 2.0 350 5 / 5

Parallel Hash (cost=23,995.58..23,995.58 rows=692 width=40) (actual time=40,693.581..40,693.582 rows=350 loops=5)

  • Buckets: 4,096 Batches: 1 Memory Usage: 256kB
34. 0.125 40,668.498 ↑ 2.0 350 5 / 5

Parallel Append (cost=38.00..23,995.58 rows=692 width=40) (actual time=31.319..40,668.498 rows=350 loops=5)

35. 54.241 58.116 ↑ 3.9 50 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w46 ns_41 (cost=62.47..2,557.66 rows=195 width=40) (actual time=42.186..290.579 rows=50 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 20,961
36. 3.875 3.875 ↓ 12.5 21,011 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx41 (cost=0.00..62.38 rows=1,682 width=0) (actual time=19.374..19.374 rows=21,011 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
37. 29.510 35.667 ↑ 3.6 40 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2020_w1 ns_48 (cost=43.15..1,904.38 rows=144 width=40) (actual time=42.535..178.337 rows=40 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 16,301
38. 6.157 6.157 ↓ 13.3 16,715 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx49 (cost=0.00..43.09 rows=1,253 width=0) (actual time=30.785..30.785 rows=16,715 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
39. 48.854 52.534 ↑ 3.2 43 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w47 ns_42 (cost=42.40..1,797.19 rows=138 width=40) (actual time=35.180..262.668 rows=43 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 18,401
40. 3.680 3.680 ↓ 15.7 18,444 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx42 (cost=0.00..42.34 rows=1,178 width=0) (actual time=18.399..18.399 rows=18,444 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
41. 35.926 40.913 ↑ 1.7 74 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w50 ns_45 (cost=38.00..1,584.73 rows=129 width=40) (actual time=36.427..204.567 rows=74 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 16,665
42. 4.988 4.988 ↓ 16.1 16,739 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx45 (cost=0.00..37.94 rows=1,038 width=0) (actual time=24.939..24.939 rows=16,739 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
43. 21.658 24.450 ↑ 3.1 29 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w45 ns_40 (cost=32.57..1,224.82 rows=91 width=40) (actual time=28.795..122.250 rows=29 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 14,517
44. 2.792 2.792 ↓ 18.3 14,546 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx40 (cost=0.00..32.53 rows=797 width=0) (actual time=13.958..13.959 rows=14,546 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
45. 24.692 27.031 ↑ 1.3 70 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w44 ns_39 (cost=29.53..1,214.06 rows=94 width=40) (actual time=15.406..135.154 rows=70 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 15,068
46. 2.339 2.339 ↓ 19.1 15,138 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx39 (cost=0.00..29.49 rows=793 width=0) (actual time=11.693..11.693 rows=15,138 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
47. 4,337.862 4,339.956 ↑ 4.3 22 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w51 ns_46 (cost=28.21..1,239.12 rows=94 width=40) (actual time=23.733..21,699.780 rows=22 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 15,465
48. 2.094 2.094 ↓ 19.1 15,487 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx46 (cost=0.00..28.17 rows=811 width=0) (actual time=10.470..10.470 rows=15,487 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
49. 14.013 15.349 ↓ 0.0 0 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w41 ns_36 (cost=27.72..1,836.00 rows=1 width=40) (actual time=76.747..76.747 rows=0 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 20,179
50. 1.336 1.336 ↓ 16.6 20,179 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx36 (cost=0.00..27.72 rows=1,216 width=0) (actual time=6.680..6.680 rows=20,179 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
51. 10,480.385 10,481.253 ↑ 14.5 6 2 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w52 ns_47 (cost=26.21..1,160.63 rows=87 width=40) (actual time=7,684.609..26,203.132 rows=6 loops=2)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 6,734
52. 0.868 0.868 ↓ 17.7 13,481 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx47 (cost=0.00..26.17 rows=761 width=0) (actual time=4.340..4.340 rows=13,481 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
53. 14,985.759 14,987.485 ↑ 8.6 8 5 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w48 ns_43 (cost=26.03..916.09 rows=69 width=40) (actual time=6,577.794..14,987.485 rows=8 loops=5)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 2,956
  • Heap Blocks: exact=939
54. 1.726 1.726 ↓ 25.0 14,823 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx43 (cost=0.00..26.00 rows=594 width=0) (actual time=8.632..8.632 rows=14,823 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
55. 14.918 15.955 ↑ 6.0 1 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w40 ns_35 (cost=23.55..1,656.20 rows=6 width=40) (actual time=11.312..79.777 rows=1 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 20,517
56. 1.037 1.037 ↓ 18.7 20,518 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx35 (cost=0.00..23.54 rows=1,098 width=0) (actual time=5.186..5.186 rows=20,518 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
57. 10.424 11.008 ↑ 2.2 19 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w43 ns_38 (cost=21.41..893.51 rows=42 width=40) (actual time=23.641..55.040 rows=19 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 13,441
58. 0.584 0.584 ↓ 23.1 13,460 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx38 (cost=0.00..21.39 rows=583 width=0) (actual time=2.920..2.920 rows=13,460 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
59. 10,500.808 10,501.570 ↑ 12.5 6 2 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2020_w2 ns_49 (cost=20.24..934.81 rows=75 width=40) (actual time=158.387..26,253.926 rows=6 loops=2)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 4,370
  • Heap Blocks: exact=5,536
60. 0.763 0.763 ↓ 15.6 9,592 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx50 (cost=0.00..20.21 rows=615 width=0) (actual time=3.814..3.814 rows=9,592 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
61. 15.576 15.576 ↑ 4.2 32 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..1,650.81 rows=135 width=40) (actual time=4.289..77.882 rows=32 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 18,816
62. 13.086 13.086 ↓ 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..1,178.93 rows=1 width=40) (actual time=65.431..65.431 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 16,893
63. 13.719 13.719 ↑ 4.5 24 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..645.01 rows=108 width=40) (actual time=4.157..68.596 rows=24 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 19,562
64. 12.020 12.020 ↑ 1.7 41 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..465.17 rows=68 width=40) (actual time=3.920..60.100 rows=41 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 18,083
65. 8.816 8.816 ↑ 2.8 24 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..403.89 rows=66 width=40) (actual time=3.413..44.081 rows=24 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 13,022
66. 2.841 2.841 ↓ 1.3 23 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..120.99 rows=18 width=40) (actual time=0.091..14.206 rows=23 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 3,696
67. 0.178 0.178 ↓ 15.5 62 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..21.82 rows=4 width=40) (actual time=0.042..0.890 rows=62 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 81
68. 0.244 0.244 ↓ 20.7 62 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..20.21 rows=3 width=40) (actual time=0.054..1.220 rows=62 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 137
69. 0.252 0.252 ↓ 21.3 64 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..19.14 rows=3 width=40) (actual time=0.053..1.260 rows=64 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 127
70. 0.217 0.217 ↓ 15.0 45 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..19.13 rows=3 width=40) (actual time=0.079..1.083 rows=45 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 90
71. 0.266 0.266 ↓ 18.5 37 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..17.55 rows=2 width=40) (actual time=0.117..1.328 rows=37 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 58
72. 0.402 0.402 ↓ 19.5 39 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..16.55 rows=2 width=40) (actual time=0.157..2.010 rows=39 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 104
73. 0.449 0.449 ↓ 29.0 58 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..16.43 rows=2 width=40) (actual time=0.186..2.246 rows=58 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 116
74. 0.401 0.401 ↓ 17.0 34 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..16.43 rows=2 width=40) (actual time=0.162..2.007 rows=34 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 120
75. 0.487 0.487 ↓ 18.5 37 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..16.43 rows=2 width=40) (actual time=0.247..2.434 rows=37 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 135
76. 0.497 0.497 ↓ 21.5 43 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..16.05 rows=2 width=40) (actual time=0.259..2.487 rows=43 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 134
77. 0.268 0.268 ↓ 6.0 12 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..15.94 rows=2 width=40) (actual time=0.187..1.342 rows=12 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 87
78. 0.334 0.334 ↓ 23.5 47 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..15.73 rows=2 width=40) (actual time=0.164..1.669 rows=47 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 80
79. 0.430 0.430 ↓ 23.0 46 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx17 on notifications_summary_weekly_partitioned_2019_w22 ns_17 (cost=0.56..15.27 rows=2 width=40) (actual time=0.362..2.150 rows=46 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 125
80. 0.226 0.226 ↓ 12.5 25 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..15.23 rows=2 width=40) (actual time=0.141..1.131 rows=25 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 68
81. 0.244 0.244 ↓ 13.5 27 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..15.18 rows=2 width=40) (actual time=0.125..1.222 rows=27 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 66
82. 0.426 0.426 ↓ 24.5 49 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..15.07 rows=2 width=40) (actual time=0.122..2.130 rows=49 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 97
83. 0.377 0.377 ↓ 18.0 36 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..15.07 rows=2 width=40) (actual time=0.284..1.887 rows=36 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 94
84. 0.359 0.359 ↓ 20.0 40 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..15.06 rows=2 width=40) (actual time=0.083..1.797 rows=40 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 90
85. 0.386 0.386 ↓ 18.0 36 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..14.72 rows=2 width=40) (actual time=0.206..1.932 rows=36 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 98
86. 0.430 0.430 ↓ 12.5 25 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..14.39 rows=2 width=40) (actual time=0.231..2.152 rows=25 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 110
87. 0.795 0.795 ↓ 27.5 55 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..14.39 rows=2 width=40) (actual time=0.185..3.977 rows=55 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 95
88. 0.384 0.384 ↓ 21.5 43 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..12.54 rows=2 width=40) (actual time=0.163..1.918 rows=43 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 81
89. 0.326 0.326 ↓ 12.5 25 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..11.77 rows=2 width=40) (actual time=0.159..1.631 rows=25 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 86
90. 0.446 0.446 ↓ 27.0 54 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..11.70 rows=2 width=40) (actual time=0.230..2.229 rows=54 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 92
91. 0.412 0.412 ↓ 22.0 44 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..11.69 rows=2 width=40) (actual time=0.214..2.062 rows=44 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 87
92. 0.338 0.338 ↓ 9.0 18 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..11.68 rows=2 width=40) (actual time=0.184..1.692 rows=18 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 87
93. 0.396 0.396 ↓ 21.5 43 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..11.02 rows=2 width=40) (actual time=0.078..1.981 rows=43 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 66
94. 0.380 0.380 ↓ 34.0 34 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..9.70 rows=1 width=40) (actual time=0.166..1.899 rows=34 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 81
95. 0.361 0.361 ↓ 18.0 18 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..8.32 rows=1 width=40) (actual time=0.324..1.804 rows=18 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 94
96. 0.237 0.237 ↓ 33.0 33 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..9.01 rows=1 width=40) (actual time=0.245..1.186 rows=33 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 38
97. 0.038 0.038 ↓ 3.0 3 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..3.58 rows=1 width=40) (actual time=0.062..0.190 rows=3 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Filter: ((category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
  • Rows Removed by Filter: 4
98. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_par_organization_uuid_ntfn_id_idx2 on notifications_summary_weekly_partitioned_2020_w3 ns_50 (cost=0.14..3.16 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

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

Parallel Index Scan using notifications_summary_weekly_par_organization_uuid_ntfn_id_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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
100. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_par_organization_uuid_ntfn_id_idx4 on notifications_summary_weekly_partitioned_2020_w5 ns_52 (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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
101. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
102. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
103. 0.001 0.001 ↓ 0.0 0 1 / 5

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

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
105. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx58 on notifications_summary_weekly_partitioned_2020_w10 ns_57 (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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
106. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
107. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx60 on notifications_summary_weekly_partitioned_2020_w12 ns_59 (cost=0.14..3.16 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx61 on notifications_summary_weekly_partitioned_2020_w13 ns_60 (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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
109. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx62 on notifications_summary_weekly_partitioned_2020_w14 ns_61 (cost=0.14..3.16 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx63 on notifications_summary_weekly_partitioned_2020_w15 ns_62 (cost=0.14..3.16 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
112. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx65 on notifications_summary_weekly_partitioned_2020_w17 ns_64 (cost=0.14..3.16 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
114. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx67 on notifications_summary_weekly_partitioned_2020_w19 ns_66 (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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
115. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx68 on notifications_summary_weekly_partitioned_2020_w20 ns_67 (cost=0.14..3.16 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

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

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

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx70 on notifications_summary_weekly_partitioned_2020_w22 ns_69 (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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
118. 0.001 0.001 ↓ 0.0 0 1 / 5

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

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx72 on notifications_summary_weekly_partitioned_2020_w24 ns_71 (cost=0.14..3.16 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx73 on notifications_summary_weekly_partitioned_2020_w25 ns_72 (cost=0.14..3.16 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: ((recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
121. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
122. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx75 on notifications_summary_weekly_partitioned_2020_w27 ns_74 (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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
123. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx76 on notifications_summary_weekly_partitioned_2020_w28 ns_75 (cost=0.14..3.16 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
125. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx78 on notifications_summary_weekly_partitioned_2020_w30 ns_77 (cost=0.14..3.16 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx79 on notifications_summary_weekly_partitioned_2020_w31 ns_78 (cost=0.14..3.16 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx80 on notifications_summary_weekly_partitioned_2020_w32 ns_79 (cost=0.14..3.16 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx81 on notifications_summary_weekly_partitioned_2020_w33 ns_80 (cost=0.14..3.16 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

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

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

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx83 on notifications_summary_weekly_partitioned_2020_w35 ns_82 (cost=0.14..3.16 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: ((recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
131. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx84 on notifications_summary_weekly_partitioned_2020_w36 ns_83 (cost=0.14..3.16 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx85 on notifications_summary_weekly_partitioned_2020_w37 ns_84 (cost=0.14..3.16 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx86 on notifications_summary_weekly_partitioned_2020_w38 ns_85 (cost=0.14..3.16 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx87 on notifications_summary_weekly_partitioned_2020_w39 ns_86 (cost=0.14..3.16 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

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

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

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
137. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx90 on notifications_summary_weekly_partitioned_2020_w42 ns_89 (cost=0.14..3.16 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx91 on notifications_summary_weekly_partitioned_2020_w43 ns_90 (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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
139. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
140. 0.001 0.001 ↓ 0.0 0 1 / 5

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

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
142. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
143. 0.001 0.001 ↓ 0.0 0 1 / 5

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

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
145. 0.001 0.001 ↓ 0.0 0 1 / 5

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

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_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 = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
147. 0.001 0.001 ↓ 0.0 0 1 / 5

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

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

Parallel Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx53 on notifications_summary_weekly_part_default ns_100 (cost=0.14..3.16 rows=1 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (category = 'PERSON'::text) AND ((delivery_status)::text = 'DELIVERED'::text))
149. 4.286 4.286 ↑ 1.0 1 2,143

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

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

Hash Right Join (cost=128.68..201.87 rows=100 width=620) (actual time=45,611.019..45,611.216 rows=100 loops=1)

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

Subquery Scan on m (cost=125.43..198.55 rows=9 width=71) (actual time=204.181..204.298 rows=100 loops=1)

  • Filter: (m.row_number = 1)
152. 0.125 204.282 ↑ 18.3 100 1

WindowAgg (cost=125.43..175.70 rows=1,828 width=102) (actual time=204.176..204.282 rows=100 loops=1)

153. 0.425 204.157 ↑ 18.3 100 1

Sort (cost=125.43..130.00 rows=1,828 width=78) (actual time=204.145..204.157 rows=100 loops=1)

  • Sort Key: msg.event_uuid, (CASE msg.language WHEN persons_org_part_67_l2_t.language THEN 1 WHEN 'en'::text THEN 2 ELSE 3 END), msg.language
  • Sort Method: quicksort Memory: 39kB
154. 0.428 203.732 ↑ 18.3 100 1

Hash Left Join (cost=3.75..26.39 rows=1,828 width=78) (actual time=1.878..203.732 rows=100 loops=1)

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

Nested Loop (cost=0.43..6.98 rows=1,828 width=74) (actual time=1.807..203.272 rows=100 loops=1)

156. 0.205 0.205 ↓ 100.0 100 1

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

  • Filter: (system_event_type IS NULL)
157. 202.800 202.800 ↑ 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.026..2.028 rows=1 loops=100)

  • Index Cond: (event_uuid = e_1.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
  • Rows Removed by Filter: 0
158. 0.004 0.032 ↑ 1.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
159. 0.028 0.028 ↑ 1.0 1 1

Index Scan using persons_org_part_67_l2_t_org_seq_vrange_uidx on persons_org_part_67_l2_t (cost=0.29..3.31 rows=1 width=3) (actual time=0.027..0.028 rows=1 loops=1)

  • Index Cond: (person_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
160. 0.057 45,406.773 ↑ 1.0 100 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
161. 45,406.716 45,406.716 ↑ 1.0 100 1

CTE Scan on filtered_events e (cost=0.00..2.00 rows=100 width=588) (actual time=45,401.309..45,406.716 rows=100 loops=1)

Planning time : 128.132 ms
Execution time : 45,618.325 ms