explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HwDn : samuel

Settings
# exclusive inclusive rows x rows loops node
1. 54.536 5,179,007.859 ↑ 1.0 2,030 1

Nested Loop (cost=0.00..1,585,328,348.75 rows=2,030 width=102) (actual time=4,362.652..5,179,007.859 rows=2,030 loops=1)

  • Output: c_salesregion.value, m_product.name, ((((SubPlan 1))::numeric * '100'::numeric) / (NULLIF((SubPlan 2), 0))::numeric), ((((SubPlan 3) * 100))::numeric(10,2) / (NULLIF((SubPlan 4), 0))::numeric(10,2))
  • Buffers: shared hit=38244639 read=728042392
2. 0.097 0.097 ↑ 1.0 58 1

Seq Scan on public.c_salesregion (cost=0.00..3.58 rows=58 width=42) (actual time=0.006..0.097 rows=58 loops=1)

  • Output: c_salesregion.c_salesregion_id, c_salesregion.ad_client_id, c_salesregion.ad_org_id, c_salesregion.isactive, c_salesregion.created, c_salesregion.createdby, c_salesregion.updated, c_salesregion.updatedby, c_salesregion.value, c_salesregion.name, c_salesregion.description, c_salesregion.issummary, c_salesregion.salesrep_id, c_salesregion.isdefault, c_salesregion.em_pm_territorial_id, c_salesregion.em_smfpda_shipper, c_salesregion.em_smfpda_rolepda, c_salesregion.em_smfpda_salesman, c_salesregion.em_smfpda_isdefault, c_salesregion.em_smfpda_sendpda
  • Buffers: shared hit=3
3. 1.952 15.196 ↑ 1.0 35 58

Materialize (cost=0.00..1,655.49 rows=35 width=62) (actual time=0.139..0.262 rows=35 loops=58)

  • Output: m_product.name, m_product.m_product_id
  • Buffers: shared hit=1357
4. 13.244 13.244 ↑ 1.0 35 1

Seq Scan on public.m_product (cost=0.00..1,655.32 rows=35 width=62) (actual time=8.032..13.244 rows=35 loops=1)

  • Output: m_product.name, m_product.m_product_id
  • Filter: ((m_product.em_vd_isvd = 'Y'::bpchar) AND (m_product.isactive = 'Y'::bpchar))
  • Rows Removed by Filter: 19853
  • Buffers: shared hit=1357
5.          

SubPlan (forNested Loop)

6. 24.360 27,287.260 ↑ 1.0 1 2,030

Aggregate (cost=2,069.06..2,069.07 rows=1 width=8) (actual time=13.441..13.442 rows=1 loops=2,030)

  • Output: count(*)
  • Buffers: shared hit=3895365 read=2810
7. 56.630 27,262.900 ↓ 1.5 48 2,030

Nested Loop (cost=0.42..2,068.99 rows=31 width=0) (actual time=6.986..13.430 rows=48 loops=2,030)

  • Buffers: shared hit=3895365 read=2810
8. 24,727.430 24,727.430 ↓ 1.1 102 2,030

