explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cw0W

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 18,977.441 30,765.569 ↑ 8.1 209 1

HashAggregate (cost=1,396.67..1,413.51 rows=1,684 width=410) (actual time=30,765.261..30,765.569 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. 3,073.002 11,788.128 ↓ 2,710.8 4,565,030 1

Hash Left Join (cost=1,068.16..1,249.32 rows=1,684 width=410) (actual time=527.698..11,788.128 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,563.933 8,713.880 ↓ 2,396.8 4,575,574 1

Hash Left Join (cost=893.09..1,068.88 rows=1,909 width=458) (actual time=526.443..8,713.880 rows=4,575,574 loops=1)

  • Hash Cond: (project0_.id = resourceal29_.project_id)
4. 1,445.345 6,149.875 ↓ 1,225.9 2,340,186 1

Hash Left Join (cost=888.32..1,027.53 rows=1,909 width=450) (actual time=526.364..6,149.875 rows=2,340,186 loops=1)

  • Hash Cond: (areaowners21_.user_id = user22_.id)
5. 1,439.073 4,703.160 ↓ 1,225.9 2,340,186 1

Hash Left Join (cost=713.25..847.43 rows=1,909 width=450) (actual time=524.987..4,703.160 rows=2,340,186 loops=1)

  • Hash Cond: (project0_.id = sponsors23_.project_id)
6. 2,738.521 3,264.056 ↓ 1,225.9 2,340,186 1

Hash Right Join (cost=694.96..821.67 rows=1,909 width=442) (actual time=524.949..3,264.056 rows=2,340,186 loops=1)

  • Hash Cond: (scopings25_.project_id = project0_.id)
7. 0.106 1.074 ↑ 1.0 176 1

Hash Right Join (cost=20.33..130.32 rows=176 width=16) (actual time=0.362..1.074 rows=176 loops=1)

  • Hash Cond: (teammanage27_.team_id = team26_.id)
8. 0.274 0.729 ↑ 1.0 141 1

Merge Right Join (cost=7.72..115.42 rows=141 width=16) (actual time=0.106..0.729 rows=141 loops=1)

  • Merge Cond: (user28_.id = teammanage27_.user_id)
9. 0.343 0.343 ↑ 1.5 1,975 1

Index Only Scan using users_pkey on users user28_ (cost=0.28..147.66 rows=2,892 width=8) (actual time=0.012..0.343 rows=1,975 loops=1)

  • Heap Fetches: 7
10. 0.085 0.112 ↑ 1.0 141 1

Sort (cost=7.44..7.80 rows=141 width=16) (actual time=0.090..0.112 rows=141 loops=1)

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

Seq Scan on user_manages_team teammanage27_ (cost=0.00..2.41 rows=141 width=16) (actual time=0.014..0.027 rows=141 loops=1)

12. 0.047 0.239 ↑ 1.0 176 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
13. 0.070 0.192 ↑ 1.0 176 1

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

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

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

15. 0.039 0.075 ↑ 1.0 141 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
16. 0.036 0.036 ↑ 1.0 141 1

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

17. 383.422 524.461 ↓ 84.5 161,262 1

Hash (cost=650.77..650.77 rows=1,909 width=434) (actual time=524.460..524.461 rows=161,262 loops=1)

  • Buckets: 16384 (originally 2048) Batches: 256 (originally 1) Memory Usage: 31388kB
18. 91.626 141.039 ↓ 84.5 161,262 1

Hash Left Join (cost=473.77..650.77 rows=1,909 width=434) (actual time=4.686..141.039 rows=161,262 loops=1)

  • Hash Cond: (project0_.primary_area_id = area20_.id)
19. 23.622 49.302 ↓ 59.0 41,236 1

Hash Left Join (cost=469.37..623.64 rows=699 width=426) (actual time=4.555..49.302 rows=41,236 loops=1)

  • Hash Cond: (project0_.id = programs16_.project_id)
20. 9.999 25.303 ↓ 25.6 16,028 1

Hash Left Join (cost=338.50..483.51 rows=627 width=418) (actual time=4.164..25.303 rows=16,028 loops=1)

  • Hash Cond: (project0_.id = leadusers15_.project_id)
21. 4.331 15.200 ↓ 7.1 4,466 1

Hash Left Join (cost=332.30..466.05 rows=627 width=410) (actual time=4.036..15.200 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. 5.636 10.592 ↓ 7.2 4,146 1

Hash Right Join (cost=206.40..321.83 rows=579 width=450) (actual time=3.746..10.592 rows=4,146 loops=1)

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

Hash Right Join (cost=20.33..130.32 rows=176 width=16) (actual time=0.456..1.673 rows=176 loops=1)

  • Hash Cond: (teammanage13_.team_id = team12_.id)
24. 0.406 1.124 ↑ 1.0 141 1

Merge Right Join (cost=7.72..115.42 rows=141 width=16) (actual time=0.124..1.124 rows=141 loops=1)

  • Merge Cond: (user14_.id = teammanage13_.user_id)
25. 0.535 0.535 ↑ 1.5 1,975 1

Index Only Scan using users_pkey on users user14_ (cost=0.28..147.66 rows=2,892 width=8) (actual time=0.018..0.535 rows=1,975 loops=1)

  • Heap Fetches: 7
26. 0.154 0.183 ↑ 1.0 141 1

Sort (cost=7.44..7.80 rows=141 width=16) (actual time=0.102..0.183 rows=141 loops=1)

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

Seq Scan on user_manages_team teammanage13_ (cost=0.00..2.41 rows=141 width=16) (actual time=0.008..0.029 rows=141 loops=1)

28. 0.057 0.316 ↑ 1.0 176 1

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

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

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

  • Hash Cond: (scopings11_.team_id = team12_.id)
30. 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.011..0.049 rows=176 loops=1)

31. 0.089 0.137 ↑ 1.0 141 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
32. 0.048 0.048 ↑ 1.0 141 1

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

33. 1.223 3.283 ↓ 1.9 1,082 1

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

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

Hash Left Join (cost=163.94..178.83 rows=579 width=442) (actual time=0.827..2.060 rows=1,082 loops=1)

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

Hash Left Join (cost=34.42..42.41 rows=212 width=434) (actual time=0.543..1.215 rows=368 loops=1)

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

Hash Left Join (cost=31.75..36.96 rows=212 width=426) (actual time=0.504..0.966 rows=313 loops=1)

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

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

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

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

39. 0.206 0.450 ↑ 1.0 212 1

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

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
42. 0.011 0.032 ↑ 1.0 4 1

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

43. 0.005 0.005 ↑ 1.0 4 1

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

44. 0.016 0.016 ↑ 1.0 1 4

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

  • Index Cond: (id = sponsors2_.user_id)
  • Heap Fetches: 0
45. 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
46. 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.006..0.015 rows=74 loops=1)

47. 0.026 0.279 ↑ 1.0 71 1

Hash (cost=128.64..128.64 rows=71 width=16) (actual time=0.279..0.279 rows=71 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
48. 0.036 0.253 ↑ 1.0 71 1

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

49. 0.041 0.075 ↑ 1.0 71 1

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

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

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

51. 0.007 0.018 ↑ 1.0 26 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
52. 0.011 0.011 ↑ 1.0 26 1

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

53. 0.142 0.142 ↑ 1.0 1 71

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

  • Index Cond: (id = areaowners5_.user_id)
  • Heap Fetches: 7
54. 0.032 0.277 ↑ 1.0 58 1

Hash (cost=125.17..125.17 rows=58 width=16) (actual time=0.277..0.277 rows=58 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
55. 0.050 0.245 ↑ 1.0 58 1

Nested Loop Left Join (cost=2.45..125.17 rows=58 width=16) (actual time=0.068..0.245 rows=58 loops=1)

56. 0.036 0.079 ↑ 1.0 58 1

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

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

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

58. 0.014 0.033 ↑ 1.0 52 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
59. 0.019 0.019 ↑ 1.0 52 1

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

60. 0.116 0.116 ↑ 1.0 1 58

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

  • Index Cond: (id = programman9_.user_id)
  • Heap Fetches: 3
61. 0.050 0.104 ↑ 1.0 187 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
62. 0.054 0.054 ↑ 1.0 187 1

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

63. 0.032 0.377 ↑ 1.0 81 1

Hash (cost=129.82..129.82 rows=83 width=16) (actual time=0.377..0.377 rows=81 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
64. 0.061 0.345 ↑ 1.0 81 1

Hash Right Join (cost=5.12..129.82 rows=83 width=16) (actual time=0.121..0.345 rows=81 loops=1)

  • Hash Cond: (program17_.id = programs16_.program_id)
65. 0.046 0.247 ↑ 1.0 58 1

Nested Loop Left Join (cost=2.45..125.17 rows=58 width=16) (actual time=0.061..0.247 rows=58 loops=1)

66. 0.039 0.085 ↑ 1.0 58 1

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

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

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

68. 0.018 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
69. 0.013 0.013 ↑ 1.0 52 1

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

70. 0.116 0.116 ↑ 1.0 1 58

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

  • Index Cond: (id = programman18_.user_id)
  • Heap Fetches: 3
71. 0.027 0.037 ↑ 1.0 74 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
72. 0.010 0.010 ↑ 1.0 74 1

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

73. 0.025 0.111 ↑ 1.0 71 1

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

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

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

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

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

76. 0.013 0.023 ↑ 1.0 26 1

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

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

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

78. 0.006 0.031 ↑ 1.0 4 1

Hash (cost=18.23..18.23 rows=4 width=16) (actual time=0.031..0.031 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
79. 0.006 0.025 ↑ 1.0 4 1

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

80. 0.007 0.007 ↑ 1.0 4 1

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

81. 0.012 0.012 ↑ 1.0 1 4

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

  • Index Cond: (id = sponsors23_.user_id)
  • Heap Fetches: 0
82. 0.671 1.370 ↑ 1.0 2,892 1

Hash (cost=138.92..138.92 rows=2,892 width=8) (actual time=1.370..1.370 rows=2,892 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 145kB
83. 0.699 0.699 ↑ 1.0 2,892 1

Seq Scan on users user22_ (cost=0.00..138.92 rows=2,892 width=8) (actual time=0.007..0.699 rows=2,892 loops=1)

84. 0.014 0.072 ↑ 1.0 39 1

Hash (cost=4.29..4.29 rows=39 width=16) (actual time=0.072..0.072 rows=39 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
85. 0.022 0.058 ↑ 1.0 39 1

Hash Left Join (cost=1.79..4.29 rows=39 width=16) (actual time=0.036..0.058 rows=39 loops=1)

  • Hash Cond: (resourceal29_.resource_id = resource30_.id)
86. 0.012 0.012 ↑ 1.0 39 1

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

87. 0.008 0.024 ↑ 1.0 35 1

Hash (cost=1.35..1.35 rows=35 width=16) (actual time=0.024..0.024 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
88. 0.016 0.016 ↑ 1.0 35 1

Seq Scan on resources resource30_ (cost=0.00..1.35 rows=35 width=16) (actual time=0.007..0.016 rows=35 loops=1)

89. 0.685 1.246 ↑ 1.0 2,892 1

Hash (cost=138.92..138.92 rows=2,892 width=8) (actual time=1.246..1.246 rows=2,892 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 145kB
90. 0.561 0.561 ↑ 1.0 2,892 1

Seq Scan on users user31_ (cost=0.00..138.92 rows=2,892 width=8) (actual time=0.004..0.561 rows=2,892 loops=1)