explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PlSN

Settings
# exclusive inclusive rows x rows loops node
1. 3,169.201 39,119.307 ↓ 1.2 569,837 1

Unique (cost=1,659,939.46..2,082,842.08 rows=476,510 width=6,500) (actual time=31,948.102..39,119.307 rows=569,837 loops=1)

  • Buffers: shared hit=6869032 read=53368 dirtied=3, temp read=203702 written=203791
2. 8,450.003 35,950.106 ↓ 1.2 569,837 1

Sort (cost=1,659,939.46..1,661,130.73 rows=476,510 width=6,500) (actual time=31,948.099..35,950.106 rows=569,837 loops=1)

  • Sort Key: fs.sale_sk, fs.sale_id, fs.product_sk, fs.company_sk, fs.redistributor_company_sk, (COALESCE(fs.invoice_date, fs.sale_reporting_date)), (COALESCE(fs.order_date, fs.sale_reporting_date)), (COALESCE(fs.ship_date, fs.sale_reporting_date)), fs.sale_reporting_date, fs.invoice_number, (CASE WHEN cmp.redistributor_ind THEN 'REDISTRIBUTOR'::text WHEN (fs.redistributor_company_sk <> '-1'::integer) THEN 'INDIRECT'::text WHEN (NOT cmp.redistributor_ind) THEN 'DIRECT'::text ELSE NULL::text END), (COALESCE(fs.sell_to_name, dim_company_sell_to.company_name)), fs.sell_to_number, fs.freight, ((fs.reduction * fs.quantity)), ((((fs.price + fs.freight) - fs.reduction) * fs.quantity)), ((fs.price * fs.quantity)), fs.attribute_01, fs.attribute_02, fs.attribute_03, fs.attribute_04, fs.attribute_05, fs.attribute_06, fs.attribute_07, fs.attribute_08, fs.attribute_09, fs.attribute_10, fs.attribute_11, fs.attribute_12, ((fs.quantity * fpuc.measure_rate_01)), ((fs.quantity * fpuc.measure_rate_02)), ((fs.quantity * fpuc.measure_rate_03)), ((fs.quantity * fpuc.measure_rate_04)), ((fs.quantity * fpuc.measure_rate_05)), ((fs.quantity * fpuc.measure_rate_06)), ((fs.quantity * fpuc.measure_rate_07)), ((fs.quantity * fpuc.measure_rate_08)), ((fs.quantity * fpuc.measure_rate_09)), ((fs.quantity * fpuc.measure_rate_10)), fs.price, fs.quantity, fs.quantity_uom_sk, fs.broker_company_sk, dim_client.client_sk, dim_client.client_id, dim_client.client_name, dim_client.client_description, dim_client.address, dim_client.city, dim_client.region, dim_client.postal_code, dim_client.country, dim_company.company_sk, dim_company.company_id, dim_company.client_sk, dim_company.company_name, dim_company.company_number, dim_company.address, dim_company.postal_code, dim_company.city, dim_company.region, dim_company.country, dim_company.internal_company_type, dim_company.company_type_description, dim_company.attribute_01, dim_company.attribute_02, dim_company.attribute_03, dim_company.attribute_04, dim_company.attribute_05, dim_company.attribute_06, dim_company.attribute_07, dim_company.attribute_08, dim_company.attribute_09, dim_company.attribute_10, dim_company.claim_visibility_grouping_01, dim_company.claim_visibility_grouping_02, dim_company.claim_visibility_grouping_03, dim_company.claim_visibility_grouping_04, dim_company.claim_visibility_grouping_05, dim_company.claim_visibility_grouping_06, dim_company.claim_visibility_grouping_07, dim_company.claim_visibility_grouping_08, dim_company.claim_visibility_grouping_09, dim_company.claim_visibility_grouping_10, dim_company.claim_visibility_grouping_11, dim_company.claim_visibility_grouping_12, dim_company.claim_visibility_grouping_13, dim_company.claim_visibility_grouping_14, dim_company.claim_visibility_grouping_15, dim_company.parent_grouping_01, dim_company.parent_grouping_02, dim_company.parent_grouping_03, dim_company.parent_grouping_04, dim_company.parent_grouping_05, dim_company.parent_grouping_06, dim_company.parent_grouping_07, dim_company.parent_grouping_08, dim_company.parent_grouping_09, dim_company.parent_grouping_10, dim_company.parent_grouping_11, dim_company.parent_grouping_12, dim_company.parent_grouping_13, dim_company.parent_grouping_14, dim_company.parent_grouping_15, dim_company.buying_grouping_01, dim_company.buying_grouping_02, dim_company.buying_grouping_03, dim_company.buying_grouping_04, dim_company.buying_grouping_05, dim_company.buying_grouping_06, dim_company.buying_grouping_07, dim_company.buying_grouping_08, dim_company.buying_grouping_09, dim_company.buying_grouping_10, dim_company.buying_grouping_11, dim_company.buying_grouping_12, dim_company.buying_grouping_13, dim_company.buying_grouping_14, dim_company.buying_grouping_15, dim_company.deduction_interval, dim_company.agg_grouping, dim_company.active_ind, dim_company.redistributor_ind, dim_uom.uom_sk, dim_uom.uom_id, dim_uom.client_sk, dim_uom.uom_description, dim_uom.uom_cd, dim_company_redistributor.company_sk, dim_company_redistributor.company_id, dim_company_redistributor.client_sk, dim_company_redistributor.company_name, dim_company_redistributor.company_number, dim_company_redistributor.address, dim_company_redistributor.postal_code, dim_company_redistributor.city, dim_company_redistributor.region, dim_company_redistributor.country, dim_company_redistributor.internal_company_type, dim_company_redistributor.company_type_description, dim_company_redistributor.attribute_01, dim_company_redistributor.attribute_02, dim_company_redistributor.attribute_03, dim_company_redistributor.attribute_04, dim_company_redistributor.attribute_05, dim_company_redistributor.attribute_06, dim_company_redistributor.attribute_07, dim_company_redistributor.attribute_08, dim_company_redistributor.attribute_09, dim_company_redistributor.attribute_10, dim_company_redistributor.claim_visibility_grouping_01, dim_company_redistributor.claim_visibility_grouping_02, dim_company_redistributor.claim_visibility_grouping_03, dim_company_redistributor.claim_visibility_grouping_04, dim_company_redistributor.claim_visibility_grouping_05, dim_company_redistributor.claim_visibility_grouping_06, dim_company_redistributor.claim_visibility_grouping_07, dim_company_redistributor.claim_visibility_grouping_08, dim_company_redistributor.claim_visibility_grouping_09, dim_company_redistributor.claim_visibility_grouping_10, dim_company_redistributor.claim_visibility_grouping_11, dim_company_redistributor.claim_visibility_grouping_12, dim_company_redistributor.claim_visibility_grouping_13, dim_company_redistributor.claim_visibility_grouping_14, dim_company_redistributor.claim_visibility_grouping_15, dim_company_redistributor.parent_grouping_01, dim_company_redistributor.parent_grouping_02, dim_company_redistributor.parent_grouping_03, dim_company_redistributor.parent_grouping_04, dim_company_redistributor.parent_grouping_05, dim_company_redistributor.parent_grouping_06, dim_company_redistributor.parent_grouping_07, dim_company_redistributor.parent_grouping_08, dim_company_redistributor.parent_grouping_09, dim_company_redistributor.parent_grouping_10, dim_company_redistributor.parent_grouping_11, dim_company_redistributor.parent_grouping_12, dim_company_redistributor.parent_grouping_13, dim_company_redistributor.parent_grouping_14, dim_company_redistributor.parent_grouping_15, dim_company_redistributor.buying_grouping_01, dim_company_redistributor.buying_grouping_02, dim_company_redistributor.buying_grouping_03, dim_company_redistributor.buying_grouping_04, dim_company_redistributor.buying_grouping_05, dim_company_redistributor.buying_grouping_06, dim_company_redistributor.buying_grouping_07, dim_company_redistributor.buying_grouping_08, dim_company_redistributor.buying_grouping_09, dim_company_redistributor.buying_grouping_10, dim_company_redistributor.buying_grouping_11, dim_company_redistributor.buying_grouping_12, dim_company_redistributor.buying_grouping_13, dim_company_redistributor.buying_grouping_14, dim_company_redistributor.buying_grouping_15, dim_company_redistributor.deduction_interval, dim_company_redistributor.agg_grouping, dim_company_redistributor.active_ind, dim_company_redistributor.redistributor_ind, dim_company_broker.company_sk, dim_company_broker.company_id, dim_company_broker.client_sk, dim_company_broker.company_name, dim_company_broker.company_number, dim_company_broker.address, dim_company_broker.postal_code, dim_company_broker.city, dim_company_broker.region, dim_company_broker.country, dim_company_broker.internal_company_type, dim_company_broker.company_type_description, dim_company_broker.attribute_01, dim_company_broker.attribute_02, dim_company_broker.attribute_03, dim_company_broker.attribute_04, dim_company_broker.attribute_05, dim_company_broker.attribute_06, dim_company_broker.attribute_07, dim_company_broker.attribute_08, dim_company_broker.attribute_09, dim_company_broker.attribute_10, dim_company_broker.claim_visibility_grouping_01, dim_company_broker.claim_visibility_grouping_02, dim_company_broker.claim_visibility_grouping_03, dim_company_broker.claim_visibility_grouping_04, dim_company_broker.claim_visibility_grouping_05, dim_company_broker.claim_visibility_grouping_06, dim_company_broker.claim_visibility_grouping_07, dim_company_broker.claim_visibility_grouping_08, dim_company_broker.claim_visibility_grouping_09, dim_company_broker.claim_visibility_grouping_10, dim_company_broker.claim_visibility_grouping_11, dim_company_broker.claim_visibility_grouping_12, dim_company_broker.claim_visibility_grouping_13, dim_company_broker.claim_visibility_grouping_14, dim_company_broker.claim_visibility_grouping_15, dim_company_broker.parent_grouping_01, dim_company_broker.parent_grouping_02, dim_company_broker.parent_grouping_03, dim_company_broker.parent_grouping_04, dim_company_broker.parent_grouping_05, dim_company_broker.parent_grouping_06, dim_company_broker.parent_grouping_07, dim_company_broker.parent_grouping_08, dim_company_broker.parent_grouping_09, dim_company_broker.parent_grouping_10, dim_company_broker.parent_grouping_11, dim_company_broker.parent_grouping_12, dim_company_broker.parent_grouping_13, dim_company_broker.parent_grouping_14, dim_company_broker.parent_grouping_15, dim_company_broker.buying_grouping_01, dim_company_broker.buying_grouping_02, dim_company_broker.buying_grouping_03, dim_company_broker.buying_grouping_04, dim_company_broker.buying_grouping_05, dim_company_broker.buying_grouping_06, dim_company_broker.buying_grouping_07, dim_company_broker.buying_grouping_08, dim_company_broker.buying_grouping_09, dim_company_broker.buying_grouping_10, dim_company_broker.buying_grouping_11, dim_company_broker.buying_grouping_12, dim_company_broker.buying_grouping_13, dim_company_broker.buying_grouping_14, dim_company_broker.buying_grouping_15, dim_company_broker.deduction_interval, dim_company_broker.agg_grouping, dim_company_broker.active_ind, dim_company_broker.redistributor_ind, dim_date.date, dim_date.client_sk, dim_date.year, dim_date.weekly_year, dim_date.month, dim_date.month_name, dim_date.day, dim_date.day_of_week, dim_date.day_of_year, dim_date.weekday_name, dim_date.weekly_week, dim_date.formatted_date, dim_date.quarter, dim_date.year_quarter, dim_date.year_month, dim_date.weekly_year_week, dim_date.weekend, dim_date.current_week_start, dim_date.current_week_end, dim_date.month_start, dim_date.month_end, dim_date.fiscal_year, dim_date.fiscal_quarter, dim_date.fiscal_month, dim_date.fiscal_week, meta_fiscal.date_range, meta_fiscal.client_sk, meta_fiscal.fiscal_year, meta_fiscal.fiscal_quarter, meta_fiscal.fiscal_month, meta_fiscal.fiscal_week, dim_product.product_sk, dim_product.product_id, dim_product.client_sk, dim_product.product_name, dim_product.product_number, dim_product.gtin_number, dim_product.brand_name, dim_product.pack_size_size_uom, dim_product.grouping_01, dim_product.grouping_02, dim_product.grouping_03, dim_product.grouping_04, dim_product.grouping_05, dim_product.grouping_06, dim_product.grouping_07, dim_product.grouping_08, dim_product.grouping_09, dim_product.grouping_10, dim_product.grouping_11, dim_product.grouping_12, dim_product.grouping_13, dim_product.grouping_14, dim_product.grouping_15, dim_product.attribute_01, dim_product.attribute_02, dim_product.attribute_03, dim_product.attribute_04, dim_product.attribute_05, dim_product.attribute_06, dim_product.attribute_07, dim_product.attribute_08, dim_product.attribute_09, dim_product.attribute_10, dim_product.upc_number, dim_product.default_uom, dim_product.active_ind, dim_product.reporting_visibility_ind, dim_product.report_grouping_01, dim_product.report_grouping_02, dim_product.report_grouping_03, dim_product.report_grouping_04, dim_product.report_grouping_05, dim_product.report_grouping_06, dim_product.report_grouping_07, dim_product.report_grouping_08, dim_product.report_grouping_09, dim_product.report_grouping_10, dim_product.report_grouping_11, dim_product.report_grouping_12, dim_product.report_grouping_13, dim_product.report_grouping_14, dim_product.report_grouping_15, dim_company_plan_to.company_number
  • Sort Method: external merge Disk: 1161216kB
  • Buffers: shared hit=6869032 read=53368 dirtied=3, temp read=203702 written=203791
