explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uz0V

Settings
# exclusive inclusive rows x rows loops node
1. 1.105 146.399 ↑ 1.0 1,000 1

Sort (cost=29,044.32..29,046.82 rows=1,000 width=54) (actual time=146.359..146.399 rows=1,000 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: 121kB
2. 0.319 145.294 ↑ 1.0 1,000 1

Hash Left Join (cost=21,820.26..28,994.50 rows=1,000 width=54) (actual time=113.819..145.294 rows=1,000 loops=1)

  • Hash Cond: (stock_move.picking_id = stock_move__picking_id.id)
3. 6.555 138.991 ↑ 1.0 1,000 1

Merge Left Join (cost=21,010.77..28,182.38 rows=1,000 width=82) (actual time=107.720..138.991 rows=1,000 loops=1)

  • Merge Cond: (stock_move.id = ir_translation.res_id)
4. 3.499 3.499 ↑ 1.0 1,000 1

Index Scan using stock_move_pkey on stock_move (cost=0.42..5,822.04 rows=1,000 width=47) (actual time=0.256..3.499 rows=1,000 loops=1)

  • Index Cond: (id = ANY ('{131074,182955,237572,147464,188425,155664,221205,230745,172056,139289,229407,73773,237614,229423,122928,221233,229429,163898,90171,238141,114752,172097,213060,155722,221262,188502,131159,18706
5. 11.921 128.937 ↓ 1.6 107,124 1

Unique (cost=21,010.35..21,511.52 rows=67,476 width=43) (actual time=106.161..128.937 rows=107,124 loops=1)

6. 64.100 117.016 ↓ 1.1 107,124 1

Sort (cost=21,010.35..21,260.94 rows=100,234 width=43) (actual time=106.160..117.016 rows=107,124 loops=1)

  • Sort Key: ir_translation.res_id, ir_translation.id DESC
  • Sort Method: external merge Disk: 5672kB
7. 52.916 52.916 ↓ 1.1 107,165 1

Seq Scan on ir_translation (cost=0.00..9,600.91 rows=100,234 width=43) (actual time=1.042..52.916 rows=107,165 loops=1)

  • Filter: ((value <> ''::text) AND ((name)::text = 'stock.move,x_designation_s4'::text) AND ((lang)::text = 'fr_FR'::text))
  • Rows Removed by Filter: 69287
8. 2.331 5.984 ↑ 1.0 16,955 1

Hash (cost=597.55..597.55 rows=16,955 width=14) (actual time=5.984..5.984 rows=16,955 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1117kB
9. 3.653 3.653 ↑ 1.0 16,955 1

Seq Scan on stock_picking stock_move__picking_id (cost=0.00..597.55 rows=16,955 width=14) (actual time=0.015..3.653 rows=16,955 loops=1)

Planning time : 3.725 ms
Execution time : 147.344 ms