explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m71o

Settings
# exclusive inclusive rows x rows loops node
1. 28.281 592.890 ↑ 1.0 26,424 1

GroupAggregate (cost=78,438.05..79,746.58 rows=27,548 width=317) (actual time=559.937..592.890 rows=26,424 loops=1)

  • Output: claim_product.claim_product_id, claim_product.product_id, product.product_name, product.product_number, array_agg(product_uom_conversion.uom_type_id), claim_product.distributor_company_id, company.company_name, company.company_number, claim_product.uom_type_id, claim_product.rebate_calculated_rate, claim_product.rebate_requested_quantity, claim_product.rebate_requested_rate, claim_product.rebate_allowed_quantity, claim_product.rebate_allowed_rate, claim_product.resolve_date, claim_product.claimant_contract_name, claim_product.contract_item_id, contract_item.contract_id, contract_family.contract_title, contract_item.won, COALESCE(claim_product.distributor_invoice_number, string_agg(cpl.distributor_invoice_number, ', '::text)), ((cpo.display_order)::integer)
  • Group Key: claim_product.claim_product_id, product.product_name, product.product_number, company.company_name, company.company_number, contract_item.contract_id, contract_family.contract_title, contract_item.won, ((cpo.display_order)::integer)
  • Buffers: shared hit=284205, temp read=3393 written=3394
2. 57.351 564.609 ↑ 1.0 27,472 1

Sort (cost=78,438.05..78,506.92 rows=27,548 width=279) (actual time=559.909..564.609 rows=27,472 loops=1)

  • Output: claim_product.claim_product_id, product.product_name, product.product_number, company.company_name, company.company_number, contract_item.contract_id, contract_family.contract_title, contract_item.won, ((cpo.display_order)::integer), claim_product.product_id, product_uom_conversion.uom_type_id, claim_product.distributor_company_id, claim_product.uom_type_id, claim_product.rebate_calculated_rate, claim_product.rebate_requested_quantity, claim_product.rebate_requested_rate, claim_product.rebate_allowed_quantity, claim_product.rebate_allowed_rate, claim_product.resolve_date, claim_product.claimant_contract_name, claim_product.contract_item_id, claim_product.distributor_invoice_number, cpl.distributor_invoice_number
  • Sort Key: claim_product.claim_product_id, product.product_name, product.product_number, company.company_name, company.company_number, contract_item.contract_id, contract_family.contract_title, contract_item.won, ((cpo.display_order)::integer)
  • Sort Method: external merge Disk: 7608kB
  • Buffers: shared hit=284205, temp read=3393 written=3394
3. 226.909 507.258 ↑ 1.0 27,472 1

Gather (cost=36,439.84..76,406.43 rows=27,548 width=279) (actual time=199.953..507.258 rows=27,472 loops=1)

  • Output: claim_product.claim_product_id, product.product_name, product.product_number, company.company_name, company.company_number, contract_item.contract_id, contract_family.contract_title, contract_item.won, ((cpo.display_order)::integer), claim_product.product_id, product_uom_conversion.uom_type_id, claim_product.distributor_company_id, claim_product.uom_type_id, claim_product.rebate_calculated_rate, claim_product.rebate_requested_quantity, claim_product.rebate_requested_rate, claim_product.rebate_allowed_quantity, claim_product.rebate_allowed_rate, claim_product.resolve_date, claim_product.claimant_contract_name, claim_product.contract_item_id, claim_product.distributor_invoice_number, cpl.distributor_invoice_number
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=284205, temp read=2442 written=2442
4. 0.000 280.349 ↑ 1.3 9,157 3

Hash Left Join (cost=35,439.84..72,611.46 rows=11,478 width=279) (actual time=180.729..280.349 rows=9,157 loops=3)

  • Output: claim_product.claim_product_id, product.product_name, product.product_number, company.company_name, company.company_number, contract_item.contract_id, contract_family.contract_title, contract_item.won, (cpo.display_order)::integer, claim_product.product_id, product_uom_conversion.uom_type_id, claim_product.distributor_company_id, claim_product.uom_type_id, claim_product.rebate_calculated_rate, claim_product.rebate_requested_quantity, claim_product.rebate_requested_rate, claim_product.rebate_allowed_quantity, claim_product.rebate_allowed_rate, claim_product.resolve_date, claim_product.claimant_contract_name, claim_product.contract_item_id, claim_product.distributor_invoice_number, cpl.distributor_invoice_number
  • Hash Cond: ((claim_product.claim_id = claim_product_order.claim_id) AND (claim_product.claim_product_id = cpo.claim_product_id))
  • Buffers: shared hit=284205, temp read=2442 written=2442
  • Worker 0: actual time=169.476..169.476 rows=0 loops=1
  • Buffers: shared hit=21111, temp read=814 written=814
  • Worker 1: actual time=175.411..175.411 rows=0 loops=1
  • Buffers: shared hit=21121, temp read=814 written=814
