pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Mon Jul 13 23:00:03 2026
Log file: /var/log/postgresql/postgresql-10-main.log
Parsed 84,534 log entries in 2s
Log start from 2026-07-13 07:00:01 to 2026-07-13 21:59:56

Global Stats

4 Number of unique normalized queries
15 Number of queries
1m33s Total query duration
2026-07-13 10:12:16 First query
2026-07-13 20:49:47 Last query
1 queries/s at 2026-07-13 13:22:47 Query peak

2,882 Number of events
3 Number of unique normalized events
2,880 Max number of times the same event was reported
0 Number of cancellation

79 Total number of automatic vacuums
128 Total number of automatic analyzes

0 Number temporary file
0 Max size of temporary file
0.00 B Average size of temporary file

7,582 Total number of sessions
4 sessions at 2026-07-13 20:50:14 Session peak
1d7h3m23s Total duration of sessions
14s745ms Average duration of sessions
0 Average queries per session
12ms Average queries duration per session

10,463 Total number of connections
9 connections/s at 2026-07-13 12:05:26 Connection peak
1 Total number of databases

SQL Traffic

Key values

1 queries/s Query Peak
2026-07-13 13:22:47 Date

SELECT Traffic

Key values

1 queries/s Query Peak
2026-07-13 13:22:47 Date

INSERT/UPDATE/DELETE Traffic

Key values

1 queries/s Query Peak
2026-07-13 20:49:47 Date

Queries duration

Key values

1m33s Total query duration

Prepared queries ratio

Key values

15.00 Ratio of bind vs prepare
100.00 % Ratio between prepared and "usual" statements

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 13	07	0	0ms	0ms	0ms	0ms	0ms	0ms
	08	0	0ms	0ms	0ms	0ms	0ms	0ms
	09	0	0ms	0ms	0ms	0ms	0ms	0ms
	10	4	0ms	1s376ms	1s290ms	0ms	1s288ms	1s376ms
	11	0	0ms	0ms	0ms	0ms	0ms	0ms
	12	0	0ms	0ms	0ms	0ms	0ms	0ms
	13	10	0ms	2s528ms	1s975ms	0ms	4s154ms	4s973ms
	14	0	0ms	0ms	0ms	0ms	0ms	0ms
	15	0	0ms	0ms	0ms	0ms	0ms	0ms
	16	0	0ms	0ms	0ms	0ms	0ms	0ms
	17	0	0ms	0ms	0ms	0ms	0ms	0ms
	18	0	0ms	0ms	0ms	0ms	0ms	0ms
	19	0	0ms	0ms	0ms	0ms	0ms	0ms
	20	1	0ms	1m8s	1m8s	0ms	0ms	1m8s
	21	0	0ms	0ms	0ms	0ms	0ms	0ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 13	07	0	0ms	0ms	0ms	0ms
	08	0	0ms	0ms	0ms	0ms
	09	0	0ms	0ms	0ms	0ms
	10	4	1s290ms	0ms	0ms	1s289ms
	11	0	0ms	0ms	0ms	0ms
	12	0	0ms	0ms	0ms	0ms
	13	10	1s975ms	0ms	0ms	4s669ms
	14	0	0ms	0ms	0ms	0ms
	15	0	0ms	0ms	0ms	0ms
	16	0	0ms	0ms	0ms	0ms
	17	0	0ms	0ms	0ms	0ms
	18	0	0ms	0ms	0ms	0ms
	19	0	0ms	0ms	0ms	0ms
	20	0	0ms	0ms	0ms	0ms
	21	0	0ms	0ms	0ms	0ms

Day	Hour	UPDATE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 13	07	0	0ms	0ms	0ms	0ms
	08	0	0ms	0ms	0ms	0ms
	09	0	0ms	0ms	0ms	0ms
	10	0	0ms	0ms	0ms	0ms
	11	0	0ms	0ms	0ms	0ms
	12	0	0ms	0ms	0ms	0ms
	13	0	0ms	0ms	0ms	0ms
	14	0	0ms	0ms	0ms	0ms
	15	0	0ms	0ms	0ms	0ms
	16	0	0ms	0ms	0ms	0ms
	17	0	0ms	0ms	0ms	0ms
	18	0	0ms	0ms	0ms	0ms
	19	0	0ms	0ms	0ms	0ms
	20	1	1m8s	0ms	0ms	0ms
	21	0	0ms	0ms	0ms	0ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
Jul 13	07	0	0.00	0.00%
	08	0	0.00	0.00%
	09	0	0.00	0.00%
	10	4	4.00	0.00%
	11	0	0.00	0.00%
	12	0	0.00	0.00%
	13	10	10.00	0.00%
	14	0	0.00	0.00%
	15	0	0.00	0.00%
	16	0	0.00	0.00%
	17	0	0.00	0.00%
	18	0	0.00	0.00%
	19	0	0.00	0.00%
	20	1	1.00	0.00%
	21	0	0.00	0.00%

