explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E1B6

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

Merge Join (cost=69.99..175.55 rows=5,744 width=12) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: "Order".id, "Order_Menu"."idMenu", "Order_Element"."idElement
  • Merge Cond: ("Order_Menu"."idOrder" = "Order".id)
  • Buffers: shared hit=1
2. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using "Order_Menu_PK" on public."Order_Menu" (cost=0.15..56.30 rows=810 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: "Order_Menu"."idOrder", "Order_Menu"."idMenu
  • Heap Fetches: 0
  • Buffers: shared hit=1
3. 0.000 0.000 ↓ 0.0 0

Sort (cost=69.84..71.79 rows=780 width=12) (never executed)

  • Output: "Order".id, "Order_Element"."idElement", "Order_Element"."idOrder
  • Sort Key: "Order".id
4. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=12.47..32.37 rows=780 width=12) (never executed)

  • Output: "Order".id, "Order_Element"."idElement", "Order_Element"."idOrder
  • Inner Unique: true
  • Hash Cond: ("Order_Element"."idOrder" = "Order".id)
5. 0.000 0.000 ↓ 0.0 0

Seq Scan on public."Order_Element" (cost=0.00..17.80 rows=780 width=8) (never executed)

  • Output: "Order_Element"."idOrder", "Order_Element"."idElement", "Order_Element".qty, "Order_Element"."qtyDelta", "Order_Element"."idCatalog
6. 0.000 0.000 ↓ 0.0 0

Hash (cost=11.10..11.10 rows=110 width=4) (never executed)

  • Output: "Order".id
7. 0.000 0.000 ↓ 0.0 0

Seq Scan on public."Order" (cost=0.00..11.10 rows=110 width=4) (never executed)

  • Output: "Order".id
Planning time : 0.202 ms
Execution time : 0.023 ms