explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oYb6 : w234

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 1.454 ↑ 9.0 2 1

Hash Join (cost=106.12..166.98 rows=18 width=764) (actual time=1.448..1.454 rows=2 loops=1)

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

Bitmap Heap Scan on uzgps_mobject_poi mp (cost=4.63..65.23 rows=23 width=54) (actual time=0.030..0.033 rows=2 loops=1)

  • Recheck Cond: ((mobject_id = 1060) AND (control_type > 0) AND ((mp_status)::text = 'A'::text))
  • Heap Blocks: exact=2
3. 0.022 0.022 ↑ 11.5 2 1

Bitmap Index Scan on uzgps_mobject_poi_mobject_id_control_type_mp_status_idx (cost=0.00..4.62 rows=23 width=0) (actual time=0.022..0.022 rows=2 loops=1)

  • Index Cond: ((mobject_id = 1060) AND (control_type > 0) AND ((mp_status)::text = 'A'::text))
4. 0.368 1.403 ↑ 1.0 1,162 1

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

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

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

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