explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mkD3

Settings
# exclusive inclusive rows x rows loops node
1. 350.727 554.013 ↑ 1.0 1,000,000 1

Hash Join (cost=30,832.00..70,728.00 rows=1,000,000 width=8) (actual time=155.274..554.013 rows=1,000,000 loops=1)

  • Output: t3a.id, t3b.id
  • Hash Cond: (t3a.id = t3b.id)
2. 50.258 50.258 ↑ 1.0 1,000,000 1

Seq Scan on public.t3a (cost=0.00..14,425.00 rows=1,000,000 width=4) (actual time=0.013..50.258 rows=1,000,000 loops=1)

  • Output: t3a.id
3. 103.681 153.028 ↑ 1.0 1,000,000 1

Hash (cost=14,425.00..14,425.00 rows=1,000,000 width=4) (actual time=153.028..153.028 rows=1,000,000 loops=1)

  • Output: t3b.id
  • Buckets: 131072 Batches: 16 Memory Usage: 3227kB
4. 49.347 49.347 ↑ 1.0 1,000,000 1

Seq Scan on public.t3b (cost=0.00..14,425.00 rows=1,000,000 width=4) (actual time=0.011..49.347 rows=1,000,000 loops=1)

  • Output: t3b.id