pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Fri Jul 17 23:00:39 2026
Log file: /var/log/postgresql/postgresql-16-main.log
Parsed 137,920 log entries in 37s
Log start from 2026-07-17 07:00:01 to 2026-07-17 21:59:55

Global Stats

43 Number of unique normalized queries
146 Number of queries
24m39s Total query duration
2026-07-17 07:00:06 First query
2026-07-17 21:00:05 Last query
2 queries/s at 2026-07-17 13:34:27 Query peak

24m39s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
24m39s Execute total duration

8,780 Number of events
3 Number of unique normalized events
8,743 Max number of times the same event was reported
0 Number of cancellation

45,902 Total number of automatic vacuums
163 Total number of automatic analyzes

25 Number temporary file
215.11 MiB Max size of temporary file
93.20 MiB Average size of temporary file

8,836 Total number of sessions
7 sessions at 2026-07-17 09:32:08 Session peak
3d20h21m21s Total duration of sessions
37s628ms Average duration of sessions
0 Average queries per session
167ms Average queries duration per session
37s460ms Average idle time per session

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

SQL Traffic

Key values

2 queries/s Query Peak
2026-07-17 13:34:27 Date

SELECT Traffic

Key values

2 queries/s Query Peak
2026-07-17 13:34:27 Date

INSERT/UPDATE/DELETE Traffic

Key values

1 queries/s Query Peak
2026-07-17 13:16:13 Date

Queries duration

Key values

24m39s 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 17	07	6	0ms	6s354ms	3s219ms	1s118ms	2s636ms	6s354ms
	08	5	0ms	5s254ms	2s272ms	0ms	1s311ms	5s254ms
	09	4	0ms	7s945ms	2s932ms	0ms	1s208ms	7s945ms
	10	7	0ms	15s971ms	4s94ms	1s345ms	3s275ms	15s971ms
	11	6	0ms	6s451ms	2s413ms	1s16ms	1s609ms	6s451ms
	12	34	0ms	24s878ms	4s662ms	3s141ms	8s573ms	1m15s
	13	22	0ms	2m52s	26s660ms	3s412ms	2m55s	3m3s
	14	6	0ms	2m39s	28s800ms	0ms	1s126ms	2m46s
	15	24	0ms	2m51s	11s160ms	3s206ms	24s841ms	2m57s
	16	9	0ms	27s373ms	6s688ms	1s16ms	4s979ms	27s373ms
	17	7	0ms	29s713ms	10s740ms	0ms	7s194ms	33s238ms
	18	1	0ms	6s914ms	6s914ms	0ms	0ms	6s914ms
	19	1	0ms	2s651ms	2s651ms	0ms	0ms	2s651ms
	20	13	0ms	13s420ms	4s540ms	0ms	6s67ms	44s743ms
	21	1	0ms	3s849ms	3s849ms	0ms	0ms	3s849ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 17	07	6	3s219ms	0ms	1s118ms	5s684ms
	08	5	2s272ms	0ms	0ms	4s795ms
	09	4	2s932ms	0ms	0ms	1s428ms
	10	6	2s114ms	0ms	1s147ms	3s275ms
	11	6	2s413ms	0ms	1s16ms	2s772ms
	12	27	4s169ms	1s221ms	2s804ms	35s236ms
	13	17	32s809ms	0ms	1s417ms	2m57s
	14	6	28s800ms	0ms	0ms	3s794ms
	15	19	13s350ms	0ms	3s206ms	42s606ms
	16	4	2s64ms	0ms	0ms	2s261ms
	17	6	12s134ms	0ms	0ms	32s374ms
	18	1	6s914ms	0ms	0ms	0ms
	19	1	2s651ms	0ms	0ms	0ms
	20	10	4s965ms	0ms	0ms	7s195ms
	21	1	3s849ms	0ms	0ms	0ms

Day	Hour	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 17	07	0	0	0ms	0ms	0ms	0ms
	08	0	0	0ms	0ms	0ms	0ms
	09	0	0	0ms	0ms	0ms	0ms
	10	0	1	15s971ms	0ms	0ms	0ms
	11	0	0	0ms	0ms	0ms	0ms
	12	5	2	6s565ms	0ms	0ms	6s773ms
	13	0	5	5s756ms	0ms	0ms	0ms
	14	0	0	0ms	0ms	0ms	0ms
	15	5	0	2s836ms	0ms	0ms	0ms
	16	0	5	10s387ms	0ms	0ms	2s265ms
	17	0	1	2s371ms	0ms	0ms	0ms
	18	0	0	0ms	0ms	0ms	0ms
	19	0	0	0ms	0ms	0ms	0ms
	20	3	0	3s125ms	0ms	0ms	0ms
	21	0	0	0ms	0ms	0ms	0ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
Jul 17	07	5	5.00	0.00%
	08	4	4.00	0.00%
	09	3	3.00	0.00%
	10	6	6.00	0.00%
	11	5	5.00	0.00%
	12	33	33.00	0.00%
	13	21	21.00	0.00%
	14	5	5.00	0.00%
	15	23	23.00	0.00%
	16	8	8.00	0.00%
	17	6	6.00	0.00%
	18	0	0.00	0.00%
	19	0	0.00	0.00%
	20	12	12.00	0.00%
	21	0	0.00	0.00%

Day	Hour	Count	Average / Second
Jul 17	07	590	0.16/s
	08	589	0.16/s
	09	593	0.16/s
	10	590	0.16/s
	11	584	0.16/s
	12	594	0.17/s
	13	590	0.16/s
	14	589	0.16/s
	15	588	0.16/s
	16	589	0.16/s
	17	587	0.16/s
	18	589	0.16/s
	19	588	0.16/s
	20	587	0.16/s
	21	590	0.16/s

