pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Thu Jul 16 23:00:33 2026
Log file: /var/log/postgresql/postgresql-16-main.log
Parsed 136,609 log entries in 31s
Log start from 2026-07-16 07:00:01 to 2026-07-16 21:59:53

Global Stats

33 Number of unique normalized queries
112 Number of queries
16m17s Total query duration
2026-07-16 07:00:09 First query
2026-07-16 21:00:03 Last query
2 queries/s at 2026-07-16 13:20:43 Query peak

16m17s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
16m17s Execute total duration

8,789 Number of events
9 Number of unique normalized events
8,740 Max number of times the same event was reported
0 Number of cancellation

44,921 Total number of automatic vacuums
163 Total number of automatic analyzes

32 Number temporary file
215.08 MiB Max size of temporary file
72.41 MiB Average size of temporary file

8,815 Total number of sessions
9 sessions at 2026-07-16 11:00:02 Session peak
4d16h12m56s Total duration of sessions
45s828ms Average duration of sessions
0 Average queries per session
110ms Average queries duration per session
45s717ms Average idle time per session

8,816 Total number of connections
4 connections/s at 2026-07-16 13:00:01 Connection peak
1 Total number of databases

SQL Traffic

Key values

2 queries/s Query Peak
2026-07-16 13:20:43 Date

SELECT Traffic

Key values

2 queries/s Query Peak
2026-07-16 13:20:43 Date

INSERT/UPDATE/DELETE Traffic

Key values

1 queries/s Query Peak
2026-07-16 20:20:06 Date

Queries duration

Key values

16m17s 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	10	0ms	19s73ms	12s27ms	3s548ms	16s847ms	56s853ms
	08	4	0ms	1m58s	33s241ms	0ms	0ms	2m5s
	09	16	0ms	18s391ms	5s438ms	2s784ms	9s190ms	45s891ms
	10	3	0ms	2s604ms	2s363ms	0ms	1s882ms	2s604ms
	11	4	0ms	9s468ms	4s813ms	0ms	4s105ms	10s605ms
	12	22	0ms	15s836ms	5s752ms	2s956ms	14s894ms	52s241ms
	13	17	0ms	2m5s	20s297ms	6s9ms	40s260ms	2m14s
	14	5	0ms	11s59ms	4s208ms	0ms	2s538ms	11s59ms
	15	15	0ms	19s132ms	4s711ms	0ms	4s363ms	50s737ms
	16	1	0ms	2s863ms	2s863ms	0ms	0ms	2s863ms
	17	1	0ms	2s30ms	2s30ms	0ms	0ms	2s30ms
	18	1	0ms	1s866ms	1s866ms	0ms	0ms	1s866ms
	19	1	0ms	2s676ms	2s676ms	0ms	0ms	2s676ms
	20	11	0ms	7s261ms	3s212ms	0ms	0ms	28s357ms
	21	1	0ms	2s599ms	2s599ms	0ms	0ms	2s599ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 16	07	9	11s492ms	0ms	1s165ms	19s73ms
	08	4	33s241ms	0ms	0ms	7s224ms
	09	10	5s843ms	0ms	1s47ms	4s31ms
	10	3	2s363ms	0ms	0ms	2s602ms
	11	3	5s48ms	0ms	0ms	4s541ms
	12	19	6s174ms	0ms	2s956ms	33s851ms
	13	15	19s609ms	0ms	2s803ms	2m13s
	14	5	4s208ms	0ms	0ms	2s731ms
	15	12	5s132ms	0ms	0ms	10s628ms
	16	1	2s863ms	0ms	0ms	0ms
	17	1	2s30ms	0ms	0ms	0ms
	18	1	1s866ms	0ms	0ms	0ms
	19	1	2s676ms	0ms	0ms	0ms
	20	9	3s50ms	0ms	0ms	6s978ms
	21	1	2s599ms	0ms	0ms	0ms

Day	Hour	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 16	07	0	1	16s847ms	0ms	0ms	0ms
	08	0	0	0ms	0ms	0ms	0ms
	09	0	6	4s764ms	0ms	0ms	4s593ms
	10	0	0	0ms	0ms	0ms	0ms
	11	0	1	4s105ms	0ms	0ms	0ms
	12	3	0	3s85ms	0ms	0ms	0ms
	13	0	2	25s463ms	0ms	0ms	0ms
	14	0	0	0ms	0ms	0ms	0ms
	15	3	0	3s27ms	0ms	0ms	0ms
	16	0	0	0ms	0ms	0ms	0ms
	17	0	0	0ms	0ms	0ms	0ms
	18	0	0	0ms	0ms	0ms	0ms
	19	0	0	0ms	0ms	0ms	0ms
	20	2	0	3s941ms	0ms	0ms	0ms
	21	0	0	0ms	0ms	0ms	0ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
Jul 16	07	9	9.00	0.00%
	08	3	3.00	0.00%
	09	15	15.00	0.00%
	10	2	2.00	0.00%
	11	3	3.00	0.00%
	12	21	21.00	0.00%
	13	16	16.00	0.00%
	14	4	4.00	0.00%
	15	14	14.00	0.00%
	16	0	0.00	0.00%
	17	0	0.00	0.00%
	18	0	0.00	0.00%
	19	0	0.00	0.00%
	20	10	10.00	0.00%
	21	0	0.00	0.00%

Day	Hour	Count	Average / Second
Jul 16	07	589	0.16/s
	08	590	0.16/s
	09	587	0.16/s
	10	592	0.16/s
	11	586	0.16/s
	12	583	0.16/s
	13	587	0.16/s
	14	589	0.16/s
	15	588	0.16/s
	16	588	0.16/s
	17	587	0.16/s
	18	589	0.16/s
	19	585	0.16/s
	20	589	0.16/s
	21	587	0.16/s

Day	Hour	Count	Average Duration	Average idle time
Jul 16	07	589	251ms	46ms
	08	589	228ms	3ms
	09	587	226ms	78ms
	10	587	4m49s	4m49s
	11	586	272ms	239ms
	12	588	1m14s	1m14s
	13	587	1m55s	1m54s
	14	590	35s914ms	35s879ms
	15	587	2m50s	2m50s
	16	588	230ms	225ms
	17	587	217ms	214ms
	18	589	214ms	211ms
	19	585	214ms	209ms
	20	589	214ms	154ms
	21	587	216ms	212ms

↑ Back to the top of the General Activity table

Established Connections

Key values

4 connections Connection Peak
2026-07-16 13:00:01 Date

Connections per database

Key values

etendo Main Database
8,816 connections Total

Chart
Table

Database	User	Count
etendo		8,798
	postgres	45
	tad	8,753
postgres		18
	postgres	15
	tad	3

Connections per user

Key values

tad Main User
8,816 connections Total

Chart
Table

User	Count
postgres	60
tad	8,756

Connections per host

Key values

10.10.11.43 Main host with 8735 connections
8,816 Total connections

Chart
Table

Host	Count
10.10.11.43	8,735
127.0.0.1	14
172.30.3.29	7
[local]	60

Simultaneous sessions

Key values

9 sessions Session Peak
2026-07-16 11:00:02 Date

Histogram of session times

Key values

8,440 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	8,440	95.75%
500ms-1s	277	3.14%
1s-30s	86	0.98%
30s-1m	0	0.00%
1m-10m	1	0.01%
10m-30m	0	0.00%
30m-1h	0	0.00%
1h-8h	8	0.09%
> 8h	3	0.03%

Sessions per database

Key values

etendo Main Database
8,815 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
etendo	8,797	4d11h22m45s	43s942ms
postgres	18	4h50m11s	16m7s

Sessions per user

Key values

tad Main User
8,815 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
postgres	60	1m49s	1s827ms
tad	8,755	4d16h11m7s	46s129ms

Sessions per host

Key values

10.10.11.43 Main Host
8,815 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.11.43	8,735	33m49s	232ms
127.0.0.1	13	4d15h37m17s	8h35m10s
172.30.3.29	7	480ms	68ms
[local]	60	1m49s	1s827ms

Sessions per application

Key values

[unknown] Main Application
8,815 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
DBeaver 26.0.1 - Main	1	2h25m3s	2h25m3s
DBeaver 26.0.1 - Main	1	2h25m5s	2h25m5s
DBeaver 26.0.1 - Metadata	1	2h25m2s	2h25m2s
DBeaver 26.0.1 - Metadata	1	2h25m4s	2h25m4s
DBeaver 26.0.1 - Read PostgreSQL database list	1	593ms	593ms
DBeaver 26.0.1 - SQLEditor	1	2h25m3s	2h25m3s
[unknown]	8,742	33m49s	232ms
openbravo	7	4d3h31m57s	14h13m8s
pg_profile	45	46s270ms	1s28ms
psql	15	1m3s	4s226ms

Checkpoints Buffers

Key values

3,403 buffers Checkpoint Peak
2026-07-16 13:16:45 Date
269.974 seconds Highest write time
0.027 seconds Sync time

Checkpoints Wal files

Key values

2 files Wal files usage Peak
2026-07-16 21:16:55 Date

Checkpoints distance

Key values

46.57 Mo Distance Peak
2026-07-16 14:06:46 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jul 16	07	3,089	306.631s	0.058s	306.904s
	08	3,265	325.008s	0.06s	325.3s
	09	9,777	921.842s	0.057s	922.132s
	10	7,421	728.311s	0.05s	728.594s
	11	4,504	447.806s	0.054s	448.084s
	12	8,017	753.538s	0.051s	753.967s
	13	9,373	863.275s	0.053s	863.583s
	14	5,356	477.157s	0.052s	477.448s
	15	4,811	479.756s	0.053s	480.053s
	16	2,804	279.374s	0.053s	279.662s
	17	6,198	572.739s	0.103s	573.093s
	18	3,717	368.874s	0.053s	369.16s
	19	2,059	204.563s	0.052s	204.824s
	20	2,846	283.374s	0.056s	283.654s
	21	4,792	457.492s	0.05s	457.775s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jul 16	07	1	753	0.004s	0.012s
	08	2	860	0.004s	0.012s
	09	3	1,654	0.005s	0.012s
	10	3	1,744	0.005s	0.012s
	11	2	1,003	0.004s	0.012s
	12	3	1,569	0.003s	0.012s
	13	3	1,857	0.007s	0.012s
	14	2	1,057	0.004s	0.012s
	15	2	698	0.004s	0.012s
	16	2	437	0.004s	0.012s
	17	2	872	0.017s	0.011s
	18	2	695	0.004s	0.012s
	19	0	324	0.004s	0.012s
	20	2	317	0.004s	0.012s
	21	2	324	0.004s	0.012s

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
	21	0s

Day	Hour	Mean distance	Mean estimate
Jul 16	07	1,631.00 kB	8,348.00 kB
	08	1,790.75 kB	9,030.08 kB
	09	5,105.25 kB	14,240.25 kB
	10	3,758.50 kB	13,485.00 kB
	11	2,366.92 kB	10,565.67 kB
	12	3,999.50 kB	13,522.75 kB
	13	4,870.58 kB	14,251.00 kB
	14	2,841.33 kB	14,678.08 kB
	15	2,498.33 kB	11,328.75 kB
	16	1,700.33 kB	10,694.67 kB
	17	3,641.00 kB	13,455.36 kB
	18	2,104.25 kB	11,113.17 kB
	19	1,293.58 kB	8,793.17 kB
	20	1,549.00 kB	10,600.83 kB
	21	2,710.75 kB	12,120.75 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (179) Main checkpoint cause
179 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	179
Total	179

Size of temporary files

Key values

264.47 MiB Temp Files size Peak
2026-07-16 20:20:14 Date

Number of temporary files

Key values

