EXPLAIN SELECT not_id, not_code, not_street, street_id, streettype_id, district_id, massiv_id, region_id, settle_id, settle_type
FROM mk.notice
LEFT JOIN mk.nstreet ON (nst_id = not_street)
LEFT JOIN mk.street ON (nst_street = street_id)
LEFT JOIN mk.streettype ON (nst_streettype = streettype_id)
LEFT JOIN mk.district ON (nst_district = district_id)
LEFT JOIN mk.massiv ON (nst_massiv = massiv_id)
LEFT JOIN mk.region ON (nst_region = region_id)
LEFT JOIN mk.settle ON (nst_settle = settle_id)

Nested Loop Left Join  (cost=2.22..177.69 rows=5 width=59)                                                       
   ->  Nested Loop Left Join  (cost=2.22..153.51 rows=5 width=55)                                                 
         ->  Nested Loop Left Join  (cost=2.22..129.33 rows=5 width=55)                                           
               ->  Nested Loop Left Join  (cost=2.22..105.15 rows=5 width=55)                                     
                     ->  Nested Loop Left Join  (cost=2.22..80.98 rows=5 width=55)                                
                           ->  Merge Right Join  (cost=2.22..56.80 rows=5 width=55)                               
                                 Merge Cond: ("outer".street_id = "inner".nst_street)                             
                                 ->  Index Scan using street_pkey on street  (cost=0.00..52.00 rows=1000 width=8) 
                                 ->  Sort  (cost=2.22..2.24 rows=5 width=51)                                      
                                       Sort Key: nstreet.nst_street                                               
                                       ->  Hash Left Join  (cost=1.05..2.17 rows=5 width=51)                      
                                             Hash Cond: ("outer".not_street = "inner".nst_id)                     
                                             ->  Seq Scan on notice  (cost=0.00..1.05 rows=5 width=27)            
                                             ->  Hash  (cost=1.04..1.04 rows=4 width=28)                          
                                                   ->  Seq Scan on nstreet  (cost=0.00..1.04 rows=4 width=28)     
                           ->  Index Scan using streettype_pkey on streettype  (cost=0.00..4.82 rows=1 width=4)   
                                 Index Cond: ("outer".nst_streettype = streettype.streettype_id)                  
                     ->  Index Scan using district_pkey on district  (cost=0.00..4.82 rows=1 width=4)             
                           Index Cond: ("outer".nst_district = district.district_id)                              
               ->  Index Scan using massiv_pkey on massiv  (cost=0.00..4.82 rows=1 width=4)                       
                     Index Cond: ("outer".nst_massiv = massiv.massiv_id)                                          
         ->  Index Scan using region_pkey on region  (cost=0.00..4.82 rows=1 width=4)                             
               Index Cond: ("outer".nst_region = region.region_id)                                                
   ->  Index Scan using settle_pkey on settle  (cost=0.00..4.82 rows=1 width=8)                                   
         Index Cond: ("outer".nst_settle = settle.settle_id)