Day	Hour	Count	Average Duration	Average idle time
Jul 17	07	590	243ms	210ms
	08	588	228ms	208ms
	09	593	1s620ms	1s600ms
	10	590	1m10s	1m10s
	11	584	265ms	240ms
	12	594	6m53s	6m52s
	13	590	7s405ms	6s411ms
	14	589	12s836ms	12s542ms
	15	588	53s446ms	52s991ms
	16	588	242ms	140ms
	17	588	232ms	104ms
	18	589	217ms	205ms
	19	588	201ms	197ms
	20	587	201ms	101ms
	21	590	210ms	203ms

↑ Back to the top of the General Activity table

Established Connections

Key values

4 connections Connection Peak
2026-07-17 07:00:01 Date

Connections per database

Key values

etendo Main Database
8,837 connections Total

Chart
Table

Database	User	Count
etendo		8,819
	postgres	45
	tad	8,774
postgres		18
	postgres	15
	tad	3

Connections per user

Key values

tad Main User
8,837 connections Total

Chart
Table

User	Count
postgres	60
tad	8,777

Connections per host

Key values

10.10.11.43 Main host with 8744 connections
8,837 Total connections

Chart
Table

Host	Count
10.10.11.43	8,744
127.0.0.1	26
172.30.3.29	7
[local]	60

Simultaneous sessions

Key values

7 sessions Session Peak
2026-07-17 09:32:08 Date

Histogram of session times

Key values

8,485 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	8,485	96.03%
500ms-1s	236	2.67%
1s-30s	91	1.03%
30s-1m	0	0.00%
1m-10m	13	0.15%
10m-30m	1	0.01%
30m-1h	1	0.01%
1h-8h	5	0.06%
> 8h	4	0.05%

Sessions per database

Key values

etendo Main Database
8,836 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
etendo	8,818	3d20h16m46s	37s673ms
postgres	18	4m35s	15s302ms

Sessions per user

Key values

tad Main User
8,836 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
postgres	60	2m15s	2s259ms
tad	8,776	3d20h19m6s	37s869ms

Sessions per host

Key values

10.10.11.43 Main Host
8,836 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.11.43	8,744	32m51s	225ms
127.0.0.1	25	3d19h46m14s	3h40m14s
172.30.3.29	7	376ms	53ms
[local]	60	2m15s	2s259ms

Sessions per application

Key values

[unknown] Main Application
8,836 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
DBeaver 26.0.1 - Main	1	2m13s	2m13s
DBeaver 26.0.1 - Main	1	2m17s	2m17s
DBeaver 26.0.1 - Metadata	1	2m12s	2m12s
DBeaver 26.0.1 - Metadata	1	2m16s	2m16s
DBeaver 26.0.1 - Read PostgreSQL database list	1	857ms	857ms
DBeaver 26.0.1 - SQLEditor	1	2m14s	2m14s
DBeaver 26.0.1 - SQLEditor	1	2m9s	2m9s
[unknown]	8,751	32m51s	225ms
openbravo	18	3d19h32m49s	5h5m9s
pg_profile	45	58s465ms	1s299ms
psql	15	1m17s	5s141ms

Checkpoints Buffers

Key values

3,478 buffers Checkpoint Peak
2026-07-17 12:07:07 Date
269.875 seconds Highest write time
0.021 seconds Sync time

Checkpoints Wal files

Key values

2 files Wal files usage Peak
2026-07-17 13:17:08 Date

Checkpoints distance

Key values

45.26 Mo Distance Peak
2026-07-17 12:07:07 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jul 17	07	2,389	238.04s	0.055s	238.313s
	08	2,595	258.135s	0.059s	258.442s
	09	6,332	596.779s	0.048s	597.069s
	10	5,503	547.687s	0.063s	548.028s
	11	3,290	328.642s	0.057s	329.006s
	12	9,239	843.527s	0.068s	843.919s
	13	9,060	840.268s	0.056s	840.644s
	14	8,188	817.074s	0.073s	817.431s
	15	7,180	739.212s	0.076s	739.566s
	16	3,599	357.777s	0.062s	358.086s
	17	5,667	540.453s	0.061s	540.799s
	18	2,667	265.423s	0.049s	265.701s
	19	2,093	208.32s	0.064s	208.633s
	20	2,748	274.081s	0.051s	274.353s
	21	4,895	462.254s	0.047s	462.533s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jul 17	07	1	501	0.013s	0.012s
	08	1	616	0.005s	0.012s
	09	2	826	0.004s	0.012s
	10	2	1,123	0.007s	0.012s
	11	2	707	0.007s	0.012s
	12	3	2,356	0.006s	0.012s
	13	4	1,834	0.004s	0.012s
	14	3	1,845	0.006s	0.012s
	15	2	1,376	0.005s	0.012s
	16	2	812	0.005s	0.012s
	17	2	563	0.013s	0.012s
	18	1	375	0.004s	0.012s
	19	1	316	0.017s	0.013s
	20	1	313	0.005s	0.012s
	21	2	340	0.004s	0.012s

Day	Hour	Avg time (sec)
Jul 17	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 17	07	1,320.17 kB	8,072.50 kB
	08	1,525.42 kB	8,764.33 kB
	09	3,362.00 kB	12,532.25 kB
	10	2,831.50 kB	12,132.75 kB
	11	1,849.50 kB	10,121.08 kB
	12	4,635.83 kB	14,977.92 kB
	13	4,673.08 kB	14,003.92 kB
	14	4,100.33 kB	13,176.58 kB
	15	3,726.25 kB	11,425.42 kB
	16	2,140.75 kB	11,295.67 kB
	17	3,092.67 kB	12,219.92 kB
	18	1,642.08 kB	11,281.17 kB
	19	1,306.58 kB	8,672.08 kB
	20	1,521.42 kB	10,328.83 kB
	21	2,670.08 kB	11,626.08 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (180) Main checkpoint cause
180 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	180
Total	180

Size of temporary files

Key values

264.50 MiB Temp Files size Peak
2026-07-17 20:20:21 Date

Number of temporary files

Key values

