explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UOZP : Optimization for: Optimization for: plan #cw0W; plan #uAB4

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 18,550.163 27,121.605 ↑ 8.3 209 1

HashAggregate (cost=1,926.48..1,943.75 rows=1,727 width=410) (actual time=27,121.336..27,121.605 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,881.386 8,571.442 ↓ 2,643.3 4,565,030 1

Hash Left Join (cost=1,565.88..1,775.36 rows=1,727 width=410) (actual time=640.505..8,571.442 rows=4,565,030 loops=1)

  • Hash Cond: (resource30_.user_id = user31_.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,405.920 5,688.480 ↓ 2,334.5 4,575,574 1

Hash Left Join (cost=1,380.48..1,584.47 rows=1,960 width=458) (actual time=638.919..5,688.480 rows=4,575,574 loops=1)

  • Hash Cond: (project0_.id = resourceal29_.project_id)
4. 2,642.749 3,282.465 ↓ 1,194.0 2,340,186 1

Hash Right Join (cost=1,373.57..1,540.01 rows=1,960 width=450) (actual time=638.804..3,282.465 rows=2,340,186 loops=1)

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

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

  • Hash Cond: (teammanage27_.team_id = team26_.id)
6. 0.362 1.085 ↑ 1.0 144 1

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

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

  • Heap Fetches: 585
8. 0.066 0.112 ↑ 1.0 144 1

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

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

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

10. 0.050 0.237 ↑ 1.0 176 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
11. 0.070 0.187 ↑ 1.0 176 1

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

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

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

13. 0.041 0.076 ↓ 1.0 144 1

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

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

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

15. 319.343 638.296 ↓ 83.4 161,262 1

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

  • Buckets: 16384 (originally 2048) Batches: 256 (originally 1) Memory Usage: 31775kB
16. 100.781 318.953 ↓ 83.4 161,262 1

Hash Left Join (cost=1,099.03..1,328.92 rows=1,933 width=442) (actual time=11.256..318.953 rows=161,262 loops=1)

  • Hash Cond: (areaowners21_.user_id = user22_.id)
17. 85.215 216.507 ↓ 83.4 161,262 1

Hash Left Join (cost=913.63..1,138.44 rows=1,933 width=442) (actual time=9.584..216.507 rows=161,262 loops=1)

  • Hash Cond: (project0_.id = sponsors23_.project_id)
18. 80.010 130.089 ↓ 83.4 161,262 1

Hash Left Join (cost=756.37..973.60 rows=1,933 width=434) (actual time=8.356..130.089 rows=161,262 loops=1)

  • Hash Cond: (project0_.primary_area_id = area20_.id)
19. 22.413 49.952 ↓ 58.2 41,236 1

Hash Left Join (cost=751.97..946.19 rows=708 width=426) (actual time=8.201..49.952 rows=41,236 loops=1)

  • Hash Cond: (project0_.id = programs16_.project_id)
20. 8.821 26.141 ↓ 25.2 16,028 1

Hash Left Join (cost=576.61..761.44 rows=635 width=418) (actual time=6.798..26.141 rows=16,028 loops=1)

  • Hash Cond: (project0_.id = leadusers15_.project_id)
21. 4.125 17.220 ↓ 7.0 4,466 1

Hash Left Join (cost=570.40..743.83 rows=635 width=410) (actual time=6.691..17.220 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
22. 4.903 11.802 ↓ 7.1 4,146 1

Hash Right Join (cost=400.00..554.86 rows=587 width=450) (actual time=5.391..11.802 rows=4,146 loops=1)

  • Hash Cond: (scopings11_.project_id = project0_.id)
23. 0.165 1.861 ↑ 1.0 176 1

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

  • Hash Cond: (teammanage13_.team_id = team12_.id)
24. 0.506 1.456 ↑ 1.0 144 1

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

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

  • Heap Fetches: 585
26. 0.109 0.140 ↑ 1.0 144 1

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

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

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

28. 0.045 0.240 ↑ 1.0 176 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
29. 0.073 0.195 ↑ 1.0 176 1

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

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

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

31. 0.040 0.077 ↓ 1.0 144 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
32. 0.037 0.037 ↓ 1.0 144 1

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

33. 1.067 5.038 ↓ 1.9 1,082 1

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

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 314kB
34. 0.550 3.971 ↓ 1.9 1,082 1

Hash Left Join (cost=357.38..372.28 rows=579 width=442) (actual time=2.750..3.971 rows=1,082 loops=1)

  • Hash Cond: (project0_.primary_area_id = area4_.id)
35. 0.216 2.498 ↓ 1.7 368 1

Hash Left Join (cost=173.39..181.39 rows=212 width=434) (actual time=1.821..2.498 rows=368 loops=1)

  • Hash Cond: (project0_.id = programs7_.project_id)
36. 0.167 2.248 ↓ 1.5 313 1

Hash Left Join (cost=170.72..175.93 rows=212 width=426) (actual time=1.780..2.248 rows=313 loops=1)

  • Hash Cond: (project0_.id = sponsors2_.project_id)
37. 0.297 0.791 ↓ 1.5 313 1

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

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

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

39. 0.217 0.466 ↑ 1.0 212 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 58kB
40. 0.249 0.249 ↑ 1.0 212 1

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

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

Hash (cost=157.21..157.21 rows=4 width=16) (actual time=1.290..1.290 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
42. 0.515 1.286 ↑ 1.0 4 1

Hash Right Join (cost=1.09..157.21 rows=4 width=16) (actual time=0.421..1.286 rows=4 loops=1)

  • Hash Cond: (user3_.id = sponsors2_.user_id)
43. 0.763 0.763 ↑ 1.0 3,351 1

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

44. 0.002 0.008 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=16) (actual time=0.008..0.008 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
45. 0.006 0.006 ↑ 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.006 rows=4 loops=1)

46. 0.019 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
47. 0.015 0.015 ↑ 1.0 74 1

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

48. 0.020 0.923 ↑ 1.0 71 1

Hash (cost=183.11..183.11 rows=71 width=16) (actual time=0.923..0.923 rows=71 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
49. 0.041 0.903 ↑ 1.0 71 1

Hash Right Join (cost=5.83..183.11 rows=71 width=16) (actual time=0.097..0.903 rows=71 loops=1)

  • Hash Cond: (areaowners5_.area_id = area4_.id)
50. 0.256 0.842 ↑ 1.0 71 1

Merge Right Join (cost=4.25..181.30 rows=71 width=16) (actual time=0.073..0.842 rows=71 loops=1)

  • Merge Cond: (user6_.id = areaowners5_.user_id)
51. 0.528 0.528 ↑ 1.4 2,386 1

Index Only Scan using users_pkey on users user6_ (cost=0.28..237.83 rows=3,351 width=8) (actual time=0.017..0.528 rows=2,386 loops=1)

  • Heap Fetches: 535
52. 0.037 0.058 ↑ 1.0 71 1

Sort (cost=3.89..4.07 rows=71 width=16) (actual time=0.052..0.058 rows=71 loops=1)

  • Sort Key: areaowners5_.user_id
  • Sort Method: quicksort Memory: 28kB
53. 0.021 0.021 ↑ 1.0 71 1

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

54. 0.007 0.020 ↑ 1.0 26 1

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

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

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

56. 0.018 1.293 ↑ 1.0 58 1

Hash (cost=169.67..169.67 rows=58 width=16) (actual time=1.293..1.293 rows=58 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
57. 0.030 1.275 ↑ 1.0 58 1

Hash Right Join (cost=4.48..169.67 rows=58 width=16) (actual time=0.087..1.275 rows=58 loops=1)

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

Hash Right Join (cost=2.31..167.34 rows=58 width=16) (actual time=0.040..1.203 rows=58 loops=1)

  • Hash Cond: (user10_.id = programman9_.user_id)
59. 0.645 0.645 ↑ 1.0 3,351 1

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

60. 0.016 0.030 ↑ 1.0 58 1

Hash (cost=1.58..1.58 rows=58 width=16) (actual time=0.030..0.030 rows=58 loops=1)

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

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

62. 0.024 0.042 ↑ 1.0 52 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
63. 0.018 0.018 ↑ 1.0 52 1

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

64. 0.057 0.100 ↑ 1.0 187 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
65. 0.043 0.043 ↑ 1.0 187 1

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

66. 0.043 1.398 ↑ 1.0 81 1

Hash (cost=174.33..174.33 rows=83 width=16) (actual time=1.398..1.398 rows=81 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
67. 0.037 1.355 ↑ 1.0 81 1

Hash Right Join (cost=7.14..174.33 rows=83 width=16) (actual time=0.152..1.355 rows=81 loops=1)

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

Hash Right Join (cost=4.48..169.67 rows=58 width=16) (actual time=0.115..1.286 rows=58 loops=1)

  • Hash Cond: (programman18_.program_id = program17_.id)
69. 0.566 1.215 ↑ 1.0 58 1

Hash Right Join (cost=2.31..167.34 rows=58 width=16) (actual time=0.068..1.215 rows=58 loops=1)

  • Hash Cond: (user19_.id = programman18_.user_id)
70. 0.616 0.616 ↑ 1.0 3,351 1

Seq Scan on users user19_ (cost=0.00..143.51 rows=3,351 width=8) (actual time=0.007..0.616 rows=3,351 loops=1)

71. 0.023 0.033 ↑ 1.0 58 1

Hash (cost=1.58..1.58 rows=58 width=16) (actual time=0.033..0.033 rows=58 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
72. 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.006..0.010 rows=58 loops=1)

73. 0.033 0.042 ↑ 1.0 52 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
74. 0.009 0.009 ↑ 1.0 52 1

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

75. 0.019 0.032 ↑ 1.0 74 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
76. 0.013 0.013 ↑ 1.0 74 1

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

77. 0.035 0.127 ↑ 1.0 71 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
78. 0.054 0.092 ↑ 1.0 71 1

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

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

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

80. 0.012 0.025 ↑ 1.0 26 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
81. 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.006..0.013 rows=26 loops=1)

82. 0.002 1.203 ↑ 1.0 4 1

Hash (cost=157.21..157.21 rows=4 width=16) (actual time=1.203..1.203 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
83. 0.551 1.201 ↑ 1.0 4 1

Hash Right Join (cost=1.09..157.21 rows=4 width=16) (actual time=0.363..1.201 rows=4 loops=1)

  • Hash Cond: (user24_.id = sponsors23_.user_id)
84. 0.643 0.643 ↑ 1.0 3,351 1

Seq Scan on users user24_ (cost=0.00..143.51 rows=3,351 width=8) (actual time=0.003..0.643 rows=3,351 loops=1)

85. 0.001 0.007 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=16) (actual time=0.007..0.007 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
86. 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.005..0.006 rows=4 loops=1)

87. 0.911 1.665 ↑ 1.0 3,351 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 163kB
88. 0.754 0.754 ↑ 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.754 rows=3,351 loops=1)

89. 0.007 0.095 ↑ 1.0 39 1

Hash (cost=6.42..6.42 rows=39 width=16) (actual time=0.095..0.095 rows=39 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
90. 0.028 0.088 ↑ 1.0 39 1

Merge Right Join (cost=3.69..6.42 rows=39 width=16) (actual time=0.049..0.088 rows=39 loops=1)

  • Merge Cond: (resource30_.id = resourceal29_.resource_id)
91. 0.025 0.025 ↑ 14.0 36 1

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

92. 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
93. 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.007..0.020 rows=39 loops=1)

94. 0.787 1.576 ↑ 1.0 3,351 1

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

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

Seq Scan on users user31_ (cost=0.00..143.51 rows=3,351 width=8) (actual time=0.007..0.789 rows=3,351 loops=1)