explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IHJh

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

Aggregate (cost=5,291,679.04..5,291,679.04 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,474,168.72..5,291,672.66 rows=2,550 width=0) (actual rows= loops=)

  • Hash Cond: (big2.id = big.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on big2 (cost=0.00..1,442,478.32 rows=100,000,032 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=3,474,136.85..3,474,136.85 rows=2,550 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,083,104.72..3,474,136.85 rows=2,550 width=8) (actual rows= loops=)

  • Hash Cond: (small3.id = big.id)
6. 0.000 0.000 ↓ 0.0

Seq Scan on small3 (cost=0.00..35.50 rows=2,550 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=1,442,478.32..1,442,478.32 rows=100,000,032 width=4) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on big (cost=0.00..1,442,478.32 rows=100,000,032 width=4) (actual rows= loops=)