explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L7v4

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

Finalize Aggregate (cost=2,222,801.27..2,222,801.28 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=2,222,801.06..2,222,801.27 rows=2 width=8) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=2,212,801.06..2,212,801.07 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=572,568.79..2,186,008.52 rows=10,717,016 width=0) (actual rows= loops=)

  • Hash Cond: (o.id = d.id)
5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on tbl_order o (cost=0.00..1,585,278.43 rows=10,728,113 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=438,606.09..438,606.09 rows=10,717,016 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Parallel Index Only Scan using tbl_order_delivery_pkey on tbl_order_delivery d (cost=0.56..438,606.09 rows=10,717,016 width=4) (actual rows= loops=)