explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lIKr

Settings
# exclusive inclusive rows x rows loops node
1. 1,190.672 2,732.838 ↑ 1.0 1,000,000 1

Hash Join (cost=26,925.00..55,100.00 rows=1,000,000 width=8) (actual time=1,056.523..2,732.838 rows=1,000,000 loops=1)

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

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

3. 579.366 1,056.138 ↑ 1.0 1,000,000 1

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

  • Buckets: 1048576 Batches: 1 Memory Usage: 43349kB
4. 476.772 476.772 ↑ 1.0 1,000,000 1

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

Planning time : 0.091 ms
Execution time : 3,170.938 ms