explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5NxX

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.240 ↓ 5.0 10 1

Limit (cost=4.23..4.24 rows=2 width=40) (actual time=0.238..0.240 rows=10 loops=1)

2. 0.013 0.238 ↓ 5.0 10 1

Sort (cost=4.23..4.24 rows=2 width=40) (actual time=0.237..0.238 rows=10 loops=1)

  • Sort Key: near.distance
  • Sort Method: quicksort Memory: 25kB
3. 0.011 0.225 ↓ 5.0 10 1

Subquery Scan on near (cost=0.41..4.22 rows=2 width=40) (actual time=0.155..0.225 rows=10 loops=1)

4. 0.003 0.214 ↓ 5.0 10 1

Limit (cost=0.41..4.18 rows=2 width=65) (actual time=0.152..0.214 rows=10 loops=1)

5. 0.211 0.211 ↓ 5.0 10 1

Index Scan using ind_roads_geom on roads (cost=0.41..4.18 rows=2 width=65) (actual time=0.151..0.211 rows=10 loops=1)

  • Index Cond: (the_geom && '0103000020E610000001000000050000003BE27CE03D7841C0300DC347C41C20C03BE27CE03D7841C016DEE522BE1B20C075964557FC7741C016DEE522BE1B20C075964557FC7741C0300DC347C41C20C03BE27CE03D7841C0300DC347C41C20C0'::geometry)
  • Order By: (the_geom <#> '0101000020E6100000583CE11B1D7841C0A3755435411C20C0'::geometry)
Planning time : 0.247 ms
Execution time : 0.289 ms