query-plan-1176

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
1.825 100.00%
 Hash Join (cost=44.57..84.62 rows=10 width=34) (actual time=1.234..1.825 rows=2 loops=1)
   Hash Cond: (f.id = r.id)
0.914 50.08%
   -> Seq Scan on financials f (cost=0.0..35.6 rows=1160 width=12) (actual time=0.024..0.914 rows=1160 loops=1)
0.050 2.74%
   -> Hash (cost=44.43..44.43 rows=11 width=30) (actual time=0.050..0.050 rows=3 loops=1)
0.038 2.08%
         -> Index Scan using studentfacultyratio_idx on rankings r (cost=0.0..44.43 rows=11 width=30) (actual time=0.025..0.038 rows=3 loops=1)
               Index Cond: (studentfacultyratio < 3::double precision)
Run-time
0.013992 seconds (13.992 ms)