explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HQ4b

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

Finalize Aggregate (cost=37,923.13..37,923.14 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=37,922.92..37,923.13 rows=2 width=32) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=36,922.92..36,922.93 rows=1 width=32) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=21,847.24..36,922.82 rows=41 width=33) (actual rows= loops=)

  • Hash Cond: (t2.id = t1.id)
5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on t2 (cost=0.00..13,512.67 rows=416,667 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=21,846.00..21,846.00 rows=99 width=37) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on t1 (cost=0.00..21,846.00 rows=99 width=37) (actual rows= loops=)

  • Filter: (clus = 1)