explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xvF5

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,285.763 ↑ 1.0 1 1

Finalize Aggregate (cost=114,602.56..114,602.57 rows=1 width=8) (actual time=1,285.762..1,285.763 rows=1 loops=1)

2. 98.329 1,345.556 ↓ 1.2 5 1

Gather (cost=114,602.14..114,602.55 rows=4 width=8) (actual time=1,281.755..1,345.556 rows=5 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 3.939 1,247.227 ↑ 1.0 1 5 / 5

Partial Aggregate (cost=113,602.14..113,602.15 rows=1 width=8) (actual time=1,247.226..1,247.227 rows=1 loops=5)

4. 51.969 1,243.288 ↑ 4.1 43,766 5 / 5

Parallel Hash Join (cost=23,739.30..113,157.95 rows=177,674 width=0) (actual time=976.802..1,243.288 rows=43,766 loops=5)

  • Hash Cond: (e_7.event_uuid = ns_41.event_uuid)
  • Join Filter: ((ns_41.created_date >= e_7.created) AND (ns_41.created_date <= (e_7.created + '31 days'::interval)))
5. 4.013 217.031 ↓ 2.4 44,936 5 / 5

Parallel Append (cost=0.29..72,436.43 rows=18,876 width=24) (actual time=2.131..217.031 rows=44,936 loops=5)

6. 0.307 0.307 ↓ 0.0 0 1 / 5

Index Scan using events_org_part_12_l3_t_20190_event_type_created_valid_ran_idx6 on events_org_part_12_l3_t_201907 e_7 (cost=0.29..3.31 rows=1 width=24) (actual time=1.536..1.536 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
7. 0.289 0.289 ↓ 0.0 0 1 / 5

Index Scan using events_org_part_12_l3_t_2018_event_type_created_valid_range_idx on events_org_part_12_l3_t_2018 e (cost=0.29..3.31 rows=1 width=24) (actual time=1.444..1.444 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
8. 0.290 0.290 ↓ 0.0 0 1 / 5

Index Scan using events_org_part_12_l3_t_20190_event_type_created_valid_ran_idx2 on events_org_part_12_l3_t_201903 e_3 (cost=0.29..3.31 rows=1 width=24) (actual time=1.449..1.449 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
9. 0.290 0.290 ↓ 0.0 0 1 / 5

Index Scan using events_org_part_12_l3_t_20190_event_type_created_valid_ran_idx3 on events_org_part_12_l3_t_201904 e_4 (cost=0.29..3.31 rows=1 width=24) (actual time=1.452..1.452 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
10. 0.026 0.026 ↓ 0.0 0 1 / 5

Index Scan using events_org_part_12_l3_t_20190_event_type_created_valid_ran_idx4 on events_org_part_12_l3_t_201905 e_5 (cost=0.29..3.31 rows=1 width=24) (actual time=0.129..0.129 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
11. 0.018 0.018 ↓ 0.0 0 1 / 5

Index Scan using events_org_part_12_l3_t_20190_event_type_created_valid_ran_idx5 on events_org_part_12_l3_t_201906 e_6 (cost=0.29..3.31 rows=1 width=24) (actual time=0.091..0.091 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
12. 0.017 0.017 ↓ 0.0 0 1 / 5

Index Scan using events_org_part_12_l3_t_20190_event_type_created_valid_ran_idx7 on events_org_part_12_l3_t_201908 e_8 (cost=0.29..3.31 rows=1 width=24) (actual time=0.086..0.086 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
13. 0.015 0.015 ↓ 0.0 0 1 / 5

Index Scan using events_org_part_12_l3_t_20190_event_type_created_valid_ran_idx8 on events_org_part_12_l3_t_201909 e_9 (cost=0.29..3.31 rows=1 width=24) (actual time=0.074..0.074 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
14. 0.019 0.019 ↓ 0.0 0 1 / 5

Index Scan using events_org_part_12_l3_t_20190_event_type_created_valid_rang_idx on events_org_part_12_l3_t_201901 e_1 (cost=0.29..3.31 rows=1 width=24) (actual time=0.096..0.096 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
15. 0.032 0.032 ↓ 0.0 0 1 / 5

Index Scan using events_org_part_12_l3_t_20190_event_type_created_valid_ran_idx1 on events_org_part_12_l3_t_201902 e_2 (cost=0.29..3.31 rows=1 width=24) (actual time=0.158..0.158 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
16. 0.002 0.002 ↓ 0.0 0 1 / 5

Parallel Index Scan using events_org_part_12_l3_t_202002_organization_uuid_expr_idx on events_org_part_12_l3_t_202002 e_14 (cost=0.14..3.16 rows=1 width=24) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (upper_inf(valid_range) AND (created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
17. 0.002 0.002 ↓ 0.0 0 1 / 5

Parallel Index Scan using events_org_part_12_l3_t_202003_organization_uuid_expr_idx on events_org_part_12_l3_t_202003 e_15 (cost=0.14..3.16 rows=1 width=24) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (upper_inf(valid_range) AND (created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
18. 0.002 0.002 ↓ 0.0 0 1 / 5

Parallel Index Scan using events_org_part_12_l3_t_202004_organization_uuid_expr_idx on events_org_part_12_l3_t_202004 e_16 (cost=0.14..3.16 rows=1 width=24) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (upper_inf(valid_range) AND (created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
19. 0.003 0.003 ↓ 0.0 0 1 / 5

Parallel Index Scan using events_org_part_12_l3_t_202005_organization_uuid_expr_idx on events_org_part_12_l3_t_202005 e_17 (cost=0.14..3.16 rows=1 width=24) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (upper_inf(valid_range) AND (created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
20. 0.002 0.002 ↓ 0.0 0 1 / 5

Parallel Index Scan using events_org_part_12_l3_t_202006_organization_uuid_expr_idx on events_org_part_12_l3_t_202006 e_18 (cost=0.14..3.16 rows=1 width=24) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (upper_inf(valid_range) AND (created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
21. 0.002 0.002 ↓ 0.0 0 1 / 5

Parallel Index Scan using events_org_part_12_l3_t_202007_organization_uuid_expr_idx on events_org_part_12_l3_t_202007 e_19 (cost=0.14..3.16 rows=1 width=24) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (upper_inf(valid_range) AND (created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
22. 0.002 0.002 ↓ 0.0 0 1 / 5

Parallel Index Scan using events_org_part_12_l3_t_202008_organization_uuid_expr_idx on events_org_part_12_l3_t_202008 e_20 (cost=0.14..3.16 rows=1 width=24) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (upper_inf(valid_range) AND (created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
23. 0.002 0.002 ↓ 0.0 0 1 / 5

Parallel Index Scan using events_org_part_12_l3_t_202009_organization_uuid_expr_idx on events_org_part_12_l3_t_202009 e_21 (cost=0.14..3.16 rows=1 width=24) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (upper_inf(valid_range) AND (created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
24. 0.002 0.002 ↓ 0.0 0 1 / 5

Parallel Index Scan using events_org_part_12_l3_t_202010_organization_uuid_expr_idx on events_org_part_12_l3_t_202010 e_22 (cost=0.14..3.16 rows=1 width=24) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (upper_inf(valid_range) AND (created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
25. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using events_org_part_12_l3_t_202011_organization_uuid_expr_idx on events_org_part_12_l3_t_202011 e_23 (cost=0.14..3.16 rows=1 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (upper_inf(valid_range) AND (created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
26. 0.002 0.002 ↓ 0.0 0 1 / 5

Parallel Index Scan using events_org_part_12_l3_t_202012_organization_uuid_expr_idx on events_org_part_12_l3_t_202012 e_24 (cost=0.14..3.16 rows=1 width=24) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (upper_inf(valid_range) AND (created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
27. 84.142 84.142 ↓ 1.9 15,200 5 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201911 e_11 (cost=0.00..27,811.18 rows=8,172 width=24) (actual time=0.028..84.142 rows=15,200 loops=5)

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
28. 55.593 55.593 ↓ 3.1 19,488 3 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201910 e_10 (cost=0.00..19,838.89 rows=6,308 width=24) (actual time=1.304..92.655 rows=19,488 loops=3)

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
  • Rows Removed by Filter: 6,886
29. 56.368 56.368 ↓ 4.6 35,883 2 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201912 e_12 (cost=0.00..19,305.32 rows=7,858 width=24) (actual time=0.025..140.920 rows=35,883 loops=2)

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
30. 15.593 15.593 ↓ 3.5 9,226 2 / 5

Parallel Seq Scan on events_org_part_12_l3_t_202001 e_13 (cost=0.00..5,341.92 rows=2,605 width=24) (actual time=0.045..38.982 rows=9,226 loops=2)

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 mons'::interval)))
31. 70.045 974.288 ↓ 14.2 60,191 5 / 5

Parallel Hash (cost=23,686.20..23,686.20 rows=4,225 width=24) (actual time=974.288..974.288 rows=60,191 loops=5)

  • Buckets: 524,288 (originally 32768) Batches: 1 (originally 1) Memory Usage: 24,480kB
32. 7.083 904.243 ↓ 14.2 60,191 5 / 5

Parallel Append (cost=38.20..23,686.20 rows=4,225 width=24) (actual time=15.501..904.243 rows=60,191 loops=5)

33. 67.876 71.285 ↓ 21.2 21,011 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w46 ns_41 (cost=62.80..2,553.05 rows=989 width=24) (actual time=21.095..356.426 rows=21,011 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
34. 3.410 3.410 ↓ 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=17.048..17.048 rows=21,011 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
35. 51.555 54.755 ↓ 22.2 16,341 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2020_w1 ns_48 (cost=43.41..1,900.95 rows=737 width=24) (actual time=18.952..273.774 rows=16,341 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
36. 3.200 3.200 ↓ 13.0 16,341 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=16.000..16.000 rows=16,341 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
37. 72.743 75.882 ↓ 26.6 18,444 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w47 ns_42 (cost=42.64..1,793.96 rows=693 width=24) (actual time=19.014..379.408 rows=18,444 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
38. 3.138 3.138 ↓ 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=15.692..15.692 rows=18,444 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
39. 49.824 52.734 ↓ 27.4 16,739 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w50 ns_45 (cost=38.20..1,581.88 rows=611 width=24) (actual time=18.042..263.671 rows=16,739 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
40. 2.910 2.910 ↓ 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=14.551..14.551 rows=16,739 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
41. 41.503 58.498 ↓ 31.0 14,546 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w45 ns_40 (cost=32.73..1,222.64 rows=469 width=24) (actual time=87.742..292.489 rows=14,546 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
42. 16.995 16.995 ↓ 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=84.976..84.976 rows=14,546 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
43. 45.469 47.476 ↓ 32.5 15,138 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w44 ns_39 (cost=29.69..1,211.88 rows=466 width=24) (actual time=13.470..237.381 rows=15,138 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
44. 2.007 2.007 ↓ 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=10.035..10.035 rows=15,138 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
45. 45.169 47.048 ↓ 32.5 15,487 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w51 ns_46 (cost=28.38..1,236.90 rows=477 width=24) (actual time=12.303..235.240 rows=15,487 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
46. 1.879 1.879 ↓ 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=9.397..9.397 rows=15,487 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
47. 54.575 56.415 ↓ 28.2 20,179 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w41 ns_36 (cost=28.03..1,832.73 rows=715 width=24) (actual time=12.563..282.074 rows=20,179 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
48. 1.839 1.839 ↓ 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=9.197..9.197 rows=20,179 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
49. 39.517 40.887 ↓ 30.1 13,481 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w52 ns_47 (cost=26.36..1,158.55 rows=448 width=24) (actual time=9.107..204.434 rows=13,481 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
50. 1.370 1.370 ↓ 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=6.850..6.850 rows=13,481 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
51. 41.967 44.274 ↓ 42.5 14,823 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w48 ns_43 (cost=26.15..914.46 rows=349 width=24) (actual time=14.240..221.369 rows=14,823 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
52. 2.307 2.307 ↓ 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=11.536..11.536 rows=14,823 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
53. 55.945 57.358 ↓ 15.9 10,259 2 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w40 ns_35 (cost=23.82..1,653.24 rows=646 width=24) (actual time=5.436..143.395 rows=10,259 loops=2)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
54. 1.413 1.413 ↓ 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=7.067..7.067 rows=20,518 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
55. 40.884 41.974 ↓ 19.6 6,730 2 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2019_w43 ns_38 (cost=21.54..891.92 rows=343 width=24) (actual time=3.810..104.936 rows=6,730 loops=2)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
56. 1.091 1.091 ↓ 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=5.454..5.454 rows=13,460 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
57. 20.616 21.249 ↓ 25.9 6,551 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2020_w2 ns_49 (cost=15.46..653.83 rows=253 width=24) (actual time=4.174..106.247 rows=6,551 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
58. 0.633 0.633 ↓ 15.3 6,579 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx50 (cost=0.00..15.36 rows=430 width=0) (actual time=3.165..3.165 rows=6,579 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
59. 51.336 51.336 ↓ 5.9 3,770 5 / 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,647.59 rows=644 width=24) (actual time=0.137..51.336 rows=3,770 loops=5)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
60. 44.080 44.080 ↓ 18.5 8,446 2 / 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,176.65 rows=456 width=24) (actual time=0.077..110.200 rows=8,446 loops=2)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
61. 41.568 41.568 ↓ 37.0 19,586 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..642.36 rows=529 width=24) (actual time=0.082..207.842 rows=19,586 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
62. 40.373 40.373 ↓ 49.1 18,124 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..463.32 rows=369 width=24) (actual time=0.080..201.867 rows=18,124 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
63. 28.604 28.604 ↓ 39.2 13,046 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..402.23 rows=333 width=24) (actual time=0.138..143.022 rows=13,046 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
64. 8.710 8.710 ↓ 37.9 3,719 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.50 rows=98 width=24) (actual time=0.109..43.548 rows=3,719 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
65. 0.405 0.405 ↓ 8.9 143 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.74 rows=16 width=24) (actual time=0.075..2.027 rows=143 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
66. 0.552 0.552 ↓ 13.3 199 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.14 rows=15 width=24) (actual time=0.087..2.760 rows=199 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
67. 0.553 0.553 ↓ 13.6 191 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.07 rows=14 width=24) (actual time=0.084..2.766 rows=191 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
68. 0.616 0.616 ↓ 9.6 135 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.06 rows=14 width=24) (actual time=0.077..3.080 rows=135 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
69. 0.298 0.298 ↓ 7.9 95 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.49 rows=12 width=24) (actual time=0.083..1.490 rows=95 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
70. 0.395 0.395 ↓ 11.9 143 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.49 rows=12 width=24) (actual time=0.079..1.977 rows=143 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
71. 0.473 0.473 ↓ 14.5 174 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.37 rows=12 width=24) (actual time=0.205..2.367 rows=174 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
72. 0.411 0.411 ↓ 12.8 154 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.37 rows=12 width=24) (actual time=0.070..2.055 rows=154 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
73. 0.620 0.620 ↓ 14.3 172 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.37 rows=12 width=24) (actual time=0.071..3.100 rows=172 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
74. 0.548 0.548 ↓ 16.1 177 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..15.99 rows=11 width=24) (actual time=0.076..2.741 rows=177 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
75. 0.364 0.364 ↓ 9.0 99 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.88 rows=11 width=24) (actual time=0.079..1.820 rows=99 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
76. 0.380 0.380 ↓ 11.5 127 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.68 rows=11 width=24) (actual time=0.074..1.902 rows=127 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
77. 0.505 0.505 ↓ 15.5 171 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.22 rows=11 width=24) (actual time=0.086..2.525 rows=171 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
78. 0.257 0.257 ↓ 8.5 93 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.18 rows=11 width=24) (actual time=0.059..1.283 rows=93 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
79. 0.263 0.263 ↓ 8.5 93 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.13 rows=11 width=24) (actual time=0.105..1.317 rows=93 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
80. 0.383 0.383 ↓ 13.3 146 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.02 rows=11 width=24) (actual time=0.144..1.915 rows=146 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
81. 0.330 0.330 ↓ 11.8 130 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.02 rows=11 width=24) (actual time=0.070..1.652 rows=130 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
82. 0.375 0.375 ↓ 11.8 130 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.01 rows=11 width=24) (actual time=0.064..1.875 rows=130 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
83. 0.345 0.345 ↓ 13.4 134 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.67 rows=10 width=24) (actual time=0.099..1.723 rows=134 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
84. 0.373 0.373 ↓ 13.5 135 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.34 rows=10 width=24) (actual time=0.074..1.866 rows=135 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
85. 0.668 0.668 ↓ 15.0 150 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.34 rows=10 width=24) (actual time=0.077..3.338 rows=150 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
86. 0.363 0.363 ↓ 15.5 124 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.50 rows=8 width=24) (actual time=0.092..1.816 rows=124 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
87. 0.334 0.334 ↓ 13.9 111 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.73 rows=8 width=24) (actual time=0.096..1.671 rows=111 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
88. 0.514 0.514 ↓ 18.2 146 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.66 rows=8 width=24) (actual time=0.134..2.572 rows=146 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
89. 0.447 0.447 ↓ 16.4 131 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.65 rows=8 width=24) (actual time=0.088..2.237 rows=131 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
90. 0.345 0.345 ↓ 13.1 105 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.65 rows=8 width=24) (actual time=0.153..1.727 rows=105 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
91. 0.376 0.376 ↓ 15.6 109 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..10.98 rows=7 width=24) (actual time=0.072..1.881 rows=109 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
92. 0.402 0.402 ↓ 19.2 115 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.67 rows=6 width=24) (actual time=0.227..2.009 rows=115 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
93. 0.378 0.378 ↓ 22.4 112 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.30 rows=5 width=24) (actual time=0.092..1.891 rows=112 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
94. 0.284 0.284 ↓ 14.2 71 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..8.99 rows=5 width=24) (actual time=0.075..1.420 rows=71 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
95. 0.049 0.049 ↓ 7.0 7 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.57 rows=1 width=24) (actual time=0.162..0.247 rows=7 loops=1)

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

Parallel Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx2 on notifications_summary_weekly_partitioned_2020_w3 ns_50 (cost=0.14..3.16 rows=1 width=24) (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)
97. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx3 on notifications_summary_weekly_partitioned_2020_w4 ns_51 (cost=0.14..3.16 rows=1 width=24) (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)
98. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx4 on notifications_summary_weekly_partitioned_2020_w5 ns_52 (cost=0.14..3.16 rows=1 width=24) (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)
99. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx54 on notifications_summary_weekly_partitioned_2020_w6 ns_53 (cost=0.14..3.16 rows=1 width=24) (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)
100. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx55 on notifications_summary_weekly_partitioned_2020_w7 ns_54 (cost=0.14..3.16 rows=1 width=24) (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)
101. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx56 on notifications_summary_weekly_partitioned_2020_w8 ns_55 (cost=0.14..3.16 rows=1 width=24) (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)
102. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx57 on notifications_summary_weekly_partitioned_2020_w9 ns_56 (cost=0.14..3.16 rows=1 width=24) (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)
103. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx58 on notifications_summary_weekly_partitioned_2020_w10 ns_57 (cost=0.14..3.16 rows=1 width=24) (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)
104. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx59 on notifications_summary_weekly_partitioned_2020_w11 ns_58 (cost=0.14..3.16 rows=1 width=24) (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)
105. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx60 on notifications_summary_weekly_partitioned_2020_w12 ns_59 (cost=0.14..3.16 rows=1 width=24) (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)
106. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx61 on notifications_summary_weekly_partitioned_2020_w13 ns_60 (cost=0.14..3.16 rows=1 width=24) (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)
107. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx62 on notifications_summary_weekly_partitioned_2020_w14 ns_61 (cost=0.14..3.16 rows=1 width=24) (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)
108. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx63 on notifications_summary_weekly_partitioned_2020_w15 ns_62 (cost=0.14..3.16 rows=1 width=24) (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)
109. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx64 on notifications_summary_weekly_partitioned_2020_w16 ns_63 (cost=0.14..3.16 rows=1 width=24) (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)
110. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx65 on notifications_summary_weekly_partitioned_2020_w17 ns_64 (cost=0.14..3.16 rows=1 width=24) (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)
111. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx66 on notifications_summary_weekly_partitioned_2020_w18 ns_65 (cost=0.14..3.16 rows=1 width=24) (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)
112. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx67 on notifications_summary_weekly_partitioned_2020_w19 ns_66 (cost=0.14..3.16 rows=1 width=24) (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)
113. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx68 on notifications_summary_weekly_partitioned_2020_w20 ns_67 (cost=0.14..3.16 rows=1 width=24) (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)
114. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx69 on notifications_summary_weekly_partitioned_2020_w21 ns_68 (cost=0.14..3.16 rows=1 width=24) (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)
115. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx70 on notifications_summary_weekly_partitioned_2020_w22 ns_69 (cost=0.14..3.16 rows=1 width=24) (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)
116. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx71 on notifications_summary_weekly_partitioned_2020_w23 ns_70 (cost=0.14..3.16 rows=1 width=24) (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)
117. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx72 on notifications_summary_weekly_partitioned_2020_w24 ns_71 (cost=0.14..3.16 rows=1 width=24) (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)
118. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx73 on notifications_summary_weekly_partitioned_2020_w25 ns_72 (cost=0.14..3.16 rows=1 width=24) (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)
119. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx74 on notifications_summary_weekly_partitioned_2020_w26 ns_73 (cost=0.14..3.16 rows=1 width=24) (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)
120. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx75 on notifications_summary_weekly_partitioned_2020_w27 ns_74 (cost=0.14..3.16 rows=1 width=24) (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)
121. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx76 on notifications_summary_weekly_partitioned_2020_w28 ns_75 (cost=0.14..3.16 rows=1 width=24) (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)
122. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx77 on notifications_summary_weekly_partitioned_2020_w29 ns_76 (cost=0.14..3.16 rows=1 width=24) (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)
123. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx78 on notifications_summary_weekly_partitioned_2020_w30 ns_77 (cost=0.14..3.16 rows=1 width=24) (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)
124. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx79 on notifications_summary_weekly_partitioned_2020_w31 ns_78 (cost=0.14..3.16 rows=1 width=24) (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)
125. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx80 on notifications_summary_weekly_partitioned_2020_w32 ns_79 (cost=0.14..3.16 rows=1 width=24) (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)
126. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx81 on notifications_summary_weekly_partitioned_2020_w33 ns_80 (cost=0.14..3.16 rows=1 width=24) (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)
127. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx82 on notifications_summary_weekly_partitioned_2020_w34 ns_81 (cost=0.14..3.16 rows=1 width=24) (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)
128. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx83 on notifications_summary_weekly_partitioned_2020_w35 ns_82 (cost=0.14..3.16 rows=1 width=24) (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)
129. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx84 on notifications_summary_weekly_partitioned_2020_w36 ns_83 (cost=0.14..3.16 rows=1 width=24) (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)
130. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx85 on notifications_summary_weekly_partitioned_2020_w37 ns_84 (cost=0.14..3.16 rows=1 width=24) (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)
131. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx86 on notifications_summary_weekly_partitioned_2020_w38 ns_85 (cost=0.14..3.16 rows=1 width=24) (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)
132. 0.007 0.007 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx87 on notifications_summary_weekly_partitioned_2020_w39 ns_86 (cost=0.14..3.16 rows=1 width=24) (actual time=0.035..0.036 rows=0 loops=1)

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

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx88 on notifications_summary_weekly_partitioned_2020_w40 ns_87 (cost=0.14..3.16 rows=1 width=24) (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)
134. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx89 on notifications_summary_weekly_partitioned_2020_w41 ns_88 (cost=0.14..3.16 rows=1 width=24) (actual time=0.004..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)
135. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx90 on notifications_summary_weekly_partitioned_2020_w42 ns_89 (cost=0.14..3.16 rows=1 width=24) (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)
136. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx91 on notifications_summary_weekly_partitioned_2020_w43 ns_90 (cost=0.14..3.16 rows=1 width=24) (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)
137. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx92 on notifications_summary_weekly_partitioned_2020_w44 ns_91 (cost=0.14..3.16 rows=1 width=24) (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)
138. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx93 on notifications_summary_weekly_partitioned_2020_w45 ns_92 (cost=0.14..3.16 rows=1 width=24) (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)
139. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx94 on notifications_summary_weekly_partitioned_2020_w46 ns_93 (cost=0.14..3.16 rows=1 width=24) (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)
140. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx95 on notifications_summary_weekly_partitioned_2020_w47 ns_94 (cost=0.14..3.16 rows=1 width=24) (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)
141. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx96 on notifications_summary_weekly_partitioned_2020_w48 ns_95 (cost=0.14..3.16 rows=1 width=24) (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)
142. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx97 on notifications_summary_weekly_partitioned_2020_w49 ns_96 (cost=0.14..3.16 rows=1 width=24) (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)
143. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx98 on notifications_summary_weekly_partitioned_2020_w50 ns_97 (cost=0.14..3.16 rows=1 width=24) (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)
144. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx99 on notifications_summary_weekly_partitioned_2020_w51 ns_98 (cost=0.14..3.16 rows=1 width=24) (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)
145. 0.001 0.001 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uui_idx100 on notifications_summary_weekly_partitioned_2020_w52 ns_99 (cost=0.14..3.16 rows=1 width=24) (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)
146. 0.002 0.002 ↓ 0.0 0 1 / 5

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx53 on notifications_summary_weekly_part_default ns_100 (cost=0.14..3.16 rows=1 width=24) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
Planning time : 231.064 ms
Execution time : 1,348.560 ms