explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yYMf

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.045 ↓ 0.0 0 1

GroupAggregate (cost=19.92..19.94 rows=1 width=40) (actual time=0.045..0.045 rows=0 loops=1)

  • Group Key: stock_move.product_id, stock_move.product_uom
2. 0.007 0.044 ↓ 0.0 0 1

Sort (cost=19.92..19.92 rows=1 width=12) (actual time=0.044..0.044 rows=0 loops=1)

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

Nested Loop (cost=0.56..19.91 rows=1 width=12) (actual time=0.037..0.037 rows=0 loops=1)

4. 0.037 0.037 ↓ 0.0 0 1

Index Scan using stock_move_product_id_index on stock_move (cost=0.28..11.59 rows=1 width=16) (actual time=0.037..0.037 rows=0 loops=1)

  • Index Cond: (product_id = 25467)
  • Filter: ((location_dest_id <> location_id) AND ((state)::text = ANY ('{confirmed,waiting,assigned}'::text[])) AND (location_id = ANY ('{21,56,25,26}'::integer[])))
5. 0.000 0.000 ↓ 0.0 0

Index Scan using stock_picking_pkey on stock_picking sp (cost=0.28..8.31 rows=1 width=4) (never executed)

  • Index Cond: (id = stock_move.picking_id)
  • Filter: (((type)::text <> 'internal'::text) AND (partner_id = ANY ('{165097,134208}'::integer[])))
Planning time : 1.317 ms
Execution time : 0.140 ms