Query Plan as raw text

Summary

Hash Join (cost=44.57..84.62 rows=10 width=34) Hash Cond: (f.id = r.id) -> Seq Scan on financials f (cost=0.00..35.60 rows=1160 width=12) -> Hash (cost=44.43..44.43 rows=11 width=30) -> Index Scan using studentfacultyratio_idx on rankings r (cost=0.00..44.43 rows=11 width=30) Index Cond: (studentfacultyratio < 3::double precision)

• To check the planner's accuracy, run [EXPLAIN ANALYZE].
• For more information on using EXPLAIN and interpreting its output, see the Postgres documentation, in particular the EXPLAIN and ANALYZE references pages, and Using Explain.

explain-analyze.info Version 0.2 © 2007, 2008 ·