pgBadger-
Global information
- Generated on Sat Jul 18 23:00:07 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 7,178 log entries in 6s
- Log start from 2026-07-18 07:00:01 to 2026-07-18 21:55:22
-
Overview
Global Stats
- 10 Number of unique normalized queries
- 278 Number of queries
- 15m50s Total query duration
- 2026-07-18 07:20:51 First query
- 2026-07-18 21:20:50 Last query
- 9 queries/s at 2026-07-18 09:11:48 Query peak
- 15m50s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 15m50s Execute total duration
- 1 Number of events
- 1 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 122 Total number of automatic vacuums
- 149 Total number of automatic analyzes
- 847 Number temporary file
- 51.73 MiB Max size of temporary file
- 14.11 MiB Average size of temporary file
- 180 Total number of sessions
- 30 sessions at 2026-07-18 09:11:47 Session peak
- 2d16h54m50s Total duration of sessions
- 21m38s Average duration of sessions
- 1 Average queries per session
- 5s283ms Average queries duration per session
- 21m32s Average idle time per session
- 180 Total number of connections
- 28 connections/s at 2026-07-18 09:11:47 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 9 queries/s Query Peak
- 2026-07-18 09:11:48 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-07-18 10:10:31 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 9 queries/s Query Peak
- 2026-07-18 09:11:48 Date
Queries duration
Key values
- 15m50s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 18 07 11 0ms 29s402ms 5s638ms 0ms 29s402ms 32s616ms 08 24 0ms 22s696ms 2s828ms 13s267ms 14s30ms 22s696ms 09 48 0ms 29s300ms 2s255ms 10s523ms 29s300ms 30s343ms 10 51 0ms 29s100ms 2s464ms 22s630ms 23s726ms 29s100ms 11 12 0ms 30s66ms 3s975ms 0ms 17s643ms 30s66ms 12 20 0ms 21s292ms 2s976ms 14s624ms 21s292ms 21s292ms 13 1 0ms 28s978ms 28s978ms 0ms 28s978ms 28s978ms 14 2 0ms 29s735ms 22s483ms 0ms 15s231ms 29s735ms 15 49 0ms 23s 2s758ms 20s821ms 22s33ms 23s 16 10 0ms 21s634ms 4s359ms 8s266ms 13s695ms 21s634ms 17 38 0ms 30s952ms 2s681ms 12s653ms 16s587ms 31s996ms 18 1 0ms 28s445ms 28s445ms 0ms 28s445ms 28s445ms 19 2 0ms 21s378ms 11s387ms 1s396ms 21s378ms 21s378ms 20 8 0ms 29s685ms 5s739ms 5s893ms 9s209ms 29s685ms 21 1 0ms 28s167ms 28s167ms 0ms 28s167ms 28s167ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 18 07 11 0 5s638ms 0ms 0ms 32s616ms 08 24 0 2s828ms 6s728ms 13s267ms 22s696ms 09 24 0 3s245ms 1s426ms 9s23ms 29s300ms 10 51 0 2s464ms 15s749ms 22s630ms 29s100ms 11 12 0 3s975ms 0ms 0ms 30s66ms 12 20 0 2s976ms 9s328ms 14s624ms 21s292ms 13 1 0 28s978ms 0ms 0ms 28s978ms 14 2 0 22s483ms 0ms 0ms 29s735ms 15 49 0 2s758ms 14s784ms 20s821ms 23s 16 10 0 4s359ms 0ms 8s266ms 21s634ms 17 38 0 2s681ms 6s886ms 12s653ms 31s996ms 18 1 0 28s445ms 0ms 0ms 28s445ms 19 2 0 11s387ms 0ms 1s396ms 21s378ms 20 8 0 5s739ms 0ms 5s893ms 29s685ms 21 1 0 28s167ms 0ms 0ms 28s167ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 18 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 24 0 0 1s264ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 18 07 0 11 11.00 0.00% 08 0 24 24.00 0.00% 09 0 48 48.00 0.00% 10 0 51 51.00 0.00% 11 0 12 12.00 0.00% 12 0 20 20.00 0.00% 13 0 1 1.00 0.00% 14 0 2 2.00 0.00% 15 0 49 49.00 0.00% 16 0 10 10.00 0.00% 17 0 38 38.00 0.00% 18 0 1 1.00 0.00% 19 0 2 2.00 0.00% 20 0 8 8.00 0.00% 21 0 1 1.00 0.00% Day Hour Count Average / Second Jul 18 07 8 0.00/s 08 10 0.00/s 09 48 0.01/s 10 12 0.00/s 11 16 0.00/s 12 11 0.00/s 13 5 0.00/s 14 11 0.00/s 15 9 0.00/s 16 9 0.00/s 17 18 0.01/s 18 5 0.00/s 19 6 0.00/s 20 8 0.00/s 21 4 0.00/s Day Hour Count Average Duration Average idle time Jul 18 07 7 5m53s 5m44s 08 11 35m24s 35m18s 09 48 11m44s 11m42s 10 12 20m26s 20m15s 11 16 22m47s 22m44s 12 10 16m11s 16m5s 13 6 30m53s 30m48s 14 11 23m35s 23m31s 15 9 18m52s 18m37s 16 8 47m38s 47m32s 17 18 27m24s 27m18s 18 6 15m9s 15m4s 19 6 21m45s 21m41s 20 6 32m39s 32m32s 21 6 37m 36m55s -
Connections
Established Connections
Key values
- 28 connections Connection Peak
- 2026-07-18 09:11:47 Date
Connections per database
Key values
- etendo Main Database
- 180 connections Total
Connections per user
Key values
- tad Main User
- 180 connections Total
-
Sessions
Simultaneous sessions
Key values
- 30 sessions Session Peak
- 2026-07-18 09:11:47 Date
Histogram of session times
Key values
- 64 60000-600000ms duration
Sessions per database
Key values
- etendo Main Database
- 180 sessions Total
Sessions per user
Key values
- tad Main User
- 180 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 180 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 107,556 buffers Checkpoint Peak
- 2026-07-18 17:29:50 Date
- 270.034 seconds Highest write time
- 0.071 seconds Sync time
Checkpoints Wal files
Key values
- 31 files Wal files usage Peak
- 2026-07-18 17:29:50 Date
Checkpoints distance
Key values
- 995.45 Mo Distance Peak
- 2026-07-18 17:29:50 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 18 07 86,066 558.092s 0.231s 558.531s 08 62,142 533.462s 0.228s 533.866s 09 89,390 876.635s 0.298s 877.128s 10 62,665 577.275s 0.272s 577.707s 11 75,019 650.082s 0.308s 650.64s 12 61,993 525.989s 0.206s 526.448s 13 74,436 633.733s 0.243s 634.165s 14 99,947 643.453s 0.293s 643.91s 15 73,981 568.811s 0.241s 569.189s 16 63,021 585.96s 0.243s 586.399s 17 112,009 712.798s 0.329s 713.33s 18 62,557 566.019s 0.208s 566.395s 19 74,287 605.554s 0.297s 606.006s 20 62,328 539.539s 0.223s 539.985s 21 72,882 485.083s 0.174s 485.526s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 18 07 0 0 21 754 0.005s 0.012s 08 0 0 17 773 0.006s 0.012s 09 0 0 24 1,066 0.005s 0.012s 10 0 0 17 955 0.006s 0.012s 11 0 0 20 1,101 0.005s 0.012s 12 0 0 17 653 0.005s 0.012s 13 0 0 19 764 0.005s 0.012s 14 0 0 32 931 0.025s 0.012s 15 0 0 19 813 0.005s 0.012s 16 0 0 18 795 0.005s 0.012s 17 0 0 34 1,150 0.005s 0.012s 18 0 0 17 691 0.005s 0.011s 19 0 0 20 1,027 0.006s 0.012s 20 0 0 17 746 0.005s 0.011s 21 0 0 18 504 0.005s 0.012s Day Hour Count Avg time (sec) Jul 18 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s Day Hour Mean distance Mean estimate Jul 18 07 28,029.33 kB 183,707.17 kB 08 23,685.42 kB 167,149.92 kB 09 32,111.33 kB 171,414.08 kB 10 24,016.25 kB 163,335.17 kB 11 26,699.50 kB 170,850.58 kB 12 23,687.92 kB 163,165.17 kB 13 26,130.00 kB 169,513.50 kB 14 43,005.25 kB 260,634.75 kB 15 26,048.50 kB 206,584.08 kB 16 24,030.42 kB 163,639.25 kB 17 46,686.08 kB 266,731.50 kB 18 26,040.00 kB 204,393.55 kB 19 26,197.92 kB 174,431.00 kB 20 25,829.64 kB 164,611.64 kB 21 25,414.33 kB 173,721.08 kB -
Temporary Files
Size of temporary files
Key values
- 128.04 MiB Temp Files size Peak
- 2026-07-18 13:20:34 Date
Number of temporary files
Key values
- 8 per second Temp Files Peak
- 2026-07-18 13:20:34 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 18 07 82 875.33 MiB 10.67 MiB 08 55 748.44 MiB 13.61 MiB 09 55 748.44 MiB 13.61 MiB 10 53 748.44 MiB 14.12 MiB 11 53 895.48 MiB 16.90 MiB 12 53 748.44 MiB 14.12 MiB 13 53 896.10 MiB 16.91 MiB 14 55 825.45 MiB 15.01 MiB 15 53 748.44 MiB 14.12 MiB 16 55 748.44 MiB 13.61 MiB 17 57 825.45 MiB 14.48 MiB 18 55 748.44 MiB 13.61 MiB 19 56 748.44 MiB 13.37 MiB 20 56 896.42 MiB 16.01 MiB 21 56 748.44 MiB 13.37 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 843 11.52 GiB 76 B 46.86 MiB 13.99 MiB select * from ov_calocupacion (?);-
SELECT * FROM OV_CALOCUPACION ($1);
Date: 2026-07-18 07:20:28 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
2 4 154.02 MiB 25.28 MiB 51.73 MiB 38.50 MiB select * from ov_calofertas (?);-
SELECT * FROM OV_CALOFERTAS ($1);
Date: 2026-07-18 14:22:44 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
Queries generating the largest temporary files
Rank Size Query 1 51.73 MiB SELECT * FROM OV_CALOFERTAS ($1);[ Date: 2026-07-18 14:22:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2 51.73 MiB SELECT * FROM OV_CALOFERTAS ($1);[ Date: 2026-07-18 17:25:09 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3 46.86 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 20:20:34 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4 46.67 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 11:20:34 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5 46.58 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 13:20:34 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
6 46.48 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 11:20:28 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
7 46.48 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 11:20:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8 46.48 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 11:20:46 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
9 46.48 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 11:20:49 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
10 46.48 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 20:20:28 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
11 46.48 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 20:20:36 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
12 46.48 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 20:20:39 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
13 46.48 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 20:20:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
14 46.48 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 20:20:46 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
15 46.48 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 20:20:48 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
16 46.47 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 13:20:28 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
17 46.47 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 13:20:36 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
18 46.47 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 13:20:39 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
19 46.47 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 13:20:41 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
20 46.47 MiB SELECT * FROM OV_CALOCUPACION ($1);[ Date: 2026-07-18 13:20:45 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 4.51 sec Highest CPU-cost vacuum
Table public.ov_ocupacion
Database etendo - 2026-07-18 07:21:16 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 4.51 sec Highest CPU-cost vacuum
Table public.ov_ocupacion
Database etendo - 2026-07-18 07:21:16 Date
Analyzes per table
Key values
- profile.last_stat_tables_srv1 (15) Main table analyzed (database etendo)
- 149 analyzes Total
Table Number of analyzes etendo.profile.last_stat_tables_srv1 15 etendo.profile.last_stat_statements_srv1 15 etendo.public.ov_ocupacion 15 etendo.profile.last_stat_indexes_srv1 15 etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.tables_list 9 etendo.profile.last_stat_io 8 etendo.profile.indexes_list 5 etendo.profile.stmt_list 5 etendo.profile.funcs_list 4 etendo.profile.last_stat_activity_count_srv1 4 etendo.public.ad_ep_instance_para 4 etendo.profile.last_extension_versions 3 etendo.public.ad_preference 3 etendo.profile.last_stat_slru 3 etendo.profile.sample_stat_tables 3 etendo.profile.sample_stat_tables_total 2 etendo.profile.sample_statements 2 etendo.public.ad_session 2 etendo.profile.sample_stat_indexes 2 etendo.profile.sample_stat_user_functions 2 etendo.public.ov_offer 2 etendo.profile.sample_stat_io 1 etendo.pg_catalog.pg_type 1 etendo.profile.sample_stat_database 1 etendo.public.fin_payment_schedule 1 postgres.pg_catalog.pg_shdepend 1 etendo.profile.sample_stat_slru 1 etendo.public.ad_module 1 etendo.public.m_matchso 1 etendo.public.ad_sequence 1 etendo.profile.sample_stat_indexes_total 1 etendo.pg_catalog.pg_class 1 Total 149 Vacuums per table
Key values
- public.ov_ocupacion (22) Main table vacuumed on database etendo
- 122 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.ov_ocupacion 22 8 1,368,622 0 90,154 0 0 948,848 90,086 80,330,860 0 0 etendo.profile.last_stat_indexes_srv1 15 15 23,293 0 372 0 0 15,442 4,753 4,410,348 147 1,222 etendo.profile.last_stat_user_functions_srv1 15 15 2,783 0 57 0 0 1,906 535 2,173,220 432 6,117 etendo.profile.last_stat_tables_srv1 15 15 20,236 0 301 0 0 13,023 4,005 4,283,342 317 2,409 etendo.profile.last_stat_statements_srv1 15 15 12,661 0 191 0 0 9,182 2,547 9,988,324 1,826 17,469 etendo.profile.tables_list 7 7 1,140 0 76 0 0 848 259 1,544,206 194 2,339 etendo.profile.indexes_list 4 4 572 0 13 0 0 174 66 397,635 35 417 etendo.profile.funcs_list 3 3 279 0 10 0 0 119 37 206,863 27 273 etendo.profile.last_stat_io 3 3 249 0 18 0 0 31 15 54,060 3 39 etendo.profile.stmt_list 3 3 817 0 36 0 0 621 201 1,260,281 114 373 etendo.profile.last_stat_activity_count_srv1 2 0 48 0 10 0 0 12 6 33,182 0 0 etendo.public.ad_ep_instance_para 2 2 475 0 11 0 0 18 4 33,718 0 0 etendo.public.ov_offer 2 2 115,822 0 4 0 0 83,183 17,389 20,002,650 0 0 etendo.profile.last_extension_versions 2 2 104 0 4 0 0 12 8 30,734 2 14 etendo.profile.last_stat_database_srv1 1 1 52 0 1 0 0 7 3 10,937 1 4 etendo.public.ad_module 1 1 334 0 1 0 0 181 58 227,232 42 261 etendo.profile.sample_stat_tables 1 0 510 0 139 0 0 147 1 17,052 0 0 etendo.profile.last_stat_slru 1 1 71 0 5 0 0 6 4 15,169 1 5 etendo.pg_toast.pg_toast_2619 1 1 1,468 0 229 0 0 590 188 322,360 6 16 etendo.pg_catalog.pg_statistic 1 1 1,990 0 367 0 0 1,015 226 667,671 128 420 etendo.pg_toast.pg_toast_323127 1 1 918 0 165 0 0 469 157 385,698 14 26 etendo.profile.last_stat_sequences_srv1 1 1 59 0 1 0 0 7 3 10,259 1 3 etendo.pg_catalog.pg_shdepend 1 1 179 0 29 0 0 63 27 163,340 3 4 etendo.public.fin_payment_schedule 1 1 20,225 0 6,485 0 0 15,476 6,432 20,391,584 446 1,774 etendo.profile.sample_statements 1 0 286 0 98 0 0 101 1 14,338 0 0 etendo.pg_toast.pg_toast_323456 1 1 671 0 6 0 0 498 128 57,187 0 0 Total 122 104 1,573,864 1,152 98,783 0 0 1,091,979 127,139 147,032,250 3,739 33,185 Vacuum throughput per table
Key values
- public.ov_ocupacion (36.37) 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.ov_ocupacion 0 0 36.37 etendo.profile.last_stat_indexes_srv1 0 0 0.3 etendo.profile.last_stat_user_functions_srv1 0 0 0.01 etendo.profile.last_stat_tables_srv1 0 0 0.22 etendo.profile.last_stat_statements_srv1 0 0 0.2 etendo.profile.tables_list 0 0 0 etendo.profile.indexes_list 0 0 0 etendo.profile.funcs_list 0 0 0 etendo.profile.last_stat_io 0 0 0.03 etendo.profile.stmt_list 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0.01 etendo.public.ad_ep_instance_para 0 0 0.04 etendo.public.ov_offer 0 0 1.43 etendo.profile.last_extension_versions 0 0 0 etendo.profile.last_stat_database_srv1 0 0 0 etendo.public.ad_module 0 0 0 etendo.profile.sample_stat_tables 0 0 0.03 etendo.profile.last_stat_slru 0 0 0 etendo.pg_toast.pg_toast_2619 0 0 0.06 etendo.pg_catalog.pg_statistic 0 0 0.1 etendo.pg_toast.pg_toast_323127 0 0 0.05 etendo.profile.last_stat_sequences_srv1 0 0 0 etendo.pg_catalog.pg_shdepend 0 0 0 etendo.public.fin_payment_schedule 0 0 1.93 etendo.profile.sample_statements 0 0 0.02 etendo.pg_toast.pg_toast_323456 0 0 0 Total 0 0 40.8 Tuples removed per table
Key values
- public.ov_ocupacion (3473511) Main table with removed tuples on database etendo
- 3687428 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.public.ov_ocupacion 22 8 3,473,511 25,670,732 0 0 16,691,158 etendo.profile.last_stat_indexes_srv1 15 15 96,364 47,715 0 0 5,865 etendo.profile.last_stat_tables_srv1 15 15 63,158 29,992 0 31 4,724 etendo.profile.last_stat_statements_srv1 15 15 22,675 20,698 0 112 2,262 etendo.public.fin_payment_schedule 1 1 19,473 249,645 0 0 15,931 etendo.profile.last_stat_user_functions_srv1 15 15 7,046 6,165 0 1 438 etendo.pg_catalog.pg_statistic 1 1 1,216 7,655 0 0 886 etendo.profile.tables_list 7 7 1,207 6,263 0 0 196 etendo.pg_toast.pg_toast_2619 1 1 504 2,819 0 0 849 etendo.pg_toast.pg_toast_323456 1 1 492 492 0 0 246 etendo.pg_toast.pg_toast_323127 1 1 284 1,778 0 0 560 etendo.public.ad_module 1 1 270 305 0 0 69 etendo.profile.stmt_list 3 3 194 2,069 0 0 206 etendo.profile.funcs_list 3 3 188 598 0 0 27 etendo.profile.indexes_list 4 4 183 1,291 0 0 36 etendo.profile.last_stat_io 3 3 169 39 0 2 4 etendo.pg_catalog.pg_shdepend 1 1 124 2,231 0 0 19 etendo.public.ad_ep_instance_para 2 2 112 0 0 3 0 etendo.profile.last_extension_versions 2 2 112 14 0 0 2 etendo.profile.last_stat_slru 1 1 55 5 0 0 1 etendo.profile.last_stat_activity_count_srv1 2 0 48 0 0 2 0 etendo.profile.last_stat_sequences_srv1 1 1 24 3 0 0 1 etendo.public.ov_offer 2 2 15 477,990 0 0 32,132 etendo.profile.last_stat_database_srv1 1 1 4 4 0 0 1 etendo.profile.sample_stat_tables 1 0 0 13,817 0 0 469 etendo.profile.sample_statements 1 0 0 4,811 0 0 242 Total 122 104 3,687,428 26,547,131 0 151 16,756,324 Pages removed per table
Key values
- profile.last_stat_statements_srv1 (112) Main table with removed pages on database etendo
- 151 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed etendo.profile.last_stat_statements_srv1 15 15 22675 112 etendo.profile.last_stat_tables_srv1 15 15 63158 31 etendo.public.ad_ep_instance_para 2 2 112 3 etendo.profile.last_stat_activity_count_srv1 2 0 48 2 etendo.profile.last_stat_io 3 3 169 2 etendo.profile.last_stat_user_functions_srv1 15 15 7046 1 etendo.profile.last_stat_database_srv1 1 1 4 0 etendo.profile.funcs_list 3 3 188 0 etendo.public.ad_module 1 1 270 0 etendo.profile.last_stat_indexes_srv1 15 15 96364 0 etendo.profile.sample_stat_tables 1 0 0 0 etendo.profile.last_stat_slru 1 1 55 0 etendo.pg_toast.pg_toast_2619 1 1 504 0 etendo.pg_catalog.pg_statistic 1 1 1216 0 etendo.pg_toast.pg_toast_323127 1 1 284 0 etendo.profile.last_stat_sequences_srv1 1 1 24 0 etendo.profile.stmt_list 3 3 194 0 etendo.public.ov_offer 2 2 15 0 etendo.profile.tables_list 7 7 1207 0 etendo.pg_catalog.pg_shdepend 1 1 124 0 etendo.profile.last_extension_versions 2 2 112 0 etendo.public.fin_payment_schedule 1 1 19473 0 etendo.profile.indexes_list 4 4 183 0 etendo.profile.sample_statements 1 0 0 0 etendo.public.ov_ocupacion 22 8 3473511 0 etendo.pg_toast.pg_toast_323456 1 1 492 0 Total 122 104 3,687,428 151 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 18 07 7 11 08 7 9 09 11 18 10 8 8 11 9 9 12 8 7 13 7 11 14 8 11 15 8 9 16 10 12 17 8 9 18 7 9 19 9 9 20 9 10 21 6 7 - 4.51 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
- 254 Total read queries
- 24 Total write queries
Queries by database
Key values
- etendo Main database
- 278 Requests
- 15m50s (etendo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 278 Requests
User Request type Count Duration tad Total 278 15m50s select 254 15m20s update 24 30s343ms Duration by user
Key values
- 15m50s (tad) Main time consuming user
User Request type Count Duration tad Total 278 15m50s select 254 15m20s update 24 30s343ms Queries by host
Key values
- 127.0.0.1 Main host
- 278 Requests
- 15m50s (127.0.0.1)
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 278 Requests
- 15m50s (openbravo)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-18 08:33:29 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 261 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 30s952ms SELECT * FROM OV_CALOCUPACION (NULL);[ Date: 2026-07-18 17:20:52 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
2 30s66ms SELECT * FROM OV_CALOCUPACION (NULL);[ Date: 2026-07-18 11:20:52 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3 29s735ms SELECT * FROM OV_CALOCUPACION (NULL);[ Date: 2026-07-18 14:20:51 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
4 29s685ms SELECT * FROM OV_CALOCUPACION (NULL);[ Date: 2026-07-18 20:20:51 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
5 29s402ms SELECT * FROM OV_CALOCUPACION (NULL);[ Date: 2026-07-18 07:20:51 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
6 29s300ms SELECT * FROM OV_CALOCUPACION (NULL);[ Date: 2026-07-18 09:20:51 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
7 29s100ms SELECT * FROM OV_CALOCUPACION (NULL);[ Date: 2026-07-18 10:20:51 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
8 28s978ms SELECT * FROM OV_CALOCUPACION (NULL);[ Date: 2026-07-18 13:20:50 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
9 28s445ms SELECT * FROM OV_CALOCUPACION (NULL);[ Date: 2026-07-18 18:20:50 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
10 28s167ms SELECT * FROM OV_CALOCUPACION (NULL);[ Date: 2026-07-18 21:20:50 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
11 23s SELECT * FROM OV_CALOCUPACION (NULL);[ Date: 2026-07-18 15:20:45 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
12 22s696ms SELECT * FROM OV_CALOCUPACION (NULL);[ Date: 2026-07-18 08:20:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
13 21s634ms SELECT * FROM OV_CALOCUPACION (NULL);[ Date: 2026-07-18 16:20:43 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
14 21s378ms SELECT * FROM OV_CALOCUPACION (NULL);[ Date: 2026-07-18 19:20:43 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
15 21s292ms SELECT * FROM OV_CALOCUPACION (NULL);[ Date: 2026-07-18 12:20:43 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
16 15s231ms SELECT * FROM OV_CALOFERTAS (NULL);[ Date: 2026-07-18 14:22:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
17 11s209ms SELECT * FROM OV_CALOFERTAS (NULL);[ Date: 2026-07-18 17:25:09 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
18 6s644ms select ov_infoact0_.OV_Infoactuaciones_V_ID as ov_infoa1_900_, ov_infoact0_.AD_Client_ID as ad_clien2_900_, ov_infoact0_.AD_Org_ID as ad_org_i3_900_, ov_infoact0_.Isactive as isactive4_900_, ov_infoact0_.Created as created5_900_, ov_infoact0_.Createdby as createdb6_900_, ov_infoact0_.Updated as updated7_900_, ov_infoact0_.Updatedby as updatedb8_900_, ov_infoact0_.Dateordered as dateorde9_900_, ov_infoact0_.Obre_Resource_ID as obre_re10_900_, ov_infoact0_.C_Order_ID as c_order11_900_, ov_infoact0_.Documentno as documen12_900_, ov_infoact0_.Anyo as anyo13_900_, ov_infoact0_.Description as descrip14_900_, ov_infoact0_.Extrapropietario as extrapr15_900_, ov_infoact0_.Importe as importe16_900_, ov_infoact0_.Total_Compra as total_c17_900_, ov_infoact0_.Resto as resto18_900_, ov_infoact0_.Tipo as tipo19_900_, ov_infoact0_.Isfacturado as isfactu20_900_, ov_infoact0_.Propietario as propiet21_900_, ov_infoact0_.Isservicio as isservi22_900_, ov_infoact0_.Numfactura as numfact23_900_, ov_infoact0_.Tipogasto as tipogas24_900_, ov_infoact0_.Periodo as periodo25_900_, ov_infoact0_.Detalle as detalle26_900_ from ov_infoactuaciones_v ov_infoact0_ where obre_resource_id = '3EF97DA965B54C7BB4856C90275F6BC1' and ov_infoact0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infoact0_.Propietario = '455F2D24F14B4513B2D51486814A386E' and ov_infoact0_.Extrapropietario = 'Y' and ov_infoact0_.Dateordered >= '2026-01-01' and ov_infoact0_.Dateordered <= '2027-01-01' and (ov_infoact0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infoact0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infoact0_.Isactive = 'Y' order by ov_infoact0_.OV_Infoactuaciones_V_ID desc, ov_infoact0_.OV_Infoactuaciones_V_ID desc;[ Date: 2026-07-18 15:54:54 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
19 6s604ms select ov_infoact0_.OV_Infoactuaciones_V_ID as ov_infoa1_900_, ov_infoact0_.AD_Client_ID as ad_clien2_900_, ov_infoact0_.AD_Org_ID as ad_org_i3_900_, ov_infoact0_.Isactive as isactive4_900_, ov_infoact0_.Created as created5_900_, ov_infoact0_.Createdby as createdb6_900_, ov_infoact0_.Updated as updated7_900_, ov_infoact0_.Updatedby as updatedb8_900_, ov_infoact0_.Dateordered as dateorde9_900_, ov_infoact0_.Obre_Resource_ID as obre_re10_900_, ov_infoact0_.C_Order_ID as c_order11_900_, ov_infoact0_.Documentno as documen12_900_, ov_infoact0_.Anyo as anyo13_900_, ov_infoact0_.Description as descrip14_900_, ov_infoact0_.Extrapropietario as extrapr15_900_, ov_infoact0_.Importe as importe16_900_, ov_infoact0_.Total_Compra as total_c17_900_, ov_infoact0_.Resto as resto18_900_, ov_infoact0_.Tipo as tipo19_900_, ov_infoact0_.Isfacturado as isfactu20_900_, ov_infoact0_.Propietario as propiet21_900_, ov_infoact0_.Isservicio as isservi22_900_, ov_infoact0_.Numfactura as numfact23_900_, ov_infoact0_.Tipogasto as tipogas24_900_, ov_infoact0_.Periodo as periodo25_900_, ov_infoact0_.Detalle as detalle26_900_ from ov_infoactuaciones_v ov_infoact0_ where obre_resource_id = '3EF97DA965B54C7BB4856C90275F6BC1' and ov_infoact0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infoact0_.Propietario = '455F2D24F14B4513B2D51486814A386E' and ov_infoact0_.Extrapropietario = 'Y' and ov_infoact0_.Dateordered >= '2026-01-01' and ov_infoact0_.Dateordered <= '2027-01-01' and (ov_infoact0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infoact0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infoact0_.Isactive = 'Y' order by ov_infoact0_.OV_Infoactuaciones_V_ID desc, ov_infoact0_.OV_Infoactuaciones_V_ID desc;[ Date: 2026-07-18 15:55:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
20 6s548ms select ov_infoact0_.OV_Infoactuaciones_V_ID as ov_infoa1_900_, ov_infoact0_.AD_Client_ID as ad_clien2_900_, ov_infoact0_.AD_Org_ID as ad_org_i3_900_, ov_infoact0_.Isactive as isactive4_900_, ov_infoact0_.Created as created5_900_, ov_infoact0_.Createdby as createdb6_900_, ov_infoact0_.Updated as updated7_900_, ov_infoact0_.Updatedby as updatedb8_900_, ov_infoact0_.Dateordered as dateorde9_900_, ov_infoact0_.Obre_Resource_ID as obre_re10_900_, ov_infoact0_.C_Order_ID as c_order11_900_, ov_infoact0_.Documentno as documen12_900_, ov_infoact0_.Anyo as anyo13_900_, ov_infoact0_.Description as descrip14_900_, ov_infoact0_.Extrapropietario as extrapr15_900_, ov_infoact0_.Importe as importe16_900_, ov_infoact0_.Total_Compra as total_c17_900_, ov_infoact0_.Resto as resto18_900_, ov_infoact0_.Tipo as tipo19_900_, ov_infoact0_.Isfacturado as isfactu20_900_, ov_infoact0_.Propietario as propiet21_900_, ov_infoact0_.Isservicio as isservi22_900_, ov_infoact0_.Numfactura as numfact23_900_, ov_infoact0_.Tipogasto as tipogas24_900_, ov_infoact0_.Periodo as periodo25_900_, ov_infoact0_.Detalle as detalle26_900_ from ov_infoactuaciones_v ov_infoact0_ where obre_resource_id = '3EF97DA965B54C7BB4856C90275F6BC1' and ov_infoact0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infoact0_.Propietario = '455F2D24F14B4513B2D51486814A386E' and ov_infoact0_.Extrapropietario = 'Y' and ov_infoact0_.Dateordered >= '2026-01-01' and ov_infoact0_.Dateordered <= '2027-01-01' and (ov_infoact0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infoact0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infoact0_.Isactive = 'Y' order by ov_infoact0_.OV_Infoactuaciones_V_ID desc, ov_infoact0_.OV_Infoactuaciones_V_ID desc;[ Date: 2026-07-18 09:40: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 6m43s 15 21s292ms 30s952ms 26s922ms select * from ov_calocupacion (null);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 18 07 1 29s402ms 29s402ms 08 1 22s696ms 22s696ms 09 1 29s300ms 29s300ms 10 1 29s100ms 29s100ms 11 1 30s66ms 30s66ms 12 1 21s292ms 21s292ms 13 1 28s978ms 28s978ms 14 1 29s735ms 29s735ms 15 1 23s 23s 16 1 21s634ms 21s634ms 17 1 30s952ms 30s952ms 18 1 28s445ms 28s445ms 19 1 21s378ms 21s378ms 20 1 29s685ms 29s685ms 21 1 28s167ms 28s167ms [ User: tad - Total duration: 6m43s - Times executed: 15 ]
[ Application: openbravo - Total duration: 6m43s - Times executed: 15 ]
-
SELECT * FROM OV_CALOCUPACION (NULL);
Date: 2026-07-18 17:20:52 Duration: 30s952ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM OV_CALOCUPACION (NULL);
Date: 2026-07-18 11:20:52 Duration: 30s66ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM OV_CALOCUPACION (NULL);
Date: 2026-07-18 14:20:51 Duration: 29s735ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 3m1s 81 1s25ms 6s644ms 2s240ms select ov_infoact0_.ov_infoactuaciones_v_id as ov_infoa1_900_, ov_infoact0_.ad_client_id as ad_clien2_900_, ov_infoact0_.ad_org_id as ad_org_i3_900_, ov_infoact0_.isactive as isactive4_900_, ov_infoact0_.created as created5_900_, ov_infoact0_.createdby as createdb6_900_, ov_infoact0_.updated as updated7_900_, ov_infoact0_.updatedby as updatedb8_900_, ov_infoact0_.dateordered as dateorde9_900_, ov_infoact0_.obre_resource_id as obre_re10_900_, ov_infoact0_.c_order_id as c_order11_900_, ov_infoact0_.documentno as documen12_900_, ov_infoact0_.anyo as anyo13_900_, ov_infoact0_.description as descrip14_900_, ov_infoact0_.extrapropietario as extrapr15_900_, ov_infoact0_.importe as importe16_900_, ov_infoact0_.total_compra as total_c17_900_, ov_infoact0_.resto as resto18_900_, ov_infoact0_.tipo as tipo19_900_, ov_infoact0_.isfacturado as isfactu20_900_, ov_infoact0_.propietario as propiet21_900_, ov_infoact0_.isservicio as isservi22_900_, ov_infoact0_.numfactura as numfact23_900_, ov_infoact0_.tipogasto as tipogas24_900_, ov_infoact0_.periodo as periodo25_900_, ov_infoact0_.detalle as detalle26_900_ from ov_infoactuaciones_v ov_infoact0_ where obre_resource_id = ? and ov_infoact0_.ad_org_id <> ? and ov_infoact0_.propietario = ? and ov_infoact0_.extrapropietario = ? and ov_infoact0_.dateordered >= ? and ov_infoact0_.dateordered <= ? and (ov_infoact0_.ad_org_id in (...)) and (ov_infoact0_.ad_client_id in (...)) and ov_infoact0_.isactive = ? order by ov_infoact0_.ov_infoactuaciones_v_id desc, ov_infoact0_.ov_infoactuaciones_v_id desc;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 18 07 4 10s352ms 2s588ms 08 9 21s290ms 2s365ms 09 11 29s960ms 2s723ms 10 16 27s370ms 1s710ms 11 2 2s928ms 1s464ms 12 6 10s819ms 1s803ms 15 7 28s308ms 4s44ms 16 1 1s178ms 1s178ms 17 23 43s76ms 1s872ms 19 1 1s396ms 1s396ms 20 1 4s774ms 4s774ms [ User: tad - Total duration: 3m1s - Times executed: 81 ]
[ Application: openbravo - Total duration: 3m1s - Times executed: 81 ]
-
select ov_infoact0_.OV_Infoactuaciones_V_ID as ov_infoa1_900_, ov_infoact0_.AD_Client_ID as ad_clien2_900_, ov_infoact0_.AD_Org_ID as ad_org_i3_900_, ov_infoact0_.Isactive as isactive4_900_, ov_infoact0_.Created as created5_900_, ov_infoact0_.Createdby as createdb6_900_, ov_infoact0_.Updated as updated7_900_, ov_infoact0_.Updatedby as updatedb8_900_, ov_infoact0_.Dateordered as dateorde9_900_, ov_infoact0_.Obre_Resource_ID as obre_re10_900_, ov_infoact0_.C_Order_ID as c_order11_900_, ov_infoact0_.Documentno as documen12_900_, ov_infoact0_.Anyo as anyo13_900_, ov_infoact0_.Description as descrip14_900_, ov_infoact0_.Extrapropietario as extrapr15_900_, ov_infoact0_.Importe as importe16_900_, ov_infoact0_.Total_Compra as total_c17_900_, ov_infoact0_.Resto as resto18_900_, ov_infoact0_.Tipo as tipo19_900_, ov_infoact0_.Isfacturado as isfactu20_900_, ov_infoact0_.Propietario as propiet21_900_, ov_infoact0_.Isservicio as isservi22_900_, ov_infoact0_.Numfactura as numfact23_900_, ov_infoact0_.Tipogasto as tipogas24_900_, ov_infoact0_.Periodo as periodo25_900_, ov_infoact0_.Detalle as detalle26_900_ from ov_infoactuaciones_v ov_infoact0_ where obre_resource_id = '3EF97DA965B54C7BB4856C90275F6BC1' and ov_infoact0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infoact0_.Propietario = '455F2D24F14B4513B2D51486814A386E' and ov_infoact0_.Extrapropietario = 'Y' and ov_infoact0_.Dateordered >= '2026-01-01' and ov_infoact0_.Dateordered <= '2027-01-01' and (ov_infoact0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infoact0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infoact0_.Isactive = 'Y' order by ov_infoact0_.OV_Infoactuaciones_V_ID desc, ov_infoact0_.OV_Infoactuaciones_V_ID desc;
Date: 2026-07-18 15:54:54 Duration: 6s644ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_infoact0_.OV_Infoactuaciones_V_ID as ov_infoa1_900_, ov_infoact0_.AD_Client_ID as ad_clien2_900_, ov_infoact0_.AD_Org_ID as ad_org_i3_900_, ov_infoact0_.Isactive as isactive4_900_, ov_infoact0_.Created as created5_900_, ov_infoact0_.Createdby as createdb6_900_, ov_infoact0_.Updated as updated7_900_, ov_infoact0_.Updatedby as updatedb8_900_, ov_infoact0_.Dateordered as dateorde9_900_, ov_infoact0_.Obre_Resource_ID as obre_re10_900_, ov_infoact0_.C_Order_ID as c_order11_900_, ov_infoact0_.Documentno as documen12_900_, ov_infoact0_.Anyo as anyo13_900_, ov_infoact0_.Description as descrip14_900_, ov_infoact0_.Extrapropietario as extrapr15_900_, ov_infoact0_.Importe as importe16_900_, ov_infoact0_.Total_Compra as total_c17_900_, ov_infoact0_.Resto as resto18_900_, ov_infoact0_.Tipo as tipo19_900_, ov_infoact0_.Isfacturado as isfactu20_900_, ov_infoact0_.Propietario as propiet21_900_, ov_infoact0_.Isservicio as isservi22_900_, ov_infoact0_.Numfactura as numfact23_900_, ov_infoact0_.Tipogasto as tipogas24_900_, ov_infoact0_.Periodo as periodo25_900_, ov_infoact0_.Detalle as detalle26_900_ from ov_infoactuaciones_v ov_infoact0_ where obre_resource_id = '3EF97DA965B54C7BB4856C90275F6BC1' and ov_infoact0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infoact0_.Propietario = '455F2D24F14B4513B2D51486814A386E' and ov_infoact0_.Extrapropietario = 'Y' and ov_infoact0_.Dateordered >= '2026-01-01' and ov_infoact0_.Dateordered <= '2027-01-01' and (ov_infoact0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infoact0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infoact0_.Isactive = 'Y' order by ov_infoact0_.OV_Infoactuaciones_V_ID desc, ov_infoact0_.OV_Infoactuaciones_V_ID desc;
Date: 2026-07-18 15:55:01 Duration: 6s604ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_infoact0_.OV_Infoactuaciones_V_ID as ov_infoa1_900_, ov_infoact0_.AD_Client_ID as ad_clien2_900_, ov_infoact0_.AD_Org_ID as ad_org_i3_900_, ov_infoact0_.Isactive as isactive4_900_, ov_infoact0_.Created as created5_900_, ov_infoact0_.Createdby as createdb6_900_, ov_infoact0_.Updated as updated7_900_, ov_infoact0_.Updatedby as updatedb8_900_, ov_infoact0_.Dateordered as dateorde9_900_, ov_infoact0_.Obre_Resource_ID as obre_re10_900_, ov_infoact0_.C_Order_ID as c_order11_900_, ov_infoact0_.Documentno as documen12_900_, ov_infoact0_.Anyo as anyo13_900_, ov_infoact0_.Description as descrip14_900_, ov_infoact0_.Extrapropietario as extrapr15_900_, ov_infoact0_.Importe as importe16_900_, ov_infoact0_.Total_Compra as total_c17_900_, ov_infoact0_.Resto as resto18_900_, ov_infoact0_.Tipo as tipo19_900_, ov_infoact0_.Isfacturado as isfactu20_900_, ov_infoact0_.Propietario as propiet21_900_, ov_infoact0_.Isservicio as isservi22_900_, ov_infoact0_.Numfactura as numfact23_900_, ov_infoact0_.Tipogasto as tipogas24_900_, ov_infoact0_.Periodo as periodo25_900_, ov_infoact0_.Detalle as detalle26_900_ from ov_infoactuaciones_v ov_infoact0_ where obre_resource_id = '3EF97DA965B54C7BB4856C90275F6BC1' and ov_infoact0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infoact0_.Propietario = '455F2D24F14B4513B2D51486814A386E' and ov_infoact0_.Extrapropietario = 'Y' and ov_infoact0_.Dateordered >= '2026-01-01' and ov_infoact0_.Dateordered <= '2027-01-01' and (ov_infoact0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infoact0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infoact0_.Isactive = 'Y' order by ov_infoact0_.OV_Infoactuaciones_V_ID desc, ov_infoact0_.OV_Infoactuaciones_V_ID desc;
Date: 2026-07-18 09:40:03 Duration: 6s548ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 2m17s 56 1s414ms 4s862ms 2s459ms select ov_cuboinf0_.ov_cuboinfoprop_v_id as ov_cuboi1_887_, ov_cuboinf0_.ad_client_id as ad_clien2_887_, ov_cuboinf0_.ad_org_id as ad_org_i3_887_, ov_cuboinf0_.created as created4_887_, ov_cuboinf0_.createdby as createdb5_887_, ov_cuboinf0_.updated as updated6_887_, ov_cuboinf0_.updatedby as updatedb7_887_, ov_cuboinf0_.isactive as isactive8_887_, ov_cuboinf0_.entrada as entrada9_887_, ov_cuboinf0_.salida as salida10_887_, ov_cuboinf0_.contrato as contrat11_887_, ov_cuboinf0_.c_order_id as c_order12_887_, ov_cuboinf0_.comprainicial as comprai13_887_, ov_cuboinf0_.totalcompra as totalco14_887_, ov_cuboinf0_.dtocompra as dtocomp15_887_, ov_cuboinf0_.documentno as documen16_887_, ov_cuboinf0_.villa as villa17_887_, ov_cuboinf0_.tipo as tipo18_887_, ov_cuboinf0_.tiporeserva as tipores19_887_, ov_cuboinf0_.obre_resource_id as obre_re20_887_, ov_cuboinf0_.m_product_id as m_produ21_887_, ov_cuboinf0_.isfacturado as isfactu22_887_, ov_cuboinf0_.reserva as reserva23_887_, ov_cuboinf0_.extrascompra as extrasc24_887_, ov_cuboinf0_.propietario as propiet25_887_, ov_cuboinf0_.anyo as anyo26_887_, ov_cuboinf0_.venta as venta27_887_, ov_cuboinf0_.venta_final as venta_f28_887_, ov_cuboinf0_.dto_venta as dto_ven29_887_, ov_cuboinf0_.iva as iva30_887_, ov_cuboinf0_.ret as ret31_887_, ov_cuboinf0_.comision as comisio32_887_, ov_cuboinf0_.por_comision as por_com33_887_, ov_cuboinf0_.por_iva as por_iva34_887_, ov_cuboinf0_.por_ret as por_ret35_887_, ov_cuboinf0_.numfactura as numfact36_887_, ov_cuboinf0_.periodo as periodo37_887_, ov_cuboinf0_.invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.obre_resource_id = ? and ov_cuboinf0_.propietario = ? and ov_cuboinf0_.ad_org_id <> ? and (ov_cuboinf0_.tiporeserva = ? or ov_cuboinf0_.tiporeserva = ? or ov_cuboinf0_.tiporeserva = ? or ov_cuboinf0_.tiporeserva = ? or ov_cuboinf0_.tiporeserva = ?) and (ov_cuboinf0_.entrada >= ? and ov_cuboinf0_.entrada <= ? or ov_cuboinf0_.salida >= ? and ov_cuboinf0_.salida <= ?) and (ov_cuboinf0_.ad_org_id in (...)) and (ov_cuboinf0_.ad_client_id in (...)) and ov_cuboinf0_.isactive = ? order by ov_cuboinf0_.ov_cuboinfoprop_v_id desc;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 18 07 2 9s671ms 4s835ms 08 4 8s714ms 2s178ms 09 4 6s940ms 1s735ms 10 14 32s278ms 2s305ms 11 4 7s877ms 1s969ms 12 4 10s312ms 2s578ms 15 18 45s7ms 2s500ms 16 4 9s944ms 2s486ms 20 2 6s982ms 3s491ms [ User: tad - Total duration: 2m17s - Times executed: 56 ]
[ Application: openbravo - Total duration: 2m17s - Times executed: 56 ]
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = '32610F2B2B384030A36374312C07FB6F' and ov_cuboinf0_.Propietario = 'A899E853ABF742F68101763FF4FE7220' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and (ov_cuboinf0_.Tiporeserva = 'a' or ov_cuboinf0_.Tiporeserva = 'b' or ov_cuboinf0_.Tiporeserva = 'c' or ov_cuboinf0_.Tiporeserva = 'd' or ov_cuboinf0_.Tiporeserva = 'e') and (ov_cuboinf0_.Entrada >= '01/01/2026' and ov_cuboinf0_.Entrada <= '31/12/2026' or ov_cuboinf0_.Salida >= '01/01/2026' and ov_cuboinf0_.Salida <= '31/12/2026') and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 07:27:24 Duration: 4s862ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = '32610F2B2B384030A36374312C07FB6F' and ov_cuboinf0_.Propietario = 'A899E853ABF742F68101763FF4FE7220' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and (ov_cuboinf0_.Tiporeserva = 'a' or ov_cuboinf0_.Tiporeserva = 'b' or ov_cuboinf0_.Tiporeserva = 'c' or ov_cuboinf0_.Tiporeserva = 'd' or ov_cuboinf0_.Tiporeserva = 'e') and (ov_cuboinf0_.Entrada >= '01/01/2026' and ov_cuboinf0_.Entrada <= '31/12/2026' or ov_cuboinf0_.Salida >= '01/01/2026' and ov_cuboinf0_.Salida <= '31/12/2026') and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 07:27:18 Duration: 4s808ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = '1677223A01A648FD91F5EA741596896A' and ov_cuboinf0_.Propietario = '9F2A0861FA8743919E43F87346AF9393' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and (ov_cuboinf0_.Tiporeserva = 'a' or ov_cuboinf0_.Tiporeserva = 'b' or ov_cuboinf0_.Tiporeserva = 'c' or ov_cuboinf0_.Tiporeserva = 'd' or ov_cuboinf0_.Tiporeserva = 'e') and (ov_cuboinf0_.Entrada >= '01/01/2026' and ov_cuboinf0_.Entrada <= '31/12/2026' or ov_cuboinf0_.Salida >= '01/01/2026' and ov_cuboinf0_.Salida <= '31/12/2026') and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 20:42:43 Duration: 3s520ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 1m43s 73 1s3ms 2s227ms 1s411ms select ov_infores0_.ov_inforesumen_v_id as ov_infor1_910_, ov_infores0_.ad_client_id as ad_clien2_910_, ov_infores0_.ad_org_id as ad_org_i3_910_, ov_infores0_.created as created4_910_, ov_infores0_.createdby as createdb5_910_, ov_infores0_.updated as updated6_910_, ov_infores0_.updatedby as updatedb7_910_, ov_infores0_.isactive as isactive8_910_, ov_infores0_.fecha as fecha9_910_, ov_infores0_.anyo as anyo10_910_, ov_infores0_.obre_resource_id as obre_re11_910_, ov_infores0_.m_product_id as m_produ12_910_, ov_infores0_.totalgasto as totalga13_910_, ov_infores0_.totalactuaciones as totalac14_910_, ov_infores0_.totalbalance as totalba15_910_, ov_infores0_.totalreservas as totalre16_910_, ov_infores0_.totalfacturas as totalfa17_910_, ov_infores0_.totalhaber as totalha18_910_, ov_infores0_.totaldebe as totalde19_910_, ov_infores0_.propietario as propiet20_910_, ov_infores0_.totalpago as totalpa21_910_ from ov_inforesumen_v ov_infores0_ where ov_infores0_.obre_resource_id = ? and ov_infores0_.propietario = ? and ov_infores0_.ad_org_id <> ? and ov_infores0_.anyo = ? and (ov_infores0_.ad_org_id in (...)) and (ov_infores0_.ad_client_id in (...)) and ov_infores0_.isactive = ? order by ov_infores0_.ov_inforesumen_v_id desc;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 18 07 2 2s766ms 1s383ms 08 7 7s849ms 1s121ms 09 4 5s798ms 1s449ms 10 10 13s67ms 1s306ms 11 3 3s506ms 1s168ms 12 5 6s151ms 1s230ms 15 23 38s860ms 1s689ms 16 2 3s927ms 1s963ms 17 13 16s666ms 1s282ms 20 4 4s472ms 1s118ms [ User: tad - Total duration: 1m43s - Times executed: 73 ]
[ Application: openbravo - Total duration: 1m43s - Times executed: 73 ]
-
select ov_infores0_.OV_Inforesumen_V_ID as ov_infor1_910_, ov_infores0_.AD_Client_ID as ad_clien2_910_, ov_infores0_.AD_Org_ID as ad_org_i3_910_, ov_infores0_.Created as created4_910_, ov_infores0_.Createdby as createdb5_910_, ov_infores0_.Updated as updated6_910_, ov_infores0_.Updatedby as updatedb7_910_, ov_infores0_.Isactive as isactive8_910_, ov_infores0_.Fecha as fecha9_910_, ov_infores0_.Anyo as anyo10_910_, ov_infores0_.Obre_Resource_ID as obre_re11_910_, ov_infores0_.M_Product_ID as m_produ12_910_, ov_infores0_.Totalgasto as totalga13_910_, ov_infores0_.Totalactuaciones as totalac14_910_, ov_infores0_.Totalbalance as totalba15_910_, ov_infores0_.Totalreservas as totalre16_910_, ov_infores0_.Totalfacturas as totalfa17_910_, ov_infores0_.Totalhaber as totalha18_910_, ov_infores0_.Totaldebe as totalde19_910_, ov_infores0_.Propietario as propiet20_910_, ov_infores0_.Totalpago as totalpa21_910_ from ov_inforesumen_v ov_infores0_ where ov_infores0_.Obre_Resource_ID = 'A0BE6D13577547E9B081A56EA6128A79' and ov_infores0_.Propietario = '1E079A1DBF9A45C8998DFA863D75AA60' and ov_infores0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infores0_.Anyo = '2025' and (ov_infores0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infores0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infores0_.Isactive = 'Y' order by ov_infores0_.OV_Inforesumen_V_ID desc;
Date: 2026-07-18 15:57:49 Duration: 2s227ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_infores0_.OV_Inforesumen_V_ID as ov_infor1_910_, ov_infores0_.AD_Client_ID as ad_clien2_910_, ov_infores0_.AD_Org_ID as ad_org_i3_910_, ov_infores0_.Created as created4_910_, ov_infores0_.Createdby as createdb5_910_, ov_infores0_.Updated as updated6_910_, ov_infores0_.Updatedby as updatedb7_910_, ov_infores0_.Isactive as isactive8_910_, ov_infores0_.Fecha as fecha9_910_, ov_infores0_.Anyo as anyo10_910_, ov_infores0_.Obre_Resource_ID as obre_re11_910_, ov_infores0_.M_Product_ID as m_produ12_910_, ov_infores0_.Totalgasto as totalga13_910_, ov_infores0_.Totalactuaciones as totalac14_910_, ov_infores0_.Totalbalance as totalba15_910_, ov_infores0_.Totalreservas as totalre16_910_, ov_infores0_.Totalfacturas as totalfa17_910_, ov_infores0_.Totalhaber as totalha18_910_, ov_infores0_.Totaldebe as totalde19_910_, ov_infores0_.Propietario as propiet20_910_, ov_infores0_.Totalpago as totalpa21_910_ from ov_inforesumen_v ov_infores0_ where ov_infores0_.Obre_Resource_ID = 'A0BE6D13577547E9B081A56EA6128A79' and ov_infores0_.Propietario = '1E079A1DBF9A45C8998DFA863D75AA60' and ov_infores0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infores0_.Anyo = '2026' and (ov_infores0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infores0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infores0_.Isactive = 'Y' order by ov_infores0_.OV_Inforesumen_V_ID desc;
Date: 2026-07-18 16:00:15 Duration: 1s988ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_infores0_.OV_Inforesumen_V_ID as ov_infor1_910_, ov_infores0_.AD_Client_ID as ad_clien2_910_, ov_infores0_.AD_Org_ID as ad_org_i3_910_, ov_infores0_.Created as created4_910_, ov_infores0_.Createdby as createdb5_910_, ov_infores0_.Updated as updated6_910_, ov_infores0_.Updatedby as updatedb7_910_, ov_infores0_.Isactive as isactive8_910_, ov_infores0_.Fecha as fecha9_910_, ov_infores0_.Anyo as anyo10_910_, ov_infores0_.Obre_Resource_ID as obre_re11_910_, ov_infores0_.M_Product_ID as m_produ12_910_, ov_infores0_.Totalgasto as totalga13_910_, ov_infores0_.Totalactuaciones as totalac14_910_, ov_infores0_.Totalbalance as totalba15_910_, ov_infores0_.Totalreservas as totalre16_910_, ov_infores0_.Totalfacturas as totalfa17_910_, ov_infores0_.Totalhaber as totalha18_910_, ov_infores0_.Totaldebe as totalde19_910_, ov_infores0_.Propietario as propiet20_910_, ov_infores0_.Totalpago as totalpa21_910_ from ov_inforesumen_v ov_infores0_ where ov_infores0_.Obre_Resource_ID = 'A0BE6D13577547E9B081A56EA6128A79' and ov_infores0_.Propietario = '1E079A1DBF9A45C8998DFA863D75AA60' and ov_infores0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infores0_.Anyo = '2026' and (ov_infores0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infores0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infores0_.Isactive = 'Y' order by ov_infores0_.OV_Inforesumen_V_ID desc;
Date: 2026-07-18 15:58:11 Duration: 1s960ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
5 1m4s 26 1s376ms 4s943ms 2s462ms select ov_cuboinf0_.ov_cuboinfoprop_v_id as ov_cuboi1_887_, ov_cuboinf0_.ad_client_id as ad_clien2_887_, ov_cuboinf0_.ad_org_id as ad_org_i3_887_, ov_cuboinf0_.created as created4_887_, ov_cuboinf0_.createdby as createdb5_887_, ov_cuboinf0_.updated as updated6_887_, ov_cuboinf0_.updatedby as updatedb7_887_, ov_cuboinf0_.isactive as isactive8_887_, ov_cuboinf0_.entrada as entrada9_887_, ov_cuboinf0_.salida as salida10_887_, ov_cuboinf0_.contrato as contrat11_887_, ov_cuboinf0_.c_order_id as c_order12_887_, ov_cuboinf0_.comprainicial as comprai13_887_, ov_cuboinf0_.totalcompra as totalco14_887_, ov_cuboinf0_.dtocompra as dtocomp15_887_, ov_cuboinf0_.documentno as documen16_887_, ov_cuboinf0_.villa as villa17_887_, ov_cuboinf0_.tipo as tipo18_887_, ov_cuboinf0_.tiporeserva as tipores19_887_, ov_cuboinf0_.obre_resource_id as obre_re20_887_, ov_cuboinf0_.m_product_id as m_produ21_887_, ov_cuboinf0_.isfacturado as isfactu22_887_, ov_cuboinf0_.reserva as reserva23_887_, ov_cuboinf0_.extrascompra as extrasc24_887_, ov_cuboinf0_.propietario as propiet25_887_, ov_cuboinf0_.anyo as anyo26_887_, ov_cuboinf0_.venta as venta27_887_, ov_cuboinf0_.venta_final as venta_f28_887_, ov_cuboinf0_.dto_venta as dto_ven29_887_, ov_cuboinf0_.iva as iva30_887_, ov_cuboinf0_.ret as ret31_887_, ov_cuboinf0_.comision as comisio32_887_, ov_cuboinf0_.por_comision as por_com33_887_, ov_cuboinf0_.por_iva as por_iva34_887_, ov_cuboinf0_.por_ret as por_ret35_887_, ov_cuboinf0_.numfactura as numfact36_887_, ov_cuboinf0_.periodo as periodo37_887_, ov_cuboinf0_.invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.obre_resource_id = ? and ov_cuboinf0_.propietario = ? and ov_cuboinf0_.ad_org_id <> ? and ov_cuboinf0_.tiporeserva <> ? and ov_cuboinf0_.invoicedate >= ? and ov_cuboinf0_.invoicedate <= ? and (ov_cuboinf0_.ad_org_id in (...)) and (ov_cuboinf0_.ad_client_id in (...)) and ov_cuboinf0_.isactive = ? order by ov_cuboinf0_.invoicedate desc, ov_cuboinf0_.ov_cuboinfoprop_v_id desc;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 18 07 2 9s826ms 4s913ms 08 3 7s331ms 2s443ms 09 4 5s897ms 1s474ms 10 10 23s852ms 2s385ms 11 2 3s330ms 1s665ms 12 4 10s962ms 2s740ms 16 1 2s827ms 2s827ms [ User: tad - Total duration: 1m4s - Times executed: 26 ]
[ Application: openbravo - Total duration: 1m4s - Times executed: 26 ]
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = '32610F2B2B384030A36374312C07FB6F' and ov_cuboinf0_.Propietario = 'A899E853ABF742F68101763FF4FE7220' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_cuboinf0_.Tiporeserva <> 'z' and ov_cuboinf0_.Invoicedate >= '01/01/2026' and ov_cuboinf0_.Invoicedate <= '01/01/2027' and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.Invoicedate desc, ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 07:27:30 Duration: 4s943ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = '32610F2B2B384030A36374312C07FB6F' and ov_cuboinf0_.Propietario = 'A899E853ABF742F68101763FF4FE7220' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_cuboinf0_.Tiporeserva <> 'z' and ov_cuboinf0_.Invoicedate >= '01/01/2026' and ov_cuboinf0_.Invoicedate <= '01/01/2027' and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.Invoicedate desc, ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 07:27:35 Duration: 4s882ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = 'F434941C6CFF45C3803DECEF8653ECE4' and ov_cuboinf0_.Propietario = '6FB6D561CBBB4F498BE9595B39D48E1C' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_cuboinf0_.Tiporeserva <> 'z' and ov_cuboinf0_.Invoicedate >= '01/01/2026' and ov_cuboinf0_.Invoicedate <= '01/01/2027' and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.Invoicedate desc, ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 12:51:37 Duration: 3s470ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
6 30s343ms 24 1s1ms 2s99ms 1s264ms update c_order set updated = ?, c_paymentterm_id = ? where c_order_id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 18 09 24 30s343ms 1s264ms [ User: tad - Total duration: 30s343ms - Times executed: 24 ]
[ Application: openbravo - Total duration: 30s343ms - Times executed: 24 ]
-
update C_Order set Updated = '2026-07-18 09:11:47.753', C_PaymentTerm_ID = 'D8CD13F170C942E4A7498583E08E1F6E' where C_Order_ID = '8BD987CC4C264BA28D9FB29A5210A7F0';
Date: 2026-07-18 09:11:49 Duration: 2s99ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update C_Order set Updated = '2026-07-18 09:11:49.076', C_PaymentTerm_ID = 'D8CD13F170C942E4A7498583E08E1F6E' where C_Order_ID = '8BD987CC4C264BA28D9FB29A5210A7F0';
Date: 2026-07-18 09:11:50 Duration: 1s671ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update C_Order set Updated = '2026-07-18 09:11:49.72', C_PaymentTerm_ID = '8D91F90A4392451D89D8F7995D4BF884' where C_Order_ID = '8BD987CC4C264BA28D9FB29A5210A7F0';
Date: 2026-07-18 09:11:51 Duration: 1s598ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
7 26s441ms 2 11s209ms 15s231ms 13s220ms select * from ov_calofertas (null);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 18 14 1 15s231ms 15s231ms 17 1 11s209ms 11s209ms [ User: tad - Total duration: 26s441ms - Times executed: 2 ]
[ Application: openbravo - Total duration: 26s441ms - Times executed: 2 ]
-
SELECT * FROM OV_CALOFERTAS (NULL);
Date: 2026-07-18 14:22:44 Duration: 15s231ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM OV_CALOFERTAS (NULL);
Date: 2026-07-18 17:25:09 Duration: 11s209ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
8 4s83ms 1 4s83ms 4s83ms 4s83ms select ov_bireser0_.ov_bireservas_v_id as ov_bires1_881_, ov_bireser0_.ad_client_id as ad_clien2_881_, ov_bireser0_.ad_org_id as ad_org_i3_881_, ov_bireser0_.isactive as isactive4_881_, ov_bireser0_.created as created5_881_, ov_bireser0_.createdby as createdb6_881_, ov_bireser0_.updated as updated7_881_, ov_bireser0_.updatedby as updatedb8_881_, ov_bireser0_.oficina as oficina9_881_, ov_bireser0_.villa as villa10_881_, ov_bireser0_.value as value11_881_, ov_bireser0_.reserva as reserva12_881_, ov_bireser0_.docstatus as docstat13_881_, ov_bireser0_.notas as notas14_881_, ov_bireser0_.dateordered as dateord15_881_, ov_bireser0_.num_noches as num_noc16_881_, ov_bireser0_.anyo as anyo17_881_, ov_bireser0_.datein as datein18_881_, ov_bireser0_.dateout as dateout19_881_, ov_bireser0_.c_bpartner_id as c_bpart20_881_, ov_bireser0_.huesped_id as huesped21_881_, ov_bireser0_.c_bpartner_location_id as c_bpart22_881_, ov_bireser0_.cliente as cliente23_881_, ov_bireser0_.mail as mail24_881_, ov_bireser0_.telf as telf25_881_, ov_bireser0_.pais as pais26_881_, ov_bireser0_.codigopais as codigop27_881_, ov_bireser0_.fechaconfirmacion as fechaco28_881_, ov_bireser0_.pagado as pagado29_881_, ov_bireser0_.grandtotal as grandto30_881_, ov_bireser0_.totallines as totalli31_881_, ov_bireser0_.alquiler as alquile32_881_, ov_bireser0_.dtoalquiler as dtoalqu33_881_, ov_bireser0_.energia as energia34_881_, ov_bireser0_.limpieza as limpiez35_881_, ov_bireser0_.dtopagocompleto as dtopago36_881_, ov_bireser0_.extras as extras37_881_, ov_bireser0_.m_warehouse_id as m_wareh38_881_, ov_bireser0_.c_project_id as c_proje39_881_, ov_bireser0_.nota_salida as nota_sa40_881_, ov_bireser0_.nota_cliente as nota_cl41_881_, ov_bireser0_.nota_entrada as nota_en42_881_, ov_bireser0_.esreserva as esreser43_881_, ov_bireser0_.tipo as tipo44_881_, ov_bireser0_.obre_resource_id as obre_re45_881_, ov_bireser0_.pax as pax46_881_, ov_bireser0_.adultpax as adultpa47_881_, ov_bireser0_.childpax as childpa48_881_, ov_bireser0_.horallegada as horalle49_881_, ov_bireser0_.esbono as esbono50_881_, ov_bireser0_.bono_id as bono_id51_881_, ov_bireser0_.fecha_anulacion as fecha_a52_881_, ov_bireser0_.estado as estado53_881_, ov_bireser0_.error as error54_881_, ov_bireser0_.salesrep_id as salesre55_881_, ov_bireser0_.responsable_id as respons56_881_, ov_bireser0_.agencia as agencia57_881_, ov_bireser0_.responsablecheckin as respons58_881_, ov_bireser0_.horaentrada as horaent59_881_, ov_bireser0_.limpieza_entrada as limpiez60_881_, ov_bireser0_.limpieza_salida as limpiez61_881_, ov_bireser0_.cuna as cuna62_881_, ov_bireser0_.mascotas as mascota63_881_, ov_bireser0_.ventilador as ventila64_881_, ov_bireser0_.trona as trona65_881_, ov_bireser0_.cama as cama66_881_, ov_bireser0_.latearrival as latearr67_881_, ov_bireser0_.seguroflexible as segurof68_881_, ov_bireser0_.seguroanulacion as seguroa69_881_, ov_bireser0_.languageiso as languag70_881_, ov_bireser0_.ventacuna as ventacu71_881_, ov_bireser0_.ventamascotas as ventama72_881_, ov_bireser0_.ventaventilador as ventave73_881_, ov_bireser0_.ventatrona as ventatr74_881_, ov_bireser0_.ventacama as ventaca75_881_, ov_bireser0_.ventalatearrival as ventala76_881_, ov_bireser0_.ventaseguroflexible as ventase77_881_, ov_bireser0_.ventaseguroanulacion as ventase78_881_, ov_bireser0_.comision as comisio79_881_, ov_bireser0_.tienebono as tienebo80_881_, ov_bireser0_.nuevareserva as nuevare81_881_, ov_bireser0_.contract_type_id as contrac82_881_, ov_bireser0_.gastosadmin as gastosa83_881_, ov_bireser0_.ventagastosadmin as ventaga84_881_, ov_bireser0_.tarifaflexible as tarifaf85_881_, ov_bireser0_.ventatarifaflexible as ventata86_881_, ov_bireser0_.salidaanteior as salidaa87_881_, ov_bireser0_.entradasiguiente as entrada88_881_, ov_bireser0_.c_paymentterm_id as c_payme89_881_, ov_bireser0_.formapago as formapa90_881_, ov_bireser0_.nifcif as nifcif91_881_, ov_bireser0_.tipodocumento as tipodoc92_881_, ov_bireser0_.diractiva as diracti93_881_, ov_bireser0_.direccion as direcci94_881_, ov_bireser0_.ciudad as ciudad95_881_, ov_bireser0_.cp as cp96_881_, ov_bireser0_.region as region97_881_ from ov_bireservas_v ov_bireser0_ where ov_bireser0_.ad_org_id = ? and ov_bireser0_.datein >= ? and ov_bireser0_.datein < ? and ov_bireser0_.updated > now() ? and (ov_bireser0_.ad_org_id in (...)) and (ov_bireser0_.ad_client_id in (...)) and ov_bireser0_.isactive = ? order by ov_bireser0_.dateout, ov_bireser0_.ov_bireservas_v_id;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 18 16 1 4s83ms 4s83ms [ User: tad - Total duration: 4s83ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 4s83ms - Times executed: 1 ]
-
select ov_bireser0_.OV_Bireservas_V_ID as ov_bires1_881_, ov_bireser0_.AD_Client_ID as ad_clien2_881_, ov_bireser0_.AD_Org_ID as ad_org_i3_881_, ov_bireser0_.Isactive as isactive4_881_, ov_bireser0_.Created as created5_881_, ov_bireser0_.Createdby as createdb6_881_, ov_bireser0_.Updated as updated7_881_, ov_bireser0_.Updatedby as updatedb8_881_, ov_bireser0_.Oficina as oficina9_881_, ov_bireser0_.Villa as villa10_881_, ov_bireser0_.Value as value11_881_, ov_bireser0_.Reserva as reserva12_881_, ov_bireser0_.Docstatus as docstat13_881_, ov_bireser0_.Notas as notas14_881_, ov_bireser0_.Dateordered as dateord15_881_, ov_bireser0_.NUM_Noches as num_noc16_881_, ov_bireser0_.Anyo as anyo17_881_, ov_bireser0_.Datein as datein18_881_, ov_bireser0_.Dateout as dateout19_881_, ov_bireser0_.C_Bpartner_ID as c_bpart20_881_, ov_bireser0_.Huesped_ID as huesped21_881_, ov_bireser0_.C_Bpartner_Location_ID as c_bpart22_881_, ov_bireser0_.Cliente as cliente23_881_, ov_bireser0_.Mail as mail24_881_, ov_bireser0_.Telf as telf25_881_, ov_bireser0_.Pais as pais26_881_, ov_bireser0_.Codigopais as codigop27_881_, ov_bireser0_.Fechaconfirmacion as fechaco28_881_, ov_bireser0_.Pagado as pagado29_881_, ov_bireser0_.Grandtotal as grandto30_881_, ov_bireser0_.Totallines as totalli31_881_, ov_bireser0_.Alquiler as alquile32_881_, ov_bireser0_.Dtoalquiler as dtoalqu33_881_, ov_bireser0_.Energia as energia34_881_, ov_bireser0_.Limpieza as limpiez35_881_, ov_bireser0_.Dtopagocompleto as dtopago36_881_, ov_bireser0_.Extras as extras37_881_, ov_bireser0_.M_Warehouse_ID as m_wareh38_881_, ov_bireser0_.C_Project_ID as c_proje39_881_, ov_bireser0_.Nota_Salida as nota_sa40_881_, ov_bireser0_.Nota_Cliente as nota_cl41_881_, ov_bireser0_.Nota_Entrada as nota_en42_881_, ov_bireser0_.Esreserva as esreser43_881_, ov_bireser0_.Tipo as tipo44_881_, ov_bireser0_.Obre_Resource_ID as obre_re45_881_, ov_bireser0_.Pax as pax46_881_, ov_bireser0_.Adultpax as adultpa47_881_, ov_bireser0_.Childpax as childpa48_881_, ov_bireser0_.Horallegada as horalle49_881_, ov_bireser0_.Esbono as esbono50_881_, ov_bireser0_.Bono_ID as bono_id51_881_, ov_bireser0_.Fecha_Anulacion as fecha_a52_881_, ov_bireser0_.Estado as estado53_881_, ov_bireser0_.Error as error54_881_, ov_bireser0_.Salesrep_ID as salesre55_881_, ov_bireser0_.Responsable_ID as respons56_881_, ov_bireser0_.Agencia as agencia57_881_, ov_bireser0_.Responsablecheckin as respons58_881_, ov_bireser0_.Horaentrada as horaent59_881_, ov_bireser0_.Limpieza_Entrada as limpiez60_881_, ov_bireser0_.Limpieza_Salida as limpiez61_881_, ov_bireser0_.Cuna as cuna62_881_, ov_bireser0_.Mascotas as mascota63_881_, ov_bireser0_.Ventilador as ventila64_881_, ov_bireser0_.Trona as trona65_881_, ov_bireser0_.Cama as cama66_881_, ov_bireser0_.Latearrival as latearr67_881_, ov_bireser0_.Seguroflexible as segurof68_881_, ov_bireser0_.Seguroanulacion as seguroa69_881_, ov_bireser0_.Languageiso as languag70_881_, ov_bireser0_.Ventacuna as ventacu71_881_, ov_bireser0_.Ventamascotas as ventama72_881_, ov_bireser0_.Ventaventilador as ventave73_881_, ov_bireser0_.Ventatrona as ventatr74_881_, ov_bireser0_.Ventacama as ventaca75_881_, ov_bireser0_.Ventalatearrival as ventala76_881_, ov_bireser0_.Ventaseguroflexible as ventase77_881_, ov_bireser0_.Ventaseguroanulacion as ventase78_881_, ov_bireser0_.Comision as comisio79_881_, ov_bireser0_.Tienebono as tienebo80_881_, ov_bireser0_.Nuevareserva as nuevare81_881_, ov_bireser0_.Contract_Type_ID as contrac82_881_, ov_bireser0_.Gastosadmin as gastosa83_881_, ov_bireser0_.Ventagastosadmin as ventaga84_881_, ov_bireser0_.Tarifaflexible as tarifaf85_881_, ov_bireser0_.Ventatarifaflexible as ventata86_881_, ov_bireser0_.Salidaanteior as salidaa87_881_, ov_bireser0_.Entradasiguiente as entrada88_881_, ov_bireser0_.C_Paymentterm_ID as c_payme89_881_, ov_bireser0_.Formapago as formapa90_881_, ov_bireser0_.Nifcif as nifcif91_881_, ov_bireser0_.Tipodocumento as tipodoc92_881_, ov_bireser0_.Diractiva as diracti93_881_, ov_bireser0_.Direccion as direcci94_881_, ov_bireser0_.Ciudad as ciudad95_881_, ov_bireser0_.Cp as cp96_881_, ov_bireser0_.Region as region97_881_ from ov_bireservas_v ov_bireser0_ where ov_bireser0_.AD_Org_ID = 'A773FA4025394EA8A1E37364E1DE3D47' and ov_bireser0_.Datein >= '01-01-2026' and ov_bireser0_.Datein < '01-01-2028' and ov_bireser0_.Updated > now() - 10 and (ov_bireser0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_bireser0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_bireser0_.Isactive = 'Y' order by ov_bireser0_.Dateout, ov_bireser0_.OV_Bireservas_V_ID;
Date: 2026-07-18 16:00:13 Duration: 4s83ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 81 3m1s 1s25ms 6s644ms 2s240ms select ov_infoact0_.ov_infoactuaciones_v_id as ov_infoa1_900_, ov_infoact0_.ad_client_id as ad_clien2_900_, ov_infoact0_.ad_org_id as ad_org_i3_900_, ov_infoact0_.isactive as isactive4_900_, ov_infoact0_.created as created5_900_, ov_infoact0_.createdby as createdb6_900_, ov_infoact0_.updated as updated7_900_, ov_infoact0_.updatedby as updatedb8_900_, ov_infoact0_.dateordered as dateorde9_900_, ov_infoact0_.obre_resource_id as obre_re10_900_, ov_infoact0_.c_order_id as c_order11_900_, ov_infoact0_.documentno as documen12_900_, ov_infoact0_.anyo as anyo13_900_, ov_infoact0_.description as descrip14_900_, ov_infoact0_.extrapropietario as extrapr15_900_, ov_infoact0_.importe as importe16_900_, ov_infoact0_.total_compra as total_c17_900_, ov_infoact0_.resto as resto18_900_, ov_infoact0_.tipo as tipo19_900_, ov_infoact0_.isfacturado as isfactu20_900_, ov_infoact0_.propietario as propiet21_900_, ov_infoact0_.isservicio as isservi22_900_, ov_infoact0_.numfactura as numfact23_900_, ov_infoact0_.tipogasto as tipogas24_900_, ov_infoact0_.periodo as periodo25_900_, ov_infoact0_.detalle as detalle26_900_ from ov_infoactuaciones_v ov_infoact0_ where obre_resource_id = ? and ov_infoact0_.ad_org_id <> ? and ov_infoact0_.propietario = ? and ov_infoact0_.extrapropietario = ? and ov_infoact0_.dateordered >= ? and ov_infoact0_.dateordered <= ? and (ov_infoact0_.ad_org_id in (...)) and (ov_infoact0_.ad_client_id in (...)) and ov_infoact0_.isactive = ? order by ov_infoact0_.ov_infoactuaciones_v_id desc, ov_infoact0_.ov_infoactuaciones_v_id desc;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 18 07 4 10s352ms 2s588ms 08 9 21s290ms 2s365ms 09 11 29s960ms 2s723ms 10 16 27s370ms 1s710ms 11 2 2s928ms 1s464ms 12 6 10s819ms 1s803ms 15 7 28s308ms 4s44ms 16 1 1s178ms 1s178ms 17 23 43s76ms 1s872ms 19 1 1s396ms 1s396ms 20 1 4s774ms 4s774ms [ User: tad - Total duration: 3m1s - Times executed: 81 ]
[ Application: openbravo - Total duration: 3m1s - Times executed: 81 ]
-
select ov_infoact0_.OV_Infoactuaciones_V_ID as ov_infoa1_900_, ov_infoact0_.AD_Client_ID as ad_clien2_900_, ov_infoact0_.AD_Org_ID as ad_org_i3_900_, ov_infoact0_.Isactive as isactive4_900_, ov_infoact0_.Created as created5_900_, ov_infoact0_.Createdby as createdb6_900_, ov_infoact0_.Updated as updated7_900_, ov_infoact0_.Updatedby as updatedb8_900_, ov_infoact0_.Dateordered as dateorde9_900_, ov_infoact0_.Obre_Resource_ID as obre_re10_900_, ov_infoact0_.C_Order_ID as c_order11_900_, ov_infoact0_.Documentno as documen12_900_, ov_infoact0_.Anyo as anyo13_900_, ov_infoact0_.Description as descrip14_900_, ov_infoact0_.Extrapropietario as extrapr15_900_, ov_infoact0_.Importe as importe16_900_, ov_infoact0_.Total_Compra as total_c17_900_, ov_infoact0_.Resto as resto18_900_, ov_infoact0_.Tipo as tipo19_900_, ov_infoact0_.Isfacturado as isfactu20_900_, ov_infoact0_.Propietario as propiet21_900_, ov_infoact0_.Isservicio as isservi22_900_, ov_infoact0_.Numfactura as numfact23_900_, ov_infoact0_.Tipogasto as tipogas24_900_, ov_infoact0_.Periodo as periodo25_900_, ov_infoact0_.Detalle as detalle26_900_ from ov_infoactuaciones_v ov_infoact0_ where obre_resource_id = '3EF97DA965B54C7BB4856C90275F6BC1' and ov_infoact0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infoact0_.Propietario = '455F2D24F14B4513B2D51486814A386E' and ov_infoact0_.Extrapropietario = 'Y' and ov_infoact0_.Dateordered >= '2026-01-01' and ov_infoact0_.Dateordered <= '2027-01-01' and (ov_infoact0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infoact0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infoact0_.Isactive = 'Y' order by ov_infoact0_.OV_Infoactuaciones_V_ID desc, ov_infoact0_.OV_Infoactuaciones_V_ID desc;
Date: 2026-07-18 15:54:54 Duration: 6s644ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_infoact0_.OV_Infoactuaciones_V_ID as ov_infoa1_900_, ov_infoact0_.AD_Client_ID as ad_clien2_900_, ov_infoact0_.AD_Org_ID as ad_org_i3_900_, ov_infoact0_.Isactive as isactive4_900_, ov_infoact0_.Created as created5_900_, ov_infoact0_.Createdby as createdb6_900_, ov_infoact0_.Updated as updated7_900_, ov_infoact0_.Updatedby as updatedb8_900_, ov_infoact0_.Dateordered as dateorde9_900_, ov_infoact0_.Obre_Resource_ID as obre_re10_900_, ov_infoact0_.C_Order_ID as c_order11_900_, ov_infoact0_.Documentno as documen12_900_, ov_infoact0_.Anyo as anyo13_900_, ov_infoact0_.Description as descrip14_900_, ov_infoact0_.Extrapropietario as extrapr15_900_, ov_infoact0_.Importe as importe16_900_, ov_infoact0_.Total_Compra as total_c17_900_, ov_infoact0_.Resto as resto18_900_, ov_infoact0_.Tipo as tipo19_900_, ov_infoact0_.Isfacturado as isfactu20_900_, ov_infoact0_.Propietario as propiet21_900_, ov_infoact0_.Isservicio as isservi22_900_, ov_infoact0_.Numfactura as numfact23_900_, ov_infoact0_.Tipogasto as tipogas24_900_, ov_infoact0_.Periodo as periodo25_900_, ov_infoact0_.Detalle as detalle26_900_ from ov_infoactuaciones_v ov_infoact0_ where obre_resource_id = '3EF97DA965B54C7BB4856C90275F6BC1' and ov_infoact0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infoact0_.Propietario = '455F2D24F14B4513B2D51486814A386E' and ov_infoact0_.Extrapropietario = 'Y' and ov_infoact0_.Dateordered >= '2026-01-01' and ov_infoact0_.Dateordered <= '2027-01-01' and (ov_infoact0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infoact0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infoact0_.Isactive = 'Y' order by ov_infoact0_.OV_Infoactuaciones_V_ID desc, ov_infoact0_.OV_Infoactuaciones_V_ID desc;
Date: 2026-07-18 15:55:01 Duration: 6s604ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_infoact0_.OV_Infoactuaciones_V_ID as ov_infoa1_900_, ov_infoact0_.AD_Client_ID as ad_clien2_900_, ov_infoact0_.AD_Org_ID as ad_org_i3_900_, ov_infoact0_.Isactive as isactive4_900_, ov_infoact0_.Created as created5_900_, ov_infoact0_.Createdby as createdb6_900_, ov_infoact0_.Updated as updated7_900_, ov_infoact0_.Updatedby as updatedb8_900_, ov_infoact0_.Dateordered as dateorde9_900_, ov_infoact0_.Obre_Resource_ID as obre_re10_900_, ov_infoact0_.C_Order_ID as c_order11_900_, ov_infoact0_.Documentno as documen12_900_, ov_infoact0_.Anyo as anyo13_900_, ov_infoact0_.Description as descrip14_900_, ov_infoact0_.Extrapropietario as extrapr15_900_, ov_infoact0_.Importe as importe16_900_, ov_infoact0_.Total_Compra as total_c17_900_, ov_infoact0_.Resto as resto18_900_, ov_infoact0_.Tipo as tipo19_900_, ov_infoact0_.Isfacturado as isfactu20_900_, ov_infoact0_.Propietario as propiet21_900_, ov_infoact0_.Isservicio as isservi22_900_, ov_infoact0_.Numfactura as numfact23_900_, ov_infoact0_.Tipogasto as tipogas24_900_, ov_infoact0_.Periodo as periodo25_900_, ov_infoact0_.Detalle as detalle26_900_ from ov_infoactuaciones_v ov_infoact0_ where obre_resource_id = '3EF97DA965B54C7BB4856C90275F6BC1' and ov_infoact0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infoact0_.Propietario = '455F2D24F14B4513B2D51486814A386E' and ov_infoact0_.Extrapropietario = 'Y' and ov_infoact0_.Dateordered >= '2026-01-01' and ov_infoact0_.Dateordered <= '2027-01-01' and (ov_infoact0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infoact0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infoact0_.Isactive = 'Y' order by ov_infoact0_.OV_Infoactuaciones_V_ID desc, ov_infoact0_.OV_Infoactuaciones_V_ID desc;
Date: 2026-07-18 09:40:03 Duration: 6s548ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 73 1m43s 1s3ms 2s227ms 1s411ms select ov_infores0_.ov_inforesumen_v_id as ov_infor1_910_, ov_infores0_.ad_client_id as ad_clien2_910_, ov_infores0_.ad_org_id as ad_org_i3_910_, ov_infores0_.created as created4_910_, ov_infores0_.createdby as createdb5_910_, ov_infores0_.updated as updated6_910_, ov_infores0_.updatedby as updatedb7_910_, ov_infores0_.isactive as isactive8_910_, ov_infores0_.fecha as fecha9_910_, ov_infores0_.anyo as anyo10_910_, ov_infores0_.obre_resource_id as obre_re11_910_, ov_infores0_.m_product_id as m_produ12_910_, ov_infores0_.totalgasto as totalga13_910_, ov_infores0_.totalactuaciones as totalac14_910_, ov_infores0_.totalbalance as totalba15_910_, ov_infores0_.totalreservas as totalre16_910_, ov_infores0_.totalfacturas as totalfa17_910_, ov_infores0_.totalhaber as totalha18_910_, ov_infores0_.totaldebe as totalde19_910_, ov_infores0_.propietario as propiet20_910_, ov_infores0_.totalpago as totalpa21_910_ from ov_inforesumen_v ov_infores0_ where ov_infores0_.obre_resource_id = ? and ov_infores0_.propietario = ? and ov_infores0_.ad_org_id <> ? and ov_infores0_.anyo = ? and (ov_infores0_.ad_org_id in (...)) and (ov_infores0_.ad_client_id in (...)) and ov_infores0_.isactive = ? order by ov_infores0_.ov_inforesumen_v_id desc;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 18 07 2 2s766ms 1s383ms 08 7 7s849ms 1s121ms 09 4 5s798ms 1s449ms 10 10 13s67ms 1s306ms 11 3 3s506ms 1s168ms 12 5 6s151ms 1s230ms 15 23 38s860ms 1s689ms 16 2 3s927ms 1s963ms 17 13 16s666ms 1s282ms 20 4 4s472ms 1s118ms [ User: tad - Total duration: 1m43s - Times executed: 73 ]
[ Application: openbravo - Total duration: 1m43s - Times executed: 73 ]
-
select ov_infores0_.OV_Inforesumen_V_ID as ov_infor1_910_, ov_infores0_.AD_Client_ID as ad_clien2_910_, ov_infores0_.AD_Org_ID as ad_org_i3_910_, ov_infores0_.Created as created4_910_, ov_infores0_.Createdby as createdb5_910_, ov_infores0_.Updated as updated6_910_, ov_infores0_.Updatedby as updatedb7_910_, ov_infores0_.Isactive as isactive8_910_, ov_infores0_.Fecha as fecha9_910_, ov_infores0_.Anyo as anyo10_910_, ov_infores0_.Obre_Resource_ID as obre_re11_910_, ov_infores0_.M_Product_ID as m_produ12_910_, ov_infores0_.Totalgasto as totalga13_910_, ov_infores0_.Totalactuaciones as totalac14_910_, ov_infores0_.Totalbalance as totalba15_910_, ov_infores0_.Totalreservas as totalre16_910_, ov_infores0_.Totalfacturas as totalfa17_910_, ov_infores0_.Totalhaber as totalha18_910_, ov_infores0_.Totaldebe as totalde19_910_, ov_infores0_.Propietario as propiet20_910_, ov_infores0_.Totalpago as totalpa21_910_ from ov_inforesumen_v ov_infores0_ where ov_infores0_.Obre_Resource_ID = 'A0BE6D13577547E9B081A56EA6128A79' and ov_infores0_.Propietario = '1E079A1DBF9A45C8998DFA863D75AA60' and ov_infores0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infores0_.Anyo = '2025' and (ov_infores0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infores0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infores0_.Isactive = 'Y' order by ov_infores0_.OV_Inforesumen_V_ID desc;
Date: 2026-07-18 15:57:49 Duration: 2s227ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_infores0_.OV_Inforesumen_V_ID as ov_infor1_910_, ov_infores0_.AD_Client_ID as ad_clien2_910_, ov_infores0_.AD_Org_ID as ad_org_i3_910_, ov_infores0_.Created as created4_910_, ov_infores0_.Createdby as createdb5_910_, ov_infores0_.Updated as updated6_910_, ov_infores0_.Updatedby as updatedb7_910_, ov_infores0_.Isactive as isactive8_910_, ov_infores0_.Fecha as fecha9_910_, ov_infores0_.Anyo as anyo10_910_, ov_infores0_.Obre_Resource_ID as obre_re11_910_, ov_infores0_.M_Product_ID as m_produ12_910_, ov_infores0_.Totalgasto as totalga13_910_, ov_infores0_.Totalactuaciones as totalac14_910_, ov_infores0_.Totalbalance as totalba15_910_, ov_infores0_.Totalreservas as totalre16_910_, ov_infores0_.Totalfacturas as totalfa17_910_, ov_infores0_.Totalhaber as totalha18_910_, ov_infores0_.Totaldebe as totalde19_910_, ov_infores0_.Propietario as propiet20_910_, ov_infores0_.Totalpago as totalpa21_910_ from ov_inforesumen_v ov_infores0_ where ov_infores0_.Obre_Resource_ID = 'A0BE6D13577547E9B081A56EA6128A79' and ov_infores0_.Propietario = '1E079A1DBF9A45C8998DFA863D75AA60' and ov_infores0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infores0_.Anyo = '2026' and (ov_infores0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infores0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infores0_.Isactive = 'Y' order by ov_infores0_.OV_Inforesumen_V_ID desc;
Date: 2026-07-18 16:00:15 Duration: 1s988ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_infores0_.OV_Inforesumen_V_ID as ov_infor1_910_, ov_infores0_.AD_Client_ID as ad_clien2_910_, ov_infores0_.AD_Org_ID as ad_org_i3_910_, ov_infores0_.Created as created4_910_, ov_infores0_.Createdby as createdb5_910_, ov_infores0_.Updated as updated6_910_, ov_infores0_.Updatedby as updatedb7_910_, ov_infores0_.Isactive as isactive8_910_, ov_infores0_.Fecha as fecha9_910_, ov_infores0_.Anyo as anyo10_910_, ov_infores0_.Obre_Resource_ID as obre_re11_910_, ov_infores0_.M_Product_ID as m_produ12_910_, ov_infores0_.Totalgasto as totalga13_910_, ov_infores0_.Totalactuaciones as totalac14_910_, ov_infores0_.Totalbalance as totalba15_910_, ov_infores0_.Totalreservas as totalre16_910_, ov_infores0_.Totalfacturas as totalfa17_910_, ov_infores0_.Totalhaber as totalha18_910_, ov_infores0_.Totaldebe as totalde19_910_, ov_infores0_.Propietario as propiet20_910_, ov_infores0_.Totalpago as totalpa21_910_ from ov_inforesumen_v ov_infores0_ where ov_infores0_.Obre_Resource_ID = 'A0BE6D13577547E9B081A56EA6128A79' and ov_infores0_.Propietario = '1E079A1DBF9A45C8998DFA863D75AA60' and ov_infores0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infores0_.Anyo = '2026' and (ov_infores0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infores0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infores0_.Isactive = 'Y' order by ov_infores0_.OV_Inforesumen_V_ID desc;
Date: 2026-07-18 15:58:11 Duration: 1s960ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 56 2m17s 1s414ms 4s862ms 2s459ms select ov_cuboinf0_.ov_cuboinfoprop_v_id as ov_cuboi1_887_, ov_cuboinf0_.ad_client_id as ad_clien2_887_, ov_cuboinf0_.ad_org_id as ad_org_i3_887_, ov_cuboinf0_.created as created4_887_, ov_cuboinf0_.createdby as createdb5_887_, ov_cuboinf0_.updated as updated6_887_, ov_cuboinf0_.updatedby as updatedb7_887_, ov_cuboinf0_.isactive as isactive8_887_, ov_cuboinf0_.entrada as entrada9_887_, ov_cuboinf0_.salida as salida10_887_, ov_cuboinf0_.contrato as contrat11_887_, ov_cuboinf0_.c_order_id as c_order12_887_, ov_cuboinf0_.comprainicial as comprai13_887_, ov_cuboinf0_.totalcompra as totalco14_887_, ov_cuboinf0_.dtocompra as dtocomp15_887_, ov_cuboinf0_.documentno as documen16_887_, ov_cuboinf0_.villa as villa17_887_, ov_cuboinf0_.tipo as tipo18_887_, ov_cuboinf0_.tiporeserva as tipores19_887_, ov_cuboinf0_.obre_resource_id as obre_re20_887_, ov_cuboinf0_.m_product_id as m_produ21_887_, ov_cuboinf0_.isfacturado as isfactu22_887_, ov_cuboinf0_.reserva as reserva23_887_, ov_cuboinf0_.extrascompra as extrasc24_887_, ov_cuboinf0_.propietario as propiet25_887_, ov_cuboinf0_.anyo as anyo26_887_, ov_cuboinf0_.venta as venta27_887_, ov_cuboinf0_.venta_final as venta_f28_887_, ov_cuboinf0_.dto_venta as dto_ven29_887_, ov_cuboinf0_.iva as iva30_887_, ov_cuboinf0_.ret as ret31_887_, ov_cuboinf0_.comision as comisio32_887_, ov_cuboinf0_.por_comision as por_com33_887_, ov_cuboinf0_.por_iva as por_iva34_887_, ov_cuboinf0_.por_ret as por_ret35_887_, ov_cuboinf0_.numfactura as numfact36_887_, ov_cuboinf0_.periodo as periodo37_887_, ov_cuboinf0_.invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.obre_resource_id = ? and ov_cuboinf0_.propietario = ? and ov_cuboinf0_.ad_org_id <> ? and (ov_cuboinf0_.tiporeserva = ? or ov_cuboinf0_.tiporeserva = ? or ov_cuboinf0_.tiporeserva = ? or ov_cuboinf0_.tiporeserva = ? or ov_cuboinf0_.tiporeserva = ?) and (ov_cuboinf0_.entrada >= ? and ov_cuboinf0_.entrada <= ? or ov_cuboinf0_.salida >= ? and ov_cuboinf0_.salida <= ?) and (ov_cuboinf0_.ad_org_id in (...)) and (ov_cuboinf0_.ad_client_id in (...)) and ov_cuboinf0_.isactive = ? order by ov_cuboinf0_.ov_cuboinfoprop_v_id desc;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 18 07 2 9s671ms 4s835ms 08 4 8s714ms 2s178ms 09 4 6s940ms 1s735ms 10 14 32s278ms 2s305ms 11 4 7s877ms 1s969ms 12 4 10s312ms 2s578ms 15 18 45s7ms 2s500ms 16 4 9s944ms 2s486ms 20 2 6s982ms 3s491ms [ User: tad - Total duration: 2m17s - Times executed: 56 ]
[ Application: openbravo - Total duration: 2m17s - Times executed: 56 ]
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = '32610F2B2B384030A36374312C07FB6F' and ov_cuboinf0_.Propietario = 'A899E853ABF742F68101763FF4FE7220' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and (ov_cuboinf0_.Tiporeserva = 'a' or ov_cuboinf0_.Tiporeserva = 'b' or ov_cuboinf0_.Tiporeserva = 'c' or ov_cuboinf0_.Tiporeserva = 'd' or ov_cuboinf0_.Tiporeserva = 'e') and (ov_cuboinf0_.Entrada >= '01/01/2026' and ov_cuboinf0_.Entrada <= '31/12/2026' or ov_cuboinf0_.Salida >= '01/01/2026' and ov_cuboinf0_.Salida <= '31/12/2026') and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 07:27:24 Duration: 4s862ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = '32610F2B2B384030A36374312C07FB6F' and ov_cuboinf0_.Propietario = 'A899E853ABF742F68101763FF4FE7220' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and (ov_cuboinf0_.Tiporeserva = 'a' or ov_cuboinf0_.Tiporeserva = 'b' or ov_cuboinf0_.Tiporeserva = 'c' or ov_cuboinf0_.Tiporeserva = 'd' or ov_cuboinf0_.Tiporeserva = 'e') and (ov_cuboinf0_.Entrada >= '01/01/2026' and ov_cuboinf0_.Entrada <= '31/12/2026' or ov_cuboinf0_.Salida >= '01/01/2026' and ov_cuboinf0_.Salida <= '31/12/2026') and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 07:27:18 Duration: 4s808ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = '1677223A01A648FD91F5EA741596896A' and ov_cuboinf0_.Propietario = '9F2A0861FA8743919E43F87346AF9393' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and (ov_cuboinf0_.Tiporeserva = 'a' or ov_cuboinf0_.Tiporeserva = 'b' or ov_cuboinf0_.Tiporeserva = 'c' or ov_cuboinf0_.Tiporeserva = 'd' or ov_cuboinf0_.Tiporeserva = 'e') and (ov_cuboinf0_.Entrada >= '01/01/2026' and ov_cuboinf0_.Entrada <= '31/12/2026' or ov_cuboinf0_.Salida >= '01/01/2026' and ov_cuboinf0_.Salida <= '31/12/2026') and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 20:42:43 Duration: 3s520ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 26 1m4s 1s376ms 4s943ms 2s462ms select ov_cuboinf0_.ov_cuboinfoprop_v_id as ov_cuboi1_887_, ov_cuboinf0_.ad_client_id as ad_clien2_887_, ov_cuboinf0_.ad_org_id as ad_org_i3_887_, ov_cuboinf0_.created as created4_887_, ov_cuboinf0_.createdby as createdb5_887_, ov_cuboinf0_.updated as updated6_887_, ov_cuboinf0_.updatedby as updatedb7_887_, ov_cuboinf0_.isactive as isactive8_887_, ov_cuboinf0_.entrada as entrada9_887_, ov_cuboinf0_.salida as salida10_887_, ov_cuboinf0_.contrato as contrat11_887_, ov_cuboinf0_.c_order_id as c_order12_887_, ov_cuboinf0_.comprainicial as comprai13_887_, ov_cuboinf0_.totalcompra as totalco14_887_, ov_cuboinf0_.dtocompra as dtocomp15_887_, ov_cuboinf0_.documentno as documen16_887_, ov_cuboinf0_.villa as villa17_887_, ov_cuboinf0_.tipo as tipo18_887_, ov_cuboinf0_.tiporeserva as tipores19_887_, ov_cuboinf0_.obre_resource_id as obre_re20_887_, ov_cuboinf0_.m_product_id as m_produ21_887_, ov_cuboinf0_.isfacturado as isfactu22_887_, ov_cuboinf0_.reserva as reserva23_887_, ov_cuboinf0_.extrascompra as extrasc24_887_, ov_cuboinf0_.propietario as propiet25_887_, ov_cuboinf0_.anyo as anyo26_887_, ov_cuboinf0_.venta as venta27_887_, ov_cuboinf0_.venta_final as venta_f28_887_, ov_cuboinf0_.dto_venta as dto_ven29_887_, ov_cuboinf0_.iva as iva30_887_, ov_cuboinf0_.ret as ret31_887_, ov_cuboinf0_.comision as comisio32_887_, ov_cuboinf0_.por_comision as por_com33_887_, ov_cuboinf0_.por_iva as por_iva34_887_, ov_cuboinf0_.por_ret as por_ret35_887_, ov_cuboinf0_.numfactura as numfact36_887_, ov_cuboinf0_.periodo as periodo37_887_, ov_cuboinf0_.invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.obre_resource_id = ? and ov_cuboinf0_.propietario = ? and ov_cuboinf0_.ad_org_id <> ? and ov_cuboinf0_.tiporeserva <> ? and ov_cuboinf0_.invoicedate >= ? and ov_cuboinf0_.invoicedate <= ? and (ov_cuboinf0_.ad_org_id in (...)) and (ov_cuboinf0_.ad_client_id in (...)) and ov_cuboinf0_.isactive = ? order by ov_cuboinf0_.invoicedate desc, ov_cuboinf0_.ov_cuboinfoprop_v_id desc;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 18 07 2 9s826ms 4s913ms 08 3 7s331ms 2s443ms 09 4 5s897ms 1s474ms 10 10 23s852ms 2s385ms 11 2 3s330ms 1s665ms 12 4 10s962ms 2s740ms 16 1 2s827ms 2s827ms [ User: tad - Total duration: 1m4s - Times executed: 26 ]
[ Application: openbravo - Total duration: 1m4s - Times executed: 26 ]
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = '32610F2B2B384030A36374312C07FB6F' and ov_cuboinf0_.Propietario = 'A899E853ABF742F68101763FF4FE7220' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_cuboinf0_.Tiporeserva <> 'z' and ov_cuboinf0_.Invoicedate >= '01/01/2026' and ov_cuboinf0_.Invoicedate <= '01/01/2027' and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.Invoicedate desc, ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 07:27:30 Duration: 4s943ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = '32610F2B2B384030A36374312C07FB6F' and ov_cuboinf0_.Propietario = 'A899E853ABF742F68101763FF4FE7220' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_cuboinf0_.Tiporeserva <> 'z' and ov_cuboinf0_.Invoicedate >= '01/01/2026' and ov_cuboinf0_.Invoicedate <= '01/01/2027' and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.Invoicedate desc, ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 07:27:35 Duration: 4s882ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = 'F434941C6CFF45C3803DECEF8653ECE4' and ov_cuboinf0_.Propietario = '6FB6D561CBBB4F498BE9595B39D48E1C' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_cuboinf0_.Tiporeserva <> 'z' and ov_cuboinf0_.Invoicedate >= '01/01/2026' and ov_cuboinf0_.Invoicedate <= '01/01/2027' and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.Invoicedate desc, ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 12:51:37 Duration: 3s470ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
5 24 30s343ms 1s1ms 2s99ms 1s264ms update c_order set updated = ?, c_paymentterm_id = ? where c_order_id = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 18 09 24 30s343ms 1s264ms [ User: tad - Total duration: 30s343ms - Times executed: 24 ]
[ Application: openbravo - Total duration: 30s343ms - Times executed: 24 ]
-
update C_Order set Updated = '2026-07-18 09:11:47.753', C_PaymentTerm_ID = 'D8CD13F170C942E4A7498583E08E1F6E' where C_Order_ID = '8BD987CC4C264BA28D9FB29A5210A7F0';
Date: 2026-07-18 09:11:49 Duration: 2s99ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update C_Order set Updated = '2026-07-18 09:11:49.076', C_PaymentTerm_ID = 'D8CD13F170C942E4A7498583E08E1F6E' where C_Order_ID = '8BD987CC4C264BA28D9FB29A5210A7F0';
Date: 2026-07-18 09:11:50 Duration: 1s671ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update C_Order set Updated = '2026-07-18 09:11:49.72', C_PaymentTerm_ID = '8D91F90A4392451D89D8F7995D4BF884' where C_Order_ID = '8BD987CC4C264BA28D9FB29A5210A7F0';
Date: 2026-07-18 09:11:51 Duration: 1s598ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
6 15 6m43s 21s292ms 30s952ms 26s922ms select * from ov_calocupacion (null);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 18 07 1 29s402ms 29s402ms 08 1 22s696ms 22s696ms 09 1 29s300ms 29s300ms 10 1 29s100ms 29s100ms 11 1 30s66ms 30s66ms 12 1 21s292ms 21s292ms 13 1 28s978ms 28s978ms 14 1 29s735ms 29s735ms 15 1 23s 23s 16 1 21s634ms 21s634ms 17 1 30s952ms 30s952ms 18 1 28s445ms 28s445ms 19 1 21s378ms 21s378ms 20 1 29s685ms 29s685ms 21 1 28s167ms 28s167ms [ User: tad - Total duration: 6m43s - Times executed: 15 ]
[ Application: openbravo - Total duration: 6m43s - Times executed: 15 ]
-
SELECT * FROM OV_CALOCUPACION (NULL);
Date: 2026-07-18 17:20:52 Duration: 30s952ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM OV_CALOCUPACION (NULL);
Date: 2026-07-18 11:20:52 Duration: 30s66ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM OV_CALOCUPACION (NULL);
Date: 2026-07-18 14:20:51 Duration: 29s735ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
7 2 26s441ms 11s209ms 15s231ms 13s220ms select * from ov_calofertas (null);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 18 14 1 15s231ms 15s231ms 17 1 11s209ms 11s209ms [ User: tad - Total duration: 26s441ms - Times executed: 2 ]
[ Application: openbravo - Total duration: 26s441ms - Times executed: 2 ]
-
SELECT * FROM OV_CALOFERTAS (NULL);
Date: 2026-07-18 14:22:44 Duration: 15s231ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM OV_CALOFERTAS (NULL);
Date: 2026-07-18 17:25:09 Duration: 11s209ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
8 1 4s83ms 4s83ms 4s83ms 4s83ms select ov_bireser0_.ov_bireservas_v_id as ov_bires1_881_, ov_bireser0_.ad_client_id as ad_clien2_881_, ov_bireser0_.ad_org_id as ad_org_i3_881_, ov_bireser0_.isactive as isactive4_881_, ov_bireser0_.created as created5_881_, ov_bireser0_.createdby as createdb6_881_, ov_bireser0_.updated as updated7_881_, ov_bireser0_.updatedby as updatedb8_881_, ov_bireser0_.oficina as oficina9_881_, ov_bireser0_.villa as villa10_881_, ov_bireser0_.value as value11_881_, ov_bireser0_.reserva as reserva12_881_, ov_bireser0_.docstatus as docstat13_881_, ov_bireser0_.notas as notas14_881_, ov_bireser0_.dateordered as dateord15_881_, ov_bireser0_.num_noches as num_noc16_881_, ov_bireser0_.anyo as anyo17_881_, ov_bireser0_.datein as datein18_881_, ov_bireser0_.dateout as dateout19_881_, ov_bireser0_.c_bpartner_id as c_bpart20_881_, ov_bireser0_.huesped_id as huesped21_881_, ov_bireser0_.c_bpartner_location_id as c_bpart22_881_, ov_bireser0_.cliente as cliente23_881_, ov_bireser0_.mail as mail24_881_, ov_bireser0_.telf as telf25_881_, ov_bireser0_.pais as pais26_881_, ov_bireser0_.codigopais as codigop27_881_, ov_bireser0_.fechaconfirmacion as fechaco28_881_, ov_bireser0_.pagado as pagado29_881_, ov_bireser0_.grandtotal as grandto30_881_, ov_bireser0_.totallines as totalli31_881_, ov_bireser0_.alquiler as alquile32_881_, ov_bireser0_.dtoalquiler as dtoalqu33_881_, ov_bireser0_.energia as energia34_881_, ov_bireser0_.limpieza as limpiez35_881_, ov_bireser0_.dtopagocompleto as dtopago36_881_, ov_bireser0_.extras as extras37_881_, ov_bireser0_.m_warehouse_id as m_wareh38_881_, ov_bireser0_.c_project_id as c_proje39_881_, ov_bireser0_.nota_salida as nota_sa40_881_, ov_bireser0_.nota_cliente as nota_cl41_881_, ov_bireser0_.nota_entrada as nota_en42_881_, ov_bireser0_.esreserva as esreser43_881_, ov_bireser0_.tipo as tipo44_881_, ov_bireser0_.obre_resource_id as obre_re45_881_, ov_bireser0_.pax as pax46_881_, ov_bireser0_.adultpax as adultpa47_881_, ov_bireser0_.childpax as childpa48_881_, ov_bireser0_.horallegada as horalle49_881_, ov_bireser0_.esbono as esbono50_881_, ov_bireser0_.bono_id as bono_id51_881_, ov_bireser0_.fecha_anulacion as fecha_a52_881_, ov_bireser0_.estado as estado53_881_, ov_bireser0_.error as error54_881_, ov_bireser0_.salesrep_id as salesre55_881_, ov_bireser0_.responsable_id as respons56_881_, ov_bireser0_.agencia as agencia57_881_, ov_bireser0_.responsablecheckin as respons58_881_, ov_bireser0_.horaentrada as horaent59_881_, ov_bireser0_.limpieza_entrada as limpiez60_881_, ov_bireser0_.limpieza_salida as limpiez61_881_, ov_bireser0_.cuna as cuna62_881_, ov_bireser0_.mascotas as mascota63_881_, ov_bireser0_.ventilador as ventila64_881_, ov_bireser0_.trona as trona65_881_, ov_bireser0_.cama as cama66_881_, ov_bireser0_.latearrival as latearr67_881_, ov_bireser0_.seguroflexible as segurof68_881_, ov_bireser0_.seguroanulacion as seguroa69_881_, ov_bireser0_.languageiso as languag70_881_, ov_bireser0_.ventacuna as ventacu71_881_, ov_bireser0_.ventamascotas as ventama72_881_, ov_bireser0_.ventaventilador as ventave73_881_, ov_bireser0_.ventatrona as ventatr74_881_, ov_bireser0_.ventacama as ventaca75_881_, ov_bireser0_.ventalatearrival as ventala76_881_, ov_bireser0_.ventaseguroflexible as ventase77_881_, ov_bireser0_.ventaseguroanulacion as ventase78_881_, ov_bireser0_.comision as comisio79_881_, ov_bireser0_.tienebono as tienebo80_881_, ov_bireser0_.nuevareserva as nuevare81_881_, ov_bireser0_.contract_type_id as contrac82_881_, ov_bireser0_.gastosadmin as gastosa83_881_, ov_bireser0_.ventagastosadmin as ventaga84_881_, ov_bireser0_.tarifaflexible as tarifaf85_881_, ov_bireser0_.ventatarifaflexible as ventata86_881_, ov_bireser0_.salidaanteior as salidaa87_881_, ov_bireser0_.entradasiguiente as entrada88_881_, ov_bireser0_.c_paymentterm_id as c_payme89_881_, ov_bireser0_.formapago as formapa90_881_, ov_bireser0_.nifcif as nifcif91_881_, ov_bireser0_.tipodocumento as tipodoc92_881_, ov_bireser0_.diractiva as diracti93_881_, ov_bireser0_.direccion as direcci94_881_, ov_bireser0_.ciudad as ciudad95_881_, ov_bireser0_.cp as cp96_881_, ov_bireser0_.region as region97_881_ from ov_bireservas_v ov_bireser0_ where ov_bireser0_.ad_org_id = ? and ov_bireser0_.datein >= ? and ov_bireser0_.datein < ? and ov_bireser0_.updated > now() ? and (ov_bireser0_.ad_org_id in (...)) and (ov_bireser0_.ad_client_id in (...)) and ov_bireser0_.isactive = ? order by ov_bireser0_.dateout, ov_bireser0_.ov_bireservas_v_id;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 18 16 1 4s83ms 4s83ms [ User: tad - Total duration: 4s83ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 4s83ms - Times executed: 1 ]
-
select ov_bireser0_.OV_Bireservas_V_ID as ov_bires1_881_, ov_bireser0_.AD_Client_ID as ad_clien2_881_, ov_bireser0_.AD_Org_ID as ad_org_i3_881_, ov_bireser0_.Isactive as isactive4_881_, ov_bireser0_.Created as created5_881_, ov_bireser0_.Createdby as createdb6_881_, ov_bireser0_.Updated as updated7_881_, ov_bireser0_.Updatedby as updatedb8_881_, ov_bireser0_.Oficina as oficina9_881_, ov_bireser0_.Villa as villa10_881_, ov_bireser0_.Value as value11_881_, ov_bireser0_.Reserva as reserva12_881_, ov_bireser0_.Docstatus as docstat13_881_, ov_bireser0_.Notas as notas14_881_, ov_bireser0_.Dateordered as dateord15_881_, ov_bireser0_.NUM_Noches as num_noc16_881_, ov_bireser0_.Anyo as anyo17_881_, ov_bireser0_.Datein as datein18_881_, ov_bireser0_.Dateout as dateout19_881_, ov_bireser0_.C_Bpartner_ID as c_bpart20_881_, ov_bireser0_.Huesped_ID as huesped21_881_, ov_bireser0_.C_Bpartner_Location_ID as c_bpart22_881_, ov_bireser0_.Cliente as cliente23_881_, ov_bireser0_.Mail as mail24_881_, ov_bireser0_.Telf as telf25_881_, ov_bireser0_.Pais as pais26_881_, ov_bireser0_.Codigopais as codigop27_881_, ov_bireser0_.Fechaconfirmacion as fechaco28_881_, ov_bireser0_.Pagado as pagado29_881_, ov_bireser0_.Grandtotal as grandto30_881_, ov_bireser0_.Totallines as totalli31_881_, ov_bireser0_.Alquiler as alquile32_881_, ov_bireser0_.Dtoalquiler as dtoalqu33_881_, ov_bireser0_.Energia as energia34_881_, ov_bireser0_.Limpieza as limpiez35_881_, ov_bireser0_.Dtopagocompleto as dtopago36_881_, ov_bireser0_.Extras as extras37_881_, ov_bireser0_.M_Warehouse_ID as m_wareh38_881_, ov_bireser0_.C_Project_ID as c_proje39_881_, ov_bireser0_.Nota_Salida as nota_sa40_881_, ov_bireser0_.Nota_Cliente as nota_cl41_881_, ov_bireser0_.Nota_Entrada as nota_en42_881_, ov_bireser0_.Esreserva as esreser43_881_, ov_bireser0_.Tipo as tipo44_881_, ov_bireser0_.Obre_Resource_ID as obre_re45_881_, ov_bireser0_.Pax as pax46_881_, ov_bireser0_.Adultpax as adultpa47_881_, ov_bireser0_.Childpax as childpa48_881_, ov_bireser0_.Horallegada as horalle49_881_, ov_bireser0_.Esbono as esbono50_881_, ov_bireser0_.Bono_ID as bono_id51_881_, ov_bireser0_.Fecha_Anulacion as fecha_a52_881_, ov_bireser0_.Estado as estado53_881_, ov_bireser0_.Error as error54_881_, ov_bireser0_.Salesrep_ID as salesre55_881_, ov_bireser0_.Responsable_ID as respons56_881_, ov_bireser0_.Agencia as agencia57_881_, ov_bireser0_.Responsablecheckin as respons58_881_, ov_bireser0_.Horaentrada as horaent59_881_, ov_bireser0_.Limpieza_Entrada as limpiez60_881_, ov_bireser0_.Limpieza_Salida as limpiez61_881_, ov_bireser0_.Cuna as cuna62_881_, ov_bireser0_.Mascotas as mascota63_881_, ov_bireser0_.Ventilador as ventila64_881_, ov_bireser0_.Trona as trona65_881_, ov_bireser0_.Cama as cama66_881_, ov_bireser0_.Latearrival as latearr67_881_, ov_bireser0_.Seguroflexible as segurof68_881_, ov_bireser0_.Seguroanulacion as seguroa69_881_, ov_bireser0_.Languageiso as languag70_881_, ov_bireser0_.Ventacuna as ventacu71_881_, ov_bireser0_.Ventamascotas as ventama72_881_, ov_bireser0_.Ventaventilador as ventave73_881_, ov_bireser0_.Ventatrona as ventatr74_881_, ov_bireser0_.Ventacama as ventaca75_881_, ov_bireser0_.Ventalatearrival as ventala76_881_, ov_bireser0_.Ventaseguroflexible as ventase77_881_, ov_bireser0_.Ventaseguroanulacion as ventase78_881_, ov_bireser0_.Comision as comisio79_881_, ov_bireser0_.Tienebono as tienebo80_881_, ov_bireser0_.Nuevareserva as nuevare81_881_, ov_bireser0_.Contract_Type_ID as contrac82_881_, ov_bireser0_.Gastosadmin as gastosa83_881_, ov_bireser0_.Ventagastosadmin as ventaga84_881_, ov_bireser0_.Tarifaflexible as tarifaf85_881_, ov_bireser0_.Ventatarifaflexible as ventata86_881_, ov_bireser0_.Salidaanteior as salidaa87_881_, ov_bireser0_.Entradasiguiente as entrada88_881_, ov_bireser0_.C_Paymentterm_ID as c_payme89_881_, ov_bireser0_.Formapago as formapa90_881_, ov_bireser0_.Nifcif as nifcif91_881_, ov_bireser0_.Tipodocumento as tipodoc92_881_, ov_bireser0_.Diractiva as diracti93_881_, ov_bireser0_.Direccion as direcci94_881_, ov_bireser0_.Ciudad as ciudad95_881_, ov_bireser0_.Cp as cp96_881_, ov_bireser0_.Region as region97_881_ from ov_bireservas_v ov_bireser0_ where ov_bireser0_.AD_Org_ID = 'A773FA4025394EA8A1E37364E1DE3D47' and ov_bireser0_.Datein >= '01-01-2026' and ov_bireser0_.Datein < '01-01-2028' and ov_bireser0_.Updated > now() - 10 and (ov_bireser0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_bireser0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_bireser0_.Isactive = 'Y' order by ov_bireser0_.Dateout, ov_bireser0_.OV_Bireservas_V_ID;
Date: 2026-07-18 16:00:13 Duration: 4s83ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 21s292ms 30s952ms 26s922ms 15 6m43s select * from ov_calocupacion (null);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 18 07 1 29s402ms 29s402ms 08 1 22s696ms 22s696ms 09 1 29s300ms 29s300ms 10 1 29s100ms 29s100ms 11 1 30s66ms 30s66ms 12 1 21s292ms 21s292ms 13 1 28s978ms 28s978ms 14 1 29s735ms 29s735ms 15 1 23s 23s 16 1 21s634ms 21s634ms 17 1 30s952ms 30s952ms 18 1 28s445ms 28s445ms 19 1 21s378ms 21s378ms 20 1 29s685ms 29s685ms 21 1 28s167ms 28s167ms [ User: tad - Total duration: 6m43s - Times executed: 15 ]
[ Application: openbravo - Total duration: 6m43s - Times executed: 15 ]
-
SELECT * FROM OV_CALOCUPACION (NULL);
Date: 2026-07-18 17:20:52 Duration: 30s952ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM OV_CALOCUPACION (NULL);
Date: 2026-07-18 11:20:52 Duration: 30s66ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM OV_CALOCUPACION (NULL);
Date: 2026-07-18 14:20:51 Duration: 29s735ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 11s209ms 15s231ms 13s220ms 2 26s441ms select * from ov_calofertas (null);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 18 14 1 15s231ms 15s231ms 17 1 11s209ms 11s209ms [ User: tad - Total duration: 26s441ms - Times executed: 2 ]
[ Application: openbravo - Total duration: 26s441ms - Times executed: 2 ]
-
SELECT * FROM OV_CALOFERTAS (NULL);
Date: 2026-07-18 14:22:44 Duration: 15s231ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM OV_CALOFERTAS (NULL);
Date: 2026-07-18 17:25:09 Duration: 11s209ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 4s83ms 4s83ms 4s83ms 1 4s83ms select ov_bireser0_.ov_bireservas_v_id as ov_bires1_881_, ov_bireser0_.ad_client_id as ad_clien2_881_, ov_bireser0_.ad_org_id as ad_org_i3_881_, ov_bireser0_.isactive as isactive4_881_, ov_bireser0_.created as created5_881_, ov_bireser0_.createdby as createdb6_881_, ov_bireser0_.updated as updated7_881_, ov_bireser0_.updatedby as updatedb8_881_, ov_bireser0_.oficina as oficina9_881_, ov_bireser0_.villa as villa10_881_, ov_bireser0_.value as value11_881_, ov_bireser0_.reserva as reserva12_881_, ov_bireser0_.docstatus as docstat13_881_, ov_bireser0_.notas as notas14_881_, ov_bireser0_.dateordered as dateord15_881_, ov_bireser0_.num_noches as num_noc16_881_, ov_bireser0_.anyo as anyo17_881_, ov_bireser0_.datein as datein18_881_, ov_bireser0_.dateout as dateout19_881_, ov_bireser0_.c_bpartner_id as c_bpart20_881_, ov_bireser0_.huesped_id as huesped21_881_, ov_bireser0_.c_bpartner_location_id as c_bpart22_881_, ov_bireser0_.cliente as cliente23_881_, ov_bireser0_.mail as mail24_881_, ov_bireser0_.telf as telf25_881_, ov_bireser0_.pais as pais26_881_, ov_bireser0_.codigopais as codigop27_881_, ov_bireser0_.fechaconfirmacion as fechaco28_881_, ov_bireser0_.pagado as pagado29_881_, ov_bireser0_.grandtotal as grandto30_881_, ov_bireser0_.totallines as totalli31_881_, ov_bireser0_.alquiler as alquile32_881_, ov_bireser0_.dtoalquiler as dtoalqu33_881_, ov_bireser0_.energia as energia34_881_, ov_bireser0_.limpieza as limpiez35_881_, ov_bireser0_.dtopagocompleto as dtopago36_881_, ov_bireser0_.extras as extras37_881_, ov_bireser0_.m_warehouse_id as m_wareh38_881_, ov_bireser0_.c_project_id as c_proje39_881_, ov_bireser0_.nota_salida as nota_sa40_881_, ov_bireser0_.nota_cliente as nota_cl41_881_, ov_bireser0_.nota_entrada as nota_en42_881_, ov_bireser0_.esreserva as esreser43_881_, ov_bireser0_.tipo as tipo44_881_, ov_bireser0_.obre_resource_id as obre_re45_881_, ov_bireser0_.pax as pax46_881_, ov_bireser0_.adultpax as adultpa47_881_, ov_bireser0_.childpax as childpa48_881_, ov_bireser0_.horallegada as horalle49_881_, ov_bireser0_.esbono as esbono50_881_, ov_bireser0_.bono_id as bono_id51_881_, ov_bireser0_.fecha_anulacion as fecha_a52_881_, ov_bireser0_.estado as estado53_881_, ov_bireser0_.error as error54_881_, ov_bireser0_.salesrep_id as salesre55_881_, ov_bireser0_.responsable_id as respons56_881_, ov_bireser0_.agencia as agencia57_881_, ov_bireser0_.responsablecheckin as respons58_881_, ov_bireser0_.horaentrada as horaent59_881_, ov_bireser0_.limpieza_entrada as limpiez60_881_, ov_bireser0_.limpieza_salida as limpiez61_881_, ov_bireser0_.cuna as cuna62_881_, ov_bireser0_.mascotas as mascota63_881_, ov_bireser0_.ventilador as ventila64_881_, ov_bireser0_.trona as trona65_881_, ov_bireser0_.cama as cama66_881_, ov_bireser0_.latearrival as latearr67_881_, ov_bireser0_.seguroflexible as segurof68_881_, ov_bireser0_.seguroanulacion as seguroa69_881_, ov_bireser0_.languageiso as languag70_881_, ov_bireser0_.ventacuna as ventacu71_881_, ov_bireser0_.ventamascotas as ventama72_881_, ov_bireser0_.ventaventilador as ventave73_881_, ov_bireser0_.ventatrona as ventatr74_881_, ov_bireser0_.ventacama as ventaca75_881_, ov_bireser0_.ventalatearrival as ventala76_881_, ov_bireser0_.ventaseguroflexible as ventase77_881_, ov_bireser0_.ventaseguroanulacion as ventase78_881_, ov_bireser0_.comision as comisio79_881_, ov_bireser0_.tienebono as tienebo80_881_, ov_bireser0_.nuevareserva as nuevare81_881_, ov_bireser0_.contract_type_id as contrac82_881_, ov_bireser0_.gastosadmin as gastosa83_881_, ov_bireser0_.ventagastosadmin as ventaga84_881_, ov_bireser0_.tarifaflexible as tarifaf85_881_, ov_bireser0_.ventatarifaflexible as ventata86_881_, ov_bireser0_.salidaanteior as salidaa87_881_, ov_bireser0_.entradasiguiente as entrada88_881_, ov_bireser0_.c_paymentterm_id as c_payme89_881_, ov_bireser0_.formapago as formapa90_881_, ov_bireser0_.nifcif as nifcif91_881_, ov_bireser0_.tipodocumento as tipodoc92_881_, ov_bireser0_.diractiva as diracti93_881_, ov_bireser0_.direccion as direcci94_881_, ov_bireser0_.ciudad as ciudad95_881_, ov_bireser0_.cp as cp96_881_, ov_bireser0_.region as region97_881_ from ov_bireservas_v ov_bireser0_ where ov_bireser0_.ad_org_id = ? and ov_bireser0_.datein >= ? and ov_bireser0_.datein < ? and ov_bireser0_.updated > now() ? and (ov_bireser0_.ad_org_id in (...)) and (ov_bireser0_.ad_client_id in (...)) and ov_bireser0_.isactive = ? order by ov_bireser0_.dateout, ov_bireser0_.ov_bireservas_v_id;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 18 16 1 4s83ms 4s83ms [ User: tad - Total duration: 4s83ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 4s83ms - Times executed: 1 ]
-
select ov_bireser0_.OV_Bireservas_V_ID as ov_bires1_881_, ov_bireser0_.AD_Client_ID as ad_clien2_881_, ov_bireser0_.AD_Org_ID as ad_org_i3_881_, ov_bireser0_.Isactive as isactive4_881_, ov_bireser0_.Created as created5_881_, ov_bireser0_.Createdby as createdb6_881_, ov_bireser0_.Updated as updated7_881_, ov_bireser0_.Updatedby as updatedb8_881_, ov_bireser0_.Oficina as oficina9_881_, ov_bireser0_.Villa as villa10_881_, ov_bireser0_.Value as value11_881_, ov_bireser0_.Reserva as reserva12_881_, ov_bireser0_.Docstatus as docstat13_881_, ov_bireser0_.Notas as notas14_881_, ov_bireser0_.Dateordered as dateord15_881_, ov_bireser0_.NUM_Noches as num_noc16_881_, ov_bireser0_.Anyo as anyo17_881_, ov_bireser0_.Datein as datein18_881_, ov_bireser0_.Dateout as dateout19_881_, ov_bireser0_.C_Bpartner_ID as c_bpart20_881_, ov_bireser0_.Huesped_ID as huesped21_881_, ov_bireser0_.C_Bpartner_Location_ID as c_bpart22_881_, ov_bireser0_.Cliente as cliente23_881_, ov_bireser0_.Mail as mail24_881_, ov_bireser0_.Telf as telf25_881_, ov_bireser0_.Pais as pais26_881_, ov_bireser0_.Codigopais as codigop27_881_, ov_bireser0_.Fechaconfirmacion as fechaco28_881_, ov_bireser0_.Pagado as pagado29_881_, ov_bireser0_.Grandtotal as grandto30_881_, ov_bireser0_.Totallines as totalli31_881_, ov_bireser0_.Alquiler as alquile32_881_, ov_bireser0_.Dtoalquiler as dtoalqu33_881_, ov_bireser0_.Energia as energia34_881_, ov_bireser0_.Limpieza as limpiez35_881_, ov_bireser0_.Dtopagocompleto as dtopago36_881_, ov_bireser0_.Extras as extras37_881_, ov_bireser0_.M_Warehouse_ID as m_wareh38_881_, ov_bireser0_.C_Project_ID as c_proje39_881_, ov_bireser0_.Nota_Salida as nota_sa40_881_, ov_bireser0_.Nota_Cliente as nota_cl41_881_, ov_bireser0_.Nota_Entrada as nota_en42_881_, ov_bireser0_.Esreserva as esreser43_881_, ov_bireser0_.Tipo as tipo44_881_, ov_bireser0_.Obre_Resource_ID as obre_re45_881_, ov_bireser0_.Pax as pax46_881_, ov_bireser0_.Adultpax as adultpa47_881_, ov_bireser0_.Childpax as childpa48_881_, ov_bireser0_.Horallegada as horalle49_881_, ov_bireser0_.Esbono as esbono50_881_, ov_bireser0_.Bono_ID as bono_id51_881_, ov_bireser0_.Fecha_Anulacion as fecha_a52_881_, ov_bireser0_.Estado as estado53_881_, ov_bireser0_.Error as error54_881_, ov_bireser0_.Salesrep_ID as salesre55_881_, ov_bireser0_.Responsable_ID as respons56_881_, ov_bireser0_.Agencia as agencia57_881_, ov_bireser0_.Responsablecheckin as respons58_881_, ov_bireser0_.Horaentrada as horaent59_881_, ov_bireser0_.Limpieza_Entrada as limpiez60_881_, ov_bireser0_.Limpieza_Salida as limpiez61_881_, ov_bireser0_.Cuna as cuna62_881_, ov_bireser0_.Mascotas as mascota63_881_, ov_bireser0_.Ventilador as ventila64_881_, ov_bireser0_.Trona as trona65_881_, ov_bireser0_.Cama as cama66_881_, ov_bireser0_.Latearrival as latearr67_881_, ov_bireser0_.Seguroflexible as segurof68_881_, ov_bireser0_.Seguroanulacion as seguroa69_881_, ov_bireser0_.Languageiso as languag70_881_, ov_bireser0_.Ventacuna as ventacu71_881_, ov_bireser0_.Ventamascotas as ventama72_881_, ov_bireser0_.Ventaventilador as ventave73_881_, ov_bireser0_.Ventatrona as ventatr74_881_, ov_bireser0_.Ventacama as ventaca75_881_, ov_bireser0_.Ventalatearrival as ventala76_881_, ov_bireser0_.Ventaseguroflexible as ventase77_881_, ov_bireser0_.Ventaseguroanulacion as ventase78_881_, ov_bireser0_.Comision as comisio79_881_, ov_bireser0_.Tienebono as tienebo80_881_, ov_bireser0_.Nuevareserva as nuevare81_881_, ov_bireser0_.Contract_Type_ID as contrac82_881_, ov_bireser0_.Gastosadmin as gastosa83_881_, ov_bireser0_.Ventagastosadmin as ventaga84_881_, ov_bireser0_.Tarifaflexible as tarifaf85_881_, ov_bireser0_.Ventatarifaflexible as ventata86_881_, ov_bireser0_.Salidaanteior as salidaa87_881_, ov_bireser0_.Entradasiguiente as entrada88_881_, ov_bireser0_.C_Paymentterm_ID as c_payme89_881_, ov_bireser0_.Formapago as formapa90_881_, ov_bireser0_.Nifcif as nifcif91_881_, ov_bireser0_.Tipodocumento as tipodoc92_881_, ov_bireser0_.Diractiva as diracti93_881_, ov_bireser0_.Direccion as direcci94_881_, ov_bireser0_.Ciudad as ciudad95_881_, ov_bireser0_.Cp as cp96_881_, ov_bireser0_.Region as region97_881_ from ov_bireservas_v ov_bireser0_ where ov_bireser0_.AD_Org_ID = 'A773FA4025394EA8A1E37364E1DE3D47' and ov_bireser0_.Datein >= '01-01-2026' and ov_bireser0_.Datein < '01-01-2028' and ov_bireser0_.Updated > now() - 10 and (ov_bireser0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_bireser0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_bireser0_.Isactive = 'Y' order by ov_bireser0_.Dateout, ov_bireser0_.OV_Bireservas_V_ID;
Date: 2026-07-18 16:00:13 Duration: 4s83ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 1s376ms 4s943ms 2s462ms 26 1m4s select ov_cuboinf0_.ov_cuboinfoprop_v_id as ov_cuboi1_887_, ov_cuboinf0_.ad_client_id as ad_clien2_887_, ov_cuboinf0_.ad_org_id as ad_org_i3_887_, ov_cuboinf0_.created as created4_887_, ov_cuboinf0_.createdby as createdb5_887_, ov_cuboinf0_.updated as updated6_887_, ov_cuboinf0_.updatedby as updatedb7_887_, ov_cuboinf0_.isactive as isactive8_887_, ov_cuboinf0_.entrada as entrada9_887_, ov_cuboinf0_.salida as salida10_887_, ov_cuboinf0_.contrato as contrat11_887_, ov_cuboinf0_.c_order_id as c_order12_887_, ov_cuboinf0_.comprainicial as comprai13_887_, ov_cuboinf0_.totalcompra as totalco14_887_, ov_cuboinf0_.dtocompra as dtocomp15_887_, ov_cuboinf0_.documentno as documen16_887_, ov_cuboinf0_.villa as villa17_887_, ov_cuboinf0_.tipo as tipo18_887_, ov_cuboinf0_.tiporeserva as tipores19_887_, ov_cuboinf0_.obre_resource_id as obre_re20_887_, ov_cuboinf0_.m_product_id as m_produ21_887_, ov_cuboinf0_.isfacturado as isfactu22_887_, ov_cuboinf0_.reserva as reserva23_887_, ov_cuboinf0_.extrascompra as extrasc24_887_, ov_cuboinf0_.propietario as propiet25_887_, ov_cuboinf0_.anyo as anyo26_887_, ov_cuboinf0_.venta as venta27_887_, ov_cuboinf0_.venta_final as venta_f28_887_, ov_cuboinf0_.dto_venta as dto_ven29_887_, ov_cuboinf0_.iva as iva30_887_, ov_cuboinf0_.ret as ret31_887_, ov_cuboinf0_.comision as comisio32_887_, ov_cuboinf0_.por_comision as por_com33_887_, ov_cuboinf0_.por_iva as por_iva34_887_, ov_cuboinf0_.por_ret as por_ret35_887_, ov_cuboinf0_.numfactura as numfact36_887_, ov_cuboinf0_.periodo as periodo37_887_, ov_cuboinf0_.invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.obre_resource_id = ? and ov_cuboinf0_.propietario = ? and ov_cuboinf0_.ad_org_id <> ? and ov_cuboinf0_.tiporeserva <> ? and ov_cuboinf0_.invoicedate >= ? and ov_cuboinf0_.invoicedate <= ? and (ov_cuboinf0_.ad_org_id in (...)) and (ov_cuboinf0_.ad_client_id in (...)) and ov_cuboinf0_.isactive = ? order by ov_cuboinf0_.invoicedate desc, ov_cuboinf0_.ov_cuboinfoprop_v_id desc;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 18 07 2 9s826ms 4s913ms 08 3 7s331ms 2s443ms 09 4 5s897ms 1s474ms 10 10 23s852ms 2s385ms 11 2 3s330ms 1s665ms 12 4 10s962ms 2s740ms 16 1 2s827ms 2s827ms [ User: tad - Total duration: 1m4s - Times executed: 26 ]
[ Application: openbravo - Total duration: 1m4s - Times executed: 26 ]
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = '32610F2B2B384030A36374312C07FB6F' and ov_cuboinf0_.Propietario = 'A899E853ABF742F68101763FF4FE7220' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_cuboinf0_.Tiporeserva <> 'z' and ov_cuboinf0_.Invoicedate >= '01/01/2026' and ov_cuboinf0_.Invoicedate <= '01/01/2027' and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.Invoicedate desc, ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 07:27:30 Duration: 4s943ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = '32610F2B2B384030A36374312C07FB6F' and ov_cuboinf0_.Propietario = 'A899E853ABF742F68101763FF4FE7220' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_cuboinf0_.Tiporeserva <> 'z' and ov_cuboinf0_.Invoicedate >= '01/01/2026' and ov_cuboinf0_.Invoicedate <= '01/01/2027' and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.Invoicedate desc, ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 07:27:35 Duration: 4s882ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = 'F434941C6CFF45C3803DECEF8653ECE4' and ov_cuboinf0_.Propietario = '6FB6D561CBBB4F498BE9595B39D48E1C' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_cuboinf0_.Tiporeserva <> 'z' and ov_cuboinf0_.Invoicedate >= '01/01/2026' and ov_cuboinf0_.Invoicedate <= '01/01/2027' and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.Invoicedate desc, ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 12:51:37 Duration: 3s470ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
5 1s414ms 4s862ms 2s459ms 56 2m17s select ov_cuboinf0_.ov_cuboinfoprop_v_id as ov_cuboi1_887_, ov_cuboinf0_.ad_client_id as ad_clien2_887_, ov_cuboinf0_.ad_org_id as ad_org_i3_887_, ov_cuboinf0_.created as created4_887_, ov_cuboinf0_.createdby as createdb5_887_, ov_cuboinf0_.updated as updated6_887_, ov_cuboinf0_.updatedby as updatedb7_887_, ov_cuboinf0_.isactive as isactive8_887_, ov_cuboinf0_.entrada as entrada9_887_, ov_cuboinf0_.salida as salida10_887_, ov_cuboinf0_.contrato as contrat11_887_, ov_cuboinf0_.c_order_id as c_order12_887_, ov_cuboinf0_.comprainicial as comprai13_887_, ov_cuboinf0_.totalcompra as totalco14_887_, ov_cuboinf0_.dtocompra as dtocomp15_887_, ov_cuboinf0_.documentno as documen16_887_, ov_cuboinf0_.villa as villa17_887_, ov_cuboinf0_.tipo as tipo18_887_, ov_cuboinf0_.tiporeserva as tipores19_887_, ov_cuboinf0_.obre_resource_id as obre_re20_887_, ov_cuboinf0_.m_product_id as m_produ21_887_, ov_cuboinf0_.isfacturado as isfactu22_887_, ov_cuboinf0_.reserva as reserva23_887_, ov_cuboinf0_.extrascompra as extrasc24_887_, ov_cuboinf0_.propietario as propiet25_887_, ov_cuboinf0_.anyo as anyo26_887_, ov_cuboinf0_.venta as venta27_887_, ov_cuboinf0_.venta_final as venta_f28_887_, ov_cuboinf0_.dto_venta as dto_ven29_887_, ov_cuboinf0_.iva as iva30_887_, ov_cuboinf0_.ret as ret31_887_, ov_cuboinf0_.comision as comisio32_887_, ov_cuboinf0_.por_comision as por_com33_887_, ov_cuboinf0_.por_iva as por_iva34_887_, ov_cuboinf0_.por_ret as por_ret35_887_, ov_cuboinf0_.numfactura as numfact36_887_, ov_cuboinf0_.periodo as periodo37_887_, ov_cuboinf0_.invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.obre_resource_id = ? and ov_cuboinf0_.propietario = ? and ov_cuboinf0_.ad_org_id <> ? and (ov_cuboinf0_.tiporeserva = ? or ov_cuboinf0_.tiporeserva = ? or ov_cuboinf0_.tiporeserva = ? or ov_cuboinf0_.tiporeserva = ? or ov_cuboinf0_.tiporeserva = ?) and (ov_cuboinf0_.entrada >= ? and ov_cuboinf0_.entrada <= ? or ov_cuboinf0_.salida >= ? and ov_cuboinf0_.salida <= ?) and (ov_cuboinf0_.ad_org_id in (...)) and (ov_cuboinf0_.ad_client_id in (...)) and ov_cuboinf0_.isactive = ? order by ov_cuboinf0_.ov_cuboinfoprop_v_id desc;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 18 07 2 9s671ms 4s835ms 08 4 8s714ms 2s178ms 09 4 6s940ms 1s735ms 10 14 32s278ms 2s305ms 11 4 7s877ms 1s969ms 12 4 10s312ms 2s578ms 15 18 45s7ms 2s500ms 16 4 9s944ms 2s486ms 20 2 6s982ms 3s491ms [ User: tad - Total duration: 2m17s - Times executed: 56 ]
[ Application: openbravo - Total duration: 2m17s - Times executed: 56 ]
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = '32610F2B2B384030A36374312C07FB6F' and ov_cuboinf0_.Propietario = 'A899E853ABF742F68101763FF4FE7220' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and (ov_cuboinf0_.Tiporeserva = 'a' or ov_cuboinf0_.Tiporeserva = 'b' or ov_cuboinf0_.Tiporeserva = 'c' or ov_cuboinf0_.Tiporeserva = 'd' or ov_cuboinf0_.Tiporeserva = 'e') and (ov_cuboinf0_.Entrada >= '01/01/2026' and ov_cuboinf0_.Entrada <= '31/12/2026' or ov_cuboinf0_.Salida >= '01/01/2026' and ov_cuboinf0_.Salida <= '31/12/2026') and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 07:27:24 Duration: 4s862ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = '32610F2B2B384030A36374312C07FB6F' and ov_cuboinf0_.Propietario = 'A899E853ABF742F68101763FF4FE7220' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and (ov_cuboinf0_.Tiporeserva = 'a' or ov_cuboinf0_.Tiporeserva = 'b' or ov_cuboinf0_.Tiporeserva = 'c' or ov_cuboinf0_.Tiporeserva = 'd' or ov_cuboinf0_.Tiporeserva = 'e') and (ov_cuboinf0_.Entrada >= '01/01/2026' and ov_cuboinf0_.Entrada <= '31/12/2026' or ov_cuboinf0_.Salida >= '01/01/2026' and ov_cuboinf0_.Salida <= '31/12/2026') and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 07:27:18 Duration: 4s808ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_cuboinf0_.OV_Cuboinfoprop_V_ID as ov_cuboi1_887_, ov_cuboinf0_.AD_Client_ID as ad_clien2_887_, ov_cuboinf0_.AD_Org_ID as ad_org_i3_887_, ov_cuboinf0_.Created as created4_887_, ov_cuboinf0_.Createdby as createdb5_887_, ov_cuboinf0_.Updated as updated6_887_, ov_cuboinf0_.Updatedby as updatedb7_887_, ov_cuboinf0_.Isactive as isactive8_887_, ov_cuboinf0_.Entrada as entrada9_887_, ov_cuboinf0_.Salida as salida10_887_, ov_cuboinf0_.Contrato as contrat11_887_, ov_cuboinf0_.C_Order_ID as c_order12_887_, ov_cuboinf0_.Comprainicial as comprai13_887_, ov_cuboinf0_.Totalcompra as totalco14_887_, ov_cuboinf0_.Dtocompra as dtocomp15_887_, ov_cuboinf0_.Documentno as documen16_887_, ov_cuboinf0_.Villa as villa17_887_, ov_cuboinf0_.Tipo as tipo18_887_, ov_cuboinf0_.Tiporeserva as tipores19_887_, ov_cuboinf0_.Obre_Resource_ID as obre_re20_887_, ov_cuboinf0_.M_Product_ID as m_produ21_887_, ov_cuboinf0_.Isfacturado as isfactu22_887_, ov_cuboinf0_.Reserva as reserva23_887_, ov_cuboinf0_.Extrascompra as extrasc24_887_, ov_cuboinf0_.Propietario as propiet25_887_, ov_cuboinf0_.Anyo as anyo26_887_, ov_cuboinf0_.Venta as venta27_887_, ov_cuboinf0_.Venta_Final as venta_f28_887_, ov_cuboinf0_.DTO_Venta as dto_ven29_887_, ov_cuboinf0_.Iva as iva30_887_, ov_cuboinf0_.Ret as ret31_887_, ov_cuboinf0_.Comision as comisio32_887_, ov_cuboinf0_.POR_Comision as por_com33_887_, ov_cuboinf0_.POR_Iva as por_iva34_887_, ov_cuboinf0_.POR_Ret as por_ret35_887_, ov_cuboinf0_.Numfactura as numfact36_887_, ov_cuboinf0_.Periodo as periodo37_887_, ov_cuboinf0_.Invoicedate as invoice38_887_ from ov_cuboinfoprop_v ov_cuboinf0_ where ov_cuboinf0_.Obre_Resource_ID = '1677223A01A648FD91F5EA741596896A' and ov_cuboinf0_.Propietario = '9F2A0861FA8743919E43F87346AF9393' and ov_cuboinf0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and (ov_cuboinf0_.Tiporeserva = 'a' or ov_cuboinf0_.Tiporeserva = 'b' or ov_cuboinf0_.Tiporeserva = 'c' or ov_cuboinf0_.Tiporeserva = 'd' or ov_cuboinf0_.Tiporeserva = 'e') and (ov_cuboinf0_.Entrada >= '01/01/2026' and ov_cuboinf0_.Entrada <= '31/12/2026' or ov_cuboinf0_.Salida >= '01/01/2026' and ov_cuboinf0_.Salida <= '31/12/2026') and (ov_cuboinf0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_cuboinf0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_cuboinf0_.Isactive = 'Y' order by ov_cuboinf0_.OV_Cuboinfoprop_V_ID desc;
Date: 2026-07-18 20:42:43 Duration: 3s520ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
6 1s25ms 6s644ms 2s240ms 81 3m1s select ov_infoact0_.ov_infoactuaciones_v_id as ov_infoa1_900_, ov_infoact0_.ad_client_id as ad_clien2_900_, ov_infoact0_.ad_org_id as ad_org_i3_900_, ov_infoact0_.isactive as isactive4_900_, ov_infoact0_.created as created5_900_, ov_infoact0_.createdby as createdb6_900_, ov_infoact0_.updated as updated7_900_, ov_infoact0_.updatedby as updatedb8_900_, ov_infoact0_.dateordered as dateorde9_900_, ov_infoact0_.obre_resource_id as obre_re10_900_, ov_infoact0_.c_order_id as c_order11_900_, ov_infoact0_.documentno as documen12_900_, ov_infoact0_.anyo as anyo13_900_, ov_infoact0_.description as descrip14_900_, ov_infoact0_.extrapropietario as extrapr15_900_, ov_infoact0_.importe as importe16_900_, ov_infoact0_.total_compra as total_c17_900_, ov_infoact0_.resto as resto18_900_, ov_infoact0_.tipo as tipo19_900_, ov_infoact0_.isfacturado as isfactu20_900_, ov_infoact0_.propietario as propiet21_900_, ov_infoact0_.isservicio as isservi22_900_, ov_infoact0_.numfactura as numfact23_900_, ov_infoact0_.tipogasto as tipogas24_900_, ov_infoact0_.periodo as periodo25_900_, ov_infoact0_.detalle as detalle26_900_ from ov_infoactuaciones_v ov_infoact0_ where obre_resource_id = ? and ov_infoact0_.ad_org_id <> ? and ov_infoact0_.propietario = ? and ov_infoact0_.extrapropietario = ? and ov_infoact0_.dateordered >= ? and ov_infoact0_.dateordered <= ? and (ov_infoact0_.ad_org_id in (...)) and (ov_infoact0_.ad_client_id in (...)) and ov_infoact0_.isactive = ? order by ov_infoact0_.ov_infoactuaciones_v_id desc, ov_infoact0_.ov_infoactuaciones_v_id desc;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 18 07 4 10s352ms 2s588ms 08 9 21s290ms 2s365ms 09 11 29s960ms 2s723ms 10 16 27s370ms 1s710ms 11 2 2s928ms 1s464ms 12 6 10s819ms 1s803ms 15 7 28s308ms 4s44ms 16 1 1s178ms 1s178ms 17 23 43s76ms 1s872ms 19 1 1s396ms 1s396ms 20 1 4s774ms 4s774ms [ User: tad - Total duration: 3m1s - Times executed: 81 ]
[ Application: openbravo - Total duration: 3m1s - Times executed: 81 ]
-
select ov_infoact0_.OV_Infoactuaciones_V_ID as ov_infoa1_900_, ov_infoact0_.AD_Client_ID as ad_clien2_900_, ov_infoact0_.AD_Org_ID as ad_org_i3_900_, ov_infoact0_.Isactive as isactive4_900_, ov_infoact0_.Created as created5_900_, ov_infoact0_.Createdby as createdb6_900_, ov_infoact0_.Updated as updated7_900_, ov_infoact0_.Updatedby as updatedb8_900_, ov_infoact0_.Dateordered as dateorde9_900_, ov_infoact0_.Obre_Resource_ID as obre_re10_900_, ov_infoact0_.C_Order_ID as c_order11_900_, ov_infoact0_.Documentno as documen12_900_, ov_infoact0_.Anyo as anyo13_900_, ov_infoact0_.Description as descrip14_900_, ov_infoact0_.Extrapropietario as extrapr15_900_, ov_infoact0_.Importe as importe16_900_, ov_infoact0_.Total_Compra as total_c17_900_, ov_infoact0_.Resto as resto18_900_, ov_infoact0_.Tipo as tipo19_900_, ov_infoact0_.Isfacturado as isfactu20_900_, ov_infoact0_.Propietario as propiet21_900_, ov_infoact0_.Isservicio as isservi22_900_, ov_infoact0_.Numfactura as numfact23_900_, ov_infoact0_.Tipogasto as tipogas24_900_, ov_infoact0_.Periodo as periodo25_900_, ov_infoact0_.Detalle as detalle26_900_ from ov_infoactuaciones_v ov_infoact0_ where obre_resource_id = '3EF97DA965B54C7BB4856C90275F6BC1' and ov_infoact0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infoact0_.Propietario = '455F2D24F14B4513B2D51486814A386E' and ov_infoact0_.Extrapropietario = 'Y' and ov_infoact0_.Dateordered >= '2026-01-01' and ov_infoact0_.Dateordered <= '2027-01-01' and (ov_infoact0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infoact0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infoact0_.Isactive = 'Y' order by ov_infoact0_.OV_Infoactuaciones_V_ID desc, ov_infoact0_.OV_Infoactuaciones_V_ID desc;
Date: 2026-07-18 15:54:54 Duration: 6s644ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_infoact0_.OV_Infoactuaciones_V_ID as ov_infoa1_900_, ov_infoact0_.AD_Client_ID as ad_clien2_900_, ov_infoact0_.AD_Org_ID as ad_org_i3_900_, ov_infoact0_.Isactive as isactive4_900_, ov_infoact0_.Created as created5_900_, ov_infoact0_.Createdby as createdb6_900_, ov_infoact0_.Updated as updated7_900_, ov_infoact0_.Updatedby as updatedb8_900_, ov_infoact0_.Dateordered as dateorde9_900_, ov_infoact0_.Obre_Resource_ID as obre_re10_900_, ov_infoact0_.C_Order_ID as c_order11_900_, ov_infoact0_.Documentno as documen12_900_, ov_infoact0_.Anyo as anyo13_900_, ov_infoact0_.Description as descrip14_900_, ov_infoact0_.Extrapropietario as extrapr15_900_, ov_infoact0_.Importe as importe16_900_, ov_infoact0_.Total_Compra as total_c17_900_, ov_infoact0_.Resto as resto18_900_, ov_infoact0_.Tipo as tipo19_900_, ov_infoact0_.Isfacturado as isfactu20_900_, ov_infoact0_.Propietario as propiet21_900_, ov_infoact0_.Isservicio as isservi22_900_, ov_infoact0_.Numfactura as numfact23_900_, ov_infoact0_.Tipogasto as tipogas24_900_, ov_infoact0_.Periodo as periodo25_900_, ov_infoact0_.Detalle as detalle26_900_ from ov_infoactuaciones_v ov_infoact0_ where obre_resource_id = '3EF97DA965B54C7BB4856C90275F6BC1' and ov_infoact0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infoact0_.Propietario = '455F2D24F14B4513B2D51486814A386E' and ov_infoact0_.Extrapropietario = 'Y' and ov_infoact0_.Dateordered >= '2026-01-01' and ov_infoact0_.Dateordered <= '2027-01-01' and (ov_infoact0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infoact0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infoact0_.Isactive = 'Y' order by ov_infoact0_.OV_Infoactuaciones_V_ID desc, ov_infoact0_.OV_Infoactuaciones_V_ID desc;
Date: 2026-07-18 15:55:01 Duration: 6s604ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_infoact0_.OV_Infoactuaciones_V_ID as ov_infoa1_900_, ov_infoact0_.AD_Client_ID as ad_clien2_900_, ov_infoact0_.AD_Org_ID as ad_org_i3_900_, ov_infoact0_.Isactive as isactive4_900_, ov_infoact0_.Created as created5_900_, ov_infoact0_.Createdby as createdb6_900_, ov_infoact0_.Updated as updated7_900_, ov_infoact0_.Updatedby as updatedb8_900_, ov_infoact0_.Dateordered as dateorde9_900_, ov_infoact0_.Obre_Resource_ID as obre_re10_900_, ov_infoact0_.C_Order_ID as c_order11_900_, ov_infoact0_.Documentno as documen12_900_, ov_infoact0_.Anyo as anyo13_900_, ov_infoact0_.Description as descrip14_900_, ov_infoact0_.Extrapropietario as extrapr15_900_, ov_infoact0_.Importe as importe16_900_, ov_infoact0_.Total_Compra as total_c17_900_, ov_infoact0_.Resto as resto18_900_, ov_infoact0_.Tipo as tipo19_900_, ov_infoact0_.Isfacturado as isfactu20_900_, ov_infoact0_.Propietario as propiet21_900_, ov_infoact0_.Isservicio as isservi22_900_, ov_infoact0_.Numfactura as numfact23_900_, ov_infoact0_.Tipogasto as tipogas24_900_, ov_infoact0_.Periodo as periodo25_900_, ov_infoact0_.Detalle as detalle26_900_ from ov_infoactuaciones_v ov_infoact0_ where obre_resource_id = '3EF97DA965B54C7BB4856C90275F6BC1' and ov_infoact0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infoact0_.Propietario = '455F2D24F14B4513B2D51486814A386E' and ov_infoact0_.Extrapropietario = 'Y' and ov_infoact0_.Dateordered >= '2026-01-01' and ov_infoact0_.Dateordered <= '2027-01-01' and (ov_infoact0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infoact0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infoact0_.Isactive = 'Y' order by ov_infoact0_.OV_Infoactuaciones_V_ID desc, ov_infoact0_.OV_Infoactuaciones_V_ID desc;
Date: 2026-07-18 09:40:03 Duration: 6s548ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
7 1s3ms 2s227ms 1s411ms 73 1m43s select ov_infores0_.ov_inforesumen_v_id as ov_infor1_910_, ov_infores0_.ad_client_id as ad_clien2_910_, ov_infores0_.ad_org_id as ad_org_i3_910_, ov_infores0_.created as created4_910_, ov_infores0_.createdby as createdb5_910_, ov_infores0_.updated as updated6_910_, ov_infores0_.updatedby as updatedb7_910_, ov_infores0_.isactive as isactive8_910_, ov_infores0_.fecha as fecha9_910_, ov_infores0_.anyo as anyo10_910_, ov_infores0_.obre_resource_id as obre_re11_910_, ov_infores0_.m_product_id as m_produ12_910_, ov_infores0_.totalgasto as totalga13_910_, ov_infores0_.totalactuaciones as totalac14_910_, ov_infores0_.totalbalance as totalba15_910_, ov_infores0_.totalreservas as totalre16_910_, ov_infores0_.totalfacturas as totalfa17_910_, ov_infores0_.totalhaber as totalha18_910_, ov_infores0_.totaldebe as totalde19_910_, ov_infores0_.propietario as propiet20_910_, ov_infores0_.totalpago as totalpa21_910_ from ov_inforesumen_v ov_infores0_ where ov_infores0_.obre_resource_id = ? and ov_infores0_.propietario = ? and ov_infores0_.ad_org_id <> ? and ov_infores0_.anyo = ? and (ov_infores0_.ad_org_id in (...)) and (ov_infores0_.ad_client_id in (...)) and ov_infores0_.isactive = ? order by ov_infores0_.ov_inforesumen_v_id desc;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 18 07 2 2s766ms 1s383ms 08 7 7s849ms 1s121ms 09 4 5s798ms 1s449ms 10 10 13s67ms 1s306ms 11 3 3s506ms 1s168ms 12 5 6s151ms 1s230ms 15 23 38s860ms 1s689ms 16 2 3s927ms 1s963ms 17 13 16s666ms 1s282ms 20 4 4s472ms 1s118ms [ User: tad - Total duration: 1m43s - Times executed: 73 ]
[ Application: openbravo - Total duration: 1m43s - Times executed: 73 ]
-
select ov_infores0_.OV_Inforesumen_V_ID as ov_infor1_910_, ov_infores0_.AD_Client_ID as ad_clien2_910_, ov_infores0_.AD_Org_ID as ad_org_i3_910_, ov_infores0_.Created as created4_910_, ov_infores0_.Createdby as createdb5_910_, ov_infores0_.Updated as updated6_910_, ov_infores0_.Updatedby as updatedb7_910_, ov_infores0_.Isactive as isactive8_910_, ov_infores0_.Fecha as fecha9_910_, ov_infores0_.Anyo as anyo10_910_, ov_infores0_.Obre_Resource_ID as obre_re11_910_, ov_infores0_.M_Product_ID as m_produ12_910_, ov_infores0_.Totalgasto as totalga13_910_, ov_infores0_.Totalactuaciones as totalac14_910_, ov_infores0_.Totalbalance as totalba15_910_, ov_infores0_.Totalreservas as totalre16_910_, ov_infores0_.Totalfacturas as totalfa17_910_, ov_infores0_.Totalhaber as totalha18_910_, ov_infores0_.Totaldebe as totalde19_910_, ov_infores0_.Propietario as propiet20_910_, ov_infores0_.Totalpago as totalpa21_910_ from ov_inforesumen_v ov_infores0_ where ov_infores0_.Obre_Resource_ID = 'A0BE6D13577547E9B081A56EA6128A79' and ov_infores0_.Propietario = '1E079A1DBF9A45C8998DFA863D75AA60' and ov_infores0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infores0_.Anyo = '2025' and (ov_infores0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infores0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infores0_.Isactive = 'Y' order by ov_infores0_.OV_Inforesumen_V_ID desc;
Date: 2026-07-18 15:57:49 Duration: 2s227ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_infores0_.OV_Inforesumen_V_ID as ov_infor1_910_, ov_infores0_.AD_Client_ID as ad_clien2_910_, ov_infores0_.AD_Org_ID as ad_org_i3_910_, ov_infores0_.Created as created4_910_, ov_infores0_.Createdby as createdb5_910_, ov_infores0_.Updated as updated6_910_, ov_infores0_.Updatedby as updatedb7_910_, ov_infores0_.Isactive as isactive8_910_, ov_infores0_.Fecha as fecha9_910_, ov_infores0_.Anyo as anyo10_910_, ov_infores0_.Obre_Resource_ID as obre_re11_910_, ov_infores0_.M_Product_ID as m_produ12_910_, ov_infores0_.Totalgasto as totalga13_910_, ov_infores0_.Totalactuaciones as totalac14_910_, ov_infores0_.Totalbalance as totalba15_910_, ov_infores0_.Totalreservas as totalre16_910_, ov_infores0_.Totalfacturas as totalfa17_910_, ov_infores0_.Totalhaber as totalha18_910_, ov_infores0_.Totaldebe as totalde19_910_, ov_infores0_.Propietario as propiet20_910_, ov_infores0_.Totalpago as totalpa21_910_ from ov_inforesumen_v ov_infores0_ where ov_infores0_.Obre_Resource_ID = 'A0BE6D13577547E9B081A56EA6128A79' and ov_infores0_.Propietario = '1E079A1DBF9A45C8998DFA863D75AA60' and ov_infores0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infores0_.Anyo = '2026' and (ov_infores0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infores0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infores0_.Isactive = 'Y' order by ov_infores0_.OV_Inforesumen_V_ID desc;
Date: 2026-07-18 16:00:15 Duration: 1s988ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select ov_infores0_.OV_Inforesumen_V_ID as ov_infor1_910_, ov_infores0_.AD_Client_ID as ad_clien2_910_, ov_infores0_.AD_Org_ID as ad_org_i3_910_, ov_infores0_.Created as created4_910_, ov_infores0_.Createdby as createdb5_910_, ov_infores0_.Updated as updated6_910_, ov_infores0_.Updatedby as updatedb7_910_, ov_infores0_.Isactive as isactive8_910_, ov_infores0_.Fecha as fecha9_910_, ov_infores0_.Anyo as anyo10_910_, ov_infores0_.Obre_Resource_ID as obre_re11_910_, ov_infores0_.M_Product_ID as m_produ12_910_, ov_infores0_.Totalgasto as totalga13_910_, ov_infores0_.Totalactuaciones as totalac14_910_, ov_infores0_.Totalbalance as totalba15_910_, ov_infores0_.Totalreservas as totalre16_910_, ov_infores0_.Totalfacturas as totalfa17_910_, ov_infores0_.Totalhaber as totalha18_910_, ov_infores0_.Totaldebe as totalde19_910_, ov_infores0_.Propietario as propiet20_910_, ov_infores0_.Totalpago as totalpa21_910_ from ov_inforesumen_v ov_infores0_ where ov_infores0_.Obre_Resource_ID = 'A0BE6D13577547E9B081A56EA6128A79' and ov_infores0_.Propietario = '1E079A1DBF9A45C8998DFA863D75AA60' and ov_infores0_.AD_Org_ID <> '89AC9B7D5FB043308093F1C33A2A9F96' and ov_infores0_.Anyo = '2026' and (ov_infores0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_infores0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) and ov_infores0_.Isactive = 'Y' order by ov_infores0_.OV_Inforesumen_V_ID desc;
Date: 2026-07-18 15:58:11 Duration: 1s960ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
8 1s1ms 2s99ms 1s264ms 24 30s343ms update c_order set updated = ?, c_paymentterm_id = ? where c_order_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 18 09 24 30s343ms 1s264ms [ User: tad - Total duration: 30s343ms - Times executed: 24 ]
[ Application: openbravo - Total duration: 30s343ms - Times executed: 24 ]
-
update C_Order set Updated = '2026-07-18 09:11:47.753', C_PaymentTerm_ID = 'D8CD13F170C942E4A7498583E08E1F6E' where C_Order_ID = '8BD987CC4C264BA28D9FB29A5210A7F0';
Date: 2026-07-18 09:11:49 Duration: 2s99ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update C_Order set Updated = '2026-07-18 09:11:49.076', C_PaymentTerm_ID = 'D8CD13F170C942E4A7498583E08E1F6E' where C_Order_ID = '8BD987CC4C264BA28D9FB29A5210A7F0';
Date: 2026-07-18 09:11:50 Duration: 1s671ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
update C_Order set Updated = '2026-07-18 09:11:49.72', C_PaymentTerm_ID = '8D91F90A4392451D89D8F7995D4BF884' where C_Order_ID = '8BD987CC4C264BA28D9FB29A5210A7F0';
Date: 2026-07-18 09:11:51 Duration: 1s598ms 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
- 4,447 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 1 Total events found
Rank Times reported Error 1 1 ERROR: @20501@
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 18 17 1 - ERROR: @20501@
Context: PL/pgSQL function c_orderlinetax_trg() line 132 at RAISE
Statement: delete from C_OrderLineTax where C_Orderlinetax_ID=$1Date: 2026-07-18 17:15:45 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1