5. 34.118 265.860 ↑ 1.3 9,157 3

Nested Loop Left Join (cost=35,432.90..72,489.73 rows=11,478 width=291) (actual time=174.273..265.860 rows=9,157 loops=3)

  • Output: claim_product.claim_product_id, claim_product.product_id, claim_product.distributor_company_id, claim_product.uom_type_id, claim_product.rebate_calculated_rate, claim_product.rebate_requested_quantity, claim_product.rebate_requested_rate, claim_product.rebate_allowed_quantity, claim_product.rebate_allowed_rate, claim_product.resolve_date, claim_product.claimant_contract_name, claim_product.contract_item_id, claim_product.distributor_invoice_number, claim_product.claim_id, contract_item.contract_id, contract_item.won, product.product_name, product.product_number, product_uom_conversion.uom_type_id, company.company_name, company.company_number, contract_family.contract_title, cpl.distributor_invoice_number
  • Buffers: shared hit=284144, temp read=2442 written=2442
  • Worker 0: actual time=169.475..169.475 rows=0 loops=1
  • Buffers: shared hit=21111, temp read=814 written=814
  • Worker 1: actual time=175.410..175.410 rows=0 loops=1
  • Buffers: shared hit=21121, temp read=814 written=814
6. 2.512 231.739 ↑ 1.3 9,157 3

Hash Left Join (cost=35,432.35..54,079.21 rows=11,478 width=290) (actual time=174.262..231.739 rows=9,157 loops=3)

  • Output: claim_product.claim_product_id, claim_product.product_id, claim_product.distributor_company_id, claim_product.uom_type_id, claim_product.rebate_calculated_rate, claim_product.rebate_requested_quantity, claim_product.rebate_requested_rate, claim_product.rebate_allowed_quantity, claim_product.rebate_allowed_rate, claim_product.resolve_date, claim_product.claimant_contract_name, claim_product.contract_item_id, claim_product.distributor_invoice_number, claim_product.claim_id, contract_item.contract_id, contract_item.won, product.product_name, product.product_number, product_uom_conversion.uom_type_id, company.company_name, company.company_number, contract_family.contract_title
  • Inner Unique: true
  • Hash Cond: (claim.contract_sequence = contract_family.contract_sequence)
  • Buffers: shared hit=173852, temp read=2442 written=2442
  • Worker 0: actual time=169.474..169.474 rows=0 loops=1
  • Buffers: shared hit=21111, temp read=814 written=814
  • Worker 1: actual time=175.409..175.409 rows=0 loops=1
  • Buffers: shared hit=21121, temp read=814 written=814
7. 0.804 226.696 ↑ 1.3 9,157 3

Hash Left Join (cost=35,073.55..53,690.26 rows=11,478 width=264) (actual time=173.406..226.696 rows=9,157 loops=3)

  • Output: claim_product.claim_product_id, claim_product.product_id, claim_product.distributor_company_id, claim_product.uom_type_id, claim_product.rebate_calculated_rate, claim_product.rebate_requested_quantity, claim_product.rebate_requested_rate, claim_product.rebate_allowed_quantity, claim_product.rebate_allowed_rate, claim_product.resolve_date, claim_product.claimant_contract_name, claim_product.contract_item_id, claim_product.distributor_invoice_number, claim_product.claim_id, contract_item.contract_id, contract_item.won, product.product_name, product.product_number, product_uom_conversion.uom_type_id, claim.contract_sequence, company.company_name, company.company_number
  • Inner Unique: true
  • Hash Cond: (claim_product.distributor_company_id = company.company_id)
  • Buffers: shared hit=173621, temp read=2442 written=2442
  • Worker 0: actual time=169.473..169.473 rows=0 loops=1
  • Buffers: shared hit=21111, temp read=814 written=814
  • Worker 1: actual time=175.408..175.408 rows=0 loops=1
  • Buffers: shared hit=21121, temp read=814 written=814
