explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YESv : 123

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 1.685 ↑ 9.0 2 1

Hash Join (cost=106.05..173.11 rows=18 width=764) (actual time=1.679..1.685 rows=2 loops=1)

  • Hash Cond: (mp.poi_id = poi.id)
2. 0.052 0.073 ↑ 11.5 2 1

Bitmap Heap Scan on uzgps_mobject_poi mp (cost=4.56..71.36 rows=23 width=54) (actual time=0.068..0.073 rows=2 loops=1)

  • Recheck Cond: ((mobject_id = 1060) AND (control_type > 0))
  • Filter: ((mp_status)::text = 'A'::text)
  • Rows Removed by Filter: 10
  • Heap Blocks: exact=7
3. 0.021 0.021 ↑ 2.2 12 1

Bitmap Index Scan on uzgps_mobject_poi_mobject_id_control_type_idx (cost=0.00..4.55 rows=27 width=0) (actual time=0.021..0.021 rows=12 loops=1)

  • Index Cond: ((mobject_id = 1060) AND (control_type > 0))
4. 0.412 1.597 ↑ 1.0 1,162 1

Hash (cost=86.35..86.35 rows=1,211 width=710) (actual time=1.597..1.597 rows=1,162 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 326kB
5. 1.185 1.185 ↑ 1.0 1,162 1

Seq Scan on uzgps_poi poi (cost=0.00..86.35 rows=1,211 width=710) (actual time=0.008..1.185 rows=1,162 loops=1)

  • Filter: ((status)::text = 'A'::text)
  • Rows Removed by Filter: 386