pgBadger-
Global information
- Generated on Sat Jul 18 23:05:10 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 359,623 log entries in 5m8s
- Log start from 2026-07-18 07:00:01 to 2026-07-18 22:00:00
-
Overview
Global Stats
- 210 Number of unique normalized queries
- 154,883 Number of queries
- 2m9s Total query duration
- 2026-07-18 07:00:01 First query
- 2026-07-18 22:00:00 Last query
- 873 queries/s at 2026-07-18 21:00:00 Query peak
- 2m9s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2m9s 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
- 86 Total number of automatic vacuums
- 112 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
- 23ms Average queries duration per session
- 0ms Average idle time per session
- 5,415 Total number of connections
- 5 connections/s at 2026-07-18 08:00:01 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 873 queries/s Query Peak
- 2026-07-18 21:00:00 Date
SELECT Traffic
Key values
- 224 queries/s Query Peak
- 2026-07-18 21:00:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 45 queries/s Query Peak
- 2026-07-18 21:00:00 Date
Queries duration
Key values
- 2m9s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 18 07 10,886 0ms 753ms 0ms 71ms 88ms 1s138ms 08 10,151 0ms 727ms 0ms 68ms 78ms 1s252ms 09 10,153 0ms 693ms 0ms 66ms 80ms 952ms 10 10,155 0ms 716ms 0ms 65ms 72ms 1s118ms 11 10,214 0ms 696ms 0ms 67ms 70ms 1s35ms 12 10,178 0ms 749ms 0ms 66ms 72ms 1s94ms 13 10,132 0ms 671ms 0ms 67ms 70ms 1s98ms 14 10,153 0ms 667ms 0ms 68ms 72ms 925ms 15 10,663 0ms 12s600ms 4ms 71ms 75ms 45s191ms 16 10,152 0ms 689ms 0ms 74ms 77ms 1s24ms 17 10,153 0ms 689ms 0ms 66ms 73ms 966ms 18 10,153 0ms 694ms 0ms 70ms 72ms 954ms 19 10,279 0ms 717ms 0ms 66ms 70ms 993ms 20 10,157 0ms 689ms 0ms 66ms 68ms 934ms 21 10,667 0ms 12s689ms 3ms 65ms 70ms 31s675ms 22 637 0ms 16ms 0ms 67ms 67ms 67ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 18 07 2,897 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,940 0 0ms 0ms 0ms 0ms 12 2,925 0 0ms 0ms 0ms 0ms 13 2,917 0 0ms 0ms 0ms 0ms 14 2,921 0 0ms 0ms 0ms 0ms 15 2,984 0 0ms 0ms 0ms 0ms 16 2,921 0 0ms 0ms 0ms 0ms 17 2,921 0 0ms 0ms 0ms 0ms 18 2,921 0 0ms 0ms 0ms 0ms 19 2,959 0 0ms 0ms 0ms 0ms 20 2,921 0 0ms 0ms 0ms 0ms 21 2,985 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 18 07 0 46 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 3 0 0 0ms 0ms 0ms 0ms 11 1 1 0 0 0ms 0ms 0ms 0ms 12 2 3 0 0 0ms 0ms 0ms 0ms 13 0 1 0 0 0ms 0ms 0ms 0ms 14 1 2 0 0 0ms 0ms 0ms 0ms 15 2 66 0 0 0ms 0ms 0ms 0ms 16 1 2 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 2 0 0 0ms 0ms 0ms 0ms 20 1 4 0 0 0ms 0ms 0ms 0ms 21 2 66 0 0 0ms 0ms 0ms 0ms 22 2 1 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 18 07 0 3,230 3,230.00 0.00% 08 0 2,992 2,992.00 0.00% 09 0 2,993 2,993.00 0.00% 10 0 2,994 2,994.00 0.00% 11 0 3,013 3,013.00 0.00% 12 0 3,000 3,000.00 0.00% 13 0 2,986 2,986.00 0.00% 14 0 2,993 2,993.00 0.00% 15 0 3,121 3,121.00 0.00% 16 0 2,993 2,993.00 0.00% 17 0 2,993 2,993.00 0.00% 18 0 2,993 2,993.00 0.00% 19 0 3,035 3,035.00 0.00% 20 0 2,995 2,995.00 0.00% 21 0 3,122 3,122.00 0.00% 22 0 212 212.00 0.00% Day Hour Count Average / Second Jul 18 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 18 07 361 22ms 11ms 08 361 22ms 11ms 09 361 21ms 12ms 10 361 21ms 11ms 11 361 21ms 12ms 12 361 22ms 12ms 13 361 21ms 11ms 14 361 21ms 12ms 15 361 21ms 0ms 16 361 21ms 12ms 17 361 21ms 12ms 18 361 21ms 11ms 19 361 21ms 12ms 20 361 22ms 12ms 21 361 22ms 0ms 22 0 0ms 0ms -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-18 08: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
- 3,426 buffers Checkpoint Peak
- 2026-07-18 14:06:52 Date
- 269.546 seconds Highest write time
- 0.003 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-07-18 17:04:28 Date
Checkpoints distance
Key values
- 20.01 Mo Distance Peak
- 2026-07-18 14:06:52 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 18 07 1,129 111.995s 0.018s 112.049s 08 1,191 118.85s 0.003s 118.857s 09 1,173 117.138s 0.002s 117.144s 10 1,197 119.544s 0.002s 119.549s 11 1,022 101.796s 0.002s 101.803s 12 1,134 113.327s 0.002s 113.334s 13 1,027 102.505s 0.002s 102.511s 14 3,426 269.546s 0.002s 269.554s 15 1,245 123.969s 0.004s 123.981s 16 1,337 133.447s 0.003s 133.455s 17 1,247 124.261s 0.002s 124.267s 18 1,142 114.142s 0.002s 114.15s 19 1,060 105.913s 0.002s 105.92s 20 1,163 116.249s 0.002s 116.256s 21 1,056 105.424s 0.002s 105.43s 22 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 18 07 0 1 0 154 0.002s 0.009s 08 0 0 0 126 0.002s 0.001s 09 0 1 0 124 0.002s 0.001s 10 0 0 0 122 0.001s 0.001s 11 0 1 0 125 0.001s 0.001s 12 0 0 0 124 0.002s 0.001s 13 0 1 0 126 0.001s 0.001s 14 0 1 0 129 0.001s 0.001s 15 0 0 0 141 0.002s 0.002s 16 0 1 0 131 0.002s 0.001s 17 0 0 0 129 0.001s 0.001s 18 0 1 0 125 0.002s 0.001s 19 0 1 0 129 0.002s 0.001s 20 0 0 0 126 0.002s 0.001s 21 0 1 0 135 0.001s 0.001s 22 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 18 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s Day Hour Mean distance Mean estimate Jul 18 07 1,095.22 kB 6,571.33 kB 08 9,403.00 kB 9,403.00 kB 09 9,477.00 kB 9,477.00 kB 10 9,469.00 kB 9,476.00 kB 11 9,468.00 kB 9,475.00 kB 12 9,027.00 kB 9,431.00 kB 13 9,496.00 kB 9,496.00 kB 14 10,243.00 kB 10,243.00 kB 15 4,893.00 kB 9,685.50 kB 16 9,830.00 kB 9,830.00 kB 17 9,862.00 kB 9,862.00 kB 18 9,068.00 kB 9,783.00 kB 19 9,442.00 kB 9,749.00 kB 20 9,228.00 kB 9,697.00 kB 21 9,607.00 kB 9,688.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-18 15:30:17 Date
Number of temporary files
Key values
- 3 per second Temp Files Peak
- 2026-07-18 15:30:17 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 18 07 0 0 0 08 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 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-18 15:30:17 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
2 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-18 15:30:17 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-18 15:30:42 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-18 15:30:17 - 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-18 21:00:02 - 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-18 15:30:44 - 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-18 21:00:30 - 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-18 15:30:17 - 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-18 21:00:03 - 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-18 15:30:30 - 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-18 15:30:42 - 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-18 21:00:15 - 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-18 21:00:28 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.37 sec Highest CPU-cost vacuum
Table profile.sample_stat_tables
Database etendo - 2026-07-18 14:00:32 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 0.37 sec Highest CPU-cost vacuum
Table profile.sample_stat_tables
Database etendo - 2026-07-18 14:00:32 Date
Analyzes per table
Key values
- profile.last_stat_user_functions_srv1 (15) Main table analyzed (database etendo)
- 112 analyzes Total
Table Number of analyzes etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.last_stat_indexes_srv1 15 etendo.profile.last_stat_statements_srv1 15 etendo.profile.last_stat_tables_srv1 15 etendo.profile.last_stat_io 8 etendo.profile.tables_list 8 etendo.profile.last_stat_activity_count_srv1 4 etendo.profile.last_extension_versions 4 etendo.profile.last_stat_slru 3 etendo.profile.stmt_list 2 etendo.profile.sample_stat_io 2 etendo.profile.sample_stat_user_functions 2 etendo.profile.indexes_list 2 etendo.profile.sample_statements 2 etendo.profile.sample_stat_tables_total 1 etendo.profile.sample_stat_tablespaces 1 etendo.public.ad_session 1 etendo.profile.sample_stat_wal 1 etendo.profile.sample_stat_database 1 etendo.profile.samples 1 etendo.profile.sample_stat_archiver 1 etendo.profile.sample_stat_cluster 1 etendo.profile.sample_stat_indexes_total 1 etendo.profile.sample_stat_user_func_total 1 etendo.profile.sample_statements_total 1 etendo.profile.sample_stat_tables 1 etendo.profile.sample_stat_slru 1 etendo.profile.funcs_list 1 etendo.profile.sample_stat_indexes 1 Total 112 Vacuums per table
Key values
- profile.last_stat_indexes_srv1 (15) Main table vacuumed on database etendo
- 86 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_indexes_srv1 15 15 15,954 0 270 0 0 11,222 285 1,805,689 0 0 etendo.profile.last_stat_tables_srv1 15 15 12,221 0 170 0 0 8,894 172 1,244,990 0 0 etendo.profile.last_stat_user_functions_srv1 15 15 2,144 0 41 0 0 1,109 33 242,215 0 0 etendo.profile.last_stat_statements_srv1 15 15 4,294 0 50 0 0 2,145 59 416,677 0 0 etendo.profile.tables_list 5 5 743 0 21 0 0 396 12 110,986 0 0 etendo.profile.last_stat_activity_count_srv1 3 0 63 0 15 0 0 18 6 29,832 0 0 etendo.profile.last_stat_io 3 3 249 0 15 0 0 28 7 51,313 0 0 etendo.profile.last_extension_versions 3 3 156 0 15 0 0 15 6 50,298 0 0 etendo.profile.stmt_list 2 2 552 0 42 0 0 298 41 259,985 12 40 etendo.profile.sample_stat_tables 1 1 3,326 0 1,364 0 0 1,826 276 557,738 0 0 etendo.profile.sample_stat_user_functions 1 1 307 0 94 0 0 144 27 103,390 0 0 etendo.profile.last_stat_slru 1 1 70 0 5 0 0 5 2 16,784 0 0 etendo.profile.funcs_list 1 1 88 0 2 0 0 27 1 10,484 0 0 etendo.profile.sample_statements 1 1 1,752 0 703 0 0 1,001 138 242,859 0 0 etendo.profile.sample_stat_indexes 1 1 551 0 187 0 0 273 45 129,125 0 0 etendo.profile.indexes_list 1 1 123 0 2 0 0 33 1 11,042 0 0 etendo.profile.last_stat_database_srv1 1 1 50 0 2 0 0 6 2 11,734 0 0 etendo.pg_toast.pg_toast_2619 1 1 429 0 104 0 0 309 92 174,872 10 21 etendo.profile.sample_stat_tables_total 1 1 197 0 52 0 0 75 16 55,594 0 0 Total 86 83 43,269 194 3,154 0 0 27,824 1,221 5,525,607 22 61 Vacuum throughput per table
Key values
- profile.sample_stat_tables (0.37) 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_indexes_srv1 0 0 0.17 etendo.profile.last_stat_tables_srv1 0 0 0.16 etendo.profile.last_stat_user_functions_srv1 0 0 0 etendo.profile.last_stat_statements_srv1 0 0 0.01 etendo.profile.tables_list 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.last_stat_io 0 0 0.02 etendo.profile.last_extension_versions 0 0 0 etendo.profile.stmt_list 0 0 0 etendo.profile.sample_stat_tables 0 0 0.37 etendo.profile.sample_stat_user_functions 0 0 0.05 etendo.profile.last_stat_slru 0 0 0 etendo.profile.funcs_list 0 0 0 etendo.profile.sample_statements 0 0 0.2 etendo.profile.sample_stat_indexes 0 0 0.07 etendo.profile.indexes_list 0 0 0 etendo.profile.last_stat_database_srv1 0 0 0 etendo.pg_toast.pg_toast_2619 0 0 0.02 etendo.profile.sample_stat_tables_total 0 0 0.03 Total 0 0 1.1 Tuples removed per table
Key values
- profile.last_stat_indexes_srv1 (70571) Main table with removed tuples on database etendo
- 135098 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,571 34,935 0 566 3,731 etendo.profile.last_stat_tables_srv1 15 15 44,518 20,880 0 364 3,052 etendo.profile.last_stat_statements_srv1 15 15 7,008 5,160 0 31 647 etendo.profile.last_stat_user_functions_srv1 15 15 5,109 4,605 0 7 323 etendo.profile.sample_stat_tables 1 1 2,106 31,988 0 0 1,330 etendo.profile.sample_statements 1 1 2,063 11,343 0 0 685 etendo.profile.sample_stat_user_functions 1 1 960 7,090 0 0 81 etendo.profile.sample_stat_indexes 1 1 846 8,754 0 0 169 etendo.profile.tables_list 5 5 632 4,040 0 0 120 etendo.pg_toast.pg_toast_2619 1 1 290 1,257 0 0 454 etendo.profile.sample_stat_tables_total 1 1 272 1,344 0 0 44 etendo.profile.last_stat_io 3 3 169 39 0 2 4 etendo.profile.last_extension_versions 3 3 168 24 0 0 3 etendo.profile.stmt_list 2 2 137 1,395 0 0 148 etendo.profile.last_stat_activity_count_srv1 3 0 72 0 0 3 0 etendo.profile.indexes_list 1 1 62 332 0 0 10 etendo.profile.funcs_list 1 1 56 171 0 0 8 etendo.profile.last_stat_slru 1 1 55 5 0 0 1 etendo.profile.last_stat_database_srv1 1 1 4 4 0 0 1 Total 86 83 135,098 133,366 0 973 10,811 Pages removed per table
Key values
- profile.last_stat_indexes_srv1 (566) Main table with removed pages on database etendo
- 973 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed etendo.profile.last_stat_indexes_srv1 15 15 70571 566 etendo.profile.last_stat_tables_srv1 15 15 44518 364 etendo.profile.last_stat_statements_srv1 15 15 7008 31 etendo.profile.last_stat_user_functions_srv1 15 15 5109 7 etendo.profile.last_stat_activity_count_srv1 3 0 72 3 etendo.profile.last_stat_io 3 3 169 2 etendo.profile.sample_stat_tables 1 1 2106 0 etendo.profile.sample_stat_user_functions 1 1 960 0 etendo.profile.last_stat_slru 1 1 55 0 etendo.profile.tables_list 5 5 632 0 etendo.profile.funcs_list 1 1 56 0 etendo.profile.sample_statements 1 1 2063 0 etendo.profile.sample_stat_indexes 1 1 846 0 etendo.profile.indexes_list 1 1 62 0 etendo.profile.last_stat_database_srv1 1 1 4 0 etendo.profile.last_extension_versions 3 3 168 0 etendo.pg_toast.pg_toast_2619 1 1 290 0 etendo.profile.sample_stat_tables_total 1 1 272 0 etendo.profile.stmt_list 2 2 137 0 Total 86 83 135,098 973 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 18 07 6 11 08 5 5 09 6 7 10 4 7 11 5 8 12 6 4 13 5 12 14 9 4 15 5 11 16 7 6 17 5 8 18 6 4 19 5 10 20 6 4 21 6 11 22 0 0 - 0.37 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,177 Total read queries
- 6,183 Total write queries
Queries by database
Key values
- etendo Main database
- 146,303 Requests
- 2m4s (etendo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 145,223 Requests
User Request type Count Duration postgres Total 9,660 17s108ms others 2,835 0ms select 1,905 0ms tcl 90 0ms tad Total 145,223 1m51s insert 18 0ms others 480 0ms select 42,272 0ms tcl 5,871 0ms update 204 0ms Duration by user
Key values
- 1m51s (tad) Main time consuming user
User Request type Count Duration postgres Total 9,660 17s108ms others 2,835 0ms select 1,905 0ms tcl 90 0ms tad Total 145,223 1m51s insert 18 0ms others 480 0ms select 42,272 0ms tcl 5,871 0ms update 204 0ms Queries by host
Key values
- 127.0.0.1 Main host
- 145,223 Requests
- 1m51s (127.0.0.1)
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 138,863 Requests
- 1m36s (openbravo)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-18 09:19:48 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 93,133 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 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.suspenseerror_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 #1
Day Hour Count Duration Avg duration Jul 18 15 2 0ms 0ms 21 2 0ms 0ms 2 0ms 1,804 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 #2
Day Hour Count Duration Avg duration Jul 18 07 121 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 121 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 120 0ms 0ms 3 0ms 16 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 in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 18 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 2 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 4 0ms 30 0ms 0ms 0ms select st.relid, st.indexrelid, st.schemaname, st.relname, st.indexrelname, st.idx_scan, st.last_idx_scan, st.idx_tup_read, st.idx_tup_fetch, stio.idx_blks_read, stio.idx_blks_hit, null relsize, ?, pg_class.reltablespace as tablespaceid, (ix.indisunique or con.conindid is not null) as indisunique, pg_class.relpages::bigint * current_setting(?)::bigint as relpages_bytes, ? as relpages_bytes_diff, to_jsonb (pg_class.reloptions) from pg_catalog.pg_stat_all_indexes st join pg_catalog.pg_statio_all_indexes stio using (relid, indexrelid, schemaname, relname, indexrelname) join pg_catalog.pg_index ix on (ix.indexrelid = st.indexrelid) join pg_catalog.pg_class on (pg_class.oid = st.indexrelid) left outer join pg_catalog.pg_constraint con on (con.conrelid, con.conindid) = (ix.indrelid, ix.indexrelid) and con.contype in (...);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 18 07 2 0ms 0ms 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 5 0ms 16 0ms 0ms 0ms select adclient0_.ad_client_id as ad_clien1_18_, adclient0_.ad_org_id as ad_org_i2_18_, adclient0_.isactive as isactive3_18_, adclient0_.created as created4_18_, adclient0_.createdby as createdb5_18_, adclient0_.updated as updated6_18_, adclient0_.updatedby as updatedb7_18_, adclient0_.value as value8_18_, adclient0_.name as name9_18_, adclient0_.description as descrip10_18_, adclient0_.smtphost as smtphos11_18_, adclient0_.requestemail as request12_18_, adclient0_.requestuser as request13_18_, adclient0_.requestuserpw as request14_18_, adclient0_.requestfolder as request15_18_, adclient0_.ad_language as ad_lang16_18_, adclient0_.ismultilingualdocument as ismulti17_18_, adclient0_.issmtpauthorization as issmtpa18_18_, adclient0_.c_currency_id as c_curre19_18_, adclient0_.acctdim_centrally_maintained as acctdim20_18_, adclient0_.project_acctdim_isenable as project21_18_, adclient0_.project_acctdim_header as project22_18_, adclient0_.project_acctdim_lines as project23_18_, adclient0_.project_acctdim_breakdown as project24_18_, adclient0_.bpartner_acctdim_isenable as bpartne25_18_, adclient0_.bpartner_acctdim_header as bpartne26_18_, adclient0_.bpartner_acctdim_lines as bpartne27_18_, adclient0_.bpartner_acctdim_breakdown as bpartne28_18_, adclient0_.product_acctdim_isenable as product29_18_, adclient0_.product_acctdim_header as product30_18_, adclient0_.product_acctdim_lines as product31_18_, adclient0_.product_acctdim_breakdown as product32_18_, adclient0_.costcenter_acctdim_header as costcen33_18_, adclient0_.costcenter_acctdim_lines as costcen34_18_, adclient0_.costcenter_acctdim_breakdown as costcen35_18_, adclient0_.user1_acctdim_isenable as user36_18_, adclient0_.user1_acctdim_header as user37_18_, adclient0_.user1_acctdim_lines as user38_18_, adclient0_.user1_acctdim_breakdown as user39_18_, adclient0_.user2_acctdim_isenable as user40_18_, adclient0_.user2_acctdim_header as user41_18_, adclient0_.user2_acctdim_lines as user42_18_, adclient0_.user2_acctdim_breakdown as user43_18_, adclient0_.costcenter_acctdim_isenable as costcen44_18_, adclient0_.org_acctdim_isenable as org_acc45_18_, adclient0_.org_acctdim_header as org_acc46_18_, adclient0_.org_acctdim_lines as org_acc47_18_, adclient0_.org_acctdim_breakdown as org_acc48_18_, adclient0_.daystopasswordexpiration as daystop49_18_ from ad_client adclient0_ where adclient0_.ad_client_id = ? limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 18 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 6 0ms 2 0ms 0ms 0ms select * from ( select c_glitem_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_glitem_id, ?) as record_id from c_glitem gli 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, gli.ad_org_id, gli.ad_client_id) <> ? or ad_isorgincluded (gli.ad_org_id, ad_org_id, gli.ad_client_id) <> ?) and isactive = ? and ad_org_acctschema.c_acctschema_id = d.c_acctschema_id and ad_org_acctschema.ad_client_id = gli.ad_client_id) and not exists ( select glia.c_acctschema_id from c_glitem_acct glia where glia.c_glitem_id = gli.c_glitem_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 #6
Day Hour Count Duration Avg duration Jul 18 15 1 0ms 0ms 21 1 0ms 0ms 7 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_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 m_product p on iol.m_product_id = p.m_product_id 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 not exists ( select ? from m_matchpo mp where mp.m_inoutline_id = iol.m_inoutline_id and mp.c_orderline_id is not null) 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) and not exists ( select ? from c_orderline ol join c_order o on ol.c_order_id = o.c_order_id and o.issotrx = ? and o.processed = ? where ol.m_product_id = iol.m_product_id and o.c_bpartner_id = bp.c_bpartner_id and ad_isorgincluded (o.ad_org_id, cr.ad_org_id, io.ad_client_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 #7
Day Hour Count Duration Avg duration Jul 18 15 1 0ms 0ms 21 1 0ms 0ms 8 0ms 15 0ms 0ms 0ms select count(?) as pgpro_fxs from pg_catalog.pg_settings where name in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 18 07 1 0ms 0ms 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 9 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 i.c_invoice_id as referencekey_id, i.documentno as record_id, ? as ad_role_id, null as ad_user_id, ? || i.documentno || ? as description, ? as isactive, i.ad_client_id, i.ad_org_id, now() as created, ? as createdby, now() as updated, ? as updatedby from c_invoice i left join c_doctype d on i.c_doctype_id = d.c_doctype_id where i.docstatus = ? and d.isreversal = ? and i.grandtotal < ?) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 18 15 1 0ms 0ms 21 1 0ms 0ms 10 0ms 2 0ms 0ms 0ms select * from ( select t.c_tax_id as referencekey_id, t.name as record_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ? as ad_org_id, t.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from c_tax t join ad_ref_data_loaded tm on (t.c_tax_id = tm.specific_id) join fact_acct f on (f.c_tax_id = tm.specific_id) where tm.generic_id in (...)) 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 #10
Day Hour Count Duration Avg duration Jul 18 15 1 0ms 0ms 21 1 0ms 0ms 11 0ms 2 0ms 0ms 0ms select * from ( select gl_journal_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 (?, gl_journal_id, ?) as record_id, posted from gl_journal where not exists ( select ? from c_period where c_period.startdate <= trunc(dateacct) and trunc(dateacct) <= c_period.enddate) group by gl_journal_id, posted, ad_client_id, 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 #11
Day Hour Count Duration Avg duration Jul 18 15 1 0ms 0ms 21 1 0ms 0ms 12 0ms 18 0ms 0ms 0ms update ad_process_request set updatedby = ?, ad_user_id = ?, status = ?, channel = ?, previous_fire_time = to_timestamp(?, ?), next_fire_time = to_timestamp(?, ?), scheduled_finish = to_timestamp(null, ?), ob_context = ?, updated = now() where ad_process_request_id = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 18 07 1 0ms 0ms 09 1 0ms 0ms 10 2 0ms 0ms 12 2 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 3 0ms 0ms 21 2 0ms 0ms 13 0ms 15 0ms 0ms 0ms select ? as id from dual where exists ( select ? from ( select a.dateacct as dateacct from a_amortization 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 #13
Day Hour Count Duration Avg duration Jul 18 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 14 0ms 15 0ms 0ms 0ms select count(*) as exist from dual where exists ( select ? from ad_preference where attribute = ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 18 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 15 0ms 1,804 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 #15
Day Hour Count Duration Avg duration Jul 18 07 121 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 121 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 120 0ms 0ms 16 0ms 6 0ms 0ms 0ms 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 = ? group by fact_acct_group_id, record_id, ad_client_id, ad_org_id having sum(amtacctcr - amtacctdr) <> ?) 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 #16
Day Hour Count Duration Avg duration Jul 18 15 3 0ms 0ms 21 3 0ms 0ms 17 0ms 540 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 #17
Day Hour Count Duration Avg duration Jul 18 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 18 0ms 15 0ms 0ms 0ms select ? as id from dual where exists ( select ? from ( select a.dateacct as dateacct from fin_doubtful_debt 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 #18
Day Hour Count Duration Avg duration Jul 18 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 19 0ms 3 0ms 0ms 0ms select admodule0_.ad_module_id as col_0_0_, admodule0_.javapackage as col_1_0_, admodule0_.name as col_2_0_, admodule0_.version as col_3_0_, admodule0_.version_label as col_4_0_ from ad_module admodule0_ order by admodule0_.javapackage;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 18 22 3 0ms 0ms 20 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 #20
Day Hour Count Duration Avg duration Jul 18 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 Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 21,783 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 18 07 1,452 0ms 0ms 08 1,449 0ms 0ms 09 1,449 0ms 0ms 10 1,449 0ms 0ms 11 1,461 0ms 0ms 12 1,449 0ms 0ms 13 1,449 0ms 0ms 14 1,449 0ms 0ms 15 1,449 0ms 0ms 16 1,449 0ms 0ms 17 1,449 0ms 0ms 18 1,449 0ms 0ms 19 1,473 0ms 0ms 20 1,449 0ms 0ms 21 1,449 0ms 0ms 22 9 0ms 0ms 2 2,980 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 18 07 300 0ms 0ms 08 191 0ms 0ms 09 191 0ms 0ms 10 191 0ms 0ms 11 192 0ms 0ms 12 191 0ms 0ms 13 191 0ms 0ms 14 191 0ms 0ms 15 191 0ms 0ms 16 191 0ms 0ms 17 191 0ms 0ms 18 191 0ms 0ms 19 193 0ms 0ms 20 191 0ms 0ms 21 191 0ms 0ms 22 3 0ms 0ms 3 2,936 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 18 07 297 0ms 0ms 08 188 0ms 0ms 09 188 0ms 0ms 10 188 0ms 0ms 11 189 0ms 0ms 12 189 0ms 0ms 13 187 0ms 0ms 14 188 0ms 0ms 15 188 0ms 0ms 16 188 0ms 0ms 17 188 0ms 0ms 18 188 0ms 0ms 19 190 0ms 0ms 20 188 0ms 0ms 21 188 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 18 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,836 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 18 07 121 0ms 0ms 08 122 0ms 0ms 09 122 0ms 0ms 10 122 0ms 0ms 11 123 0ms 0ms 12 124 0ms 0ms 13 120 0ms 0ms 14 122 0ms 0ms 15 122 0ms 0ms 16 122 0ms 0ms 17 122 0ms 0ms 18 122 0ms 0ms 19 124 0ms 0ms 20 122 0ms 0ms 21 122 0ms 0ms 22 4 0ms 0ms 6 1,810 0ms 0ms 0ms 0ms select ? from dual;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 18 07 127 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 120 0ms 0ms 20 120 0ms 0ms 21 121 0ms 0ms 22 2 0ms 0ms 7 1,804 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 #7
Day Hour Count Duration Avg duration Jul 18 07 121 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 121 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 120 0ms 0ms 8 1,804 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 #8
Day Hour Count Duration Avg duration Jul 18 07 121 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 121 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 120 0ms 0ms 9 1,804 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 #9
Day Hour Count Duration Avg duration Jul 18 07 121 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 121 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 120 0ms 0ms 10 1,804 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 #10
Day Hour Count Duration Avg duration Jul 18 07 121 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 121 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 120 0ms 0ms 11 1,804 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 #11
Day Hour Count Duration Avg duration Jul 18 07 121 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 121 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 120 0ms 0ms 12 1,804 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 #12
Day Hour Count Duration Avg duration Jul 18 07 121 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 121 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 120 0ms 0ms 13 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 #13
Day Hour Count Duration Avg duration Jul 18 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 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 18 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 version();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 18 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 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 18 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 18 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 18 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 18 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 18 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 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.suspenseerror_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 #1
Day Hour Count Duration Avg duration Jul 18 15 2 0ms 0ms 21 2 0ms 0ms 2 0ms 0ms 0ms 1,804 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 #2
Day Hour Count Duration Avg duration Jul 18 07 121 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 121 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 120 0ms 0ms 3 0ms 0ms 0ms 16 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 in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 18 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 2 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 4 0ms 0ms 0ms 30 0ms select st.relid, st.indexrelid, st.schemaname, st.relname, st.indexrelname, st.idx_scan, st.last_idx_scan, st.idx_tup_read, st.idx_tup_fetch, stio.idx_blks_read, stio.idx_blks_hit, null relsize, ?, pg_class.reltablespace as tablespaceid, (ix.indisunique or con.conindid is not null) as indisunique, pg_class.relpages::bigint * current_setting(?)::bigint as relpages_bytes, ? as relpages_bytes_diff, to_jsonb (pg_class.reloptions) from pg_catalog.pg_stat_all_indexes st join pg_catalog.pg_statio_all_indexes stio using (relid, indexrelid, schemaname, relname, indexrelname) join pg_catalog.pg_index ix on (ix.indexrelid = st.indexrelid) join pg_catalog.pg_class on (pg_class.oid = st.indexrelid) left outer join pg_catalog.pg_constraint con on (con.conrelid, con.conindid) = (ix.indrelid, ix.indexrelid) and con.contype in (...);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 18 07 2 0ms 0ms 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 5 0ms 0ms 0ms 16 0ms select adclient0_.ad_client_id as ad_clien1_18_, adclient0_.ad_org_id as ad_org_i2_18_, adclient0_.isactive as isactive3_18_, adclient0_.created as created4_18_, adclient0_.createdby as createdb5_18_, adclient0_.updated as updated6_18_, adclient0_.updatedby as updatedb7_18_, adclient0_.value as value8_18_, adclient0_.name as name9_18_, adclient0_.description as descrip10_18_, adclient0_.smtphost as smtphos11_18_, adclient0_.requestemail as request12_18_, adclient0_.requestuser as request13_18_, adclient0_.requestuserpw as request14_18_, adclient0_.requestfolder as request15_18_, adclient0_.ad_language as ad_lang16_18_, adclient0_.ismultilingualdocument as ismulti17_18_, adclient0_.issmtpauthorization as issmtpa18_18_, adclient0_.c_currency_id as c_curre19_18_, adclient0_.acctdim_centrally_maintained as acctdim20_18_, adclient0_.project_acctdim_isenable as project21_18_, adclient0_.project_acctdim_header as project22_18_, adclient0_.project_acctdim_lines as project23_18_, adclient0_.project_acctdim_breakdown as project24_18_, adclient0_.bpartner_acctdim_isenable as bpartne25_18_, adclient0_.bpartner_acctdim_header as bpartne26_18_, adclient0_.bpartner_acctdim_lines as bpartne27_18_, adclient0_.bpartner_acctdim_breakdown as bpartne28_18_, adclient0_.product_acctdim_isenable as product29_18_, adclient0_.product_acctdim_header as product30_18_, adclient0_.product_acctdim_lines as product31_18_, adclient0_.product_acctdim_breakdown as product32_18_, adclient0_.costcenter_acctdim_header as costcen33_18_, adclient0_.costcenter_acctdim_lines as costcen34_18_, adclient0_.costcenter_acctdim_breakdown as costcen35_18_, adclient0_.user1_acctdim_isenable as user36_18_, adclient0_.user1_acctdim_header as user37_18_, adclient0_.user1_acctdim_lines as user38_18_, adclient0_.user1_acctdim_breakdown as user39_18_, adclient0_.user2_acctdim_isenable as user40_18_, adclient0_.user2_acctdim_header as user41_18_, adclient0_.user2_acctdim_lines as user42_18_, adclient0_.user2_acctdim_breakdown as user43_18_, adclient0_.costcenter_acctdim_isenable as costcen44_18_, adclient0_.org_acctdim_isenable as org_acc45_18_, adclient0_.org_acctdim_header as org_acc46_18_, adclient0_.org_acctdim_lines as org_acc47_18_, adclient0_.org_acctdim_breakdown as org_acc48_18_, adclient0_.daystopasswordexpiration as daystop49_18_ from ad_client adclient0_ where adclient0_.ad_client_id = ? limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 18 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 6 0ms 0ms 0ms 2 0ms select * from ( select c_glitem_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_glitem_id, ?) as record_id from c_glitem gli 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, gli.ad_org_id, gli.ad_client_id) <> ? or ad_isorgincluded (gli.ad_org_id, ad_org_id, gli.ad_client_id) <> ?) and isactive = ? and ad_org_acctschema.c_acctschema_id = d.c_acctschema_id and ad_org_acctschema.ad_client_id = gli.ad_client_id) and not exists ( select glia.c_acctschema_id from c_glitem_acct glia where glia.c_glitem_id = gli.c_glitem_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 #6
Day Hour Count Duration Avg duration Jul 18 15 1 0ms 0ms 21 1 0ms 0ms 7 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_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 m_product p on iol.m_product_id = p.m_product_id 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 not exists ( select ? from m_matchpo mp where mp.m_inoutline_id = iol.m_inoutline_id and mp.c_orderline_id is not null) 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) and not exists ( select ? from c_orderline ol join c_order o on ol.c_order_id = o.c_order_id and o.issotrx = ? and o.processed = ? where ol.m_product_id = iol.m_product_id and o.c_bpartner_id = bp.c_bpartner_id and ad_isorgincluded (o.ad_org_id, cr.ad_org_id, io.ad_client_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 #7
Day Hour Count Duration Avg duration Jul 18 15 1 0ms 0ms 21 1 0ms 0ms 8 0ms 0ms 0ms 15 0ms select count(?) as pgpro_fxs from pg_catalog.pg_settings where name in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 18 07 1 0ms 0ms 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 9 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 i.c_invoice_id as referencekey_id, i.documentno as record_id, ? as ad_role_id, null as ad_user_id, ? || i.documentno || ? as description, ? as isactive, i.ad_client_id, i.ad_org_id, now() as created, ? as createdby, now() as updated, ? as updatedby from c_invoice i left join c_doctype d on i.c_doctype_id = d.c_doctype_id where i.docstatus = ? and d.isreversal = ? and i.grandtotal < ?) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 18 15 1 0ms 0ms 21 1 0ms 0ms 10 0ms 0ms 0ms 2 0ms select * from ( select t.c_tax_id as referencekey_id, t.name as record_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ? as ad_org_id, t.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby from c_tax t join ad_ref_data_loaded tm on (t.c_tax_id = tm.specific_id) join fact_acct f on (f.c_tax_id = tm.specific_id) where tm.generic_id in (...)) 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 #10
Day Hour Count Duration Avg duration Jul 18 15 1 0ms 0ms 21 1 0ms 0ms 11 0ms 0ms 0ms 2 0ms select * from ( select gl_journal_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 (?, gl_journal_id, ?) as record_id, posted from gl_journal where not exists ( select ? from c_period where c_period.startdate <= trunc(dateacct) and trunc(dateacct) <= c_period.enddate) group by gl_journal_id, posted, ad_client_id, 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 #11
Day Hour Count Duration Avg duration Jul 18 15 1 0ms 0ms 21 1 0ms 0ms 12 0ms 0ms 0ms 18 0ms update ad_process_request set updatedby = ?, ad_user_id = ?, status = ?, channel = ?, previous_fire_time = to_timestamp(?, ?), next_fire_time = to_timestamp(?, ?), scheduled_finish = to_timestamp(null, ?), ob_context = ?, updated = now() where ad_process_request_id = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 18 07 1 0ms 0ms 09 1 0ms 0ms 10 2 0ms 0ms 12 2 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 3 0ms 0ms 21 2 0ms 0ms 13 0ms 0ms 0ms 15 0ms select ? as id from dual where exists ( select ? from ( select a.dateacct as dateacct from a_amortization 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 #13
Day Hour Count Duration Avg duration Jul 18 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 14 0ms 0ms 0ms 15 0ms select count(*) as exist from dual where exists ( select ? from ad_preference where attribute = ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 18 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 15 0ms 0ms 0ms 1,804 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 #15
Day Hour Count Duration Avg duration Jul 18 07 121 0ms 0ms 08 120 0ms 0ms 09 120 0ms 0ms 10 120 0ms 0ms 11 121 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 120 0ms 0ms 16 0ms 0ms 0ms 6 0ms 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 = ? group by fact_acct_group_id, record_id, ad_client_id, ad_org_id having sum(amtacctcr - amtacctdr) <> ?) 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 #16
Day Hour Count Duration Avg duration Jul 18 15 3 0ms 0ms 21 3 0ms 0ms 17 0ms 0ms 0ms 540 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 #17
Day Hour Count Duration Avg duration Jul 18 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 18 0ms 0ms 0ms 15 0ms select ? as id from dual where exists ( select ? from ( select a.dateacct as dateacct from fin_doubtful_debt 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 #18
Day Hour Count Duration Avg duration Jul 18 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 19 0ms 0ms 0ms 3 0ms select admodule0_.ad_module_id as col_0_0_, admodule0_.javapackage as col_1_0_, admodule0_.name as col_2_0_, admodule0_.version as col_3_0_, admodule0_.version_label as col_4_0_ from ad_module admodule0_ order by admodule0_.javapackage;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 18 22 3 0ms 0ms 20 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 #20
Day Hour Count Duration Avg duration Jul 18 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 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 18 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
- 212,951 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