explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jPIm

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 165.624 ↓ 3.1 31 1

Limit (cost=8,235.53..8,235.56 rows=10 width=1,488) (actual time=165.607..165.624 rows=31 loops=1)

  • Buffers: shared hit=54606
2. 0.417 165.615 ↓ 3.1 31 1

Sort (cost=8,235.53..8,235.56 rows=10 width=1,488) (actual time=165.605..165.615 rows=31 loops=1)

  • Sort Key: product1_.name, product1_.m_product_id
  • Sort Method: top-N heapsort Memory: 56kB
  • Buffers: shared hit=54606
3. 1.457 165.198 ↓ 15.2 152 1

Nested Loop (cost=261.24..8,235.37 rows=10 width=1,488) (actual time=74.827..165.198 rows=152 loops=1)

  • Join Filter: ((obretco_pr0_.m_product_id)::text = (pricingpro2_.m_product_id)::text)
  • Buffers: shared hit=54606
4. 1.175 74.517 ↓ 47.5 285 1

Nested Loop (cost=260.68..5,550.39 rows=6 width=1,527) (actual time=73.379..74.517 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=37604
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.004..0.007 rows=15 loops=1)

  • Buffers: shared hit=1
6. 0.638 73.335 ↓ 47.5 285 15

Materialize (cost=260.68..5,547.91 rows=6 width=1,519) (actual time=0.366..4.889 rows=285 loops=15)

  • Buffers: shared hit=37603
7. 0.329 72.697 ↓ 47.5 285 1

Nested Loop (cost=260.68..5,547.88 rows=6 width=1,519) (actual time=5.482..72.697 rows=285 loops=1)

  • Buffers: shared hit=37603
8. 4.820 70.373 ↓ 47.5 285 1

Nested Loop (cost=260.12..5,510.41 rows=6 width=1,410) (actual time=5.469..70.373 rows=285 loops=1)

  • Buffers: shared hit=36170
9. 19.294 23.205 ↓ 17.3 7,058 1

Bitmap Heap Scan on m_product product1_ (cost=259.56..1,996.08 rows=409 width=1,300) (actual time=5.006..23.205 rows=7,058 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: 567
  • Heap Blocks: exact=7441
  • Buffers: shared hit=7557
10. 0.001 3.911 ↓ 0.0 0 1

BitmapOr (cost=259.56..259.56 rows=448 width=0) (actual time=3.911..3.911 rows=0 loops=1)

  • Buffers: shared hit=116
11. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on em_butgrid_m_product_upc_trgm (cost=0.00..185.91 rows=255 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (upper((upc)::text) ~~ '%ARMOIRE%'::text)
  • Buffers: shared hit=11
12. 3.896 3.896 ↓ 39.5 7,627 1

Bitmap Index Scan on em_butgrid_m_product_name_trgm (cost=0.00..73.45 rows=193 width=0) (actual time=3.896..3.896 rows=7,627 loops=1)

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

Index Scan using obretco_prol_product_act_pl on obretco_prol_product obretco_pr0_ (cost=0.56..8.58 rows=1 width=110) (actual time=0.006..0.006 rows=0 loops=7,058)

  • Index Cond: ((isactive = 'Y'::bpchar) AND ((obretco_productlist_id)::text = '96897ADC710B4BB3BCB58B2DD518F906'::text) AND ((m_product_id)::text = (product1_.m_product_id)::text))
  • Buffers: shared hit=28613
14. 1.995 1.995 ↑ 1.0 1 285

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

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

Index Scan using m_productprice_pricelist_ve_un on m_productprice pricingpro2_ (cost=0.56..2.06 rows=2 width=60) (actual time=0.008..0.008 rows=1 loops=285)

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

SubPlan (forNested Loop)

17. 0.304 80.560 ↓ 0.0 0 152

HashAggregate (cost=200.67..200.68 rows=1 width=8) (actual time=0.530..0.530 rows=0 loops=152)

  • Group Key: butismd_mi3_.nosica_store
  • Buffers: shared hit=10920
18. 12.312 80.256 ↓ 0.0 0 152

Hash Join (cost=16.76..200.66 rows=1 width=8) (actual time=0.396..0.528 rows=0 loops=152)

  • Hash Cond: ((warehouse4_.em_butimwh_noswarehouse_id)::text = (butismd_mi3_.nosica_warehouse)::text)
  • Buffers: shared hit=10920
19. 65.968 65.968 ↓ 1.1 1,735 76

Seq Scan on m_warehouse warehouse4_ (cost=0.00..177.89 rows=1,599 width=14) (actual time=0.001..0.868 rows=1,735 loops=76)

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

Hash (cost=16.75..16.75 rows=1 width=22) (actual time=0.013..0.013 rows=1 loops=152)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=1040
21. 0.152 1.824 ↑ 1.0 1 152

Nested Loop (cost=0.70..16.75 rows=1 width=22) (actual time=0.012..0.012 rows=1 loops=152)

  • Buffers: shared hit=1040
22. 0.304 0.304 ↑ 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.002..0.002 rows=1 loops=152)

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

Index Scan using butismd_ministock_unique on butismd_ministock butismd_mi3_ (cost=0.43..8.45 rows=1 width=22) (actual time=0.008..0.009 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=584
24. 0.760 0.760 ↑ 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.005..0.005 rows=1 loops=152)

  • Index Cond: ((phieco_taxcategory_id)::text = (product_co6_.em_phieco_dea)::text)
  • Buffers: shared hit=596
25. 0.456 0.456 ↑ 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.003..0.003 rows=1 loops=152)

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

Seq Scan on obpos_print_template obpos_prin8_ (cost=0.00..2.50 rows=1 width=42) (actual time=0.004..0.004 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.456 0.456 ↓ 0.0 0 152

Seq Scan on obpos_print_template obpos_prin9_ (cost=0.00..2.50 rows=1 width=4) (actual time=0.003..0.003 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.456 0.456 ↓ 0.0 0 152

Seq Scan on obpos_print_template obpos_prin10_ (cost=0.00..2.50 rows=1 width=5) (actual time=0.003..0.003 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. 0.456 0.456 ↑ 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.003..0.003 rows=1 loops=152)

  • Index Cond: ((product1_.em_phieco_dea)::text = (phieco_taxcategory_id)::text)
  • Buffers: shared hit=596
30. 0.456 0.456 ↑ 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.003..0.003 rows=1 loops=152)

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

Nested Loop (cost=1.26..25.34 rows=1 width=13) (actual time=0.017..0.018 rows=1 loops=152)

  • Buffers: shared hit=1482
32. 0.000 1.976 ↑ 1.0 1 152

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

  • Buffers: shared hit=1150
33. 0.456 0.456 ↑ 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.003..0.003 rows=1 loops=152)

  • Index Cond: ((name)::text = 'Produit.DispoPce'::text)
  • Buffers: shared hit=456
34. 1.520 1.520 ↑ 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.010..0.010 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=694
35. 0.498 0.498 ↑ 1.0 1 83

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

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