uni=# explain
uni-# select s.sid,p.name
uni-# from Students s, People p where s.id=p.id;
                      QUERY PLAN
----------------------------------------------------------
 Hash Join (cost=988.58..3112.76 rows=31048 width=19)
           (actual time=11.504..39.478 rows=31048 loops=1)
   Hash Cond: (p.id = s.id)
   -> Seq Scan on people p
          (cost=0.00..989.97 rows=36497 width=19)
          (actual time=0.016..8.312 rows=36497 loops=1)
   -> Hash (cost=478.48..478.48 rows=31048 width=4)
           (actual time=10.532..10.532 rows=31048 loops=1)
           Buckets: 4096  Batches: 2  Memory Usage: 548kB
       ->  Seq Scan on students s 
               (cost=0.00..478.48 rows=31048 width=4)
               (actual time=0.005..4.630 rows=31048 loops=1)
Total runtime: 41.0 ms