explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WHOF

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=9,825.22..9,825.23 rows=1 width=1,042) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=9,825.22..9,825.23 rows=1 width=1,042) (actual rows= loops=)

  • Sort Key: (('12742'::double precision * asin(sqrt((power(sin((((('49.4464909'::double precision - latitude) * '3.14159265358979'::double precision) / '180'::double precision) / '2'::double precision)), '2'::double precision) + (('0.650157915722783'::double precision * cos(((latitude * '3.14159265358979'::double precision) / '180'::double precision))) * power(sin((((('1.0976001'::double precision - longitude) * '3.14159265358979'::double precision) / '180'::double precision) / '2'::double precision)), '2'::double precision)))))))
3. 0.000 0.000 ↓ 0.0

Seq Scan on villes (cost=0.00..9,825.21 rows=1 width=1,042) (actual rows= loops=)

  • Filter: ((latitude >= '49.2666265788163'::double precision) AND (latitude <= '49.6263552211837'::double precision) AND (longitude >= '0.820952970381052'::double precision) AND (longitude <= '1.37424722961895'::double precision) AND (id <> '17cc64ed-b361-4882-82a2-5027c549cd94'::uuid) AND (('12742'::double precision * asin(sqrt((power(sin((((('49.4464909'::double precision - latitude) * '3.14159265358979'::double precision) / '180'::double precision) / '2'::double precision)), '2'::double precision) + (('0.650157915722783'::double precision * cos(((latitude * '3.14159265358979'::double precision) / '180'::double precision))) * power(sin((((('1.0976001'::double precision - longitude) * '3.14159265358979'::double precision) / '180'::double precision) / '2'::double precision)), '2'::double precision)))))) >= '0'::double precision) AND (('12742'::double precision * asin(sqrt((power(sin((((('49.4464909'::double precision - latitude) * '3.14159265358979'::double precision) / '180'::double precision) / '2'::double precision)), '2'::double precision) + (('0.650157915722783'::double precision * cos(((latitude * '3.14159265358979'::double precision) / '180'::double precision))) * power(sin((((('1.0976001'::double precision - longitude) * '3.14159265358979'::double precision) / '180'::double precision) / '2'::double precision)), '2'::double precision)))))) <= '20'::double precision))