pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Thu Jul 16 20:00:08 2026
Log file: /var/log/postgresql/postgresql-12-main.log
Parsed 61,411 log entries in 7s
Log start from 2026-07-16 07:00:01 to 2026-07-16 20:00:07

Global Stats

35 Number of unique normalized queries
467 Number of queries
38m1s Total query duration
2026-07-16 07:00:03 First query
2026-07-16 20:00:03 Last query
2 queries/s at 2026-07-16 09:00:04 Query peak

38m1s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
38m1s Execute total duration

0 Number of events
0 Number of unique normalized events
0 Max number of times the same event was reported
0 Number of cancellation

165 Total number of automatic vacuums
208 Total number of automatic analyzes

439 Number temporary file
453.77 MiB Max size of temporary file
55.94 MiB Average size of temporary file

8,999 Total number of sessions
5 sessions at 2026-07-16 09:00:02 Session peak
1d18h52m43s Total duration of sessions
17s153ms Average duration of sessions
0 Average queries per session
253ms Average queries duration per session

8,997 Total number of connections
9 connections/s at 2026-07-16 15:15:27 Connection peak
1 Total number of databases

SQL Traffic

Key values

2 queries/s Query Peak
2026-07-16 09:00:04 Date

SELECT Traffic

Key values

0 queries/s Query Peak
Date

INSERT/UPDATE/DELETE Traffic

Key values

2 queries/s Query Peak
2026-07-16 13:00:03 Date

Queries duration

Key values

38m1s Total query duration

Prepared queries ratio

Key values

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

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 16	07	53	0ms	49s947ms	6s56ms	12s860ms	46s544ms	1m9s
	08	39	0ms	10s121ms	4s452ms	11s866ms	15s301ms	23s825ms
	09	35	0ms	8s560ms	4s104ms	10s711ms	12s40ms	23s493ms
	10	37	0ms	1m12s	6s719ms	11s698ms	16s591ms	1m12s
	11	38	0ms	1m6s	6s408ms	11s483ms	14s34ms	1m39s
	12	33	0ms	6s691ms	4s20ms	10s272ms	11s865ms	14s841ms
	13	33	0ms	8s948ms	4s79ms	10s198ms	11s716ms	19s984ms
	14	38	0ms	1m14s	6s801ms	10s809ms	14s682ms	1m14s
	15	35	0ms	7s786ms	4s78ms	10s510ms	11s24ms	26s188ms
	16	31	0ms	6s915ms	3s958ms	10s440ms	11s583ms	15s669ms
	17	31	0ms	5s697ms	3s839ms	10s385ms	10s518ms	14s207ms
	18	31	0ms	6s8ms	3s717ms	10s214ms	10s894ms	13s933ms
	19	31	0ms	6s683ms	3s876ms	10s393ms	11s515ms	14s367ms
	20	2	2s375ms	3s257ms	2s816ms	5s633ms	5s633ms	5s633ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 16	07	19	4s16ms	4s259ms	6s522ms	7s749ms
	08	27	4s420ms	4s286ms	8s44ms	18s580ms
	09	21	4s191ms	4s193ms	6s572ms	12s40ms
	10	25	7s860ms	4s437ms	7s12ms	37s708ms
	11	26	7s285ms	4s444ms	6s815ms	14s787ms
	12	21	3s808ms	4s316ms	6s617ms	9s361ms
	13	21	3s945ms	4s235ms	6s411ms	9s576ms
	14	26	7s986ms	4s939ms	6s547ms	51s630ms
	15	23	3s924ms	4s267ms	6s582ms	10s308ms
	16	19	3s694ms	4s126ms	6s497ms	7s154ms
	17	19	3s570ms	4s34ms	6s490ms	7s21ms
	18	19	3s494ms	3s989ms	6s331ms	6s523ms
	19	19	3s608ms	4s106ms	6s308ms	7s40ms
	20	2	2s816ms	5s633ms	5s633ms	5s633ms

Day	Hour	UPDATE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 16	07	12	4s994ms	0ms	3s954ms	5s110ms
	08	12	4s525ms	0ms	3s937ms	4s965ms
	09	12	4s362ms	0ms	3s965ms	4s722ms
	10	12	4s343ms	0ms	3s925ms	4s766ms
	11	12	4s508ms	0ms	3s879ms	4s909ms
	12	12	4s391ms	0ms	3s915ms	4s913ms
	13	12	4s315ms	0ms	3s928ms	4s797ms
	14	12	4s232ms	0ms	3s926ms	4s466ms
	15	12	4s373ms	0ms	3s853ms	4s862ms
	16	12	4s377ms	0ms	3s873ms	4s873ms
	17	12	4s265ms	0ms	3s894ms	4s675ms
	18	12	4s71ms	0ms	3s823ms	4s250ms
	19	12	4s301ms	0ms	3s946ms	4s649ms
	20	0	0ms	0ms	0ms	0ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
Jul 16	07	30	30.00	0.00%
	08	38	38.00	0.00%
	09	34	34.00	0.00%
	10	36	36.00	0.00%
	11	37	37.00	0.00%
	12	32	32.00	0.00%
	13	32	32.00	0.00%
	14	37	37.00	0.00%
	15	34	34.00	0.00%
	16	30	30.00	0.00%
	17	30	30.00	0.00%
	18	30	30.00	0.00%
	19	30	30.00	0.00%
	20	1	1.00	0.00%

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

Day	Hour	Count	Average Duration
Jul 16	07	700	21s548ms
	08	699	8s137ms
	09	701	48s709ms
	10	697	19ms
	11	699	1m56s
	12	698	2s845ms
	13	697	20ms
	14	697	19ms
	15	697	19ms
	16	698	22s617ms
	17	667	18ms
	18	667	18ms
	19	667	18ms
	20	15	313ms

↑ Back to the top of the General Activity table

Established Connections

Key values

9 connections Connection Peak
2026-07-16 15:15:27 Date

Connections per database

Key values

openbravo Main Database
8,997 connections Total

Chart
Table

Database	User	Count
openbravo		5,229
	postgres	2,552
	tad	2,677
postgres		14
	postgres	14
template1		3,754
	postgres	3,754

Connections per user

Key values

postgres Main User
8,997 connections Total

Chart
Table

User	Count
postgres	6,320
tad	2,677

Connections per host

Key values

[local] Main host with 6320 connections
8,997 Total connections

Chart
Table

Host	Count
127.0.0.1	2,677
[local]	6,320

Simultaneous sessions

Key values

5 sessions Session Peak
2026-07-16 09:00:02 Date

Histogram of session times

Key values

8,953 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	8,953	99.49%
500ms-1s	9	0.10%
1s-30s	24	0.27%
30s-1m	0	0.00%
1m-10m	5	0.06%
10m-30m	0	0.00%
30m-1h	2	0.02%
1h-8h	3	0.03%
> 8h	3	0.03%

Sessions per database

Key values

openbravo Main Database
8,999 sessions Total

Chart
Table

Database	User	Count	Total Duration
openbravo	5,231	1d18h51m57s	29s500ms
postgres	14	1s261ms	90ms
template1	3,754	44s595ms	11ms

Sessions per user

Key values

postgres Main User
8,999 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
postgres	6,320	2m12s
tad	2,679	1d18h50m30s

Sessions per host

Key values

[local] Main Host
8,999 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	2,679	1d18h50m30s	57s570ms
[local]	6,320	2m12s	20ms

Sessions per application

Key values

[unknown] Main Host
8,999 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
[unknown]	6,250	1m22s	13ms
openbravo	12	1d18h46m18s	3h33m51s
pg_dump	1	3m21s	3m21s
pg_profile	42	23s758ms	565ms
psql	2,694	1m16s	28ms

Checkpoints Buffers

Key values

10,557 buffers Checkpoint Peak
2026-07-16 09:08:01 Date
269.817 seconds Highest write time
0.026 seconds Sync time

Checkpoints Wal files

Key values

