QUERY PLAN                                                             
------------------------------------------------------------------------------------------------------------------------------------
 Nested Loop  (cost=0.00..13.52 rows=2 width=1119) (actual time=155.286..155.305 rows=1 loops=1)
   ->  Index Scan using pk_newslang on newslang nl  (cost=0.00..3.87 rows=1 width=1004) (actual time=44.575..44.579 rows=1 loops=1)
         Index Cond: (((codelang)::text = 'FRA'::text) AND (3498704 = numnews))
   ->  Nested Loop Left Join  (cost=0.00..9.61 rows=2 width=119) (actual time=110.648..110.660 rows=1 loops=1)
         ->  Index Scan using pk_news on news n  (cost=0.00..3.31 rows=2 width=98) (actual time=0.169..0.174 rows=1 loops=1)
               Index Cond: (numnews = 3498704)
         ->  Index Scan using pk_photo on photo p  (cost=0.00..3.14 rows=1 width=25) (actual time=110.451..110.454 rows=1 loops=1)
               Index Cond: (p.numphoto = "outer".numphoto)
 Total runtime: 155.514 ms
(9 rows)