explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AdER

Settings
# exclusive inclusive rows x rows loops node
1. 97.131 249.324 ↓ 0.0 0 1

Hash Join (cost=20,190.26..43,069.69 rows=255 width=238) (actual time=249.324..249.324 rows=0 loops=1)

  • Buffers: local hit=1 read=9794, temp read=2073 written=2067
2. 49.864 49.864 ↓ 1.0 108,448 1

Seq Scan on t_existing_earnings ee (cost=0..4,025.88 rows=107,174 width=129) (actual time=0.005..49.864 rows=108,448 loops=1)

  • Filter: ((ee.amount <> '0'::numeric) AND (ee.requested_quantity <> '0'::numeric) AND (ee.allowed_quantity <> '0'::numeric))
  • Buffers: local hit=1 read=2116
3. 36.642 102.329 ↑ 3.2 108,488 1

Hash (cost=11,125.73..11,125.73 rows=344,773 width=44) (actual time=102.329..102.329 rows=108,488 loops=1)

  • Buffers: local read=7678, temp written=634
4. 65.687 65.687 ↑ 3.2 108,488 1

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

  • Buffers: local read=7678
Planning time : 2.744 ms
Execution time : 249.386 ms