explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WcIn

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 1.282 ↑ 1.0 1 1

GroupAggregate (cost=0.56..24.90 rows=1 width=40) (actual time=1.281..1.282 rows=1 loops=1)

  • Group Key: stock_move.product_id
2. 0.005 1.260 ↑ 1.0 1 1

Nested Loop (cost=0.56..24.88 rows=1 width=8) (actual time=1.236..1.260 rows=1 loops=1)

3. 0.976 0.976 ↓ 3.0 3 1

Index Scan using stock_move_product_id_index on stock_move (cost=0.28..16.57 rows=1 width=12) (actual time=0.963..0.976 rows=3 loops=1)

  • Index Cond: (product_id = 25201)
  • Filter: (((state)::text = ANY ('{confirmed,waiting,assigned}'::text[])) AND (location_id = ANY ('{21,56,25,26}'::integer[])) AND (location_dest_id <> ALL ('{21,56,25,26}'::integer[])))
  • Rows Removed by Filter: 3
4. 0.279 0.279 ↓ 0.0 0 3

Index Scan using stock_picking_pkey on stock_picking sp (cost=0.28..8.30 rows=1 width=4) (actual time=0.092..0.093 rows=0 loops=3)

  • Index Cond: (id = stock_move.picking_id)
  • Filter: ((purchase_id IS NULL) AND ((type)::text = 'internal'::text))
  • Rows Removed by Filter: 1