explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6omL

Settings
# exclusive inclusive rows x rows loops node
1. 0.942 39,167.775 ↑ 16,181.1 50 1

Sort (cost=21,004,300.40..21,006,323.04 rows=809,055 width=19,290) (actual time=39,167.772..39,167.775 rows=50 loops=1)

  • Sort Key: o_1.c_order_id, oll.c_orderline_id
  • Sort Method: quicksort Memory: 289kB
2. 0.453 39,166.833 ↑ 16,181.1 50 1

Hash Left Join (cost=5,323,909.68..17,013,354.57 rows=809,055 width=19,290) (actual time=39,092.038..39,166.833 rows=50 loops=1)

  • Hash Cond: (o.c_doctypetarget_id = dt.c_doctype_id)
3. 0.265 39,157.506 ↑ 16,181.1 50 1

Hash Left Join (cost=5,323,894.73..6,920,235.71 rows=809,055 width=18,336) (actual time=39,088.854..39,157.506 rows=50 loops=1)

  • Hash Cond: (o.z_digitador_id = u.ad_user_id)
4. 0.267 39,134.656 ↑ 16,181.1 50 1

Hash Left Join (cost=5,320,709.18..6,914,926.23 rows=809,055 width=18,331) (actual time=39,066.155..39,134.656 rows=50 loops=1)

  • Hash Cond: (o_1.bill_bpartner_id = billbp.c_bpartner_id)
5. 1.365 39,104.730 ↑ 16,181.1 50 1

Hash Left Join (cost=5,317,432.12..6,909,525.18 rows=809,055 width=18,285) (actual time=39,036.382..39,104.730 rows=50 loops=1)

  • Hash Cond: (ol.c_orderline_id = oll.c_orderline_id)
6. 0.200 38,587.284 ↑ 16,181.1 50 1

Hash Left Join (cost=5,260,852.59..6,850,821.87 rows=809,055 width=18,246) (actual time=38,519.090..38,587.284 rows=50 loops=1)

  • Hash Cond: (pt_1.m_product_id = p.m_product_id)
7. 266.276 38,585.932 ↑ 16,181.1 50 1

Hash Join (cost=5,260,689.35..6,848,530.83 rows=809,055 width=18,215) (actual time=38,517.889..38,585.932 rows=50 loops=1)

  • Hash Cond: (ol.c_order_id = o_1.c_order_id)
8. 5,617.663 37,399.751 ↑ 1.0 1,643,385 1

Unique (cost=5,162,863.96..6,720,017.67 rows=1,643,434 width=11,216) (actual time=30,488.054..37,399.751 rows=1,643,385 loops=1)

9. 14,479.016 31,782.088 ↑ 1.0 1,643,385 1

