explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OeDk

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 374.675 ↓ 1.0 64,269 1

Gather Merge (cost=78,146.14..85,496.41 rows=61,388 width=22) (actual time=294.222..374.675 rows=64,269 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 98.200 1,398.880 ↑ 1.2 12,854 5

Sort (cost=77,146.09..77,184.45 rows=15,347 width=22) (actual time=278.744..279.776 rows=12,854 loops=5)

  • 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: 2078kB
3. 107.446 1,300.680 ↑ 1.2 12,854 5

Nested Loop Left Join (cost=790.11..76,079.03 rows=15,347 width=22) (actual time=49.363..260.136 rows=12,854 loops=5)

4. 774.971 807.620 ↑ 1.2 12,854 5

Parallel Bitmap Heap Scan on stock_move (cost=789.69..61,059.03 rows=15,347 width=12) (actual time=49.270..161.524 rows=12,854 loops=5)

  • Recheck Cond: (product_id = 1417)
  • Heap Blocks: exact=15777
5. 32.649 32.649 ↓ 1.1 66,379 1

Bitmap Index Scan on stock_move_product_id_index (cost=0.00..774.34 rows=61,388 width=0) (actual time=32.649..32.649 rows=66,379 loops=1)

  • Index Cond: (product_id = 1417)
6. 385.614 385.614 ↑ 1.0 1 64,269

Index Scan using stock_picking_pkey on stock_picking stock_move__picking_id (cost=0.42..0.98 rows=1 width=14) (actual time=0.006..0.006 rows=1 loops=64,269)

  • Index Cond: (stock_move.picking_id = id)
Planning time : 1.015 ms
Execution time : 378.313 ms