explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ynFT

Settings
# exclusive inclusive rows x rows loops node
1. 31.576 186.291 ↓ 3.4 101 1

Limit (cost=43,722.69..44,751.40 rows=30 width=2,811) (actual time=150.639..186.291 rows=101 loops=1)

  • Buffers: shared hit=172,264
2. 0.531 154.715 ↓ 3.4 101 1

Result (cost=43,722.69..44,751.40 rows=30 width=2,811) (actual time=150.637..154.715 rows=101 loops=1)

  • Buffers: shared hit=172,264
3. 2.262 150.447 ↓ 3.4 101 1

Sort (cost=43,722.69..43,722.76 rows=30 width=1,644) (actual time=150.430..150.447 rows=101 loops=1)

  • Sort Key: product1_.name, product1_.m_product_id
  • Sort Method: top-N heapsort Memory: 275kB
  • Buffers: shared hit=169,073
4. 3.413 148.185 ↓ 32.5 974 1

Nested Loop (cost=1,002.23..43,721.95 rows=30 width=1,644) (actual time=1.340..148.185 rows=974 loops=1)

  • Join Filter: ((product1_.c_uom_id)::text = (uom15_.c_uom_id)::text)
  • Rows Removed by Join Filter: 25,324
  • Buffers: shared hit=169,073
5. 0.000 143.798 ↓ 32.5 974 1

Nested Loop Left Join (cost=1,002.23..43,705.40 rows=30 width=1,651) (actual time=1.315..143.798 rows=974 loops=1)

  • Join Filter: ((product1_.m_attributeset_id)::text = (attributes2_.m_attributeset_id)::text)
  • Rows Removed by Join Filter: 974
  • Buffers: shared hit=169,072
6. 32.229 174.526 ↓ 32.5 974 1

