explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UkZQ

Settings
# exclusive inclusive rows x rows loops node
1. 19.219 253.541 ↑ 5.4 26,424 1

Hash Left Join (cost=57,307.06..107,886.31 rows=141,740 width=313) (actual time=148.888..253.541 rows=26,424 loops=1)

  • Output: claim_product.claim_product_id, claim_product.product_id, product.product_name, product.product_number, product_uom_conversions.uom_type_ids, 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, cpl.distributor_invoice_number)
  • Inner Unique: true
  • Hash Cond: ((claim_product.claim_id = cpl.claim_id) AND (claim_product.claim_product_id = cpl.claim_product_id))
  • Buffers: shared hit=254986
2. 12.747 111.472 ↑ 5.4 26,424 1

Hash Join (cost=2,482.57..52,317.68 rows=141,740 width=306) (actual time=25.965..111.472 rows=26,424 loops=1)

  • 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_conversions.uom_type_ids, company.company_name, company.company_number, contract_family.contract_title
  • Inner Unique: true
  • Hash Cond: (claim_product.product_id = product_uom_conversions.product_id)
  • Buffers: shared hit=127925
3. 4.524 95.667 ↑ 1.0 26,424 1

Nested Loop (cost=2,318.34..52,080.54 rows=27,537 width=290) (actual time=22.890..95.667 rows=26,424 loops=1)

  • 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.product_id, company.company_name, company.company_number, contract_family.contract_title
  • Buffers: shared hit=127908
4. 0.003 0.074 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.12..8.68 rows=1 width=46) (actual time=0.046..0.074 rows=1 loops=1)

  • Output: claim.claim_id, contract_family.contract_title
  • Inner Unique: true
  • Buffers: shared hit=11
5. 0.015 0.063 ↑ 1.0 1 1

Nested Loop (cost=0.84..5.38 rows=1 width=20) (actual time=0.036..0.063 rows=1 loops=1)

  • Output: claim.claim_id, claim.contract_sequence
  • Inner Unique: true
  • Buffers: shared hit=8
6. 0.036 0.036 ↑ 1.0 1 1

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

  • 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=4
7. 0.012 0.012 ↑ 1.0 1 1

Index Only Scan using invoice_pkey on client_pinnacle.invoice (cost=0.42..1.94 rows=1 width=16) (actual time=0.012..0.012 rows=1 loops=1)

  • Output: invoice.invoice_id
  • Index Cond: (invoice.invoice_id = claim.invoice_id)
  • Heap Fetches: 0
  • Buffers: shared hit=4
8. 0.008 0.008 ↑ 1.0 1 1

Index Scan using contract_family_unique on client_pinnacle.contract_family (cost=0.28..3.30 rows=1 width=34) (actual time=0.008..0.008 rows=1 loops=1)

  • Output: contract_family.contract_family_id, contract_family.client_id, contract_family.contractee_company_id, contract_family.contractee_grouping_id, contract_family.creator_id, contract_family.contract_sequence, contract_family.cost_basis_type, contract_family.contract_type, contract_family.contract_title, contract_family.contract_template_id, contract_family.payment_calendar_id, contract_family.catch_all, contract_family.import_contract_number, contract_family.accrual_quantity_source
  • Index Cond: (contract_family.contract_sequence = claim.contract_sequence)
  • Buffers: shared hit=3
9. 1.091 91.069 ↑ 1.0 26,424 1

Gather (cost=2,317.21..51,796.49 rows=27,537 width=260) (actual time=22.840..91.069 rows=26,424 loops=1)

  • 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.product_id, company.company_name, company.company_number
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=127897
10. 5.212 89.978 ↑ 1.3 8,808 3

