explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bNTF

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 21,875.246 ↑ 1.0 1 1

Limit (cost=432,836.61..432,836.62 rows=1 width=8) (actual time=21,875.245..21,875.246 rows=1 loops=1)

2. 0.000 21,875.242 ↑ 1.0 1 1

Finalize Aggregate (cost=432,836.61..432,836.62 rows=1 width=8) (actual time=21,875.242..21,875.242 rows=1 loops=1)

3. 148.363 21,936.161 ↓ 1.2 5 1

Gather (cost=432,836.19..432,836.60 rows=4 width=8) (actual time=21,871.188..21,936.161 rows=5 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
4. 18.405 21,787.798 ↑ 1.0 1 5 / 5

Partial Aggregate (cost=431,836.19..431,836.20 rows=1 width=8) (actual time=21,787.798..21,787.798 rows=1 loops=5)

5. 153.907 21,769.393 ↑ 3.9 259,315 5 / 5

Parallel Hash Left Join (cost=23,737.65..429,290.98 rows=1,018,083 width=0) (actual time=19,661.523..21,769.393 rows=259,315 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)))
6. 22.162 1,954.411 ↓ 2.4 259,299 5 / 5

Parallel Append (cost=0.14..308,221.68 rows=108,184 width=24) (actual time=0.069..1,954.411 rows=259,299 loops=5)

  • Subplans Removed: 11
7. 151.358 151.358 ↓ 12.0 229,101 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201907 e_7 (cost=0.00..48,208.90 rows=19,098 width=24) (actual time=0.070..756.789 rows=229,101 loops=1)

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP))
8. 796.707 796.707 ↓ 1.9 15,200 5 / 5

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

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP))
9. 74.356 74.356 ↓ 9.3 119,924 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_2018 e (cost=0.00..26,784.70 rows=12,895 width=24) (actual time=0.081..371.778 rows=119,924 loops=1)

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP))
10. 67.174 67.174 ↓ 9.3 105,026 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201908 e_8 (cost=0.00..25,740.59 rows=11,293 width=24) (actual time=0.057..335.870 rows=105,026 loops=1)

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP))
11. 80.785 80.785 ↓ 9.3 110,162 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201904 e_4 (cost=0.00..24,691.72 rows=11,845 width=24) (actual time=0.033..403.924 rows=110,162 loops=1)

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP))
12. 73.575 73.575 ↓ 9.3 80,941 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201909 e_9 (cost=0.00..23,047.20 rows=8,703 width=24) (actual time=0.027..367.877 rows=80,941 loops=1)

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP))
13. 60.553 60.553 ↓ 9.3 107,061 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201906 e_6 (cost=0.00..22,507.72 rows=11,512 width=24) (actual time=0.052..302.767 rows=107,061 loops=1)

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP))
14. 218.728 218.728 ↓ 3.1 29,927 3 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201903 e_3 (cost=0.00..21,399.23 rows=9,654 width=24) (actual time=0.036..364.546 rows=29,927 loops=3)

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP))
15. 64.094 64.094 ↓ 9.3 101,429 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201905 e_5 (cost=0.00..21,232.38 rows=10,906 width=24) (actual time=0.032..320.468 rows=101,429 loops=1)

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP))
16. 50.529 50.529 ↓ 4.6 39,561 2 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201910 e_10 (cost=0.00..19,647.46 rows=8,508 width=24) (actual time=0.035..126.322 rows=39,561 loops=2)

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP))
17. 115.141 115.141 ↓ 4.6 35,883 2 / 5

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

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP))
18. 31.075 31.075 ↓ 9.3 57,880 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201901 e_1 (cost=0.00..12,021.42 rows=6,224 width=24) (actual time=0.025..155.377 rows=57,880 loops=1)

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP))
19. 135.683 135.683 ↓ 9.3 49,864 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_201902 e_2 (cost=0.00..10,330.70 rows=5,362 width=24) (actual time=0.019..678.413 rows=49,864 loops=1)

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP))
20. 12.493 12.493 ↓ 7.1 18,441 1 / 5

Parallel Seq Scan on events_org_part_12_l3_t_202001 e_13 (cost=0.00..5,278.16 rows=2,602 width=24) (actual time=0.070..62.463 rows=18,441 loops=1)

  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= CURRENT_TIMESTAMP))
21. 10,024.097 19,661.075 ↓ 14.2 60,189 5 / 5

Parallel Hash (cost=23,684.70..23,684.70 rows=4,225 width=24) (actual time=19,661.075..19,661.075 rows=60,189 loops=5)

  • Buckets: 524,288 (originally 32768) Batches: 1 (originally 1) Memory Usage: 24,512kB
22. 7.379 9,636.978 ↓ 14.2 60,189 5 / 5

Parallel Append (cost=38.20..23,684.70 rows=4,225 width=24) (actual time=239.513..9,636.978 rows=60,189 loops=5)

