explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uAB4 : Optimization for: plan #cw0W

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 18,530.425 24,486.265 ↑ 8.3 209 1

HashAggregate (cost=1,580.10..1,597.37 rows=1,727 width=410) (actual time=24,485.953..24,486.265 rows=209 loops=1)

  • Group Key: project0_.id, project0_.author_id, project0_.created_at, project0_.domain_id, project0_.end_timeframe_milestone_id, project0_.external_sponsors, project0_.is_deferred, project0_.is_eng_optional, project0_.is_imported, project0_.is_qa_automated, project0_.needs_hi, project0_.needs_infosec_review, project0_.needs_legal, project0_.needs_privacy_review, project0_.phase, project0_.primary_area_id, project0_.priority, project0_.project_definition, project0_.radar_tlf, project0_.radar_tstt_id, project0_.ranking, project0_.reject_reason, project0_.short_description, project0_.start_timeframe_milestone_id, project0_.state, project0_.status, project0_.status_comment, project0_.status_comment_updated_at, project0_.status_comment_updated_by_user_id, project0_.status_updated_at, project0_.tentpole, project0_.timeframe_id, project0_.title, project0_.ultra, project0_.updated_at
2. 2,691.003 5,955.840 ↓ 2,643.3 4,565,030 1

Hash Left Join (cost=1,114.09..1,428.99 rows=1,727 width=410) (actual time=636.546..5,955.840 rows=4,565,030 loops=1)

  • Hash Cond: (project0_.id = resourceal29_.project_id)
  • Filter: ((project0_.author_id = ANY ('{314,2853,2852,2851,2850,1913,1906,1903,1902,1898,1927,1926,1925,1923,1922,1921,1920,1919,1918,1917,1916,1915,1914,1912,1911,1910,1909,1908,1907,1905,1904,1901,1900,1899,771,770,620,619,313}'::bigint[])) OR (leadusers15_.user_id = ANY ('{314,2853,2852,2851,2850,1913,1906,1903,1902,1898,1927,1926,1925,1923,1922,1921,1920,1919,1918,1917,1916,1915,1914,1912,1911,1910,1909,1908,1907,1905,1904,1901,1900,1899,771,770,620,619,313}'::bigint[])) OR (user19_.id = ANY ('{314,2853,2852,2851,2850,1913,1906,1903,1902,1898,1927,1926,1925,1923,1922,1921,1920,1919,1918,1917,1916,1915,1914,1912,1911,1910,1909,1908,1907,1905,1904,1901,1900,1899,771,770,620,619,313}'::bigint[])) OR (user22_.id = ANY ('{314,2853,2852,2851,2850,1913,1906,1903,1902,1898,1927,1926,1925,1923,1922,1921,1920,1919,1918,1917,1916,1915,1914,1912,1911,1910,1909,1908,1907,1905,1904,1901,1900,1899,771,770,620,619,313}'::bigint[])) OR (user24_.id = ANY ('{314,2853,2852,2851,2850,1913,1906,1903,1902,1898,1927,1926,1925,1923,1922,1921,1920,1919,1918,1917,1916,1915,1914,1912,1911,1910,1909,1908,1907,1905,1904,1901,1900,1899,771,770,620,619,313}'::bigint[])) OR (user28_.id = ANY ('{314,2853,2852,2851,2850,1913,1906,1903,1902,1898,1927,1926,1925,1923,1922,1921,1920,1919,1918,1917,1916,1915,1914,1912,1911,1910,1909,1908,1907,1905,1904,1901,1900,1899,771,770,620,619,313}'::bigint[])) OR (user31_.id = ANY ('{314,2853,2852,2851,2850,1913,1906,1903,1902,1898,1927,1926,1925,1923,1922,1921,1920,1919,1918,1917,1916,1915,1914,1912,1911,1910,1909,1908,1907,1905,1904,1901,1900,1899,771,770,620,619,313}'::bigint[])))
  • Rows Removed by Filter: 10544
3. 2,627.443 3,264.614 ↓ 1,194.0 2,340,186 1