2 per second Temp Files Peak
2026-07-16 09:19:06 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jul 16	07	0	0	0
	08	0	0	0
	09	8	2.60 MiB	332.97 KiB
	10	0	0	0
	11	0	0	0
	12	8	771.53 MiB	96.44 MiB
	13	0	0	0
	14	0	0	0
	15	8	771.55 MiB	96.44 MiB
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	8	771.55 MiB	96.44 MiB
	21	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	15	1.52 GiB	3.68 MiB	215.08 MiB	103.60 MiB	select * from ( select c_invoice_id as referencekey_id, ; SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; Date: 2026-07-16 12:15:44 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
2	8	2.60 MiB	129 B	665.34 KiB	332.97 KiB	select ma_production_cost (?, ?) as result from dual; SELECT MA_PRODUCTION_COST ($1, $2) AS RESULT FROM DUAL; Date: 2026-07-16 09:19:03 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
3	6	749.57 MiB	34.77 MiB	215.08 MiB	124.93 MiB	update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, c_invoice.ad_org_id as ad_org_id, c_invoice.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id from c_invoice, c_doctype, fact_acct f1, fact_acct f2 where c_invoice.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype in (...) and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id group by c_invoice_id, posted, c_invoice.ad_client_id, c_invoice.ad_org_id, f1.ad_table_id, f1.record_id) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id); UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '7EDC62AE0AF34B74A4B327EA8A957965' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'PURCHASE INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('API', 'APC') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); Date: 2026-07-16 12:16:12 Duration: 6s176ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '7EDC62AE0AF34B74A4B327EA8A957965' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'PURCHASE INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('API', 'APC') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); Date: 2026-07-16 15:25:57 Duration: 6s47ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '7EDC62AE0AF34B74A4B327EA8A957965' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'PURCHASE INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('API', 'APC') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); Date: 2026-07-16 20:20:31 Duration: 5s895ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
4	3	11.04 MiB	3.68 MiB	3.68 MiB	3.68 MiB	update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select distinct ad_column_identifier (?, fin_payment_schedule.c_invoice_id, ?) as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = ? group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, ?)) order by ?) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id); 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 distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); Date: 2026-07-16 12:15:45 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo

Queries generating the largest temporary files


