explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XDPy

Settings
# exclusive inclusive rows x rows loops node
1. 2.523 41,443.624 ↑ 7,418.8 110 1

Sort (cost=21,160,392.69..21,162,432.87 rows=816,070 width=19,299) (actual time=41,443.617..41,443.624 rows=110 loops=1)

  • Sort Key: o_1.c_order_id, oll.c_orderline_id
  • Sort Method: quicksort Memory: 602kB
2. 1.086 41,441.101 ↑ 7,418.8 110 1

Hash Left Join (cost=5,348,166.39..17,133,158.62 rows=816,070 width=19,299) (actual time=36,988.808..41,441.101 rows=110 loops=1)

  • Hash Cond: (o.c_doctypetarget_id = dt.c_doctype_id)
3. 0.873 41,425.240 ↑ 7,418.8 110 1

Hash Left Join (cost=5,348,151.44..6,952,527.15 rows=816,070 width=18,344) (actual time=36,984.411..41,425.240 rows=110 loops=1)

  • Hash Cond: (o.z_digitador_id = u.ad_user_id)
4. 0.906 41,400.242 ↑ 7,418.8 110 1

Hash Left Join (cost=5,344,953.53..6,947,186.90 rows=816,070 width=18,338) (actual time=36,959.750..41,400.242 rows=110 loops=1)

  • Hash Cond: (o_1.bill_bpartner_id = billbp.c_bpartner_id)
5. 8.682 41,367.268 ↑ 7,418.8 110 1

Hash Left Join (cost=5,341,660.61..6,941,751.58 rows=816,070 width=18,293) (actual time=36,927.115..41,367.268 rows=110 loops=1)

  • Hash Cond: (ol.c_orderline_id = oll.c_orderline_id)
6. 0.570 40,768.486 ↑ 7,418.8 110 1

Hash Left Join (cost=5,285,109.18..6,883,057.96 rows=816,070 width=18,254) (actual time=36,328.666..40,768.486 rows=110 loops=1)

  • Hash Cond: (pt_1.m_product_id = p.m_product_id)
7. 322.867 40,766.475 ↑ 7,418.8 110 1

Hash Join (cost=5,284,945.94..6,880,748.47 rows=816,070 width=18,223) (actual time=36,327.002..40,766.475 rows=110 loops=1)

  • Hash Cond: (ol.c_order_id = o_1.c_order_id)
8. 6,396.415 39,441.680 ↑ 1.0 1,640,412 1

Unique (cost=5,187,050.53..6,751,982.27 rows=1,651,643 width=11,216) (actual time=31,319.566..39,441.680 rows=1,640,412 loops=1)

9. 15,726.667 33,045.265 ↑ 1.0 1,640,412 1

