explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tutH

Settings

Optimization(s) for this plan:

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

Limit (cost=763,597.09..763,597.29 rows=10 width=24) (actual rows= loops=)

2.          

CTE nodes

3. 0.000 0.000 ↓ 0.0

Recursive Union (cost=35,267.08..763,597.09 rows=3,097,872 width=40) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Gather (cost=35,267.08..70,348.40 rows=30,672 width=40) (actual rows= loops=)

  • Workers Planned: 2
5. 0.000 0.000 ↓ 0.0

Parallel Hash Semi Join (cost=34,267.08..66,281.20 rows=12,780 width=40) (actual rows= loops=)

  • Hash Cond: (s1.id = blocks.prev_block_id)
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on blocks s1 (cost=0.00..30,829.21 rows=13,610 width=32) (actual rows= loops=)

  • Filter: (height IS NOT NULL)
7. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=30,829.21..30,829.21 rows=209,510 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on blocks (cost=0.00..30,829.21 rows=209,510 width=8) (actual rows= loops=)

  • Filter: (height IS NULL)
9. 0.000 0.000 ↓ 0.0

Hash Join (cost=44,830.53..63,129.13 rows=306,720 width=40) (actual rows= loops=)

  • Hash Cond: (s1_1.id = s2.prev_block_id)
10. 0.000 0.000 ↓ 0.0

WorkTable Scan on nodes s1_1 (cost=0.00..6,134.40 rows=306,720 width=16) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=33,952.90..33,952.90 rows=535,490 width=40) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on blocks s2 (cost=0.00..33,952.90 rows=535,490 width=40) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

CTE Scan on nodes (cost=0.00..61,957.44 rows=3,097,872 width=24) (actual rows= loops=)