explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ccOw

Settings
# exclusive inclusive rows x rows loops node
1. 29.391 190.760 ↓ 2.4 101 1

Limit (cost=43,738.06..45,596.05 rows=42 width=2,940) (actual time=155.333..190.760 rows=101 loops=1)

  • Buffers: shared hit=189,626
2. 0.751 161.369 ↓ 2.4 101 1

Result (cost=43,738.06..45,596.05 rows=42 width=2,940) (actual time=155.332..161.369 rows=101 loops=1)

  • Buffers: shared hit=189,626
3. 2.167 155.164 ↓ 2.4 101 1

Sort (cost=43,738.06..43,738.17 rows=42 width=1,633) (actual time=155.144..155.164 rows=101 loops=1)

  • Sort Key: product1_.name, product1_.m_product_id
  • Sort Method: top-N heapsort Memory: 274kB
  • Buffers: shared hit=184,961
4. 0.000 152.997 ↓ 24.4 1,025 1

Nested Loop (cost=1,002.23..43,736.93 rows=42 width=1,633) (actual time=1.248..152.997 rows=1,025 loops=1)

  • Join Filter: ((product1_.c_uom_id)::text = (uom18_.c_uom_id)::text)
  • Rows Removed by Join Filter: 26,650
  • Buffers: shared hit=184,961
5. 30.605 177.557 ↓ 24.4 1,025 1