Sort (cost=5,187,050.53..5,191,179.64 rows=1,651,643 width=11,216) (actual time=31,319.564..33,045.265 rows=1,640,412 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: 908640kB
10. 172.402 17,318.598 ↑ 1.0 1,640,412 1

Append (cost=30,379.16..370,822.66 rows=1,651,643 width=11,216) (actual time=439.413..17,318.598 rows=1,640,412 loops=1)

11. 3,536.456 14,818.933 ↑ 1.0 625,095 1

Hash Left Join (cost=30,379.16..298,921.27 rows=627,308 width=7,021) (actual time=439.412..14,818.933 rows=625,095 loops=1)

  • Hash Cond: (((uomt.ad_language)::text = (tt.ad_language)::text) AND (ol.c_tax_id = tt.c_tax_id))
12. 1,063.422 11,282.416 ↑ 1.0 625,095 1

Hash Left Join (cost=30,373.52..107,349.82 rows=627,308 width=6,309) (actual time=438.565..11,282.416 rows=625,095 loops=1)

  • Hash Cond: (ol.c_tax_id = t.c_tax_id)
13. 1,073.107 10,218.926 ↑ 1.0 625,095 1

Hash Join (cost=30,368.36..105,625.28 rows=627,308 width=6,214) (actual time=438.482..10,218.926 rows=625,095 loops=1)

  • Hash Cond: (ol.c_bpartner_location_id = bpl_1.c_bpartner_location_id)
14. 1,214.333 9,098.940 ↑ 1.0 625,095 1

Hash Join (cost=26,787.60..100,397.74 rows=627,308 width=6,052) (actual time=391.138..9,098.940 rows=625,095 loops=1)

  • Hash Cond: (ol.c_bpartner_id = bp_1.c_bpartner_id)
15. 771.536 7,831.470 ↑ 1.0 625,095 1

Hash Left Join (cost=23,494.67..95,457.96 rows=627,308 width=5,363) (actual time=337.762..7,831.470 rows=625,095 loops=1)

  • Hash Cond: ((ol.m_product_id = pp.m_product_id) AND (i.c_bpartner_id = pp.c_bpartner_id))
16. 672.993 7,059.906 ↑ 1.0 625,095 1

Hash Left Join (cost=23,492.80..92,162.72 rows=627,308 width=5,050) (actual time=337.719..7,059.906 rows=625,095 loops=1)

  • Hash Cond: (((uomt.ad_language)::text = (ct.ad_language)::text) AND (ol.c_charge_id = ct.c_charge_id))
17. 612.847 6,386.716 ↑ 1.0 625,095 1

Hash Left Join (cost=23,474.28..88,850.74 rows=627,308 width=5,004) (actual time=337.510..6,386.716 rows=625,095 loops=1)

  • Hash Cond: (ol.c_charge_id = c_1.c_charge_id)
18. 631.881 5,773.673 ↑ 1.0 625,095 1

Hash Left Join (cost=23,457.50..87,187.18 rows=627,308 width=4,930) (actual time=337.302..5,773.673 rows=625,095 loops=1)

  • Hash Cond: (ol.s_resourceassignment_id = ra.s_resourceassignment_id)
19. 700.401 5,141.790 ↑ 1.0 625,095 1

Hash Left Join (cost=23,445.70..85,528.70 rows=627,308 width=4,132) (actual time=337.284..5,141.790 rows=625,095 loops=1)

  • Hash Cond: ((p_1.m_product_id = po.m_product_id) AND (i.c_bpartner_id = po.c_bpartner_id))
20. 833.250 4,441.122 ↑ 1.0 625,095 1

Hash Left Join (cost=23,427.70..82,217.33 rows=627,308 width=3,834) (actual time=337.001..4,441.122 rows=625,095 loops=1)

  • Hash Cond: (((uomt.ad_language)::text = (pt_1.ad_language)::text) AND (ol.m_product_id = pt_1.m_product_id))
21. 854.894 3,606.502 ↑ 1.0 625,095 1

Hash Left Join (cost=23,314.29..78,807.13 rows=627,308 width=3,733) (actual time=335.605..3,606.502 rows=625,095 loops=1)

  • Hash Cond: (ol.m_product_id = p_1.m_product_id)
22. 868.742 2,749.210 ↑ 1.0 625,095 1

Hash Join (cost=23,151.05..76,994.09 rows=627,308 width=1,696) (actual time=333.175..2,749.210 rows=625,095 loops=1)

  • Hash Cond: (ol.c_order_id = i.c_order_id)
23. 469.656 1,548.431 ↑ 1.0 625,095 1

Hash Join (cost=11.15..52,207.48 rows=627,308 width=511) (actual time=0.208..1,548.431 rows=625,095 loops=1)

  • Hash Cond: (ol.c_uom_id = uomt.c_uom_id)
24. 473.043 1,078.678 ↑ 1.0 625,095 1

Hash Join (cost=3.64..50,456.00 rows=627,308 width=459) (actual time=0.096..1,078.678 rows=625,095 loops=1)

  • Hash Cond: (ol.c_uom_id = uom.c_uom_id)
25. 605.577 605.577 ↑ 1.0 625,095 1

Seq Scan on c_orderline ol (cost=0.00..48,710.08 rows=627,308 width=437) (actual time=0.009..605.577 rows=625,095 loops=1)

26. 0.029 0.058 ↑ 1.0 73 1

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

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

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

28. 0.032 0.097 ↑ 1.0 73 1

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

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

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

  • Filter: ((ad_language)::text = 'pt_BR'::text)
  • Rows Removed by Filter: 135
30. 167.860 332.037 ↑ 1.0 217,861 1

Hash (cost=20,351.62..20,351.62 rows=223,062 width=1,191) (actual time=332.037..332.037 rows=217,861 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 70966kB
31. 164.177 164.177 ↑ 1.0 217,861 1

Seq Scan on c_order i (cost=0.00..20,351.62 rows=223,062 width=1,191) (actual time=0.008..164.177 rows=217,861 loops=1)

32. 1.165 2.398 ↑ 1.0 2,233 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 463kB
33. 1.233 1.233 ↑ 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.007..1.233 rows=2,233 loops=1)

34. 0.721 1.370 ↑ 1.0 2,233 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 348kB
35. 0.649 0.649 ↑ 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.649 rows=2,233 loops=1)

  • Filter: ((ad_language)::text = 'pt_BR'::text)
