explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dn80

Settings
# exclusive inclusive rows x rows loops node
1. 74.616 1,742.837 ↓ 0.0 0 1

Gather Merge (cost=499,737.43..499,738.39 rows=8 width=22) (actual time=1,674.310..1,742.837 rows=0 loops=1)

  • Workers Planned: 4
  • Workers Launched: 3
2. 0.092 1,668.221 ↓ 0.0 0 4 / 4

Sort (cost=498,737.37..498,737.38 rows=2 width=22) (actual time=1,668.221..1,668.221 rows=0 loops=4)

  • 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
3. 0.001 1,668.129 ↓ 0.0 0 4 / 4

Nested Loop Left Join (cost=0.43..498,737.36 rows=2 width=22) (actual time=1,668.129..1,668.129 rows=0 loops=4)

4. 1,668.128 1,668.128 ↓ 0.0 0 4 / 4

Parallel Seq Scan on stock_move (cost=0.00..498,732.06 rows=2 width=12) (actual time=1,668.128..1,668.128 rows=0 loops=4)

  • Filter: (((company_id IS NULL) OR (company_id = 1)) AND (origin_returned_move_id = ANY ('{14373997,14374016,14374045,14374065,14374123,14374155,14374184,14374217,14374267,14374350}'::integer[])))
  • Rows Removed by Filter: 3,236,622
5. 0.000 0.000 ↓ 0.0 0 / 4

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

  • Index Cond: (stock_move.picking_id = id)
Planning time : 0.517 ms
Execution time : 1,742.909 ms