explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jaUC

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

CTE Scan on allevorgaenger (cost=22.87..24.33 rows=73 width=12) (actual rows= loops=)

2.          

CTE allevorgaenger

3. 0.000 0.000 ↓ 0.0

Recursive Union (cost=0.00..22.87 rows=73 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on voraussetzen v (cost=0.00..1.09 rows=3 width=8) (actual rows= loops=)

  • Filter: ("Vorgaenger" = 5001)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.16..2.03 rows=7 width=8) (actual rows= loops=)

  • Hash Cond: (a.nachfolger = v_1."Vorgaenger")
6. 0.000 0.000 ↓ 0.0

WorkTable Scan on allevorgaenger a (cost=0.00..0.60 rows=30 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=1.07..1.07 rows=7 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on voraussetzen v_1 (cost=0.00..1.07 rows=7 width=8) (actual rows= loops=)