explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jbPt

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

Nested Loop (cost=20,000,000,008.50..20,000,000,033.69 rows=16 width=12) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: "Order".id, "Order_Menu"."idMenu", "Order_Element"."idElement
  • Buffers: shared hit=1
2. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=10,000,000,004.32..10,000,000,020.84 rows=4 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: "Order".id, "Order_Menu"."idMenu
  • Buffers: shared hit=1
3. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using "Order_PK" on public."Order" (cost=0.14..8.16 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: "Order".id
  • Index Cond: ("Order".id = 10)
  • Heap Fetches: 0
  • Buffers: shared hit=1
4. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on public."Order_Menu" (cost=4.18..12.64 rows=4 width=8) (never executed)

  • Output: "Order_Menu"."idOrder", "Order_Menu"."idMenu", "Order_Menu".qty, "Order_Menu"."qtyDelta
  • Recheck Cond: ("Order_Menu"."idOrder" = 10)
5. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on "Order_Menu_PK" (cost=0.00..4.18 rows=4 width=0) (never executed)

  • Index Cond: ("Order_Menu"."idOrder" = 10)
6. 0.000 0.000 ↓ 0.0 0

Materialize (cost=4.18..12.66 rows=4 width=8) (never executed)

  • Output: "Order_Element"."idElement", "Order_Element"."idOrder
7. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on public."Order_Element" (cost=4.18..12.64 rows=4 width=8) (never executed)

  • Output: "Order_Element"."idElement", "Order_Element"."idOrder
  • Recheck Cond: ("Order_Element"."idOrder" = 10)
8. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on "Order_Element_PK" (cost=0.00..4.18 rows=4 width=0) (never executed)

  • Index Cond: ("Order_Element"."idOrder" = 10)
Planning time : 0.097 ms
Execution time : 0.023 ms