pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sun Jul 19 23:00:11 2026
Log file: /var/log/postgresql/postgresql-16-main.log
Parsed 67,083 log entries in 9s
Log start from 2026-07-19 07:00:01 to 2026-07-19 22:00:00

Global Stats

4 Number of unique normalized queries
25 Number of queries
3m20s Total query duration
2026-07-19 07:00:03 First query
2026-07-19 21:00:04 Last query
1 queries/s at 2026-07-19 17:14:04 Query peak

3m20s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
3m20s Execute total duration

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

37,409 Total number of automatic vacuums
134 Total number of automatic analyzes

10 Number temporary file
3.50 MiB Max size of temporary file
1.75 MiB Average size of temporary file

3,412 Total number of sessions
68 sessions at 2026-07-19 19:12:56 Session peak
2d22h25m34s Total duration of sessions
1m14s Average duration of sessions
0 Average queries per session
58ms Average queries duration per session
1m14s Average idle time per session

3,412 Total number of connections
6 connections/s at 2026-07-19 17:00:00 Connection peak
1 Total number of databases

SQL Traffic

Key values

1 queries/s Query Peak
2026-07-19 17:14:04 Date

SELECT Traffic

Key values

1 queries/s Query Peak
2026-07-19 17:14:04 Date

INSERT/UPDATE/DELETE Traffic

Key values

0 queries/s Query Peak
Date

Queries duration

Key values

3m20s 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 19	07	1	0ms	2s181ms	2s181ms	0ms	0ms	2s181ms
	08	1	0ms	2s198ms	2s198ms	0ms	0ms	2s198ms
	09	1	0ms	2s202ms	2s202ms	0ms	0ms	2s202ms
	10	1	0ms	2s293ms	2s293ms	0ms	0ms	2s293ms
	11	1	0ms	2s195ms	2s195ms	0ms	0ms	2s195ms
	12	2	0ms	23s332ms	12s764ms	0ms	0ms	23s332ms
	13	2	0ms	23s651ms	12s933ms	0ms	0ms	23s651ms
	14	3	0ms	23s834ms	9s137ms	0ms	0ms	25s33ms
	15	2	0ms	22s722ms	12s452ms	0ms	0ms	22s722ms
	16	1	0ms	2s297ms	2s297ms	0ms	0ms	2s297ms
	17	3	0ms	23s769ms	9s115ms	0ms	0ms	25s137ms
	18	3	0ms	23s752ms	9s27ms	0ms	1s10ms	23s752ms
	19	2	0ms	22s330ms	12s324ms	0ms	0ms	22s330ms
	20	1	0ms	2s355ms	2s355ms	0ms	0ms	2s355ms
	21	1	0ms	2s253ms	2s253ms	0ms	0ms	2s253ms
	22	0	0ms	0ms	0ms	0ms	0ms	0ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 19	07	1	2s181ms	0ms	0ms	0ms
	08	1	2s198ms	0ms	0ms	0ms
	09	1	2s202ms	0ms	0ms	0ms
	10	1	2s293ms	0ms	0ms	0ms
	11	1	2s195ms	0ms	0ms	0ms
	12	2	12s764ms	0ms	0ms	2s197ms
	13	2	12s933ms	0ms	0ms	2s215ms
	14	3	9s137ms	0ms	0ms	2s379ms
	15	2	12s452ms	0ms	0ms	2s183ms
	16	1	2s297ms	0ms	0ms	0ms
	17	3	9s115ms	0ms	0ms	2s208ms
	18	3	9s27ms	0ms	0ms	2s319ms
	19	2	12s324ms	0ms	0ms	2s319ms
	20	1	2s355ms	0ms	0ms	0ms
	21	1	2s253ms	0ms	0ms	0ms
	22	0	0ms	0ms	0ms	0ms

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

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

Day	Hour	Count	Average / Second
Jul 19	07	218	0.06/s
	08	224	0.06/s
	09	223	0.06/s
	10	223	0.06/s
	11	224	0.06/s
	12	232	0.06/s
	13	232	0.06/s
	14	233	0.06/s
	15	231	0.06/s
	16	223	0.06/s
	17	233	0.06/s
	18	232	0.06/s
	19	232	0.06/s
	20	224	0.06/s
	21	223	0.06/s
	22	5	0.00/s

Day	Hour	Count	Average Duration	Average idle time
Jul 19	07	222	1m40s	1m40s
	08	224	1m24s	1m24s
	09	223	51s946ms	51s936ms
	10	223	1m	1m
	11	224	1m32s	1m32s
	12	232	54s400ms	54s290ms
	13	232	1m40s	1m40s
	14	233	54s718ms	54s600ms
	15	231	1m1s	1m1s
	16	223	1m40s	1m40s
	17	233	1m17s	1m17s
	18	232	1m25s	1m25s
	19	232	1m17s	1m17s
	20	224	1m16s	1m16s
	21	223	35s806ms	35s796ms
	22	1	28ms	28ms

↑ Back to the top of the General Activity table

Established Connections

Key values

6 connections Connection Peak
2026-07-19 17:00:00 Date

Connections per database

Key values

etendo Main Database
3,412 connections Total

Chart
Table

Database	User	Count
etendo		3,397
	postgres	60
	tad	3,337
postgres		15
	postgres	15

Connections per user

Key values

tad Main User
3,412 connections Total

Chart
Table

User	Count
postgres	75
tad	3,337

Connections per host

Key values

127.0.0.1 Main host with 3274 connections
3,412 Total connections

Chart
Table

Host	Count
127.0.0.1	3,274
46.183.115.21	63
[local]	75

Simultaneous sessions

Key values

68 sessions Session Peak
2026-07-19 19:12:56 Date

Histogram of session times

Key values

3,225 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	3,225	94.52%
500ms-1s	15	0.44%
1s-30s	15	0.44%
30s-1m	0	0.00%
1m-10m	100	2.93%
10m-30m	0	0.00%
30m-1h	22	0.64%
1h-8h	35	1.03%
> 8h	0	0.00%

Sessions per database

Key values

etendo Main Database
3,412 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
etendo	3,397	2d22h25m34s	1m14s
postgres	15	764ms	50ms

Sessions per user

Key values

tad Main User
3,412 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
postgres	75	47s696ms	635ms
tad	3,337	2d22h24m47s	1m15s

Sessions per host

Key values

127.0.0.1 Main Host
3,412 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	3,274	2d16h54m	1m11s
46.183.115.21	63	5h30m46s	5m15s
[local]	75	47s696ms	635ms

Sessions per application

Key values

psql Main Application
3,412 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
Mashup Engine	63	5h30m46s	5m15s
openbravo	94	2d16h53m3s	41m24s
pg_profile	45	13s718ms	304ms
psql	3,210	1m31s	28ms

Checkpoints Buffers

Key values

3,735 buffers Checkpoint Peak
2026-07-19 07:07:05 Date
270.021 seconds Highest write time
0.004 seconds Sync time

Checkpoints Wal files

Key values

1 files Wal files usage Peak
2026-07-19 11:07:07 Date

Checkpoints distance

Key values

33.86 Mo Distance Peak
2026-07-19 19:07:24 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jul 19	07	4,523	346.093s	0.015s	346.127s
	08	4,018	307.969s	0.012s	307.996s
	09	3,969	309.696s	0.012s	309.731s
	10	4,062	316.014s	0.012s	316.043s
	11	4,030	310.237s	0.018s	310.275s
	12	3,951	311.297s	0.012s	311.327s
	13	3,959	312.147s	0.014s	312.18s
	14	4,146	322.782s	0.014s	322.813s
	15	4,041	313.758s	0.013s	313.785s
	16	3,989	311.218s	0.012s	311.25s
	17	4,030	311.826s	0.012s	311.854s
	18	3,977	308.489s	0.013s	308.518s
	19	4,172	315.062s	0.013s	315.09s
	20	4,026	312.817s	0.012s	312.849s
	21	4,033	312.606s	0.014s	312.637s
	22	0	0s	0s	0s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jul 19	07	2	456	0.003s	0.012s
	08	1	435	0.001s	0.012s
	09	1	429	0.001s	0.012s
	10	1	452	0.001s	0.012s
	11	1	443	0.004s	0.012s
	12	1	438	0.001s	0.012s
	13	1	435	0.002s	0.012s
	14	2	472	0.002s	0.012s
	15	1	451	0.001s	0.012s
	16	1	443	0.001s	0.012s
	17	1	441	0.001s	0.012s
	18	1	433	0.001s	0.012s
	19	1	453	0.001s	0.012s
	20	1	442	0.001s	0.012s
	21	1	445	0.002s	0.012s
	22	0	0	0s	0s

Day	Hour	Avg time (sec)
Jul 19	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
	22	0s

Day	Hour	Mean distance	Mean estimate
Jul 19	07	1,746.58 kB	10,398.17 kB
	08	1,529.75 kB	10,374.33 kB
	09	1,514.25 kB	10,243.17 kB
	10	1,537.25 kB	10,308.58 kB
	11	1,532.42 kB	10,396.92 kB
	12	1,488.00 kB	10,106.42 kB
	13	1,502.00 kB	10,193.75 kB
	14	1,555.33 kB	10,298.08 kB
	15	1,534.25 kB	10,383.17 kB
	16	1,513.83 kB	10,298.17 kB
	17	1,530.00 kB	10,372.33 kB
	18	1,519.17 kB	10,350.00 kB
	19	1,540.92 kB	10,410.50 kB
	20	1,529.75 kB	10,361.58 kB
	21	1,525.42 kB	10,338.17 kB
	22	0.00 kB	0.00 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

