explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ck4n

Settings
# exclusive inclusive rows x rows loops node
1. 2,255.493 18,169.144 ↑ 3.2 8,448 1

Gather (cost=4,402.92..31,373.84 rows=26,764 width=32) (actual time=14,244.354..18,169.144 rows=8,448 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 24.467 15,913.651 ↑ 4.0 1,690 5 / 5

Parallel Hash Join (cost=3,402.92..27,697.44 rows=6,691 width=32) (actual time=8,389.258..15,913.651 rows=1,690 loops=5)

  • Hash Cond: (ns_41.event_uuid = e_7.event_uuid)
  • Join Filter: ((ns_41.created_date >= e_7.created) AND (ns_41.created_date <= (e_7.created + '31 days'::interval)))
3. 6.835 15,799.507 ↓ 14.2 60,193 5 / 5

Parallel Append (cost=38.20..23,686.20 rows=4,225 width=40) (actual time=16.951..15,799.507 rows=60,193 loops=5)

4. 17.211 19.731 ↓ 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=40) (actual time=16.437..98.657 rows=21,011 loops=1)

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
6. 6,810.437 6,816.225 ↓ 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=40) (actual time=18.685..6,816.225 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=212
7. 5.788 5.788 ↓ 13.3 16,715 1 / 5

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
8. 15.721 18.459 ↓ 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=40) (actual time=17.451..92.294 rows=18,444 loops=1)

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
10. 15.284 18.018 ↓ 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=40) (actual time=17.497..90.090 rows=16,739 loops=1)

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
12. 10.855 12.490 ↓ 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=40) (actual time=10.829..62.448 rows=14,546 loops=1)

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
14. 12.272 13.917 ↓ 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=40) (actual time=10.991..69.586 rows=15,138 loops=1)

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
16. 12.709 14.065 ↓ 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=40) (actual time=9.610..70.326 rows=15,487 loops=1)

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
18. 14.851 16.148 ↓ 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=40) (actual time=9.903..80.740 rows=20,179 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
19. 1.297 1.297 ↓ 16.6 20,179 1 / 5

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
20. 11.105 12.053 ↓ 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=40) (actual time=7.081..60.264 rows=13,481 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
21. 0.948 0.948 ↓ 17.7 13,481 1 / 5

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
22. 10.924 12.530 ↓ 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=40) (actual time=10.735..62.649 rows=14,823 loops=1)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
23. 1.605 1.605 ↓ 25.0 14,823 1 / 5

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
24. 1,895.050 1,897.362 ↓ 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=40) (actual time=40.361..9,486.811 rows=20,518 loops=1)

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
26. 11.255 12.012 ↓ 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=40) (actual time=5.990..60.060 rows=13,460 loops=1)

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
28. 790.141 790.850 ↓ 8.6 2,186 3 / 5

Parallel Bitmap Heap Scan on notifications_summary_weekly_partitioned_2020_w2 ns_49 (cost=15.46..653.83 rows=253 width=40) (actual time=11.554..1,318.083 rows=2,186 loops=3)

  • Recheck Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
  • Heap Blocks: exact=2374