0 files Wal files usage Peak
2026-07-16 10:06:03 Date

Checkpoints distance

Key values

157.76 Mo Distance Peak
2026-07-16 09:08:01 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jul 16	07	2,537	255.768s	0.016s	255.838s
	08	4,000	402.104s	0.047s	402.205s
	09	13,997	615.675s	0.029s	615.788s
	10	7,326	709.324s	0.034s	709.417s
	11	3,953	398.168s	0.024s	398.253s
	12	6,389	642.417s	0.025s	642.494s
	13	5,084	513.528s	0.033s	513.625s
	14	8,347	841.217s	0.041s	841.309s
	15	5,588	561.114s	0.025s	561.186s
	16	6,860	690.583s	0.042s	690.69s
	17	2,031	207.577s	0.015s	207.644s
	18	2,232	224.563s	0.013s	224.632s
	19	1,677	169.349s	0.014s	169.419s
	20	0	0s	0s	0s

Day	Hour	Removed	Synced files	Longest sync	Average sync
Jul 16	07	1	240	0.003s	0.012s
	08	1	961	0.003s	0.012s
	09	7	1,546	0.002s	0.012s
	10	3	1,472	0.002s	0.012s
	11	2	1,230	0.002s	0.012s
	12	3	1,926	0.002s	0.012s
	13	2	1,826	0.002s	0.012s
	14	4	1,649	0.002s	0.012s
	15	2	1,622	0.002s	0.011s
	16	3	1,907	0.002s	0.013s
	17	1	234	0.002s	0.011s
	18	1	216	0.001s	0.012s
	19	1	202	0.002s	0.012s
	20	0	0	0s	0s

Day	Hour	Avg time (sec)
Jul 16	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

Day	Hour	Mean distance	Mean estimate
Jul 16	07	1,350.58 kB	7,194.75 kB
	08	2,461.58 kB	7,897.92 kB
	09	8,700.25 kB	49,270.42 kB
	10	4,628.25 kB	17,886.50 kB
	11	2,357.17 kB	9,393.08 kB
	12	3,701.83 kB	9,644.75 kB
	13	2,954.17 kB	8,357.83 kB
	14	5,049.42 kB	9,788.83 kB
	15	3,504.27 kB	10,475.64 kB
	16	3,681.85 kB	10,739.38 kB
	17	1,452.55 kB	8,658.91 kB
	18	1,421.83 kB	7,699.42 kB
	19	1,056.00 kB	6,763.83 kB
	20	0.00 kB	0.00 kB

↑ Back to the top of the Checkpoint Activity table

Size of temporary files

Key values

453.77 MiB Temp Files size Peak
2026-07-16 14:40:18 Date

Number of temporary files

Key values

