explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yt1c

Settings
# exclusive inclusive rows x rows loops node
1. 5,063.690 18,896.546 ↓ 6.5 174,300 1

Aggregate (cost=1,064,037.3..1,200,422.23 rows=26,903 width=120) (actual time=12,656.922..18,896.546 rows=174,300 loops=1)

  • Buffers: shared hit=4413794 read=129063 written=10, temp read=81239 written=81332
2. 6,470.212 13,832.856 ↑ 1.0 4,525,987 1

Sort (cost=1,064,037.3..1,075,352.27 rows=4,525,987 width=79) (actual time=12,656.767..13,832.856 rows=4,525,987 loops=1)

  • Sort Key: claim_product.claim_id
  • Sort Method: external merge Disk: 371752kB
  • Buffers: shared hit=4413794 read=129063 written=10, temp read=81239 written=81332
3. 1,229.663 7,362.644 ↑ 1.0 4,525,987 1

Merge Join (cost=0.86..305,128.44 rows=4,525,987 width=79) (actual time=0.119..7,362.644 rows=4,525,987 loops=1)

  • Buffers: shared hit=4413794 read=129063 written=10
4. 6,101.934 6,101.934 ↑ 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.063..6,101.934 rows=4,525,987 loops=1)

  • Buffers: shared hit=4410796 read=128053 written=10
5. 1.630 31.047 ↑ 417.2 1,409 1

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

  • Buffers: shared hit=2998 read=1010
6. 29.417 29.417 ↑ 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.052..29.417 rows=1,519 loops=1)

  • Index Cond: (claim_product_reason_code.claim_reason_type = 'PEND'::enum.claim_reason_type)
  • Buffers: shared hit=2998 read=1010