2 per second Temp Files Peak
2026-07-17 12:16:17 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jul 17	07	0	0	0
	08	0	0	0
	09	0	0	0
	10	1	15.00 MiB	15.00 MiB
	11	0	0	0
	12	8	771.57 MiB	96.45 MiB
	13	0	0	0
	14	0	0	0
	15	8	771.69 MiB	96.46 MiB
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	8	771.69 MiB	96.46 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.11 MiB	103.61 MiB	select * from ( select c_invoice_id as referencekey_id, ; SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; Date: 2026-07-17 12:15:49 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
2	6	749.70 MiB	34.78 MiB	215.11 MiB	124.95 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-17 15:26:01 Duration: 7s916ms 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-17 12:16:25 Duration: 7s619ms 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-17 20:20:42 Duration: 6s326ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
3	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-17 12:15:52 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
4	1	15.00 MiB	15.00 MiB	15.00 MiB	15.00 MiB	select orderline0_.m_product_id as col_0_0_, product1_.name as col_1_0_, sum(orderline0_.qtyordered) as col_2_0_, uom3_.name as col_3_0_, product1_.c_uom_id as col_4_0_ from c_orderline orderline0_ cross join m_product product1_ cross join c_uom uom3_ cross join c_order order5_ cross join m_product product7_ where orderline0_.m_product_id = product1_.m_product_id and product1_.c_uom_id = uom3_.c_uom_id and orderline0_.c_order_id = order5_.c_order_id and orderline0_.m_product_id = product7_.m_product_id and order5_.docstatus = ? and order5_.issotrx = ? and ? = ? and orderline0_.ad_client_id = ? and (product7_.name like ?) and (orderline0_.ad_org_id in (...)) group by product1_.name, uom3_.name, orderline0_.m_product_id, product1_.c_uom_id order by sum(orderline0_.qtyordered) desc limit ?; select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = '29E43D204AEB4CEC9D1DC4EFFD0E5987' and (product7_.Name like '%') and (orderline0_.AD_Org_ID in ('0', '975163BBDF184727BFA9D21FECF88F51', '0145CB12BBE04855B3C433728BD65F7C', '7EEF753D8C114D32A101EA8393FEAC19', '8997B74B935D46B08D5E187F5B343F48', '9DFF9C5278274C2DA3F411C2BA23605C')) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit '40'; Date: 2026-07-17 10:36:06 Duration: 1s535ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo

Queries generating the largest temporary files


[ Date: 2026-07-17 15:25:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 15:25:53 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 15:26:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 20:20:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 20:20:35 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 20:20:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 12:15:49 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 12:16:17 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 12:16:25 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 12:15:49 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 15:25:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 20:20:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 15:25:53 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 15:26:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 20:20:35 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 20:20:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 12:16:17 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 12:16:25 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 10:36:06 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 12:15:52 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

Rank	Size	Query
1	215.11 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-17 15:25:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2	215.11 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-17 15:25:53 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3	215.11 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-17 15:26:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4	215.11 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-17 20:20:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5	215.11 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-17 20:20:35 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
6	215.11 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-17 20:20:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
7	215.09 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-17 12:15:49 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8	215.09 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-17 12:16:17 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
9	215.09 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-17 12:16:25 - 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-17 12:15:49 - 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-17 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-17 20:20:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
13	34.80 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-17 15:25:53 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
14	34.80 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-17 15:26:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
15	34.80 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-17 20:20:35 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
16	34.80 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-17 20:20:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
17	34.78 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-17 12:16:17 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
18	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-17 12:16:25 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
19	15.00 MiB	select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = $1 and (product7_.Name like $2) and (orderline0_.AD_Org_ID in ($3, $4, $5, $6, $7, $8)) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit $9; [ Date: 2026-07-17 10:36:06 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
20	3.68 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-17 12:15:52 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

Vacuums / Analyzes Distribution

Key values

2.65 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo
2026-07-17 15:26:47 Date
0 sec Highest CPU-cost analyze
Table
Database etendo
Date

Average Autovacuum Duration

Key values

2.65 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo
2026-07-17 15:26:47 Date

Analyzes per table

Key values

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

Chart
Table

Table	Number of analyzes
etendo.public.ad_ep_instance_para	17
etendo.profile.last_stat_user_functions_srv1	15
etendo.profile.last_stat_tables_srv1	15
etendo.profile.last_stat_indexes_srv1	15
etendo.profile.last_stat_statements_srv1	15
etendo.profile.tables_list	12
etendo.public.ad_session	9
etendo.profile.last_stat_io	8
etendo.profile.indexes_list	7
etendo.profile.stmt_list	6
etendo.profile.funcs_list	6
etendo.profile.last_extension_versions	5
etendo.profile.last_stat_activity_count_srv1	5
etendo.profile.last_stat_slru	3
etendo.public.ad_sequence	2
etendo.profile.sample_stat_tables	2
etendo.public.ad_process_request	2
etendo.profile.sample_stat_indexes	2
etendo.profile.sample_statements	1
etendo.public.ad_preference	1
etendo.public.fin_financial_account	1
etendo.public.c_ordertax	1
etendo.public.ad_module	1
etendo.profile.sample_statements_total	1
etendo.public.ad_process_run	1
etendo.profile.sample_stat_indexes_total	1
etendo.profile.sample_stat_io	1
etendo.public.ad_pinstance	1
etendo.profile.sample_stat_tables_total	1
etendo.public.ad_pinstance_para	1
etendo.profile.sample_stat_user_functions	1
etendo.profile.sample_stat_tablespaces	1
etendo.profile.sample_stat_database	1
etendo.profile.sample_stat_slru	1
etendo.profile.sample_stat_user_func_total	1
Total	163

Vacuums per table

Key values

profile.sample_stat_io (899) Main table vacuumed on database etendo
45,902 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.profile.sample_stat_io	899	0	114,143	0	13	0	0	150	0	36,150	0	0
etendo.profile.sample_stat_indexes_total	899	0	73,990	0	15	0	0	150	0	36,150	0	0
etendo.pg_toast.pg_toast_85256	899	0	1,204,073	0	72	0	0	156	72	438,936	0	0
etendo.public.ad_module	899	0	318,759	0	87	0	0	157	72	432,709	4	4
etendo.profile.last_stat_indexes_srv1	899	0	72,604,241	0	81	0	0	242	81	454,018	0	0
etendo.profile.last_stat_tables_srv1	899	0	57,701,664	0	26	0	0	233	16	175,681	0	0
etendo.profile.last_stat_user_functions_srv1	899	0	5,904,007	0	0	0	0	227	0	107,371	0	0
etendo.public.ad_ep_instance_para	899	5	121,691	0	150	0	0	248	69	495,924	0	0
etendo.profile.last_stat_tablespaces_srv1	899	0	42,083	0	14	0	0	149	0	70,477	0	0
etendo.profile.sample_stat_wal	899	0	33,239	0	84	0	0	150	69	578,490	0	0
etendo.profile.sample_statements	899	0	1,914,752	0	0	0	0	187	0	45,067	0	0
etendo.profile.sample_stat_user_func_total	899	0	40,744	0	17	0	0	150	0	36,150	0	0
etendo.profile.last_stat_io	899	0	153,982	0	78	0	0	149	70	279,802	0	0
etendo.profile.sample_stat_cluster	899	0	37,148	0	15	0	0	150	0	36,150	0	0
etendo.profile.last_stat_archiver	899	0	27,869	0	45	0	0	149	0	28,012	0	0
etendo.profile.sample_stat_tables_total	899	0	192,389	0	12	0	0	150	0	36,150	0	0
etendo.profile.last_stat_database_srv1	899	0	95,012	0	60	0	0	149	58	307,813	0	0
etendo.profile.last_stat_wal	899	0	31,465	0	17	0	0	149	0	28,012	0	0
etendo.profile.funcs_list	899	0	513,011	0	2	0	0	151	0	36,391	0	0
etendo.profile.sample_stat_archiver	899	0	30,600	0	27	0	0	150	0	36,150	0	0
etendo.public.ad_process_run	899	0	1,936,397	0	224	0	0	354	105	867,138	0	0
etendo.public.c_invoice	899	0	13,941,586	0	89	0	0	347	76	580,401	93	410
etendo.public.ma_processplan_tot_aux	899	0	715,761	0	68	0	0	149	70	590,173	0	0
etendo.profile.last_extension_versions	899	0	78,960	0	63	0	0	149	58	251,254	0	0
etendo.profile.last_stat_activity_count_srv1	899	0	93,614	0	30	0	0	150	0	70,950	0	0
etendo.profile.sample_statements_total	899	0	81,110	0	15	0	0	150	0	36,150	0	0
etendo.profile.stmt_list	899	0	2,283,343	0	71	0	0	151	71	142,039	0	0
etendo.pg_toast.pg_toast_196728	899	0	477,808	0	15	0	0	151	12	107,264	0	0
etendo.profile.servers	899	0	46,150	0	85	0	0	164	71	435,398	15	15
etendo.profile.sample_stat_tables	899	0	4,190,936	0	4	0	0	163	4	70,723	0	0
etendo.profile.last_stat_statements_srv1	899	0	16,851,716	0	27	0	0	250	23	200,222	0	0
etendo.profile.last_stat_cluster	899	0	33,263	0	87	0	0	149	70	296,042	0	0
etendo.public.ad_sequence	899	0	140,172	0	44	0	0	151	0	38,807	0	0
etendo.profile.last_stat_slru	899	0	57,419	0	14	0	0	149	0	28,012	0	0
etendo.profile.tables_list	899	0	1,358,250	0	0	0	0	151	0	36,391	0	0
etendo.public.ad_preference	899	0	2,753,748	0	107	0	0	93	24	153,213	0	0
etendo.profile.sample_stat_slru	899	0	58,068	0	17	0	0	150	2	44,798	0	0
etendo.public.ad_session	899	0	1,616,470	0	256	0	0	448	107	951,354	5	5
etendo.profile.sample_stat_tablespaces	899	0	50,878	0	33	0	0	150	0	36,150	0	0
etendo.profile.sample_stat_database	899	0	141,565	0	13	0	0	150	0	36,150	0	0
etendo.profile.indexes_list	899	0	585,849	0	0	0	0	150	0	36,150	0	0
etendo.pg_catalog.pg_statistic	899	0	9,257,232	0	61	0	0	96	46	299,440	0	0
etendo.public.m_stock_proposed	899	0	110,714	0	68	0	0	149	70	556,293	0	0
etendo.pg_toast.pg_toast_2619	899	0	2,612,197	0	41	0	0	63	38	297,034	0	0
etendo.profile.sample_stat_user_functions	899	0	292,309	0	6	0	0	176	0	42,416	0	0
etendo.profile.sample_stat_indexes	899	0	613,881	0	10	0	0	181	10	122,221	0	0
etendo.public.ad_pinstance	899	3	147,378	0	103	0	0	352	76	493,118	32	56
etendo.profile.samples	899	0	48,546	0	15	0	0	150	0	36,150	0	0
etendo.public.ad_process_request	899	0	940,668	0	276	0	0	229	74	605,861	0	0
etendo.public.m_product_org	599	0	1,039,255	0	66	0	0	202	66	470,090	0	0
etendo.public.fin_financial_account	598	0	66,486	0	24	0	0	117	0	30,069	0	0
etendo.public.ad_pinstance_para	374	0	41,346	0	31	0	0	66	17	149,970	0	0
etendo.public.m_storage_pending	279	0	182,565	0	26	0	0	8	7	40,836	0	0
etendo.public.gl_journalbatch	1	0	91	0	11	0	0	1	1	6,233	0	0
Total	45,902	8	204,000,593	7,202,306	2,815	0	0	9,105	1,605	11,854,113	149	490

Vacuum throughput per table

Key values

profile.last_stat_indexes_srv1 (1007.61000000001) 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.profile.sample_stat_io	0	0	0.04
etendo.profile.sample_stat_indexes_total	0	0	0
etendo.pg_toast.pg_toast_85256	0	0	9.42999999999985
etendo.public.ad_module	0	0	0.05
etendo.profile.last_stat_indexes_srv1	0	0	1,007.61000000001
etendo.profile.last_stat_tables_srv1	0	0	815.980000000002
etendo.profile.last_stat_user_functions_srv1	0	0	81.140000000001
etendo.public.ad_ep_instance_para	0	0	0.04
etendo.profile.last_stat_tablespaces_srv1	0	0	0
etendo.profile.sample_stat_wal	0	0	0
etendo.profile.sample_statements	0	0	29.5
etendo.profile.sample_stat_user_func_total	0	0	0
etendo.profile.last_stat_io	0	0	0.01
etendo.profile.sample_stat_cluster	0	0	0
etendo.profile.last_stat_archiver	0	0	0
etendo.profile.sample_stat_tables_total	0	0	0.01
etendo.profile.last_stat_database_srv1	0	0	0
etendo.profile.last_stat_wal	0	0	0
etendo.profile.funcs_list	0	0	0.31
etendo.profile.sample_stat_archiver	0	0	0
etendo.public.ad_process_run	0	0	41.2399999999996
etendo.public.c_invoice	0	0	166.650000000002
etendo.public.ma_processplan_tot_aux	0	0	14.5099999999998
etendo.profile.last_extension_versions	0	0	0
etendo.profile.last_stat_activity_count_srv1	0	0	0
etendo.profile.sample_statements_total	0	0	0
etendo.profile.stmt_list	0	0	28.0300000000003
etendo.pg_toast.pg_toast_196728	0	0	0.06
etendo.profile.servers	0	0	0
etendo.profile.sample_stat_tables	0	0	84.4699999999993
etendo.profile.last_stat_statements_srv1	0	0	232.509999999998
etendo.profile.last_stat_cluster	0	0	0
etendo.public.ad_sequence	0	0	0.01
etendo.profile.last_stat_slru	0	0	0
etendo.profile.tables_list	0	0	15.3199999999998
etendo.public.ad_preference	0	0	28.0500000000003
etendo.profile.sample_stat_slru	0	0	0
etendo.public.ad_session	0	0	21.8399999999999
etendo.profile.sample_stat_tablespaces	0	0	0
etendo.profile.sample_stat_database	0	0	0
etendo.profile.indexes_list	0	0	1.71
etendo.pg_catalog.pg_statistic	0	0	132.790000000001
etendo.public.m_stock_proposed	0	0	0.01
etendo.pg_toast.pg_toast_2619	0	0	30.8800000000003
etendo.profile.sample_stat_user_functions	0	0	0.13
etendo.profile.sample_stat_indexes	0	0	9.58999999999985
etendo.public.ad_pinstance	0	0	0.04
etendo.profile.samples	0	0	0
etendo.public.ad_process_request	0	0	10.4199999999998
etendo.public.m_product_org	0	0	12.0599999999998
etendo.public.fin_financial_account	0	0	0
etendo.public.ad_pinstance_para	0	0	0
etendo.public.m_storage_pending	0	0	2.90999999999998
etendo.public.gl_journalbatch	0	0	0
Total	0	0	2,777.35000000001

Tuples removed per table

Key values

public.ad_pinstance (345) Main table with removed tuples on database etendo
485 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
etendo.public.ad_pinstance	899	3	345	2,408,405	1,150,834	0	117,769
etendo.public.ad_ep_instance_para	899	5	140	2,335,478	2,335,478	0	47,456
etendo.profile.sample_stat_io	899	0	0	2,095,656	1,058,508	0	55,738
etendo.public.gl_journalbatch	1	0	0	775	122	0	376
etendo.profile.sample_stat_indexes_total	899	0	0	1,208,240	603,392	0	17,081
etendo.pg_toast.pg_toast_85256	899	0	0	2,854,102	1,945,860	0	1,215,448
etendo.public.ad_module	899	0	0	1,533,358	1,158,815	0	202,275
etendo.profile.last_stat_indexes_srv1	899	0	0	905,318,541	901,526,316	0	52,515,984
etendo.profile.last_stat_tables_srv1	899	0	0	588,583,873	586,260,110	0	42,055,220
etendo.profile.last_stat_user_functions_srv1	899	0	0	92,421,204	91,706,084	0	4,227,997
etendo.public.fin_financial_account	598	0	0	91,957	62,655	0	22,724
etendo.profile.last_stat_tablespaces_srv1	899	0	0	302,056	300,258	0	7,192
etendo.profile.sample_stat_wal	899	0	0	302,060	150,848	0	5,394
etendo.profile.sample_statements	899	0	0	24,397,343	11,091,388	0	1,364,682
etendo.profile.sample_stat_user_func_total	899	0	0	604,120	301,696	0	6,293
etendo.profile.last_stat_io	899	0	0	1,963,364	1,951,677	0	61,132
etendo.profile.sample_stat_cluster	899	0	0	302,060	150,848	0	8,091
etendo.profile.last_stat_archiver	899	0	0	151,028	150,129	0	1,798
etendo.profile.sample_stat_tables_total	899	0	0	2,718,540	1,357,632	0	86,304
etendo.profile.last_stat_database_srv1	899	0	0	604,112	600,516	0	35,061
etendo.profile.last_stat_wal	899	0	0	151,028	150,129	0	3,596
etendo.profile.funcs_list	899	0	0	6,271,068	5,998,665	0	243,629
etendo.profile.sample_stat_archiver	899	0	0	302,060	150,848	0	3,596
etendo.public.ad_process_run	899	0	0	16,376,551	6,719,395	0	1,527,401
etendo.public.c_invoice	899	0	0	130,927,838	33,024,250	0	28,741,030
etendo.public.ma_processplan_tot_aux	899	0	0	19,576,624	9,788,312	0	489,955
etendo.profile.last_extension_versions	899	0	0	1,359,252	1,351,161	0	26,970
etendo.profile.last_stat_activity_count_srv1	899	0	0	1,613,364	1,613,364	0	42,312
etendo.profile.sample_statements_total	899	0	0	604,120	301,696	0	30,566
etendo.profile.stmt_list	899	0	0	10,531,894	9,629,593	0	1,165,104
etendo.public.m_product_org	599	0	0	39,349,097	7,103,383	0	4,051,636
etendo.pg_toast.pg_toast_196728	899	0	0	907,813	437,948	0	234,639
etendo.profile.servers	899	0	0	151,028	150,129	0	4,495
etendo.profile.sample_stat_tables	899	0	0	87,275,140	39,616,636	0	3,168,076
etendo.profile.last_stat_statements_srv1	899	0	0	160,658,644	158,705,932	0	13,626,143
etendo.profile.last_stat_cluster	899	0	0	151,028	150,129	0	4,495
etendo.public.m_storage_pending	279	0	0	2,183,755	389,484	0	137,547
etendo.public.ad_sequence	899	0	0	620,777	340,289	0	65,627
etendo.profile.last_stat_slru	899	0	0	755,140	750,645	0	15,283
etendo.profile.tables_list	899	0	0	23,626,705	22,778,402	0	694,927
etendo.public.ad_preference	899	0	0	9,527,266	3,333,347	0	2,526,190
etendo.profile.sample_stat_slru	899	0	0	1,209,139	603,751	0	20,677
etendo.public.ad_session	899	0	0	25,282,068	20,881,147	0	2,362,572
etendo.profile.sample_stat_tablespaces	899	0	0	604,120	301,696	0	5,394
etendo.profile.sample_stat_database	899	0	0	1,208,240	603,392	0	59,334
etendo.profile.indexes_list	899	0	0	11,123,892	10,633,217	0	267,902
etendo.pg_catalog.pg_statistic	899	0	0	69,217,857	59,374,386	0	6,927,694
etendo.public.m_stock_proposed	899	0	0	1,076,103	695,826	0	45,849
etendo.public.ad_pinstance_para	374	0	0	403,342	83,776	0	14,266
etendo.pg_toast.pg_toast_2619	899	0	0	6,740,981	3,829,817	0	1,958,921
etendo.profile.sample_stat_user_functions	899	0	0	17,057,187	7,752,336	0	178,002
etendo.profile.sample_stat_indexes	899	0	0	25,397,191	11,672,111	0	432,419
etendo.profile.samples	899	0	0	302,060	150,848	0	2,697
etendo.public.ad_process_request	899	0	0	4,991,867	3,559,419	0	1,526,502
Total	45,902	8	485	2,307,730,511	2,026,488,625	0	172,659,461

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.profile.sample_stat_io	899	0	0
etendo.public.gl_journalbatch	1	0	0
etendo.profile.sample_stat_indexes_total	899	0	0
etendo.pg_toast.pg_toast_85256	899	0	0
etendo.public.ad_module	899	0	0
etendo.profile.last_stat_indexes_srv1	899	0	0
etendo.profile.last_stat_tables_srv1	899	0	0
etendo.profile.last_stat_user_functions_srv1	899	0	0
etendo.public.ad_ep_instance_para	899	5	140
etendo.public.fin_financial_account	598	0	0
etendo.profile.last_stat_tablespaces_srv1	899	0	0
etendo.profile.sample_stat_wal	899	0	0
etendo.profile.sample_statements	899	0	0
etendo.profile.sample_stat_user_func_total	899	0	0
etendo.profile.last_stat_io	899	0	0
etendo.profile.sample_stat_cluster	899	0	0
etendo.profile.last_stat_archiver	899	0	0
etendo.profile.sample_stat_tables_total	899	0	0
etendo.profile.last_stat_database_srv1	899	0	0
etendo.profile.last_stat_wal	899	0	0
etendo.profile.funcs_list	899	0	0
etendo.profile.sample_stat_archiver	899	0	0
etendo.public.ad_process_run	899	0	0
etendo.public.c_invoice	899	0	0
etendo.public.ma_processplan_tot_aux	899	0	0
etendo.profile.last_extension_versions	899	0	0
etendo.profile.last_stat_activity_count_srv1	899	0	0
etendo.profile.sample_statements_total	899	0	0
etendo.profile.stmt_list	899	0	0
etendo.public.m_product_org	599	0	0
etendo.pg_toast.pg_toast_196728	899	0	0
etendo.profile.servers	899	0	0
etendo.profile.sample_stat_tables	899	0	0
etendo.profile.last_stat_statements_srv1	899	0	0
etendo.profile.last_stat_cluster	899	0	0
etendo.public.m_storage_pending	279	0	0
etendo.public.ad_sequence	899	0	0
etendo.profile.last_stat_slru	899	0	0
etendo.profile.tables_list	899	0	0
etendo.public.ad_preference	899	0	0
etendo.profile.sample_stat_slru	899	0	0
etendo.public.ad_session	899	0	0
etendo.profile.sample_stat_tablespaces	899	0	0
etendo.profile.sample_stat_database	899	0	0
etendo.profile.indexes_list	899	0	0
etendo.pg_catalog.pg_statistic	899	0	0
etendo.public.m_stock_proposed	899	0	0
etendo.public.ad_pinstance_para	374	0	0
etendo.pg_toast.pg_toast_2619	899	0	0
etendo.profile.sample_stat_user_functions	899	0	0
etendo.profile.sample_stat_indexes	899	0	0
etendo.public.ad_pinstance	899	3	345
etendo.profile.samples	899	0	0
etendo.public.ad_process_request	899	0	0
Total	45,902	8	485

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jul 17	07	3,000	8
	08	3,000	9
	09	3,000	9
	10	3,000	12
	11	3,000	12
	12	3,119	11
	13	3,074	17
	14	3,060	14
	15	3,061	13
	16	3,060	9
	17	3,100	12
	18	3,068	5
	19	3,120	16
	20	3,120	8
	21	3,120	8

↑ 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

119 Total read queries
27 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	119	81.51%
INSERT	0	0.00%
UPDATE	13	8.90%
DELETE	14	9.59%
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
146 Requests
24m39s (etendo)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
etendo	Total	146	24m39s
	delete	14	2m10s
	select	119	21m50s
	update	13	37s863ms

Queries by user

Key values

tad Main user
131 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	15	1m17s
	select	15	1m17s
tad	Total	131	23m22s
	delete	14	2m10s
	select	104	20m33s
	update	13	37s863ms

Duration by user

Key values

23m22s (tad) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	15	1m17s
	select	15	1m17s
tad	Total	131	23m22s
	delete	14	2m10s
	select	104	20m33s
	update	13	37s863ms

Queries by host

Key values

127.0.0.1 Main host
131 Requests
23m22s (127.0.0.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	131	23m22s
	delete	14	2m10s
	select	104	20m33s
	update	13	37s863ms
[local]	Total	15	1m17s
	select	15	1m17s

Queries by application

Key values

openbravo Main application
131 Requests
23m22s (openbravo)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
openbravo	Total	131	23m22s
	delete	14	2m10s
	select	104	20m33s
	update	13	37s863ms
psql	Total	15	1m17s
	select	15	1m17s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-07-17 09:25:24 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

126 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	126	86.30%
> 10000ms	20	13.70%

Slowest individual queries


[ Date: 2026-07-17 13:23:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 15:32:19 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 13:41:19 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 13:02:15 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 14:35:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 17:23:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 17:22:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 16:11:51 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 12:15:24 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 13:16:13 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 16:45:15 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 15:25:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 10:19:45 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 12:15:49 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 12:15:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 20:20:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 13:02:27 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 20:20:55 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 12:15:33 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-17 13:00:11 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]

Rank	Duration	Query
1	2m52s	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-17 13:23:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
2	2m51s	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-17 15:32:19 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3	2m46s	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-17 13:41:19 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
4	2m45s	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-17 13:02:15 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
5	2m39s	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-17 14:35:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
6	29s713ms	SELECT COUNT() AS ID FROM M_InOutLine WHERE C_Bpartner_ID = 'F13A46A52FED42A3B782E84F316BF3A6' AND AD_ORG_ID IN ('0', '975163BBDF184727BFA9D21FECF88F51', '0145CB12BBE04855B3C433728BD65F7C', '7EEF753D8C114D32A101EA8393FEAC19', '8997B74B935D46B08D5E187F5B343F48', '9DFF9C5278274C2DA3F411C2BA23605C') AND AD_CLIENT_ID IN ('29E43D204AEB4CEC9D1DC4EFFD0E5987'); [ Date:* 2026-07-17 17:23:12 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
7	28s768ms	SELECT COUNT() AS ID FROM M_InOutLine WHERE C_Bpartner_ID = 'F13A46A52FED42A3B782E84F316BF3A6' AND AD_ORG_ID IN ('0', '975163BBDF184727BFA9D21FECF88F51', '0145CB12BBE04855B3C433728BD65F7C', '7EEF753D8C114D32A101EA8393FEAC19', '8997B74B935D46B08D5E187F5B343F48', '9DFF9C5278274C2DA3F411C2BA23605C') AND AD_CLIENT_ID IN ('29E43D204AEB4CEC9D1DC4EFFD0E5987'); [ Date:* 2026-07-17 17:22:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
8	27s373ms	delete from C_OrderLine where C_OrderLine_ID = 'EA73D89F2610469ABC93E1A81C42970A'; [ Date: 2026-07-17 16:11:51 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
9	24s878ms	delete from C_OrderLine where C_OrderLine_ID = '4194A82FAEC94324B2F9D24604AA6BE9'; [ Date: 2026-07-17 12:15:24 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
10	17s937ms	delete from C_OrderLine where C_OrderLine_ID = '3D52C1D732BF46E8B31CDCF0AF70ADAB'; [ Date: 2026-07-17 13:16:13 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
11	17s871ms	delete from C_OrderLine where C_OrderLine_ID = '49B1236BBA41444D9E8CAF5C85B5C593'; [ Date: 2026-07-17 16:45:15 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
12	16s411ms	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-17 15:25:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
13	15s971ms	delete from C_OrderLine where C_OrderLine_ID = '42D110FD48854B8DBEFCCFBD8B30F1B3'; [ Date: 2026-07-17 10:19:45 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
14	14s943ms	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-17 12:15:49 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
15	13s601ms	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-17 12:15:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
16	13s420ms	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-17 20:20:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
17	11s677ms	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 ('FCBDDF4073444E9F86999FA3801305B9', 'EDD84127D1D24901B30C814BE956EA93', 'BFA82F4339514142815E1EBDA97D55DF', 'A51F74838923401B828149258C216C20', '911012AE84784C319648F0200E455572', '73CB51F91DD04E7CA6202AC8C788856A', '2464849836924D36AB07C38403EF28C5', 'A1540AB12AF54B1EB97C70C8369ECDCD', '75ED1EB8D1624315AC579407C1F03213', 'E56CD8DEB7294268B7A09DBE0520D8B0', '6999B288722E4544B38489B370830801', 'EFBC1FC3B5CE4538BCB7634B63D3B8CA', 'A23418D9F05240B79C4F9BEF763A6983', '22F63E6BEF174224A4864BD2A7649365', '5755BB0FFF054EE19C2C4734DFDCF924', 'FD3EEA3815264D06B2EDA8E85F5C5B99', '7D31AB83DC554E8F82864DBAC227AFAF', 'F97E787067864E1CBF185485AE2397F9', '02256ECFE7FC40D98A07844750C852D8', '889907C124AE462985025DE6314B4586', 'ADE95BAC82AE45D28DFE945CE8D79D41', 'EDC43EA7A70D421EAD3EA0152B7A0606', '64610C21759C4C2787BA4606F0B57AEF', 'E2C1538CCF12437FB163B17441F3BBBC', '482FDD813C7C42799C65DB28ABD7C4FD'); [ Date: 2026-07-17 13:02:27 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
18	11s326ms	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-17 20:20:55 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
19	10s149ms	SELECT * FROM ( select record_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED SALES 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 ('ARI', 'ARC', 'ARF') 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 = '67CD4EDC3FF8419E8B4CB4348234D409' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED'); [ Date: 2026-07-17 12:15:33 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
20	10s95ms	SELECT profile.take_sample (); [ Date: 2026-07-17 13:00:11 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]

Time consuming queries (N)


[ User: tad - Total duration: 13m55s - Times executed: 5 ]
[ User: tad - Total duration: 2m10s - Times executed: 14 ]
[ User: postgres - Total duration: 1m17s - Times executed: 15 ]
[ User: tad - Total duration: 1m6s - Times executed: 6 ]
[ User: tad - Total duration: 58s481ms - Times executed: 2 ]
[ User: tad - Total duration: 45s614ms - Times executed: 8 ]
[ User: tad - Total duration: 32s699ms - Times executed: 5 ]
[ User: tad - Total duration: 30s41ms - Times executed: 3 ]
[ User: tad - Total duration: 21s862ms - Times executed: 3 ]
[ User: tad - Total duration: 20s302ms - Times executed: 3 ]
[ User: tad - Total duration: 17s742ms - Times executed: 12 ]
[ User: tad - Total duration: 15s281ms - Times executed: 3 ]
[ User: tad - Total duration: 12s214ms - Times executed: 9 ]
[ User: tad - Total duration: 10s891ms - Times executed: 4 ]
[ User: tad - Total duration: 9s442ms - Times executed: 3 ]
[ User: tad - Total duration: 8s473ms - Times executed: 6 ]
[ User: tad - Total duration: 8s93ms - Times executed: 2 ]
[ User: tad - Total duration: 7s547ms - Times executed: 3 ]
[ User: tad - Total duration: 6s599ms - Times executed: 3 ]
[ User: tad - Total duration: 6s354ms - Times executed: 1 ]

Most frequent queries (N)


[ User: postgres - Total duration: 1m17s - Times executed: 15 ]
[ User: tad - Total duration: 2m10s - Times executed: 14 ]
[ User: tad - Total duration: 17s742ms - Times executed: 12 ]
[ User: tad - Total duration: 12s214ms - Times executed: 9 ]
[ User: tad - Total duration: 45s614ms - Times executed: 8 ]
[ User: tad - Total duration: 1m6s - Times executed: 6 ]
[ User: tad - Total duration: 8s473ms - Times executed: 6 ]
[ User: tad - Total duration: 13m55s - Times executed: 5 ]
[ User: tad - Total duration: 32s699ms - Times executed: 5 ]
[ User: tad - Total duration: 6s113ms - Times executed: 5 ]
[ User: tad - Total duration: 10s891ms - Times executed: 4 ]
[ User: tad - Total duration: 30s41ms - Times executed: 3 ]
[ User: tad - Total duration: 21s862ms - Times executed: 3 ]
[ User: tad - Total duration: 20s302ms - Times executed: 3 ]
[ User: tad - Total duration: 15s281ms - Times executed: 3 ]
[ User: tad - Total duration: 9s442ms - Times executed: 3 ]
[ User: tad - Total duration: 7s547ms - Times executed: 3 ]
[ User: tad - Total duration: 6s599ms - Times executed: 3 ]
[ User: tad - Total duration: 6s321ms - Times executed: 3 ]
[ User: tad - Total duration: 4s747ms - Times executed: 3 ]

Normalized slowest queries (N)


[ User: tad - Total duration: 13m55s - Times executed: 5 ]
[ User: tad - Total duration: 58s481ms - Times executed: 2 ]
[ User: tad - Total duration: 1m6s - Times executed: 6 ]
[ User: tad - Total duration: 30s41ms - Times executed: 3 ]
[ User: tad - Total duration: 2m10s - Times executed: 14 ]
[ User: tad - Total duration: 21s862ms - Times executed: 3 ]
[ User: tad - Total duration: 20s302ms - Times executed: 3 ]
[ User: tad - Total duration: 32s699ms - Times executed: 5 ]
[ User: tad - Total duration: 6s354ms - Times executed: 1 ]
[ User: tad - Total duration: 45s614ms - Times executed: 8 ]
[ User: postgres - Total duration: 1m17s - Times executed: 15 ]
[ User: tad - Total duration: 15s281ms - Times executed: 3 ]
[ User: tad - Total duration: 8s93ms - Times executed: 2 ]
[ User: tad - Total duration: 9s442ms - Times executed: 3 ]
[ User: tad - Total duration: 10s891ms - Times executed: 4 ]
[ User: tad - Total duration: 7s547ms - Times executed: 3 ]
[ User: tad - Total duration: 6s599ms - Times executed: 3 ]
[ User: tad - Total duration: 6s321ms - Times executed: 3 ]
[ User: tad - Total duration: 4s747ms - Times executed: 3 ]
[ User: tad - Total duration: 17s742ms - Times executed: 12 ]

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

90,867 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
DETAIL	128	0.14%
ERROR	7	0.01%
EVENTLOG	8,773	9.65%
LOG	81,943	90.18%
STATEMENT	16	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
0 FATAL entries
7 ERROR entries
0 WARNING entries
8773 EVENTLOG entries

Most Frequent Errors/Events

Key values

8,743 Max number of times the same event was reported
8,780 Total events found

Rank

Times reported

Error

1

8,743

Details

LOG: could not receive data from client: Connection reset by peer

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jul 17	07	586
	08	583
	09	582
	10	582
	11	580
	12	582
	13	582
	14	582
	15	581
	16	583
	17	584
	18	584
	19	584
	20	582
	21	586

LOG: could not receive data from client: Connection reset by peer
LOG: could not receive data from client: Connection reset by peer
LOG: could not receive data from client: Connection reset by peer

2

30

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #2

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

ERROR: unexpected EOF on client connection with an open transaction
ERROR: unexpected EOF on client connection with an open transaction
ERROR: unexpected EOF on client connection with an open transaction

3

7

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jul 17	08	1
	10	1
	12	1
	14	1
	16	1
	18	1
	20	1

ERROR: relation "lib_production_plan_info" does not exist at character 309
ERROR: relation "lib_production_plan_info" does not exist at character 309
ERROR: relation "lib_production_plan_info" does not exist at character 309

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