pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Mon Jul 13 23:00:18 2026
Log file: /var/log/postgresql/postgresql-16-main.log
Parsed 128,411 log entries in 17s
Log start from 2026-07-13 07:00:01 to 2026-07-13 21:59:50

Global Stats

53 Number of unique normalized queries
131 Number of queries
9m14s Total query duration
2026-07-13 07:00:12 First query
2026-07-13 21:00:05 Last query
5 queries/s at 2026-07-13 12:09:38 Query peak

9m14s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
9m14s Execute total duration

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

36,733 Total number of automatic vacuums
176 Total number of automatic analyzes

24 Number temporary file
203.75 MiB Max size of temporary file
92.18 MiB Average size of temporary file

8,831 Total number of sessions
5 sessions at 2026-07-13 10:00:03 Session peak
8d12h38m11s Total duration of sessions
1m23s Average duration of sessions
0 Average queries per session
62ms Average queries duration per session
1m23s Average idle time per session

8,832 Total number of connections
4 connections/s at 2026-07-13 20:00:02 Connection peak
1 Total number of databases

SQL Traffic

Key values

5 queries/s Query Peak
2026-07-13 12:09:38 Date

SELECT Traffic

Key values

5 queries/s Query Peak
2026-07-13 12:09:38 Date

INSERT/UPDATE/DELETE Traffic

Key values

1 queries/s Query Peak
2026-07-13 15:25:55 Date

Queries duration

Key values

9m14s 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 13	07	7	0ms	11s498ms	3s751ms	1s125ms	3s924ms	11s498ms
	08	3	0ms	11s888ms	6s774ms	0ms	1s143ms	11s888ms
	09	3	0ms	8s609ms	5s731ms	0ms	0ms	10s
	10	22	0ms	17s677ms	2s953ms	1s409ms	8s727ms	20s163ms
	11	3	0ms	15s994ms	6s274ms	0ms	1s87ms	15s994ms
	12	33	0ms	15s437ms	3s755ms	9s214ms	15s437ms	49s958ms
	13	8	0ms	14s214ms	3s390ms	0ms	4s750ms	14s214ms
	14	4	0ms	11s325ms	3s642ms	0ms	1s39ms	11s325ms
	15	22	0ms	22s997ms	4s556ms	3s903ms	11s199ms	50s294ms
	16	5	0ms	39s255ms	12s184ms	0ms	3s30ms	39s255ms
	17	3	0ms	7s297ms	3s181ms	0ms	1s97ms	7s297ms
	18	1	0ms	8s378ms	8s378ms	0ms	0ms	8s378ms
	19	1	0ms	3s198ms	3s198ms	0ms	0ms	3s198ms
	20	15	0ms	11s717ms	3s676ms	0ms	0ms	47s748ms
	21	1	0ms	4s205ms	4s205ms	0ms	0ms	4s205ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 13	07	7	3s751ms	0ms	1s125ms	5s8ms
	08	3	6s774ms	0ms	0ms	7s292ms
	09	3	5s731ms	0ms	0ms	7s192ms
	10	22	2s953ms	0ms	1s409ms	19s445ms
	11	3	6s274ms	0ms	0ms	1s740ms
	12	29	3s799ms	0ms	9s214ms	18s733ms
	13	7	3s195ms	0ms	0ms	5s181ms
	14	4	3s642ms	0ms	0ms	1s198ms
	15	13	3s539ms	0ms	0ms	3s975ms
	16	4	5s416ms	0ms	0ms	3s30ms
	17	3	3s181ms	0ms	0ms	1s149ms
	18	1	8s378ms	0ms	0ms	0ms
	19	1	3s198ms	0ms	0ms	0ms
	20	11	3s971ms	0ms	0ms	7s393ms
	21	1	4s205ms	0ms	0ms	0ms

Day	Hour	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 13	07	0	0	0ms	0ms	0ms	0ms
	08	0	0	0ms	0ms	0ms	0ms
	09	0	0	0ms	0ms	0ms	0ms
	10	0	0	0ms	0ms	0ms	0ms
	11	0	0	0ms	0ms	0ms	0ms
	12	4	0	3s439ms	0ms	0ms	0ms
	13	0	1	4s750ms	0ms	0ms	0ms
	14	0	0	0ms	0ms	0ms	0ms
	15	5	4	6s25ms	0ms	0ms	9s998ms
	16	0	1	39s255ms	0ms	0ms	0ms
	17	0	0	0ms	0ms	0ms	0ms
	18	0	0	0ms	0ms	0ms	0ms
	19	0	0	0ms	0ms	0ms	0ms
	20	4	0	2s862ms	0ms	0ms	0ms
	21	0	0	0ms	0ms	0ms	0ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
Jul 13	07	5	5.00	0.00%
	08	2	2.00	0.00%
	09	2	2.00	0.00%
	10	21	21.00	0.00%
	11	2	2.00	0.00%
	12	32	32.00	0.00%
	13	7	7.00	0.00%
	14	3	3.00	0.00%
	15	21	21.00	0.00%
	16	4	4.00	0.00%
	17	2	2.00	0.00%
	18	0	0.00	0.00%
	19	0	0.00	0.00%
	20	14	14.00	0.00%
	21	0	0.00	0.00%

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

Day	Hour	Count	Average Duration	Average idle time
Jul 13	07	591	266ms	222ms
	08	591	3m25s	3m25s
	09	592	7m44s	7m44s
	10	587	243ms	133ms
	11	587	29s357ms	29s325ms
	12	597	7m35s	7m35s
	13	588	272ms	226ms
	14	585	285ms	260ms
	15	585	275ms	104ms
	16	590	46s998ms	46s895ms
	17	589	37s365ms	37s349ms
	18	589	250ms	236ms
	19	586	238ms	232ms
	20	587	228ms	134ms
	21	587	248ms	240ms

↑ Back to the top of the General Activity table

Established Connections

Key values

4 connections Connection Peak
2026-07-13 20:00:02 Date

Connections per database

Key values

etendo Main Database
8,832 connections Total

Chart
Table

Database	User	Count
etendo		8,816
	postgres	46
	tad	8,770
postgres		16
	postgres	16

Connections per user

Key values

tad Main User
8,832 connections Total

Chart
Table

User	Count
postgres	62
tad	8,770

Connections per host

Key values

10.10.11.43 Main host with 8741 connections
8,832 Total connections

Chart
Table

Host	Count
10.10.11.43	8,741
127.0.0.1	22
172.30.3.29	7
[local]	62

Simultaneous sessions

Key values

5 sessions Session Peak
2026-07-13 10:00:03 Date

Histogram of session times

Key values

8,463 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	8,463	95.83%
500ms-1s	253	2.86%
1s-30s	94	1.06%
30s-1m	0	0.00%
1m-10m	5	0.06%
10m-30m	2	0.02%
30m-1h	2	0.02%
1h-8h	8	0.09%
> 8h	4	0.05%

Sessions per database

Key values

etendo Main Database
8,831 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
etendo	8,815	8d12h38m10s	1m23s
postgres	16	956ms	59ms

Sessions per user

Key values

tad Main User
8,831 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
postgres	62	3m32s	3s433ms
tad	8,769	8d12h34m38s	1m23s

Sessions per host

Key values

10.10.11.43 Main Host
8,831 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.11.43	8,741	33m41s	231ms
127.0.0.1	21	8d12h56s	9h42m54s
172.30.3.29	7	352ms	50ms
[local]	62	3m32s	3s433ms

Sessions per application

Key values

[unknown] Main Application
8,831 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
[unknown]	8,748	33m42s	231ms
openbravo	21	8d12h56s	9h42m54s
pg_profile	45	1m37s	2s176ms
psql	17	1m54s	6s762ms

Checkpoints Buffers

Key values

3,217 buffers Checkpoint Peak
2026-07-13 13:15:32 Date
269.978 seconds Highest write time
0.026 seconds Sync time

