Openbravo Issue Tracking System - Modules
openbravo=# explain analyze delete from c_invoice where c_invoice_id='BF4FB8533D864288B7C9834F988D40FA';
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------
Delete on c_invoice (cost=0.56..8.57 rows=1 width=6) (actual time=0.177..0.177 rows=0 loops=1)
-> Index Scan using c_invoice_key on c_invoice (cost=0.56..8.57 rows=1 width=6) (actual time=0.055..0.056 rows=1 loops=1)
Index Cond: ((c_invoice_id)::text = 'BF4FB8533D864288B7C9834F988D40FA'::text)
Trigger for constraint obanaly_fact_disc_inv_fk: time=3.157 calls=1
Trigger for constraint obanaly_fact_order_inv_fk: time=129267.366 calls=1
Trigger for constraint aprm_pending_payinv_invoice: time=0.198 calls=1
Trigger for constraint c_currencyratedocinv: time=0.104 calls=1
Trigger for constraint c_debt_payment_c_invoice: time=0.112 calls=1
Trigger for constraint c_invoice_ccommissionrun: time=5.052 calls=1
Trigger for constraint c_invoice_discount_c_invoice: time=0.170 calls=1
Trigger for constraint c_invoice_reverse_c_invoice: time=0.096 calls=1
Trigger for constraint c_invoice_reverse_reversed_c_i: time=0.247 calls=1
Trigger for constraint c_invoicelinetax_c_invoice: time=1.807 calls=1
Trigger for constraint c_invoicetax_c_invoice: time=1.337 calls=1
Trigger for constraint fin_c_invoice_orig_payment: time=1.241 calls=1
Trigger for constraint fin_c_invoice_payment: time=0.100 calls=1
Trigger for constraint i_invoice_c_invoice: time=0.084 calls=1
Trigger for constraint m_inout_c_invoice: time=0.588 calls=1
Trigger for constraint m_rappel_invoice_c_invoice: time=0.086 calls=1
Trigger for constraint c_invoiceline_c_invoice: time=0.138 calls=1
Trigger c_invoice_trg: time=0.076 calls=1
Total runtime: 129282.500 ms
AS you can see most of the time is consumed on:
Trigger for constraint obanaly_fact_order_inv_fk: time=129267.366 calls=1
38579.diff (624) 2018-05-18 09:59https://issues.openbravo.com/file_download.php?file_id=11804&type=bug