36. 0.145 0.267 ↑ 1.1 320 1

Hash (cost=12.60..12.60 rows=360 width=304) (actual time=0.267..0.267 rows=320 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 57kB
37. 0.122 0.122 ↑ 1.1 320 1

Seq Scan on m_product_po po (cost=0.00..12.60 rows=360 width=304) (actual time=0.006..0.122 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.088 0.196 ↑ 1.0 346 1

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

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

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

42. 0.093 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.104 0.104 ↑ 1.0 346 1

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

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

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

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

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

46. 27.858 53.137 ↑ 1.0 41,375 1

Hash (cost=2,762.41..2,762.41 rows=42,441 width=695) (actual time=53.137..53.137 rows=41,375 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 11716kB
47. 25.279 25.279 ↑ 1.0 41,375 1

Seq Scan on c_bpartner bp_1 (cost=0.00..2,762.41 rows=42,441 width=695) (actual time=0.008..25.279 rows=41,375 loops=1)

48. 26.879 46.879 ↑ 1.0 66,715 1

Hash (cost=2,746.45..2,746.45 rows=66,745 width=168) (actual time=46.879..46.879 rows=66,715 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 12125kB
49. 20.000 20.000 ↑ 1.0 66,715 1

Seq Scan on c_bpartner_location bpl_1 (cost=0.00..2,746.45 rows=66,745 width=168) (actual time=0.006..20.000 rows=66,715 loops=1)

50. 0.031 0.068 ↑ 1.0 96 1

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

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

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

52. 0.031 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.030 0.030 ↑ 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.030 rows=96 loops=1)

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

Nested Loop (cost=2.25..1,168.06 rows=28 width=9,133) (actual time=0.010..0.010 rows=0 loops=1)

55. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=1.97..1,158.09 rows=28 width=4,559) (actual time=0.010..0.010 rows=0 loops=1)

56. 0.000 0.009 ↓ 0.0 0 1

Nested Loop (cost=1.82..1,151.71 rows=38 width=4,531) (actual time=0.009..0.009 rows=0 loops=1)

57. 0.000 0.009 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.68..1,145.64 rows=38 width=4,495) (actual time=0.009..0.009 rows=0 loops=1)

58. 0.000 0.009 ↓ 0.0 0 1

Nested Loop (cost=1.41..1,134.28 rows=38 width=4,191) (actual time=0.009..0.009 rows=0 loops=1)

59. 0.001 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.99..1,116.41 rows=38 width=3,006) (actual time=0.009..0.009 rows=0 loops=1)

60. 0.000 0.008 ↓ 0.0 0 1

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

61. 0.004 0.012 ↓ 0.0 0 1

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

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

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

63. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on pp_product_bom b (cost=0.00..10.40 rows=40 width=32) (actual time=0.007..0.008 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,011.96 rows=2,096 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,191) (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=304) (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. 418.785 489.857 ↑ 1.0 217,861 1

Nested Loop (cost=0.14..22,584.60 rows=223,062 width=11,140) (actual time=0.032..489.857 rows=217,861 loops=1)

74. 0.022 0.022 ↑ 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.020..0.022 rows=1 loops=1)

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

Seq Scan on c_order i_2 (cost=0.00..20,351.62 rows=223,062 width=50) (actual time=0.005..71.050 rows=217,861 loops=1)

76. 1,766.470 1,837.396 ↑ 1.0 797,456 1

Hash Join (cost=5.40..31,632.30 rows=801,245 width=11,083) (actual time=0.092..1,837.396 rows=797,456 loops=1)

  • Hash Cond: (ot.c_tax_id = tt_1.c_tax_id)
77. 70.867 70.867 ↑ 1.0 797,456 1

Seq Scan on c_ordertax ot (cost=0.00..23,421.45 rows=801,245 width=71) (actual time=0.015..70.867 rows=797,456 loops=1)

78. 0.022 0.059 ↑ 1.0 96 1

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

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

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

  • Filter: ((ad_language)::text = 'pt_BR'::text)
80. 0.130 1,001.928 ↑ 7,872.4 14 1

