pgBadger-
Global information
- Generated on Tue Jul 14 23:00:08 2026
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 88,034 log entries in 7s
- Log start from 2026-07-14 07:00:01 to 2026-07-14 22:00:00
-
Overview
Global Stats
- 6 Number of unique normalized queries
- 198 Number of queries
- 4m53s Total query duration
- 2026-07-14 07:00:03 First query
- 2026-07-14 21:59:32 Last query
- 1 queries/s at 2026-07-14 11:59:32 Query peak
- 4m53s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4m53s Execute total duration
- 38 Number of events
- 9 Number of unique normalized events
- 16 Max number of times the same event was reported
- 0 Number of cancellation
- 921 Total number of automatic vacuums
- 167 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 10,557 Total number of sessions
- 28 sessions at 2026-07-14 21:00:01 Session peak
- 3d1h33s Total duration of sessions
- 24s896ms Average duration of sessions
- 0 Average queries per session
- 27ms Average queries duration per session
- 24s868ms Average idle time per session
- 10,557 Total number of connections
- 10 connections/s at 2026-07-14 09:35:09 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-14 11:59:32 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-14 11:59:32 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-14 14:19:32 Date
Queries duration
Key values
- 4m53s 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 14 07 11 0ms 2s623ms 1s536ms 1s422ms 2s541ms 3s451ms 08 11 0ms 2s680ms 1s552ms 1s432ms 2s562ms 2s680ms 09 13 0ms 2s692ms 1s489ms 1s529ms 3s446ms 3s741ms 10 15 0ms 2s669ms 1s411ms 2s513ms 3s466ms 3s537ms 11 13 0ms 2s746ms 1s477ms 1s513ms 2s746ms 3s514ms 12 15 0ms 2s700ms 1s405ms 2s518ms 2s700ms 3s496ms 13 15 0ms 2s656ms 1s411ms 2s537ms 3s444ms 3s488ms 14 11 0ms 2s608ms 1s548ms 1s506ms 2s562ms 2s608ms 15 11 0ms 2s634ms 1s549ms 1s424ms 2s580ms 3s537ms 16 12 0ms 2s695ms 1s501ms 1s465ms 2s601ms 3s461ms 17 13 0ms 2s659ms 1s476ms 2s527ms 2s550ms 3s448ms 18 15 0ms 2s700ms 1s413ms 2s431ms 3s442ms 3s489ms 19 18 0ms 4s263ms 1s537ms 2s715ms 3s502ms 4s263ms 20 11 0ms 2s703ms 1s548ms 1s487ms 2s623ms 3s452ms 21 14 0ms 2s629ms 1s444ms 2s494ms 2s629ms 3s524ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 14 07 7 0 1s387ms 0ms 1s408ms 1s523ms 08 6 0 1s461ms 0ms 1s418ms 1s509ms 09 9 0 1s334ms 0ms 1s477ms 2s428ms 10 9 0 1s301ms 0ms 1s407ms 2s462ms 11 8 0 1s351ms 0ms 1s406ms 2s450ms 12 8 0 1s346ms 0ms 1s429ms 2s419ms 13 9 0 1s315ms 0ms 1s480ms 2s439ms 14 6 0 1s467ms 0ms 1s404ms 1s506ms 15 7 0 1s391ms 0ms 1s410ms 1s510ms 16 8 0 1s335ms 0ms 1s419ms 2s425ms 17 7 0 1s418ms 0ms 1s415ms 1s532ms 18 10 0 1s276ms 0ms 1s471ms 2s457ms 19 11 0 1s561ms 0ms 1s544ms 2s510ms 20 8 0 1s338ms 0ms 1s394ms 2s434ms 21 8 0 1s366ms 0ms 1s418ms 2s474ms 22 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 14 07 0 4 0 0 1s798ms 0ms 0ms 1s28ms 08 0 5 0 0 1s661ms 0ms 0ms 1s45ms 09 0 4 0 0 1s838ms 0ms 0ms 1s32ms 10 0 6 0 0 1s575ms 0ms 0ms 1s64ms 11 0 5 0 0 1s678ms 0ms 0ms 1s12ms 12 0 7 0 0 1s473ms 0ms 0ms 1s41ms 13 0 6 0 0 1s556ms 0ms 0ms 1s35ms 14 0 5 0 0 1s645ms 0ms 0ms 1s15ms 15 0 4 0 0 1s825ms 0ms 0ms 1s53ms 16 0 4 0 0 1s832ms 0ms 0ms 1s33ms 17 0 6 0 0 1s544ms 0ms 0ms 1s18ms 18 0 5 0 0 1s689ms 0ms 0ms 1s19ms 19 0 7 0 0 1s498ms 0ms 0ms 1s47ms 20 0 3 0 0 2s110ms 0ms 0ms 1s2ms 21 0 6 0 0 1s548ms 0ms 0ms 1s42ms 22 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 14 07 0 11 11.00 0.00% 08 0 11 11.00 0.00% 09 0 12 12.00 0.00% 10 0 15 15.00 0.00% 11 0 13 13.00 0.00% 12 0 15 15.00 0.00% 13 0 15 15.00 0.00% 14 0 11 11.00 0.00% 15 0 11 11.00 0.00% 16 0 12 12.00 0.00% 17 0 13 13.00 0.00% 18 0 15 15.00 0.00% 19 0 18 18.00 0.00% 20 0 11 11.00 0.00% 21 0 14 14.00 0.00% 22 0 0 0.00 0.00% Day Hour Count Average / Second Jul 14 07 699 0.19/s 08 707 0.20/s 09 706 0.20/s 10 704 0.20/s 11 704 0.20/s 12 703 0.20/s 13 703 0.20/s 14 703 0.20/s 15 704 0.20/s 16 703 0.20/s 17 703 0.20/s 18 703 0.20/s 19 703 0.20/s 20 703 0.20/s 21 705 0.20/s 22 4 0.00/s Day Hour Count Average Duration Average idle time Jul 14 07 703 29s524ms 29s500ms 08 707 35s396ms 35s372ms 09 706 35s763ms 35s735ms 10 704 15s18ms 14s988ms 11 704 30s360ms 30s333ms 12 703 32s85ms 32s55ms 13 703 21s843ms 21s813ms 14 703 26s964ms 26s940ms 15 704 22s690ms 22s666ms 16 703 19s283ms 19s258ms 17 703 34s646ms 34s619ms 18 703 11s602ms 11s571ms 19 703 16s723ms 16s683ms 20 703 21s844ms 21s820ms 21 705 19s619ms 19s591ms 22 0 0ms 0ms -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2026-07-14 09:35:09 Date
Connections per database
Key values
- etendo Main Database
- 10,557 connections Total
Connections per user
Key values
- postgres Main User
- 10,557 connections Total
-
Sessions
Simultaneous sessions
Key values
- 28 sessions Session Peak
- 2026-07-14 21:00:01 Date
Histogram of session times
Key values
- 10,425 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 10,557 sessions Total
Sessions per user
Key values
- postgres Main User
- 10,557 sessions Total
Sessions per host
Key values
- [local] Main Host
- 10,557 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 7,459 buffers Checkpoint Peak
- 2026-07-14 08:06:40 Date
- 270.054 seconds Highest write time
- 0.006 seconds Sync time
Checkpoints Wal files
Key values
- 4 files Wal files usage Peak
- 2026-07-14 08:06:40 Date
Checkpoints distance
Key values
- 107.98 Mo Distance Peak
- 2026-07-14 08:06:40 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 14 07 18,189 1,111.682s 0.013s 1,111.724s 08 19,062 1,119.548s 0.013s 1,119.595s 09 18,020 1,082.09s 0.013s 1,082.137s 10 18,259 1,086.983s 0.017s 1,087.038s 11 18,239 1,090.445s 0.019s 1,090.501s 12 18,032 1,080.605s 0.013s 1,080.649s 13 17,934 1,083.348s 0.02s 1,083.406s 14 18,111 1,078.952s 0.016s 1,079.005s 15 17,833 1,076.327s 0.016s 1,076.377s 16 17,703 1,079.403s 0.012s 1,079.445s 17 17,249 1,070.554s 0.011s 1,070.594s 18 17,559 1,070.405s 0.011s 1,070.443s 19 17,751 1,090.6s 0.015s 1,090.646s 20 17,732 1,084.428s 0.013s 1,084.472s 21 17,308 1,066.639s 0.013s 1,066.683s 22 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 14 07 0 0 7 519 0.002s 0.009s 08 0 0 8 569 0.002s 0.011s 09 0 0 7 423 0.002s 0.011s 10 0 0 7 428 0.002s 0.011s 11 0 0 7 434 0.005s 0.011s 12 0 0 7 412 0.002s 0.01s 13 0 0 7 425 0.004s 0.011s 14 0 0 8 425 0.003s 0.011s 15 0 0 7 429 0.002s 0.011s 16 0 0 7 415 0.002s 0.01s 17 0 0 7 402 0.001s 0.009s 18 0 0 7 395 0.001s 0.008s 19 0 0 7 427 0.002s 0.01s 20 0 0 7 423 0.001s 0.01s 21 0 0 7 400 0.001s 0.009s 22 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 14 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s Day Hour Mean distance Mean estimate Jul 14 07 13,247.33 kB 39,217.11 kB 08 10,990.45 kB 39,116.73 kB 09 10,586.00 kB 38,512.27 kB 10 10,671.27 kB 38,879.45 kB 11 10,696.73 kB 38,831.09 kB 12 11,541.60 kB 39,497.40 kB 13 10,591.45 kB 38,594.82 kB 14 10,535.09 kB 38,404.45 kB 15 10,554.64 kB 38,459.64 kB 16 11,547.80 kB 38,167.30 kB 17 12,726.44 kB 38,613.22 kB 18 14,475.62 kB 40,625.62 kB 19 11,562.30 kB 37,304.50 kB 20 11,678.10 kB 38,800.00 kB 21 12,809.00 kB 38,960.11 kB 22 0.00 kB 0.00 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 14 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 22 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.50 sec Highest CPU-cost vacuum
Table public.c_bpartner
Database etendo - 2026-07-14 09:09:49 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 0.50 sec Highest CPU-cost vacuum
Table public.c_bpartner
Database etendo - 2026-07-14 09:09:49 Date
Analyzes per table
Key values
- public.c_order (30) Main table analyzed (database etendo)
- 167 analyzes Total
Table Number of analyzes etendo.public.c_order 30 etendo.public.c_bpartner 30 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.public.ad_process_request 6 etendo.profile.last_stat_activity_count_srv1 4 etendo.profile.last_extension_versions 4 etendo.profile.tables_list 4 etendo.profile.stmt_list 3 etendo.profile.sample_stat_indexes 2 etendo.profile.sample_stat_user_functions 2 etendo.profile.sample_stat_tables 2 etendo.profile.last_stat_slru 2 etendo.profile.sample_statements 2 etendo.profile.indexes_list 2 etendo.profile.sample_stat_indexes_total 1 etendo.public.ad_process_run 1 etendo.pg_catalog.pg_type 1 etendo.profile.sample_stat_tablespaces 1 etendo.profile.sample_statements_total 1 etendo.pg_catalog.pg_attribute 1 postgres.pg_catalog.pg_shdepend 1 etendo.profile.last_stat_wal 1 etendo.profile.sample_stat_database 1 etendo.profile.sample_stat_tables_total 1 etendo.profile.sample_stat_slru 1 etendo.profile.last_stat_archiver 1 etendo.profile.last_stat_cluster 1 etendo.profile.sample_stat_user_func_total 1 Total 167 Vacuums per table
Key values
- public.c_bpartner (270) Main table vacuumed on database etendo
- 921 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.c_bpartner 270 30 1,313,155 0 49,481 0 0 255,050 48,902 207,958,109 0 0 etendo.profile.last_stat_indexes_srv1 157 15 131,856 0 6,280 0 0 14,183 4,392 3,862,860 0 0 etendo.profile.last_stat_tables_srv1 157 15 105,927 0 4,940 0 0 11,251 3,475 2,827,145 0 0 etendo.profile.last_stat_user_functions_srv1 157 15 21,138 0 810 0 0 1,900 677 2,809,083 0 0 etendo.profile.last_stat_statements_srv1 157 15 32,141 0 1,052 0 0 2,579 916 3,327,075 0 0 etendo.pg_toast.pg_toast_2619 5 5 4,157 0 787 0 268 2,182 696 1,754,484 0 0 etendo.profile.stmt_list 3 3 507 0 11 0 0 164 12 87,269 0 0 etendo.profile.last_extension_versions 2 2 108 0 8 0 0 8 2 16,834 0 0 etendo.profile.tables_list 2 2 353 0 13 0 0 107 10 67,788 0 0 etendo.profile.last_stat_activity_count_srv1 2 0 72 0 7 0 0 12 6 32,980 0 0 etendo.profile.indexes_list 2 2 257 0 14 0 0 36 10 78,141 0 0 etendo.profile.sample_stat_tablespaces 1 1 89 0 8 0 0 9 4 25,514 0 0 etendo.profile.sample_stat_indexes 1 1 513 0 84 0 29 170 46 145,912 0 0 etendo.profile.sample_stat_tables 1 1 2,066 0 439 0 290 764 219 408,702 0 0 etendo.profile.last_stat_database_srv1 1 1 57 0 4 0 0 3 1 5,355 0 0 etendo.profile.sample_stat_user_func_total 1 1 68 0 8 0 0 8 4 25,788 0 0 etendo.profile.last_stat_slru 1 1 55 0 3 0 0 4 0 628 0 0 etendo.profile.sample_stat_user_functions 1 1 364 0 43 0 0 93 24 91,489 0 0 Total 921 111 1,612,883 96 63,992 0 587 288,523 59,396 223,525,156 0 0 Vacuum throughput per table
Key values
- public.c_bpartner (30.7) 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.c_bpartner 0 0 30.7 etendo.profile.last_stat_indexes_srv1 0 0 2.04 etendo.profile.last_stat_tables_srv1 0 0 1.26 etendo.profile.last_stat_user_functions_srv1 0 0 0.15 etendo.profile.last_stat_statements_srv1 0 0 0.23 etendo.pg_toast.pg_toast_2619 0 0 0.2 etendo.profile.stmt_list 0 0 0 etendo.profile.last_extension_versions 0 0 0 etendo.profile.tables_list 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.indexes_list 0 0 0 etendo.profile.sample_stat_tablespaces 0 0 0 etendo.profile.sample_stat_indexes 0 0 0.03 etendo.profile.sample_stat_tables 0 0 0.12 etendo.profile.last_stat_database_srv1 0 0 0 etendo.profile.sample_stat_user_func_total 0 0 0 etendo.profile.last_stat_slru 0 0 0 etendo.profile.sample_stat_user_functions 0 0 0.02 Total 0 0 34.75 Tuples removed per table
Key values
- public.c_bpartner (221243) Main table with removed tuples on database etendo
- 394876 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.public.c_bpartner 270 30 221,243 3,667,500 1,830,960 0 241,650 etendo.profile.last_stat_indexes_srv1 157 15 90,682 1,328,987 858,458 481 56,375 etendo.profile.last_stat_tables_srv1 157 15 58,575 848,344 554,515 356 45,039 etendo.profile.last_stat_statements_srv1 157 15 9,655 170,004 91,472 16 8,030 etendo.profile.last_stat_user_functions_srv1 157 15 9,510 182,344 90,028 0 6,123 etendo.pg_toast.pg_toast_2619 5 5 1,927 9,489 97 0 3,350 etendo.profile.sample_stat_indexes 1 1 1,014 8,588 54 0 169 etendo.profile.sample_stat_tables 1 1 849 26,956 324 0 1,120 etendo.profile.sample_stat_user_functions 1 1 769 7,903 94 0 89 etendo.profile.stmt_list 3 3 114 942 57 0 84 etendo.profile.tables_list 2 2 113 2,076 84 0 54 etendo.profile.last_extension_versions 2 2 96 32 16 0 2 etendo.profile.last_stat_activity_count_srv1 2 0 96 16 16 0 4 etendo.profile.sample_stat_user_func_total 1 1 88 338 2 0 4 etendo.profile.sample_stat_tablespaces 1 1 84 338 2 0 4 etendo.profile.last_stat_slru 1 1 48 8 4 0 1 etendo.profile.indexes_list 2 2 13 454 14 0 12 etendo.profile.last_stat_database_srv1 1 1 0 8 4 0 1 Total 921 111 394,876 6,254,327 3,426,201 853 362,111 Pages removed per table
Key values
- profile.last_stat_indexes_srv1 (481) Main table with removed pages on database etendo
- 853 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed etendo.profile.last_stat_indexes_srv1 157 15 90682 481 etendo.profile.last_stat_tables_srv1 157 15 58575 356 etendo.profile.last_stat_statements_srv1 157 15 9655 16 etendo.profile.stmt_list 3 3 114 0 etendo.profile.sample_stat_tablespaces 1 1 84 0 etendo.profile.sample_stat_indexes 1 1 1014 0 etendo.profile.last_extension_versions 2 2 96 0 etendo.profile.sample_stat_tables 1 1 849 0 etendo.profile.last_stat_user_functions_srv1 157 15 9510 0 etendo.profile.last_stat_database_srv1 1 1 0 0 etendo.public.c_bpartner 270 30 221243 0 etendo.pg_toast.pg_toast_2619 5 5 1927 0 etendo.profile.sample_stat_user_func_total 1 1 88 0 etendo.profile.tables_list 2 2 113 0 etendo.profile.last_stat_activity_count_srv1 2 0 96 0 etendo.profile.indexes_list 2 2 13 0 etendo.profile.last_stat_slru 1 1 48 0 etendo.profile.sample_stat_user_functions 1 1 769 0 Total 921 111 394,876 853 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 14 07 64 14 08 60 10 09 58 8 10 62 10 11 58 16 12 59 10 13 58 9 14 62 10 15 58 12 16 67 11 17 64 8 18 63 13 19 64 12 20 62 12 21 62 12 22 0 0 - 0.50 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
- 121 Total read queries
- 77 Total write queries
Queries by database
Key values
- etendo Main database
- 198 Requests
- 4m53s (etendo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 197 Requests
User Request type Count Duration postgres Total 1 1s49ms select 1 1s49ms tad Total 197 4m52s select 120 2m45s update 77 2m7s Duration by user
Key values
- 4m52s (tad) Main time consuming user
User Request type Count Duration postgres Total 1 1s49ms select 1 1s49ms tad Total 197 4m52s select 120 2m45s update 77 2m7s Queries by host
Key values
- 127.0.0.1 Main host
- 197 Requests
- 4m52s (127.0.0.1)
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 197 Requests
- 4m52s (openbravo)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-14 19:36:46 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 198 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 4s263ms select invoice0_.DocumentNo as col_0_0_, businesspa2_.Name as col_1_0_, invoice0_.DateInvoiced as col_2_0_, organizati3_.Name as col_3_0_, adlisttrl1_.Name as col_4_0_ from C_Invoice invoice0_ cross join C_BPartner businesspa2_ cross join AD_Org organizati3_ cross join AD_Ref_List_Trl adlisttrl1_ cross join AD_Ref_List adlist4_ where invoice0_.C_BPartner_ID = businesspa2_.C_BPartner_ID and invoice0_.AD_Org_ID = organizati3_.AD_Org_ID and adlisttrl1_.AD_Ref_List_ID = adlist4_.AD_Ref_List_ID and invoice0_.EM_Priuti_Status_Of_Review <> 'Accepted' and adlist4_.Value = invoice0_.EM_Priuti_Status_Of_Review and adlist4_.AD_Reference_ID = 'DC8D631738C24AC39691B4DC26E185A6' and adlisttrl1_.AD_Language = 'es_ES' and ('DCF54271002A444FAFDD835C526EC020' in ( select priuti_inv6_.AD_User_ID from priuti_invoice_reviewers priuti_inv6_ where priuti_inv6_.C_Invoice_ID = invoice0_.C_Invoice_ID and (priuti_inv6_.Sequence in ( select coalesce(min(priuti_inv7_.Sequence), 99999) from priuti_invoice_reviewers priuti_inv7_ where priuti_inv7_.C_Invoice_ID = invoice0_.C_Invoice_ID and (priuti_inv7_.Result is null))))) limit '10';[ Date: 2026-07-14 19:18:33 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
2 2s746ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 11:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3 2s715ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 19:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
4 2s703ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 20:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
5 2s700ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 18:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
6 2s700ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 12:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
7 2s695ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 16:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
8 2s694ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 18:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
9 2s692ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 09:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
10 2s680ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 08:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
11 2s669ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 10:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
12 2s659ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 17:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
13 2s656ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 13:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
14 2s641ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 19:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
15 2s634ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 15:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
16 2s630ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 10:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
17 2s629ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 21:30:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
18 2s623ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 20:00:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
19 2s623ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 07:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
20 2s619ms update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);[ Date: 2026-07-14 11:30:03 - 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 2m11s 90 1s394ms 1s554ms 1s460ms select * from ( select aud.bpid as referencekey_id, ad_column_identifier (?, aud.bpid, ?) as record_id, ? as ad_role_id, null as ad_user_id, ? || aud.username || ? || aud.colname || ? || coalesce(aud.oldval, ?) || ? || coalesce(aud.newval, ?) as description, ? as isactive, ? as ad_org_id, ? as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = ? and aud.ad_table_id = ? and aud.updated > to_date(?, ?) and bp.c_bpartner_id is not null) as aud) 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 14 07 6 8s708ms 1s451ms 08 6 8s771ms 1s461ms 09 6 8s923ms 1s487ms 10 6 8s633ms 1s438ms 11 6 8s770ms 1s461ms 12 6 8s756ms 1s459ms 13 6 8s787ms 1s464ms 14 6 8s806ms 1s467ms 15 6 8s691ms 1s448ms 16 6 8s677ms 1s446ms 17 6 8s919ms 1s486ms 18 6 8s693ms 1s448ms 19 6 8s784ms 1s464ms 20 6 8s691ms 1s448ms 21 6 8s866ms 1s477ms [ User: tad - Total duration: 2m11s - Times executed: 90 ]
[ Application: openbravo - Total duration: 2m11s - Times executed: 90 ]
-
SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 08:29:30 Duration: 1s554ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 14:19:30 Duration: 1s546ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 19:49:30 Duration: 1s544ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 1m19s 30 2s519ms 2s746ms 2s635ms update c_bpartner set customer_blocking = ?, so_invoice_blocking = ?, so_order_blocking = ?, so_payment_blocking = ?, so_goods_blocking = ?, em_obwpl_bp_block_pickinglist = ? where exists (( select ? from fshins_bpcond where ((fshins_bpcond.date_init > trunc(now())) or (fshins_bpcond.date_final is not null and fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.fshins_situation_id not in ( select fshins_situation_id from fshins_situation where fshins_situation.decl = ?) or (fshins_bpcond.fshins_situation_id in ( select fshins_situation_id from fshins_situation where fshins_situation.decl = ?) and fshins_bpcond.assigned_amount = ?) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select ? from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 14 07 2 5s142ms 2s571ms 08 2 5s242ms 2s621ms 09 2 5s303ms 2s651ms 10 2 5s299ms 2s649ms 11 2 5s365ms 2s682ms 12 2 5s254ms 2s627ms 13 2 5s232ms 2s616ms 14 2 5s203ms 2s601ms 15 2 5s215ms 2s607ms 16 2 5s296ms 2s648ms 17 2 5s203ms 2s601ms 18 2 5s394ms 2s697ms 19 2 5s357ms 2s678ms 20 2 5s327ms 2s663ms 21 2 5s223ms 2s611ms [ User: tad - Total duration: 1m19s - Times executed: 30 ]
[ Application: openbravo - Total duration: 1m19s - Times executed: 30 ]
-
update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);
Date: 2026-07-14 11:00:04 Duration: 2s746ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);
Date: 2026-07-14 19:30:04 Duration: 2s715ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);
Date: 2026-07-14 20:30:04 Duration: 2s703ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 47s986ms 47 1s 1s64ms 1s20ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || documentno || ? || doc.name || ? as description, ? as isactive, inv.ad_org_id, inv.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id from c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id where c_invoice_id in ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ?), ?)) as idsinvoices from c_doctype dt where dt.isactive = ? and dt.issotrx = ? and dt.docbasetype = ? and dt.ad_table_id = ?) order by doc.name, documentno) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 14 07 2 2s50ms 1s25ms 08 3 3s65ms 1s21ms 09 2 2s51ms 1s25ms 10 4 4s155ms 1s38ms 11 3 3s27ms 1s9ms 12 5 5s60ms 1s12ms 13 4 4s105ms 1s26ms 14 3 3s24ms 1s8ms 15 2 2s87ms 1s43ms 16 2 2s35ms 1s17ms 17 4 4s63ms 1s15ms 18 3 3s52ms 1s17ms 19 5 5s135ms 1s27ms 20 1 1s2ms 1s2ms 21 4 4s69ms 1s17ms [ User: tad - Total duration: 47s986ms - Times executed: 47 ]
[ Application: openbravo - Total duration: 47s986ms - Times executed: 47 ]
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-14 10:49:33 Duration: 1s64ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-14 10:29:33 Duration: 1s60ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-14 15:49:33 Duration: 1s53ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 29s575ms 29 1s1ms 1s59ms 1s19ms select * from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || documentno || ? || doc.name || ? as description, ? as isactive, inv.ad_org_id, inv.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id from c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id where c_invoice_id in ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ?), ?)) as idsinvoices from c_doctype dt where dt.isactive = ? and dt.issotrx = ? and dt.docbasetype = ? and dt.ad_table_id = ?) order by doc.name, documentno) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 14 07 1 1s1ms 1s1ms 09 2 2s41ms 1s20ms 10 3 3s79ms 1s26ms 11 2 2s37ms 1s18ms 12 2 2s16ms 1s8ms 13 3 3s47ms 1s15ms 15 1 1s51ms 1s51ms 16 2 2s8ms 1s4ms 17 1 1s12ms 1s12ms 18 4 4s67ms 1s16ms 19 4 4s132ms 1s33ms 20 2 2s14ms 1s7ms 21 2 2s63ms 1s31ms [ User: tad - Total duration: 29s575ms - Times executed: 29 ]
[ Application: openbravo - Total duration: 29s575ms - Times executed: 29 ]
-
SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 19:39:32 Duration: 1s59ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 15:49:32 Duration: 1s51ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 19:59:32 Duration: 1s42ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
5 4s263ms 1 4s263ms 4s263ms 4s263ms select invoice0_.documentno as col_0_0_, businesspa2_.name as col_1_0_, invoice0_.dateinvoiced as col_2_0_, organizati3_.name as col_3_0_, adlisttrl1_.name as col_4_0_ from c_invoice invoice0_ cross join c_bpartner businesspa2_ cross join ad_org organizati3_ cross join ad_ref_list_trl adlisttrl1_ cross join ad_ref_list adlist4_ where invoice0_.c_bpartner_id = businesspa2_.c_bpartner_id and invoice0_.ad_org_id = organizati3_.ad_org_id and adlisttrl1_.ad_ref_list_id = adlist4_.ad_ref_list_id and invoice0_.em_priuti_status_of_review <> ? and adlist4_.value = invoice0_.em_priuti_status_of_review and adlist4_.ad_reference_id = ? and adlisttrl1_.ad_language = ? and (? in ( select priuti_inv6_.ad_user_id from priuti_invoice_reviewers priuti_inv6_ where priuti_inv6_.c_invoice_id = invoice0_.c_invoice_id and (priuti_inv6_.sequence in ( select coalesce(min(priuti_inv7_.sequence), ?) from priuti_invoice_reviewers priuti_inv7_ where priuti_inv7_.c_invoice_id = invoice0_.c_invoice_id and (priuti_inv7_.result is null))))) limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 14 19 1 4s263ms 4s263ms [ User: tad - Total duration: 4s263ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 4s263ms - Times executed: 1 ]
-
select invoice0_.DocumentNo as col_0_0_, businesspa2_.Name as col_1_0_, invoice0_.DateInvoiced as col_2_0_, organizati3_.Name as col_3_0_, adlisttrl1_.Name as col_4_0_ from C_Invoice invoice0_ cross join C_BPartner businesspa2_ cross join AD_Org organizati3_ cross join AD_Ref_List_Trl adlisttrl1_ cross join AD_Ref_List adlist4_ where invoice0_.C_BPartner_ID = businesspa2_.C_BPartner_ID and invoice0_.AD_Org_ID = organizati3_.AD_Org_ID and adlisttrl1_.AD_Ref_List_ID = adlist4_.AD_Ref_List_ID and invoice0_.EM_Priuti_Status_Of_Review <> 'Accepted' and adlist4_.Value = invoice0_.EM_Priuti_Status_Of_Review and adlist4_.AD_Reference_ID = 'DC8D631738C24AC39691B4DC26E185A6' and adlisttrl1_.AD_Language = 'es_ES' and ('DCF54271002A444FAFDD835C526EC020' in ( select priuti_inv6_.AD_User_ID from priuti_invoice_reviewers priuti_inv6_ where priuti_inv6_.C_Invoice_ID = invoice0_.C_Invoice_ID and (priuti_inv6_.Sequence in ( select coalesce(min(priuti_inv7_.Sequence), 99999) from priuti_invoice_reviewers priuti_inv7_ where priuti_inv7_.C_Invoice_ID = invoice0_.C_Invoice_ID and (priuti_inv7_.Result is null))))) limit '10';
Date: 2026-07-14 19:18:33 Duration: 4s263ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
6 1s49ms 1 1s49ms 1s49ms 1s49ms select profile.take_sample ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 14 09 1 1s49ms 1s49ms [ User: postgres - Total duration: 1s49ms - Times executed: 1 ]
[ Application: psql - Total duration: 1s49ms - Times executed: 1 ]
-
SELECT profile.take_sample ();
Date: 2026-07-14 09:00:02 Duration: 1s49ms Database: etendo User: postgres Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 90 2m11s 1s394ms 1s554ms 1s460ms select * from ( select aud.bpid as referencekey_id, ad_column_identifier (?, aud.bpid, ?) as record_id, ? as ad_role_id, null as ad_user_id, ? || aud.username || ? || aud.colname || ? || coalesce(aud.oldval, ?) || ? || coalesce(aud.newval, ?) as description, ? as isactive, ? as ad_org_id, ? as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = ? and aud.ad_table_id = ? and aud.updated > to_date(?, ?) and bp.c_bpartner_id is not null) as aud) 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 14 07 6 8s708ms 1s451ms 08 6 8s771ms 1s461ms 09 6 8s923ms 1s487ms 10 6 8s633ms 1s438ms 11 6 8s770ms 1s461ms 12 6 8s756ms 1s459ms 13 6 8s787ms 1s464ms 14 6 8s806ms 1s467ms 15 6 8s691ms 1s448ms 16 6 8s677ms 1s446ms 17 6 8s919ms 1s486ms 18 6 8s693ms 1s448ms 19 6 8s784ms 1s464ms 20 6 8s691ms 1s448ms 21 6 8s866ms 1s477ms [ User: tad - Total duration: 2m11s - Times executed: 90 ]
[ Application: openbravo - Total duration: 2m11s - Times executed: 90 ]
-
SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 08:29:30 Duration: 1s554ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 14:19:30 Duration: 1s546ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 19:49:30 Duration: 1s544ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 47 47s986ms 1s 1s64ms 1s20ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || documentno || ? || doc.name || ? as description, ? as isactive, inv.ad_org_id, inv.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id from c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id where c_invoice_id in ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ?), ?)) as idsinvoices from c_doctype dt where dt.isactive = ? and dt.issotrx = ? and dt.docbasetype = ? and dt.ad_table_id = ?) order by doc.name, documentno) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 14 07 2 2s50ms 1s25ms 08 3 3s65ms 1s21ms 09 2 2s51ms 1s25ms 10 4 4s155ms 1s38ms 11 3 3s27ms 1s9ms 12 5 5s60ms 1s12ms 13 4 4s105ms 1s26ms 14 3 3s24ms 1s8ms 15 2 2s87ms 1s43ms 16 2 2s35ms 1s17ms 17 4 4s63ms 1s15ms 18 3 3s52ms 1s17ms 19 5 5s135ms 1s27ms 20 1 1s2ms 1s2ms 21 4 4s69ms 1s17ms [ User: tad - Total duration: 47s986ms - Times executed: 47 ]
[ Application: openbravo - Total duration: 47s986ms - Times executed: 47 ]
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-14 10:49:33 Duration: 1s64ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-14 10:29:33 Duration: 1s60ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-14 15:49:33 Duration: 1s53ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 30 1m19s 2s519ms 2s746ms 2s635ms update c_bpartner set customer_blocking = ?, so_invoice_blocking = ?, so_order_blocking = ?, so_payment_blocking = ?, so_goods_blocking = ?, em_obwpl_bp_block_pickinglist = ? where exists (( select ? from fshins_bpcond where ((fshins_bpcond.date_init > trunc(now())) or (fshins_bpcond.date_final is not null and fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.fshins_situation_id not in ( select fshins_situation_id from fshins_situation where fshins_situation.decl = ?) or (fshins_bpcond.fshins_situation_id in ( select fshins_situation_id from fshins_situation where fshins_situation.decl = ?) and fshins_bpcond.assigned_amount = ?) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select ? from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 14 07 2 5s142ms 2s571ms 08 2 5s242ms 2s621ms 09 2 5s303ms 2s651ms 10 2 5s299ms 2s649ms 11 2 5s365ms 2s682ms 12 2 5s254ms 2s627ms 13 2 5s232ms 2s616ms 14 2 5s203ms 2s601ms 15 2 5s215ms 2s607ms 16 2 5s296ms 2s648ms 17 2 5s203ms 2s601ms 18 2 5s394ms 2s697ms 19 2 5s357ms 2s678ms 20 2 5s327ms 2s663ms 21 2 5s223ms 2s611ms [ User: tad - Total duration: 1m19s - Times executed: 30 ]
[ Application: openbravo - Total duration: 1m19s - Times executed: 30 ]
-
update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);
Date: 2026-07-14 11:00:04 Duration: 2s746ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);
Date: 2026-07-14 19:30:04 Duration: 2s715ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);
Date: 2026-07-14 20:30:04 Duration: 2s703ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 29 29s575ms 1s1ms 1s59ms 1s19ms select * from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || documentno || ? || doc.name || ? as description, ? as isactive, inv.ad_org_id, inv.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id from c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id where c_invoice_id in ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ?), ?)) as idsinvoices from c_doctype dt where dt.isactive = ? and dt.issotrx = ? and dt.docbasetype = ? and dt.ad_table_id = ?) order by doc.name, documentno) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 14 07 1 1s1ms 1s1ms 09 2 2s41ms 1s20ms 10 3 3s79ms 1s26ms 11 2 2s37ms 1s18ms 12 2 2s16ms 1s8ms 13 3 3s47ms 1s15ms 15 1 1s51ms 1s51ms 16 2 2s8ms 1s4ms 17 1 1s12ms 1s12ms 18 4 4s67ms 1s16ms 19 4 4s132ms 1s33ms 20 2 2s14ms 1s7ms 21 2 2s63ms 1s31ms [ User: tad - Total duration: 29s575ms - Times executed: 29 ]
[ Application: openbravo - Total duration: 29s575ms - Times executed: 29 ]
-
SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 19:39:32 Duration: 1s59ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 15:49:32 Duration: 1s51ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 19:59:32 Duration: 1s42ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
5 1 4s263ms 4s263ms 4s263ms 4s263ms select invoice0_.documentno as col_0_0_, businesspa2_.name as col_1_0_, invoice0_.dateinvoiced as col_2_0_, organizati3_.name as col_3_0_, adlisttrl1_.name as col_4_0_ from c_invoice invoice0_ cross join c_bpartner businesspa2_ cross join ad_org organizati3_ cross join ad_ref_list_trl adlisttrl1_ cross join ad_ref_list adlist4_ where invoice0_.c_bpartner_id = businesspa2_.c_bpartner_id and invoice0_.ad_org_id = organizati3_.ad_org_id and adlisttrl1_.ad_ref_list_id = adlist4_.ad_ref_list_id and invoice0_.em_priuti_status_of_review <> ? and adlist4_.value = invoice0_.em_priuti_status_of_review and adlist4_.ad_reference_id = ? and adlisttrl1_.ad_language = ? and (? in ( select priuti_inv6_.ad_user_id from priuti_invoice_reviewers priuti_inv6_ where priuti_inv6_.c_invoice_id = invoice0_.c_invoice_id and (priuti_inv6_.sequence in ( select coalesce(min(priuti_inv7_.sequence), ?) from priuti_invoice_reviewers priuti_inv7_ where priuti_inv7_.c_invoice_id = invoice0_.c_invoice_id and (priuti_inv7_.result is null))))) limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 14 19 1 4s263ms 4s263ms [ User: tad - Total duration: 4s263ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 4s263ms - Times executed: 1 ]
-
select invoice0_.DocumentNo as col_0_0_, businesspa2_.Name as col_1_0_, invoice0_.DateInvoiced as col_2_0_, organizati3_.Name as col_3_0_, adlisttrl1_.Name as col_4_0_ from C_Invoice invoice0_ cross join C_BPartner businesspa2_ cross join AD_Org organizati3_ cross join AD_Ref_List_Trl adlisttrl1_ cross join AD_Ref_List adlist4_ where invoice0_.C_BPartner_ID = businesspa2_.C_BPartner_ID and invoice0_.AD_Org_ID = organizati3_.AD_Org_ID and adlisttrl1_.AD_Ref_List_ID = adlist4_.AD_Ref_List_ID and invoice0_.EM_Priuti_Status_Of_Review <> 'Accepted' and adlist4_.Value = invoice0_.EM_Priuti_Status_Of_Review and adlist4_.AD_Reference_ID = 'DC8D631738C24AC39691B4DC26E185A6' and adlisttrl1_.AD_Language = 'es_ES' and ('DCF54271002A444FAFDD835C526EC020' in ( select priuti_inv6_.AD_User_ID from priuti_invoice_reviewers priuti_inv6_ where priuti_inv6_.C_Invoice_ID = invoice0_.C_Invoice_ID and (priuti_inv6_.Sequence in ( select coalesce(min(priuti_inv7_.Sequence), 99999) from priuti_invoice_reviewers priuti_inv7_ where priuti_inv7_.C_Invoice_ID = invoice0_.C_Invoice_ID and (priuti_inv7_.Result is null))))) limit '10';
Date: 2026-07-14 19:18:33 Duration: 4s263ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
6 1 1s49ms 1s49ms 1s49ms 1s49ms select profile.take_sample ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 14 09 1 1s49ms 1s49ms [ User: postgres - Total duration: 1s49ms - Times executed: 1 ]
[ Application: psql - Total duration: 1s49ms - Times executed: 1 ]
-
SELECT profile.take_sample ();
Date: 2026-07-14 09:00:02 Duration: 1s49ms Database: etendo User: postgres Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 4s263ms 4s263ms 4s263ms 1 4s263ms select invoice0_.documentno as col_0_0_, businesspa2_.name as col_1_0_, invoice0_.dateinvoiced as col_2_0_, organizati3_.name as col_3_0_, adlisttrl1_.name as col_4_0_ from c_invoice invoice0_ cross join c_bpartner businesspa2_ cross join ad_org organizati3_ cross join ad_ref_list_trl adlisttrl1_ cross join ad_ref_list adlist4_ where invoice0_.c_bpartner_id = businesspa2_.c_bpartner_id and invoice0_.ad_org_id = organizati3_.ad_org_id and adlisttrl1_.ad_ref_list_id = adlist4_.ad_ref_list_id and invoice0_.em_priuti_status_of_review <> ? and adlist4_.value = invoice0_.em_priuti_status_of_review and adlist4_.ad_reference_id = ? and adlisttrl1_.ad_language = ? and (? in ( select priuti_inv6_.ad_user_id from priuti_invoice_reviewers priuti_inv6_ where priuti_inv6_.c_invoice_id = invoice0_.c_invoice_id and (priuti_inv6_.sequence in ( select coalesce(min(priuti_inv7_.sequence), ?) from priuti_invoice_reviewers priuti_inv7_ where priuti_inv7_.c_invoice_id = invoice0_.c_invoice_id and (priuti_inv7_.result is null))))) limit ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 14 19 1 4s263ms 4s263ms [ User: tad - Total duration: 4s263ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 4s263ms - Times executed: 1 ]
-
select invoice0_.DocumentNo as col_0_0_, businesspa2_.Name as col_1_0_, invoice0_.DateInvoiced as col_2_0_, organizati3_.Name as col_3_0_, adlisttrl1_.Name as col_4_0_ from C_Invoice invoice0_ cross join C_BPartner businesspa2_ cross join AD_Org organizati3_ cross join AD_Ref_List_Trl adlisttrl1_ cross join AD_Ref_List adlist4_ where invoice0_.C_BPartner_ID = businesspa2_.C_BPartner_ID and invoice0_.AD_Org_ID = organizati3_.AD_Org_ID and adlisttrl1_.AD_Ref_List_ID = adlist4_.AD_Ref_List_ID and invoice0_.EM_Priuti_Status_Of_Review <> 'Accepted' and adlist4_.Value = invoice0_.EM_Priuti_Status_Of_Review and adlist4_.AD_Reference_ID = 'DC8D631738C24AC39691B4DC26E185A6' and adlisttrl1_.AD_Language = 'es_ES' and ('DCF54271002A444FAFDD835C526EC020' in ( select priuti_inv6_.AD_User_ID from priuti_invoice_reviewers priuti_inv6_ where priuti_inv6_.C_Invoice_ID = invoice0_.C_Invoice_ID and (priuti_inv6_.Sequence in ( select coalesce(min(priuti_inv7_.Sequence), 99999) from priuti_invoice_reviewers priuti_inv7_ where priuti_inv7_.C_Invoice_ID = invoice0_.C_Invoice_ID and (priuti_inv7_.Result is null))))) limit '10';
Date: 2026-07-14 19:18:33 Duration: 4s263ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 2s519ms 2s746ms 2s635ms 30 1m19s update c_bpartner set customer_blocking = ?, so_invoice_blocking = ?, so_order_blocking = ?, so_payment_blocking = ?, so_goods_blocking = ?, em_obwpl_bp_block_pickinglist = ? where exists (( select ? from fshins_bpcond where ((fshins_bpcond.date_init > trunc(now())) or (fshins_bpcond.date_final is not null and fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.fshins_situation_id not in ( select fshins_situation_id from fshins_situation where fshins_situation.decl = ?) or (fshins_bpcond.fshins_situation_id in ( select fshins_situation_id from fshins_situation where fshins_situation.decl = ?) and fshins_bpcond.assigned_amount = ?) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select ? from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 14 07 2 5s142ms 2s571ms 08 2 5s242ms 2s621ms 09 2 5s303ms 2s651ms 10 2 5s299ms 2s649ms 11 2 5s365ms 2s682ms 12 2 5s254ms 2s627ms 13 2 5s232ms 2s616ms 14 2 5s203ms 2s601ms 15 2 5s215ms 2s607ms 16 2 5s296ms 2s648ms 17 2 5s203ms 2s601ms 18 2 5s394ms 2s697ms 19 2 5s357ms 2s678ms 20 2 5s327ms 2s663ms 21 2 5s223ms 2s611ms [ User: tad - Total duration: 1m19s - Times executed: 30 ]
[ Application: openbravo - Total duration: 1m19s - Times executed: 30 ]
-
update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);
Date: 2026-07-14 11:00:04 Duration: 2s746ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);
Date: 2026-07-14 19:30:04 Duration: 2s715ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update c_bpartner set customer_blocking = 'Y', so_invoice_blocking = 'N', so_order_blocking = 'N', so_payment_blocking = 'N', so_goods_blocking = 'Y', em_obwpl_bp_block_pickinglist = 'Y' where exists (( select 1 from fshins_bpcond where ((fshins_bpcond.date_Init > trunc(now())) OR (fshins_bpcond.date_final is not null AND fshins_bpcond.date_final < trunc(now()))) or fshins_bpcond.Fshins_Situation_ID not in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') or (fshins_bpcond.Fshins_Situation_ID in ( select Fshins_Situation_ID from fshins_situation where fshins_situation.decl = 'Y') and fshins_bpcond.assigned_amount = 0) and fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id)) or not exists ( select 1 from fshins_bpcond where fshins_bpcond.c_bpartner_id = c_bpartner.c_bpartner_id);
Date: 2026-07-14 20:30:04 Duration: 2s703ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 1s394ms 1s554ms 1s460ms 90 2m11s select * from ( select aud.bpid as referencekey_id, ad_column_identifier (?, aud.bpid, ?) as record_id, ? as ad_role_id, null as ad_user_id, ? || aud.username || ? || aud.colname || ? || coalesce(aud.oldval, ?) || ? || coalesce(aud.newval, ?) as description, ? as isactive, ? as ad_org_id, ? as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = ? and aud.ad_table_id = ? and aud.updated > to_date(?, ?) and bp.c_bpartner_id is not null) as aud) 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 #3
Day Hour Count Duration Avg duration Jul 14 07 6 8s708ms 1s451ms 08 6 8s771ms 1s461ms 09 6 8s923ms 1s487ms 10 6 8s633ms 1s438ms 11 6 8s770ms 1s461ms 12 6 8s756ms 1s459ms 13 6 8s787ms 1s464ms 14 6 8s806ms 1s467ms 15 6 8s691ms 1s448ms 16 6 8s677ms 1s446ms 17 6 8s919ms 1s486ms 18 6 8s693ms 1s448ms 19 6 8s784ms 1s464ms 20 6 8s691ms 1s448ms 21 6 8s866ms 1s477ms [ User: tad - Total duration: 2m11s - Times executed: 90 ]
[ Application: openbravo - Total duration: 2m11s - Times executed: 90 ]
-
SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 08:29:30 Duration: 1s554ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 14:19:30 Duration: 1s546ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select aud.bpid as referencekey_id, ad_column_identifier ('c_bpartner', aud.bpid, 'en_US') AS record_id, '0' AS ad_role_id, NULL AS ad_user_id, 'USUARIO: ' || aud.username || ' - CAMPO: ' || aud.colname || ' - VALOR ANTIGUO: ' || coalesce(aud.oldval, 'null') || ' - VALOR ACTUAL: ' || coalesce(aud.newval, 'null') as description, 'Y' AS isActive, 'E3E23266C9CE4E91971071A3D8BF481A' as ad_org_id, '523673B50F634B52908327A51F066C5D' as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy from ( select aud.ad_audit_trail_id as audid, bp.c_bpartner_id as bpid, col.name as colname, aud.old_value as oldval, aud.new_value as newval, us.name as username from ad_audit_trail_v aud left join ad_column col on col.ad_column_id = aud.ad_column_id left join c_bpartner bp on bp.c_bpartner_id = aud.record_id left join ad_user us on bp.updatedby = us.ad_user_id where aud.action = 'U' and aud.ad_table_id = '291' and aud.updated > to_date('01-06-2021', 'dd-MM-yyyy') and bp.c_bpartner_id is not null) as aud) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'CBE7E1A5BF294F14907C7F4F9876B4BA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 19:49:30 Duration: 1s544ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 1s49ms 1s49ms 1s49ms 1 1s49ms select profile.take_sample ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 14 09 1 1s49ms 1s49ms [ User: postgres - Total duration: 1s49ms - Times executed: 1 ]
[ Application: psql - Total duration: 1s49ms - Times executed: 1 ]
-
SELECT profile.take_sample ();
Date: 2026-07-14 09:00:02 Duration: 1s49ms Database: etendo User: postgres Remote: [local] Application: psql
5 1s 1s64ms 1s20ms 47 47s986ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || documentno || ? || doc.name || ? as description, ? as isactive, inv.ad_org_id, inv.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id from c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id where c_invoice_id in ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ?), ?)) as idsinvoices from c_doctype dt where dt.isactive = ? and dt.issotrx = ? and dt.docbasetype = ? and dt.ad_table_id = ?) order by doc.name, documentno) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 14 07 2 2s50ms 1s25ms 08 3 3s65ms 1s21ms 09 2 2s51ms 1s25ms 10 4 4s155ms 1s38ms 11 3 3s27ms 1s9ms 12 5 5s60ms 1s12ms 13 4 4s105ms 1s26ms 14 3 3s24ms 1s8ms 15 2 2s87ms 1s43ms 16 2 2s35ms 1s17ms 17 4 4s63ms 1s15ms 18 3 3s52ms 1s17ms 19 5 5s135ms 1s27ms 20 1 1s2ms 1s2ms 21 4 4s69ms 1s17ms [ User: tad - Total duration: 47s986ms - Times executed: 47 ]
[ Application: openbravo - Total duration: 47s986ms - Times executed: 47 ]
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-14 10:49:33 Duration: 1s64ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-14 10:29:33 Duration: 1s60ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = 'C551178C7AEE4180A4BCF91AE798B7FF' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-14 15:49:33 Duration: 1s53ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
6 1s1ms 1s59ms 1s19ms 29 29s575ms select * from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || documentno || ? || doc.name || ? as description, ? as isactive, inv.ad_org_id, inv.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id from c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id where c_invoice_id in ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ?), ?)) as idsinvoices from c_doctype dt where dt.isactive = ? and dt.issotrx = ? and dt.docbasetype = ? and dt.ad_table_id = ?) order by doc.name, documentno) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 14 07 1 1s1ms 1s1ms 09 2 2s41ms 1s20ms 10 3 3s79ms 1s26ms 11 2 2s37ms 1s18ms 12 2 2s16ms 1s8ms 13 3 3s47ms 1s15ms 15 1 1s51ms 1s51ms 16 2 2s8ms 1s4ms 17 1 1s12ms 1s12ms 18 4 4s67ms 1s16ms 19 4 4s132ms 1s33ms 20 2 2s14ms 1s7ms 21 2 2s63ms 1s31ms [ User: tad - Total duration: 29s575ms - Times executed: 29 ]
[ Application: openbravo - Total duration: 29s575ms - Times executed: 29 ]
-
SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 19:39:32 Duration: 1s59ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 15:49:32 Duration: 1s51ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name || ' tiene un salto de número en la secuencia del tipo de documento en la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(priuti_getinvidsinvalidseq (dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive = 'Y' and dt.issotrx = 'Y' and dt.docbasetype = 'ARI' and dt.ad_table_id = '318') order by doc.name, documentno) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C551178C7AEE4180A4BCF91AE798B7FF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-14 19:59:32 Duration: 1s42ms 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
- 44,179 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 34 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 4 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 16 Max number of times the same event was reported
- 38 Total events found
Rank Times reported Error 1 16 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", no encryption
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 14 07 2 08 9 10 1 16 1 20 2 21 1 - FATAL: no pg_hba.conf entry for host "85.11.167.7", user "wog", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "81.19.216.112", user "postgres", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "85.11.167.7", user "wog", database "postgres", no encryption
Date: 2026-07-14 07:24:38 Database: postgres Application: [unknown] User: wog Remote: 85.11.167.7
Date: 2026-07-14 07:48:38 Database: postgres Application: [unknown] User: postgres Remote: 81.19.216.112
Date: 2026-07-14 08:29:14 Database: postgres Application: [unknown] User: wog Remote: 85.11.167.7
2 4 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 14 16 3 17 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-14 16:10:57 Database: [unknown] Application: [unknown] User: [unknown] Remote: 167.94.146.58
Date: 2026-07-14 16:21:55 Database: [unknown] Application: [unknown] User: [unknown] Remote: 3.129.187.38
Date: 2026-07-14 16:33:28 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.195.37
3 4 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 14 16 3 17 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-14 16:10:57 Database: [unknown] Application: [unknown] User: [unknown] Remote: 167.94.146.58
Date: 2026-07-14 16:21:55 Database: [unknown] Application: [unknown] User: [unknown] Remote: 3.129.187.38
Date: 2026-07-14 16:33:27 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.195.37
4 4 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 14 16 3 17 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-14 16:10:57 Database: [unknown] Application: [unknown] User: [unknown] Remote: 167.94.146.58
Date: 2026-07-14 16:21:55 Database: [unknown] Application: [unknown] User: [unknown] Remote: 3.129.187.38
Date: 2026-07-14 16:33:27 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.195.37
5 3 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 14 13 1 14 1 15 1 - LOG: could not receive data from client: Connection reset by peer
- LOG: could not receive data from client: Connection reset by peer
- LOG: could not receive data from client: Connection reset by peer
Date: 2026-07-14 13:36:25 Database: [unknown] Application: [unknown] User: [unknown] Remote: 45.33.14.5
Date: 2026-07-14 14:35:37 Database: [unknown] Application: [unknown] User: [unknown] Remote: 45.33.12.122
Date: 2026-07-14 15:36:51 Database: [unknown] Application: [unknown] User: [unknown] Remote: 45.79.115.59
6 3 FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 14 10 1 14 1 16 1 - FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
Date: 2026-07-14 10:55:45 Database: [unknown] Application: [unknown] User: [unknown] Remote: 34.140.241.37
Date: 2026-07-14 14:35:46 Database: [unknown] Application: [unknown] User: [unknown] Remote: 45.33.12.122
Date: 2026-07-14 16:56:15 Database: [unknown] Application: [unknown] User: [unknown] Remote: 165.22.231.142
7 2 FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 14 07 2 - FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
Date: 2026-07-14 07:01:13 Database: [unknown] Application: [unknown] User: [unknown] Remote: 20.65.185.21
Date: 2026-07-14 07:51:55 Database: [unknown] Application: [unknown] User: [unknown] Remote: 135.233.96.197
8 1 ERROR: incomplete startup packet
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 14 17 1 - ERROR: incomplete startup packet
Date: 2026-07-14 17:44:15 Database: [unknown] Application: [unknown] User: [unknown] Remote: 195.178.110.137
9 1 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL encryption
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 14 20 1 - FATAL: no pg_hba.conf entry for host "185.180.141.37", user "postgres", database "postgres", SSL encryption
Date: 2026-07-14 20:06:40 Database: postgres Application: [unknown] User: postgres Remote: 185.180.141.37