/* select
        page 
    from
        Url page 
    where
        page.url_str='index.html' 
        and page.customer.host='www'   */ select
            url0_.pr_id as pr1_3_,
            url0_.customer as customer3_,
            url0_.lastupdate as lastupdate3_,
            url0_.menuitem as menuitem3_,
            url0_.url_str as url3_3_,
            url0_1_.bin_daten as bin1_4_,
            url0_1_.mime_type as mime2_4_,
            url0_2_.title as title5_,
            url0_2_.xml_daten as xml2_5_,
            case 
                when url0_1_.pr_id is not null then  1  
                when url0_2_.pr_id is not null then  2  
                when url0_.pr_id is not null then  0  
            end as clazz_ 
        from
            public.url url0_ 
        left outer join
            public.rossource url0_1_ 
                on url0_.pr_id=url0_1_.pr_id 
        left outer join
            public.page url0_2_ 
                on url0_.pr_id=url0_2_.pr_id,
            public.customer customer1_ 
        where
            url0_.customer=customer1_.pr 
            and url0_.url_str='index.html' 
            and customer1_.host='www'

 Nested Loop Left Join  (cost= 0 . 00 .. 33 . 11  rows= 1  width= 1542 ) (actual time= 0 . 096 .. 0 . 099  rows= 1  loops= 1 )
   ->  Nested Loop Left Join  (cost= 0 . 00 .. 24 . 83  rows= 1  width= 990 ) (actual time= 0 . 086 .. 0 . 089  rows= 1  loops= 1 )
         ->  Nested Loop  (cost= 0 . 00 .. 16 . 55  rows= 1  width= 536 ) (actual time= 0 . 077 .. 0 . 079  rows= 1  loops= 1 )
               ->  Index Scan using customer_host_key on customer customer1_  (cost= 0 . 00 .. 8 . 27  rows= 1  width= 4 ) (actual time= 0 . 050 .. 0 . 050  rows= 1  loops= 1 )
                     Index Cond: ((host)::text = 'www'::text)
               ->  Index Scan using url_customer_key on url url0_  (cost= 0 . 00 .. 8 . 27  rows= 1  width= 536 ) (actual time= 0 . 019 .. 0 . 020  rows= 1  loops= 1 )
                     Index Cond: ((url0_.customer = customer1_.pr) AND ((url0_.url_str)::text = 'index.html'::text))
         ->  Index Scan using page_pkey on page url0_2_  (cost= 0 . 00 .. 8 . 27  rows= 1  width= 454 ) (actual time= 0 . 009 .. 0 . 010  rows= 1  loops= 1 )
               Index Cond: (url0_.pr_id = url0_2_.pr_id)
   ->  Index Scan using rossource_pkey on rossource url0_1_  (cost= 0 . 00 .. 8 . 27  rows= 1  width= 552 ) (actual time= 0 . 006 .. 0 . 006  rows= 0  loops= 1 )
         Index Cond: (url0_.pr_id = url0_1_.pr_id)
 Total runtime:  0 . 235  ms
( 12  rows)

hosting=# select * from customer where pr =  1  ;
 pr | host | name_ | template
----+------+-------+----------
   1  | ... | .... |         1 
( 1  row)

Time:  0 . 371  ms