explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H83I

Settings
# exclusive inclusive rows x rows loops node
1. 4,252.454 20,638.235 ↓ 9.7 10,475,593 1

Unique (cost=1,893,284.96..2,001,159.65 rows=1,078,747 width=41) (actual time=13,591.749..20,638.235 rows=10,475,593 loops=1)

  • Buffers: shared hit=38 read=98594, temp read=136319 written=136457
2. 13,999.580 16,385.781 ↓ 1.0 10,787,952 1

Sort (cost=1,893,284.96..1,920,253.63 rows=10,787,469 width=41) (actual time=13,591.746..16,385.781 rows=10,787,952 loops=1)

  • Sort Key: claim_product_location.claim_product_id, claim_product_location.location_id, claim_product_location.quantity_ratio
  • Sort Method: external merge Disk: 539072kB
  • Buffers: shared hit=38 read=98594, temp read=136319 written=136457
3. 2,386.201 2,386.201 ↓ 1.0 10,787,952 1

Seq Scan on claim_product_location claim_product_location (cost=0..206,500.69 rows=10,787,469 width=41) (actual time=0.037..2,386.201 rows=10,787,952 loops=1)

  • Buffers: shared hit=32 read=98594