3. 0.000 27,500.103 ↓ 1.2 569,837 1

Gather (cost=97,606.46..760,631.7 rows=476,510 width=6,500) (actual time=3,482.112..27,500.103 rows=569,837 loops=1)

  • Buffers: shared hit=6869007 read=53368 dirtied=3, temp read=58550 written=58612
4. 1,849.128 27,945.827 ↑ 1.0 189,946 3

Hash Join (cost=96,606.46..711,980.7 rows=198,546 width=6,500) (actual time=3,444.79..27,945.827 rows=189,946 loops=3)

  • Buffers: shared hit=6869007 read=53368 dirtied=3, temp read=58550 written=58612
5. 1,204.425 26,096.577 ↑ 1.0 189,946 3

Hash Join (cost=96,601.03..703,491.8 rows=198,546 width=6,062) (actual time=3,444.614..26,096.577 rows=189,946 loops=3)

  • Buffers: shared hit=6869000 read=53366 dirtied=3, temp read=58550 written=58612
6. 2,314.835 24,702.505 ↑ 1.0 189,946 3

Nested Loop (cost=92,304.02..698,163.22 rows=196,409 width=5,909) (actual time=3,254.589..24,702.505 rows=189,946 loops=3)

  • Buffers: shared hit=6868474 read=50269 dirtied=3, temp read=58550 written=58612
