explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8vNm : 234234

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.121 ↑ 4.7 6 1

Bitmap Heap Scan on uzgps_mobject_poi mp (cost=4.57..73.28 rows=28 width=54) (actual time=0.115..0.121 rows=6 loops=1)

  • Recheck Cond: ((mobject_id = 1060) AND ((mp_status)::text = 'A'::text))
  • Heap Blocks: exact=2
2. 0.108 0.108 ↑ 4.7 6 1

Bitmap Index Scan on uzgps_mobject_poi_mobject_id_mp_status_idx (cost=0.00..4.57 rows=28 width=0) (actual time=0.108..0.108 rows=6 loops=1)

  • Index Cond: ((mobject_id = 1060) AND ((mp_status)::text = 'A'::text))