pgBadger-
Global information
- Generated on Sat Jul 18 23:00:17 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 49,866 log entries in 15s
- Log start from 2026-07-18 07:00:01 to 2026-07-18 22:00:00
-
Overview
Global Stats
- 4 Number of unique normalized queries
- 23 Number of queries
- 3m23s Total query duration
- 2026-07-18 07:00:03 First query
- 2026-07-18 21:00:04 Last query
- 1 queries/s at 2026-07-18 15:12:09 Query peak
- 3m23s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 3m23s 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
- 20,224 Total number of automatic vacuums
- 125 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,413 Total number of sessions
- 68 sessions at 2026-07-18 19:16:54 Session peak
- 3d27m27s Total duration of sessions
- 1m16s Average duration of sessions
- 0 Average queries per session
- 59ms Average queries duration per session
- 1m16s Average idle time per session
- 3,413 Total number of connections
- 6 connections/s at 2026-07-18 17:00:00 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-18 15:12:09 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-18 15:12:09 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 3m23s 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
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 18 07 1 0ms 2s236ms 2s236ms 0ms 0ms 2s236ms 08 1 0ms 2s133ms 2s133ms 0ms 0ms 2s133ms 09 1 0ms 2s101ms 2s101ms 0ms 0ms 2s101ms 10 1 0ms 2s405ms 2s405ms 0ms 0ms 2s405ms 11 1 0ms 2s225ms 2s225ms 0ms 0ms 2s225ms 12 2 0ms 24s202ms 13s174ms 0ms 0ms 24s202ms 13 2 0ms 23s531ms 12s839ms 0ms 0ms 23s531ms 14 2 0ms 24s659ms 13s438ms 0ms 0ms 24s659ms 15 3 0ms 24s438ms 9s485ms 0ms 1s882ms 24s438ms 16 1 0ms 2s150ms 2s150ms 0ms 0ms 2s150ms 17 2 0ms 23s934ms 13s53ms 0ms 0ms 23s934ms 18 2 0ms 24s333ms 13s256ms 0ms 0ms 24s333ms 19 2 0ms 23s693ms 12s912ms 0ms 0ms 23s693ms 20 1 0ms 2s177ms 2s177ms 0ms 0ms 2s177ms 21 1 0ms 2s98ms 2s98ms 0ms 0ms 2s98ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 18 07 1 0 2s236ms 0ms 0ms 0ms 08 1 0 2s133ms 0ms 0ms 0ms 09 1 0 2s101ms 0ms 0ms 0ms 10 1 0 2s405ms 0ms 0ms 0ms 11 1 0 2s225ms 0ms 0ms 0ms 12 2 0 13s174ms 0ms 0ms 2s146ms 13 2 0 12s839ms 0ms 0ms 2s147ms 14 2 0 13s438ms 0ms 0ms 2s216ms 15 3 0 9s485ms 0ms 0ms 2s135ms 16 1 0 2s150ms 0ms 0ms 0ms 17 2 0 13s53ms 0ms 0ms 2s173ms 18 2 0 13s256ms 0ms 0ms 2s180ms 19 2 0 12s912ms 0ms 0ms 2s131ms 20 1 0 2s177ms 0ms 0ms 0ms 21 1 0 2s98ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 18 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 18 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 1 1.00 0.00% 13 0 1 1.00 0.00% 14 0 1 1.00 0.00% 15 0 2 2.00 0.00% 16 0 0 0.00 0.00% 17 0 1 1.00 0.00% 18 0 1 1.00 0.00% 19 0 1 1.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% Day Hour Count Average / Second Jul 18 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 232 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 18 07 222 1m 1m 08 224 2m20s 2m20s 09 223 51s940ms 51s930ms 10 223 35s799ms 35s788ms 11 224 1m56s 1m56s 12 232 38s868ms 38s755ms 13 232 1m17s 1m17s 14 233 1m56s 1m56s 15 232 38s882ms 38s759ms 16 223 1m24s 1m24s 17 233 1m25s 1m25s 18 232 38s871ms 38s756ms 19 232 2m4s 2m4s 20 224 36s218ms 36s209ms 21 223 1m40s 1m40s 22 1 22ms 22ms -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-07-18 17:00:00 Date
Connections per database
Key values
- etendo Main Database
- 3,413 connections Total
Connections per user
Key values
- tad Main User
- 3,413 connections Total
-
Sessions
Simultaneous sessions
Key values
- 68 sessions Session Peak
- 2026-07-18 19:16:54 Date
Histogram of session times
Key values
- 3,225 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 3,413 sessions Total
Sessions per user
Key values
- tad Main User
- 3,413 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 3,413 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 3,776 buffers Checkpoint Peak
- 2026-07-18 07:06:45 Date
- 269.834 seconds Highest write time
- 0.003 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2026-07-18 08:06:45 Date
Checkpoints distance
Key values
- 32.83 Mo Distance Peak
- 2026-07-18 19:06:56 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 18 07 4,541 344.263s 0.012s 344.295s 08 3,844 300.84s 0.011s 300.869s 09 3,940 311.015s 0.011s 311.042s 10 3,771 300.199s 0.011s 300.225s 11 3,822 300.412s 0.013s 300.441s 12 3,781 299.987s 0.011s 300.016s 13 3,906 303.316s 0.011s 303.346s 14 3,823 307.425s 0.011s 307.455s 15 3,814 302.596s 0.011s 302.621s 16 3,868 298.696s 0.012s 298.743s 17 4,279 326.042s 0.011s 326.067s 18 3,817 303.283s 0.011s 303.308s 19 4,109 310.531s 0.012s 310.56s 20 3,776 300.895s 0.012s 300.921s 21 4,003 315.216s 0.012s 315.247s 22 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 18 07 0 0 1 440 0.001s 0.012s 08 0 0 1 400 0.001s 0.011s 09 0 0 1 406 0.001s 0.011s 10 0 0 1 397 0.001s 0.011s 11 0 0 1 397 0.003s 0.011s 12 0 0 2 396 0.001s 0.011s 13 0 0 1 401 0.001s 0.011s 14 0 0 1 412 0.001s 0.011s 15 0 0 1 404 0.001s 0.011s 16 0 0 1 389 0.002s 0.011s 17 0 0 1 418 0.001s 0.011s 18 0 0 1 405 0.001s 0.011s 19 0 0 1 412 0.001s 0.011s 20 0 0 1 397 0.001s 0.011s 21 0 0 1 427 0.001s 0.012s 22 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 18 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s Day Hour Mean distance Mean estimate Jul 18 07 1,667.42 kB 9,874.08 kB 08 1,527.00 kB 9,985.55 kB 09 1,554.91 kB 10,127.55 kB 10 1,520.82 kB 9,946.00 kB 11 1,550.09 kB 10,159.73 kB 12 1,520.91 kB 9,948.00 kB 13 1,567.73 kB 10,235.73 kB 14 1,547.00 kB 9,977.00 kB 15 1,562.00 kB 10,199.00 kB 16 1,531.64 kB 10,042.00 kB 17 1,607.27 kB 10,450.64 kB 18 1,552.45 kB 10,140.82 kB 19 1,611.55 kB 10,522.55 kB 20 1,553.64 kB 10,150.27 kB 21 1,479.83 kB 9,998.50 kB 22 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 3.50 MiB Temp Files size Peak
- 2026-07-18 14:00:01 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-18 14:00:01 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 18 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 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-18 08:00:01 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
Queries generating the largest temporary files
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-18 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-18 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-18 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-18 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-18 20:00:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.28 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo - 2026-07-18 21:00:56 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 0.28 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo - 2026-07-18 21:00:56 Date
Analyzes per table
Key values
- profile.last_stat_user_functions_srv1 (15) Main table analyzed (database etendo)
- 125 analyzes Total
Table Number of analyzes etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.last_stat_statements_srv1 15 etendo.profile.last_stat_tables_srv1 15 etendo.profile.last_stat_indexes_srv1 15 etendo.public.c_invoice 8 etendo.profile.last_stat_io 7 etendo.profile.tables_list 7 etendo.profile.last_stat_activity_count_srv1 4 etendo.profile.last_extension_versions 4 etendo.public.ad_process_request 3 etendo.profile.last_stat_slru 3 etendo.profile.funcs_list 2 etendo.profile.sample_stat_user_functions 2 etendo.profile.sample_stat_tables 2 etendo.profile.sample_statements 2 etendo.profile.stmt_list 2 etendo.profile.indexes_list 2 etendo.profile.sample_stat_user_func_total 1 etendo.profile.sample_stat_tables_total 1 etendo.public.ad_module 1 etendo.profile.last_stat_wal 1 etendo.profile.sample_stat_slru 1 template1.pg_catalog.pg_shdepend 1 etendo.public.ad_process_run 1 etendo.profile.sample_statements_total 1 etendo.pg_catalog.pg_type 1 etendo.profile.last_stat_archiver 1 etendo.pg_catalog.pg_attribute 1 etendo.profile.sample_stat_tablespaces 1 etendo.profile.sample_stat_io 1 etendo.profile.sample_stat_database 1 etendo.profile.sample_stat_indexes 1 etendo.profile.last_stat_cluster 1 etendo.profile.sample_stat_indexes_total 1 Total 125 Vacuums per table
Key values
- public.ad_session (900) Main table vacuumed on database etendo
- 20,224 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples etendo.public.ad_session 900 0 317,690 0 0 0 0 0 0 0 0 0 etendo.pg_catalog.pg_statistic 900 0 4,183,347 0 298 0 0 154 56 167,355 0 0 etendo.profile.stmt_list 900 0 727,200 0 77 0 0 100 79 115,936 0 0 etendo.public.ad_process_request 900 0 406,874 0 191 0 0 178 37 135,186 0 0 etendo.pg_toast.pg_toast_2619 900 0 1,362,247 0 29 0 0 54 28 67,129 0 0 etendo.pg_toast.pg_toast_111094 900 0 693,503 0 80 0 0 95 79 196,822 0 0 etendo.profile.last_stat_slru 900 0 33,246 0 28 0 0 94 0 17,672 0 0 etendo.profile.last_stat_database_srv1 900 0 40,540 0 15 0 0 94 0 44,462 0 0 etendo.profile.indexes_list 900 0 203,628 0 9 0 0 94 0 22,654 0 0 etendo.profile.last_extension_versions 900 0 41,158 0 78 0 0 94 65 128,552 0 0 etendo.profile.last_stat_indexes_srv1 900 0 17,829,865 0 68 0 0 196 69 208,343 0 0 etendo.profile.last_stat_io 900 0 70,006 0 87 0 0 94 78 168,350 0 0 etendo.public.c_import_entry 900 0 68,628 0 75 0 0 94 77 213,009 0 0 etendo.public.ad_module 900 0 224,672 0 61 0 0 99 61 186,869 0 0 etendo.public.c_invoice 900 0 7,293,848 0 116 0 0 587 117 393,520 0 0 etendo.profile.last_stat_user_functions_srv1 900 0 1,310,668 0 0 0 0 170 0 80,410 0 0 etendo.profile.funcs_list 900 0 189,134 0 11 0 0 94 0 22,654 0 0 etendo.profile.last_stat_activity_count_srv1 900 0 22,180 0 110 0 0 94 76 200,728 0 0 etendo.profile.tables_list 900 0 641,928 0 0 0 0 94 0 22,654 0 0 etendo.profile.last_stat_tables_srv1 900 0 13,672,265 0 1 0 0 182 0 86,086 0 0 etendo.profile.last_stat_statements_srv1 900 0 2,439,721 0 81 0 0 277 82 268,660 0 0 etendo.profile.last_stat_tablespaces_srv1 780 0 27,249 0 17 0 0 81 0 38,313 0 0 etendo.profile.sample_stat_indexes 180 0 90,657 0 23 0 0 14 2 7,950 0 0 etendo.profile.sample_stat_user_functions 180 0 46,417 0 3 0 0 14 0 3,374 0 0 etendo.profile.sample_stat_tables 180 0 351,032 0 32 0 0 35 3 15,301 0 0 etendo.profile.sample_stat_cluster 1 1 64 0 8 0 0 15 5 11,789 0 0 etendo.profile.sample_stat_archiver 1 1 53 0 5 0 0 9 2 4,285 0 0 etendo.profile.samples 1 1 83 0 4 0 0 6 1 2,576 0 0 etendo.profile.sample_stat_wal 1 1 57 0 5 0 0 11 2 6,551 0 0 Total 20,224 4 52,287,960 1,405 1,512 0 0 3,123 919 2,837,190 0 0 Vacuum throughput per table
Key values
- profile.last_stat_indexes_srv1 (212.36) 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
I/O timing (ms) CPU (s) Table read write elapsed etendo.public.ad_session 0 0 0 etendo.pg_catalog.pg_statistic 0 0 45.97 etendo.profile.stmt_list 0 0 0.15 etendo.public.ad_process_request 0 0 0 etendo.pg_toast.pg_toast_2619 0 0 9.02999999999985 etendo.pg_toast.pg_toast_111094 0 0 0.01 etendo.profile.last_stat_slru 0 0 0 etendo.profile.last_stat_database_srv1 0 0 0 etendo.profile.indexes_list 0 0 0 etendo.profile.last_extension_versions 0 0 0 etendo.profile.last_stat_indexes_srv1 0 0 212.36 etendo.profile.last_stat_io 0 0 0 etendo.public.c_import_entry 0 0 0 etendo.public.ad_module 0 0 0 etendo.public.c_invoice 0 0 80.0100000000001 etendo.profile.last_stat_user_functions_srv1 0 0 9.79999999999984 etendo.profile.funcs_list 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.tables_list 0 0 0.01 etendo.profile.last_stat_tables_srv1 0 0 162.340000000002 etendo.profile.last_stat_statements_srv1 0 0 24.0100000000001 etendo.profile.last_stat_tablespaces_srv1 0 0 0 etendo.profile.sample_stat_indexes 0 0 0.01 etendo.profile.sample_stat_user_functions 0 0 0 etendo.profile.sample_stat_tables 0 0 3.61 etendo.profile.sample_stat_cluster 0 0 0 etendo.profile.sample_stat_archiver 0 0 0 etendo.profile.samples 0 0 0 etendo.profile.sample_stat_wal 0 0 0 Total 0 0 547.310000000002 Tuples removed per table
Key values
- profile.sample_stat_cluster (56) Main table with removed tuples on database etendo
- 168 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.profile.sample_stat_cluster 1 1 56 197 28 0 6 etendo.profile.sample_stat_archiver 1 1 56 197 28 0 3 etendo.profile.sample_stat_wal 1 1 56 197 28 0 4 etendo.public.ad_session 900 0 0 7,116,300 1,650,600 0 468,000 etendo.pg_catalog.pg_statistic 900 0 0 23,119,307 12,217,243 0 4,156,200 etendo.profile.stmt_list 900 0 0 1,883,044 975,940 0 392,400 etendo.public.ad_process_request 900 0 0 2,122,980 747,808 0 325,800 etendo.pg_toast.pg_toast_2619 900 0 0 3,025,479 1,040,288 0 781,200 etendo.pg_toast.pg_toast_111094 900 0 0 1,314,885 859,524 0 332,100 etendo.profile.last_stat_tablespaces_srv1 780 0 0 51,480 49,920 0 1,560 etendo.profile.last_stat_slru 900 0 0 143,995 139,495 0 2,700 etendo.profile.last_stat_database_srv1 900 0 0 115,196 111,596 0 6,300 etendo.profile.sample_stat_indexes 180 0 0 2,416,529 467,700 0 45,180 etendo.profile.indexes_list 900 0 0 895,369 514,909 0 72,000 etendo.profile.last_extension_versions 900 0 0 230,392 223,192 0 5,400 etendo.profile.last_stat_indexes_srv1 900 0 0 173,622,284 169,483,190 0 10,563,300 etendo.profile.last_stat_io 900 0 0 460,784 446,384 0 16,200 etendo.profile.samples 1 1 0 197 28 0 2 etendo.public.c_import_entry 900 0 0 46,800 46,800 0 8,100 etendo.public.ad_module 900 0 0 840,508 496,148 0 123,300 etendo.public.c_invoice 900 0 0 29,267,834 19,480,860 0 19,365,300 etendo.profile.last_stat_user_functions_srv1 900 0 0 15,473,113 14,811,311 0 746,100 etendo.profile.funcs_list 900 0 0 605,037 396,237 0 72,900 etendo.profile.last_stat_activity_count_srv1 900 0 0 229,972 229,972 0 6,120 etendo.profile.tables_list 900 0 0 4,008,055 2,969,818 0 299,700 etendo.profile.last_stat_tables_srv1 900 0 0 110,742,164 108,274,158 0 8,431,200 etendo.profile.last_stat_statements_srv1 900 0 0 22,810,302 21,787,709 0 3,183,300 etendo.profile.sample_stat_user_functions 180 0 0 1,743,868 351,540 0 20,160 etendo.profile.sample_stat_tables 180 0 0 6,575,226 1,382,700 0 285,480 Total 20,224 4 168 408,861,691 359,155,154 0 49,710,015 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed etendo.public.ad_session 900 0 0 0 etendo.pg_catalog.pg_statistic 900 0 0 0 etendo.profile.stmt_list 900 0 0 0 etendo.public.ad_process_request 900 0 0 0 etendo.pg_toast.pg_toast_2619 900 0 0 0 etendo.pg_toast.pg_toast_111094 900 0 0 0 etendo.profile.last_stat_tablespaces_srv1 780 0 0 0 etendo.profile.last_stat_slru 900 0 0 0 etendo.profile.last_stat_database_srv1 900 0 0 0 etendo.profile.sample_stat_indexes 180 0 0 0 etendo.profile.sample_stat_cluster 1 1 56 0 etendo.profile.indexes_list 900 0 0 0 etendo.profile.last_extension_versions 900 0 0 0 etendo.profile.last_stat_indexes_srv1 900 0 0 0 etendo.profile.sample_stat_archiver 1 1 56 0 etendo.profile.last_stat_io 900 0 0 0 etendo.profile.samples 1 1 0 0 etendo.public.c_import_entry 900 0 0 0 etendo.public.ad_module 900 0 0 0 etendo.public.c_invoice 900 0 0 0 etendo.profile.last_stat_user_functions_srv1 900 0 0 0 etendo.profile.sample_stat_wal 1 1 56 0 etendo.profile.funcs_list 900 0 0 0 etendo.profile.last_stat_activity_count_srv1 900 0 0 0 etendo.profile.tables_list 900 0 0 0 etendo.profile.last_stat_tables_srv1 900 0 0 0 etendo.profile.last_stat_statements_srv1 900 0 0 0 etendo.profile.sample_stat_user_functions 180 0 0 0 etendo.profile.sample_stat_tables 180 0 0 0 Total 20,224 4 168 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 18 07 1,260 12 08 1,260 8 09 1,320 7 10 1,320 6 11 1,320 7 12 1,324 8 13 1,320 8 14 1,320 7 15 1,320 6 16 1,320 9 17 1,320 12 18 1,320 7 19 1,500 13 20 1,500 8 21 1,500 7 22 0 0 - 0.28 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
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
Queries by type
Key values
- 23 Total read queries
- 0 Total write queries
Queries by database
Key values
- etendo Main database
- 23 Requests
- 3m23s (etendo)
- Main time consuming database
Queries by user
Key values
- postgres Main user
- 15 Requests
User Request type Count Duration postgres Total 15 32s658ms select 15 32s658ms tad Total 8 2m50s select 8 2m50s Duration by user
Key values
- 2m50s (tad) Main time consuming user
User Request type Count Duration postgres Total 15 32s658ms select 15 32s658ms tad Total 8 2m50s select 8 2m50s Queries by host
Key values
- [local] Main host
- 15 Requests
- 2m50s (46.183.115.21)
- Main time consuming host
Queries by application
Key values
- psql Main application
- 15 Requests
- 2m50s (Mashup Engine)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-18 07:09:57 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 16 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 24s659ms 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-18 14:14:08 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
2 24s438ms 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-18 15:12:09 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
3 24s333ms 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-18 18:13:15 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
4 24s202ms 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-18 12:11:42 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
5 23s934ms 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-18 17:13:44 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
6 23s693ms 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-18 19:12:47 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
7 23s531ms 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-18 13:09:27 - Database: etendo - User: tad - Remote: 46.183.115.21 - Application: Mashup Engine - Bind query: yes ]
8 2s405ms SELECT profile.take_sample ();[ Date: 2026-07-18 10:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
9 2s236ms SELECT profile.take_sample ();[ Date: 2026-07-18 07:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
10 2s225ms SELECT profile.take_sample ();[ Date: 2026-07-18 11:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
11 2s216ms SELECT profile.take_sample ();[ Date: 2026-07-18 14:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
12 2s180ms SELECT profile.take_sample ();[ Date: 2026-07-18 18:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
13 2s177ms SELECT profile.take_sample ();[ Date: 2026-07-18 20:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
14 2s173ms SELECT profile.take_sample ();[ Date: 2026-07-18 17:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
15 2s150ms SELECT profile.take_sample ();[ Date: 2026-07-18 16:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
16 2s147ms SELECT profile.take_sample ();[ Date: 2026-07-18 13:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
17 2s146ms SELECT profile.take_sample ();[ Date: 2026-07-18 12:00:04 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
18 2s135ms SELECT profile.take_sample ();[ Date: 2026-07-18 15:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
19 2s133ms SELECT profile.take_sample ();[ Date: 2026-07-18 08:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
20 2s131ms SELECT profile.take_sample ();[ Date: 2026-07-18 19:00:04 - 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 2m48s 7 23s531ms 24s659ms 24s113ms 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 18 12 1 24s202ms 24s202ms 13 1 23s531ms 23s531ms 14 1 24s659ms 24s659ms 15 1 24s438ms 24s438ms 17 1 23s934ms 23s934ms 18 1 24s333ms 24s333ms 19 1 23s693ms 23s693ms [ User: tad - Total duration: 2m48s - Times executed: 7 ]
[ Application: Mashup Engine - Total duration: 2m48s - 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-18 14:14:08 Duration: 24s659ms 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-18 15:12:09 Duration: 24s438ms 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-18 18:13:15 Duration: 24s333ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
2 32s658ms 15 2s98ms 2s405ms 2s177ms select profile.take_sample ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 18 07 1 2s236ms 2s236ms 08 1 2s133ms 2s133ms 09 1 2s101ms 2s101ms 10 1 2s405ms 2s405ms 11 1 2s225ms 2s225ms 12 1 2s146ms 2s146ms 13 1 2s147ms 2s147ms 14 1 2s216ms 2s216ms 15 1 2s135ms 2s135ms 16 1 2s150ms 2s150ms 17 1 2s173ms 2s173ms 18 1 2s180ms 2s180ms 19 1 2s131ms 2s131ms 20 1 2s177ms 2s177ms 21 1 2s98ms 2s98ms [ User: postgres - Total duration: 32s658ms - Times executed: 15 ]
[ Application: psql - Total duration: 32s658ms - Times executed: 15 ]
-
SELECT profile.take_sample ();
Date: 2026-07-18 10:00:03 Duration: 2s405ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-18 07:00:03 Duration: 2s236ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-18 11:00:03 Duration: 2s225ms Database: etendo User: postgres Remote: [local] Application: psql
3 1s882ms 1 1s882ms 1s882ms 1s882ms 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 18 15 1 1s882ms 1s882ms [ User: tad - Total duration: 1s882ms - Times executed: 1 ]
[ Application: Mashup Engine - Total duration: 1s882ms - Times executed: 1 ]
-
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-18 15:11:47 Duration: 1s882ms 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 32s658ms 2s98ms 2s405ms 2s177ms select profile.take_sample ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 18 07 1 2s236ms 2s236ms 08 1 2s133ms 2s133ms 09 1 2s101ms 2s101ms 10 1 2s405ms 2s405ms 11 1 2s225ms 2s225ms 12 1 2s146ms 2s146ms 13 1 2s147ms 2s147ms 14 1 2s216ms 2s216ms 15 1 2s135ms 2s135ms 16 1 2s150ms 2s150ms 17 1 2s173ms 2s173ms 18 1 2s180ms 2s180ms 19 1 2s131ms 2s131ms 20 1 2s177ms 2s177ms 21 1 2s98ms 2s98ms [ User: postgres - Total duration: 32s658ms - Times executed: 15 ]
[ Application: psql - Total duration: 32s658ms - Times executed: 15 ]
-
SELECT profile.take_sample ();
Date: 2026-07-18 10:00:03 Duration: 2s405ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-18 07:00:03 Duration: 2s236ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-18 11:00:03 Duration: 2s225ms Database: etendo User: postgres Remote: [local] Application: psql
2 7 2m48s 23s531ms 24s659ms 24s113ms 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 18 12 1 24s202ms 24s202ms 13 1 23s531ms 23s531ms 14 1 24s659ms 24s659ms 15 1 24s438ms 24s438ms 17 1 23s934ms 23s934ms 18 1 24s333ms 24s333ms 19 1 23s693ms 23s693ms [ User: tad - Total duration: 2m48s - Times executed: 7 ]
[ Application: Mashup Engine - Total duration: 2m48s - 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-18 14:14:08 Duration: 24s659ms 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-18 15:12:09 Duration: 24s438ms 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-18 18:13:15 Duration: 24s333ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
3 1 1s882ms 1s882ms 1s882ms 1s882ms 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 18 15 1 1s882ms 1s882ms [ User: tad - Total duration: 1s882ms - Times executed: 1 ]
[ Application: Mashup Engine - Total duration: 1s882ms - Times executed: 1 ]
-
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-18 15:11:47 Duration: 1s882ms 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 23s531ms 24s659ms 24s113ms 7 2m48s 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 18 12 1 24s202ms 24s202ms 13 1 23s531ms 23s531ms 14 1 24s659ms 24s659ms 15 1 24s438ms 24s438ms 17 1 23s934ms 23s934ms 18 1 24s333ms 24s333ms 19 1 23s693ms 23s693ms [ User: tad - Total duration: 2m48s - Times executed: 7 ]
[ Application: Mashup Engine - Total duration: 2m48s - 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-18 14:14:08 Duration: 24s659ms 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-18 15:12:09 Duration: 24s438ms 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-18 18:13:15 Duration: 24s333ms Database: etendo User: tad Remote: 46.183.115.21 Application: Mashup Engine Bind query: yes
2 2s98ms 2s405ms 2s177ms 15 32s658ms select profile.take_sample ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 18 07 1 2s236ms 2s236ms 08 1 2s133ms 2s133ms 09 1 2s101ms 2s101ms 10 1 2s405ms 2s405ms 11 1 2s225ms 2s225ms 12 1 2s146ms 2s146ms 13 1 2s147ms 2s147ms 14 1 2s216ms 2s216ms 15 1 2s135ms 2s135ms 16 1 2s150ms 2s150ms 17 1 2s173ms 2s173ms 18 1 2s180ms 2s180ms 19 1 2s131ms 2s131ms 20 1 2s177ms 2s177ms 21 1 2s98ms 2s98ms [ User: postgres - Total duration: 32s658ms - Times executed: 15 ]
[ Application: psql - Total duration: 32s658ms - Times executed: 15 ]
-
SELECT profile.take_sample ();
Date: 2026-07-18 10:00:03 Duration: 2s405ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-18 07:00:03 Duration: 2s236ms Database: etendo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-18 11:00:03 Duration: 2s225ms Database: etendo User: postgres Remote: [local] Application: psql
3 1s882ms 1s882ms 1s882ms 1 1s882ms 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 18 15 1 1s882ms 1s882ms [ User: tad - Total duration: 1s882ms - Times executed: 1 ]
[ Application: Mashup Engine - Total duration: 1s882ms - Times executed: 1 ]
-
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-18 15:11:47 Duration: 1s882ms 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
-
Events
Log levels
Key values
- 34,366 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
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