29. 0.709 0.709 ↓ 15.3 6,588 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.543..3.543 rows=6,588 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
30. 12.971 12.971 ↓ 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=40) (actual time=0.047..64.855 rows=18,848 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
31. 10.536 10.536 ↓ 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=40) (actual time=0.054..52.678 rows=16,893 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
32. 37.564 37.564 ↓ 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=40) (actual time=2.083..187.819 rows=19,586 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
33. 32.049 32.049 ↓ 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=40) (actual time=0.164..160.244 rows=18,124 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
34. 24.972 24.972 ↓ 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=40) (actual time=0.145..124.858 rows=13,046 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
35. 6.598 6.598 ↓ 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=40) (actual time=3.262..32.989 rows=3,719 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
36. 467.306 467.306 ↓ 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=40) (actual time=34.191..2,336.531 rows=143 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
37. 546.807 546.807 ↓ 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=40) (actual time=14.459..2,734.037 rows=199 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
38. 0.499 0.499 ↓ 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=40) (actual time=0.380..2.497 rows=191 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
39. 352.504 352.504 ↓ 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=40) (actual time=13.304..1,762.519 rows=135 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
40. 384.445 384.445 ↓ 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=40) (actual time=61.938..1,922.223 rows=95 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
41. 492.207 492.207 ↓ 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=40) (actual time=30.128..2,461.036 rows=143 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
42. 0.443 0.443 ↓ 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=40) (actual time=0.226..2.214 rows=174 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
43. 0.361 0.361 ↓ 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=40) (actual time=0.097..1.805 rows=154 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
44. 0.397 0.397 ↓ 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=40) (actual time=0.099..1.987 rows=172 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
45. 510.351 510.351 ↓ 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=40) (actual time=33.629..2,551.754 rows=177 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
46. 335.906 335.906 ↓ 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=40) (actual time=39.501..1,679.532 rows=99 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
47. 415.214 415.214 ↓ 5.8 64 2 / 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=40) (actual time=18.441..1,038.036 rows=64 loops=2)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
48. 491.612 491.612 ↓ 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=40) (actual time=15.871..2,458.062 rows=171 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
49. 0.269 0.269 ↓ 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=40) (actual time=0.086..1.345 rows=93 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
50. 287.221 287.221 ↓ 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=40) (actual time=25.365..1,436.107 rows=93 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
51. 399.139 399.139 ↓ 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=40) (actual time=19.573..1,995.693 rows=146 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
52. 0.412 0.412 ↓ 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=40) (actual time=0.090..2.059 rows=130 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
53. 341.077 341.077 ↓ 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=40) (actual time=21.699..1,705.385 rows=130 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
54. 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=40) (actual time=0.137..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))
55. 0.439 0.439 ↓ 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=40) (actual time=0.103..2.197 rows=135 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
56. 460.064 460.064 ↓ 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=40) (actual time=86.244..2,300.318 rows=150 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
57. 0.601 0.601 ↓ 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=40) (actual time=1.128..3.004 rows=124 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
58. 0.296 0.296 ↓ 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=40) (actual time=0.093..1.479 rows=111 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
59. 1.318 1.318 ↓ 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=40) (actual time=3.724..6.590 rows=146 loops=1)

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
61. 272.685 272.685 ↓ 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=40) (actual time=24.026..1,363.426 rows=105 loops=1)

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
63. 248.485 248.485 ↓ 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=40) (actual time=26.122..1,242.427 rows=115 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
64. 1.456 1.456 ↓ 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=40) (actual time=4.247..7.281 rows=112 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid))
65. 0.326 0.326 ↓ 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=40) (actual time=0.105..1.628 rows=71 loops=1)

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

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

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

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

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

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

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

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx55 on notifications_summary_weekly_partitioned_2020_w7 ns_54 (cost=0.14..3.16 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

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

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

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx57 on notifications_summary_weekly_partitioned_2020_w9 ns_56 (cost=0.14..3.16 rows=1 width=40) (actual time=0.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)
74. 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=40) (actual time=0.004..0.004 rows=0 loops=1)

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

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

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

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

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

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

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

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

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx64 on notifications_summary_weekly_partitioned_2020_w16 ns_63 (cost=0.14..3.16 rows=1 width=40) (actual time=0.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)
81. 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=40) (actual time=0.004..0.004 rows=0 loops=1)

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

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

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

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

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
86. 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=40) (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)
87. 0.001 0.001 ↓ 0.0 0 1 / 5

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

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

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx72 on notifications_summary_weekly_partitioned_2020_w24 ns_71 (cost=0.14..3.16 rows=1 width=40) (actual time=0.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)
89. 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=40) (actual time=0.004..0.004 rows=0 loops=1)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx89 on notifications_summary_weekly_partitioned_2020_w41 ns_88 (cost=0.14..3.16 rows=1 width=40) (actual time=0.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_idx90 on notifications_summary_weekly_partitioned_2020_w42 ns_89 (cost=0.14..3.16 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

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

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

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

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

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

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx94 on notifications_summary_weekly_partitioned_2020_w46 ns_93 (cost=0.14..3.16 rows=1 width=40) (actual time=0.016..0.016 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_idx95 on notifications_summary_weekly_partitioned_2020_w47 ns_94 (cost=0.14..3.16 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

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

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

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

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

Parallel Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx99 on notifications_summary_weekly_partitioned_2020_w51 ns_98 (cost=0.14..3.16 rows=1 width=40) (actual time=0.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_uui_idx100 on notifications_summary_weekly_partitioned_2020_w52 ns_99 (cost=0.14..3.16 rows=1 width=40) (actual time=0.006..0.006 rows=0 loops=1)

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

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

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
118. 11.045 89.677 ↓ 2.4 1,701 5 / 5

Parallel Hash (cost=3,355.89..3,355.89 rows=706 width=24) (actual time=89.677..89.677 rows=1,701 loops=5)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 576kB
119. 0.162 78.632 ↓ 2.4 1,701 5 / 5

Parallel Append (cost=0.29..3,355.89 rows=706 width=24) (actual time=25.810..78.632 rows=1,701 loops=5)

120. 4.645 4.645 ↓ 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=23.225..23.225 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 days'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
121. 3.245 3.245 ↓ 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=16.227..16.227 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 days'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
122. 2.864 2.864 ↓ 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=14.319..14.319 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 days'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
123. 5.860 5.860 ↓ 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=29.302..29.302 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 days'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
124. 2.684 2.684 ↓ 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=13.418..13.418 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 days'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
125. 3.161 3.161 ↓ 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=15.806..15.806 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 days'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
126. 4.420 4.420 ↓ 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=22.098..22.098 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 days'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
127. 3.636 3.636 ↓ 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=18.179..18.179 rows=0 loops=1)

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

Index Scan using events_org_part_12_l3_t_20191_event_type_created_valid_rang_idx on events_org_part_12_l3_t_201910 e_10 (cost=0.29..3.31 rows=1 width=24) (actual time=43.972..43.972 rows=0 loops=1)

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

Index Scan using events_org_part_12_l3_t_20191_event_type_created_valid_ran_idx1 on events_org_part_12_l3_t_201911 e_11 (cost=0.29..3.31 rows=1 width=24) (actual time=25.810..25.810 rows=0 loops=1)

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

Index Scan using events_org_part_12_l3_t_20191_event_type_created_valid_ran_idx2 on events_org_part_12_l3_t_201912 e_12 (cost=0.29..3.31 rows=1 width=24) (actual time=27.206..27.206 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 days'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
131. 1.617 1.617 ↓ 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=8.086..8.086 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 days'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
132. 11.849 11.849 ↓ 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=59.245..59.245 rows=0 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 days'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
133. 15.084 15.084 ↓ 5.1 8,506 1 / 5

Parallel Index Scan using events_org_part_12_l3_t_202001_created_idx on events_org_part_12_l3_t_202001 e_13 (cost=0.29..3,304.31 rows=1,659 width=24) (actual time=16.684..75.420 rows=8,506 loops=1)

  • Index Cond: ((created <= CURRENT_TIMESTAMP) AND (created > (CURRENT_TIMESTAMP - '3 days'::interval)))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
134. 0.001 0.001 ↓ 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.003..0.003 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 days'::interval)))
135. 0.001 0.001 ↓ 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.003..0.003 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 days'::interval)))
136. 0.001 0.001 ↓ 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.003..0.003 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 days'::interval)))
137. 0.001 0.001 ↓ 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.003..0.004 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 days'::interval)))
138. 0.001 0.001 ↓ 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.003..0.003 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 days'::interval)))
139. 0.001 0.001 ↓ 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.003..0.003 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 days'::interval)))
140. 0.001 0.001 ↓ 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.003..0.003 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 days'::interval)))
141. 0.001 0.001 ↓ 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.003..0.003 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 days'::interval)))
142. 0.001 0.001 ↓ 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.003..0.003 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 days'::interval)))
143. 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.003..0.003 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 days'::interval)))
144. 0.001 0.001 ↓ 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.007..0.007 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 days'::interval)))
Planning time : 72.195 ms
Execution time : 18,173.205 ms