explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N27Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 828.674 ↓ 2.8 31 1

Limit (cost=10,570.16..10,570.19 rows=11 width=1,488) (actual time=828.661..828.674 rows=31 loops=1)

  • Buffers: shared hit=69768 read=1532 dirtied=5
2. 1.292 828.670 ↓ 2.8 31 1

Sort (cost=10,570.16..10,570.19 rows=11 width=1,488) (actual time=828.658..828.670 rows=31 loops=1)

  • Sort Key: product1_.name, product1_.m_product_id
  • Sort Method: top-N heapsort Memory: 56kB
  • Buffers: shared hit=69768 read=1532 dirtied=5
3. 3.637 827.378 ↓ 13.8 152 1

Nested Loop (cost=585.71..10,569.97 rows=11 width=1,488) (actual time=218.385..827.378 rows=152 loops=1)

  • Join Filter: ((obretco_pr0_.m_product_id)::text = (pricingpro2_.m_product_id)::text)
  • Buffers: shared hit=69765 read=1532 dirtied=5
4. 3.959 216.786 ↓ 47.5 285 1

Nested Loop (cost=585.02..6,272.07 rows=6 width=1,527) (actual time=212.494..216.786 rows=285 loops=1)

  • Join Filter: ((product1_.c_uom_id)::text = (uom16_.c_uom_id)::text)
  • Rows Removed by Join Filter: 3990
  • Buffers: shared hit=43918 read=899
5. 0.007 0.007 ↑ 1.0 15 1

Seq Scan on c_uom uom16_ (cost=0.00..1.15 rows=15 width=23) (actual time=0.002..0.007 rows=15 loops=1)

  • Buffers: shared hit=1
6. 1.528 212.820 ↓ 47.5 285 15

Materialize (cost=585.02..6,269.58 rows=6 width=1,519) (actual time=0.768..14.188 rows=285 loops=15)

  • Buffers: shared hit=43917 read=899
7. 0.399 211.292 ↓ 47.5 285 1

Nested Loop (cost=585.02..6,269.55 rows=6 width=1,519) (actual time=11.503..211.292 rows=285 loops=1)

  • Buffers: shared hit=43917 read=899
8. 3.987 203.198 ↓ 47.5 285 1

Nested Loop (cost=584.46..6,225.86 rows=6 width=1,410) (actual time=11.456..203.198 rows=285 loops=1)

  • Buffers: shared hit=42483 read=899
9. 92.255 100.287 ↓ 16.3 7,066 1

Bitmap Heap Scan on m_product product1_ (cost=583.78..2,442.47 rows=434 width=1,300) (actual time=9.541..100.287 rows=7,066 loops=1)

  • Recheck Cond: ((upper((upc)::text) ~~ '%ARMOIRE%'::text) OR (upper((name)::text) ~~ '%ARMOIRE%'::text))
  • Rows Removed by Index Recheck: 2
  • Filter: (isactive = 'Y'::bpchar)
  • Rows Removed by Filter: 568
  • Heap Blocks: exact=7455
  • Buffers: shared hit=7742
10. 0.002 8.032 ↓ 0.0 0 1

BitmapOr (cost=583.78..583.78 rows=475 width=0) (actual time=8.032..8.032 rows=0 loops=1)

  • Buffers: shared hit=287
11. 0.228 0.228 ↓ 0.0 0 1

Bitmap Index Scan on em_butgrid_m_product_upc_trgm (cost=0.00..442.02 rows=269 width=0) (actual time=0.228..0.228 rows=0 loops=1)

  • Index Cond: (upper((upc)::text) ~~ '%ARMOIRE%'::text)
  • Buffers: shared hit=20
12. 7.802 7.802 ↓ 37.1 7,636 1

Bitmap Index Scan on em_butgrid_m_product_name_trgm (cost=0.00..141.54 rows=206 width=0) (actual time=7.802..7.802 rows=7,636 loops=1)

  • Index Cond: (upper((name)::text) ~~ '%ARMOIRE%'::text)
  • Buffers: shared hit=267
13. 98.924 98.924 ↓ 0.0 0 7,066