7. 959.526 22,387.664 ↑ 1.0 189,946 3

Hash Join (cost=92,303.6..605,531.83 rows=196,409 width=4,389) (actual time=3,254.536..22,387.664 rows=189,946 loops=3)

  • Buffers: shared hit=4589198 read=50197 dirtied=3, temp read=58550 written=58612
8. 937.639 21,343.980 ↑ 1.0 189,946 3

Hash Join (cost=81,754.45..591,892.34 rows=196,409 width=4,367) (actual time=3,170.115..21,343.98 rows=189,946 loops=3)

  • Buffers: shared hit=4587553 read=45970 dirtied=3, temp read=58550 written=58612
9. 13,125.335 20,322.154 ↑ 1.0 189,946 3

Nested Loop (cost=76,853.43..585,960.17 rows=196,409 width=4,315) (actual time=3,085.256..20,322.154 rows=189,946 loops=3)

  • Buffers: shared hit=4587549 read=43491 dirtied=3, temp read=58550 written=58612
10. 1,948.623 7,196.755 ↑ 1.0 189,946 3

Nested Loop (cost=76,853.28..551,067.58 rows=196,409 width=4,281) (actual time=3,083.221..7,196.755 rows=189,946 loops=3)

  • Buffers: shared hit=2305558 read=43481, temp read=58550 written=58612