Seq Scan on public.c_bpartner (cost=0.00..1,849.26 rows=90 width=33) (actual time=5.040..12.181 rows=102 loops=2,030)

  • Output: c_bpartner.c_bpartner_id, c_bpartner.ad_client_id, c_bpartner.ad_org_id, c_bpartner.isactive, c_bpartner.created, c_bpartner.createdby, c_bpartner.updated, c_bpartner.updatedby, c_bpartner.value, c_bpartner.name, c_bpartner.name2, c_bpartner.description, c_bpartner.issummary, c_bpartner.c_bp_group_id, c_bpartner.isonetime, c_bpartner.isprospect, c_bpartner.isvendor, c_bpartner.iscustomer, c_bpartner.isemployee, c_bpartner.issalesrep, c_bpartner.referenceno, c_bpartner.duns, c_bpartner.url, c_bpartner.ad_language, c_bpartner.taxid, c_bpartner.istaxexempt, c_bpartner.c_invoiceschedule_id, c_bpartner.rating, c_bpartner.salesvolume, c_bpartner.numberemployees, c_bpartner.naics, c_bpartner.firstsale, c_bpartner.acqusitioncost, c_bpartner.potentiallifetimevalue, c_bpartner.actuallifetimevalue, c_bpartner.shareofcustomer, c_bpartner.paymentrule, c_bpartner.so_creditlimit, c_bpartner.so_creditused, c_bpartner.c_paymentterm_id, c_bpartner.m_pricelist_id, c_bpartner.isdiscountprinted, c_bpartner.so_description, c_bpartner.poreference, c_bpartner.paymentrulepo, c_bpartner.po_pricelist_id, c_bpartner.po_paymentterm_id, c_bpartner.documentcopies, c_bpartner.c_greeting_id, c_bpartner.invoicerule, c_bpartner.deliveryrule, c_bpartner.deliveryviarule, c_bpartner.salesrep_id, c_bpartner.bpartner_parent_id, c_bpartner.socreditstatus, c_bpartner.ad_forced_org_id, c_bpartner.showpriceinorder, c_bpartner.invoicegrouping, c_bpartner.fixmonthday, c_bpartner.fixmonthday2, c_bpartner.fixmonthday3, c_bpartner.isworker, c_bpartner.upc, c_bpartner.c_salary_category_id, c_bpartner.invoice_printformat, c_bpartner.last_days, c_bpartner.po_bankaccount_id, c_bpartner.po_bp_taxcategory_id, c_bpartner.po_fixmonthday, c_bpartner.po_fixmonthday2, c_bpartner.po_fixmonthday3, c_bpartner.so_bankaccount_id, c_bpartner.so_bp_taxcategory_id, c_bpartner.fiscalcode, c_bpartner.isofiscalcode, c_bpartner.po_c_incoterms_id, c_bpartner.so_c_incoterms_id, c_bpartner.fin_paymentmethod_id, c_bpartner.po_paymentmethod_id, c_bpartner.fin_financial_account_id, c_bpartner.po_financial_account_id, c_bpartner.em_ae_unitcost_id, c_bpartner.em_ca_assignedcar, c_bpartner.em_ca_carplate, c_bpartner.em_ca_liters, c_bpartner.em_pm_vdvalue, c_bpartner.em_pm_market, c_bpartner.em_pm_territorial_id, c_bpartner.em_pm_complex_id, c_bpartner.em_pm_trade_id, c_bpartner.em_pm_supertrade_id, c_bpartner.em_pm_mincexregistered, c_bpartner.em_pm_mincexcode, c_bpartner.em_pm_national, c_bpartner.em_pm_identitycard, c_bpartner.em_pm_collectionarea_id, c_bpartner.em_pm_isproducer, c_bpartner.em_pm_ismerchandiser, c_bpartner.em_pm_isaei, c_bpartner.em_pm_isvd, c_bpartner.em_pm_clienttype, c_bpartner.em_cuvddm_csalesregionid, c_bpartner.em_cuvddm_visitfreq, c_bpartner.em_cuvddm_deliveryfreq, c_bpartner.em_cuvddm_cec_id, c_bpartner.em_cuvddm_plistcentmaint, c_bpartner.em_cuvddm_activity_id, c_bpartner.em_cuvddm_vdpayer, c_bpartner.em_cuvddm_lastinvrecepday, c_bpartner.em_cuvddm_verifdigit, c_bpartner.em_cuvddm_vdmoddate, c_bpartner.em_cuvddm_weeklyvolume, c_bpartner.em_cuvddm_routemoddate, c_bpartner.em_cuvddm_deactstatus, c_bpartner.em_cuvddm_visittype, c_bpartner.em_cuvddm_merchandising, c_bpartner.em_cuvddm_regdate, c_bpartner.em_cuvddm_reactdate, c_bpartner.em_cuvddm_deactdate, c_bpartner.em_cuvddm_visitweek, c_bpartner.em_cuvddm_distchannel_id, c_bpartner.em_cuvddm_merchactdate, c_bpartner.em_cuvddm_workdays, c_bpartner.em_cuvddm_anniversarydate, c_bpartner.em_cuvddm_isdealer, c_bpartner.em_cuvddm_issalesman, c_bpartner.em_cuvddm_van, c_bpartner.em_cuvddm_aveweekvol, c_bpartner.em_cuvddm_avebydelivvol, c_bpartner.em_vd_parent_id, c_bpartner.em_smfpda_hasmerchandising, c_bpartner.em_smfpda_placetype, c_bpartner.em_smfpda_client, c_bpartner.em_smfpda_merchcover, c_bpartner.em_smfpda_zonetlv, c_bpartner.em_smfpda_zonerm, c_bpartner.em_smfpda_isemployeevd, c_bpartner.em_smfpda_paid, c_bpartner.em_smfpda_ispotential, c_bpartner.em_smfpda_ispostponedinv, c_bpartner.em_smfpda_updated, c_bpartner.em_smfpda_tendency, c_bpartner.em_smfpda_mvd, c_bpartner.em_smfpda_missingvol, c_bpartner.em_smfpda_fromimportxls, c_bpartner.em_smfpda_manualsearchkey, c_bpartner.em_smfpda_defpotencial
  • Filter: (((c_bpartner.value)::text ~~ '010PV%'::text) AND ((c_bpartner.em_smfpda_placetype)::text = 'E'::text) AND (c_bpartner.em_cuvddm_deactstatus = '1'::bpchar) AND ((c_bpartner.em_cuvddm_csalesregionid)::text = (c_salesregion.c_salesregion_id)::text))
  • Rows Removed by Filter: 14111
  • Buffers: shared hit=3176950
