explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ewGa

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

Nested Loop (cost=1,000.43..451,052.48 rows=290 width=60) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan using order_head_pkey on order_head oh (cost=0.43..8.45 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (id = 1200)
3. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..451,041.14 rows=290 width=52) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on order_item oi (cost=0.00..450,012.14 rows=121 width=52) (actual rows= loops=)