Checkpoints Wal files

Key values

2 files Wal files usage Peak
2026-07-13 14:05:33 Date

Checkpoints distance

Key values

42.19 Mo Distance Peak
2026-07-13 10:05:30 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jul 13	07	4,647	463.059s	0.045s	463.378s
	08	5,617	559.607s	0.047s	559.917s
	09	9,101	858.665s	0.057s	859.01s
	10	5,548	531.76s	0.046s	532.065s
	11	4,598	457.783s	0.054s	458.076s
	12	8,641	877.291s	0.066s	877.631s
	13	8,752	820.795s	0.054s	821.097s
	14	6,141	598.506s	0.048s	598.824s
	15	7,217	719.285s	0.059s	719.605s
	16	5,061	503.882s	0.08s	504.28s
	17	9,977	943.735s	0.047s	944.048s
	18	2,996	298.904s	0.053s	299.216s
	19	2,069	206.033s	0.05s	206.327s
	20	2,881	287.098s	0.051s	287.379s
	21	5,388	512.55s	0.048s	512.82s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jul 13	07	1	994	0.005s	0.012s
	08	2	1,207	0.004s	0.012s
	09	3	1,467	0.004s	0.012s
	10	2	918	0.007s	0.012s
	11	2	843	0.004s	0.012s
	12	2	1,757	0.009s	0.012s
	13	3	1,445	0.004s	0.012s
	14	3	1,287	0.004s	0.012s
	15	2	1,332	0.004s	0.012s
	16	2	1,408	0.005s	0.012s
	17	3	1,034	0.004s	0.012s
	18	1	392	0.004s	0.012s
	19	1	305	0.004s	0.012s
	20	1	314	0.004s	0.011s
	21	2	318	0.006s	0.011s

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

Day	Hour	Mean distance	Mean estimate
Jul 13	07	2,095.58 kB	8,131.25 kB
	08	2,394.33 kB	9,112.08 kB
	09	4,230.25 kB	11,691.67 kB
	10	2,619.75 kB	13,346.83 kB
	11	2,392.92 kB	9,332.42 kB
	12	3,865.83 kB	11,565.08 kB
	13	4,005.00 kB	11,876.33 kB
	14	3,038.75 kB	12,991.50 kB
	15	3,578.92 kB	12,642.08 kB
	16	2,619.17 kB	10,817.17 kB
	17	3,724.00 kB	11,789.75 kB
	18	1,701.08 kB	11,458.00 kB
	19	1,245.42 kB	8,395.58 kB
	20	1,543.27 kB	9,822.36 kB
	21	2,793.36 kB	11,077.91 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (178) Main checkpoint cause
178 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	178
Total	178

Size of temporary files

Key values

253.14 MiB Temp Files size Peak
2026-07-13 20:20:20 Date

Number of temporary files

Key values