Index Scan using obretco_prol_product_un on obretco_prol_product obretco_pr0_ (cost=0.69..8.71 rows=1 width=110) (actual time=0.014..0.014 rows=0 loops=7,066)

  • Index Cond: (((obretco_productlist_id)::text = '96897ADC710B4BB3BCB58B2DD518F906'::text) AND ((m_product_id)::text = (product1_.m_product_id)::text))
  • Filter: (isactive = 'Y'::bpchar)
  • Buffers: shared hit=34741 read=899
14. 7.695 7.695 ↑ 1.0 1 285

Index Scan using m_product_key on m_product product_co6_ (cost=0.56..7.27 rows=1 width=109) (actual time=0.027..0.027 rows=1 loops=285)

  • Index Cond: ((m_product_id)::text = (obretco_pr0_.m_product_id)::text)
  • Buffers: shared hit=1434
15. 312.075 312.075 ↑ 2.0 1 285

Index Scan using m_productprice_act_plv_pro on m_productprice pricingpro2_ (cost=0.69..2.56 rows=2 width=60) (actual time=1.046..1.095 rows=1 loops=285)

  • Index Cond: ((isactive = 'Y'::bpchar) AND ((m_pricelist_version_id)::text = 'A18A94BC53EC4495A47344F2EE489019'::text) AND ((m_product_id)::text = (product_co6_.m_product_id)::text))
  • Buffers: shared hit=1161 read=427
16.          

SubPlan (forNested Loop)

17. 0.760 275.120 ↓ 0.0 0 152

HashAggregate (cost=322.79..322.81 rows=1 width=8) (actual time=1.810..1.810 rows=0 loops=152)

  • Group Key: butismd_mi3_.nosica_store
  • Buffers: shared hit=19893 read=204 dirtied=5
18. 27.209 274.360 ↓ 0.0 0 152

Hash Join (cost=16.89..322.79 rows=1 width=8) (actual time=1.491..1.805 rows=0 loops=152)

  • Hash Cond: ((warehouse4_.em_butimwh_noswarehouse_id)::text = (butismd_mi3_.nosica_warehouse)::text)
  • Buffers: shared hit=19893 read=204 dirtied=5
19. 165.375 165.375 ↓ 1.1 1,735 75

Seq Scan on m_warehouse warehouse4_ (cost=0.00..299.89 rows=1,599 width=14) (actual time=0.004..2.205 rows=1,735 loops=75)

  • Filter: ((em_butimwh_type_code = '2'::numeric) OR (em_butimwh_type_code = '12'::numeric))
  • Rows Removed by Filter: 1458
  • Buffers: shared hit=18900
20. 0.608 81.776 ↑ 1.0 1 152

Hash (cost=16.88..16.88 rows=1 width=22) (actual time=0.538..0.538 rows=1 loops=152)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=993 read=204 dirtied=5
21. 0.608 81.168 ↑ 1.0 1 152

Nested Loop (cost=0.83..16.88 rows=1 width=22) (actual time=0.409..0.534 rows=1 loops=152)

  • Buffers: shared hit=993 read=204 dirtied=5
22. 1.824 1.824 ↑ 1.0 1 152

Index Scan using obretco_pl_key on obretco_productlist obretco_pr5_ (cost=0.27..8.29 rows=1 width=4) (actual time=0.012..0.012 rows=1 loops=152)

  • Index Cond: ((obretco_pr0_.obretco_productlist_id)::text = (obretco_productlist_id)::text)
  • Buffers: shared hit=456
23. 78.736 78.736 ↑ 1.0 1 152

Index Scan using butismd_ministock_unique on butismd_ministock butismd_mi3_ (cost=0.56..8.57 rows=1 width=22) (actual time=0.393..0.518 rows=1 loops=152)

  • Index Cond: (((nosica_store)::text = (obretco_pr5_.em_butintp_nosica_storeid)::text) AND ((nosica_product)::text = (product1_.em_butintp_idproduit)::text))
  • Buffers: shared hit=537 read=204 dirtied=5
24. 2.128 2.128 ↑ 1.0 1 152

Index Scan using phieco_taxcategory_key on phieco_taxcategory eco (cost=0.41..8.43 rows=1 width=6) (actual time=0.014..0.014 rows=1 loops=152)

  • Index Cond: ((phieco_taxcategory_id)::text = (product_co6_.em_phieco_dea)::text)
  • Buffers: shared hit=601
