pgBadger-
Global information
- Generated on Wed Jul 15 23:04:16 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 2,408,599 log entries in 4m14s
- Log start from 2026-07-15 07:00:01 to 2026-07-15 22:00:00
-
Overview
Global Stats
- 1,101 Number of unique normalized queries
- 1,138,012 Number of queries
- 3m53s Total query duration
- 2026-07-15 07:00:01 First query
- 2026-07-15 22:00:00 Last query
- 4,386 queries/s at 2026-07-15 16:16:29 Query peak
- 3m53s Total query duration
- 0ms Prepare/parse total duration
- 3s861ms Bind total duration
- 3m49s Execute total duration
- 10 Number of events
- 3 Number of unique normalized events
- 8 Max number of times the same event was reported
- 0 Number of cancellation
- 102 Total number of automatic vacuums
- 160 Total number of automatic analyzes
- 26 Number temporary file
- 90.77 MiB Max size of temporary file
- 19.85 MiB Average size of temporary file
- 5,420 Total number of sessions
- 0 sessions at Session peak
- 4d17h58m32s Total duration of sessions
- 1m15s Average duration of sessions
- 209 Average queries per session
- 43ms Average queries duration per session
- 1m15s Average idle time per session
- 5,420 Total number of connections
- 5 connections/s at 2026-07-15 16:00:01 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4,386 queries/s Query Peak
- 2026-07-15 16:16:29 Date
SELECT Traffic
Key values
- 1,403 queries/s Query Peak
- 2026-07-15 16:16:29 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 89 queries/s Query Peak
- 2026-07-15 17:00:01 Date
Queries duration
Key values
- 3m53s 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 15 07 5,823 0ms 711ms 0ms 59ms 60ms 937ms 08 43,442 0ms 939ms 0ms 1s37ms 1s770ms 10s243ms 09 77,810 0ms 18s382ms 0ms 994ms 1s613ms 18s409ms 10 310,788 0ms 827ms 0ms 1s99ms 1s570ms 2s339ms 11 52,723 0ms 885ms 0ms 323ms 404ms 1s507ms 12 100,058 0ms 738ms 0ms 434ms 858ms 1s202ms 13 139,615 0ms 819ms 0ms 696ms 1s123ms 1s311ms 14 34,590 0ms 873ms 0ms 125ms 410ms 1s171ms 15 59,644 0ms 12s639ms 0ms 377ms 563ms 31s92ms 16 168,136 0ms 738ms 0ms 900ms 1s259ms 2s36ms 17 71,535 0ms 835ms 0ms 339ms 756ms 2s185ms 18 41,103 0ms 788ms 0ms 216ms 450ms 1s321ms 19 11,031 0ms 773ms 0ms 67ms 72ms 1s296ms 20 10,193 0ms 712ms 0ms 70ms 74ms 993ms 21 10,808 0ms 12s669ms 3ms 68ms 73ms 31s578ms 22 713 0ms 36ms 0ms 101ms 101ms 101ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 15 07 1,598 0 0ms 0ms 0ms 0ms 08 12,543 0 0ms 0ms 0ms 0ms 09 22,747 0 0ms 0ms 0ms 0ms 10 95,639 0 0ms 0ms 0ms 0ms 11 14,400 0 0ms 0ms 0ms 0ms 12 30,144 0 0ms 0ms 0ms 0ms 13 42,444 0 0ms 0ms 0ms 0ms 14 10,230 0 0ms 0ms 0ms 0ms 15 17,546 0 0ms 0ms 0ms 0ms 16 51,261 0 0ms 0ms 0ms 0ms 17 21,387 0 0ms 0ms 0ms 0ms 18 12,040 0 0ms 0ms 0ms 0ms 19 3,120 0 0ms 0ms 0ms 0ms 20 2,921 0 0ms 0ms 0ms 0ms 21 3,023 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 15 07 0 0 0 0 0ms 0ms 0ms 0ms 08 94 83 0 0 0ms 0ms 0ms 0ms 09 124 192 1 0 0ms 0ms 0ms 0ms 10 577 469 3 0 0ms 0ms 0ms 0ms 11 84 397 5 0 0ms 0ms 0ms 0ms 12 144 309 4 0 0ms 0ms 0ms 0ms 13 292 307 8 0 0ms 0ms 0ms 0ms 14 42 92 0 0 0ms 0ms 0ms 0ms 15 80 208 0 0 0ms 0ms 0ms 0ms 16 351 330 11 0 0ms 0ms 0ms 0ms 17 143 165 21 0 0ms 0ms 0ms 0ms 18 84 78 5 0 0ms 0ms 0ms 0ms 19 5 13 4 0 0ms 0ms 0ms 0ms 20 2 4 0 0 0ms 0ms 0ms 0ms 21 1 64 0 0 0ms 0ms 0ms 0ms 22 2 3 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 15 07 0 1,545 1,545.00 0.00% 08 0 13,579 13,579.00 0.00% 09 0 24,587 24,587.00 0.00% 10 0 100,831 100,831.00 0.00% 11 0 16,867 16,867.00 0.00% 12 0 32,584 32,584.00 0.00% 13 0 45,470 45,470.00 0.00% 14 0 11,047 11,047.00 0.00% 15 0 18,919 18,919.00 0.00% 16 0 54,438 54,438.00 0.00% 17 0 22,789 22,789.00 0.00% 18 0 12,824 12,824.00 0.00% 19 0 3,223 3,223.00 0.00% 20 0 2,996 2,996.00 0.00% 21 0 3,159 3,159.00 0.00% 22 0 214 214.00 0.00% Day Hour Count Average / Second Jul 15 07 361 0.10/s 08 362 0.10/s 09 360 0.10/s 10 365 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 362 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 15 07 361 22ms 14ms 08 362 4m51s 4m51s 09 360 21ms 0ms 10 365 12m45s 12m45s 11 361 23ms 3ms 12 361 21ms 0ms 13 361 22ms 0ms 14 361 22ms 8ms 15 361 21ms 0ms 16 361 22ms 0ms 17 362 1m10s 1m10s 18 361 22ms 4ms 19 361 21ms 11ms 20 361 21ms 12ms 21 361 22ms 0ms 22 0 0ms 0ms -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-15 16:00:01 Date
Connections per database
Key values
- etendo Main Database
- 5,420 connections Total
Connections per user
Key values
- tad Main User
- 5,420 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- 5,398 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 5,420 sessions Total
Sessions per user
Key values
- tad Main User
- 5,420 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 5,420 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,839 buffers Checkpoint Peak
- 2026-07-15 13:06:43 Date
- 269.617 seconds Highest write time
- 0.005 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-07-15 12:37:13 Date
Checkpoints distance
Key values
- 24.87 Mo Distance Peak
- 2026-07-15 17:04:57 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 15 07 1,498 149.448s 0.003s 149.457s 08 1,492 147.878s 0.026s 147.945s 09 1,820 180.191s 0.027s 180.266s 10 3,190 315.905s 0.033s 316.004s 11 2,024 201.235s 0.024s 201.304s 12 2,039 201.714s 0.027s 201.784s 13 3,893 372.954s 0.025s 373.047s 14 1,674 165.974s 0.026s 166.047s 15 1,666 165.183s 0.026s 165.255s 16 2,788 276.85s 0.031s 276.944s 17 2,146 213.239s 0.026s 213.31s 18 1,718 170.744s 0.013s 170.779s 19 1,350 134.507s 0.004s 134.52s 20 1,293 129.276s 0.002s 129.281s 21 1,339 133.79s 0.002s 133.796s 22 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 15 07 0 1 0 133 0.002s 0.001s 08 0 0 0 333 0.002s 0.012s 09 0 1 0 409 0.002s 0.012s 10 0 2 0 966 0.002s 0.012s 11 0 0 0 418 0.002s 0.012s 12 0 1 0 563 0.002s 0.012s 13 0 2 0 705 0.002s 0.012s 14 0 0 0 267 0.002s 0.012s 15 0 1 0 345 0.002s 0.012s 16 0 1 0 778 0.002s 0.012s 17 0 1 0 437 0.002s 0.012s 18 0 1 0 331 0.002s 0.006s 19 0 1 0 170 0.002s 0.002s 20 0 0 0 131 0.001s 0.001s 21 0 1 0 143 0.001s 0.001s 22 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 15 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 15 07 9,835.00 kB 9,835.00 kB 08 933.50 kB 5,934.08 kB 09 1,121.58 kB 6,172.67 kB 10 1,928.92 kB 7,798.00 kB 11 1,219.00 kB 7,563.08 kB 12 1,272.25 kB 6,917.25 kB 13 1,562.33 kB 7,547.00 kB 14 1,018.00 kB 6,720.17 kB 15 1,056.25 kB 6,396.25 kB 16 1,622.58 kB 7,058.25 kB 17 1,313.67 kB 7,723.92 kB 18 2,213.33 kB 9,098.00 kB 19 5,409.50 kB 10,258.00 kB 20 10,002.00 kB 10,002.00 kB 21 10,047.00 kB 10,047.00 kB 22 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 92.01 MiB Temp Files size Peak
- 2026-07-15 15:30:03 Date
Number of temporary files
Key values
- 3 per second Temp Files Peak
- 2026-07-15 15:30:03 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 15 07 0 0 0 08 0 0 0 09 5 67.46 MiB 13.49 MiB 10 4 50.60 MiB 12.65 MiB 11 0 0 0 12 0 0 0 13 2 23.62 MiB 11.81 MiB 14 0 0 0 15 8 193.92 MiB 24.24 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 7 180.45 MiB 25.78 MiB 22 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 107.94 MiB 13.49 MiB 13.49 MiB 13.49 MiB select sum(order0_.totallines) as col_0_0_, sum( cost) as col_1_0_, sum(margen) as col_2_0_, sum(pmargen) / count(*) as col_3_0_ from c_order order0_ left outer join c_invoice invoicelis1_ on order0_.c_order_id = invoicelis1_.c_order_id cross join c_orderline orderline2_ where orderline2_.c_order_id = order0_.c_order_id and order0_.issotrx = ? and order0_.docstatus = ? and ? = ? limit ?;-
select sum(order0_.TotalLines) as col_0_0_, sum( Cost) as col_1_0_, sum(Margen) as col_2_0_, sum(PMargen) / count(*) as col_3_0_ from C_Order order0_ left outer join C_Invoice invoicelis1_ on order0_.C_Order_ID = invoicelis1_.C_Order_ID cross join C_OrderLine orderline2_ where orderline2_.C_Order_ID = order0_.C_Order_ID and order0_.IsSOTrx = 'Y' and order0_.DocStatus = 'CO' and 1 = 1 limit $1;
Date: 2026-07-15 09:18:17 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
2 4 3.94 MiB 728.00 KiB 1.26 MiB 1008.00 KiB ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id, ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, record_id, ?) as record_id from fact_acct where ad_table_id = ? and docbasetype in (...) group by fact_acct_group_id, record_id, ad_client_id, ad_org_id having sum(amtacctcr - amtacctdr) <> ?) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);-
'0' as ad_role_id, null as ad_user_id, 'NOT BALANCED SALES INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('ARI', 'ARC', 'ARF') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-15 15:30:03 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
3 4 355.52 MiB 87.00 MiB 90.77 MiB 88.88 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-15 15:30:03 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-15 15:30:28 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
5 1 23.62 MiB 23.62 MiB 23.62 MiB 23.62 MiB from fin_payment_scheduledetail fpsd join fin_payment_detail fpd on fpsd.fin_payment_detail_id = fpd.fin_payment_detail_id join fin_payment fp on fpd.fin_payment_id = fp.fin_payment_id join fin_payment_schedule ps on ps.fin_payment_schedule_id = fpsd.fin_payment_schedule_order join c_order co on co.c_order_id = ps.c_order_id where ps.c_order_id = ? and to_number(aprm_seqnumberpaymentstatus (fp.status)) >= ? group by co.grandtotal, ps.outstandingamt, ps.c_order_id;-
from fin_payment_scheduledetail fpsd join fin_payment_detail fpd on fpsd.fin_payment_detail_id = fpd.fin_payment_detail_id join fin_payment fp on fpd.fin_payment_id = fp.fin_payment_id join fin_payment_schedule ps ON ps.fin_payment_schedule_id = fpsd.fin_payment_schedule_order join c_order co on co.c_order_id = ps.c_order_id WHERE ps.c_order_id = $1 and to_number(aprm_seqnumberpaymentstatus (fp.status)) >= 40 group by co.GrandTotal, ps.outstandingamt, ps.c_order_id;
Date: 2026-07-15 10:36:08 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
6 1 23.62 MiB 23.62 MiB 23.62 MiB 23.62 MiB from c_bpartner td0 where td0.ad_client_id in (...) and td0.ad_org_id in (...) and td0.c_bpartner_id in ( select bp.c_bpartner_id from c_bpartner bp, c_bp_group g where g.c_bp_group_id = bp.c_bp_group_id and g.value = ?) and (td0.isactive = ? or td0.c_bpartner_id = (?)) order by ? limit ? offset ?;-
FROM C_BPartner td0 WHERE td0.AD_Client_ID IN ('0', '44FE6AC078E14A6CA5A1189E01E67FB5') AND td0.AD_Org_ID IN ('0', '0068C08A9E6E4F5DABD3DE8DF501F3AE', 'AE22A8F271B7478C9A7D2FD8E6A06E0B', '825BF275D875406288FE248FC7D41136', '753D13C4479A4E14A0CA845AE121A5EB') AND td0.C_BPartner_ID IN ( SELECT bp.C_BPartner_ID FROM C_BPartner bp, C_BP_Group g WHERE g.C_BP_Group_ID = bp.C_BP_Group_ID AND g.Value = 'D') AND (td0.isActive = 'Y' OR td0.C_BPartner_ID = ($1)) ORDER BY 2 LIMIT 76 OFFSET 0;
Date: 2026-07-15 13:37:17 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
Queries generating the largest temporary files
Rank Size Query 1 90.77 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-15 21:00:02 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2 90.75 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-15 15:30:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3 87.01 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-15 21:00:30 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4 87.00 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-15 15:30:30 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5 23.62 MiB from fin_payment_scheduledetail fpsd join fin_payment_detail fpd on fpsd.fin_payment_detail_id = fpd.fin_payment_detail_id join fin_payment fp on fpd.fin_payment_id = fp.fin_payment_id join fin_payment_schedule ps ON ps.fin_payment_schedule_id = fpsd.fin_payment_schedule_order join c_order co on co.c_order_id = ps.c_order_id WHERE ps.c_order_id = $1 and to_number(aprm_seqnumberpaymentstatus (fp.status)) >= 40 group by co.GrandTotal, ps.outstandingamt, ps.c_order_id;[ Date: 2026-07-15 10:36:08 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
6 23.62 MiB FROM C_BPartner td0 WHERE td0.AD_Client_ID IN ('0', '44FE6AC078E14A6CA5A1189E01E67FB5') AND td0.AD_Org_ID IN ('0', '0068C08A9E6E4F5DABD3DE8DF501F3AE', 'AE22A8F271B7478C9A7D2FD8E6A06E0B', '825BF275D875406288FE248FC7D41136', '753D13C4479A4E14A0CA845AE121A5EB') AND td0.C_BPartner_ID IN ( SELECT bp.C_BPartner_ID FROM C_BPartner bp, C_BP_Group g WHERE g.C_BP_Group_ID = bp.C_BP_Group_ID AND g.Value = 'D') AND (td0.isActive = 'Y' OR td0.C_BPartner_ID = ($1)) ORDER BY 2 LIMIT 76 OFFSET 0;[ Date: 2026-07-15 13:37:17 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
7 13.49 MiB select sum(order0_.TotalLines) as col_0_0_, sum( Cost) as col_1_0_, sum(Margen) as col_2_0_, sum(PMargen) / count(*) as col_3_0_ from C_Order order0_ left outer join C_Invoice invoicelis1_ on order0_.C_Order_ID = invoicelis1_.C_Order_ID cross join C_OrderLine orderline2_ where orderline2_.C_Order_ID = order0_.C_Order_ID and order0_.IsSOTrx = 'Y' and order0_.DocStatus = 'CO' and 1 = 1 limit $1;[ Date: 2026-07-15 09:18:17 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8 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-15 09:27:41 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
9 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-15 09:52:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
10 13.49 MiB select sum(order0_.TotalLines) as col_0_0_, sum( Cost) as col_1_0_, sum(Margen) as col_2_0_, sum(PMargen) / count(*) as col_3_0_ from C_Order order0_ left outer join C_Invoice invoicelis1_ on order0_.C_Order_ID = invoicelis1_.C_Order_ID cross join C_OrderLine orderline2_ where orderline2_.C_Order_ID = order0_.C_Order_ID and order0_.IsSOTrx = 'Y' and order0_.DocStatus = 'CO' and 1 = 1 limit $1;[ Date: 2026-07-15 09:52:13 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
11 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-15 09:57:27 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
12 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-15 10:36:07 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
13 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-15 10:39:41 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
14 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-15 15:34:24 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
15 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-15 15:30:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
16 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-15 21:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
17 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-15 15:30:16 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
18 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-15 15:30:28 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
19 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-15 21:00:15 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
20 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-15 21:00:28 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.38 sec Highest CPU-cost vacuum
Table profile.sample_stat_tables
Database etendo - 2026-07-15 13:00:07 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 0.38 sec Highest CPU-cost vacuum
Table profile.sample_stat_tables
Database etendo - 2026-07-15 13:00:07 Date
Analyzes per table
Key values
- public.ad_session (19) Main table analyzed (database etendo)
- 160 analyzes Total
Table Number of analyzes etendo.public.ad_session 19 etendo.profile.last_stat_tables_srv1 15 etendo.profile.last_stat_statements_srv1 15 etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.last_stat_indexes_srv1 15 etendo.public.ad_ep_instance_para 13 etendo.profile.last_stat_io 8 etendo.profile.tables_list 8 etendo.profile.stmt_list 7 etendo.profile.funcs_list 5 etendo.profile.last_extension_versions 4 etendo.profile.last_stat_activity_count_srv1 4 etendo.profile.indexes_list 4 etendo.profile.sample_stat_user_functions 3 etendo.profile.last_stat_slru 3 etendo.profile.sample_stat_indexes 2 etendo.public.ad_preference 1 etendo.profile.sample_statements_total 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.sample_stat_tablespaces 1 etendo.profile.sample_stat_user_func_total 1 etendo.profile.sample_stat_slru 1 etendo.profile.sample_stat_cluster 1 etendo.profile.sample_statements 1 etendo.profile.sample_stat_archiver 1 etendo.profile.samples 1 etendo.profile.sample_stat_io 1 etendo.profile.sample_stat_wal 1 etendo.public.m_storage_pending 1 etendo.public.ad_pinstance 1 etendo.profile.sample_stat_database 1 etendo.profile.sample_stat_tables 1 etendo.public.ad_sequence 1 etendo.public.ad_process_request 1 etendo.profile.sample_stat_tables_total 1 etendo.public.fin_financial_account 1 Total 160 Vacuums per table
Key values
- profile.last_stat_tables_srv1 (15) Main table vacuumed on database etendo
- 102 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples etendo.profile.last_stat_tables_srv1 15 15 12,012 0 169 0 0 9,078 172 1,259,385 0 0 etendo.profile.last_stat_user_functions_srv1 15 15 2,154 0 50 0 0 1,142 34 242,634 0 0 etendo.profile.last_stat_indexes_srv1 15 15 15,513 0 270 0 0 11,438 285 1,813,108 0 0 etendo.profile.last_stat_statements_srv1 15 15 7,897 0 111 0 0 5,002 115 785,578 0 0 etendo.profile.tables_list 6 6 940 0 19 0 0 529 14 128,021 3 12 etendo.public.ad_ep_instance_para 6 6 354 0 30 0 0 42 12 100,776 0 0 etendo.profile.funcs_list 5 5 446 0 22 0 0 133 11 90,542 0 0 etendo.profile.stmt_list 4 4 1,197 0 31 0 0 831 36 280,239 16 76 etendo.profile.last_extension_versions 3 3 156 0 14 0 0 15 5 41,937 0 0 etendo.profile.indexes_list 3 3 390 0 13 0 0 113 11 86,043 1 2 etendo.profile.last_stat_activity_count_srv1 3 0 63 0 15 0 0 18 6 48,960 0 0 etendo.profile.last_stat_io 3 3 249 0 15 0 0 28 7 50,869 0 0 etendo.pg_toast.pg_toast_2619 2 2 1,036 0 234 0 0 697 209 526,941 32 86 etendo.profile.sample_stat_io 1 1 117 0 31 0 0 46 12 46,404 0 0 etendo.profile.sample_stat_user_functions 1 1 307 0 92 0 0 147 28 122,259 0 0 etendo.profile.last_stat_slru 1 1 70 0 5 0 0 5 2 16,636 0 0 etendo.profile.last_stat_database_srv1 1 1 50 0 3 0 0 6 3 19,803 0 0 etendo.profile.sample_stat_tables_total 1 1 199 0 51 0 0 76 15 40,188 0 0 etendo.profile.sample_stat_tables 1 1 3,311 0 1,324 0 0 1,857 263 492,817 0 0 etendo.profile.sample_stat_indexes 1 1 528 0 181 0 0 254 42 137,529 0 0 Total 102 99 46,989 148 2,680 0 0 31,457 1,282 6,330,669 52 176 Vacuum throughput per table
Key values
- profile.sample_stat_tables (0.38) Max CPU elapsed for vacuum on database etendo
- unknown (0 ms) Max I/O read time for vacuum on database etendo
- unknown (0 ms) Max I/O write time for vacuum on database etendo
I/O timing (ms) CPU (s) Table read write elapsed etendo.profile.last_stat_tables_srv1 0 0 0.15 etendo.profile.last_stat_user_functions_srv1 0 0 0 etendo.profile.last_stat_indexes_srv1 0 0 0.15 etendo.profile.last_stat_statements_srv1 0 0 0.05 etendo.profile.tables_list 0 0 0 etendo.public.ad_ep_instance_para 0 0 0 etendo.profile.funcs_list 0 0 0 etendo.profile.stmt_list 0 0 0 etendo.profile.last_extension_versions 0 0 0 etendo.profile.indexes_list 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.last_stat_io 0 0 0 etendo.pg_toast.pg_toast_2619 0 0 0.06 etendo.profile.sample_stat_io 0 0 0.01 etendo.profile.sample_stat_user_functions 0 0 0.04 etendo.profile.last_stat_slru 0 0 0 etendo.profile.last_stat_database_srv1 0 0 0 etendo.profile.sample_stat_tables_total 0 0 0.02 etendo.profile.sample_stat_tables 0 0 0.38 etendo.profile.sample_stat_indexes 0 0 0.07 Total 0 0 0.93 Tuples removed per table
Key values
- profile.last_stat_indexes_srv1 (70755) Main table with removed tuples on database etendo
- 143844 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,755 34,935 0 0 4,320 etendo.profile.last_stat_tables_srv1 15 15 44,808 20,880 0 0 3,446 etendo.profile.last_stat_statements_srv1 15 15 15,334 13,206 0 217 1,429 etendo.profile.last_stat_user_functions_srv1 15 15 5,433 4,605 0 3 335 etendo.profile.sample_stat_tables 1 1 2,369 31,550 0 0 1,322 etendo.profile.sample_stat_user_functions 1 1 1,004 7,018 0 0 80 etendo.profile.tables_list 6 6 920 4,840 0 0 156 etendo.profile.sample_stat_indexes 1 1 854 8,657 0 0 164 etendo.pg_toast.pg_toast_2619 2 2 570 2,461 0 0 908 etendo.profile.stmt_list 4 4 413 2,959 0 0 304 etendo.profile.sample_stat_tables_total 1 1 264 1,344 0 0 45 etendo.profile.funcs_list 5 5 238 866 0 0 40 etendo.profile.sample_stat_io 1 1 175 858 0 0 24 etendo.profile.last_stat_io 3 3 169 39 0 2 4 etendo.profile.last_extension_versions 3 3 168 24 0 0 3 etendo.profile.indexes_list 3 3 129 1,026 0 0 30 etendo.public.ad_ep_instance_para 6 6 110 0 0 6 0 etendo.profile.last_stat_activity_count_srv1 3 0 72 0 0 3 0 etendo.profile.last_stat_slru 1 1 55 5 0 0 1 etendo.profile.last_stat_database_srv1 1 1 4 4 0 0 1 Total 102 99 143,844 135,277 0 231 12,612 Pages removed per table
Key values
- profile.last_stat_statements_srv1 (217) Main table with removed pages on database etendo
- 231 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed etendo.profile.last_stat_statements_srv1 15 15 15334 217 etendo.public.ad_ep_instance_para 6 6 110 6 etendo.profile.last_stat_user_functions_srv1 15 15 5433 3 etendo.profile.last_stat_activity_count_srv1 3 0 72 3 etendo.profile.last_stat_io 3 3 169 2 etendo.profile.last_stat_tables_srv1 15 15 44808 0 etendo.profile.last_extension_versions 3 3 168 0 etendo.profile.sample_stat_io 1 1 175 0 etendo.profile.sample_stat_user_functions 1 1 1004 0 etendo.profile.last_stat_slru 1 1 55 0 etendo.profile.last_stat_database_srv1 1 1 4 0 etendo.profile.indexes_list 3 3 129 0 etendo.profile.last_stat_indexes_srv1 15 15 70755 0 etendo.profile.stmt_list 4 4 413 0 etendo.profile.tables_list 6 6 920 0 etendo.pg_toast.pg_toast_2619 2 2 570 0 etendo.profile.sample_stat_tables_total 1 1 264 0 etendo.profile.funcs_list 5 5 238 0 etendo.profile.sample_stat_tables 1 1 2369 0 etendo.profile.sample_stat_indexes 1 1 854 0 Total 102 99 143,844 231 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 15 07 9 9 08 5 7 09 7 11 10 8 20 11 6 12 12 7 10 13 9 17 14 6 12 15 7 11 16 7 9 17 4 10 18 8 6 19 4 7 20 7 8 21 8 11 22 0 0 - 0.38 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
- 341,245 Total read queries
- 28,510 Total write queries
Queries by database
Key values
- etendo Main database
- 1,129,432 Requests
- 3m45s (etendo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 1,128,352 Requests
User Request type Count Duration postgres Total 9,660 18s196ms others 2,835 0ms select 1,905 0ms tcl 90 0ms tad Total 1,128,352 3m31s delete 62 0ms insert 2,025 0ms others 491 0ms select 339,340 0ms tcl 23,619 0ms update 2,714 0ms Duration by user
Key values
- 3m31s (tad) Main time consuming user
User Request type Count Duration postgres Total 9,660 18s196ms others 2,835 0ms select 1,905 0ms tcl 90 0ms tad Total 1,128,352 3m31s delete 62 0ms insert 2,025 0ms others 491 0ms select 339,340 0ms tcl 23,619 0ms update 2,714 0ms Queries by host
Key values
- 127.0.0.1 Main host
- 1,128,352 Requests
- 3m31s (127.0.0.1)
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 1,121,952 Requests
- 3m15s (openbravo)
- Main time consuming application
Application Request type Count Duration [unknown] Total 8,457 3s717ms others 2,757 0ms select 1,440 0ms tcl 45 0ms openbravo Total 1,121,952 3m15s delete 62 0ms insert 2,025 0ms select 336,640 0ms tcl 23,619 0ms update 2,714 0ms pg_profile Total 1,185 2s824ms others 90 0ms select 435 0ms tcl 45 0ms psql Total 6,418 27s494ms others 479 0ms select 2,730 0ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-15 18:50:48 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 751,712 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 2 0ms 0ms 0ms select * from ( select m_product_category_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id as ad_org_id, ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, m_product_category_id, ?) as record_id from m_product_category pc where exists ( select d.c_acctschema_id from c_acctschema_default d where exists ( select ? from ad_org_acctschema where (ad_isorgincluded (ad_org_id, pc.ad_org_id, pc.ad_client_id) <> ? or ad_isorgincluded (pc.ad_org_id, ad_org_id, pc.ad_client_id) <> ?) and isactive = ? and ad_org_acctschema.c_acctschema_id = d.c_acctschema_id and ad_org_acctschema.ad_client_id = pc.ad_client_id) and not exists ( select pca.c_acctschema_id from m_product_category_acct pca where pca.m_product_category_id = pc.m_product_category_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 #1
Day Hour Count Duration Avg duration Jul 15 15 1 0ms 0ms 21 1 0ms 0ms 2 0ms 12 0ms 0ms 0ms select t.istaxundeductable as ratetaxundeductable, ( select istaxundeductable from ad_orginfo o where o.ad_org_id = it.ad_org_id) as orgtaxundeductable, it.c_tax_id, t.name, t.rate, t.istaxdeductable, sum(it.taxbaseamt) as taxbaseamt, sum(it.taxamt) as taxamt, min(it.line) as line, ? as c_invoice_id, ? as ad_client_id, ? as ad_org_id, ? as isactive, ? as created, ? as createdby, ? as updated, ? as updatedby, ? as issotrx, ? as documentno, ? as docstatus, ? as docaction, ? as processing, ? as processed, ? as posted, ? as c_doctype_id, ? as c_doctypetarget_id, ? as c_order_id, ? as description, ? as istransferred, ? as isprinted, ? as salesrep_id, ? as dateinvoiced, ? as dateprinted, ? as dateacct, ? as c_bpartner_id, ? as c_bpartner_location_id, ? as poreference, ? as isdiscountprinted, ? as dateordered, ? as c_currency_id, ? as paymentrule, ? as c_paymentterm_id, ? as c_charge_id, ? as chargeamt, ? as totallines, ? as grandtotal, ? as m_pricelist_id, ? as istaxincluded, ? as c_campaign_id, ? as c_project_id, ? as c_activity_id, ? as ispaid, ? as createfrom, ? as generateto, ? as sendemail, ? as ad_user_id, ? as copyfrom, ? as isselfservice, ? as ad_orgtrx_id, ? as user1_id, ? as user2_id, ? as amount, ? as status, ? as isreceipt, ? as ismanual, ? as writeoffamt, ? as c_debt_payment_id, ? as p_revenue_acct, ? as p_expense_acct, ? as fin_payment_schedule_id, ? as fin_paymentmethod_id, ? as prepaidamt, ? as fininvcount, ? as finacctcount, ? as fin_payment_id, ? as c_costcenter_id, t.iscashvat as iscashvat, ? as prepaymentamt from c_tax t, c_invoicetax it where t.c_tax_id = it.c_tax_id and it.c_invoice_id = ? group by t.istaxundeductable, it.c_tax_id, t.name, t.rate, t.istaxdeductable, it.ad_org_id, t.iscashvat order by line;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 15 09 1 0ms 0ms 10 3 0ms 0ms 11 1 0ms 0ms 13 2 0ms 0ms 16 4 0ms 0ms 17 1 0ms 0ms 3 0ms 1 0ms 0ms 0ms select pricingpri0_.m_pricelist_version_id as m_pricel1_433_0_, pricingpri0_.ad_client_id as ad_clien2_433_0_, pricingpri0_.ad_org_id as ad_org_i3_433_0_, pricingpri0_.isactive as isactive4_433_0_, pricingpri0_.created as created5_433_0_, pricingpri0_.createdby as createdb6_433_0_, pricingpri0_.updated as updated7_433_0_, pricingpri0_.updatedby as updatedb8_433_0_, pricingpri0_.name as name9_433_0_, pricingpri0_.description as descrip10_433_0_, pricingpri0_.m_pricelist_id as m_price11_433_0_, pricingpri0_.m_discountschema_id as m_disco12_433_0_, pricingpri0_.validfrom as validfr13_433_0_, pricingpri0_.proccreate as proccre14_433_0_, pricingpri0_.m_pricelist_version_base_id as m_price15_433_0_, pricingpri0_.m_pricelist_version_generate as m_price16_433_0_ from m_pricelist_version pricingpri0_ where pricingpri0_.m_pricelist_version_id in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 15 10 1 0ms 0ms 4 0ms 74 0ms 0ms 0ms select coalesce(( select show_in_header from ad_client_acctdimension where ad_client_id = ? and docbasetype = ? and dimension = ?), c.user1_acctdim_header) from ad_client c where c.ad_client_id = ? and c.user1_acctdim_isenable = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 15 16 59 0ms 0ms 18 15 0ms 0ms 5 0ms 6 0ms 0ms 0ms select order0_.c_order_id as c_order_1_246_, order0_.ad_client_id as ad_clien2_246_, order0_.ad_org_id as ad_org_i3_246_, order0_.isactive as isactive4_246_, order0_.created as created5_246_, order0_.createdby as createdb6_246_, order0_.updated as updated7_246_, order0_.updatedby as updatedb8_246_, order0_.issotrx as issotrx9_246_, order0_.documentno as documen10_246_, order0_.docstatus as docstat11_246_, order0_.docaction as docacti12_246_, order0_.processing as process13_246_, order0_.processed as process14_246_, order0_.c_doctype_id as c_docty15_246_, order0_.c_doctypetarget_id as c_docty16_246_, order0_.description as descrip17_246_, order0_.isdelivered as isdeliv18_246_, order0_.isinvoiced as isinvoi19_246_, order0_.isprinted as isprint20_246_, order0_.isselected as isselec21_246_, order0_.salesrep_id as salesre22_246_, order0_.dateordered as dateord23_246_, order0_.datepromised as datepro24_246_, order0_.dateprinted as datepri25_246_, order0_.dateacct as dateacc26_246_, order0_.c_bpartner_id as c_bpart27_246_, order0_.billto_id as billto_28_246_, order0_.c_bpartner_location_id as c_bpart29_246_, order0_.poreference as porefer30_246_, order0_.isdiscountprinted as isdisco31_246_, order0_.c_currency_id as c_curre32_246_, order0_.paymentrule as payment33_246_, order0_.c_paymentterm_id as c_payme34_246_, order0_.invoicerule as invoice35_246_, order0_.deliveryrule as deliver36_246_, order0_.freightcostrule as freight37_246_, order0_.freightamt as freight38_246_, order0_.deliveryviarule as deliver39_246_, order0_.m_shipper_id as m_shipp40_246_, order0_.c_charge_id as c_charg41_246_, order0_.chargeamt as chargea42_246_, order0_.priorityrule as priorit43_246_, order0_.totallines as totalli44_246_, order0_.grandtotal as grandto45_246_, order0_.m_warehouse_id as m_wareh46_246_, order0_.m_pricelist_id as m_price47_246_, order0_.istaxincluded as istaxin48_246_, order0_.c_campaign_id as c_campa49_246_, order0_.c_project_id as c_proje50_246_, order0_.c_activity_id as c_activ51_246_, order0_.posted as posted52_246_, order0_.ad_user_id as ad_user53_246_, order0_.copyfrom as copyfro54_246_, order0_.dropship_bpartner_id as dropshi55_246_, order0_.dropship_location_id as dropshi56_246_, order0_.dropship_user_id as dropshi57_246_, order0_.isselfservice as isselfs58_246_, order0_.ad_orgtrx_id as ad_orgt59_246_, order0_.user1_id as user60_246_, order0_.user2_id as user61_246_, order0_.deliverynotes as deliver62_246_, order0_.c_incoterms_id as c_incot63_246_, order0_.incotermsdescription as incoter64_246_, order0_.generatetemplate as generat65_246_, order0_.delivery_location_id as deliver66_246_, order0_.copyfrompo as copyfro67_246_, order0_.fin_paymentmethod_id as fin_pay68_246_, order0_.fin_payment_priority_id as fin_pay69_246_, order0_.rm_pickfromshipment as rm_pick70_246_, order0_.rm_receivematerials as rm_rece71_246_, order0_.rm_createinvoice as rm_crea72_246_, order0_.c_return_reason_id as c_retur73_246_, order0_.rm_addorphanline as rm_addo74_246_, order0_.a_asset_id as a_asset75_246_, order0_.calculate_promotions as calcula76_246_, order0_.c_costcenter_id as c_costc77_246_, order0_.convertquotation as convert78_246_, order0_.c_reject_reason_id as c_rejec79_246_, order0_.validuntil as validun80_246_, order0_.quotation_id as quotati81_246_, order0_.so_res_status as so_res_82_246_, order0_.create_polines as create_83_246_, order0_.iscashvat as iscashv84_246_, order0_.em_opxmp_buttonpo as em_opxm85_246_, order0_.rm_pickfromreceipt as rm_pick86_246_, order0_.cancelandreplace as cancela87_246_, order0_.em_aprm_addpayment as em_aprm88_246_, order0_.em_opxmp_envdirecto as em_opxm89_246_, order0_.em_opxmp_disenador_id as em_opxm90_246_, order0_.em_opxmp_estado as em_opxm91_246_, order0_.em_opxmp_buttonpv as em_opxm92_246_, order0_.em_opxmp_buttonmail as em_opxm93_246_, order0_.em_mp_infpvint as em_mp_i94_246_, order0_.confirmcancelandreplace as confirm95_246_, order0_.cancelledorder_id as cancell96_246_, order0_.replacedorder_id as replace97_246_, order0_.iscancelled as iscance98_246_, order0_.replacementorder_id as replace99_246_, order0_.bpartner_extref as bpartn100_246_ from c_order order0_ cross join c_doctype documentty1_ where order0_.c_doctypetarget_id = documentty1_.c_doctype_id and order0_.issotrx = ? and documentty1_.isreturn = ? and (documentty1_.docsubtypeso not like ?) and (order0_.updated > ? or order0_.processed = ?) and (order0_.ad_org_id in (...)) and (order0_.ad_client_id in (...)) order by order0_.datepromised desc, order0_.c_order_id desc limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 15 09 3 0ms 0ms 17 3 0ms 0ms 6 0ms 41 0ms 0ms 0ms select users.default_ad_org_id from ad_user users inner join ad_org org on users.default_ad_org_id = org.ad_org_id where users.ad_user_id = ? and not users.default_ad_org_id is null and org.isactive = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 15 08 3 0ms 0ms 09 14 0ms 0ms 10 15 0ms 0ms 15 6 0ms 0ms 17 3 0ms 0ms 7 0ms 2 0ms 0ms 0ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select c_bpartner_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id as ad_org_id, ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_bpartner_id, ?) as record_id from c_bpartner bp where bp.iscustomer = ? and exists ( select d.c_acctschema_id from c_acctschema_default d where exists ( select ? from ad_org_acctschema where (ad_isorgincluded (ad_org_id, bp.ad_org_id, bp.ad_client_id) <> ? or ad_isorgincluded (bp.ad_org_id, ad_org_id, bp.ad_client_id) <> ?) and isactive = ? and ad_org_acctschema.c_acctschema_id = d.c_acctschema_id and ad_org_acctschema.ad_client_id = bp.ad_client_id) and not exists ( select bpca.c_acctschema_id from c_bp_customer_acct bpca where bpca.c_bpartner_id = bp.c_bpartner_id))) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 15 15 1 0ms 0ms 21 1 0ms 0ms 8 0ms 93 0ms 0ms 0ms select coalesce(max(dt.docbasetype), ?) from c_invoice inv join c_doctype dt on (inv.c_doctypetarget_id = dt.c_doctype_id) where inv.c_invoice_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 15 09 4 0ms 0ms 10 11 0ms 0ms 11 4 0ms 0ms 12 8 0ms 0ms 13 3 0ms 0ms 15 3 0ms 0ms 16 36 0ms 0ms 17 16 0ms 0ms 18 8 0ms 0ms 9 0ms 6 0ms 0ms 0ms select this_.opxmail_informes_correo_id as opxmail_1_643_0_, this_.ad_client_id as ad_clien2_643_0_, this_.ad_org_id as ad_org_i3_643_0_, this_.isactive as isactive4_643_0_, this_.created as created5_643_0_, this_.createdby as createdb6_643_0_, this_.updated as updated7_643_0_, this_.updatedby as updatedb8_643_0_, this_.ad_tab_id as ad_tab_i9_643_0_, this_.nombre as nombre10_643_0_, this_.ruta as ruta11_643_0_, this_.ad_module_id as ad_modu12_643_0_, this_.asunto as asunto13_643_0_, this_.mensaje as mensaje14_643_0_ from opxmail_informes_correo this_ where this_.ad_tab_id = ? and this_.ad_org_id in (...) and this_.ad_client_id in (...) and this_.isactive = ? order by this_.nombre asc;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 15 09 1 0ms 0ms 10 1 0ms 0ms 13 1 0ms 0ms 16 2 0ms 0ms 17 1 0ms 0ms 10 0ms 594 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 #10
Day Hour Count Duration Avg duration Jul 15 08 33 0ms 0ms 09 68 0ms 0ms 10 161 0ms 0ms 11 33 0ms 0ms 12 50 0ms 0ms 13 113 0ms 0ms 14 17 0ms 0ms 15 31 0ms 0ms 16 45 0ms 0ms 17 26 0ms 0ms 18 17 0ms 0ms 11 0ms 98 0ms 0ms 0ms select adprocessa0_.ad_process_id as col_0_0_ from ad_process_access adprocessa0_ where adprocessa0_.ad_role_id = ? and adprocessa0_.isactive = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 15 08 7 0ms 0ms 09 35 0ms 0ms 10 35 0ms 0ms 15 14 0ms 0ms 17 7 0ms 0ms 12 0ms 94 0ms 0ms 0ms select admessaget0_.ad_message_id as ad_messa2_56_1_, admessaget0_.ad_message_trl_id as ad_messa1_56_1_, admessaget0_.ad_message_trl_id as ad_messa1_56_0_, admessaget0_.ad_message_id as ad_messa2_56_0_, admessaget0_.ad_language as ad_langu3_56_0_, admessaget0_.ad_client_id as ad_clien4_56_0_, admessaget0_.ad_org_id as ad_org_i5_56_0_, admessaget0_.isactive as isactive6_56_0_, admessaget0_.created as created7_56_0_, admessaget0_.createdby as createdb8_56_0_, admessaget0_.updated as updated9_56_0_, admessaget0_.updatedby as updated10_56_0_, admessaget0_.msgtext as msgtext11_56_0_, admessaget0_.msgtip as msgtip12_56_0_, admessaget0_.istranslated as istrans13_56_0_ from ad_message_trl admessaget0_ where admessaget0_.ad_message_id = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 15 08 1 0ms 0ms 09 3 0ms 0ms 10 10 0ms 0ms 11 6 0ms 0ms 12 5 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 3 0ms 0ms 16 48 0ms 0ms 17 7 0ms 0ms 18 9 0ms 0ms 13 0ms 28 0ms 0ms 0ms select this_.obserds_datasource_id as obserds_1_597_0_, this_.ad_client_id as ad_clien2_597_0_, this_.ad_org_id as ad_org_i3_597_0_, this_.ad_module_id as ad_modul4_597_0_, this_.name as name5_597_0_, this_.description as descript6_597_0_, this_.ad_table_id as ad_table7_597_0_, this_.whereclause as wherecla8_597_0_, this_.classname as classnam9_597_0_, this_.obclker_template_id as obclker10_597_0_, this_.isactive as isactiv11_597_0_, this_.created as created12_597_0_, this_.createdby as created13_597_0_, this_.updated as updated14_597_0_, this_.updatedby as updated15_597_0_, this_.useastabledataorigin as useasta16_597_0_, this_.idfkfiltering as idfkfil17_597_0_ from obserds_datasource this_ where this_.name = ? and this_.ad_org_id in (...) and this_.ad_client_id in (...) and this_.isactive = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 15 08 1 0ms 0ms 09 3 0ms 0ms 10 5 0ms 0ms 13 4 0ms 0ms 16 7 0ms 0ms 17 8 0ms 0ms 14 0ms 137 0ms 0ms 0ms select td0.value as id, (coalesce(to_char((( case td0.isactive when ? then ? else ? end) || ( case when td_trl0.name is null then td0.name else td_trl0.name end))), ?)) as name, ( case when td_trl0.description is null then td0.description else td_trl0.description end) as description from ad_ref_list td0 left join ad_ref_list_trl td_trl0 on td0.ad_ref_list_id = td_trl0.ad_ref_list_id and td_trl0.ad_language = ? where td0.ad_reference_id = (?) and ((td0.value in (...) or ( select docsubtypeso from c_doctype where c_doctype.c_doctype_id = ?) <> ?)) and (td0.isactive = ? or td0.value = ?) order by td0.seqno, ( case when td_trl0.name is null then td0.name else td_trl0.name end);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 15 08 8 0ms 0ms 09 10 0ms 0ms 10 50 0ms 0ms 11 3 0ms 0ms 12 10 0ms 0ms 13 41 0ms 0ms 14 3 0ms 0ms 15 1 0ms 0ms 16 4 0ms 0ms 17 4 0ms 0ms 18 3 0ms 0ms 15 0ms 1 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 #15
Day Hour Count Duration Avg duration Jul 15 11 1 0ms 0ms 16 0ms 5 0ms 0ms 0ms select td0.c_doctype_id as id, (coalesce(to_char(( case when td_trl1.name is null then coalesce(to_char(td0.name), ?) else coalesce(to_char(td_trl1.name), ?) end)), ?)) as name, ? as description from c_doctype td0 left join c_doctype_trl td_trl1 on td0.c_doctype_id = td_trl1.c_doctype_id and td_trl1.ad_language = ? where td0.ad_client_id in (...) and td0.ad_org_id in (...) and td0.ad_client_id = ? and (? <> ? or coalesce(?, ?) = ?) and (td0.docbasetype in (...) and td0.issotrx = ? and (ad_isorgincluded (?, td0.ad_org_id, ?) <> ? or coalesce(?, ?) = ?) and coalesce(null, ?) = td0.isreturn and ((null = ? and docsubtypeso like ?) or ((null = ? or null is null) and (docsubtypeso is null or docsubtypeso not like ?)))) and (td0.isactive = ? or td0.c_doctype_id = (null)) order by td0.isdefault desc, td0.name limit ? offset ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 15 08 2 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 17 0ms 40 0ms 0ms 0ms select this_.fin_finacc_paymentmethod_id as fin_fina1_329_0_, this_.ad_client_id as ad_clien2_329_0_, this_.ad_org_id as ad_org_i3_329_0_, this_.created as created4_329_0_, this_.createdby as createdb5_329_0_, this_.updated as updated6_329_0_, this_.updatedby as updatedb7_329_0_, this_.isactive as isactive8_329_0_, this_.fin_paymentmethod_id as fin_paym9_329_0_, this_.fin_financial_account_id as fin_fin10_329_0_, this_.automatic_receipt as automat11_329_0_, this_.automatic_payment as automat12_329_0_, this_.automatic_deposit as automat13_329_0_, this_.automatic_withdrawn as automat14_329_0_, this_.payin_allow as payin_a15_329_0_, this_.payout_allow as payout_16_329_0_, this_.payin_execution_type as payin_e17_329_0_, this_.payout_execution_type as payout_18_329_0_, this_.payin_execution_process_id as payin_e19_329_0_, this_.payout_execution_process_id as payout_20_329_0_, this_.payin_deferred as payin_d21_329_0_, this_.payout_deferred as payout_22_329_0_, this_.uponreceiptuse as uponrec23_329_0_, this_.upondeposituse as upondep24_329_0_, this_.inuponclearinguse as inuponc25_329_0_, this_.uponpaymentuse as uponpay26_329_0_, this_.uponwithdrawaluse as uponwit27_329_0_, this_.outuponclearinguse as outupon28_329_0_, this_.payin_ismulticurrency as payin_i29_329_0_, this_.payout_ismulticurrency as payout_30_329_0_, this_.isdefault as isdefau31_329_0_, this_.payin_invoicepaidstatus as payin_i32_329_0_, this_.payout_invoicepaidstatus as payout_33_329_0_ from fin_finacc_paymentmethod this_ where this_.fin_financial_account_id = ? and this_.fin_paymentmethod_id = ? and this_.isactive = ? and this_.isactive = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 15 10 4 0ms 0ms 11 4 0ms 0ms 12 2 0ms 0ms 15 2 0ms 0ms 16 20 0ms 0ms 17 4 0ms 0ms 18 4 0ms 0ms 18 0ms 63 0ms 0ms 0ms select attributes0_.m_attributesetinstance_id as m_attrib1_371_0_, attributes0_.ad_client_id as ad_clien2_371_0_, attributes0_.ad_org_id as ad_org_i3_371_0_, attributes0_.isactive as isactive4_371_0_, attributes0_.created as created5_371_0_, attributes0_.createdby as createdb6_371_0_, attributes0_.updated as updated7_371_0_, attributes0_.updatedby as updatedb8_371_0_, attributes0_.m_attributeset_id as m_attrib9_371_0_, attributes0_.serno as serno10_371_0_, attributes0_.lot as lot11_371_0_, attributes0_.guaranteedate as guarant12_371_0_, attributes0_.description as descrip13_371_0_, attributes0_.m_lot_id as m_lot_i14_371_0_, attributes0_.islocked as islocke15_371_0_, attributes0_.lock_description as lock_de16_371_0_, attributes0_.m_refinventory_id as m_refin17_371_0_, attributes0_.parent_attributesetinstance_id as parent_18_371_0_ from m_attributesetinstance attributes0_ where attributes0_.m_attributesetinstance_id = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 15 08 1 0ms 0ms 09 5 0ms 0ms 10 31 0ms 0ms 12 5 0ms 0ms 13 11 0ms 0ms 14 1 0ms 0ms 15 4 0ms 0ms 16 2 0ms 0ms 17 1 0ms 0ms 18 2 0ms 0ms 19 0ms 1,096 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 in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 15 08 79 0ms 0ms 09 84 0ms 0ms 10 298 0ms 0ms 11 51 0ms 0ms 12 112 0ms 0ms 13 145 0ms 0ms 14 44 0ms 0ms 15 44 0ms 0ms 16 141 0ms 0ms 17 63 0ms 0ms 18 30 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 2 0ms 0ms 20 0ms 2 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, a.ad_org_id, a.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, a.a_amortization_id, ?) as record_id from a_amortization a, fact_acct f1, fact_acct f2 where 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 and f1.record_id = a.a_amortization_id group by a.a_amortization_id, a.ad_org_id, a.ad_client_id, f1.ad_table_id, f1.record_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 #20
Day Hour Count Duration Avg duration Jul 15 15 1 0ms 0ms 21 1 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 173,218 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 15 08 5,225 0ms 0ms 09 10,061 0ms 0ms 10 55,400 0ms 0ms 11 6,418 0ms 0ms 12 17,556 0ms 0ms 13 22,244 0ms 0ms 14 4,650 0ms 0ms 15 8,925 0ms 0ms 16 27,770 0ms 0ms 17 10,036 0ms 0ms 18 4,933 0ms 0ms 2 21,476 0ms 0ms 0ms 0ms select coalesce(t.msgtext, m.msgtext) as msgtext from ad_message m left join ad_message_trl t on m.ad_message_id = t.ad_message_id and t.ad_language = ? where m.value = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 15 07 720 0ms 0ms 08 1,201 0ms 0ms 09 1,546 0ms 0ms 10 1,617 0ms 0ms 11 1,465 0ms 0ms 12 1,469 0ms 0ms 13 1,526 0ms 0ms 14 1,465 0ms 0ms 15 1,481 0ms 0ms 16 1,615 0ms 0ms 17 1,519 0ms 0ms 18 1,470 0ms 0ms 19 1,451 0ms 0ms 20 1,449 0ms 0ms 21 1,473 0ms 0ms 22 9 0ms 0ms 3 12,542 0ms 0ms 0ms 0ms select distinct addimensio0_.documentlevel as col_0_0_ from ad_dimension_mapping addimensio0_ where addimensio0_.ad_table_id = ? and addimensio0_.dimension = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 15 08 270 0ms 0ms 09 718 0ms 0ms 10 3,786 0ms 0ms 11 454 0ms 0ms 12 1,252 0ms 0ms 13 1,528 0ms 0ms 14 310 0ms 0ms 15 616 0ms 0ms 16 2,408 0ms 0ms 17 792 0ms 0ms 18 408 0ms 0ms 4 11,810 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 15 07 127 0ms 0ms 08 582 0ms 0ms 09 915 0ms 0ms 10 2,221 0ms 0ms 11 1,144 0ms 0ms 12 1,145 0ms 0ms 13 1,363 0ms 0ms 14 495 0ms 0ms 15 696 0ms 0ms 16 1,396 0ms 0ms 17 689 0ms 0ms 18 462 0ms 0ms 19 194 0ms 0ms 20 188 0ms 0ms 21 189 0ms 0ms 22 4 0ms 0ms 5 11,796 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 15 07 130 0ms 0ms 08 582 0ms 0ms 09 912 0ms 0ms 10 2,204 0ms 0ms 11 1,146 0ms 0ms 12 1,145 0ms 0ms 13 1,352 0ms 0ms 14 498 0ms 0ms 15 696 0ms 0ms 16 1,397 0ms 0ms 17 689 0ms 0ms 18 462 0ms 0ms 19 197 0ms 0ms 20 191 0ms 0ms 21 192 0ms 0ms 22 3 0ms 0ms 6 6,271 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 15 08 135 0ms 0ms 09 359 0ms 0ms 10 1,893 0ms 0ms 11 227 0ms 0ms 12 626 0ms 0ms 13 764 0ms 0ms 14 155 0ms 0ms 15 308 0ms 0ms 16 1,204 0ms 0ms 17 396 0ms 0ms 18 204 0ms 0ms 7 5,971 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 15 08 276 0ms 0ms 09 448 0ms 0ms 10 1,456 0ms 0ms 11 510 0ms 0ms 12 591 0ms 0ms 13 791 0ms 0ms 14 180 0ms 0ms 15 308 0ms 0ms 16 893 0ms 0ms 17 321 0ms 0ms 18 197 0ms 0ms 8 5,188 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 15 07 60 0ms 0ms 08 303 0ms 0ms 09 393 0ms 0ms 10 1,072 0ms 0ms 11 277 0ms 0ms 12 438 0ms 0ms 13 571 0ms 0ms 14 236 0ms 0ms 15 280 0ms 0ms 16 622 0ms 0ms 17 335 0ms 0ms 18 229 0ms 0ms 19 122 0ms 0ms 20 122 0ms 0ms 21 124 0ms 0ms 22 4 0ms 0ms 9 3,860 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 15 08 257 0ms 0ms 09 247 0ms 0ms 10 1,019 0ms 0ms 11 197 0ms 0ms 12 330 0ms 0ms 13 572 0ms 0ms 14 130 0ms 0ms 15 170 0ms 0ms 16 570 0ms 0ms 17 229 0ms 0ms 18 139 0ms 0ms 10 2,721 0ms 0ms 0ms 0ms select adclient0_.ad_client_id as ad_clien1_18_0_, adclient0_.ad_org_id as ad_org_i2_18_0_, adclient0_.isactive as isactive3_18_0_, adclient0_.created as created4_18_0_, adclient0_.createdby as createdb5_18_0_, adclient0_.updated as updated6_18_0_, adclient0_.updatedby as updatedb7_18_0_, adclient0_.value as value8_18_0_, adclient0_.name as name9_18_0_, adclient0_.description as descrip10_18_0_, adclient0_.smtphost as smtphos11_18_0_, adclient0_.requestemail as request12_18_0_, adclient0_.requestuser as request13_18_0_, adclient0_.requestuserpw as request14_18_0_, adclient0_.requestfolder as request15_18_0_, adclient0_.ad_language as ad_lang16_18_0_, adclient0_.ismultilingualdocument as ismulti17_18_0_, adclient0_.issmtpauthorization as issmtpa18_18_0_, adclient0_.c_currency_id as c_curre19_18_0_, adclient0_.acctdim_centrally_maintained as acctdim20_18_0_, adclient0_.project_acctdim_isenable as project21_18_0_, adclient0_.project_acctdim_header as project22_18_0_, adclient0_.project_acctdim_lines as project23_18_0_, adclient0_.project_acctdim_breakdown as project24_18_0_, adclient0_.bpartner_acctdim_isenable as bpartne25_18_0_, adclient0_.bpartner_acctdim_header as bpartne26_18_0_, adclient0_.bpartner_acctdim_lines as bpartne27_18_0_, adclient0_.bpartner_acctdim_breakdown as bpartne28_18_0_, adclient0_.product_acctdim_isenable as product29_18_0_, adclient0_.product_acctdim_header as product30_18_0_, adclient0_.product_acctdim_lines as product31_18_0_, adclient0_.product_acctdim_breakdown as product32_18_0_, adclient0_.costcenter_acctdim_header as costcen33_18_0_, adclient0_.costcenter_acctdim_lines as costcen34_18_0_, adclient0_.costcenter_acctdim_breakdown as costcen35_18_0_, adclient0_.user1_acctdim_isenable as user36_18_0_, adclient0_.user1_acctdim_header as user37_18_0_, adclient0_.user1_acctdim_lines as user38_18_0_, adclient0_.user1_acctdim_breakdown as user39_18_0_, adclient0_.user2_acctdim_isenable as user40_18_0_, adclient0_.user2_acctdim_header as user41_18_0_, adclient0_.user2_acctdim_lines as user42_18_0_, adclient0_.user2_acctdim_breakdown as user43_18_0_, adclient0_.costcenter_acctdim_isenable as costcen44_18_0_, adclient0_.org_acctdim_isenable as org_acc45_18_0_, adclient0_.org_acctdim_header as org_acc46_18_0_, adclient0_.org_acctdim_lines as org_acc47_18_0_, adclient0_.org_acctdim_breakdown as org_acc48_18_0_, adclient0_.daystopasswordexpiration as daystop49_18_0_ from ad_client adclient0_ where adclient0_.ad_client_id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 15 07 60 0ms 0ms 08 140 0ms 0ms 09 195 0ms 0ms 10 397 0ms 0ms 11 161 0ms 0ms 12 200 0ms 0ms 13 266 0ms 0ms 14 149 0ms 0ms 15 173 0ms 0ms 16 276 0ms 0ms 17 182 0ms 0ms 18 160 0ms 0ms 19 120 0ms 0ms 20 120 0ms 0ms 21 122 0ms 0ms 11 2,682 0ms 0ms 0ms 0ms select this_.c_invoice_id as c_invoic1_230_0_, this_.ad_client_id as ad_clien2_230_0_, this_.ad_org_id as ad_org_i3_230_0_, this_.isactive as isactive4_230_0_, this_.created as created5_230_0_, this_.createdby as createdb6_230_0_, this_.updated as updated7_230_0_, this_.updatedby as updatedb8_230_0_, this_.issotrx as issotrx9_230_0_, this_.documentno as documen10_230_0_, this_.docstatus as docstat11_230_0_, this_.docaction as docacti12_230_0_, this_.processing as process13_230_0_, this_.processed as process14_230_0_, this_.posted as posted15_230_0_, this_.c_doctype_id as c_docty16_230_0_, this_.c_doctypetarget_id as c_docty17_230_0_, this_.c_order_id as c_order18_230_0_, this_.description as descrip19_230_0_, this_.isprinted as isprint20_230_0_, this_.salesrep_id as salesre21_230_0_, this_.dateinvoiced as dateinv22_230_0_, this_.dateprinted as datepri23_230_0_, this_.dateacct as dateacc24_230_0_, this_.c_bpartner_id as c_bpart25_230_0_, this_.c_bpartner_location_id as c_bpart26_230_0_, this_.poreference as porefer27_230_0_, this_.isdiscountprinted as isdisco28_230_0_, this_.dateordered as dateord29_230_0_, this_.c_currency_id as c_curre30_230_0_, this_.c_paymentterm_id as c_payme31_230_0_, this_.c_charge_id as c_charg32_230_0_, this_.chargeamt as chargea33_230_0_, this_.totallines as totalli34_230_0_, this_.grandtotal as grandto35_230_0_, this_.m_pricelist_id as m_price36_230_0_, this_.istaxincluded as istaxin37_230_0_, this_.c_campaign_id as c_campa38_230_0_, this_.c_project_id as c_proje39_230_0_, this_.c_activity_id as c_activ40_230_0_, this_.createfrom as createf41_230_0_, this_.generateto as generat42_230_0_, this_.ad_user_id as ad_user43_230_0_, this_.copyfrom as copyfro44_230_0_, this_.isselfservice as isselfs45_230_0_, this_.ad_orgtrx_id as ad_orgt46_230_0_, this_.user1_id as user47_230_0_, this_.user2_id as user48_230_0_, this_.withholdingamount as withhol49_230_0_, this_.taxdate as taxdate50_230_0_, this_.c_withholding_id as c_withh51_230_0_, this_.ispaid as ispaid52_230_0_, this_.em_einv_generated as em_einv53_230_0_, this_.totalpaid as totalpa54_230_0_, this_.em_einv_sent as em_einv55_230_0_, this_.outstandingamt as outstan56_230_0_, this_.daystilldue as daystil57_230_0_, this_.dueamt as dueamt58_230_0_, this_.lastcalculatedondate as lastcal59_230_0_, this_.fin_paymentmethod_id as fin_pay60_230_0_, this_.fin_payment_priority_id as fin_pay61_230_0_, this_.finalsettlement as finalse62_230_0_, this_.daysoutstanding as daysout63_230_0_, this_.percentageoverdue as percent64_230_0_, this_.c_costcenter_id as c_costc65_230_0_, this_.calculate_promotions as calcula66_230_0_, this_.a_asset_id as a_asset67_230_0_, this_.em_aprm_addpayment as em_aprm68_230_0_, this_.iscashvat as iscashv69_230_0_, this_.em_aprm_processinvoice as em_aprm70_230_0_, this_.prepaymentamt as prepaym71_230_0_, this_.createfromorders as createf72_230_0_, this_.createfrominouts as createf73_230_0_, this_.paidamtatinvoicing as paidamt74_230_0_, this_.bpartner_extref as bpartne75_230_0_, this_.em_opxcld_createlines as em_opxc76_230_0_ from c_invoice this_ where this_.issotrx = ? and this_.ad_org_id = ? and this_.ad_org_id in (...) and this_.ad_client_id in (...) and this_.isactive = ? order by this_.documentno desc;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 15 10 786 0ms 0ms 12 343 0ms 0ms 13 343 0ms 0ms 16 867 0ms 0ms 17 343 0ms 0ms 12 2,485 0ms 0ms 0ms 0ms select text.filename as filename, text.text as text, text.isused as isused, text.ad_module_id as moduleid, texttrl.ad_language as trllang, texttrl.text as trltext, texttrl.istranslated as istranslated, ? as orderseq from ad_textinterfaces text, ad_textinterfaces_trl texttrl where text.ad_textinterfaces_id = texttrl.ad_textinterfaces_id and text.filename = ? and text.isused = ? and texttrl.ad_language = ? union select text.filename as filename, text.text as text, text.isused as isused, text.ad_module_id as moduleid, texttrl.ad_language as trllang, texttrl.text as trltext, texttrl.istranslated as istranslated, ? as orderseq from ad_textinterfaces text, ad_textinterfaces_trl texttrl where text.ad_textinterfaces_id = texttrl.ad_textinterfaces_id and text.filename is null and text.isused = ? and texttrl.ad_language = ? union select text.filename as filename, text.text as text, text.isused as isused, text.ad_module_id as moduleid, ? as trllang, text.text as trltext, ? as istranslated, ? as orderseq from ad_textinterfaces text where text.ad_textinterfaces_id not in ( select t.ad_textinterfaces_id from ad_textinterfaces t, ad_textinterfaces_trl trl where t.ad_textinterfaces_id = trl.ad_textinterfaces_id and trl.ad_language = ?) and (text.filename is null or text.filename = ?) and text.isused = ? order by orderseq;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 15 07 60 0ms 0ms 08 116 0ms 0ms 09 181 0ms 0ms 10 349 0ms 0ms 11 123 0ms 0ms 12 159 0ms 0ms 13 237 0ms 0ms 14 131 0ms 0ms 15 135 0ms 0ms 16 325 0ms 0ms 17 162 0ms 0ms 18 145 0ms 0ms 19 120 0ms 0ms 20 120 0ms 0ms 21 122 0ms 0ms 13 2,201 0ms 0ms 0ms 0ms select ? from dual;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 15 07 120 0ms 0ms 08 148 0ms 0ms 09 149 0ms 0ms 10 198 0ms 0ms 11 157 0ms 0ms 12 160 0ms 0ms 13 170 0ms 0ms 14 137 0ms 0ms 15 145 0ms 0ms 16 173 0ms 0ms 17 144 0ms 0ms 18 135 0ms 0ms 19 122 0ms 0ms 20 120 0ms 0ms 21 121 0ms 0ms 22 2 0ms 0ms 14 2,132 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 15 08 155 0ms 0ms 09 737 0ms 0ms 10 775 0ms 0ms 15 310 0ms 0ms 17 155 0ms 0ms 15 2,042 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 #15
Day Hour Count Duration Avg duration Jul 15 08 128 0ms 0ms 09 160 0ms 0ms 10 632 0ms 0ms 11 110 0ms 0ms 12 191 0ms 0ms 13 297 0ms 0ms 14 75 0ms 0ms 15 98 0ms 0ms 16 207 0ms 0ms 17 87 0ms 0ms 18 57 0ms 0ms 16 1,988 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 #16
Day Hour Count Duration Avg duration Jul 15 08 132 0ms 0ms 09 127 0ms 0ms 10 523 0ms 0ms 11 99 0ms 0ms 12 169 0ms 0ms 13 294 0ms 0ms 14 65 0ms 0ms 15 87 0ms 0ms 16 302 0ms 0ms 17 118 0ms 0ms 18 72 0ms 0ms 17 1,980 0ms 0ms 0ms 0ms show server_version;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 15 07 132 0ms 0ms 08 132 0ms 0ms 09 132 0ms 0ms 10 132 0ms 0ms 11 132 0ms 0ms 12 132 0ms 0ms 13 132 0ms 0ms 14 132 0ms 0ms 15 132 0ms 0ms 16 132 0ms 0ms 17 132 0ms 0ms 18 132 0ms 0ms 19 132 0ms 0ms 20 132 0ms 0ms 21 132 0ms 0ms 18 1,950 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 #18
Day Hour Count Duration Avg duration Jul 15 08 99 0ms 0ms 09 124 0ms 0ms 10 533 0ms 0ms 11 95 0ms 0ms 12 184 0ms 0ms 13 283 0ms 0ms 14 71 0ms 0ms 15 81 0ms 0ms 16 301 0ms 0ms 17 104 0ms 0ms 18 73 0ms 0ms 19 2 0ms 0ms 19 1,802 0ms 0ms 0ms 0ms select count(*) from ad_alert where coalesce(status, ?) = ? and ad_client_id in (...) and ad_org_id in (...) and ad_alertrule_id in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 15 08 69 0ms 0ms 09 152 0ms 0ms 10 308 0ms 0ms 11 348 0ms 0ms 12 256 0ms 0ms 13 233 0ms 0ms 14 80 0ms 0ms 15 124 0ms 0ms 16 133 0ms 0ms 17 71 0ms 0ms 18 28 0ms 0ms 20 1,802 0ms 0ms 0ms 0ms select distinct adalertrul1_.ad_alertrule_id as ad_alert1_11_, adalertrul1_.ad_client_id as ad_clien2_11_, adalertrul1_.ad_org_id as ad_org_i3_11_, adalertrul1_.isactive as isactive4_11_, adalertrul1_.created as created5_11_, adalertrul1_.createdby as createdb6_11_, adalertrul1_.updated as updated7_11_, adalertrul1_.updatedby as updatedb8_11_, adalertrul1_.name as name9_11_, adalertrul1_.ad_tab_id as ad_tab_10_11_, adalertrul1_.filterclause as filterc11_11_, adalertrul1_.sql as sql12_11_, adalertrul1_.type as type13_11_ from ad_alertrecipient adalertrec0_ inner join ad_alertrule adalertrul1_ on adalertrec0_.ad_alertrule_id = adalertrul1_.ad_alertrule_id where adalertrul1_.isactive = ? and (adalertrec0_.ad_user_id = ? or (adalertrec0_.ad_user_id is null) and adalertrec0_.ad_role_id = ?) and (adalertrul1_.ad_client_id in (...)) and (adalertrul1_.ad_org_id in (...));Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 15 08 69 0ms 0ms 09 152 0ms 0ms 10 308 0ms 0ms 11 348 0ms 0ms 12 256 0ms 0ms 13 233 0ms 0ms 14 80 0ms 0ms 15 124 0ms 0ms 16 133 0ms 0ms 17 71 0ms 0ms 18 28 0ms 0ms Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 0ms 0ms 2 0ms select * from ( select m_product_category_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id as ad_org_id, ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, m_product_category_id, ?) as record_id from m_product_category pc where exists ( select d.c_acctschema_id from c_acctschema_default d where exists ( select ? from ad_org_acctschema where (ad_isorgincluded (ad_org_id, pc.ad_org_id, pc.ad_client_id) <> ? or ad_isorgincluded (pc.ad_org_id, ad_org_id, pc.ad_client_id) <> ?) and isactive = ? and ad_org_acctschema.c_acctschema_id = d.c_acctschema_id and ad_org_acctschema.ad_client_id = pc.ad_client_id) and not exists ( select pca.c_acctschema_id from m_product_category_acct pca where pca.m_product_category_id = pc.m_product_category_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 #1
Day Hour Count Duration Avg duration Jul 15 15 1 0ms 0ms 21 1 0ms 0ms 2 0ms 0ms 0ms 12 0ms select t.istaxundeductable as ratetaxundeductable, ( select istaxundeductable from ad_orginfo o where o.ad_org_id = it.ad_org_id) as orgtaxundeductable, it.c_tax_id, t.name, t.rate, t.istaxdeductable, sum(it.taxbaseamt) as taxbaseamt, sum(it.taxamt) as taxamt, min(it.line) as line, ? as c_invoice_id, ? as ad_client_id, ? as ad_org_id, ? as isactive, ? as created, ? as createdby, ? as updated, ? as updatedby, ? as issotrx, ? as documentno, ? as docstatus, ? as docaction, ? as processing, ? as processed, ? as posted, ? as c_doctype_id, ? as c_doctypetarget_id, ? as c_order_id, ? as description, ? as istransferred, ? as isprinted, ? as salesrep_id, ? as dateinvoiced, ? as dateprinted, ? as dateacct, ? as c_bpartner_id, ? as c_bpartner_location_id, ? as poreference, ? as isdiscountprinted, ? as dateordered, ? as c_currency_id, ? as paymentrule, ? as c_paymentterm_id, ? as c_charge_id, ? as chargeamt, ? as totallines, ? as grandtotal, ? as m_pricelist_id, ? as istaxincluded, ? as c_campaign_id, ? as c_project_id, ? as c_activity_id, ? as ispaid, ? as createfrom, ? as generateto, ? as sendemail, ? as ad_user_id, ? as copyfrom, ? as isselfservice, ? as ad_orgtrx_id, ? as user1_id, ? as user2_id, ? as amount, ? as status, ? as isreceipt, ? as ismanual, ? as writeoffamt, ? as c_debt_payment_id, ? as p_revenue_acct, ? as p_expense_acct, ? as fin_payment_schedule_id, ? as fin_paymentmethod_id, ? as prepaidamt, ? as fininvcount, ? as finacctcount, ? as fin_payment_id, ? as c_costcenter_id, t.iscashvat as iscashvat, ? as prepaymentamt from c_tax t, c_invoicetax it where t.c_tax_id = it.c_tax_id and it.c_invoice_id = ? group by t.istaxundeductable, it.c_tax_id, t.name, t.rate, t.istaxdeductable, it.ad_org_id, t.iscashvat order by line;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 15 09 1 0ms 0ms 10 3 0ms 0ms 11 1 0ms 0ms 13 2 0ms 0ms 16 4 0ms 0ms 17 1 0ms 0ms 3 0ms 0ms 0ms 1 0ms select pricingpri0_.m_pricelist_version_id as m_pricel1_433_0_, pricingpri0_.ad_client_id as ad_clien2_433_0_, pricingpri0_.ad_org_id as ad_org_i3_433_0_, pricingpri0_.isactive as isactive4_433_0_, pricingpri0_.created as created5_433_0_, pricingpri0_.createdby as createdb6_433_0_, pricingpri0_.updated as updated7_433_0_, pricingpri0_.updatedby as updatedb8_433_0_, pricingpri0_.name as name9_433_0_, pricingpri0_.description as descrip10_433_0_, pricingpri0_.m_pricelist_id as m_price11_433_0_, pricingpri0_.m_discountschema_id as m_disco12_433_0_, pricingpri0_.validfrom as validfr13_433_0_, pricingpri0_.proccreate as proccre14_433_0_, pricingpri0_.m_pricelist_version_base_id as m_price15_433_0_, pricingpri0_.m_pricelist_version_generate as m_price16_433_0_ from m_pricelist_version pricingpri0_ where pricingpri0_.m_pricelist_version_id in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 15 10 1 0ms 0ms 4 0ms 0ms 0ms 74 0ms select coalesce(( select show_in_header from ad_client_acctdimension where ad_client_id = ? and docbasetype = ? and dimension = ?), c.user1_acctdim_header) from ad_client c where c.ad_client_id = ? and c.user1_acctdim_isenable = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 15 16 59 0ms 0ms 18 15 0ms 0ms 5 0ms 0ms 0ms 6 0ms select order0_.c_order_id as c_order_1_246_, order0_.ad_client_id as ad_clien2_246_, order0_.ad_org_id as ad_org_i3_246_, order0_.isactive as isactive4_246_, order0_.created as created5_246_, order0_.createdby as createdb6_246_, order0_.updated as updated7_246_, order0_.updatedby as updatedb8_246_, order0_.issotrx as issotrx9_246_, order0_.documentno as documen10_246_, order0_.docstatus as docstat11_246_, order0_.docaction as docacti12_246_, order0_.processing as process13_246_, order0_.processed as process14_246_, order0_.c_doctype_id as c_docty15_246_, order0_.c_doctypetarget_id as c_docty16_246_, order0_.description as descrip17_246_, order0_.isdelivered as isdeliv18_246_, order0_.isinvoiced as isinvoi19_246_, order0_.isprinted as isprint20_246_, order0_.isselected as isselec21_246_, order0_.salesrep_id as salesre22_246_, order0_.dateordered as dateord23_246_, order0_.datepromised as datepro24_246_, order0_.dateprinted as datepri25_246_, order0_.dateacct as dateacc26_246_, order0_.c_bpartner_id as c_bpart27_246_, order0_.billto_id as billto_28_246_, order0_.c_bpartner_location_id as c_bpart29_246_, order0_.poreference as porefer30_246_, order0_.isdiscountprinted as isdisco31_246_, order0_.c_currency_id as c_curre32_246_, order0_.paymentrule as payment33_246_, order0_.c_paymentterm_id as c_payme34_246_, order0_.invoicerule as invoice35_246_, order0_.deliveryrule as deliver36_246_, order0_.freightcostrule as freight37_246_, order0_.freightamt as freight38_246_, order0_.deliveryviarule as deliver39_246_, order0_.m_shipper_id as m_shipp40_246_, order0_.c_charge_id as c_charg41_246_, order0_.chargeamt as chargea42_246_, order0_.priorityrule as priorit43_246_, order0_.totallines as totalli44_246_, order0_.grandtotal as grandto45_246_, order0_.m_warehouse_id as m_wareh46_246_, order0_.m_pricelist_id as m_price47_246_, order0_.istaxincluded as istaxin48_246_, order0_.c_campaign_id as c_campa49_246_, order0_.c_project_id as c_proje50_246_, order0_.c_activity_id as c_activ51_246_, order0_.posted as posted52_246_, order0_.ad_user_id as ad_user53_246_, order0_.copyfrom as copyfro54_246_, order0_.dropship_bpartner_id as dropshi55_246_, order0_.dropship_location_id as dropshi56_246_, order0_.dropship_user_id as dropshi57_246_, order0_.isselfservice as isselfs58_246_, order0_.ad_orgtrx_id as ad_orgt59_246_, order0_.user1_id as user60_246_, order0_.user2_id as user61_246_, order0_.deliverynotes as deliver62_246_, order0_.c_incoterms_id as c_incot63_246_, order0_.incotermsdescription as incoter64_246_, order0_.generatetemplate as generat65_246_, order0_.delivery_location_id as deliver66_246_, order0_.copyfrompo as copyfro67_246_, order0_.fin_paymentmethod_id as fin_pay68_246_, order0_.fin_payment_priority_id as fin_pay69_246_, order0_.rm_pickfromshipment as rm_pick70_246_, order0_.rm_receivematerials as rm_rece71_246_, order0_.rm_createinvoice as rm_crea72_246_, order0_.c_return_reason_id as c_retur73_246_, order0_.rm_addorphanline as rm_addo74_246_, order0_.a_asset_id as a_asset75_246_, order0_.calculate_promotions as calcula76_246_, order0_.c_costcenter_id as c_costc77_246_, order0_.convertquotation as convert78_246_, order0_.c_reject_reason_id as c_rejec79_246_, order0_.validuntil as validun80_246_, order0_.quotation_id as quotati81_246_, order0_.so_res_status as so_res_82_246_, order0_.create_polines as create_83_246_, order0_.iscashvat as iscashv84_246_, order0_.em_opxmp_buttonpo as em_opxm85_246_, order0_.rm_pickfromreceipt as rm_pick86_246_, order0_.cancelandreplace as cancela87_246_, order0_.em_aprm_addpayment as em_aprm88_246_, order0_.em_opxmp_envdirecto as em_opxm89_246_, order0_.em_opxmp_disenador_id as em_opxm90_246_, order0_.em_opxmp_estado as em_opxm91_246_, order0_.em_opxmp_buttonpv as em_opxm92_246_, order0_.em_opxmp_buttonmail as em_opxm93_246_, order0_.em_mp_infpvint as em_mp_i94_246_, order0_.confirmcancelandreplace as confirm95_246_, order0_.cancelledorder_id as cancell96_246_, order0_.replacedorder_id as replace97_246_, order0_.iscancelled as iscance98_246_, order0_.replacementorder_id as replace99_246_, order0_.bpartner_extref as bpartn100_246_ from c_order order0_ cross join c_doctype documentty1_ where order0_.c_doctypetarget_id = documentty1_.c_doctype_id and order0_.issotrx = ? and documentty1_.isreturn = ? and (documentty1_.docsubtypeso not like ?) and (order0_.updated > ? or order0_.processed = ?) and (order0_.ad_org_id in (...)) and (order0_.ad_client_id in (...)) order by order0_.datepromised desc, order0_.c_order_id desc limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 15 09 3 0ms 0ms 17 3 0ms 0ms 6 0ms 0ms 0ms 41 0ms select users.default_ad_org_id from ad_user users inner join ad_org org on users.default_ad_org_id = org.ad_org_id where users.ad_user_id = ? and not users.default_ad_org_id is null and org.isactive = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 15 08 3 0ms 0ms 09 14 0ms 0ms 10 15 0ms 0ms 15 6 0ms 0ms 17 3 0ms 0ms 7 0ms 0ms 0ms 2 0ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select c_bpartner_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id as ad_org_id, ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_bpartner_id, ?) as record_id from c_bpartner bp where bp.iscustomer = ? and exists ( select d.c_acctschema_id from c_acctschema_default d where exists ( select ? from ad_org_acctschema where (ad_isorgincluded (ad_org_id, bp.ad_org_id, bp.ad_client_id) <> ? or ad_isorgincluded (bp.ad_org_id, ad_org_id, bp.ad_client_id) <> ?) and isactive = ? and ad_org_acctschema.c_acctschema_id = d.c_acctschema_id and ad_org_acctschema.ad_client_id = bp.ad_client_id) and not exists ( select bpca.c_acctschema_id from c_bp_customer_acct bpca where bpca.c_bpartner_id = bp.c_bpartner_id))) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 15 15 1 0ms 0ms 21 1 0ms 0ms 8 0ms 0ms 0ms 93 0ms select coalesce(max(dt.docbasetype), ?) from c_invoice inv join c_doctype dt on (inv.c_doctypetarget_id = dt.c_doctype_id) where inv.c_invoice_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 15 09 4 0ms 0ms 10 11 0ms 0ms 11 4 0ms 0ms 12 8 0ms 0ms 13 3 0ms 0ms 15 3 0ms 0ms 16 36 0ms 0ms 17 16 0ms 0ms 18 8 0ms 0ms 9 0ms 0ms 0ms 6 0ms select this_.opxmail_informes_correo_id as opxmail_1_643_0_, this_.ad_client_id as ad_clien2_643_0_, this_.ad_org_id as ad_org_i3_643_0_, this_.isactive as isactive4_643_0_, this_.created as created5_643_0_, this_.createdby as createdb6_643_0_, this_.updated as updated7_643_0_, this_.updatedby as updatedb8_643_0_, this_.ad_tab_id as ad_tab_i9_643_0_, this_.nombre as nombre10_643_0_, this_.ruta as ruta11_643_0_, this_.ad_module_id as ad_modu12_643_0_, this_.asunto as asunto13_643_0_, this_.mensaje as mensaje14_643_0_ from opxmail_informes_correo this_ where this_.ad_tab_id = ? and this_.ad_org_id in (...) and this_.ad_client_id in (...) and this_.isactive = ? order by this_.nombre asc;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 15 09 1 0ms 0ms 10 1 0ms 0ms 13 1 0ms 0ms 16 2 0ms 0ms 17 1 0ms 0ms 10 0ms 0ms 0ms 594 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 #10
Day Hour Count Duration Avg duration Jul 15 08 33 0ms 0ms 09 68 0ms 0ms 10 161 0ms 0ms 11 33 0ms 0ms 12 50 0ms 0ms 13 113 0ms 0ms 14 17 0ms 0ms 15 31 0ms 0ms 16 45 0ms 0ms 17 26 0ms 0ms 18 17 0ms 0ms 11 0ms 0ms 0ms 98 0ms select adprocessa0_.ad_process_id as col_0_0_ from ad_process_access adprocessa0_ where adprocessa0_.ad_role_id = ? and adprocessa0_.isactive = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 15 08 7 0ms 0ms 09 35 0ms 0ms 10 35 0ms 0ms 15 14 0ms 0ms 17 7 0ms 0ms 12 0ms 0ms 0ms 94 0ms select admessaget0_.ad_message_id as ad_messa2_56_1_, admessaget0_.ad_message_trl_id as ad_messa1_56_1_, admessaget0_.ad_message_trl_id as ad_messa1_56_0_, admessaget0_.ad_message_id as ad_messa2_56_0_, admessaget0_.ad_language as ad_langu3_56_0_, admessaget0_.ad_client_id as ad_clien4_56_0_, admessaget0_.ad_org_id as ad_org_i5_56_0_, admessaget0_.isactive as isactive6_56_0_, admessaget0_.created as created7_56_0_, admessaget0_.createdby as createdb8_56_0_, admessaget0_.updated as updated9_56_0_, admessaget0_.updatedby as updated10_56_0_, admessaget0_.msgtext as msgtext11_56_0_, admessaget0_.msgtip as msgtip12_56_0_, admessaget0_.istranslated as istrans13_56_0_ from ad_message_trl admessaget0_ where admessaget0_.ad_message_id = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 15 08 1 0ms 0ms 09 3 0ms 0ms 10 10 0ms 0ms 11 6 0ms 0ms 12 5 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 3 0ms 0ms 16 48 0ms 0ms 17 7 0ms 0ms 18 9 0ms 0ms 13 0ms 0ms 0ms 28 0ms select this_.obserds_datasource_id as obserds_1_597_0_, this_.ad_client_id as ad_clien2_597_0_, this_.ad_org_id as ad_org_i3_597_0_, this_.ad_module_id as ad_modul4_597_0_, this_.name as name5_597_0_, this_.description as descript6_597_0_, this_.ad_table_id as ad_table7_597_0_, this_.whereclause as wherecla8_597_0_, this_.classname as classnam9_597_0_, this_.obclker_template_id as obclker10_597_0_, this_.isactive as isactiv11_597_0_, this_.created as created12_597_0_, this_.createdby as created13_597_0_, this_.updated as updated14_597_0_, this_.updatedby as updated15_597_0_, this_.useastabledataorigin as useasta16_597_0_, this_.idfkfiltering as idfkfil17_597_0_ from obserds_datasource this_ where this_.name = ? and this_.ad_org_id in (...) and this_.ad_client_id in (...) and this_.isactive = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 15 08 1 0ms 0ms 09 3 0ms 0ms 10 5 0ms 0ms 13 4 0ms 0ms 16 7 0ms 0ms 17 8 0ms 0ms 14 0ms 0ms 0ms 137 0ms select td0.value as id, (coalesce(to_char((( case td0.isactive when ? then ? else ? end) || ( case when td_trl0.name is null then td0.name else td_trl0.name end))), ?)) as name, ( case when td_trl0.description is null then td0.description else td_trl0.description end) as description from ad_ref_list td0 left join ad_ref_list_trl td_trl0 on td0.ad_ref_list_id = td_trl0.ad_ref_list_id and td_trl0.ad_language = ? where td0.ad_reference_id = (?) and ((td0.value in (...) or ( select docsubtypeso from c_doctype where c_doctype.c_doctype_id = ?) <> ?)) and (td0.isactive = ? or td0.value = ?) order by td0.seqno, ( case when td_trl0.name is null then td0.name else td_trl0.name end);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 15 08 8 0ms 0ms 09 10 0ms 0ms 10 50 0ms 0ms 11 3 0ms 0ms 12 10 0ms 0ms 13 41 0ms 0ms 14 3 0ms 0ms 15 1 0ms 0ms 16 4 0ms 0ms 17 4 0ms 0ms 18 3 0ms 0ms 15 0ms 0ms 0ms 1 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 #15
Day Hour Count Duration Avg duration Jul 15 11 1 0ms 0ms 16 0ms 0ms 0ms 5 0ms select td0.c_doctype_id as id, (coalesce(to_char(( case when td_trl1.name is null then coalesce(to_char(td0.name), ?) else coalesce(to_char(td_trl1.name), ?) end)), ?)) as name, ? as description from c_doctype td0 left join c_doctype_trl td_trl1 on td0.c_doctype_id = td_trl1.c_doctype_id and td_trl1.ad_language = ? where td0.ad_client_id in (...) and td0.ad_org_id in (...) and td0.ad_client_id = ? and (? <> ? or coalesce(?, ?) = ?) and (td0.docbasetype in (...) and td0.issotrx = ? and (ad_isorgincluded (?, td0.ad_org_id, ?) <> ? or coalesce(?, ?) = ?) and coalesce(null, ?) = td0.isreturn and ((null = ? and docsubtypeso like ?) or ((null = ? or null is null) and (docsubtypeso is null or docsubtypeso not like ?)))) and (td0.isactive = ? or td0.c_doctype_id = (null)) order by td0.isdefault desc, td0.name limit ? offset ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 15 08 2 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 17 0ms 0ms 0ms 40 0ms select this_.fin_finacc_paymentmethod_id as fin_fina1_329_0_, this_.ad_client_id as ad_clien2_329_0_, this_.ad_org_id as ad_org_i3_329_0_, this_.created as created4_329_0_, this_.createdby as createdb5_329_0_, this_.updated as updated6_329_0_, this_.updatedby as updatedb7_329_0_, this_.isactive as isactive8_329_0_, this_.fin_paymentmethod_id as fin_paym9_329_0_, this_.fin_financial_account_id as fin_fin10_329_0_, this_.automatic_receipt as automat11_329_0_, this_.automatic_payment as automat12_329_0_, this_.automatic_deposit as automat13_329_0_, this_.automatic_withdrawn as automat14_329_0_, this_.payin_allow as payin_a15_329_0_, this_.payout_allow as payout_16_329_0_, this_.payin_execution_type as payin_e17_329_0_, this_.payout_execution_type as payout_18_329_0_, this_.payin_execution_process_id as payin_e19_329_0_, this_.payout_execution_process_id as payout_20_329_0_, this_.payin_deferred as payin_d21_329_0_, this_.payout_deferred as payout_22_329_0_, this_.uponreceiptuse as uponrec23_329_0_, this_.upondeposituse as upondep24_329_0_, this_.inuponclearinguse as inuponc25_329_0_, this_.uponpaymentuse as uponpay26_329_0_, this_.uponwithdrawaluse as uponwit27_329_0_, this_.outuponclearinguse as outupon28_329_0_, this_.payin_ismulticurrency as payin_i29_329_0_, this_.payout_ismulticurrency as payout_30_329_0_, this_.isdefault as isdefau31_329_0_, this_.payin_invoicepaidstatus as payin_i32_329_0_, this_.payout_invoicepaidstatus as payout_33_329_0_ from fin_finacc_paymentmethod this_ where this_.fin_financial_account_id = ? and this_.fin_paymentmethod_id = ? and this_.isactive = ? and this_.isactive = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 15 10 4 0ms 0ms 11 4 0ms 0ms 12 2 0ms 0ms 15 2 0ms 0ms 16 20 0ms 0ms 17 4 0ms 0ms 18 4 0ms 0ms 18 0ms 0ms 0ms 63 0ms select attributes0_.m_attributesetinstance_id as m_attrib1_371_0_, attributes0_.ad_client_id as ad_clien2_371_0_, attributes0_.ad_org_id as ad_org_i3_371_0_, attributes0_.isactive as isactive4_371_0_, attributes0_.created as created5_371_0_, attributes0_.createdby as createdb6_371_0_, attributes0_.updated as updated7_371_0_, attributes0_.updatedby as updatedb8_371_0_, attributes0_.m_attributeset_id as m_attrib9_371_0_, attributes0_.serno as serno10_371_0_, attributes0_.lot as lot11_371_0_, attributes0_.guaranteedate as guarant12_371_0_, attributes0_.description as descrip13_371_0_, attributes0_.m_lot_id as m_lot_i14_371_0_, attributes0_.islocked as islocke15_371_0_, attributes0_.lock_description as lock_de16_371_0_, attributes0_.m_refinventory_id as m_refin17_371_0_, attributes0_.parent_attributesetinstance_id as parent_18_371_0_ from m_attributesetinstance attributes0_ where attributes0_.m_attributesetinstance_id = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 15 08 1 0ms 0ms 09 5 0ms 0ms 10 31 0ms 0ms 12 5 0ms 0ms 13 11 0ms 0ms 14 1 0ms 0ms 15 4 0ms 0ms 16 2 0ms 0ms 17 1 0ms 0ms 18 2 0ms 0ms 19 0ms 0ms 0ms 1,096 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 in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 15 08 79 0ms 0ms 09 84 0ms 0ms 10 298 0ms 0ms 11 51 0ms 0ms 12 112 0ms 0ms 13 145 0ms 0ms 14 44 0ms 0ms 15 44 0ms 0ms 16 141 0ms 0ms 17 63 0ms 0ms 18 30 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 2 0ms 0ms 20 0ms 0ms 0ms 2 0ms select * from ( select a_amortization_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, a.ad_org_id, a.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, a.a_amortization_id, ?) as record_id from a_amortization a, fact_acct f1, fact_acct f2 where 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 and f1.record_id = a.a_amortization_id group by a.a_amortization_id, a.ad_org_id, a.ad_client_id, f1.ad_table_id, f1.record_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 #20
Day Hour Count Duration Avg duration Jul 15 15 1 0ms 0ms 21 1 0ms 0ms Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1s560ms 1 1s560ms 1s560ms 1s560ms BEGIN;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 15 08 1 1s560ms 1s560ms -
BEGIN;
Date: 2026-07-15 08:16:04 Duration: 1s560ms Database: postgres User: etendo Remote: tad Application: 127.0.0.1 Queryid: openbravo
2 1s184ms 1 1s184ms 1s184ms 1s184ms SELECT SUM(TOTAL) AS TOTAL FROM ( SELECT COUNT(*) AS TOTAL FROM AD_Process_Access WHERE AD_Role_ID = $1 AND (TO_CHAR('P') = $2 OR TO_CHAR('R') = $3) AND AD_Process_ID = $4 AND IsActive = 'Y' UNION SELECT COUNT(*) AS TOTAL FROM AD_Form_Access WHERE AD_Role_ID = $5 AND TO_CHAR('X') = $6 AND AD_Form_ID = $7 AND IsActive = 'Y' UNION SELECT COUNT(*) AS TOTAL FROM DUAL WHERE (to_char('800017') = $8 OR to_char('800018') = $9) AND TO_CHAR('TABLE') <> TO_CHAR($10) UNION SELECT COUNT(*) AS TOTAL FROM AD_Window_Access WHERE AD_Role_ID = $11 AND TO_CHAR('W') = $12 AND AD_Window_ID = ( SELECT AD_WINDOW_ID FROM AD_TAB WHERE AD_TAB_ID = $13) AND IsActive = 'Y' 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 = $14 AND TO_CHAR('TABLE') = $15 AND tb.AD_Tab_ID = $16 AND t.IsActive = 'Y' AND t.IsExclude = 'Y' UNION SELECT COUNT(*) AS TOTAL FROM AD_Process_Access A, AD_Process P WHERE AD_Role_ID = $17 AND TO_CHAR('P') = TO_CHAR($18) AND A.AD_Process_ID = $19 AND P.AD_Process_ID = A.AD_Process_ID AND A.IsActive = 'Y' AND P.IsExternalService = 'Y' UNION SELECT 1 AS TOTAL FROM AD_Process WHERE TO_CHAR('P') = TO_CHAR($20) AND AD_Process_ID = $21 AND IsActive = 'Y' AND IsExternalService != 'Y') TOTAL;Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 05 1 1s184ms 1s184ms -
SELECT SUM(TOTAL) AS TOTAL FROM ( SELECT COUNT(*) AS TOTAL FROM AD_Process_Access WHERE AD_Role_ID = $1 AND (TO_CHAR('P') = $2 OR TO_CHAR('R') = $3) AND AD_Process_ID = $4 AND IsActive = 'Y' UNION SELECT COUNT(*) AS TOTAL FROM AD_Form_Access WHERE AD_Role_ID = $5 AND TO_CHAR('X') = $6 AND AD_Form_ID = $7 AND IsActive = 'Y' UNION SELECT COUNT(*) AS TOTAL FROM DUAL WHERE (to_char('800017') = $8 OR to_char('800018') = $9) AND TO_CHAR('TABLE') <> TO_CHAR($10) UNION SELECT COUNT(*) AS TOTAL FROM AD_Window_Access WHERE AD_Role_ID = $11 AND TO_CHAR('W') = $12 AND AD_Window_ID = ( SELECT AD_WINDOW_ID FROM AD_TAB WHERE AD_TAB_ID = $13) AND IsActive = 'Y' 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 = $14 AND TO_CHAR('TABLE') = $15 AND tb.AD_Tab_ID = $16 AND t.IsActive = 'Y' AND t.IsExclude = 'Y' UNION SELECT COUNT(*) AS TOTAL FROM AD_Process_Access A, AD_Process P WHERE AD_Role_ID = $17 AND TO_CHAR('P') = TO_CHAR($18) AND A.AD_Process_ID = $19 AND P.AD_Process_ID = A.AD_Process_ID AND A.IsActive = 'Y' AND P.IsExternalService = 'Y' UNION SELECT 1 AS TOTAL FROM AD_Process WHERE TO_CHAR('P') = TO_CHAR($20) AND AD_Process_ID = $21 AND IsActive = 'Y' AND IsExternalService != 'Y') TOTAL;
Date: 2026-07-15 08:16:07 Duration: 1s184ms Database: postgres User: etendo Remote: tad Application: 127.0.0.1 Queryid: openbravo parameters: $1 = '5C5A74B07D284F41B93CC9D8812BA388', $2 = 'TABLE', $3 = 'TABLE', $4 = '186', $5 = '5C5A74B07D284F41B93CC9D8812BA388', $6 = 'TABLE', $7 = '186', $8 = '186', $9 = '186', $10 = 'TABLE', $11 = '5C5A74B07D284F41B93CC9D8812BA388', $12 = 'TABLE', $13 = '186', $14 = '5C5A74B07D284F41B93CC9D8812BA388', $15 = 'TABLE', $16 = '186', $17 = '5C5A74B07D284F41B93CC9D8812BA388', $18 = 'TABLE', $19 = '186', $20 = 'TABLE', $21 = '186'
3 1s116ms 1 1s116ms 1s116ms 1s116ms SELECT COUNT(*) AS TOTAL FROM AD_SESSION WHERE AD_SESSION_ID = $1 AND SESSION_ACTIVE = 'Y' AND ISACTIVE = 'Y';Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 05 1 1s116ms 1s116ms -
SELECT COUNT(*) AS TOTAL FROM AD_SESSION WHERE AD_SESSION_ID = $1 AND SESSION_ACTIVE = 'Y' AND ISACTIVE = 'Y';
Date: 2026-07-15 08:16:05 Duration: 1s116ms Database: postgres User: etendo Remote: tad Application: 127.0.0.1 Queryid: openbravo parameters: $1 = 'C2DE96ACDA2745CCAE773F42D5F6B8FD'
4 0ms 118 0ms 0ms 0ms ;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration Jul 15 08 2 0ms 0ms 09 4 0ms 0ms 10 33 0ms 0ms 11 7 0ms 0ms 12 7 0ms 0ms 13 10 0ms 0ms 14 2 0ms 0ms 15 3 0ms 0ms 16 21 0ms 0ms 17 16 0ms 0ms 18 6 0ms 0ms 19 3 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,494,903 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
- 10 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 8 Max number of times the same event was reported
- 10 Total events found
Rank Times reported Error 1 8 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 15 09 5 10 2 15 1 - ERROR: column "cost" does not exist at character 49
- ERROR: column "cost" does not exist at character 49
- ERROR: column "cost" does not exist at character 49
Statement: select sum(order0_.TotalLines) as col_0_0_, sum(Cost) as col_1_0_, sum(Margen) as col_2_0_, sum(PMargen)/count(*) as col_3_0_ from C_Order order0_ left outer join C_Invoice invoicelis1_ on order0_.C_Order_ID=invoicelis1_.C_Order_ID cross join C_OrderLine orderline2_ where orderline2_.C_Order_ID=order0_.C_Order_ID and order0_.IsSOTrx='Y' and order0_.DocStatus='CO' and 1=1 limit $1
Date: 2026-07-15 09:18:20 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-15 09:27:41 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-15 09:52:12 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
2 1 ERROR: duplicate key value violates unique constraint "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 15 17 1 - ERROR: duplicate key value violates unique constraint "c_bpartner_value"
Detail: Key (value, ad_org_id, ad_client_id)=(RHONE ALPES SERVICIOS ESPAÑA ETT SLU, 825BF275D875406288FE248FC7D41136, 44FE6AC078E14A6CA5A1189E01E67FB5) already exists.
Statement: insert into C_BPartner (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, Value, Name, Name2, Description, IsSummary, C_BP_Group_ID, IsOneTime, IsProspect, IsVendor, IsCustomer, IsEmployee, IsSalesRep, AD_Language, TaxID, IsTaxExempt, SO_CreditLimit, SO_CreditUsed, C_PaymentTerm_ID, M_PriceList_ID, IsDiscountPrinted, InvoiceRule, SalesRep_ID, ShowPriceInOrder, Invoicegrouping, Isworker, Last_Days, EM_Einv_Einvoice, FIN_Paymentmethod_ID, FIN_Financial_Account_ID, Customer_Blocking, Vendor_Blocking, SO_Payment_Blocking, PO_Payment_Blocking, SO_Invoice_Blocking, PO_Invoice_Blocking, SO_Order_Blocking, PO_Order_Blocking, SO_Goods_Blocking, PO_Goods_Blocking, Iscashvat, Update_Currency, Is_Customer_Consent, EM_OBTIK_Tax_ID_Key, C_BPartner_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51)Date: 2026-07-15 17:02:14 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
3 1 ERROR: @20502@
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 15 13 1 - ERROR: @20502@
Context: PL/pgSQL function c_order_chk_restrinctions_trg() line 60 at RAISE
Statement: update C_Order set Updated=$1, UpdatedBy=$2, C_BPartner_ID=$3, BillTo_ID=$4, C_BPartner_Location_ID=$5, M_PriceList_ID=$6 where C_Order_ID=$7Date: 2026-07-15 13:25:40 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1