11. 598.203 5,248.126 ↑ 1.0 189,946 3

Hash Join (cost=76,852.86..458,436.18 rows=196,409 width=2,761) (actual time=3,083.152..5,248.126 rows=189,946 loops=3)

  • Buffers: shared hit=26212 read=43477, temp read=58550 written=58612
12. 555.708 4,649.886 ↑ 1.0 189,946 3

Hash Join (cost=76,851.54..455,734.23 rows=196,409 width=2,656) (actual time=3,083.093..4,649.886 rows=189,946 loops=3)

  • Buffers: shared hit=26209 read=43477, temp read=58550 written=58612
13. 1,434.998 4,070.813 ↑ 1.0 189,946 3

Hash Join (cost=66,534.28..402,695.85 rows=196,409 width=2,647) (actual time=3,059.642..4,070.813 rows=189,946 loops=3)

  • Buffers: shared hit=20374 read=43477, temp read=58550 written=58612
14. 689.734 2,473.318 ↑ 1.0 189,946 3

Hash Join (cost=42,909.76..310,668.74 rows=196,409 width=1,127) (actual time=2,023.978..2,473.318 rows=189,946 loops=3)

  • Buffers: shared hit=14091 read=40290, temp read=16994 written=17024
15. 250.964 1,630.638 ↑ 1.0 189,946 3