8. 2.225 219.538 ↑ 1.3 9,157 3

Hash Left Join (cost=34,581.90..53,168.47 rows=11,478 width=233) (actual time=171.269..219.538 rows=9,157 loops=3)

  • Output: claim_product.claim_product_id, claim_product.product_id, claim_product.distributor_company_id, claim_product.uom_type_id, claim_product.rebate_calculated_rate, claim_product.rebate_requested_quantity, claim_product.rebate_requested_rate, claim_product.rebate_allowed_quantity, claim_product.rebate_allowed_rate, claim_product.resolve_date, claim_product.claimant_contract_name, claim_product.contract_item_id, claim_product.distributor_invoice_number, claim_product.claim_id, contract_item.contract_id, contract_item.won, product.product_name, product.product_number, product_uom_conversion.uom_type_id, claim.contract_sequence
  • Hash Cond: ((claim_product.product_id = pro.product_id) AND (contract_item.uom_type_id = suomc.uom_type_id) AND (claim_product.uom_type_id = tuomc.uom_type_id))
  • Buffers: shared hit=173367, temp read=2442 written=2442
  • Worker 0: actual time=169.473..169.473 rows=0 loops=1
  • Buffers: shared hit=21111, temp read=814 written=814
  • Worker 1: actual time=175.408..175.408 rows=0 loops=1
  • Buffers: shared hit=21121, temp read=814 written=814
9. 29.757 211.422 ↑ 1.3 9,157 3

Nested Loop Left Join (cost=34,271.73..52,614.40 rows=11,478 width=249) (actual time=169.295..211.422 rows=9,157 loops=3)

  • Output: claim_product.claim_product_id, claim_product.product_id, claim_product.distributor_company_id, claim_product.uom_type_id, claim_product.rebate_calculated_rate, claim_product.rebate_requested_quantity, claim_product.rebate_requested_rate, claim_product.rebate_allowed_quantity, claim_product.rebate_allowed_rate, claim_product.resolve_date, claim_product.claimant_contract_name, claim_product.contract_item_id, claim_product.distributor_invoice_number, claim_product.claim_id, product.product_name, product.product_number, product_uom_conversion.uom_type_id, claim.contract_sequence, contract_item.contract_id, contract_item.won, contract_item.uom_type_id
  • Inner Unique: true
  • Buffers: shared hit=173304, temp read=2442 written=2442
  • Worker 0: actual time=169.472..169.472 rows=0 loops=1
  • Buffers: shared hit=21111, temp read=814 written=814
  • Worker 1: actual time=175.407..175.407 rows=0 loops=1
  • Buffers: shared hit=21121, temp read=814 written=814
10. 4.375 181.663 ↑ 1.3 9,157 3

Hash Join (cost=34,271.31..37,278.39 rows=11,478 width=216) (actual time=169.283..181.663 rows=9,157 loops=3)

  • Output: claim_product.claim_product_id, claim_product.product_id, claim_product.distributor_company_id, claim_product.uom_type_id, claim_product.rebate_calculated_rate, claim_product.rebate_requested_quantity, claim_product.rebate_requested_rate, claim_product.rebate_allowed_quantity, claim_product.rebate_allowed_rate, claim_product.resolve_date, claim_product.claimant_contract_name, claim_product.contract_item_id, claim_product.distributor_invoice_number, claim_product.claim_id, product.product_name, product.product_number, product_uom_conversion.uom_type_id, claim.contract_sequence
  • Hash Cond: (claim_product.product_id = product_uom_conversion.product_id)
  • Buffers: shared hit=63416, temp read=2442 written=2442
  • Worker 0: actual time=169.471..169.471 rows=0 loops=1
  • Buffers: shared hit=21111, temp read=814 written=814
  • Worker 1: actual time=175.406..175.406 rows=0 loops=1
  • Buffers: shared hit=21121, temp read=814 written=814
11. 10.048 175.702 ↑ 1.3 8,808 3