25. 1.216 1.216 ↑ 1.0 1 152

Index Scan using phieco_taxcategory_key on phieco_taxcategory eco_1 (cost=0.41..8.43 rows=1 width=6) (actual time=0.008..0.008 rows=1 loops=152)

  • Index Cond: ((phieco_taxcategory_id)::text = (product_co6_.em_phieco_deee)::text)
  • Buffers: shared hit=600
26. 1.368 1.368 ↓ 0.0 0 152

Seq Scan on obpos_print_template obpos_prin8_ (cost=0.00..2.50 rows=1 width=42) (actual time=0.009..0.009 rows=0 loops=152)

  • Filter: ((product1_.em_obpgc_printtemplate_id)::text = (obpos_print_template_id)::text)
  • Rows Removed by Filter: 40
  • Buffers: shared hit=304
27. 0.912 0.912 ↓ 0.0 0 152

Seq Scan on obpos_print_template obpos_prin9_ (cost=0.00..2.50 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=152)

  • Filter: ((product1_.em_obpgc_printtemplate_id)::text = (obpos_print_template_id)::text)
  • Rows Removed by Filter: 40
  • Buffers: shared hit=304
28. 0.760 0.760 ↓ 0.0 0 152

Seq Scan on obpos_print_template obpos_prin10_ (cost=0.00..2.50 rows=1 width=5) (actual time=0.005..0.005 rows=0 loops=152)

  • Filter: ((product1_.em_obpgc_printtemplate_id)::text = (obpos_print_template_id)::text)
  • Rows Removed by Filter: 40
  • Buffers: shared hit=304
29. 1.064 1.064 ↑ 1.0 1 152

Index Scan using phieco_taxcategory_key on phieco_taxcategory phieco_tax11_ (cost=0.41..8.43 rows=1 width=6) (actual time=0.007..0.007 rows=1 loops=152)

  • Index Cond: ((product1_.em_phieco_dea)::text = (phieco_taxcategory_id)::text)
  • Buffers: shared hit=601
30. 1.064 1.064 ↑ 1.0 1 152

Index Scan using phieco_taxcategory_key on phieco_taxcategory phieco_tax12_ (cost=0.41..8.43 rows=1 width=6) (actual time=0.007..0.007 rows=1 loops=152)

  • Index Cond: ((product1_.em_phieco_deee)::text = (phieco_taxcategory_id)::text)
  • Buffers: shared hit=600
31. 0.344 11.248 ↑ 1.0 1 152

Nested Loop (cost=1.26..25.28 rows=1 width=13) (actual time=0.073..0.074 rows=1 loops=152)

  • Buffers: shared hit=1479 read=2
32. 0.152 9.576 ↑ 1.0 1 152

Nested Loop (cost=0.83..16.88 rows=1 width=33) (actual time=0.063..0.063 rows=1 loops=152)

  • Buffers: shared hit=1147 read=2
33. 1.064 1.064 ↑ 1.0 1 152

Index Scan using em_butintp_ch_name_client on m_characteristic characteri15_ (cost=0.28..8.29 rows=1 width=33) (actual time=0.007..0.007 rows=1 loops=152)

  • Index Cond: ((name)::text = 'Produit.DispoPce'::text)
  • Buffers: shared hit=456
34. 8.360 8.360 ↑ 1.0 1 152

Index Scan using em_repdf_product_ch_rep on m_product_ch_value productcha13_ (cost=0.56..8.58 rows=1 width=66) (actual time=0.054..0.055 rows=1 loops=152)

  • Index Cond: (((m_product_id)::text = (product1_.m_product_id)::text) AND ((m_characteristic_id)::text = (characteri15_.m_characteristic_id)::text))
  • Buffers: shared hit=691 read=2
35. 1.328 1.328 ↑ 1.0 1 83

Index Scan using m_ch_value_key on m_ch_value characteri14_ (cost=0.42..8.38 rows=1 width=46) (actual time=0.016..0.016 rows=1 loops=83)

  • Index Cond: ((m_ch_value_id)::text = (productcha13_.m_ch_value_id)::text)
  • Buffers: shared hit=332
Planning time : 13.215 ms
Execution time : 829.583 ms