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. 391.165 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)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=12284 read=109828, temp read=88105 written=88147
3. 1,923.790 5,659.071 ↓ 2.6 68,604 3 / 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. 1,568.353 3,735.281 ↑ 1.3 1,508,662 3 / 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. 1,399.778 2,166.928 ↑ 1.3 1,508,662 3 / 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. 738.557 738.557 ↑ 1.3 1,508,662 3 / 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. 0.851 28.593 ↑ 417.2 1,409 3 / 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. 0.596 27.742 ↑ 417.2 1,409 3 / 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. 27.146 27.146 ↑ 511.2 1,519 3 / 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