explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4CXD

Settings
# exclusive inclusive rows x rows loops node
1. 19,945.953 24,104.691 ↑ 1.0 14,630,067 1

Hash Join (cost=112.97..3,318,396.33 rows=14,630,067 width=247) (actual time=0.850..24,104.691 rows=14,630,067 loops=1)

  • Hash Cond: (t.landing_id = l.id)
2. 4,157.921 4,157.921 ↑ 1.0 14,630,067 1

Seq Scan on orders t (cost=0.00..2,074,727.67 rows=14,630,067 width=247) (actual time=0.002..4,157.921 rows=14,630,067 loops=1)

3. 0.396 0.817 ↓ 1.0 2,816 1

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

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

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

Planning time : 3.069 ms
Execution time : 24,454.115 ms