Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Apr 23rd, 2012  |  syntax: None  |  size: 0.59 KB  |  hits: 15  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Hash Join  (cost=9038.99..1960768.62 rows=27239 width=4) (actual time=20299.675..50348.400 rows=13572 loops=1)
  2.   Hash Cond: (o.contig_id = c.id)
  3.   ->  Seq Scan on orfs o  (cost=0.00..1882041.86 rows=7933186 width=8) (actual time=0.028..42191.211 rows=7975597 loops=1)
  4.   ->  Hash  (cost=8979.15..8979.15 rows=4787 width=4) (actual time=1836.093..1836.093 rows=3989 loops=1)
  5.         ->  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)
  6.               Index Cond: (assembly_id = 505)
  7. Total runtime: 50357.673 ms
create a new version of this paste RAW Paste Data