Merge Join (cost=34,193.66..37,026.66 rows=11,474 width=216) (actual time=167.607..175.702 rows=8,808 loops=3)

  • Output: claim_product.claim_product_id, claim_product.product_id, claim_product.distributor_company_id, claim_product.uom_type_id, claim_product.rebate_calculated_rate, claim_product.rebate_requested_quantity, claim_product.rebate_requested_rate, claim_product.rebate_allowed_quantity, claim_product.rebate_allowed_rate, claim_product.resolve_date, claim_product.claimant_contract_name, claim_product.contract_item_id, claim_product.distributor_invoice_number, claim_product.claim_id, product.product_name, product.product_number, product.product_id, claim.contract_sequence
  • Merge Cond: (invoice.invoice_id = claim.invoice_id)
  • Buffers: shared hit=63289, temp read=2442 written=2442
  • Worker 0: actual time=167.449..167.449 rows=0 loops=1
  • Buffers: shared hit=21058, temp read=814 written=814
  • Worker 1: actual time=174.295..174.295 rows=0 loops=1
  • Buffers: shared hit=21068, temp read=814 written=814
12. 1.990 1.990 ↑ 7.8 8,043 3

Parallel Index Only Scan using invoice_pkey on client_pinnacle.invoice (cost=0.42..2,427.92 rows=62,955 width=16) (actual time=0.035..1.990 rows=8,043 loops=3)

  • Output: invoice.invoice_id
  • Heap Fetches: 14
  • Buffers: shared hit=131
  • Worker 0: actual time=0.039..0.118 rows=262 loops=1
  • Buffers: shared hit=3
  • Worker 1: actual time=0.034..0.574 rows=2228 loops=1
  • Buffers: shared hit=13
13. 66.486 163.664 ↑ 1.0 26,424 3

Sort (cost=34,188.93..34,257.77 rows=27,537 width=232) (actual time=152.365..163.664 rows=26,424 loops=3)

  • Output: claim_product.claim_product_id, claim_product.product_id, claim_product.distributor_company_id, claim_product.uom_type_id, claim_product.rebate_calculated_rate, claim_product.rebate_requested_quantity, claim_product.rebate_requested_rate, claim_product.rebate_allowed_quantity, claim_product.rebate_allowed_rate, claim_product.resolve_date, claim_product.claimant_contract_name, claim_product.contract_item_id, claim_product.distributor_invoice_number, claim_product.claim_id, product.product_name, product.product_number, product.product_id, claim.invoice_id, claim.contract_sequence
  • Sort Key: claim.invoice_id
  • Sort Method: external sort Disk: 6512kB
  • Buffers: shared hit=63158, temp read=2442 written=2442
  • Worker 0: actual time=151.909..161.508 rows=26424 loops=1
  • Buffers: shared hit=21055, temp read=814 written=814
  • Worker 1: actual time=153.139..165.318 rows=26424 loops=1
  • Buffers: shared hit=21055, temp read=814 written=814
14. 8.595 97.178 ↑ 1.0 26,424 3

Nested Loop (cost=515.40..32,158.20 rows=27,537 width=232) (actual time=14.239..97.178 rows=26,424 loops=3)

  • Output: claim_product.claim_product_id, claim_product.product_id, claim_product.distributor_company_id, claim_product.uom_type_id, claim_product.rebate_calculated_rate, claim_product.rebate_requested_quantity, claim_product.rebate_requested_rate, claim_product.rebate_allowed_quantity, claim_product.rebate_allowed_rate, claim_product.resolve_date, claim_product.claimant_contract_name, claim_product.contract_item_id, claim_product.distributor_invoice_number, claim_product.claim_id, product.product_name, product.product_number, product.product_id, claim.invoice_id, claim.contract_sequence
  • Buffers: shared hit=63148
  • Worker 0: actual time=14.188..96.404 rows=26424 loops=1
  • Buffers: shared hit=21050
  • Worker 1: actual time=16.738..97.872 rows=26424 loops=1
  • Buffers: shared hit=21050
15. 0.033 0.033 ↑ 1.0 1 3

Index Scan using claim_pkey on client_pinnacle.claim (cost=0.42..3.44 rows=1 width=36) (actual time=0.029..0.033 rows=1 loops=3)

  • Output: claim.claim_id, claim.invoice_id, claim.claim_state, claim.claim_sequence, claim.transaction_type, claim.contract_sequence, claim.claim_tag
  • Index Cond: (claim.claim_id = '2c3c9316-267c-4439-b4d6-e0f137e32fdf'::uuid)
  • Buffers: shared hit=14
  • Worker 0: actual time=0.032..0.034 rows=1 loops=1
  • Buffers: shared hit=5
  • Worker 1: actual time=0.016..0.020 rows=1 loops=1
  • Buffers: shared hit=5