Gather (cost=1,002.23..43,703.93 rows=30 width=1,649) (actual time=1.303..174.526 rows=974 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=169,071
7. 0.124 142.297 ↓ 27.1 325 3 / 3

Nested Loop (cost=2.23..42,700.93 rows=12 width=1,649) (actual time=0.763..142.297 rows=325 loops=3)

  • Join Filter: ((obretco_pr0_.m_product_id)::text = (product_co9_.m_product_id)::text)
  • Buffers: shared hit=169,071
8. 0.370 140.550 ↓ 27.1 325 3 / 3

Nested Loop (cost=1.68..42,682.50 rows=12 width=1,641) (actual time=0.750..140.550 rows=325 loops=3)

  • Join Filter: ((obretco_pr0_.m_product_id)::text = (pricingpro3_.m_product_id)::text)
  • Buffers: shared hit=164,196
9. 39.197 136.096 ↑ 1.7 340 3 / 3

Nested Loop (cost=1.12..41,259.06 rows=583 width=1,581) (actual time=0.693..136.096 rows=340 loops=3)

  • Buffers: shared hit=159,127
  • -> Parallel Index Scan using em_butgrid_prol_product_act_pl on obretco_prol_product obretco_pr0_ (cost=0.56..16678.64 rows=10,615 width=141) (actual time=0.030
  • Index Cond: ((isactive = 'Y'::bpchar) AND ((obretco_productlist_id)::text = '598145C1BCA945B8B6FAE1DF40776487'::text))
  • Buffers: shared hit=26,622
10. 96.899 96.899 ↓ 0.0 0 26,427 / 3

Index Scan using m_product_key on m_product product1_ (cost=0.56..2.32 rows=1 width=1,440) (actual time=0.011..0.011 rows=0 loops=26,427)

  • Index Cond: ((m_product_id)::text = (obretco_pr0_.m_product_id)::text)
  • Filter: ((isactive = 'Y'::bpchar) AND ((upper((upc)::text) ~~ '%TAB%'::text) OR (upper((name)::text) ~~ '%TAB%'::text)))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=132,505
11. 4.084 4.084 ↑ 1.0 1 1,021 / 3

Index Scan using em_butgrid_prodpri_act_plv_pr on m_productprice pricingpro3_ (cost=0.56..2.43 rows=1 width=60) (actual time=0.012..0.012 rows=1 loops=1,021)

  • Index Cond: ((isactive = 'Y'::bpchar) AND ((m_pricelist_version_id)::text = '89ADA75AD66049379F3A5090011FEDF5'::text) AND ((m_product_id)::text = (product1_.m_p
  • Buffers: shared hit=5,069
12. 1.623 1.623 ↑ 1.0 1 974 / 3

Index Scan using m_product_key on m_product product_co9_ (cost=0.56..1.52 rows=1 width=107) (actual time=0.005..0.005 rows=1 loops=974)

  • Index Cond: ((m_product_id)::text = (product1_.m_product_id)::text)
  • Buffers: shared hit=4,875
13. 0.000 0.000 ↑ 1.0 1 974

Materialize (cost=0.00..1.01 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=974)

  • Buffers: shared hit=1
14. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on m_attributeset attributes2_ (cost=0.00..1.01 rows=1 width=4) (actual time=0.005..0.006 rows=1 loops=1)

  • Buffers: shared hit=1
15. 0.964 0.974 ↑ 1.3 27 974

Materialize (cost=0.00..1.59 rows=34 width=33) (actual time=0.000..0.001 rows=27 loops=974)

  • Buffers: shared hit=1
16. 0.010 0.010 ↑ 1.3 27 1

Seq Scan on c_uom uom15_ (cost=0.00..1.43 rows=34 width=33) (actual time=0.005..0.010 rows=27 loops=1)

  • Filter: (isactive = 'Y'::bpchar)
  • Buffers: shared hit=1
17.          

SubPlan (for Result)

18. 0.303 0.303 ↑ 1.0 1 101

Index Scan using phieco_taxcategory_key on phieco_taxcategory phieco_tax4_ (cost=0.41..2.63 rows=1 width=6) (actual time=0.003..0.003 rows=1 loops=101)

  • Index Cond: ((product1_.em_phieco_dea)::text = (phieco_taxcategory_id)::text)
  • Buffers: shared hit=276
19. 0.202 0.202 ↑ 1.0 1 101

Index Scan using phieco_taxcategory_key on phieco_taxcategory phieco_tax5_ (cost=0.41..2.63 rows=1 width=6) (actual time=0.002..0.002 rows=1 loops=101)

  • Index Cond: ((product1_.em_phieco_deee)::text = (phieco_taxcategory_id)::text)
  • Buffers: shared hit=320
20. 0.042 1.313 ↓ 0.0 0 101

Nested Loop (cost=1.27..7.93 rows=1 width=13) (actual time=0.013..0.013 rows=0 loops=101)

  • Buffers: shared hit=870
21. 0.101 1.111 ↓ 0.0 0 101

Nested Loop (cost=0.84..5.29 rows=1 width=33) (actual time=0.011..0.011 rows=0 loops=101)

  • Buffers: shared hit=742
22. 0.202 0.202 ↑ 1.0 1 101

Index Scan using em_butintp_ch_name_client on m_characteristic characteri8_ (cost=0.28..2.50 rows=1 width=33) (actual time=0.002..0.002 rows=1 loops=101)

  • Index Cond: ((name)::text = 'Produit.DispoPce'::text)
  • Buffers: shared hit=303
23. 0.808 0.808 ↓ 0.0 0 101

Index Scan using em_repdf_product_ch_rep on m_product_ch_value productcha6_ (cost=0.56..2.78 rows=1 width=66) (actual time=0.008..0.008 rows=0 loops=101)

  • Index Cond: (((m_product_id)::text = (product1_.m_product_id)::text) AND ((m_characteristic_id)::text = (characteri8_.m_characteristic_id)::text))
  • Buffers: shared hit=439
24. 0.160 0.160 ↑ 1.0 1 32

Index Scan using m_ch_value_key on m_ch_value characteri7_ (cost=0.43..2.65 rows=1 width=46) (actual time=0.005..0.005 rows=1 loops=32)

  • Index Cond: ((m_ch_value_id)::text = (productcha6_.m_ch_value_id)::text)
  • Buffers: shared hit=128
25. 0.202 0.202 ↑ 1.0 1 101

Index Scan using phieco_taxcategory_key on phieco_taxcategory eco (cost=0.41..2.63 rows=1 width=6) (actual time=0.002..0.002 rows=1 loops=101)

  • Index Cond: ((phieco_taxcategory_id)::text = (product_co9_.em_phieco_dea)::text)
  • Buffers: shared hit=276
26. 0.202 0.202 ↑ 1.0 1 101

Index Scan using phieco_taxcategory_key on phieco_taxcategory eco_1 (cost=0.41..2.63 rows=1 width=6) (actual time=0.002..0.002 rows=1 loops=101)

  • Index Cond: ((phieco_taxcategory_id)::text = (product_co9_.em_phieco_deee)::text)
  • Buffers: shared hit=320
27. 0.101 1.515 ↓ 0.0 0 101

GroupAggregate (cost=6.36..6.38 rows=1 width=36) (actual time=0.015..0.015 rows=0 loops=101)

  • Group Key: butismd_mi11_.nosica_store
  • Buffers: shared hit=1,028
28. 0.101 1.414 ↑ 1.0 1 101

Sort (cost=6.36..6.37 rows=1 width=8) (actual time=0.014..0.014 rows=1 loops=101)

  • Sort Key: butismd_mi11_.nosica_store
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1,028
29. 0.063 1.313 ↑ 1.0 1 101

Nested Loop (cost=1.11..6.35 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=101)

  • Buffers: shared hit=1,028
30. 0.000 1.010 ↑ 1.0 1 101

Nested Loop (cost=0.83..5.28 rows=1 width=22) (actual time=0.010..0.010 rows=1 loops=101)

  • Buffers: shared hit=788
31. 0.202 0.202 ↑ 1.0 1 101

Index Scan using obretco_pl_key on obretco_productlist obretco_pr13_ (cost=0.27..2.49 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=101)

  • Index Cond: ((obretco_pr0_.obretco_productlist_id)::text = (obretco_productlist_id)::text)
  • Buffers: shared hit=303
32. 0.808 0.808 ↑ 1.0 1 101

Index Scan using butismd_ministock_unique on butismd_ministock butismd_mi11_ (cost=0.56..2.77 rows=1 width=22) (actual time=0.007..0.008 rows=1 loops=101)

  • Index Cond: (((nosica_store)::text = (obretco_pr13_.em_butintp_nosica_storeid)::text) AND ((nosica_product)::text = (product1_.em_butintp_idproduit)::text))
  • Buffers: shared hit=485
33. 0.240 0.240 ↑ 1.0 1 80

Index Scan using em_butimwh_noswarehouse on m_warehouse warehouse12_ (cost=0.28..1.07 rows=1 width=14) (actual time=0.003..0.003 rows=1 loops=80)

  • Index Cond: ((em_butimwh_noswarehouse_id)::text = (butismd_mi11_.nosica_warehouse)::text)
  • Filter: ((em_butimwh_type_code = '2'::numeric) OR (em_butimwh_type_code = '12'::numeric))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=240
34. 0.000 0.000 ↓ 0.0 0 101

Index Scan using m_product_trl_product_langu_un on m_product_trl producttrl14_ (cost=0.14..2.36 rows=1 width=138) (actual time=0.000..0.000 rows=0 loops=101)

  • Index Cond: (((m_product_id)::text = (product1_.m_product_id)::text) AND ((ad_language)::text = 'fr_FR'::text))
  • Buffers: shared hit=101
35. 0.000 0.000 ↓ 0.0 0 101

Index Scan using obpos_printtemplate_pk on obpos_print_template obpos_prin17_ (cost=0.14..2.36 rows=1 width=41) (actual time=0.000..0.000 rows=0 loops=101)

  • Index Cond: ((product1_.em_obpgc_printtemplate_id)::text = (obpos_print_template_id)::text)
36. 0.000 0.000 ↓ 0.0 0 101

Index Scan using obpos_printtemplate_pk on obpos_print_template obpos_prin18_ (cost=0.14..2.36 rows=1 width=2) (actual time=0.000..0.000 rows=0 loops=101)

  • Index Cond: ((product1_.em_obpgc_printtemplate_id)::text = (obpos_print_template_id)::text)
37. 0.000 0.000 ↓ 0.0 0 101

Index Scan using obpos_printtemplate_pk on obpos_print_template obpos_prin19_ (cost=0.14..2.36 rows=1 width=5) (actual time=0.000..0.000 rows=0 loops=101)

  • Index Cond: ((product1_.em_obpgc_printtemplate_id)::text = (obpos_print_template_id)::text)
Planning time : 5.312 ms
Execution time : 186.741 ms