Hash Right Join (cost=1,084.15..1,250.59 rows=1,960 width=450) (actual time=636.313..3,264.614 rows=2,340,186 loops=1)

  • Hash Cond: (scopings25_.project_id = project0_.id)
4. 0.098 1.360 ↑ 1.0 176 1

Hash Right Join (cost=20.49..169.84 rows=178 width=16) (actual time=0.358..1.360 rows=176 loops=1)

  • Hash Cond: (teammanage27_.team_id = team26_.id)
5. 0.355 1.021 ↑ 1.0 144 1

Merge Right Join (cost=7.88..154.91 rows=144 width=16) (actual time=0.101..1.021 rows=144 loops=1)

  • Merge Cond: (user28_.id = teammanage27_.user_id)
6. 0.577 0.577 ↑ 1.2 2,896 1

Index Only Scan using users_pkey on users user28_ (cost=0.28..237.83 rows=3,351 width=8) (actual time=0.012..0.577 rows=2,896 loops=1)

  • Heap Fetches: 585
7. 0.062 0.089 ↑ 1.0 144 1

Sort (cost=7.60..7.96 rows=144 width=16) (actual time=0.086..0.089 rows=144 loops=1)

  • Sort Key: teammanage27_.user_id
  • Sort Method: quicksort Memory: 31kB
8. 0.027 0.027 ↑ 1.0 144 1

Seq Scan on user_manages_team teammanage27_ (cost=0.00..2.44 rows=144 width=16) (actual time=0.011..0.027 rows=144 loops=1)

9. 0.042 0.241 ↑ 1.0 176 1

