explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7KP

Settings
# exclusive inclusive rows x rows loops node
1. 6,999.570 27,621.457 ↓ 6.5 174,300 1

Aggregate (cost=1,064,037.3..1,200,287.71 rows=26,903 width=120) (actual time=19,243.531..27,621.457 rows=174,300 loops=1)

  • Buffers: shared hit=4417378 read=125479 written=121, temp read=81239 written=81332
2. 7,855.141 20,621.887 ↑ 1.0 4,525,987 1

Sort (cost=1,064,037.3..1,075,352.27 rows=4,525,987 width=79) (actual time=19,243.504..20,621.887 rows=4,525,987 loops=1)

  • Sort Key: claim_product.claim_id
  • Sort Method: external merge Disk: 371752kB
  • Buffers: shared hit=4417378 read=125479 written=121, temp read=81239 written=81332
3. 1,452.900 12,766.746 ↑ 1.0 4,525,987 1

Merge Join (cost=0.86..305,128.44 rows=4,525,987 width=79) (actual time=0.073..12,766.746 rows=4,525,987 loops=1)

  • Buffers: shared hit=4417378 read=125479 written=121
4. 11,273.040 11,273.040 ↑ 1.0 4,525,987 1

Index Scan using claim_product_pkey on claim_product claim_product (cost=0.43..258,934.13 rows=4,525,987 width=63) (actual time=0.02..11,273.04 rows=4,525,987 loops=1)

  • Buffers: shared hit=4414937 read=123912 written=119
5. 2.354 40.806 ↑ 417.2 1,409 1

Unique (cost=0.42..21,651.63 rows=587,898 width=16) (actual time=0.05..40.806 rows=1,409 loops=1)

  • Buffers: shared hit=2441 read=1567 written=2
6. 38.452 38.452 ↑ 511.2 1,519 1

Index Only Scan using claim_product_reason_code_active_idx on claim_product_reason_code claim_product_reason_code (cost=0.42..19,710.52 rows=776,443 width=16) (actual time=0.049..38.452 rows=1,519 loops=1)

  • Index Cond: (claim_product_reason_code.claim_reason_type = 'PEND'::enum.claim_reason_type)
  • Buffers: shared hit=2441 read=1567 written=2