explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E6SY

Settings
# exclusive inclusive rows x rows loops node
1. 50.643 1,559.655 ↓ 2.1 62,029 1

Gather (cost=54,474.80..59,444.29 rows=29,446 width=171) (actual time=1,393.799..1,559.655 rows=62,029 loops=1)

  • Output: xref.id, xref.customer_number, xref.document_type, xref.note, xref.user_name, xref.file_name, xref.note_id
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=85038, temp read=4002 written=4008
2. 79.063 1,509.012 ↓ 1.7 20,676 3

Merge Anti Join (cost=53,474.80..55,499.69 rows=12,269 width=171) (actual time=1,380.420..1,509.012 rows=20,676 loops=3)

  • Output: xref.id, xref.customer_number, xref.document_type, xref.note, xref.user_name, xref.file_name, xref.note_id
  • Merge Cond: (xref.id = cl.deduction_id)
  • Buffers: shared hit=85038, temp read=4002 written=4008
  • Worker 0: actual time=1355.832..1503.050 rows=28024 loops=1
  • Buffers: shared hit=28465, temp read=1444 written=1446
  • Worker 1: actual time=1392.223..1504.051 rows=24227 loops=1
  • Buffers: shared hit=28213, temp read=1212 written=1214
3. 284.630 293.980 ↑ 1.3 43,484 3

Sort (cost=11,486.53..11,628.37 rows=56,734 width=171) (actual time=280.290..293.980 rows=43,484 loops=3)

  • Output: xref.id, xref.customer_number, xref.document_type, xref.note, xref.user_name, xref.file_name, xref.note_id
  • Sort Key: xref.id
  • Sort Method: external merge Disk: 7912kB
  • Buffers: shared hit=3333, temp read=2931 written=2934
  • Worker 0: actual time=249.188..266.670 rows=45059 loops=1
  • Buffers: shared hit=1230, temp read=1087 written=1088
  • Worker 1: actual time=291.256..301.334 rows=39259 loops=1
  • Buffers: shared hit=978, temp read=855 written=856
4. 9.350 9.350 ↑ 1.3 43,484 3

Parallel Seq Scan on client_stonyfield_sandbox.claim_attachment_xref xref (cost=0.00..3,888.34 rows=56,734 width=171) (actual time=0.006..9.350 rows=43,484 loops=3)

  • Output: xref.id, xref.customer_number, xref.document_type, xref.note, xref.user_name, xref.file_name, xref.note_id
  • Buffers: shared hit=3321
  • Worker 0: actual time=0.004..8.195 rows=45059 loops=1
  • Buffers: shared hit=1224
  • Worker 1: actual time=0.005..8.468 rows=39259 loops=1
  • Buffers: shared hit=972
5. 1,067.433 1,135.969 ↑ 1.0 153,454 3

Sort (cost=41,988.26..42,371.91 rows=153,460 width=8) (actual time=1,099.842..1,135.969 rows=153,454 loops=3)

  • Output: cl.deduction_id
  • Sort Key: cl.deduction_id
  • Sort Method: external merge Disk: 2856kB
  • Buffers: shared hit=81705, temp read=1071 written=1074
  • Worker 0: actual time=1106.635..1146.670 rows=153444 loops=1
  • Buffers: shared hit=27235, temp read=357 written=358
  • Worker 1: actual time=1100.959..1132.598 rows=153459 loops=1
  • Buffers: shared hit=27235, temp read=357 written=358
6. 68.536 68.536 ↑ 1.0 153,460 3

Seq Scan on client_stonyfield_sandbox.claim_data cl (cost=0.00..28,769.60 rows=153,460 width=8) (actual time=0.035..68.536 rows=153,460 loops=3)

  • Output: cl.deduction_id
  • Buffers: shared hit=81705
  • Worker 0: actual time=0.047..67.252 rows=153460 loops=1
  • Buffers: shared hit=27235
  • Worker 1: actual time=0.045..75.573 rows=153460 loops=1
  • Buffers: shared hit=27235