explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aITF

Settings
# exclusive inclusive rows x rows loops node
1. 849.688 9,780.974 ↓ 0.0 0 1

Merge Join (cost=906,199.94..1,051,296.52 rows=20,775 width=246) (actual time=9,780.974..9,780.974 rows=0 loops=1)

  • Buffers: shared hit=11, local hit=1268824 read=327457, temp read=10262 written=10282
2. 1,018.340 1,018.340 ↓ 1.2 1,371,323 1

Index Scan using ix__existing_earnings_sale_contract on _existing_earnings ee (cost=0.55..97,817.93 rows=1,173,797 width=138) (actual time=0.012..1,018.34 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 hit=1268824 read=45958
3. 6,628.352 7,912.946 ↑ 2.8 1,373,074 1

Sort (cost=906,199.39..915,764.06 rows=3,825,869 width=51) (actual time=5,551.415..7,912.946 rows=1,373,074 loops=1)

  • Sort Key: s.sale_number, s.contract_family_id, s.claimant_company_id
  • Sort Method: external merge Disk: 82096kB
  • Buffers: shared hit=11, local read=281499, temp read=10262 written=10282
4. 1,284.594 1,284.594 ↑ 2.8 1,373,074 1

Seq Scan on _sales_potential_earnings s (cost=0..319,757.69 rows=3,825,869 width=51) (actual time=140.525..1,284.594 rows=1,373,074 loops=1)

  • Buffers: local read=281499
Planning time : 4.188 ms
Execution time : 9,795.567 ms