explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yeeZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.170 50.517 ↑ 1.0 1 1

Aggregate (cost=7,034.00..7,034.01 rows=1 width=0) (actual time=50.516..50.517 rows=1 loops=1)

2. 0.505 50.347 ↓ 1.1 928 1

Hash Left Join (cost=3,379.00..7,031.82 rows=874 width=0) (actual time=47.737..50.347 rows=928 loops=1)

  • Hash Cond: (((hs_student_college.college_id)::text = (eligibilities.college_id)::text) AND ((hs_students.id)::text = (eligibilities.student_id)::text))
3. 0.889 49.702 ↓ 1.1 928 1

Hash Join (cost=3,329.38..6,958.16 rows=874 width=50) (actual time=47.585..49.702 rows=928 loops=1)

  • Hash Cond: ((hs_student_college.student_id)::text = (hs_students.id)::text)
4. 1.608 1.770 ↑ 1.1 932 1

Bitmap Heap Scan on hs_student_college (cost=36.28..3,652.58 rows=997 width=50) (actual time=0.270..1.770 rows=932 loops=1)

  • Recheck Cond: ((college_id)::text = '549900446e670ecd4e000160'::text)
  • Heap Blocks: exact=924
5. 0.162 0.162 ↑ 1.1 932 1

Bitmap Index Scan on hs_student_college_college_id (cost=0.00..36.03 rows=997 width=0) (actual time=0.162..0.162 rows=932 loops=1)

  • Index Cond: ((college_id)::text = '549900446e670ecd4e000160'::text)
6. 11.464 47.043 ↑ 1.0 33,092 1

Hash (cost=2,879.43..2,879.43 rows=33,094 width=25) (actual time=47.043..47.043 rows=33,092 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2355kB
7. 35.579 35.579 ↑ 1.0 33,092 1

Seq Scan on hs_students (cost=0.00..2,879.43 rows=33,094 width=25) (actual time=0.012..35.579 rows=33,092 loops=1)

  • Filter: ((country)::text = ANY ('{US,PW,MH,FM}'::text[]))
  • Rows Removed by Filter: 3
8. 0.010 0.140 ↓ 1.4 13 1

Hash (cost=49.48..49.48 rows=9 width=50) (actual time=0.140..0.140 rows=13 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
9. 0.016 0.130 ↓ 1.4 13 1

Hash Left Join (cost=17.30..49.48 rows=9 width=50) (actual time=0.105..0.130 rows=13 loops=1)

  • Hash Cond: ((eligibilities.program_id)::text = (scholarship_programs.scholarship_program_id)::text)
10. 0.024 0.050 ↓ 1.4 13 1

Bitmap Heap Scan on eligibilities (cost=4.48..36.59 rows=9 width=75) (actual time=0.032..0.050 rows=13 loops=1)

  • Recheck Cond: ((college_id)::text = '549900446e670ecd4e000160'::text)
  • Heap Blocks: exact=12
11. 0.026 0.026 ↓ 1.4 13 1

Bitmap Index Scan on eligibilities_college_student_program (cost=0.00..4.48 rows=9 width=0) (actual time=0.026..0.026 rows=13 loops=1)

  • Index Cond: ((college_id)::text = '549900446e670ecd4e000160'::text)
12. 0.033 0.064 ↑ 1.0 81 1

Hash (cost=11.81..11.81 rows=81 width=25) (actual time=0.064..0.064 rows=81 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
13. 0.031 0.031 ↑ 1.0 81 1

Seq Scan on scholarship_programs (cost=0.00..11.81 rows=81 width=25) (actual time=0.002..0.031 rows=81 loops=1)