explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aoU

Settings

Optimization(s) for this plan:

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

Aggregate (cost=123.10..123.11 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=104.05..107.22 rows=1,270 width=64) (actual rows= loops=)

  • Sort Key: dad.name
3. 0.000 0.000 ↓ 0.0

Seq Scan on dad (cost=0.00..38.58 rows=1,270 width=64) (actual rows= loops=)

4.          

SubPlan (forSeq Scan)

5. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=32) (actual rows= loops=)