explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dGR3 : 123123

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.045 ↑ 4.7 6 1

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

  • Recheck Cond: ((mobject_id = 1060) AND ((mp_status)::text = 'A'::text))
  • Heap Blocks: exact=2
2. 0.031 0.031 ↑ 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.031..0.031 rows=6 loops=1)

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