pgBadger-
Global information
- Generated on Mon Jul 13 23:03:12 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 2,989,184 log entries in 3m11s
- Log start from 2026-07-13 07:00:01 to 2026-07-13 22:00:00
-
Overview
Global Stats
- 1,230 Number of unique normalized queries
- 1,396,381 Number of queries
- 4m39s Total query duration
- 2026-07-13 07:00:01 First query
- 2026-07-13 22:00:00 Last query
- 4,353 queries/s at 2026-07-13 13:39:32 Query peak
- 4m39s Total query duration
- 0ms Prepare/parse total duration
- 6s460ms Bind total duration
- 4m33s Execute total duration
- 3 Number of events
- 1 Number of unique normalized events
- 3 Max number of times the same event was reported
- 0 Number of cancellation
- 98 Total number of automatic vacuums
- 145 Total number of automatic analyzes
- 17 Number temporary file
- 90.73 MiB Max size of temporary file
- 23.60 MiB Average size of temporary file
- 5,417 Total number of sessions
- 0 sessions at Session peak
- 2m1s Total duration of sessions
- 22ms Average duration of sessions
- 257 Average queries per session
- 51ms Average queries duration per session
- 0ms Average idle time per session
- 5,417 Total number of connections
- 5 connections/s at 2026-07-13 07:00:01 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4,353 queries/s Query Peak
- 2026-07-13 13:39:32 Date
SELECT Traffic
Key values
- 1,375 queries/s Query Peak
- 2026-07-13 13:39:32 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 70 queries/s Query Peak
- 2026-07-13 11:00:00 Date
Queries duration
Key values
- 4m39s 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 13 07 5,831 0ms 713ms 0ms 57ms 63ms 1s862ms 08 45,348 0ms 936ms 0ms 1s142ms 2s465ms 5s3ms 09 150,819 0ms 3s463ms 0ms 2s928ms 3s880ms 14s101ms 10 119,800 0ms 953ms 0ms 1s838ms 2s385ms 2s783ms 11 274,418 0ms 2s179ms 0ms 1s338ms 3s518ms 4s240ms 12 461,971 0ms 2s56ms 0ms 1s304ms 1s956ms 4s163ms 13 186,632 0ms 2s346ms 0ms 770ms 1s91ms 3s483ms 14 44,724 0ms 785ms 0ms 326ms 519ms 1s456ms 15 26,397 0ms 12s681ms 1ms 229ms 507ms 32s264ms 16 45,366 0ms 746ms 0ms 56ms 769ms 1s34ms 17 8,214 0ms 736ms 0ms 51ms 56ms 1s12ms 18 6,508 0ms 668ms 0ms 49ms 56ms 969ms 19 6,399 0ms 665ms 0ms 48ms 55ms 922ms 20 6,391 0ms 762ms 0ms 51ms 57ms 1s41ms 21 6,923 0ms 12s568ms 4ms 49ms 53ms 31s400ms 22 640 0ms 14ms 0ms 60ms 60ms 60ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 13 07 1,600 0 0ms 0ms 0ms 0ms 08 13,473 0 0ms 0ms 0ms 0ms 09 46,350 0 0ms 0ms 0ms 0ms 10 35,226 0 0ms 0ms 0ms 0ms 11 84,234 0 0ms 0ms 0ms 0ms 12 146,975 0 0ms 0ms 0ms 0ms 13 56,487 0 0ms 0ms 0ms 0ms 14 12,943 0 0ms 0ms 0ms 0ms 15 7,283 0 0ms 0ms 0ms 0ms 16 14,062 0 0ms 0ms 0ms 0ms 17 1,994 0 0ms 0ms 0ms 0ms 18 1,800 0 0ms 0ms 0ms 0ms 19 1,781 0 0ms 0ms 0ms 0ms 20 1,781 0 0ms 0ms 0ms 0ms 21 1,845 0 0ms 0ms 0ms 0ms 22 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 13 07 0 0 0 0 0ms 0ms 0ms 0ms 08 67 71 0 0 0ms 0ms 0ms 0ms 09 230 237 2 0 0ms 0ms 0ms 0ms 10 273 357 4 0 0ms 0ms 0ms 0ms 11 615 428 16 0 0ms 0ms 0ms 0ms 12 622 389 6 0 0ms 0ms 0ms 0ms 13 396 401 6 0 0ms 0ms 0ms 0ms 14 143 111 7 0 0ms 0ms 0ms 0ms 15 30 158 0 0 0ms 0ms 0ms 0ms 16 51 33 0 0 0ms 0ms 0ms 0ms 17 1 67 0 0 0ms 0ms 0ms 0ms 18 1 2 0 0 0ms 0ms 0ms 0ms 19 1 2 0 0 0ms 0ms 0ms 0ms 20 1 2 0 0 0ms 0ms 0ms 0ms 21 2 68 0 0 0ms 0ms 0ms 0ms 22 2 1 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 13 07 0 1,545 1,545.00 0.00% 08 0 14,258 14,258.00 0.00% 09 0 48,826 48,826.00 0.00% 10 0 38,413 38,413.00 0.00% 11 0 89,476 89,476.00 0.00% 12 0 152,428 152,428.00 0.00% 13 0 60,424 60,424.00 0.00% 14 0 14,073 14,073.00 0.00% 15 0 8,024 8,024.00 0.00% 16 0 14,503 14,503.00 0.00% 17 0 2,337 2,337.00 0.00% 18 0 1,754 1,754.00 0.00% 19 0 1,733 1,733.00 0.00% 20 0 1,733 1,733.00 0.00% 21 0 1,864 1,864.00 0.00% 22 0 212 212.00 0.00% Day Hour Count Average / Second Jul 13 07 363 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 13 07 363 23ms 10ms 08 361 22ms 0ms 09 361 22ms 0ms 10 361 23ms 0ms 11 361 22ms 0ms 12 361 22ms 0ms 13 361 22ms 0ms 14 361 22ms 4ms 15 361 22ms 0ms 16 361 22ms 7ms 17 361 21ms 13ms 18 361 22ms 14ms 19 361 21ms 14ms 20 361 22ms 14ms 21 361 22ms 0ms 22 0 0ms 0ms -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-13 07:00:01 Date
Connections per database
Key values
- etendo Main Database
- 5,417 connections Total
Connections per user
Key values
- tad Main User
- 5,417 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- 5,400 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 5,417 sessions Total
Sessions per user
Key values
- tad Main User
- 5,417 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 5,417 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 1,886 buffers Checkpoint Peak
- 2026-07-13 11:05:54 Date
- 188.570 seconds Highest write time
- 0.247 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-07-13 15:52:50 Date
Checkpoints distance
Key values
- 27.93 Mo Distance Peak
- 2026-07-13 11:05:54 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 13 07 1,179 117.759s 0.004s 117.773s 08 1,503 148.955s 0.023s 149.023s 09 1,951 193.602s 0.026s 193.675s 10 2,407 239.282s 0.029s 239.35s 11 3,387 336.178s 0.035s 336.277s 12 2,904 287.582s 0.029s 287.656s 13 2,789 277.033s 0.273s 277.353s 14 2,110 209.738s 0.026s 209.815s 15 1,672 165.871s 0.025s 165.937s 16 1,531 152.481s 0.013s 152.516s 17 1,389 137.886s 0.025s 137.952s 18 1,221 121.764s 0.002s 121.77s 19 1,179 117.751s 0.003s 117.759s 20 1,168 116.438s 0.003s 116.444s 21 1,200 119.551s 0.003s 119.56s 22 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 13 07 0 1 0 140 0.002s 0.002s 08 0 1 0 265 0.002s 0.011s 09 0 0 0 432 0.003s 0.012s 10 0 1 0 642 0.003s 0.012s 11 0 2 0 966 0.002s 0.012s 12 0 1 0 853 0.002s 0.012s 13 0 1 0 721 0.247s 0.03s 14 0 1 0 401 0.002s 0.012s 15 0 1 0 251 0.002s 0.012s 16 0 1 0 199 0.003s 0.006s 17 0 0 0 163 0.002s 0.012s 18 0 1 0 132 0.002s 0.001s 19 0 1 0 133 0.001s 0.001s 20 0 0 0 128 0.002s 0.001s 21 0 1 0 136 0.001s 0.001s 22 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 13 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 13 07 4,635.00 kB 9,239.00 kB 08 999.27 kB 6,170.45 kB 09 1,180.42 kB 6,176.00 kB 10 1,428.25 kB 7,263.08 kB 11 2,015.42 kB 8,921.33 kB 12 1,775.58 kB 7,274.50 kB 13 1,669.50 kB 7,473.67 kB 14 1,237.42 kB 7,568.58 kB 15 1,008.50 kB 6,769.42 kB 16 1,887.50 kB 8,423.50 kB 17 884.83 kB 6,288.33 kB 18 9,626.00 kB 9,626.00 kB 19 9,329.00 kB 9,597.00 kB 20 9,287.00 kB 9,566.00 kB 21 9,470.00 kB 9,556.00 kB 22 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 91.98 MiB Temp Files size Peak
- 2026-07-13 15:30:04 Date
Number of temporary files
Key values
- 3 per second Temp Files Peak
- 2026-07-13 15:30:04 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 13 07 0 0 0 08 0 0 0 09 1 13.48 MiB 13.48 MiB 10 1 13.48 MiB 13.48 MiB 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 7 180.39 MiB 25.77 MiB 16 1 13.49 MiB 13.49 MiB 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 7 180.39 MiB 25.77 MiB 22 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 4 3.94 MiB 728.00 KiB 1.26 MiB 1008.00 KiB ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id, ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, record_id, ?) as record_id from fact_acct where ad_table_id = ? and docbasetype in (...) group by fact_acct_group_id, record_id, ad_client_id, ad_org_id having sum(amtacctcr - amtacctdr) <> ?) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);-
'0' as ad_role_id, null as ad_user_id, 'NOT BALANCED SALES INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('ARI', 'ARC', 'ARF') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-13 15:30:04 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
2 4 355.42 MiB 86.98 MiB 90.73 MiB 88.86 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-13 15:30:04 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
3 3 40.46 MiB 13.48 MiB 13.49 MiB 13.49 MiB select sum(order0_.totallines) as col_0_0_, sum( cost) as col_1_0_, sum(margen) as col_2_0_, sum(pmargen) / count(*) as col_3_0_ from c_order order0_ left outer join c_invoice invoicelis1_ on order0_.c_order_id = invoicelis1_.c_order_id cross join c_orderline orderline2_ where orderline2_.c_order_id = order0_.c_order_id and order0_.issotrx = ? and order0_.docstatus = ? and ? = ? limit ?;-
select sum(order0_.TotalLines) as col_0_0_, sum( Cost) as col_1_0_, sum(Margen) as col_2_0_, sum(PMargen) / count(*) as col_3_0_ from C_Order order0_ left outer join C_Invoice invoicelis1_ on order0_.C_Order_ID = invoicelis1_.C_Order_ID cross join C_OrderLine orderline2_ where orderline2_.C_Order_ID = order0_.C_Order_ID and order0_.IsSOTrx = 'Y' and order0_.DocStatus = 'CO' and 1 = 1 limit $1;
Date: 2026-07-13 09:34:55 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
4 2 1.42 MiB 728.00 KiB 728.00 KiB 728.00 KiB update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select record_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id, ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, record_id, ?) as record_id from fact_acct where ad_table_id = ? and docbasetype in (...) group by fact_acct_group_id, record_id, ad_client_id, ad_org_id having sum(amtacctcr - amtacctdr) <> ?) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select record_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED PURCHASE INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('API', 'APC') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-13 15:30:29 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
Queries generating the largest temporary files
Rank Size Query 1 90.73 MiB '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-13 15:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2 90.73 MiB '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-13 21:00:02 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3 86.98 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-13 15:30:31 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4 86.98 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-13 21:00:30 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5 13.49 MiB select sum(order0_.TotalLines) as col_0_0_, sum( Cost) as col_1_0_, sum(Margen) as col_2_0_, sum(PMargen) / count(*) as col_3_0_ from C_Order order0_ left outer join C_Invoice invoicelis1_ on order0_.C_Order_ID = invoicelis1_.C_Order_ID cross join C_OrderLine orderline2_ where orderline2_.C_Order_ID = order0_.C_Order_ID and order0_.IsSOTrx = 'Y' and order0_.DocStatus = 'CO' and 1 = 1 limit $1;[ Date: 2026-07-13 16:36:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
6 13.48 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-13 09:34:55 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
7 13.48 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-13 10:22:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8 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-13 15:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
9 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-13 21:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
10 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-13 15:30:17 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
11 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-13 15:30:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
12 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-13 21:00:15 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
13 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-13 21:00:28 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.04 sec Highest CPU-cost vacuum
Table profile.sample_stat_user_functions
Database etendo - 2026-07-13 11:00:36 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 0.04 sec Highest CPU-cost vacuum
Table profile.sample_stat_user_functions
Database etendo - 2026-07-13 11:00:36 Date
Analyzes per table
Key values
- public.ad_session (17) Main table analyzed (database etendo)
- 145 analyzes Total
Table Number of analyzes etendo.public.ad_session 17 etendo.profile.last_stat_indexes_srv1 15 etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.last_stat_statements_srv1 15 etendo.profile.last_stat_tables_srv1 15 etendo.public.ad_ep_instance_para 9 etendo.profile.last_stat_io 8 etendo.profile.tables_list 8 etendo.profile.last_extension_versions 4 etendo.profile.last_stat_activity_count_srv1 4 etendo.profile.funcs_list 4 etendo.profile.stmt_list 4 etendo.profile.last_stat_slru 3 etendo.profile.indexes_list 3 etendo.profile.sample_stat_indexes 2 etendo.public.ad_preference 2 etendo.profile.sample_statements 2 etendo.profile.sample_stat_user_functions 2 etendo.profile.sample_statements_total 1 etendo.profile.last_stat_archiver 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.last_stat_cluster 1 etendo.profile.last_stat_wal 1 etendo.profile.sample_stat_slru 1 etendo.profile.sample_stat_database 1 etendo.profile.sample_stat_io 1 etendo.profile.sample_stat_tablespaces 1 etendo.public.ad_sequence 1 etendo.profile.sample_stat_tables_total 1 etendo.profile.sample_stat_tables 1 etendo.profile.sample_stat_user_func_total 1 Total 145 Vacuums per table
Key values
- profile.last_stat_statements_srv1 (15) Main table vacuumed on database etendo
- 98 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_statements_srv1 15 15 6,943 0 100 0 0 4,478 105 721,829 0 0 etendo.profile.last_stat_tables_srv1 15 15 11,988 0 171 0 0 8,959 173 1,256,441 0 0 etendo.profile.last_stat_user_functions_srv1 15 15 2,111 0 48 0 0 1,122 34 240,786 0 0 etendo.profile.last_stat_indexes_srv1 15 15 15,437 0 270 0 0 11,345 285 1,807,243 0 0 etendo.profile.tables_list 6 6 882 0 15 0 0 471 11 118,862 0 0 etendo.public.ad_ep_instance_para 4 4 236 0 21 0 0 25 7 58,812 0 0 etendo.profile.funcs_list 3 3 282 0 12 0 0 81 5 47,080 0 0 etendo.profile.stmt_list 3 3 927 0 38 0 0 641 39 281,896 17 65 etendo.profile.last_stat_io 3 3 249 0 15 0 0 28 7 50,869 0 0 etendo.profile.last_stat_activity_count_srv1 2 0 42 0 10 0 0 12 4 31,912 0 0 etendo.profile.indexes_list 2 2 257 0 13 0 0 72 7 61,248 0 0 etendo.profile.last_extension_versions 2 2 104 0 9 0 0 10 3 25,543 0 0 etendo.profile.last_stat_slru 2 2 94 0 9 0 0 10 3 25,563 0 0 etendo.profile.samples 1 1 81 0 6 0 0 8 3 24,806 0 0 etendo.profile.last_stat_tablespaces_srv1 1 1 51 0 6 0 0 6 3 18,979 0 0 etendo.profile.sample_stat_user_functions 1 1 343 0 38 0 0 106 23 121,810 1 29 etendo.profile.sample_stat_io 1 1 135 0 22 0 0 43 11 57,264 3 40 etendo.pg_toast.pg_toast_106363 1 1 99 0 22 0 0 44 12 44,224 7 18 etendo.profile.sample_stat_tables_total 1 1 220 0 33 0 0 58 18 67,563 2 46 etendo.profile.sample_stat_cluster 1 1 57 0 9 0 0 13 3 17,008 0 0 etendo.profile.last_stat_database_srv1 1 1 50 0 2 0 0 6 2 16,162 0 0 etendo.profile.sample_stat_wal 1 1 53 0 8 0 0 11 4 25,954 0 0 etendo.pg_toast.pg_toast_2619 1 1 509 0 79 0 0 257 75 137,527 3 6 etendo.profile.sample_stat_archiver 1 1 50 0 6 0 0 8 2 17,103 0 0 Total 98 96 41,200 0 962 0 0 27,814 839 5,276,484 33 204 Vacuum throughput per table
Key values
- profile.last_stat_tables_srv1 (0.15) 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_statements_srv1 0 0 0.05 etendo.profile.last_stat_tables_srv1 0 0 0.15 etendo.profile.last_stat_user_functions_srv1 0 0 0 etendo.profile.last_stat_indexes_srv1 0 0 0.15 etendo.profile.tables_list 0 0 0 etendo.public.ad_ep_instance_para 0 0 0.02 etendo.profile.funcs_list 0 0 0 etendo.profile.stmt_list 0 0 0 etendo.profile.last_stat_io 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.indexes_list 0 0 0 etendo.profile.last_extension_versions 0 0 0 etendo.profile.last_stat_slru 0 0 0 etendo.profile.samples 0 0 0 etendo.profile.last_stat_tablespaces_srv1 0 0 0 etendo.profile.sample_stat_user_functions 0 0 0.04 etendo.profile.sample_stat_io 0 0 0.02 etendo.pg_toast.pg_toast_106363 0 0 0 etendo.profile.sample_stat_tables_total 0 0 0 etendo.profile.sample_stat_cluster 0 0 0 etendo.profile.last_stat_database_srv1 0 0 0 etendo.profile.sample_stat_wal 0 0 0 etendo.pg_toast.pg_toast_2619 0 0 0.02 etendo.profile.sample_stat_archiver 0 0 0 Total 0 0 0.45 Tuples removed per table
Key values
- profile.last_stat_indexes_srv1 (70679) Main table with removed tuples on database etendo
- 138375 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,679 34,935 0 0 4,304 etendo.profile.last_stat_tables_srv1 15 15 44,688 20,880 0 0 3,444 etendo.profile.last_stat_statements_srv1 15 15 13,914 11,910 0 138 1,341 etendo.profile.last_stat_user_functions_srv1 15 15 5,338 4,605 0 2 334 etendo.profile.sample_stat_user_functions 1 1 953 7,011 0 0 80 etendo.profile.tables_list 6 6 843 4,810 0 0 138 etendo.profile.stmt_list 3 3 271 2,257 0 0 234 etendo.pg_toast.pg_toast_2619 1 1 243 1,074 0 0 455 etendo.profile.sample_stat_tables_total 1 1 236 1,352 0 0 45 etendo.profile.last_stat_io 3 3 169 39 0 2 4 etendo.profile.sample_stat_io 1 1 145 864 0 0 25 etendo.profile.funcs_list 3 3 145 525 0 0 24 etendo.profile.indexes_list 2 2 115 675 0 0 20 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.public.ad_ep_instance_para 4 4 74 0 0 3 1 etendo.profile.sample_stat_cluster 1 1 73 168 0 0 6 etendo.profile.sample_stat_archiver 1 1 71 168 0 0 3 etendo.profile.sample_stat_wal 1 1 68 168 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.pg_toast.pg_toast_106363 1 1 22 49 0 0 16 etendo.profile.last_stat_database_srv1 1 1 4 4 0 0 1 etendo.profile.samples 1 1 2 168 0 0 1 Total 98 96 138,375 91,690 0 147 10,485 Pages removed per table
Key values
- profile.last_stat_statements_srv1 (138) Main table with removed pages on database etendo
- 147 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed etendo.profile.last_stat_statements_srv1 15 15 13914 138 etendo.public.ad_ep_instance_para 4 4 74 3 etendo.profile.last_stat_activity_count_srv1 2 0 48 2 etendo.profile.last_stat_io 3 3 169 2 etendo.profile.last_stat_user_functions_srv1 15 15 5338 2 etendo.profile.samples 1 1 2 0 etendo.profile.last_stat_tablespaces_srv1 1 1 52 0 etendo.profile.sample_stat_user_functions 1 1 953 0 etendo.profile.sample_stat_io 1 1 145 0 etendo.profile.last_stat_tables_srv1 15 15 44688 0 etendo.pg_toast.pg_toast_106363 1 1 22 0 etendo.profile.sample_stat_tables_total 1 1 236 0 etendo.profile.indexes_list 2 2 115 0 etendo.profile.funcs_list 3 3 145 0 etendo.profile.sample_stat_cluster 1 1 73 0 etendo.profile.last_stat_database_srv1 1 1 4 0 etendo.profile.sample_stat_wal 1 1 68 0 etendo.profile.stmt_list 3 3 271 0 etendo.profile.last_extension_versions 2 2 112 0 etendo.pg_toast.pg_toast_2619 1 1 243 0 etendo.profile.sample_stat_archiver 1 1 71 0 etendo.profile.last_stat_slru 2 2 110 0 etendo.profile.last_stat_indexes_srv1 15 15 70679 0 etendo.profile.tables_list 6 6 843 0 Total 98 96 138,375 147 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 13 07 6 8 08 7 10 09 6 16 10 7 10 11 7 13 12 7 12 13 7 13 14 11 7 15 8 13 16 6 10 17 5 9 18 7 6 19 6 7 20 4 5 21 4 6 22 0 0 - 0.04 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
- 428,036 Total read queries
- 28,266 Total write queries
Queries by database
Key values
- etendo Main database
- 1,387,799 Requests
- 4m29s (etendo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 1,386,713 Requests
User Request type Count Duration postgres Total 9,668 18s511ms ddl 2 0ms others 2,835 0ms select 1,907 0ms tcl 90 0ms tad Total 1,386,713 4m14s delete 41 0ms insert 2,435 0ms others 480 0ms select 426,129 0ms tcl 23,371 0ms update 2,327 0ms Duration by user
Key values
- 4m14s (tad) Main time consuming user
User Request type Count Duration postgres Total 9,668 18s511ms ddl 2 0ms others 2,835 0ms select 1,907 0ms tcl 90 0ms tad Total 1,386,713 4m14s delete 41 0ms insert 2,435 0ms others 480 0ms select 426,129 0ms tcl 23,371 0ms update 2,327 0ms Queries by host
Key values
- 127.0.0.1 Main host
- 1,386,713 Requests
- 4m14s (127.0.0.1)
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 1,380,353 Requests
- 3m59s (openbravo)
- Main time consuming application
Application Request type Count Duration [unknown] Total 8,415 3s675ms others 2,745 0ms select 1,440 0ms tcl 45 0ms openbravo Total 1,380,353 3m59s delete 41 0ms insert 2,435 0ms select 423,429 0ms tcl 23,371 0ms update 2,327 0ms pg_profile Total 1,185 2s806ms others 90 0ms select 435 0ms tcl 45 0ms psql Total 6,428 27s637ms ddl 2 0ms others 480 0ms select 2,732 0ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-13 11:30:34 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 922,777 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 16 0ms 0ms 0ms select ( case mo.action when ? then mo.ad_form_id when ? then mo.ad_process_id when ? then mo.ad_process_id when ? then mo.ad_callout_id when ? then mo.ad_reference_id else mo.ad_tab_id end) as ad_tab_id, mom.mappingname as tabname, mo.action from ad_model_object mo, ad_model_object_mapping mom where mo.ad_model_object_id = mom.ad_model_object_id and mo.isactive = ? and mom.isactive = ? and mom.isdefault = ? and upper(mo.classname) = upper(?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 13 10 8 0ms 0ms 11 3 0ms 0ms 12 4 0ms 0ms 13 1 0ms 0ms 2 0ms 2 0ms 0ms 0ms select count(distinct country2_.c_country_id) as col_0_0_ from c_bpartner_location businesspa0_ inner join c_location location1_ on businesspa0_.c_location_id = location1_.c_location_id inner join c_country country2_ on location1_.c_country_id = country2_.c_country_id where businesspa0_.c_bpartner_id = ? and businesspa0_.istaxlocation = ? and country2_.c_country_id <> ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 13 11 1 0ms 0ms 14 1 0ms 0ms 3 0ms 9 0ms 0ms 0ms select invoice0_.c_invoice_id as col_0_0_, invoice0_.documentno as col_1_0_, invoice0_.c_bpartner_id as col_2_0_, businesspa1_.name as col_3_0_, invoice0_.dateinvoiced as col_4_0_, invoice0_.grandtotal as col_5_0_, currency2_.iso_code as col_6_0_, financialm3_.name as col_7_0_, invoice0_.outstandingamt as col_8_0_, invoice0_.daystilldue as col_9_0_, invoice0_.dueamt as col_10_0_, organizati4_.name as col_11_0_ from c_invoice invoice0_ cross join c_bpartner businesspa1_ cross join c_currency currency2_ cross join c_paymentterm financialm3_ cross join ad_org organizati4_ where invoice0_.c_bpartner_id = businesspa1_.c_bpartner_id and invoice0_.c_currency_id = currency2_.c_currency_id and invoice0_.c_paymentterm_id = financialm3_.c_paymentterm_id and invoice0_.ad_org_id = organizati4_.ad_org_id and (businesspa1_.name like ?) and (invoice0_.documentno like ?) and invoice0_.processed = ? and invoice0_.docstatus <> ? and invoice0_.ispaid = ? and invoice0_.issotrx = ? and invoice0_.ad_client_id = ? and (invoice0_.ad_org_id in (...)) and (organizati4_.name like ?) and ? = ? order by invoice0_.dateinvoiced limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 13 09 4 0ms 0ms 10 1 0ms 0ms 13 3 0ms 0ms 16 1 0ms 0ms 4 0ms 257 0ms 0ms 0ms select case when sum(fpsd.amount) = ci.grandtotal then ? else ? end 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_invoice join c_invoice ci on ci.c_invoice_id = ps.c_invoice_id where ps.c_invoice_id = ? and to_number(aprm_seqnumberpaymentstatus (fp.status)) >= ? group by ci.grandtotal;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 13 09 33 0ms 0ms 10 49 0ms 0ms 11 61 0ms 0ms 12 83 0ms 0ms 13 31 0ms 0ms 5 0ms 68 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 = ? or coalesce(adpreferen0_.visibleat_client_id, ?) = ?) and (adpreferen0_.visibleat_role_id = ? or adpreferen0_.visibleat_role_id is null) and (coalesce(adpreferen0_.visibleat_org_id, ?) in (...)) and (adpreferen0_.ad_user_id = ? or adpreferen0_.ad_user_id is null) and (adpreferen0_.ad_window_id is null) and adpreferen0_.ispropertylist = ? and adpreferen0_.attribute = ? 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 #5
Day Hour Count Duration Avg duration Jul 13 09 38 0ms 0ms 13 30 0ms 0ms 6 0ms 1 0ms 0ms 0ms select orderlinet0_.c_orderlinetax_id as c_orderl1_253_0_, orderlinet0_.c_orderline_id as c_orderl2_253_0_, orderlinet0_.c_tax_id as c_tax_id3_253_0_, orderlinet0_.ad_client_id as ad_clien4_253_0_, orderlinet0_.ad_org_id as ad_org_i5_253_0_, orderlinet0_.isactive as isactive6_253_0_, orderlinet0_.created as created7_253_0_, orderlinet0_.createdby as createdb8_253_0_, orderlinet0_.updated as updated9_253_0_, orderlinet0_.updatedby as updated10_253_0_, orderlinet0_.taxbaseamt as taxbase11_253_0_, orderlinet0_.taxamt as taxamt12_253_0_, orderlinet0_.line as line13_253_0_, orderlinet0_.c_order_id as c_order14_253_0_ from c_orderlinetax orderlinet0_ where orderlinet0_.c_orderlinetax_id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 13 10 1 0ms 0ms 7 0ms 29 0ms 0ms 0ms select adtable1_.isfullyaudited as col_0_0_ from ad_tab adtab0_ cross join ad_table adtable1_ where adtab0_.ad_table_id = adtable1_.ad_table_id and adtab0_.ad_window_id = ? order by adtab0_.seqno, adtab0_.ad_tab_id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 13 08 3 0ms 0ms 09 7 0ms 0ms 10 3 0ms 0ms 11 5 0ms 0ms 13 5 0ms 0ms 14 1 0ms 0ms 15 4 0ms 0ms 16 1 0ms 0ms 8 0ms 4 0ms 0ms 0ms select * from ( select a_amortization_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 (?, a_amortization_id, ?) as record_id, posted from a_amortization where a_amortization.posted in (...) group by a_amortization_id, posted, ad_client_id, ad_org_id) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 13 15 2 0ms 0ms 21 2 0ms 0ms 9 0ms 12 0ms 0ms 0ms select c_costcenter_id, user1_id, user2_id from fin_payment where fin_payment_id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 13 10 1 0ms 0ms 11 4 0ms 0ms 12 1 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 10 0ms 2 0ms 0ms 0ms select c_order.c_order_id as document_id, c_order.docstatus as docstatus, c_order.documentno as ourreference, c_order.poreference as yourreference, c_order.salesrep_id as salesrep_user_id, salesrep.email as salesrep_email, salesrep.name as salesrep_name, c_order.c_bpartner_id as bpartner_id, c_bpartner.name as bpartner_name, c_order.ad_user_id as contact_user_id, customercontact.email as contact_email, customercontact.name as contact_name from c_order left join ad_user customercontact on c_order.ad_user_id = customercontact.ad_user_id left join ad_user salesrep on c_order.salesrep_id = salesrep.ad_user_id left join c_bpartner on c_order.c_bpartner_id = c_bpartner.c_bpartner_id where ? = ? and c_order.c_order_id in (...);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 13 09 1 0ms 0ms 11 1 0ms 0ms 11 0ms 430 0ms 0ms 0ms select orderline0_.c_orderline_id as c_orderl1_249_, orderline0_.ad_client_id as ad_clien2_249_, orderline0_.ad_org_id as ad_org_i3_249_, orderline0_.isactive as isactive4_249_, orderline0_.created as created5_249_, orderline0_.createdby as createdb6_249_, orderline0_.updated as updated7_249_, orderline0_.updatedby as updatedb8_249_, orderline0_.c_order_id as c_order_9_249_, orderline0_.line as line10_249_, orderline0_.c_bpartner_id as c_bpart11_249_, orderline0_.c_bpartner_location_id as c_bpart12_249_, orderline0_.dateordered as dateord13_249_, orderline0_.datepromised as datepro14_249_, orderline0_.datedelivered as datedel15_249_, orderline0_.dateinvoiced as dateinv16_249_, orderline0_.description as descrip17_249_, orderline0_.m_product_id as m_produ18_249_, orderline0_.m_warehouse_id as m_wareh19_249_, orderline0_.directship as directs20_249_, orderline0_.c_uom_id as c_uom_i21_249_, orderline0_.qtyordered as qtyorde22_249_, orderline0_.qtyreserved as qtyrese23_249_, orderline0_.qtydelivered as qtydeli24_249_, orderline0_.qtyinvoiced as qtyinvo25_249_, orderline0_.m_shipper_id as m_shipp26_249_, orderline0_.c_currency_id as c_curre27_249_, orderline0_.pricelist as priceli28_249_, orderline0_.priceactual as priceac29_249_, orderline0_.pricelimit as priceli30_249_, orderline0_.linenetamt as linenet31_249_, orderline0_.discount as discoun32_249_, orderline0_.freightamt as freight33_249_, orderline0_.c_charge_id as c_charg34_249_, orderline0_.chargeamt as chargea35_249_, orderline0_.c_tax_id as c_tax_i36_249_, orderline0_.s_resourceassignment_id as s_resou37_249_, orderline0_.ref_orderline_id as ref_ord38_249_, orderline0_.m_attributesetinstance_id as m_attri39_249_, orderline0_.isdescription as isdescr40_249_, orderline0_.quantityorder as quantit41_249_, orderline0_.m_product_uom_id as m_produ42_249_, orderline0_.m_offer_id as m_offer43_249_, orderline0_.pricestd as pricest44_249_, orderline0_.cancelpricead as cancelp45_249_, orderline0_.c_order_discount_id as c_order46_249_, orderline0_.iseditlinenetamt as iseditl47_249_, orderline0_.taxbaseamt as taxbase48_249_, orderline0_.m_inoutline_id as m_inout49_249_, orderline0_.c_return_reason_id as c_retur50_249_, orderline0_.gross_unit_price as gross_u51_249_, orderline0_.line_gross_amount as line_gr52_249_, orderline0_.grosspricelist as grosspr53_249_, orderline0_.c_costcenter_id as c_costc54_249_, orderline0_.grosspricestd as grosspr55_249_, orderline0_.a_asset_id as a_asset56_249_, orderline0_.m_warehouse_rule_id as m_wareh57_249_, orderline0_.user1_id as user58_249_, orderline0_.quotationline_id as quotati59_249_, orderline0_.user2_id as user60_249_, orderline0_.create_reservation as create_61_249_, orderline0_.c_project_id as c_proje62_249_, orderline0_.so_res_status as so_res_63_249_, orderline0_.manage_reservation as manage_64_249_, orderline0_.manage_prereservation as manage_65_249_, orderline0_.explode as explode66_249_, orderline0_.bom_parent_id as bom_par67_249_, orderline0_.em_opxmp_purchase_bpartner_id as em_opxm68_249_, orderline0_.replacedorderline_id as replace69_249_, orderline0_.em_opxmp_costprice as em_opxm70_249_, orderline0_.print_description as print_d71_249_, orderline0_.em_opxmp_m_pl_version_id as em_opxm72_249_, orderline0_.overdue_return_days as overdue73_249_, orderline0_.em_opxmp_margen as em_opxm74_249_, orderline0_.relate_orderline as relate_75_249_, orderline0_.em_opxmp_poline_id as em_opxm76_249_, orderline0_.c_aum as c_aum77_249_, orderline0_.aumqty as aumqty78_249_, orderline0_.returnline as returnl79_249_ from c_orderline orderline0_ where orderline0_.c_order_id = ? and (orderline0_.ad_org_id in (...)) and (orderline0_.ad_client_id in (...)) order by orderline0_.line, orderline0_.c_orderline_id limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 13 09 5 0ms 0ms 10 14 0ms 0ms 11 70 0ms 0ms 12 283 0ms 0ms 13 26 0ms 0ms 16 32 0ms 0ms 12 0ms 765 0ms 0ms 0ms select this_.c_doctype_trl_id as c_doctyp1_207_0_, this_.c_doctype_id as c_doctyp2_207_0_, this_.ad_language as ad_langu3_207_0_, this_.ad_client_id as ad_clien4_207_0_, this_.ad_org_id as ad_org_i5_207_0_, this_.isactive as isactive6_207_0_, this_.created as created7_207_0_, this_.createdby as createdb8_207_0_, this_.updated as updated9_207_0_, this_.updatedby as updated10_207_0_, this_.name as name11_207_0_, this_.printname as printna12_207_0_, this_.documentnote as documen13_207_0_, this_.istranslated as istrans14_207_0_ from c_doctype_trl this_ where this_.c_doctype_id = ? and this_.ad_language = ? and this_.isactive = ? limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 13 08 38 0ms 0ms 09 110 0ms 0ms 10 105 0ms 0ms 11 201 0ms 0ms 12 107 0ms 0ms 13 131 0ms 0ms 14 29 0ms 0ms 15 30 0ms 0ms 16 14 0ms 0ms 13 0ms 127 0ms 0ms 0ms select documentty0_.c_doctype_id as c_doctyp2_207_1_, documentty0_.c_doctype_trl_id as c_doctyp1_207_1_, documentty0_.c_doctype_trl_id as c_doctyp1_207_0_, documentty0_.c_doctype_id as c_doctyp2_207_0_, documentty0_.ad_language as ad_langu3_207_0_, documentty0_.ad_client_id as ad_clien4_207_0_, documentty0_.ad_org_id as ad_org_i5_207_0_, documentty0_.isactive as isactive6_207_0_, documentty0_.created as created7_207_0_, documentty0_.createdby as createdb8_207_0_, documentty0_.updated as updated9_207_0_, documentty0_.updatedby as updated10_207_0_, documentty0_.name as name11_207_0_, documentty0_.printname as printna12_207_0_, documentty0_.documentnote as documen13_207_0_, documentty0_.istranslated as istrans14_207_0_ from c_doctype_trl documentty0_ where documentty0_.c_doctype_id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 13 12 115 0ms 0ms 13 12 0ms 0ms 14 0ms 4 0ms 0ms 0ms select adfieldgro0_.ad_fieldgroup_id as ad_field2_46_1_, adfieldgro0_.ad_fieldgroup_trl_id as ad_field1_46_1_, adfieldgro0_.ad_fieldgroup_trl_id as ad_field1_46_0_, adfieldgro0_.ad_fieldgroup_id as ad_field2_46_0_, adfieldgro0_.ad_language as ad_langu3_46_0_, adfieldgro0_.ad_client_id as ad_clien4_46_0_, adfieldgro0_.ad_org_id as ad_org_i5_46_0_, adfieldgro0_.isactive as isactive6_46_0_, adfieldgro0_.created as created7_46_0_, adfieldgro0_.createdby as createdb8_46_0_, adfieldgro0_.updated as updated9_46_0_, adfieldgro0_.updatedby as updated10_46_0_, adfieldgro0_.name as name11_46_0_, adfieldgro0_.istranslated as istrans12_46_0_ from ad_fieldgroup_trl adfieldgro0_ where adfieldgro0_.ad_fieldgroup_id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 13 09 4 0ms 0ms 15 0ms 15 0ms 0ms 0ms select c_import_e0_.c_import_entry_id as c_import1_227_, c_import_e0_.ad_client_id as ad_clien2_227_, c_import_e0_.ad_org_id as ad_org_i3_227_, c_import_e0_.isactive as isactive4_227_, c_import_e0_.created as created5_227_, c_import_e0_.createdby as createdb6_227_, c_import_e0_.updated as updated7_227_, c_import_e0_.updatedby as updatedb8_227_, c_import_e0_.imported as imported9_227_, c_import_e0_.jsoninfo as jsoninf10_227_, c_import_e0_.importstatus as imports11_227_, c_import_e0_.typeofdata as typeofd12_227_, c_import_e0_.errorinfo as errorin13_227_, c_import_e0_.ad_role_id as ad_role14_227_, c_import_e0_.createdtimestamp as created15_227_, c_import_e0_.responseinfo as respons16_227_ from c_import_entry c_import_e0_ where c_import_e0_.importstatus = ? and c_import_e0_.isactive = ? order by c_import_e0_.created limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 13 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 16 0ms 71 0ms 0ms 0ms select adlanguage0_.ad_language_id as ad_langu1_52_, adlanguage0_.ad_language as ad_langu2_52_, adlanguage0_.ad_client_id as ad_clien3_52_, adlanguage0_.ad_org_id as ad_org_i4_52_, adlanguage0_.isactive as isactive5_52_, adlanguage0_.created as created6_52_, adlanguage0_.createdby as createdb7_52_, adlanguage0_.updated as updated8_52_, adlanguage0_.updatedby as updatedb9_52_, adlanguage0_.name as name10_52_, adlanguage0_.languageiso as languag11_52_, adlanguage0_.countrycode as country12_52_, adlanguage0_.isbaselanguage as isbasel13_52_, adlanguage0_.issystemlanguage as issyste14_52_, adlanguage0_.processing as process15_52_, adlanguage0_.pixelsize as pixelsi16_52_, adlanguage0_.translatedby as transla17_52_, adlanguage0_.isrtl as isrtl18_52_ from ad_language adlanguage0_ where adlanguage0_.ad_language = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 13 08 3 0ms 0ms 09 8 0ms 0ms 10 7 0ms 0ms 11 11 0ms 0ms 12 5 0ms 0ms 13 14 0ms 0ms 14 4 0ms 0ms 15 9 0ms 0ms 16 3 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 2 0ms 0ms 17 0ms 2 0ms 0ms 0ms select invoice0_.c_invoice_id as c_invoic1_230_, invoice0_.ad_client_id as ad_clien2_230_, invoice0_.ad_org_id as ad_org_i3_230_, invoice0_.isactive as isactive4_230_, invoice0_.created as created5_230_, invoice0_.createdby as createdb6_230_, invoice0_.updated as updated7_230_, invoice0_.updatedby as updatedb8_230_, invoice0_.issotrx as issotrx9_230_, invoice0_.documentno as documen10_230_, invoice0_.docstatus as docstat11_230_, invoice0_.docaction as docacti12_230_, invoice0_.processing as process13_230_, invoice0_.processed as process14_230_, invoice0_.posted as posted15_230_, invoice0_.c_doctype_id as c_docty16_230_, invoice0_.c_doctypetarget_id as c_docty17_230_, invoice0_.c_order_id as c_order18_230_, invoice0_.description as descrip19_230_, invoice0_.isprinted as isprint20_230_, invoice0_.salesrep_id as salesre21_230_, invoice0_.dateinvoiced as dateinv22_230_, invoice0_.dateprinted as datepri23_230_, invoice0_.dateacct as dateacc24_230_, invoice0_.c_bpartner_id as c_bpart25_230_, invoice0_.c_bpartner_location_id as c_bpart26_230_, invoice0_.poreference as porefer27_230_, invoice0_.isdiscountprinted as isdisco28_230_, invoice0_.dateordered as dateord29_230_, invoice0_.c_currency_id as c_curre30_230_, invoice0_.c_paymentterm_id as c_payme31_230_, invoice0_.c_charge_id as c_charg32_230_, invoice0_.chargeamt as chargea33_230_, invoice0_.totallines as totalli34_230_, invoice0_.grandtotal as grandto35_230_, invoice0_.m_pricelist_id as m_price36_230_, invoice0_.istaxincluded as istaxin37_230_, invoice0_.c_campaign_id as c_campa38_230_, invoice0_.c_project_id as c_proje39_230_, invoice0_.c_activity_id as c_activ40_230_, invoice0_.createfrom as createf41_230_, invoice0_.generateto as generat42_230_, invoice0_.ad_user_id as ad_user43_230_, invoice0_.copyfrom as copyfro44_230_, invoice0_.isselfservice as isselfs45_230_, invoice0_.ad_orgtrx_id as ad_orgt46_230_, invoice0_.user1_id as user47_230_, invoice0_.user2_id as user48_230_, invoice0_.withholdingamount as withhol49_230_, invoice0_.taxdate as taxdate50_230_, invoice0_.c_withholding_id as c_withh51_230_, invoice0_.ispaid as ispaid52_230_, invoice0_.em_einv_generated as em_einv53_230_, invoice0_.totalpaid as totalpa54_230_, invoice0_.em_einv_sent as em_einv55_230_, invoice0_.outstandingamt as outstan56_230_, invoice0_.daystilldue as daystil57_230_, invoice0_.dueamt as dueamt58_230_, invoice0_.lastcalculatedondate as lastcal59_230_, invoice0_.fin_paymentmethod_id as fin_pay60_230_, invoice0_.fin_payment_priority_id as fin_pay61_230_, invoice0_.finalsettlement as finalse62_230_, invoice0_.daysoutstanding as daysout63_230_, invoice0_.percentageoverdue as percent64_230_, invoice0_.c_costcenter_id as c_costc65_230_, invoice0_.calculate_promotions as calcula66_230_, invoice0_.a_asset_id as a_asset67_230_, invoice0_.em_aprm_addpayment as em_aprm68_230_, invoice0_.iscashvat as iscashv69_230_, invoice0_.em_aprm_processinvoice as em_aprm70_230_, invoice0_.prepaymentamt as prepaym71_230_, invoice0_.createfromorders as createf72_230_, invoice0_.createfrominouts as createf73_230_, invoice0_.paidamtatinvoicing as paidamt74_230_, invoice0_.bpartner_extref as bpartne75_230_, invoice0_.em_opxcld_createlines as em_opxc76_230_ from c_invoice invoice0_ where invoice0_.c_bpartner_id = ? and invoice0_.grandtotal = ? and invoice0_.issotrx = ? and invoice0_.docstatus <> ? and (invoice0_.ad_org_id in (...)) and (invoice0_.ad_client_id in (...)) order by invoice0_.dateacct desc, invoice0_.c_invoice_id desc limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 13 13 2 0ms 0ms 18 0ms 20 0ms 0ms 0ms select ? as id from dual where exists ( select ? from ( select a.dateacct as dateacct from fin_finacc_transaction a where a.ad_client_id = ? and a.ad_org_id in (...) and a.posted = ? and a.processed = ? and (a.processing = ? or a.processing is null) and exists ( select ? from c_period p where a.dateacct >= p.startdate and a.dateacct < p.enddate + ? and exists ( select ? from c_periodcontrol pc where pc.c_period_id = p.c_period_id and ad_org_getperiodcontrolallow (a.ad_org_id) = pc.ad_org_id and pc.docbasetype = ? and pc.periodstatus = ?))) b where ? = ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 13 08 1 0ms 0ms 09 1 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms 14 2 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 22 1 0ms 0ms 19 0ms 24 0ms 0ms 0ms select attrsetvaluetype from m_product where m_product_id = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 13 08 1 0ms 0ms 09 9 0ms 0ms 11 3 0ms 0ms 12 3 0ms 0ms 13 6 0ms 0ms 14 2 0ms 0ms 20 0ms 21 0ms 0ms 0ms select acctschema0_.c_acctschema_table_doctype_id as c_acctsc1_152_, acctschema0_.c_acctschema_table_id as c_acctsc2_152_, acctschema0_.ad_client_id as ad_clien3_152_, acctschema0_.ad_org_id as ad_org_i4_152_, acctschema0_.isactive as isactive5_152_, acctschema0_.created as created6_152_, acctschema0_.createdby as createdb7_152_, acctschema0_.updated as updated8_152_, acctschema0_.updatedby as updatedb9_152_, acctschema0_.allownegative as allowne10_152_, acctschema0_.docbasetype as docbase11_152_, acctschema0_.ad_createfact_template_id as ad_crea12_152_ from c_acctschema_table_doctype acctschema0_ cross join c_acctschema_table financialm1_ where acctschema0_.c_acctschema_table_id = financialm1_.c_acctschema_table_id and financialm1_.c_acctschema_id = ? and financialm1_.ad_table_id = ? and acctschema0_.docbasetype = ? and (acctschema0_.ad_org_id in (...)) and (acctschema0_.ad_client_id in (...)) and acctschema0_.isactive = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 13 10 3 0ms 0ms 11 7 0ms 0ms 12 4 0ms 0ms 13 3 0ms 0ms 14 4 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 252,491 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 13 08 6,789 0ms 0ms 09 27,153 0ms 0ms 10 18,418 0ms 0ms 11 49,938 0ms 0ms 12 103,073 0ms 0ms 13 30,812 0ms 0ms 14 5,684 0ms 0ms 15 1,964 0ms 0ms 16 8,660 0ms 0ms 2 17,084 0ms 0ms 0ms 0ms select distinct addimensio0_.documentlevel as col_0_0_ from ad_dimension_mapping addimensio0_ where addimensio0_.ad_table_id = ? and addimensio0_.dimension = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 13 08 434 0ms 0ms 09 1,900 0ms 0ms 10 1,336 0ms 0ms 11 3,344 0ms 0ms 12 6,934 0ms 0ms 13 2,146 0ms 0ms 14 304 0ms 0ms 15 126 0ms 0ms 16 560 0ms 0ms 3 11,823 0ms 0ms 0ms 0ms select coalesce(t.msgtext, m.msgtext) as msgtext from ad_message m left join ad_message_trl t on m.ad_message_id = t.ad_message_id and t.ad_language = ? where m.value = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 13 07 720 0ms 0ms 08 729 0ms 0ms 09 801 0ms 0ms 10 974 0ms 0ms 11 864 0ms 0ms 12 846 0ms 0ms 13 908 0ms 0ms 14 736 0ms 0ms 15 825 0ms 0ms 16 742 0ms 0ms 17 741 0ms 0ms 18 741 0ms 0ms 19 729 0ms 0ms 20 729 0ms 0ms 21 729 0ms 0ms 22 9 0ms 0ms 4 11,686 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 13 07 127 0ms 0ms 08 477 0ms 0ms 09 1,157 0ms 0ms 10 1,430 0ms 0ms 11 2,245 0ms 0ms 12 2,372 0ms 0ms 13 1,720 0ms 0ms 14 588 0ms 0ms 15 430 0ms 0ms 16 332 0ms 0ms 17 291 0ms 0ms 18 129 0ms 0ms 19 128 0ms 0ms 20 128 0ms 0ms 21 128 0ms 0ms 22 4 0ms 0ms 5 11,653 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 13 07 130 0ms 0ms 08 478 0ms 0ms 09 1,152 0ms 0ms 10 1,428 0ms 0ms 11 2,221 0ms 0ms 12 2,356 0ms 0ms 13 1,715 0ms 0ms 14 585 0ms 0ms 15 432 0ms 0ms 16 334 0ms 0ms 17 294 0ms 0ms 18 132 0ms 0ms 19 131 0ms 0ms 20 131 0ms 0ms 21 131 0ms 0ms 22 3 0ms 0ms 6 8,542 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 13 08 217 0ms 0ms 09 950 0ms 0ms 10 668 0ms 0ms 11 1,672 0ms 0ms 12 3,467 0ms 0ms 13 1,073 0ms 0ms 14 152 0ms 0ms 15 63 0ms 0ms 16 280 0ms 0ms 7 6,937 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 13 08 235 0ms 0ms 09 722 0ms 0ms 10 881 0ms 0ms 11 1,565 0ms 0ms 12 1,744 0ms 0ms 13 1,123 0ms 0ms 14 308 0ms 0ms 15 146 0ms 0ms 16 149 0ms 0ms 17 64 0ms 0ms 8 5,872 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 13 07 60 0ms 0ms 08 251 0ms 0ms 09 596 0ms 0ms 10 622 0ms 0ms 11 1,184 0ms 0ms 12 1,407 0ms 0ms 13 850 0ms 0ms 14 254 0ms 0ms 15 155 0ms 0ms 16 177 0ms 0ms 17 63 0ms 0ms 18 63 0ms 0ms 19 62 0ms 0ms 20 62 0ms 0ms 21 62 0ms 0ms 22 4 0ms 0ms 9 5,342 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 13 08 201 0ms 0ms 09 512 0ms 0ms 10 665 0ms 0ms 11 1,364 0ms 0ms 12 1,242 0ms 0ms 13 908 0ms 0ms 14 285 0ms 0ms 15 47 0ms 0ms 16 118 0ms 0ms 10 2,822 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 #10
Day Hour Count Duration Avg duration Jul 13 08 111 0ms 0ms 09 335 0ms 0ms 10 306 0ms 0ms 11 651 0ms 0ms 12 780 0ms 0ms 13 374 0ms 0ms 14 123 0ms 0ms 15 64 0ms 0ms 16 78 0ms 0ms 11 2,795 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 #11
Day Hour Count Duration Avg duration Jul 13 08 84 0ms 0ms 09 280 0ms 0ms 10 185 0ms 0ms 11 547 0ms 0ms 12 1,144 0ms 0ms 13 356 0ms 0ms 14 76 0ms 0ms 15 29 0ms 0ms 16 94 0ms 0ms 12 2,773 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 13 08 101 0ms 0ms 09 260 0ms 0ms 10 371 0ms 0ms 11 704 0ms 0ms 12 644 0ms 0ms 13 463 0ms 0ms 14 147 0ms 0ms 15 24 0ms 0ms 16 59 0ms 0ms 13 2,681 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 #13
Day Hour Count Duration Avg duration Jul 13 08 107 0ms 0ms 09 279 0ms 0ms 10 296 0ms 0ms 11 604 0ms 0ms 12 766 0ms 0ms 13 425 0ms 0ms 14 103 0ms 0ms 15 31 0ms 0ms 16 70 0ms 0ms 14 2,636 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 #14
Day Hour Count Duration Avg duration Jul 13 08 193 0ms 0ms 09 465 0ms 0ms 10 310 0ms 0ms 11 311 0ms 0ms 13 582 0ms 0ms 15 620 0ms 0ms 16 155 0ms 0ms 15 2,582 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 #15
Day Hour Count Duration Avg duration Jul 13 09 343 0ms 0ms 10 343 0ms 0ms 11 1,029 0ms 0ms 12 524 0ms 0ms 13 343 0ms 0ms 16 2,252 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 #16
Day Hour Count Duration Avg duration Jul 13 08 87 0ms 0ms 09 226 0ms 0ms 10 293 0ms 0ms 11 541 0ms 0ms 12 554 0ms 0ms 13 375 0ms 0ms 14 81 0ms 0ms 15 39 0ms 0ms 16 56 0ms 0ms 17 2,199 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 #17
Day Hour Count Duration Avg duration Jul 13 08 86 0ms 0ms 09 242 0ms 0ms 10 257 0ms 0ms 11 519 0ms 0ms 12 523 0ms 0ms 13 356 0ms 0ms 14 109 0ms 0ms 15 50 0ms 0ms 16 50 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 2 0ms 0ms 18 2,156 0ms 0ms 0ms 0ms insert into ad_session_usage_audit (ad_session_usage_audit_id, ad_client_id, ad_org_id, createdby, updatedby, ad_session_id, object_id, ad_module_id, command, classname, object_type, process_time) values (get_uuid (), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, to_number(?));Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 13 08 63 0ms 0ms 09 212 0ms 0ms 10 234 0ms 0ms 11 546 0ms 0ms 12 570 0ms 0ms 13 336 0ms 0ms 14 122 0ms 0ms 15 24 0ms 0ms 16 49 0ms 0ms 19 2,138 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 #19
Day Hour Count Duration Avg duration Jul 13 07 60 0ms 0ms 08 99 0ms 0ms 09 170 0ms 0ms 10 185 0ms 0ms 11 311 0ms 0ms 12 466 0ms 0ms 13 249 0ms 0ms 14 101 0ms 0ms 15 94 0ms 0ms 16 101 0ms 0ms 17 61 0ms 0ms 18 61 0ms 0ms 19 60 0ms 0ms 20 60 0ms 0ms 21 60 0ms 0ms 20 2,098 0ms 0ms 0ms 0ms select ? from dual;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 13 07 120 0ms 0ms 08 126 0ms 0ms 09 150 0ms 0ms 10 165 0ms 0ms 11 189 0ms 0ms 12 193 0ms 0ms 13 164 0ms 0ms 14 138 0ms 0ms 15 125 0ms 0ms 16 124 0ms 0ms 17 121 0ms 0ms 18 120 0ms 0ms 19 120 0ms 0ms 20 120 0ms 0ms 21 121 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 16 0ms select ( case mo.action when ? then mo.ad_form_id when ? then mo.ad_process_id when ? then mo.ad_process_id when ? then mo.ad_callout_id when ? then mo.ad_reference_id else mo.ad_tab_id end) as ad_tab_id, mom.mappingname as tabname, mo.action from ad_model_object mo, ad_model_object_mapping mom where mo.ad_model_object_id = mom.ad_model_object_id and mo.isactive = ? and mom.isactive = ? and mom.isdefault = ? and upper(mo.classname) = upper(?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 13 10 8 0ms 0ms 11 3 0ms 0ms 12 4 0ms 0ms 13 1 0ms 0ms 2 0ms 0ms 0ms 2 0ms select count(distinct country2_.c_country_id) as col_0_0_ from c_bpartner_location businesspa0_ inner join c_location location1_ on businesspa0_.c_location_id = location1_.c_location_id inner join c_country country2_ on location1_.c_country_id = country2_.c_country_id where businesspa0_.c_bpartner_id = ? and businesspa0_.istaxlocation = ? and country2_.c_country_id <> ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 13 11 1 0ms 0ms 14 1 0ms 0ms 3 0ms 0ms 0ms 9 0ms select invoice0_.c_invoice_id as col_0_0_, invoice0_.documentno as col_1_0_, invoice0_.c_bpartner_id as col_2_0_, businesspa1_.name as col_3_0_, invoice0_.dateinvoiced as col_4_0_, invoice0_.grandtotal as col_5_0_, currency2_.iso_code as col_6_0_, financialm3_.name as col_7_0_, invoice0_.outstandingamt as col_8_0_, invoice0_.daystilldue as col_9_0_, invoice0_.dueamt as col_10_0_, organizati4_.name as col_11_0_ from c_invoice invoice0_ cross join c_bpartner businesspa1_ cross join c_currency currency2_ cross join c_paymentterm financialm3_ cross join ad_org organizati4_ where invoice0_.c_bpartner_id = businesspa1_.c_bpartner_id and invoice0_.c_currency_id = currency2_.c_currency_id and invoice0_.c_paymentterm_id = financialm3_.c_paymentterm_id and invoice0_.ad_org_id = organizati4_.ad_org_id and (businesspa1_.name like ?) and (invoice0_.documentno like ?) and invoice0_.processed = ? and invoice0_.docstatus <> ? and invoice0_.ispaid = ? and invoice0_.issotrx = ? and invoice0_.ad_client_id = ? and (invoice0_.ad_org_id in (...)) and (organizati4_.name like ?) and ? = ? order by invoice0_.dateinvoiced limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 13 09 4 0ms 0ms 10 1 0ms 0ms 13 3 0ms 0ms 16 1 0ms 0ms 4 0ms 0ms 0ms 257 0ms select case when sum(fpsd.amount) = ci.grandtotal then ? else ? end 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_invoice join c_invoice ci on ci.c_invoice_id = ps.c_invoice_id where ps.c_invoice_id = ? and to_number(aprm_seqnumberpaymentstatus (fp.status)) >= ? group by ci.grandtotal;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 13 09 33 0ms 0ms 10 49 0ms 0ms 11 61 0ms 0ms 12 83 0ms 0ms 13 31 0ms 0ms 5 0ms 0ms 0ms 68 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 = ? or coalesce(adpreferen0_.visibleat_client_id, ?) = ?) and (adpreferen0_.visibleat_role_id = ? or adpreferen0_.visibleat_role_id is null) and (coalesce(adpreferen0_.visibleat_org_id, ?) in (...)) and (adpreferen0_.ad_user_id = ? or adpreferen0_.ad_user_id is null) and (adpreferen0_.ad_window_id is null) and adpreferen0_.ispropertylist = ? and adpreferen0_.attribute = ? 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 #5
Day Hour Count Duration Avg duration Jul 13 09 38 0ms 0ms 13 30 0ms 0ms 6 0ms 0ms 0ms 1 0ms select orderlinet0_.c_orderlinetax_id as c_orderl1_253_0_, orderlinet0_.c_orderline_id as c_orderl2_253_0_, orderlinet0_.c_tax_id as c_tax_id3_253_0_, orderlinet0_.ad_client_id as ad_clien4_253_0_, orderlinet0_.ad_org_id as ad_org_i5_253_0_, orderlinet0_.isactive as isactive6_253_0_, orderlinet0_.created as created7_253_0_, orderlinet0_.createdby as createdb8_253_0_, orderlinet0_.updated as updated9_253_0_, orderlinet0_.updatedby as updated10_253_0_, orderlinet0_.taxbaseamt as taxbase11_253_0_, orderlinet0_.taxamt as taxamt12_253_0_, orderlinet0_.line as line13_253_0_, orderlinet0_.c_order_id as c_order14_253_0_ from c_orderlinetax orderlinet0_ where orderlinet0_.c_orderlinetax_id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 13 10 1 0ms 0ms 7 0ms 0ms 0ms 29 0ms select adtable1_.isfullyaudited as col_0_0_ from ad_tab adtab0_ cross join ad_table adtable1_ where adtab0_.ad_table_id = adtable1_.ad_table_id and adtab0_.ad_window_id = ? order by adtab0_.seqno, adtab0_.ad_tab_id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 13 08 3 0ms 0ms 09 7 0ms 0ms 10 3 0ms 0ms 11 5 0ms 0ms 13 5 0ms 0ms 14 1 0ms 0ms 15 4 0ms 0ms 16 1 0ms 0ms 8 0ms 0ms 0ms 4 0ms select * from ( select a_amortization_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 (?, a_amortization_id, ?) as record_id, posted from a_amortization where a_amortization.posted in (...) group by a_amortization_id, posted, ad_client_id, ad_org_id) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 13 15 2 0ms 0ms 21 2 0ms 0ms 9 0ms 0ms 0ms 12 0ms select c_costcenter_id, user1_id, user2_id from fin_payment where fin_payment_id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 13 10 1 0ms 0ms 11 4 0ms 0ms 12 1 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 10 0ms 0ms 0ms 2 0ms select c_order.c_order_id as document_id, c_order.docstatus as docstatus, c_order.documentno as ourreference, c_order.poreference as yourreference, c_order.salesrep_id as salesrep_user_id, salesrep.email as salesrep_email, salesrep.name as salesrep_name, c_order.c_bpartner_id as bpartner_id, c_bpartner.name as bpartner_name, c_order.ad_user_id as contact_user_id, customercontact.email as contact_email, customercontact.name as contact_name from c_order left join ad_user customercontact on c_order.ad_user_id = customercontact.ad_user_id left join ad_user salesrep on c_order.salesrep_id = salesrep.ad_user_id left join c_bpartner on c_order.c_bpartner_id = c_bpartner.c_bpartner_id where ? = ? and c_order.c_order_id in (...);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 13 09 1 0ms 0ms 11 1 0ms 0ms 11 0ms 0ms 0ms 430 0ms select orderline0_.c_orderline_id as c_orderl1_249_, orderline0_.ad_client_id as ad_clien2_249_, orderline0_.ad_org_id as ad_org_i3_249_, orderline0_.isactive as isactive4_249_, orderline0_.created as created5_249_, orderline0_.createdby as createdb6_249_, orderline0_.updated as updated7_249_, orderline0_.updatedby as updatedb8_249_, orderline0_.c_order_id as c_order_9_249_, orderline0_.line as line10_249_, orderline0_.c_bpartner_id as c_bpart11_249_, orderline0_.c_bpartner_location_id as c_bpart12_249_, orderline0_.dateordered as dateord13_249_, orderline0_.datepromised as datepro14_249_, orderline0_.datedelivered as datedel15_249_, orderline0_.dateinvoiced as dateinv16_249_, orderline0_.description as descrip17_249_, orderline0_.m_product_id as m_produ18_249_, orderline0_.m_warehouse_id as m_wareh19_249_, orderline0_.directship as directs20_249_, orderline0_.c_uom_id as c_uom_i21_249_, orderline0_.qtyordered as qtyorde22_249_, orderline0_.qtyreserved as qtyrese23_249_, orderline0_.qtydelivered as qtydeli24_249_, orderline0_.qtyinvoiced as qtyinvo25_249_, orderline0_.m_shipper_id as m_shipp26_249_, orderline0_.c_currency_id as c_curre27_249_, orderline0_.pricelist as priceli28_249_, orderline0_.priceactual as priceac29_249_, orderline0_.pricelimit as priceli30_249_, orderline0_.linenetamt as linenet31_249_, orderline0_.discount as discoun32_249_, orderline0_.freightamt as freight33_249_, orderline0_.c_charge_id as c_charg34_249_, orderline0_.chargeamt as chargea35_249_, orderline0_.c_tax_id as c_tax_i36_249_, orderline0_.s_resourceassignment_id as s_resou37_249_, orderline0_.ref_orderline_id as ref_ord38_249_, orderline0_.m_attributesetinstance_id as m_attri39_249_, orderline0_.isdescription as isdescr40_249_, orderline0_.quantityorder as quantit41_249_, orderline0_.m_product_uom_id as m_produ42_249_, orderline0_.m_offer_id as m_offer43_249_, orderline0_.pricestd as pricest44_249_, orderline0_.cancelpricead as cancelp45_249_, orderline0_.c_order_discount_id as c_order46_249_, orderline0_.iseditlinenetamt as iseditl47_249_, orderline0_.taxbaseamt as taxbase48_249_, orderline0_.m_inoutline_id as m_inout49_249_, orderline0_.c_return_reason_id as c_retur50_249_, orderline0_.gross_unit_price as gross_u51_249_, orderline0_.line_gross_amount as line_gr52_249_, orderline0_.grosspricelist as grosspr53_249_, orderline0_.c_costcenter_id as c_costc54_249_, orderline0_.grosspricestd as grosspr55_249_, orderline0_.a_asset_id as a_asset56_249_, orderline0_.m_warehouse_rule_id as m_wareh57_249_, orderline0_.user1_id as user58_249_, orderline0_.quotationline_id as quotati59_249_, orderline0_.user2_id as user60_249_, orderline0_.create_reservation as create_61_249_, orderline0_.c_project_id as c_proje62_249_, orderline0_.so_res_status as so_res_63_249_, orderline0_.manage_reservation as manage_64_249_, orderline0_.manage_prereservation as manage_65_249_, orderline0_.explode as explode66_249_, orderline0_.bom_parent_id as bom_par67_249_, orderline0_.em_opxmp_purchase_bpartner_id as em_opxm68_249_, orderline0_.replacedorderline_id as replace69_249_, orderline0_.em_opxmp_costprice as em_opxm70_249_, orderline0_.print_description as print_d71_249_, orderline0_.em_opxmp_m_pl_version_id as em_opxm72_249_, orderline0_.overdue_return_days as overdue73_249_, orderline0_.em_opxmp_margen as em_opxm74_249_, orderline0_.relate_orderline as relate_75_249_, orderline0_.em_opxmp_poline_id as em_opxm76_249_, orderline0_.c_aum as c_aum77_249_, orderline0_.aumqty as aumqty78_249_, orderline0_.returnline as returnl79_249_ from c_orderline orderline0_ where orderline0_.c_order_id = ? and (orderline0_.ad_org_id in (...)) and (orderline0_.ad_client_id in (...)) order by orderline0_.line, orderline0_.c_orderline_id limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 13 09 5 0ms 0ms 10 14 0ms 0ms 11 70 0ms 0ms 12 283 0ms 0ms 13 26 0ms 0ms 16 32 0ms 0ms 12 0ms 0ms 0ms 765 0ms select this_.c_doctype_trl_id as c_doctyp1_207_0_, this_.c_doctype_id as c_doctyp2_207_0_, this_.ad_language as ad_langu3_207_0_, this_.ad_client_id as ad_clien4_207_0_, this_.ad_org_id as ad_org_i5_207_0_, this_.isactive as isactive6_207_0_, this_.created as created7_207_0_, this_.createdby as createdb8_207_0_, this_.updated as updated9_207_0_, this_.updatedby as updated10_207_0_, this_.name as name11_207_0_, this_.printname as printna12_207_0_, this_.documentnote as documen13_207_0_, this_.istranslated as istrans14_207_0_ from c_doctype_trl this_ where this_.c_doctype_id = ? and this_.ad_language = ? and this_.isactive = ? limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 13 08 38 0ms 0ms 09 110 0ms 0ms 10 105 0ms 0ms 11 201 0ms 0ms 12 107 0ms 0ms 13 131 0ms 0ms 14 29 0ms 0ms 15 30 0ms 0ms 16 14 0ms 0ms 13 0ms 0ms 0ms 127 0ms select documentty0_.c_doctype_id as c_doctyp2_207_1_, documentty0_.c_doctype_trl_id as c_doctyp1_207_1_, documentty0_.c_doctype_trl_id as c_doctyp1_207_0_, documentty0_.c_doctype_id as c_doctyp2_207_0_, documentty0_.ad_language as ad_langu3_207_0_, documentty0_.ad_client_id as ad_clien4_207_0_, documentty0_.ad_org_id as ad_org_i5_207_0_, documentty0_.isactive as isactive6_207_0_, documentty0_.created as created7_207_0_, documentty0_.createdby as createdb8_207_0_, documentty0_.updated as updated9_207_0_, documentty0_.updatedby as updated10_207_0_, documentty0_.name as name11_207_0_, documentty0_.printname as printna12_207_0_, documentty0_.documentnote as documen13_207_0_, documentty0_.istranslated as istrans14_207_0_ from c_doctype_trl documentty0_ where documentty0_.c_doctype_id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 13 12 115 0ms 0ms 13 12 0ms 0ms 14 0ms 0ms 0ms 4 0ms select adfieldgro0_.ad_fieldgroup_id as ad_field2_46_1_, adfieldgro0_.ad_fieldgroup_trl_id as ad_field1_46_1_, adfieldgro0_.ad_fieldgroup_trl_id as ad_field1_46_0_, adfieldgro0_.ad_fieldgroup_id as ad_field2_46_0_, adfieldgro0_.ad_language as ad_langu3_46_0_, adfieldgro0_.ad_client_id as ad_clien4_46_0_, adfieldgro0_.ad_org_id as ad_org_i5_46_0_, adfieldgro0_.isactive as isactive6_46_0_, adfieldgro0_.created as created7_46_0_, adfieldgro0_.createdby as createdb8_46_0_, adfieldgro0_.updated as updated9_46_0_, adfieldgro0_.updatedby as updated10_46_0_, adfieldgro0_.name as name11_46_0_, adfieldgro0_.istranslated as istrans12_46_0_ from ad_fieldgroup_trl adfieldgro0_ where adfieldgro0_.ad_fieldgroup_id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 13 09 4 0ms 0ms 15 0ms 0ms 0ms 15 0ms select c_import_e0_.c_import_entry_id as c_import1_227_, c_import_e0_.ad_client_id as ad_clien2_227_, c_import_e0_.ad_org_id as ad_org_i3_227_, c_import_e0_.isactive as isactive4_227_, c_import_e0_.created as created5_227_, c_import_e0_.createdby as createdb6_227_, c_import_e0_.updated as updated7_227_, c_import_e0_.updatedby as updatedb8_227_, c_import_e0_.imported as imported9_227_, c_import_e0_.jsoninfo as jsoninf10_227_, c_import_e0_.importstatus as imports11_227_, c_import_e0_.typeofdata as typeofd12_227_, c_import_e0_.errorinfo as errorin13_227_, c_import_e0_.ad_role_id as ad_role14_227_, c_import_e0_.createdtimestamp as created15_227_, c_import_e0_.responseinfo as respons16_227_ from c_import_entry c_import_e0_ where c_import_e0_.importstatus = ? and c_import_e0_.isactive = ? order by c_import_e0_.created limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 13 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 16 0ms 0ms 0ms 71 0ms select adlanguage0_.ad_language_id as ad_langu1_52_, adlanguage0_.ad_language as ad_langu2_52_, adlanguage0_.ad_client_id as ad_clien3_52_, adlanguage0_.ad_org_id as ad_org_i4_52_, adlanguage0_.isactive as isactive5_52_, adlanguage0_.created as created6_52_, adlanguage0_.createdby as createdb7_52_, adlanguage0_.updated as updated8_52_, adlanguage0_.updatedby as updatedb9_52_, adlanguage0_.name as name10_52_, adlanguage0_.languageiso as languag11_52_, adlanguage0_.countrycode as country12_52_, adlanguage0_.isbaselanguage as isbasel13_52_, adlanguage0_.issystemlanguage as issyste14_52_, adlanguage0_.processing as process15_52_, adlanguage0_.pixelsize as pixelsi16_52_, adlanguage0_.translatedby as transla17_52_, adlanguage0_.isrtl as isrtl18_52_ from ad_language adlanguage0_ where adlanguage0_.ad_language = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 13 08 3 0ms 0ms 09 8 0ms 0ms 10 7 0ms 0ms 11 11 0ms 0ms 12 5 0ms 0ms 13 14 0ms 0ms 14 4 0ms 0ms 15 9 0ms 0ms 16 3 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 2 0ms 0ms 17 0ms 0ms 0ms 2 0ms select invoice0_.c_invoice_id as c_invoic1_230_, invoice0_.ad_client_id as ad_clien2_230_, invoice0_.ad_org_id as ad_org_i3_230_, invoice0_.isactive as isactive4_230_, invoice0_.created as created5_230_, invoice0_.createdby as createdb6_230_, invoice0_.updated as updated7_230_, invoice0_.updatedby as updatedb8_230_, invoice0_.issotrx as issotrx9_230_, invoice0_.documentno as documen10_230_, invoice0_.docstatus as docstat11_230_, invoice0_.docaction as docacti12_230_, invoice0_.processing as process13_230_, invoice0_.processed as process14_230_, invoice0_.posted as posted15_230_, invoice0_.c_doctype_id as c_docty16_230_, invoice0_.c_doctypetarget_id as c_docty17_230_, invoice0_.c_order_id as c_order18_230_, invoice0_.description as descrip19_230_, invoice0_.isprinted as isprint20_230_, invoice0_.salesrep_id as salesre21_230_, invoice0_.dateinvoiced as dateinv22_230_, invoice0_.dateprinted as datepri23_230_, invoice0_.dateacct as dateacc24_230_, invoice0_.c_bpartner_id as c_bpart25_230_, invoice0_.c_bpartner_location_id as c_bpart26_230_, invoice0_.poreference as porefer27_230_, invoice0_.isdiscountprinted as isdisco28_230_, invoice0_.dateordered as dateord29_230_, invoice0_.c_currency_id as c_curre30_230_, invoice0_.c_paymentterm_id as c_payme31_230_, invoice0_.c_charge_id as c_charg32_230_, invoice0_.chargeamt as chargea33_230_, invoice0_.totallines as totalli34_230_, invoice0_.grandtotal as grandto35_230_, invoice0_.m_pricelist_id as m_price36_230_, invoice0_.istaxincluded as istaxin37_230_, invoice0_.c_campaign_id as c_campa38_230_, invoice0_.c_project_id as c_proje39_230_, invoice0_.c_activity_id as c_activ40_230_, invoice0_.createfrom as createf41_230_, invoice0_.generateto as generat42_230_, invoice0_.ad_user_id as ad_user43_230_, invoice0_.copyfrom as copyfro44_230_, invoice0_.isselfservice as isselfs45_230_, invoice0_.ad_orgtrx_id as ad_orgt46_230_, invoice0_.user1_id as user47_230_, invoice0_.user2_id as user48_230_, invoice0_.withholdingamount as withhol49_230_, invoice0_.taxdate as taxdate50_230_, invoice0_.c_withholding_id as c_withh51_230_, invoice0_.ispaid as ispaid52_230_, invoice0_.em_einv_generated as em_einv53_230_, invoice0_.totalpaid as totalpa54_230_, invoice0_.em_einv_sent as em_einv55_230_, invoice0_.outstandingamt as outstan56_230_, invoice0_.daystilldue as daystil57_230_, invoice0_.dueamt as dueamt58_230_, invoice0_.lastcalculatedondate as lastcal59_230_, invoice0_.fin_paymentmethod_id as fin_pay60_230_, invoice0_.fin_payment_priority_id as fin_pay61_230_, invoice0_.finalsettlement as finalse62_230_, invoice0_.daysoutstanding as daysout63_230_, invoice0_.percentageoverdue as percent64_230_, invoice0_.c_costcenter_id as c_costc65_230_, invoice0_.calculate_promotions as calcula66_230_, invoice0_.a_asset_id as a_asset67_230_, invoice0_.em_aprm_addpayment as em_aprm68_230_, invoice0_.iscashvat as iscashv69_230_, invoice0_.em_aprm_processinvoice as em_aprm70_230_, invoice0_.prepaymentamt as prepaym71_230_, invoice0_.createfromorders as createf72_230_, invoice0_.createfrominouts as createf73_230_, invoice0_.paidamtatinvoicing as paidamt74_230_, invoice0_.bpartner_extref as bpartne75_230_, invoice0_.em_opxcld_createlines as em_opxc76_230_ from c_invoice invoice0_ where invoice0_.c_bpartner_id = ? and invoice0_.grandtotal = ? and invoice0_.issotrx = ? and invoice0_.docstatus <> ? and (invoice0_.ad_org_id in (...)) and (invoice0_.ad_client_id in (...)) order by invoice0_.dateacct desc, invoice0_.c_invoice_id desc limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 13 13 2 0ms 0ms 18 0ms 0ms 0ms 20 0ms select ? as id from dual where exists ( select ? from ( select a.dateacct as dateacct from fin_finacc_transaction a where a.ad_client_id = ? and a.ad_org_id in (...) and a.posted = ? and a.processed = ? and (a.processing = ? or a.processing is null) and exists ( select ? from c_period p where a.dateacct >= p.startdate and a.dateacct < p.enddate + ? and exists ( select ? from c_periodcontrol pc where pc.c_period_id = p.c_period_id and ad_org_getperiodcontrolallow (a.ad_org_id) = pc.ad_org_id and pc.docbasetype = ? and pc.periodstatus = ?))) b where ? = ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 13 08 1 0ms 0ms 09 1 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms 14 2 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 22 1 0ms 0ms 19 0ms 0ms 0ms 24 0ms select attrsetvaluetype from m_product where m_product_id = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 13 08 1 0ms 0ms 09 9 0ms 0ms 11 3 0ms 0ms 12 3 0ms 0ms 13 6 0ms 0ms 14 2 0ms 0ms 20 0ms 0ms 0ms 21 0ms select acctschema0_.c_acctschema_table_doctype_id as c_acctsc1_152_, acctschema0_.c_acctschema_table_id as c_acctsc2_152_, acctschema0_.ad_client_id as ad_clien3_152_, acctschema0_.ad_org_id as ad_org_i4_152_, acctschema0_.isactive as isactive5_152_, acctschema0_.created as created6_152_, acctschema0_.createdby as createdb7_152_, acctschema0_.updated as updated8_152_, acctschema0_.updatedby as updatedb9_152_, acctschema0_.allownegative as allowne10_152_, acctschema0_.docbasetype as docbase11_152_, acctschema0_.ad_createfact_template_id as ad_crea12_152_ from c_acctschema_table_doctype acctschema0_ cross join c_acctschema_table financialm1_ where acctschema0_.c_acctschema_table_id = financialm1_.c_acctschema_table_id and financialm1_.c_acctschema_id = ? and financialm1_.ad_table_id = ? and acctschema0_.docbasetype = ? and (acctschema0_.ad_org_id in (...)) and (acctschema0_.ad_client_id in (...)) and acctschema0_.isactive = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 13 10 3 0ms 0ms 11 7 0ms 0ms 12 4 0ms 0ms 13 3 0ms 0ms 14 4 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 3s872ms 1 3s872ms 3s872ms 3s872ms select array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') as col_0_0_, array_to_string(array_agg(order3_.DocumentNo), ',') as col_1_0_, case when invoice7_.IsSOTrx = 'N' and (organizati11_.AD_Org_ID is not null) and (organizati11_.EM_Aprm_Payment_Desc like 'Supplier Reference') then invoice7_.POReference else invoice7_.DocumentNo end as col_2_0_, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID) as col_3_0_, coalesce(fin_paymen9_.Name, fin_paymen5_.Name) as col_4_0_, coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate) as col_5_0_, max(coalesce(fin_paymen6_.Amount, fin_paymen2_.Amount)) as col_6_0_, max(coalesce(invoice7_.GrandTotal, 0)) as col_7_0_, aduser14_.UserName as col_8_0_, aduser16_.UserName as col_9_0_, invoice7_.Created as col_10_0_, invoice7_.Updated as col_11_0_, businesspa1_.C_BPartner_ID as col_12_0_, businesspa1_.Name as col_13_0_, sum(fin_paymen0_.Amount + fin_paymen0_.Writeoffamt) as col_14_0_, coalesce(sum(fin_paymen12_.Amount), 0) as col_15_0_, case when sum(fin_paymen0_.Writeoffamt) <> 0 then true else false end as col_16_0_, case when max(fin_paymen13_.Fin_Payment_ID) is not null then true else false end as col_17_0_ from FIN_Payment_ScheduleDetail fin_paymen0_ inner join C_BPartner businesspa1_ on fin_paymen0_.C_Bpartner_ID = businesspa1_.C_BPartner_ID left outer join FIN_Payment_Schedule fin_paymen2_ on fin_paymen0_.FIN_Payment_Schedule_Order = fin_paymen2_.Fin_Payment_Schedule_ID left outer join C_Order order3_ on fin_paymen2_.C_Order_ID = order3_.C_Order_ID and (order3_.IsSOTrx = $1 and order3_.C_Currency_ID = $2 and order3_.C_BPartner_ID = $3) left outer join FIN_Payment_Priority fin_paymen4_ on fin_paymen2_.FIN_Payment_Priority_ID = fin_paymen4_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen5_ on fin_paymen2_.Fin_Paymentmethod_ID = fin_paymen5_.Fin_Paymentmethod_ID left outer join FIN_Payment_Schedule fin_paymen6_ on fin_paymen0_.FIN_Payment_Schedule_Invoice = fin_paymen6_.Fin_Payment_Schedule_ID left outer join C_Invoice invoice7_ on fin_paymen6_.C_Invoice_ID = invoice7_.C_Invoice_ID and (invoice7_.IsSOTrx = $4 and invoice7_.C_Currency_ID = $5 and invoice7_.C_BPartner_ID = $6) left outer join FIN_Payment_Priority fin_paymen8_ on fin_paymen6_.FIN_Payment_Priority_ID = fin_paymen8_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen9_ on fin_paymen6_.Fin_Paymentmethod_ID = fin_paymen9_.Fin_Paymentmethod_ID left outer join AD_Org organizati10_ on fin_paymen0_.AD_Org_ID = organizati10_.AD_Org_ID left outer join AD_OrgInfo organizati11_ on organizati10_.AD_Org_ID = organizati11_.AD_Org_ID left outer join FIN_Payment_Detail fin_paymen12_ on fin_paymen0_.FIN_Payment_Detail_ID = fin_paymen12_.Fin_Payment_Detail_ID left outer join FIN_Payment fin_paymen13_ on fin_paymen12_.Fin_Payment_ID = fin_paymen13_.Fin_Payment_ID left outer join AD_User aduser14_ on invoice7_.CreatedBy = aduser14_.AD_User_ID left outer join AD_User aduser15_ on order3_.CreatedBy = aduser15_.AD_User_ID left outer join AD_User aduser16_ on invoice7_.UpdatedBy = aduser16_.AD_User_ID left outer join AD_User aduser17_ on order3_.UpdatedBy = aduser17_.AD_User_ID where (fin_paymen0_.AD_Client_ID in ('0', $7)) and (fin_paymen0_.FIN_Payment_Detail_ID is null) and (coalesce(fin_paymen6_.Fin_Payment_Schedule_ID, fin_paymen2_.Fin_Payment_Schedule_ID) is not null) and (fin_paymen0_.AD_Org_ID in ($8)) and (organizati11_.AD_Org_ID is null or organizati11_.IsActive = 'Y') and invoice7_.IsSOTrx = $9 and invoice7_.C_Currency_ID = $10 and businesspa1_.C_BPartner_ID = $11 group by invoice7_.C_Invoice_ID, invoice7_.DocumentNo, invoice7_.C_DocType_ID, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID), coalesce(fin_paymen9_.Name, fin_paymen5_.Name), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), invoice7_.IsSOTrx, organizati11_.AD_Org_ID, organizati11_.EM_Aprm_Payment_Desc, invoice7_.POReference, aduser14_.UserName, aduser16_.UserName, invoice7_.Created, invoice7_.Updated, businesspa1_.C_BPartner_ID, businesspa1_.Name having upper(coalesce(fin_paymen9_.Name, fin_paymen5_.Name)) like upper($12) escape '|' order by case when max(invoice7_.C_Invoice_ID) = '836A5F6E13174A06A5174419FC1657C6' then 0 else 1 end, coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), invoice7_.DocumentNo limit $13;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 13 09 1 3s872ms 3s872ms -
select array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') as col_0_0_, array_to_string(array_agg(order3_.DocumentNo), ',') as col_1_0_, case when invoice7_.IsSOTrx = 'N' and (organizati11_.AD_Org_ID is not null) and (organizati11_.EM_Aprm_Payment_Desc like 'Supplier Reference') then invoice7_.POReference else invoice7_.DocumentNo end as col_2_0_, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID) as col_3_0_, coalesce(fin_paymen9_.Name, fin_paymen5_.Name) as col_4_0_, coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate) as col_5_0_, max(coalesce(fin_paymen6_.Amount, fin_paymen2_.Amount)) as col_6_0_, max(coalesce(invoice7_.GrandTotal, 0)) as col_7_0_, aduser14_.UserName as col_8_0_, aduser16_.UserName as col_9_0_, invoice7_.Created as col_10_0_, invoice7_.Updated as col_11_0_, businesspa1_.C_BPartner_ID as col_12_0_, businesspa1_.Name as col_13_0_, sum(fin_paymen0_.Amount + fin_paymen0_.Writeoffamt) as col_14_0_, coalesce(sum(fin_paymen12_.Amount), 0) as col_15_0_, case when sum(fin_paymen0_.Writeoffamt) <> 0 then true else false end as col_16_0_, case when max(fin_paymen13_.Fin_Payment_ID) is not null then true else false end as col_17_0_ from FIN_Payment_ScheduleDetail fin_paymen0_ inner join C_BPartner businesspa1_ on fin_paymen0_.C_Bpartner_ID = businesspa1_.C_BPartner_ID left outer join FIN_Payment_Schedule fin_paymen2_ on fin_paymen0_.FIN_Payment_Schedule_Order = fin_paymen2_.Fin_Payment_Schedule_ID left outer join C_Order order3_ on fin_paymen2_.C_Order_ID = order3_.C_Order_ID and (order3_.IsSOTrx = $1 and order3_.C_Currency_ID = $2 and order3_.C_BPartner_ID = $3) left outer join FIN_Payment_Priority fin_paymen4_ on fin_paymen2_.FIN_Payment_Priority_ID = fin_paymen4_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen5_ on fin_paymen2_.Fin_Paymentmethod_ID = fin_paymen5_.Fin_Paymentmethod_ID left outer join FIN_Payment_Schedule fin_paymen6_ on fin_paymen0_.FIN_Payment_Schedule_Invoice = fin_paymen6_.Fin_Payment_Schedule_ID left outer join C_Invoice invoice7_ on fin_paymen6_.C_Invoice_ID = invoice7_.C_Invoice_ID and (invoice7_.IsSOTrx = $4 and invoice7_.C_Currency_ID = $5 and invoice7_.C_BPartner_ID = $6) left outer join FIN_Payment_Priority fin_paymen8_ on fin_paymen6_.FIN_Payment_Priority_ID = fin_paymen8_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen9_ on fin_paymen6_.Fin_Paymentmethod_ID = fin_paymen9_.Fin_Paymentmethod_ID left outer join AD_Org organizati10_ on fin_paymen0_.AD_Org_ID = organizati10_.AD_Org_ID left outer join AD_OrgInfo organizati11_ on organizati10_.AD_Org_ID = organizati11_.AD_Org_ID left outer join FIN_Payment_Detail fin_paymen12_ on fin_paymen0_.FIN_Payment_Detail_ID = fin_paymen12_.Fin_Payment_Detail_ID left outer join FIN_Payment fin_paymen13_ on fin_paymen12_.Fin_Payment_ID = fin_paymen13_.Fin_Payment_ID left outer join AD_User aduser14_ on invoice7_.CreatedBy = aduser14_.AD_User_ID left outer join AD_User aduser15_ on order3_.CreatedBy = aduser15_.AD_User_ID left outer join AD_User aduser16_ on invoice7_.UpdatedBy = aduser16_.AD_User_ID left outer join AD_User aduser17_ on order3_.UpdatedBy = aduser17_.AD_User_ID where (fin_paymen0_.AD_Client_ID in ('0', $7)) and (fin_paymen0_.FIN_Payment_Detail_ID is null) and (coalesce(fin_paymen6_.Fin_Payment_Schedule_ID, fin_paymen2_.Fin_Payment_Schedule_ID) is not null) and (fin_paymen0_.AD_Org_ID in ($8)) and (organizati11_.AD_Org_ID is null or organizati11_.IsActive = 'Y') and invoice7_.IsSOTrx = $9 and invoice7_.C_Currency_ID = $10 and businesspa1_.C_BPartner_ID = $11 group by invoice7_.C_Invoice_ID, invoice7_.DocumentNo, invoice7_.C_DocType_ID, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID), coalesce(fin_paymen9_.Name, fin_paymen5_.Name), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), invoice7_.IsSOTrx, organizati11_.AD_Org_ID, organizati11_.EM_Aprm_Payment_Desc, invoice7_.POReference, aduser14_.UserName, aduser16_.UserName, invoice7_.Created, invoice7_.Updated, businesspa1_.C_BPartner_ID, businesspa1_.Name having upper(coalesce(fin_paymen9_.Name, fin_paymen5_.Name)) like upper($12) escape '|' order by case when max(invoice7_.C_Invoice_ID) = '836A5F6E13174A06A5174419FC1657C6' then 0 else 1 end, coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), invoice7_.DocumentNo limit $13;
Date: 2026-07-13 09:49:04 Duration: 3s872ms Database: postgres User: etendo Remote: tad Application: 127.0.0.1 Queryid: openbravo parameters: $1 = 'Y', $2 = '102', $3 = '8F9EC7B675B84DD3892C99DF18842C44', $4 = 'Y', $5 = '102', $6 = '8F9EC7B675B84DD3892C99DF18842C44', $7 = '44FE6AC078E14A6CA5A1189E01E67FB5', $8 = '0068C08A9E6E4F5DABD3DE8DF501F3AE', $9 = 'Y', $10 = '102', $11 = '8F9EC7B675B84DD3892C99DF18842C44', $12 = '%Transferencia%', $13 = '101'
2 1s432ms 1 1s432ms 1s432ms 1s432ms SELECT COUNT(*) AS TOTAL FROM AD_SESSION WHERE AD_SESSION_ID = $1 AND SESSION_ACTIVE = 'Y' AND ISACTIVE = 'Y';Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 06 1 1s432ms 1s432ms -
SELECT COUNT(*) AS TOTAL FROM AD_SESSION WHERE AD_SESSION_ID = $1 AND SESSION_ACTIVE = 'Y' AND ISACTIVE = 'Y';
Date: 2026-07-13 09:49:02 Duration: 1s432ms Database: postgres User: etendo Remote: tad Application: 127.0.0.1 Queryid: openbravo parameters: $1 = 'D6398DA064FA4D03A5E40088E53D9712'
3 1s155ms 1 1s155ms 1s155ms 1s155ms SELECT C_ORDER.C_ORDER_ID, creador.name as creador, C_BPARTNER.NAME AS CB_NAME, L.ADDRESS1 AS L_ADDRESS1, L.POSTAL AS L_POSTAL, L.CITY AS L_CITY, R.NAME AS R_NAME, ( SELECT CBPL.PHONE FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.BILLTO_ID) AS PHONE, C_BPARTNER_LOCATION.FAX, C_BPARTNER.URL, C_ORDER.DESCRIPTION, C_ORDER.POREFERENCE, C_ORDER.DATEORDERED, C_ORDER.DOCUMENTNO AS PEDIDO, C_BPARTNER.NAME2 || ' (' || C_BPARTNER.NAME || ')' AS COMPLETE_NAME, AD_CLIENT.DESCRIPTION AS ENTITY, C_LOCATION_DESCRIPTION (AD_ORGINFO.C_LOCATION_ID) AS LOCATION, AD_ORG.ad_org_id AS ORGANIZATIONID, C_ORDER.docstatus AS STATUS, AD_USER.NAME AS AD_NAME, C_BPARTNER.TAXID, ADDRESS1, POSTAL, L.CITY, CO.NAME, AD_ORGINFO.TAXID AS ORG_TAXID, SHOWLOGO, SHOWCOMPANYDATA, HEADERMARGIN, AD_ORG.NAME AS ORG_NAME, DELIVERYRULE.NAME AS DELIVERYTERM, PAYMENTTERM.TERM AS PAYMENTTERM, C_POC_DOCTYPE_TEMPLATE.NAME AS DOC_TYPE, C_CURRENCY.ISO_CODE AS CURRENCY_ISO, M_PRICELIST.ISTAXINCLUDED, C_ORDER.ISSOTRX AS ISSOTRX, C_BPARTNER.NAME2 AS NAME2, ( SELECT NAME FROM C_BPARTNER WHERE C_BPARTNER_ID = C_ORDER.EM_OPXMP_DISENADOR_ID) AS DISENADOR, C_ORDER.EM_OPXMP_ESTADO AS ESTADO, ( SELECT CL.ADDRESS1 FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.DELIVERY_LOCATION_ID) AS DIRENTREGA, ( SELECT CL.POSTAL FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.DELIVERY_LOCATION_ID) AS POSTALENTREGA, ( SELECT CL.CITY FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.DELIVERY_LOCATION_ID) AS CITYENTREGA, ( SELECT CBPL.NAME FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.DELIVERY_LOCATION_ID) AS NAMEDIRENTREGA, ( SELECT CL.ADDRESS1 FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.BILLTO_ID) AS DIRFACT, ( SELECT CL.POSTAL FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.BILLTO_ID) AS POSTALFACT, ( SELECT CL.CITY FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.BILLTO_ID) AS CITYFACT, ( SELECT CBPL.NAME FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.BILLTO_ID) AS NAMEDIRFACT, ( SELECT CBPL.PHONE FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.DELIVERY_LOCATION_ID) AS TELF, ( SELECT CBPL.EM_OPXMP_CONTACTO FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.DELIVERY_LOCATION_ID) AS CONTACTO, ( SELECT CBPL.EM_OPXMP_EMAIL FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.DELIVERY_LOCATION_ID) AS EMAIL FROM C_BPARTNER_LOCATION left join C_LOCATION L on C_BPARTNER_LOCATION.C_LOCATION_ID = L.C_LOCATION_ID left join C_COUNTRY CO ON L.C_COUNTRY_ID = CO.C_COUNTRY_ID left join C_REGION R on L.C_REGION_ID = R.C_REGION_ID, AD_USER right join C_ORDER on AD_USER.AD_USER_ID = C_ORDER.AD_USER_ID left join AD_USER creador on creador.ad_user_id = C_ORDER.createdby left join C_POC_DOCTYPE_TEMPLATE ON C_POC_DOCTYPE_TEMPLATE.C_DOCTYPE_ID = C_ORDER.C_DOCTYPETARGET_ID, C_BPARTNER, AD_ORGINFO, AD_CLIENT, AD_ORG, ( SELECT VALUE, NAME FROM AD_REF_LIST_V WHERE AD_REFERENCE_ID = '151' AND AD_LANGUAGE IN ($1)) DELIVERYRULE, ( SELECT C_PAYMENTTERM.C_PAYMENTTERM_ID, COALESCE(C_PAYMENTTERM_TRL.NAME, C_PAYMENTTERM.NAME) AS TERM FROM C_PAYMENTTERM LEFT JOIN C_PAYMENTTERM_TRL ON C_PAYMENTTERM.C_PAYMENTTERM_ID = C_PAYMENTTERM_TRL.C_PAYMENTTERM_ID AND C_PAYMENTTERM_TRL.AD_LANGUAGE IN ($2)) PAYMENTTERM, C_CURRENCY, M_PRICELIST WHERE C_ORDER.C_BPARTNER_LOCATION_ID = C_BPARTNER_LOCATION.C_BPARTNER_LOCATION_ID AND C_ORDER.M_PRICELIST_ID = M_PRICELIST.M_PRICELIST_ID AND C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND AD_ORG.ad_org_id = AD_ORGINFO.ad_org_id AND AD_ORG.ad_org_id = ( SELECT o.AD_ORG_ID FROM AD_ORG o JOIN AD_OrgType t USING (AD_ORGTYPE_ID) WHERE AD_ISORGINCLUDED (C_ORDER.AD_ORG_ID, o.ad_org_id, C_ORDER.ad_client_id) <> - 1 AND (t.IsLegalEntity = 'Y' OR t.IsAcctLegalEntity = 'Y')) AND C_ORDER.AD_CLIENT_ID = AD_CLIENT.AD_CLIENT_ID AND C_ORDER.C_ORDER_ID IN ($3) AND C_ORDER.DELIVERYRULE = DELIVERYRULE.VALUE AND C_ORDER.C_PAYMENTTERM_ID = PAYMENTTERM.C_PAYMENTTERM_ID AND C_CURRENCY.C_CURRENCY_ID = C_ORDER.C_CURRENCY_ID GROUP BY C_ORDER.C_ORDER_ID, creador.name, C_BPARTNER.NAME, L.ADDRESS1, L.POSTAL, L.CITY, R.NAME, C_BPARTNER_LOCATION.PHONE, C_BPARTNER_LOCATION.FAX, C_BPARTNER.URL, C_ORDER.DESCRIPTION, C_ORDER.POREFERENCE, C_ORDER.DATEORDERED, C_ORDER.DOCUMENTNO, C_BPARTNER.NAME2 || ' (' || C_BPARTNER.NAME || ')', AD_CLIENT.DESCRIPTION, C_LOCATION_DESCRIPTION (AD_ORGINFO.C_LOCATION_ID), AD_ORG.ad_org_id, C_ORDER.docstatus, AD_USER.NAME, C_BPARTNER.TAXID, ADDRESS1, POSTAL, L.CITY, CO.NAME, AD_ORGINFO.TAXID, SHOWLOGO, SHOWCOMPANYDATA, HEADERMARGIN, AD_ORG.NAME, DELIVERYRULE.NAME, PAYMENTTERM.TERM, C_POC_DOCTYPE_TEMPLATE.NAME, C_CURRENCY.ISO_CODE, M_PRICELIST.ISTAXINCLUDED, C_ORDER.ISSOTRX, NAME2, C_ORDER.EM_OPXMP_DISENADOR_ID, C_ORDER.EM_OPXMP_ESTADO, C_ORDER.DELIVERY_LOCATION_ID, C_BPARTNER_LOCATION.PHONE, C_BPARTNER_LOCATION.EM_OPXMP_CONTACTO, C_BPARTNER_LOCATION.EM_OPXMP_EMAIL, C_BPARTNER_LOCATION.NAME, C_ORDER.BILLTO_ID ORDER BY C_ORDER.C_ORDER_ID, C_BPARTNER.NAME, L.ADDRESS1, L.POSTAL, L.CITY, R.NAME, C_BPARTNER_LOCATION.PHONE, C_BPARTNER_LOCATION.FAX, C_BPARTNER.URL, C_ORDER.DESCRIPTION, C_ORDER.POREFERENCE, C_ORDER.DATEORDERED, C_ORDER.DOCUMENTNO, C_BPARTNER.NAME2 || ' (' || C_BPARTNER.NAME || ')', AD_CLIENT.DESCRIPTION, C_LOCATION_DESCRIPTION (AD_ORGINFO.C_LOCATION_ID), AD_ORG.ad_org_id, C_ORDER.docstatus, AD_USER.NAME, C_BPARTNER.TAXID, ADDRESS1, POSTAL, L.CITY, CO.NAME, AD_ORGINFO.TAXID, SHOWLOGO, SHOWCOMPANYDATA, HEADERMARGIN, AD_ORG.NAME, DELIVERYRULE.NAME, PAYMENTTERM.TERM, C_POC_DOCTYPE_TEMPLATE.NAME, C_CURRENCY.ISO_CODE, M_PRICELIST.ISTAXINCLUDED, C_ORDER.ISSOTRX;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 05 1 1s155ms 1s155ms -
SELECT C_ORDER.C_ORDER_ID, creador.name as creador, C_BPARTNER.NAME AS CB_NAME, L.ADDRESS1 AS L_ADDRESS1, L.POSTAL AS L_POSTAL, L.CITY AS L_CITY, R.NAME AS R_NAME, ( SELECT CBPL.PHONE FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.BILLTO_ID) AS PHONE, C_BPARTNER_LOCATION.FAX, C_BPARTNER.URL, C_ORDER.DESCRIPTION, C_ORDER.POREFERENCE, C_ORDER.DATEORDERED, C_ORDER.DOCUMENTNO AS PEDIDO, C_BPARTNER.NAME2 || ' (' || C_BPARTNER.NAME || ')' AS COMPLETE_NAME, AD_CLIENT.DESCRIPTION AS ENTITY, C_LOCATION_DESCRIPTION (AD_ORGINFO.C_LOCATION_ID) AS LOCATION, AD_ORG.ad_org_id AS ORGANIZATIONID, C_ORDER.docstatus AS STATUS, AD_USER.NAME AS AD_NAME, C_BPARTNER.TAXID, ADDRESS1, POSTAL, L.CITY, CO.NAME, AD_ORGINFO.TAXID AS ORG_TAXID, SHOWLOGO, SHOWCOMPANYDATA, HEADERMARGIN, AD_ORG.NAME AS ORG_NAME, DELIVERYRULE.NAME AS DELIVERYTERM, PAYMENTTERM.TERM AS PAYMENTTERM, C_POC_DOCTYPE_TEMPLATE.NAME AS DOC_TYPE, C_CURRENCY.ISO_CODE AS CURRENCY_ISO, M_PRICELIST.ISTAXINCLUDED, C_ORDER.ISSOTRX AS ISSOTRX, C_BPARTNER.NAME2 AS NAME2, ( SELECT NAME FROM C_BPARTNER WHERE C_BPARTNER_ID = C_ORDER.EM_OPXMP_DISENADOR_ID) AS DISENADOR, C_ORDER.EM_OPXMP_ESTADO AS ESTADO, ( SELECT CL.ADDRESS1 FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.DELIVERY_LOCATION_ID) AS DIRENTREGA, ( SELECT CL.POSTAL FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.DELIVERY_LOCATION_ID) AS POSTALENTREGA, ( SELECT CL.CITY FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.DELIVERY_LOCATION_ID) AS CITYENTREGA, ( SELECT CBPL.NAME FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.DELIVERY_LOCATION_ID) AS NAMEDIRENTREGA, ( SELECT CL.ADDRESS1 FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.BILLTO_ID) AS DIRFACT, ( SELECT CL.POSTAL FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.BILLTO_ID) AS POSTALFACT, ( SELECT CL.CITY FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.BILLTO_ID) AS CITYFACT, ( SELECT CBPL.NAME FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.BILLTO_ID) AS NAMEDIRFACT, ( SELECT CBPL.PHONE FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.DELIVERY_LOCATION_ID) AS TELF, ( SELECT CBPL.EM_OPXMP_CONTACTO FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.DELIVERY_LOCATION_ID) AS CONTACTO, ( SELECT CBPL.EM_OPXMP_EMAIL FROM C_BPARTNER_LOCATION AS CBPL JOIN C_LOCATION AS CL ON CBPL.C_LOCATION_ID = CL.C_LOCATION_ID WHERE C_BPARTNER_LOCATION_ID = C_ORDER.DELIVERY_LOCATION_ID) AS EMAIL FROM C_BPARTNER_LOCATION left join C_LOCATION L on C_BPARTNER_LOCATION.C_LOCATION_ID = L.C_LOCATION_ID left join C_COUNTRY CO ON L.C_COUNTRY_ID = CO.C_COUNTRY_ID left join C_REGION R on L.C_REGION_ID = R.C_REGION_ID, AD_USER right join C_ORDER on AD_USER.AD_USER_ID = C_ORDER.AD_USER_ID left join AD_USER creador on creador.ad_user_id = C_ORDER.createdby left join C_POC_DOCTYPE_TEMPLATE ON C_POC_DOCTYPE_TEMPLATE.C_DOCTYPE_ID = C_ORDER.C_DOCTYPETARGET_ID, C_BPARTNER, AD_ORGINFO, AD_CLIENT, AD_ORG, ( SELECT VALUE, NAME FROM AD_REF_LIST_V WHERE AD_REFERENCE_ID = '151' AND AD_LANGUAGE IN ($1)) DELIVERYRULE, ( SELECT C_PAYMENTTERM.C_PAYMENTTERM_ID, COALESCE(C_PAYMENTTERM_TRL.NAME, C_PAYMENTTERM.NAME) AS TERM FROM C_PAYMENTTERM LEFT JOIN C_PAYMENTTERM_TRL ON C_PAYMENTTERM.C_PAYMENTTERM_ID = C_PAYMENTTERM_TRL.C_PAYMENTTERM_ID AND C_PAYMENTTERM_TRL.AD_LANGUAGE IN ($2)) PAYMENTTERM, C_CURRENCY, M_PRICELIST WHERE C_ORDER.C_BPARTNER_LOCATION_ID = C_BPARTNER_LOCATION.C_BPARTNER_LOCATION_ID AND C_ORDER.M_PRICELIST_ID = M_PRICELIST.M_PRICELIST_ID AND C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND AD_ORG.ad_org_id = AD_ORGINFO.ad_org_id AND AD_ORG.ad_org_id = ( SELECT o.AD_ORG_ID FROM AD_ORG o JOIN AD_OrgType t USING (AD_ORGTYPE_ID) WHERE AD_ISORGINCLUDED (C_ORDER.AD_ORG_ID, o.ad_org_id, C_ORDER.ad_client_id) <> - 1 AND (t.IsLegalEntity = 'Y' OR t.IsAcctLegalEntity = 'Y')) AND C_ORDER.AD_CLIENT_ID = AD_CLIENT.AD_CLIENT_ID AND C_ORDER.C_ORDER_ID IN ($3) AND C_ORDER.DELIVERYRULE = DELIVERYRULE.VALUE AND C_ORDER.C_PAYMENTTERM_ID = PAYMENTTERM.C_PAYMENTTERM_ID AND C_CURRENCY.C_CURRENCY_ID = C_ORDER.C_CURRENCY_ID GROUP BY C_ORDER.C_ORDER_ID, creador.name, C_BPARTNER.NAME, L.ADDRESS1, L.POSTAL, L.CITY, R.NAME, C_BPARTNER_LOCATION.PHONE, C_BPARTNER_LOCATION.FAX, C_BPARTNER.URL, C_ORDER.DESCRIPTION, C_ORDER.POREFERENCE, C_ORDER.DATEORDERED, C_ORDER.DOCUMENTNO, C_BPARTNER.NAME2 || ' (' || C_BPARTNER.NAME || ')', AD_CLIENT.DESCRIPTION, C_LOCATION_DESCRIPTION (AD_ORGINFO.C_LOCATION_ID), AD_ORG.ad_org_id, C_ORDER.docstatus, AD_USER.NAME, C_BPARTNER.TAXID, ADDRESS1, POSTAL, L.CITY, CO.NAME, AD_ORGINFO.TAXID, SHOWLOGO, SHOWCOMPANYDATA, HEADERMARGIN, AD_ORG.NAME, DELIVERYRULE.NAME, PAYMENTTERM.TERM, C_POC_DOCTYPE_TEMPLATE.NAME, C_CURRENCY.ISO_CODE, M_PRICELIST.ISTAXINCLUDED, C_ORDER.ISSOTRX, NAME2, C_ORDER.EM_OPXMP_DISENADOR_ID, C_ORDER.EM_OPXMP_ESTADO, C_ORDER.DELIVERY_LOCATION_ID, C_BPARTNER_LOCATION.PHONE, C_BPARTNER_LOCATION.EM_OPXMP_CONTACTO, C_BPARTNER_LOCATION.EM_OPXMP_EMAIL, C_BPARTNER_LOCATION.NAME, C_ORDER.BILLTO_ID ORDER BY C_ORDER.C_ORDER_ID, C_BPARTNER.NAME, L.ADDRESS1, L.POSTAL, L.CITY, R.NAME, C_BPARTNER_LOCATION.PHONE, C_BPARTNER_LOCATION.FAX, C_BPARTNER.URL, C_ORDER.DESCRIPTION, C_ORDER.POREFERENCE, C_ORDER.DATEORDERED, C_ORDER.DOCUMENTNO, C_BPARTNER.NAME2 || ' (' || C_BPARTNER.NAME || ')', AD_CLIENT.DESCRIPTION, C_LOCATION_DESCRIPTION (AD_ORGINFO.C_LOCATION_ID), AD_ORG.ad_org_id, C_ORDER.docstatus, AD_USER.NAME, C_BPARTNER.TAXID, ADDRESS1, POSTAL, L.CITY, CO.NAME, AD_ORGINFO.TAXID, SHOWLOGO, SHOWCOMPANYDATA, HEADERMARGIN, AD_ORG.NAME, DELIVERYRULE.NAME, PAYMENTTERM.TERM, C_POC_DOCTYPE_TEMPLATE.NAME, C_CURRENCY.ISO_CODE, M_PRICELIST.ISTAXINCLUDED, C_ORDER.ISSOTRX;
Date: 2026-07-13 08:32:50 Duration: 1s155ms Database: postgres User: etendo Remote: tad Application: 127.0.0.1 Queryid: openbravo parameters: $1 = 'es_ES', $2 = 'es_ES', $3 = '4B0E5FEFAF104ADAA277872B19131440'
4 0ms 96 0ms 0ms 0ms ;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration Jul 13 08 2 0ms 0ms 09 6 0ms 0ms 10 12 0ms 0ms 11 26 0ms 0ms 12 16 0ms 0ms 13 17 0ms 0ms 14 7 0ms 0ms 15 2 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 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,841,948 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
- 3 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3 Max number of times the same event was reported
- 3 Total events found
Rank Times reported Error 1 3 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 13 09 1 10 1 16 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-13 09:34:55 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-13 10:22:44 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-13 16:36:44 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1