Hash Join (cost=24,225.81..269,879.2 rows=196,409 width=206) (actual time=1,047.603..1,630.638 rows=189,946 loops=3)

  • Buffers: shared hit=14025 read=34162
16. 348.591 1,309.642 ↑ 1.0 189,946 3

Bitmap Heap Scan on fact_sale fs (cost=13,246.28..258,384.1 rows=196,409 width=205) (actual time=976.995..1,309.642 rows=189,946 loops=3)

  • Buffers: shared hit=4555 read=34162
17. 961.051 961.051 ↓ 1.2 569,837 1

Bitmap Index Scan on fact_sale_experiment_idx (cost=0..13,128.43 rows=471,381 width=0) (actual time=961.051..961.051 rows=569,837 loops=1)

  • Index Cond: ((fs.client_sk = 11) AND (fs.sale_reporting_date >= '2017-01-01'::date))
  • Buffers: shared read=6200
18. 25.499 70.032 ↑ 1.4 49,440 3

Hash (cost=10,140.9..10,140.9 rows=67,090 width=5) (actual time=70.031..70.032 rows=49,440 loops=3)

  • Buffers: shared hit=9470
19. 44.533 44.533 ↑ 1.4 49,440 3

Seq Scan on dim_company cmp (cost=0..10,140.9 rows=67,090 width=5) (actual time=0.011..44.533 rows=49,440 loops=3)

  • Buffers: shared hit=9470
20. 53.992 152.946 ↑ 1.6 57,752 3

Hash (cost=7,094.43..7,094.43 rows=90,042 width=921) (actual time=152.946..152.946 rows=57,752 loops=3)

  • Buffers: shared hit=66 read=6128, temp written=2212
21. 98.954 98.954 ↑ 1.6 57,752 3

Seq Scan on dim_product dim_product (cost=0..7,094.43 rows=90,042 width=921) (actual time=0.032..98.954 rows=57,752 loops=3)

  • Buffers: shared hit=66 read=6128
22. 67.736 162.497 ↑ 1.4 49,440 3

Hash (cost=10,140.9..10,140.9 rows=67,090 width=1,520) (actual time=162.497..162.497 rows=49,440 loops=3)

  • Buffers: shared hit=6283 read=3187, temp written=3356
23. 94.761 94.761 ↑ 1.4 49,440 3

Seq Scan on dim_company dim_company (cost=0..10,140.9 rows=67,090 width=1,520) (actual time=0.012..94.761 rows=49,440 loops=3)

  • Buffers: shared hit=6283 read=3187
24. 0.054 23.365 ↓ 0.0 0 3

Hash (cost=10,315.98..10,315.98 rows=85 width=40) (actual time=23.365..23.365 rows=0 loops=3)

  • Buffers: shared hit=5835
25. 17.967 23.311 ↓ 0.0 0 3

Bitmap Heap Scan on dim_company dim_company_plan_to (cost=578.93..10,315.98 rows=85 width=40) (actual time=23.311..23.311 rows=0 loops=3)

  • Filter: ((dim_company_plan_to.attribute_01)::text = 'PLAN'::text)
  • Buffers: shared hit=5835
26. 5.344 5.344 ↑ 1.1 39,280 1

Bitmap Index Scan on dim_company_client_sk_idx (cost=0..578.88 rows=42,728 width=0) (actual time=5.344..5.344 rows=39,280 loops=1)

  • Index Cond: (dim_company_plan_to.client_sk = 11)
  • Buffers: shared hit=114
27. 0.005 0.037 ↑ 1.0 1 3

