Hash Join  (cost=9038.99..1960768.62 rows=27239 width=4) (actual time=20299.675..50348.400 rows=13572 loops=1)
  Hash Cond: (o.contig_id = c.id)
  ->  Seq Scan on orfs o  (cost=0.00..1882041.86 rows=7933186 width=8) (actual time=0.028..42191.211 rows=7975597 loops=1)
  ->  Hash  (cost=8979.15..8979.15 rows=4787 width=4) (actual time=1836.093..1836.093 rows=3989 loops=1)
        ->  Index Scan using index_contigs_on_assembly_id on contigs c  (cost=0.00..8979.15 rows=4787 width=4) (actual time=749.715..1831.232 rows=3989 loops=1)
              Index Cond: (assembly_id = 505)
Total runtime: 50357.673 ms