pgBadger-
Global information
- Generated on Thu Jul 16 23:05:56 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 3,003,428 log entries in 5m54s
- Log start from 2026-07-16 07:00:01 to 2026-07-16 22:00:00
-
Overview
Global Stats
- 1,317 Number of unique normalized queries
- 1,417,451 Number of queries
- 3m56s Total query duration
- 2026-07-16 07:00:01 First query
- 2026-07-16 22:00:00 Last query
- 4,086 queries/s at 2026-07-16 08:38:55 Query peak
- 3m56s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 3m56s Execute total duration
- 5 Number of events
- 1 Number of unique normalized events
- 5 Max number of times the same event was reported
- 0 Number of cancellation
- 105 Total number of automatic vacuums
- 166 Total number of automatic analyzes
- 20 Number temporary file
- 90.80 MiB Max size of temporary file
- 22.10 MiB Average size of temporary file
- 5,415 Total number of sessions
- 0 sessions at Session peak
- 2m2s Total duration of sessions
- 22ms Average duration of sessions
- 261 Average queries per session
- 43ms Average queries duration per session
- 0ms Average idle time per session
- 5,415 Total number of connections
- 5 connections/s at 2026-07-16 15:00:02 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4,086 queries/s Query Peak
- 2026-07-16 08:38:55 Date
SELECT Traffic
Key values
- 1,334 queries/s Query Peak
- 2026-07-16 08:38:55 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 174 queries/s Query Peak
- 2026-07-16 10:18:45 Date
Queries duration
Key values
- 3m56s 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 16 07 11,737 0ms 765ms 0ms 65ms 126ms 1s8ms 08 93,250 0ms 702ms 0ms 741ms 1s371ms 1s516ms 09 316,344 0ms 845ms 0ms 1s600ms 1s768ms 2s207ms 10 240,435 0ms 851ms 0ms 1s103ms 1s579ms 1s848ms 11 131,450 0ms 827ms 0ms 720ms 1s26ms 1s953ms 12 132,645 0ms 820ms 0ms 382ms 798ms 3s470ms 13 119,605 0ms 2s330ms 0ms 596ms 1s583ms 2s548ms 14 61,551 0ms 769ms 0ms 313ms 507ms 1s190ms 15 39,037 0ms 12s781ms 1ms 410ms 707ms 41s849ms 16 89,780 0ms 752ms 0ms 426ms 569ms 1s717ms 17 114,498 0ms 1s117ms 0ms 439ms 831ms 2s583ms 18 35,298 0ms 795ms 0ms 86ms 398ms 1s247ms 19 10,231 0ms 932ms 0ms 69ms 75ms 1s215ms 20 10,191 0ms 691ms 0ms 69ms 74ms 958ms 21 10,739 0ms 12s675ms 3ms 66ms 70ms 31s817ms 22 660 0ms 22ms 0ms 71ms 71ms 71ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 16 07 3,322 0 0ms 0ms 0ms 0ms 08 28,014 0 0ms 0ms 0ms 0ms 09 97,960 0 0ms 0ms 0ms 0ms 10 73,146 0 0ms 0ms 0ms 0ms 11 38,159 0 0ms 0ms 0ms 0ms 12 39,524 0 0ms 0ms 0ms 0ms 13 36,310 0 0ms 0ms 0ms 0ms 14 17,787 0 0ms 0ms 0ms 0ms 15 11,133 0 0ms 0ms 0ms 0ms 16 27,440 0 0ms 0ms 0ms 0ms 17 35,022 0 0ms 0ms 0ms 0ms 18 10,625 0 0ms 0ms 0ms 0ms 19 2,921 0 0ms 0ms 0ms 0ms 20 2,921 0 0ms 0ms 0ms 0ms 21 2,990 0 0ms 0ms 0ms 0ms 22 202 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 16 07 3 5 0 0 0ms 0ms 0ms 0ms 08 156 152 0 0 0ms 0ms 0ms 0ms 09 631 390 11 0 0ms 0ms 0ms 0ms 10 493 668 11 0 0ms 0ms 0ms 0ms 11 397 534 10 0 0ms 0ms 0ms 0ms 12 290 411 12 0 0ms 0ms 0ms 0ms 13 190 274 13 0 0ms 0ms 0ms 0ms 14 120 210 1 0 0ms 0ms 0ms 0ms 15 35 183 0 0 0ms 0ms 0ms 0ms 16 130 114 3 0 0ms 0ms 0ms 0ms 17 238 129 13 0 0ms 0ms 0ms 0ms 18 52 43 2 0 0ms 0ms 0ms 0ms 19 1 3 0 0 0ms 0ms 0ms 0ms 20 1 4 0 0 0ms 0ms 0ms 0ms 21 7 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 16 07 0 3,457 3,457.00 0.00% 08 0 29,873 29,873.00 0.00% 09 0 103,085 103,085.00 0.00% 10 0 78,039 78,039.00 0.00% 11 0 42,085 42,085.00 0.00% 12 0 42,822 42,822.00 0.00% 13 0 38,835 38,835.00 0.00% 14 0 19,576 19,576.00 0.00% 15 0 12,164 12,164.00 0.00% 16 0 28,890 28,890.00 0.00% 17 0 36,931 36,931.00 0.00% 18 0 11,163 11,163.00 0.00% 19 0 2,994 2,994.00 0.00% 20 0 2,995 2,995.00 0.00% 21 0 3,132 3,132.00 0.00% 22 0 212 212.00 0.00% Day Hour Count Average / Second Jul 16 07 361 0.10/s 08 361 0.10/s 09 361 0.10/s 10 361 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 16 07 361 22ms 9ms 08 361 22ms 0ms 09 361 22ms 0ms 10 361 22ms 0ms 11 361 23ms 0ms 12 361 22ms 0ms 13 361 23ms 0ms 14 361 22ms 2ms 15 361 22ms 0ms 16 361 22ms 0ms 17 361 22ms 0ms 18 361 22ms 8ms 19 361 23ms 13ms 20 361 21ms 12ms 21 361 21ms 0ms 22 0 0ms 0ms -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-16 15:00:02 Date
Connections per database
Key values
- etendo Main Database
- 5,415 connections Total
Connections per user
Key values
- tad Main User
- 5,415 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- 5,398 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 5,415 sessions Total
Sessions per user
Key values
- tad Main User
- 5,415 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 5,415 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 1,924 buffers Checkpoint Peak
- 2026-07-16 13:05:44 Date
- 191.961 seconds Highest write time
- 0.004 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-07-16 16:47:43 Date
Checkpoints distance
Key values
- 27.84 Mo Distance Peak
- 2026-07-16 12:05:40 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 16 07 1,392 138.832s 0.005s 138.846s 08 1,948 193.042s 0.025s 193.111s 09 3,211 318.86s 0.032s 318.938s 10 3,614 358.37s 0.029s 358.468s 11 2,925 291.02s 0.025s 291.095s 12 2,709 269.221s 0.025s 269.292s 13 2,663 263.477s 0.026s 263.548s 14 1,794 177.627s 0.023s 177.719s 15 1,730 171.698s 0.025s 171.771s 16 2,089 207.526s 0.024s 207.613s 17 3,221 320.433s 0.027s 320.511s 18 1,577 156.812s 0.016s 156.855s 19 1,308 130.294s 0.004s 130.308s 20 1,248 124.759s 0.002s 124.765s 21 1,219 121.558s 0.002s 121.564s 22 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 16 07 0 1 0 154 0.002s 0.002s 08 0 1 0 472 0.002s 0.011s 09 0 1 0 803 0.002s 0.012s 10 0 2 0 1,009 0.003s 0.012s 11 0 1 0 693 0.002s 0.012s 12 0 1 0 630 0.002s 0.012s 13 0 1 0 590 0.002s 0.012s 14 0 1 0 427 0.002s 0.012s 15 0 1 0 277 0.002s 0.012s 16 0 1 0 417 0.002s 0.012s 17 0 1 0 600 0.002s 0.012s 18 0 1 0 299 0.003s 0.006s 19 0 1 0 142 0.002s 0.002s 20 0 0 0 131 0.002s 0.001s 21 0 1 0 143 0.002s 0.001s 22 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 16 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 16 07 5,092.00 kB 9,520.00 kB 08 1,219.73 kB 6,150.64 kB 09 1,846.42 kB 6,782.67 kB 10 2,108.67 kB 7,687.58 kB 11 1,752.33 kB 8,380.58 kB 12 1,630.00 kB 8,745.25 kB 13 1,445.67 kB 8,037.83 kB 14 1,128.83 kB 6,564.42 kB 15 1,031.75 kB 6,654.92 kB 16 1,162.00 kB 7,070.50 kB 17 1,858.92 kB 8,312.25 kB 18 2,015.67 kB 8,492.33 kB 19 5,298.00 kB 10,036.50 kB 20 9,934.00 kB 9,934.00 kB 21 9,538.00 kB 9,895.00 kB 22 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 92.05 MiB Temp Files size Peak
- 2026-07-16 21:00:03 Date
Number of temporary files
Key values
- 3 per second Temp Files Peak
- 2026-07-16 15:30:13 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 16 07 0 0 0 08 0 0 0 09 4 53.99 MiB 13.50 MiB 10 0 0 0 11 1 13.50 MiB 13.50 MiB 12 0 0 0 13 0 0 0 14 0 0 0 15 8 193.98 MiB 24.25 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 7 180.54 MiB 25.79 MiB 22 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 5 67.49 MiB 13.49 MiB 13.50 MiB 13.50 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-16 09:26:58 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
2 4 355.65 MiB 87.02 MiB 90.80 MiB 88.91 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-16 15:30:13 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
3 4 3.95 MiB 728.00 KiB 1.26 MiB 1010.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-16 15:30:13 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
4 2 1.43 MiB 728.00 KiB 736.00 KiB 732.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-16 15:30:39 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
5 1 13.50 MiB 13.50 MiB 13.50 MiB 13.50 MiB from fin_payment_scheduledetail fpsd join fin_payment_detail fpd on fpsd.fin_payment_detail_id = fpd.fin_payment_detail_id join fin_payment fp on fpd.fin_payment_id = fp.fin_payment_id join fin_payment_schedule ps on ps.fin_payment_schedule_id = fpsd.fin_payment_schedule_order join c_order co on co.c_order_id = ps.c_order_id where ps.c_order_id = ? and to_number(aprm_seqnumberpaymentstatus (fp.status)) >= ? group by co.grandtotal, ps.outstandingamt, ps.c_order_id;-
from fin_payment_scheduledetail fpsd join fin_payment_detail fpd on fpsd.fin_payment_detail_id = fpd.fin_payment_detail_id join fin_payment fp on fpd.fin_payment_id = fp.fin_payment_id join fin_payment_schedule ps ON ps.fin_payment_schedule_id = fpsd.fin_payment_schedule_order join c_order co on co.c_order_id = ps.c_order_id WHERE ps.c_order_id = $1 and to_number(aprm_seqnumberpaymentstatus (fp.status)) >= 40 group by co.GrandTotal, ps.outstandingamt, ps.c_order_id;
Date: 2026-07-16 09:38:21 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
Queries generating the largest temporary files
Rank Size Query 1 90.80 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-16 21:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2 90.78 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-16 15:30:13 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3 87.05 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-16 21:00:30 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4 87.02 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-16 15:30:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5 13.50 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-16 09:26:58 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
6 13.50 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-16 09:38:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
7 13.50 MiB from fin_payment_scheduledetail fpsd join fin_payment_detail fpd on fpsd.fin_payment_detail_id = fpd.fin_payment_detail_id join fin_payment fp on fpd.fin_payment_id = fp.fin_payment_id join fin_payment_schedule ps ON ps.fin_payment_schedule_id = fpsd.fin_payment_schedule_order join c_order co on co.c_order_id = ps.c_order_id WHERE ps.c_order_id = $1 and to_number(aprm_seqnumberpaymentstatus (fp.status)) >= 40 group by co.GrandTotal, ps.outstandingamt, ps.c_order_id;[ Date: 2026-07-16 09:38:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8 13.50 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-16 11:01:23 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
9 13.50 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-16 15:52:51 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
10 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-16 09:28:45 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
11 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-16 15:30:13 - 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-16 21:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
13 736.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-16 21:00:15 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
14 736.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-16 21:00:28 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
15 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-16 15:30:26 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
16 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-16 15:30:39 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.16 sec Highest CPU-cost vacuum
Table profile.sample_statements
Database etendo - 2026-07-16 13:00:26 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 0.16 sec Highest CPU-cost vacuum
Table profile.sample_statements
Database etendo - 2026-07-16 13:00:26 Date
Analyzes per table
Key values
- public.ad_session (20) Main table analyzed (database etendo)
- 166 analyzes Total
Table Number of analyzes etendo.public.ad_session 20 etendo.profile.last_stat_indexes_srv1 15 etendo.public.ad_ep_instance_para 15 etendo.profile.last_stat_statements_srv1 15 etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.last_stat_tables_srv1 15 etendo.profile.tables_list 10 etendo.profile.last_stat_io 8 etendo.profile.stmt_list 6 etendo.profile.funcs_list 5 etendo.profile.last_stat_activity_count_srv1 4 etendo.profile.indexes_list 4 etendo.profile.last_extension_versions 4 etendo.profile.last_stat_slru 3 etendo.public.ad_preference 3 etendo.profile.sample_stat_tables 2 etendo.profile.sample_stat_indexes 2 etendo.profile.sample_statements 2 etendo.profile.sample_stat_user_functions 2 etendo.profile.sample_stat_io 1 etendo.public.ad_process_run 1 etendo.public.ad_pinstance 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.sample_stat_user_func_total 1 etendo.public.ad_sequence 1 etendo.profile.sample_statements_total 1 etendo.profile.last_stat_cluster 1 etendo.profile.sample_stat_slru 1 etendo.profile.sample_stat_tablespaces 1 etendo.public.ad_process_request 1 etendo.public.m_storage_pending 1 etendo.profile.sample_stat_tables_total 1 etendo.profile.last_stat_wal 1 etendo.profile.sample_stat_database 1 etendo.profile.last_stat_archiver 1 Total 166 Vacuums per table
Key values
- profile.last_stat_tables_srv1 (15) Main table vacuumed on database etendo
- 105 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_tables_srv1 15 15 12,200 0 172 0 0 9,448 173 1,284,171 0 0 etendo.profile.last_stat_statements_srv1 15 15 8,123 0 123 0 0 5,305 126 840,657 0 0 etendo.profile.last_stat_indexes_srv1 15 15 15,497 0 270 0 0 11,367 285 1,810,391 0 0 etendo.profile.last_stat_user_functions_srv1 15 15 2,164 0 43 0 0 1,140 35 244,849 0 0 etendo.public.ad_ep_instance_para 8 8 472 0 40 0 0 56 16 134,336 0 0 etendo.profile.tables_list 7 7 1,083 0 16 0 0 596 8 104,758 1 4 etendo.profile.stmt_list 4 4 1,222 0 38 0 0 823 35 265,010 16 45 etendo.profile.funcs_list 4 4 364 0 18 0 0 112 12 97,806 0 0 etendo.profile.indexes_list 3 3 390 0 12 0 0 112 9 81,188 0 0 etendo.profile.last_stat_io 3 3 237 0 12 0 0 21 6 50,201 0 0 etendo.profile.last_extension_versions 2 2 104 0 10 0 0 10 4 33,004 0 0 etendo.profile.last_stat_database_srv1 2 2 100 0 6 0 0 12 6 39,606 0 0 etendo.pg_toast.pg_toast_2619 2 2 921 0 209 0 0 623 189 455,727 7 16 etendo.profile.last_stat_activity_count_srv1 2 0 42 0 10 0 0 12 4 32,640 0 0 etendo.profile.last_stat_slru 2 2 117 0 9 0 0 10 3 25,563 0 0 etendo.profile.sample_stat_user_functions 1 1 344 0 37 0 0 104 22 112,368 0 0 etendo.profile.sample_stat_user_func_total 1 1 58 0 7 0 0 10 3 18,340 0 0 etendo.profile.last_stat_tablespaces_srv1 1 1 51 0 6 0 0 6 3 24,331 0 0 etendo.profile.sample_stat_indexes 1 1 512 0 89 0 0 191 51 181,852 1 35 etendo.profile.sample_statements 1 1 969 0 269 0 0 583 144 257,254 1 13 etendo.profile.sample_stat_tablespaces 1 1 78 0 7 0 0 11 3 18,098 0 0 Total 105 103 45,048 8 1,403 0 0 30,552 1,137 6,112,150 26 113 Vacuum throughput per table
Key values
- profile.sample_statements (0.16) 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_tables_srv1 0 0 0.15 etendo.profile.last_stat_statements_srv1 0 0 0.07 etendo.profile.last_stat_indexes_srv1 0 0 0.15 etendo.profile.last_stat_user_functions_srv1 0 0 0 etendo.public.ad_ep_instance_para 0 0 0.02 etendo.profile.tables_list 0 0 0 etendo.profile.stmt_list 0 0 0 etendo.profile.funcs_list 0 0 0 etendo.profile.indexes_list 0 0 0 etendo.profile.last_stat_io 0 0 0 etendo.profile.last_extension_versions 0 0 0 etendo.profile.last_stat_database_srv1 0 0 0 etendo.pg_toast.pg_toast_2619 0 0 0.15 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.last_stat_slru 0 0 0 etendo.profile.sample_stat_user_functions 0 0 0.02 etendo.profile.sample_stat_user_func_total 0 0 0.01 etendo.profile.last_stat_tablespaces_srv1 0 0 0 etendo.profile.sample_stat_indexes 0 0 0.05 etendo.profile.sample_statements 0 0 0.16 etendo.profile.sample_stat_tablespaces 0 0 0 Total 0 0 0.78 Tuples removed per table
Key values
- profile.last_stat_indexes_srv1 (70754) Main table with removed tuples on database etendo
- 144067 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,754 34,935 0 0 4,320 etendo.profile.last_stat_tables_srv1 15 15 44,777 20,880 0 0 3,450 etendo.profile.last_stat_statements_srv1 15 15 16,288 14,191 0 176 1,546 etendo.profile.last_stat_user_functions_srv1 15 15 5,426 4,605 0 5 334 etendo.profile.sample_statements 1 1 1,839 9,968 0 0 690 etendo.profile.tables_list 7 7 1,054 5,636 0 0 182 etendo.profile.sample_stat_indexes 1 1 980 8,176 0 0 169 etendo.profile.sample_stat_user_functions 1 1 907 7,066 0 0 80 etendo.pg_toast.pg_toast_2619 2 2 546 2,317 0 0 908 etendo.profile.stmt_list 4 4 431 2,852 0 0 304 etendo.profile.funcs_list 4 4 204 693 0 0 32 etendo.public.ad_ep_instance_para 8 8 144 0 0 8 0 etendo.profile.indexes_list 3 3 124 1,011 0 0 30 etendo.profile.last_extension_versions 2 2 112 16 0 0 2 etendo.profile.last_stat_slru 2 2 110 10 0 0 2 etendo.profile.last_stat_io 3 3 91 39 0 0 6 etendo.profile.sample_stat_user_func_total 1 1 88 336 0 0 4 etendo.profile.sample_stat_tablespaces 1 1 84 336 0 0 4 etendo.profile.last_stat_tablespaces_srv1 1 1 52 2 0 0 1 etendo.profile.last_stat_activity_count_srv1 2 0 48 0 0 2 0 etendo.profile.last_stat_database_srv1 2 2 8 8 0 0 2 Total 105 103 144,067 113,077 0 191 12,066 Pages removed per table
Key values
- profile.last_stat_statements_srv1 (176) Main table with removed pages on database etendo
- 191 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed etendo.profile.last_stat_statements_srv1 15 15 16288 176 etendo.public.ad_ep_instance_para 8 8 144 8 etendo.profile.last_stat_user_functions_srv1 15 15 5426 5 etendo.profile.last_stat_activity_count_srv1 2 0 48 2 etendo.profile.sample_stat_user_functions 1 1 907 0 etendo.profile.tables_list 7 7 1054 0 etendo.profile.stmt_list 4 4 431 0 etendo.profile.sample_stat_user_func_total 1 1 88 0 etendo.profile.last_extension_versions 2 2 112 0 etendo.profile.last_stat_tablespaces_srv1 1 1 52 0 etendo.profile.last_stat_database_srv1 2 2 8 0 etendo.pg_toast.pg_toast_2619 2 2 546 0 etendo.profile.indexes_list 3 3 124 0 etendo.profile.last_stat_tables_srv1 15 15 44777 0 etendo.profile.funcs_list 4 4 204 0 etendo.profile.sample_stat_indexes 1 1 980 0 etendo.profile.last_stat_indexes_srv1 15 15 70754 0 etendo.profile.sample_statements 1 1 1839 0 etendo.profile.last_stat_io 3 3 91 0 etendo.profile.sample_stat_tablespaces 1 1 84 0 etendo.profile.last_stat_slru 2 2 110 0 Total 105 103 144,067 191 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 16 07 8 12 08 6 9 09 9 19 10 7 16 11 8 13 12 4 10 13 11 12 14 6 6 15 5 18 16 7 9 17 8 12 18 9 7 19 6 11 20 7 5 21 4 7 22 0 0 - 0.16 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
- 427,476 Total read queries
- 33,472 Total write queries
Queries by database
Key values
- etendo Main database
- 1,408,871 Requests
- 3m52s (etendo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 1,407,791 Requests
User Request type Count Duration postgres Total 9,660 18s253ms others 2,835 0ms select 1,905 0ms tcl 90 0ms tad Total 1,407,791 3m37s delete 76 0ms insert 2,746 0ms others 480 0ms select 425,571 0ms tcl 27,373 0ms update 3,187 0ms Duration by user
Key values
- 3m37s (tad) Main time consuming user
User Request type Count Duration postgres Total 9,660 18s253ms others 2,835 0ms select 1,905 0ms tcl 90 0ms tad Total 1,407,791 3m37s delete 76 0ms insert 2,746 0ms others 480 0ms select 425,571 0ms tcl 27,373 0ms update 3,187 0ms Queries by host
Key values
- 127.0.0.1 Main host
- 1,407,791 Requests
- 3m37s (127.0.0.1)
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 1,401,431 Requests
- 3m22s (openbravo)
- Main time consuming application
Application Request type Count Duration [unknown] Total 8,415 3s667ms others 2,745 0ms select 1,440 0ms tcl 45 0ms openbravo Total 1,401,431 3m22s delete 76 0ms insert 2,746 0ms select 422,871 0ms tcl 27,373 0ms update 3,187 0ms pg_profile Total 1,185 2s687ms others 90 0ms select 435 0ms tcl 45 0ms psql Total 6,420 27s743ms others 480 0ms select 2,730 0ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-16 18:02:37 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 938,361 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 37 0ms 0ms 0ms select adprocess0_.ad_process_id as ad_proce1_84_0_, adprocess0_.ad_client_id as ad_clien2_84_0_, adprocess0_.ad_org_id as ad_org_i3_84_0_, adprocess0_.isactive as isactive4_84_0_, adprocess0_.created as created5_84_0_, adprocess0_.createdby as createdb6_84_0_, adprocess0_.updated as updated7_84_0_, adprocess0_.updatedby as updatedb8_84_0_, adprocess0_.value as value9_84_0_, adprocess0_.name as name10_84_0_, adprocess0_.description as descrip11_84_0_, adprocess0_.help as help12_84_0_, adprocess0_.accesslevel as accessl13_84_0_, adprocess0_.isuserstartable as isusers14_84_0_, adprocess0_.procedurename as procedu15_84_0_, adprocess0_.isreport as isrepor16_84_0_, adprocess0_.isdirectprint as isdirec17_84_0_, adprocess0_.classname as classna18_84_0_, adprocess0_.isbackground as isbackg19_84_0_, adprocess0_.isjasper as isjaspe20_84_0_, adprocess0_.jrname as jrname21_84_0_, adprocess0_.service_type as service22_84_0_, adprocess0_.isexternalservice as isexter23_84_0_, adprocess0_.service_source as service24_84_0_, adprocess0_.ad_module_id as ad_modu25_84_0_, adprocess0_.uipattern as uipatte26_84_0_, adprocess0_.isadvancedfeature as isadvan27_84_0_, adprocess0_.preventconcurrent as prevent28_84_0_, adprocess0_.is_explicit_access as is_expl29_84_0_, adprocess0_.iskillable as iskilla30_84_0_ from ad_process adprocess0_ where adprocess0_.ad_process_id in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 16 08 3 0ms 0ms 09 10 0ms 0ms 10 7 0ms 0ms 11 3 0ms 0ms 12 3 0ms 0ms 13 5 0ms 0ms 14 2 0ms 0ms 16 1 0ms 0ms 17 2 0ms 0ms 18 1 0ms 0ms 2 0ms 15 0ms 0ms 0ms select concat(?, tab.tablename, ?, count(?), ?) as ad_tree from ad_tree at2 left join ad_table tab on tab.ad_table_id = at2.ad_table_id where at2.ad_table_id is not null group by tab.ad_table_id, at2.ad_client_id having count(?) > ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 16 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 3 0ms 8 0ms 0ms 0ms insert into c_file (ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, name, c_datatype_id, seqno, text, ad_table_id, ad_record_id, c_file_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 16 09 2 0ms 0ms 10 2 0ms 0ms 12 3 0ms 0ms 17 1 0ms 0ms 4 0ms 28 0ms 0ms 0ms select coalesce(( select show_in_header from ad_client_acctdimension where ad_client_id = ? and docbasetype = ? and dimension = ?), c.product_acctdim_header) from ad_client c where c.ad_client_id = ? and c.org_acctdim_isenable = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 16 09 13 0ms 0ms 10 12 0ms 0ms 17 3 0ms 0ms 5 0ms 6,306 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 #5
Day Hour Count Duration Avg duration Jul 16 07 135 0ms 0ms 08 440 0ms 0ms 09 1,113 0ms 0ms 10 905 0ms 0ms 11 559 0ms 0ms 12 598 0ms 0ms 13 516 0ms 0ms 14 304 0ms 0ms 15 250 0ms 0ms 16 363 0ms 0ms 17 550 0ms 0ms 18 203 0ms 0ms 19 122 0ms 0ms 20 122 0ms 0ms 21 122 0ms 0ms 22 4 0ms 0ms 6 0ms 197 0ms 0ms 0ms select adpreferen0_.ad_preference_id as ad_prefe1_83_, adpreferen0_.ad_client_id as ad_clien2_83_, adpreferen0_.ad_org_id as ad_org_i3_83_, adpreferen0_.isactive as isactive4_83_, adpreferen0_.created as created5_83_, adpreferen0_.createdby as createdb6_83_, adpreferen0_.updated as updated7_83_, adpreferen0_.updatedby as updatedb8_83_, adpreferen0_.ad_window_id as ad_windo9_83_, adpreferen0_.ad_user_id as ad_user10_83_, adpreferen0_.attribute as attribu11_83_, adpreferen0_.value as value12_83_, adpreferen0_.property as propert13_83_, adpreferen0_.ispropertylist as isprope14_83_, adpreferen0_.visibleat_client_id as visible15_83_, adpreferen0_.visibleat_org_id as visible16_83_, adpreferen0_.visibleat_role_id as visible17_83_, adpreferen0_.selected as selecte18_83_, adpreferen0_.ad_module_id as ad_modu19_83_, adpreferen0_.inherited_from as inherit20_83_ from ad_preference adpreferen0_ where adpreferen0_.visibleat_client_id = ? and adpreferen0_.visibleat_org_id = ? and adpreferen0_.ad_user_id = ? and adpreferen0_.visibleat_role_id = ? and (adpreferen0_.ad_window_id is null) and adpreferen0_.ispropertylist = ? and adpreferen0_.property = ? and (adpreferen0_.ad_org_id in (...)) and (adpreferen0_.ad_client_id in (...)) and adpreferen0_.isactive = ? order by adpreferen0_.ad_preference_id;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 16 08 14 0ms 0ms 09 55 0ms 0ms 10 32 0ms 0ms 11 32 0ms 0ms 12 10 0ms 0ms 13 6 0ms 0ms 14 12 0ms 0ms 15 8 0ms 0ms 16 12 0ms 0ms 17 14 0ms 0ms 18 2 0ms 0ms 7 0ms 458 0ms 0ms 0ms select name, gaap, isaccrual, costingmethod, c_currency_id, hasalias, istradediscountposted, isdiscountcorrectstax, ad_client_id, ? as usesuspensebalancing, ? as suspensebalancing_acct, ? as usesuspenseerror, ? as suspenseerror_acct, ? as usecurrencybalancing, ? as currencybalancing_acct, ? as retainedearning_acct, ? as incomesummary_acct, ? as intercompanydueto_acct, ? as intercompanyduefrom_acct, ? as c_acctschema_id from c_acctschema where c_acctschema_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 16 08 18 0ms 0ms 09 34 0ms 0ms 10 58 0ms 0ms 11 42 0ms 0ms 12 46 0ms 0ms 13 56 0ms 0ms 14 24 0ms 0ms 15 18 0ms 0ms 16 30 0ms 0ms 17 36 0ms 0ms 18 24 0ms 0ms 19 18 0ms 0ms 20 18 0ms 0ms 21 18 0ms 0ms 22 18 0ms 0ms 8 0ms 17 0ms 0ms 0ms select this_.obuiapp_navbar_component_id as obuiapp_1_613_0_, this_.ad_client_id as ad_clien2_613_0_, this_.ad_org_id as ad_org_i3_613_0_, this_.ad_module_id as ad_modul4_613_0_, this_.obclker_template_id as obclker_5_613_0_, this_.name as name6_613_0_, this_.description as descript7_613_0_, this_.classname as classnam8_613_0_, this_.allroles as allroles9_613_0_, this_.sortno as sortno10_613_0_, this_.isactive as isactiv11_613_0_, this_.created as created12_613_0_, this_.createdby as created13_613_0_, this_.updated as updated14_613_0_, this_.updatedby as updated15_613_0_, this_.isstaticcomponent as isstati16_613_0_ from obuiapp_navbar_component this_ where this_.ad_org_id in (...) and this_.ad_client_id in (...) and this_.isactive = ? order by this_.sortno asc;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 16 07 1 0ms 0ms 08 2 0ms 0ms 09 3 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 2 0ms 0ms 13 4 0ms 0ms 15 3 0ms 0ms 9 0ms 2 0ms 0ms 0ms update c_order set updated = ?, description = ? where c_order_id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 16 09 1 0ms 0ms 10 1 0ms 0ms 10 0ms 19 0ms 0ms 0ms insert into rem_remittanceline (ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, rem_remittance_id, line, fin_payment_scheduledetail_id, amount, rem_remittanceline_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 16 11 14 0ms 0ms 12 5 0ms 0ms 11 0ms 6 0ms 0ms 0ms select admodelimp0_.ad_model_object_id as ad_model9_58_1_, admodelimp0_.ad_model_object_mapping_id as ad_model1_58_1_, admodelimp0_.ad_model_object_mapping_id as ad_model1_58_0_, admodelimp0_.ad_client_id as ad_clien2_58_0_, admodelimp0_.ad_org_id as ad_org_i3_58_0_, admodelimp0_.isactive as isactive4_58_0_, admodelimp0_.created as created5_58_0_, admodelimp0_.createdby as createdb6_58_0_, admodelimp0_.updated as updated7_58_0_, admodelimp0_.updatedby as updatedb8_58_0_, admodelimp0_.ad_model_object_id as ad_model9_58_0_, admodelimp0_.mappingname as mapping10_58_0_, admodelimp0_.isdefault as isdefau11_58_0_ from ad_model_object_mapping admodelimp0_ where admodelimp0_.ad_model_object_id = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 16 10 4 0ms 0ms 16 2 0ms 0ms 12 0ms 12 0ms 0ms 0ms select paymentrule, c_paymentterm_id, invoicerule, deliveryrule, deliveryviarule, paymentrulepo, po_paymentterm_id from c_bpartner where c_bpartner_id = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 16 08 1 0ms 0ms 09 4 0ms 0ms 10 1 0ms 0ms 11 2 0ms 0ms 12 1 0ms 0ms 14 2 0ms 0ms 18 1 0ms 0ms 13 0ms 2 0ms 0ms 0ms select aduser0_.ad_user_id as ad_user_1_129_, aduser0_.ad_client_id as ad_clien2_129_, aduser0_.ad_org_id as ad_org_i3_129_, aduser0_.isactive as isactive4_129_, aduser0_.created as created5_129_, aduser0_.createdby as createdb6_129_, aduser0_.updated as updated7_129_, aduser0_.updatedby as updatedb8_129_, aduser0_.name as name9_129_, aduser0_.description as descrip10_129_, aduser0_.password as passwor11_129_, aduser0_.email as email12_129_, aduser0_.supervisor_id as supervi13_129_, aduser0_.c_bpartner_id as c_bpart14_129_, aduser0_.processing as process15_129_, aduser0_.emailuser as emailus16_129_, aduser0_.emailuserpw as emailus17_129_, aduser0_.c_bpartner_location_id as c_bpart18_129_, aduser0_.c_greeting_id as c_greet19_129_, aduser0_.title as title20_129_, aduser0_.comments as comment21_129_, aduser0_.phone as phone22_129_, aduser0_.phone2 as phone23_129_, aduser0_.fax as fax24_129_, aduser0_.lastcontact as lastcon25_129_, aduser0_.lastresult as lastres26_129_, aduser0_.birthday as birthda27_129_, aduser0_.ad_orgtrx_id as ad_orgt28_129_, aduser0_.firstname as firstna29_129_, aduser0_.lastname as lastnam30_129_, aduser0_.username as usernam31_129_, aduser0_.default_ad_client_id as default32_129_, aduser0_.default_ad_language as default33_129_, aduser0_.default_ad_org_id as default34_129_, aduser0_.default_ad_role_id as default35_129_, aduser0_.default_m_warehouse_id as default36_129_, aduser0_.islocked as islocke37_129_, aduser0_.ad_image_id as ad_imag38_129_, aduser0_.grant_portal_access as grant_p39_129_, aduser0_.lastpasswordupdate as lastpas40_129_, aduser0_.isexpiredpassword as isexpir41_129_, aduser0_.commercialauth as commerc42_129_, aduser0_.viasms as viasms43_129_, aduser0_.viaemail as viaemai44_129_, aduser0_.em_smfsws_default_ws_role_id as em_smfs45_129_ from ad_user aduser0_ where exists ( select ? from c_order order1_ inner join ad_user aduser2_ on order1_.salesrep_id = aduser2_.ad_user_id cross join c_doctype documentty3_ where order1_.c_doctypetarget_id = documentty3_.c_doctype_id and order1_.issotrx = ? and documentty3_.isreturn = ? and (documentty3_.docsubtypeso not like ?) and aduser2_.ad_user_id = aduser0_.ad_user_id and (order1_.ad_org_id in (...)) and (order1_.ad_client_id in (...))) order by aduser0_.name limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 16 10 2 0ms 0ms 14 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(?), null, to_number(null), null, null, ?, null, null, null, null, null, null, null, null, null, ? ? a1040716ab4785a18a89f1f0891b5e ? ? ? fat ? ? b91058cda84385b78306b7f419f056 ? n ');Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 16 12 1 0ms 0ms 15 0ms 1 0ms 0ms 0ms update c_order set updated = ?, updatedby = ?, em_opxmp_disenador_id = ?, em_opxmp_estado = ? where c_order_id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 16 10 1 0ms 0ms 16 0ms 3 0ms 0ms 0ms insert into c_invoice (ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processing, processed, posted, c_doctype_id, c_doctypetarget_id, c_order_id, isprinted, dateinvoiced, dateacct, c_bpartner_id, c_bpartner_location_id, poreference, isdiscountprinted, dateordered, c_currency_id, c_paymentterm_id, m_pricelist_id, istaxincluded, createfrom, generateto, copyfrom, isselfservice, ispaid, em_einv_generated, totalpaid, em_einv_sent, outstandingamt, daystilldue, dueamt, fin_paymentmethod_id, calculate_promotions, em_aprm_addpayment, iscashvat, em_aprm_processinvoice, prepaymentamt, createfromorders, createfrominouts, paidamtatinvoicing, em_opxcld_createlines, c_invoice_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 16 09 2 0ms 0ms 12 1 0ms 0ms 17 0ms 26 0ms 0ms 0ms select admodule0_.ad_module_id as ad_modul1_60_0_, admodule0_.ad_client_id as ad_clien2_60_0_, admodule0_.ad_org_id as ad_org_i3_60_0_, admodule0_.isactive as isactive4_60_0_, admodule0_.created as created5_60_0_, admodule0_.createdby as createdb6_60_0_, admodule0_.updated as updated7_60_0_, admodule0_.updatedby as updatedb8_60_0_, admodule0_.name as name9_60_0_, admodule0_.version as version10_60_0_, admodule0_.description as descrip11_60_0_, admodule0_.help as help12_60_0_, admodule0_.url as url13_60_0_, admodule0_.type as type14_60_0_, admodule0_.license as license15_60_0_, admodule0_.isindevelopment as isindev16_60_0_, admodule0_.isdefault as isdefau17_60_0_, admodule0_.seqno as seqno18_60_0_, admodule0_.javapackage as javapac19_60_0_, admodule0_.licensetype as license20_60_0_, admodule0_.author as author21_60_0_, admodule0_.status as status22_60_0_, admodule0_.update_available as update_23_60_0_, admodule0_.istranslationrequired as istrans24_60_0_, admodule0_.ad_language as ad_lang25_60_0_, admodule0_.haschartofaccounts as haschar26_60_0_, admodule0_.istranslationmodule as istrans27_60_0_, admodule0_.hasreferencedata as hasrefe28_60_0_, admodule0_.isregistered as isregis29_60_0_, admodule0_.updateinfo as updatei30_60_0_, admodule0_.update_ver_id as update_31_60_0_, admodule0_.referencedatainfo as referen32_60_0_, admodule0_.version_label as version33_60_0_, admodule0_.iscommercial as iscomme34_60_0_, admodule0_.maturity_update as maturit35_60_0_, admodule0_.enabled as enabled36_60_0_, admodule0_.isconfigscriptapplied as isconfi37_60_0_, admodule0_.upgrade_available as upgrade38_60_0_, admodule0_.istrialallowed as istrial39_60_0_ from ad_module admodule0_ where admodule0_.ad_module_id in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 16 07 1 0ms 0ms 08 2 0ms 0ms 09 8 0ms 0ms 10 1 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 6 0ms 0ms 15 4 0ms 0ms 18 0ms 9 0ms 0ms 0ms select invoicedis0_.c_invoice_discount_id as c_invoic1_232_0_, invoicedis0_.ad_client_id as ad_clien2_232_0_, invoicedis0_.ad_org_id as ad_org_i3_232_0_, invoicedis0_.isactive as isactive4_232_0_, invoicedis0_.created as created5_232_0_, invoicedis0_.createdby as createdb6_232_0_, invoicedis0_.updated as updated7_232_0_, invoicedis0_.updatedby as updatedb8_232_0_, invoicedis0_.c_invoice_id as c_invoic9_232_0_, invoicedis0_.c_discount_id as c_disco10_232_0_, invoicedis0_.line as line11_232_0_, invoicedis0_.cascade as cascade12_232_0_ from c_invoice_discount invoicedis0_ where invoicedis0_.c_invoice_discount_id = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 16 10 1 0ms 0ms 11 1 0ms 0ms 16 3 0ms 0ms 17 4 0ms 0ms 19 0ms 37 0ms 0ms 0ms select fin_paymentmethod.name as paymentmethod, c_paymentterm.name as paymentterm, c_order.grandtotal as total from c_tax join c_ordertax on c_tax.c_tax_id = c_ordertax.c_tax_id join c_order on c_order.c_order_id = c_ordertax.c_order_id join c_orderline on c_orderline.c_order_id = c_order.c_order_id join c_paymentterm on c_order.c_paymentterm_id = c_paymentterm.c_paymentterm_id join fin_paymentmethod on c_order.fin_paymentmethod_id = fin_paymentmethod.fin_paymentmethod_id where c_ordertax.c_order_id = ? and c_ordertax.c_tax_id = c_tax.c_tax_id group by c_order.c_order_id, fin_paymentmethod.name, c_paymentterm.name, c_order.grandtotal order by c_order.c_order_id;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 16 08 9 0ms 0ms 09 6 0ms 0ms 10 3 0ms 0ms 11 3 0ms 0ms 12 2 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 2 0ms 0ms 16 4 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 20 0ms 20 0ms 0ms 0ms select m_attributeset_id from m_product where m_product_id = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 16 08 1 0ms 0ms 09 6 0ms 0ms 10 5 0ms 0ms 11 4 0ms 0ms 12 1 0ms 0ms 14 2 0ms 0ms 18 1 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 229,202 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 16 08 15,453 0ms 0ms 09 59,935 0ms 0ms 10 42,258 0ms 0ms 11 18,286 0ms 0ms 12 21,269 0ms 0ms 13 20,276 0ms 0ms 14 8,286 0ms 0ms 15 4,054 0ms 0ms 16 14,936 0ms 0ms 17 19,468 0ms 0ms 18 4,981 0ms 0ms 2 22,761 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 #2
Day Hour Count Duration Avg duration Jul 16 07 1,464 0ms 0ms 08 1,491 0ms 0ms 09 1,602 0ms 0ms 10 1,598 0ms 0ms 11 1,570 0ms 0ms 12 1,650 0ms 0ms 13 1,560 0ms 0ms 14 1,473 0ms 0ms 15 1,535 0ms 0ms 16 1,505 0ms 0ms 17 1,491 0ms 0ms 18 1,466 0ms 0ms 19 1,449 0ms 0ms 20 1,449 0ms 0ms 21 1,449 0ms 0ms 22 9 0ms 0ms 3 15,998 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 #3
Day Hour Count Duration Avg duration Jul 16 08 944 0ms 0ms 09 4,020 0ms 0ms 10 3,122 0ms 0ms 11 1,134 0ms 0ms 12 1,490 0ms 0ms 13 1,380 0ms 0ms 14 526 0ms 0ms 15 284 0ms 0ms 16 1,268 0ms 0ms 17 1,518 0ms 0ms 18 312 0ms 0ms 4 13,687 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 16 07 217 0ms 0ms 08 929 0ms 0ms 09 2,200 0ms 0ms 10 2,014 0ms 0ms 11 1,646 0ms 0ms 12 1,446 0ms 0ms 13 1,178 0ms 0ms 14 882 0ms 0ms 15 560 0ms 0ms 16 755 0ms 0ms 17 918 0ms 0ms 18 374 0ms 0ms 19 188 0ms 0ms 20 188 0ms 0ms 21 189 0ms 0ms 22 3 0ms 0ms 5 13,665 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 16 07 220 0ms 0ms 08 922 0ms 0ms 09 2,187 0ms 0ms 10 2,013 0ms 0ms 11 1,640 0ms 0ms 12 1,446 0ms 0ms 13 1,176 0ms 0ms 14 879 0ms 0ms 15 560 0ms 0ms 16 751 0ms 0ms 17 920 0ms 0ms 18 375 0ms 0ms 19 191 0ms 0ms 20 191 0ms 0ms 21 192 0ms 0ms 22 2 0ms 0ms 6 7,999 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 16 08 472 0ms 0ms 09 2,010 0ms 0ms 10 1,561 0ms 0ms 11 567 0ms 0ms 12 745 0ms 0ms 13 690 0ms 0ms 14 263 0ms 0ms 15 142 0ms 0ms 16 634 0ms 0ms 17 759 0ms 0ms 18 156 0ms 0ms 7 7,456 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 16 07 12 0ms 0ms 08 500 0ms 0ms 09 1,554 0ms 0ms 10 1,281 0ms 0ms 11 986 0ms 0ms 12 821 0ms 0ms 13 621 0ms 0ms 14 415 0ms 0ms 15 198 0ms 0ms 16 394 0ms 0ms 17 549 0ms 0ms 18 125 0ms 0ms 8 6,306 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 16 07 135 0ms 0ms 08 440 0ms 0ms 09 1,113 0ms 0ms 10 905 0ms 0ms 11 559 0ms 0ms 12 598 0ms 0ms 13 516 0ms 0ms 14 304 0ms 0ms 15 250 0ms 0ms 16 363 0ms 0ms 17 550 0ms 0ms 18 203 0ms 0ms 19 122 0ms 0ms 20 122 0ms 0ms 21 122 0ms 0ms 22 4 0ms 0ms 9 5,194 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 16 07 4 0ms 0ms 08 337 0ms 0ms 09 1,246 0ms 0ms 10 920 0ms 0ms 11 639 0ms 0ms 12 528 0ms 0ms 13 400 0ms 0ms 14 242 0ms 0ms 15 72 0ms 0ms 16 261 0ms 0ms 17 442 0ms 0ms 18 103 0ms 0ms 10 3,170 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 #10
Day Hour Count Duration Avg duration Jul 16 07 125 0ms 0ms 08 216 0ms 0ms 09 443 0ms 0ms 10 372 0ms 0ms 11 256 0ms 0ms 12 244 0ms 0ms 13 249 0ms 0ms 14 177 0ms 0ms 15 153 0ms 0ms 16 200 0ms 0ms 17 231 0ms 0ms 18 143 0ms 0ms 19 120 0ms 0ms 20 120 0ms 0ms 21 121 0ms 0ms 11 2,736 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 #11
Day Hour Count Duration Avg duration Jul 16 07 122 0ms 0ms 08 185 0ms 0ms 09 343 0ms 0ms 10 282 0ms 0ms 11 206 0ms 0ms 12 227 0ms 0ms 13 204 0ms 0ms 14 156 0ms 0ms 15 131 0ms 0ms 16 184 0ms 0ms 17 203 0ms 0ms 18 133 0ms 0ms 19 120 0ms 0ms 20 120 0ms 0ms 21 120 0ms 0ms 12 2,689 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 #12
Day Hour Count Duration Avg duration Jul 16 07 2 0ms 0ms 08 178 0ms 0ms 09 636 0ms 0ms 10 469 0ms 0ms 11 338 0ms 0ms 12 280 0ms 0ms 13 205 0ms 0ms 14 124 0ms 0ms 15 37 0ms 0ms 16 141 0ms 0ms 17 227 0ms 0ms 18 52 0ms 0ms 13 2,682 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 16 09 524 0ms 0ms 10 1,029 0ms 0ms 12 786 0ms 0ms 13 343 0ms 0ms 14 2,659 0ms 0ms 0ms 0ms select businesspa0_.c_bpartner_id as c_bpartn1_172_0_, businesspa0_.ad_client_id as ad_clien2_172_0_, businesspa0_.ad_org_id as ad_org_i3_172_0_, businesspa0_.isactive as isactive4_172_0_, businesspa0_.created as created5_172_0_, businesspa0_.createdby as createdb6_172_0_, businesspa0_.updated as updated7_172_0_, businesspa0_.updatedby as updatedb8_172_0_, businesspa0_.value as value9_172_0_, businesspa0_.name as name10_172_0_, businesspa0_.name2 as name11_172_0_, businesspa0_.description as descrip12_172_0_, businesspa0_.issummary as issumma13_172_0_, businesspa0_.c_bp_group_id as c_bp_gr14_172_0_, businesspa0_.isonetime as isoneti15_172_0_, businesspa0_.isprospect as isprosp16_172_0_, businesspa0_.isvendor as isvendo17_172_0_, businesspa0_.iscustomer as iscusto18_172_0_, businesspa0_.isemployee as isemplo19_172_0_, businesspa0_.issalesrep as issales20_172_0_, businesspa0_.referenceno as referen21_172_0_, businesspa0_.duns as duns22_172_0_, businesspa0_.url as url23_172_0_, businesspa0_.ad_language as ad_lang24_172_0_, businesspa0_.taxid as taxid25_172_0_, businesspa0_.istaxexempt as istaxex26_172_0_, businesspa0_.c_invoiceschedule_id as c_invoi27_172_0_, businesspa0_.rating as rating28_172_0_, businesspa0_.salesvolume as salesvo29_172_0_, businesspa0_.numberemployees as numbere30_172_0_, businesspa0_.naics as naics31_172_0_, businesspa0_.firstsale as firstsa32_172_0_, businesspa0_.acqusitioncost as acqusit33_172_0_, businesspa0_.potentiallifetimevalue as potenti34_172_0_, businesspa0_.actuallifetimevalue as actuall35_172_0_, businesspa0_.shareofcustomer as shareof36_172_0_, businesspa0_.paymentrule as payment37_172_0_, businesspa0_.so_creditlimit as so_cred38_172_0_, businesspa0_.so_creditused as so_cred39_172_0_, businesspa0_.c_paymentterm_id as c_payme40_172_0_, businesspa0_.m_pricelist_id as m_price41_172_0_, businesspa0_.isdiscountprinted as isdisco42_172_0_, businesspa0_.so_description as so_desc43_172_0_, businesspa0_.poreference as porefer44_172_0_, businesspa0_.paymentrulepo as payment45_172_0_, businesspa0_.po_pricelist_id as po_pric46_172_0_, businesspa0_.po_paymentterm_id as po_paym47_172_0_, businesspa0_.documentcopies as documen48_172_0_, businesspa0_.c_greeting_id as c_greet49_172_0_, businesspa0_.invoicerule as invoice50_172_0_, businesspa0_.deliveryrule as deliver51_172_0_, businesspa0_.deliveryviarule as deliver52_172_0_, businesspa0_.salesrep_id as salesre53_172_0_, businesspa0_.bpartner_parent_id as bpartne54_172_0_, businesspa0_.socreditstatus as socredi55_172_0_, businesspa0_.ad_forced_org_id as ad_forc56_172_0_, businesspa0_.showpriceinorder as showpri57_172_0_, businesspa0_.invoicegrouping as invoice58_172_0_, businesspa0_.fixmonthday as fixmont59_172_0_, businesspa0_.fixmonthday2 as fixmont60_172_0_, businesspa0_.fixmonthday3 as fixmont61_172_0_, businesspa0_.isworker as isworke62_172_0_, businesspa0_.upc as upc63_172_0_, businesspa0_.c_salary_category_id as c_salar64_172_0_, businesspa0_.invoice_printformat as invoice65_172_0_, businesspa0_.last_days as last_da66_172_0_, businesspa0_.po_bankaccount_id as po_bank67_172_0_, businesspa0_.po_bp_taxcategory_id as po_bp_t68_172_0_, businesspa0_.po_fixmonthday as po_fixm69_172_0_, businesspa0_.po_fixmonthday2 as po_fixm70_172_0_, businesspa0_.po_fixmonthday3 as po_fixm71_172_0_, businesspa0_.so_bankaccount_id as so_bank72_172_0_, businesspa0_.so_bp_taxcategory_id as so_bp_t73_172_0_, businesspa0_.fiscalcode as fiscalc74_172_0_, businesspa0_.isofiscalcode as isofisc75_172_0_, businesspa0_.em_einv_einvoice as em_einv76_172_0_, businesspa0_.po_c_incoterms_id as po_c_in77_172_0_, businesspa0_.em_einv_format_id as em_einv78_172_0_, businesspa0_.so_c_incoterms_id as so_c_in79_172_0_, businesspa0_.em_einv_platform_id as em_einv80_172_0_, businesspa0_.fin_paymentmethod_id as fin_pay81_172_0_, businesspa0_.em_einv_email as em_einv82_172_0_, businesspa0_.po_paymentmethod_id as po_paym83_172_0_, businesspa0_.fin_financial_account_id as fin_fin84_172_0_, businesspa0_.em_einv_deliverymode as em_einv85_172_0_, businesspa0_.po_financial_account_id as po_fina86_172_0_, businesspa0_.customer_blocking as custome87_172_0_, businesspa0_.vendor_blocking as vendor_88_172_0_, businesspa0_.so_payment_blocking as so_paym89_172_0_, businesspa0_.po_payment_blocking as po_paym90_172_0_, businesspa0_.so_invoice_blocking as so_invo91_172_0_, businesspa0_.po_invoice_blocking as po_invo92_172_0_, businesspa0_.so_order_blocking as so_orde93_172_0_, businesspa0_.po_order_blocking as po_orde94_172_0_, businesspa0_.so_goods_blocking as so_good95_172_0_, businesspa0_.po_goods_blocking as po_good96_172_0_, businesspa0_.iscashvat as iscashv97_172_0_, businesspa0_.update_currency as update_98_172_0_, businesspa0_.bp_currency_id as bp_curr99_172_0_, businesspa0_.birthplace as birthp100_172_0_, businesspa0_.birthday as birthd101_172_0_, businesspa0_.is_customer_consent as is_cus102_172_0_, businesspa0_.em_obsepad_mandate_identifier as em_obs103_172_0_, businesspa0_.em_obsepad_mandate_date as em_obs104_172_0_, businesspa0_.em_obtik_tax_id_key as em_obt105_172_0_ from c_bpartner businesspa0_ where businesspa0_.c_bpartner_id in (...);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 16 07 9 0ms 0ms 08 203 0ms 0ms 09 642 0ms 0ms 10 421 0ms 0ms 11 265 0ms 0ms 12 282 0ms 0ms 13 235 0ms 0ms 14 131 0ms 0ms 15 66 0ms 0ms 16 144 0ms 0ms 17 205 0ms 0ms 18 56 0ms 0ms 15 2,533 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 16 07 2 0ms 0ms 08 175 0ms 0ms 09 589 0ms 0ms 10 462 0ms 0ms 11 258 0ms 0ms 12 257 0ms 0ms 13 229 0ms 0ms 14 114 0ms 0ms 15 51 0ms 0ms 16 117 0ms 0ms 17 231 0ms 0ms 18 48 0ms 0ms 16 2,520 0ms 0ms 0ms 0ms select admodule0_.ad_module_id as ad_modul1_60_0_, admodule0_.ad_client_id as ad_clien2_60_0_, admodule0_.ad_org_id as ad_org_i3_60_0_, admodule0_.isactive as isactive4_60_0_, admodule0_.created as created5_60_0_, admodule0_.createdby as createdb6_60_0_, admodule0_.updated as updated7_60_0_, admodule0_.updatedby as updatedb8_60_0_, admodule0_.name as name9_60_0_, admodule0_.version as version10_60_0_, admodule0_.description as descrip11_60_0_, admodule0_.help as help12_60_0_, admodule0_.url as url13_60_0_, admodule0_.type as type14_60_0_, admodule0_.license as license15_60_0_, admodule0_.isindevelopment as isindev16_60_0_, admodule0_.isdefault as isdefau17_60_0_, admodule0_.seqno as seqno18_60_0_, admodule0_.javapackage as javapac19_60_0_, admodule0_.licensetype as license20_60_0_, admodule0_.author as author21_60_0_, admodule0_.status as status22_60_0_, admodule0_.update_available as update_23_60_0_, admodule0_.istranslationrequired as istrans24_60_0_, admodule0_.ad_language as ad_lang25_60_0_, admodule0_.haschartofaccounts as haschar26_60_0_, admodule0_.istranslationmodule as istrans27_60_0_, admodule0_.hasreferencedata as hasrefe28_60_0_, admodule0_.isregistered as isregis29_60_0_, admodule0_.updateinfo as updatei30_60_0_, admodule0_.update_ver_id as update_31_60_0_, admodule0_.referencedatainfo as referen32_60_0_, admodule0_.version_label as version33_60_0_, admodule0_.iscommercial as iscomme34_60_0_, admodule0_.maturity_update as maturit35_60_0_, admodule0_.enabled as enabled36_60_0_, admodule0_.isconfigscriptapplied as isconfi37_60_0_, admodule0_.upgrade_available as upgrade38_60_0_, admodule0_.istrialallowed as istrial39_60_0_ from ad_module admodule0_ where admodule0_.ad_module_id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 16 07 155 0ms 0ms 08 310 0ms 0ms 09 426 0ms 0ms 10 155 0ms 0ms 11 157 0ms 0ms 12 310 0ms 0ms 13 542 0ms 0ms 15 465 0ms 0ms 17 2,492 0ms 0ms 0ms 0ms select order0_.c_order_id as c_order_1_246_0_, order0_.ad_client_id as ad_clien2_246_0_, order0_.ad_org_id as ad_org_i3_246_0_, order0_.isactive as isactive4_246_0_, order0_.created as created5_246_0_, order0_.createdby as createdb6_246_0_, order0_.updated as updated7_246_0_, order0_.updatedby as updatedb8_246_0_, order0_.issotrx as issotrx9_246_0_, order0_.documentno as documen10_246_0_, order0_.docstatus as docstat11_246_0_, order0_.docaction as docacti12_246_0_, order0_.processing as process13_246_0_, order0_.processed as process14_246_0_, order0_.c_doctype_id as c_docty15_246_0_, order0_.c_doctypetarget_id as c_docty16_246_0_, order0_.description as descrip17_246_0_, order0_.isdelivered as isdeliv18_246_0_, order0_.isinvoiced as isinvoi19_246_0_, order0_.isprinted as isprint20_246_0_, order0_.isselected as isselec21_246_0_, order0_.salesrep_id as salesre22_246_0_, order0_.dateordered as dateord23_246_0_, order0_.datepromised as datepro24_246_0_, order0_.dateprinted as datepri25_246_0_, order0_.dateacct as dateacc26_246_0_, order0_.c_bpartner_id as c_bpart27_246_0_, order0_.billto_id as billto_28_246_0_, order0_.c_bpartner_location_id as c_bpart29_246_0_, order0_.poreference as porefer30_246_0_, order0_.isdiscountprinted as isdisco31_246_0_, order0_.c_currency_id as c_curre32_246_0_, order0_.paymentrule as payment33_246_0_, order0_.c_paymentterm_id as c_payme34_246_0_, order0_.invoicerule as invoice35_246_0_, order0_.deliveryrule as deliver36_246_0_, order0_.freightcostrule as freight37_246_0_, order0_.freightamt as freight38_246_0_, order0_.deliveryviarule as deliver39_246_0_, order0_.m_shipper_id as m_shipp40_246_0_, order0_.c_charge_id as c_charg41_246_0_, order0_.chargeamt as chargea42_246_0_, order0_.priorityrule as priorit43_246_0_, order0_.totallines as totalli44_246_0_, order0_.grandtotal as grandto45_246_0_, order0_.m_warehouse_id as m_wareh46_246_0_, order0_.m_pricelist_id as m_price47_246_0_, order0_.istaxincluded as istaxin48_246_0_, order0_.c_campaign_id as c_campa49_246_0_, order0_.c_project_id as c_proje50_246_0_, order0_.c_activity_id as c_activ51_246_0_, order0_.posted as posted52_246_0_, order0_.ad_user_id as ad_user53_246_0_, order0_.copyfrom as copyfro54_246_0_, order0_.dropship_bpartner_id as dropshi55_246_0_, order0_.dropship_location_id as dropshi56_246_0_, order0_.dropship_user_id as dropshi57_246_0_, order0_.isselfservice as isselfs58_246_0_, order0_.ad_orgtrx_id as ad_orgt59_246_0_, order0_.user1_id as user60_246_0_, order0_.user2_id as user61_246_0_, order0_.deliverynotes as deliver62_246_0_, order0_.c_incoterms_id as c_incot63_246_0_, order0_.incotermsdescription as incoter64_246_0_, order0_.generatetemplate as generat65_246_0_, order0_.delivery_location_id as deliver66_246_0_, order0_.copyfrompo as copyfro67_246_0_, order0_.fin_paymentmethod_id as fin_pay68_246_0_, order0_.fin_payment_priority_id as fin_pay69_246_0_, order0_.rm_pickfromshipment as rm_pick70_246_0_, order0_.rm_receivematerials as rm_rece71_246_0_, order0_.rm_createinvoice as rm_crea72_246_0_, order0_.c_return_reason_id as c_retur73_246_0_, order0_.rm_addorphanline as rm_addo74_246_0_, order0_.a_asset_id as a_asset75_246_0_, order0_.calculate_promotions as calcula76_246_0_, order0_.c_costcenter_id as c_costc77_246_0_, order0_.convertquotation as convert78_246_0_, order0_.c_reject_reason_id as c_rejec79_246_0_, order0_.validuntil as validun80_246_0_, order0_.quotation_id as quotati81_246_0_, order0_.so_res_status as so_res_82_246_0_, order0_.create_polines as create_83_246_0_, order0_.iscashvat as iscashv84_246_0_, order0_.em_opxmp_buttonpo as em_opxm85_246_0_, order0_.rm_pickfromreceipt as rm_pick86_246_0_, order0_.cancelandreplace as cancela87_246_0_, order0_.em_aprm_addpayment as em_aprm88_246_0_, order0_.em_opxmp_envdirecto as em_opxm89_246_0_, order0_.em_opxmp_disenador_id as em_opxm90_246_0_, order0_.em_opxmp_estado as em_opxm91_246_0_, order0_.em_opxmp_buttonpv as em_opxm92_246_0_, order0_.em_opxmp_buttonmail as em_opxm93_246_0_, order0_.em_mp_infpvint as em_mp_i94_246_0_, order0_.confirmcancelandreplace as confirm95_246_0_, order0_.cancelledorder_id as cancell96_246_0_, order0_.replacedorder_id as replace97_246_0_, order0_.iscancelled as iscance98_246_0_, order0_.replacementorder_id as replace99_246_0_, order0_.bpartner_extref as bpartn100_246_0_ from c_order order0_ where order0_.c_order_id = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 16 08 180 0ms 0ms 09 672 0ms 0ms 10 507 0ms 0ms 11 193 0ms 0ms 12 208 0ms 0ms 13 243 0ms 0ms 14 108 0ms 0ms 15 46 0ms 0ms 16 89 0ms 0ms 17 193 0ms 0ms 18 53 0ms 0ms 18 2,295 0ms 0ms 0ms 0ms select ? from dual;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 16 07 121 0ms 0ms 08 159 0ms 0ms 09 202 0ms 0ms 10 196 0ms 0ms 11 175 0ms 0ms 12 174 0ms 0ms 13 163 0ms 0ms 14 160 0ms 0ms 15 139 0ms 0ms 16 156 0ms 0ms 17 157 0ms 0ms 18 129 0ms 0ms 19 120 0ms 0ms 20 120 0ms 0ms 21 122 0ms 0ms 22 2 0ms 0ms 19 2,192 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 #19
Day Hour Count Duration Avg duration Jul 16 07 4 0ms 0ms 08 154 0ms 0ms 09 484 0ms 0ms 10 410 0ms 0ms 11 224 0ms 0ms 12 220 0ms 0ms 13 188 0ms 0ms 14 91 0ms 0ms 15 49 0ms 0ms 16 124 0ms 0ms 17 211 0ms 0ms 18 33 0ms 0ms 20 2,180 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 #20
Day Hour Count Duration Avg duration Jul 16 07 8 0ms 0ms 08 176 0ms 0ms 09 474 0ms 0ms 10 374 0ms 0ms 11 224 0ms 0ms 12 229 0ms 0ms 13 189 0ms 0ms 14 99 0ms 0ms 15 59 0ms 0ms 16 108 0ms 0ms 17 198 0ms 0ms 18 37 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 2 0ms 0ms Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 0ms 0ms 37 0ms select adprocess0_.ad_process_id as ad_proce1_84_0_, adprocess0_.ad_client_id as ad_clien2_84_0_, adprocess0_.ad_org_id as ad_org_i3_84_0_, adprocess0_.isactive as isactive4_84_0_, adprocess0_.created as created5_84_0_, adprocess0_.createdby as createdb6_84_0_, adprocess0_.updated as updated7_84_0_, adprocess0_.updatedby as updatedb8_84_0_, adprocess0_.value as value9_84_0_, adprocess0_.name as name10_84_0_, adprocess0_.description as descrip11_84_0_, adprocess0_.help as help12_84_0_, adprocess0_.accesslevel as accessl13_84_0_, adprocess0_.isuserstartable as isusers14_84_0_, adprocess0_.procedurename as procedu15_84_0_, adprocess0_.isreport as isrepor16_84_0_, adprocess0_.isdirectprint as isdirec17_84_0_, adprocess0_.classname as classna18_84_0_, adprocess0_.isbackground as isbackg19_84_0_, adprocess0_.isjasper as isjaspe20_84_0_, adprocess0_.jrname as jrname21_84_0_, adprocess0_.service_type as service22_84_0_, adprocess0_.isexternalservice as isexter23_84_0_, adprocess0_.service_source as service24_84_0_, adprocess0_.ad_module_id as ad_modu25_84_0_, adprocess0_.uipattern as uipatte26_84_0_, adprocess0_.isadvancedfeature as isadvan27_84_0_, adprocess0_.preventconcurrent as prevent28_84_0_, adprocess0_.is_explicit_access as is_expl29_84_0_, adprocess0_.iskillable as iskilla30_84_0_ from ad_process adprocess0_ where adprocess0_.ad_process_id in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 16 08 3 0ms 0ms 09 10 0ms 0ms 10 7 0ms 0ms 11 3 0ms 0ms 12 3 0ms 0ms 13 5 0ms 0ms 14 2 0ms 0ms 16 1 0ms 0ms 17 2 0ms 0ms 18 1 0ms 0ms 2 0ms 0ms 0ms 15 0ms select concat(?, tab.tablename, ?, count(?), ?) as ad_tree from ad_tree at2 left join ad_table tab on tab.ad_table_id = at2.ad_table_id where at2.ad_table_id is not null group by tab.ad_table_id, at2.ad_client_id having count(?) > ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 16 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 3 0ms 0ms 0ms 8 0ms insert into c_file (ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, name, c_datatype_id, seqno, text, ad_table_id, ad_record_id, c_file_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 16 09 2 0ms 0ms 10 2 0ms 0ms 12 3 0ms 0ms 17 1 0ms 0ms 4 0ms 0ms 0ms 28 0ms select coalesce(( select show_in_header from ad_client_acctdimension where ad_client_id = ? and docbasetype = ? and dimension = ?), c.product_acctdim_header) from ad_client c where c.ad_client_id = ? and c.org_acctdim_isenable = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 16 09 13 0ms 0ms 10 12 0ms 0ms 17 3 0ms 0ms 5 0ms 0ms 0ms 6,306 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 #5
Day Hour Count Duration Avg duration Jul 16 07 135 0ms 0ms 08 440 0ms 0ms 09 1,113 0ms 0ms 10 905 0ms 0ms 11 559 0ms 0ms 12 598 0ms 0ms 13 516 0ms 0ms 14 304 0ms 0ms 15 250 0ms 0ms 16 363 0ms 0ms 17 550 0ms 0ms 18 203 0ms 0ms 19 122 0ms 0ms 20 122 0ms 0ms 21 122 0ms 0ms 22 4 0ms 0ms 6 0ms 0ms 0ms 197 0ms select adpreferen0_.ad_preference_id as ad_prefe1_83_, adpreferen0_.ad_client_id as ad_clien2_83_, adpreferen0_.ad_org_id as ad_org_i3_83_, adpreferen0_.isactive as isactive4_83_, adpreferen0_.created as created5_83_, adpreferen0_.createdby as createdb6_83_, adpreferen0_.updated as updated7_83_, adpreferen0_.updatedby as updatedb8_83_, adpreferen0_.ad_window_id as ad_windo9_83_, adpreferen0_.ad_user_id as ad_user10_83_, adpreferen0_.attribute as attribu11_83_, adpreferen0_.value as value12_83_, adpreferen0_.property as propert13_83_, adpreferen0_.ispropertylist as isprope14_83_, adpreferen0_.visibleat_client_id as visible15_83_, adpreferen0_.visibleat_org_id as visible16_83_, adpreferen0_.visibleat_role_id as visible17_83_, adpreferen0_.selected as selecte18_83_, adpreferen0_.ad_module_id as ad_modu19_83_, adpreferen0_.inherited_from as inherit20_83_ from ad_preference adpreferen0_ where adpreferen0_.visibleat_client_id = ? and adpreferen0_.visibleat_org_id = ? and adpreferen0_.ad_user_id = ? and adpreferen0_.visibleat_role_id = ? and (adpreferen0_.ad_window_id is null) and adpreferen0_.ispropertylist = ? and adpreferen0_.property = ? and (adpreferen0_.ad_org_id in (...)) and (adpreferen0_.ad_client_id in (...)) and adpreferen0_.isactive = ? order by adpreferen0_.ad_preference_id;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 16 08 14 0ms 0ms 09 55 0ms 0ms 10 32 0ms 0ms 11 32 0ms 0ms 12 10 0ms 0ms 13 6 0ms 0ms 14 12 0ms 0ms 15 8 0ms 0ms 16 12 0ms 0ms 17 14 0ms 0ms 18 2 0ms 0ms 7 0ms 0ms 0ms 458 0ms select name, gaap, isaccrual, costingmethod, c_currency_id, hasalias, istradediscountposted, isdiscountcorrectstax, ad_client_id, ? as usesuspensebalancing, ? as suspensebalancing_acct, ? as usesuspenseerror, ? as suspenseerror_acct, ? as usecurrencybalancing, ? as currencybalancing_acct, ? as retainedearning_acct, ? as incomesummary_acct, ? as intercompanydueto_acct, ? as intercompanyduefrom_acct, ? as c_acctschema_id from c_acctschema where c_acctschema_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 16 08 18 0ms 0ms 09 34 0ms 0ms 10 58 0ms 0ms 11 42 0ms 0ms 12 46 0ms 0ms 13 56 0ms 0ms 14 24 0ms 0ms 15 18 0ms 0ms 16 30 0ms 0ms 17 36 0ms 0ms 18 24 0ms 0ms 19 18 0ms 0ms 20 18 0ms 0ms 21 18 0ms 0ms 22 18 0ms 0ms 8 0ms 0ms 0ms 17 0ms select this_.obuiapp_navbar_component_id as obuiapp_1_613_0_, this_.ad_client_id as ad_clien2_613_0_, this_.ad_org_id as ad_org_i3_613_0_, this_.ad_module_id as ad_modul4_613_0_, this_.obclker_template_id as obclker_5_613_0_, this_.name as name6_613_0_, this_.description as descript7_613_0_, this_.classname as classnam8_613_0_, this_.allroles as allroles9_613_0_, this_.sortno as sortno10_613_0_, this_.isactive as isactiv11_613_0_, this_.created as created12_613_0_, this_.createdby as created13_613_0_, this_.updated as updated14_613_0_, this_.updatedby as updated15_613_0_, this_.isstaticcomponent as isstati16_613_0_ from obuiapp_navbar_component this_ where this_.ad_org_id in (...) and this_.ad_client_id in (...) and this_.isactive = ? order by this_.sortno asc;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 16 07 1 0ms 0ms 08 2 0ms 0ms 09 3 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 2 0ms 0ms 13 4 0ms 0ms 15 3 0ms 0ms 9 0ms 0ms 0ms 2 0ms update c_order set updated = ?, description = ? where c_order_id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 16 09 1 0ms 0ms 10 1 0ms 0ms 10 0ms 0ms 0ms 19 0ms insert into rem_remittanceline (ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, rem_remittance_id, line, fin_payment_scheduledetail_id, amount, rem_remittanceline_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 16 11 14 0ms 0ms 12 5 0ms 0ms 11 0ms 0ms 0ms 6 0ms select admodelimp0_.ad_model_object_id as ad_model9_58_1_, admodelimp0_.ad_model_object_mapping_id as ad_model1_58_1_, admodelimp0_.ad_model_object_mapping_id as ad_model1_58_0_, admodelimp0_.ad_client_id as ad_clien2_58_0_, admodelimp0_.ad_org_id as ad_org_i3_58_0_, admodelimp0_.isactive as isactive4_58_0_, admodelimp0_.created as created5_58_0_, admodelimp0_.createdby as createdb6_58_0_, admodelimp0_.updated as updated7_58_0_, admodelimp0_.updatedby as updatedb8_58_0_, admodelimp0_.ad_model_object_id as ad_model9_58_0_, admodelimp0_.mappingname as mapping10_58_0_, admodelimp0_.isdefault as isdefau11_58_0_ from ad_model_object_mapping admodelimp0_ where admodelimp0_.ad_model_object_id = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 16 10 4 0ms 0ms 16 2 0ms 0ms 12 0ms 0ms 0ms 12 0ms select paymentrule, c_paymentterm_id, invoicerule, deliveryrule, deliveryviarule, paymentrulepo, po_paymentterm_id from c_bpartner where c_bpartner_id = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 16 08 1 0ms 0ms 09 4 0ms 0ms 10 1 0ms 0ms 11 2 0ms 0ms 12 1 0ms 0ms 14 2 0ms 0ms 18 1 0ms 0ms 13 0ms 0ms 0ms 2 0ms select aduser0_.ad_user_id as ad_user_1_129_, aduser0_.ad_client_id as ad_clien2_129_, aduser0_.ad_org_id as ad_org_i3_129_, aduser0_.isactive as isactive4_129_, aduser0_.created as created5_129_, aduser0_.createdby as createdb6_129_, aduser0_.updated as updated7_129_, aduser0_.updatedby as updatedb8_129_, aduser0_.name as name9_129_, aduser0_.description as descrip10_129_, aduser0_.password as passwor11_129_, aduser0_.email as email12_129_, aduser0_.supervisor_id as supervi13_129_, aduser0_.c_bpartner_id as c_bpart14_129_, aduser0_.processing as process15_129_, aduser0_.emailuser as emailus16_129_, aduser0_.emailuserpw as emailus17_129_, aduser0_.c_bpartner_location_id as c_bpart18_129_, aduser0_.c_greeting_id as c_greet19_129_, aduser0_.title as title20_129_, aduser0_.comments as comment21_129_, aduser0_.phone as phone22_129_, aduser0_.phone2 as phone23_129_, aduser0_.fax as fax24_129_, aduser0_.lastcontact as lastcon25_129_, aduser0_.lastresult as lastres26_129_, aduser0_.birthday as birthda27_129_, aduser0_.ad_orgtrx_id as ad_orgt28_129_, aduser0_.firstname as firstna29_129_, aduser0_.lastname as lastnam30_129_, aduser0_.username as usernam31_129_, aduser0_.default_ad_client_id as default32_129_, aduser0_.default_ad_language as default33_129_, aduser0_.default_ad_org_id as default34_129_, aduser0_.default_ad_role_id as default35_129_, aduser0_.default_m_warehouse_id as default36_129_, aduser0_.islocked as islocke37_129_, aduser0_.ad_image_id as ad_imag38_129_, aduser0_.grant_portal_access as grant_p39_129_, aduser0_.lastpasswordupdate as lastpas40_129_, aduser0_.isexpiredpassword as isexpir41_129_, aduser0_.commercialauth as commerc42_129_, aduser0_.viasms as viasms43_129_, aduser0_.viaemail as viaemai44_129_, aduser0_.em_smfsws_default_ws_role_id as em_smfs45_129_ from ad_user aduser0_ where exists ( select ? from c_order order1_ inner join ad_user aduser2_ on order1_.salesrep_id = aduser2_.ad_user_id cross join c_doctype documentty3_ where order1_.c_doctypetarget_id = documentty3_.c_doctype_id and order1_.issotrx = ? and documentty3_.isreturn = ? and (documentty3_.docsubtypeso not like ?) and aduser2_.ad_user_id = aduser0_.ad_user_id and (order1_.ad_org_id in (...)) and (order1_.ad_client_id in (...))) order by aduser0_.name limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 16 10 2 0ms 0ms 14 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(?), null, to_number(null), null, null, ?, null, null, null, null, null, null, null, null, null, ? ? a1040716ab4785a18a89f1f0891b5e ? ? ? fat ? ? b91058cda84385b78306b7f419f056 ? n ');Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 16 12 1 0ms 0ms 15 0ms 0ms 0ms 1 0ms update c_order set updated = ?, updatedby = ?, em_opxmp_disenador_id = ?, em_opxmp_estado = ? where c_order_id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 16 10 1 0ms 0ms 16 0ms 0ms 0ms 3 0ms insert into c_invoice (ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processing, processed, posted, c_doctype_id, c_doctypetarget_id, c_order_id, isprinted, dateinvoiced, dateacct, c_bpartner_id, c_bpartner_location_id, poreference, isdiscountprinted, dateordered, c_currency_id, c_paymentterm_id, m_pricelist_id, istaxincluded, createfrom, generateto, copyfrom, isselfservice, ispaid, em_einv_generated, totalpaid, em_einv_sent, outstandingamt, daystilldue, dueamt, fin_paymentmethod_id, calculate_promotions, em_aprm_addpayment, iscashvat, em_aprm_processinvoice, prepaymentamt, createfromorders, createfrominouts, paidamtatinvoicing, em_opxcld_createlines, c_invoice_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 16 09 2 0ms 0ms 12 1 0ms 0ms 17 0ms 0ms 0ms 26 0ms select admodule0_.ad_module_id as ad_modul1_60_0_, admodule0_.ad_client_id as ad_clien2_60_0_, admodule0_.ad_org_id as ad_org_i3_60_0_, admodule0_.isactive as isactive4_60_0_, admodule0_.created as created5_60_0_, admodule0_.createdby as createdb6_60_0_, admodule0_.updated as updated7_60_0_, admodule0_.updatedby as updatedb8_60_0_, admodule0_.name as name9_60_0_, admodule0_.version as version10_60_0_, admodule0_.description as descrip11_60_0_, admodule0_.help as help12_60_0_, admodule0_.url as url13_60_0_, admodule0_.type as type14_60_0_, admodule0_.license as license15_60_0_, admodule0_.isindevelopment as isindev16_60_0_, admodule0_.isdefault as isdefau17_60_0_, admodule0_.seqno as seqno18_60_0_, admodule0_.javapackage as javapac19_60_0_, admodule0_.licensetype as license20_60_0_, admodule0_.author as author21_60_0_, admodule0_.status as status22_60_0_, admodule0_.update_available as update_23_60_0_, admodule0_.istranslationrequired as istrans24_60_0_, admodule0_.ad_language as ad_lang25_60_0_, admodule0_.haschartofaccounts as haschar26_60_0_, admodule0_.istranslationmodule as istrans27_60_0_, admodule0_.hasreferencedata as hasrefe28_60_0_, admodule0_.isregistered as isregis29_60_0_, admodule0_.updateinfo as updatei30_60_0_, admodule0_.update_ver_id as update_31_60_0_, admodule0_.referencedatainfo as referen32_60_0_, admodule0_.version_label as version33_60_0_, admodule0_.iscommercial as iscomme34_60_0_, admodule0_.maturity_update as maturit35_60_0_, admodule0_.enabled as enabled36_60_0_, admodule0_.isconfigscriptapplied as isconfi37_60_0_, admodule0_.upgrade_available as upgrade38_60_0_, admodule0_.istrialallowed as istrial39_60_0_ from ad_module admodule0_ where admodule0_.ad_module_id in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 16 07 1 0ms 0ms 08 2 0ms 0ms 09 8 0ms 0ms 10 1 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 6 0ms 0ms 15 4 0ms 0ms 18 0ms 0ms 0ms 9 0ms select invoicedis0_.c_invoice_discount_id as c_invoic1_232_0_, invoicedis0_.ad_client_id as ad_clien2_232_0_, invoicedis0_.ad_org_id as ad_org_i3_232_0_, invoicedis0_.isactive as isactive4_232_0_, invoicedis0_.created as created5_232_0_, invoicedis0_.createdby as createdb6_232_0_, invoicedis0_.updated as updated7_232_0_, invoicedis0_.updatedby as updatedb8_232_0_, invoicedis0_.c_invoice_id as c_invoic9_232_0_, invoicedis0_.c_discount_id as c_disco10_232_0_, invoicedis0_.line as line11_232_0_, invoicedis0_.cascade as cascade12_232_0_ from c_invoice_discount invoicedis0_ where invoicedis0_.c_invoice_discount_id = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 16 10 1 0ms 0ms 11 1 0ms 0ms 16 3 0ms 0ms 17 4 0ms 0ms 19 0ms 0ms 0ms 37 0ms select fin_paymentmethod.name as paymentmethod, c_paymentterm.name as paymentterm, c_order.grandtotal as total from c_tax join c_ordertax on c_tax.c_tax_id = c_ordertax.c_tax_id join c_order on c_order.c_order_id = c_ordertax.c_order_id join c_orderline on c_orderline.c_order_id = c_order.c_order_id join c_paymentterm on c_order.c_paymentterm_id = c_paymentterm.c_paymentterm_id join fin_paymentmethod on c_order.fin_paymentmethod_id = fin_paymentmethod.fin_paymentmethod_id where c_ordertax.c_order_id = ? and c_ordertax.c_tax_id = c_tax.c_tax_id group by c_order.c_order_id, fin_paymentmethod.name, c_paymentterm.name, c_order.grandtotal order by c_order.c_order_id;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 16 08 9 0ms 0ms 09 6 0ms 0ms 10 3 0ms 0ms 11 3 0ms 0ms 12 2 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 2 0ms 0ms 16 4 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 20 0ms 0ms 0ms 20 0ms select m_attributeset_id from m_product where m_product_id = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 16 08 1 0ms 0ms 09 6 0ms 0ms 10 5 0ms 0ms 11 4 0ms 0ms 12 1 0ms 0ms 14 2 0ms 0ms 18 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 193 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 16 08 4 0ms 0ms 09 21 0ms 0ms 10 32 0ms 0ms 11 25 0ms 0ms 12 20 0ms 0ms 13 8 0ms 0ms 14 8 0ms 0ms 15 3 0ms 0ms 16 7 0ms 0ms 17 57 0ms 0ms 18 3 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,862,509 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
- 5 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 5 Max number of times the same event was reported
- 5 Total events found
Rank Times reported Error 1 5 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 16 09 3 11 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-16 09:26:58 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-16 09:28:45 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-16 09:38:21 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1