explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aTBn

Settings
# exclusive inclusive rows x rows loops node
1. 20.177 905.958 ↑ 5.4 26,424 1

GroupAggregate (cost=187,361.05..193,030.65 rows=141,740 width=313) (actual time=880.312..905.958 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, string_agg(cpl.distributor_invoice_number, ', '::text))
  • Group Key: claim_product.claim_product_id, product.product_name, product.product_number, product_uom_conversions.uom_type_ids, company.company_name, company.company_number, contract_item.contract_id, contract_family.contract_title, contract_item.won
  • Buffers: shared hit=149053, temp read=1931 written=1931
2. 44.812 885.781 ↑ 5.4 26,424 1

Sort (cost=187,361.05..187,715.40 rows=141,740 width=291) (actual time=880.293..885.781 rows=26,424 loops=1)

  • Output: claim_product.claim_product_id, product.product_name, product.product_number, product_uom_conversions.uom_type_ids, company.company_name, company.company_number, contract_item.contract_id, contract_family.contract_title, contract_item.won, 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, cpl.distributor_invoice_number
  • Sort Key: claim_product.claim_product_id, product.product_name, product.product_number, product_uom_conversions.uom_type_ids, company.company_name, company.company_number, contract_item.contract_id, contract_family.contract_title, contract_item.won
  • Sort Method: external sort Disk: 7744kB
  • Buffers: shared hit=149053, temp read=1931 written=1931
3. 257.815 840.969 ↑ 5.4 26,424 1

Merge Right Join (cost=76,904.39..162,774.90 rows=141,740 width=291) (actual time=170.553..840.969 rows=26,424 loops=1)

  • Output: claim_product.claim_product_id, product.product_name, product.product_number, product_uom_conversions.uom_type_ids, company.company_name, company.company_number, contract_item.contract_id, contract_family.contract_title, contract_item.won, 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, cpl.distributor_invoice_number
  • Merge Cond: (cpl.claim_product_id = claim_product.claim_product_id)
  • Buffers: shared hit=149053, temp read=963 written=963
4. 401.507 401.507 ↑ 1.0 2,965,119 1

Index Only Scan using claim_product_location_pkey on client_pinnacle.claim_product_location cpl (cost=0.56..76,465.05 rows=2,965,433 width=17) (actual time=0.015..401.507 rows=2,965,119 loops=1)

  • Output: cpl.claim_product_id, cpl.location_id, cpl.distributor_invoice_number
  • Heap Fetches: 0
  • Buffers: shared hit=21128
5. 3.799 181.647 ↑ 5.4 26,424 1