Gather (cost=1,002.23..43,714.35 rows=42 width=1,559) (actual time=1.225..177.557 rows=1,025 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=184,960
6. 0.128 146.952 ↓ 19.0 342 3 / 3

Nested Loop (cost=2.23..42,710.15 rows=18 width=1,559) (actual time=0.386..146.952 rows=342 loops=3)

  • Join Filter: ((obretco_pr0_.m_product_id)::text = (product_co6_.m_product_id)::text)
  • Buffers: shared hit=184,960
7. 0.179 145.116 ↓ 19.0 342 3 / 3

Nested Loop (cost=1.68..42,682.50 rows=18 width=1,551) (actual time=0.375..145.116 rows=342 loops=3)

  • Join Filter: ((obretco_pr0_.m_product_id)::text = (pricingpro2_.m_product_id)::text)
  • Buffers: shared hit=179,828
8. 8.325 140.292 ↑ 1.6 357 3 / 3

Nested Loop (cost=1.12..41,259.06 rows=583 width=1,491) (actual time=0.309..140.292 rows=357 loops=3)

  • Buffers: shared hit=174,497
9. 34.804 34.804 ↑ 1.1 9,716 3 / 3

Parallel Index Scan using em_butgrid_prol_product_act_pl on obretco_prol_product obretco_pr0_ (cost=0.56..16,678.64 rows=10,615 width=141) (actual time=0.036..34.804 rows=9,716 loops=3)

  • Index Cond: ((isactive = 'Y'::bpchar) AND ((obretco_productlist_id)::text = '03259FF5F80645E190D62E9ACCB78FA9'::text))
  • Buffers: shared hit=28,345
10. 97.163 97.163 ↓ 0.0 0 29,149 / 3

Index Scan using m_product_key on m_product product1_ (cost=0.56..2.32 rows=1 width=1,350) (actual time=0.010..0.010 rows=0 loops=29,149)

  • 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=146,152
11. 4.645 4.645 ↑ 1.0 1 1,072 / 3

Index Scan using em_butgrid_prodpri_act_plv_pr on m_productprice pricingpro2_ (cost=0.56..2.43 rows=1 width=60) (actual time=0.013..0.013 rows=1 loops=1,072)

  • Index Cond: ((isactive = 'Y'::bpchar) AND ((m_pricelist_version_id)::text = '9A04114334A949A6868F2FCBBD939393'::text) AND ((m_product_id)::text = (product1_.m_product_id)::text))
  • Buffers: shared hit=5,331
12. 1.708 1.708 ↑ 1.0 1 1,025 / 3

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

  • Index Cond: ((m_product_id)::text = (product1_.m_product_id)::text)
  • Buffers: shared hit=5,132
13. 1.014 1.025 ↑ 1.3 27 1,025

Materialize (cost=0.00..1.51 rows=34 width=33) (actual time=0.000..0.001 rows=27 loops=1,025)

  • Buffers: shared hit=1
14. 0.011 0.011 ↑ 1.3 27 1

Seq Scan on c_uom uom18_ (cost=0.00..1.34 rows=34 width=33) (actual time=0.007..0.011 rows=27 loops=1)

  • Buffers: shared hit=1
15.          

SubPlan (for Result)

16. 0.101 1.818 ↑ 1.0 1 101

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

  • Group Key: butismd_mi3_.nosica_store
  • Buffers: shared hit=1,273
17. 0.101 1.717 ↑ 1.0 1 101

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

  • Sort Key: butismd_mi3_.nosica_store
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1,273
18. 0.000 1.616 ↑ 1.0 1 101

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

  • Buffers: shared hit=1,273
19. 0.101 1.212 ↑ 1.0 1 101

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

  • Buffers: shared hit=850
20. 0.202 0.202 ↑ 1.0 1 101

Index Scan using obretco_pl_key on obretco_productlist obretco_pr5_ (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
21. 0.909 0.909 ↑ 1.0 1 101

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

  • Index Cond: (((nosica_store)::text = (obretco_pr5_.em_butintp_nosica_storeid)::text) AND ((nosica_product)::text = (product1_.em_butintp_idproduit)::text))
  • Buffers: shared hit=547
22. 0.423 0.423 ↑ 1.0 1 141

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

  • Index Cond: ((em_butimwh_noswarehouse_id)::text = (butismd_mi3_.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=423
23. 0.303 0.303 ↑ 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.003..0.003 rows=1 loops=101)

  • Index Cond: ((phieco_taxcategory_id)::text = (product_co6_.em_phieco_dea)::text)
  • Buffers: shared hit=277
24. 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_co6_.em_phieco_deee)::text)
  • Buffers: shared hit=320
25. 0.000 0.000 ↓ 0.0 0 101

Index Scan using obpos_printtemplate_pk on obpos_print_template obpos_prin8_ (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)
26. 0.000 0.000 ↓ 0.0 0 101

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

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

Index Scan using obpos_printtemplate_pk on obpos_print_template obpos_prin10_ (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)
28. 0.000 0.000 ↓ 0.0 0 101

Index Scan using obpos_printtemplate_pk on obpos_print_template obpos_prin11_ (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)
29. 0.202 0.202 ↑ 1.0 1 101

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

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

Index Scan using phieco_taxcategory_key on phieco_taxcategory phieco_tax13_ (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
31. 0.032 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=879
32. 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=743
33. 0.202 0.202 ↑ 1.0 1 101

Index Scan using em_butintp_ch_name_client on m_characteristic characteri16_ (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
34. 0.808 0.808 ↓ 0.0 0 101

Index Scan using em_repdf_product_ch_rep on m_product_ch_value productcha14_ (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 = (characteri16_.m_characteristic_id)::text))
  • Buffers: shared hit=440
35. 0.170 0.170 ↑ 1.0 1 34

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

  • Index Cond: ((m_ch_value_id)::text = (productcha14_.m_ch_value_id)::text)
  • Buffers: shared hit=136
36. 0.000 0.000 ↓ 0.0 0 101

Index Scan using m_product_trl_product_langu_un on m_product_trl producttrl17_ (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
37. 0.101 0.909 ↑ 1.0 1 101

Nested Loop Left Join (cost=0.56..3.80 rows=1 width=1) (actual time=0.009..0.009 rows=1 loops=101)

  • Join Filter: ((product20_.m_attributeset_id)::text = (attributes21_.m_attributeset_id)::text)
  • Rows Removed by Join Filter: 1
  • Buffers: shared hit=609
38. 0.808 0.808 ↑ 1.0 1 101

Index Scan using m_product_key on m_product product20_ (cost=0.56..2.77 rows=1 width=82) (actual time=0.008..0.008 rows=1 loops=101)

  • Index Cond: ((m_product_id)::text = (product1_.m_product_id)::text)
  • Buffers: shared hit=508
39. 0.000 0.000 ↑ 1.0 1 101

Seq Scan on m_attributeset attributes21_ (cost=0.00..1.01 rows=1 width=2) (actual time=0.000..0.000 rows=1 loops=101)

  • Buffers: shared hit=101
40. 0.101 0.505 ↑ 1.0 1 101

Nested Loop Left Join (cost=0.56..3.80 rows=1 width=1) (actual time=0.005..0.005 rows=1 loops=101)

  • Join Filter: ((product22_.m_attributeset_id)::text = (attributes23_.m_attributeset_id)::text)
  • Rows Removed by Join Filter: 1
  • Buffers: shared hit=609
41. 0.404 0.404 ↑ 1.0 1 101

Index Scan using m_product_key on m_product product22_ (cost=0.56..2.77 rows=1 width=82) (actual time=0.004..0.004 rows=1 loops=101)

  • Index Cond: ((m_product_id)::text = (product1_.m_product_id)::text)
  • Buffers: shared hit=508
42. 0.000 0.000 ↑ 1.0 1 101

Seq Scan on m_attributeset attributes23_ (cost=0.00..1.01 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=101)

  • Buffers: shared hit=101
Planning time : 3.528 ms
Execution time : 191.027 ms