explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eFn0

Settings
# exclusive inclusive rows x rows loops node
1. 230.242 2,048.770 ↑ 1.3 185,276 1

Hash Join (cost=22,238.93..68,988.95 rows=233,741 width=112) (actual time=839.706..2,048.770 rows=185,276 loops=1)

  • Output: xref.note_id, claim_data.invoice_id, '49d1d0aa-35e9-4e4b-8596-4dcde88d49ce'::uuid, ((((('Document type: '::text || xref.document_type) || ' - User: '::text) || xref.user_name) || ' - Note: '::text) || xref.note), NULL::text
  • Hash Cond: (claim_data.deduction_id = xref.id)
  • Buffers: shared hit=4915 read=27141, temp read=2870 written=2866
2. 979.753 979.753 ↑ 1.0 153,460 1

Seq Scan on client_stonyfield_sandbox.claim_data (cost=0.00..28,769.60 rows=153,460 width=24) (actual time=0.010..979.753 rows=153,460 loops=1)

  • Output: claim_data.invoice_id, claim_data.deduction_id
  • Buffers: shared hit=94 read=27141
3. 68.075 838.775 ↑ 1.0 130,451 1

Hash (cost=19,206.91..19,206.91 rows=136,161 width=55) (actual time=838.775..838.775 rows=130,451 loops=1)

  • Output: xref.note_id, xref.document_type, xref.user_name, xref.note, xref.id
  • Buckets: 131072 Batches: 2 Memory Usage: 6756kB
  • Buffers: shared hit=4807, temp read=1869 written=2473
4. 657.964 770.700 ↑ 1.0 130,451 1

Hash Join (cost=4,895.28..19,206.91 rows=136,161 width=55) (actual time=73.481..770.700 rows=130,451 loops=1)

  • Output: xref.note_id, xref.document_type, xref.user_name, xref.note, xref.id
  • Hash Cond: ("right"(xref.file_name, ("position"(reverse(xref.file_name), '/'::text) - 1)) = ids.attachment_name)
  • Buffers: shared hit=4807, temp read=1869 written=1867
5. 40.205 40.205 ↑ 1.0 130,452 1

Seq Scan on client_stonyfield_sandbox.claim_attachment_xref xref (cost=0.00..4,682.61 rows=136,161 width=160) (actual time=0.015..40.205 rows=130,452 loops=1)

  • Output: xref.note_id, xref.document_type, xref.user_name, xref.note, xref.file_name, xref.id
  • Buffers: shared hit=3321
6. 46.865 72.531 ↑ 1.0 108,946 1

Hash (cost=2,575.46..2,575.46 rows=108,946 width=42) (actual time=72.531..72.531 rows=108,946 loops=1)

  • Output: ids.attachment_name
  • Buckets: 131072 Batches: 2 Memory Usage: 4988kB
  • Buffers: shared hit=1486, temp written=419
7. 25.666 25.666 ↑ 1.0 108,946 1

Seq Scan on client_stonyfield_sandbox.claim_attachment_ids ids (cost=0.00..2,575.46 rows=108,946 width=42) (actual time=0.014..25.666 rows=108,946 loops=1)

  • Output: ids.attachment_name
  • Buffers: shared hit=1486