Sort (cost=5,162,863.96..5,166,972.54 rows=1,643,434 width=11,216) (actual time=30,488.051..31,782.088 rows=1,643,385 loops=1)

  • Sort Key: ol.ad_client_id, ol.ad_org_id, ol.isactive, ol.created, ol.createdby, ol.updated, ol.updatedby, uomt.ad_language, ol.c_order_id, ol.c_orderline_id, ol.c_tax_id, tt.taxindicator, ol.c_bpartner_id, ol.c_bpartner_location_id, bp_1.name, bpl_1.c_location_id, ol.line, pt_1.m_product_id, po.vendorproductno, (CASE WHEN ((ol.qtyordered <> '0'::numeric) OR (ol.m_product_id IS NOT NULL)) THEN ol.qtyordered ELSE NULL::numeric END), (CASE WHEN ((ol.qtyentered <> '0'::numeric) OR (ol.m_product_id IS NOT NULL)) THEN ol.qtyentered ELSE NULL::numeric END), (CASE WHEN ((ol.qtyentered <> '0'::numeric) OR (ol.m_product_id IS NOT NULL)) THEN uomt.uomsymbol ELSE NULL::character varying END), (COALESCE(ct.name, (((COALESCE(pt_1.name, p_1.name))::text || (productattribute(ol.m_attributesetinstance_id))::text))::character varying, ol.description)), (CASE WHEN (COALESCE(ct.name, pt_1.name, p_1.name) IS NOT NULL) THEN ol.description ELSE NULL::character varying END), (COALESCE(pt_1.documentnote, p_1.documentnote)), p_1.upc, p_1.sku, (COALESCE(pp.vendorproductno, p_1.value)), ra.description, (CASE WHEN ((i.isdiscountprinted = 'Y'::bpchar) AND (ol.pricelist <> '0'::numeric)) THEN ol.pricelist ELSE NULL::numeric END), (CASE WHEN ((i.isdiscountprinted = 'Y'::bpchar) AND (ol.pricelist <> '0'::numeric) AND (ol.qtyentered <> '0'::numeric)) THEN ((ol.pricelist * ol.qtyordered) / ol.qtyentered) ELSE NULL::numeric END), (CASE WHEN ((i.isdiscountprinted = 'Y'::bpchar) AND (ol.pricelist > ol.priceactual) AND (ol.pricelist <> '0'::numeric)) THEN (((ol.pricelist - ol.priceactual) / ol.pricelist) * '100'::numeric) ELSE NULL::numeric END), (CASE WHEN ((ol.priceactual <> '0'::numeric) OR (ol.m_product_id IS NOT NULL)) THEN ol.priceactual ELSE NULL::numeric END), (CASE WHEN ((ol.priceentered <> '0'::numeric) OR (ol.m_product_id IS NOT NULL)) THEN ol.priceentered ELSE NULL::numeric END), (CASE WHEN ((ol.linenetamt <> '0'::numeric) OR (ol.m_product_id IS NOT NULL)) THEN ol.linenetamt ELSE NULL::numeric END), pt_1.description, p_1.imageurl, ol.c_campaign_id, ol.c_project_id, ol.c_activity_id, ol.c_projectphase_id, ol.c_projecttask_id, ol.ad_orgtrx_id, ol.c_charge_id, ol.c_currency_id, ol.c_uom_id, ol.datedelivered, ol.dateinvoiced, ol.dateordered, ol.datepromised, ol.freightamt, ol.isdescription, ol.link_orderline_id, ol.m_promotion_id, ol.m_shipper_id, ol.m_warehouse_id, ol.pricecost, ol.pricelimit, ol.processed, ol.qtydelivered, ol.qtyinvoiced, ol.qtylostsales, ol.qtyreserved, ol.ref_orderline_id, ol.rramt, ol.rrstartdate, ol.s_resourceassignment_id, ol.user1_id, ol.user2_id, uomt.ad_org_id, uom.costingprecision, uomt.description, uomt.isactive, uom.isdefault, uomt.name, uom.stdprecision, uom.uomtype, uom.x12de355, i.ad_org_id, i.ad_orgtrx_id, i.ad_user_id, i.amountrefunded, i.amounttendered, i.bill_bpartner_id, i.bill_location_id, i.bill_user_id, i.c_activity_id, i.c_bpartner_id, i.c_campaign_id, i.c_cashline_id, i.c_cashplanline_id, i.c_charge_id, i.c_conversiontype_id, i.c_currency_id, i.c_doctype_id, i.c_doctypetarget_id, i.chargeamt, i.copyfrom, i.c_payment_id, i.c_paymentterm_id, i.c_pos_id, i.c_project_id, i.created, i.createdby, i.dateacct, i.dateprinted, i.datepromised, i.deliveryrule, i.deliveryviarule, i.description, i.docaction, i.docstatus, i.documentno, i.dropship_bpartner_id, i.dropship_location_id, i.dropship_user_id, i.freightamt, i.freightcostrule, i.grandtotal, i.invoicerule, i.isactive, i.isapproved, i.iscreditapproved, i.isdelivered, i.isdiscountprinted, i.isdropship, i.isinvoiced, i.ispayschedulevalid, i.isprinted, i.isselected, i.isselfservice, i.issotrx, i.istaxincluded, i.istransferred, i.link_order_id, i.m_freightcategory_id, i.m_pricelist_id, i.m_shipper_id, i.m_warehouse_id, i.ordertype, i.pay_bpartner_id, i.pay_location_id, i.paymentrule, i.poreference, i.posted, i.priorityrule, i.processed, i.processedon, i.promotioncode, i.ref_order_id, i.salesrep_id, i.sendemail, i.totallines, i.updated, i.updatedby, i.user1_id, i.user2_id, i.volume, i.weight, pt_1.ad_org_id, p_1.classification, p_1.copyfrom, pt_1.created, pt_1.createdby, p_1.c_revenuerecognition_id, p_1.c_subscriptiontype_id, p_1.c_taxcategory_id, p_1.c_uom_id, p_1.descriptionurl, p_1.discontinued, p_1.discontinuedat, p_1.group1, p_1.group2, p_1.guaranteedays, p_1.guaranteedaysmin, p_1.help, pt_1.isactive, p_1.isbom, p_1.isdropship, p_1.isexcludeautodelivery, p_1.isinvoiceprintdetails, p_1.ispicklistprintdetails, p_1.ispurchased, p_1.isselfservice, p_1.issold, p_1.isstocked, p_1.issummary, p_1.isverified, p_1.iswebstorefeatured, p_1.lowlevel, p_1.m_attributeset_id, p_1.m_attributesetinstance_id, p_1.m_freightcategory_id, p_1.m_locator_id, p_1.m_product_category_id, p_1.processing, p_1.producttype, p_1.r_mailtext_id, p_1.salesrep_id, p_1.s_expensetype_id, p_1.shelfdepth, p_1.shelfheight, p_1.shelfwidth, p_1.s_resource_id, p_1.unitsperpack, p_1.unitsperpallet, pt_1.updated, pt_1.updatedby, p_1.versionno, p_1.volume, p_1.weight, po.ad_org_id, po.c_bpartner_id, po.c_currency_id, po.costperorder, po.created, po.createdby, po.c_uom_id, po.deliverytime_actual, po.deliverytime_promised, po.discontinued, po.discontinuedat, po.isactive, po.iscurrentvendor, po.manufacturer, po.m_product_id, po.order_min, po.order_pack, po.priceeffective, po.pricelastinv, po.pricelastpo, po.pricelist, po.pricepo, po.qualityrating, po.royaltyamt, po.upc, po.updated, po.updatedby, po.vendorcategory, ra.ad_org_id, ra.assigndatefrom, ra.assigndateto, ra.created, ra.createdby, ra.isactive, ra.isconfirmed, ra.name, ra.qty, ra.s_resource_id, ra.updated, ra.updatedby, ct.ad_org_id, c_1.c_bpartner_id, c_1.c_chargetype_id, c_1.chargeamt, c_1.c_taxcategory_id, c_1.description, ct.isactive, c_1.issamecurrency, c_1.issametax, c_1.istaxincluded, pp.ad_org_id, pp.c_bpartner_id, pp.created, pp.createdby, pp.description, pp.isactive, pp.ismanufacturer, pp.manufacturer, pp.qualityrating, pp.shelflifemindays, pp.shelflifeminpct, pp.updated, pp.updatedby, pp.vendorcategory, bp_1.acqusitioncost, bp_1.actuallifetimevalue, bp_1.ad_language, bp_1.ad_orgbp_id, bp_1.ad_org_id, bp_1.bpartner_parent_id, bp_1.c_bp_group_id, bp_1.c_dunning_id, bp_1.c_greeting_id, bp_1.c_invoiceschedule_id, bp_1.c_paymentterm_id, bp_1.created, bp_1.createdby, bp_1.c_taxgroup_id, bp_1.deliveryrule, bp_1.deliveryviarule, bp_1.description, bp_1.dunninggrace, bp_1.duns, bp_1.firstsale, bp_1.flatdiscount, bp_1.freightcostrule, bp_1.invoicerule, bp_1.isactive, bp_1.iscustomer, bp_1.isdiscountprinted, bp_1.isemployee, bp_1.ismanufacturer, bp_1.isonetime, bp_1.ispotaxexempt, bp_1.isprospect, bp_1.issalesrep, bp_1.issummary, bp_1.istaxexempt, bp_1.isvendor, bp_1.logo_id, bp_1.m_discountschema_id, bp_1.m_pricelist_id, bp_1.naics, bp_1.name, bp_1.name2, bp_1.numberemployees, bp_1.paymentrule, bp_1.paymentrulepo, bp_1.po_discountschema_id, bp_1.po_paymentterm_id, bp_1.po_pricelist_id, bp_1.poreference, bp_1.potentiallifetimevalue, bp_1.rating, bp_1.referenceno, bp_1.salesrep_id, bp_1.salesvolume, bp_1.sendemail, bp_1.shareofcustomer, bp_1.shelflifeminpct, bp_1.so_creditlimit, bp_1.socreditstatus, bp_1.so_creditused, bp_1.so_description, bp_1.taxid, bp_1.totalopenbalance, bp_1.updated, bp_1.updatedby, bp_1.url, bp_1.value, bpl_1.ad_org_id, bpl_1.c_bpartner_id, bpl_1.created, bpl_1.createdby, bpl_1.c_salesregion_id, bpl_1.fax, bpl_1.isactive, bpl_1.isbillto, bpl_1.isdn, bpl_1.ispayfrom, bpl_1.isremitto, bpl_1.isshipto, bpl_1.name, bpl_1.phone, bpl_1.phone2, bpl_1.updated, bpl_1.updatedby, tt.ad_org_id, t.ad_rule_id, t.c_country_id, t.c_region_id, t.c_taxcategory_id, tt.description, tt.isactive, t.isdefault, t.isdocumentlevel, t.issalestax, t.issummary, t.istaxexempt, tt.name, t.parent_tax_id, t.rate, t.requirestaxcertificate, t.sopotype, t.to_country_id, t.to_region_id, t.validfrom
  • Sort Method: external merge Disk: 910416kB
