"Hash Join  (cost=49771.10..88028.96 rows=2403 width=32) (actual time=1052.358..1256.355 rows=53495 loops=1)"
"  Hash Cond: ((production.company.name)::text = (s2.name)::text)"
"  ->  Nested Loop  (cost=1183.27..39219.67 rows=52648 width=30) (actual time=1.903..71.109 rows=15507 loops=1)"
"        ->  HashAggregate  (cost=1.55..1.56 rows=1 width=8) (actual time=0.029..0.032 rows=1 loops=1)"
"              ->  Seq Scan on run  (cost=0.00..1.55 rows=1 width=8) (actual time=0.019..0.021 rows=1 loops=1)"
"                    Filter: ((name)::text = 'test'::text)"
"        ->  Bitmap Heap Scan on company  (cost=1181.72..38435.51 rows=62608 width=30) (actual time=1.867..26.079 rows=15507 loops=1)"
"              Recheck Cond: ((production.company.run_id)::bigint = production.run.id)"
"              ->  Bitmap Index Scan on comp_run  (cost=0.00..1166.07 rows=62608 width=0) (actual time=1.780..1.780 rows=15507 loops=1)"
"                    Index Cond: ((production.company.run_id)::bigint = production.run.id)"
"  ->  Hash  (cost=48471.98..48471.98 rows=9268 width=44) (actual time=1050.273..1050.273 rows=45091 loops=1)"
"        ->  Hash Join  (cost=8826.52..48471.98 rows=9268 width=44) (actual time=761.377..959.409 rows=45091 loops=1)"
"              Hash Cond: ((production.company.name)::text = ((s1.name)::text))"
"              ->  Nested Loop  (cost=1183.27..39376.19 rows=52648 width=30) (actual time=1.767..71.797 rows=15507 loops=1)"
"                    ->  HashAggregate  (cost=1.55..1.56 rows=1 width=8) (actual time=0.015..0.018 rows=1 loops=1)"
"                          ->  Seq Scan on run  (cost=0.00..1.55 rows=1 width=8) (actual time=0.008..0.009 rows=1 loops=1)"
"                                Filter: ((name)::text = 'test'::text)"
"                    ->  Bitmap Heap Scan on company  (cost=1181.72..38592.03 rows=62608 width=30) (actual time=1.746..29.069 rows=15507 loops=1)"
"                          Recheck Cond: ((production.company.run_id)::bigint = production.run.id)"
"                          Filter: ((production.company.status)::text = 'unprocessed'::text)"
"                          ->  Bitmap Index Scan on comp_run  (cost=0.00..1166.07 rows=62608 width=0) (actual time=1.662..1.662 rows=15507 loops=1)"
"                                Index Cond: ((production.company.run_id)::bigint = production.run.id)"
"              ->  Hash  (cost=6951.43..6951.43 rows=35745 width=28) (actual time=759.420..759.420 rows=35745 loops=1)"
"                    ->  Unique  (cost=6683.34..6951.43 rows=35745 width=28) (actual time=524.617..693.365 rows=35745 loops=1)"
"                          ->  Sort  (cost=6683.34..6772.71 rows=35745 width=28) (actual time=524.614..593.649 rows=35745 loops=1)"
"                                Sort Key: ((s1.name)::text), ((s2.name)::text)"
"                                Sort Method:  external merge  Disk: 2064kB"
"                                ->  Hash Join  (cost=928.57..3122.55 rows=35745 width=28) (actual time=91.540..380.449 rows=35745 loops=1)"
"                                      Hash Cond: ((atom_match.atom1_id)::integer = s1.id)"
"                                      ->  Hash Join  (cost=445.80..1880.19 rows=35745 width=18) (actual time=45.322..215.477 rows=35745 loops=1)"
"                                            Hash Cond: ((atom_match.atom2_id)::integer = s2.id)"
"                                            ->  Seq Scan on atom_match  (cost=0.00..674.81 rows=35745 width=8) (actual time=0.006..56.541 rows=35745 loops=1)"
"                                                  Filter: ((match_function_id)::integer = 2)"
"                                            ->  Hash  (cost=260.91..260.91 rows=14791 width=18) (actual time=45.304..45.304 rows=14791 loops=1)"
"                                                  ->  Seq Scan on atoms_string s2  (cost=0.00..260.91 rows=14791 width=18) (actual time=0.004..21.717 rows=14791 loops=1)"
"                                      ->  Hash  (cost=297.89..297.89 rows=14791 width=18) (actual time=46.203..46.203 rows=14791 loops=1)"
"                                            ->  Seq Scan on atoms_string s1  (cost=0.00..297.89 rows=14791 width=18) (actual time=0.007..22.026 rows=14791 loops=1)"
"                                                  Filter: ((atom_type_id)::integer = (-1))"
"Total runtime: 1332.827 ms"