pgBadger-
Global information
- Generated on Sun Jul 19 23:00:07 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 51,196 log entries in 6s
- Log start from 2026-07-19 07:00:01 to 2026-07-19 21:59:56
-
Overview
Global Stats
- 2 Number of unique normalized queries
- 180 Number of queries
- 10m13s Total query duration
- 2026-07-19 07:02:34 First query
- 2026-07-19 21:52:40 Last query
- 1 queries/s at 2026-07-19 14:02:34 Query peak
- 10m13s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 10m13s Execute total duration
- 798 Number of events
- 10 Number of unique normalized events
- 483 Max number of times the same event was reported
- 0 Number of cancellation
- 18,683 Total number of automatic vacuums
- 187 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 3,265 Total number of sessions
- 22 sessions at 2026-07-19 16:00:01 Session peak
- 1d10h38m39s Total duration of sessions
- 38s199ms Average duration of sessions
- 0 Average queries per session
- 188ms Average queries duration per session
- 38s10ms Average idle time per session
- 3,269 Total number of connections
- 7 connections/s at 2026-07-19 21:00:01 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-19 14:02:34 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-19 14:02:34 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 10m13s 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 12 0ms 5s175ms 3s391ms 6s663ms 6s801ms 6s863ms 08 12 0ms 5s138ms 3s361ms 6s626ms 6s745ms 6s775ms 09 12 0ms 5s193ms 3s391ms 6s712ms 6s800ms 6s829ms 10 12 0ms 5s582ms 3s532ms 6s742ms 7s213ms 7s261ms 11 12 0ms 5s175ms 3s366ms 6s689ms 6s728ms 6s824ms 12 12 0ms 5s126ms 3s375ms 6s724ms 6s744ms 6s788ms 13 12 0ms 5s153ms 3s374ms 6s713ms 6s744ms 6s793ms 14 12 0ms 5s216ms 3s393ms 6s739ms 6s778ms 6s835ms 15 12 0ms 5s225ms 3s390ms 6s649ms 6s784ms 6s926ms 16 12 0ms 5s312ms 3s391ms 6s675ms 6s768ms 6s929ms 17 12 0ms 5s155ms 3s384ms 6s718ms 6s782ms 6s822ms 18 12 0ms 5s349ms 3s453ms 6s695ms 6s933ms 6s985ms 19 12 0ms 5s370ms 3s454ms 6s832ms 6s910ms 6s995ms 20 12 0ms 5s463ms 3s450ms 6s821ms 6s887ms 7s72ms 21 12 0ms 5s309ms 3s450ms 6s816ms 6s913ms 6s939ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 19 07 12 0 3s391ms 0ms 6s663ms 6s855ms 08 12 0 3s361ms 0ms 6s626ms 6s759ms 09 12 0 3s391ms 0ms 6s712ms 6s826ms 10 12 0 3s532ms 0ms 6s742ms 7s217ms 11 12 0 3s366ms 0ms 6s689ms 6s735ms 12 12 0 3s375ms 0ms 6s724ms 6s773ms 13 12 0 3s374ms 0ms 6s713ms 6s773ms 14 12 0 3s393ms 0ms 6s739ms 6s815ms 15 12 0 3s390ms 0ms 6s649ms 6s820ms 16 12 0 3s391ms 0ms 6s675ms 6s852ms 17 12 0 3s384ms 0ms 6s718ms 6s799ms 18 12 0 3s453ms 0ms 6s695ms 6s979ms 19 12 0 3s454ms 0ms 6s832ms 6s949ms 20 12 0 3s450ms 0ms 6s821ms 6s958ms 21 12 0 3s450ms 0ms 6s816ms 6s932ms 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 12 12.00 0.00% 08 0 12 12.00 0.00% 09 0 12 12.00 0.00% 10 0 12 12.00 0.00% 11 0 12 12.00 0.00% 12 0 12 12.00 0.00% 13 0 12 12.00 0.00% 14 0 12 12.00 0.00% 15 0 12 12.00 0.00% 16 0 12 12.00 0.00% 17 0 12 12.00 0.00% 18 0 12 12.00 0.00% 19 0 12 12.00 0.00% 20 0 12 12.00 0.00% 21 0 12 12.00 0.00% Day Hour Count Average / Second Jul 19 07 220 0.06/s 08 217 0.06/s 09 219 0.06/s 10 217 0.06/s 11 217 0.06/s 12 217 0.06/s 13 217 0.06/s 14 217 0.06/s 15 220 0.06/s 16 217 0.06/s 17 219 0.06/s 18 217 0.06/s 19 217 0.06/s 20 217 0.06/s 21 221 0.06/s Day Hour Count Average Duration Average idle time Jul 19 07 217 20ms 0ms 08 217 20ms 0ms 09 219 24s336ms 24s150ms 10 217 21ms 0ms 11 217 21ms 0ms 12 217 20ms 0ms 13 217 20ms 0ms 14 217 21ms 0ms 15 219 2m5s 2m4s 16 217 21ms 0ms 17 217 21ms 0ms 18 219 2m36s 2m36s 19 217 21ms 0ms 20 217 21ms 0ms 21 221 4m20s 4m20s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-07-19 21:00:01 Date
Connections per database
Key values
- etendo Main Database
- 3,269 connections Total
Connections per user
Key values
- tad Main User
- 3,269 connections Total
-
Sessions
Simultaneous sessions
Key values
- 22 sessions Session Peak
- 2026-07-19 16:00:01 Date
Histogram of session times
Key values
- 3,241 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 3,265 sessions Total
Sessions per user
Key values
- tad Main User
- 3,265 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 3,265 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 12,367 buffers Checkpoint Peak
- 2026-07-19 13:30:02 Date
- 809.675 seconds Highest write time
- 0.009 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-07-19 14:47:09 Date
Checkpoints distance
Key values
- 95.36 Mo Distance Peak
- 2026-07-19 21:25:25 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 19 07 2,833 282.919s 0.005s 282.931s 08 2,323 231.642s 0.006s 231.66s 09 3,266 326.093s 0.005s 326.105s 10 3,830 382.367s 0.006s 382.384s 11 2,792 278.621s 0.005s 278.642s 12 2,611 260.873s 0.006s 260.889s 13 14,942 1,066.716s 0.015s 1,066.749s 14 2,815 280.929s 0.005s 280.942s 15 3,014 300.86s 0.005s 300.872s 16 2,401 239.428s 0.005s 239.444s 17 2,414 241.013s 0.004s 241.026s 18 3,214 320.781s 0.005s 320.794s 19 3,034 302.943s 0.005s 302.955s 20 2,287 228.399s 0.004s 228.409s 21 8,598 859.413s 0.009s 859.446s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 19 07 0 2 0 266 0.001s 0.004s 08 0 1 0 412 0.001s 0.004s 09 0 1 0 498 0.001s 0.004s 10 0 1 0 422 0.001s 0.004s 11 0 2 0 447 0.001s 0.004s 12 0 1 0 246 0.001s 0.004s 13 0 4 0 497 0.003s 0.004s 14 0 1 0 586 0.001s 0.004s 15 0 2 0 455 0.001s 0.004s 16 0 1 0 400 0.001s 0.004s 17 0 1 0 281 0.001s 0.004s 18 0 2 0 602 0.001s 0.004s 19 0 1 0 480 0.001s 0.004s 20 0 1 0 262 0.001s 0.004s 21 0 5 0 641 0.001s 0.004s 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 4,794.25 kB 381,494.00 kB 08 4,599.75 kB 251,916.25 kB 09 6,384.75 kB 167,316.00 kB 10 5,011.00 kB 111,650.25 kB 11 5,557.75 kB 75,105.75 kB 12 4,724.25 kB 51,036.25 kB 13 16,608.75 kB 41,543.50 kB 14 5,341.75 kB 30,937.00 kB 15 5,893.50 kB 22,232.00 kB 16 4,719.50 kB 16,343.25 kB 17 4,848.75 kB 12,321.00 kB 18 6,115.75 kB 13,092.25 kB 19 5,915.25 kB 13,148.50 kB 20 4,549.00 kB 11,945.50 kB 21 18,477.50 kB 37,364.25 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 19 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 1.82 sec Highest CPU-cost vacuum
Table public.c_invoice
Database etendo - 2026-07-19 13:05:01 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 1.82 sec Highest CPU-cost vacuum
Table public.c_invoice
Database etendo - 2026-07-19 13:05:01 Date
Analyzes per table
Key values
- profile.last_stat_tables_srv1 (15) Main table analyzed (database etendo)
- 187 analyzes Total
Table Number of analyzes etendo.profile.last_stat_tables_srv1 15 etendo.profile.last_stat_indexes_srv1 15 etendo.public.pramz_product 15 etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.last_stat_statements_srv1 15 etendo.public.prspf_conf 15 etendo.public.ad_process_request 11 etendo.public.prspf_variant 9 etendo.profile.tables_list 9 etendo.public.prspf_product 8 etendo.profile.last_stat_io 8 etendo.public.ad_ep_instance_para 7 etendo.public.m_storage_detail 6 etendo.profile.last_extension_versions 5 etendo.profile.indexes_list 5 etendo.profile.stmt_list 5 etendo.profile.funcs_list 4 etendo.profile.last_stat_activity_count_srv1 4 etendo.profile.last_stat_slru 3 etendo.public.c_invoice 2 etendo.profile.sample_statements 2 etendo.profile.sample_stat_indexes 1 etendo.profile.sample_stat_database 1 etendo.profile.sample_stat_tables_total 1 etendo.profile.sample_stat_user_functions 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.sample_stat_tables 1 etendo.public.ad_process_run 1 etendo.profile.sample_stat_io 1 etendo.profile.sample_stat_slru 1 Total 187 Vacuums per table
Key values
- public.prspf_product (899) Main table vacuumed on database etendo
- 18,683 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.prspf_product 899 0 287,198 0 25 0 0 50 27 216,386 0 0 etendo.public.ad_process_request 899 0 275,340 0 271 0 0 121 56 453,417 0 0 etendo.profile.indexes_list 899 0 101,575 0 36 0 0 36 29 190,912 0 0 etendo.profile.last_stat_tables_srv1 899 0 4,555,491 0 15 0 0 36 17 142,352 0 0 etendo.public.m_storage_detail 899 0 535,865 0 76 0 0 74 43 343,972 5 17 etendo.profile.last_stat_user_functions_srv1 899 0 513,751 0 0 0 0 36 0 17,028 0 0 etendo.public.pramz_product 899 0 177,975 0 44 0 0 59 44 349,147 0 0 etendo.profile.last_stat_indexes_srv1 899 0 5,658,039 0 17 0 0 36 17 141,672 0 0 etendo.profile.last_stat_io 899 0 40,549 0 70 0 0 36 27 212,643 0 0 etendo.profile.funcs_list 899 0 72,397 0 18 0 0 39 1 17,050 0 0 etendo.profile.stmt_list 899 0 292,436 0 35 0 0 36 29 234,760 0 0 etendo.profile.last_stat_statements_srv1 899 0 1,297,344 0 6 0 0 36 0 17,028 0 0 etendo.public.ad_ep_instance_para 899 0 28,674 0 27 0 0 36 0 8,676 0 0 etendo.public.prspf_variant 899 0 299,407 0 30 0 0 86 32 268,918 0 0 etendo.public.prspf_conf 899 0 175,528 0 153 0 0 137 40 336,857 0 0 etendo.profile.tables_list 899 0 160,090 0 25 0 0 36 27 207,720 0 0 etendo.pg_catalog.pg_statistic 890 0 1,840,626 0 453 0 0 140 23 200,021 2 22 etendo.profile.last_extension_versions 779 0 29,918 0 57 0 0 33 26 207,470 0 0 etendo.profile.last_stat_activity_count_srv1 719 0 11,713 0 52 0 0 30 24 175,470 0 0 etendo.pg_toast.pg_toast_2619 536 0 535,376 0 245 0 0 124 34 280,134 0 0 etendo.public.c_invoice 535 0 3,619,840 0 7,646 0 0 6,700 5 443,083 0 0 etendo.profile.last_stat_slru 479 0 16,136 0 36 0 0 21 16 127,868 0 0 etendo.profile.last_stat_database_srv1 360 0 13,283 0 23 0 0 17 9 72,301 0 0 etendo.profile.sample_stat_tables 1 0 2,690 0 1,300 0 0 1,202 2 87,081 0 0 Total 18,683 0 20,541,241 0 10,660 0 0 9,157 528 4,751,966 7 39 Vacuum throughput per table
Key values
- profile.last_stat_indexes_srv1 (61.0900000000003) 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.prspf_product 0 0 0 etendo.public.ad_process_request 0 0 0 etendo.profile.indexes_list 0 0 0 etendo.profile.last_stat_tables_srv1 0 0 47.7399999999999 etendo.public.m_storage_detail 0 0 0.01 etendo.profile.last_stat_user_functions_srv1 0 0 0.06 etendo.public.pramz_product 0 0 0 etendo.profile.last_stat_indexes_srv1 0 0 61.0900000000003 etendo.profile.last_stat_io 0 0 0 etendo.profile.funcs_list 0 0 0 etendo.profile.stmt_list 0 0 0 etendo.profile.last_stat_statements_srv1 0 0 9.01999999999985 etendo.public.ad_ep_instance_para 0 0 0 etendo.public.prspf_variant 0 0 0 etendo.public.prspf_conf 0 0 0 etendo.profile.tables_list 0 0 0 etendo.pg_catalog.pg_statistic 0 0 17.9199999999998 etendo.profile.last_extension_versions 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.pg_toast.pg_toast_2619 0 0 2.66999999999999 etendo.public.c_invoice 0 0 40.8900000000002 etendo.profile.last_stat_slru 0 0 0 etendo.profile.last_stat_database_srv1 0 0 0 etendo.profile.sample_stat_tables 0 0 0.31 Total 0 0 179.71 Tuples removed per table
Key values
- pg_catalog.pg_statistic (10) Main table with removed tuples on database etendo
- 10 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.pg_catalog.pg_statistic 890 0 10 16,477,690 5,823,692 0 953,810 etendo.public.prspf_product 899 0 0 2,727,824 1,364,041 0 118,676 etendo.profile.last_extension_versions 779 0 0 91,143 84,132 0 1,618 etendo.public.ad_process_request 899 0 0 1,035,954 682,865 0 118,653 etendo.profile.indexes_list 899 0 0 951,406 512,693 0 21,336 etendo.profile.last_stat_tables_srv1 899 0 0 43,533,101 41,729,707 0 2,262,624 etendo.public.m_storage_detail 899 0 0 5,569,626 2,220,367 0 212,649 etendo.profile.last_stat_user_functions_srv1 899 0 0 7,579,060 6,995,549 0 241,808 etendo.public.pramz_product 899 0 0 1,095,347 949,709 0 70,270 etendo.profile.last_stat_indexes_srv1 899 0 0 68,904,020 65,936,421 0 2,813,778 etendo.profile.last_stat_io 899 0 0 161,805 148,320 0 3,895 etendo.profile.funcs_list 899 0 0 520,846 263,910 0 15,342 etendo.profile.last_stat_database_srv1 360 0 0 23,760 22,320 0 1,140 etendo.profile.stmt_list 899 0 0 1,615,454 718,126 0 122,201 etendo.profile.last_stat_statements_srv1 899 0 0 11,601,034 10,783,844 0 625,901 etendo.profile.last_stat_activity_count_srv1 719 0 0 71,904 71,904 0 2,097 etendo.profile.sample_stat_tables 1 0 0 37,594 1,468 0 1,305 etendo.pg_toast.pg_toast_2619 536 0 0 1,821,620 462,450 0 525,280 etendo.public.ad_ep_instance_para 899 0 0 149,582 149,582 0 3,369 etendo.profile.last_stat_slru 479 0 0 37,135 34,740 0 779 etendo.public.prspf_variant 899 0 0 2,297,948 1,838,622 0 142,295 etendo.public.prspf_conf 899 0 0 520,835 512,744 0 72,729 etendo.profile.tables_list 899 0 0 2,675,812 1,622,963 0 59,152 etendo.public.c_invoice 535 0 0 20,725,002 7,824,910 0 5,206,131 Total 18,683 0 10 190,225,502 150,755,079 0 13,596,838 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed etendo.public.prspf_product 899 0 0 0 etendo.profile.last_extension_versions 779 0 0 0 etendo.public.ad_process_request 899 0 0 0 etendo.profile.indexes_list 899 0 0 0 etendo.profile.last_stat_tables_srv1 899 0 0 0 etendo.pg_catalog.pg_statistic 890 0 10 0 etendo.public.m_storage_detail 899 0 0 0 etendo.profile.last_stat_user_functions_srv1 899 0 0 0 etendo.public.pramz_product 899 0 0 0 etendo.profile.last_stat_indexes_srv1 899 0 0 0 etendo.profile.last_stat_io 899 0 0 0 etendo.profile.funcs_list 899 0 0 0 etendo.profile.last_stat_database_srv1 360 0 0 0 etendo.profile.stmt_list 899 0 0 0 etendo.profile.last_stat_statements_srv1 899 0 0 0 etendo.profile.last_stat_activity_count_srv1 719 0 0 0 etendo.profile.sample_stat_tables 1 0 0 0 etendo.pg_toast.pg_toast_2619 536 0 0 0 etendo.public.ad_ep_instance_para 899 0 0 0 etendo.profile.last_stat_slru 479 0 0 0 etendo.public.prspf_variant 899 0 0 0 etendo.public.prspf_conf 899 0 0 0 etendo.profile.tables_list 899 0 0 0 etendo.public.c_invoice 535 0 0 0 Total 18,683 0 10 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 19 07 1,011 14 08 1,020 7 09 1,080 15 10 1,141 10 11 1,140 11 12 1,141 13 13 1,231 15 14 1,319 9 15 1,320 18 16 1,380 7 17 1,380 12 18 1,380 16 19 1,380 13 20 1,380 9 21 1,380 18 - 1.82 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
- 180 Total read queries
- 0 Total write queries
Queries by database
Key values
- etendo Main database
- 180 Requests
- 10m13s (etendo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 180 Requests
User Request type Count Duration tad Total 180 10m13s select 180 10m13s Duration by user
Key values
- 10m13s (tad) Main time consuming user
User Request type Count Duration tad Total 180 10m13s select 180 10m13s Queries by host
Key values
- 127.0.0.1 Main host
- 180 Requests
- 10m13s (127.0.0.1)
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 180 Requests
- 10m13s (openbravo)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-19 14:02:34 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 180 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 5s582ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 10:12:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
2 5s578ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 10:32:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3 5s575ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 10:22:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
4 5s463ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 20:32:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
5 5s370ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 19:02:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
6 5s349ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 18:32:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
7 5s343ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 10:42:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
8 5s326ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 20:22:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
9 5s319ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 10:52:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
10 5s312ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 16:52:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
11 5s309ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 21:52:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
12 5s293ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 19:42:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
13 5s291ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 18:52:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
14 5s289ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 19:32:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
15 5s284ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 18:12:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
16 5s278ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 18:22:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
17 5s277ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 21:42:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
18 5s267ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 20:52:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
19 5s264ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 21:32:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
20 5s261ms SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 18:42:40 - 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 7m46s 90 5s9ms 5s582ms 5s180ms select * from ( select op.obwpack_packingh_id as referencekey_id, ad_column_identifier (?, op.obwpack_packingh_id, ?) as record_id, ? as ad_role_id, null as ad_user_id, ? || op.documentno as description, ? as isactive, op.ad_org_id, op.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from obwpack_packingh op where op.created > ? and exists ( select ? from prpp_box pb where pb.obwpack_packingh_id = op.obwpack_packingh_id group by pb.boxno, case when pb.parent_box_id is null then ? else ? end having count(*) > ?)) 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 6 30s813ms 5s135ms 08 6 30s526ms 5s87ms 09 6 30s802ms 5s133ms 10 6 32s503ms 5s417ms 11 6 30s580ms 5s96ms 12 6 30s603ms 5s100ms 13 6 30s629ms 5s104ms 14 6 30s897ms 5s149ms 15 6 30s846ms 5s141ms 16 6 30s909ms 5s151ms 17 6 30s714ms 5s119ms 18 6 31s535ms 5s255ms 19 6 31s659ms 5s276ms 20 6 31s657ms 5s276ms 21 6 31s525ms 5s254ms [ User: tad - Total duration: 7m46s - Times executed: 90 ]
[ Application: openbravo - Total duration: 7m46s - Times executed: 90 ]
-
SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 10:12:40 Duration: 5s582ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 10:32:40 Duration: 5s578ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 10:22:40 Duration: 5s575ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 2m27s 90 1s606ms 1s701ms 1s641ms select * from ( select fact_acct.fact_acct_id as referencekey_id, ad_column_identifier (?, fact_acct_id, ?) as record_id, ? as ad_role_id, null as ad_user_id, to_char(fact_acct.dateacct, ?) || ? || fact_acct.acctvalue || ? || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ? || aoacct.name || ? || aocelemtn.name as description, ? as isactive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, ?) = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, ?) = aocelemtn.ad_org_id where fact_acct.updated >= now() ? and aoacct.ad_org_id <> aocelemtn.ad_org_id) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 07 6 9s879ms 1s646ms 08 6 9s812ms 1s635ms 09 6 9s900ms 1s650ms 10 6 9s884ms 1s647ms 11 6 9s822ms 1s637ms 12 6 9s906ms 1s651ms 13 6 9s866ms 1s644ms 14 6 9s819ms 1s636ms 15 6 9s839ms 1s639ms 16 6 9s783ms 1s630ms 17 6 9s901ms 1s650ms 18 6 9s901ms 1s650ms 19 6 9s794ms 1s632ms 20 6 9s754ms 1s625ms 21 6 9s881ms 1s646ms [ User: tad - Total duration: 2m27s - Times executed: 90 ]
[ Application: openbravo - Total duration: 2m27s - Times executed: 90 ]
-
SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 07:32:34 Duration: 1s701ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 15:22:34 Duration: 1s700ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 18:22:34 Duration: 1s700ms 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 90 7m46s 5s9ms 5s582ms 5s180ms select * from ( select op.obwpack_packingh_id as referencekey_id, ad_column_identifier (?, op.obwpack_packingh_id, ?) as record_id, ? as ad_role_id, null as ad_user_id, ? || op.documentno as description, ? as isactive, op.ad_org_id, op.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from obwpack_packingh op where op.created > ? and exists ( select ? from prpp_box pb where pb.obwpack_packingh_id = op.obwpack_packingh_id group by pb.boxno, case when pb.parent_box_id is null then ? else ? end having count(*) > ?)) 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 6 30s813ms 5s135ms 08 6 30s526ms 5s87ms 09 6 30s802ms 5s133ms 10 6 32s503ms 5s417ms 11 6 30s580ms 5s96ms 12 6 30s603ms 5s100ms 13 6 30s629ms 5s104ms 14 6 30s897ms 5s149ms 15 6 30s846ms 5s141ms 16 6 30s909ms 5s151ms 17 6 30s714ms 5s119ms 18 6 31s535ms 5s255ms 19 6 31s659ms 5s276ms 20 6 31s657ms 5s276ms 21 6 31s525ms 5s254ms [ User: tad - Total duration: 7m46s - Times executed: 90 ]
[ Application: openbravo - Total duration: 7m46s - Times executed: 90 ]
-
SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 10:12:40 Duration: 5s582ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 10:32:40 Duration: 5s578ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 10:22:40 Duration: 5s575ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 90 2m27s 1s606ms 1s701ms 1s641ms select * from ( select fact_acct.fact_acct_id as referencekey_id, ad_column_identifier (?, fact_acct_id, ?) as record_id, ? as ad_role_id, null as ad_user_id, to_char(fact_acct.dateacct, ?) || ? || fact_acct.acctvalue || ? || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ? || aoacct.name || ? || aocelemtn.name as description, ? as isactive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, ?) = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, ?) = aocelemtn.ad_org_id where fact_acct.updated >= now() ? and aoacct.ad_org_id <> aocelemtn.ad_org_id) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 07 6 9s879ms 1s646ms 08 6 9s812ms 1s635ms 09 6 9s900ms 1s650ms 10 6 9s884ms 1s647ms 11 6 9s822ms 1s637ms 12 6 9s906ms 1s651ms 13 6 9s866ms 1s644ms 14 6 9s819ms 1s636ms 15 6 9s839ms 1s639ms 16 6 9s783ms 1s630ms 17 6 9s901ms 1s650ms 18 6 9s901ms 1s650ms 19 6 9s794ms 1s632ms 20 6 9s754ms 1s625ms 21 6 9s881ms 1s646ms [ User: tad - Total duration: 2m27s - Times executed: 90 ]
[ Application: openbravo - Total duration: 2m27s - Times executed: 90 ]
-
SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 07:32:34 Duration: 1s701ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 15:22:34 Duration: 1s700ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 18:22:34 Duration: 1s700ms 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 5s9ms 5s582ms 5s180ms 90 7m46s select * from ( select op.obwpack_packingh_id as referencekey_id, ad_column_identifier (?, op.obwpack_packingh_id, ?) as record_id, ? as ad_role_id, null as ad_user_id, ? || op.documentno as description, ? as isactive, op.ad_org_id, op.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from obwpack_packingh op where op.created > ? and exists ( select ? from prpp_box pb where pb.obwpack_packingh_id = op.obwpack_packingh_id group by pb.boxno, case when pb.parent_box_id is null then ? else ? end having count(*) > ?)) 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 6 30s813ms 5s135ms 08 6 30s526ms 5s87ms 09 6 30s802ms 5s133ms 10 6 32s503ms 5s417ms 11 6 30s580ms 5s96ms 12 6 30s603ms 5s100ms 13 6 30s629ms 5s104ms 14 6 30s897ms 5s149ms 15 6 30s846ms 5s141ms 16 6 30s909ms 5s151ms 17 6 30s714ms 5s119ms 18 6 31s535ms 5s255ms 19 6 31s659ms 5s276ms 20 6 31s657ms 5s276ms 21 6 31s525ms 5s254ms [ User: tad - Total duration: 7m46s - Times executed: 90 ]
[ Application: openbravo - Total duration: 7m46s - Times executed: 90 ]
-
SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 10:12:40 Duration: 5s582ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 10:32:40 Duration: 5s578ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 10:22:40 Duration: 5s575ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 1s606ms 1s701ms 1s641ms 90 2m27s select * from ( select fact_acct.fact_acct_id as referencekey_id, ad_column_identifier (?, fact_acct_id, ?) as record_id, ? as ad_role_id, null as ad_user_id, to_char(fact_acct.dateacct, ?) || ? || fact_acct.acctvalue || ? || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ? || aoacct.name || ? || aocelemtn.name as description, ? as isactive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, ?) = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, ?) = aocelemtn.ad_org_id where fact_acct.updated >= now() ? and aoacct.ad_org_id <> aocelemtn.ad_org_id) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 07 6 9s879ms 1s646ms 08 6 9s812ms 1s635ms 09 6 9s900ms 1s650ms 10 6 9s884ms 1s647ms 11 6 9s822ms 1s637ms 12 6 9s906ms 1s651ms 13 6 9s866ms 1s644ms 14 6 9s819ms 1s636ms 15 6 9s839ms 1s639ms 16 6 9s783ms 1s630ms 17 6 9s901ms 1s650ms 18 6 9s901ms 1s650ms 19 6 9s794ms 1s632ms 20 6 9s754ms 1s625ms 21 6 9s881ms 1s646ms [ User: tad - Total duration: 2m27s - Times executed: 90 ]
[ Application: openbravo - Total duration: 2m27s - Times executed: 90 ]
-
SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 07:32:34 Duration: 1s701ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 15:22:34 Duration: 1s700ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( SELECT fact_acct.fact_acct_id AS referencekey_id, ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '73EB48F710A6426880F84796DA997424' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 18:22:34 Duration: 1s700ms 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
- 34,373 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 499 FATAL entries
- 298 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 483 Max number of times the same event was reported
- 798 Total events found
Rank Times reported Error 1 483 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", no encryption
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 19 07 28 08 26 09 24 10 33 11 35 12 33 13 32 14 33 15 36 16 33 17 34 18 33 19 34 20 36 21 33 - FATAL: no pg_hba.conf entry for host "186.236.254.56", user "pgsql", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "159.65.148.75", user "postgresql", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "186.236.254.56", user "pgsql", database "postgres", no encryption
Date: 2026-07-19 07:03:25 Database: postgres Application: [unknown] User: pgsql Remote: 186.236.254.56
Date: 2026-07-19 07:05:32 Database: postgres Application: [unknown] User: postgresql Remote: 159.65.148.75
Date: 2026-07-19 07:07:08 Database: postgres Application: [unknown] User: pgsql Remote: 186.236.254.56
2 296 ERROR: @PRSPF_PrspfProductUnique@
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 19 07 37 09 37 11 37 13 37 15 37 17 37 19 37 21 37 - ERROR: @PRSPF_PrspfProductUnique@
- ERROR: @PRSPF_PrspfProductUnique@
- ERROR: @PRSPF_PrspfProductUnique@
Context: PL/pgSQL function prspf_product_uniq_trg() line 31 at RAISE
Statement: update prspf_product set Updated=$1, M_Product_ID=$2 where Prspf_Product_ID=$3Date: 2026-07-19 07:35:34 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Context: PL/pgSQL function prspf_product_uniq_trg() line 31 at RAISE
Statement: update prspf_product set Updated=$1, M_Product_ID=$2 where Prspf_Product_ID=$3Date: 2026-07-19 07:35:38 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Context: PL/pgSQL function prspf_product_uniq_trg() line 31 at RAISE
Statement: update prspf_product set Updated=$1, M_Product_ID=$2 where Prspf_Product_ID=$3Date: 2026-07-19 07:35:40 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
3 4 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 19 11 2 19 1 21 1 - FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Date: 2026-07-19 11:13:25 Database: [unknown] Application: [unknown] User: [unknown] Remote: 3.130.168.2
Date: 2026-07-19 11:54:54 Database: [unknown] Application: [unknown] User: [unknown] Remote: 209.141.46.157
Date: 2026-07-19 19:49:57 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.172.131
4 4 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 19 11 2 19 1 21 1 - FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Date: 2026-07-19 11:13:25 Database: [unknown] Application: [unknown] User: [unknown] Remote: 3.130.168.2
Date: 2026-07-19 11:54:53 Database: [unknown] Application: [unknown] User: [unknown] Remote: 209.141.46.157
Date: 2026-07-19 19:49:56 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.172.131
5 4 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 19 11 2 19 1 21 1 - FATAL: no PostgreSQL user name specified in startup packet
- FATAL: no PostgreSQL user name specified in startup packet
- FATAL: no PostgreSQL user name specified in startup packet
Date: 2026-07-19 11:13:25 Database: [unknown] Application: [unknown] User: [unknown] Remote: 3.130.168.2
Date: 2026-07-19 11:54:54 Database: [unknown] Application: [unknown] User: [unknown] Remote: 209.141.46.157
Date: 2026-07-19 19:49:57 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.172.131
6 3 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL encryption
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 19 11 1 19 1 20 1 - FATAL: no pg_hba.conf entry for host "64.89.163.82", user "postgres", database "postgres", SSL encryption
- FATAL: no pg_hba.conf entry for host "35.241.166.201", user "postgres", database "postgres", SSL encryption
- FATAL: no pg_hba.conf entry for host "64.89.163.83", user "postgres", database "postgres", SSL encryption
Date: 2026-07-19 11:09:06 Database: postgres Application: [unknown] User: postgres Remote: 64.89.163.82
Date: 2026-07-19 19:09:25 Database: postgres Application: [unknown] User: postgres Remote: 35.241.166.201
Date: 2026-07-19 20:12:47 Database: postgres Application: [unknown] User: postgres Remote: 64.89.163.83
7 1 FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 19 07 1 - FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
Date: 2026-07-19 07:14:54 Database: [unknown] Application: [unknown] User: [unknown] Remote: 20.119.74.72
8 1 ERROR: @PeriodNotValid@
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 19 18 1 - ERROR: @PeriodNotValid@
Context: PL/pgSQL function gl_journal_chk_restrict_trg() line 77 at RAISE
Statement: insert into GL_Journal (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, C_AcctSchema_ID, C_DocType_ID, DocumentNo, DocStatus, DocAction, IsApproved, IsPrinted, Description, PostingType, GL_Category_ID, DateDoc, DateAcct, C_Period_ID, C_Currency_ID, CurrencyRateType, CurrencyRate, GL_JournalBatch_ID, TotalDr, TotalCr, Processing, Processed, Posted, IsOpening, Multi_Gl, EM_Etblkp_Accountingstatus, EM_Pruti_Revert_Journal, EM_Etblkp_Bulkposting, EM_Etglja_Create_Deferred_Plan, EM_Smfglre_Revert_Gljournal, GL_Journal_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37)Date: 2026-07-19 18:32:53 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
9 1 ERROR: new row for relation "..." violates check constraint "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 19 18 1 - ERROR: new row for relation "gl_journalline" violates check constraint "gl_journalline_mgl_glj_check"
Detail: Failing row contains (F3AF078141434DE6919D040BFB0FC7CF, D9ED1071A3014171ACF14AE11ACDC394, 0642322ABBAC45EF88BC0157BEBBB9A4, Y, 2026-07-19 18:33:28.417, FF8081813431F217013436F58BFF00E9, 2026-07-19 18:33:28.417, FF8081813431F217013436F58BFF00E9, 46BB3367DEB140A4ABB8A4356B935A7B, 10, N, ajuste cuentas financieras, 0, 0, 102, S, 1, 0.00, 0.00, 100, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, N, null, null, null, Y).
Statement: insert into GL_JournalLine (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, GL_Journal_ID, Line, IsGenerated, Description, AmtSourceDr, AmtSourceCr, C_Currency_ID, CurrencyRateType, CurrencyRate, AmtAcctDr, AmtAcctCr, C_UOM_ID, Open_Items, EM_Aprm_Addpayment, GL_JournalLine_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22)Date: 2026-07-19 18:33:28 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
10 1 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 19 15 1 - LOG: could not receive data from client: Connection reset by peer
Date: 2026-07-19 15:16:22 Database: [unknown] Application: [unknown] User: [unknown] Remote: 193.148.61.201