9. 2,478.840 2,478.840 ↓ 0.0 0 206,570

Index Scan using smfpda_uk_clientprod on public.smfpda_clientprod (cost=0.42..2.43 rows=1 width=33) (actual time=0.012..0.012 rows=0 loops=206,570)

  • Output: smfpda_clientprod.smfpda_clientprod_id, smfpda_clientprod.ad_client_id, smfpda_clientprod.ad_org_id, smfpda_clientprod.isactive, smfpda_clientprod.created, smfpda_clientprod.createdby, smfpda_clientprod.updated, smfpda_clientprod.updatedby, smfpda_clientprod.c_bpartner_id, smfpda_clientprod.m_product_id, smfpda_clientprod.date_first_sale, smfpda_clientprod.pda_updated
  • Index Cond: (((smfpda_clientprod.c_bpartner_id)::text = (c_bpartner.c_bpartner_id)::text) AND ((smfpda_clientprod.m_product_id)::text = (m_product.m_product_id)::text))
  • Filter: (smfpda_clientprod.isactive = 'Y'::bpchar)
  • Buffers: shared hit=718415 read=2810
10. 28.420 19,021.100 ↑ 1.0 1 2,030

Aggregate (cost=1,768.18..1,768.19 rows=1 width=8) (actual time=9.370..9.370 rows=1 loops=2,030)

  • Output: count(*)
  • Buffers: shared hit=3903690
11. 18,992.680 18,992.680 ↓ 1.3 102 2,030

Index Scan using em_pm_cbpartner_isvd on public.c_bpartner c_bpartner_1 (cost=0.29..1,767.98 rows=79 width=0) (actual time=3.581..9.356 rows=102 loops=2,030)

  • Output: c_bpartner_1.c_bpartner_id, c_bpartner_1.ad_client_id, c_bpartner_1.ad_org_id, c_bpartner_1.isactive, c_bpartner_1.created, c_bpartner_1.createdby, c_bpartner_1.updated, c_bpartner_1.updatedby, c_bpartner_1.value, c_bpartner_1.name, c_bpartner_1.name2, c_bpartner_1.description, c_bpartner_1.issummary, c_bpartner_1.c_bp_group_id, c_bpartner_1.isonetime, c_bpartner_1.isprospect, c_bpartner_1.isvendor, c_bpartner_1.iscustomer, c_bpartner_1.isemployee, c_bpartner_1.issalesrep, c_bpartner_1.referenceno, c_bpartner_1.duns, c_bpartner_1.url, c_bpartner_1.ad_language, c_bpartner_1.taxid, c_bpartner_1.istaxexempt, c_bpartner_1.c_invoiceschedule_id, c_bpartner_1.rating, c_bpartner_1.salesvolume, c_bpartner_1.numberemployees, c_bpartner_1.naics, c_bpartner_1.firstsale, c_bpartner_1.acqusitioncost, c_bpartner_1.potentiallifetimevalue, c_bpartner_1.actuallifetimevalue, c_bpartner_1.shareofcustomer, c_bpartner_1.paymentrule, c_bpartner_1.so_creditlimit, c_bpartner_1.so_creditused, c_bpartner_1.c_paymentterm_id, c_bpartner_1.m_pricelist_id, c_bpartner_1.isdiscountprinted, c_bpartner_1.so_description, c_bpartner_1.poreference, c_bpartner_1.paymentrulepo, c_bpartner_1.po_pricelist_id, c_bpartner_1.po_paymentterm_id, c_bpartner_1.documentcopies, c_bpartner_1.c_greeting_id, c_bpartner_1.invoicerule, c_bpartner_1.deliveryrule, c_bpartner_1.deliveryviarule, c_bpartner_1.salesrep_id, c_bpartner_1.bpartner_parent_id, c_bpartner_1.socreditstatus, c_bpartner_1.ad_forced_org_id, c_bpartner_1.showpriceinorder, c_bpartner_1.invoicegrouping, c_bpartner_1.fixmonthday, c_bpartner_1.fixmonthday2, c_bpartner_1.fixmonthday3, c_bpartner_1.isworker, c_bpartner_1.upc, c_bpartner_1.c_salary_category_id, c_bpartner_1.invoice_printformat, c_bpartner_1.last_days, c_bpartner_1.po_bankaccount_id, c_bpartner_1.po_bp_taxcategory_id, c_bpartner_1.po_fixmonthday, c_bpartner_1.po_fixmonthday2, c_bpartner_1.po_fixmonthday3, c_bpartner_1.so_bankaccount_id, c_bpartner_1.so_bp_taxcategory_id, c_bpartner_1.fiscalcode, c_bpartner_1.isofiscalcode, c_bpartner_1.po_c_incoterms_id, c_bpartner_1.so_c_incoterms_id, c_bpartner_1.fin_paymentmethod_id, c_bpartner_1.po_paymentmethod_id, c_bpartner_1.fin_financial_account_id, c_bpartner_1.po_financial_account_id, c_bpartner_1.em_ae_unitcost_id, c_bpartner_1.em_ca_assignedcar, c_bpartner_1.em_ca_carplate, c_bpartner_1.em_ca_liters, c_bpartner_1.em_pm_vdvalue, c_bpartner_1.em_pm_market, c_bpartner_1.em_pm_territorial_id, c_bpartner_1.em_pm_complex_id, c_bpartner_1.em_pm_trade_id, c_bpartner_1.em_pm_supertrade_id, c_bpartner_1.em_pm_mincexregistered, c_bpartner_1.em_pm_mincexcode, c_bpartner_1.em_pm_national, c_bpartner_1.em_pm_identitycard, c_bpartner_1.em_pm_collectionarea_id, c_bpartner_1.em_pm_isproducer, c_bpartner_1.em_pm_ismerchandiser, c_bpartner_1.em_pm_isaei, c_bpartner_1.em_pm_isvd, c_bpartner_1.em_pm_clienttype, c_bpartner_1.em_cuvddm_csalesregionid, c_bpartner_1.em_cuvddm_visitfreq, c_bpartner_1.em_cuvddm_deliveryfreq, c_bpartner_1.em_cuvddm_cec_id, c_bpartner_1.em_cuvddm_plistcentmaint, c_bpartner_1.em_cuvddm_activity_id, c_bpartner_1.em_cuvddm_vdpayer, c_bpartner_1.em_cuvddm_lastinvrecepday, c_bpartner_1.em_cuvddm_verifdigit, c_bpartner_1.em_cuvddm_vdmoddate, c_bpartner_1.em_cuvddm_weeklyvolume, c_bpartner_1.em_cuvddm_routemoddate, c_bpartner_1.em_cuvddm_deactstatus, c_bpartner_1.em_cuvddm_visittype, c_bpartner_1.em_cuvddm_merchandising, c_bpartner_1.em_cuvddm_regdate, c_bpartner_1.em_cuvddm_reactdate, c_bpartner_1.em_cuvddm_deactdate, c_bpartner_1.em_cuvddm_visitweek, c_bpartner_1.em_cuvddm_distchannel_id, c_bpartner_1.em_cuvddm_merchactdate, c_bpartner_1.em_cuvddm_workdays, c_bpartner_1.em_cuvddm_anniversarydate, c_bpartner_1.em_cuvddm_isdealer, c_bpartner_1.em_cuvddm_issalesman, c_bpartner_1.em_cuvddm_van, c_bpartner_1.em_cuvddm_aveweekvol, c_bpartner_1.em_cuvddm_avebydelivvol, c_bpartner_1.em_vd_parent_id, c_bpartner_1.em_smfpda_hasmerchandising, c_bpartner_1.em_smfpda_placetype, c_bpartner_1.em_smfpda_client, c_bpartner_1.em_smfpda_merchcover, c_bpartner_1.em_smfpda_zonetlv, c_bpartner_1.em_smfpda_zonerm, c_bpartner_1.em_smfpda_isemployeevd, c_bpartner_1.em_smfpda_paid, c_bpartner_1.em_smfpda_ispotential, c_bpartner_1.em_smfpda_ispostponedinv, c_bpartner_1.em_smfpda_updated, c_bpartner_1.em_smfpda_tendency, c_bpartner_1.em_smfpda_mvd, c_bpartner_1.em_smfpda_missingvol, c_bpartner_1.em_smfpda_fromimportxls, c_bpartner_1.em_smfpda_manualsearchkey, c_bpartner_1.em_smfpda_defpotencial
  • Index Cond: (c_bpartner_1.em_pm_isvd = 'Y'::bpchar)
  • Filter: (((c_bpartner_1.value)::text ~~ '010PV%'::text) AND ((c_bpartner_1.em_cuvddm_csalesregionid)::text = (c_salesregion.c_salesregion_id)::text) AND ((c_bpartner_1.em_smfpda_placetype)::text = 'E'::text) AND (c_bpartner_1.em_cuvddm_deactstatus = '1'::bpchar))
  • Rows Removed by Filter: 12354
  • Buffers: shared hit=3903690
12. 20.300 2,698,911.390 ↑ 1.0 1 2,030

Aggregate (cost=396,295.28..396,295.29 rows=1 width=8) (actual time=1,329.513..1,329.513 rows=1 loops=2,030)

  • Output: count(*)
  • Buffers: shared hit=6593734 read=364019807
13. 342.012 2,698,891.090 ↓ 2.0 16 2,030

Nested Loop (cost=1,737.69..396,295.26 rows=8 width=0) (actual time=1,039.117..1,329.503 rows=16 loops=2,030)

  • Buffers: shared hit=6593734 read=364019807
14. 13,882.785 2,692,795.000 ↓ 2.7 315 2,030

Hash Join (cost=1,737.26..396,189.85 rows=116 width=33) (actual time=227.829..1,326.500 rows=315 loops=2,030)

  • Output: smfpda_productinfo.smfpda_visit_id
  • Hash Cond: ((smfpda_productinfo.c_bpartner_id)::text = (c_bpartner_2.c_bpartner_id)::text)
  • Buffers: shared hit=4023708 read=364019807
15. 2,666,147.575 2,666,147.575 ↑ 1.0 47,128 1,225

Seq Scan on public.smfpda_productinfo (cost=0.00..394,269.50 rows=48,513 width=66) (actual time=316.282..2,176.447 rows=47,128 loops=1,225)

  • Output: smfpda_productinfo.smfpda_productinfo_id, smfpda_productinfo.ad_client_id, smfpda_productinfo.ad_org_id, smfpda_productinfo.isactive, smfpda_productinfo.created, smfpda_productinfo.createdby, smfpda_productinfo.updated, smfpda_productinfo.updatedby, smfpda_productinfo.smfpda_visit_id, smfpda_productinfo.quantity, smfpda_productinfo.m_product_id, smfpda_productinfo.c_uom_id, smfpda_productinfo.c_bpartner_id, smfpda_productinfo.pda_updated
  • Filter: ((smfpda_productinfo.quantity = '0'::numeric) AND ((smfpda_productinfo.m_product_id)::text = (m_product.m_product_id)::text))
  • Rows Removed by Filter: 6420868
  • Buffers: shared hit=120018 read=364019807