Hash (cost=1.31..1.31 rows=1 width=105) (actual time=0.037..0.037 rows=1 loops=3)

  • Buffers: shared hit=3
28. 0.032 0.032 ↑ 1.0 1 3

Seq Scan on dim_client dim_client (cost=0..1.31 rows=1 width=105) (actual time=0.029..0.032 rows=1 loops=3)

  • Filter: (dim_client.client_sk = 11)
  • Buffers: shared hit=3
29. 0.006 0.006 ↑ 1.0 1 569,837

Index Scan using dim_company_pkey on dim_company dim_company_redistributor (cost=0.42..0.47 rows=1 width=1,520) (actual time=0.006..0.006 rows=1 loops=569,837)

  • Index Cond: (fs.redistributor_company_sk = dim_company_redistributor.company_sk)
  • Buffers: shared hit=2279346 read=4
30. 0.064 0.064 ↑ 1.0 1 569,837

Index Scan using meta_fiscal_date_range_excl on meta_fiscal meta_fiscal (cost=0.14..0.17 rows=1 width=34) (actual time=0.048..0.064 rows=1 loops=569,837)

  • Index Cond: ((fs.client_sk = meta_fiscal.client_sk) AND (meta_fiscal.client_sk = 11) AND (fs.sale_reporting_date <@ meta_fiscal.date_range))
  • Buffers: shared hit=2281991 read=10 dirtied=3
31. 39.464 84.187 ↑ 1.8 54,808 3

Hash (cost=3,450.21..3,450.21 rows=96,721 width=60) (actual time=84.187..84.187 rows=54,808 loops=3)

  • Buffers: shared hit=4 read=2479
32. 44.723 44.723 ↑ 1.8 54,808 3

Seq Scan on fact_product_uom_conversion fpuc (cost=0..3,450.21 rows=96,721 width=60) (actual time=0.035..44.723 rows=54,808 loops=3)

  • Buffers: shared hit=4 read=2479
33. 13.920 84.158 ↑ 1.4 13,093 3

Hash (cost=10,282.1..10,282.1 rows=17,803 width=35) (actual time=84.158..84.158 rows=13,093 loops=3)

  • Buffers: shared hit=1607 read=4227
34. 56.281 70.238 ↑ 1.4 13,093 3

Bitmap Heap Scan on dim_company dim_company_sell_to (cost=589.56..10,282.1 rows=17,803 width=35) (actual time=16.028..70.238 rows=13,093 loops=3)

  • Buffers: shared hit=1607 read=4227
35. 13.957 13.957 ↑ 1.1 39,280 1

Bitmap Index Scan on dim_company_client_sk_idx (cost=0..578.88 rows=42,728 width=0) (actual time=13.957..13.957 rows=39,280 loops=1)

  • Index Cond: (dim_company_sell_to.client_sk = 11)
  • Buffers: shared read=113
36. 0.006 0.006 ↑ 1.0 1 569,837

Index Scan using dim_company_pkey on dim_company dim_company_broker (cost=0.42..0.47 rows=1 width=1,520) (actual time=0.006..0.006 rows=1 loops=569,837)

  • Index Cond: (fs.broker_company_sk = dim_company_broker.company_sk)
  • Buffers: shared hit=2279276 read=72
37. 1.968 189.647 ↑ 1.3 1,948 3

Hash (cost=4,260.07..4,260.07 rows=2,463 width=153) (actual time=189.647..189.647 rows=1,948 loops=3)

  • Buffers: shared hit=402 read=3097
38. 187.679 187.679 ↑ 1.3 1,948 3

Seq Scan on dim_date dim_date (cost=0..4,260.07 rows=2,463 width=153) (actual time=20.175..187.679 rows=1,948 loops=3)

  • Filter: (dim_date.client_sk = 11)
  • Buffers: shared hit=402 read=3097
39. 0.052 0.122 ↑ 1.0 108 3

Hash (cost=4.08..4.08 rows=108 width=52) (actual time=0.122..0.122 rows=108 loops=3)

  • Buffers: shared hit=7 read=2
40. 0.070 0.070 ↑ 1.0 108 3

Seq Scan on dim_uom dim_uom (cost=0..4.08 rows=108 width=52) (actual time=0.018..0.07 rows=108 loops=3)

  • Buffers: shared hit=7 read=2