explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uYFFG

Settings
# exclusive inclusive rows x rows loops node
1. 243.379 456.849 ↓ 0.0 0 1

Hash Join (cost=6,288.67..36,122.54 rows=2,019 width=182) (actual time=456.849..456.849 rows=0 loops=1)

  • Buffers: local read=9795, temp read=1374 written=1372
2. 109.629 109.629 ↑ 3.2 108,488 1

Seq Scan on t_sales_potential_earnings s (cost=0..11,125.73 rows=344,773 width=149) (actual time=41.661..109.629 rows=108,488 loops=1)

  • Buffers: local read=7678
3. 59.717 103.841 ↑ 1.0 109,079 1

Hash (cost=3,207.79..3,207.79 rows=109,079 width=64) (actual time=103.841..103.841 rows=109,079 loops=1)

  • Buffers: local read=2117, temp written=577
4. 44.124 44.124 ↑ 1.0 109,079 1

Seq Scan on t_existing_earnings ee (cost=0..3,207.79 rows=109,079 width=64) (actual time=0.015..44.124 rows=109,079 loops=1)

  • Buffers: local read=2117
Planning time : 10.381 ms
Execution time : 457.005 ms