explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CWod

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.084 ↓ 0.0 0 1

GroupAggregate (cost=8.32..8.35 rows=1 width=40) (actual time=0.084..0.084 rows=0 loops=1)

  • Group Key: product_id, product_uom
2. 0.012 0.082 ↓ 0.0 0 1

Sort (cost=8.32..8.33 rows=1 width=12) (actual time=0.082..0.082 rows=0 loops=1)

  • Sort Key: product_uom
  • Sort Method: quicksort Memory: 25kB
3. 0.070 0.070 ↓ 0.0 0 1

Index Scan using stock_move_picking_id_index on stock_move (cost=0.28..8.31 rows=1 width=12) (actual time=0.070..0.070 rows=0 loops=1)

  • Index Cond: (picking_id = 3422109)
  • Filter: ((location_dest_id <> location_id) AND (product_id = 25372) AND ((state)::text = ANY ('{confirmed,waiting,assigned}'::text[])) AND (location_id = ANY ('{21,56,25,26}'::integer[])))