explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FKWO

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.069 12.751 ↓ 1.4 10 1

Sort (cost=1,904.61..1,904.62 rows=7 width=22) (actual time=12.750..12.751 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.009 12.682 ↓ 1.4 10 1

Nested Loop Left Join (cost=0.29..1,904.51 rows=7 width=22) (actual time=4.913..12.682 rows=10 loops=1)

3. 12.663 12.663 ↓ 1.4 10 1

Seq Scan on stock_move (cost=0.00..1,846.39 rows=7 width=12) (actual time=4.906..12.663 rows=10 loops=1)

  • Filter: (((scrapped IS NULL) OR (NOT scrapped)) AND (raw_material_production_id = 835))
  • Rows Removed by Filter: 32737
4. 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)