Day	Hour	Count	Average / Second
Jul 13	07	700	0.19/s
	08	697	0.19/s
	09	697	0.19/s
	10	698	0.19/s
	11	697	0.19/s
	12	697	0.19/s
	13	697	0.19/s
	14	697	0.19/s
	15	697	0.19/s
	16	697	0.19/s
	17	698	0.19/s
	18	697	0.19/s
	19	697	0.19/s
	20	700	0.19/s
	21	697	0.19/s

Day	Hour	Count	Average Duration
Jul 13	07	507	12ms
	08	505	11ms
	09	505	11ms
	10	506	366ms
	11	505	11ms
	12	505	11ms
	13	505	11ms
	14	505	11ms
	15	505	11ms
	16	505	11ms
	17	506	1m24s
	18	505	11ms
	19	505	11ms
	20	508	2m14s
	21	505	11ms

↑ Back to the top of the General Activity table

Established Connections

Key values

9 connections Connection Peak
2026-07-13 12:05:26 Date

Connections per database

Key values

etendo Main Database
10,463 connections Total

Chart
Table

Database	User	Count
etendo		3,247
	postgres	61
	tad	3,186
openbravo		2,880
	postgres	2,880
postgres		2,176
	postgres	2,176
template1		2,160
	postgres	2,160

Connections per user

Key values

postgres Main User
10,463 connections Total

Chart
Table

User	Count
postgres	7,277
tad	3,186

Connections per host

Key values

[local] Main host with 7277 connections
10,463 Total connections

Chart
Table

Host	Count
127.0.0.1	6
::1	3,180
[local]	7,277

Simultaneous sessions

Key values

4 sessions Session Peak
2026-07-13 20:50:14 Date

Histogram of session times

Key values

7,559 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	7,559	99.70%
500ms-1s	18	0.24%
1s-30s	0	0.00%
30s-1m	0	0.00%
1m-10m	2	0.03%
10m-30m	0	0.00%
30m-1h	0	0.00%
1h-8h	1	0.01%
> 8h	2	0.03%

Sessions per database

Key values

etendo Main Database
7,582 sessions Total

Chart
Table

Database	User	Count	Total Duration
etendo	3,246	1d7h2m51s	34s433ms
postgres	2,176	17s488ms	8ms
template1	2,160	14s398ms	6ms

Sessions per user

Key values

postgres Main User
7,582 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
postgres	4,397	54s661ms
tad	3,185	1d7h2m28s

Sessions per host

Key values

[local] Main Host
7,582 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	5	1d7h1m54s	6h12m22s
::1	3,180	33s691ms	10ms
[local]	4,397	54s661ms	12ms

Sessions per application

Key values

[unknown] Main Host
7,582 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
[unknown]	4,350	36s375ms	8ms
openbravo	5	1d7h1m54s	6h12m22s
pg_profile	15	7s308ms	487ms
psql	3,212	44s669ms	13ms

Checkpoints Buffers

Key values

0 buffers Checkpoint Peak
Date
seconds Highest write time
seconds Sync time

Checkpoint write buffers (5 minutes period)

NO DATASET

Checkpoints Wal files

Key values

0 files Wal files usage Peak
Date

Checkpoint Wal files usage (5 minutes period)

NO DATASET

Checkpoints distance

Key values

Checkpoint mean distance and estimate (5 minutes period)

NO DATASET

Checkpoints Activity

Day	Hour	Write time	Sync time	Total time
Jul 13	07	0s	0s	0s
	08	0s	0s	0s
	09	0s	0s	0s
	10	0s	0s	0s
	11	0s	0s	0s
	12	0s	0s	0s
	13	0s	0s	0s
	14	0s	0s	0s
	15	0s	0s	0s
	16	0s	0s	0s
	17	0s	0s	0s
	18	0s	0s	0s
	19	0s	0s	0s
	20	0s	0s	0s
	21	0s	0s	0s

Day	Hour	Longest sync	Average sync
Jul 13	07	0s	0s
	08	0s	0s
	09	0s	0s
	10	0s	0s
	11	0s	0s
	12	0s	0s
	13	0s	0s
	14	0s	0s
	15	0s	0s
	16	0s	0s
	17	0s	0s
	18	0s	0s
	19	0s	0s
	20	0s	0s
	21	0s	0s

Day	Hour	Avg time (sec)
Jul 13	07	0s
	08	0s
	09	0s
	10	0s
	11	0s
	12	0s
	13	0s
	14	0s
	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s
	21	0s

Day	Hour	Mean distance	Mean estimate
Jul 13	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0

↑ Back to the top of the Checkpoint Activity table

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

NO DATASET

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

NO DATASET

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jul 13	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date
0 sec Highest CPU-cost analyze
Table
Database
Date

Analyzes per table

Key values

public.ad_ep_instance_para (27) Main table analyzed (database etendo)
128 analyzes Total

Chart
Table

Table	Number of analyzes
etendo.public.ad_ep_instance_para	27
etendo.public.ad_session	19
etendo.profile.last_stat_tables	15
etendo.profile.last_stat_user_functions	15
etendo.public.c_invoice	15
etendo.profile.last_stat_indexes	15
etendo.public.ad_process_request	4
etendo.public.ad_pinstance	3
etendo.public.ad_preference	3
etendo.profile.sample_stat_user_functions	2
etendo.public.prsync_entry	2
etendo.profile.last_stat_database	2
etendo.profile.sample_stat_indexes	1
etendo.profile.sample_stat_tables	1
etendo.profile.sample_stat_indexes_total	1
etendo.profile.sample_stat_tables_total	1
etendo.profile.sample_statements	1
etendo.profile.sample_stat_database	1
Total	128