16. 15.930 88.550 ↑ 1.0 26,424 3

Hash Join (cost=514.98..31,879.39 rows=27,537 width=212) (actual time=14.201..88.550 rows=26,424 loops=3)

  • Output: claim_product.claim_product_id, claim_product.product_id, claim_product.distributor_company_id, claim_product.uom_type_id, claim_product.rebate_calculated_rate, claim_product.rebate_requested_quantity, claim_product.rebate_requested_rate, claim_product.rebate_allowed_quantity, claim_product.rebate_allowed_rate, claim_product.resolve_date, claim_product.claimant_contract_name, claim_product.contract_item_id, claim_product.distributor_invoice_number, claim_product.claim_id, product.product_name, product.product_number, product.product_id
  • Inner Unique: true
  • Hash Cond: (claim_product.product_id = product.product_id)
  • Buffers: shared hit=63134
  • Worker 0: actual time=14.148..87.745 rows=26424 loops=1
  • Buffers: shared hit=21045
  • Worker 1: actual time=16.714..89.529 rows=26424 loops=1
  • Buffers: shared hit=21045
17. 63.191 70.613 ↑ 1.0 26,424 3

Bitmap Heap Scan on client_pinnacle.claim_product (cost=389.34..31,681.35 rows=27,537 width=158) (actual time=12.160..70.613 rows=26,424 loops=3)

  • Output: claim_product.claim_product_id, claim_product.product_id, claim_product.distributor_company_id, claim_product.uom_type_id, claim_product.rebate_calculated_rate, claim_product.rebate_requested_quantity, claim_product.rebate_requested_rate, claim_product.rebate_allowed_quantity, claim_product.rebate_allowed_rate, claim_product.resolve_date, claim_product.claimant_contract_name, claim_product.contract_item_id, claim_product.distributor_invoice_number, claim_product.claim_id
  • Recheck Cond: (claim_product.claim_id = '2c3c9316-267c-4439-b4d6-e0f137e32fdf'::uuid)
  • Heap Blocks: exact=20870
  • Buffers: shared hit=62927
  • Worker 0: actual time=11.812..69.505 rows=26424 loops=1
  • Buffers: shared hit=20976
  • Worker 1: actual time=15.224..72.184 rows=26424 loops=1
  • Buffers: shared hit=20976
18. 7.422 7.422 ↑ 1.0 26,424 3

Bitmap Index Scan on claim_product_claim_id_idx (cost=0.00..382.46 rows=27,537 width=0) (actual time=7.422..7.422 rows=26,424 loops=3)

  • Index Cond: (claim_product.claim_id = '2c3c9316-267c-4439-b4d6-e0f137e32fdf'::uuid)
  • Buffers: shared hit=317
  • Worker 0: actual time=6.981..6.981 rows=26424 loops=1
  • Buffers: shared hit=106
  • Worker 1: actual time=10.436..10.436 rows=26424 loops=1
  • Buffers: shared hit=106
19. 1.126 2.007 ↑ 1.0 2,517 3

Hash (cost=94.17..94.17 rows=2,517 width=54) (actual time=2.006..2.007 rows=2,517 loops=3)

  • Output: product.product_name, product.product_number, product.product_id
  • Buckets: 4096 Batches: 1 Memory Usage: 247kB
  • Buffers: shared hit=207
  • Worker 0: actual time=2.296..2.296 rows=2517 loops=1
  • Buffers: shared hit=69
  • Worker 1: actual time=1.451..1.451 rows=2517 loops=1
  • Buffers: shared hit=69
20. 0.881 0.881 ↑ 1.0 2,517 3

Seq Scan on client_pinnacle.product (cost=0.00..94.17 rows=2,517 width=54) (actual time=0.016..0.881 rows=2,517 loops=3)

  • Output: product.product_name, product.product_number, product.product_id
  • Buffers: shared hit=207
  • Worker 0: actual time=0.016..0.984 rows=2517 loops=1
  • Buffers: shared hit=69
  • Worker 1: actual time=0.015..0.654 rows=2517 loops=1
  • Buffers: shared hit=69