Hash Left Join (cost=1,317.21..48,042.79 rows=11,474 width=260) (actual time=17.173..89.978 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, contract_item.contract_id, contract_item.won, product.product_name, product.product_number, product.product_id, company.company_name, company.company_number
  • Inner Unique: true
  • Hash Cond: (claim_product.distributor_company_id = company.company_id)
  • Buffers: shared hit=127897
  • Worker 0: actual time=14.553..112.449 rows=10521 loops=1
  • Buffers: shared hit=50812
  • Worker 1: actual time=15.055..88.736 rows=9848 loops=1
  • Buffers: shared hit=47589
11. 4.513 79.749 ↑ 1.3 8,808 3

Hash Join (cost=825.57..47,521.02 rows=11,474 width=229) (actual time=12.074..79.749 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, contract_item.contract_id, contract_item.won, product.product_name, product.product_number, product.product_id
  • Inner Unique: true
  • Hash Cond: (claim_product.product_id = product.product_id)
  • Buffers: shared hit=127135
  • Worker 0: actual time=9.014..100.974 rows=10521 loops=1
  • Buffers: shared hit=50558
  • Worker 1: actual time=10.069..77.877 rows=9848 loops=1
  • Buffers: shared hit=47335
12. 6.133 73.704 ↑ 1.3 8,808 3

Hash Left Join (cost=699.94..47,365.21 rows=11,474 width=175) (actual time=10.451..73.704 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, contract_item.contract_id, contract_item.won
  • 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=126864
  • Worker 0: actual time=6.780..93.633 rows=10521 loops=1
  • Buffers: shared hit=50457
  • Worker 1: actual time=8.655..71.391 rows=9848 loops=1
  • Buffers: shared hit=47234
13. 37.378 62.315 ↑ 1.3 8,808 3

Nested Loop Left Join (cost=389.77..46,811.22 rows=11,474 width=191) (actual time=5.152..62.315 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, contract_item.contract_id, contract_item.won, contract_item.uom_type_id
  • Inner Unique: true
  • Buffers: shared hit=126673
  • Worker 0: actual time=0.126..79.920 rows=10521 loops=1
  • Buffers: shared hit=50393
  • Worker 1: actual time=4.217..60.074 rows=9848 loops=1
  • Buffers: shared hit=47170
14. 18.319 24.933 ↑ 1.3 8,808 3

Parallel Bitmap Heap Scan on client_pinnacle.claim_product (cost=389.34..31,480.56 rows=11,474 width=158) (actual time=5.119..24.933 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
  • Recheck Cond: (claim_product.claim_id = '2c3c9316-267c-4439-b4d6-e0f137e32fdf'::uuid)
  • Heap Blocks: exact=4785
  • Buffers: shared hit=20975
  • Worker 0: actual time=0.094..23.337 rows=10521 loops=1
  • Buffers: shared hit=8308
  • Worker 1: actual time=4.179..26.575 rows=9848 loops=1
  • Buffers: shared hit=7777
15. 6.614 6.614 ↑ 1.0 26,424 1

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

  • Index Cond: (claim_product.claim_id = '2c3c9316-267c-4439-b4d6-e0f137e32fdf'::uuid)
  • Buffers: shared hit=105
16. 0.004 0.004 ↑ 1.0 1 26,424

Index Scan using contract_item_pkey on client_pinnacle.contract_item (cost=0.42..1.34 rows=1 width=49) (actual time=0.004..0.004 rows=1 loops=26,424)

  • 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=105698
  • Worker 0: actual time=0.005..0.005 rows=1 loops=10521
  • Buffers: shared hit=42085
  • Worker 1: actual time=0.003..0.003 rows=1 loops=9848
  • Buffers: shared hit=39393
17. 0.804 5.256 ↓ 1.0 2,520 3

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

  • Output: pro.product_id, suomc.uom_type_id, tuomc.uom_type_id
  • Buckets: 4096 Batches: 1 Memory Usage: 229kB
  • Buffers: shared hit=191
  • Worker 0: actual time=6.610..6.610 rows=2520 loops=1
  • Buffers: shared hit=64
  • Worker 1: actual time=4.398..4.398 rows=2520 loops=1
  • Buffers: shared hit=64
18. 0.907 4.452 ↓ 1.0 2,520 3

Hash Join (cost=185.27..266.09 rows=2,519 width=48) (actual time=3.341..4.452 rows=2,520 loops=3)

  • Output: pro.product_id, suomc.uom_type_id, tuomc.uom_type_id
  • Hash Cond: (tuomc.product_id = pro.product_id)
  • Buffers: shared hit=191
  • Worker 0: actual time=4.791..5.836 rows=2520 loops=1
  • Buffers: shared hit=64
  • Worker 1: actual time=2.526..3.602 rows=2520 loops=1
  • Buffers: shared hit=64
19. 0.242 0.242 ↑ 1.0 2,518 3

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

  • Output: tuomc.product_id, tuomc.uom_type_id, tuomc.rate
  • Buffers: shared hit=63
  • Worker 0: actual time=0.015..0.236 rows=2518 loops=1
  • Buffers: shared hit=21
  • Worker 1: actual time=0.015..0.244 rows=2518 loops=1
  • Buffers: shared hit=21
20. 0.606 3.303 ↑ 1.0 2,518 3

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

  • Output: pro.product_id, suomc.product_id, suomc.uom_type_id
  • Buckets: 4096 Batches: 1 Memory Usage: 229kB
  • Buffers: shared hit=128
  • Worker 0: actual time=4.737..4.737 rows=2518 loops=1
  • Buffers: shared hit=43
  • Worker 1: actual time=2.485..2.485 rows=2518 loops=1
  • Buffers: shared hit=43
21. 0.913 2.697 ↑ 1.0 2,518 3

Hash Join (cost=101.00..153.80 rows=2,518 width=48) (actual time=1.562..2.697 rows=2,518 loops=3)

  • 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=128
  • Worker 0: actual time=2.879..4.064 rows=2518 loops=1
  • Buffers: shared hit=43
  • Worker 1: actual time=0.869..1.892 rows=2518 loops=1
  • Buffers: shared hit=43
22. 0.251 0.251 ↑ 1.0 2,518 3

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

  • Output: suomc.product_id, suomc.uom_type_id, suomc.rate
  • Buffers: shared hit=63
  • Worker 0: actual time=0.003..0.242 rows=2518 loops=1
  • Buffers: shared hit=21
  • Worker 1: actual time=0.002..0.224 rows=2518 loops=1
  • Buffers: shared hit=21
23. 0.563 1.533 ↑ 1.0 2,517 3

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

  • Output: pro.product_id
  • Buckets: 4096 Batches: 1 Memory Usage: 150kB
  • Buffers: shared hit=65
  • Worker 0: actual time=2.838..2.838 rows=2517 loops=1
  • Buffers: shared hit=22
  • Worker 1: actual time=0.836..0.836 rows=2517 loops=1
  • Buffers: shared hit=22
24. 0.970 0.970 ↑ 1.0 2,517 3

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

  • Output: pro.product_id
  • Heap Fetches: 0
  • Buffers: shared hit=65
  • Worker 0: actual time=0.036..2.106 rows=2517 loops=1
  • Buffers: shared hit=22
  • Worker 1: actual time=0.023..0.369 rows=2517 loops=1
  • Buffers: shared hit=22
25. 0.802 1.532 ↑ 1.0 2,517 3

Hash (cost=94.17..94.17 rows=2,517 width=54) (actual time=1.532..1.532 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.067..2.067 rows=2517 loops=1
  • Buffers: shared hit=69
  • Worker 1: actual time=1.334..1.334 rows=2517 loops=1
  • Buffers: shared hit=69
26. 0.730 0.730 ↑ 1.0 2,517 3

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

  • Output: product.product_name, product.product_number, product.product_id
  • Buffers: shared hit=207
  • Worker 0: actual time=0.023..0.956 rows=2517 loops=1
  • Buffers: shared hit=69
  • Worker 1: actual time=0.019..0.610 rows=2517 loops=1
  • Buffers: shared hit=69
27. 2.780 5.017 ↑ 1.0 10,562 3

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

  • Output: company.company_name, company.company_number, company.company_id
  • Buckets: 16384 Batches: 1 Memory Usage: 956kB
  • Buffers: shared hit=762
  • Worker 0: actual time=5.434..5.435 rows=10562 loops=1
  • Buffers: shared hit=254
  • Worker 1: actual time=4.883..4.883 rows=10562 loops=1
  • Buffers: shared hit=254
28. 2.237 2.237 ↑ 1.0 10,562 3

Seq Scan on client_pinnacle.company (cost=0.00..359.62 rows=10,562 width=47) (actual time=0.015..2.237 rows=10,562 loops=3)

  • Output: company.company_name, company.company_number, company.company_id
  • Buffers: shared hit=762
  • Worker 0: actual time=0.019..2.404 rows=10562 loops=1
  • Buffers: shared hit=254
  • Worker 1: actual time=0.019..2.053 rows=10562 loops=1
  • Buffers: shared hit=254
29. 0.577 3.058 ↑ 1.0 2,517 1

Hash (cost=132.77..132.77 rows=2,517 width=48) (actual time=3.058..3.058 rows=2,517 loops=1)

  • Output: product_uom_conversions.uom_type_ids, product_uom_conversions.product_id
  • Buckets: 4096 Batches: 1 Memory Usage: 241kB
  • Buffers: shared hit=17
30. 0.356 2.481 ↑ 1.0 2,517 1

Subquery Scan on product_uom_conversions (cost=0.28..132.77 rows=2,517 width=48) (actual time=0.029..2.481 rows=2,517 loops=1)

  • Output: product_uom_conversions.uom_type_ids, product_uom_conversions.product_id
  • Buffers: shared hit=17
31. 1.744 2.125 ↑ 1.0 2,517 1

GroupAggregate (cost=0.28..107.60 rows=2,517 width=48) (actual time=0.029..2.125 rows=2,517 loops=1)

  • Output: product_uom_conversion.product_id, array_agg(product_uom_conversion.uom_type_id)
  • Group Key: product_uom_conversion.product_id
  • Buffers: shared hit=17
32. 0.381 0.381 ↑ 1.0 2,518 1

Index Only Scan using product_uom_conversion_pkey on client_pinnacle.product_uom_conversion (cost=0.28..63.55 rows=2,518 width=32) (actual time=0.019..0.381 rows=2,518 loops=1)

  • Output: product_uom_conversion.product_id, product_uom_conversion.uom_type_id
  • Heap Fetches: 0
  • Buffers: shared hit=17
33. 7.000 122.850 ↓ 1.5 26,424 1

Hash (cost=54,553.65..54,553.65 rows=18,056 width=64) (actual time=122.850..122.850 rows=26,424 loops=1)

  • Output: cpl.distributor_invoice_number, cpl.claim_product_id, cpl.claim_id
  • Buckets: 32768 Batches: 1 Memory Usage: 1934kB
  • Buffers: shared hit=127061
34. 4.342 115.850 ↓ 1.5 26,424 1

Subquery Scan on cpl (cost=53,966.83..54,553.65 rows=18,056 width=64) (actual time=95.973..115.850 rows=26,424 loops=1)

  • Output: cpl.distributor_invoice_number, cpl.claim_product_id, cpl.claim_id
  • Buffers: shared hit=127061
35. 13.086 111.508 ↓ 1.5 26,424 1

GroupAggregate (cost=53,966.83..54,373.09 rows=18,056 width=64) (actual time=95.972..111.508 rows=26,424 loops=1)

  • Output: claim_product_1.claim_id, claim_product_location.claim_product_id, string_agg(claim_product_location.distributor_invoice_number, ', '::text)
  • Group Key: claim_product_1.claim_id, claim_product_location.claim_product_id
  • Buffers: shared hit=127061
36. 14.966 98.422 ↓ 1.5 26,424 1

Sort (cost=53,966.83..54,011.97 rows=18,056 width=33) (actual time=95.959..98.422 rows=26,424 loops=1)

  • Output: claim_product_1.claim_id, claim_product_location.claim_product_id, claim_product_location.distributor_invoice_number
  • Sort Key: claim_product_location.claim_product_id
  • Sort Method: quicksort Memory: 2833kB
  • Buffers: shared hit=127061
37. 11.613 83.456 ↓ 1.5 26,424 1

Gather (cost=1,389.90..52,690.26 rows=18,056 width=33) (actual time=13.003..83.456 rows=26,424 loops=1)

  • Output: claim_product_1.claim_id, claim_product_location.claim_product_id, claim_product_location.distributor_invoice_number
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=127061
38. 46.726 71.843 ↓ 1.2 8,808 3

Nested Loop (cost=389.90..49,884.66 rows=7,523 width=33) (actual time=5.620..71.843 rows=8,808 loops=3)

  • Output: claim_product_1.claim_id, claim_product_location.claim_product_id, claim_product_location.distributor_invoice_number
  • Buffers: shared hit=127061
  • Worker 0: actual time=0.093..69.158 rows=8475 loops=1
  • Buffers: shared hit=40718
  • Worker 1: actual time=4.385..76.032 rows=8739 loops=1
  • Buffers: shared hit=42017
39. 18.331 25.112 ↑ 1.3 8,808 3

Parallel Bitmap Heap Scan on client_pinnacle.claim_product claim_product_1 (cost=389.34..31,480.56 rows=11,474 width=32) (actual time=5.585..25.112 rows=8,808 loops=3)

  • Output: claim_product_1.claim_id, claim_product_1.claim_product_id
  • Recheck Cond: (claim_product_1.claim_id = '2c3c9316-267c-4439-b4d6-e0f137e32fdf'::uuid)
  • Heap Blocks: exact=7250
  • Buffers: shared hit=20975
  • Worker 0: actual time=0.056..19.770 rows=8475 loops=1
  • Buffers: shared hit=6697
  • Worker 1: actual time=4.337..24.551 rows=8739 loops=1
  • Buffers: shared hit=6923
40. 6.781 6.781 ↑ 1.0 26,424 1

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

  • Index Cond: (claim_product_1.claim_id = '2c3c9316-267c-4439-b4d6-e0f137e32fdf'::uuid)
  • Buffers: shared hit=105
41. 0.005 0.005 ↑ 5.0 1 26,424

Index Only Scan using claim_product_location_pkey on client_pinnacle.claim_product_location (cost=0.56..1.55 rows=5 width=17) (actual time=0.004..0.005 rows=1 loops=26,424)

  • Output: claim_product_location.claim_product_id, claim_product_location.location_id, claim_product_location.distributor_invoice_number
  • Index Cond: (claim_product_location.claim_product_id = claim_product_1.claim_product_id)
  • Heap Fetches: 0
  • Buffers: shared hit=106086
  • Worker 0: actual time=0.005..0.005 rows=1 loops=8475
  • Buffers: shared hit=34021
  • Worker 1: actual time=0.005..0.005 rows=1 loops=8739
  • Buffers: shared hit=35094