pgBadger-
Global information
- Generated on Sun Jul 19 23:00:04 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 27,706 log entries in 2s
- Log start from 2026-07-19 07:00:01 to 2026-07-19 21:59:44
-
Overview
Global Stats
- 4 Number of unique normalized queries
- 16 Number of queries
- 18s459ms Total query duration
- 2026-07-19 07:00:01 First query
- 2026-07-19 21:00:01 Last query
- 2 queries/s at 2026-07-19 20:00:01 Query peak
- 18s459ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 18s459ms Execute total duration
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 82 Total number of automatic vacuums
- 106 Total number of automatic analyzes
- 30 Number temporary file
- 22.72 MiB Max size of temporary file
- 11.36 MiB Average size of temporary file
- 3,276 Total number of sessions
- 7 sessions at 2026-07-19 21:00:01 Session peak
- 2d19h59m11s Total duration of sessions
- 1m14s Average duration of sessions
- 0 Average queries per session
- 5ms Average queries duration per session
- 1m14s Average idle time per session
- 3,274 Total number of connections
- 5 connections/s at 2026-07-19 15:00:01 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2026-07-19 20:00:01 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-07-19 20:00:01 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 18s459ms 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 19 07 1 0ms 1s187ms 1s187ms 0ms 0ms 1s187ms 08 1 0ms 1s122ms 1s122ms 0ms 0ms 1s122ms 09 1 0ms 1s143ms 1s143ms 0ms 0ms 1s143ms 10 1 0ms 1s112ms 1s112ms 0ms 0ms 1s112ms 11 1 0ms 1s188ms 1s188ms 0ms 0ms 1s188ms 12 1 0ms 1s94ms 1s94ms 0ms 0ms 1s94ms 13 1 0ms 1s187ms 1s187ms 0ms 0ms 1s187ms 14 1 0ms 1s112ms 1s112ms 0ms 0ms 1s112ms 15 1 0ms 1s104ms 1s104ms 0ms 0ms 1s104ms 16 1 0ms 1s110ms 1s110ms 0ms 0ms 1s110ms 17 1 0ms 1s237ms 1s237ms 0ms 0ms 1s237ms 18 1 0ms 1s85ms 1s85ms 0ms 0ms 1s85ms 19 1 0ms 1s305ms 1s305ms 0ms 0ms 1s305ms 20 2 0ms 1s203ms 1s145ms 0ms 0ms 2s291ms 21 1 0ms 1s176ms 1s176ms 0ms 0ms 1s176ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 19 07 1 0 1s187ms 0ms 0ms 0ms 08 1 0 1s122ms 0ms 0ms 0ms 09 1 0 1s143ms 0ms 0ms 0ms 10 1 0 1s112ms 0ms 0ms 0ms 11 1 0 1s188ms 0ms 0ms 0ms 12 1 0 1s94ms 0ms 0ms 0ms 13 1 0 1s187ms 0ms 0ms 0ms 14 1 0 1s112ms 0ms 0ms 0ms 15 1 0 1s104ms 0ms 0ms 0ms 16 1 0 1s110ms 0ms 0ms 0ms 17 1 0 1s237ms 0ms 0ms 0ms 18 1 0 1s85ms 0ms 0ms 0ms 19 1 0 1s305ms 0ms 0ms 0ms 20 2 0 1s145ms 0ms 0ms 0ms 21 1 0 1s176ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 19 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 Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 19 07 0 1 1.00 0.00% 08 0 1 1.00 0.00% 09 0 1 1.00 0.00% 10 0 1 1.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 1 1.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 2 2.00 0.00% 21 0 1 1.00 0.00% Day Hour Count Average / Second Jul 19 07 217 0.06/s 08 217 0.06/s 09 221 0.06/s 10 217 0.06/s 11 219 0.06/s 12 217 0.06/s 13 219 0.06/s 14 217 0.06/s 15 219 0.06/s 16 218 0.06/s 17 219 0.06/s 18 217 0.06/s 19 219 0.06/s 20 217 0.06/s 21 221 0.06/s Day Hour Count Average Duration Average idle time Jul 19 07 219 57s947ms 57s941ms 08 217 18ms 13ms 09 221 1m39s 1m39s 10 217 18ms 13ms 11 219 1m7s 1m7s 12 217 18ms 13ms 13 219 3m49s 3m49s 14 217 19ms 14ms 15 219 1m39s 1m39s 16 218 691ms 686ms 17 219 4m22s 4m22s 18 217 19ms 14ms 19 219 3m18s 3m18s 20 217 19ms 8ms 21 221 1m40s 1m40s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-19 15:00:01 Date
Connections per database
Key values
- etendo Main Database
- 3,274 connections Total
Connections per user
Key values
- tad Main User
- 3,274 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-07-19 21:00:01 Date
Histogram of session times
Key values
- 3,240 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 3,276 sessions Total
Sessions per user
Key values
- tad Main User
- 3,276 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 3,276 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 30,337 buffers Checkpoint Peak
- 2026-07-19 18:17:35 Date
- 269.885 seconds Highest write time
- 0.007 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-07-19 18:31:02 Date
Checkpoints distance
Key values
- 49.69 Mo Distance Peak
- 2026-07-19 17:07:34 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 19 07 12,064 1,196.253s 0.008s 1,196.27s 08 14,107 1,408.806s 0.017s 1,408.833s 09 12,490 1,244.017s 0.007s 1,244.031s 10 13,506 1,349.338s 0.011s 1,349.363s 11 13,831 1,337.89s 0.008s 1,337.907s 12 13,973 1,395.204s 0.009s 1,395.225s 13 14,027 1,366.143s 0.009s 1,366.162s 14 14,641 1,463.016s 0.009s 1,463.035s 15 14,388 1,401.002s 0.009s 1,401.021s 16 14,767 1,475.243s 0.009s 1,475.266s 17 13,667 1,311.854s 0.007s 1,311.869s 18 43,995 1,634.358s 0.008s 1,634.377s 19 14,717 1,412.524s 0.007s 1,412.54s 20 15,299 1,528.303s 0.008s 1,528.322s 21 14,882 1,434.632s 0.007s 1,434.65s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 19 07 0 6 0 362 0.001s 0.008s 08 0 6 0 425 0.002s 0.011s 09 0 6 0 358 0.001s 0.007s 10 0 7 0 489 0.001s 0.01s 11 0 6 0 366 0.001s 0.007s 12 0 6 0 399 0.001s 0.009s 13 0 7 0 391 0.001s 0.009s 14 0 7 0 399 0.001s 0.009s 15 0 7 0 401 0.001s 0.009s 16 0 7 0 390 0.001s 0.009s 17 0 6 0 356 0.001s 0.007s 18 0 6 0 394 0.001s 0.007s 19 0 6 0 380 0.001s 0.007s 20 0 6 0 377 0.001s 0.008s 21 0 7 0 358 0.001s 0.006s Day Hour Count Avg time (sec) Jul 19 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s Day Hour Mean distance Mean estimate Jul 19 07 11,909.00 kB 228,963.25 kB 08 9,925.64 kB 92,662.55 kB 09 13,978.57 kB 42,290.29 kB 10 10,445.60 kB 23,929.90 kB 11 14,926.57 kB 22,025.14 kB 12 11,861.11 kB 16,510.33 kB 13 11,949.67 kB 20,289.00 kB 14 12,326.89 kB 15,008.00 kB 15 12,408.89 kB 20,617.33 kB 16 12,623.33 kB 15,253.78 kB 17 14,601.57 kB 22,204.43 kB 18 13,387.12 kB 18,078.62 kB 19 13,543.57 kB 20,219.43 kB 20 12,868.62 kB 16,059.75 kB 21 14,896.00 kB 21,693.71 kB -
Temporary Files
Size of temporary files
Key values
- 22.72 MiB Temp Files size Peak
- 2026-07-19 07:00:04 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-19 07:00:04 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 19 07 2 22.72 MiB 11.36 MiB 08 2 22.72 MiB 11.36 MiB 09 2 22.72 MiB 11.36 MiB 10 2 22.72 MiB 11.36 MiB 11 2 22.72 MiB 11.36 MiB 12 2 22.72 MiB 11.36 MiB 13 2 22.72 MiB 11.36 MiB 14 2 22.72 MiB 11.36 MiB 15 2 22.72 MiB 11.36 MiB 16 2 22.72 MiB 11.36 MiB 17 2 22.72 MiB 11.36 MiB 18 2 22.72 MiB 11.36 MiB 19 2 22.72 MiB 11.36 MiB 20 2 22.72 MiB 11.36 MiB 21 2 22.72 MiB 11.36 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 15 238.55 MiB 11.36 MiB 22.72 MiB 15.90 MiB update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select prod.upc as referencekey_id, ad_column_identifier (?, prod.upc, ?) as record_id, ? as ad_role_id, null as ad_user_id, ? || prod.upc as description, ? as isactive, prod.ad_org_id, prod.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from m_product prod where prod.upc is not null and prod.upc <> ? group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > ?) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-19 07:00:04 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
2 9 102.23 MiB 11.36 MiB 11.36 MiB 11.36 MiB select * from ( select ;-
SELECT * FROM ( select ;
Date: 2026-07-19 09:00:04 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
Queries generating the largest temporary files
Rank Size Query 1 22.72 MiB UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 07:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2 22.72 MiB UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 10:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3 22.72 MiB UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 12:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4 22.72 MiB UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 08:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5 22.72 MiB UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 16:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
6 22.72 MiB UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 20:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
7 11.36 MiB SELECT * FROM ( select ;[ Date: 2026-07-19 09:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8 11.36 MiB UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 09:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
9 11.36 MiB SELECT * FROM ( select ;[ Date: 2026-07-19 11:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
10 11.36 MiB UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 11:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
11 11.36 MiB SELECT * FROM ( select ;[ Date: 2026-07-19 13:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
12 11.36 MiB UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 13:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
13 11.36 MiB SELECT * FROM ( select ;[ Date: 2026-07-19 14:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
14 11.36 MiB UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 14:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
15 11.36 MiB SELECT * FROM ( select ;[ Date: 2026-07-19 15:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
16 11.36 MiB UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 15:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
17 11.36 MiB SELECT * FROM ( select ;[ Date: 2026-07-19 17:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
18 11.36 MiB UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select prod.upc AS referencekey_id, ad_column_identifier ('m_proudct', prod.upc, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'UPC duplicado: ' || prod.upc AS description, 'Y' AS isActive, prod.ad_org_id, prod.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_product prod where prod.upc is not null and prod.upc <> '' group by prod.upc, prod.ad_org_id, prod.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 17:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
19 11.36 MiB SELECT * FROM ( select ;[ Date: 2026-07-19 18:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
20 11.36 MiB SELECT * FROM ( select ;[ Date: 2026-07-19 19:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 6.85 sec Highest CPU-cost vacuum
Table public.c_invoice
Database etendo - 2026-07-19 18:12:49 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 6.85 sec Highest CPU-cost vacuum
Table public.c_invoice
Database etendo - 2026-07-19 18:12:49 Date
Analyzes per table
Key values
- profile.last_stat_user_functions_srv1 (15) Main table analyzed (database etendo)
- 106 analyzes Total
Table Number of analyzes etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.last_stat_tables_srv1 15 etendo.profile.last_stat_indexes_srv1 15 etendo.profile.last_stat_statements_srv1 15 etendo.profile.last_stat_io 8 etendo.profile.tables_list 7 etendo.profile.last_extension_versions 5 etendo.profile.last_stat_activity_count_srv1 4 etendo.profile.stmt_list 3 etendo.profile.indexes_list 3 etendo.public.c_invoice 2 etendo.public.ad_process_request 2 etendo.profile.last_stat_slru 2 etendo.profile.sample_stat_tables_total 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.sample_statements 1 etendo.profile.sample_stat_tables 1 etendo.profile.sample_stat_database 1 etendo.profile.sample_stat_user_functions 1 etendo.profile.sample_stat_io 1 etendo.profile.sample_stat_slru 1 etendo.profile.sample_stat_indexes 1 etendo.profile.funcs_list 1 Total 106 Vacuums per table
Key values
- profile.last_stat_user_functions_srv1 (15) Main table vacuumed on database etendo
- 82 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples etendo.profile.last_stat_user_functions_srv1 15 15 2,591 0 41 0 0 1,540 42 337,109 0 0 etendo.profile.last_stat_tables_srv1 15 15 15,390 0 225 0 0 11,610 229 1,631,779 0 0 etendo.profile.last_stat_indexes_srv1 15 15 20,555 0 368 0 0 14,988 375 2,322,799 0 0 etendo.profile.last_stat_statements_srv1 15 15 4,831 0 70 0 0 2,831 78 537,103 0 0 etendo.profile.tables_list 5 5 858 0 23 0 0 473 20 160,536 3 60 etendo.profile.last_stat_io 4 4 296 0 18 0 0 29 9 67,224 0 0 etendo.profile.stmt_list 2 2 536 0 49 0 0 312 29 215,467 4 6 etendo.profile.indexes_list 2 2 254 0 8 0 0 68 4 38,593 0 0 etendo.profile.last_stat_activity_count_srv1 2 0 44 0 10 0 0 12 4 32,544 0 0 etendo.profile.last_extension_versions 2 2 102 0 10 0 0 10 4 33,572 0 0 etendo.pg_toast.pg_toast_2619 1 1 791 0 152 0 0 459 128 289,694 42 88 etendo.public.c_invoice 1 1 67,159 0 28,346 0 0 33,781 2,961 3,698,978 0 0 etendo.profile.sample_stat_user_functions 1 1 257 0 87 0 0 100 3 25,693 0 0 etendo.profile.last_stat_database_srv1 1 1 50 0 5 0 0 6 2 12,434 0 0 etendo.profile.last_stat_slru 1 1 70 0 5 0 0 5 2 16,696 0 0 Total 82 80 113,784 5,663 29,417 0 0 66,224 3,890 9,420,221 49 154 Vacuum throughput per table
Key values
- public.c_invoice (6.85) Max CPU elapsed for vacuum on database etendo
- unknown (0 ms) Max I/O read time for vacuum on database etendo
- unknown (0 ms) Max I/O write time for vacuum on database etendo
I/O timing (ms) CPU (s) Table read write elapsed etendo.profile.last_stat_user_functions_srv1 0 0 0 etendo.profile.last_stat_tables_srv1 0 0 0.15 etendo.profile.last_stat_indexes_srv1 0 0 0.29 etendo.profile.last_stat_statements_srv1 0 0 0 etendo.profile.tables_list 0 0 0 etendo.profile.last_stat_io 0 0 0 etendo.profile.stmt_list 0 0 0 etendo.profile.indexes_list 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.last_extension_versions 0 0 0 etendo.pg_toast.pg_toast_2619 0 0 0.04 etendo.public.c_invoice 0 0 6.85 etendo.profile.sample_stat_user_functions 0 0 0.02 etendo.profile.last_stat_database_srv1 0 0 0 etendo.profile.last_stat_slru 0 0 0 Total 0 0 7.35 Tuples removed per table
Key values
- profile.last_stat_indexes_srv1 (94000) Main table with removed tuples on database etendo
- 171833 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.profile.last_stat_indexes_srv1 15 15 94,000 46,560 0 630 5,098 etendo.profile.last_stat_tables_srv1 15 15 57,745 27,525 0 191 4,272 etendo.profile.last_stat_statements_srv1 15 15 9,569 6,710 0 124 845 etendo.profile.last_stat_user_functions_srv1 15 15 7,765 7,095 0 0 480 etendo.public.c_invoice 1 1 1,044 204,823 0 0 28,450 etendo.profile.tables_list 5 5 740 4,985 0 0 150 etendo.pg_toast.pg_toast_2619 1 1 363 1,705 0 0 631 etendo.profile.last_stat_io 4 4 147 64 0 0 8 etendo.profile.last_extension_versions 2 2 108 18 0 0 2 etendo.profile.stmt_list 2 2 100 1,575 0 0 142 etendo.profile.sample_stat_user_functions 1 1 87 8,798 0 0 84 etendo.profile.indexes_list 2 2 58 710 0 0 20 etendo.profile.last_stat_slru 1 1 55 5 0 0 1 etendo.profile.last_stat_activity_count_srv1 2 0 48 0 0 2 0 etendo.profile.last_stat_database_srv1 1 1 4 4 0 0 1 Total 82 80 171,833 310,577 0 947 40,184 Pages removed per table
Key values
- profile.last_stat_indexes_srv1 (630) Main table with removed pages on database etendo
- 947 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed etendo.profile.last_stat_indexes_srv1 15 15 94000 630 etendo.profile.last_stat_tables_srv1 15 15 57745 191 etendo.profile.last_stat_statements_srv1 15 15 9569 124 etendo.profile.last_stat_activity_count_srv1 2 0 48 2 etendo.pg_toast.pg_toast_2619 1 1 363 0 etendo.profile.stmt_list 2 2 100 0 etendo.public.c_invoice 1 1 1044 0 etendo.profile.last_stat_user_functions_srv1 15 15 7765 0 etendo.profile.indexes_list 2 2 58 0 etendo.profile.sample_stat_user_functions 1 1 87 0 etendo.profile.tables_list 5 5 740 0 etendo.profile.last_stat_io 4 4 147 0 etendo.profile.last_stat_database_srv1 1 1 4 0 etendo.profile.last_extension_versions 2 2 108 0 etendo.profile.last_stat_slru 1 1 55 0 Total 82 80 171,833 947 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 19 07 5 8 08 6 5 09 6 7 10 5 4 11 5 10 12 6 6 13 5 7 14 5 8 15 4 5 16 7 7 17 6 9 18 6 7 19 5 6 20 6 11 21 5 6 - 6.85 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
- 16 Total read queries
- 0 Total write queries
Queries by database
Key values
- etendo Main database
- 16 Requests
- 18s459ms (etendo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 16 Requests
User Request type Count Duration tad Total 16 18s459ms select 16 18s459ms Duration by user
Key values
- 18s459ms (tad) Main time consuming user
User Request type Count Duration tad Total 16 18s459ms select 16 18s459ms Queries by host
Key values
- 127.0.0.1 Main host
- 16 Requests
- 18s459ms (127.0.0.1)
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 16 Requests
- 18s459ms (openbravo)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-19 17:34:39 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 16 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1s305ms SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 19:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
2 1s237ms SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 17:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3 1s203ms SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 20:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
4 1s188ms SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 11:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
5 1s187ms SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 07:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
6 1s187ms SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 13:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
7 1s176ms SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 21:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
8 1s143ms SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 09:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
9 1s122ms SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 08:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
10 1s112ms SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 14:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
11 1s112ms SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 10:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
12 1s110ms SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 16:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
13 1s104ms SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 15:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
14 1s94ms SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 12:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
15 1s87ms select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> 0 OR COALESCE(sd.qtyorderonhand, 0) <> 0 union ALL select m_product_id, null, 0, 0 FROM m_product p WHERE p.isgeneric = 'N') as ps where ((ps.qtyonhand <> 0 AND EXISTS ( SELECT 1 FROM m_locator ml WHERE ml.m_locator_id = ps.m_locator_id AND EXISTS ( SELECT 1 FROM AD_Org_Warehouse ow WHERE ml.m_warehouse_id = ow.m_warehouse_id AND ow.ad_org_id IN ('FF80818134D2AA330134F1D03034277D', 'FF80818133B7413E0133B71974AD28C6')))) OR (EXISTS ( SELECT 1 FROM m_product mp WHERE ps.m_product_id = mp.m_product_id AND mp.isstocked = 'N' AND mp.producttype = 'I' AND ad_client_id = 'FF80818133B7413E0133B7164D6A0002'))) AND NOT EXISTS ( select 1 from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = '52ABADF5F9C04311B0A0E8FD21244670') AND exists ( select 1 from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = 'Y' and mp.producttype = 'I' and ad_client_id = 'FF80818133B7413E0133B7164D6A0002');[ Date: 2026-07-19 20:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
16 1s85ms SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 18:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 17s371ms 15 1s85ms 1s305ms 1s158ms select * from ( select o.c_order_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || ad_column_identifier (?, o.c_order_id, ?) || ? || sum(ol.linenetamt) || ? || o.totallines as description, ? as isactive, o.ad_org_id as ad_org_id, o.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, o.c_order_id, ?) as record_id from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 07 1 1s187ms 1s187ms 08 1 1s122ms 1s122ms 09 1 1s143ms 1s143ms 10 1 1s112ms 1s112ms 11 1 1s188ms 1s188ms 12 1 1s94ms 1s94ms 13 1 1s187ms 1s187ms 14 1 1s112ms 1s112ms 15 1 1s104ms 1s104ms 16 1 1s110ms 1s110ms 17 1 1s237ms 1s237ms 18 1 1s85ms 1s85ms 19 1 1s305ms 1s305ms 20 1 1s203ms 1s203ms 21 1 1s176ms 1s176ms [ User: tad - Total duration: 17s371ms - Times executed: 15 ]
[ Application: openbravo - Total duration: 17s371ms - Times executed: 15 ]
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 19:00:01 Duration: 1s305ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 17:00:01 Duration: 1s237ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 20:00:01 Duration: 1s203ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 1s87ms 1 1s87ms 1s87ms 1s87ms select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> ? or coalesce(sd.qtyorderonhand, ?) <> ? union all select m_product_id, null, ?, ? from m_product p where p.isgeneric = ?) as ps where ((ps.qtyonhand <> ? and exists ( select ? from m_locator ml where ml.m_locator_id = ps.m_locator_id and exists ( select ? from ad_org_warehouse ow where ml.m_warehouse_id = ow.m_warehouse_id and ow.ad_org_id in (...)))) or (exists ( select ? from m_product mp where ps.m_product_id = mp.m_product_id and mp.isstocked = ? and mp.producttype = ? and ad_client_id = ?))) and not exists ( select ? from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = ?) and exists ( select ? from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = ? and mp.producttype = ? and ad_client_id = ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 20 1 1s87ms 1s87ms [ User: tad - Total duration: 1s87ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 1s87ms - Times executed: 1 ]
-
select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> 0 OR COALESCE(sd.qtyorderonhand, 0) <> 0 union ALL select m_product_id, null, 0, 0 FROM m_product p WHERE p.isgeneric = 'N') as ps where ((ps.qtyonhand <> 0 AND EXISTS ( SELECT 1 FROM m_locator ml WHERE ml.m_locator_id = ps.m_locator_id AND EXISTS ( SELECT 1 FROM AD_Org_Warehouse ow WHERE ml.m_warehouse_id = ow.m_warehouse_id AND ow.ad_org_id IN ('FF80818134D2AA330134F1D03034277D', 'FF80818133B7413E0133B71974AD28C6')))) OR (EXISTS ( SELECT 1 FROM m_product mp WHERE ps.m_product_id = mp.m_product_id AND mp.isstocked = 'N' AND mp.producttype = 'I' AND ad_client_id = 'FF80818133B7413E0133B7164D6A0002'))) AND NOT EXISTS ( select 1 from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = '52ABADF5F9C04311B0A0E8FD21244670') AND exists ( select 1 from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = 'Y' and mp.producttype = 'I' and ad_client_id = 'FF80818133B7413E0133B7164D6A0002');
Date: 2026-07-19 20:00:01 Duration: 1s87ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 15 17s371ms 1s85ms 1s305ms 1s158ms select * from ( select o.c_order_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || ad_column_identifier (?, o.c_order_id, ?) || ? || sum(ol.linenetamt) || ? || o.totallines as description, ? as isactive, o.ad_org_id as ad_org_id, o.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, o.c_order_id, ?) as record_id from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 07 1 1s187ms 1s187ms 08 1 1s122ms 1s122ms 09 1 1s143ms 1s143ms 10 1 1s112ms 1s112ms 11 1 1s188ms 1s188ms 12 1 1s94ms 1s94ms 13 1 1s187ms 1s187ms 14 1 1s112ms 1s112ms 15 1 1s104ms 1s104ms 16 1 1s110ms 1s110ms 17 1 1s237ms 1s237ms 18 1 1s85ms 1s85ms 19 1 1s305ms 1s305ms 20 1 1s203ms 1s203ms 21 1 1s176ms 1s176ms [ User: tad - Total duration: 17s371ms - Times executed: 15 ]
[ Application: openbravo - Total duration: 17s371ms - Times executed: 15 ]
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 19:00:01 Duration: 1s305ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 17:00:01 Duration: 1s237ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 20:00:01 Duration: 1s203ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 1 1s87ms 1s87ms 1s87ms 1s87ms select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> ? or coalesce(sd.qtyorderonhand, ?) <> ? union all select m_product_id, null, ?, ? from m_product p where p.isgeneric = ?) as ps where ((ps.qtyonhand <> ? and exists ( select ? from m_locator ml where ml.m_locator_id = ps.m_locator_id and exists ( select ? from ad_org_warehouse ow where ml.m_warehouse_id = ow.m_warehouse_id and ow.ad_org_id in (...)))) or (exists ( select ? from m_product mp where ps.m_product_id = mp.m_product_id and mp.isstocked = ? and mp.producttype = ? and ad_client_id = ?))) and not exists ( select ? from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = ?) and exists ( select ? from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = ? and mp.producttype = ? and ad_client_id = ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 20 1 1s87ms 1s87ms [ User: tad - Total duration: 1s87ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 1s87ms - Times executed: 1 ]
-
select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> 0 OR COALESCE(sd.qtyorderonhand, 0) <> 0 union ALL select m_product_id, null, 0, 0 FROM m_product p WHERE p.isgeneric = 'N') as ps where ((ps.qtyonhand <> 0 AND EXISTS ( SELECT 1 FROM m_locator ml WHERE ml.m_locator_id = ps.m_locator_id AND EXISTS ( SELECT 1 FROM AD_Org_Warehouse ow WHERE ml.m_warehouse_id = ow.m_warehouse_id AND ow.ad_org_id IN ('FF80818134D2AA330134F1D03034277D', 'FF80818133B7413E0133B71974AD28C6')))) OR (EXISTS ( SELECT 1 FROM m_product mp WHERE ps.m_product_id = mp.m_product_id AND mp.isstocked = 'N' AND mp.producttype = 'I' AND ad_client_id = 'FF80818133B7413E0133B7164D6A0002'))) AND NOT EXISTS ( select 1 from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = '52ABADF5F9C04311B0A0E8FD21244670') AND exists ( select 1 from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = 'Y' and mp.producttype = 'I' and ad_client_id = 'FF80818133B7413E0133B7164D6A0002');
Date: 2026-07-19 20:00:01 Duration: 1s87ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1s85ms 1s305ms 1s158ms 15 17s371ms select * from ( select o.c_order_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || ad_column_identifier (?, o.c_order_id, ?) || ? || sum(ol.linenetamt) || ? || o.totallines as description, ? as isactive, o.ad_org_id as ad_org_id, o.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, o.c_order_id, ?) as record_id from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 07 1 1s187ms 1s187ms 08 1 1s122ms 1s122ms 09 1 1s143ms 1s143ms 10 1 1s112ms 1s112ms 11 1 1s188ms 1s188ms 12 1 1s94ms 1s94ms 13 1 1s187ms 1s187ms 14 1 1s112ms 1s112ms 15 1 1s104ms 1s104ms 16 1 1s110ms 1s110ms 17 1 1s237ms 1s237ms 18 1 1s85ms 1s85ms 19 1 1s305ms 1s305ms 20 1 1s203ms 1s203ms 21 1 1s176ms 1s176ms [ User: tad - Total duration: 17s371ms - Times executed: 15 ]
[ Application: openbravo - Total duration: 17s371ms - Times executed: 15 ]
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 19:00:01 Duration: 1s305ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 17:00:01 Duration: 1s237ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select o.c_order_id AS REFERENCEKEY_ID, '0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Check totals of the next order ' || AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') || ' Lines: ' || sum(ol.linenetamt) || ' , Order: ' || o.totallines as DESCRIPTION, 'Y' AS ISACTIVE, o.AD_ORG_ID AS AD_ORG_ID, o.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, '0' AS CREATEDBY, now() AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('c_order', o.c_order_id, 'es_ES') AS RECORD_ID from c_order o left join c_orderline ol on ol.c_order_id = o.c_order_id group by o.totallines, o.c_order_id having sum(ol.linenetamt) <> o.totallines) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '92F0537DB3A4485E95386FF56E727C80' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 20:00:01 Duration: 1s203ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 1s87ms 1s87ms 1s87ms 1 1s87ms select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> ? or coalesce(sd.qtyorderonhand, ?) <> ? union all select m_product_id, null, ?, ? from m_product p where p.isgeneric = ?) as ps where ((ps.qtyonhand <> ? and exists ( select ? from m_locator ml where ml.m_locator_id = ps.m_locator_id and exists ( select ? from ad_org_warehouse ow where ml.m_warehouse_id = ow.m_warehouse_id and ow.ad_org_id in (...)))) or (exists ( select ? from m_product mp where ps.m_product_id = mp.m_product_id and mp.isstocked = ? and mp.producttype = ? and ad_client_id = ?))) and not exists ( select ? from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = ?) and exists ( select ? from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = ? and mp.producttype = ? and ad_client_id = ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 20 1 1s87ms 1s87ms [ User: tad - Total duration: 1s87ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 1s87ms - Times executed: 1 ]
-
select distinct ps.m_product_id as product_id from ( select m_product_id, sd.m_locator_id, sd.qtyonhand, sd.qtyorderonhand from m_storage_detail sd where sd.qtyonhand <> 0 OR COALESCE(sd.qtyorderonhand, 0) <> 0 union ALL select m_product_id, null, 0, 0 FROM m_product p WHERE p.isgeneric = 'N') as ps where ((ps.qtyonhand <> 0 AND EXISTS ( SELECT 1 FROM m_locator ml WHERE ml.m_locator_id = ps.m_locator_id AND EXISTS ( SELECT 1 FROM AD_Org_Warehouse ow WHERE ml.m_warehouse_id = ow.m_warehouse_id AND ow.ad_org_id IN ('FF80818134D2AA330134F1D03034277D', 'FF80818133B7413E0133B71974AD28C6')))) OR (EXISTS ( SELECT 1 FROM m_product mp WHERE ps.m_product_id = mp.m_product_id AND mp.isstocked = 'N' AND mp.producttype = 'I' AND ad_client_id = 'FF80818133B7413E0133B7164D6A0002'))) AND NOT EXISTS ( select 1 from obretco_prol_product obp where ps.m_product_id = obp.m_product_id and obp.obretco_productlist_id = '52ABADF5F9C04311B0A0E8FD21244670') AND exists ( select 1 from m_product mp where ps.m_product_id = mp.m_product_id and mp.issold = 'Y' and mp.producttype = 'I' and ad_client_id = 'FF80818133B7413E0133B7164D6A0002');
Date: 2026-07-19 20:00:01 Duration: 1s87ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 13,613 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Events per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET