pgBadger-
Global information
- Generated on Sun Jul 19 20:00:06 2026
- Log file: /var/log/postgresql/postgresql-12-main.log
- Parsed 60,434 log entries in 5s
- Log start from 2026-07-19 07:00:01 to 2026-07-19 20:00:03
-
Overview
Global Stats
- 27 Number of unique normalized queries
- 427 Number of queries
- 29m39s Total query duration
- 2026-07-19 07:00:03 First query
- 2026-07-19 20:00:03 Last query
- 2 queries/s at 2026-07-19 07:00:03 Query peak
- 29m39s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 29m39s 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
- 94 Total number of automatic vacuums
- 95 Total number of automatic analyzes
- 312 Number temporary file
- 58.95 MiB Max size of temporary file
- 58.95 MiB Average size of temporary file
- 8,984 Total number of sessions
- 6 sessions at 2026-07-19 09:00:02 Session peak
- 1d9h32m6s Total duration of sessions
- 13s437ms Average duration of sessions
- 0 Average queries per session
- 198ms Average queries duration per session
- 8,982 Total number of connections
- 9 connections/s at 2026-07-19 19:45:27 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2026-07-19 07:00:03 Date
SELECT Traffic
Key values
- 0 queries/s Query Peak
- Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2 queries/s Query Peak
- 2026-07-19 07:00:03 Date
Queries duration
Key values
- 29m39s 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 19 07 53 0ms 49s743ms 5s967ms 11s579ms 45s898ms 1m10s 08 31 0ms 7s518ms 3s948ms 10s244ms 11s301ms 16s278ms 09 31 0ms 8s201ms 4s27ms 10s764ms 11s741ms 19s63ms 10 31 0ms 6s665ms 3s932ms 10s506ms 11s666ms 14s238ms 11 31 0ms 6s887ms 3s887ms 10s323ms 10s548ms 14s995ms 12 31 0ms 6s47ms 3s889ms 10s396ms 10s985ms 14s778ms 13 31 0ms 6s534ms 3s880ms 10s604ms 11s35ms 14s726ms 14 31 0ms 7s544ms 4s4ms 10s626ms 11s579ms 16s38ms 15 31 0ms 6s511ms 3s950ms 10s470ms 11s697ms 13s930ms 16 31 0ms 6s781ms 3s850ms 10s507ms 10s732ms 14s929ms 17 31 0ms 6s381ms 3s857ms 10s312ms 11s227ms 14s361ms 18 31 0ms 5s614ms 3s969ms 10s929ms 11s793ms 14s501ms 19 31 0ms 6s523ms 3s852ms 10s272ms 11s464ms 13s995ms 20 2 2s174ms 2s612ms 2s393ms 4s786ms 4s786ms 4s786ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 19 07 19 0 3s840ms 4s158ms 6s327ms 6s984ms 08 19 0 3s700ms 4s78ms 6s368ms 6s802ms 09 19 0 3s897ms 4s108ms 6s403ms 7s311ms 10 19 0 3s626ms 4s6ms 6s576ms 7s89ms 11 19 0 3s661ms 4s42ms 6s362ms 7s582ms 12 19 0 3s575ms 4s59ms 6s394ms 7s58ms 13 19 0 3s640ms 4s77ms 6s594ms 7s186ms 14 19 0 3s693ms 4s33ms 6s477ms 6s821ms 15 19 0 3s666ms 4s232ms 6s590ms 6s910ms 16 19 0 3s646ms 4s36ms 6s479ms 6s997ms 17 19 0 3s615ms 4s36ms 6s373ms 6s745ms 18 19 0 3s628ms 4s128ms 6s597ms 7s36ms 19 19 0 3s581ms 4s113ms 6s220ms 6s767ms 20 2 0 2s393ms 4s786ms 4s786ms 4s786ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 19 07 0 12 0 0 4s651ms 0ms 4s95ms 5s8ms 08 0 12 0 0 4s340ms 0ms 3s838ms 4s731ms 09 0 12 0 0 4s232ms 0ms 3s887ms 4s393ms 10 0 12 0 0 4s416ms 0ms 3s929ms 4s772ms 11 0 12 0 0 4s245ms 0ms 3s898ms 4s504ms 12 0 12 0 0 4s387ms 0ms 3s962ms 4s637ms 13 0 12 0 0 4s260ms 0ms 3s903ms 4s684ms 14 0 12 0 0 4s496ms 0ms 3s890ms 4s788ms 15 0 12 0 0 4s399ms 0ms 3s880ms 4s950ms 16 0 12 0 0 4s172ms 0ms 3s906ms 4s458ms 17 0 12 0 0 4s241ms 0ms 3s854ms 4s605ms 18 0 12 0 0 4s509ms 0ms 3s848ms 4s992ms 19 0 12 0 0 4s283ms 0ms 3s937ms 4s681ms 20 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 19 07 0 30 30.00 0.00% 08 0 30 30.00 0.00% 09 0 30 30.00 0.00% 10 0 30 30.00 0.00% 11 0 30 30.00 0.00% 12 0 30 30.00 0.00% 13 0 30 30.00 0.00% 14 0 30 30.00 0.00% 15 0 30 30.00 0.00% 16 0 30 30.00 0.00% 17 0 30 30.00 0.00% 18 0 30 30.00 0.00% 19 0 30 30.00 0.00% 20 0 1 1.00 0.00% Day Hour Count Average / Second Jul 19 07 698 0.19/s 08 697 0.19/s 09 702 0.20/s 10 697 0.19/s 11 697 0.19/s 12 697 0.19/s 13 697 0.19/s 14 697 0.19/s 15 697 0.19/s 16 697 0.19/s 17 667 0.19/s 18 667 0.19/s 19 667 0.19/s 20 5 0.00/s Day Hour Count Average Duration Jul 19 07 700 1m11s 08 697 18ms 09 702 1m40s 10 697 17ms 11 697 18ms 12 697 17ms 13 697 17ms 14 697 18ms 15 697 18ms 16 697 18ms 17 667 18ms 18 667 18ms 19 667 17ms 20 5 877ms -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-07-19 19:45:27 Date
Connections per database
Key values
- openbravo Main Database
- 8,982 connections Total
Connections per user
Key values
- postgres Main User
- 8,982 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-07-19 09:00:02 Date
Histogram of session times
Key values
- 8,945 0-500ms duration
Sessions per database
Key values
- openbravo Main Database
- 8,984 sessions Total
Sessions per user
Key values
- postgres Main User
- 8,984 sessions Total
Sessions per host
Key values
- [local] Main Host
- 8,984 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 1,854 buffers Checkpoint Peak
- 2026-07-19 10:06:46 Date
- 185.568 seconds Highest write time
- 0.013 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-07-19 16:23:46 Date
Checkpoints distance
Key values
- 28.21 Mo Distance Peak
- 2026-07-19 10:06:46 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 19 07 2,445 246.604s 0.014s 246.674s 08 1,819 183.363s 0.015s 183.435s 09 1,857 187.052s 0.015s 187.13s 10 2,102 211.418s 0.014s 211.488s 11 1,629 164.559s 0.016s 164.646s 12 1,796 180.971s 0.013s 181.041s 13 1,822 183.729s 0.014s 183.808s 14 1,729 174.48s 0.013s 174.559s 15 1,836 184.93s 0.026s 185.015s 16 1,697 171.08s 0.012s 171.157s 17 1,860 187.466s 0.013s 187.54s 18 1,758 177.511s 0.016s 177.584s 19 1,802 181.516s 0.016s 181.589s 20 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 19 07 0 1 0 227 0.001s 0.012s 08 0 1 0 204 0.002s 0.012s 09 0 1 0 213 0.002s 0.012s 10 0 1 0 201 0.002s 0.011s 11 0 1 0 206 0.002s 0.012s 12 0 0 0 202 0.001s 0.011s 13 0 1 0 208 0.002s 0.012s 14 0 1 0 208 0.002s 0.012s 15 0 1 0 210 0.012s 0.013s 16 0 1 0 198 0.001s 0.012s 17 0 1 0 209 0.001s 0.012s 18 0 0 0 221 0.002s 0.012s 19 0 1 0 201 0.002s 0.012s 20 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 19 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 Day Hour Mean distance Mean estimate Jul 19 07 1,363.83 kB 7,399.33 kB 08 1,199.75 kB 7,653.50 kB 09 1,240.08 kB 7,813.67 kB 10 1,445.18 kB 9,056.18 kB 11 1,058.50 kB 6,868.42 kB 12 1,274.55 kB 7,886.64 kB 13 1,171.83 kB 7,399.33 kB 14 1,124.58 kB 7,146.92 kB 15 1,166.08 kB 7,156.75 kB 16 1,069.08 kB 6,913.33 kB 17 1,163.92 kB 6,934.67 kB 18 1,091.75 kB 6,714.67 kB 19 1,134.50 kB 7,232.83 kB 20 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 58.95 MiB Temp Files size Peak
- 2026-07-19 07:40:04 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2026-07-19 07:40:04 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 19 07 24 1.38 GiB 58.95 MiB 08 24 1.38 GiB 58.95 MiB 09 24 1.38 GiB 58.95 MiB 10 24 1.38 GiB 58.95 MiB 11 24 1.38 GiB 58.95 MiB 12 24 1.38 GiB 58.95 MiB 13 24 1.38 GiB 58.95 MiB 14 24 1.38 GiB 58.95 MiB 15 24 1.38 GiB 58.95 MiB 16 24 1.38 GiB 58.95 MiB 17 24 1.38 GiB 58.95 MiB 18 24 1.38 GiB 58.95 MiB 19 24 1.38 GiB 58.95 MiB 20 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 156 8.98 GiB 58.95 MiB 58.95 MiB 58.95 MiB update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select f.c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || f.documentno || ? as description, ? as isactive, f.ad_org_id, f.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, f.c_invoice_id, ?) as record_id from ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = ? and co.em_obpos_applications_id is not null group by ci.documentno, extract(year from dateinvoiced), ci.c_doctype_id having count(ci.documentno) > ? order by max(dateinvoiced) desc) as f) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '463465B5BE664902A40F05E84E1587CD' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-19 12:00:11 Duration: 6s47ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '463465B5BE664902A40F05E84E1587CD' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-19 07:00:14 Duration: 5s941ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '463465B5BE664902A40F05E84E1587CD' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-19 07:05:10 Duration: 5s612ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo
2 156 8.98 GiB 58.95 MiB 58.95 MiB 58.95 MiB select * from ( select f.c_invoice_id as referencekey_id, ;-
SELECT * FROM ( select f.c_invoice_id as referencekey_id, ;
Date: 2026-07-19 07:00:08 Duration: 0ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo
Queries generating the largest temporary files
Rank Size Query 1 58.95 MiB SELECT * FROM ( select f.c_invoice_id as referencekey_id, ;[ Date: 2026-07-19 07:00:08 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2 58.95 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 f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 07:00:14 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3 58.95 MiB SELECT * FROM ( select f.c_invoice_id as referencekey_id, ;[ Date: 2026-07-19 07:05:04 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4 58.95 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 f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 07:05:10 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5 58.95 MiB SELECT * FROM ( select f.c_invoice_id as referencekey_id, ;[ Date: 2026-07-19 07:10:05 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
6 58.95 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 f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 07:10:10 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
7 58.95 MiB SELECT * FROM ( select f.c_invoice_id as referencekey_id, ;[ Date: 2026-07-19 07:15:04 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8 58.95 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 f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 07:15:08 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
9 58.95 MiB SELECT * FROM ( select f.c_invoice_id as referencekey_id, ;[ Date: 2026-07-19 07:20:05 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
10 58.95 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 f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 07:20:09 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
11 58.95 MiB SELECT * FROM ( select f.c_invoice_id as referencekey_id, ;[ Date: 2026-07-19 07:25:04 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
12 58.95 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 f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 07:25:08 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
13 58.95 MiB SELECT * FROM ( select f.c_invoice_id as referencekey_id, ;[ Date: 2026-07-19 07:30:04 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
14 58.95 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 f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 07:30:08 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
15 58.95 MiB SELECT * FROM ( select f.c_invoice_id as referencekey_id, ;[ Date: 2026-07-19 07:35:04 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
16 58.95 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 f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 07:35:08 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
17 58.95 MiB SELECT * FROM ( select f.c_invoice_id as referencekey_id, ;[ Date: 2026-07-19 07:40:04 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
18 58.95 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 f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 07:40:09 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
19 58.95 MiB SELECT * FROM ( select f.c_invoice_id as referencekey_id, ;[ Date: 2026-07-19 07:45:04 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
20 58.95 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 f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 07:45:09 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Analyzes per table
Key values
- profile.last_stat_indexes_srv1 (13) Main table analyzed (database openbravo)
- 95 analyzes Total
Table Number of analyzes openbravo.profile.last_stat_indexes_srv1 13 openbravo.profile.last_stat_statements_srv1 13 openbravo.profile.last_stat_tables_srv1 13 openbravo.profile.last_stat_user_functions_srv1 13 openbravo.public.ad_process_request 8 openbravo.public.prpres_conf 7 openbravo.profile.stmt_list 4 openbravo.profile.tables_list 4 openbravo.profile.last_stat_activity_count_srv1 3 openbravo.profile.indexes_list 3 openbravo.profile.last_extension_versions 3 openbravo.profile.sample_statements 2 openbravo.profile.sample_stat_indexes 1 openbravo.public.ad_process_run 1 openbravo.profile.funcs_list 1 openbravo.profile.sample_stat_tables_total 1 openbravo.profile.sample_stat_user_functions 1 openbravo.profile.sample_statements_total 1 openbravo.profile.sample_stat_indexes_total 1 openbravo.profile.sample_stat_database 1 openbravo.profile.sample_stat_tables 1 Total 95 Vacuums per table
Key values
- profile.last_stat_user_functions_srv1 (20) Main table vacuumed on database openbravo
- 94 vacuums Total
Table Number of vacuums Index scans openbravo.profile.last_stat_user_functions_srv1 20 13 openbravo.profile.last_stat_indexes_srv1 20 13 openbravo.profile.last_stat_statements_srv1 20 13 openbravo.profile.last_stat_tables_srv1 20 13 openbravo.profile.tables_list 3 3 openbravo.profile.last_extension_versions 2 2 openbravo.profile.indexes_list 2 2 openbravo.profile.last_stat_activity_count_srv1 2 0 openbravo.profile.stmt_list 2 2 openbravo.pg_toast.pg_toast_2619 1 1 openbravo.pg_catalog.pg_statistic 1 1 openbravo.profile.last_stat_database_srv1 1 1 Total 94 64 Tuples removed per table
Key values
- profile.last_stat_indexes_srv1 (71869) Main table with removed tuples on database openbravo
- 130521 tuples Total removed
Table Number of vacuums Index scans Tuples removed Pages removed openbravo.profile.last_stat_indexes_srv1 20 13 71869 0 openbravo.profile.last_stat_tables_srv1 20 13 44057 0 openbravo.profile.last_stat_statements_srv1 20 13 7947 67 openbravo.profile.last_stat_user_functions_srv1 20 13 4929 0 openbravo.pg_catalog.pg_statistic 1 1 800 0 openbravo.pg_toast.pg_toast_2619 1 1 275 0 openbravo.profile.tables_list 3 3 204 0 openbravo.profile.stmt_list 2 2 157 0 openbravo.profile.indexes_list 2 2 127 0 openbravo.profile.last_extension_versions 2 2 104 0 openbravo.profile.last_stat_activity_count_srv1 2 0 40 2 openbravo.profile.last_stat_database_srv1 1 1 12 0 Total 94 64 130,521 69 Pages removed per table
Key values
- profile.last_stat_statements_srv1 (67) Main table with removed pages on database openbravo
- 69 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed openbravo.profile.last_stat_statements_srv1 20 13 7947 67 openbravo.profile.last_stat_activity_count_srv1 2 0 40 2 openbravo.pg_toast.pg_toast_2619 1 1 275 0 openbravo.pg_catalog.pg_statistic 1 1 800 0 openbravo.profile.last_extension_versions 2 2 104 0 openbravo.profile.last_stat_database_srv1 1 1 12 0 openbravo.profile.tables_list 3 3 204 0 openbravo.profile.last_stat_user_functions_srv1 20 13 4929 0 openbravo.profile.indexes_list 2 2 127 0 openbravo.profile.last_stat_indexes_srv1 20 13 71869 0 openbravo.profile.last_stat_tables_srv1 20 13 44057 0 openbravo.profile.stmt_list 2 2 157 0 Total 94 64 130,521 69 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 19 07 26 6 08 4 9 09 6 8 10 10 8 11 8 5 12 5 11 13 8 7 14 4 5 15 5 8 16 4 6 17 5 7 18 4 7 19 5 8 20 0 0 - 0 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
- 249 Total read queries
- 156 Total write queries
Queries by database
Key values
- openbravo Main database
- 427 Requests
- 29m39s (openbravo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 413 Requests
User Request type Count Duration postgres Total 14 22s136ms SELECT 14 22s136ms tad Total 413 29m17s COPY 22 3m7s SELECT 235 14m50s UPDATE 156 11m19s Duration by user
Key values
- 29m17s (tad) Main time consuming user
User Request type Count Duration postgres Total 14 22s136ms SELECT 14 22s136ms tad Total 413 29m17s COPY 22 3m7s SELECT 235 14m50s UPDATE 156 11m19s Queries by host
Key values
- 127.0.0.1 Main host
- 413 Requests
- 29m17s (127.0.0.1)
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 391 Requests
- 26m10s (openbravo)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-19 11:04:14 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 421 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 49s743ms COPY public.ad_image (ad_image_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, name, imageurl, binarydata, width, height, mimetype) TO stdout;[ Date: 2026-07-19 07:00:56 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
2 19s911ms COPY public.c_orderline (c_orderline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_order_id, line, c_bpartner_id, c_bpartner_location_id, dateordered, datepromised, datedelivered, dateinvoiced, description, m_product_id, m_warehouse_id, directship, c_uom_id, qtyordered, qtyreserved, qtydelivered, qtyinvoiced, m_shipper_id, c_currency_id, pricelist, priceactual, pricelimit, linenetamt, discount, freightamt, c_charge_id, chargeamt, c_tax_id, s_resourceassignment_id, ref_orderline_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_offer_id, pricestd, cancelpricead, c_order_discount_id, iseditlinenetamt, taxbaseamt, m_inoutline_id, c_return_reason_id, gross_unit_price, line_gross_amount, grosspricelist, c_costcenter_id, grosspricestd, a_asset_id, m_warehouse_rule_id, user1_id, quotationline_id, user2_id, create_reservation, c_project_id, so_res_status, manage_reservation, manage_prereservation, explode, bom_parent_id, em_mntc_discount, print_description, overdue_return_days, relate_orderline, replacedorderline_id, c_aum, aumqty, returnline, em_obpos_epccode, em_obpos_serialnumber, em_obpos_isdeleted, em_obpos_service_proposed, em_obpos_qtydeleted, em_obpos_canbedelivered, em_obpos_ispaid, em_obpos_pricereason_id, em_obrdm_delivery_mode, em_obrdm_delivery_date, em_obrdm_delivery_time, em_obrdm_amttopayindelivery, em_obmfm_isfreightamt, em_obmfm_freight_definition_id, em_obwpl_readypl, salesrep_id, em_prpres_ps_line_id) TO stdout;[ Date: 2026-07-19 07:02:07 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
3 16s592ms COPY public.c_invoiceline (c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoice_id, c_orderline_id, m_inoutline_id, line, description, financial_invoice_line, account_id, m_product_id, qtyinvoiced, pricelist, priceactual, pricelimit, linenetamt, c_charge_id, chargeamt, c_uom_id, c_tax_id, s_resourceassignment_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, c_invoice_discount_id, c_projectline_id, m_offer_id, pricestd, excludeforwithholding, iseditlinenetamt, taxbaseamt, line_gross_amount, gross_unit_price, c_bpartner_id, periodnumber, grosspricestd, a_asset_id, defplantype, grosspricelist, c_project_id, isdeferred, c_period_id, c_costcenter_id, user1_id, user2_id, explode, bom_parent_id, match_lccosts, c_aum, aumqty, salesrep_id) TO stdout;[ Date: 2026-07-19 07:01:23 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
4 12s631ms COPY public.m_transaction (m_transaction_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, movementtype, m_locator_id, m_product_id, movementdate, movementqty, m_inventoryline_id, m_movementline_id, m_inoutline_id, m_productionline_id, c_projectissue_id, m_attributesetinstance_id, m_product_uom_id, quantityorder, c_uom_id, m_internal_consumptionline_id, transactioncost, trxprocessdate, m_costing_algorithm_id, iscostcalculated, c_currency_id, costing_status, checkreservedqty, isprocessed, checkpricedifference, manualcostadjustment, iscostpermanent) TO stdout;[ Date: 2026-07-19 07:03:23 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
5 12s135ms COPY public.m_inoutline (m_inoutline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, line, description, m_inout_id, c_orderline_id, m_locator_id, m_product_id, c_uom_id, movementqty, isinvoiced, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_condition_goods_id, canceled_inoutline_id, a_asset_id, manage_prereservation, user1_id, user2_id, c_project_id, c_costcenter_id, c_bpartner_id, explode, bom_parent_id, c_aum, aumqty, em_obwpl_pickinglist_id, em_obwpl_editlines_pe, em_obwpl_removeline, em_prpp_qtyverified, salesrep_id) TO stdout;[ Date: 2026-07-19 07:03:08 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
6 11s293ms COPY public.c_orderlinetax (c_orderlinetax_id, c_orderline_id, c_tax_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, c_order_id) TO stdout;[ Date: 2026-07-19 07:02:27 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
7 9s36ms COPY public.c_orderline_offer (c_orderline_offer_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_orderline_id, line, m_offer_id, priceoffer, amtoffer, priceoffergross, totalamt, displayedtotalamt, em_obdisc_qtyoffer, em_obdisc_identifier, em_obpos_discountinstance, em_obpos_extraproperties) TO stdout;[ Date: 2026-07-19 07:02:16 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
8 8s669ms SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 07:00:08 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
9 8s502ms COPY public.c_invoicelinetax (c_invoicelinetax_id, c_tax_id, c_invoice_id, c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, recalculate) TO stdout;[ Date: 2026-07-19 07:01:38 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
10 8s201ms SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 09:00:08 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
11 7s544ms SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 14:00:07 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
12 7s518ms SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 08:00:07 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
13 6s887ms SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 11:00:06 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
14 6s781ms SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 16:00:06 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
15 6s665ms SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 10:00:06 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
16 6s534ms SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 13:00:06 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
17 6s524ms COPY public.c_invoiceline_offer (c_invoiceline_offer_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoiceline_id, line, m_offer_id, priceoffer, amtoffer, priceoffergross, totalamt, displayedtotalamt, em_obdisc_qtyoffer) TO stdout;[ Date: 2026-07-19 07:01:30 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: pg_dump ]
18 6s523ms SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 19:00:06 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
19 6s511ms SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 15:00:06 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
20 6s381ms SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');[ Date: 2026-07-19 17:00:06 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 12m17s 156 3s989ms 8s669ms 4s730ms select * from ( select f.c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || f.documentno || ? as description, ? as isactive, f.ad_org_id, f.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, f.c_invoice_id, ?) as record_id from ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = ? and co.em_obpos_applications_id is not null group by ci.documentno, extract(year from dateinvoiced), ci.c_doctype_id having count(ci.documentno) > ? order by max(dateinvoiced) desc) as f) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 07 12 59s272ms 4s939ms 08 12 56s662ms 4s721ms 09 12 57s862ms 4s821ms 10 12 56s681ms 4s723ms 11 12 56s523ms 4s710ms 12 12 55s339ms 4s611ms 13 12 56s732ms 4s727ms 14 12 57s580ms 4s798ms 15 12 57s215ms 4s767ms 16 12 56s303ms 4s691ms 17 12 55s905ms 4s658ms 18 12 55s997ms 4s666ms 19 12 55s833ms 4s652ms [ User: tad - Total duration: 12m17s - Times executed: 156 ]
[ Application: openbravo - Total duration: 12m17s - Times executed: 156 ]
-
SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 07:00:08 Duration: 8s669ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 09:00:08 Duration: 8s201ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 14:00:07 Duration: 7s544ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 11m19s 156 3s804ms 6s47ms 4s356ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select f.c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || f.documentno || ? as description, ? as isactive, f.ad_org_id, f.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, f.c_invoice_id, ?) as record_id from ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = ? and co.em_obpos_applications_id is not null group by ci.documentno, extract(year from dateinvoiced), ci.c_doctype_id having count(ci.documentno) > ? order by max(dateinvoiced) desc) as f) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 07 12 55s823ms 4s651ms 08 12 52s83ms 4s340ms 09 12 50s793ms 4s232ms 10 12 52s992ms 4s416ms 11 12 50s941ms 4s245ms 12 12 52s655ms 4s387ms 13 12 51s126ms 4s260ms 14 12 53s955ms 4s496ms 15 12 52s796ms 4s399ms 16 12 50s74ms 4s172ms 17 12 50s895ms 4s241ms 18 12 54s111ms 4s509ms 19 12 51s399ms 4s283ms [ User: tad - Total duration: 11m19s - Times executed: 156 ]
[ Application: openbravo - Total duration: 11m19s - Times executed: 156 ]
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '463465B5BE664902A40F05E84E1587CD' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-19 12:00:11 Duration: 6s47ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '463465B5BE664902A40F05E84E1587CD' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-19 07:00:14 Duration: 5s941ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '463465B5BE664902A40F05E84E1587CD' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-19 07:05:10 Duration: 5s612ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 2m32s 79 1s639ms 4s651ms 1s929ms select distinct pprod.m_product_id, pprod.ps_product_id as baseprodid, ? as combinationid, pprod.stock_id, pprod.shop_id, coalesce(pprod.group_id, ?) as group_id, coalesce(pprod.out_of_stock, ?) as out_of_stock, coalesce(pprod.depends_on_stock, ?) as depends_on_stock from prpres_product pprod where pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_transaction left join prpres_product on m_transaction.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = ? and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_product.m_product_id is not null and m_product.isgeneric = ?) or pprod.prpres_product_id in ( select distinct (prpres_product_id) from prpres_product left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id left join m_product on prpres_product.m_product_id = m_product.m_product_id where prpres_conf.prpres_conf_id = ? and coalesce(prpres_product.inventory_date, prpres_product.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_product.m_product_id is not null and m_product.isgeneric = ?) or pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_reservation left join prpres_product on m_reservation.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = ? and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_product.m_product_id is not null and m_product.isgeneric = ?) union select distinct pcomb.m_product_id, pprod.ps_product_id as baseprodid, pcomb.ps_combination_id as combinationid, pcomb.stock_id, pcomb.shop_id, coalesce(pcomb.group_id, ?) as group_id, coalesce(pcomb.out_of_stock, ?) as out_of_stock, coalesce(pcomb.depends_on_stock, ?) as depends_on_stock from prpres_combination pcomb left join prpres_product pprod on pcomb.prpres_product_id = pprod.prpres_product_id where pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_transaction left join prpres_combination on m_transaction.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = ? and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_combination.m_product_id is not null and m_product.isgeneric = ?) or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from prpres_combination left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = ? and coalesce(prpres_combination.inventory_date, prpres_combination.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_combination.m_product_id is not null and m_product.isgeneric = ?) or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_reservation left join prpres_combination on m_reservation.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = ? and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_combination.m_product_id is not null and m_product.isgeneric = ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 07 6 11s863ms 1s977ms 08 6 11s930ms 1s988ms 09 6 13s943ms 2s323ms 10 6 10s959ms 1s826ms 11 6 11s440ms 1s906ms 12 6 11s263ms 1s877ms 13 6 11s134ms 1s855ms 14 6 11s91ms 1s848ms 15 6 11s44ms 1s840ms 16 6 11s446ms 1s907ms 17 6 11s220ms 1s870ms 18 6 11s595ms 1s932ms 19 6 10s894ms 1s815ms 20 1 2s612ms 2s612ms [ User: tad - Total duration: 2m32s - Times executed: 79 ]
[ Application: openbravo - Total duration: 2m32s - Times executed: 79 ]
-
select distinct pprod.m_product_id, pprod.ps_product_id as baseprodid, '0' as combinationid, pprod.stock_id, pprod.shop_id, coalesce(pprod.group_id, '0') as group_id, coalesce(pprod.out_of_stock, '2') as out_of_stock, coalesce(pprod.depends_on_stock, '0') as depends_on_stock from prpres_product pprod where pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_transaction left join prpres_product on m_transaction.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from prpres_product left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id left join m_product on prpres_product.m_product_id = m_product.m_product_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_product.inventory_date, prpres_product.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_reservation left join prpres_product on m_reservation.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') UNION select distinct pcomb.m_product_id, pprod.ps_product_id as baseprodid, pcomb.ps_combination_id as combinationid, pcomb.stock_id, pcomb.shop_id, coalesce(pcomb.group_id, '0') as group_id, coalesce(pcomb.out_of_stock, '2') as out_of_stock, coalesce(pcomb.depends_on_stock, '0') as depends_on_stock from prpres_combination pcomb left join prpres_product pprod on pcomb.prpres_product_id = pprod.prpres_product_id where pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_transaction left join prpres_combination on m_transaction.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from prpres_combination left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_combination.inventory_date, prpres_combination.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_reservation left join prpres_combination on m_reservation.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N');
Date: 2026-07-19 09:00:04 Duration: 4s651ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select distinct pprod.m_product_id, pprod.ps_product_id as baseprodid, '0' as combinationid, pprod.stock_id, pprod.shop_id, coalesce(pprod.group_id, '0') as group_id, coalesce(pprod.out_of_stock, '2') as out_of_stock, coalesce(pprod.depends_on_stock, '0') as depends_on_stock from prpres_product pprod where pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_transaction left join prpres_product on m_transaction.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from prpres_product left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id left join m_product on prpres_product.m_product_id = m_product.m_product_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_product.inventory_date, prpres_product.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_reservation left join prpres_product on m_reservation.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') UNION select distinct pcomb.m_product_id, pprod.ps_product_id as baseprodid, pcomb.ps_combination_id as combinationid, pcomb.stock_id, pcomb.shop_id, coalesce(pcomb.group_id, '0') as group_id, coalesce(pcomb.out_of_stock, '2') as out_of_stock, coalesce(pcomb.depends_on_stock, '0') as depends_on_stock from prpres_combination pcomb left join prpres_product pprod on pcomb.prpres_product_id = pprod.prpres_product_id where pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_transaction left join prpres_combination on m_transaction.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from prpres_combination left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_combination.inventory_date, prpres_combination.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_reservation left join prpres_combination on m_reservation.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N');
Date: 2026-07-19 07:00:03 Duration: 2s829ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select distinct pprod.m_product_id, pprod.ps_product_id as baseprodid, '0' as combinationid, pprod.stock_id, pprod.shop_id, coalesce(pprod.group_id, '0') as group_id, coalesce(pprod.out_of_stock, '2') as out_of_stock, coalesce(pprod.depends_on_stock, '0') as depends_on_stock from prpres_product pprod where pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_transaction left join prpres_product on m_transaction.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from prpres_product left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id left join m_product on prpres_product.m_product_id = m_product.m_product_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_product.inventory_date, prpres_product.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_reservation left join prpres_product on m_reservation.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') UNION select distinct pcomb.m_product_id, pprod.ps_product_id as baseprodid, pcomb.ps_combination_id as combinationid, pcomb.stock_id, pcomb.shop_id, coalesce(pcomb.group_id, '0') as group_id, coalesce(pcomb.out_of_stock, '2') as out_of_stock, coalesce(pcomb.depends_on_stock, '0') as depends_on_stock from prpres_combination pcomb left join prpres_product pprod on pcomb.prpres_product_id = pprod.prpres_product_id where pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_transaction left join prpres_combination on m_transaction.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from prpres_combination left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_combination.inventory_date, prpres_combination.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_reservation left join prpres_combination on m_reservation.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N');
Date: 2026-07-19 20:00:02 Duration: 2s612ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 49s743ms 1 49s743ms 49s743ms 49s743ms copy public.ad_image (ad_image_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, name, imageurl, binarydata, width, height, mimetype) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 19 07 1 49s743ms 49s743ms [ User: tad - Total duration: 49s743ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 49s743ms - Times executed: 1 ]
-
COPY public.ad_image (ad_image_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, name, imageurl, binarydata, width, height, mimetype) TO stdout;
Date: 2026-07-19 07:00:56 Duration: 49s743ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
5 22s136ms 14 1s262ms 2s241ms 1s581ms select profile.take_sample ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 19 07 1 1s835ms 1s835ms 08 1 1s724ms 1s724ms 09 1 2s241ms 2s241ms 10 1 1s262ms 1s262ms 11 1 1s606ms 1s606ms 12 1 1s321ms 1s321ms 13 1 1s292ms 1s292ms 14 1 1s499ms 1s499ms 15 1 1s398ms 1s398ms 16 1 1s542ms 1s542ms 17 1 1s566ms 1s566ms 18 1 1s356ms 1s356ms 19 1 1s313ms 1s313ms 20 1 2s174ms 2s174ms [ User: postgres - Total duration: 22s136ms - Times executed: 14 ]
[ Application: psql - Total duration: 22s136ms - Times executed: 14 ]
-
SELECT profile.take_sample ();
Date: 2026-07-19 09:00:04 Duration: 2s241ms Database: openbravo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-19 20:00:03 Duration: 2s174ms Database: openbravo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-19 07:00:03 Duration: 1s835ms Database: openbravo User: postgres Remote: [local] Application: psql
6 19s911ms 1 19s911ms 19s911ms 19s911ms copy public.c_orderline (c_orderline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_order_id, line, c_bpartner_id, c_bpartner_location_id, dateordered, datepromised, datedelivered, dateinvoiced, description, m_product_id, m_warehouse_id, directship, c_uom_id, qtyordered, qtyreserved, qtydelivered, qtyinvoiced, m_shipper_id, c_currency_id, pricelist, priceactual, pricelimit, linenetamt, discount, freightamt, c_charge_id, chargeamt, c_tax_id, s_resourceassignment_id, ref_orderline_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_offer_id, pricestd, cancelpricead, c_order_discount_id, iseditlinenetamt, taxbaseamt, m_inoutline_id, c_return_reason_id, gross_unit_price, line_gross_amount, grosspricelist, c_costcenter_id, grosspricestd, a_asset_id, m_warehouse_rule_id, user1_id, quotationline_id, user2_id, create_reservation, c_project_id, so_res_status, manage_reservation, manage_prereservation, explode, bom_parent_id, em_mntc_discount, print_description, overdue_return_days, relate_orderline, replacedorderline_id, c_aum, aumqty, returnline, em_obpos_epccode, em_obpos_serialnumber, em_obpos_isdeleted, em_obpos_service_proposed, em_obpos_qtydeleted, em_obpos_canbedelivered, em_obpos_ispaid, em_obpos_pricereason_id, em_obrdm_delivery_mode, em_obrdm_delivery_date, em_obrdm_delivery_time, em_obrdm_amttopayindelivery, em_obmfm_isfreightamt, em_obmfm_freight_definition_id, em_obwpl_readypl, salesrep_id, em_prpres_ps_line_id) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 19 07 1 19s911ms 19s911ms [ User: tad - Total duration: 19s911ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 19s911ms - Times executed: 1 ]
-
COPY public.c_orderline (c_orderline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_order_id, line, c_bpartner_id, c_bpartner_location_id, dateordered, datepromised, datedelivered, dateinvoiced, description, m_product_id, m_warehouse_id, directship, c_uom_id, qtyordered, qtyreserved, qtydelivered, qtyinvoiced, m_shipper_id, c_currency_id, pricelist, priceactual, pricelimit, linenetamt, discount, freightamt, c_charge_id, chargeamt, c_tax_id, s_resourceassignment_id, ref_orderline_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_offer_id, pricestd, cancelpricead, c_order_discount_id, iseditlinenetamt, taxbaseamt, m_inoutline_id, c_return_reason_id, gross_unit_price, line_gross_amount, grosspricelist, c_costcenter_id, grosspricestd, a_asset_id, m_warehouse_rule_id, user1_id, quotationline_id, user2_id, create_reservation, c_project_id, so_res_status, manage_reservation, manage_prereservation, explode, bom_parent_id, em_mntc_discount, print_description, overdue_return_days, relate_orderline, replacedorderline_id, c_aum, aumqty, returnline, em_obpos_epccode, em_obpos_serialnumber, em_obpos_isdeleted, em_obpos_service_proposed, em_obpos_qtydeleted, em_obpos_canbedelivered, em_obpos_ispaid, em_obpos_pricereason_id, em_obrdm_delivery_mode, em_obrdm_delivery_date, em_obrdm_delivery_time, em_obrdm_amttopayindelivery, em_obmfm_isfreightamt, em_obmfm_freight_definition_id, em_obwpl_readypl, salesrep_id, em_prpres_ps_line_id) TO stdout;
Date: 2026-07-19 07:02:07 Duration: 19s911ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
7 16s592ms 1 16s592ms 16s592ms 16s592ms copy public.c_invoiceline (c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoice_id, c_orderline_id, m_inoutline_id, line, description, financial_invoice_line, account_id, m_product_id, qtyinvoiced, pricelist, priceactual, pricelimit, linenetamt, c_charge_id, chargeamt, c_uom_id, c_tax_id, s_resourceassignment_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, c_invoice_discount_id, c_projectline_id, m_offer_id, pricestd, excludeforwithholding, iseditlinenetamt, taxbaseamt, line_gross_amount, gross_unit_price, c_bpartner_id, periodnumber, grosspricestd, a_asset_id, defplantype, grosspricelist, c_project_id, isdeferred, c_period_id, c_costcenter_id, user1_id, user2_id, explode, bom_parent_id, match_lccosts, c_aum, aumqty, salesrep_id) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 19 07 1 16s592ms 16s592ms [ User: tad - Total duration: 16s592ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 16s592ms - Times executed: 1 ]
-
COPY public.c_invoiceline (c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoice_id, c_orderline_id, m_inoutline_id, line, description, financial_invoice_line, account_id, m_product_id, qtyinvoiced, pricelist, priceactual, pricelimit, linenetamt, c_charge_id, chargeamt, c_uom_id, c_tax_id, s_resourceassignment_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, c_invoice_discount_id, c_projectline_id, m_offer_id, pricestd, excludeforwithholding, iseditlinenetamt, taxbaseamt, line_gross_amount, gross_unit_price, c_bpartner_id, periodnumber, grosspricestd, a_asset_id, defplantype, grosspricelist, c_project_id, isdeferred, c_period_id, c_costcenter_id, user1_id, user2_id, explode, bom_parent_id, match_lccosts, c_aum, aumqty, salesrep_id) TO stdout;
Date: 2026-07-19 07:01:23 Duration: 16s592ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
8 12s631ms 1 12s631ms 12s631ms 12s631ms copy public.m_transaction (m_transaction_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, movementtype, m_locator_id, m_product_id, movementdate, movementqty, m_inventoryline_id, m_movementline_id, m_inoutline_id, m_productionline_id, c_projectissue_id, m_attributesetinstance_id, m_product_uom_id, quantityorder, c_uom_id, m_internal_consumptionline_id, transactioncost, trxprocessdate, m_costing_algorithm_id, iscostcalculated, c_currency_id, costing_status, checkreservedqty, isprocessed, checkpricedifference, manualcostadjustment, iscostpermanent) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 19 07 1 12s631ms 12s631ms [ User: tad - Total duration: 12s631ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 12s631ms - Times executed: 1 ]
-
COPY public.m_transaction (m_transaction_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, movementtype, m_locator_id, m_product_id, movementdate, movementqty, m_inventoryline_id, m_movementline_id, m_inoutline_id, m_productionline_id, c_projectissue_id, m_attributesetinstance_id, m_product_uom_id, quantityorder, c_uom_id, m_internal_consumptionline_id, transactioncost, trxprocessdate, m_costing_algorithm_id, iscostcalculated, c_currency_id, costing_status, checkreservedqty, isprocessed, checkpricedifference, manualcostadjustment, iscostpermanent) TO stdout;
Date: 2026-07-19 07:03:23 Duration: 12s631ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
9 12s135ms 1 12s135ms 12s135ms 12s135ms copy public.m_inoutline (m_inoutline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, line, description, m_inout_id, c_orderline_id, m_locator_id, m_product_id, c_uom_id, movementqty, isinvoiced, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_condition_goods_id, canceled_inoutline_id, a_asset_id, manage_prereservation, user1_id, user2_id, c_project_id, c_costcenter_id, c_bpartner_id, explode, bom_parent_id, c_aum, aumqty, em_obwpl_pickinglist_id, em_obwpl_editlines_pe, em_obwpl_removeline, em_prpp_qtyverified, salesrep_id) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 19 07 1 12s135ms 12s135ms [ User: tad - Total duration: 12s135ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 12s135ms - Times executed: 1 ]
-
COPY public.m_inoutline (m_inoutline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, line, description, m_inout_id, c_orderline_id, m_locator_id, m_product_id, c_uom_id, movementqty, isinvoiced, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_condition_goods_id, canceled_inoutline_id, a_asset_id, manage_prereservation, user1_id, user2_id, c_project_id, c_costcenter_id, c_bpartner_id, explode, bom_parent_id, c_aum, aumqty, em_obwpl_pickinglist_id, em_obwpl_editlines_pe, em_obwpl_removeline, em_prpp_qtyverified, salesrep_id) TO stdout;
Date: 2026-07-19 07:03:08 Duration: 12s135ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
10 11s293ms 1 11s293ms 11s293ms 11s293ms copy public.c_orderlinetax (c_orderlinetax_id, c_orderline_id, c_tax_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, c_order_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 19 07 1 11s293ms 11s293ms [ User: tad - Total duration: 11s293ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 11s293ms - Times executed: 1 ]
-
COPY public.c_orderlinetax (c_orderlinetax_id, c_orderline_id, c_tax_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, c_order_id) TO stdout;
Date: 2026-07-19 07:02:27 Duration: 11s293ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
11 9s36ms 1 9s36ms 9s36ms 9s36ms copy public.c_orderline_offer (c_orderline_offer_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_orderline_id, line, m_offer_id, priceoffer, amtoffer, priceoffergross, totalamt, displayedtotalamt, em_obdisc_qtyoffer, em_obdisc_identifier, em_obpos_discountinstance, em_obpos_extraproperties) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 19 07 1 9s36ms 9s36ms [ User: tad - Total duration: 9s36ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s36ms - Times executed: 1 ]
-
COPY public.c_orderline_offer (c_orderline_offer_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_orderline_id, line, m_offer_id, priceoffer, amtoffer, priceoffergross, totalamt, displayedtotalamt, em_obdisc_qtyoffer, em_obdisc_identifier, em_obpos_discountinstance, em_obpos_extraproperties) TO stdout;
Date: 2026-07-19 07:02:16 Duration: 9s36ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
12 8s502ms 1 8s502ms 8s502ms 8s502ms copy public.c_invoicelinetax (c_invoicelinetax_id, c_tax_id, c_invoice_id, c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, recalculate) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 19 07 1 8s502ms 8s502ms [ User: tad - Total duration: 8s502ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s502ms - Times executed: 1 ]
-
COPY public.c_invoicelinetax (c_invoicelinetax_id, c_tax_id, c_invoice_id, c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, recalculate) TO stdout;
Date: 2026-07-19 07:01:38 Duration: 8s502ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
13 6s524ms 1 6s524ms 6s524ms 6s524ms copy public.c_invoiceline_offer (c_invoiceline_offer_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoiceline_id, line, m_offer_id, priceoffer, amtoffer, priceoffergross, totalamt, displayedtotalamt, em_obdisc_qtyoffer) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 19 07 1 6s524ms 6s524ms [ User: tad - Total duration: 6s524ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 6s524ms - Times executed: 1 ]
-
COPY public.c_invoiceline_offer (c_invoiceline_offer_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoiceline_id, line, m_offer_id, priceoffer, amtoffer, priceoffergross, totalamt, displayedtotalamt, em_obdisc_qtyoffer) TO stdout;
Date: 2026-07-19 07:01:30 Duration: 6s524ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
14 5s936ms 1 5s936ms 5s936ms 5s936ms copy public.c_order (c_order_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processing, processed, c_doctype_id, c_doctypetarget_id, description, isdelivered, isinvoiced, isprinted, isselected, salesrep_id, dateordered, datepromised, dateprinted, dateacct, c_bpartner_id, billto_id, c_bpartner_location_id, poreference, isdiscountprinted, c_currency_id, paymentrule, c_paymentterm_id, invoicerule, deliveryrule, freightcostrule, freightamt, deliveryviarule, m_shipper_id, c_charge_id, chargeamt, priorityrule, totallines, grandtotal, m_warehouse_id, m_pricelist_id, istaxincluded, c_campaign_id, c_project_id, c_activity_id, posted, ad_user_id, copyfrom, dropship_bpartner_id, dropship_location_id, dropship_user_id, isselfservice, ad_orgtrx_id, user1_id, user2_id, deliverynotes, c_incoterms_id, incotermsdescription, generatetemplate, delivery_location_id, copyfrompo, fin_paymentmethod_id, fin_payment_priority_id, rm_pickfromshipment, rm_receivematerials, rm_createinvoice, c_return_reason_id, rm_addorphanline, a_asset_id, calculate_promotions, c_costcenter_id, convertquotation, c_reject_reason_id, validuntil, quotation_id, so_res_status, create_polines, iscashvat, rm_pickfromreceipt, em_opxmm_btn_purch, em_obdisc_addpack, em_obpos_applications_id, em_obpos_sendemail, em_obpos_email_status, cancelandreplace, confirmcancelandreplace, cancelledorder_id, replacedorder_id, iscancelled, replacementorder_id, em_aprm_addpayment, em_obpos_app_cashup_id, em_obpos_createdabsolute, em_obpos_notinvoiceoncashup, em_obpos_rejected_quotat_id, em_obpos_isdeleted, em_obpos_islayaway, em_obpos_prepaymentamt, em_obpos_prepaymentlimitamt, em_obpos_prepaymentlaylimitamt, em_prpres_reference, em_prpres_void_order, em_prpres_gross_total, em_prpres_net_total, em_prpres_isgift, em_prpres_giftmessage, em_prpres_id_cart, em_prpres_id_paym_transaction, em_obmfm_selectfreight, em_obmfm_delivery_period_id, em_obmfm_delivery_charges, em_obmfm_freight_id, em_obmfm_weight, em_obmfm_weight_uom_id, em_obmfm_set_weight, em_obwpl_generatepicking, em_obwpl_isinpickinglist, em_obwpl_readypl, em_prpp_generatepicking, em_mntc_createinvoice, bpartner_extref, c_alternate_location_id, em_prpres_processing, em_prpres_generatepicking, em_obpos_rounding_amount, em_obpos_sequencename, em_obpos_sequencenumber, em_obpos_skip_tax_calculation) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 19 07 1 5s936ms 5s936ms [ User: tad - Total duration: 5s936ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 5s936ms - Times executed: 1 ]
-
COPY public.c_order (c_order_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processing, processed, c_doctype_id, c_doctypetarget_id, description, isdelivered, isinvoiced, isprinted, isselected, salesrep_id, dateordered, datepromised, dateprinted, dateacct, c_bpartner_id, billto_id, c_bpartner_location_id, poreference, isdiscountprinted, c_currency_id, paymentrule, c_paymentterm_id, invoicerule, deliveryrule, freightcostrule, freightamt, deliveryviarule, m_shipper_id, c_charge_id, chargeamt, priorityrule, totallines, grandtotal, m_warehouse_id, m_pricelist_id, istaxincluded, c_campaign_id, c_project_id, c_activity_id, posted, ad_user_id, copyfrom, dropship_bpartner_id, dropship_location_id, dropship_user_id, isselfservice, ad_orgtrx_id, user1_id, user2_id, deliverynotes, c_incoterms_id, incotermsdescription, generatetemplate, delivery_location_id, copyfrompo, fin_paymentmethod_id, fin_payment_priority_id, rm_pickfromshipment, rm_receivematerials, rm_createinvoice, c_return_reason_id, rm_addorphanline, a_asset_id, calculate_promotions, c_costcenter_id, convertquotation, c_reject_reason_id, validuntil, quotation_id, so_res_status, create_polines, iscashvat, rm_pickfromreceipt, em_opxmm_btn_purch, em_obdisc_addpack, em_obpos_applications_id, em_obpos_sendemail, em_obpos_email_status, cancelandreplace, confirmcancelandreplace, cancelledorder_id, replacedorder_id, iscancelled, replacementorder_id, em_aprm_addpayment, em_obpos_app_cashup_id, em_obpos_createdabsolute, em_obpos_notinvoiceoncashup, em_obpos_rejected_quotat_id, em_obpos_isdeleted, em_obpos_islayaway, em_obpos_prepaymentamt, em_obpos_prepaymentlimitamt, em_obpos_prepaymentlaylimitamt, em_prpres_reference, em_prpres_void_order, em_prpres_gross_total, em_prpres_net_total, em_prpres_isgift, em_prpres_giftmessage, em_prpres_id_cart, em_prpres_id_paym_transaction, em_obmfm_selectfreight, em_obmfm_delivery_period_id, em_obmfm_delivery_charges, em_obmfm_freight_id, em_obmfm_weight, em_obmfm_weight_uom_id, em_obmfm_set_weight, em_obwpl_generatepicking, em_obwpl_isinpickinglist, em_obwpl_readypl, em_prpp_generatepicking, em_mntc_createinvoice, bpartner_extref, c_alternate_location_id, em_prpres_processing, em_prpres_generatepicking, em_obpos_rounding_amount, em_obpos_sequencename, em_obpos_sequencenumber, em_obpos_skip_tax_calculation) TO stdout;
Date: 2026-07-19 07:01:47 Duration: 5s936ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
15 5s459ms 1 5s459ms 5s459ms 5s459ms copy public.fin_payment_schedule (fin_payment_schedule_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, c_invoice_id, c_order_id, duedate, fin_paymentmethod_id, c_currency_id, amount, paidamt, outstandingamt, isactive, fin_payment_priority_id, update_payment_plan, origduedate, description, expecteddate, em_kctrp_isretention_payment, em_aprm_modif_paym_sched, em_aprm_modif_paym_out_sched) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 19 07 1 5s459ms 5s459ms [ User: tad - Total duration: 5s459ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 5s459ms - Times executed: 1 ]
-
COPY public.fin_payment_schedule (fin_payment_schedule_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, c_invoice_id, c_order_id, duedate, fin_paymentmethod_id, c_currency_id, amount, paidamt, outstandingamt, isactive, fin_payment_priority_id, update_payment_plan, origduedate, description, expecteddate, em_kctrp_isretention_payment, em_aprm_modif_paym_sched, em_aprm_modif_paym_out_sched) TO stdout;
Date: 2026-07-19 07:02:48 Duration: 5s459ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
16 4s947ms 1 4s947ms 4s947ms 4s947ms copy public.c_invoice (c_invoice_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processing, processed, posted, c_doctype_id, c_doctypetarget_id, c_order_id, description, isprinted, salesrep_id, dateinvoiced, dateprinted, dateacct, c_bpartner_id, c_bpartner_location_id, poreference, isdiscountprinted, dateordered, c_currency_id, c_paymentterm_id, c_charge_id, chargeamt, totallines, grandtotal, m_pricelist_id, istaxincluded, c_campaign_id, c_project_id, c_activity_id, createfrom, generateto, ad_user_id, copyfrom, isselfservice, ad_orgtrx_id, user1_id, user2_id, withholdingamount, taxdate, c_withholding_id, ispaid, totalpaid, outstandingamt, daystilldue, dueamt, lastcalculatedondate, fin_paymentmethod_id, fin_payment_priority_id, finalsettlement, daysoutstanding, percentageoverdue, c_costcenter_id, calculate_promotions, a_asset_id, iscashvat, em_lpy_controle_impressos_id, em_lpy_isfiscalserno, em_lpy_fiscalno, em_lpy_fiscalserno, em_kctrp_isretention_payment, em_kctrp_retention_grossamt_id, em_aprm_addpayment, em_aprm_processinvoice, prepaymentamt, createfromorders, createfrominouts, paidamtatinvoicing, bpartner_extref, c_alternate_location_id, einvoice_status, einvoice_generated, einvoice_externalid, einvoice_send_status, einvoice_sent, em_obpos_rounding_amount, em_obpos_sequencename, em_obpos_sequencenumber, em_mntc_invoice_format) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 19 07 1 4s947ms 4s947ms [ User: tad - Total duration: 4s947ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4s947ms - Times executed: 1 ]
-
COPY public.c_invoice (c_invoice_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processing, processed, posted, c_doctype_id, c_doctypetarget_id, c_order_id, description, isprinted, salesrep_id, dateinvoiced, dateprinted, dateacct, c_bpartner_id, c_bpartner_location_id, poreference, isdiscountprinted, dateordered, c_currency_id, c_paymentterm_id, c_charge_id, chargeamt, totallines, grandtotal, m_pricelist_id, istaxincluded, c_campaign_id, c_project_id, c_activity_id, createfrom, generateto, ad_user_id, copyfrom, isselfservice, ad_orgtrx_id, user1_id, user2_id, withholdingamount, taxdate, c_withholding_id, ispaid, totalpaid, outstandingamt, daystilldue, dueamt, lastcalculatedondate, fin_paymentmethod_id, fin_payment_priority_id, finalsettlement, daysoutstanding, percentageoverdue, c_costcenter_id, calculate_promotions, a_asset_id, iscashvat, em_lpy_controle_impressos_id, em_lpy_isfiscalserno, em_lpy_fiscalno, em_lpy_fiscalserno, em_kctrp_isretention_payment, em_kctrp_retention_grossamt_id, em_aprm_addpayment, em_aprm_processinvoice, prepaymentamt, createfromorders, createfrominouts, paidamtatinvoicing, bpartner_extref, c_alternate_location_id, einvoice_status, einvoice_generated, einvoice_externalid, einvoice_send_status, einvoice_sent, em_obpos_rounding_amount, em_obpos_sequencename, em_obpos_sequencenumber, em_mntc_invoice_format) TO stdout;
Date: 2026-07-19 07:01:06 Duration: 4s947ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
17 3s787ms 1 3s787ms 3s787ms 3s787ms copy public.fin_finacc_transaction (fin_finacc_transaction_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, isactive, c_currency_id, fin_financial_account_id, line, fin_payment_id, dateacct, c_glitem_id, status, paymentamt, depositamt, processed, processing, posted, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, trxtype, statementdate, description, fin_reconciliation_id, createdbyalgorithm, foreign_currency_id, foreign_convert_rate, foreign_amount, c_bpartner_id, m_product_id, c_salesregion_id, c_costcenter_id, em_aprm_processed, em_aprm_finacc_trans_origin, em_obpos_app_cashup_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 19 07 1 3s787ms 3s787ms [ User: tad - Total duration: 3s787ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 3s787ms - Times executed: 1 ]
-
COPY public.fin_finacc_transaction (fin_finacc_transaction_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, isactive, c_currency_id, fin_financial_account_id, line, fin_payment_id, dateacct, c_glitem_id, status, paymentamt, depositamt, processed, processing, posted, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, trxtype, statementdate, description, fin_reconciliation_id, createdbyalgorithm, foreign_currency_id, foreign_convert_rate, foreign_amount, c_bpartner_id, m_product_id, c_salesregion_id, c_costcenter_id, em_aprm_processed, em_aprm_finacc_trans_origin, em_obpos_app_cashup_id) TO stdout;
Date: 2026-07-19 07:02:34 Duration: 3s787ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
18 3s579ms 1 3s579ms 3s579ms 3s579ms copy public.fin_payment_scheduledetail (fin_payment_scheduledetail_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, fin_payment_detail_id, fin_payment_schedule_order, fin_payment_schedule_invoice, amount, isactive, writeoffamt, iscanceled, c_bpartner_id, c_activity_id, m_product_id, c_campaign_id, c_project_id, c_salesregion_id, c_costcenter_id, user1_id, user2_id, doubtfuldebt_amount, isinvoicepaid) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 19 07 1 3s579ms 3s579ms [ User: tad - Total duration: 3s579ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 3s579ms - Times executed: 1 ]
-
COPY public.fin_payment_scheduledetail (fin_payment_scheduledetail_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, fin_payment_detail_id, fin_payment_schedule_order, fin_payment_schedule_invoice, amount, isactive, writeoffamt, iscanceled, c_bpartner_id, c_activity_id, m_product_id, c_campaign_id, c_project_id, c_salesregion_id, c_costcenter_id, user1_id, user2_id, doubtfuldebt_amount, isinvoicepaid) TO stdout;
Date: 2026-07-19 07:02:52 Duration: 3s579ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
19 3s341ms 1 3s341ms 3s341ms 3s341ms copy public.fin_payment (fin_payment_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, isactive, isreceipt, c_bpartner_id, paymentdate, c_currency_id, amount, writeoffamt, fin_paymentmethod_id, documentno, referenceno, status, processed, processing, posted, description, fin_financial_account_id, c_doctype_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, generated_credit, used_credit, createdbyalgorithm, finacc_txn_convert_rate, finacc_txn_amount, fin_rev_payment_id, c_costcenter_id, em_kctrp_isretention_payment, em_kctrp_c_tax_id, em_kctrp_isretention_applied, em_kctrp_c_invoice_id, em_aprm_process_payment, em_aprm_reconcile_payment, em_aprm_add_scheduledpayments, em_aprm_executepayment, em_aprm_reversepayment, em_obpos_paymentdata, em_obpos_app_cashup_id, em_obpos_applications_id, em_obpos_rounded_payment_id, em_obpos_txtransaction, em_obpos_txauthorization, em_obpos_txcreditcardnummasked) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 19 07 1 3s341ms 3s341ms [ User: tad - Total duration: 3s341ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 3s341ms - Times executed: 1 ]
-
COPY public.fin_payment (fin_payment_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, isactive, isreceipt, c_bpartner_id, paymentdate, c_currency_id, amount, writeoffamt, fin_paymentmethod_id, documentno, referenceno, status, processed, processing, posted, description, fin_financial_account_id, c_doctype_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, generated_credit, used_credit, createdbyalgorithm, finacc_txn_convert_rate, finacc_txn_amount, fin_rev_payment_id, c_costcenter_id, em_kctrp_isretention_payment, em_kctrp_c_tax_id, em_kctrp_isretention_applied, em_kctrp_c_invoice_id, em_aprm_process_payment, em_aprm_reconcile_payment, em_aprm_add_scheduledpayments, em_aprm_executepayment, em_aprm_reversepayment, em_obpos_paymentdata, em_obpos_app_cashup_id, em_obpos_applications_id, em_obpos_rounded_payment_id, em_obpos_txtransaction, em_obpos_txauthorization, em_obpos_txcreditcardnummasked) TO stdout;
Date: 2026-07-19 07:02:40 Duration: 3s341ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
20 3s332ms 1 3s332ms 3s332ms 3s332ms copy public.m_inout (m_inout_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docaction, docstatus, posted, processing, processed, c_doctype_id, description, c_order_id, dateordered, isprinted, movementtype, movementdate, dateacct, c_bpartner_id, c_bpartner_location_id, m_warehouse_id, poreference, deliveryrule, freightcostrule, freightamt, deliveryviarule, m_shipper_id, c_charge_id, chargeamt, priorityrule, dateprinted, c_invoice_id, createfrom, generateto, ad_user_id, salesrep_id, nopackages, pickdate, shipdate, trackingno, ad_orgtrx_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, updatelines, islogistic, calculate_freight, delivery_location_id, m_freightcategory_id, freight_currency_id, rm_receipt_pickedit, rm_shipment_pickedit, m_condition_goods_id, a_asset_id, c_costcenter_id, process_goods_java, em_lpy_controle_impressos_id, em_lpy_isfiscalserno, em_lpy_fiscalno, em_lpy_fiscalserno, isnettingshipment, iscompletelyinvoiced, invoicefromshipment, em_prpres_disable_trackerror, em_obmfm_freight_id, em_obmfm_delivery_charges, em_obmfm_deliverynotes, em_prlab_desc, em_obwpack_packing, em_obwpack_packingh_id, em_obwpack_processed, em_obwpack_reactivated, em_obwpack_packingrequired, bpartner_extref, c_alternate_location_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 19 07 1 3s332ms 3s332ms [ User: tad - Total duration: 3s332ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 3s332ms - Times executed: 1 ]
-
COPY public.m_inout (m_inout_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docaction, docstatus, posted, processing, processed, c_doctype_id, description, c_order_id, dateordered, isprinted, movementtype, movementdate, dateacct, c_bpartner_id, c_bpartner_location_id, m_warehouse_id, poreference, deliveryrule, freightcostrule, freightamt, deliveryviarule, m_shipper_id, c_charge_id, chargeamt, priorityrule, dateprinted, c_invoice_id, createfrom, generateto, ad_user_id, salesrep_id, nopackages, pickdate, shipdate, trackingno, ad_orgtrx_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, updatelines, islogistic, calculate_freight, delivery_location_id, m_freightcategory_id, freight_currency_id, rm_receipt_pickedit, rm_shipment_pickedit, m_condition_goods_id, a_asset_id, c_costcenter_id, process_goods_java, em_lpy_controle_impressos_id, em_lpy_isfiscalserno, em_lpy_fiscalno, em_lpy_fiscalserno, isnettingshipment, iscompletelyinvoiced, invoicefromshipment, em_prpres_disable_trackerror, em_obmfm_freight_id, em_obmfm_delivery_charges, em_obmfm_deliverynotes, em_prlab_desc, em_obwpack_packing, em_obwpack_packingh_id, em_obwpack_processed, em_obwpack_reactivated, em_obwpack_packingrequired, bpartner_extref, c_alternate_location_id) TO stdout;
Date: 2026-07-19 07:02:55 Duration: 3s332ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 156 12m17s 3s989ms 8s669ms 4s730ms select * from ( select f.c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || f.documentno || ? as description, ? as isactive, f.ad_org_id, f.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, f.c_invoice_id, ?) as record_id from ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = ? and co.em_obpos_applications_id is not null group by ci.documentno, extract(year from dateinvoiced), ci.c_doctype_id having count(ci.documentno) > ? order by max(dateinvoiced) desc) as f) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 07 12 59s272ms 4s939ms 08 12 56s662ms 4s721ms 09 12 57s862ms 4s821ms 10 12 56s681ms 4s723ms 11 12 56s523ms 4s710ms 12 12 55s339ms 4s611ms 13 12 56s732ms 4s727ms 14 12 57s580ms 4s798ms 15 12 57s215ms 4s767ms 16 12 56s303ms 4s691ms 17 12 55s905ms 4s658ms 18 12 55s997ms 4s666ms 19 12 55s833ms 4s652ms [ User: tad - Total duration: 12m17s - Times executed: 156 ]
[ Application: openbravo - Total duration: 12m17s - Times executed: 156 ]
-
SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 07:00:08 Duration: 8s669ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 09:00:08 Duration: 8s201ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 14:00:07 Duration: 7s544ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 156 11m19s 3s804ms 6s47ms 4s356ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select f.c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || f.documentno || ? as description, ? as isactive, f.ad_org_id, f.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, f.c_invoice_id, ?) as record_id from ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = ? and co.em_obpos_applications_id is not null group by ci.documentno, extract(year from dateinvoiced), ci.c_doctype_id having count(ci.documentno) > ? order by max(dateinvoiced) desc) as f) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 07 12 55s823ms 4s651ms 08 12 52s83ms 4s340ms 09 12 50s793ms 4s232ms 10 12 52s992ms 4s416ms 11 12 50s941ms 4s245ms 12 12 52s655ms 4s387ms 13 12 51s126ms 4s260ms 14 12 53s955ms 4s496ms 15 12 52s796ms 4s399ms 16 12 50s74ms 4s172ms 17 12 50s895ms 4s241ms 18 12 54s111ms 4s509ms 19 12 51s399ms 4s283ms [ User: tad - Total duration: 11m19s - Times executed: 156 ]
[ Application: openbravo - Total duration: 11m19s - Times executed: 156 ]
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '463465B5BE664902A40F05E84E1587CD' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-19 12:00:11 Duration: 6s47ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '463465B5BE664902A40F05E84E1587CD' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-19 07:00:14 Duration: 5s941ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '463465B5BE664902A40F05E84E1587CD' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-19 07:05:10 Duration: 5s612ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 79 2m32s 1s639ms 4s651ms 1s929ms select distinct pprod.m_product_id, pprod.ps_product_id as baseprodid, ? as combinationid, pprod.stock_id, pprod.shop_id, coalesce(pprod.group_id, ?) as group_id, coalesce(pprod.out_of_stock, ?) as out_of_stock, coalesce(pprod.depends_on_stock, ?) as depends_on_stock from prpres_product pprod where pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_transaction left join prpres_product on m_transaction.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = ? and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_product.m_product_id is not null and m_product.isgeneric = ?) or pprod.prpres_product_id in ( select distinct (prpres_product_id) from prpres_product left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id left join m_product on prpres_product.m_product_id = m_product.m_product_id where prpres_conf.prpres_conf_id = ? and coalesce(prpres_product.inventory_date, prpres_product.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_product.m_product_id is not null and m_product.isgeneric = ?) or pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_reservation left join prpres_product on m_reservation.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = ? and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_product.m_product_id is not null and m_product.isgeneric = ?) union select distinct pcomb.m_product_id, pprod.ps_product_id as baseprodid, pcomb.ps_combination_id as combinationid, pcomb.stock_id, pcomb.shop_id, coalesce(pcomb.group_id, ?) as group_id, coalesce(pcomb.out_of_stock, ?) as out_of_stock, coalesce(pcomb.depends_on_stock, ?) as depends_on_stock from prpres_combination pcomb left join prpres_product pprod on pcomb.prpres_product_id = pprod.prpres_product_id where pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_transaction left join prpres_combination on m_transaction.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = ? and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_combination.m_product_id is not null and m_product.isgeneric = ?) or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from prpres_combination left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = ? and coalesce(prpres_combination.inventory_date, prpres_combination.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_combination.m_product_id is not null and m_product.isgeneric = ?) or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_reservation left join prpres_combination on m_reservation.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = ? and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_combination.m_product_id is not null and m_product.isgeneric = ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 07 6 11s863ms 1s977ms 08 6 11s930ms 1s988ms 09 6 13s943ms 2s323ms 10 6 10s959ms 1s826ms 11 6 11s440ms 1s906ms 12 6 11s263ms 1s877ms 13 6 11s134ms 1s855ms 14 6 11s91ms 1s848ms 15 6 11s44ms 1s840ms 16 6 11s446ms 1s907ms 17 6 11s220ms 1s870ms 18 6 11s595ms 1s932ms 19 6 10s894ms 1s815ms 20 1 2s612ms 2s612ms [ User: tad - Total duration: 2m32s - Times executed: 79 ]
[ Application: openbravo - Total duration: 2m32s - Times executed: 79 ]
-
select distinct pprod.m_product_id, pprod.ps_product_id as baseprodid, '0' as combinationid, pprod.stock_id, pprod.shop_id, coalesce(pprod.group_id, '0') as group_id, coalesce(pprod.out_of_stock, '2') as out_of_stock, coalesce(pprod.depends_on_stock, '0') as depends_on_stock from prpres_product pprod where pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_transaction left join prpres_product on m_transaction.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from prpres_product left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id left join m_product on prpres_product.m_product_id = m_product.m_product_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_product.inventory_date, prpres_product.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_reservation left join prpres_product on m_reservation.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') UNION select distinct pcomb.m_product_id, pprod.ps_product_id as baseprodid, pcomb.ps_combination_id as combinationid, pcomb.stock_id, pcomb.shop_id, coalesce(pcomb.group_id, '0') as group_id, coalesce(pcomb.out_of_stock, '2') as out_of_stock, coalesce(pcomb.depends_on_stock, '0') as depends_on_stock from prpres_combination pcomb left join prpres_product pprod on pcomb.prpres_product_id = pprod.prpres_product_id where pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_transaction left join prpres_combination on m_transaction.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from prpres_combination left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_combination.inventory_date, prpres_combination.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_reservation left join prpres_combination on m_reservation.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N');
Date: 2026-07-19 09:00:04 Duration: 4s651ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select distinct pprod.m_product_id, pprod.ps_product_id as baseprodid, '0' as combinationid, pprod.stock_id, pprod.shop_id, coalesce(pprod.group_id, '0') as group_id, coalesce(pprod.out_of_stock, '2') as out_of_stock, coalesce(pprod.depends_on_stock, '0') as depends_on_stock from prpres_product pprod where pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_transaction left join prpres_product on m_transaction.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from prpres_product left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id left join m_product on prpres_product.m_product_id = m_product.m_product_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_product.inventory_date, prpres_product.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_reservation left join prpres_product on m_reservation.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') UNION select distinct pcomb.m_product_id, pprod.ps_product_id as baseprodid, pcomb.ps_combination_id as combinationid, pcomb.stock_id, pcomb.shop_id, coalesce(pcomb.group_id, '0') as group_id, coalesce(pcomb.out_of_stock, '2') as out_of_stock, coalesce(pcomb.depends_on_stock, '0') as depends_on_stock from prpres_combination pcomb left join prpres_product pprod on pcomb.prpres_product_id = pprod.prpres_product_id where pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_transaction left join prpres_combination on m_transaction.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from prpres_combination left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_combination.inventory_date, prpres_combination.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_reservation left join prpres_combination on m_reservation.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N');
Date: 2026-07-19 07:00:03 Duration: 2s829ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select distinct pprod.m_product_id, pprod.ps_product_id as baseprodid, '0' as combinationid, pprod.stock_id, pprod.shop_id, coalesce(pprod.group_id, '0') as group_id, coalesce(pprod.out_of_stock, '2') as out_of_stock, coalesce(pprod.depends_on_stock, '0') as depends_on_stock from prpres_product pprod where pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_transaction left join prpres_product on m_transaction.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from prpres_product left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id left join m_product on prpres_product.m_product_id = m_product.m_product_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_product.inventory_date, prpres_product.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_reservation left join prpres_product on m_reservation.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') UNION select distinct pcomb.m_product_id, pprod.ps_product_id as baseprodid, pcomb.ps_combination_id as combinationid, pcomb.stock_id, pcomb.shop_id, coalesce(pcomb.group_id, '0') as group_id, coalesce(pcomb.out_of_stock, '2') as out_of_stock, coalesce(pcomb.depends_on_stock, '0') as depends_on_stock from prpres_combination pcomb left join prpres_product pprod on pcomb.prpres_product_id = pprod.prpres_product_id where pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_transaction left join prpres_combination on m_transaction.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from prpres_combination left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_combination.inventory_date, prpres_combination.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_reservation left join prpres_combination on m_reservation.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N');
Date: 2026-07-19 20:00:02 Duration: 2s612ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 14 22s136ms 1s262ms 2s241ms 1s581ms select profile.take_sample ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 19 07 1 1s835ms 1s835ms 08 1 1s724ms 1s724ms 09 1 2s241ms 2s241ms 10 1 1s262ms 1s262ms 11 1 1s606ms 1s606ms 12 1 1s321ms 1s321ms 13 1 1s292ms 1s292ms 14 1 1s499ms 1s499ms 15 1 1s398ms 1s398ms 16 1 1s542ms 1s542ms 17 1 1s566ms 1s566ms 18 1 1s356ms 1s356ms 19 1 1s313ms 1s313ms 20 1 2s174ms 2s174ms [ User: postgres - Total duration: 22s136ms - Times executed: 14 ]
[ Application: psql - Total duration: 22s136ms - Times executed: 14 ]
-
SELECT profile.take_sample ();
Date: 2026-07-19 09:00:04 Duration: 2s241ms Database: openbravo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-19 20:00:03 Duration: 2s174ms Database: openbravo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-19 07:00:03 Duration: 1s835ms Database: openbravo User: postgres Remote: [local] Application: psql
5 1 49s743ms 49s743ms 49s743ms 49s743ms copy public.ad_image (ad_image_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, name, imageurl, binarydata, width, height, mimetype) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 19 07 1 49s743ms 49s743ms [ User: tad - Total duration: 49s743ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 49s743ms - Times executed: 1 ]
-
COPY public.ad_image (ad_image_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, name, imageurl, binarydata, width, height, mimetype) TO stdout;
Date: 2026-07-19 07:00:56 Duration: 49s743ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
6 1 19s911ms 19s911ms 19s911ms 19s911ms copy public.c_orderline (c_orderline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_order_id, line, c_bpartner_id, c_bpartner_location_id, dateordered, datepromised, datedelivered, dateinvoiced, description, m_product_id, m_warehouse_id, directship, c_uom_id, qtyordered, qtyreserved, qtydelivered, qtyinvoiced, m_shipper_id, c_currency_id, pricelist, priceactual, pricelimit, linenetamt, discount, freightamt, c_charge_id, chargeamt, c_tax_id, s_resourceassignment_id, ref_orderline_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_offer_id, pricestd, cancelpricead, c_order_discount_id, iseditlinenetamt, taxbaseamt, m_inoutline_id, c_return_reason_id, gross_unit_price, line_gross_amount, grosspricelist, c_costcenter_id, grosspricestd, a_asset_id, m_warehouse_rule_id, user1_id, quotationline_id, user2_id, create_reservation, c_project_id, so_res_status, manage_reservation, manage_prereservation, explode, bom_parent_id, em_mntc_discount, print_description, overdue_return_days, relate_orderline, replacedorderline_id, c_aum, aumqty, returnline, em_obpos_epccode, em_obpos_serialnumber, em_obpos_isdeleted, em_obpos_service_proposed, em_obpos_qtydeleted, em_obpos_canbedelivered, em_obpos_ispaid, em_obpos_pricereason_id, em_obrdm_delivery_mode, em_obrdm_delivery_date, em_obrdm_delivery_time, em_obrdm_amttopayindelivery, em_obmfm_isfreightamt, em_obmfm_freight_definition_id, em_obwpl_readypl, salesrep_id, em_prpres_ps_line_id) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 19 07 1 19s911ms 19s911ms [ User: tad - Total duration: 19s911ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 19s911ms - Times executed: 1 ]
-
COPY public.c_orderline (c_orderline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_order_id, line, c_bpartner_id, c_bpartner_location_id, dateordered, datepromised, datedelivered, dateinvoiced, description, m_product_id, m_warehouse_id, directship, c_uom_id, qtyordered, qtyreserved, qtydelivered, qtyinvoiced, m_shipper_id, c_currency_id, pricelist, priceactual, pricelimit, linenetamt, discount, freightamt, c_charge_id, chargeamt, c_tax_id, s_resourceassignment_id, ref_orderline_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_offer_id, pricestd, cancelpricead, c_order_discount_id, iseditlinenetamt, taxbaseamt, m_inoutline_id, c_return_reason_id, gross_unit_price, line_gross_amount, grosspricelist, c_costcenter_id, grosspricestd, a_asset_id, m_warehouse_rule_id, user1_id, quotationline_id, user2_id, create_reservation, c_project_id, so_res_status, manage_reservation, manage_prereservation, explode, bom_parent_id, em_mntc_discount, print_description, overdue_return_days, relate_orderline, replacedorderline_id, c_aum, aumqty, returnline, em_obpos_epccode, em_obpos_serialnumber, em_obpos_isdeleted, em_obpos_service_proposed, em_obpos_qtydeleted, em_obpos_canbedelivered, em_obpos_ispaid, em_obpos_pricereason_id, em_obrdm_delivery_mode, em_obrdm_delivery_date, em_obrdm_delivery_time, em_obrdm_amttopayindelivery, em_obmfm_isfreightamt, em_obmfm_freight_definition_id, em_obwpl_readypl, salesrep_id, em_prpres_ps_line_id) TO stdout;
Date: 2026-07-19 07:02:07 Duration: 19s911ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
7 1 16s592ms 16s592ms 16s592ms 16s592ms copy public.c_invoiceline (c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoice_id, c_orderline_id, m_inoutline_id, line, description, financial_invoice_line, account_id, m_product_id, qtyinvoiced, pricelist, priceactual, pricelimit, linenetamt, c_charge_id, chargeamt, c_uom_id, c_tax_id, s_resourceassignment_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, c_invoice_discount_id, c_projectline_id, m_offer_id, pricestd, excludeforwithholding, iseditlinenetamt, taxbaseamt, line_gross_amount, gross_unit_price, c_bpartner_id, periodnumber, grosspricestd, a_asset_id, defplantype, grosspricelist, c_project_id, isdeferred, c_period_id, c_costcenter_id, user1_id, user2_id, explode, bom_parent_id, match_lccosts, c_aum, aumqty, salesrep_id) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 19 07 1 16s592ms 16s592ms [ User: tad - Total duration: 16s592ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 16s592ms - Times executed: 1 ]
-
COPY public.c_invoiceline (c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoice_id, c_orderline_id, m_inoutline_id, line, description, financial_invoice_line, account_id, m_product_id, qtyinvoiced, pricelist, priceactual, pricelimit, linenetamt, c_charge_id, chargeamt, c_uom_id, c_tax_id, s_resourceassignment_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, c_invoice_discount_id, c_projectline_id, m_offer_id, pricestd, excludeforwithholding, iseditlinenetamt, taxbaseamt, line_gross_amount, gross_unit_price, c_bpartner_id, periodnumber, grosspricestd, a_asset_id, defplantype, grosspricelist, c_project_id, isdeferred, c_period_id, c_costcenter_id, user1_id, user2_id, explode, bom_parent_id, match_lccosts, c_aum, aumqty, salesrep_id) TO stdout;
Date: 2026-07-19 07:01:23 Duration: 16s592ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
8 1 12s631ms 12s631ms 12s631ms 12s631ms copy public.m_transaction (m_transaction_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, movementtype, m_locator_id, m_product_id, movementdate, movementqty, m_inventoryline_id, m_movementline_id, m_inoutline_id, m_productionline_id, c_projectissue_id, m_attributesetinstance_id, m_product_uom_id, quantityorder, c_uom_id, m_internal_consumptionline_id, transactioncost, trxprocessdate, m_costing_algorithm_id, iscostcalculated, c_currency_id, costing_status, checkreservedqty, isprocessed, checkpricedifference, manualcostadjustment, iscostpermanent) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 19 07 1 12s631ms 12s631ms [ User: tad - Total duration: 12s631ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 12s631ms - Times executed: 1 ]
-
COPY public.m_transaction (m_transaction_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, movementtype, m_locator_id, m_product_id, movementdate, movementqty, m_inventoryline_id, m_movementline_id, m_inoutline_id, m_productionline_id, c_projectissue_id, m_attributesetinstance_id, m_product_uom_id, quantityorder, c_uom_id, m_internal_consumptionline_id, transactioncost, trxprocessdate, m_costing_algorithm_id, iscostcalculated, c_currency_id, costing_status, checkreservedqty, isprocessed, checkpricedifference, manualcostadjustment, iscostpermanent) TO stdout;
Date: 2026-07-19 07:03:23 Duration: 12s631ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
9 1 12s135ms 12s135ms 12s135ms 12s135ms copy public.m_inoutline (m_inoutline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, line, description, m_inout_id, c_orderline_id, m_locator_id, m_product_id, c_uom_id, movementqty, isinvoiced, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_condition_goods_id, canceled_inoutline_id, a_asset_id, manage_prereservation, user1_id, user2_id, c_project_id, c_costcenter_id, c_bpartner_id, explode, bom_parent_id, c_aum, aumqty, em_obwpl_pickinglist_id, em_obwpl_editlines_pe, em_obwpl_removeline, em_prpp_qtyverified, salesrep_id) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 19 07 1 12s135ms 12s135ms [ User: tad - Total duration: 12s135ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 12s135ms - Times executed: 1 ]
-
COPY public.m_inoutline (m_inoutline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, line, description, m_inout_id, c_orderline_id, m_locator_id, m_product_id, c_uom_id, movementqty, isinvoiced, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_condition_goods_id, canceled_inoutline_id, a_asset_id, manage_prereservation, user1_id, user2_id, c_project_id, c_costcenter_id, c_bpartner_id, explode, bom_parent_id, c_aum, aumqty, em_obwpl_pickinglist_id, em_obwpl_editlines_pe, em_obwpl_removeline, em_prpp_qtyverified, salesrep_id) TO stdout;
Date: 2026-07-19 07:03:08 Duration: 12s135ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
10 1 11s293ms 11s293ms 11s293ms 11s293ms copy public.c_orderlinetax (c_orderlinetax_id, c_orderline_id, c_tax_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, c_order_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 19 07 1 11s293ms 11s293ms [ User: tad - Total duration: 11s293ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 11s293ms - Times executed: 1 ]
-
COPY public.c_orderlinetax (c_orderlinetax_id, c_orderline_id, c_tax_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, c_order_id) TO stdout;
Date: 2026-07-19 07:02:27 Duration: 11s293ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
11 1 9s36ms 9s36ms 9s36ms 9s36ms copy public.c_orderline_offer (c_orderline_offer_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_orderline_id, line, m_offer_id, priceoffer, amtoffer, priceoffergross, totalamt, displayedtotalamt, em_obdisc_qtyoffer, em_obdisc_identifier, em_obpos_discountinstance, em_obpos_extraproperties) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 19 07 1 9s36ms 9s36ms [ User: tad - Total duration: 9s36ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s36ms - Times executed: 1 ]
-
COPY public.c_orderline_offer (c_orderline_offer_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_orderline_id, line, m_offer_id, priceoffer, amtoffer, priceoffergross, totalamt, displayedtotalamt, em_obdisc_qtyoffer, em_obdisc_identifier, em_obpos_discountinstance, em_obpos_extraproperties) TO stdout;
Date: 2026-07-19 07:02:16 Duration: 9s36ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
12 1 8s502ms 8s502ms 8s502ms 8s502ms copy public.c_invoicelinetax (c_invoicelinetax_id, c_tax_id, c_invoice_id, c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, recalculate) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 19 07 1 8s502ms 8s502ms [ User: tad - Total duration: 8s502ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s502ms - Times executed: 1 ]
-
COPY public.c_invoicelinetax (c_invoicelinetax_id, c_tax_id, c_invoice_id, c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, recalculate) TO stdout;
Date: 2026-07-19 07:01:38 Duration: 8s502ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
13 1 6s524ms 6s524ms 6s524ms 6s524ms copy public.c_invoiceline_offer (c_invoiceline_offer_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoiceline_id, line, m_offer_id, priceoffer, amtoffer, priceoffergross, totalamt, displayedtotalamt, em_obdisc_qtyoffer) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 19 07 1 6s524ms 6s524ms [ User: tad - Total duration: 6s524ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 6s524ms - Times executed: 1 ]
-
COPY public.c_invoiceline_offer (c_invoiceline_offer_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoiceline_id, line, m_offer_id, priceoffer, amtoffer, priceoffergross, totalamt, displayedtotalamt, em_obdisc_qtyoffer) TO stdout;
Date: 2026-07-19 07:01:30 Duration: 6s524ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
14 1 5s936ms 5s936ms 5s936ms 5s936ms copy public.c_order (c_order_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processing, processed, c_doctype_id, c_doctypetarget_id, description, isdelivered, isinvoiced, isprinted, isselected, salesrep_id, dateordered, datepromised, dateprinted, dateacct, c_bpartner_id, billto_id, c_bpartner_location_id, poreference, isdiscountprinted, c_currency_id, paymentrule, c_paymentterm_id, invoicerule, deliveryrule, freightcostrule, freightamt, deliveryviarule, m_shipper_id, c_charge_id, chargeamt, priorityrule, totallines, grandtotal, m_warehouse_id, m_pricelist_id, istaxincluded, c_campaign_id, c_project_id, c_activity_id, posted, ad_user_id, copyfrom, dropship_bpartner_id, dropship_location_id, dropship_user_id, isselfservice, ad_orgtrx_id, user1_id, user2_id, deliverynotes, c_incoterms_id, incotermsdescription, generatetemplate, delivery_location_id, copyfrompo, fin_paymentmethod_id, fin_payment_priority_id, rm_pickfromshipment, rm_receivematerials, rm_createinvoice, c_return_reason_id, rm_addorphanline, a_asset_id, calculate_promotions, c_costcenter_id, convertquotation, c_reject_reason_id, validuntil, quotation_id, so_res_status, create_polines, iscashvat, rm_pickfromreceipt, em_opxmm_btn_purch, em_obdisc_addpack, em_obpos_applications_id, em_obpos_sendemail, em_obpos_email_status, cancelandreplace, confirmcancelandreplace, cancelledorder_id, replacedorder_id, iscancelled, replacementorder_id, em_aprm_addpayment, em_obpos_app_cashup_id, em_obpos_createdabsolute, em_obpos_notinvoiceoncashup, em_obpos_rejected_quotat_id, em_obpos_isdeleted, em_obpos_islayaway, em_obpos_prepaymentamt, em_obpos_prepaymentlimitamt, em_obpos_prepaymentlaylimitamt, em_prpres_reference, em_prpres_void_order, em_prpres_gross_total, em_prpres_net_total, em_prpres_isgift, em_prpres_giftmessage, em_prpres_id_cart, em_prpres_id_paym_transaction, em_obmfm_selectfreight, em_obmfm_delivery_period_id, em_obmfm_delivery_charges, em_obmfm_freight_id, em_obmfm_weight, em_obmfm_weight_uom_id, em_obmfm_set_weight, em_obwpl_generatepicking, em_obwpl_isinpickinglist, em_obwpl_readypl, em_prpp_generatepicking, em_mntc_createinvoice, bpartner_extref, c_alternate_location_id, em_prpres_processing, em_prpres_generatepicking, em_obpos_rounding_amount, em_obpos_sequencename, em_obpos_sequencenumber, em_obpos_skip_tax_calculation) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 19 07 1 5s936ms 5s936ms [ User: tad - Total duration: 5s936ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 5s936ms - Times executed: 1 ]
-
COPY public.c_order (c_order_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processing, processed, c_doctype_id, c_doctypetarget_id, description, isdelivered, isinvoiced, isprinted, isselected, salesrep_id, dateordered, datepromised, dateprinted, dateacct, c_bpartner_id, billto_id, c_bpartner_location_id, poreference, isdiscountprinted, c_currency_id, paymentrule, c_paymentterm_id, invoicerule, deliveryrule, freightcostrule, freightamt, deliveryviarule, m_shipper_id, c_charge_id, chargeamt, priorityrule, totallines, grandtotal, m_warehouse_id, m_pricelist_id, istaxincluded, c_campaign_id, c_project_id, c_activity_id, posted, ad_user_id, copyfrom, dropship_bpartner_id, dropship_location_id, dropship_user_id, isselfservice, ad_orgtrx_id, user1_id, user2_id, deliverynotes, c_incoterms_id, incotermsdescription, generatetemplate, delivery_location_id, copyfrompo, fin_paymentmethod_id, fin_payment_priority_id, rm_pickfromshipment, rm_receivematerials, rm_createinvoice, c_return_reason_id, rm_addorphanline, a_asset_id, calculate_promotions, c_costcenter_id, convertquotation, c_reject_reason_id, validuntil, quotation_id, so_res_status, create_polines, iscashvat, rm_pickfromreceipt, em_opxmm_btn_purch, em_obdisc_addpack, em_obpos_applications_id, em_obpos_sendemail, em_obpos_email_status, cancelandreplace, confirmcancelandreplace, cancelledorder_id, replacedorder_id, iscancelled, replacementorder_id, em_aprm_addpayment, em_obpos_app_cashup_id, em_obpos_createdabsolute, em_obpos_notinvoiceoncashup, em_obpos_rejected_quotat_id, em_obpos_isdeleted, em_obpos_islayaway, em_obpos_prepaymentamt, em_obpos_prepaymentlimitamt, em_obpos_prepaymentlaylimitamt, em_prpres_reference, em_prpres_void_order, em_prpres_gross_total, em_prpres_net_total, em_prpres_isgift, em_prpres_giftmessage, em_prpres_id_cart, em_prpres_id_paym_transaction, em_obmfm_selectfreight, em_obmfm_delivery_period_id, em_obmfm_delivery_charges, em_obmfm_freight_id, em_obmfm_weight, em_obmfm_weight_uom_id, em_obmfm_set_weight, em_obwpl_generatepicking, em_obwpl_isinpickinglist, em_obwpl_readypl, em_prpp_generatepicking, em_mntc_createinvoice, bpartner_extref, c_alternate_location_id, em_prpres_processing, em_prpres_generatepicking, em_obpos_rounding_amount, em_obpos_sequencename, em_obpos_sequencenumber, em_obpos_skip_tax_calculation) TO stdout;
Date: 2026-07-19 07:01:47 Duration: 5s936ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
15 1 5s459ms 5s459ms 5s459ms 5s459ms copy public.fin_payment_schedule (fin_payment_schedule_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, c_invoice_id, c_order_id, duedate, fin_paymentmethod_id, c_currency_id, amount, paidamt, outstandingamt, isactive, fin_payment_priority_id, update_payment_plan, origduedate, description, expecteddate, em_kctrp_isretention_payment, em_aprm_modif_paym_sched, em_aprm_modif_paym_out_sched) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 19 07 1 5s459ms 5s459ms [ User: tad - Total duration: 5s459ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 5s459ms - Times executed: 1 ]
-
COPY public.fin_payment_schedule (fin_payment_schedule_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, c_invoice_id, c_order_id, duedate, fin_paymentmethod_id, c_currency_id, amount, paidamt, outstandingamt, isactive, fin_payment_priority_id, update_payment_plan, origduedate, description, expecteddate, em_kctrp_isretention_payment, em_aprm_modif_paym_sched, em_aprm_modif_paym_out_sched) TO stdout;
Date: 2026-07-19 07:02:48 Duration: 5s459ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
16 1 4s947ms 4s947ms 4s947ms 4s947ms copy public.c_invoice (c_invoice_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processing, processed, posted, c_doctype_id, c_doctypetarget_id, c_order_id, description, isprinted, salesrep_id, dateinvoiced, dateprinted, dateacct, c_bpartner_id, c_bpartner_location_id, poreference, isdiscountprinted, dateordered, c_currency_id, c_paymentterm_id, c_charge_id, chargeamt, totallines, grandtotal, m_pricelist_id, istaxincluded, c_campaign_id, c_project_id, c_activity_id, createfrom, generateto, ad_user_id, copyfrom, isselfservice, ad_orgtrx_id, user1_id, user2_id, withholdingamount, taxdate, c_withholding_id, ispaid, totalpaid, outstandingamt, daystilldue, dueamt, lastcalculatedondate, fin_paymentmethod_id, fin_payment_priority_id, finalsettlement, daysoutstanding, percentageoverdue, c_costcenter_id, calculate_promotions, a_asset_id, iscashvat, em_lpy_controle_impressos_id, em_lpy_isfiscalserno, em_lpy_fiscalno, em_lpy_fiscalserno, em_kctrp_isretention_payment, em_kctrp_retention_grossamt_id, em_aprm_addpayment, em_aprm_processinvoice, prepaymentamt, createfromorders, createfrominouts, paidamtatinvoicing, bpartner_extref, c_alternate_location_id, einvoice_status, einvoice_generated, einvoice_externalid, einvoice_send_status, einvoice_sent, em_obpos_rounding_amount, em_obpos_sequencename, em_obpos_sequencenumber, em_mntc_invoice_format) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 19 07 1 4s947ms 4s947ms [ User: tad - Total duration: 4s947ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4s947ms - Times executed: 1 ]
-
COPY public.c_invoice (c_invoice_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processing, processed, posted, c_doctype_id, c_doctypetarget_id, c_order_id, description, isprinted, salesrep_id, dateinvoiced, dateprinted, dateacct, c_bpartner_id, c_bpartner_location_id, poreference, isdiscountprinted, dateordered, c_currency_id, c_paymentterm_id, c_charge_id, chargeamt, totallines, grandtotal, m_pricelist_id, istaxincluded, c_campaign_id, c_project_id, c_activity_id, createfrom, generateto, ad_user_id, copyfrom, isselfservice, ad_orgtrx_id, user1_id, user2_id, withholdingamount, taxdate, c_withholding_id, ispaid, totalpaid, outstandingamt, daystilldue, dueamt, lastcalculatedondate, fin_paymentmethod_id, fin_payment_priority_id, finalsettlement, daysoutstanding, percentageoverdue, c_costcenter_id, calculate_promotions, a_asset_id, iscashvat, em_lpy_controle_impressos_id, em_lpy_isfiscalserno, em_lpy_fiscalno, em_lpy_fiscalserno, em_kctrp_isretention_payment, em_kctrp_retention_grossamt_id, em_aprm_addpayment, em_aprm_processinvoice, prepaymentamt, createfromorders, createfrominouts, paidamtatinvoicing, bpartner_extref, c_alternate_location_id, einvoice_status, einvoice_generated, einvoice_externalid, einvoice_send_status, einvoice_sent, em_obpos_rounding_amount, em_obpos_sequencename, em_obpos_sequencenumber, em_mntc_invoice_format) TO stdout;
Date: 2026-07-19 07:01:06 Duration: 4s947ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
17 1 3s787ms 3s787ms 3s787ms 3s787ms copy public.fin_finacc_transaction (fin_finacc_transaction_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, isactive, c_currency_id, fin_financial_account_id, line, fin_payment_id, dateacct, c_glitem_id, status, paymentamt, depositamt, processed, processing, posted, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, trxtype, statementdate, description, fin_reconciliation_id, createdbyalgorithm, foreign_currency_id, foreign_convert_rate, foreign_amount, c_bpartner_id, m_product_id, c_salesregion_id, c_costcenter_id, em_aprm_processed, em_aprm_finacc_trans_origin, em_obpos_app_cashup_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 19 07 1 3s787ms 3s787ms [ User: tad - Total duration: 3s787ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 3s787ms - Times executed: 1 ]
-
COPY public.fin_finacc_transaction (fin_finacc_transaction_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, isactive, c_currency_id, fin_financial_account_id, line, fin_payment_id, dateacct, c_glitem_id, status, paymentamt, depositamt, processed, processing, posted, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, trxtype, statementdate, description, fin_reconciliation_id, createdbyalgorithm, foreign_currency_id, foreign_convert_rate, foreign_amount, c_bpartner_id, m_product_id, c_salesregion_id, c_costcenter_id, em_aprm_processed, em_aprm_finacc_trans_origin, em_obpos_app_cashup_id) TO stdout;
Date: 2026-07-19 07:02:34 Duration: 3s787ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
18 1 3s579ms 3s579ms 3s579ms 3s579ms copy public.fin_payment_scheduledetail (fin_payment_scheduledetail_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, fin_payment_detail_id, fin_payment_schedule_order, fin_payment_schedule_invoice, amount, isactive, writeoffamt, iscanceled, c_bpartner_id, c_activity_id, m_product_id, c_campaign_id, c_project_id, c_salesregion_id, c_costcenter_id, user1_id, user2_id, doubtfuldebt_amount, isinvoicepaid) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 19 07 1 3s579ms 3s579ms [ User: tad - Total duration: 3s579ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 3s579ms - Times executed: 1 ]
-
COPY public.fin_payment_scheduledetail (fin_payment_scheduledetail_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, fin_payment_detail_id, fin_payment_schedule_order, fin_payment_schedule_invoice, amount, isactive, writeoffamt, iscanceled, c_bpartner_id, c_activity_id, m_product_id, c_campaign_id, c_project_id, c_salesregion_id, c_costcenter_id, user1_id, user2_id, doubtfuldebt_amount, isinvoicepaid) TO stdout;
Date: 2026-07-19 07:02:52 Duration: 3s579ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
19 1 3s341ms 3s341ms 3s341ms 3s341ms copy public.fin_payment (fin_payment_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, isactive, isreceipt, c_bpartner_id, paymentdate, c_currency_id, amount, writeoffamt, fin_paymentmethod_id, documentno, referenceno, status, processed, processing, posted, description, fin_financial_account_id, c_doctype_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, generated_credit, used_credit, createdbyalgorithm, finacc_txn_convert_rate, finacc_txn_amount, fin_rev_payment_id, c_costcenter_id, em_kctrp_isretention_payment, em_kctrp_c_tax_id, em_kctrp_isretention_applied, em_kctrp_c_invoice_id, em_aprm_process_payment, em_aprm_reconcile_payment, em_aprm_add_scheduledpayments, em_aprm_executepayment, em_aprm_reversepayment, em_obpos_paymentdata, em_obpos_app_cashup_id, em_obpos_applications_id, em_obpos_rounded_payment_id, em_obpos_txtransaction, em_obpos_txauthorization, em_obpos_txcreditcardnummasked) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 19 07 1 3s341ms 3s341ms [ User: tad - Total duration: 3s341ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 3s341ms - Times executed: 1 ]
-
COPY public.fin_payment (fin_payment_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, isactive, isreceipt, c_bpartner_id, paymentdate, c_currency_id, amount, writeoffamt, fin_paymentmethod_id, documentno, referenceno, status, processed, processing, posted, description, fin_financial_account_id, c_doctype_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, generated_credit, used_credit, createdbyalgorithm, finacc_txn_convert_rate, finacc_txn_amount, fin_rev_payment_id, c_costcenter_id, em_kctrp_isretention_payment, em_kctrp_c_tax_id, em_kctrp_isretention_applied, em_kctrp_c_invoice_id, em_aprm_process_payment, em_aprm_reconcile_payment, em_aprm_add_scheduledpayments, em_aprm_executepayment, em_aprm_reversepayment, em_obpos_paymentdata, em_obpos_app_cashup_id, em_obpos_applications_id, em_obpos_rounded_payment_id, em_obpos_txtransaction, em_obpos_txauthorization, em_obpos_txcreditcardnummasked) TO stdout;
Date: 2026-07-19 07:02:40 Duration: 3s341ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
20 1 3s332ms 3s332ms 3s332ms 3s332ms copy public.m_inout (m_inout_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docaction, docstatus, posted, processing, processed, c_doctype_id, description, c_order_id, dateordered, isprinted, movementtype, movementdate, dateacct, c_bpartner_id, c_bpartner_location_id, m_warehouse_id, poreference, deliveryrule, freightcostrule, freightamt, deliveryviarule, m_shipper_id, c_charge_id, chargeamt, priorityrule, dateprinted, c_invoice_id, createfrom, generateto, ad_user_id, salesrep_id, nopackages, pickdate, shipdate, trackingno, ad_orgtrx_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, updatelines, islogistic, calculate_freight, delivery_location_id, m_freightcategory_id, freight_currency_id, rm_receipt_pickedit, rm_shipment_pickedit, m_condition_goods_id, a_asset_id, c_costcenter_id, process_goods_java, em_lpy_controle_impressos_id, em_lpy_isfiscalserno, em_lpy_fiscalno, em_lpy_fiscalserno, isnettingshipment, iscompletelyinvoiced, invoicefromshipment, em_prpres_disable_trackerror, em_obmfm_freight_id, em_obmfm_delivery_charges, em_obmfm_deliverynotes, em_prlab_desc, em_obwpack_packing, em_obwpack_packingh_id, em_obwpack_processed, em_obwpack_reactivated, em_obwpack_packingrequired, bpartner_extref, c_alternate_location_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 19 07 1 3s332ms 3s332ms [ User: tad - Total duration: 3s332ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 3s332ms - Times executed: 1 ]
-
COPY public.m_inout (m_inout_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docaction, docstatus, posted, processing, processed, c_doctype_id, description, c_order_id, dateordered, isprinted, movementtype, movementdate, dateacct, c_bpartner_id, c_bpartner_location_id, m_warehouse_id, poreference, deliveryrule, freightcostrule, freightamt, deliveryviarule, m_shipper_id, c_charge_id, chargeamt, priorityrule, dateprinted, c_invoice_id, createfrom, generateto, ad_user_id, salesrep_id, nopackages, pickdate, shipdate, trackingno, ad_orgtrx_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, updatelines, islogistic, calculate_freight, delivery_location_id, m_freightcategory_id, freight_currency_id, rm_receipt_pickedit, rm_shipment_pickedit, m_condition_goods_id, a_asset_id, c_costcenter_id, process_goods_java, em_lpy_controle_impressos_id, em_lpy_isfiscalserno, em_lpy_fiscalno, em_lpy_fiscalserno, isnettingshipment, iscompletelyinvoiced, invoicefromshipment, em_prpres_disable_trackerror, em_obmfm_freight_id, em_obmfm_delivery_charges, em_obmfm_deliverynotes, em_prlab_desc, em_obwpack_packing, em_obwpack_packingh_id, em_obwpack_processed, em_obwpack_reactivated, em_obwpack_packingrequired, bpartner_extref, c_alternate_location_id) TO stdout;
Date: 2026-07-19 07:02:55 Duration: 3s332ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 49s743ms 49s743ms 49s743ms 1 49s743ms copy public.ad_image (ad_image_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, name, imageurl, binarydata, width, height, mimetype) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 07 1 49s743ms 49s743ms [ User: tad - Total duration: 49s743ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 49s743ms - Times executed: 1 ]
-
COPY public.ad_image (ad_image_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, name, imageurl, binarydata, width, height, mimetype) TO stdout;
Date: 2026-07-19 07:00:56 Duration: 49s743ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
2 19s911ms 19s911ms 19s911ms 1 19s911ms copy public.c_orderline (c_orderline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_order_id, line, c_bpartner_id, c_bpartner_location_id, dateordered, datepromised, datedelivered, dateinvoiced, description, m_product_id, m_warehouse_id, directship, c_uom_id, qtyordered, qtyreserved, qtydelivered, qtyinvoiced, m_shipper_id, c_currency_id, pricelist, priceactual, pricelimit, linenetamt, discount, freightamt, c_charge_id, chargeamt, c_tax_id, s_resourceassignment_id, ref_orderline_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_offer_id, pricestd, cancelpricead, c_order_discount_id, iseditlinenetamt, taxbaseamt, m_inoutline_id, c_return_reason_id, gross_unit_price, line_gross_amount, grosspricelist, c_costcenter_id, grosspricestd, a_asset_id, m_warehouse_rule_id, user1_id, quotationline_id, user2_id, create_reservation, c_project_id, so_res_status, manage_reservation, manage_prereservation, explode, bom_parent_id, em_mntc_discount, print_description, overdue_return_days, relate_orderline, replacedorderline_id, c_aum, aumqty, returnline, em_obpos_epccode, em_obpos_serialnumber, em_obpos_isdeleted, em_obpos_service_proposed, em_obpos_qtydeleted, em_obpos_canbedelivered, em_obpos_ispaid, em_obpos_pricereason_id, em_obrdm_delivery_mode, em_obrdm_delivery_date, em_obrdm_delivery_time, em_obrdm_amttopayindelivery, em_obmfm_isfreightamt, em_obmfm_freight_definition_id, em_obwpl_readypl, salesrep_id, em_prpres_ps_line_id) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 07 1 19s911ms 19s911ms [ User: tad - Total duration: 19s911ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 19s911ms - Times executed: 1 ]
-
COPY public.c_orderline (c_orderline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_order_id, line, c_bpartner_id, c_bpartner_location_id, dateordered, datepromised, datedelivered, dateinvoiced, description, m_product_id, m_warehouse_id, directship, c_uom_id, qtyordered, qtyreserved, qtydelivered, qtyinvoiced, m_shipper_id, c_currency_id, pricelist, priceactual, pricelimit, linenetamt, discount, freightamt, c_charge_id, chargeamt, c_tax_id, s_resourceassignment_id, ref_orderline_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_offer_id, pricestd, cancelpricead, c_order_discount_id, iseditlinenetamt, taxbaseamt, m_inoutline_id, c_return_reason_id, gross_unit_price, line_gross_amount, grosspricelist, c_costcenter_id, grosspricestd, a_asset_id, m_warehouse_rule_id, user1_id, quotationline_id, user2_id, create_reservation, c_project_id, so_res_status, manage_reservation, manage_prereservation, explode, bom_parent_id, em_mntc_discount, print_description, overdue_return_days, relate_orderline, replacedorderline_id, c_aum, aumqty, returnline, em_obpos_epccode, em_obpos_serialnumber, em_obpos_isdeleted, em_obpos_service_proposed, em_obpos_qtydeleted, em_obpos_canbedelivered, em_obpos_ispaid, em_obpos_pricereason_id, em_obrdm_delivery_mode, em_obrdm_delivery_date, em_obrdm_delivery_time, em_obrdm_amttopayindelivery, em_obmfm_isfreightamt, em_obmfm_freight_definition_id, em_obwpl_readypl, salesrep_id, em_prpres_ps_line_id) TO stdout;
Date: 2026-07-19 07:02:07 Duration: 19s911ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
3 16s592ms 16s592ms 16s592ms 1 16s592ms copy public.c_invoiceline (c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoice_id, c_orderline_id, m_inoutline_id, line, description, financial_invoice_line, account_id, m_product_id, qtyinvoiced, pricelist, priceactual, pricelimit, linenetamt, c_charge_id, chargeamt, c_uom_id, c_tax_id, s_resourceassignment_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, c_invoice_discount_id, c_projectline_id, m_offer_id, pricestd, excludeforwithholding, iseditlinenetamt, taxbaseamt, line_gross_amount, gross_unit_price, c_bpartner_id, periodnumber, grosspricestd, a_asset_id, defplantype, grosspricelist, c_project_id, isdeferred, c_period_id, c_costcenter_id, user1_id, user2_id, explode, bom_parent_id, match_lccosts, c_aum, aumqty, salesrep_id) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 07 1 16s592ms 16s592ms [ User: tad - Total duration: 16s592ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 16s592ms - Times executed: 1 ]
-
COPY public.c_invoiceline (c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoice_id, c_orderline_id, m_inoutline_id, line, description, financial_invoice_line, account_id, m_product_id, qtyinvoiced, pricelist, priceactual, pricelimit, linenetamt, c_charge_id, chargeamt, c_uom_id, c_tax_id, s_resourceassignment_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, c_invoice_discount_id, c_projectline_id, m_offer_id, pricestd, excludeforwithholding, iseditlinenetamt, taxbaseamt, line_gross_amount, gross_unit_price, c_bpartner_id, periodnumber, grosspricestd, a_asset_id, defplantype, grosspricelist, c_project_id, isdeferred, c_period_id, c_costcenter_id, user1_id, user2_id, explode, bom_parent_id, match_lccosts, c_aum, aumqty, salesrep_id) TO stdout;
Date: 2026-07-19 07:01:23 Duration: 16s592ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
4 12s631ms 12s631ms 12s631ms 1 12s631ms copy public.m_transaction (m_transaction_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, movementtype, m_locator_id, m_product_id, movementdate, movementqty, m_inventoryline_id, m_movementline_id, m_inoutline_id, m_productionline_id, c_projectissue_id, m_attributesetinstance_id, m_product_uom_id, quantityorder, c_uom_id, m_internal_consumptionline_id, transactioncost, trxprocessdate, m_costing_algorithm_id, iscostcalculated, c_currency_id, costing_status, checkreservedqty, isprocessed, checkpricedifference, manualcostadjustment, iscostpermanent) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 19 07 1 12s631ms 12s631ms [ User: tad - Total duration: 12s631ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 12s631ms - Times executed: 1 ]
-
COPY public.m_transaction (m_transaction_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, movementtype, m_locator_id, m_product_id, movementdate, movementqty, m_inventoryline_id, m_movementline_id, m_inoutline_id, m_productionline_id, c_projectissue_id, m_attributesetinstance_id, m_product_uom_id, quantityorder, c_uom_id, m_internal_consumptionline_id, transactioncost, trxprocessdate, m_costing_algorithm_id, iscostcalculated, c_currency_id, costing_status, checkreservedqty, isprocessed, checkpricedifference, manualcostadjustment, iscostpermanent) TO stdout;
Date: 2026-07-19 07:03:23 Duration: 12s631ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
5 12s135ms 12s135ms 12s135ms 1 12s135ms copy public.m_inoutline (m_inoutline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, line, description, m_inout_id, c_orderline_id, m_locator_id, m_product_id, c_uom_id, movementqty, isinvoiced, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_condition_goods_id, canceled_inoutline_id, a_asset_id, manage_prereservation, user1_id, user2_id, c_project_id, c_costcenter_id, c_bpartner_id, explode, bom_parent_id, c_aum, aumqty, em_obwpl_pickinglist_id, em_obwpl_editlines_pe, em_obwpl_removeline, em_prpp_qtyverified, salesrep_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 19 07 1 12s135ms 12s135ms [ User: tad - Total duration: 12s135ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 12s135ms - Times executed: 1 ]
-
COPY public.m_inoutline (m_inoutline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, line, description, m_inout_id, c_orderline_id, m_locator_id, m_product_id, c_uom_id, movementqty, isinvoiced, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_condition_goods_id, canceled_inoutline_id, a_asset_id, manage_prereservation, user1_id, user2_id, c_project_id, c_costcenter_id, c_bpartner_id, explode, bom_parent_id, c_aum, aumqty, em_obwpl_pickinglist_id, em_obwpl_editlines_pe, em_obwpl_removeline, em_prpp_qtyverified, salesrep_id) TO stdout;
Date: 2026-07-19 07:03:08 Duration: 12s135ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
6 11s293ms 11s293ms 11s293ms 1 11s293ms copy public.c_orderlinetax (c_orderlinetax_id, c_orderline_id, c_tax_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, c_order_id) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 19 07 1 11s293ms 11s293ms [ User: tad - Total duration: 11s293ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 11s293ms - Times executed: 1 ]
-
COPY public.c_orderlinetax (c_orderlinetax_id, c_orderline_id, c_tax_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, c_order_id) TO stdout;
Date: 2026-07-19 07:02:27 Duration: 11s293ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
7 9s36ms 9s36ms 9s36ms 1 9s36ms copy public.c_orderline_offer (c_orderline_offer_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_orderline_id, line, m_offer_id, priceoffer, amtoffer, priceoffergross, totalamt, displayedtotalamt, em_obdisc_qtyoffer, em_obdisc_identifier, em_obpos_discountinstance, em_obpos_extraproperties) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 19 07 1 9s36ms 9s36ms [ User: tad - Total duration: 9s36ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s36ms - Times executed: 1 ]
-
COPY public.c_orderline_offer (c_orderline_offer_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_orderline_id, line, m_offer_id, priceoffer, amtoffer, priceoffergross, totalamt, displayedtotalamt, em_obdisc_qtyoffer, em_obdisc_identifier, em_obpos_discountinstance, em_obpos_extraproperties) TO stdout;
Date: 2026-07-19 07:02:16 Duration: 9s36ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
8 8s502ms 8s502ms 8s502ms 1 8s502ms copy public.c_invoicelinetax (c_invoicelinetax_id, c_tax_id, c_invoice_id, c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, recalculate) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 19 07 1 8s502ms 8s502ms [ User: tad - Total duration: 8s502ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s502ms - Times executed: 1 ]
-
COPY public.c_invoicelinetax (c_invoicelinetax_id, c_tax_id, c_invoice_id, c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, recalculate) TO stdout;
Date: 2026-07-19 07:01:38 Duration: 8s502ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
9 6s524ms 6s524ms 6s524ms 1 6s524ms copy public.c_invoiceline_offer (c_invoiceline_offer_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoiceline_id, line, m_offer_id, priceoffer, amtoffer, priceoffergross, totalamt, displayedtotalamt, em_obdisc_qtyoffer) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 19 07 1 6s524ms 6s524ms [ User: tad - Total duration: 6s524ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 6s524ms - Times executed: 1 ]
-
COPY public.c_invoiceline_offer (c_invoiceline_offer_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoiceline_id, line, m_offer_id, priceoffer, amtoffer, priceoffergross, totalamt, displayedtotalamt, em_obdisc_qtyoffer) TO stdout;
Date: 2026-07-19 07:01:30 Duration: 6s524ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
10 5s936ms 5s936ms 5s936ms 1 5s936ms copy public.c_order (c_order_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processing, processed, c_doctype_id, c_doctypetarget_id, description, isdelivered, isinvoiced, isprinted, isselected, salesrep_id, dateordered, datepromised, dateprinted, dateacct, c_bpartner_id, billto_id, c_bpartner_location_id, poreference, isdiscountprinted, c_currency_id, paymentrule, c_paymentterm_id, invoicerule, deliveryrule, freightcostrule, freightamt, deliveryviarule, m_shipper_id, c_charge_id, chargeamt, priorityrule, totallines, grandtotal, m_warehouse_id, m_pricelist_id, istaxincluded, c_campaign_id, c_project_id, c_activity_id, posted, ad_user_id, copyfrom, dropship_bpartner_id, dropship_location_id, dropship_user_id, isselfservice, ad_orgtrx_id, user1_id, user2_id, deliverynotes, c_incoterms_id, incotermsdescription, generatetemplate, delivery_location_id, copyfrompo, fin_paymentmethod_id, fin_payment_priority_id, rm_pickfromshipment, rm_receivematerials, rm_createinvoice, c_return_reason_id, rm_addorphanline, a_asset_id, calculate_promotions, c_costcenter_id, convertquotation, c_reject_reason_id, validuntil, quotation_id, so_res_status, create_polines, iscashvat, rm_pickfromreceipt, em_opxmm_btn_purch, em_obdisc_addpack, em_obpos_applications_id, em_obpos_sendemail, em_obpos_email_status, cancelandreplace, confirmcancelandreplace, cancelledorder_id, replacedorder_id, iscancelled, replacementorder_id, em_aprm_addpayment, em_obpos_app_cashup_id, em_obpos_createdabsolute, em_obpos_notinvoiceoncashup, em_obpos_rejected_quotat_id, em_obpos_isdeleted, em_obpos_islayaway, em_obpos_prepaymentamt, em_obpos_prepaymentlimitamt, em_obpos_prepaymentlaylimitamt, em_prpres_reference, em_prpres_void_order, em_prpres_gross_total, em_prpres_net_total, em_prpres_isgift, em_prpres_giftmessage, em_prpres_id_cart, em_prpres_id_paym_transaction, em_obmfm_selectfreight, em_obmfm_delivery_period_id, em_obmfm_delivery_charges, em_obmfm_freight_id, em_obmfm_weight, em_obmfm_weight_uom_id, em_obmfm_set_weight, em_obwpl_generatepicking, em_obwpl_isinpickinglist, em_obwpl_readypl, em_prpp_generatepicking, em_mntc_createinvoice, bpartner_extref, c_alternate_location_id, em_prpres_processing, em_prpres_generatepicking, em_obpos_rounding_amount, em_obpos_sequencename, em_obpos_sequencenumber, em_obpos_skip_tax_calculation) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 19 07 1 5s936ms 5s936ms [ User: tad - Total duration: 5s936ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 5s936ms - Times executed: 1 ]
-
COPY public.c_order (c_order_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processing, processed, c_doctype_id, c_doctypetarget_id, description, isdelivered, isinvoiced, isprinted, isselected, salesrep_id, dateordered, datepromised, dateprinted, dateacct, c_bpartner_id, billto_id, c_bpartner_location_id, poreference, isdiscountprinted, c_currency_id, paymentrule, c_paymentterm_id, invoicerule, deliveryrule, freightcostrule, freightamt, deliveryviarule, m_shipper_id, c_charge_id, chargeamt, priorityrule, totallines, grandtotal, m_warehouse_id, m_pricelist_id, istaxincluded, c_campaign_id, c_project_id, c_activity_id, posted, ad_user_id, copyfrom, dropship_bpartner_id, dropship_location_id, dropship_user_id, isselfservice, ad_orgtrx_id, user1_id, user2_id, deliverynotes, c_incoterms_id, incotermsdescription, generatetemplate, delivery_location_id, copyfrompo, fin_paymentmethod_id, fin_payment_priority_id, rm_pickfromshipment, rm_receivematerials, rm_createinvoice, c_return_reason_id, rm_addorphanline, a_asset_id, calculate_promotions, c_costcenter_id, convertquotation, c_reject_reason_id, validuntil, quotation_id, so_res_status, create_polines, iscashvat, rm_pickfromreceipt, em_opxmm_btn_purch, em_obdisc_addpack, em_obpos_applications_id, em_obpos_sendemail, em_obpos_email_status, cancelandreplace, confirmcancelandreplace, cancelledorder_id, replacedorder_id, iscancelled, replacementorder_id, em_aprm_addpayment, em_obpos_app_cashup_id, em_obpos_createdabsolute, em_obpos_notinvoiceoncashup, em_obpos_rejected_quotat_id, em_obpos_isdeleted, em_obpos_islayaway, em_obpos_prepaymentamt, em_obpos_prepaymentlimitamt, em_obpos_prepaymentlaylimitamt, em_prpres_reference, em_prpres_void_order, em_prpres_gross_total, em_prpres_net_total, em_prpres_isgift, em_prpres_giftmessage, em_prpres_id_cart, em_prpres_id_paym_transaction, em_obmfm_selectfreight, em_obmfm_delivery_period_id, em_obmfm_delivery_charges, em_obmfm_freight_id, em_obmfm_weight, em_obmfm_weight_uom_id, em_obmfm_set_weight, em_obwpl_generatepicking, em_obwpl_isinpickinglist, em_obwpl_readypl, em_prpp_generatepicking, em_mntc_createinvoice, bpartner_extref, c_alternate_location_id, em_prpres_processing, em_prpres_generatepicking, em_obpos_rounding_amount, em_obpos_sequencename, em_obpos_sequencenumber, em_obpos_skip_tax_calculation) TO stdout;
Date: 2026-07-19 07:01:47 Duration: 5s936ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
11 5s459ms 5s459ms 5s459ms 1 5s459ms copy public.fin_payment_schedule (fin_payment_schedule_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, c_invoice_id, c_order_id, duedate, fin_paymentmethod_id, c_currency_id, amount, paidamt, outstandingamt, isactive, fin_payment_priority_id, update_payment_plan, origduedate, description, expecteddate, em_kctrp_isretention_payment, em_aprm_modif_paym_sched, em_aprm_modif_paym_out_sched) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 19 07 1 5s459ms 5s459ms [ User: tad - Total duration: 5s459ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 5s459ms - Times executed: 1 ]
-
COPY public.fin_payment_schedule (fin_payment_schedule_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, c_invoice_id, c_order_id, duedate, fin_paymentmethod_id, c_currency_id, amount, paidamt, outstandingamt, isactive, fin_payment_priority_id, update_payment_plan, origduedate, description, expecteddate, em_kctrp_isretention_payment, em_aprm_modif_paym_sched, em_aprm_modif_paym_out_sched) TO stdout;
Date: 2026-07-19 07:02:48 Duration: 5s459ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
12 4s947ms 4s947ms 4s947ms 1 4s947ms copy public.c_invoice (c_invoice_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processing, processed, posted, c_doctype_id, c_doctypetarget_id, c_order_id, description, isprinted, salesrep_id, dateinvoiced, dateprinted, dateacct, c_bpartner_id, c_bpartner_location_id, poreference, isdiscountprinted, dateordered, c_currency_id, c_paymentterm_id, c_charge_id, chargeamt, totallines, grandtotal, m_pricelist_id, istaxincluded, c_campaign_id, c_project_id, c_activity_id, createfrom, generateto, ad_user_id, copyfrom, isselfservice, ad_orgtrx_id, user1_id, user2_id, withholdingamount, taxdate, c_withholding_id, ispaid, totalpaid, outstandingamt, daystilldue, dueamt, lastcalculatedondate, fin_paymentmethod_id, fin_payment_priority_id, finalsettlement, daysoutstanding, percentageoverdue, c_costcenter_id, calculate_promotions, a_asset_id, iscashvat, em_lpy_controle_impressos_id, em_lpy_isfiscalserno, em_lpy_fiscalno, em_lpy_fiscalserno, em_kctrp_isretention_payment, em_kctrp_retention_grossamt_id, em_aprm_addpayment, em_aprm_processinvoice, prepaymentamt, createfromorders, createfrominouts, paidamtatinvoicing, bpartner_extref, c_alternate_location_id, einvoice_status, einvoice_generated, einvoice_externalid, einvoice_send_status, einvoice_sent, em_obpos_rounding_amount, em_obpos_sequencename, em_obpos_sequencenumber, em_mntc_invoice_format) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 19 07 1 4s947ms 4s947ms [ User: tad - Total duration: 4s947ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4s947ms - Times executed: 1 ]
-
COPY public.c_invoice (c_invoice_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processing, processed, posted, c_doctype_id, c_doctypetarget_id, c_order_id, description, isprinted, salesrep_id, dateinvoiced, dateprinted, dateacct, c_bpartner_id, c_bpartner_location_id, poreference, isdiscountprinted, dateordered, c_currency_id, c_paymentterm_id, c_charge_id, chargeamt, totallines, grandtotal, m_pricelist_id, istaxincluded, c_campaign_id, c_project_id, c_activity_id, createfrom, generateto, ad_user_id, copyfrom, isselfservice, ad_orgtrx_id, user1_id, user2_id, withholdingamount, taxdate, c_withholding_id, ispaid, totalpaid, outstandingamt, daystilldue, dueamt, lastcalculatedondate, fin_paymentmethod_id, fin_payment_priority_id, finalsettlement, daysoutstanding, percentageoverdue, c_costcenter_id, calculate_promotions, a_asset_id, iscashvat, em_lpy_controle_impressos_id, em_lpy_isfiscalserno, em_lpy_fiscalno, em_lpy_fiscalserno, em_kctrp_isretention_payment, em_kctrp_retention_grossamt_id, em_aprm_addpayment, em_aprm_processinvoice, prepaymentamt, createfromorders, createfrominouts, paidamtatinvoicing, bpartner_extref, c_alternate_location_id, einvoice_status, einvoice_generated, einvoice_externalid, einvoice_send_status, einvoice_sent, em_obpos_rounding_amount, em_obpos_sequencename, em_obpos_sequencenumber, em_mntc_invoice_format) TO stdout;
Date: 2026-07-19 07:01:06 Duration: 4s947ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
13 3s989ms 8s669ms 4s730ms 156 12m17s select * from ( select f.c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || f.documentno || ? as description, ? as isactive, f.ad_org_id, f.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, f.c_invoice_id, ?) as record_id from ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = ? and co.em_obpos_applications_id is not null group by ci.documentno, extract(year from dateinvoiced), ci.c_doctype_id having count(ci.documentno) > ? order by max(dateinvoiced) desc) as f) aaa where not exists ( select ? from ad_alert a where a.ad_alertrule_id = ? and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, ?) != ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 19 07 12 59s272ms 4s939ms 08 12 56s662ms 4s721ms 09 12 57s862ms 4s821ms 10 12 56s681ms 4s723ms 11 12 56s523ms 4s710ms 12 12 55s339ms 4s611ms 13 12 56s732ms 4s727ms 14 12 57s580ms 4s798ms 15 12 57s215ms 4s767ms 16 12 56s303ms 4s691ms 17 12 55s905ms 4s658ms 18 12 55s997ms 4s666ms 19 12 55s833ms 4s652ms [ User: tad - Total duration: 12m17s - Times executed: 156 ]
[ Application: openbravo - Total duration: 12m17s - Times executed: 156 ]
-
SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 07:00:08 Duration: 8s669ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 09:00:08 Duration: 8s201ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
SELECT * FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '463465B5BE664902A40F05E84E1587CD' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');
Date: 2026-07-19 14:00:07 Duration: 7s544ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
14 3s804ms 6s47ms 4s356ms 156 11m19s update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select f.c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || f.documentno || ? as description, ? as isactive, f.ad_org_id, f.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, f.c_invoice_id, ?) as record_id from ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = ? and co.em_obpos_applications_id is not null group by ci.documentno, extract(year from dateinvoiced), ci.c_doctype_id having count(ci.documentno) > ? order by max(dateinvoiced) desc) as f) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 19 07 12 55s823ms 4s651ms 08 12 52s83ms 4s340ms 09 12 50s793ms 4s232ms 10 12 52s992ms 4s416ms 11 12 50s941ms 4s245ms 12 12 52s655ms 4s387ms 13 12 51s126ms 4s260ms 14 12 53s955ms 4s496ms 15 12 52s796ms 4s399ms 16 12 50s74ms 4s172ms 17 12 50s895ms 4s241ms 18 12 54s111ms 4s509ms 19 12 51s399ms 4s283ms [ User: tad - Total duration: 11m19s - Times executed: 156 ]
[ Application: openbravo - Total duration: 11m19s - Times executed: 156 ]
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '463465B5BE664902A40F05E84E1587CD' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-19 12:00:11 Duration: 6s47ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '463465B5BE664902A40F05E84E1587CD' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-19 07:00:14 Duration: 5s941ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '463465B5BE664902A40F05E84E1587CD' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-19 07:05:10 Duration: 5s612ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
15 3s787ms 3s787ms 3s787ms 1 3s787ms copy public.fin_finacc_transaction (fin_finacc_transaction_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, isactive, c_currency_id, fin_financial_account_id, line, fin_payment_id, dateacct, c_glitem_id, status, paymentamt, depositamt, processed, processing, posted, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, trxtype, statementdate, description, fin_reconciliation_id, createdbyalgorithm, foreign_currency_id, foreign_convert_rate, foreign_amount, c_bpartner_id, m_product_id, c_salesregion_id, c_costcenter_id, em_aprm_processed, em_aprm_finacc_trans_origin, em_obpos_app_cashup_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 19 07 1 3s787ms 3s787ms [ User: tad - Total duration: 3s787ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 3s787ms - Times executed: 1 ]
-
COPY public.fin_finacc_transaction (fin_finacc_transaction_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, isactive, c_currency_id, fin_financial_account_id, line, fin_payment_id, dateacct, c_glitem_id, status, paymentamt, depositamt, processed, processing, posted, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, trxtype, statementdate, description, fin_reconciliation_id, createdbyalgorithm, foreign_currency_id, foreign_convert_rate, foreign_amount, c_bpartner_id, m_product_id, c_salesregion_id, c_costcenter_id, em_aprm_processed, em_aprm_finacc_trans_origin, em_obpos_app_cashup_id) TO stdout;
Date: 2026-07-19 07:02:34 Duration: 3s787ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
16 3s579ms 3s579ms 3s579ms 1 3s579ms copy public.fin_payment_scheduledetail (fin_payment_scheduledetail_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, fin_payment_detail_id, fin_payment_schedule_order, fin_payment_schedule_invoice, amount, isactive, writeoffamt, iscanceled, c_bpartner_id, c_activity_id, m_product_id, c_campaign_id, c_project_id, c_salesregion_id, c_costcenter_id, user1_id, user2_id, doubtfuldebt_amount, isinvoicepaid) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 19 07 1 3s579ms 3s579ms [ User: tad - Total duration: 3s579ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 3s579ms - Times executed: 1 ]
-
COPY public.fin_payment_scheduledetail (fin_payment_scheduledetail_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, fin_payment_detail_id, fin_payment_schedule_order, fin_payment_schedule_invoice, amount, isactive, writeoffamt, iscanceled, c_bpartner_id, c_activity_id, m_product_id, c_campaign_id, c_project_id, c_salesregion_id, c_costcenter_id, user1_id, user2_id, doubtfuldebt_amount, isinvoicepaid) TO stdout;
Date: 2026-07-19 07:02:52 Duration: 3s579ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
17 3s341ms 3s341ms 3s341ms 1 3s341ms copy public.fin_payment (fin_payment_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, isactive, isreceipt, c_bpartner_id, paymentdate, c_currency_id, amount, writeoffamt, fin_paymentmethod_id, documentno, referenceno, status, processed, processing, posted, description, fin_financial_account_id, c_doctype_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, generated_credit, used_credit, createdbyalgorithm, finacc_txn_convert_rate, finacc_txn_amount, fin_rev_payment_id, c_costcenter_id, em_kctrp_isretention_payment, em_kctrp_c_tax_id, em_kctrp_isretention_applied, em_kctrp_c_invoice_id, em_aprm_process_payment, em_aprm_reconcile_payment, em_aprm_add_scheduledpayments, em_aprm_executepayment, em_aprm_reversepayment, em_obpos_paymentdata, em_obpos_app_cashup_id, em_obpos_applications_id, em_obpos_rounded_payment_id, em_obpos_txtransaction, em_obpos_txauthorization, em_obpos_txcreditcardnummasked) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 19 07 1 3s341ms 3s341ms [ User: tad - Total duration: 3s341ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 3s341ms - Times executed: 1 ]
-
COPY public.fin_payment (fin_payment_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, isactive, isreceipt, c_bpartner_id, paymentdate, c_currency_id, amount, writeoffamt, fin_paymentmethod_id, documentno, referenceno, status, processed, processing, posted, description, fin_financial_account_id, c_doctype_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, generated_credit, used_credit, createdbyalgorithm, finacc_txn_convert_rate, finacc_txn_amount, fin_rev_payment_id, c_costcenter_id, em_kctrp_isretention_payment, em_kctrp_c_tax_id, em_kctrp_isretention_applied, em_kctrp_c_invoice_id, em_aprm_process_payment, em_aprm_reconcile_payment, em_aprm_add_scheduledpayments, em_aprm_executepayment, em_aprm_reversepayment, em_obpos_paymentdata, em_obpos_app_cashup_id, em_obpos_applications_id, em_obpos_rounded_payment_id, em_obpos_txtransaction, em_obpos_txauthorization, em_obpos_txcreditcardnummasked) TO stdout;
Date: 2026-07-19 07:02:40 Duration: 3s341ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
18 3s332ms 3s332ms 3s332ms 1 3s332ms copy public.m_inout (m_inout_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docaction, docstatus, posted, processing, processed, c_doctype_id, description, c_order_id, dateordered, isprinted, movementtype, movementdate, dateacct, c_bpartner_id, c_bpartner_location_id, m_warehouse_id, poreference, deliveryrule, freightcostrule, freightamt, deliveryviarule, m_shipper_id, c_charge_id, chargeamt, priorityrule, dateprinted, c_invoice_id, createfrom, generateto, ad_user_id, salesrep_id, nopackages, pickdate, shipdate, trackingno, ad_orgtrx_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, updatelines, islogistic, calculate_freight, delivery_location_id, m_freightcategory_id, freight_currency_id, rm_receipt_pickedit, rm_shipment_pickedit, m_condition_goods_id, a_asset_id, c_costcenter_id, process_goods_java, em_lpy_controle_impressos_id, em_lpy_isfiscalserno, em_lpy_fiscalno, em_lpy_fiscalserno, isnettingshipment, iscompletelyinvoiced, invoicefromshipment, em_prpres_disable_trackerror, em_obmfm_freight_id, em_obmfm_delivery_charges, em_obmfm_deliverynotes, em_prlab_desc, em_obwpack_packing, em_obwpack_packingh_id, em_obwpack_processed, em_obwpack_reactivated, em_obwpack_packingrequired, bpartner_extref, c_alternate_location_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 19 07 1 3s332ms 3s332ms [ User: tad - Total duration: 3s332ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 3s332ms - Times executed: 1 ]
-
COPY public.m_inout (m_inout_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docaction, docstatus, posted, processing, processed, c_doctype_id, description, c_order_id, dateordered, isprinted, movementtype, movementdate, dateacct, c_bpartner_id, c_bpartner_location_id, m_warehouse_id, poreference, deliveryrule, freightcostrule, freightamt, deliveryviarule, m_shipper_id, c_charge_id, chargeamt, priorityrule, dateprinted, c_invoice_id, createfrom, generateto, ad_user_id, salesrep_id, nopackages, pickdate, shipdate, trackingno, ad_orgtrx_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, updatelines, islogistic, calculate_freight, delivery_location_id, m_freightcategory_id, freight_currency_id, rm_receipt_pickedit, rm_shipment_pickedit, m_condition_goods_id, a_asset_id, c_costcenter_id, process_goods_java, em_lpy_controle_impressos_id, em_lpy_isfiscalserno, em_lpy_fiscalno, em_lpy_fiscalserno, isnettingshipment, iscompletelyinvoiced, invoicefromshipment, em_prpres_disable_trackerror, em_obmfm_freight_id, em_obmfm_delivery_charges, em_obmfm_deliverynotes, em_prlab_desc, em_obwpack_packing, em_obwpack_packingh_id, em_obwpack_processed, em_obwpack_reactivated, em_obwpack_packingrequired, bpartner_extref, c_alternate_location_id) TO stdout;
Date: 2026-07-19 07:02:55 Duration: 3s332ms Database: openbravo User: tad Remote: 127.0.0.1 Application: pg_dump
19 1s639ms 4s651ms 1s929ms 79 2m32s select distinct pprod.m_product_id, pprod.ps_product_id as baseprodid, ? as combinationid, pprod.stock_id, pprod.shop_id, coalesce(pprod.group_id, ?) as group_id, coalesce(pprod.out_of_stock, ?) as out_of_stock, coalesce(pprod.depends_on_stock, ?) as depends_on_stock from prpres_product pprod where pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_transaction left join prpres_product on m_transaction.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = ? and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_product.m_product_id is not null and m_product.isgeneric = ?) or pprod.prpres_product_id in ( select distinct (prpres_product_id) from prpres_product left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id left join m_product on prpres_product.m_product_id = m_product.m_product_id where prpres_conf.prpres_conf_id = ? and coalesce(prpres_product.inventory_date, prpres_product.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_product.m_product_id is not null and m_product.isgeneric = ?) or pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_reservation left join prpres_product on m_reservation.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = ? and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_product.m_product_id is not null and m_product.isgeneric = ?) union select distinct pcomb.m_product_id, pprod.ps_product_id as baseprodid, pcomb.ps_combination_id as combinationid, pcomb.stock_id, pcomb.shop_id, coalesce(pcomb.group_id, ?) as group_id, coalesce(pcomb.out_of_stock, ?) as out_of_stock, coalesce(pcomb.depends_on_stock, ?) as depends_on_stock from prpres_combination pcomb left join prpres_product pprod on pcomb.prpres_product_id = pprod.prpres_product_id where pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_transaction left join prpres_combination on m_transaction.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = ? and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_combination.m_product_id is not null and m_product.isgeneric = ?) or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from prpres_combination left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = ? and coalesce(prpres_combination.inventory_date, prpres_combination.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_combination.m_product_id is not null and m_product.isgeneric = ?) or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_reservation left join prpres_combination on m_reservation.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = ? and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id is not null and prpres_combination.m_product_id is not null and m_product.isgeneric = ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 19 07 6 11s863ms 1s977ms 08 6 11s930ms 1s988ms 09 6 13s943ms 2s323ms 10 6 10s959ms 1s826ms 11 6 11s440ms 1s906ms 12 6 11s263ms 1s877ms 13 6 11s134ms 1s855ms 14 6 11s91ms 1s848ms 15 6 11s44ms 1s840ms 16 6 11s446ms 1s907ms 17 6 11s220ms 1s870ms 18 6 11s595ms 1s932ms 19 6 10s894ms 1s815ms 20 1 2s612ms 2s612ms [ User: tad - Total duration: 2m32s - Times executed: 79 ]
[ Application: openbravo - Total duration: 2m32s - Times executed: 79 ]
-
select distinct pprod.m_product_id, pprod.ps_product_id as baseprodid, '0' as combinationid, pprod.stock_id, pprod.shop_id, coalesce(pprod.group_id, '0') as group_id, coalesce(pprod.out_of_stock, '2') as out_of_stock, coalesce(pprod.depends_on_stock, '0') as depends_on_stock from prpres_product pprod where pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_transaction left join prpres_product on m_transaction.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from prpres_product left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id left join m_product on prpres_product.m_product_id = m_product.m_product_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_product.inventory_date, prpres_product.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_reservation left join prpres_product on m_reservation.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') UNION select distinct pcomb.m_product_id, pprod.ps_product_id as baseprodid, pcomb.ps_combination_id as combinationid, pcomb.stock_id, pcomb.shop_id, coalesce(pcomb.group_id, '0') as group_id, coalesce(pcomb.out_of_stock, '2') as out_of_stock, coalesce(pcomb.depends_on_stock, '0') as depends_on_stock from prpres_combination pcomb left join prpres_product pprod on pcomb.prpres_product_id = pprod.prpres_product_id where pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_transaction left join prpres_combination on m_transaction.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from prpres_combination left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_combination.inventory_date, prpres_combination.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_reservation left join prpres_combination on m_reservation.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N');
Date: 2026-07-19 09:00:04 Duration: 4s651ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select distinct pprod.m_product_id, pprod.ps_product_id as baseprodid, '0' as combinationid, pprod.stock_id, pprod.shop_id, coalesce(pprod.group_id, '0') as group_id, coalesce(pprod.out_of_stock, '2') as out_of_stock, coalesce(pprod.depends_on_stock, '0') as depends_on_stock from prpres_product pprod where pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_transaction left join prpres_product on m_transaction.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from prpres_product left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id left join m_product on prpres_product.m_product_id = m_product.m_product_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_product.inventory_date, prpres_product.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_reservation left join prpres_product on m_reservation.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') UNION select distinct pcomb.m_product_id, pprod.ps_product_id as baseprodid, pcomb.ps_combination_id as combinationid, pcomb.stock_id, pcomb.shop_id, coalesce(pcomb.group_id, '0') as group_id, coalesce(pcomb.out_of_stock, '2') as out_of_stock, coalesce(pcomb.depends_on_stock, '0') as depends_on_stock from prpres_combination pcomb left join prpres_product pprod on pcomb.prpres_product_id = pprod.prpres_product_id where pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_transaction left join prpres_combination on m_transaction.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from prpres_combination left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_combination.inventory_date, prpres_combination.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_reservation left join prpres_combination on m_reservation.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N');
Date: 2026-07-19 07:00:03 Duration: 2s829ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select distinct pprod.m_product_id, pprod.ps_product_id as baseprodid, '0' as combinationid, pprod.stock_id, pprod.shop_id, coalesce(pprod.group_id, '0') as group_id, coalesce(pprod.out_of_stock, '2') as out_of_stock, coalesce(pprod.depends_on_stock, '0') as depends_on_stock from prpres_product pprod where pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_transaction left join prpres_product on m_transaction.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from prpres_product left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id left join m_product on prpres_product.m_product_id = m_product.m_product_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_product.inventory_date, prpres_product.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') or pprod.prpres_product_id in ( select distinct (prpres_product_id) from m_reservation left join prpres_product on m_reservation.m_product_id = prpres_product.m_product_id left join m_product on prpres_product.m_product_id = m_product.m_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_product.m_product_id is not null and m_product.isgeneric = 'N') UNION select distinct pcomb.m_product_id, pprod.ps_product_id as baseprodid, pcomb.ps_combination_id as combinationid, pcomb.stock_id, pcomb.shop_id, coalesce(pcomb.group_id, '0') as group_id, coalesce(pcomb.out_of_stock, '2') as out_of_stock, coalesce(pcomb.depends_on_stock, '0') as depends_on_stock from prpres_combination pcomb left join prpres_product pprod on pcomb.prpres_product_id = pprod.prpres_product_id where pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_transaction left join prpres_combination on m_transaction.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_transaction.trxprocessdate >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from prpres_combination left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and coalesce(prpres_combination.inventory_date, prpres_combination.created) >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N') or pcomb.prpres_combination_id in ( select distinct (prpres_combination_id) from m_reservation left join prpres_combination on m_reservation.m_product_id = prpres_combination.m_product_id left join m_product on prpres_combination.m_product_id = m_product.m_product_id left join prpres_product on prpres_combination.prpres_product_id = prpres_product.prpres_product_id left join prpres_conf on prpres_conf.prpres_conf_id = prpres_product.prpres_conf_id where prpres_conf.prpres_conf_id = '83A67C3749514528BCB99879C97E01BE' and m_reservation.created >= prpres_conf.last_inventory_sync and prpres_product.ps_product_id IS NOT NULL and prpres_combination.m_product_id is not null and m_product.isgeneric = 'N');
Date: 2026-07-19 20:00:02 Duration: 2s612ms Database: openbravo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
20 1s262ms 2s241ms 1s581ms 14 22s136ms select profile.take_sample ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 19 07 1 1s835ms 1s835ms 08 1 1s724ms 1s724ms 09 1 2s241ms 2s241ms 10 1 1s262ms 1s262ms 11 1 1s606ms 1s606ms 12 1 1s321ms 1s321ms 13 1 1s292ms 1s292ms 14 1 1s499ms 1s499ms 15 1 1s398ms 1s398ms 16 1 1s542ms 1s542ms 17 1 1s566ms 1s566ms 18 1 1s356ms 1s356ms 19 1 1s313ms 1s313ms 20 1 2s174ms 2s174ms [ User: postgres - Total duration: 22s136ms - Times executed: 14 ]
[ Application: psql - Total duration: 22s136ms - Times executed: 14 ]
-
SELECT profile.take_sample ();
Date: 2026-07-19 09:00:04 Duration: 2s241ms Database: openbravo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-19 20:00:03 Duration: 2s174ms Database: openbravo User: postgres Remote: [local] Application: psql
-
SELECT profile.take_sample ();
Date: 2026-07-19 07:00:03 Duration: 1s835ms Database: openbravo User: postgres Remote: [local] Application: psql
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
- 28,652 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Errors 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