explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B4Oy

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.020 ↓ 0.0 0 1

Bitmap Heap Scan on filter_zone_localities filter_zone_localities (cost=7.15..12.49 rows=2 width=176) (actual time=0.015..0.02 rows=0 loops=1)

  • Buffers: shared hit=1
2. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on uq_filter_zone_localities_city_state_country_filter_zones_id (cost=0..7.15 rows=2 width=0) (actual time=0.005..0.009 rows=0 loops=1)

  • Index Cond: (filter_zone_localities.filter_zones_id = '55afa273-a19e-4d0b-ab17-e4d2abe0c0a6'::uuid)
  • Buffers: shared hit=1
Planning time : 0.11 ms
Execution time : 0.073 ms