pgBadger-
Global information
- Generated on Sat Jul 18 23:00:07 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 31,201 log entries in 6s
- Log start from 2026-07-18 07:00:01 to 2026-07-18 21:59:44
-
Overview
Global Stats
- 11 Number of unique normalized queries
- 58 Number of queries
- 7m8s Total query duration
- 2026-07-18 07:00:01 First query
- 2026-07-18 21:00:01 Last query
- 2 queries/s at 2026-07-18 07:00:01 Query peak
- 7m8s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7m8s Execute total duration
- 6 Number of events
- 2 Number of unique normalized events
- 5 Max number of times the same event was reported
- 0 Number of cancellation
- 96 Total number of automatic vacuums
- 124 Total number of automatic analyzes
- 757 Number temporary file
- 46.52 MiB Max size of temporary file
- 4.54 MiB Average size of temporary file
- 3,277 Total number of sessions
- 10 sessions at 2026-07-18 21:00:01 Session peak
- 3d2m42s Total duration of sessions
- 1m19s Average duration of sessions
- 0 Average queries per session
- 130ms Average queries duration per session
- 1m19s Average idle time per session
- 3,275 Total number of connections
- 5 connections/s at 2026-07-18 07:00:01 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2026-07-18 07:00:01 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-07-18 07:00:01 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-18 10:00:15 Date
Queries duration
Key values
- 7m8s 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 18 07 2 0ms 1s219ms 1s120ms 0ms 0ms 2s240ms 08 2 0ms 1s116ms 1s71ms 0ms 0ms 2s142ms 09 14 0ms 50s166ms 22s719ms 7s97ms 46s617ms 1m39s 10 17 0ms 7s7ms 1s954ms 1s236ms 7s7ms 9s479ms 11 5 0ms 7s55ms 4s620ms 0ms 6s906ms 7s55ms 12 6 0ms 7s121ms 5s983ms 1s180ms 7s26ms 7s121ms 13 1 0ms 1s151ms 1s151ms 0ms 0ms 1s151ms 14 1 0ms 1s102ms 1s102ms 0ms 0ms 1s102ms 15 3 0ms 1s174ms 1s91ms 0ms 0ms 3s275ms 16 1 0ms 1s87ms 1s87ms 0ms 0ms 1s87ms 17 2 0ms 1s162ms 1s95ms 0ms 0ms 2s191ms 18 1 0ms 1s168ms 1s168ms 0ms 0ms 1s168ms 19 1 0ms 1s152ms 1s152ms 0ms 0ms 1s152ms 20 1 0ms 1s130ms 1s130ms 0ms 0ms 1s130ms 21 1 0ms 1s117ms 1s117ms 0ms 0ms 1s117ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 18 07 2 0 1s120ms 0ms 0ms 0ms 08 2 0 1s71ms 0ms 0ms 0ms 09 14 0 22s719ms 0ms 7s97ms 1m37s 10 16 0 1s895ms 0ms 1s236ms 7s7ms 11 5 0 4s620ms 0ms 0ms 6s987ms 12 6 0 5s983ms 0ms 1s180ms 7s51ms 13 1 0 1s151ms 0ms 0ms 0ms 14 1 0 1s102ms 0ms 0ms 0ms 15 3 0 1s91ms 0ms 0ms 0ms 16 1 0 1s87ms 0ms 0ms 0ms 17 2 0 1s95ms 0ms 0ms 0ms 18 1 0 1s168ms 0ms 0ms 0ms 19 1 0 1s152ms 0ms 0ms 0ms 20 1 0 1s130ms 0ms 0ms 0ms 21 1 0 1s117ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 18 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 1 0 2s902ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 18 07 0 2 2.00 0.00% 08 0 2 2.00 0.00% 09 0 14 14.00 0.00% 10 0 17 17.00 0.00% 11 0 5 5.00 0.00% 12 0 6 6.00 0.00% 13 0 1 1.00 0.00% 14 0 1 1.00 0.00% 15 0 3 3.00 0.00% 16 0 1 1.00 0.00% 17 0 2 2.00 0.00% 18 0 1 1.00 0.00% 19 0 1 1.00 0.00% 20 0 1 1.00 0.00% 21 0 1 1.00 0.00% Day Hour Count Average / Second Jul 18 07 217 0.06/s 08 217 0.06/s 09 222 0.06/s 10 217 0.06/s 11 219 0.06/s 12 217 0.06/s 13 219 0.06/s 14 217 0.06/s 15 219 0.06/s 16 217 0.06/s 17 220 0.06/s 18 217 0.06/s 19 219 0.06/s 20 217 0.06/s 21 221 0.06/s Day Hour Count Average Duration Average idle time Jul 18 07 219 1m3s 1m3s 08 217 20ms 10ms 09 222 1m47s 1m46s 10 217 19ms 0ms 11 219 58s919ms 58s814ms 12 217 19ms 0ms 13 219 2m12s 2m12s 14 217 19ms 14ms 15 219 3m16s 3m16s 16 217 18ms 13ms 17 220 5m21s 5m21s 18 217 18ms 13ms 19 219 1m40s 1m40s 20 217 19ms 14ms 21 221 3m18s 3m18s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-18 07:00:01 Date
Connections per database
Key values
- etendo Main Database
- 3,275 connections Total
Connections per user
Key values
- tad Main User
- 3,275 connections Total
-
Sessions
Simultaneous sessions
Key values
- 10 sessions Session Peak
- 2026-07-18 21:00:01 Date
Histogram of session times
Key values
- 3,240 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 3,277 sessions Total
Sessions per user
Key values
- tad Main User
- 3,277 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 3,277 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 30,269 buffers Checkpoint Peak
- 2026-07-18 18:17:38 Date
- 269.884 seconds Highest write time
- 0.648 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-07-18 15:10:55 Date
Checkpoints distance
Key values
- 55.38 Mo Distance Peak
- 2026-07-18 11:07:33 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 18 07 12,139 1,201.581s 0.01s 1,201.6s 08 13,253 1,323.768s 0.009s 1,323.787s 09 14,253 1,406.66s 0.012s 1,406.687s 10 17,730 1,768.306s 0.016s 1,768.334s 11 15,644 1,468.796s 0.011s 1,468.823s 12 18,236 1,821.269s 0.014s 1,821.301s 13 14,392 1,376.692s 0.011s 1,376.718s 14 15,691 1,568.101s 0.011s 1,568.124s 15 14,479 1,404.822s 0.009s 1,404.843s 16 14,785 1,476.923s 0.009s 1,476.943s 17 14,826 1,430.277s 0.009s 1,430.3s 18 44,711 1,713.574s 0.008s 1,713.593s 19 15,485 1,452.719s 0.242s 1,452.972s 20 17,129 1,712.362s 0.657s 1,713.035s 21 15,006 1,447.49s 0.009s 1,447.51s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 18 07 0 6 0 408 0.001s 0.01s 08 0 6 0 506 0.001s 0.009s 09 0 7 0 1,162 0.001s 0.011s 10 0 8 0 1,599 0.001s 0.013s 11 0 7 0 1,224 0.001s 0.011s 12 0 9 0 1,454 0.001s 0.013s 13 0 6 0 454 0.001s 0.011s 14 0 7 0 404 0.001s 0.01s 15 0 7 0 383 0.001s 0.009s 16 0 7 0 386 0.001s 0.009s 17 0 7 0 373 0.001s 0.009s 18 0 7 0 389 0.001s 0.007s 19 0 6 0 386 0.234s 0.015s 20 0 7 0 413 0.648s 0.028s 21 0 6 0 375 0.001s 0.009s Day Hour Count Avg time (sec) Jul 18 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 Day Hour Mean distance Mean estimate Jul 18 07 9,811.80 kB 189,562.80 kB 08 11,626.11 kB 75,558.44 kB 09 10,097.00 kB 34,028.73 kB 10 10,307.38 kB 17,335.38 kB 11 10,978.73 kB 21,198.45 kB 12 10,449.00 kB 14,721.46 kB 13 10,209.00 kB 20,206.36 kB 14 11,222.10 kB 14,113.60 kB 15 12,382.00 kB 21,049.00 kB 16 12,503.56 kB 15,364.44 kB 17 12,459.44 kB 21,431.11 kB 18 14,014.12 kB 18,531.00 kB 19 10,862.78 kB 19,160.33 kB 20 11,519.70 kB 13,970.50 kB 21 11,740.78 kB 19,655.22 kB -
Temporary Files
Size of temporary files
Key values
- 46.52 MiB Temp Files size Peak
- 2026-07-18 12:27:59 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2026-07-18 09:29:25 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 18 07 2 22.72 MiB 11.36 MiB 08 2 22.72 MiB 11.36 MiB 09 617 2.25 GiB 3.73 MiB 10 92 423.06 MiB 4.60 MiB 11 19 211.16 MiB 11.11 MiB 12 7 255.30 MiB 36.47 MiB 13 2 22.72 MiB 11.36 MiB 14 2 22.72 MiB 11.36 MiB 15 2 22.72 MiB 11.36 MiB 16 2 22.72 MiB 11.36 MiB 17 2 22.72 MiB 11.36 MiB 18 2 22.72 MiB 11.36 MiB 19 2 22.72 MiB 11.36 MiB 20 2 22.72 MiB 11.36 MiB 21 2 22.72 MiB 11.36 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 592 2.02 GiB 3.27 MiB 3.72 MiB 3.49 MiB select shipmentin0_.m_inout_id as m_inout_1_509_0_, shipmentin0_.ad_client_id as ad_clien2_509_0_, shipmentin0_.ad_org_id as ad_org_i3_509_0_, ( select count(*) from c_bpartner as bp where bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = ?) > ?) as formula34_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula35_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id in (...);-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('9D60729BADAE4DFEBB393723AA46A9B8', '907395AA40CD4274AECE7E26691CF41E', '2F08189EB11D4B95B70C015C9DD6077C', 'ECA5FA40027D4774A963617F20A182F0', 'C9A66C1D73CD4EAA9A653BC3A834EC8B', 'BF731ED9A22444D69932D55067CCE293', 'BA0DD37FFF49405AB4AC143B9E65AD0A', 'A66132309A6A422BA51FC2B90F9081E2', 'A217C94B57894F7FA59B791FBB7E210D', '9E80B16534FA4450830D2F6F953357D1', '9BA6EC0729E34B88997539E830B001EF', '8577819CD29C40C1A59308306AF3C689', '7FFD4129BE8B43578A912CBF97F0562F', '623A6A2853BE4171BA1F26ED4A75F35A', '47FF59181BC04F739094A7823B20C42A', '2FBF094E5F0B49CDB5A6ABE3A5F4D886', '239264DBCFF1420D9D42E9DB86E5CF26', '20101CF85949484FB7BCFB2AE3C88768', '0C86D437B7AB46B2A17B6865000E794B', '037417A18FF6403684886EABBD4D5057', 'C88F465EDEA34CA39868816F4B96B901', '5ABD202EBA7A425AA48CE424BB714D79', 'FAE634ADA07B4BA0A943FCBC71269F1C', 'F9A194C1F4D0414697752C62AAD78801', 'EF6816B9922F4E4D817CBE44928D53B3', 'EBCD671A6A684CAF81ACA00144BD8448', 'DE2F6D07F55C4F50A200A4C9C6570E9F', 'C904A961AB9940FDADC873790241C5AB', 'BBC8993C9B36449E95538F8BC635937D', 'BB1C633AA69344E3B614CE64E6E5A73F', 'AEF1C3FCAF094D5F942C80E36690146D', '9C0E76DFFBDE45EBA29593B5EFAD52B5', '9B346B691297488E9962D0EC97A6CDB0', '880CE6172F6B48EA9F796E272E126120', '78B7473F77A84DD7A019891D46AB9004', '5C1C8F2C981D4C9BAE7419CD0A5C94C4', '5279BE3A457A4C78941D40E83F9A614C', '444493353F944B54B46CABE5105A8385', '4334DAD2E4834930A087E1D2C413310D', '340559052E2C4EE0BEDEB94D9100AFC1', '07920CA1DF2E4692823C50BA3116F922', '051E8F6455E94FF3B4CB64A83D6D876E', 'F7B1713212A04ED894689CA1528F6415', 'E5AF9004D37D4CA1A45FA90E52E6D6B6', 'E081848A3FAC4E1DB6638C9B2257ED53', 'B5776043334E4F0B95A45E7E9ADB6CB3', 'B4DEB76EB3DE440AA03884C3AD5BC3A7', 'A613569C616B4400A67CF0D2E98E25B8', '9DE3E845BFFC4A90A3DB21B8ECA3AF83', '9CBAA873B64242F48DEE11BD7BDAB6A1');
Date: 2026-07-18 09:30:29 Duration: 50s166ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('9D60729BADAE4DFEBB393723AA46A9B8', '907395AA40CD4274AECE7E26691CF41E', '2F08189EB11D4B95B70C015C9DD6077C', 'ECA5FA40027D4774A963617F20A182F0', 'C9A66C1D73CD4EAA9A653BC3A834EC8B', 'BF731ED9A22444D69932D55067CCE293', 'BA0DD37FFF49405AB4AC143B9E65AD0A', 'A66132309A6A422BA51FC2B90F9081E2', 'A217C94B57894F7FA59B791FBB7E210D', '9E80B16534FA4450830D2F6F953357D1', '9BA6EC0729E34B88997539E830B001EF', '8577819CD29C40C1A59308306AF3C689', '7FFD4129BE8B43578A912CBF97F0562F', '623A6A2853BE4171BA1F26ED4A75F35A', '47FF59181BC04F739094A7823B20C42A', '2FBF094E5F0B49CDB5A6ABE3A5F4D886', '239264DBCFF1420D9D42E9DB86E5CF26', '20101CF85949484FB7BCFB2AE3C88768', '0C86D437B7AB46B2A17B6865000E794B', '037417A18FF6403684886EABBD4D5057', 'C88F465EDEA34CA39868816F4B96B901', '5ABD202EBA7A425AA48CE424BB714D79', 'FAE634ADA07B4BA0A943FCBC71269F1C', 'F9A194C1F4D0414697752C62AAD78801', 'EF6816B9922F4E4D817CBE44928D53B3', 'EBCD671A6A684CAF81ACA00144BD8448', 'DE2F6D07F55C4F50A200A4C9C6570E9F', 'C904A961AB9940FDADC873790241C5AB', 'BBC8993C9B36449E95538F8BC635937D', 'BB1C633AA69344E3B614CE64E6E5A73F', 'AEF1C3FCAF094D5F942C80E36690146D', '9C0E76DFFBDE45EBA29593B5EFAD52B5', '9B346B691297488E9962D0EC97A6CDB0', '880CE6172F6B48EA9F796E272E126120', '78B7473F77A84DD7A019891D46AB9004', '5C1C8F2C981D4C9BAE7419CD0A5C94C4', '5279BE3A457A4C78941D40E83F9A614C', '444493353F944B54B46CABE5105A8385', '4334DAD2E4834930A087E1D2C413310D', '340559052E2C4EE0BEDEB94D9100AFC1', '07920CA1DF2E4692823C50BA3116F922', '051E8F6455E94FF3B4CB64A83D6D876E', 'F7B1713212A04ED894689CA1528F6415', 'E5AF9004D37D4CA1A45FA90E52E6D6B6', 'E081848A3FAC4E1DB6638C9B2257ED53', 'B5776043334E4F0B95A45E7E9ADB6CB3', 'B4DEB76EB3DE440AA03884C3AD5BC3A7', 'A613569C616B4400A67CF0D2E98E25B8', '9DE3E845BFFC4A90A3DB21B8ECA3AF83', '9CBAA873B64242F48DEE11BD7BDAB6A1');
Date: 2026-07-18 09:30:41 Duration: 49s496ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('DA6D5109E0794236A336DF4E401DDF51', 'F0BF886301AD47BEBEBEA9BAD8F71636', 'CC2BBA7A73B942D3B66710128ED64082', 'BCCE65A2565F466D9088812901B72D5A', 'B16D487E8CD745AFB4AC48A70B772809', '8761684D30F444CE8CE5C6601136B819', '83E50806819244D88264DCBBBD91A2E4', '8096BC6CFD6D4A498510F223BB5D1A88', '6D09377074BA408D87545F0CA284AA6F', '6C836A724E2C46D6BEC5A17CBF060CD7', '685E20C464B647FCB1477E28DCB06253', '59A8B55738AB4B27A2CCD1445CB9BC8A', '4F67ABD8FDCF4F39B534D2BEF9CA9E09', '3B9493A345D247B48E1A7E939EBCEE57', '37C4AE7CB5874660947BC07399DF31EF', '1EB9EB0C061F44C68FC6EFA6583E5A5C', '191C177FBCD44B32BCCDC4D21B787689', '038AF2FA2F04427CAED332404A60E870', '01A9D139249C40C3A2D6D9966402D7FA', 'C6DB48F85AE044558DD9CE649FD39252', 'C20A9ACE321845E8AE85033FFB882786', 'C0E80560436344EDA1262F8A7855E811', 'B4A580707B5743AD9EB21DA58FBAD84C', 'AF26C99F1F5B4BDA9ADE33281C824310', 'A74D5584155C4F2ABB29197BEEAB6AEF', 'A0EA6676758A431D97D0EF94B42A67DF', '999BC0DA6F604831BCE836ACC899B166', '8194420624964FAC9C7553A635DC07AC', '7030BD9DBC1F4E9DB35DA9639DAE294A', '6BFB63A78EB74D33BCF96CA70B345A32', '523ABD7E7D6C418997B7FC874D2CF971', '4DA771C0639B4722ABB73776386246C7', '44283D5184804405B5322523206369DF', '2B3669E169F94F159126C4FD0783410C', '0DECD474EEE04C9288CCC2EF80CB9067', 'D77F3EC2F2FB4F0E8167AE5A720DA84B', 'CF4FE921173D4296A13612C39A226ABB', '974C3A378CBC492C8AC100C35B262D28', '92FB4AA6CF8C4016ABCF18B511F990E4', '902BE349A14C46C484FDE3AA4CA87FD1', '70E06199D44142D2AC0425EA5A0E4E25', '6D1A505D0A874F5B8EFD2CADD6542C78', '57CDF98D9C954D519E6902F8AE16AB0E', '40A7E834ED004BC0BC56E8EBC39E3F96', '3EB2D430287B4C578B13E33CD71028B4', '253A1863F8894B348BBC8235B3B7B4FD', 'D1BBB239C3BA4FCE80C09CA8F3AC90DC', 'CBCA234DA9B74D84B2165C1AD8183CBD', 'B203A5E9D8784D56807F6C07C968B979', 'AF9059E7C4F14AB0877DF403E828905D');
Date: 2026-07-18 09:29:51 Duration: 49s155ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
2 122 426.05 MiB 3.27 MiB 3.72 MiB 3.49 MiB select shipmentin0_.m_inout_id as m_inout_1_509_0_, shipmentin0_.ad_client_id as ad_clien2_509_0_, shipmentin0_.ad_org_id as ad_org_i3_509_0_, ( select count(*) from c_bpartner as bp where bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = ?) > ?) as formula34_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula35_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id = ?;-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '31DAF150D8954486B73F1FB987F27C3E';
Date: 2026-07-18 10:21:03 Duration: 1s111ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '31DAF150D8954486B73F1FB987F27C3E';
Date: 2026-07-18 10:21:02 Duration: 1s58ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '4BE1DBCDCCC24B5AABA8C6593DE4C732';
Date: 2026-07-18 10:02:02 Duration: 1s54ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
3 15 181.75 MiB 11.36 MiB 22.72 MiB 12.12 MiB update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select prod.upc as referencekey_id, ad_column_identifier (?, prod.upc, ?) as record_id, ? as ad_role_id, null as ad_user_id, ? || prod.upc as description, ? as isactive, prod.ad_org_id, prod.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from m_product prod where prod.upc is not null and prod.upc <> ? group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > ?) 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 prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-18 07:00:04 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
4 11 124.95 MiB 11.36 MiB 11.36 MiB 11.36 MiB select * from ( select ;-
SELECT * FROM ( select ;
Date: 2026-07-18 08:00:03 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
5 10 465.16 MiB 46.52 MiB 46.52 MiB 46.52 MiB select * from c_order_post (?);-
SELECT * FROM C_ORDER_POST ('9C4FE6DA87D6419EB380830C182D9766');
Date: 2026-07-18 09:09:42 Duration: 10s633ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
SELECT * FROM C_ORDER_POST ('450D7BE6631A43C79AF18E9D6D735D10');
Date: 2026-07-18 12:16:44 Duration: 7s121ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
SELECT * FROM C_ORDER_POST ('B14400AFA01C42CFB0871BEACC37071A');
Date: 2026-07-18 09:53:09 Duration: 7s97ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
6 3 139.55 MiB 46.52 MiB 46.52 MiB 46.52 MiB select * from m_inout_post0 (?);-
SELECT * FROM M_InOut_Post0 ('57F8ACBCB4404F008791C57097576D56');
Date: 2026-07-18 10:27:42 Duration: 7s7ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
SELECT * FROM M_InOut_Post0 ('EF8A7CCEDC1F446A86FB2C2A5D9B7620');
Date: 2026-07-18 10:15:51 Duration: 7s2ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
SELECT * FROM M_InOut_Post0 ('323B0B95EB2946E59E3CEAC1DE7C3AA2');
Date: 2026-07-18 12:27:59 Duration: 6s744ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
7 3 34.08 MiB 11.36 MiB 11.36 MiB 11.36 MiB select * from ( select distinct ad_column_identifier (?, fin_payment_schedule.c_invoice_id, ?) as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = ? group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, ?)) order by ?) 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, ?) != ?);-
SELECT * FROM ( select distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'DF2689B486E04B849AB2F8CD38EE5B23' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 15:00:02 Duration: 1s42ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
SELECT * FROM ( select distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'DF2689B486E04B849AB2F8CD38EE5B23' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 17:00:02 Duration: 1s29ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
SELECT * FROM ( select distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'DF2689B486E04B849AB2F8CD38EE5B23' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 09:00:02 Duration: 1s2ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
Queries generating the largest temporary files
Rank Size Query 1 46.52 MiB SELECT * FROM C_ORDER_POST ($1);[ Date: 2026-07-18 09:09:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2 46.52 MiB SELECT * FROM C_ORDER_POST ($1);[ Date: 2026-07-18 09:18:47 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3 46.52 MiB SELECT * FROM C_ORDER_POST ($1);[ Date: 2026-07-18 09:53:09 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4 46.52 MiB SELECT * FROM M_InOut_Post0 ($1);[ Date: 2026-07-18 10:15:51 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5 46.52 MiB SELECT * FROM M_InOut_Post0 ($1);[ Date: 2026-07-18 10:27:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
6 46.52 MiB SELECT * FROM C_ORDER_POST ($1);[ Date: 2026-07-18 11:02:38 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
7 46.52 MiB SELECT * FROM C_ORDER_POST ($1);[ Date: 2026-07-18 11:17:36 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8 46.52 MiB SELECT * FROM C_ORDER_POST ($1);[ Date: 2026-07-18 11:26:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
9 46.52 MiB SELECT * FROM C_ORDER_POST ($1);[ Date: 2026-07-18 12:10:41 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
10 46.52 MiB SELECT * FROM C_ORDER_POST ($1);[ Date: 2026-07-18 12:16:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
11 46.52 MiB SELECT * FROM M_InOut_Post0 ($1);[ Date: 2026-07-18 12:27:59 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
12 46.52 MiB SELECT * FROM C_ORDER_POST ($1);[ Date: 2026-07-18 12:40:33 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
13 46.52 MiB SELECT * FROM C_ORDER_POST ($1);[ Date: 2026-07-18 12:52:56 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
14 22.72 MiB 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 prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-18 07:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
15 11.36 MiB SELECT * FROM ( select ;[ Date: 2026-07-18 08:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
16 11.36 MiB SELECT * FROM ( select distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = $1 and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-18 09:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
17 11.36 MiB 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 prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-18 09:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
18 11.36 MiB 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 prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-18 08:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
19 11.36 MiB SELECT * FROM ( select ;[ Date: 2026-07-18 10:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
20 11.36 MiB 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 prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-18 10:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 6.87 sec Highest CPU-cost vacuum
Table public.c_invoice
Database etendo - 2026-07-18 18:12:48 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 6.87 sec Highest CPU-cost vacuum
Table public.c_invoice
Database etendo - 2026-07-18 18:12:48 Date
Analyzes per table
Key values
- profile.last_stat_tables_srv1 (15) Main table analyzed (database etendo)
- 124 analyzes Total
Table Number of analyzes etendo.profile.last_stat_tables_srv1 15 etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.last_stat_indexes_srv1 15 etendo.profile.last_stat_statements_srv1 15 etendo.public.ad_ep_instance_para 12 etendo.profile.last_stat_io 8 etendo.profile.tables_list 7 etendo.profile.last_extension_versions 5 etendo.profile.stmt_list 4 etendo.profile.indexes_list 4 etendo.profile.last_stat_activity_count_srv1 4 etendo.public.ad_session 4 etendo.profile.last_stat_slru 2 etendo.public.c_invoice 2 etendo.profile.funcs_list 2 etendo.public.ad_process_request 1 etendo.profile.sample_statements 1 etendo.profile.sample_stat_tables_total 1 etendo.profile.sample_stat_indexes 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.sample_stat_tables 1 etendo.profile.sample_stat_io 1 etendo.profile.sample_stat_slru 1 etendo.profile.sample_stat_database 1 etendo.profile.sample_stat_user_functions 1 Total 124 Vacuums per table
Key values
- profile.last_stat_user_functions_srv1 (15) Main table vacuumed on database etendo
- 96 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_user_functions_srv1 15 15 2,688 0 53 0 0 1,592 45 341,124 0 0 etendo.profile.last_stat_tables_srv1 15 15 15,528 0 226 0 0 11,590 233 1,622,081 0 0 etendo.profile.last_stat_statements_srv1 15 15 7,471 0 114 0 0 4,603 119 789,717 0 0 etendo.profile.last_stat_indexes_srv1 15 15 20,679 0 368 0 0 14,976 375 2,322,328 0 0 etendo.public.ad_ep_instance_para 7 7 420 0 35 0 0 49 16 117,222 0 0 etendo.profile.tables_list 6 6 1,031 0 27 0 0 600 24 193,493 3 25 etendo.profile.last_stat_io 4 4 255 0 18 0 0 29 9 67,208 0 0 etendo.profile.stmt_list 3 3 833 0 72 0 0 499 45 342,724 7 14 etendo.profile.indexes_list 3 3 382 0 17 0 0 106 8 72,994 0 0 etendo.profile.last_stat_activity_count_srv1 2 0 44 0 10 0 0 12 4 21,824 0 0 etendo.profile.funcs_list 2 2 197 0 7 0 0 46 5 43,747 0 0 etendo.profile.last_extension_versions 2 2 102 0 10 0 0 10 4 33,564 0 0 etendo.pg_toast.pg_toast_2619 1 1 774 0 159 0 0 458 137 379,320 50 110 etendo.profile.last_stat_slru 1 1 70 0 5 0 0 5 2 16,696 0 0 etendo.profile.last_stat_database_srv1 1 1 50 0 6 0 0 6 3 20,783 0 0 etendo.profile.sample_stat_io 1 1 132 0 28 0 0 31 3 24,130 0 0 etendo.profile.sample_stat_tables 1 1 2,617 0 1,187 0 0 1,349 73 209,660 0 0 etendo.public.c_invoice 1 1 64,091 0 28,194 0 0 33,426 2,830 4,308,321 1 1 etendo.profile.sample_stat_indexes 1 1 539 0 194 0 0 238 24 92,137 0 0 Total 96 94 117,903 8,143 30,730 0 0 69,625 3,959 11,019,073 61 150 Vacuum throughput per table
Key values
- public.c_invoice (6.87) 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_user_functions_srv1 0 0 0 etendo.profile.last_stat_tables_srv1 0 0 0.16 etendo.profile.last_stat_statements_srv1 0 0 0.04 etendo.profile.last_stat_indexes_srv1 0 0 0.27 etendo.public.ad_ep_instance_para 0 0 0 etendo.profile.tables_list 0 0 0 etendo.profile.last_stat_io 0 0 0 etendo.profile.stmt_list 0 0 0 etendo.profile.indexes_list 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.funcs_list 0 0 0 etendo.profile.last_extension_versions 0 0 0 etendo.pg_toast.pg_toast_2619 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_io 0 0 0 etendo.profile.sample_stat_tables 0 0 0.28 etendo.public.c_invoice 0 0 6.87 etendo.profile.sample_stat_indexes 0 0 0.04 Total 0 0 7.7 Tuples removed per table
Key values
- profile.last_stat_indexes_srv1 (94061) Main table with removed tuples on database etendo
- 180048 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.profile.last_stat_indexes_srv1 15 15 94,061 46,560 0 756 4,972 etendo.profile.last_stat_tables_srv1 15 15 57,833 27,525 0 289 4,165 etendo.profile.last_stat_statements_srv1 15 15 14,839 11,831 0 268 1,332 etendo.profile.last_stat_user_functions_srv1 15 15 7,855 7,095 0 2 485 etendo.profile.sample_stat_tables 1 1 1,505 32,364 0 0 1,173 etendo.profile.tables_list 6 6 1,039 6,000 0 0 180 etendo.public.c_invoice 1 1 992 204,823 0 0 28,233 etendo.profile.sample_stat_indexes 1 1 588 10,664 0 0 183 etendo.pg_toast.pg_toast_2619 1 1 344 1,731 0 0 624 etendo.profile.stmt_list 3 3 199 2,355 0 0 210 etendo.profile.indexes_list 3 3 155 1,053 0 0 30 etendo.profile.last_stat_io 4 4 147 64 0 0 8 etendo.public.ad_ep_instance_para 7 7 146 0 0 7 0 etendo.profile.funcs_list 2 2 124 352 0 0 15 etendo.profile.last_extension_versions 2 2 108 18 0 0 2 etendo.profile.last_stat_slru 1 1 55 5 0 0 1 etendo.profile.last_stat_activity_count_srv1 2 0 48 0 0 2 0 etendo.profile.sample_stat_io 1 1 6 1,107 0 0 26 etendo.profile.last_stat_database_srv1 1 1 4 4 0 0 1 Total 96 94 180,048 353,551 0 1,324 41,640 Pages removed per table
Key values
- profile.last_stat_indexes_srv1 (756) Main table with removed pages on database etendo
- 1324 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed etendo.profile.last_stat_indexes_srv1 15 15 94061 756 etendo.profile.last_stat_tables_srv1 15 15 57833 289 etendo.profile.last_stat_statements_srv1 15 15 14839 268 etendo.public.ad_ep_instance_para 7 7 146 7 etendo.profile.last_stat_user_functions_srv1 15 15 7855 2 etendo.profile.last_stat_activity_count_srv1 2 0 48 2 etendo.profile.tables_list 6 6 1039 0 etendo.pg_toast.pg_toast_2619 1 1 344 0 etendo.profile.stmt_list 3 3 199 0 etendo.profile.last_stat_slru 1 1 55 0 etendo.profile.indexes_list 3 3 155 0 etendo.profile.funcs_list 2 2 124 0 etendo.profile.last_extension_versions 2 2 108 0 etendo.profile.last_stat_database_srv1 1 1 4 0 etendo.profile.sample_stat_io 1 1 6 0 etendo.profile.sample_stat_tables 1 1 1505 0 etendo.public.c_invoice 1 1 992 0 etendo.profile.last_stat_io 4 4 147 0 etendo.profile.sample_stat_indexes 1 1 588 0 Total 96 94 180,048 1,324 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 18 07 5 8 08 5 5 09 9 9 10 7 11 11 8 13 12 8 10 13 7 10 14 6 9 15 4 7 16 6 5 17 7 10 18 6 6 19 7 5 20 5 9 21 6 7 - 6.87 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
- 57 Total read queries
- 1 Total write queries
Queries by database
Key values
- etendo Main database
- 58 Requests
- 7m8s (etendo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 58 Requests
User Request type Count Duration tad Total 58 7m8s delete 1 2s902ms select 57 7m5s Duration by user
Key values
- 7m8s (tad) Main time consuming user
User Request type Count Duration tad Total 58 7m8s delete 1 2s902ms select 57 7m5s Queries by host
Key values
- 127.0.0.1 Main host
- 58 Requests
- 7m8s (127.0.0.1)
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 58 Requests
- 7m8s (openbravo)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-18 19:19:44 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 51 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 50s166ms select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('9D60729BADAE4DFEBB393723AA46A9B8', '907395AA40CD4274AECE7E26691CF41E', '2F08189EB11D4B95B70C015C9DD6077C', 'ECA5FA40027D4774A963617F20A182F0', 'C9A66C1D73CD4EAA9A653BC3A834EC8B', 'BF731ED9A22444D69932D55067CCE293', 'BA0DD37FFF49405AB4AC143B9E65AD0A', 'A66132309A6A422BA51FC2B90F9081E2', 'A217C94B57894F7FA59B791FBB7E210D', '9E80B16534FA4450830D2F6F953357D1', '9BA6EC0729E34B88997539E830B001EF', '8577819CD29C40C1A59308306AF3C689', '7FFD4129BE8B43578A912CBF97F0562F', '623A6A2853BE4171BA1F26ED4A75F35A', '47FF59181BC04F739094A7823B20C42A', '2FBF094E5F0B49CDB5A6ABE3A5F4D886', '239264DBCFF1420D9D42E9DB86E5CF26', '20101CF85949484FB7BCFB2AE3C88768', '0C86D437B7AB46B2A17B6865000E794B', '037417A18FF6403684886EABBD4D5057', 'C88F465EDEA34CA39868816F4B96B901', '5ABD202EBA7A425AA48CE424BB714D79', 'FAE634ADA07B4BA0A943FCBC71269F1C', 'F9A194C1F4D0414697752C62AAD78801', 'EF6816B9922F4E4D817CBE44928D53B3', 'EBCD671A6A684CAF81ACA00144BD8448', 'DE2F6D07F55C4F50A200A4C9C6570E9F', 'C904A961AB9940FDADC873790241C5AB', 'BBC8993C9B36449E95538F8BC635937D', 'BB1C633AA69344E3B614CE64E6E5A73F', 'AEF1C3FCAF094D5F942C80E36690146D', '9C0E76DFFBDE45EBA29593B5EFAD52B5', '9B346B691297488E9962D0EC97A6CDB0', '880CE6172F6B48EA9F796E272E126120', '78B7473F77A84DD7A019891D46AB9004', '5C1C8F2C981D4C9BAE7419CD0A5C94C4', '5279BE3A457A4C78941D40E83F9A614C', '444493353F944B54B46CABE5105A8385', '4334DAD2E4834930A087E1D2C413310D', '340559052E2C4EE0BEDEB94D9100AFC1', '07920CA1DF2E4692823C50BA3116F922', '051E8F6455E94FF3B4CB64A83D6D876E', 'F7B1713212A04ED894689CA1528F6415', 'E5AF9004D37D4CA1A45FA90E52E6D6B6', 'E081848A3FAC4E1DB6638C9B2257ED53', 'B5776043334E4F0B95A45E7E9ADB6CB3', 'B4DEB76EB3DE440AA03884C3AD5BC3A7', 'A613569C616B4400A67CF0D2E98E25B8', '9DE3E845BFFC4A90A3DB21B8ECA3AF83', '9CBAA873B64242F48DEE11BD7BDAB6A1');[ Date: 2026-07-18 09:30:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
2 49s496ms select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('9D60729BADAE4DFEBB393723AA46A9B8', '907395AA40CD4274AECE7E26691CF41E', '2F08189EB11D4B95B70C015C9DD6077C', 'ECA5FA40027D4774A963617F20A182F0', 'C9A66C1D73CD4EAA9A653BC3A834EC8B', 'BF731ED9A22444D69932D55067CCE293', 'BA0DD37FFF49405AB4AC143B9E65AD0A', 'A66132309A6A422BA51FC2B90F9081E2', 'A217C94B57894F7FA59B791FBB7E210D', '9E80B16534FA4450830D2F6F953357D1', '9BA6EC0729E34B88997539E830B001EF', '8577819CD29C40C1A59308306AF3C689', '7FFD4129BE8B43578A912CBF97F0562F', '623A6A2853BE4171BA1F26ED4A75F35A', '47FF59181BC04F739094A7823B20C42A', '2FBF094E5F0B49CDB5A6ABE3A5F4D886', '239264DBCFF1420D9D42E9DB86E5CF26', '20101CF85949484FB7BCFB2AE3C88768', '0C86D437B7AB46B2A17B6865000E794B', '037417A18FF6403684886EABBD4D5057', 'C88F465EDEA34CA39868816F4B96B901', '5ABD202EBA7A425AA48CE424BB714D79', 'FAE634ADA07B4BA0A943FCBC71269F1C', 'F9A194C1F4D0414697752C62AAD78801', 'EF6816B9922F4E4D817CBE44928D53B3', 'EBCD671A6A684CAF81ACA00144BD8448', 'DE2F6D07F55C4F50A200A4C9C6570E9F', 'C904A961AB9940FDADC873790241C5AB', 'BBC8993C9B36449E95538F8BC635937D', 'BB1C633AA69344E3B614CE64E6E5A73F', 'AEF1C3FCAF094D5F942C80E36690146D', '9C0E76DFFBDE45EBA29593B5EFAD52B5', '9B346B691297488E9962D0EC97A6CDB0', '880CE6172F6B48EA9F796E272E126120', '78B7473F77A84DD7A019891D46AB9004', '5C1C8F2C981D4C9BAE7419CD0A5C94C4', '5279BE3A457A4C78941D40E83F9A614C', '444493353F944B54B46CABE5105A8385', '4334DAD2E4834930A087E1D2C413310D', '340559052E2C4EE0BEDEB94D9100AFC1', '07920CA1DF2E4692823C50BA3116F922', '051E8F6455E94FF3B4CB64A83D6D876E', 'F7B1713212A04ED894689CA1528F6415', 'E5AF9004D37D4CA1A45FA90E52E6D6B6', 'E081848A3FAC4E1DB6638C9B2257ED53', 'B5776043334E4F0B95A45E7E9ADB6CB3', 'B4DEB76EB3DE440AA03884C3AD5BC3A7', 'A613569C616B4400A67CF0D2E98E25B8', '9DE3E845BFFC4A90A3DB21B8ECA3AF83', '9CBAA873B64242F48DEE11BD7BDAB6A1');[ Date: 2026-07-18 09:30:41 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3 49s155ms select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('DA6D5109E0794236A336DF4E401DDF51', 'F0BF886301AD47BEBEBEA9BAD8F71636', 'CC2BBA7A73B942D3B66710128ED64082', 'BCCE65A2565F466D9088812901B72D5A', 'B16D487E8CD745AFB4AC48A70B772809', '8761684D30F444CE8CE5C6601136B819', '83E50806819244D88264DCBBBD91A2E4', '8096BC6CFD6D4A498510F223BB5D1A88', '6D09377074BA408D87545F0CA284AA6F', '6C836A724E2C46D6BEC5A17CBF060CD7', '685E20C464B647FCB1477E28DCB06253', '59A8B55738AB4B27A2CCD1445CB9BC8A', '4F67ABD8FDCF4F39B534D2BEF9CA9E09', '3B9493A345D247B48E1A7E939EBCEE57', '37C4AE7CB5874660947BC07399DF31EF', '1EB9EB0C061F44C68FC6EFA6583E5A5C', '191C177FBCD44B32BCCDC4D21B787689', '038AF2FA2F04427CAED332404A60E870', '01A9D139249C40C3A2D6D9966402D7FA', 'C6DB48F85AE044558DD9CE649FD39252', 'C20A9ACE321845E8AE85033FFB882786', 'C0E80560436344EDA1262F8A7855E811', 'B4A580707B5743AD9EB21DA58FBAD84C', 'AF26C99F1F5B4BDA9ADE33281C824310', 'A74D5584155C4F2ABB29197BEEAB6AEF', 'A0EA6676758A431D97D0EF94B42A67DF', '999BC0DA6F604831BCE836ACC899B166', '8194420624964FAC9C7553A635DC07AC', '7030BD9DBC1F4E9DB35DA9639DAE294A', '6BFB63A78EB74D33BCF96CA70B345A32', '523ABD7E7D6C418997B7FC874D2CF971', '4DA771C0639B4722ABB73776386246C7', '44283D5184804405B5322523206369DF', '2B3669E169F94F159126C4FD0783410C', '0DECD474EEE04C9288CCC2EF80CB9067', 'D77F3EC2F2FB4F0E8167AE5A720DA84B', 'CF4FE921173D4296A13612C39A226ABB', '974C3A378CBC492C8AC100C35B262D28', '92FB4AA6CF8C4016ABCF18B511F990E4', '902BE349A14C46C484FDE3AA4CA87FD1', '70E06199D44142D2AC0425EA5A0E4E25', '6D1A505D0A874F5B8EFD2CADD6542C78', '57CDF98D9C954D519E6902F8AE16AB0E', '40A7E834ED004BC0BC56E8EBC39E3F96', '3EB2D430287B4C578B13E33CD71028B4', '253A1863F8894B348BBC8235B3B7B4FD', 'D1BBB239C3BA4FCE80C09CA8F3AC90DC', 'CBCA234DA9B74D84B2165C1AD8183CBD', 'B203A5E9D8784D56807F6C07C968B979', 'AF9059E7C4F14AB0877DF403E828905D');[ Date: 2026-07-18 09:29:51 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
4 48s249ms select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('DA6D5109E0794236A336DF4E401DDF51', 'F0BF886301AD47BEBEBEA9BAD8F71636', 'CC2BBA7A73B942D3B66710128ED64082', 'BCCE65A2565F466D9088812901B72D5A', 'B16D487E8CD745AFB4AC48A70B772809', '8761684D30F444CE8CE5C6601136B819', '83E50806819244D88264DCBBBD91A2E4', '8096BC6CFD6D4A498510F223BB5D1A88', '6D09377074BA408D87545F0CA284AA6F', '6C836A724E2C46D6BEC5A17CBF060CD7', '685E20C464B647FCB1477E28DCB06253', '59A8B55738AB4B27A2CCD1445CB9BC8A', '4F67ABD8FDCF4F39B534D2BEF9CA9E09', '3B9493A345D247B48E1A7E939EBCEE57', '37C4AE7CB5874660947BC07399DF31EF', '1EB9EB0C061F44C68FC6EFA6583E5A5C', '191C177FBCD44B32BCCDC4D21B787689', '038AF2FA2F04427CAED332404A60E870', '01A9D139249C40C3A2D6D9966402D7FA', 'C6DB48F85AE044558DD9CE649FD39252', 'C20A9ACE321845E8AE85033FFB882786', 'C0E80560436344EDA1262F8A7855E811', 'B4A580707B5743AD9EB21DA58FBAD84C', 'AF26C99F1F5B4BDA9ADE33281C824310', 'A74D5584155C4F2ABB29197BEEAB6AEF', 'A0EA6676758A431D97D0EF94B42A67DF', '999BC0DA6F604831BCE836ACC899B166', '8194420624964FAC9C7553A635DC07AC', '7030BD9DBC1F4E9DB35DA9639DAE294A', '6BFB63A78EB74D33BCF96CA70B345A32', '523ABD7E7D6C418997B7FC874D2CF971', '4DA771C0639B4722ABB73776386246C7', '44283D5184804405B5322523206369DF', '2B3669E169F94F159126C4FD0783410C', '0DECD474EEE04C9288CCC2EF80CB9067', 'D77F3EC2F2FB4F0E8167AE5A720DA84B', 'CF4FE921173D4296A13612C39A226ABB', '974C3A378CBC492C8AC100C35B262D28', '92FB4AA6CF8C4016ABCF18B511F990E4', '902BE349A14C46C484FDE3AA4CA87FD1', '70E06199D44142D2AC0425EA5A0E4E25', '6D1A505D0A874F5B8EFD2CADD6542C78', '57CDF98D9C954D519E6902F8AE16AB0E', '40A7E834ED004BC0BC56E8EBC39E3F96', '3EB2D430287B4C578B13E33CD71028B4', '253A1863F8894B348BBC8235B3B7B4FD', 'D1BBB239C3BA4FCE80C09CA8F3AC90DC', 'CBCA234DA9B74D84B2165C1AD8183CBD', 'B203A5E9D8784D56807F6C07C968B979', 'AF9059E7C4F14AB0877DF403E828905D');[ Date: 2026-07-18 09:29:39 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
5 46s617ms select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('F0BF886301AD47BEBEBEA9BAD8F71636', 'CC2BBA7A73B942D3B66710128ED64082', 'BCCE65A2565F466D9088812901B72D5A', 'B16D487E8CD745AFB4AC48A70B772809', '8761684D30F444CE8CE5C6601136B819', '83E50806819244D88264DCBBBD91A2E4', '8096BC6CFD6D4A498510F223BB5D1A88', '6D09377074BA408D87545F0CA284AA6F', '6C836A724E2C46D6BEC5A17CBF060CD7', '59A8B55738AB4B27A2CCD1445CB9BC8A', '4F67ABD8FDCF4F39B534D2BEF9CA9E09', '3B9493A345D247B48E1A7E939EBCEE57', '37C4AE7CB5874660947BC07399DF31EF', '1EB9EB0C061F44C68FC6EFA6583E5A5C', '191C177FBCD44B32BCCDC4D21B787689', '038AF2FA2F04427CAED332404A60E870', '01A9D139249C40C3A2D6D9966402D7FA', 'C20A9ACE321845E8AE85033FFB882786', 'C9A66C1D73CD4EAA9A653BC3A834EC8B', '20101CF85949484FB7BCFB2AE3C88768', '5C1C8F2C981D4C9BAE7419CD0A5C94C4', '9D2FC4CF3D2D4DDC8DF9765E7605691D', '63A32197912B4B71BF77B4EEF946B34D', '1008095BD92E4B8DB34473FEE5016D28', 'AECBF75476BD40B2AC3EC56CD97F8CA0', 'D2410710DE3347D5B92601793A8FAEF9', 'D09A8A82FBB543F3A09826BA68EC71B7', '1F9CAC0DF2A34234AABA0DEB5CA8B8A1', 'B38E57DC5ED745879E9B5DEB9A6B4D79', '8E2109762FEA466D8C789618826A5271', '4B0B13AF4BF44FF2B2FAC737A1D88CFB', '4720BEB693DB4A54838A2E7A979C6513', '2E1C4C1CF9854E4DB0C796A6F7B5C77B', '4A6A46FCC7994A4DB404DFEFF810C169', '10EA0F995FCC45CC8851599FE8AC2E1A', 'FB91D872258A4A8BAA148B0C5E07E259', 'D759C50627064EA18D1918EFCC22DE2E', '8D58C7781E78431C807F8AEF6A394261', '6770442A0F6F4E83B467CE84E9D2B6B9', 'E66EBA8734D94BD485D9431FEE736A3A', 'F8C3BE00B80E4107A8334ED48B906103', '1D870037B76440B6B11CD5BAE6AF9A8F', '276E345EC9114AD386996E237806F436', '53476E9202344750A17B65E0D7B5C507', '98CD786335B14EED9989AE41BDE30AF2', '8117EE401ED148DD9F0EDC96683BF486', 'E6D34646F0B648E18B83D48D2B80469F', 'F88A9DEEF6134A1097DAE830DE93D46D', 'C5030A142C6F40799D6E86514D9F4140', 'F55936E68F2B483399FF78BD96B5BFC8');[ Date: 2026-07-18 09:27:43 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
6 44s150ms select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('8AA7984053D14BC6905AE63ADC78601C', '9A496CB6DEF24CE4A83D6298AE7C21B3', '945190F37ED446429A6A95913E39B50D', '3D6CD81DD33140F18C23EB552CB46E0A', '2112A0BB62004A48A967CD5E48DD20FE', '06EACD640160475FBC8079DE0DAF02A4', 'B482A628F9794306AFA5013E9FC0F4A9', '3002A1CFB4AA4B49AE6404C033589E42', '5FEB973579DE44889E19D4F1C0F8FA9A', 'FF6447329B1447FDAAA2AB2752D97208', '83BB29E7E7E74DC4A03501CEB4529285', 'E93A50089A854CAC91E7F5BB5184C789', 'E172D7AC85754862A45DA794E06A7674', '4E19576B656F4F13B7C3BC264E77CF63', '865EA05416C6412882BD7A834E48C24E', '022E37A3D8884E46A1F8C99817D58A7A', '189E18A85193409DA9AB21B078C9D994', '5F68635D2A0F4B32A7AA3E2E63AC1E99', '4775DAB4E16046A596343DB74DFE551F', '0F922FACC39B4D8F9ACEFD2C597117C5', '9D0F78B7AD414B4EB01479BC004930E7', '1DE15C0762BE4FD69B5A43760E77737E', 'EDFD15C6DB5F43789BB9BE1E2ECE9E61', '743F5C648A584ABDB60C28500405D3D1', '63E804AE53A6471C8A2A44F6D665832E', '46205F5551B045ECB19109C6B847E1EB', '37F6ECB73010413EA47D8E57A1C515A1', 'F6D698D39C6142DAA62163BB3E604DE6', 'FC4EEBB3A712446EA15DA60732CB730C', '9592129F6E434246BF41F04DDE09FBC1', 'DC6A5FAEF200451A88D938FDE818B787', 'F5D709318C1540F4904EC8DD0B698EC1', '5ECA728F595C4872B7CB8F1845FF2CC1', '5C39152B55C54936A3F89A2811D93D61', '3FB036C1C95342F0B4CFA7C7A89E6532', '5037EC6C659C477BA655F183D844D891', 'E7B97409090746FBA3CEA0481F92F9BC', 'CE68C90E929E49BABA153DA523C4284D', '385AFE429BDB4DC3B9CEE461F91FF182', '36D1591D1E924693B24B395AC86701CE', '8C88DC860C274A70A36873B6EE5C2B36', '32B09F6135BB4433B0B364E1C640EFB7', 'F89915877B504439B9B156CBE98AD536', '429D6C9429A740A2A7FD849000B4012D', 'EE279625B4894C2E98D2DDEE2F65DF4C', 'B131C2148EB24480BCC538FB35E6FED8', 'CC3596D502B146D3B1F377276ED40231', '1CF8372D90044846B871B8DAFDB6AA66', '3C240F74526A4A29A77097DCFAB376D3', 'C7A4E2823AC5457EB3512DC05ABD6717');[ Date: 2026-07-18 09:28:27 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
7 10s633ms SELECT * FROM C_ORDER_POST ('9C4FE6DA87D6419EB380830C182D9766');[ Date: 2026-07-18 09:09:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
8 7s121ms SELECT * FROM C_ORDER_POST ('450D7BE6631A43C79AF18E9D6D735D10');[ Date: 2026-07-18 12:16:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
9 7s97ms SELECT * FROM C_ORDER_POST ('B14400AFA01C42CFB0871BEACC37071A');[ Date: 2026-07-18 09:53:09 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
10 7s55ms SELECT * FROM C_ORDER_POST ('FDD8BCDBA1F34DD998DE7806FF69374B');[ Date: 2026-07-18 11:17:36 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
11 7s51ms SELECT * FROM C_ORDER_POST ('CCDD6437C20743BA9372C8E57ADADEAB');[ Date: 2026-07-18 12:40:33 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
12 7s26ms SELECT * FROM C_ORDER_POST ('CFCA3F71714E4A71B1A93D1AB0F1BDBB');[ Date: 2026-07-18 12:10:41 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
13 7s7ms SELECT * FROM M_InOut_Post0 ('57F8ACBCB4404F008791C57097576D56');[ Date: 2026-07-18 10:27:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
14 7s6ms SELECT * FROM C_ORDER_POST ('DA54757389704349A428C895474BC2DA');[ Date: 2026-07-18 09:18:47 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
15 7s2ms SELECT * FROM M_InOut_Post0 ('EF8A7CCEDC1F446A86FB2C2A5D9B7620');[ Date: 2026-07-18 10:15:51 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
16 6s987ms SELECT * FROM C_ORDER_POST ('C50CB88AAE2D43E0ACDAB5D88EFBE764');[ Date: 2026-07-18 11:02:38 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
17 6s906ms SELECT * FROM C_ORDER_POST ('AA007EB63B0C48378D9C0428CAAAEFE4');[ Date: 2026-07-18 11:26:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
18 6s778ms SELECT * FROM C_ORDER_POST ('75E86BE5D2C84D04BBE44B0B053AD488');[ Date: 2026-07-18 12:52:56 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
19 6s744ms SELECT * FROM M_InOut_Post0 ('323B0B95EB2946E59E3CEAC1DE7C3AA2');[ Date: 2026-07-18 12:27:59 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
20 2s902ms delete from M_Product where M_Product_ID = '920E9847CD2B4D99BD22B8FE0FE94EBD';[ Date: 2026-07-18 10:00:15 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 4m47s 6 44s150ms 50s166ms 47s972ms select shipmentin0_.m_inout_id as m_inout_1_509_0_, shipmentin0_.ad_client_id as ad_clien2_509_0_, shipmentin0_.ad_org_id as ad_org_i3_509_0_, ( select count(*) from c_bpartner as bp where bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = ?) > ?) as formula34_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula35_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 18 09 6 4m47s 47s972ms [ User: tad - Total duration: 4m47s - Times executed: 6 ]
[ Application: openbravo - Total duration: 4m47s - Times executed: 6 ]
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('9D60729BADAE4DFEBB393723AA46A9B8', '907395AA40CD4274AECE7E26691CF41E', '2F08189EB11D4B95B70C015C9DD6077C', 'ECA5FA40027D4774A963617F20A182F0', 'C9A66C1D73CD4EAA9A653BC3A834EC8B', 'BF731ED9A22444D69932D55067CCE293', 'BA0DD37FFF49405AB4AC143B9E65AD0A', 'A66132309A6A422BA51FC2B90F9081E2', 'A217C94B57894F7FA59B791FBB7E210D', '9E80B16534FA4450830D2F6F953357D1', '9BA6EC0729E34B88997539E830B001EF', '8577819CD29C40C1A59308306AF3C689', '7FFD4129BE8B43578A912CBF97F0562F', '623A6A2853BE4171BA1F26ED4A75F35A', '47FF59181BC04F739094A7823B20C42A', '2FBF094E5F0B49CDB5A6ABE3A5F4D886', '239264DBCFF1420D9D42E9DB86E5CF26', '20101CF85949484FB7BCFB2AE3C88768', '0C86D437B7AB46B2A17B6865000E794B', '037417A18FF6403684886EABBD4D5057', 'C88F465EDEA34CA39868816F4B96B901', '5ABD202EBA7A425AA48CE424BB714D79', 'FAE634ADA07B4BA0A943FCBC71269F1C', 'F9A194C1F4D0414697752C62AAD78801', 'EF6816B9922F4E4D817CBE44928D53B3', 'EBCD671A6A684CAF81ACA00144BD8448', 'DE2F6D07F55C4F50A200A4C9C6570E9F', 'C904A961AB9940FDADC873790241C5AB', 'BBC8993C9B36449E95538F8BC635937D', 'BB1C633AA69344E3B614CE64E6E5A73F', 'AEF1C3FCAF094D5F942C80E36690146D', '9C0E76DFFBDE45EBA29593B5EFAD52B5', '9B346B691297488E9962D0EC97A6CDB0', '880CE6172F6B48EA9F796E272E126120', '78B7473F77A84DD7A019891D46AB9004', '5C1C8F2C981D4C9BAE7419CD0A5C94C4', '5279BE3A457A4C78941D40E83F9A614C', '444493353F944B54B46CABE5105A8385', '4334DAD2E4834930A087E1D2C413310D', '340559052E2C4EE0BEDEB94D9100AFC1', '07920CA1DF2E4692823C50BA3116F922', '051E8F6455E94FF3B4CB64A83D6D876E', 'F7B1713212A04ED894689CA1528F6415', 'E5AF9004D37D4CA1A45FA90E52E6D6B6', 'E081848A3FAC4E1DB6638C9B2257ED53', 'B5776043334E4F0B95A45E7E9ADB6CB3', 'B4DEB76EB3DE440AA03884C3AD5BC3A7', 'A613569C616B4400A67CF0D2E98E25B8', '9DE3E845BFFC4A90A3DB21B8ECA3AF83', '9CBAA873B64242F48DEE11BD7BDAB6A1');
Date: 2026-07-18 09:30:29 Duration: 50s166ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('9D60729BADAE4DFEBB393723AA46A9B8', '907395AA40CD4274AECE7E26691CF41E', '2F08189EB11D4B95B70C015C9DD6077C', 'ECA5FA40027D4774A963617F20A182F0', 'C9A66C1D73CD4EAA9A653BC3A834EC8B', 'BF731ED9A22444D69932D55067CCE293', 'BA0DD37FFF49405AB4AC143B9E65AD0A', 'A66132309A6A422BA51FC2B90F9081E2', 'A217C94B57894F7FA59B791FBB7E210D', '9E80B16534FA4450830D2F6F953357D1', '9BA6EC0729E34B88997539E830B001EF', '8577819CD29C40C1A59308306AF3C689', '7FFD4129BE8B43578A912CBF97F0562F', '623A6A2853BE4171BA1F26ED4A75F35A', '47FF59181BC04F739094A7823B20C42A', '2FBF094E5F0B49CDB5A6ABE3A5F4D886', '239264DBCFF1420D9D42E9DB86E5CF26', '20101CF85949484FB7BCFB2AE3C88768', '0C86D437B7AB46B2A17B6865000E794B', '037417A18FF6403684886EABBD4D5057', 'C88F465EDEA34CA39868816F4B96B901', '5ABD202EBA7A425AA48CE424BB714D79', 'FAE634ADA07B4BA0A943FCBC71269F1C', 'F9A194C1F4D0414697752C62AAD78801', 'EF6816B9922F4E4D817CBE44928D53B3', 'EBCD671A6A684CAF81ACA00144BD8448', 'DE2F6D07F55C4F50A200A4C9C6570E9F', 'C904A961AB9940FDADC873790241C5AB', 'BBC8993C9B36449E95538F8BC635937D', 'BB1C633AA69344E3B614CE64E6E5A73F', 'AEF1C3FCAF094D5F942C80E36690146D', '9C0E76DFFBDE45EBA29593B5EFAD52B5', '9B346B691297488E9962D0EC97A6CDB0', '880CE6172F6B48EA9F796E272E126120', '78B7473F77A84DD7A019891D46AB9004', '5C1C8F2C981D4C9BAE7419CD0A5C94C4', '5279BE3A457A4C78941D40E83F9A614C', '444493353F944B54B46CABE5105A8385', '4334DAD2E4834930A087E1D2C413310D', '340559052E2C4EE0BEDEB94D9100AFC1', '07920CA1DF2E4692823C50BA3116F922', '051E8F6455E94FF3B4CB64A83D6D876E', 'F7B1713212A04ED894689CA1528F6415', 'E5AF9004D37D4CA1A45FA90E52E6D6B6', 'E081848A3FAC4E1DB6638C9B2257ED53', 'B5776043334E4F0B95A45E7E9ADB6CB3', 'B4DEB76EB3DE440AA03884C3AD5BC3A7', 'A613569C616B4400A67CF0D2E98E25B8', '9DE3E845BFFC4A90A3DB21B8ECA3AF83', '9CBAA873B64242F48DEE11BD7BDAB6A1');
Date: 2026-07-18 09:30:41 Duration: 49s496ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('DA6D5109E0794236A336DF4E401DDF51', 'F0BF886301AD47BEBEBEA9BAD8F71636', 'CC2BBA7A73B942D3B66710128ED64082', 'BCCE65A2565F466D9088812901B72D5A', 'B16D487E8CD745AFB4AC48A70B772809', '8761684D30F444CE8CE5C6601136B819', '83E50806819244D88264DCBBBD91A2E4', '8096BC6CFD6D4A498510F223BB5D1A88', '6D09377074BA408D87545F0CA284AA6F', '6C836A724E2C46D6BEC5A17CBF060CD7', '685E20C464B647FCB1477E28DCB06253', '59A8B55738AB4B27A2CCD1445CB9BC8A', '4F67ABD8FDCF4F39B534D2BEF9CA9E09', '3B9493A345D247B48E1A7E939EBCEE57', '37C4AE7CB5874660947BC07399DF31EF', '1EB9EB0C061F44C68FC6EFA6583E5A5C', '191C177FBCD44B32BCCDC4D21B787689', '038AF2FA2F04427CAED332404A60E870', '01A9D139249C40C3A2D6D9966402D7FA', 'C6DB48F85AE044558DD9CE649FD39252', 'C20A9ACE321845E8AE85033FFB882786', 'C0E80560436344EDA1262F8A7855E811', 'B4A580707B5743AD9EB21DA58FBAD84C', 'AF26C99F1F5B4BDA9ADE33281C824310', 'A74D5584155C4F2ABB29197BEEAB6AEF', 'A0EA6676758A431D97D0EF94B42A67DF', '999BC0DA6F604831BCE836ACC899B166', '8194420624964FAC9C7553A635DC07AC', '7030BD9DBC1F4E9DB35DA9639DAE294A', '6BFB63A78EB74D33BCF96CA70B345A32', '523ABD7E7D6C418997B7FC874D2CF971', '4DA771C0639B4722ABB73776386246C7', '44283D5184804405B5322523206369DF', '2B3669E169F94F159126C4FD0783410C', '0DECD474EEE04C9288CCC2EF80CB9067', 'D77F3EC2F2FB4F0E8167AE5A720DA84B', 'CF4FE921173D4296A13612C39A226ABB', '974C3A378CBC492C8AC100C35B262D28', '92FB4AA6CF8C4016ABCF18B511F990E4', '902BE349A14C46C484FDE3AA4CA87FD1', '70E06199D44142D2AC0425EA5A0E4E25', '6D1A505D0A874F5B8EFD2CADD6542C78', '57CDF98D9C954D519E6902F8AE16AB0E', '40A7E834ED004BC0BC56E8EBC39E3F96', '3EB2D430287B4C578B13E33CD71028B4', '253A1863F8894B348BBC8235B3B7B4FD', 'D1BBB239C3BA4FCE80C09CA8F3AC90DC', 'CBCA234DA9B74D84B2165C1AD8183CBD', 'B203A5E9D8784D56807F6C07C968B979', 'AF9059E7C4F14AB0877DF403E828905D');
Date: 2026-07-18 09:29:51 Duration: 49s155ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 1m13s 10 6s778ms 10s633ms 7s366ms select * from c_order_post (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 18 09 3 24s737ms 8s245ms 11 3 20s950ms 6s983ms 12 4 27s977ms 6s994ms [ User: tad - Total duration: 1m13s - Times executed: 10 ]
[ Application: openbravo - Total duration: 1m13s - Times executed: 10 ]
-
SELECT * FROM C_ORDER_POST ('9C4FE6DA87D6419EB380830C182D9766');
Date: 2026-07-18 09:09:42 Duration: 10s633ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM C_ORDER_POST ('450D7BE6631A43C79AF18E9D6D735D10');
Date: 2026-07-18 12:16:44 Duration: 7s121ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM C_ORDER_POST ('B14400AFA01C42CFB0871BEACC37071A');
Date: 2026-07-18 09:53:09 Duration: 7s97ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 20s754ms 3 6s744ms 7s7ms 6s918ms select * from m_inout_post0 (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 18 10 2 14s10ms 7s5ms 12 1 6s744ms 6s744ms [ User: tad - Total duration: 20s754ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 20s754ms - Times executed: 3 ]
-
SELECT * FROM M_InOut_Post0 ('57F8ACBCB4404F008791C57097576D56');
Date: 2026-07-18 10:27:42 Duration: 7s7ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM M_InOut_Post0 ('EF8A7CCEDC1F446A86FB2C2A5D9B7620');
Date: 2026-07-18 10:15:51 Duration: 7s2ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM M_InOut_Post0 ('323B0B95EB2946E59E3CEAC1DE7C3AA2');
Date: 2026-07-18 12:27:59 Duration: 6s744ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 17s207ms 15 1s87ms 1s219ms 1s147ms select * from ( select o.c_order_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || ad_column_identifier (?, o.c_order_id, ?) || ? || sum(ol.linenetamt) || ? || o.totallines as description, ? as isactive, o.ad_org_id as ad_org_id, o.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, o.c_order_id, ?) as record_id from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) 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 #4
Day Hour Count Duration Avg duration Jul 18 07 1 1s219ms 1s219ms 08 1 1s116ms 1s116ms 09 1 1s175ms 1s175ms 10 1 1s125ms 1s125ms 11 1 1s142ms 1s142ms 12 1 1s180ms 1s180ms 13 1 1s151ms 1s151ms 14 1 1s102ms 1s102ms 15 1 1s174ms 1s174ms 16 1 1s87ms 1s87ms 17 1 1s162ms 1s162ms 18 1 1s168ms 1s168ms 19 1 1s152ms 1s152ms 20 1 1s130ms 1s130ms 21 1 1s117ms 1s117ms [ User: tad - Total duration: 17s207ms - Times executed: 15 ]
[ Application: openbravo - Total duration: 17s207ms - Times executed: 15 ]
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 07:00:01 Duration: 1s219ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 12:00:01 Duration: 1s180ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 09:00:01 Duration: 1s175ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
5 11s222ms 9 1s223ms 1s286ms 1s246ms select product1_.value as col_0_0_, product1_.m_product_id as col_1_0_, pricingpri2_.m_pricelist_version_id as col_2_0_, pricingpri2_.name as col_3_0_, currency4_.c_currency_id as col_4_0_, pricingpro0_.pricelimit as col_5_0_, product1_.name as col_6_0_, product1_.c_uom_id as col_7_0_, pricingpro0_.pricestd as col_8_0_, pricingpro0_.pricelist as col_9_0_, pricingpri3_.issopricelist as col_10_0_, product1_.characteristic_desc as col_11_0_, product5_.name as col_12_0_, product1_.upc as col_13_0_, pricingpri2_.m_pricelist_version_id as m_pricel1_551_0_, uom6_.c_uom_id as c_uom_id1_324_1_, pricingpri2_.ad_client_id as ad_clien2_551_0_, pricingpri2_.ad_org_id as ad_org_i3_551_0_, pricingpri2_.isactive as isactive4_551_0_, pricingpri2_.created as created5_551_0_, pricingpri2_.createdby as createdb6_551_0_, pricingpri2_.updated as updated7_551_0_, pricingpri2_.updatedby as updatedb8_551_0_, pricingpri2_.name as name9_551_0_, pricingpri2_.description as descrip10_551_0_, pricingpri2_.m_pricelist_id as m_price11_551_0_, pricingpri2_.m_discountschema_id as m_disco12_551_0_, pricingpri2_.validfrom as validfr13_551_0_, pricingpri2_.proccreate as proccre14_551_0_, pricingpri2_.m_pricelist_version_base_id as m_price15_551_0_, pricingpri2_.m_pricelist_version_generate as m_price16_551_0_, pricingpri2_.em_pruti_import_prices as em_prut17_551_0_, uom6_.ad_client_id as ad_clien2_324_1_, uom6_.ad_org_id as ad_org_i3_324_1_, uom6_.isactive as isactive4_324_1_, uom6_.created as created5_324_1_, uom6_.updated as updated6_324_1_, uom6_.createdby as createdb7_324_1_, uom6_.updatedby as updatedb8_324_1_, uom6_.x12de355 as x9_324_1_, uom6_.uomsymbol as uomsymb10_324_1_, uom6_.name as name11_324_1_, uom6_.description as descrip12_324_1_, uom6_.stdprecision as stdprec13_324_1_, uom6_.costingprecision as costing14_324_1_, uom6_.isdefault as isdefau15_324_1_, uom6_.breakdown as breakdo16_324_1_, uom6_.uom_type as uom_typ17_324_1_, uom6_.useinproduction as useinpr18_324_1_ from m_productprice pricingpro0_ inner join m_product product1_ on pricingpro0_.m_product_id = product1_.m_product_id inner join m_pricelist_version pricingpri2_ on pricingpro0_.m_pricelist_version_id = pricingpri2_.m_pricelist_version_id inner join m_pricelist pricingpri3_ on pricingpri2_.m_pricelist_id = pricingpri3_.m_pricelist_id left outer join c_currency currency4_ on pricingpri3_.c_currency_id = currency4_.c_currency_id left outer join m_product product5_ on product1_.generic_product_id = product5_.m_product_id inner join c_uom uom6_ on product1_.c_uom_id = uom6_.c_uom_id where product1_.isgeneric = ? and product1_.isactive = ? and pricingpri2_.isactive = ? and (product1_.ad_client_id in (...)) and (product1_.ad_org_id in (...)) and pricingpri3_.issopricelist = ? and currency4_.c_currency_id = ? and (upper(product1_.upc) like upper(?) or upper(product1_.value) like upper(?) or upper(product1_.name) like upper(?)) and (upper(pricingpri2_.name) like upper(?)) and pricingpri2_.m_pricelist_version_id = ? order by ? limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 18 09 1 1s286ms 1s286ms 10 8 9s935ms 1s241ms [ User: tad - Total duration: 11s222ms - Times executed: 9 ]
[ Application: openbravo - Total duration: 11s222ms - Times executed: 9 ]
-
select product1_.Value as col_0_0_, product1_.M_Product_ID as col_1_0_, pricingpri2_.M_PriceList_Version_ID as col_2_0_, pricingpri2_.Name as col_3_0_, currency4_.C_Currency_ID as col_4_0_, pricingpro0_.PriceLimit as col_5_0_, product1_.Name as col_6_0_, product1_.C_UOM_ID as col_7_0_, pricingpro0_.PriceStd as col_8_0_, pricingpro0_.PriceList as col_9_0_, pricingpri3_.IsSOPriceList as col_10_0_, product1_.Characteristic_Desc as col_11_0_, product5_.Name as col_12_0_, product1_.UPC as col_13_0_, pricingpri2_.M_PriceList_Version_ID as m_pricel1_551_0_, uom6_.C_UOM_ID as c_uom_id1_324_1_, pricingpri2_.AD_Client_ID as ad_clien2_551_0_, pricingpri2_.AD_Org_ID as ad_org_i3_551_0_, pricingpri2_.IsActive as isactive4_551_0_, pricingpri2_.Created as created5_551_0_, pricingpri2_.CreatedBy as createdb6_551_0_, pricingpri2_.Updated as updated7_551_0_, pricingpri2_.UpdatedBy as updatedb8_551_0_, pricingpri2_.Name as name9_551_0_, pricingpri2_.Description as descrip10_551_0_, pricingpri2_.M_PriceList_ID as m_price11_551_0_, pricingpri2_.M_DiscountSchema_ID as m_disco12_551_0_, pricingpri2_.ValidFrom as validfr13_551_0_, pricingpri2_.ProcCreate as proccre14_551_0_, pricingpri2_.M_Pricelist_Version_Base_ID as m_price15_551_0_, pricingpri2_.M_Pricelist_Version_Generate as m_price16_551_0_, pricingpri2_.EM_Pruti_Import_Prices as em_prut17_551_0_, uom6_.AD_Client_ID as ad_clien2_324_1_, uom6_.AD_Org_ID as ad_org_i3_324_1_, uom6_.IsActive as isactive4_324_1_, uom6_.Created as created5_324_1_, uom6_.Updated as updated6_324_1_, uom6_.CreatedBy as createdb7_324_1_, uom6_.UpdatedBy as updatedb8_324_1_, uom6_.X12DE355 as x9_324_1_, uom6_.UOMSymbol as uomsymb10_324_1_, uom6_.Name as name11_324_1_, uom6_.Description as descrip12_324_1_, uom6_.StdPrecision as stdprec13_324_1_, uom6_.CostingPrecision as costing14_324_1_, uom6_.IsDefault as isdefau15_324_1_, uom6_.Breakdown as breakdo16_324_1_, uom6_.UOM_Type as uom_typ17_324_1_, uom6_.Useinproduction as useinpr18_324_1_ from M_ProductPrice pricingpro0_ inner join M_Product product1_ on pricingpro0_.M_Product_ID = product1_.M_Product_ID inner join M_PriceList_Version pricingpri2_ on pricingpro0_.M_PriceList_Version_ID = pricingpri2_.M_PriceList_Version_ID inner join M_PriceList pricingpri3_ on pricingpri2_.M_PriceList_ID = pricingpri3_.M_PriceList_ID left outer join C_Currency currency4_ on pricingpri3_.C_Currency_ID = currency4_.C_Currency_ID left outer join M_Product product5_ on product1_.Generic_Product_ID = product5_.M_Product_ID inner join C_UOM uom6_ on product1_.C_UOM_ID = uom6_.C_UOM_ID where product1_.IsGeneric = 'N' and product1_.IsActive = 'Y' and pricingpri2_.IsActive = 'Y' and (product1_.AD_Client_ID in ('0', 'FF80818133B7413E0133B7164D6A0002')) and (product1_.AD_Org_ID in ('0', 'FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and pricingpri3_.IsSOPriceList = 'Y' and currency4_.C_Currency_ID = '102' and (upper(product1_.UPC) like upper('%ESCUR%') or upper(product1_.Value) like upper('%ESCUR%') or upper(product1_.Name) like upper('%ESCUR%')) and (upper(pricingpri2_.Name) like upper('%Venta%')) and pricingpri2_.M_PriceList_Version_ID = 'FF80818134057575013437B0786E0262' order by 7 limit '76';
Date: 2026-07-18 09:52:54 Duration: 1s286ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select product1_.Value as col_0_0_, product1_.M_Product_ID as col_1_0_, pricingpri2_.M_PriceList_Version_ID as col_2_0_, pricingpri2_.Name as col_3_0_, currency4_.C_Currency_ID as col_4_0_, pricingpro0_.PriceLimit as col_5_0_, product1_.Name as col_6_0_, product1_.C_UOM_ID as col_7_0_, pricingpro0_.PriceStd as col_8_0_, pricingpro0_.PriceList as col_9_0_, pricingpri3_.IsSOPriceList as col_10_0_, product1_.Characteristic_Desc as col_11_0_, product5_.Name as col_12_0_, product1_.UPC as col_13_0_, pricingpri2_.M_PriceList_Version_ID as m_pricel1_551_0_, uom6_.C_UOM_ID as c_uom_id1_324_1_, pricingpri2_.AD_Client_ID as ad_clien2_551_0_, pricingpri2_.AD_Org_ID as ad_org_i3_551_0_, pricingpri2_.IsActive as isactive4_551_0_, pricingpri2_.Created as created5_551_0_, pricingpri2_.CreatedBy as createdb6_551_0_, pricingpri2_.Updated as updated7_551_0_, pricingpri2_.UpdatedBy as updatedb8_551_0_, pricingpri2_.Name as name9_551_0_, pricingpri2_.Description as descrip10_551_0_, pricingpri2_.M_PriceList_ID as m_price11_551_0_, pricingpri2_.M_DiscountSchema_ID as m_disco12_551_0_, pricingpri2_.ValidFrom as validfr13_551_0_, pricingpri2_.ProcCreate as proccre14_551_0_, pricingpri2_.M_Pricelist_Version_Base_ID as m_price15_551_0_, pricingpri2_.M_Pricelist_Version_Generate as m_price16_551_0_, pricingpri2_.EM_Pruti_Import_Prices as em_prut17_551_0_, uom6_.AD_Client_ID as ad_clien2_324_1_, uom6_.AD_Org_ID as ad_org_i3_324_1_, uom6_.IsActive as isactive4_324_1_, uom6_.Created as created5_324_1_, uom6_.Updated as updated6_324_1_, uom6_.CreatedBy as createdb7_324_1_, uom6_.UpdatedBy as updatedb8_324_1_, uom6_.X12DE355 as x9_324_1_, uom6_.UOMSymbol as uomsymb10_324_1_, uom6_.Name as name11_324_1_, uom6_.Description as descrip12_324_1_, uom6_.StdPrecision as stdprec13_324_1_, uom6_.CostingPrecision as costing14_324_1_, uom6_.IsDefault as isdefau15_324_1_, uom6_.Breakdown as breakdo16_324_1_, uom6_.UOM_Type as uom_typ17_324_1_, uom6_.Useinproduction as useinpr18_324_1_ from M_ProductPrice pricingpro0_ inner join M_Product product1_ on pricingpro0_.M_Product_ID = product1_.M_Product_ID inner join M_PriceList_Version pricingpri2_ on pricingpro0_.M_PriceList_Version_ID = pricingpri2_.M_PriceList_Version_ID inner join M_PriceList pricingpri3_ on pricingpri2_.M_PriceList_ID = pricingpri3_.M_PriceList_ID left outer join C_Currency currency4_ on pricingpri3_.C_Currency_ID = currency4_.C_Currency_ID left outer join M_Product product5_ on product1_.Generic_Product_ID = product5_.M_Product_ID inner join C_UOM uom6_ on product1_.C_UOM_ID = uom6_.C_UOM_ID where product1_.IsGeneric = 'N' and product1_.IsActive = 'Y' and pricingpri2_.IsActive = 'Y' and (product1_.AD_Client_ID in ('0', 'FF80818133B7413E0133B7164D6A0002')) and (product1_.AD_Org_ID in ('0', 'FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and pricingpri3_.IsSOPriceList = 'Y' and currency4_.C_Currency_ID = '102' and (upper(product1_.UPC) like upper('%534327102%') or upper(product1_.Value) like upper('%534327102%') or upper(product1_.Name) like upper('%534327102%')) and (upper(pricingpri2_.Name) like upper('%Venta%')) and pricingpri2_.M_PriceList_Version_ID = 'FF80818134057575013437B0786E0262' order by 7 limit '76';
Date: 2026-07-18 10:00:54 Duration: 1s264ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select product1_.Value as col_0_0_, product1_.M_Product_ID as col_1_0_, pricingpri2_.M_PriceList_Version_ID as col_2_0_, pricingpri2_.Name as col_3_0_, currency4_.C_Currency_ID as col_4_0_, pricingpro0_.PriceLimit as col_5_0_, product1_.Name as col_6_0_, product1_.C_UOM_ID as col_7_0_, pricingpro0_.PriceStd as col_8_0_, pricingpro0_.PriceList as col_9_0_, pricingpri3_.IsSOPriceList as col_10_0_, product1_.Characteristic_Desc as col_11_0_, product5_.Name as col_12_0_, product1_.UPC as col_13_0_, pricingpri2_.M_PriceList_Version_ID as m_pricel1_551_0_, uom6_.C_UOM_ID as c_uom_id1_324_1_, pricingpri2_.AD_Client_ID as ad_clien2_551_0_, pricingpri2_.AD_Org_ID as ad_org_i3_551_0_, pricingpri2_.IsActive as isactive4_551_0_, pricingpri2_.Created as created5_551_0_, pricingpri2_.CreatedBy as createdb6_551_0_, pricingpri2_.Updated as updated7_551_0_, pricingpri2_.UpdatedBy as updatedb8_551_0_, pricingpri2_.Name as name9_551_0_, pricingpri2_.Description as descrip10_551_0_, pricingpri2_.M_PriceList_ID as m_price11_551_0_, pricingpri2_.M_DiscountSchema_ID as m_disco12_551_0_, pricingpri2_.ValidFrom as validfr13_551_0_, pricingpri2_.ProcCreate as proccre14_551_0_, pricingpri2_.M_Pricelist_Version_Base_ID as m_price15_551_0_, pricingpri2_.M_Pricelist_Version_Generate as m_price16_551_0_, pricingpri2_.EM_Pruti_Import_Prices as em_prut17_551_0_, uom6_.AD_Client_ID as ad_clien2_324_1_, uom6_.AD_Org_ID as ad_org_i3_324_1_, uom6_.IsActive as isactive4_324_1_, uom6_.Created as created5_324_1_, uom6_.Updated as updated6_324_1_, uom6_.CreatedBy as createdb7_324_1_, uom6_.UpdatedBy as updatedb8_324_1_, uom6_.X12DE355 as x9_324_1_, uom6_.UOMSymbol as uomsymb10_324_1_, uom6_.Name as name11_324_1_, uom6_.Description as descrip12_324_1_, uom6_.StdPrecision as stdprec13_324_1_, uom6_.CostingPrecision as costing14_324_1_, uom6_.IsDefault as isdefau15_324_1_, uom6_.Breakdown as breakdo16_324_1_, uom6_.UOM_Type as uom_typ17_324_1_, uom6_.Useinproduction as useinpr18_324_1_ from M_ProductPrice pricingpro0_ inner join M_Product product1_ on pricingpro0_.M_Product_ID = product1_.M_Product_ID inner join M_PriceList_Version pricingpri2_ on pricingpro0_.M_PriceList_Version_ID = pricingpri2_.M_PriceList_Version_ID inner join M_PriceList pricingpri3_ on pricingpri2_.M_PriceList_ID = pricingpri3_.M_PriceList_ID left outer join C_Currency currency4_ on pricingpri3_.C_Currency_ID = currency4_.C_Currency_ID left outer join M_Product product5_ on product1_.Generic_Product_ID = product5_.M_Product_ID inner join C_UOM uom6_ on product1_.C_UOM_ID = uom6_.C_UOM_ID where product1_.IsGeneric = 'N' and product1_.IsActive = 'Y' and pricingpri2_.IsActive = 'Y' and (product1_.AD_Client_ID in ('0', 'FF80818133B7413E0133B7164D6A0002')) and (product1_.AD_Org_ID in ('0', 'FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and pricingpri3_.IsSOPriceList = 'Y' and currency4_.C_Currency_ID = '102' and (upper(product1_.UPC) like upper('%AURIGA%%') or upper(product1_.Value) like upper('%AURIGA%%') or upper(product1_.Name) like upper('%AURIGA%%')) and (upper(pricingpri2_.Name) like upper('%Venta%')) and pricingpri2_.M_PriceList_Version_ID = 'FF80818134057575013437B0786E0262' order by 7 limit '76';
Date: 2026-07-18 10:15:30 Duration: 1s251ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
6 8s293ms 8 1s1ms 1s111ms 1s36ms select shipmentin0_.m_inout_id as m_inout_1_509_0_, shipmentin0_.ad_client_id as ad_clien2_509_0_, shipmentin0_.ad_org_id as ad_org_i3_509_0_, ( select count(*) from c_bpartner as bp where bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = ?) > ?) as formula34_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula35_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 18 09 2 2s30ms 1s15ms 10 5 5s253ms 1s50ms 11 1 1s9ms 1s9ms [ User: tad - Total duration: 8s293ms - Times executed: 8 ]
[ Application: openbravo - Total duration: 8s293ms - Times executed: 8 ]
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '31DAF150D8954486B73F1FB987F27C3E';
Date: 2026-07-18 10:21:03 Duration: 1s111ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '31DAF150D8954486B73F1FB987F27C3E';
Date: 2026-07-18 10:21:02 Duration: 1s58ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '4BE1DBCDCCC24B5AABA8C6593DE4C732';
Date: 2026-07-18 10:02:02 Duration: 1s54ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
7 3s105ms 3 1s20ms 1s58ms 1s35ms select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> ? or coalesce(sd.qtyorderonhand, ?) <> ? union all select m_product_id, null, ?, ? from m_product p where p.isgeneric = ?) as ps where ((ps.qtyonhand <> ? and exists ( select ? from m_locator ml where ml.m_locator_id = ps.m_locator_id and exists ( select ? from ad_org_warehouse ow where ml.m_warehouse_id = ow.m_warehouse_id and ow.ad_org_id in (...)))) or (exists ( select ? from m_product mp where ps.m_product_id = mp.m_product_id and mp.isstocked = ? and mp.producttype = ? and ad_client_id = ?))) and not exists ( select ? from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = ?) and exists ( select ? from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = ? and mp.producttype = ? and ad_client_id = ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 18 07 1 1s20ms 1s20ms 08 1 1s26ms 1s26ms 15 1 1s58ms 1s58ms [ User: tad - Total duration: 3s105ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 3s105ms - Times executed: 3 ]
-
select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> 0 OR COALESCE(sd.qtyorderonhand, 0) <> 0 union ALL select m_product_id, null, 0, 0 FROM m_product p WHERE p.isgeneric = 'N') as ps where ((ps.qtyonhand <> 0 AND EXISTS ( SELECT 1 FROM m_locator ml WHERE ml.m_locator_id = ps.m_locator_id AND EXISTS ( SELECT 1 FROM AD_Org_Warehouse ow WHERE ml.m_warehouse_id = ow.m_warehouse_id AND ow.ad_org_id IN ('FF80818134D2AA330134F1D03034277D', 'FF80818133B7413E0133B71974AD28C6')))) OR (EXISTS ( SELECT 1 FROM m_product mp WHERE ps.m_product_id = mp.m_product_id AND mp.isstocked = 'N' AND mp.producttype = 'I' AND ad_client_id = 'FF80818133B7413E0133B7164D6A0002'))) AND NOT EXISTS ( select 1 from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = '52ABADF5F9C04311B0A0E8FD21244670') AND exists ( select 1 from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = 'Y' and mp.producttype = 'I' and ad_client_id = 'FF80818133B7413E0133B7164D6A0002');
Date: 2026-07-18 15:00:01 Duration: 1s58ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> 0 OR COALESCE(sd.qtyorderonhand, 0) <> 0 union ALL select m_product_id, null, 0, 0 FROM m_product p WHERE p.isgeneric = 'N') as ps where ((ps.qtyonhand <> 0 AND EXISTS ( SELECT 1 FROM m_locator ml WHERE ml.m_locator_id = ps.m_locator_id AND EXISTS ( SELECT 1 FROM AD_Org_Warehouse ow WHERE ml.m_warehouse_id = ow.m_warehouse_id AND ow.ad_org_id IN ('FF80818134D2AA330134F1D03034277D', 'FF80818133B7413E0133B71974AD28C6')))) OR (EXISTS ( SELECT 1 FROM m_product mp WHERE ps.m_product_id = mp.m_product_id AND mp.isstocked = 'N' AND mp.producttype = 'I' AND ad_client_id = 'FF80818133B7413E0133B7164D6A0002'))) AND NOT EXISTS ( select 1 from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = '52ABADF5F9C04311B0A0E8FD21244670') AND exists ( select 1 from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = 'Y' and mp.producttype = 'I' and ad_client_id = 'FF80818133B7413E0133B7164D6A0002');
Date: 2026-07-18 08:00:01 Duration: 1s26ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> 0 OR COALESCE(sd.qtyorderonhand, 0) <> 0 union ALL select m_product_id, null, 0, 0 FROM m_product p WHERE p.isgeneric = 'N') as ps where ((ps.qtyonhand <> 0 AND EXISTS ( SELECT 1 FROM m_locator ml WHERE ml.m_locator_id = ps.m_locator_id AND EXISTS ( SELECT 1 FROM AD_Org_Warehouse ow WHERE ml.m_warehouse_id = ow.m_warehouse_id AND ow.ad_org_id IN ('FF80818134D2AA330134F1D03034277D', 'FF80818133B7413E0133B71974AD28C6')))) OR (EXISTS ( SELECT 1 FROM m_product mp WHERE ps.m_product_id = mp.m_product_id AND mp.isstocked = 'N' AND mp.producttype = 'I' AND ad_client_id = 'FF80818133B7413E0133B7164D6A0002'))) AND NOT EXISTS ( select 1 from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = '52ABADF5F9C04311B0A0E8FD21244670') AND exists ( select 1 from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = 'Y' and mp.producttype = 'I' and ad_client_id = 'FF80818133B7413E0133B7164D6A0002');
Date: 2026-07-18 07:00:01 Duration: 1s20ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
8 3s74ms 3 1s2ms 1s42ms 1s24ms select * from ( select distinct ad_column_identifier (?, fin_payment_schedule.c_invoice_id, ?) as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = ? group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, ?)) order by ?) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 18 09 1 1s2ms 1s2ms 15 1 1s42ms 1s42ms 17 1 1s29ms 1s29ms [ User: tad - Total duration: 3s74ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 3s74ms - Times executed: 3 ]
-
SELECT * FROM ( select distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'DF2689B486E04B849AB2F8CD38EE5B23' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 15:00:02 Duration: 1s42ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'DF2689B486E04B849AB2F8CD38EE5B23' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 17:00:02 Duration: 1s29ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'DF2689B486E04B849AB2F8CD38EE5B23' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 09:00:02 Duration: 1s2ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
9 2s902ms 1 2s902ms 2s902ms 2s902ms delete from m_product where m_product_id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 18 10 1 2s902ms 2s902ms [ User: tad - Total duration: 2s902ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 2s902ms - Times executed: 1 ]
-
delete from M_Product where M_Product_ID = '920E9847CD2B4D99BD22B8FE0FE94EBD';
Date: 2026-07-18 10:00:15 Duration: 2s902ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 15 17s207ms 1s87ms 1s219ms 1s147ms select * from ( select o.c_order_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || ad_column_identifier (?, o.c_order_id, ?) || ? || sum(ol.linenetamt) || ? || o.totallines as description, ? as isactive, o.ad_org_id as ad_org_id, o.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, o.c_order_id, ?) as record_id from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) 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 18 07 1 1s219ms 1s219ms 08 1 1s116ms 1s116ms 09 1 1s175ms 1s175ms 10 1 1s125ms 1s125ms 11 1 1s142ms 1s142ms 12 1 1s180ms 1s180ms 13 1 1s151ms 1s151ms 14 1 1s102ms 1s102ms 15 1 1s174ms 1s174ms 16 1 1s87ms 1s87ms 17 1 1s162ms 1s162ms 18 1 1s168ms 1s168ms 19 1 1s152ms 1s152ms 20 1 1s130ms 1s130ms 21 1 1s117ms 1s117ms [ User: tad - Total duration: 17s207ms - Times executed: 15 ]
[ Application: openbravo - Total duration: 17s207ms - Times executed: 15 ]
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 07:00:01 Duration: 1s219ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 12:00:01 Duration: 1s180ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 09:00:01 Duration: 1s175ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 10 1m13s 6s778ms 10s633ms 7s366ms select * from c_order_post (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 18 09 3 24s737ms 8s245ms 11 3 20s950ms 6s983ms 12 4 27s977ms 6s994ms [ User: tad - Total duration: 1m13s - Times executed: 10 ]
[ Application: openbravo - Total duration: 1m13s - Times executed: 10 ]
-
SELECT * FROM C_ORDER_POST ('9C4FE6DA87D6419EB380830C182D9766');
Date: 2026-07-18 09:09:42 Duration: 10s633ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM C_ORDER_POST ('450D7BE6631A43C79AF18E9D6D735D10');
Date: 2026-07-18 12:16:44 Duration: 7s121ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM C_ORDER_POST ('B14400AFA01C42CFB0871BEACC37071A');
Date: 2026-07-18 09:53:09 Duration: 7s97ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 9 11s222ms 1s223ms 1s286ms 1s246ms select product1_.value as col_0_0_, product1_.m_product_id as col_1_0_, pricingpri2_.m_pricelist_version_id as col_2_0_, pricingpri2_.name as col_3_0_, currency4_.c_currency_id as col_4_0_, pricingpro0_.pricelimit as col_5_0_, product1_.name as col_6_0_, product1_.c_uom_id as col_7_0_, pricingpro0_.pricestd as col_8_0_, pricingpro0_.pricelist as col_9_0_, pricingpri3_.issopricelist as col_10_0_, product1_.characteristic_desc as col_11_0_, product5_.name as col_12_0_, product1_.upc as col_13_0_, pricingpri2_.m_pricelist_version_id as m_pricel1_551_0_, uom6_.c_uom_id as c_uom_id1_324_1_, pricingpri2_.ad_client_id as ad_clien2_551_0_, pricingpri2_.ad_org_id as ad_org_i3_551_0_, pricingpri2_.isactive as isactive4_551_0_, pricingpri2_.created as created5_551_0_, pricingpri2_.createdby as createdb6_551_0_, pricingpri2_.updated as updated7_551_0_, pricingpri2_.updatedby as updatedb8_551_0_, pricingpri2_.name as name9_551_0_, pricingpri2_.description as descrip10_551_0_, pricingpri2_.m_pricelist_id as m_price11_551_0_, pricingpri2_.m_discountschema_id as m_disco12_551_0_, pricingpri2_.validfrom as validfr13_551_0_, pricingpri2_.proccreate as proccre14_551_0_, pricingpri2_.m_pricelist_version_base_id as m_price15_551_0_, pricingpri2_.m_pricelist_version_generate as m_price16_551_0_, pricingpri2_.em_pruti_import_prices as em_prut17_551_0_, uom6_.ad_client_id as ad_clien2_324_1_, uom6_.ad_org_id as ad_org_i3_324_1_, uom6_.isactive as isactive4_324_1_, uom6_.created as created5_324_1_, uom6_.updated as updated6_324_1_, uom6_.createdby as createdb7_324_1_, uom6_.updatedby as updatedb8_324_1_, uom6_.x12de355 as x9_324_1_, uom6_.uomsymbol as uomsymb10_324_1_, uom6_.name as name11_324_1_, uom6_.description as descrip12_324_1_, uom6_.stdprecision as stdprec13_324_1_, uom6_.costingprecision as costing14_324_1_, uom6_.isdefault as isdefau15_324_1_, uom6_.breakdown as breakdo16_324_1_, uom6_.uom_type as uom_typ17_324_1_, uom6_.useinproduction as useinpr18_324_1_ from m_productprice pricingpro0_ inner join m_product product1_ on pricingpro0_.m_product_id = product1_.m_product_id inner join m_pricelist_version pricingpri2_ on pricingpro0_.m_pricelist_version_id = pricingpri2_.m_pricelist_version_id inner join m_pricelist pricingpri3_ on pricingpri2_.m_pricelist_id = pricingpri3_.m_pricelist_id left outer join c_currency currency4_ on pricingpri3_.c_currency_id = currency4_.c_currency_id left outer join m_product product5_ on product1_.generic_product_id = product5_.m_product_id inner join c_uom uom6_ on product1_.c_uom_id = uom6_.c_uom_id where product1_.isgeneric = ? and product1_.isactive = ? and pricingpri2_.isactive = ? and (product1_.ad_client_id in (...)) and (product1_.ad_org_id in (...)) and pricingpri3_.issopricelist = ? and currency4_.c_currency_id = ? and (upper(product1_.upc) like upper(?) or upper(product1_.value) like upper(?) or upper(product1_.name) like upper(?)) and (upper(pricingpri2_.name) like upper(?)) and pricingpri2_.m_pricelist_version_id = ? order by ? limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 18 09 1 1s286ms 1s286ms 10 8 9s935ms 1s241ms [ User: tad - Total duration: 11s222ms - Times executed: 9 ]
[ Application: openbravo - Total duration: 11s222ms - Times executed: 9 ]
-
select product1_.Value as col_0_0_, product1_.M_Product_ID as col_1_0_, pricingpri2_.M_PriceList_Version_ID as col_2_0_, pricingpri2_.Name as col_3_0_, currency4_.C_Currency_ID as col_4_0_, pricingpro0_.PriceLimit as col_5_0_, product1_.Name as col_6_0_, product1_.C_UOM_ID as col_7_0_, pricingpro0_.PriceStd as col_8_0_, pricingpro0_.PriceList as col_9_0_, pricingpri3_.IsSOPriceList as col_10_0_, product1_.Characteristic_Desc as col_11_0_, product5_.Name as col_12_0_, product1_.UPC as col_13_0_, pricingpri2_.M_PriceList_Version_ID as m_pricel1_551_0_, uom6_.C_UOM_ID as c_uom_id1_324_1_, pricingpri2_.AD_Client_ID as ad_clien2_551_0_, pricingpri2_.AD_Org_ID as ad_org_i3_551_0_, pricingpri2_.IsActive as isactive4_551_0_, pricingpri2_.Created as created5_551_0_, pricingpri2_.CreatedBy as createdb6_551_0_, pricingpri2_.Updated as updated7_551_0_, pricingpri2_.UpdatedBy as updatedb8_551_0_, pricingpri2_.Name as name9_551_0_, pricingpri2_.Description as descrip10_551_0_, pricingpri2_.M_PriceList_ID as m_price11_551_0_, pricingpri2_.M_DiscountSchema_ID as m_disco12_551_0_, pricingpri2_.ValidFrom as validfr13_551_0_, pricingpri2_.ProcCreate as proccre14_551_0_, pricingpri2_.M_Pricelist_Version_Base_ID as m_price15_551_0_, pricingpri2_.M_Pricelist_Version_Generate as m_price16_551_0_, pricingpri2_.EM_Pruti_Import_Prices as em_prut17_551_0_, uom6_.AD_Client_ID as ad_clien2_324_1_, uom6_.AD_Org_ID as ad_org_i3_324_1_, uom6_.IsActive as isactive4_324_1_, uom6_.Created as created5_324_1_, uom6_.Updated as updated6_324_1_, uom6_.CreatedBy as createdb7_324_1_, uom6_.UpdatedBy as updatedb8_324_1_, uom6_.X12DE355 as x9_324_1_, uom6_.UOMSymbol as uomsymb10_324_1_, uom6_.Name as name11_324_1_, uom6_.Description as descrip12_324_1_, uom6_.StdPrecision as stdprec13_324_1_, uom6_.CostingPrecision as costing14_324_1_, uom6_.IsDefault as isdefau15_324_1_, uom6_.Breakdown as breakdo16_324_1_, uom6_.UOM_Type as uom_typ17_324_1_, uom6_.Useinproduction as useinpr18_324_1_ from M_ProductPrice pricingpro0_ inner join M_Product product1_ on pricingpro0_.M_Product_ID = product1_.M_Product_ID inner join M_PriceList_Version pricingpri2_ on pricingpro0_.M_PriceList_Version_ID = pricingpri2_.M_PriceList_Version_ID inner join M_PriceList pricingpri3_ on pricingpri2_.M_PriceList_ID = pricingpri3_.M_PriceList_ID left outer join C_Currency currency4_ on pricingpri3_.C_Currency_ID = currency4_.C_Currency_ID left outer join M_Product product5_ on product1_.Generic_Product_ID = product5_.M_Product_ID inner join C_UOM uom6_ on product1_.C_UOM_ID = uom6_.C_UOM_ID where product1_.IsGeneric = 'N' and product1_.IsActive = 'Y' and pricingpri2_.IsActive = 'Y' and (product1_.AD_Client_ID in ('0', 'FF80818133B7413E0133B7164D6A0002')) and (product1_.AD_Org_ID in ('0', 'FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and pricingpri3_.IsSOPriceList = 'Y' and currency4_.C_Currency_ID = '102' and (upper(product1_.UPC) like upper('%ESCUR%') or upper(product1_.Value) like upper('%ESCUR%') or upper(product1_.Name) like upper('%ESCUR%')) and (upper(pricingpri2_.Name) like upper('%Venta%')) and pricingpri2_.M_PriceList_Version_ID = 'FF80818134057575013437B0786E0262' order by 7 limit '76';
Date: 2026-07-18 09:52:54 Duration: 1s286ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select product1_.Value as col_0_0_, product1_.M_Product_ID as col_1_0_, pricingpri2_.M_PriceList_Version_ID as col_2_0_, pricingpri2_.Name as col_3_0_, currency4_.C_Currency_ID as col_4_0_, pricingpro0_.PriceLimit as col_5_0_, product1_.Name as col_6_0_, product1_.C_UOM_ID as col_7_0_, pricingpro0_.PriceStd as col_8_0_, pricingpro0_.PriceList as col_9_0_, pricingpri3_.IsSOPriceList as col_10_0_, product1_.Characteristic_Desc as col_11_0_, product5_.Name as col_12_0_, product1_.UPC as col_13_0_, pricingpri2_.M_PriceList_Version_ID as m_pricel1_551_0_, uom6_.C_UOM_ID as c_uom_id1_324_1_, pricingpri2_.AD_Client_ID as ad_clien2_551_0_, pricingpri2_.AD_Org_ID as ad_org_i3_551_0_, pricingpri2_.IsActive as isactive4_551_0_, pricingpri2_.Created as created5_551_0_, pricingpri2_.CreatedBy as createdb6_551_0_, pricingpri2_.Updated as updated7_551_0_, pricingpri2_.UpdatedBy as updatedb8_551_0_, pricingpri2_.Name as name9_551_0_, pricingpri2_.Description as descrip10_551_0_, pricingpri2_.M_PriceList_ID as m_price11_551_0_, pricingpri2_.M_DiscountSchema_ID as m_disco12_551_0_, pricingpri2_.ValidFrom as validfr13_551_0_, pricingpri2_.ProcCreate as proccre14_551_0_, pricingpri2_.M_Pricelist_Version_Base_ID as m_price15_551_0_, pricingpri2_.M_Pricelist_Version_Generate as m_price16_551_0_, pricingpri2_.EM_Pruti_Import_Prices as em_prut17_551_0_, uom6_.AD_Client_ID as ad_clien2_324_1_, uom6_.AD_Org_ID as ad_org_i3_324_1_, uom6_.IsActive as isactive4_324_1_, uom6_.Created as created5_324_1_, uom6_.Updated as updated6_324_1_, uom6_.CreatedBy as createdb7_324_1_, uom6_.UpdatedBy as updatedb8_324_1_, uom6_.X12DE355 as x9_324_1_, uom6_.UOMSymbol as uomsymb10_324_1_, uom6_.Name as name11_324_1_, uom6_.Description as descrip12_324_1_, uom6_.StdPrecision as stdprec13_324_1_, uom6_.CostingPrecision as costing14_324_1_, uom6_.IsDefault as isdefau15_324_1_, uom6_.Breakdown as breakdo16_324_1_, uom6_.UOM_Type as uom_typ17_324_1_, uom6_.Useinproduction as useinpr18_324_1_ from M_ProductPrice pricingpro0_ inner join M_Product product1_ on pricingpro0_.M_Product_ID = product1_.M_Product_ID inner join M_PriceList_Version pricingpri2_ on pricingpro0_.M_PriceList_Version_ID = pricingpri2_.M_PriceList_Version_ID inner join M_PriceList pricingpri3_ on pricingpri2_.M_PriceList_ID = pricingpri3_.M_PriceList_ID left outer join C_Currency currency4_ on pricingpri3_.C_Currency_ID = currency4_.C_Currency_ID left outer join M_Product product5_ on product1_.Generic_Product_ID = product5_.M_Product_ID inner join C_UOM uom6_ on product1_.C_UOM_ID = uom6_.C_UOM_ID where product1_.IsGeneric = 'N' and product1_.IsActive = 'Y' and pricingpri2_.IsActive = 'Y' and (product1_.AD_Client_ID in ('0', 'FF80818133B7413E0133B7164D6A0002')) and (product1_.AD_Org_ID in ('0', 'FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and pricingpri3_.IsSOPriceList = 'Y' and currency4_.C_Currency_ID = '102' and (upper(product1_.UPC) like upper('%534327102%') or upper(product1_.Value) like upper('%534327102%') or upper(product1_.Name) like upper('%534327102%')) and (upper(pricingpri2_.Name) like upper('%Venta%')) and pricingpri2_.M_PriceList_Version_ID = 'FF80818134057575013437B0786E0262' order by 7 limit '76';
Date: 2026-07-18 10:00:54 Duration: 1s264ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select product1_.Value as col_0_0_, product1_.M_Product_ID as col_1_0_, pricingpri2_.M_PriceList_Version_ID as col_2_0_, pricingpri2_.Name as col_3_0_, currency4_.C_Currency_ID as col_4_0_, pricingpro0_.PriceLimit as col_5_0_, product1_.Name as col_6_0_, product1_.C_UOM_ID as col_7_0_, pricingpro0_.PriceStd as col_8_0_, pricingpro0_.PriceList as col_9_0_, pricingpri3_.IsSOPriceList as col_10_0_, product1_.Characteristic_Desc as col_11_0_, product5_.Name as col_12_0_, product1_.UPC as col_13_0_, pricingpri2_.M_PriceList_Version_ID as m_pricel1_551_0_, uom6_.C_UOM_ID as c_uom_id1_324_1_, pricingpri2_.AD_Client_ID as ad_clien2_551_0_, pricingpri2_.AD_Org_ID as ad_org_i3_551_0_, pricingpri2_.IsActive as isactive4_551_0_, pricingpri2_.Created as created5_551_0_, pricingpri2_.CreatedBy as createdb6_551_0_, pricingpri2_.Updated as updated7_551_0_, pricingpri2_.UpdatedBy as updatedb8_551_0_, pricingpri2_.Name as name9_551_0_, pricingpri2_.Description as descrip10_551_0_, pricingpri2_.M_PriceList_ID as m_price11_551_0_, pricingpri2_.M_DiscountSchema_ID as m_disco12_551_0_, pricingpri2_.ValidFrom as validfr13_551_0_, pricingpri2_.ProcCreate as proccre14_551_0_, pricingpri2_.M_Pricelist_Version_Base_ID as m_price15_551_0_, pricingpri2_.M_Pricelist_Version_Generate as m_price16_551_0_, pricingpri2_.EM_Pruti_Import_Prices as em_prut17_551_0_, uom6_.AD_Client_ID as ad_clien2_324_1_, uom6_.AD_Org_ID as ad_org_i3_324_1_, uom6_.IsActive as isactive4_324_1_, uom6_.Created as created5_324_1_, uom6_.Updated as updated6_324_1_, uom6_.CreatedBy as createdb7_324_1_, uom6_.UpdatedBy as updatedb8_324_1_, uom6_.X12DE355 as x9_324_1_, uom6_.UOMSymbol as uomsymb10_324_1_, uom6_.Name as name11_324_1_, uom6_.Description as descrip12_324_1_, uom6_.StdPrecision as stdprec13_324_1_, uom6_.CostingPrecision as costing14_324_1_, uom6_.IsDefault as isdefau15_324_1_, uom6_.Breakdown as breakdo16_324_1_, uom6_.UOM_Type as uom_typ17_324_1_, uom6_.Useinproduction as useinpr18_324_1_ from M_ProductPrice pricingpro0_ inner join M_Product product1_ on pricingpro0_.M_Product_ID = product1_.M_Product_ID inner join M_PriceList_Version pricingpri2_ on pricingpro0_.M_PriceList_Version_ID = pricingpri2_.M_PriceList_Version_ID inner join M_PriceList pricingpri3_ on pricingpri2_.M_PriceList_ID = pricingpri3_.M_PriceList_ID left outer join C_Currency currency4_ on pricingpri3_.C_Currency_ID = currency4_.C_Currency_ID left outer join M_Product product5_ on product1_.Generic_Product_ID = product5_.M_Product_ID inner join C_UOM uom6_ on product1_.C_UOM_ID = uom6_.C_UOM_ID where product1_.IsGeneric = 'N' and product1_.IsActive = 'Y' and pricingpri2_.IsActive = 'Y' and (product1_.AD_Client_ID in ('0', 'FF80818133B7413E0133B7164D6A0002')) and (product1_.AD_Org_ID in ('0', 'FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and pricingpri3_.IsSOPriceList = 'Y' and currency4_.C_Currency_ID = '102' and (upper(product1_.UPC) like upper('%AURIGA%%') or upper(product1_.Value) like upper('%AURIGA%%') or upper(product1_.Name) like upper('%AURIGA%%')) and (upper(pricingpri2_.Name) like upper('%Venta%')) and pricingpri2_.M_PriceList_Version_ID = 'FF80818134057575013437B0786E0262' order by 7 limit '76';
Date: 2026-07-18 10:15:30 Duration: 1s251ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 8 8s293ms 1s1ms 1s111ms 1s36ms select shipmentin0_.m_inout_id as m_inout_1_509_0_, shipmentin0_.ad_client_id as ad_clien2_509_0_, shipmentin0_.ad_org_id as ad_org_i3_509_0_, ( select count(*) from c_bpartner as bp where bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = ?) > ?) as formula34_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula35_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 18 09 2 2s30ms 1s15ms 10 5 5s253ms 1s50ms 11 1 1s9ms 1s9ms [ User: tad - Total duration: 8s293ms - Times executed: 8 ]
[ Application: openbravo - Total duration: 8s293ms - Times executed: 8 ]
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '31DAF150D8954486B73F1FB987F27C3E';
Date: 2026-07-18 10:21:03 Duration: 1s111ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '31DAF150D8954486B73F1FB987F27C3E';
Date: 2026-07-18 10:21:02 Duration: 1s58ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '4BE1DBCDCCC24B5AABA8C6593DE4C732';
Date: 2026-07-18 10:02:02 Duration: 1s54ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
5 6 4m47s 44s150ms 50s166ms 47s972ms select shipmentin0_.m_inout_id as m_inout_1_509_0_, shipmentin0_.ad_client_id as ad_clien2_509_0_, shipmentin0_.ad_org_id as ad_org_i3_509_0_, ( select count(*) from c_bpartner as bp where bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = ?) > ?) as formula34_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula35_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id in (...);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 18 09 6 4m47s 47s972ms [ User: tad - Total duration: 4m47s - Times executed: 6 ]
[ Application: openbravo - Total duration: 4m47s - Times executed: 6 ]
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('9D60729BADAE4DFEBB393723AA46A9B8', '907395AA40CD4274AECE7E26691CF41E', '2F08189EB11D4B95B70C015C9DD6077C', 'ECA5FA40027D4774A963617F20A182F0', 'C9A66C1D73CD4EAA9A653BC3A834EC8B', 'BF731ED9A22444D69932D55067CCE293', 'BA0DD37FFF49405AB4AC143B9E65AD0A', 'A66132309A6A422BA51FC2B90F9081E2', 'A217C94B57894F7FA59B791FBB7E210D', '9E80B16534FA4450830D2F6F953357D1', '9BA6EC0729E34B88997539E830B001EF', '8577819CD29C40C1A59308306AF3C689', '7FFD4129BE8B43578A912CBF97F0562F', '623A6A2853BE4171BA1F26ED4A75F35A', '47FF59181BC04F739094A7823B20C42A', '2FBF094E5F0B49CDB5A6ABE3A5F4D886', '239264DBCFF1420D9D42E9DB86E5CF26', '20101CF85949484FB7BCFB2AE3C88768', '0C86D437B7AB46B2A17B6865000E794B', '037417A18FF6403684886EABBD4D5057', 'C88F465EDEA34CA39868816F4B96B901', '5ABD202EBA7A425AA48CE424BB714D79', 'FAE634ADA07B4BA0A943FCBC71269F1C', 'F9A194C1F4D0414697752C62AAD78801', 'EF6816B9922F4E4D817CBE44928D53B3', 'EBCD671A6A684CAF81ACA00144BD8448', 'DE2F6D07F55C4F50A200A4C9C6570E9F', 'C904A961AB9940FDADC873790241C5AB', 'BBC8993C9B36449E95538F8BC635937D', 'BB1C633AA69344E3B614CE64E6E5A73F', 'AEF1C3FCAF094D5F942C80E36690146D', '9C0E76DFFBDE45EBA29593B5EFAD52B5', '9B346B691297488E9962D0EC97A6CDB0', '880CE6172F6B48EA9F796E272E126120', '78B7473F77A84DD7A019891D46AB9004', '5C1C8F2C981D4C9BAE7419CD0A5C94C4', '5279BE3A457A4C78941D40E83F9A614C', '444493353F944B54B46CABE5105A8385', '4334DAD2E4834930A087E1D2C413310D', '340559052E2C4EE0BEDEB94D9100AFC1', '07920CA1DF2E4692823C50BA3116F922', '051E8F6455E94FF3B4CB64A83D6D876E', 'F7B1713212A04ED894689CA1528F6415', 'E5AF9004D37D4CA1A45FA90E52E6D6B6', 'E081848A3FAC4E1DB6638C9B2257ED53', 'B5776043334E4F0B95A45E7E9ADB6CB3', 'B4DEB76EB3DE440AA03884C3AD5BC3A7', 'A613569C616B4400A67CF0D2E98E25B8', '9DE3E845BFFC4A90A3DB21B8ECA3AF83', '9CBAA873B64242F48DEE11BD7BDAB6A1');
Date: 2026-07-18 09:30:29 Duration: 50s166ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('9D60729BADAE4DFEBB393723AA46A9B8', '907395AA40CD4274AECE7E26691CF41E', '2F08189EB11D4B95B70C015C9DD6077C', 'ECA5FA40027D4774A963617F20A182F0', 'C9A66C1D73CD4EAA9A653BC3A834EC8B', 'BF731ED9A22444D69932D55067CCE293', 'BA0DD37FFF49405AB4AC143B9E65AD0A', 'A66132309A6A422BA51FC2B90F9081E2', 'A217C94B57894F7FA59B791FBB7E210D', '9E80B16534FA4450830D2F6F953357D1', '9BA6EC0729E34B88997539E830B001EF', '8577819CD29C40C1A59308306AF3C689', '7FFD4129BE8B43578A912CBF97F0562F', '623A6A2853BE4171BA1F26ED4A75F35A', '47FF59181BC04F739094A7823B20C42A', '2FBF094E5F0B49CDB5A6ABE3A5F4D886', '239264DBCFF1420D9D42E9DB86E5CF26', '20101CF85949484FB7BCFB2AE3C88768', '0C86D437B7AB46B2A17B6865000E794B', '037417A18FF6403684886EABBD4D5057', 'C88F465EDEA34CA39868816F4B96B901', '5ABD202EBA7A425AA48CE424BB714D79', 'FAE634ADA07B4BA0A943FCBC71269F1C', 'F9A194C1F4D0414697752C62AAD78801', 'EF6816B9922F4E4D817CBE44928D53B3', 'EBCD671A6A684CAF81ACA00144BD8448', 'DE2F6D07F55C4F50A200A4C9C6570E9F', 'C904A961AB9940FDADC873790241C5AB', 'BBC8993C9B36449E95538F8BC635937D', 'BB1C633AA69344E3B614CE64E6E5A73F', 'AEF1C3FCAF094D5F942C80E36690146D', '9C0E76DFFBDE45EBA29593B5EFAD52B5', '9B346B691297488E9962D0EC97A6CDB0', '880CE6172F6B48EA9F796E272E126120', '78B7473F77A84DD7A019891D46AB9004', '5C1C8F2C981D4C9BAE7419CD0A5C94C4', '5279BE3A457A4C78941D40E83F9A614C', '444493353F944B54B46CABE5105A8385', '4334DAD2E4834930A087E1D2C413310D', '340559052E2C4EE0BEDEB94D9100AFC1', '07920CA1DF2E4692823C50BA3116F922', '051E8F6455E94FF3B4CB64A83D6D876E', 'F7B1713212A04ED894689CA1528F6415', 'E5AF9004D37D4CA1A45FA90E52E6D6B6', 'E081848A3FAC4E1DB6638C9B2257ED53', 'B5776043334E4F0B95A45E7E9ADB6CB3', 'B4DEB76EB3DE440AA03884C3AD5BC3A7', 'A613569C616B4400A67CF0D2E98E25B8', '9DE3E845BFFC4A90A3DB21B8ECA3AF83', '9CBAA873B64242F48DEE11BD7BDAB6A1');
Date: 2026-07-18 09:30:41 Duration: 49s496ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('DA6D5109E0794236A336DF4E401DDF51', 'F0BF886301AD47BEBEBEA9BAD8F71636', 'CC2BBA7A73B942D3B66710128ED64082', 'BCCE65A2565F466D9088812901B72D5A', 'B16D487E8CD745AFB4AC48A70B772809', '8761684D30F444CE8CE5C6601136B819', '83E50806819244D88264DCBBBD91A2E4', '8096BC6CFD6D4A498510F223BB5D1A88', '6D09377074BA408D87545F0CA284AA6F', '6C836A724E2C46D6BEC5A17CBF060CD7', '685E20C464B647FCB1477E28DCB06253', '59A8B55738AB4B27A2CCD1445CB9BC8A', '4F67ABD8FDCF4F39B534D2BEF9CA9E09', '3B9493A345D247B48E1A7E939EBCEE57', '37C4AE7CB5874660947BC07399DF31EF', '1EB9EB0C061F44C68FC6EFA6583E5A5C', '191C177FBCD44B32BCCDC4D21B787689', '038AF2FA2F04427CAED332404A60E870', '01A9D139249C40C3A2D6D9966402D7FA', 'C6DB48F85AE044558DD9CE649FD39252', 'C20A9ACE321845E8AE85033FFB882786', 'C0E80560436344EDA1262F8A7855E811', 'B4A580707B5743AD9EB21DA58FBAD84C', 'AF26C99F1F5B4BDA9ADE33281C824310', 'A74D5584155C4F2ABB29197BEEAB6AEF', 'A0EA6676758A431D97D0EF94B42A67DF', '999BC0DA6F604831BCE836ACC899B166', '8194420624964FAC9C7553A635DC07AC', '7030BD9DBC1F4E9DB35DA9639DAE294A', '6BFB63A78EB74D33BCF96CA70B345A32', '523ABD7E7D6C418997B7FC874D2CF971', '4DA771C0639B4722ABB73776386246C7', '44283D5184804405B5322523206369DF', '2B3669E169F94F159126C4FD0783410C', '0DECD474EEE04C9288CCC2EF80CB9067', 'D77F3EC2F2FB4F0E8167AE5A720DA84B', 'CF4FE921173D4296A13612C39A226ABB', '974C3A378CBC492C8AC100C35B262D28', '92FB4AA6CF8C4016ABCF18B511F990E4', '902BE349A14C46C484FDE3AA4CA87FD1', '70E06199D44142D2AC0425EA5A0E4E25', '6D1A505D0A874F5B8EFD2CADD6542C78', '57CDF98D9C954D519E6902F8AE16AB0E', '40A7E834ED004BC0BC56E8EBC39E3F96', '3EB2D430287B4C578B13E33CD71028B4', '253A1863F8894B348BBC8235B3B7B4FD', 'D1BBB239C3BA4FCE80C09CA8F3AC90DC', 'CBCA234DA9B74D84B2165C1AD8183CBD', 'B203A5E9D8784D56807F6C07C968B979', 'AF9059E7C4F14AB0877DF403E828905D');
Date: 2026-07-18 09:29:51 Duration: 49s155ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
6 3 20s754ms 6s744ms 7s7ms 6s918ms select * from m_inout_post0 (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 18 10 2 14s10ms 7s5ms 12 1 6s744ms 6s744ms [ User: tad - Total duration: 20s754ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 20s754ms - Times executed: 3 ]
-
SELECT * FROM M_InOut_Post0 ('57F8ACBCB4404F008791C57097576D56');
Date: 2026-07-18 10:27:42 Duration: 7s7ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM M_InOut_Post0 ('EF8A7CCEDC1F446A86FB2C2A5D9B7620');
Date: 2026-07-18 10:15:51 Duration: 7s2ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM M_InOut_Post0 ('323B0B95EB2946E59E3CEAC1DE7C3AA2');
Date: 2026-07-18 12:27:59 Duration: 6s744ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
7 3 3s105ms 1s20ms 1s58ms 1s35ms select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> ? or coalesce(sd.qtyorderonhand, ?) <> ? union all select m_product_id, null, ?, ? from m_product p where p.isgeneric = ?) as ps where ((ps.qtyonhand <> ? and exists ( select ? from m_locator ml where ml.m_locator_id = ps.m_locator_id and exists ( select ? from ad_org_warehouse ow where ml.m_warehouse_id = ow.m_warehouse_id and ow.ad_org_id in (...)))) or (exists ( select ? from m_product mp where ps.m_product_id = mp.m_product_id and mp.isstocked = ? and mp.producttype = ? and ad_client_id = ?))) and not exists ( select ? from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = ?) and exists ( select ? from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = ? and mp.producttype = ? and ad_client_id = ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 18 07 1 1s20ms 1s20ms 08 1 1s26ms 1s26ms 15 1 1s58ms 1s58ms [ User: tad - Total duration: 3s105ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 3s105ms - Times executed: 3 ]
-
select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> 0 OR COALESCE(sd.qtyorderonhand, 0) <> 0 union ALL select m_product_id, null, 0, 0 FROM m_product p WHERE p.isgeneric = 'N') as ps where ((ps.qtyonhand <> 0 AND EXISTS ( SELECT 1 FROM m_locator ml WHERE ml.m_locator_id = ps.m_locator_id AND EXISTS ( SELECT 1 FROM AD_Org_Warehouse ow WHERE ml.m_warehouse_id = ow.m_warehouse_id AND ow.ad_org_id IN ('FF80818134D2AA330134F1D03034277D', 'FF80818133B7413E0133B71974AD28C6')))) OR (EXISTS ( SELECT 1 FROM m_product mp WHERE ps.m_product_id = mp.m_product_id AND mp.isstocked = 'N' AND mp.producttype = 'I' AND ad_client_id = 'FF80818133B7413E0133B7164D6A0002'))) AND NOT EXISTS ( select 1 from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = '52ABADF5F9C04311B0A0E8FD21244670') AND exists ( select 1 from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = 'Y' and mp.producttype = 'I' and ad_client_id = 'FF80818133B7413E0133B7164D6A0002');
Date: 2026-07-18 15:00:01 Duration: 1s58ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> 0 OR COALESCE(sd.qtyorderonhand, 0) <> 0 union ALL select m_product_id, null, 0, 0 FROM m_product p WHERE p.isgeneric = 'N') as ps where ((ps.qtyonhand <> 0 AND EXISTS ( SELECT 1 FROM m_locator ml WHERE ml.m_locator_id = ps.m_locator_id AND EXISTS ( SELECT 1 FROM AD_Org_Warehouse ow WHERE ml.m_warehouse_id = ow.m_warehouse_id AND ow.ad_org_id IN ('FF80818134D2AA330134F1D03034277D', 'FF80818133B7413E0133B71974AD28C6')))) OR (EXISTS ( SELECT 1 FROM m_product mp WHERE ps.m_product_id = mp.m_product_id AND mp.isstocked = 'N' AND mp.producttype = 'I' AND ad_client_id = 'FF80818133B7413E0133B7164D6A0002'))) AND NOT EXISTS ( select 1 from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = '52ABADF5F9C04311B0A0E8FD21244670') AND exists ( select 1 from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = 'Y' and mp.producttype = 'I' and ad_client_id = 'FF80818133B7413E0133B7164D6A0002');
Date: 2026-07-18 08:00:01 Duration: 1s26ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> 0 OR COALESCE(sd.qtyorderonhand, 0) <> 0 union ALL select m_product_id, null, 0, 0 FROM m_product p WHERE p.isgeneric = 'N') as ps where ((ps.qtyonhand <> 0 AND EXISTS ( SELECT 1 FROM m_locator ml WHERE ml.m_locator_id = ps.m_locator_id AND EXISTS ( SELECT 1 FROM AD_Org_Warehouse ow WHERE ml.m_warehouse_id = ow.m_warehouse_id AND ow.ad_org_id IN ('FF80818134D2AA330134F1D03034277D', 'FF80818133B7413E0133B71974AD28C6')))) OR (EXISTS ( SELECT 1 FROM m_product mp WHERE ps.m_product_id = mp.m_product_id AND mp.isstocked = 'N' AND mp.producttype = 'I' AND ad_client_id = 'FF80818133B7413E0133B7164D6A0002'))) AND NOT EXISTS ( select 1 from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = '52ABADF5F9C04311B0A0E8FD21244670') AND exists ( select 1 from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = 'Y' and mp.producttype = 'I' and ad_client_id = 'FF80818133B7413E0133B7164D6A0002');
Date: 2026-07-18 07:00:01 Duration: 1s20ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
8 3 3s74ms 1s2ms 1s42ms 1s24ms select * from ( select distinct ad_column_identifier (?, fin_payment_schedule.c_invoice_id, ?) as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = ? group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, ?)) order by ?) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 18 09 1 1s2ms 1s2ms 15 1 1s42ms 1s42ms 17 1 1s29ms 1s29ms [ User: tad - Total duration: 3s74ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 3s74ms - Times executed: 3 ]
-
SELECT * FROM ( select distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'DF2689B486E04B849AB2F8CD38EE5B23' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 15:00:02 Duration: 1s42ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'DF2689B486E04B849AB2F8CD38EE5B23' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 17:00:02 Duration: 1s29ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'DF2689B486E04B849AB2F8CD38EE5B23' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 09:00:02 Duration: 1s2ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
9 1 2s902ms 2s902ms 2s902ms 2s902ms delete from m_product where m_product_id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 18 10 1 2s902ms 2s902ms [ User: tad - Total duration: 2s902ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 2s902ms - Times executed: 1 ]
-
delete from M_Product where M_Product_ID = '920E9847CD2B4D99BD22B8FE0FE94EBD';
Date: 2026-07-18 10:00:15 Duration: 2s902ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 44s150ms 50s166ms 47s972ms 6 4m47s select shipmentin0_.m_inout_id as m_inout_1_509_0_, shipmentin0_.ad_client_id as ad_clien2_509_0_, shipmentin0_.ad_org_id as ad_org_i3_509_0_, ( select count(*) from c_bpartner as bp where bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = ?) > ?) as formula34_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula35_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 18 09 6 4m47s 47s972ms [ User: tad - Total duration: 4m47s - Times executed: 6 ]
[ Application: openbravo - Total duration: 4m47s - Times executed: 6 ]
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('9D60729BADAE4DFEBB393723AA46A9B8', '907395AA40CD4274AECE7E26691CF41E', '2F08189EB11D4B95B70C015C9DD6077C', 'ECA5FA40027D4774A963617F20A182F0', 'C9A66C1D73CD4EAA9A653BC3A834EC8B', 'BF731ED9A22444D69932D55067CCE293', 'BA0DD37FFF49405AB4AC143B9E65AD0A', 'A66132309A6A422BA51FC2B90F9081E2', 'A217C94B57894F7FA59B791FBB7E210D', '9E80B16534FA4450830D2F6F953357D1', '9BA6EC0729E34B88997539E830B001EF', '8577819CD29C40C1A59308306AF3C689', '7FFD4129BE8B43578A912CBF97F0562F', '623A6A2853BE4171BA1F26ED4A75F35A', '47FF59181BC04F739094A7823B20C42A', '2FBF094E5F0B49CDB5A6ABE3A5F4D886', '239264DBCFF1420D9D42E9DB86E5CF26', '20101CF85949484FB7BCFB2AE3C88768', '0C86D437B7AB46B2A17B6865000E794B', '037417A18FF6403684886EABBD4D5057', 'C88F465EDEA34CA39868816F4B96B901', '5ABD202EBA7A425AA48CE424BB714D79', 'FAE634ADA07B4BA0A943FCBC71269F1C', 'F9A194C1F4D0414697752C62AAD78801', 'EF6816B9922F4E4D817CBE44928D53B3', 'EBCD671A6A684CAF81ACA00144BD8448', 'DE2F6D07F55C4F50A200A4C9C6570E9F', 'C904A961AB9940FDADC873790241C5AB', 'BBC8993C9B36449E95538F8BC635937D', 'BB1C633AA69344E3B614CE64E6E5A73F', 'AEF1C3FCAF094D5F942C80E36690146D', '9C0E76DFFBDE45EBA29593B5EFAD52B5', '9B346B691297488E9962D0EC97A6CDB0', '880CE6172F6B48EA9F796E272E126120', '78B7473F77A84DD7A019891D46AB9004', '5C1C8F2C981D4C9BAE7419CD0A5C94C4', '5279BE3A457A4C78941D40E83F9A614C', '444493353F944B54B46CABE5105A8385', '4334DAD2E4834930A087E1D2C413310D', '340559052E2C4EE0BEDEB94D9100AFC1', '07920CA1DF2E4692823C50BA3116F922', '051E8F6455E94FF3B4CB64A83D6D876E', 'F7B1713212A04ED894689CA1528F6415', 'E5AF9004D37D4CA1A45FA90E52E6D6B6', 'E081848A3FAC4E1DB6638C9B2257ED53', 'B5776043334E4F0B95A45E7E9ADB6CB3', 'B4DEB76EB3DE440AA03884C3AD5BC3A7', 'A613569C616B4400A67CF0D2E98E25B8', '9DE3E845BFFC4A90A3DB21B8ECA3AF83', '9CBAA873B64242F48DEE11BD7BDAB6A1');
Date: 2026-07-18 09:30:29 Duration: 50s166ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('9D60729BADAE4DFEBB393723AA46A9B8', '907395AA40CD4274AECE7E26691CF41E', '2F08189EB11D4B95B70C015C9DD6077C', 'ECA5FA40027D4774A963617F20A182F0', 'C9A66C1D73CD4EAA9A653BC3A834EC8B', 'BF731ED9A22444D69932D55067CCE293', 'BA0DD37FFF49405AB4AC143B9E65AD0A', 'A66132309A6A422BA51FC2B90F9081E2', 'A217C94B57894F7FA59B791FBB7E210D', '9E80B16534FA4450830D2F6F953357D1', '9BA6EC0729E34B88997539E830B001EF', '8577819CD29C40C1A59308306AF3C689', '7FFD4129BE8B43578A912CBF97F0562F', '623A6A2853BE4171BA1F26ED4A75F35A', '47FF59181BC04F739094A7823B20C42A', '2FBF094E5F0B49CDB5A6ABE3A5F4D886', '239264DBCFF1420D9D42E9DB86E5CF26', '20101CF85949484FB7BCFB2AE3C88768', '0C86D437B7AB46B2A17B6865000E794B', '037417A18FF6403684886EABBD4D5057', 'C88F465EDEA34CA39868816F4B96B901', '5ABD202EBA7A425AA48CE424BB714D79', 'FAE634ADA07B4BA0A943FCBC71269F1C', 'F9A194C1F4D0414697752C62AAD78801', 'EF6816B9922F4E4D817CBE44928D53B3', 'EBCD671A6A684CAF81ACA00144BD8448', 'DE2F6D07F55C4F50A200A4C9C6570E9F', 'C904A961AB9940FDADC873790241C5AB', 'BBC8993C9B36449E95538F8BC635937D', 'BB1C633AA69344E3B614CE64E6E5A73F', 'AEF1C3FCAF094D5F942C80E36690146D', '9C0E76DFFBDE45EBA29593B5EFAD52B5', '9B346B691297488E9962D0EC97A6CDB0', '880CE6172F6B48EA9F796E272E126120', '78B7473F77A84DD7A019891D46AB9004', '5C1C8F2C981D4C9BAE7419CD0A5C94C4', '5279BE3A457A4C78941D40E83F9A614C', '444493353F944B54B46CABE5105A8385', '4334DAD2E4834930A087E1D2C413310D', '340559052E2C4EE0BEDEB94D9100AFC1', '07920CA1DF2E4692823C50BA3116F922', '051E8F6455E94FF3B4CB64A83D6D876E', 'F7B1713212A04ED894689CA1528F6415', 'E5AF9004D37D4CA1A45FA90E52E6D6B6', 'E081848A3FAC4E1DB6638C9B2257ED53', 'B5776043334E4F0B95A45E7E9ADB6CB3', 'B4DEB76EB3DE440AA03884C3AD5BC3A7', 'A613569C616B4400A67CF0D2E98E25B8', '9DE3E845BFFC4A90A3DB21B8ECA3AF83', '9CBAA873B64242F48DEE11BD7BDAB6A1');
Date: 2026-07-18 09:30:41 Duration: 49s496ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('DA6D5109E0794236A336DF4E401DDF51', 'F0BF886301AD47BEBEBEA9BAD8F71636', 'CC2BBA7A73B942D3B66710128ED64082', 'BCCE65A2565F466D9088812901B72D5A', 'B16D487E8CD745AFB4AC48A70B772809', '8761684D30F444CE8CE5C6601136B819', '83E50806819244D88264DCBBBD91A2E4', '8096BC6CFD6D4A498510F223BB5D1A88', '6D09377074BA408D87545F0CA284AA6F', '6C836A724E2C46D6BEC5A17CBF060CD7', '685E20C464B647FCB1477E28DCB06253', '59A8B55738AB4B27A2CCD1445CB9BC8A', '4F67ABD8FDCF4F39B534D2BEF9CA9E09', '3B9493A345D247B48E1A7E939EBCEE57', '37C4AE7CB5874660947BC07399DF31EF', '1EB9EB0C061F44C68FC6EFA6583E5A5C', '191C177FBCD44B32BCCDC4D21B787689', '038AF2FA2F04427CAED332404A60E870', '01A9D139249C40C3A2D6D9966402D7FA', 'C6DB48F85AE044558DD9CE649FD39252', 'C20A9ACE321845E8AE85033FFB882786', 'C0E80560436344EDA1262F8A7855E811', 'B4A580707B5743AD9EB21DA58FBAD84C', 'AF26C99F1F5B4BDA9ADE33281C824310', 'A74D5584155C4F2ABB29197BEEAB6AEF', 'A0EA6676758A431D97D0EF94B42A67DF', '999BC0DA6F604831BCE836ACC899B166', '8194420624964FAC9C7553A635DC07AC', '7030BD9DBC1F4E9DB35DA9639DAE294A', '6BFB63A78EB74D33BCF96CA70B345A32', '523ABD7E7D6C418997B7FC874D2CF971', '4DA771C0639B4722ABB73776386246C7', '44283D5184804405B5322523206369DF', '2B3669E169F94F159126C4FD0783410C', '0DECD474EEE04C9288CCC2EF80CB9067', 'D77F3EC2F2FB4F0E8167AE5A720DA84B', 'CF4FE921173D4296A13612C39A226ABB', '974C3A378CBC492C8AC100C35B262D28', '92FB4AA6CF8C4016ABCF18B511F990E4', '902BE349A14C46C484FDE3AA4CA87FD1', '70E06199D44142D2AC0425EA5A0E4E25', '6D1A505D0A874F5B8EFD2CADD6542C78', '57CDF98D9C954D519E6902F8AE16AB0E', '40A7E834ED004BC0BC56E8EBC39E3F96', '3EB2D430287B4C578B13E33CD71028B4', '253A1863F8894B348BBC8235B3B7B4FD', 'D1BBB239C3BA4FCE80C09CA8F3AC90DC', 'CBCA234DA9B74D84B2165C1AD8183CBD', 'B203A5E9D8784D56807F6C07C968B979', 'AF9059E7C4F14AB0877DF403E828905D');
Date: 2026-07-18 09:29:51 Duration: 49s155ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 6s778ms 10s633ms 7s366ms 10 1m13s select * from c_order_post (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 18 09 3 24s737ms 8s245ms 11 3 20s950ms 6s983ms 12 4 27s977ms 6s994ms [ User: tad - Total duration: 1m13s - Times executed: 10 ]
[ Application: openbravo - Total duration: 1m13s - Times executed: 10 ]
-
SELECT * FROM C_ORDER_POST ('9C4FE6DA87D6419EB380830C182D9766');
Date: 2026-07-18 09:09:42 Duration: 10s633ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM C_ORDER_POST ('450D7BE6631A43C79AF18E9D6D735D10');
Date: 2026-07-18 12:16:44 Duration: 7s121ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM C_ORDER_POST ('B14400AFA01C42CFB0871BEACC37071A');
Date: 2026-07-18 09:53:09 Duration: 7s97ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 6s744ms 7s7ms 6s918ms 3 20s754ms select * from m_inout_post0 (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 18 10 2 14s10ms 7s5ms 12 1 6s744ms 6s744ms [ User: tad - Total duration: 20s754ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 20s754ms - Times executed: 3 ]
-
SELECT * FROM M_InOut_Post0 ('57F8ACBCB4404F008791C57097576D56');
Date: 2026-07-18 10:27:42 Duration: 7s7ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM M_InOut_Post0 ('EF8A7CCEDC1F446A86FB2C2A5D9B7620');
Date: 2026-07-18 10:15:51 Duration: 7s2ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM M_InOut_Post0 ('323B0B95EB2946E59E3CEAC1DE7C3AA2');
Date: 2026-07-18 12:27:59 Duration: 6s744ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 2s902ms 2s902ms 2s902ms 1 2s902ms delete from m_product where m_product_id = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 18 10 1 2s902ms 2s902ms [ User: tad - Total duration: 2s902ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 2s902ms - Times executed: 1 ]
-
delete from M_Product where M_Product_ID = '920E9847CD2B4D99BD22B8FE0FE94EBD';
Date: 2026-07-18 10:00:15 Duration: 2s902ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
5 1s223ms 1s286ms 1s246ms 9 11s222ms select product1_.value as col_0_0_, product1_.m_product_id as col_1_0_, pricingpri2_.m_pricelist_version_id as col_2_0_, pricingpri2_.name as col_3_0_, currency4_.c_currency_id as col_4_0_, pricingpro0_.pricelimit as col_5_0_, product1_.name as col_6_0_, product1_.c_uom_id as col_7_0_, pricingpro0_.pricestd as col_8_0_, pricingpro0_.pricelist as col_9_0_, pricingpri3_.issopricelist as col_10_0_, product1_.characteristic_desc as col_11_0_, product5_.name as col_12_0_, product1_.upc as col_13_0_, pricingpri2_.m_pricelist_version_id as m_pricel1_551_0_, uom6_.c_uom_id as c_uom_id1_324_1_, pricingpri2_.ad_client_id as ad_clien2_551_0_, pricingpri2_.ad_org_id as ad_org_i3_551_0_, pricingpri2_.isactive as isactive4_551_0_, pricingpri2_.created as created5_551_0_, pricingpri2_.createdby as createdb6_551_0_, pricingpri2_.updated as updated7_551_0_, pricingpri2_.updatedby as updatedb8_551_0_, pricingpri2_.name as name9_551_0_, pricingpri2_.description as descrip10_551_0_, pricingpri2_.m_pricelist_id as m_price11_551_0_, pricingpri2_.m_discountschema_id as m_disco12_551_0_, pricingpri2_.validfrom as validfr13_551_0_, pricingpri2_.proccreate as proccre14_551_0_, pricingpri2_.m_pricelist_version_base_id as m_price15_551_0_, pricingpri2_.m_pricelist_version_generate as m_price16_551_0_, pricingpri2_.em_pruti_import_prices as em_prut17_551_0_, uom6_.ad_client_id as ad_clien2_324_1_, uom6_.ad_org_id as ad_org_i3_324_1_, uom6_.isactive as isactive4_324_1_, uom6_.created as created5_324_1_, uom6_.updated as updated6_324_1_, uom6_.createdby as createdb7_324_1_, uom6_.updatedby as updatedb8_324_1_, uom6_.x12de355 as x9_324_1_, uom6_.uomsymbol as uomsymb10_324_1_, uom6_.name as name11_324_1_, uom6_.description as descrip12_324_1_, uom6_.stdprecision as stdprec13_324_1_, uom6_.costingprecision as costing14_324_1_, uom6_.isdefault as isdefau15_324_1_, uom6_.breakdown as breakdo16_324_1_, uom6_.uom_type as uom_typ17_324_1_, uom6_.useinproduction as useinpr18_324_1_ from m_productprice pricingpro0_ inner join m_product product1_ on pricingpro0_.m_product_id = product1_.m_product_id inner join m_pricelist_version pricingpri2_ on pricingpro0_.m_pricelist_version_id = pricingpri2_.m_pricelist_version_id inner join m_pricelist pricingpri3_ on pricingpri2_.m_pricelist_id = pricingpri3_.m_pricelist_id left outer join c_currency currency4_ on pricingpri3_.c_currency_id = currency4_.c_currency_id left outer join m_product product5_ on product1_.generic_product_id = product5_.m_product_id inner join c_uom uom6_ on product1_.c_uom_id = uom6_.c_uom_id where product1_.isgeneric = ? and product1_.isactive = ? and pricingpri2_.isactive = ? and (product1_.ad_client_id in (...)) and (product1_.ad_org_id in (...)) and pricingpri3_.issopricelist = ? and currency4_.c_currency_id = ? and (upper(product1_.upc) like upper(?) or upper(product1_.value) like upper(?) or upper(product1_.name) like upper(?)) and (upper(pricingpri2_.name) like upper(?)) and pricingpri2_.m_pricelist_version_id = ? order by ? limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 18 09 1 1s286ms 1s286ms 10 8 9s935ms 1s241ms [ User: tad - Total duration: 11s222ms - Times executed: 9 ]
[ Application: openbravo - Total duration: 11s222ms - Times executed: 9 ]
-
select product1_.Value as col_0_0_, product1_.M_Product_ID as col_1_0_, pricingpri2_.M_PriceList_Version_ID as col_2_0_, pricingpri2_.Name as col_3_0_, currency4_.C_Currency_ID as col_4_0_, pricingpro0_.PriceLimit as col_5_0_, product1_.Name as col_6_0_, product1_.C_UOM_ID as col_7_0_, pricingpro0_.PriceStd as col_8_0_, pricingpro0_.PriceList as col_9_0_, pricingpri3_.IsSOPriceList as col_10_0_, product1_.Characteristic_Desc as col_11_0_, product5_.Name as col_12_0_, product1_.UPC as col_13_0_, pricingpri2_.M_PriceList_Version_ID as m_pricel1_551_0_, uom6_.C_UOM_ID as c_uom_id1_324_1_, pricingpri2_.AD_Client_ID as ad_clien2_551_0_, pricingpri2_.AD_Org_ID as ad_org_i3_551_0_, pricingpri2_.IsActive as isactive4_551_0_, pricingpri2_.Created as created5_551_0_, pricingpri2_.CreatedBy as createdb6_551_0_, pricingpri2_.Updated as updated7_551_0_, pricingpri2_.UpdatedBy as updatedb8_551_0_, pricingpri2_.Name as name9_551_0_, pricingpri2_.Description as descrip10_551_0_, pricingpri2_.M_PriceList_ID as m_price11_551_0_, pricingpri2_.M_DiscountSchema_ID as m_disco12_551_0_, pricingpri2_.ValidFrom as validfr13_551_0_, pricingpri2_.ProcCreate as proccre14_551_0_, pricingpri2_.M_Pricelist_Version_Base_ID as m_price15_551_0_, pricingpri2_.M_Pricelist_Version_Generate as m_price16_551_0_, pricingpri2_.EM_Pruti_Import_Prices as em_prut17_551_0_, uom6_.AD_Client_ID as ad_clien2_324_1_, uom6_.AD_Org_ID as ad_org_i3_324_1_, uom6_.IsActive as isactive4_324_1_, uom6_.Created as created5_324_1_, uom6_.Updated as updated6_324_1_, uom6_.CreatedBy as createdb7_324_1_, uom6_.UpdatedBy as updatedb8_324_1_, uom6_.X12DE355 as x9_324_1_, uom6_.UOMSymbol as uomsymb10_324_1_, uom6_.Name as name11_324_1_, uom6_.Description as descrip12_324_1_, uom6_.StdPrecision as stdprec13_324_1_, uom6_.CostingPrecision as costing14_324_1_, uom6_.IsDefault as isdefau15_324_1_, uom6_.Breakdown as breakdo16_324_1_, uom6_.UOM_Type as uom_typ17_324_1_, uom6_.Useinproduction as useinpr18_324_1_ from M_ProductPrice pricingpro0_ inner join M_Product product1_ on pricingpro0_.M_Product_ID = product1_.M_Product_ID inner join M_PriceList_Version pricingpri2_ on pricingpro0_.M_PriceList_Version_ID = pricingpri2_.M_PriceList_Version_ID inner join M_PriceList pricingpri3_ on pricingpri2_.M_PriceList_ID = pricingpri3_.M_PriceList_ID left outer join C_Currency currency4_ on pricingpri3_.C_Currency_ID = currency4_.C_Currency_ID left outer join M_Product product5_ on product1_.Generic_Product_ID = product5_.M_Product_ID inner join C_UOM uom6_ on product1_.C_UOM_ID = uom6_.C_UOM_ID where product1_.IsGeneric = 'N' and product1_.IsActive = 'Y' and pricingpri2_.IsActive = 'Y' and (product1_.AD_Client_ID in ('0', 'FF80818133B7413E0133B7164D6A0002')) and (product1_.AD_Org_ID in ('0', 'FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and pricingpri3_.IsSOPriceList = 'Y' and currency4_.C_Currency_ID = '102' and (upper(product1_.UPC) like upper('%ESCUR%') or upper(product1_.Value) like upper('%ESCUR%') or upper(product1_.Name) like upper('%ESCUR%')) and (upper(pricingpri2_.Name) like upper('%Venta%')) and pricingpri2_.M_PriceList_Version_ID = 'FF80818134057575013437B0786E0262' order by 7 limit '76';
Date: 2026-07-18 09:52:54 Duration: 1s286ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select product1_.Value as col_0_0_, product1_.M_Product_ID as col_1_0_, pricingpri2_.M_PriceList_Version_ID as col_2_0_, pricingpri2_.Name as col_3_0_, currency4_.C_Currency_ID as col_4_0_, pricingpro0_.PriceLimit as col_5_0_, product1_.Name as col_6_0_, product1_.C_UOM_ID as col_7_0_, pricingpro0_.PriceStd as col_8_0_, pricingpro0_.PriceList as col_9_0_, pricingpri3_.IsSOPriceList as col_10_0_, product1_.Characteristic_Desc as col_11_0_, product5_.Name as col_12_0_, product1_.UPC as col_13_0_, pricingpri2_.M_PriceList_Version_ID as m_pricel1_551_0_, uom6_.C_UOM_ID as c_uom_id1_324_1_, pricingpri2_.AD_Client_ID as ad_clien2_551_0_, pricingpri2_.AD_Org_ID as ad_org_i3_551_0_, pricingpri2_.IsActive as isactive4_551_0_, pricingpri2_.Created as created5_551_0_, pricingpri2_.CreatedBy as createdb6_551_0_, pricingpri2_.Updated as updated7_551_0_, pricingpri2_.UpdatedBy as updatedb8_551_0_, pricingpri2_.Name as name9_551_0_, pricingpri2_.Description as descrip10_551_0_, pricingpri2_.M_PriceList_ID as m_price11_551_0_, pricingpri2_.M_DiscountSchema_ID as m_disco12_551_0_, pricingpri2_.ValidFrom as validfr13_551_0_, pricingpri2_.ProcCreate as proccre14_551_0_, pricingpri2_.M_Pricelist_Version_Base_ID as m_price15_551_0_, pricingpri2_.M_Pricelist_Version_Generate as m_price16_551_0_, pricingpri2_.EM_Pruti_Import_Prices as em_prut17_551_0_, uom6_.AD_Client_ID as ad_clien2_324_1_, uom6_.AD_Org_ID as ad_org_i3_324_1_, uom6_.IsActive as isactive4_324_1_, uom6_.Created as created5_324_1_, uom6_.Updated as updated6_324_1_, uom6_.CreatedBy as createdb7_324_1_, uom6_.UpdatedBy as updatedb8_324_1_, uom6_.X12DE355 as x9_324_1_, uom6_.UOMSymbol as uomsymb10_324_1_, uom6_.Name as name11_324_1_, uom6_.Description as descrip12_324_1_, uom6_.StdPrecision as stdprec13_324_1_, uom6_.CostingPrecision as costing14_324_1_, uom6_.IsDefault as isdefau15_324_1_, uom6_.Breakdown as breakdo16_324_1_, uom6_.UOM_Type as uom_typ17_324_1_, uom6_.Useinproduction as useinpr18_324_1_ from M_ProductPrice pricingpro0_ inner join M_Product product1_ on pricingpro0_.M_Product_ID = product1_.M_Product_ID inner join M_PriceList_Version pricingpri2_ on pricingpro0_.M_PriceList_Version_ID = pricingpri2_.M_PriceList_Version_ID inner join M_PriceList pricingpri3_ on pricingpri2_.M_PriceList_ID = pricingpri3_.M_PriceList_ID left outer join C_Currency currency4_ on pricingpri3_.C_Currency_ID = currency4_.C_Currency_ID left outer join M_Product product5_ on product1_.Generic_Product_ID = product5_.M_Product_ID inner join C_UOM uom6_ on product1_.C_UOM_ID = uom6_.C_UOM_ID where product1_.IsGeneric = 'N' and product1_.IsActive = 'Y' and pricingpri2_.IsActive = 'Y' and (product1_.AD_Client_ID in ('0', 'FF80818133B7413E0133B7164D6A0002')) and (product1_.AD_Org_ID in ('0', 'FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and pricingpri3_.IsSOPriceList = 'Y' and currency4_.C_Currency_ID = '102' and (upper(product1_.UPC) like upper('%534327102%') or upper(product1_.Value) like upper('%534327102%') or upper(product1_.Name) like upper('%534327102%')) and (upper(pricingpri2_.Name) like upper('%Venta%')) and pricingpri2_.M_PriceList_Version_ID = 'FF80818134057575013437B0786E0262' order by 7 limit '76';
Date: 2026-07-18 10:00:54 Duration: 1s264ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select product1_.Value as col_0_0_, product1_.M_Product_ID as col_1_0_, pricingpri2_.M_PriceList_Version_ID as col_2_0_, pricingpri2_.Name as col_3_0_, currency4_.C_Currency_ID as col_4_0_, pricingpro0_.PriceLimit as col_5_0_, product1_.Name as col_6_0_, product1_.C_UOM_ID as col_7_0_, pricingpro0_.PriceStd as col_8_0_, pricingpro0_.PriceList as col_9_0_, pricingpri3_.IsSOPriceList as col_10_0_, product1_.Characteristic_Desc as col_11_0_, product5_.Name as col_12_0_, product1_.UPC as col_13_0_, pricingpri2_.M_PriceList_Version_ID as m_pricel1_551_0_, uom6_.C_UOM_ID as c_uom_id1_324_1_, pricingpri2_.AD_Client_ID as ad_clien2_551_0_, pricingpri2_.AD_Org_ID as ad_org_i3_551_0_, pricingpri2_.IsActive as isactive4_551_0_, pricingpri2_.Created as created5_551_0_, pricingpri2_.CreatedBy as createdb6_551_0_, pricingpri2_.Updated as updated7_551_0_, pricingpri2_.UpdatedBy as updatedb8_551_0_, pricingpri2_.Name as name9_551_0_, pricingpri2_.Description as descrip10_551_0_, pricingpri2_.M_PriceList_ID as m_price11_551_0_, pricingpri2_.M_DiscountSchema_ID as m_disco12_551_0_, pricingpri2_.ValidFrom as validfr13_551_0_, pricingpri2_.ProcCreate as proccre14_551_0_, pricingpri2_.M_Pricelist_Version_Base_ID as m_price15_551_0_, pricingpri2_.M_Pricelist_Version_Generate as m_price16_551_0_, pricingpri2_.EM_Pruti_Import_Prices as em_prut17_551_0_, uom6_.AD_Client_ID as ad_clien2_324_1_, uom6_.AD_Org_ID as ad_org_i3_324_1_, uom6_.IsActive as isactive4_324_1_, uom6_.Created as created5_324_1_, uom6_.Updated as updated6_324_1_, uom6_.CreatedBy as createdb7_324_1_, uom6_.UpdatedBy as updatedb8_324_1_, uom6_.X12DE355 as x9_324_1_, uom6_.UOMSymbol as uomsymb10_324_1_, uom6_.Name as name11_324_1_, uom6_.Description as descrip12_324_1_, uom6_.StdPrecision as stdprec13_324_1_, uom6_.CostingPrecision as costing14_324_1_, uom6_.IsDefault as isdefau15_324_1_, uom6_.Breakdown as breakdo16_324_1_, uom6_.UOM_Type as uom_typ17_324_1_, uom6_.Useinproduction as useinpr18_324_1_ from M_ProductPrice pricingpro0_ inner join M_Product product1_ on pricingpro0_.M_Product_ID = product1_.M_Product_ID inner join M_PriceList_Version pricingpri2_ on pricingpro0_.M_PriceList_Version_ID = pricingpri2_.M_PriceList_Version_ID inner join M_PriceList pricingpri3_ on pricingpri2_.M_PriceList_ID = pricingpri3_.M_PriceList_ID left outer join C_Currency currency4_ on pricingpri3_.C_Currency_ID = currency4_.C_Currency_ID left outer join M_Product product5_ on product1_.Generic_Product_ID = product5_.M_Product_ID inner join C_UOM uom6_ on product1_.C_UOM_ID = uom6_.C_UOM_ID where product1_.IsGeneric = 'N' and product1_.IsActive = 'Y' and pricingpri2_.IsActive = 'Y' and (product1_.AD_Client_ID in ('0', 'FF80818133B7413E0133B7164D6A0002')) and (product1_.AD_Org_ID in ('0', 'FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and pricingpri3_.IsSOPriceList = 'Y' and currency4_.C_Currency_ID = '102' and (upper(product1_.UPC) like upper('%AURIGA%%') or upper(product1_.Value) like upper('%AURIGA%%') or upper(product1_.Name) like upper('%AURIGA%%')) and (upper(pricingpri2_.Name) like upper('%Venta%')) and pricingpri2_.M_PriceList_Version_ID = 'FF80818134057575013437B0786E0262' order by 7 limit '76';
Date: 2026-07-18 10:15:30 Duration: 1s251ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
6 1s87ms 1s219ms 1s147ms 15 17s207ms select * from ( select o.c_order_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || ad_column_identifier (?, o.c_order_id, ?) || ? || sum(ol.linenetamt) || ? || o.totallines as description, ? as isactive, o.ad_org_id as ad_org_id, o.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, o.c_order_id, ?) as record_id from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) 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 #6
Day Hour Count Duration Avg duration Jul 18 07 1 1s219ms 1s219ms 08 1 1s116ms 1s116ms 09 1 1s175ms 1s175ms 10 1 1s125ms 1s125ms 11 1 1s142ms 1s142ms 12 1 1s180ms 1s180ms 13 1 1s151ms 1s151ms 14 1 1s102ms 1s102ms 15 1 1s174ms 1s174ms 16 1 1s87ms 1s87ms 17 1 1s162ms 1s162ms 18 1 1s168ms 1s168ms 19 1 1s152ms 1s152ms 20 1 1s130ms 1s130ms 21 1 1s117ms 1s117ms [ User: tad - Total duration: 17s207ms - Times executed: 15 ]
[ Application: openbravo - Total duration: 17s207ms - Times executed: 15 ]
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 07:00:01 Duration: 1s219ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 12:00:01 Duration: 1s180ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 09:00:01 Duration: 1s175ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
7 1s1ms 1s111ms 1s36ms 8 8s293ms select shipmentin0_.m_inout_id as m_inout_1_509_0_, shipmentin0_.ad_client_id as ad_clien2_509_0_, shipmentin0_.ad_org_id as ad_org_i3_509_0_, ( select count(*) from c_bpartner as bp where bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = ?) > ?) as formula34_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula35_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 18 09 2 2s30ms 1s15ms 10 5 5s253ms 1s50ms 11 1 1s9ms 1s9ms [ User: tad - Total duration: 8s293ms - Times executed: 8 ]
[ Application: openbravo - Total duration: 8s293ms - Times executed: 8 ]
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '31DAF150D8954486B73F1FB987F27C3E';
Date: 2026-07-18 10:21:03 Duration: 1s111ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '31DAF150D8954486B73F1FB987F27C3E';
Date: 2026-07-18 10:21:02 Duration: 1s58ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '4BE1DBCDCCC24B5AABA8C6593DE4C732';
Date: 2026-07-18 10:02:02 Duration: 1s54ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
8 1s20ms 1s58ms 1s35ms 3 3s105ms select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> ? or coalesce(sd.qtyorderonhand, ?) <> ? union all select m_product_id, null, ?, ? from m_product p where p.isgeneric = ?) as ps where ((ps.qtyonhand <> ? and exists ( select ? from m_locator ml where ml.m_locator_id = ps.m_locator_id and exists ( select ? from ad_org_warehouse ow where ml.m_warehouse_id = ow.m_warehouse_id and ow.ad_org_id in (...)))) or (exists ( select ? from m_product mp where ps.m_product_id = mp.m_product_id and mp.isstocked = ? and mp.producttype = ? and ad_client_id = ?))) and not exists ( select ? from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = ?) and exists ( select ? from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = ? and mp.producttype = ? and ad_client_id = ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 18 07 1 1s20ms 1s20ms 08 1 1s26ms 1s26ms 15 1 1s58ms 1s58ms [ User: tad - Total duration: 3s105ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 3s105ms - Times executed: 3 ]
-
select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> 0 OR COALESCE(sd.qtyorderonhand, 0) <> 0 union ALL select m_product_id, null, 0, 0 FROM m_product p WHERE p.isgeneric = 'N') as ps where ((ps.qtyonhand <> 0 AND EXISTS ( SELECT 1 FROM m_locator ml WHERE ml.m_locator_id = ps.m_locator_id AND EXISTS ( SELECT 1 FROM AD_Org_Warehouse ow WHERE ml.m_warehouse_id = ow.m_warehouse_id AND ow.ad_org_id IN ('FF80818134D2AA330134F1D03034277D', 'FF80818133B7413E0133B71974AD28C6')))) OR (EXISTS ( SELECT 1 FROM m_product mp WHERE ps.m_product_id = mp.m_product_id AND mp.isstocked = 'N' AND mp.producttype = 'I' AND ad_client_id = 'FF80818133B7413E0133B7164D6A0002'))) AND NOT EXISTS ( select 1 from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = '52ABADF5F9C04311B0A0E8FD21244670') AND exists ( select 1 from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = 'Y' and mp.producttype = 'I' and ad_client_id = 'FF80818133B7413E0133B7164D6A0002');
Date: 2026-07-18 15:00:01 Duration: 1s58ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> 0 OR COALESCE(sd.qtyorderonhand, 0) <> 0 union ALL select m_product_id, null, 0, 0 FROM m_product p WHERE p.isgeneric = 'N') as ps where ((ps.qtyonhand <> 0 AND EXISTS ( SELECT 1 FROM m_locator ml WHERE ml.m_locator_id = ps.m_locator_id AND EXISTS ( SELECT 1 FROM AD_Org_Warehouse ow WHERE ml.m_warehouse_id = ow.m_warehouse_id AND ow.ad_org_id IN ('FF80818134D2AA330134F1D03034277D', 'FF80818133B7413E0133B71974AD28C6')))) OR (EXISTS ( SELECT 1 FROM m_product mp WHERE ps.m_product_id = mp.m_product_id AND mp.isstocked = 'N' AND mp.producttype = 'I' AND ad_client_id = 'FF80818133B7413E0133B7164D6A0002'))) AND NOT EXISTS ( select 1 from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = '52ABADF5F9C04311B0A0E8FD21244670') AND exists ( select 1 from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = 'Y' and mp.producttype = 'I' and ad_client_id = 'FF80818133B7413E0133B7164D6A0002');
Date: 2026-07-18 08:00:01 Duration: 1s26ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> 0 OR COALESCE(sd.qtyorderonhand, 0) <> 0 union ALL select m_product_id, null, 0, 0 FROM m_product p WHERE p.isgeneric = 'N') as ps where ((ps.qtyonhand <> 0 AND EXISTS ( SELECT 1 FROM m_locator ml WHERE ml.m_locator_id = ps.m_locator_id AND EXISTS ( SELECT 1 FROM AD_Org_Warehouse ow WHERE ml.m_warehouse_id = ow.m_warehouse_id AND ow.ad_org_id IN ('FF80818134D2AA330134F1D03034277D', 'FF80818133B7413E0133B71974AD28C6')))) OR (EXISTS ( SELECT 1 FROM m_product mp WHERE ps.m_product_id = mp.m_product_id AND mp.isstocked = 'N' AND mp.producttype = 'I' AND ad_client_id = 'FF80818133B7413E0133B7164D6A0002'))) AND NOT EXISTS ( select 1 from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = '52ABADF5F9C04311B0A0E8FD21244670') AND exists ( select 1 from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = 'Y' and mp.producttype = 'I' and ad_client_id = 'FF80818133B7413E0133B7164D6A0002');
Date: 2026-07-18 07:00:01 Duration: 1s20ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
9 1s2ms 1s42ms 1s24ms 3 3s74ms select * from ( select distinct ad_column_identifier (?, fin_payment_schedule.c_invoice_id, ?) as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = ? group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, ?)) order by ?) 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 #9
Day Hour Count Duration Avg duration Jul 18 09 1 1s2ms 1s2ms 15 1 1s42ms 1s42ms 17 1 1s29ms 1s29ms [ User: tad - Total duration: 3s74ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 3s74ms - Times executed: 3 ]
-
SELECT * FROM ( select distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'DF2689B486E04B849AB2F8CD38EE5B23' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 15:00:02 Duration: 1s42ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'DF2689B486E04B849AB2F8CD38EE5B23' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 17:00:02 Duration: 1s29ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'DF2689B486E04B849AB2F8CD38EE5B23' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-18 09:00:02 Duration: 1s2ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
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 NO DATASET
-
Events
Log levels
Key values
- 15,976 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
- 6 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 5 Max number of times the same event was reported
- 6 Total events found
Rank Times reported Error 1 5 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 18 10 5 - ERROR: current transaction is aborted, commands ignored until end of transaction block
- ERROR: current transaction is aborted, commands ignored until end of transaction block
- ERROR: current transaction is aborted, commands ignored until end of transaction block
Statement: 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=$1 and this_.AD_Org_ID in ($2, $3, $4, $5, $6) and this_.AD_Client_ID in ($7, $8) and this_.Isactive=$9
Date: 2026-07-18 10:21:07 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Statement: 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=$1 and this_.AD_Org_ID in ($2, $3, $4, $5, $6) and this_.AD_Client_ID in ($7, $8) and this_.Isactive=$9
Date: 2026-07-18 10:21:07 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Statement: 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=$1 and this_.AD_Org_ID in ($2, $3, $4, $5, $6) and this_.AD_Client_ID in ($7, $8) and this_.Isactive=$9
Date: 2026-07-18 10:21:07 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
2 1 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 18 10 1 - ERROR: syntax error at or near ")" at character 162
Statement: SELECT td0.AD_Client_ID AS ID, (COALESCE(TO_CHAR(COALESCE(TO_CHAR(td0.Name),'')),'')) AS NAME, '' AS DESCRIPTION FROM AD_Client td0 WHERE td0.AD_Client_ID IN () AND (td0.isActive = 'Y' OR td0.AD_Client_ID = ($1) ) AND td0.AD_Client_ID=($2) ORDER BY 2
Date: 2026-07-18 10:21:07 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1