"Unique (cost=60853.14..61238.07 rows=38493 width=195)" " -> Sort (cost=60853.14..60949.37 rows=38493 width=195)" " Sort Key: s2.name, s1.name, s0.name" " -> Hash Join (cost=51349.05..54235.95 rows=38493 width=195)" " Hash Cond: (c5.individual = s0.id)" " -> Bitmap Heap Scan on conceptassertions c5 (cost=1341.13..3997.19 rows=61525 width=4)" " Recheck Cond: (concept = 576)" " -> Bitmap Index Scan on conceptassertions_concept_idx (cost=0.00..1325.75 rows=61525 width=0)" " Index Cond: (concept = 576)" " -> Hash (cost=50007.68..50007.68 rows=20 width=207)" " -> Nested Loop (cost=34886.95..50007.68 rows=20 width=207)" " Join Filter: (s1.id = c2.individual)" " -> Nested Loop (cost=34812.31..47917.51 rows=1 width=219)" " Join Filter: ((s0.id = r4.rhs) AND (s1.id = r4.lhs))" " -> Seq Scan on roleassertions r4 (cost=0.00..9976.73 rows=9342 width=8)" " Filter: (role = 712)" " -> Materialize (cost=34812.31..37613.82 rows=2 width=211)" " -> Hash Join (cost=34812.31..37613.81 rows=2 width=211)" " Hash Cond: (s2.id = c0.individual)" " -> Seq Scan on symbols s2 (cost=0.00..2289.32 rows=102432 width=69)" " -> Hash (cost=34812.28..34812.28 rows=2 width=158)" " -> Hash Join (cost=32010.78..34812.28 rows=2 width=158)" " Hash Cond: (s1.id = r1.rhs)" " -> Seq Scan on symbols s1 (cost=0.00..2289.32 rows=102432 width=69)" " -> Hash (cost=32010.76..32010.76 rows=2 width=89)" " -> Hash Join (cost=29209.26..32010.76 rows=2 width=89)" " Hash Cond: (s0.id = r3.rhs)" " -> Seq Scan on symbols s0 (cost=0.00..2289.32 rows=102432 width=69)" " -> Hash (cost=29209.23..29209.23 rows=2 width=20)" " -> Nested Loop (cost=16263.05..29209.23 rows=2 width=20)" " Join Filter: (fake_filter(r3.rhs, r1.rhs, c0.individual) AND (c0.individual = r3.lhs))" " -> Merge Join (cost=16263.05..16264.49 rows=11 width=12)" " Merge Cond: (c0.individual = r1.lhs)" " -> Sort (cost=3497.01..3497.52 rows=205 width=4)" " Sort Key: c0.individual" " -> Bitmap Heap Scan on conceptassertions c0 (cost=884.09..3489.14 rows=205 width=4)" " Recheck Cond: (concept = 352)" " Filter: ((individual & 4) = 4)" " -> Bitmap Index Scan on conceptassertions_concept_idx (cost=0.00..884.04 rows=41031 width=0)" " Index Cond: (concept = 352)" " -> Sort (cost=12765.86..12766.10 rows=98 width=8)" " Sort Key: r1.lhs" " -> Seq Scan on roleassertions r1 (cost=0.00..12762.62 rows=98 width=8)" " Filter: ((role = 696) AND ((rhs & 4) = 4))" " -> Materialize (cost=0.00..12767.29 rows=934 width=8)" " -> Seq Scan on roleassertions r3 (cost=0.00..12762.62 rows=934 width=8)" " Filter: ((role = 616) AND ((rhs & 4) = 4))" " -> Bitmap Heap Scan on conceptassertions c2 (cost=74.64..2047.70 rows=3397 width=4)" " Recheck Cond: (concept = 192)" " -> Bitmap Index Scan on conceptassertions_concept_idx (cost=0.00..73.79 rows=3397 width=0)" " Index Cond: (concept = 192)"