explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kAa

Settings
# exclusive inclusive rows x rows loops node
1. 45.352 249.200 ↑ 1,275.1 9,999 1

Hash Join (cost=30,832.00..200,018.56 rows=12,750,000 width=8) (actual time=237.937..249.200 rows=9,999 loops=1)

  • Hash Cond: (small.x = large.x)
  • Buffers: shared hit=4426, temp read=2845 written=4218
2. 0.020 0.020 ↑ 2,550.0 1 1

Seq Scan on small (cost=0.00..35.50 rows=2,550 width=4) (actual time=0.020..0.020 rows=1 loops=1)

  • Buffers: shared hit=1
3. 118.059 203.828 ↑ 1.0 1,000,000 1

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

  • Buckets: 131072 (originally 131072) Batches: 32 (originally 16) Memory Usage: 3073kB
  • Buffers: shared hit=4425, temp written=3276
4. 85.769 85.769 ↑ 1.0 1,000,000 1

Seq Scan on large (cost=0.00..14,425.00 rows=1,000,000 width=8) (actual time=0.028..85.769 rows=1,000,000 loops=1)

  • Buffers: shared hit=4425
Planning time : 0.233 ms
Execution time : 249.559 ms