explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Oni : Optimization for: plan #FKWO

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.041 0.177 ↓ 1.4 10 1

Sort (cost=89.16..89.18 rows=7 width=22) (actual time=0.175..0.177 rows=10 loops=1)

  • Sort Key: stock_move__picking_id.priority DESC, stock_move__picking_id.date, stock_move__picking_id.id DESC, stock_move.sequence, stock_move.id
  • Sort Method: quicksort Memory: 25kB
2. 0.011 0.136 ↓ 1.4 10 1

Nested Loop Left Join (cost=4.63..89.06 rows=7 width=22) (actual time=0.096..0.136 rows=10 loops=1)

3. 0.043 0.115 ↓ 1.4 10 1

Bitmap Heap Scan on stock_move (cost=4.34..30.94 rows=7 width=12) (actual time=0.088..0.115 rows=10 loops=1)

  • Recheck Cond: (raw_material_production_id = 835)
  • Filter: ((scrapped IS NULL) OR (NOT scrapped))
  • Heap Blocks: exact=6
4. 0.072 0.072 ↓ 1.4 10 1

Bitmap Index Scan on stock_move_raw_material_production_id_index (cost=0.00..4.34 rows=7 width=0) (actual time=0.072..0.072 rows=10 loops=1)

  • Index Cond: (raw_material_production_id = 835)
5. 0.010 0.010 ↓ 0.0 0 10

Index Scan using stock_picking_pkey on stock_picking stock_move__picking_id (cost=0.29..8.30 rows=1 width=14) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: (stock_move.picking_id = id)