[ Date: 2026-07-16 12:15:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 12:16:06 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 12:16:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 15:25:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 15:25:51 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 15:25:57 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 20:20:14 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 20:20:25 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 20:20:31 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 12:15:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 15:25:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 20:20:14 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 15:25:51 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 15:25:57 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 20:20:25 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 20:20:31 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 12:16:06 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 12:16:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 12:15:45 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-16 12:15:45 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

Rank	Size	Query
1	215.08 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-16 12:15:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2	215.08 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-16 12:16:06 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3	215.08 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 C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'PURCHASE INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('API', 'APC') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-16 12:16:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4	215.08 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-16 15:25:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5	215.08 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-16 15:25:51 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
6	215.08 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 C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'PURCHASE INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('API', 'APC') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-16 15:25:57 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
7	215.08 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-16 20:20:14 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8	215.08 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-16 20:20:25 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
9	215.08 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 C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'PURCHASE INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('API', 'APC') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-16 20:20:31 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
10	49.39 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-16 12:15:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
11	49.39 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-16 15:25:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
12	49.39 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-16 20:20:14 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
13	34.78 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-16 15:25:51 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
14	34.78 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 C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'PURCHASE INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('API', 'APC') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-16 15:25:57 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
15	34.78 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-16 20:20:25 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
16	34.78 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 C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'PURCHASE INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('API', 'APC') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-16 20:20:31 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
17	34.77 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-16 12:16:06 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
18	34.77 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 C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'PURCHASE INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('API', 'APC') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-16 12:16:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
19	3.68 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-16 12:15:45 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
20	3.68 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 distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-16 12:15:45 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

Vacuums / Analyzes Distribution

Key values

1.84 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo
2026-07-16 15:26:42 Date
0 sec Highest CPU-cost analyze
Table
Database etendo
Date

Average Autovacuum Duration

Key values

1.84 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo
2026-07-16 15:26:42 Date

Analyzes per table

Key values

public.ad_ep_instance_para (19) Main table analyzed (database etendo)
163 analyzes Total

Chart
Table

Table	Number of analyzes
etendo.public.ad_ep_instance_para	19
etendo.profile.last_stat_tables_srv1	15
etendo.profile.last_stat_user_functions_srv1	15
etendo.profile.last_stat_indexes_srv1	15
etendo.profile.last_stat_statements_srv1	15
etendo.profile.tables_list	13
etendo.profile.last_stat_io	8
etendo.profile.indexes_list	8
etendo.profile.funcs_list	7
etendo.profile.stmt_list	7
etendo.public.ad_session	6
etendo.profile.last_stat_activity_count_srv1	5
etendo.profile.last_extension_versions	5
etendo.profile.last_stat_slru	3
etendo.profile.sample_stat_tables	2
etendo.public.ad_process_request	2
etendo.profile.sample_stat_tables_total	1
etendo.public.c_email_bpcontact_lastused	1
etendo.public.m_storage_pending	1
etendo.profile.sample_stat_io	1
etendo.public.ad_sequence	1
etendo.profile.sample_stat_indexes_total	1
etendo.profile.sample_stat_user_functions	1
etendo.public.ad_pinstance	1
etendo.public.ad_process_run	1
etendo.profile.sample_stat_slru	1
etendo.public.m_stock_aux	1
etendo.public.ad_preference	1
etendo.profile.sample_statements	1
etendo.profile.sample_stat_indexes	1
etendo.public.ad_session_usage_audit	1
etendo.profile.sample_stat_database	1
etendo.profile.servers	1
etendo.public.ad_module	1
Total	163

Vacuums per table

Key values

public.ad_pinstance (898) Main table vacuumed on database etendo
44,921 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage			Frozen
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes	pages	tuples
etendo.public.ad_pinstance	898	4	160,205	0	124	0	0	396	89	579,616	32	62
etendo.profile.last_stat_io	898	0	154,456	0	99	0	0	193	87	349,223	0	0
etendo.profile.sample_stat_indexes_total	898	0	77,023	0	15	0	0	194	0	46,754	0	0
etendo.profile.sample_stat_tables	898	0	3,957,239	0	4	0	0	58	4	45,418	0	0
etendo.profile.sample_stat_user_func_total	898	0	41,236	0	15	0	0	195	0	46,995	0	0
etendo.profile.last_stat_indexes_srv1	898	0	62,323,042	0	92	0	0	304	93	533,648	0	0
etendo.profile.stmt_list	898	0	2,240,818	0	91	0	0	206	91	185,054	0	0
etendo.profile.tables_list	898	0	1,370,402	0	0	0	0	194	0	46,754	0	0
etendo.pg_toast.pg_toast_85256	898	0	989,244	0	89	0	0	203	89	544,485	0	0
etendo.public.ad_process_run	898	0	2,114,765	0	227	0	0	371	86	731,059	0	0
etendo.profile.sample_stat_io	898	0	124,834	0	14	0	0	194	0	46,754	0	0
etendo.profile.sample_statements_total	898	0	83,812	0	15	0	0	195	0	46,995	0	0
etendo.pg_catalog.pg_statistic	898	0	8,207,336	0	68	0	0	110	42	278,430	0	0
etendo.profile.sample_stat_tables_total	898	0	196,301	0	13	0	0	195	1	54,855	0	0
etendo.public.ad_sequence	898	0	146,027	0	52	0	0	193	1	56,993	0	0
etendo.profile.sample_stat_tablespaces	898	0	50,944	0	15	0	0	194	0	46,754	0	0
etendo.public.ad_ep_instance_para	898	3	102,710	0	164	0	0	256	87	620,001	0	0
etendo.profile.sample_stat_database	898	0	143,334	0	13	0	0	195	0	46,995	0	0
etendo.profile.sample_stat_archiver	898	0	30,790	0	15	0	0	194	0	46,754	0	0
etendo.profile.sample_stat_indexes	898	0	621,081	0	7	0	0	81	8	82,401	0	0
etendo.public.m_stock_proposed	898	1	120,334	0	90	0	0	215	90	719,175	0	0
etendo.public.ad_module	898	0	278,910	0	106	0	0	206	89	539,959	7	7
etendo.public.ad_session	898	0	1,396,760	0	231	0	0	445	69	653,118	7	7
etendo.profile.samples	898	0	48,492	0	15	0	0	195	0	46,995	0	0
etendo.profile.last_extension_versions	898	0	79,649	0	80	0	0	193	69	301,865	0	0
etendo.profile.last_stat_cluster	898	0	33,226	0	102	0	0	193	87	369,407	0	0
etendo.public.ad_process_request	898	0	890,779	0	286	0	0	307	91	751,571	0	0
etendo.profile.sample_statements	898	0	1,686,650	0	0	0	0	52	0	12,532	0	0
etendo.profile.last_stat_archiver	898	0	27,838	0	25	0	0	193	0	36,284	0	0
etendo.profile.last_stat_slru	898	0	57,302	0	15	0	0	193	0	36,284	0	0
etendo.profile.last_stat_user_functions_srv1	898	0	5,072,966	0	3	0	0	286	2	143,662	0	0
etendo.profile.sample_stat_user_functions	898	0	279,528	0	8	0	0	224	1	61,844	0	0
etendo.pg_toast.pg_toast_2619	898	0	2,427,541	0	41	0	0	70	41	320,865	0	0
etendo.profile.last_stat_tables_srv1	898	0	50,124,100	0	33	0	0	299	25	243,727	0	0
etendo.profile.last_stat_tablespaces_srv1	898	0	42,002	0	15	0	0	193	0	91,289	0	0
etendo.profile.last_stat_wal	898	0	31,430	0	15	0	0	193	0	36,284	0	0
etendo.profile.funcs_list	898	0	508,505	0	1	0	0	195	0	46,995	0	0
etendo.profile.last_stat_activity_count_srv1	898	0	81,440	0	33	0	0	194	0	91,762	0	0
etendo.profile.servers	898	0	45,872	0	102	0	0	208	87	541,976	15	15
etendo.profile.sample_stat_cluster	898	0	38,153	0	15	0	0	194	0	46,754	0	0
etendo.profile.last_stat_statements_srv1	898	0	14,146,568	0	30	0	0	311	27	243,331	0	0
etendo.profile.sample_stat_wal	898	0	33,880	0	97	0	0	194	82	691,274	0	0
etendo.profile.last_stat_database_srv1	898	0	95,020	0	75	0	0	193	70	377,729	0	0
etendo.public.c_invoice	898	0	12,017,376	0	132	0	0	460	108	837,619	130	404
etendo.profile.indexes_list	898	0	580,181	0	1	0	0	194	0	46,754	0	0
etendo.public.ma_processplan_tot_aux	898	0	819,321	0	87	0	0	193	87	735,509	0	0
etendo.profile.sample_stat_slru	898	0	61,465	0	14	0	0	194	0	46,754	0	0
etendo.public.ad_pinstance_para	898	0	90,747	0	110	0	0	193	56	487,745	0	0
etendo.public.ad_preference	898	0	2,565,942	0	151	0	0	216	31	222,540	0	0
etendo.pg_toast.pg_toast_196728	898	0	434,775	0	10	0	0	49	4	35,504	0	0
etendo.public.m_product_org	19	0	30,282	0	7	0	0	19	7	49,235	0	0
etendo.public.m_storage_pending	1	0	672	0	110	0	0	5	5	35,609	0	0
etendo.pg_catalog.pg_type	1	1	152	0	79	0	0	118	63	367,940	1	2
Total	44,921	9	177,283,457	4,151,580	3,251	0	0	10,708	1,869	13,705,829	192	497

Vacuum throughput per table

Key values

profile.last_stat_indexes_srv1 (812.189999999987) Max CPU elapsed for vacuum on database etendo
unknown (0 ms) Max I/O read time for vacuum on database etendo
unknown (0 ms) Max I/O write time for vacuum on database etendo

Chart
Table

	I/O timing (ms)		CPU (s)
Table	read	write	elapsed
etendo.public.ad_pinstance	0	0	0
etendo.profile.last_stat_io	0	0	0
etendo.profile.sample_stat_indexes_total	0	0	0
etendo.profile.sample_stat_tables	0	0	63.8100000000005
etendo.profile.sample_stat_user_func_total	0	0	0
etendo.profile.last_stat_indexes_srv1	0	0	812.189999999987
etendo.profile.stmt_list	0	0	20.2299999999998
etendo.profile.tables_list	0	0	12.4499999999998
etendo.pg_toast.pg_toast_85256	0	0	9.01999999999985
etendo.public.ad_process_run	0	0	34.5100000000004
etendo.profile.sample_stat_io	0	0	0
etendo.profile.sample_statements_total	0	0	0
etendo.pg_catalog.pg_statistic	0	0	106.84
etendo.profile.sample_stat_tables_total	0	0	0
etendo.public.ad_sequence	0	0	0
etendo.profile.sample_stat_tablespaces	0	0	0
etendo.public.ad_ep_instance_para	0	0	0.01
etendo.profile.sample_stat_database	0	0	0
etendo.profile.sample_stat_archiver	0	0	0
etendo.profile.sample_stat_indexes	0	0	5.94999999999992
etendo.public.m_stock_proposed	0	0	0.08
etendo.public.ad_module	0	0	0
etendo.public.ad_session	0	0	15.3299999999997
etendo.profile.samples	0	0	0
etendo.profile.last_extension_versions	0	0	0
etendo.profile.last_stat_cluster	0	0	0
etendo.public.ad_process_request	0	0	9.53999999999985
etendo.profile.sample_statements	0	0	20.5499999999999
etendo.profile.last_stat_archiver	0	0	0
etendo.profile.last_stat_slru	0	0	0
etendo.profile.last_stat_user_functions_srv1	0	0	64.0600000000004
etendo.profile.sample_stat_user_functions	0	0	0.04
etendo.pg_toast.pg_toast_2619	0	0	28.1200000000002
etendo.profile.last_stat_tables_srv1	0	0	647.120000000002
etendo.profile.last_stat_tablespaces_srv1	0	0	0
etendo.profile.last_stat_wal	0	0	0
etendo.profile.funcs_list	0	0	0.07
etendo.profile.last_stat_activity_count_srv1	0	0	0
etendo.profile.servers	0	0	0
etendo.profile.sample_stat_cluster	0	0	0
etendo.profile.last_stat_statements_srv1	0	0	176.960000000001
etendo.profile.sample_stat_wal	0	0	0
etendo.profile.last_stat_database_srv1	0	0	0
etendo.public.c_invoice	0	0	137.439999999999
etendo.profile.indexes_list	0	0	1
etendo.public.ma_processplan_tot_aux	0	0	12.2599999999998
etendo.profile.sample_stat_slru	0	0	0
etendo.public.ad_pinstance_para	0	0	0
etendo.public.ad_preference	0	0	25.8900000000002
etendo.pg_toast.pg_toast_196728	0	0	0.04
etendo.public.m_product_org	0	0	0.31
etendo.public.m_storage_pending	0	0	0.03
etendo.pg_catalog.pg_type	0	0	0.03
Total	0	0	2,203.87999999999

Tuples removed per table

Key values

public.ad_pinstance (348) Main table with removed tuples on database etendo
605 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
etendo.public.ad_pinstance	898	4	348	2,213,665	1,042,737	0	117,638
etendo.pg_catalog.pg_type	1	1	123	2,863	100	0	77
etendo.public.ad_ep_instance_para	898	3	120	1,865,733	1,865,733	0	38,141
etendo.public.m_storage_pending	1	0	7	7,887	1,232	0	493
etendo.public.m_stock_proposed	898	1	7	1,069,168	695,052	0	45,798
etendo.profile.last_stat_io	898	0	0	1,681,082	1,669,408	0	61,064
etendo.profile.sample_stat_indexes_total	898	0	0	1,120,712	514,624	0	17,062
etendo.profile.sample_stat_tables	898	0	0	81,602,573	33,849,202	0	3,164,552
etendo.profile.sample_stat_user_func_total	898	0	0	560,356	257,312	0	6,286
etendo.profile.last_stat_indexes_srv1	898	0	0	775,537,461	771,127,247	0	52,457,568
etendo.profile.stmt_list	898	0	0	9,012,441	8,048,596	0	1,163,808
etendo.profile.tables_list	898	0	0	20,214,465	19,345,801	0	694,154
etendo.pg_toast.pg_toast_85256	898	0	0	2,619,016	1,502,076	0	1,214,096
etendo.public.ad_process_run	898	0	0	15,598,080	6,240,165	0	1,525,702
etendo.profile.sample_stat_io	898	0	0	1,942,446	893,951	0	55,676
etendo.profile.sample_statements_total	898	0	0	560,356	257,312	0	30,532
etendo.pg_catalog.pg_statistic	898	0	0	61,848,716	50,702,562	0	6,919,988
etendo.profile.sample_stat_tables_total	898	0	0	2,521,602	1,157,904	0	86,208
etendo.public.ad_sequence	898	0	0	501,208	221,032	0	65,554
etendo.profile.sample_stat_tablespaces	898	0	0	560,356	257,312	0	5,388
etendo.profile.sample_stat_database	898	0	0	1,120,712	514,624	0	59,268
etendo.public.m_product_org	19	0	0	1,177,381	199,334	0	128,516
etendo.profile.sample_stat_archiver	898	0	0	280,178	128,656	0	3,592
etendo.profile.sample_stat_indexes	898	0	0	24,130,621	9,942,975	0	431,938
etendo.public.ad_module	898	0	0	1,329,671	894,529	0	202,050
etendo.public.ad_session	898	0	0	21,329,564	16,858,819	0	2,359,944
etendo.profile.samples	898	0	0	280,178	128,656	0	2,694
etendo.profile.last_extension_versions	898	0	0	1,163,826	1,155,744	0	26,940
etendo.profile.last_stat_cluster	898	0	0	129,314	128,416	0	4,490
etendo.public.ad_process_request	898	0	0	4,338,038	3,083,704	0	1,524,804
etendo.profile.sample_statements	898	0	0	22,658,540	9,390,472	0	1,363,164
etendo.profile.last_stat_archiver	898	0	0	129,314	128,416	0	1,796
etendo.profile.last_stat_slru	898	0	0	646,570	642,080	0	15,266
etendo.profile.last_stat_user_functions_srv1	898	0	0	79,142,324	78,310,674	0	4,223,294
etendo.profile.sample_stat_user_functions	898	0	0	16,725,714	6,533,051	0	177,804
etendo.pg_toast.pg_toast_2619	898	0	0	6,439,879	3,273,948	0	1,956,742
etendo.profile.last_stat_tables_srv1	898	0	0	504,113,208	501,413,108	0	42,008,440
etendo.profile.last_stat_tablespaces_srv1	898	0	0	258,628	256,832	0	7,184
etendo.profile.last_stat_wal	898	0	0	129,314	128,416	0	3,592
etendo.profile.funcs_list	898	0	0	5,350,812	5,076,383	0	243,358
etendo.profile.last_stat_activity_count_srv1	898	0	0	1,382,525	1,382,525	0	36,340
etendo.profile.servers	898	0	0	129,314	128,416	0	4,490
etendo.profile.sample_stat_cluster	898	0	0	280,178	128,656	0	8,082
etendo.profile.last_stat_statements_srv1	898	0	0	134,288,844	131,639,487	0	13,610,986
etendo.profile.sample_stat_wal	898	0	0	280,178	128,656	0	5,388
etendo.profile.last_stat_database_srv1	898	0	0	517,256	513,664	0	35,022
etendo.public.c_invoice	898	0	0	127,242,794	27,947,014	0	28,709,060
etendo.profile.indexes_list	898	0	0	9,710,553	9,211,505	0	267,604
etendo.public.ma_processplan_tot_aux	898	0	0	19,554,848	9,777,424	0	489,410
etendo.profile.sample_stat_slru	898	0	0	1,121,610	514,624	0	20,654
etendo.public.ad_pinstance_para	898	0	0	946,063	201,152	0	33,718
etendo.public.ad_preference	898	0	0	8,999,209	2,659,147	0	2,523,380
etendo.pg_toast.pg_toast_196728	898	0	0	757,493	343,274	0	234,378
Total	44,921	9	605	1,977,124,837	1,722,413,739	0	168,393,173

Pages removed per table

Key values

unknown (0) Main table with removed pages on database unknown
0 pages Total removed

Chart
Table

Pages removed per tables

NO DATASET

Table	Number of vacuums	Index scans	Tuples removed
etendo.public.ad_pinstance	898	4	348
etendo.profile.last_stat_io	898	0	0
etendo.profile.sample_stat_indexes_total	898	0	0
etendo.profile.sample_stat_tables	898	0	0
etendo.profile.sample_stat_user_func_total	898	0	0
etendo.profile.last_stat_indexes_srv1	898	0	0
etendo.profile.stmt_list	898	0	0
etendo.profile.tables_list	898	0	0
etendo.pg_toast.pg_toast_85256	898	0	0
etendo.public.ad_process_run	898	0	0
etendo.profile.sample_stat_io	898	0	0
etendo.public.m_storage_pending	1	0	7
etendo.profile.sample_statements_total	898	0	0
etendo.pg_catalog.pg_statistic	898	0	0
etendo.profile.sample_stat_tables_total	898	0	0
etendo.public.ad_sequence	898	0	0
etendo.profile.sample_stat_tablespaces	898	0	0
etendo.public.ad_ep_instance_para	898	3	120
etendo.profile.sample_stat_database	898	0	0
etendo.public.m_product_org	19	0	0
etendo.profile.sample_stat_archiver	898	0	0
etendo.profile.sample_stat_indexes	898	0	0
etendo.public.m_stock_proposed	898	1	7
etendo.public.ad_module	898	0	0
etendo.public.ad_session	898	0	0
etendo.profile.samples	898	0	0
etendo.profile.last_extension_versions	898	0	0
etendo.profile.last_stat_cluster	898	0	0
etendo.public.ad_process_request	898	0	0
etendo.profile.sample_statements	898	0	0
etendo.profile.last_stat_archiver	898	0	0
etendo.profile.last_stat_slru	898	0	0
etendo.profile.last_stat_user_functions_srv1	898	0	0
etendo.profile.sample_stat_user_functions	898	0	0
etendo.pg_toast.pg_toast_2619	898	0	0
etendo.profile.last_stat_tables_srv1	898	0	0
etendo.profile.last_stat_tablespaces_srv1	898	0	0
etendo.profile.last_stat_wal	898	0	0
etendo.profile.funcs_list	898	0	0
etendo.profile.last_stat_activity_count_srv1	898	0	0
etendo.profile.servers	898	0	0
etendo.pg_catalog.pg_type	1	1	123
etendo.profile.sample_stat_cluster	898	0	0
etendo.profile.last_stat_statements_srv1	898	0	0
etendo.profile.sample_stat_wal	898	0	0
etendo.profile.last_stat_database_srv1	898	0	0
etendo.public.c_invoice	898	0	0
etendo.profile.indexes_list	898	0	0
etendo.public.ma_processplan_tot_aux	898	0	0
etendo.profile.sample_stat_slru	898	0	0
etendo.public.ad_pinstance_para	898	0	0
etendo.public.ad_preference	898	0	0
etendo.pg_toast.pg_toast_196728	898	0	0
Total	44,921	9	605

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jul 16	07	3,000	11
	08	3,000	10
	09	3,000	15
	10	2,950	8
	11	3,000	12
	12	3,003	9
	13	3,000	18
	14	3,002	16
	15	3,004	13
	16	2,950	10
	17	3,000	9
	18	3,000	7
	19	3,000	9
	20	3,012	9
	21	3,000	7

↑ 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

94 Total read queries
18 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	94	83.93%
INSERT	0	0.00%
UPDATE	8	7.14%
DELETE	10	8.93%
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%

Queries by database

Key values

etendo Main database
112 Requests
16m17s (etendo)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
etendo	Total	112	16m17s
	delete	10	1m40s
	select	94	14m10s
	update	8	26s221ms

Queries by user

Key values

tad Main user
97 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	15	1m3s
	select	15	1m3s
tad	Total	97	15m13s
	delete	10	1m40s
	select	79	13m7s
	update	8	26s221ms

Duration by user

Key values

15m13s (tad) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	15	1m3s
	select	15	1m3s
tad	Total	97	15m13s
	delete	10	1m40s
	select	79	13m7s
	update	8	26s221ms

Queries by host

Key values

127.0.0.1 Main host
97 Requests
15m13s (127.0.0.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	97	15m13s
	delete	10	1m40s
	select	79	13m7s
	update	8	26s221ms
[local]	Total	15	1m3s
	select	15	1m3s

Queries by application

Key values

openbravo Main application
97 Requests
15m13s (openbravo)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
openbravo	Total	97	15m13s
	delete	10	1m40s
	select	79	13m7s
	update	8	26s221ms
psql	Total	15	1m3s
	select	15	1m3s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-07-16 15:05:40 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

89 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	89	79.46%
> 10000ms	23	20.54%

Slowest individual queries


[ Date: 2026-07-16 13:36:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 13:13:46 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 08:45:07 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 13:11:16 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 15:25:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 07:43:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 07:44:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 07:44:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 09:06:39 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 07:44:30 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 09:06:58 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 07:50:48 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 12:16:30 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 12:22:25 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 07:12:11 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 12:15:19 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 09:14:22 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 12:15:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-16 14:00:12 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-16 13:16:54 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

Rank	Duration	Query
1	2m5s	select materialmg0_.M_InOut_ID as m_inout_1_548_, materialmg0_.AD_Client_ID as ad_clien2_548_, materialmg0_.AD_Org_ID as ad_org_i3_548_, materialmg0_.IsActive as isactive4_548_, materialmg0_.Created as created5_548_, materialmg0_.CreatedBy as createdb6_548_, materialmg0_.Updated as updated7_548_, materialmg0_.UpdatedBy as updatedb8_548_, materialmg0_.IsSOTrx as issotrx9_548_, materialmg0_.DocumentNo as documen10_548_, materialmg0_.DocAction as docacti11_548_, materialmg0_.DocStatus as docstat12_548_, materialmg0_.Posted as posted13_548_, materialmg0_.Processing as process14_548_, materialmg0_.Processed as process15_548_, materialmg0_.C_DocType_ID as c_docty16_548_, materialmg0_.Description as descrip17_548_, materialmg0_.C_Order_ID as c_order18_548_, materialmg0_.DateOrdered as dateord19_548_, materialmg0_.IsPrinted as isprint20_548_, materialmg0_.MovementType as movemen21_548_, materialmg0_.MovementDate as movemen22_548_, materialmg0_.DateAcct as dateacc23_548_, materialmg0_.C_BPartner_ID as c_bpart24_548_, materialmg0_.C_BPartner_Location_ID as c_bpart25_548_, materialmg0_.M_Warehouse_ID as m_wareh26_548_, materialmg0_.POReference as porefer27_548_, materialmg0_.DeliveryRule as deliver28_548_, materialmg0_.FreightCostRule as freight29_548_, materialmg0_.FreightAmt as freight30_548_, materialmg0_.DeliveryViaRule as deliver31_548_, materialmg0_.M_Shipper_ID as m_shipp32_548_, materialmg0_.C_Charge_ID as c_charg33_548_, materialmg0_.ChargeAmt as chargea34_548_, materialmg0_.PriorityRule as priorit35_548_, materialmg0_.DatePrinted as datepri36_548_, materialmg0_.C_Invoice_ID as c_invoi37_548_, materialmg0_.CreateFrom as createf38_548_, materialmg0_.GenerateTo as generat39_548_, materialmg0_.AD_User_ID as ad_user40_548_, materialmg0_.SalesRep_ID as salesre41_548_, materialmg0_.NoPackages as nopacka42_548_, materialmg0_.PickDate as pickdat43_548_, materialmg0_.ShipDate as shipdat44_548_, materialmg0_.TrackingNo as trackin45_548_, materialmg0_.AD_OrgTrx_ID as ad_orgt46_548_, materialmg0_.C_Project_ID as c_proje47_548_, materialmg0_.C_Campaign_ID as c_campa48_548_, materialmg0_.C_Activity_ID as c_activ49_548_, materialmg0_.User1_ID as user50_548_, materialmg0_.User2_ID as user51_548_, materialmg0_.UpdateLines as updatel52_548_, materialmg0_.Islogistic as islogis53_548_, materialmg0_.Calculate_Freight as calcula54_548_, materialmg0_.Delivery_Location_ID as deliver55_548_, materialmg0_.M_FreightCategory_ID as m_freig56_548_, materialmg0_.Freight_Currency_ID as freight57_548_, materialmg0_.RM_Receipt_PickEdit as rm_rece58_548_, materialmg0_.RM_Shipment_Pickedit as rm_ship59_548_, materialmg0_.EM_Obcma_C_Poc_Email_ID as em_obcm60_548_, materialmg0_.M_Condition_Goods_ID as m_condi61_548_, materialmg0_.A_Asset_ID as a_asset62_548_, materialmg0_.C_Costcenter_ID as c_costc63_548_, materialmg0_.Process_Goods_Java as process64_548_, materialmg0_.Isnettingshipment as isnetti65_548_, materialmg0_.Iscompletelyinvoiced as iscompl66_548_, materialmg0_.EM_OBMFM_Freight_ID as em_obmf67_548_, materialmg0_.EM_Obwpack_Packing as em_obwp68_548_, materialmg0_.EM_OBMFM_Delivery_Charges as em_obmf69_548_, materialmg0_.EM_Obwpack_Packingh_ID as em_obwp70_548_, materialmg0_.Invoicefromshipment as invoice71_548_, materialmg0_.EM_Obwpack_Processed as em_obwp72_548_, materialmg0_.Bpartner_Extref as bpartne73_548_, materialmg0_.EM_Etblkp_Accountingstatus as em_etbl74_548_, materialmg0_.EM_Obwpack_Reactivated as em_obwp75_548_, materialmg0_.EM_Etblkp_Bulkposting as em_etbl76_548_, materialmg0_.EM_Prouti_Changebpartner as em_prou77_548_, materialmg0_.EM_Obwpack_Packingrequired as em_obwp78_548_, materialmg0_.EM_Prouti_Totalqtyreceived as em_prou79_548_, materialmg0_.EM_Pruti_Total_Amt_Tax as em_prut80_548_, materialmg0_.EM_Etblkc_Bulkcompletion as em_etbl81_548_, materialmg0_.EM_OBMFM_Deliverynotes as em_obmf82_548_, materialmg0_.EM_Prouti_Initial_Bp_ID as em_prou83_548_, materialmg0_.EM_Prouti_Move_Stock as em_prou84_548_, materialmg0_.EM_Prouti_Stock_Moved as em_prou85_548_, materialmg0_.EM_Pruti_Showpriceingoods as em_prut86_548_, materialmg0_.em_prlab_desc as em_prla87_548_, materialmg0_.em_prouti_invoiced as em_prou88_548_, materialmg0_.EM_Pruti_Createfrom as em_prut89_548_ from M_InOut materialmg0_ cross join M_InOut shipmentin1_ cross join C_DocType documentty2_ where materialmg0_.M_InOut_ID = shipmentin1_.M_InOut_ID and materialmg0_.C_DocType_ID = documentty2_.C_DocType_ID and materialmg0_.AD_Org_ID = '8997B74B935D46B08D5E187F5B343F48' and materialmg0_.MovementDate >= '2026-01-01 00:00:00' and ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin1_.m_inout_id) from dual) < '100' and materialmg0_.DocStatus = 'CO' and (materialmg0_.MovementType in ('V-', 'V+')) and materialmg0_.Islogistic = 'N' and documentty2_.IsReturn = 'N' and (materialmg0_.AD_Org_ID in ('0', '975163BBDF184727BFA9D21FECF88F51', '0145CB12BBE04855B3C433728BD65F7C', '7EEF753D8C114D32A101EA8393FEAC19', '8997B74B935D46B08D5E187F5B343F48', '9DFF9C5278274C2DA3F411C2BA23605C')) and (materialmg0_.AD_Client_ID in ('29E43D204AEB4CEC9D1DC4EFFD0E5987', '0')) order by materialmg0_.MovementDate desc, materialmg0_.M_InOut_ID desc limit '101'; [ Date: 2026-07-16 13:36:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
2	2m4s	select materialmg0_.M_InOut_ID as m_inout_1_548_, materialmg0_.AD_Client_ID as ad_clien2_548_, materialmg0_.AD_Org_ID as ad_org_i3_548_, materialmg0_.IsActive as isactive4_548_, materialmg0_.Created as created5_548_, materialmg0_.CreatedBy as createdb6_548_, materialmg0_.Updated as updated7_548_, materialmg0_.UpdatedBy as updatedb8_548_, materialmg0_.IsSOTrx as issotrx9_548_, materialmg0_.DocumentNo as documen10_548_, materialmg0_.DocAction as docacti11_548_, materialmg0_.DocStatus as docstat12_548_, materialmg0_.Posted as posted13_548_, materialmg0_.Processing as process14_548_, materialmg0_.Processed as process15_548_, materialmg0_.C_DocType_ID as c_docty16_548_, materialmg0_.Description as descrip17_548_, materialmg0_.C_Order_ID as c_order18_548_, materialmg0_.DateOrdered as dateord19_548_, materialmg0_.IsPrinted as isprint20_548_, materialmg0_.MovementType as movemen21_548_, materialmg0_.MovementDate as movemen22_548_, materialmg0_.DateAcct as dateacc23_548_, materialmg0_.C_BPartner_ID as c_bpart24_548_, materialmg0_.C_BPartner_Location_ID as c_bpart25_548_, materialmg0_.M_Warehouse_ID as m_wareh26_548_, materialmg0_.POReference as porefer27_548_, materialmg0_.DeliveryRule as deliver28_548_, materialmg0_.FreightCostRule as freight29_548_, materialmg0_.FreightAmt as freight30_548_, materialmg0_.DeliveryViaRule as deliver31_548_, materialmg0_.M_Shipper_ID as m_shipp32_548_, materialmg0_.C_Charge_ID as c_charg33_548_, materialmg0_.ChargeAmt as chargea34_548_, materialmg0_.PriorityRule as priorit35_548_, materialmg0_.DatePrinted as datepri36_548_, materialmg0_.C_Invoice_ID as c_invoi37_548_, materialmg0_.CreateFrom as createf38_548_, materialmg0_.GenerateTo as generat39_548_, materialmg0_.AD_User_ID as ad_user40_548_, materialmg0_.SalesRep_ID as salesre41_548_, materialmg0_.NoPackages as nopacka42_548_, materialmg0_.PickDate as pickdat43_548_, materialmg0_.ShipDate as shipdat44_548_, materialmg0_.TrackingNo as trackin45_548_, materialmg0_.AD_OrgTrx_ID as ad_orgt46_548_, materialmg0_.C_Project_ID as c_proje47_548_, materialmg0_.C_Campaign_ID as c_campa48_548_, materialmg0_.C_Activity_ID as c_activ49_548_, materialmg0_.User1_ID as user50_548_, materialmg0_.User2_ID as user51_548_, materialmg0_.UpdateLines as updatel52_548_, materialmg0_.Islogistic as islogis53_548_, materialmg0_.Calculate_Freight as calcula54_548_, materialmg0_.Delivery_Location_ID as deliver55_548_, materialmg0_.M_FreightCategory_ID as m_freig56_548_, materialmg0_.Freight_Currency_ID as freight57_548_, materialmg0_.RM_Receipt_PickEdit as rm_rece58_548_, materialmg0_.RM_Shipment_Pickedit as rm_ship59_548_, materialmg0_.EM_Obcma_C_Poc_Email_ID as em_obcm60_548_, materialmg0_.M_Condition_Goods_ID as m_condi61_548_, materialmg0_.A_Asset_ID as a_asset62_548_, materialmg0_.C_Costcenter_ID as c_costc63_548_, materialmg0_.Process_Goods_Java as process64_548_, materialmg0_.Isnettingshipment as isnetti65_548_, materialmg0_.Iscompletelyinvoiced as iscompl66_548_, materialmg0_.EM_OBMFM_Freight_ID as em_obmf67_548_, materialmg0_.EM_Obwpack_Packing as em_obwp68_548_, materialmg0_.EM_OBMFM_Delivery_Charges as em_obmf69_548_, materialmg0_.EM_Obwpack_Packingh_ID as em_obwp70_548_, materialmg0_.Invoicefromshipment as invoice71_548_, materialmg0_.EM_Obwpack_Processed as em_obwp72_548_, materialmg0_.Bpartner_Extref as bpartne73_548_, materialmg0_.EM_Etblkp_Accountingstatus as em_etbl74_548_, materialmg0_.EM_Obwpack_Reactivated as em_obwp75_548_, materialmg0_.EM_Etblkp_Bulkposting as em_etbl76_548_, materialmg0_.EM_Prouti_Changebpartner as em_prou77_548_, materialmg0_.EM_Obwpack_Packingrequired as em_obwp78_548_, materialmg0_.EM_Prouti_Totalqtyreceived as em_prou79_548_, materialmg0_.EM_Pruti_Total_Amt_Tax as em_prut80_548_, materialmg0_.EM_Etblkc_Bulkcompletion as em_etbl81_548_, materialmg0_.EM_OBMFM_Deliverynotes as em_obmf82_548_, materialmg0_.EM_Prouti_Initial_Bp_ID as em_prou83_548_, materialmg0_.EM_Prouti_Move_Stock as em_prou84_548_, materialmg0_.EM_Prouti_Stock_Moved as em_prou85_548_, materialmg0_.EM_Pruti_Showpriceingoods as em_prut86_548_, materialmg0_.em_prlab_desc as em_prla87_548_, materialmg0_.em_prouti_invoiced as em_prou88_548_, materialmg0_.EM_Pruti_Createfrom as em_prut89_548_ from M_InOut materialmg0_ cross join M_InOut shipmentin1_ cross join C_DocType documentty2_ where materialmg0_.M_InOut_ID = shipmentin1_.M_InOut_ID and materialmg0_.C_DocType_ID = documentty2_.C_DocType_ID and materialmg0_.AD_Org_ID = '8997B74B935D46B08D5E187F5B343F48' and materialmg0_.MovementDate >= '2026-01-01 00:00:00' and ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin1_.m_inout_id) from dual) < '100' and materialmg0_.DocStatus = 'CO' and (materialmg0_.MovementType in ('V-', 'V+')) and materialmg0_.Islogistic = 'N' and documentty2_.IsReturn = 'N' and (materialmg0_.AD_Org_ID in ('0', '975163BBDF184727BFA9D21FECF88F51', '0145CB12BBE04855B3C433728BD65F7C', '7EEF753D8C114D32A101EA8393FEAC19', '8997B74B935D46B08D5E187F5B343F48', '9DFF9C5278274C2DA3F411C2BA23605C')) and (materialmg0_.AD_Client_ID in ('29E43D204AEB4CEC9D1DC4EFFD0E5987', '0')) order by materialmg0_.MovementDate desc, materialmg0_.M_InOut_ID desc limit '101'; [ Date: 2026-07-16 13:13:46 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3	1m58s	select materialmg0_.M_InOut_ID as m_inout_1_548_, materialmg0_.AD_Client_ID as ad_clien2_548_, materialmg0_.AD_Org_ID as ad_org_i3_548_, materialmg0_.IsActive as isactive4_548_, materialmg0_.Created as created5_548_, materialmg0_.CreatedBy as createdb6_548_, materialmg0_.Updated as updated7_548_, materialmg0_.UpdatedBy as updatedb8_548_, materialmg0_.IsSOTrx as issotrx9_548_, materialmg0_.DocumentNo as documen10_548_, materialmg0_.DocAction as docacti11_548_, materialmg0_.DocStatus as docstat12_548_, materialmg0_.Posted as posted13_548_, materialmg0_.Processing as process14_548_, materialmg0_.Processed as process15_548_, materialmg0_.C_DocType_ID as c_docty16_548_, materialmg0_.Description as descrip17_548_, materialmg0_.C_Order_ID as c_order18_548_, materialmg0_.DateOrdered as dateord19_548_, materialmg0_.IsPrinted as isprint20_548_, materialmg0_.MovementType as movemen21_548_, materialmg0_.MovementDate as movemen22_548_, materialmg0_.DateAcct as dateacc23_548_, materialmg0_.C_BPartner_ID as c_bpart24_548_, materialmg0_.C_BPartner_Location_ID as c_bpart25_548_, materialmg0_.M_Warehouse_ID as m_wareh26_548_, materialmg0_.POReference as porefer27_548_, materialmg0_.DeliveryRule as deliver28_548_, materialmg0_.FreightCostRule as freight29_548_, materialmg0_.FreightAmt as freight30_548_, materialmg0_.DeliveryViaRule as deliver31_548_, materialmg0_.M_Shipper_ID as m_shipp32_548_, materialmg0_.C_Charge_ID as c_charg33_548_, materialmg0_.ChargeAmt as chargea34_548_, materialmg0_.PriorityRule as priorit35_548_, materialmg0_.DatePrinted as datepri36_548_, materialmg0_.C_Invoice_ID as c_invoi37_548_, materialmg0_.CreateFrom as createf38_548_, materialmg0_.GenerateTo as generat39_548_, materialmg0_.AD_User_ID as ad_user40_548_, materialmg0_.SalesRep_ID as salesre41_548_, materialmg0_.NoPackages as nopacka42_548_, materialmg0_.PickDate as pickdat43_548_, materialmg0_.ShipDate as shipdat44_548_, materialmg0_.TrackingNo as trackin45_548_, materialmg0_.AD_OrgTrx_ID as ad_orgt46_548_, materialmg0_.C_Project_ID as c_proje47_548_, materialmg0_.C_Campaign_ID as c_campa48_548_, materialmg0_.C_Activity_ID as c_activ49_548_, materialmg0_.User1_ID as user50_548_, materialmg0_.User2_ID as user51_548_, materialmg0_.UpdateLines as updatel52_548_, materialmg0_.Islogistic as islogis53_548_, materialmg0_.Calculate_Freight as calcula54_548_, materialmg0_.Delivery_Location_ID as deliver55_548_, materialmg0_.M_FreightCategory_ID as m_freig56_548_, materialmg0_.Freight_Currency_ID as freight57_548_, materialmg0_.RM_Receipt_PickEdit as rm_rece58_548_, materialmg0_.RM_Shipment_Pickedit as rm_ship59_548_, materialmg0_.EM_Obcma_C_Poc_Email_ID as em_obcm60_548_, materialmg0_.M_Condition_Goods_ID as m_condi61_548_, materialmg0_.A_Asset_ID as a_asset62_548_, materialmg0_.C_Costcenter_ID as c_costc63_548_, materialmg0_.Process_Goods_Java as process64_548_, materialmg0_.Isnettingshipment as isnetti65_548_, materialmg0_.Iscompletelyinvoiced as iscompl66_548_, materialmg0_.EM_OBMFM_Freight_ID as em_obmf67_548_, materialmg0_.EM_Obwpack_Packing as em_obwp68_548_, materialmg0_.EM_OBMFM_Delivery_Charges as em_obmf69_548_, materialmg0_.EM_Obwpack_Packingh_ID as em_obwp70_548_, materialmg0_.Invoicefromshipment as invoice71_548_, materialmg0_.EM_Obwpack_Processed as em_obwp72_548_, materialmg0_.Bpartner_Extref as bpartne73_548_, materialmg0_.EM_Etblkp_Accountingstatus as em_etbl74_548_, materialmg0_.EM_Obwpack_Reactivated as em_obwp75_548_, materialmg0_.EM_Etblkp_Bulkposting as em_etbl76_548_, materialmg0_.EM_Prouti_Changebpartner as em_prou77_548_, materialmg0_.EM_Obwpack_Packingrequired as em_obwp78_548_, materialmg0_.EM_Prouti_Totalqtyreceived as em_prou79_548_, materialmg0_.EM_Pruti_Total_Amt_Tax as em_prut80_548_, materialmg0_.EM_Etblkc_Bulkcompletion as em_etbl81_548_, materialmg0_.EM_OBMFM_Deliverynotes as em_obmf82_548_, materialmg0_.EM_Prouti_Initial_Bp_ID as em_prou83_548_, materialmg0_.EM_Prouti_Move_Stock as em_prou84_548_, materialmg0_.EM_Prouti_Stock_Moved as em_prou85_548_, materialmg0_.EM_Pruti_Showpriceingoods as em_prut86_548_, materialmg0_.em_prlab_desc as em_prla87_548_, materialmg0_.em_prouti_invoiced as em_prou88_548_, materialmg0_.EM_Pruti_Createfrom as em_prut89_548_ from M_InOut materialmg0_ cross join M_InOut shipmentin1_ cross join C_DocType documentty2_ where materialmg0_.M_InOut_ID = shipmentin1_.M_InOut_ID and materialmg0_.C_DocType_ID = documentty2_.C_DocType_ID and materialmg0_.AD_Org_ID = '8997B74B935D46B08D5E187F5B343F48' and materialmg0_.MovementDate >= '2026-01-01 00:00:00' and ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin1_.m_inout_id) from dual) < '100' and materialmg0_.DocStatus = 'CO' and (materialmg0_.MovementType in ('V-', 'V+')) and materialmg0_.Islogistic = 'N' and documentty2_.IsReturn = 'N' and (materialmg0_.AD_Org_ID in ('0', '975163BBDF184727BFA9D21FECF88F51', '0145CB12BBE04855B3C433728BD65F7C', '7EEF753D8C114D32A101EA8393FEAC19', '8997B74B935D46B08D5E187F5B343F48', '9DFF9C5278274C2DA3F411C2BA23605C')) and (materialmg0_.AD_Client_ID in ('29E43D204AEB4CEC9D1DC4EFFD0E5987', '0')) order by materialmg0_.MovementDate desc, materialmg0_.M_InOut_ID desc limit '101'; [ Date: 2026-07-16 08:45:07 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
4	40s260ms	delete from C_OrderLine where C_OrderLine_ID = '59CB2C7C1656444AA7485EC0E5552EC8'; [ Date: 2026-07-16 13:11:16 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
5	19s132ms	SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'F2C188AA7FF14438B4012EC2DDCA91F3' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date: 2026-07-16 15:25:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
6	19s73ms	select shipmentin0_.M_InOut_ID as m_inout_1_548_0_, shipmentin0_.AD_Client_ID as ad_clien2_548_0_, shipmentin0_.AD_Org_ID as ad_org_i3_548_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('2464849836924D36AB07C38403EF28C5', 'A1540AB12AF54B1EB97C70C8369ECDCD', '75ED1EB8D1624315AC579407C1F03213', 'F8E9D0F56C374E018A5EB55F5FEC47BA', 'E56CD8DEB7294268B7A09DBE0520D8B0', '6999B288722E4544B38489B370830801', 'EFBC1FC3B5CE4538BCB7634B63D3B8CA', 'A23418D9F05240B79C4F9BEF763A6983', 'E437DA52BECD4A65835AE53F05DD895D', 'C183DFCC351B48EE867D63094006DB09', 'A70E94284C4D4D6BA533F16FAC1D9F44', '88358C04688A4DB180BD586864226486', '7FFC107C38AD46CE9DB9A5C16E30D72C', '22F63E6BEF174224A4864BD2A7649365', '1183E76227194BA9BDF4B635B51EA8AA', 'CA7230FD745F44E08B3419F9705DFC75', 'BA066D2368C047D3B450D85DFBFF3284', '6920DD449F42472BBB8E28D4E60115C7', '59F4F8DAF68D4FCEA0C31FD95B1109D6', '5755BB0FFF054EE19C2C4734DFDCF924', '334CC9734D974F9A9F138E01D3C3554F', '0EB2243EC98B4D45A246AF1EF6DE5AB6', '0593DAA12E834C679D5EB625D7641E0B', 'FD3EEA3815264D06B2EDA8E85F5C5B99', '7D31AB83DC554E8F82864DBAC227AFAF', '5B3D854704D846A8BBF735EE90C08EC6', '5676C88890924D12ACFDDA937824706F', 'F97E787067864E1CBF185485AE2397F9', '02256ECFE7FC40D98A07844750C852D8', 'A25C9A6E64ED4254A3927468497A284A', '9B4204A320D8437AB740A79816048842', 'D61596591DFA4CDB810E7AB4151C666B', 'AA7E9D2D8FB9434CA09A45BDB0AA2E0A', '56658E2CE6A347B49D55E7770905167F', 'EDA7F3DD8DF745D5A1796C17E79360D7', 'E757BFA3A4A044A5AEFB3AA0BF4418F7', 'D0A2ABCFEA974B99B8365B09F5F75DA4', '88DD2AEBB0B5434CA495B8CFCF0A1B04', '79052844AF3D4EF1A04143F3C7E2B3F7', '75FDD499C9314BCBB2FB4720985CD249', '0B5D8061BD3B481CAC98A2F8BE9AF86F', 'F8721F06C1BD4FACA89DA4D42631A02F', '73B02DBD78834EDDB5678A1D930A54A8', '61D7129D278F47088D096097C28341BD', '158EE030F0D44567ABCA6BFD36535A28', 'EC85491D8075441FA23DD7DA632F9203', 'E0BB0721517D42FF89497B7F8C6E1EC4', 'CCF32FCA6889428AA219B822709F2A87', 'B24B513395D143CEB1C6104256202029', '94AFF89537B641FAA5A7134AF713F4B8'); [ Date: 2026-07-16 07:43:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
7	18s927ms	select shipmentin0_.M_InOut_ID as m_inout_1_548_0_, shipmentin0_.AD_Client_ID as ad_clien2_548_0_, shipmentin0_.AD_Org_ID as ad_org_i3_548_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('2464849836924D36AB07C38403EF28C5', 'A1540AB12AF54B1EB97C70C8369ECDCD', '75ED1EB8D1624315AC579407C1F03213', 'F8E9D0F56C374E018A5EB55F5FEC47BA', 'E56CD8DEB7294268B7A09DBE0520D8B0', '6999B288722E4544B38489B370830801', 'EFBC1FC3B5CE4538BCB7634B63D3B8CA', 'A23418D9F05240B79C4F9BEF763A6983', 'E437DA52BECD4A65835AE53F05DD895D', 'C183DFCC351B48EE867D63094006DB09', 'A70E94284C4D4D6BA533F16FAC1D9F44', '88358C04688A4DB180BD586864226486', '7FFC107C38AD46CE9DB9A5C16E30D72C', '22F63E6BEF174224A4864BD2A7649365', '1183E76227194BA9BDF4B635B51EA8AA', 'CA7230FD745F44E08B3419F9705DFC75', 'BA066D2368C047D3B450D85DFBFF3284', '6920DD449F42472BBB8E28D4E60115C7', '59F4F8DAF68D4FCEA0C31FD95B1109D6', '5755BB0FFF054EE19C2C4734DFDCF924', '334CC9734D974F9A9F138E01D3C3554F', '0EB2243EC98B4D45A246AF1EF6DE5AB6', '0593DAA12E834C679D5EB625D7641E0B', 'FD3EEA3815264D06B2EDA8E85F5C5B99', '7D31AB83DC554E8F82864DBAC227AFAF', '5B3D854704D846A8BBF735EE90C08EC6', '5676C88890924D12ACFDDA937824706F', 'F97E787067864E1CBF185485AE2397F9', '02256ECFE7FC40D98A07844750C852D8', 'A25C9A6E64ED4254A3927468497A284A', '9B4204A320D8437AB740A79816048842', 'D61596591DFA4CDB810E7AB4151C666B', 'AA7E9D2D8FB9434CA09A45BDB0AA2E0A', '56658E2CE6A347B49D55E7770905167F', 'EDA7F3DD8DF745D5A1796C17E79360D7', 'E757BFA3A4A044A5AEFB3AA0BF4418F7', 'D0A2ABCFEA974B99B8365B09F5F75DA4', '88DD2AEBB0B5434CA495B8CFCF0A1B04', '79052844AF3D4EF1A04143F3C7E2B3F7', '75FDD499C9314BCBB2FB4720985CD249', '0B5D8061BD3B481CAC98A2F8BE9AF86F', 'F8721F06C1BD4FACA89DA4D42631A02F', '73B02DBD78834EDDB5678A1D930A54A8', '61D7129D278F47088D096097C28341BD', '158EE030F0D44567ABCA6BFD36535A28', 'EC85491D8075441FA23DD7DA632F9203', 'E0BB0721517D42FF89497B7F8C6E1EC4', 'CCF32FCA6889428AA219B822709F2A87', 'B24B513395D143CEB1C6104256202029', '94AFF89537B641FAA5A7134AF713F4B8'); [ Date: 2026-07-16 07:44:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
8	18s572ms	select shipmentin0_.M_InOut_ID as m_inout_1_548_0_, shipmentin0_.AD_Client_ID as ad_clien2_548_0_, shipmentin0_.AD_Org_ID as ad_org_i3_548_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('73E0C9FCF36C47A8A3AC8C7005EB2383', '5D38B90A288949249B11967AC4EF30CE', '2EAF328D81704F6A9EC9AACD7D0E26C4', '06C7A9CE1C124835ADD5859508E5860C', 'FA0C234791484C80A9450DC37C6483F7', 'F02A908CBF6941A3A97009947032CB7D', 'D2C980C3F870461EA06BB1A396DF5CCA', '2EDBA46ADF5A4ADD99C7129E527BA7AF', '208EA8558CB344D0BE51A3CAAB0CA094', '85C27C6C5A0D46F5AAD8AE60042E3EBC', '7206CA88222C44B296B90E85171E8D78', '62A825848B3F4A9189EDCBE5DF434027', '25A15A4EBBF3433F8333CAF98D42CD2B', '0837CFCD73B24C2DAEE458AA11A4E1D4', 'F3F303C8539241E69D97A193ED2DC553', 'D5009CFD78194650B1D926D87C9F7B94', '3C610A090F834C5C9B0701CDE82F0B63', '21F34EDE65944594B831C9C271CDFB5C', '2E009837AA2346CFAC4D9FA17F17EEC3', '1B57A97ABD10450C960D899EC13A731F', '99A1445D5D134414AA422BE0E98C8C2C', '84E6471E0F004E6E92C13D2B3B3BCD0A', '6676F03C94A542DE8509817397097DBF', '2B7A906A597947838EECA2654212317C', 'F280622215024E1286F19C35CEDA0453', 'DABAC61D31794EDAB32F6C69104F75FD', 'AAEAC087CA884CFCAC2CF87E39924DBB', 'A48627871CB54ED08A67C40909636D01', '9FEF5B4CBDDC4D65BD63ED0DD6D8FD50', '9218D93C86274DB0AA06E845880FB4FC', '60481CEE31B044448DC6AF9B3FBFCAB2', '58E07566EC924698B7D95BE49E1D92F5', '401D873274EB4EF6A410D50AE461C241', '11FCD6556C434324A86031923F0961E6', 'E0350B98AAE442D5A41BA3564548D89F', 'AAE437121C4446D5BC8A45596DA072BF', '4CBB8E46E4794A149091D1881E491B24', '2545EAE6A58948AD90C7F8F5A6E66C1A', '1C599D230970405697B367091CE5FE1F', 'F2D26CDFE60E4D0695BAF8F93B78D9D9', 'F153F412C73B4CD18138BF307DD94C54', 'EDB716CEA1AC4288BFB7C35563E5516E', 'C5D9FED3CF78462AA6F439EFA589ABCA', '4BFA8812B61F45E888DDFDF252EE98EE', '1FA8F76153BB44D894ED731F37B85E46', 'C9935BE6C4914780B28B5922DD68F96B', 'BE691CDE89754B9691748897DD0FA5AF', 'A015E4739B6944918AFB34B1E17064B2', '9CF58A8EF50749888D945DF502C2F0FA', '5975258B3B7046728118B387C2DC837B'); [ Date: 2026-07-16 07:44:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
9	18s391ms	select shipmentin0_.M_InOut_ID as m_inout_1_548_0_, shipmentin0_.AD_Client_ID as ad_clien2_548_0_, shipmentin0_.AD_Org_ID as ad_org_i3_548_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('2464849836924D36AB07C38403EF28C5', 'A1540AB12AF54B1EB97C70C8369ECDCD', '75ED1EB8D1624315AC579407C1F03213', 'F8E9D0F56C374E018A5EB55F5FEC47BA', 'E56CD8DEB7294268B7A09DBE0520D8B0', '6999B288722E4544B38489B370830801', 'EFBC1FC3B5CE4538BCB7634B63D3B8CA', 'A23418D9F05240B79C4F9BEF763A6983', 'E437DA52BECD4A65835AE53F05DD895D', 'C183DFCC351B48EE867D63094006DB09', 'A70E94284C4D4D6BA533F16FAC1D9F44', '88358C04688A4DB180BD586864226486', '7FFC107C38AD46CE9DB9A5C16E30D72C', '22F63E6BEF174224A4864BD2A7649365', '1183E76227194BA9BDF4B635B51EA8AA', 'CA7230FD745F44E08B3419F9705DFC75', 'BA066D2368C047D3B450D85DFBFF3284', '6920DD449F42472BBB8E28D4E60115C7', '59F4F8DAF68D4FCEA0C31FD95B1109D6', '5755BB0FFF054EE19C2C4734DFDCF924', '334CC9734D974F9A9F138E01D3C3554F', '0EB2243EC98B4D45A246AF1EF6DE5AB6', '0593DAA12E834C679D5EB625D7641E0B', 'FD3EEA3815264D06B2EDA8E85F5C5B99', '7D31AB83DC554E8F82864DBAC227AFAF', '5B3D854704D846A8BBF735EE90C08EC6', '5676C88890924D12ACFDDA937824706F', 'F97E787067864E1CBF185485AE2397F9', '02256ECFE7FC40D98A07844750C852D8', 'A25C9A6E64ED4254A3927468497A284A', '9B4204A320D8437AB740A79816048842', 'D61596591DFA4CDB810E7AB4151C666B', 'AA7E9D2D8FB9434CA09A45BDB0AA2E0A', '56658E2CE6A347B49D55E7770905167F', 'EDA7F3DD8DF745D5A1796C17E79360D7', 'E757BFA3A4A044A5AEFB3AA0BF4418F7', 'D0A2ABCFEA974B99B8365B09F5F75DA4', '88DD2AEBB0B5434CA495B8CFCF0A1B04', '79052844AF3D4EF1A04143F3C7E2B3F7', '75FDD499C9314BCBB2FB4720985CD249', '0B5D8061BD3B481CAC98A2F8BE9AF86F', 'F8721F06C1BD4FACA89DA4D42631A02F', '73B02DBD78834EDDB5678A1D930A54A8', '61D7129D278F47088D096097C28341BD', '158EE030F0D44567ABCA6BFD36535A28', 'EC85491D8075441FA23DD7DA632F9203', 'E0BB0721517D42FF89497B7F8C6E1EC4', 'CCF32FCA6889428AA219B822709F2A87', 'B24B513395D143CEB1C6104256202029', '94AFF89537B641FAA5A7134AF713F4B8'); [ Date: 2026-07-16 09:06:39 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
10	18s267ms	select shipmentin0_.M_InOut_ID as m_inout_1_548_0_, shipmentin0_.AD_Client_ID as ad_clien2_548_0_, shipmentin0_.AD_Org_ID as ad_org_i3_548_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('73E0C9FCF36C47A8A3AC8C7005EB2383', '5D38B90A288949249B11967AC4EF30CE', '2EAF328D81704F6A9EC9AACD7D0E26C4', '06C7A9CE1C124835ADD5859508E5860C', 'FA0C234791484C80A9450DC37C6483F7', 'F02A908CBF6941A3A97009947032CB7D', 'D2C980C3F870461EA06BB1A396DF5CCA', '2EDBA46ADF5A4ADD99C7129E527BA7AF', '208EA8558CB344D0BE51A3CAAB0CA094', '85C27C6C5A0D46F5AAD8AE60042E3EBC', '7206CA88222C44B296B90E85171E8D78', '62A825848B3F4A9189EDCBE5DF434027', '25A15A4EBBF3433F8333CAF98D42CD2B', '0837CFCD73B24C2DAEE458AA11A4E1D4', 'F3F303C8539241E69D97A193ED2DC553', 'D5009CFD78194650B1D926D87C9F7B94', '3C610A090F834C5C9B0701CDE82F0B63', '21F34EDE65944594B831C9C271CDFB5C', '2E009837AA2346CFAC4D9FA17F17EEC3', '1B57A97ABD10450C960D899EC13A731F', '99A1445D5D134414AA422BE0E98C8C2C', '84E6471E0F004E6E92C13D2B3B3BCD0A', '6676F03C94A542DE8509817397097DBF', '2B7A906A597947838EECA2654212317C', 'F280622215024E1286F19C35CEDA0453', 'DABAC61D31794EDAB32F6C69104F75FD', 'AAEAC087CA884CFCAC2CF87E39924DBB', 'A48627871CB54ED08A67C40909636D01', '9FEF5B4CBDDC4D65BD63ED0DD6D8FD50', '9218D93C86274DB0AA06E845880FB4FC', '60481CEE31B044448DC6AF9B3FBFCAB2', '58E07566EC924698B7D95BE49E1D92F5', '401D873274EB4EF6A410D50AE461C241', '11FCD6556C434324A86031923F0961E6', 'E0350B98AAE442D5A41BA3564548D89F', 'AAE437121C4446D5BC8A45596DA072BF', '4CBB8E46E4794A149091D1881E491B24', '2545EAE6A58948AD90C7F8F5A6E66C1A', '1C599D230970405697B367091CE5FE1F', 'F2D26CDFE60E4D0695BAF8F93B78D9D9', 'F153F412C73B4CD18138BF307DD94C54', 'EDB716CEA1AC4288BFB7C35563E5516E', 'C5D9FED3CF78462AA6F439EFA589ABCA', '4BFA8812B61F45E888DDFDF252EE98EE', '1FA8F76153BB44D894ED731F37B85E46', 'C9935BE6C4914780B28B5922DD68F96B', 'BE691CDE89754B9691748897DD0FA5AF', 'A015E4739B6944918AFB34B1E17064B2', '9CF58A8EF50749888D945DF502C2F0FA', '5975258B3B7046728118B387C2DC837B'); [ Date: 2026-07-16 07:44:30 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
11	18s239ms	select shipmentin0_.M_InOut_ID as m_inout_1_548_0_, shipmentin0_.AD_Client_ID as ad_clien2_548_0_, shipmentin0_.AD_Org_ID as ad_org_i3_548_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('73E0C9FCF36C47A8A3AC8C7005EB2383', '5D38B90A288949249B11967AC4EF30CE', '2EAF328D81704F6A9EC9AACD7D0E26C4', '06C7A9CE1C124835ADD5859508E5860C', 'FA0C234791484C80A9450DC37C6483F7', 'F02A908CBF6941A3A97009947032CB7D', 'D2C980C3F870461EA06BB1A396DF5CCA', '2EDBA46ADF5A4ADD99C7129E527BA7AF', '208EA8558CB344D0BE51A3CAAB0CA094', '85C27C6C5A0D46F5AAD8AE60042E3EBC', '7206CA88222C44B296B90E85171E8D78', '62A825848B3F4A9189EDCBE5DF434027', '25A15A4EBBF3433F8333CAF98D42CD2B', '0837CFCD73B24C2DAEE458AA11A4E1D4', 'F3F303C8539241E69D97A193ED2DC553', 'D5009CFD78194650B1D926D87C9F7B94', '3C610A090F834C5C9B0701CDE82F0B63', '21F34EDE65944594B831C9C271CDFB5C', '2E009837AA2346CFAC4D9FA17F17EEC3', '1B57A97ABD10450C960D899EC13A731F', '99A1445D5D134414AA422BE0E98C8C2C', '84E6471E0F004E6E92C13D2B3B3BCD0A', '6676F03C94A542DE8509817397097DBF', '2B7A906A597947838EECA2654212317C', 'F280622215024E1286F19C35CEDA0453', 'DABAC61D31794EDAB32F6C69104F75FD', 'AAEAC087CA884CFCAC2CF87E39924DBB', 'A48627871CB54ED08A67C40909636D01', '9FEF5B4CBDDC4D65BD63ED0DD6D8FD50', '9218D93C86274DB0AA06E845880FB4FC', '60481CEE31B044448DC6AF9B3FBFCAB2', '58E07566EC924698B7D95BE49E1D92F5', '401D873274EB4EF6A410D50AE461C241', '11FCD6556C434324A86031923F0961E6', 'E0350B98AAE442D5A41BA3564548D89F', 'AAE437121C4446D5BC8A45596DA072BF', '4CBB8E46E4794A149091D1881E491B24', '2545EAE6A58948AD90C7F8F5A6E66C1A', '1C599D230970405697B367091CE5FE1F', 'F2D26CDFE60E4D0695BAF8F93B78D9D9', 'F153F412C73B4CD18138BF307DD94C54', 'EDB716CEA1AC4288BFB7C35563E5516E', 'C5D9FED3CF78462AA6F439EFA589ABCA', '4BFA8812B61F45E888DDFDF252EE98EE', '1FA8F76153BB44D894ED731F37B85E46', 'C9935BE6C4914780B28B5922DD68F96B', 'BE691CDE89754B9691748897DD0FA5AF', 'A015E4739B6944918AFB34B1E17064B2', '9CF58A8EF50749888D945DF502C2F0FA', '5975258B3B7046728118B387C2DC837B'); [ Date: 2026-07-16 09:06:58 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
12	16s847ms	delete from C_OrderLine where C_OrderLine_ID = '66FF1EA20378407E8294577632C2039A'; [ Date: 2026-07-16 07:50:48 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
13	15s836ms	SELECT * FROM ( select j.GL_JOURNAL_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'G/L JOURNAL DOCUMENT POSTED MORE THAN ONCE' as description, 'Y' as isActive, j.ad_org_id, j.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('GL_JOURNAL', j.GL_JOURNAL_id, 'es_ES') AS RECORD_ID FROM GL_JOURNAL j, fact_acct f1, fact_acct f2 where f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id and j.gl_journal_id = f1.record_id group by f1.ad_table_id, f1.record_id, j.gl_journal_id, j.ad_org_id, j.ad_client_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '5DB4719C9B154DA3A584345DD754189D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date: 2026-07-16 12:16:30 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
14	14s894ms	select a.id, ev.value as account_id, COALESCE(ev_trl.name, ev.name) as name, a.initialamt as SALDO_INICIAL, a.amtacctcr, a.amtacctdr, A.INITIALAMT + A.AMTACCTDR - A.AMTACCTCR AS SALDO_FINAL, a.groupbyid, CASE ad_column_identifier ('',groupbyid,TO_CHAR('es_ES')) WHEN '' THEN '' ELSE ad_column_identifier ('',groupbyid,TO_CHAR('es_ES')) END AS groupbyname from( SELECT sum(case when (DATEACCT < TO_DATE('01-01-2026') or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = 'O')) then F.AMTACCTDR - F.AMTACCTCR else 0 end) as initialamt, sum(case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTDR else 0 end) as AMTACCTDR, sum(case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTCR else 0 end) as AMTACCTCR, F.ACCOUNT_ID AS ID, to_char('') AS groupbyid FROM FACT_ACCT F WHERE F.AD_ORG_ID IN ('9DFF9C5278274C2DA3F411C2BA23605C', '975163BBDF184727BFA9D21FECF88F51', '8997B74B935D46B08D5E187F5B343F48', '7EEF753D8C114D32A101EA8393FEAC19', '0145CB12BBE04855B3C433728BD65F7C', '0') AND F.AD_CLIENT_ID IN ('0', '29E43D204AEB4CEC9D1DC4EFFD0E5987') AND F.AD_ORG_ID IN ('9DFF9C5278274C2DA3F411C2BA23605C', '975163BBDF184727BFA9D21FECF88F51', '8997B74B935D46B08D5E187F5B343F48', '7EEF753D8C114D32A101EA8393FEAC19', '0145CB12BBE04855B3C433728BD65F7C', '0') AND DATEACCT < TO_DATE('01-06-2026') AND 1 = 1 AND F.C_ACCTSCHEMA_ID = '07852E85025D4759A77318FB991C7B8F' AND F.ISACTIVE = 'Y' group by F.ACCOUNT_ID) a LEFT JOIN c_elementvalue ev ON a.id = ev.c_elementvalue_id LEFT JOIN c_elementvalue_trl ev_trl ON ev.c_elementvalue_id = ev_trl.c_elementvalue_id AND ev_trl.ad_language = 'es_ES' WHERE ev.elementlevel = 'S' AND 2 = 2 AND EV.VALUE >= '572000000' AND EV.VALUE <= '573000003' and (a.initialamt <> 0 or a.amtacctcr <> 0 or a.amtacctdr <> 0) order by ev.value, ev.name, id, groupbyname; [ Date: 2026-07-16 12:22:25 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query:** yes ]
15	14s834ms	select order0_.C_Order_ID as c_order_1_260_, order0_.AD_Client_ID as ad_clien2_260_, order0_.AD_Org_ID as ad_org_i3_260_, order0_.IsActive as isactive4_260_, order0_.Created as created5_260_, order0_.CreatedBy as createdb6_260_, order0_.Updated as updated7_260_, order0_.UpdatedBy as updatedb8_260_, order0_.IsSOTrx as issotrx9_260_, order0_.DocumentNo as documen10_260_, order0_.DocStatus as docstat11_260_, order0_.DocAction as docacti12_260_, order0_.Processing as process13_260_, order0_.Processed as process14_260_, order0_.C_DocType_ID as c_docty15_260_, order0_.C_DocTypeTarget_ID as c_docty16_260_, order0_.Description as descrip17_260_, order0_.IsDelivered as isdeliv18_260_, order0_.IsInvoiced as isinvoi19_260_, order0_.IsPrinted as isprint20_260_, order0_.IsSelected as isselec21_260_, order0_.SalesRep_ID as salesre22_260_, order0_.DateOrdered as dateord23_260_, order0_.DatePromised as datepro24_260_, order0_.DatePrinted as datepri25_260_, order0_.DateAcct as dateacc26_260_, order0_.C_BPartner_ID as c_bpart27_260_, order0_.BillTo_ID as billto_28_260_, order0_.C_BPartner_Location_ID as c_bpart29_260_, order0_.POReference as porefer30_260_, order0_.IsDiscountPrinted as isdisco31_260_, order0_.C_Currency_ID as c_curre32_260_, order0_.PaymentRule as payment33_260_, order0_.C_PaymentTerm_ID as c_payme34_260_, order0_.InvoiceRule as invoice35_260_, order0_.DeliveryRule as deliver36_260_, order0_.FreightCostRule as freight37_260_, order0_.FreightAmt as freight38_260_, order0_.DeliveryViaRule as deliver39_260_, order0_.M_Shipper_ID as m_shipp40_260_, order0_.C_Charge_ID as c_charg41_260_, order0_.ChargeAmt as chargea42_260_, order0_.PriorityRule as priorit43_260_, order0_.TotalLines as totalli44_260_, order0_.GrandTotal as grandto45_260_, order0_.M_Warehouse_ID as m_wareh46_260_, order0_.M_PriceList_ID as m_price47_260_, order0_.IsTaxIncluded as istaxin48_260_, order0_.C_Campaign_ID as c_campa49_260_, order0_.C_Project_ID as c_proje50_260_, order0_.C_Activity_ID as c_activ51_260_, order0_.Posted as posted52_260_, order0_.AD_User_ID as ad_user53_260_, order0_.CopyFrom as copyfro54_260_, order0_.DropShip_BPartner_ID as dropshi55_260_, order0_.DropShip_Location_ID as dropshi56_260_, order0_.DropShip_User_ID as dropshi57_260_, order0_.IsSelfService as isselfs58_260_, order0_.AD_OrgTrx_ID as ad_orgt59_260_, order0_.User1_ID as user60_260_, order0_.User2_ID as user61_260_, order0_.Deliverynotes as deliver62_260_, order0_.C_Incoterms_ID as c_incot63_260_, order0_.Incotermsdescription as incoter64_260_, order0_.Generatetemplate as generat65_260_, order0_.Delivery_Location_ID as deliver66_260_, order0_.CopyFromPO as copyfro67_260_, order0_.EM_Psmad_Copyfrompo as em_psma68_260_, order0_.FIN_Paymentmethod_ID as fin_pay69_260_, order0_.EM_Psmad_Dateendeffect as em_psma70_260_, order0_.FIN_Payment_Priority_ID as fin_pay71_260_, order0_.EM_Psmad_Requestinguser as em_psma72_260_, order0_.RM_PickFromShipment as rm_pick73_260_, order0_.EM_Psmad_Isopenpo_Doctype as em_psma74_260_, order0_.RM_ReceiveMaterials as rm_rece75_260_, order0_.EM_Erpmag_Ecomord as em_erpm76_260_, order0_.EM_Obcma_C_Poc_Email_ID as em_obcm77_260_, order0_.RM_CreateInvoice as rm_crea78_260_, order0_.C_Return_Reason_ID as c_retur79_260_, order0_.RM_AddOrphanLine as rm_addo80_260_, order0_.A_Asset_ID as a_asset81_260_, order0_.Calculate_Promotions as calcula82_260_, order0_.C_Costcenter_ID as c_costc83_260_, order0_.Convertquotation as convert84_260_, order0_.C_Reject_Reason_ID as c_rejec85_260_, order0_.validuntil as validun86_260_, order0_.Quotation_ID as quotati87_260_, order0_.SO_Res_Status as so_res_88_260_, order0_.Create_POLines as create_89_260_, order0_.Iscashvat as iscashv90_260_, order0_.EM_OBMFM_Selectfreight as em_obmf91_260_, order0_.EM_OBMFM_Delivery_Period_ID as em_obmf92_260_, order0_.RM_Pickfromreceipt as rm_pick93_260_, order0_.Cancelandreplace as cancela94_260_, order0_.EM_APRM_AddPayment as em_aprm95_260_, order0_.EM_OBMFM_Delivery_Charges as em_obmf96_260_, order0_.EM_OBMFM_Freight_ID as em_obmf97_260_, order0_.EM_Obwpl_Generatepicking as em_obwp98_260_, order0_.EM_Libp_Preporder as em_libp99_260_, order0_.EM_OBMFM_Weight as em_obm100_260_, order0_.EM_Obwpl_Isinpickinglist as em_obw101_260_, order0_.EM_Obwpl_Readypl as em_obw102_260_, order0_.EM_OBMFM_Weight_Uom_ID as em_obm103_260_, order0_.EM_OBMFM_Set_Weight as em_obm104_260_, order0_.EM_Aeatsii_Fecha_Operacion as em_aea105_260_, order0_.Confirmcancelandreplace as confir106_260_, order0_.EM_Aeatsii_Descripcion_Sii as em_aea107_260_, order0_.EM_Etabam_Bankaccount_ID as em_eta108_260_, order0_.EM_Etpr_Remove_Payment as em_etp109_260_, order0_.EM_Etvfac_Reversed_Invoice as em_etv110_260_, order0_.Cancelledorder_id as cancel111_260_, order0_.EM_Etblkc_Bulkcompletion as em_etb112_260_, order0_.EM_Prmag2_Grandtotal as em_prm113_260_, order0_.Replacedorder_id as replac114_260_, order0_.Iscancelled as iscanc115_260_, order0_.EM_Libd_Revisionfactura as em_lib116_260_, order0_.EM_Obmag_Createquot as em_obm117_260_, order0_.EM_Libd_Revisaimpuestos as em_lib118_260_, order0_.Replacementorder_ID as replac119_260_, order0_.EM_Libd_Impuestos as em_lib120_260_, order0_.EM_Etafdp_Undoclose as em_eta121_260_, order0_.EM_Libd_Isprinted as em_lib122_260_, order0_.EM_Etinter_Interco_Orig as em_eti123_260_, order0_.EM_Libd_Aplicacion_ID as em_lib124_260_, order0_.BPartner_ExtRef as bpartn125_260_, order0_.EM_Libp_Dateorder as em_lib126_260_, order0_.EM_Prouti_Order_Stock as em_pro127_260_, order0_.EM_Prouti_Pregenerate_Minout as em_pro128_260_, order0_.EM_Prouti_Sotopo as em_pro129_260_, order0_.EM_Prouti_Generate_Pick_Inv as em_pro130_260_, order0_.EM_Prouti_Order_ID as em_pro131_260_, order0_.EM_Prouti_Grandtotalinitial as em_pro132_260_, order0_.EM_Prouti_Dateclosed as em_pro133_260_, order0_.EM_Prouti_Totallinesinitial as em_pro134_260_, order0_.EM_Prouti_Changebpartner as em_pro135_260_, order0_.EM_Prouti_Recalculate_Price as em_pro136_260_, order0_.EM_Prouti_Pricecalculatetdate as em_pro137_260_, order0_.EM_Prouti_Reactiveorder as em_pro138_260_, order0_.EM_Prouti_Totalizations as em_pro139_260_, order0_.EM_Libd_Bpartner_Parent_ID as em_lib140_260_, order0_.em_prouti_Invoiced as em_pro141_260_, order0_.EM_Libd_usercloud as em_lib142_260_, order0_.em_prouti_Received as em_pro143_260_, order0_.EM_Libd_Id_Purchase as em_lib144_260_, order0_.em_prouti_initial_received as em_pro145_260_, order0_.EM_Libd_Convertquotation as em_lib146_260_, order0_.EM_Prouti_Status_Of_Review as em_pro147_260_, order0_.EM_Libd_Duplicatequotation as em_lib148_260_, order0_.EM_Prouti_Validate_Order as em_pro149_260_, order0_.EM_Libd_Endcustomer_ID as em_lib150_260_, order0_.EM_Prouti_Start_Review as em_pro151_260_, order0_.EM_Libd_Editing as em_lib152_260_, order0_.EM_Prouti_Initial_Bp_ID as em_pro153_260_, order0_.EM_Prouti_Addlines_Btn as em_pro154_260_, order0_.EM_Prouti_Changebpartner_Bgt as em_pro155_260_, order0_.EM_Pruti_Ignoreminqty as em_pru156_260_, order0_.EM_Prouti_Reset_Initial_Values as em_pro157_260_, order0_.EM_Prouti_Select_Soline as em_pro158_260_, order0_.EM_Prouti_Return_Quantity as em_pro159_260_, order0_.EM_Libd_Actions_Quotation as em_lib160_260_ from C_Order order0_ inner join C_DocType documentty1_ on order0_.C_DocTypeTarget_ID = documentty1_.C_DocType_ID cross join C_Order order_comp2_ where order0_.C_Order_ID = order_comp2_.C_Order_ID and (coalesce(( select case when sum(abs(ol.qtyordered)) = 0 or order_comp2_.iscancelled = 'Y' or order_comp2_.cancelledorder_id is not null then 0 else round(coalesce(sum(abs(ol.qtydelivered)), 0) / sum(abs(ol.qtyordered)) * 100, 0) end from c_orderline ol where ol.c_order_id = order_comp2_.c_order_id and ol.c_order_discount_id is null), 0)) < '100' and order0_.EM_Libp_Preporder = 'Y' and (documentty1_.C_DocType_ID = '93B1C21D229E4F70918287DA983CB18E' or documentty1_.C_DocType_ID = '7C1C60D646A84C0CA252F50CE8F55D6F' or documentty1_.C_DocType_ID = '5AC9E2D9DAB44BF9A2069BB51E1145DF') and order0_.DocStatus = 'CO' and order0_.IsSOTrx = 'Y' and documentty1_.IsReturn = 'N' and (documentty1_.DocSubTypeSO not like 'OB') and (order0_.AD_Org_ID in ('0', '975163BBDF184727BFA9D21FECF88F51', '0145CB12BBE04855B3C433728BD65F7C', '7EEF753D8C114D32A101EA8393FEAC19', '8997B74B935D46B08D5E187F5B343F48', '9DFF9C5278274C2DA3F411C2BA23605C')) and (order0_.AD_Client_ID in ('29E43D204AEB4CEC9D1DC4EFFD0E5987', '0')) order by order0_.DateOrdered desc, order0_.C_Order_ID desc limit '101'; [ Date: 2026-07-16 07:12:11 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
16	13s955ms	SELECT * FROM ( select record_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED PURCHASE INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('API', 'APC') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'DC1924997FC3426989EDC0910711A426' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date: 2026-07-16 12:15:19 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
17	13s620ms	delete from C_OrderLine where C_OrderLine_ID = '7D5E16B9DBCD4BE19677DE58410B937C'; [ Date: 2026-07-16 09:14:22 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
18	12s136ms	SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'F2C188AA7FF14438B4012EC2DDCA91F3' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date: 2026-07-16 12:15:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
19	11s59ms	SELECT profile.take_sample (); [ Date: 2026-07-16 14:00:12 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
20	10s665ms	delete from C_OrderLine where C_OrderLine_ID = 'DCD64B9503234708BEAE1176F8A90C84'; [ Date: 2026-07-16 13:16:54 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

Time consuming queries (N)


[ User: tad - Total duration: 6m8s - Times executed: 3 ]
[ User: tad - Total duration: 2m36s - Times executed: 16 ]
[ User: tad - Total duration: 1m40s - Times executed: 10 ]
[ User: postgres - Total duration: 1m3s - Times executed: 15 ]
[ User: tad - Total duration: 56s737ms - Times executed: 6 ]
[ User: tad - Total duration: 31s453ms - Times executed: 5 ]
[ User: tad - Total duration: 27s533ms - Times executed: 6 ]
[ User: tad - Total duration: 20s712ms - Times executed: 3 ]
[ User: tad - Total duration: 20s380ms - Times executed: 3 ]
[ User: tad - Total duration: 18s119ms - Times executed: 3 ]
[ User: tad - Total duration: 15s931ms - Times executed: 3 ]
[ User: tad - Total duration: 15s722ms - Times executed: 3 ]
[ User: tad - Total duration: 14s834ms - Times executed: 1 ]
[ User: tad - Total duration: 9s785ms - Times executed: 6 ]
[ User: tad - Total duration: 6s712ms - Times executed: 2 ]
[ User: tad - Total duration: 6s51ms - Times executed: 3 ]
[ User: tad - Total duration: 6s2ms - Times executed: 3 ]
[ User: tad - Total duration: 5s945ms - Times executed: 3 ]
[ User: tad - Total duration: 3s666ms - Times executed: 2 ]
[ User: tad - Total duration: 3s548ms - Times executed: 1 ]

Most frequent queries (N)


[ User: tad - Total duration: 2m36s - Times executed: 16 ]
[ User: postgres - Total duration: 1m3s - Times executed: 15 ]
[ User: tad - Total duration: 1m40s - Times executed: 10 ]
[ User: tad - Total duration: 56s737ms - Times executed: 6 ]
[ User: tad - Total duration: 27s533ms - Times executed: 6 ]
[ User: tad - Total duration: 9s785ms - Times executed: 6 ]
[ User: tad - Total duration: 31s453ms - Times executed: 5 ]
[ User: tad - Total duration: 6m8s - Times executed: 3 ]
[ User: tad - Total duration: 20s712ms - Times executed: 3 ]
[ User: tad - Total duration: 20s380ms - Times executed: 3 ]
[ User: tad - Total duration: 18s119ms - Times executed: 3 ]
[ User: tad - Total duration: 15s931ms - Times executed: 3 ]
[ User: tad - Total duration: 15s722ms - Times executed: 3 ]
[ User: tad - Total duration: 6s51ms - Times executed: 3 ]
[ User: tad - Total duration: 6s2ms - Times executed: 3 ]
[ User: tad - Total duration: 5s945ms - Times executed: 3 ]
[ User: tad - Total duration: 6s712ms - Times executed: 2 ]
[ User: tad - Total duration: 3s666ms - Times executed: 2 ]
[ User: tad - Total duration: 3s528ms - Times executed: 2 ]
[ User: tad - Total duration: 3s442ms - Times executed: 2 ]

Normalized slowest queries (N)


[ User: tad - Total duration: 6m8s - Times executed: 3 ]
[ User: tad - Total duration: 14s834ms - Times executed: 1 ]
[ User: tad - Total duration: 1m40s - Times executed: 10 ]
[ User: tad - Total duration: 2m36s - Times executed: 16 ]
[ User: tad - Total duration: 56s737ms - Times executed: 6 ]
[ User: tad - Total duration: 20s712ms - Times executed: 3 ]
[ User: tad - Total duration: 20s380ms - Times executed: 3 ]
[ User: tad - Total duration: 31s453ms - Times executed: 5 ]
[ User: tad - Total duration: 18s119ms - Times executed: 3 ]
[ User: tad - Total duration: 15s931ms - Times executed: 3 ]
[ User: tad - Total duration: 15s722ms - Times executed: 3 ]
[ User: tad - Total duration: 27s533ms - Times executed: 6 ]
[ User: postgres - Total duration: 1m3s - Times executed: 15 ]
[ User: tad - Total duration: 3s548ms - Times executed: 1 ]
[ User: tad - Total duration: 6s712ms - Times executed: 2 ]
[ User: tad - Total duration: 6s51ms - Times executed: 3 ]
[ User: tad - Total duration: 6s2ms - Times executed: 3 ]
[ User: tad - Total duration: 5s945ms - Times executed: 3 ]
[ User: tad - Total duration: 3s666ms - Times executed: 2 ]
[ User: tad - Total duration: 3s528ms - Times executed: 2 ]

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

89,788 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	17	0.02%
DETAIL	97	0.11%
ERROR	19	0.02%
EVENTLOG	8,770	9.77%
LOG	80,849	90.04%
STATEMENT	36	0.04%

Events distribution (except queries)

Key values

0 PANIC entries
0 FATAL entries
19 ERROR entries
0 WARNING entries
8770 EVENTLOG entries

Most Frequent Errors/Events

Key values

8,740 Max number of times the same event was reported
8,789 Total events found


Date: 2026-07-16 07:00:02
Database: etendo
Application: [unknown]
User: tad
Remote: 10.10.11.43
Date: 2026-07-16 07:00:22
Database: etendo
Application: [unknown]
User: tad
Remote: 10.10.11.43
Date: 2026-07-16 08:00:48
Database: etendo
Application: [unknown]
User: tad
Remote: 172.30.3.29
Date: 2026-07-16 13:05:11
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1
Date: 2026-07-16 09:13:26
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1
Date: 2026-07-16 10:26:12
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1
Date: 2026-07-16 11:23:38
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1
Date: 2026-07-16 17:36:50
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1
Date: 2026-07-16 07:27:03
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1

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

Checkpoint causes

Key values

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

Average Autovacuum Duration

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Vacuum throughput per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Pages removed per tables

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