explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WHg6

Settings
# exclusive inclusive rows x rows loops node
1. 2,883.189 6,955.916 ↓ 0.0 0 1

Hash Join (cost=105,673.28..489,164.72 rows=1,274 width=262) (actual time=6,955.916..6,955.916 rows=0 loops=1)

  • Buffers: local read=314169, temp read=42494 written=42432
2. 2,632.699 2,632.699 ↑ 1.0 1,373,074 1

Seq Scan on _sales_potential_earnings s (cost=0..295,229.74 rows=1,373,074 width=123) (actual time=374.865..2,632.699 rows=1,373,074 loops=1)

  • Buffers: local read=281499
3. 718.349 1,440.028 ↓ 1.2 1,371,323 1

Hash (cost=58,558.73..58,558.73 rows=1,179,003 width=154) (actual time=1,440.027..1,440.028 rows=1,371,323 loops=1)

  • Buffers: local read=32670, temp written=27158
4. 721.679 721.679 ↓ 1.2 1,371,323 1

Seq Scan on _existing_earnings ee (cost=0..58,558.73 rows=1,179,003 width=154) (actual time=0.016..721.679 rows=1,371,323 loops=1)

  • Filter: ((ee.amount <> '0'::numeric) AND (ee.requested_quantity <> '0'::numeric) AND (ee.allowed_quantity <> '0'::numeric))
  • Buffers: local read=32670
Planning time : 5.75 ms
Execution time : 6,956.055 ms