23. 58.158 149.872 ↓ 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=462.475..749.358 rows=21,011 loops=1)

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
25. 5,946.606 5,949.325 ↓ 4.4 3,268 5 / 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=23.280..5,949.325 rows=3,268 loops=5)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Heap Blocks: exact=140
26. 2.719 2.719 ↓ 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=13.596..13.596 rows=16,341 loops=1)

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

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
29. 1,226.853 1,304.564 ↓ 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=391.827..6,522.818 rows=16,739 loops=1)

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
31. 1,508.535 1,583.480 ↓ 10.3 4,849 3 / 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=133.941..2,639.133 rows=4,849 loops=3)

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

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

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

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

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

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

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

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

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
41. 43.156 45.102 ↓ 21.2 7,412 2 / 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=6.199..112.755 rows=7,412 loops=2)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Heap Blocks: exact=3,743
42. 1.946 1.946 ↓ 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=9.730..9.730 rows=14,823 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
43. 44.487 45.659 ↓ 31.8 20,518 1 / 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=9.250..228.296 rows=20,518 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Heap Blocks: exact=18,561
44. 1.172 1.172 ↓ 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.861..5.861 rows=20,518 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
45. 32.792 33.977 ↓ 39.2 13,460 1 / 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=8.049..169.884 rows=13,460 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Heap Blocks: exact=12,603
46. 1.184 1.184 ↓ 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.922..5.922 rows=13,460 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
47. 16.794 17.328 ↓ 25.8 6,540 1 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2020_w2 ns_49 (cost=13.96..652.33 rows=253 width=24) (actual time=3.682..86.640 rows=6,540 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Heap Blocks: exact=6,192
48. 0.534 0.534 ↓ 15.3 6,565 1 / 5

Bitmap Index Scan on notifications_summary_weekly_organization_uuid_recipient__idx50 (cost=0.00..13.86 rows=430 width=0) (actual time=2.669..2.669 rows=6,565 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
49. 42.948 42.948 ↓ 29.3 18,848 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,647.59 rows=644 width=24) (actual time=0.103..214.740 rows=18,848 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
50. 37.237 37.237 ↓ 37.0 16,893 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,176.65 rows=456 width=24) (actual time=0.110..186.183 rows=16,893 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
51. 40.878 40.878 ↓ 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.078..204.389 rows=19,586 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
52. 39.000 39.000 ↓ 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.077..195.000 rows=18,124 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
53. 26.873 26.873 ↓ 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.078..134.364 rows=13,046 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
54. 8.423 8.423 ↓ 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.082..42.116 rows=3,719 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
55. 0.370 0.370 ↓ 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.078..1.850 rows=143 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
56. 0.569 0.569 ↓ 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.066..2.846 rows=199 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
57. 0.495 0.495 ↓ 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.086..2.475 rows=191 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
58. 0.362 0.362 ↓ 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.090..1.809 rows=135 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
59. 0.278 0.278 ↓ 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.074..1.392 rows=95 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
60. 0.400 0.400 ↓ 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.068..2.002 rows=143 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
61. 0.481 0.481 ↓ 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.081..2.403 rows=174 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
62. 0.439 0.439 ↓ 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.082..2.197 rows=154 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
63. 0.487 0.487 ↓ 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.085..2.434 rows=172 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
64. 0.491 0.491 ↓ 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.079..2.453 rows=177 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
65. 0.283 0.283 ↓ 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.086..1.415 rows=99 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
66. 0.378 0.378 ↓ 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.078..1.888 rows=127 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
67. 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.117..2.526 rows=171 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
68. 0.311 0.311 ↓ 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.080..1.555 rows=93 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
69. 0.275 0.275 ↓ 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.107..1.376 rows=93 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
70. 0.419 0.419 ↓ 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.077..2.097 rows=146 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
71. 0.428 0.428 ↓ 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.123..2.141 rows=130 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 ↓ 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.075..2.055 rows=130 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
73. 0.401 0.401 ↓ 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..2.005 rows=134 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
74. 0.388 0.388 ↓ 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.087..1.941 rows=135 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
75. 0.468 0.468 ↓ 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.073..2.341 rows=150 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
76. 0.409 0.409 ↓ 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.078..2.047 rows=124 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
77. 0.340 0.340 ↓ 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.088..1.702 rows=111 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
78. 0.441 0.441 ↓ 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.068..2.206 rows=146 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
79. 0.423 0.423 ↓ 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.091..2.116 rows=131 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
80. 0.326 0.326 ↓ 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.097..1.630 rows=105 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
81. 0.354 0.354 ↓ 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.088..1.771 rows=109 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
82. 0.429 0.429 ↓ 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.094..2.144 rows=115 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
83. 0.395 0.395 ↓ 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.100..1.973 rows=112 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
84. 0.261 0.261 ↓ 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.090..1.307 rows=71 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
85. 0.048 0.048 ↓ 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.131..0.242 rows=7 loops=1)

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
87. 0.000 0.000 ↓ 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=24) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
88. 0.000 0.000 ↓ 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=24) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
89. 0.000 0.000 ↓ 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=24) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
90. 0.000 0.000 ↓ 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=24) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
91. 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=24) (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)
92. 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=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)
93. 0.000 0.000 ↓ 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=24) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
94. 0.000 0.000 ↓ 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=24) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
95. 0.000 0.000 ↓ 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=24) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
96. 0.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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_pa_organization_uuid_ntfn_id_idx70 on notifications_summary_weekly_partitioned_2020_w22 ns_69 (cost=0.14..3.16 rows=1 width=24) (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)
106. 0.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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_pa_organization_uuid_ntfn_id_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)
122. 0.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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.000 0.000 ↓ 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=24) (actual time=0.002..0.002 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_pa_organization_uuid_ntfn_id_idx53 on notifications_summary_weekly_part_default ns_100 (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: (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
Planning time : 73.212 ms