8 per second Temp Files Peak
2026-07-16 11:35:45 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jul 16	07	24	1.38 GiB	58.91 MiB
	08	27	1.43 GiB	54.18 MiB
	09	25	1.40 GiB	57.21 MiB
	10	63	3.34 GiB	54.26 MiB
	11	64	3.35 GiB	53.67 MiB
	12	25	1.40 GiB	57.21 MiB
	13	25	1.40 GiB	57.21 MiB
	14	64	3.35 GiB	53.67 MiB
	15	26	1.41 GiB	55.65 MiB
	16	24	1.38 GiB	58.92 MiB
	17	24	1.38 GiB	58.92 MiB
	18	24	1.38 GiB	58.92 MiB
	19	24	1.38 GiB	58.92 MiB
	20	0	0	0

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	64	2.40 GiB	11.09 MiB	453.77 MiB	38.33 MiB	select organizati9_.name as col_0_0_, organizati9_.ad_org_id as col_1_0_, businesspa6_.c_bpartner_id as col_2_0_, businesspa6_.name as col_3_0_, sum(orderline3_.qtyordered) as col_4_0_, round(sum(orderline3_.qtyordered * (orderline3_.grosspricelist - orderline3_.gross_unit_price)), ?) as col_5_0_, case when round(sum(orderline3_.qtyordered * (orderline3_.grosspricelist - orderline3_.gross_unit_price)), ?) = ? then ? else case when sum(orderline3_.grosspricelist) = ? then ? else round(sum(orderline3_.grosspricelist - orderline3_.gross_unit_price) / sum(orderline3_.grosspricelist) * ?, ?) end end as col_6_0_, round(sum(orderline3_.linenetamt + ( select sum(orderlinet10_.taxamt) from c_orderlinetax orderlinet10_ where orderlinet10_.c_orderline_id = orderline3_.c_orderline_id)), ?) as col_7_0_, round(sum(transactio0_.cost), ?) as col_8_0_, case when round(sum(transactio0_.cost), ?) > ? then round(sum(orderline3_.linenetamt + ( select sum(orderlinet11_.taxamt) from c_orderlinetax orderlinet11_ where orderlinet11_.c_orderline_id = orderline3_.c_orderline_id)) / sum(transactio0_.cost), ?) else null end as col_9_0_, round(sum(orderline3_.linenetamt + ( select sum(orderlinet12_.taxamt) from c_orderlinetax orderlinet12_ where orderlinet12_.c_orderline_id = orderline3_.c_orderline_id) - transactio0_.cost), ?) as col_10_0_, round(sum(orderline3_.linenetamt + ( select sum(orderlinet13_.taxamt) from c_orderlinetax orderlinet13_ where orderlinet13_.c_orderline_id = orderline3_.c_orderline_id) - transactio0_.cost) / sum(orderline3_.linenetamt + ( select sum(orderlinet14_.taxamt) from c_orderlinetax orderlinet14_ where orderlinet14_.c_orderline_id = orderline3_.c_orderline_id)) * ?, ?) as col_11_0_ from m_transaction_cost transactio0_ inner join m_transaction materialmg1_ on transactio0_.m_transaction_id = materialmg1_.m_transaction_id right outer join m_inoutline materialmg2_ on materialmg1_.m_inoutline_id = materialmg2_.m_inoutline_id left outer join c_orderline orderline3_ on materialmg2_.c_orderline_id = orderline3_.c_orderline_id left outer join m_product product4_ on orderline3_.m_product_id = product4_.m_product_id left outer join c_order order5_ on orderline3_.c_order_id = order5_.c_order_id left outer join c_bpartner businesspa6_ on order5_.c_bpartner_id = businesspa6_.c_bpartner_id left outer join m_product_category productcat7_ on product4_.m_product_category_id = productcat7_.m_product_category_id left outer join obpos_applications obpos_appl8_ on order5_.em_obpos_applications_id = obpos_appl8_.obpos_applications_id left outer join ad_org organizati9_ on order5_.ad_org_id = organizati9_.ad_org_id where order5_.issotrx = ? and order5_.docstatus = ? and obpos_appl8_.ad_client_id = ? and (obpos_appl8_.ad_org_id in (...)) and order5_.created > to_date(?, ?) and order5_.created & lt; to_date(?, ?) and ? = ? group by organizati9_.name, organizati9_.ad_org_id, businesspa6_.name, businesspa6_.c_bpartner_id order by col_7_0_ desc, col_4_0_ desc, organizati9_.name, businesspa6_.name limit ?; select organizati9_.Name as col_0_0_, organizati9_.AD_Org_ID as col_1_0_, businesspa6_.C_BPartner_ID as col_2_0_, businesspa6_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet14_.Taxamt) from C_OrderLineTax orderlinet14_ where orderlinet14_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join C_BPartner businesspa6_ on order5_.C_BPartner_ID = businesspa6_.C_BPartner_ID left outer join M_Product_Category productcat7_ on product4_.M_Product_Category_ID = productcat7_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl8_ on order5_.EM_Obpos_Applications_ID = obpos_appl8_.Obpos_Applications_ID left outer join AD_Org organizati9_ on order5_.AD_Org_ID = organizati9_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl8_.AD_Client_ID = 'F1F033983E8740EC81BE7129A38DC0A2' and (obpos_appl8_.AD_Org_ID in ('0', 'A22222CD0A46452CA481F8F5CE47ABA3')) and order5_.Created > to_date('2021-01-01 00:00:00-03', 'YYYY-MM-DD') and order5_.Created & lt; to_date('2998-12-31 00:00:00-03', 'YYYY-MM-DD') and 1 = 1 group by organizati9_.Name, organizati9_.AD_Org_ID, businesspa6_.Name, businesspa6_.C_BPartner_ID order by col_7_0_ desc, col_4_0_ desc, organizati9_.Name, businesspa6_.Name limit '20'; Date: 2026-07-16 14:40:51 Duration: 43s744ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo select organizati9_.Name as col_0_0_, organizati9_.AD_Org_ID as col_1_0_, businesspa6_.C_BPartner_ID as col_2_0_, businesspa6_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet14_.Taxamt) from C_OrderLineTax orderlinet14_ where orderlinet14_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join C_BPartner businesspa6_ on order5_.C_BPartner_ID = businesspa6_.C_BPartner_ID left outer join M_Product_Category productcat7_ on product4_.M_Product_Category_ID = productcat7_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl8_ on order5_.EM_Obpos_Applications_ID = obpos_appl8_.Obpos_Applications_ID left outer join AD_Org organizati9_ on order5_.AD_Org_ID = organizati9_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl8_.AD_Client_ID = 'F1F033983E8740EC81BE7129A38DC0A2' and (obpos_appl8_.AD_Org_ID in ('0', 'A22222CD0A46452CA481F8F5CE47ABA3')) and order5_.Created > to_date('2021-01-01 00:00:00-03', 'YYYY-MM-DD') and order5_.Created & lt; to_date('2998-12-31 00:00:00-03', 'YYYY-MM-DD') and 1 = 1 group by organizati9_.Name, organizati9_.AD_Org_ID, businesspa6_.Name, businesspa6_.C_BPartner_ID order by col_7_0_ desc, col_4_0_ desc, organizati9_.Name, businesspa6_.Name limit '20'; Date: 2026-07-16 10:26:26 Duration: 37s708ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo select organizati9_.Name as col_0_0_, organizati9_.AD_Org_ID as col_1_0_, businesspa6_.C_BPartner_ID as col_2_0_, businesspa6_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet14_.Taxamt) from C_OrderLineTax orderlinet14_ where orderlinet14_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join C_BPartner businesspa6_ on order5_.C_BPartner_ID = businesspa6_.C_BPartner_ID left outer join M_Product_Category productcat7_ on product4_.M_Product_Category_ID = productcat7_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl8_ on order5_.EM_Obpos_Applications_ID = obpos_appl8_.Obpos_Applications_ID left outer join AD_Org organizati9_ on order5_.AD_Org_ID = organizati9_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl8_.AD_Client_ID = 'F1F033983E8740EC81BE7129A38DC0A2' and (obpos_appl8_.AD_Org_ID in ('0', 'A22222CD0A46452CA481F8F5CE47ABA3')) and order5_.Created > to_date('2021-01-01 00:00:00-03', 'YYYY-MM-DD') and order5_.Created & lt; to_date('2998-12-31 00:00:00-03', 'YYYY-MM-DD') and 1 = 1 group by organizati9_.Name, organizati9_.AD_Org_ID, businesspa6_.Name, businesspa6_.C_BPartner_ID order by col_7_0_ desc, col_4_0_ desc, organizati9_.Name, businesspa6_.Name limit '20'; Date: 2026-07-16 11:36:06 Duration: 33s542ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo
2	63	3.64 GiB	10.51 MiB	258.71 MiB	59.11 MiB	select organizati8_.name as col_0_0_, organizati8_.ad_org_id as col_1_0_, product4_.m_product_id as col_2_0_, product4_.name as col_3_0_, sum(orderline3_.qtyordered) as col_4_0_, round(sum(orderline3_.qtyordered * (orderline3_.grosspricelist - orderline3_.gross_unit_price)), ?) as col_5_0_, case when round(sum(orderline3_.qtyordered * (orderline3_.grosspricelist - orderline3_.gross_unit_price)), ?) = ? then ? else case when sum(orderline3_.grosspricelist) = ? then ? else round(sum(orderline3_.grosspricelist - orderline3_.gross_unit_price) / sum(orderline3_.grosspricelist) * ?, ?) end end as col_6_0_, round(sum(orderline3_.linenetamt + ( select sum(orderlinet9_.taxamt) from c_orderlinetax orderlinet9_ where orderlinet9_.c_orderline_id = orderline3_.c_orderline_id)), ?) as col_7_0_, round(sum(transactio0_.cost), ?) as col_8_0_, case when round(sum(transactio0_.cost), ?) > ? then round(sum(orderline3_.linenetamt + ( select sum(orderlinet10_.taxamt) from c_orderlinetax orderlinet10_ where orderlinet10_.c_orderline_id = orderline3_.c_orderline_id)) / sum(transactio0_.cost), ?) else null end as col_9_0_, round(sum(orderline3_.linenetamt + ( select sum(orderlinet11_.taxamt) from c_orderlinetax orderlinet11_ where orderlinet11_.c_orderline_id = orderline3_.c_orderline_id) - transactio0_.cost), ?) as col_10_0_, round(sum(orderline3_.linenetamt + ( select sum(orderlinet12_.taxamt) from c_orderlinetax orderlinet12_ where orderlinet12_.c_orderline_id = orderline3_.c_orderline_id) - transactio0_.cost) / sum(orderline3_.linenetamt + ( select sum(orderlinet13_.taxamt) from c_orderlinetax orderlinet13_ where orderlinet13_.c_orderline_id = orderline3_.c_orderline_id)) * ?, ?) as col_11_0_ from m_transaction_cost transactio0_ inner join m_transaction materialmg1_ on transactio0_.m_transaction_id = materialmg1_.m_transaction_id right outer join m_inoutline materialmg2_ on materialmg1_.m_inoutline_id = materialmg2_.m_inoutline_id left outer join c_orderline orderline3_ on materialmg2_.c_orderline_id = orderline3_.c_orderline_id left outer join m_product product4_ on orderline3_.m_product_id = product4_.m_product_id left outer join c_order order5_ on orderline3_.c_order_id = order5_.c_order_id left outer join m_product_category productcat6_ on product4_.m_product_category_id = productcat6_.m_product_category_id left outer join obpos_applications obpos_appl7_ on order5_.em_obpos_applications_id = obpos_appl7_.obpos_applications_id left outer join ad_org organizati8_ on order5_.ad_org_id = organizati8_.ad_org_id where order5_.issotrx = ? and order5_.docstatus = ? and obpos_appl7_.ad_client_id = ? and (obpos_appl7_.ad_org_id in (...)) and order5_.created > to_date(?, ?) and order5_.created & lt; to_date(?, ?) and ? = ? group by organizati8_.name, organizati8_.ad_org_id, product4_.name, product4_.m_product_id order by col_7_0_ desc, col_4_0_ desc, organizati8_.name, product4_.name limit ?; select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = 'F1F033983E8740EC81BE7129A38DC0A2' and (obpos_appl7_.AD_Org_ID in ('0', 'A22222CD0A46452CA481F8F5CE47ABA3')) and order5_.Created > to_date('1900-01-01 00:00:00-03:50:40', 'YYYY-MM-DD') and order5_.Created & lt; to_date('2999-01-01 00:00:00-03', 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit '30'; Date: 2026-07-16 14:41:22 Duration: 1m14s Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = 'F1F033983E8740EC81BE7129A38DC0A2' and (obpos_appl7_.AD_Org_ID in ('0', 'A22222CD0A46452CA481F8F5CE47ABA3')) and order5_.Created > to_date('1900-01-01 00:00:00-03:50:40', 'YYYY-MM-DD') and order5_.Created & lt; to_date('2999-01-01 00:00:00-03', 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit '30'; Date: 2026-07-16 10:27:01 Duration: 1m12s Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = 'F1F033983E8740EC81BE7129A38DC0A2' and (obpos_appl7_.AD_Org_ID in ('0', 'A22222CD0A46452CA481F8F5CE47ABA3')) and order5_.Created > to_date('1900-01-01 00:00:00-03:50:40', 'YYYY-MM-DD') and order5_.Created & lt; to_date('2999-01-01 00:00:00-03', 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit '30'; Date: 2026-07-16 11:36:39 Duration: 1m6s Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo
3	156	8.98 GiB	58.91 MiB	58.92 MiB	58.92 MiB	update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select f.c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? \|\| f.documentno \|\| ? as description, ? as isactive, f.ad_org_id, f.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, f.c_invoice_id, ?) as record_id from ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = ? and co.em_obpos_applications_id is not null group by ci.documentno, extract(year from dateinvoiced), ci.c_doctype_id having count(ci.documentno) > ? order by max(dateinvoiced) desc) as f) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id); UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '463465B5BE664902A40F05E84E1587CD' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' \|\| f.documentno \|\| ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); Date: 2026-07-16 07:05:15 Duration: 9s344ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '463465B5BE664902A40F05E84E1587CD' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' \|\| f.documentno \|\| ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); Date: 2026-07-16 07:00:14 Duration: 6s100ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '463465B5BE664902A40F05E84E1587CD' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' \|\| f.documentno \|\| ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); Date: 2026-07-16 09:30:10 Duration: 5s401ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo
4	156	8.98 GiB	58.91 MiB	58.92 MiB	58.92 MiB	select * from ( select f.c_invoice_id as referencekey_id, ; SELECT * FROM ( select f.c_invoice_id as referencekey_id, ; Date: 2026-07-16 07:00:08 Duration: 0ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo

Queries generating the largest temporary files


[ Date: 2026-07-16 14:40:18 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 11:35:41 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 10:25:59 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 14:41:23 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 10:27:01 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 11:36:39 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 14:40:23 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 11:35:45 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 10:26:03 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 14:40:28 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 10:26:07 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 11:35:48 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 14:40:25 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 11:35:46 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 10:26:05 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 14:40:52 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 11:36:06 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 10:26:26 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 13:45:04 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 13:45:08 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

Rank	Size	Query
1	453.77 MiB	select organizati9_.Name as col_0_0_, organizati9_.AD_Org_ID as col_1_0_, businesspa6_.C_BPartner_ID as col_2_0_, businesspa6_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet14_.Taxamt) from C_OrderLineTax orderlinet14_ where orderlinet14_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join C_BPartner businesspa6_ on order5_.C_BPartner_ID = businesspa6_.C_BPartner_ID left outer join M_Product_Category productcat7_ on product4_.M_Product_Category_ID = productcat7_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl8_ on order5_.EM_Obpos_Applications_ID = obpos_appl8_.Obpos_Applications_ID left outer join AD_Org organizati9_ on order5_.AD_Org_ID = organizati9_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl8_.AD_Client_ID = $1 and (obpos_appl8_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati9_.Name, organizati9_.AD_Org_ID, businesspa6_.Name, businesspa6_.C_BPartner_ID order by col_7_0_ desc, col_4_0_ desc, organizati9_.Name, businesspa6_.Name limit $6; [ Date: 2026-07-16 14:40:18 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2	453.74 MiB	select organizati9_.Name as col_0_0_, organizati9_.AD_Org_ID as col_1_0_, businesspa6_.C_BPartner_ID as col_2_0_, businesspa6_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet14_.Taxamt) from C_OrderLineTax orderlinet14_ where orderlinet14_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join C_BPartner businesspa6_ on order5_.C_BPartner_ID = businesspa6_.C_BPartner_ID left outer join M_Product_Category productcat7_ on product4_.M_Product_Category_ID = productcat7_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl8_ on order5_.EM_Obpos_Applications_ID = obpos_appl8_.Obpos_Applications_ID left outer join AD_Org organizati9_ on order5_.AD_Org_ID = organizati9_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl8_.AD_Client_ID = $1 and (obpos_appl8_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati9_.Name, organizati9_.AD_Org_ID, businesspa6_.Name, businesspa6_.C_BPartner_ID order by col_7_0_ desc, col_4_0_ desc, organizati9_.Name, businesspa6_.Name limit $6; [ Date: 2026-07-16 11:35:41 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3	453.72 MiB	select organizati9_.Name as col_0_0_, organizati9_.AD_Org_ID as col_1_0_, businesspa6_.C_BPartner_ID as col_2_0_, businesspa6_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet14_.Taxamt) from C_OrderLineTax orderlinet14_ where orderlinet14_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join C_BPartner businesspa6_ on order5_.C_BPartner_ID = businesspa6_.C_BPartner_ID left outer join M_Product_Category productcat7_ on product4_.M_Product_Category_ID = productcat7_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl8_ on order5_.EM_Obpos_Applications_ID = obpos_appl8_.Obpos_Applications_ID left outer join AD_Org organizati9_ on order5_.AD_Org_ID = organizati9_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl8_.AD_Client_ID = $1 and (obpos_appl8_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati9_.Name, organizati9_.AD_Org_ID, businesspa6_.Name, businesspa6_.C_BPartner_ID order by col_7_0_ desc, col_4_0_ desc, organizati9_.Name, businesspa6_.Name limit $6; [ Date: 2026-07-16 10:25:59 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4	258.71 MiB	select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = $1 and (obpos_appl7_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit $6; [ Date: 2026-07-16 14:41:23 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5	258.70 MiB	select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = $1 and (obpos_appl7_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit $6; [ Date: 2026-07-16 10:27:01 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
6	258.70 MiB	select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = $1 and (obpos_appl7_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit $6; [ Date: 2026-07-16 11:36:39 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
7	228.25 MiB	select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = $1 and (obpos_appl7_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit $6; [ Date: 2026-07-16 14:40:23 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8	228.25 MiB	select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = $1 and (obpos_appl7_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit $6; [ Date: 2026-07-16 11:35:45 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
9	228.24 MiB	select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = $1 and (obpos_appl7_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit $6; [ Date: 2026-07-16 10:26:03 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
10	226.63 MiB	select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = $1 and (obpos_appl7_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit $6; [ Date: 2026-07-16 14:40:28 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
11	226.61 MiB	select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = $1 and (obpos_appl7_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit $6; [ Date: 2026-07-16 10:26:07 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
12	226.61 MiB	select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = $1 and (obpos_appl7_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit $6; [ Date: 2026-07-16 11:35:48 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
13	225.88 MiB	select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = $1 and (obpos_appl7_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit $6; [ Date: 2026-07-16 14:40:25 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
14	225.83 MiB	select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = $1 and (obpos_appl7_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit $6; [ Date: 2026-07-16 11:35:46 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
15	225.82 MiB	select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = $1 and (obpos_appl7_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit $6; [ Date: 2026-07-16 10:26:05 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
16	93.29 MiB	select organizati9_.Name as col_0_0_, organizati9_.AD_Org_ID as col_1_0_, businesspa6_.C_BPartner_ID as col_2_0_, businesspa6_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet14_.Taxamt) from C_OrderLineTax orderlinet14_ where orderlinet14_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join C_BPartner businesspa6_ on order5_.C_BPartner_ID = businesspa6_.C_BPartner_ID left outer join M_Product_Category productcat7_ on product4_.M_Product_Category_ID = productcat7_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl8_ on order5_.EM_Obpos_Applications_ID = obpos_appl8_.Obpos_Applications_ID left outer join AD_Org organizati9_ on order5_.AD_Org_ID = organizati9_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl8_.AD_Client_ID = $1 and (obpos_appl8_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati9_.Name, organizati9_.AD_Org_ID, businesspa6_.Name, businesspa6_.C_BPartner_ID order by col_7_0_ desc, col_4_0_ desc, organizati9_.Name, businesspa6_.Name limit $6; [ Date: 2026-07-16 14:40:52 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
17	93.28 MiB	select organizati9_.Name as col_0_0_, organizati9_.AD_Org_ID as col_1_0_, businesspa6_.C_BPartner_ID as col_2_0_, businesspa6_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet14_.Taxamt) from C_OrderLineTax orderlinet14_ where orderlinet14_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join C_BPartner businesspa6_ on order5_.C_BPartner_ID = businesspa6_.C_BPartner_ID left outer join M_Product_Category productcat7_ on product4_.M_Product_Category_ID = productcat7_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl8_ on order5_.EM_Obpos_Applications_ID = obpos_appl8_.Obpos_Applications_ID left outer join AD_Org organizati9_ on order5_.AD_Org_ID = organizati9_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl8_.AD_Client_ID = $1 and (obpos_appl8_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati9_.Name, organizati9_.AD_Org_ID, businesspa6_.Name, businesspa6_.C_BPartner_ID order by col_7_0_ desc, col_4_0_ desc, organizati9_.Name, businesspa6_.Name limit $6; [ Date: 2026-07-16 11:36:06 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
18	93.27 MiB	select organizati9_.Name as col_0_0_, organizati9_.AD_Org_ID as col_1_0_, businesspa6_.C_BPartner_ID as col_2_0_, businesspa6_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet14_.Taxamt) from C_OrderLineTax orderlinet14_ where orderlinet14_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join C_BPartner businesspa6_ on order5_.C_BPartner_ID = businesspa6_.C_BPartner_ID left outer join M_Product_Category productcat7_ on product4_.M_Product_Category_ID = productcat7_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl8_ on order5_.EM_Obpos_Applications_ID = obpos_appl8_.Obpos_Applications_ID left outer join AD_Org organizati9_ on order5_.AD_Org_ID = organizati9_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl8_.AD_Client_ID = $1 and (obpos_appl8_.AD_Org_ID in ($2, $3)) and order5_.Created > to_date($4, 'YYYY-MM-DD') and order5_.Created & lt; to_date($5, 'YYYY-MM-DD') and 1 = 1 group by organizati9_.Name, organizati9_.AD_Org_ID, businesspa6_.Name, businesspa6_.C_BPartner_ID order by col_7_0_ desc, col_4_0_ desc, organizati9_.Name, businesspa6_.Name limit $6; [ Date: 2026-07-16 10:26:26 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
19	58.92 MiB	SELECT * FROM ( select f.c_invoice_id as referencekey_id, ; [ Date: 2026-07-16 13:45:04 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
20	58.92 MiB	UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' \|\| f.documentno \|\| ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-16 13:45:08 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

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_pinstance_para (39) Main table analyzed (database openbravo)
208 analyzes Total

Chart
Table

Table	Number of analyzes
openbravo.public.ad_pinstance_para	39
openbravo.public.c_import_entry	27
openbravo.public.ad_session	20
openbravo.profile.last_stat_indexes_srv1	13
openbravo.profile.last_stat_tables_srv1	13
openbravo.profile.last_stat_user_functions_srv1	13
openbravo.profile.last_stat_statements_srv1	13
openbravo.public.ad_process_request	8
openbravo.public.ad_pinstance	7
openbravo.public.prpres_conf	6
openbravo.profile.stmt_list	6
openbravo.profile.tables_list	5
openbravo.public.obpos_applications	5
openbravo.profile.funcs_list	4
openbravo.public.ad_ep_instance_para	4
openbravo.profile.indexes_list	4
openbravo.profile.last_stat_activity_count_srv1	3
openbravo.profile.last_extension_versions	3
openbravo.public.ad_sequence	2
openbravo.profile.sample_stat_tables	2
openbravo.profile.sample_stat_indexes	2
openbravo.profile.sample_statements	2
openbravo.profile.sample_stat_user_functions	2
openbravo.profile.sample_stat_tables_total	1
openbravo.public.fin_financial_account	1
openbravo.profile.sample_stat_indexes_total	1
openbravo.profile.sample_stat_database	1
openbravo.profile.sample_statements_total	1
Total	208

Vacuums per table

Key values

public.ad_pinstance_para (31) Main table vacuumed on database openbravo
165 vacuums Total

Chart
Table

Table	Number of vacuums	Index scans
openbravo.public.ad_pinstance_para	31	31
openbravo.profile.last_stat_indexes_srv1	21	13
openbravo.profile.last_stat_user_functions_srv1	21	13
openbravo.profile.last_stat_statements_srv1	21	13
openbravo.profile.last_stat_tables_srv1	21	13
openbravo.public.c_import_entry	13	13
openbravo.pg_toast.pg_toast_70826	8	8
openbravo.profile.stmt_list	5	5
openbravo.profile.funcs_list	4	4
openbravo.profile.tables_list	4	4
openbravo.profile.indexes_list	3	3
openbravo.public.ad_pinstance	3	3
openbravo.public.ad_ep_instance_para	3	3
openbravo.profile.last_stat_activity_count_srv1	2	0
openbravo.profile.last_extension_versions	2	2
openbravo.pg_toast.pg_toast_2619	1	1
openbravo.profile.last_stat_database_srv1	1	1
openbravo.pg_catalog.pg_statistic	1	1
Total	165	131

Tuples removed per table

Key values

profile.last_stat_indexes_srv1 (71965) Main table with removed tuples on database openbravo
144970 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
openbravo.profile.last_stat_indexes_srv1	21	13	71965	110
openbravo.profile.last_stat_tables_srv1	21	13	44305	0
openbravo.profile.last_stat_statements_srv1	21	13	14990	116
openbravo.profile.last_stat_user_functions_srv1	21	13	5187	5
openbravo.public.ad_pinstance_para	31	31	4321	57
openbravo.pg_catalog.pg_statistic	1	1	929	0
openbravo.public.c_import_entry	13	13	678	63
openbravo.pg_toast.pg_toast_70826	8	8	611	156
openbravo.profile.stmt_list	5	5	393	0
openbravo.public.ad_pinstance	3	3	354	0
openbravo.profile.tables_list	4	4	278	0
openbravo.public.ad_ep_instance_para	3	3	250	7
openbravo.pg_toast.pg_toast_2619	1	1	238	0
openbravo.profile.funcs_list	4	4	187	0
openbravo.profile.indexes_list	3	3	128	0
openbravo.profile.last_extension_versions	2	2	104	0
openbravo.profile.last_stat_activity_count_srv1	2	0	40	2
openbravo.profile.last_stat_database_srv1	1	1	12	0
Total	165	131	144,970	516

Pages removed per table

Key values

pg_toast.pg_toast_70826 (156) Main table with removed pages on database openbravo
516 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
openbravo.pg_toast.pg_toast_70826	8	8	611	156
openbravo.profile.last_stat_statements_srv1	21	13	14990	116
openbravo.profile.last_stat_indexes_srv1	21	13	71965	110
openbravo.public.c_import_entry	13	13	678	63
openbravo.public.ad_pinstance_para	31	31	4321	57
openbravo.public.ad_ep_instance_para	3	3	250	7
openbravo.profile.last_stat_user_functions_srv1	21	13	5187	5
openbravo.profile.last_stat_activity_count_srv1	2	0	40	2
openbravo.pg_toast.pg_toast_2619	1	1	238	0
openbravo.profile.stmt_list	5	5	393	0
openbravo.profile.last_extension_versions	2	2	104	0
openbravo.profile.funcs_list	4	4	187	0
openbravo.profile.last_stat_database_srv1	1	1	12	0
openbravo.profile.tables_list	4	4	278	0
openbravo.profile.last_stat_tables_srv1	21	13	44305	0
openbravo.profile.indexes_list	3	3	128	0
openbravo.public.ad_pinstance	3	3	354	0
openbravo.pg_catalog.pg_statistic	1	1	929	0
Total	165	131	144,970	516

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jul 16	07	31	5
	08	5	12
	09	16	22
	10	11	23
	11	9	14
	12	21	26
	13	13	14
	14	15	21
	15	13	25
	16	14	20
	17	6	10
	18	7	10
	19	4	6
	20	0	0

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

NO DATASET

Type	Object	Count	Total Duration	Average Duration (s)
NO DATASET

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
NO DATASET

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

287 Total read queries
156 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	287	61.46%
INSERT	0	0.00%
UPDATE	156	33.40%
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%
CURSOR	0	0.00%
OTHERS	24	5.14%

Queries by database

Key values

openbravo Main database
467 Requests
38m1s (openbravo)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
openbravo	Total	467	38m1s
	COPY	22	3m4s
	SELECT	287	23m28s
	UPDATE	156	11m24s
	others	2	3s301ms

Queries by user

Key values

tad Main user
453 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	14	25s682ms
	SELECT	14	25s682ms
tad	Total	453	37m36s
	COPY	22	3m4s
	SELECT	273	23m3s
	UPDATE	156	11m24s
	others	2	3s301ms

Duration by user

Key values

37m36s (tad) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	14	25s682ms
	SELECT	14	25s682ms
tad	Total	453	37m36s
	COPY	22	3m4s
	SELECT	273	23m3s
	UPDATE	156	11m24s
	others	2	3s301ms

Queries by host

Key values

127.0.0.1 Main host
453 Requests
37m36s (127.0.0.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	453	37m36s
	COPY	22	3m4s
	SELECT	273	23m3s
	UPDATE	156	11m24s
	others	2	3s301ms
[local]	Total	14	25s682ms
	SELECT	14	25s682ms

Queries by application

Key values

openbravo Main application
431 Requests
34m31s (openbravo)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
openbravo	Total	431	34m31s
	SELECT	273	23m3s
	UPDATE	156	11m24s
	others	2	3s301ms
pg_dump	Total	22	3m4s
	COPY	22	3m4s
psql	Total	14	25s682ms
	SELECT	14	25s682ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-07-16 09:28:46 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

454 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	454	97.22%
> 10000ms	13	2.78%

Slowest individual queries


[ Date: 2026-07-16 14:41:22 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 10:27:01 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 11:36:39 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 07:00:57 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2026-07-16 14:40:51 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 10:26:26 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 11:36:06 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 07:02:05 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2026-07-16 07:01:23 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2026-07-16 07:03:20 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2026-07-16 07:03:06 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2026-07-16 07:02:26 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2026-07-16 08:29:36 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 07:05:15 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 07:02:15 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2026-07-16 13:00:08 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 08:29:34 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 09:00:08 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 07:01:38 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2026-07-16 08:30:08 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

Rank	Duration	Query
1	1m14s	select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = 'F1F033983E8740EC81BE7129A38DC0A2' and (obpos_appl7_.AD_Org_ID in ('0', 'A22222CD0A46452CA481F8F5CE47ABA3')) and order5_.Created > to_date('1900-01-01 00:00:00-03:50:40', 'YYYY-MM-DD') and order5_.Created & lt; to_date('2999-01-01 00:00:00-03', 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit '30'; [ Date: 2026-07-16 14:41:22 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
2	1m12s	select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = 'F1F033983E8740EC81BE7129A38DC0A2' and (obpos_appl7_.AD_Org_ID in ('0', 'A22222CD0A46452CA481F8F5CE47ABA3')) and order5_.Created > to_date('1900-01-01 00:00:00-03:50:40', 'YYYY-MM-DD') and order5_.Created & lt; to_date('2999-01-01 00:00:00-03', 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit '30'; [ Date: 2026-07-16 10:27:01 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3	1m6s	select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = 'F1F033983E8740EC81BE7129A38DC0A2' and (obpos_appl7_.AD_Org_ID in ('0', 'A22222CD0A46452CA481F8F5CE47ABA3')) and order5_.Created > to_date('1900-01-01 00:00:00-03:50:40', 'YYYY-MM-DD') and order5_.Created & lt; to_date('2999-01-01 00:00:00-03', 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit '30'; [ Date: 2026-07-16 11:36:39 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
4	49s947ms	COPY public.ad_image (ad_image_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, name, imageurl, binarydata, width, height, mimetype) TO stdout; [ Date: 2026-07-16 07:00:57 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
5	43s744ms	select organizati9_.Name as col_0_0_, organizati9_.AD_Org_ID as col_1_0_, businesspa6_.C_BPartner_ID as col_2_0_, businesspa6_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet14_.Taxamt) from C_OrderLineTax orderlinet14_ where orderlinet14_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join C_BPartner businesspa6_ on order5_.C_BPartner_ID = businesspa6_.C_BPartner_ID left outer join M_Product_Category productcat7_ on product4_.M_Product_Category_ID = productcat7_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl8_ on order5_.EM_Obpos_Applications_ID = obpos_appl8_.Obpos_Applications_ID left outer join AD_Org organizati9_ on order5_.AD_Org_ID = organizati9_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl8_.AD_Client_ID = 'F1F033983E8740EC81BE7129A38DC0A2' and (obpos_appl8_.AD_Org_ID in ('0', 'A22222CD0A46452CA481F8F5CE47ABA3')) and order5_.Created > to_date('2021-01-01 00:00:00-03', 'YYYY-MM-DD') and order5_.Created & lt; to_date('2998-12-31 00:00:00-03', 'YYYY-MM-DD') and 1 = 1 group by organizati9_.Name, organizati9_.AD_Org_ID, businesspa6_.Name, businesspa6_.C_BPartner_ID order by col_7_0_ desc, col_4_0_ desc, organizati9_.Name, businesspa6_.Name limit '20'; [ Date: 2026-07-16 14:40:51 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
6	37s708ms	select organizati9_.Name as col_0_0_, organizati9_.AD_Org_ID as col_1_0_, businesspa6_.C_BPartner_ID as col_2_0_, businesspa6_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet14_.Taxamt) from C_OrderLineTax orderlinet14_ where orderlinet14_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join C_BPartner businesspa6_ on order5_.C_BPartner_ID = businesspa6_.C_BPartner_ID left outer join M_Product_Category productcat7_ on product4_.M_Product_Category_ID = productcat7_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl8_ on order5_.EM_Obpos_Applications_ID = obpos_appl8_.Obpos_Applications_ID left outer join AD_Org organizati9_ on order5_.AD_Org_ID = organizati9_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl8_.AD_Client_ID = 'F1F033983E8740EC81BE7129A38DC0A2' and (obpos_appl8_.AD_Org_ID in ('0', 'A22222CD0A46452CA481F8F5CE47ABA3')) and order5_.Created > to_date('2021-01-01 00:00:00-03', 'YYYY-MM-DD') and order5_.Created & lt; to_date('2998-12-31 00:00:00-03', 'YYYY-MM-DD') and 1 = 1 group by organizati9_.Name, organizati9_.AD_Org_ID, businesspa6_.Name, businesspa6_.C_BPartner_ID order by col_7_0_ desc, col_4_0_ desc, organizati9_.Name, businesspa6_.Name limit '20'; [ Date: 2026-07-16 10:26:26 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
7	33s542ms	select organizati9_.Name as col_0_0_, organizati9_.AD_Org_ID as col_1_0_, businesspa6_.C_BPartner_ID as col_2_0_, businesspa6_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet14_.Taxamt) from C_OrderLineTax orderlinet14_ where orderlinet14_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join C_BPartner businesspa6_ on order5_.C_BPartner_ID = businesspa6_.C_BPartner_ID left outer join M_Product_Category productcat7_ on product4_.M_Product_Category_ID = productcat7_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl8_ on order5_.EM_Obpos_Applications_ID = obpos_appl8_.Obpos_Applications_ID left outer join AD_Org organizati9_ on order5_.AD_Org_ID = organizati9_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl8_.AD_Client_ID = 'F1F033983E8740EC81BE7129A38DC0A2' and (obpos_appl8_.AD_Org_ID in ('0', 'A22222CD0A46452CA481F8F5CE47ABA3')) and order5_.Created > to_date('2021-01-01 00:00:00-03', 'YYYY-MM-DD') and order5_.Created & lt; to_date('2998-12-31 00:00:00-03', 'YYYY-MM-DD') and 1 = 1 group by organizati9_.Name, organizati9_.AD_Org_ID, businesspa6_.Name, businesspa6_.C_BPartner_ID order by col_7_0_ desc, col_4_0_ desc, organizati9_.Name, businesspa6_.Name limit '20'; [ Date: 2026-07-16 11:36:06 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
8	18s825ms	COPY public.c_orderline (c_orderline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_order_id, line, c_bpartner_id, c_bpartner_location_id, dateordered, datepromised, datedelivered, dateinvoiced, description, m_product_id, m_warehouse_id, directship, c_uom_id, qtyordered, qtyreserved, qtydelivered, qtyinvoiced, m_shipper_id, c_currency_id, pricelist, priceactual, pricelimit, linenetamt, discount, freightamt, c_charge_id, chargeamt, c_tax_id, s_resourceassignment_id, ref_orderline_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_offer_id, pricestd, cancelpricead, c_order_discount_id, iseditlinenetamt, taxbaseamt, m_inoutline_id, c_return_reason_id, gross_unit_price, line_gross_amount, grosspricelist, c_costcenter_id, grosspricestd, a_asset_id, m_warehouse_rule_id, user1_id, quotationline_id, user2_id, create_reservation, c_project_id, so_res_status, manage_reservation, manage_prereservation, explode, bom_parent_id, em_mntc_discount, print_description, overdue_return_days, relate_orderline, replacedorderline_id, c_aum, aumqty, returnline, em_obpos_epccode, em_obpos_serialnumber, em_obpos_isdeleted, em_obpos_service_proposed, em_obpos_qtydeleted, em_obpos_canbedelivered, em_obpos_ispaid, em_obpos_pricereason_id, em_obrdm_delivery_mode, em_obrdm_delivery_date, em_obrdm_delivery_time, em_obrdm_amttopayindelivery, em_obmfm_isfreightamt, em_obmfm_freight_definition_id, em_obwpl_readypl, salesrep_id, em_prpres_ps_line_id) TO stdout; [ Date: 2026-07-16 07:02:05 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
9	16s613ms	COPY public.c_invoiceline (c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoice_id, c_orderline_id, m_inoutline_id, line, description, financial_invoice_line, account_id, m_product_id, qtyinvoiced, pricelist, priceactual, pricelimit, linenetamt, c_charge_id, chargeamt, c_uom_id, c_tax_id, s_resourceassignment_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, c_invoice_discount_id, c_projectline_id, m_offer_id, pricestd, excludeforwithholding, iseditlinenetamt, taxbaseamt, line_gross_amount, gross_unit_price, c_bpartner_id, periodnumber, grosspricestd, a_asset_id, defplantype, grosspricelist, c_project_id, isdeferred, c_period_id, c_costcenter_id, user1_id, user2_id, explode, bom_parent_id, match_lccosts, c_aum, aumqty, salesrep_id) TO stdout; [ Date: 2026-07-16 07:01:23 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
10	12s214ms	COPY public.m_transaction (m_transaction_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, movementtype, m_locator_id, m_product_id, movementdate, movementqty, m_inventoryline_id, m_movementline_id, m_inoutline_id, m_productionline_id, c_projectissue_id, m_attributesetinstance_id, m_product_uom_id, quantityorder, c_uom_id, m_internal_consumptionline_id, transactioncost, trxprocessdate, m_costing_algorithm_id, iscostcalculated, c_currency_id, costing_status, checkreservedqty, isprocessed, checkpricedifference, manualcostadjustment, iscostpermanent) TO stdout; [ Date: 2026-07-16 07:03:20 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
11	12s97ms	COPY public.m_inoutline (m_inoutline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, line, description, m_inout_id, c_orderline_id, m_locator_id, m_product_id, c_uom_id, movementqty, isinvoiced, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_condition_goods_id, canceled_inoutline_id, a_asset_id, manage_prereservation, user1_id, user2_id, c_project_id, c_costcenter_id, c_bpartner_id, explode, bom_parent_id, c_aum, aumqty, em_obwpl_pickinglist_id, em_obwpl_editlines_pe, em_obwpl_removeline, em_prpp_qtyverified, salesrep_id) TO stdout; [ Date: 2026-07-16 07:03:06 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
12	10s810ms	COPY public.c_orderlinetax (c_orderlinetax_id, c_orderline_id, c_tax_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, c_order_id) TO stdout; [ Date: 2026-07-16 07:02:26 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
13	10s121ms	select organizati9_.Name as col_0_0_, organizati9_.AD_Org_ID as col_1_0_, businesspa6_.C_BPartner_ID as col_2_0_, businesspa6_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet14_.Taxamt) from C_OrderLineTax orderlinet14_ where orderlinet14_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join C_BPartner businesspa6_ on order5_.C_BPartner_ID = businesspa6_.C_BPartner_ID left outer join M_Product_Category productcat7_ on product4_.M_Product_Category_ID = productcat7_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl8_ on order5_.EM_Obpos_Applications_ID = obpos_appl8_.Obpos_Applications_ID left outer join AD_Org organizati9_ on order5_.AD_Org_ID = organizati9_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl8_.AD_Client_ID = 'F1F033983E8740EC81BE7129A38DC0A2' and (obpos_appl8_.AD_Org_ID in ('0', 'A22222CD0A46452CA481F8F5CE47ABA3')) and order5_.Created > to_date('2024-01-01 00:00:00-03', 'YYYY-MM-DD') and order5_.Created & lt; to_date('2025-01-01 00:00:00-03', 'YYYY-MM-DD') and 1 = 1 group by organizati9_.Name, organizati9_.AD_Org_ID, businesspa6_.Name, businesspa6_.C_BPartner_ID order by col_7_0_ desc, col_4_0_ desc, organizati9_.Name, businesspa6_.Name limit '50'; [ Date: 2026-07-16 08:29:36 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
14	9s344ms	UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '463465B5BE664902A40F05E84E1587CD' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' \|\| f.documentno \|\| ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-16 07:05:15 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
15	9s231ms	COPY public.c_orderline_offer (c_orderline_offer_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_orderline_id, line, m_offer_id, priceoffer, amtoffer, priceoffergross, totalamt, displayedtotalamt, em_obdisc_qtyoffer, em_obdisc_identifier, em_obpos_discountinstance, em_obpos_extraproperties) TO stdout; [ Date: 2026-07-16 07:02:15 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
16	8s948ms	SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' \|\| f.documentno \|\| ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date: 2026-07-16 13:00:08 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
17	8s582ms	select organizati8_.Name as col_0_0_, organizati8_.AD_Org_ID as col_1_0_, product4_.M_Product_ID as col_2_0_, product4_.Name as col_3_0_, sum(orderline3_.QtyOrdered) as col_4_0_, round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) as col_5_0_, case when round(sum(orderline3_.QtyOrdered * (orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price)), 2) = 0 then 0 else case when sum(orderline3_.GrossPriceList) = 0 then 100 else round(sum(orderline3_.GrossPriceList - orderline3_.Gross_Unit_Price) / sum(orderline3_.GrossPriceList) * 100, 2) end end as col_6_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet9_.Taxamt) from C_OrderLineTax orderlinet9_ where orderlinet9_.C_Orderline_ID = orderline3_.C_OrderLine_ID)), 2) as col_7_0_, round(sum(transactio0_.Cost), 2) as col_8_0_, case when round(sum(transactio0_.Cost), 2) > 0 then round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet10_.Taxamt) from C_OrderLineTax orderlinet10_ where orderlinet10_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) / sum(transactio0_.Cost), 2) else null end as col_9_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet11_.Taxamt) from C_OrderLineTax orderlinet11_ where orderlinet11_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost), 2) as col_10_0_, round(sum(orderline3_.LineNetAmt + ( select sum(orderlinet12_.Taxamt) from C_OrderLineTax orderlinet12_ where orderlinet12_.C_Orderline_ID = orderline3_.C_OrderLine_ID) - transactio0_.Cost) / sum(orderline3_.LineNetAmt + ( select sum(orderlinet13_.Taxamt) from C_OrderLineTax orderlinet13_ where orderlinet13_.C_Orderline_ID = orderline3_.C_OrderLine_ID)) * 100, 2) as col_11_0_ from M_Transaction_Cost transactio0_ inner join M_Transaction materialmg1_ on transactio0_.M_Transaction_ID = materialmg1_.M_Transaction_ID right outer join M_InOutLine materialmg2_ on materialmg1_.M_InOutLine_ID = materialmg2_.M_InOutLine_ID left outer join C_OrderLine orderline3_ on materialmg2_.C_OrderLine_ID = orderline3_.C_OrderLine_ID left outer join M_Product product4_ on orderline3_.M_Product_ID = product4_.M_Product_ID left outer join C_Order order5_ on orderline3_.C_Order_ID = order5_.C_Order_ID left outer join M_Product_Category productcat6_ on product4_.M_Product_Category_ID = productcat6_.M_Product_Category_ID left outer join OBPOS_APPLICATIONS obpos_appl7_ on order5_.EM_Obpos_Applications_ID = obpos_appl7_.Obpos_Applications_ID left outer join AD_Org organizati8_ on order5_.AD_Org_ID = organizati8_.AD_Org_ID where order5_.IsSOTrx = 'Y' and order5_.DocStatus = 'CO' and obpos_appl7_.AD_Client_ID = 'F1F033983E8740EC81BE7129A38DC0A2' and (obpos_appl7_.AD_Org_ID in ('0', 'A22222CD0A46452CA481F8F5CE47ABA3')) and order5_.Created > to_date('2026-01-01 00:00:00-03', 'YYYY-MM-DD') and order5_.Created & lt; to_date('2026-07-01 00:00:00-03', 'YYYY-MM-DD') and 1 = 1 group by organizati8_.Name, organizati8_.AD_Org_ID, product4_.Name, product4_.M_Product_ID order by col_7_0_ desc, col_4_0_ desc, organizati8_.Name, product4_.Name limit '50'; [ Date: 2026-07-16 08:29:34 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
18	8s560ms	SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' \|\| f.documentno \|\| ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date: 2026-07-16 09:00:08 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
19	8s293ms	COPY public.c_invoicelinetax (c_invoicelinetax_id, c_tax_id, c_invoice_id, c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, recalculate) TO stdout; [ Date: 2026-07-16 07:01:38 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
20	8s244ms	SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' \|\| f.documentno \|\| ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date: 2026-07-16 08:30:08 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

Time consuming queries


[ User: tad - Total duration: 12m26s - Times executed: 156 ]
[ User: tad - Total duration: 11m24s - Times executed: 156 ]
[ User: tad - Total duration: 4m29s - Times executed: 16 ]
[ User: tad - Total duration: 3m19s - Times executed: 16 ]
[ User: tad - Total duration: 2m38s - Times executed: 79 ]
[ User: tad - Total duration: 49s947ms - Times executed: 1 ]
[ User: postgres - Total duration: 25s682ms - Times executed: 14 ]
[ User: tad - Total duration: 18s825ms - Times executed: 1 ]
[ User: tad - Total duration: 16s613ms - Times executed: 1 ]
[ User: tad - Total duration: 12s214ms - Times executed: 1 ]
[ User: tad - Total duration: 12s97ms - Times executed: 1 ]
[ User: tad - Total duration: 10s810ms - Times executed: 1 ]
[ User: tad - Total duration: 9s231ms - Times executed: 1 ]
[ User: tad - Total duration: 8s293ms - Times executed: 1 ]
[ User: tad - Total duration: 6s679ms - Times executed: 1 ]
[ User: tad - Total duration: 5s842ms - Times executed: 1 ]
[ User: tad - Total duration: 5s528ms - Times executed: 1 ]
[ User: tad - Total duration: 4s199ms - Times executed: 1 ]
[ User: tad - Total duration: 4s51ms - Times executed: 3 ]
[ User: tad - Total duration: 3s796ms - Times executed: 1 ]

Most frequent queries (N)


[ User: tad - Total duration: 12m26s - Times executed: 156 ]
[ User: tad - Total duration: 11m24s - Times executed: 156 ]
[ User: tad - Total duration: 2m38s - Times executed: 79 ]
[ User: tad - Total duration: 4m29s - Times executed: 16 ]
[ User: tad - Total duration: 3m19s - Times executed: 16 ]
[ User: postgres - Total duration: 25s682ms - Times executed: 14 ]
[ User: tad - Total duration: 4s51ms - Times executed: 3 ]
[ User: tad - Total duration: 49s947ms - Times executed: 1 ]
[ User: tad - Total duration: 18s825ms - Times executed: 1 ]
[ User: tad - Total duration: 16s613ms - Times executed: 1 ]
[ User: tad - Total duration: 12s214ms - Times executed: 1 ]
[ User: tad - Total duration: 12s97ms - Times executed: 1 ]
[ User: tad - Total duration: 10s810ms - Times executed: 1 ]
[ User: tad - Total duration: 9s231ms - Times executed: 1 ]
[ User: tad - Total duration: 8s293ms - Times executed: 1 ]
[ User: tad - Total duration: 6s679ms - Times executed: 1 ]
[ User: tad - Total duration: 5s842ms - Times executed: 1 ]
[ User: tad - Total duration: 5s528ms - Times executed: 1 ]
[ User: tad - Total duration: 4s199ms - Times executed: 1 ]
[ User: tad - Total duration: 3s796ms - Times executed: 1 ]

Normalized slowest queries (N)


[ User: tad - Total duration: 49s947ms - Times executed: 1 ]
[ User: tad - Total duration: 18s825ms - Times executed: 1 ]
[ User: tad - Total duration: 4m29s - Times executed: 16 ]
[ User: tad - Total duration: 16s613ms - Times executed: 1 ]
[ User: tad - Total duration: 3m19s - Times executed: 16 ]
[ User: tad - Total duration: 12s214ms - Times executed: 1 ]
[ User: tad - Total duration: 12s97ms - Times executed: 1 ]
[ User: tad - Total duration: 10s810ms - Times executed: 1 ]
[ User: tad - Total duration: 9s231ms - Times executed: 1 ]
[ User: tad - Total duration: 8s293ms - Times executed: 1 ]
[ User: tad - Total duration: 6s679ms - Times executed: 1 ]
[ User: tad - Total duration: 5s842ms - Times executed: 1 ]
[ User: tad - Total duration: 5s528ms - Times executed: 1 ]
[ User: tad - Total duration: 12m26s - Times executed: 156 ]
[ User: tad - Total duration: 11m24s - Times executed: 156 ]
[ User: tad - Total duration: 4s199ms - Times executed: 1 ]
[ User: tad - Total duration: 3s796ms - Times executed: 1 ]
[ User: tad - Total duration: 2m38s - Times executed: 79 ]
[ User: postgres - Total duration: 25s682ms - Times executed: 14 ]
[ User: tad - Total duration: 4s51ms - Times executed: 3 ]

Time consuming prepare

Rank	Total duration	Times executed	Min duration	Max duration	Avg duration	Query
NO DATASET

Time consuming bind

Rank	Total duration	Times executed	Min duration	Max duration	Avg duration	Query
NO DATASET

Log levels

Key values

29,196 Log entries

Chart
Table

Type	Count	Percentage
DETAIL	350	1.20%
LOG	28,582	97.90%
STATEMENT	264	0.90%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
0 ERROR entries
0 WARNING entries

Errors per 5 minutes

NO DATASET

Most Frequent Errors/Events

Key values

0 Max number of times the same event was reported
0 Total events found

Rank	Times reported	Error
NO DATASET

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

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

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

Type of locks

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

Key values

Queries by host