explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cn7X

Settings
# exclusive inclusive rows x rows loops node
1. 264.424 526.428 ↓ 0.0 0 1

Hash Join (cost=23,220.26..53,462.24 rows=100,236 width=238) (actual time=526.428..526.428 rows=0 loops=1)

  • Buffers: shared hit=19, local hit=1 read=9794, temp read=2698 written=2684
2. 67.266 67.266 ↓ 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.012..67.266 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. 66.564 194.738 ↑ 3.2 108,488 1

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

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

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

  • Buffers: local read=7678
Planning time : 57.427 ms
Execution time : 526.53 ms