Vacuums per table

Key values

public.c_invoice (15) Main table vacuumed on database etendo
79 vacuums Total

Chart
Table

Table	Number of vacuums	Index scans
etendo.public.c_invoice	15	15
etendo.profile.last_stat_tables	15	15
etendo.public.ad_ep_instance_para	15	15
etendo.profile.last_stat_user_functions	15	0
etendo.profile.last_stat_indexes	15	15
etendo.pg_toast.pg_toast_2619	2	2
etendo.pg_toast.pg_toast_3525579	1	1
etendo.profile.last_stat_database	1	1
Total	79	64

Tuples removed per table

Key values

public.c_invoice (188359) Main table with removed tuples on database etendo
255162 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
etendo.public.c_invoice	15	15	188359	0
etendo.profile.last_stat_indexes	15	15	36189	0
etendo.profile.last_stat_tables	15	15	23638	0
etendo.profile.last_stat_user_functions	15	0	6200	3
etendo.pg_toast.pg_toast_2619	2	2	561	0
etendo.public.ad_ep_instance_para	15	15	197	15
etendo.profile.last_stat_database	1	1	12	0
etendo.pg_toast.pg_toast_3525579	1	1	6	0
Total	79	64	255,162	18

Pages removed per table

Key values

public.ad_ep_instance_para (15) Main table with removed pages on database etendo
18 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
etendo.public.ad_ep_instance_para	15	15	197	15
etendo.profile.last_stat_user_functions	15	0	6200	3
etendo.public.c_invoice	15	15	188359	0
etendo.pg_toast.pg_toast_2619	2	2	561	0
etendo.pg_toast.pg_toast_3525579	1	1	6	0
etendo.profile.last_stat_tables	15	15	23638	0
etendo.profile.last_stat_database	1	1	12	0
etendo.profile.last_stat_indexes	15	15	36189	0
Total	79	64	255,162	18

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jul 13	07	4	6
	08	6	10
	09	4	6
	10	6	10
	11	6	12
	12	6	11
	13	4	9
	14	5	8
	15	4	5
	16	6	8
	17	4	8
	18	6	7
	19	5	6
	20	7	12
	21	6	10

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

ShareLock Main Lock Type
1 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ShareLock		1	1m8s	1m8s
	transaction	1	1m8s	1m8s
	Total	1	1m8s	1m8s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	1	1m8s	1m8s	1m8s	1m8s	UPDATE c_invoice SET processing = '' WHERE c_invoice_id = ? AND processed = '' AND (processing = '' OR processing IS NULL) AND posted <> ''; UPDATE C_Invoice SET Processing = 'Y' WHERE C_Invoice_ID = $1 AND Processed = 'Y' AND (Processing = 'N' OR Processing IS NULL) AND Posted <> 'Y'; Date: 2026-07-13 20:49:47 Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo

Queries that waited the most

