pgBadger-
Global information
- Generated on Tue Jul 14 23:03:59 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 2,524,863 log entries in 3m57s
- Log start from 2026-07-14 07:00:01 to 2026-07-14 22:00:00
-
Overview
Global Stats
- 1,628 Number of unique normalized queries
- 1,197,130 Number of queries
- 4m16s Total query duration
- 2026-07-14 07:00:01 First query
- 2026-07-14 22:00:00 Last query
- 3,076 queries/s at 2026-07-14 13:34:41 Query peak
- 4m16s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4m16s Execute total duration
- 7 Number of events
- 4 Number of unique normalized events
- 3 Max number of times the same event was reported
- 0 Number of cancellation
- 97 Total number of automatic vacuums
- 152 Total number of automatic analyzes
- 21 Number temporary file
- 90.74 MiB Max size of temporary file
- 19.74 MiB Average size of temporary file
- 5,416 Total number of sessions
- 0 sessions at Session peak
- 7h10m48s Total duration of sessions
- 4s772ms Average duration of sessions
- 221 Average queries per session
- 47ms Average queries duration per session
- 4s725ms Average idle time per session
- 5,419 Total number of connections
- 5 connections/s at 2026-07-14 10:00:01 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 3,076 queries/s Query Peak
- 2026-07-14 13:34:41 Date
SELECT Traffic
Key values
- 990 queries/s Query Peak
- 2026-07-14 13:34:41 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 96 queries/s Query Peak
- 2026-07-14 17:00:00 Date
Queries duration
Key values
- 4m16s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 14 07 5,825 0ms 702ms 0ms 56ms 63ms 920ms 08 97,197 0ms 1s266ms 0ms 921ms 1s606ms 3s486ms 09 164,896 0ms 799ms 0ms 802ms 1s422ms 1s893ms 10 226,659 0ms 7s544ms 0ms 1s502ms 2s752ms 9s797ms 11 155,287 0ms 826ms 0ms 819ms 1s214ms 1s430ms 12 72,462 0ms 854ms 0ms 881ms 1s245ms 2s605ms 13 124,107 0ms 839ms 0ms 1s189ms 1s309ms 1s593ms 14 11,316 0ms 848ms 0ms 70ms 118ms 1s145ms 15 49,621 0ms 13s398ms 1ms 1s100ms 2s400ms 32s497ms 16 140,694 0ms 796ms 0ms 1s544ms 1s902ms 2s382ms 17 95,561 0ms 786ms 0ms 527ms 923ms 1s675ms 18 33,085 0ms 899ms 0ms 71ms 409ms 1s348ms 19 6,408 0ms 749ms 0ms 60ms 62ms 1s3ms 20 6,408 0ms 741ms 0ms 58ms 64ms 1s10ms 21 6,935 0ms 12s663ms 4ms 58ms 61ms 31s529ms 22 669 0ms 25ms 0ms 87ms 87ms 87ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 14 07 1,598 0 0ms 0ms 0ms 0ms 08 29,150 0 0ms 0ms 0ms 0ms 09 49,259 0 0ms 0ms 0ms 0ms 10 68,384 0 0ms 0ms 0ms 0ms 11 45,995 0 0ms 0ms 0ms 0ms 12 21,101 0 0ms 0ms 0ms 0ms 13 36,257 0 0ms 0ms 0ms 0ms 14 2,670 0 0ms 0ms 0ms 0ms 15 14,846 0 0ms 0ms 0ms 0ms 16 41,923 0 0ms 0ms 0ms 0ms 17 29,927 0 0ms 0ms 0ms 0ms 18 9,953 0 0ms 0ms 0ms 0ms 19 1,781 0 0ms 0ms 0ms 0ms 20 1,781 0 0ms 0ms 0ms 0ms 21 1,845 0 0ms 0ms 0ms 0ms 22 203 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 14 07 0 0 0 0 0ms 0ms 0ms 0ms 08 180 108 5 0 0ms 0ms 0ms 0ms 09 360 368 13 0 0ms 0ms 0ms 0ms 10 507 482 20 0 0ms 0ms 0ms 0ms 11 404 378 11 0 0ms 0ms 0ms 0ms 12 181 191 2 0 0ms 0ms 0ms 0ms 13 313 325 7 0 0ms 0ms 0ms 0ms 14 3 112 0 0 0ms 0ms 0ms 0ms 15 80 123 6 0 0ms 0ms 0ms 0ms 16 283 299 14 0 0ms 0ms 0ms 0ms 17 175 142 17 0 0ms 0ms 0ms 0ms 18 55 57 4 0 0ms 0ms 0ms 0ms 19 1 3 0 0 0ms 0ms 0ms 0ms 20 1 4 0 0 0ms 0ms 0ms 0ms 21 2 64 0 0 0ms 0ms 0ms 0ms 22 2 3 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 14 07 0 1,545 1,545.00 0.00% 08 0 30,649 30,649.00 0.00% 09 0 52,572 52,572.00 0.00% 10 0 72,946 72,946.00 0.00% 11 0 49,719 49,719.00 0.00% 12 0 23,030 23,030.00 0.00% 13 0 39,490 39,490.00 0.00% 14 0 3,293 3,293.00 0.00% 15 0 15,673 15,673.00 0.00% 16 0 44,693 44,693.00 0.00% 17 0 31,400 31,400.00 0.00% 18 0 10,436 10,436.00 0.00% 19 0 1,734 1,734.00 0.00% 20 0 1,735 1,735.00 0.00% 21 0 1,860 1,860.00 0.00% 22 0 215 215.00 0.00% Day Hour Count Average / Second Jul 14 07 361 0.10/s 08 364 0.10/s 09 361 0.10/s 10 362 0.10/s 11 361 0.10/s 12 361 0.10/s 13 361 0.10/s 14 361 0.10/s 15 361 0.10/s 16 361 0.10/s 17 361 0.10/s 18 361 0.10/s 19 361 0.10/s 20 361 0.10/s 21 361 0.10/s 22 0 0.00/s Day Hour Count Average Duration Average idle time Jul 14 07 361 21ms 13ms 08 361 21ms 0ms 09 361 22ms 0ms 10 362 1m11s 1m10s 11 361 22ms 0ms 12 361 22ms 0ms 13 361 22ms 0ms 14 361 22ms 13ms 15 361 22ms 0ms 16 361 21ms 0ms 17 361 22ms 0ms 18 361 22ms 10ms 19 361 22ms 14ms 20 361 22ms 14ms 21 361 21ms 0ms 22 0 0ms 0ms -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-14 10:00:01 Date
Connections per database
Key values
- etendo Main Database
- 5,419 connections Total
Connections per user
Key values
- tad Main User
- 5,419 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- 5,399 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 5,416 sessions Total
Sessions per user
Key values
- tad Main User
- 5,416 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 5,416 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,137 buffers Checkpoint Peak
- 2026-07-14 11:10:25 Date
- 213.679 seconds Highest write time
- 0.021 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-07-14 09:04:13 Date
Checkpoints distance
Key values
- 30.32 Mo Distance Peak
- 2026-07-14 10:05:10 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 14 07 985 98.389s 0.002s 98.396s 08 1,680 166.489s 0.024s 166.558s 09 2,622 259.99s 0.028s 260.068s 10 3,356 333.414s 0.029s 333.485s 11 4,529 450.572s 0.046s 450.66s 12 2,381 236.911s 0.026s 236.986s 13 2,278 225.633s 0.028s 225.706s 14 1,423 141.012s 0.024s 141.089s 15 1,638 162.536s 0.015s 162.6s 16 2,590 258.011s 0.043s 258.121s 17 2,314 228.998s 0.027s 229.07s 18 1,546 153.709s 0.017s 153.752s 19 1,257 125.166s 0.004s 125.175s 20 1,412 141.221s 0.003s 141.23s 21 1,473 147.314s 0.002s 147.321s 22 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 14 07 0 1 0 122 0.002s 0.001s 08 0 0 0 450 0.002s 0.011s 09 0 2 0 747 0.002s 0.012s 10 0 1 0 880 0.002s 0.012s 11 0 1 0 638 0.011s 0.012s 12 0 1 0 487 0.002s 0.012s 13 0 1 0 597 0.004s 0.012s 14 0 1 0 191 0.002s 0.012s 15 0 1 0 290 0.002s 0.009s 16 0 1 0 643 0.018s 0.012s 17 0 1 0 654 0.002s 0.012s 18 0 1 0 274 0.002s 0.007s 19 0 0 0 135 0.001s 0.002s 20 0 1 0 127 0.002s 0.001s 21 0 1 0 132 0.001s 0.001s 22 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 14 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s Day Hour Mean distance Mean estimate Jul 14 07 8,860.00 kB 1,049,511.00 kB 08 1,131.36 kB 589,920.64 kB 09 1,590.75 kB 178,457.42 kB 10 2,047.08 kB 51,921.92 kB 11 1,543.67 kB 15,802.00 kB 12 1,383.83 kB 8,428.75 kB 13 1,442.17 kB 6,900.00 kB 14 925.50 kB 6,407.08 kB 15 1,355.00 kB 7,309.22 kB 16 1,587.58 kB 6,566.25 kB 17 1,392.42 kB 6,988.92 kB 18 1,723.71 kB 8,368.57 kB 19 5,259.50 kB 9,969.50 kB 20 10,008.00 kB 10,008.00 kB 21 10,451.00 kB 10,451.00 kB 22 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 91.99 MiB Temp Files size Peak
- 2026-07-14 15:30:03 Date
Number of temporary files
Key values
- 3 per second Temp Files Peak
- 2026-07-14 15:30:03 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 14 07 0 0 0 08 1 13.49 MiB 13.49 MiB 09 1 13.49 MiB 13.49 MiB 10 0 0 0 11 0 0 0 12 0 0 0 13 4 13.31 MiB 3.33 MiB 14 0 0 0 15 8 193.90 MiB 24.24 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 7 180.41 MiB 25.77 MiB 22 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 4 355.46 MiB 86.99 MiB 90.74 MiB 88.87 MiB ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, c_invoice.ad_org_id as ad_org_id, c_invoice.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) 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 (...) 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) a where ? = ? and a.referencekey_id = ad_alert.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) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-14 15:30:03 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
2 4 3.94 MiB 728.00 KiB 1.26 MiB 1008.00 KiB ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id, ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, record_id, ?) as record_id from fact_acct where ad_table_id = ? and docbasetype in (...) group by fact_acct_group_id, record_id, ad_client_id, ad_org_id having sum(amtacctcr - amtacctdr) <> ?) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);-
'0' as ad_role_id, null as ad_user_id, 'NOT BALANCED SALES INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('ARI', 'ARC', 'ARF') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-14 15:30:03 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
3 4 13.31 MiB 3.29 MiB 3.38 MiB 3.33 MiB select coalesce(sum(s.amtacctdr), ?) as amtacctdr, coalesce(sum(s.amtacctcr), ?) as amtacctcr from ( select * from ( select ? as rn1, c.* from ( select value, name, dateacct, coalesce(sum(amtacctdr), ?) as amtacctdr, coalesce(sum(amtacctcr), ?) as amtacctcr, coalesce(sum(amtacctdr - amtacctcr), ?) as total, max(fact_acct_id) as fact_acct_id, fact_acct_group_id, id, groupbyid, groupbyname, description, isdebit, ? as totalacctdr, ? as totalacctcr, ? as totalacctsub, ? as previousdebit, ? as previouscredit, ? as previoustotal, ? as finaldebit, ? as finalcredit, ? as finaltotal, to_char(dateacct, ?) as dateacctnumber, ? as groupby, ? as bpid, ? as bpname, ? as pdid, ? as pdname, ? as pjid, ? as pjname, factaccttype, ? as amtacctdrprevsum, ? as amtacctcrprevsum from ( select fact_acct.acctvalue as value, fact_acct.acctdescription as name, dateacct, amtacctdr, amtacctcr, fact_acct_id, fact_acct_group_id, fact_acct.account_id as id, fact_acct.description, case ? when ? then c_bpartner.c_bpartner_id when ? then m_product.m_product_id when ? then c_project.c_project_id else ? end as groupbyid, case ? when ? then ( select to_char(name) from c_bpartner b where b.c_bpartner_id = c_bpartner.c_bpartner_id) when ? then ( select to_char(value || ? || name) from m_product p where p.m_product_id = m_product.m_product_id) when ? then ( select to_char(name) from c_project pj where pj.c_project_id = c_project.c_project_id) else ? end as groupbyname, case when (amtacctdr > ? and amtacctcr = ?) or (amtacctcr < ? and amtacctdr = ?) then ? else ? end as isdebit, case when fact_acct.factaccttype = ? then ? else ( case when fact_acct.factaccttype = ? then ? else ( case when fact_acct.factaccttype = ? then ? else ( case when fact_acct.factaccttype = ? then ? end) end) end) end as factaccttype from fact_acct left join c_bpartner on fact_acct.c_bpartner_id = c_bpartner.c_bpartner_id left join m_product on fact_acct.m_product_id = m_product.m_product_id left join c_project on fact_acct.c_project_id = c_project.c_project_id where (? = ? or fact_acct.account_id in ( select c_elementvalue_id as name from c_elementvalue where value >= ( select value from c_elementvalue where c_elementvalue_id = ?) and value <= ( select value from c_elementvalue where c_elementvalue_id = ?) and c_elementvalue.elementlevel = ?)) and fact_acct.ad_org_id in (...) and fact_acct.ad_client_id in (...) and ? = ? and fact_acct.c_acctschema_id = ? and fact_acct.dateacct >= to_date(?) and fact_acct.dateacct < to_date(?) and fact_acct.ad_org_id in (...) and ? = ? and ? = ?) d where ? = ? group by groupbyname, groupbyid, value, name, id, dateacct, factaccttype, fact_acct_group_id, description, isdebit having sum(amtacctdr) - sum(amtacctcr) <> ? order by groupbyname, groupbyid, value, name, id, dateacct, factaccttype, fact_acct_group_id, fact_acct_id, description, isdebit) c) b where ? = ? and to_char(dateacct, ?) || factaccttype || fact_acct_group_id || fact_acct_id < ?) s where s.id = ?;-
SELECT Coalesce(SUM(S.amtacctdr), 0) AS AMTACCTDR, Coalesce(SUM(S.amtacctcr), 0) AS AMTACCTCR FROM ( SELECT * FROM ( SELECT 0 AS RN1, C.* FROM ( SELECT VALUE, NAME, DATEACCT, COALESCE(SUM(AMTACCTDR), 0) AS AMTACCTDR, COALESCE(SUM(AMTACCTCR), 0) AS AMTACCTCR, COALESCE(SUM(AMTACCTDR - AMTACCTCR), 0) AS TOTAL, MAX(FACT_ACCT_ID) AS FACT_ACCT_ID, FACT_ACCT_GROUP_ID, ID, groupbyid, groupbyname, DESCRIPTION, ISDEBIT, 0 AS TOTALACCTDR, 0 AS TOTALACCTCR, 0 AS TOTALACCTSUB, 0 AS PREVIOUSDEBIT, 0 AS PREVIOUSCREDIT, 0 AS PREVIOUSTOTAL, 0 AS FINALDEBIT, 0 AS FINALCREDIT, 0 AS FINALTOTAL, TO_CHAR(DATEACCT, 'J') AS DATEACCTNUMBER, $1 AS groupby, '' as bpid, '' as bpname, '' as pdid, '' as pdname, '' as pjid, '' as pjname, factaccttype, 0 AS AMTACCTDRPREVSUM, 0 AS AMTACCTCRPREVSUM FROM ( SELECT FACT_ACCT.ACCTVALUE AS VALUE, FACT_ACCT.ACCTDESCRIPTION AS NAME, DATEACCT, AMTACCTDR, AMTACCTCR, FACT_ACCT_ID, FACT_ACCT_GROUP_ID, FACT_ACCT.ACCOUNT_ID AS ID, FACT_ACCT.DESCRIPTION, CASE $2 WHEN 'BPartner' THEN c_bpartner.c_bpartner_id WHEN 'Product' THEN m_product.m_product_id WHEN 'Project' THEN c_project.c_project_id ELSE '' END AS groupbyid, CASE $3 WHEN 'BPartner' THEN ( select to_char(name) from c_bpartner b where b.c_bpartner_id = c_bpartner.c_bpartner_id) WHEN 'Product' THEN ( select to_char(value || ' - ' || name) from m_product p where p.m_product_id = m_product.m_product_id) WHEN 'Project' THEN ( select to_char(name) from c_project pj where pj.c_project_id = c_project.c_project_id) ELSE '' END AS groupbyname, CASE WHEN (AMTACCTDR > 0 AND AMTACCTCR = 0) OR (AMTACCTCR < 0 AND AMTACCTDR = 0) THEN 'Y' ELSE 'N' END AS ISDEBIT, CASE WHEN FACT_ACCT.FACTACCTTYPE = 'O' THEN 1 ELSE ( CASE WHEN FACT_ACCT.FACTACCTTYPE = 'N' THEN 2 ELSE ( CASE WHEN FACT_ACCT.FACTACCTTYPE = 'R' THEN 3 ELSE ( CASE WHEN FACT_ACCT.FACTACCTTYPE = 'C' THEN 4 END) END) END) END AS FACTACCTTYPE FROM FACT_ACCT LEFT JOIN C_BPARTNER ON FACT_ACCT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID LEFT JOIN M_PRODUCT ON FACT_ACCT.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID LEFT JOIN C_PROJECT ON FACT_ACCT.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID WHERE ($4 = 'Y' OR FACT_ACCT.ACCOUNT_ID IN ( SELECT c_elementvalue_id as name FROM C_ELEMENTVALUE WHERE value >= ( select value from c_elementvalue where c_elementvalue_id = $5) and value <= ( select value from c_elementvalue where c_elementvalue_id = $6) and c_elementvalue.ELEMENTLEVEL = 'S')) AND FACT_ACCT.AD_ORG_ID IN ('0', '0068C08A9E6E4F5DABD3DE8DF501F3AE', 'AE22A8F271B7478C9A7D2FD8E6A06E0B', '825BF275D875406288FE248FC7D41136', '753D13C4479A4E14A0CA845AE121A5EB') AND FACT_ACCT.AD_CLIENT_ID IN ('0', '44FE6AC078E14A6CA5A1189E01E67FB5') AND 1 = 1 AND FACT_ACCT.C_ACCTSCHEMA_ID = $7 AND FACT_ACCT.DATEACCT >= TO_DATE($8) AND FACT_ACCT.DATEACCT < TO_DATE($9) AND FACT_ACCT.AD_ORG_ID IN ('AE22A8F271B7478C9A7D2FD8E6A06E0B', '825BF275D875406288FE248FC7D41136', '753D13C4479A4E14A0CA845AE121A5EB', '0068C08A9E6E4F5DABD3DE8DF501F3AE') AND 2 = 2 AND 3 = 3) D WHERE 6 = 6 GROUP BY groupbyname, groupbyid, VALUE, NAME, ID, DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, DESCRIPTION, ISDEBIT HAVING SUM(AMTACCTDR) - SUM(AMTACCTCR) <> 0 ORDER BY groupbyname, groupbyid, VALUE, NAME, ID, DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, FACT_ACCT_ID, DESCRIPTION, ISDEBIT) C) B WHERE 1 = 1 and to_char(DATEACCT, 'J') || FACTACCTTYPE || FACT_ACCT_GROUP_ID || FACT_ACCT_ID < $10) S WHERE S.id = $11;
Date: 2026-07-14 13:18:38 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
4 3 40.48 MiB 13.49 MiB 13.49 MiB 13.49 MiB select sum(order0_.totallines) as col_0_0_, sum( cost) as col_1_0_, sum(margen) as col_2_0_, sum(pmargen) / count(*) as col_3_0_ from c_order order0_ left outer join c_invoice invoicelis1_ on order0_.c_order_id = invoicelis1_.c_order_id cross join c_orderline orderline2_ where orderline2_.c_order_id = order0_.c_order_id and order0_.issotrx = ? and order0_.docstatus = ? and ? = ? limit ?;-
select sum(order0_.TotalLines) as col_0_0_, sum( Cost) as col_1_0_, sum(Margen) as col_2_0_, sum(PMargen) / count(*) as col_3_0_ from C_Order order0_ left outer join C_Invoice invoicelis1_ on order0_.C_Order_ID = invoicelis1_.C_Order_ID cross join C_OrderLine orderline2_ where orderline2_.C_Order_ID = order0_.C_Order_ID and order0_.IsSOTrx = 'Y' and order0_.DocStatus = 'CO' and 1 = 1 limit $1;
Date: 2026-07-14 08:56:00 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
5 2 1.42 MiB 728.00 KiB 728.00 KiB 728.00 KiB update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select record_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id, ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, record_id, ?) as record_id from fact_acct where ad_table_id = ? and docbasetype in (...) group by fact_acct_group_id, record_id, ad_client_id, ad_org_id having sum(amtacctcr - amtacctdr) <> ?) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select record_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED PURCHASE INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('API', 'APC') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-14 15:30:29 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
Queries generating the largest temporary files
Rank Size Query 1 90.74 MiB '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) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-14 21:00:02 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2 90.73 MiB '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) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-14 15:30:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3 86.99 MiB '0' as ad_role_id, null as ad_user_id, 'PURCHASE 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 ('API', 'APC') 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) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-14 15:30:31 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4 86.99 MiB '0' as ad_role_id, null as ad_user_id, 'PURCHASE 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 ('API', 'APC') 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) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-14 21:00:30 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5 13.49 MiB select sum(order0_.TotalLines) as col_0_0_, sum( Cost) as col_1_0_, sum(Margen) as col_2_0_, sum(PMargen) / count(*) as col_3_0_ from C_Order order0_ left outer join C_Invoice invoicelis1_ on order0_.C_Order_ID = invoicelis1_.C_Order_ID cross join C_OrderLine orderline2_ where orderline2_.C_Order_ID = order0_.C_Order_ID and order0_.IsSOTrx = 'Y' and order0_.DocStatus = 'CO' and 1 = 1 limit $1;[ Date: 2026-07-14 08:56:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
6 13.49 MiB select sum(order0_.TotalLines) as col_0_0_, sum( Cost) as col_1_0_, sum(Margen) as col_2_0_, sum(PMargen) / count(*) as col_3_0_ from C_Order order0_ left outer join C_Invoice invoicelis1_ on order0_.C_Order_ID = invoicelis1_.C_Order_ID cross join C_OrderLine orderline2_ where orderline2_.C_Order_ID = order0_.C_Order_ID and order0_.IsSOTrx = 'Y' and order0_.DocStatus = 'CO' and 1 = 1 limit $1;[ Date: 2026-07-14 09:32:54 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
7 13.49 MiB select sum(order0_.TotalLines) as col_0_0_, sum( Cost) as col_1_0_, sum(Margen) as col_2_0_, sum(PMargen) / count(*) as col_3_0_ from C_Order order0_ left outer join C_Invoice invoicelis1_ on order0_.C_Order_ID = invoicelis1_.C_Order_ID cross join C_OrderLine orderline2_ where orderline2_.C_Order_ID = order0_.C_Order_ID and order0_.IsSOTrx = 'Y' and order0_.DocStatus = 'CO' and 1 = 1 limit $1;[ Date: 2026-07-14 15:46:25 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8 3.38 MiB SELECT Coalesce(SUM(S.amtacctdr), 0) AS AMTACCTDR, Coalesce(SUM(S.amtacctcr), 0) AS AMTACCTCR FROM ( SELECT * FROM ( SELECT 0 AS RN1, C.* FROM ( SELECT VALUE, NAME, DATEACCT, COALESCE(SUM(AMTACCTDR), 0) AS AMTACCTDR, COALESCE(SUM(AMTACCTCR), 0) AS AMTACCTCR, COALESCE(SUM(AMTACCTDR - AMTACCTCR), 0) AS TOTAL, MAX(FACT_ACCT_ID) AS FACT_ACCT_ID, FACT_ACCT_GROUP_ID, ID, groupbyid, groupbyname, DESCRIPTION, ISDEBIT, 0 AS TOTALACCTDR, 0 AS TOTALACCTCR, 0 AS TOTALACCTSUB, 0 AS PREVIOUSDEBIT, 0 AS PREVIOUSCREDIT, 0 AS PREVIOUSTOTAL, 0 AS FINALDEBIT, 0 AS FINALCREDIT, 0 AS FINALTOTAL, TO_CHAR(DATEACCT, 'J') AS DATEACCTNUMBER, $1 AS groupby, '' as bpid, '' as bpname, '' as pdid, '' as pdname, '' as pjid, '' as pjname, factaccttype, 0 AS AMTACCTDRPREVSUM, 0 AS AMTACCTCRPREVSUM FROM ( SELECT FACT_ACCT.ACCTVALUE AS VALUE, FACT_ACCT.ACCTDESCRIPTION AS NAME, DATEACCT, AMTACCTDR, AMTACCTCR, FACT_ACCT_ID, FACT_ACCT_GROUP_ID, FACT_ACCT.ACCOUNT_ID AS ID, FACT_ACCT.DESCRIPTION, CASE $2 WHEN 'BPartner' THEN c_bpartner.c_bpartner_id WHEN 'Product' THEN m_product.m_product_id WHEN 'Project' THEN c_project.c_project_id ELSE '' END AS groupbyid, CASE $3 WHEN 'BPartner' THEN ( select to_char(name) from c_bpartner b where b.c_bpartner_id = c_bpartner.c_bpartner_id) WHEN 'Product' THEN ( select to_char(value || ' - ' || name) from m_product p where p.m_product_id = m_product.m_product_id) WHEN 'Project' THEN ( select to_char(name) from c_project pj where pj.c_project_id = c_project.c_project_id) ELSE '' END AS groupbyname, CASE WHEN (AMTACCTDR > 0 AND AMTACCTCR = 0) OR (AMTACCTCR < 0 AND AMTACCTDR = 0) THEN 'Y' ELSE 'N' END AS ISDEBIT, CASE WHEN FACT_ACCT.FACTACCTTYPE = 'O' THEN 1 ELSE ( CASE WHEN FACT_ACCT.FACTACCTTYPE = 'N' THEN 2 ELSE ( CASE WHEN FACT_ACCT.FACTACCTTYPE = 'R' THEN 3 ELSE ( CASE WHEN FACT_ACCT.FACTACCTTYPE = 'C' THEN 4 END) END) END) END AS FACTACCTTYPE FROM FACT_ACCT LEFT JOIN C_BPARTNER ON FACT_ACCT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID LEFT JOIN M_PRODUCT ON FACT_ACCT.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID LEFT JOIN C_PROJECT ON FACT_ACCT.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID WHERE ($4 = 'Y' OR FACT_ACCT.ACCOUNT_ID IN ( SELECT c_elementvalue_id as name FROM C_ELEMENTVALUE WHERE value >= ( select value from c_elementvalue where c_elementvalue_id = $5) and value <= ( select value from c_elementvalue where c_elementvalue_id = $6) and c_elementvalue.ELEMENTLEVEL = 'S')) AND FACT_ACCT.AD_ORG_ID IN ('0', '0068C08A9E6E4F5DABD3DE8DF501F3AE', 'AE22A8F271B7478C9A7D2FD8E6A06E0B', '825BF275D875406288FE248FC7D41136', '753D13C4479A4E14A0CA845AE121A5EB') AND FACT_ACCT.AD_CLIENT_ID IN ('0', '44FE6AC078E14A6CA5A1189E01E67FB5') AND 1 = 1 AND FACT_ACCT.C_ACCTSCHEMA_ID = $7 AND FACT_ACCT.DATEACCT >= TO_DATE($8) AND FACT_ACCT.DATEACCT < TO_DATE($9) AND FACT_ACCT.AD_ORG_ID IN ('AE22A8F271B7478C9A7D2FD8E6A06E0B', '825BF275D875406288FE248FC7D41136', '753D13C4479A4E14A0CA845AE121A5EB', '0068C08A9E6E4F5DABD3DE8DF501F3AE') AND 2 = 2 AND 3 = 3) D WHERE 6 = 6 GROUP BY groupbyname, groupbyid, VALUE, NAME, ID, DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, DESCRIPTION, ISDEBIT HAVING SUM(AMTACCTDR) - SUM(AMTACCTCR) <> 0 ORDER BY groupbyname, groupbyid, VALUE, NAME, ID, DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, FACT_ACCT_ID, DESCRIPTION, ISDEBIT) C) B WHERE 1 = 1 and to_char(DATEACCT, 'J') || FACTACCTTYPE || FACT_ACCT_GROUP_ID || FACT_ACCT_ID < $10) S WHERE S.id = $11;[ Date: 2026-07-14 13:18:38 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
9 3.32 MiB SELECT Coalesce(SUM(S.amtacctdr), 0) AS AMTACCTDR, Coalesce(SUM(S.amtacctcr), 0) AS AMTACCTCR FROM ( SELECT * FROM ( SELECT 0 AS RN1, C.* FROM ( SELECT VALUE, NAME, DATEACCT, COALESCE(SUM(AMTACCTDR), 0) AS AMTACCTDR, COALESCE(SUM(AMTACCTCR), 0) AS AMTACCTCR, COALESCE(SUM(AMTACCTDR - AMTACCTCR), 0) AS TOTAL, MAX(FACT_ACCT_ID) AS FACT_ACCT_ID, FACT_ACCT_GROUP_ID, ID, groupbyid, groupbyname, DESCRIPTION, ISDEBIT, 0 AS TOTALACCTDR, 0 AS TOTALACCTCR, 0 AS TOTALACCTSUB, 0 AS PREVIOUSDEBIT, 0 AS PREVIOUSCREDIT, 0 AS PREVIOUSTOTAL, 0 AS FINALDEBIT, 0 AS FINALCREDIT, 0 AS FINALTOTAL, TO_CHAR(DATEACCT, 'J') AS DATEACCTNUMBER, $1 AS groupby, '' as bpid, '' as bpname, '' as pdid, '' as pdname, '' as pjid, '' as pjname, factaccttype, 0 AS AMTACCTDRPREVSUM, 0 AS AMTACCTCRPREVSUM FROM ( SELECT FACT_ACCT.ACCTVALUE AS VALUE, FACT_ACCT.ACCTDESCRIPTION AS NAME, DATEACCT, AMTACCTDR, AMTACCTCR, FACT_ACCT_ID, FACT_ACCT_GROUP_ID, FACT_ACCT.ACCOUNT_ID AS ID, FACT_ACCT.DESCRIPTION, CASE $2 WHEN 'BPartner' THEN c_bpartner.c_bpartner_id WHEN 'Product' THEN m_product.m_product_id WHEN 'Project' THEN c_project.c_project_id ELSE '' END AS groupbyid, CASE $3 WHEN 'BPartner' THEN ( select to_char(name) from c_bpartner b where b.c_bpartner_id = c_bpartner.c_bpartner_id) WHEN 'Product' THEN ( select to_char(value || ' - ' || name) from m_product p where p.m_product_id = m_product.m_product_id) WHEN 'Project' THEN ( select to_char(name) from c_project pj where pj.c_project_id = c_project.c_project_id) ELSE '' END AS groupbyname, CASE WHEN (AMTACCTDR > 0 AND AMTACCTCR = 0) OR (AMTACCTCR < 0 AND AMTACCTDR = 0) THEN 'Y' ELSE 'N' END AS ISDEBIT, CASE WHEN FACT_ACCT.FACTACCTTYPE = 'O' THEN 1 ELSE ( CASE WHEN FACT_ACCT.FACTACCTTYPE = 'N' THEN 2 ELSE ( CASE WHEN FACT_ACCT.FACTACCTTYPE = 'R' THEN 3 ELSE ( CASE WHEN FACT_ACCT.FACTACCTTYPE = 'C' THEN 4 END) END) END) END AS FACTACCTTYPE FROM FACT_ACCT LEFT JOIN C_BPARTNER ON FACT_ACCT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID LEFT JOIN M_PRODUCT ON FACT_ACCT.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID LEFT JOIN C_PROJECT ON FACT_ACCT.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID WHERE ($4 = 'Y' OR FACT_ACCT.ACCOUNT_ID IN ( SELECT c_elementvalue_id as name FROM C_ELEMENTVALUE WHERE value >= ( select value from c_elementvalue where c_elementvalue_id = $5) and value <= ( select value from c_elementvalue where c_elementvalue_id = $6) and c_elementvalue.ELEMENTLEVEL = 'S')) AND FACT_ACCT.AD_ORG_ID IN ('0', '0068C08A9E6E4F5DABD3DE8DF501F3AE', 'AE22A8F271B7478C9A7D2FD8E6A06E0B', '825BF275D875406288FE248FC7D41136', '753D13C4479A4E14A0CA845AE121A5EB') AND FACT_ACCT.AD_CLIENT_ID IN ('0', '44FE6AC078E14A6CA5A1189E01E67FB5') AND 1 = 1 AND FACT_ACCT.C_ACCTSCHEMA_ID = $7 AND FACT_ACCT.DATEACCT >= TO_DATE($8) AND FACT_ACCT.DATEACCT < TO_DATE($9) AND FACT_ACCT.AD_ORG_ID IN ('AE22A8F271B7478C9A7D2FD8E6A06E0B', '825BF275D875406288FE248FC7D41136', '753D13C4479A4E14A0CA845AE121A5EB', '0068C08A9E6E4F5DABD3DE8DF501F3AE') AND 2 = 2 AND 3 = 3) D WHERE 6 = 6 GROUP BY groupbyname, groupbyid, VALUE, NAME, ID, DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, DESCRIPTION, ISDEBIT HAVING SUM(AMTACCTDR) - SUM(AMTACCTCR) <> 0 ORDER BY groupbyname, groupbyid, VALUE, NAME, ID, DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, FACT_ACCT_ID, DESCRIPTION, ISDEBIT) C) B WHERE 1 = 1 and to_char(DATEACCT, 'J') || FACTACCTTYPE || FACT_ACCT_GROUP_ID || FACT_ACCT_ID < $10) S WHERE S.id = $11;[ Date: 2026-07-14 13:19:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
10 3.32 MiB SELECT Coalesce(SUM(S.amtacctdr), 0) AS AMTACCTDR, Coalesce(SUM(S.amtacctcr), 0) AS AMTACCTCR FROM ( SELECT * FROM ( SELECT 0 AS RN1, C.* FROM ( SELECT VALUE, NAME, DATEACCT, COALESCE(SUM(AMTACCTDR), 0) AS AMTACCTDR, COALESCE(SUM(AMTACCTCR), 0) AS AMTACCTCR, COALESCE(SUM(AMTACCTDR - AMTACCTCR), 0) AS TOTAL, MAX(FACT_ACCT_ID) AS FACT_ACCT_ID, FACT_ACCT_GROUP_ID, ID, groupbyid, groupbyname, DESCRIPTION, ISDEBIT, 0 AS TOTALACCTDR, 0 AS TOTALACCTCR, 0 AS TOTALACCTSUB, 0 AS PREVIOUSDEBIT, 0 AS PREVIOUSCREDIT, 0 AS PREVIOUSTOTAL, 0 AS FINALDEBIT, 0 AS FINALCREDIT, 0 AS FINALTOTAL, TO_CHAR(DATEACCT, 'J') AS DATEACCTNUMBER, $1 AS groupby, '' as bpid, '' as bpname, '' as pdid, '' as pdname, '' as pjid, '' as pjname, factaccttype, 0 AS AMTACCTDRPREVSUM, 0 AS AMTACCTCRPREVSUM FROM ( SELECT FACT_ACCT.ACCTVALUE AS VALUE, FACT_ACCT.ACCTDESCRIPTION AS NAME, DATEACCT, AMTACCTDR, AMTACCTCR, FACT_ACCT_ID, FACT_ACCT_GROUP_ID, FACT_ACCT.ACCOUNT_ID AS ID, FACT_ACCT.DESCRIPTION, CASE $2 WHEN 'BPartner' THEN c_bpartner.c_bpartner_id WHEN 'Product' THEN m_product.m_product_id WHEN 'Project' THEN c_project.c_project_id ELSE '' END AS groupbyid, CASE $3 WHEN 'BPartner' THEN ( select to_char(name) from c_bpartner b where b.c_bpartner_id = c_bpartner.c_bpartner_id) WHEN 'Product' THEN ( select to_char(value || ' - ' || name) from m_product p where p.m_product_id = m_product.m_product_id) WHEN 'Project' THEN ( select to_char(name) from c_project pj where pj.c_project_id = c_project.c_project_id) ELSE '' END AS groupbyname, CASE WHEN (AMTACCTDR > 0 AND AMTACCTCR = 0) OR (AMTACCTCR < 0 AND AMTACCTDR = 0) THEN 'Y' ELSE 'N' END AS ISDEBIT, CASE WHEN FACT_ACCT.FACTACCTTYPE = 'O' THEN 1 ELSE ( CASE WHEN FACT_ACCT.FACTACCTTYPE = 'N' THEN 2 ELSE ( CASE WHEN FACT_ACCT.FACTACCTTYPE = 'R' THEN 3 ELSE ( CASE WHEN FACT_ACCT.FACTACCTTYPE = 'C' THEN 4 END) END) END) END AS FACTACCTTYPE FROM FACT_ACCT LEFT JOIN C_BPARTNER ON FACT_ACCT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID LEFT JOIN M_PRODUCT ON FACT_ACCT.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID LEFT JOIN C_PROJECT ON FACT_ACCT.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID WHERE ($4 = 'Y' OR FACT_ACCT.ACCOUNT_ID IN ( SELECT c_elementvalue_id as name FROM C_ELEMENTVALUE WHERE value >= ( select value from c_elementvalue where c_elementvalue_id = $5) and value <= ( select value from c_elementvalue where c_elementvalue_id = $6) and c_elementvalue.ELEMENTLEVEL = 'S')) AND FACT_ACCT.AD_ORG_ID IN ('0', '0068C08A9E6E4F5DABD3DE8DF501F3AE', 'AE22A8F271B7478C9A7D2FD8E6A06E0B', '825BF275D875406288FE248FC7D41136', '753D13C4479A4E14A0CA845AE121A5EB') AND FACT_ACCT.AD_CLIENT_ID IN ('0', '44FE6AC078E14A6CA5A1189E01E67FB5') AND 1 = 1 AND FACT_ACCT.C_ACCTSCHEMA_ID = $7 AND FACT_ACCT.DATEACCT >= TO_DATE($8) AND FACT_ACCT.DATEACCT < TO_DATE($9) AND FACT_ACCT.AD_ORG_ID IN ('AE22A8F271B7478C9A7D2FD8E6A06E0B', '825BF275D875406288FE248FC7D41136', '753D13C4479A4E14A0CA845AE121A5EB', '0068C08A9E6E4F5DABD3DE8DF501F3AE') AND 2 = 2 AND 3 = 3) D WHERE 6 = 6 GROUP BY groupbyname, groupbyid, VALUE, NAME, ID, DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, DESCRIPTION, ISDEBIT HAVING SUM(AMTACCTDR) - SUM(AMTACCTCR) <> 0 ORDER BY groupbyname, groupbyid, VALUE, NAME, ID, DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, FACT_ACCT_ID, DESCRIPTION, ISDEBIT) C) B WHERE 1 = 1 and to_char(DATEACCT, 'J') || FACTACCTTYPE || FACT_ACCT_GROUP_ID || FACT_ACCT_ID < $10) S WHERE S.id = $11;[ Date: 2026-07-14 13:20:46 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
11 3.29 MiB SELECT Coalesce(SUM(S.amtacctdr), 0) AS AMTACCTDR, Coalesce(SUM(S.amtacctcr), 0) AS AMTACCTCR FROM ( SELECT * FROM ( SELECT 0 AS RN1, C.* FROM ( SELECT VALUE, NAME, DATEACCT, COALESCE(SUM(AMTACCTDR), 0) AS AMTACCTDR, COALESCE(SUM(AMTACCTCR), 0) AS AMTACCTCR, COALESCE(SUM(AMTACCTDR - AMTACCTCR), 0) AS TOTAL, MAX(FACT_ACCT_ID) AS FACT_ACCT_ID, FACT_ACCT_GROUP_ID, ID, groupbyid, groupbyname, DESCRIPTION, ISDEBIT, 0 AS TOTALACCTDR, 0 AS TOTALACCTCR, 0 AS TOTALACCTSUB, 0 AS PREVIOUSDEBIT, 0 AS PREVIOUSCREDIT, 0 AS PREVIOUSTOTAL, 0 AS FINALDEBIT, 0 AS FINALCREDIT, 0 AS FINALTOTAL, TO_CHAR(DATEACCT, 'J') AS DATEACCTNUMBER, $1 AS groupby, '' as bpid, '' as bpname, '' as pdid, '' as pdname, '' as pjid, '' as pjname, factaccttype, 0 AS AMTACCTDRPREVSUM, 0 AS AMTACCTCRPREVSUM FROM ( SELECT FACT_ACCT.ACCTVALUE AS VALUE, FACT_ACCT.ACCTDESCRIPTION AS NAME, DATEACCT, AMTACCTDR, AMTACCTCR, FACT_ACCT_ID, FACT_ACCT_GROUP_ID, FACT_ACCT.ACCOUNT_ID AS ID, FACT_ACCT.DESCRIPTION, CASE $2 WHEN 'BPartner' THEN c_bpartner.c_bpartner_id WHEN 'Product' THEN m_product.m_product_id WHEN 'Project' THEN c_project.c_project_id ELSE '' END AS groupbyid, CASE $3 WHEN 'BPartner' THEN ( select to_char(name) from c_bpartner b where b.c_bpartner_id = c_bpartner.c_bpartner_id) WHEN 'Product' THEN ( select to_char(value || ' - ' || name) from m_product p where p.m_product_id = m_product.m_product_id) WHEN 'Project' THEN ( select to_char(name) from c_project pj where pj.c_project_id = c_project.c_project_id) ELSE '' END AS groupbyname, CASE WHEN (AMTACCTDR > 0 AND AMTACCTCR = 0) OR (AMTACCTCR < 0 AND AMTACCTDR = 0) THEN 'Y' ELSE 'N' END AS ISDEBIT, CASE WHEN FACT_ACCT.FACTACCTTYPE = 'O' THEN 1 ELSE ( CASE WHEN FACT_ACCT.FACTACCTTYPE = 'N' THEN 2 ELSE ( CASE WHEN FACT_ACCT.FACTACCTTYPE = 'R' THEN 3 ELSE ( CASE WHEN FACT_ACCT.FACTACCTTYPE = 'C' THEN 4 END) END) END) END AS FACTACCTTYPE FROM FACT_ACCT LEFT JOIN C_BPARTNER ON FACT_ACCT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID LEFT JOIN M_PRODUCT ON FACT_ACCT.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID LEFT JOIN C_PROJECT ON FACT_ACCT.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID WHERE ($4 = 'Y' OR FACT_ACCT.ACCOUNT_ID IN ( SELECT c_elementvalue_id as name FROM C_ELEMENTVALUE WHERE value >= ( select value from c_elementvalue where c_elementvalue_id = $5) and value <= ( select value from c_elementvalue where c_elementvalue_id = $6) and c_elementvalue.ELEMENTLEVEL = 'S')) AND FACT_ACCT.AD_ORG_ID IN ('0', '0068C08A9E6E4F5DABD3DE8DF501F3AE', 'AE22A8F271B7478C9A7D2FD8E6A06E0B', '825BF275D875406288FE248FC7D41136', '753D13C4479A4E14A0CA845AE121A5EB') AND FACT_ACCT.AD_CLIENT_ID IN ('0', '44FE6AC078E14A6CA5A1189E01E67FB5') AND 1 = 1 AND FACT_ACCT.C_ACCTSCHEMA_ID = $7 AND FACT_ACCT.DATEACCT >= TO_DATE($8) AND FACT_ACCT.DATEACCT < TO_DATE($9) AND FACT_ACCT.AD_ORG_ID IN ('AE22A8F271B7478C9A7D2FD8E6A06E0B', '825BF275D875406288FE248FC7D41136', '753D13C4479A4E14A0CA845AE121A5EB', '0068C08A9E6E4F5DABD3DE8DF501F3AE') AND 2 = 2 AND 3 = 3) D WHERE 6 = 6 GROUP BY groupbyname, groupbyid, VALUE, NAME, ID, DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, DESCRIPTION, ISDEBIT HAVING SUM(AMTACCTDR) - SUM(AMTACCTCR) <> 0 ORDER BY groupbyname, groupbyid, VALUE, NAME, ID, DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, FACT_ACCT_ID, DESCRIPTION, ISDEBIT) C) B WHERE 1 = 1 and to_char(DATEACCT, 'J') || FACTACCTTYPE || FACT_ACCT_GROUP_ID || FACT_ACCT_ID < $10) S WHERE S.id = $11;[ Date: 2026-07-14 13:21:22 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
12 1.26 MiB '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED SALES INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('ARI', 'ARC', 'ARF') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-14 15:30:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
13 1.26 MiB '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED SALES INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('ARI', 'ARC', 'ARF') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-14 21:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
14 728.00 KiB '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED PURCHASE INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('API', 'APC') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-14 15:30:16 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
15 728.00 KiB UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select record_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED PURCHASE INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('API', 'APC') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-14 15:30:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
16 728.00 KiB '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED PURCHASE INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('API', 'APC') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-14 21:00:15 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
17 728.00 KiB UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select record_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED PURCHASE INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('API', 'APC') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-14 21:00:28 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.50 sec Highest CPU-cost vacuum
Table public.ad_session_usage_audit
Database etendo - 2026-07-14 11:05:21 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 0.50 sec Highest CPU-cost vacuum
Table public.ad_session_usage_audit
Database etendo - 2026-07-14 11:05:21 Date
Analyzes per table
Key values
- public.ad_session (15) Main table analyzed (database etendo)
- 152 analyzes Total
Table Number of analyzes etendo.public.ad_session 15 etendo.profile.last_stat_indexes_srv1 15 etendo.profile.last_stat_statements_srv1 15 etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.last_stat_tables_srv1 15 etendo.public.ad_ep_instance_para 12 etendo.profile.tables_list 10 etendo.profile.last_stat_io 8 etendo.profile.funcs_list 6 etendo.profile.stmt_list 6 etendo.profile.indexes_list 5 etendo.profile.last_extension_versions 4 etendo.profile.last_stat_activity_count_srv1 4 etendo.public.ad_preference 3 etendo.profile.last_stat_slru 3 etendo.profile.sample_stat_indexes 2 etendo.profile.sample_stat_user_functions 2 etendo.profile.sample_statements 2 etendo.profile.sample_stat_tables 2 etendo.profile.sample_statements_total 1 etendo.public.ad_process_request 1 etendo.public.ad_pinstance 1 etendo.profile.sample_stat_database 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.sample_stat_tables_total 1 etendo.profile.sample_stat_slru 1 etendo.profile.sample_stat_io 1 Total 152 Vacuums per table
Key values
- profile.last_stat_indexes_srv1 (15) Main table vacuumed on database etendo
- 97 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples etendo.profile.last_stat_indexes_srv1 15 15 15,388 0 274 0 0 11,287 286 1,791,716 0 0 etendo.profile.last_stat_statements_srv1 15 15 8,253 0 129 0 0 5,442 135 860,074 0 0 etendo.profile.last_stat_tables_srv1 15 15 11,982 0 174 0 0 8,976 175 1,256,631 0 0 etendo.profile.last_stat_user_functions_srv1 15 15 2,158 0 42 0 0 1,139 32 235,059 0 0 etendo.public.ad_ep_instance_para 7 7 413 0 34 0 0 49 13 109,841 0 0 etendo.profile.tables_list 7 7 1,092 0 22 0 0 613 15 147,442 1 7 etendo.profile.funcs_list 4 4 350 0 15 0 0 106 8 66,279 0 0 etendo.profile.stmt_list 4 4 1,185 0 32 0 0 806 36 288,255 12 36 etendo.profile.last_stat_io 3 3 242 0 17 0 0 26 8 50,900 0 0 etendo.profile.indexes_list 3 3 367 0 5 0 0 99 4 34,737 1 4 etendo.profile.last_extension_versions 2 2 107 0 10 0 0 10 4 33,004 0 0 etendo.profile.last_stat_activity_count_srv1 2 0 42 0 10 0 0 12 4 32,640 0 0 etendo.profile.last_stat_database_srv1 1 1 48 0 6 0 0 6 3 19,803 0 0 etendo.pg_catalog.pg_statistic 1 1 1,405 0 279 0 0 1,112 258 1,169,032 98 760 etendo.profile.last_stat_slru 1 1 68 0 5 0 0 5 2 16,636 0 0 etendo.pg_toast.pg_toast_2619 1 1 960 0 117 0 0 377 105 279,805 36 90 etendo.public.ad_session_usage_audit 1 0 4,192 0 2,053 0 0 2,053 2 137,234 0 0 Total 97 94 48,252 0 3,224 0 0 32,118 1,090 6,529,088 148 897 Vacuum throughput per table
Key values
- public.ad_session_usage_audit (0.5) Max CPU elapsed for vacuum on database etendo
- unknown (0 ms) Max I/O read time for vacuum on database etendo
- unknown (0 ms) Max I/O write time for vacuum on database etendo
I/O timing (ms) CPU (s) Table read write elapsed etendo.profile.last_stat_indexes_srv1 0 0 0.16 etendo.profile.last_stat_statements_srv1 0 0 0.07 etendo.profile.last_stat_tables_srv1 0 0 0.15 etendo.profile.last_stat_user_functions_srv1 0 0 0 etendo.public.ad_ep_instance_para 0 0 0.01 etendo.profile.tables_list 0 0 0 etendo.profile.funcs_list 0 0 0 etendo.profile.stmt_list 0 0 0 etendo.profile.last_stat_io 0 0 0 etendo.profile.indexes_list 0 0 0 etendo.profile.last_extension_versions 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.last_stat_database_srv1 0 0 0 etendo.pg_catalog.pg_statistic 0 0 0.09 etendo.profile.last_stat_slru 0 0 0 etendo.pg_toast.pg_toast_2619 0 0 0.04 etendo.public.ad_session_usage_audit 0 0 0.5 Total 0 0 1.02 Tuples removed per table
Key values
- profile.last_stat_indexes_srv1 (70740) Main table with removed tuples on database etendo
- 141038 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.profile.last_stat_indexes_srv1 15 15 70,740 34,935 0 94 4,218 etendo.profile.last_stat_tables_srv1 15 15 44,800 20,880 0 75 3,363 etendo.profile.last_stat_statements_srv1 15 15 16,671 14,501 0 264 1,529 etendo.profile.last_stat_user_functions_srv1 15 15 5,391 4,605 0 5 336 etendo.profile.tables_list 7 7 1,137 5,628 0 0 182 etendo.pg_catalog.pg_statistic 1 1 779 6,285 0 0 535 etendo.profile.stmt_list 4 4 375 2,944 0 0 297 etendo.pg_toast.pg_toast_2619 1 1 259 1,366 0 0 454 etendo.profile.funcs_list 4 4 226 696 0 0 32 etendo.public.ad_ep_instance_para 7 7 150 0 0 7 0 etendo.profile.indexes_list 3 3 148 1,015 0 0 30 etendo.profile.last_stat_io 3 3 143 39 0 1 5 etendo.profile.last_extension_versions 2 2 112 16 0 0 2 etendo.profile.last_stat_slru 1 1 55 5 0 0 1 etendo.profile.last_stat_activity_count_srv1 2 0 48 0 0 2 0 etendo.profile.last_stat_database_srv1 1 1 4 4 0 0 1 etendo.public.ad_session_usage_audit 1 0 0 62,199 0 0 2,052 Total 97 94 141,038 155,118 0 448 13,037 Pages removed per table
Key values
- profile.last_stat_statements_srv1 (264) Main table with removed pages on database etendo
- 448 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed etendo.profile.last_stat_statements_srv1 15 15 16671 264 etendo.profile.last_stat_indexes_srv1 15 15 70740 94 etendo.profile.last_stat_tables_srv1 15 15 44800 75 etendo.public.ad_ep_instance_para 7 7 150 7 etendo.profile.last_stat_user_functions_srv1 15 15 5391 5 etendo.profile.last_stat_activity_count_srv1 2 0 48 2 etendo.profile.last_stat_io 3 3 143 1 etendo.profile.last_stat_database_srv1 1 1 4 0 etendo.profile.last_extension_versions 2 2 112 0 etendo.profile.funcs_list 4 4 226 0 etendo.pg_catalog.pg_statistic 1 1 779 0 etendo.profile.last_stat_slru 1 1 55 0 etendo.profile.stmt_list 4 4 375 0 etendo.profile.tables_list 7 7 1137 0 etendo.pg_toast.pg_toast_2619 1 1 259 0 etendo.public.ad_session_usage_audit 1 0 0 0 etendo.profile.indexes_list 3 3 148 0 Total 97 94 141,038 448 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 14 07 4 8 08 6 6 09 6 12 10 11 15 11 6 14 12 6 12 13 8 12 14 6 7 15 6 13 16 8 6 17 7 14 18 7 6 19 6 12 20 5 8 21 5 7 22 0 0 - 0.50 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 356,673 Total read queries
- 29,004 Total write queries
Queries by database
Key values
- etendo Main database
- 1,188,550 Requests
- 4m12s (etendo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 1,187,470 Requests
User Request type Count Duration postgres Total 9,660 18s595ms others 2,835 0ms select 1,905 0ms tcl 90 0ms tad Total 1,187,470 3m57s delete 99 0ms insert 2,547 0ms others 488 0ms select 354,768 0ms tcl 23,609 0ms update 2,659 0ms Duration by user
Key values
- 3m57s (tad) Main time consuming user
User Request type Count Duration postgres Total 9,660 18s595ms others 2,835 0ms select 1,905 0ms tcl 90 0ms tad Total 1,187,470 3m57s delete 99 0ms insert 2,547 0ms others 488 0ms select 354,768 0ms tcl 23,609 0ms update 2,659 0ms Queries by host
Key values
- 127.0.0.1 Main host
- 1,187,470 Requests
- 3m57s (127.0.0.1)
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 1,181,082 Requests
- 3m42s (openbravo)
- Main time consuming application
Application Request type Count Duration [unknown] Total 8,443 3s791ms others 2,753 0ms select 1,440 0ms tcl 45 0ms openbravo Total 1,181,082 3m42s delete 99 0ms insert 2,547 0ms select 352,068 0ms tcl 23,609 0ms update 2,659 0ms pg_profile Total 1,185 2s875ms others 90 0ms select 435 0ms tcl 45 0ms psql Total 6,420 27s705ms others 480 0ms select 2,730 0ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-14 13:25:25 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 793,546 0-1ms duration
Slowest individual queries
Rank Duration Query NO DATASET
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 4 0ms 0ms 0ms select count(*) as id from c_order where replacementorder_id = ? and c_order.issotrx = ? and exists ( select ? from c_doctype where c_doctype_id = c_order.c_doctypetarget_id and isreturn = ?) and ad_org_id not in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 14 09 2 0ms 0ms 13 2 0ms 0ms 2 0ms 1 0ms 0ms 0ms insert into c_invoiceline (ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoice_id, c_orderline_id, line, description, financial_invoice_line, m_product_id, qtyinvoiced, pricelist, priceactual, pricelimit, linenetamt, chargeamt, c_uom_id, c_tax_id, isdescription, pricestd, excludeforwithholding, iseditlinenetamt, taxbaseamt, line_gross_amount, gross_unit_price, c_bpartner_id, grosspricestd, grosspricelist, isdeferred, explode, match_lccosts, cancelpricead, c_invoiceline_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? n ? ? f9f95d307464074a2dc899b2d3c3ac4 ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? a0e9eb5c5ebb462b9155106a3d441525 ? n ? ? ? n ? n ? ? ? ? ? ? ? c17579cec29c408bba9631eca1df2092 ? ? ? ? ? n ? n ? n ? n ? ? f06a0745b40039260d732e65bbfc1 ');Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 14 17 1 0ms 0ms 3 0ms 542 0ms 0ms 0ms select financialm0_.c_tax_id as c_tax_id1_293_0_, financialm0_.ad_client_id as ad_clien2_293_0_, financialm0_.ad_org_id as ad_org_i3_293_0_, financialm0_.isactive as isactive4_293_0_, financialm0_.created as created5_293_0_, financialm0_.createdby as createdb6_293_0_, financialm0_.updated as updated7_293_0_, financialm0_.name as name8_293_0_, financialm0_.updatedby as updatedb9_293_0_, financialm0_.description as descrip10_293_0_, financialm0_.taxindicator as taxindi11_293_0_, financialm0_.validfrom as validfr12_293_0_, financialm0_.issummary as issumma13_293_0_, financialm0_.rate as rate14_293_0_, financialm0_.parent_tax_id as parent_15_293_0_, financialm0_.c_country_id as c_count16_293_0_, financialm0_.c_region_id as c_regio17_293_0_, financialm0_.to_country_id as to_coun18_293_0_, financialm0_.to_region_id as to_regi19_293_0_, financialm0_.c_taxcategory_id as c_taxca20_293_0_, financialm0_.isdefault as isdefau21_293_0_, financialm0_.istaxexempt as istaxex22_293_0_, financialm0_.sopotype as sopotyp23_293_0_, financialm0_.cascade as cascade24_293_0_, financialm0_.c_bp_taxcategory_id as c_bp_ta25_293_0_, financialm0_.line as line26_293_0_, financialm0_.iswithholdingtax as iswithh27_293_0_, financialm0_.isnotaxable as isnotax28_293_0_, financialm0_.deducpercent as deducpe29_293_0_, financialm0_.originalrate as origina30_293_0_, financialm0_.istaxundeductable as istaxun31_293_0_, financialm0_.istaxdeductable as istaxde32_293_0_, financialm0_.isnovat as isnovat33_293_0_, financialm0_.baseamount as baseamo34_293_0_, financialm0_.c_taxbase_id as c_taxba35_293_0_, financialm0_.doctaxamount as doctaxa36_293_0_, financialm0_.iscashvat as iscashv37_293_0_, financialm0_.em_obspti_declaration as em_obsp38_293_0_, financialm0_.em_obspti_isreversecharge as em_obsp39_293_0_, financialm0_.em_obspti_isequivalentcharge as em_obsp40_293_0_, financialm0_.em_obspti_isintracommunity as em_obsp41_293_0_, financialm0_.em_obspti_islease as em_obsp42_293_0_, financialm0_.em_obspti_isrealestate as em_obsp43_293_0_, financialm0_.em_obspti_reagyp as em_obsp44_293_0_, financialm0_.em_obspti_isrebu as em_obsp45_293_0_, financialm0_.em_obspti_isexport as em_obsp46_293_0_, financialm0_.em_obspti_isimplicitcharge as em_obsp47_293_0_, financialm0_.em_obspti_receive_oss as em_obsp48_293_0_ from c_tax financialm0_ where financialm0_.c_tax_id = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 14 08 48 0ms 0ms 09 107 0ms 0ms 10 134 0ms 0ms 11 64 0ms 0ms 12 37 0ms 0ms 13 18 0ms 0ms 15 17 0ms 0ms 16 43 0ms 0ms 17 56 0ms 0ms 18 18 0ms 0ms 4 0ms 3 0ms 0ms 0ms select ( select count(distinct gl_journalline.account_id) from gl_journalline inner join gl_journal on gl_journalline.gl_journal_id = gl_journal.gl_journal_id where gl_journal.multi_gl = ? and gl_journal.gl_journal_id = ?) as fininvcount, ( select count(distinct glact.c_glitem_id) from gl_journalline inner join gl_journal on gl_journalline.gl_journal_id = gl_journal.gl_journal_id join c_glitem_acct glact on (gl_journalline.account_id = glact.c_glitem_id) where gl_journal.multi_gl = ? and gl_journal.gl_journal_id = ? and glact.c_acctschema_id = ?) as finacctcount from dual;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 14 11 1 0ms 0ms 13 2 0ms 0ms 5 0ms 4 0ms 0ms 0ms select td0.c_doctype_id as id, (coalesce(to_char(( case when td_trl1.name is null then coalesce(to_char(td0.name), ?) else coalesce(to_char(td_trl1.name), ?) end)), ?)) as name, ? as description from c_doctype td0 left join c_doctype_trl td_trl1 on td0.c_doctype_id = td_trl1.c_doctype_id and td_trl1.ad_language = ? where td0.ad_client_id in (...) and td0.ad_org_id in (...) and td0.ad_client_id = ? and (? <> ? or coalesce(?, ?) = ?) and (td0.docbasetype in (...) and td0.issotrx = ? and (ad_isorgincluded (?, td0.ad_org_id, ?) <> ? or coalesce(?, ?) = ?)) and (td0.isactive = ? or td0.c_doctype_id = (null)) and td0.c_doctype_id = (?) order by td0.isdefault desc, td0.name;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 14 09 2 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 6 0ms 22 0ms 0ms 0ms select warehouse0_.m_warehouse_id as m_wareho1_495_, warehouse0_.ad_client_id as ad_clien2_495_, warehouse0_.ad_org_id as ad_org_i3_495_, warehouse0_.isactive as isactive4_495_, warehouse0_.created as created5_495_, warehouse0_.createdby as createdb6_495_, warehouse0_.updated as updated7_495_, warehouse0_.updatedby as updatedb8_495_, warehouse0_.value as value9_495_, warehouse0_.name as name10_495_, warehouse0_.description as descrip11_495_, warehouse0_.c_location_id as c_locat12_495_, warehouse0_.separator as separat13_495_, warehouse0_.isshipper as isshipp14_495_, warehouse0_.shippercode as shipper15_495_, warehouse0_.fromdocumentno as fromdoc16_495_, warehouse0_.todocumentno as todocum17_495_, warehouse0_.m_returnlocator_id as m_retur18_495_, warehouse0_.m_warehouse_rule_id as m_wareh19_495_, warehouse0_.isallocated as isalloc20_495_ from m_warehouse warehouse0_ where warehouse0_.m_warehouse_id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 14 08 4 0ms 0ms 09 5 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 4 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 7 0ms 1 0ms 0ms 0ms insert into fin_payment_scheduledetail (ad_client_id, ad_org_id, created, createdby, updated, updatedby, fin_payment_schedule_invoice, amount, isactive, writeoffamt, iscanceled, c_bpartner_id, doubtfuldebt_amount, isinvoicepaid, fin_payment_scheduledetail_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 14 16 1 0ms 0ms 8 0ms 1 0ms 0ms 0ms select obkmo_widg0_.obkmo_widget_class_id as col_0_0_ from obkmo_widget_class obkmo_widg0_ where obkmo_widg0_.allow_anonymous_access = ? and obkmo_widg0_.issuperclass = ? and obkmo_widg0_.available_in_workspace = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 14 08 1 0ms 0ms 9 0ms 102 0ms 0ms 0ms select c_currency_id from c_acctschema where c_acctschema_id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 14 11 46 0ms 0ms 13 56 0ms 0ms 10 0ms 45 0ms 0ms 0ms set search_path = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 14 07 3 0ms 0ms 08 3 0ms 0ms 09 3 0ms 0ms 10 3 0ms 0ms 11 3 0ms 0ms 12 3 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 3 0ms 0ms 16 3 0ms 0ms 17 3 0ms 0ms 18 3 0ms 0ms 19 3 0ms 0ms 20 3 0ms 0ms 21 3 0ms 0ms 11 0ms 2 0ms 0ms 0ms select count(*) as id from rem_remittanceline_cancel where fin_payment_id = ? and exists ( select ? from rem_remittance where rem_remittance.rem_remittance_id = rem_remittanceline_cancel.rem_remittance_id) and ad_org_id not in (...);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 14 13 2 0ms 0ms 12 0ms 1 0ms 0ms 0ms insert into fact_acct (fact_acct_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_acctschema_id, account_id, acctvalue, acctdescription, datetrx, dateacct, c_period_id, ad_table_id, record_id, line_id, gl_category_id, c_tax_id, postingtype, c_currency_id, amtsourcedr, amtsourcecr, amtacctdr, amtacctcr, c_uom_id, qty, m_locator_id, m_product_id, c_bpartner_id, ad_orgtrx_id, c_locfrom_id, c_locto_id, c_salesregion_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, description, fact_acct_group_id, seqno, docbasetype, record_id2, a_asset_id, c_withholding_id, c_doctype_id, c_costcenter_id, factaccttype) values (?, ?, ?, ?, now(), ?, now(), ?, ?, ?, ?, ?, to_date(?), to_date(?), ?, ?, ?, ?, ?, null, ?, ?, to_number(?), to_number(?), to_number(?), to_number(?), ?, to_number(?), null, null, ?, null, ?, ?, null, null, null, null, null, null, ?, ?, to_number(?), ?, null, null, null, ?, null, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 14 10 1 0ms 0ms 13 0ms 85 0ms 0ms 0ms select coalesce(isreceipt, ?) as isreceipt from fin_payment where fin_payment_id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 14 11 42 0ms 0ms 13 43 0ms 0ms 14 0ms 495 0ms 0ms 0ms select count(*) as total from ( select ? from ad_table_access t, ad_tab tb where t.ad_table_id = tb.ad_table_id and t.ad_role_id = ? and tb.ad_tab_id = ? and t.isactive = ? and t.isexclude = ? and (t.isreadonly = ? or tb.uipattern = ?) union select ? from ad_window_access w, ad_tab t where w.isactive = ? and w.ad_window_id = t.ad_window_id and w.ad_role_id = ? and t.ad_tab_id = ? and w.isreadwrite = ? and w.isactive = ? and not exists ( select ? from ad_tab_access ta where ta.isactive = ? and ta.ad_window_access_id = w.ad_window_access_id and ta.ad_tab_id = t.ad_tab_id and (ta.isreadwrite = ? or exists ( select ? from ad_field_access fa where fa.isactive = ? and fa.ad_tab_access_id = ta.ad_tab_access_id and fa.isreadwrite = ?))) union select ? from ad_window_access w, ad_tab_access t where w.isactive = ? and w.ad_window_access_id = t.ad_window_access_id and w.ad_role_id = ? and t.ad_tab_id = ? and t.isreadwrite = ? and t.isactive = ? and not exists ( select ? from ad_field_access fa where fa.isactive = ? and fa.ad_tab_access_id = t.ad_tab_access_id and fa.isreadwrite = ?)) t;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 14 08 61 0ms 0ms 09 119 0ms 0ms 10 90 0ms 0ms 11 33 0ms 0ms 12 18 0ms 0ms 13 45 0ms 0ms 14 15 0ms 0ms 15 33 0ms 0ms 16 62 0ms 0ms 17 18 0ms 0ms 18 1 0ms 0ms 15 0ms 1 0ms 0ms 0ms select businesspa0_.c_bpartner_id as c_bpartn1_172_, businesspa0_.ad_client_id as ad_clien2_172_, businesspa0_.ad_org_id as ad_org_i3_172_, businesspa0_.isactive as isactive4_172_, businesspa0_.created as created5_172_, businesspa0_.createdby as createdb6_172_, businesspa0_.updated as updated7_172_, businesspa0_.updatedby as updatedb8_172_, businesspa0_.value as value9_172_, businesspa0_.name as name10_172_, businesspa0_.name2 as name11_172_, businesspa0_.description as descrip12_172_, businesspa0_.issummary as issumma13_172_, businesspa0_.c_bp_group_id as c_bp_gr14_172_, businesspa0_.isonetime as isoneti15_172_, businesspa0_.isprospect as isprosp16_172_, businesspa0_.isvendor as isvendo17_172_, businesspa0_.iscustomer as iscusto18_172_, businesspa0_.isemployee as isemplo19_172_, businesspa0_.issalesrep as issales20_172_, businesspa0_.referenceno as referen21_172_, businesspa0_.duns as duns22_172_, businesspa0_.url as url23_172_, businesspa0_.ad_language as ad_lang24_172_, businesspa0_.taxid as taxid25_172_, businesspa0_.istaxexempt as istaxex26_172_, businesspa0_.c_invoiceschedule_id as c_invoi27_172_, businesspa0_.rating as rating28_172_, businesspa0_.salesvolume as salesvo29_172_, businesspa0_.numberemployees as numbere30_172_, businesspa0_.naics as naics31_172_, businesspa0_.firstsale as firstsa32_172_, businesspa0_.acqusitioncost as acqusit33_172_, businesspa0_.potentiallifetimevalue as potenti34_172_, businesspa0_.actuallifetimevalue as actuall35_172_, businesspa0_.shareofcustomer as shareof36_172_, businesspa0_.paymentrule as payment37_172_, businesspa0_.so_creditlimit as so_cred38_172_, businesspa0_.so_creditused as so_cred39_172_, businesspa0_.c_paymentterm_id as c_payme40_172_, businesspa0_.m_pricelist_id as m_price41_172_, businesspa0_.isdiscountprinted as isdisco42_172_, businesspa0_.so_description as so_desc43_172_, businesspa0_.poreference as porefer44_172_, businesspa0_.paymentrulepo as payment45_172_, businesspa0_.po_pricelist_id as po_pric46_172_, businesspa0_.po_paymentterm_id as po_paym47_172_, businesspa0_.documentcopies as documen48_172_, businesspa0_.c_greeting_id as c_greet49_172_, businesspa0_.invoicerule as invoice50_172_, businesspa0_.deliveryrule as deliver51_172_, businesspa0_.deliveryviarule as deliver52_172_, businesspa0_.salesrep_id as salesre53_172_, businesspa0_.bpartner_parent_id as bpartne54_172_, businesspa0_.socreditstatus as socredi55_172_, businesspa0_.ad_forced_org_id as ad_forc56_172_, businesspa0_.showpriceinorder as showpri57_172_, businesspa0_.invoicegrouping as invoice58_172_, businesspa0_.fixmonthday as fixmont59_172_, businesspa0_.fixmonthday2 as fixmont60_172_, businesspa0_.fixmonthday3 as fixmont61_172_, businesspa0_.isworker as isworke62_172_, businesspa0_.upc as upc63_172_, businesspa0_.c_salary_category_id as c_salar64_172_, businesspa0_.invoice_printformat as invoice65_172_, businesspa0_.last_days as last_da66_172_, businesspa0_.po_bankaccount_id as po_bank67_172_, businesspa0_.po_bp_taxcategory_id as po_bp_t68_172_, businesspa0_.po_fixmonthday as po_fixm69_172_, businesspa0_.po_fixmonthday2 as po_fixm70_172_, businesspa0_.po_fixmonthday3 as po_fixm71_172_, businesspa0_.so_bankaccount_id as so_bank72_172_, businesspa0_.so_bp_taxcategory_id as so_bp_t73_172_, businesspa0_.fiscalcode as fiscalc74_172_, businesspa0_.isofiscalcode as isofisc75_172_, businesspa0_.em_einv_einvoice as em_einv76_172_, businesspa0_.po_c_incoterms_id as po_c_in77_172_, businesspa0_.em_einv_format_id as em_einv78_172_, businesspa0_.so_c_incoterms_id as so_c_in79_172_, businesspa0_.em_einv_platform_id as em_einv80_172_, businesspa0_.fin_paymentmethod_id as fin_pay81_172_, businesspa0_.em_einv_email as em_einv82_172_, businesspa0_.po_paymentmethod_id as po_paym83_172_, businesspa0_.fin_financial_account_id as fin_fin84_172_, businesspa0_.em_einv_deliverymode as em_einv85_172_, businesspa0_.po_financial_account_id as po_fina86_172_, businesspa0_.customer_blocking as custome87_172_, businesspa0_.vendor_blocking as vendor_88_172_, businesspa0_.so_payment_blocking as so_paym89_172_, businesspa0_.po_payment_blocking as po_paym90_172_, businesspa0_.so_invoice_blocking as so_invo91_172_, businesspa0_.po_invoice_blocking as po_invo92_172_, businesspa0_.so_order_blocking as so_orde93_172_, businesspa0_.po_order_blocking as po_orde94_172_, businesspa0_.so_goods_blocking as so_good95_172_, businesspa0_.po_goods_blocking as po_good96_172_, businesspa0_.iscashvat as iscashv97_172_, businesspa0_.update_currency as update_98_172_, businesspa0_.bp_currency_id as bp_curr99_172_, businesspa0_.birthplace as birthp100_172_, businesspa0_.birthday as birthd101_172_, businesspa0_.is_customer_consent as is_cus102_172_, businesspa0_.em_obsepad_mandate_identifier as em_obs103_172_, businesspa0_.em_obsepad_mandate_date as em_obs104_172_, businesspa0_.em_obtik_tax_id_key as em_obt105_172_ from c_bpartner businesspa0_ where businesspa0_.c_bpartner_id = ? and (businesspa0_.ad_org_id in (...)) and (businesspa0_.ad_client_id in (...)) order by businesspa0_.created desc, businesspa0_.c_bpartner_id desc limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 14 10 1 0ms 0ms 16 0ms 36 0ms 0ms 0ms select processclu0_.ad_process_id as ad_proce9_86_1_, processclu0_.ad_process_cluster_inst_id as ad_proce1_86_1_, processclu0_.ad_process_cluster_inst_id as ad_proce1_86_0_, processclu0_.ad_client_id as ad_clien2_86_0_, processclu0_.ad_org_id as ad_org_i3_86_0_, processclu0_.isactive as isactive4_86_0_, processclu0_.created as created5_86_0_, processclu0_.createdby as createdb6_86_0_, processclu0_.updated as updated7_86_0_, processclu0_.updatedby as updatedb8_86_0_, processclu0_.ad_process_id as ad_proce9_86_0_, processclu0_.ad_cluster_instance_id as ad_clus10_86_0_ from ad_process_cluster_inst processclu0_ where processclu0_.ad_process_id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 14 08 1 0ms 0ms 09 7 0ms 0ms 10 1 0ms 0ms 11 5 0ms 0ms 12 1 0ms 0ms 13 5 0ms 0ms 16 15 0ms 0ms 17 1 0ms 0ms 17 0ms 3 0ms 0ms 0ms update ad_preference set updated = ?, value = ? ? ec3e8d143aa4da0aa9d62bdb4abbc96 ';Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 14 16 3 0ms 0ms 18 0ms 22 0ms 0ms 0ms select c_invoiceschedule_id as columnname from c_invoiceschedule where isactive = ? and isdefault = ? and ad_client_id in (...) and ad_org_id in (...) order by ad_client_id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 14 08 4 0ms 0ms 09 5 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 4 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 19 0ms 1 0ms 0ms 0ms select count(fact_acct_group_id) as total from ( select f.dateacct, f.fact_acct_group_id from ad_table t left join ad_tab tb on t.ad_table_id = tb.ad_table_id left join ad_column c on t.ad_table_id = c.ad_table_id and c.iskey = ? left join fact_acct f on f.ad_table_id = t.ad_table_id left join ad_window w on tb.ad_window_id = w.ad_window_id where f.ad_client_id in (...) and f.ad_org_id in (...) and ? = ? and f.fact_acct_group_id = ? and ( case ( select max(issotrx) from c_doctype d where d.docbasetype = f.docbasetype) when ? then coalesce(t.po_window_id, t.ad_window_id) else t.ad_window_id end) = w.ad_window_id group by f.dateacct, f.fact_acct_group_id) aa where (dateacct < to_date(?) or (dateacct = to_date(?) and fact_acct_group_id < ?));Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 14 12 1 0ms 0ms 20 0ms 1 0ms 0ms 0ms insert into c_orderline (ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_order_id, line, c_bpartner_id, c_bpartner_location_id, dateordered, datepromised, description, m_product_id, m_warehouse_id, directship, c_uom_id, qtyordered, c_currency_id, pricelist, priceactual, pricelimit, linenetamt, discount, chargeamt, c_tax_id, ref_orderline_id, isdescription, pricestd, cancelpricead, iseditlinenetamt, taxbaseamt, gross_unit_price, line_gross_amount, grosspricelist, grosspricestd, manage_reservation, manage_prereservation, explode, em_opxmp_purchase_bpartner_id, em_opxmp_costprice, print_description, em_opxmp_m_pl_version_id, em_opxmp_margen, relate_orderline, em_opxmp_poline_id, c_orderline_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ? f9f95d307464074a2dc899b2d3c3ac4 ? cd0854c3d1394b6299bd7ebed08e0968 ? n ? ? ? ? ? ? ? ?.? ? ?.? ? ? ? ?.? ? ? ? ? ? ? a024850e28c41838d722405575f0eac ? ? b3bc66309f455a9656bf3e9d86c0a6 ? n ? ?.? ? n ? n ? ?.? ? ? ? ? ? ? ? ? ? n ? n ? n ? ? fca8be9dc46d5b44e5c6feec5e67b ? ?.? ? n ? abfdfdb2fbec4f34b33c8e0a1c9844ef ? ? ? n ? ? b3bc66309f455a9656bf3e9d86c0a6 ? ? adfb00dd484a916d43e902e82582 ');Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 14 09 1 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 176,757 0ms 0ms 0ms 0ms select this_.ad_sequence_config_id as ad_seque1_112_0_, this_.ad_client_id as ad_clien2_112_0_, this_.ad_org_id as ad_org_i3_112_0_, this_.isactive as isactive4_112_0_, this_.created as created5_112_0_, this_.createdby as createdb6_112_0_, this_.updated as updated7_112_0_, this_.updatedby as updatedb8_112_0_, this_.generator as generato9_112_0_, this_.ad_reference_id as ad_refe10_112_0_, this_.db_sequence_name as db_sequ11_112_0_, this_.db_sequence_initial as db_sequ12_112_0_, this_.db_sequence_increment as db_sequ13_112_0_ from ad_sequence_config this_ where this_.ad_reference_id = ? and this_.ad_org_id in (...) and this_.ad_client_id in (...) and this_.isactive = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 14 08 14,397 0ms 0ms 09 24,973 0ms 0ms 10 39,408 0ms 0ms 11 24,211 0ms 0ms 12 10,610 0ms 0ms 13 14,317 0ms 0ms 15 5,036 0ms 0ms 16 21,300 0ms 0ms 17 17,186 0ms 0ms 18 5,319 0ms 0ms 2 14,192 0ms 0ms 0ms 0ms select distinct addimensio0_.documentlevel as col_0_0_ from ad_dimension_mapping addimensio0_ where addimensio0_.ad_table_id = ? and addimensio0_.dimension = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 14 08 1,028 0ms 0ms 09 1,756 0ms 0ms 10 2,820 0ms 0ms 11 2,068 0ms 0ms 12 766 0ms 0ms 13 1,346 0ms 0ms 15 452 0ms 0ms 16 2,374 0ms 0ms 17 1,248 0ms 0ms 18 334 0ms 0ms 3 12,818 0ms 0ms 0ms 0ms select coalesce(t.msgtext, m.msgtext) as msgtext from ad_message m left join ad_message_trl t on m.ad_message_id = t.ad_message_id and t.ad_language = ? where m.value = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 14 07 720 0ms 0ms 08 783 0ms 0ms 09 816 0ms 0ms 10 971 0ms 0ms 11 867 0ms 0ms 12 1,133 0ms 0ms 13 1,086 0ms 0ms 14 753 0ms 0ms 15 867 0ms 0ms 16 1,105 0ms 0ms 17 785 0ms 0ms 18 736 0ms 0ms 19 729 0ms 0ms 20 729 0ms 0ms 21 729 0ms 0ms 22 9 0ms 0ms 4 11,805 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 14 07 127 0ms 0ms 08 754 0ms 0ms 09 1,439 0ms 0ms 10 1,929 0ms 0ms 11 1,619 0ms 0ms 12 931 0ms 0ms 13 1,448 0ms 0ms 14 407 0ms 0ms 15 463 0ms 0ms 16 1,240 0ms 0ms 17 723 0ms 0ms 18 337 0ms 0ms 19 128 0ms 0ms 20 128 0ms 0ms 21 128 0ms 0ms 22 4 0ms 0ms 5 11,790 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 14 07 130 0ms 0ms 08 747 0ms 0ms 09 1,427 0ms 0ms 10 1,924 0ms 0ms 11 1,615 0ms 0ms 12 934 0ms 0ms 13 1,441 0ms 0ms 14 411 0ms 0ms 15 463 0ms 0ms 16 1,240 0ms 0ms 17 724 0ms 0ms 18 338 0ms 0ms 19 131 0ms 0ms 20 131 0ms 0ms 21 131 0ms 0ms 22 3 0ms 0ms 6 7,096 0ms 0ms 0ms 0ms select distinct addimensio0_.docbasetype as col_0_0_ from ad_dimension_mapping addimensio0_ where addimensio0_.ad_table_id = ? and addimensio0_.dimension = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 14 08 514 0ms 0ms 09 878 0ms 0ms 10 1,410 0ms 0ms 11 1,034 0ms 0ms 12 383 0ms 0ms 13 673 0ms 0ms 15 226 0ms 0ms 16 1,187 0ms 0ms 17 624 0ms 0ms 18 167 0ms 0ms 7 6,803 0ms 0ms 0ms 0ms select count(*) as total from ad_session where ad_session_id = ? and session_active = ? and isactive = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 14 08 458 0ms 0ms 09 962 0ms 0ms 10 1,241 0ms 0ms 11 1,080 0ms 0ms 12 484 0ms 0ms 13 869 0ms 0ms 14 116 0ms 0ms 15 207 0ms 0ms 16 839 0ms 0ms 17 415 0ms 0ms 18 132 0ms 0ms 8 5,038 0ms 0ms 0ms 0ms select adlanguage0_.ad_language_id as ad_langu1_52_0_, adlanguage0_.ad_language as ad_langu2_52_0_, adlanguage0_.ad_client_id as ad_clien3_52_0_, adlanguage0_.ad_org_id as ad_org_i4_52_0_, adlanguage0_.isactive as isactive5_52_0_, adlanguage0_.created as created6_52_0_, adlanguage0_.createdby as createdb7_52_0_, adlanguage0_.updated as updated8_52_0_, adlanguage0_.updatedby as updatedb9_52_0_, adlanguage0_.name as name10_52_0_, adlanguage0_.languageiso as languag11_52_0_, adlanguage0_.countrycode as country12_52_0_, adlanguage0_.isbaselanguage as isbasel13_52_0_, adlanguage0_.issystemlanguage as issyste14_52_0_, adlanguage0_.processing as process15_52_0_, adlanguage0_.pixelsize as pixelsi16_52_0_, adlanguage0_.translatedby as transla17_52_0_, adlanguage0_.isrtl as isrtl18_52_0_ from ad_language adlanguage0_ where adlanguage0_.ad_language = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 14 07 60 0ms 0ms 08 382 0ms 0ms 09 730 0ms 0ms 10 833 0ms 0ms 11 781 0ms 0ms 12 292 0ms 0ms 13 518 0ms 0ms 14 76 0ms 0ms 15 168 0ms 0ms 16 530 0ms 0ms 17 350 0ms 0ms 18 128 0ms 0ms 19 62 0ms 0ms 20 62 0ms 0ms 21 62 0ms 0ms 22 4 0ms 0ms 9 4,698 0ms 0ms 0ms 0ms select sum(total) as total from ( select count(*) as total from ad_process_access where ad_role_id = ? and (to_char(?) = ? or to_char(?) = ?) and ad_process_id = ? and isactive = ? union select count(*) as total from ad_form_access where ad_role_id = ? and to_char(?) = ? and ad_form_id = ? and isactive = ? union select count(*) as total from dual where (to_char(?) = ? or to_char(?) = ?) and to_char(?) <> to_char(?) union select count(*) as total from ad_window_access where ad_role_id = ? and to_char(?) = ? and ad_window_id = ( select ad_window_id from ad_tab where ad_tab_id = ?) and isactive = ? union select count(*) as total from ad_table_access t, ad_tab tb where t.ad_table_id = tb.ad_table_id and t.ad_role_id = ? and to_char(?) = ? and tb.ad_tab_id = ? and t.isactive = ? and t.isexclude = ? union select count(*) as total from ad_process_access a, ad_process p where ad_role_id = ? and to_char(?) = to_char(?) and a.ad_process_id = ? and p.ad_process_id = a.ad_process_id and a.isactive = ? and p.isexternalservice = ? union select ? as total from ad_process where to_char(?) = to_char(?) and ad_process_id = ? and isactive = ? and isexternalservice != ?) total;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 14 08 377 0ms 0ms 09 818 0ms 0ms 10 839 0ms 0ms 11 840 0ms 0ms 12 295 0ms 0ms 13 525 0ms 0ms 14 4 0ms 0ms 15 120 0ms 0ms 16 479 0ms 0ms 17 315 0ms 0ms 18 86 0ms 0ms 10 3,927 0ms 0ms 0ms 0ms select financialm0_.c_elementvalue_id as c_elemen1_211_0_, financialm0_.ad_client_id as ad_clien2_211_0_, financialm0_.ad_org_id as ad_org_i3_211_0_, financialm0_.isactive as isactive4_211_0_, financialm0_.created as created5_211_0_, financialm0_.createdby as createdb6_211_0_, financialm0_.updated as updated7_211_0_, financialm0_.updatedby as updatedb8_211_0_, financialm0_.value as value9_211_0_, financialm0_.name as name10_211_0_, financialm0_.description as descrip11_211_0_, financialm0_.accounttype as account12_211_0_, financialm0_.accountsign as account13_211_0_, financialm0_.isdoccontrolled as isdocco14_211_0_, financialm0_.c_element_id as c_eleme15_211_0_, financialm0_.issummary as issumma16_211_0_, financialm0_.validfrom as validfr17_211_0_, financialm0_.validto as validto18_211_0_, financialm0_.postactual as postact19_211_0_, financialm0_.postbudget as postbud20_211_0_, financialm0_.postencumbrance as postenc21_211_0_, financialm0_.poststatistical as poststa22_211_0_, financialm0_.isbankaccount as isbanka23_211_0_, financialm0_.c_bankaccount_id as c_banka24_211_0_, financialm0_.isforeigncurrency as isforei25_211_0_, financialm0_.c_currency_id as c_curre26_211_0_, financialm0_.showelement as showele27_211_0_, financialm0_.showvaluecond as showval28_211_0_, financialm0_.elementlevel as element29_211_0_, financialm0_.isalwaysshown as isalway30_211_0_ from c_elementvalue financialm0_ where financialm0_.c_elementvalue_id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 14 11 44 0ms 0ms 13 41 0ms 0ms 15 3,154 0ms 0ms 16 688 0ms 0ms 11 3,907 0ms 0ms 0ms 0ms select adtable0_.ad_table_id as ad_table1_120_0_, adtable0_.ad_client_id as ad_clien2_120_0_, adtable0_.ad_org_id as ad_org_i3_120_0_, adtable0_.isactive as isactive4_120_0_, adtable0_.created as created5_120_0_, adtable0_.createdby as createdb6_120_0_, adtable0_.updated as updated7_120_0_, adtable0_.updatedby as updatedb8_120_0_, adtable0_.name as name9_120_0_, adtable0_.description as descrip10_120_0_, adtable0_.help as help11_120_0_, adtable0_.tablename as tablena12_120_0_, adtable0_.classname as classna13_120_0_, adtable0_.isview as isview14_120_0_, adtable0_.accesslevel as accessl15_120_0_, adtable0_.ad_window_id as ad_wind16_120_0_, adtable0_.issecurityenabled as issecur17_120_0_, adtable0_.isdeleteable as isdelet18_120_0_, adtable0_.ishighvolume as ishighv19_120_0_, adtable0_.importtable as importt20_120_0_, adtable0_.ischangelog as ischang21_120_0_, adtable0_.po_window_id as po_wind22_120_0_, adtable0_.isdefaultacct as isdefau23_120_0_, adtable0_.sql_record_identifier as sql_rec24_120_0_, adtable0_.developmentstatus as develop25_120_0_, adtable0_.ad_package_id as ad_pack26_120_0_, adtable0_.treetype as treetyp27_120_0_, adtable0_.acctdate_column_id as acctdat28_120_0_, adtable0_.acctclassname as acctcla29_120_0_, adtable0_.isfullyaudited as isfully30_120_0_, adtable0_.isauditinserts as isaudit31_120_0_, adtable0_.dataorigintype as dataori32_120_0_, adtable0_.obserds_datasource_id as obserds33_120_0_, adtable0_.istree as istree34_120_0_, adtable0_.hqlquery as hqlquer35_120_0_, adtable0_.entity_alias as entity_36_120_0_ from ad_table adtable0_ where adtable0_.ad_table_id = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 14 08 28 0ms 0ms 09 811 0ms 0ms 10 60 0ms 0ms 11 56 0ms 0ms 12 14 0ms 0ms 13 2,831 0ms 0ms 14 2 0ms 0ms 15 4 0ms 0ms 16 77 0ms 0ms 17 10 0ms 0ms 18 10 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 12 3,628 0ms 0ms 0ms 0ms select text.filename as filename, text.text as text, text.isused as isused, text.ad_module_id as moduleid, texttrl.ad_language as trllang, texttrl.text as trltext, texttrl.istranslated as istranslated, ? as orderseq from ad_textinterfaces text, ad_textinterfaces_trl texttrl where text.ad_textinterfaces_id = texttrl.ad_textinterfaces_id and text.filename = ? and text.isused = ? and texttrl.ad_language = ? union select text.filename as filename, text.text as text, text.isused as isused, text.ad_module_id as moduleid, texttrl.ad_language as trllang, texttrl.text as trltext, texttrl.istranslated as istranslated, ? as orderseq from ad_textinterfaces text, ad_textinterfaces_trl texttrl where text.ad_textinterfaces_id = texttrl.ad_textinterfaces_id and text.filename is null and text.isused = ? and texttrl.ad_language = ? union select text.filename as filename, text.text as text, text.isused as isused, text.ad_module_id as moduleid, ? as trllang, text.text as trltext, ? as istranslated, ? as orderseq from ad_textinterfaces text where text.ad_textinterfaces_id not in ( select t.ad_textinterfaces_id from ad_textinterfaces t, ad_textinterfaces_trl trl where t.ad_textinterfaces_id = trl.ad_textinterfaces_id and trl.ad_language = ?) and (text.filename is null or text.filename = ?) and text.isused = ? order by orderseq;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 14 07 60 0ms 0ms 08 147 0ms 0ms 09 106 0ms 0ms 10 463 0ms 0ms 11 269 0ms 0ms 12 713 0ms 0ms 13 628 0ms 0ms 14 62 0ms 0ms 15 259 0ms 0ms 16 521 0ms 0ms 17 147 0ms 0ms 18 73 0ms 0ms 19 60 0ms 0ms 20 60 0ms 0ms 21 60 0ms 0ms 13 2,601 0ms 0ms 0ms 0ms select this_.c_invoice_id as c_invoic1_230_0_, this_.ad_client_id as ad_clien2_230_0_, this_.ad_org_id as ad_org_i3_230_0_, this_.isactive as isactive4_230_0_, this_.created as created5_230_0_, this_.createdby as createdb6_230_0_, this_.updated as updated7_230_0_, this_.updatedby as updatedb8_230_0_, this_.issotrx as issotrx9_230_0_, this_.documentno as documen10_230_0_, this_.docstatus as docstat11_230_0_, this_.docaction as docacti12_230_0_, this_.processing as process13_230_0_, this_.processed as process14_230_0_, this_.posted as posted15_230_0_, this_.c_doctype_id as c_docty16_230_0_, this_.c_doctypetarget_id as c_docty17_230_0_, this_.c_order_id as c_order18_230_0_, this_.description as descrip19_230_0_, this_.isprinted as isprint20_230_0_, this_.salesrep_id as salesre21_230_0_, this_.dateinvoiced as dateinv22_230_0_, this_.dateprinted as datepri23_230_0_, this_.dateacct as dateacc24_230_0_, this_.c_bpartner_id as c_bpart25_230_0_, this_.c_bpartner_location_id as c_bpart26_230_0_, this_.poreference as porefer27_230_0_, this_.isdiscountprinted as isdisco28_230_0_, this_.dateordered as dateord29_230_0_, this_.c_currency_id as c_curre30_230_0_, this_.c_paymentterm_id as c_payme31_230_0_, this_.c_charge_id as c_charg32_230_0_, this_.chargeamt as chargea33_230_0_, this_.totallines as totalli34_230_0_, this_.grandtotal as grandto35_230_0_, this_.m_pricelist_id as m_price36_230_0_, this_.istaxincluded as istaxin37_230_0_, this_.c_campaign_id as c_campa38_230_0_, this_.c_project_id as c_proje39_230_0_, this_.c_activity_id as c_activ40_230_0_, this_.createfrom as createf41_230_0_, this_.generateto as generat42_230_0_, this_.ad_user_id as ad_user43_230_0_, this_.copyfrom as copyfro44_230_0_, this_.isselfservice as isselfs45_230_0_, this_.ad_orgtrx_id as ad_orgt46_230_0_, this_.user1_id as user47_230_0_, this_.user2_id as user48_230_0_, this_.withholdingamount as withhol49_230_0_, this_.taxdate as taxdate50_230_0_, this_.c_withholding_id as c_withh51_230_0_, this_.ispaid as ispaid52_230_0_, this_.em_einv_generated as em_einv53_230_0_, this_.totalpaid as totalpa54_230_0_, this_.em_einv_sent as em_einv55_230_0_, this_.outstandingamt as outstan56_230_0_, this_.daystilldue as daystil57_230_0_, this_.dueamt as dueamt58_230_0_, this_.lastcalculatedondate as lastcal59_230_0_, this_.fin_paymentmethod_id as fin_pay60_230_0_, this_.fin_payment_priority_id as fin_pay61_230_0_, this_.finalsettlement as finalse62_230_0_, this_.daysoutstanding as daysout63_230_0_, this_.percentageoverdue as percent64_230_0_, this_.c_costcenter_id as c_costc65_230_0_, this_.calculate_promotions as calcula66_230_0_, this_.a_asset_id as a_asset67_230_0_, this_.em_aprm_addpayment as em_aprm68_230_0_, this_.iscashvat as iscashv69_230_0_, this_.em_aprm_processinvoice as em_aprm70_230_0_, this_.prepaymentamt as prepaym71_230_0_, this_.createfromorders as createf72_230_0_, this_.createfrominouts as createf73_230_0_, this_.paidamtatinvoicing as paidamt74_230_0_, this_.bpartner_extref as bpartne75_230_0_, this_.em_opxcld_createlines as em_opxc76_230_0_ from c_invoice this_ where this_.issotrx = ? and this_.ad_org_id = ? and this_.ad_org_id in (...) and this_.ad_client_id in (...) and this_.isactive = ? order by this_.documentno desc;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 14 08 262 0ms 0ms 10 262 0ms 0ms 15 262 0ms 0ms 17 1,815 0ms 0ms 14 2,522 0ms 0ms 0ms 0ms select accesslevel from ad_form where to_char(?) = ? and ad_form_id = ? union select accesslevel from ad_process where (to_char(?) = ? or to_char(?) = ?) and ad_process_id = ? union select t.accesslevel from ad_table t, ad_tab tb where t.ad_table_id = tb.ad_table_id and to_char(?) = ? and tb.ad_tab_id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 14 08 195 0ms 0ms 09 414 0ms 0ms 10 441 0ms 0ms 11 431 0ms 0ms 12 187 0ms 0ms 13 302 0ms 0ms 14 2 0ms 0ms 15 72 0ms 0ms 16 269 0ms 0ms 17 165 0ms 0ms 18 44 0ms 0ms 15 2,396 0ms 0ms 0ms 0ms select currency0_.c_currency_id as c_curren1_197_0_, currency0_.ad_client_id as ad_clien2_197_0_, currency0_.ad_org_id as ad_org_i3_197_0_, currency0_.isactive as isactive4_197_0_, currency0_.created as created5_197_0_, currency0_.createdby as createdb6_197_0_, currency0_.updated as updated7_197_0_, currency0_.updatedby as updatedb8_197_0_, currency0_.iso_code as iso_code9_197_0_, currency0_.cursymbol as cursymb10_197_0_, currency0_.description as descrip11_197_0_, currency0_.stdprecision as stdprec12_197_0_, currency0_.costingprecision as costing13_197_0_, currency0_.priceprecision as pricepr14_197_0_, currency0_.issymbolrightside as issymbo15_197_0_ from c_currency currency0_ where currency0_.c_currency_id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 14 08 177 0ms 0ms 09 375 0ms 0ms 10 431 0ms 0ms 11 443 0ms 0ms 12 132 0ms 0ms 13 284 0ms 0ms 14 2 0ms 0ms 15 47 0ms 0ms 16 290 0ms 0ms 17 170 0ms 0ms 18 45 0ms 0ms 16 2,216 0ms 0ms 0ms 0ms select adclient0_.ad_client_id as ad_clien1_18_0_, adclient0_.ad_org_id as ad_org_i2_18_0_, adclient0_.isactive as isactive3_18_0_, adclient0_.created as created4_18_0_, adclient0_.createdby as createdb5_18_0_, adclient0_.updated as updated6_18_0_, adclient0_.updatedby as updatedb7_18_0_, adclient0_.value as value8_18_0_, adclient0_.name as name9_18_0_, adclient0_.description as descrip10_18_0_, adclient0_.smtphost as smtphos11_18_0_, adclient0_.requestemail as request12_18_0_, adclient0_.requestuser as request13_18_0_, adclient0_.requestuserpw as request14_18_0_, adclient0_.requestfolder as request15_18_0_, adclient0_.ad_language as ad_lang16_18_0_, adclient0_.ismultilingualdocument as ismulti17_18_0_, adclient0_.issmtpauthorization as issmtpa18_18_0_, adclient0_.c_currency_id as c_curre19_18_0_, adclient0_.acctdim_centrally_maintained as acctdim20_18_0_, adclient0_.project_acctdim_isenable as project21_18_0_, adclient0_.project_acctdim_header as project22_18_0_, adclient0_.project_acctdim_lines as project23_18_0_, adclient0_.project_acctdim_breakdown as project24_18_0_, adclient0_.bpartner_acctdim_isenable as bpartne25_18_0_, adclient0_.bpartner_acctdim_header as bpartne26_18_0_, adclient0_.bpartner_acctdim_lines as bpartne27_18_0_, adclient0_.bpartner_acctdim_breakdown as bpartne28_18_0_, adclient0_.product_acctdim_isenable as product29_18_0_, adclient0_.product_acctdim_header as product30_18_0_, adclient0_.product_acctdim_lines as product31_18_0_, adclient0_.product_acctdim_breakdown as product32_18_0_, adclient0_.costcenter_acctdim_header as costcen33_18_0_, adclient0_.costcenter_acctdim_lines as costcen34_18_0_, adclient0_.costcenter_acctdim_breakdown as costcen35_18_0_, adclient0_.user1_acctdim_isenable as user36_18_0_, adclient0_.user1_acctdim_header as user37_18_0_, adclient0_.user1_acctdim_lines as user38_18_0_, adclient0_.user1_acctdim_breakdown as user39_18_0_, adclient0_.user2_acctdim_isenable as user40_18_0_, adclient0_.user2_acctdim_header as user41_18_0_, adclient0_.user2_acctdim_lines as user42_18_0_, adclient0_.user2_acctdim_breakdown as user43_18_0_, adclient0_.costcenter_acctdim_isenable as costcen44_18_0_, adclient0_.org_acctdim_isenable as org_acc45_18_0_, adclient0_.org_acctdim_header as org_acc46_18_0_, adclient0_.org_acctdim_lines as org_acc47_18_0_, adclient0_.org_acctdim_breakdown as org_acc48_18_0_, adclient0_.daystopasswordexpiration as daystop49_18_0_ from ad_client adclient0_ where adclient0_.ad_client_id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 14 07 60 0ms 0ms 08 139 0ms 0ms 09 250 0ms 0ms 10 291 0ms 0ms 11 303 0ms 0ms 12 120 0ms 0ms 13 265 0ms 0ms 14 65 0ms 0ms 15 98 0ms 0ms 16 213 0ms 0ms 17 147 0ms 0ms 18 85 0ms 0ms 19 60 0ms 0ms 20 60 0ms 0ms 21 60 0ms 0ms 17 2,191 0ms 0ms 0ms 0ms select ? from dual;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 14 07 120 0ms 0ms 08 141 0ms 0ms 09 162 0ms 0ms 10 178 0ms 0ms 11 172 0ms 0ms 12 163 0ms 0ms 13 182 0ms 0ms 14 124 0ms 0ms 15 144 0ms 0ms 16 171 0ms 0ms 17 144 0ms 0ms 18 127 0ms 0ms 19 120 0ms 0ms 20 120 0ms 0ms 21 121 0ms 0ms 22 2 0ms 0ms 18 2,066 0ms 0ms 0ms 0ms select organizati0_.ad_org_id as ad_org_i1_71_0_, organizati0_.ad_client_id as ad_clien2_71_0_, organizati0_.isactive as isactive3_71_0_, organizati0_.created as created4_71_0_, organizati0_.createdby as createdb5_71_0_, organizati0_.updated as updated6_71_0_, organizati0_.updatedby as updatedb7_71_0_, organizati0_.value as value8_71_0_, organizati0_.name as name9_71_0_, organizati0_.description as descrip10_71_0_, organizati0_.issummary as issumma11_71_0_, organizati0_.ad_orgtype_id as ad_orgt12_71_0_, organizati0_.isperiodcontrolallowed as isperio13_71_0_, organizati0_.c_calendar_id as c_calen14_71_0_, organizati0_.isready as isready15_71_0_, organizati0_.social_name as social_16_71_0_, organizati0_.c_currency_id as c_curre17_71_0_, organizati0_.c_acctschema_id as c_accts18_71_0_, organizati0_.em_aprm_glitem_id as em_aprm19_71_0_, organizati0_.ad_periodcontrolallowed_org_id as ad_peri20_71_0_, organizati0_.ad_calendarowner_org_id as ad_cale21_71_0_, organizati0_.ad_legalentity_org_id as ad_lega22_71_0_, organizati0_.ad_inheritedcalendar_id as ad_inhe23_71_0_, organizati0_.ad_businessunit_org_id as ad_busi24_71_0_, organizati0_.c_extbp_enabled as c_extbp25_71_0_, organizati0_.c_extbp_config_id as c_extbp26_71_0_ from ad_org organizati0_ where organizati0_.ad_org_id in (...);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 14 08 165 0ms 0ms 09 336 0ms 0ms 10 368 0ms 0ms 11 362 0ms 0ms 12 112 0ms 0ms 13 223 0ms 0ms 14 8 0ms 0ms 15 53 0ms 0ms 16 270 0ms 0ms 17 130 0ms 0ms 18 34 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 2 0ms 0ms 19 2,050 0ms 0ms 0ms 0ms insert into ad_session_usage_audit (ad_session_usage_audit_id, ad_client_id, ad_org_id, createdby, updatedby, ad_session_id, object_id, ad_module_id, command, classname, object_type, process_time) values (get_uuid (), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, to_number(?));Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 14 08 153 0ms 0ms 09 299 0ms 0ms 10 401 0ms 0ms 11 332 0ms 0ms 12 157 0ms 0ms 13 264 0ms 0ms 14 2 0ms 0ms 15 65 0ms 0ms 16 211 0ms 0ms 17 122 0ms 0ms 18 44 0ms 0ms 20 2,015 0ms 0ms 0ms 0ms select aduser0_.ad_user_id as ad_user_1_129_0_, aduser0_.ad_client_id as ad_clien2_129_0_, aduser0_.ad_org_id as ad_org_i3_129_0_, aduser0_.isactive as isactive4_129_0_, aduser0_.created as created5_129_0_, aduser0_.createdby as createdb6_129_0_, aduser0_.updated as updated7_129_0_, aduser0_.updatedby as updatedb8_129_0_, aduser0_.name as name9_129_0_, aduser0_.description as descrip10_129_0_, aduser0_.password as passwor11_129_0_, aduser0_.email as email12_129_0_, aduser0_.supervisor_id as supervi13_129_0_, aduser0_.c_bpartner_id as c_bpart14_129_0_, aduser0_.processing as process15_129_0_, aduser0_.emailuser as emailus16_129_0_, aduser0_.emailuserpw as emailus17_129_0_, aduser0_.c_bpartner_location_id as c_bpart18_129_0_, aduser0_.c_greeting_id as c_greet19_129_0_, aduser0_.title as title20_129_0_, aduser0_.comments as comment21_129_0_, aduser0_.phone as phone22_129_0_, aduser0_.phone2 as phone23_129_0_, aduser0_.fax as fax24_129_0_, aduser0_.lastcontact as lastcon25_129_0_, aduser0_.lastresult as lastres26_129_0_, aduser0_.birthday as birthda27_129_0_, aduser0_.ad_orgtrx_id as ad_orgt28_129_0_, aduser0_.firstname as firstna29_129_0_, aduser0_.lastname as lastnam30_129_0_, aduser0_.username as usernam31_129_0_, aduser0_.default_ad_client_id as default32_129_0_, aduser0_.default_ad_language as default33_129_0_, aduser0_.default_ad_org_id as default34_129_0_, aduser0_.default_ad_role_id as default35_129_0_, aduser0_.default_m_warehouse_id as default36_129_0_, aduser0_.islocked as islocke37_129_0_, aduser0_.ad_image_id as ad_imag38_129_0_, aduser0_.grant_portal_access as grant_p39_129_0_, aduser0_.lastpasswordupdate as lastpas40_129_0_, aduser0_.isexpiredpassword as isexpir41_129_0_, aduser0_.commercialauth as commerc42_129_0_, aduser0_.viasms as viasms43_129_0_, aduser0_.viaemail as viaemai44_129_0_, aduser0_.em_smfsws_default_ws_role_id as em_smfs45_129_0_ from ad_user aduser0_ where aduser0_.ad_user_id in (...);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 14 08 158 0ms 0ms 09 325 0ms 0ms 10 358 0ms 0ms 11 385 0ms 0ms 12 118 0ms 0ms 13 261 0ms 0ms 14 4 0ms 0ms 15 47 0ms 0ms 16 187 0ms 0ms 17 146 0ms 0ms 18 26 0ms 0ms Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 0ms 0ms 4 0ms select count(*) as id from c_order where replacementorder_id = ? and c_order.issotrx = ? and exists ( select ? from c_doctype where c_doctype_id = c_order.c_doctypetarget_id and isreturn = ?) and ad_org_id not in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 14 09 2 0ms 0ms 13 2 0ms 0ms 2 0ms 0ms 0ms 1 0ms insert into c_invoiceline (ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoice_id, c_orderline_id, line, description, financial_invoice_line, m_product_id, qtyinvoiced, pricelist, priceactual, pricelimit, linenetamt, chargeamt, c_uom_id, c_tax_id, isdescription, pricestd, excludeforwithholding, iseditlinenetamt, taxbaseamt, line_gross_amount, gross_unit_price, c_bpartner_id, grosspricestd, grosspricelist, isdeferred, explode, match_lccosts, cancelpricead, c_invoiceline_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? n ? ? f9f95d307464074a2dc899b2d3c3ac4 ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? a0e9eb5c5ebb462b9155106a3d441525 ? n ? ? ? n ? n ? ? ? ? ? ? ? c17579cec29c408bba9631eca1df2092 ? ? ? ? ? n ? n ? n ? n ? ? f06a0745b40039260d732e65bbfc1 ');Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 14 17 1 0ms 0ms 3 0ms 0ms 0ms 542 0ms select financialm0_.c_tax_id as c_tax_id1_293_0_, financialm0_.ad_client_id as ad_clien2_293_0_, financialm0_.ad_org_id as ad_org_i3_293_0_, financialm0_.isactive as isactive4_293_0_, financialm0_.created as created5_293_0_, financialm0_.createdby as createdb6_293_0_, financialm0_.updated as updated7_293_0_, financialm0_.name as name8_293_0_, financialm0_.updatedby as updatedb9_293_0_, financialm0_.description as descrip10_293_0_, financialm0_.taxindicator as taxindi11_293_0_, financialm0_.validfrom as validfr12_293_0_, financialm0_.issummary as issumma13_293_0_, financialm0_.rate as rate14_293_0_, financialm0_.parent_tax_id as parent_15_293_0_, financialm0_.c_country_id as c_count16_293_0_, financialm0_.c_region_id as c_regio17_293_0_, financialm0_.to_country_id as to_coun18_293_0_, financialm0_.to_region_id as to_regi19_293_0_, financialm0_.c_taxcategory_id as c_taxca20_293_0_, financialm0_.isdefault as isdefau21_293_0_, financialm0_.istaxexempt as istaxex22_293_0_, financialm0_.sopotype as sopotyp23_293_0_, financialm0_.cascade as cascade24_293_0_, financialm0_.c_bp_taxcategory_id as c_bp_ta25_293_0_, financialm0_.line as line26_293_0_, financialm0_.iswithholdingtax as iswithh27_293_0_, financialm0_.isnotaxable as isnotax28_293_0_, financialm0_.deducpercent as deducpe29_293_0_, financialm0_.originalrate as origina30_293_0_, financialm0_.istaxundeductable as istaxun31_293_0_, financialm0_.istaxdeductable as istaxde32_293_0_, financialm0_.isnovat as isnovat33_293_0_, financialm0_.baseamount as baseamo34_293_0_, financialm0_.c_taxbase_id as c_taxba35_293_0_, financialm0_.doctaxamount as doctaxa36_293_0_, financialm0_.iscashvat as iscashv37_293_0_, financialm0_.em_obspti_declaration as em_obsp38_293_0_, financialm0_.em_obspti_isreversecharge as em_obsp39_293_0_, financialm0_.em_obspti_isequivalentcharge as em_obsp40_293_0_, financialm0_.em_obspti_isintracommunity as em_obsp41_293_0_, financialm0_.em_obspti_islease as em_obsp42_293_0_, financialm0_.em_obspti_isrealestate as em_obsp43_293_0_, financialm0_.em_obspti_reagyp as em_obsp44_293_0_, financialm0_.em_obspti_isrebu as em_obsp45_293_0_, financialm0_.em_obspti_isexport as em_obsp46_293_0_, financialm0_.em_obspti_isimplicitcharge as em_obsp47_293_0_, financialm0_.em_obspti_receive_oss as em_obsp48_293_0_ from c_tax financialm0_ where financialm0_.c_tax_id = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 14 08 48 0ms 0ms 09 107 0ms 0ms 10 134 0ms 0ms 11 64 0ms 0ms 12 37 0ms 0ms 13 18 0ms 0ms 15 17 0ms 0ms 16 43 0ms 0ms 17 56 0ms 0ms 18 18 0ms 0ms 4 0ms 0ms 0ms 3 0ms select ( select count(distinct gl_journalline.account_id) from gl_journalline inner join gl_journal on gl_journalline.gl_journal_id = gl_journal.gl_journal_id where gl_journal.multi_gl = ? and gl_journal.gl_journal_id = ?) as fininvcount, ( select count(distinct glact.c_glitem_id) from gl_journalline inner join gl_journal on gl_journalline.gl_journal_id = gl_journal.gl_journal_id join c_glitem_acct glact on (gl_journalline.account_id = glact.c_glitem_id) where gl_journal.multi_gl = ? and gl_journal.gl_journal_id = ? and glact.c_acctschema_id = ?) as finacctcount from dual;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 14 11 1 0ms 0ms 13 2 0ms 0ms 5 0ms 0ms 0ms 4 0ms select td0.c_doctype_id as id, (coalesce(to_char(( case when td_trl1.name is null then coalesce(to_char(td0.name), ?) else coalesce(to_char(td_trl1.name), ?) end)), ?)) as name, ? as description from c_doctype td0 left join c_doctype_trl td_trl1 on td0.c_doctype_id = td_trl1.c_doctype_id and td_trl1.ad_language = ? where td0.ad_client_id in (...) and td0.ad_org_id in (...) and td0.ad_client_id = ? and (? <> ? or coalesce(?, ?) = ?) and (td0.docbasetype in (...) and td0.issotrx = ? and (ad_isorgincluded (?, td0.ad_org_id, ?) <> ? or coalesce(?, ?) = ?)) and (td0.isactive = ? or td0.c_doctype_id = (null)) and td0.c_doctype_id = (?) order by td0.isdefault desc, td0.name;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 14 09 2 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 6 0ms 0ms 0ms 22 0ms select warehouse0_.m_warehouse_id as m_wareho1_495_, warehouse0_.ad_client_id as ad_clien2_495_, warehouse0_.ad_org_id as ad_org_i3_495_, warehouse0_.isactive as isactive4_495_, warehouse0_.created as created5_495_, warehouse0_.createdby as createdb6_495_, warehouse0_.updated as updated7_495_, warehouse0_.updatedby as updatedb8_495_, warehouse0_.value as value9_495_, warehouse0_.name as name10_495_, warehouse0_.description as descrip11_495_, warehouse0_.c_location_id as c_locat12_495_, warehouse0_.separator as separat13_495_, warehouse0_.isshipper as isshipp14_495_, warehouse0_.shippercode as shipper15_495_, warehouse0_.fromdocumentno as fromdoc16_495_, warehouse0_.todocumentno as todocum17_495_, warehouse0_.m_returnlocator_id as m_retur18_495_, warehouse0_.m_warehouse_rule_id as m_wareh19_495_, warehouse0_.isallocated as isalloc20_495_ from m_warehouse warehouse0_ where warehouse0_.m_warehouse_id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 14 08 4 0ms 0ms 09 5 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 4 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 7 0ms 0ms 0ms 1 0ms insert into fin_payment_scheduledetail (ad_client_id, ad_org_id, created, createdby, updated, updatedby, fin_payment_schedule_invoice, amount, isactive, writeoffamt, iscanceled, c_bpartner_id, doubtfuldebt_amount, isinvoicepaid, fin_payment_scheduledetail_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 14 16 1 0ms 0ms 8 0ms 0ms 0ms 1 0ms select obkmo_widg0_.obkmo_widget_class_id as col_0_0_ from obkmo_widget_class obkmo_widg0_ where obkmo_widg0_.allow_anonymous_access = ? and obkmo_widg0_.issuperclass = ? and obkmo_widg0_.available_in_workspace = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 14 08 1 0ms 0ms 9 0ms 0ms 0ms 102 0ms select c_currency_id from c_acctschema where c_acctschema_id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 14 11 46 0ms 0ms 13 56 0ms 0ms 10 0ms 0ms 0ms 45 0ms set search_path = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 14 07 3 0ms 0ms 08 3 0ms 0ms 09 3 0ms 0ms 10 3 0ms 0ms 11 3 0ms 0ms 12 3 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 3 0ms 0ms 16 3 0ms 0ms 17 3 0ms 0ms 18 3 0ms 0ms 19 3 0ms 0ms 20 3 0ms 0ms 21 3 0ms 0ms 11 0ms 0ms 0ms 2 0ms select count(*) as id from rem_remittanceline_cancel where fin_payment_id = ? and exists ( select ? from rem_remittance where rem_remittance.rem_remittance_id = rem_remittanceline_cancel.rem_remittance_id) and ad_org_id not in (...);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 14 13 2 0ms 0ms 12 0ms 0ms 0ms 1 0ms insert into fact_acct (fact_acct_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_acctschema_id, account_id, acctvalue, acctdescription, datetrx, dateacct, c_period_id, ad_table_id, record_id, line_id, gl_category_id, c_tax_id, postingtype, c_currency_id, amtsourcedr, amtsourcecr, amtacctdr, amtacctcr, c_uom_id, qty, m_locator_id, m_product_id, c_bpartner_id, ad_orgtrx_id, c_locfrom_id, c_locto_id, c_salesregion_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, description, fact_acct_group_id, seqno, docbasetype, record_id2, a_asset_id, c_withholding_id, c_doctype_id, c_costcenter_id, factaccttype) values (?, ?, ?, ?, now(), ?, now(), ?, ?, ?, ?, ?, to_date(?), to_date(?), ?, ?, ?, ?, ?, null, ?, ?, to_number(?), to_number(?), to_number(?), to_number(?), ?, to_number(?), null, null, ?, null, ?, ?, null, null, null, null, null, null, ?, ?, to_number(?), ?, null, null, null, ?, null, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 14 10 1 0ms 0ms 13 0ms 0ms 0ms 85 0ms select coalesce(isreceipt, ?) as isreceipt from fin_payment where fin_payment_id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 14 11 42 0ms 0ms 13 43 0ms 0ms 14 0ms 0ms 0ms 495 0ms select count(*) as total from ( select ? from ad_table_access t, ad_tab tb where t.ad_table_id = tb.ad_table_id and t.ad_role_id = ? and tb.ad_tab_id = ? and t.isactive = ? and t.isexclude = ? and (t.isreadonly = ? or tb.uipattern = ?) union select ? from ad_window_access w, ad_tab t where w.isactive = ? and w.ad_window_id = t.ad_window_id and w.ad_role_id = ? and t.ad_tab_id = ? and w.isreadwrite = ? and w.isactive = ? and not exists ( select ? from ad_tab_access ta where ta.isactive = ? and ta.ad_window_access_id = w.ad_window_access_id and ta.ad_tab_id = t.ad_tab_id and (ta.isreadwrite = ? or exists ( select ? from ad_field_access fa where fa.isactive = ? and fa.ad_tab_access_id = ta.ad_tab_access_id and fa.isreadwrite = ?))) union select ? from ad_window_access w, ad_tab_access t where w.isactive = ? and w.ad_window_access_id = t.ad_window_access_id and w.ad_role_id = ? and t.ad_tab_id = ? and t.isreadwrite = ? and t.isactive = ? and not exists ( select ? from ad_field_access fa where fa.isactive = ? and fa.ad_tab_access_id = t.ad_tab_access_id and fa.isreadwrite = ?)) t;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 14 08 61 0ms 0ms 09 119 0ms 0ms 10 90 0ms 0ms 11 33 0ms 0ms 12 18 0ms 0ms 13 45 0ms 0ms 14 15 0ms 0ms 15 33 0ms 0ms 16 62 0ms 0ms 17 18 0ms 0ms 18 1 0ms 0ms 15 0ms 0ms 0ms 1 0ms select businesspa0_.c_bpartner_id as c_bpartn1_172_, businesspa0_.ad_client_id as ad_clien2_172_, businesspa0_.ad_org_id as ad_org_i3_172_, businesspa0_.isactive as isactive4_172_, businesspa0_.created as created5_172_, businesspa0_.createdby as createdb6_172_, businesspa0_.updated as updated7_172_, businesspa0_.updatedby as updatedb8_172_, businesspa0_.value as value9_172_, businesspa0_.name as name10_172_, businesspa0_.name2 as name11_172_, businesspa0_.description as descrip12_172_, businesspa0_.issummary as issumma13_172_, businesspa0_.c_bp_group_id as c_bp_gr14_172_, businesspa0_.isonetime as isoneti15_172_, businesspa0_.isprospect as isprosp16_172_, businesspa0_.isvendor as isvendo17_172_, businesspa0_.iscustomer as iscusto18_172_, businesspa0_.isemployee as isemplo19_172_, businesspa0_.issalesrep as issales20_172_, businesspa0_.referenceno as referen21_172_, businesspa0_.duns as duns22_172_, businesspa0_.url as url23_172_, businesspa0_.ad_language as ad_lang24_172_, businesspa0_.taxid as taxid25_172_, businesspa0_.istaxexempt as istaxex26_172_, businesspa0_.c_invoiceschedule_id as c_invoi27_172_, businesspa0_.rating as rating28_172_, businesspa0_.salesvolume as salesvo29_172_, businesspa0_.numberemployees as numbere30_172_, businesspa0_.naics as naics31_172_, businesspa0_.firstsale as firstsa32_172_, businesspa0_.acqusitioncost as acqusit33_172_, businesspa0_.potentiallifetimevalue as potenti34_172_, businesspa0_.actuallifetimevalue as actuall35_172_, businesspa0_.shareofcustomer as shareof36_172_, businesspa0_.paymentrule as payment37_172_, businesspa0_.so_creditlimit as so_cred38_172_, businesspa0_.so_creditused as so_cred39_172_, businesspa0_.c_paymentterm_id as c_payme40_172_, businesspa0_.m_pricelist_id as m_price41_172_, businesspa0_.isdiscountprinted as isdisco42_172_, businesspa0_.so_description as so_desc43_172_, businesspa0_.poreference as porefer44_172_, businesspa0_.paymentrulepo as payment45_172_, businesspa0_.po_pricelist_id as po_pric46_172_, businesspa0_.po_paymentterm_id as po_paym47_172_, businesspa0_.documentcopies as documen48_172_, businesspa0_.c_greeting_id as c_greet49_172_, businesspa0_.invoicerule as invoice50_172_, businesspa0_.deliveryrule as deliver51_172_, businesspa0_.deliveryviarule as deliver52_172_, businesspa0_.salesrep_id as salesre53_172_, businesspa0_.bpartner_parent_id as bpartne54_172_, businesspa0_.socreditstatus as socredi55_172_, businesspa0_.ad_forced_org_id as ad_forc56_172_, businesspa0_.showpriceinorder as showpri57_172_, businesspa0_.invoicegrouping as invoice58_172_, businesspa0_.fixmonthday as fixmont59_172_, businesspa0_.fixmonthday2 as fixmont60_172_, businesspa0_.fixmonthday3 as fixmont61_172_, businesspa0_.isworker as isworke62_172_, businesspa0_.upc as upc63_172_, businesspa0_.c_salary_category_id as c_salar64_172_, businesspa0_.invoice_printformat as invoice65_172_, businesspa0_.last_days as last_da66_172_, businesspa0_.po_bankaccount_id as po_bank67_172_, businesspa0_.po_bp_taxcategory_id as po_bp_t68_172_, businesspa0_.po_fixmonthday as po_fixm69_172_, businesspa0_.po_fixmonthday2 as po_fixm70_172_, businesspa0_.po_fixmonthday3 as po_fixm71_172_, businesspa0_.so_bankaccount_id as so_bank72_172_, businesspa0_.so_bp_taxcategory_id as so_bp_t73_172_, businesspa0_.fiscalcode as fiscalc74_172_, businesspa0_.isofiscalcode as isofisc75_172_, businesspa0_.em_einv_einvoice as em_einv76_172_, businesspa0_.po_c_incoterms_id as po_c_in77_172_, businesspa0_.em_einv_format_id as em_einv78_172_, businesspa0_.so_c_incoterms_id as so_c_in79_172_, businesspa0_.em_einv_platform_id as em_einv80_172_, businesspa0_.fin_paymentmethod_id as fin_pay81_172_, businesspa0_.em_einv_email as em_einv82_172_, businesspa0_.po_paymentmethod_id as po_paym83_172_, businesspa0_.fin_financial_account_id as fin_fin84_172_, businesspa0_.em_einv_deliverymode as em_einv85_172_, businesspa0_.po_financial_account_id as po_fina86_172_, businesspa0_.customer_blocking as custome87_172_, businesspa0_.vendor_blocking as vendor_88_172_, businesspa0_.so_payment_blocking as so_paym89_172_, businesspa0_.po_payment_blocking as po_paym90_172_, businesspa0_.so_invoice_blocking as so_invo91_172_, businesspa0_.po_invoice_blocking as po_invo92_172_, businesspa0_.so_order_blocking as so_orde93_172_, businesspa0_.po_order_blocking as po_orde94_172_, businesspa0_.so_goods_blocking as so_good95_172_, businesspa0_.po_goods_blocking as po_good96_172_, businesspa0_.iscashvat as iscashv97_172_, businesspa0_.update_currency as update_98_172_, businesspa0_.bp_currency_id as bp_curr99_172_, businesspa0_.birthplace as birthp100_172_, businesspa0_.birthday as birthd101_172_, businesspa0_.is_customer_consent as is_cus102_172_, businesspa0_.em_obsepad_mandate_identifier as em_obs103_172_, businesspa0_.em_obsepad_mandate_date as em_obs104_172_, businesspa0_.em_obtik_tax_id_key as em_obt105_172_ from c_bpartner businesspa0_ where businesspa0_.c_bpartner_id = ? and (businesspa0_.ad_org_id in (...)) and (businesspa0_.ad_client_id in (...)) order by businesspa0_.created desc, businesspa0_.c_bpartner_id desc limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 14 10 1 0ms 0ms 16 0ms 0ms 0ms 36 0ms select processclu0_.ad_process_id as ad_proce9_86_1_, processclu0_.ad_process_cluster_inst_id as ad_proce1_86_1_, processclu0_.ad_process_cluster_inst_id as ad_proce1_86_0_, processclu0_.ad_client_id as ad_clien2_86_0_, processclu0_.ad_org_id as ad_org_i3_86_0_, processclu0_.isactive as isactive4_86_0_, processclu0_.created as created5_86_0_, processclu0_.createdby as createdb6_86_0_, processclu0_.updated as updated7_86_0_, processclu0_.updatedby as updatedb8_86_0_, processclu0_.ad_process_id as ad_proce9_86_0_, processclu0_.ad_cluster_instance_id as ad_clus10_86_0_ from ad_process_cluster_inst processclu0_ where processclu0_.ad_process_id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 14 08 1 0ms 0ms 09 7 0ms 0ms 10 1 0ms 0ms 11 5 0ms 0ms 12 1 0ms 0ms 13 5 0ms 0ms 16 15 0ms 0ms 17 1 0ms 0ms 17 0ms 0ms 0ms 3 0ms update ad_preference set updated = ?, value = ? ? ec3e8d143aa4da0aa9d62bdb4abbc96 ';Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 14 16 3 0ms 0ms 18 0ms 0ms 0ms 22 0ms select c_invoiceschedule_id as columnname from c_invoiceschedule where isactive = ? and isdefault = ? and ad_client_id in (...) and ad_org_id in (...) order by ad_client_id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 14 08 4 0ms 0ms 09 5 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 4 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 19 0ms 0ms 0ms 1 0ms select count(fact_acct_group_id) as total from ( select f.dateacct, f.fact_acct_group_id from ad_table t left join ad_tab tb on t.ad_table_id = tb.ad_table_id left join ad_column c on t.ad_table_id = c.ad_table_id and c.iskey = ? left join fact_acct f on f.ad_table_id = t.ad_table_id left join ad_window w on tb.ad_window_id = w.ad_window_id where f.ad_client_id in (...) and f.ad_org_id in (...) and ? = ? and f.fact_acct_group_id = ? and ( case ( select max(issotrx) from c_doctype d where d.docbasetype = f.docbasetype) when ? then coalesce(t.po_window_id, t.ad_window_id) else t.ad_window_id end) = w.ad_window_id group by f.dateacct, f.fact_acct_group_id) aa where (dateacct < to_date(?) or (dateacct = to_date(?) and fact_acct_group_id < ?));Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 14 12 1 0ms 0ms 20 0ms 0ms 0ms 1 0ms insert into c_orderline (ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_order_id, line, c_bpartner_id, c_bpartner_location_id, dateordered, datepromised, description, m_product_id, m_warehouse_id, directship, c_uom_id, qtyordered, c_currency_id, pricelist, priceactual, pricelimit, linenetamt, discount, chargeamt, c_tax_id, ref_orderline_id, isdescription, pricestd, cancelpricead, iseditlinenetamt, taxbaseamt, gross_unit_price, line_gross_amount, grosspricelist, grosspricestd, manage_reservation, manage_prereservation, explode, em_opxmp_purchase_bpartner_id, em_opxmp_costprice, print_description, em_opxmp_m_pl_version_id, em_opxmp_margen, relate_orderline, em_opxmp_poline_id, c_orderline_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ? f9f95d307464074a2dc899b2d3c3ac4 ? cd0854c3d1394b6299bd7ebed08e0968 ? n ? ? ? ? ? ? ? ?.? ? ?.? ? ? ? ?.? ? ? ? ? ? ? a024850e28c41838d722405575f0eac ? ? b3bc66309f455a9656bf3e9d86c0a6 ? n ? ?.? ? n ? n ? ?.? ? ? ? ? ? ? ? ? ? n ? n ? n ? ? fca8be9dc46d5b44e5c6feec5e67b ? ?.? ? n ? abfdfdb2fbec4f34b33c8e0a1c9844ef ? ? ? n ? ? b3bc66309f455a9656bf3e9d86c0a6 ? ? adfb00dd484a916d43e902e82582 ');Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 14 09 1 0ms 0ms Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 132 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 14 08 8 0ms 0ms 09 22 0ms 0ms 10 25 0ms 0ms 11 6 0ms 0ms 12 6 0ms 0ms 13 3 0ms 0ms 14 1 0ms 0ms 15 4 0ms 0ms 16 25 0ms 0ms 17 23 0ms 0ms 18 4 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 2 0ms 0ms 22 1 0ms 0ms -
;
Date: Duration: 0ms Database: postgres User: etendo Remote: tad Application: 127.0.0.1 Queryid: openbravo
-
Events
Log levels
Key values
- 1,569,844 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 7 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3 Max number of times the same event was reported
- 7 Total events found
Rank Times reported Error 1 3 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 14 08 1 09 1 15 1 - ERROR: column "cost" does not exist at character 49
- ERROR: column "cost" does not exist at character 49
- ERROR: column "cost" does not exist at character 49
Statement: select sum(order0_.TotalLines) as col_0_0_, sum(Cost) as col_1_0_, sum(Margen) as col_2_0_, sum(PMargen)/count(*) as col_3_0_ from C_Order order0_ left outer join C_Invoice invoicelis1_ on order0_.C_Order_ID=invoicelis1_.C_Order_ID cross join C_OrderLine orderline2_ where orderline2_.C_Order_ID=order0_.C_Order_ID and order0_.IsSOTrx='Y' and order0_.DocStatus='CO' and 1=1 limit $1
Date: 2026-07-14 08:56:01 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Statement: select sum(order0_.TotalLines) as col_0_0_, sum(Cost) as col_1_0_, sum(Margen) as col_2_0_, sum(PMargen)/count(*) as col_3_0_ from C_Order order0_ left outer join C_Invoice invoicelis1_ on order0_.C_Order_ID=invoicelis1_.C_Order_ID cross join C_OrderLine orderline2_ where orderline2_.C_Order_ID=order0_.C_Order_ID and order0_.IsSOTrx='Y' and order0_.DocStatus='CO' and 1=1 limit $1
Date: 2026-07-14 09:32:54 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Statement: select sum(order0_.TotalLines) as col_0_0_, sum(Cost) as col_1_0_, sum(Margen) as col_2_0_, sum(PMargen)/count(*) as col_3_0_ from C_Order order0_ left outer join C_Invoice invoicelis1_ on order0_.C_Order_ID=invoicelis1_.C_Order_ID cross join C_OrderLine orderline2_ where orderline2_.C_Order_ID=order0_.C_Order_ID and order0_.IsSOTrx='Y' and order0_.DocStatus='CO' and 1=1 limit $1
Date: 2026-07-14 15:46:26 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
2 2 ERROR: @DistinctAmtError@
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 14 13 2 - ERROR: @DistinctAmtError@
- ERROR: @DistinctAmtError@
Context: PL/pgSQL function gl_journal_post(character varying,character varying) line 360 at RAISE
Statement: SELECT gl_journal_post($1,$2) AS RESULT FROM DUALDate: 2026-07-14 13:41:08 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Context: PL/pgSQL function gl_journal_post(character varying,character varying) line 360 at RAISE
Statement: SELECT gl_journal_post($1,$2) AS RESULT FROM DUALDate: 2026-07-14 13:43:11 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
3 1 ERROR: @20501@
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 14 08 1 - ERROR: @20501@
Context: PL/pgSQL function c_ordertax_trg() line 65 at RAISE
Statement: delete from C_OrderTax where C_OrderTax_ID=$1Date: 2026-07-14 08:41:41 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
4 1 ERROR: @APRM_JSAMOUNTDIFFTOZERO@
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 14 11 1 - ERROR: @APRM_JSAMOUNTDIFFTOZERO@
Context: PL/pgSQL function gl_journalline_trg() line 67 at RAISE
Statement: insert into GL_JournalLine (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, GL_Journal_ID, Line, IsGenerated, Description, AmtSourceDr, AmtSourceCr, C_Currency_ID, CurrencyRateType, CurrencyRate, AmtAcctDr, AmtAcctCr, C_UOM_ID, C_ValidCombination_ID, Open_Items, EM_Aprm_Addpayment, GL_JournalLine_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23)Date: 2026-07-14 11:03:40 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1