3.50 MiB Temp Files size Peak
2026-07-19 17:00:01 Date

Number of temporary files

Key values

2 per second Temp Files Peak
2026-07-19 17:00:01 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jul 19	07	0	0	0
	08	2	3.50 MiB	1.75 MiB
	09	0	0	0
	10	0	0	0
	11	2	3.50 MiB	1.75 MiB
	12	0	0	0
	13	0	0	0
	14	2	3.50 MiB	1.75 MiB
	15	0	0	0
	16	0	0	0
	17	2	3.50 MiB	1.75 MiB
	18	0	0	0
	19	0	0	0
	20	2	3.50 MiB	1.75 MiB
	21	0	0	0
	22	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	5	17.50 MiB	3.50 MiB	3.50 MiB	3.50 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-19 08:00:01 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo

Queries generating the largest temporary files


[ Date: 2026-07-19 08:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-19 11:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-19 14:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-19 17:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-19 20:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

Rank	Size	Query
1	3.50 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-19 08:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2	3.50 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-19 11:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3	3.50 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-19 14:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4	3.50 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-19 17:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5	3.50 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-19 20:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

Vacuums / Analyzes Distribution

Key values

0.44 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo
2026-07-19 20:00:41 Date
0 sec Highest CPU-cost analyze
Table
Database etendo
Date

Average Autovacuum Duration

Key values

0.44 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo
2026-07-19 20:00:41 Date

Analyzes per table

Key values

profile.last_stat_tables_srv1 (15) Main table analyzed (database etendo)
134 analyzes Total

Chart
Table

Table	Number of analyzes
etendo.profile.last_stat_tables_srv1	15
etendo.profile.last_stat_user_functions_srv1	15
etendo.profile.last_stat_statements_srv1	15
etendo.profile.last_stat_indexes_srv1	15
etendo.public.c_invoice	14
etendo.profile.tables_list	7
etendo.profile.last_stat_io	7
etendo.profile.last_stat_activity_count_srv1	4
etendo.profile.last_extension_versions	4
etendo.profile.last_stat_slru	3
etendo.public.ad_process_request	3
etendo.profile.funcs_list	2
etendo.profile.sample_statements	2
etendo.profile.indexes_list	2
etendo.profile.stmt_list	2
etendo.profile.sample_stat_tables	2
etendo.profile.sample_stat_indexes	2
etendo.profile.last_stat_wal	1
etendo.profile.last_stat_archiver	1
etendo.profile.sample_stat_user_func_total	1
etendo.profile.sample_stat_tablespaces	1
etendo.public.ad_module	1
etendo.profile.sample_stat_archiver	1
etendo.profile.samples	1
etendo.profile.sample_statements_total	1
etendo.pg_catalog.pg_type	1
etendo.profile.sample_stat_wal	1
etendo.profile.sample_stat_io	1
etendo.profile.sample_stat_tables_total	1
etendo.profile.last_stat_cluster	1
etendo.profile.sample_stat_slru	1
etendo.profile.sample_stat_indexes_total	1
postgres.pg_catalog.pg_shdepend	1
etendo.public.ad_process_run	1
etendo.profile.sample_stat_database	1
etendo.profile.sample_stat_user_functions	1
etendo.profile.sample_stat_cluster	1
Total	134

Vacuums per table

Key values

profile.funcs_list (900) Main table vacuumed on database etendo
37,409 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.funcs_list	900	0	189,090	0	9	0	0	90	0	21,690	0	0
etendo.public.m_stock_proposed	900	0	672,300	0	0	0	0	0	0	0	0	0
etendo.public.ad_pinstance_para	900	0	154,800	0	0	0	0	0	0	0	0	0
etendo.profile.sample_stat_tables_total	900	0	165,300	0	39	0	0	90	0	21,690	0	0
etendo.profile.sample_stat_io	900	0	107,430	0	39	0	0	90	0	21,690	0	0
etendo.public.c_import_entry	900	0	68,580	0	73	0	0	90	73	214,702	0	0
etendo.public.c_invoice	900	0	12,050,444	0	102	0	0	456	102	351,819	0	0
etendo.public.ad_session	900	0	309,922	0	15	0	0	18	4	12,987	0	0
etendo.profile.last_stat_activity_count_srv1	900	0	30,420	0	110	0	0	90	71	188,159	0	0
etendo.profile.last_stat_database_srv1	900	0	44,820	0	39	0	0	90	0	42,570	0	0
etendo.public.ad_pinstance	900	0	264,690	0	0	0	0	90	0	16,920	0	0
etendo.pg_catalog.pg_statistic	900	0	5,565,426	0	112	0	0	159	91	266,402	0	0
etendo.profile.last_stat_statements_srv1	900	0	3,900,522	0	76	0	0	179	76	218,770	0	0
etendo.profile.sample_stat_tables	900	0	2,232,465	0	10	0	0	107	8	44,047	0	0
etendo.public.ad_process_run	900	0	2,148,226	0	442	0	0	261	178	443,660	0	0
etendo.profile.tables_list	900	0	641,880	0	0	0	0	90	0	21,690	0	0
etendo.public.ad_process_request	900	0	509,238	0	184	0	0	126	9	49,040	0	0
etendo.public.ad_session_usage_audit	900	0	3,180,992	0	7	0	0	30	5	17,642	0	0
etendo.profile.last_stat_slru	900	0	35,850	0	42	0	0	90	0	16,920	0	0
etendo.profile.sample_stat_indexes_total	900	0	73,199	0	49	0	0	90	0	21,690	0	0
etendo.profile.indexes_list	900	0	203,580	0	10	0	0	90	0	21,690	0	0
etendo.profile.sample_stat_slru	900	0	59,398	0	24	0	0	90	0	21,690	0	0
etendo.profile.last_extension_versions	900	0	42,210	0	102	0	0	90	60	125,005	0	0
etendo.pg_toast.pg_toast_111094	900	0	913,661	0	73	0	0	91	72	189,971	0	0
etendo.pg_toast.pg_toast_2619	900	0	1,803,607	0	93	0	0	94	77	175,272	0	0
etendo.public.ad_module	900	0	284,016	0	76	0	0	91	76	231,296	0	0
etendo.profile.last_stat_tables_srv1	900	0	21,691,260	0	8	0	0	90	0	42,570	0	0
etendo.profile.sample_stat_indexes	900	0	487,689	0	11	0	0	61	9	35,190	0	0
etendo.profile.last_stat_indexes_srv1	900	0	27,992,520	0	60	0	0	90	60	148,767	0	0
etendo.profile.sample_stat_user_functions	900	0	304,170	0	18	0	0	90	0	21,690	0	0
etendo.profile.sample_stat_database	900	0	99,779	0	50	0	0	90	0	21,690	0	0
etendo.public.obmobc_logclient	900	0	5,045,399	0	180	0	0	900	0	120,600	0	0
etendo.profile.stmt_list	900	0	736,146	0	75	0	0	94	75	116,892	0	0
etendo.profile.last_stat_io	900	0	70,810	0	47	0	0	90	17	51,849	0	0
etendo.profile.last_stat_user_functions_srv1	900	0	2,003,100	0	6	0	0	90	0	42,570	0	0
etendo.profile.last_stat_tablespaces_srv1	900	0	31,410	0	45	0	0	90	0	42,570	0	0
etendo.profile.sample_statements	900	0	1,022,586	0	8	0	0	74	2	22,386	0	0
etendo.profile.last_stat_archiver	720	0	23,740	0	70	0	0	70	56	125,173	0	0
etendo.profile.last_stat_wal	720	0	23,090	0	14	0	0	70	0	13,160	0	0
etendo.profile.last_stat_cluster	720	0	23,090	0	70	0	0	70	56	123,008	0	0
etendo.profile.servers	720	0	35,812	0	68	0	0	83	56	103,285	13	62
etendo.pg_catalog.pg_type	688	0	133,057	0	27	0	0	91	2	26,954	0	0
etendo.profile.sample_statements_total	180	0	13,569	0	9	0	0	19	0	4,579	0	0
etendo.profile.sample_stat_tablespaces	180	0	10,809	0	6	0	0	19	0	4,579	0	0
etendo.profile.sample_stat_user_func_total	180	0	8,469	0	6	0	0	19	0	4,579	0	0
etendo.pg_catalog.pg_class	1	1	467	0	87	0	0	150	78	182,756	0	0
Total	37,409	1	95,409,038	67	2,591	0	0	5,132	1,313	4,011,859	13	62

Vacuum throughput per table

Key values

profile.last_stat_indexes_srv1 (339.010000000002) 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.funcs_list	0	0	0
etendo.public.m_stock_proposed	0	0	0.01
etendo.public.ad_pinstance_para	0	0	0
etendo.profile.sample_stat_tables_total	0	0	0
etendo.profile.sample_stat_io	0	0	0
etendo.public.c_import_entry	0	0	0
etendo.public.c_invoice	0	0	135.009999999999
etendo.public.ad_session	0	0	0
etendo.profile.last_stat_activity_count_srv1	0	0	0
etendo.profile.last_stat_database_srv1	0	0	0
etendo.public.ad_pinstance	0	0	0
etendo.pg_catalog.pg_statistic	0	0	64.7299999999998
etendo.profile.last_stat_statements_srv1	0	0	42.4299999999997
etendo.profile.sample_stat_tables	0	0	25.2100000000002
etendo.public.ad_process_run	0	0	18.7399999999997
etendo.profile.tables_list	0	0	0
etendo.public.ad_process_request	0	0	0.01
etendo.public.ad_session_usage_audit	0	0	35.9999999999994
etendo.profile.last_stat_slru	0	0	0
etendo.profile.sample_stat_indexes_total	0	0	0
etendo.profile.indexes_list	0	0	0
etendo.profile.sample_stat_slru	0	0	0
etendo.profile.last_extension_versions	0	0	0
etendo.pg_toast.pg_toast_111094	0	0	8.46999999999986
etendo.pg_toast.pg_toast_2619	0	0	17.9799999999997
etendo.public.ad_module	0	0	0
etendo.profile.last_stat_tables_srv1	0	0	262.540000000001
etendo.profile.sample_stat_indexes	0	0	0
etendo.profile.last_stat_indexes_srv1	0	0	339.010000000002
etendo.profile.sample_stat_user_functions	0	0	0
etendo.profile.sample_stat_database	0	0	0
etendo.public.obmobc_logclient	0	0	55.8100000000005
etendo.profile.stmt_list	0	0	0.28
etendo.profile.last_stat_io	0	0	0
etendo.profile.last_stat_user_functions_srv1	0	0	18.7499999999998
etendo.profile.last_stat_tablespaces_srv1	0	0	0
etendo.profile.sample_statements	0	0	8.99999999999985
etendo.profile.last_stat_archiver	0	0	0
etendo.profile.last_stat_wal	0	0	0
etendo.profile.last_stat_cluster	0	0	0
etendo.profile.servers	0	0	0
etendo.pg_catalog.pg_type	0	0	0
etendo.profile.sample_statements_total	0	0	0
etendo.profile.sample_stat_tablespaces	0	0	0
etendo.profile.sample_stat_user_func_total	0	0	0
etendo.pg_catalog.pg_class	0	0	0.02
Total	0	0	1,034

Tuples removed per table

Key values

pg_catalog.pg_class (147) Main table with removed tuples on database etendo
147 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
etendo.pg_catalog.pg_class	1	1	147	5,162	356	0	130
etendo.profile.funcs_list	900	0	0	858,660	649,860	0	72,900
etendo.public.m_stock_proposed	900	0	0	13,055,400	5,460,300	0	894,600
etendo.public.ad_pinstance_para	900	0	0	2,133,000	995,400	0	129,600
etendo.profile.sample_stat_tables_total	900	0	0	1,806,300	441,180	0	47,460
etendo.profile.sample_stat_io	900	0	0	1,319,160	319,920	0	29,460
etendo.profile.sample_statements_total	180	0	0	82,440	21,960	0	3,540
etendo.pg_catalog.pg_type	688	0	0	2,356,780	463,756	0	56,416
etendo.public.c_import_entry	900	0	0	46,800	46,800	0	8,100
etendo.public.c_invoice	900	0	0	42,092,047	34,514,460	0	19,365,300
etendo.public.ad_session	900	0	0	6,326,895	1,942,272	0	468,000
etendo.profile.last_stat_activity_count_srv1	900	0	0	404,100	404,100	0	10,260
etendo.profile.last_stat_database_srv1	900	0	0	201,600	198,000	0	8,460
etendo.profile.last_stat_archiver	720	0	0	41,400	40,680	0	1,440
etendo.public.ad_pinstance	900	0	0	4,098,600	1,269,000	0	219,600
etendo.pg_catalog.pg_statistic	900	0	0	31,889,461	23,533,591	0	4,156,200
etendo.profile.last_stat_wal	720	0	0	41,400	40,680	0	1,440
etendo.profile.last_stat_statements_srv1	900	0	0	36,054,533	35,356,860	0	3,183,300
etendo.profile.sample_stat_tables	900	0	0	38,732,987	10,224,420	0	1,514,700
etendo.public.ad_process_run	900	0	0	14,425,356	5,482,706	0	1,129,175
etendo.profile.tables_list	900	0	0	6,290,520	5,184,420	0	299,700
etendo.public.ad_process_request	900	0	0	2,367,478	1,559,625	0	325,800
etendo.public.ad_session_usage_audit	900	0	0	48,265,914	30,559,500	0	6,285,600
etendo.profile.last_stat_slru	900	0	0	252,000	247,500	0	4,020
etendo.profile.sample_stat_indexes_total	900	0	0	802,800	196,080	0	9,600
etendo.profile.last_stat_cluster	720	0	0	41,400	40,680	0	1,440
etendo.profile.indexes_list	900	0	0	1,260,780	861,300	0	72,000
etendo.profile.sample_stat_slru	900	0	0	803,700	196,080	0	11,700
etendo.profile.last_extension_versions	900	0	0	403,200	396,000	0	5,940
etendo.pg_toast.pg_toast_111094	900	0	0	1,745,124	1,302,324	0	436,281
etendo.profile.servers	720	0	0	41,400	40,680	0	2,160
etendo.pg_toast.pg_toast_2619	900	0	0	4,012,599	2,300,373	0	874,080
etendo.profile.sample_stat_tablespaces	180	0	0	82,440	21,960	0	720
etendo.public.ad_module	900	0	0	1,012,489	751,748	0	123,300
etendo.profile.last_stat_tables_srv1	900	0	0	193,709,880	192,069,780	0	9,860,520
etendo.profile.sample_stat_user_func_total	180	0	0	82,440	21,960	0	720
etendo.profile.sample_stat_indexes	900	0	0	13,320,690	3,444,120	0	233,460
etendo.profile.last_stat_indexes_srv1	900	0	0	303,310,980	300,611,880	0	12,342,300
etendo.profile.sample_stat_user_functions	900	0	0	10,784,160	2,577,120	0	101,820
etendo.profile.sample_stat_database	900	0	0	802,800	196,080	0	32,520
etendo.public.obmobc_logclient	900	0	0	43,435,800	25,124,400	0	2,883,600
etendo.profile.stmt_list	900	0	0	2,451,331	1,543,080	0	392,400
etendo.profile.last_stat_io	900	0	0	806,400	792,000	0	18,360
etendo.profile.last_stat_user_functions_srv1	900	0	0	26,678,160	26,246,160	0	861,780
etendo.profile.last_stat_tablespaces_srv1	900	0	0	100,800	99,000	0	1,800
etendo.profile.sample_statements	900	0	0	12,009,778	3,133,440	0	709,440
Total	37,409	1	147	870,847,144	720,923,591	0	67,191,142

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.funcs_list	900	0	0
etendo.public.m_stock_proposed	900	0	0
etendo.public.ad_pinstance_para	900	0	0
etendo.profile.sample_stat_tables_total	900	0	0
etendo.profile.sample_stat_io	900	0	0
etendo.profile.sample_statements_total	180	0	0
etendo.pg_catalog.pg_type	688	0	0
etendo.public.c_import_entry	900	0	0
etendo.public.c_invoice	900	0	0
etendo.public.ad_session	900	0	0
etendo.profile.last_stat_activity_count_srv1	900	0	0
etendo.profile.last_stat_database_srv1	900	0	0
etendo.profile.last_stat_archiver	720	0	0
etendo.public.ad_pinstance	900	0	0
etendo.pg_catalog.pg_statistic	900	0	0
etendo.profile.last_stat_wal	720	0	0
etendo.profile.last_stat_statements_srv1	900	0	0
etendo.pg_catalog.pg_class	1	1	147
etendo.profile.sample_stat_tables	900	0	0
etendo.public.ad_process_run	900	0	0
etendo.profile.tables_list	900	0	0
etendo.public.ad_process_request	900	0	0
etendo.public.ad_session_usage_audit	900	0	0
etendo.profile.last_stat_slru	900	0	0
etendo.profile.sample_stat_indexes_total	900	0	0
etendo.profile.last_stat_cluster	720	0	0
etendo.profile.indexes_list	900	0	0
etendo.profile.sample_stat_slru	900	0	0
etendo.profile.last_extension_versions	900	0	0
etendo.pg_toast.pg_toast_111094	900	0	0
etendo.profile.servers	720	0	0
etendo.pg_toast.pg_toast_2619	900	0	0
etendo.profile.sample_stat_tablespaces	180	0	0
etendo.public.ad_module	900	0	0
etendo.profile.last_stat_tables_srv1	900	0	0
etendo.profile.sample_stat_user_func_total	180	0	0
etendo.profile.sample_stat_indexes	900	0	0
etendo.profile.last_stat_indexes_srv1	900	0	0
etendo.profile.sample_stat_user_functions	900	0	0
etendo.profile.sample_stat_database	900	0	0
etendo.public.obmobc_logclient	900	0	0
etendo.profile.stmt_list	900	0	0
etendo.profile.last_stat_io	900	0	0
etendo.profile.last_stat_user_functions_srv1	900	0	0
etendo.profile.last_stat_tablespaces_srv1	900	0	0
etendo.profile.sample_statements	900	0	0
Total	37,409	1	147

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jul 19	07	2,220	11
	08	2,220	9
	09	2,220	7
	10	2,488	10
	11	2,520	8
	12	2,520	9
	13	2,520	6
	14	2,520	12
	15	2,520	10
	16	2,520	8
	17	2,520	12
	18	2,520	6
	19	2,701	12
	20	2,700	8
	21	2,700	6
	22	0	0

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

NO DATASET

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

25 Total read queries
0 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	25	100.00%
INSERT	0	0.00%
UPDATE	0	0.00%
DELETE	0	0.00%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	0	0.00%
TCL	0	0.00%
CURSOR	0	0.00%

Queries by database

Key values

etendo Main database
25 Requests
3m20s (etendo)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
etendo	Total	25	3m20s
	select	25	3m20s

Queries by user

Key values

postgres Main user
15 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	15	33s802ms
	select	15	33s802ms
tad	Total	10	2m46s
	select	10	2m46s

Duration by user

Key values

2m46s (tad) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	15	33s802ms
	select	15	33s802ms
tad	Total	10	2m46s
	select	10	2m46s

Queries by host

Key values

[local] Main host
15 Requests
2m46s (46.183.115.21)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
46.183.115.21	Total	10	2m46s
	select	10	2m46s
[local]	Total	15	33s802ms
	select	15	33s802ms

Queries by application

Key values

psql Main application
15 Requests
2m46s (Mashup Engine)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
Mashup Engine	Total	10	2m46s
	select	10	2m46s
psql	Total	15	33s802ms
	select	15	33s802ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-07-19 19:25:52 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

18 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	18	72.00%
> 10000ms	7	28.00%

Slowest individual queries


[ Date: 2026-07-19 14:12:23 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
[ Date: 2026-07-19 17:14:28 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
[ Date: 2026-07-19 18:11:03 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
[ Date: 2026-07-19 13:09:41 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
[ Date: 2026-07-19 12:12:07 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
[ Date: 2026-07-19 15:11:10 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
[ Date: 2026-07-19 19:13:07 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
[ Date: 2026-07-19 14:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-19 20:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-19 19:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-19 18:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-19 16:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-19 10:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-19 21:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-19 13:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-19 17:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-19 09:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-19 08:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-19 12:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2026-07-19 11:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]

Rank	Duration	Query
1	23s834ms	select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_"; [ Date: 2026-07-19 14:12:23 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
2	23s769ms	select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_"; [ Date: 2026-07-19 17:14:28 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
3	23s752ms	select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_"; [ Date: 2026-07-19 18:11:03 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
4	23s651ms	select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_"; [ Date: 2026-07-19 13:09:41 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
5	23s332ms	select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_"; [ Date: 2026-07-19 12:12:07 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
6	22s722ms	select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_"; [ Date: 2026-07-19 15:11:10 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
7	22s330ms	select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_"; [ Date: 2026-07-19 19:13:07 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
8	2s379ms	SELECT profile.take_sample (); [ Date: 2026-07-19 14:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
9	2s355ms	SELECT profile.take_sample (); [ Date: 2026-07-19 20:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
10	2s319ms	SELECT profile.take_sample (); [ Date: 2026-07-19 19:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
11	2s319ms	SELECT profile.take_sample (); [ Date: 2026-07-19 18:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
12	2s297ms	SELECT profile.take_sample (); [ Date: 2026-07-19 16:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
13	2s293ms	SELECT profile.take_sample (); [ Date: 2026-07-19 10:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
14	2s253ms	SELECT profile.take_sample (); [ Date: 2026-07-19 21:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
15	2s215ms	SELECT profile.take_sample (); [ Date: 2026-07-19 13:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
16	2s208ms	SELECT profile.take_sample (); [ Date: 2026-07-19 17:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
17	2s202ms	SELECT profile.take_sample (); [ Date: 2026-07-19 09:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
18	2s198ms	SELECT profile.take_sample (); [ Date: 2026-07-19 08:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
19	2s197ms	SELECT profile.take_sample (); [ Date: 2026-07-19 12:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
20	2s195ms	SELECT profile.take_sample (); [ Date: 2026-07-19 11:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

2m43s

7

Details

22s330ms

23s834ms

23s341ms

select "_"."c_invoiceline_id" AS "c_invoiceline_id", "_"."c_invoice_id" AS "c_invoice_id", "_"."ad_org_id" AS "ad_org_id", "_"."isactive" AS "isactive", "_"."issotrx" AS "issotrx", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."c_currency_id" AS "c_currency_id", "_"."m_product_id" AS "m_product_id", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."m_product_category_id" AS "m_product_category_id", "_"."line" AS "line", "_"."Data Factura" AS "Data Factura", "_"."Descripció" AS "Descripció", "_"."Quantitat Factura" AS "Quantitat Factura", "_"."Preu llista" AS "Preu llista", "_"."Preu Actual" AS "Preu Actual", "_"."Preu Límit" AS "Preu Límit", "_"."Import Línia" AS "Import Línia", "_"."Descompte" AS "Descompte", "_"."gross_unit_price" AS "gross_unit_price", "_"."grosspricelist" AS "grosspricelist", "_"."Cost" AS "Cost", extract(hour from "_"."created") AS "created", "_"."Venedor" AS "Model de Negoci", case when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? else ? end AS "Agrupacio Model Negoci" from ( select ol.c_invoiceline_id, ol.c_invoice_id, ol.ad_org_id, ol.isactive, o.issotrx, o.c_bpartner_id, o.c_currency_id, ol.m_product_id, null m_warehouse_id, p.m_product_category_id, ol.line, o.dateinvoiced AS "Data Factura", ol.description AS "Descripció", ol.qtyinvoiced AS "Quantitat Factura", round(ol.pricelist, ?) AS "Preu llista", round(ol.priceactual, ?) AS "Preu Actual", round(ol.pricelimit, ?) AS "Preu Límit", round(ol.linenetamt, ?) AS "Import Línia", ? AS "Descompte", ol.gross_unit_price, ol.grosspricelist, coalesce(m_get_cost (ol.m_product_id, o.dateinvoiced::timestamp, ?, ol.ad_org_id, ol.ad_client_id, null, ?, ?) * ol.qtyinvoiced, ?) AS "Cost", ol.created, us.name AS "Venedor" from c_invoiceline ol left join c_invoice o on o.c_invoice_id = ol.c_invoice_id left join m_product p on p.m_product_id = ol.m_product_id left join ad_user us on us.ad_user_id = coalesce(ol.em_ins_salesrep_id, o.salesrep_id) where ? = ? and o.issotrx = ? and o.c_doctype_id <> ?) "_";

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 19	12	1	23s332ms	23s332ms
	13	1	23s651ms	23s651ms
	14	1	23s834ms	23s834ms
	15	1	22s722ms	22s722ms
	17	1	23s769ms	23s769ms
	18	1	23s752ms	23s752ms
	19	1	22s330ms	22s330ms

[ User: tad - Total duration: 2m43s - Times executed: 7 ]

[ Application: Mashup Engine - Total duration: 2m43s - Times executed: 7 ]

select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";

Date: 2026-07-19 14:12:23 Duration: 23s834ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";

Date: 2026-07-19 17:14:28 Duration: 23s769ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";

Date: 2026-07-19 18:11:03 Duration: 23s752ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes

2

33s802ms

15

Details

2s181ms

2s379ms

2s253ms

select profile.take_sample ();

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jul 19	07	1	2s181ms	2s181ms
	08	1	2s198ms	2s198ms
	09	1	2s202ms	2s202ms
	10	1	2s293ms	2s293ms
	11	1	2s195ms	2s195ms
	12	1	2s197ms	2s197ms
	13	1	2s215ms	2s215ms
	14	1	2s379ms	2s379ms
	15	1	2s183ms	2s183ms
	16	1	2s297ms	2s297ms
	17	1	2s208ms	2s208ms
	18	1	2s319ms	2s319ms
	19	1	2s319ms	2s319ms
	20	1	2s355ms	2s355ms
	21	1	2s253ms	2s253ms

[ User: postgres - Total duration: 33s802ms - Times executed: 15 ]

[ Application: psql - Total duration: 33s802ms - Times executed: 15 ]

SELECT profile.take_sample ();

Date: 2026-07-19 14:00:03 Duration: 2s379ms Database: etendo User: postgres Remote: [local] Application: psql
SELECT profile.take_sample ();

Date: 2026-07-19 20:00:04 Duration: 2s355ms Database: etendo User: postgres Remote: [local] Application: psql
SELECT profile.take_sample ();

Date: 2026-07-19 19:00:03 Duration: 2s319ms Database: etendo User: postgres Remote: [local] Application: psql

3

3s576ms

3

Details

1s10ms

1s367ms

1s192ms

select "_"."c_invoice_id" AS "c_invoice_id", "_"."ad_org_id" AS "ad_org_id", "_"."isactive" AS "isactive", "_"."issotrx" AS "issotrx", "_"."m_pricelist_id" AS "m_pricelist_id", "_"."Document" AS "Document", "_"."Estat Factura" AS "Estat Factura", "_"."Acció Factura" AS "Acció Factura", "_"."Processada" AS "Processada", "_"."Tipus Document" AS "Tipus Document", "_"."Descripció" AS "Descripció", cast("_"."Data Factura" as date) AS "Data Factura", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."Referencia Proveïdor" AS "Referencia Proveïdor", "_"."c_currency_id" AS "c_currency_id", "_"."Moneda ISO" AS "Moneda ISO", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."Població" AS "Població", "_"."Codi Postal" AS "Codi Postal", "_"."País" AS "País", "_"."Regió" AS "Regió", "_"."Venedor" AS "Model de Negoci", "_"."Devolució" AS "Devolució", "_"."salesrep_id" AS "salesrep_id", case when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? else ? end AS "Agrupacio Model Negoci" from ( select o.c_invoice_id, o.ad_org_id, o.isactive, o.issotrx, o.m_pricelist_id, o.documentno AS "Document", o.docstatus AS "Estat Factura", o.docaction AS "Acció Factura", o.processed AS "Processada", dt.name AS "Tipus Document", o.description AS "Descripció", o.dateordered AS "Data Factura", o.c_bpartner_id, o.poreference "Referencia Proveïdor", o.c_currency_id, cu.iso_code "Moneda ISO", null as m_warehouse_id, cl.city AS "Població", cl.postal AS "Codi Postal", cc."name" AS "País", cr."name" AS "Regió", us.name AS "Venedor", case when o.totallines < ? then ? else ? end AS "Devolució", o.salesrep_id from c_invoice o left join c_doctype dt on dt.c_doctype_id = o.c_doctype_id inner join c_currency cu on cu.c_currency_id = o.c_currency_id left join c_bpartner_location cbl on cbl.c_bpartner_location_id = o.c_bpartner_location_id left join c_location cl on cl.c_location_id = cbl.c_location_id left join c_country cc on cc.c_country_id = cl.c_country_id left join c_region cr on cr.c_region_id = cl.c_region_id left join ad_user us on us.ad_user_id = o.salesrep_id left join c_campaign ca on ca.c_campaign_id = o.c_campaign_id where ? = ? and o.issotrx = ? and o.c_doctype_id <> ?) "_";

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jul 19	14	1	1s199ms	1s199ms
	17	1	1s367ms	1s367ms
	18	1	1s10ms	1s10ms

[ User: tad - Total duration: 3s576ms - Times executed: 3 ]

[ Application: Mashup Engine - Total duration: 3s576ms - Times executed: 3 ]

select "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."m_pricelist_id" as "m_pricelist_id", "_"."Document" as "Document", "_"."Estat Factura" as "Estat Factura", "_"."Acció Factura" as "Acció Factura", "_"."Processada" as "Processada", "_"."Tipus Document" as "Tipus Document", "_"."Descripció" as "Descripció", cast("_"."Data Factura" as date) as "Data Factura", "_"."c_bpartner_id" as "c_bpartner_id", "_"."Referencia Proveïdor" as "Referencia Proveïdor", "_"."c_currency_id" as "c_currency_id", "_"."Moneda ISO" as "Moneda ISO", "_"."m_warehouse_id" as "m_warehouse_id", "_"."Població" as "Població", "_"."Codi Postal" as "Codi Postal", "_"."País" as "País", "_"."Regió" as "Regió", "_"."Venedor" as "Model de Negoci", "_"."Devolució" as "Devolució", "_"."salesrep_id" as "salesrep_id", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'STUDIO') = 1 then 'STUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT O.c_invoice_id, O.ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno as "Document", O.docstatus as "Estat Factura", O.docaction as "Acció Factura", O.processed as "Processada", DT.name as "Tipus Document", O.description as "Descripció", O.dateordered as "Data Factura", O.c_bpartner_id, O.poreference "Referencia Proveïdor", O.c_currency_id, cu.iso_code "Moneda ISO", null as m_warehouse_id, cl.city as "Població", cl.postal as "Codi Postal", cc."name" as "País", cr."name" as "Regió", us.name as "Venedor", case when O.totallines < 0 then 'Si' else 'No' end as "Devolució", O.salesrep_id FROM c_invoice O LEFT JOIN c_doctype DT on DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu on cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl on cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl on cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc on cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr on cr.c_region_id = cl.c_region_id LEFT JOIN ad_user us on us.ad_user_id = O.salesrep_id left join c_campaign ca on ca.c_campaign_id = O.c_campaign_id WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4') "_";

Date: 2026-07-19 17:14:04 Duration: 1s367ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
select "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."m_pricelist_id" as "m_pricelist_id", "_"."Document" as "Document", "_"."Estat Factura" as "Estat Factura", "_"."Acció Factura" as "Acció Factura", "_"."Processada" as "Processada", "_"."Tipus Document" as "Tipus Document", "_"."Descripció" as "Descripció", cast("_"."Data Factura" as date) as "Data Factura", "_"."c_bpartner_id" as "c_bpartner_id", "_"."Referencia Proveïdor" as "Referencia Proveïdor", "_"."c_currency_id" as "c_currency_id", "_"."Moneda ISO" as "Moneda ISO", "_"."m_warehouse_id" as "m_warehouse_id", "_"."Població" as "Població", "_"."Codi Postal" as "Codi Postal", "_"."País" as "País", "_"."Regió" as "Regió", "_"."Venedor" as "Model de Negoci", "_"."Devolució" as "Devolució", "_"."salesrep_id" as "salesrep_id", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'STUDIO') = 1 then 'STUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT O.c_invoice_id, O.ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno as "Document", O.docstatus as "Estat Factura", O.docaction as "Acció Factura", O.processed as "Processada", DT.name as "Tipus Document", O.description as "Descripció", O.dateordered as "Data Factura", O.c_bpartner_id, O.poreference "Referencia Proveïdor", O.c_currency_id, cu.iso_code "Moneda ISO", null as m_warehouse_id, cl.city as "Població", cl.postal as "Codi Postal", cc."name" as "País", cr."name" as "Regió", us.name as "Venedor", case when O.totallines < 0 then 'Si' else 'No' end as "Devolució", O.salesrep_id FROM c_invoice O LEFT JOIN c_doctype DT on DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu on cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl on cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl on cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc on cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr on cr.c_region_id = cl.c_region_id LEFT JOIN ad_user us on us.ad_user_id = O.salesrep_id left join c_campaign ca on ca.c_campaign_id = O.c_campaign_id WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4') "_";

Date: 2026-07-19 14:12:00 Duration: 1s199ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
select "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."m_pricelist_id" as "m_pricelist_id", "_"."Document" as "Document", "_"."Estat Factura" as "Estat Factura", "_"."Acció Factura" as "Acció Factura", "_"."Processada" as "Processada", "_"."Tipus Document" as "Tipus Document", "_"."Descripció" as "Descripció", cast("_"."Data Factura" as date) as "Data Factura", "_"."c_bpartner_id" as "c_bpartner_id", "_"."Referencia Proveïdor" as "Referencia Proveïdor", "_"."c_currency_id" as "c_currency_id", "_"."Moneda ISO" as "Moneda ISO", "_"."m_warehouse_id" as "m_warehouse_id", "_"."Població" as "Població", "_"."Codi Postal" as "Codi Postal", "_"."País" as "País", "_"."Regió" as "Regió", "_"."Venedor" as "Model de Negoci", "_"."Devolució" as "Devolució", "_"."salesrep_id" as "salesrep_id", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'STUDIO') = 1 then 'STUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT O.c_invoice_id, O.ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno as "Document", O.docstatus as "Estat Factura", O.docaction as "Acció Factura", O.processed as "Processada", DT.name as "Tipus Document", O.description as "Descripció", O.dateordered as "Data Factura", O.c_bpartner_id, O.poreference "Referencia Proveïdor", O.c_currency_id, cu.iso_code "Moneda ISO", null as m_warehouse_id, cl.city as "Població", cl.postal as "Codi Postal", cc."name" as "País", cr."name" as "Regió", us.name as "Venedor", case when O.totallines < 0 then 'Si' else 'No' end as "Devolució", O.salesrep_id FROM c_invoice O LEFT JOIN c_doctype DT on DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu on cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl on cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl on cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc on cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr on cr.c_region_id = cl.c_region_id LEFT JOIN ad_user us on us.ad_user_id = O.salesrep_id left join c_campaign ca on ca.c_campaign_id = O.c_campaign_id WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4') "_";

Date: 2026-07-19 18:10:42 Duration: 1s10ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

15

Details

33s802ms

2s181ms

2s379ms

2s253ms

select profile.take_sample ();

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 19	07	1	2s181ms	2s181ms
	08	1	2s198ms	2s198ms
	09	1	2s202ms	2s202ms
	10	1	2s293ms	2s293ms
	11	1	2s195ms	2s195ms
	12	1	2s197ms	2s197ms
	13	1	2s215ms	2s215ms
	14	1	2s379ms	2s379ms
	15	1	2s183ms	2s183ms
	16	1	2s297ms	2s297ms
	17	1	2s208ms	2s208ms
	18	1	2s319ms	2s319ms
	19	1	2s319ms	2s319ms
	20	1	2s355ms	2s355ms
	21	1	2s253ms	2s253ms

[ User: postgres - Total duration: 33s802ms - Times executed: 15 ]

[ Application: psql - Total duration: 33s802ms - Times executed: 15 ]

SELECT profile.take_sample ();

Date: 2026-07-19 14:00:03 Duration: 2s379ms Database: etendo User: postgres Remote: [local] Application: psql
SELECT profile.take_sample ();

Date: 2026-07-19 20:00:04 Duration: 2s355ms Database: etendo User: postgres Remote: [local] Application: psql
SELECT profile.take_sample ();

Date: 2026-07-19 19:00:03 Duration: 2s319ms Database: etendo User: postgres Remote: [local] Application: psql

2

7

Details

2m43s

22s330ms

23s834ms

23s341ms

select "_"."c_invoiceline_id" AS "c_invoiceline_id", "_"."c_invoice_id" AS "c_invoice_id", "_"."ad_org_id" AS "ad_org_id", "_"."isactive" AS "isactive", "_"."issotrx" AS "issotrx", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."c_currency_id" AS "c_currency_id", "_"."m_product_id" AS "m_product_id", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."m_product_category_id" AS "m_product_category_id", "_"."line" AS "line", "_"."Data Factura" AS "Data Factura", "_"."Descripció" AS "Descripció", "_"."Quantitat Factura" AS "Quantitat Factura", "_"."Preu llista" AS "Preu llista", "_"."Preu Actual" AS "Preu Actual", "_"."Preu Límit" AS "Preu Límit", "_"."Import Línia" AS "Import Línia", "_"."Descompte" AS "Descompte", "_"."gross_unit_price" AS "gross_unit_price", "_"."grosspricelist" AS "grosspricelist", "_"."Cost" AS "Cost", extract(hour from "_"."created") AS "created", "_"."Venedor" AS "Model de Negoci", case when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? else ? end AS "Agrupacio Model Negoci" from ( select ol.c_invoiceline_id, ol.c_invoice_id, ol.ad_org_id, ol.isactive, o.issotrx, o.c_bpartner_id, o.c_currency_id, ol.m_product_id, null m_warehouse_id, p.m_product_category_id, ol.line, o.dateinvoiced AS "Data Factura", ol.description AS "Descripció", ol.qtyinvoiced AS "Quantitat Factura", round(ol.pricelist, ?) AS "Preu llista", round(ol.priceactual, ?) AS "Preu Actual", round(ol.pricelimit, ?) AS "Preu Límit", round(ol.linenetamt, ?) AS "Import Línia", ? AS "Descompte", ol.gross_unit_price, ol.grosspricelist, coalesce(m_get_cost (ol.m_product_id, o.dateinvoiced::timestamp, ?, ol.ad_org_id, ol.ad_client_id, null, ?, ?) * ol.qtyinvoiced, ?) AS "Cost", ol.created, us.name AS "Venedor" from c_invoiceline ol left join c_invoice o on o.c_invoice_id = ol.c_invoice_id left join m_product p on p.m_product_id = ol.m_product_id left join ad_user us on us.ad_user_id = coalesce(ol.em_ins_salesrep_id, o.salesrep_id) where ? = ? and o.issotrx = ? and o.c_doctype_id <> ?) "_";

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jul 19	12	1	23s332ms	23s332ms
	13	1	23s651ms	23s651ms
	14	1	23s834ms	23s834ms
	15	1	22s722ms	22s722ms
	17	1	23s769ms	23s769ms
	18	1	23s752ms	23s752ms
	19	1	22s330ms	22s330ms

[ User: tad - Total duration: 2m43s - Times executed: 7 ]

[ Application: Mashup Engine - Total duration: 2m43s - Times executed: 7 ]

select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";

Date: 2026-07-19 14:12:23 Duration: 23s834ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";

Date: 2026-07-19 17:14:28 Duration: 23s769ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";

Date: 2026-07-19 18:11:03 Duration: 23s752ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes

3

Details

3s576ms

1s10ms

1s367ms

1s192ms

select "_"."c_invoice_id" AS "c_invoice_id", "_"."ad_org_id" AS "ad_org_id", "_"."isactive" AS "isactive", "_"."issotrx" AS "issotrx", "_"."m_pricelist_id" AS "m_pricelist_id", "_"."Document" AS "Document", "_"."Estat Factura" AS "Estat Factura", "_"."Acció Factura" AS "Acció Factura", "_"."Processada" AS "Processada", "_"."Tipus Document" AS "Tipus Document", "_"."Descripció" AS "Descripció", cast("_"."Data Factura" as date) AS "Data Factura", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."Referencia Proveïdor" AS "Referencia Proveïdor", "_"."c_currency_id" AS "c_currency_id", "_"."Moneda ISO" AS "Moneda ISO", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."Població" AS "Població", "_"."Codi Postal" AS "Codi Postal", "_"."País" AS "País", "_"."Regió" AS "Regió", "_"."Venedor" AS "Model de Negoci", "_"."Devolució" AS "Devolució", "_"."salesrep_id" AS "salesrep_id", case when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? else ? end AS "Agrupacio Model Negoci" from ( select o.c_invoice_id, o.ad_org_id, o.isactive, o.issotrx, o.m_pricelist_id, o.documentno AS "Document", o.docstatus AS "Estat Factura", o.docaction AS "Acció Factura", o.processed AS "Processada", dt.name AS "Tipus Document", o.description AS "Descripció", o.dateordered AS "Data Factura", o.c_bpartner_id, o.poreference "Referencia Proveïdor", o.c_currency_id, cu.iso_code "Moneda ISO", null as m_warehouse_id, cl.city AS "Població", cl.postal AS "Codi Postal", cc."name" AS "País", cr."name" AS "Regió", us.name AS "Venedor", case when o.totallines < ? then ? else ? end AS "Devolució", o.salesrep_id from c_invoice o left join c_doctype dt on dt.c_doctype_id = o.c_doctype_id inner join c_currency cu on cu.c_currency_id = o.c_currency_id left join c_bpartner_location cbl on cbl.c_bpartner_location_id = o.c_bpartner_location_id left join c_location cl on cl.c_location_id = cbl.c_location_id left join c_country cc on cc.c_country_id = cl.c_country_id left join c_region cr on cr.c_region_id = cl.c_region_id left join ad_user us on us.ad_user_id = o.salesrep_id left join c_campaign ca on ca.c_campaign_id = o.c_campaign_id where ? = ? and o.issotrx = ? and o.c_doctype_id <> ?) "_";

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jul 19	14	1	1s199ms	1s199ms
	17	1	1s367ms	1s367ms
	18	1	1s10ms	1s10ms

[ User: tad - Total duration: 3s576ms - Times executed: 3 ]

[ Application: Mashup Engine - Total duration: 3s576ms - Times executed: 3 ]

select "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."m_pricelist_id" as "m_pricelist_id", "_"."Document" as "Document", "_"."Estat Factura" as "Estat Factura", "_"."Acció Factura" as "Acció Factura", "_"."Processada" as "Processada", "_"."Tipus Document" as "Tipus Document", "_"."Descripció" as "Descripció", cast("_"."Data Factura" as date) as "Data Factura", "_"."c_bpartner_id" as "c_bpartner_id", "_"."Referencia Proveïdor" as "Referencia Proveïdor", "_"."c_currency_id" as "c_currency_id", "_"."Moneda ISO" as "Moneda ISO", "_"."m_warehouse_id" as "m_warehouse_id", "_"."Població" as "Població", "_"."Codi Postal" as "Codi Postal", "_"."País" as "País", "_"."Regió" as "Regió", "_"."Venedor" as "Model de Negoci", "_"."Devolució" as "Devolució", "_"."salesrep_id" as "salesrep_id", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'STUDIO') = 1 then 'STUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT O.c_invoice_id, O.ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno as "Document", O.docstatus as "Estat Factura", O.docaction as "Acció Factura", O.processed as "Processada", DT.name as "Tipus Document", O.description as "Descripció", O.dateordered as "Data Factura", O.c_bpartner_id, O.poreference "Referencia Proveïdor", O.c_currency_id, cu.iso_code "Moneda ISO", null as m_warehouse_id, cl.city as "Població", cl.postal as "Codi Postal", cc."name" as "País", cr."name" as "Regió", us.name as "Venedor", case when O.totallines < 0 then 'Si' else 'No' end as "Devolució", O.salesrep_id FROM c_invoice O LEFT JOIN c_doctype DT on DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu on cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl on cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl on cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc on cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr on cr.c_region_id = cl.c_region_id LEFT JOIN ad_user us on us.ad_user_id = O.salesrep_id left join c_campaign ca on ca.c_campaign_id = O.c_campaign_id WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4') "_";

Date: 2026-07-19 17:14:04 Duration: 1s367ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
select "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."m_pricelist_id" as "m_pricelist_id", "_"."Document" as "Document", "_"."Estat Factura" as "Estat Factura", "_"."Acció Factura" as "Acció Factura", "_"."Processada" as "Processada", "_"."Tipus Document" as "Tipus Document", "_"."Descripció" as "Descripció", cast("_"."Data Factura" as date) as "Data Factura", "_"."c_bpartner_id" as "c_bpartner_id", "_"."Referencia Proveïdor" as "Referencia Proveïdor", "_"."c_currency_id" as "c_currency_id", "_"."Moneda ISO" as "Moneda ISO", "_"."m_warehouse_id" as "m_warehouse_id", "_"."Població" as "Població", "_"."Codi Postal" as "Codi Postal", "_"."País" as "País", "_"."Regió" as "Regió", "_"."Venedor" as "Model de Negoci", "_"."Devolució" as "Devolució", "_"."salesrep_id" as "salesrep_id", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'STUDIO') = 1 then 'STUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT O.c_invoice_id, O.ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno as "Document", O.docstatus as "Estat Factura", O.docaction as "Acció Factura", O.processed as "Processada", DT.name as "Tipus Document", O.description as "Descripció", O.dateordered as "Data Factura", O.c_bpartner_id, O.poreference "Referencia Proveïdor", O.c_currency_id, cu.iso_code "Moneda ISO", null as m_warehouse_id, cl.city as "Població", cl.postal as "Codi Postal", cc."name" as "País", cr."name" as "Regió", us.name as "Venedor", case when O.totallines < 0 then 'Si' else 'No' end as "Devolució", O.salesrep_id FROM c_invoice O LEFT JOIN c_doctype DT on DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu on cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl on cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl on cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc on cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr on cr.c_region_id = cl.c_region_id LEFT JOIN ad_user us on us.ad_user_id = O.salesrep_id left join c_campaign ca on ca.c_campaign_id = O.c_campaign_id WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4') "_";

Date: 2026-07-19 14:12:00 Duration: 1s199ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
select "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."m_pricelist_id" as "m_pricelist_id", "_"."Document" as "Document", "_"."Estat Factura" as "Estat Factura", "_"."Acció Factura" as "Acció Factura", "_"."Processada" as "Processada", "_"."Tipus Document" as "Tipus Document", "_"."Descripció" as "Descripció", cast("_"."Data Factura" as date) as "Data Factura", "_"."c_bpartner_id" as "c_bpartner_id", "_"."Referencia Proveïdor" as "Referencia Proveïdor", "_"."c_currency_id" as "c_currency_id", "_"."Moneda ISO" as "Moneda ISO", "_"."m_warehouse_id" as "m_warehouse_id", "_"."Població" as "Població", "_"."Codi Postal" as "Codi Postal", "_"."País" as "País", "_"."Regió" as "Regió", "_"."Venedor" as "Model de Negoci", "_"."Devolució" as "Devolució", "_"."salesrep_id" as "salesrep_id", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'STUDIO') = 1 then 'STUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT O.c_invoice_id, O.ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno as "Document", O.docstatus as "Estat Factura", O.docaction as "Acció Factura", O.processed as "Processada", DT.name as "Tipus Document", O.description as "Descripció", O.dateordered as "Data Factura", O.c_bpartner_id, O.poreference "Referencia Proveïdor", O.c_currency_id, cu.iso_code "Moneda ISO", null as m_warehouse_id, cl.city as "Població", cl.postal as "Codi Postal", cc."name" as "País", cr."name" as "Regió", us.name as "Venedor", case when O.totallines < 0 then 'Si' else 'No' end as "Devolució", O.salesrep_id FROM c_invoice O LEFT JOIN c_doctype DT on DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu on cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl on cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl on cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc on cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr on cr.c_region_id = cl.c_region_id LEFT JOIN ad_user us on us.ad_user_id = O.salesrep_id left join c_campaign ca on ca.c_campaign_id = O.c_campaign_id WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4') "_";

Date: 2026-07-19 18:10:42 Duration: 1s10ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

22s330ms

23s834ms

23s341ms

7

Details

2m43s

select "_"."c_invoiceline_id" AS "c_invoiceline_id", "_"."c_invoice_id" AS "c_invoice_id", "_"."ad_org_id" AS "ad_org_id", "_"."isactive" AS "isactive", "_"."issotrx" AS "issotrx", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."c_currency_id" AS "c_currency_id", "_"."m_product_id" AS "m_product_id", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."m_product_category_id" AS "m_product_category_id", "_"."line" AS "line", "_"."Data Factura" AS "Data Factura", "_"."Descripció" AS "Descripció", "_"."Quantitat Factura" AS "Quantitat Factura", "_"."Preu llista" AS "Preu llista", "_"."Preu Actual" AS "Preu Actual", "_"."Preu Límit" AS "Preu Límit", "_"."Import Línia" AS "Import Línia", "_"."Descompte" AS "Descompte", "_"."gross_unit_price" AS "gross_unit_price", "_"."grosspricelist" AS "grosspricelist", "_"."Cost" AS "Cost", extract(hour from "_"."created") AS "created", "_"."Venedor" AS "Model de Negoci", case when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? else ? end AS "Agrupacio Model Negoci" from ( select ol.c_invoiceline_id, ol.c_invoice_id, ol.ad_org_id, ol.isactive, o.issotrx, o.c_bpartner_id, o.c_currency_id, ol.m_product_id, null m_warehouse_id, p.m_product_category_id, ol.line, o.dateinvoiced AS "Data Factura", ol.description AS "Descripció", ol.qtyinvoiced AS "Quantitat Factura", round(ol.pricelist, ?) AS "Preu llista", round(ol.priceactual, ?) AS "Preu Actual", round(ol.pricelimit, ?) AS "Preu Límit", round(ol.linenetamt, ?) AS "Import Línia", ? AS "Descompte", ol.gross_unit_price, ol.grosspricelist, coalesce(m_get_cost (ol.m_product_id, o.dateinvoiced::timestamp, ?, ol.ad_org_id, ol.ad_client_id, null, ?, ?) * ol.qtyinvoiced, ?) AS "Cost", ol.created, us.name AS "Venedor" from c_invoiceline ol left join c_invoice o on o.c_invoice_id = ol.c_invoice_id left join m_product p on p.m_product_id = ol.m_product_id left join ad_user us on us.ad_user_id = coalesce(ol.em_ins_salesrep_id, o.salesrep_id) where ? = ? and o.issotrx = ? and o.c_doctype_id <> ?) "_";

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 19	12	1	23s332ms	23s332ms
	13	1	23s651ms	23s651ms
	14	1	23s834ms	23s834ms
	15	1	22s722ms	22s722ms
	17	1	23s769ms	23s769ms
	18	1	23s752ms	23s752ms
	19	1	22s330ms	22s330ms

[ User: tad - Total duration: 2m43s - Times executed: 7 ]

[ Application: Mashup Engine - Total duration: 2m43s - Times executed: 7 ]

select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";

Date: 2026-07-19 14:12:23 Duration: 23s834ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";

Date: 2026-07-19 17:14:28 Duration: 23s769ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
select "_"."c_invoiceline_id" as "c_invoiceline_id", "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", "_"."Data Factura" as "Data Factura", "_"."Descripció" as "Descripció", "_"."Quantitat Factura" as "Quantitat Factura", "_"."Preu llista" as "Preu llista", "_"."Preu Actual" as "Preu Actual", "_"."Preu Límit" as "Preu Límit", "_"."Import Línia" as "Import Línia", "_"."Descompte" as "Descompte", "_"."gross_unit_price" as "gross_unit_price", "_"."grosspricelist" as "grosspricelist", "_"."Cost" as "Cost", extract(hour from "_"."created") as "created", "_"."Venedor" as "Model de Negoci", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'ESTUDIO') = 1 then 'ESTUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT OL.c_invoiceline_id, OL.c_invoice_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, O.c_currency_id, OL.m_product_id, null m_warehouse_id, P.m_product_category_id, OL.line, O.dateinvoiced as "Data Factura", OL.description as "Descripció", OL.qtyinvoiced as "Quantitat Factura", round(OL.pricelist, 2) as "Preu llista", round(OL.priceactual, 2) as "Preu Actual", round(OL.pricelimit, 2) as "Preu Límit", round(OL.linenetamt, 2) as "Import Línia", 0 as "Descompte", OL.gross_unit_price, OL.grosspricelist, coalesce(m_get_cost (OL.m_product_id, O.dateinvoiced::timestamp, 'AVA', OL.ad_org_id, OL.ad_client_id, null, '102', '102') * OL.qtyinvoiced, 0) as "Cost", OL.created, us.name as "Venedor" FROM c_invoiceline OL LEFT JOIN c_invoice O on O.c_invoice_id = OL.c_invoice_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN ad_user us on us.ad_user_id = coalesce(OL.em_ins_salesrep_id, O.salesrep_id) WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4' -- AND OL.c_invoiceline_id = 'D5E3820F37444F38B3E446F91B6D9253' ) "_";

Date: 2026-07-19 18:11:03 Duration: 23s752ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes

2

2s181ms

2s379ms

2s253ms

15

Details

33s802ms

select profile.take_sample ();

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jul 19	07	1	2s181ms	2s181ms
	08	1	2s198ms	2s198ms
	09	1	2s202ms	2s202ms
	10	1	2s293ms	2s293ms
	11	1	2s195ms	2s195ms
	12	1	2s197ms	2s197ms
	13	1	2s215ms	2s215ms
	14	1	2s379ms	2s379ms
	15	1	2s183ms	2s183ms
	16	1	2s297ms	2s297ms
	17	1	2s208ms	2s208ms
	18	1	2s319ms	2s319ms
	19	1	2s319ms	2s319ms
	20	1	2s355ms	2s355ms
	21	1	2s253ms	2s253ms

[ User: postgres - Total duration: 33s802ms - Times executed: 15 ]

[ Application: psql - Total duration: 33s802ms - Times executed: 15 ]

SELECT profile.take_sample ();

Date: 2026-07-19 14:00:03 Duration: 2s379ms Database: etendo User: postgres Remote: [local] Application: psql
SELECT profile.take_sample ();

Date: 2026-07-19 20:00:04 Duration: 2s355ms Database: etendo User: postgres Remote: [local] Application: psql
SELECT profile.take_sample ();

Date: 2026-07-19 19:00:03 Duration: 2s319ms Database: etendo User: postgres Remote: [local] Application: psql

3

1s10ms

1s367ms

1s192ms

3

Details

3s576ms

select "_"."c_invoice_id" AS "c_invoice_id", "_"."ad_org_id" AS "ad_org_id", "_"."isactive" AS "isactive", "_"."issotrx" AS "issotrx", "_"."m_pricelist_id" AS "m_pricelist_id", "_"."Document" AS "Document", "_"."Estat Factura" AS "Estat Factura", "_"."Acció Factura" AS "Acció Factura", "_"."Processada" AS "Processada", "_"."Tipus Document" AS "Tipus Document", "_"."Descripció" AS "Descripció", cast("_"."Data Factura" as date) AS "Data Factura", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."Referencia Proveïdor" AS "Referencia Proveïdor", "_"."c_currency_id" AS "c_currency_id", "_"."Moneda ISO" AS "Moneda ISO", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."Població" AS "Població", "_"."Codi Postal" AS "Codi Postal", "_"."País" AS "País", "_"."Regió" AS "Regió", "_"."Venedor" AS "Model de Negoci", "_"."Devolució" AS "Devolució", "_"."salesrep_id" AS "salesrep_id", case when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? when strpos("_"."Venedor", ?) = ? then ? else ? end AS "Agrupacio Model Negoci" from ( select o.c_invoice_id, o.ad_org_id, o.isactive, o.issotrx, o.m_pricelist_id, o.documentno AS "Document", o.docstatus AS "Estat Factura", o.docaction AS "Acció Factura", o.processed AS "Processada", dt.name AS "Tipus Document", o.description AS "Descripció", o.dateordered AS "Data Factura", o.c_bpartner_id, o.poreference "Referencia Proveïdor", o.c_currency_id, cu.iso_code "Moneda ISO", null as m_warehouse_id, cl.city AS "Població", cl.postal AS "Codi Postal", cc."name" AS "País", cr."name" AS "Regió", us.name AS "Venedor", case when o.totallines < ? then ? else ? end AS "Devolució", o.salesrep_id from c_invoice o left join c_doctype dt on dt.c_doctype_id = o.c_doctype_id inner join c_currency cu on cu.c_currency_id = o.c_currency_id left join c_bpartner_location cbl on cbl.c_bpartner_location_id = o.c_bpartner_location_id left join c_location cl on cl.c_location_id = cbl.c_location_id left join c_country cc on cc.c_country_id = cl.c_country_id left join c_region cr on cr.c_region_id = cl.c_region_id left join ad_user us on us.ad_user_id = o.salesrep_id left join c_campaign ca on ca.c_campaign_id = o.c_campaign_id where ? = ? and o.issotrx = ? and o.c_doctype_id <> ?) "_";

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jul 19	14	1	1s199ms	1s199ms
	17	1	1s367ms	1s367ms
	18	1	1s10ms	1s10ms

[ User: tad - Total duration: 3s576ms - Times executed: 3 ]

[ Application: Mashup Engine - Total duration: 3s576ms - Times executed: 3 ]

select "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."m_pricelist_id" as "m_pricelist_id", "_"."Document" as "Document", "_"."Estat Factura" as "Estat Factura", "_"."Acció Factura" as "Acció Factura", "_"."Processada" as "Processada", "_"."Tipus Document" as "Tipus Document", "_"."Descripció" as "Descripció", cast("_"."Data Factura" as date) as "Data Factura", "_"."c_bpartner_id" as "c_bpartner_id", "_"."Referencia Proveïdor" as "Referencia Proveïdor", "_"."c_currency_id" as "c_currency_id", "_"."Moneda ISO" as "Moneda ISO", "_"."m_warehouse_id" as "m_warehouse_id", "_"."Població" as "Població", "_"."Codi Postal" as "Codi Postal", "_"."País" as "País", "_"."Regió" as "Regió", "_"."Venedor" as "Model de Negoci", "_"."Devolució" as "Devolució", "_"."salesrep_id" as "salesrep_id", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'STUDIO') = 1 then 'STUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT O.c_invoice_id, O.ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno as "Document", O.docstatus as "Estat Factura", O.docaction as "Acció Factura", O.processed as "Processada", DT.name as "Tipus Document", O.description as "Descripció", O.dateordered as "Data Factura", O.c_bpartner_id, O.poreference "Referencia Proveïdor", O.c_currency_id, cu.iso_code "Moneda ISO", null as m_warehouse_id, cl.city as "Població", cl.postal as "Codi Postal", cc."name" as "País", cr."name" as "Regió", us.name as "Venedor", case when O.totallines < 0 then 'Si' else 'No' end as "Devolució", O.salesrep_id FROM c_invoice O LEFT JOIN c_doctype DT on DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu on cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl on cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl on cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc on cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr on cr.c_region_id = cl.c_region_id LEFT JOIN ad_user us on us.ad_user_id = O.salesrep_id left join c_campaign ca on ca.c_campaign_id = O.c_campaign_id WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4') "_";

Date: 2026-07-19 17:14:04 Duration: 1s367ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
select "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."m_pricelist_id" as "m_pricelist_id", "_"."Document" as "Document", "_"."Estat Factura" as "Estat Factura", "_"."Acció Factura" as "Acció Factura", "_"."Processada" as "Processada", "_"."Tipus Document" as "Tipus Document", "_"."Descripció" as "Descripció", cast("_"."Data Factura" as date) as "Data Factura", "_"."c_bpartner_id" as "c_bpartner_id", "_"."Referencia Proveïdor" as "Referencia Proveïdor", "_"."c_currency_id" as "c_currency_id", "_"."Moneda ISO" as "Moneda ISO", "_"."m_warehouse_id" as "m_warehouse_id", "_"."Població" as "Població", "_"."Codi Postal" as "Codi Postal", "_"."País" as "País", "_"."Regió" as "Regió", "_"."Venedor" as "Model de Negoci", "_"."Devolució" as "Devolució", "_"."salesrep_id" as "salesrep_id", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'STUDIO') = 1 then 'STUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT O.c_invoice_id, O.ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno as "Document", O.docstatus as "Estat Factura", O.docaction as "Acció Factura", O.processed as "Processada", DT.name as "Tipus Document", O.description as "Descripció", O.dateordered as "Data Factura", O.c_bpartner_id, O.poreference "Referencia Proveïdor", O.c_currency_id, cu.iso_code "Moneda ISO", null as m_warehouse_id, cl.city as "Població", cl.postal as "Codi Postal", cc."name" as "País", cr."name" as "Regió", us.name as "Venedor", case when O.totallines < 0 then 'Si' else 'No' end as "Devolució", O.salesrep_id FROM c_invoice O LEFT JOIN c_doctype DT on DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu on cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl on cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl on cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc on cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr on cr.c_region_id = cl.c_region_id LEFT JOIN ad_user us on us.ad_user_id = O.salesrep_id left join c_campaign ca on ca.c_campaign_id = O.c_campaign_id WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4') "_";

Date: 2026-07-19 14:12:00 Duration: 1s199ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
select "_"."c_invoice_id" as "c_invoice_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."m_pricelist_id" as "m_pricelist_id", "_"."Document" as "Document", "_"."Estat Factura" as "Estat Factura", "_"."Acció Factura" as "Acció Factura", "_"."Processada" as "Processada", "_"."Tipus Document" as "Tipus Document", "_"."Descripció" as "Descripció", cast("_"."Data Factura" as date) as "Data Factura", "_"."c_bpartner_id" as "c_bpartner_id", "_"."Referencia Proveïdor" as "Referencia Proveïdor", "_"."c_currency_id" as "c_currency_id", "_"."Moneda ISO" as "Moneda ISO", "_"."m_warehouse_id" as "m_warehouse_id", "_"."Població" as "Població", "_"."Codi Postal" as "Codi Postal", "_"."País" as "País", "_"."Regió" as "Regió", "_"."Venedor" as "Model de Negoci", "_"."Devolució" as "Devolució", "_"."salesrep_id" as "salesrep_id", case when strpos("_"."Venedor", 'RETAIL') = 1 then 'RETAIL' when strpos("_"."Venedor", 'MEDIA ARCHITECTURE') = 1 then 'MEDIA ARCHITECTURE' when strpos("_"."Venedor", 'STUDIO') = 1 then 'STUDIO' else 'ALTRES' end as "Agrupacio Model Negoci" from ( SELECT O.c_invoice_id, O.ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno as "Document", O.docstatus as "Estat Factura", O.docaction as "Acció Factura", O.processed as "Processada", DT.name as "Tipus Document", O.description as "Descripció", O.dateordered as "Data Factura", O.c_bpartner_id, O.poreference "Referencia Proveïdor", O.c_currency_id, cu.iso_code "Moneda ISO", null as m_warehouse_id, cl.city as "Població", cl.postal as "Codi Postal", cc."name" as "País", cr."name" as "Regió", us.name as "Venedor", case when O.totallines < 0 then 'Si' else 'No' end as "Devolució", O.salesrep_id FROM c_invoice O LEFT JOIN c_doctype DT on DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu on cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl on cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl on cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc on cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr on cr.c_region_id = cl.c_region_id LEFT JOIN ad_user us on us.ad_user_id = O.salesrep_id left join c_campaign ca on ca.c_campaign_id = O.c_campaign_id WHERE 1 = 1 AND O.issotrx = 'Y' AND O.c_doctype_id <> '49BCC80F7B8E4A2685CF8364184ED2F4') "_";

Date: 2026-07-19 18:10:42 Duration: 1s10ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes

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

51,584 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
LOG	51,579	99.99%
STATEMENT	5	0.01%

Events distribution (except queries)

Key values

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

Events per 5 minutes

NO DATASET

Most Frequent Errors/Events

Key values

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

Rank	Times reported	Error
NO DATASET

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

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