explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4QFH : Optimization for: Optimization for: plan #D0ic; plan #Disw

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.017 0.095 ↓ 0.0 0 1

Sort (cost=16.55..16.55 rows=1 width=22) (actual time=0.095..0.095 rows=0 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.002 0.078 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.43..16.54 rows=1 width=22) (actual time=0.077..0.078 rows=0 loops=1)

3. 0.076 0.076 ↓ 0.0 0 1

Index Scan using stock_move_origin_returned_move_id_index on stock_move (cost=0.28..8.30 rows=1 width=12) (actual time=0.076..0.076 rows=0 loops=1)

  • Index Cond: (origin_returned_move_id = 11530)
  • Filter: ((company_id IS NULL) OR (company_id = 1))
4. 0.000 0.000 ↓ 0.0 0

Index Scan using stock_picking_pkey on stock_picking stock_move__picking_id (cost=0.14..8.16 rows=1 width=14) (never executed)

  • Index Cond: (stock_move.picking_id = id)