Hash (cost=10.41..10.41 rows=176 width=16) (actual time=0.241..0.241 rows=176 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
10. 0.072 0.199 ↑ 1.0 176 1

Hash Left Join (cost=6.17..10.41 rows=176 width=16) (actual time=0.099..0.199 rows=176 loops=1)

  • Hash Cond: (scopings25_.team_id = team26_.id)
11. 0.048 0.048 ↑ 1.0 176 1

Seq Scan on scopings scopings25_ (cost=0.00..3.76 rows=176 width=16) (actual time=0.014..0.048 rows=176 loops=1)

12. 0.034 0.079 ↓ 1.0 144 1

Hash (cost=4.41..4.41 rows=141 width=8) (actual time=0.079..0.079 rows=144 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
13. 0.045 0.045 ↓ 1.0 144 1

Seq Scan on teams team26_ (cost=0.00..4.41 rows=141 width=8) (actual time=0.007..0.045 rows=144 loops=1)

14. 319.514 635.811 ↓ 83.4 161,262 1

Hash (cost=1,039.50..1,039.50 rows=1,933 width=442) (actual time=635.811..635.811 rows=161,262 loops=1)

  • Buckets: 16384 (originally 2048) Batches: 256 (originally 1) Memory Usage: 31775kB
15. 101.158 316.297 ↓ 83.4 161,262 1

Hash Left Join (cost=809.61..1,039.50 rows=1,933 width=442) (actual time=5.913..316.297 rows=161,262 loops=1)

  • Hash Cond: (areaowners21_.user_id = user22_.id)
16. 85.541 213.484 ↓ 83.4 161,262 1

Hash Left Join (cost=624.21..849.02 rows=1,933 width=442) (actual time=4.252..213.484 rows=161,262 loops=1)

  • Hash Cond: (project0_.id = sponsors23_.project_id)
17. 81.352 127.915 ↓ 83.4 161,262 1

Hash Left Join (cost=601.93..819.16 rows=1,933 width=434) (actual time=4.220..127.915 rows=161,262 loops=1)

  • Hash Cond: (project0_.primary_area_id = area20_.id)
18. 22.653 46.466 ↓ 58.2 41,236 1

Hash Left Join (cost=597.52..791.74 rows=708 width=426) (actual time=4.118..46.466 rows=41,236 loops=1)

  • Hash Cond: (project0_.id = programs16_.project_id)
19. 9.138 23.495 ↓ 25.2 16,028 1

Hash Left Join (cost=426.66..611.49 rows=635 width=418) (actual time=3.794..23.495 rows=16,028 loops=1)

  • Hash Cond: (project0_.id = leadusers15_.project_id)
20. 3.908 14.264 ↓ 7.0 4,466 1

Hash Left Join (cost=420.46..593.89 rows=635 width=410) (actual time=3.696..14.264 rows=4,466 loops=1)

  • Hash Cond: (programs7_.program_id = program8_.id)
  • Filter: ((project0_.author_id = 314) OR (leadusers1_.user_id = 314) OR (user3_.id = 314) OR (user6_.id = 314) OR (user10_.id = 314) OR (user14_.id = 314) OR (NOT project0_.ultra))
  • Rows Removed by Filter: 40
21. 5.128 10.101 ↓ 7.1 4,146 1

Hash Right Join (cost=254.56..409.42 rows=587 width=450) (actual time=3.435..10.101 rows=4,146 loops=1)

  • Hash Cond: (scopings11_.project_id = project0_.id)
22. 0.161 1.909 ↑ 1.0 176 1

Hash Right Join (cost=20.49..169.84 rows=178 width=16) (actual time=0.365..1.909 rows=176 loops=1)

  • Hash Cond: (teammanage13_.team_id = team12_.id)
23. 0.496 1.498 ↑ 1.0 144 1

Merge Right Join (cost=7.88..154.91 rows=144 width=16) (actual time=0.108..1.498 rows=144 loops=1)

  • Merge Cond: (user14_.id = teammanage13_.user_id)
24. 0.853 0.853 ↑ 1.2 2,896 1

Index Only Scan using users_pkey on users user14_ (cost=0.28..237.83 rows=3,351 width=8) (actual time=0.008..0.853 rows=2,896 loops=1)

  • Heap Fetches: 585
25. 0.101 0.149 ↑ 1.0 144 1

Sort (cost=7.60..7.96 rows=144 width=16) (actual time=0.097..0.149 rows=144 loops=1)

  • Sort Key: teammanage13_.user_id
  • Sort Method: quicksort Memory: 31kB
26. 0.048 0.048 ↑ 1.0 144 1

Seq Scan on user_manages_team teammanage13_ (cost=0.00..2.44 rows=144 width=16) (actual time=0.010..0.048 rows=144 loops=1)

27. 0.049 0.250 ↑ 1.0 176 1

Hash (cost=10.41..10.41 rows=176 width=16) (actual time=0.250..0.250 rows=176 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
28. 0.065 0.201 ↑ 1.0 176 1

Hash Left Join (cost=6.17..10.41 rows=176 width=16) (actual time=0.100..0.201 rows=176 loops=1)

  • Hash Cond: (scopings11_.team_id = team12_.id)
29. 0.049 0.049 ↑ 1.0 176 1

Seq Scan on scopings scopings11_ (cost=0.00..3.76 rows=176 width=16) (actual time=0.009..0.049 rows=176 loops=1)

30. 0.047 0.087 ↓ 1.0 144 1

Hash (cost=4.41..4.41 rows=141 width=8) (actual time=0.087..0.087 rows=144 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
31. 0.040 0.040 ↓ 1.0 144 1

Seq Scan on teams team12_ (cost=0.00..4.41 rows=141 width=8) (actual time=0.006..0.040 rows=144 loops=1)

32. 1.056 3.064 ↓ 1.9 1,082 1

Hash (cost=226.83..226.83 rows=579 width=442) (actual time=3.064..3.064 rows=1,082 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 314kB
33. 0.548 2.008 ↓ 1.9 1,082 1

Hash Left Join (cost=211.94..226.83 rows=579 width=442) (actual time=0.824..2.008 rows=1,082 loops=1)

  • Hash Cond: (project0_.primary_area_id = area4_.id)
34. 0.199 1.155 ↓ 1.7 368 1

Hash Left Join (cost=38.42..46.41 rows=212 width=434) (actual time=0.514..1.155 rows=368 loops=1)

  • Hash Cond: (project0_.id = programs7_.project_id)
35. 0.151 0.922 ↓ 1.5 313 1

Hash Left Join (cost=35.75..40.96 rows=212 width=426) (actual time=0.475..0.922 rows=313 loops=1)

  • Hash Cond: (project0_.id = sponsors2_.project_id)
36. 0.290 0.737 ↓ 1.5 313 1

Hash Right Join (cost=13.47..17.84 rows=212 width=418) (actual time=0.435..0.737 rows=313 loops=1)

  • Hash Cond: (leadusers1_.project_id = project0_.id)
37. 0.027 0.027 ↑ 1.0 187 1

Seq Scan on projects_leads leadusers1_ (cost=0.00..3.87 rows=187 width=16) (actual time=0.008..0.027 rows=187 loops=1)

38. 0.191 0.420 ↑ 1.0 212 1

Hash (cost=10.82..10.82 rows=212 width=410) (actual time=0.420..0.420 rows=212 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 58kB
39. 0.229 0.229 ↑ 1.0 212 1

Seq Scan on projects project0_ (cost=0.00..10.82 rows=212 width=410) (actual time=0.023..0.229 rows=212 loops=1)

  • Filter: ((domain_id = 2) AND ((state)::text = ANY ('{PLANNED,ROADMAPED,NOMINATED}'::text[])))
  • Rows Removed by Filter: 23
40. 0.002 0.034 ↑ 1.0 4 1

Hash (cost=22.23..22.23 rows=4 width=16) (actual time=0.034..0.034 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
41. 0.004 0.032 ↑ 1.0 4 1

Nested Loop Left Join (cost=0.28..22.23 rows=4 width=16) (actual time=0.018..0.032 rows=4 loops=1)

42. 0.008 0.008 ↑ 1.0 4 1

Seq Scan on user_sponsors_project sponsors2_ (cost=0.00..1.04 rows=4 width=16) (actual time=0.006..0.008 rows=4 loops=1)

43. 0.020 0.020 ↑ 1.0 1 4

Index Only Scan using users_pkey on users user3_ (cost=0.28..5.30 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=4)

  • Index Cond: (id = sponsors2_.user_id)
  • Heap Fetches: 2
44. 0.020 0.034 ↑ 1.0 74 1

Hash (cost=1.74..1.74 rows=74 width=16) (actual time=0.034..0.034 rows=74 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
45. 0.014 0.014 ↑ 1.0 74 1

Seq Scan on projects_programs programs7_ (cost=0.00..1.74 rows=74 width=16) (actual time=0.007..0.014 rows=74 loops=1)

46. 0.015 0.305 ↑ 1.0 71 1

Hash (cost=172.64..172.64 rows=71 width=16) (actual time=0.305..0.305 rows=71 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
47. 0.063 0.290 ↑ 1.0 71 1

Nested Loop Left Join (cost=1.86..172.64 rows=71 width=16) (actual time=0.036..0.290 rows=71 loops=1)

48. 0.048 0.085 ↑ 1.0 71 1

Hash Right Join (cost=1.58..3.51 rows=71 width=16) (actual time=0.029..0.085 rows=71 loops=1)

  • Hash Cond: (areaowners5_.area_id = area4_.id)
49. 0.018 0.018 ↑ 1.0 71 1

Seq Scan on user_manages_area areaowners5_ (cost=0.00..1.71 rows=71 width=16) (actual time=0.006..0.018 rows=71 loops=1)

50. 0.009 0.019 ↑ 1.0 26 1

Hash (cost=1.26..1.26 rows=26 width=8) (actual time=0.019..0.019 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
51. 0.010 0.010 ↑ 1.0 26 1

Seq Scan on areas area4_ (cost=0.00..1.26 rows=26 width=8) (actual time=0.007..0.010 rows=26 loops=1)

52. 0.142 0.142 ↑ 1.0 1 71

Index Only Scan using users_pkey on users user6_ (cost=0.28..2.38 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=71)

  • Index Cond: (id = areaowners5_.user_id)
  • Heap Fetches: 45
53. 0.012 0.255 ↑ 1.0 58 1

Hash (cost=165.17..165.17 rows=58 width=16) (actual time=0.255..0.255 rows=58 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
54. 0.044 0.243 ↑ 1.0 58 1

Nested Loop Left Join (cost=2.45..165.17 rows=58 width=16) (actual time=0.047..0.243 rows=58 loops=1)

55. 0.037 0.083 ↑ 1.0 58 1

Hash Right Join (cost=2.17..3.91 rows=58 width=16) (actual time=0.042..0.083 rows=58 loops=1)

  • Hash Cond: (programman9_.program_id = program8_.id)
56. 0.015 0.015 ↑ 1.0 58 1

Seq Scan on programs_managers programman9_ (cost=0.00..1.58 rows=58 width=16) (actual time=0.006..0.015 rows=58 loops=1)

57. 0.014 0.031 ↑ 1.0 52 1

Hash (cost=1.52..1.52 rows=52 width=8) (actual time=0.031..0.031 rows=52 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
58. 0.017 0.017 ↑ 1.0 52 1

Seq Scan on programs program8_ (cost=0.00..1.52 rows=52 width=8) (actual time=0.008..0.017 rows=52 loops=1)

59. 0.116 0.116 ↑ 1.0 1 58

Index Only Scan using users_pkey on users user10_ (cost=0.28..2.78 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=58)

  • Index Cond: (id = programman9_.user_id)
  • Heap Fetches: 16
60. 0.054 0.093 ↑ 1.0 187 1

Hash (cost=3.87..3.87 rows=187 width=16) (actual time=0.093..0.093 rows=187 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
61. 0.039 0.039 ↑ 1.0 187 1

Seq Scan on projects_leads leadusers15_ (cost=0.00..3.87 rows=187 width=16) (actual time=0.006..0.039 rows=187 loops=1)

62. 0.022 0.318 ↑ 1.0 81 1

Hash (cost=169.82..169.82 rows=83 width=16) (actual time=0.318..0.318 rows=81 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
63. 0.048 0.296 ↑ 1.0 81 1

Hash Right Join (cost=5.12..169.82 rows=83 width=16) (actual time=0.079..0.296 rows=81 loops=1)

  • Hash Cond: (program17_.id = programs16_.program_id)
64. 0.029 0.217 ↑ 1.0 58 1

Nested Loop Left Join (cost=2.45..165.17 rows=58 width=16) (actual time=0.043..0.217 rows=58 loops=1)

65. 0.029 0.072 ↑ 1.0 58 1

Hash Right Join (cost=2.17..3.91 rows=58 width=16) (actual time=0.038..0.072 rows=58 loops=1)

  • Hash Cond: (programman18_.program_id = program17_.id)
66. 0.014 0.014 ↑ 1.0 58 1

Seq Scan on programs_managers programman18_ (cost=0.00..1.58 rows=58 width=16) (actual time=0.005..0.014 rows=58 loops=1)

67. 0.012 0.029 ↑ 1.0 52 1

Hash (cost=1.52..1.52 rows=52 width=8) (actual time=0.029..0.029 rows=52 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
68. 0.017 0.017 ↑ 1.0 52 1

Seq Scan on programs program17_ (cost=0.00..1.52 rows=52 width=8) (actual time=0.005..0.017 rows=52 loops=1)

69. 0.116 0.116 ↑ 1.0 1 58

Index Only Scan using users_pkey on users user19_ (cost=0.28..2.78 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=58)

  • Index Cond: (id = programman18_.user_id)
  • Heap Fetches: 16
70. 0.023 0.031 ↑ 1.0 74 1

Hash (cost=1.74..1.74 rows=74 width=16) (actual time=0.031..0.031 rows=74 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
71. 0.008 0.008 ↑ 1.0 74 1

Seq Scan on projects_programs programs16_ (cost=0.00..1.74 rows=74 width=16) (actual time=0.005..0.008 rows=74 loops=1)

72. 0.030 0.097 ↑ 1.0 71 1

Hash (cost=3.51..3.51 rows=71 width=16) (actual time=0.097..0.097 rows=71 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
73. 0.032 0.067 ↑ 1.0 71 1

Hash Right Join (cost=1.58..3.51 rows=71 width=16) (actual time=0.028..0.067 rows=71 loops=1)

  • Hash Cond: (areaowners21_.area_id = area20_.id)
74. 0.016 0.016 ↑ 1.0 71 1

Seq Scan on user_manages_area areaowners21_ (cost=0.00..1.71 rows=71 width=16) (actual time=0.004..0.016 rows=71 loops=1)

75. 0.006 0.019 ↑ 1.0 26 1

Hash (cost=1.26..1.26 rows=26 width=8) (actual time=0.019..0.019 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
76. 0.013 0.013 ↑ 1.0 26 1

Seq Scan on areas area20_ (cost=0.00..1.26 rows=26 width=8) (actual time=0.007..0.013 rows=26 loops=1)

77. 0.001 0.028 ↑ 1.0 4 1

Hash (cost=22.23..22.23 rows=4 width=16) (actual time=0.028..0.028 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
78. 0.005 0.027 ↑ 1.0 4 1

Nested Loop Left Join (cost=0.28..22.23 rows=4 width=16) (actual time=0.015..0.027 rows=4 loops=1)

79. 0.006 0.006 ↑ 1.0 4 1

Seq Scan on user_sponsors_project sponsors23_ (cost=0.00..1.04 rows=4 width=16) (actual time=0.004..0.006 rows=4 loops=1)

80. 0.016 0.016 ↑ 1.0 1 4

Index Only Scan using users_pkey on users user24_ (cost=0.28..5.30 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=4)

  • Index Cond: (id = sponsors23_.user_id)
  • Heap Fetches: 2
81. 0.860 1.655 ↑ 1.0 3,351 1

Hash (cost=143.51..143.51 rows=3,351 width=8) (actual time=1.655..1.655 rows=3,351 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 163kB
82. 0.795 0.795 ↑ 1.0 3,351 1

Seq Scan on users user22_ (cost=0.00..143.51 rows=3,351 width=8) (actual time=0.006..0.795 rows=3,351 loops=1)

83. 0.012 0.223 ↑ 1.0 39 1

Hash (cost=29.46..29.46 rows=39 width=16) (actual time=0.223..0.223 rows=39 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
84. 0.030 0.211 ↑ 1.0 39 1

Merge Right Join (cost=3.97..29.46 rows=39 width=16) (actual time=0.062..0.211 rows=39 loops=1)

  • Merge Cond: (resource30_.id = resourceal29_.resource_id)
85. 0.016 0.146 ↑ 14.0 36 1

Nested Loop Left Join (cost=0.55..369.09 rows=505 width=16) (actual time=0.026..0.146 rows=36 loops=1)

86. 0.022 0.022 ↑ 14.0 36 1

Index Scan using resources_pkey on resources resource30_ (cost=0.27..30.85 rows=505 width=16) (actual time=0.014..0.022 rows=36 loops=1)

87. 0.108 0.108 ↑ 1.0 1 36

Index Only Scan using users_pkey on users user31_ (cost=0.28..0.67 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=36)

  • Index Cond: (id = resource30_.user_id)
  • Heap Fetches: 18
88. 0.015 0.035 ↑ 1.0 39 1

Sort (cost=3.42..3.52 rows=39 width=16) (actual time=0.032..0.035 rows=39 loops=1)

  • Sort Key: resourceal29_.resource_id
  • Sort Method: quicksort Memory: 26kB
89. 0.020 0.020 ↑ 1.0 39 1

Seq Scan on resource_allocations resourceal29_ (cost=0.00..2.39 rows=39 width=16) (actual time=0.008..0.020 rows=39 loops=1)