explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UEHZO

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

Aggregate (cost=12.34..12.35 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=11.27..12.32 rows=1 width=53) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on "user" (cost=0.00..1.02 rows=1 width=21) (actual rows= loops=)

  • Filter: (id = 1)
4. 0.000 0.000 ↓ 0.0

Aggregate (cost=11.27..11.28 rows=1 width=32) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on employee (cost=0.00..11.25 rows=1 width=222) (actual rows= loops=)

  • Filter: ("user".id = user_id)
6.          

SubPlan (for Aggregate)

7. 0.000 0.000 ↓ 0.0

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

8.          

SubPlan (for Aggregate)

9. 0.000 0.000 ↓ 0.0

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