explain.depesz.com

PostgreSQL's explain analyze made readable

Result: liVd

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.022 ↓ 0.0 0 1

Bitmap Heap Scan on filter_zone_localities filter_zone_localities (cost=4.16..9.51 rows=1 width=176) (actual time=0.019..0.022 rows=0 loops=1)

  • Filter: (filter_zone_localities.city = 'fake_city'::text)
  • Buffers: shared hit=1
2. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on idx_filter_zone_localities_place_id (cost=0..4.16 rows=2 width=0) (actual time=0.01..0.013 rows=0 loops=1)

  • Index Cond: (filter_zone_localities.place_id = 'gmap12'::text)
  • Buffers: shared hit=1
Planning time : 0.07 ms
Execution time : 0.062 ms