explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9PcO

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 91,073.064 ↑ 1.0 1 1

Limit (cost=1,711.96..1,711.97 rows=1 width=8) (actual time=91,073.063..91,073.064 rows=1 loops=1)

2. 31.775 91,073.061 ↑ 1.0 1 1

Aggregate (cost=1,711.96..1,711.97 rows=1 width=8) (actual time=91,073.060..91,073.061 rows=1 loops=1)

3. 26.767 91,041.286 ↓ 17.8 300,887 1

Append (cost=0.56..1,669.62 rows=16,937 width=0) (actual time=11.118..91,041.286 rows=300,887 loops=1)

  • Subplans Removed: 50
4. 11.816 11.816 ↓ 8.5 111 1

Index Only Scan using notifications_summary_weekly__organization_uuid_recipient_u_idx on notifications_summary_weekly_partitioned_2019_w5 ns (cost=0.56..2.36 rows=13 width=0) (actual time=11.112..11.816 rows=111 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
5. 6.714 6.714 ↓ 10.1 131 1

Index Only Scan using notifications_summary_weekly__organization_uuid_recipient__idx1 on notifications_summary_weekly_partitioned_2019_w6 ns_1 (cost=0.56..2.36 rows=13 width=0) (actual time=6.665..6.714 rows=131 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
6. 47.338 47.338 ↓ 9.1 109 1

Index Only Scan using notifications_summary_weekly__organization_uuid_recipient__idx2 on notifications_summary_weekly_partitioned_2019_w7 ns_2 (cost=0.56..2.33 rows=12 width=0) (actual time=47.270..47.338 rows=109 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
7. 18.665 18.665 ↓ 14.0 112 1

Index Only Scan using notifications_summary_weekly__organization_uuid_recipient__idx3 on notifications_summary_weekly_partitioned_2019_w8 ns_3 (cost=0.56..2.25 rows=8 width=0) (actual time=18.603..18.665 rows=112 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
8. 21.785 21.785 ↓ 11.2 146 1

Index Only Scan using notifications_summary_weekly__organization_uuid_recipient__idx4 on notifications_summary_weekly_partitioned_2019_w9 ns_4 (cost=0.56..2.36 rows=13 width=0) (actual time=21.719..21.785 rows=146 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
9. 39.835 39.835 ↓ 11.5 115 1

Index Only Scan using notifications_summary_weekly__organization_uuid_recipient__idx5 on notifications_summary_weekly_partitioned_2019_w10 ns_5 (cost=0.56..2.29 rows=10 width=0) (actual time=39.773..39.835 rows=115 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
10. 10.825 10.825 ↓ 8.8 150 1

Index Only Scan using notifications_summary_weekly__organization_uuid_recipient__idx6 on notifications_summary_weekly_partitioned_2019_w11 ns_6 (cost=0.56..2.45 rows=17 width=0) (actual time=10.194..10.825 rows=150 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
11. 17.054 17.054 ↓ 7.2 130 1

Index Only Scan using notifications_summary_weekly__organization_uuid_recipient__idx7 on notifications_summary_weekly_partitioned_2019_w12 ns_7 (cost=0.56..2.47 rows=18 width=0) (actual time=16.308..17.054 rows=130 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
12. 10.919 10.919 ↓ 8.1 105 1

Index Only Scan using notifications_summary_weekly__organization_uuid_recipient__idx8 on notifications_summary_weekly_partitioned_2019_w13 ns_8 (cost=0.56..2.36 rows=13 width=0) (actual time=10.347..10.919 rows=105 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
13. 12.688 12.688 ↓ 7.2 143 1

Index Only Scan using notifications_summary_weekly__organization_uuid_recipient__idx9 on notifications_summary_weekly_partitioned_2019_w14 ns_9 (cost=0.56..2.51 rows=20 width=0) (actual time=12.612..12.688 rows=143 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
14. 21.639 21.639 ↓ 9.3 177 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx10 on notifications_summary_weekly_partitioned_2019_w15 ns_10 (cost=0.56..2.49 rows=19 width=0) (actual time=20.855..21.639 rows=177 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
15. 13.065 13.065 ↓ 5.2 99 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx11 on notifications_summary_weekly_partitioned_2019_w16 ns_11 (cost=0.56..2.49 rows=19 width=0) (actual time=13.017..13.065 rows=99 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
16. 64.827 64.827 ↓ 4.5 95 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx12 on notifications_summary_weekly_partitioned_2019_w17 ns_12 (cost=0.56..2.54 rows=21 width=0) (actual time=64.776..64.827 rows=95 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
17. 12.790 12.790 ↓ 5.6 135 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx13 on notifications_summary_weekly_partitioned_2019_w18 ns_13 (cost=0.56..2.60 rows=24 width=0) (actual time=11.996..12.790 rows=135 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
18. 7.292 7.292 ↓ 5.2 93 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx14 on notifications_summary_weekly_partitioned_2019_w19 ns_14 (cost=0.56..2.47 rows=18 width=0) (actual time=6.258..7.292 rows=93 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
19. 14.284 14.284 ↓ 5.1 143 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx15 on notifications_summary_weekly_partitioned_2019_w20 ns_15 (cost=0.56..2.69 rows=28 width=0) (actual time=14.204..14.284 rows=143 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
20. 43.622 43.622 ↓ 8.0 199 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx16 on notifications_summary_weekly_partitioned_2019_w21 ns_16 (cost=0.56..2.63 rows=25 width=0) (actual time=42.509..43.622 rows=199 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
21. 13.519 13.519 ↓ 9.5 171 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx17 on notifications_summary_weekly_partitioned_2019_w22 ns_17 (cost=0.56..2.47 rows=18 width=0) (actual time=13.431..13.519 rows=171 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
22. 14.216 14.216 ↓ 6.7 127 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx18 on notifications_summary_weekly_partitioned_2019_w23 ns_18 (cost=0.56..2.49 rows=19 width=0) (actual time=13.445..14.216 rows=127 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
23. 15.894 15.894 ↓ 8.1 146 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx19 on notifications_summary_weekly_partitioned_2019_w24 ns_19 (cost=0.56..2.47 rows=18 width=0) (actual time=15.834..15.894 rows=146 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
24. 19.906 19.906 ↓ 8.6 172 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx20 on notifications_summary_weekly_partitioned_2019_w25 ns_20 (cost=0.56..2.51 rows=20 width=0) (actual time=19.809..19.906 rows=172 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
25. 13.025 13.025 ↓ 8.0 191 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx21 on notifications_summary_weekly_partitioned_2019_w26 ns_21 (cost=0.56..2.60 rows=24 width=0) (actual time=12.921..13.025 rows=191 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
26. 0.854 0.854 ↓ 7.2 130 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx22 on notifications_summary_weekly_partitioned_2019_w27 ns_22 (cost=0.56..2.47 rows=18 width=0) (actual time=0.776..0.854 rows=130 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
27. 6.293 6.293 ↓ 5.2 93 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx23 on notifications_summary_weekly_partitioned_2019_w28 ns_23 (cost=0.56..2.47 rows=18 width=0) (actual time=5.651..6.293 rows=93 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
28. 16.883 16.883 ↓ 7.7 154 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx24 on notifications_summary_weekly_partitioned_2019_w29 ns_24 (cost=0.56..2.51 rows=20 width=0) (actual time=16.795..16.883 rows=154 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
29. 17.268 17.268 ↓ 8.7 174 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx25 on notifications_summary_weekly_partitioned_2019_w30 ns_25 (cost=0.56..2.51 rows=20 width=0) (actual time=16.575..17.268 rows=174 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
30. 30.198 30.198 ↓ 7.9 135 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx26 on notifications_summary_weekly_partitioned_2019_w31 ns_26 (cost=0.56..2.45 rows=17 width=0) (actual time=29.466..30.198 rows=135 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
31. 11.589 11.589 ↓ 7.9 134 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx27 on notifications_summary_weekly_partitioned_2019_w32 ns_27 (cost=0.56..2.45 rows=17 width=0) (actual time=11.572..11.589 rows=134 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
32. 15.695 15.695 ↓ 7.9 71 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx28 on notifications_summary_weekly_partitioned_2019_w33 ns_28 (cost=0.56..2.26 rows=9 width=0) (actual time=15.627..15.695 rows=71 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
33. 23.785 23.785 ↓ 7.0 7 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx29 on notifications_summary_weekly_partitioned_2019_w34 ns_29 (cost=0.56..2.08 rows=1 width=0) (actual time=23.780..23.785 rows=7 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
34. 24.601 24.601 ↓ 8.9 124 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx30 on notifications_summary_weekly_partitioned_2019_w35 ns_30 (cost=0.56..2.38 rows=14 width=0) (actual time=24.542..24.601 rows=124 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
35. 18.497 18.497 ↓ 22.3 3,719 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx31 on notifications_summary_weekly_partitioned_2019_w36 ns_31 (cost=0.56..7.32 rows=167 width=0) (actual time=17.522..18.497 rows=3,719 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
36. 46.901 46.901 ↓ 23.0 13,046 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx32 on notifications_summary_weekly_partitioned_2019_w37 ns_32 (cost=0.56..19.30 rows=566 width=0) (actual time=42.631..46.901 rows=13,046 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
37. 38.152 38.152 ↓ 21.8 19,586 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx33 on notifications_summary_weekly_partitioned_2019_w38 ns_33 (cost=0.56..31.29 rows=899 width=0) (actual time=31.634..38.152 rows=19,586 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
38. 31.534 31.534 ↓ 28.9 18,124 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx34 on notifications_summary_weekly_partitioned_2019_w39 ns_34 (cost=0.56..22.20 rows=628 width=0) (actual time=26.258..31.534 rows=18,124 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
39. 45.044 45.044 ↓ 18.7 20,518 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx35 on notifications_summary_weekly_partitioned_2019_w40 ns_35 (cost=0.56..37.27 rows=1,098 width=0) (actual time=25.354..45.044 rows=20,518 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
40. 27.794 27.794 ↓ 16.6 20,179 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx36 on notifications_summary_weekly_partitioned_2019_w41 ns_36 (cost=0.56..42.90 rows=1,215 width=0) (actual time=21.673..27.794 rows=20,179 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
41. 127.676 127.676 ↓ 21.8 16,893 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx37 on notifications_summary_weekly_partitioned_2019_w42 ns_37 (cost=0.56..31.53 rows=776 width=0) (actual time=26.247..127.676 rows=16,893 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
42. 22.042 22.042 ↓ 23.1 13,460 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx38 on notifications_summary_weekly_partitioned_2019_w43 ns_38 (cost=0.56..28.68 rows=583 width=0) (actual time=9.183..22.042 rows=13,460 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
43. 148.915 148.915 ↓ 19.1 15,138 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx39 on notifications_summary_weekly_partitioned_2019_w44 ns_39 (cost=0.56..39.41 rows=793 width=0) (actual time=25.125..148.915 rows=15,138 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
44. 432.016 432.016 ↓ 18.3 14,546 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx40 on notifications_summary_weekly_partitioned_2019_w45 ns_40 (cost=0.56..42.50 rows=797 width=0) (actual time=16.812..432.016 rows=14,546 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
45. 455.556 455.556 ↓ 12.5 21,011 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx41 on notifications_summary_weekly_partitioned_2019_w46 ns_41 (cost=0.56..83.41 rows=1,682 width=0) (actual time=33.961..455.556 rows=21,011 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
46. 419.236 419.236 ↓ 15.7 18,444 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx42 on notifications_summary_weekly_partitioned_2019_w47 ns_42 (cost=0.56..57.07 rows=1,178 width=0) (actual time=16.092..419.236 rows=18,444 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
47. 390.757 390.757 ↓ 25.0 14,823 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx43 on notifications_summary_weekly_partitioned_2019_w48 ns_43 (cost=0.56..33.43 rows=594 width=0) (actual time=37.982..390.757 rows=14,823 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 0
48. 1,848.254 1,848.254 ↓ 17.2 18,848 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx44 on notifications_summary_weekly_partitioned_2019_w49 ns_44 (cost=0.56..61.18 rows=1,094 width=0) (actual time=22.170..1,848.254 rows=18,848 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 61
49. 521.925 521.925 ↓ 16.1 16,739 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx45 on notifications_summary_weekly_partitioned_2019_w50 ns_45 (cost=0.56..50.92 rows=1,038 width=0) (actual time=105.373..521.925 rows=16,739 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 1
50. 396.548 396.548 ↓ 19.1 15,487 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx46 on notifications_summary_weekly_partitioned_2019_w51 ns_46 (cost=0.56..38.31 rows=811 width=0) (actual time=30.262..396.548 rows=15,487 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 1
51. 375.003 375.003 ↓ 17.7 13,481 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx47 on notifications_summary_weekly_partitioned_2019_w52 ns_47 (cost=0.56..35.69 rows=761 width=0) (actual time=41.150..375.003 rows=13,481 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 2
52. 74,603.193 74,603.193 ↓ 13.0 16,341 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx49 on notifications_summary_weekly_partitioned_2020_w1 ns_48 (cost=0.56..253.45 rows=1,253 width=0) (actual time=2.865..74,603.193 rows=16,341 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 4,777
53. 10,466.536 10,466.536 ↓ 15.1 6,482 1

Index Only Scan using notifications_summary_weekly_organization_uuid_recipient__idx50 on notifications_summary_weekly_partitioned_2020_w2 ns_49 (cost=0.56..431.61 rows=429 width=0) (actual time=0.107..10,466.536 rows=6,482 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
  • Heap Fetches: 4,333
54. 0.056 0.056 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx53 on notifications_summary_weekly_part_default ns_50 (cost=0.14..3.17 rows=1 width=0) (actual time=0.056..0.056 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
Planning time : 39.660 ms
Execution time : 91,075.872 ms