explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yN8K

Settings
# exclusive inclusive rows x rows loops node
1. 502.496 6,552.732 ↓ 6.5 174,300 1

Aggregate (cost=466,316.52..522,094.04 rows=26,903 width=120) (actual time=3,420.251..6,552.732 rows=174,300 loops=1)

  • Buffers: shared hit=4040 read=37868, temp read=30360 written=30375
2. 0.000 6,050.236 ↓ 3.8 205,813 1

Gather Merge (cost=466,316.52..520,143.57 rows=53,806 width=120) (actual time=3,420.036..6,050.236 rows=205,813 loops=1)

  • Buffers: shared hit=12284 read=109828, temp read=88105 written=88147
3. 5,771.370 16,977.213 ↓ 2.6 68,604 3

Aggregate (cost=465,316.5..512,933 rows=26,903 width=120) (actual time=3,307.935..5,659.071 rows=68,604 loops=3)

  • Buffers: shared hit=12284 read=109828, temp read=88105 written=88147
4. 4,705.059 11,205.843 ↑ 1.3 1,508,662 3

Sort (cost=465,316.5..470,031.07 rows=1,885,828 width=79) (actual time=3,307.813..3,735.281 rows=1,508,662 loops=3)

  • Sort Key: claim_product.claim_id
  • Sort Method: external merge Disk: 128192kB
  • Buffers: shared hit=12284 read=109828, temp read=88105 written=88147
5. 4,199.334 6,500.784 ↑ 1.3 1,508,662 3

Hash Join (cost=37,750.34..214,879.92 rows=1,885,828 width=79) (actual time=32.973..2,166.928 rows=1,508,662 loops=3)

  • Buffers: shared hit=12268 read=109828, temp read=41609 written=41567
6. 2,215.671 2,215.671 ↑ 1.3 1,508,662 3

Seq Scan on claim_product claim_product (cost=0..128,792.28 rows=1,885,828 width=63) (actual time=0.027..738.557 rows=1,508,662 loops=3)

  • Buffers: shared hit=107 read=109827
7. 2.553 85.779 ↑ 417.2 1,409 3

Hash (cost=27,530.61..27,530.61 rows=587,898 width=16) (actual time=28.593..28.593 rows=1,409 loops=3)

  • Buffers: shared hit=12026
8. 1.788 83.226 ↑ 417.2 1,409 3

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

  • Buffers: shared hit=12026
9. 81.438 81.438 ↑ 511.2 1,519 3

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.095..27.146 rows=1,519 loops=3)

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