21. 0.878 1.586 ↑ 1.0 2,518 3

Hash (cost=46.18..46.18 rows=2,518 width=32) (actual time=1.586..1.586 rows=2,518 loops=3)

  • Output: product_uom_conversion.uom_type_id, product_uom_conversion.product_id
  • Buckets: 4096 Batches: 1 Memory Usage: 190kB
  • Buffers: shared hit=63
  • Worker 0: actual time=1.883..1.883 rows=2518 loops=1
  • Buffers: shared hit=21
  • Worker 1: actual time=1.002..1.002 rows=2518 loops=1
  • Buffers: shared hit=21
22. 0.708 0.708 ↑ 1.0 2,518 3

Seq Scan on client_pinnacle.product_uom_conversion (cost=0.00..46.18 rows=2,518 width=32) (actual time=0.018..0.708 rows=2,518 loops=3)

  • Output: product_uom_conversion.uom_type_id, product_uom_conversion.product_id
  • Buffers: shared hit=63
  • Worker 0: actual time=0.021..0.858 rows=2518 loops=1
  • Buffers: shared hit=21
  • Worker 1: actual time=0.017..0.454 rows=2518 loops=1
  • Buffers: shared hit=21
23. 0.002 0.002 ↑ 1.0 1 27,472

Index Scan using contract_item_pkey on client_pinnacle.contract_item (cost=0.42..1.34 rows=1 width=49) (actual time=0.002..0.002 rows=1 loops=27,472)

  • Output: contract_item.contract_item_id, contract_item.contract_id, contract_item.product_id, contract_item.grouping_id, contract_item.estimated_quantity, contract_item.uom_type_id, contract_item.rebate_deviated_value, contract_item.rebate_deviated_type, contract_item.inactive_override, contract_item.rebate_direct_value, contract_item.rebate_direct_type, contract_item.rebate_direct_decimal_model, contract_item.rebate_deviated_decimal_model, contract_item.won, contract_item.rebate_growth_type, contract_item.rebate_growth_decimal_model
  • Index Cond: (claim_product.contract_item_id = contract_item.contract_item_id)
  • Buffers: shared hit=109888
24. 0.677 5.891 ↓ 1.0 2,520 1

Hash (cost=266.09..266.09 rows=2,519 width=48) (actual time=5.891..5.891 rows=2,520 loops=1)

  • Output: pro.product_id, suomc.uom_type_id, tuomc.uom_type_id
  • Buckets: 4096 Batches: 1 Memory Usage: 229kB
  • Buffers: shared hit=63
25. 0.975 5.214 ↓ 1.0 2,520 1

Hash Join (cost=185.27..266.09 rows=2,519 width=48) (actual time=4.035..5.214 rows=2,520 loops=1)

  • Output: pro.product_id, suomc.uom_type_id, tuomc.uom_type_id
  • Hash Cond: (tuomc.product_id = pro.product_id)
  • Buffers: shared hit=63
26. 0.227 0.227 ↑ 1.0 2,518 1

Seq Scan on client_pinnacle.product_uom_conversion tuomc (cost=0.00..46.18 rows=2,518 width=32) (actual time=0.010..0.227 rows=2,518 loops=1)

  • Output: tuomc.product_id, tuomc.uom_type_id, tuomc.rate
  • Buffers: shared hit=21
27. 0.881 4.012 ↑ 1.0 2,518 1

Hash (cost=153.80..153.80 rows=2,518 width=48) (actual time=4.012..4.012 rows=2,518 loops=1)

  • Output: pro.product_id, suomc.product_id, suomc.uom_type_id
  • Buckets: 4096 Batches: 1 Memory Usage: 229kB
  • Buffers: shared hit=42
28. 1.306 3.131 ↑ 1.0 2,518 1

Hash Join (cost=101.00..153.80 rows=2,518 width=48) (actual time=1.497..3.131 rows=2,518 loops=1)

  • Output: pro.product_id, suomc.product_id, suomc.uom_type_id
  • Inner Unique: true
  • Hash Cond: (suomc.product_id = pro.product_id)
  • Buffers: shared hit=42
29. 0.346 0.346 ↑ 1.0 2,518 1

Seq Scan on client_pinnacle.product_uom_conversion suomc (cost=0.00..46.18 rows=2,518 width=32) (actual time=0.004..0.346 rows=2,518 loops=1)

  • Output: suomc.product_id, suomc.uom_type_id, suomc.rate
  • Buffers: shared hit=21
