explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 60T

Settings
# exclusive inclusive rows x rows loops node
1. 35.923 193.840 ↑ 1,275.1 9,999 1

Hash Join (cost=30,832.00..197,682.12 rows=12,750,000 width=8) (actual time=185.539..193.840 rows=9,999 loops=1)

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

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

  • Buffers: shared hit=1
3. 88.453 157.904 ↑ 1.0 1,000,000 1

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

  • Buckets: 131072 (originally 131072) Batches: 32 (originally 16) Memory Usage: 3073kB
  • Buffers: shared hit=128 read=4297, temp written=3276
4. 69.451 69.451 ↑ 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.107..69.451 rows=1,000,000 loops=1)

  • Buffers: shared hit=128 read=4297
Planning time : 0.192 ms
Execution time : 194.134 ms