Times Reported Time consuming queries #1

x Hide

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

x Hide

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

x Hide

UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-18 16:29:34
Duration: 1s648ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo
Bind query: yes

UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-18 20:29:34
Duration: 1s645ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo
Bind query: yes

UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-18 19:39:34
Duration: 1s643ms
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: 2m19s - Times executed: 90 ]

x Hide

[ Application: openbravo - Total duration: 2m19s - 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-18 13:09:30
Duration: 1s642ms
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-18 08:19:30
Duration: 1s631ms
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-18 15:39:30
Duration: 1s627ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo
Bind query: yes