explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1Q9A

Settings
# exclusive inclusive rows x rows loops node
1. 19,711.045 23,031.936 ↑ 1.1 14,630,067 1

Hash Join (cost=112.97..3,419,783.18 rows=15,697,297 width=247) (actual time=2.391..23,031.936 rows=14,630,067 loops=1)

  • Hash Cond: (t.landing_id = l.id)
2. 3,318.580 3,318.580 ↑ 1.1 14,630,067 1

Seq Scan on orders t (cost=0.00..2,085,399.97 rows=15,697,297 width=247) (actual time=0.006..3,318.580 rows=14,630,067 loops=1)

3. 1.209 2.311 ↓ 1.0 2,816 1

Hash (cost=78.54..78.54 rows=2,754 width=16) (actual time=2.311..2.311 rows=2,816 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 164kB
4. 1.102 1.102 ↓ 1.0 2,816 1

Seq Scan on landings l (cost=0.00..78.54 rows=2,754 width=16) (actual time=0.004..1.102 rows=2,816 loops=1)

Planning time : 0.825 ms
Execution time : 23,375.332 ms