explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Disw : Optimization for: plan #D0ic

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.026 1.944 ↓ 0.0 0 1
→

Sort (cost=268.48..268.48 rows=1 width=22) (actual time=1.944..1.944 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.001 1.918 ↓ 0.0 0 1
→

Nested Loop Left Join (cost=0.14..268.47 rows=1 width=22) (actual time=1.918..1.918 rows=0 loops=1)

3. 1.917 1.917 ↓ 0.0 0 1
→

Seq Scan on stock_move (cost=0.00..260.23 rows=1 width=12) (actual time=1.917..1.917 rows=0 loops=1)

  • Filter: (((company_id IS NULL) OR (company_id = 1)) AND (origin_returned_move_id = 11530))
  • Rows Removed by Filter: 4882
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)