pgBadger-
Global information
- Generated on Sun Jul 19 23:00:23 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 357,575 log entries in 22s
- Log start from 2026-07-19 07:00:01 to 2026-07-19 22:00:00
-
Overview
Global Stats
- 205 Number of unique normalized queries
- 153,863 Number of queries
- 2m31s Total query duration
- 2026-07-19 07:00:01 First query
- 2026-07-19 22:00:00 Last query
- 629 queries/s at 2026-07-19 22:00:00 Query peak
- 2m31s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2m31s 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
- 85 Total number of automatic vacuums
- 107 Total number of automatic analyzes
- 14 Number temporary file
- 90.81 MiB Max size of temporary file
- 25.80 MiB Average size of temporary file
- 5,415 Total number of sessions
- 0 sessions at Session peak
- 1m58s Total duration of sessions
- 21ms Average duration of sessions
- 28 Average queries per session
- 28ms Average queries duration per session
- 0ms Average idle time per session
- 5,415 Total number of connections
- 5 connections/s at 2026-07-19 14:00:01 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 629 queries/s Query Peak
- 2026-07-19 22:00:00 Date
SELECT Traffic
Key values
- 202 queries/s Query Peak
- 2026-07-19 22:00:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 27 queries/s Query Peak
- 2026-07-19 21:00:02 Date
Queries duration
Key values
- 2m31s 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 9,606 0ms 742ms 0ms 61ms 67ms 1s115ms 08 10,152 0ms 683ms 0ms 59ms 63ms 992ms 09 10,152 0ms 686ms 0ms 58ms 66ms 969ms 10 10,153 0ms 722ms 0ms 60ms 69ms 997ms 11 10,155 0ms 717ms 0ms 57ms 65ms 989ms 12 10,153 0ms 675ms 0ms 65ms 70ms 1s102ms 13 10,151 0ms 703ms 0ms 63ms 66ms 1s31ms 14 10,216 0ms 701ms 0ms 61ms 72ms 971ms 15 10,738 0ms 30s909ms 6ms 62ms 1s40ms 50s396ms 16 10,214 0ms 716ms 0ms 63ms 67ms 974ms 17 10,153 0ms 711ms 0ms 61ms 65ms 1s12ms 18 10,153 0ms 690ms 0ms 63ms 64ms 967ms 19 10,233 0ms 698ms 0ms 63ms 65ms 981ms 20 10,276 0ms 715ms 0ms 62ms 66ms 987ms 21 10,729 0ms 12s768ms 3ms 64ms 74ms 34s811ms 22 629 0ms 48ms 0ms 197ms 197ms 197ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 19 07 2,738 0 0ms 0ms 0ms 0ms 08 2,921 0 0ms 0ms 0ms 0ms 09 2,921 0 0ms 0ms 0ms 0ms 10 2,921 0 0ms 0ms 0ms 0ms 11 2,921 0 0ms 0ms 0ms 0ms 12 2,921 0 0ms 0ms 0ms 0ms 13 2,921 0 0ms 0ms 0ms 0ms 14 2,940 0 0ms 0ms 0ms 0ms 15 3,003 0 0ms 0ms 0ms 0ms 16 2,940 0 0ms 0ms 0ms 0ms 17 2,921 0 0ms 0ms 0ms 0ms 18 2,921 0 0ms 0ms 0ms 0ms 19 2,942 0 0ms 0ms 0ms 0ms 20 2,959 0 0ms 0ms 0ms 0ms 21 3,004 0 0ms 0ms 0ms 0ms 22 202 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 19 07 0 1 0 0 0ms 0ms 0ms 0ms 08 1 1 0 0 0ms 0ms 0ms 0ms 09 1 2 0 0 0ms 0ms 0ms 0ms 10 1 2 0 0 0ms 0ms 0ms 0ms 11 1 3 0 0 0ms 0ms 0ms 0ms 12 1 2 0 0 0ms 0ms 0ms 0ms 13 1 1 0 0 0ms 0ms 0ms 0ms 14 1 2 0 0 0ms 0ms 0ms 0ms 15 2 67 0 0 0ms 0ms 0ms 0ms 16 1 1 0 0 0ms 0ms 0ms 0ms 17 1 2 0 0 0ms 0ms 0ms 0ms 18 1 2 0 0 0ms 0ms 0ms 0ms 19 1 3 0 0 0ms 0ms 0ms 0ms 20 1 1 0 0 0ms 0ms 0ms 0ms 21 2 66 0 0 0ms 0ms 0ms 0ms 22 2 3 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 19 07 0 2,806 2,806.00 0.00% 08 0 2,992 2,992.00 0.00% 09 0 2,993 2,993.00 0.00% 10 0 2,993 2,993.00 0.00% 11 0 2,994 2,994.00 0.00% 12 0 2,993 2,993.00 0.00% 13 0 2,992 2,992.00 0.00% 14 0 3,014 3,014.00 0.00% 15 0 3,143 3,143.00 0.00% 16 0 3,013 3,013.00 0.00% 17 0 2,993 2,993.00 0.00% 18 0 2,993 2,993.00 0.00% 19 0 3,019 3,019.00 0.00% 20 0 3,034 3,034.00 0.00% 21 0 3,143 3,143.00 0.00% 22 0 214 214.00 0.00% Day Hour Count Average / Second Jul 19 07 361 0.10/s 08 361 0.10/s 09 361 0.10/s 10 361 0.10/s 11 361 0.10/s 12 361 0.10/s 13 361 0.10/s 14 361 0.10/s 15 361 0.10/s 16 361 0.10/s 17 361 0.10/s 18 361 0.10/s 19 361 0.10/s 20 361 0.10/s 21 361 0.10/s 22 0 0.00/s Day Hour Count Average Duration Average idle time Jul 19 07 361 21ms 11ms 08 361 21ms 12ms 09 361 22ms 12ms 10 361 22ms 12ms 11 361 21ms 12ms 12 361 21ms 11ms 13 361 22ms 12ms 14 361 21ms 12ms 15 361 21ms 0ms 16 361 22ms 12ms 17 361 22ms 12ms 18 361 22ms 12ms 19 361 22ms 12ms 20 361 21ms 11ms 21 361 22ms 0ms 22 0 0ms 0ms -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-19 14:00:01 Date
Connections per database
Key values
- etendo Main Database
- 5,415 connections Total
Connections per user
Key values
- tad Main User
- 5,415 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- 5,400 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 5,415 sessions Total
Sessions per user
Key values
- tad Main User
- 5,415 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 5,415 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 1,452 buffers Checkpoint Peak
- 2026-07-19 13:05:04 Date
- 144.921 seconds Highest write time
- 0.003 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-07-19 21:04:27 Date
Checkpoints distance
Key values
- 20.69 Mo Distance Peak
- 2026-07-19 13:05:04 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 19 07 1,236 123.159s 0.003s 123.165s 08 1,155 115.048s 0.002s 115.054s 09 1,336 133.188s 0.003s 133.195s 10 1,204 119.946s 0.002s 119.954s 11 1,151 114.738s 0.003s 114.746s 12 1,184 118.146s 0.003s 118.152s 13 1,452 144.921s 0.002s 144.929s 14 1,124 112.131s 0.002s 112.138s 15 1,020 101.611s 0.005s 101.625s 16 1,337 133.392s 0.002s 133.398s 17 1,181 117.949s 0.003s 117.957s 18 1,177 117.36s 0.002s 117.367s 19 1,198 119.352s 0.002s 119.356s 20 1,161 116.037s 0.002s 116.044s 21 1,041 103.714s 0.002s 103.72s 22 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 19 07 0 0 0 134 0.002s 0.001s 08 0 1 0 134 0.001s 0.001s 09 0 0 0 133 0.001s 0.001s 10 0 1 0 127 0.001s 0.001s 11 0 1 0 127 0.002s 0.001s 12 0 0 0 123 0.002s 0.001s 13 0 1 0 132 0.002s 0.001s 14 0 0 0 128 0.002s 0.001s 15 0 1 0 138 0.002s 0.002s 16 0 0 0 128 0.002s 0.001s 17 0 1 0 129 0.002s 0.001s 18 0 1 0 129 0.002s 0.001s 19 0 0 0 125 0.001s 0.001s 20 0 1 0 129 0.002s 0.001s 21 0 0 0 135 0.002s 0.001s 22 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 21 0 0s 22 0 0s Day Hour Mean distance Mean estimate Jul 19 07 9,565.00 kB 10,848.00 kB 08 9,137.00 kB 10,677.00 kB 09 9,748.00 kB 10,584.00 kB 10 9,440.00 kB 10,470.00 kB 11 9,214.00 kB 10,344.00 kB 12 9,384.00 kB 10,248.00 kB 13 10,595.00 kB 10,595.00 kB 14 8,904.00 kB 10,426.00 kB 15 4,703.00 kB 9,804.00 kB 16 9,977.00 kB 9,977.00 kB 17 9,841.00 kB 9,964.00 kB 18 9,283.00 kB 9,896.00 kB 19 9,761.00 kB 9,882.00 kB 20 9,272.00 kB 9,821.00 kB 21 9,575.00 kB 9,796.00 kB 22 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 92.08 MiB Temp Files size Peak
- 2026-07-19 15:30:38 Date
Number of temporary files
Key values
- 3 per second Temp Files Peak
- 2026-07-19 15:30:38 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 19 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 7 180.59 MiB 25.80 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 7 180.59 MiB 25.80 MiB 22 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 4 355.77 MiB 87.07 MiB 90.81 MiB 88.94 MiB ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, c_invoice.ad_org_id as ad_org_id, c_invoice.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id from c_invoice, c_doctype, fact_acct f1, fact_acct f2 where c_invoice.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype in (...) and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id group by c_invoice_id, posted, c_invoice.ad_client_id, c_invoice.ad_org_id, f1.ad_table_id, f1.record_id) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);-
'0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-19 15:30:38 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
2 4 3.97 MiB 736.00 KiB 1.27 MiB 1016.00 KiB ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id, ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, record_id, ?) as record_id from fact_acct where ad_table_id = ? and docbasetype in (...) group by fact_acct_group_id, record_id, ad_client_id, ad_org_id having sum(amtacctcr - amtacctdr) <> ?) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);-
'0' as ad_role_id, null as ad_user_id, 'NOT BALANCED SALES INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('ARI', 'ARC', 'ARF') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-19 15:30:38 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
3 2 1.44 MiB 736.00 KiB 736.00 KiB 736.00 KiB update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select record_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id, ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, record_id, ?) as record_id from fact_acct where ad_table_id = ? and docbasetype in (...) group by fact_acct_group_id, record_id, ad_client_id, ad_org_id having sum(amtacctcr - amtacctdr) <> ?) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);-
UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select record_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED PURCHASE INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('API', 'APC') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);
Date: 2026-07-19 15:31:04 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
Queries generating the largest temporary files
Rank Size Query 1 90.81 MiB '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 15:30:38 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2 90.81 MiB '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 21:00:06 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3 87.07 MiB '0' as ad_role_id, null as ad_user_id, 'PURCHASE INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('API', 'APC') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 15:31:06 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4 87.07 MiB '0' as ad_role_id, null as ad_user_id, 'PURCHASE INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('API', 'APC') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 21:00:34 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5 1.27 MiB '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED SALES INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('ARI', 'ARC', 'ARF') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 15:30:38 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
6 1.27 MiB '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED SALES INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('ARI', 'ARC', 'ARF') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 21:00:06 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
7 736.00 KiB '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED PURCHASE INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('API', 'APC') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 15:30:51 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8 736.00 KiB 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 record_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED PURCHASE INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('API', 'APC') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 15:31:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
9 736.00 KiB '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED PURCHASE INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('API', 'APC') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 21:00:19 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
10 736.00 KiB 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 record_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED PURCHASE INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('API', 'APC') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);[ Date: 2026-07-19 21:00:32 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.33 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database etendo - 2026-07-19 13:01:36 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 0.33 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database etendo - 2026-07-19 13:01:36 Date
Analyzes per table
Key values
- profile.last_stat_user_functions_srv1 (15) Main table analyzed (database etendo)
- 107 analyzes Total
Table Number of analyzes etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.last_stat_statements_srv1 15 etendo.profile.last_stat_tables_srv1 15 etendo.profile.last_stat_indexes_srv1 15 etendo.profile.last_stat_io 8 etendo.profile.tables_list 7 etendo.profile.last_stat_activity_count_srv1 4 etendo.profile.last_extension_versions 4 etendo.profile.last_stat_slru 3 etendo.profile.sample_stat_user_functions 2 etendo.profile.stmt_list 2 etendo.profile.sample_stat_tables 2 etendo.profile.indexes_list 2 etendo.profile.last_stat_archiver 1 etendo.profile.sample_stat_database 1 etendo.profile.sample_stat_tables_total 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.sample_stat_io 1 etendo.profile.last_stat_wal 1 etendo.profile.sample_stat_user_func_total 1 etendo.profile.funcs_list 1 etendo.profile.sample_statements 1 etendo.profile.sample_stat_slru 1 etendo.profile.sample_stat_tablespaces 1 etendo.profile.sample_stat_indexes 1 etendo.profile.last_stat_cluster 1 Total 107 Vacuums per table
Key values
- profile.last_stat_statements_srv1 (15) Main table vacuumed on database etendo
- 85 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples etendo.profile.last_stat_statements_srv1 15 15 4,194 0 45 0 0 2,052 60 424,460 0 0 etendo.profile.last_stat_indexes_srv1 15 15 15,688 0 270 0 0 11,271 285 1,807,673 0 0 etendo.profile.last_stat_tables_srv1 15 15 12,270 0 173 0 0 8,924 174 1,252,092 0 0 etendo.profile.last_stat_user_functions_srv1 15 15 2,140 0 43 0 0 1,111 33 242,305 0 0 etendo.profile.tables_list 4 4 588 0 12 0 0 325 8 88,398 0 0 etendo.profile.last_stat_io 3 3 219 0 11 0 0 21 5 42,788 0 0 etendo.profile.last_stat_database_srv1 2 2 100 0 4 0 0 12 4 23,468 0 0 etendo.profile.last_stat_activity_count_srv1 2 0 42 0 10 0 0 12 4 19,888 0 0 etendo.profile.last_extension_versions 2 2 104 0 10 0 0 10 4 33,532 0 0 etendo.profile.last_stat_slru 2 2 117 0 9 0 0 10 3 25,711 0 0 etendo.profile.indexes_list 2 2 247 0 7 0 0 63 6 38,882 1 2 etendo.profile.stmt_list 2 2 549 0 39 0 0 267 37 246,197 5 14 etendo.profile.last_stat_tablespaces_srv1 1 1 51 0 6 0 0 6 3 20,739 0 0 etendo.profile.funcs_list 1 1 88 0 4 0 0 27 1 10,500 0 0 etendo.profile.sample_stat_user_func_total 1 1 61 0 8 0 0 11 4 26,313 0 0 etendo.profile.sample_stat_tablespaces 1 1 84 0 8 0 0 13 4 26,215 0 0 etendo.pg_catalog.pg_statistic 1 1 1,466 0 271 0 0 1,147 252 1,156,078 116 865 etendo.pg_toast.pg_toast_2619 1 1 436 0 89 0 0 278 85 196,756 5 10 Total 85 83 38,444 0 1,019 0 0 25,560 972 5,681,995 127 891 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.33) Max CPU elapsed for vacuum on database etendo
- unknown (0 ms) Max I/O read time for vacuum on database etendo
- unknown (0 ms) Max I/O write time for vacuum on database etendo
I/O timing (ms) CPU (s) Table read write elapsed etendo.profile.last_stat_statements_srv1 0 0 0.01 etendo.profile.last_stat_indexes_srv1 0 0 0.18 etendo.profile.last_stat_tables_srv1 0 0 0.19 etendo.profile.last_stat_user_functions_srv1 0 0 0 etendo.profile.tables_list 0 0 0 etendo.profile.last_stat_io 0 0 0 etendo.profile.last_stat_database_srv1 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.last_extension_versions 0 0 0 etendo.profile.last_stat_slru 0 0 0 etendo.profile.indexes_list 0 0 0 etendo.profile.stmt_list 0 0 0 etendo.profile.last_stat_tablespaces_srv1 0 0 0 etendo.profile.funcs_list 0 0 0 etendo.profile.sample_stat_user_func_total 0 0 0.01 etendo.profile.sample_stat_tablespaces 0 0 0 etendo.pg_catalog.pg_statistic 0 0 0.33 etendo.pg_toast.pg_toast_2619 0 0 0.02 Total 0 0 0.74 Tuples removed per table
Key values
- profile.last_stat_indexes_srv1 (70562) Main table with removed tuples on database etendo
- 129376 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.profile.last_stat_indexes_srv1 15 15 70,562 34,935 0 282 4,018 etendo.profile.last_stat_tables_srv1 15 15 44,525 20,880 0 366 3,059 etendo.profile.last_stat_statements_srv1 15 15 6,664 4,894 0 19 624 etendo.profile.last_stat_user_functions_srv1 15 15 5,105 4,605 0 6 324 etendo.pg_catalog.pg_statistic 1 1 943 7,226 0 0 544 etendo.profile.tables_list 4 4 462 3,202 0 0 96 etendo.pg_toast.pg_toast_2619 1 1 250 1,150 0 0 454 etendo.profile.stmt_list 2 2 153 1,394 0 0 148 etendo.profile.last_extension_versions 2 2 112 16 0 0 2 etendo.profile.last_stat_slru 2 2 110 10 0 0 2 etendo.profile.last_stat_io 3 3 91 39 0 0 6 etendo.profile.sample_stat_user_func_total 1 1 90 336 0 0 4 etendo.profile.sample_stat_tablespaces 1 1 82 336 0 0 4 etendo.profile.indexes_list 2 2 69 664 0 0 20 etendo.profile.last_stat_tablespaces_srv1 1 1 52 2 0 0 1 etendo.profile.funcs_list 1 1 50 172 0 0 8 etendo.profile.last_stat_activity_count_srv1 2 0 48 0 0 2 0 etendo.profile.last_stat_database_srv1 2 2 8 8 0 0 2 Total 85 83 129,376 79,869 0 675 9,316 Pages removed per table
Key values
- profile.last_stat_tables_srv1 (366) Main table with removed pages on database etendo
- 675 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed etendo.profile.last_stat_tables_srv1 15 15 44525 366 etendo.profile.last_stat_indexes_srv1 15 15 70562 282 etendo.profile.last_stat_statements_srv1 15 15 6664 19 etendo.profile.last_stat_user_functions_srv1 15 15 5105 6 etendo.profile.last_stat_activity_count_srv1 2 0 48 2 etendo.profile.tables_list 4 4 462 0 etendo.profile.last_stat_database_srv1 2 2 8 0 etendo.profile.last_stat_tablespaces_srv1 1 1 52 0 etendo.profile.funcs_list 1 1 50 0 etendo.profile.sample_stat_user_func_total 1 1 90 0 etendo.profile.sample_stat_tablespaces 1 1 82 0 etendo.pg_catalog.pg_statistic 1 1 943 0 etendo.profile.last_extension_versions 2 2 112 0 etendo.profile.last_stat_slru 2 2 110 0 etendo.profile.indexes_list 2 2 69 0 etendo.pg_toast.pg_toast_2619 1 1 250 0 etendo.profile.last_stat_io 3 3 91 0 etendo.profile.stmt_list 2 2 153 0 Total 85 83 129,376 675 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 19 07 6 13 08 6 4 09 6 8 10 5 5 11 6 7 12 4 6 13 9 6 14 4 5 15 4 9 16 6 9 17 5 6 18 7 8 19 4 10 20 8 4 21 5 7 22 0 0 - 0.33 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
- 44,096 Total read queries
- 5,928 Total write queries
Queries by database
Key values
- etendo Main database
- 145,283 Requests
- 2m27s (etendo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 144,203 Requests
User Request type Count Duration postgres Total 9,660 16s946ms others 2,835 0ms select 1,905 0ms tcl 90 0ms tad Total 144,203 2m14s insert 18 0ms others 480 0ms select 42,191 0ms tcl 5,661 0ms update 159 0ms Duration by user
Key values
- 2m14s (tad) Main time consuming user
User Request type Count Duration postgres Total 9,660 16s946ms others 2,835 0ms select 1,905 0ms tcl 90 0ms tad Total 144,203 2m14s insert 18 0ms others 480 0ms select 42,191 0ms tcl 5,661 0ms update 159 0ms Queries by host
Key values
- 127.0.0.1 Main host
- 144,203 Requests
- 2m14s (127.0.0.1)
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 137,843 Requests
- 1m59s (openbravo)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-19 07:03:48 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 92,324 0-1ms duration
Slowest individual queries
Rank Duration Query NO DATASET
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 1,805 0ms 0ms 0ms select ? from dual;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 07 120 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 120 0ms 0ms 12 120 0ms 0ms 13 120 0ms 0ms 14 120 0ms 0ms 15 120 0ms 0ms 16 120 0ms 0ms 17 120 0ms 0ms 18 120 0ms 0ms 19 122 0ms 0ms 20 120 0ms 0ms 21 121 0ms 0ms 22 2 0ms 0ms 2 0ms 2 0ms 0ms 0ms select * from ( select a_amortization_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, a.ad_org_id, a.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, a.a_amortization_id, ?) as record_id from a_amortization a, fact_acct f1, fact_acct f2 where f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id and f1.record_id = a.a_amortization_id group by a.a_amortization_id, a.ad_org_id, a.ad_client_id, f1.ad_table_id, f1.record_id) 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 #2
Day Hour Count Duration Avg duration Jul 19 15 1 0ms 0ms 21 1 0ms 0ms 3 0ms 4 0ms 0ms 0ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select a_amortization_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id, ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, a_amortization_id, ?) as record_id, posted from a_amortization where a_amortization.posted in (...) group by a_amortization_id, posted, ad_client_id, ad_org_id) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 15 2 0ms 0ms 21 2 0ms 0ms 4 0ms 2 0ms 0ms 0ms select * from ( select distinct iol.m_product_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || p.name || ? as description, ? as isactive, iol.ad_org_id as ad_org_id, iol.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, p.name as record_id from m_inoutline iol join m_inout io on iol.m_inout_id = io.m_inout_id and io.issotrx = ? and io.docstatus = ? join m_product p on iol.m_product_id = p.m_product_id join m_transaction t on iol.m_inoutline_id = t.m_inoutline_id join c_bpartner bp on io.c_bpartner_id = bp.c_bpartner_id join c_doctype dt on io.c_doctype_id = dt.c_doctype_id and dt.isreturn = ? join m_costing_rule cr on ad_isorgincluded (io.ad_org_id, cr.ad_org_id, io.ad_client_id) >= ? and cr.datefrom <= t.trxprocessdate and cr.dateto > t.trxprocessdate join m_costing_algorithm ca on cr.m_costing_algorithm_id = ca.m_costing_algorithm_id and ca.classname = ? where iol.movementqty < ? and not exists ( select ? from m_costing c where c.m_product_id = iol.m_product_id and c.costtype in (...) and c.datefrom <= t.trxprocessdate and c.dateto > t.trxprocessdate) and not exists ( select ? from m_productprice pp join m_pricelist_version ppv on pp.m_pricelist_version_id = ppv.m_pricelist_version_id join m_pricelist pl on pl.m_pricelist_id = ppv.m_pricelist_id where pp.m_product_id = iol.m_product_id and (bp.po_pricelist_id = ppv.m_pricelist_id or (bp.po_pricelist_id is null and pl.issopricelist = ?)) and ppv.validfrom <= t.trxprocessdate)) 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 #4
Day Hour Count Duration Avg duration Jul 19 15 1 0ms 0ms 21 1 0ms 0ms 5 0ms 1,807 0ms 0ms 0ms select adpreferen0_.ad_preference_id as ad_prefe1_83_, adpreferen0_.ad_client_id as ad_clien2_83_, adpreferen0_.ad_org_id as ad_org_i3_83_, adpreferen0_.isactive as isactive4_83_, adpreferen0_.created as created5_83_, adpreferen0_.createdby as createdb6_83_, adpreferen0_.updated as updated7_83_, adpreferen0_.updatedby as updatedb8_83_, adpreferen0_.ad_window_id as ad_windo9_83_, adpreferen0_.ad_user_id as ad_user10_83_, adpreferen0_.attribute as attribu11_83_, adpreferen0_.value as value12_83_, adpreferen0_.property as propert13_83_, adpreferen0_.ispropertylist as isprope14_83_, adpreferen0_.visibleat_client_id as visible15_83_, adpreferen0_.visibleat_org_id as visible16_83_, adpreferen0_.visibleat_role_id as visible17_83_, adpreferen0_.selected as selecte18_83_, adpreferen0_.ad_module_id as ad_modu19_83_, adpreferen0_.inherited_from as inherit20_83_ from ad_preference adpreferen0_ where (adpreferen0_.value like ?) and adpreferen0_.property = ? and (adpreferen0_.visibleat_client_id is null or adpreferen0_.visibleat_client_id = ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 19 07 120 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 120 0ms 0ms 12 120 0ms 0ms 13 120 0ms 0ms 14 121 0ms 0ms 15 121 0ms 0ms 16 121 0ms 0ms 17 120 0ms 0ms 18 120 0ms 0ms 19 121 0ms 0ms 20 122 0ms 0ms 21 121 0ms 0ms 6 0ms 2 0ms 0ms 0ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select c_bp_group_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id as ad_org_id, ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_bp_group_id, ?) as record_id from c_bp_group bpg where exists ( select d.c_acctschema_id from c_acctschema_default d where exists ( select ? from ad_org_acctschema where (ad_isorgincluded (ad_org_id, bpg.ad_org_id, bpg.ad_client_id) <> ? or ad_isorgincluded (bpg.ad_org_id, ad_org_id, bpg.ad_client_id) <> ?) and isactive = ? and ad_org_acctschema.c_acctschema_id = d.c_acctschema_id and ad_org_acctschema.ad_client_id = bpg.ad_client_id) and not exists ( select bpga.c_acctschema_id from c_bp_group_acct bpga where bpga.c_bp_group_id = bpg.c_bp_group_id))) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 19 15 1 0ms 0ms 21 1 0ms 0ms 7 0ms 6 0ms 0ms 0ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, c_invoice.ad_org_id as ad_org_id, c_invoice.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id, posted from c_invoice, c_doctype where c_invoice.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype in (...) and c_invoice.posted in (...) group by c_invoice_id, posted, c_invoice.ad_org_id, c_invoice.ad_client_id) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 19 15 3 0ms 0ms 21 3 0ms 0ms 8 0ms 90 0ms 0ms 0ms select round(?.? * sum(n_dead_tup) / nullif (sum(n_live_tup) + sum(n_dead_tup), ?), ?) as dead_tuple_percent from pg_stat_user_tables;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 19 07 6 0ms 0ms 08 6 0ms 0ms 09 6 0ms 0ms 10 6 0ms 0ms 11 6 0ms 0ms 12 6 0ms 0ms 13 6 0ms 0ms 14 6 0ms 0ms 15 6 0ms 0ms 16 6 0ms 0ms 17 6 0ms 0ms 18 6 0ms 0ms 19 6 0ms 0ms 20 6 0ms 0ms 21 6 0ms 0ms 9 0ms 540 0ms 0ms 0ms select version();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 19 07 36 0ms 0ms 08 36 0ms 0ms 09 36 0ms 0ms 10 36 0ms 0ms 11 36 0ms 0ms 12 36 0ms 0ms 13 36 0ms 0ms 14 36 0ms 0ms 15 36 0ms 0ms 16 36 0ms 0ms 17 36 0ms 0ms 18 36 0ms 0ms 19 36 0ms 0ms 20 36 0ms 0ms 21 36 0ms 0ms 10 0ms 2 0ms 0ms 0ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select j.gl_journal_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, j.ad_org_id, j.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, j.gl_journal_id, ?) as record_id from gl_journal j, fact_acct f1, fact_acct f2 where f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id and j.gl_journal_id = f1.record_id group by f1.ad_table_id, f1.record_id, j.gl_journal_id, j.ad_org_id, j.ad_client_id) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 19 15 1 0ms 0ms 21 1 0ms 0ms 11 0ms 15 0ms 0ms 0ms select ? as id from dual where exists ( select ? from ( select a.dateacct as dateacct from rem_remittanceline_return a where a.ad_client_id = ? and a.ad_org_id in (...) and a.posted = ? and a.processed = ? and (a.processing = ? or a.processing is null) and exists ( select ? from c_period p where a.dateacct >= p.startdate and a.dateacct < p.enddate + ? and exists ( select ? from c_periodcontrol pc where pc.c_period_id = p.c_period_id and ad_org_getperiodcontrolallow (a.ad_org_id) = pc.ad_org_id and pc.docbasetype = ? and pc.periodstatus = ?))) b where ? = ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 19 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 12 0ms 4 0ms 0ms 0ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select record_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id, ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, record_id, ?) as record_id from fact_acct where ad_table_id = ? and docbasetype = ? and exists ( select ? from c_acctschema_gl, c_validcombination where c_acctschema_gl.suspensebalancing_acct = c_validcombination.c_validcombination_id and c_validcombination.account_id = fact_acct.account_id and c_acctschema_gl.c_acctschema_id = fact_acct.c_acctschema_id) group by fact_acct_group_id, record_id, ad_client_id, ad_org_id) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 19 15 2 0ms 0ms 21 2 0ms 0ms 13 0ms 16 0ms 0ms 0ms select organizati0_.ad_org_id as ad_org_i1_71_, organizati0_.ad_client_id as ad_clien2_71_, organizati0_.isactive as isactive3_71_, organizati0_.created as created4_71_, organizati0_.createdby as createdb5_71_, organizati0_.updated as updated6_71_, organizati0_.updatedby as updatedb7_71_, organizati0_.value as value8_71_, organizati0_.name as name9_71_, organizati0_.description as descrip10_71_, organizati0_.issummary as issumma11_71_, organizati0_.ad_orgtype_id as ad_orgt12_71_, organizati0_.isperiodcontrolallowed as isperio13_71_, organizati0_.c_calendar_id as c_calen14_71_, organizati0_.isready as isready15_71_, organizati0_.social_name as social_16_71_, organizati0_.c_currency_id as c_curre17_71_, organizati0_.c_acctschema_id as c_accts18_71_, organizati0_.em_aprm_glitem_id as em_aprm19_71_, organizati0_.ad_periodcontrolallowed_org_id as ad_peri20_71_, organizati0_.ad_calendarowner_org_id as ad_cale21_71_, organizati0_.ad_legalentity_org_id as ad_lega22_71_, organizati0_.ad_inheritedcalendar_id as ad_inhe23_71_, organizati0_.ad_businessunit_org_id as ad_busi24_71_, organizati0_.c_extbp_enabled as c_extbp25_71_, organizati0_.c_extbp_config_id as c_extbp26_71_ from ad_org organizati0_ where organizati0_.ad_org_id = ? limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 19 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 2 0ms 0ms 14 0ms 2 0ms 0ms 0ms select * from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, c_invoice.ad_org_id as ad_org_id, c_invoice.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id, posted from c_invoice, c_doctype where c_invoice.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype in (...) and c_invoice.processed <> ? and c_invoice.updated < now() ? group by c_invoice_id, posted, c_invoice.ad_client_id, c_invoice.ad_org_id) 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 #14
Day Hour Count Duration Avg duration Jul 19 15 1 0ms 0ms 21 1 0ms 0ms 15 0ms 450 0ms 0ms 0ms select coalesce(string_agg(pro.name || ? || round(extract(epoch from (now() - run.start_time)) / ?) || ?, e ?), ?) from ad_process_run run join ad_process_request req on req.ad_process_request_id = run.ad_process_request_id join ad_process pro on pro.ad_process_id = req.ad_process_id where extract(epoch from (now() - run.start_time)) / ? > ? and run.end_time is null and run.status = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 19 07 30 0ms 0ms 08 30 0ms 0ms 09 30 0ms 0ms 10 30 0ms 0ms 11 30 0ms 0ms 12 30 0ms 0ms 13 30 0ms 0ms 14 30 0ms 0ms 15 30 0ms 0ms 16 30 0ms 0ms 17 30 0ms 0ms 18 30 0ms 0ms 19 30 0ms 0ms 20 30 0ms 0ms 21 30 0ms 0ms 16 0ms 180 0ms 0ms 0ms values (?, ?, ?), (?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 19 07 12 0ms 0ms 08 12 0ms 0ms 09 12 0ms 0ms 10 12 0ms 0ms 11 12 0ms 0ms 12 12 0ms 0ms 13 12 0ms 0ms 14 12 0ms 0ms 15 12 0ms 0ms 16 12 0ms 0ms 17 12 0ms 0ms 18 12 0ms 0ms 19 12 0ms 0ms 20 12 0ms 0ms 21 12 0ms 0ms 17 0ms 2 0ms 0ms 0ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select distinct il.m_product_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || p.name || ? as description, ? as isactive, il.ad_org_id as ad_org_id, il.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, p.m_product_id, ?) as record_id from m_internal_consumptionline il join m_internal_consumption i on i.m_internal_consumption_id = il.m_internal_consumption_id join m_transaction t on il.m_internal_consumptionline_id = t.m_internal_consumptionline_id join m_product p on il.m_product_id = p.m_product_id join m_costing_rule cr on ad_isorgincluded (i.ad_org_id, cr.ad_org_id, i.ad_client_id) >= ? and cr.datefrom <= t.trxprocessdate and cr.dateto > t.trxprocessdate join m_costing_algorithm ca on cr.m_costing_algorithm_id = ca.m_costing_algorithm_id and ca.classname = ? where t.movementqty > ? and not exists ( select ? from m_costing c where c.m_product_id = il.m_product_id and c.costtype in (...) and c.datefrom <= t.trxprocessdate and c.dateto > t.trxprocessdate) and not exists ( select ? from m_productprice pp join m_pricelist_version ppv on pp.m_pricelist_version_id = ppv.m_pricelist_version_id join m_pricelist pl on pl.m_pricelist_id = ppv.m_pricelist_id where pp.m_product_id = il.m_product_id and pl.issopricelist = ? and ppv.validfrom <= t.trxprocessdate)) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 19 15 1 0ms 0ms 21 1 0ms 0ms 18 0ms 2 0ms 0ms 0ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, c_invoice.ad_org_id as ad_org_id, c_invoice.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id, posted from c_invoice, c_doctype where c_invoice.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype in (...) and not exists ( select ? from c_period where c_period.startdate <= trunc(dateacct) and trunc(dateacct) <= c_period.enddate) group by c_invoice_id, posted, c_invoice.ad_org_id, c_invoice.ad_client_id) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 19 15 1 0ms 0ms 21 1 0ms 0ms 19 0ms 30 0ms 0ms 0ms select ? as id from dual where exists ( select ? from ( select a.paymentdate as dateacct from fin_payment a where a.ad_client_id = ? and a.ad_org_id in (...) and a.posted = ? and a.processed = ? and (a.processing = ? or a.processing is null) and exists ( select ? from c_period p where a.paymentdate >= p.startdate and a.paymentdate < p.enddate + ? and exists ( select ? from c_periodcontrol pc where pc.c_period_id = p.c_period_id and ad_org_getperiodcontrolallow (a.ad_org_id) = pc.ad_org_id and pc.docbasetype = ? and pc.periodstatus = ?))) b where ? = ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 19 08 2 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 18 2 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms 22 2 0ms 0ms 20 0ms 540 0ms 0ms 0ms select count(datid) as current, ( select setting as mc from pg_settings where name = ?) as mc, d.datname from pg_database d left join pg_stat_activity s on (s.datid = d.oid) group by ?, ? order by datname;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 19 07 36 0ms 0ms 08 36 0ms 0ms 09 36 0ms 0ms 10 36 0ms 0ms 11 36 0ms 0ms 12 36 0ms 0ms 13 36 0ms 0ms 14 36 0ms 0ms 15 36 0ms 0ms 16 36 0ms 0ms 17 36 0ms 0ms 18 36 0ms 0ms 19 36 0ms 0ms 20 36 0ms 0ms 21 36 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 21,819 0ms 0ms 0ms 0ms select coalesce(t.msgtext, m.msgtext) as msgtext from ad_message m left join ad_message_trl t on m.ad_message_id = t.ad_message_id and t.ad_language = ? where m.value = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 07 1,440 0ms 0ms 08 1,449 0ms 0ms 09 1,449 0ms 0ms 10 1,449 0ms 0ms 11 1,449 0ms 0ms 12 1,449 0ms 0ms 13 1,449 0ms 0ms 14 1,461 0ms 0ms 15 1,461 0ms 0ms 16 1,461 0ms 0ms 17 1,449 0ms 0ms 18 1,449 0ms 0ms 19 1,461 0ms 0ms 20 1,473 0ms 0ms 21 1,461 0ms 0ms 22 9 0ms 0ms 2 2,875 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 07 190 0ms 0ms 08 191 0ms 0ms 09 191 0ms 0ms 10 191 0ms 0ms 11 191 0ms 0ms 12 191 0ms 0ms 13 191 0ms 0ms 14 192 0ms 0ms 15 192 0ms 0ms 16 192 0ms 0ms 17 191 0ms 0ms 18 191 0ms 0ms 19 193 0ms 0ms 20 193 0ms 0ms 21 192 0ms 0ms 22 3 0ms 0ms 3 2,831 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 07 187 0ms 0ms 08 188 0ms 0ms 09 188 0ms 0ms 10 188 0ms 0ms 11 188 0ms 0ms 12 188 0ms 0ms 13 188 0ms 0ms 14 189 0ms 0ms 15 189 0ms 0ms 16 189 0ms 0ms 17 188 0ms 0ms 18 188 0ms 0ms 19 190 0ms 0ms 20 190 0ms 0ms 21 189 0ms 0ms 22 4 0ms 0ms 4 1,980 0ms 0ms 0ms 0ms show server_version;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 19 07 132 0ms 0ms 08 132 0ms 0ms 09 132 0ms 0ms 10 132 0ms 0ms 11 132 0ms 0ms 12 132 0ms 0ms 13 132 0ms 0ms 14 132 0ms 0ms 15 132 0ms 0ms 16 132 0ms 0ms 17 132 0ms 0ms 18 132 0ms 0ms 19 132 0ms 0ms 20 132 0ms 0ms 21 132 0ms 0ms 5 1,839 0ms 0ms 0ms 0ms select adlanguage0_.ad_language_id as ad_langu1_52_0_, adlanguage0_.ad_language as ad_langu2_52_0_, adlanguage0_.ad_client_id as ad_clien3_52_0_, adlanguage0_.ad_org_id as ad_org_i4_52_0_, adlanguage0_.isactive as isactive5_52_0_, adlanguage0_.created as created6_52_0_, adlanguage0_.createdby as createdb7_52_0_, adlanguage0_.updated as updated8_52_0_, adlanguage0_.updatedby as updatedb9_52_0_, adlanguage0_.name as name10_52_0_, adlanguage0_.languageiso as languag11_52_0_, adlanguage0_.countrycode as country12_52_0_, adlanguage0_.isbaselanguage as isbasel13_52_0_, adlanguage0_.issystemlanguage as issyste14_52_0_, adlanguage0_.processing as process15_52_0_, adlanguage0_.pixelsize as pixelsi16_52_0_, adlanguage0_.translatedby as transla17_52_0_, adlanguage0_.isrtl as isrtl18_52_0_ from ad_language adlanguage0_ where adlanguage0_.ad_language = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 19 07 120 0ms 0ms 08 122 0ms 0ms 09 122 0ms 0ms 10 122 0ms 0ms 11 122 0ms 0ms 12 122 0ms 0ms 13 122 0ms 0ms 14 123 0ms 0ms 15 123 0ms 0ms 16 123 0ms 0ms 17 122 0ms 0ms 18 122 0ms 0ms 19 123 0ms 0ms 20 124 0ms 0ms 21 123 0ms 0ms 22 4 0ms 0ms 6 1,807 0ms 0ms 0ms 0ms select adpreferen0_.ad_preference_id as ad_prefe1_83_, adpreferen0_.ad_client_id as ad_clien2_83_, adpreferen0_.ad_org_id as ad_org_i3_83_, adpreferen0_.isactive as isactive4_83_, adpreferen0_.created as created5_83_, adpreferen0_.createdby as createdb6_83_, adpreferen0_.updated as updated7_83_, adpreferen0_.updatedby as updatedb8_83_, adpreferen0_.ad_window_id as ad_windo9_83_, adpreferen0_.ad_user_id as ad_user10_83_, adpreferen0_.attribute as attribu11_83_, adpreferen0_.value as value12_83_, adpreferen0_.property as propert13_83_, adpreferen0_.ispropertylist as isprope14_83_, adpreferen0_.visibleat_client_id as visible15_83_, adpreferen0_.visibleat_org_id as visible16_83_, adpreferen0_.visibleat_role_id as visible17_83_, adpreferen0_.selected as selecte18_83_, adpreferen0_.ad_module_id as ad_modu19_83_, adpreferen0_.inherited_from as inherit20_83_ from ad_preference adpreferen0_ where (adpreferen0_.value like ?) and adpreferen0_.property = ? and (adpreferen0_.visibleat_client_id is null or adpreferen0_.visibleat_client_id = ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 19 07 120 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 120 0ms 0ms 12 120 0ms 0ms 13 120 0ms 0ms 14 121 0ms 0ms 15 121 0ms 0ms 16 121 0ms 0ms 17 120 0ms 0ms 18 120 0ms 0ms 19 121 0ms 0ms 20 122 0ms 0ms 21 121 0ms 0ms 7 1,807 0ms 0ms 0ms 0ms select adclient0_.ad_client_id as ad_clien1_18_0_, adclient0_.ad_org_id as ad_org_i2_18_0_, adclient0_.isactive as isactive3_18_0_, adclient0_.created as created4_18_0_, adclient0_.createdby as createdb5_18_0_, adclient0_.updated as updated6_18_0_, adclient0_.updatedby as updatedb7_18_0_, adclient0_.value as value8_18_0_, adclient0_.name as name9_18_0_, adclient0_.description as descrip10_18_0_, adclient0_.smtphost as smtphos11_18_0_, adclient0_.requestemail as request12_18_0_, adclient0_.requestuser as request13_18_0_, adclient0_.requestuserpw as request14_18_0_, adclient0_.requestfolder as request15_18_0_, adclient0_.ad_language as ad_lang16_18_0_, adclient0_.ismultilingualdocument as ismulti17_18_0_, adclient0_.issmtpauthorization as issmtpa18_18_0_, adclient0_.c_currency_id as c_curre19_18_0_, adclient0_.acctdim_centrally_maintained as acctdim20_18_0_, adclient0_.project_acctdim_isenable as project21_18_0_, adclient0_.project_acctdim_header as project22_18_0_, adclient0_.project_acctdim_lines as project23_18_0_, adclient0_.project_acctdim_breakdown as project24_18_0_, adclient0_.bpartner_acctdim_isenable as bpartne25_18_0_, adclient0_.bpartner_acctdim_header as bpartne26_18_0_, adclient0_.bpartner_acctdim_lines as bpartne27_18_0_, adclient0_.bpartner_acctdim_breakdown as bpartne28_18_0_, adclient0_.product_acctdim_isenable as product29_18_0_, adclient0_.product_acctdim_header as product30_18_0_, adclient0_.product_acctdim_lines as product31_18_0_, adclient0_.product_acctdim_breakdown as product32_18_0_, adclient0_.costcenter_acctdim_header as costcen33_18_0_, adclient0_.costcenter_acctdim_lines as costcen34_18_0_, adclient0_.costcenter_acctdim_breakdown as costcen35_18_0_, adclient0_.user1_acctdim_isenable as user36_18_0_, adclient0_.user1_acctdim_header as user37_18_0_, adclient0_.user1_acctdim_lines as user38_18_0_, adclient0_.user1_acctdim_breakdown as user39_18_0_, adclient0_.user2_acctdim_isenable as user40_18_0_, adclient0_.user2_acctdim_header as user41_18_0_, adclient0_.user2_acctdim_lines as user42_18_0_, adclient0_.user2_acctdim_breakdown as user43_18_0_, adclient0_.costcenter_acctdim_isenable as costcen44_18_0_, adclient0_.org_acctdim_isenable as org_acc45_18_0_, adclient0_.org_acctdim_header as org_acc46_18_0_, adclient0_.org_acctdim_lines as org_acc47_18_0_, adclient0_.org_acctdim_breakdown as org_acc48_18_0_, adclient0_.daystopasswordexpiration as daystop49_18_0_ from ad_client adclient0_ where adclient0_.ad_client_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 19 07 120 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 120 0ms 0ms 12 120 0ms 0ms 13 120 0ms 0ms 14 121 0ms 0ms 15 121 0ms 0ms 16 121 0ms 0ms 17 120 0ms 0ms 18 120 0ms 0ms 19 121 0ms 0ms 20 122 0ms 0ms 21 121 0ms 0ms 8 1,807 0ms 0ms 0ms 0ms select adpreferen0_.ad_preference_id as ad_prefe1_83_, adpreferen0_.ad_client_id as ad_clien2_83_, adpreferen0_.ad_org_id as ad_org_i3_83_, adpreferen0_.isactive as isactive4_83_, adpreferen0_.created as created5_83_, adpreferen0_.createdby as createdb6_83_, adpreferen0_.updated as updated7_83_, adpreferen0_.updatedby as updatedb8_83_, adpreferen0_.ad_window_id as ad_windo9_83_, adpreferen0_.ad_user_id as ad_user10_83_, adpreferen0_.attribute as attribu11_83_, adpreferen0_.value as value12_83_, adpreferen0_.property as propert13_83_, adpreferen0_.ispropertylist as isprope14_83_, adpreferen0_.visibleat_client_id as visible15_83_, adpreferen0_.visibleat_org_id as visible16_83_, adpreferen0_.visibleat_role_id as visible17_83_, adpreferen0_.selected as selecte18_83_, adpreferen0_.ad_module_id as ad_modu19_83_, adpreferen0_.inherited_from as inherit20_83_ from ad_preference adpreferen0_ where coalesce(adpreferen0_.visibleat_client_id, ?) = ? and (adpreferen0_.visibleat_role_id is null) and (coalesce(adpreferen0_.visibleat_org_id, ?) in (...)) and (adpreferen0_.ad_user_id is null) and (adpreferen0_.ad_window_id is null) and adpreferen0_.ispropertylist = ? and adpreferen0_.property = ? and (adpreferen0_.ad_org_id in (...)) and (adpreferen0_.ad_client_id in (...)) and adpreferen0_.isactive = ? order by adpreferen0_.ad_preference_id;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 19 07 120 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 120 0ms 0ms 12 120 0ms 0ms 13 120 0ms 0ms 14 121 0ms 0ms 15 121 0ms 0ms 16 121 0ms 0ms 17 120 0ms 0ms 18 120 0ms 0ms 19 121 0ms 0ms 20 122 0ms 0ms 21 121 0ms 0ms 9 1,807 0ms 0ms 0ms 0ms select adsystem0_.ad_system_id as ad_syste1_115_0_, adsystem0_.ad_client_id as ad_clien2_115_0_, adsystem0_.ad_org_id as ad_org_i3_115_0_, adsystem0_.isactive as isactive4_115_0_, adsystem0_.created as created5_115_0_, adsystem0_.createdby as createdb6_115_0_, adsystem0_.updated as updated7_115_0_, adsystem0_.updatedby as updatedb8_115_0_, adsystem0_.name as name9_115_0_, adsystem0_.info as info10_115_0_, adsystem0_.version as version11_115_0_, adsystem0_.releaseno as release12_115_0_, adsystem0_.tad_recordrange as tad_rec13_115_0_, adsystem0_.tad_recordrange_info as tad_rec14_115_0_, adsystem0_.tad_transactionalrange as tad_tra15_115_0_, adsystem0_.tad_theme as tad_the16_115_0_, adsystem0_.instance_key as instanc17_115_0_, adsystem0_.activation_key as activat18_115_0_ from ad_system adsystem0_ where adsystem0_.ad_system_id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 19 07 120 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 120 0ms 0ms 12 120 0ms 0ms 13 120 0ms 0ms 14 121 0ms 0ms 15 121 0ms 0ms 16 121 0ms 0ms 17 120 0ms 0ms 18 120 0ms 0ms 19 121 0ms 0ms 20 122 0ms 0ms 21 121 0ms 0ms 10 1,807 0ms 0ms 0ms 0ms select text.filename as filename, text.text as text, text.isused as isused, text.ad_module_id as moduleid, texttrl.ad_language as trllang, texttrl.text as trltext, texttrl.istranslated as istranslated, ? as orderseq from ad_textinterfaces text, ad_textinterfaces_trl texttrl where text.ad_textinterfaces_id = texttrl.ad_textinterfaces_id and text.filename = ? and text.isused = ? and texttrl.ad_language = ? union select text.filename as filename, text.text as text, text.isused as isused, text.ad_module_id as moduleid, texttrl.ad_language as trllang, texttrl.text as trltext, texttrl.istranslated as istranslated, ? as orderseq from ad_textinterfaces text, ad_textinterfaces_trl texttrl where text.ad_textinterfaces_id = texttrl.ad_textinterfaces_id and text.filename is null and text.isused = ? and texttrl.ad_language = ? union select text.filename as filename, text.text as text, text.isused as isused, text.ad_module_id as moduleid, ? as trllang, text.text as trltext, ? as istranslated, ? as orderseq from ad_textinterfaces text where text.ad_textinterfaces_id not in ( select t.ad_textinterfaces_id from ad_textinterfaces t, ad_textinterfaces_trl trl where t.ad_textinterfaces_id = trl.ad_textinterfaces_id and trl.ad_language = ?) and (text.filename is null or text.filename = ?) and text.isused = ? order by orderseq;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 19 07 120 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 120 0ms 0ms 12 120 0ms 0ms 13 120 0ms 0ms 14 121 0ms 0ms 15 121 0ms 0ms 16 121 0ms 0ms 17 120 0ms 0ms 18 120 0ms 0ms 19 121 0ms 0ms 20 122 0ms 0ms 21 121 0ms 0ms 11 1,807 0ms 0ms 0ms 0ms select adsystemin0_.ad_system_info_id as ad_syste1_116_0_, adsystemin0_.ad_client_id as ad_clien2_116_0_, adsystemin0_.ad_org_id as ad_org_i3_116_0_, adsystemin0_.isactive as isactive4_116_0_, adsystemin0_.created as created5_116_0_, adsystemin0_.createdby as createdb6_116_0_, adsystemin0_.updated as updated7_116_0_, adsystemin0_.updatedby as updatedb8_116_0_, adsystemin0_.system_identifier as system_i9_116_0_, adsystemin0_.isheartbeatactive as isheart10_116_0_, adsystemin0_.postpone_date as postpon11_116_0_, adsystemin0_.isproxyrequired as isproxy12_116_0_, adsystemin0_.proxy_server as proxy_s13_116_0_, adsystemin0_.proxy_port as proxy_p14_116_0_, adsystemin0_.testproxy as testpro15_116_0_, adsystemin0_.ant_version as ant_ver16_116_0_, adsystemin0_.ob_version as ob_vers17_116_0_, adsystemin0_.ob_installmode as ob_inst18_116_0_, adsystemin0_.webserver as webserv19_116_0_, adsystemin0_.webserver_version as webserv20_116_0_, adsystemin0_.customization_allowed as customi21_116_0_, adsystemin0_.last_build as last_bu22_116_0_, adsystemin0_.last_dbupdate as last_db23_116_0_, adsystemin0_.db_checksum as db_chec24_116_0_, adsystemin0_.your_company_login_image as your_co25_116_0_, adsystemin0_.your_it_service_login_image as your_it26_116_0_, adsystemin0_.your_company_menu_image as your_co27_116_0_, adsystemin0_.your_company_big_image as your_co28_116_0_, adsystemin0_.your_company_document_image as your_co29_116_0_, adsystemin0_.support_contact as support30_116_0_, adsystemin0_.system_status as system_31_116_0_, adsystemin0_.maturity_update as maturit32_116_0_, adsystemin0_.maturity_search as maturit33_116_0_, adsystemin0_.isproxy_authenticated as isproxy34_116_0_, adsystemin0_.proxy_user as proxy_u35_116_0_, adsystemin0_.proxy_password as proxy_p36_116_0_, adsystemin0_.instance_purpose as instanc37_116_0_, adsystemin0_.isusageauditenabled as isusage38_116_0_, adsystemin0_.change_instance_purpose as change_39_116_0_, adsystemin0_.show_community_branding as show_co40_116_0_, adsystemin0_.production_banner_image_id as product41_116_0_, adsystemin0_.em_prbck_company_test_image as em_prbc42_116_0_, adsystemin0_.yourcompanyurl as yourcom43_116_0_ from ad_system_info adsystemin0_ where adsystemin0_.ad_system_info_id = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 19 07 120 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 120 0ms 0ms 12 120 0ms 0ms 13 120 0ms 0ms 14 121 0ms 0ms 15 121 0ms 0ms 16 121 0ms 0ms 17 120 0ms 0ms 18 120 0ms 0ms 19 121 0ms 0ms 20 122 0ms 0ms 21 121 0ms 0ms 12 1,805 0ms 0ms 0ms 0ms select ? from dual;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 19 07 120 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 120 0ms 0ms 12 120 0ms 0ms 13 120 0ms 0ms 14 120 0ms 0ms 15 120 0ms 0ms 16 120 0ms 0ms 17 120 0ms 0ms 18 120 0ms 0ms 19 122 0ms 0ms 20 120 0ms 0ms 21 121 0ms 0ms 22 2 0ms 0ms 13 540 0ms 0ms 0ms 0ms select version();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 19 07 36 0ms 0ms 08 36 0ms 0ms 09 36 0ms 0ms 10 36 0ms 0ms 11 36 0ms 0ms 12 36 0ms 0ms 13 36 0ms 0ms 14 36 0ms 0ms 15 36 0ms 0ms 16 36 0ms 0ms 17 36 0ms 0ms 18 36 0ms 0ms 19 36 0ms 0ms 20 36 0ms 0ms 21 36 0ms 0ms 14 540 0ms 0ms 0ms 0ms select count(datid) as current, ( select setting as mc from pg_settings where name = ?) as mc, d.datname from pg_database d left join pg_stat_activity s on (s.datid = d.oid) group by ?, ? order by datname;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 19 07 36 0ms 0ms 08 36 0ms 0ms 09 36 0ms 0ms 10 36 0ms 0ms 11 36 0ms 0ms 12 36 0ms 0ms 13 36 0ms 0ms 14 36 0ms 0ms 15 36 0ms 0ms 16 36 0ms 0ms 17 36 0ms 0ms 18 36 0ms 0ms 19 36 0ms 0ms 20 36 0ms 0ms 21 36 0ms 0ms 15 540 0ms 0ms 0ms 0ms select ad_client_id, ad_org_id, isactive, updated, updatedby, alias, combination, description, isfullyqualified, c_acctschema_id, account_id, m_product_id, c_bpartner_id, ad_orgtrx_id, c_locfrom_id, c_locto_id, c_salesregion_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, ? as usesuspensebalancing, ? as suspensebalancing_acct, ? as usesuspenseerror, ? as suspenseerror_acct, ? as usecurrencybalancing, ? as currencybalancing_acct, ? as retainedearning_acct, ? as incomesummary_acct, ? as intercompanydueto_acct, ? as intercompanyduefrom_acct from c_validcombination where c_validcombination_id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 19 08 36 0ms 0ms 09 36 0ms 0ms 10 36 0ms 0ms 11 36 0ms 0ms 12 36 0ms 0ms 13 36 0ms 0ms 14 36 0ms 0ms 15 36 0ms 0ms 16 36 0ms 0ms 17 36 0ms 0ms 18 36 0ms 0ms 19 36 0ms 0ms 20 36 0ms 0ms 21 36 0ms 0ms 22 36 0ms 0ms 16 480 0ms 0ms 0ms 0ms set statement_timeout = ?; commit; select granted, mode, datname from pg_locks l right join pg_database d on (d.oid = l.database) where d.datallowconn;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 19 07 32 0ms 0ms 08 32 0ms 0ms 09 32 0ms 0ms 10 32 0ms 0ms 11 32 0ms 0ms 12 32 0ms 0ms 13 32 0ms 0ms 14 32 0ms 0ms 15 32 0ms 0ms 16 32 0ms 0ms 17 32 0ms 0ms 18 32 0ms 0ms 19 32 0ms 0ms 20 32 0ms 0ms 21 32 0ms 0ms 17 450 0ms 0ms 0ms 0ms select coalesce(string_agg(pro.name || ? || round(extract(epoch from (now() - run.start_time)) / ?) || ?, e ?), ?) from ad_process_run run join ad_process_request req on req.ad_process_request_id = run.ad_process_request_id join ad_process pro on pro.ad_process_id = req.ad_process_id where extract(epoch from (now() - run.start_time)) / ? > ? and run.end_time is null and run.status = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 19 07 30 0ms 0ms 08 30 0ms 0ms 09 30 0ms 0ms 10 30 0ms 0ms 11 30 0ms 0ms 12 30 0ms 0ms 13 30 0ms 0ms 14 30 0ms 0ms 15 30 0ms 0ms 16 30 0ms 0ms 17 30 0ms 0ms 18 30 0ms 0ms 19 30 0ms 0ms 20 30 0ms 0ms 21 30 0ms 0ms 18 450 0ms 0ms 0ms 0ms select coalesce(string_agg(pro.name || ? || round(extract(epoch from (now() - run.start_time)) / ?) || ?, e ?), ?) from ad_process_run run join ad_process_request req on req.ad_process_request_id = run.ad_process_request_id join ad_process pro on pro.ad_process_id = req.ad_process_id where ? = ? and pro.ad_process_id = ? and extract(epoch from (now() - run.start_time)) / ? > ? and run.end_time is null and run.status = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 19 07 30 0ms 0ms 08 30 0ms 0ms 09 30 0ms 0ms 10 30 0ms 0ms 11 30 0ms 0ms 12 30 0ms 0ms 13 30 0ms 0ms 14 30 0ms 0ms 15 30 0ms 0ms 16 30 0ms 0ms 17 30 0ms 0ms 18 30 0ms 0ms 19 30 0ms 0ms 20 30 0ms 0ms 21 30 0ms 0ms 19 450 0ms 0ms 0ms 0ms select c_import_e0_.c_import_entry_id as c_import1_227_, c_import_e0_.ad_client_id as ad_clien2_227_, c_import_e0_.ad_org_id as ad_org_i3_227_, c_import_e0_.isactive as isactive4_227_, c_import_e0_.created as created5_227_, c_import_e0_.createdby as createdb6_227_, c_import_e0_.updated as updated7_227_, c_import_e0_.updatedby as updatedb8_227_, c_import_e0_.imported as imported9_227_, c_import_e0_.jsoninfo as jsoninf10_227_, c_import_e0_.importstatus as imports11_227_, c_import_e0_.typeofdata as typeofd12_227_, c_import_e0_.errorinfo as errorin13_227_, c_import_e0_.ad_role_id as ad_role14_227_, c_import_e0_.createdtimestamp as created15_227_, c_import_e0_.responseinfo as respons16_227_ from c_import_entry c_import_e0_ where c_import_e0_.typeofdata = ? and c_import_e0_.importstatus = ? order by c_import_e0_.created, c_import_e0_.createdtimestamp limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 19 07 30 0ms 0ms 08 30 0ms 0ms 09 30 0ms 0ms 10 30 0ms 0ms 11 30 0ms 0ms 12 30 0ms 0ms 13 30 0ms 0ms 14 30 0ms 0ms 15 30 0ms 0ms 16 30 0ms 0ms 17 30 0ms 0ms 18 30 0ms 0ms 19 30 0ms 0ms 20 30 0ms 0ms 21 30 0ms 0ms 20 450 0ms 0ms 0ms 0ms select coalesce(string_agg(pro.name || ? || round(extract(epoch from (now() - run.start_time)) / ?) || ?, e ?), ?) from ad_process_run run join ad_process_request req on run.ad_process_request_id = req.ad_process_request_id join ad_process pro on req.ad_process_id = pro.ad_process_id where run.status = ? and extract(epoch from (now() - run.start_time)) > ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 19 07 30 0ms 0ms 08 30 0ms 0ms 09 30 0ms 0ms 10 30 0ms 0ms 11 30 0ms 0ms 12 30 0ms 0ms 13 30 0ms 0ms 14 30 0ms 0ms 15 30 0ms 0ms 16 30 0ms 0ms 17 30 0ms 0ms 18 30 0ms 0ms 19 30 0ms 0ms 20 30 0ms 0ms 21 30 0ms 0ms Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 0ms 0ms 1,805 0ms select ? from dual;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 07 120 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 120 0ms 0ms 12 120 0ms 0ms 13 120 0ms 0ms 14 120 0ms 0ms 15 120 0ms 0ms 16 120 0ms 0ms 17 120 0ms 0ms 18 120 0ms 0ms 19 122 0ms 0ms 20 120 0ms 0ms 21 121 0ms 0ms 22 2 0ms 0ms 2 0ms 0ms 0ms 2 0ms select * from ( select a_amortization_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, a.ad_org_id, a.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, a.a_amortization_id, ?) as record_id from a_amortization a, fact_acct f1, fact_acct f2 where f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id and f1.record_id = a.a_amortization_id group by a.a_amortization_id, a.ad_org_id, a.ad_client_id, f1.ad_table_id, f1.record_id) 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 #2
Day Hour Count Duration Avg duration Jul 19 15 1 0ms 0ms 21 1 0ms 0ms 3 0ms 0ms 0ms 4 0ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select a_amortization_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id, ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, a_amortization_id, ?) as record_id, posted from a_amortization where a_amortization.posted in (...) group by a_amortization_id, posted, ad_client_id, ad_org_id) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 15 2 0ms 0ms 21 2 0ms 0ms 4 0ms 0ms 0ms 2 0ms select * from ( select distinct iol.m_product_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || p.name || ? as description, ? as isactive, iol.ad_org_id as ad_org_id, iol.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, p.name as record_id from m_inoutline iol join m_inout io on iol.m_inout_id = io.m_inout_id and io.issotrx = ? and io.docstatus = ? join m_product p on iol.m_product_id = p.m_product_id join m_transaction t on iol.m_inoutline_id = t.m_inoutline_id join c_bpartner bp on io.c_bpartner_id = bp.c_bpartner_id join c_doctype dt on io.c_doctype_id = dt.c_doctype_id and dt.isreturn = ? join m_costing_rule cr on ad_isorgincluded (io.ad_org_id, cr.ad_org_id, io.ad_client_id) >= ? and cr.datefrom <= t.trxprocessdate and cr.dateto > t.trxprocessdate join m_costing_algorithm ca on cr.m_costing_algorithm_id = ca.m_costing_algorithm_id and ca.classname = ? where iol.movementqty < ? and not exists ( select ? from m_costing c where c.m_product_id = iol.m_product_id and c.costtype in (...) and c.datefrom <= t.trxprocessdate and c.dateto > t.trxprocessdate) and not exists ( select ? from m_productprice pp join m_pricelist_version ppv on pp.m_pricelist_version_id = ppv.m_pricelist_version_id join m_pricelist pl on pl.m_pricelist_id = ppv.m_pricelist_id where pp.m_product_id = iol.m_product_id and (bp.po_pricelist_id = ppv.m_pricelist_id or (bp.po_pricelist_id is null and pl.issopricelist = ?)) and ppv.validfrom <= t.trxprocessdate)) 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 #4
Day Hour Count Duration Avg duration Jul 19 15 1 0ms 0ms 21 1 0ms 0ms 5 0ms 0ms 0ms 1,807 0ms select adpreferen0_.ad_preference_id as ad_prefe1_83_, adpreferen0_.ad_client_id as ad_clien2_83_, adpreferen0_.ad_org_id as ad_org_i3_83_, adpreferen0_.isactive as isactive4_83_, adpreferen0_.created as created5_83_, adpreferen0_.createdby as createdb6_83_, adpreferen0_.updated as updated7_83_, adpreferen0_.updatedby as updatedb8_83_, adpreferen0_.ad_window_id as ad_windo9_83_, adpreferen0_.ad_user_id as ad_user10_83_, adpreferen0_.attribute as attribu11_83_, adpreferen0_.value as value12_83_, adpreferen0_.property as propert13_83_, adpreferen0_.ispropertylist as isprope14_83_, adpreferen0_.visibleat_client_id as visible15_83_, adpreferen0_.visibleat_org_id as visible16_83_, adpreferen0_.visibleat_role_id as visible17_83_, adpreferen0_.selected as selecte18_83_, adpreferen0_.ad_module_id as ad_modu19_83_, adpreferen0_.inherited_from as inherit20_83_ from ad_preference adpreferen0_ where (adpreferen0_.value like ?) and adpreferen0_.property = ? and (adpreferen0_.visibleat_client_id is null or adpreferen0_.visibleat_client_id = ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 19 07 120 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 120 0ms 0ms 12 120 0ms 0ms 13 120 0ms 0ms 14 121 0ms 0ms 15 121 0ms 0ms 16 121 0ms 0ms 17 120 0ms 0ms 18 120 0ms 0ms 19 121 0ms 0ms 20 122 0ms 0ms 21 121 0ms 0ms 6 0ms 0ms 0ms 2 0ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select c_bp_group_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id as ad_org_id, ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_bp_group_id, ?) as record_id from c_bp_group bpg where exists ( select d.c_acctschema_id from c_acctschema_default d where exists ( select ? from ad_org_acctschema where (ad_isorgincluded (ad_org_id, bpg.ad_org_id, bpg.ad_client_id) <> ? or ad_isorgincluded (bpg.ad_org_id, ad_org_id, bpg.ad_client_id) <> ?) and isactive = ? and ad_org_acctschema.c_acctschema_id = d.c_acctschema_id and ad_org_acctschema.ad_client_id = bpg.ad_client_id) and not exists ( select bpga.c_acctschema_id from c_bp_group_acct bpga where bpga.c_bp_group_id = bpg.c_bp_group_id))) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 19 15 1 0ms 0ms 21 1 0ms 0ms 7 0ms 0ms 0ms 6 0ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, c_invoice.ad_org_id as ad_org_id, c_invoice.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id, posted from c_invoice, c_doctype where c_invoice.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype in (...) and c_invoice.posted in (...) group by c_invoice_id, posted, c_invoice.ad_org_id, c_invoice.ad_client_id) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 19 15 3 0ms 0ms 21 3 0ms 0ms 8 0ms 0ms 0ms 90 0ms select round(?.? * sum(n_dead_tup) / nullif (sum(n_live_tup) + sum(n_dead_tup), ?), ?) as dead_tuple_percent from pg_stat_user_tables;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 19 07 6 0ms 0ms 08 6 0ms 0ms 09 6 0ms 0ms 10 6 0ms 0ms 11 6 0ms 0ms 12 6 0ms 0ms 13 6 0ms 0ms 14 6 0ms 0ms 15 6 0ms 0ms 16 6 0ms 0ms 17 6 0ms 0ms 18 6 0ms 0ms 19 6 0ms 0ms 20 6 0ms 0ms 21 6 0ms 0ms 9 0ms 0ms 0ms 540 0ms select version();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 19 07 36 0ms 0ms 08 36 0ms 0ms 09 36 0ms 0ms 10 36 0ms 0ms 11 36 0ms 0ms 12 36 0ms 0ms 13 36 0ms 0ms 14 36 0ms 0ms 15 36 0ms 0ms 16 36 0ms 0ms 17 36 0ms 0ms 18 36 0ms 0ms 19 36 0ms 0ms 20 36 0ms 0ms 21 36 0ms 0ms 10 0ms 0ms 0ms 2 0ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select j.gl_journal_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, j.ad_org_id, j.ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, j.gl_journal_id, ?) as record_id from gl_journal j, fact_acct f1, fact_acct f2 where f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id and j.gl_journal_id = f1.record_id group by f1.ad_table_id, f1.record_id, j.gl_journal_id, j.ad_org_id, j.ad_client_id) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 19 15 1 0ms 0ms 21 1 0ms 0ms 11 0ms 0ms 0ms 15 0ms select ? as id from dual where exists ( select ? from ( select a.dateacct as dateacct from rem_remittanceline_return a where a.ad_client_id = ? and a.ad_org_id in (...) and a.posted = ? and a.processed = ? and (a.processing = ? or a.processing is null) and exists ( select ? from c_period p where a.dateacct >= p.startdate and a.dateacct < p.enddate + ? and exists ( select ? from c_periodcontrol pc where pc.c_period_id = p.c_period_id and ad_org_getperiodcontrolallow (a.ad_org_id) = pc.ad_org_id and pc.docbasetype = ? and pc.periodstatus = ?))) b where ? = ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 19 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 12 0ms 0ms 0ms 4 0ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select record_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id, ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, record_id, ?) as record_id from fact_acct where ad_table_id = ? and docbasetype = ? and exists ( select ? from c_acctschema_gl, c_validcombination where c_acctschema_gl.suspensebalancing_acct = c_validcombination.c_validcombination_id and c_validcombination.account_id = fact_acct.account_id and c_acctschema_gl.c_acctschema_id = fact_acct.c_acctschema_id) group by fact_acct_group_id, record_id, ad_client_id, ad_org_id) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 19 15 2 0ms 0ms 21 2 0ms 0ms 13 0ms 0ms 0ms 16 0ms select organizati0_.ad_org_id as ad_org_i1_71_, organizati0_.ad_client_id as ad_clien2_71_, organizati0_.isactive as isactive3_71_, organizati0_.created as created4_71_, organizati0_.createdby as createdb5_71_, organizati0_.updated as updated6_71_, organizati0_.updatedby as updatedb7_71_, organizati0_.value as value8_71_, organizati0_.name as name9_71_, organizati0_.description as descrip10_71_, organizati0_.issummary as issumma11_71_, organizati0_.ad_orgtype_id as ad_orgt12_71_, organizati0_.isperiodcontrolallowed as isperio13_71_, organizati0_.c_calendar_id as c_calen14_71_, organizati0_.isready as isready15_71_, organizati0_.social_name as social_16_71_, organizati0_.c_currency_id as c_curre17_71_, organizati0_.c_acctschema_id as c_accts18_71_, organizati0_.em_aprm_glitem_id as em_aprm19_71_, organizati0_.ad_periodcontrolallowed_org_id as ad_peri20_71_, organizati0_.ad_calendarowner_org_id as ad_cale21_71_, organizati0_.ad_legalentity_org_id as ad_lega22_71_, organizati0_.ad_inheritedcalendar_id as ad_inhe23_71_, organizati0_.ad_businessunit_org_id as ad_busi24_71_, organizati0_.c_extbp_enabled as c_extbp25_71_, organizati0_.c_extbp_config_id as c_extbp26_71_ from ad_org organizati0_ where organizati0_.ad_org_id = ? limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 19 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 2 0ms 0ms 14 0ms 0ms 0ms 2 0ms select * from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, c_invoice.ad_org_id as ad_org_id, c_invoice.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id, posted from c_invoice, c_doctype where c_invoice.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype in (...) and c_invoice.processed <> ? and c_invoice.updated < now() ? group by c_invoice_id, posted, c_invoice.ad_client_id, c_invoice.ad_org_id) 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 #14
Day Hour Count Duration Avg duration Jul 19 15 1 0ms 0ms 21 1 0ms 0ms 15 0ms 0ms 0ms 450 0ms select coalesce(string_agg(pro.name || ? || round(extract(epoch from (now() - run.start_time)) / ?) || ?, e ?), ?) from ad_process_run run join ad_process_request req on req.ad_process_request_id = run.ad_process_request_id join ad_process pro on pro.ad_process_id = req.ad_process_id where extract(epoch from (now() - run.start_time)) / ? > ? and run.end_time is null and run.status = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 19 07 30 0ms 0ms 08 30 0ms 0ms 09 30 0ms 0ms 10 30 0ms 0ms 11 30 0ms 0ms 12 30 0ms 0ms 13 30 0ms 0ms 14 30 0ms 0ms 15 30 0ms 0ms 16 30 0ms 0ms 17 30 0ms 0ms 18 30 0ms 0ms 19 30 0ms 0ms 20 30 0ms 0ms 21 30 0ms 0ms 16 0ms 0ms 0ms 180 0ms values (?, ?, ?), (?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 19 07 12 0ms 0ms 08 12 0ms 0ms 09 12 0ms 0ms 10 12 0ms 0ms 11 12 0ms 0ms 12 12 0ms 0ms 13 12 0ms 0ms 14 12 0ms 0ms 15 12 0ms 0ms 16 12 0ms 0ms 17 12 0ms 0ms 18 12 0ms 0ms 19 12 0ms 0ms 20 12 0ms 0ms 21 12 0ms 0ms 17 0ms 0ms 0ms 2 0ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select distinct il.m_product_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? || p.name || ? as description, ? as isactive, il.ad_org_id as ad_org_id, il.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, p.m_product_id, ?) as record_id from m_internal_consumptionline il join m_internal_consumption i on i.m_internal_consumption_id = il.m_internal_consumption_id join m_transaction t on il.m_internal_consumptionline_id = t.m_internal_consumptionline_id join m_product p on il.m_product_id = p.m_product_id join m_costing_rule cr on ad_isorgincluded (i.ad_org_id, cr.ad_org_id, i.ad_client_id) >= ? and cr.datefrom <= t.trxprocessdate and cr.dateto > t.trxprocessdate join m_costing_algorithm ca on cr.m_costing_algorithm_id = ca.m_costing_algorithm_id and ca.classname = ? where t.movementqty > ? and not exists ( select ? from m_costing c where c.m_product_id = il.m_product_id and c.costtype in (...) and c.datefrom <= t.trxprocessdate and c.dateto > t.trxprocessdate) and not exists ( select ? from m_productprice pp join m_pricelist_version ppv on pp.m_pricelist_version_id = ppv.m_pricelist_version_id join m_pricelist pl on pl.m_pricelist_id = ppv.m_pricelist_id where pp.m_product_id = il.m_product_id and pl.issopricelist = ? and ppv.validfrom <= t.trxprocessdate)) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 19 15 1 0ms 0ms 21 1 0ms 0ms 18 0ms 0ms 0ms 2 0ms update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select c_invoice_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, c_invoice.ad_org_id as ad_org_id, c_invoice.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id, posted from c_invoice, c_doctype where c_invoice.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype in (...) and not exists ( select ? from c_period where c_period.startdate <= trunc(dateacct) and trunc(dateacct) <= c_period.enddate) group by c_invoice_id, posted, c_invoice.ad_org_id, c_invoice.ad_client_id) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 19 15 1 0ms 0ms 21 1 0ms 0ms 19 0ms 0ms 0ms 30 0ms select ? as id from dual where exists ( select ? from ( select a.paymentdate as dateacct from fin_payment a where a.ad_client_id = ? and a.ad_org_id in (...) and a.posted = ? and a.processed = ? and (a.processing = ? or a.processing is null) and exists ( select ? from c_period p where a.paymentdate >= p.startdate and a.paymentdate < p.enddate + ? and exists ( select ? from c_periodcontrol pc where pc.c_period_id = p.c_period_id and ad_org_getperiodcontrolallow (a.ad_org_id) = pc.ad_org_id and pc.docbasetype = ? and pc.periodstatus = ?))) b where ? = ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 19 08 2 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 18 2 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms 22 2 0ms 0ms 20 0ms 0ms 0ms 540 0ms select count(datid) as current, ( select setting as mc from pg_settings where name = ?) as mc, d.datname from pg_database d left join pg_stat_activity s on (s.datid = d.oid) group by ?, ? order by datname;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 19 07 36 0ms 0ms 08 36 0ms 0ms 09 36 0ms 0ms 10 36 0ms 0ms 11 36 0ms 0ms 12 36 0ms 0ms 13 36 0ms 0ms 14 36 0ms 0ms 15 36 0ms 0ms 16 36 0ms 0ms 17 36 0ms 0ms 18 36 0ms 0ms 19 36 0ms 0ms 20 36 0ms 0ms 21 36 0ms 0ms 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 1 0ms 17 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 19 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 2 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 2 0ms 0ms 22 1 0ms 0ms -
;
Date: Duration: 0ms Database: postgres User: etendo Remote: tad Application: 127.0.0.1 Queryid: openbravo
-
Events
Log levels
Key values
- 211,785 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Events per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET