explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EK8i

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

Limit (cost=91.95..100.47 rows=1 width=65) (actual time=10.702..10.702 rows=1 loops=1)

  • Buffers: shared hit=332
2. 0.025 10.701 ↑ 1.0 1 1

Bitmap Heap Scan on t_city_can_parking_area (cost=91.95..100.47 rows=1 width=65) (actual time=10.701..10.701 rows=1 loops=1)

  • Recheck Cond: ((can_parking_area_gis ~ st_setsrid(st_point($2, $3), 4326)) AND ((((city_guid)::text = ($1)::text) AND (is_delete = 0) AND (area_status = 3)) OR (((city_guid)::text = ($1)::text) AND (is_delete = 0) AND (area_status IS NULL))))
  • Filter: _st_covers(can_parking_area_gis, st_setsrid(st_point($2, $3), 4326))
  • Heap Blocks: exact=1
  • Buffers: shared hit=332
3. 0.090 10.676 ↓ 0.0 0 1

BitmapAnd (cost=91.95..91.95 rows=2 width=0) (actual time=10.676..10.676 rows=0 loops=1)

  • Buffers: shared hit=331
4. 0.403 0.403 ↑ 34.0 10 1

Bitmap Index Scan on nidx_city_can_parking_real_can_park_area_gis_gist (cost=0.00..14.84 rows=340 width=0) (actual time=0.403..0.403 rows=10 loops=1)

  • Index Cond: (can_parking_area_gis ~ st_setsrid(st_point($2, $3), 4326))
  • Buffers: shared hit=17
5. 0.854 10.183 ↓ 0.0 0 1

BitmapOr (cost=76.86..76.86 rows=1,601 width=0) (actual time=10.183..10.183 rows=0 loops=1)

  • Buffers: shared hit=314
6. 9.329 9.329 ↓ 66.7 38,153 1

Bitmap Index Scan on nidx_t_city_can_parking_area_cguid_isdel_arstatus (cost=0.00..27.57 rows=572 width=0) (actual time=9.329..9.329 rows=38,153 loops=1)