Times Reported Time consuming queries #1

x Hide

[ User: tad - Total duration: 2m16s - Times executed: 90 ]

x Hide

[ Application: openbravo - Total duration: 2m16s - Times executed: 90 ]

x Hide

SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-17 07:39:30
Duration: 1s611ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo
Bind query: yes

SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-17 12:09:30
Duration: 1s600ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo
Bind query: yes

SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-17 16:39:30
Duration: 1s595ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: tad - Total duration: 1m19s - Times executed: 30 ]

x Hide

[ Application: openbravo - Total duration: 1m19s - Times executed: 30 ]

x Hide

update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);

Date: 2026-07-17 14:00:04
Duration: 2s800ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo
Bind query: yes

update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);

Date: 2026-07-17 18:00:04
Duration: 2s766ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo
Bind query: yes

update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);

Date: 2026-07-17 15:00:04
Duration: 2s749ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo
Bind query: yes