explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ESBt

Settings
# exclusive inclusive rows x rows loops node
1. 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
2. 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)
3. 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)
4. 0.000 0.000 ↓ 0.0

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

5. 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)