2 per second Temp Files Peak
2026-07-13 20:20:44 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jul 13	07	0	0	0
	08	0	0	0
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	8	737.38 MiB	92.17 MiB
	13	0	0	0
	14	0	0	0
	15	8	737.46 MiB	92.18 MiB
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	8	737.48 MiB	92.19 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.45 GiB	3.68 MiB	203.75 MiB	99.06 MiB	select * from ( select c_invoice_id as referencekey_id, ; SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; Date: 2026-07-13 12:15:25 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
2	6	715.43 MiB	34.72 MiB	203.75 MiB	119.24 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-13 12:15:58 Duration: 9s234ms 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-13 15:25:48 Duration: 7s83ms 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-13 20:20:44 Duration: 6s829ms 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-13 12:15:27 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo

Queries generating the largest temporary files


[ Date: 2026-07-13 15:25:22 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 15:25:41 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 15:25:48 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 20:20:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 20:20:38 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 20:20:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 12:15:25 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 12:15:49 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 12:15:58 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 20:20:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 12:15:25 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 15:25:22 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 20:20:38 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 20:20:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 15:25:41 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 15:25:48 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 12:15:49 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 12:15:58 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 12:15:27 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-13 12:15:27 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

Rank	Size	Query
1	203.75 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-13 15:25:22 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2	203.75 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-13 15:25:41 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3	203.75 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-13 15:25:48 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4	203.75 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-13 20:20:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5	203.75 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-13 20:20:38 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
6	203.75 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-13 20:20:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
7	203.73 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-13 12:15:25 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8	203.73 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-13 12:15:49 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
9	203.73 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-13 12:15:58 - 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-13 20:20:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
11	49.38 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-13 12:15:25 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
12	49.38 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-13 15:25:22 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
13	34.74 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-13 20:20:38 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
14	34.74 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-13 20:20:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
15	34.73 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-13 15:25:41 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
16	34.73 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-13 15:25:48 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
17	34.72 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-13 12:15:49 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
18	34.72 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-13 12:15:58 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
19	3.68 MiB	SELECT * FROM ( select C_INVOICE_id as referencekey_id, ; [ Date: 2026-07-13 12:15:27 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
20	3.68 MiB	UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-13 12:15:27 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

Vacuums / Analyzes Distribution

Key values

1.05 sec Highest CPU-cost vacuum
Table public.c_invoice
Database etendo
2026-07-13 17:11:50 Date
0 sec Highest CPU-cost analyze
Table
Database etendo
Date

Average Autovacuum Duration

Key values

1.05 sec Highest CPU-cost vacuum
Table public.c_invoice
Database etendo
2026-07-13 17:11:50 Date

Analyzes per table

Key values

public.ad_ep_instance_para (29) Main table analyzed (database etendo)
176 analyzes Total

Chart
Table

Table	Number of analyzes
etendo.public.ad_ep_instance_para	29
etendo.profile.last_stat_tables_srv1	15
etendo.profile.last_stat_statements_srv1	15
etendo.profile.last_stat_user_functions_srv1	15
etendo.profile.last_stat_indexes_srv1	15
etendo.public.ad_session	10
etendo.profile.tables_list	8
etendo.profile.indexes_list	7
etendo.profile.funcs_list	7
etendo.profile.stmt_list	6
etendo.profile.last_stat_activity_count_srv1	5
etendo.profile.last_stat_io	5
etendo.profile.last_extension_versions	5
etendo.profile.last_stat_slru	3
etendo.public.ad_process_request	3
etendo.profile.sample_stat_indexes	2
etendo.profile.sample_stat_io	2
etendo.profile.sample_stat_tables	2
etendo.profile.sample_stat_user_functions	2
etendo.public.ad_preference	2
etendo.public.c_invoice	1
etendo.public.priuti_automaticpolines	1
etendo.public.fin_financial_account	1
etendo.profile.last_stat_wal	1
etendo.profile.last_stat_archiver	1
etendo.public.c_order	1
etendo.public.ad_sequence	1
etendo.profile.last_stat_cluster	1
etendo.public.m_storage_pending	1
etendo.public.m_transaction_last	1
etendo.public.m_product_org	1
etendo.profile.sample_stat_tablespaces	1
etendo.profile.sample_stat_tables_total	1
etendo.profile.sample_statements_total	1
etendo.public.ad_pinstance	1
etendo.public.ad_process_run	1
etendo.profile.sample_statements	1
etendo.profile.sample_stat_user_func_total	1
Total	176

Vacuums per table

Key values

profile.last_stat_cluster (898) Main table vacuumed on database etendo
36,733 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.last_stat_cluster	898	0	33,226	0	107	0	0	201	92	390,056	0	0
etendo.profile.tables_list	898	0	1,090,672	0	1	0	0	133	1	39,913	0	0
etendo.profile.sample_stat_database	898	0	145,476	0	12	0	0	200	0	48,200	0	0
etendo.profile.last_stat_io	898	0	71,120	0	106	0	0	236	96	389,680	0	0
etendo.pg_toast.pg_toast_85256	898	1	684,141	0	92	0	0	580	93	593,855	0	0
etendo.profile.servers	898	0	45,389	0	113	0	0	216	99	587,094	15	15
etendo.profile.sample_stat_user_func_total	898	0	41,338	0	15	0	0	200	0	48,200	0	0
etendo.profile.stmt_list	898	0	1,932,082	0	98	0	0	229	98	201,013	0	0
etendo.public.ad_pinstance	898	5	164,311	0	154	0	0	454	121	759,924	51	88
etendo.profile.last_stat_slru	898	0	57,472	0	14	0	0	201	0	37,788	0	0
etendo.profile.sample_stat_indexes_total	898	0	76,874	0	15	0	0	200	0	48,200	0	0
etendo.profile.last_extension_versions	898	0	77,414	0	72	0	0	201	58	261,030	0	0
etendo.profile.sample_stat_tables_total	898	0	203,937	0	12	0	0	200	0	48,200	0	0
etendo.profile.sample_stat_tablespaces	898	0	50,928	0	15	0	0	200	0	48,200	0	0
etendo.pg_toast.pg_toast_2619	898	0	1,496,370	0	63	0	0	148	56	448,104	0	0
etendo.profile.sample_stat_io	898	0	125,865	0	94	0	0	200	83	700,580	0	0
etendo.public.m_stock_proposed	898	0	122,076	0	94	0	0	201	92	732,457	0	0
etendo.profile.last_stat_activity_count_srv1	898	0	44,898	0	31	0	0	200	0	94,600	0	0
etendo.profile.sample_stat_indexes	898	0	339,663	0	19	0	0	140	19	183,080	0	0
etendo.profile.indexes_list	898	0	557,507	0	0	0	0	200	0	48,200	0	0
etendo.public.ad_module	898	1	223,702	0	135	0	0	340	98	613,239	10	10
etendo.profile.last_stat_wal	898	0	31,430	0	15	0	0	201	0	37,788	0	0
etendo.profile.last_stat_archiver	898	0	27,838	0	15	0	0	201	0	37,788	0	0
etendo.profile.sample_stat_user_functions	898	0	168,117	0	3	0	0	144	2	50,424	0	0
etendo.profile.sample_statements	898	0	872,388	0	3	0	0	164	3	63,104	0	0
etendo.public.ad_process_run	898	0	2,087,965	0	150	0	0	374	85	724,438	0	0
etendo.public.ad_process_request	898	0	566,600	0	267	0	0	343	93	775,607	0	0
etendo.public.ad_pinstance_para	898	6	92,168	0	96	0	0	244	69	585,142	0	0
etendo.profile.sample_stat_tables	898	0	2,180,220	0	7	0	0	176	7	97,436	0	0
etendo.pg_catalog.pg_statistic	898	0	5,184,178	0	629	0	0	226	74	497,810	0	0
etendo.profile.funcs_list	898	0	414,046	0	2	0	0	35	0	8,435	0	0
etendo.profile.sample_statements_total	898	0	84,064	0	15	0	0	200	0	48,200	0	0
etendo.profile.sample_stat_slru	898	0	61,931	0	14	0	0	199	0	47,959	0	0
etendo.profile.last_stat_indexes_srv1	897	0	31,470,293	0	126	0	0	484	126	757,124	0	0
etendo.profile.last_stat_user_functions_srv1	897	0	2,572,028	0	0	0	0	427	0	201,971	0	0
etendo.profile.last_stat_tables_srv1	895	0	25,201,216	0	49	0	0	466	47	412,742	0	0
etendo.profile.last_stat_tablespaces_srv1	892	0	41,924	0	15	0	0	198	0	93,654	0	0
etendo.profile.last_stat_statements_srv1	892	0	5,647,294	0	75	0	0	596	75	549,208	0	0
etendo.profile.last_stat_database_srv1	892	0	93,411	0	84	0	0	198	72	388,278	0	0
etendo.public.ad_ep_instance_para	876	10	47,073	0	235	0	0	279	104	730,353	0	0
etendo.public.ad_session	842	0	843,938	0	189	0	0	503	65	635,128	8	8
etendo.public.m_product_org	10	0	7,837	0	4	0	0	10	4	27,386	0	0
etendo.public.c_invoice	4	0	33,012	0	2,853	0	0	187	169	1,238,240	157	654
etendo.public.ad_preference	2	0	3,034	0	283	0	0	2	2	11,290	0	0
Total	36,733	23	85,316,466	1,683,602	6,391	0	0	10,737	2,003	14,341,118	241	775

Vacuum throughput per table

Key values

profile.last_stat_indexes_srv1 (411.660000000004) 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.last_stat_cluster	0	0	0
etendo.profile.tables_list	0	0	10.0199999999998
etendo.profile.sample_stat_database	0	0	0
etendo.profile.last_stat_io	0	0	0
etendo.pg_toast.pg_toast_85256	0	0	0.23
etendo.profile.servers	0	0	0
etendo.profile.sample_stat_user_func_total	0	0	0
etendo.profile.stmt_list	0	0	19.6199999999998
etendo.public.ad_pinstance	0	0	0.05
etendo.profile.last_stat_slru	0	0	0
etendo.profile.sample_stat_indexes_total	0	0	0.01
etendo.profile.last_extension_versions	0	0	0
etendo.profile.sample_stat_tables_total	0	0	0.02
etendo.profile.sample_stat_tablespaces	0	0	0
etendo.pg_toast.pg_toast_2619	0	0	13.8799999999998
etendo.profile.sample_stat_io	0	0	0.01
etendo.public.m_stock_proposed	0	0	0.01
etendo.profile.last_stat_activity_count_srv1	0	0	0
etendo.profile.sample_stat_indexes	0	0	0.12
etendo.profile.indexes_list	0	0	0.33
etendo.public.ad_module	0	0	0
etendo.profile.last_stat_wal	0	0	0
etendo.profile.last_stat_archiver	0	0	0
etendo.profile.sample_stat_user_functions	0	0	0.02
etendo.profile.sample_statements	0	0	9.65999999999984
etendo.public.ad_process_run	0	0	34.9500000000002
etendo.public.ad_process_request	0	0	4.71999999999994
etendo.public.ad_pinstance_para	0	0	0.01
etendo.profile.sample_stat_tables	0	0	31.9300000000001
etendo.pg_catalog.pg_statistic	0	0	74.4700000000009
etendo.profile.funcs_list	0	0	0.07
etendo.profile.sample_statements_total	0	0	0
etendo.profile.sample_stat_slru	0	0	0.01
etendo.profile.last_stat_indexes_srv1	0	0	411.660000000004
etendo.profile.last_stat_user_functions_srv1	0	0	30.2899999999997
etendo.profile.last_stat_tables_srv1	0	0	324.589999999999
etendo.profile.last_stat_tablespaces_srv1	0	0	0
etendo.profile.last_stat_statements_srv1	0	0	68.5500000000007
etendo.profile.last_stat_database_srv1	0	0	0.01
etendo.public.ad_ep_instance_para	0	0	0.08
etendo.public.ad_session	0	0	8.87999999999986
etendo.public.m_product_org	0	0	0.03
etendo.public.c_invoice	0	0	1.37
etendo.public.ad_preference	0	0	0.09
Total	0	0	1,045.69

Tuples removed per table

Key values

pg_toast.pg_toast_85256 (492) Main table with removed tuples on database etendo
1431 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
etendo.pg_toast.pg_toast_85256	898	1	492	2,501,897	883,632	0	1,214,096
etendo.public.ad_pinstance	898	5	375	1,537,640	668,614	0	117,638
etendo.public.ad_module	898	1	293	1,083,764	526,228	0	202,050
etendo.public.ad_ep_instance_para	876	10	184	483,548	483,548	3	10,168
etendo.public.c_invoice	4	0	73	403,947	67,191	0	127,880
etendo.public.ad_pinstance_para	898	6	14	804,137	201,152	0	33,226
etendo.profile.last_stat_cluster	898	0	0	64,651	63,753	0	4,490
etendo.profile.tables_list	898	0	0	10,116,236	8,980,511	0	694,154
etendo.public.ad_session	842	0	0	7,729,385	3,845,047	0	2,212,776
etendo.profile.last_stat_tablespaces_srv1	892	0	0	128,480	126,696	0	7,136
etendo.profile.last_stat_statements_srv1	892	0	0	57,406,339	50,562,525	0	13,520,044
etendo.profile.sample_stat_database	898	0	0	862,060	256,928	0	59,268
etendo.profile.last_stat_io	898	0	0	864,785	828,789	0	61,064
etendo.profile.servers	898	0	0	64,651	63,753	0	4,490
etendo.profile.sample_stat_user_func_total	898	0	0	431,030	128,464	0	6,286
etendo.profile.stmt_list	898	0	0	4,572,876	3,500,692	0	1,163,808
etendo.profile.last_stat_slru	898	0	0	323,255	318,765	0	15,266
etendo.profile.last_stat_database_srv1	892	0	0	256,960	253,392	0	34,788
etendo.profile.sample_stat_indexes_total	898	0	0	862,060	256,928	0	17,062
etendo.profile.last_extension_versions	898	0	0	581,859	573,777	0	26,940
etendo.profile.sample_stat_tables_total	898	0	0	1,939,635	578,088	0	86,208
etendo.profile.sample_stat_tablespaces	898	0	0	431,030	128,464	0	5,388
etendo.pg_toast.pg_toast_2619	898	0	0	5,898,958	1,465,802	0	1,956,742
etendo.profile.sample_stat_io	898	0	0	1,489,384	426,693	0	55,676
etendo.public.m_stock_proposed	898	0	0	953,230	695,052	0	45,798
etendo.profile.last_stat_activity_count_srv1	898	0	0	677,938	677,938	0	17,959
etendo.profile.sample_stat_indexes	898	0	0	18,574,520	4,930,765	0	431,938
etendo.profile.indexes_list	898	0	0	5,305,206	4,799,036	0	267,604
etendo.profile.last_stat_wal	898	0	0	64,651	63,753	0	3,592
etendo.profile.last_stat_tables_srv1	895	0	0	253,060,412	247,802,119	0	41,868,100
etendo.profile.last_stat_archiver	898	0	0	64,651	63,753	0	1,796
etendo.profile.sample_stat_user_functions	898	0	0	11,143,587	3,048,012	0	177,804
etendo.public.ad_preference	2	0	0	13,224	1,922	0	5,620
etendo.profile.sample_statements	898	0	0	17,674,770	4,506,472	0	1,363,164
etendo.profile.last_stat_indexes_srv1	897	0	0	390,986,341	382,377,593	0	52,399,152
etendo.profile.last_stat_user_functions_srv1	897	0	0	40,159,065	38,542,643	0	4,218,591
etendo.public.ad_process_run	898	0	0	12,678,618	4,814,718	0	1,525,702
etendo.public.ad_process_request	898	0	0	2,692,992	1,658,261	0	1,524,804
etendo.profile.sample_stat_tables	898	0	0	61,360,524	17,025,385	0	3,164,552
etendo.pg_catalog.pg_statistic	898	0	0	41,316,561	24,777,131	0	6,919,988
etendo.profile.funcs_list	898	0	0	2,662,434	2,336,879	0	243,358
etendo.profile.sample_statements_total	898	0	0	431,030	128,464	0	30,532
etendo.profile.sample_stat_slru	898	0	0	862,958	256,928	0	20,654
etendo.public.m_product_org	10	0	0	245,612	47,400	0	67,640
Total	36,733	23	1,431	961,766,891	813,743,656	3	135,934,992

Pages removed per table

Key values

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

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
etendo.public.ad_ep_instance_para	876	10	184	3
etendo.profile.last_stat_cluster	898	0	0	0
etendo.profile.tables_list	898	0	0	0
etendo.public.ad_session	842	0	0	0
etendo.profile.last_stat_tablespaces_srv1	892	0	0	0
etendo.profile.last_stat_statements_srv1	892	0	0	0
etendo.profile.sample_stat_database	898	0	0	0
etendo.profile.last_stat_io	898	0	0	0
etendo.pg_toast.pg_toast_85256	898	1	492	0
etendo.profile.servers	898	0	0	0
etendo.profile.sample_stat_user_func_total	898	0	0	0
etendo.profile.stmt_list	898	0	0	0
etendo.public.ad_pinstance	898	5	375	0
etendo.profile.last_stat_slru	898	0	0	0
etendo.profile.last_stat_database_srv1	892	0	0	0
etendo.profile.sample_stat_indexes_total	898	0	0	0
etendo.profile.last_extension_versions	898	0	0	0
etendo.profile.sample_stat_tables_total	898	0	0	0
etendo.profile.sample_stat_tablespaces	898	0	0	0
etendo.pg_toast.pg_toast_2619	898	0	0	0
etendo.profile.sample_stat_io	898	0	0	0
etendo.public.m_stock_proposed	898	0	0	0
etendo.profile.last_stat_activity_count_srv1	898	0	0	0
etendo.profile.sample_stat_indexes	898	0	0	0
etendo.profile.indexes_list	898	0	0	0
etendo.public.ad_module	898	1	293	0
etendo.profile.last_stat_wal	898	0	0	0
etendo.profile.last_stat_tables_srv1	895	0	0	0
etendo.public.c_invoice	4	0	73	0
etendo.profile.last_stat_archiver	898	0	0	0
etendo.profile.sample_stat_user_functions	898	0	0	0
etendo.public.ad_preference	2	0	0	0
etendo.profile.sample_statements	898	0	0	0
etendo.profile.last_stat_indexes_srv1	897	0	0	0
etendo.profile.last_stat_user_functions_srv1	897	0	0	0
etendo.public.ad_process_run	898	0	0	0
etendo.public.ad_process_request	898	0	0	0
etendo.public.ad_pinstance_para	898	6	14	0
etendo.profile.sample_stat_tables	898	0	0	0
etendo.pg_catalog.pg_statistic	898	0	0	0
etendo.profile.funcs_list	898	0	0	0
etendo.profile.sample_statements_total	898	0	0	0
etendo.profile.sample_stat_slru	898	0	0	0
etendo.public.m_product_org	10	0	0	0
Total	36,733	23	1,431	3

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jul 13	07	2,344	11
	08	2,457	11
	09	2,457	19
	10	2,457	7
	11	2,457	13
	12	2,462	12
	13	2,456	18
	14	2,457	11
	15	2,462	18
	16	2,460	9
	17	2,461	11
	18	2,460	7
	19	2,419	6
	20	2,461	10
	21	2,463	13

↑ 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

112 Total read queries
19 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	112	85.50%
INSERT	0	0.00%
UPDATE	13	9.92%
DELETE	6	4.58%
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
131 Requests
9m14s (etendo)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
etendo	Total	131	9m14s
	delete	6	1m24s
	select	112	7m11s
	update	13	38s570ms

Queries by user

Key values

tad Main user
115 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	16	1m54s
	select	16	1m54s
tad	Total	115	7m19s
	delete	6	1m24s
	select	96	5m16s
	update	13	38s570ms

Duration by user

Key values

7m19s (tad) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	16	1m54s
	select	16	1m54s
tad	Total	115	7m19s
	delete	6	1m24s
	select	96	5m16s
	update	13	38s570ms

Queries by host

Key values

127.0.0.1 Main host
115 Requests
7m19s (127.0.0.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	115	7m19s
	delete	6	1m24s
	select	96	5m16s
	update	13	38s570ms
[local]	Total	16	1m54s
	select	16	1m54s

Queries by application

Key values

openbravo Main application
115 Requests
7m19s (openbravo)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
openbravo	Total	115	7m19s
	delete	6	1m24s
	select	96	5m16s
	update	13	38s570ms
psql	Total	16	1m54s
	select	16	1m54s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-07-13 18:47:05 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

117 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	117	89.31%
> 10000ms	14	10.69%

Slowest individual queries


[ Date: 2026-07-13 16:16:10 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 15:30:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 10:13:19 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 11:00:17 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-13 12:22:15 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 12:21:59 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 16:11:37 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 13:00:15 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-13 12:15:25 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 15:25:22 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 08:22:32 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 20:20:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 07:00:12 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-13 14:00:13 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-13 12:15:58 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 10:49:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 09:54:22 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 18:00:10 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-13 15:03:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
[ Date: 2026-07-13 15:39:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

Rank	Duration	Query
1	39s255ms	delete from C_OrderLine where C_OrderLine_ID = '287DF272BC1847F2BE18E3F4CA98CAA8'; [ Date: 2026-07-13 16:16:10 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
2	22s997ms	delete from C_OrderLine where C_OrderLine_ID = '7704EBE1762144F895122F05C5DA8E4C'; [ Date: 2026-07-13 15:30:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3	17s677ms	select financialm0_.Fact_Acct_ID as fact_acc1_437_, financialm0_.AD_Client_ID as ad_clien2_437_, financialm0_.AD_Org_ID as ad_org_i3_437_, financialm0_.IsActive as isactive4_437_, financialm0_.Created as created5_437_, financialm0_.CreatedBy as createdb6_437_, financialm0_.Updated as updated7_437_, financialm0_.UpdatedBy as updatedb8_437_, financialm0_.C_AcctSchema_ID as c_acctsc9_437_, financialm0_.Account_ID as account10_437_, financialm0_.DateTrx as datetrx11_437_, financialm0_.DateAcct as dateacc12_437_, financialm0_.C_Period_ID as c_perio13_437_, financialm0_.AD_Table_ID as ad_tabl14_437_, financialm0_.Record_ID as record_15_437_, financialm0_.Line_ID as line_id16_437_, financialm0_.GL_Category_ID as gl_cate17_437_, financialm0_.C_Tax_ID as c_tax_i18_437_, financialm0_.M_Locator_ID as m_locat19_437_, financialm0_.PostingType as posting20_437_, financialm0_.C_Currency_ID as c_curre21_437_, financialm0_.AmtSourceDr as amtsour22_437_, financialm0_.AmtSourceCr as amtsour23_437_, financialm0_.AmtAcctDr as amtacct24_437_, financialm0_.AmtAcctCr as amtacct25_437_, financialm0_.C_UOM_ID as c_uom_i26_437_, financialm0_.Qty as qty27_437_, financialm0_.M_Product_ID as m_produ28_437_, financialm0_.C_BPartner_ID as c_bpart29_437_, financialm0_.AD_OrgTrx_ID as ad_orgt30_437_, financialm0_.C_LocFrom_ID as c_locfr31_437_, financialm0_.C_LocTo_ID as c_locto32_437_, financialm0_.C_SalesRegion_ID as c_sales33_437_, financialm0_.C_Project_ID as c_proje34_437_, financialm0_.C_Campaign_ID as c_campa35_437_, financialm0_.C_Activity_ID as c_activ36_437_, financialm0_.User1_ID as user37_437_, financialm0_.User2_ID as user38_437_, financialm0_.Description as descrip39_437_, financialm0_.A_Asset_ID as a_asset40_437_, financialm0_.Fact_Acct_Group_ID as fact_ac41_437_, financialm0_.SeqNo as seqno42_437_, financialm0_.FactAcctType as factacc43_437_, financialm0_.DocBaseType as docbase44_437_, financialm0_.AcctValue as acctval45_437_, financialm0_.AcctDescription as acctdes46_437_, financialm0_.Record_ID2 as record_47_437_, financialm0_.C_Withholding_ID as c_withh48_437_, financialm0_.C_Doctype_ID as c_docty49_437_, financialm0_.C_Costcenter_ID as c_costc50_437_, financialm0_.Ismodify as ismodif51_437_, financialm0_.Datebalanced as datebal52_437_ from Fact_Acct financialm0_ where (financialm0_.AD_Org_ID in ('0', '975163BBDF184727BFA9D21FECF88F51', '0145CB12BBE04855B3C433728BD65F7C', '7EEF753D8C114D32A101EA8393FEAC19', '8997B74B935D46B08D5E187F5B343F48', '9DFF9C5278274C2DA3F411C2BA23605C')) and (financialm0_.AD_Client_ID in ('29E43D204AEB4CEC9D1DC4EFFD0E5987', '0')) order by financialm0_.AmtAcctDr desc, financialm0_.Fact_Acct_ID desc limit '101'; [ Date: 2026-07-13 10:13:19 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
4	15s994ms	SELECT profile.take_sample (); [ Date: 2026-07-13 11:00:17 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
5	15s437ms	SELECT COUNT() AS ID FROM MRP_Run_ProductionLine WHERE MA_Processplan_ID = 'EA190026B5AB4D7F8DB1E268FF5ED21E' AND EXISTS ( SELECT 1 FROM MRP_Run_Production WHERE MRP_Run_Production.MRP_Run_Production_ID = MRP_Run_ProductionLine.MRP_Run_Production_ID) AND AD_ORG_ID IN ('0', '975163BBDF184727BFA9D21FECF88F51', '0145CB12BBE04855B3C433728BD65F7C', '7EEF753D8C114D32A101EA8393FEAC19', '8997B74B935D46B08D5E187F5B343F48', '9DFF9C5278274C2DA3F411C2BA23605C') AND AD_CLIENT_ID IN ('29E43D204AEB4CEC9D1DC4EFFD0E5987'); [ Date:* 2026-07-13 12:22:15 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
6	15s383ms	SELECT COUNT() AS ID FROM MRP_Run_ProductionLine WHERE MA_Processplan_ID = 'EA190026B5AB4D7F8DB1E268FF5ED21E' AND EXISTS ( SELECT 1 FROM MRP_Run_Production WHERE MRP_Run_Production.MRP_Run_Production_ID = MRP_Run_ProductionLine.MRP_Run_Production_ID) AND AD_ORG_ID NOT IN ('0', '975163BBDF184727BFA9D21FECF88F51', '0145CB12BBE04855B3C433728BD65F7C', '7EEF753D8C114D32A101EA8393FEAC19', '8997B74B935D46B08D5E187F5B343F48', '9DFF9C5278274C2DA3F411C2BA23605C'); [ Date:* 2026-07-13 12:21:59 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
7	15s134ms	SELECT B.* FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, SUM(AMOUNT) AS AMOUNT, SUM(QTY) AS QTY, SUM(WEIGHT) AS WEIGHT, SUM( COST) AS COST, SUM(AMOUNTREF) AS AMOUNTREF, SUM(QTYREF) AS QTYREF, SUM(WEIGHTREF) AS WEIGHTREF, SUM(CONVAMOUNT) AS CONVAMOUNT, CASE WHEN SUM(COSTCALCULATED) = 0 THEN SUM(CONVCOST) WHEN SUM(GROUPCOUNT) <> SUM(COSTCALCULATED) THEN SUM(CONVCOST) WHEN SUM(COSTEDAMT) = 0 AND SUM(CONVCOST) > 0 THEN SUM(CONVCOST) WHEN SUM( CASE WHEN GROUPCOUNT = COSTCALCULATED THEN 0 ELSE CONVAMOUNT END) = 0 THEN SUM(CONVCOST) ELSE SUM(CONVCOST) * SUM(CONVAMOUNT) / SUM( CASE WHEN GROUPCOUNT = COSTCALCULATED THEN 0 ELSE CONVAMOUNT END) END AS CONVCOST, SUM(CONVAMOUNTREF) AS CONVAMOUNTREF, SUM(CONVCOSTREF) AS CONVCOSTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, SUM(ZZ.COSTCALCULATED) AS COSTCALCULATED FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, SUM(LINENETAMT) AS AMOUNT, SUM(QTYINVOICED) AS QTY, SUM(WEIGHT) AS WEIGHT, SUM( COST) AS COST, SUM(LINENETREF) AS AMOUNTREF, SUM(QTYINVOICEDREF) AS QTYREF, SUM(WEIGHT_REF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM(LINENETAMT), TRCURRENCYID, '102', TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, CASE WHEN SUM(COSTCALCULATED) >= 0 THEN SUM( COST) WHEN SUM(COSTEDAMT) = 0 AND SUM( COST) > 0 THEN SUM( COST) ELSE SUM( COST) * SUM(LINENETAMT) / SUM(COSTEDAMT) END AS CONVCOST, 0 AS CONVAMOUNTREF, 0 AS CONVCOSTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, SUM(AA.COSTCALCULATED) as COSTCALCULATED, C_CURRENCY_CONVERT (SUM(COSTEDAMT), TRCURRENCYID, '102', TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS costedamt, COUNT() AS GROUPCOUNT FROM ( SELECT to_char(AD_COLUMN_IDENTIFIER (to_char('C_Bpartner'), to_char(C_BPARTNER.C_BPARTNER_ID), to_char('es_ES'))) AS NIVEL1, to_char('') AS NIVEL2, to_char('') AS NIVEL3, to_char('') AS NIVEL4, to_char('') AS NIVEL5, to_char('') AS NIVEL6, to_char('') AS NIVEL7, to_char('') AS NIVEL8, to_char('') AS NIVEL9, to_char('') AS NIVEL10, CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN C_INVOICELINE.LINENETAMT -1 ELSE C_INVOICELINE.LINENETAMT END AS LINENETAMT, CASE WHEN c_doctype.docbasetype = 'ARC' THEN c_invoiceline.qtyinvoiced * -1 ELSE c_invoiceline.qtyinvoiced END AS QTYINVOICED, C_INVOICELINE.QTYINVOICED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYINVOICEDREF, 0 AS WEIGHT_REF, C_UOM.UOMSYMBOL, C_INVOICE.C_CURRENCY_ID AS TRCURRENCYID, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())) AS TRDATE, C_INVOICELINE.AD_CLIENT_ID AS TRCLIENTID, C_INVOICELINE.AD_ORG_ID AS TRORGID, CASE WHEN sum(trxcost.total_cost) is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 1 ELSE 0 END AS COSTCALCULATED, CASE WHEN M_PRODUCT.ISSTOCKED = 'Y' AND M_PRODUCT.PRODUCTTYPE = 'I' THEN CASE WHEN C_INVOICELINE.M_INOUTLINE_ID IS NULL THEN COALESCE(M_GET_NO_TRX_PRD_COST_LATEST (M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, AD_ORG.AD_ORG_ID, NULL, C_INVOICE.C_CURRENCY_ID, 'N'), 0) * ( CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN C_INVOICELINE.QTYINVOICED * -1 ELSE C_INVOICELINE.QTYINVOICED END) WHEN TRX.MOVEMENTQTY = 0 THEN 0 ELSE CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN -1 * COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(MAX(trxcost.total_cost) / ABS(TRX.MOVEMENTQTY) * C_INVOICELINE.QTYINVOICED, C_GET_CURRENCY_PRECISION (MAX(trxcost.c_currency_id), 'C')), MAX(trxcost.c_currency_id), '102', TRX.MOVEMENTDATE, NULL, TRX.AD_CLIENT_ID, TRX.AD_ORG_ID, 'C'), 0) ELSE COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(MAX(trxcost.total_cost) / ABS(TRX.MOVEMENTQTY) * C_INVOICELINE.QTYINVOICED, C_GET_CURRENCY_PRECISION (MAX(trxcost.c_currency_id), 'C')), MAX(trxcost.c_currency_id), '102', TRX.MOVEMENTDATE, NULL, TRX.AD_CLIENT_ID, TRX.AD_ORG_ID, 'C'), 0) END END ELSE COALESCE(M_GET_NO_TRX_PRD_COST_LATEST (M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, AD_ORG.AD_ORG_ID, NULL, C_INVOICE.C_CURRENCY_ID, 'N'), 0) * ( CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN C_INVOICELINE.QTYINVOICED * -1 ELSE C_INVOICELINE.QTYINVOICED END) END AS COST, CASE WHEN sum(trxcost.total_cost) is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 0 ELSE CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN C_INVOICELINE.LINENETAMT * -1 ELSE C_INVOICELINE.LINENETAMT END END AS COSTEDAMT FROM C_INVOICELINE join C_INVOICE on C_INVOICE.C_INVOICE_ID = C_INVOICELINE.C_INVOICE_ID join C_BPARTNER on C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID join C_BP_GROUP on C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID join AD_ORG on C_INVOICE.AD_ORG_ID = AD_ORG.AD_ORG_ID left join C_BPARTNER CB on C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID left join AD_USER on C_INVOICE.SALESREP_ID = AD_USER.AD_USER_ID left join C_PROJECT on C_INVOICE.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID left join C_DOCTYPE on C_INVOICE.C_DOCTYPE_ID = C_DOCTYPE.C_DOCTYPE_ID left join M_PRODUCT on C_INVOICELINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID left join C_UOM on C_INVOICELINE.C_UOM_ID = C_UOM.C_UOM_ID left join M_PRODUCT_CATEGORY on M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID left join M_INOUTLINE on C_INVOICELINE.M_INOUTLINE_ID = M_INOUTLINE.M_INOUTLINE_ID left join M_INOUT ON M_INOUTLINE.M_INOUT_ID = M_INOUT.M_INOUT_ID left join m_transaction trx ON trx.m_inoutline_id = m_inoutline.m_inoutline_id left join ( SELECT m_transaction_id, SUM( cost) AS total_cost, MAX(c_currency_id) AS c_currency_id FROM m_transaction_cost GROUP BY m_transaction_id) trxcost ON trx.m_transaction_id = trxcost.m_transaction_id WHERE C_INVOICE.ISSOTRX = 'Y' AND C_INVOICE.PROCESSED = 'Y' AND C_INVOICE.AD_ORG_ID IN ('9DFF9C5278274C2DA3F411C2BA23605C', '975163BBDF184727BFA9D21FECF88F51', '8997B74B935D46B08D5E187F5B343F48', '7EEF753D8C114D32A101EA8393FEAC19', '0145CB12BBE04855B3C433728BD65F7C', '0') AND C_INVOICE.AD_CLIENT_ID IN ('0', '29E43D204AEB4CEC9D1DC4EFFD0E5987') AND 1 = 1 AND C_INVOICE.DATEINVOICED >= to_date('01-05-2024') AND C_INVOICE.DATEINVOICED < to_date('01-06-2024') GROUP BY trxcost.m_transaction_id, C_INVOICELINE.C_INVOICELINE_ID, C_BPARTNER.C_BPARTNER_ID, M_PRODUCT_CATEGORY.NAME, C_INVOICE.DOCUMENTNO, AD_ORG.NAME, AD_USER.AD_USER_ID, C_PROJECT.NAME, AD_USER.FIRSTNAME, AD_USER.LASTNAME, C_BP_GROUP.NAME, M_INOUT.C_BPARTNER_LOCATION_ID, C_INVOICELINE.AD_CLIENT_ID, C_INVOICELINE.AD_ORG_ID, C_INVOICELINE.LINENETAMT, C_INVOICELINE.QTYINVOICED, C_UOM.UOMSYMBOL, c_doctype.docbasetype, ad_org.ad_org_id, C_INVOICE.C_CURRENCY_ID, C_INVOICE.DATEINVOICED, trx.movementqty, trx.movementdate, trx.ad_client_id, trx.ad_org_id, M_PRODUCT.WEIGHT, M_PRODUCT.M_PRODUCT_ID, M_PRODUCT.ISSTOCKED, M_PRODUCT.PRODUCTTYPE, C_INVOICELINE.M_INOUTLINE_ID ORDER BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10 ORDER BY NIVEL1) B LIMIT 20001; [ Date: 2026-07-13 16:11:37 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
8	14s214ms	SELECT profile.take_sample (); [ Date: 2026-07-13 13:00:15 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
9	12s993ms	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-13 12:15:25 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
10	12s752ms	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-13 15:25:22 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
11	11s888ms	select a.id, ev.value as account_id, COALESCE(ev_trl.name, ev.name) as name, a.initialamt as SALDO_INICIAL, a.amtacctcr, a.amtacctdr, A.INITIALAMT + A.AMTACCTDR - A.AMTACCTCR AS SALDO_FINAL, a.groupbyid, CASE ad_column_identifier ('',groupbyid,TO_CHAR('es_ES')) WHEN '' THEN '' ELSE ad_column_identifier ('',groupbyid,TO_CHAR('es_ES')) END AS groupbyname from( SELECT sum(case when (DATEACCT < TO_DATE('01-01-2026') or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = 'O')) then F.AMTACCTDR - F.AMTACCTCR else 0 end) as initialamt, sum(case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTDR else 0 end) as AMTACCTDR, sum(case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTCR else 0 end) as AMTACCTCR, F.ACCOUNT_ID AS ID, to_char('') AS groupbyid FROM FACT_ACCT F WHERE F.AD_ORG_ID IN ('9DFF9C5278274C2DA3F411C2BA23605C', '975163BBDF184727BFA9D21FECF88F51', '8997B74B935D46B08D5E187F5B343F48', '7EEF753D8C114D32A101EA8393FEAC19', '0145CB12BBE04855B3C433728BD65F7C', '0') AND F.AD_CLIENT_ID IN ('0', '29E43D204AEB4CEC9D1DC4EFFD0E5987') AND F.AD_ORG_ID IN ('9DFF9C5278274C2DA3F411C2BA23605C', '975163BBDF184727BFA9D21FECF88F51', '8997B74B935D46B08D5E187F5B343F48', '7EEF753D8C114D32A101EA8393FEAC19', '0145CB12BBE04855B3C433728BD65F7C', '0') AND DATEACCT < TO_DATE('01-01-2027') AND 1 = 1 AND F.C_ACCTSCHEMA_ID = '07852E85025D4759A77318FB991C7B8F' AND F.ISACTIVE = 'Y' group by F.ACCOUNT_ID) a LEFT JOIN c_elementvalue ev ON a.id = ev.c_elementvalue_id LEFT JOIN c_elementvalue_trl ev_trl ON ev.c_elementvalue_id = ev_trl.c_elementvalue_id AND ev_trl.ad_language = 'es_ES' WHERE ev.elementlevel = 'S' AND 2 = 2 AND EV.VALUE >= '524000000' AND EV.VALUE <= '524000000' and (a.initialamt <> 0 or a.amtacctcr <> 0 or a.amtacctdr <> 0) order by ev.value, ev.name, id, groupbyname; [ Date: 2026-07-13 08:22:32 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query:** yes ]
12	11s717ms	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-13 20:20:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
13	11s498ms	SELECT profile.take_sample (); [ Date: 2026-07-13 07:00:12 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
14	11s325ms	SELECT profile.take_sample (); [ Date: 2026-07-13 14:00:13 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
15	9s234ms	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-13 12:15:58 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
16	9s173ms	select financialm0_.C_ElementValue_ID as c_elemen1_229_, financialm0_.AD_Client_ID as ad_clien2_229_, financialm0_.AD_Org_ID as ad_org_i3_229_, financialm0_.IsActive as isactive4_229_, financialm0_.Created as created5_229_, financialm0_.CreatedBy as createdb6_229_, financialm0_.Updated as updated7_229_, financialm0_.UpdatedBy as updatedb8_229_, financialm0_.Value as value9_229_, financialm0_.Name as name10_229_, financialm0_.Description as descrip11_229_, financialm0_.AccountType as account12_229_, financialm0_.AccountSign as account13_229_, financialm0_.IsDocControlled as isdocco14_229_, financialm0_.C_Element_ID as c_eleme15_229_, financialm0_.IsSummary as issumma16_229_, financialm0_.ValidFrom as validfr17_229_, financialm0_.ValidTo as validto18_229_, financialm0_.PostActual as postact19_229_, financialm0_.PostBudget as postbud20_229_, financialm0_.PostEncumbrance as postenc21_229_, financialm0_.PostStatistical as poststa22_229_, financialm0_.IsBankAccount as isbanka23_229_, financialm0_.C_BankAccount_ID as c_banka24_229_, financialm0_.IsForeignCurrency as isforei25_229_, financialm0_.C_Currency_ID as c_curre26_229_, financialm0_.ShowElement as showele27_229_, financialm0_.ShowValueCond as showval28_229_, financialm0_.ElementLevel as element29_229_, financialm0_.Isalwaysshown as isalway30_229_, financialm0_.EM_Etasv_Excludefromvalidation as em_etas31_229_, financialm0_.EM_Etvatr_Vat_Regularization as em_etva32_229_, financialm0_.EM_Pruti_Create_Glitem as em_prut33_229_ from C_ElementValue financialm0_ where (upper((financialm0_.Value \|\| ' - ' \|\| coalesce(to_char(( select financialm1_.Name from C_ElementValue_Trl financialm1_ where financialm1_.C_ElementValue_ID = financialm0_.C_ElementValue_ID and financialm1_.AD_Language = 'es_ES')), to_char(financialm0_.Name), ''))) like upper('%70%') escape '\|') and (exists ( select 1 from Fact_Acct financialm2_ left outer join C_ElementValue financialm3_ on financialm2_.Account_ID = financialm3_.C_ElementValue_ID where financialm3_.C_ElementValue_ID = financialm0_.C_ElementValue_ID and (financialm2_.AD_Org_ID in ('0', '975163BBDF184727BFA9D21FECF88F51', '0145CB12BBE04855B3C433728BD65F7C', '7EEF753D8C114D32A101EA8393FEAC19', '8997B74B935D46B08D5E187F5B343F48', '9DFF9C5278274C2DA3F411C2BA23605C')) and (financialm2_.AD_Client_ID in ('29E43D204AEB4CEC9D1DC4EFFD0E5987', '0')))) order by financialm0_.Value, financialm0_.Name limit '76'; [ Date: 2026-07-13 10:49:21 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
17	8s609ms	select a.id, ev.value as account_id, COALESCE(ev_trl.name, ev.name) as name, a.initialamt as SALDO_INICIAL, a.amtacctcr, a.amtacctdr, A.INITIALAMT + A.AMTACCTDR - A.AMTACCTCR AS SALDO_FINAL, a.groupbyid, CASE ad_column_identifier ('',groupbyid,TO_CHAR('es_ES')) WHEN '' THEN '' ELSE ad_column_identifier ('',groupbyid,TO_CHAR('es_ES')) END AS groupbyname from( SELECT sum(case when (DATEACCT < TO_DATE('01-01-2026') or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = 'O')) then F.AMTACCTDR - F.AMTACCTCR else 0 end) as initialamt, sum(case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTDR else 0 end) as AMTACCTDR, sum(case when (DATEACCT >= TO_DATE('01-01-2026') AND F.FACTACCTTYPE not in('O', 'R', 'C')) or (DATEACCT = TO_DATE('01-01-2026') and F.FACTACCTTYPE = NULL) then F.AMTACCTCR else 0 end) as AMTACCTCR, F.ACCOUNT_ID AS ID, to_char('') AS groupbyid FROM FACT_ACCT F WHERE F.AD_ORG_ID IN ('9DFF9C5278274C2DA3F411C2BA23605C', '975163BBDF184727BFA9D21FECF88F51', '8997B74B935D46B08D5E187F5B343F48', '7EEF753D8C114D32A101EA8393FEAC19', '0145CB12BBE04855B3C433728BD65F7C', '0') AND F.AD_CLIENT_ID IN ('0', '29E43D204AEB4CEC9D1DC4EFFD0E5987') AND F.AD_ORG_ID IN ('9DFF9C5278274C2DA3F411C2BA23605C', '975163BBDF184727BFA9D21FECF88F51', '8997B74B935D46B08D5E187F5B343F48', '7EEF753D8C114D32A101EA8393FEAC19', '0145CB12BBE04855B3C433728BD65F7C', '0') AND DATEACCT < TO_DATE('01-01-2027') AND 1 = 1 AND F.C_ACCTSCHEMA_ID = '07852E85025D4759A77318FB991C7B8F' AND F.ISACTIVE = 'Y' group by F.ACCOUNT_ID) a LEFT JOIN c_elementvalue ev ON a.id = ev.c_elementvalue_id LEFT JOIN c_elementvalue_trl ev_trl ON ev.c_elementvalue_id = ev_trl.c_elementvalue_id AND ev_trl.ad_language = 'es_ES' WHERE ev.elementlevel = 'S' AND 2 = 2 AND EV.VALUE >= '572000000' AND EV.VALUE <= '573000003' and (a.initialamt <> 0 or a.amtacctcr <> 0 or a.amtacctdr <> 0) order by ev.value, ev.name, id, groupbyname; [ Date: 2026-07-13 09:54:22 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query:** yes ]
18	8s378ms	SELECT profile.take_sample (); [ Date: 2026-07-13 18:00:10 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
19	7s877ms	delete from C_OrderLine where C_OrderLine_ID = '1B503091E28C4235A23090DCBDE7B5BA'; [ Date: 2026-07-13 15:03:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
20	7s479ms	delete from C_OrderLine where C_OrderLine_ID = 'CA91140FA27F4BE091BCBA2DF93FA9CA'; [ Date: 2026-07-13 15:39:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

Time consuming queries (N)


[ User: postgres - Total duration: 1m50s - Times executed: 15 ]
[ User: tad - Total duration: 1m24s - Times executed: 6 ]
[ User: tad - Total duration: 58s91ms - Times executed: 6 ]
[ User: tad - Total duration: 23s148ms - Times executed: 3 ]
[ User: tad - Total duration: 20s498ms - Times executed: 2 ]
[ User: tad - Total duration: 19s251ms - Times executed: 2 ]
[ User: tad - Total duration: 18s733ms - Times executed: 12 ]
[ User: tad - Total duration: 16s498ms - Times executed: 3 ]
[ User: tad - Total duration: 15s437ms - Times executed: 1 ]
[ User: tad - Total duration: 15s383ms - Times executed: 1 ]
[ User: tad - Total duration: 15s134ms - Times executed: 1 ]
[ User: tad - Total duration: 11s667ms - Times executed: 3 ]
[ User: tad - Total duration: 10s965ms - Times executed: 3 ]
[ User: tad - Total duration: 10s99ms - Times executed: 4 ]
[ User: tad - Total duration: 9s864ms - Times executed: 8 ]
[ User: tad - Total duration: 9s173ms - Times executed: 1 ]
[ User: tad - Total duration: 8s263ms - Times executed: 3 ]
[ User: tad - Total duration: 7s301ms - Times executed: 3 ]
[ User: tad - Total duration: 7s153ms - Times executed: 2 ]
[ User: tad - Total duration: 6s888ms - Times executed: 2 ]

Most frequent queries (N)


[ User: postgres - Total duration: 1m50s - Times executed: 15 ]
[ User: tad - Total duration: 18s733ms - Times executed: 12 ]
[ User: tad - Total duration: 9s864ms - Times executed: 8 ]
[ User: tad - Total duration: 1m24s - Times executed: 6 ]
[ User: tad - Total duration: 58s91ms - Times executed: 6 ]
[ User: tad - Total duration: 10s99ms - Times executed: 4 ]
[ User: tad - Total duration: 4s762ms - Times executed: 4 ]
[ User: tad - Total duration: 23s148ms - Times executed: 3 ]
[ User: tad - Total duration: 16s498ms - Times executed: 3 ]
[ User: tad - Total duration: 11s667ms - Times executed: 3 ]
[ User: tad - Total duration: 10s965ms - Times executed: 3 ]
[ User: tad - Total duration: 8s263ms - Times executed: 3 ]
[ User: tad - Total duration: 7s301ms - Times executed: 3 ]
[ User: tad - Total duration: 5s952ms - Times executed: 3 ]
[ User: tad - Total duration: 5s900ms - Times executed: 3 ]
[ User: tad - Total duration: 4s35ms - Times executed: 3 ]
[ User: tad - Total duration: 3s958ms - Times executed: 3 ]
[ User: tad - Total duration: 3s688ms - Times executed: 3 ]
[ User: tad - Total duration: 3s632ms - Times executed: 3 ]
[ User: tad - Total duration: 3s398ms - Times executed: 3 ]

Normalized slowest queries (N)


[ User: tad - Total duration: 15s437ms - Times executed: 1 ]
[ User: tad - Total duration: 15s383ms - Times executed: 1 ]
[ User: tad - Total duration: 15s134ms - Times executed: 1 ]
[ User: tad - Total duration: 1m24s - Times executed: 6 ]
[ User: tad - Total duration: 20s498ms - Times executed: 2 ]
[ User: tad - Total duration: 58s91ms - Times executed: 6 ]
[ User: tad - Total duration: 19s251ms - Times executed: 2 ]
[ User: tad - Total duration: 9s173ms - Times executed: 1 ]
[ User: tad - Total duration: 23s148ms - Times executed: 3 ]
[ User: postgres - Total duration: 1m50s - Times executed: 15 ]
[ User: tad - Total duration: 16s498ms - Times executed: 3 ]
[ User: tad - Total duration: 11s667ms - Times executed: 3 ]
[ User: tad - Total duration: 10s965ms - Times executed: 3 ]
[ User: tad - Total duration: 7s153ms - Times executed: 2 ]
[ User: tad - Total duration: 6s888ms - Times executed: 2 ]
[ User: tad - Total duration: 8s263ms - Times executed: 3 ]
[ User: tad - Total duration: 10s99ms - Times executed: 4 ]
[ User: tad - Total duration: 7s301ms - Times executed: 3 ]
[ User: tad - Total duration: 5s952ms - Times executed: 3 ]
[ User: tad - Total duration: 5s900ms - Times executed: 3 ]

Time consuming prepare

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

Time consuming bind

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

Log levels

Key values

81,720 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	9	0.01%
DETAIL	118	0.14%
ERROR	22	0.03%
EVENTLOG	8,770	10.73%
LOG	72,770	89.05%
STATEMENT	31	0.04%

Events distribution (except queries)

Key values

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

Most Frequent Errors/Events

Key values

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


Date: 2026-07-13 07:00:03
Database: etendo
Application: [unknown]
User: tad
Remote: 10.10.11.43
Date: 2026-07-13 07:00:13
Database: etendo
Application: [unknown]
User: tad
Remote: 10.10.11.43
Date: 2026-07-13 08:00:54
Database: etendo
Application: [unknown]
User: tad
Remote: 172.30.3.29
Date: 2026-07-13 09:19:16
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1
Date: 2026-07-13 09:12:56
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1
Date: 2026-07-13 11:53:38
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1
Date: 2026-07-13 07:21:10
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Average Autovacuum Duration

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Vacuum throughput per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Autovacuum Activity

Locks

Locks by types

Key values

Type of locks

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database