16. 46.690 12,764.640 ↓ 2.6 88 2,030

Hash (cost=1,736.84..1,736.84 rows=34 width=33) (actual time=6.288..6.288 rows=88 loops=2,030)

  • Output: c_bpartner_2.c_bpartner_id
  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=3903690
17. 12,717.950 12,717.950 ↓ 2.6 88 2,030

Index Scan using em_pm_cbpartner_isvd on public.c_bpartner c_bpartner_2 (cost=0.29..1,736.84 rows=34 width=33) (actual time=2.489..6.265 rows=88 loops=2,030)

  • Output: c_bpartner_2.c_bpartner_id
  • Index Cond: (c_bpartner_2.em_pm_isvd = 'Y'::bpchar)
  • Filter: ((c_bpartner_2.em_cuvddm_avebydelivvol IS NOT NULL) AND ((c_bpartner_2.em_cuvddm_csalesregionid)::text = (c_salesregion.c_salesregion_id)::text) AND ((c_bpartner_2.em_smfpda_placetype)::text = 'E'::text) AND (c_bpartner_2.em_cuvddm_deactstatus = '1'::bpchar))
  • Rows Removed by Filter: 12368
  • Buffers: shared hit=3903690
18. 5,754.078 5,754.078 ↓ 0.0 0 639,342

