explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZoJA

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.912 ↓ 0.0 0 1

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

  • Group Key: product_id, product_uom
2. 0.070 0.909 ↓ 0.0 0 1

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

  • Sort Key: product_uom
  • Sort Method: quicksort Memory: 25kB
3. 0.839 0.839 ↓ 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.839..0.839 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[])))