explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VdwM

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.070 ↑ 1.0 10 1

Bitmap Heap Scan on im_flexe_inventory im_flexe_inventory (cost=4.36..26.98 rows=10 width=37) (actual time=0.062..0.07 rows=10 loops=1)

  • Heap Blocks: exact=7
  • Buffers: shared hit=7 read=2
2. 0.055 0.055 ↑ 1.0 10 1

Bitmap Index Scan on im_flexe_inventory_master_sku_reservation_id_uindex (cost=0..4.36 rows=10 width=0) (actual time=0.055..0.055 rows=10 loops=1)

  • Index Cond: ((master_sku)::text = 'HME020029N'::text)
  • Buffers: shared read=2
Planning time : 0.055 ms
Execution time : 0.088 ms