Hash (cost=96,517.73..96,517.73 rows=110,214 width=7,007) (actual time=1,001.928..1,001.928 rows=14 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 1063kB
81. 0.508 1,001.798 ↑ 7,872.4 14 1

Hash Left Join (cost=66,265.94..96,517.73 rows=110,214 width=7,007) (actual time=1,000.816..1,001.798 rows=14 loops=1)

  • Hash Cond: (bbpl.c_location_id = billloc.c_location_id)
82. 1.105 951.991 ↑ 7,872.4 14 1

Hash Left Join (cost=61,998.29..91,960.75 rows=110,214 width=6,919) (actual time=951.039..951.991 rows=14 loops=1)

  • Hash Cond: (o_1.c_order_id = o.c_order_id)
83. 0.047 662.208 ↑ 7,872.4 14 1

Hash Left Join (cost=38,858.39..68,531.54 rows=110,214 width=6,789) (actual time=661.287..662.208 rows=14 loops=1)

  • Hash Cond: (o_1.cof_c_custody_id = c.cof_c_custody_id)
84. 0.066 662.131 ↑ 7,872.4 14 1

Hash Left Join (cost=38,855.38..68,211.97 rows=110,214 width=6,780) (actual time=661.240..662.131 rows=14 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.323 661.902 ↑ 7,872.4 14 1

Hash Left Join (cost=38,841.42..67,611.64 rows=110,214 width=6,764) (actual time=661.039..661.902 rows=14 loops=1)

  • Hash Cond: (o_1.bill_user_id = bbpc.ad_user_id)
86. 0.495 611.834 ↑ 7,872.4 14 1

Hash Left Join (cost=35,643.51..64,124.40 rows=110,214 width=6,463) (actual time=611.005..611.834 rows=14 loops=1)

  • Hash Cond: (cpfl.c_location_id = cpfll.c_location_id)
87. 0.497 560.417 ↑ 7,872.4 14 1

Hash Left Join (cost=31,375.86..59,567.42 rows=110,214 width=6,381) (actual time=559.621..560.417 rows=14 loops=1)

  • Hash Cond: (o_1.cof_payfrom_location_id = cpfl.c_bpartner_location_id)
88. 0.588 515.742 ↑ 7,872.4 14 1

Hash Join (cost=27,795.09..55,697.32 rows=110,214 width=6,232) (actual time=514.978..515.742 rows=14 loops=1)

  • Hash Cond: (o_1.bill_location_id = bbpl.c_bpartner_location_id)
89. 0.277 460.557 ↑ 7,872.4 14 1

Hash Join (cost=24,214.33..51,827.22 rows=110,214 width=6,070) (actual time=459.825..460.557 rows=14 loops=1)

  • Hash Cond: (o_1.bill_bpartner_id = bbp.c_bpartner_id)
90. 0.278 405.617 ↑ 7,872.4 14 1

Hash Left Join (cost=20,921.41..48,244.95 rows=110,214 width=5,381) (actual time=404.920..405.617 rows=14 loops=1)

  • Hash Cond: (u_1.c_bpartner_id = ubp.c_bpartner_id)
91. 0.273 353.318 ↑ 7,872.4 14 1

Hash Left Join (cost=17,628.49..44,662.69 rows=110,214 width=4,692) (actual time=352.651..353.318 rows=14 loops=1)

  • Hash Cond: (o_1.salesrep_id = u_1.ad_user_id)
92. 0.052 311.384 ↑ 7,872.4 14 1

Hash Join (cost=14,430.58..41,175.45 rows=110,214 width=4,391) (actual time=310.744..311.384 rows=14 loops=1)

  • Hash Cond: (o_1.ad_client_id = ci.ad_client_id)
93. 0.038 311.321 ↑ 7,872.4 14 1

Hash Join (cost=14,429.53..40,272.02 rows=110,214 width=4,384) (actual time=310.700..311.321 rows=14 loops=1)

  • Hash Cond: (o_1.ad_org_id = oi.ad_org_id)
94. 0.044 311.256 ↑ 7,872.4 14 1

Hash Left Join (cost=14,427.92..39,935.69 rows=110,214 width=3,672) (actual time=310.658..311.256 rows=14 loops=1)

  • Hash Cond: (((dt_1.ad_language)::text = (bpcgt.ad_language)::text) AND (bpc.c_greeting_id = bpcgt.c_greeting_id))
95. 0.036 311.202 ↑ 7,872.4 14 1

Hash Left Join (cost=14,425.55..39,354.69 rows=110,214 width=3,372) (actual time=310.621..311.202 rows=14 loops=1)

  • Hash Cond: (bpc.c_greeting_id = bpcg.c_greeting_id)
96. 0.262 311.163 ↑ 7,872.4 14 1

Hash Left Join (cost=14,412.17..39,052.00 rows=110,214 width=3,364) (actual time=310.599..311.163 rows=14 loops=1)

  • Hash Cond: (o_1.ad_user_id = bpc.ad_user_id)
97. 0.494 267.632 ↑ 7,872.4 14 1

Hash Join (cost=11,214.26..35,564.76 rows=110,214 width=3,063) (actual time=267.092..267.632 rows=14 loops=1)

  • Hash Cond: (bpl.c_location_id = l.c_location_id)
98. 0.506 209.203 ↑ 7,872.4 14 1

Hash Join (cost=6,946.61..31,007.78 rows=110,214 width=2,887) (actual time=208.686..209.203 rows=14 loops=1)

  • Hash Cond: (o_1.c_bpartner_location_id = bpl.c_bpartner_location_id)
99. 0.109 158.705 ↑ 7,872.4 14 1

Hash Left Join (cost=3,365.84..27,137.69 rows=110,214 width=2,725) (actual time=158.212..158.705 rows=14 loops=1)

  • Hash Cond: (((dt_1.ad_language)::text = (bpgt.ad_language)::text) AND (bp.c_greeting_id = bpgt.c_greeting_id))
100. 0.038 158.589 ↑ 7,872.4 14 1

Hash Join (cost=3,363.47..26,556.68 rows=110,214 width=2,425) (actual time=158.109..158.589 rows=14 loops=1)

  • Hash Cond: (o_1.c_doctype_id = dt_1.c_doctype_id)
101. 0.061 158.407 ↑ 7,572.7 14 1

Hash Left Join (cost=3,351.95..26,261.30 rows=106,018 width=2,339) (actual time=157.943..158.407 rows=14 loops=1)

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

Hash Join (cost=3,338.58..25,969.63 rows=106,018 width=2,331) (actual time=157.887..158.338 rows=14 loops=1)

  • Hash Cond: (o_1.c_bpartner_id = bp.c_bpartner_id)
103. 0.028 101.123 ↑ 7,572.7 14 1

Hash Join (cost=45.66..22,398.39 rows=106,018 width=1,594) (actual time=100.697..101.123 rows=14 loops=1)

  • Hash Cond: (o_1.c_paymentterm_id = ptt.c_paymentterm_id)
104. 0.029 100.822 ↑ 7,572.7 14 1

Hash Join (cost=26.03..22,097.69 rows=106,018 width=1,528) (actual time=100.410..100.822 rows=14 loops=1)

  • Hash Cond: (o_1.c_paymentterm_id = pt.c_paymentterm_id)
105. 0.028 100.489 ↑ 7,572.7 14 1

Hash Join (cost=4.47..21,795.06 rows=106,018 width=1,471) (actual time=100.092..100.489 rows=14 loops=1)

  • Hash Cond: (o_1.m_warehouse_id = wh.m_warehouse_id)
106. 100.372 100.433 ↑ 7,572.7 14 1

Seq Scan on c_order o_1 (cost=2.88..21,469.81 rows=106,018 width=1,230) (actual time=100.050..100.433 rows=14 loops=1)

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

SubPlan (forSeq Scan)

108. 0.061 0.061 ↓ 1.1 14 1

Index Scan using idx_t_selection_ad_pinstance_id on t_selection (cost=0.42..2.85 rows=13 width=7) (actual time=0.058..0.061 rows=14 loops=1)

  • Index Cond: (ad_pinstance_id = '8036772'::numeric)
109. 0.017 0.028 ↑ 1.0 26 1

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

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

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

111. 0.133 0.304 ↑ 1.0 425 1

Hash (cost=16.25..16.25 rows=425 width=57) (actual time=0.304..0.304 rows=425 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
112. 0.171 0.171 ↑ 1.0 425 1

Seq Scan on c_paymentterm pt (cost=0.00..16.25 rows=425 width=57) (actual time=0.007..0.171 rows=425 loops=1)

113. 0.132 0.273 ↑ 1.0 425 1

Hash (cost=14.31..14.31 rows=425 width=78) (actual time=0.273..0.273 rows=425 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
114. 0.141 0.141 ↑ 1.0 425 1

Seq Scan on c_paymentterm_trl ptt (cost=0.00..14.31 rows=425 width=78) (actual time=0.015..0.141 rows=425 loops=1)

  • Filter: ((ad_language)::text = 'pt_BR'::text)
115. 29.451 57.108 ↑ 1.0 41,375 1

Hash (cost=2,762.41..2,762.41 rows=42,441 width=743) (actual time=57.108..57.108 rows=41,375 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 12605kB
116. 27.657 27.657 ↑ 1.0 41,375 1

Seq Scan on c_bpartner bp (cost=0.00..2,762.41 rows=42,441 width=743) (actual time=0.006..27.657 rows=41,375 loops=1)

117. 0.001 0.008 ↓ 0.0 0 1

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

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

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

119. 0.067 0.144 ↑ 1.0 220 1

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

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
122. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: ((ad_language)::text = 'pt_BR'::text)
123. 28.103 49.992 ↑ 1.0 66,715 1

Hash (cost=2,746.45..2,746.45 rows=66,745 width=168) (actual time=49.992..49.992 rows=66,715 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 12125kB
124. 21.889 21.889 ↑ 1.0 66,715 1

Seq Scan on c_bpartner_location bpl (cost=0.00..2,746.45 rows=66,745 width=168) (actual time=0.006..21.889 rows=66,715 loops=1)

125. 33.137 57.935 ↑ 1.0 84,894 1

Hash (cost=3,205.07..3,205.07 rows=85,007 width=182) (actual time=57.935..57.935 rows=84,894 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 15947kB
126. 24.798 24.798 ↑ 1.0 84,894 1

Seq Scan on c_location l (cost=0.00..3,205.07 rows=85,007 width=182) (actual time=0.004..24.798 rows=84,894 loops=1)

127. 22.497 43.269 ↑ 1.0 56,320 1

Hash (cost=2,484.07..2,484.07 rows=57,107 width=307) (actual time=43.269..43.269 rows=56,320 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 10115kB
128. 20.772 20.772 ↑ 1.0 56,320 1

Seq Scan on ad_user bpc (cost=0.00..2,484.07 rows=57,107 width=307) (actual time=0.006..20.772 rows=56,320 loops=1)

129. 0.000 0.003 ↓ 0.0 0 1

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

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

Seq Scan on c_greeting bpcg (cost=0.00..11.50 rows=150 width=24) (actual time=0.003..0.003 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.016 0.027 ↑ 1.0 27 1

Hash (cost=1.27..1.27 rows=27 width=712) (actual time=0.027..0.027 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.006 0.011 ↑ 1.0 2 1

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

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

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

137. 22.267 41.661 ↑ 1.0 56,320 1

Hash (cost=2,484.07..2,484.07 rows=57,107 width=307) (actual time=41.661..41.661 rows=56,320 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 10138kB
138. 19.394 19.394 ↑ 1.0 56,320 1

Seq Scan on ad_user u_1 (cost=0.00..2,484.07 rows=57,107 width=307) (actual time=0.006..19.394 rows=56,320 loops=1)

139. 27.456 52.021 ↑ 1.0 41,375 1

Hash (cost=2,762.41..2,762.41 rows=42,441 width=695) (actual time=52.021..52.021 rows=41,375 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 11716kB
140. 24.565 24.565 ↑ 1.0 41,375 1

Seq Scan on c_bpartner ubp (cost=0.00..2,762.41 rows=42,441 width=695) (actual time=0.007..24.565 rows=41,375 loops=1)

141. 27.647 54.663 ↑ 1.0 41,375 1

Hash (cost=2,762.41..2,762.41 rows=42,441 width=695) (actual time=54.663..54.663 rows=41,375 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 11713kB
142. 27.016 27.016 ↑ 1.0 41,375 1

Seq Scan on c_bpartner bbp (cost=0.00..2,762.41 rows=42,441 width=695) (actual time=0.008..27.016 rows=41,375 loops=1)

143. 30.092 54.597 ↑ 1.0 66,715 1

Hash (cost=2,746.45..2,746.45 rows=66,745 width=168) (actual time=54.597..54.597 rows=66,715 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 12125kB
144. 24.505 24.505 ↑ 1.0 66,715 1

Seq Scan on c_bpartner_location bbpl (cost=0.00..2,746.45 rows=66,745 width=168) (actual time=0.009..24.505 rows=66,715 loops=1)

145. 24.344 44.178 ↑ 1.0 66,715 1

Hash (cost=2,746.45..2,746.45 rows=66,745 width=162) (actual time=44.178..44.178 rows=66,715 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 11538kB
146. 19.834 19.834 ↑ 1.0 66,715 1

Seq Scan on c_bpartner_location cpfl (cost=0.00..2,746.45 rows=66,745 width=162) (actual time=0.017..19.834 rows=66,715 loops=1)

147. 28.244 50.922 ↑ 1.0 84,894 1

Hash (cost=3,205.07..3,205.07 rows=85,007 width=94) (actual time=50.922..50.922 rows=84,894 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 10319kB
148. 22.678 22.678 ↑ 1.0 84,894 1

Seq Scan on c_location cpfll (cost=0.00..3,205.07 rows=85,007 width=94) (actual time=0.006..22.678 rows=84,894 loops=1)

149. 26.369 49.745 ↑ 1.0 56,320 1

Hash (cost=2,484.07..2,484.07 rows=57,107 width=307) (actual time=49.745..49.745 rows=56,320 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 10115kB
150. 23.376 23.376 ↑ 1.0 56,320 1

Seq Scan on ad_user bbpc (cost=0.00..2,484.07 rows=57,107 width=307) (actual time=0.007..23.376 rows=56,320 loops=1)

151. 0.054 0.163 ↑ 1.0 174 1

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

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

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

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

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

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

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

155. 85.442 288.678 ↑ 1.0 217,861 1

Hash (cost=20,351.62..20,351.62 rows=223,062 width=136) (actual time=288.678..288.678 rows=217,861 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 30251kB
156. 203.236 203.236 ↑ 1.0 217,861 1

Seq Scan on c_order o (cost=0.00..20,351.62 rows=223,062 width=136) (actual time=0.007..203.236 rows=217,861 loops=1)

157. 27.554 49.299 ↑ 1.0 84,894 1

Hash (cost=3,205.07..3,205.07 rows=85,007 width=94) (actual time=49.299..49.299 rows=84,894 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 10319kB
158. 21.745 21.745 ↑ 1.0 84,894 1

Seq Scan on c_location billloc (cost=0.00..3,205.07 rows=85,007 width=94) (actual time=0.005..21.745 rows=84,894 loops=1)

159. 0.562 1.441 ↑ 1.0 2,233 1

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

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

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

161. 205.297 590.100 ↑ 1.0 625,095 1

Hash (cost=48,710.08..48,710.08 rows=627,308 width=39) (actual time=590.100..590.100 rows=625,095 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 44999kB
162. 384.803 384.803 ↑ 1.0 625,095 1

Seq Scan on c_orderline oll (cost=0.00..48,710.08 rows=627,308 width=39) (actual time=0.086..384.803 rows=625,095 loops=1)

163. 9.781 32.068 ↑ 1.0 41,375 1

Hash (cost=2,762.41..2,762.41 rows=42,441 width=51) (actual time=32.068..32.068 rows=41,375 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2865kB
164. 22.287 22.287 ↑ 1.0 41,375 1

Seq Scan on c_bpartner billbp (cost=0.00..2,762.41 rows=42,441 width=51) (actual time=0.030..22.287 rows=41,375 loops=1)

165. 12.234 24.125 ↑ 1.0 56,320 1

Hash (cost=2,484.07..2,484.07 rows=57,107 width=18) (actual time=24.125..24.125 rows=56,320 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3324kB
166. 11.891 11.891 ↑ 1.0 56,320 1

Seq Scan on ad_user u (cost=0.00..2,484.07 rows=57,107 width=18) (actual time=0.018..11.891 rows=56,320 loops=1)

167. 0.061 0.145 ↑ 1.0 220 1

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

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

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

169.          

SubPlan (forHash Left Join)

170. 0.330 0.330 ↓ 0.0 0 110

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=110)

  • Index Cond: (c_orderline_id = ol.c_orderline_id)
171. 0.110 0.110 ↓ 0.0 0 110

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=110)

  • Index Cond: (c_orderline_id = ol.c_orderline_id)
172. 0.440 0.440 ↑ 1.0 1 110

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

  • Index Cond: (c_bpartner_location_id = o.c_bpartner_location_id)
173. 12.100 13.750 ↑ 1.0 1 110

Aggregate (cost=4.63..4.64 rows=1 width=32) (actual time=0.125..0.125 rows=1 loops=110)

174. 0.906 1.650 ↑ 2.0 1 110

Hash Right Join (cost=2.68..4.09 rows=2 width=25) (actual time=0.012..0.015 rows=1 loops=110)

  • Hash Cond: (cn.cof_c_cardnetwork_id = ops.cof_c_cardnetwork_id)
175. 0.194 0.194 ↑ 1.0 27 97

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=97)

176. 0.110 0.550 ↑ 2.0 1 110

Hash (cost=2.65..2.65 rows=2 width=16) (actual time=0.005..0.005 rows=1 loops=110)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
177. 0.440 0.440 ↑ 2.0 1 110

Index Scan using idx_c_orderpayschedule_c_order_id on c_orderpayschedule ops (cost=0.42..2.65 rows=2 width=16) (actual time=0.003..0.004 rows=1 loops=110)

  • Index Cond: (c_order_id = o_1.c_order_id)