Materialize (cost=76,903.84..77,612.54 rows=141,740 width=290) (actual time=170.506..181.647 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, 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
  • Buffers: shared hit=127925, temp read=963 written=963
6. 59.364 177.848 ↑ 5.4 26,424 1

Sort (cost=76,903.84..77,258.19 rows=141,740 width=290) (actual time=170.503..177.848 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, 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
  • Sort Key: claim_product.claim_product_id
  • Sort Method: external sort Disk: 7704kB
  • Buffers: shared hit=127925, temp read=963 written=963
7. 15.390 118.484 ↑ 5.4 26,424 1

Hash Join (cost=2,482.57..52,317.68 rows=141,740 width=290) (actual time=34.789..118.484 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, 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
8. 7.325 100.304 ↑ 1.0 26,424 1

Nested Loop (cost=2,318.34..52,080.54 rows=27,537 width=274) (actual time=31.984..100.304 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, 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
9. 0.002 0.037 ↑ 1.0 1 1

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

  • Output: claim.claim_id, contract_family.contract_title
  • Inner Unique: true
  • Buffers: shared hit=11
10. 0.003 0.028 ↑ 1.0 1 1

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

  • Output: claim.claim_id, claim.contract_sequence
  • Inner Unique: true
  • Buffers: shared hit=8
11. 0.015 0.015 ↑ 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.012..0.015 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
12. 0.010 0.010 ↑ 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.010..0.010 rows=1 loops=1)

  • Output: invoice.invoice_id
  • Index Cond: (invoice.invoice_id = claim.invoice_id)
  • Heap Fetches: 0
  • Buffers: shared hit=4
13. 0.007 0.007 ↑ 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.007..0.007 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
14. 0.000 92.942 ↑ 1.0 26,424 1

Gather (cost=2,317.21..51,796.49 rows=27,537 width=260) (actual time=31.949..92.942 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
15. 6.813 109.471 ↑ 1.3 8,808 3

Hash Left Join (cost=1,317.21..48,042.79 rows=11,474 width=260) (actual time=24.931..109.471 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=17.975..123.581 rows=11721 loops=1
  • Buffers: shared hit=56605
  • Worker 1: actual time=25.708..133.939 rows=10826 loops=1
  • Buffers: shared hit=52221
16. 5.998 94.143 ↑ 1.3 8,808 3

Hash Join (cost=825.57..47,521.02 rows=11,474 width=229) (actual time=16.320..94.143 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.736..106.885 rows=11721 loops=1
  • Buffers: shared hit=56351
  • Worker 1: actual time=16.843..116.483 rows=10826 loops=1
  • Buffers: shared hit=51967
17. 8.210 86.248 ↑ 1.3 8,808 3

Hash Left Join (cost=699.94..47,365.21 rows=11,474 width=175) (actual time=14.341..86.248 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=7.557..97.368 rows=11721 loops=1
  • Buffers: shared hit=56250
  • Worker 1: actual time=14.535..106.621 rows=10826 loops=1
  • Buffers: shared hit=51866
18. 40.412 70.430 ↑ 1.3 8,808 3

Nested Loop Left Join (cost=389.77..46,811.22 rows=11,474 width=191) (actual time=6.688..70.430 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.088..79.737 rows=11721 loops=1
  • Buffers: shared hit=56186
  • Worker 1: actual time=6.527..88.146 rows=10826 loops=1
  • Buffers: shared hit=51802
19. 22.569 30.014 ↑ 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=6.655..30.014 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=3072
  • Buffers: shared hit=20975
  • Worker 0: actual time=0.065..29.924 rows=11721 loops=1
  • Buffers: shared hit=9301
  • Worker 1: actual time=6.487..35.560 rows=10826 loops=1
  • Buffers: shared hit=8497
20. 7.445 7.445 ↑ 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=7.445..7.445 rows=26,424 loops=1)

  • Index Cond: (claim_product.claim_id = '2c3c9316-267c-4439-b4d6-e0f137e32fdf'::uuid)
  • Buffers: shared hit=105
21. 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.003..0.003 rows=1 loops=11721
  • Buffers: shared hit=46885
  • Worker 1: actual time=0.004..0.004 rows=1 loops=10826
  • Buffers: shared hit=43305
22. 1.323 7.608 ↓ 1.0 2,520 3

Hash (cost=266.09..266.09 rows=2,519 width=48) (actual time=7.608..7.608 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=7.427..7.428 rows=2520 loops=1
  • Buffers: shared hit=64
  • Worker 1: actual time=7.946..7.946 rows=2520 loops=1
  • Buffers: shared hit=64
23. 1.527 6.285 ↓ 1.0 2,520 3

Hash Join (cost=185.27..266.09 rows=2,519 width=48) (actual time=4.399..6.285 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.331..6.153 rows=2520 loops=1
  • Buffers: shared hit=64
  • Worker 1: actual time=4.647..6.596 rows=2520 loops=1
  • Buffers: shared hit=64
24. 0.398 0.398 ↑ 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.398 rows=2,518 loops=3)

  • Output: tuomc.product_id, tuomc.uom_type_id, tuomc.rate
  • Buffers: shared hit=63
  • Worker 0: actual time=0.011..0.391 rows=2518 loops=1
  • Buffers: shared hit=21
  • Worker 1: actual time=0.017..0.411 rows=2518 loops=1
  • Buffers: shared hit=21
25. 1.092 4.360 ↑ 1.0 2,518 3

Hash (cost=153.80..153.80 rows=2,518 width=48) (actual time=4.360..4.360 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.285..4.285 rows=2518 loops=1
  • Buffers: shared hit=43
  • Worker 1: actual time=4.599..4.599 rows=2518 loops=1
  • Buffers: shared hit=43
26. 1.426 3.268 ↑ 1.0 2,518 3

Hash Join (cost=101.00..153.80 rows=2,518 width=48) (actual time=1.489..3.268 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=1.534..3.263 rows=2518 loops=1
  • Buffers: shared hit=43
  • Worker 1: actual time=1.589..3.401 rows=2518 loops=1
  • Buffers: shared hit=43
27. 0.381 0.381 ↑ 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.004..0.381 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.372 rows=2518 loops=1
  • Buffers: shared hit=21
  • Worker 1: actual time=0.004..0.390 rows=2518 loops=1
  • Buffers: shared hit=21
28. 0.809 1.461 ↑ 1.0 2,517 3

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

  • Output: pro.product_id
  • Buckets: 4096 Batches: 1 Memory Usage: 150kB
  • Buffers: shared hit=65
  • Worker 0: actual time=1.503..1.503 rows=2517 loops=1
  • Buffers: shared hit=22
  • Worker 1: actual time=1.556..1.556 rows=2517 loops=1
  • Buffers: shared hit=22
29. 0.652 0.652 ↑ 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.033..0.652 rows=2,517 loops=3)

  • Output: pro.product_id
  • Heap Fetches: 0
  • Buffers: shared hit=65
  • Worker 0: actual time=0.048..0.665 rows=2517 loops=1
  • Buffers: shared hit=22
  • Worker 1: actual time=0.034..0.688 rows=2517 loops=1
  • Buffers: shared hit=22
30. 1.029 1.897 ↑ 1.0 2,517 3

Hash (cost=94.17..94.17 rows=2,517 width=54) (actual time=1.897..1.897 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.071..2.071 rows=2517 loops=1
  • Buffers: shared hit=69
  • Worker 1: actual time=2.190..2.190 rows=2517 loops=1
  • Buffers: shared hit=69
31. 0.868 0.868 ↑ 1.0 2,517 3

Seq Scan on client_pinnacle.product (cost=0.00..94.17 rows=2,517 width=54) (actual time=0.015..0.868 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.929 rows=2517 loops=1
  • Buffers: shared hit=69
  • Worker 1: actual time=0.020..0.969 rows=2517 loops=1
  • Buffers: shared hit=69
32. 4.824 8.515 ↑ 1.0 10,562 3

Hash (cost=359.62..359.62 rows=10,562 width=47) (actual time=8.515..8.515 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=8.122..8.122 rows=10562 loops=1
  • Buffers: shared hit=254
  • Worker 1: actual time=8.737..8.737 rows=10562 loops=1
  • Buffers: shared hit=254
33. 3.691 3.691 ↑ 1.0 10,562 3

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

  • Output: company.company_name, company.company_number, company.company_id
  • Buffers: shared hit=762
  • Worker 0: actual time=0.020..3.466 rows=10562 loops=1
  • Buffers: shared hit=254
  • Worker 1: actual time=0.028..3.717 rows=10562 loops=1
  • Buffers: shared hit=254
34. 0.474 2.790 ↑ 1.0 2,517 1

Hash (cost=132.77..132.77 rows=2,517 width=48) (actual time=2.790..2.790 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
35. 0.368 2.316 ↑ 1.0 2,517 1

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

  • Output: product_uom_conversions.uom_type_ids, product_uom_conversions.product_id
  • Buffers: shared hit=17
36. 1.597 1.948 ↑ 1.0 2,517 1

GroupAggregate (cost=0.28..107.60 rows=2,517 width=48) (actual time=0.020..1.948 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
37. 0.351 0.351 ↑ 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.011..0.351 rows=2,518 loops=1)

  • Output: product_uom_conversion.product_id, product_uom_conversion.uom_type_id
  • Heap Fetches: 0
  • Buffers: shared hit=17