explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fMX4

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.191 ↑ 1.0 1 1

Limit (cost=4.24..4.24 rows=1 width=40) (actual time=0.190..0.191 rows=1 loops=1)

2. 0.009 0.190 ↑ 2.0 1 1

Sort (cost=4.24..4.24 rows=2 width=40) (actual time=0.190..0.190 rows=1 loops=1)

  • Sort Key: near.distance
  • Sort Method: top-N heapsort Memory: 25kB
3. 0.011 0.181 ↓ 5.0 10 1

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

4. 0.002 0.170 ↓ 5.0 10 1

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

5. 0.168 0.168 ↓ 5.0 10 1

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

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