10. 170.191 17,303.072 ↑ 1.0 1,643,385 1

Append (cost=30,479.18..370,632.12 rows=1,643,434 width=11,216) (actual time=439.025..17,303.072 rows=1,643,385 loops=1)

11. 3,495.464 14,836.125 ↑ 1.0 626,270 1

Hash Left Join (cost=30,479.18..298,705.39 rows=626,290 width=7,014) (actual time=439.024..14,836.125 rows=626,270 loops=1)

  • Hash Cond: (((uomt.ad_language)::text = (tt.ad_language)::text) AND (ol.c_tax_id = tt.c_tax_id))
12. 1,058.525 11,340.600 ↑ 1.0 626,270 1

Hash Left Join (cost=30,473.54..107,444.81 rows=626,290 width=6,303) (actual time=438.278..11,340.600 rows=626,270 loops=1)

  • Hash Cond: (ol.c_tax_id = t.c_tax_id)
13. 1,112.161 10,282.003 ↑ 1.0 626,270 1

Hash Join (cost=30,468.38..105,723.06 rows=626,290 width=6,208) (actual time=438.192..10,282.003 rows=626,270 loops=1)

  • Hash Cond: (ol.c_bpartner_location_id = bpl_1.c_bpartner_location_id)
14. 1,199.766 9,125.524 ↑ 1.0 626,270 1

Hash Join (cost=26,886.31..100,496.88 rows=626,290 width=6,047) (actual time=393.404..9,125.524 rows=626,270 loops=1)

  • Hash Cond: (ol.c_bpartner_id = bp_1.c_bpartner_id)
15. 795.799 7,873.401 ↑ 1.0 626,270 1

Hash Left Join (cost=23,609.25..95,575.64 rows=626,290 width=5,365) (actual time=340.797..7,873.401 rows=626,270 loops=1)

  • Hash Cond: ((ol.m_product_id = pp.m_product_id) AND (i.c_bpartner_id = pp.c_bpartner_id))
16. 665.551 7,077.575 ↑ 1.0 626,270 1

Hash Left Join (cost=23,607.37..92,285.75 rows=626,290 width=5,052) (actual time=340.755..7,077.575 rows=626,270 loops=1)

  • Hash Cond: (((uomt.ad_language)::text = (ct.ad_language)::text) AND (ol.c_charge_id = ct.c_charge_id))
17. 637.776 6,411.827 ↑ 1.0 626,270 1

Hash Left Join (cost=23,588.86..88,979.11 rows=626,290 width=5,006) (actual time=340.545..6,411.827 rows=626,270 loops=1)

  • Hash Cond: (ol.c_charge_id = c_1.c_charge_id)
18. 607.440 5,773.864 ↑ 1.0 626,270 1

Hash Left Join (cost=23,572.07..87,318.22 rows=626,290 width=4,932) (actual time=340.347..5,773.864 rows=626,270 loops=1)

  • Hash Cond: (ol.s_resourceassignment_id = ra.s_resourceassignment_id)
19. 712.089 5,166.422 ↑ 1.0 626,270 1

Hash Left Join (cost=23,560.27..85,662.41 rows=626,290 width=4,134) (actual time=340.332..5,166.422 rows=626,270 loops=1)

  • Hash Cond: ((p_1.m_product_id = po.m_product_id) AND (i.c_bpartner_id = po.c_bpartner_id))
20. 839.530 4,454.042 ↑ 1.0 626,270 1

Hash Left Join (cost=23,540.27..82,354.39 rows=626,290 width=3,837) (actual time=340.027..4,454.042 rows=626,270 loops=1)

  • Hash Cond: (((uomt.ad_language)::text = (pt_1.ad_language)::text) AND (ol.m_product_id = pt_1.m_product_id))
21. 852.643 3,613.039 ↑ 1.0 626,270 1

Hash Left Join (cost=23,426.86..78,949.54 rows=626,290 width=3,736) (actual time=338.526..3,613.039 rows=626,270 loops=1)

  • Hash Cond: (ol.m_product_id = p_1.m_product_id)
22. 922.366 2,757.975 ↑ 1.0 626,270 1

Hash Join (cost=23,263.62..77,139.19 rows=626,290 width=1,699) (actual time=336.077..2,757.975 rows=626,270 loops=1)

  • Hash Cond: (ol.c_order_id = i.c_order_id)
23. 444.047 1,500.602 ↑ 1.0 626,270 1

Hash Join (cost=11.15..52,242.67 rows=626,290 width=512) (actual time=0.146..1,500.602 rows=626,270 loops=1)

  • Hash Cond: (ol.c_uom_id = uomt.c_uom_id)
24. 457.386 1,056.487 ↑ 1.0 626,270 1

Hash Join (cost=3.64..50,494.00 rows=626,290 width=460) (actual time=0.064..1,056.487 rows=626,270 loops=1)

  • Hash Cond: (ol.c_uom_id = uom.c_uom_id)
25. 599.061 599.061 ↑ 1.0 626,270 1

Seq Scan on c_orderline ol (cost=0.00..48,750.90 rows=626,290 width=438) (actual time=0.006..599.061 rows=626,270 loops=1)

26. 0.020 0.040 ↑ 1.0 73 1

