explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M913

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 288.429 ↑ 1.0 10 1

Limit (cost=72,709.97..72,709.99 rows=10 width=289) (actual time=288.422..288.429 rows=10 loops=1)

  • Buffers: shared hit=117644
2. 1.473 288.423 ↑ 8.0 10 1

Sort (cost=72,709.97..72,710.17 rows=80 width=289) (actual time=288.420..288.423 rows=10 loops=1)

  • Sort Key: (_st_distance((st_makepoint(bike.lon, bike.lat))::geography(Geometry,4326), '0101000020E61000002030C50BD86F5340345D990178FD2940'::geography(Geometry,4326), '0'::double precision, true))
  • Sort Method: top-N heapsort Memory: 28kB
  • Buffers: shared hit=117644
3. 5.149 286.950 ↓ 13.8 1,106 1

Nested Loop (cost=18,721.69..72,708.24 rows=80 width=289) (actual time=142.233..286.950 rows=1,106 loops=1)

  • Buffers: shared hit=117644
4. 161.912 278.483 ↓ 13.7 1,106 1

Bitmap Heap Scan on bike (cost=18,721.40..72,049.92 rows=81 width=144) (actual time=142.127..278.483 rows=1,106 loops=1)

  • Recheck Cond: (axcess_id IS NOT NULL)
  • Filter: ((type <> 'cycle'::keyless_type) AND (status = 'idle'::bike_status) AND ((st_makepoint(lon, lat))::geography(Geometry,4326) && '0101000020E61000002030C50BD86F5340345D990178FD2940'::geography) AND ('0101000020E61000002030C50BD86F5340345D990178FD2940'::geography(Geometry,4326) && _st_expand((st_makepoint(lon, lat))::geography(Geometry,4326), '1500'::double precision)) AND _st_dwithin((st_makepoint(lon, lat))::geography(Geometry,4326), '0101000020E61000002030C50BD86F5340345D990178FD2940'::geography(Geometry,4326), '1500'::double precision, true))
  • Rows Removed by Filter: 16074
  • Heap Blocks: exact=109815
  • Buffers: shared hit=114319
5. 116.571 116.571 ↓ 45.6 784,607 1

Bitmap Index Scan on idx_bike_axcess_id (cost=0.00..18,721.38 rows=17,196 width=0) (actual time=116.571..116.571 rows=784,607 loops=1)

  • Index Cond: (axcess_id IS NOT NULL)
  • Buffers: shared hit=4501
6. 3.318 3.318 ↑ 1.0 1 1,106

Index Scan using axcess_pkey on axcess (cost=0.29..7.86 rows=1 width=145) (actual time=0.003..0.003 rows=1 loops=1,106)

  • Index Cond: (id = bike.axcess_id)
  • Filter: (ota_status = 'COMPLETED'::otastatus)
  • Buffers: shared hit=3322
Planning time : 0.817 ms