explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WD7Y

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 19,149.058 25,370.834 ↑ 8.3 209 1

HashAggregate (cost=1,580.10..1,597.37 rows=1,727 width=410) (actual time=25,370.555..25,370.834 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,793.861 6,221.776 ↓ 2,643.3 4,565,030 1

Hash Left Join (cost=1,114.09..1,428.99 rows=1,727 width=410) (actual time=640.657..6,221.776 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,786.410 3,427.696 ↓ 1,194.0 2,340,186 1

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

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

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

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

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

  • Merge Cond: (user28_.id = teammanage27_.user_id)
6. 0.605 0.605 ↑ 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.013..0.605 rows=2,896 loops=1)

  • Heap Fetches: 586
7. 0.071 0.096 ↑ 1.0 144 1

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

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

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

9. 0.053 0.242 ↑ 1.0 176 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
10. 0.061 0.189 ↑ 1.0 176 1

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

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

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

12. 0.036 0.078 ↓ 1.0 144 1

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

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

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

14. 320.949 639.924 ↓ 83.4 161,262 1

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

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

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

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

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

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

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

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

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

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

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

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

Hash Left Join (cost=420.46..593.89 rows=635 width=410) (actual time=4.896..15.881 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.155 11.488 ↓ 7.1 4,146 1

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

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

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

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

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

  • Merge Cond: (user14_.id = teammanage13_.user_id)
24. 1.047 1.047 ↑ 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.019..1.047 rows=2,896 loops=1)

  • Heap Fetches: 597
25. 0.111 0.147 ↑ 1.0 144 1

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

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

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

27. 0.056 0.276 ↑ 1.0 176 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
28. 0.071 0.220 ↑ 1.0 176 1

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

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

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

30. 0.038 0.088 ↓ 1.0 144 1

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

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

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

32. 1.360 4.126 ↓ 1.9 1,082 1

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

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

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

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

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

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

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

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

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

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

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

38. 0.247 0.602 ↑ 1.0 212 1

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

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
41. 0.006 0.151 ↑ 1.0 4 1

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

42. 0.017 0.017 ↑ 1.0 4 1

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

43. 0.128 0.128 ↑ 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.032..0.032 rows=1 loops=4)

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

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

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

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

46. 0.038 0.565 ↑ 1.0 71 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
47. 0.081 0.527 ↑ 1.0 71 1

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

48. 0.044 0.091 ↑ 1.0 71 1

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

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

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

50. 0.012 0.032 ↑ 1.0 26 1

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

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

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

52. 0.355 0.355 ↑ 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.005..0.005 rows=1 loops=71)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
54. 0.014 0.304 ↑ 1.0 58 1

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

55. 0.031 0.116 ↑ 1.0 58 1

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

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

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

57. 0.026 0.066 ↑ 1.0 52 1

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

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

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

59. 0.174 0.174 ↑ 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.003..0.003 rows=1 loops=58)

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

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

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

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

62. 0.032 0.353 ↑ 1.0 81 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
63. 0.044 0.321 ↑ 1.0 81 1

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

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

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

65. 0.040 0.082 ↑ 1.0 58 1

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

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

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

67. 0.020 0.032 ↑ 1.0 52 1

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

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

Seq Scan on programs program17_ (cost=0.00..1.52 rows=52 width=8) (actual time=0.005..0.012 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.018 0.038 ↑ 1.0 74 1

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

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

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

72. 0.022 0.100 ↑ 1.0 71 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
73. 0.049 0.078 ↑ 1.0 71 1

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

  • Hash Cond: (areaowners21_.area_id = area20_.id)
74. 0.008 0.008 ↑ 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.008 rows=71 loops=1)

75. 0.012 0.021 ↑ 1.0 26 1

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

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

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

77. 0.004 0.040 ↑ 1.0 4 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
78. 0.009 0.036 ↑ 1.0 4 1

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

79. 0.003 0.003 ↑ 1.0 4 1

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

80. 0.024 0.024 ↑ 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.006..0.006 rows=1 loops=4)

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

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

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

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

83. 0.014 0.219 ↑ 1.0 39 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
84. 0.027 0.205 ↑ 1.0 39 1

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

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

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

86. 0.024 0.024 ↑ 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.024 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.014 0.033 ↑ 1.0 39 1

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

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

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