30. 0.799 1.479 ↑ 1.0 2,517 1

Hash (cost=69.53..69.53 rows=2,517 width=16) (actual time=1.479..1.479 rows=2,517 loops=1)

  • Output: pro.product_id
  • Buckets: 4096 Batches: 1 Memory Usage: 150kB
  • Buffers: shared hit=21
31. 0.680 0.680 ↑ 1.0 2,517 1

Index Only Scan using product_pkey on client_pinnacle.product pro (cost=0.28..69.53 rows=2,517 width=16) (actual time=0.016..0.680 rows=2,517 loops=1)

  • Output: pro.product_id
  • Heap Fetches: 0
  • Buffers: shared hit=21
32. 3.389 6.354 ↑ 1.0 10,562 1

Hash (cost=359.62..359.62 rows=10,562 width=47) (actual time=6.354..6.354 rows=10,562 loops=1)

  • Output: company.company_name, company.company_number, company.company_id
  • Buckets: 16384 Batches: 1 Memory Usage: 956kB
  • Buffers: shared hit=254
33. 2.965 2.965 ↑ 1.0 10,562 1

Seq Scan on client_pinnacle.company (cost=0.00..359.62 rows=10,562 width=47) (actual time=0.011..2.965 rows=10,562 loops=1)

  • Output: company.company_name, company.company_number, company.company_id
  • Buffers: shared hit=254
34. 1.087 2.531 ↑ 1.0 5,680 1

Hash (cost=287.80..287.80 rows=5,680 width=34) (actual time=2.531..2.531 rows=5,680 loops=1)

  • Output: contract_family.contract_title, contract_family.contract_sequence
  • Buckets: 8192 Batches: 1 Memory Usage: 439kB
  • Buffers: shared hit=231
35. 1.444 1.444 ↑ 1.0 5,680 1

Seq Scan on client_pinnacle.contract_family (cost=0.00..287.80 rows=5,680 width=34) (actual time=0.020..1.444 rows=5,680 loops=1)

  • Output: contract_family.contract_title, contract_family.contract_sequence
  • Buffers: shared hit=231
36. 0.003 0.003 ↑ 5.0 1 27,472

Index Only Scan using claim_product_location_pkey on client_pinnacle.claim_product_location cpl (cost=0.56..1.55 rows=5 width=17) (actual time=0.003..0.003 rows=1 loops=27,472)

  • Output: cpl.claim_product_id, cpl.location_id, cpl.distributor_invoice_number
  • Index Cond: (cpl.claim_product_id = claim_product.claim_product_id)
  • Heap Fetches: 0
  • Buffers: shared hit=110292
37. 7.438 19.344 ↓ 264.2 26,424 1

Hash (cost=5.44..5.44 rows=100 width=40) (actual time=19.344..19.344 rows=26,424 loops=1)

  • Output: claim_product_order.claim_id, cpo.display_order, cpo.claim_product_id
  • Buckets: 32768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 2114kB
  • Buffers: shared hit=61
38. 4.365 11.906 ↓ 264.2 26,424 1

Nested Loop (cost=0.42..5.44 rows=100 width=40) (actual time=4.439..11.906 rows=26,424 loops=1)

  • Output: claim_product_order.claim_id, cpo.display_order, cpo.claim_product_id
  • Buffers: shared hit=61
39. 0.021 0.021 ↑ 1.0 1 1

Index Scan using claim_product_order_pkey on client_pinnacle.claim_product_order (cost=0.42..3.44 rows=1 width=144) (actual time=0.016..0.021 rows=1 loops=1)

  • Output: claim_product_order.claim_id, claim_product_order.item_ids
  • Index Cond: (claim_product_order.claim_id = '2c3c9316-267c-4439-b4d6-e0f137e32fdf'::uuid)
  • Buffers: shared hit=4
40. 7.520 7.520 ↓ 264.2 26,424 1

Function Scan on pg_catalog.unnest cpo (cost=0.00..1.00 rows=100 width=24) (actual time=4.417..7.520 rows=26,424 loops=1)

  • Output: cpo.claim_product_id, cpo.display_order
  • Function Call: unnest(claim_product_order.item_ids)
  • Buffers: shared hit=57