Index Scan using smfpda_visit_key on public.smfpda_visit (cost=0.42..0.90 rows=1 width=33) (actual time=0.009..0.009 rows=0 loops=639,342)

  • Output: smfpda_visit.smfpda_visit_id, smfpda_visit.ad_client_id, smfpda_visit.ad_org_id, smfpda_visit.isactive, smfpda_visit.created, smfpda_visit.createdby, smfpda_visit.updated, smfpda_visit.updatedby, smfpda_visit.visitdate, smfpda_visit.c_bpartner_id, smfpda_visit.smfpda_workday_id, smfpda_visit.noattentionreasonam, smfpda_visit.started, smfpda_visit.ended, smfpda_visit.totaltime, smfpda_visit.noattentionreasond, smfpda_visit.noattentionreasonv, smfpda_visit.noattentionreasontlv, smfpda_visit.noattentionreasonrm, smfpda_visit.isreconciled, smfpda_visit.status_fact, smfpda_visit.outruote, smfpda_visit.pda_updated
  • Index Cond: ((smfpda_visit.smfpda_visit_id)::text = (smfpda_productinfo.smfpda_visit_id)::text)
  • Filter: ((smfpda_visit.visitdate >= '2018-10-01'::date) AND (smfpda_visit.visitdate <= '2018-10-31'::date) AND ((smfpda_visit.outruote)::text <> 'F'::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=2570026
19. 62.930 2,433,718.280 ↑ 1.0 1 2,030

Aggregate (cost=380,816.50..380,816.51 rows=1 width=8) (actual time=1,198.876..1,198.876 rows=1 loops=2,030)

  • Output: count(*)
  • Buffers: shared hit=23850490 read=364019775
20. 3,575.418 2,433,655.350 ↓ 5.0 160 2,030

Nested Loop (cost=1,737.69..380,816.42 rows=32 width=0) (actual time=918.193..1,198.845 rows=160 loops=2,030)

  • Buffers: shared hit=23850490 read=364019775
21. 46,464.670 2,395,550.220 ↓ 5.3 2,430 2,030

Hash Join (cost=1,737.26..380,555.89 rows=455 width=33) (actual time=187.321..1,180.074 rows=2,430 loops=2,030)

  • Output: smfpda_productinfo_1.smfpda_visit_id
  • Hash Cond: ((smfpda_productinfo_1.c_bpartner_id)::text = (c_bpartner_3.c_bpartner_id)::text)
  • Buffers: shared hit=4023740 read=364019775
22. 2,335,697.700 2,335,697.700 ↑ 1.0 184,795 1,225

Seq Scan on public.smfpda_productinfo smfpda_productinfo_1 (cost=0.00..378,100.75 rows=190,221 width=66) (actual time=275.025..1,906.692 rows=184,795 loops=1,225)

  • Output: smfpda_productinfo_1.smfpda_productinfo_id, smfpda_productinfo_1.ad_client_id, smfpda_productinfo_1.ad_org_id, smfpda_productinfo_1.isactive, smfpda_productinfo_1.created, smfpda_productinfo_1.createdby, smfpda_productinfo_1.updated, smfpda_productinfo_1.updatedby, smfpda_productinfo_1.smfpda_visit_id, smfpda_productinfo_1.quantity, smfpda_productinfo_1.m_product_id, smfpda_productinfo_1.c_uom_id, smfpda_productinfo_1.c_bpartner_id, smfpda_productinfo_1.pda_updated
  • Filter: ((smfpda_productinfo_1.m_product_id)::text = (m_product.m_product_id)::text)
  • Rows Removed by Filter: 6283201
  • Buffers: shared hit=120050 read=364019775
23. 48.720 13,387.850 ↓ 2.6 88 2,030

Hash (cost=1,736.84..1,736.84 rows=34 width=33) (actual time=6.595..6.595 rows=88 loops=2,030)

  • Output: c_bpartner_3.c_bpartner_id
  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=3903690
24. 13,339.130 13,339.130 ↓ 2.6 88 2,030

Index Scan using em_pm_cbpartner_isvd on public.c_bpartner c_bpartner_3 (cost=0.29..1,736.84 rows=34 width=33) (actual time=2.479..6.571 rows=88 loops=2,030)

  • Output: c_bpartner_3.c_bpartner_id
  • Index Cond: (c_bpartner_3.em_pm_isvd = 'Y'::bpchar)
  • Filter: ((c_bpartner_3.em_cuvddm_avebydelivvol IS NOT NULL) AND ((c_bpartner_3.em_cuvddm_csalesregionid)::text = (c_salesregion.c_salesregion_id)::text) AND ((c_bpartner_3.em_smfpda_placetype)::text = 'E'::text) AND (c_bpartner_3.em_cuvddm_deactstatus = '1'::bpchar))
  • Rows Removed by Filter: 12368
  • Buffers: shared hit=3903690
25. 34,529.712 34,529.712 ↓ 0.0 0 4,932,816

Index Scan using smfpda_visit_key on public.smfpda_visit smfpda_visit_1 (cost=0.42..0.56 rows=1 width=33) (actual time=0.007..0.007 rows=0 loops=4,932,816)

  • Output: smfpda_visit_1.smfpda_visit_id, smfpda_visit_1.ad_client_id, smfpda_visit_1.ad_org_id, smfpda_visit_1.isactive, smfpda_visit_1.created, smfpda_visit_1.createdby, smfpda_visit_1.updated, smfpda_visit_1.updatedby, smfpda_visit_1.visitdate, smfpda_visit_1.c_bpartner_id, smfpda_visit_1.smfpda_workday_id, smfpda_visit_1.noattentionreasonam, smfpda_visit_1.started, smfpda_visit_1.ended, smfpda_visit_1.totaltime, smfpda_visit_1.noattentionreasond, smfpda_visit_1.noattentionreasonv, smfpda_visit_1.noattentionreasontlv, smfpda_visit_1.noattentionreasonrm, smfpda_visit_1.isreconciled, smfpda_visit_1.status_fact, smfpda_visit_1.outruote, smfpda_visit_1.pda_updated
  • Index Cond: ((smfpda_visit_1.smfpda_visit_id)::text = (smfpda_productinfo_1.smfpda_visit_id)::text)
  • Filter: ((smfpda_visit_1.visitdate >= '2018-10-01'::date) AND (smfpda_visit_1.visitdate <= '2018-10-31'::date) AND ((smfpda_visit_1.outruote)::text <> 'F'::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=19826750