Rank	Wait time	Query
1	1m8s	UPDATE C_Invoice SET Processing = 'Y' WHERE C_Invoice_ID = $1 AND Processed = 'Y' AND (Processing = 'N' OR Processing IS NULL) AND Posted <> 'Y'; [ Date: 2026-07-13 20:49:47 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

Queries by type

Key values

14 Total read queries
1 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	14	93.33%
INSERT	0	0.00%
UPDATE	1	6.67%
DELETE	0	0.00%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	0	0.00%
TCL	0	0.00%

Queries by database

Key values

etendo Main database
15 Requests
1m33s (etendo)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
etendo	Total	15	1m33s
	SELECT	14	24s913ms
	UPDATE	1	1m8s

Queries by user

Key values

tad Main user
15 Requests

Queries Chart
Table

User	Request type	Count	Duration
tad	Total	15	1m33s
	SELECT	14	24s913ms
	UPDATE	1	1m8s

Duration by user

Key values

1m33s (tad) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
tad	Total	15	1m33s
	SELECT	14	24s913ms
	UPDATE	1	1m8s

Queries by host

Key values

127.0.0.1 Main host
15 Requests
1m33s (127.0.0.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	15	1m33s
	SELECT	14	24s913ms
	UPDATE	1	1m8s

Queries by application

Key values

openbravo Main application
15 Requests
1m33s (openbravo)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
openbravo	Total	15	1m33s
	SELECT	14	24s913ms
	UPDATE	1	1m8s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-07-13 19:30:08 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Top Queries

Histogram of query times

Key values

14 1000-10000ms duration

Chart
Table

Range	Count	Percentage
0-1ms	0	0.00%
1-5ms	0	0.00%
5-10ms	0	0.00%
10-25ms	0	0.00%
25-50ms	0	0.00%
50-100ms	0	0.00%
100-500ms	0	0.00%
500-1000ms	0	0.00%
1000-10000ms	14	93.33%
> 10000ms	1	6.67%

Slowest individual queries


[ Date: 2026-07-13 20:49:47 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 13:23:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 13:23:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 13:24:57 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 13:22:47 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 13:24:26 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 13:22:19 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 13:21:39 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 13:09:58 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 13:21:07 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 13:09:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 10:15:06 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 10:38:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 10:13:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 10:12:16 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

Rank	Duration	Query
1	1m8s	UPDATE C_Invoice SET Processing = 'Y' WHERE C_Invoice_ID = '00350E7183BC4D6C8497F1B3878A3336' AND Processed = 'Y' AND (Processing = 'N' OR Processing IS NULL) AND Posted <> 'Y'; [ Date: 2026-07-13 20:49:47 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
2	2s528ms	SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2019') AND C_ORDER.DATEORDERED < to_date ('01-01-2020')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1; [ Date: 2026-07-13 13:23:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3	2s445ms	SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2018') AND C_ORDER.DATEORDERED < to_date ('01-01-2019')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1; [ Date: 2026-07-13 13:23:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
4	2s423ms	SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2021') AND C_ORDER.DATEORDERED < to_date ('01-01-2022')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1; [ Date: 2026-07-13 13:24:57 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
5	2s275ms	SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2017') AND C_ORDER.DATEORDERED < to_date ('01-01-2018')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1; [ Date: 2026-07-13 13:22:47 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
6	2s245ms	SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2020') AND C_ORDER.DATEORDERED < to_date ('01-01-2021')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1; [ Date: 2026-07-13 13:24:26 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
7	1s879ms	SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2016') AND C_ORDER.DATEORDERED < to_date ('01-01-2017')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1; [ Date: 2026-07-13 13:22:19 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
8	1s596ms	SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2015') AND C_ORDER.DATEORDERED < to_date ('01-01-2016')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1; [ Date: 2026-07-13 13:21:39 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
9	1s465ms	SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2014') AND C_ORDER.DATEORDERED < to_date ('01-01-2015')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1; [ Date: 2026-07-13 13:09:58 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
10	1s462ms	SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2014') AND C_ORDER.DATEORDERED < to_date ('01-01-2015')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1; [ Date: 2026-07-13 13:21:07 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
11	1s428ms	SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2013') AND C_ORDER.DATEORDERED < to_date ('01-01-2014')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1; [ Date: 2026-07-13 13:09:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
12	1s376ms	SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2012') AND C_ORDER.DATEORDERED < to_date ('01-01-2013')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1; [ Date: 2026-07-13 10:15:06 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
13	1s289ms	SELECT td0.AD_User_ID AS ID, (COALESCE (to_char (COALESCE (to_char (td0.Name), '')), '')) AS NAME, '' AS DESCRIPTION FROM AD_User td0 WHERE td0.AD_Client_ID IN ('0', '1000001') AND td0.AD_Org_ID IN ('0', '1000002') AND (EXISTS ( SELECT ad_user_id FROM ad_user LEFT JOIN c_bpartner ON td0.c_bpartner_id = c_bpartner.c_bpartner_id WHERE c_bpartner.isemployee = 'Y')) AND (td0.isActive = 'Y' OR td0.AD_User_ID = (NULL)) ORDER BY 2 LIMIT 1 OFFSET 0; [ Date: 2026-07-13 10:38:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
14	1s288ms	SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2011') AND C_ORDER.DATEORDERED < to_date ('01-01-2012')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1; [ Date: 2026-07-13 10:13:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
15	1s209ms	SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2010') AND C_ORDER.DATEORDERED < to_date ('01-01-2011')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1; [ Date: 2026-07-13 10:12:16 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

Time consuming queries

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

1m8s

1

Details

1m8s

UPDATE c_invoice SET processing = '' WHERE c_invoice_id = '' AND processed = '' AND (processing = '' OR processing IS NULL) AND posted <> '';

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 13	20	1	1m8s	1m8s

[ User: tad - Total duration: 1m8s - Times executed: 1 ]

[ Application: openbravo - Total duration: 1m8s - Times executed: 1 ]

UPDATE C_Invoice SET Processing = 'Y' WHERE C_Invoice_ID = '00350E7183BC4D6C8497F1B3878A3336' AND Processed = 'Y' AND (Processing = 'N' OR Processing IS NULL) AND Posted <> 'Y';

2

23s624ms

13

Details

1s209ms

2s528ms

1s817ms

SELECT nivel1, nivel2, nivel3, nivel4, nivel5, nivel6, nivel7, nivel8, nivel9, nivel10, nivel11, sum (amount) AS amount, sum (qty) AS qty, sum (weight) AS weight, sum (amountref) AS amountref, sum (qtyref) AS qtyref, sum (weightref) AS weightref, sum (convamount) AS convamount, sum (convamountref) AS convamountref, c_currency_symbol ('', 0, '') AS convsym, c_currency_isosym ('') AS convisosym, min (wsymbol) AS wsymbol FROM ( SELECT nivel1, nivel2, nivel3, nivel4, nivel5, nivel6, nivel7, nivel8, nivel9, nivel10, nivel11, sum (linenetamt) AS amount, sum (qtyordered) AS qty, sum (weight) AS weight, sum (linenetref) AS amountref, sum (qtyorderedref) AS qtyref, sum (weightref) AS weightref, c_currency_convert (sum (linenetamt), trcurrencyid, '', to_date (trdate), NULL, trclientid, trorgid) AS convamount, 0 AS convamountref, trcurrencyid, trdate, trclientid, trorgid, min (wsymbol) AS wsymbol FROM ( SELECT to_char (ad_column_identifier (to_char (''), to_char (c_bpartner.c_bpartner_id), to_char (''))) AS nivel1, to_char ('') AS nivel2, to_char ('') AS nivel3, to_char ('') AS nivel4, to_char ('') AS nivel5, to_char ('') AS nivel6, to_char ('') AS nivel7, to_char ('') AS nivel8, to_char ('') AS nivel9, to_char ('') AS nivel10, to_char ('') AS nivel11, c_orderline.linenetamt, c_orderline.qtyordered, c_orderline.qtyordered * m_product.weight AS weight, 0 AS linenetref, 0 AS qtyorderedref, 0 AS weightref, c_uom.uomsymbol, COALESCE (c_orderline.c_currency_id, c_order.c_currency_id) AS trcurrencyid, to_date (COALESCE (c_order.dateordered, now ())) AS trdate, c_orderline.ad_client_id AS trclientid, c_orderline.ad_org_id AS trorgid, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS wsymbol FROM c_order LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN ad_user ON c_order.salesrep_id = ad_user.ad_user_id, c_bpartner LEFT JOIN c_bpartner cb ON c_bpartner.salesrep_id = cb.c_bpartner_id, c_bp_group, c_orderline, m_product, m_product_category, m_warehouse, c_uom, ad_org WHERE c_order.c_bpartner_id = c_bpartner.c_bpartner_id AND c_bpartner.c_bp_group_id = c_bp_group.c_bp_group_id AND c_order.c_order_id = c_orderline.c_order_id AND c_orderline.m_product_id = m_product.m_product_id AND m_product.m_product_category_id = m_product_category.m_product_category_id AND c_order.m_warehouse_id = m_warehouse.m_warehouse_id AND c_orderline.c_uom_id = c_uom.c_uom_id AND c_order.ad_org_id = ad_org.ad_org_id AND c_order.issotrx = '' AND c_order.processed = '' AND c_order.docstatus NOT IN (...) AND 0 = 0 AND c_order.ad_org_id IN (...) AND c_order.ad_client_id IN (...) AND 0 = 0 AND c_order.dateordered >= to_date ('') AND c_order.dateordered < to_date ('')) aa GROUP BY nivel1, nivel2, nivel3, nivel4, nivel5, nivel6, nivel7, nivel8, nivel9, nivel10, nivel11, trcurrencyid, trdate, trclientid, trorgid) zz GROUP BY nivel1, nivel2, nivel3, nivel4, nivel5, nivel6, nivel7, nivel8, nivel9, nivel10, nivel11 ORDER BY nivel1;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jul 13	10	3	3s874ms	1s291ms
	13	10	19s750ms	1s975ms

[ User: tad - Total duration: 23s624ms - Times executed: 13 ]

[ Application: openbravo - Total duration: 23s624ms - Times executed: 13 ]

SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2019') AND C_ORDER.DATEORDERED < to_date ('01-01-2020')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1;
SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2018') AND C_ORDER.DATEORDERED < to_date ('01-01-2019')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1;
SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2021') AND C_ORDER.DATEORDERED < to_date ('01-01-2022')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1;

3

1s289ms

1

Details

1s289ms

SELECT td0.ad_user_id AS id, (COALESCE (to_char (COALESCE (to_char (td0.name), '')), '')) AS name, '' AS description FROM ad_user td0 WHERE td0.ad_client_id IN (...) AND td0.ad_org_id IN (...) AND (EXISTS ( SELECT ad_user_id FROM ad_user LEFT JOIN c_bpartner ON td0.c_bpartner_id = c_bpartner.c_bpartner_id WHERE c_bpartner.isemployee = '')) AND (td0.isactive = '' OR td0.ad_user_id = (NULL)) ORDER BY 0 LIMIT 0 OFFSET 0;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jul 13	10	1	1s289ms	1s289ms

[ User: tad - Total duration: 1s289ms - Times executed: 1 ]

[ Application: openbravo - Total duration: 1s289ms - Times executed: 1 ]

SELECT td0.AD_User_ID AS ID, (COALESCE (to_char (COALESCE (to_char (td0.Name), '')), '')) AS NAME, '' AS DESCRIPTION FROM AD_User td0 WHERE td0.AD_Client_ID IN ('0', '1000001') AND td0.AD_Org_ID IN ('0', '1000002') AND (EXISTS ( SELECT ad_user_id FROM ad_user LEFT JOIN c_bpartner ON td0.c_bpartner_id = c_bpartner.c_bpartner_id WHERE c_bpartner.isemployee = 'Y')) AND (td0.isActive = 'Y' OR td0.AD_User_ID = (NULL)) ORDER BY 2 LIMIT 1 OFFSET 0;

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

13

Details

23s624ms

1s209ms

2s528ms

1s817ms

SELECT nivel1, nivel2, nivel3, nivel4, nivel5, nivel6, nivel7, nivel8, nivel9, nivel10, nivel11, sum (amount) AS amount, sum (qty) AS qty, sum (weight) AS weight, sum (amountref) AS amountref, sum (qtyref) AS qtyref, sum (weightref) AS weightref, sum (convamount) AS convamount, sum (convamountref) AS convamountref, c_currency_symbol ('', 0, '') AS convsym, c_currency_isosym ('') AS convisosym, min (wsymbol) AS wsymbol FROM ( SELECT nivel1, nivel2, nivel3, nivel4, nivel5, nivel6, nivel7, nivel8, nivel9, nivel10, nivel11, sum (linenetamt) AS amount, sum (qtyordered) AS qty, sum (weight) AS weight, sum (linenetref) AS amountref, sum (qtyorderedref) AS qtyref, sum (weightref) AS weightref, c_currency_convert (sum (linenetamt), trcurrencyid, '', to_date (trdate), NULL, trclientid, trorgid) AS convamount, 0 AS convamountref, trcurrencyid, trdate, trclientid, trorgid, min (wsymbol) AS wsymbol FROM ( SELECT to_char (ad_column_identifier (to_char (''), to_char (c_bpartner.c_bpartner_id), to_char (''))) AS nivel1, to_char ('') AS nivel2, to_char ('') AS nivel3, to_char ('') AS nivel4, to_char ('') AS nivel5, to_char ('') AS nivel6, to_char ('') AS nivel7, to_char ('') AS nivel8, to_char ('') AS nivel9, to_char ('') AS nivel10, to_char ('') AS nivel11, c_orderline.linenetamt, c_orderline.qtyordered, c_orderline.qtyordered * m_product.weight AS weight, 0 AS linenetref, 0 AS qtyorderedref, 0 AS weightref, c_uom.uomsymbol, COALESCE (c_orderline.c_currency_id, c_order.c_currency_id) AS trcurrencyid, to_date (COALESCE (c_order.dateordered, now ())) AS trdate, c_orderline.ad_client_id AS trclientid, c_orderline.ad_org_id AS trorgid, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS wsymbol FROM c_order LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN ad_user ON c_order.salesrep_id = ad_user.ad_user_id, c_bpartner LEFT JOIN c_bpartner cb ON c_bpartner.salesrep_id = cb.c_bpartner_id, c_bp_group, c_orderline, m_product, m_product_category, m_warehouse, c_uom, ad_org WHERE c_order.c_bpartner_id = c_bpartner.c_bpartner_id AND c_bpartner.c_bp_group_id = c_bp_group.c_bp_group_id AND c_order.c_order_id = c_orderline.c_order_id AND c_orderline.m_product_id = m_product.m_product_id AND m_product.m_product_category_id = m_product_category.m_product_category_id AND c_order.m_warehouse_id = m_warehouse.m_warehouse_id AND c_orderline.c_uom_id = c_uom.c_uom_id AND c_order.ad_org_id = ad_org.ad_org_id AND c_order.issotrx = '' AND c_order.processed = '' AND c_order.docstatus NOT IN (...) AND 0 = 0 AND c_order.ad_org_id IN (...) AND c_order.ad_client_id IN (...) AND 0 = 0 AND c_order.dateordered >= to_date ('') AND c_order.dateordered < to_date ('')) aa GROUP BY nivel1, nivel2, nivel3, nivel4, nivel5, nivel6, nivel7, nivel8, nivel9, nivel10, nivel11, trcurrencyid, trdate, trclientid, trorgid) zz GROUP BY nivel1, nivel2, nivel3, nivel4, nivel5, nivel6, nivel7, nivel8, nivel9, nivel10, nivel11 ORDER BY nivel1;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 13	10	3	3s874ms	1s291ms
	13	10	19s750ms	1s975ms

[ User: tad - Total duration: 23s624ms - Times executed: 13 ]

[ Application: openbravo - Total duration: 23s624ms - Times executed: 13 ]

SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2019') AND C_ORDER.DATEORDERED < to_date ('01-01-2020')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1;
SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2018') AND C_ORDER.DATEORDERED < to_date ('01-01-2019')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1;
SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2021') AND C_ORDER.DATEORDERED < to_date ('01-01-2022')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1;

2

1

Details

1s289ms

SELECT td0.ad_user_id AS id, (COALESCE (to_char (COALESCE (to_char (td0.name), '')), '')) AS name, '' AS description FROM ad_user td0 WHERE td0.ad_client_id IN (...) AND td0.ad_org_id IN (...) AND (EXISTS ( SELECT ad_user_id FROM ad_user LEFT JOIN c_bpartner ON td0.c_bpartner_id = c_bpartner.c_bpartner_id WHERE c_bpartner.isemployee = '')) AND (td0.isactive = '' OR td0.ad_user_id = (NULL)) ORDER BY 0 LIMIT 0 OFFSET 0;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jul 13	10	1	1s289ms	1s289ms

[ User: tad - Total duration: 1s289ms - Times executed: 1 ]

[ Application: openbravo - Total duration: 1s289ms - Times executed: 1 ]

SELECT td0.AD_User_ID AS ID, (COALESCE (to_char (COALESCE (to_char (td0.Name), '')), '')) AS NAME, '' AS DESCRIPTION FROM AD_User td0 WHERE td0.AD_Client_ID IN ('0', '1000001') AND td0.AD_Org_ID IN ('0', '1000002') AND (EXISTS ( SELECT ad_user_id FROM ad_user LEFT JOIN c_bpartner ON td0.c_bpartner_id = c_bpartner.c_bpartner_id WHERE c_bpartner.isemployee = 'Y')) AND (td0.isActive = 'Y' OR td0.AD_User_ID = (NULL)) ORDER BY 2 LIMIT 1 OFFSET 0;

3

1

Details

1m8s

UPDATE c_invoice SET processing = '' WHERE c_invoice_id = '' AND processed = '' AND (processing = '' OR processing IS NULL) AND posted <> '';

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jul 13	20	1	1m8s	1m8s

[ User: tad - Total duration: 1m8s - Times executed: 1 ]

[ Application: openbravo - Total duration: 1m8s - Times executed: 1 ]

UPDATE C_Invoice SET Processing = 'Y' WHERE C_Invoice_ID = '00350E7183BC4D6C8497F1B3878A3336' AND Processed = 'Y' AND (Processing = 'N' OR Processing IS NULL) AND Posted <> 'Y';

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

1m8s

1

Details

1m8s

UPDATE c_invoice SET processing = '' WHERE c_invoice_id = '' AND processed = '' AND (processing = '' OR processing IS NULL) AND posted <> '';

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 13	20	1	1m8s	1m8s

[ User: tad - Total duration: 1m8s - Times executed: 1 ]

[ Application: openbravo - Total duration: 1m8s - Times executed: 1 ]

UPDATE C_Invoice SET Processing = 'Y' WHERE C_Invoice_ID = '00350E7183BC4D6C8497F1B3878A3336' AND Processed = 'Y' AND (Processing = 'N' OR Processing IS NULL) AND Posted <> 'Y';

2

1s209ms

2s528ms

1s817ms

13

Details

23s624ms

SELECT nivel1, nivel2, nivel3, nivel4, nivel5, nivel6, nivel7, nivel8, nivel9, nivel10, nivel11, sum (amount) AS amount, sum (qty) AS qty, sum (weight) AS weight, sum (amountref) AS amountref, sum (qtyref) AS qtyref, sum (weightref) AS weightref, sum (convamount) AS convamount, sum (convamountref) AS convamountref, c_currency_symbol ('', 0, '') AS convsym, c_currency_isosym ('') AS convisosym, min (wsymbol) AS wsymbol FROM ( SELECT nivel1, nivel2, nivel3, nivel4, nivel5, nivel6, nivel7, nivel8, nivel9, nivel10, nivel11, sum (linenetamt) AS amount, sum (qtyordered) AS qty, sum (weight) AS weight, sum (linenetref) AS amountref, sum (qtyorderedref) AS qtyref, sum (weightref) AS weightref, c_currency_convert (sum (linenetamt), trcurrencyid, '', to_date (trdate), NULL, trclientid, trorgid) AS convamount, 0 AS convamountref, trcurrencyid, trdate, trclientid, trorgid, min (wsymbol) AS wsymbol FROM ( SELECT to_char (ad_column_identifier (to_char (''), to_char (c_bpartner.c_bpartner_id), to_char (''))) AS nivel1, to_char ('') AS nivel2, to_char ('') AS nivel3, to_char ('') AS nivel4, to_char ('') AS nivel5, to_char ('') AS nivel6, to_char ('') AS nivel7, to_char ('') AS nivel8, to_char ('') AS nivel9, to_char ('') AS nivel10, to_char ('') AS nivel11, c_orderline.linenetamt, c_orderline.qtyordered, c_orderline.qtyordered * m_product.weight AS weight, 0 AS linenetref, 0 AS qtyorderedref, 0 AS weightref, c_uom.uomsymbol, COALESCE (c_orderline.c_currency_id, c_order.c_currency_id) AS trcurrencyid, to_date (COALESCE (c_order.dateordered, now ())) AS trdate, c_orderline.ad_client_id AS trclientid, c_orderline.ad_org_id AS trorgid, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS wsymbol FROM c_order LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN ad_user ON c_order.salesrep_id = ad_user.ad_user_id, c_bpartner LEFT JOIN c_bpartner cb ON c_bpartner.salesrep_id = cb.c_bpartner_id, c_bp_group, c_orderline, m_product, m_product_category, m_warehouse, c_uom, ad_org WHERE c_order.c_bpartner_id = c_bpartner.c_bpartner_id AND c_bpartner.c_bp_group_id = c_bp_group.c_bp_group_id AND c_order.c_order_id = c_orderline.c_order_id AND c_orderline.m_product_id = m_product.m_product_id AND m_product.m_product_category_id = m_product_category.m_product_category_id AND c_order.m_warehouse_id = m_warehouse.m_warehouse_id AND c_orderline.c_uom_id = c_uom.c_uom_id AND c_order.ad_org_id = ad_org.ad_org_id AND c_order.issotrx = '' AND c_order.processed = '' AND c_order.docstatus NOT IN (...) AND 0 = 0 AND c_order.ad_org_id IN (...) AND c_order.ad_client_id IN (...) AND 0 = 0 AND c_order.dateordered >= to_date ('') AND c_order.dateordered < to_date ('')) aa GROUP BY nivel1, nivel2, nivel3, nivel4, nivel5, nivel6, nivel7, nivel8, nivel9, nivel10, nivel11, trcurrencyid, trdate, trclientid, trorgid) zz GROUP BY nivel1, nivel2, nivel3, nivel4, nivel5, nivel6, nivel7, nivel8, nivel9, nivel10, nivel11 ORDER BY nivel1;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jul 13	10	3	3s874ms	1s291ms
	13	10	19s750ms	1s975ms

[ User: tad - Total duration: 23s624ms - Times executed: 13 ]

[ Application: openbravo - Total duration: 23s624ms - Times executed: 13 ]

SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2019') AND C_ORDER.DATEORDERED < to_date ('01-01-2020')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1;
SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2018') AND C_ORDER.DATEORDERED < to_date ('01-01-2019')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1;
SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM (LINENETAMT) AS AMOUNT, SUM (QTYORDERED) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (QTYORDEREDREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, '102', to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN (WSYMBOL) AS WSYMBOL FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('C_Bpartner'), to_char (C_BPARTNER.C_BPARTNER_ID), to_char ('es_ES'))) AS NIVEL1, to_char ('') AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, to_char ('') AS NIVEL10, to_char ('') AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE (C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, ( SELECT uomsymbol FROM c_uom WHERE c_uom_id = aci.c_uom_weight_id) AS WSYMBOL FROM C_ORDER LEFT JOIN ad_clientinfo aci ON aci.ad_client_id = c_order.ad_client_id LEFT JOIN AD_USER ON C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = 'Y' AND C_ORDER.PROCESSED = 'Y' AND C_ORDER.DOCSTATUS NOT IN ('CJ', 'UE', 'CA') AND 0 = 0 AND C_ORDER.AD_ORG_ID IN ('1000002') AND C_ORDER.AD_CLIENT_ID IN ('0', '1000001') AND 1 = 1 AND C_ORDER.DATEORDERED >= to_date ('01-01-2021') AND C_ORDER.DATEORDERED < to_date ('01-01-2022')) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1;

3

1s289ms

1

Details

1s289ms

SELECT td0.ad_user_id AS id, (COALESCE (to_char (COALESCE (to_char (td0.name), '')), '')) AS name, '' AS description FROM ad_user td0 WHERE td0.ad_client_id IN (...) AND td0.ad_org_id IN (...) AND (EXISTS ( SELECT ad_user_id FROM ad_user LEFT JOIN c_bpartner ON td0.c_bpartner_id = c_bpartner.c_bpartner_id WHERE c_bpartner.isemployee = '')) AND (td0.isactive = '' OR td0.ad_user_id = (NULL)) ORDER BY 0 LIMIT 0 OFFSET 0;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jul 13	10	1	1s289ms	1s289ms

[ User: tad - Total duration: 1s289ms - Times executed: 1 ]

[ Application: openbravo - Total duration: 1s289ms - Times executed: 1 ]

SELECT td0.AD_User_ID AS ID, (COALESCE (to_char (COALESCE (to_char (td0.Name), '')), '')) AS NAME, '' AS DESCRIPTION FROM AD_User td0 WHERE td0.AD_Client_ID IN ('0', '1000001') AND td0.AD_Org_ID IN ('0', '1000002') AND (EXISTS ( SELECT ad_user_id FROM ad_user LEFT JOIN c_bpartner ON td0.c_bpartner_id = c_bpartner.c_bpartner_id WHERE c_bpartner.isemployee = 'Y')) AND (td0.isActive = 'Y' OR td0.AD_User_ID = (NULL)) ORDER BY 2 LIMIT 1 OFFSET 0;

Log levels

Key values

31,985 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	3	0.01%
DETAIL	16	0.05%
ERROR	1	0.00%
FATAL	2,880	9.00%
LOG	29,082	90.92%
STATEMENT	3	0.01%

Events distribution

Key values

0 PANIC entries
2880 FATAL entries
2 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

2,880 Max number of times the same event was reported
2,882 Total events found

Rank

Times reported

Error

1

2,880

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jul 13	07	192
	08	192
	09	192
	10	192
	11	192
	12	192
	13	192
	14	192
	15	192
	16	192
	17	192
	18	192
	19	192
	20	192
	21	192

FATAL: database "openbravo" does not exist

2

1

Details

LOG: process ... still waiting for ShareLock on transaction ... after ... ms

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jul 13	20	1

LOG: process 28381 still waiting for ShareLock on transaction 12677502 after 1000.063 ms

3

1

Details

ERROR: @20206@

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jul 13	10	1

ERROR: @20206@

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoint write buffers (5 minutes period)

Checkpoints Wal files

Key values

Checkpoint Wal files usage (5 minutes period)

Checkpoints distance

Key values

Checkpoint mean distance and estimate (5 minutes period)

Checkpoints Activity

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Autovacuum Activity

Locks

Locks by types

Key values

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values

Duration by user