pgBadger-
Global information
- Generated on Fri Jul 17 23:00:16 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 46,333 log entries in 15s
- Log start from 2026-07-17 07:00:02 to 2026-07-17 22:00:00
-
Overview
Global Stats
- 8 Number of unique normalized queries
- 51 Number of queries
- 14m40s Total query duration
- 2026-07-17 07:00:04 First query
- 2026-07-17 21:00:03 Last query
- 1 queries/s at 2026-07-17 10:00:04 Query peak
- 14m40s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 14m40s Execute total duration
- 10 Number of events
- 2 Number of unique normalized events
- 9 Max number of times the same event was reported
- 0 Number of cancellation
- 13,293 Total number of automatic vacuums
- 131 Total number of automatic analyzes
- 714 Number temporary file
- 22.26 MiB Max size of temporary file
- 11.17 MiB Average size of temporary file
- 3,403 Total number of sessions
- 71 sessions at 2026-07-17 19:10:00 Session peak
- 8d22h35m50s Total duration of sessions
- 3m47s Average duration of sessions
- 0 Average queries per session
- 258ms Average queries duration per session
- 3m46s Average idle time per session
- 3,403 Total number of connections
- 6 connections/s at 2026-07-17 20:00:00 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-17 10:00:04 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-17 10:00:04 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 14m40s 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 17 07 26 0ms 53s326ms 25s868ms 13s25ms 1m43s 3m 08 4 0ms 2s253ms 1s459ms 0ms 1s271ms 2s253ms 09 1 0ms 2s567ms 2s567ms 0ms 0ms 2s567ms 10 1 0ms 2s129ms 2s129ms 0ms 0ms 2s129ms 11 2 0ms 2s231ms 1s748ms 0ms 0ms 2s231ms 12 2 0ms 25s115ms 13s657ms 0ms 0ms 25s115ms 13 2 0ms 22s296ms 12s281ms 0ms 0ms 22s296ms 14 2 0ms 26s969ms 14s502ms 0ms 0ms 26s969ms 15 2 0ms 25s139ms 13s634ms 0ms 0ms 25s139ms 16 1 0ms 2s92ms 2s92ms 0ms 0ms 2s92ms 17 2 0ms 24s251ms 13s151ms 0ms 0ms 24s251ms 18 2 0ms 23s952ms 12s995ms 0ms 0ms 23s952ms 19 2 0ms 24s320ms 13s283ms 0ms 0ms 24s320ms 20 1 0ms 2s136ms 2s136ms 0ms 0ms 2s136ms 21 1 0ms 2s223ms 2s223ms 0ms 0ms 2s223ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 17 07 26 0 25s868ms 1s232ms 13s25ms 2m47s 08 4 0 1s459ms 0ms 0ms 1s306ms 09 1 0 2s567ms 0ms 0ms 0ms 10 1 0 2s129ms 0ms 0ms 0ms 11 2 0 1s748ms 0ms 0ms 1s265ms 12 2 0 13s657ms 0ms 0ms 2s200ms 13 2 0 12s281ms 0ms 0ms 2s265ms 14 2 0 14s502ms 0ms 0ms 2s34ms 15 2 0 13s634ms 0ms 0ms 2s129ms 16 1 0 2s92ms 0ms 0ms 0ms 17 2 0 13s151ms 0ms 0ms 2s51ms 18 2 0 12s995ms 0ms 0ms 2s38ms 19 2 0 13s283ms 0ms 0ms 2s246ms 20 1 0 2s136ms 0ms 0ms 0ms 21 1 0 2s223ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 17 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 0 0 0ms 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 22 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 17 07 0 25 25.00 0.00% 08 0 3 3.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 1 1.00 0.00% 12 0 1 1.00 0.00% 13 0 1 1.00 0.00% 14 0 1 1.00 0.00% 15 0 1 1.00 0.00% 16 0 0 0.00 0.00% 17 0 1 1.00 0.00% 18 0 1 1.00 0.00% 19 0 1 1.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% Day Hour Count Average / Second Jul 17 07 238 0.07/s 08 221 0.06/s 09 218 0.06/s 10 226 0.06/s 11 227 0.06/s 12 228 0.06/s 13 228 0.06/s 14 229 0.06/s 15 228 0.06/s 16 219 0.06/s 17 229 0.06/s 18 228 0.06/s 19 232 0.06/s 20 224 0.06/s 21 223 0.06/s 22 5 0.00/s Day Hour Count Average Duration Average idle time Jul 17 07 237 39m19s 39m16s 08 225 13s660ms 13s634ms 09 219 38s15ms 38s3ms 10 226 2m30s 2m30s 11 227 28s90ms 28s75ms 12 228 42s139ms 42s19ms 13 228 29s392ms 29s284ms 14 229 1m1s 1m1s 15 228 1m22s 1m21s 16 219 2m3s 2m3s 17 229 29s829ms 29s714ms 18 228 29s388ms 29s274ms 19 232 3m52s 3m52s 20 224 44s247ms 44s238ms 21 223 35s795ms 35s785ms 22 1 22ms 22ms -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-07-17 20:00:00 Date
Connections per database
Key values
- etendo Main Database
- 3,403 connections Total
Connections per user
Key values
- tad Main User
- 3,403 connections Total
-
Sessions
Simultaneous sessions
Key values
- 71 sessions Session Peak
- 2026-07-17 19:10:00 Date
Histogram of session times
Key values
- 3,223 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 3,403 sessions Total
Sessions per user
Key values
- tad Main User
- 3,403 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 3,403 sessions Total
Sessions per application
Key values
- psql Main Application
- 3,403 sessions Total
Application Count Total Duration Average Duration DBeaver 26.0.1 - Main 3 26m3s 8m41s DBeaver 26.0.1 - Main 3 26m14s 8m44s DBeaver 26.0.1 - Metadata 3 26m1s 8m40s DBeaver 26.0.1 - Metadata 3 26m11s 8m43s DBeaver 26.0.1 - Read PostgreSQL database list 3 2s608ms 869ms DBeaver 26.0.1 - SQLEditor 3 26m5s 8m41s DBeaver 26.0.1 - SQLEditor 1 4m10s 4m10s DBeaver 26.0.1 - SQLEditor 1 2m20s 2m20s Mashup Engine 63 5h30m57s 5m15s PostgreSQL JDBC Driver 2 14s191ms 7s95ms openbravo 65 8d14h45m46s 3h10m51s pg_profile 45 14s56ms 312ms psql 3,208 1m29s 27ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 5,512 buffers Checkpoint Peak
- 2026-07-17 08:01:26 Date
- 270.069 seconds Highest write time
- 0.013 seconds Sync time
Checkpoints Wal files
Key values
- 2 files Wal files usage Peak
- 2026-07-17 08:01:26 Date
Checkpoints distance
Key values
- 79.29 Mo Distance Peak
- 2026-07-17 08:01:26 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 17 07 4,262 336.827s 0.024s 336.884s 08 13,209 893.064s 0.015s 893.102s 09 7,353 624.571s 0.015s 624.603s 10 7,739 638.666s 0.013s 638.695s 11 5,328 402.307s 0.011s 402.334s 12 4,493 326.983s 0.011s 327.009s 13 4,287 324.127s 0.013s 324.158s 14 4,119 326.776s 0.015s 326.807s 15 4,060 321.713s 0.011s 321.743s 16 3,858 315.767s 0.011s 315.818s 17 4,142 320.42s 0.011s 320.452s 18 3,868 303.594s 0.011s 303.62s 19 4,338 329.529s 0.011s 329.557s 20 4,298 328.906s 0.011s 328.934s 21 4,236 323.999s 0.011s 324.027s 22 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 17 07 0 0 1 454 0.008s 0.01s 08 0 0 4 1,487 0.001s 0.013s 09 0 0 1 1,310 0.001s 0.012s 10 0 0 2 1,328 0.001s 0.012s 11 0 0 1 723 0.001s 0.011s 12 0 0 1 416 0.001s 0.011s 13 0 0 1 389 0.001s 0.011s 14 0 0 1 392 0.003s 0.011s 15 0 0 1 386 0.001s 0.011s 16 0 0 1 376 0.001s 0.011s 17 0 0 1 375 0.001s 0.011s 18 0 0 1 383 0.001s 0.011s 19 0 0 1 403 0.001s 0.011s 20 0 0 1 402 0.001s 0.011s 21 0 0 1 396 0.001s 0.011s 22 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 17 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s Day Hour Mean distance Mean estimate Jul 17 07 1,784.10 kB 10,725.80 kB 08 4,862.77 kB 24,351.38 kB 09 2,269.17 kB 9,979.17 kB 10 2,327.17 kB 10,363.50 kB 11 1,746.73 kB 10,283.91 kB 12 1,488.55 kB 9,735.55 kB 13 1,462.36 kB 9,585.55 kB 14 1,427.73 kB 9,295.36 kB 15 1,436.27 kB 9,422.18 kB 16 1,428.73 kB 9,348.64 kB 17 1,451.82 kB 9,525.73 kB 18 1,492.27 kB 9,793.09 kB 19 1,468.36 kB 9,545.27 kB 20 1,503.27 kB 9,764.91 kB 21 1,504.18 kB 9,823.82 kB 22 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 56.05 MiB Temp Files size Peak
- 2026-07-17 07:48:07 Date
Number of temporary files
Key values
- 5 per second Temp Files Peak
- 2026-07-17 07:48:07 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 17 07 702 7.73 GiB 11.27 MiB 08 3 25.76 MiB 8.59 MiB 09 0 0 0 10 0 0 0 11 3 25.76 MiB 8.59 MiB 12 0 0 0 13 0 0 0 14 2 3.50 MiB 1.75 MiB 15 0 0 0 16 0 0 0 17 2 3.50 MiB 1.75 MiB 18 0 0 0 19 0 0 0 20 2 3.50 MiB 1.75 MiB 21 0 0 0 22 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 691 7.57 GiB 11.21 MiB 11.21 MiB 11.21 MiB select shipmentin0_.m_inout_id as m_inout_1_521_0_, shipmentin0_.ad_client_id as ad_clien2_521_0_, shipmentin0_.ad_org_id as ad_org_i3_521_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula34_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id in (...);-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('E341B938EE354C90A4A049F069F4DAA9', 'CC865F1ADCDA462CBBEE333F8A738275', 'C55C2211696E4EFC8C40A6AE6ECD4F6F', '983097CA14BD41DD989FD5621F358F63', '87A1B81CC6904CCE93BEAB5C8580A041', '14789B1EDC704F659C26E9ED68001319', '07B486592161449EB173F0A53BCDC503', '6D83F4670D7B42FB9D07E29595DE0A3B', '5B9F9E6C6D0544608D26E063CD35B29C', '518A49B3472F4256B1C430E16B8E3878', '4A51F861FF37436B8D943C8959643C5F', '07A3A3DF63E64D4C9DFC6C7C0BBA1F25', 'FFB1D1BA333E4F229A969866B6C8C4CA', 'EF8455A1230A4B2E8F5E94941915B8A8', 'EC805D277C83422492ACE03FA4D8B344', 'D9BADC73AF8747578D14423F9CE3AEFC', 'D8A553FABFC14929853D067C5D5026A0', 'D0256943A1A94ADC92367F85E1B3098B', 'C99F66E9C8FE4EBE9F685651C8AFF761', 'AAE117B63415497EBE6866874186AE4D', '78AB6EF0E2E1424FBD9C8A4535D6073C', '6FB9EA84D54E4264A4FCFBA27B0CAC58', '6DB4864FB64D40DCAD9CB3B20EA34CB6', '6CDACA9BB90B43EEA4525EE71A715B07', '6A9C8FB9082A46E685B889B438F587BC', '59525207A29946159D962C124902086A', '381292DA14AC41319DF64C42CD44807D', '0F7D1640888341899B1963877BCF82F5', '07E0E689962A41F3B9EF2C5E7C281F26', 'B86ABF14DB384C6F930775E3BDCA0282', '81D3F18EB6984459B3B5EB668D6ED39C', '25CCBB462CF6499C9799F7BB96C6B0CE', 'F6270C337FEF4F5FBC569305DAEB6854', 'F4D7EB873E184313AE8749A532833981', 'DB9BF174C8244345BBCEDE58FDB825AF', 'CB7811A603624202A441841BB43B363D', '96A48F85F69546D483D3B2C1DABE7284', '96160E5CF83C4BA48627B27C4CAD7270', '6F8224B47A4A49BBAE17B3830AA3D36F', '6913A1AB611F4C04932E98A3A3A3CCE0', '4E87203D64BD4F08B272A8CEA55B7130', '341771A95A1B4C15809CD69FE9F131AA', '1FBD80EFB6EA43D5B780C97FD0DB2E26', '070EF5DB307C496C88006C36FF2C3C4E', 'BB1218FBBA624F17AE49C522E736A3E1', 'A9CA82DF289242FF8B3A1B433846946F', '668F8E571183459FAD85DB4C60E1C84A', '64D0841754154470B4C1F47085F05737', '2BEF4068706C406EBE74923F2E3A2100', 'F391EB61C8284C7E8479892EC4ADA3E9');
Date: 2026-07-17 07:48:20 Duration: 53s326ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('897B6A3582C145988EF890564BE9B95C', '5E0968B250D94CB2910FA3B989395828', '5E064FEFC8844ED8AF01EC712E13CDD9', '476D0BE1B6714A4DB7771406E70041AF', '32ADD0EA1F1A4178BA1983960218A6CA', '23244A1DF17B48618F94499D4F22DA10', 'F5FF23666E684188B591FFA859E69BE8', 'DC5344AEC7674782838FABF633E4A028', 'CB600B3C4D7649C9AEEB6B88604B041C', 'C0DDEF758EED4F52BCE0130A887EAD27', 'B577530D1CEA45FA84B4983E7ADBD24F', 'B4C7E923CB4E4B6D993D7AC917E67993', 'B376BDB6928443FCA28B4F734AA47953', 'AC91B399C2974EEBB1E28FDF08F7FF0F', '8FB5B343669A413D9E63BA5E78EFCD70', '7AD5160327044FB98AD727DD1BCB78AB', '6A4311CB1BC14810B78FBD7CBBDD14DE', '678D14E2839E401699E5FD8FDA7ED38F', '61890F68AF5444A3B92157F79D814EF3', '5BA9DAB956FD4099B6CC53AA36E14F0A', '57A75659AD284DE193C849DF001EF79E', '3D625F0195274F1FAB749A4EEEA9570B', 'EE1BFC992E1D46F788DAC4A1FB91505C', 'D6C10436FE9A4104AEEF78A12F3C0694', 'D18F338EA5F346D9877983D53ABF3899', 'C488EECA6A53410CA41CF709FE2B8E6D', 'C3D8E2802DFB4D7586E12EEA20F9C0D5', 'B30F570BC66E4B99BB0C8DE0861ADC52', 'AA606CF7473A40FD82191F6183BBA888', '821CB396490345DF9405533CDD38B2A5', '7165046164F5465C9F4DFC50C45F59CF', '64BB9FE1B0534415B67146291B75C99F', '4253F000BD0A4F86AD50D0A7389254EC', '37EBFCE207A8436AAC0509D7F5AE1676', '31CF58828C2943D38D284D5554B2FD0C', '31C41C9634E645778AF9474A9611282D', '1BFC606BC1044386812B6831AAA05FC5', '0549E1443FFC4A8AB80F47ED23E87709', 'F16B8AFBC15343DB8D79E783F4167948', '93EF3012353B4228AFE7FFE449FED83D', '8105DBD13C0E432EBA97B5D9FEEF0576', '6BFD1A6ABD984C878626F241340193F6', '63C8B6FB476940DDAD1CAD52829DDB57', '19BE974A72B1411287B77983E0482850', 'F769D2B2982A41379C473CC6B6728FA9', 'E63DD98E4B5E4B88992C96E0C3BE4FAD', 'E603984ECA8A46978C85179B5C8B3531', '9962A410E59646DDBE3F5C2F73F13185', '8A73FAEB5206468A98A3098017C145E6', '76216167222E4B0FBB258A812666A693');
Date: 2026-07-17 07:49:03 Duration: 53s57ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('F579B1A55A2441168C8F3FE6540018CF', 'DBF552E609444C9DBE2C4097BF6E5B7B', 'D3F480A3019C4EE09738BE4B5240EECC', 'CEAB899637F34F15AEC45E6E69312B1C', 'CDC6C680D63449F39B58E3E709C6AE76', 'C24E466824884AA69E1924567DDADDC5', 'B949932CE16D4671A9A26582348D7043', 'A5B5545CF34143A3890B6D0634841E86', 'A127F87F10EB49E2A64A27EE444B8998', '968EBF4E2EAF4B09BEF9AB2BFB570A55', '6CC946CE146847D19EAB3B154B0CC3AB', '575B5D7054104206B57FD0E15613BF35', '5360A1D40AB545949CB002FB5A7DA19D', '509E23E4DB7D4530B4F77F1ADF31A6F6', '3E18BCF5BD1E47ABA495039D73072303', '23AD62B4E0D6486E8F7DF202C65EDE3A', '18EA3C75A0364389970D62353B068756', '14C11CDC6F71459FB2889943DEF40A20', 'C8242610250F4BEE80B981062E4D269C', 'C6B885B7E55E4AF28460E77AA5B0291D', 'C3ACE2604972469FBFB12DDC9B8FC0ED', 'C27DF24FFC2844DD83C1FD6DB724F645', 'AB6CB8647D60402C8653BF5CEA77CDF1', 'A39D331D845D4BF683E0E9F54159FD2F', '9A1073CCA1E24B4EA496EE4874BEE4B6', '977253F06F7D4B008AED1CF8B926F66B', '7BC892DF2C3A4A10B202B7E3FD926575', '7884E045302B44D99CF9D9E1A285B8E3', '69FA2585EC3548AA8C7308D27BB4CA63', '621A3DB055F64443886855BDF6FE0F8B', '5ED36936A5A643E1861230A64FA0274E', '5B735E91786E48C487F7C05382ADFFCA', '4DA803F5A9484638A2C6D0607A5FDBAB', '4A02A4151D194ABE8D7AE997FF77E8BC', '42C5ED3CDFAD473B9A3DB7F169BD7E1E', '406A8120D09E4F2D929D313D3206AABB', '37A5CF5AFE0848FD965DE0E82475C08D', '19847AA4D4C34B81AD2F3CA824F1B9F4', '15AB26E73E014CD7A7BD16CEB9A9A8BF', 'DB2BD124BF4541868FB37A8A63D2D8BE', 'CB5FB2DF310D41A68A23223A75FBB8DC', 'C4883DA872924A319B0A180973B290C0', '807DA4047FB6440E8A1076BFEA9E3067', '348067BEE15340B2A047D70D8A54D37A', 'FEEB974131804A4F8275B1F4CF5898CF', 'EAB4547B4BF64163BECAF5319ECA6109', 'B0353BC736AE4F9FAE9DE68118F3D072', '9FD301FE0E95400DA3059B3DB549ECCE', '9D4419DF81E844019AA081CF48E4EE87', '8F87E4C023874DD0910695792E2287E8');
Date: 2026-07-17 07:48:10 Duration: 52s525ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
2 7 78.48 MiB 11.21 MiB 11.21 MiB 11.21 MiB select shipmentin0_.m_inout_id as m_inout_1_521_0_, shipmentin0_.ad_client_id as ad_clien2_521_0_, shipmentin0_.ad_org_id as ad_org_i3_521_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula34_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id = ?;-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '34B8EE7EDE844769862EEBB446106D5B';
Date: 2026-07-17 07:49:04 Duration: 1s123ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = 'A8A567AE0D2447B894B2C92C22D29335';
Date: 2026-07-17 07:58:40 Duration: 1s Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = $1;
Date: 2026-07-17 07:49:04 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
3 6 133.55 MiB 22.26 MiB 22.26 MiB 22.26 MiB select orderline0_.m_product_id as col_0_0_, product1_.name as col_1_0_, sum(orderline0_.qtyordered) as col_2_0_, uom3_.name as col_3_0_, product1_.c_uom_id as col_4_0_ from c_orderline orderline0_ cross join m_product product1_ cross join c_uom uom3_ cross join c_order order5_ cross join m_product product7_ where orderline0_.m_product_id = product1_.m_product_id and product1_.c_uom_id = uom3_.c_uom_id and orderline0_.c_order_id = order5_.c_order_id and orderline0_.m_product_id = product7_.m_product_id and order5_.docstatus = ? and order5_.issotrx = ? and ? = ? and orderline0_.ad_client_id = ? and (product7_.name like ?) and (orderline0_.ad_org_id in (...)) group by product1_.name, uom3_.name, orderline0_.m_product_id, product1_.c_uom_id order by sum(orderline0_.qtyordered) desc limit ?;-
select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = '3C5B81C4F43246A88CB0D6064A5E0530' and (product7_.Name like '%') and (orderline0_.AD_Org_ID in ('0', '9F4FFFC6F7674F6F917C736776A79EFD')) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit '10';
Date: 2026-07-17 07:52:52 Duration: 3s756ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = '3C5B81C4F43246A88CB0D6064A5E0530' and (product7_.Name like '%') and (orderline0_.AD_Org_ID in ('0', '9F4FFFC6F7674F6F917C736776A79EFD')) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit '10';
Date: 2026-07-17 07:38:14 Duration: 1s812ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
-
select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = '3C5B81C4F43246A88CB0D6064A5E0530' and (product7_.Name like '%') and (orderline0_.AD_Org_ID in ('0', '9F4FFFC6F7674F6F917C736776A79EFD')) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit '10';
Date: 2026-07-17 07:48:30 Duration: 1s364ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
4 5 17.50 MiB 3.50 MiB 3.50 MiB 3.50 MiB update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( 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 ?) 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 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) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-17 08:00:01 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
Queries generating the largest temporary files
Rank Size Query 1 22.26 MiB select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = $1 and (product7_.Name like $2) and (orderline0_.AD_Org_ID in ($3, $4)) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit $5;[ Date: 2026-07-17 07:38:14 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2 22.26 MiB select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = $1 and (product7_.Name like $2) and (orderline0_.AD_Org_ID in ($3, $4)) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit $5;[ Date: 2026-07-17 07:47:15 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3 22.26 MiB select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = $1 and (product7_.Name like $2) and (orderline0_.AD_Org_ID in ($3, $4)) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit $5;[ Date: 2026-07-17 07:48:30 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4 22.26 MiB select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = $1 and (product7_.Name like $2) and (orderline0_.AD_Org_ID in ($3, $4)) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit $5;[ Date: 2026-07-17 08:15:24 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5 22.26 MiB select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = $1 and (product7_.Name like $2) and (orderline0_.AD_Org_ID in ($3, $4)) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit $5;[ Date: 2026-07-17 11:40:07 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
6 22.26 MiB select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = $1 and (product7_.Name like $2) and (orderline0_.AD_Org_ID in ($3, $4)) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit $5;[ Date: 2026-07-17 07:52:52 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
7 11.21 MiB select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50);[ Date: 2026-07-17 07:47:17 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8 11.21 MiB select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50);[ Date: 2026-07-17 07:47:18 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
9 11.21 MiB select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50);[ Date: 2026-07-17 07:47:19 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
10 11.21 MiB select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50);[ Date: 2026-07-17 07:47:19 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
11 11.21 MiB select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50);[ Date: 2026-07-17 07:47:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
12 11.21 MiB select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50);[ Date: 2026-07-17 07:47:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
13 11.21 MiB select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50);[ Date: 2026-07-17 07:47:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
14 11.21 MiB select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50);[ Date: 2026-07-17 07:47:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
15 11.21 MiB select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50);[ Date: 2026-07-17 07:47:22 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
16 11.21 MiB select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50);[ Date: 2026-07-17 07:47:22 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
17 11.21 MiB select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50);[ Date: 2026-07-17 07:47:23 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
18 11.21 MiB select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50);[ Date: 2026-07-17 07:47:23 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
19 11.21 MiB select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50);[ Date: 2026-07-17 07:47:24 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
20 11.21 MiB select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50);[ Date: 2026-07-17 07:47:24 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 6.55 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo - 2026-07-17 07:52:38 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 6.55 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo - 2026-07-17 07:52:38 Date
Analyzes per table
Key values
- profile.last_stat_user_functions_srv1 (15) Main table analyzed (database etendo)
- 131 analyzes Total
Table Number of analyzes etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.last_stat_statements_srv1 15 etendo.profile.last_stat_tables_srv1 15 etendo.profile.last_stat_indexes_srv1 15 etendo.profile.last_stat_io 7 etendo.profile.tables_list 7 etendo.profile.stmt_list 5 etendo.profile.last_extension_versions 4 etendo.profile.funcs_list 4 etendo.profile.last_stat_activity_count_srv1 4 etendo.public.ad_session 4 etendo.profile.indexes_list 3 etendo.profile.last_stat_slru 3 etendo.public.ad_process_request 2 etendo.profile.sample_stat_io 2 etendo.profile.sample_statements 2 etendo.public.c_invoice 2 etendo.profile.sample_stat_indexes 2 etendo.profile.sample_stat_user_functions 2 etendo.profile.last_stat_wal 1 etendo.pg_catalog.pg_attribute 1 etendo.public.c_import_entry 1 etendo.profile.sample_stat_tables 1 etendo.public.ad_module 1 etendo.profile.sample_stat_tablespaces 1 etendo.profile.last_stat_archiver 1 etendo.profile.sample_stat_slru 1 etendo.profile.sample_stat_tables_total 1 etendo.profile.sample_statements_total 1 etendo.public.ad_ep_instance_para 1 etendo.public.ad_preference 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.last_stat_cluster 1 etendo.profile.sample_stat_user_func_total 1 etendo.pg_catalog.pg_type 1 etendo.public.ad_process_run 1 etendo.profile.sample_stat_database 1 Total 131 Vacuums per table
Key values
- public.ad_module (897) Main table vacuumed on database etendo
- 13,293 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples etendo.public.ad_module 897 1 215,078 0 122 0 0 253 116 278,299 30 97 etendo.pg_toast.pg_toast_111094 897 1 488,578 0 311 0 0 475 186 180,569 0 0 etendo.profile.last_stat_tables_srv1 844 1 5,865,752 0 19,342 0 0 30,467 9,967 4,041,456 14 18 etendo.profile.last_stat_indexes_srv1 842 1 8,148,541 0 24,608 0 0 38,897 12,864 5,824,596 1 1 etendo.profile.last_stat_user_functions_srv1 794 1 625,226 0 1,770 0 0 3,285 936 778,868 13 352 etendo.profile.tables_list 772 1 483,558 0 406 0 0 773 224 164,609 148 818 etendo.public.ad_session 751 1 294,559 0 923 0 0 1,481 450 525,768 225 545 etendo.profile.last_stat_statements_srv1 743 1 1,206,861 0 7,662 0 0 12,563 4,120 2,212,009 25 370 etendo.public.c_import_entry 717 1 67,794 0 371 0 0 535 214 208,956 0 0 etendo.profile.last_stat_io 710 1 55,237 0 89 0 0 141 75 122,618 1 13 etendo.profile.funcs_list 710 1 149,114 0 124 0 0 269 65 73,043 40 230 etendo.profile.stmt_list 710 1 507,589 0 652 0 0 1,176 354 508,808 220 658 etendo.profile.indexes_list 651 1 147,013 0 121 0 0 252 64 70,605 43 386 etendo.profile.last_stat_activity_count_srv1 590 0 10,176 0 80 0 0 84 50 107,550 0 0 etendo.profile.last_extension_versions 530 1 24,196 0 57 0 0 72 39 57,925 1 8 etendo.pg_catalog.pg_statistic 414 1 1,442,387 0 4,258 0 0 6,307 2,037 1,516,207 387 1,584 etendo.profile.last_stat_slru 290 1 11,428 0 28 0 0 68 15 11,006 1 5 etendo.profile.last_stat_database_srv1 170 1 8,173 0 22 0 0 59 14 12,462 1 4 etendo.public.ad_process_request 53 1 28,383 0 640 0 0 895 261 363,852 139 312 etendo.pg_toast.pg_toast_2619 51 1 88,184 0 1,254 0 0 1,695 531 630,740 46 110 etendo.public.m_reservation 50 1 45,080 0 911 0 0 1,474 589 1,555,069 239 734 etendo.profile.sample_stat_user_functions 50 1 16,619 0 142 0 0 229 67 160,092 29 1,413 etendo.profile.sample_stat_database 50 1 5,088 0 73 0 0 113 26 36,551 22 306 etendo.public.c_invoice 50 1 884,513 0 15,255 0 0 22,593 8,882 10,407,017 486 2,694 etendo.pg_toast.pg_toast_118599 50 1 57,588 0 709 0 0 1,079 352 426,473 27 86 etendo.profile.sample_stat_slru 50 1 3,318 0 34 0 0 63 17 29,835 13 268 etendo.pg_toast.pg_toast_112974 50 1 4,323 0 40 0 0 98 37 17,763 0 0 etendo.public.ad_pinstance 50 1 26,657 0 474 0 0 845 303 872,086 163 775 etendo.profile.sample_stat_tables 50 1 112,104 0 1,300 0 0 1,867 497 545,993 75 865 etendo.public.ad_preference 50 1 43,352 0 608 0 0 988 316 542,980 91 143 etendo.profile.last_stat_tablespaces_srv1 50 1 1,765 0 10 0 0 16 4 4,476 1 2 etendo.public.m_storage_detail 50 1 52,577 0 1,136 0 0 1,587 841 2,047,907 155 987 etendo.public.obwpl_pickinglist 50 1 17,125 0 293 0 0 468 155 164,949 34 80 etendo.profile.sample_stat_indexes 50 1 20,529 0 261 0 0 388 118 218,504 23 1,090 etendo.public.ad_ep_instance_para 50 1 4,600 0 85 0 0 140 51 61,344 0 0 etendo.profile.sample_stat_tables_total 50 1 8,602 0 90 0 0 150 36 52,629 27 497 etendo.public.ad_sequence 50 1 4,025 0 22 0 0 44 18 33,000 8 52 etendo.profile.sample_stat_indexes_total 50 1 4,217 0 32 0 0 54 15 32,293 10 256 etendo.public.m_storage_pending 50 1 26,031 0 324 0 0 532 201 550,990 89 836 etendo.public.m_reservation_stock 50 1 37,158 0 766 0 0 1,186 564 1,733,513 194 1,228 etendo.public.prpp_json 50 1 3,887 0 26 0 0 55 23 55,729 9 56 etendo.profile.sample_statements 50 1 61,063 0 677 0 0 1,002 273 353,626 70 640 etendo.profile.sample_stat_io 50 1 6,028 0 60 0 0 103 25 40,415 19 542 etendo.pg_catalog.pg_type 1 1 250 0 39 0 0 61 33 40,434 0 0 etendo.profile.sample_statements_total 1 1 95 0 20 0 0 34 13 19,167 4 54 etendo.profile.last_stat_archiver 1 1 51 0 4 0 0 7 1 2,702 0 0 etendo.profile.sample_stat_user_func_total 1 1 70 0 9 0 0 11 5 10,842 0 0 etendo.profile.last_stat_cluster 1 1 56 0 4 0 0 7 1 2,884 0 0 etendo.profile.sample_stat_tablespaces 1 1 90 0 9 0 0 17 5 10,326 0 0 etendo.profile.last_stat_wal 1 1 51 0 3 0 0 7 0 914 0 0 Total 13,293 49 21,314,739 358,126 86,256 0 0 134,965 46,050 37,720,449 3,123 19,115 Vacuum throughput per table
Key values
- profile.last_stat_indexes_srv1 (102.55) 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.public.ad_module 0 0 0.01 etendo.pg_toast.pg_toast_111094 0 0 0.06 etendo.profile.last_stat_tables_srv1 0 0 74.6399999999997 etendo.profile.last_stat_indexes_srv1 0 0 102.55 etendo.profile.last_stat_user_functions_srv1 0 0 2.43999999999999 etendo.profile.tables_list 0 0 0.11 etendo.public.ad_session 0 0 0.73 etendo.profile.last_stat_statements_srv1 0 0 12.9499999999999 etendo.public.c_import_entry 0 0 0.09 etendo.profile.last_stat_io 0 0 0.01 etendo.profile.funcs_list 0 0 0.03 etendo.profile.stmt_list 0 0 0.39 etendo.profile.indexes_list 0 0 0.03 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.last_extension_versions 0 0 0 etendo.pg_catalog.pg_statistic 0 0 16.2199999999999 etendo.profile.last_stat_slru 0 0 0.01 etendo.profile.last_stat_database_srv1 0 0 0.01 etendo.public.ad_process_request 0 0 0.15 etendo.pg_toast.pg_toast_2619 0 0 1.02 etendo.public.m_reservation 0 0 0.76 etendo.profile.sample_stat_user_functions 0 0 0.04 etendo.profile.sample_stat_database 0 0 0.01 etendo.public.c_invoice 0 0 15.53 etendo.pg_toast.pg_toast_118599 0 0 0.68 etendo.profile.sample_stat_slru 0 0 0 etendo.pg_toast.pg_toast_112974 0 0 0.01 etendo.public.ad_pinstance 0 0 0.13 etendo.profile.sample_stat_tables 0 0 1.48 etendo.public.ad_preference 0 0 0.65 etendo.profile.last_stat_tablespaces_srv1 0 0 0.01 etendo.public.m_storage_detail 0 0 0.86 etendo.public.obwpl_pickinglist 0 0 0.07 etendo.profile.sample_stat_indexes 0 0 0.08 etendo.public.ad_ep_instance_para 0 0 0.03 etendo.profile.sample_stat_tables_total 0 0 0.02 etendo.public.ad_sequence 0 0 0 etendo.profile.sample_stat_indexes_total 0 0 0 etendo.public.m_storage_pending 0 0 0.1 etendo.public.m_reservation_stock 0 0 0.25 etendo.public.prpp_json 0 0 0 etendo.profile.sample_statements 0 0 0.69 etendo.profile.sample_stat_io 0 0 0.01 etendo.pg_catalog.pg_type 0 0 0.01 etendo.profile.sample_statements_total 0 0 0 etendo.profile.last_stat_archiver 0 0 0 etendo.profile.sample_stat_user_func_total 0 0 0 etendo.profile.last_stat_cluster 0 0 0 etendo.profile.sample_stat_tablespaces 0 0 0 etendo.profile.last_stat_wal 0 0 0 Total 0 0 232.87 Tuples removed per table
Key values
- profile.last_stat_indexes_srv1 (285416) Main table with removed tuples on database etendo
- 685867 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.profile.last_stat_indexes_srv1 842 1 285,416 67,002,518 51,976,976 0 9,882,554 etendo.profile.last_stat_tables_srv1 844 1 182,216 41,695,557 33,216,142 0 7,906,592 etendo.profile.last_stat_statements_srv1 743 1 66,050 12,908,989 10,246,856 0 2,627,991 etendo.public.c_invoice 50 1 35,620 4,536,998 1,744,682 0 1,083,200 etendo.profile.last_stat_user_functions_srv1 794 1 25,252 6,466,371 4,535,494 0 658,226 etendo.pg_catalog.pg_statistic 414 1 21,143 9,320,704 2,795,852 0 1,911,852 etendo.profile.sample_stat_tables 50 1 10,274 2,112,662 503,426 0 79,300 etendo.public.ad_session 751 1 9,918 6,110,890 1,747,817 0 390,520 etendo.profile.tables_list 772 1 5,672 2,007,017 1,024,752 0 257,076 etendo.public.m_reservation 50 1 4,170 578,030 204,330 0 33,350 etendo.public.m_storage_detail 50 1 3,799 599,751 186,151 0 29,300 etendo.profile.sample_stat_indexes 50 1 3,568 697,706 174,832 0 12,550 etendo.profile.sample_statements 50 1 3,478 678,227 170,422 0 38,300 etendo.profile.sample_stat_user_functions 50 1 2,751 595,799 134,799 0 5,600 etendo.profile.stmt_list 710 1 2,709 1,279,892 473,361 0 309,560 etendo.public.m_reservation_stock 50 1 2,202 636,648 107,898 0 31,500 etendo.public.obwpl_pickinglist 50 1 2,188 139,112 107,212 0 7,600 etendo.pg_toast.pg_toast_2619 51 1 2,049 199,843 102,427 0 44,138 etendo.public.m_storage_pending 50 1 1,933 328,467 94,717 0 13,850 etendo.public.ad_preference 50 1 1,600 178,496 78,110 0 26,400 etendo.public.ad_pinstance 50 1 1,531 298,419 75,019 0 12,350 etendo.public.ad_ep_instance_para 50 1 1,483 72,667 72,667 30 1,470 etendo.public.ad_process_request 53 1 1,377 143,975 67,590 50 21,636 etendo.profile.indexes_list 651 1 1,291 484,273 213,635 0 52,080 etendo.pg_toast.pg_toast_118599 50 1 1,228 119,872 60,172 0 30,150 etendo.profile.funcs_list 710 1 1,105 350,495 184,885 0 57,510 etendo.public.c_import_entry 717 1 1,042 85,742 85,742 141 12,912 etendo.profile.last_stat_io 710 1 752 143,248 131,888 0 12,780 etendo.pg_toast.pg_toast_111094 897 1 484 1,083,273 441,324 0 324,966 etendo.profile.sample_stat_tables_total 50 1 423 96,327 20,727 0 2,550 etendo.profile.last_stat_activity_count_srv1 590 0 384 65,016 65,016 10 1,870 etendo.profile.last_extension_versions 530 1 376 62,984 58,744 0 3,180 etendo.profile.sample_stat_io 50 1 307 69,943 15,043 0 1,550 etendo.public.ad_sequence 50 1 253 20,447 12,397 0 600 etendo.profile.last_stat_slru 290 1 235 27,965 26,515 7 1,213 etendo.public.prpp_json 50 1 190 20,960 9,310 0 950 etendo.profile.sample_stat_database 50 1 188 42,812 9,212 0 1,750 etendo.profile.sample_stat_slru 50 1 188 42,812 9,212 0 650 etendo.profile.sample_stat_indexes_total 50 1 188 42,812 9,212 0 500 etendo.profile.last_stat_database_srv1 170 1 188 16,372 15,692 5 1,435 etendo.pg_toast.pg_toast_112974 50 1 144 7,056 7,056 29 1,421 etendo.public.ad_module 897 1 97 621,284 254,464 0 122,889 etendo.profile.last_stat_tablespaces_srv1 50 1 94 4,706 4,606 0 100 etendo.profile.sample_stat_tablespaces 1 1 94 362 24 0 4 etendo.profile.sample_statements_total 1 1 70 362 24 0 19 etendo.profile.last_stat_archiver 1 1 47 5 4 0 2 etendo.profile.last_stat_cluster 1 1 47 5 4 0 2 etendo.profile.last_stat_wal 1 1 47 5 4 0 2 etendo.pg_catalog.pg_type 1 1 6 2,843 92 0 82 etendo.profile.sample_stat_user_func_total 1 1 0 362 24 0 4 Total 13,293 49 685,867 162,001,081 111,476,560 272 26,016,086 Pages removed per table
Key values
- public.c_import_entry (141) Main table with removed pages on database etendo
- 272 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed etendo.public.c_import_entry 717 1 1042 141 etendo.public.ad_process_request 53 1 1377 50 etendo.public.ad_ep_instance_para 50 1 1483 30 etendo.pg_toast.pg_toast_112974 50 1 144 29 etendo.profile.last_stat_activity_count_srv1 590 0 384 10 etendo.profile.last_stat_slru 290 1 235 7 etendo.profile.last_stat_database_srv1 170 1 188 5 etendo.public.m_reservation 50 1 4170 0 etendo.profile.tables_list 772 1 5672 0 etendo.profile.sample_stat_user_functions 50 1 2751 0 etendo.public.ad_session 751 1 9918 0 etendo.profile.sample_stat_database 50 1 188 0 etendo.pg_catalog.pg_type 1 1 6 0 etendo.public.c_invoice 50 1 35620 0 etendo.profile.last_stat_io 710 1 752 0 etendo.pg_toast.pg_toast_118599 50 1 1228 0 etendo.profile.last_stat_tables_srv1 844 1 182216 0 etendo.pg_toast.pg_toast_2619 51 1 2049 0 etendo.profile.sample_statements_total 1 1 70 0 etendo.profile.sample_stat_slru 50 1 188 0 etendo.profile.last_stat_archiver 1 1 47 0 etendo.profile.funcs_list 710 1 1105 0 etendo.profile.last_extension_versions 530 1 376 0 etendo.public.ad_module 897 1 97 0 etendo.public.ad_pinstance 50 1 1531 0 etendo.profile.sample_stat_tables 50 1 10274 0 etendo.public.ad_preference 50 1 1600 0 etendo.profile.indexes_list 651 1 1291 0 etendo.profile.last_stat_tablespaces_srv1 50 1 94 0 etendo.profile.last_stat_user_functions_srv1 794 1 25252 0 etendo.profile.stmt_list 710 1 2709 0 etendo.public.m_storage_detail 50 1 3799 0 etendo.pg_catalog.pg_statistic 414 1 21143 0 etendo.profile.last_stat_indexes_srv1 842 1 285416 0 etendo.public.obwpl_pickinglist 50 1 2188 0 etendo.profile.sample_stat_indexes 50 1 3568 0 etendo.profile.sample_stat_user_func_total 1 1 0 0 etendo.profile.last_stat_cluster 1 1 47 0 etendo.profile.sample_stat_tables_total 50 1 423 0 etendo.profile.sample_stat_tablespaces 1 1 94 0 etendo.public.ad_sequence 50 1 253 0 etendo.profile.last_stat_statements_srv1 743 1 66050 0 etendo.profile.sample_stat_indexes_total 50 1 188 0 etendo.public.m_storage_pending 50 1 1933 0 etendo.public.m_reservation_stock 50 1 2202 0 etendo.public.prpp_json 50 1 190 0 etendo.pg_toast.pg_toast_111094 897 1 484 0 etendo.profile.last_stat_wal 1 1 47 0 etendo.profile.sample_statements 50 1 3478 0 etendo.profile.sample_stat_io 50 1 307 0 Total 13,293 49 685,867 272 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 17 07 2,164 13 08 155 10 09 272 11 10 426 6 11 724 15 12 781 8 13 840 9 14 901 6 15 902 9 16 961 6 17 960 6 18 1,020 7 19 1,021 6 20 1,085 10 21 1,081 9 22 0 0 - 6.55 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
- 51 Total read queries
- 0 Total write queries
Queries by database
Key values
- etendo Main database
- 51 Requests
- 14m40s (etendo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 36 Requests
User Request type Count Duration postgres Total 15 32s982ms select 15 32s982ms tad Total 36 14m7s select 36 14m7s Duration by user
Key values
- 14m7s (tad) Main time consuming user
User Request type Count Duration postgres Total 15 32s982ms select 15 32s982ms tad Total 36 14m7s select 36 14m7s Queries by host
Key values
- 127.0.0.1 Main host
- 29 Requests
- 11m15s (127.0.0.1)
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 28 Requests
- 11m13s (openbravo)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-17 16:39:26 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 30 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 53s326ms select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('E341B938EE354C90A4A049F069F4DAA9', 'CC865F1ADCDA462CBBEE333F8A738275', 'C55C2211696E4EFC8C40A6AE6ECD4F6F', '983097CA14BD41DD989FD5621F358F63', '87A1B81CC6904CCE93BEAB5C8580A041', '14789B1EDC704F659C26E9ED68001319', '07B486592161449EB173F0A53BCDC503', '6D83F4670D7B42FB9D07E29595DE0A3B', '5B9F9E6C6D0544608D26E063CD35B29C', '518A49B3472F4256B1C430E16B8E3878', '4A51F861FF37436B8D943C8959643C5F', '07A3A3DF63E64D4C9DFC6C7C0BBA1F25', 'FFB1D1BA333E4F229A969866B6C8C4CA', 'EF8455A1230A4B2E8F5E94941915B8A8', 'EC805D277C83422492ACE03FA4D8B344', 'D9BADC73AF8747578D14423F9CE3AEFC', 'D8A553FABFC14929853D067C5D5026A0', 'D0256943A1A94ADC92367F85E1B3098B', 'C99F66E9C8FE4EBE9F685651C8AFF761', 'AAE117B63415497EBE6866874186AE4D', '78AB6EF0E2E1424FBD9C8A4535D6073C', '6FB9EA84D54E4264A4FCFBA27B0CAC58', '6DB4864FB64D40DCAD9CB3B20EA34CB6', '6CDACA9BB90B43EEA4525EE71A715B07', '6A9C8FB9082A46E685B889B438F587BC', '59525207A29946159D962C124902086A', '381292DA14AC41319DF64C42CD44807D', '0F7D1640888341899B1963877BCF82F5', '07E0E689962A41F3B9EF2C5E7C281F26', 'B86ABF14DB384C6F930775E3BDCA0282', '81D3F18EB6984459B3B5EB668D6ED39C', '25CCBB462CF6499C9799F7BB96C6B0CE', 'F6270C337FEF4F5FBC569305DAEB6854', 'F4D7EB873E184313AE8749A532833981', 'DB9BF174C8244345BBCEDE58FDB825AF', 'CB7811A603624202A441841BB43B363D', '96A48F85F69546D483D3B2C1DABE7284', '96160E5CF83C4BA48627B27C4CAD7270', '6F8224B47A4A49BBAE17B3830AA3D36F', '6913A1AB611F4C04932E98A3A3A3CCE0', '4E87203D64BD4F08B272A8CEA55B7130', '341771A95A1B4C15809CD69FE9F131AA', '1FBD80EFB6EA43D5B780C97FD0DB2E26', '070EF5DB307C496C88006C36FF2C3C4E', 'BB1218FBBA624F17AE49C522E736A3E1', 'A9CA82DF289242FF8B3A1B433846946F', '668F8E571183459FAD85DB4C60E1C84A', '64D0841754154470B4C1F47085F05737', '2BEF4068706C406EBE74923F2E3A2100', 'F391EB61C8284C7E8479892EC4ADA3E9');[ Date: 2026-07-17 07:48:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
2 53s57ms select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('897B6A3582C145988EF890564BE9B95C', '5E0968B250D94CB2910FA3B989395828', '5E064FEFC8844ED8AF01EC712E13CDD9', '476D0BE1B6714A4DB7771406E70041AF', '32ADD0EA1F1A4178BA1983960218A6CA', '23244A1DF17B48618F94499D4F22DA10', 'F5FF23666E684188B591FFA859E69BE8', 'DC5344AEC7674782838FABF633E4A028', 'CB600B3C4D7649C9AEEB6B88604B041C', 'C0DDEF758EED4F52BCE0130A887EAD27', 'B577530D1CEA45FA84B4983E7ADBD24F', 'B4C7E923CB4E4B6D993D7AC917E67993', 'B376BDB6928443FCA28B4F734AA47953', 'AC91B399C2974EEBB1E28FDF08F7FF0F', '8FB5B343669A413D9E63BA5E78EFCD70', '7AD5160327044FB98AD727DD1BCB78AB', '6A4311CB1BC14810B78FBD7CBBDD14DE', '678D14E2839E401699E5FD8FDA7ED38F', '61890F68AF5444A3B92157F79D814EF3', '5BA9DAB956FD4099B6CC53AA36E14F0A', '57A75659AD284DE193C849DF001EF79E', '3D625F0195274F1FAB749A4EEEA9570B', 'EE1BFC992E1D46F788DAC4A1FB91505C', 'D6C10436FE9A4104AEEF78A12F3C0694', 'D18F338EA5F346D9877983D53ABF3899', 'C488EECA6A53410CA41CF709FE2B8E6D', 'C3D8E2802DFB4D7586E12EEA20F9C0D5', 'B30F570BC66E4B99BB0C8DE0861ADC52', 'AA606CF7473A40FD82191F6183BBA888', '821CB396490345DF9405533CDD38B2A5', '7165046164F5465C9F4DFC50C45F59CF', '64BB9FE1B0534415B67146291B75C99F', '4253F000BD0A4F86AD50D0A7389254EC', '37EBFCE207A8436AAC0509D7F5AE1676', '31CF58828C2943D38D284D5554B2FD0C', '31C41C9634E645778AF9474A9611282D', '1BFC606BC1044386812B6831AAA05FC5', '0549E1443FFC4A8AB80F47ED23E87709', 'F16B8AFBC15343DB8D79E783F4167948', '93EF3012353B4228AFE7FFE449FED83D', '8105DBD13C0E432EBA97B5D9FEEF0576', '6BFD1A6ABD984C878626F241340193F6', '63C8B6FB476940DDAD1CAD52829DDB57', '19BE974A72B1411287B77983E0482850', 'F769D2B2982A41379C473CC6B6728FA9', 'E63DD98E4B5E4B88992C96E0C3BE4FAD', 'E603984ECA8A46978C85179B5C8B3531', '9962A410E59646DDBE3F5C2F73F13185', '8A73FAEB5206468A98A3098017C145E6', '76216167222E4B0FBB258A812666A693');[ Date: 2026-07-17 07:49:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3 52s525ms select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('F579B1A55A2441168C8F3FE6540018CF', 'DBF552E609444C9DBE2C4097BF6E5B7B', 'D3F480A3019C4EE09738BE4B5240EECC', 'CEAB899637F34F15AEC45E6E69312B1C', 'CDC6C680D63449F39B58E3E709C6AE76', 'C24E466824884AA69E1924567DDADDC5', 'B949932CE16D4671A9A26582348D7043', 'A5B5545CF34143A3890B6D0634841E86', 'A127F87F10EB49E2A64A27EE444B8998', '968EBF4E2EAF4B09BEF9AB2BFB570A55', '6CC946CE146847D19EAB3B154B0CC3AB', '575B5D7054104206B57FD0E15613BF35', '5360A1D40AB545949CB002FB5A7DA19D', '509E23E4DB7D4530B4F77F1ADF31A6F6', '3E18BCF5BD1E47ABA495039D73072303', '23AD62B4E0D6486E8F7DF202C65EDE3A', '18EA3C75A0364389970D62353B068756', '14C11CDC6F71459FB2889943DEF40A20', 'C8242610250F4BEE80B981062E4D269C', 'C6B885B7E55E4AF28460E77AA5B0291D', 'C3ACE2604972469FBFB12DDC9B8FC0ED', 'C27DF24FFC2844DD83C1FD6DB724F645', 'AB6CB8647D60402C8653BF5CEA77CDF1', 'A39D331D845D4BF683E0E9F54159FD2F', '9A1073CCA1E24B4EA496EE4874BEE4B6', '977253F06F7D4B008AED1CF8B926F66B', '7BC892DF2C3A4A10B202B7E3FD926575', '7884E045302B44D99CF9D9E1A285B8E3', '69FA2585EC3548AA8C7308D27BB4CA63', '621A3DB055F64443886855BDF6FE0F8B', '5ED36936A5A643E1861230A64FA0274E', '5B735E91786E48C487F7C05382ADFFCA', '4DA803F5A9484638A2C6D0607A5FDBAB', '4A02A4151D194ABE8D7AE997FF77E8BC', '42C5ED3CDFAD473B9A3DB7F169BD7E1E', '406A8120D09E4F2D929D313D3206AABB', '37A5CF5AFE0848FD965DE0E82475C08D', '19847AA4D4C34B81AD2F3CA824F1B9F4', '15AB26E73E014CD7A7BD16CEB9A9A8BF', 'DB2BD124BF4541868FB37A8A63D2D8BE', 'CB5FB2DF310D41A68A23223A75FBB8DC', 'C4883DA872924A319B0A180973B290C0', '807DA4047FB6440E8A1076BFEA9E3067', '348067BEE15340B2A047D70D8A54D37A', 'FEEB974131804A4F8275B1F4CF5898CF', 'EAB4547B4BF64163BECAF5319ECA6109', 'B0353BC736AE4F9FAE9DE68118F3D072', '9FD301FE0E95400DA3059B3DB549ECCE', '9D4419DF81E844019AA081CF48E4EE87', '8F87E4C023874DD0910695792E2287E8');[ Date: 2026-07-17 07:48:10 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
4 51s326ms select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('CDC6C680D63449F39B58E3E709C6AE76', '968EBF4E2EAF4B09BEF9AB2BFB570A55', 'A5B5545CF34143A3890B6D0634841E86', 'DBF552E609444C9DBE2C4097BF6E5B7B', 'A127F87F10EB49E2A64A27EE444B8998', 'B949932CE16D4671A9A26582348D7043', '23AD62B4E0D6486E8F7DF202C65EDE3A', '6CC946CE146847D19EAB3B154B0CC3AB', '509E23E4DB7D4530B4F77F1ADF31A6F6', '5360A1D40AB545949CB002FB5A7DA19D', '15AB26E73E014CD7A7BD16CEB9A9A8BF', 'C6B885B7E55E4AF28460E77AA5B0291D', '19847AA4D4C34B81AD2F3CA824F1B9F4', '5ED36936A5A643E1861230A64FA0274E', '977253F06F7D4B008AED1CF8B926F66B', 'AB6CB8647D60402C8653BF5CEA77CDF1', '4A02A4151D194ABE8D7AE997FF77E8BC', '9A1073CCA1E24B4EA496EE4874BEE4B6', 'C3ACE2604972469FBFB12DDC9B8FC0ED', '5B735E91786E48C487F7C05382ADFFCA', 'A39D331D845D4BF683E0E9F54159FD2F', 'C4883DA872924A319B0A180973B290C0', 'C27DF24FFC2844DD83C1FD6DB724F645', 'CB5FB2DF310D41A68A23223A75FBB8DC', '37A5CF5AFE0848FD965DE0E82475C08D', 'EAB4547B4BF64163BECAF5319ECA6109', 'DB2BD124BF4541868FB37A8A63D2D8BE', '476D0BE1B6714A4DB7771406E70041AF', 'C0DDEF758EED4F52BCE0130A887EAD27', 'B4C7E923CB4E4B6D993D7AC917E67993', 'CB600B3C4D7649C9AEEB6B88604B041C', '61890F68AF5444A3B92157F79D814EF3', '3D625F0195274F1FAB749A4EEEA9570B', '5BA9DAB956FD4099B6CC53AA36E14F0A', '8FB5B343669A413D9E63BA5E78EFCD70', '6A4311CB1BC14810B78FBD7CBBDD14DE', 'AC91B399C2974EEBB1E28FDF08F7FF0F', 'DC5344AEC7674782838FABF633E4A028', '678D14E2839E401699E5FD8FDA7ED38F', '57A75659AD284DE193C849DF001EF79E', 'B577530D1CEA45FA84B4983E7ADBD24F', 'F5FF23666E684188B591FFA859E69BE8', 'C488EECA6A53410CA41CF709FE2B8E6D', '821CB396490345DF9405533CDD38B2A5', '1BFC606BC1044386812B6831AAA05FC5', '31CF58828C2943D38D284D5554B2FD0C', '4253F000BD0A4F86AD50D0A7389254EC', 'C3D8E2802DFB4D7586E12EEA20F9C0D5', '93EF3012353B4228AFE7FFE449FED83D', '7165046164F5465C9F4DFC50C45F59CF');[ Date: 2026-07-17 07:54:08 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
5 50s330ms select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('406A8120D09E4F2D929D313D3206AABB', '19BE974A72B1411287B77983E0482850', '63C8B6FB476940DDAD1CAD52829DDB57', '807DA4047FB6440E8A1076BFEA9E3067', '348067BEE15340B2A047D70D8A54D37A', '60D0E10AC95744C7AFA1EBF848DCAF87', '6BFD1A6ABD984C878626F241340193F6', '7AD5160327044FB98AD727DD1BCB78AB', '34B8EE7EDE844769862EEBB446106D5B', '2D710FD85E544355BF3A740166C9B148', 'F769D2B2982A41379C473CC6B6728FA9', 'B376BDB6928443FCA28B4F734AA47953', '76216167222E4B0FBB258A812666A693', 'E603984ECA8A46978C85179B5C8B3531', '8A73FAEB5206468A98A3098017C145E6', 'E06AF067941048FD911A21702717E1E5', '5C1CA8BEFA104A39B4B51DE791805436', '42C5ED3CDFAD473B9A3DB7F169BD7E1E', '897B6A3582C145988EF890564BE9B95C', 'E63DD98E4B5E4B88992C96E0C3BE4FAD', '335866934B15459C8B1B866C2190F94D', '1A11ACA5009B46E2AC461779A3764AAE', 'FE64BC1E52E04E718CA1A850261B9473', 'F1345C5B7D6644BB958509E383AFD970', '40214D15CCFE47B9867AE42846E80F6F', '0949C6EEEFEC4371B78DFDA13DE98AEA', 'F16B8AFBC15343DB8D79E783F4167948', 'ABFD7878ABCF42FE8B76BB65613D0C94', '033CBDBB263446DF96E983CF2278D35C', '6D8B8096D15641DB97529BF632334699', 'BEF052DDA6E6461C874281E5D9B6DA1E', 'D83599A0D59B4EB9B2D982A675463028', '857C3C02400F43EEA0657BFF1E993EB4', '40CCEBACED674056A9FF41DFC4F44C81', 'CD55BF02237C40A9A5EBD02C8A3D81A5', 'F75E12F79CA8497AB0651814871EA1E4', '103FFABBE0F3431789806A6768D1CFD8', '7FBFA81DD5B547EF9DE8A0C0AA162B2A', '20102DC9F6364FDD9544FDD6C30E6CF4', 'BA45540E2E1049C2846711F084F62FB5', '946034819FA24017A3DC1CC818929915', '98137996413E4C549A7A11F8A4EEC307', '74D16E6C1C6F4F29ADC312D319365B89', '3CACD31F1AD04C2BBD3E8CB8BF370683', '3F0C4DEB545D49A4A4EBF85E4161A934', '03D2FF6142774860BEDA2160878B654C', '1A554223AB524681BC1F0E0944EAFD7D', '3B30DE63E00C423BBB6EA9B8B7EF582E', '377E0053527242F79E6AA08C11E92DFD', '056D8F4A69C24536A5648002EC1682A2');[ Date: 2026-07-17 07:54:58 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
6 49s717ms select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('E90C63D8CDB84115B4109953C7C0A4D0', 'E098C9AC847041739852D1E6DF0CC249', 'D900EC0965714A8382F1F4EDE813E6A1', 'B2967C5DFEC64B94A233B2B537FB7994', 'AB31339193854E7DBC4B1A3137805D2D', '7CC9EECA111244B6834A2E6B7F7905EF', '7C8C0481079D4389A33DBBF31D0805FE', '7944FE3965BF4625BF734668AFFAE3E7', '57BCBA46E7F94B9389FB6E5F837C7476', '55308FCC5E154A58BBFDB6DDB0F17CA9', '549B2A3C1D1045C6B4F5E27FB781CE53', '53DED10F8E254D1684595980EC4C4A1E', '4211E52363D14C3491F51F4DFCC10DFD', '2FE3778593F74999B2C5E2B66FBD54F5', 'F64A6A82F7FB4AC1B8B3A39E2079F157', 'CEC1F74D2C4C48B99273DC3A6C2BA676', 'CBEAEDEC738F4AF2B5A117E111D542E9', 'BF9B163EC3704DDDA0C64245C2BED760', 'BDF497CAE4DA41D09A575624245143C7', 'AE66571AAE214C81B13DE82A4C109CE9', 'AB831379D3964005B9EF5669A780F1BB', 'AABB001590A643F69E46D88D1BF98995', 'A225F2528E34425993E11E20B59F1913', '926511A8C88F4F75B92F6564268AF2C3', '8C4390FA6BE64D7A8C6AD7E8E319BE43', '7EFFBE0628764AD58B1F25D8421FD0CF', '7C6CD9AD78C34DEBB38D5259D84139EF', '6E924D85CC7B4D85BE868C2AF2A5FBEC', '6E8A3B67657248E5AC905655F0E68B6B', '692433928C76481EA22F66C762A09341', '640A329D23A3493AB99168344144B662', '50F6DE5282CE47158D4D4AA5C0C59416', '2EBD9A62D11347ADB5B4D812E7E702E1', '1AFCB1C0BD1246FB890FA1FCE968305C', '0D562E6E88EC49E5A97D71631B25918E', 'D7B4CBE60FC042A6BCD0375FEA0B14A6', 'C26FC054069244AB8622E0A2FAE24681', '9702B555392547FF80AF0A7CF1463813', '9232BF51128D489F83E107B271E82CD6', '75478FE5AD2F4016ADC6FBE3FFD9351F', '7100AE7261B7492489DBA56F619B6F84', '5F78CC1CABA4418FB0B3D1E26C4769CC', '242D2AC62AB84FC3AB53E04E292C3303', '01018431A7FD477DBDCB8B44883808CA', 'FEA7252645C741C0953D642CA1A656C2', 'E35C436BCED748D6BAB5191DA36756D7', 'E1D36A0DD73E4A4B82C8E5A183659D1E', 'D344DF41A5B544C5887F1024D7C0B2BF', 'CFB49C93DC7649FD96A252423DBF817B', 'C697C29D941E4275A1C596C76AC961E4');[ Date: 2026-07-17 07:49:10 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
7 49s209ms select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('F579B1A55A2441168C8F3FE6540018CF', 'DBF552E609444C9DBE2C4097BF6E5B7B', 'D3F480A3019C4EE09738BE4B5240EECC', 'CEAB899637F34F15AEC45E6E69312B1C', 'CDC6C680D63449F39B58E3E709C6AE76', 'C24E466824884AA69E1924567DDADDC5', 'B949932CE16D4671A9A26582348D7043', 'A5B5545CF34143A3890B6D0634841E86', 'A127F87F10EB49E2A64A27EE444B8998', '968EBF4E2EAF4B09BEF9AB2BFB570A55', '6CC946CE146847D19EAB3B154B0CC3AB', '575B5D7054104206B57FD0E15613BF35', '5360A1D40AB545949CB002FB5A7DA19D', '509E23E4DB7D4530B4F77F1ADF31A6F6', '3E18BCF5BD1E47ABA495039D73072303', '23AD62B4E0D6486E8F7DF202C65EDE3A', '18EA3C75A0364389970D62353B068756', '14C11CDC6F71459FB2889943DEF40A20', 'C8242610250F4BEE80B981062E4D269C', '69FA2585EC3548AA8C7308D27BB4CA63', '621A3DB055F64443886855BDF6FE0F8B', '4DA803F5A9484638A2C6D0607A5FDBAB', '9D4419DF81E844019AA081CF48E4EE87', '8F87E4C023874DD0910695792E2287E8', '5E064FEFC8844ED8AF01EC712E13CDD9', '32ADD0EA1F1A4178BA1983960218A6CA', '23244A1DF17B48618F94499D4F22DA10', 'D6C10436FE9A4104AEEF78A12F3C0694', 'D18F338EA5F346D9877983D53ABF3899', '0549E1443FFC4A8AB80F47ED23E87709', '28AB95BC4ACE4A2DB71FCA56F8F380A7', '76807AC850314491A194024A9464C98A', '2729698BE8E844FBAB5D9E6A20719B0D', '30430214C9FE44FEA9BCCB183CDAFE18', 'E19C6A65EB7340DB919CB962C40DD0EC', '8513258B17F546EEACF7BE8DB46EEBF1', '45449F3A97654E8D836E307B8E307CBA', 'F7E12A3BAACA42E0AA5A8F527EE1C759', '8A64F919A25346C2AD7188ED5D87BAB9', '0B77803C7F6040AB8F47DEDE836D459A', '1BEE9C66E11D423ABF505CD28AD902E9', '93EC682D60EF46BF9C02F483C758873D', '9C0818FCFC4A4FCF82BDDFD80809C924', 'E2B4C32F2BDA494C82357525EFE0CD22', '600F5F238CBA4701B675D9F00AC65EB0', 'DE01D59E42C440A28CC2D1FE4119CFC8', 'A66F78042C9D45D6BE74984D5445844E', '42549FA24BE94AD18C3490535A3A1F55', '9FE82D2942784C929817ED65E023D4FF', '2046DA5587274098B406DA23AB14F269');[ Date: 2026-07-17 07:48:05 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
8 47s343ms select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('897B6A3582C145988EF890564BE9B95C', '5E0968B250D94CB2910FA3B989395828', '5E064FEFC8844ED8AF01EC712E13CDD9', '476D0BE1B6714A4DB7771406E70041AF', '32ADD0EA1F1A4178BA1983960218A6CA', '23244A1DF17B48618F94499D4F22DA10', 'F5FF23666E684188B591FFA859E69BE8', 'DC5344AEC7674782838FABF633E4A028', 'CB600B3C4D7649C9AEEB6B88604B041C', 'C0DDEF758EED4F52BCE0130A887EAD27', 'B577530D1CEA45FA84B4983E7ADBD24F', 'B4C7E923CB4E4B6D993D7AC917E67993', 'B376BDB6928443FCA28B4F734AA47953', 'AC91B399C2974EEBB1E28FDF08F7FF0F', '8FB5B343669A413D9E63BA5E78EFCD70', '7AD5160327044FB98AD727DD1BCB78AB', '6A4311CB1BC14810B78FBD7CBBDD14DE', '678D14E2839E401699E5FD8FDA7ED38F', '61890F68AF5444A3B92157F79D814EF3', '5BA9DAB956FD4099B6CC53AA36E14F0A', '57A75659AD284DE193C849DF001EF79E', '3D625F0195274F1FAB749A4EEEA9570B', 'EE1BFC992E1D46F788DAC4A1FB91505C', 'D6C10436FE9A4104AEEF78A12F3C0694', 'D18F338EA5F346D9877983D53ABF3899', 'C488EECA6A53410CA41CF709FE2B8E6D', 'C3D8E2802DFB4D7586E12EEA20F9C0D5', 'B30F570BC66E4B99BB0C8DE0861ADC52', 'AA606CF7473A40FD82191F6183BBA888', '821CB396490345DF9405533CDD38B2A5', '7165046164F5465C9F4DFC50C45F59CF', '64BB9FE1B0534415B67146291B75C99F', '4253F000BD0A4F86AD50D0A7389254EC', '37EBFCE207A8436AAC0509D7F5AE1676', '31CF58828C2943D38D284D5554B2FD0C', '31C41C9634E645778AF9474A9611282D', '1BFC606BC1044386812B6831AAA05FC5', '0549E1443FFC4A8AB80F47ED23E87709', 'F16B8AFBC15343DB8D79E783F4167948', '93EF3012353B4228AFE7FFE449FED83D', '8105DBD13C0E432EBA97B5D9FEEF0576', '6BFD1A6ABD984C878626F241340193F6', '63C8B6FB476940DDAD1CAD52829DDB57', '19BE974A72B1411287B77983E0482850', 'F769D2B2982A41379C473CC6B6728FA9', 'E63DD98E4B5E4B88992C96E0C3BE4FAD', 'E603984ECA8A46978C85179B5C8B3531', '9962A410E59646DDBE3F5C2F73F13185', '8A73FAEB5206468A98A3098017C145E6', '76216167222E4B0FBB258A812666A693');[ Date: 2026-07-17 07:58:32 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
9 46s303ms select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('E90C63D8CDB84115B4109953C7C0A4D0', 'E098C9AC847041739852D1E6DF0CC249', 'D900EC0965714A8382F1F4EDE813E6A1', 'B2967C5DFEC64B94A233B2B537FB7994', 'AB31339193854E7DBC4B1A3137805D2D', '7CC9EECA111244B6834A2E6B7F7905EF', '7C8C0481079D4389A33DBBF31D0805FE', '7944FE3965BF4625BF734668AFFAE3E7', '57BCBA46E7F94B9389FB6E5F837C7476', '55308FCC5E154A58BBFDB6DDB0F17CA9', '549B2A3C1D1045C6B4F5E27FB781CE53', '53DED10F8E254D1684595980EC4C4A1E', '4211E52363D14C3491F51F4DFCC10DFD', '2FE3778593F74999B2C5E2B66FBD54F5', 'F64A6A82F7FB4AC1B8B3A39E2079F157', 'CEC1F74D2C4C48B99273DC3A6C2BA676', 'CBEAEDEC738F4AF2B5A117E111D542E9', 'BF9B163EC3704DDDA0C64245C2BED760', 'BDF497CAE4DA41D09A575624245143C7', 'AE66571AAE214C81B13DE82A4C109CE9', 'AB831379D3964005B9EF5669A780F1BB', 'AABB001590A643F69E46D88D1BF98995', 'A225F2528E34425993E11E20B59F1913', '926511A8C88F4F75B92F6564268AF2C3', '8C4390FA6BE64D7A8C6AD7E8E319BE43', '7EFFBE0628764AD58B1F25D8421FD0CF', '7C6CD9AD78C34DEBB38D5259D84139EF', '6E924D85CC7B4D85BE868C2AF2A5FBEC', '6E8A3B67657248E5AC905655F0E68B6B', '692433928C76481EA22F66C762A09341', '640A329D23A3493AB99168344144B662', '50F6DE5282CE47158D4D4AA5C0C59416', '2EBD9A62D11347ADB5B4D812E7E702E1', '1AFCB1C0BD1246FB890FA1FCE968305C', '0D562E6E88EC49E5A97D71631B25918E', 'D7B4CBE60FC042A6BCD0375FEA0B14A6', 'C26FC054069244AB8622E0A2FAE24681', '9702B555392547FF80AF0A7CF1463813', '9232BF51128D489F83E107B271E82CD6', '75478FE5AD2F4016ADC6FBE3FFD9351F', '7100AE7261B7492489DBA56F619B6F84', '5F78CC1CABA4418FB0B3D1E26C4769CC', '242D2AC62AB84FC3AB53E04E292C3303', '01018431A7FD477DBDCB8B44883808CA', 'FEA7252645C741C0953D642CA1A656C2', 'E35C436BCED748D6BAB5191DA36756D7', 'E1D36A0DD73E4A4B82C8E5A183659D1E', 'D344DF41A5B544C5887F1024D7C0B2BF', 'CFB49C93DC7649FD96A252423DBF817B', 'C697C29D941E4275A1C596C76AC961E4');[ Date: 2026-07-17 07:58:39 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
10 45s509ms select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('F579B1A55A2441168C8F3FE6540018CF', 'DBF552E609444C9DBE2C4097BF6E5B7B', 'D3F480A3019C4EE09738BE4B5240EECC', 'CEAB899637F34F15AEC45E6E69312B1C', 'CDC6C680D63449F39B58E3E709C6AE76', 'C24E466824884AA69E1924567DDADDC5', 'B949932CE16D4671A9A26582348D7043', 'A5B5545CF34143A3890B6D0634841E86', 'A127F87F10EB49E2A64A27EE444B8998', '968EBF4E2EAF4B09BEF9AB2BFB570A55', '6CC946CE146847D19EAB3B154B0CC3AB', '575B5D7054104206B57FD0E15613BF35', '5360A1D40AB545949CB002FB5A7DA19D', '509E23E4DB7D4530B4F77F1ADF31A6F6', '3E18BCF5BD1E47ABA495039D73072303', '23AD62B4E0D6486E8F7DF202C65EDE3A', '18EA3C75A0364389970D62353B068756', '14C11CDC6F71459FB2889943DEF40A20', 'C8242610250F4BEE80B981062E4D269C', 'C6B885B7E55E4AF28460E77AA5B0291D', 'C3ACE2604972469FBFB12DDC9B8FC0ED', 'C27DF24FFC2844DD83C1FD6DB724F645', 'AB6CB8647D60402C8653BF5CEA77CDF1', 'A39D331D845D4BF683E0E9F54159FD2F', '9A1073CCA1E24B4EA496EE4874BEE4B6', '977253F06F7D4B008AED1CF8B926F66B', '7BC892DF2C3A4A10B202B7E3FD926575', '7884E045302B44D99CF9D9E1A285B8E3', '69FA2585EC3548AA8C7308D27BB4CA63', '621A3DB055F64443886855BDF6FE0F8B', '5ED36936A5A643E1861230A64FA0274E', '5B735E91786E48C487F7C05382ADFFCA', '4DA803F5A9484638A2C6D0607A5FDBAB', '4A02A4151D194ABE8D7AE997FF77E8BC', '42C5ED3CDFAD473B9A3DB7F169BD7E1E', '406A8120D09E4F2D929D313D3206AABB', '37A5CF5AFE0848FD965DE0E82475C08D', '19847AA4D4C34B81AD2F3CA824F1B9F4', '15AB26E73E014CD7A7BD16CEB9A9A8BF', 'DB2BD124BF4541868FB37A8A63D2D8BE', 'CB5FB2DF310D41A68A23223A75FBB8DC', 'C4883DA872924A319B0A180973B290C0', '807DA4047FB6440E8A1076BFEA9E3067', '348067BEE15340B2A047D70D8A54D37A', 'FEEB974131804A4F8275B1F4CF5898CF', 'EAB4547B4BF64163BECAF5319ECA6109', 'B0353BC736AE4F9FAE9DE68118F3D072', '9FD301FE0E95400DA3059B3DB549ECCE', '9D4419DF81E844019AA081CF48E4EE87', '8F87E4C023874DD0910695792E2287E8');[ Date: 2026-07-17 07:57:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
11 45s70ms select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('F579B1A55A2441168C8F3FE6540018CF', 'DBF552E609444C9DBE2C4097BF6E5B7B', 'D3F480A3019C4EE09738BE4B5240EECC', 'CEAB899637F34F15AEC45E6E69312B1C', 'CDC6C680D63449F39B58E3E709C6AE76', 'C24E466824884AA69E1924567DDADDC5', 'B949932CE16D4671A9A26582348D7043', 'A5B5545CF34143A3890B6D0634841E86', 'A127F87F10EB49E2A64A27EE444B8998', '968EBF4E2EAF4B09BEF9AB2BFB570A55', '6CC946CE146847D19EAB3B154B0CC3AB', '575B5D7054104206B57FD0E15613BF35', '5360A1D40AB545949CB002FB5A7DA19D', '509E23E4DB7D4530B4F77F1ADF31A6F6', '3E18BCF5BD1E47ABA495039D73072303', '23AD62B4E0D6486E8F7DF202C65EDE3A', '18EA3C75A0364389970D62353B068756', '14C11CDC6F71459FB2889943DEF40A20', 'C8242610250F4BEE80B981062E4D269C', '69FA2585EC3548AA8C7308D27BB4CA63', '621A3DB055F64443886855BDF6FE0F8B', '4DA803F5A9484638A2C6D0607A5FDBAB', '9D4419DF81E844019AA081CF48E4EE87', '8F87E4C023874DD0910695792E2287E8', '5E064FEFC8844ED8AF01EC712E13CDD9', '32ADD0EA1F1A4178BA1983960218A6CA', '23244A1DF17B48618F94499D4F22DA10', 'D6C10436FE9A4104AEEF78A12F3C0694', 'D18F338EA5F346D9877983D53ABF3899', '0549E1443FFC4A8AB80F47ED23E87709', '28AB95BC4ACE4A2DB71FCA56F8F380A7', '76807AC850314491A194024A9464C98A', '2729698BE8E844FBAB5D9E6A20719B0D', '30430214C9FE44FEA9BCCB183CDAFE18', 'E19C6A65EB7340DB919CB962C40DD0EC', '8513258B17F546EEACF7BE8DB46EEBF1', '45449F3A97654E8D836E307B8E307CBA', 'F7E12A3BAACA42E0AA5A8F527EE1C759', '8A64F919A25346C2AD7188ED5D87BAB9', '0B77803C7F6040AB8F47DEDE836D459A', '1BEE9C66E11D423ABF505CD28AD902E9', '93EC682D60EF46BF9C02F483C758873D', '9C0818FCFC4A4FCF82BDDFD80809C924', 'E2B4C32F2BDA494C82357525EFE0CD22', '600F5F238CBA4701B675D9F00AC65EB0', 'DE01D59E42C440A28CC2D1FE4119CFC8', 'A66F78042C9D45D6BE74984D5445844E', '42549FA24BE94AD18C3490535A3A1F55', '9FE82D2942784C929817ED65E023D4FF', '2046DA5587274098B406DA23AB14F269');[ Date: 2026-07-17 07:54:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
12 44s235ms select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('E341B938EE354C90A4A049F069F4DAA9', 'CC865F1ADCDA462CBBEE333F8A738275', 'C55C2211696E4EFC8C40A6AE6ECD4F6F', '983097CA14BD41DD989FD5621F358F63', '87A1B81CC6904CCE93BEAB5C8580A041', '14789B1EDC704F659C26E9ED68001319', '07B486592161449EB173F0A53BCDC503', '6D83F4670D7B42FB9D07E29595DE0A3B', '5B9F9E6C6D0544608D26E063CD35B29C', '518A49B3472F4256B1C430E16B8E3878', '4A51F861FF37436B8D943C8959643C5F', '07A3A3DF63E64D4C9DFC6C7C0BBA1F25', 'FFB1D1BA333E4F229A969866B6C8C4CA', 'EF8455A1230A4B2E8F5E94941915B8A8', 'EC805D277C83422492ACE03FA4D8B344', 'D9BADC73AF8747578D14423F9CE3AEFC', 'D8A553FABFC14929853D067C5D5026A0', 'D0256943A1A94ADC92367F85E1B3098B', 'C99F66E9C8FE4EBE9F685651C8AFF761', 'AAE117B63415497EBE6866874186AE4D', '78AB6EF0E2E1424FBD9C8A4535D6073C', '6FB9EA84D54E4264A4FCFBA27B0CAC58', '6DB4864FB64D40DCAD9CB3B20EA34CB6', '6CDACA9BB90B43EEA4525EE71A715B07', '6A9C8FB9082A46E685B889B438F587BC', '59525207A29946159D962C124902086A', '381292DA14AC41319DF64C42CD44807D', '0F7D1640888341899B1963877BCF82F5', '07E0E689962A41F3B9EF2C5E7C281F26', 'B86ABF14DB384C6F930775E3BDCA0282', '81D3F18EB6984459B3B5EB668D6ED39C', '25CCBB462CF6499C9799F7BB96C6B0CE', 'F6270C337FEF4F5FBC569305DAEB6854', 'F4D7EB873E184313AE8749A532833981', 'DB9BF174C8244345BBCEDE58FDB825AF', 'CB7811A603624202A441841BB43B363D', '96A48F85F69546D483D3B2C1DABE7284', '96160E5CF83C4BA48627B27C4CAD7270', '6F8224B47A4A49BBAE17B3830AA3D36F', '6913A1AB611F4C04932E98A3A3A3CCE0', '4E87203D64BD4F08B272A8CEA55B7130', '341771A95A1B4C15809CD69FE9F131AA', '1FBD80EFB6EA43D5B780C97FD0DB2E26', '070EF5DB307C496C88006C36FF2C3C4E', 'BB1218FBBA624F17AE49C522E736A3E1', 'A9CA82DF289242FF8B3A1B433846946F', '668F8E571183459FAD85DB4C60E1C84A', '64D0841754154470B4C1F47085F05737', '2BEF4068706C406EBE74923F2E3A2100', 'F391EB61C8284C7E8479892EC4ADA3E9');[ Date: 2026-07-17 07:57:53 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
13 26s969ms select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";[ Date: 2026-07-17 14:14:14 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
14 25s139ms select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";[ Date: 2026-07-17 15:11:55 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
15 25s115ms select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";[ Date: 2026-07-17 12:11:41 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
16 24s320ms select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";[ Date: 2026-07-17 19:07:36 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
17 24s251ms select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";[ Date: 2026-07-17 17:14:13 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
18 23s968ms select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('6C3B8CE12B5D432F80E65C48EB94D162', '1B5CF6326A364A9F89CC18F8B42E275F', '1B8186A8EB5C463B9DACB1A941C83BA2', 'ED109A57867847D3BE0B4A55C6F12B14', '309FE24898E94603BF748AA6A3BFE7DC', '8DEADCF8B8D1422C9FDBE0EE0401C92C', '366264D839D44A7DA803685F09F1157F', 'CDB1B70993924D6BB15CE992DFB9367C', '1CEE69E0F97B4B0C945D429B09F8BEC0', 'BEA32E59D7B0485CB39FB0F256800176', 'BFDD5DA8E6A449EB958BEF49E582B6B9', '7CE6672EE9824A9FA157A5A823D3643B', 'E0A6508566714F22910B10CED3D27C45', 'DF1A4329AB254C559F1293E9264B82D6', '665F0984BF53461B8F2E334B0C9F1F9B', 'D0FD6921BA7A4FB7872D00BC0EDD5F71', '04F5A928C3944243BB9E513EAA1BE26F', '7CA3C52C478A455098DB1A2314DA5948', 'EE4B7CD720B44D16828B875BA547FAF6', '64568FE3A5974130B49CACECF366C809', '5C79EDF4DD684F37B6801C8450310B9A', '88CD47EB8A764108BCA273892E7A12DB', 'F6F40EC824534E95819FE326FE2F41AB', '2440B798E433489B85F427A4B94F295B', '0686AD08459640DDBD0CA7620D1D1105', '3486D15D1A63440CA439F5D44318B66F', '58FD538EEA584468851AEE1C7988C3B8', 'C0346DB3137C45E38B6314650062BA79', 'CEE34753949E468F9710EE3CA37B1AC3', 'B15A5E0AB81D4198934E988D3C3AFCF2', '87D556778BE945A5963B84B93EB7B651', '4B46C256900C49CCA4BAA8AB51B01D67', '6BB8C8A0C01E4AC7885402DD4560047B', '5D0D816EFBEB4EF0B97C530C8FD691A8', 'A0046B3E7A694A4B9BA8E5BBEB3E9451', 'DF223D2F9F8240C481CC0441568E0E16', '6D3F60EF686742B7B51836EC8AE19EBB', 'F7DD5AF821FB421593230419DB5DE687', 'A0E192F93F154BDE8DADC828C318BE38', '1DBB5BBECC2443069A14584F2E48F4F8', '06A46D839DE94A6D862D620618F2A6A4', 'B61A2329BC204C7FA11B7E468ABE3B0D', '723E5BCD1E544DE0A21B56C28F9DEC59', '8B8A7D3F4E0B4CCD8EB4A2E75F902E81', 'A1641D5D0960447DB1353ECA6B1E8C9B', '5AA1746F669F4EA396A6942B71EAF382', '135E64EE723F44E59DDEDA40451900B9', '3E28EC15A5324B6FAD78CEE3656BEE77', '82BD89C5C8B549899F295B1B69EA5638', 'A9D4B981CF9446A8A32B9B0CCB313473');[ Date: 2026-07-17 07:48:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
19 23s952ms select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";[ Date: 2026-07-17 18:09:53 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
20 22s296ms select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";[ Date: 2026-07-17 13:13:46 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 10m58s 18 4s869ms 53s326ms 36s590ms select shipmentin0_.m_inout_id as m_inout_1_521_0_, shipmentin0_.ad_client_id as ad_clien2_521_0_, shipmentin0_.ad_org_id as ad_org_i3_521_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula34_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 17 07 18 10m58s 36s590ms [ User: tad - Total duration: 10m58s - Times executed: 18 ]
[ Application: openbravo - Total duration: 10m58s - Times executed: 18 ]
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('E341B938EE354C90A4A049F069F4DAA9', 'CC865F1ADCDA462CBBEE333F8A738275', 'C55C2211696E4EFC8C40A6AE6ECD4F6F', '983097CA14BD41DD989FD5621F358F63', '87A1B81CC6904CCE93BEAB5C8580A041', '14789B1EDC704F659C26E9ED68001319', '07B486592161449EB173F0A53BCDC503', '6D83F4670D7B42FB9D07E29595DE0A3B', '5B9F9E6C6D0544608D26E063CD35B29C', '518A49B3472F4256B1C430E16B8E3878', '4A51F861FF37436B8D943C8959643C5F', '07A3A3DF63E64D4C9DFC6C7C0BBA1F25', 'FFB1D1BA333E4F229A969866B6C8C4CA', 'EF8455A1230A4B2E8F5E94941915B8A8', 'EC805D277C83422492ACE03FA4D8B344', 'D9BADC73AF8747578D14423F9CE3AEFC', 'D8A553FABFC14929853D067C5D5026A0', 'D0256943A1A94ADC92367F85E1B3098B', 'C99F66E9C8FE4EBE9F685651C8AFF761', 'AAE117B63415497EBE6866874186AE4D', '78AB6EF0E2E1424FBD9C8A4535D6073C', '6FB9EA84D54E4264A4FCFBA27B0CAC58', '6DB4864FB64D40DCAD9CB3B20EA34CB6', '6CDACA9BB90B43EEA4525EE71A715B07', '6A9C8FB9082A46E685B889B438F587BC', '59525207A29946159D962C124902086A', '381292DA14AC41319DF64C42CD44807D', '0F7D1640888341899B1963877BCF82F5', '07E0E689962A41F3B9EF2C5E7C281F26', 'B86ABF14DB384C6F930775E3BDCA0282', '81D3F18EB6984459B3B5EB668D6ED39C', '25CCBB462CF6499C9799F7BB96C6B0CE', 'F6270C337FEF4F5FBC569305DAEB6854', 'F4D7EB873E184313AE8749A532833981', 'DB9BF174C8244345BBCEDE58FDB825AF', 'CB7811A603624202A441841BB43B363D', '96A48F85F69546D483D3B2C1DABE7284', '96160E5CF83C4BA48627B27C4CAD7270', '6F8224B47A4A49BBAE17B3830AA3D36F', '6913A1AB611F4C04932E98A3A3A3CCE0', '4E87203D64BD4F08B272A8CEA55B7130', '341771A95A1B4C15809CD69FE9F131AA', '1FBD80EFB6EA43D5B780C97FD0DB2E26', '070EF5DB307C496C88006C36FF2C3C4E', 'BB1218FBBA624F17AE49C522E736A3E1', 'A9CA82DF289242FF8B3A1B433846946F', '668F8E571183459FAD85DB4C60E1C84A', '64D0841754154470B4C1F47085F05737', '2BEF4068706C406EBE74923F2E3A2100', 'F391EB61C8284C7E8479892EC4ADA3E9');
Date: 2026-07-17 07:48:20 Duration: 53s326ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('897B6A3582C145988EF890564BE9B95C', '5E0968B250D94CB2910FA3B989395828', '5E064FEFC8844ED8AF01EC712E13CDD9', '476D0BE1B6714A4DB7771406E70041AF', '32ADD0EA1F1A4178BA1983960218A6CA', '23244A1DF17B48618F94499D4F22DA10', 'F5FF23666E684188B591FFA859E69BE8', 'DC5344AEC7674782838FABF633E4A028', 'CB600B3C4D7649C9AEEB6B88604B041C', 'C0DDEF758EED4F52BCE0130A887EAD27', 'B577530D1CEA45FA84B4983E7ADBD24F', 'B4C7E923CB4E4B6D993D7AC917E67993', 'B376BDB6928443FCA28B4F734AA47953', 'AC91B399C2974EEBB1E28FDF08F7FF0F', '8FB5B343669A413D9E63BA5E78EFCD70', '7AD5160327044FB98AD727DD1BCB78AB', '6A4311CB1BC14810B78FBD7CBBDD14DE', '678D14E2839E401699E5FD8FDA7ED38F', '61890F68AF5444A3B92157F79D814EF3', '5BA9DAB956FD4099B6CC53AA36E14F0A', '57A75659AD284DE193C849DF001EF79E', '3D625F0195274F1FAB749A4EEEA9570B', 'EE1BFC992E1D46F788DAC4A1FB91505C', 'D6C10436FE9A4104AEEF78A12F3C0694', 'D18F338EA5F346D9877983D53ABF3899', 'C488EECA6A53410CA41CF709FE2B8E6D', 'C3D8E2802DFB4D7586E12EEA20F9C0D5', 'B30F570BC66E4B99BB0C8DE0861ADC52', 'AA606CF7473A40FD82191F6183BBA888', '821CB396490345DF9405533CDD38B2A5', '7165046164F5465C9F4DFC50C45F59CF', '64BB9FE1B0534415B67146291B75C99F', '4253F000BD0A4F86AD50D0A7389254EC', '37EBFCE207A8436AAC0509D7F5AE1676', '31CF58828C2943D38D284D5554B2FD0C', '31C41C9634E645778AF9474A9611282D', '1BFC606BC1044386812B6831AAA05FC5', '0549E1443FFC4A8AB80F47ED23E87709', 'F16B8AFBC15343DB8D79E783F4167948', '93EF3012353B4228AFE7FFE449FED83D', '8105DBD13C0E432EBA97B5D9FEEF0576', '6BFD1A6ABD984C878626F241340193F6', '63C8B6FB476940DDAD1CAD52829DDB57', '19BE974A72B1411287B77983E0482850', 'F769D2B2982A41379C473CC6B6728FA9', 'E63DD98E4B5E4B88992C96E0C3BE4FAD', 'E603984ECA8A46978C85179B5C8B3531', '9962A410E59646DDBE3F5C2F73F13185', '8A73FAEB5206468A98A3098017C145E6', '76216167222E4B0FBB258A812666A693');
Date: 2026-07-17 07:49:03 Duration: 53s57ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('F579B1A55A2441168C8F3FE6540018CF', 'DBF552E609444C9DBE2C4097BF6E5B7B', 'D3F480A3019C4EE09738BE4B5240EECC', 'CEAB899637F34F15AEC45E6E69312B1C', 'CDC6C680D63449F39B58E3E709C6AE76', 'C24E466824884AA69E1924567DDADDC5', 'B949932CE16D4671A9A26582348D7043', 'A5B5545CF34143A3890B6D0634841E86', 'A127F87F10EB49E2A64A27EE444B8998', '968EBF4E2EAF4B09BEF9AB2BFB570A55', '6CC946CE146847D19EAB3B154B0CC3AB', '575B5D7054104206B57FD0E15613BF35', '5360A1D40AB545949CB002FB5A7DA19D', '509E23E4DB7D4530B4F77F1ADF31A6F6', '3E18BCF5BD1E47ABA495039D73072303', '23AD62B4E0D6486E8F7DF202C65EDE3A', '18EA3C75A0364389970D62353B068756', '14C11CDC6F71459FB2889943DEF40A20', 'C8242610250F4BEE80B981062E4D269C', 'C6B885B7E55E4AF28460E77AA5B0291D', 'C3ACE2604972469FBFB12DDC9B8FC0ED', 'C27DF24FFC2844DD83C1FD6DB724F645', 'AB6CB8647D60402C8653BF5CEA77CDF1', 'A39D331D845D4BF683E0E9F54159FD2F', '9A1073CCA1E24B4EA496EE4874BEE4B6', '977253F06F7D4B008AED1CF8B926F66B', '7BC892DF2C3A4A10B202B7E3FD926575', '7884E045302B44D99CF9D9E1A285B8E3', '69FA2585EC3548AA8C7308D27BB4CA63', '621A3DB055F64443886855BDF6FE0F8B', '5ED36936A5A643E1861230A64FA0274E', '5B735E91786E48C487F7C05382ADFFCA', '4DA803F5A9484638A2C6D0607A5FDBAB', '4A02A4151D194ABE8D7AE997FF77E8BC', '42C5ED3CDFAD473B9A3DB7F169BD7E1E', '406A8120D09E4F2D929D313D3206AABB', '37A5CF5AFE0848FD965DE0E82475C08D', '19847AA4D4C34B81AD2F3CA824F1B9F4', '15AB26E73E014CD7A7BD16CEB9A9A8BF', 'DB2BD124BF4541868FB37A8A63D2D8BE', 'CB5FB2DF310D41A68A23223A75FBB8DC', 'C4883DA872924A319B0A180973B290C0', '807DA4047FB6440E8A1076BFEA9E3067', '348067BEE15340B2A047D70D8A54D37A', 'FEEB974131804A4F8275B1F4CF5898CF', 'EAB4547B4BF64163BECAF5319ECA6109', 'B0353BC736AE4F9FAE9DE68118F3D072', '9FD301FE0E95400DA3059B3DB549ECCE', '9D4419DF81E844019AA081CF48E4EE87', '8F87E4C023874DD0910695792E2287E8');
Date: 2026-07-17 07:48:10 Duration: 52s525ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 2m52s 7 22s296ms 26s969ms 24s578ms select "_"."c_invoiceline_id" AS "c_invoiceline_id", "_"."c_invoice_id" AS "c_invoice_id", "_"."ad_org_id" AS "ad_org_id", "_"."isactive" AS "isactive", "_"."issotrx" AS "issotrx", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."c_currency_id" AS "c_currency_id", "_"."m_product_id" AS "m_product_id", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."m_product_category_id" AS "m_product_category_id", "_"."line" AS "line", "_"."Data Factura" AS "Data Factura", "_"."Descripció" AS "Descripció", "_"."Quantitat Factura" AS "Quantitat Factura", "_"."Preu llista" AS "Preu llista", "_"."Preu Actual" AS "Preu Actual", "_"."Preu Límit" AS "Preu Límit", "_"."Import Línia" AS "Import Línia", "_"."Descompte" AS "Descompte", "_"."gross_unit_price" AS "gross_unit_price", "_"."grosspricelist" AS "grosspricelist", "_"."Cost" AS "Cost", extract(hour from "_"."created") AS "created", "_"."Venedor" AS "Model de Negoci", case when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? else ? end AS "Agrupacio Model Negoci" from ( select ol.c_invoiceline_id, ol.c_invoice_id, ol.ad_org_id, ol.isactive, o.issotrx, o.c_bpartner_id, o.c_currency_id, ol.m_product_id, null m_warehouse_id, p.m_product_category_id, ol.line, o.dateinvoiced AS "Data Factura", ol.description AS "Descripció", ol.qtyinvoiced AS "Quantitat Factura", round(ol.pricelist, ?) AS "Preu llista", round(ol.priceactual, ?) AS "Preu Actual", round(ol.pricelimit, ?) AS "Preu Límit", round(ol.linenetamt, ?) AS "Import Línia", ? AS "Descompte", ol.gross_unit_price, ol.grosspricelist, coalesce(m_get_cost (ol.m_product_id, o.dateinvoiced::timestamp, ?, ol.ad_org_id, ol.ad_client_id, null, ?, ?) * ol.qtyinvoiced, ?) AS "Cost", ol.created, us.name AS "Venedor" from c_invoiceline ol left join c_invoice o on o.c_invoice_id = ol.c_invoice_id left join m_product p on p.m_product_id = ol.m_product_id left join ad_user us on us.ad_user_id = coalesce(ol.em_ins_salesrep_id, o.salesrep_id) where ? = ? and o.issotrx = ? and o.c_doctype_id <> ?) "_";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 17 12 1 25s115ms 25s115ms 13 1 22s296ms 22s296ms 14 1 26s969ms 26s969ms 15 1 25s139ms 25s139ms 17 1 24s251ms 24s251ms 18 1 23s952ms 23s952ms 19 1 24s320ms 24s320ms [ User: tad - Total duration: 2m52s - Times executed: 7 ]
[ Application: Mashup Engine - Total duration: 2m52s - Times executed: 7 ]
-
select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";
Date: 2026-07-17 14:14:14 Duration: 26s969ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
-
select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";
Date: 2026-07-17 15:11:55 Duration: 25s139ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
-
select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";
Date: 2026-07-17 12:11:41 Duration: 25s115ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
3 32s982ms 15 2s34ms 2s567ms 2s198ms select profile.take_sample ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 17 07 1 2s384ms 2s384ms 08 1 2s253ms 2s253ms 09 1 2s567ms 2s567ms 10 1 2s129ms 2s129ms 11 1 2s231ms 2s231ms 12 1 2s200ms 2s200ms 13 1 2s265ms 2s265ms 14 1 2s34ms 2s34ms 15 1 2s129ms 2s129ms 16 1 2s92ms 2s92ms 17 1 2s51ms 2s51ms 18 1 2s38ms 2s38ms 19 1 2s246ms 2s246ms 20 1 2s136ms 2s136ms 21 1 2s223ms 2s223ms [ User: postgres - Total duration: 32s982ms - Times executed: 15 ]
[ Application: psql - Total duration: 32s982ms - Times executed: 15 ]
-
SELECT profile.take_sample ();
Date: 2026-07-17 09:00:04 Duration: 2s567ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-17 07:00:04 Duration: 2s384ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-17 13:00:03 Duration: 2s265ms Database: etendo User: postgres Remote: [local] Application: psql
4 10s755ms 6 1s265ms 3s756ms 1s792ms select orderline0_.m_product_id as col_0_0_, product1_.name as col_1_0_, sum(orderline0_.qtyordered) as col_2_0_, uom3_.name as col_3_0_, product1_.c_uom_id as col_4_0_ from c_orderline orderline0_ cross join m_product product1_ cross join c_uom uom3_ cross join c_order order5_ cross join m_product product7_ where orderline0_.m_product_id = product1_.m_product_id and product1_.c_uom_id = uom3_.c_uom_id and orderline0_.c_order_id = order5_.c_order_id and orderline0_.m_product_id = product7_.m_product_id and order5_.docstatus = ? and order5_.issotrx = ? and ? = ? and orderline0_.ad_client_id = ? and (product7_.name like ?) and (orderline0_.ad_org_id in (...)) group by product1_.name, uom3_.name, orderline0_.m_product_id, product1_.c_uom_id order by sum(orderline0_.qtyordered) desc limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 17 07 4 8s218ms 2s54ms 08 1 1s271ms 1s271ms 11 1 1s265ms 1s265ms [ User: tad - Total duration: 10s755ms - Times executed: 6 ]
[ Application: openbravo - Total duration: 10s755ms - Times executed: 6 ]
-
select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = '3C5B81C4F43246A88CB0D6064A5E0530' and (product7_.Name like '%') and (orderline0_.AD_Org_ID in ('0', '9F4FFFC6F7674F6F917C736776A79EFD')) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit '10';
Date: 2026-07-17 07:52:52 Duration: 3s756ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = '3C5B81C4F43246A88CB0D6064A5E0530' and (product7_.Name like '%') and (orderline0_.AD_Org_ID in ('0', '9F4FFFC6F7674F6F917C736776A79EFD')) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit '10';
Date: 2026-07-17 07:38:14 Duration: 1s812ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = '3C5B81C4F43246A88CB0D6064A5E0530' and (product7_.Name like '%') and (orderline0_.AD_Org_ID in ('0', '9F4FFFC6F7674F6F917C736776A79EFD')) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit '10';
Date: 2026-07-17 07:48:30 Duration: 1s364ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
5 2s314ms 2 1s7ms 1s306ms 1s157ms select a.id, ev.value as account_id, coalesce(ev_trl.name, ev.name) as name, a.initialamt as saldo_inicial, a.amtacctcr, a.amtacctdr, a.initialamt + a.amtacctdr - a.amtacctcr as saldo_final, a.groupbyid, coalesce( case ? when ? then ( select bp.name from c_bpartner bp where bp.c_bpartner_id = a.groupbyid) when ? then ( select to_char(mp.value) || ? || coalesce(mp_trl.name, mp.name) from m_product mp left join m_product_trl mp_trl on mp_trl.m_product_id = mp.m_product_id and mp_trl.ad_language = ? where mp.m_product_id = a.groupbyid) when ? then ( select to_char(pj.value) || ? || pj.name from c_project pj where pj.c_project_id = a.groupbyid) else ? end, ?) as groupbyname from ( select sum( case when (dateacct < to_date(?) or (dateacct = to_date(?) and f.factaccttype = ?)) then f.amtacctdr - f.amtacctcr else ? end) as initialamt, sum( case when (dateacct >= to_date(?) and f.factaccttype not in (...)) or (dateacct = to_date(?) and f.factaccttype = ?) then f.amtacctdr else ? end) as amtacctdr, sum( case when (dateacct >= to_date(?) and f.factaccttype not in (...)) or (dateacct = to_date(?) and f.factaccttype = ?) then f.amtacctcr else ? end) as amtacctcr, f.account_id as id, to_char(?) as groupbyid from fact_acct f where f.ad_org_id in (...) and f.ad_client_id in (...) and f.ad_org_id in (...) and dateacct < to_date(?) and ? = ? and f.c_acctschema_id = ? and f.isactive = ? group by f.account_id) a left join c_elementvalue ev on a.id = ev.c_elementvalue_id left join c_elementvalue_trl ev_trl on ev.c_elementvalue_id = ev_trl.c_elementvalue_id and ev_trl.ad_language = ? where ev.elementlevel = ? and ? = ? and (a.initialamt <> ? or a.amtacctcr <> ? or a.amtacctdr <> ?) order by ev.value, ev.name, id, groupbyname;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 17 08 2 2s314ms 1s157ms [ User: tad - Total duration: 2s314ms - Times executed: 2 ]
[ Application: openbravo - Total duration: 2s314ms - Times executed: 2 ]
-
select a.id, ev.value as account_id, COALESCE(ev_trl.name, ev.name) as name, a.initialamt as SALDO_INICIAL, a.amtacctcr, a.amtacctdr, A.INITIALAMT + A.AMTACCTDR - A.AMTACCTCR AS SALDO_FINAL, a.groupbyid, COALESCE( CASE '' WHEN 'C_BPARTNER' THEN ( SELECT bp.name FROM c_bpartner bp WHERE bp.c_bpartner_id = a.groupbyid) WHEN 'M_PRODUCT' THEN ( SELECT TO_CHAR(mp.value) || ' - ' || COALESCE(mp_trl.name, mp.name) FROM m_product mp LEFT JOIN m_product_trl mp_trl ON mp_trl.m_product_id = mp.m_product_id AND mp_trl.ad_language = 'es_ES' WHERE mp.m_product_id = a.groupbyid) WHEN 'C_PROJECT' THEN ( SELECT TO_CHAR(pj.value) || ' - ' || pj.name FROM c_project pj WHERE pj.c_project_id = a.groupbyid) ELSE '' END , '') AS groupbyname from ( SELECT sum( case when (DATEACCT < TO_DATE('01-01-2026') or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = 'O')) then F.AMTACCTDR - F.AMTACCTCR else 0 end) as initialamt, sum( case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in ('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTDR else 0 end) as AMTACCTDR, sum( case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in ('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTCR else 0 end) as AMTACCTCR, F.ACCOUNT_ID AS ID, to_char('') AS groupbyid FROM FACT_ACCT F WHERE F.AD_ORG_ID IN ('9F4FFFC6F7674F6F917C736776A79EFD') AND F.AD_CLIENT_ID IN ('0', '3C5B81C4F43246A88CB0D6064A5E0530') AND F.AD_ORG_ID IN ('9F4FFFC6F7674F6F917C736776A79EFD') AND DATEACCT < TO_DATE('01-07-2026') AND 1 = 1 AND F.C_ACCTSCHEMA_ID = '96951D41F113403591D35C71C35D899C' AND F.ISACTIVE = 'Y' group by F.ACCOUNT_ID) a LEFT JOIN c_elementvalue ev ON a.id = ev.c_elementvalue_id LEFT JOIN c_elementvalue_trl ev_trl ON ev.c_elementvalue_id = ev_trl.c_elementvalue_id AND ev_trl.ad_language = 'es_ES' WHERE ev.elementlevel = 'S' AND 2 = 2 and (a.initialamt <> 0 or a.amtacctcr <> 0 or a.amtacctdr <> 0) order by ev.value, ev.name, id, groupbyname;
Date: 2026-07-17 08:07:42 Duration: 1s306ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select a.id, ev.value as account_id, COALESCE(ev_trl.name, ev.name) as name, a.initialamt as SALDO_INICIAL, a.amtacctcr, a.amtacctdr, A.INITIALAMT + A.AMTACCTDR - A.AMTACCTCR AS SALDO_FINAL, a.groupbyid, COALESCE( CASE '' WHEN 'C_BPARTNER' THEN ( SELECT bp.name FROM c_bpartner bp WHERE bp.c_bpartner_id = a.groupbyid) WHEN 'M_PRODUCT' THEN ( SELECT TO_CHAR(mp.value) || ' - ' || COALESCE(mp_trl.name, mp.name) FROM m_product mp LEFT JOIN m_product_trl mp_trl ON mp_trl.m_product_id = mp.m_product_id AND mp_trl.ad_language = 'es_ES' WHERE mp.m_product_id = a.groupbyid) WHEN 'C_PROJECT' THEN ( SELECT TO_CHAR(pj.value) || ' - ' || pj.name FROM c_project pj WHERE pj.c_project_id = a.groupbyid) ELSE '' END , '') AS groupbyname from ( SELECT sum( case when (DATEACCT < TO_DATE('01-01-2026') or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = 'O')) then F.AMTACCTDR - F.AMTACCTCR else 0 end) as initialamt, sum( case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in ('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTDR else 0 end) as AMTACCTDR, sum( case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in ('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTCR else 0 end) as AMTACCTCR, F.ACCOUNT_ID AS ID, to_char('') AS groupbyid FROM FACT_ACCT F WHERE F.AD_ORG_ID IN ('9F4FFFC6F7674F6F917C736776A79EFD') AND F.AD_CLIENT_ID IN ('0', '3C5B81C4F43246A88CB0D6064A5E0530') AND F.AD_ORG_ID IN ('9F4FFFC6F7674F6F917C736776A79EFD') AND DATEACCT < TO_DATE('18-07-2026') AND 1 = 1 AND F.C_ACCTSCHEMA_ID = '96951D41F113403591D35C71C35D899C' AND F.ISACTIVE = 'Y' group by F.ACCOUNT_ID) a LEFT JOIN c_elementvalue ev ON a.id = ev.c_elementvalue_id LEFT JOIN c_elementvalue_trl ev_trl ON ev.c_elementvalue_id = ev_trl.c_elementvalue_id AND ev_trl.ad_language = 'es_ES' WHERE ev.elementlevel = 'S' AND 2 = 2 and (a.initialamt <> 0 or a.amtacctcr <> 0 or a.amtacctdr <> 0) order by ev.value, ev.name, id, groupbyname;
Date: 2026-07-17 08:16:11 Duration: 1s7ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
6 2s124ms 2 1s 1s123ms 1s62ms select shipmentin0_.m_inout_id as m_inout_1_521_0_, shipmentin0_.ad_client_id as ad_clien2_521_0_, shipmentin0_.ad_org_id as ad_org_i3_521_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula34_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 17 07 2 2s124ms 1s62ms [ User: tad - Total duration: 2s124ms - Times executed: 2 ]
[ Application: openbravo - Total duration: 2s124ms - Times executed: 2 ]
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '34B8EE7EDE844769862EEBB446106D5B';
Date: 2026-07-17 07:49:04 Duration: 1s123ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = 'A8A567AE0D2447B894B2C92C22D29335';
Date: 2026-07-17 07:58:40 Duration: 1s Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = $1;
Date: 2026-07-17 07:49:04 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
7 1s232ms 1 1s232ms 1s232ms 1s232ms select * from c_invoiceline invline left join c_invoice inv on invline.c_invoice_id = inv.c_invoice_id where issotrx = ? and inv.dateinvoiced <= to_date(now()) - ? and inv.docstatus in (...) and invline.c_orderline_id is not null and not exists ( select ? from m_matchso mm where mm.c_orderline_id = invline.c_orderline_id and mm.c_invoiceline_id = invline.c_invoiceline_id and mm.m_inoutline_id is null);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 17 07 1 1s232ms 1s232ms [ User: tad - Total duration: 1s232ms - Times executed: 1 ]
[ Application: DBeaver 26.0.1 - SQLEditor
- Total duration: 1s232ms - Times executed: 1 ] -
select * from c_invoiceline invline left join c_invoice inv on invline.c_invoice_id = inv.c_invoice_id where issotrx = 'Y' and inv.dateinvoiced <= to_date(now()) - 260 and inv.docstatus in ('CO', 'CL', 'VO', 'RE') and invline.c_orderline_id is not null and not exists ( select 1 from m_matchso mm where mm.c_orderline_id = invline.c_orderline_id and mm.c_invoiceline_id = invline.c_invoiceline_id and mm.m_inoutline_id is null);
Date: 2026-07-17 07:42:30 Duration: 1s232ms Database: etendo User: tad Remote: 127.0.0.1 Application: DBeaver 26.0.1 - SQLEditor
Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 18 10m58s 4s869ms 53s326ms 36s590ms select shipmentin0_.m_inout_id as m_inout_1_521_0_, shipmentin0_.ad_client_id as ad_clien2_521_0_, shipmentin0_.ad_org_id as ad_org_i3_521_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula34_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 17 07 18 10m58s 36s590ms [ User: tad - Total duration: 10m58s - Times executed: 18 ]
[ Application: openbravo - Total duration: 10m58s - Times executed: 18 ]
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('E341B938EE354C90A4A049F069F4DAA9', 'CC865F1ADCDA462CBBEE333F8A738275', 'C55C2211696E4EFC8C40A6AE6ECD4F6F', '983097CA14BD41DD989FD5621F358F63', '87A1B81CC6904CCE93BEAB5C8580A041', '14789B1EDC704F659C26E9ED68001319', '07B486592161449EB173F0A53BCDC503', '6D83F4670D7B42FB9D07E29595DE0A3B', '5B9F9E6C6D0544608D26E063CD35B29C', '518A49B3472F4256B1C430E16B8E3878', '4A51F861FF37436B8D943C8959643C5F', '07A3A3DF63E64D4C9DFC6C7C0BBA1F25', 'FFB1D1BA333E4F229A969866B6C8C4CA', 'EF8455A1230A4B2E8F5E94941915B8A8', 'EC805D277C83422492ACE03FA4D8B344', 'D9BADC73AF8747578D14423F9CE3AEFC', 'D8A553FABFC14929853D067C5D5026A0', 'D0256943A1A94ADC92367F85E1B3098B', 'C99F66E9C8FE4EBE9F685651C8AFF761', 'AAE117B63415497EBE6866874186AE4D', '78AB6EF0E2E1424FBD9C8A4535D6073C', '6FB9EA84D54E4264A4FCFBA27B0CAC58', '6DB4864FB64D40DCAD9CB3B20EA34CB6', '6CDACA9BB90B43EEA4525EE71A715B07', '6A9C8FB9082A46E685B889B438F587BC', '59525207A29946159D962C124902086A', '381292DA14AC41319DF64C42CD44807D', '0F7D1640888341899B1963877BCF82F5', '07E0E689962A41F3B9EF2C5E7C281F26', 'B86ABF14DB384C6F930775E3BDCA0282', '81D3F18EB6984459B3B5EB668D6ED39C', '25CCBB462CF6499C9799F7BB96C6B0CE', 'F6270C337FEF4F5FBC569305DAEB6854', 'F4D7EB873E184313AE8749A532833981', 'DB9BF174C8244345BBCEDE58FDB825AF', 'CB7811A603624202A441841BB43B363D', '96A48F85F69546D483D3B2C1DABE7284', '96160E5CF83C4BA48627B27C4CAD7270', '6F8224B47A4A49BBAE17B3830AA3D36F', '6913A1AB611F4C04932E98A3A3A3CCE0', '4E87203D64BD4F08B272A8CEA55B7130', '341771A95A1B4C15809CD69FE9F131AA', '1FBD80EFB6EA43D5B780C97FD0DB2E26', '070EF5DB307C496C88006C36FF2C3C4E', 'BB1218FBBA624F17AE49C522E736A3E1', 'A9CA82DF289242FF8B3A1B433846946F', '668F8E571183459FAD85DB4C60E1C84A', '64D0841754154470B4C1F47085F05737', '2BEF4068706C406EBE74923F2E3A2100', 'F391EB61C8284C7E8479892EC4ADA3E9');
Date: 2026-07-17 07:48:20 Duration: 53s326ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('897B6A3582C145988EF890564BE9B95C', '5E0968B250D94CB2910FA3B989395828', '5E064FEFC8844ED8AF01EC712E13CDD9', '476D0BE1B6714A4DB7771406E70041AF', '32ADD0EA1F1A4178BA1983960218A6CA', '23244A1DF17B48618F94499D4F22DA10', 'F5FF23666E684188B591FFA859E69BE8', 'DC5344AEC7674782838FABF633E4A028', 'CB600B3C4D7649C9AEEB6B88604B041C', 'C0DDEF758EED4F52BCE0130A887EAD27', 'B577530D1CEA45FA84B4983E7ADBD24F', 'B4C7E923CB4E4B6D993D7AC917E67993', 'B376BDB6928443FCA28B4F734AA47953', 'AC91B399C2974EEBB1E28FDF08F7FF0F', '8FB5B343669A413D9E63BA5E78EFCD70', '7AD5160327044FB98AD727DD1BCB78AB', '6A4311CB1BC14810B78FBD7CBBDD14DE', '678D14E2839E401699E5FD8FDA7ED38F', '61890F68AF5444A3B92157F79D814EF3', '5BA9DAB956FD4099B6CC53AA36E14F0A', '57A75659AD284DE193C849DF001EF79E', '3D625F0195274F1FAB749A4EEEA9570B', 'EE1BFC992E1D46F788DAC4A1FB91505C', 'D6C10436FE9A4104AEEF78A12F3C0694', 'D18F338EA5F346D9877983D53ABF3899', 'C488EECA6A53410CA41CF709FE2B8E6D', 'C3D8E2802DFB4D7586E12EEA20F9C0D5', 'B30F570BC66E4B99BB0C8DE0861ADC52', 'AA606CF7473A40FD82191F6183BBA888', '821CB396490345DF9405533CDD38B2A5', '7165046164F5465C9F4DFC50C45F59CF', '64BB9FE1B0534415B67146291B75C99F', '4253F000BD0A4F86AD50D0A7389254EC', '37EBFCE207A8436AAC0509D7F5AE1676', '31CF58828C2943D38D284D5554B2FD0C', '31C41C9634E645778AF9474A9611282D', '1BFC606BC1044386812B6831AAA05FC5', '0549E1443FFC4A8AB80F47ED23E87709', 'F16B8AFBC15343DB8D79E783F4167948', '93EF3012353B4228AFE7FFE449FED83D', '8105DBD13C0E432EBA97B5D9FEEF0576', '6BFD1A6ABD984C878626F241340193F6', '63C8B6FB476940DDAD1CAD52829DDB57', '19BE974A72B1411287B77983E0482850', 'F769D2B2982A41379C473CC6B6728FA9', 'E63DD98E4B5E4B88992C96E0C3BE4FAD', 'E603984ECA8A46978C85179B5C8B3531', '9962A410E59646DDBE3F5C2F73F13185', '8A73FAEB5206468A98A3098017C145E6', '76216167222E4B0FBB258A812666A693');
Date: 2026-07-17 07:49:03 Duration: 53s57ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('F579B1A55A2441168C8F3FE6540018CF', 'DBF552E609444C9DBE2C4097BF6E5B7B', 'D3F480A3019C4EE09738BE4B5240EECC', 'CEAB899637F34F15AEC45E6E69312B1C', 'CDC6C680D63449F39B58E3E709C6AE76', 'C24E466824884AA69E1924567DDADDC5', 'B949932CE16D4671A9A26582348D7043', 'A5B5545CF34143A3890B6D0634841E86', 'A127F87F10EB49E2A64A27EE444B8998', '968EBF4E2EAF4B09BEF9AB2BFB570A55', '6CC946CE146847D19EAB3B154B0CC3AB', '575B5D7054104206B57FD0E15613BF35', '5360A1D40AB545949CB002FB5A7DA19D', '509E23E4DB7D4530B4F77F1ADF31A6F6', '3E18BCF5BD1E47ABA495039D73072303', '23AD62B4E0D6486E8F7DF202C65EDE3A', '18EA3C75A0364389970D62353B068756', '14C11CDC6F71459FB2889943DEF40A20', 'C8242610250F4BEE80B981062E4D269C', 'C6B885B7E55E4AF28460E77AA5B0291D', 'C3ACE2604972469FBFB12DDC9B8FC0ED', 'C27DF24FFC2844DD83C1FD6DB724F645', 'AB6CB8647D60402C8653BF5CEA77CDF1', 'A39D331D845D4BF683E0E9F54159FD2F', '9A1073CCA1E24B4EA496EE4874BEE4B6', '977253F06F7D4B008AED1CF8B926F66B', '7BC892DF2C3A4A10B202B7E3FD926575', '7884E045302B44D99CF9D9E1A285B8E3', '69FA2585EC3548AA8C7308D27BB4CA63', '621A3DB055F64443886855BDF6FE0F8B', '5ED36936A5A643E1861230A64FA0274E', '5B735E91786E48C487F7C05382ADFFCA', '4DA803F5A9484638A2C6D0607A5FDBAB', '4A02A4151D194ABE8D7AE997FF77E8BC', '42C5ED3CDFAD473B9A3DB7F169BD7E1E', '406A8120D09E4F2D929D313D3206AABB', '37A5CF5AFE0848FD965DE0E82475C08D', '19847AA4D4C34B81AD2F3CA824F1B9F4', '15AB26E73E014CD7A7BD16CEB9A9A8BF', 'DB2BD124BF4541868FB37A8A63D2D8BE', 'CB5FB2DF310D41A68A23223A75FBB8DC', 'C4883DA872924A319B0A180973B290C0', '807DA4047FB6440E8A1076BFEA9E3067', '348067BEE15340B2A047D70D8A54D37A', 'FEEB974131804A4F8275B1F4CF5898CF', 'EAB4547B4BF64163BECAF5319ECA6109', 'B0353BC736AE4F9FAE9DE68118F3D072', '9FD301FE0E95400DA3059B3DB549ECCE', '9D4419DF81E844019AA081CF48E4EE87', '8F87E4C023874DD0910695792E2287E8');
Date: 2026-07-17 07:48:10 Duration: 52s525ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 15 32s982ms 2s34ms 2s567ms 2s198ms select profile.take_sample ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 17 07 1 2s384ms 2s384ms 08 1 2s253ms 2s253ms 09 1 2s567ms 2s567ms 10 1 2s129ms 2s129ms 11 1 2s231ms 2s231ms 12 1 2s200ms 2s200ms 13 1 2s265ms 2s265ms 14 1 2s34ms 2s34ms 15 1 2s129ms 2s129ms 16 1 2s92ms 2s92ms 17 1 2s51ms 2s51ms 18 1 2s38ms 2s38ms 19 1 2s246ms 2s246ms 20 1 2s136ms 2s136ms 21 1 2s223ms 2s223ms [ User: postgres - Total duration: 32s982ms - Times executed: 15 ]
[ Application: psql - Total duration: 32s982ms - Times executed: 15 ]
-
SELECT profile.take_sample ();
Date: 2026-07-17 09:00:04 Duration: 2s567ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-17 07:00:04 Duration: 2s384ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-17 13:00:03 Duration: 2s265ms Database: etendo User: postgres Remote: [local] Application: psql
3 7 2m52s 22s296ms 26s969ms 24s578ms select "_"."c_invoiceline_id" AS "c_invoiceline_id", "_"."c_invoice_id" AS "c_invoice_id", "_"."ad_org_id" AS "ad_org_id", "_"."isactive" AS "isactive", "_"."issotrx" AS "issotrx", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."c_currency_id" AS "c_currency_id", "_"."m_product_id" AS "m_product_id", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."m_product_category_id" AS "m_product_category_id", "_"."line" AS "line", "_"."Data Factura" AS "Data Factura", "_"."Descripció" AS "Descripció", "_"."Quantitat Factura" AS "Quantitat Factura", "_"."Preu llista" AS "Preu llista", "_"."Preu Actual" AS "Preu Actual", "_"."Preu Límit" AS "Preu Límit", "_"."Import Línia" AS "Import Línia", "_"."Descompte" AS "Descompte", "_"."gross_unit_price" AS "gross_unit_price", "_"."grosspricelist" AS "grosspricelist", "_"."Cost" AS "Cost", extract(hour from "_"."created") AS "created", "_"."Venedor" AS "Model de Negoci", case when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? else ? end AS "Agrupacio Model Negoci" from ( select ol.c_invoiceline_id, ol.c_invoice_id, ol.ad_org_id, ol.isactive, o.issotrx, o.c_bpartner_id, o.c_currency_id, ol.m_product_id, null m_warehouse_id, p.m_product_category_id, ol.line, o.dateinvoiced AS "Data Factura", ol.description AS "Descripció", ol.qtyinvoiced AS "Quantitat Factura", round(ol.pricelist, ?) AS "Preu llista", round(ol.priceactual, ?) AS "Preu Actual", round(ol.pricelimit, ?) AS "Preu Límit", round(ol.linenetamt, ?) AS "Import Línia", ? AS "Descompte", ol.gross_unit_price, ol.grosspricelist, coalesce(m_get_cost (ol.m_product_id, o.dateinvoiced::timestamp, ?, ol.ad_org_id, ol.ad_client_id, null, ?, ?) * ol.qtyinvoiced, ?) AS "Cost", ol.created, us.name AS "Venedor" from c_invoiceline ol left join c_invoice o on o.c_invoice_id = ol.c_invoice_id left join m_product p on p.m_product_id = ol.m_product_id left join ad_user us on us.ad_user_id = coalesce(ol.em_ins_salesrep_id, o.salesrep_id) where ? = ? and o.issotrx = ? and o.c_doctype_id <> ?) "_";Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 17 12 1 25s115ms 25s115ms 13 1 22s296ms 22s296ms 14 1 26s969ms 26s969ms 15 1 25s139ms 25s139ms 17 1 24s251ms 24s251ms 18 1 23s952ms 23s952ms 19 1 24s320ms 24s320ms [ User: tad - Total duration: 2m52s - Times executed: 7 ]
[ Application: Mashup Engine - Total duration: 2m52s - Times executed: 7 ]
-
select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";
Date: 2026-07-17 14:14:14 Duration: 26s969ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
-
select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";
Date: 2026-07-17 15:11:55 Duration: 25s139ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
-
select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";
Date: 2026-07-17 12:11:41 Duration: 25s115ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
4 6 10s755ms 1s265ms 3s756ms 1s792ms select orderline0_.m_product_id as col_0_0_, product1_.name as col_1_0_, sum(orderline0_.qtyordered) as col_2_0_, uom3_.name as col_3_0_, product1_.c_uom_id as col_4_0_ from c_orderline orderline0_ cross join m_product product1_ cross join c_uom uom3_ cross join c_order order5_ cross join m_product product7_ where orderline0_.m_product_id = product1_.m_product_id and product1_.c_uom_id = uom3_.c_uom_id and orderline0_.c_order_id = order5_.c_order_id and orderline0_.m_product_id = product7_.m_product_id and order5_.docstatus = ? and order5_.issotrx = ? and ? = ? and orderline0_.ad_client_id = ? and (product7_.name like ?) and (orderline0_.ad_org_id in (...)) group by product1_.name, uom3_.name, orderline0_.m_product_id, product1_.c_uom_id order by sum(orderline0_.qtyordered) desc limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 17 07 4 8s218ms 2s54ms 08 1 1s271ms 1s271ms 11 1 1s265ms 1s265ms [ User: tad - Total duration: 10s755ms - Times executed: 6 ]
[ Application: openbravo - Total duration: 10s755ms - Times executed: 6 ]
-
select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = '3C5B81C4F43246A88CB0D6064A5E0530' and (product7_.Name like '%') and (orderline0_.AD_Org_ID in ('0', '9F4FFFC6F7674F6F917C736776A79EFD')) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit '10';
Date: 2026-07-17 07:52:52 Duration: 3s756ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = '3C5B81C4F43246A88CB0D6064A5E0530' and (product7_.Name like '%') and (orderline0_.AD_Org_ID in ('0', '9F4FFFC6F7674F6F917C736776A79EFD')) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit '10';
Date: 2026-07-17 07:38:14 Duration: 1s812ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = '3C5B81C4F43246A88CB0D6064A5E0530' and (product7_.Name like '%') and (orderline0_.AD_Org_ID in ('0', '9F4FFFC6F7674F6F917C736776A79EFD')) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit '10';
Date: 2026-07-17 07:48:30 Duration: 1s364ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
5 2 2s314ms 1s7ms 1s306ms 1s157ms select a.id, ev.value as account_id, coalesce(ev_trl.name, ev.name) as name, a.initialamt as saldo_inicial, a.amtacctcr, a.amtacctdr, a.initialamt + a.amtacctdr - a.amtacctcr as saldo_final, a.groupbyid, coalesce( case ? when ? then ( select bp.name from c_bpartner bp where bp.c_bpartner_id = a.groupbyid) when ? then ( select to_char(mp.value) || ? || coalesce(mp_trl.name, mp.name) from m_product mp left join m_product_trl mp_trl on mp_trl.m_product_id = mp.m_product_id and mp_trl.ad_language = ? where mp.m_product_id = a.groupbyid) when ? then ( select to_char(pj.value) || ? || pj.name from c_project pj where pj.c_project_id = a.groupbyid) else ? end, ?) as groupbyname from ( select sum( case when (dateacct < to_date(?) or (dateacct = to_date(?) and f.factaccttype = ?)) then f.amtacctdr - f.amtacctcr else ? end) as initialamt, sum( case when (dateacct >= to_date(?) and f.factaccttype not in (...)) or (dateacct = to_date(?) and f.factaccttype = ?) then f.amtacctdr else ? end) as amtacctdr, sum( case when (dateacct >= to_date(?) and f.factaccttype not in (...)) or (dateacct = to_date(?) and f.factaccttype = ?) then f.amtacctcr else ? end) as amtacctcr, f.account_id as id, to_char(?) as groupbyid from fact_acct f where f.ad_org_id in (...) and f.ad_client_id in (...) and f.ad_org_id in (...) and dateacct < to_date(?) and ? = ? and f.c_acctschema_id = ? and f.isactive = ? group by f.account_id) a left join c_elementvalue ev on a.id = ev.c_elementvalue_id left join c_elementvalue_trl ev_trl on ev.c_elementvalue_id = ev_trl.c_elementvalue_id and ev_trl.ad_language = ? where ev.elementlevel = ? and ? = ? and (a.initialamt <> ? or a.amtacctcr <> ? or a.amtacctdr <> ?) order by ev.value, ev.name, id, groupbyname;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 17 08 2 2s314ms 1s157ms [ User: tad - Total duration: 2s314ms - Times executed: 2 ]
[ Application: openbravo - Total duration: 2s314ms - Times executed: 2 ]
-
select a.id, ev.value as account_id, COALESCE(ev_trl.name, ev.name) as name, a.initialamt as SALDO_INICIAL, a.amtacctcr, a.amtacctdr, A.INITIALAMT + A.AMTACCTDR - A.AMTACCTCR AS SALDO_FINAL, a.groupbyid, COALESCE( CASE '' WHEN 'C_BPARTNER' THEN ( SELECT bp.name FROM c_bpartner bp WHERE bp.c_bpartner_id = a.groupbyid) WHEN 'M_PRODUCT' THEN ( SELECT TO_CHAR(mp.value) || ' - ' || COALESCE(mp_trl.name, mp.name) FROM m_product mp LEFT JOIN m_product_trl mp_trl ON mp_trl.m_product_id = mp.m_product_id AND mp_trl.ad_language = 'es_ES' WHERE mp.m_product_id = a.groupbyid) WHEN 'C_PROJECT' THEN ( SELECT TO_CHAR(pj.value) || ' - ' || pj.name FROM c_project pj WHERE pj.c_project_id = a.groupbyid) ELSE '' END , '') AS groupbyname from ( SELECT sum( case when (DATEACCT < TO_DATE('01-01-2026') or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = 'O')) then F.AMTACCTDR - F.AMTACCTCR else 0 end) as initialamt, sum( case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in ('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTDR else 0 end) as AMTACCTDR, sum( case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in ('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTCR else 0 end) as AMTACCTCR, F.ACCOUNT_ID AS ID, to_char('') AS groupbyid FROM FACT_ACCT F WHERE F.AD_ORG_ID IN ('9F4FFFC6F7674F6F917C736776A79EFD') AND F.AD_CLIENT_ID IN ('0', '3C5B81C4F43246A88CB0D6064A5E0530') AND F.AD_ORG_ID IN ('9F4FFFC6F7674F6F917C736776A79EFD') AND DATEACCT < TO_DATE('01-07-2026') AND 1 = 1 AND F.C_ACCTSCHEMA_ID = '96951D41F113403591D35C71C35D899C' AND F.ISACTIVE = 'Y' group by F.ACCOUNT_ID) a LEFT JOIN c_elementvalue ev ON a.id = ev.c_elementvalue_id LEFT JOIN c_elementvalue_trl ev_trl ON ev.c_elementvalue_id = ev_trl.c_elementvalue_id AND ev_trl.ad_language = 'es_ES' WHERE ev.elementlevel = 'S' AND 2 = 2 and (a.initialamt <> 0 or a.amtacctcr <> 0 or a.amtacctdr <> 0) order by ev.value, ev.name, id, groupbyname;
Date: 2026-07-17 08:07:42 Duration: 1s306ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select a.id, ev.value as account_id, COALESCE(ev_trl.name, ev.name) as name, a.initialamt as SALDO_INICIAL, a.amtacctcr, a.amtacctdr, A.INITIALAMT + A.AMTACCTDR - A.AMTACCTCR AS SALDO_FINAL, a.groupbyid, COALESCE( CASE '' WHEN 'C_BPARTNER' THEN ( SELECT bp.name FROM c_bpartner bp WHERE bp.c_bpartner_id = a.groupbyid) WHEN 'M_PRODUCT' THEN ( SELECT TO_CHAR(mp.value) || ' - ' || COALESCE(mp_trl.name, mp.name) FROM m_product mp LEFT JOIN m_product_trl mp_trl ON mp_trl.m_product_id = mp.m_product_id AND mp_trl.ad_language = 'es_ES' WHERE mp.m_product_id = a.groupbyid) WHEN 'C_PROJECT' THEN ( SELECT TO_CHAR(pj.value) || ' - ' || pj.name FROM c_project pj WHERE pj.c_project_id = a.groupbyid) ELSE '' END , '') AS groupbyname from ( SELECT sum( case when (DATEACCT < TO_DATE('01-01-2026') or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = 'O')) then F.AMTACCTDR - F.AMTACCTCR else 0 end) as initialamt, sum( case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in ('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTDR else 0 end) as AMTACCTDR, sum( case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in ('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTCR else 0 end) as AMTACCTCR, F.ACCOUNT_ID AS ID, to_char('') AS groupbyid FROM FACT_ACCT F WHERE F.AD_ORG_ID IN ('9F4FFFC6F7674F6F917C736776A79EFD') AND F.AD_CLIENT_ID IN ('0', '3C5B81C4F43246A88CB0D6064A5E0530') AND F.AD_ORG_ID IN ('9F4FFFC6F7674F6F917C736776A79EFD') AND DATEACCT < TO_DATE('18-07-2026') AND 1 = 1 AND F.C_ACCTSCHEMA_ID = '96951D41F113403591D35C71C35D899C' AND F.ISACTIVE = 'Y' group by F.ACCOUNT_ID) a LEFT JOIN c_elementvalue ev ON a.id = ev.c_elementvalue_id LEFT JOIN c_elementvalue_trl ev_trl ON ev.c_elementvalue_id = ev_trl.c_elementvalue_id AND ev_trl.ad_language = 'es_ES' WHERE ev.elementlevel = 'S' AND 2 = 2 and (a.initialamt <> 0 or a.amtacctcr <> 0 or a.amtacctdr <> 0) order by ev.value, ev.name, id, groupbyname;
Date: 2026-07-17 08:16:11 Duration: 1s7ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
6 2 2s124ms 1s 1s123ms 1s62ms select shipmentin0_.m_inout_id as m_inout_1_521_0_, shipmentin0_.ad_client_id as ad_clien2_521_0_, shipmentin0_.ad_org_id as ad_org_i3_521_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula34_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 17 07 2 2s124ms 1s62ms [ User: tad - Total duration: 2s124ms - Times executed: 2 ]
[ Application: openbravo - Total duration: 2s124ms - Times executed: 2 ]
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '34B8EE7EDE844769862EEBB446106D5B';
Date: 2026-07-17 07:49:04 Duration: 1s123ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = 'A8A567AE0D2447B894B2C92C22D29335';
Date: 2026-07-17 07:58:40 Duration: 1s Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = $1;
Date: 2026-07-17 07:49:04 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
7 1 1s232ms 1s232ms 1s232ms 1s232ms select * from c_invoiceline invline left join c_invoice inv on invline.c_invoice_id = inv.c_invoice_id where issotrx = ? and inv.dateinvoiced <= to_date(now()) - ? and inv.docstatus in (...) and invline.c_orderline_id is not null and not exists ( select ? from m_matchso mm where mm.c_orderline_id = invline.c_orderline_id and mm.c_invoiceline_id = invline.c_invoiceline_id and mm.m_inoutline_id is null);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 17 07 1 1s232ms 1s232ms [ User: tad - Total duration: 1s232ms - Times executed: 1 ]
[ Application: DBeaver 26.0.1 - SQLEditor
- Total duration: 1s232ms - Times executed: 1 ] -
select * from c_invoiceline invline left join c_invoice inv on invline.c_invoice_id = inv.c_invoice_id where issotrx = 'Y' and inv.dateinvoiced <= to_date(now()) - 260 and inv.docstatus in ('CO', 'CL', 'VO', 'RE') and invline.c_orderline_id is not null and not exists ( select 1 from m_matchso mm where mm.c_orderline_id = invline.c_orderline_id and mm.c_invoiceline_id = invline.c_invoiceline_id and mm.m_inoutline_id is null);
Date: 2026-07-17 07:42:30 Duration: 1s232ms Database: etendo User: tad Remote: 127.0.0.1 Application: DBeaver 26.0.1 - SQLEditor
Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 4s869ms 53s326ms 36s590ms 18 10m58s select shipmentin0_.m_inout_id as m_inout_1_521_0_, shipmentin0_.ad_client_id as ad_clien2_521_0_, shipmentin0_.ad_org_id as ad_org_i3_521_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula34_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 17 07 18 10m58s 36s590ms [ User: tad - Total duration: 10m58s - Times executed: 18 ]
[ Application: openbravo - Total duration: 10m58s - Times executed: 18 ]
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('E341B938EE354C90A4A049F069F4DAA9', 'CC865F1ADCDA462CBBEE333F8A738275', 'C55C2211696E4EFC8C40A6AE6ECD4F6F', '983097CA14BD41DD989FD5621F358F63', '87A1B81CC6904CCE93BEAB5C8580A041', '14789B1EDC704F659C26E9ED68001319', '07B486592161449EB173F0A53BCDC503', '6D83F4670D7B42FB9D07E29595DE0A3B', '5B9F9E6C6D0544608D26E063CD35B29C', '518A49B3472F4256B1C430E16B8E3878', '4A51F861FF37436B8D943C8959643C5F', '07A3A3DF63E64D4C9DFC6C7C0BBA1F25', 'FFB1D1BA333E4F229A969866B6C8C4CA', 'EF8455A1230A4B2E8F5E94941915B8A8', 'EC805D277C83422492ACE03FA4D8B344', 'D9BADC73AF8747578D14423F9CE3AEFC', 'D8A553FABFC14929853D067C5D5026A0', 'D0256943A1A94ADC92367F85E1B3098B', 'C99F66E9C8FE4EBE9F685651C8AFF761', 'AAE117B63415497EBE6866874186AE4D', '78AB6EF0E2E1424FBD9C8A4535D6073C', '6FB9EA84D54E4264A4FCFBA27B0CAC58', '6DB4864FB64D40DCAD9CB3B20EA34CB6', '6CDACA9BB90B43EEA4525EE71A715B07', '6A9C8FB9082A46E685B889B438F587BC', '59525207A29946159D962C124902086A', '381292DA14AC41319DF64C42CD44807D', '0F7D1640888341899B1963877BCF82F5', '07E0E689962A41F3B9EF2C5E7C281F26', 'B86ABF14DB384C6F930775E3BDCA0282', '81D3F18EB6984459B3B5EB668D6ED39C', '25CCBB462CF6499C9799F7BB96C6B0CE', 'F6270C337FEF4F5FBC569305DAEB6854', 'F4D7EB873E184313AE8749A532833981', 'DB9BF174C8244345BBCEDE58FDB825AF', 'CB7811A603624202A441841BB43B363D', '96A48F85F69546D483D3B2C1DABE7284', '96160E5CF83C4BA48627B27C4CAD7270', '6F8224B47A4A49BBAE17B3830AA3D36F', '6913A1AB611F4C04932E98A3A3A3CCE0', '4E87203D64BD4F08B272A8CEA55B7130', '341771A95A1B4C15809CD69FE9F131AA', '1FBD80EFB6EA43D5B780C97FD0DB2E26', '070EF5DB307C496C88006C36FF2C3C4E', 'BB1218FBBA624F17AE49C522E736A3E1', 'A9CA82DF289242FF8B3A1B433846946F', '668F8E571183459FAD85DB4C60E1C84A', '64D0841754154470B4C1F47085F05737', '2BEF4068706C406EBE74923F2E3A2100', 'F391EB61C8284C7E8479892EC4ADA3E9');
Date: 2026-07-17 07:48:20 Duration: 53s326ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('897B6A3582C145988EF890564BE9B95C', '5E0968B250D94CB2910FA3B989395828', '5E064FEFC8844ED8AF01EC712E13CDD9', '476D0BE1B6714A4DB7771406E70041AF', '32ADD0EA1F1A4178BA1983960218A6CA', '23244A1DF17B48618F94499D4F22DA10', 'F5FF23666E684188B591FFA859E69BE8', 'DC5344AEC7674782838FABF633E4A028', 'CB600B3C4D7649C9AEEB6B88604B041C', 'C0DDEF758EED4F52BCE0130A887EAD27', 'B577530D1CEA45FA84B4983E7ADBD24F', 'B4C7E923CB4E4B6D993D7AC917E67993', 'B376BDB6928443FCA28B4F734AA47953', 'AC91B399C2974EEBB1E28FDF08F7FF0F', '8FB5B343669A413D9E63BA5E78EFCD70', '7AD5160327044FB98AD727DD1BCB78AB', '6A4311CB1BC14810B78FBD7CBBDD14DE', '678D14E2839E401699E5FD8FDA7ED38F', '61890F68AF5444A3B92157F79D814EF3', '5BA9DAB956FD4099B6CC53AA36E14F0A', '57A75659AD284DE193C849DF001EF79E', '3D625F0195274F1FAB749A4EEEA9570B', 'EE1BFC992E1D46F788DAC4A1FB91505C', 'D6C10436FE9A4104AEEF78A12F3C0694', 'D18F338EA5F346D9877983D53ABF3899', 'C488EECA6A53410CA41CF709FE2B8E6D', 'C3D8E2802DFB4D7586E12EEA20F9C0D5', 'B30F570BC66E4B99BB0C8DE0861ADC52', 'AA606CF7473A40FD82191F6183BBA888', '821CB396490345DF9405533CDD38B2A5', '7165046164F5465C9F4DFC50C45F59CF', '64BB9FE1B0534415B67146291B75C99F', '4253F000BD0A4F86AD50D0A7389254EC', '37EBFCE207A8436AAC0509D7F5AE1676', '31CF58828C2943D38D284D5554B2FD0C', '31C41C9634E645778AF9474A9611282D', '1BFC606BC1044386812B6831AAA05FC5', '0549E1443FFC4A8AB80F47ED23E87709', 'F16B8AFBC15343DB8D79E783F4167948', '93EF3012353B4228AFE7FFE449FED83D', '8105DBD13C0E432EBA97B5D9FEEF0576', '6BFD1A6ABD984C878626F241340193F6', '63C8B6FB476940DDAD1CAD52829DDB57', '19BE974A72B1411287B77983E0482850', 'F769D2B2982A41379C473CC6B6728FA9', 'E63DD98E4B5E4B88992C96E0C3BE4FAD', 'E603984ECA8A46978C85179B5C8B3531', '9962A410E59646DDBE3F5C2F73F13185', '8A73FAEB5206468A98A3098017C145E6', '76216167222E4B0FBB258A812666A693');
Date: 2026-07-17 07:49:03 Duration: 53s57ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('F579B1A55A2441168C8F3FE6540018CF', 'DBF552E609444C9DBE2C4097BF6E5B7B', 'D3F480A3019C4EE09738BE4B5240EECC', 'CEAB899637F34F15AEC45E6E69312B1C', 'CDC6C680D63449F39B58E3E709C6AE76', 'C24E466824884AA69E1924567DDADDC5', 'B949932CE16D4671A9A26582348D7043', 'A5B5545CF34143A3890B6D0634841E86', 'A127F87F10EB49E2A64A27EE444B8998', '968EBF4E2EAF4B09BEF9AB2BFB570A55', '6CC946CE146847D19EAB3B154B0CC3AB', '575B5D7054104206B57FD0E15613BF35', '5360A1D40AB545949CB002FB5A7DA19D', '509E23E4DB7D4530B4F77F1ADF31A6F6', '3E18BCF5BD1E47ABA495039D73072303', '23AD62B4E0D6486E8F7DF202C65EDE3A', '18EA3C75A0364389970D62353B068756', '14C11CDC6F71459FB2889943DEF40A20', 'C8242610250F4BEE80B981062E4D269C', 'C6B885B7E55E4AF28460E77AA5B0291D', 'C3ACE2604972469FBFB12DDC9B8FC0ED', 'C27DF24FFC2844DD83C1FD6DB724F645', 'AB6CB8647D60402C8653BF5CEA77CDF1', 'A39D331D845D4BF683E0E9F54159FD2F', '9A1073CCA1E24B4EA496EE4874BEE4B6', '977253F06F7D4B008AED1CF8B926F66B', '7BC892DF2C3A4A10B202B7E3FD926575', '7884E045302B44D99CF9D9E1A285B8E3', '69FA2585EC3548AA8C7308D27BB4CA63', '621A3DB055F64443886855BDF6FE0F8B', '5ED36936A5A643E1861230A64FA0274E', '5B735E91786E48C487F7C05382ADFFCA', '4DA803F5A9484638A2C6D0607A5FDBAB', '4A02A4151D194ABE8D7AE997FF77E8BC', '42C5ED3CDFAD473B9A3DB7F169BD7E1E', '406A8120D09E4F2D929D313D3206AABB', '37A5CF5AFE0848FD965DE0E82475C08D', '19847AA4D4C34B81AD2F3CA824F1B9F4', '15AB26E73E014CD7A7BD16CEB9A9A8BF', 'DB2BD124BF4541868FB37A8A63D2D8BE', 'CB5FB2DF310D41A68A23223A75FBB8DC', 'C4883DA872924A319B0A180973B290C0', '807DA4047FB6440E8A1076BFEA9E3067', '348067BEE15340B2A047D70D8A54D37A', 'FEEB974131804A4F8275B1F4CF5898CF', 'EAB4547B4BF64163BECAF5319ECA6109', 'B0353BC736AE4F9FAE9DE68118F3D072', '9FD301FE0E95400DA3059B3DB549ECCE', '9D4419DF81E844019AA081CF48E4EE87', '8F87E4C023874DD0910695792E2287E8');
Date: 2026-07-17 07:48:10 Duration: 52s525ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 22s296ms 26s969ms 24s578ms 7 2m52s select "_"."c_invoiceline_id" AS "c_invoiceline_id", "_"."c_invoice_id" AS "c_invoice_id", "_"."ad_org_id" AS "ad_org_id", "_"."isactive" AS "isactive", "_"."issotrx" AS "issotrx", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."c_currency_id" AS "c_currency_id", "_"."m_product_id" AS "m_product_id", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."m_product_category_id" AS "m_product_category_id", "_"."line" AS "line", "_"."Data Factura" AS "Data Factura", "_"."Descripció" AS "Descripció", "_"."Quantitat Factura" AS "Quantitat Factura", "_"."Preu llista" AS "Preu llista", "_"."Preu Actual" AS "Preu Actual", "_"."Preu Límit" AS "Preu Límit", "_"."Import Línia" AS "Import Línia", "_"."Descompte" AS "Descompte", "_"."gross_unit_price" AS "gross_unit_price", "_"."grosspricelist" AS "grosspricelist", "_"."Cost" AS "Cost", extract(hour from "_"."created") AS "created", "_"."Venedor" AS "Model de Negoci", case when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? else ? end AS "Agrupacio Model Negoci" from ( select ol.c_invoiceline_id, ol.c_invoice_id, ol.ad_org_id, ol.isactive, o.issotrx, o.c_bpartner_id, o.c_currency_id, ol.m_product_id, null m_warehouse_id, p.m_product_category_id, ol.line, o.dateinvoiced AS "Data Factura", ol.description AS "Descripció", ol.qtyinvoiced AS "Quantitat Factura", round(ol.pricelist, ?) AS "Preu llista", round(ol.priceactual, ?) AS "Preu Actual", round(ol.pricelimit, ?) AS "Preu Límit", round(ol.linenetamt, ?) AS "Import Línia", ? AS "Descompte", ol.gross_unit_price, ol.grosspricelist, coalesce(m_get_cost (ol.m_product_id, o.dateinvoiced::timestamp, ?, ol.ad_org_id, ol.ad_client_id, null, ?, ?) * ol.qtyinvoiced, ?) AS "Cost", ol.created, us.name AS "Venedor" from c_invoiceline ol left join c_invoice o on o.c_invoice_id = ol.c_invoice_id left join m_product p on p.m_product_id = ol.m_product_id left join ad_user us on us.ad_user_id = coalesce(ol.em_ins_salesrep_id, o.salesrep_id) where ? = ? and o.issotrx = ? and o.c_doctype_id <> ?) "_";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 17 12 1 25s115ms 25s115ms 13 1 22s296ms 22s296ms 14 1 26s969ms 26s969ms 15 1 25s139ms 25s139ms 17 1 24s251ms 24s251ms 18 1 23s952ms 23s952ms 19 1 24s320ms 24s320ms [ User: tad - Total duration: 2m52s - Times executed: 7 ]
[ Application: Mashup Engine - Total duration: 2m52s - Times executed: 7 ]
-
select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";
Date: 2026-07-17 14:14:14 Duration: 26s969ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
-
select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";
Date: 2026-07-17 15:11:55 Duration: 25s139ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
-
select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";
Date: 2026-07-17 12:11:41 Duration: 25s115ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
3 2s34ms 2s567ms 2s198ms 15 32s982ms select profile.take_sample ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 17 07 1 2s384ms 2s384ms 08 1 2s253ms 2s253ms 09 1 2s567ms 2s567ms 10 1 2s129ms 2s129ms 11 1 2s231ms 2s231ms 12 1 2s200ms 2s200ms 13 1 2s265ms 2s265ms 14 1 2s34ms 2s34ms 15 1 2s129ms 2s129ms 16 1 2s92ms 2s92ms 17 1 2s51ms 2s51ms 18 1 2s38ms 2s38ms 19 1 2s246ms 2s246ms 20 1 2s136ms 2s136ms 21 1 2s223ms 2s223ms [ User: postgres - Total duration: 32s982ms - Times executed: 15 ]
[ Application: psql - Total duration: 32s982ms - Times executed: 15 ]
-
SELECT profile.take_sample ();
Date: 2026-07-17 09:00:04 Duration: 2s567ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-17 07:00:04 Duration: 2s384ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-17 13:00:03 Duration: 2s265ms Database: etendo User: postgres Remote: [local] Application: psql
4 1s265ms 3s756ms 1s792ms 6 10s755ms select orderline0_.m_product_id as col_0_0_, product1_.name as col_1_0_, sum(orderline0_.qtyordered) as col_2_0_, uom3_.name as col_3_0_, product1_.c_uom_id as col_4_0_ from c_orderline orderline0_ cross join m_product product1_ cross join c_uom uom3_ cross join c_order order5_ cross join m_product product7_ where orderline0_.m_product_id = product1_.m_product_id and product1_.c_uom_id = uom3_.c_uom_id and orderline0_.c_order_id = order5_.c_order_id and orderline0_.m_product_id = product7_.m_product_id and order5_.docstatus = ? and order5_.issotrx = ? and ? = ? and orderline0_.ad_client_id = ? and (product7_.name like ?) and (orderline0_.ad_org_id in (...)) group by product1_.name, uom3_.name, orderline0_.m_product_id, product1_.c_uom_id order by sum(orderline0_.qtyordered) desc limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 17 07 4 8s218ms 2s54ms 08 1 1s271ms 1s271ms 11 1 1s265ms 1s265ms [ User: tad - Total duration: 10s755ms - Times executed: 6 ]
[ Application: openbravo - Total duration: 10s755ms - Times executed: 6 ]
-
select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = '3C5B81C4F43246A88CB0D6064A5E0530' and (product7_.Name like '%') and (orderline0_.AD_Org_ID in ('0', '9F4FFFC6F7674F6F917C736776A79EFD')) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit '10';
Date: 2026-07-17 07:52:52 Duration: 3s756ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = '3C5B81C4F43246A88CB0D6064A5E0530' and (product7_.Name like '%') and (orderline0_.AD_Org_ID in ('0', '9F4FFFC6F7674F6F917C736776A79EFD')) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit '10';
Date: 2026-07-17 07:38:14 Duration: 1s812ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = '3C5B81C4F43246A88CB0D6064A5E0530' and (product7_.Name like '%') and (orderline0_.AD_Org_ID in ('0', '9F4FFFC6F7674F6F917C736776A79EFD')) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit '10';
Date: 2026-07-17 07:48:30 Duration: 1s364ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
5 1s232ms 1s232ms 1s232ms 1 1s232ms select * from c_invoiceline invline left join c_invoice inv on invline.c_invoice_id = inv.c_invoice_id where issotrx = ? and inv.dateinvoiced <= to_date(now()) - ? and inv.docstatus in (...) and invline.c_orderline_id is not null and not exists ( select ? from m_matchso mm where mm.c_orderline_id = invline.c_orderline_id and mm.c_invoiceline_id = invline.c_invoiceline_id and mm.m_inoutline_id is null);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 17 07 1 1s232ms 1s232ms [ User: tad - Total duration: 1s232ms - Times executed: 1 ]
[ Application: DBeaver 26.0.1 - SQLEditor
- Total duration: 1s232ms - Times executed: 1 ] -
select * from c_invoiceline invline left join c_invoice inv on invline.c_invoice_id = inv.c_invoice_id where issotrx = 'Y' and inv.dateinvoiced <= to_date(now()) - 260 and inv.docstatus in ('CO', 'CL', 'VO', 'RE') and invline.c_orderline_id is not null and not exists ( select 1 from m_matchso mm where mm.c_orderline_id = invline.c_orderline_id and mm.c_invoiceline_id = invline.c_invoiceline_id and mm.m_inoutline_id is null);
Date: 2026-07-17 07:42:30 Duration: 1s232ms Database: etendo User: tad Remote: 127.0.0.1 Application: DBeaver 26.0.1 - SQLEditor
Bind query: yes
6 1s7ms 1s306ms 1s157ms 2 2s314ms select a.id, ev.value as account_id, coalesce(ev_trl.name, ev.name) as name, a.initialamt as saldo_inicial, a.amtacctcr, a.amtacctdr, a.initialamt + a.amtacctdr - a.amtacctcr as saldo_final, a.groupbyid, coalesce( case ? when ? then ( select bp.name from c_bpartner bp where bp.c_bpartner_id = a.groupbyid) when ? then ( select to_char(mp.value) || ? || coalesce(mp_trl.name, mp.name) from m_product mp left join m_product_trl mp_trl on mp_trl.m_product_id = mp.m_product_id and mp_trl.ad_language = ? where mp.m_product_id = a.groupbyid) when ? then ( select to_char(pj.value) || ? || pj.name from c_project pj where pj.c_project_id = a.groupbyid) else ? end, ?) as groupbyname from ( select sum( case when (dateacct < to_date(?) or (dateacct = to_date(?) and f.factaccttype = ?)) then f.amtacctdr - f.amtacctcr else ? end) as initialamt, sum( case when (dateacct >= to_date(?) and f.factaccttype not in (...)) or (dateacct = to_date(?) and f.factaccttype = ?) then f.amtacctdr else ? end) as amtacctdr, sum( case when (dateacct >= to_date(?) and f.factaccttype not in (...)) or (dateacct = to_date(?) and f.factaccttype = ?) then f.amtacctcr else ? end) as amtacctcr, f.account_id as id, to_char(?) as groupbyid from fact_acct f where f.ad_org_id in (...) and f.ad_client_id in (...) and f.ad_org_id in (...) and dateacct < to_date(?) and ? = ? and f.c_acctschema_id = ? and f.isactive = ? group by f.account_id) a left join c_elementvalue ev on a.id = ev.c_elementvalue_id left join c_elementvalue_trl ev_trl on ev.c_elementvalue_id = ev_trl.c_elementvalue_id and ev_trl.ad_language = ? where ev.elementlevel = ? and ? = ? and (a.initialamt <> ? or a.amtacctcr <> ? or a.amtacctdr <> ?) order by ev.value, ev.name, id, groupbyname;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 17 08 2 2s314ms 1s157ms [ User: tad - Total duration: 2s314ms - Times executed: 2 ]
[ Application: openbravo - Total duration: 2s314ms - Times executed: 2 ]
-
select a.id, ev.value as account_id, COALESCE(ev_trl.name, ev.name) as name, a.initialamt as SALDO_INICIAL, a.amtacctcr, a.amtacctdr, A.INITIALAMT + A.AMTACCTDR - A.AMTACCTCR AS SALDO_FINAL, a.groupbyid, COALESCE( CASE '' WHEN 'C_BPARTNER' THEN ( SELECT bp.name FROM c_bpartner bp WHERE bp.c_bpartner_id = a.groupbyid) WHEN 'M_PRODUCT' THEN ( SELECT TO_CHAR(mp.value) || ' - ' || COALESCE(mp_trl.name, mp.name) FROM m_product mp LEFT JOIN m_product_trl mp_trl ON mp_trl.m_product_id = mp.m_product_id AND mp_trl.ad_language = 'es_ES' WHERE mp.m_product_id = a.groupbyid) WHEN 'C_PROJECT' THEN ( SELECT TO_CHAR(pj.value) || ' - ' || pj.name FROM c_project pj WHERE pj.c_project_id = a.groupbyid) ELSE '' END , '') AS groupbyname from ( SELECT sum( case when (DATEACCT < TO_DATE('01-01-2026') or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = 'O')) then F.AMTACCTDR - F.AMTACCTCR else 0 end) as initialamt, sum( case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in ('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTDR else 0 end) as AMTACCTDR, sum( case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in ('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTCR else 0 end) as AMTACCTCR, F.ACCOUNT_ID AS ID, to_char('') AS groupbyid FROM FACT_ACCT F WHERE F.AD_ORG_ID IN ('9F4FFFC6F7674F6F917C736776A79EFD') AND F.AD_CLIENT_ID IN ('0', '3C5B81C4F43246A88CB0D6064A5E0530') AND F.AD_ORG_ID IN ('9F4FFFC6F7674F6F917C736776A79EFD') AND DATEACCT < TO_DATE('01-07-2026') AND 1 = 1 AND F.C_ACCTSCHEMA_ID = '96951D41F113403591D35C71C35D899C' AND F.ISACTIVE = 'Y' group by F.ACCOUNT_ID) a LEFT JOIN c_elementvalue ev ON a.id = ev.c_elementvalue_id LEFT JOIN c_elementvalue_trl ev_trl ON ev.c_elementvalue_id = ev_trl.c_elementvalue_id AND ev_trl.ad_language = 'es_ES' WHERE ev.elementlevel = 'S' AND 2 = 2 and (a.initialamt <> 0 or a.amtacctcr <> 0 or a.amtacctdr <> 0) order by ev.value, ev.name, id, groupbyname;
Date: 2026-07-17 08:07:42 Duration: 1s306ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select a.id, ev.value as account_id, COALESCE(ev_trl.name, ev.name) as name, a.initialamt as SALDO_INICIAL, a.amtacctcr, a.amtacctdr, A.INITIALAMT + A.AMTACCTDR - A.AMTACCTCR AS SALDO_FINAL, a.groupbyid, COALESCE( CASE '' WHEN 'C_BPARTNER' THEN ( SELECT bp.name FROM c_bpartner bp WHERE bp.c_bpartner_id = a.groupbyid) WHEN 'M_PRODUCT' THEN ( SELECT TO_CHAR(mp.value) || ' - ' || COALESCE(mp_trl.name, mp.name) FROM m_product mp LEFT JOIN m_product_trl mp_trl ON mp_trl.m_product_id = mp.m_product_id AND mp_trl.ad_language = 'es_ES' WHERE mp.m_product_id = a.groupbyid) WHEN 'C_PROJECT' THEN ( SELECT TO_CHAR(pj.value) || ' - ' || pj.name FROM c_project pj WHERE pj.c_project_id = a.groupbyid) ELSE '' END , '') AS groupbyname from ( SELECT sum( case when (DATEACCT < TO_DATE('01-01-2026') or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = 'O')) then F.AMTACCTDR - F.AMTACCTCR else 0 end) as initialamt, sum( case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in ('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTDR else 0 end) as AMTACCTDR, sum( case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in ('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTCR else 0 end) as AMTACCTCR, F.ACCOUNT_ID AS ID, to_char('') AS groupbyid FROM FACT_ACCT F WHERE F.AD_ORG_ID IN ('9F4FFFC6F7674F6F917C736776A79EFD') AND F.AD_CLIENT_ID IN ('0', '3C5B81C4F43246A88CB0D6064A5E0530') AND F.AD_ORG_ID IN ('9F4FFFC6F7674F6F917C736776A79EFD') AND DATEACCT < TO_DATE('18-07-2026') AND 1 = 1 AND F.C_ACCTSCHEMA_ID = '96951D41F113403591D35C71C35D899C' AND F.ISACTIVE = 'Y' group by F.ACCOUNT_ID) a LEFT JOIN c_elementvalue ev ON a.id = ev.c_elementvalue_id LEFT JOIN c_elementvalue_trl ev_trl ON ev.c_elementvalue_id = ev_trl.c_elementvalue_id AND ev_trl.ad_language = 'es_ES' WHERE ev.elementlevel = 'S' AND 2 = 2 and (a.initialamt <> 0 or a.amtacctcr <> 0 or a.amtacctdr <> 0) order by ev.value, ev.name, id, groupbyname;
Date: 2026-07-17 08:16:11 Duration: 1s7ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
7 1s 1s123ms 1s62ms 2 2s124ms select shipmentin0_.m_inout_id as m_inout_1_521_0_, shipmentin0_.ad_client_id as ad_clien2_521_0_, shipmentin0_.ad_org_id as ad_org_i3_521_0_, ( select c_getinvoicestatusfromshipment (shipmentin0_.m_inout_id) from dual) as formula34_0_ from m_inout shipmentin0_ where shipmentin0_.m_inout_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 17 07 2 2s124ms 1s62ms [ User: tad - Total duration: 2s124ms - Times executed: 2 ]
[ Application: openbravo - Total duration: 2s124ms - Times executed: 2 ]
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '34B8EE7EDE844769862EEBB446106D5B';
Date: 2026-07-17 07:49:04 Duration: 1s123ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = 'A8A567AE0D2447B894B2C92C22D29335';
Date: 2026-07-17 07:58:40 Duration: 1s Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select shipmentin0_.M_InOut_ID as m_inout_1_521_0_, shipmentin0_.AD_Client_ID as ad_clien2_521_0_, shipmentin0_.AD_Org_ID as ad_org_i3_521_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula34_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = $1;
Date: 2026-07-17 07:49:04 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
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
- 29,582 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 9 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 9 Max number of times the same event was reported
- 10 Total events found
Rank Times reported Error 1 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 17 07 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-17 07:49:31 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Date: 2026-07-17 07:49:31 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Date: 2026-07-17 07:49:31 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
2 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 17 07 1 - LOG: database system was shut down at 2026-07-17 07:49:31 CEST
Date: 2026-07-17 07:51:56