explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GLQ5

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 0.119 ↑ 1.0 1 1

GroupAggregate (cost=0.56..24.98 rows=1 width=40) (actual time=0.119..0.119 rows=1 loops=1)

  • Group Key: stock_move.product_id
2. 0.009 0.080 ↑ 1.0 1 1

Nested Loop (cost=0.56..24.96 rows=1 width=8) (actual time=0.041..0.080 rows=1 loops=1)

3. 0.044 0.044 ↓ 3.0 3 1

Index Scan using stock_move_product_id_index on stock_move (cost=0.28..16.65 rows=1 width=12) (actual time=0.024..0.044 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.027 0.027 ↓ 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.008..0.009 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