explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ijG9

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 13,313.092 ↑ 5.8 18 1

Sort (cost=535,413.22..535,413.48 rows=105 width=70) (actual time=13,313.090..13,313.092 rows=18 loops=1)

  • Sort Key: stock_move_line__move_id__picking_id.priority DESC, stock_move_line__move_id__picking_id.date, stock_move_line__move_id__picking_id.id DESC, stock_move_line__move_id.sequence, stock_move_line__move_id.id
  • Sort Method: quicksort Memory: 27kB
2. 0.000 13,313.058 ↑ 5.8 18 1

Finalize GroupAggregate (cost=535,393.40..535,409.70 rows=105 width=70) (actual time=13,312.991..13,313.058 rows=18 loops=1)

  • Group Key: stock_move_line.move_id, stock_move_line__move_id__picking_id.id, stock_move_line__move_id.id
3. 0.911 13,313.146 ↑ 5.8 18 1

Gather Merge (cost=535,393.40..535,406.56 rows=104 width=70) (actual time=13,312.970..13,313.146 rows=18 loops=1)

  • Workers Planned: 4
  • Workers Launched: 0
4. 0.057 13,312.235 ↑ 1.4 18 1

Partial GroupAggregate (cost=534,393.34..534,394.12 rows=26 width=70) (actual time=13,312.202..13,312.235 rows=18 loops=1)

  • Group Key: stock_move_line.move_id, stock_move_line__move_id__picking_id.id, stock_move_line__move_id.id
5. 0.029 13,312.178 ↑ 1.4 18 1

Sort (cost=534,393.34..534,393.40 rows=26 width=34) (actual time=13,312.175..13,312.178 rows=18 loops=1)

  • Sort Key: stock_move_line.move_id, stock_move_line__move_id__picking_id.id DESC, stock_move_line__move_id.id
  • Sort Method: quicksort Memory: 26kB
6. 0.026 13,312.149 ↑ 1.4 18 1

Nested Loop Left Join (cost=0.87..534,392.73 rows=26 width=34) (actual time=13,309.835..13,312.149 rows=18 loops=1)

7. 0.028 13,312.015 ↑ 1.4 18 1

Nested Loop Left Join (cost=0.43..534,380.70 rows=26 width=24) (actual time=13,309.767..13,312.015 rows=18 loops=1)

8. 13,311.861 13,311.861 ↑ 1.4 18 1

Parallel Seq Scan on stock_move_line (cost=0.00..534,311.73 rows=26 width=12) (actual time=13,309.709..13,311.861 rows=18 loops=1)

  • Filter: (move_id = ANY ('{14155137,14155265,14155140,14155143,14155399,14155146,14155275,14155402,14155150,14155408,14155153,14155282,14155286,14155289,14155419,14155165,14155293,14155296,14155042,14155171,14155428,14155174,14155177,14155307,14155180,14155437,14155054,14155310,14155057,14155316,14155189,14155319,14155064,14155192,14155067,14155195,14155454,14155073,14155202,14155458,14155205,14155335,14155080,14155469,14155342,14155215,14155088,14155345,14155473,14155348,14155351,14155224,14155097,14155354,14155357,14155230,14155360,14155233,14155236,14155109,14155239,14155368,14155242,14155115,14155372,14155245,14155118,14155248,14155121,14155380,14155383,14155386,14155261}'::integer[]))
  • Rows Removed by Filter: 11,854,070
9. 0.126 0.126 ↑ 1.0 1 18

Index Scan using stock_move_pkey on stock_move stock_move_line__move_id (cost=0.43..2.65 rows=1 width=12) (actual time=0.007..0.007 rows=1 loops=18)

  • Index Cond: (stock_move_line.move_id = id)
10. 0.108 0.108 ↑ 1.0 1 18

Index Scan using stock_picking_pkey on stock_picking stock_move_line__move_id__picking_id (cost=0.43..0.46 rows=1 width=14) (actual time=0.006..0.006 rows=1 loops=18)

  • Index Cond: (stock_move_line__move_id.picking_id = id)
Planning time : 0.804 ms
Execution time : 13,313.372 ms