QUERY PLAN
Nested Loop  (cost=58.71..1512.50 rows=1 width=16) (actual time=1.849..535681.136 rows=14 loops=1)
  ->  Nested Loop  (cost=58.71..1506.60 rows=1 width=20) (actual time=1.839..535680.377 rows=14 loops=1)
        Join Filter: (link0_.element_source = blocks9_.element_seqnum)
        ->  Nested Loop  (cost=58.71..1498.29 rows=1 width=32) (actual time=1.819..535337.910 rows=6534 loops=1)
              ->  Nested Loop  (cost=58.71..1497.14 rows=1 width=28) (actual time=1.811..535246.825 rows=6534 loops=1)
                    ->  Nested Loop  (cost=58.71..1488.83 rows=1 width=36) (actual time=1.800..535160.718 rows=6534 loops=1)
                          ->  Nested Loop  (cost=58.71..1484.40 rows=1 width=28) (actual time=1.772..535042.549 rows=6534 loops=1)
                                ->  Nested Loop  (cost=13.20..1434.87 rows=1 width=16) (actual time=1.398..8327.567 rows=122850 loops=1)
                                      ->  Nested Loop  (cost=13.20..1428.97 rows=1 width=20) (actual time=1.387..1911.520 rows=122850 loops=1)
                                            ->  Nested Loop  (cost=13.20..1427.83 rows=1 width=24) (actual time=1.374..517.662 rows=122850 loops=1)
                                                  ->  Nested Loop  (cost=0.00..16.63 rows=1 width=16) (actual time=0.085..0.409 rows=15 loops=1)
                                                        ->  Index Scan using fki_element_block_block on element_block blocks7_  (cost=0.00..8.30 rows=1 width=8) (actual time=0.045..0.082 rows=15 loops=1)
                                                              Index Cond: (block_seqnum = 5)
                                                        ->  Index Scan using pk_user_element on user_element users3_  (cost=0.00..8.33 rows=1 width=8) (actual time=0.012..0.015 rows=1 loops=15)
                                                              Index Cond: ((users3_.user_seqnum = 10) AND (users3_.element_seqnum = blocks7_.element_seqnum))
                                                  ->  Bitmap Heap Scan on user_element users5_  (cost=13.20..1404.85 rows=634 width=8) (actual time=1.091..12.478 rows=8190 loops=15)
                                                        Recheck Cond: (users5_.user_seqnum = 10)
                                                        ->  Bitmap Index Scan on fki_user_element_user  (cost=0.00..13.05 rows=634 width=0) (actual time=1.062..1.062 rows=8194 loops=15)
                                                              Index Cond: (users5_.user_seqnum = 10)
                                            ->  Seq Scan on block block8_  (cost=0.00..1.14 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=122850)
                                                  Filter: (block8_.block_seqnum = 5)
                                      ->  Seq Scan on "user" user4_  (cost=0.00..5.89 rows=1 width=4) (actual time=0.005..0.047 rows=1 loops=122850)
                                            Filter: (user4_.user_seqnum = 10)
                                ->  Bitmap Heap Scan on link link0_  (cost=45.50..49.51 rows=1 width=12) (actual time=4.283..4.283 rows=0 loops=122850)
                                      Recheck Cond: ((link0_.element_source = users5_.element_seqnum) AND (link0_.element_target = users3_.element_seqnum))
                                      Filter: (link0_.link_sup_date IS NULL)
                                      ->  BitmapAnd  (cost=45.50..45.50 rows=1 width=0) (actual time=4.280..4.280 rows=0 loops=122850)
                                            ->  Bitmap Index Scan on element_source_fk  (cost=0.00..4.61 rows=21 width=0) (actual time=0.007..0.007 rows=6 loops=122850)
                                                  Index Cond: (link0_.element_source = users5_.element_seqnum)
                                            ->  Bitmap Index Scan on element_target_fk  (cost=0.00..40.12 rows=2089 width=0) (actual time=4.719..4.719 rows=33814 loops=110880)
                                                  Index Cond: (link0_.element_target = users3_.element_seqnum)
                          ->  Index Scan using pk_element on element element2_  (cost=0.00..4.41 rows=1 width=8) (actual time=0.009..0.011 rows=1 loops=6534)
                                Index Cond: (element2_.element_seqnum = link0_.element_source)
                    ->  Index Scan using pk_element on element element1_  (cost=0.00..8.31 rows=1 width=4) (actual time=0.006..0.007 rows=1 loops=6534)
                          Index Cond: (element1_.element_seqnum = link0_.element_target)
              ->  Seq Scan on block block10_  (cost=0.00..1.14 rows=1 width=4) (actual time=0.005..0.007 rows=1 loops=6534)
                    Filter: (block10_.block_seqnum = 5)
        ->  Index Scan using fki_element_block_block on element_block blocks9_  (cost=0.00..8.30 rows=1 width=8) (actual time=0.007..0.030 rows=15 loops=6534)
              Index Cond: (blocks9_.block_seqnum = 5)
  ->  Seq Scan on "user" user6_  (cost=0.00..5.89 rows=1 width=4) (actual time=0.006..0.048 rows=1 loops=14)
        Filter: (user6_.user_seqnum = 10)
Total runtime: 535681.414 ms