SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;

Date: 2026-07-17 07:00:11
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: postgres - Total duration: 5m40s - Times executed: 15 ]

x Hide

[ Application: psql - Total duration: 5m40s - Times executed: 15 ]

x Hide

SELECT profile.take_sample ();

Date: 2026-07-17 11:00:50
Duration: 49s344ms
Database: etendo
User: postgres
Remote: [local]
Application: psql

SELECT profile.take_sample ();

Date: 2026-07-17 08:00:51
Duration: 49s148ms
Database: etendo
User: postgres
Remote: [local]
Application: psql

SELECT profile.take_sample ();

Date: 2026-07-17 17:00:22
Duration: 21s48ms
Database: etendo
User: postgres
Remote: [local]
Application: psql

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: tad - Total duration: 3m43s - Times executed: 15 ]

x Hide

[ Application: openbravo - Total duration: 3m43s - Times executed: 15 ]

x Hide

SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '67AC26DEBEC1455D9510182FB973BC34' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-17 10:00:19
Duration: 18s261ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo
Bind query: yes

SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '67AC26DEBEC1455D9510182FB973BC34' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

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

SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as 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, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '67AC26DEBEC1455D9510182FB973BC34' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

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