Hash (cost=2.73..2.73 rows=73 width=22) (actual time=0.040..0.040 rows=73 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
27. 0.020 0.020 ↑ 1.0 73 1

Seq Scan on c_uom uom (cost=0.00..2.73 rows=73 width=22) (actual time=0.003..0.020 rows=73 loops=1)

28. 0.023 0.068 ↑ 1.0 73 1

Hash (cost=6.60..6.60 rows=73 width=64) (actual time=0.068..0.068 rows=73 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
29. 0.045 0.045 ↑ 1.0 73 1

Seq Scan on c_uom_trl uomt (cost=0.00..6.60 rows=73 width=64) (actual time=0.005..0.045 rows=73 loops=1)

  • Filter: ((ad_language)::text = 'pt_BR'::text)
  • Rows Removed by Filter: 135
30. 171.804 335.007 ↑ 1.0 218,243 1

Hash (cost=20,524.43..20,524.43 rows=218,243 width=1,193) (actual time=335.007..335.007 rows=218,243 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 71085kB
31. 163.203 163.203 ↑ 1.0 218,243 1

Seq Scan on c_order i (cost=0.00..20,524.43 rows=218,243 width=1,193) (actual time=0.006..163.203 rows=218,243 loops=1)

32. 1.185 2.421 ↑ 1.0 2,233 1

Hash (cost=135.33..135.33 rows=2,233 width=2,037) (actual time=2.421..2.421 rows=2,233 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 463kB
33. 1.236 1.236 ↑ 1.0 2,233 1

Seq Scan on m_product p_1 (cost=0.00..135.33 rows=2,233 width=2,037) (actual time=0.006..1.236 rows=2,233 loops=1)

34. 0.725 1.473 ↑ 1.0 2,233 1

Hash (cost=79.91..79.91 rows=2,233 width=107) (actual time=1.473..1.473 rows=2,233 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 348kB
35. 0.748 0.748 ↑ 1.0 2,233 1

Seq Scan on m_product_trl pt_1 (cost=0.00..79.91 rows=2,233 width=107) (actual time=0.006..0.748 rows=2,233 loops=1)

  • Filter: ((ad_language)::text = 'pt_BR'::text)
36. 0.148 0.291 ↑ 1.0 320 1

Hash (cost=15.20..15.20 rows=320 width=303) (actual time=0.291..0.291 rows=320 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 57kB
37. 0.143 0.143 ↑ 1.0 320 1

Seq Scan on m_product_po po (cost=0.00..15.20 rows=320 width=303) (actual time=0.004..0.143 rows=320 loops=1)

38. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=10.80..10.80 rows=80 width=814) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
39. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on s_resourceassignment ra (cost=0.00..10.80 rows=80 width=814) (actual time=0.002..0.002 rows=0 loops=1)

40. 0.087 0.187 ↑ 1.0 346 1

Hash (cost=12.46..12.46 rows=346 width=80) (actual time=0.187..0.187 rows=346 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 38kB
41. 0.100 0.100 ↑ 1.0 346 1

Seq Scan on c_charge c_1 (cost=0.00..12.46 rows=346 width=80) (actual time=0.010..0.100 rows=346 loops=1)

42. 0.094 0.197 ↑ 1.0 346 1

Hash (cost=13.32..13.32 rows=346 width=58) (actual time=0.197..0.197 rows=346 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
43. 0.103 0.103 ↑ 1.0 346 1

Seq Scan on c_charge_trl ct (cost=0.00..13.32 rows=346 width=58) (actual time=0.008..0.103 rows=346 loops=1)

  • Filter: ((ad_language)::text = 'pt_BR'::text)
44. 0.015 0.027 ↑ 1.0 35 1

Hash (cost=1.35..1.35 rows=35 width=320) (actual time=0.027..0.027 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
45. 0.012 0.012 ↑ 1.0 35 1

Seq Scan on c_bpartner_product pp (cost=0.00..1.35 rows=35 width=320) (actual time=0.004..0.012 rows=35 loops=1)

46. 27.693 52.357 ↑ 1.0 41,425 1

Hash (cost=2,759.25..2,759.25 rows=41,425 width=688) (actual time=52.357..52.357 rows=41,425 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 11730kB
47. 24.664 24.664 ↑ 1.0 41,425 1

Seq Scan on c_bpartner bp_1 (cost=0.00..2,759.25 rows=41,425 width=688) (actual time=0.008..24.664 rows=41,425 loops=1)

48. 24.673 44.318 ↑ 1.0 66,803 1

Hash (cost=2,747.03..2,747.03 rows=66,803 width=167) (actual time=44.318..44.318 rows=66,803 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 12140kB
49. 19.645 19.645 ↑ 1.0 66,803 1

Seq Scan on c_bpartner_location bpl_1 (cost=0.00..2,747.03 rows=66,803 width=167) (actual time=0.007..19.645 rows=66,803 loops=1)

50. 0.033 0.072 ↑ 1.0 96 1

Hash (cost=3.96..3.96 rows=96 width=101) (actual time=0.072..0.072 rows=96 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
51. 0.039 0.039 ↑ 1.0 96 1

Seq Scan on c_tax t (cost=0.00..3.96 rows=96 width=101) (actual time=0.005..0.039 rows=96 loops=1)

52. 0.030 0.061 ↑ 1.0 96 1

Hash (cost=4.20..4.20 rows=96 width=69) (actual time=0.061..0.061 rows=96 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
53. 0.031 0.031 ↑ 1.0 96 1

Seq Scan on c_tax_trl tt (cost=0.00..4.20 rows=96 width=69) (actual time=0.004..0.031 rows=96 loops=1)

  • Filter: ((ad_language)::text = 'pt_BR'::text)
54. 0.002 0.023 ↓ 0.0 0 1

Nested Loop (cost=2.25..1,186.87 rows=29 width=9,134) (actual time=0.023..0.023 rows=0 loops=1)

55. 0.002 0.021 ↓ 0.0 0 1

Nested Loop (cost=1.97..1,176.55 rows=29 width=4,560) (actual time=0.021..0.021 rows=0 loops=1)

56. 0.001 0.019 ↓ 0.0 0 1

Nested Loop (cost=1.82..1,169.83 rows=40 width=4,532) (actual time=0.019..0.019 rows=0 loops=1)

57. 0.001 0.018 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.68..1,163.45 rows=40 width=4,496) (actual time=0.018..0.018 rows=0 loops=1)

58. 0.001 0.017 ↓ 0.0 0 1

Nested Loop (cost=1.41..1,151.41 rows=40 width=4,193) (actual time=0.017..0.017 rows=0 loops=1)

59. 0.001 0.016 ↓ 0.0 0 1

Nested Loop (cost=0.99..1,132.58 rows=40 width=3,006) (actual time=0.016..0.016 rows=0 loops=1)

60. 0.002 0.015 ↓ 0.0 0 1

Nested Loop (cost=0.56..83.49 rows=1 width=2,659) (actual time=0.015..0.015 rows=0 loops=1)

61. 0.001 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.28..82.01 rows=1 width=642) (actual time=0.013..0.013 rows=0 loops=1)

  • Join Filter: (b.pp_product_bom_id = bl.pp_product_bom_id)
62. 0.002 0.012 ↓ 0.0 0 1

Nested Loop (cost=0.28..71.11 rows=1 width=38) (actual time=0.012..0.012 rows=0 loops=1)

63. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on pp_product_bom b (cost=0.00..10.40 rows=40 width=32) (actual time=0.010..0.010 rows=0 loops=1)

64. 0.000 0.000 ↓ 0.0 0

Index Scan using m_product_pkey on m_product bp_2 (cost=0.28..1.49 rows=1 width=6) (never executed)

  • Index Cond: (m_product_id = b.m_product_id)
  • Filter: ((isbom = 'Y'::bpchar) AND (isverified = 'Y'::bpchar) AND (isinvoiceprintdetails = 'Y'::bpchar))
65. 0.000 0.000 ↓ 0.0 0

Seq Scan on pp_product_bomline bl (cost=0.00..10.40 rows=40 width=636) (never executed)

66. 0.000 0.000 ↓ 0.0 0

Index Scan using m_product_pkey on m_product p_2 (cost=0.28..1.48 rows=1 width=2,017) (never executed)

  • Index Cond: (m_product_id = bl.m_product_id)
67. 0.000 0.000 ↓ 0.0 0

Index Scan using c_orderline_product on c_orderline ol_1 (cost=0.42..1,026.75 rows=2,234 width=376) (never executed)

  • Index Cond: (m_product_id = b.m_product_id)
68. 0.000 0.000 ↓ 0.0 0

Index Scan using c_order_pkey on c_order i_1 (cost=0.42..0.47 rows=1 width=1,193) (never executed)

  • Index Cond: (c_order_id = ol_1.c_order_id)
69. 0.000 0.000 ↓ 0.0 0

Index Scan using m_product_po_pkey on m_product_po po_1 (cost=0.27..0.30 rows=1 width=303) (never executed)

  • Index Cond: ((p_2.m_product_id = m_product_id) AND (i_1.c_bpartner_id = c_bpartner_id))
70. 0.000 0.000 ↓ 0.0 0

Index Scan using c_uom_pkey on c_uom uom_1 (cost=0.14..0.16 rows=1 width=42) (never executed)

  • Index Cond: (c_uom_id = ol_1.c_uom_id)
71. 0.000 0.000 ↓ 0.0 0

Index Scan using c_uom_trl_pkey on c_uom_trl uomt_1 (cost=0.14..0.17 rows=1 width=34) (never executed)

  • Index Cond: ((c_uom_id = p_2.c_uom_id) AND ((ad_language)::text = 'pt_BR'::text))
72. 0.000 0.000 ↓ 0.0 0

Index Scan using m_product_trl_pkey on m_product_trl pt_2 (cost=0.28..0.33 rows=1 width=93) (never executed)

  • Index Cond: ((m_product_id = p_2.m_product_id) AND ((ad_language)::text = 'pt_BR'::text))
73. 408.675 472.634 ↑ 1.0 218,243 1

Nested Loop (cost=0.14..22,709.23 rows=218,243 width=11,141) (actual time=0.065..472.634 rows=218,243 loops=1)

74. 0.038 0.038 ↑ 1.0 1 1

Index Scan using ad_language_pkey on ad_language l_1 (cost=0.14..2.37 rows=1 width=6) (actual time=0.035..0.038 rows=1 loops=1)

  • Index Cond: ((ad_language)::text = 'pt_BR'::text)
  • Filter: ((isbaselanguage = 'N'::bpchar) AND (issystemlanguage = 'Y'::bpchar))
75. 63.921 63.921 ↑ 1.0 218,243 1

Seq Scan on c_order i_2 (cost=0.00..20,524.43 rows=218,243 width=51) (actual time=0.008..63.921 rows=218,243 loops=1)

76. 1,758.196 1,824.099 ↑ 1.0 798,872 1

Hash Join (cost=5.40..31,596.28 rows=798,872 width=11,083) (actual time=0.167..1,824.099 rows=798,872 loops=1)

  • Hash Cond: (ot.c_tax_id = tt_1.c_tax_id)
77. 65.806 65.806 ↑ 1.0 798,872 1

Seq Scan on c_ordertax ot (cost=0.00..23,409.72 rows=798,872 width=71) (actual time=0.022..65.806 rows=798,872 loops=1)

78. 0.048 0.097 ↑ 1.0 96 1

Hash (cost=4.20..4.20 rows=96 width=44) (actual time=0.097..0.097 rows=96 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
79. 0.049 0.049 ↑ 1.0 96 1

Seq Scan on c_tax_trl tt_1 (cost=0.00..4.20 rows=96 width=44) (actual time=0.007..0.049 rows=96 loops=1)

  • Filter: ((ad_language)::text = 'pt_BR'::text)
80. 0.068 919.905 ↑ 15,348.6 7 1

Hash (cost=96,482.39..96,482.39 rows=107,440 width=6,999) (actual time=919.905..919.905 rows=7 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 1043kB
81. 0.499 919.837 ↑ 15,348.6 7 1

Hash Left Join (cost=66,301.18..96,482.39 rows=107,440 width=6,999) (actual time=917.389..919.837 rows=7 loops=1)

  • Hash Cond: (bbpl.c_location_id = billloc.c_location_id)
82. 0.976 873.485 ↑ 15,348.6 7 1

Hash Left Join (cost=62,032.03..91,931.21 rows=107,440 width=6,911) (actual time=871.050..873.485 rows=7 loops=1)

  • Hash Cond: (o_1.c_order_id = o.c_order_id)
83. 0.036 620.415 ↑ 15,348.6 7 1

Hash Left Join (cost=38,779.57..68,396.71 rows=107,440 width=6,781) (actual time=617.997..620.415 rows=7 loops=1)

  • Hash Cond: (o_1.cof_c_custody_id = c.cof_c_custody_id)
84. 0.040 620.353 ↑ 15,348.6 7 1

Hash Left Join (cost=38,776.56..68,085.10 rows=107,440 width=6,772) (actual time=617.951..620.353 rows=7 loops=1)

  • Hash Cond: (((dt_1.ad_language)::text = (cur.ad_language)::text) AND (o_1.c_currency_id = cur.c_currency_id))
85. 0.266 620.174 ↑ 15,348.6 7 1

Hash Left Join (cost=38,762.60..67,499.52 rows=107,440 width=6,756) (actual time=617.789..620.174 rows=7 loops=1)

  • Hash Cond: (o_1.bill_user_id = bbpc.ad_user_id)
86. 0.498 578.147 ↑ 15,348.6 7 1

Hash Left Join (cost=35,577.04..64,031.92 rows=107,440 width=6,450) (actual time=575.778..578.147 rows=7 loops=1)

  • Hash Cond: (cpfl.c_location_id = cpfll.c_location_id)
87. 0.495 531.450 ↑ 15,348.6 7 1

Hash Left Join (cost=31,307.90..59,480.74 rows=107,440 width=6,368) (actual time=529.098..531.450 rows=7 loops=1)

  • Hash Cond: (o_1.cof_payfrom_location_id = cpfl.c_bpartner_location_id)
88. 0.511 487.511 ↑ 15,348.6 7 1

Hash Join (cost=27,725.84..55,616.62 rows=107,440 width=6,220) (actual time=485.173..487.511 rows=7 loops=1)

  • Hash Cond: (o_1.bill_location_id = bbpl.c_bpartner_location_id)
89. 0.268 440.953 ↑ 15,348.6 7 1

Hash Join (cost=24,143.77..51,752.50 rows=107,440 width=6,059) (actual time=438.632..440.953 rows=7 loops=1)

  • Hash Cond: (o_1.bill_bpartner_id = bbp.c_bpartner_id)
90. 0.289 386.834 ↑ 15,348.6 7 1

Hash Left Join (cost=20,866.71..48,193.38 rows=107,440 width=5,377) (actual time=384.530..386.834 rows=7 loops=1)

  • Hash Cond: (u_1.c_bpartner_id = ubp.c_bpartner_id)
91. 0.258 333.593 ↑ 15,348.6 7 1

Hash Left Join (cost=17,589.64..44,634.25 rows=107,440 width=4,695) (actual time=331.306..333.593 rows=7 loops=1)

  • Hash Cond: (o_1.salesrep_id = u_1.ad_user_id)
92. 0.033 290.898 ↑ 15,348.6 7 1

Hash Join (cost=14,404.09..41,166.65 rows=107,440 width=4,389) (actual time=288.623..290.898 rows=7 loops=1)

  • Hash Cond: (o_1.ad_client_id = ci.ad_client_id)
93. 0.029 290.853 ↑ 15,348.6 7 1

Hash Join (cost=14,403.05..40,285.94 rows=107,440 width=4,382) (actual time=288.589..290.853 rows=7 loops=1)

  • Hash Cond: (o_1.ad_org_id = oi.ad_org_id)
94. 0.022 290.796 ↑ 15,348.6 7 1

Hash Left Join (cost=14,401.44..39,958.03 rows=107,440 width=3,670) (actual time=288.543..290.796 rows=7 loops=1)

  • Hash Cond: (((dt_1.ad_language)::text = (bpcgt.ad_language)::text) AND (bpc.c_greeting_id = bpcgt.c_greeting_id))
95. 0.028 290.764 ↑ 15,348.6 7 1

Hash Left Join (cost=14,399.06..39,391.60 rows=107,440 width=3,370) (actual time=288.520..290.764 rows=7 loops=1)

  • Hash Cond: (bpc.c_greeting_id = bpcg.c_greeting_id)
96. 0.252 290.732 ↑ 15,348.6 7 1

Hash Left Join (cost=14,385.69..39,096.19 rows=107,440 width=3,362) (actual time=288.496..290.732 rows=7 loops=1)

  • Hash Cond: (o_1.ad_user_id = bpc.ad_user_id)
97. 0.481 247.461 ↑ 15,348.6 7 1

Hash Join (cost=11,200.14..35,628.59 rows=107,440 width=3,056) (actual time=245.237..247.461 rows=7 loops=1)

  • Hash Cond: (bpl.c_location_id = l.c_location_id)
98. 0.489 189.241 ↑ 15,348.6 7 1

Hash Join (cost=6,931.00..31,077.41 rows=107,440 width=2,881) (actual time=187.028..189.241 rows=7 loops=1)

  • Hash Cond: (o_1.c_bpartner_location_id = bpl.c_bpartner_location_id)
99. 0.025 144.322 ↑ 15,348.6 7 1

Hash Left Join (cost=3,348.93..27,213.29 rows=107,440 width=2,720) (actual time=142.120..144.322 rows=7 loops=1)

  • Hash Cond: (((dt_1.ad_language)::text = (bpgt.ad_language)::text) AND (bp.c_greeting_id = bpgt.c_greeting_id))
100. 0.035 144.281 ↑ 15,348.6 7 1

Hash Join (cost=3,346.55..26,646.85 rows=107,440 width=2,420) (actual time=142.087..144.281 rows=7 loops=1)

  • Hash Cond: (o_1.c_doctype_id = dt_1.c_doctype_id)
101. 0.035 144.124 ↑ 14,780.3 7 1

Hash Left Join (cost=3,335.04..26,358.32 rows=103,462 width=2,334) (actual time=141.940..144.124 rows=7 loops=1)

  • Hash Cond: (bp.c_greeting_id = bpg.c_greeting_id)
102. 0.107 144.085 ↑ 14,780.3 7 1

Hash Join (cost=3,321.67..26,073.36 rows=103,462 width=2,326) (actual time=141.909..144.085 rows=7 loops=1)

  • Hash Cond: (o_1.c_bpartner_id = bp.c_bpartner_id)
103. 0.020 89.024 ↑ 14,780.3 7 1

Hash Join (cost=44.61..22,524.69 rows=103,462 width=1,595) (actual time=86.859..89.024 rows=7 loops=1)

  • Hash Cond: (o_1.c_paymentterm_id = ptt.c_paymentterm_id)
104. 0.021 88.793 ↑ 14,780.3 7 1

Hash Join (cost=24.95..22,230.75 rows=103,462 width=1,529) (actual time=86.636..88.793 rows=7 loops=1)

  • Hash Cond: (o_1.c_paymentterm_id = pt.c_paymentterm_id)
105. 0.023 88.490 ↑ 14,780.3 7 1

Hash Join (cost=3.37..21,934.87 rows=103,462 width=1,472) (actual time=86.341..88.490 rows=7 loops=1)

  • Hash Cond: (o_1.m_warehouse_id = wh.m_warehouse_id)
106. 88.338 88.440 ↑ 14,780.3 7 1

Seq Scan on c_order o_1 (cost=1.79..21,617.43 rows=103,462 width=1,231) (actual time=86.300..88.440 rows=7 loops=1)

  • Filter: ((hashed SubPlan 5) AND (issotrx = 'Y'::bpchar))
  • Rows Removed by Filter: 218236
107.          

SubPlan (forSeq Scan)

108. 0.102 0.102 ↑ 1.9 7 1

Index Only Scan using t_selection_pkey on t_selection (cost=0.42..1.75 rows=13 width=7) (actual time=0.100..0.102 rows=7 loops=1)

  • Index Cond: (ad_pinstance_id = '8041201'::numeric)
  • Heap Fetches: 0
109. 0.017 0.027 ↑ 1.0 26 1

Hash (cost=1.26..1.26 rows=26 width=247) (actual time=0.027..0.027 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
110. 0.010 0.010 ↑ 1.0 26 1

Seq Scan on m_warehouse wh (cost=0.00..1.26 rows=26 width=247) (actual time=0.004..0.010 rows=26 loops=1)

111. 0.125 0.282 ↑ 1.0 426 1

Hash (cost=16.26..16.26 rows=426 width=57) (actual time=0.281..0.282 rows=426 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
112. 0.157 0.157 ↑ 1.0 426 1

Seq Scan on c_paymentterm pt (cost=0.00..16.26 rows=426 width=57) (actual time=0.010..0.157 rows=426 loops=1)

113. 0.099 0.211 ↑ 1.0 426 1

Hash (cost=14.32..14.32 rows=426 width=78) (actual time=0.211..0.211 rows=426 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
114. 0.112 0.112 ↑ 1.0 426 1

Seq Scan on c_paymentterm_trl ptt (cost=0.00..14.32 rows=426 width=78) (actual time=0.004..0.112 rows=426 loops=1)

  • Filter: ((ad_language)::text = 'pt_BR'::text)
115. 28.297 54.954 ↑ 1.0 41,425 1

Hash (cost=2,759.25..2,759.25 rows=41,425 width=737) (actual time=54.954..54.954 rows=41,425 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 12620kB
116. 26.657 26.657 ↑ 1.0 41,425 1

Seq Scan on c_bpartner bp (cost=0.00..2,759.25 rows=41,425 width=737) (actual time=0.006..26.657 rows=41,425 loops=1)

117. 0.001 0.004 ↓ 0.0 0 1

Hash (cost=11.50..11.50 rows=150 width=24) (actual time=0.004..0.004 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
118. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on c_greeting bpg (cost=0.00..11.50 rows=150 width=24) (actual time=0.003..0.003 rows=0 loops=1)

119. 0.053 0.122 ↑ 1.0 220 1

Hash (cost=8.76..8.76 rows=220 width=98) (actual time=0.122..0.122 rows=220 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 27kB
120. 0.069 0.069 ↑ 1.0 220 1

Seq Scan on c_doctype_trl dt_1 (cost=0.00..8.76 rows=220 width=98) (actual time=0.008..0.069 rows=220 loops=1)

  • Filter: ((ad_language)::text = 'pt_BR'::text)
  • Rows Removed by Filter: 1
121. 0.001 0.016 ↓ 0.0 0 1

Hash (cost=2.36..2.36 rows=1 width=344) (actual time=0.016..0.016 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
122. 0.015 0.015 ↓ 0.0 0 1

Index Scan using c_greeting_trl_pkey on c_greeting_trl bpgt (cost=0.14..2.36 rows=1 width=344) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((ad_language)::text = 'pt_BR'::text)
123. 24.690 44.430 ↑ 1.0 66,803 1

Hash (cost=2,747.03..2,747.03 rows=66,803 width=167) (actual time=44.430..44.430 rows=66,803 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 12140kB
124. 19.740 19.740 ↑ 1.0 66,803 1

Seq Scan on c_bpartner_location bpl (cost=0.00..2,747.03 rows=66,803 width=167) (actual time=0.008..19.740 rows=66,803 loops=1)

125. 33.190 57.739 ↑ 1.0 84,984 1

Hash (cost=3,206.84..3,206.84 rows=84,984 width=181) (actual time=57.739..57.739 rows=84,984 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 15964kB
126. 24.549 24.549 ↑ 1.0 84,984 1

Seq Scan on c_location l (cost=0.00..3,206.84 rows=84,984 width=181) (actual time=0.004..24.549 rows=84,984 loops=1)

127. 22.334 43.019 ↑ 1.0 56,380 1

Hash (cost=2,480.80..2,480.80 rows=56,380 width=312) (actual time=43.019..43.019 rows=56,380 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 10126kB
128. 20.685 20.685 ↑ 1.0 56,380 1

Seq Scan on ad_user bpc (cost=0.00..2,480.80 rows=56,380 width=312) (actual time=0.006..20.685 rows=56,380 loops=1)

129. 0.000 0.004 ↓ 0.0 0 1

Hash (cost=11.50..11.50 rows=150 width=24) (actual time=0.004..0.004 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
130. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on c_greeting bpcg (cost=0.00..11.50 rows=150 width=24) (actual time=0.004..0.004 rows=0 loops=1)

131. 0.000 0.010 ↓ 0.0 0 1

Hash (cost=2.36..2.36 rows=1 width=344) (actual time=0.010..0.010 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
132. 0.010 0.010 ↓ 0.0 0 1

Index Scan using c_greeting_trl_pkey on c_greeting_trl bpcgt (cost=0.14..2.36 rows=1 width=344) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((ad_language)::text = 'pt_BR'::text)
133. 0.017 0.028 ↑ 1.0 27 1

Hash (cost=1.27..1.27 rows=27 width=712) (actual time=0.028..0.028 rows=27 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
134. 0.011 0.011 ↑ 1.0 27 1

Seq Scan on ad_orginfo oi (cost=0.00..1.27 rows=27 width=712) (actual time=0.003..0.011 rows=27 loops=1)

135. 0.005 0.012 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=12) (actual time=0.012..0.012 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
136. 0.007 0.007 ↑ 1.0 2 1

Seq Scan on ad_clientinfo ci (cost=0.00..1.02 rows=2 width=12) (actual time=0.006..0.007 rows=2 loops=1)

137. 22.620 42.437 ↑ 1.0 56,380 1

Hash (cost=2,480.80..2,480.80 rows=56,380 width=312) (actual time=42.437..42.437 rows=56,380 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 10150kB
138. 19.817 19.817 ↑ 1.0 56,380 1

Seq Scan on ad_user u_1 (cost=0.00..2,480.80 rows=56,380 width=312) (actual time=0.006..19.817 rows=56,380 loops=1)

139. 27.976 52.952 ↑ 1.0 41,425 1

Hash (cost=2,759.25..2,759.25 rows=41,425 width=688) (actual time=52.952..52.952 rows=41,425 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 11730kB
140. 24.976 24.976 ↑ 1.0 41,425 1

Seq Scan on c_bpartner ubp (cost=0.00..2,759.25 rows=41,425 width=688) (actual time=0.007..24.976 rows=41,425 loops=1)

141. 27.449 53.851 ↑ 1.0 41,425 1

Hash (cost=2,759.25..2,759.25 rows=41,425 width=688) (actual time=53.850..53.851 rows=41,425 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 11726kB
142. 26.402 26.402 ↑ 1.0 41,425 1

Seq Scan on c_bpartner bbp (cost=0.00..2,759.25 rows=41,425 width=688) (actual time=0.007..26.402 rows=41,425 loops=1)

143. 24.866 46.047 ↑ 1.0 66,803 1

Hash (cost=2,747.03..2,747.03 rows=66,803 width=167) (actual time=46.047..46.047 rows=66,803 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 12140kB
144. 21.181 21.181 ↑ 1.0 66,803 1

Seq Scan on c_bpartner_location bbpl (cost=0.00..2,747.03 rows=66,803 width=167) (actual time=0.010..21.181 rows=66,803 loops=1)

145. 23.787 43.444 ↑ 1.0 66,803 1

Hash (cost=2,747.03..2,747.03 rows=66,803 width=161) (actual time=43.444..43.444 rows=66,803 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 11552kB
146. 19.657 19.657 ↑ 1.0 66,803 1

Seq Scan on c_bpartner_location cpfl (cost=0.00..2,747.03 rows=66,803 width=161) (actual time=0.007..19.657 rows=66,803 loops=1)

147. 25.461 46.199 ↑ 1.0 84,984 1

Hash (cost=3,206.84..3,206.84 rows=84,984 width=94) (actual time=46.199..46.199 rows=84,984 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 10330kB
148. 20.738 20.738 ↑ 1.0 84,984 1

Seq Scan on c_location cpfll (cost=0.00..3,206.84 rows=84,984 width=94) (actual time=0.006..20.738 rows=84,984 loops=1)

149. 22.296 41.761 ↑ 1.0 56,380 1

Hash (cost=2,480.80..2,480.80 rows=56,380 width=312) (actual time=41.761..41.761 rows=56,380 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 10126kB
150. 19.465 19.465 ↑ 1.0 56,380 1

Seq Scan on ad_user bbpc (cost=0.00..2,480.80 rows=56,380 width=312) (actual time=0.009..19.465 rows=56,380 loops=1)

151. 0.044 0.139 ↑ 1.0 174 1

Hash (cost=11.35..11.35 rows=174 width=27) (actual time=0.139..0.139 rows=174 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
152. 0.095 0.095 ↑ 1.0 174 1

Seq Scan on c_currency_trl cur (cost=0.00..11.35 rows=174 width=27) (actual time=0.016..0.095 rows=174 loops=1)

  • Filter: ((ad_language)::text = 'pt_BR'::text)
  • Rows Removed by Filter: 174
153. 0.012 0.026 ↑ 1.0 45 1

Hash (cost=2.45..2.45 rows=45 width=22) (actual time=0.026..0.026 rows=45 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
154. 0.014 0.014 ↑ 1.0 45 1

Seq Scan on cof_c_custody c (cost=0.00..2.45 rows=45 width=22) (actual time=0.003..0.014 rows=45 loops=1)

155. 73.042 252.094 ↑ 1.0 218,243 1

Hash (cost=20,524.43..20,524.43 rows=218,243 width=136) (actual time=252.094..252.094 rows=218,243 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 30302kB
156. 179.052 179.052 ↑ 1.0 218,243 1

Seq Scan on c_order o (cost=0.00..20,524.43 rows=218,243 width=136) (actual time=0.006..179.052 rows=218,243 loops=1)

157. 25.329 45.853 ↑ 1.0 84,984 1

Hash (cost=3,206.84..3,206.84 rows=84,984 width=94) (actual time=45.853..45.853 rows=84,984 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 10330kB
158. 20.524 20.524 ↑ 1.0 84,984 1

Seq Scan on c_location billloc (cost=0.00..3,206.84 rows=84,984 width=94) (actual time=0.007..20.524 rows=84,984 loops=1)

159. 0.397 1.152 ↑ 1.0 2,233 1

Hash (cost=135.33..135.33 rows=2,233 width=37) (actual time=1.152..1.152 rows=2,233 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 187kB
160. 0.755 0.755 ↑ 1.0 2,233 1

Seq Scan on m_product p (cost=0.00..135.33 rows=2,233 width=37) (actual time=0.073..0.755 rows=2,233 loops=1)

161. 155.201 516.081 ↑ 1.0 626,270 1

Hash (cost=48,750.90..48,750.90 rows=626,290 width=39) (actual time=516.081..516.081 rows=626,270 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 45067kB
162. 360.880 360.880 ↑ 1.0 626,270 1

Seq Scan on c_orderline oll (cost=0.00..48,750.90 rows=626,290 width=39) (actual time=0.006..360.880 rows=626,270 loops=1)

163. 7.859 29.659 ↑ 1.0 41,425 1

Hash (cost=2,759.25..2,759.25 rows=41,425 width=52) (actual time=29.659..29.659 rows=41,425 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2868kB
164. 21.800 21.800 ↑ 1.0 41,425 1

Seq Scan on c_bpartner billbp (cost=0.00..2,759.25 rows=41,425 width=52) (actual time=0.012..21.800 rows=41,425 loops=1)

165. 9.935 22.585 ↑ 1.0 56,380 1

Hash (cost=2,480.80..2,480.80 rows=56,380 width=18) (actual time=22.585..22.585 rows=56,380 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3327kB
166. 12.650 12.650 ↑ 1.0 56,380 1

Seq Scan on ad_user u (cost=0.00..2,480.80 rows=56,380 width=18) (actual time=0.011..12.650 rows=56,380 loops=1)

167. 0.041 0.124 ↑ 1.0 220 1

Hash (cost=12.20..12.20 rows=220 width=42) (actual time=0.124..0.124 rows=220 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
168. 0.083 0.083 ↑ 1.0 220 1

Seq Scan on c_doctype dt (cost=0.00..12.20 rows=220 width=42) (actual time=0.016..0.083 rows=220 loops=1)

169.          

SubPlan (forHash Left Join)

170. 0.150 0.150 ↓ 0.0 0 50

Index Scan using c_orderline_pkey on c_orderline (cost=0.42..2.64 rows=1 width=3) (actual time=0.003..0.003 rows=0 loops=50)

  • Index Cond: (c_orderline_id = ol.c_orderline_id)
171. 0.050 0.050 ↓ 0.0 0 50

Index Scan using c_orderline_pkey on c_orderline c_orderline_1 (cost=0.42..2.64 rows=1 width=3) (actual time=0.001..0.001 rows=0 loops=50)

  • Index Cond: (c_orderline_id = ol.c_orderline_id)
172. 0.200 0.200 ↑ 1.0 1 50

Index Scan using c_bpartner_location_pkey on c_bpartner_location (cost=0.29..2.51 rows=1 width=92) (actual time=0.003..0.004 rows=1 loops=50)

  • Index Cond: (c_bpartner_location_id = o.c_bpartner_location_id)
173. 7.550 8.350 ↑ 1.0 1 50

Aggregate (cost=4.63..4.64 rows=1 width=32) (actual time=0.167..0.167 rows=1 loops=50)

174. 0.414 0.800 ↑ 2.0 1 50

Hash Right Join (cost=2.68..4.10 rows=2 width=25) (actual time=0.014..0.016 rows=1 loops=50)

  • Hash Cond: (cn.cof_c_cardnetwork_id = ops.cof_c_cardnetwork_id)
175. 0.086 0.086 ↑ 1.0 27 43

Seq Scan on cof_c_cardnetwork cn (cost=0.00..1.27 rows=27 width=21) (actual time=0.001..0.002 rows=27 loops=43)

176. 0.000 0.300 ↑ 2.0 1 50

Hash (cost=2.66..2.66 rows=2 width=16) (actual time=0.006..0.006 rows=1 loops=50)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
177. 0.300 0.300 ↑ 2.0 1 50

Index Scan using idx_c_orderpayschedule_c_order_id on c_orderpayschedule ops (cost=0.42..2.66 rows=2 width=16) (actual time=0.005..0.006 rows=1 loops=50)

  • Index Cond: (c_order_id = o_1.c_order_id)