explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sWwP

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

Limit (cost=4.24..4.24 rows=2 width=40) (actual time=0.156..0.158 rows=10 loops=1)

2. 0.008 0.156 ↓ 5.0 10 1

Sort (cost=4.24..4.24 rows=2 width=40) (actual time=0.155..0.156 rows=10 loops=1)

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

Subquery Scan on near (cost=0.41..4.23 rows=2 width=40) (actual time=0.100..0.148 rows=10 loops=1)

4. 0.002 0.139 ↓ 5.0 10 1

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

5. 0.137 0.137 ↓ 5.0 10 1

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

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