QUERY PLAN                                                                                                                                                                                      
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=3126.79..3126.79 rows=1 width=728) (actual time=0.112..0.112 rows=0 loops=1)
   ->  Nested Loop  (cost=44.85..3126.79 rows=1 width=728) (actual time=0.108..0.108 rows=0 loops=1)
         ->  Nested Loop Left Join  (cost=44.85..3117.78 rows=1 width=571) (actual time=0.106..0.106 rows=0 loops=1)
               Join Filter: (residenced19_.residencetype_id = residencet22_.id)
               ->  Nested Loop Left Join  (cost=44.85..3116.58 rows=1 width=546) (actual time=0.104..0.104 rows=0 loops=1)
                     ->  Nested Loop  (cost=44.85..3108.96 rows=1 width=530) (actual time=0.102..0.102 rows=0 loops=1)
                           ->  Nested Loop  (cost=44.85..3101.06 rows=1 width=514) (actual time=0.100..0.100 rows=0 loops=1)
                                 ->  Nested Loop  (cost=44.85..3093.44 rows=1 width=292) (actual time=0.098..0.098 rows=0 loops=1)
                                       ->  Hash Join  (cost=44.85..3085.84 rows=1 width=132) (actual time=0.096..0.096 rows=0 loops=1)
                                             Hash Cond: (ace3_.eventinitiator_id = account6_.id)
                                             ->  Seq Scan on adcreatedevent ace3_  (cost=0.00..2323.41 rows=149641 width=16) (actual time=0.030..0.030 rows=1 loops=1)
                                             ->  Hash  (cost=44.84..44.84 rows=1 width=116) (actual time=0.045..0.045 rows=0 loops=1)
                                                   ->  Nested Loop  (cost=0.00..44.84 rows=1 width=116) (actual time=0.044..0.044 rows=0 loops=1)
                                                         Join Filter: (account6_.contactinformation_id = contactinf7_.id)
                                                         ->  Nested Loop  (cost=0.00..43.73 rows=1 width=55) (actual time=0.041..0.041 rows=0 loops=1)
                                                               ->  Seq Scan on contactinformation contactinf7_  (cost=0.00..1.05 rows=5 width=39) (actual time=0.005..0.014 rows=5 loops=1)
                                                               ->  Index Scan using cityid on city city8_  (cost=0.00..8.52 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=5)
                                                                     Index Cond: (contactinf7_.city_id = city8_.id)
                                                         ->  Seq Scan on account account6_  (cost=0.00..1.05 rows=5 width=61) (never executed)
                                       ->  Index Scan using roommateresidenceofferadcreatedevent on roommateresidenceoffer this_  (cost=0.00..7.59 rows=1 width=160) (never executed)
                                             Index Cond: (this_.adcreatedevent_id = ace3_.id)
                                 ->  Index Scan using residencedescription_pkey on residencedescription residenced19_  (cost=0.00..7.61 rows=1 width=222) (never executed)
                                       Index Cond: (this_.residencedescription_id = residenced19_.id)
                           ->  Index Scan using cityid on city city1_  (cost=0.00..7.88 rows=1 width=16) (never executed)
                                 Index Cond: (residenced19_.city_id = city1_.id)
                     ->  Index Scan using funalaevent_pkey on funalaevent ace3_1_  (cost=0.00..7.61 rows=1 width=16) (never executed)
                           Index Cond: (ace3_.id = ace3_1_.id)
               ->  Seq Scan on residencetype residencet22_  (cost=0.00..1.09 rows=9 width=25) (never executed)
         ->  Index Scan using gisfeatureid on gisfeature gf2_  (cost=0.00..9.00 rows=1 width=157) (never executed)
               Index Cond: (city1_.associatedgisfeature_id = gf2_.id)
               Filter: (("location" && '0103000020E610000001000000050000009BC810BB85B8F83F01D42B98AA5D48409BC810BB85B8F83F4134414633804840D44ADA6E12F908404134414633804840D44ADA6E12F9084001D42B98AA5D48409BC810BB85B8F83F01D42B98AA5D4840'::geometry) AND (distance_sphere("location", '0101000020E6100000915731A6AAAA0240218436EFEE6E4840'::geometry) <= 15000::double precision))
 Total runtime: 1.137 ms
(32 lignes)